Sep 24 2020 12:47 PM
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?
Sep 24 2020 02:31 PM
Sep 24 2020 02:57 PM
@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.
Sep 25 2020 12:09 AM
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
Sep 25 2020 01:25 AM
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)