Help! Trouble making a interactive graph and embedding data

[pulary]

Hey Everyone,

I am having trouble completing an assignment at work. I am tasked with creating an interactive pricing analysis. I have data from 2011-2014, and I need to create an interactive graph that shows my data in a year over year, as well as quarter comparisons. I would like for the graphs to be based off a selection of criteria.

I thought about using a cover page, and then having my data being pulled in through Vlookup's, but ran into trouble getting the quarter data to pull over.

Any help would be greatly appreciated. I am not sure how to add my file. I can email to anyone that wants it. My email address is pulary@verizon.net

Thanks for your help everyone. Sorry I am not sure how to add my file to make it easier for you

Phillip

Excel 2007
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	Q	R	S	T
1	Revenue		Jan-11	Feb-11	Mar-11	Apr-11	May-11	Jun-11	Jul-11	Aug-11	Sep-11	Oct-11	Nov-11	Dec-11	YTD Total	Q1-2012	Q2-2012	Q3-2012	Q4-2012
2		Product 1	$2,553,175.00	$2,483,037.77	$3,283,764.61	$2,887,841.89	$3,242,992.71	$3,817,426.69	$2,982,685.29	$4,897,732.12	$4,575,282.90	$4,440,173.93	$3,919,177.21	$3,694,056.81	$42,777,346.93	$8,319,977.38	$9,948,261.29	$12,455,700.31	$12,053,407.95
3		Product 2	$46,199.25	$53,107.15	$66,643.40	$58,278.60	$64,816.25	$72,110.15	$61,852.85	$78,286.60	$71,961.00	$71,814.90	$67,525.75	$61,150.30	$773,746.20	$165,949.80	$195,205.00	$212,100.45	$200,490.95
4		Product 3	$53,636.30	$56,705.35	$76,429.10	$66,668.80	$68,593.40	$71,036.00	$58,316.55	$70,320.45	$147,205.65	($16,942.40)	$59,791.65	$51,941.75	$763,702.60	$186,770.75	$206,298.20	$275,842.65	$94,791.00
5		Product 4	$36,285.00	$28,468.00	$37,367.00	$36,591.50	$35,541.00	$39,093.00	$34,626.50	$54,382.00	$50,471.00	$49,860.00	$44,992.50	$42,878.00	$490,555.50	$102,120.00	$111,225.50	$139,479.50	$137,730.50
6		Product 5	$187,757.00	$187,653.50	$244,171.00	$227,954.50	$246,462.75	$262,482.50	$249,382.75	$350,915.50	$348,446.25	$348,122.25	$404,893.75	$306,530.00	$3,364,771.75	$619,581.50	$736,899.75	$948,744.50	$1,059,546.00
7		Product 6	$3,487.00	$2,108.50	$2,697.50	$2,643.00	$3,470.50	$3,238.00	$2,629.00	$3,358.00	$2,466.00	$3,182.00	$2,767.75	$2,825.00	$34,872.25	$8,293.00	$9,351.50	$8,453.00	$8,774.75
8		Product 7	$168,737.90	$157,713.35	$196,221.50	$177,407.30	$195,398.15	$230,561.75	$169,114.50	$215,655.90	$193,218.20	$188,420.35	$210,442.35	$278,134.30	$2,381,025.55	$522,672.75	$603,367.20	$577,988.60	$676,997.00
9
10		Total Prod Rev	$3,049,277.45	$2,968,793.62	$3,907,294.11	$3,457,385.59	$3,857,274.76	$4,495,948.09	$3,558,607.44	$5,670,650.57	$5,389,051.00	$5,084,631.03	$4,709,590.96	$4,437,516.16	$50,586,020.78	$9,925,365.18	$11,810,608.44	$14,618,309.01	$14,231,738.15
11
12		Product 8	$142,776.35	$209,513.05	$255,891.80	$125,483.35	$168,839.55	$154,987.70	$111,762.55	$123,692.30	$187,915.50	$107,873.25	$121,477.00	$103,049.45	$1,813,261.85	$608,181.20	$449,310.60	$423,370.35	$332,399.70
13		Product 9	$50,543.50	$37,161.60	$43,026.00	$32,813.00	$36,901.50	$40,631.50	$39,272.00	$48,274.50	$48,771.50	$48,883.00	$81,957.00	$159,102.80	$667,337.90	$130,731.10	$110,346.00	$136,318.00	$289,942.80
14		Product 10	$1,420.70	$408.00	$2,716.00	$686.00	$458.00	$1,248.00	$687.60	$670.00	$296.00	$1,121.30	$484.00	$476.00	$10,671.60	$4,544.70	$2,392.00	$1,653.60	$2,081.30
15		Product 11	$1,287.30	$20,626.25	$2,026.40	$22,194.60	$7,428.55	$50,758.70	$7,216.65	$28,362.25	$4,581.25	$1,486.30	$38,063.35	$253,402.85	$437,434.45	$23,939.95	$80,381.85	$40,160.15	$292,952.50
16
17		Total Conv Rev	$196,027.85	$267,708.90	$303,660.20	$181,176.95	$213,627.60	$247,625.90	$158,938.80	$200,999.05	$241,564.25	$159,363.85	$241,981.35	$516,031.10	$2,928,705.80	$767,396.95	$642,430.45	$601,502.10	$917,376.30
18
19		Net Total Rev	$3,245,305.30	$3,236,502.52	$4,210,954.31	$3,638,562.54	$4,070,902.36	$4,743,573.99	$3,717,546.24	$5,871,649.62	$5,630,615.25	$5,243,994.88	$4,951,572.31	$4,953,547.26	$53,514,726.58	$10,692,762.13	$12,453,038.89	$15,219,811.11	$15,149,114.45
20
21		Product 12	$0.00	$0.00	($1.00)	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	($1.00)	($1.00)	$0.00	$0.00	$0.00
22		Product 13	$379,649.91	$441,960.85	$540,660.64	$449,366.06	$552,629.31	$531,768.89	$399,152.05	$500,842.59	$534,623.50	$507,749.85	$366,488.90	$321,618.43	$5,526,510.98	$1,362,271.40	$1,533,764.26	$1,434,618.14	$1,195,857.18
23																$0.00	$0.00	$0.00	$0.00
24	Total Revenue with Product 13		$3,624,955.21	$3,678,463.37	$4,751,613.95	$4,087,928.60	$4,623,531.67	$5,275,342.88	$4,116,698.29	$6,372,492.21	$6,165,238.75	$5,751,744.73	$5,318,061.21	$5,275,165.69	$59,041,236.56	$12,055,032.53	$13,986,803.15	$16,654,429.25	$16,344,971.63
25
26		SR&A	($100,000.00)	($100,000.00)	($300,000.00)	($300,000.00)	($250,000.00)	($250,000.00)	($200,000.00)	($200,000.00)	($200,000.00)	($200,000.00)	($200,000.00)	($200,000.00)	($2,500,000.00)	($500,000.00)	($800,000.00)	($600,000.00)	($600,000.00)
27
28		Net Cert Based Rev	$3,524,955.21	$3,578,463.37	$4,451,613.95	$3,787,928.60	$4,373,531.67	$5,025,342.88	$3,916,698.29	$6,172,492.21	$5,965,238.75	$5,551,744.73	$5,118,061.21	$5,075,165.69	$56,541,236.56	$11,555,032.53	$13,186,803.15	$16,054,429.25	$15,744,971.63
30
31	Volume		Jan-11	Feb-11	Mar-11	Apr-11	May-11	Jun-11	Jul-11	Aug-11	Sep-11	Oct-11	Nov-11	Dec-11	YTD Total
32		Product 1	385,082	308,856	400,105	348,276	385,953	435,571	391,536	583,871	549,980	527,773	463,820	449,647	5,230,470	1,094,043	1,169,800	1,525,387	1,441,240
33		Product 2	5,289	6,324	7,944	6,894	7,694	8,410	7,278	9,124	8,484	8,395	7,815	7,127	90,778	19,557	22,998	24,886	23,337
34		Product 3	9,419	9,925	14,983	13,453	13,524	13,128	10,934	12,348	12,056	11,499	10,480	9,470	141,219	34,327	40,105	35,338	31,449
35		Product 4	2,906	2,318	3,048	2,958	2,913	3,154	2,825	4,603	4,211	4,158	3,644	3,489	40,227	8,272	9,025	11,639	11,291
36		Product 5	27,309	27,373	35,249	33,638	36,428	38,379	36,662	51,271	51,140	50,745	61,256	44,925	494,375	89,931	108,445	139,073	156,926
37		Product 6	234	231	274	281	309	307	258	272	233	266	253	261	3,179	739	897	763	780
38		Product 7	12,561	11,786	14,596	13,087	14,135	18,111	12,896	16,398	14,445	13,943	16,461	16,409	174,828	38,943	45,333	43,739	46,813
39
40		Total Prod	442,800	366,813	476,199	418,587	460,956	517,060	462,389	677,887	640,549	616,779	563,729	531,328	6,175,076	1,285,812	1,396,603	1,780,825	1,711,836
41
42		Product 8	59,966	75,790	83,583	43,287	56,695	40,589	32,559	34,349	42,314	36,600	61,264	37,003	603,999	219,339	140,571	109,222	134,867
43		Product 9	12,283	9,295	10,279	7,736	10,131	9,609	9,001	10,499	11,743	11,168	27,197	83,852	212,793	31,857	27,476	31,243	122,217
44		Product 10	991	362	1,358	567	229	624	534	335	148	842	242	238	6,470	2,711	1,420	1,017	1,322
45		Product 11	2,191	30,718	837	4,814	19,400	50,547	2,678	11,289	1,741	961	19,480	123,843	268,499	33,746	74,761	15,708	144,284
46
47		Total Conv	75,431	116,165	96,057	56,404	86,455	101,369	44,772	56,472	55,946	49,571	108,183	244,936	1,091,761	287,653	244,228	157,190	402,690
48
49		Net Total Volume	518,231	482,978	572,256	474,991	547,411	618,429	507,161	734,359	696,495	666,350	671,912	776,264	7,266,837	1,573,465	1,640,831	1,938,015	2,114,526
50
51		Product 12	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
52		Product 13	185,319	216,340	281,085	260,475	282,518	266,196	212,016	239,536	263,697	230,378	202,859	165,355	2,805,774	682,744	809,189	715,249	598,592
53
54	Total Volume with WYO		703,550	699,318	853,341	735,466	829,929	884,625	719,177	973,895	960,192	896,728	874,771	941,619	10,072,611	2,256,209	2,450,020	2,653,264	2,713,118
55
56	Price Per Unit		Jan-11	Feb-11	Mar-11	Apr-11	May-11	Jun-11	Jul-11	Aug-11	Sep-11	Oct-11	Nov-11	Dec-11	YTD Total
57		Product 1	$6.63	$8.04	$8.21	$8.29	$8.40	$8.76	$7.62	$8.39	$8.32	$8.41	$8.45	$8.22	$8.18	$7.60	$8.50	$8.17	$8.36
58		Product 2	$8.73	$8.40	$8.39	$8.45	$8.42	$8.57	$8.50	$8.58	$8.48	$8.55	$8.64	$8.58	$8.52	$8.49	$8.49	$8.52	$8.59
59		Product 3	$5.69	$5.71	$5.10	$4.96	$5.07	$5.41	$5.33	$5.69	$12.21	($1.47)	$5.71	$5.48	$5.41	$5.44	$5.14	$7.81	$3.01
60		Product 4	$12.49	$12.28	$12.26	$12.37	$12.20	$12.39	$12.26	$11.81	$11.99	$11.99	$12.35	$12.29	$12.19	$12.35	$12.32	$11.98	$12.20
61		Product 5	$6.88	$6.86	$6.93	$6.78	$6.77	$6.84	$6.80	$6.84	$6.81	$6.86	$6.61	$6.82	$6.81	$6.89	$6.80	$6.82	$6.75
62		Product 6	$14.90	$9.13	$9.84	$9.41	$11.23	$10.55	$10.19	$12.35	$10.58	$11.96	$10.94	$10.82	$10.97	$11.22	$10.43	$11.08	$11.25
63		Product 7	$13.43	$13.38	$13.44	$13.56	$13.82	$12.73	$13.11	$13.15	$13.38	$13.51	$12.78	$16.95	$13.62	$13.42	$13.31	$13.21	$14.46
64
65		Total Prod PPU	$6.89	$8.09	$8.21	$8.26	$8.37	$8.70	$7.70	$8.37	$8.41	$8.24	$8.35	$8.35	$8.19	$7.72	$8.46	$8.21	$8.31
66
67		Product 8	$2.38	$2.76	$3.06	$2.90	$2.98	$3.82	$3.43	$3.60	$4.44	$2.95	$1.98	$2.78	$3.00	$2.77	$3.20	$3.88	$2.46
68		Product 9	$4.11	$4.00	$4.19	$4.24	$3.64	$4.23	$4.36	$4.60	$4.15	$4.38	$3.01	$1.90	$3.14	$4.10	$4.02	$4.36	$2.37
69		Product 10	$1.43	$1.13	$2.00	$1.21	$2.00	$2.00	$1.29	$2.00	$2.00	$1.33	$2.00	$2.00	$1.65	$1.68	$1.68	$1.63	$1.57
70		Product 11	$0.59	$0.67	$2.42	$4.61	$0.38	$1.00	$2.69	$2.51	$2.63	$1.55	$1.95	$2.05	$1.63	$0.71	$1.08	$2.56	$2.03
71
72		Total Conv PPU	$2.60	$2.30	$3.16	$3.21	$2.47	$2.44	$3.55	$3.56	$4.32	$3.21	$2.24	$2.11	$2.68	$2.67	$2.63	$3.83	$2.28
73
74		Net Total PPU	$6.26	$6.70	$7.36	$7.66	$7.44	$7.67	$7.33	$8.00	$8.08	$7.87	$7.37	$6.38	$7.36	$6.80	$7.59	$7.85	$7.16
75
76		Product 12	$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	$0.00	$0.00	$0.00	$0.00
77		Product 13	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
78
79	Total PPU with Product 13		$5.15	$5.26	$5.57	$5.56	$5.57	$5.96	$5.72	$6.54	$6.42	$6.41	$6.08	$5.60	$5.86	$5.34	$5.71	$6.28	$6.02
80
81		YTD Price Per Unit	$5.15	$5.21	$5.34	$5.40	$5.43	$5.53	$5.56	$5.71	$5.80	$5.87	$5.89	$5.86
82						QTD	$5.57	$5.71	$5.72	$6.20	$6.28	$6.41	$6.25	$6.02
83
84		Business Days	20	19	23	21	21	22	20	23	21	21	20	21	252
85		Week Days	21	20	23	21	22	22	21	23	22	21	22	22	260
86
87		Avg. Daily Volume	35,178	36,806	37,102	35,022	39,520	40,210	35,959	42,343	45,723	42,701	43,739	44,839	39,971
88
89
90
91
2011 Price Per Cert

