Metres and Miles
The FREE target setting Excel spreadsheet for all
Welcome Back!
Grrr... not a good year for any of us I guess.
Lockdowns to try to control the spread of covid19 have hit everyone hard in the UK and elsewhere.
As you can see from my 2020 chart below, several months with either no swims or reduced wet time have made training sporadic at best.
(I failed to hit my target even after halving it back in July)
However, walks/dogwalks, golf, gardening and rowing machine have all helped to keen me reasonably fit and sane throughout.
The start of 2021 is going to be hard for all until vaccinations are completed.
At some point we will return to pools to train and compete again!
Until then stay safe everyone.
Happy New Year.
wet days of the week display
improved current year vs previous year's chart
'average speed check' chart bug swatted
"2016" added
new features included
some color corrections
Cloud On is dead in the water - long live Excel :(
5th Jan 2015
2015 v2.1.1 available
unit selection activated for MACs
31st Dec 2014
2015 v2.1 available
"2015" added
31st Dec 2014
2015 v2.0 available
extra features added
20th Dec 2014 2015 v1.4 available
chart corrections made
15th Dec 2014
2015 v1.3 available
13th Dec 2014 '
new version' beta available
(+ Dave's example sheet)
9th Dec 2014
2014 download available
M&M 2021
2021 Version includes no changes:
What to do next:
1. To avoid disappointment read and use the 'Hints for New Users' -see below
2. Click on the link above to download and SAVE the new M&M onto your desktop computer, then OPEN the file into Excel.
3. Enter your target distance - click on your choice of units
4. Optional: enter your choice of venue (or swim location) codes - you have total freedom of choice here and can change your mind later too!
5. Do your swims - enter distances - Optional: enter venue code and estimated minutes swimming/getting wet!
6. Check the My Stats page for analyses - see how close to the target swim line __ you are.
7. Optional: Enter your previous years swim totals (on the JAN page) - and see where your new this year's forecast is taking you :)
8. these 2 images show:-
(above) my previous years (2018 not completed)
(right) how they display on the 2019 MyStats page
NB - this will change once the new year gets started
with the 2018 data included!!
New design features for 2021
New design features for 2020
New design features for 2019
GoogleTranslatorisms!
chart experience!
New design features for 2018
New design features for 2017
New design features for 2016
New design features for 2015
(BUT with your target for the whole year firmly in focus!!)
Hints for new users:
(someone not sure how to open an EXCEL file on their device)
STEP 1:PC or MAC with MS Excel (2007 or later)
1. download the file above onto your desktop PC or MAC and SAVE AS with a new file name
(e.g. "Dave's swims 2019"; "Anita's rows 2019"; "Pedro's cycles 2019"
2. set a target for the year on the 'My Stats' page, revisiting it several times in the first month or so if you are not sure the level to set it at first time. entering 'venue codes' are optional
3. start entering each training distance ('venue codes' and 'times' are optional ) for each day of the month and then check on your progress on the 'My Stats' page
*Experienced users will probably want a copy to be saved in the cloud to access from anywhere, on any device - see my solution below if you haven't done this sort of thing before
Hints for not so new users - using mobile devices:
STEP 2: Using iPad & iPhone (NOT to be done before step 1)
Ipads and iPhones CANNOT import these, highly formatted, Excel files directly
without messing them up completely!!!!! - try it and see !
You will need to use Excel for iPad or Excel for iPhone
My Workaround Method - there are other ways and other clouds to do this!
NB
Remember to Google every time you get stuck with anything
- there's loads of help out there
FYI
(there are many other ways of doing this I believe):
Copyright © All Rights Reserved