Thursday, November 26, 2020

Downtown Nordic Ski Meter Tracking Spreadsheet

We all know it is tough to stay positive and motivated during the Pandemic.  However, it is likely more important than ever to get outside, breath the fresh air, enjoy nature and ski!!

In order to encourage some of us that are motivated by setting goals and tracking our progress towards those goals, we have created a rudimentary spreadsheet using google sheets that any DN member can use to track their meters skied during the 2020-2021 ski season.  
Users ideally will have a Gmail account and some basic comfort using spreadsheets in order to sign in and use the tracker on Google sheets.

Please use this link to access the Tracking sheet:

When you click on the link the following screen should appear.....

The bright red box on the top right of the screen  says "SIGN UP TO EDIT".  You can use your gmail account to sign in.  

Once you have signed up, you should see a version of the following screen.  You would then go to the next available "Insert name" box in row 1 and replace this with your name.  

Beneath your name in row 2, you can add your season goal for the number of kilometers you hope to ski this season.  

Then its time to ski.  You can then add your mileage in the appropriate row under your name that corresponds to the correct date in column A.

You can also download the Google sheets app for your smart phone to make data entry quick and easy.

Please note that the admin will protect your column such that only you can modify your data.