SBR Top-Rated Sportsbooks Recommended Books
1. Pinnacle Sports SBR Rating A+ Pinnacle Sports Review
2. The Greek Sports Book SBR Rating A+ The Greek Review
3. BookMaker SBR Rating A+ BookMaker Review
4. BetJamaica SBR Rating A+ BetJamaica Review
5. Legends Sports SBR Rating A+ Legends Review
 
SBR Posters' Poll - September 2009 View Complete Results
1. 5Dimes 253 total points 5Dimes Review
2. Matchbook 252 total points Matchbook Review
3. BetJamaica 194 total points BetJamaica Review
4. Pinnacle Sports 193 total points Pinnacle Sports Review
5. BookMaker 190 total points BookMaker Review
 
 
View New Posts
 
LinkBack Thread Tools
Old 12-09-08, 07:49 AM   #1
mundane
 
mundane's Avatar
Joined: 02-25-08
Posts: 2,313
 
Message Me
Challenge Me
Default NBA Math excel sheet (beta)

for reference, check this thread... NBA Math

here's an excel worksheet i made for this so called "70% system". im calling it 'beta' right now as im sure i missed out on something. feel free to comment.

lemme know... tweak it as u please! i could have missed something. it's just a draft but i figure i'd share it now.

btw.. the only feasible play right now is PISTONS. i think the other ones dont qualify coz of injuries (houston) and back to back (magic). suns, hmm im not sure how to quantify injuries so ill leave that up to u but even if it qualifies for calculation, it's a NO PLAY anyways 4.12 only. Knicks @ Bulls, system got fubar bcoz they have an identical record! LOL!

try to plug in the numbers urself. this worksheet only needs 6 numbers from u then it will tell u if it's a play, no play or play the other team ats. u'll have to research injuries, back to back and read the notes and filters urself if the games ur looking at is qualified for this system.

best of luck fellas! let's beat the books!

disclaimer... this could be wrong as i dont really have a firm grasp of this 'system'. i just based it upon my noobie comprehension.
Attached Files
File Type: xls nba_win%play_calc_beta_v3.xls (59.0 KB, 427 views)

Last edited by mundane; 12-22-08 at 12:56 PM..
Quick reply to this message
Old 12-09-08, 08:08 AM   #2
Devon
 
Devon's Avatar
Joined: 11-25-08
Posts: 272
 
Message Me
Challenge Me
Default

Great work, mundane!

Defintely keen to have a look at it with some numbers and see how it goes! Cheers.
Quick reply to this message
Old 12-09-08, 08:35 AM   #3
mundane
 
mundane's Avatar
Joined: 02-25-08
Posts: 2,313
 
Message Me
Challenge Me
Default

here's a screenshot for those who are curious...

like i said, leave a comment here. ill tweak it some more if need be.

Quick reply to this message
Old 12-09-08, 09:09 AM   #4
mundane
 
mundane's Avatar
Joined: 02-25-08
Posts: 2,313
 
Message Me
Challenge Me
Default

oh wait.. pistons is only 19 games in.. i guess it's not officially a play for this system. proceed with caution!
Quick reply to this message
Old 12-09-08, 10:16 AM   #5
Fiasco
 
Fiasco's Avatar
Joined: 11-02-08
Posts: 2,195
 
Message Me
Challenge Me
Default

good stuff
Quick reply to this message
Old 12-09-08, 03:05 PM   #6
nzwarrior
 
nzwarrior's Avatar
Default

I downloaded it but it had no formula is that link the one with the actual spreadsheet that you use?
Quick reply to this message
Old 12-09-08, 03:26 PM   #7
jtnguyen79
 
jtnguyen79's Avatar
Joined: 09-26-07
Posts: 730
 
Message Me
Challenge Me
Default

good stuff i'll probably try it on a night when there's less games

keep it up
Quick reply to this message
Old 12-09-08, 04:30 PM   #8
nzwarrior
 
nzwarrior's Avatar
Default

Is MIL +6.5 a play going by the system? I still dont quite understand it.. Not too sure if my maths is right on this one. The 6.5 seems to low to play with the bucks inconsistancys but i wanna try the system out?
Thanks
Quick reply to this message
Old 12-09-08, 05:19 PM   #9
Boner_18
 
