# Forecasting Curve Distribution

#### Honerun

##### New Member
Hello,

I am working on a forecasting model and have run into some trouble when trying to extend the X-Axis of a 12-month Curve Distribution to a longer time frame. Given a distribution of 12 percentages (one for each month), how can I spread the 12 months or periods to say 18 months while maintaining the integrity of the curve.

Example:

 Distribution Amount \$1,000,000 Known Curve 1 2 3 4 5 6 7 8 9 10 11 12 Bell Curve 1.00% 3.00% 6.00% 8.00% 12.00% 20.00% 20.00% 12.00% 8.00% 6.00% 3.00% 1.00% Spend Pattern 10,000 30,000 60,000 80,000 120,000 200,000 200,000 120,000 80,000 60,000 30,000 10,000 Adjusted Curve 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Bell Curve ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? Spend Pattern ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?

<colgroup><col><col span="4"><col span="2"><col><col><col span="10"></colgroup><tbody>
</tbody>

### Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

##### Well-known Member
I don't know how to find the pattern exactly but here's a rough guess:

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th><th>L</th><th>M</th><th>N</th><th>O</th><th>P</th><th>Q</th><th>R</th><th>S</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style=";">Known Curve</td><td style="text-align: right;;">1</td><td style="text-align: right;;">2</td><td style="text-align: right;;">3</td><td style="text-align: right;;">4</td><td style="text-align: right;;">5</td><td style="text-align: right;;">6</td><td style="text-align: right;;">7</td><td style="text-align: right;;">8</td><td style="text-align: right;;">9</td><td style="text-align: right;;">10</td><td style="text-align: right;;">11</td><td style="text-align: right;;">12</td><td style="text-align: right;;">13</td><td style="text-align: right;;">14</td><td style="text-align: right;;">15</td><td style="text-align: right;;">16</td><td style="text-align: right;;">17</td><td style="text-align: right;;">18</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">7</td><td style=";">Bell Curve</td><td style="text-align: right;;">1.00%</td><td style="text-align: right;;">2.00%</td><td style="text-align: right;;">3.00%</td><td style="text-align: right;;">4.00%</td><td style="text-align: right;;">6.00%</td><td style="text-align: right;;">7.00%</td><td style="text-align: right;;">8.00%</td><td style="text-align: right;;">9.00%</td><td style="text-align: right;;">10.00%</td><td style="text-align: right;;">10.00%</td><td style="text-align: right;;">9.00%</td><td style="text-align: right;;">8.00%</td><td style="text-align: right;;">7.00%</td><td style="text-align: right;;">6.00%</td><td style="text-align: right;;">4.00%</td><td style="text-align: right;;">3.00%</td><td style="text-align: right;;">2.00%</td><td style="text-align: right;;">1.00%</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">8</td><td style=";">Spend Pattern</td><td style="text-align: right;;">10,000</td><td style="text-align: right;;">20,000</td><td style="text-align: right;;">30,000</td><td style="text-align: right;;">40,000</td><td style="text-align: right;;">60,000</td><td style="text-align: right;;">70,000</td><td style="text-align: right;;">80,000</td><td style="text-align: right;;">90,000</td><td style="text-align: right;;">100,000</td><td style="text-align: right;;">100,000</td><td style="text-align: right;;">90,000</td><td style="text-align: right;;">80,000</td><td style="text-align: right;;">70,000</td><td style="text-align: right;;">60,000</td><td style="text-align: right;;">40,000</td><td style="text-align: right;;">30,000</td><td style="text-align: right;;">20,000</td><td style="text-align: right;;">10,000</td></tr></tbody></table><p style="width:8.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Sheet10 (3)</p><br /><br />

1,102,611
Messages
5,487,860
Members
407,611
Latest member
vrs_20

### This Week's Hot Topics

• Timer in VBA - Stop, Start, Pause and Reset
[CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
• how to updates multiple rows in muliselect listbox
Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
• Delete Row from Table
I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
• Assigning to a variable
I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
• Way to verify information
Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
• Active Cell Address – Inactive Sheet
How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...