2010 mlb capping & betting #102 - daily key info plus q&a

[jacksonjohn]

Yesterday: 0-3
YTD: 10-10
ALP: -1.08

Today:

Mets -1.10
San Diego +1.35
Atlanta +1.20

 

[DaffyDuck]

These are the plays today Jackson, based on the spreadsheet?

 

[jacksonjohn]

These are the plays today Jackson, based on the spreadsheet?

These are MY plays using the data I choose from what is available in the database. There are no official "THE PLAYS" in this thread. Everyone comes up with their own. Mine are in the early stages of experimentation so tread lightly or just watch and wait.


<input id="gwProxy" type="hidden"><!--Session data--><input onclick="jsCall();" id="jsProxy" type="hidden">

 

[pops69]

Pops would it be possible to add a sheet to the PDWS that would pick up all the stuff as the master would have it as in correct cells. Then for those that use the master like for 30 day calcs and stuff could simply copy that page and add to their own master and done. Might save you a lot of work in the long run.

prob is that pdws has many diff cells than the master and not in the same order as well. not really sure what you want other than what's already there that i upload with both files

 

[cigar]

what does the extra s in ussa stand for........

 

[cigar]

this is what i meant by the extra number in the master you posted yesterday, clicking on the 1 gave you the game slated for yesterday in that category......... handicapped that section in 2 minutes.

<table style="border-collapse: collapse; width: 102pt;" border="0" cellpadding="0" cellspacing="0" width="136"><col style="width: 50pt;" width="66"> <col style="width: 23pt;" width="31"> <col style="width: 29pt;" width="39"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt; width: 50pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; background: none repeat scroll 0% 0% rgb(219, 229, 241);" height="20" width="66">HVEM2</td> <td class="xl97" style="width: 23pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; background: none repeat scroll 0% 0% rgb(219, 229, 241);" width="31">
</td> <td class="xl97" style="width: 29pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; background: none repeat scroll 0% 0% rgb(219, 229, 241);" width="39">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215); background: none repeat scroll 0% 0% rgb(219, 229, 241);" height="20">W</td> <td class="xl97" style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215); background: none repeat scroll 0% 0% rgb(219, 229, 241);">L</td> <td style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215); background: none repeat scroll 0% 0% rgb(219, 229, 241);">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt;" height="20">6</td> <td class="xl97">6</td> <td class="xl97">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt;" height="20">2</td> <td class="xl97">5</td> <td class="xl97">1</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt;" height="20">5</td> <td class="xl97">6</td> <td class="xl97">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt;" height="20">7</td> <td class="xl97">4</td> <td class="xl97">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt;" height="20">2</td> <td class="xl97">1</td> <td class="xl97">
</td> </tr> </tbody></table>

 

[CTP]

What I am looking for is the same stuff you were adding to the master for todays gms. I got it all from the PDWS but takes like 3 or 4 pastes back in forth. My intent was on this extra sheet on the PDWS if it would reference those cells and put them in the right col such one could paste into the master in one fail swoop.

 

[pops69]

what does the extra s in ussa stand for........

oh, i though that is what u call it now. united socialiest states of america

 

[pops69]

this is what i meant by the extra number in the master you posted yesterday, clicking on the 1 gave you the game slated for yesterday in that category......... handicapped that section in 2 minutes.

<table style="border-collapse: collapse; width: 102pt;" border="0" cellpadding="0" cellspacing="0" width="136"><col style="width: 50pt;" width="66"> <col style="width: 23pt;" width="31"> <col style="width: 29pt;" width="39"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt; width: 50pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; background: none repeat scroll 0% 0% rgb(219, 229, 241);" height="20" width="66">HVEM2</td> <td class="xl97" style="width: 23pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; background: none repeat scroll 0% 0% rgb(219, 229, 241);" width="31">
</td> <td class="xl97" style="width: 29pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; background: none repeat scroll 0% 0% rgb(219, 229, 241);" width="39">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215); background: none repeat scroll 0% 0% rgb(219, 229, 241);" height="20">W</td> <td class="xl97" style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215); background: none repeat scroll 0% 0% rgb(219, 229, 241);">L</td> <td style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215); background: none repeat scroll 0% 0% rgb(219, 229, 241);">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt;" height="20">6</td> <td class="xl97">6</td> <td class="xl97">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt;" height="20">2</td> <td class="xl97">5</td> <td class="xl97">1</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt;" height="20">5</td> <td class="xl97">6</td> <td class="xl97">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt;" height="20">7</td> <td class="xl97">4</td> <td class="xl97">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt;" height="20">2</td> <td class="xl97">1</td> <td class="xl97">
</td> </tr> </tbody></table>

