I can draft you something if you want, but it's (fairly) simple.
Create colums for different classes of expenses (fuel, oil, other lubricants, service labour, tires, parts, mods, etc) and then in the rows record each occurence with a datestamp.
Have some more fields off to the side (or better yet, on a different worksheet of the spreadsheet) that calculates totals. You can even add new summary areas as needed (i.e. having a running total to date is good, but after seeing which rows fall within a calendar year, you could have a new cell with a new formula that totals b5-b45, that range theoretically representing a calendar year).
For some extra savvy fun, host a MySQL or MS SQL Express database instance on your home network, and then use a MS Access or OOBase front-end to enter data into the DB. Create a custom report to generate the historical info you require. I thin you can use OOCalc or Excel to manage data entry as well with an ODBC connection - the same one you'll need for Base/Access anyways.
Now that you have me thinking, I may just whip up someting like this for the truck tonight. I'll keep you informed.
Create colums for different classes of expenses (fuel, oil, other lubricants, service labour, tires, parts, mods, etc) and then in the rows record each occurence with a datestamp.
Have some more fields off to the side (or better yet, on a different worksheet of the spreadsheet) that calculates totals. You can even add new summary areas as needed (i.e. having a running total to date is good, but after seeing which rows fall within a calendar year, you could have a new cell with a new formula that totals b5-b45, that range theoretically representing a calendar year).
For some extra savvy fun, host a MySQL or MS SQL Express database instance on your home network, and then use a MS Access or OOBase front-end to enter data into the DB. Create a custom report to generate the historical info you require. I thin you can use OOCalc or Excel to manage data entry as well with an ODBC connection - the same one you'll need for Base/Access anyways.
Now that you have me thinking, I may just whip up someting like this for the truck tonight. I'll keep you informed.
Daily driver 1: 2007 Jeep Wrangler Unlimited Sport "S"
33" BFG Mud-Terrain KM2s, lots of Rough Country gear - bumper, 2.5" lift, swaybar disconnects, Superwinch 10,000lb winch, Detroit Locker in rear D44 axle, custom exhaust, K+N filtercharger, Superchips-tuned.
Daily driver 2: 2006 Subaru Legacy GT
COBB Stage 1+ package - AccessPort tuner, COBB intake and airbox. Stage 2 coming shortly - COBB 3" AT stainless DP and race cat, custom 3" Magnaflow-based exhaust and Stage 2 COBB tune.
33" BFG Mud-Terrain KM2s, lots of Rough Country gear - bumper, 2.5" lift, swaybar disconnects, Superwinch 10,000lb winch, Detroit Locker in rear D44 axle, custom exhaust, K+N filtercharger, Superchips-tuned.
Daily driver 2: 2006 Subaru Legacy GT
COBB Stage 1+ package - AccessPort tuner, COBB intake and airbox. Stage 2 coming shortly - COBB 3" AT stainless DP and race cat, custom 3" Magnaflow-based exhaust and Stage 2 COBB tune.