All Forums | Systems & Strategies

RPI Chase Picks and Tracking Spreadsheet

...

Participants:

Posts: 100

hansivonmueller

Veteran

Joined: Apr, 2007

Posts: 1908

Posted: Jul. 7, 2012 - 11:32 PM ET #76

Did the download, but says it is a read only doc. Can't see a message about enabling. Not to worry, people are pretty good at posting the plays. Nice spreadsheet though.

CanisMajor

Prospect

Joined: Jan, 2012

Posts: 185

Posted: Jul. 23, 2012 - 12:16 PM ET #77

If anyone has the RPI and Standings history for July 22nd, please contact me. I am missing that day and would like to get it so I can have and post complete history from 4/30 to current.

Thanks.

Canis

neilsy25

Rookie

Joined: Oct, 2008

Posts: 818

Posted: Jul. 27, 2012 - 1:11 PM ET #78

Canis

I am sending you a friend request, I have a query that I was wondering if you could run using NBA data..I tried with my limited excel knowledge..but failed miserably !..thanks

housebusta

Prospect

Joined: Mar, 2013

Posts: 0

Posted: Mar. 21, 2013 - 3:42 AM ET #79

Bummer I'm a year late from finding this. I noticed the link is gone anything current for this year?? I know its going to take a month or so to gather up any worthwhile stats but just checking:)

luckywayne001

Prospect

Joined: Apr, 2013

Posts: 5

Posted: Apr. 21, 2013 - 2:00 AM ET #80

Canis,

can you post the latest version of BTW RPI spreadsheet. I have version 2 from Degen and the Standings tab does not update for this year. i spent all day fixing the schedule and now having issues with it updating the standings. If you can't post it can you please PM and tell me how I might be able to aquire the latest version. Thanks

luckywayne001

Prospect

Joined: Apr, 2013

Posts: 5

Posted: Apr. 21, 2013 - 10:43 AM ET #81

Canis

I am sending you a friend request. I was hoping we could all get the BTW RPI Spreadsheet going this year. I have the schedule completed in the correct format with all the A/B/C games. Thanks

Bradbrayan

Prospect

Joined: Aug, 2012

Posts: 22

Posted: Apr. 24, 2013 - 9:30 AM ET #82

Quote Originally Posted by luckywayne001:

Canis

I am sending you a friend request. I was hoping we could all get the BTW RPI Spreadsheet going this year. I have the schedule completed in the correct format with all the A/B/C games. Thanks

PLEASE send it to me IF NOT HASSLE THE MAIL
I have the sheet bradbrayan556@hotmail.com 2012 and need updating

DegenGamble

Veteran

Joined: Oct, 2011

Posts: 1150

Posted: Apr. 25, 2013 - 12:00 PM ET #83

2013 B2W's RPI SYSTEM

The much awaited NEW and IMPROVED B2W RPI system spreadsheet.

Here is the link:

https://docs.google.com/file/d/0B5dydT9Oe6Jbcm5zdjBpcURHT1k/edit?usp=sharing

Features:

· Added Sagarin Rankings, Starting Pitchers, Current Odds

· Added ability to Refresh Odds, and Add Bets to Bet Tracker

· You can download from the link above:

b_rad_1983

Rookie

Joined: Dec, 2011

Posts: 553

Posted: Jun. 30, 2013 - 9:38 AM ET #84

Great Work on this! Thanks

Is there anything for NHL?

b_rad_1983

Rookie

Joined: Dec, 2011

Posts: 553

Posted: Jul. 1, 2013 - 12:26 PM ET #85

im trying this out and getting an error when I update.

"run time error '1004'

DegenGamble

Veteran

Joined: Oct, 2011

Posts: 1150

Posted: Jul. 1, 2013 - 1:34 PM ET #86

Quote Originally Posted by b_rad_1983:

im trying this out and getting an error when I update.

"run time error '1004'

Run-time error '1004': Application-defined or object-defined error usually means you have an undefined variable. Look at what line of code there is an issue. When the error comes up their is usually a "debug" option that highlights the line of code that failed. 9 times out of 10 there is a variable in that line or a line right before it that is using a variable that is not defined.

That is if you are messing around with the spreadsheet - if not just download a clean recent version and try it again. I ran the RPI spreadheet today with no issues

literato

Prospect

Joined: Jun, 2013

Posts: 41

Posted: Jul. 1, 2013 - 1:38 PM ET #87

hello I'm not an expert in macro but I think your problem is importing the web page pitchers

Danrules24

Captain

Joined: May, 2012

Posts: 5921

Posted: Jul. 1, 2013 - 1:45 PM ET #88

I had an issue too, but downloaded a new one and it ran perfectly. Thanks Degen.

Stay disciplined and manage your bankroll

BuckeyeKaptn

Veteran

Joined: Jan, 2013

Posts: 1447

Posted: Jul. 1, 2013 - 4:36 PM ET #89

I was having issues too. I just closed them without saving and then reopened them and it worked fine

b_rad_1983

Rookie

Joined: Dec, 2011

Posts: 553

Posted: Jul. 1, 2013 - 5:03 PM ET #90

i found a couple hours later it worked fine for me. The site it grabbed the data from maybe was updating...

Keep up the good work!

b_rad_1983

Rookie

Joined: Dec, 2011

Posts: 553

Posted: Jul. 2, 2013 - 1:31 AM ET #91

Normally i need to click on the yellow boxes so its not read only.. Tonight I went to check it out and it never popped up, also all my formulas were not working...what causes this? or whats the fix?

BuckeyeKaptn

Veteran

Joined: Jan, 2013

Posts: 1447

Posted: Jul. 2, 2013 - 6:49 AM ET #92

Quote Originally Posted by b_rad_1983:

Normally i need to click on the yellow boxes so its not read only.. Tonight I went to check it out and it never popped up, also all my formulas were not working...what causes this? or whats the fix?

You should only need to do that when you first download a spreadsheet. Dunno about the formulas.

TheGovernor11

Prospect

Joined: Jun, 2011

Posts: 33

Posted: Jul. 2, 2013 - 7:49 AM ET #93

The site "DonBest" is the problem and this is where the pitching data is coming from. The website isn't showing any data so it's breaking the formula that is calling on the pitching stats. I just erased the code refreshing the pitching data. Crude solution but it works.

DegenGamble

Veteran

Joined: Oct, 2011

Posts: 1150

Posted: Jul. 2, 2013 - 9:46 AM ET #94

Quote Originally Posted by TheGovernor11:

The site "DonBest" is the problem and this is where the pitching data is coming from. The website isn't showing any data so it's breaking the formula that is calling on the pitching stats. I just erased the code refreshing the pitching data. Crude solution but it works.

i'll take a look and fix it today and upload a new version

DegenGamble

Veteran

Joined: Oct, 2011

Posts: 1150

Posted: Jul. 2, 2013 - 10:43 AM ET #95

So Governor is right - it's that damn Don Best website. I commented out the line of code that pulls the pitcher data from Don Best. Uploaded a fixed version (same link) - it's a quick fix - so i'll look into a long term fix later.