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
1
2	Contract 1
3	Transaction No. is Greater Than:		But Less Than or Equal to:	Revenue Rate	Differential rate
4	-		1,000,000	$0.10	$0.10
5	1,000,000		5,000,000	$0.08	($0.02)
6	5,000,000			$0.05	($0.03)
7
8	Effective Date
9	Contract 2
10	Transaction No. is Greater Than:	But Less Than or Equal to:	Revenue Rate	Differential rate
11	-	1,000,000	$0.03	$0.03
12
13
14	Contract 3
15	Transaction No. is Greater Than:	But Less Than or Equal to:	Revenue Rate	Differential rate
16	-	1,000,000	$0.10	$0.10
17	1,000,000	5,000,000	$0.08	($0.02)
18	5,000,000		$0.04	($0.04)
19
20
21	Contract 4
22	Transaction No. is Greater Than:	But Less Than or Equal to:	Revenue Rate	Differential rate
23	-	1,000,000	$0.08	$0.08
24	1,000,000	5,000,000	$0.06	($0.02)
25	5,000,000		$0.04	($0.02)

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

29

Scenario 1

Scenario 2

Scenario 3

Scenario 4

Scenario 5

Scenario 6

Scenario 7

30

Contract Type

Start Date

End date

Start Date

End date

Start Date

End date

Start Date

End date

Start Date

End date

Start Date

End date

Start Date

End date

31

Contract 1

1/01/2015

31/12/2016

1/01/2015

31/12/2016

1/01/2015

31/12/2016

1/01/2015

31/12/2016

32

Contract 2

1/01/2017

31/12/2020

1/01/2017

31/12/2020

1/01/2017

31/12/2020

1/01/2017

31/12/2020

33

Contract 3

1/01/2021

31/12/2024

1/01/2021

31/12/2024

1/01/2021

31/12/2024

1/01/2021

31/12/2024

1/01/2015

31/12/2020

1/01/2015

31/12/2020

34

Contract 4

1/01/2021

31/12/2024

1/01/2021

31/12/2024

1/01/2015

31/12/2024

