Quote:
Originally Posted by NoOne
CSV exports! you can export that data and link a spreadsheet to the files. then as you export each successive time, all you do it open up the spreadsheet and it will ask you to update the data.
then you can do whatever you want to them. note that they are split by conference/league. so AL/NL would need to be added together if you wanted a total. if oyu have dh/non-dh i'd recommend keeping the data separate, and totals only for the fun of it. those sets of data are two different animals and shouldn't be mingled.
i have a thread with one that is set up for "data dumps," which is a different file and location. you can use that to start or make your own. i have the dh in both leagues so it's combined.
back to LTMs
just because it says 5900 and 1.000 doesn't mean it's going to hit that number. think of the 1.000 realted to results, not hte modifier. so if the results i 20% too low, try 1.180 (a little less than 20% increase of that value, which happens to be 1 this time)
the LTM = the result. so if the result is X% different, change the LTM by roughly that amount.
the league total value just tells you how to calculate the % difference. (5900-4300) / 4300. maybe 1.300 to 1.350 ish? that's a steep incline to start. i might even go 1.200 to start out unless it is the only LTM that changes.
in this situation, again i'd sugges hitting autocalc first. your home runs could be off for reasons outside of the LTM specifically for home runs.... hope that makes sense. a ~40% increast is quite large... i'd be wary of that value.
in my experience some of them do not scale 1:1. i find teirs at certain points wear large jumps occur from .. e.g. from 1.243 to 1.244. just .001 difference can on occasion be more than you expect.
|
Ok this is starting to make sense, however I have another situation in my test league. All the modifiers are still 1.000 but I decreased the league total homeruns to 4900 (from 5900) but the actual homerun numbers INCREASED. How?
Also, you said the league total values are just for calculating the % difference so that you can set the modifiers? So they don't really affect results at all (though they seemingly did in my test league)?
edit: just saw your edit. So if I hit autocalc in my actual league, it will change the modifiers in a way that will get numbers closer to what the league totals are set to?