RPI Chase Picks and Tracking Spreadsheet

Forum: Systems & Strategies Page 4 of 4  1 2 3 4  
Author: [Systems & Strategies] Topic: RPI Chase Picks and Tracking Spreadsheet
hansivonmueller PM hansivonmueller
Joined: Apr 2007
Posts: 1907
British
              Columbia
 
hansivonmueller
Participation Meter
Posted: 7/7/2012 11:32:43 PM
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 PM CanisMajor
Joined: Jan 2012
Posts: 185
Texas
 
CanisMajor
Participation Meter
Posted: 7/23/2012 12:16:42 PM

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 PM neilsy25
Joined: Oct 2008
Posts: 818
 
neilsy25
Participation Meter
Posted: 7/27/2012 1:11:52 PM

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 PM housebusta
Joined: Mar 2013
Posts: 0
 
housebusta
Participation Meter
Posted: 3/21/2013 3:42:46 AM
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 PM luckywayne001
Joined: Apr 2013
Posts: 5
Texas
 
luckywayne001
Participation Meter
Posted: 4/21/2013 2:00:04 AM

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 PM luckywayne001
Joined: Apr 2013
Posts: 5
Texas
 
luckywayne001
Participation Meter
Posted: 4/21/2013 10:43:16 AM

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 PM Bradbrayan
Joined: Aug 2012
Posts: 22
Venezuela
 
Bradbrayan
Participation Meter
Posted: 4/24/2013 9:30:50 AM
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 PM DegenGamble
Joined: Oct 2011
Posts: 1070
New Jersey
 
DegenGamble
Participation Meter
Posted: 4/25/2013 12:00:52 PM

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 PM b_rad_1983
Joined: Dec 2011
Posts: 553
Ontario
 
b_rad_1983
Participation Meter
Posted: 6/30/2013 9:38:26 AM
Great Work on this! Thanks
Is there anything for NHL?
b_rad_1983 PM b_rad_1983
Joined: Dec 2011
Posts: 553
Ontario
 
b_rad_1983
Participation Meter
Posted: 7/1/2013 12:26:32 PM
im trying this out and getting an error when I update.
"run time error '1004'
DegenGamble PM DegenGamble
Joined: Oct 2011
Posts: 1070
New Jersey
 
DegenGamble
Participation Meter
Posted: 7/1/2013 1:34:34 PM
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 PM literato
Joined: Jun 2013
Posts: 38
France
 
literato
Participation Meter
Posted: 7/1/2013 1:38:17 PM
hello I'm not an expert in macro but I think your problem is importing the web page pitchers
Danrules24 PM Danrules24
Joined: May 2012
Posts: 4311
Nevada
 
Danrules24
Participation Meter
Posted: 7/1/2013 1:45:36 PM
I had an issue too, but downloaded a new one and it ran perfectly. Thanks Degen.
BuckeyeKaptn PM BuckeyeKaptn
Joined: Jan 2013
Posts: 656
Ohio
 
BuckeyeKaptn
Participation Meter
Posted: 7/1/2013 4:36:11 PM
I was having issues too.  I just closed them without saving and then reopened them and it worked fine
b_rad_1983 PM b_rad_1983
Joined: Dec 2011
Posts: 553
Ontario
 
b_rad_1983
Participation Meter
Posted: 7/1/2013 5:03:29 PM
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 PM b_rad_1983
Joined: Dec 2011
Posts: 553
Ontario
 
b_rad_1983
Participation Meter
Posted: 7/2/2013 1:31:43 AM
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 PM BuckeyeKaptn
Joined: Jan 2013
Posts: 656
Ohio
 
BuckeyeKaptn
Participation Meter
Posted: 7/2/2013 6:49:56 AM
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 PM TheGovernor11
Joined: Jun 2011
Posts: 33
 
TheGovernor11
Participation Meter
Posted: 7/2/2013 7:49:23 AM
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 PM DegenGamble
Joined: Oct 2011
Posts: 1070
New Jersey
 
DegenGamble
Participation Meter
Posted: 7/2/2013 9:46:17 AM
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 PM DegenGamble
Joined: Oct 2011
Posts: 1070
New Jersey
 
DegenGamble
Participation Meter
Posted: 7/2/2013 10:43:00 AM
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. 

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.
TheGovernor11 PM TheGovernor11
Joined: Jun 2011
Posts: 33
 
TheGovernor11
Participation Meter
Posted: 7/2/2013 12:54:59 PM
Thanks Degen.  We'd be screwed without your excel sheet!
BuckeyeKaptn PM BuckeyeKaptn
Joined: Jan 2013
Posts: 656
Ohio
 
BuckeyeKaptn
Participation Meter
Posted: 7/2/2013 1:44:52 PM
QUOTE Originally Posted by DegenGamble:


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.
I noticed the Don Best web site does that a few days ago...didn't have the matchups on the "Classic" side.  Just checked it now, still doesn't.
literato PM literato
Joined: Jun 2013
Posts: 38
France
 
literato
Participation Meter
Posted: 7/2/2013 4:03:25 PM

may be that this link will be useful

 

http://www.statfox.com/mlb/gamematchup.asp

BuckeyeKaptn PM BuckeyeKaptn
Joined: Jan 2013
Posts: 656
Ohio
 
BuckeyeKaptn
Participation Meter
Posted: 7/2/2013 4:41:18 PM
QUOTE Originally Posted by literato:

may be that this link will be useful

 

http://www.statfox.com/mlb/gamematchup.asp

That's perfect.  DeGen, this link Literato posted is almost identical to Don Best's.  I'm going to use is.  Thanx
BuckeyeKaptn PM BuckeyeKaptn
Joined: Jan 2013
Posts: 656
Ohio
 
BuckeyeKaptn
Participation Meter
quote#100
Posted: 7/2/2013 4:44:41 PM
Go figure, Don Best is now working.
Forum: Systems & Strategies Page 4 of 4  1 2 3 4  
You have entered the forum as a GUEST. 
You must login/register to post or reply.