I extended the miles spreadsheet, to allow collection of monthly miles per bike and member.
Please have a look at:
https://docs.google.com/spreadsheets/d/1...sp=sharing
Feel free to enter a line per bike of yours and fill in monthly miles.
If you're metric, you may want to enter your kilometers divided by mile, e.g. 580 km as: =580/1.609344 (which is 360 miles).
To keep the table simple, I reduced it to miles, as this forum is located in the USA. (Don't know, why they still have these weird units.)
Don't change colored fields, they are calculated.
Currently there are only 2 month columns: Feb and Jan. I will insert new monthly columns as year goes by. The idea is, to keep the new month at the left side, so we don't have to scroll too much to enter current data.
Please change your `Last Change' field to reflect, when you entered miles the last time.
Hope you like it. Please discuss here, if you've ideas to improve the table.
Enjoy.