Technical details for MyMaintenanceRecords v1
Requires Microsoft Excel running on Windows. It has been tested at v2010.
Uses Visual Basic for Application (VBA) macros. The first time you open the file you will need to enable Macros.
Can handle an unlimited number of maintenance Items and Tasks
You will have a single user license for MyMaintenanceRecords v1. Once paid and downloaded you can run MyMaintenanceRecords v1 as many times as you want.
The Excel sheets are editable. The VBA macros are protected (cannot be viewed nor changed).
What else can MyMaintenanceRecords v1 do? That is up to you! Contact us if you have any suggestions on how to improve MyMaintenanceRecords v1. We are always looking for hard-hitting ways to extend the programs capabilities in a manner that is important to you.
Click for Tutorial
MyMaintenanceRecords v1 is a spreadsheet (Excel or Google Docs Sheets) based tool that allows you to keep track of all the maintenance task that you need to perform around the house, farm, or business. Too often I forget to do a maintenance task or simply forget when I last did it.
MyMaintenanceRecords v1 keeps track of all that for you.
At the intersection of the Item and Task you simply enter when was the last time you performed that Task; and indicate how many months between each time you perform that maintenance Task.
MyMaintenanceRecords v1 will take care of the rest. It will automatically calculate the number of months since the last time you performed the Task. It will also highlight in yellow when you have reached the number of months between Tasks; and in red when you have exceeded the number of months.
MyMaintenanceRecords v1 is written for Microsoft Excel at version 2010, but should work for other versions. It can also be imported into Google Docs Sheets so the entire family, farm, or business can keep track of maintenance records in one place.