+ Reply to Thread
Results 1 to 4 of 4

Build an averaging style calculator?

  1. #1
    Registered User
    Join Date
    09-05-2017
    Location
    Australia
    MS-Off Ver
    2007
    Posts
    33

    Build an averaging style calculator?

    Hi all,
    I would like to build a calculator that does the following.
    If I put a row of sales by the hour in column A. First being 10am second being 11am all the way through to 9pm.
    These would be last years sales. I can setup a formula so if I enter a figure into column B next to one of last years numbers then I can get a percentage variance. That's about as skilled as I am at excel.
    What I would like to be able to do is have a calculator setup so I can enter all the last years figures and then have a cell I can enter current live sales at a particular time and if I enter the particular time in another cell then the calculator will give me a percentage based on projecting the average between the two closest hours. Eg. If 12pm last year was $5000 and 1pm was $7000 then if I entered $6000 at 12:30pm this year the calculator would say 0%.
    Hope that makes sense.

    I'm also thinking if I can get this to work I could just enter the daily total for last year and work out a trading history by percentage per hour so the hourly marks would have percentages added.

  2. #2
    Valued Forum Contributor spitfireblue's Avatar
    Join Date
    01-29-2015
    Location
    Adelaide, Australia
    MS-Off Ver
    2007,2010,2016
    Posts
    611

    Re: Build an averaging style calculator?

    Hi,

    Try this.

    The light grey cells are formula's.
    Enter your data in the white cells.
    Attached Files Attached Files
    Regards,
    Stephen

    If you feel someone has helped you please thank them and click on the star on their post to add reputation.
    Please ensure that you use code tags where relevant, and mark solved threads as solved.
    Most of all please be respectful and understanding of others.

  3. #3
    Registered User
    Join Date
    09-05-2017
    Location
    Australia
    MS-Off Ver
    2007
    Posts
    33

    Re: Build an averaging style calculator?

    Awesome thanks for that Stephen.
    For some reason the bit on the side where you can put the specific time and sales doesn't
    seem to work when I import to numbers or excel apps on my iPad. It's showing it works in the safari browser though. Is it likely to work on my PC?

  4. #4
    Valued Forum Contributor spitfireblue's Avatar
    Join Date
    01-29-2015
    Location
    Adelaide, Australia
    MS-Off Ver
    2007,2010,2016
    Posts
    611

    Re: Build an averaging style calculator?

    It will work on your PC. The only thing to watch out for is keeping the formatting of the time the same.
    You can download MS Excel on your iPad but I have only tested it on PC so I'm not 100% of the difference in functionality.

+ 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] Transform Data From Pivot Style to a Table Style
    By The_Snook in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-18-2016, 04:13 AM
  2. Complicated averaging-- averaging data that matches certain intervals
    By atung in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 10-22-2014, 04:19 PM
  3. Replies: 2
    Last Post: 04-10-2014, 12:15 AM
  4. Normal Style to No Spacing Style by default.
    By dogberry in forum Word Formatting & General
    Replies: 1
    Last Post: 12-23-2012, 11:48 PM
  5. Replies: 1
    Last Post: 02-02-2011, 08:10 AM
  6. Help to build a working day calculator
    By jordan.lawrance in forum Excel General
    Replies: 11
    Last Post: 12-09-2009, 12:06 PM
  7. [SOLVED] Integrated calculator in excel 07 instead of separate calculator
    By Wayne in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2006, 11:20 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