Excel Exporting Template

Using template to create excel report

customerName	productName	productLine	orderDay	orderMonth	orderYear	orderQuarter	dollar_sales
Vitachrome Inc.	1937 Lincoln Berline	Vintage Cars	10	1	2003	Q1	3,726
Vitachrome Inc.	1936 Mercedes-Benz 500K Special Roadster	Vintage Cars	10	1	2003	Q1	1,768
Baane Mini Imports	1952 Alpine Renault 1300	Classic Cars	29	1	2003	Q1	5,572
Baane Mini Imports	1962 LanciaA Delta 16V	Classic Cars	29	1	2003	Q1	5,026
Baane Mini Imports	1958 Setra Bus	Trucks and Buses	29	1	2003	Q1	3,284
Baane Mini Imports	1940 Ford Pickup Truck	Trucks and Buses	29	1	2003	Q1	3,308
Baane Mini Imports	1926 Ford Fire Engine	Trucks and Buses	29	1	2003	Q1	1,283
Baane Mini Imports	1913 Ford Model T Speedster	Vintage Cars	29	1	2003	Q1	2,489
Baane Mini Imports	1934 Ford V8 Coupe	Vintage Cars	29	1	2003	Q1	2,164
Baane Mini Imports	18th Century Vintage Horse Carriage	Vintage Cars	29	1	2003	Q1	2,173
Baane Mini Imports	1917 Maxwell Touring Car	Vintage Cars	29	1	2003	Q1	3,970
Baane Mini Imports	1940s Ford truck	Trucks and Buses	29	1	2003	Q1	3,531
Baane Mini Imports	1939 Cadillac Limousine	Vintage Cars	29	1	2003	Q1	1,671
Baane Mini Imports	1962 Volkswagen Microbus	Trucks and Buses	29	1	2003	Q1	3,864
Baane Mini Imports	1936 Chrysler Airflow	Vintage Cars	29	1	2003	Q1	2,216
Baane Mini Imports	1980Ã¢â‚¬â„¢s GM Manhattan Express	Trucks and Buses	29	1	2003	Q1	2,866
Baane Mini Imports	1996 Peterbilt 379 Stake Bed with Outrigger	Trucks and Buses	29	1	2003	Q1	2,851
Baane Mini Imports	1982 Camaro Z28	Classic Cars	29	1	2003	Q1	3,951
Euro+ Shopping Channel	1969 Corvair Monza	Classic Cars	31	1	2003	Q1	4,469
Euro+ Shopping Channel	1957 Chevy Pickup	Trucks and Buses	31	1	2003	Q1	4,567
Euro+ Shopping Channel	1998 Chrysler Plymouth Prowler	Classic Cars	31	1	2003	Q1	3,262
Euro+ Shopping Channel	1964 Mercedes Tour Bus	Trucks and Buses	31	1	2003	Q1	3,559
Euro+ Shopping Channel	1992 Ferrari 360 Spider red	Classic Cars	31	1	2003	Q1	3,817
Euro+ Shopping Channel	1970 Triumph Spitfire	Classic Cars	31	1	2003	Q1	4,530
Euro+ Shopping Channel	1970 Dodge Coronet	Classic Cars	31	1	2003	Q1	1,821
Euro+ Shopping Channel	1958 Chevy Corvette Limited Edition	Classic Cars	31	1	2003	Q1	1,338
Euro+ Shopping Channel	1992 Porsche Cayenne Turbo Silver	Classic Cars	31	1	2003	Q1	2,768
Euro+ Shopping Channel	1954 Greyhound Scenicruiser	Trucks and Buses	31	1	2003	Q1	1,818
Euro+ Shopping Channel	1950's Chicago Surface Lines Streetcar	Trains	31	1	2003	Q1	2,771
Euro+ Shopping Channel	Diamond T620 Semi-Skirted Tanker	Trucks and Buses	31	1	2003	Q1	3,781
Euro+ Shopping Channel	1962 City of Detroit Streetcar	Trains	31	1	2003	Q1	1,706
Danish Wholesale Imports	1972 Alfa Romeo GTA	Classic Cars	11	2	2003	Q1	6,392
Danish Wholesale Imports	2001 Ferrari Enzo	Classic Cars	11	2	2003	Q1	8,435
Danish Wholesale Imports	1969 Ford Falcon	Classic Cars	11	2	2003	Q1	4,115
Danish Wholesale Imports	1903 Ford Model A	Vintage Cars	11	2	2003	Q1	3,005
Danish Wholesale Imports	Collectable Wooden Train	Trains	11	2	2003	Q1	3,334
Danish Wholesale Imports	1904 Buick Runabout	Vintage Cars	11	2	2003	Q1	3,095
Danish Wholesale Imports	18th century schooner	Ships	11	2	2003	Q1	5,073
Danish Wholesale Imports	1912 Ford Model T Delivery Wagon	Vintage Cars	11	2	2003	Q1	3,232
Danish Wholesale Imports	1940 Ford Delivery Sedan	Vintage Cars	11	2	2003	Q1	3,774
Danish Wholesale Imports	The Schooner Bluenose	Ships	11	2	2003	Q1	2,214
Danish Wholesale Imports	The Mayflower	Ships	11	2	2003	Q1	2,512
Danish Wholesale Imports	The USS Constitution Ship	Ships	11	2	2003	Q1	1,882
Danish Wholesale Imports	The Titanic	Ships	11	2	2003	Q1	3,594
Danish Wholesale Imports	The Queen Mary	Ships	11	2	2003	Q1	2,185
Danish Wholesale Imports	Pont Yacht	Ships	11	2	2003	Q1	1,119
Rovelli Gifts	1980s Black Hawk Helicopter	Planes	17	2	2003	Q1	4,825
Rovelli Gifts	P-51-D Mustang	Planes	17	2	2003	Q1	2,757
Rovelli Gifts	1999 Yamaha Speed Boat	Ships	17	2	2003	Q1	3,315
Rovelli Gifts	1941 Chevrolet Special Deluxe Cabriolet	Vintage Cars	17	2	2003	Q1	3,863

