I have a 1 store 36 month model. Now I want to be able to create a 36 month
muti-unit budget where I plug in X number of store openings per month and
scenario play to determine cashflow so I can see how many I can open in
certain months. For Example: Month 1 would equal the 1 store model if I
opened 1 store and if I opened 2 stores it would equal times 2. However, in
month 2, stores opened in month 1 would be in there second month and then 4
openings in the current month. Then the third month I would open 3 stores, 4
would be in the second month and 2 in the third month of operations. I have
created a model but my formula is too long and will not let me proceed.
There must be a way to use macros or functions to easily do this. Your help
is greatly appreciated and if you need more details I will gladly provide for
that.

You say you have created a formula, but it is too long? Are you using an IF,
THEN, ELSE formula?

"JTack" wrote:

I have a 1 store 36 month model. Now I want to be able to create a 36 month
muti-unit budget where I plug in X number of store openings per month and
scenario play to determine cashflow so I can see how many I can open in
certain months. For Example: Month 1 would equal the 1 store model if I
opened 1 store and if I opened 2 stores it would equal times 2. However, in
month 2, stores opened in month 1 would be in there second month and then 4
openings in the current month. Then the third month I would open 3 stores, 4
would be in the second month and 2 in the third month of operations. I have
created a model but my formula is too long and will not let me proceed.
There must be a way to use macros or functions to easily do this. Your help
is greatly appreciated and if you need more details I will gladly provide for
that.

Hi,
Is this what you mean?

1 Month 1 Month 2 Month 3 Month 4 Month 5
Month 6
2 Opened This Month 1 2 2 1 2 3
3 Cumulative Opened 1 3 5 6 8 11

If Month1 is in columm B then Cumulative Opened is "= Sum($B:$2:B2)". Drag
this across row 3 to get the monthly cumulatives.

HTH

"JTack" wrote:

I have a 1 store 36 month model. Now I want to be able to create a 36 month
muti-unit budget where I plug in X number of store openings per month and
scenario play to determine cashflow so I can see how many I can open in
certain months. For Example: Month 1 would equal the 1 store model if I
opened 1 store and if I opened 2 stores it would equal times 2. However, in
month 2, stores opened in month 1 would be in there second month and then 4
openings in the current month. Then the third month I would open 3 stores, 4
would be in the second month and 2 in the third month of operations. I have
created a model but my formula is too long and will not let me proceed.
There must be a way to use macros or functions to easily do this. Your help
is greatly appreciated and if you need more details I will gladly provide for
that.

Mistyped the formula - should be "= SUM($B$2:B2)"

"Toppers" wrote:


Hi,
Is this what you mean?

1 Month 1 Month 2 Month 3 Month 4 Month 5
Month 6
2 Opened This Month 1 2 2 1 2 3
3 Cumulative Opened 1 3 5 6 8 11

If Month1 is in columm B then Cumulative Opened is "= Sum($B:$2:B2)". Drag
this across row 3 to get the monthly cumulatives.

HTH

"JTack" wrote:

I have a 1 store 36 month model. Now I want to be able to create a 36 month
muti-unit budget where I plug in X number of store openings per month and
scenario play to determine cashflow so I can see how many I can open in
certain months. For Example: Month 1 would equal the 1 store model if I
opened 1 store and if I opened 2 stores it would equal times 2. However, in
month 2, stores opened in month 1 would be in there second month and then 4
openings in the current month. Then the third month I would open 3 stores, 4
would be in the second month and 2 in the third month of operations. I have
created a model but my formula is too long and will not let me proceed.
There must be a way to use macros or functions to easily do this. Your help
is greatly appreciated and if you need more details I will gladly provide for
that.