Boner_18's Avatar
Joined: 08-24-08
Posts: 1,384
 
Message Me
Challenge Me
Default

the link is busted... I made my own to test it out, but its not as purrrty as yours, can you repost?
Quick reply to this message
Old 12-09-08, 05:54 PM   #10
The_Kid
 
The_Kid's Avatar
Joined: 02-09-08
Posts: 4,785
 
Message Me
Challenge Me
Default

Thanks for putting this information in excel, mundane. This will be interesting if you keep this thread up the rest of the NBA season.
Quick reply to this message
Old 12-09-08, 06:10 PM   #11
Devon
 
Devon's Avatar
Joined: 11-25-08
Posts: 272
 
Message Me
Challenge Me
Default

Quote:
Originally Posted by nzwarrior View Post
Is MIL +6.5 a play going by the system? I still dont quite understand it.. Not too sure if my maths is right on this one. The 6.5 seems to low to play with the bucks inconsistancys but i wanna try the system out?
Thanks
No, it not.

Play needs to be above 10 (or equal to?) for a play to happen.
Quick reply to this message
Old 12-09-08, 06:21 PM   #12
ManBearPig
 
ManBearPig's Avatar
Joined: 12-04-08
Posts: 581
 
Message Me
Challenge Me
Default

So according to this system the only play tonight is the pistons. The one bet I wasnt about to make. Well I hope for at least tonight this system is a little inaccurate so that I can win some straight cash.
__________________
"And if they hate then let them hate and watch the money pile up..."- 50 Cent
Quick reply to this message
Old 12-09-08, 06:35 PM   #13
nzwarrior
 
nzwarrior's Avatar
Default

Quote:
Originally Posted by Devon View Post
No, it not.

Play needs to be above 10 (or equal to?) for a play to happen.
I thought if its equals -1 or less you play the fade?
I probably worked it out wrong anyway though like i said im still not sure how it works...
Quick reply to this message
Old 12-09-08, 06:57 PM   #14
mundane
 
mundane's Avatar
Joined: 02-25-08
Posts: 2,313
 
Message Me
Challenge Me
Default

pistons is not even a play. 19 games only for them coming in on this game. SO STILL NO OFFICIAL PLAY accrdng to the 'system rules'.
Quick reply to this message
Old 12-09-08, 07:31 PM   #15
Boner_18
 
Boner_18's Avatar
Joined: 08-24-08
Posts: 1,384
 
Message Me
Challenge Me
Default

Great, dloaded it! Thanks for making such a snappy version Mundane, love the "SBR" tab.
Quick reply to this message
Old 12-09-08, 07:33 PM   #16
Boner_18
 
Boner_18's Avatar
Joined: 08-24-08
Posts: 1,384
 
Message Me
Challenge Me
Default

Aren't the Blazers and Bulls both plays?
Quick reply to this message
Old 12-09-08, 07:50 PM   #17
Devon
 
Devon's Avatar
Joined: 11-25-08
Posts: 272
 
Message Me
Challenge Me
Default

Hmm... doesn't this line

Quote:
If the number is less than or equal to -1, then you play the other team ATS.
get canceled out by this?

Quote:
The final number must be 10 or greater for a PLAY!
Becuase no matter which team you put first and you get a "negative" number, if you switch the teams around (home first on the card and vice versa), the number is the same but a positive number and pending on the negative number it may be LESS than or MORE than 10.... which is resolute for the second quoted line.

Maybe it should read...

Quote:
The final number must be 10 or greater for a PLAY! OR if the play is -10 or lower, then play the opposing team ATS
Thoughts people?

Last edited by Devon; 12-09-08 at 07:57 PM..
Quick reply to this message
Old 12-09-08, 07:57 PM   #18
mundane
 
mundane's Avatar
Joined: 02-25-08
Posts: 2,313
 
Message Me
Challenge Me
Default

identical records for both teams - knicks and bulls.u dont have a lesser number to subtract the other ones number.

