Home

Metres and Miles

 

 

 

 

 

The FREE target setting Excel spreadsheet for all

 

swimmers, walkers, cyclists, runners, rowers......

 

 

WELCOME

 

Download the latest version of the Excel spreadsheet.

It will help keep your training target firmly in focus all year!

 

My 2016 swim challenge

click each image to enlarge

2016 Leap Year Apology + Fix!

 

If your MY STATS page didn't freeze on the last day - sorry!

 

A Quick fix for Excel enthusiasts is to

  • UNPROTECT your 'My Stats' page
  • change contents of F28 to the number 29
  • SAVE the change

 

 

For Excel novices

  • load your Excel 2016 spreadsheet into a PC or a Mac Excel program - don't use any other gadget or any other app/program

 

  • (never use Apple's 'Numbers' App as it can't cope)!

 

on a Mac:

  • click 'REVIEW' in the green bar at the top
  • then click the 'sheet' symbol just below
  • now click on the square that is in line with column F and row 28
  • immediately type the number 29, followed by return/enter
  • now SAVE in the usual way

 

on a PC:

  • click 'REVIEW' in the blue bar at the top
  • then click the 'Unprotect Sheet' symbol just below
  • now click on the square that is in line with column F and row 28
  • immediately type the number 29, followed by return/enter
  • now SAVE in the usual way

 

 

NB there are some EXCEL version differences, but these hints will help with almost all versions.

M&M 2017

 

 

  • click for FREE download NOW!

 

 

MetresandMiles 2017 (Basic) v1.2

(1-1-17) bug removed - forecast working now

 

 

 

MetresandMiles 2017 (Advanced) v2.2

(8-1-17) yards speed units now sorted

 

For those swimmers who have:

  • a need for more speed,
  • have a need to analyse their swims at different times of day
  • or days of the week
  • several training venues
  • 50 & 25m/yd access
  • open water swims

 

What to do.

  • click on the link to download via Orangdox (as before)
  • enter your target distance (as before)
  • enter your venue codes - see later for examples
  • do your swims and enter distances (as before) and enter venue code and minutes swimming
  • check My Stats page for analyses

 

 

 

 

 

 

 

 

 

 

 

 

New design features for 2017

  • smoother/clearer data entry
  • 'basic' version and new 'advanced' version in the pipeline
  •  

 

New design features for 2016

  • easier to change chart units using 'Excel for iPad/iPhone'
  • 'todays swims' distance included on 'My Stats' page

 

New design features for 2015

  • your target can be set in miles, yards or metres
  • the new target that appears for the NEXT month is dependent on progress so far in previous months.

(BUT with your target for the whole year firmly in focus!!)

  • you can enter data in miles, yards, meters or any combination in any one day!!

 

 

Hints for new users:

 

STEP 1:PC with Excel (2007 or later)

 

  1. download onto your desktop PC and SAVE AS with a new file name (e.g. "Dave's swims 2016"; "Anne's rows 2016"; "Pete's cycles 2016"

 

  1. 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.

 

  1. start entering each training distance 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.

 

 

STEP 1a: MAC with 'Excel for Mac' loaded (New versions only)

 

as above

 

 

 

 

 

Hints for not so new users:

 

STEP 2: Using iPad & iPhone (NOT to be done before step 1)

 

Ipads and iPhones CANNOT import Excel files directly

without messing them up completely!!!!!

 

My Workaround Method - there are other ways of doing this!

 

  • Use your PC to open a free Dropbox account
  • Save a copy of the spreadsheet into Dropbox.
  • Load the free app Excel for iPad into your iPad/iPhone and link it with Dropbox
  • Open the spreadsheet by opening Excel for iPad, then select the Dropbox folder, then click on the spreadsheet you want to open

 

NB

 

  • After entering new training data it is VERY important to either SAVE the data or exit propely from one device before using a different device. This helps Dropbox to know exactly which copy is your latest copy!
  • If you do make a mess of it, Dropbox has an easy way of REVERTing to a previous version!

 

  • The app 'Excel for iPad' is available free and will nearly do everything you need, via Dropbox (or similar Cloud Storage).
  • It cannot use the unit buttons to change the chart units - but you can easily change all of them, on ALL charts, at the same time using the yellow box numbers on the My Stats page.

 

 

 

Remember to Google every time you get stuck with anything - there's loads of help out there

 

 

 

FYI

 

Technology that we are using successfully at home

(there are many other ways of doing this I believe):

 

  • ipads with Excel for iPad app, linked to Dropbox
  • iphone5 with Excel for iPad app, linked to Dropbox
  • iMac + mac Excel, linked to Dropbox
  • PC with Vista + Excel, linked to Dropbox
  • PC with Windows 7 + Excel, linked to Dropbox

 

All devices are able to access the spreadsheet in use, via Dropbox, so that the latest data is accessible from any device.

 

The latest spreadsheet copy is automatically loaded into the memory of ALL our devices - if/as they are switched on.

 

This means it is available to view or enter data on any device at any time we choose anywhere in the world. Brilliant!

 

 

 

 

 

 

 

News:

 

18th Dec 2016 2017 v1.1 available

"2017" added

'basic' version added

 

31st Dec 2015 2016 v1.1 available

"2016" added

new features included

some color corrections

 

31st Jan 2015 News Flash:- CloudOn issues!

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

 

 

 

 

 

 

 

 

 

 

 

Copyright © All Rights Reserved