Forecasting

[vwag2323]

I am trying to forecast rentals in the coming 90 days. I have 3 years of historical data. The question I have is I have 50 facilties I am trying to forecast for. It's very simple to do this on a single site. How can I forecast for all 50 facilities in a single forecast, instead of going 1 by 1 doing 50 individual forecasts?

[#2]

@vwag2323 

I would ask you to publish a copy of the worksheet as long as it does not contain confidential or personal information and at the same time on this copy could explain your plans to us.

This would be of great help to the users here who would like to volunteer to offer you a tailored help and maybe a ready solution...if some have their time.

So it would be a win-win situation for everyone :)

Thank you for your time and effort in making this possible in advance.

Nikolino

I know that I know nothing

(Socrates)

[#3]

@NikolinoDE  unfortunately there is confidential information. What I was thinking about is using a pivot table where I have 2 columns the date & the value, using the different facilities as a filter. Then adding the additional columns for Forecast, Lower Confidence bound, and upper confidence bound. I think this is one way to possibly do it, but I feel like there are still somethings that I am going to end up running in to that I am not considering right now.

[#4]

@vwag2323 

If you will allow me, here is a little thought-provoking aid for your plans. I found the template at some point on the Internet, but unfortunately I can't remember the address.
Anyway, a little thinking support for the design and maybe a few formulas :).

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

[#5]

@vwag2323 

Also an interesting address from an MVP.

Mynda Treacy shows how to create an easy-to-read interactive profit and loss statement in Excel using PivotTable, Slicer and conditional formatting.

Maybe this could also help you.

Excel PivotTable Profit and Loss
https://www.myonlinetraininghub.com/excel-pivottable-profit-and-loss

*Any articles, templates, third-party products or information I have provided are for reference only. While I endeavor to keep the information up to date and correct as far as I can. I make no representations or warranties, express or implied, as to the completeness, correctness, reliability, suitability, or availability of any product or information, article, file, template, or related graphic on my posts in this forum. The trust you place in such information is therefore entirely at your own risk.

Thank you for letting me demonstrate an approach / solution / assistance.

Nikolino

I know I don't know anything (Socrates)