Changing Calendar -- Too complicated for me!

kpigden

New Member
Joined
Jan 22, 2013
Messages
6
Hi there,

I have a complicated excel problem, which I want to solve with formulas if possible. Basically, it's a forecasting tool that changes based on different launch dates.

For example: Launch Date is April 2013, and the quantity in that month is a percentage of the total market (say 50).

JanFebMarAprMayJunJulAugSepOctNovDec
2013000505050505050505050
2014505050x
2015

<tbody>
</tbody>

In year 2, we have an expected growth rate of 0.2% (no matter what the launch date is).

JanFebMarAprMayJunJulAugSepOctNovDec
2013000505050505050505050
2014505050515151515151x
2015

<tbody>
</tbody>

In October 2014, there is a new contract that we expect to achieve that gives another % market share (say another 20 units). If we were to have launched in September 2014, we would still get that contract, but if launch is October 2014 and later, we won't get that contract.

JanFebMarAprMayJunJulAugSepOctNovDec
2013000505050505050505050
2014505050515151515151717171
2015717171

<tbody>
</tbody>

Is there a way to do this? I'd want the formulas in the calendar itself, but the forecast amounts will be in separate cells (ie. the 50 original units, the growth rate, and any contract amounts and start dates).:confused::confused:

Thank you very much in advance for any help!
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Ok, so here are the variables:

Launch date: ____________ (Not fixed)
Market Quantity Per Month: Fixed (Say 70)
Expected Growth: Fixed (0.2% per year)

Not contracted quantity: 71% of Market (50 units)
October 2014 Contract: 29% of Market (20 units)

If April 2013 was the launch month, then this would be the grid:

JanFebMarAprMayJunJulAugSepOctNovDec
2013505050505050505050
2014505050515151515151717171

<tbody>
</tbody>

If April 2014 was the launch month, then this would be the grid:

JanFebMarAprMayJunJulAugSepOctNovDec
2013
2014505050505050707070

<tbody>
</tbody>

If October 2014 was the launch month, then this would be the grid:
(We would miss the start date of the October 2014 contract date in this case).
JanFebMarAprMayJunJulAugSepOctNovDec
2013
2014505050

<tbody>
</tbody>

Does that help at all?
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,113,999
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top