by racerfern » Thu Dec 01, 2011 9:51 pm
I want to develop a formula for calculating TSB/CTL/ATL. The purpose will be to come up with a ramp rate for future training with a system I can try to automate. Fit Plan gives me the calculations based on my manual input. Reach Your Goal allows a planner for the future, but I need to calculate the formulas.
For example Today's CTL = Yesterday's CTL + ((today's TSS - Yesterday's CTL) / constant usually 42))
My question is how can I make Calculated Fields look up yesterday's CTL, which of course depends on the CTL the day before that, etc.
Fernando