I’m working on a training log spread sheet using an example from off the web. I have the mileages logging working well. It gives all kinds of averages and totals etc.
The mileage worksheet contains a column for weight. So I found some info on graphing weight which has the type of info I’m looking to computer given any days weight. BUT i’m getting stuck on the Total loss column.
The author of the original sheet seems to have cheery picked data and kinda cheated on how to handle days where there is not date.
I really like the approach of this sheet/chart because it tracks a 5 day rolling average.
I could just drop out the weight tracking. There are plenty of dedicated weight tracking spreadsheets, programs, and online tools for tracking weight.
Anyone got the chops and interest to get the weight sheet working?
For anyone else I have a bunch of spreadsheets downloaded for tracking mileage and for tracking weight. If anyone wants a big ball of these files just let me know.
Just let me know what kind of archive you prefer.
I’ve attached the summary box to give you and idea what I’m up to.
Below this is some pretty basic graphs.
Also attached it the weight calculation sheet. This sheet picks up the weight from the training log so the weight gets entered only in one place.
Like I said, I like this one because it does the 5 day moving average which even out the day to day fluctuations.
Let me know what you guys think and if someone wants to contribute with some help on the weight portion let me know.
When it’s done i’ll make this available to whoever wants it.