Fixed Assets

Audit Number: 1074

Fiscal Year Ending 11-30-2008

Lead Work Sheet

Electronic Workpaper index

When certain audit tests are performed, the system can document these results in the work papers as an automatic by-product of performing the tests. These documents can then be edited using Word or other text editor to indicate the test results, conclusions, add tick marks, etc.

The advantages of electronic work papers include the following:

The starting point for the preparation of electronic work papers is to complete the details of the audit tests to be performed. This is done through "fill in the blanks" on an Excel worksheet and includes information such as type of test to be performed, data source, data elements to be tested, etc.

Once the details have been completed, a series of audit tests to be performed by the system can be started by clicking a button on an Excel worksheet. This will cause the system to perform the analysis, document the results and produce any charts of the results, where applicable.

The next step is for the auditor to review the results of the tests, edit the documents to add conclusions, comments, cross-references, etc. and then store the documents, either as a Word document, HTML or converted to Adobe PDF format.

Although the initial format for this project is to use Excel sheets for inputting testing parameters and performing the audit processing, later versions will use a standard Windows GUI.

Currently there are example audit programs for audit tests in the following areas:

Electronic Work Paper Examples
Application Work Papers Example Input Form
Fixed Assets
Input Form
Payroll
Input Form
Procurement cards
Input Form
Accounts payable
Input Form
General Ledger
Input Form
Expense Reports
Input Form
Inventory Cycle
Input Form
Accounts Receivable
Input Form
Revenue Cycle
Input Form
Payments and Purchases
Input Form
DescriptionValue
Prepared By IMAN Auditor
Date 03-25-2009
Reviewed By G. Audit Supervisor
Review Date 02-24-2009
Audit Step20
Audit ObjectivePrepare a schedule of assets with useful lives or depreciation rates beyond set norms
Data Sourcec:\test\data\EWP.xls
Date Run04-18-09 22:30:53
Table/WorkSheetfa$
Column(none)
Commandextract - Extract data based upon criteria specified
Parameters Used(none)
First Parameter(none)
Wherecost > 8000 and life < 6
Second Parameter(none)
SQL usedselect * from [fa$] where cost > 8000 and life < 6
Processing statusNormal process - 261 rows
Finding (Condition, Cause, Effect)  
Conclusions  
Recommendations  
Discussed with  
Management agrees?  
Management comments  
Auditor comments  
Report Schedule


