Results 1 to 7 of 7

Thread: I need some inspiration!!

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Neophyte jaydp's Avatar
    Join Date
    Sep 2019
    Posts
    3
    Articles
    0
    Excel Version
    2007

    Talking I need some inspiration!!

    Hi my boss has asked me to create a monthly report on the usage of one of our departments basically a footfall. so he wants to see the Peaks and Troughs of the department.
    I am looking at something that will show the following;-

    Type of customer (Only 2)
    Date
    Time in
    Time out

    the dashboard should show something like a 6am to 8pm graph peak periods and total customer usage based on the 2 types. does anyone have a template I could start with? or an idea?

    my thoughts are to create a database entry form on sheet 1, with the database on sheet 2 and a report with graphs etc on sheet 3.

    I need this to be simple as the staff maintaining this are non excel users, and I will be the only one who would generate the report to submit to management.

    any help ideas I would be grateful for

    Thank you

  2. #2
    Conjurer Ed Kelly's Avatar
    Join Date
    Jul 2016
    Posts
    164
    Articles
    0
    Excel Version
    2016
    Jay,

    Make our life easy and give us about 15 lines of data Raw in the exact format that you will receive it. And of course sanitize it if sensitive. Without actual data, everything takes much longer

  3. #3
    Neophyte jaydp's Avatar
    Join Date
    Sep 2019
    Posts
    3
    Articles
    0
    Excel Version
    2007
    Hi Thank you for coming back to me, I have started the project I am not sure if I am over complicating it but I have attached the excel workbook here. A simple database to collate the information using a input form (VBA based I cannot seem to get the time inputs to work properly,) sheet 3 will have the dashboard or reports facility. any help would be appreciated to finish this project
    Attached Files Attached Files

  4. #4
    Conjurer Ed Kelly's Avatar
    Join Date
    Jul 2016
    Posts
    164
    Articles
    0
    Excel Version
    2016
    Jaydp, apologies just back in the site, 3 pages no data. Data please.

  5. #5
    Neophyte jaydp's Avatar
    Join Date
    Sep 2019
    Posts
    3
    Articles
    0
    Excel Version
    2007
    I Ed I have posted the worksheet which I have started, Thank you in advance for taking a look

  6. #6
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,680
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Administrative Note:

    We don't expect you to bump threads more than once in 24 hours - it has been only a couple of hours since you posted. Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.
    Thank you Ken for this secure forum.

  7. #7
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,680
    Articles
    0
    Excel Version
    2010 on Xubuntu
    We would very much like to help you with your query, however the thread title does not really convey what your request is about.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    As you cannot edit your title, please post a suggestion, I will change the title

    Thanks
    Last edited by Pecoflyer; 2019-10-13 at 10:03 AM.
    Thank you Ken for this secure forum.

Posting Permissions

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