Sheet1

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
40	Total Transactions
41		Start Date	Jan-15	Feb-15	Mar-15	Apr-15	May-15	Jun-15	Jul-15	Aug-15	Sep-15	Oct-15	Nov-15	Dec-15	Jan-16
42	Person1	01/04/2015	-	-	-	939,789	1,225,385	1,596,110	2,076,251	2,696,307	3,494,120	4,515,942	5,817,148	7,462,254	9,523,749
43	Person2	01/04/2015	-	-	-	1,273,167	1,660,077	2,162,314	2,812,772	3,652,787	4,733,618	6,117,925	7,880,714	10,109,398	12,902,185
44	Person3	01/05/2015	-	-	-	-	343,044	447,291	582,613	757,871	984,201	1,275,428	1,648,415	2,123,378	2,723,868
45	Person4	01/05/2015	-	-	-	-	379,899	495,340	645,198	839,291	1,089,932	1,412,445	1,825,493	2,351,492	3,016,493
46	Person5	01/05/2015	-	-	-	-	733,455	956,348	1,245,675	1,620,393	2,104,310	2,726,964	3,524,438	4,539,956	5,823,869
47	Person6	01/05/2015	-	-	-	-	969,444	1,264,052	1,646,475	2,141,763	2,781,375	3,604,362	4,658,435	6,000,694	7,697,704
48	Person7	01/06/2015	-	-	-	-	-	82,233	107,223	139,657	181,673	235,924	305,733	395,146	508,999
49	Person8	01/07/2015	-	-	-	-	-	-	161,244	210,240	273,848	356,232	462,615	599,495	774,809
50	Person9	01/07/2015	-	-	-	-	-	-	316,134	412,206	536,922	698,428	907,013	1,175,394	1,519,121
51	Person10	01/08/2015	-	-	-	-	-	-	-	181,044	236,061	307,477	399,967	519,420	673,108
52	Person11	01/12/2015	-	-	-	-	-	-	-	-	-	-	-	31,833	41,507
53	Person12	01/11/2015	-	-	-	-	-	-	-	-	-	-	52,101	67,942	88,490
54	Person13	01/09/2015	-	-	-	-	-	-	-	-	277,488	361,811	471,268	613,038	796,119
55	Person14	01/10/2015	-	-	-	-	-	-	-	-	-	123,912	161,577	210,451	273,768
56	Person15	01/09/2026	-	-	-	-	-	-	-	-	-	-	-	-	-
57	Person16	01/10/2026	-	-	-	-	-	-	-	-	-	-	-	-	-
58	Person17	01/03/2015	-	-	4,044,978	5,274,220	6,869,877	8,936,458	11,605,248	15,039,152	19,437,231	25,037,794	32,118,531	40,991,475	51,990,000
59	Person18	01/03/2015	-	-	535,545	698,296	909,559	1,183,168	1,536,516	1,991,150	2,573,453	3,314,954	4,252,433	5,427,191	6,883,373
60			-	-	4,580,523	8,185,472	13,090,741	17,123,313	22,735,348	29,681,861	38,704,233	50,089,600	64,485,880	82,618,558	105,237,163

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
64	Revenue
65	Sceanrio 1		Jan-15	Feb-15	Mar-15	Apr-15	May-15	Jun-15	Jul-15	Aug-15	Sep-15	Oct-15	Nov-15	Dec-15	Jan-16
66	Person1		$0.00	$0.00	$0.00	$93,978.90	$118,030.84	$147,688.79	$186,100.09	$235,704.54	$299,529.62	$381,275.39	$460,857.39	$543,112.68	$646,187.43
67	Person2		$0.00	$0.00	$0.00	$121,853.36	$152,806.19	$192,985.11	$245,021.79	$312,222.95	$398,689.42	$475,896.26	$564,035.71	$675,469.89	$815,109.25
68	Person3		$0.00	$0.00	$0.00	$0.00	$34,304.40	$44,729.07	$58,261.28	$75,787.12	$98,420.13	$122,034.23	$151,873.17	$189,870.22	$237,909.48
69	Person4		$0.00	$0.00	$0.00	$0.00	$37,989.90	$49,534.03	$64,519.78	$83,929.11	$107,194.57	$132,995.64	$166,039.43	$208,119.35	$261,319.43
70	Person5		$0.00	$0.00	$0.00	$0.00	$73,345.50	$95,634.77	$119,653.98	$149,631.40	$188,344.84	$238,157.09	$301,955.06	$383,196.49	$461,193.44
71	Person6		$0.00	$0.00	$0.00	$0.00	$96,944.40	$121,124.20	$151,717.97	$191,341.05	$242,509.99	$308,348.98	$392,674.79	$470,034.70	$554,885.18
72	Person7		$0.00	$0.00	$0.00	$0.00	$0.00	$8,223.30	$10,722.29	$13,965.73	$18,167.29	$23,592.44	$30,573.26	$39,514.65	$50,899.93
73	Person8		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$16,124.40	$21,024.02	$27,384.81	$35,623.24	$46,261.49	$59,949.49	$77,480.90
74	Person9		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$31,613.40	$41,220.64	$53,692.17	$69,842.79	$90,701.34	$114,031.52	$141,529.69
75	Person10		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$18,104.40	$23,606.09	$30,747.74	$39,996.72	$51,942.05	$67,310.78
76	Person11		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$3,183.30	$4,150.74
77	Person12		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$5,210.10	$6,794.21	$8,849.03
78	Person13		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$27,748.80	$36,181.10	$47,126.75	$61,303.81	$79,611.92
79	Person14		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$12,391.20	$16,157.66	$21,045.14	$27,376.78
80	Person15		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
81	Person16		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
82	Person17		$0.00	$0.00	$343,598.24	$433,711.00	$513,493.87	$616,822.88	$750,262.40	$921,957.60	$1,141,861.57	$1,421,889.70	$1,775,926.55	$2,219,573.77	$2,769,500.02
83	Person18		$0.00	$0.00	$53,554.50	$69,829.61	$90,955.88	$114,653.41	$142,921.26	$179,292.00	$225,876.24	$285,196.32	$360,194.67	$441,359.55	$514,168.68
84			-	-	397,153	719,373	1,117,871	1,391,396	1,776,919	2,244,181	2,853,026	3,574,172	4,449,584	5,488,501	6,717,483

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