Mr Hammers World Chat Champion
Joined: 10 Jul 2008 Karma :
|
Posted: 13:32 - 10 Nov 2019 Post subject: Maintenance Spreadsheet |
|
|
Been keeping a maintenance reminder/indicator type spreadsheet for the Triple since i bought it, but finally got it tidied up now so it's nice and clean and easier to read. Thought someone here might like it, so you can download it and change settings to your own preferences.
Basically, the box on the top left is where you put in your current mileage. The unboxed numbers above the green/yellow/red boxes for the parts are the mileage at which the part was changed.
The dates above the purple boxes are the dates you bought the bike, when it's next MOT, tax and insurance are due, and the purple boxes show how many days you've owned it, and days left until your MOT, tax and insurance are due.
The parts boxes change from light green to darker green, to amber, to red, as the mileage increases, and the purple boxes get darker the closer it gets to the renewal dates. You can adjust the change intervals in the conditional formatting section if required, so it changes colour earlier or later.
Planning to add another function under the coloured boxes that will show previous changes, but that'll come later.
Hope someone will find it useful for them too. ____________________ A Guide To Powerbands |
|