I am exporting several sets of data from sql via a web app to Excel. Is it possible to format this data. In particular I would like to use the Subtotal function in Excel using sum at each change in Shift Set. Below is an example of what the spreadsheet looks like. In this case I would like columns Employees through Sat to be summed twice: once for shit set 6 and once for shift set 7. ScheduleHeaderID Date TotalEmployees TotalShifts DisplayName Minimum Maximum NeededMon NeededTues NeededWed 288 6/4/2010 9:14 57 251 6/4/2010 - 57 emps 51 62 40 45 38 Shift Set Shift ID Employees SUN MON TUE WED THU FRI SAT 6 155 14 14 14 14 0 0 14 0 6 136 17 0 0 17 17 17 17 0 6 162 5 5 5 5 0 5 5 0 6 152 9 9 9 0 9 9 9 0 6 171 12 12 12 12 12 12 0 0 7 155 14 14 14 14 0 0 14 0 7 136 17 0 0 17 17 17 17 0 7 162 5 5 5 5 0 5 5 0 7 152 9 9 9 0 9 9 9 0 7 171 12 12 12 12 12 12 0 0

Answer

Fromatting Export to Excel from web app/sql

Rodney Johnson

14y

2.2k

I am exporting several sets of data from sql via a web app to Excel. Is it possible to format this data. In particular I would like to use the "Subtotal" function in Excel using "sum" at each change in Shift Set. Below is an example of what the spreadsheet looks like. In this case I would like columns "Employees" through "Sat" to be summed twice: once for shit set 6 and once for shift set 7.

ScheduleHeaderID	Date	TotalEmployees	TotalShifts	DisplayName	Minimum	Maximum	NeededMon	NeededTues	NeededWed
288	6/4/2010 9:14	57	251	6/4/2010 - 57 emps	51	62	40	45	38

Shift Set	Shift ID	Employees	SUN	MON	TUE	WED	THU	FRI	SAT
6	155	14	14	14	14	0	0	14	0
6	136	17	0	0	17	17	17	17	0
6	162	5	5	5	5	0	5	5	0
6	152	9	9	9	0	9	9	9	0
6	171	12	12	12	12	12	12	0	0
7	155	14	14	14	14	0	0	14	0
7	136	17	0	0	17	17	17	17	0
7	162	5	5	5	5	0	5	5	0
7	152	9	9	9	0	9	9	9	0
7	171	12	12	12	12	12	12	0	0