+ Reply to Thread
Results 1 to 7 of 7

Forecasting issue

Hybrid View

BremmesN Forecasting issue 09-19-2017, 08:28 AM
Estevaoba Re: Forecasting issue 09-19-2017, 01:17 PM
BremmesN Re: Forecasting issue 09-21-2017, 04:15 AM
Estevaoba Well, I did it for no... 09-21-2017, 10:17 AM
BremmesN Re: Forecasting issue 09-21-2017, 10:19 AM
Estevaoba Re: Forecasting issue 09-23-2017, 04:46 PM
BremmesN Re: Forecasting issue 09-25-2017, 03:11 AM
  1. #1
    Registered User
    Join Date
    03-20-2015
    Location
    Netherlands
    MS-Off Ver
    Microsoft Excel 2016
    Posts
    12

    Re: Forecasting issue

    Dear Estevaoba,

    Thank you for your quick response! It indeed looks a lot better! I can work with this. I only have one question. What is the reason that you batched the data in groups of 8 and 7? Is it also possible to keep the data in its previous form? My original set of data is in weeks so that I can see the change of sales and forecast weekly sales. Please let me know what you think, feel free to sugest perhaps other (better) methods for forecasting weekly sales data.

    Thank you in advance for your help!

    Cordially,

    BremmesN

  2. #2
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365 Version 2412
    Posts
    1,508
    Well, I did it for no particular reason. It just occurred to me that the original example had far less figures to deal with. So I decided to bring yours closer to that.
    I am no expert, but I thought that maybe you'll find some explanation in the book the method comes from.
    Good luck!

  3. #3
    Registered User
    Join Date
    03-20-2015
    Location
    Netherlands
    MS-Off Ver
    Microsoft Excel 2016
    Posts
    12

    Re: Forecasting issue

    Alright, so you are not familiar with a method that suits my set of data best?

    BremmesN

  4. #4
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365 Version 2412
    Posts
    1,508

    Re: Forecasting issue

    No, I'm not.
    Sorry I can't help you on that.
    Take care, my friend!

  5. #5
    Registered User
    Join Date
    03-20-2015
    Location
    Netherlands
    MS-Off Ver
    Microsoft Excel 2016
    Posts
    12

    Re: Forecasting issue

    Dear Estevaoba,

    Alright, no problem. I will post this thread once more and perhaps someone else can help me.

    Thank you for your help.

    Cordially,

    Bram Nijman

+ 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. MPG forecasting???
    By deletedalien in forum Excel General
    Replies: 1
    Last Post: 08-08-2017, 06:49 PM
  2. Help with forecasting
    By rs1aj in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-08-2015, 04:03 PM
  3. [SOLVED] Forecasting
    By Beach Walker in forum Excel General
    Replies: 1
    Last Post: 07-30-2014, 03:28 AM
  4. HELP - Forecasting spreadsheet issue - day into number?
    By unitedrule in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-09-2014, 08:14 AM
  5. Forecasting
    By usmanfarok in forum Excel General
    Replies: 1
    Last Post: 06-14-2012, 04:17 AM
  6. help with forecasting
    By superspurs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2009, 05:45 AM
  7. Forecasting
    By Brisbane Rob in forum Excel General
    Replies: 3
    Last Post: 10-24-2005, 03:05 PM

Tags for this Thread

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