Description
Value
Prepared By
IMAN Auditor
Date
04-13-2009
Reviewed By
G. Audit Supervisor
Review Date
02-18-2009
Audit Step
12
Audit Objective
Prepare a schedule of the five assets with the least cost, in ascending order
Data Source
c:\test\data\EWP.xls
Date Run
04-18-09 22:30:49
Table/WorkSheet
fa$
Column
cost
Command
bottomn - Smallest values
Parameters Used
(none)
First Parameter
5
Where
(none)
Second Parameter
(none)
SQL used
select [cost], * from [fa$] order by [cost] asc
Processing status
Normal process - 4064 rows
Finding (Condition, Cause, Effect)
Conclusions
Recommendations
Discussed with
Management agrees?
Management comments
Auditor comments
Report Schedule
cost
TagNo
AD
Replace
Bookval
Salvage
Depr
Life
Location
AcqDate
Accode
DispDate
RepCost
Acquisition
ADATE
-6615
1237
2698.064898
1984
3916.94
1323
539.6129796
8
DSR
9/22/2004
A
-
10000
2593.94
9/22/2004 3:33:40 AM
-1203
3614
7290
361
-6087
241
1458
8
DSR
8/14/2005
A
-
200
-6328
8/14/2005 10:38:30 AM
-31
3501
12.48535323
9
18.51
6
2.497070646
7
DSR
10/12/2006
A
-
0
12.51
10/12/2006 11:55:29 PM
0
3705
2051.164536
1519
3010.84
1012
410.2329073
6
DSR
10/20/2006
A
-
8600
1998.84
10/20/2006 11:33:02 PM
0
4402
1258.271908
936
1860.73
624
251.6543815
5
DSR
4/30/2007
A
-
3200
1236.73
4/30/2007 5:30:41 PM
Lead Work Sheet
Electronic Workpaper index