How to design user friendly forecasting tool minimal input required

MrCool888

New Member
Joined
Sep 23, 2021
Messages
2
Office Version
  1. 365
Platform
  1. Windows
Hi team,

I have created a quite basic overview tool in Excel where assigned people should populate what they think the outcome of some event is, e.g. number of monthly obsolete ice creams in an ice cream truck. The base "forecast" for future months is the average outcome of the past 3 months, and the user can either report increases or decreases based on the best knowledge available - in order to visually represent the forecast without (orange line) and with reduction efforts (blue line). Reduction efforts could be, in this case, e.g. by buying smaller ice cream batches, better sales forecasting, buying a better fridge, etc.

Questions:
  • What is the easiest way for users to perform such input in Excel? Currently, I use 12 rows to the right of months with default value = 1 (100%) which users could manually change to reflect changes in absolute values. But I suspect it's not an ideal approach directly... (asking as there will be hundreds of such rows as in this example)
  • How to most easily capture and display the orange line, assuming we want to avoid users having to populate two rows per item? The blue one is easy as it incorporates all forecasted input, while the orange one needs to exclude the reduction efforts in a smart way with some mechanism. How to best go about this?
KR
 

Attachments

  • Obsolete Ice cream - example.JPG
    Obsolete Ice cream - example.JPG
    116.4 KB · Views: 22

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Forum statistics

Threads
1,223,229
Messages
6,170,881
Members
452,364
Latest member
springate

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