Cell Formulas
Range	Formula
O2	=SUM(C2:N2)
O3	=SUM(C3:N3)
O4	=SUM(C4:N4)
O5	=SUM(C5:N5)
O6	=SUM(C6:N6)
O7	=SUM(C7:N7)
O8	=SUM(C8:N8)
O10	=SUM(O2:O9)
O12	=SUM(C12:N12)
O13	=SUM(C13:N13)
O14	=SUM(C14:N14)
O15	=SUM(C15:N15)
O17	=SUM(O12:O16)
O19	=SUM(O10,O17)
O21	=SUM(C21:N21)
O22	=SUM(C22:N22)
O24	=SUM(O19,SUM(O21:O23))
O26	=SUM(C26:N26)
O28	=+O24+O26
O32	=SUM(C32:N32)
O33	=SUM(C33:N33)
O34	=SUM(C34:N34)
O35	=SUM(C35:N35)
O36	=SUM(C36:N36)
O37	=SUM(C37:N37)
O38	=SUM(C38:N38)
O40	=SUM(O32:O39)
O42	=SUM(C42:N42)
O43	=SUM(C43:N43)
O44	=SUM(C44:N44)
O45	=SUM(C45:N45)
O47	=SUM(O42:O46)
O49	=SUM(O40,O47)
O51	=SUM(C51:N51)
O52	=SUM(C52:N52)
O54	=SUM(O49,SUM(O51:O52))
O57	=IF(O32=0,0,+O2/O32)
O58	=IF(O33=0,0,+O3/O33)
O59	=IF(O34=0,0,+O4/O34)
O60	=IF(O35=0,0,+O5/O35)
O61	=IF(O36=0,0,+O6/O36)
O62	=IF(O37=0,0,+O7/O37)
O63	=IF(O38=0,0,+O8/O38)
O65	=IF(O40=0,0,+O10/O40)
O67	=IF(O42=0,0,+O12/O42)
O68	=IF(O43=0,0,+O13/O43)
O69	=IF(O44=0,0,+O14/O44)
O70	=IF(O45=0,0,+O15/O45)
O72	=IF(O47=0,0,+O17/O47)
O74	=IF(O49=0,0,+O19/O49)
O76	=IF(O51=0,0,+O21/O51)
O77	=IF(O52=0,0,+O22/(O52+#REF!))
O79	=IF(O54=0,0,+O24/O54)
O84	=SUM(C84:N84)
O85	=SUM(C85:N85)
O87	=O54/O84
C10	=SUM(C2:C9)
C17	=SUM(C12:C16)
C19	=SUM(C10,C17)
C24	=SUM(C19,SUM(C21:C23))
C28	=+C24+C26
C40	=SUM(C32:C39)
C47	=SUM(C42:C46)
C49	=SUM(C40,C47)
C54	=SUM(C49,SUM(C51:C52))
C57	=IF(C32=0,0,+C2/C32)
C58	=IF(C33=0,0,+C3/C33)
C59	=IF(C34=0,0,+C4/C34)
C60	=IF(C35=0,0,+C5/C35)
C61	=IF(C36=0,0,+C6/C36)
C62	=IF(C37=0,0,+C7/C37)
C63	=IF(C38=0,0,+C8/C38)
C65	=IF(C40=0,0,+C10/C40)
C67	=IF(C42=0,0,+C12/C42)
C68	=IF(C43=0,0,+C13/C43)
C69	=IF(C44=0,0,+C14/C44)
C70	=IF(C45=0,0,+C15/C45)
C72	=IF(C47=0,0,+C17/C47)
C74	=IF(C49=0,0,+C19/C49)
C76	=IF(C51=0,0,+C21/C51)
C77	=IF(C52=0,0,+C22/(C52+#REF!))
C79	=IF(C54=0,0,+C24/C54)
C81	=C79
C87	=C54/C84
D10	=SUM(D2:D9)
D17	=SUM(D12:D16)
D19	=SUM(D10,D17)
D24	=SUM(D19,SUM(D21:D23))
D28	=+D24+D26
D40	=SUM(D32:D39)
D47	=SUM(D42:D46)
D49	=SUM(D40,D47)
D54	=SUM(D49,SUM(D51:D52))
D57	=IF(D32=0,0,+D2/D32)
D58	=IF(D33=0,0,+D3/D33)
D59	=IF(D34=0,0,+D4/D34)
D60	=IF(D35=0,0,+D5/D35)
D61	=IF(D36=0,0,+D6/D36)
D62	=IF(D37=0,0,+D7/D37)
D63	=IF(D38=0,0,+D8/D38)
D65	=IF(D40=0,0,+D10/D40)
D67	=IF(D42=0,0,+D12/D42)
D68	=IF(D43=0,0,+D13/D43)
D69	=IF(D44=0,0,+D14/D44)
D70	=IF(D45=0,0,+D15/D45)
D72	=IF(D47=0,0,+D17/D47)
D74	=IF(D49=0,0,+D19/D49)
D76	=IF(D51=0,0,+D21/D51)
D77	=IF(D52=0,0,+D22/(D52+#REF!))
D79	=IF(D54=0,0,+D24/D54)
D81	=(SUM($C$24:D$24)/SUM($C$54:D$54))
D87	=D54/D84
E10	=SUM(E2:E9)
E17	=SUM(E12:E16)
E19	=SUM(E10,E17)
E24	=SUM(E19,SUM(E21:E23))
E28	=+E24+E26
E40	=SUM(E32:E39)
E47	=SUM(E42:E46)
E49	=SUM(E40,E47)
E54	=SUM(E49,SUM(E51:E52))
E57	=IF(E32=0,0,+E2/E32)
E58	=IF(E33=0,0,+E3/E33)
E59	=IF(E34=0,0,+E4/E34)
E60	=IF(E35=0,0,+E5/E35)
E61	=IF(E36=0,0,+E6/E36)
E62	=IF(E37=0,0,+E7/E37)
E63	=IF(E38=0,0,+E8/E38)
E65	=IF(E40=0,0,+E10/E40)
E67	=IF(E42=0,0,+E12/E42)
E68	=IF(E43=0,0,+E13/E43)
E69	=IF(E44=0,0,+E14/E44)
E70	=IF(E45=0,0,+E15/E45)
E72	=IF(E47=0,0,+E17/E47)
E74	=IF(E49=0,0,+E19/E49)
E76	=IF(E51=0,0,+E21/E51)
E77	=IF(E52=0,0,+E22/(E52+#REF!))
E79	=IF(E54=0,0,+E24/E54)
E81	=(SUM($C$24:E$24)/SUM($C$54:E$54))
E87	=E54/E84
F10	=SUM(F2:F9)
F17	=SUM(F12:F16)
F19	=SUM(F10,F17)
F24	=SUM(F19,SUM(F21:F23))
F28	=+F24+F26
F40	=SUM(F32:F39)
F47	=SUM(F42:F46)
F49	=SUM(F40,F47)
F54	=SUM(F49,SUM(F51:F52))
F57	=IF(F32=0,0,+F2/F32)
F58	=IF(F33=0,0,+F3/F33)
F59	=IF(F34=0,0,+F4/F34)
F60	=IF(F35=0,0,+F5/F35)
F61	=IF(F36=0,0,+F6/F36)
F62	=IF(F37=0,0,+F7/F37)
F63	=IF(F38=0,0,+F8/F38)
F65	=IF(F40=0,0,+F10/F40)
F67	=IF(F42=0,0,+F12/F42)
F68	=IF(F43=0,0,+F13/F43)
F69	=IF(F44=0,0,+F14/F44)
F70	=IF(F45=0,0,+F15/F45)
F72	=IF(F47=0,0,+F17/F47)
F74	=IF(F49=0,0,+F19/F49)
F76	=IF(F51=0,0,+F21/F51)
F77	=IF(F52=0,0,+F22/(F52+#REF!))
F79	=IF(F54=0,0,+F24/F54)
F81	=(SUM($C$24:F$24)/SUM($C$54:F$54))
F87	=F54/F84
G10	=SUM(G2:G9)
G17	=SUM(G12:G16)
G19	=SUM(G10,G17)
G24	=SUM(G19,SUM(G21:G23))
G28	=+G24+G26
G40	=SUM(G32:G39)
G47	=SUM(G42:G46)
G49	=SUM(G40,G47)
G54	=SUM(G49,SUM(G51:G52))
G57	=IF(G32=0,0,+G2/G32)
G58	=IF(G33=0,0,+G3/G33)
G59	=IF(G34=0,0,+G4/G34)
G60	=IF(G35=0,0,+G5/G35)
G61	=IF(G36=0,0,+G6/G36)
G62	=IF(G37=0,0,+G7/G37)
G63	=IF(G38=0,0,+G8/G38)
G65	=IF(G40=0,0,+G10/G40)
G67	=IF(G42=0,0,+G12/G42)
G68	=IF(G43=0,0,+G13/G43)
G69	=IF(G44=0,0,+G14/G44)
G70	=IF(G45=0,0,+G15/G45)
G72	=IF(G47=0,0,+G17/G47)
G74	=IF(G49=0,0,+G19/G49)
G76	=IF(G51=0,0,+G21/G51)
G77	=IF(G52=0,0,+G22/(G52+#REF!))
G79	=IF(G54=0,0,+G24/G54)
G81	=(SUM($C$24:G$24)/SUM($C$54:G$54))
G82	=(SUM($F$24:G$24)/SUM($F$54:G$54))
G87	=G54/G84
H10	=SUM(H2:H9)
H17	=SUM(H12:H16)
H19	=SUM(H10,H17)
H24	=SUM(H19,SUM(H21:H23))
H28	=+H24+H26
H40	=SUM(H32:H39)
H47	=SUM(H42:H46)
H49	=SUM(H40,H47)
H54	=SUM(H49,SUM(H51:H52))
H57	=IF(H32=0,0,+H2/H32)
H58	=IF(H33=0,0,+H3/H33)
H59	=IF(H34=0,0,+H4/H34)
H60	=IF(H35=0,0,+H5/H35)
H61	=IF(H36=0,0,+H6/H36)
H62	=IF(H37=0,0,+H7/H37)
H63	=IF(H38=0,0,+H8/H38)
H65	=IF(H40=0,0,+H10/H40)
H67	=IF(H42=0,0,+H12/H42)
H68	=IF(H43=0,0,+H13/H43)
H69	=IF(H44=0,0,+H14/H44)
H70	=IF(H45=0,0,+H15/H45)
H72	=IF(H47=0,0,+H17/H47)
H74	=IF(H49=0,0,+H19/H49)
H76	=IF(H51=0,0,+H21/H51)
H77	=IF(H52=0,0,+H22/(H52+#REF!))
H79	=IF(H54=0,0,+H24/H54)
H81	=(SUM($C$24:H$24)/SUM($C$54:H$54))
H82	=(SUM($F$24:H$24)/SUM($F$54:H$54))
H87	=H54/H84
I10	=SUM(I2:I9)
I17	=SUM(I12:I16)
I19	=SUM(I10,I17)
I24	=SUM(I19,SUM(I21:I23))
I28	=+I24+I26
I40	=SUM(I32:I39)
I47	=SUM(I42:I46)
I49	=SUM(I40,I47)
I54	=SUM(I49,SUM(I51:I52))
I57	=IF(I32=0,0,+I2/I32)
I58	=IF(I33=0,0,+I3/I33)
I59	=IF(I34=0,0,+I4/I34)
I60	=IF(I35=0,0,+I5/I35)
I61	=IF(I36=0,0,+I6/I36)
I62	=IF(I37=0,0,+I7/I37)
I63	=IF(I38=0,0,+I8/I38)
I65	=IF(I40=0,0,+I10/I40)
I67	=IF(I42=0,0,+I12/I42)
I68	=IF(I43=0,0,+I13/I43)
I69	=IF(I44=0,0,+I14/I44)
I70	=IF(I45=0,0,+I15/I45)
I72	=IF(I47=0,0,+I17/I47)
I74	=IF(I49=0,0,+I19/I49)
I76	=IF(I51=0,0,+I21/I51)
I77	=IF(I52=0,0,+I22/(I52+#REF!))
I79	=IF(I54=0,0,+I24/I54)
I81	=(SUM($C$24:I$24)/SUM($C$54:I$54))
I82	=(SUM($I$24:I$24)/SUM($I$54:I$54))
I87	=I54/I84
J10	=SUM(J2:J9)
J17	=SUM(J12:J16)
J19	=SUM(J10,J17)
J24	=SUM(J19,SUM(J21:J23))
J28	=+J24+J26
J40	=SUM(J32:J39)
J47	=SUM(J42:J46)
J49	=SUM(J40,J47)
J54	=SUM(J49,SUM(J51:J52))
J57	=IF(J32=0,0,+J2/J32)
J58	=IF(J33=0,0,+J3/J33)
J59	=IF(J34=0,0,+J4/J34)
J60	=IF(J35=0,0,+J5/J35)
J61	=IF(J36=0,0,+J6/J36)
J62	=IF(J37=0,0,+J7/J37)
J63	=IF(J38=0,0,+J8/J38)
J65	=IF(J40=0,0,+J10/J40)
J67	=IF(J42=0,0,+J12/J42)
J68	=IF(J43=0,0,+J13/J43)
J69	=IF(J44=0,0,+J14/J44)
J70	=IF(J45=0,0,+J15/J45)
J72	=IF(J47=0,0,+J17/J47)
J74	=IF(J49=0,0,+J19/J49)
J76	=IF(J51=0,0,+J21/J51)
J77	=IF(J52=0,0,+J22/(J52+#REF!))
J79	=IF(J54=0,0,+J24/J54)
J81	=(SUM($C$24:J$24)/SUM($C$54:J$54))
J82	=(SUM($I$24:J$24)/SUM($I$54:J$54))
J87	=J54/J84
K10	=SUM(K2:K9)
K17	=SUM(K12:K16)
K19	=SUM(K10,K17)
K24	=SUM(K19,SUM(K21:K23))
K28	=+K24+K26
K40	=SUM(K32:K39)
K47	=SUM(K42:K46)
K49	=SUM(K40,K47)
K54	=SUM(K49,SUM(K51:K52))
K57	=IF(K32=0,0,+K2/K32)
K58	=IF(K33=0,0,+K3/K33)
K59	=IF(K34=0,0,+K4/K34)
K60	=IF(K35=0,0,+K5/K35)
K61	=IF(K36=0,0,+K6/K36)
K62	=IF(K37=0,0,+K7/K37)
K63	=IF(K38=0,0,+K8/K38)
K65	=IF(K40=0,0,+K10/K40)
K67	=IF(K42=0,0,+K12/K42)
K68	=IF(K43=0,0,+K13/K43)
K69	=IF(K44=0,0,+K14/K44)
K70	=IF(K45=0,0,+K15/K45)
K72	=IF(K47=0,0,+K17/K47)
K74	=IF(K49=0,0,+K19/K49)
K76	=IF(K51=0,0,+K21/K51)
K77	=IF(K52=0,0,+K22/(K52+#REF!))
K79	=IF(K54=0,0,+K24/K54)
K81	=(SUM($C$24:K$24)/SUM($C$54:K$54))
K82	=(SUM($I$24:K$24)/SUM($I$54:K$54))
K87	=K54/K84
L10	=SUM(L2:L9)
L17	=SUM(L12:L16)
L19	=SUM(L10,L17)
L24	=SUM(L19,SUM(L21:L23))
L28	=+L24+L26
L40	=SUM(L32:L39)
L47	=SUM(L42:L46)
L49	=SUM(L40,L47)
L54	=SUM(L49,SUM(L51:L52))
L57	=IF(L32=0,0,+L2/L32)
L58	=IF(L33=0,0,+L3/L33)
L59	=IF(L34=0,0,+L4/L34)
L60	=IF(L35=0,0,+L5/L35)
L61	=IF(L36=0,0,+L6/L36)
L62	=IF(L37=0,0,+L7/L37)
L63	=IF(L38=0,0,+L8/L38)
L65	=IF(L40=0,0,+L10/L40)
L67	=IF(L42=0,0,+L12/L42)
L68	=IF(L43=0,0,+L13/L43)
L69	=IF(L44=0,0,+L14/L44)
L70	=IF(L45=0,0,+L15/L45)
L72	=IF(L47=0,0,+L17/L47)
L74	=IF(L49=0,0,+L19/L49)
L76	=IF(L51=0,0,+L21/L51)
L77	=IF(L52=0,0,+L22/(L52+#REF!))
L79	=IF(L54=0,0,+L24/L54)
L81	=(SUM($C$24:L$24)/SUM($C$54:L$54))
L82	=(SUM($L$24:L$24)/SUM($L$54:L$54))
L87	=L54/L84
M10	=SUM(M2:M9)
M17	=SUM(M12:M16)
M19	=SUM(M10,M17)
M24	=SUM(M19,SUM(M21:M23))
M28	=+M24+M26
M40	=SUM(M32:M39)
M47	=SUM(M42:M46)
M49	=SUM(M40,M47)
M54	=SUM(M49,SUM(M51:M52))
M57	=IF(M32=0,0,+M2/M32)
M58	=IF(M33=0,0,+M3/M33)
M59	=IF(M34=0,0,+M4/M34)
M60	=IF(M35=0,0,+M5/M35)
M61	=IF(M36=0,0,+M6/M36)
M62	=IF(M37=0,0,+M7/M37)
M63	=IF(M38=0,0,+M8/M38)
M65	=IF(M40=0,0,+M10/M40)
M67	=IF(M42=0,0,+M12/M42)
M68	=IF(M43=0,0,+M13/M43)
M69	=IF(M44=0,0,+M14/M44)
M70	=IF(M45=0,0,+M15/M45)
M72	=IF(M47=0,0,+M17/M47)
M74	=IF(M49=0,0,+M19/M49)
M76	=IF(M51=0,0,+M21/M51)
M77	=IF(M52=0,0,+M22/(M52+#REF!))
M79	=IF(M54=0,0,+M24/M54)
M81	=(SUM($C$24:M$24)/SUM($C$54:M$54))
M82	=(SUM($L$24:M$24)/SUM($L$54:M$54))
M87	=M54/M84
N10	=SUM(N2:N9)
N17	=SUM(N12:N16)
N19	=SUM(N10,N17)
N24	=SUM(N19,SUM(N21:N23))
N28	=+N24+N26
N40	=SUM(N32:N39)
N47	=SUM(N42:N46)
N49	=SUM(N40,N47)
N54	=SUM(N49,SUM(N51:N52))
N57	=IF(N32=0,0,+N2/N32)
N58	=IF(N33=0,0,+N3/N33)
N59	=IF(N34=0,0,+N4/N34)
N60	=IF(N35=0,0,+N5/N35)
N61	=IF(N36=0,0,+N6/N36)
N62	=IF(N37=0,0,+N7/N37)
N63	=IF(N38=0,0,+N8/N38)
N65	=IF(N40=0,0,+N10/N40)
N67	=IF(N42=0,0,+N12/N42)
N68	=IF(N43=0,0,+N13/N43)
N69	=IF(N44=0,0,+N14/N44)
N70	=IF(N45=0,0,+N15/N45)
N72	=IF(N47=0,0,+N17/N47)
N74	=IF(N49=0,0,+N19/N49)
N76	=IF(N51=0,0,+N21/N51)
N77	=IF(N52=0,0,+N22/(N52+#REF!))
N79	=IF(N54=0,0,+N24/N54)
N81	=(SUM($C$24:N$24)/SUM($C$54:N$54))
N82	=(SUM($L$24:N$24)/SUM($L$54:N$54))
N87	=N54/N84
Q2	=SUM(C2:E2)
Q3	=SUM(C3:E3)
Q4	=SUM(C4:E4)
Q5	=SUM(C5:E5)
Q6	=SUM(C6:E6)
Q7	=SUM(C7:E7)
Q8	=SUM(C8:E8)
Q10	=SUM(C10:E10)
Q12	=SUM(C12:E12)
Q13	=SUM(C13:E13)
Q14	=SUM(C14:E14)
Q15	=SUM(C15:E15)
Q17	=SUM(C17:E17)
Q19	=SUM(C19:E19)
Q21	=SUM(C21:E21)
Q22	=SUM(C22:E22)
Q23	=SUM(C23:E23)
Q24	=SUM(C24:E24)
Q26	=SUM(C26:E26)
Q28	=SUM(C28:E28)
Q32	=SUM(C32:E32)
Q33	=SUM(C33:E33)
Q34	=SUM(C34:E34)
Q35	=SUM(C35:E35)
Q36	=SUM(C36:E36)
Q37	=SUM(C37:E37)
Q38	=SUM(C38:E38)
Q40	=SUM(C40:E40)
Q42	=SUM(C42:E42)
Q43	=SUM(C43:E43)
Q44	=SUM(C44:E44)
Q45	=SUM(C45:E45)
Q47	=SUM(C47:E47)
Q49	=SUM(C49:E49)
Q51	=SUM(C51:E51)
Q52	=SUM(C52:E52)
Q54	=SUM(C54:E54)
Q57	=IF(Q32=0,0,+Q2/Q32)
Q58	=IF(Q33=0,0,+Q3/Q33)
Q59	=IF(Q34=0,0,+Q4/Q34)
Q60	=IF(Q35=0,0,+Q5/Q35)
Q61	=IF(Q36=0,0,+Q6/Q36)
Q62	=IF(Q37=0,0,+Q7/Q37)
Q63	=IF(Q38=0,0,+Q8/Q38)
Q65	=IF(Q40=0,0,+Q10/Q40)
Q67	=IF(Q42=0,0,+Q12/Q42)
Q68	=IF(Q43=0,0,+Q13/Q43)
Q69	=IF(Q44=0,0,+Q14/Q44)
Q70	=IF(Q45=0,0,+Q15/Q45)
Q72	=IF(Q47=0,0,+Q17/Q47)
Q74	=IF(Q49=0,0,+Q19/Q49)
Q76	=IF(Q51=0,0,+Q21/Q51)
Q77	=IF(Q52=0,0,+Q22/(Q52+#REF!))
Q79	=IF(Q54=0,0,+Q24/Q54)
R2	=SUM(F2:H2)
R3	=SUM(F3:H3)
R4	=SUM(F4:H4)
R5	=SUM(F5:H5)
R6	=SUM(F6:H6)
R7	=SUM(F7:H7)
R8	=SUM(F8:H8)
R10	=SUM(F10:H10)
R12	=SUM(F12:H12)
R13	=SUM(F13:H13)
R14	=SUM(F14:H14)
R15	=SUM(F15:H15)
R17	=SUM(F17:H17)
R19	=SUM(F19:H19)
R21	=SUM(F21:H21)
R22	=SUM(F22:H22)
R23	=SUM(F23:H23)
R24	=SUM(F24:H24)
R26	=SUM(F26:H26)
R28	=SUM(F28:H28)
R32	=SUM(F32:H32)
R33	=SUM(F33:H33)
R34	=SUM(F34:H34)
R35	=SUM(F35:H35)
R36	=SUM(F36:H36)
R37	=SUM(F37:H37)
R38	=SUM(F38:H38)
R40	=SUM(F40:H40)
R42	=SUM(F42:H42)
R43	=SUM(F43:H43)
R44	=SUM(F44:H44)
R45	=SUM(F45:H45)
R47	=SUM(F47:H47)
R49	=SUM(F49:H49)
R51	=SUM(F51:H51)
R52	=SUM(F52:H52)
R54	=SUM(F54:H54)
R57	=IF(R32=0,0,+R2/R32)
R58	=IF(R33=0,0,+R3/R33)
R59	=IF(R34=0,0,+R4/R34)
R60	=IF(R35=0,0,+R5/R35)
R61	=IF(R36=0,0,+R6/R36)
R62	=IF(R37=0,0,+R7/R37)
R63	=IF(R38=0,0,+R8/R38)
R65	=IF(R40=0,0,+R10/R40)
R67	=IF(R42=0,0,+R12/R42)
R68	=IF(R43=0,0,+R13/R43)
R69	=IF(R44=0,0,+R14/R44)
R70	=IF(R45=0,0,+R15/R45)
R72	=IF(R47=0,0,+R17/R47)
R74	=IF(R49=0,0,+R19/R49)
R76	=IF(R51=0,0,+R21/R51)
R77	=IF(R52=0,0,+R22/(R52+#REF!))
R79	=IF(R54=0,0,+R24/R54)
S2	=SUM(I2:K2)
S3	=SUM(I3:K3)
S4	=SUM(I4:K4)
S5	=SUM(I5:K5)
S6	=SUM(I6:K6)
S7	=SUM(I7:K7)
S8	=SUM(I8:K8)
S10	=SUM(I10:K10)
S12	=SUM(I12:K12)
S13	=SUM(I13:K13)
S14	=SUM(I14:K14)
S15	=SUM(I15:K15)
S17	=SUM(I17:K17)
S19	=SUM(I19:K19)
S21	=SUM(I21:K21)
S22	=SUM(I22:K22)
S23	=SUM(I23:K23)
S24	=SUM(I24:K24)
S26	=SUM(I26:K26)
S28	=SUM(I28:K28)
S32	=SUM(I32:K32)
S33	=SUM(I33:K33)
S34	=SUM(I34:K34)
S35	=SUM(I35:K35)
S36	=SUM(I36:K36)
S37	=SUM(I37:K37)
S38	=SUM(I38:K38)
S40	=SUM(I40:K40)
S42	=SUM(I42:K42)
S43	=SUM(I43:K43)
S44	=SUM(I44:K44)
S45	=SUM(I45:K45)
S47	=SUM(I47:K47)
S49	=SUM(I49:K49)
S51	=SUM(I51:K51)
S52	=SUM(I52:K52)
S54	=SUM(I54:K54)
S57	=IF(S32=0,0,+S2/S32)
S58	=IF(S33=0,0,+S3/S33)
S59	=IF(S34=0,0,+S4/S34)
S60	=IF(S35=0,0,+S5/S35)
S61	=IF(S36=0,0,+S6/S36)
S62	=IF(S37=0,0,+S7/S37)
S63	=IF(S38=0,0,+S8/S38)
S65	=IF(S40=0,0,+S10/S40)
S67	=IF(S42=0,0,+S12/S42)
S68	=IF(S43=0,0,+S13/S43)
S69	=IF(S44=0,0,+S14/S44)
S70	=IF(S45=0,0,+S15/S45)
S72	=IF(S47=0,0,+S17/S47)
S74	=IF(S49=0,0,+S19/S49)
S76	=IF(S51=0,0,+S21/S51)
S77	=IF(S52=0,0,+S22/(S52+#REF!))
S79	=IF(S54=0,0,+S24/S54)
T2	=SUM(L2:N2)
T3	=SUM(L3:N3)
T4	=SUM(L4:N4)
T5	=SUM(L5:N5)
T6	=SUM(L6:N6)
T7	=SUM(L7:N7)
T8	=SUM(L8:N8)
T10	=SUM(L10:N10)
T12	=SUM(L12:N12)
T13	=SUM(L13:N13)
T14	=SUM(L14:N14)
T15	=SUM(L15:N15)
T17	=SUM(L17:N17)
T19	=SUM(L19:N19)
T21	=SUM(L21:N21)
T22	=SUM(L22:N22)
T23	=SUM(L23:N23)
T24	=SUM(L24:N24)
T26	=SUM(L26:N26)
T28	=SUM(L28:N28)
T32	=SUM(L32:N32)
T33	=SUM(L33:N33)
T34	=SUM(L34:N34)
T35	=SUM(L35:N35)
T36	=SUM(L36:N36)
T37	=SUM(L37:N37)
T38	=SUM(L38:N38)
T40	=SUM(L40:N40)
T42	=SUM(L42:N42)
T43	=SUM(L43:N43)
T44	=SUM(L44:N44)
T45	=SUM(L45:N45)
T47	=SUM(L47:N47)
T49	=SUM(L49:N49)
T51	=SUM(L51:N51)
T52	=SUM(L52:N52)
T54	=SUM(L54:N54)
T57	=IF(T32=0,0,+T2/T32)
T58	=IF(T33=0,0,+T3/T33)
T59	=IF(T34=0,0,+T4/T34)
T60	=IF(T35=0,0,+T5/T35)
T61	=IF(T36=0,0,+T6/T36)
T62	=IF(T37=0,0,+T7/T37)
T63	=IF(T38=0,0,+T8/T38)
T65	=IF(T40=0,0,+T10/T40)
T67	=IF(T42=0,0,+T12/T42)
T68	=IF(T43=0,0,+T13/T43)
T69	=IF(T44=0,0,+T14/T44)
T70	=IF(T45=0,0,+T15/T45)
T72	=IF(T47=0,0,+T17/T47)
T74	=IF(T49=0,0,+T19/T49)
T76	=IF(T51=0,0,+T21/T51)
T77	=IF(T52=0,0,+T22/(T52+#REF!))
T79	=IF(T54=0,0,+T24/T54)