Capping MLB 2007 #101a Ov/Un plus Las Vegas Q&A

[sinatrac]

sin:
showing contrary info on your Detroit wind. I'm seeing IN from LF at 8... No Pudge or Maggs for the Tigers, either... I took a stab at KC/O regardless... Meche better in teh daytime over his career and Bondy really struggled in day games last year... (two decent ones in 07)...

just saw your post, weather.com still showing 8 out to r/f cor........

 

[pops69]

Pops,
Under the whips and salary tab, what does the numbers 4,5,6,7,8,9,10,11,12, 13 stand for in the sum of salary box? is it how many millions the pitchers make?
Thanks
cd

highest paid pitchers get a lower number and lowest paid get a highter number.. double click on any of the O or U numbers in col y or z and you will get the details.

what to look for in whip is if an ump had and effect on higher whips lower whips of the two pitchers

 

[pops69]

Pops,
probabaly another dumb question, but is there any way to print out the Pops summary and wa-nps{what does that stand for} report, so that it looks the same way you look at it in the spreadsheet? There are so many columns across, you cant see everything at once.
thanks

the best way to print that off is make a dumb version of that master (values only) with the proper headers. than you can arrange it as you see fit and print it out w/o effecting any calc. just like i do the pdws that i post in the thread

 

[pops69]

Pops,
another question, told you once i got started the questions would keep coming, lolll.
How do i get the master pivot table field list to show itself on the side? I closed it some how and i cant figure out how to get it to pop up again
thanks

need a better explaination, not sure what your talking about. it should always be there unless you have changed the filters to show no or less data

 

[pops69]

Seems this Mississippi State education I have is hampering my comprehension and application of the hard work being done. Here are some examples:

1. I don't really understand the relationships between the PDWS, the MLB Master, and the summaries.

2. All I know about the pivot tables is that they allow you to ask an infinite number of "what if's." Don't understand the mechanics.

3. I notice the temp and humidity columns are blank. Are we supposed to locate this data and input it, or is that input for us closer to game time?

Also, are you automatically playing the under on outdoor games where the humidity is between 50-65?

I fully expect to get a tirade of "WTF's?", but you asked for questions and I'll be the dummy who asks out loud what half of us are wondering. Thanks for all you do.

P.S. Did you ever get a chance to see if any natives around there remember Sammy Tannenbaum, aka "Philadelphia Sammy?" I'm curious to know what they think of his handicapping methods.

easy one's first, not in any specific order

1. forgot all about sammy
2. not automatically right now, 1st year collecting the data, but it sure does look promissing
3. pivot tables are nothing more than a quick sort on a large data base vs finding the info manually. i dont understand how a plane fly's either but it does.
4. humdity is left blank on the pdws, what good is the humidity taken at night 18 hours b4 the game. yes if the info continues to be as good as it is, it would be a good idea to get it, i always do about 15 min b4 the game is scheduled to be played
5. the pdws is the main document for collecting almost all of the basic info that i put into the master spreadsheet. just makes it easy to copy and paste from 1 source, so only takes me a few min to do my updates, as i collect all the data on the pdws and than copy paste to the master. no relation at all of the pdws to the popsummary and wa nps, other than it's a quick way to update those summaries vs using the drop down arrows

i believe that's all of them

 

[BillDildeaux]

On the KAN/DET game the HP umpire Jerry Crawford who historically is a slight Over Ump looks like he has changed his ways. He is now 0-4 O/U for 2007 and was calling alot of questionable strikes today.

 

[cd329]

need a better explaination, not sure what your talking about. it should always be there unless you have changed the filters to show no or less data

didnt change anything but some how i must have clicked the x to close the field table list box. I got it back by closing the spreadsheet and opening it up again, but there has got to be a way of opening it, without having to close and open the spreadsheet.
thanks for help
cd

 

[pops69]

didnt change anything but some how i must have clicked the x to close the field table list box. I got it back by closing the spreadsheet and opening it up again, but there has got to be a way of opening it, without having to close and open the spreadsheet.
thanks for help
cd

