Formula Streamline

Biz · Mar 10, 2015

Dear All,

I have derived a formula which looks at current month dates within a Scenario and then ascertains which contracts applies and then calculates the revenue.
It works, but wondering if there more streamlined approach.

Cell C66
=CHOOSE(SUMPRODUCT(--(C$65>=$B$31:$B$34),--(C$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(C42>Contract_1),(C42-Contract_1),CRates_1),SUMPRODUCT(--(C42>Contract_2),(C42-Contract_2),CRates_2),SUMPRODUCT(--(C42>Contract_3),(C42-Contract_3),CRates_3),SUMPRODUCT(--(C42>Contract_4),(C42-Contract_4),CRates_4))

Item in orange gets the correct contract 1 rates and then Choose selects a formula. There are four contracts and using choose there are too many Sumproducts which will down model calculation.

Is there a better way?

Sheet1

	A	B	C	D	E	F	G







Effective Date

<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 119px;"><col style="width: 119px;"><col style="width: 73px;"><col style="width: 73px;"><col style="width: 162px;"><col style="width: 78px;"><col style="width: 78px;"></colgroup><tbody>
[TD="bgcolor: #CACACA, align: center"]1[/TD]

[TD="bgcolor: #CACACA, align: center"]2[/TD]
[TD="bgcolor: #C0C0C0"]Contract 1[/TD]
[TD="bgcolor: #C0C0C0"] [/TD]

[TD="bgcolor: #CACACA, align: center"]3[/TD]
[TD="bgcolor: #FFFFCC, align: center"]Transaction No. is Greater Than:[/TD]
[TD="bgcolor: #FFFFCC"] [/TD]
[TD="bgcolor: #FFFFCC, align: center"]But Less Than or Equal to:[/TD]
[TD="bgcolor: #FFFFCC, align: center"]Revenue Rate[/TD]
[TD="bgcolor: #FFFFCC, align: center"]Differential rate[/TD]

[TD="bgcolor: #CACACA, align: center"]4[/TD]
[TD="bgcolor: #FFFFCC, align: right"] - [/TD]
[TD="bgcolor: #FFFFCC"] [/TD]
[TD="bgcolor: #FFFFCC, align: right"] 1,000,000 [/TD]
[TD="align: right"]$0.10 [/TD]
[TD="align: right"]$0.10 [/TD]

[TD="bgcolor: #CACACA, align: center"]5[/TD]
[TD="align: right"] 1,000,000 [/TD]

[TD="bgcolor: #FFFFCC, align: right"] 5,000,000 [/TD]
[TD="align: right"]$0.08 [/TD]
[TD="align: right"]($0.02)[/TD]

[TD="bgcolor: #CACACA, align: center"]6[/TD]
[TD="align: right"] 5,000,000 [/TD]

[TD="align: right"]$0.05 [/TD]
[TD="align: right"]($0.03)[/TD]

[TD="bgcolor: #CACACA, align: center"]7[/TD]

[TD="bgcolor: #CACACA, align: center"]8[/TD]

[TD="bgcolor: #FFFF99"] [/TD]

[TD="bgcolor: #CACACA, align: center"]9[/TD]
[TD="bgcolor: #FFCC99"]Contract 2[/TD]
[TD="bgcolor: #FFCC99"] [/TD]

[TD="bgcolor: #CACACA, align: center"]10[/TD]
[TD="bgcolor: #FFFFCC, align: center"]Transaction No. is Greater Than:[/TD]
[TD="bgcolor: #FFFFCC, align: center"]But Less Than or Equal to:[/TD]
[TD="bgcolor: #FFFFCC, align: center"]Revenue Rate[/TD]
[TD="bgcolor: #FFFFCC, align: center"]Differential rate[/TD]

[TD="bgcolor: #CACACA, align: center"]11[/TD]
[TD="bgcolor: #FFFFCC, align: right"] - [/TD]
[TD="bgcolor: #FFFFCC, align: right"] 1,000,000 [/TD]
[TD="align: right"]$0.03 [/TD]
[TD="align: right"]$0.03 [/TD]

[TD="bgcolor: #CACACA, align: center"]12[/TD]

[TD="bgcolor: #CACACA, align: center"]13[/TD]

[TD="bgcolor: #CACACA, align: center"]14[/TD]
[TD="bgcolor: #FFCC99"]Contract 3[/TD]

[TD="bgcolor: #CACACA, align: center"]15[/TD]
[TD="bgcolor: #FFFFCC, align: center"]Transaction No. is Greater Than:[/TD]
[TD="bgcolor: #FFFFCC, align: center"]But Less Than or Equal to:[/TD]
[TD="bgcolor: #FFFFCC, align: center"]Revenue Rate[/TD]
[TD="bgcolor: #FFFFCC, align: center"]Differential rate[/TD]

[TD="bgcolor: #CACACA, align: center"]16[/TD]
[TD="bgcolor: #FFFFCC, align: right"] - [/TD]
[TD="bgcolor: #FFFFCC, align: right"] 1,000,000 [/TD]
[TD="align: right"]$0.10 [/TD]
[TD="align: right"]$0.10 [/TD]

[TD="bgcolor: #CACACA, align: center"]17[/TD]
[TD="align: right"] 1,000,000 [/TD]
[TD="bgcolor: #FFFFCC, align: right"] 5,000,000 [/TD]
[TD="align: right"]$0.08 [/TD]
[TD="align: right"]($0.02)[/TD]

[TD="bgcolor: #CACACA, align: center"]18[/TD]
[TD="align: right"] 5,000,000 [/TD]

[TD="align: right"]$0.04 [/TD]
[TD="align: right"]($0.04)[/TD]

[TD="bgcolor: #CACACA, align: center"]19[/TD]

[TD="bgcolor: #CACACA, align: center"]20[/TD]

[TD="bgcolor: #CACACA, align: center"]21[/TD]
[TD="bgcolor: #FFCC99"]Contract 4[/TD]

[TD="bgcolor: #CACACA, align: center"]22[/TD]
[TD="bgcolor: #FFFFCC, align: center"]Transaction No. is Greater Than:[/TD]
[TD="bgcolor: #FFFFCC, align: center"]But Less Than or Equal to:[/TD]
[TD="bgcolor: #FFFFCC, align: center"]Revenue Rate[/TD]
[TD="bgcolor: #FFFFCC, align: center"]Differential rate[/TD]

[TD="bgcolor: #CACACA, align: center"]23[/TD]
[TD="bgcolor: #FFFFCC, align: right"] - [/TD]
[TD="bgcolor: #FFFFCC, align: right"] 1,000,000 [/TD]
[TD="align: right"]$0.08 [/TD]
[TD="align: right"]$0.08 [/TD]

[TD="bgcolor: #CACACA, align: center"]24[/TD]
[TD="align: right"] 1,000,000 [/TD]
[TD="bgcolor: #FFFFCC, align: right"] 5,000,000 [/TD]
[TD="align: right"]$0.06 [/TD]
[TD="align: right"]($0.02)[/TD]

[TD="bgcolor: #CACACA, align: center"]25[/TD]
[TD="align: right"] 5,000,000 [/TD]

[TD="align: right"]$0.04 [/TD]
[TD="align: right"]($0.02)[/TD]

</tbody>

Spreadsheet Formulas

Cell	Formula
E4	=D4
A5	=$B$16+0.01
E5	=D5-D4
A6	=$B$17+0.01
E6	=D6-D5
D11	=C11
D16	=C16
A17	=B16+0.01
D17	=C17-C16
A18	=B17+0.01
D18	=C18-C17
D23	=C23
A24	=B23+0.01
D24	=C24-C23
A25	=B24+0.01
D25	=C25-C24

Sheet1

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

Scenario 1

Scenario 2

Scenario 3

Scenario 4

Scenario 5

Scenario 6

Scenario 7

Contract Type

Start Date

<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 119px;"><col style="width: 119px;"><col style="width: 73px;"><col style="width: 73px;"><col style="width: 162px;"><col style="width: 78px;"><col style="width: 78px;"><col style="width: 78px;"><col style="width: 78px;"><col style="width: 78px;"><col style="width: 89px;"><col style="width: 89px;"><col style="width: 89px;"><col style="width: 89px;"><col style="width: 89px;"></colgroup><tbody>
[TD="bgcolor: #CACACA, align: center"]29[/TD]

[TD="bgcolor: #CACACA, align: center"]30[/TD]

[TD="align: left"]End date[/TD]

[TD="align: left"]End date[/TD]

[TD="align: left"]End date[/TD]

[TD="align: left"]End date[/TD]

[TD="align: left"]End date[/TD]

[TD="align: left"]End date[/TD]

[TD="align: left"]End date[/TD]

[TD="bgcolor: #CACACA, align: center"]31[/TD]
[TD="align: left"]Contract 1[/TD]
[TD="bgcolor: #FFFF99, align: right"]1/01/2015[/TD]
[TD="bgcolor: #FFFF99, align: right"]31/12/2016[/TD]
[TD="bgcolor: #FFFF99, align: right"]1/01/2015[/TD]
[TD="bgcolor: #FFFF99, align: right"]31/12/2016[/TD]
[TD="bgcolor: #FFFF99, align: right"]1/01/2015[/TD]
[TD="bgcolor: #FFFF99, align: right"]31/12/2016[/TD]
[TD="bgcolor: #FFFF99, align: right"]1/01/2015[/TD]
[TD="bgcolor: #FFFF99, align: right"]31/12/2016[/TD]
[TD="bgcolor: #FFFF99"] [/TD]
[TD="bgcolor: #FFFF99"] [/TD]
[TD="bgcolor: #FFFF99"] [/TD]
[TD="bgcolor: #FFFF99"] [/TD]
[TD="bgcolor: #FFFF99"] [/TD]
[TD="bgcolor: #FFFF99"] [/TD]

[TD="bgcolor: #CACACA, align: center"]32[/TD]
[TD="align: left"]Contract 2[/TD]
[TD="bgcolor: #FFFF99, align: right"]1/01/2017[/TD]
[TD="bgcolor: #FFFF99, align: right"]31/12/2020[/TD]
[TD="bgcolor: #FFFF99, align: right"]1/01/2017[/TD]
[TD="bgcolor: #FFFF99, align: right"]31/12/2020[/TD]
[TD="bgcolor: #FFFF99, align: right"]1/01/2017[/TD]
[TD="bgcolor: #FFFF99, align: right"]31/12/2020[/TD]
[TD="bgcolor: #FFFF99, align: right"]1/01/2017[/TD]
[TD="bgcolor: #FFFF99, align: right"]31/12/2020[/TD]
[TD="bgcolor: #FFFF99"] [/TD]
[TD="bgcolor: #FFFF99"] [/TD]
[TD="bgcolor: #FFFF99"] [/TD]
[TD="bgcolor: #FFFF99"] [/TD]
[TD="bgcolor: #FFFF99"] [/TD]
[TD="bgcolor: #FFFF99"] [/TD]

[TD="bgcolor: #CACACA, align: center"]33[/TD]
[TD="align: left"]Contract 3[/TD]
[TD="bgcolor: #FFFF99, align: right"]1/01/2021[/TD]
[TD="bgcolor: #FFFF99, align: right"]31/12/2024[/TD]
[TD="bgcolor: #FFFF99, align: right"]1/01/2021[/TD]
[TD="bgcolor: #FFFF99, align: right"]31/12/2024[/TD]
[TD="bgcolor: #FFFF99, align: right"]1/01/2021[/TD]
[TD="bgcolor: #FFFF99, align: right"]31/12/2024[/TD]
[TD="bgcolor: #FFFF99, align: right"]1/01/2021[/TD]
[TD="bgcolor: #FFFF99, align: right"]31/12/2024[/TD]
[TD="bgcolor: #FFFF99, align: right"]1/01/2015[/TD]
[TD="bgcolor: #FFFF99, align: right"]31/12/2020[/TD]
[TD="bgcolor: #FFFF99, align: right"]1/01/2015[/TD]
[TD="bgcolor: #FFFF99, align: right"]31/12/2020[/TD]
[TD="bgcolor: #FFFF99"] [/TD]
[TD="bgcolor: #FFFF99"] [/TD]

[TD="bgcolor: #CACACA, align: center"]34[/TD]
[TD="align: left"]Contract 4[/TD]
[TD="bgcolor: #FFFF99"] [/TD]
[TD="bgcolor: #FFFF99"] [/TD]
[TD="bgcolor: #FFFF99"] [/TD]
[TD="bgcolor: #FFFF99"] [/TD]
[TD="bgcolor: #FFFF99"] [/TD]
[TD="bgcolor: #FFFF99"] [/TD]
[TD="bgcolor: #FFFF99"] [/TD]
[TD="bgcolor: #FFFF99"] [/TD]
[TD="bgcolor: #FFFF99, align: right"]1/01/2021[/TD]
[TD="bgcolor: #FFFF99, align: right"]31/12/2024[/TD]
[TD="bgcolor: #FFFF99, align: right"]1/01/2021[/TD]
[TD="bgcolor: #FFFF99, align: right"]31/12/2024[/TD]
[TD="bgcolor: #FFFF99, align: right"]1/01/2015[/TD]
[TD="bgcolor: #FFFF99, align: right"]31/12/2024[/TD]

</tbody>

Sheet1

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

Person1

Person2

Person3

Person4

Person5

Person6

Person7

Person8

Person9

Person10

Person11

Person12

Person13

Person14

Person15

Person16

Person17

Person18

<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 119px;"><col style="width: 119px;"><col style="width: 73px;"><col style="width: 73px;"><col style="width: 162px;"><col style="width: 78px;"><col style="width: 78px;"><col style="width: 78px;"><col style="width: 78px;"><col style="width: 78px;"><col style="width: 89px;"><col style="width: 89px;"><col style="width: 89px;"><col style="width: 89px;"><col style="width: 89px;"></colgroup><tbody>
[TD="bgcolor: #CACACA, align: center"]40[/TD]
[TD="bgcolor: #008080"]Total Transactions[/TD]
[TD="bgcolor: #008080"] [/TD]

[TD="bgcolor: #CACACA, align: center"]41[/TD]

[TD="align: center"]Start Date[/TD]
[TD="align: center"]Jan-15[/TD]
[TD="align: center"]Feb-15[/TD]
[TD="align: center"]Mar-15[/TD]
[TD="align: center"]Apr-15[/TD]
[TD="align: center"]May-15[/TD]
[TD="align: center"]Jun-15[/TD]
[TD="align: center"]Jul-15[/TD]
[TD="align: center"]Aug-15[/TD]
[TD="align: center"]Sep-15[/TD]
[TD="align: center"]Oct-15[/TD]
[TD="align: center"]Nov-15[/TD]
[TD="align: center"]Dec-15[/TD]
[TD="align: center"]Jan-16[/TD]

[TD="bgcolor: #CACACA, align: center"]42[/TD]

[TD="align: right"]01/04/2015[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]939,789 [/TD]
[TD="align: right"]1,225,385 [/TD]
[TD="align: right"]1,596,110 [/TD]
[TD="align: right"]2,076,251 [/TD]
[TD="align: right"]2,696,307 [/TD]
[TD="align: right"]3,494,120 [/TD]
[TD="align: right"]4,515,942 [/TD]
[TD="align: right"]5,817,148 [/TD]
[TD="align: right"]7,462,254 [/TD]
[TD="align: right"]9,523,749 [/TD]

[TD="bgcolor: #CACACA, align: center"]43[/TD]

[TD="align: right"]01/04/2015[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]1,273,167 [/TD]
[TD="align: right"]1,660,077 [/TD]
[TD="align: right"]2,162,314 [/TD]
[TD="align: right"]2,812,772 [/TD]
[TD="align: right"]3,652,787 [/TD]
[TD="align: right"]4,733,618 [/TD]
[TD="align: right"]6,117,925 [/TD]
[TD="align: right"]7,880,714 [/TD]
[TD="align: right"]10,109,398 [/TD]
[TD="align: right"]12,902,185 [/TD]

[TD="bgcolor: #CACACA, align: center"]44[/TD]

[TD="align: right"]01/05/2015[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]343,044 [/TD]
[TD="align: right"]447,291 [/TD]
[TD="align: right"]582,613 [/TD]
[TD="align: right"]757,871 [/TD]
[TD="align: right"]984,201 [/TD]
[TD="align: right"]1,275,428 [/TD]
[TD="align: right"]1,648,415 [/TD]
[TD="align: right"]2,123,378 [/TD]
[TD="align: right"]2,723,868 [/TD]

[TD="bgcolor: #CACACA, align: center"]45[/TD]

[TD="align: right"]01/05/2015[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]379,899 [/TD]
[TD="align: right"]495,340 [/TD]
[TD="align: right"]645,198 [/TD]
[TD="align: right"]839,291 [/TD]
[TD="align: right"]1,089,932 [/TD]
[TD="align: right"]1,412,445 [/TD]
[TD="align: right"]1,825,493 [/TD]
[TD="align: right"]2,351,492 [/TD]
[TD="align: right"]3,016,493 [/TD]

[TD="bgcolor: #CACACA, align: center"]46[/TD]

[TD="align: right"]01/05/2015[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]733,455 [/TD]
[TD="align: right"]956,348 [/TD]
[TD="align: right"]1,245,675 [/TD]
[TD="align: right"]1,620,393 [/TD]
[TD="align: right"]2,104,310 [/TD]
[TD="align: right"]2,726,964 [/TD]
[TD="align: right"]3,524,438 [/TD]
[TD="align: right"]4,539,956 [/TD]
[TD="align: right"]5,823,869 [/TD]

[TD="bgcolor: #CACACA, align: center"]47[/TD]

[TD="align: right"]01/05/2015[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]969,444 [/TD]
[TD="align: right"]1,264,052 [/TD]
[TD="align: right"]1,646,475 [/TD]
[TD="align: right"]2,141,763 [/TD]
[TD="align: right"]2,781,375 [/TD]
[TD="align: right"]3,604,362 [/TD]
[TD="align: right"]4,658,435 [/TD]
[TD="align: right"]6,000,694 [/TD]
[TD="align: right"]7,697,704 [/TD]

[TD="bgcolor: #CACACA, align: center"]48[/TD]

[TD="align: right"]01/06/2015[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]82,233 [/TD]
[TD="align: right"]107,223 [/TD]
[TD="align: right"]139,657 [/TD]
[TD="align: right"]181,673 [/TD]
[TD="align: right"]235,924 [/TD]
[TD="align: right"]305,733 [/TD]
[TD="align: right"]395,146 [/TD]
[TD="align: right"]508,999 [/TD]

[TD="bgcolor: #CACACA, align: center"]49[/TD]

[TD="align: right"]01/07/2015[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]161,244 [/TD]
[TD="align: right"]210,240 [/TD]
[TD="align: right"]273,848 [/TD]
[TD="align: right"]356,232 [/TD]
[TD="align: right"]462,615 [/TD]
[TD="align: right"]599,495 [/TD]
[TD="align: right"]774,809 [/TD]

[TD="bgcolor: #CACACA, align: center"]50[/TD]

[TD="align: right"]01/07/2015[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]316,134 [/TD]
[TD="align: right"]412,206 [/TD]
[TD="align: right"]536,922 [/TD]
[TD="align: right"]698,428 [/TD]
[TD="align: right"]907,013 [/TD]
[TD="align: right"]1,175,394 [/TD]
[TD="align: right"]1,519,121 [/TD]

[TD="bgcolor: #CACACA, align: center"]51[/TD]

[TD="align: right"]01/08/2015[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]181,044 [/TD]
[TD="align: right"]236,061 [/TD]
[TD="align: right"]307,477 [/TD]
[TD="align: right"]399,967 [/TD]
[TD="align: right"]519,420 [/TD]
[TD="align: right"]673,108 [/TD]

[TD="bgcolor: #CACACA, align: center"]52[/TD]

[TD="align: right"]01/12/2015[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]31,833 [/TD]
[TD="align: right"]41,507 [/TD]

[TD="bgcolor: #CACACA, align: center"]53[/TD]

[TD="align: right"]01/11/2015[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]52,101 [/TD]
[TD="align: right"]67,942 [/TD]
[TD="align: right"]88,490 [/TD]

[TD="bgcolor: #CACACA, align: center"]54[/TD]

[TD="align: right"]01/09/2015[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]277,488 [/TD]
[TD="align: right"]361,811 [/TD]
[TD="align: right"]471,268 [/TD]
[TD="align: right"]613,038 [/TD]
[TD="align: right"]796,119 [/TD]

[TD="bgcolor: #CACACA, align: center"]55[/TD]

[TD="align: right"]01/10/2015[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]123,912 [/TD]
[TD="align: right"]161,577 [/TD]
[TD="align: right"]210,451 [/TD]
[TD="align: right"]273,768 [/TD]

[TD="bgcolor: #CACACA, align: center"]56[/TD]

[TD="align: right"]01/09/2026[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]

[TD="bgcolor: #CACACA, align: center"]57[/TD]

[TD="align: right"]01/10/2026[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]

[TD="bgcolor: #CACACA, align: center"]58[/TD]

[TD="align: right"]01/03/2015[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]4,044,978 [/TD]
[TD="align: right"]5,274,220 [/TD]
[TD="align: right"]6,869,877 [/TD]
[TD="align: right"]8,936,458 [/TD]
[TD="align: right"]11,605,248 [/TD]
[TD="align: right"]15,039,152 [/TD]
[TD="align: right"]19,437,231 [/TD]
[TD="align: right"]25,037,794 [/TD]
[TD="align: right"]32,118,531 [/TD]
[TD="align: right"]40,991,475 [/TD]
[TD="align: right"]51,990,000 [/TD]

[TD="bgcolor: #CACACA, align: center"]59[/TD]

[TD="align: right"]01/03/2015[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]535,545 [/TD]
[TD="align: right"]698,296 [/TD]
[TD="align: right"]909,559 [/TD]
[TD="align: right"]1,183,168 [/TD]
[TD="align: right"]1,536,516 [/TD]
[TD="align: right"]1,991,150 [/TD]
[TD="align: right"]2,573,453 [/TD]
[TD="align: right"]3,314,954 [/TD]
[TD="align: right"]4,252,433 [/TD]
[TD="align: right"]5,427,191 [/TD]
[TD="align: right"]6,883,373 [/TD]

[TD="bgcolor: #CACACA, align: center"]60[/TD]

[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]4,580,523 [/TD]
[TD="align: right"]8,185,472 [/TD]
[TD="align: right"]13,090,741 [/TD]
[TD="align: right"]17,123,313 [/TD]
[TD="align: right"]22,735,348 [/TD]
[TD="align: right"]29,681,861 [/TD]
[TD="align: right"]38,704,233 [/TD]
[TD="align: right"]50,089,600 [/TD]
[TD="align: right"]64,485,880 [/TD]
[TD="align: right"]82,618,558 [/TD]
[TD="align: right"]105,237,163 [/TD]

</tbody>

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

Revenue

Person1

Person2

Person3

Person4

Person5

Person6

Person7

Person8

Person9

Person10

Person11

Person12

Person13

Person14

Person15

Person16

Person17

Person18

<tbody>
[TD="bgcolor: #CACACA, align: center"]64[/TD]

[TD="bgcolor: #CACACA, align: center"]65[/TD]
[TD="bgcolor: #008080"]Sceanrio 1[/TD]
[TD="bgcolor: #008080"] [/TD]
[TD="align: right"]Jan-15[/TD]
[TD="align: right"]Feb-15[/TD]
[TD="align: right"]Mar-15[/TD]
[TD="align: right"]Apr-15[/TD]
[TD="align: right"]May-15[/TD]
[TD="align: right"]Jun-15[/TD]
[TD="align: right"]Jul-15[/TD]
[TD="align: right"]Aug-15[/TD]
[TD="align: right"]Sep-15[/TD]
[TD="align: right"]Oct-15[/TD]
[TD="align: right"]Nov-15[/TD]
[TD="align: right"]Dec-15[/TD]
[TD="align: right"]Jan-16[/TD]

[TD="bgcolor: #CACACA, align: center"]66[/TD]

[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$93,978.90[/TD]
[TD="align: right"]$118,030.84[/TD]
[TD="align: right"]$147,688.79[/TD]
[TD="align: right"]$186,100.09[/TD]
[TD="align: right"]$235,704.54[/TD]
[TD="align: right"]$299,529.62[/TD]
[TD="align: right"]$381,275.39[/TD]
[TD="align: right"]$460,857.39[/TD]
[TD="align: right"]$543,112.68[/TD]
[TD="align: right"]$646,187.43[/TD]

[TD="bgcolor: #CACACA, align: center"]67[/TD]

[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$121,853.36[/TD]
[TD="align: right"]$152,806.19[/TD]
[TD="align: right"]$192,985.11[/TD]
[TD="align: right"]$245,021.79[/TD]
[TD="align: right"]$312,222.95[/TD]
[TD="align: right"]$398,689.42[/TD]
[TD="align: right"]$475,896.26[/TD]
[TD="align: right"]$564,035.71[/TD]
[TD="align: right"]$675,469.89[/TD]
[TD="align: right"]$815,109.25[/TD]

[TD="bgcolor: #CACACA, align: center"]68[/TD]

[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$34,304.40[/TD]
[TD="align: right"]$44,729.07[/TD]
[TD="align: right"]$58,261.28[/TD]
[TD="align: right"]$75,787.12[/TD]
[TD="align: right"]$98,420.13[/TD]
[TD="align: right"]$122,034.23[/TD]
[TD="align: right"]$151,873.17[/TD]
[TD="align: right"]$189,870.22[/TD]
[TD="align: right"]$237,909.48[/TD]

[TD="bgcolor: #CACACA, align: center"]69[/TD]

[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$37,989.90[/TD]
[TD="align: right"]$49,534.03[/TD]
[TD="align: right"]$64,519.78[/TD]
[TD="align: right"]$83,929.11[/TD]
[TD="align: right"]$107,194.57[/TD]
[TD="align: right"]$132,995.64[/TD]
[TD="align: right"]$166,039.43[/TD]
[TD="align: right"]$208,119.35[/TD]
[TD="align: right"]$261,319.43[/TD]

[TD="bgcolor: #CACACA, align: center"]70[/TD]

[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$73,345.50[/TD]
[TD="align: right"]$95,634.77[/TD]
[TD="align: right"]$119,653.98[/TD]
[TD="align: right"]$149,631.40[/TD]
[TD="align: right"]$188,344.84[/TD]
[TD="align: right"]$238,157.09[/TD]
[TD="align: right"]$301,955.06[/TD]
[TD="align: right"]$383,196.49[/TD]
[TD="align: right"]$461,193.44[/TD]

[TD="bgcolor: #CACACA, align: center"]71[/TD]

[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$96,944.40[/TD]
[TD="align: right"]$121,124.20[/TD]
[TD="align: right"]$151,717.97[/TD]
[TD="align: right"]$191,341.05[/TD]
[TD="align: right"]$242,509.99[/TD]
[TD="align: right"]$308,348.98[/TD]
[TD="align: right"]$392,674.79[/TD]
[TD="align: right"]$470,034.70[/TD]
[TD="align: right"]$554,885.18[/TD]

[TD="bgcolor: #CACACA, align: center"]72[/TD]

[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$8,223.30[/TD]
[TD="align: right"]$10,722.29[/TD]
[TD="align: right"]$13,965.73[/TD]
[TD="align: right"]$18,167.29[/TD]
[TD="align: right"]$23,592.44[/TD]
[TD="align: right"]$30,573.26[/TD]
[TD="align: right"]$39,514.65[/TD]
[TD="align: right"]$50,899.93[/TD]

[TD="bgcolor: #CACACA, align: center"]73[/TD]

[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$16,124.40[/TD]
[TD="align: right"]$21,024.02[/TD]
[TD="align: right"]$27,384.81[/TD]
[TD="align: right"]$35,623.24[/TD]
[TD="align: right"]$46,261.49[/TD]
[TD="align: right"]$59,949.49[/TD]
[TD="align: right"]$77,480.90[/TD]

[TD="bgcolor: #CACACA, align: center"]74[/TD]

[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$31,613.40[/TD]
[TD="align: right"]$41,220.64[/TD]
[TD="align: right"]$53,692.17[/TD]
[TD="align: right"]$69,842.79[/TD]
[TD="align: right"]$90,701.34[/TD]
[TD="align: right"]$114,031.52[/TD]
[TD="align: right"]$141,529.69[/TD]

[TD="bgcolor: #CACACA, align: center"]75[/TD]

[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$18,104.40[/TD]
[TD="align: right"]$23,606.09[/TD]
[TD="align: right"]$30,747.74[/TD]
[TD="align: right"]$39,996.72[/TD]
[TD="align: right"]$51,942.05[/TD]
[TD="align: right"]$67,310.78[/TD]

[TD="bgcolor: #CACACA, align: center"]76[/TD]

[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$3,183.30[/TD]
[TD="align: right"]$4,150.74[/TD]

[TD="bgcolor: #CACACA, align: center"]77[/TD]

[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$5,210.10[/TD]
[TD="align: right"]$6,794.21[/TD]
[TD="align: right"]$8,849.03[/TD]

[TD="bgcolor: #CACACA, align: center"]78[/TD]

[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$27,748.80[/TD]
[TD="align: right"]$36,181.10[/TD]
[TD="align: right"]$47,126.75[/TD]
[TD="align: right"]$61,303.81[/TD]
[TD="align: right"]$79,611.92[/TD]

[TD="bgcolor: #CACACA, align: center"]79[/TD]

[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$12,391.20[/TD]
[TD="align: right"]$16,157.66[/TD]
[TD="align: right"]$21,045.14[/TD]
[TD="align: right"]$27,376.78[/TD]

[TD="bgcolor: #CACACA, align: center"]80[/TD]

[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]

[TD="bgcolor: #CACACA, align: center"]81[/TD]

[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]

[TD="bgcolor: #CACACA, align: center"]82[/TD]

[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$343,598.24[/TD]
[TD="align: right"]$433,711.00[/TD]
[TD="align: right"]$513,493.87[/TD]
[TD="align: right"]$616,822.88[/TD]
[TD="align: right"]$750,262.40[/TD]
[TD="align: right"]$921,957.60[/TD]
[TD="align: right"]$1,141,861.57[/TD]
[TD="align: right"]$1,421,889.70[/TD]
[TD="align: right"]$1,775,926.55[/TD]
[TD="align: right"]$2,219,573.77[/TD]
[TD="align: right"]$2,769,500.02[/TD]

[TD="bgcolor: #CACACA, align: center"]83[/TD]

[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$53,554.50[/TD]
[TD="align: right"]$69,829.61[/TD]
[TD="align: right"]$90,955.88[/TD]
[TD="align: right"]$114,653.41[/TD]
[TD="align: right"]$142,921.26[/TD]
[TD="align: right"]$179,292.00[/TD]
[TD="align: right"]$225,876.24[/TD]
[TD="align: right"]$285,196.32[/TD]
[TD="align: right"]$360,194.67[/TD]
[TD="align: right"]$441,359.55[/TD]
[TD="align: right"]$514,168.68[/TD]

[TD="bgcolor: #CACACA, align: center"]84[/TD]

[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]397,153 [/TD]
[TD="align: right"]719,373 [/TD]
[TD="align: right"]1,117,871 [/TD]
[TD="align: right"]1,391,396 [/TD]
[TD="align: right"]1,776,919 [/TD]
[TD="align: right"]2,244,181 [/TD]
[TD="align: right"]2,853,026 [/TD]
[TD="align: right"]3,574,172 [/TD]
[TD="align: right"]4,449,584 [/TD]
[TD="align: right"]5,488,501 [/TD]
[TD="align: right"]6,717,483 [/TD]

</tbody>

Spreadsheet Formulas

Cell	Formula
C65	=C41
D65	=D41
E65	=E41
F65	=F41
G65	=G41
H65	=H41
I65	=I41
J65	=J41
K65	=K41
L65	=L41
M65	=M41
N65	=N41
O65	=O41
C66	=CHOOSE(SUMPRODUCT(--(C$65>=$B$31:$B$34),--(C$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(C42>Contract_1),(C42-Contract_1),CRates_1),SUMPRODUCT(--(C42>Contract_2),(C42-Contract_2),CRates_2),SUMPRODUCT(--(C42>Contract_3),(C42-Contract_3),CRates_3),SUMPRODUCT(--(C42>Contract_4),(C42-Contract_4),CRates_4))
D66	=CHOOSE(SUMPRODUCT(--(D$65>=$B$31:$B$34),--(D$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(D42>Contract_1),(D42-Contract_1),CRates_1),SUMPRODUCT(--(D42>Contract_2),(D42-Contract_2),CRates_2),SUMPRODUCT(--(D42>Contract_3),(D42-Contract_3),CRates_3),SUMPRODUCT(--(D42>Contract_4),(D42-Contract_4),CRates_4))
E66	=CHOOSE(SUMPRODUCT(--(E$65>=$B$31:$B$34),--(E$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(E42>Contract_1),(E42-Contract_1),CRates_1),SUMPRODUCT(--(E42>Contract_2),(E42-Contract_2),CRates_2),SUMPRODUCT(--(E42>Contract_3),(E42-Contract_3),CRates_3),SUMPRODUCT(--(E42>Contract_4),(E42-Contract_4),CRates_4))
F66	=CHOOSE(SUMPRODUCT(--(F$65>=$B$31:$B$34),--(F$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(F42>Contract_1),(F42-Contract_1),CRates_1),SUMPRODUCT(--(F42>Contract_2),(F42-Contract_2),CRates_2),SUMPRODUCT(--(F42>Contract_3),(F42-Contract_3),CRates_3),SUMPRODUCT(--(F42>Contract_4),(F42-Contract_4),CRates_4))
G66	=CHOOSE(SUMPRODUCT(--(G$65>=$B$31:$B$34),--(G$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(G42>Contract_1),(G42-Contract_1),CRates_1),SUMPRODUCT(--(G42>Contract_2),(G42-Contract_2),CRates_2),SUMPRODUCT(--(G42>Contract_3),(G42-Contract_3),CRates_3),SUMPRODUCT(--(G42>Contract_4),(G42-Contract_4),CRates_4))
H66	=CHOOSE(SUMPRODUCT(--(H$65>=$B$31:$B$34),--(H$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(H42>Contract_1),(H42-Contract_1),CRates_1),SUMPRODUCT(--(H42>Contract_2),(H42-Contract_2),CRates_2),SUMPRODUCT(--(H42>Contract_3),(H42-Contract_3),CRates_3),SUMPRODUCT(--(H42>Contract_4),(H42-Contract_4),CRates_4))
I66	=CHOOSE(SUMPRODUCT(--(I$65>=$B$31:$B$34),--(I$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(I42>Contract_1),(I42-Contract_1),CRates_1),SUMPRODUCT(--(I42>Contract_2),(I42-Contract_2),CRates_2),SUMPRODUCT(--(I42>Contract_3),(I42-Contract_3),CRates_3),SUMPRODUCT(--(I42>Contract_4),(I42-Contract_4),CRates_4))
J66	=CHOOSE(SUMPRODUCT(--(J$65>=$B$31:$B$34),--(J$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(J42>Contract_1),(J42-Contract_1),CRates_1),SUMPRODUCT(--(J42>Contract_2),(J42-Contract_2),CRates_2),SUMPRODUCT(--(J42>Contract_3),(J42-Contract_3),CRates_3),SUMPRODUCT(--(J42>Contract_4),(J42-Contract_4),CRates_4))
K66	=CHOOSE(SUMPRODUCT(--(K$65>=$B$31:$B$34),--(K$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(K42>Contract_1),(K42-Contract_1),CRates_1),SUMPRODUCT(--(K42>Contract_2),(K42-Contract_2),CRates_2),SUMPRODUCT(--(K42>Contract_3),(K42-Contract_3),CRates_3),SUMPRODUCT(--(K42>Contract_4),(K42-Contract_4),CRates_4))
L66	=CHOOSE(SUMPRODUCT(--(L$65>=$B$31:$B$34),--(L$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(L42>Contract_1),(L42-Contract_1),CRates_1),SUMPRODUCT(--(L42>Contract_2),(L42-Contract_2),CRates_2),SUMPRODUCT(--(L42>Contract_3),(L42-Contract_3),CRates_3),SUMPRODUCT(--(L42>Contract_4),(L42-Contract_4),CRates_4))
M66	=CHOOSE(SUMPRODUCT(--(M$65>=$B$31:$B$34),--(M$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(M42>Contract_1),(M42-Contract_1),CRates_1),SUMPRODUCT(--(M42>Contract_2),(M42-Contract_2),CRates_2),SUMPRODUCT(--(M42>Contract_3),(M42-Contract_3),CRates_3),SUMPRODUCT(--(M42>Contract_4),(M42-Contract_4),CRates_4))
N66	=CHOOSE(SUMPRODUCT(--(N$65>=$B$31:$B$34),--(N$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(N42>Contract_1),(N42-Contract_1),CRates_1),SUMPRODUCT(--(N42>Contract_2),(N42-Contract_2),CRates_2),SUMPRODUCT(--(N42>Contract_3),(N42-Contract_3),CRates_3),SUMPRODUCT(--(N42>Contract_4),(N42-Contract_4),CRates_4))
O66	=CHOOSE(SUMPRODUCT(--(O$65>=$B$31:$B$34),--(O$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(O42>Contract_1),(O42-Contract_1),CRates_1),SUMPRODUCT(--(O42>Contract_2),(O42-Contract_2),CRates_2),SUMPRODUCT(--(O42>Contract_3),(O42-Contract_3),CRates_3),SUMPRODUCT(--(O42>Contract_4),(O42-Contract_4),CRates_4))
C67	=CHOOSE(SUMPRODUCT(--(C$65>=$B$31:$B$34),--(C$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(C43>Contract_1),(C43-Contract_1),CRates_1),SUMPRODUCT(--(C43>Contract_2),(C43-Contract_2),CRates_2),SUMPRODUCT(--(C43>Contract_3),(C43-Contract_3),CRates_3),SUMPRODUCT(--(C43>Contract_4),(C43-Contract_4),CRates_4))
D67	=CHOOSE(SUMPRODUCT(--(D$65>=$B$31:$B$34),--(D$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(D43>Contract_1),(D43-Contract_1),CRates_1),SUMPRODUCT(--(D43>Contract_2),(D43-Contract_2),CRates_2),SUMPRODUCT(--(D43>Contract_3),(D43-Contract_3),CRates_3),SUMPRODUCT(--(D43>Contract_4),(D43-Contract_4),CRates_4))
E67	=CHOOSE(SUMPRODUCT(--(E$65>=$B$31:$B$34),--(E$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(E43>Contract_1),(E43-Contract_1),CRates_1),SUMPRODUCT(--(E43>Contract_2),(E43-Contract_2),CRates_2),SUMPRODUCT(--(E43>Contract_3),(E43-Contract_3),CRates_3),SUMPRODUCT(--(E43>Contract_4),(E43-Contract_4),CRates_4))
F67	=CHOOSE(SUMPRODUCT(--(F$65>=$B$31:$B$34),--(F$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(F43>Contract_1),(F43-Contract_1),CRates_1),SUMPRODUCT(--(F43>Contract_2),(F43-Contract_2),CRates_2),SUMPRODUCT(--(F43>Contract_3),(F43-Contract_3),CRates_3),SUMPRODUCT(--(F43>Contract_4),(F43-Contract_4),CRates_4))
G67	=CHOOSE(SUMPRODUCT(--(G$65>=$B$31:$B$34),--(G$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(G43>Contract_1),(G43-Contract_1),CRates_1),SUMPRODUCT(--(G43>Contract_2),(G43-Contract_2),CRates_2),SUMPRODUCT(--(G43>Contract_3),(G43-Contract_3),CRates_3),SUMPRODUCT(--(G43>Contract_4),(G43-Contract_4),CRates_4))
H67	=CHOOSE(SUMPRODUCT(--(H$65>=$B$31:$B$34),--(H$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(H43>Contract_1),(H43-Contract_1),CRates_1),SUMPRODUCT(--(H43>Contract_2),(H43-Contract_2),CRates_2),SUMPRODUCT(--(H43>Contract_3),(H43-Contract_3),CRates_3),SUMPRODUCT(--(H43>Contract_4),(H43-Contract_4),CRates_4))
I67	=CHOOSE(SUMPRODUCT(--(I$65>=$B$31:$B$34),--(I$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(I43>Contract_1),(I43-Contract_1),CRates_1),SUMPRODUCT(--(I43>Contract_2),(I43-Contract_2),CRates_2),SUMPRODUCT(--(I43>Contract_3),(I43-Contract_3),CRates_3),SUMPRODUCT(--(I43>Contract_4),(I43-Contract_4),CRates_4))
J67	=CHOOSE(SUMPRODUCT(--(J$65>=$B$31:$B$34),--(J$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(J43>Contract_1),(J43-Contract_1),CRates_1),SUMPRODUCT(--(J43>Contract_2),(J43-Contract_2),CRates_2),SUMPRODUCT(--(J43>Contract_3),(J43-Contract_3),CRates_3),SUMPRODUCT(--(J43>Contract_4),(J43-Contract_4),CRates_4))
K67	=CHOOSE(SUMPRODUCT(--(K$65>=$B$31:$B$34),--(K$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(K43>Contract_1),(K43-Contract_1),CRates_1),SUMPRODUCT(--(K43>Contract_2),(K43-Contract_2),CRates_2),SUMPRODUCT(--(K43>Contract_3),(K43-Contract_3),CRates_3),SUMPRODUCT(--(K43>Contract_4),(K43-Contract_4),CRates_4))
L67	=CHOOSE(SUMPRODUCT(--(L$65>=$B$31:$B$34),--(L$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(L43>Contract_1),(L43-Contract_1),CRates_1),SUMPRODUCT(--(L43>Contract_2),(L43-Contract_2),CRates_2),SUMPRODUCT(--(L43>Contract_3),(L43-Contract_3),CRates_3),SUMPRODUCT(--(L43>Contract_4),(L43-Contract_4),CRates_4))
M67	=CHOOSE(SUMPRODUCT(--(M$65>=$B$31:$B$34),--(M$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(M43>Contract_1),(M43-Contract_1),CRates_1),SUMPRODUCT(--(M43>Contract_2),(M43-Contract_2),CRates_2),SUMPRODUCT(--(M43>Contract_3),(M43-Contract_3),CRates_3),SUMPRODUCT(--(M43>Contract_4),(M43-Contract_4),CRates_4))
N67	=CHOOSE(SUMPRODUCT(--(N$65>=$B$31:$B$34),--(N$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(N43>Contract_1),(N43-Contract_1),CRates_1),SUMPRODUCT(--(N43>Contract_2),(N43-Contract_2),CRates_2),SUMPRODUCT(--(N43>Contract_3),(N43-Contract_3),CRates_3),SUMPRODUCT(--(N43>Contract_4),(N43-Contract_4),CRates_4))
O67	=CHOOSE(SUMPRODUCT(--(O$65>=$B$31:$B$34),--(O$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(O43>Contract_1),(O43-Contract_1),CRates_1),SUMPRODUCT(--(O43>Contract_2),(O43-Contract_2),CRates_2),SUMPRODUCT(--(O43>Contract_3),(O43-Contract_3),CRates_3),SUMPRODUCT(--(O43>Contract_4),(O43-Contract_4),CRates_4))
C68	=CHOOSE(SUMPRODUCT(--(C$65>=$B$31:$B$34),--(C$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(C44>Contract_1),(C44-Contract_1),CRates_1),SUMPRODUCT(--(C44>Contract_2),(C44-Contract_2),CRates_2),SUMPRODUCT(--(C44>Contract_3),(C44-Contract_3),CRates_3),SUMPRODUCT(--(C44>Contract_4),(C44-Contract_4),CRates_4))
D68	=CHOOSE(SUMPRODUCT(--(D$65>=$B$31:$B$34),--(D$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(D44>Contract_1),(D44-Contract_1),CRates_1),SUMPRODUCT(--(D44>Contract_2),(D44-Contract_2),CRates_2),SUMPRODUCT(--(D44>Contract_3),(D44-Contract_3),CRates_3),SUMPRODUCT(--(D44>Contract_4),(D44-Contract_4),CRates_4))
E68	=CHOOSE(SUMPRODUCT(--(E$65>=$B$31:$B$34),--(E$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(E44>Contract_1),(E44-Contract_1),CRates_1),SUMPRODUCT(--(E44>Contract_2),(E44-Contract_2),CRates_2),SUMPRODUCT(--(E44>Contract_3),(E44-Contract_3),CRates_3),SUMPRODUCT(--(E44>Contract_4),(E44-Contract_4),CRates_4))
F68	=CHOOSE(SUMPRODUCT(--(F$65>=$B$31:$B$34),--(F$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(F44>Contract_1),(F44-Contract_1),CRates_1),SUMPRODUCT(--(F44>Contract_2),(F44-Contract_2),CRates_2),SUMPRODUCT(--(F44>Contract_3),(F44-Contract_3),CRates_3),SUMPRODUCT(--(F44>Contract_4),(F44-Contract_4),CRates_4))
G68	=CHOOSE(SUMPRODUCT(--(G$65>=$B$31:$B$34),--(G$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(G44>Contract_1),(G44-Contract_1),CRates_1),SUMPRODUCT(--(G44>Contract_2),(G44-Contract_2),CRates_2),SUMPRODUCT(--(G44>Contract_3),(G44-Contract_3),CRates_3),SUMPRODUCT(--(G44>Contract_4),(G44-Contract_4),CRates_4))
H68	=CHOOSE(SUMPRODUCT(--(H$65>=$B$31:$B$34),--(H$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(H44>Contract_1),(H44-Contract_1),CRates_1),SUMPRODUCT(--(H44>Contract_2),(H44-Contract_2),CRates_2),SUMPRODUCT(--(H44>Contract_3),(H44-Contract_3),CRates_3),SUMPRODUCT(--(H44>Contract_4),(H44-Contract_4),CRates_4))
I68	=CHOOSE(SUMPRODUCT(--(I$65>=$B$31:$B$34),--(I$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(I44>Contract_1),(I44-Contract_1),CRates_1),SUMPRODUCT(--(I44>Contract_2),(I44-Contract_2),CRates_2),SUMPRODUCT(--(I44>Contract_3),(I44-Contract_3),CRates_3),SUMPRODUCT(--(I44>Contract_4),(I44-Contract_4),CRates_4))
J68	=CHOOSE(SUMPRODUCT(--(J$65>=$B$31:$B$34),--(J$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(J44>Contract_1),(J44-Contract_1),CRates_1),SUMPRODUCT(--(J44>Contract_2),(J44-Contract_2),CRates_2),SUMPRODUCT(--(J44>Contract_3),(J44-Contract_3),CRates_3),SUMPRODUCT(--(J44>Contract_4),(J44-Contract_4),CRates_4))
K68	=CHOOSE(SUMPRODUCT(--(K$65>=$B$31:$B$34),--(K$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(K44>Contract_1),(K44-Contract_1),CRates_1),SUMPRODUCT(--(K44>Contract_2),(K44-Contract_2),CRates_2),SUMPRODUCT(--(K44>Contract_3),(K44-Contract_3),CRates_3),SUMPRODUCT(--(K44>Contract_4),(K44-Contract_4),CRates_4))
L68	=CHOOSE(SUMPRODUCT(--(L$65>=$B$31:$B$34),--(L$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(L44>Contract_1),(L44-Contract_1),CRates_1),SUMPRODUCT(--(L44>Contract_2),(L44-Contract_2),CRates_2),SUMPRODUCT(--(L44>Contract_3),(L44-Contract_3),CRates_3),SUMPRODUCT(--(L44>Contract_4),(L44-Contract_4),CRates_4))
M68	=CHOOSE(SUMPRODUCT(--(M$65>=$B$31:$B$34),--(M$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(M44>Contract_1),(M44-Contract_1),CRates_1),SUMPRODUCT(--(M44>Contract_2),(M44-Contract_2),CRates_2),SUMPRODUCT(--(M44>Contract_3),(M44-Contract_3),CRates_3),SUMPRODUCT(--(M44>Contract_4),(M44-Contract_4),CRates_4))
N68	=CHOOSE(SUMPRODUCT(--(N$65>=$B$31:$B$34),--(N$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(N44>Contract_1),(N44-Contract_1),CRates_1),SUMPRODUCT(--(N44>Contract_2),(N44-Contract_2),CRates_2),SUMPRODUCT(--(N44>Contract_3),(N44-Contract_3),CRates_3),SUMPRODUCT(--(N44>Contract_4),(N44-Contract_4),CRates_4))
O68	=CHOOSE(SUMPRODUCT(--(O$65>=$B$31:$B$34),--(O$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(O44>Contract_1),(O44-Contract_1),CRates_1),SUMPRODUCT(--(O44>Contract_2),(O44-Contract_2),CRates_2),SUMPRODUCT(--(O44>Contract_3),(O44-Contract_3),CRates_3),SUMPRODUCT(--(O44>Contract_4),(O44-Contract_4),CRates_4))
C69	=CHOOSE(SUMPRODUCT(--(C$65>=$B$31:$B$34),--(C$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(C45>Contract_1),(C45-Contract_1),CRates_1),SUMPRODUCT(--(C45>Contract_2),(C45-Contract_2),CRates_2),SUMPRODUCT(--(C45>Contract_3),(C45-Contract_3),CRates_3),SUMPRODUCT(--(C45>Contract_4),(C45-Contract_4),CRates_4))
D69	=CHOOSE(SUMPRODUCT(--(D$65>=$B$31:$B$34),--(D$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(D45>Contract_1),(D45-Contract_1),CRates_1),SUMPRODUCT(--(D45>Contract_2),(D45-Contract_2),CRates_2),SUMPRODUCT(--(D45>Contract_3),(D45-Contract_3),CRates_3),SUMPRODUCT(--(D45>Contract_4),(D45-Contract_4),CRates_4))
E69	=CHOOSE(SUMPRODUCT(--(E$65>=$B$31:$B$34),--(E$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(E45>Contract_1),(E45-Contract_1),CRates_1),SUMPRODUCT(--(E45>Contract_2),(E45-Contract_2),CRates_2),SUMPRODUCT(--(E45>Contract_3),(E45-Contract_3),CRates_3),SUMPRODUCT(--(E45>Contract_4),(E45-Contract_4),CRates_4))
F69	=CHOOSE(SUMPRODUCT(--(F$65>=$B$31:$B$34),--(F$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(F45>Contract_1),(F45-Contract_1),CRates_1),SUMPRODUCT(--(F45>Contract_2),(F45-Contract_2),CRates_2),SUMPRODUCT(--(F45>Contract_3),(F45-Contract_3),CRates_3),SUMPRODUCT(--(F45>Contract_4),(F45-Contract_4),CRates_4))
G69	=CHOOSE(SUMPRODUCT(--(G$65>=$B$31:$B$34),--(G$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(G45>Contract_1),(G45-Contract_1),CRates_1),SUMPRODUCT(--(G45>Contract_2),(G45-Contract_2),CRates_2),SUMPRODUCT(--(G45>Contract_3),(G45-Contract_3),CRates_3),SUMPRODUCT(--(G45>Contract_4),(G45-Contract_4),CRates_4))
H69	=CHOOSE(SUMPRODUCT(--(H$65>=$B$31:$B$34),--(H$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(H45>Contract_1),(H45-Contract_1),CRates_1),SUMPRODUCT(--(H45>Contract_2),(H45-Contract_2),CRates_2),SUMPRODUCT(--(H45>Contract_3),(H45-Contract_3),CRates_3),SUMPRODUCT(--(H45>Contract_4),(H45-Contract_4),CRates_4))
I69	=CHOOSE(SUMPRODUCT(--(I$65>=$B$31:$B$34),--(I$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(I45>Contract_1),(I45-Contract_1),CRates_1),SUMPRODUCT(--(I45>Contract_2),(I45-Contract_2),CRates_2),SUMPRODUCT(--(I45>Contract_3),(I45-Contract_3),CRates_3),SUMPRODUCT(--(I45>Contract_4),(I45-Contract_4),CRates_4))
J69	=CHOOSE(SUMPRODUCT(--(J$65>=$B$31:$B$34),--(J$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(J45>Contract_1),(J45-Contract_1),CRates_1),SUMPRODUCT(--(J45>Contract_2),(J45-Contract_2),CRates_2),SUMPRODUCT(--(J45>Contract_3),(J45-Contract_3),CRates_3),SUMPRODUCT(--(J45>Contract_4),(J45-Contract_4),CRates_4))
K69	=CHOOSE(SUMPRODUCT(--(K$65>=$B$31:$B$34),--(K$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(K45>Contract_1),(K45-Contract_1),CRates_1),SUMPRODUCT(--(K45>Contract_2),(K45-Contract_2),CRates_2),SUMPRODUCT(--(K45>Contract_3),(K45-Contract_3),CRates_3),SUMPRODUCT(--(K45>Contract_4),(K45-Contract_4),CRates_4))
L69	=CHOOSE(SUMPRODUCT(--(L$65>=$B$31:$B$34),--(L$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(L45>Contract_1),(L45-Contract_1),CRates_1),SUMPRODUCT(--(L45>Contract_2),(L45-Contract_2),CRates_2),SUMPRODUCT(--(L45>Contract_3),(L45-Contract_3),CRates_3),SUMPRODUCT(--(L45>Contract_4),(L45-Contract_4),CRates_4))
M69	=CHOOSE(SUMPRODUCT(--(M$65>=$B$31:$B$34),--(M$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(M45>Contract_1),(M45-Contract_1),CRates_1),SUMPRODUCT(--(M45>Contract_2),(M45-Contract_2),CRates_2),SUMPRODUCT(--(M45>Contract_3),(M45-Contract_3),CRates_3),SUMPRODUCT(--(M45>Contract_4),(M45-Contract_4),CRates_4))
N69	=CHOOSE(SUMPRODUCT(--(N$65>=$B$31:$B$34),--(N$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(N45>Contract_1),(N45-Contract_1),CRates_1),SUMPRODUCT(--(N45>Contract_2),(N45-Contract_2),CRates_2),SUMPRODUCT(--(N45>Contract_3),(N45-Contract_3),CRates_3),SUMPRODUCT(--(N45>Contract_4),(N45-Contract_4),CRates_4))
O69	=CHOOSE(SUMPRODUCT(--(O$65>=$B$31:$B$34),--(O$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(O45>Contract_1),(O45-Contract_1),CRates_1),SUMPRODUCT(--(O45>Contract_2),(O45-Contract_2),CRates_2),SUMPRODUCT(--(O45>Contract_3),(O45-Contract_3),CRates_3),SUMPRODUCT(--(O45>Contract_4),(O45-Contract_4),CRates_4))
C70	=CHOOSE(SUMPRODUCT(--(C$65>=$B$31:$B$34),--(C$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(C46>Contract_1),(C46-Contract_1),CRates_1),SUMPRODUCT(--(C46>Contract_2),(C46-Contract_2),CRates_2),SUMPRODUCT(--(C46>Contract_3),(C46-Contract_3),CRates_3),SUMPRODUCT(--(C46>Contract_4),(C46-Contract_4),CRates_4))
D70	=CHOOSE(SUMPRODUCT(--(D$65>=$B$31:$B$34),--(D$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(D46>Contract_1),(D46-Contract_1),CRates_1),SUMPRODUCT(--(D46>Contract_2),(D46-Contract_2),CRates_2),SUMPRODUCT(--(D46>Contract_3),(D46-Contract_3),CRates_3),SUMPRODUCT(--(D46>Contract_4),(D46-Contract_4),CRates_4))
E70	=CHOOSE(SUMPRODUCT(--(E$65>=$B$31:$B$34),--(E$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(E46>Contract_1),(E46-Contract_1),CRates_1),SUMPRODUCT(--(E46>Contract_2),(E46-Contract_2),CRates_2),SUMPRODUCT(--(E46>Contract_3),(E46-Contract_3),CRates_3),SUMPRODUCT(--(E46>Contract_4),(E46-Contract_4),CRates_4))
F70	=CHOOSE(SUMPRODUCT(--(F$65>=$B$31:$B$34),--(F$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(F46>Contract_1),(F46-Contract_1),CRates_1),SUMPRODUCT(--(F46>Contract_2),(F46-Contract_2),CRates_2),SUMPRODUCT(--(F46>Contract_3),(F46-Contract_3),CRates_3),SUMPRODUCT(--(F46>Contract_4),(F46-Contract_4),CRates_4))
G70	=CHOOSE(SUMPRODUCT(--(G$65>=$B$31:$B$34),--(G$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(G46>Contract_1),(G46-Contract_1),CRates_1),SUMPRODUCT(--(G46>Contract_2),(G46-Contract_2),CRates_2),SUMPRODUCT(--(G46>Contract_3),(G46-Contract_3),CRates_3),SUMPRODUCT(--(G46>Contract_4),(G46-Contract_4),CRates_4))
H70	=CHOOSE(SUMPRODUCT(--(H$65>=$B$31:$B$34),--(H$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(H46>Contract_1),(H46-Contract_1),CRates_1),SUMPRODUCT(--(H46>Contract_2),(H46-Contract_2),CRates_2),SUMPRODUCT(--(H46>Contract_3),(H46-Contract_3),CRates_3),SUMPRODUCT(--(H46>Contract_4),(H46-Contract_4),CRates_4))
I70	=CHOOSE(SUMPRODUCT(--(I$65>=$B$31:$B$34),--(I$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(I46>Contract_1),(I46-Contract_1),CRates_1),SUMPRODUCT(--(I46>Contract_2),(I46-Contract_2),CRates_2),SUMPRODUCT(--(I46>Contract_3),(I46-Contract_3),CRates_3),SUMPRODUCT(--(I46>Contract_4),(I46-Contract_4),CRates_4))
J70	=CHOOSE(SUMPRODUCT(--(J$65>=$B$31:$B$34),--(J$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(J46>Contract_1),(J46-Contract_1),CRates_1),SUMPRODUCT(--(J46>Contract_2),(J46-Contract_2),CRates_2),SUMPRODUCT(--(J46>Contract_3),(J46-Contract_3),CRates_3),SUMPRODUCT(--(J46>Contract_4),(J46-Contract_4),CRates_4))
K70	=CHOOSE(SUMPRODUCT(--(K$65>=$B$31:$B$34),--(K$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(K46>Contract_1),(K46-Contract_1),CRates_1),SUMPRODUCT(--(K46>Contract_2),(K46-Contract_2),CRates_2),SUMPRODUCT(--(K46>Contract_3),(K46-Contract_3),CRates_3),SUMPRODUCT(--(K46>Contract_4),(K46-Contract_4),CRates_4))
L70	=CHOOSE(SUMPRODUCT(--(L$65>=$B$31:$B$34),--(L$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(L46>Contract_1),(L46-Contract_1),CRates_1),SUMPRODUCT(--(L46>Contract_2),(L46-Contract_2),CRates_2),SUMPRODUCT(--(L46>Contract_3),(L46-Contract_3),CRates_3),SUMPRODUCT(--(L46>Contract_4),(L46-Contract_4),CRates_4))
M70	=CHOOSE(SUMPRODUCT(--(M$65>=$B$31:$B$34),--(M$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(M46>Contract_1),(M46-Contract_1),CRates_1),SUMPRODUCT(--(M46>Contract_2),(M46-Contract_2),CRates_2),SUMPRODUCT(--(M46>Contract_3),(M46-Contract_3),CRates_3),SUMPRODUCT(--(M46>Contract_4),(M46-Contract_4),CRates_4))
N70	=CHOOSE(SUMPRODUCT(--(N$65>=$B$31:$B$34),--(N$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(N46>Contract_1),(N46-Contract_1),CRates_1),SUMPRODUCT(--(N46>Contract_2),(N46-Contract_2),CRates_2),SUMPRODUCT(--(N46>Contract_3),(N46-Contract_3),CRates_3),SUMPRODUCT(--(N46>Contract_4),(N46-Contract_4),CRates_4))
O70	=CHOOSE(SUMPRODUCT(--(O$65>=$B$31:$B$34),--(O$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(O46>Contract_1),(O46-Contract_1),CRates_1),SUMPRODUCT(--(O46>Contract_2),(O46-Contract_2),CRates_2),SUMPRODUCT(--(O46>Contract_3),(O46-Contract_3),CRates_3),SUMPRODUCT(--(O46>Contract_4),(O46-Contract_4),CRates_4))
C71	=CHOOSE(SUMPRODUCT(--(C$65>=$B$31:$B$34),--(C$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(C47>Contract_1),(C47-Contract_1),CRates_1),SUMPRODUCT(--(C47>Contract_2),(C47-Contract_2),CRates_2),SUMPRODUCT(--(C47>Contract_3),(C47-Contract_3),CRates_3),SUMPRODUCT(--(C47>Contract_4),(C47-Contract_4),CRates_4))
D71	=CHOOSE(SUMPRODUCT(--(D$65>=$B$31:$B$34),--(D$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(D47>Contract_1),(D47-Contract_1),CRates_1),SUMPRODUCT(--(D47>Contract_2),(D47-Contract_2),CRates_2),SUMPRODUCT(--(D47>Contract_3),(D47-Contract_3),CRates_3),SUMPRODUCT(--(D47>Contract_4),(D47-Contract_4),CRates_4))
E71	=CHOOSE(SUMPRODUCT(--(E$65>=$B$31:$B$34),--(E$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(E47>Contract_1),(E47-Contract_1),CRates_1),SUMPRODUCT(--(E47>Contract_2),(E47-Contract_2),CRates_2),SUMPRODUCT(--(E47>Contract_3),(E47-Contract_3),CRates_3),SUMPRODUCT(--(E47>Contract_4),(E47-Contract_4),CRates_4))
F71	=CHOOSE(SUMPRODUCT(--(F$65>=$B$31:$B$34),--(F$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(F47>Contract_1),(F47-Contract_1),CRates_1),SUMPRODUCT(--(F47>Contract_2),(F47-Contract_2),CRates_2),SUMPRODUCT(--(F47>Contract_3),(F47-Contract_3),CRates_3),SUMPRODUCT(--(F47>Contract_4),(F47-Contract_4),CRates_4))
G71	=CHOOSE(SUMPRODUCT(--(G$65>=$B$31:$B$34),--(G$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(G47>Contract_1),(G47-Contract_1),CRates_1),SUMPRODUCT(--(G47>Contract_2),(G47-Contract_2),CRates_2),SUMPRODUCT(--(G47>Contract_3),(G47-Contract_3),CRates_3),SUMPRODUCT(--(G47>Contract_4),(G47-Contract_4),CRates_4))
H71	=CHOOSE(SUMPRODUCT(--(H$65>=$B$31:$B$34),--(H$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(H47>Contract_1),(H47-Contract_1),CRates_1),SUMPRODUCT(--(H47>Contract_2),(H47-Contract_2),CRates_2),SUMPRODUCT(--(H47>Contract_3),(H47-Contract_3),CRates_3),SUMPRODUCT(--(H47>Contract_4),(H47-Contract_4),CRates_4))
I71	=CHOOSE(SUMPRODUCT(--(I$65>=$B$31:$B$34),--(I$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(I47>Contract_1),(I47-Contract_1),CRates_1),SUMPRODUCT(--(I47>Contract_2),(I47-Contract_2),CRates_2),SUMPRODUCT(--(I47>Contract_3),(I47-Contract_3),CRates_3),SUMPRODUCT(--(I47>Contract_4),(I47-Contract_4),CRates_4))
J71	=CHOOSE(SUMPRODUCT(--(J$65>=$B$31:$B$34),--(J$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(J47>Contract_1),(J47-Contract_1),CRates_1),SUMPRODUCT(--(J47>Contract_2),(J47-Contract_2),CRates_2),SUMPRODUCT(--(J47>Contract_3),(J47-Contract_3),CRates_3),SUMPRODUCT(--(J47>Contract_4),(J47-Contract_4),CRates_4))
K71	=CHOOSE(SUMPRODUCT(--(K$65>=$B$31:$B$34),--(K$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(K47>Contract_1),(K47-Contract_1),CRates_1),SUMPRODUCT(--(K47>Contract_2),(K47-Contract_2),CRates_2),SUMPRODUCT(--(K47>Contract_3),(K47-Contract_3),CRates_3),SUMPRODUCT(--(K47>Contract_4),(K47-Contract_4),CRates_4))
L71	=CHOOSE(SUMPRODUCT(--(L$65>=$B$31:$B$34),--(L$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(L47>Contract_1),(L47-Contract_1),CRates_1),SUMPRODUCT(--(L47>Contract_2),(L47-Contract_2),CRates_2),SUMPRODUCT(--(L47>Contract_3),(L47-Contract_3),CRates_3),SUMPRODUCT(--(L47>Contract_4),(L47-Contract_4),CRates_4))
M71	=CHOOSE(SUMPRODUCT(--(M$65>=$B$31:$B$34),--(M$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(M47>Contract_1),(M47-Contract_1),CRates_1),SUMPRODUCT(--(M47>Contract_2),(M47-Contract_2),CRates_2),SUMPRODUCT(--(M47>Contract_3),(M47-Contract_3),CRates_3),SUMPRODUCT(--(M47>Contract_4),(M47-Contract_4),CRates_4))
N71	=CHOOSE(SUMPRODUCT(--(N$65>=$B$31:$B$34),--(N$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(N47>Contract_1),(N47-Contract_1),CRates_1),SUMPRODUCT(--(N47>Contract_2),(N47-Contract_2),CRates_2),SUMPRODUCT(--(N47>Contract_3),(N47-Contract_3),CRates_3),SUMPRODUCT(--(N47>Contract_4),(N47-Contract_4),CRates_4))
O71	=CHOOSE(SUMPRODUCT(--(O$65>=$B$31:$B$34),--(O$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(O47>Contract_1),(O47-Contract_1),CRates_1),SUMPRODUCT(--(O47>Contract_2),(O47-Contract_2),CRates_2),SUMPRODUCT(--(O47>Contract_3),(O47-Contract_3),CRates_3),SUMPRODUCT(--(O47>Contract_4),(O47-Contract_4),CRates_4))
C72	=CHOOSE(SUMPRODUCT(--(C$65>=$B$31:$B$34),--(C$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(C48>Contract_1),(C48-Contract_1),CRates_1),SUMPRODUCT(--(C48>Contract_2),(C48-Contract_2),CRates_2),SUMPRODUCT(--(C48>Contract_3),(C48-Contract_3),CRates_3),SUMPRODUCT(--(C48>Contract_4),(C48-Contract_4),CRates_4))
D72	=CHOOSE(SUMPRODUCT(--(D$65>=$B$31:$B$34),--(D$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(D48>Contract_1),(D48-Contract_1),CRates_1),SUMPRODUCT(--(D48>Contract_2),(D48-Contract_2),CRates_2),SUMPRODUCT(--(D48>Contract_3),(D48-Contract_3),CRates_3),SUMPRODUCT(--(D48>Contract_4),(D48-Contract_4),CRates_4))
E72	=CHOOSE(SUMPRODUCT(--(E$65>=$B$31:$B$34),--(E$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(E48>Contract_1),(E48-Contract_1),CRates_1),SUMPRODUCT(--(E48>Contract_2),(E48-Contract_2),CRates_2),SUMPRODUCT(--(E48>Contract_3),(E48-Contract_3),CRates_3),SUMPRODUCT(--(E48>Contract_4),(E48-Contract_4),CRates_4))
F72	=CHOOSE(SUMPRODUCT(--(F$65>=$B$31:$B$34),--(F$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(F48>Contract_1),(F48-Contract_1),CRates_1),SUMPRODUCT(--(F48>Contract_2),(F48-Contract_2),CRates_2),SUMPRODUCT(--(F48>Contract_3),(F48-Contract_3),CRates_3),SUMPRODUCT(--(F48>Contract_4),(F48-Contract_4),CRates_4))
G72	=CHOOSE(SUMPRODUCT(--(G$65>=$B$31:$B$34),--(G$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(G48>Contract_1),(G48-Contract_1),CRates_1),SUMPRODUCT(--(G48>Contract_2),(G48-Contract_2),CRates_2),SUMPRODUCT(--(G48>Contract_3),(G48-Contract_3),CRates_3),SUMPRODUCT(--(G48>Contract_4),(G48-Contract_4),CRates_4))
H72	=CHOOSE(SUMPRODUCT(--(H$65>=$B$31:$B$34),--(H$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(H48>Contract_1),(H48-Contract_1),CRates_1),SUMPRODUCT(--(H48>Contract_2),(H48-Contract_2),CRates_2),SUMPRODUCT(--(H48>Contract_3),(H48-Contract_3),CRates_3),SUMPRODUCT(--(H48>Contract_4),(H48-Contract_4),CRates_4))
I72	=CHOOSE(SUMPRODUCT(--(I$65>=$B$31:$B$34),--(I$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(I48>Contract_1),(I48-Contract_1),CRates_1),SUMPRODUCT(--(I48>Contract_2),(I48-Contract_2),CRates_2),SUMPRODUCT(--(I48>Contract_3),(I48-Contract_3),CRates_3),SUMPRODUCT(--(I48>Contract_4),(I48-Contract_4),CRates_4))
J72	=CHOOSE(SUMPRODUCT(--(J$65>=$B$31:$B$34),--(J$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(J48>Contract_1),(J48-Contract_1),CRates_1),SUMPRODUCT(--(J48>Contract_2),(J48-Contract_2),CRates_2),SUMPRODUCT(--(J48>Contract_3),(J48-Contract_3),CRates_3),SUMPRODUCT(--(J48>Contract_4),(J48-Contract_4),CRates_4))
K72	=CHOOSE(SUMPRODUCT(--(K$65>=$B$31:$B$34),--(K$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(K48>Contract_1),(K48-Contract_1),CRates_1),SUMPRODUCT(--(K48>Contract_2),(K48-Contract_2),CRates_2),SUMPRODUCT(--(K48>Contract_3),(K48-Contract_3),CRates_3),SUMPRODUCT(--(K48>Contract_4),(K48-Contract_4),CRates_4))
L72	=CHOOSE(SUMPRODUCT(--(L$65>=$B$31:$B$34),--(L$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(L48>Contract_1),(L48-Contract_1),CRates_1),SUMPRODUCT(--(L48>Contract_2),(L48-Contract_2),CRates_2),SUMPRODUCT(--(L48>Contract_3),(L48-Contract_3),CRates_3),SUMPRODUCT(--(L48>Contract_4),(L48-Contract_4),CRates_4))
M72	=CHOOSE(SUMPRODUCT(--(M$65>=$B$31:$B$34),--(M$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(M48>Contract_1),(M48-Contract_1),CRates_1),SUMPRODUCT(--(M48>Contract_2),(M48-Contract_2),CRates_2),SUMPRODUCT(--(M48>Contract_3),(M48-Contract_3),CRates_3),SUMPRODUCT(--(M48>Contract_4),(M48-Contract_4),CRates_4))
N72	=CHOOSE(SUMPRODUCT(--(N$65>=$B$31:$B$34),--(N$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(N48>Contract_1),(N48-Contract_1),CRates_1),SUMPRODUCT(--(N48>Contract_2),(N48-Contract_2),CRates_2),SUMPRODUCT(--(N48>Contract_3),(N48-Contract_3),CRates_3),SUMPRODUCT(--(N48>Contract_4),(N48-Contract_4),CRates_4))
O72	=CHOOSE(SUMPRODUCT(--(O$65>=$B$31:$B$34),--(O$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(O48>Contract_1),(O48-Contract_1),CRates_1),SUMPRODUCT(--(O48>Contract_2),(O48-Contract_2),CRates_2),SUMPRODUCT(--(O48>Contract_3),(O48-Contract_3),CRates_3),SUMPRODUCT(--(O48>Contract_4),(O48-Contract_4),CRates_4))
C73	=CHOOSE(SUMPRODUCT(--(C$65>=$B$31:$B$34),--(C$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(C49>Contract_1),(C49-Contract_1),CRates_1),SUMPRODUCT(--(C49>Contract_2),(C49-Contract_2),CRates_2),SUMPRODUCT(--(C49>Contract_3),(C49-Contract_3),CRates_3),SUMPRODUCT(--(C49>Contract_4),(C49-Contract_4),CRates_4))
D73	=CHOOSE(SUMPRODUCT(--(D$65>=$B$31:$B$34),--(D$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(D49>Contract_1),(D49-Contract_1),CRates_1),SUMPRODUCT(--(D49>Contract_2),(D49-Contract_2),CRates_2),SUMPRODUCT(--(D49>Contract_3),(D49-Contract_3),CRates_3),SUMPRODUCT(--(D49>Contract_4),(D49-Contract_4),CRates_4))
E73	=CHOOSE(SUMPRODUCT(--(E$65>=$B$31:$B$34),--(E$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(E49>Contract_1),(E49-Contract_1),CRates_1),SUMPRODUCT(--(E49>Contract_2),(E49-Contract_2),CRates_2),SUMPRODUCT(--(E49>Contract_3),(E49-Contract_3),CRates_3),SUMPRODUCT(--(E49>Contract_4),(E49-Contract_4),CRates_4))
F73	=CHOOSE(SUMPRODUCT(--(F$65>=$B$31:$B$34),--(F$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(F49>Contract_1),(F49-Contract_1),CRates_1),SUMPRODUCT(--(F49>Contract_2),(F49-Contract_2),CRates_2),SUMPRODUCT(--(F49>Contract_3),(F49-Contract_3),CRates_3),SUMPRODUCT(--(F49>Contract_4),(F49-Contract_4),CRates_4))
G73	=CHOOSE(SUMPRODUCT(--(G$65>=$B$31:$B$34),--(G$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(G49>Contract_1),(G49-Contract_1),CRates_1),SUMPRODUCT(--(G49>Contract_2),(G49-Contract_2),CRates_2),SUMPRODUCT(--(G49>Contract_3),(G49-Contract_3),CRates_3),SUMPRODUCT(--(G49>Contract_4),(G49-Contract_4),CRates_4))
H73	=CHOOSE(SUMPRODUCT(--(H$65>=$B$31:$B$34),--(H$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(H49>Contract_1),(H49-Contract_1),CRates_1),SUMPRODUCT(--(H49>Contract_2),(H49-Contract_2),CRates_2),SUMPRODUCT(--(H49>Contract_3),(H49-Contract_3),CRates_3),SUMPRODUCT(--(H49>Contract_4),(H49-Contract_4),CRates_4))
I73	=CHOOSE(SUMPRODUCT(--(I$65>=$B$31:$B$34),--(I$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(I49>Contract_1),(I49-Contract_1),CRates_1),SUMPRODUCT(--(I49>Contract_2),(I49-Contract_2),CRates_2),SUMPRODUCT(--(I49>Contract_3),(I49-Contract_3),CRates_3),SUMPRODUCT(--(I49>Contract_4),(I49-Contract_4),CRates_4))
J73	=CHOOSE(SUMPRODUCT(--(J$65>=$B$31:$B$34),--(J$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(J49>Contract_1),(J49-Contract_1),CRates_1),SUMPRODUCT(--(J49>Contract_2),(J49-Contract_2),CRates_2),SUMPRODUCT(--(J49>Contract_3),(J49-Contract_3),CRates_3),SUMPRODUCT(--(J49>Contract_4),(J49-Contract_4),CRates_4))
K73	=CHOOSE(SUMPRODUCT(--(K$65>=$B$31:$B$34),--(K$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(K49>Contract_1),(K49-Contract_1),CRates_1),SUMPRODUCT(--(K49>Contract_2),(K49-Contract_2),CRates_2),SUMPRODUCT(--(K49>Contract_3),(K49-Contract_3),CRates_3),SUMPRODUCT(--(K49>Contract_4),(K49-Contract_4),CRates_4))
L73	=CHOOSE(SUMPRODUCT(--(L$65>=$B$31:$B$34),--(L$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(L49>Contract_1),(L49-Contract_1),CRates_1),SUMPRODUCT(--(L49>Contract_2),(L49-Contract_2),CRates_2),SUMPRODUCT(--(L49>Contract_3),(L49-Contract_3),CRates_3),SUMPRODUCT(--(L49>Contract_4),(L49-Contract_4),CRates_4))
M73	=CHOOSE(SUMPRODUCT(--(M$65>=$B$31:$B$34),--(M$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(M49>Contract_1),(M49-Contract_1),CRates_1),SUMPRODUCT(--(M49>Contract_2),(M49-Contract_2),CRates_2),SUMPRODUCT(--(M49>Contract_3),(M49-Contract_3),CRates_3),SUMPRODUCT(--(M49>Contract_4),(M49-Contract_4),CRates_4))
N73	=CHOOSE(SUMPRODUCT(--(N$65>=$B$31:$B$34),--(N$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(N49>Contract_1),(N49-Contract_1),CRates_1),SUMPRODUCT(--(N49>Contract_2),(N49-Contract_2),CRates_2),SUMPRODUCT(--(N49>Contract_3),(N49-Contract_3),CRates_3),SUMPRODUCT(--(N49>Contract_4),(N49-Contract_4),CRates_4))
O73	=CHOOSE(SUMPRODUCT(--(O$65>=$B$31:$B$34),--(O$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(O49>Contract_1),(O49-Contract_1),CRates_1),SUMPRODUCT(--(O49>Contract_2),(O49-Contract_2),CRates_2),SUMPRODUCT(--(O49>Contract_3),(O49-Contract_3),CRates_3),SUMPRODUCT(--(O49>Contract_4),(O49-Contract_4),CRates_4))
C74	=CHOOSE(SUMPRODUCT(--(C$65>=$B$31:$B$34),--(C$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(C50>Contract_1),(C50-Contract_1),CRates_1),SUMPRODUCT(--(C50>Contract_2),(C50-Contract_2),CRates_2),SUMPRODUCT(--(C50>Contract_3),(C50-Contract_3),CRates_3),SUMPRODUCT(--(C50>Contract_4),(C50-Contract_4),CRates_4))
D74	=CHOOSE(SUMPRODUCT(--(D$65>=$B$31:$B$34),--(D$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(D50>Contract_1),(D50-Contract_1),CRates_1),SUMPRODUCT(--(D50>Contract_2),(D50-Contract_2),CRates_2),SUMPRODUCT(--(D50>Contract_3),(D50-Contract_3),CRates_3),SUMPRODUCT(--(D50>Contract_4),(D50-Contract_4),CRates_4))
E74	=CHOOSE(SUMPRODUCT(--(E$65>=$B$31:$B$34),--(E$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(E50>Contract_1),(E50-Contract_1),CRates_1),SUMPRODUCT(--(E50>Contract_2),(E50-Contract_2),CRates_2),SUMPRODUCT(--(E50>Contract_3),(E50-Contract_3),CRates_3),SUMPRODUCT(--(E50>Contract_4),(E50-Contract_4),CRates_4))
F74	=CHOOSE(SUMPRODUCT(--(F$65>=$B$31:$B$34),--(F$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(F50>Contract_1),(F50-Contract_1),CRates_1),SUMPRODUCT(--(F50>Contract_2),(F50-Contract_2),CRates_2),SUMPRODUCT(--(F50>Contract_3),(F50-Contract_3),CRates_3),SUMPRODUCT(--(F50>Contract_4),(F50-Contract_4),CRates_4))
G74	=CHOOSE(SUMPRODUCT(--(G$65>=$B$31:$B$34),--(G$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(G50>Contract_1),(G50-Contract_1),CRates_1),SUMPRODUCT(--(G50>Contract_2),(G50-Contract_2),CRates_2),SUMPRODUCT(--(G50>Contract_3),(G50-Contract_3),CRates_3),SUMPRODUCT(--(G50>Contract_4),(G50-Contract_4),CRates_4))
H74	=CHOOSE(SUMPRODUCT(--(H$65>=$B$31:$B$34),--(H$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(H50>Contract_1),(H50-Contract_1),CRates_1),SUMPRODUCT(--(H50>Contract_2),(H50-Contract_2),CRates_2),SUMPRODUCT(--(H50>Contract_3),(H50-Contract_3),CRates_3),SUMPRODUCT(--(H50>Contract_4),(H50-Contract_4),CRates_4))
I74	=CHOOSE(SUMPRODUCT(--(I$65>=$B$31:$B$34),--(I$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(I50>Contract_1),(I50-Contract_1),CRates_1),SUMPRODUCT(--(I50>Contract_2),(I50-Contract_2),CRates_2),SUMPRODUCT(--(I50>Contract_3),(I50-Contract_3),CRates_3),SUMPRODUCT(--(I50>Contract_4),(I50-Contract_4),CRates_4))
J74	=CHOOSE(SUMPRODUCT(--(J$65>=$B$31:$B$34),--(J$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(J50>Contract_1),(J50-Contract_1),CRates_1),SUMPRODUCT(--(J50>Contract_2),(J50-Contract_2),CRates_2),SUMPRODUCT(--(J50>Contract_3),(J50-Contract_3),CRates_3),SUMPRODUCT(--(J50>Contract_4),(J50-Contract_4),CRates_4))
K74	=CHOOSE(SUMPRODUCT(--(K$65>=$B$31:$B$34),--(K$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(K50>Contract_1),(K50-Contract_1),CRates_1),SUMPRODUCT(--(K50>Contract_2),(K50-Contract_2),CRates_2),SUMPRODUCT(--(K50>Contract_3),(K50-Contract_3),CRates_3),SUMPRODUCT(--(K50>Contract_4),(K50-Contract_4),CRates_4))
L74	=CHOOSE(SUMPRODUCT(--(L$65>=$B$31:$B$34),--(L$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(L50>Contract_1),(L50-Contract_1),CRates_1),SUMPRODUCT(--(L50>Contract_2),(L50-Contract_2),CRates_2),SUMPRODUCT(--(L50>Contract_3),(L50-Contract_3),CRates_3),SUMPRODUCT(--(L50>Contract_4),(L50-Contract_4),CRates_4))
M74	=CHOOSE(SUMPRODUCT(--(M$65>=$B$31:$B$34),--(M$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(M50>Contract_1),(M50-Contract_1),CRates_1),SUMPRODUCT(--(M50>Contract_2),(M50-Contract_2),CRates_2),SUMPRODUCT(--(M50>Contract_3),(M50-Contract_3),CRates_3),SUMPRODUCT(--(M50>Contract_4),(M50-Contract_4),CRates_4))
N74	=CHOOSE(SUMPRODUCT(--(N$65>=$B$31:$B$34),--(N$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(N50>Contract_1),(N50-Contract_1),CRates_1),SUMPRODUCT(--(N50>Contract_2),(N50-Contract_2),CRates_2),SUMPRODUCT(--(N50>Contract_3),(N50-Contract_3),CRates_3),SUMPRODUCT(--(N50>Contract_4),(N50-Contract_4),CRates_4))
O74	=CHOOSE(SUMPRODUCT(--(O$65>=$B$31:$B$34),--(O$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(O50>Contract_1),(O50-Contract_1),CRates_1),SUMPRODUCT(--(O50>Contract_2),(O50-Contract_2),CRates_2),SUMPRODUCT(--(O50>Contract_3),(O50-Contract_3),CRates_3),SUMPRODUCT(--(O50>Contract_4),(O50-Contract_4),CRates_4))
C75	=CHOOSE(SUMPRODUCT(--(C$65>=$B$31:$B$34),--(C$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(C51>Contract_1),(C51-Contract_1),CRates_1),SUMPRODUCT(--(C51>Contract_2),(C51-Contract_2),CRates_2),SUMPRODUCT(--(C51>Contract_3),(C51-Contract_3),CRates_3),SUMPRODUCT(--(C51>Contract_4),(C51-Contract_4),CRates_4))
D75	=CHOOSE(SUMPRODUCT(--(D$65>=$B$31:$B$34),--(D$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(D51>Contract_1),(D51-Contract_1),CRates_1),SUMPRODUCT(--(D51>Contract_2),(D51-Contract_2),CRates_2),SUMPRODUCT(--(D51>Contract_3),(D51-Contract_3),CRates_3),SUMPRODUCT(--(D51>Contract_4),(D51-Contract_4),CRates_4))
E75	=CHOOSE(SUMPRODUCT(--(E$65>=$B$31:$B$34),--(E$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(E51>Contract_1),(E51-Contract_1),CRates_1),SUMPRODUCT(--(E51>Contract_2),(E51-Contract_2),CRates_2),SUMPRODUCT(--(E51>Contract_3),(E51-Contract_3),CRates_3),SUMPRODUCT(--(E51>Contract_4),(E51-Contract_4),CRates_4))
F75	=CHOOSE(SUMPRODUCT(--(F$65>=$B$31:$B$34),--(F$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(F51>Contract_1),(F51-Contract_1),CRates_1),SUMPRODUCT(--(F51>Contract_2),(F51-Contract_2),CRates_2),SUMPRODUCT(--(F51>Contract_3),(F51-Contract_3),CRates_3),SUMPRODUCT(--(F51>Contract_4),(F51-Contract_4),CRates_4))
G75	=CHOOSE(SUMPRODUCT(--(G$65>=$B$31:$B$34),--(G$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(G51>Contract_1),(G51-Contract_1),CRates_1),SUMPRODUCT(--(G51>Contract_2),(G51-Contract_2),CRates_2),SUMPRODUCT(--(G51>Contract_3),(G51-Contract_3),CRates_3),SUMPRODUCT(--(G51>Contract_4),(G51-Contract_4),CRates_4))
H75	=CHOOSE(SUMPRODUCT(--(H$65>=$B$31:$B$34),--(H$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(H51>Contract_1),(H51-Contract_1),CRates_1),SUMPRODUCT(--(H51>Contract_2),(H51-Contract_2),CRates_2),SUMPRODUCT(--(H51>Contract_3),(H51-Contract_3),CRates_3),SUMPRODUCT(--(H51>Contract_4),(H51-Contract_4),CRates_4))
I75	=CHOOSE(SUMPRODUCT(--(I$65>=$B$31:$B$34),--(I$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(I51>Contract_1),(I51-Contract_1),CRates_1),SUMPRODUCT(--(I51>Contract_2),(I51-Contract_2),CRates_2),SUMPRODUCT(--(I51>Contract_3),(I51-Contract_3),CRates_3),SUMPRODUCT(--(I51>Contract_4),(I51-Contract_4),CRates_4))
J75	=CHOOSE(SUMPRODUCT(--(J$65>=$B$31:$B$34),--(J$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(J51>Contract_1),(J51-Contract_1),CRates_1),SUMPRODUCT(--(J51>Contract_2),(J51-Contract_2),CRates_2),SUMPRODUCT(--(J51>Contract_3),(J51-Contract_3),CRates_3),SUMPRODUCT(--(J51>Contract_4),(J51-Contract_4),CRates_4))
K75	=CHOOSE(SUMPRODUCT(--(K$65>=$B$31:$B$34),--(K$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(K51>Contract_1),(K51-Contract_1),CRates_1),SUMPRODUCT(--(K51>Contract_2),(K51-Contract_2),CRates_2),SUMPRODUCT(--(K51>Contract_3),(K51-Contract_3),CRates_3),SUMPRODUCT(--(K51>Contract_4),(K51-Contract_4),CRates_4))
L75	=CHOOSE(SUMPRODUCT(--(L$65>=$B$31:$B$34),--(L$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(L51>Contract_1),(L51-Contract_1),CRates_1),SUMPRODUCT(--(L51>Contract_2),(L51-Contract_2),CRates_2),SUMPRODUCT(--(L51>Contract_3),(L51-Contract_3),CRates_3),SUMPRODUCT(--(L51>Contract_4),(L51-Contract_4),CRates_4))
M75	=CHOOSE(SUMPRODUCT(--(M$65>=$B$31:$B$34),--(M$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(M51>Contract_1),(M51-Contract_1),CRates_1),SUMPRODUCT(--(M51>Contract_2),(M51-Contract_2),CRates_2),SUMPRODUCT(--(M51>Contract_3),(M51-Contract_3),CRates_3),SUMPRODUCT(--(M51>Contract_4),(M51-Contract_4),CRates_4))
N75	=CHOOSE(SUMPRODUCT(--(N$65>=$B$31:$B$34),--(N$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(N51>Contract_1),(N51-Contract_1),CRates_1),SUMPRODUCT(--(N51>Contract_2),(N51-Contract_2),CRates_2),SUMPRODUCT(--(N51>Contract_3),(N51-Contract_3),CRates_3),SUMPRODUCT(--(N51>Contract_4),(N51-Contract_4),CRates_4))
O75	=CHOOSE(SUMPRODUCT(--(O$65>=$B$31:$B$34),--(O$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(O51>Contract_1),(O51-Contract_1),CRates_1),SUMPRODUCT(--(O51>Contract_2),(O51-Contract_2),CRates_2),SUMPRODUCT(--(O51>Contract_3),(O51-Contract_3),CRates_3),SUMPRODUCT(--(O51>Contract_4),(O51-Contract_4),CRates_4))
C76	=CHOOSE(SUMPRODUCT(--(C$65>=$B$31:$B$34),--(C$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(C52>Contract_1),(C52-Contract_1),CRates_1),SUMPRODUCT(--(C52>Contract_2),(C52-Contract_2),CRates_2),SUMPRODUCT(--(C52>Contract_3),(C52-Contract_3),CRates_3),SUMPRODUCT(--(C52>Contract_4),(C52-Contract_4),CRates_4))
D76	=CHOOSE(SUMPRODUCT(--(D$65>=$B$31:$B$34),--(D$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(D52>Contract_1),(D52-Contract_1),CRates_1),SUMPRODUCT(--(D52>Contract_2),(D52-Contract_2),CRates_2),SUMPRODUCT(--(D52>Contract_3),(D52-Contract_3),CRates_3),SUMPRODUCT(--(D52>Contract_4),(D52-Contract_4),CRates_4))
E76	=CHOOSE(SUMPRODUCT(--(E$65>=$B$31:$B$34),--(E$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(E52>Contract_1),(E52-Contract_1),CRates_1),SUMPRODUCT(--(E52>Contract_2),(E52-Contract_2),CRates_2),SUMPRODUCT(--(E52>Contract_3),(E52-Contract_3),CRates_3),SUMPRODUCT(--(E52>Contract_4),(E52-Contract_4),CRates_4))
F76	=CHOOSE(SUMPRODUCT(--(F$65>=$B$31:$B$34),--(F$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(F52>Contract_1),(F52-Contract_1),CRates_1),SUMPRODUCT(--(F52>Contract_2),(F52-Contract_2),CRates_2),SUMPRODUCT(--(F52>Contract_3),(F52-Contract_3),CRates_3),SUMPRODUCT(--(F52>Contract_4),(F52-Contract_4),CRates_4))
G76	=CHOOSE(SUMPRODUCT(--(G$65>=$B$31:$B$34),--(G$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(G52>Contract_1),(G52-Contract_1),CRates_1),SUMPRODUCT(--(G52>Contract_2),(G52-Contract_2),CRates_2),SUMPRODUCT(--(G52>Contract_3),(G52-Contract_3),CRates_3),SUMPRODUCT(--(G52>Contract_4),(G52-Contract_4),CRates_4))
H76	=CHOOSE(SUMPRODUCT(--(H$65>=$B$31:$B$34),--(H$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(H52>Contract_1),(H52-Contract_1),CRates_1),SUMPRODUCT(--(H52>Contract_2),(H52-Contract_2),CRates_2),SUMPRODUCT(--(H52>Contract_3),(H52-Contract_3),CRates_3),SUMPRODUCT(--(H52>Contract_4),(H52-Contract_4),CRates_4))
I76	=CHOOSE(SUMPRODUCT(--(I$65>=$B$31:$B$34),--(I$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(I52>Contract_1),(I52-Contract_1),CRates_1),SUMPRODUCT(--(I52>Contract_2),(I52-Contract_2),CRates_2),SUMPRODUCT(--(I52>Contract_3),(I52-Contract_3),CRates_3),SUMPRODUCT(--(I52>Contract_4),(I52-Contract_4),CRates_4))
J76	=CHOOSE(SUMPRODUCT(--(J$65>=$B$31:$B$34),--(J$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(J52>Contract_1),(J52-Contract_1),CRates_1),SUMPRODUCT(--(J52>Contract_2),(J52-Contract_2),CRates_2),SUMPRODUCT(--(J52>Contract_3),(J52-Contract_3),CRates_3),SUMPRODUCT(--(J52>Contract_4),(J52-Contract_4),CRates_4))
K76	=CHOOSE(SUMPRODUCT(--(K$65>=$B$31:$B$34),--(K$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(K52>Contract_1),(K52-Contract_1),CRates_1),SUMPRODUCT(--(K52>Contract_2),(K52-Contract_2),CRates_2),SUMPRODUCT(--(K52>Contract_3),(K52-Contract_3),CRates_3),SUMPRODUCT(--(K52>Contract_4),(K52-Contract_4),CRates_4))
L76	=CHOOSE(SUMPRODUCT(--(L$65>=$B$31:$B$34),--(L$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(L52>Contract_1),(L52-Contract_1),CRates_1),SUMPRODUCT(--(L52>Contract_2),(L52-Contract_2),CRates_2),SUMPRODUCT(--(L52>Contract_3),(L52-Contract_3),CRates_3),SUMPRODUCT(--(L52>Contract_4),(L52-Contract_4),CRates_4))
M76	=CHOOSE(SUMPRODUCT(--(M$65>=$B$31:$B$34),--(M$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(M52>Contract_1),(M52-Contract_1),CRates_1),SUMPRODUCT(--(M52>Contract_2),(M52-Contract_2),CRates_2),SUMPRODUCT(--(M52>Contract_3),(M52-Contract_3),CRates_3),SUMPRODUCT(--(M52>Contract_4),(M52-Contract_4),CRates_4))
N76	=CHOOSE(SUMPRODUCT(--(N$65>=$B$31:$B$34),--(N$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(N52>Contract_1),(N52-Contract_1),CRates_1),SUMPRODUCT(--(N52>Contract_2),(N52-Contract_2),CRates_2),SUMPRODUCT(--(N52>Contract_3),(N52-Contract_3),CRates_3),SUMPRODUCT(--(N52>Contract_4),(N52-Contract_4),CRates_4))
O76	=CHOOSE(SUMPRODUCT(--(O$65>=$B$31:$B$34),--(O$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(O52>Contract_1),(O52-Contract_1),CRates_1),SUMPRODUCT(--(O52>Contract_2),(O52-Contract_2),CRates_2),SUMPRODUCT(--(O52>Contract_3),(O52-Contract_3),CRates_3),SUMPRODUCT(--(O52>Contract_4),(O52-Contract_4),CRates_4))
C77	=CHOOSE(SUMPRODUCT(--(C$65>=$B$31:$B$34),--(C$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(C53>Contract_1),(C53-Contract_1),CRates_1),SUMPRODUCT(--(C53>Contract_2),(C53-Contract_2),CRates_2),SUMPRODUCT(--(C53>Contract_3),(C53-Contract_3),CRates_3),SUMPRODUCT(--(C53>Contract_4),(C53-Contract_4),CRates_4))
D77	=CHOOSE(SUMPRODUCT(--(D$65>=$B$31:$B$34),--(D$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(D53>Contract_1),(D53-Contract_1),CRates_1),SUMPRODUCT(--(D53>Contract_2),(D53-Contract_2),CRates_2),SUMPRODUCT(--(D53>Contract_3),(D53-Contract_3),CRates_3),SUMPRODUCT(--(D53>Contract_4),(D53-Contract_4),CRates_4))
E77	=CHOOSE(SUMPRODUCT(--(E$65>=$B$31:$B$34),--(E$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(E53>Contract_1),(E53-Contract_1),CRates_1),SUMPRODUCT(--(E53>Contract_2),(E53-Contract_2),CRates_2),SUMPRODUCT(--(E53>Contract_3),(E53-Contract_3),CRates_3),SUMPRODUCT(--(E53>Contract_4),(E53-Contract_4),CRates_4))
F77	=CHOOSE(SUMPRODUCT(--(F$65>=$B$31:$B$34),--(F$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(F53>Contract_1),(F53-Contract_1),CRates_1),SUMPRODUCT(--(F53>Contract_2),(F53-Contract_2),CRates_2),SUMPRODUCT(--(F53>Contract_3),(F53-Contract_3),CRates_3),SUMPRODUCT(--(F53>Contract_4),(F53-Contract_4),CRates_4))
G77	=CHOOSE(SUMPRODUCT(--(G$65>=$B$31:$B$34),--(G$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(G53>Contract_1),(G53-Contract_1),CRates_1),SUMPRODUCT(--(G53>Contract_2),(G53-Contract_2),CRates_2),SUMPRODUCT(--(G53>Contract_3),(G53-Contract_3),CRates_3),SUMPRODUCT(--(G53>Contract_4),(G53-Contract_4),CRates_4))
H77	=CHOOSE(SUMPRODUCT(--(H$65>=$B$31:$B$34),--(H$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(H53>Contract_1),(H53-Contract_1),CRates_1),SUMPRODUCT(--(H53>Contract_2),(H53-Contract_2),CRates_2),SUMPRODUCT(--(H53>Contract_3),(H53-Contract_3),CRates_3),SUMPRODUCT(--(H53>Contract_4),(H53-Contract_4),CRates_4))
I77	=CHOOSE(SUMPRODUCT(--(I$65>=$B$31:$B$34),--(I$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(I53>Contract_1),(I53-Contract_1),CRates_1),SUMPRODUCT(--(I53>Contract_2),(I53-Contract_2),CRates_2),SUMPRODUCT(--(I53>Contract_3),(I53-Contract_3),CRates_3),SUMPRODUCT(--(I53>Contract_4),(I53-Contract_4),CRates_4))
J77	=CHOOSE(SUMPRODUCT(--(J$65>=$B$31:$B$34),--(J$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(J53>Contract_1),(J53-Contract_1),CRates_1),SUMPRODUCT(--(J53>Contract_2),(J53-Contract_2),CRates_2),SUMPRODUCT(--(J53>Contract_3),(J53-Contract_3),CRates_3),SUMPRODUCT(--(J53>Contract_4),(J53-Contract_4),CRates_4))
K77	=CHOOSE(SUMPRODUCT(--(K$65>=$B$31:$B$34),--(K$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(K53>Contract_1),(K53-Contract_1),CRates_1),SUMPRODUCT(--(K53>Contract_2),(K53-Contract_2),CRates_2),SUMPRODUCT(--(K53>Contract_3),(K53-Contract_3),CRates_3),SUMPRODUCT(--(K53>Contract_4),(K53-Contract_4),CRates_4))
L77	=CHOOSE(SUMPRODUCT(--(L$65>=$B$31:$B$34),--(L$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(L53>Contract_1),(L53-Contract_1),CRates_1),SUMPRODUCT(--(L53>Contract_2),(L53-Contract_2),CRates_2),SUMPRODUCT(--(L53>Contract_3),(L53-Contract_3),CRates_3),SUMPRODUCT(--(L53>Contract_4),(L53-Contract_4),CRates_4))
M77	=CHOOSE(SUMPRODUCT(--(M$65>=$B$31:$B$34),--(M$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(M53>Contract_1),(M53-Contract_1),CRates_1),SUMPRODUCT(--(M53>Contract_2),(M53-Contract_2),CRates_2),SUMPRODUCT(--(M53>Contract_3),(M53-Contract_3),CRates_3),SUMPRODUCT(--(M53>Contract_4),(M53-Contract_4),CRates_4))
N77	=CHOOSE(SUMPRODUCT(--(N$65>=$B$31:$B$34),--(N$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(N53>Contract_1),(N53-Contract_1),CRates_1),SUMPRODUCT(--(N53>Contract_2),(N53-Contract_2),CRates_2),SUMPRODUCT(--(N53>Contract_3),(N53-Contract_3),CRates_3),SUMPRODUCT(--(N53>Contract_4),(N53-Contract_4),CRates_4))
O77	=CHOOSE(SUMPRODUCT(--(O$65>=$B$31:$B$34),--(O$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(O53>Contract_1),(O53-Contract_1),CRates_1),SUMPRODUCT(--(O53>Contract_2),(O53-Contract_2),CRates_2),SUMPRODUCT(--(O53>Contract_3),(O53-Contract_3),CRates_3),SUMPRODUCT(--(O53>Contract_4),(O53-Contract_4),CRates_4))
C78	=CHOOSE(SUMPRODUCT(--(C$65>=$B$31:$B$34),--(C$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(C54>Contract_1),(C54-Contract_1),CRates_1),SUMPRODUCT(--(C54>Contract_2),(C54-Contract_2),CRates_2),SUMPRODUCT(--(C54>Contract_3),(C54-Contract_3),CRates_3),SUMPRODUCT(--(C54>Contract_4),(C54-Contract_4),CRates_4))
D78	=CHOOSE(SUMPRODUCT(--(D$65>=$B$31:$B$34),--(D$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(D54>Contract_1),(D54-Contract_1),CRates_1),SUMPRODUCT(--(D54>Contract_2),(D54-Contract_2),CRates_2),SUMPRODUCT(--(D54>Contract_3),(D54-Contract_3),CRates_3),SUMPRODUCT(--(D54>Contract_4),(D54-Contract_4),CRates_4))
E78	=CHOOSE(SUMPRODUCT(--(E$65>=$B$31:$B$34),--(E$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(E54>Contract_1),(E54-Contract_1),CRates_1),SUMPRODUCT(--(E54>Contract_2),(E54-Contract_2),CRates_2),SUMPRODUCT(--(E54>Contract_3),(E54-Contract_3),CRates_3),SUMPRODUCT(--(E54>Contract_4),(E54-Contract_4),CRates_4))
F78	=CHOOSE(SUMPRODUCT(--(F$65>=$B$31:$B$34),--(F$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(F54>Contract_1),(F54-Contract_1),CRates_1),SUMPRODUCT(--(F54>Contract_2),(F54-Contract_2),CRates_2),SUMPRODUCT(--(F54>Contract_3),(F54-Contract_3),CRates_3),SUMPRODUCT(--(F54>Contract_4),(F54-Contract_4),CRates_4))
G78	=CHOOSE(SUMPRODUCT(--(G$65>=$B$31:$B$34),--(G$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(G54>Contract_1),(G54-Contract_1),CRates_1),SUMPRODUCT(--(G54>Contract_2),(G54-Contract_2),CRates_2),SUMPRODUCT(--(G54>Contract_3),(G54-Contract_3),CRates_3),SUMPRODUCT(--(G54>Contract_4),(G54-Contract_4),CRates_4))
H78	=CHOOSE(SUMPRODUCT(--(H$65>=$B$31:$B$34),--(H$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(H54>Contract_1),(H54-Contract_1),CRates_1),SUMPRODUCT(--(H54>Contract_2),(H54-Contract_2),CRates_2),SUMPRODUCT(--(H54>Contract_3),(H54-Contract_3),CRates_3),SUMPRODUCT(--(H54>Contract_4),(H54-Contract_4),CRates_4))
I78	=CHOOSE(SUMPRODUCT(--(I$65>=$B$31:$B$34),--(I$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(I54>Contract_1),(I54-Contract_1),CRates_1),SUMPRODUCT(--(I54>Contract_2),(I54-Contract_2),CRates_2),SUMPRODUCT(--(I54>Contract_3),(I54-Contract_3),CRates_3),SUMPRODUCT(--(I54>Contract_4),(I54-Contract_4),CRates_4))
J78	=CHOOSE(SUMPRODUCT(--(J$65>=$B$31:$B$34),--(J$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(J54>Contract_1),(J54-Contract_1),CRates_1),SUMPRODUCT(--(J54>Contract_2),(J54-Contract_2),CRates_2),SUMPRODUCT(--(J54>Contract_3),(J54-Contract_3),CRates_3),SUMPRODUCT(--(J54>Contract_4),(J54-Contract_4),CRates_4))
K78	=CHOOSE(SUMPRODUCT(--(K$65>=$B$31:$B$34),--(K$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(K54>Contract_1),(K54-Contract_1),CRates_1),SUMPRODUCT(--(K54>Contract_2),(K54-Contract_2),CRates_2),SUMPRODUCT(--(K54>Contract_3),(K54-Contract_3),CRates_3),SUMPRODUCT(--(K54>Contract_4),(K54-Contract_4),CRates_4))
L78	=CHOOSE(SUMPRODUCT(--(L$65>=$B$31:$B$34),--(L$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(L54>Contract_1),(L54-Contract_1),CRates_1),SUMPRODUCT(--(L54>Contract_2),(L54-Contract_2),CRates_2),SUMPRODUCT(--(L54>Contract_3),(L54-Contract_3),CRates_3),SUMPRODUCT(--(L54>Contract_4),(L54-Contract_4),CRates_4))
M78	=CHOOSE(SUMPRODUCT(--(M$65>=$B$31:$B$34),--(M$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(M54>Contract_1),(M54-Contract_1),CRates_1),SUMPRODUCT(--(M54>Contract_2),(M54-Contract_2),CRates_2),SUMPRODUCT(--(M54>Contract_3),(M54-Contract_3),CRates_3),SUMPRODUCT(--(M54>Contract_4),(M54-Contract_4),CRates_4))
N78	=CHOOSE(SUMPRODUCT(--(N$65>=$B$31:$B$34),--(N$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(N54>Contract_1),(N54-Contract_1),CRates_1),SUMPRODUCT(--(N54>Contract_2),(N54-Contract_2),CRates_2),SUMPRODUCT(--(N54>Contract_3),(N54-Contract_3),CRates_3),SUMPRODUCT(--(N54>Contract_4),(N54-Contract_4),CRates_4))
O78	=CHOOSE(SUMPRODUCT(--(O$65>=$B$31:$B$34),--(O$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(O54>Contract_1),(O54-Contract_1),CRates_1),SUMPRODUCT(--(O54>Contract_2),(O54-Contract_2),CRates_2),SUMPRODUCT(--(O54>Contract_3),(O54-Contract_3),CRates_3),SUMPRODUCT(--(O54>Contract_4),(O54-Contract_4),CRates_4))
C79	=CHOOSE(SUMPRODUCT(--(C$65>=$B$31:$B$34),--(C$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(C55>Contract_1),(C55-Contract_1),CRates_1),SUMPRODUCT(--(C55>Contract_2),(C55-Contract_2),CRates_2),SUMPRODUCT(--(C55>Contract_3),(C55-Contract_3),CRates_3),SUMPRODUCT(--(C55>Contract_4),(C55-Contract_4),CRates_4))
D79	=CHOOSE(SUMPRODUCT(--(D$65>=$B$31:$B$34),--(D$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(D55>Contract_1),(D55-Contract_1),CRates_1),SUMPRODUCT(--(D55>Contract_2),(D55-Contract_2),CRates_2),SUMPRODUCT(--(D55>Contract_3),(D55-Contract_3),CRates_3),SUMPRODUCT(--(D55>Contract_4),(D55-Contract_4),CRates_4))
E79	=CHOOSE(SUMPRODUCT(--(E$65>=$B$31:$B$34),--(E$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(E55>Contract_1),(E55-Contract_1),CRates_1),SUMPRODUCT(--(E55>Contract_2),(E55-Contract_2),CRates_2),SUMPRODUCT(--(E55>Contract_3),(E55-Contract_3),CRates_3),SUMPRODUCT(--(E55>Contract_4),(E55-Contract_4),CRates_4))
F79	=CHOOSE(SUMPRODUCT(--(F$65>=$B$31:$B$34),--(F$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(F55>Contract_1),(F55-Contract_1),CRates_1),SUMPRODUCT(--(F55>Contract_2),(F55-Contract_2),CRates_2),SUMPRODUCT(--(F55>Contract_3),(F55-Contract_3),CRates_3),SUMPRODUCT(--(F55>Contract_4),(F55-Contract_4),CRates_4))
G79	=CHOOSE(SUMPRODUCT(--(G$65>=$B$31:$B$34),--(G$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(G55>Contract_1),(G55-Contract_1),CRates_1),SUMPRODUCT(--(G55>Contract_2),(G55-Contract_2),CRates_2),SUMPRODUCT(--(G55>Contract_3),(G55-Contract_3),CRates_3),SUMPRODUCT(--(G55>Contract_4),(G55-Contract_4),CRates_4))
H79	=CHOOSE(SUMPRODUCT(--(H$65>=$B$31:$B$34),--(H$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(H55>Contract_1),(H55-Contract_1),CRates_1),SUMPRODUCT(--(H55>Contract_2),(H55-Contract_2),CRates_2),SUMPRODUCT(--(H55>Contract_3),(H55-Contract_3),CRates_3),SUMPRODUCT(--(H55>Contract_4),(H55-Contract_4),CRates_4))
I79	=CHOOSE(SUMPRODUCT(--(I$65>=$B$31:$B$34),--(I$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(I55>Contract_1),(I55-Contract_1),CRates_1),SUMPRODUCT(--(I55>Contract_2),(I55-Contract_2),CRates_2),SUMPRODUCT(--(I55>Contract_3),(I55-Contract_3),CRates_3),SUMPRODUCT(--(I55>Contract_4),(I55-Contract_4),CRates_4))
J79	=CHOOSE(SUMPRODUCT(--(J$65>=$B$31:$B$34),--(J$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(J55>Contract_1),(J55-Contract_1),CRates_1),SUMPRODUCT(--(J55>Contract_2),(J55-Contract_2),CRates_2),SUMPRODUCT(--(J55>Contract_3),(J55-Contract_3),CRates_3),SUMPRODUCT(--(J55>Contract_4),(J55-Contract_4),CRates_4))
K79	=CHOOSE(SUMPRODUCT(--(K$65>=$B$31:$B$34),--(K$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(K55>Contract_1),(K55-Contract_1),CRates_1),SUMPRODUCT(--(K55>Contract_2),(K55-Contract_2),CRates_2),SUMPRODUCT(--(K55>Contract_3),(K55-Contract_3),CRates_3),SUMPRODUCT(--(K55>Contract_4),(K55-Contract_4),CRates_4))
L79	=CHOOSE(SUMPRODUCT(--(L$65>=$B$31:$B$34),--(L$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(L55>Contract_1),(L55-Contract_1),CRates_1),SUMPRODUCT(--(L55>Contract_2),(L55-Contract_2),CRates_2),SUMPRODUCT(--(L55>Contract_3),(L55-Contract_3),CRates_3),SUMPRODUCT(--(L55>Contract_4),(L55-Contract_4),CRates_4))
M79	=CHOOSE(SUMPRODUCT(--(M$65>=$B$31:$B$34),--(M$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(M55>Contract_1),(M55-Contract_1),CRates_1),SUMPRODUCT(--(M55>Contract_2),(M55-Contract_2),CRates_2),SUMPRODUCT(--(M55>Contract_3),(M55-Contract_3),CRates_3),SUMPRODUCT(--(M55>Contract_4),(M55-Contract_4),CRates_4))
N79	=CHOOSE(SUMPRODUCT(--(N$65>=$B$31:$B$34),--(N$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(N55>Contract_1),(N55-Contract_1),CRates_1),SUMPRODUCT(--(N55>Contract_2),(N55-Contract_2),CRates_2),SUMPRODUCT(--(N55>Contract_3),(N55-Contract_3),CRates_3),SUMPRODUCT(--(N55>Contract_4),(N55-Contract_4),CRates_4))
O79	=CHOOSE(SUMPRODUCT(--(O$65>=$B$31:$B$34),--(O$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(O55>Contract_1),(O55-Contract_1),CRates_1),SUMPRODUCT(--(O55>Contract_2),(O55-Contract_2),CRates_2),SUMPRODUCT(--(O55>Contract_3),(O55-Contract_3),CRates_3),SUMPRODUCT(--(O55>Contract_4),(O55-Contract_4),CRates_4))
C80	=CHOOSE(SUMPRODUCT(--(C$65>=$B$31:$B$34),--(C$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(C56>Contract_1),(C56-Contract_1),CRates_1),SUMPRODUCT(--(C56>Contract_2),(C56-Contract_2),CRates_2),SUMPRODUCT(--(C56>Contract_3),(C56-Contract_3),CRates_3),SUMPRODUCT(--(C56>Contract_4),(C56-Contract_4),CRates_4))
D80	=CHOOSE(SUMPRODUCT(--(D$65>=$B$31:$B$34),--(D$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(D56>Contract_1),(D56-Contract_1),CRates_1),SUMPRODUCT(--(D56>Contract_2),(D56-Contract_2),CRates_2),SUMPRODUCT(--(D56>Contract_3),(D56-Contract_3),CRates_3),SUMPRODUCT(--(D56>Contract_4),(D56-Contract_4),CRates_4))
E80	=CHOOSE(SUMPRODUCT(--(E$65>=$B$31:$B$34),--(E$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(E56>Contract_1),(E56-Contract_1),CRates_1),SUMPRODUCT(--(E56>Contract_2),(E56-Contract_2),CRates_2),SUMPRODUCT(--(E56>Contract_3),(E56-Contract_3),CRates_3),SUMPRODUCT(--(E56>Contract_4),(E56-Contract_4),CRates_4))
F80	=CHOOSE(SUMPRODUCT(--(F$65>=$B$31:$B$34),--(F$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(F56>Contract_1),(F56-Contract_1),CRates_1),SUMPRODUCT(--(F56>Contract_2),(F56-Contract_2),CRates_2),SUMPRODUCT(--(F56>Contract_3),(F56-Contract_3),CRates_3),SUMPRODUCT(--(F56>Contract_4),(F56-Contract_4),CRates_4))
G80	=CHOOSE(SUMPRODUCT(--(G$65>=$B$31:$B$34),--(G$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(G56>Contract_1),(G56-Contract_1),CRates_1),SUMPRODUCT(--(G56>Contract_2),(G56-Contract_2),CRates_2),SUMPRODUCT(--(G56>Contract_3),(G56-Contract_3),CRates_3),SUMPRODUCT(--(G56>Contract_4),(G56-Contract_4),CRates_4))
H80	=CHOOSE(SUMPRODUCT(--(H$65>=$B$31:$B$34),--(H$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(H56>Contract_1),(H56-Contract_1),CRates_1),SUMPRODUCT(--(H56>Contract_2),(H56-Contract_2),CRates_2),SUMPRODUCT(--(H56>Contract_3),(H56-Contract_3),CRates_3),SUMPRODUCT(--(H56>Contract_4),(H56-Contract_4),CRates_4))
I80	=CHOOSE(SUMPRODUCT(--(I$65>=$B$31:$B$34),--(I$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(I56>Contract_1),(I56-Contract_1),CRates_1),SUMPRODUCT(--(I56>Contract_2),(I56-Contract_2),CRates_2),SUMPRODUCT(--(I56>Contract_3),(I56-Contract_3),CRates_3),SUMPRODUCT(--(I56>Contract_4),(I56-Contract_4),CRates_4))
J80	=CHOOSE(SUMPRODUCT(--(J$65>=$B$31:$B$34),--(J$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(J56>Contract_1),(J56-Contract_1),CRates_1),SUMPRODUCT(--(J56>Contract_2),(J56-Contract_2),CRates_2),SUMPRODUCT(--(J56>Contract_3),(J56-Contract_3),CRates_3),SUMPRODUCT(--(J56>Contract_4),(J56-Contract_4),CRates_4))
K80	=CHOOSE(SUMPRODUCT(--(K$65>=$B$31:$B$34),--(K$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(K56>Contract_1),(K56-Contract_1),CRates_1),SUMPRODUCT(--(K56>Contract_2),(K56-Contract_2),CRates_2),SUMPRODUCT(--(K56>Contract_3),(K56-Contract_3),CRates_3),SUMPRODUCT(--(K56>Contract_4),(K56-Contract_4),CRates_4))
L80	=CHOOSE(SUMPRODUCT(--(L$65>=$B$31:$B$34),--(L$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(L56>Contract_1),(L56-Contract_1),CRates_1),SUMPRODUCT(--(L56>Contract_2),(L56-Contract_2),CRates_2),SUMPRODUCT(--(L56>Contract_3),(L56-Contract_3),CRates_3),SUMPRODUCT(--(L56>Contract_4),(L56-Contract_4),CRates_4))
M80	=CHOOSE(SUMPRODUCT(--(M$65>=$B$31:$B$34),--(M$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(M56>Contract_1),(M56-Contract_1),CRates_1),SUMPRODUCT(--(M56>Contract_2),(M56-Contract_2),CRates_2),SUMPRODUCT(--(M56>Contract_3),(M56-Contract_3),CRates_3),SUMPRODUCT(--(M56>Contract_4),(M56-Contract_4),CRates_4))
N80	=CHOOSE(SUMPRODUCT(--(N$65>=$B$31:$B$34),--(N$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(N56>Contract_1),(N56-Contract_1),CRates_1),SUMPRODUCT(--(N56>Contract_2),(N56-Contract_2),CRates_2),SUMPRODUCT(--(N56>Contract_3),(N56-Contract_3),CRates_3),SUMPRODUCT(--(N56>Contract_4),(N56-Contract_4),CRates_4))
O80	=CHOOSE(SUMPRODUCT(--(O$65>=$B$31:$B$34),--(O$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(O56>Contract_1),(O56-Contract_1),CRates_1),SUMPRODUCT(--(O56>Contract_2),(O56-Contract_2),CRates_2),SUMPRODUCT(--(O56>Contract_3),(O56-Contract_3),CRates_3),SUMPRODUCT(--(O56>Contract_4),(O56-Contract_4),CRates_4))
C81	=CHOOSE(SUMPRODUCT(--(C$65>=$B$31:$B$34),--(C$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(C57>Contract_1),(C57-Contract_1),CRates_1),SUMPRODUCT(--(C57>Contract_2),(C57-Contract_2),CRates_2),SUMPRODUCT(--(C57>Contract_3),(C57-Contract_3),CRates_3),SUMPRODUCT(--(C57>Contract_4),(C57-Contract_4),CRates_4))
D81	=CHOOSE(SUMPRODUCT(--(D$65>=$B$31:$B$34),--(D$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(D57>Contract_1),(D57-Contract_1),CRates_1),SUMPRODUCT(--(D57>Contract_2),(D57-Contract_2),CRates_2),SUMPRODUCT(--(D57>Contract_3),(D57-Contract_3),CRates_3),SUMPRODUCT(--(D57>Contract_4),(D57-Contract_4),CRates_4))
E81	=CHOOSE(SUMPRODUCT(--(E$65>=$B$31:$B$34),--(E$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(E57>Contract_1),(E57-Contract_1),CRates_1),SUMPRODUCT(--(E57>Contract_2),(E57-Contract_2),CRates_2),SUMPRODUCT(--(E57>Contract_3),(E57-Contract_3),CRates_3),SUMPRODUCT(--(E57>Contract_4),(E57-Contract_4),CRates_4))
F81	=CHOOSE(SUMPRODUCT(--(F$65>=$B$31:$B$34),--(F$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(F57>Contract_1),(F57-Contract_1),CRates_1),SUMPRODUCT(--(F57>Contract_2),(F57-Contract_2),CRates_2),SUMPRODUCT(--(F57>Contract_3),(F57-Contract_3),CRates_3),SUMPRODUCT(--(F57>Contract_4),(F57-Contract_4),CRates_4))
G81	=CHOOSE(SUMPRODUCT(--(G$65>=$B$31:$B$34),--(G$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(G57>Contract_1),(G57-Contract_1),CRates_1),SUMPRODUCT(--(G57>Contract_2),(G57-Contract_2),CRates_2),SUMPRODUCT(--(G57>Contract_3),(G57-Contract_3),CRates_3),SUMPRODUCT(--(G57>Contract_4),(G57-Contract_4),CRates_4))
H81	=CHOOSE(SUMPRODUCT(--(H$65>=$B$31:$B$34),--(H$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(H57>Contract_1),(H57-Contract_1),CRates_1),SUMPRODUCT(--(H57>Contract_2),(H57-Contract_2),CRates_2),SUMPRODUCT(--(H57>Contract_3),(H57-Contract_3),CRates_3),SUMPRODUCT(--(H57>Contract_4),(H57-Contract_4),CRates_4))
I81	=CHOOSE(SUMPRODUCT(--(I$65>=$B$31:$B$34),--(I$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(I57>Contract_1),(I57-Contract_1),CRates_1),SUMPRODUCT(--(I57>Contract_2),(I57-Contract_2),CRates_2),SUMPRODUCT(--(I57>Contract_3),(I57-Contract_3),CRates_3),SUMPRODUCT(--(I57>Contract_4),(I57-Contract_4),CRates_4))
J81	=CHOOSE(SUMPRODUCT(--(J$65>=$B$31:$B$34),--(J$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(J57>Contract_1),(J57-Contract_1),CRates_1),SUMPRODUCT(--(J57>Contract_2),(J57-Contract_2),CRates_2),SUMPRODUCT(--(J57>Contract_3),(J57-Contract_3),CRates_3),SUMPRODUCT(--(J57>Contract_4),(J57-Contract_4),CRates_4))
K81	=CHOOSE(SUMPRODUCT(--(K$65>=$B$31:$B$34),--(K$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(K57>Contract_1),(K57-Contract_1),CRates_1),SUMPRODUCT(--(K57>Contract_2),(K57-Contract_2),CRates_2),SUMPRODUCT(--(K57>Contract_3),(K57-Contract_3),CRates_3),SUMPRODUCT(--(K57>Contract_4),(K57-Contract_4),CRates_4))
L81	=CHOOSE(SUMPRODUCT(--(L$65>=$B$31:$B$34),--(L$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(L57>Contract_1),(L57-Contract_1),CRates_1),SUMPRODUCT(--(L57>Contract_2),(L57-Contract_2),CRates_2),SUMPRODUCT(--(L57>Contract_3),(L57-Contract_3),CRates_3),SUMPRODUCT(--(L57>Contract_4),(L57-Contract_4),CRates_4))
M81	=CHOOSE(SUMPRODUCT(--(M$65>=$B$31:$B$34),--(M$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(M57>Contract_1),(M57-Contract_1),CRates_1),SUMPRODUCT(--(M57>Contract_2),(M57-Contract_2),CRates_2),SUMPRODUCT(--(M57>Contract_3),(M57-Contract_3),CRates_3),SUMPRODUCT(--(M57>Contract_4),(M57-Contract_4),CRates_4))
N81	=CHOOSE(SUMPRODUCT(--(N$65>=$B$31:$B$34),--(N$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(N57>Contract_1),(N57-Contract_1),CRates_1),SUMPRODUCT(--(N57>Contract_2),(N57-Contract_2),CRates_2),SUMPRODUCT(--(N57>Contract_3),(N57-Contract_3),CRates_3),SUMPRODUCT(--(N57>Contract_4),(N57-Contract_4),CRates_4))
O81	=CHOOSE(SUMPRODUCT(--(O$65>=$B$31:$B$34),--(O$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(O57>Contract_1),(O57-Contract_1),CRates_1),SUMPRODUCT(--(O57>Contract_2),(O57-Contract_2),CRates_2),SUMPRODUCT(--(O57>Contract_3),(O57-Contract_3),CRates_3),SUMPRODUCT(--(O57>Contract_4),(O57-Contract_4),CRates_4))
C82	=CHOOSE(SUMPRODUCT(--(C$65>=$B$31:$B$34),--(C$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(C58>Contract_1),(C58-Contract_1),CRates_1),SUMPRODUCT(--(C58>Contract_2),(C58-Contract_2),CRates_2),SUMPRODUCT(--(C58>Contract_3),(C58-Contract_3),CRates_3),SUMPRODUCT(--(C58>Contract_4),(C58-Contract_4),CRates_4))
D82	=CHOOSE(SUMPRODUCT(--(D$65>=$B$31:$B$34),--(D$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(D58>Contract_1),(D58-Contract_1),CRates_1),SUMPRODUCT(--(D58>Contract_2),(D58-Contract_2),CRates_2),SUMPRODUCT(--(D58>Contract_3),(D58-Contract_3),CRates_3),SUMPRODUCT(--(D58>Contract_4),(D58-Contract_4),CRates_4))
E82	=CHOOSE(SUMPRODUCT(--(E$65>=$B$31:$B$34),--(E$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(E58>Contract_1),(E58-Contract_1),CRates_1),SUMPRODUCT(--(E58>Contract_2),(E58-Contract_2),CRates_2),SUMPRODUCT(--(E58>Contract_3),(E58-Contract_3),CRates_3),SUMPRODUCT(--(E58>Contract_4),(E58-Contract_4),CRates_4))
F82	=CHOOSE(SUMPRODUCT(--(F$65>=$B$31:$B$34),--(F$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(F58>Contract_1),(F58-Contract_1),CRates_1),SUMPRODUCT(--(F58>Contract_2),(F58-Contract_2),CRates_2),SUMPRODUCT(--(F58>Contract_3),(F58-Contract_3),CRates_3),SUMPRODUCT(--(F58>Contract_4),(F58-Contract_4),CRates_4))
G82	=CHOOSE(SUMPRODUCT(--(G$65>=$B$31:$B$34),--(G$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(G58>Contract_1),(G58-Contract_1),CRates_1),SUMPRODUCT(--(G58>Contract_2),(G58-Contract_2),CRates_2),SUMPRODUCT(--(G58>Contract_3),(G58-Contract_3),CRates_3),SUMPRODUCT(--(G58>Contract_4),(G58-Contract_4),CRates_4))
H82	=CHOOSE(SUMPRODUCT(--(H$65>=$B$31:$B$34),--(H$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(H58>Contract_1),(H58-Contract_1),CRates_1),SUMPRODUCT(--(H58>Contract_2),(H58-Contract_2),CRates_2),SUMPRODUCT(--(H58>Contract_3),(H58-Contract_3),CRates_3),SUMPRODUCT(--(H58>Contract_4),(H58-Contract_4),CRates_4))
I82	=CHOOSE(SUMPRODUCT(--(I$65>=$B$31:$B$34),--(I$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(I58>Contract_1),(I58-Contract_1),CRates_1),SUMPRODUCT(--(I58>Contract_2),(I58-Contract_2),CRates_2),SUMPRODUCT(--(I58>Contract_3),(I58-Contract_3),CRates_3),SUMPRODUCT(--(I58>Contract_4),(I58-Contract_4),CRates_4))
J82	=CHOOSE(SUMPRODUCT(--(J$65>=$B$31:$B$34),--(J$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(J58>Contract_1),(J58-Contract_1),CRates_1),SUMPRODUCT(--(J58>Contract_2),(J58-Contract_2),CRates_2),SUMPRODUCT(--(J58>Contract_3),(J58-Contract_3),CRates_3),SUMPRODUCT(--(J58>Contract_4),(J58-Contract_4),CRates_4))
K82	=CHOOSE(SUMPRODUCT(--(K$65>=$B$31:$B$34),--(K$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(K58>Contract_1),(K58-Contract_1),CRates_1),SUMPRODUCT(--(K58>Contract_2),(K58-Contract_2),CRates_2),SUMPRODUCT(--(K58>Contract_3),(K58-Contract_3),CRates_3),SUMPRODUCT(--(K58>Contract_4),(K58-Contract_4),CRates_4))
L82	=CHOOSE(SUMPRODUCT(--(L$65>=$B$31:$B$34),--(L$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(L58>Contract_1),(L58-Contract_1),CRates_1),SUMPRODUCT(--(L58>Contract_2),(L58-Contract_2),CRates_2),SUMPRODUCT(--(L58>Contract_3),(L58-Contract_3),CRates_3),SUMPRODUCT(--(L58>Contract_4),(L58-Contract_4),CRates_4))
M82	=CHOOSE(SUMPRODUCT(--(M$65>=$B$31:$B$34),--(M$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(M58>Contract_1),(M58-Contract_1),CRates_1),SUMPRODUCT(--(M58>Contract_2),(M58-Contract_2),CRates_2),SUMPRODUCT(--(M58>Contract_3),(M58-Contract_3),CRates_3),SUMPRODUCT(--(M58>Contract_4),(M58-Contract_4),CRates_4))
N82	=CHOOSE(SUMPRODUCT(--(N$65>=$B$31:$B$34),--(N$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(N58>Contract_1),(N58-Contract_1),CRates_1),SUMPRODUCT(--(N58>Contract_2),(N58-Contract_2),CRates_2),SUMPRODUCT(--(N58>Contract_3),(N58-Contract_3),CRates_3),SUMPRODUCT(--(N58>Contract_4),(N58-Contract_4),CRates_4))
O82	=CHOOSE(SUMPRODUCT(--(O$65>=$B$31:$B$34),--(O$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(O58>Contract_1),(O58-Contract_1),CRates_1),SUMPRODUCT(--(O58>Contract_2),(O58-Contract_2),CRates_2),SUMPRODUCT(--(O58>Contract_3),(O58-Contract_3),CRates_3),SUMPRODUCT(--(O58>Contract_4),(O58-Contract_4),CRates_4))
C83	=CHOOSE(SUMPRODUCT(--(C$65>=$B$31:$B$34),--(C$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(C59>Contract_1),(C59-Contract_1),CRates_1),SUMPRODUCT(--(C59>Contract_2),(C59-Contract_2),CRates_2),SUMPRODUCT(--(C59>Contract_3),(C59-Contract_3),CRates_3),SUMPRODUCT(--(C59>Contract_4),(C59-Contract_4),CRates_4))
D83	=CHOOSE(SUMPRODUCT(--(D$65>=$B$31:$B$34),--(D$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(D59>Contract_1),(D59-Contract_1),CRates_1),SUMPRODUCT(--(D59>Contract_2),(D59-Contract_2),CRates_2),SUMPRODUCT(--(D59>Contract_3),(D59-Contract_3),CRates_3),SUMPRODUCT(--(D59>Contract_4),(D59-Contract_4),CRates_4))
E83	=CHOOSE(SUMPRODUCT(--(E$65>=$B$31:$B$34),--(E$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(E59>Contract_1),(E59-Contract_1),CRates_1),SUMPRODUCT(--(E59>Contract_2),(E59-Contract_2),CRates_2),SUMPRODUCT(--(E59>Contract_3),(E59-Contract_3),CRates_3),SUMPRODUCT(--(E59>Contract_4),(E59-Contract_4),CRates_4))
F83	=CHOOSE(SUMPRODUCT(--(F$65>=$B$31:$B$34),--(F$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(F59>Contract_1),(F59-Contract_1),CRates_1),SUMPRODUCT(--(F59>Contract_2),(F59-Contract_2),CRates_2),SUMPRODUCT(--(F59>Contract_3),(F59-Contract_3),CRates_3),SUMPRODUCT(--(F59>Contract_4),(F59-Contract_4),CRates_4))
G83	=CHOOSE(SUMPRODUCT(--(G$65>=$B$31:$B$34),--(G$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(G59>Contract_1),(G59-Contract_1),CRates_1),SUMPRODUCT(--(G59>Contract_2),(G59-Contract_2),CRates_2),SUMPRODUCT(--(G59>Contract_3),(G59-Contract_3),CRates_3),SUMPRODUCT(--(G59>Contract_4),(G59-Contract_4),CRates_4))
H83	=CHOOSE(SUMPRODUCT(--(H$65>=$B$31:$B$34),--(H$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(H59>Contract_1),(H59-Contract_1),CRates_1),SUMPRODUCT(--(H59>Contract_2),(H59-Contract_2),CRates_2),SUMPRODUCT(--(H59>Contract_3),(H59-Contract_3),CRates_3),SUMPRODUCT(--(H59>Contract_4),(H59-Contract_4),CRates_4))
I83	=CHOOSE(SUMPRODUCT(--(I$65>=$B$31:$B$34),--(I$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(I59>Contract_1),(I59-Contract_1),CRates_1),SUMPRODUCT(--(I59>Contract_2),(I59-Contract_2),CRates_2),SUMPRODUCT(--(I59>Contract_3),(I59-Contract_3),CRates_3),SUMPRODUCT(--(I59>Contract_4),(I59-Contract_4),CRates_4))
J83	=CHOOSE(SUMPRODUCT(--(J$65>=$B$31:$B$34),--(J$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(J59>Contract_1),(J59-Contract_1),CRates_1),SUMPRODUCT(--(J59>Contract_2),(J59-Contract_2),CRates_2),SUMPRODUCT(--(J59>Contract_3),(J59-Contract_3),CRates_3),SUMPRODUCT(--(J59>Contract_4),(J59-Contract_4),CRates_4))
K83	=CHOOSE(SUMPRODUCT(--(K$65>=$B$31:$B$34),--(K$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(K59>Contract_1),(K59-Contract_1),CRates_1),SUMPRODUCT(--(K59>Contract_2),(K59-Contract_2),CRates_2),SUMPRODUCT(--(K59>Contract_3),(K59-Contract_3),CRates_3),SUMPRODUCT(--(K59>Contract_4),(K59-Contract_4),CRates_4))
L83	=CHOOSE(SUMPRODUCT(--(L$65>=$B$31:$B$34),--(L$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(L59>Contract_1),(L59-Contract_1),CRates_1),SUMPRODUCT(--(L59>Contract_2),(L59-Contract_2),CRates_2),SUMPRODUCT(--(L59>Contract_3),(L59-Contract_3),CRates_3),SUMPRODUCT(--(L59>Contract_4),(L59-Contract_4),CRates_4))
M83	=CHOOSE(SUMPRODUCT(--(M$65>=$B$31:$B$34),--(M$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(M59>Contract_1),(M59-Contract_1),CRates_1),SUMPRODUCT(--(M59>Contract_2),(M59-Contract_2),CRates_2),SUMPRODUCT(--(M59>Contract_3),(M59-Contract_3),CRates_3),SUMPRODUCT(--(M59>Contract_4),(M59-Contract_4),CRates_4))
N83	=CHOOSE(SUMPRODUCT(--(N$65>=$B$31:$B$34),--(N$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(N59>Contract_1),(N59-Contract_1),CRates_1),SUMPRODUCT(--(N59>Contract_2),(N59-Contract_2),CRates_2),SUMPRODUCT(--(N59>Contract_3),(N59-Contract_3),CRates_3),SUMPRODUCT(--(N59>Contract_4),(N59-Contract_4),CRates_4))
O83	=CHOOSE(SUMPRODUCT(--(O$65>=$B$31:$B$34),--(O$65<=$C$31:$C$34),$A$31:$A$34),SUMPRODUCT(--(O59>Contract_1),(O59-Contract_1),CRates_1),SUMPRODUCT(--(O59>Contract_2),(O59-Contract_2),CRates_2),SUMPRODUCT(--(O59>Contract_3),(O59-Contract_3),CRates_3),SUMPRODUCT(--(O59>Contract_4),(O59-Contract_4),CRates_4))
C84	=SUM(C66:C83)
D84	=SUM(D66:D83)
E84	=SUM(E66:E83)
F84	=SUM(F66:F83)
G84	=SUM(G66:G83)
H84	=SUM(H66:H83)
I84	=SUM(I66:I83)
J84	=SUM(J66:J83)
K84	=SUM(K66:K83)
L84	=SUM(L66:L83)
M84	=SUM(M66:M83)
N84	=SUM(N66:N83)
O84	=SUM(O66:O83)

Your help would be appreciated

Kind Regards

Biz

Formula Streamline

Biz

Well-known Member

Excel Facts

Similar threads

Forum statistics

Share this page

Formula Streamline

Biz

Well-known Member

Excel Facts

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock