How to make a training log

jmcc99_98

Anyone on here be able to help me with the calculating problem I am having above if I were to share the document with them.

It is wrecking my head!!

I am using a dropdown box for different sports, but the weekly and monthly totals are for all sports, I would like a split between cycling and running. So my weekly and monthly totals would add the distances where cycling is in the dropdown and give me that total but also do the same thing when running is in the dropdown

Brewski78

I have a Summary tab which does this, was based on roms original shoes formula, I'm happy to share mine with you if you'd like to take a look?

jmcc99_98

Brewski78 wrote: »

I have a Summary tab which does this, was based on roms original shoes formula, I'm happy to share mine with you if you'd like to take a look?

Yeah that would be great, I used Roms instructions regarding the shoes but I can get it to auto calculate distances for me based on running and cycling.

Can I PM you my email address?

Brewski78

Yeah of course. I had to tinker with the formulas slightly to get it to work so hopefully you can take the formulas from my sheet and it should work for you.

jmcc99_98

Thanks Brewski, your spreadsheet set me on the right road but Grrrrr, I have the weekly totals for each sport but have to manually put in each range.

I have tried to merge the IF A=0 (eg cycling) and the formula that adds the distance between two specific dates but can't manage it)

Brewski78

Sorry it wasn't quite what you were looking for, have wracked my brains on a way to do same but can't figure it - will keep plugging away and see if something clicks. At the moment all I can think is to copy and paste values of the summary sheet at each month end but obviously not ideal, and not practical to do weekly

jmcc99_98

Brewski78 wrote: »

Sorry it wasn't quite what you were looking for, have wracked my brains on a way to do same but can't figure it - will keep plugging away and see if something clicks. At the moment all I can think is to copy and paste values of the summary sheet at each month end but obviously not ideal, and not practical to do weekly

Not at all, it has gotten me very close to getting the correct formula, I just need to work out how to merge the two sets of formula i.e. give me the distance and time between two set dates if the sport = "X"

Thanks again

rom

bump

gaz200

this is great rom, have tried a few times but keep getting an error with the pace but will keep playing around with it