can this formula be made to work with dragging down / autofill

sous2817

sous2817

Well-known Member
Joined
Feb 22, 2008
Messages
2,276
Hello everyone,

I have the formula below, and I was wondering if there's a way to make it so it can be dragged down / use autofill:

<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>R</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;">0.000</td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;">0.355</td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: right;;">1.142</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: right;;">2.190</td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="text-align: right;;">3.470</td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="text-align: right;;">5.072</td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="text-align: right;;">6.839</td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="text-align: right;;">8.752</td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style="text-align: right;;">10.913</td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">E7050703</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R7</th><td style="text-align:left">=O7*(<font color="Blue">1-EXP(<font color="Red">-J7*1</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R8</th><td style="text-align:left">=O8*(<font color="Blue">1-EXP(<font color="Red">-J8*1</font>)</font>)+O7*(<font color="Blue">1-EXP(<font color="Red">-J7*2</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R9</th><td style="text-align:left">=O9*(<font color="Blue">1-EXP(<font color="Red">-J9*1</font>)</font>)+O8*(<font color="Blue">1-EXP(<font color="Red">-J8*2</font>)</font>)+O7*(<font color="Blue">1-EXP(<font color="Red">-J7*3</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R10</th><td style="text-align:left">=O10*(<font color="Blue">1-EXP(<font color="Red">-J10*1</font>)</font>)+O9*(<font color="Blue">1-EXP(<font color="Red">-J9*2</font>)</font>)+O8*(<font color="Blue">1-EXP(<font color="Red">-J8*3</font>)</font>)+O7*(<font color="Blue">1-EXP(<font color="Red">-J7*4</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R11</th><td style="text-align:left">=O11*(<font color="Blue">1-EXP(<font color="Red">-J11*1</font>)</font>)+O10*(<font color="Blue">1-EXP(<font color="Red">-J10*2</font>)</font>)+O9*(<font color="Blue">1-EXP(<font color="Red">-J9*3</font>)</font>)+O8*(<font color="Blue">1-EXP(<font color="Red">-J8*4</font>)</font>)+O7*(<font color="Blue">1-EXP(<font color="Red">-J7*5</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R12</th><td style="text-align:left">=O12*(<font color="Blue">1-EXP(<font color="Red">-J12*1</font>)</font>)+O11*(<font color="Blue">1-EXP(<font color="Red">-J11*2</font>)</font>)+O10*(<font color="Blue">1-EXP(<font color="Red">-J10*3</font>)</font>)+O9*(<font color="Blue">1-EXP(<font color="Red">-J9*4</font>)</font>)+O8*(<font color="Blue">1-EXP(<font color="Red">-J8*5</font>)</font>)+O7*(<font color="Blue">1-EXP(<font color="Red">-J7*6</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R13</th><td style="text-align:left">=O13*(<font color="Blue">1-EXP(<font color="Red">-J13*1</font>)</font>)+O12*(<font color="Blue">1-EXP(<font color="Red">-J12*2</font>)</font>)+O11*(<font color="Blue">1-EXP(<font color="Red">-J11*3</font>)</font>)+O10*(<font color="Blue">1-EXP(<font color="Red">-J10*4</font>)</font>)+O9*(<font color="Blue">1-EXP(<font color="Red">-J9*5</font>)</font>)+O8*(<font color="Blue">1-EXP(<font color="Red">-J8*6</font>)</font>)+O7*(<font color="Blue">1-EXP(<font color="Red">-J7*7</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R14</th><td style="text-align:left">=O14*(<font color="Blue">1-EXP(<font color="Red">-J14*1</font>)</font>)+O13*(<font color="Blue">1-EXP(<font color="Red">-J13*2</font>)</font>)+O12*(<font color="Blue">1-EXP(<font color="Red">-J12*3</font>)</font>)+O11*(<font color="Blue">1-EXP(<font color="Red">-J11*4</font>)</font>)+O10*(<font color="Blue">1-EXP(<font color="Red">-J10*5</font>)</font>)+O9*(<font color="Blue">1-EXP(<font color="Red">-J9*6</font>)</font>)+O8*(<font color="Blue">1-EXP(<font color="Red">-J8*7</font>)</font>)+O7*(<font color="Blue">1-EXP(<font color="Red">-J7*8</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R15</th><td style="text-align:left">=O15*(<font color="Blue">1-EXP(<font color="Red">-J15*1</font>)</font>)+O14*(<font color="Blue">1-EXP(<font color="Red">-J14*2</font>)</font>)+O13*(<font color="Blue">1-EXP(<font color="Red">-J13*3</font>)</font>)+O12*(<font color="Blue">1-EXP(<font color="Red">-J12*4</font>)</font>)+O11*(<font color="Blue">1-EXP(<font color="Red">-J11*5</font>)</font>)+O10*(<font color="Blue">1-EXP(<font color="Red">-J10*6</font>)</font>)+O9*(<font color="Blue">1-EXP(<font color="Red">-J9*7</font>)</font>)+O8*(<font color="Blue">1-EXP(<font color="Red">-J8*8</font>)</font>)+O7*(<font color="Blue">1-EXP(<font color="Red">-J7*9</font>)</font>)</td></tr></tbody></table></td></tr></table><br />

If anyone has any ideas / tips, I'd greatly appreciate it.

Thanks in advance!
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Sort by date Sort by votes
Untested, but try:

=SUM($O$7:O7*(1-EXP(-$J$7:J7*ROWS($J$7:J7))))

Try both with and without CTRL+SHIFT+ENTER.
 
Upvote 0
Thanks Mr.Kowz, but not quite. This is what you returned:

<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>V</th><th>W</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;">0</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;">0.355155</td><td style="text-align: right;;">0.355155</td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: right;;">0.473541</td><td style="text-align: right;;">0.828696</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: right;;">0.355155</td><td style="text-align: right;;">1.183852</td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="text-align: right;;">0.355155</td><td style="text-align: right;;">1.539007</td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="text-align: right;;">0.473541</td><td style="text-align: right;;">2.012548</td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="text-align: right;;">0.355155</td><td style="text-align: right;;">2.367703</td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="text-align: right;;">0.355155</td><td style="text-align: right;;">2.722859</td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style="text-align: right;;">0.473541</td><td style="text-align: right;;">3.196399</td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style="text-align: right;;">0.355155</td><td style="text-align: right;;">3.551555</td></tr><tr ><td style="color: #161120;text-align: center;">17</td><td style="text-align: right;;">0.355155</td><td style="text-align: right;;">3.90671</td></tr><tr ><td style="color: #161120;text-align: center;">18</td><td style="text-align: right;;">0.473541</td><td style="text-align: right;;">4.380251</td></tr><tr ><td style="color: #161120;text-align: center;">19</td><td style="text-align: right;;">0.355155</td><td style="text-align: right;;">4.735406</td></tr><tr ><td style="color: #161120;text-align: center;">20</td><td style="text-align: right;;">0</td><td style="text-align: right;;">4.735406</td></tr><tr ><td style="color: #161120;text-align: center;">21</td><td style="text-align: right;;">0</td><td style="text-align: right;;">4.735406</td></tr><tr ><td style="color: #161120;text-align: center;">22</td><td style="text-align: right;;">0</td><td style="text-align: right;;">4.735406</td></tr><tr ><td style="color: #161120;text-align: center;">23</td><td style="text-align: right;;">0</td><td style="text-align: right;;">4.735406</td></tr><tr ><td style="color: #161120;text-align: center;">24</td><td style="text-align: right;;">0</td><td style="text-align: right;;">4.735406</td></tr><tr ><td style="color: #161120;text-align: center;">25</td><td style="text-align: right;;">0</td><td style="text-align: right;;">4.735406</td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">E7050703</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V7</th><td style="text-align:left">=SUM(<font color="Blue">$O$7:O7*(<font color="Red">1-EXP(<font color="Green">-$J$7:J7</font>)</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V8</th><td style="text-align:left">=SUM(<font color="Blue">$O$7:O8*(<font color="Red">1-EXP(<font color="Green">-$J$7:J8</font>)</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V9</th><td style="text-align:left">=SUM(<font color="Blue">$O$7:O9*(<font color="Red">1-EXP(<font color="Green">-$J$7:J9</font>)</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V10</th><td style="text-align:left">=SUM(<font color="Blue">$O$7:O10*(<font color="Red">1-EXP(<font color="Green">-$J$7:J10</font>)</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V11</th><td style="text-align:left">=SUM(<font color="Blue">$O$7:O11*(<font color="Red">1-EXP(<font color="Green">-$J$7:J11</font>)</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V12</th><td style="text-align:left">=SUM(<font color="Blue">$O$7:O12*(<font color="Red">1-EXP(<font color="Green">-$J$7:J12</font>)</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V13</th><td style="text-align:left">=SUM(<font color="Blue">$O$7:O13*(<font color="Red">1-EXP(<font color="Green">-$J$7:J13</font>)</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V14</th><td style="text-align:left">=SUM(<font color="Blue">$O$7:O14*(<font color="Red">1-EXP(<font color="Green">-$J$7:J14</font>)</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V15</th><td style="text-align:left">=SUM(<font color="Blue">$O$7:O15*(<font color="Red">1-EXP(<font color="Green">-$J$7:J15</font>)</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V16</th><td style="text-align:left">=SUM(<font color="Blue">$O$7:O16*(<font color="Red">1-EXP(<font color="Green">-$J$7:J16</font>)</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V17</th><td style="text-align:left">=SUM(<font color="Blue">$O$7:O17*(<font color="Red">1-EXP(<font color="Green">-$J$7:J17</font>)</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V18</th><td style="text-align:left">=SUM(<font color="Blue">$O$7:O18*(<font color="Red">1-EXP(<font color="Green">-$J$7:J18</font>)</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V19</th><td style="text-align:left">=SUM(<font color="Blue">$O$7:O19*(<font color="Red">1-EXP(<font color="Green">-$J$7:J19</font>)</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V20</th><td style="text-align:left">=SUM(<font color="Blue">$O$7:O20*(<font color="Red">1-EXP(<font color="Green">-$J$7:J20</font>)</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V21</th><td style="text-align:left">=SUM(<font color="Blue">$O$7:O21*(<font color="Red">1-EXP(<font color="Green">-$J$7:J21</font>)</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V22</th><td style="text-align:left">=SUM(<font color="Blue">$O$7:O22*(<font color="Red">1-EXP(<font color="Green">-$J$7:J22</font>)</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V23</th><td style="text-align:left">=SUM(<font color="Blue">$O$7:O23*(<font color="Red">1-EXP(<font color="Green">-$J$7:J23</font>)</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V24</th><td style="text-align:left">=SUM(<font color="Blue">$O$7:O24*(<font color="Red">1-EXP(<font color="Green">-$J$7:J24</font>)</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V25</th><td style="text-align:left">=SUM(<font color="Blue">$O$7:O25*(<font color="Red">1-EXP(<font color="Green">-$J$7:J25</font>)</font>)</font>)</td></tr></tbody></table></td></tr></table><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Array Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W7</th><td style="text-align:left">{=SUM(<font color="Blue">$O$7:O7*(<font color="Red">1-EXP(<font color="Green">-$J$7:J7</font>)</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W8</th><td style="text-align:left">{=SUM(<font color="Blue">$O$7:O8*(<font color="Red">1-EXP(<font color="Green">-$J$7:J8</font>)</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W9</th><td style="text-align:left">{=SUM(<font color="Blue">$O$7:O9*(<font color="Red">1-EXP(<font color="Green">-$J$7:J9</font>)</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W10</th><td style="text-align:left">{=SUM(<font color="Blue">$O$7:O10*(<font color="Red">1-EXP(<font color="Green">-$J$7:J10</font>)</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W11</th><td style="text-align:left">{=SUM(<font color="Blue">$O$7:O11*(<font color="Red">1-EXP(<font color="Green">-$J$7:J11</font>)</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W12</th><td style="text-align:left">{=SUM(<font color="Blue">$O$7:O12*(<font color="Red">1-EXP(<font color="Green">-$J$7:J12</font>)</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W13</th><td style="text-align:left">{=SUM(<font color="Blue">$O$7:O13*(<font color="Red">1-EXP(<font color="Green">-$J$7:J13</font>)</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W14</th><td style="text-align:left">{=SUM(<font color="Blue">$O$7:O14*(<font color="Red">1-EXP(<font color="Green">-$J$7:J14</font>)</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W15</th><td style="text-align:left">{=SUM(<font color="Blue">$O$7:O15*(<font color="Red">1-EXP(<font color="Green">-$J$7:J15</font>)</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W16</th><td style="text-align:left">{=SUM(<font color="Blue">$O$7:O16*(<font color="Red">1-EXP(<font color="Green">-$J$7:J16</font>)</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W17</th><td style="text-align:left">{=SUM(<font color="Blue">$O$7:O17*(<font color="Red">1-EXP(<font color="Green">-$J$7:J17</font>)</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W18</th><td style="text-align:left">{=SUM(<font color="Blue">$O$7:O18*(<font color="Red">1-EXP(<font color="Green">-$J$7:J18</font>)</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W19</th><td style="text-align:left">{=SUM(<font color="Blue">$O$7:O19*(<font color="Red">1-EXP(<font color="Green">-$J$7:J19</font>)</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W20</th><td style="text-align:left">{=SUM(<font color="Blue">$O$7:O20*(<font color="Red">1-EXP(<font color="Green">-$J$7:J20</font>)</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W21</th><td style="text-align:left">{=SUM(<font color="Blue">$O$7:O21*(<font color="Red">1-EXP(<font color="Green">-$J$7:J21</font>)</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W22</th><td style="text-align:left">{=SUM(<font color="Blue">$O$7:O22*(<font color="Red">1-EXP(<font color="Green">-$J$7:J22</font>)</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W23</th><td style="text-align:left">{=SUM(<font color="Blue">$O$7:O23*(<font color="Red">1-EXP(<font color="Green">-$J$7:J23</font>)</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W24</th><td style="text-align:left">{=SUM(<font color="Blue">$O$7:O24*(<font color="Red">1-EXP(<font color="Green">-$J$7:J24</font>)</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W25</th><td style="text-align:left">{=SUM(<font color="Blue">$O$7:O25*(<font color="Red">1-EXP(<font color="Green">-$J$7:J25</font>)</font>)</font>)}</td></tr></tbody></table><b>Entered with Ctrl+Shift+Enter.</b> If entered correctly, Excel will surround with curly braces {}.
<b>Note: Do not try and enter the {} manually yourself</b></td></tr></table><br />
 
Upvote 0
So I can test on my end, what values do you have in columns O and J?
 
Upvote 0
Sure, no problem. This is what I've got:

<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>O</th><th>P</th><th>Q</th><th>R</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;">0.000</td><td style="text-align: right;;">0.000</td><td style="text-align: right;;">0.00</td><td style="text-align: right;;">0.000</td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;">3.000</td><td style="text-align: right;;">3.000</td><td style="text-align: right;;">0.65</td><td style="text-align: right;;">0.355</td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: right;;">4.000</td><td style="text-align: right;;">4.000</td><td style="text-align: right;;">2.11</td><td style="text-align: right;;">1.142</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: right;;">3.000</td><td style="text-align: right;;">3.000</td><td style="text-align: right;;">4.06</td><td style="text-align: right;;">2.190</td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="text-align: right;;">3.000</td><td style="text-align: right;;">3.000</td><td style="text-align: right;;">6.45</td><td style="text-align: right;;">3.470</td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="text-align: right;;">4.000</td><td style="text-align: right;;">4.000</td><td style="text-align: right;;">9.45</td><td style="text-align: right;;">5.072</td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="text-align: right;;">3.000</td><td style="text-align: right;;">3.000</td><td style="text-align: right;;">12.77</td><td style="text-align: right;;">6.839</td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="text-align: right;;">3.000</td><td style="text-align: right;;">3.000</td><td style="text-align: right;;">16.39</td><td style="text-align: right;;">8.752</td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style="text-align: right;;">4.000</td><td style="text-align: right;;">4.000</td><td style="text-align: right;;">20.48</td><td style="text-align: right;;">10.913</td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style="text-align: right;;">3.000</td><td style="text-align: right;;">3.000</td><td style="text-align: right;;">24.77</td><td style="text-align: right;;">13.172</td></tr><tr ><td style="color: #161120;text-align: center;">17</td><td style="text-align: right;;">3.000</td><td style="text-align: right;;">3.000</td><td style="text-align: right;;">29.25</td><td style="text-align: right;;">15.520</td></tr><tr ><td style="color: #161120;text-align: center;">18</td><td style="text-align: right;;">4.000</td><td style="text-align: right;;">4.000</td><td style="text-align: right;;">34.12</td><td style="text-align: right;;">18.063</td></tr><tr ><td style="color: #161120;text-align: center;">19</td><td style="text-align: right;;">3.000</td><td style="text-align: right;;">3.000</td><td style="text-align: right;;">39.10</td><td style="text-align: right;;">20.660</td></tr><tr ><td style="color: #161120;text-align: center;">20</td><td style="text-align: right;;">0.000</td><td style="text-align: right;;">0.000</td><td style="text-align: right;;">43.54</td><td style="text-align: right;;">22.949</td></tr><tr ><td style="color: #161120;text-align: center;">21</td><td style="text-align: right;;">0.000</td><td style="text-align: right;;">0.000</td><td style="text-align: right;;">47.49</td><td style="text-align: right;;">24.968</td></tr><tr ><td style="color: #161120;text-align: center;">22</td><td style="text-align: right;;">0.000</td><td style="text-align: right;;">0.000</td><td style="text-align: right;;">51.01</td><td style="text-align: right;;">26.747</td></tr><tr ><td style="color: #161120;text-align: center;">23</td><td style="text-align: right;;">0.000</td><td style="text-align: right;;">0.000</td><td style="text-align: right;;">54.15</td><td style="text-align: right;;">28.316</td></tr><tr ><td style="color: #161120;text-align: center;">24</td><td style="text-align: right;;">0.000</td><td style="text-align: right;;">0.000</td><td style="text-align: right;;">56.95</td><td style="text-align: right;;">29.699</td></tr><tr ><td style="color: #161120;text-align: center;">25</td><td style="text-align: right;;">0.000</td><td style="text-align: right;;">0.000</td><td style="text-align: right;;">59.44</td><td style="text-align: right;;">30.919</td></tr><tr ><td style="color: #161120;text-align: center;">26</td><td style="text-align: right;;">0.000</td><td style="text-align: right;;">0.000</td><td style="text-align: right;;">61.66</td><td style="text-align: right;;">31.994</td></tr><tr ><td style="color: #161120;text-align: center;">27</td><td style="text-align: right;;">0.000</td><td style="text-align: right;;">0.000</td><td style="text-align: right;;">63.63</td><td style="text-align: right;;">32.942</td></tr><tr ><td style="color: #161120;text-align: center;">28</td><td style="text-align: right;;">0.000</td><td style="text-align: right;;">0.000</td><td style="text-align: right;;">65.40</td><td style="text-align: right;;">33.777</td></tr><tr ><td style="color: #161120;text-align: center;">29</td><td style="text-align: right;;">0.000</td><td style="text-align: right;;">0.000</td><td style="text-align: right;;">66.97</td><td style="text-align: right;;">34.514</td></tr><tr ><td style="color: #161120;text-align: center;">30</td><td style="text-align: right;;">0.000</td><td style="text-align: right;;">0.000</td><td style="text-align: right;;">68.37</td><td style="text-align: right;;">35.163</td></tr><tr ><td style="color: #161120;text-align: center;">31</td><td style="text-align: right;;">0.000</td><td style="text-align: right;;">0.000</td><td style="text-align: right;;">69.62</td><td style="text-align: right;;">35.736</td></tr><tr ><td style="color: #161120;text-align: center;">32</td><td style="text-align: right;;">0.000</td><td style="text-align: right;;">0.000</td><td style="text-align: right;;">70.73</td><td style="text-align: right;;">36.241</td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">E7050703</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q7</th><td style="text-align:left">=R7+S7</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R7</th><td style="text-align:left">=O7*(<font color="Blue">1-EXP(<font color="Red">-J7*1</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q8</th><td style="text-align:left">=R8+S8</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R8</th><td style="text-align:left">=O8*(<font color="Blue">1-EXP(<font color="Red">-J8*1</font>)</font>)+O7*(<font color="Blue">1-EXP(<font color="Red">-J7*2</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q9</th><td style="text-align:left">=R9+S9</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R9</th><td style="text-align:left">=O9*(<font color="Blue">1-EXP(<font color="Red">-J9*1</font>)</font>)+O8*(<font color="Blue">1-EXP(<font color="Red">-J8*2</font>)</font>)+O7*(<font color="Blue">1-EXP(<font color="Red">-J7*3</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q10</th><td style="text-align:left">=R10+S10</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R10</th><td style="text-align:left">=O10*(<font color="Blue">1-EXP(<font color="Red">-J10*1</font>)</font>)+O9*(<font color="Blue">1-EXP(<font color="Red">-J9*2</font>)</font>)+O8*(<font color="Blue">1-EXP(<font color="Red">-J8*3</font>)</font>)+O7*(<font color="Blue">1-EXP(<font color="Red">-J7*4</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q11</th><td style="text-align:left">=R11+S11</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R11</th><td style="text-align:left">=O11*(<font color="Blue">1-EXP(<font color="Red">-J11*1</font>)</font>)+O10*(<font color="Blue">1-EXP(<font color="Red">-J10*2</font>)</font>)+O9*(<font color="Blue">1-EXP(<font color="Red">-J9*3</font>)</font>)+O8*(<font color="Blue">1-EXP(<font color="Red">-J8*4</font>)</font>)+O7*(<font color="Blue">1-EXP(<font color="Red">-J7*5</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q12</th><td style="text-align:left">=R12+S12</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R12</th><td style="text-align:left">=O12*(<font color="Blue">1-EXP(<font color="Red">-J12*1</font>)</font>)+O11*(<font color="Blue">1-EXP(<font color="Red">-J11*2</font>)</font>)+O10*(<font color="Blue">1-EXP(<font color="Red">-J10*3</font>)</font>)+O9*(<font color="Blue">1-EXP(<font color="Red">-J9*4</font>)</font>)+O8*(<font color="Blue">1-EXP(<font color="Red">-J8*5</font>)</font>)+O7*(<font color="Blue">1-EXP(<font color="Red">-J7*6</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q13</th><td style="text-align:left">=R13+S13</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R13</th><td style="text-align:left">=O13*(<font color="Blue">1-EXP(<font color="Red">-J13*1</font>)</font>)+O12*(<font color="Blue">1-EXP(<font color="Red">-J12*2</font>)</font>)+O11*(<font color="Blue">1-EXP(<font color="Red">-J11*3</font>)</font>)+O10*(<font color="Blue">1-EXP(<font color="Red">-J10*4</font>)</font>)+O9*(<font color="Blue">1-EXP(<font color="Red">-J9*5</font>)</font>)+O8*(<font color="Blue">1-EXP(<font color="Red">-J8*6</font>)</font>)+O7*(<font color="Blue">1-EXP(<font color="Red">-J7*7</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q14</th><td style="text-align:left">=R14+S14</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R14</th><td style="text-align:left">=O14*(<font color="Blue">1-EXP(<font color="Red">-J14*1</font>)</font>)+O13*(<font color="Blue">1-EXP(<font color="Red">-J13*2</font>)</font>)+O12*(<font color="Blue">1-EXP(<font color="Red">-J12*3</font>)</font>)+O11*(<font color="Blue">1-EXP(<font color="Red">-J11*4</font>)</font>)+O10*(<font color="Blue">1-EXP(<font color="Red">-J10*5</font>)</font>)+O9*(<font color="Blue">1-EXP(<font color="Red">-J9*6</font>)</font>)+O8*(<font color="Blue">1-EXP(<font color="Red">-J8*7</font>)</font>)+O7*(<font color="Blue">1-EXP(<font color="Red">-J7*8</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q15</th><td style="text-align:left">=R15+S15</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R15</th><td style="text-align:left">=O15*(<font color="Blue">1-EXP(<font color="Red">-J15*1</font>)</font>)+O14*(<font color="Blue">1-EXP(<font color="Red">-J14*2</font>)</font>)+O13*(<font color="Blue">1-EXP(<font color="Red">-J13*3</font>)</font>)+O12*(<font color="Blue">1-EXP(<font color="Red">-J12*4</font>)</font>)+O11*(<font color="Blue">1-EXP(<font color="Red">-J11*5</font>)</font>)+O10*(<font color="Blue">1-EXP(<font color="Red">-J10*6</font>)</font>)+O9*(<font color="Blue">1-EXP(<font color="Red">-J9*7</font>)</font>)+O8*(<font color="Blue">1-EXP(<font color="Red">-J8*8</font>)</font>)+O7*(<font color="Blue">1-EXP(<font color="Red">-J7*9</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q16</th><td style="text-align:left">=R16+S16</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R16</th><td style="text-align:left">=O16*(<font color="Blue">1-EXP(<font color="Red">-J16*1</font>)</font>)+O15*(<font color="Blue">1-EXP(<font color="Red">-J15*2</font>)</font>)+O14*(<font color="Blue">1-EXP(<font color="Red">-J14*3</font>)</font>)+O13*(<font color="Blue">1-EXP(<font color="Red">-J13*4</font>)</font>)+O12*(<font color="Blue">1-EXP(<font color="Red">-J12*5</font>)</font>)+O11*(<font color="Blue">1-EXP(<font color="Red">-J11*6</font>)</font>)+O10*(<font color="Blue">1-EXP(<font color="Red">-J10*7</font>)</font>)+O9*(<font color="Blue">1-EXP(<font color="Red">-J9*8</font>)</font>)+O8*(<font color="Blue">1-EXP(<font color="Red">-J8*9</font>)</font>)+O7*(<font color="Blue">1-EXP(<font color="Red">-J7*10</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q17</th><td style="text-align:left">=R17+S17</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R17</th><td style="text-align:left">=O17*(<font color="Blue">1-EXP(<font color="Red">-J17*1</font>)</font>)+O16*(<font color="Blue">1-EXP(<font color="Red">-J16*2</font>)</font>)+O15*(<font color="Blue">1-EXP(<font color="Red">-J15*3</font>)</font>)+O14*(<font color="Blue">1-EXP(<font color="Red">-J14*4</font>)</font>)+O13*(<font color="Blue">1-EXP(<font color="Red">-J13*5</font>)</font>)+O12*(<font color="Blue">1-EXP(<font color="Red">-J12*6</font>)</font>)+O11*(<font color="Blue">1-EXP(<font color="Red">-J11*7</font>)</font>)+O10*(<font color="Blue">1-EXP(<font color="Red">-J10*8</font>)</font>)+O9*(<font color="Blue">1-EXP(<font color="Red">-J9*9</font>)</font>)+O8*(<font color="Blue">1-EXP(<font color="Red">-J8*10</font>)</font>)+O7*(<font color="Blue">1-EXP(<font color="Red">-J7*11</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q18</th><td style="text-align:left">=R18+S18</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R18</th><td style="text-align:left">=O18*(<font color="Blue">1-EXP(<font color="Red">-J18*1</font>)</font>)+O17*(<font color="Blue">1-EXP(<font color="Red">-J17*2</font>)</font>)+O16*(<font color="Blue">1-EXP(<font color="Red">-J16*3</font>)</font>)+O15*(<font color="Blue">1-EXP(<font color="Red">-J15*4</font>)</font>)+O14*(<font color="Blue">1-EXP(<font color="Red">-J14*5</font>)</font>)+O13*(<font color="Blue">1-EXP(<font color="Red">-J13*6</font>)</font>)+O12*(<font color="Blue">1-EXP(<font color="Red">-J12*7</font>)</font>)+O11*(<font color="Blue">1-EXP(<font color="Red">-J11*8</font>)</font>)+O10*(<font color="Blue">1-EXP(<font color="Red">-J10*9</font>)</font>)+O9*(<font color="Blue">1-EXP(<font color="Red">-J9*10</font>)</font>)+O8*(<font color="Blue">1-EXP(<font color="Red">-J8*11</font>)</font>)+O7*(<font color="Blue">1-EXP(<font color="Red">-J7*12</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q19</th><td style="text-align:left">=R19+S19</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R19</th><td style="text-align:left">=O19*(<font color="Blue">1-EXP(<font color="Red">-J19*1</font>)</font>)+O18*(<font color="Blue">1-EXP(<font color="Red">-J18*2</font>)</font>)+O17*(<font color="Blue">1-EXP(<font color="Red">-J17*3</font>)</font>)+O16*(<font color="Blue">1-EXP(<font color="Red">-J16*4</font>)</font>)+O15*(<font color="Blue">1-EXP(<font color="Red">-J15*5</font>)</font>)+O14*(<font color="Blue">1-EXP(<font color="Red">-J14*6</font>)</font>)+O13*(<font color="Blue">1-EXP(<font color="Red">-J13*7</font>)</font>)+O12*(<font color="Blue">1-EXP(<font color="Red">-J12*8</font>)</font>)+O11*(<font color="Blue">1-EXP(<font color="Red">-J11*9</font>)</font>)+O10*(<font color="Blue">1-EXP(<font color="Red">-J10*10</font>)</font>)+O9*(<font color="Blue">1-EXP(<font color="Red">-J9*11</font>)</font>)+O8*(<font color="Blue">1-EXP(<font color="Red">-J8*12</font>)</font>)+O7*(<font color="Blue">1-EXP(<font color="Red">-J7*13</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O8</th><td style="text-align:left">=M8-M7</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P8</th><td style="text-align:left">=N8-N7</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O9</th><td style="text-align:left">=M9-M8</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P9</th><td style="text-align:left">=N9-N8</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O15</th><td style="text-align:left">=M15-M14</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P15</th><td style="text-align:left">=N15-N14</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O20</th><td style="text-align:left">=M20-M19</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P20</th><td style="text-align:left">=N20-N19</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q20</th><td style="text-align:left">=R20+S20</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R20</th><td style="text-align:left">=O20*(<font color="Blue">1-EXP(<font color="Red">-J20*1</font>)</font>)+O19*(<font color="Blue">1-EXP(<font color="Red">-J19*2</font>)</font>)+O18*(<font color="Blue">1-EXP(<font color="Red">-J18*3</font>)</font>)+O17*(<font color="Blue">1-EXP(<font color="Red">-J17*4</font>)</font>)+O16*(<font color="Blue">1-EXP(<font color="Red">-J16*5</font>)</font>)+O15*(<font color="Blue">1-EXP(<font color="Red">-J15*6</font>)</font>)+O14*(<font color="Blue">1-EXP(<font color="Red">-J14*7</font>)</font>)+O13*(<font color="Blue">1-EXP(<font color="Red">-J13*8</font>)</font>)+O12*(<font color="Blue">1-EXP(<font color="Red">-J12*9</font>)</font>)+O11*(<font color="Blue">1-EXP(<font color="Red">-J11*10</font>)</font>)+O10*(<font color="Blue">1-EXP(<font color="Red">-J10*11</font>)</font>)+O9*(<font color="Blue">1-EXP(<font color="Red">-J9*12</font>)</font>)+O8*(<font color="Blue">1-EXP(<font color="Red">-J8*13</font>)</font>)+O7*(<font color="Blue">1-EXP(<font color="Red">-J7*14</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O21</th><td style="text-align:left">=M21-M20</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P21</th><td style="text-align:left">=N21-N20</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q21</th><td style="text-align:left">=R21+S21</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R21</th><td style="text-align:left">=O21*(<font color="Blue">1-EXP(<font color="Red">-J21*1</font>)</font>)+O20*(<font color="Blue">1-EXP(<font color="Red">-J20*2</font>)</font>)+O19*(<font color="Blue">1-EXP(<font color="Red">-J19*3</font>)</font>)+O18*(<font color="Blue">1-EXP(<font color="Red">-J18*4</font>)</font>)+O17*(<font color="Blue">1-EXP(<font color="Red">-J17*5</font>)</font>)+O16*(<font color="Blue">1-EXP(<font color="Red">-J16*6</font>)</font>)+O15*(<font color="Blue">1-EXP(<font color="Red">-J15*7</font>)</font>)+O14*(<font color="Blue">1-EXP(<font color="Red">-J14*8</font>)</font>)+O13*(<font color="Blue">1-EXP(<font color="Red">-J13*9</font>)</font>)+O12*(<font color="Blue">1-EXP(<font color="Red">-J12*10</font>)</font>)+O11*(<font color="Blue">1-EXP(<font color="Red">-J11*11</font>)</font>)+O10*(<font color="Blue">1-EXP(<font color="Red">-J10*12</font>)</font>)+O9*(<font color="Blue">1-EXP(<font color="Red">-J9*13</font>)</font>)+O8*(<font color="Blue">1-EXP(<font color="Red">-J8*14</font>)</font>)+O7*(<font color="Blue">1-EXP(<font color="Red">-J7*15</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O22</th><td style="text-align:left">=M22-M21</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P22</th><td style="text-align:left">=N22-N21</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q22</th><td style="text-align:left">=R22+S22</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R22</th><td style="text-align:left">=O22*(<font color="Blue">1-EXP(<font color="Red">-J22*1</font>)</font>)+O21*(<font color="Blue">1-EXP(<font color="Red">-J21*2</font>)</font>)+O20*(<font color="Blue">1-EXP(<font color="Red">-J20*3</font>)</font>)+O19*(<font color="Blue">1-EXP(<font color="Red">-J19*4</font>)</font>)+O18*(<font color="Blue">1-EXP(<font color="Red">-J18*5</font>)</font>)+O17*(<font color="Blue">1-EXP(<font color="Red">-J17*6</font>)</font>)+O16*(<font color="Blue">1-EXP(<font color="Red">-J16*7</font>)</font>)+O15*(<font color="Blue">1-EXP(<font color="Red">-J15*8</font>)</font>)+O14*(<font color="Blue">1-EXP(<font color="Red">-J14*9</font>)</font>)+O13*(<font color="Blue">1-EXP(<font color="Red">-J13*10</font>)</font>)+O12*(<font color="Blue">1-EXP(<font color="Red">-J12*11</font>)</font>)+O11*(<font color="Blue">1-EXP(<font color="Red">-J11*12</font>)</font>)+O10*(<font color="Blue">1-EXP(<font color="Red">-J10*13</font>)</font>)+O9*(<font color="Blue">1-EXP(<font color="Red">-J9*14</font>)</font>)+O8*(<font color="Blue">1-EXP(<font color="Red">-J8*15</font>)</font>)+O7*(<font color="Blue">1-EXP(<font color="Red">-J7*16</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O23</th><td style="text-align:left">=M23-M22</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P23</th><td style="text-align:left">=N23-N22</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q23</th><td style="text-align:left">=R23+S23</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R23</th><td style="text-align:left">=O23*(<font color="Blue">1-EXP(<font color="Red">-J23*1</font>)</font>)+O22*(<font color="Blue">1-EXP(<font color="Red">-J22*2</font>)</font>)+O21*(<font color="Blue">1-EXP(<font color="Red">-J21*3</font>)</font>)+O20*(<font color="Blue">1-EXP(<font color="Red">-J20*4</font>)</font>)+O19*(<font color="Blue">1-EXP(<font color="Red">-J19*5</font>)</font>)+O18*(<font color="Blue">1-EXP(<font color="Red">-J18*6</font>)</font>)+O17*(<font color="Blue">1-EXP(<font color="Red">-J17*7</font>)</font>)+O16*(<font color="Blue">1-EXP(<font color="Red">-J16*8</font>)</font>)+O15*(<font color="Blue">1-EXP(<font color="Red">-J15*9</font>)</font>)+O14*(<font color="Blue">1-EXP(<font color="Red">-J14*10</font>)</font>)+O13*(<font color="Blue">1-EXP(<font color="Red">-J13*11</font>)</font>)+O12*(<font color="Blue">1-EXP(<font color="Red">-J12*12</font>)</font>)+O11*(<font color="Blue">1-EXP(<font color="Red">-J11*13</font>)</font>)+O10*(<font color="Blue">1-EXP(<font color="Red">-J10*14</font>)</font>)+O9*(<font color="Blue">1-EXP(<font color="Red">-J9*15</font>)</font>)+O8*(<font color="Blue">1-EXP(<font color="Red">-J8*16</font>)</font>)+O7*(<font color="Blue">1-EXP(<font color="Red">-J7*17</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O24</th><td style="text-align:left">=M24-M23</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P24</th><td style="text-align:left">=N24-N23</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q24</th><td style="text-align:left">=R24+S24</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R24</th><td style="text-align:left">=O24*(<font color="Blue">1-EXP(<font color="Red">-J24*1</font>)</font>)+O23*(<font color="Blue">1-EXP(<font color="Red">-J23*2</font>)</font>)+O22*(<font color="Blue">1-EXP(<font color="Red">-J22*3</font>)</font>)+O21*(<font color="Blue">1-EXP(<font color="Red">-J21*4</font>)</font>)+O20*(<font color="Blue">1-EXP(<font color="Red">-J20*5</font>)</font>)+O19*(<font color="Blue">1-EXP(<font color="Red">-J19*6</font>)</font>)+O18*(<font color="Blue">1-EXP(<font color="Red">-J18*7</font>)</font>)+O17*(<font color="Blue">1-EXP(<font color="Red">-J17*8</font>)</font>)+O16*(<font color="Blue">1-EXP(<font color="Red">-J16*9</font>)</font>)+O15*(<font color="Blue">1-EXP(<font color="Red">-J15*10</font>)</font>)+O14*(<font color="Blue">1-EXP(<font color="Red">-J14*11</font>)</font>)+O13*(<font color="Blue">1-EXP(<font color="Red">-J13*12</font>)</font>)+O12*(<font color="Blue">1-EXP(<font color="Red">-J12*13</font>)</font>)+O11*(<font color="Blue">1-EXP(<font color="Red">-J11*14</font>)</font>)+O10*(<font color="Blue">1-EXP(<font color="Red">-J10*15</font>)</font>)+O9*(<font color="Blue">1-EXP(<font color="Red">-J9*16</font>)</font>)+O8*(<font color="Blue">1-EXP(<font color="Red">-J8*17</font>)</font>)+O7*(<font color="Blue">1-EXP(<font color="Red">-J7*18</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O25</th><td style="text-align:left">=M25-M24</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P25</th><td style="text-align:left">=N25-N24</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q25</th><td style="text-align:left">=R25+S25</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R25</th><td style="text-align:left">=O25*(<font color="Blue">1-EXP(<font color="Red">-J25*1</font>)</font>)+O24*(<font color="Blue">1-EXP(<font color="Red">-J24*2</font>)</font>)+O23*(<font color="Blue">1-EXP(<font color="Red">-J23*3</font>)</font>)+O22*(<font color="Blue">1-EXP(<font color="Red">-J22*4</font>)</font>)+O21*(<font color="Blue">1-EXP(<font color="Red">-J21*5</font>)</font>)+O20*(<font color="Blue">1-EXP(<font color="Red">-J20*6</font>)</font>)+O19*(<font color="Blue">1-EXP(<font color="Red">-J19*7</font>)</font>)+O18*(<font color="Blue">1-EXP(<font color="Red">-J18*8</font>)</font>)+O17*(<font color="Blue">1-EXP(<font color="Red">-J17*9</font>)</font>)+O16*(<font color="Blue">1-EXP(<font color="Red">-J16*10</font>)</font>)+O15*(<font color="Blue">1-EXP(<font color="Red">-J15*11</font>)</font>)+O14*(<font color="Blue">1-EXP(<font color="Red">-J14*12</font>)</font>)+O13*(<font color="Blue">1-EXP(<font color="Red">-J13*13</font>)</font>)+O12*(<font color="Blue">1-EXP(<font color="Red">-J12*14</font>)</font>)+O11*(<font color="Blue">1-EXP(<font color="Red">-J11*15</font>)</font>)+O10*(<font color="Blue">1-EXP(<font color="Red">-J10*16</font>)</font>)+O9*(<font color="Blue">1-EXP(<font color="Red">-J9*17</font>)</font>)+O8*(<font color="Blue">1-EXP(<font color="Red">-J8*18</font>)</font>)+O7*(<font color="Blue">1-EXP(<font color="Red">-J7*19</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O26</th><td style="text-align:left">=M26-M25</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P26</th><td style="text-align:left">=N26-N25</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q26</th><td style="text-align:left">=R26+S26</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R26</th><td style="text-align:left">=O26*(<font color="Blue">1-EXP(<font color="Red">-J26*1</font>)</font>)+O25*(<font color="Blue">1-EXP(<font color="Red">-J25*2</font>)</font>)+O24*(<font color="Blue">1-EXP(<font color="Red">-J24*3</font>)</font>)+O23*(<font color="Blue">1-EXP(<font color="Red">-J23*4</font>)</font>)+O22*(<font color="Blue">1-EXP(<font color="Red">-J22*5</font>)</font>)+O21*(<font color="Blue">1-EXP(<font color="Red">-J21*6</font>)</font>)+O20*(<font color="Blue">1-EXP(<font color="Red">-J20*7</font>)</font>)+O19*(<font color="Blue">1-EXP(<font color="Red">-J19*8</font>)</font>)+O18*(<font color="Blue">1-EXP(<font color="Red">-J18*9</font>)</font>)+O17*(<font color="Blue">1-EXP(<font color="Red">-J17*10</font>)</font>)+O16*(<font color="Blue">1-EXP(<font color="Red">-J16*11</font>)</font>)+O15*(<font color="Blue">1-EXP(<font color="Red">-J15*12</font>)</font>)+O14*(<font color="Blue">1-EXP(<font color="Red">-J14*13</font>)</font>)+O13*(<font color="Blue">1-EXP(<font color="Red">-J13*14</font>)</font>)+O12*(<font color="Blue">1-EXP(<font color="Red">-J12*15</font>)</font>)+O11*(<font color="Blue">1-EXP(<font color="Red">-J11*16</font>)</font>)+O10*(<font color="Blue">1-EXP(<font color="Red">-J10*17</font>)</font>)+O9*(<font color="Blue">1-EXP(<font color="Red">-J9*18</font>)</font>)+O8*(<font color="Blue">1-EXP(<font color="Red">-J8*19</font>)</font>)+O7*(<font color="Blue">1-EXP(<font color="Red">-J7*20</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O27</th><td style="text-align:left">=M27-M26</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P27</th><td style="text-align:left">=N27-N26</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q27</th><td style="text-align:left">=R27+S27</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R27</th><td style="text-align:left">=O27*(<font color="Blue">1-EXP(<font color="Red">-J27*1</font>)</font>)+O26*(<font color="Blue">1-EXP(<font color="Red">-J26*2</font>)</font>)+O25*(<font color="Blue">1-EXP(<font color="Red">-J25*3</font>)</font>)+O24*(<font color="Blue">1-EXP(<font color="Red">-J24*4</font>)</font>)+O23*(<font color="Blue">1-EXP(<font color="Red">-J23*5</font>)</font>)+O22*(<font color="Blue">1-EXP(<font color="Red">-J22*6</font>)</font>)+O21*(<font color="Blue">1-EXP(<font color="Red">-J21*7</font>)</font>)+O20*(<font color="Blue">1-EXP(<font color="Red">-J20*8</font>)</font>)+O19*(<font color="Blue">1-EXP(<font color="Red">-J19*9</font>)</font>)+O18*(<font color="Blue">1-EXP(<font color="Red">-J18*10</font>)</font>)+O17*(<font color="Blue">1-EXP(<font color="Red">-J17*11</font>)</font>)+O16*(<font color="Blue">1-EXP(<font color="Red">-J16*12</font>)</font>)+O15*(<font color="Blue">1-EXP(<font color="Red">-J15*13</font>)</font>)+O14*(<font color="Blue">1-EXP(<font color="Red">-J14*14</font>)</font>)+O13*(<font color="Blue">1-EXP(<font color="Red">-J13*15</font>)</font>)+O12*(<font color="Blue">1-EXP(<font color="Red">-J12*16</font>)</font>)+O11*(<font color="Blue">1-EXP(<font color="Red">-J11*17</font>)</font>)+O10*(<font color="Blue">1-EXP(<font color="Red">-J10*18</font>)</font>)+O9*(<font color="Blue">1-EXP(<font color="Red">-J9*19</font>)</font>)+O8*(<font color="Blue">1-EXP(<font color="Red">-J8*20</font>)</font>) +O7*(<font color="Blue">1-EXP(<font color="Red">-J7*21</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O28</th><td style="text-align:left">=M28-M27</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P28</th><td style="text-align:left">=N28-N27</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q28</th><td style="text-align:left">=R28+S28</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R28</th><td style="text-align:left">=O28*(<font color="Blue">1-EXP(<font color="Red">-J28*1</font>)</font>)+O27*(<font color="Blue">1-EXP(<font color="Red">-J27*2</font>)</font>)+O26*(<font color="Blue">1-EXP(<font color="Red">-J26*3</font>)</font>)+O25*(<font color="Blue">1-EXP(<font color="Red">-J25*4</font>)</font>)+O24*(<font color="Blue">1-EXP(<font color="Red">-J24*5</font>)</font>)+O23*(<font color="Blue">1-EXP(<font color="Red">-J23*6</font>)</font>)+O22*(<font color="Blue">1-EXP(<font color="Red">-J22*7</font>)</font>)+O21*(<font color="Blue">1-EXP(<font color="Red">-J21*8</font>)</font>)+O20*(<font color="Blue">1-EXP(<font color="Red">-J20*9</font>)</font>)+O19*(<font color="Blue">1-EXP(<font color="Red">-J19*10</font>)</font>)+O18*(<font color="Blue">1-EXP(<font color="Red">-J18*11</font>)</font>)+O17*(<font color="Blue">1-EXP(<font color="Red">-J17*12</font>)</font>)+O16*(<font color="Blue">1-EXP(<font color="Red">-J16*13</font>)</font>)+O15*(<font color="Blue">1-EXP(<font color="Red">-J15*14</font>)</font>)+O14*(<font color="Blue">1-EXP(<font color="Red">-J14*15</font>)</font>)+O13*(<font color="Blue">1-EXP(<font color="Red">-J13*16</font>)</font>)+O12*(<font color="Blue">1-EXP(<font color="Red">-J12*17</font>)</font>)+O11*(<font color="Blue">1-EXP(<font color="Red">-J11*18</font>)</font>)+O10*(<font color="Blue">1-EXP(<font color="Red">-J10*19</font>)</font>)+O9*(<font color="Blue">1-EXP(<font color="Red">-J9*20</font>)</font>) +O8*(<font color="Blue">1-EXP(<font color="Red">-J8*21</font>)</font>)+O7*(<font color="Blue">1-EXP(<font color="Red">-J7*22</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O29</th><td style="text-align:left">=M29-M28</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P29</th><td style="text-align:left">=N29-N28</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q29</th><td style="text-align:left">=R29+S29</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R29</th><td style="text-align:left">=O29*(<font color="Blue">1-EXP(<font color="Red">-J29*1</font>)</font>)+O28*(<font color="Blue">1-EXP(<font color="Red">-J28*2</font>)</font>)+O27*(<font color="Blue">1-EXP(<font color="Red">-J27*3</font>)</font>)+O26*(<font color="Blue">1-EXP(<font color="Red">-J26*4</font>)</font>)+O25*(<font color="Blue">1-EXP(<font color="Red">-J25*5</font>)</font>)+O24*(<font color="Blue">1-EXP(<font color="Red">-J24*6</font>)</font>)+O23*(<font color="Blue">1-EXP(<font color="Red">-J23*7</font>)</font>)+O22*(<font color="Blue">1-EXP(<font color="Red">-J22*8</font>)</font>)+O21*(<font color="Blue">1-EXP(<font color="Red">-J21*9</font>)</font>)+O20*(<font color="Blue">1-EXP(<font color="Red">-J20*10</font>)</font>)+O19*(<font color="Blue">1-EXP(<font color="Red">-J19*11</font>)</font>)+O18*(<font color="Blue">1-EXP(<font color="Red">-J18*12</font>)</font>)+O17*(<font color="Blue">1-EXP(<font color="Red">-J17*13</font>)</font>)+O16*(<font color="Blue">1-EXP(<font color="Red">-J16*14</font>)</font>)+O15*(<font color="Blue">1-EXP(<font color="Red">-J15*15</font>)</font>)+O14*(<font color="Blue">1-EXP(<font color="Red">-J14*16</font>)</font>)+O13*(<font color="Blue">1-EXP(<font color="Red">-J13*17</font>)</font>)+O12*(<font color="Blue">1-EXP(<font color="Red">-J12*18</font>)</font>)+O11*(<font color="Blue">1-EXP(<font color="Red">-J11*19</font>)</font>)+O10*(<font color="Blue">1-EXP(<font color="Red">-J10*20</font>)</font>) +O9*(<font color="Blue">1-EXP(<font color="Red">-J9*21</font>)</font>)+O8*(<font color="Blue">1-EXP(<font color="Red">-J8*22</font>)</font>)+O7*(<font color="Blue">1-EXP(<font color="Red">-J7*23</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O30</th><td style="text-align:left">=M30-M29</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P30</th><td style="text-align:left">=N30-N29</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q30</th><td style="text-align:left">=R30+S30</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R30</th><td style="text-align:left">=O30*(<font color="Blue">1-EXP(<font color="Red">-J30*1</font>)</font>)+O29*(<font color="Blue">1-EXP(<font color="Red">-J29*2</font>)</font>)+O28*(<font color="Blue">1-EXP(<font color="Red">-J28*3</font>)</font>)+O27*(<font color="Blue">1-EXP(<font color="Red">-J27*4</font>)</font>)+O26*(<font color="Blue">1-EXP(<font color="Red">-J26*5</font>)</font>)+O25*(<font color="Blue">1-EXP(<font color="Red">-J25*6</font>)</font>)+O24*(<font color="Blue">1-EXP(<font color="Red">-J24*7</font>)</font>)+O23*(<font color="Blue">1-EXP(<font color="Red">-J23*8</font>)</font>)+O22*(<font color="Blue">1-EXP(<font color="Red">-J22*9</font>)</font>)+O21*(<font color="Blue">1-EXP(<font color="Red">-J21*10</font>)</font>)+O20*(<font color="Blue">1-EXP(<font color="Red">-J20*11</font>)</font>)+O19*(<font color="Blue">1-EXP(<font color="Red">-J19*12</font>)</font>)+O18*(<font color="Blue">1-EXP(<font color="Red">-J18*13</font>)</font>)+O17*(<font color="Blue">1-EXP(<font color="Red">-J17*14</font>)</font>)+O16*(<font color="Blue">1-EXP(<font color="Red">-J16*15</font>)</font>)+O15*(<font color="Blue">1-EXP(<font color="Red">-J15*16</font>)</font>)+O14*(<font color="Blue">1-EXP(<font color="Red">-J14*17</font>)</font>)+O13*(<font color="Blue">1-EXP(<font color="Red">-J13*18</font>)</font>)+O12*(<font color="Blue">1-EXP(<font color="Red">-J12*19</font>)</font>)+O11*(<font color="Blue">1-EXP(<font color="Red">-J11*20</font>)</font>) +O10*(<font color="Blue">1-EXP(<font color="Red">-J10*21</font>)</font>)+O9*(<font color="Blue">1-EXP(<font color="Red">-J9*22</font>)</font>)+O8*(<font color="Blue">1-EXP(<font color="Red">-J8*23</font>)</font>)+O7*(<font color="Blue">1-EXP(<font color="Red">-J7*24</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O31</th><td style="text-align:left">=M31-M30</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P31</th><td style="text-align:left">=N31-N30</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q31</th><td style="text-align:left">=R31+S31</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R31</th><td style="text-align:left">=O31*(<font color="Blue">1-EXP(<font color="Red">-J31*1</font>)</font>)+O30*(<font color="Blue">1-EXP(<font color="Red">-J30*2</font>)</font>)+O29*(<font color="Blue">1-EXP(<font color="Red">-J29*3</font>)</font>)+O28*(<font color="Blue">1-EXP(<font color="Red">-J28*4</font>)</font>)+O27*(<font color="Blue">1-EXP(<font color="Red">-J27*5</font>)</font>)+O26*(<font color="Blue">1-EXP(<font color="Red">-J26*6</font>)</font>)+O25*(<font color="Blue">1-EXP(<font color="Red">-J25*7</font>)</font>)+O24*(<font color="Blue">1-EXP(<font color="Red">-J24*8</font>)</font>)+O23*(<font color="Blue">1-EXP(<font color="Red">-J23*9</font>)</font>)+O22*(<font color="Blue">1-EXP(<font color="Red">-J22*10</font>)</font>)+O21*(<font color="Blue">1-EXP(<font color="Red">-J21*11</font>)</font>)+O20*(<font color="Blue">1-EXP(<font color="Red">-J20*12</font>)</font>)+O19*(<font color="Blue">1-EXP(<font color="Red">-J19*13</font>)</font>)+O18*(<font color="Blue">1-EXP(<font color="Red">-J18*14</font>)</font>)+O17*(<font color="Blue">1-EXP(<font color="Red">-J17*15</font>)</font>)+O16*(<font color="Blue">1-EXP(<font color="Red">-J16*16</font>)</font>)+O15*(<font color="Blue">1-EXP(<font color="Red">-J15*17</font>)</font>)+O14*(<font color="Blue">1-EXP(<font color="Red">-J14*18</font>)</font>)+O13*(<font color="Blue">1-EXP(<font color="Red">-J13*19</font>)</font>)+O12*(<font color="Blue">1-EXP(<font color="Red">-J12*20</font>)</font>) +O11*(<font color="Blue">1-EXP(<font color="Red">-J11*21</font>)</font>)+O10*(<font color="Blue">1-EXP(<font color="Red">-J10*22</font>)</font>)+O9*(<font color="Blue">1-EXP(<font color="Red">-J9*23</font>)</font>)+O8*(<font color="Blue">1-EXP(<font color="Red">-J8*24</font>)</font>) +O7*(<font color="Blue">1-EXP(<font color="Red">-J7*25</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O32</th><td style="text-align:left">=M32-M31</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P32</th><td style="text-align:left">=N32-N31</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q32</th><td style="text-align:left">=R32+S32</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R32</th><td style="text-align:left">=O32*(<font color="Blue">1-EXP(<font color="Red">-J32*1</font>)</font>)+O31*(<font color="Blue">1-EXP(<font color="Red">-J31*2</font>)</font>)+O30*(<font color="Blue">1-EXP(<font color="Red">-J30*3</font>)</font>)+O29*(<font color="Blue">1-EXP(<font color="Red">-J29*4</font>)</font>)+O28*(<font color="Blue">1-EXP(<font color="Red">-J28*5</font>)</font>)+O27*(<font color="Blue">1-EXP(<font color="Red">-J27*6</font>)</font>)+O26*(<font color="Blue">1-EXP(<font color="Red">-J26*7</font>)</font>)+O25*(<font color="Blue">1-EXP(<font color="Red">-J25*8</font>)</font>)+O24*(<font color="Blue">1-EXP(<font color="Red">-J24*9</font>)</font>)+O23*(<font color="Blue">1-EXP(<font color="Red">-J23*10</font>)</font>)+O22*(<font color="Blue">1-EXP(<font color="Red">-J22*11</font>)</font>)+O21*(<font color="Blue">1-EXP(<font color="Red">-J21*12</font>)</font>)+O20*(<font color="Blue">1-EXP(<font color="Red">-J20*13</font>)</font>)+O19*(<font color="Blue">1-EXP(<font color="Red">-J19*14</font>)</font>)+O18*(<font color="Blue">1-EXP(<font color="Red">-J18*15</font>)</font>)+O17*(<font color="Blue">1-EXP(<font color="Red">-J17*16</font>)</font>)+O16*(<font color="Blue">1-EXP(<font color="Red">-J16*17</font>)</font>)+O15*(<font color="Blue">1-EXP(<font color="Red">-J15*18</font>)</font>)+O14*(<font color="Blue">1-EXP(<font color="Red">-J14*19</font>)</font>)+O13*(<font color="Blue">1-EXP(<font color="Red">-J13*20</font>)</font>) +O12*(<font color="Blue">1-EXP(<font color="Red">-J12*21</font>)</font>)+O11*(<font color="Blue">1-EXP(<font color="Red">-J11*22</font>)</font>)+O10*(<font color="Blue">1-EXP(<font color="Red">-J10*23</font>)</font>)+O9*(<font color="Blue">1-EXP(<font color="Red">-J9*24</font>)</font>) +O8*(<font color="Blue">1-EXP(<font color="Red">-J8*25</font>)</font>)+O7*(<font color="Blue">1-EXP(<font color="Red">-J7*26</font>)</font>)</td></tr></tbody></table></td></tr></table><br />
 
Upvote 0
I could not figure out how to get it with native formulas, but here is a UDF that takes care of it:

Code: 
Public Function Sous2817(rng1 As Range, rng2 As Range)
Dim i   As Long
If rng1.Count <> rng2.Count Then
    Sous2817 = xlErrValue
Else
    For i = 1 To rng1.Count
        Sous2817 = Sous2817 + rng1.Cells(i, 1).Value * (1 - Exp((-1) * rng2.Cells(i, 1).Value * (rng1.Count + 1 - i)))
    Next i
End If
 
End Function

Excel 2007<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH></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></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">7</TD><TD style="TEXT-ALIGN: right">0.126</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">0</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">0</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">0</TD><TD style="TEXT-ALIGN: right">0</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">8</TD><TD style="TEXT-ALIGN: right">0.126</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">3</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">3</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">0.65</TD><TD style="TEXT-ALIGN: right">0.35515546</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">9</TD><TD style="TEXT-ALIGN: right">0.126</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">4</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">4</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">2.11</TD><TD style="TEXT-ALIGN: right">1.141806399</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">10</TD><TD style="TEXT-ALIGN: right">0.126</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">3</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">3</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">4.06</TD><TD style="TEXT-ALIGN: right">2.190485005</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">11</TD><TD style="TEXT-ALIGN: right">0.126</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">3</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">3</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">6.45</TD><TD style="TEXT-ALIGN: right">3.470171094</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">12</TD><TD style="TEXT-ALIGN: right">0.126</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">4</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">4</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">9.45</TD><TD style="TEXT-ALIGN: right">5.071901962</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">13</TD><TD style="TEXT-ALIGN: right">0.126</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">3</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">3</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">12.77</TD><TD style="TEXT-ALIGN: right">6.839167136</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">14</TD><TD style="TEXT-ALIGN: right">0.126</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">3</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">3</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">16.39</TD><TD style="TEXT-ALIGN: right">8.75236981</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">15</TD><TD style="TEXT-ALIGN: right">0.126</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">4</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">4</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">20.48</TD><TD style="TEXT-ALIGN: right">10.91261831</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">16</TD><TD style="TEXT-ALIGN: right">0.126</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">3</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">3</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">24.77</TD><TD style="TEXT-ALIGN: right">13.17228091</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">17</TD><TD style="TEXT-ALIGN: right">0.126</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">3</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">3</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">29.25</TD><TD style="TEXT-ALIGN: right">15.51958847</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">18</TD><TD style="TEXT-ALIGN: right">0.126</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">4</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">4</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">34.12</TD><TD style="TEXT-ALIGN: right">18.06255028</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">19</TD><TD style="TEXT-ALIGN: right">0.126</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">3</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">3</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">39.1</TD><TD style="TEXT-ALIGN: right">20.65961863</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">20</TD><TD style="TEXT-ALIGN: right">0.126</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">0</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">0</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">43.54</TD><TD style="TEXT-ALIGN: right">22.94923264</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">21</TD><TD style="TEXT-ALIGN: right">0.126</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">0</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">0</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">47.49</TD><TD style="TEXT-ALIGN: right">24.96779035</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">22</TD><TD style="TEXT-ALIGN: right">0.126</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">0</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">0</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">51.01</TD><TD style="TEXT-ALIGN: right">26.74738079</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">23</TD><TD style="TEXT-ALIGN: right">0.126</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">0</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">0</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">54.15</TD><TD style="TEXT-ALIGN: right">28.31629415</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">24</TD><TD style="TEXT-ALIGN: right">0.126</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">0</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">0</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">56.95</TD><TD style="TEXT-ALIGN: right">29.69947145</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">25</TD><TD style="TEXT-ALIGN: right">0.126</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">0</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">0</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">59.44</TD><TD style="TEXT-ALIGN: right">30.9189011</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">26</TD><TD style="TEXT-ALIGN: right">0.126</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">0</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">0</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">61.66</TD><TD style="TEXT-ALIGN: right">31.99396839</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">27</TD><TD style="TEXT-ALIGN: right">0.126</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">0</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">0</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">63.63</TD><TD style="TEXT-ALIGN: right">32.94176367</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">28</TD><TD style="TEXT-ALIGN: right">0.126</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">0</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">0</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">65.4</TD><TD style="TEXT-ALIGN: right">33.77735406</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">29</TD><TD style="TEXT-ALIGN: right">0.126</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">0</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">0</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff">66.97</TD><TD style="TEXT-ALIGN: right">34.51402295</TD></TR></TBODY></TABLE><TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH>Sheet1</TH></TR></TD></THEAD><TBODY></TBODY></TABLE>

