I am trying to do a little research on my HTH league, where I want to look at how much of a players $ value is in each category.
my league is about 55% offensive budget with a $380 cap. So i did $380*.55 = $42 for offensive budget (rounded up). So i put in an $84 budget and set the balance to 50% value to make sure that $42 were allocated to the hitters. I then checked only the offensive category of interest... i did this for each category, and then compiled the numbers in excel... however, the separate category values do not add up to the the same value if i just run a players value with all 5 categories checked.
for example here are these 3 players
Any idea what I am doing wrong?
my league is about 55% offensive budget with a $380 cap. So i did $380*.55 = $42 for offensive budget (rounded up). So i put in an $84 budget and set the balance to 50% value to make sure that $42 were allocated to the hitters. I then checked only the offensive category of interest... i did this for each category, and then compiled the numbers in excel... however, the separate category values do not add up to the the same value if i just run a players value with all 5 categories checked.
for example here are these 3 players
PlayerID | Lastname | Firstname | OPS$ | SB$ | RUNS$ | RBI$ | HR$ | TOTAL FMV | actual FMV |
813 | Cabrera | Miguel | 12 | 1 | 7 | 11 | 10 | 41 | 64 |
2542 | Braun | Ryan | 11 | 6 | 7 | 7 | 7 | 38 | 62 |
983 | Encarnacion | Edwin | 9 | 3 | 5 | 8 | 6 | 31 | 50 |
Any idea what I am doing wrong?
Comment