still dont know what you did, give me an example, do it again, use a small pivot table like OUAvgRunsbyLine and walk me thru the fuck up steps

 

[cd329]

still dont know what you did, give me an example, do it again, use a small pivot table like OUAvgRunsbyLine and walk me thru the fuck up steps

Pops,
heres an example. In the ou avg runs by line tab, there is a big box to the right called the pivot table field list which has the fields to click on to add to the report. on that box is an x in the upper right hand corner which closes that whole box, when i close it, i cant figure out how to get it to show again.
am not talking about all the little indivual boxes, they are open, its the big field list box to the right which i closed and cant open again
thanks

 

[pops69]

Pops,
heres an example. In the ou avg runs by line tab, there is a big box to the right called the pivot table field list which has the fields to click on to add to the report. on that box is an x in the upper right hand corner which closes that whole box, when i close it, i cant figure out how to get it to show again.
am not talking about all the little indivual boxes, they are open, its the big field list box to the right which i closed and cant open again
thanks

left click in any box of the values in the data on the left side of the page, and magic, it's back

 

[cd329]

left click in any box of the values in the data on the left side of the page, and magic, it's back

Pops,
Your talking about the hide and unhide
yes that only works if you dont actually close the box. I actually hit the close button of the box, so clicking on one of the value boxes doesnt bring back the field table box.
Try it, click the x in the corner and then click on one of the little boxes, it wount come back.
thanks

 

[pops69]

Pops,
Your talking about the hide and unhide
yes that only works if you dont actually close the box. I actually hit the close button of the box, so clicking on one of the value boxes doesnt bring back the field table box.
Try it, click the x in the corner and then click on one of the little boxes, it wount come back.
thanks

options, field list

 

[cd329]

options, field list

That did it, thank you Pops

 

[pops69]

5th inning already over in the TB game, i just cant understand why everyone keeps betting them under. you need to have star power to warrent a 7-. too many good hitters on both of those teams and no pig pen from either.

plus i saw a bunch of guys picking this game as an easy under. i guess there must be some data that i dont see or cant find

 

[EX-BALLPLAYER]

5th inning already over in the TB game, i just cant understand why everyone keeps betting them under. you need to have star power to warrent a 7-. too many good hitters on both of those teams and no pig pen from either.

plus i saw a bunch of guys picking this game as an easy under. i guess there must be some data that i dont see or cant find

Took the ov on that one last night because I thought it would be bet up. amazing it went down to 8 even. gotta love the D-Rays

 

[pops69]

Took the ov on that one last night because I thought it would be bet up. amazing it went down to 8 even. gotta love the D-Rays

mbb fav team to watch is TB, he's got me hook on them as well, never a dull moment with that great hitting and pitching

 

[bet2win.us]

early leans for tonight's games

NYY ov
SFO un
MIL un

I absolutely love this play which makes me a lot nervous

PHI ov opened at 9 currently at 8.5

I'm calling this game the "Toilet Bowl" there is no pitching on either side and both have the ability to put up major runs should be in the 15 to 20 run range

 

[ENKI]

5th inning already over in the TB game, i just cant understand why everyone keeps betting them under. you need to have star power to warrent a 7-. too many good hitters on both of those teams and no pig pen from either.

plus i saw a bunch of guys picking this game as an easy under. i guess there must be some data that i dont see or cant find

all the data pointed to an over - got stuck thinking Bedard and Kaz were up to the task for the under. New rule? Never a tampa under.

 

[sinatrac]

mbb fav team to watch is TB, he's got me hook on them as well, never a dull moment with that great hitting and pitching

I have bet over evry game this year, lot of (young) 5 tool players, and no pitching (less Kaz)........Guy giving my cmputer back tomorrow, said he never saw one that had the "blue screen of death" come on as soon as u turn it on lol. Vista!!!

 

[LETSGORAPTORS]

Guys,im leaning towards the Red Sox game under 10.
Any opions,thanks and GLTA!:drink: