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

[pops69]

housekeeping

on the next spreadsheet update, i'm moving all the spreadsheet tabs that you should just stay out all the way to the right and coloring them red. those will be data only or supporting data and calculations for the summary reports or other pivot tables within the spreadsheet

so what you have are two summary tabs popsummary and wa nps, plus 8 tabs for pivot tables, and one tab for Line Charts

 

[BillDildeaux]

Pops I was messing around with the new SS you sent me. It appears to still have problems. e.g. When you put in the Cardinals as the home team the Cubs pitchers show up on the drop down list of home pitchers. Hope it is not PICNIC (problem in chair not in computer) thanks

 

[pops69]

Pops I was messing around with the new SS you sent me. It appears to still have problems. e.g. When you put in the Cardinals as the home team the Cubs pitchers show up on the drop down list of home pitchers. Hope it is not PICNIC (problem in chair not in computer) thanks

try the one i just sent, i know it works, just tried it and was working fine

 

[BillDildeaux]

try the one i just sent, i know it works, just tried it and was working fine

That one should do it. Thanks

 

[cd329]

Does anyone have T-Bones email?

check the spread sheet he does everyday, i believe its in there.

 

[ILMW]

Thanks will do.

 

[ILMW]

No checked the sunday ss and Tbones email is not listed, if anyone has it or Tbone you read this can you post it, thanks.

 

[cd329]

Pops,
am finally getting the hang of the spreadsheet,especially since i never really used one before. Still have some learning to do and i will be soon posting a bunch of questions for you, lolllllllll.
My first question is, and might be a dumb one, but if we spot a trend are we supposed to post it on the board? I know with basketball, we werent supposed to say anything.
Cause right now i find a under trend that is 15-2 on the year.
thanks
cd

 

[cd329]

No checked the sunday ss and Tbones email is not listed, if anyone has it or Tbone you read this can you post it, thanks.

tbonestk at gmail.com

 

[ILMW]

thanks cd

 

[ILMW]

Some

Some more weekly reading for anyone that needs to play catch up since the start of the season.


http://download.yousendit.com/A7A43E2D3AA9E012

 

[pops69]

Pops,
am finally getting the hang of the spreadsheet,especially since i never really used one before. Still have some learning to do and i will be soon posting a bunch of questions for you, lolllllllll.
My first question is, and might be a dumb one, but if we spot a trend are we supposed to post it on the board? I know with basketball, we werent supposed to say anything.
Cause right now i find a under trend that is 15-2 on the year.
thanks
cd

lol, no you bet it, if you want to post it, your choice. or if your not sure of the data, post it and ask. the only reason we put the data together is to make bets. so if it feels good "just do it"

 

[pops69]

going with 3 overs for the late games tonight:

TB ov 9-
Col ov 9-
nat ov 9

 

[mlfp]

going with 3 overs for the late games tonight:

TB ov 9-
Col ov 9-
nat ov 9

On that TB game with you after spending my afternoon buried in the Master SS. Was able to operate it 100% with my old version of Excel for some reason today, whereas every other has given me the filetype unknown warning or whatever. GL

 

[pops69]

On that TB game with you after spending my afternoon buried in the Master SS. Was able to operate it 100% with my old version of Excel for some reason today, whereas every other has given me the filetype unknown warning or whatever. GL

i have no clue why some are and are not working. sooner or later we'll all be on the same page and version numbers

 

[pops69]

On that TB game with you after spending my afternoon buried in the Master SS. Was able to operate it 100% with my old version of Excel for some reason today, whereas every other has given me the filetype unknown warning or whatever. GL

just remember red your dead, all other tabs open for business (al & NL Combined) will be color coded red in my next update

 

[pops69]

updated ump spreadsheet last 3 years plus 2007 ov/un by ump and league
in the link below

http://download.yousendit.com/9BE8361A1D6F9D0C

 

[CTP]

Couple dumb questions. Say one wanted to look at line moves is there any other place to look than al/nl combined?

What is up with Tampa over? Granted based on Cris there is a 1.5 move down. So far 2 games like that, one scored 3 and naturally stayed under the other 8 and the line had moved to 7 so an over. Pretty low scoring averages for Tampa. Do you have a genious type answer like usual. I thought Capn kind of had it marked as an under as well.

 

[ILMW]

Tbone you have mail

 

[pops69]

Couple dumb questions. Say one wanted to look at line moves is there any other place to look than al/nl combined?

What is up with Tampa over? Granted based on Cris there is a 1.5 move down. So far 2 games like that, one scored 3 and naturally stayed under the other 8 and the line had moved to 7 so an over. Pretty low scoring averages for Tampa. Do you have a genious type answer like usual. I thought Capn kind of had it marked as an under as well.

with the TB hitting and pitching i'm never taking them under, even vs eddings, they could score 20 runs and there pitching would give up 22. all they like to do his hit the shit out of the ball and run the bases

regarding line moves, the LineMove Tab has most of the data with respect to those. and DB uses cris for the closing lines