Can anyone make a spreadsheet with the bold face equation?
Begin this process by measuring your performance across two distances. For example, you might measure your time swimming 50 yards and 100 yards. You can then project your time for additional distances, such as 200 yards, 400 yards, 800 yards, and 1,600 yards using the following equations:
t(x) = T1 x (T2/T1)
where t(x) = predicted time for distance ðs (distance for which you want to predict a time) T1 = time for test 1 (the shorter test, or 50 yards in this case) T2 = time for test 2 (the longer test, or 100 yards in this case) D1 = distance for test 1 (50 yards in this case) D2 = distance for test 2 (100 yards in this case) LN = the natural log You can use the same calculations for power by substituting average power over a given distance for time. The calculations use the natural log because velocity and power decay in an exponential function. To complete them rapidly, you would need to either use a calculator that performs natural log calculations or design a spreadsheet to do so. The Excel spreadsheet will manage this quite nicely. In a natural log function, the percentage of reduction in velocity or power for each doubling in race distance can be expressed as a constant, which is referred to as the fatigue rate. It is calculated using the following equation, assuming distance 2 is twice as long as distance 1: T2 − / T1 ðs 100