<TABLE style="BORDER-BOTTOM: black 2px solid; BORDER-LEFT: black 2px solid; PADDING-BOTTOM: 0.4em; BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 0.4em; PADDING-RIGHT: 0.4em; BORDER-COLLAPSE: collapse; BORDER-TOP: black 2px solid; BORDER-RIGHT: black 2px solid; PADDING-TOP: 0.4em" rules=all cellPadding=2 width="85%"><TBODY><TR><TD style="PADDING-BOTTOM: 6px; PADDING-LEFT: 6px; PADDING-RIGHT: 6px; PADDING-TOP: 6px">Worksheet Formulas<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2 width="100%"><THEAD><TR style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH width=10>Cell</TH><TH style="TEXT-ALIGN: left; PADDING-LEFT: 5px">Formula</TH></TR></THEAD><TBODY><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>R7</TH><TD style="TEXT-ALIGN: left">=sous2817($O$7:O7,$J$7:J7)</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Question Question
VBA code clean up
Replies
9
Views
573
mumps
mumps
D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
617
smozgur
smozgur
E
  • Question Question
Adding a custom message.
Replies
1
Views
659
Micron
M
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
2K
CrashOD
C
G
  • Question Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G

Forum statistics

Threads
1,224,524
Messages
6,179,304
Members
452,904
Latest member
CodeMasterX

Share this page

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