So... as mentioned earlier, I tried to create a way to calculate TPE in spreadsheet form based on player attributes pasted from the sim (because then it's really easy to show the TPE leaders based on various criteria) but I'm seeing a lot of numbers that don't match up between the sim and update threads...
If updaters keep track of player stats (including fractional stats and banked TPE) in a central sheet, it's relatively easy to add a formula to that and get total TPE. Then add a separate lookup to calculate base TPE and find the difference.
This is the method I tried, but I don't have time to go through every player profile myself and update banked TPE and fractional stats, and I can't rely on taking stats as listed in the sim. Though I suppose my attempts have highlighted a few apparent errors in the listed stats in the sim. Adam Bennett, for example. He appears to have the wrong STR, INT, PBL and RBL stats listed in the sim.
This is a trimmed down version of what I have so far:
https://docs.google.com/spreadsheets/d/1CoT...dit?usp=sharing
If updaters keep track of player stats (including fractional stats and banked TPE) in a central sheet, it's relatively easy to add a formula to that and get total TPE. Then add a separate lookup to calculate base TPE and find the difference.
This is the method I tried, but I don't have time to go through every player profile myself and update banked TPE and fractional stats, and I can't rely on taking stats as listed in the sim. Though I suppose my attempts have highlighted a few apparent errors in the listed stats in the sim. Adam Bennett, for example. He appears to have the wrong STR, INT, PBL and RBL stats listed in the sim.
This is a trimmed down version of what I have so far:
https://docs.google.com/spreadsheets/d/1CoT...dit?usp=sharing
I impersonate a programmer for a living
Father of the League Wiki • Friendly Neighbourhood Angry Black Guy™ • NOT British
Originator of the Sim League Cinematic Universe (SLCU)
Super capitalists are parasites. Fite me.
Alternatively, if you agree, you can support a grassroots movement dedicated to educating and organising the working class by buying a digital newspaper subscription. Your support would be greatly appreciated.
