John E Davies Posted August 9, 2018 Share Posted August 9, 2018 EDIT 08/11/18 Uploaded a (corrected) Numbers Revision 01 file and a (new) Excel Revision 01 file. Note: I will keep any future major updates or important comments in this first post. I do not want for them get lost in subsequent replies. If you are at all familiar with Excel or Numbers, this may be helpful. I was keeping my records in a variety of forms, and the data was getting increasingly messy and hard to interpret, so with the help of my wife I now have an all-in-one spreadsheet that I can update on-the-fly, as long as I have an internet connection. I back it up in the Cloud, so I can do data entry from my iPad at a campsite as easily as I can from my iMac at home. It has four tabs or sections. The first is the Trip log. The Date column "self-formats" so all the dates look alike. The Total column automatically updates when you enter the Trip (daily) number of miles. Don't mess with the figures in the TOTAL column. [attachment file=Trip log capture.png] The second tab is the Service Schedule/ Tech page. I have service reminders (stuff I need to do soon), torque values, service info and my Squawk List (aka the "Honey-Do List") - stuff I either want to or need to address, eventually. [attachment file=Service Tech Capture.png] The third tab is the actual Service Record, which includes all routine work, repairs, and mods. I did not include extra columns for cost and detailed lists - I summarized since a future owner would only need that rough data. The paper records are there if I need to get down to small part costs. [attachment file=Service Record capture.png] The last tab is an Inventory section, for me to keep track of loose stuff that is carried in the trailer, in case of loss. [attachment file=Inventory Capture.png] The sample file, which includes the data shown in the screen captures above, but not all my history, can be found at my Dropbox page. Follow this link for the NUMBERS file: https://www.dropbox.com/s/u4fmo7ko7oxde6y/DAVIES%20SAMPLE%20RV%20LOG%20Serv%20Rec%20Inv%20REV01%20%20NUMBERS.numbers?dl=0 Follow this link for the EXCEL file: https://www.dropbox.com/s/07kvpx7u1d9l7bc/DAVIES%20SAMPLE%20RV%20LOG%20Serv%20Rec%20Inv%20REV01%20%20EXCEL.xlsx?dl=0 I strongly suggest that you save your file as a Master, duplicate it and work with the copy in case you mess up some how. Change all the entries and headers as you see fit. I hope it is useful to some of you. The first and third tabs print very nicely in Landscape, the other two work in Portrait. Use the "Fit to Page" option, print one tab at a time, and they will all stay on one printed page, so they are easy to read. Please let me know if there are any problems downloading or opening the file. I know very little about spreadsheets, but way more than I used to ;) John Davies Spokane WA 10 "Mouse": 2017 Legacy Elite II NARV (Not An RV) Two Beds, Hull Number 218, See my HOW TO threads: https://olivertraveltrailers.com/topic/john-e-davies-how-to-threads-and-tech-articles-links/ Tow Vehicle: 2013 Land Cruiser 200, 33" LT tires, airbags, Safari snorkel. Link to comment Share on other sites More sharing options...
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now