magic has a better winning % than blazers so i guess that's the selected team. BACK TO BACK for them though, so a no-play accdng to the rulez. but if u plug in the numbers, it says play the opposing team ats (play blazers). but it's not an 'offical' play.

none of the games qualify actually.
Quick reply to this message
Old 12-09-08, 08:03 PM   #19
mundane
 
mundane's Avatar
Joined: 02-25-08
Posts: 2,313
 
Message Me
Challenge Me
Default

devon, from what i could understand from that initial post by the person who brought this up, 0-9.9 is not a play. u dont play that game. basically a pass. he mentioned this system only gets about 100 games. the filters alone takes half of the nba games out (back to back, injuries, 20 games in the season, no 3 games after all star, starters shld be at least back in a week, missing starter = all these equates to NO PLAY on a game)

and i believe u always, start with the better team, winning percentage-wise. so that way, ull get a positive number to work with.
Quick reply to this message
Old 12-09-08, 08:21 PM   #20
nzwarrior
 
nzwarrior's Avatar
Default

Im confused... so if its a negative 1 or more its a PLAY for the dog? -0.99-9.99 a NO PLAY? And 10+ a PLAY for the fav? Is that correct?
Quick reply to this message
Old 12-09-08, 08:25 PM   #21
Devon
 
Devon's Avatar
Joined: 11-25-08
Posts: 272
 
Message Me
Challenge Me
Default

Quote:
Originally Posted by nzwarrior View Post
Im confused... so if its a negative 1 or more its a PLAY for the dog? -0.99-9.99 a NO PLAY? And 10+ a PLAY for the fav? Is that correct?
Pretty much.

10 or greater = Play "selected team"
0-9.99 = NO PLAY
-1 or less = Play other team

Selected team = the team with the higher winning percentage, you put them in the equation first, see the print screen card mundane posted earlier.
Quick reply to this message
Old 12-09-08, 08:39 PM   #22
nzwarrior
 
nzwarrior's Avatar
Default

I worked that out wrong anyway i subtracted 3 from phoenix when i was supposed to add 3... For home advantage
Quick reply to this message
Old 12-09-08, 08:42 PM   #23
Devon
 
Devon's Avatar
Joined: 11-25-08
Posts: 272
 
Message Me
Challenge Me
Default

Yeah, it's a no play.

Off the system topic.. Bucks do look great there, considering how the Suns have been playing this year and Bucks have been covering machines too. They would do decent with Bogut and with Redd back, more minutes - this should be close.
Quick reply to this message
Old 12-09-08, 09:01 PM   #24
nzwarrior
 
nzwarrior's Avatar
Default

Yeah I like the Bucks here but I’d rather 8.5, ML is tempting though but I’m pretty sure the Suns will do enough to win...
Quick reply to this message
Old 12-10-08, 07:05 AM   #25
turboj
 
turboj's Avatar
Joined: 11-12-08
Posts: 83
 
Message Me
Challenge Me
Default

Hey, Mundane. Do You Have A Spreadsheet On Today Game? Thanks
Quick reply to this message
Old 12-10-08, 09:56 AM   #26
strybie
 
strybie's Avatar
Joined: 12-08-08
Posts: 179
 
Message Me
Challenge Me
Default

Quote:
Originally Posted by turboj View Post
Hey, Mundane. Do You Have A Spreadsheet On Today Game? Thanks
according to me you can use the same spreadsheat in game ?

Pacers@toronto : on both teams I get NO play
NYknicks@NJnets : on both teams I get NO play
MEM@OKC : NO play
Cha@NO : NO Play (play NO when spread is -8.5 of lower)
ATL@SA : NO play
MIN@DEN : PLay Denver -12 (and still OK till spread 16)

For the other games I don't see the lines yet

From now on the system should work because most teams played 20 games.

Let's see what de record will be for this system. 70% should be great

Last edited by strybie; 12-10-08 at 02:10 PM..
Quick reply to this message
Old 12-10-08, 11:04 AM   #27
SexyMit
Money Maker!
 
SexyMit's Avatar
Joined: 10-12-06
Posts: 5,324
 
Message Me
Challenge Me
Default

