Dear members,
I am currently working on forecasting in excel, maybe due to the large amount of data (11K cells) and fomulas (a lot conditional formatting) my excel document is running slow.
I was wondering if it was possible to calculate in VBA (given the historial data of the products) the future forecasts.
For the forecasts calculation Im currently using 8 weeks moving average with a lot of conditional formatting, like when Im in current week X take the sales from this week to this week, if its a new product then to take the values from a separate sheet only meant for new products (which is more manual since are new launches), also when its a new product and there are no current sales for the past 8 weeks; to take the values from the last 8 forecasted weeks but once there are 8 weeks of actual sales to take them instead.
I wanted to check if something like this is possible to automate (Either with macros, VBA or power pivot) since there are currently so many conditional formatting involved and would like to make the document run faster and with less formulas accross all the sheet.
Any suggestion or support is highly appreciated.
Thank you!
I am currently working on forecasting in excel, maybe due to the large amount of data (11K cells) and fomulas (a lot conditional formatting) my excel document is running slow.
I was wondering if it was possible to calculate in VBA (given the historial data of the products) the future forecasts.
For the forecasts calculation Im currently using 8 weeks moving average with a lot of conditional formatting, like when Im in current week X take the sales from this week to this week, if its a new product then to take the values from a separate sheet only meant for new products (which is more manual since are new launches), also when its a new product and there are no current sales for the past 8 weeks; to take the values from the last 8 forecasted weeks but once there are 8 weeks of actual sales to take them instead.
I wanted to check if something like this is possible to automate (Either with macros, VBA or power pivot) since there are currently so many conditional formatting involved and would like to make the document run faster and with less formulas accross all the sheet.
Any suggestion or support is highly appreciated.
Thank you!
