Sum of every 3rd column as per the month

[manojk71273]

Dear All

I have an excel sheet having data like below

Column A	B	C	D	E	F	G	H	I	J
	Apr				May			Jun
Particular	Name	G	NG	Total	G	NG	Total	G	NG

Now i want a total of Quarter to date and Year to date total on the basis of Month/s

if month is Q1 Apr then Column E , if Month is May then total of column E+H .... for Jun total of column E+H+K and every Qtr the cell reference will change.

for YTD in Apr E in May E+H, in Jun E+H+K in Jul it will be E+H+K+N and so on.......

how can I do it please help,

Thanks in advance.
Manojk.

 

[awoohaw]

But, as a side note.. do you have access to the raw data? What you have here is more a less a complex cross tab report.
I hope your company has this in a flat file format of these columns only:
Category
Product
Type
Month
G
NG
Total (this field may not be needed if it is the sum of G and NG)

If you can find the data in this format then 99.9% of your reporting woes will be solved.

 

[manojk71273]

sample for total of 3rd column.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CJ	CK	CL	CM	CN	CO	CP	CQ	CR	CS	CT	CU	CV	CW	CX	CY	CZ	DA	DB	DC	DD	DE	DF	DG	DH	DI	DJ	DK	DL	DM	DN	DO	DP	DQ	DR	DS	DT	DU	DV	DW	DX	DY	DZ	EA	EB	EC	ED	EE	EF	EG	EH	EI	EJ	EK	EL	EM	EN	EO	EP	EQ	ER	ES	ET	EU	EV	EW	EX	EY	EZ	FA	FB	FC	FD	FE	FF	FG	FH	FI	FJ	FK	FL	FM	FN	FO	FP	FQ	FR	FS	FT	FU	FV	FW	FX	FY	FZ	GA	GB	GC	GD	GE	GF	GG	GH	GI	GJ	GK	GL	GM	GN	GO	GP	GQ	GR	GS	GT	GU	GV	GW	GX	GY	GZ	HA	HB	HC	HD	HE	HF
1																																																																																																																																																																																																										Feb	AI5	BW5	DK5	EY5
2																																							Sale 1																																								Sale 2																																								Sale 3																																								Sale 4																																								Total			Q4	35.00	75.00	115.00	155.00
3		Product	Apr			May			Jun			Jul			Aug			Sep			Oct			Nov			Dec			Jan			Feb			Mar			FY 20-21				Apr			May			Jun			Jul			Aug			Sep			Oct			Nov			Dec			Jan			Feb			Mar			FY 20-21				Apr			May			Jun			Jul			Aug			Sep			Oct			Nov			Dec			Jan			Feb			Mar			FY 20-21				Apr			May			Jun			Jul			Aug			Sep			Oct			Nov			Dec			Jan			Feb			Mar			FY 20-21				Apr			May			Jun			Jul			Aug			Sep			Oct			Nov			Dec			Jan			Feb			Mar			FY 20-21				Month				Quarter				YTD
4	Category		NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total		NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total		NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total		NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total		NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total		Sale 1	Sale 2	Sale 3	Sale 4	Sale 1	Sale 2	Sale 3	Sale 4	Sale 1	Sale 2	Sale 3	Sale 4
5	Catagory1	Product1	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.12	0.12	0.24		0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.12	0.12	0.24		0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.12	0.12	0.24		0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.12	0.12	0.24		0.04	0.04	0.08	0.04	0.04	0.08	0.04	0.04	0.08	0.04	0.04	0.08	0.04	0.04	0.08	0.04	0.04	0.08	0.04	0.04	0.08	0.04	0.04	0.08	0.04	0.04	0.08	0.04	0.04	0.08	0.04	0.04	0.08	0.04	0.04	0.08	0.48	0.48	0.96		0.02	0.02	0.02	0.02	0.06	0.06	0.06	0.06	0.24	0.24	0.24	0.24
6		Grand Total	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.12	0.12	0.24		0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.12	0.12	0.24		0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.12	0.12	0.24		0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.12	0.12	0.24		0.04	0.04	0.08	0.04	0.04	0.08	0.04	0.04	0.08	0.04	0.04	0.08	0.04	0.04	0.08	0.04	0.04	0.08	0.04	0.04	0.08	0.04	0.04	0.08	0.04	0.04	0.08	0.04	0.04	0.08	0.04	0.04	0.08	0.04	0.04	0.08	0.48	0.48	0.96		0.02	0.02	0.02	0.02	0.06	0.06	0.06	0.06	0.24	0.24	0.24	0.24
Sheet1

