+ Reply to Thread
Results 1 to 7 of 7

Help with page after page of simple numbers

  1. #1
    Registered User
    Join Date
    01-31-2015
    Location
    USA
    MS-Off Ver
    2003
    Posts
    5

    Help with page after page of simple numbers

    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

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Help with page after page of simple numbers

    Hi, welcome to the forum

    Yes, this does sound like a job for super maaaan....ooops soeey lol I meant for excel

    However, have you looked at those 2 pics you uploaded?

    Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
    Also, not all members can upload picture files (Company firewalls and stuff)

    Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

    Not sure I would advise a sheet/week though, excel works best when all data is entered into 1 "data base" sheet, and then all summaries are run from that
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    01-31-2015
    Location
    USA
    MS-Off Ver
    2003
    Posts
    5

    Re: Help with page after page of simple numbers

    Ah yes, that makes sense. Thank you. Here is an attachment of the work I've done so far. I opted for a 'macro enabled' version of it so I could use this code:
    function =AddSequentialDate("f3",F3)
    which is this (from alt-F11)

    Please Login or Register  to view this content.
    Now if I was a dude surfing the internet, I would avoid downloading a "macro enabled" workbook. So I'll attach a non-macro-enabled copy too.

    A brief English explanation of what I'm going for here. n the tug boat, we've got various engines aboard. Each of them has a preventative maintenance schedule where when the engine hours add up to a certain amount, I'm supposed to change the oil, or the filter, or both. There are multiple engines, multiple run hours, and various tasks. In the first post you can see a couple of photos of the actual carbon copy logs we use where the numbers from the previous weeks form get copied over to the current weeks form: Hour Meter Stop (previous week) to Hour Meter Start (current week).

    I was doing these forms and was thinking: man this is the perfect job for a computer to help me with. My Excel ineptitude and your guys guru-ness is what brought me to this forum.

    Another side note, I just listened to Plant Money's "Excel!" podcast. It was brilliant, and I have revitalized energy to post here and chase down a solution!

    http://www.npr.org/blogs/money/2015/...6-spreadsheets


    ENGINE ROOM LOG v1.xlsm
    ENGINE ROOM LOG v1.xlsx

  4. #4
    Registered User
    Join Date
    01-31-2015
    Location
    USA
    MS-Off Ver
    2003
    Posts
    5

    Re: Help with page after page of simple numbers

    Anyone have any other thoughts on how to tackle this spreadsheet problem?

  5. #5
    Forum Contributor
    Join Date
    07-30-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    121

    Re: Help with page after page of simple numbers

    Having been involved in Preventative Maintenance programs before, I suggest this would be much better handled by Access or a similar database program. Facility codes for each unit, triggered queries based on Date Start/Date Stop, preventative maintenance schedules automatically printed out and signed off back into db.

  6. #6
    Registered User
    Join Date
    01-31-2015
    Location
    USA
    MS-Off Ver
    2003
    Posts
    5

    Re: Help with page after page of simple numbers

    Yeah, that's sorta what I thought. I'm going for the Google Drive option here. We'll see how it goes.
    Thank you for your reply.

  7. #7
    Registered User
    Join Date
    01-31-2015
    Location
    USA
    MS-Off Ver
    2003
    Posts
    5

    Re: Help with page after page of simple numbers

    It's going horribly. Between MS Office Online, and having to re-learn all that is and is not possible with Google Documents, I've made zero progress.

    Maybe having 52 sheets is the way to go? Looking for some more help here folks. thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Vba code to start page numbers from current page (bottom of the pate right side)
    By satputenandkumar0 in forum Word Formatting & General
    Replies: 2
    Last Post: 04-04-2014, 01:09 AM
  2. Get total pages per sheet and set page numbers in page footer by formula
    By Snoopy2003 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-13-2013, 04:00 PM
  3. Yes/no drop down list needs to populate a contents page with matching page numbers
    By limebaish in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-19-2013, 02:46 PM
  4. Using Section Page Numbers and Document Page Numbers In Footer
    By janschepens in forum Word Formatting & General
    Replies: 2
    Last Post: 03-16-2012, 01:54 PM
  5. Mail Merge page numbers issue on 1st page only
    By Internoob2 in forum Word Formatting & General
    Replies: 1
    Last Post: 09-22-2011, 10:35 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1