customerName	{{all}}	Q1	Q2	Q3	Q4
Vitachrome Inc.	72497.64	5494.78	22602.36	0	44400.5
Baane Mini Imports	104224.79	50218.95	0	0	54005.84
Euro+ Shopping Channel	820689.54	285274.59	249673.72	64949.38	220791.85
Danish Wholesale Imports	129085.12	53959.21	54561.05	0	20564.86
Rovelli Gifts	127529.69	52151.81	0	0	75377.88

productName	{{all}}	Q1	Q2	Q3	Q4
1937 Lincoln Berline	102563.52	21151.12	21166.56	19598.65	40647.19
1936 Mercedes-Benz 500K Special Roadster	46078.29	12146.66	8092.53	7590.47	18248.63
1952 Alpine Renault 1300	190017.96	43938.1	34943.71	33460.91	77675.24
1962 LanciaA Delta 16V	123123.01	32472.36	22874.64	19918.52	47857.49
1958 Setra Bus	119085.25	27629.37	23291.46	20586.1	47578.32

dollar_sales - sum		2004			2005		Total
dollar_sales - sum		Q3	Q4	Total	Q1	Total	Total
AV Stores, Co.	Classic Cars		34737.87	34737.87			34737.87
	Ships		19186.06	19186.06			19186.06
	Trains		7873.58	7873.58			7873.58
	Vintage Cars		38186.89	38186.89			38186.89
	Total		99984.4	99984.4			99984.4
Alpha Cognac	Ships				12432.32	12432.32	12432.32
Alpha Cognac	Total				12432.32	12432.32	12432.32
Amica Models & Co.	Classic Cars	26424.11		26424.11			26424.11
	Ships	6251.22		6251.22			6251.22
	Trains	2018.72		2018.72			2018.72
	Trucks and Buses	2352		2352			2352
	Vintage Cars	45177.18		45177.18			45177.18
	Total	82223.23		82223.23			82223.23
Anna's Decorations, Ltd	Classic Cars				18187.89	18187.89	18187.89
	Trucks and Buses				27396.76	27396.76	27396.76
	Vintage Cars				11347.65	11347.65	11347.65
	Total				56932.3	56932.3	56932.3
Atelier graphique	Motorcycles	6066.78		6066.78			6066.78
	Vintage Cars		1676.14	1676.14			1676.14
	Total	6066.78	1676.14	7742.92			7742.92
Total		88290.01	101660.54	189950.55	69364.62	69364.62	259315.17

Excel Exporting Template

Description