Cell Formulas
Range	Formula
GU1:GX1	GU1	=ADDRESS(5,(GU2),4)
GV2:GX2	GV2	=+GU2+40
E5,FB5,EY5,EV5,ES5,EP5,EM5,EJ5,EG5,ED5,EA5,DX5,DU5,DN5,DK5,DH5,DE5,DB5,CY5,CV5,CS5,CP5,CM5,CJ5,CG5,BZ5,BW5,BT5,BQ5,BN5,BK5,BH5,BE5,BB5,AY5,AV5,AS5,AL5,AI5,AF5,AC5,Z5,W5,T5,Q5,N5,K5,H5	E5	=C5+D5
AM5:AN5,FC5:FD5,DO5:DP5,CA5:CB5	AM5	=C5+F5+I5+L5+O5+R5+U5+X5+AA5+AD5+AG5+AJ5
AO5,FE5,DQ5,CC5	AO5	=SUM(AM5:AN5)
FG5:GS5	FG5	=+C5+AQ5+CE5+DS5
FG6:GS6,DS6:FE6,CE6:DQ6,AQ6:CC6,C6:AO6	FG6	=SUM(FG5:FG5)
GU5:GX6	GU5	=INDIRECT(LEFT(TEXT(ADDRESS(5,(GU$2),4),0),2)&ROW(),TRUE)
GY5:GY6	GY5	=AF5+AI5+AL5
GZ5:GZ6	GZ5	=BT5+BW5+BZ5
HA5:HA6	HA5	=DH5+DK5+DN5
HB5:HB6	HB5	=EV5+EY5+FB5
HC5:HC6	HC5	=E5+H5+K5+N5+Q5++T5+W5+Z5+AC5+AF5+AI5+AL5
HD5:HD6	HD5	=AS5+AV5+AY5+BB5+BE5++BH5+BK5+BN5+BQ5+BT5+BW5+BZ5
HE5:HE6	HE5	=CG5+CJ5+CM5+CP5+CS5++CV5+CY5+DB5+DE5+DH5+DK5+DN5
HF5:HF6	HF5	=DU5+DX5+EA5+ED5+EG5++EJ5+EM5+EP5+ES5+EV5+EY5+FB5

 

[manojk71273]

Dear All the sample file is uploaded for your reference.

 

[manojk71273]

Please help, the file is uploaded.

 

[manojk71273]

Please help

 

[awoohaw]

Please help

i'll take a look at it this morning.

 

[awoohaw]

@manojk71273 , can you answer my question about if this is your raw data or is a report of someone else's data?

 

[manojk71273]

@manojk71273 , can you answer my question about if this is your raw data or is a report of someone else's data?

I am owner of this data, don't understand this requirement.

 

[awoohaw]

I am owner of this data, don't understand this requirement.

