Visits from government agencies

Description	Value
Prepared By	IMAN Auditor
Date	03-20-2009
Reviewed By	G. Audit Supervisor
Review Date	02-01-2009
Audit Step	3
Audit Objective	Summarize invoices by state code
Data Source	c:\test\data\EWP.xls
Date Run	04-19-09 17:12:45
Table/WorkSheet	Trans$
Column	Invoice Amount
Command	summary - Summarize amounts
Parameters Used	[State]
First Parameter	(none)
Where	(none)
Second Parameter	1
SQL used	select sum([Invoice Amount]) as [Total], avg([Invoice Amount]) as [Average], min([Invoice Amount]) as [Minimum], max([Invoice Amount]) as [Maximum], count([Invoice Amount]) as [Count], stdev([Invoice Amount]) as [Standard Deviation], [State] from [Trans$] group by [State] ;
Processing status	Normal process - 44 rows
Finding (Condition, Cause, Effect)
Conclusions
Recommendations
Discussed with
Management agrees?
Management comments
Auditor comments

Report Schedule

State	Total	Average	Minimum	Maximum	Count	Standard Deviation
AK	2,146,343.74	4,258.62	-10,410.46	10,335.54	504	4,386.51
AR	212,991.79	4,953.30	-8,368.03	10,251.31	43	4,504.52
AZ	105,261.70	3,508.72	-8,569.90	9,225.20	30	4,135.52
CO	323,639.92	3,946.83	-9,285.83	10,417.74	82	5,032.95
CT	72,849.87	3,642.49	-6,000.00	10,072.15	20	4,729.92
DC	49,124.70	7,017.81	4,192.48	10,422.56	7	2,246.93
DE	20,232.88	5,058.22	951.88	7,364.06	4	2,999.11
GA	686,894.12	4,320.09	-10,000.00	10,468.24	159	4,415.90
HI	35,124.00	3,512.40	-7,564.99	10,452.91	10	6,547.63
IA	138,956.28	5,344.47	-5,088.78	10,095.46	26	3,860.39
ID	150,020.21	4,546.07	-9,435.50	10,075.71	33	3,632.23
IL	492,918.31	4,606.71	-10,000.00	10,372.20	107	4,726.43
IN	112,455.63	4,685.65	-5,000.00	10,473.66	24	4,297.74
KS	42,529.52	4,252.95	-10,070.26	9,344.76	10	5,903.75
KY	296,086.53	3,655.39	-10,000.00	10,460.35	81	5,041.89
LA	443,139.85	3,723.86	-10,000.00	10,456.84	119	4,983.98
MA	568,314.77	4,338.28	-11,000.00	10,464.41	131	4,444.63
MD	234,611.85	4,600.23	-9,003.33	10,262.25	51	4,038.73
ME	32,146.49	2,678.87	-9,100.56	10,342.23	12	5,975.96
State	Total	Average	Minimum	Maximum	Count	Standard Deviation
MI	563,214.78	3,754.77	-10,017.85	10,497.28	150	5,474.91
MN	168,042.53	4,801.22	-5,106.80	9,836.96	35	3,258.33
MO	446,718.79	4,061.08	-10,000.00	10,403.78	110	5,178.28
MS	292,980.72	4,372.85	-5,954.13	10,495.90	67	3,704.75
MT	16,785.47	8,392.74	7,257.13	9,528.34	2	1,605.99
NC	270,758.44	4,297.75	-8,726.51	10,367.44	63	4,705.70
NE	13,422.31	1,917.47	-11,000.00	8,635.84	7	6,467.65
NM	530,605.37	5,253.52	-10,101.96	10,458.30	101	4,198.69
NV	127,996.25	3,878.67	-11,000.00	9,925.10	33	5,073.29
NZ	6,152,552.25	4,308.51	-11,000.00	10,488.86	1,428	4,529.29
OH	679,697.66	4,592.55	-11,000.00	10,475.43	148	4,309.14
OK	293,513.99	4,734.10	-10,389.53	10,341.91	62	4,682.82
OR	76,204.20	5,861.86	890.34	9,865.72	13	3,110.90
PA	1,192,439.67	4,466.07	-11,000.00	10,497.21	267	4,383.42
PR	213,348.52	4,741.08	-3,012.41	9,929.89	45	3,166.35
RI	148,322.31	4,494.62	-6,840.37	10,242.21	33	3,912.09
SC	344,046.56	5,640.11	-10,337.08	10,379.49	61	4,443.59
SD	22,123.85	3,160.55	-886.01	6,810.81	7	2,565.28
TN	408,254.44	4,978.71	-10,000.00	10,466.60	82	3,905.68
UT	1,558,953.11	4,379.08	-10,136.05	10,407.36	356	4,112.81
State	Total	Average	Minimum	Maximum	Count	Standard Deviation
VA	48,496.44	1,865.25	-10,340.46	10,346.50	26	6,097.06
WA	150,737.41	4,567.80	-8,000.00	10,003.31	33	3,734.99
WI	273,477.82	4,143.60	-10,394.28	10,425.72	66	4,508.89
WV	16,691.56	2,781.93	-9,999.06	9,503.34	6	7,537.16
WY	1,578,422.36	4,175.72	-10,062.37	10,494.15	378	4,400.82

Lead Work Sheet

Electronic Workpaper index