Extend or Shorten Time Series - Unintended cell block extended

Hi Khang,

As a general comment we strongly recommend not making changes to core time series infrastructure if possible as:

1. It's likely to create errors in your model due to unexpected formula mis-references, etc. And this is not Modano-specific, it's a general comment when modeling in Excel.
2. It will render your model incompatible with all other modules built based on the time series module that was originally used for that model. So you're effectively creating a breakaway model from all existing content libraries and other models / modules.

Hence, we usually try whatever else we can do to avoid inserting columns in between period titles blocks within time series sheets, such as widening the width of columns and moving around content within columns A - I.

If inserting columns is unavoidable, you can do what you've done but you will need to shorten all cell blocks which have auto-filled across columns J - L by selecting all data within these columns and pressing the Ctl+E keyboard shortcut. You will then need to cut and paste cell blocks - on a sheet-by-sheet, component-by-component basis, back into the column before the all periods forecast (i.e. column L in your example above) to prevent formula errors. And even then I think there's real risk of resulting errors from this approach.

Another approach would be inserting columns to the left of the period titles block starting in column J (prior to your inserted columns above) and then cutting and pasting data in column I across into the newly-created column L. This is fiddly stuff so I'd get support from our team when doing this.

Have you considered building a new module based on a custom period titles set to do whatever you're looking to do here, rather than messing with all the time series sheets in your model? If not I've recommend doing so...

The consistency of time series periods titles sheets, both within modular workbooks and across modular workbooks, is a key foundation of being able to reuse and share content. So once you move away from this you move back into an old school manual labour world - i.e. the world in which consolidation models took us weeks to build and maintain not hours...

As mentioned above, I would strongly recommend getting support from our Services team to assist you with discussing and agreeing a best approach for your requirements here, as you're entering messy and risky waters...

M.