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

[sinatrac]

Pops, will be putting up weather early am, and (when possible) hour or so before nite games. Also plan to track 2:00-5:00 local time starts to see if field shadows form an under pattern. We spoke about eliminating a few parks where wind no factor. Will do them all until I hear further.

 

[jacksonjohn]

"How to on Pivot Tables"

the boy's are back in town:

below are the basic requirement need to receive the MLB packages for this year in terms of time and computer resources need to be able to do the job effectively.


your email system can handle 1 mb of attachments. plus you will need pkunzip or any program that can unzip compressed files as i send out the master programs in zip format at least twice per week and the daily updates are very small.
each person will receives the mlb packages will be required to do 14 days of pdws (pitcher data work sheet for the games the next day, which should not take you more than 15 min per night to do these updates)

much of this info is just straight drag and will take less than 30 seconds per row for day and date etc, and much will be data mined as well. it's just a few key areas that need to be checked etc. a copy of this years pdws is posted below

also i'll only be using office 2007 for this years spreadsheets, so you will nee a program that able to use those excel files. also no hunt and peck guys with 286 puters, these programs are very large and you really should know how to use excel pivot tables to use the programs effectively

I work for a career technical college and have asked the technology instructor to teach me about navigating through the pivot tables and charts. He says that in two weeks he will have a primer put together that I can follow. When I get it, I will post it for all who need help with this.

 

[leisure]

I work for a career technical college and have asked the technology instructor to teach me about navigating through the pivot tables and charts. He says that in two weeks he will have a primer put together that I can follow. When I get it, I will post it for all who need help with this.

John look thru pops other thread on CBB forum as I remember a few pivot table tutorials being posted there. It was within the last 7-10 days if that helps

 

[ChuckECheese]

Here's a couple links I have used the last few years that were helpful to find info.
http://mlb.mlb.com/index.jsp

This is a great weather site.
http://www.weather.com/activities/events/sports/?from=breadcrumbs

 

[ILMW]

I work for a career technical college and have asked the technology instructor to teach me about navigating through the pivot tables and charts. He says that in two weeks he will have a primer put together that I can follow. When I get it, I will post it for all who need help with this.

Please do as I am a retard when it comes to this, working slow but sure trying to figure it out.

 

[pops69]

Pops, will be putting up weather early am, and (when possible) hour or so before nite games. Also plan to track 2:00-5:00 local time starts to see if field shadows form an under pattern. We spoke about eliminating a few parks where wind no factor. Will do them all until I hear further.

wtf happend to you and my free dinner in vegas

 

[billyaz]

Pops your threads are the best fucking things going on the internet information wise.

I see you are adding game time temp and humidity to the data and I wondered if you guys considered tracking the Barometric pressure at game time??

Alot of people i talk to feel that the pressure and air temp have a much greater effect on the ball than humidity.

Just curious what any of you guys think.

 

[twjd]

wtf happend to you and my free dinner in vegas

You should know that weather men never come through.LOL

 

[sinatrac]

wtf happend to you and my free dinner in vegas

page 458 post 11444....so you WANTED me to call you to hook up?

 

[pops69]

Please do as I am a retard when it comes to this, working slow but sure trying to figure it out.

into to pivot tables link below. a bunch of pivot tables will already be included with the spreadsheet like last year, but each time i put another pivot table in, it almost doubles the side of the spreadsheet. plus a bunch of you will come up with new ideas for differnet tables as well which use the info that available. if we are capturing the data, a pivot table can be run against it for what if's

http://spreadsheets.about.com/sites...bles&SUName=spreadsheets&TopNode=22019&type=1

 

[pops69]

just in case someone need the nit and mm date for this weeks game they are in the link below. this will be a full service thread.

i'll have a screen shot of the pdws up shortly. it's really coming along, and expect it to be ready well b4 the season starts

nit and mm data below

http://download.yousendit.com/D002B2877C4CD0FD

 

[tbonestk]

Pivot Table 101:

http://office.microsoft.com/en-us/excel/HA010346321033.aspx?pid=CH010714011033

http://office.microsoft.com/en-us/excel/HA010346331033.aspx

http://www.microsoft.com/dynamics/using/excel_pivot_tables_collins.mspx

 

[punter]

I think it might be helpful to track starting pitchers wives/girlfriends menstrual cycles.
I know this info might be a bit hard to come by. Does anyone know some gynecologist who are devout gamblers.

 

[EX-BALLPLAYER]

Afternoon gents, Good to see everyone here. That Matsu guy sure can pitch. 5 2/3 no- hit inns vs. a good Reds line up. Saw more of the same last week with him, goning to be un-hittable till players get quite a few looks at him.

 

[leisure]

Afternoon gents, Good to see everyone here. That Matsu guy sure can pitch. 5 2/3 no- hit inns vs. a good Reds line up. Saw more of the same last week with him, goning to be un-hittable till players get quite a few looks at him.

104 pitches and was wild also

 

[EX-BALLPLAYER]

104 pitches and was wild also

Exactly, he had a "bad" day and not one hit, or even a hard hit ball for that matter.

 

[geeze]

Should we consider 5 inning bets as a separate gamble with more reliability, making it more simple to maintain data without having to factor in unpredictable bullpen information?

Reducing the variables should increase accuracy.

 

[EX-BALLPLAYER]

Should we consider 5 inning bets as a separate gamble with more reliability, making it more simple to maintain data without having to factor in unpredictable bullpen information?

Reducing the variables should increase accuracy.

I found no value in these last year, much higher priced for one thing, and sometimes the bats don't come alive for your team till the later inns.

 

[EX-BALLPLAYER]

Geeze, I'm only talking about sides btw, you might be right with totals.

 

[pops69]

Pivot Table 101:

http://office.microsoft.com/en-us/excel/HA010346321033.aspx?pid=CH010714011033

http://office.microsoft.com/en-us/excel/HA010346331033.aspx

http://www.microsoft.com/dynamics/using/excel_pivot_tables_collins.mspx

other that learning VB and writing macro for data mining, this is prob one of the most important things you should know and lear with respect to using excel. it's not all that difficult to even create them, especially with 2007 walk you right thru it. there will be at least 10 pivot tables included in the master which i already feel are important to capping mlb ov/un, but my baseball knowledge is very limited. guys that know both should do very well.