Description
Value
Prepared By
IMAN Auditor
Date
03-08-2009
Reviewed By
G. Audit Supervisor
Review Date
03-08-2009
Audit Step
31
Audit Objective
Prepare a schedule of all acquisitions made between 11-2-2005 and 11-17-2005
Data Source
c:\test\data\EWP.xls
Date Run
04-18-09 22:31:03
Table/WorkSheet
fa$
Column
acqdate
Command
daterange - Check for transactions between two dates specified
Parameters Used
(none)
First Parameter
11-2-2005
Where
(none)
Second Parameter
11-17-2005
SQL used
select [acqdate], * from [fa$] where [acqdate] between #11-2-2005# and #11-17-2005#
Processing status
Normal process - 65 rows
Finding (Condition, Cause, Effect)
Conclusions
Recommendations
Discussed with
Management agrees?
Management comments
Auditor comments
Report Schedule
acqdate
TagNo
Cost
AD
Replace
Bookval
Salvage
Depr
Life
Location
Accode
DispDate
RepCost
Acquisition
ADATE
11/7/2005
5213
6369
2600.450771
1911
3768.55
1274
520.0901541
6
ABC
I
-
13800
2494.55
11/7/2005 6:40:14 PM
11/14/2005
4879
9558
3880.380127
2867
5677.62
1912
776.0760255
8
ABC
A
-
17300
3765.62
11/14/2005 11:40:36 AM
11/8/2005
1880
398
160.5424154
119
237.46
80
32.10848307
3
ABC
A
-
400
157.46
11/8/2005 4:21:21 PM
11/10/2005
1502
6299
2555.755115
1890
3743.24
1260
511.1510229
11
ABC
A
-
3000
2483.24
11/10/2005 2:54:58 PM
11/14/2005
3916
3537
1442.460679
1061
2094.54
707
288.4921358
6
ABC
A
-
2200
1387.54
11/14/2005 3:41:13 PM
11/3/2005
4093
6450
5160
1935
1290
1290
524.6504921
11
ABC
A
-
9000
0
11/3/2005 4:23:23 AM
11/10/2005
2623
552
223.1025937
166
328.9
110
44.62051873
10
ABC
A
-
1000
218.9
11/10/2005 1:00:51 AM
11/2/2005
1766
4131
1673.815085
1239
2457.18
826
334.7630169
9
ABC
A
-
6500
1631.18
11/2/2005 6:44:45 AM
11/14/2005
3085
1428
9321
428
-7893
286
1864.2
11
ABC
A
-
300
-8179
11/14/2005 10:26:19 AM
11/13/2005
2993
4157
1686.326846
1247
2470.67
831
337.2653691
12
ABC
A
-
3200
1639.67
11/13/2005 6:27:38 PM
11/2/2005
2158
7866
3178.912628
2360
4687.09
1573
635.7825256
11
ABC
A
-
13800
3114.09
11/2/2005 5:02:32 PM
11/7/2005
4167
4708
1921.287859
1412
2786.71
942
384.2575718
8
ABC
A
-
7100
1844.71
11/7/2005 2:16:11 PM
11/13/2005
3313
3740
1518.056528
1122
2221.94
748
303.6113055
8
ABC
A
-
5600
1473.94
11/13/2005 4:06:27 PM
11/9/2005
2604
7153
2875.743277
2146
4277.26
1431
575.1486555
12
ABC
A
-
13100
2846.26
11/9/2005 10:03:58 PM
11/7/2005
2906
4687.99
1908.341189
1406
2779.65
938
381.6682378
11
ABC
A
-
5300
1841.65
11/7/2005 9:39:33 AM
11/12/2005
3899
2357
947.6502087
707
1409.35
471
189.5300417
12
ABC
A
-
3900
938.35
11/12/2005 7:14:30 AM
11/15/2005
4525
4960
2029.855655
1488
2930.14
992
405.9711309
10
ABC
A
-
9200
1938.14
11/15/2005 9:49:03 AM
11/8/2005
5208
8045
3288.315813
2414
4756.68
1609
657.6631625
8
EFR
A
-
10300
3147.68
11/8/2005 5:42:13 PM
11/2/2005
4819
8914
7327
2674
1587
1783
1465.4
10
EFR
A
-
2200
-196
11/2/2005 8:11:33 AM
acqdate
TagNo
Cost
AD
Replace
Bookval
Salvage
Depr
Life
Location
Accode
DispDate
RepCost
Acquisition
ADATE
11/4/2005
1230
497
398
149
99
99
39.7750944
11
ABC
A
-
700
0
11/4/2005 12:03:09 PM
11/10/2005
4718
3769
1515.933293
1131
2253.07
754
303.1866585
11
DSR
A
-
4000
1499.07
11/10/2005 3:12:54 PM
11/13/2005
2399
2467
993.40307
740
1473.6
493
198.680614
10
DSR
A
-
4400
980.6
11/13/2005 12:40:54 AM
11/2/2005
1505
4083
1661.142961
1225
2421.86
817
332.2285922
7
ABC
A
-
3300
1604.86
11/2/2005 4:00:10 PM
11/9/2005
1664
6543
2674.083275
1963
3868.92
1309
534.816655
12
FGT
A
-
6300
2559.92
11/9/2005 4:59:50 AM
11/16/2005
3202
851
348.2020892
255
502.8
170
69.64041785
9
AB
A
-
1300
332.8
11/16/2005 9:12:02 AM
11/9/2005
1400
4131
1684.346126
1239
2446.65
826
336.8692252
7
AB
A
-
4700
1620.65
11/9/2005 2:08:45 PM
11/4/2005
4611
4366
1784.557693
1310
2581.44
873
356.9115386
5
AB
A
-
3700
1708.44
11/4/2005 7:44:30 PM
11/16/2005
2425
3704
1483.388092
1111
2220.61
741
296.6776183
9
AB
A
-
3000
1479.61
11/16/2005 4:00:56 PM
11/17/2005
1473
9442
3865.067988
2833
5576.93
1888
773.0135977
10
AB
A
-
16000
3688.93
11/17/2005 6:09:48 AM
11/2/2005
1878
1793
725.3388961
538
1067.66
359
145.0677792
10
ABC
A
-
900
708.66
11/2/2005 7:02:03 PM
11/3/2005
4406
471
192.4103081
141
278.59
94
38.48206161
78
GHF
A
-
500
184.59
11/3/2005 12:43:31 AM
11/8/2005
4430
9430
3864.438763
2829
5565.56
1886
772.8877527
6
GHF
A
-
11700
3679.56
11/8/2005 8:44:23 AM
11/7/2005
1996
3234
1317.67899
970
1916.32
647
263.5357979
4
GHF
A
-
5700
1269.32
11/7/2005 12:47:34 PM
11/2/2005
2140
3474
1423.525283
1042
2050.47
695
284.7050566
8
GHF
A
-
3900
1355.47
11/2/2005 6:29:17 PM
11/3/2005
5261
4873
1985.86554
1462
2887.13
975
397.1731079
12
GHF
A
-
5900
1912.13
11/3/2005 5:52:43 PM
11/16/2005
1947
2420
985.0897811
726
1434.91
484
197.0179562
12
ABC
A
-
1400
950.91
11/16/2005 9:27:03 PM
11/15/2005
4598
8151
3322.962023
2445
4828.04
1630
664.5924046
5
ABC
A
-
15300
3198.04
11/15/2005 6:52:37 AM
11/4/2005
2175
2329
934.2958876
699
1394.7
466
186.8591775
10
ABC
A
-
2000
928.7
11/4/2005 8:38:09 AM
11/17/2005
4541
8270
3378.224387
2481
4891.78
1654
675.6448774
5
ABC
A
-
12900
3237.78
11/17/2005 9:47:32 PM
acqdate
TagNo
Cost
AD
Replace
Bookval
Salvage
Depr
Life
Location
Accode
DispDate
RepCost
Acquisition
ADATE
11/15/2005
2370
4702
1893.66474
1411
2808.34
940
378.732948
7
ABC
A
-
6800
1868.34
11/15/2005 4:10:32 AM
11/6/2005
1564
1121
452.1527405
336
668.85
224
90.43054811
11
ABC
A
-
700
444.85
11/6/2005 5:04:19 PM
11/6/2005
5021
1121
452.1527405
336
668.85
224
90.43054811
11
ABC
A
-
700
444.85
11/6/2005 5:04:19 PM
11/10/2005
3295
1390
563.0481334
417
826.95
278
112.6096267
3
ABC
A
-
1100
548.95
11/10/2005 4:07:53 PM
11/14/2005
5192
3149
1262.495328
945
1886.5
630
252.4990655
8
ABC
A
-
1100
1256.5
11/14/2005 10:42:13 PM
11/17/2005
3878
5975
2438.532892
1792
3536.47
1195
487.7065784
4
ABC
A
-
7800
2341.47
11/17/2005 10:50:39 AM
11/13/2005
4619
1211
496.2787935
363
714.72
242
99.25575871
3
ABC
A
-
1200
472.72
11/13/2005 12:37:36 PM
11/8/2005
1703
3106
1254.038258
932
1851.96
621
250.8076517
8
ABC
A
-
2800
1230.96
11/8/2005 6:13:15 PM
11/11/2005
3254
7398
6022
2219
1376
1480
1204.4
4
ABC
A
-
1600
-104
11/11/2005 7:38:53 PM
11/11/2005
1771
6440
2590.869904
1932
3849.13
1288
518.1739809
9
ABC
A
-
8000
2561.13
11/11/2005 9:42:00 PM
11/6/2005
5144
8291
3365.081775
2487
4925.92
1658
673.0163549
12
ABC
A
-
8500
3267.92
11/6/2005 10:59:12 AM
11/4/2005
5099
7313
2943.376773
2194
4369.62
1463
588.6753545
9
JHT
A
-
10400
2906.62
11/4/2005 5:09:07 AM
11/6/2005
3642
1389
559.9251996
417
829.07
278
111.9850399
8
ABC
A
-
2700
551.07
11/6/2005 12:02:22 AM
11/13/2005
3594
9490
3886.393998
2847
5603.61
1898
777.2787996
12
ABC
A
-
9000
3705.61
11/13/2005 5:54:30 AM
11/14/2005
2319
4735
1922.981039
1420
2812.02
947
384.5962078
10
ABC
A
-
2200
1865.02
11/14/2005 4:13:14 AM
11/9/2005
2801
8610
3486.842272
2583
5123.16
1722
697.3684544
5
ABC
A
-
14600
3401.16
11/9/2005 2:03:44 AM
11/3/2005
4332
9586
3864.620767
2876
5721.38
1917
772.9241533
6
ABC
I
-
20500
3804.38
11/3/2005 9:48:27 AM
11/12/2005
4527
5746
2339.868175
1724
3406.13
1149
467.973635
8
ABC
A
-
6800
2257.13
11/12/2005 11:38:37 AM
11/5/2005
2836
2050
831.2757556
615
1218.72
410
166.2551511
11
ABC
A
-
1700
808.72
11/5/2005 2:23:29 PM
11/10/2005
3390
9819
3940.430779
2946
5878.57
1964
788.0861558
6
ABC
A
-
17100
3914.57
11/10/2005 12:53:37 PM
acqdate
TagNo
Cost
AD
Replace
Bookval
Salvage
Depr
Life
Location
Accode
DispDate
RepCost
Acquisition
ADATE
11/11/2005
2663
4692
1897.326894
1408
2794.67
938
379.4653787
4
ABC
A
-
9600
1856.67
11/11/2005 10:45:46 PM
11/9/2005
1254
7192
2879.001374
2158
4313
1438
575.8002747
10
ABC
A
-
3500
2875
11/9/2005 11:58:14 PM
11/10/2005
4034
7630
3062.766653
2289
4567.23
1526
612.5533305
7
ABC
A
-
7200
3041.23
11/10/2005 1:18:13 PM
11/16/2005
1378
5823
2380.535017
1747
3442.46
1165
476.1070035
3
ABC
A
-
10100
2277.46
11/16/2005 10:03:27 AM
11/14/2005
5151
2126
861.6819177
638
1264.32
425
172.3363835
6
ABC
A
-
1000
839.32
11/14/2005 8:52:27 AM
11/9/2005
3076
9194
3742.881118
2758
5451.12
1839
748.5762235
11
ABC
I
-
20000
3612.12
11/9/2005 7:07:17 AM
Lead Work Sheet
Electronic Workpaper index
