- Status
Pops, just upgraded to 2007 and all the pivots work just dandy.
Anyone looking to upgrade, you can buy the $125 version (got mine from Costco) Home & Student version (new not the upgraded version) and a very clean oneshot upgrade on top of the old version.
Don't know where they hide the Pivot under the old data menu. Is that the "Filter" thingy?
Anyone looking to upgrade, you can buy the $125 version (got mine from Costco) Home & Student version (new not the upgraded version) and a very clean oneshot upgrade on top of the old version.
Don't know where they hide the Pivot under the old data menu. Is that the "Filter" thingy?
fuck getting all of this shit finished is taking much longer that i anticipated
in the process of adding the team and starting pitcher salaries, we have some pivots for 5 inn that i'm checking now, plus some for humitity etc
suggestion was for me to add whip into the master data and pivot it. my question was to pivot it to what. i dont have a clue as to which variables would have the greatest effect on pivots, plus need to bracket them just too many unique numbers to have any effect on the data. so what would be good brackets (max is 7)
.50 to .70 is this two low
.71 to 1.00
1.01 to 1.20
1.21 to 1.40
1.41 to 1.60
1.61 to 1.80
2.00 to
suggestions if you got em
below is the pdws for tomorrow, 1st game of a series for bal, tor and minn so all new umps at those locations
nite all, back at you in the morning
in the process of adding the team and starting pitcher salaries, we have some pivots for 5 inn that i'm checking now, plus some for humitity etc
suggestion was for me to add whip into the master data and pivot it. my question was to pivot it to what. i dont have a clue as to which variables would have the greatest effect on pivots, plus need to bracket them just too many unique numbers to have any effect on the data. so what would be good brackets (max is 7)
.50 to .70 is this two low
.71 to 1.00
1.01 to 1.20
1.21 to 1.40
1.41 to 1.60
1.61 to 1.80
2.00 to
suggestions if you got em
below is the pdws for tomorrow, 1st game of a series for bal, tor and minn so all new umps at those locations
nite all, back at you in the morning
Last edited:
Quote:
<TABLE cellSpacing=0 cellPadding=6 width="100%" border=0><TBODY><TR><TD class=alt2 style="BORDER-RIGHT: 1px inset; BORDER-TOP: 1px inset; BORDER-LEFT: 1px inset; BORDER-BOTTOM: 1px inset">Originally Posted by jimmy bravo
for thoes getting the sheet from capn.
I suggest you track proj margin of victory. (especially on the road teams)
jb
</TD></TR></TBODY></TABLE>
ML plays from my sheet have been doing great (3-0 again last night). All dogs or small favorites.
Also
I've been doing some analysis of early season scoring compared to past seasons and was a bit surprised at results:
- Scoring is down almost 2.4 runs per game this year (8.30) vs 2006 (10.67) for the first 130 games
- Scoring is down about 1.3 runs vs 2005
Probably the biggest reason for this is the cold in the eastern half of the country but also west coast games seem quite low scoring as well. There is a new order this year from the commissioner's office to store baseballs in a uniform environment (temp of 70, humidity of 50%) but I don't think this would be a major factor. I think scoring should increase as the temperature rises.
Any other ideas for low scoring? Lack of steroids, etc.
<TABLE cellSpacing=0 cellPadding=6 width="100%" border=0><TBODY><TR><TD class=alt2 style="BORDER-RIGHT: 1px inset; BORDER-TOP: 1px inset; BORDER-LEFT: 1px inset; BORDER-BOTTOM: 1px inset">Originally Posted by jimmy bravo
for thoes getting the sheet from capn.
I suggest you track proj margin of victory. (especially on the road teams)
jb
</TD></TR></TBODY></TABLE>
ML plays from my sheet have been doing great (3-0 again last night). All dogs or small favorites.
Also
I've been doing some analysis of early season scoring compared to past seasons and was a bit surprised at results:
- Scoring is down almost 2.4 runs per game this year (8.30) vs 2006 (10.67) for the first 130 games
- Scoring is down about 1.3 runs vs 2005
Probably the biggest reason for this is the cold in the eastern half of the country but also west coast games seem quite low scoring as well. There is a new order this year from the commissioner's office to store baseballs in a uniform environment (temp of 70, humidity of 50%) but I don't think this would be a major factor. I think scoring should increase as the temperature rises.
Any other ideas for low scoring? Lack of steroids, etc.
Thursday April 12th
morning, already go my starts, ready to check mail, chatch up on the thread posts and ready to go. i do know that i'm taking my wife to the casino later this morning for bf, not sure if she will stay and give me a little peace and quiet, but we'll see
i see no thoughts on whip's
ch, regarding low scoring, when i talked our boy J before the season started, he strongly advised betting the unders early. i think last year was a way ov early, 10% higher than the previous avg, but still down vs 2005 is large. overall the pitching appears to be a little better vs last year, more appear to be in playing condition. hell yesterday i had all the 10- under and only one showed, the two other landed on 11, so some games are going over, but it appears to be specific teams vs all teams, and in almost all cases to make it over both teams have to score, and this year in in many of the blow outs only 1 team is scoring the runs so many are not making it
let me get to work, time fly's when your having fun and working your ass off.
later
morning, already go my starts, ready to check mail, chatch up on the thread posts and ready to go. i do know that i'm taking my wife to the casino later this morning for bf, not sure if she will stay and give me a little peace and quiet, but we'll see
i see no thoughts on whip's
ch, regarding low scoring, when i talked our boy J before the season started, he strongly advised betting the unders early. i think last year was a way ov early, 10% higher than the previous avg, but still down vs 2005 is large. overall the pitching appears to be a little better vs last year, more appear to be in playing condition. hell yesterday i had all the 10- under and only one showed, the two other landed on 11, so some games are going over, but it appears to be specific teams vs all teams, and in almost all cases to make it over both teams have to score, and this year in in many of the blow outs only 1 team is scoring the runs so many are not making it
let me get to work, time fly's when your having fun and working your ass off.
later
pops
at espn you can rank the pitchers based on their whip. if you set the minimum innings pitched for the year to 100 innings you would get a sample of about 140 pitchers. this would allow you to get a range for every 20 pitchers. getting an average of what the 20th, 40th, 60th, etc. ranked whip was for the past several years would help to get a more accurate range due to the high degree of variance from year to year. for example in 2000 the 20th lowest whip of 1.25 would have been the 43rd lowest whip in 2002 for all pitchers with at least 100 innings.
since there are 5 starting pitchers per team and 30 teams you might want a larger sample of pitchers. by decreasing the minimum innings pitched to 80 innings you would get a sample of about 180 pitchers.
the one problem with using 80 min innings would be that you would have about 10 to 20 relief pitchers per year as part of your sample. with 100 min innings you get only a couple relief pitchers per year. if you set the min innings to 120 you wouldn't get any relief pitchers and your sample size would end up being about 120 pitchers per year.
i'll get the ranges for you pops just tell me what min innings you want me to use. also, are you using individual whips or total whips for your pivot tables? i hope its individual whips or i just wrote all this crap for nothing.
at espn you can rank the pitchers based on their whip. if you set the minimum innings pitched for the year to 100 innings you would get a sample of about 140 pitchers. this would allow you to get a range for every 20 pitchers. getting an average of what the 20th, 40th, 60th, etc. ranked whip was for the past several years would help to get a more accurate range due to the high degree of variance from year to year. for example in 2000 the 20th lowest whip of 1.25 would have been the 43rd lowest whip in 2002 for all pitchers with at least 100 innings.
since there are 5 starting pitchers per team and 30 teams you might want a larger sample of pitchers. by decreasing the minimum innings pitched to 80 innings you would get a sample of about 180 pitchers.
the one problem with using 80 min innings would be that you would have about 10 to 20 relief pitchers per year as part of your sample. with 100 min innings you get only a couple relief pitchers per year. if you set the min innings to 120 you wouldn't get any relief pitchers and your sample size would end up being about 120 pitchers per year.
i'll get the ranges for you pops just tell me what min innings you want me to use. also, are you using individual whips or total whips for your pivot tables? i hope its individual whips or i just wrote all this crap for nothing.
- Status