I couldn't figure out how to use the system... I tried imputting the data in there. How does the calculations work? Never used anything like that before but if it proven to make money over the yrs would be willing to give it a try.
__________________
If it seems to good to be true it usually is!!
Quick reply to this message
Old 12-10-08, 02:17 PM   #28
strybie
 
strybie's Avatar
Joined: 12-08-08
Posts: 179
 
Message Me
Challenge Me
Default

Did the calculation for

Cle @ 76ers : It says PLAY CLE-6.5

So only two which have a result above 10 are Denver and CLE

I will play them both single and double; Hope it works

CLE - 6,5
DEN - 12

Other games are all : No play on the selected team.

Good luck to all
Quick reply to this message
Old 12-10-08, 05:06 PM   #29
mundane
 
mundane's Avatar
Joined: 02-25-08
Posts: 2,313
 
Message Me
Challenge Me
Default

i think every game is a no play! (can somebody confirm?) devon?

because of back to backs and and the spread being 10 and higher. (i juzz woke up. i could be wrong.)
Quick reply to this message
Old 12-14-08, 02:08 PM   #30
AdaBarber
 
AdaBarber's Avatar
Joined: 12-05-08
Posts: 553
 
Message Me
Challenge Me
Default

If this is the link to that yousendit, it has expired. It won't download.
__________________
2009 NFL 13-15
2009 NCAA 25-24-1
Quick reply to this message
Old 12-15-08, 05:20 AM   #31
Ineed$$
 
Ineed$$'s Avatar
Joined: 12-07-08
Posts: 44
 
Message Me
Challenge Me
Default

Yeah, upload again, pls!
__________________
Quote:
Originally Posted by cocknocker View Post
With $1000.00, I would place one hundred dollar wagers for whole game plays, and $25.00 for halftime plays, and $10.00 on any parlay you choose to do, with a minimum of 4 teams.

Once you get to $2000.00, start placing $200.00 wagers, and $50.00 halftime plays, and still only $10.00 parlays.

(...)

There you have it. Money management. Pin it up on your wall and never forget that information.
Quick reply to this message
Old 12-15-08, 07:51 AM   #32
Devon
 
Devon's Avatar
Joined: 11-25-08
Posts: 272
 
Message Me
Challenge Me
Default

15/12 -

There is definitely one play, possibly a second. The definite play is Atlanta Hawks, while the possible play is Boston - if you can get Boston at -8.5 or lower than the play works, however, the line has moved to -9.
Quick reply to this message
Old 12-15-08, 08:12 AM   #33
Devon
 
Devon's Avatar
Joined: 11-25-08
Posts: 272
 
Message Me
Challenge Me
Default

Having a second look at that Atlanta is not a play.

The reason being Don't play if one or more starters are OUT. Allow one week for return starters.

The Bobcats have only just recently accquired two players who will start in their team via trade, we have to lay off them for at least a week according to the above rule. I know there's no rule as such on trades and etc but Bobcats games can't be touched for at for at least a week from one of two dates:

Wed 10 December - when Bobcats did the trade with the Suns; or
Sat 13 December - when Bell & Diaw started for the first time with the Bobcats.


Quick reply to this message
Old 12-15-08, 04:37 PM   #34
nick2060
 
nick2060's Avatar
Joined: 10-28-08
Posts: 918
 
Message Me
Challenge Me
Default

They don't say anything about trades, so i really don't think that rule applies. Also because its not like there regaining team chemistry, the chemistry has to be built from scratch essentially. Eitherway regardless as to whether you guys decide it should be a play im bettin on it so good luck everybody
Quick reply to this message
Old 12-15-08, 06:27 PM   #35
Devon
 
Devon's Avatar
Joined: 11-25-08
Posts: 272
 
Message Me
Challenge Me
Default

Yeah, fair enough Nick.

Just floating out ideas, thinking out aloud... more on the fact that they would have had to readjust team chemistry with them but since there is no rule about trades, should be a play as you mentioned.
Quick reply to this message
 


SBR Featured Videos

Thread Tools
Display Modes



All times are GMT -5. The time now is 02:52 PM.


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33