just what i though. it was caused by me doing a refresh all on the master b4 i uploaded it with only partial data for that days' games. i just wanted to get something up for jj without creating a bunch of extra work for myself. it should not happen again as dont plan to upload any partial masters in the future

 

[pops69]

What I am looking for is the same stuff you were adding to the master for todays gms. I got it all from the PDWS but takes like 3 or 4 pastes back in forth. My intent was on this extra sheet on the PDWS if it would reference those cells and put them in the right col such one could paste into the master in one fail swoop.

fuck u c. better u do the copy paste specials and modifications than me. already doing wtf more special stuff added to the pdws of which 99.9999999999999 are not using or dont have a clue as how they would anyway

 

[cigar]

just what i though. it was caused by me doing a refresh all on the master b4 i uploaded it with only partial data for that days' games. i just wanted to get something up for jj without creating a bunch of extra work for myself. it should not happen again as dont plan to upload any partial masters in the future

cant argue the USSA

so if i did some copying and pasting from todays pdws to todays master......... could i make those numbers come up today?

 

[pops69]

cant argue the USSA

so if i did some copying and pasting from todays pdws to todays master......... could i make those numbers come up today?

yes, u just need to make sure your doing the correct cols from the pdws into the master and also make double sure that u do a paste special vs a copy past. if you do a straight copy paste high probability that you will get file cross linking problems as well. plus one other think is that you will get multiple error messages when you do a refresh all so that all the data than shows up in the pivot tables

b4 u do the refresh all after you copied the cols you wanted some cols from the previious day will need to be dragged down for those that do have forms in them. i try not to do all that many calc in the master as i dont want the size to become 100gb plus

try it you can fuck anything up. if you do just d/l another copy off my post

 

[cigar]

i was trying, but need to again with a special paste...............thanks Pop,

all these guys are waldos now? do you think the oddsmaker adjusts for all of them? Surely they do for H and E. I was surprised to get an 8 on R last night

 

[pops69]

i was trying, but need to again with a special paste...............thanks Pop,

all these guys are waldos now? do you think the oddsmaker adjusts for all of them? Surely they do for H and E. I was surprised to get an 8 on R last night

i know they do for a fact because i know some of the people that make the numbers etc. but most bettors dont or even have a clue that the umps are a factor in that o/u number

 

[cigar]

ok just thought maybe a couple could be off some radars.


so this might sound dumb...but how do i refresh?

 

[pops69]

ok just thought maybe a couple could be off some radars.


so this might sound dumb...but how do i refresh?

not everyone one of those are all the time but they do look at their records etc and betting patterns for 1st and 2nd game of a series and make adjustments accordingly

click on the data tab at the top of the screen and click on refresh all. than you need to determine what actions to tell excel to do based on your error messages

 

[cigar]

well that wasnt too bad.

Got it, thanks

 

[pops69]

well that wasnt too bad.

Got it, thanks

1st few time takes a while but after than once you know the pattern it's a piece of cake. i can do all my data collection in about 5 min and the adding to the master and thread pdws in 25 min tops. much of that is double checking

 

[jblonghorn]

WTF are the Celtics getting more points tonight than in game one? It makes zero sense. I think Celts win straight up.

 

[cigar]

WTF are the Celtics getting more points tonight than in game one? It makes zero sense. I think Celts win straight up.

6 is the same isnt it?

maybe cause it's the only game people are watching and what they last saw and heard from the talking heads is that this is the best the Lakers have looked all year