TagNoCostADReplaceBookvalSalvageDeprLifeLocationAcqDateAccodeDispDateRepCostAcquisitionADATE
341181183311.24657224354806.751624662.24931455ABC2/9/2007A-145003182.752/9/2007 9:42:33 PM
396089553641.43855626865313.561791728.28771113ABC12/8/2005A-79003522.5612/8/2005 7:32:10 PM
391495783891.34484828735686.661916778.26896964ABC8/19/2005A-188003770.668/19/2005 3:49:30 AM
281684733437.99371625425035.011695687.59874333ABC11/10/2004A-43003340.0111/10/2004 7:49:55 AM
292297423899.19551829235842.81948779.83910375ABC2/15/2005A-164003894.82/15/2005 1:17:30 PM
479596753894.8227229025780.181935778.96454395ABC9/6/2006A-139003845.189/6/2006 6:23:36 AM
126086283451.62246325885176.381726690.32449264ABC12/20/2004A-120003450.3812/20/2004 8:56:58 AM
125597343904.21499729205829.791947780.84299955ABC4/29/2006A-145003882.794/29/2006 4:08:40 PM
304698073981.05772429425825.941961796.21154484ABC7/14/2005A-114003864.947/14/2005 11:50:43 AM
397884803472.69358325445007.311696694.53871655ABC6/13/2006A-44003311.316/13/2006 11:29:57 AM
316287133527.85815126145185.141743705.57163035ABC2/5/2005A-79003442.142/5/2005 5:24:35 PM
430383143387.10250424944926.91663677.42050074ABC6/6/2005A-148003263.96/6/2005 11:49:14 AM
348394033854.75267228215548.251881770.95053444ABC1/21/2006I-200003667.251/21/2006 2:18:51 PM
424593843825.02449828155558.981877765.00489955ABC4/25/2006A-150003681.984/25/2006 7:16:05 AM
401496423943.63169928935698.371928788.72633993ABC6/19/2006A-118003770.376/19/2006 10:14:12 PM
278691393716.93077627425422.071828743.38615525ABC8/1/2006A-131003594.078/1/2006 8:41:03 AM
147296313885.47919228895745.521926777.09583855ABC8/23/2006A-148003819.528/23/2006 11:01:21 PM
477788553578.93489326565276.071771715.78697855ABC5/11/2005I-190003505.075/11/2005 5:00:56 AM
264792203711.32524727665508.671844742.26504954ABC2/13/2006A-129003664.672/13/2006 7:21:32 AM
TagNoCostADReplaceBookvalSalvageDeprLifeLocationAcqDateAccodeDispDateRepCostAcquisitionADATE
148183943432.77544425184961.221679686.55508875ABC12/12/2006A-149003282.2212/12/2006 4:39:54 AM
289883153359.60394324944955.41663671.92078853ABC11/27/2005A-116003292.411/27/2005 12:58:02 AM
416091423715.73722627435426.261828743.14744523ABC6/10/2005A-47003598.266/10/2005 5:25:52 PM
412986983484.66842726095213.331740696.93368534ABC5/13/2005A-77003473.335/13/2005 6:23:10 PM
233883793357.650625145021.351676671.530125ABC4/2/2007A-143003345.354/2/2007 3:00:14 AM
479098584006.86936629575851.131972801.37387324ABC3/23/2006A-155003879.133/23/2006 8:17:50 AM
511784513406.74644825355044.251690681.34928963ABC8/7/2005A-111003354.258/7/2005 2:59:58 AM
341699174047.00387297558701983809.4007743ABC12/13/2006A-8300388712/13/2006 4:34:00 PM
513292293716.93495227695512.071846743.38699045ABC5/16/2006A-30003666.075/16/2006 9:27:21 PM
344298363945.93611829515890.061967789.18722363ABC12/16/2006A-156003923.0612/16/2006 7:00:42 AM
496389783623.32943426935354.671796724.66588693ABC11/9/2004A-124003558.6711/9/2004 9:40:36 AM
206394033781.84662828215621.151881756.36932554ABC10/30/2004A-188003740.1510/30/2004 8:44:01 PM
432789233641.28327826775281.721785728.25665555ABC4/13/2007A-65003496.724/13/2007 1:33:54 PM
165289393631.37456326825307.631788726.27491265ABC9/8/2006A-42003519.639/8/2006 10:13:43 AM
306782823376.41713624854905.581656675.28342735ABC10/5/2006A-38003249.5810/5/2006 6:34:24 AM
159881893299.1536724574889.851638659.8307345ABC7/20/2006A-152003251.857/20/2006 5:13:09 PM
364893283747.71679927985580.281866749.54335983ABC2/5/2005A-103003714.282/5/2005 8:13:11 AM
324496503889.33454628955760.671930777.86690923ABC6/16/2005A-137003830.676/16/2005 2:14:20 AM
201192413777.18178227725463.821848755.43635645ABC12/8/2006A-73003615.8212/8/2006 5:12:49 PM
231090193641.29694427065377.71804728.25938895ABC12/2/2006A-96003573.712/2/2006 5:57:35 AM
TagNoCostADReplaceBookvalSalvageDeprLifeLocationAcqDateAccodeDispDateRepCostAcquisitionADATE
477685453431.42937925645113.571709686.28587593ABC2/8/2006A-128003404.572/8/2006 3:51:42 PM
399094103839.74668628235570.251882767.94933725ABC7/12/2005A-92003688.257/12/2005 6:49:35 PM
502485843505.80217725755078.21717701.16043535ABC1/29/2006A-79003361.21/29/2006 8:08:41 PM
522888143569.98557226445244.011763713.99711434ABC5/27/2007A-106003481.015/27/2007 5:10:56 AM
329290333665.96213427105367.041807733.19242693ABC3/9/2006A-39003560.043/9/2006 10:12:15 AM
302387483508.85691626245239.141750701.77138333ABC12/15/2005A-152003489.1412/15/2005 7:27:30 PM
301183013331.43435824904969.571660666.28687175ABC2/27/2007A-170003309.572/27/2007 5:57:34 AM
166989493586.74907826855362.251790717.34981574ABC3/22/2007A-40003572.253/22/2007 7:22:19 PM
150097483908.39315429245839.611950781.67863084ABC1/5/2007A-29003889.611/5/2007 4:50:01 PM
212491013668.59847427305432.41820733.71969485ABC6/17/2005A-114003612.46/17/2005 7:57:38 AM
337784463393.18283725345052.821689678.63656755ABC4/25/2006A-116003363.824/25/2006 9:57:14 AM
181886813475.83110926045205.171736695.16622173ABC7/4/2005A-128003469.177/4/2005 6:59:32 PM
452497593943.5880229285815.411952788.7176045ABC8/2/2006A-123003863.418/2/2006 2:34:27 PM
158191527322274618301830747.38320985ABC2/24/2006A-1160002/24/2006 11:42:01 PM
376897693979.15816129315789.841954795.83163224ABC7/4/2006A-165003835.847/4/2006 12:49:40 PM
425589583665.0668926875292.931792733.0133783ABC4/21/2005A-119003500.934/21/2005 3:52:27 AM
149482803376.82229224844903.181656675.36445844ABC3/2/2005A-50003247.183/2/2005 7:59:24 AM
185397804005.56907229345774.431956801.11381443ABC1/16/2005A-60003818.431/16/2005 4:24:07 PM
155280353244.35032324104790.651607648.87006463ABC1/20/2006I-172003183.651/20/2006 11:37:36 AM
459390373656.31388627115380.691807731.26277733ABC9/19/2005A-168003573.699/19/2005 4:10:15 AM
TagNoCostADReplaceBookvalSalvageDeprLifeLocationAcqDateAccodeDispDateRepCostAcquisitionADATE
402389853666.84756226965318.151797733.36951253ABC3/25/2005A-143003521.153/25/2005 10:50:23 PM
376183223356.09554224974965.91664671.21910843ABC5/18/2006A-155003301.95/18/2006 6:46:57 AM
334586513534.44513125955116.551730706.88902625ABC1/10/2007A-85003386.551/10/2007 4:04:12 AM
492993737498281218751875755.28625353ABC3/14/2006A-430003/14/2006 12:07:45 AM
291182763318.46956824834957.531655663.69391355ABC7/7/2005A-113003302.537/7/2005 7:44:07 PM
333287613586.58920226285174.411752717.31784045ABC7/16/2005A-92003422.417/16/2005 8:18:27 AM
318384963453.1998925495042.81699690.6399785ABC11/18/2005A-98003343.811/18/2005 1:47:20 AM
289780023210.89310424014791.111600642.17862075ABC6/29/2005A-84003191.116/29/2005 10:42:58 PM
146186993557.37496226105141.631740711.47499233ABC1/6/2006A-44003401.631/6/2006 8:51:43 PM
486593243816.08282327975507.921865763.21656464ABC8/1/2006A-68003642.928/1/2006 9:57:46 PM
243189783639.32557226935338.671796727.86511454ABC7/25/2006A-29003542.677/25/2006 3:50:00 PM
210897373988.64632629215748.351947797.72926525ABC3/23/2005A-195003801.353/23/2005 10:46:54 AM
367186403492.86902825925147.131728698.57380575ABC4/29/2007I-183003419.134/29/2007 12:55:16 AM
204094103790.32846328235619.671882758.06569265ABC10/9/2004I-204003737.6710/9/2004 1:05:56 AM
453084713395.36892125415075.631694679.07378414ABC3/25/2007A-67003381.633/25/2007 11:08:46 PM
282599604011.12509929885948.871992802.22501995ABC1/8/2005A-66003956.871/8/2005 8:26:12 PM
4672804264342413160816081697.84XSF2/6/2007A6/5/2007170002/6/2007 12:44:48 PM
307891017281273018201820730.01356534ABC1/24/2006A-670001/24/2006 9:11:06 AM
327391183683.38112327355434.621824736.67622464DSR6/9/2006A-107003610.626/9/2006 3:33:32 PM
195194213783.62225928265637.381884756.72445184DSR3/30/2007A-47003753.383/30/2007 11:54:47 PM
TagNoCostADReplaceBookvalSalvageDeprLifeLocationAcqDateAccodeDispDateRepCostAcquisitionADATE
262792783721.53617727835556.461856744.30723533DSR3/28/2005I-201003700.463/28/2005 8:52:25 AM
471186253469.43875925885155.561725693.88775173DSR1/27/2006A-180003430.561/27/2006 5:42:49 AM
384990863721.53114527265364.471817744.3062295DSR10/20/2005A-45003547.4710/20/2005 11:19:21 PM
130080963249.94468624294846.061619649.98893723DSR6/6/2007A-151003227.066/6/2007 1:11:45 AM
302184756780254216951695694.59019345DSR1/3/2006A-300001/3/2006 3:21:04 AM
301893913838.12745228175552.871878767.62549054DSR8/7/2006A-177003674.878/7/2006 3:27:56 PM
463185573449.96956625675107.031711689.99391324DSR4/11/2005A-156003396.034/11/2005 7:33:34 PM
465597493914.70998329255834.291950782.94199655DSR11/8/2006A-190003884.2911/8/2006 3:32:56 PM
287297493967.93311329255781.071950793.58662265DSR5/29/2006A-84003831.075/29/2006 12:35:44 AM
425381243267.86357524374856.141625653.5727153DSR1/22/2007A-76003231.141/22/2007 4:57:02 PM
3420827549152482336016559835DSR7/30/2005A-200017057/30/2005 9:09:09 PM
349898653956.77388629605908.231973791.35477723DSR2/4/2006A-74003935.232/4/2006 7:07:29 AM
364488673558.83019926605308.171773711.76603973DSR5/31/2006A-58003535.175/31/2006 12:34:26 AM
503180743265.81150624224808.191615653.16230124DSR12/15/2005A-54003193.1912/15/2005 11:31:19 AM
340492463702.89121927745543.111849740.57824383DSR7/30/2006A-185003694.117/30/2006 3:22:49 AM
146980393277.74619924124761.251608655.54923975DSR8/14/2006A-133003153.258/14/2006 6:55:16 PM
386091893731.03579727575457.961838746.20715945DSR2/17/2005A-84003619.962/17/2005 9:17:06 PM
128997693909.60046429315859.41954781.92009273DSR7/18/2006A-124003905.47/18/2006 2:15:45 AM
325084023373.12394925215028.881680674.62478975DSR8/10/2005A-49003348.888/10/2005 7:16:10 AM
3058914573162744182918291351.63ABC5/9/2005A6/7/2007180005/9/2005 1:12:43 PM
TagNoCostADReplaceBookvalSalvageDeprLifeLocationAcqDateAccodeDispDateRepCostAcquisitionADATE
244783763428.85022225134947.151675685.77004435ABC10/7/2006A-132003272.1510/7/2006 5:45:41 PM
320687093487.49055526135221.511742697.49811113FGT1/20/2005A-167003479.511/20/2005 10:04:43 AM
292383943415.1278325184978.871679683.02556614FGT10/25/2006A-165003299.8710/25/2006 9:16:40 PM
190480553270.19047224164784.811611654.03809455FGT8/19/2006A-161003173.818/19/2006 5:44:59 AM
175283363359.90168925014976.11667671.98033794FGT1/3/2005A-57003309.11/3/2005 9:44:57 PM
196781523272.74941224464879.251630654.54988243FGT3/21/2005A-98003249.253/21/2005 7:42:46 PM
477999694001.03532229915967.961994800.20706434FGT4/21/2006A-171003973.964/21/2006 11:11:13 PM
317291053646.11176127325458.891821729.22235215FGT1/12/2007A-46003637.891/12/2007 8:57:02 AM
481896103898.53841928835711.461922779.70768383FGT10/3/2005A-39003789.4610/3/2005 1:41:15 AM
405388013554.29075226405246.711760710.85815044ABC3/20/2006A-108003486.713/20/2006 10:46:18 PM
233594053835.12517928225569.871881767.02503583AB4/15/2007A-111003688.874/15/2007 6:40:30 PM
310298951453296884421979290.63AB9/29/2006A-250064639/29/2006 3:45:05 AM
251284743450.21149525425023.791695690.04229915AB7/1/2005A-146003328.797/1/2005 2:46:08 AM
352088203611.82489926465208.181764722.36497974AB3/27/2006A-138003444.183/27/2006 2:41:04 AM
206188673583.3526226605283.651773716.6705244AB10/28/2005A-30003510.6510/28/2005 4:20:18 AM
430488383619.8536826515218.151768723.97073613AB9/5/2005A-29003450.159/5/2005 6:53:43 AM
476495283841.34621228585686.651906768.26924243AB1/1/2007A-189003780.651/1/2007 8:41:01 AM
184891393731.10294427425407.91828746.22058885AB12/16/2006A-80003579.912/16/2006 7:45:06 PM
34769110.993723.84322227335387.151822744.76864444AB5/18/2005A-184003565.155/18/2005 1:18:23 PM
390382963354.06559124894941.931659670.81311825ABC4/8/2006A-88003282.934/8/2006 1:30:20 PM
TagNoCostADReplaceBookvalSalvageDeprLifeLocationAcqDateAccodeDispDateRepCostAcquisitionADATE
324384883469.8874925465018.111698693.9774984ABC5/16/2005A-145003320.115/16/2005 4:15:09 AM
287490603698.94898627185361.051812739.78979724ABC4/1/2006A-52003549.054/1/2006 11:09:11 PM
186093993765.26251328205633.741880753.05250255ABC3/6/2005A-167003753.743/6/2005 9:53:46 AM
517589447155268317891789716.14089340GHF3/7/2006A-610003/7/2006 5:17:25 AM
314596963894.08445629095801.921939778.81689134GHF2/13/2007A-60003862.922/13/2007 9:04:15 PM
362291103676.05410527335433.951822735.21082093GHF12/14/2004A-73003611.9512/14/2004 9:28:11 PM
125689223601.79772326775320.21784720.35954475GHF4/28/2007I-187003536.24/28/2007 3:12:39 PM
266891343744.59745627405389.41827748.91949123GHF6/16/2006A-128003562.46/16/2006 4:23:54 PM
454797793932.44376629345846.561956786.48875323GHF2/19/2006A-28003890.562/19/2006 9:33:23 PM
264080443275.63627824134768.361609655.12725564GHF5/19/2005A-113003159.365/19/2005 3:45:04 AM
390083993365.66761925205033.331680673.13352375GHF5/21/2006A-114003353.335/21/2006 11:44:08 PM
317780383293.19342124114744.811608658.63868424GHF1/13/2007A-90003136.811/13/2007 12:44:17 PM
503088183533.44491826455284.561764706.68898364GHF3/17/2005A-126003520.563/17/2005 1:36:06 PM
412792863720.5251627865565.471857744.10503195GHF1/5/2006A-193003708.471/5/2006 6:38:06 AM
408886193463.32653625865155.671724692.66530713GHF7/25/2005A-92003431.677/25/2005 9:56:19 PM
491485353463.73879525605071.261707692.74775915GHF12/13/2004A-33003364.2612/13/2004 9:12:48 AM
183284143417.6960125244996.31683683.5392024GHF7/7/2006A-86003313.37/7/2006 9:30:42 PM
2820960050692880453119201013.84GHF3/24/2006A-220026113/24/2006 5:26:13 PM
351687863545.98093126365240.021757709.19618623GHF12/3/2005A-82003483.0212/3/2005 2:11:57 AM
422594463835.58235428345610.421889767.11647083GHF1/4/2007A-198003721.421/4/2007 8:03:42 PM
TagNoCostADReplaceBookvalSalvageDeprLifeLocationAcqDateAccodeDispDateRepCostAcquisitionADATE
442684773407.09259425435069.911695681.41851874GHF9/6/2005A-155003374.919/6/2005 12:12:34 PM
502799274069.131729785857.871985813.826343ABC12/5/2004A-69003872.8712/5/2004 1:23:22 PM
301089933686.21307326985306.791799737.24261473ABC5/10/2005A-152003507.795/10/2005 11:06:09 AM
210192113749.35105427635461.651842749.87021084ABC10/24/2006A-151003619.6510/24/2006 9:02:34 PM
437998964038.0139729695857.991979807.60279415ABC3/7/2006A-179003878.993/7/2006 8:38:18 AM
469284973405.20808825495091.791699681.04161755ABC1/1/2007A-94003392.791/1/2007 4:44:25 AM
162797864004.2367729365781.761957800.8473545ABC12/23/2005A-55003824.7612/23/2005 10:19:44 AM
213381863297.49443724564888.511637659.49888743ABC3/5/2006A-59003251.513/5/2006 5:14:16 PM
237391403666.76365427425473.241828733.35273074ABC4/12/2006A-54003645.244/12/2006 12:54:29 AM
241792683730.97290527805537.031854746.1945814ABC12/16/2005A-118003683.0312/16/2005 2:26:15 PM
500287113527.87244926135183.131742705.57448994ABC6/17/2005A-135003441.136/17/2005 6:49:09 PM
370696963943.76784729095752.231939788.75356945ABC4/24/2007A-68003813.234/24/2007 4:35:38 PM
427996233894.22210928875728.781925778.84442183ABC3/18/2005A-72003803.783/18/2005 10:07:23 PM
368492163744.72890627655471.271843748.94578115ABC2/19/2005A-185003628.272/19/2005 8:15:05 PM
459881513322.96202324454828.041630664.59240465ABC11/15/2005A-153003198.0411/15/2005 6:52:37 AM
265387373554.76357426215182.241747710.95271495ABC4/15/2007A-62003435.244/15/2007 7:24:56 AM
134288503602.13420426555247.871770720.42684083ABC6/11/2005A-150003477.876/11/2005 6:27:05 AM
231593133726.43487327945586.571863745.28697454ABC3/9/2007A-70003723.573/9/2007 10:29:19 PM
238192293739.5922527695489.411846747.918455ABC6/7/2007A-24003643.416/7/2007 11:02:46 AM
310599044014.51988929715889.481981802.90397795ABC5/22/2006A-148003908.485/22/2006 7:58:21 AM
TagNoCostADReplaceBookvalSalvageDeprLifeLocationAcqDateAccodeDispDateRepCostAcquisitionADATE
454182703378.22438724814891.781654675.64487745ABC11/17/2005A-129003237.7811/17/2005 9:47:32 PM
164988233617.03505926475205.961765723.40701184ABC5/21/2007A-138003440.965/21/2007 7:10:34 AM
162589353645.54607526805289.451787729.1092155ABC5/27/2007A-67003502.455/27/2007 9:20:36 PM
431784293443.72107125294985.281686688.74421423ABC1/29/2007A-169003299.281/29/2007 12:09:03 AM
129793303823.01963627995506.981866764.60392724ABC3/7/2005A-132003640.983/7/2005 10:31:36 AM
178880673291.42505524204775.571613658.2850115ABC7/14/2005A-78003162.577/14/2005 7:13:07 PM
261794557564283618911891766.21191454ABC10/28/2005A-3500010/28/2005 8:49:52 AM
198991483660.32361427445487.681830732.06472274ABC10/26/2006A-75003657.6810/26/2006 5:41:08 PM
404598103991.36487729435818.641962798.27297543ABC8/3/2006A-202003856.648/3/2006 6:35:15 AM
240095163819.29519628555696.71903763.85903923ABC9/18/2005A-155003793.79/18/2005 3:47:59 AM
525789453662.19792726845282.81789732.43958554ABC7/11/2005A-25003493.87/11/2005 8:20:57 PM
383896723934.78262229025737.221934786.95652445ABC9/6/2006A-125003803.229/6/2006 7:22:32 PM
513494673809.89844528405657.11893761.9796895ABC5/31/2007A-95003764.15/31/2007 6:21:44 AM
158395823913.48731828755668.511916782.69746375ABC2/20/2006A-65003752.512/20/2006 3:27:22 PM
215691113664.96015227335446.041822732.99203053ABC3/27/2005A-66003624.043/27/2005 11:52:52 PM
298594693820.97526828415648.021894764.19505353ABC1/31/2007A-162003754.021/31/2007 3:51:14 AM
336691863698.49997927565487.51837739.69999573ABC12/16/2004A-153003650.512/16/2004 6:57:00 AM
308798994017.45096429705881.551980803.49019285ABC2/27/2006A-92003901.552/27/2006 8:41:53 PM
176485913522.16257925775068.841718704.43251585ABC6/24/2005A-27003350.846/24/2005 5:35:11 PM
358598993999.39631429705899.61980799.87926274ABC1/7/2006A-139003919.61/7/2006 12:14:56 AM
TagNoCostADReplaceBookvalSalvageDeprLifeLocationAcqDateAccodeDispDateRepCostAcquisitionADATE
478294483795.59404828345652.411890759.11880974ABC11/30/2004A-131003762.4111/30/2004 9:37:29 AM
525694643876.71394228395587.291893775.34278835ABC12/30/2005A-162003694.2912/30/2005 11:10:07 PM
367482343331.12953224704902.871647666.22590633ABC7/8/2006A-40003255.877/8/2006 6:02:46 AM
398685863472.25853325765113.741717694.45170653ABC11/1/2004A-52003396.7411/1/2004 2:21:06 PM
484995423827.42857428635714.571908765.48571493ABC7/13/2006A-185003806.577/13/2006 8:28:14 PM
208193843835.50491128155548.51877767.10098214ABC9/22/2005A-140003671.59/22/2005 12:28:15 PM
315291353689.74843727405445.251827737.94968745ABC9/8/2006A-99003618.259/8/2006 4:12:32 PM
176592303724.30546727695505.691846744.86109354ABC11/6/2006A-44003659.6911/6/2006 11:48:17 PM
122698914032.4595929675858.541978806.49191815ABC7/22/2006A-139003880.547/22/2006 7:23:42 PM
363287993548.02931326405250.971760709.60586265ABC10/7/2006A-108003490.9710/7/2006 4:14:24 AM
367787953541.46555326385253.531759708.29311063ABC4/16/2006A-83003494.534/16/2006 10:52:42 PM
354091023730.32907827315371.671820746.06581554ABC12/8/2006A-170003551.6712/8/2006 1:15:27 PM
310999483991.06242329845956.941990798.21248474ABC2/21/2005A-171003966.942/21/2005 9:32:29 AM
177687603579.28290826285180.721752715.85658165ABC9/25/2006A-110003428.729/25/2006 11:07:16 AM
175397133951.92624429145761.071943790.38524875ABC3/3/2007A-136003818.073/3/2007 9:03:06 PM
262598094018.78315429435790.221962803.75663085ABC9/11/2006A-108003828.229/11/2006 2:13:27 AM
252399974019.16396729995977.841999803.83279344ABC11/28/2006A-148003978.8411/28/2006 7:47:55 AM
252992183713.20147127655504.81844742.64029424ABC10/4/2004A-34003660.810/4/2004 4:12:50 AM
308498123973.27304629445838.731962794.65460925JHT3/16/2006A-44003876.733/16/2006 6:48:30 AM
198586003514.73920325805085.261720702.94784063JHT12/27/2006A-114003365.2612/27/2006 11:37:14 AM
TagNoCostADReplaceBookvalSalvageDeprLifeLocationAcqDateAccodeDispDateRepCostAcquisitionADATE
224281963303.47441324594892.531639660.69488265JHT10/26/2005A-91003253.5310/26/2005 11:58:09 AM
276886373479.05351825915157.951727695.81070375ABC8/23/2005A-61003430.958/23/2005 7:11:38 PM
346499637970298919931993816.58509645ABC4/15/2006A-280004/15/2006 11:06:32 PM
264489063599.73137626725306.271781719.94627533ABC10/13/2004A-60003525.2710/13/2004 6:13:08 PM
255989923610.64310926985381.361798722.12862173ABC3/10/2005A-32003583.363/10/2005 11:32:50 AM
463697683957.73213229305810.271954791.54642645ABC8/16/2005A-170003856.278/16/2005 6:01:31 PM
124380413269.29533924124771.71608653.85906795ABC12/16/2004A-65003163.712/16/2004 5:13:47 AM
460293563827.36997228075528.631871765.47399443ABC8/17/2005A-77003657.638/17/2005 9:03:00 AM
280890563680.44642127175375.551811736.08928425ABC12/4/2005I-195003564.5512/4/2005 7:06:39 AM
360491093649.34286227335459.661822729.86857235ABC9/9/2006A-147003637.669/9/2006 6:52:36 AM
464682333375.37550524704857.621647675.07510094ABC3/14/2007A-64003210.623/14/2007 10:55:23 PM
425299774014.1014429935962.91995802.82028814ABC4/2/2005A-82003967.94/2/2005 2:42:29 PM
357390723644.78175927225427.221814728.95635193ABC5/14/2006A-93003613.225/14/2006 3:30:33 AM
489689753597.33805826925377.661795719.46761164ABC2/28/2006I-189003582.662/28/2006 3:43:58 PM
472081213322.42541724364798.571624664.48508344ABC4/5/2006A-29003174.574/5/2006 6:58:27 PM
362483813380.74657125145000.251676676.14931423ABC5/9/2006A-155003324.255/9/2006 7:35:49 PM
161383643397.83753225094966.161673679.56750643ABC10/27/2005A-34003293.1610/27/2005 6:33:44 PM
153282456596247416491649665.38571624ABC2/7/2006A-1320002/7/2006 7:25:04 AM
3636980878462942196219621110.83ABC2/6/2005A6/6/2007200002/6/2005 7:56:12 AM
486097957836293819591959797.7545475ABC3/5/2006A-250003/5/2006 11:58:55 PM
TagNoCostADReplaceBookvalSalvageDeprLifeLocationAcqDateAccodeDispDateRepCostAcquisitionADATE
280186103486.84227225835123.161722697.36845445ABC11/9/2005A-146003401.1611/9/2005 2:03:44 AM
430085053439.37117925525065.631701687.87423595ABC12/13/2005A-48003364.6312/13/2005 3:14:40 AM
429485983501.91106825795096.091720700.38221365ABC5/1/2005A-121003376.095/1/2005 6:12:08 PM
461095763850.8732528735725.131915770.17465014ABC7/27/2006A-63003810.137/27/2006 6:09:43 PM
2750833865422501179616681308.45ABC3/2/2005A-19001283/2/2005 6:28:19 AM
446289433651.56369926835291.441789730.31273974ABC8/30/2005I-193003502.448/30/2005 1:41:45 PM
451788103585.05263626435224.951762717.01052723ABC2/10/2005A-128003462.952/10/2005 4:56:30 PM
464781883285.96698824564902.031638657.19339754ABC6/18/2006A-46003264.036/18/2006 8:18:19 AM
503488463620.16058426545225.841769724.03211694ABC3/5/2007A-178003456.843/5/2007 4:36:37 PM
394394593858.54739128385600.451892771.70947824ABC12/26/2004A-165003708.4512/26/2004 5:21:34 PM
434498173967.11487729455849.891963793.42297555ABC6/22/2006A-192003886.896/22/2006 9:17:01 AM
515381263279.93015824384846.071625655.98603155ABC2/21/2007A-61003221.072/21/2007 8:41:57 PM
400786203476.20167325865143.81724695.24033463ABC7/8/2006A-75003419.87/8/2006 7:37:18 AM
412084373425.38531725315011.611687685.07706344ABC12/23/2006A-60003324.6112/23/2006 5:13:22 PM
480280423217.98741824134824.011608643.59748354ABC3/2/2006A-67003216.013/2/2006 6:37:49 PM
473883853374.70764925165010.291677674.94152993ABC4/12/2006A-118003333.294/12/2006 4:48:05 PM
138199694076.24503129915892.751994815.24900625ABC12/11/2006A-149003898.7512/11/2006 2:20:33 AM
508790693653.79100827215415.211814730.75820163ABC9/2/2005A-90003601.219/2/2005 8:49:45 PM
512998133927.17053129445885.831963785.43410614ABC9/1/2005A-62003922.839/1/2005 2:57:37 PM
328695763898.90090728735677.11915779.78018135ABC11/21/2005A-148003762.111/21/2005 5:50:33 PM
TagNoCostADReplaceBookvalSalvageDeprLifeLocationAcqDateAccodeDispDateRepCostAcquisitionADATE
210689203583.28809526765336.711784716.65761893ABC3/28/2007A-150003552.713/28/2007 1:27:39 PM
307781093293.67442324334815.331622658.73488464ABC8/9/2005A-117003193.338/9/2005 12:00:57 PM
254894333788.8449828305644.161887757.76899594ABC10/23/2006A-104003757.1610/23/2006 4:01:13 AM
377980923306.74745124284785.251618661.34949024ABC10/7/2006A-70003167.2510/7/2006 11:11:17 AM
469591213676.59040127365444.411824735.31808025ABC12/7/2005A-84003620.4112/7/2005 7:26:21 AM
326794583868.40182328375589.61892773.68036463ABC10/25/2006A-67003697.610/25/2006 2:11:21 AM
161481203297.15870724364822.841624659.43174135ABC1/6/2005A-53003198.841/6/2005 8:29:41 PM
322983633403.05369425094959.951673680.61073874ABC2/25/2005A-91003286.952/25/2005 3:07:33 AM
187184663415.23513525405050.761693683.04702693ABC3/24/2005A-49003357.763/24/2005 1:35:32 AM
427687223509.82943926175212.171744701.96588795ABC11/15/2004A-78003468.1711/15/2004 9:30:14 PM
479898213986.85047129465834.151964797.37009424ABC10/28/2005A-130003870.1510/28/2005 3:54:28 PM
185292593752.42436527785506.581852750.4848734ABC5/10/2007A-127003654.585/10/2007 10:28:06 PM
509891493747.9947227455401.011830749.59894395ABC12/2/2006A-132003571.0112/2/2006 4:23:53 PM
136896064836288247701921967.23ABC7/31/2005A-230028497/31/2005 1:14:18 PM
180692047363276118411841680.65ABC11/27/2005A6/5/20071900011/27/2005 11:52:25 PM
518689653620.64638826905344.351793724.12927765ABC4/26/2007A-172003551.354/26/2007 11:51:43 AM
234097863982.48529329365803.511957796.49705854ABC5/3/2007A-62003846.515/3/2007 2:15:47 PM
375882153307.79760524644907.21643661.55952094ABC8/23/2005A-126003264.28/23/2005 5:09:31 AM
151497013954.95192929105746.051940790.99038573ABC8/16/2006A-168003806.058/16/2006 3:36:27 PM
278988143527.22319926445286.781763705.44463993ABC8/3/2005A-165003523.788/3/2005 3:59:53 AM
TagNoCostADReplaceBookvalSalvageDeprLifeLocationAcqDateAccodeDispDateRepCostAcquisitionADATE
519480533294.6136224164758.391611658.9227243ABC5/27/2005A-130003147.395/27/2005 10:51:28 PM
352883583419.93020525074938.071672683.98604114ABC2/15/2007A 76003266.072/15/2007 10:31:46 PM


Lead Work Sheet

Electronic Workpaper index