View Single Post
Old 10-24-2015, 04:26 PM   #48
NoOne
Banned
 
Join Date: Apr 2015
Posts: 7,273
Infractions: 0/2 (4)
Quote:
Originally Posted by Klew1986 View Post
It's a fictional league. I have simmed from 1900 through the 1953 season. I started with 16 teams and am now up to 20 teams. Attached are the three excel documents you need. They have built in headers. Let me know if you need anything else.

I know I probably shouldn't have, but I was adjusting League Total Modifiers as I simmed. I would only change them every 5-10 years. So numbers might be a little off.

Attachment 424325
Attachment 424326
Attachment 424327

Edit: i'm working on it as i type, so i'll post a reply soon.

okay, some issues i see ...

1) one this spreadsheet is setup for a static number of teams... it would take some persnalized edits to account for the change in # of teams each time it occurs. # of games and number of teams will need to be accounted for.

2) if you changed LTMs throughout, there is little information to glean from this spreadsheet. it's purpose is to make a change after enough years of data are collected.

*there is nothing wrong with adjusting LTM, don't get me wrong. if you haven't centered your stats around a baseline of your choosing, there's nothing else you can do but alter them on occasion or use autocalc. this is the path of least resistance that you may want to take. it's easier.

i'll send back 2 spreadsheets, nonetheless. just don't put too much weight into the suggestions, because of the 2 reasons i listed above. the data is tainted, so take it as a grain of salt.

Last edited by NoOne; 10-24-2015 at 05:35 PM.
NoOne is offline   Reply With Quote