SBR2017 - The Spreadsheet

mossym

How it works

1) First enter your name on the overall sheet, then in the january sheet. Doesn't matter where you enter it on the monthly sheets, next available slot, even if not in the same order as the overall.I'll manually add them to the other sheets once we are up and running
2) In the distance format column in the overall sheet only, enter k(default) or m(miles), depending on how you log your distances. There is no need to do it on the other sheets, it'll carry over automatically. if you chose m, in the detailed columns, enter the distances in m, they'll be converted to km in the totals column. Nothing else is entered in the overall sheet.
3) You will have to fill in the detailed rows in each month, not the total columns. They should be locked. If you don't want to split them out, you can use a single detailed row for each discipline to log everything, so for instance put all the bike miles in the road column if you want
4) The goal you enter in the Overall Sheet will automatically carry over to the months, but if you want you are free to overwrite any month with a specific goal for that month if you wish. For example you may be chasing a PB in a 10k/HM, so your focus for the month may change.
5) For those that enter in Miles, your totals will stay in miles in the detailed breakdown columns, but will be converted to km in the totals columns in each month, and in the totals columns in the overall


https://docs.google.com/spreadsheets/d/1_I2owiRwplThf3D4DpoZ_F6y-CzmkLqFWk7NpmuecoE/edit?usp=sharing

RacoonQueen

Sir, I think someone broke mine

mossym

RacoonQueen wrote: »

Sir, I think someone broke mine

1) First enter your name on the overall sheet, then in the january sheet

we really shouldn't let runners join this, the complication of multiple sports is just way too much and makes them unable to follow the simplest of instructions

RacoonQueen

mossym wrote: »

1) First enter your name on the overall sheet, then in the january sheet

we really shouldn't let runners join this, the complication of multiple sports is just way too much and makes them unable to follow the simplest of instructions

I did!

RTFM

mossym

RacoonQueen wrote: »

I did!

RTFM

Wasn't on the overall tab when I opened it, simple fix,just having a bit of fun

phil

Started logging. First tri season and first time participating in this board. Hoping this helps get me off the couch on the bad days! Here's hoping I'm still here in June!

and still ricky villa

Not sure if it's something I've done or the major drop off in numbers but this isn't calculating for March
(Simple VLOOKUPs are the limit of my Excel talents)

mossym

fixed.