So here's the thing. I've got "engineering room log" sheets.
There's one log per week
"start numbers" are equal to the "stop numbers" from the previous week.
hours run is subtraction of stop-start hours
hours run gets added to the previous week for lube oil, if there wasn't an oil change.
same goes for filters, unless they get changed, then the number gets reset to some small number (changed out on Wednesday, 12 hours put on between Wednesday and Friday, so the number will be 12)
Basically, it's a repetative process that lends itself to easy compounding errors. The exact sort of thing computers should help with, right?
I'm looking for how to electronify this process using Excel. I thought of making a single xlsx document with 52 sheets. One sheet references the previous sheet. Then I got into a VBS script that would increment dates across sheets. 1/8/15-1/14/15, 1/15/15-1/21/15 etc...
Any help would be great.
drew
WNHJkXks.jpg IdW120cs.jpg
Bookmarks