I'm just saying that they way you have put it together is EXTREMELY difficult to do any kind of reporting on other than how you have it entered.
My excel skills are not the greatest, and Power Query I think would a tool that could help with this, but I just do not know it well enough.
You essentially have what I call an ultra complex Cross Tab Report, you have 2 headers rows 2 header columns and 3 different data elements.
What I am doing may not be exactly what you want. I am essentially UNPIVOTING the cross tab (Unpivot is a great tool in Power Query, but I don't know how to do that with so many header types)

Here is what I've come up with, and from this you can create just about any report you can dream of because it is a flat file.
I took your data and created some more rows, and changed your data a little bit.
What you can do with this is use the formulas on the top row and drag them down, but you'll need to do it for the number of columns times the number of rows.
This is a mini, so the bottom 1200 or so rows are not going to be there. But the formulas on the top row will work on a data set of 7 rows.
I know this may be confusing, so please as.

One thing off the bat: is the cell reference that is used to calculated the MOD and INT values in the formulas.
Since the first formula I use is in cell A15... the root lookup reference is (ROW(A15)-15). If your first cell is C25, then you would need adjust it to (Row(C25)-25).

I have to post this in mulitple pieces.

mr excel questions 17.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CJ	CK	CL	CM	CN	CO	CP	CQ	CR	CS	CT	CU	CV	CW	CX	CY	CZ	DA	DB	DC	DD	DE	DF	DG	DH	DI	DJ	DK	DL	DM	DN	DO	DP	DQ	DR	DS	DT	DU	DV	DW	DX	DY	DZ	EA	EB	EC	ED	EE	EF	EG	EH	EI	EJ	EK	EL	EM	EN	EO	EP	EQ	ER	ES	ET	EU	EV	EW	EX	EY	EZ	FA	FB	FC	FD	FE	FF	FG	FH	FI	FJ	FK	FL	FM	FN	FO	FP	FQ	FR	FS	FT	FU	FV	FW	FX	FY	FZ	GA	GB	GC	GD	GE	GF	GG	GH	GI	GJ	GK	GL	GM	GN	GO	GP	GQ	GR	GS	GT	GU	GV	GW	GX	GY	GZ	HA	HB	HC	HD	HE	HF
1																																																																																																																																																																																																										Feb	AI5	BW5	DK5	EY5
2			Sale1																																				Sale 1				Sale2																																				Sale 2				Sale3																																				Sale 3				Sale4																																				Sale 4																																								Total			Q4	35	75	115	155
3		Product	Apr			May			Jun			Jul			Aug			Sep			Oct			Nov			Dec			Jan			Feb			Mar			FY 20-21				Apr			May			Jun			Jul			Aug			Sep			Oct			Nov			Dec			Jan			Feb			Mar			FY 20-21				Apr			May			Jun			Jul			Aug			Sep			Oct			Nov			Dec			Jan			Feb			Mar			FY 20-21				Apr			May			Jun			Jul			Aug			Sep			Oct			Nov			Dec			Jan			Feb			Mar			FY 20-21				Apr			May			Jun			Jul			Aug			Sep			Oct			Nov			Dec			Jan			Feb			Mar			FY 20-21				Month				Quarter				YTD
4	Category		NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total		NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total		NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total		NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total		NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total	NG	G	Total		Sale 1	Sale 2	Sale 3	Sale 4	Sale 1	Sale 2	Sale 3	Sale 4	Sale 1	Sale 2	Sale 3	Sale 4
5	Category1	Product1	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.12	0.24	0.36		0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.12	0.12	0.24		0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.12	0.12	0.24		0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.12	0.12	0.24		0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.48	0.6	1.08		0.03	0.02	0.02	0.02	0.09	0.06	0.06	0.06	0.36	0.24	0.24	0.24
6	Category2	Product1	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.12	0.24	0.36		0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.12	0.12	0.24		0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.12	0.12	0.24		0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.12	0.12	0.24		0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.48	0.6	1.08		0.03	0.02	0.02	0.02	0.09	0.06	0.06	0.06	0.36	0.24	0.24	0.24
Sheet1

Cell Formulas
Range	Formula
GU1:GX1	GU1	=ADDRESS(5,(GU2),4)
GV2:GX2	GV2	=+GU2+40
AL5:AL6,EY5:EY6,EV5:EV6,ES5:ES6,EP5:EP6,EM5:EM6,EJ5:EJ6,EG5:EG6,ED5:ED6,EA5:EA6,DX5:DX6,DU5:DU6,DK5:DK6,DH5:DH6,DE5:DE6,DB5:DB6,CY5:CY6,CV5:CV6,CS5:CS6,CP5:CP6,CM5:CM6,CJ5:CJ6,CG5:CG6,BW5:BW6,BT5:BT6,BQ5:BQ6,BN5:BN6,BK5:BK6,BH5:BH6,BE5:BE6,BB5:BB6,AY5:AY6	AL5	=AJ5+AK5
AM5:AN6,FC5:FD6,DO5:DP6,CA5:CB6	AM5	=C5+F5+I5+L5+O5+R5+U5+X5+AA5+AD5+AG5+AJ5
AO5:AO6,FE5:FE6,DQ5:DQ6,CC5:CC6	AO5	=SUM(AM5:AN5)
FG5:GS6	FG5	=+C5+AQ5+CE5+DS5
GU5:GX6	GU5	=INDIRECT(LEFT(TEXT(ADDRESS(5,(GU$2),4),0),2)&ROW(),TRUE)
GY5:GY6	GY5	=AF5+AI5+AL5
GZ5:GZ6	GZ5	=BT5+BW5+BZ5
HA5:HA6	HA5	=DH5+DK5+DN5
HB5:HB6	HB5	=EV5+EY5+FB5
HC5:HC6	HC5	=E5+H5+K5+N5+Q5++T5+W5+Z5+AC5+AF5+AI5+AL5
HD5:HD6	HD5	=AS5+AV5+AY5+BB5+BE5++BH5+BK5+BN5+BQ5+BT5+BW5+BZ5
HE5:HE6	HE5	=CG5+CJ5+CM5+CP5+CS5++CV5+CY5+DB5+DE5+DH5+DK5+DN5
HF5:HF6	HF5	=DU5+DX5+EA5+ED5+EG5++EJ5+EM5+EP5+ES5+EV5+EY5+FB5

 

[awoohaw]

part 2 of 4:

mr excel questions 17.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CJ	CK	CL	CM	CN	CO	CP	CQ	CR	CS	CT	CU	CV	CW	CX	CY	CZ	DA	DB	DC	DD	DE	DF	DG	DH	DI	DJ	DK	DL	DM	DN	DO	DP	DQ	DR	DS	DT	DU	DV	DW	DX	DY	DZ	EA	EB	EC	ED	EE	EF	EG	EH	EI	EJ	EK	EL	EM	EN	EO	EP	EQ	ER	ES	ET	EU	EV	EW	EX	EY	EZ	FA	FB	FC	FD	FE	FF	FG	FH	FI	FJ	FK	FL	FM	FN	FO	FP	FQ	FR	FS	FT	FU	FV	FW	FX	FY	FZ	GA	GB	GC	GD	GE	GF	GG	GH	GI	GJ	GK	GL	GM	GN	GO	GP	GQ	GR	GS	GT	GU	GV	GW	GX	GY	GZ	HA	HB	HC	HD	HE	HF
7	Category3	Product1	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.12	0.24	0.36		0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.12	0.12	0.24		0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.12	0.12	0.24		0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.12	0.12	0.24		0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.48	0.6	1.08		0.03	0.02	0.02	0.02	0.09	0.06	0.06	0.06	0.36	0.24	0.24	0.24
8	Category4	Product2	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.12	0.24	0.36		0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.12	0.12	0.24		0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.12	0.12	0.24		0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.12	0.12	0.24		0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.48	0.6	1.08		0.03	0.02	0.02	0.02	0.09	0.06	0.06	0.06	0.36	0.24	0.24	0.24
9	Category5	Product2	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.12	0.24	0.36		0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.12	0.12	0.24		0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.12	0.12	0.24		0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.12	0.12	0.24		0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.48	0.6	1.08		0.03	0.02	0.02	0.02	0.09	0.06	0.06	0.06	0.36	0.24	0.24	0.24
10	Category6	Product3	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.01	0.02	0.03	0.12	0.24	0.36		0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.12	0.12	0.24		0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.12	0.12	0.24		0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.01	0.01	0.02	0.12	0.12	0.24		0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.04	0.05	0.09	0.48	0.6	1.08		0.03	0.02	0.02	0.02	0.09	0.06	0.06	0.06	0.36	0.24	0.24	0.24
Sheet1

Cell Formulas
Range	Formula
AL7:AL10,EY7:EY10,EV7:EV10,ES7:ES10,EP7:EP10,EM7:EM10,EJ7:EJ10,EG7:EG10,ED7:ED10,EA7:EA10,DX7:DX10,DU7:DU10,DK7:DK10,DH7:DH10,DE7:DE10,DB7:DB10,CY7:CY10,CV7:CV10,CS7:CS10,CP7:CP10,CM7:CM10,CJ7:CJ10,CG7:CG10,BW7:BW10,BT7:BT10,BQ7:BQ10,BN7:BN10,BK7:BK10	AL7	=AJ7+AK7
AM7:AN10,FC7:FD10,DO7:DP10,CA7:CB10	AM7	=C7+F7+I7+L7+O7+R7+U7+X7+AA7+AD7+AG7+AJ7
AO7:AO10,FE7:FE10,DQ7:DQ10,CC7:CC10	AO7	=SUM(AM7:AN7)
FG7:GS10	FG7	=+C7+AQ7+CE7+DS7
GU7:GX10	GU7	=INDIRECT(LEFT(TEXT(ADDRESS(5,(GU$2),4),0),2)&ROW(),TRUE)
GY7:GY10	GY7	=AF7+AI7+AL7
GZ7:GZ10	GZ7	=BT7+BW7+BZ7
HA7:HA10	HA7	=DH7+DK7+DN7
HB7:HB10	HB7	=EV7+EY7+FB7
HC7:HC10	HC7	=E7+H7+K7+N7+Q7++T7+W7+Z7+AC7+AF7+AI7+AL7
HD7:HD10	HD7	=AS7+AV7+AY7+BB7+BE7++BH7+BK7+BN7+BQ7+BT7+BW7+BZ7
HE7:HE10	HE7	=CG7+CJ7+CM7+CP7+CS7++CV7+CY7+DB7+DE7+DH7+DK7+DN7
HF7:HF10	HF7	=DU7+DX7+EA7+ED7+EG7++EJ7+EM7+EP7+ES7+EV7+EY7+FB7