Probably stupid questions but couldn't figure that out by myself:
What is the best way to add LU list with units of measure to be used for drop down forms at all sheets/modules? I understand it should be at the LU sheet, but does it matter which module it will be part of? Can I add it to the TS module? Will it create any problems in the future in relation to links/ modules structure
Another TS related - if I want to have another calculation at the top of all sheets, like year serial number, which would be pretty basic, f.e. CurrentYear - FirstYear +1 - can I add it somewhere in TS module? I tried to do it at the top of the sheet, but got some error messages and it's not flowing through to all the other sheets.
Hi Yury,
The best place to add lookup tables to be referenced across all modules is at the bottom of the time series lookups module component.
Similarly, you can add rows to the bottom of time series period titles sets without causing compatibility issues.
As a general rule, you can add content to the time series assumptions and lookups components to the right and/or bottom, but not before or to the left of existing content, if you want to maintain compatibility with other modules based on the time series module in your workbook. You can also add rows to the bottom of existing time series period titles sets.
The Modano add-in is smart enough to know when additions have been made, and as long as there's no conflicts in additions to time series modules in different workbooks, you should be fine.
As a general rule, don't ever insert rows between existing rows in time series components, and I take this further by always building down not to the right.
I'd also think hard about whether you really need to ever add rows to time series periods titles sets, as we've found very few rows people add really need to be on every sheet. You're better off including custom time series triggers, etc., in grouped collapsed rows at the top of module components within modules outside the time series module if possible...
I hope this helps.
Michael
Thanks, Michael, works as charm!