Tying together two time dimensions of a model

3.78K viewsTips and Techniques


I am modeling expansion of a retail chain, with one identical store opening every couple of weeks, though not necessarily in a regular manner.

Obviously costs and revenues per one store can easily be captured in a matrix with the time dimension tied to ELAPSED weeks to/since store opening.

But then there’s the CALENDAR weeks dimension of the chain operating as a whole.

Here’s where I hit the wall. An obvious solution is to manually create full copies of a single store cashflow, each evolving in its elapsed time, and stagger them along the calendar time dimension. But this seems to have the disadvantage of redundancy, with related drawbacks in changing the model.

It’s dawning on me there must be a better way. Maybe I can keep the store model in one master matrix and only somehow virtually link it as many times as I need to the calendar time dimension of the chain as a whole…

Can you point me to a solution?

Thank you,



Hi Marek – thanks for the post. I am wondering if you could post a sample model describing your use case…?

You are viewing 1 out of 2 answers, click here to view all answers.

Latest Questions

Qloud Losing Formatting 4 Answers | 0 Votes
Meditation on timelines 3 Answers | 0 Votes