Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Good news everyone! The Boards.ie Subscription service is live. See here: https://subscriptions.boards.ie/

How to make a training log

13»

Comments

  • Registered Users, Registered Users 2 Posts: 535 ✭✭✭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


  • Registered Users, Registered Users 2 Posts: 61 ✭✭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?


  • Registered Users, Registered Users 2 Posts: 535 ✭✭✭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?


  • Registered Users, Registered Users 2 Posts: 61 ✭✭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.


  • Registered Users, Registered Users 2 Posts: 535 ✭✭✭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)


  • Advertisement
  • Registered Users, Registered Users 2 Posts: 61 ✭✭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


  • Registered Users, Registered Users 2 Posts: 535 ✭✭✭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


  • Registered Users, Registered Users 2 Posts: 5,147 ✭✭✭rom


    bump


  • Registered Users, Registered Users 2 Posts: 44 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


Advertisement