[NoOne]

ugh, they have to be zip files, LoL... why?!?

i removed any yellow background on cells you do not need to use. All yellow background cells on the Input worksheet must be filled in. (actually in your case the current LTMs arent necessary to fill in due to what i explained in the previous post, but you can put them in if you wish). Do not touch any other cell's contents. the only other thing you will ever adjust outside that input worksheet is the table size on the "Work" worksheet to accomodate the correct amount of years.

the "adjusted" section of the Work worksheet is scaling the LTMs that also have totals listed for them in the league settings. this is so that you can compare apples to apples. e.g. 4500hr with 150,000ab is not the same as 4500hr with 148,000ab. this adjusts them to an even scale. the raw data is at the far end of the table.

if you didn't make majore adjustments to your LTMS (guessing <.010 changes???), you might get some half-way useful info from the suggested new mods. however, apply what you changed... e.g. if you incresed HR, take a little off the new suggestion for HR LTM.

okay, both are labeled with the years. ***1900-1949*** and 1950-1953

everything is set, if it asks to update links, say no. only update them if there is new data to use. (use the 1900-1949*** file for that)

the 1950-53 i did sloppy and fast, don't allow it to update the links when you open it up in openoffice calc. (if you use excel, hopefully it works, lol, otherwise download apache openoffice). it will be tougher to re-use this file, because of how i adjusted it.

keep the 1900 one for future use. put it and the 3 csv files in the same directory and each time you export new stats, copy them over those 3 files. once you open the spreadsheet it should ask if you want to update links... do so and you only have to adjust the table size on the worksheet to account for the correct amount of years.

since you sent 50 years, it's set for 50 years at the moment. add or remove entire rows within the table to adjust its size (add/remove 2 rows per year). never remove the first or last row of the table. highlight 1 row of data and 1 empty line and "Fill" down/up. use help for info on Fill function in your spreadsheet program if you are not familiar. it's that easy to adjust the size of the table... starting at a different year than year 1 of data is a bit trickier. highlight and drag the new 'starting' year to the first row, then fill down as described above. do not copy/paste, it will not work right. to start at an earlier date, click and drag the first year down X number of years you want to start earlier and fill up from there.

all formulas will adjust automatically if you do this process right. make a back up and play around with it until you are comfortable.

there are instructions on how to use it as well as a general strategy to adjusting LTMs. they more LTMs you adjust at one time, the less likely you are to get the results you want. the order in which i suggest setting them is not perfect.

there is some useful info (min/max/avg) from the Work worksheet that i should have on the input page (really should be "Input/Output"). if you want somem visual feedback on varous stats, make some line graphs.