forecasting

  1. M

    Scaling a “Check Point” x “% used” data table to fit a smaller range.

    I need some help having a macro or something that can take a data set (45 check points = X and % stock used = Y) and it’s bell curve, compress it to fit a smaller scale such as 1-15 checkpoints and maintain the bell curve shape. I want to type in a stock amount and weeks and it spits out a new...
  2. B

    Forecasting from two business sites on one output, is this possible?

    Hi all, I have a simple table like the below. I'm looking to forecast both sites at once if possible on one output. When I select the whole range and select 'Forecast Sheet', it only selects Site B e.g. the bottom row. I assume it is possible to forecast both Sites at once, or indeed any number...
  3. H

    Avoiding INDIRECT when referencing and comparing ranges in different workbooks

    I work in Finance and have a QoL-issue with excelling daily. I use INDIRECT and SUMIFS constantly when comparing figures. Oftentimes it's about comparing latest estimates with previous forecasts or budgets in an earlier instances of the same file (although with a different name)...
  4. Y

    Forecasting using past and current year

    I know there's a way but I'm drawing a blank on best approach and method. I have one rolling year of data so say July 2019 to June 2020. However, on the report I'm only showing year to date so January to June. What I'd like to be able to do is from July to December provide a projection based on...
  5. V

    Forecasting date based on current performance & targets

    Hi All, Thanks for reading!! I want to predict date or week number based on the current performance measured against target: Col A : Week Number Col B : Target (Number) target is 500 and each week target is to complete 20 (so 20, 40, 60, 80, and so on till 500) Col C: Actual completed number...
  6. King Mustard

    Forecasting the next number in a list?

    Is there a formula that I can put next to the final date that will "forecast" the number? My car contract allows 12,000 miles per year and I'm checking if I'm estimated to hit it.
  7. C

    Forecasting

    Hi I'm trying to forecast my unit sales for the following year. I have last years data but I'm at a loss as to where i begin. My data is below along with what i expect the market changes to be. <colgroup><col><col span="12"></colgroup><tbody> Monthly Data Jan Feb Mar Apr May Jun...
  8. A

    Forecasting Quantity in Sales

    I have a product for which units sold in May is 12420, Jun is 1200, and Jul is 12400. How can i forecast that how many units will be sold for the next 12 months?.
  9. G

    Forecasting Opening and Closing Inventory

    Hello all, new to the forum. I have an issue with powerpivot/DAX that I have not been able to solve. I hope someone is up for the challenge... The problem is calculating a YTD monthly Inventory closing position while ignoring cumulative negatives if there is no stock to satisfy the forecast...
  10. T

    Dynamic update of the database when you change the linked cell?

    Hi, all I am a new user and novice without VBA knowledge. The hardest formula I can use is about Index/Match so please be nice :). I am looking for a solution which does below; 1. A cell which looks up a value from a separate tab. I currently do this by index match. (ROW10 SUPPLY FCST key...
  11. C

    Forecasting help

    Hi, I'm having trouble with this problem Construct a forecasting worksheet to calculate: 1. the number of new clients each month, and 2. the total client base (cumulative number of clients signed up) each month. In your model, make projections for 60 months (Periods) for the two scenarios...
  12. H

    Excrutiatingly slow insert/delete times using table and defined names

    I have a file that is taking longer and longer to insert/delete/move cells/columns/rows now up to at least 10 minutes EVERY SINGLE TIME! I have tried absolutely EVERYTHING that I can find and am at my wits end. I started from scratch to create a budget model that would provide forecasting...
  13. K

    Forecasting and Capacity Analysis for Future Dates, Projects, and Resource Names

    Hi guys, I am running into circles with trying to figure out this issue. I am wanting to automate our current capacity planning tool for my team and want to generate some sort of forecasting ability with the forecast formula. I have heard that the newer versions of Excel contain the forecasting...
  14. J

    Forecasting Raw Material Pricing

    With recent economic and market conditions (eg. tariffs), raw material and commodity prices have fluctuated. Some, such as steel (purchased scrap), have fluctuated significantly. If I want to use a formula for raw material pricing, does anyone suggested a specific "forecast" formula. I am...
  15. H

    Forecasting Curve Distribution

    Hello, I am working on a forecasting model and have run into some trouble when trying to extend the X-Axis of a 12-month Curve Distribution to a longer time frame. Given a distribution of 12 percentages (one for each month), how can I spread the 12 months or periods to say 18 months while...
  16. S

    Forecasting Accuracy Model

    Hi all, First time posting so apologies if I'm not overly clear. I've been set a task that is bending my brain a little bit - The document has 3 tabs - Historical Calls, Forecast Calls, Accuracy -Historical Calls - actual data -Forecast Calls - historical data which is either like for like...
  17. A

    Cumulative sales Forecast Formula

    I have a year end sale figure of £80,000 and want to divide this between 12 months in way that starts from Jan to Dec, and the Jan Sale not to be less than £4,000 and each month the sale increase slightly with a few fluctuations in Sep, Feb and March when there is seasonality and the sales are...
  18. P

    Forecasting & Predicting Data

    Dear All, First of all sorry if this has been answered somewhere else also I am a newbie so sorry if I'm wasting your time. I'm currently analysing data for my School. I have two questions: <colgroup><col span="22"></colgroup><tbody> Art <tbody>...
  19. V

    Simple conditional output failure aka Prediction Interval Testing - should be an easy VBA fix

    I do a lot of forecasting and am tired of having to repeatedly write a formula from scratch to test whether or not my forecasts fall within the prediction interval. To be clear what I mean, is that I may predict a value of 1,000 with an 80% chance it will be within 900 and 1100. I need to test...
  20. P

    Best Way to Forecast with this Data

    Hi - I need help determining the best way to forecast for the following year end forecast value. The 'Xs' represent the data I have available to me to leverage. Ideas??? Thanks!!! <tbody> Months: 1 2 3 4 5 6 7 8 9 10 11 12 Total 2018 x x x x *FORECAST* 2017 x x x x x x x x x x...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top