{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Interject_LastPulledValues","Depr Summary","FAR Dep Summary","FAR 04.30.2023","Bud Capital Input","Pre Acquisition Assets"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":3,"defined_names":24,"comments":2,"pivot_tables":1},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Interject_LastPulledValues","index":0,"n_rows":2,"n_cols":16,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Interject_LastPulledValues_BalanceRange",null,null,null,null,null,null,null,null,null,"Interject_LastPulledValues_DescriptionRange",null,null,null,null,"Interject_LastPulledValues_LastChangeGUID"]
["KeyValue","FullAccount","Period","Year","Source","Company","Currency","Version","Balance",null,"KeyValue","SegmentValue","SegmentNumber","Description",null,"Interject_LastPulledValues_PreviousLastChangeGUID"]

{"sheet":"Depr Summary","index":1,"n_rows":52,"n_cols":35,"rows_kept":52,"cut":false,"hidden":false,"merged":[[4,27,4,34],[1,6,1,7],[4,0,4,7],[26,8,27,8],[4,9,4,16],[26,17,27,17],[4,18,4,25]]}
["Peninsula Sanitation"]
["Depreciation & Average Investment Summary"]
["2023-04-30"]
[]
["Pre-Acquisition Assets 11/1/2021",null,null,null,null,null,null,null,null,"Assets PIS 11/1/2021 and Beyond",null,null,null,null,null,null,null,null,"Budgeted Capital 05/1/2023 and Beyond",null,null,null,null,null,null,null,null,"Combined Summary - This Section to Proforma"]
[null,null,null,null,null,"Beginning","Ending","Average",null,null,null,null,null,null,"Beginning","Ending","Average",null,null,null,null,null,null,"Beginning","Ending","Average",null,null,null,null,null,null,"Beginning","Ending","Average"]
[null,"Cost","Salvage","Depr","Test Year","Accum Depr","Accum Depr","Investment",null,null,"Cost","Salvage","Depr","Test Year","Accum Depr","Accum Depr","Investment",null,null,"Cost","Salvage","Depr","Test Year","Accum Depr","Accum Depr","Investment",null,null,"Cost","Salvage","Depr","Test Year","Accum Depr","Accum Depr","Investment"]
[null,null,null,"Cost","Depr","2022-05-01",{"$f":"+F8+364","v":"2023-04-30"},{"$f":"G8","v":"2023-04-30"},null,null,null,null,"Cost","Depr",{"$f":"F8","v":"2022-05-01"},{"$f":"G8","v":"2023-04-30"},{"$f":"H8","v":"2023-04-30"},null,null,null,null,"Cost","Depr",{"$f":"O8","v":"2022-05-01"},{"$f":"P8","v":"2023-04-30"},{"$f":"Q8","v":"2023-04-30"},null,null,null,null,"Cost","Depr",{"$f":"O8","v":"2022-05-01"},{"$f":"P8","v":"2023-04-30"},{"$f":"Q8","v":"2023-04-30"}]
["Trucks",null,null,null,null,null,null,null,null,"Trucks",null,null,null,null,null,null,null,null,"Trucks",null,null,null,null,null,null,null,null,"Trucks"]
[]
["Garbage Trucks",{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A11,'Pre Acquisition Assets'!M:M)","v":1878229},0,{"$f":"+B11-C11","v":1878229},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A11,'Pre Acquisition Assets'!Q:Q)","v":129680},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A11,'Pre Acquisition Assets'!V:V)","v":1352702.6190476385},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A11,'Pre Acquisition Assets'!Z:Z)","v":1498697.9523809697},{"$f":"+SUMIF('Pre Acquisition Assets'!C:C,A11,'Pre Acquisition Assets'!AA:AA)","v":379531.04761903058},null,"Garbage Trucks",{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J11,'FAR Dep Summary'!$B$24:$B$33)","v":1525},0,{"$f":"+K11-L11","v":1525},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J11,'FAR Dep Summary'!$C$24:$C$33)","v":508.33333333333326},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J11,'FAR Dep Summary'!$D$24:$D$33)","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J11,'FAR Dep Summary'!$E$24:$E$33)","v":508.33333333333326},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J11,'FAR Dep Summary'!$F$24:$F$33)","v":1016.6666666666667},null,"Garbage Trucks",{"$f":"+SUMIF('Bud Capital Input'!$L$57:$L$71,$S11,'Bud Capital Input'!M$57)*M71","v":0},0,{"$f":"+T11-U11","v":0},0,0,0,0,null,{"$f":"+J11","v":"Garbage Trucks"},{"$f":"+B11+K11+T11","v":1879754},{"$f":"+C11+L11","v":0},{"$f":"+D11+M11+V11","v":1879754},{"$f":"+E11+N11+W11","v":130188.33333333333},{"$f":"+F11+O11+X11","v":1352702.6190476385},{"$f":"+G11+P11+Y11","v":1499206.2857143029},{"$f":"+H11+Q11+Z11","v":380547.71428569726}]
[]
["Roll-off Truck",{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A13,'Pre Acquisition Assets'!M:M)","v":852532},0,{"$f":"+B13-C13","v":852532},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A13,'Pre Acquisition Assets'!Q:Q)","v":71493.142857142855},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A13,'Pre Acquisition Assets'!V:V)","v":625903.79285714962},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A13,'Pre Acquisition Assets'!Z:Z)","v":697670.28571429243},{"$f":"+SUMIF('Pre Acquisition Assets'!C:C,A13,'Pre Acquisition Assets'!AA:AA)","v":154861.71428570757},null,"Roll-off Truck",{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J13,'FAR Dep Summary'!$B$24:$B$33)","v":74064.44},0,{"$f":"+K13-L13","v":74064.44},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J13,'FAR Dep Summary'!$C$24:$C$33)","v":10580.634285714286},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J13,'FAR Dep Summary'!$D$24:$D$33)","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J13,'FAR Dep Summary'!$E$24:$E$33)","v":10580.634285714286},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J13,'FAR Dep Summary'!$F$24:$F$33)","v":63483.805714285714},null,"Roll-off Truck",{"$f":"+'Bud Capital Input'!M58","v":105157},0,{"$f":"+T13-U13","v":105157},{"$f":"+'Bud Capital Input'!Q58","v":15022.428571428571},0,{"$f":"+'Bud Capital Input'!Q58","v":15022.428571428571},{"$f":"+V13-Y13","v":90134.571428571435},null,{"$f":"+J13","v":"Roll-off Truck"},{"$f":"+B13+K13+T13","v":1031753.44},{"$f":"+C13+L13","v":0},{"$f":"+D13+M13+V13","v":1031753.44},{"$f":"+E13+N13+W13","v":97096.205714285708},{"$f":"+F13+O13+X13","v":625903.79285714962},{"$f":"+G13+P13+Y13","v":723273.3485714352},{"$f":"+H13+Q13+Z13","v":308480.09142856469}]
[]
["Container Delivery",{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A15,'Pre Acquisition Assets'!M:M)","v":0},0,{"$f":"+B15-C15","v":0},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A15,'Pre Acquisition Assets'!Q:Q)","v":0},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A15,'Pre Acquisition Assets'!V:V)","v":0},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A15,'Pre Acquisition Assets'!Z:Z)","v":0},{"$f":"+SUMIF('Pre Acquisition Assets'!C:C,A15,'Pre Acquisition Assets'!AA:AA)","v":0},null,"Container Delivery",{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J15,'FAR Dep Summary'!$B$24:$B$33)","v":0},0,{"$f":"+K15-L15","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J15,'FAR Dep Summary'!$C$24:$C$33)","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J15,'FAR Dep Summary'!$D$24:$D$33)","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J15,'FAR Dep Summary'!$E$24:$E$33)","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J15,'FAR Dep Summary'!$F$24:$F$33)","v":0},null,"Container Delivery",{"$f":"+SUMIF('Bud Capital Input'!$L$57:$L$71,$S15,'Bud Capital Input'!M$57)*M75","v":0},0,{"$f":"+T15-U15","v":0},0,0,0,0,null,{"$f":"+J15","v":"Container Delivery"},{"$f":"+B15+K15+T15","v":0},{"$f":"+C15+L15","v":0},{"$f":"+D15+M15+V15","v":0},{"$f":"+E15+N15+W15","v":0},{"$f":"+F15+O15+X15","v":0},{"$f":"+G15+P15+Y15","v":0},{"$f":"+H15+Q15+Z15","v":0}]
[]
["Total Trucks",{"$f":"SUM(B11:B16)","v":2730761},0,2730761,201173.14285714284,1978606.4119047881,2196368.2380952621,534392.76190473814,null,"Total Trucks",{"$f":"SUM(K11:K16)","v":75589.440000000002},0,75589.440000000002,11088.96761904762,0,11088.96761904762,64500.472380952378,null,"Total Trucks",{"$f":"SUM(T11:T16)","v":105157},0,105157,15022.428571428571,0,15022.428571428571,90134.571428571435,null,"Total Trucks",{"$f":"SUM(AC11:AC16)","v":2911507.44},0,2911507.44,227284.53904761904,1978606.4119047881,2222479.6342857382,689027.80571426195]
[null,{"$f":"+'Pre Acquisition Assets'!O55-'Depr Summary'!B17","v":22198}]
["Containers",null,null,null,null,null,null,null,null,"Containers",null,null,null,null,null,null,null,null,"Containers",null,null,null,null,null,null,null,null,"Containers"]
["Garbage Carts",{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A20,'Pre Acquisition Assets'!M:M)","v":559875},0,{"$f":"+B20-C20","v":559875},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A20,'Pre Acquisition Assets'!Q:Q)","v":31958.6},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A20,'Pre Acquisition Assets'!V:V)","v":365084.96666667005},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A20,'Pre Acquisition Assets'!Z:Z)","v":398107.40000000293},{"$f":"+SUMIF('Pre Acquisition Assets'!C:C,A20,'Pre Acquisition Assets'!AA:AA)","v":161767.59999999701},null,"Garbage Carts",{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J20,'FAR Dep Summary'!$B$24:$B$33)","v":42895.740000000005},0,{"$f":"+K20-L20","v":42895.740000000005},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J20,'FAR Dep Summary'!$C$24:$C$33)","v":6127.9628571428575},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J20,'FAR Dep Summary'!$D$24:$D$33)","v":1531.9907142857155},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J20,'FAR Dep Summary'!$E$24:$E$33)","v":7659.953571428573},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J20,'FAR Dep Summary'!$F$24:$F$33)","v":35235.786428571431},null,"Garbage Carts",{"$f":"+'Bud Capital Input'!O60","v":52100},0,{"$f":"+T20-U20","v":52100},{"$f":"+'Bud Capital Input'!Q60","v":7442.8571428571431},0,{"$f":"+W20+X20","v":7442.8571428571431},{"$f":"+'Bud Capital Input'!S60","v":44657.142857142855},null,{"$f":"+J20","v":"Garbage Carts"},{"$f":"+B20+K20+T20","v":654870.74},{"$f":"+C20+L20","v":0},{"$f":"+D20+M20+V20","v":654870.74},{"$f":"+E20+N20+W20","v":45529.42},{"$f":"+F20+O20+X20","v":366616.95738095575},{"$f":"+G20+P20+Y20","v":413210.21071428864},{"$f":"+H20+Q20+Z20","v":241660.52928571129}]
[]
["Automated Toter Garbage",{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A22,'Pre Acquisition Assets'!M:M)","v":0},0,{"$f":"+B22-C22","v":0},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A22,'Pre Acquisition Assets'!Q:Q)","v":0},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A22,'Pre Acquisition Assets'!V:V)","v":0},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A22,'Pre Acquisition Assets'!Z:Z)","v":0},{"$f":"+SUMIF('Pre Acquisition Assets'!C:C,A22,'Pre Acquisition Assets'!AA:AA)","v":0},null,"Automated Toter Garbage",{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J22,'FAR Dep Summary'!$B$24:$B$33)","v":0},0,{"$f":"+K22-L22","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J22,'FAR Dep Summary'!$C$24:$C$33)","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J22,'FAR Dep Summary'!$D$24:$D$33)","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J22,'FAR Dep Summary'!$E$24:$E$33)","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J22,'FAR Dep Summary'!$F$24:$F$33)","v":0},null,"Automated Toter Garbage",{"$f":"+SUMIF('Bud Capital Input'!$L$57:$L$71,$S22,'Bud Capital Input'!M$57)*M82","v":0},0,{"$f":"+T22-U22","v":0},0,0,0,0,null,{"$f":"+J22","v":"Automated Toter Garbage"},{"$f":"+B22+K22+T22","v":0},{"$f":"+C22+L22","v":0},{"$f":"+D22+M22+V22","v":0},{"$f":"+E22+N22+W22","v":0},{"$f":"+F22+O22+X22","v":0},{"$f":"+G22+P22+Y22","v":0},{"$f":"+H22+Q22+Z22","v":0}]
[]
["Automated Toter Garbage - Comm",{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A24,'Pre Acquisition Assets'!M:M)","v":0},0,{"$f":"+B24-C24","v":0},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A24,'Pre Acquisition Assets'!Q:Q)","v":0},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A24,'Pre Acquisition Assets'!V:V)","v":0},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A24,'Pre Acquisition Assets'!Z:Z)","v":0},{"$f":"+SUMIF('Pre Acquisition Assets'!C:C,A24,'Pre Acquisition Assets'!AA:AA)","v":0},null,"Garbage Carts - Comm",{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J24,'FAR Dep Summary'!$B$24:$B$33)","v":0},0,{"$f":"+K24-L24","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J24,'FAR Dep Summary'!$C$24:$C$33)","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J24,'FAR Dep Summary'!$D$24:$D$33)","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J24,'FAR Dep Summary'!$E$24:$E$33)","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J24,'FAR Dep Summary'!$F$24:$F$33)","v":0},null,"Garbage Carts - Comm",{"$f":"+SUMIF('Bud Capital Input'!$L$57:$L$71,$S24,'Bud Capital Input'!M$57)*M84","v":0},0,{"$f":"+T24-U24","v":0},0,0,0,0,null,{"$f":"+J24","v":"Garbage Carts - Comm"},{"$f":"+B24+K24+T24","v":0},{"$f":"+C24+L24","v":0},{"$f":"+D24+M24+V24","v":0},{"$f":"+E24+N24+W24","v":0},{"$f":"+F24+O24+X24","v":0},{"$f":"+G24+P24+Y24","v":0},{"$f":"+H24+Q24+Z24","v":0}]
[]
["Drop Boxes",{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A26,'Pre Acquisition Assets'!M:M)","v":156174},0,{"$f":"+B26-C26","v":156174},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A26,'Pre Acquisition Assets'!Q:Q)","v":3210},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A26,'Pre Acquisition Assets'!V:V)","v":145206.50000000049},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A26,'Pre Acquisition Assets'!Z:Z)","v":148416.50000000049},{"$f":"+SUMIF('Pre Acquisition Assets'!C:C,A26,'Pre Acquisition Assets'!AA:AA)","v":7757.4999999995125},null,"Drop Boxes",{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J26,'FAR Dep Summary'!$B$24:$B$33)","v":40198.080000000002},0,{"$f":"+K26-L26","v":40198.080000000002},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J26,'FAR Dep Summary'!$C$24:$C$33)","v":2812.4016666666666},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J26,'FAR Dep Summary'!$D$24:$D$33)","v":6449.26},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J26,'FAR Dep Summary'!$E$24:$E$33)","v":9261.6616666666669},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J26,'FAR Dep Summary'!$F$24:$F$33)","v":30936.418333333335},null,"Drop Boxes",{"$f":"+'Bud Capital Input'!O59","v":32900},0,{"$f":"+T26-U26","v":32900},{"$f":"+'Bud Capital Input'!Q59","v":2741.6666666666665},0,{"$f":"+W26+X26","v":2741.6666666666665},{"$f":"+'Bud Capital Input'!S59","v":30158.333333333332},null,{"$f":"+J26","v":"Drop Boxes"},{"$f":"+B26+K26+T26","v":229272.08000000002},{"$f":"+C26+L26","v":0},{"$f":"+D26+M26+V26","v":229272.08000000002},{"$f":"+E26+N26+W26","v":8764.0683333333327},{"$f":"+F26+O26+X26","v":151655.7600000005},{"$f":"+G26+P26+Y26","v":160419.8283333338},{"$f":"+H26+Q26+Z26","v":68852.251666666183}]
[null,null,null,null,null,null,null,null,"+",null,null,null,null,null,null,null,null,"="]
[]
["Total Cont, Carts,Totes",{"$f":"SUM(B20:B28)","v":716049},0,716049,35168.6,510291.46666667052,546523.9000000034,169525.09999999651,null,"Total Cont, Carts,Totes",{"$f":"SUM(K20:K28)","v":83093.820000000007},0,83093.820000000007,8940.3645238095232,7981.2507142857157,16921.615238095241,66172.204761904766,null,"Total Cont, Carts,Totes",{"$f":"SUM(T20:T28)","v":85000},0,85000,10184.523809523809,0,10184.523809523809,74815.476190476184,null,"Total Cont, Carts,Totes",{"$f":"SUM(AC20:AC28)","v":884142.82000000007},0,884142.82000000007,54293.488333333327,518272.71738095628,573630.03904762247,310512.78095237748]
[]
["Service Equipment",{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A31,'Pre Acquisition Assets'!M:M)","v":0},0,{"$f":"+B31-C31","v":0},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A31,'Pre Acquisition Assets'!Q:Q)","v":0},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A31,'Pre Acquisition Assets'!V:V)","v":0},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A31,'Pre Acquisition Assets'!Z:Z)","v":0},{"$f":"+SUMIF('Pre Acquisition Assets'!C:C,A31,'Pre Acquisition Assets'!AA:AA)","v":0},null,"Service Equipment",{"$f":"IFERROR(VLOOKUP($J31,'FAR Dep Summary'!$A$25:$F$32,2,FALSE),0)","v":0},0,{"$f":"+K31-L31","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J31,'FAR Dep Summary'!$C$24:$C$33)","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J31,'FAR Dep Summary'!$D$24:$D$33)","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J31,'FAR Dep Summary'!$E$24:$E$33)","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J31,'FAR Dep Summary'!$F$24:$F$33)","v":0},null,"Service Equipment",{"$f":"IFERROR(VLOOKUP($J31,'FAR Dep Summary'!$A$25:$F$32,2,FALSE),0)","v":0},0,{"$f":"+T31-U31","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J31,'FAR Dep Summary'!$C$24:$C$33)","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J31,'FAR Dep Summary'!$D$24:$D$33)","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J31,'FAR Dep Summary'!$E$24:$E$33)","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J31,'FAR Dep Summary'!$F$24:$F$33)","v":0},null,{"$f":"+J31","v":"Service Equipment"},{"$f":"+B31+K31+T31","v":0},{"$f":"+C31+L31","v":0},{"$f":"+D31+M31+V31","v":0},{"$f":"+E31+N31+W31","v":0},{"$f":"+F31+O31+X31","v":0},{"$f":"+G31+P31+Y31","v":0},{"$f":"+H31+Q31+Z31","v":0}]
[]
["Service Truck",{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A33,'Pre Acquisition Assets'!M:M)","v":22198},0,{"$f":"+B33-C33","v":22198},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A33,'Pre Acquisition Assets'!Q:Q)","v":0},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A33,'Pre Acquisition Assets'!V:V)","v":21343.416666666781},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A33,'Pre Acquisition Assets'!Z:Z)","v":22198},{"$f":"+SUMIF('Pre Acquisition Assets'!C:C,A33,'Pre Acquisition Assets'!AA:AA)","v":0},null,"Service Truck",{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J33,'FAR Dep Summary'!$B$24:$B$33)","v":47517.68},0,{"$f":"+K33-L33","v":47517.68},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J33,'FAR Dep Summary'!$C$24:$C$33)","v":9503.5360000000001},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J33,'FAR Dep Summary'!$D$24:$D$33)","v":4693.05666666672},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J33,'FAR Dep Summary'!$E$24:$E$33)","v":14196.59266666672},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J33,'FAR Dep Summary'!$F$24:$F$33)","v":33321.087333333278},null,"Service Truck",{"$f":"+SUMIF('Bud Capital Input'!$L$57:$L$71,$S33,'Bud Capital Input'!M$57)*M93","v":0},0,{"$f":"+T33-U33","v":0},0,0,0,0,null,{"$f":"+J33","v":"Service Truck"},{"$f":"+B33+K33+T33","v":69715.679999999993},{"$f":"+C33+L33","v":0},{"$f":"+D33+M33+V33","v":69715.679999999993},{"$f":"+E33+N33+W33","v":9503.5360000000001},{"$f":"+F33+O33+X33","v":26036.473333333503},{"$f":"+G33+P33+Y33","v":36394.592666666722},{"$f":"+H33+Q33+Z33","v":33321.087333333278}]
[]
["Shop Equipment",{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A35,'Pre Acquisition Assets'!M:M)","v":27219},0,{"$f":"+B35-C35","v":27219},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A35,'Pre Acquisition Assets'!Q:Q)","v":0},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A35,'Pre Acquisition Assets'!V:V)","v":27219},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A35,'Pre Acquisition Assets'!Z:Z)","v":27219},{"$f":"+SUMIF('Pre Acquisition Assets'!C:C,A35,'Pre Acquisition Assets'!AA:AA)","v":0},null,"Shop Equipment",{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J35,'FAR Dep Summary'!$B$24:$B$33)","v":111922.44000000002},0,{"$f":"+K35-L35","v":111922.44000000002},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J35,'FAR Dep Summary'!$C$24:$C$33)","v":17146.597666666668},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J35,'FAR Dep Summary'!$D$24:$D$33)","v":2875.6500000006936},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J35,'FAR Dep Summary'!$E$24:$E$33)","v":20022.247666667365},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J35,'FAR Dep Summary'!$F$24:$F$33)","v":91900.192333332641},null,"Shop Equipment",{"$f":"+SUMIF('Bud Capital Input'!$L$57:$L$71,$S35,'Bud Capital Input'!M$57)*M95","v":0},0,{"$f":"+T35-U35","v":0},0,0,0,0,null,{"$f":"+J35","v":"Shop Equipment"},{"$f":"+B35+K35+T35","v":139141.44},{"$f":"+C35+L35","v":0},{"$f":"+D35+M35+V35","v":139141.44},{"$f":"+E35+N35+W35","v":17146.597666666668},{"$f":"+F35+O35+X35","v":30094.650000000693},{"$f":"+G35+P35+Y35","v":47241.247666667361},{"$f":"+H35+Q35+Z35","v":91900.192333332641}]
[]
["Office Equipment",{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A37,'Pre Acquisition Assets'!M:M)","v":45545},0,{"$f":"+B37-C37","v":45545},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A37,'Pre Acquisition Assets'!Q:Q)","v":0},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A37,'Pre Acquisition Assets'!V:V)","v":45545},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A37,'Pre Acquisition Assets'!Z:Z)","v":45545},{"$f":"+SUMIF('Pre Acquisition Assets'!C:C,A37,'Pre Acquisition Assets'!AA:AA)","v":0},null,"Office Equipment",{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J37,'FAR Dep Summary'!$B$24:$B$33)","v":7105.7300000000005},0,{"$f":"+K37-L37","v":7105.7300000000005},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J37,'FAR Dep Summary'!$C$24:$C$33)","v":2035.1013333333331},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J37,'FAR Dep Summary'!$D$24:$D$33)","v":449.21605555571199},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J37,'FAR Dep Summary'!$E$24:$E$33)","v":2484.3173888890451},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J37,'FAR Dep Summary'!$F$24:$F$33)","v":4621.4126111109545},null,"Office Equipment",{"$f":"+SUMIF('Bud Capital Input'!$L$57:$L$71,$S37,'Bud Capital Input'!M$57)*M97","v":0},0,{"$f":"+T37-U37","v":0},0,0,0,0,null,{"$f":"+J37","v":"Office Equipment"},{"$f":"+B37+K37+T37","v":52650.73},{"$f":"+C37+L37","v":0},{"$f":"+D37+M37+V37","v":52650.73},{"$f":"+E37+N37+W37","v":2035.1013333333331},{"$f":"+F37+O37+X37","v":45994.216055555713},{"$f":"+G37+P37+Y37","v":48029.317388889045},{"$f":"+H37+Q37+Z37","v":4621.4126111109545}]
[]
["Leasehold Improvements",{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A39,'Pre Acquisition Assets'!M:M)","v":16871},0,{"$f":"+B39-C39","v":16871},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A39,'Pre Acquisition Assets'!Q:Q)","v":0},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A39,'Pre Acquisition Assets'!V:V)","v":16871},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A39,'Pre Acquisition Assets'!Z:Z)","v":16871},{"$f":"+SUMIF('Pre Acquisition Assets'!C:C,A39,'Pre Acquisition Assets'!AA:AA)","v":0},null,"Leasehold Improvements",{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J39,'FAR Dep Summary'!$B$24:$B$33)","v":0},0,{"$f":"+K39-L39","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J39,'FAR Dep Summary'!$C$24:$C$33)","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J39,'FAR Dep Summary'!$D$24:$D$33)","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J39,'FAR Dep Summary'!$E$24:$E$33)","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J39,'FAR Dep Summary'!$F$24:$F$33)","v":0},null,"Leasehold Improvements",{"$f":"+SUMIF('Bud Capital Input'!$L$57:$L$71,$S39,'Bud Capital Input'!M$57)*M99","v":0},0,{"$f":"+T39-U39","v":0},0,0,0,0,null,{"$f":"+J39","v":"Leasehold Improvements"},{"$f":"+B39+K39+T39","v":16871},{"$f":"+C39+L39","v":0},{"$f":"+D39+M39+V39","v":16871},{"$f":"+E39+N39+W39","v":0},{"$f":"+F39+O39+X39","v":16871},{"$f":"+G39+P39+Y39","v":16871},{"$f":"+H39+Q39+Z39","v":0}]
[]
["Land - Hauling",{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A41,'Pre Acquisition Assets'!M:M)","v":0},0,{"$f":"+B41-C41","v":0},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A41,'Pre Acquisition Assets'!Q:Q)","v":0},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A41,'Pre Acquisition Assets'!V:V)","v":0},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A41,'Pre Acquisition Assets'!Z:Z)","v":0},{"$f":"+SUMIF('Pre Acquisition Assets'!C:C,A41,'Pre Acquisition Assets'!AA:AA)","v":0},null,"Land - Hauling",{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J41,'FAR Dep Summary'!$B$24:$B$33)","v":0},0,{"$f":"+K41-L41","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J41,'FAR Dep Summary'!$C$24:$C$33)","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J41,'FAR Dep Summary'!$D$24:$D$33)","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J41,'FAR Dep Summary'!$E$24:$E$33)","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J41,'FAR Dep Summary'!$F$24:$F$33)","v":0},null,"Land - Hauling",{"$f":"+SUMIF('Bud Capital Input'!$L$57:$L$71,$S41,'Bud Capital Input'!M$57)*M101","v":0},0,{"$f":"+T41-U41","v":0},0,0,0,0,null,{"$f":"+J41","v":"Land - Hauling"},{"$f":"+B41+K41+T41","v":0},{"$f":"+C41+L41","v":0},{"$f":"+D41+M41+V41","v":0},{"$f":"+E41+N41+W41","v":0},{"$f":"+F41+O41+X41","v":0},{"$f":"+G41+P41+Y41","v":0},{"$f":"+H41+Q41+Z41","v":0}]
[]
["Structure - Hauling Only",{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A43,'Pre Acquisition Assets'!M:M)","v":566660},0,{"$f":"+B43-C43","v":566660},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A43,'Pre Acquisition Assets'!Q:Q)","v":18888.666666666668},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A43,'Pre Acquisition Assets'!V:V)","v":367687.48333333444},{"$f":"+SUMIF('Pre Acquisition Assets'!$C:$C,$A43,'Pre Acquisition Assets'!Z:Z)","v":386576.15000000113},{"$f":"+SUMIF('Pre Acquisition Assets'!C:C,A43,'Pre Acquisition Assets'!AA:AA)","v":180083.84999999887},null,"Structure - Hauling Only",{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J43,'FAR Dep Summary'!$B$24:$B$33)","v":0},0,{"$f":"+K43-L43","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J43,'FAR Dep Summary'!$C$24:$C$33)","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J43,'FAR Dep Summary'!$D$24:$D$33)","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J43,'FAR Dep Summary'!$E$24:$E$33)","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J43,'FAR Dep Summary'!$F$24:$F$33)","v":0},null,"Structure - Hauling Only",{"$f":"+SUMIF('Bud Capital Input'!$L$57:$L$71,$S43,'Bud Capital Input'!M$57)*M103","v":0},0,{"$f":"+T43-U43","v":0},0,0,0,0,null,{"$f":"+J43","v":"Structure - Hauling Only"},{"$f":"+B43+K43+T43","v":566660},{"$f":"+C43+L43","v":0},{"$f":"+D43+M43+V43","v":566660},{"$f":"+E43+N43+W43","v":18888.666666666668},{"$f":"+F43+O43+X43","v":367687.48333333444},{"$f":"+G43+P43+Y43","v":386576.15000000113},{"$f":"+H43+Q43+Z43","v":180083.84999999887}]
[]
["Transfer Station",null,null,null,null,null,null,null,null,"Transfer Station",{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J45,'FAR Dep Summary'!$B$24:$B$33)","v":0},0,{"$f":"+K45-L45","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J45,'FAR Dep Summary'!$C$24:$C$33)","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J45,'FAR Dep Summary'!$D$24:$D$33)","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J45,'FAR Dep Summary'!$E$24:$E$33)","v":0},{"$f":"+SUMIF('FAR Dep Summary'!$A$24:$A$33,$J45,'FAR Dep Summary'!$F$24:$F$33)","v":0},null,"Transfer Station",{"$f":"+SUMIF('Bud Capital Input'!$L$57:$L$71,$S45,'Bud Capital Input'!M$57)*M105","v":0},0,{"$f":"+T45-U45","v":0},0,0,0,0,null,{"$f":"+J45","v":"Transfer Station"},{"$f":"+B45+K45+T45","v":0},{"$f":"+C45+L45","v":0},{"$f":"+D45+M45+V45","v":0},{"$f":"+E45+N45+W45","v":0},{"$f":"+F45+O45+X45","v":0},{"$f":"+G45+P45+Y45","v":0},{"$f":"+H45+Q45+Z45","v":0}]
[]
[]
["Total Other",{"$f":"SUM(B31:B47)","v":678493},{"$f":"SUM(C31:C47)","v":0},678493,18888.666666666668,478665.90000000119,498409.15000000113,180083.84999999887,null,"Total Other",{"$f":"SUM(K31:K47)","v":166545.85000000003},{"$f":"SUM(L31:L47)","v":0},166545.85000000003,28685.235000000001,8017.9227222231257,36703.157722223128,129842.69227777686,null,"Total Other",{"$f":"SUM(T31:T47)","v":0},{"$f":"SUM(U31:U47)","v":0},0,0,0,0,0,null,"Total Other",{"$f":"SUM(AC31:AC47)","v":845038.85},{"$f":"SUM(AD31:AD47)","v":0},845038.85,47573.901666666672,486683.82272222434,535112.30772222427,309926.5422777757]
[]
["Total",{"$f":"B17+B29+B48","v":4125303},0,4125303,255230.4095238095,2967563.7785714599,3241301.2880952666,884001.71190473344,null,"Total",{"$f":"K17+K29+K48","v":325229.11000000004},0,325229.11000000004,48714.567142857144,15999.173436508841,64713.740579365985,260515.369420634,null,"Total",{"$f":"T17+T29+T48","v":190157},0,190157,25206.952380952382,0,25206.952380952382,164950.04761904763,null,"Total",{"$f":"AC17+AC29+AC48","v":4640689.1099999994},0,4640689.1099999994,329151.92904761905,2983562.9520079689,3331221.9810555852,1309467.1289444151]
[]
["Check",{"$f":"+'Pre Acquisition Assets'!M143-B50","v":0},null,{"$f":"+'Pre Acquisition Assets'!O143-D50","v":0},{"$f":"+'Pre Acquisition Assets'!Q143-E50","v":0},{"$f":"+'Pre Acquisition Assets'!V143-F50","v":0},{"$f":"+'Pre Acquisition Assets'!Z143-G50","v":0},{"$f":"+'Pre Acquisition Assets'!AA143-H50","v":0},null,"Check",{"$f":"+'FAR Dep Summary'!B32-'Depr Summary'!K50","v":0},null,null,{"$f":"+'FAR Dep Summary'!C32-'Depr Summary'!N50","v":0},{"$f":"+'FAR Dep Summary'!D32-'Depr Summary'!O50","v":0},{"$f":"+'FAR Dep Summary'!E32-'Depr Summary'!P50","v":0},{"$f":"+'FAR Dep Summary'!F32-'Depr Summary'!Q50","v":0},null,"Check",{"$f":"+'Bud Capital Input'!O62-T50","v":0},null,null,{"$f":"+'Bud Capital Input'!Q62-W50","v":0},null,null,{"$f":"+'Bud Capital Input'!S62-Z50","v":0},null,"Check",{"$f":"AC50-B50-K50-T50","v":-6.4028427004814148E-10},{"$f":"AD50-C50-L50-U50","v":0},-6.4028427004814148E-10,0,1.3824319466948509E-10,2.7648638933897018E-10,{"$f":"AI50-H50-Q50-Z50","v":0}]

{"sheet":"FAR Dep Summary","index":2,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[3,0,3,5]]}
[]
[]
[]
["Live Pivot "]
["Pre Acquisistion Add?","No"]
[]
["Row Labels","Sum of Cost","Sum of Test Year Dep","Sum of BOY Accum","Sum of EOY Accum","Sum of EOY Average Investment"]
["Drop Boxes",40198.080000000002,2812.4016666666666,6449.26,9261.6616666666669,30936.418333333335]
["Garbage Trucks",1525,508.33333333333326,0,508.33333333333326,1016.6666666666667]
["Office Equipment",7105.7300000000005,2035.1013333333331,449.21605555571199,2484.3173888890451,4621.4126111109545]
["Service Truck",47517.68,9503.5360000000001,4693.05666666672,14196.59266666672,33321.087333333278]
["Shop Equipment",111922.44000000002,17146.597666666668,2875.6500000006936,20022.247666667365,91900.192333332641]
["Roll-off Truck",74064.44,10580.634285714286,0,10580.634285714286,63483.805714285714]
["Garbage Carts",42895.740000000005,6127.9628571428575,1531.9907142857155,7659.953571428573,35235.786428571431]
["Grand Total",325229.11,48714.567142857144,15999.173436508841,64713.740579365993,260515.36942063406]
[]
[]
[]
[]
[]
[]
["Pasted Values"]
[]
["Row Labels","Sum of Cost","Sum of Test Year Dep","Sum of BOY Accum","Sum of EOY Accum","Sum of EOY Average Investment"]
["Drop Boxes",40198.080000000002,2812.4016666666666,6449.26,9261.6616666666669,30936.418333333335]
["Garbage Trucks",1525,508.33333333333326,0,508.33333333333326,1016.6666666666667]
["Office Equipment",7105.7300000000005,2035.1013333333331,449.21605555571199,2484.3173888890451,4621.4126111109545]
["Service Truck",47517.68,9503.5360000000001,4693.05666666672,14196.59266666672,33321.087333333278]
["Shop Equipment",111922.44000000002,17146.597666666668,2875.6500000006936,20022.247666667365,91900.192333332641]
["Roll-off Truck",74064.44,10580.634285714286,0,10580.634285714286,63483.805714285714]
["Garbage Carts",42895.740000000005,6127.9628571428575,1531.9907142857155,7659.953571428573,35235.786428571431]
["Grand Total",325229.11,48714.567142857144,15999.173436508841,64713.740579365993,260515.36942063406]
[null,{"$f":"+B32-B15","v":0},{"$f":"+C32-C15","v":0},0,0,0]

{"sheet":"FAR 04.30.2023","index":3,"n_rows":147,"n_cols":49,"rows_kept":147,"cut":false,"hidden":false,"merged":[[8,5,9,9],[8,12,8,13],[9,2,9,3],[9,12,9,13],[10,12,10,13]]}
[null,"Location","AssetID","ParentChild","Description","SystemNo",null,"MFGSerialNum","LicensePlate","ModelYear","VendorMfg","BodyManuf","InsuranceCategory","InServiceDate","AcquisitionDate","PONumber","EstimatedLife","AssetGL","AcqValue","AccumulatedGL","CurrentLifeToDate",null,"CurrentYearToDate","ExpenseGL","CurrentPeriodDepr","AcqType","FormerCompany","InvoiceNum","CompAsstNo","Book","ActivityCd","DeprMethod","BegLsDeprDate","LongName","Sequence","BegLifeToDate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S2-U2","v":0}]
[null,{"$f":"_xll.ReportRange(\"FARReport\",A14:AJ148,A1:AJ1,A2:AJ2,_xll.Param($C$9,$C$10,C12,$M$9,$M$10,$M$11,$S$9,M12,$Y$10,$Y$9,S10,S11,CELL(\"address\",$E$6)),TRUE,FALSE)","v":"OK!: ReportRange Formula OK [jAction{}]"},null,null,null,null,null,null,null,null,null,"Default Month :",{"$f":"MONTH(NOW())","v":6},null,null,null,null,null,{"$f":"_xll.ReportDrill([3]ProjDepr!D3,,_xll.PairGroup(_xll.Pair('FAR 04.30.2023'!C9,[3]ProjDepr!D19),_xll.Pair(\"C:B\",[3]ProjDepr!D20),_xll.Pair(\"C:C\",[3]ProjDepr!D21),_xll.Pair(\"C:V\",[3]ProjDepr!D22)),\"Projected Depr\")","v":"OK!: ReportDrill 'Projected Depr' Formula OK [jAction{}]"},null,null,null,null,null,{"$f":"_xll.jFreezePanes(A14,A5)","v":"> jFreezePanes is ready. "},null,null,{"$f":"_xll.jFocus(C9)","v":"> jFocus is ready. "}]
[null,null,null,null,null,null,null,null,null,null,null,"Default Year :",{"$f":"IF(M3=12,YEAR(NOW()),YEAR(NOW()))","v":2023},null,null,null,null,null,"reportdrill(Invoice!C2,,pairgroup(pair(\"C:C\",Invoice!E8),pair(\"\",Invoice!E7,\"N\")),\"Drill To Invoices by FAS# (Exc CIP)\")",null,{"$f":"_xll.ReportDrill([3]Invoice!$C$2,,_xll.PairGroup(_xll.Pair(\"C:P\",[3]Invoice!$E$7),_xll.Pair(\"\",[3]Invoice!$E$8,\"N\"),_xll.Pair(\"\",[3]Invoice!$E$9,\"n\")),\"Drill To All Invoices by PO#\")","v":"OK!: ReportDrill 'Drill To All Invoices by PO#' Formula OK [jAction{}]"},null,null,{"$f":"_xll.ReportDrill([3]Invoice!$C$2,,_xll.PairGroup(_xll.Pair(\"C:P\",[3]Invoice!$E$7),_xll.Pair(\"\",[3]Invoice!$E$8,\"N\"),_xll.Pair(\"C:Z\",[3]Invoice!$E$9,\"n\")),\"Drill to Invoice by PO# and Invoice #\")","v":"OK!: ReportDrill 'Drill to Invoice by PO# and Invoice #' Formula OK [jAction{}]"}]
[null,"Fixed Asset Register",null,null,null,null,null,"Asset Count:",{"$f":"COUNT(C14:C148)","v":134},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Test Period Beg. Month"]
[null,"Data Last Updated in this Pull:",null,null,"May  8 2023  8:39AM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Test Period End Month"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2022,"First Year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,"Second year"]
[null,"Period:","2023-04",null,null,"Ctrl + Shift + J",null,null,null,null,null,"VIN:",null,null,"(Contains the string)",null,null,"Parent/Child:",null,"(Leave blank for all)",null,null,null,"Service Date To:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AK8+(AK6/12)","v":2023.3333333333333},"Test Period End Mo/Yr"]
[null,"District:","2178",null,"(F9 Aware)",null,null,null,null,null,null,"Description:",null,null,"(Contains the string)",null,null,"Asset Acct:",null,null,null,null,null,"Service Date From:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AK7+(AK5/12)","v":2022.4166666666667},"Test Period Beg. Mo/Yr"]
[null,null,null,null,null,null,null,null,null,null,null,"PO Number:",null,null,"(Contains the string)",null,null,"Exp Acct:"]
[null,"Asset #:",null,null,null,null,null,null,null,null,null,"Ins Category:",null,null,"(Not setup yet)",null,null,"Depreciated %:",null,"(Not setup yet)"]
[null,"District","Asset #","Parent/ Child","Descr","Container Count","NA","MFG Serial#","License Plate","Model Year","Vendor/Mfg","Body Mfg","Ins Category","In Service Date","Acq Date","CER #","Useful Life","Asset Account","Cost","Accum Account","Accum Life to Date","NBV","Accum YTD","Expense Account","Current Depr","Acq Type","Former Company","Invoice #","Company Asset #","Book","Activity Cd","Depr Meth","Beg Date","Dbase","Seq","Beg Depr","Truck #","Equipment Type for Lookup","Month","YearPIS","Year Fully Dep","Year/Mo Fully Dep","Monthly Dep","Annual Dep","Test Year Dep","BOY Accum","EOY Accum","EOY Average Investment","Pre Acquisistion Add?"]
[null,2178,304030,"P","2022 Galbreath T5 Pup Trailer",null,null,"1W9SR2533PC269294",null,0,null,null,"Trailer","2023-04-01","2023-04-01","2178-23-0004-1",700,14040,74064.44,14046,881.72,{"$f":"S14-U14","v":73182.720000000001},881.72,51260,881.72,"P",null,null,null,"Internal","A","SL",null,"WCNX",0,0,"DBT3","Roll-off Truck",{"$f":"MONTH($N14)","v":4},{"$f":"YEAR($N14)","v":2023},{"$f":"$AN14+($Q14/100)","v":2030},{"$f":"$AO14+($AM14/12)","v":2030.3333333333333},{"$f":"IFERROR($S14/($Q14/100)/12,0)","v":881.71952380952382},{"$f":"$AQ14*12","v":10580.634285714286},{"$f":"+IF(AP14<=$AK$9,0,AR14)","v":10580.634285714286},{"$f":"+IF(AP14<=$AK$10,S14,IF((AN14+(AM14/12))>=$AK$10,0,((S14-((AP14-$AK$10)*12)*AQ14))))","v":0},{"$f":"IF($AS14=0,S14,($AS14+$AT14))","v":10580.634285714286},{"$f":"$S14-$AU14","v":63483.805714285714},"No"]
[null,2178,299026,"P","HP ProBook 450 G9 Notebook - SN: 5CD2428C6F",1,null,null,null,0,"CDW DIR #2178",null,null,"2023-01-20","2023-01-20","2178-23-0005-1",300,14110,1312.04,14116,109.34,1202.7,109.34,70260,36.450000000000003,"P",null,"NA",null,"Internal","A","SL",null,"WCNX",0,0,null,"Office Equipment",{"$f":"MONTH($N15)","v":1},{"$f":"YEAR($N15)","v":2023},{"$f":"$AN15+($Q15/100)","v":2026},{"$f":"$AO15+($AM15/12)","v":2026.0833333333333},{"$f":"IFERROR($S15/($Q15/100)/12,0)","v":36.445555555555551},{"$f":"$AQ15*12","v":437.34666666666658},{"$f":"+IF(AP15<=$AK$9,0,AR15)","v":437.34666666666658},{"$f":"+IF(AP15<=$AK$10,S15,IF((AN15+(AM15/12))>=$AK$10,0,((S15-((AP15-$AK$10)*12)*AQ15))))","v":0},{"$f":"IF($AS15=0,S15,($AS15+$AT15))","v":437.34666666666658},{"$f":"$S15-$AU15","v":874.69333333333338},"No"]
[null,2178,296023,293636,"Stationary Air Compressor/Generator Item #4NB87",null,null,"3C7WR5AJ5NG222964",null,2022,"TONKIN HILLSBORO","RAM 2500","Non-Rolling Stock","2022-11-10","2022-11-10","2178-22-0009-1",300,14040,4110.8599999999997,14046,685.14,3425.72,456.76,51260,114.19,"P",null,1466359441,null,"Internal","A","SL",null,"WCNX",0,0,"ST1","Shop Equipment",11,2022,2025,2025.9166666666667,114.19055555555555,1370.2866666666666,1370.2866666666666,0,1370.2866666666666,2740.5733333333328,"No"]
[null,2178,295133,"P","GeoTab Units",16,null,null,null,0,"ASSURED TELEMATICS INC",null,null,"2022-12-15","2022-12-15","2178-22-0008-1",300,14110,1525,14116,211.8,1313.2,169.44,70260,42.36,"P",null,98552,null,"Internal","A","SL",null,"WCNX",0,0,"MULTI","Garbage Trucks",12,2022,2025,2026,42.361111111111107,508.33333333333326,508.33333333333326,0,508.33333333333326,1016.6666666666667,"No"]
[null,2178,293636,"P","2022 Ram 2500 Service Truck",null,null,"3C7WR5AJ5NG222964",null,2022,"TONKIN HILLSBORO","RAM 2500","Service Truck","2022-11-10","2022-11-10","2178-22-0009-1",1000,14040,73817.350000000006,14046,3690.87,70126.48000000001,2460.58,51260,615.14,"P",null,17701,null,"Internal","A","SL",null,"WCNX",0,0,"ST1","Shop Equipment",11,2022,2032,2032.9166666666667,615.14458333333334,7381.7350000000006,7381.7350000000006,0,7381.7350000000006,66435.615000000005,"No"]
[null,2178,287690,"P","C2GW-August Goodwill",null,null,null,null,0,null,null,null,"2022-08-01","2022-08-01",null,0,15110,-18253.39,15120,0,-18253.39,0,70269,0,"A","Peninsula Sanitation",null,null,"Internal","A","NO",null,"WCNX",0,0,0,"Intangibles",null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,287375,284802,"Tax on 30YD RO Boxes",2,null,null,null,0,"CAPITAL INDUSTRIES INC",null,"Non-Container Audit","2022-06-30","2022-06-30","2178-22-0006-1",1200,14050,1412.64,14056,98.1,1314.5400000000002,39.24,54260,9.81,"P",null,"173823A",null,"Internal","A","SL",null,"WCNX",0,0,0,"Drop Boxes",{"$f":"MONTH($N20)","v":6},{"$f":"YEAR($N20)","v":2022},{"$f":"$AN20+($Q20/100)","v":2034},{"$f":"$AO20+($AM20/12)","v":2034.5},{"$f":"IFERROR($S20/($Q20/100)/12,0)","v":9.81},{"$f":"$AQ20*12","v":117.72},{"$f":"+IF(AP20<=$AK$9,0,AR20)","v":117.72},{"$f":"+IF(AP20<=$AK$10,S20,IF((AN20+(AM20/12))>=$AK$10,0,((S20-((AP20-$AK$10)*12)*AQ20))))","v":0},{"$f":"IF($AS20=0,S20,($AS20+$AT20))","v":117.72},{"$f":"$S20-$AU20","v":1294.92},"No"]
[null,2178,287374,284792,"Tax on 20YD RO Boxes",2,null,null,null,0,"CAPITAL INDUSTRIES INC",null,"Non-Container Audit","2022-06-30","2022-06-30","2178-22-0006-1",1200,14050,1116.18,14056,77.52,1038.6600000000001,31.01,54260,7.75,"P",null,"173822A",null,"Internal","A","SL",null,"WCNX",0,0,0,"Drop Boxes",6,2022,2034,2034.5,7.7512499999999998,93.015000000000001,93.015000000000001,0,93.015000000000001,1023.1650000000001,"No"]
[null,2178,284802,"P","30YD RO Boxes",2,null,null,null,0,"CAPITAL INDUSTRIES INC",null,"30 YD RO Box","2022-06-30","2022-06-30","2178-22-0006-1",1200,14050,17440,14056,1211.1099999999999,16228.89,484.44,54260,121.11,"P",null,173823,null,"Internal","A","SL",null,"WCNX",0,0,0,"Drop Boxes",6,2022,2034,2034.5,121.1111111111111,1453.3333333333333,1453.3333333333333,0,1453.3333333333333,15986.666666666666,"No"]
[null,2178,284792,"P","20YD RO Boxes",2,null,null,null,0,"CAPITAL INDUSTRIES INC",null,"20 YD RO Box","2022-06-30","2022-06-30","2178-22-0006-1",1200,14050,13780,14056,956.95,12823.05,382.78,54260,95.7,"P",null,173822,null,"Internal","A","SL",null,"WCNX",0,0,0,"Drop Boxes",6,2022,2034,2034.5,95.694444444444443,1148.3333333333333,1148.3333333333333,0,1148.3333333333333,12631.666666666666,"No"]
[null,2178,283492,"P","Laptop for Maint Sup SN: 5CD2159W57",1,null,null,null,0,"CDW DIR #PO  2178-22-0",null,null,"2022-06-02","2022-06-02","2178-22-0007-1",300,14110,1459.08,14116,445.83,1013.25,162.12,70260,40.53,"P",null,"Z066342",null,"Internal","A","SL",null,"WCNX",0,0,0,"Shop Equipment",6,2022,2025,2025.5,40.529999999999994,486.3599999999999,486.3599999999999,0,486.3599999999999,972.72,"No"]
[null,2178,280400,"P","20 YD RO Box",1,null,null,null,0,null,null,null,"2008-11-03","2008-11-03",null,700,14050,87.05,14056,87.05,0,0,54260,0,"A","LeMay Enterprises",null,null,"Internal","A","SL","2022-04-30","WCNX",0,87.05,0,"Drop Boxes",11,2008,2015,2015.9166666666667,1.0363095238095237,12.435714285714283,0,87.05,87.05,0,"No"]
[null,2178,279840,"P","30 Yard box",3,null,0,null,0,"ENTERPRISE SALES, INC.",null,"30 YD RO Box","2007-06-11","2007-06-11","07-2112-003",1200,14050,6362.21,14056,6362.21,0,0,54260,0,"P",null,3405,null,"Internal","A","SL","2022-04-30","WCNX",0,6362.21,0,"Drop Boxes",6,2007,2019,2019.5,44.182013888888889,530.18416666666667,0,6362.21,6362.21,0,"No"]
[null,2178,278662,"P","Shop Laptop - Diagnostic Cable",1,null,null,null,0,"Jackson Group Peterbilt",null,null,"2022-04-14","2022-04-14","2178-22-0004-1",300,14110,3774.96,14116,1363.18,2411.7799999999997,419.44,70260,104.86,"P",null,"23297K",null,"Internal","A","SL",null,"WCNX",0,0,0,"Shop Equipment",4,2022,2025,2025.3333333333333,104.86,1258.32,1258.32,104.86000000019067,1363.1800000001906,2411.7799999998097,"No"]
[null,2178,276457,"P","Peninsula Sanitation DTL - Tax C/O Fixed Assets Q1 '22",null,null,null,null,0,null,null,null,"2022-03-31","2022-03-31",null,0,15110,-147795,15120,0,-147795,0,70268,0,"A","Pacific Solid Waste",null,null,"Internal","A","NO",null,"WCNX",0,0,0,"Intangibles",null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,276001,"P","Shop 10 ton Maintenance Set",1,null,null,null,0,"Grainger",null,null,"2022-03-22","2022-03-22","2178-22-0005-1",500,14070,3558.84,14076,771.08,2787.76,237.26,51260,59.32,"P",null,1440707389,null,"Internal","A","SL",null,"WCNX",0,0,0,"Office Equipment",{"$f":"MONTH($N29)","v":3},{"$f":"YEAR($N29)","v":2022},{"$f":"$AN29+($Q29/100)","v":2027},{"$f":"$AO29+($AM29/12)","v":2027.25},{"$f":"IFERROR($S29/($Q29/100)/12,0)","v":59.314},{"$f":"$AQ29*12","v":711.76800000000003},{"$f":"+IF(AP29<=$AK$9,0,AR29)","v":711.76800000000003},{"$f":"+IF(AP29<=$AK$10,S29,IF((AN29+(AM29/12))>=$AK$10,0,((S29-((AP29-$AK$10)*12)*AQ29))))","v":118.62800000005427},{"$f":"IF($AS29=0,S29,($AS29+$AT29))","v":830.3960000000543},{"$f":"$S29-$AU29","v":2728.4439999999458},"No"]
[null,2178,275231,"P","65gal MSW Totes",330,null,null,"94-3283464",0,"REHRIG PACIFIC COMPANY IN",null,"Non-Container Audit","2022-02-28","2022-02-28","2178-22-0001-1",700,14050,20180.22,14056,3363.37,16816.850000000002,960.96,54260,240.24,"P",null,50226410,null,"Internal","A","SL",null,"WCNX",0,0,0,"Garbage Carts",2,2022,2029,2029.1666666666667,240.24071428571429,2882.8885714285716,2882.8885714285716,720.7221428571429,3603.6107142857145,16576.609285714287,"No"]
[null,2178,275230,"P","95gal MSW Totes",336,null,null,"94-3283464",0,"REHRIG PACIFIC COMPANY IN",null,"Non-Container Audit","2022-02-28","2022-02-28","2178-22-0001-1",700,14050,22715.52,14056,3785.92,18929.599999999999,1081.69,54260,270.42,"P",null,50226410,null,"Internal","A","SL",null,"WCNX",0,0,0,"Garbage Carts",2,2022,2029,2029.1666666666667,270.42285714285714,3245.0742857142859,3245.0742857142859,811.26857142857261,4056.3428571428585,18659.177142857141,"No"]
[null,2178,274706,"P","C2GW-February Goodwill",null,null,null,null,0,null,null,null,"2022-02-01","2022-02-01",null,0,15110,1386244.01,15120,0,1386244.01,0,70268,0,"A","Peninsula Sanitation",null,null,"Internal","A","NO",null,"WCNX",0,0,0,"Intangibles",null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,274639,273337,"Insite Pro (MR/HD) Plus",1,null,null,null,0,"Cummins Inc.",null,null,"2022-01-25","2022-01-25","2178-22-0003-1",300,14110,337.78,14116,140.72999999999999,197.04999999999998,37.53,70260,9.3800000000000008,"P",null,"I-0000151212",null,"Internal","A","SL",null,"WCNX",0,0,0,"Office Equipment",{"$f":"MONTH($N33)","v":1},{"$f":"YEAR($N33)","v":2022},{"$f":"$AN33+($Q33/100)","v":2025},{"$f":"$AO33+($AM33/12)","v":2025.0833333333333},{"$f":"IFERROR($S33/($Q33/100)/12,0)","v":9.3827777777777772},{"$f":"$AQ33*12","v":112.59333333333333},{"$f":"+IF(AP33<=$AK$9,0,AR33)","v":112.59333333333333},{"$f":"+IF(AP33<=$AK$10,S33,IF((AN33+(AM33/12))>=$AK$10,0,((S33-((AP33-$AK$10)*12)*AQ33))))","v":37.531111111128155},{"$f":"IF($AS33=0,S33,($AS33+$AT33))","v":150.12444444446149},{"$f":"$S33-$AU33","v":187.65555555553848},"No"]
[null,2178,273536,"P","C2GW-January Goodwill",null,null,null,null,0,null,null,null,"2022-01-01","2022-01-01",null,0,15110,-87959.15,15120,0,-87959.15,0,70268,0,"A","Peninsula Sanitation",null,null,"Internal","A","NO",null,"WCNX",0,0,0,"Intangibles",null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,273337,"P","HP ProDesk 600 G6 i5 MXL1521KW6",1,null,null,null,0,"CDW DIR #2178",null,null,"2022-01-25","2022-01-25","2178-22-0003-1",300,14110,1050.8499999999999,14116,437.85,612.99999999999989,116.76,70260,29.19,"P",null,"R284784",null,"Internal","A","SL",null,"WCNX",0,0,0,"Office Equipment",{"$f":"MONTH($N35)","v":1},{"$f":"YEAR($N35)","v":2022},{"$f":"$AN35+($Q35/100)","v":2025},{"$f":"$AO35+($AM35/12)","v":2025.0833333333333},{"$f":"IFERROR($S35/($Q35/100)/12,0)","v":29.190277777777776},{"$f":"$AQ35*12","v":350.2833333333333},{"$f":"+IF(AP35<=$AK$9,0,AR35)","v":350.2833333333333},{"$f":"+IF(AP35<=$AK$10,S35,IF((AN35+(AM35/12))>=$AK$10,0,((S35-((AP35-$AK$10)*12)*AQ35))))","v":116.76111111116415},{"$f":"IF($AS35=0,S35,($AS35+$AT35))","v":467.04444444449746},{"$f":"$S35-$AU35","v":583.80555555550245},"No"]
[null,2178,272324,"P","Peninsula Sanitation Deferred Tax Liabil",null,null,null,null,0,null,null,null,"2021-12-31","2021-12-31",null,0,15110,2394046.5699999998,15120,0,2394046.5699999998,0,null,0,"A","J&J Services",null,null,"Internal","A","NO",null,"WCNX",0,0,0,"Intangibles",null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,272323,"P","Peninsula Sanitation Deferred Tax Liabil",null,null,null,null,0,null,null,null,"2021-12-31","2021-12-31",null,0,15110,722851.08,15120,0,722851.08,0,null,0,"A","Pacific Solid Waste",null,null,"Internal","A","NO",null,"WCNX",0,0,0,"Intangibles",null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,272004,"P","C2GW-December Goodwill",null,null,null,null,0,null,null,null,"2021-12-01","2021-12-01",null,0,15110,30779.49,15120,0,30779.49,0,null,0,"A","Pacific Solid Waste",null,null,"Internal","A","NO",null,"WCNX",0,0,0,"Intangibles",null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,271883,266482,"2022 Peterbilt 520 RH Drive (Heil Durapack Automated)",null,null,"3BPDLJ0X1NF112424",null,0,null,null,"Non-Rolling Stock","2021-11-01","2021-11-01",null,1000,14040,0,14046,0,0,0,51260,0,"A","Peninsula Sanitation",null,115,"Internal","A","SL",null,"WCNX",0,0,18,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,271882,266481,"2022 Peterbilt 520 RH Drive (Heil Durapack Automated)",null,null,"3BPDLJ0XXNF112423",null,0,null,null,"Non-Rolling Stock","2021-11-01","2021-11-01",null,1000,14040,0,14046,0,0,0,51260,0,"A","Peninsula Sanitation",null,114,"Internal","A","SL",null,"WCNX",0,0,17,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,271844,"P-Tax","40-60 Gallon Carts",40,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Pacific Solid Waste",null,null,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,271458,"P","Nexiq USB Link 2",1,null,null,null,0,"SP   MARINE DIAG TOOLS",null,null,"2021-12-20","2021-12-20","2178-21-0003-1",200,14110,846.22,14116,564.15,282.07000000000005,141.04,70260,35.26,"P",null,106144,null,"Internal","A","SL",null,"WCNX",0,0,0,"Office Equipment",{"$f":"MONTH($N42)","v":12},{"$f":"YEAR($N42)","v":2021},{"$f":"$AN42+($Q42/100)","v":2023},{"$f":"$AO42+($AM42/12)","v":2024},{"$f":"IFERROR($S42/($Q42/100)/12,0)","v":35.259166666666665},{"$f":"$AQ42*12","v":423.11},{"$f":"+IF(AP42<=$AK$9,0,AR42)","v":423.11},{"$f":"+IF(AP42<=$AK$10,S42,IF((AN42+(AM42/12))>=$AK$10,0,((S42-((AP42-$AK$10)*12)*AQ42))))","v":176.29583333336541},{"$f":"IF($AS42=0,S42,($AS42+$AT42))","v":599.40583333336542},{"$f":"$S42-$AU42","v":246.81416666663461},"No"]
[null,2178,271407,"P","SF300 Event Recorders",17,null,null,null,0,"Lytx",null,null,"2021-12-13","2021-12-13","2178-21-0006-1",500,14070,5391.49,14076,1527.59,3863.8999999999996,359.43,51260,89.85,"P",null,5437755,null,"Internal","A","SL",null,"WCNX",0,0,"MULTI","Shop Equipment",12,2021,2026,2027,89.858166666666662,1078.298,1078.298,449.29083333341532,1527.5888333334153,3863.9011666665847,"No"]
[null,2178,271406,"P","Shop Jacks and Stands",3,null,null,null,0,"Northern Tool & Equipment",null,null,"2021-12-20","2021-12-20","2178-21-0005-1",500,14070,5375.72,14076,1433.52,3942.2000000000003,358.38,51260,89.59,"P",null,93009660,null,"Internal","A","SL",null,"WCNX",0,0,0,"Shop Equipment",12,2021,2026,2027,89.595333333333329,1075.144,1075.144,447.97666666674832,1523.1206666667483,3852.5993333332517,"No"]
[null,2178,270682,"P","3rd Eye Camera",31,null,null,null,0,null,null,null,"2021-12-31","2021-12-31","1010-21-0039",500,14070,15000.12,14076,4000.03,11000.09,1000.01,51260,250,"P",null,null,null,"Internal","A","SL",null,"WCNX",0,0,"MULTI","Shop Equipment",12,2021,2026,2027,250.00200000000004,3000.0240000000003,3000.0240000000003,1250.0100000002258,4250.0340000002261,10750.085999999774,"No"]
[null,2178,270098,265060,"Pickup - License and Use Tax",null,null,null,null,2021,"N/A","Ford","Non-Rolling Stock","2021-12-28","2021-12-28","2178-21-0001-1",500,14040,3522.68,14046,939.39,{"$f":"S46-U46","v":2583.29},234.85,51260,58.71,"P",null,12282021,null,"Internal","A","SL",null,"WCNX",0,0,"PU2","Service Truck",12,2021,2026,2027,58.711333333333329,704.53599999999994,704.53599999999994,293.55666666672005,998.09266666671999,2524.5873333332797,"No"]
[null,2178,267267,"P","NOREGON Panasonic Toughbook",1,null,null,null,0,"NOREGON SYSTEMS INC",null,null,"2021-12-13","2021-12-13","2178-21-0003-1",200,14110,2992.86,14116,2119.94,872.92000000000007,498.81,70260,124.7,"P",null,"INV00108359",null,"Internal","A","SL",null,"WCNX",0,0,0,"Shop Equipment",12,2021,2023,2024,124.7025,1496.43,1496.43,623.5125000001135,2119.9425000001138,872.91749999988633,"No"]
[null,2178,267059,"P","Peninsula Sanitation Office Equipment",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,500,14100,1250,14106,375,875,83.33,70260,20.83,"A","Peninsula Sanitation",null,null,"Internal","A","SL",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,267058,"P","Peninsula Sanitation Shop Equipment",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,500,14070,1250,14076,375,875,83.33,51260,20.83,"A","Peninsula Sanitation",null,null,"Internal","A","SL",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266876,"P","96 Gal Totes",30,null,null,null,0,"TANK HOLDING CORP",null,"Non-Container Audit","2021-11-15","2021-11-15","2178-21-0004-1",700,14050,3845.84,14056,824.11,3021.73,183.14,54260,45.79,"P",null,396156,null,"Internal","A","SL",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266858,"P","60 Gal Totes",120,null,null,null,0,"TANK HOLDING CORP",null,"Non-Container Audit","2021-11-15","2021-11-15","2178-21-0004-1",700,14050,14114.98,14056,3024.64,11090.34,672.14,54260,168.03,"P",null,396156,null,"Internal","A","SL",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266608,"P","Peninsula Sanitation G. Certificate",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,15260,9557072.1199999992,15266,0,9557072.1199999992,0,0,0,"A","Peninsula Sanitation",null,null,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266607,"P-Tax","350-65G& 100-95G Bear Cart",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,113,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266606,"P-Tax","300-60 gal./ 100-90 gal.",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,112,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266605,"P-Tax","210 - 60 gallons",210,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,111,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266604,"P-Tax","Box C8,9.10,11",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,110,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266603,"P-Tax","100-90 Gallon Cans",100,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,107,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266602,"P-Tax","300-60 Gallon Cans",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,106,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266601,"P-Tax","100-300 Gallon Cans",100,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,105,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266600,"P-Tax","300 60 G. Cans/100 96 G.",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,102,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266599,"P-Tax","400 60 Gallon totes",400,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,98,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266598,"P-Tax","Drop Boxes",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,97,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266597,"P-Tax","New cans - 400",400,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,91,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266596,"P-Tax","60 Gallon Cans",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,84,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266595,"P-Tax","90 Gallon Cans",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,83,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266594,"P-Tax","Box #4730 #3730",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,82,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266593,"P-Tax","Box #3L30",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,81,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266592,"P-Tax","Box #C5 C6 C7",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,73,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266591,"P-Tax","Box # 1630 CB9 CB 10",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,72,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266590,"P-Tax","90, 300 & 60 Gal. Cans",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,71,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266589,"P-Tax","3 . 30yd Drop Boxes",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,70,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266588,"P-Tax","10 Drop Boxes",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,68,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266587,"P-Tax","Totes",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,67,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266586,"P-Tax","Box#2830 2930 24  L2 3 4",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,66,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266585,"P-Tax","Box #22 23 Ll",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,64,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266584,"P-Tax","400 60 Gallon Cans",400,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,63,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266583,"P-Tax","Drop Box #2530 2630 2730",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,62,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266582,"P-Tax","Totes",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,{"$f":"S78-U78","v":0},0,54260,0,"A","Peninsula Sanitation",null,61,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266581,"P-Tax","Box #2430 4L40 5L40",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,60,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266580,"P-Tax","Box #21",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,59,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266579,"P-Tax","2 Drop Boxes #19 & 20",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,58,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266578,"P-Tax","Totes",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,57,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266577,"P-Tax","Recycle Box #2330",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,56,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266576,"P-Tax","20 Yd. Boxes - 4",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,54,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266575,"P-Tax","60 & 90 Gallon cans",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,53,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266574,"P-Tax","30 Yd. Drop Boxes-#1 2 3",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,50,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266573,"P-Tax","New totes",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,48,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266572,"P-Tax","Box's #LlO #Lll  #Ll3",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,47,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266571,"P-Tax","Totes",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,46,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266570,"P-Tax","30Yd Drop Boxes",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,44,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266569,"P-Tax","Box #'s L5 LG L9",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,43,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266567,"P-Tax","Compactor",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14060,0,14066,0,0,0,54260,0,"A","Peninsula Sanitation",null,69,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266566,"P-Tax","Roll-Off #2",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14040,0,14046,0,0,0,51260,0,"A","Peninsula Sanitation",null,109,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266565,"P-Tax","Roll-Off #3",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14040,0,14046,0,0,0,51260,0,"A","Peninsula Sanitation",null,108,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266564,"P-Tax","Heil Truck #16",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14040,0,14046,0,0,0,51260,0,"A","Peninsula Sanitation",null,99,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266563,"P-Tax","DP 7000 28yd Dump #14",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14030,0,14036,0,0,0,51260,0,"A","Peninsula Sanitation",null,92,"Internal","A","NO",null,"WCNX",0,0,14,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266562,"P-Tax","2014 Peterbilt 320 #14",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14040,0,14046,0,0,0,51260,0,"A","Peninsula Sanitation",null,90,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266561,"P-Tax","#4 Rolloff Boom",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14030,0,14036,0,0,0,51260,0,"A","Peninsula Sanitation",null,89,"Internal","A","NO",null,"WCNX",0,0,4,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266560,"P-Tax","#5 Rolloff Boom",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14030,0,14036,0,0,0,51260,0,"A","Peninsula Sanitation",null,88,"Internal","A","NO",null,"WCNX",0,0,5,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266559,"P-Tax","DP 7000 28yd Dump #12",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14030,0,14036,0,0,0,51260,0,"A","Peninsula Sanitation",null,85,"Internal","A","NO",null,"WCNX",0,0,12,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266558,"P-Tax","Roto Cart",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14050,0,14056,0,0,0,54260,0,"A","Peninsula Sanitation",null,75,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266557,"P-Tax","2 Trucks#9 Heil",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14040,0,14046,0,0,0,51260,0,"A","Peninsula Sanitation",null,55,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266556,"P-Tax","Computers",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14110,0,14116,0,0,0,70260,0,"A","Peninsula Sanitation",null,79,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266555,"P-Tax","Printer & stand",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14110,0,14116,0,0,0,70260,0,"A","Peninsula Sanitation",null,78,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266554,"P-Tax","Computer Program",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14110,0,14116,0,0,0,70260,0,"A","Peninsula Sanitation",null,77,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266553,"P-Tax","Phone System",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14100,0,14106,0,0,0,70260,0,"A","Peninsula Sanitation",null,74,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266552,"P-Tax","Truck Cover Building",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14080,0,14086,0,0,0,57260,0,"A","Peninsula Sanitation",null,76,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266551,"P-Tax","Paving",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14010,0,14016,0,0,0,57260,0,"A","Peninsula Sanitation",null,49,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266550,"P-Tax","Leasehold improvements",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,14090,0,14096,0,0,0,57260,0,"A","Peninsula Sanitation",null,30,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266515,"P","116 Howerton Way - Land Improvements",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,1000,14010,90000,14016,13500,{"$f":"S110-U110","v":76500},3000,57260,750,"A","Peninsula Sanitation",null,null,"Internal","A","SL",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266514,"P","116 Howerton Way - Buildings",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,2000,14080,840000,14086,63000,777000,14000,57260,3500,"A","Peninsula Sanitation",null,1,"Internal","A","SL",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266510,"P","20 YD Compactor",1,null,null,null,0,null,null,"20 YD Compactor","2021-11-01","2021-11-01",null,700,14060,7000,14066,1500,5500,333.33,54260,83.33,"A","Peninsula Sanitation",null,100,"Internal","A","SL",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266509,"P","2 YD Container Bin",48,null,null,null,0,null,null,"2 YD Container","2021-11-01","2021-11-01",null,700,14050,9408,14056,2016,7392,448,54260,112,"A","Peninsula Sanitation",null,null,"Internal","A","SL",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266508,"P","1.5 YD Container Bin",86,null,null,null,0,null,null,"1.5 YD Container","2021-11-01","2021-11-01",null,700,14050,16856,14056,3612,13244,802.67,54260,200.67,"A","Peninsula Sanitation",null,null,"Internal","A","SL",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266507,"P","1 YD Container Bin",68,null,null,null,0,null,null,"1 YD Container","2021-11-01","2021-11-01",null,700,14050,13328,14056,2856,10472,634.66999999999996,54260,158.66999999999999,"A","Peninsula Sanitation",null,null,"Internal","A","SL",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266506,"P","2652 Gallon Water Box",1,null,null,null,0,null,null,"Other","2021-11-01","2021-11-01",null,700,14050,196,14056,42,154,9.33,54260,2.33,"A","Peninsula Sanitation",null,58,"Internal","A","SL",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266505,"P","44 YD RO Boxes",3,null,null,null,0,null,null,"44 YD RO Box","2021-11-01","2021-11-01",null,700,14050,9000,14056,1928.58,7071.42,428.57,54260,107.14,"A","Peninsula Sanitation",null,null,"Internal","A","SL",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266504,"P","40 YD RO Boxes",5,null,null,null,0,null,null,"40 YD RO Box","2021-11-01","2021-11-01",null,700,14050,15000,14056,3214.29,11785.71,714.29,54260,178.57,"A","Peninsula Sanitation",null,null,"Internal","A","SL",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266503,"P","35 YD RO Boxes",6,null,null,null,0,null,null,"20 YD RO Boxes","2021-11-01","2021-11-01",null,700,14050,18000,14056,3857.14,14142.86,857.14,54260,214.28,"A","Peninsula Sanitation",null,null,"Internal","A","SL",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266502,"P","30 YD RO Boxes",72,null,null,null,0,null,null,"20 YD RO Box","2021-11-01","2021-11-01",null,700,14050,216000,14056,46285.71,169714.29,10285.709999999999,54260,2571.42,"A","Peninsula Sanitation",null,null,"Internal","A","SL",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266501,"P","25 YD RO Boxes",2,null,null,null,0,null,null,"20 YD RO Boxes","2021-11-01","2021-11-01",null,700,14050,6000,14056,1285.71,4714.29,285.70999999999998,54260,71.42,"A","Peninsula Sanitation",null,null,"Internal","A","SL",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266500,"P","20 YD RO Boxes",55,null,null,null,0,null,null,"20 YD RO Boxes","2021-11-01","2021-11-01",null,700,14050,165000,14056,35357.14,129642.86,7857.14,54260,1964.28,"A","Peninsula Sanitation",null,null,"Internal","A","SL",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266499,"P","300 Gallon Carts",390,null,null,null,0,null,null,"Non-Container Audit","2021-11-01","2021-11-01",null,500,14050,6240,14056,1872,4368,416,54260,104,"A","Peninsula Sanitation",null,null,"Internal","A","SL",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266498,"P","95 Gallon Carts",100,null,null,null,0,null,null,"Non-Container Audit","2021-11-01","2021-11-01",null,500,14050,1600,14056,480,1120,106.67,54260,26.67,"A","Peninsula Sanitation",null,null,"Internal","A","SL",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266497,"P","65 Gallon Carts",350,null,null,null,0,null,null,"Non-Container Audit","2021-11-01","2021-11-01",null,500,14050,5600,14056,1680,3920,373.33,54260,93.33,"A","Peninsula Sanitation",null,null,"Internal","A","SL",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266496,"P","90 Gallon Carts",841,null,null,null,0,null,null,"Non-Container Audit","2021-11-01","2021-11-01",null,500,14050,13456,14056,4036.8,9419.2000000000007,897.07,54260,224.27,"A","Peninsula Sanitation",null,null,"Internal","A","SL",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266495,"P","60 Gallon Carts",5128,null,null,null,0,null,null,"Non-Container Audit","2021-11-01","2021-11-01",null,500,14050,82048,14056,24614.400000000001,57433.599999999999,5469.87,54260,1367.47,"A","Peninsula Sanitation",null,null,"Internal","A","SL",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266482,"P","2022 Peterbilt 520 RH Drive (Heil Durapack Automated)",null,null,"3BPDLJ0X1NF112424",null,2022,null,null,"Automated Sideload","2021-11-01","2021-11-01",null,1000,14040,295000,14046,44250,250750,9833.33,51260,2458.33,"A","Peninsula Sanitation",null,18,"Internal","A","SL",null,"WCNX",0,0,18,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266481,"P","2022 Peterbilt 520 RH Drive (Heil Durapack Automated)",null,null,"3BPDLJ0XXNF112423",null,2022,null,null,"Automated Sideload","2021-11-01","2021-11-01",null,1000,14040,295000,14046,44250,250750,9833.33,51260,2458.33,"A","Peninsula Sanitation",null,17,"Internal","A","SL",null,"WCNX",0,0,17,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266480,"P","2019 Peterbilt 567 (Roll-Off)",null,null,"1NPCLP0X9KD618187",null,2019,null,null,"R/O Truck","2021-11-01","2021-11-01",null,700,14040,155000,14046,33214.29,121785.70999999999,7380.95,51260,1845.23,"A","Peninsula Sanitation",null,3,"Internal","A","SL",null,"WCNX",0,0,3,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266479,"P","2019 Peterbilt 567 (Roll-Off)",null,null,"1NPCLP0X0KD618188",null,2019,null,null,"R/O Truck","2021-11-01","2021-11-01",null,700,14040,155000,14046,33214.29,121785.70999999999,7380.95,51260,1845.23,"A","Peninsula Sanitation",null,2,"Internal","A","SL",null,"WCNX",0,0,2,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266478,"P","2016 Peterbilt 320 (Heil Durapack Automated)",null,null,"3BPZLJ0X6GF107244",null,2016,null,null,"Automated Sideload","2021-11-01","2021-11-01",null,400,14040,155000,14046,58125,96875,12916.67,51260,3229.17,"A","Peninsula Sanitation",null,16,"Internal","A","SL",null,"WCNX",0,0,16,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266477,"P","2015 Peterbilt 320 (Heil Durapack Automated)",null,null,"3BPZLJ0XXFF290940",null,2015,null,null,"Automated Sideload","2021-11-01","2021-11-01",null,300,14040,140000,14046,70000.009999999995,69999.990000000005,15555.56,51260,3888.89,"A","Peninsula Sanitation",null,15,"Internal","A","SL",null,"WCNX",0,0,15,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266476,"P","2015 Peterbilt 320 (Heil Durapack Automated)",null,null,"3BPZLJ0X3FF290939",null,2015,null,null,"Automated Sideload","2021-11-01","2021-11-01",null,300,14040,140000,14046,70000.009999999995,69999.990000000005,15555.56,51260,3888.89,"A","Peninsula Sanitation",null,14,"Internal","A","SL",null,"WCNX",0,0,14,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266475,"P","2014 Peterbilt 365 (Roll-Off)",null,null,"1NPSLP0X5ED229417",null,2014,null,null,"R/O Truck","2021-11-01","2021-11-01",null,300,14040,85000,14046,42499.98,42500.02,9444.44,51260,2361.11,"A","Peninsula Sanitation",null,5,"Internal","A","SL",null,"WCNX",0,0,5,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266474,"P","2014 Peterbilt 365 (Roll-Off)",null,null,"1NPSLP0X3ED229416",null,2014,null,null,"R/O Truck","2021-11-01","2021-11-01",null,300,14040,85000,14046,42499.98,42500.02,9444.44,51260,2361.11,"A","Peninsula Sanitation",null,4,"Internal","A","SL",null,"WCNX",0,0,4,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266472,"P","2013 Peterbilt 320 (Heil Durapack Automated)",null,null,"3BPZL50X9DF198593",null,2013,null,null,"Trailer","2021-11-01","2021-11-01",null,300,14040,15000,14046,7500,7500,1666.67,51260,416.67,"A","Peninsula Sanitation",null,61,"Internal","A","SL",null,"WCNX",0,0,12,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266471,"P","2012 Peterbilt 386 (Tractor)",null,null,"1XPHDP9XXCD149351",null,2012,null,null,"Tractor","2021-11-01","2021-11-01",null,300,14040,25000,14046,12500,12500,2777.78,51260,694.45,"A","Peninsula Sanitation",null,8,"Internal","A","SL",null,"WCNX",0,0,8,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266470,"P","2011 Chevrolet 63500 (Box Van w/ Lift Gate)",null,null,"1GB3G4BG8B1155133",null,2011,null,null,"Box Van","2021-11-01","2021-11-01",null,300,14040,15000,14046,7500,7500,1666.67,51260,416.67,"A","Peninsula Sanitation",null,101,"Internal","A","SL",null,"WCNX",0,0,"CT",null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266467,"P","2002 Trail Mobile Dry Van (53' Dry Van)",null,null,"1PTO1AAH229002614",null,2002,null,null,"Box Van","2021-11-01","2021-11-01",null,0,14040,0,14046,0,0,0,51260,0,"A","Peninsula Sanitation",null,null,"Internal","A","NO",null,"WCNX",0,0,"VT2",null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266466,"P","2002 Trail Mobile Dry Van (53' Dry Van)",null,null,"1PTO1AAH529002610",null,2002,null,null,"Box Van","2021-11-01","2021-11-01",null,0,14040,0,14046,0,0,0,51260,0,"A","Peninsula Sanitation",null,null,"Internal","A","NO",null,"WCNX",0,0,"VT1",null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266465,"P","1994 Chevrolet 2500 (Service Truck)",null,null,"1GCFC24K9RE226837",null,1994,null,null,"Service Truck","2021-11-01","2021-11-01",null,0,14040,0,14046,0,{"$f":"S142-U142","v":0},0,51260,0,"A","Peninsula Sanitation",null,52,"Internal","A","NO",null,"WCNX",0,0,"PU3",null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266463,"P","1991 Peerless  (Drop Box Trailer)",null,null,"1PLC02821MTG06770",null,1991,null,null,"Trailer","2021-11-01","2021-11-01",null,0,14040,0,14046,0,0,0,51260,0,"A","Peninsula Sanitation",null,37,"Internal","A","NO",null,"WCNX",0,0,"DBT1",null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266437,"P","C2GW-November Goodwill",null,null,null,null,0,null,null,null,"2021-11-01","2021-11-01",null,0,15110,-1114618.1000000001,15120,0,-1114618.1000000001,0,null,0,"A","Peninsula Sanitation",null,null,"Internal","A","NO",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266433,"P","Docking station (NO SN)",1,null,null,null,0,"AMZN MKTP US S79NJ6SK3",null,null,"2021-11-02","2021-11-02","2178-21-0002-1",300,14110,271.24,14116,135.62,135.62,30.14,70260,7.54,"P",null,4144256,null,"Internal","A","SL",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,266034,"P","HP PROBOOK # : 5CD1421C7P",1,null,null,null,0,"CDW DIR #2178",null,null,"2021-11-02","2021-11-02","2178-21-0002-1",300,14110,1370.38,14116,685.18,685.20000000000016,152.26,70260,38.06,"P",null,"N227774",null,"Internal","A","SL",null,"WCNX",0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,2178,265060,"P","2021 Ford Pickup Truck F250",null,null,"1FTBF2A61MED54365",null,2021,null,null,"Pick Up Truck","2021-11-30","2021-11-30","2178-21-0001",500,14040,43995,14046,12465.25,31529.75,2933,51260,733.25,"P",null,null,"P2","Internal","A","SL",null,"WCNX",0,0,"PU2","Service Truck",{"$f":"MONTH($N147)","v":11},{"$f":"YEAR($N147)","v":2021},{"$f":"$AN147+($Q147/100)","v":2026},{"$f":"$AO147+($AM147/12)","v":2026.9166666666667},{"$f":"IFERROR($S147/($Q147/100)/12,0)","v":733.25},{"$f":"$AQ147*12","v":8799},{"$f":"+IF(AP147<=$AK$9,0,AR147)","v":8799},{"$f":"+IF(AP147<=$AK$10,S147,IF((AN147+(AM147/12))>=$AK$10,0,((S147-((AP147-$AK$10)*12)*AQ147))))","v":4399.5},{"$f":"IF($AS147=0,S147,($AS147+$AT147))","v":13198.5},{"$f":"$S147-$AU147","v":30796.5},"No"]

{"sheet":"Bud Capital Input","index":4,"n_rows":62,"n_cols":58,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Column Definitions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TruckRequest#"]
["PONum_Modified","CurrentProjectNumber_FPS","ProjectNumber_FPS",null,"DeleteFlag","PoNumber","PoItemNumber","ProjectName_FPS","ItemDescription","Explanation",null,"AssetType","AssetSubType","Life","AddReplace","Condition","TruckCenterNum ValueList:RequestedTruckList","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec",null,null,null,"FASNum",null,"ReplacementNotes","EquipmentNum","EquipmentModelYear",null,"FileLink hlink:FileLink"]
[null,null,"CurrentProjectNumber_FPS",null,null,null,"PoItemNumber",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MessageToUser"]
[null,null,null,"Formatting Range"]
[{"$f":"IF(AND(C6<>\"\", B6<>C6),TRUE, FALSE)","v":false},{"$f":"IF(RIGHT(\"0000\"&F6,4)&\"-\"&G6 <> \"0000-\", RIGHT(\"0000\"&F6,4)&\"-\"&G6, \"\")","v":""},null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R6:AC6)","v":0},null,null,null,null,null,null,null,null," ",null,null,{"$f":"IF(Q6=\"\", \"\", Q6)","v":""},{"$f":"IFERROR(VLOOKUP($AQ6,[2]TruckCenterReference!$C$23:$I26,3,FALSE), \"\")","v":""},{"$f":"IF(Q6<>\"\",IF(AR6<>H6,\"Review\",\"ok\"), \"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($AQ6,[2]TruckCenterReference!$C$23:$I26,4,FALSE), \"\")","v":""},{"$f":"IF(Q6=\"\",\"\", IF($AU6<>$P6, \"Fix!\", \"ok\"))","v":""},null,{"$f":"IFERROR(VLOOKUP(M6,SubtypeToTruckType,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($AQ6,[2]TruckCenterReference!$C$23:$I26,6,FALSE), \"\")","v":""},{"$f":"IF(Q6<>\"\",IF(AX6<>AY6,\"Fix!\",\"ok\"), \"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($AQ6,[2]TruckCenterReference!$C$23:$I26,7,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ6,[2]TruckCenterReference!$C$23:$K26,9,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ6,[2]TruckCenterReference!$C$23:$K26,8,FALSE), 0)","v":0},{"$f":"IF(BB6<>0,BB6-AE6-BD6,\"\")","v":""},{"$f":"IF(Q6=\"\",\"\",IF(ABS(BE6)>100,IF(RIGHT(M6,4)=\"Body\",\"Review\",\"Fix!\"),\"ok\"))","v":""}]
[null,null,null,"Report Formulas"]
[null,null,null,null,null,"Pull",null,null,null,null,null,{"$f":"_xll.jFreezePanes(I29,D22)","v":"> jFreezePanes is ready. "}]
[null,null,null,null,"Clear Hash:",{"$f":"_xll.ReportDefaults(\"Pull\",\"Clear\",_xll.PairGroup(_xll.Pair(\"\",H18)))","v":"OK!: ReportDefaults Formula OK [jAction{}]"},null,null,null,null,"CC Query Drill:",{"$f":"_xll.ReportDrill(,\"CCQueryDrill\",_xll.PairGroup(_xll.Pair(K18,\"SummaryLevel\"),_xll.Pair(H24,\"BudYear\"),_xll.Pair(H23,\"DistrictCell\"),_xll.Pair(C30:C79,\"PONumber\"),_xll.Pair(F20:AO20)),\"Drill to CC Query for Change History\")","v":"OK!: ReportDrill 'Drill to CC Query for Change History' Formula OK [jAction{}]"}]
[null,null,null,null,"Pull AssetTypeList:",{"$f":"_xll.ReportRun([2]AssetTypeList!C7,FALSE,\"Pull\")","v":"OK!: ReportRun Formula OK [jAction{}]"}]
[null,null,null,null,"Pull - BudCap:",{"$f":"_xll.ReportRange(\"BudgetCapitalDetailPull\",30:53,C3:BE3,C6:BE6,_xll.Param(H23,H24,H18,N18,K19))","v":"OK!: ReportRange Formula OK [jAction{}]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FASNum","FASDescription"]
[null,null,null,null,"Pull - FAS:",{"$f":"_xll.ReportFixed(\"BudCap1\",AG30:AG53,AG11:AH11,_xll.Param(DetailBudYear, DetailDistrict))","v":"OK!: ReportFixed Formula OK [jAction{}]"}]
[null,null,null,null,null,{"$f":"_xll.ReportRun([2]TruckCenterReference!F16,,\"Pull\")","v":"OK!: ReportRun Formula OK [jAction{}]"}]
[null,null,null,null,null,"Save"]
[null,null,null,null,"Save:",{"$f":"_xll.ReportSave(\"BudgetCapitalDetailSave\",B30:B53,A3:AM3,C4:AO4,_xll.Param(H23,H24,H18,N18))","v":"OK!: ReportSave Formula OK [jAction{}]"}]
[]
[null,null,null,"Hidden Parameters & Notes"]
["Repull?:",{"$f":"IFERROR(OR(A30:A53),FALSE)","v":false},null,null,null,null,"FilterHash:","6D0AC9A9C0621706F1907653EB800A",null,"CC Query Summary Level:","By Change",null,"Exclude Items:",2]
[null,{"$f":"IF(B18=TRUE,\"Save\",\"SkipRePull\")","v":"SkipRePull"},null,null,null,null,null,null,null,"Pull Blank Rows:","Yes"]
[null,null,null,null,null,"For Drill","For Drill","For Drill","For Drill","For Drill",null,"For Drill","For Drill","For Drill","For Drill","For Drill","For Drill","For Drill","For Drill","For Drill","For Drill","For Drill","For Drill","For Drill","For Drill","For Drill","For Drill","For Drill","For Drill",null,"For Drill",null,"For Drill",null,null,"For Drill","For Drill",null,"For Drill",null,"For Drill"]
[null,null,null,"Report Area Below"]
[]
[null,null,null,null,null,null,"Individual District:","2178","(Only one district a time for this input page)"]
[null,null,null,null,null,null,"Budget Year:",2023]
[null,null,null,null,null,null,null,null,null,null,null,"IMPORTANT:  Pull for a single district BEFORE inputting.  This will auto create new lines for you and prepare the page for input.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Recon Check Against Truck Center"]
[null,null,null,null,"CAPITAL DETAIL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Replacement Info",null,null,null,null,null,null,null,null,null,null,null,"Suggested",null,null,"New / Used",null,null,"Truck Type","Truck Type",null,null,"Truck Cost"]
[null,null,null,null,"Delete on Save","PO #","Item","PO Description (Required)","PO Item Description","PO Explanation",null,"Asset Type","SubType","Life","A / R","N / U","Truck Ctr. #","2010-01-31","2010-02-28","2010-03-31","2010-04-30","2010-05-31","2010-06-30","2010-07-31","2010-08-31","2010-09-30","2010-10-31","2010-11-30","2010-12-31",null,"Total",null,"FAS #","FAS Description","Replacement Notes","Site Eq #","Model Year",null,"Folder/File Link",null,"Save Message",null,"Truck #","PO Description","Note",null,"Truck Center","Note*",null,"PO Center","Truck Center","Note",null,"Truck Center","Prior year PO","Prior Year PO$","Variance","Note*"]
[]
[{"$f":"IF(AND(C30<>\"\", B30<>C30),TRUE, FALSE)","v":false},{"$f":"IF(RIGHT(\"0000\"&F30,4)&\"-\"&G30 <> \"0000-\", RIGHT(\"0000\"&F30,4)&\"-\"&G30, \"\")","v":"0001-1"},"0001-1",1,null,1,1,"New Ford Shop Service Truck","New Ford Shop Service Truck","New Ford Shop Service Truck",null,"New Trucks","Service Truck",10,"R","N",17366,0,0,93408,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(R30:AC30)","v":93408},null,266462,null,"Current service truck is unreliable as it is 35 years old. Current mile radius is around 200 miles.",null,1987,null,null," ",null,null,{"$f":"IF(Q30=\"\", \"\", Q30)","v":17366},{"$f":"IFERROR(VLOOKUP($AQ30,[2]TruckCenterReference!$C$23:$I50,3,FALSE), \"\")","v":""},{"$f":"IF(Q30<>\"\",IF(AR30<>H30,\"Review\",\"ok\"), \"\")","v":"Review"},null,{"$f":"IFERROR(VLOOKUP($AQ30,[2]TruckCenterReference!$C$23:$I50,4,FALSE), \"\")","v":""},{"$f":"IF(Q30=\"\",\"\", IF($AU30<>$P30, \"Fix!\", \"ok\"))","v":"Fix!"},null,{"$f":"IFERROR(VLOOKUP(M30,SubtypeToTruckType,2,FALSE),\"\")","v":"Service Truck"},{"$f":"IFERROR(VLOOKUP($AQ30,[2]TruckCenterReference!$C$23:$I50,6,FALSE), \"\")","v":""},{"$f":"IF(Q30<>\"\",IF(AX30<>AY30,\"Fix!\",\"ok\"), \"\")","v":"Fix!"},null,{"$f":"IFERROR(VLOOKUP($AQ30,[2]TruckCenterReference!$C$23:$I50,7,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ30,[2]TruckCenterReference!$C$23:$K50,9,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ30,[2]TruckCenterReference!$C$23:$K50,8,FALSE), 0)","v":0},{"$f":"IF(BB30<>0,BB30-AE30-BD30,\"\")","v":""},{"$f":"IF(Q30=\"\",\"\",IF(ABS(BE30)>100,IF(RIGHT(M30,4)=\"Body\",\"Review\",\"Fix!\"),\"ok\"))","v":{"$error":"#VALUE!"}}]
[false,"0002-1","0002-1",1,null,2,1,"New RO Pup Trailer","New RO Pup Trailer","New RO Pup Trailer",null,"New Trucks","Roll Off Pup Trailer",7,"R","N",16485,0,0,0,0,0,0,0,0,105157,0,0,0,null,105157,null,266463,"1991 Peerless  (Drop Box Trailer)","Curent trailer is constently undergoing repairs and doesn't have ABS brakes, and is used about twice/day.",null,1991,null,null," ",null,null,16485,{"$f":"IFERROR(VLOOKUP($AQ31,[2]TruckCenterReference!$C$23:$I51,3,FALSE), \"\")","v":"New RO Pup Wagon - Dry"},"Review",null,{"$f":"IFERROR(VLOOKUP($AQ31,[2]TruckCenterReference!$C$23:$I51,4,FALSE), \"\")","v":"N"},"ok",null,"Trailer",{"$f":"IFERROR(VLOOKUP($AQ31,[2]TruckCenterReference!$C$23:$I51,6,FALSE), \"\")","v":"Trailer"},"ok",null,{"$f":"IFERROR(VLOOKUP($AQ31,[2]TruckCenterReference!$C$23:$I51,7,FALSE), 0)","v":105157},{"$f":"IFERROR(VLOOKUP($AQ31,[2]TruckCenterReference!$C$23:$K51,9,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ31,[2]TruckCenterReference!$C$23:$K51,8,FALSE), 0)","v":0},0,"ok"]
[false,"0003-1","0003-1",1,null,3,1,"Containers Various","Containers Various","Containers Various",null,"Containers","Other – Metal",12,"R","N",null,0,0,15000,0,35000,0,0,35000,0,0,0,0,null,85000,null,null,null,"Replacement of old rusted roll off boxes. 300 for addt'l commercial use. ",null,null,null,null," ",null,null,"",{"$f":"IFERROR(VLOOKUP($AQ32,[2]TruckCenterReference!$C$23:$I52,3,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ32,[2]TruckCenterReference!$C$23:$I52,4,FALSE), \"\")","v":""},"",null,"",{"$f":"IFERROR(VLOOKUP($AQ32,[2]TruckCenterReference!$C$23:$I52,6,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ32,[2]TruckCenterReference!$C$23:$I52,7,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ32,[2]TruckCenterReference!$C$23:$K52,9,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ32,[2]TruckCenterReference!$C$23:$K52,8,FALSE), 0)","v":0},"",""]
[false,"","",1,null,null,null,"","","",null,"","",null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,null,null,"",null,null,null,null," ",null,null,"",{"$f":"IFERROR(VLOOKUP($AQ33,[2]TruckCenterReference!$C$23:$I53,3,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ33,[2]TruckCenterReference!$C$23:$I53,4,FALSE), \"\")","v":""},"",null,"",{"$f":"IFERROR(VLOOKUP($AQ33,[2]TruckCenterReference!$C$23:$I53,6,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ33,[2]TruckCenterReference!$C$23:$I53,7,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ33,[2]TruckCenterReference!$C$23:$K53,9,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ33,[2]TruckCenterReference!$C$23:$K53,8,FALSE), 0)","v":0},"",""]
[false,"","",1,null,null,null,"","","",null,"","",null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,null,null,"",null,null,null,null," ",null,null,"",{"$f":"IFERROR(VLOOKUP($AQ34,[2]TruckCenterReference!$C$23:$I54,3,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ34,[2]TruckCenterReference!$C$23:$I54,4,FALSE), \"\")","v":""},"",null,"",{"$f":"IFERROR(VLOOKUP($AQ34,[2]TruckCenterReference!$C$23:$I54,6,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ34,[2]TruckCenterReference!$C$23:$I54,7,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ34,[2]TruckCenterReference!$C$23:$K54,9,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ34,[2]TruckCenterReference!$C$23:$K54,8,FALSE), 0)","v":0},"",""]
[false,"","",1,null,null,null,"","","",null,"","",null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,null,null,"",null,null,null,null," ",null,null,"",{"$f":"IFERROR(VLOOKUP($AQ35,[2]TruckCenterReference!$C$23:$I55,3,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ35,[2]TruckCenterReference!$C$23:$I55,4,FALSE), \"\")","v":""},"",null,"",{"$f":"IFERROR(VLOOKUP($AQ35,[2]TruckCenterReference!$C$23:$I55,6,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ35,[2]TruckCenterReference!$C$23:$I55,7,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ35,[2]TruckCenterReference!$C$23:$K55,9,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ35,[2]TruckCenterReference!$C$23:$K55,8,FALSE), 0)","v":0},"",""]
[false,"","",1,null,null,null,"","","",null,"","",null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,null,null,"",null,null,null,null," ",null,null,"",{"$f":"IFERROR(VLOOKUP($AQ36,[2]TruckCenterReference!$C$23:$I56,3,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ36,[2]TruckCenterReference!$C$23:$I56,4,FALSE), \"\")","v":""},"",null,"",{"$f":"IFERROR(VLOOKUP($AQ36,[2]TruckCenterReference!$C$23:$I56,6,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ36,[2]TruckCenterReference!$C$23:$I56,7,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ36,[2]TruckCenterReference!$C$23:$K56,9,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ36,[2]TruckCenterReference!$C$23:$K56,8,FALSE), 0)","v":0},"",""]
[false,"","",1,null,null,null,"","","",null,"","",null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,null,null,"",null,null,null,null," ",null,null,"",{"$f":"IFERROR(VLOOKUP($AQ37,[2]TruckCenterReference!$C$23:$I57,3,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ37,[2]TruckCenterReference!$C$23:$I57,4,FALSE), \"\")","v":""},"",null,"",{"$f":"IFERROR(VLOOKUP($AQ37,[2]TruckCenterReference!$C$23:$I57,6,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ37,[2]TruckCenterReference!$C$23:$I57,7,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ37,[2]TruckCenterReference!$C$23:$K57,9,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ37,[2]TruckCenterReference!$C$23:$K57,8,FALSE), 0)","v":0},"",""]
[false,"","",1,null,null,null,"","","",null,"","",null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,null,null,"",null,null,null,null," ",null,null,"",{"$f":"IFERROR(VLOOKUP($AQ38,[2]TruckCenterReference!$C$23:$I58,3,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ38,[2]TruckCenterReference!$C$23:$I58,4,FALSE), \"\")","v":""},"",null,"",{"$f":"IFERROR(VLOOKUP($AQ38,[2]TruckCenterReference!$C$23:$I58,6,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ38,[2]TruckCenterReference!$C$23:$I58,7,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ38,[2]TruckCenterReference!$C$23:$K58,9,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ38,[2]TruckCenterReference!$C$23:$K58,8,FALSE), 0)","v":0},"",""]
[false,"","",1,null,null,null,"","","",null,"","",null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,null,null,"",null,null,null,null," ",null,null,"",{"$f":"IFERROR(VLOOKUP($AQ39,[2]TruckCenterReference!$C$23:$I59,3,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ39,[2]TruckCenterReference!$C$23:$I59,4,FALSE), \"\")","v":""},"",null,"",{"$f":"IFERROR(VLOOKUP($AQ39,[2]TruckCenterReference!$C$23:$I59,6,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ39,[2]TruckCenterReference!$C$23:$I59,7,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ39,[2]TruckCenterReference!$C$23:$K59,9,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ39,[2]TruckCenterReference!$C$23:$K59,8,FALSE), 0)","v":0},"",""]
[false,"","",1,null,null,null,"","","",null,"","",null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,null,null,"",null,null,null,null," ",null,null,"",{"$f":"IFERROR(VLOOKUP($AQ40,[2]TruckCenterReference!$C$23:$I60,3,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ40,[2]TruckCenterReference!$C$23:$I60,4,FALSE), \"\")","v":""},"",null,"",{"$f":"IFERROR(VLOOKUP($AQ40,[2]TruckCenterReference!$C$23:$I60,6,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ40,[2]TruckCenterReference!$C$23:$I60,7,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ40,[2]TruckCenterReference!$C$23:$K60,9,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ40,[2]TruckCenterReference!$C$23:$K60,8,FALSE), 0)","v":0},"",""]
[false,"","",1,null,null,null,"","","",null,"","",null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,null,null,"",null,null,null,null," ",null,null,"",{"$f":"IFERROR(VLOOKUP($AQ41,[2]TruckCenterReference!$C$23:$I61,3,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ41,[2]TruckCenterReference!$C$23:$I61,4,FALSE), \"\")","v":""},"",null,"",{"$f":"IFERROR(VLOOKUP($AQ41,[2]TruckCenterReference!$C$23:$I61,6,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ41,[2]TruckCenterReference!$C$23:$I61,7,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ41,[2]TruckCenterReference!$C$23:$K61,9,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ41,[2]TruckCenterReference!$C$23:$K61,8,FALSE), 0)","v":0},"",""]
[false,"","",1,null,null,null,"","","",null,"","",null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,null,null,"",null,null,null,null," ",null,null,"",{"$f":"IFERROR(VLOOKUP($AQ42,[2]TruckCenterReference!$C$23:$I62,3,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ42,[2]TruckCenterReference!$C$23:$I62,4,FALSE), \"\")","v":""},"",null,"",{"$f":"IFERROR(VLOOKUP($AQ42,[2]TruckCenterReference!$C$23:$I62,6,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ42,[2]TruckCenterReference!$C$23:$I62,7,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ42,[2]TruckCenterReference!$C$23:$K62,9,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ42,[2]TruckCenterReference!$C$23:$K62,8,FALSE), 0)","v":0},"",""]
[false,"","",1,null,null,null,"","","",null,"","",null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,null,null,"",null,null,null,null," ",null,null,"",{"$f":"IFERROR(VLOOKUP($AQ43,[2]TruckCenterReference!$C$23:$I63,3,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ43,[2]TruckCenterReference!$C$23:$I63,4,FALSE), \"\")","v":""},"",null,"",{"$f":"IFERROR(VLOOKUP($AQ43,[2]TruckCenterReference!$C$23:$I63,6,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ43,[2]TruckCenterReference!$C$23:$I63,7,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ43,[2]TruckCenterReference!$C$23:$K63,9,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ43,[2]TruckCenterReference!$C$23:$K63,8,FALSE), 0)","v":0},"",""]
[false,"","",1,null,null,null,"","","",null,"","",null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,null,null,"",null,null,null,null," ",null,null,"",{"$f":"IFERROR(VLOOKUP($AQ44,[2]TruckCenterReference!$C$23:$I64,3,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ44,[2]TruckCenterReference!$C$23:$I64,4,FALSE), \"\")","v":""},"",null,"",{"$f":"IFERROR(VLOOKUP($AQ44,[2]TruckCenterReference!$C$23:$I64,6,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ44,[2]TruckCenterReference!$C$23:$I64,7,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ44,[2]TruckCenterReference!$C$23:$K64,9,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ44,[2]TruckCenterReference!$C$23:$K64,8,FALSE), 0)","v":0},"",""]
[false,"","",1,null,null,null,"","","",null,"","",null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,null,null,"",null,null,null,null," ",null,null,"",{"$f":"IFERROR(VLOOKUP($AQ45,[2]TruckCenterReference!$C$23:$I65,3,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ45,[2]TruckCenterReference!$C$23:$I65,4,FALSE), \"\")","v":""},"",null,"",{"$f":"IFERROR(VLOOKUP($AQ45,[2]TruckCenterReference!$C$23:$I65,6,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ45,[2]TruckCenterReference!$C$23:$I65,7,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ45,[2]TruckCenterReference!$C$23:$K65,9,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ45,[2]TruckCenterReference!$C$23:$K65,8,FALSE), 0)","v":0},"",""]
[false,"","",1,null,null,null,"","","",null,"","",null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,null,null,"",null,null,null,null," ",null,null,"",{"$f":"IFERROR(VLOOKUP($AQ46,[2]TruckCenterReference!$C$23:$I66,3,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ46,[2]TruckCenterReference!$C$23:$I66,4,FALSE), \"\")","v":""},"",null,"",{"$f":"IFERROR(VLOOKUP($AQ46,[2]TruckCenterReference!$C$23:$I66,6,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ46,[2]TruckCenterReference!$C$23:$I66,7,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ46,[2]TruckCenterReference!$C$23:$K66,9,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ46,[2]TruckCenterReference!$C$23:$K66,8,FALSE), 0)","v":0},"",""]
[false,"","",1,null,null,null,"","","",null,"","",null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,null,null,"",null,null,null,null," ",null,null,"",{"$f":"IFERROR(VLOOKUP($AQ47,[2]TruckCenterReference!$C$23:$I67,3,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ47,[2]TruckCenterReference!$C$23:$I67,4,FALSE), \"\")","v":""},"",null,"",{"$f":"IFERROR(VLOOKUP($AQ47,[2]TruckCenterReference!$C$23:$I67,6,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ47,[2]TruckCenterReference!$C$23:$I67,7,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ47,[2]TruckCenterReference!$C$23:$K67,9,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ47,[2]TruckCenterReference!$C$23:$K67,8,FALSE), 0)","v":0},"",""]
[false,"","",1,null,null,null,"","","",null,"","",null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,null,null,"",null,null,null,null," ",null,null,"",{"$f":"IFERROR(VLOOKUP($AQ48,[2]TruckCenterReference!$C$23:$I68,3,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ48,[2]TruckCenterReference!$C$23:$I68,4,FALSE), \"\")","v":""},"",null,"",{"$f":"IFERROR(VLOOKUP($AQ48,[2]TruckCenterReference!$C$23:$I68,6,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ48,[2]TruckCenterReference!$C$23:$I68,7,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ48,[2]TruckCenterReference!$C$23:$K68,9,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ48,[2]TruckCenterReference!$C$23:$K68,8,FALSE), 0)","v":0},"",""]
[false,"","",1,null,null,null,"","","",null,"","",null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,null,null,"",null,null,null,null," ",null,null,"",{"$f":"IFERROR(VLOOKUP($AQ49,[2]TruckCenterReference!$C$23:$I69,3,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ49,[2]TruckCenterReference!$C$23:$I69,4,FALSE), \"\")","v":""},"",null,"",{"$f":"IFERROR(VLOOKUP($AQ49,[2]TruckCenterReference!$C$23:$I69,6,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ49,[2]TruckCenterReference!$C$23:$I69,7,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ49,[2]TruckCenterReference!$C$23:$K69,9,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ49,[2]TruckCenterReference!$C$23:$K69,8,FALSE), 0)","v":0},"",""]
[false,"","",1,null,null,null,"","","",null,"","",null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,null,null,"",null,null,null,null," ",null,null,"",{"$f":"IFERROR(VLOOKUP($AQ50,[2]TruckCenterReference!$C$23:$I70,3,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ50,[2]TruckCenterReference!$C$23:$I70,4,FALSE), \"\")","v":""},"",null,"",{"$f":"IFERROR(VLOOKUP($AQ50,[2]TruckCenterReference!$C$23:$I70,6,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ50,[2]TruckCenterReference!$C$23:$I70,7,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ50,[2]TruckCenterReference!$C$23:$K70,9,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ50,[2]TruckCenterReference!$C$23:$K70,8,FALSE), 0)","v":0},"",""]
[false,"","",1,null,null,null,"","","",null,"","",null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,null,null,"",null,null,null,null," ",null,null,"",{"$f":"IFERROR(VLOOKUP($AQ51,[2]TruckCenterReference!$C$23:$I71,3,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ51,[2]TruckCenterReference!$C$23:$I71,4,FALSE), \"\")","v":""},"",null,"",{"$f":"IFERROR(VLOOKUP($AQ51,[2]TruckCenterReference!$C$23:$I71,6,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ51,[2]TruckCenterReference!$C$23:$I71,7,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ51,[2]TruckCenterReference!$C$23:$K71,9,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ51,[2]TruckCenterReference!$C$23:$K71,8,FALSE), 0)","v":0},"",""]
[false,"","",1,null,null,null,"","","",null,"","",null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,null,null,"",null,null,null,null," ",null,null,"",{"$f":"IFERROR(VLOOKUP($AQ52,[2]TruckCenterReference!$C$23:$I72,3,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ52,[2]TruckCenterReference!$C$23:$I72,4,FALSE), \"\")","v":""},"",null,"",{"$f":"IFERROR(VLOOKUP($AQ52,[2]TruckCenterReference!$C$23:$I72,6,FALSE), \"\")","v":""},"",null,{"$f":"IFERROR(VLOOKUP($AQ52,[2]TruckCenterReference!$C$23:$I72,7,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ52,[2]TruckCenterReference!$C$23:$K72,9,FALSE), 0)","v":0},{"$f":"IFERROR(VLOOKUP($AQ52,[2]TruckCenterReference!$C$23:$K72,8,FALSE), 0)","v":0},"",""]
[null,null,null,null,"End of List (save and re-pull for at least 5 more rows)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL CAPITAL",{"$f":"SUM(R29:R53)","v":0},0,108408,0,35000,0,0,35000,105157,0,0,0,null,{"$f":"SUM(AE29:AE53)","v":283565}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Item","Cost","Adjustment","Adjusted Cost","Useful Lefe","Test Year Depreciation","Ending Accum Depreciation","Average Investment"]
[null,null,null,null,null,null,null,null,null,null,null,"Service Truck",{"$f":"+AE30","v":93408},{"$f":"-M57","v":-93408},{"$f":"+M57+N57","v":0},{"$f":"+N30","v":10},{"$f":"+O57/P57","v":0},{"$f":"+Q57","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,"Roll-off Trailer",{"$f":"+AE31","v":105157},0,105157,{"$f":"+N31","v":7},{"$f":"+O58/P58","v":15022.428571428571},{"$f":"+Q58","v":15022.428571428571},{"$f":"+O58-R58","v":90134.571428571435}]
[null,null,null,null,null,null,null,null,null,null,null,"Drop Boxes",{"$f":"+SUMIF($M$30:$M$52,L59,$AE$30:$AE$52)","v":0},{"$f":"17900+15000","v":32900},32900,12,{"$f":"+O59/P59","v":2741.6666666666665},2741.6666666666665,{"$f":"+O59-R59","v":30158.333333333332}]
[null,null,null,null,null,null,null,null,null,null,null,"Garbage Carts",0,{"$f":"38050+14050","v":52100},52100,7,{"$f":"+O60/P60","v":7442.8571428571431},7442.8571428571431,44657.142857142855]
[null,null,null,null,null,null,null,null,null,null,null,"Containers",{"$f":"+AE32","v":85000},{"$f":"+-N59-N60","v":-85000},0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O58:O61)","v":190157},null,{"$f":"SUM(Q58:Q61)","v":25206.952380952382},{"$f":"SUM(R58:R61)","v":25206.952380952382},{"$f":"SUM(S58:S61)","v":164950.04761904763}]

{"sheet":"Pre Acquisition Assets","index":5,"n_rows":191,"n_cols":29,"rows_kept":191,"cut":false,"hidden":false,"merged":[]}
[null,"Peninsula Sanitation Services, Inc.",null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Test Period Beg. Month"]
[null,"Regulatory Depreciation Schedule",null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Test Period End Month"]
[null,"2020-09-30",null,null,null,null,null,null,null,null,null,null,null,null,null,2022,"First Year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,"Second year"]
[null,"$400k is the over reconized revenue ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+P4+(P2/12)","v":2023.3333333333333},"Test Period End Mo/Yr"]
[null,"Prior year adjustment for $400k February",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+P3+(P1/12)","v":2022.4166666666667},"Test Period Beg. Mo/Yr"]
[null,"Livermore ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total","Beginning","Allocated",null,"Allocated","Ending"]
[null,null,null,"Date in Service",null,"Salvage",null,null,"Year",null,null,"Year/Mo",null,null,null,null,null,"Disposal","Total",null,"Allocated","Accumulated","Accumulated","Branch","Accum.","Accumulated"]
[null,null,null,null,null,"Value","Method","Life","Fully","Disposal",null,"Fully","Asset","Asset","Depreciable","Monthly","Test year","Year","Test yr.","%","Test year","Depreciation","Depreciation","Allo.","Depr.","Depreciation","Average"]
["Depreciation","DESCRIPTION","Waste Connections Equipment Type","Year","Mo.","%",null,null,"Depreciated","  Yr."," Mo.","Depreciated","Cost","Disposal","Cost","Depreciation","Depreciation","Depr.","Depr.","Allo.","Depr.","2019-10-01",39814,"%",39814,"2020-09-30","Investment"]
["Schedule No."]
[null,"GARBAGE COLLECTION EQUIPMENT"]
[]
[]
["53-a","1991 Peerless trailer ","Roll-off Truck",1998,9,0,"SL",5,{"$f":"+D15+H15","v":2003},null,null,{"$f":"+I15+E15/12","v":2003.75},{"$f":"7100-2343","v":4757},null,{"$f":"M15-M15*F15","v":4757},{"$f":"O15/H15/12","v":79.283333333333331},{"$f":"+IF(L15<=$P$5,0,P15*12)","v":0},{"$f":"IF(N15=0,0,IF((AND((AF15>=AE15),(AF15<=AD15))),((AF15-AE15)*12)*P15,0))","v":0},{"$f":"IF(R15>0,R15,Q15)","v":0},1,{"$f":"T15*SUM(Q15:R15)","v":0},{"$f":"+IF(L15<=$P$6,M15,IF((D15+(E15/12))>=$P$6,0,((M15-((L15-$P$6)*12)*P15))))","v":4757},{"$f":"V15*T15","v":4757},1,{"$f":"W15*X15","v":4757},{"$f":"+IF(U15=0,M15,Y15+U15)","v":4757},{"$f":"+O15-Z15","v":0}]
["53-SV","1991 Peerless trailer - Salvage Value","Roll-off Truck",2017,12,0,"SL",5,{"$f":"+D16+H16","v":2022},null,null,2023,2343,null,{"$f":"M16-M16*F16","v":2343},{"$f":"O16/H16/12","v":39.050000000000004},{"$f":"+IF(L16<=$P$5,0,P16*12)","v":0},{"$f":"IF(N16=0,0,IF((AND((AF16>=AE16),(AF16<=AD16))),((AF16-AE16)*12)*P16,0))","v":0},{"$f":"IF(R16>0,R16,Q16)","v":0},1,{"$f":"T16*SUM(Q16:R16)","v":0},{"$f":"+IF(L16<=$P$6,M16,IF((D16+(E16/12))>=$P$6,0,((M16-((L16-$P$6)*12)*P16))))","v":2069.6500000000356},{"$f":"V16*T16","v":2069.6500000000356},1,{"$f":"W16*X16","v":2069.6500000000356},{"$f":"+IF(U16=0,M16,Y16+U16)","v":2343},{"$f":"+O16-Z16","v":0}]
["67-a","94 Chev Service Truck ","Service Truck",2003,10,0,"SL",5,2008,null,null,2008.8333333333333,{"$f":"13900-4587","v":9313},null,9313,155.21666666666667,0,0,0,1,0,9313,9313,1,9313,9313,0]
["67-SV","94 Chev Service Truck - Salvage Value","Service Truck",2017,12,0,"SL",5,{"$f":"+D18+H18","v":2022},null,null,2023,4587,null,4587,76.45,0,0,0,1,0,4051.8500000000695,4051.8500000000695,1,4051.8500000000695,4587,0]
["68-a","94 Chev Service Truck Body","Service Truck",2003,10,0,"SL",5,2008,null,null,2008.8333333333333,{"$f":"8298-2738","v":5560},null,5560,92.666666666666671,0,0,0,1,0,5560,5560,1,5560,5560,0]
["68-SV","94 Chev Service Truck Body-Salvage Value","Service Truck",2017,12,0,"SL",5,{"$f":"+D20+H20","v":2022},null,null,2023,2738,null,2738,45.633333333333333,0,0,0,1,0,2418.566666666708,2418.566666666708,1,2418.566666666708,2738,0]
["96-a","2013 Peterbilt 320 #12","Garbage Trucks",2012,9,0,"SL",7,2019,null,null,2019.75,{"$f":"152150-30430","v":121720},null,121720,1449.047619047619,0,0,0,1,0,121720,121720,1,121720,121720,0]
["96-SV","2013 Peterbilt 320 #12-Salvage Value","Garbage Trucks",2017,12,0,"SL",7,{"$f":"+D22+H22","v":2024},null,null,2025,30430,null,30430,362.26190476190476,4347.1428571428569,0,4347.1428571428569,1,4347.1428571428569,19199.880952381282,19199.880952381282,1,19199.880952381282,23547.023809524137,6882.9761904758634]
["101-a","DP 7000 28yd Dump #12","Garbage Trucks",2013,4,0,"SL",7,2020,null,null,2020.3333333333333,{"$f":"137629-27526","v":110103},null,110103,1310.75,0,0,0,1,0,110103,110103,1,110103,110103,0]
["101-SV","DP 7000 28yd Dump #12-Salvage Value","Garbage Trucks",2017,12,0,"SL",7,{"$f":"+D24+H24","v":2024},null,null,2025,27526,null,27526,327.6904761904762,3932.2857142857147,0,3932.2857142857147,1,3932.2857142857147,17367.595238095535,17367.595238095535,1,17367.595238095535,21299.880952381249,6226.1190476187512]
["102-a","2014 Peterbilt 365 #4","Roll-off Truck",2013,7,0,"SL",7,2020,null,null,2020.5833333333333,{"$f":"138938-27788","v":111150},null,111150,1323.2142857142858,0,0,0,1,0,111150,111150,1,111150,111150,0]
["102-SV","2014 Peterbilt 365 #4-Salvage Value","Roll-off Truck",2017,12,0,"SL",7,{"$f":"+D26+H26","v":2024},null,null,2025,27788,null,27788,330.8095238095238,3969.7142857142853,0,3969.7142857142853,1,3969.7142857142853,17532.904761905062,17532.904761905062,1,17532.904761905062,21502.619047619348,6285.3809523806522]
["103-a","2014 Peterbilt 365 #5","Roll-off Truck",2013,8,0,"SL",7,2020,null,null,2020.6666666666667,{"$f":"138938-27788","v":111150},null,111150,1323.2142857142858,0,0,0,1,0,111150,111150,1,111150,111150,0]
["103-SV","2014 Peterbilt 365 #5-Salvage Value","Roll-off Truck",2017,12,0,"SL",7,{"$f":"+D28+H28","v":2024},null,null,2025,27788,null,27788,330.8095238095238,3969.7142857142853,0,3969.7142857142853,1,3969.7142857142853,17532.904761905062,17532.904761905062,1,17532.904761905062,21502.619047619348,6285.3809523806522]
["104-a","#5 Rolloff Boom","Roll-off Truck",2013,7,0,"SL",7,2020,null,null,2020.5833333333333,{"$f":"71455-14291","v":57164},null,57164,680.52380952380952,0,0,0,1,0,57164,57164,1,57164,57164,0]
["104-SV","#5 Rolloff Boom-Salvage Value ","Roll-off Truck",2017,12,0,"SL",7,{"$f":"+D30+H30","v":2024},null,null,2025,14291,null,14291,170.13095238095238,2041.5714285714284,0,2041.5714285714284,1,2041.5714285714284,9016.9404761906299,9016.9404761906299,1,9016.9404761906299,11058.511904762057,3232.4880952379426]
["105-a","#4 Rolloff Boom","Roll-off Truck",2013,8,0,"SL",7,2020,null,null,2020.6666666666667,{"$f":"74027-14805","v":59222},null,59222,705.02380952380952,0,0,0,1,0,59222,59222,1,59222,59222,0]
["105-SV","#4 Rolloff Boom-Salvage Value","Roll-off Truck",2017,12,0,"SL",7,{"$f":"+D32+H32","v":2024},null,null,2025,14805,null,14805,176.25,2115,0,2115,1,2115,9341.2500000001601,9341.2500000001601,1,9341.2500000001601,11456.25000000016,3348.7499999998399]
["106-a","2014 Peterbilt 320 #14","Garbage Trucks",2014,10,0,"SL",7,2021,null,null,2021.8333333333333,{"$f":"152700-30540","v":122160},null,122160,1454.2857142857144,0,0,0,1,0,122160,122160,1,122160,122160,0]
["106-SV","2014 Peterbilt 320 #14-Salvage Value","Garbage Trucks",2017,12,0,"SL",7,{"$f":"+D34+H34","v":2024},null,null,2025,30540,null,30540,363.57142857142861,4362.8571428571431,0,4362.8571428571431,1,4362.8571428571431,19269.285714286045,19269.285714286045,1,19269.285714286045,23632.14285714319,6907.8571428568102]
["108-a","DP 7000 28yd Dump #14","Garbage Trucks",2014,12,0,"SL",7,2021,null,null,2022,{"$f":"153776-30755","v":123021},null,123021,1464.5357142857144,0,0,0,1,0,123021,123021,1,123021,123021,0]
["108-SV","DP 7000 28yd Dump #14-Salvage Value","Garbage Trucks",2017,12,0,"SL",7,{"$f":"+D36+H36","v":2024},null,null,2025,30755,null,30755,366.13095238095235,4393.5714285714284,0,4393.5714285714284,1,4393.5714285714284,19404.940476190808,19404.940476190808,1,19404.940476190808,23798.511904762236,6956.4880952377644]
["110-a","2015 Peterbilt 320 #15","Garbage Trucks",2015,4,0,"SL",7,2022,null,null,2022.3333333333333,{"$f":"152827-30565","v":122262},null,122262,1455.5,0,0,0,1,0,122262,122262,1,122262,122262,0]
["110-SV","2015 Peterbilt 320 #15-Salvage Value","Garbage Trucks",2017,12,0,"SL",7,{"$f":"+D38+H38","v":2024},null,null,2025,30565,null,30565,363.86904761904765,4366.4285714285716,0,4366.4285714285716,1,4366.4285714285716,19285.059523809854,19285.059523809854,1,19285.059523809854,23651.488095238426,6913.5119047615735]
["111-a","2016 Peterbilt 320 #16","Garbage Trucks",2015,9,0,"SL",7,2022,null,null,2022.75,{"$f":"152827-30565","v":122262},null,122262,1455.5,0,0,0,1,0,116440.00000000132,116440.00000000132,1,116440.00000000132,122262,0]
["111-SV","2016 Peterbilt 320 #16-Salvage Value","Garbage Trucks",2017,12,0,"SL",7,{"$f":"+D40+H40","v":2024},null,null,2025,30565,null,30565,363.86904761904765,4366.4285714285716,0,4366.4285714285716,1,4366.4285714285716,19285.059523809854,19285.059523809854,1,19285.059523809854,23651.488095238426,6913.5119047615735]
["112-a","Heil Refuse Body DP7000 #15","Garbage Trucks",2015,5,0,"SL",7,2022,null,null,2022.4166666666667,{"$f":"153776-30755","v":123021},null,123021,1464.5357142857144,0,0,0,1,0,123021,123021,1,123021,123021,0]
["112-SV","Heil Refuse Body DP7000 #15-Salvage Value","Garbage Trucks",2017,12,0,"SL",7,{"$f":"+D42+H42","v":2024},null,null,2025,30755,null,30755,366.13095238095235,4393.5714285714284,0,4393.5714285714284,1,4393.5714285714284,19404.940476190808,19404.940476190808,1,19404.940476190808,23798.511904762236,6956.4880952377644]
["115-a","Heil Refuse Body DP7000 #16","Garbage Trucks",2015,12,0,"SL",7,2022,null,null,2023,{"$f":"157400-31480","v":125920},null,125920,1499.047619047619,0,0,0,1,0,115426.66666666802,115426.66666666802,1,115426.66666666802,125920,0]
["115-SV","Heil Refuse Body DP7000 #16-Salvage Value","Garbage Trucks",2017,12,0,"SL",7,2024,null,null,2025,31480,null,31480,374.76190476190476,4497.1428571428569,0,4497.1428571428569,1,4497.1428571428569,19862.380952381292,19862.380952381292,1,19862.380952381292,24359.523809524151,7120.4761904758489]
["120-a","2019 Peterbuilt #2","Roll-off Truck",2018,7,0,"SL",7,2025,null,null,2025.5833333333333,134223,null,134223,1597.8928571428571,19174.714285714286,0,19174.714285714286,1,19174.714285714286,73503.071428574331,73503.071428574331,1,73503.071428574331,92677.785714288621,41545.214285711379]
["121-a","2019 Peterbuilt #3","Roll-off Truck",2018,7,0,"SL",7,2025,null,null,2025.5833333333333,134223,null,134223,1597.8928571428571,19174.714285714286,0,19174.714285714286,1,19174.714285714286,73503.071428574331,73503.071428574331,1,73503.071428574331,92677.785714288621,41545.214285711379]
["125-a","Roll - Off #3","Roll-off Truck",2018,11,0,"SL",7,2025,null,null,2025.9166666666667,73667,null,73667,876.9880952380953,10523.857142857143,0,10523.857142857143,1,10523.857142857143,36833.5,36833.5,1,36833.5,47357.357142857145,26309.642857142855]
["126-a","Roll - Off #2","Roll-off Truck",2018,11,0,"SL",7,2025,null,null,2025.9166666666667,73667,null,73667,876.9880952380953,10523.857142857143,0,10523.857142857143,1,10523.857142857143,36833.5,36833.5,1,36833.5,47357.357142857145,26309.642857142855]
[null,"2022 Peterbilt RH Drive-Side Loader","Garbage Trucks",2019,10,0,"SL",7,{"$f":"+D49+H49","v":2026},null,null,2026.8333333333333,344974,null,344974,4106.833333333333,49282,0,49282,1,49282,127311.83333334082,127311.83333334082,1,127311.83333334082,176593.83333334082,168380.16666665918]
[null,"2022 Bodies for Peterbilt RH Drive-Side Loader","Garbage Trucks",2019,10,0,"SL",7,{"$f":"+D50+H50","v":2026},null,null,2026.8333333333333,320170,null,320170,3811.5476190476188,45738.571428571428,0,45738.571428571428,1,45738.571428571428,118157.97619048314,118157.97619048314,1,118157.97619048314,163896.54761905456,156273.45238094544]
["STAFF CAPITALIZED ITEMS - LAST RATE CASE"]
[]
[null,"Truck #3-Differental Replacement","Roll-off Truck",2013,7,0,"SL",5,{"$f":"+D53+H53","v":2018},null,null,2018.5833333333333,2313,null,{"$f":"M53-M53*F53","v":2313},{"$f":"O53/H53/12","v":38.550000000000004},{"$f":"+IF(L53<=$P$5,0,P53*12)","v":0},{"$f":"IF(N53=0,0,IF((AND((AF53>=AE53),(AF53<=AD53))),((AF53-AE53)*12)*P53,0))","v":0},{"$f":"IF(R53>0,R53,Q53)","v":0},1,{"$f":"T53*SUM(Q53:R53)","v":0},{"$f":"+IF(L53<=$P$6,M53,IF((D53+(E53/12))>=$P$6,0,((M53-((L53-$P$6)*12)*P53))))","v":2313},{"$f":"V53*T53","v":2313},1,{"$f":"W53*X53","v":2313},{"$f":"+IF(U53=0,M53,Y53+U53)","v":2313},{"$f":"+O53-Z53","v":0}]
[null,"Trucks #4 & 5 Painting","Roll-off Truck",2013,7,0,"SL",5,{"$f":"+D54+H54","v":2018},null,null,2018.5833333333333,3981,null,3981,66.350000000000009,0,0,0,1,0,3981,3981,1,3981,3981,0]
[null,"Sub-Total - Collection Equipment",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M15:M54)","v":2752959},null,{"$f":"SUM(O15:O54)","v":2752959},32942.807142857149,201173.14285714284,0,201173.14285714284,null,201173.14285714284,1999949.8285714556,1999949.8285714556,null,1999949.8285714556,2218566.2380952616,534392.76190473814]
[]
[null,"BUILDINGS"]
[1,"Building","Structure - Hauling Only",1998,5,null,"SL",30,{"$f":"+D58+H58","v":2028},null,null,{"$f":"+I58+E58/12","v":2028.4166666666667},336581,null,{"$f":"M58-M58*F58","v":336581},{"$f":"O58/H58/12","v":934.94722222222219},{"$f":"+IF(L58<=$P$5,0,P58*12)","v":11219.366666666667},{"$f":"IF(N58=0,0,IF((AND((AF58>=AE58),(AF58<=AD58))),((AF58-AE58)*12)*P58,0))","v":0},{"$f":"IF(R58>0,R58,Q58)","v":11219.366666666667},1,{"$f":"T58*SUM(Q58:R58)","v":11219.366666666667},{"$f":"+IF(L58<=$P$6,M58,IF((D58+(E58/12))>=$P$6,0,((M58-((L58-$P$6)*12)*P58))))","v":269264.8},{"$f":"V58*T58","v":269264.8},1,{"$f":"W58*X58","v":269264.8},{"$f":"+IF(U58=0,M58,Y58+U58)","v":280484.16666666663},{"$f":"+O58-Z58","v":56096.833333333372}]
[54,"Leasehold Improvement","Leasehold Improvements",1995,12,null,"SL",15,{"$f":"+D59+H59","v":2010},null,null,2011,112,null,112,0.62222222222222223,0,0,0,1,0,112,112,1,112,112,0]
[91,"Paving","Leasehold Improvements",2003,5,null,"SL",15,{"$f":"+D60+H60","v":2018},null,null,2018.4166666666667,16759,null,16759,93.105555555555554,0,0,0,1,0,16759,16759,1,16759,16759,0]
[125,"Truck Cover Building","Structure - Hauling Only",2009,7,null,"SL",30,{"$f":"+D61+H61","v":2039},null,null,2039.5833333333333,230079,null,230079,639.10833333333335,7669.3,0,7669.3,1,7669.3,98422.683333334484,98422.683333334484,1,98422.683333334484,106091.98333333449,123987.01666666551]
[null,"Sub-Total - Buildings",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M58:M61)","v":583531},null,{"$f":"SUM(O58:O61)","v":583531},1667.7833333333333,18888.666666666668,0,18888.666666666668,null,18888.666666666668,384558.48333333444,384558.48333333444,null,384558.48333333444,403447.15000000113,180083.84999999887]
[]
[null,"CONTAINERS AND DROP BOXES"]
[8,"2 20yd drop boxes ","Drop Boxes",1996,2,null,"SL",10,{"$f":"+D65+H65","v":2006},null,null,{"$f":"+I65+E65/12","v":2006.1666666666667},8570,null,{"$f":"M65-M65*F65","v":8570},{"$f":"O65/H65/12","v":71.416666666666671},{"$f":"+IF(L65<=$P$5,0,P65*12)","v":0},{"$f":"IF(N65=0,0,IF((AND((AF65>=AE65),(AF65<=AD65))),((AF65-AE65)*12)*P65,0))","v":0},{"$f":"IF(R65>0,R65,Q65)","v":0},1,{"$f":"T65*SUM(Q65:R65)","v":0},{"$f":"+IF(L65<=$P$6,M65,IF((D65+(E65/12))>=$P$6,0,((M65-((L65-$P$6)*12)*P65))))","v":8570},{"$f":"V65*T65","v":8570},1,{"$f":"W65*X65","v":8570},{"$f":"+IF(U65=0,M65,Y65+U65)","v":8570},{"$f":"+O65-Z65","v":0}]
[25,"3-30yd Drop boxes ","Drop Boxes",1994,2,null,"SL",10,{"$f":"+D66+H66","v":2004},null,null,{"$f":"+I66+E66/12","v":2004.1666666666667},8786,null,{"$f":"M66-M66*F66","v":8786},{"$f":"O66/H66/12","v":73.216666666666669},{"$f":"+IF(L66<=$P$5,0,P66*12)","v":0},{"$f":"IF(N66=0,0,IF((AND((AF66>=AE66),(AF66<=AD66))),((AF66-AE66)*12)*P66,0))","v":0},{"$f":"IF(R66>0,R66,Q66)","v":0},1,{"$f":"T66*SUM(Q66:R66)","v":0},{"$f":"+IF(L66<=$P$6,M66,IF((D66+(E66/12))>=$P$6,0,((M66-((L66-$P$6)*12)*P66))))","v":8786},{"$f":"V66*T66","v":8786},1,{"$f":"W66*X66","v":8786},{"$f":"+IF(U66=0,M66,Y66+U66)","v":8786},{"$f":"+O66-Z66","v":0}]
[26,"3-30yd Boxes ","Drop Boxes",1994,7,null,"SL",10,{"$f":"+D67+H67","v":2004},null,null,{"$f":"+I67+E67/12","v":2004.5833333333333},9315,null,{"$f":"M67-M67*F67","v":9315},{"$f":"O67/H67/12","v":77.625},{"$f":"+IF(L67<=$P$5,0,P67*12)","v":0},{"$f":"IF(N67=0,0,IF((AND((AF67>=AE67),(AF67<=AD67))),((AF67-AE67)*12)*P67,0))","v":0},{"$f":"IF(R67>0,R67,Q67)","v":0},1,{"$f":"T67*SUM(Q67:R67)","v":0},{"$f":"+IF(L67<=$P$6,M67,IF((D67+(E67/12))>=$P$6,0,((M67-((L67-$P$6)*12)*P67))))","v":9315},{"$f":"V67*T67","v":9315},1,{"$f":"W67*X67","v":9315},{"$f":"+IF(U67=0,M67,Y67+U67)","v":9315},{"$f":"+O67-Z67","v":0}]
[28,"2 Drop boxes ","Drop Boxes",1996,1,null,"SL",10,2006,null,null,2006.0833333333333,10884,null,10884,90.7,0,0,0,1,0,10884,10884,1,10884,10884,0]
[34,"150-60 F/A Containers ","Garbage Carts",1994,5,null,"SL",10,2004,null,null,2004.4166666666667,7357,null,7357,61.308333333333337,0,0,0,1,0,7357,7357,1,7357,7357,0]
[36,"25 300F Auto containers ","Garbage Carts",1994,5,null,"SL",10,2004,null,null,2004.4166666666667,3622,null,3622,30.183333333333334,0,0,0,1,0,3622,3622,1,3622,3622,0]
[40,"29 60 gal totes ","Garbage Carts",1993,8,null,"SL",10,2003,null,null,2003.6666666666667,784,null,784,6.5333333333333341,0,0,0,1,0,784,784,1,784,784,0]
[41,"200-60 Gal totes ","Garbage Carts",1995,4,null,"SL",10,2005,null,null,2005.3333333333333,10466,null,10466,87.216666666666654,0,0,0,1,0,10466,10466,1,10466,10466,0]
[42,"50-90 gal totes ","Garbage Carts",1995,4,null,"SL",10,2005,null,null,2005.3333333333333,3103,null,3103,25.858333333333334,0,0,0,1,0,3103,3103,1,3103,3103,0]
[43,"1-300 Gal tote ","Garbage Carts",1995,4,null,"SL",10,2005,null,null,2005.3333333333333,193,null,193,1.6083333333333334,0,0,0,1,0,193,193,1,193,193,0]
[62,"1-20yd Drop box ","Drop Boxes",1997,1,null,"SL",10,2007,null,null,2007.0833333333333,2538,null,2538,21.150000000000002,0,0,0,1,0,2538,2538,1,2538,2538,0]
[63,"623 Roller totes ","Garbage Carts",1997,2,null,"SL",10,2007,null,null,2007.1666666666667,33457,null,33457,278.80833333333334,0,0,0,1,0,33457,33457,1,33457,33457,0]
[74,"Totes ","Garbage Carts",1999,9,null,"SL",10,2009,null,null,2009.75,9458,null,9458,78.816666666666663,0,0,0,1,0,9458,9458,1,9458,9458,0]
[79,"New Totes ","Garbage Carts",2000,8,null,"SL",10,2010,null,null,2010.6666666666667,20502,null,20502,170.85,0,0,0,1,0,20502,20502,1,20502,20502,0]
[81,"30Yd Drop Boxes ","Drop Boxes",2001,1,null,"SL",10,{"$f":"+D79+H79","v":2011},null,null,{"$f":"+I79+E79/12","v":2011.0833333333333},12006,null,{"$f":"M79-M79*F79","v":12006},{"$f":"O79/H79/12","v":100.05},{"$f":"+IF(L79<=$P$5,0,P79*12)","v":0},{"$f":"IF(N79=0,0,IF((AND((AF79>=AE79),(AF79<=AD79))),((AF79-AE79)*12)*P79,0))","v":0},{"$f":"IF(R79>0,R79,Q79)","v":0},1,{"$f":"T79*SUM(Q79:R79)","v":0},{"$f":"+IF(L79<=$P$6,M79,IF((D79+(E79/12))>=$P$6,0,((M79-((L79-$P$6)*12)*P79))))","v":12006},{"$f":"V79*T79","v":12006},1,{"$f":"W79*X79","v":12006},{"$f":"+IF(U79=0,M79,Y79+U79)","v":12006},{"$f":"+O79-Z79","v":0}]
[85,"Totes ","Garbage Carts",2002,6,null,"SL",10,2012,null,null,2012.5,12584,null,12584,104.86666666666667,0,0,0,1,0,12584,12584,1,12584,12584,0]
[89,"New totes ","Garbage Carts",2003,6,null,"SL",10,2013,null,null,2013.5,11326,null,11326,94.383333333333326,0,0,0,1,0,11326,11326,1,11326,11326,0]
[92,"30 Yd. Drop Boxes-#1 2 3 ","Drop Boxes",2003,8,null,"SL",10,{"$f":"+D82+H82","v":2013},null,null,{"$f":"+I82+E82/12","v":2013.6666666666667},34364,null,{"$f":"M82-M82*F82","v":34364},{"$f":"O82/H82/12","v":286.36666666666667},{"$f":"+IF(L82<=$P$5,0,P82*12)","v":0},{"$f":"IF(N82=0,0,IF((AND((AF82>=AE82),(AF82<=AD82))),((AF82-AE82)*12)*P82,0))","v":0},{"$f":"IF(R82>0,R82,Q82)","v":0},1,{"$f":"T82*SUM(Q82:R82)","v":0},{"$f":"+IF(L82<=$P$6,M82,IF((D82+(E82/12))>=$P$6,0,((M82-((L82-$P$6)*12)*P82))))","v":34364},{"$f":"V82*T82","v":34364},1,{"$f":"W82*X82","v":34364},{"$f":"+IF(U82=0,M82,Y82+U82)","v":34364},{"$f":"+O82-Z82","v":0}]
[96,"60 & 90 Gallon cans ","Garbage Carts",2004,9,null,"SL",10,2014,null,null,2014.75,8286,null,8286,69.05,0,0,0,1,0,8286,8286,1,8286,8286,0]
[99,"20 Yd. Boxes - 4 ","Drop Boxes",2005,2,null,"SL",10,2015,null,null,2015.1666666666667,16233,null,16233,135.27500000000001,0,0,0,1,0,16233,16233,1,16233,16233,0]
[102,"Totes ","Garbage Carts",2005,8,null,"SL",10,2015,null,null,2015.6666666666667,19267,null,19267,160.55833333333334,0,0,0,1,0,19267,19267,1,19267,19267,0]
[107,"Totes ","Garbage Carts",2006,3,null,"SL",10,2016,null,null,2016.25,11053,null,11053,92.108333333333334,0,0,0,1,0,11053,11053,1,11053,11053,0]
[109,"400 60 Gallon Cans ","Garbage Carts",2006,6,null,"SL",10,2016,null,null,2016.5,26614,null,26614,221.78333333333333,0,0,0,1,0,26614,26614,1,26614,26614,0]
[114,"Totes ","Garbage Carts",2007,8,null,"SL",10,2017,null,null,2017.6666666666667,18120,null,18120,151,0,0,0,1,0,18120,18120,1,18120,18120,0]
[117,"3 - 30yd Drop Boxes ","Drop Boxes",2008,2,null,"SL",10,2018,null,null,2018.1666666666667,21378,null,21378,178.15,0,0,0,1,0,21378,21378,1,21378,21378,0]
[118,"90, 300 & 60 Gal. Cans ","Garbage Carts",2008,2,null,"SL",10,2018,null,null,2018.1666666666667,18565,null,18565,154.70833333333334,0,0,0,1,0,18565,18565,1,18565,18565,0]
[99,"90 Gallon Cans","Garbage Carts",2012,10,null,"SL",10,2022,null,null,2022.8333333333333,13252,null,13252,110.43333333333334,0,0,0,1,0,12699.833333333534,12699.833333333534,1,12699.833333333534,13252,0]
[100,"60 Gallon Cans","Garbage Carts",2012,10,null,"SL",10,2022,null,null,2022.8333333333333,12280,null,12280,102.33333333333333,0,0,0,1,0,11768.333333333519,11768.333333333519,1,11768.333333333519,12280,0]
[107,"New Cans - 400","Garbage Carts",2014,8,null,"SL",10,2024,null,null,2024.6666666666667,26505,null,26505,220.875,2650.5,0,2650.5,1,2650.5,20541.375,20541.375,1,20541.375,23191.875,3313.125]
[113,"Drop Boxes","Drop Boxes",2015,10,null,"SL",10,2025,null,null,2025.8333333333333,32100,null,32100,267.5,3210,0,3210,1,3210,21132.500000000487,21132.500000000487,1,21132.500000000487,24342.500000000487,7757.4999999995125]
[114,"400 - 60 Gallon Totes","Garbage Carts",2015,12,null,"SL",10,2025,null,null,2026,26100,null,26100,217.5,2610,0,2610,1,2610,16747.500000000196,16747.500000000196,1,16747.500000000196,19357.500000000196,6742.4999999998035]
[116,"Compactor","Garbage Carts",2016,7,null,"SL",10,2026,null,null,2026.5833333333333,14835,null,14835,123.625,1483.5,0,1483.5,1,1483.5,8653.7500000002256,8653.7500000002256,1,8653.7500000002256,10137.250000000226,4697.7499999997744]
[118,"300 60 Gal Totes & 100 96 Gal Totes","Garbage Carts",2017,5,null,"SL",10,2027,null,null,2027.4166666666667,26605,null,26605,221.70833333333334,2660.5,0,2660.5,1,2660.5,13302.5,13302.5,1,13302.5,15963,10642]
[122,"100 - 300 Gal Cans","Garbage Carts",2018,6,null,"SL",10,2028,null,null,2028.5,27490,null,27490,229.08333333333334,2749,0,2749,1,2749,10766.916666666875,10766.916666666875,1,10766.916666666875,13515.916666666875,13974.083333333125]
[123,"300 - 60 Gal Cans","Garbage Carts",2018,6,null,"SL",10,2028,null,null,2028.5,22560,null,22560,188,2256,0,2256,1,2256,8836.000000000171,8836.000000000171,1,8836.000000000171,11092.000000000171,11467.999999999829]
[124,"100 - 90 Gal Cans","Garbage Carts",2018,6,null,"SL",10,2028,null,null,2028.5,6290,null,6290,52.416666666666664,629,0,629,1,629,2463.5833333333812,2463.5833333333812,1,2463.5833333333812,3092.5833333333812,3197.4166666666188]
[127,"210 - 60 Gal Cans","Garbage Carts",2019,5,null,"SL",10,2029,null,null,2029.4166666666667,14543,null,14543,121.19166666666666,1454.3,0,1454.3,1,1454.3,4362.8999999999996,4362.8999999999996,1,4362.8999999999996,5817.2,8725.7999999999993]
[128,"300 - 60 Gal Cans 100 - 90 Gal Cans","Garbage Carts",2019,9,null,"SL",10,2029,null,null,2029.75,27835,null,27835,231.95833333333334,2783.5,0,2783.5,1,2783.5,7422.6666666668752,7422.6666666668752,1,7422.6666666668752,10206.166666666875,17628.833333333125]
[129,"350 - 65 Gal Bear Carts & 100 - 95 Gal Bear","Garbage Carts",2019,10,null,"SL",10,2029,null,null,2029.8333333333333,110127,null,110127,917.72500000000002,11012.7,0,11012.7,1,11012.7,28449.475000001665,28449.475000001665,1,28449.475000001665,39462.175000001662,70664.824999998338]
[null,"200 - 60 Gal Cans 30 96 Gal Cans","Garbage Carts",2019,10,null,"SL",10,2029,null,null,2029.8333333333333,16696,null,16696,139.13333333333333,1669.6,0,1669.6,1,1669.6,4313.1333333335879,4313.1333333335879,1,4313.1333333335879,5982.7333333335882,10713.266666666412]
[]
[null,"Sub-Total - Containers & Drop Boxes",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M65:M104)","v":716049},0,716049,5967.0750000000007,35168.6,0,35168.6,null,{"$f":"SUM(U65:U104)","v":35168.6},{"$f":"SUM(V65:V104)","v":510291.46666667052},{"$f":"SUM(W65:W104)","v":510291.46666667052},null,{"$f":"SUM(Y65:Y104)","v":510291.46666667052},{"$f":"SUM(Z65:Z104)","v":546523.9000000034},{"$f":"SUM(AA65:AA104)","v":169525.09999999651}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N107=0,0,IF((AND((AF107>=AE107),(AF107<=AD107))),((AF107-AE107)*12)*P107,0))","v":0},{"$f":"IF(R107>0,R107,Q107)","v":0},null,{"$f":"T107*SUM(Q107:R107)","v":0}]
[null,"SHOP EQUIPMENT"]
[9,"U Air compressor ","Shop Equipment",1993,9,null,"SL",5,{"$f":"+D109+H109","v":1998},null,null,{"$f":"+I109+E109/12","v":1998.75},300,null,{"$f":"M109-M109*F109","v":300},{"$f":"O109/H109/12","v":5},{"$f":"+IF(L109<=$P$5,0,P109*12)","v":0},{"$f":"IF(N109=0,0,IF((AND((AF109>=AE109),(AF109<=AD109))),((AF109-AE109)*12)*P109,0))","v":0},{"$f":"IF(R109>0,R109,Q109)","v":0},1,{"$f":"T109*SUM(Q109:R109)","v":0},{"$f":"+IF(L109<=$P$6,M109,IF((D109+(E109/12))>=$P$6,0,((M109-((L109-$P$6)*12)*P109))))","v":300},{"$f":"V109*T109","v":300},1,{"$f":"W109*X109","v":300},{"$f":"+IF(U109=0,M109,Y109+U109)","v":300},{"$f":"+O109-Z109","v":0}]
[19,"Base radio speaker ","Shop Equipment",1986,5,null,"SL",5,{"$f":"+D110+H110","v":1991},null,null,1991.4166666666667,1621,null,1621,27.016666666666666,0,0,0,1,0,1621,1621,1,1621,1621,0]
[46,"Midland Radio #15 ","Shop Equipment",1993,6,null,"SL",5,1998,null,null,1998.5,971,null,971,16.183333333333334,0,0,0,1,0,971,971,1,971,971,0]
[47,"Tarp ","Shop Equipment",1993,8,null,"SL",5,1998,null,null,1998.6666666666667,3500,null,3500,58.333333333333336,0,0,0,1,0,3500,3500,1,3500,3500,0]
[50,"Tool box & lift ga ","Shop Equipment",1994,10,null,"SL",5,1999,null,null,1999.8333333333333,550,null,550,9.1666666666666661,0,0,0,1,0,550,550,1,550,550,0]
[51,"Jensen radio #1 ","Shop Equipment",1995,4,null,"SL",5,2000,null,null,2000.3333333333333,923,null,923,15.383333333333333,0,0,0,1,0,923,923,1,923,923,0]
[52,"Peerless Roll off H ","Shop Equipment",1988,3,null,"SL",5,1993,null,null,1993.25,2880,null,2880,48,0,0,0,1,0,2880,2880,1,2880,2880,0]
[53,"Midland radio ","Shop Equipment",1989,12,null,"SL",5,1994,null,null,1995,775,null,775,12.916666666666666,0,0,0,1,0,775,775,1,775,775,0]
[67,"Compressor ","Shop Equipment",1997,9,null,"SL",5,{"$f":"+D117+H117","v":2002},null,null,2002.75,1615,null,1615,26.916666666666668,0,0,0,1,0,1615,1615,1,1615,1615,0]
[68,"Tools ","Shop Equipment",1997,10,null,"SL",5,{"$f":"+D118+H118","v":2002},null,null,2002.8333333333333,2781,null,2781,46.35,0,0,0,1,0,2781,2781,1,2781,2781,0]
[116,"Drop Box Compactor 15 Yard","Shop Equipment",2008,6,null,"SL",10,{"$f":"+D119+H119","v":2018},null,null,2018.5,11303,null,11303,94.191666666666663,0,0,0,1,0,11303,11303,1,11303,11303,0]
[null,"Sub-Total - Shop Equipment",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M109:M119)","v":27219},0,{"$f":"SUM(O109:O119)","v":27219},359.45833333333331,0,0,0,null,0,27219,27219,null,27219,27219,0]
[]
[null,"OFFICE EQUIPMENT"]
[2,"Oak Desk ","Office Equipment",1988,12,null,"SL",5,{"$f":"+D123+H123","v":1993},null,null,null,205,null,{"$f":"M123-M123*F123","v":205},{"$f":"O123/H123/12","v":3.4166666666666665},{"$f":"+IF(L123<=$P$5,0,P123*12)","v":0},{"$f":"IF(N123=0,0,IF((AND((AF123>=AE123),(AF123<=AD123))),((AF123-AE123)*12)*P123,0))","v":0},{"$f":"IF(R123>0,R123,Q123)","v":0},1,{"$f":"T123*SUM(Q123:R123)","v":0},{"$f":"+IF(L123<=$P$6,M123,IF((D123+(E123/12))>=$P$6,0,((M123-((L123-$P$6)*12)*P123))))","v":205},{"$f":"V123*T123","v":205},1,{"$f":"W123*X123","v":205},{"$f":"+IF(U123=0,M123,Y123+U123)","v":205},{"$f":"+O123-Z123","v":0}]
[3,"Oak office desk ","Office Equipment",1989,9,null,"SL",5,1994,null,null,null,200,null,200,3.3333333333333335,0,0,0,1,0,200,200,1,200,200,0]
[4,"File cabinet ","Office Equipment",1994,5,null,"SL",5,1999,null,null,null,210,null,210,3.5,0,0,0,1,0,210,210,1,210,210,0]
[5,"Quill/fire safe ","Office Equipment",1994,4,null,"SL",5,1999,null,null,null,245,null,245,4.083333333333333,0,0,0,1,0,245,245,1,245,245,0]
[8,"2 Desks & chairs ","Office Equipment",1980,7,null,"SL",5,1985,null,null,null,132,null,132,2.1999999999999997,0,0,0,1,0,132,132,1,132,132,0]
[9,"Filing cabinet ","Office Equipment",1980,12,null,"SL",5,1985,null,null,null,506,null,506,8.4333333333333336,0,0,0,1,0,506,506,1,506,506,0]
[10,"Filing cabinet ","Office Equipment",1980,7,null,"SL",5,1985,null,null,null,29,null,29,0.48333333333333334,0,0,0,1,0,29,29,1,29,29,0]
[11,"Office sign ","Office Equipment",1980,10,null,"SL",5,1985,null,null,null,195,null,195,3.25,0,0,0,1,0,195,195,1,195,195,0]
[12,"Filing cabinet ","Office Equipment",1980,12,null,"SL",5,1985,null,null,null,35,null,35,0.58333333333333337,0,0,0,1,0,35,35,1,35,35,0]
[13,"Wall pictures ","Office Equipment",1980,12,null,"SL",5,1985,null,null,null,125,null,125,2.0833333333333335,0,0,0,1,0,125,125,1,125,125,0]
[14,"Office furniture ","Office Equipment",1980,12,null,"SL",5,1985,null,null,null,585,null,585,9.75,0,0,0,1,0,585,585,1,585,585,0]
[15,"Office chair ","Office Equipment",1987,4,null,"SL",5,1992,null,null,null,159,null,159,2.65,0,0,0,1,0,159,159,1,159,159,0]
[16,"Oak file cabinet ","Office Equipment",1981,7,null,"SL",5,1986,null,null,null,38,null,38,0.6333333333333333,0,0,0,1,0,38,38,1,38,38,0]
[54,"Office furniture ","Office Equipment",1997,10,null,"SL",5,2002,null,null,null,1265,null,1265,21.083333333333332,0,0,0,1,0,1265,1265,1,1265,1265,0]
[55,"Carpet ","Office Equipment",1998,6,null,"SL",5,2003,null,null,null,6860,null,6860,114.33333333333333,0,0,0,1,0,6860,6860,1,6860,6860,0]
[97,"Phone System ","Office Equipment",2009,3,null,"SL",5,2014,null,null,null,7361,null,7361,122.68333333333334,0,0,0,1,0,7361,7361,1,7361,7361,0]
[101,"Computer Program ","Office Equipment",2010,1,null,"SL",5,2015,null,null,null,10908,null,10908,181.79999999999998,0,0,0,1,0,10908,10908,1,10908,10908,0]
[102,"Printer & stand ","Office Equipment",2010,3,null,"SL",5,2015,null,null,null,2477,null,2477,41.283333333333331,0,0,0,1,0,2477,2477,1,2477,2477,0]
[103,"Computers ","Office Equipment",2010,12,null,"SL",5,2015,null,null,null,14010,null,14010,233.5,0,0,0,1,0,14010,14010,1,14010,14010,0]
[null,"Sub-Total - Office Equipment",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M123:M141)","v":45545},{"$f":"SUM(N123:N141)","v":0},45545,759.08333333333326,0,0,0,null,0,45545,45545,null,45545,45545,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+M55+M62+M106+M120+M142","v":4125303},null,{"$f":"+O55+O62+O106+O120+O142","v":4125303},{"$f":"+P55+P62+P106+P120+P142","v":41696.207142857151},{"$f":"+Q55+Q62+Q106+Q120+Q142","v":255230.4095238095},{"$f":"+R55+R62+R106+R120+R142","v":0},{"$f":"+S55+S62+S106+S120+S142","v":255230.4095238095},null,{"$f":"+U55+U62+U106+U120+U142","v":255230.4095238095},{"$f":"+V55+V62+V106+V120+V142","v":2967563.7785714604},{"$f":"+W55+W62+W106+W120+W142","v":2967563.7785714604},null,{"$f":"+Y55+Y62+Y106+Y120+Y142","v":2967563.7785714604},{"$f":"+Z55+Z62+Z106+Z120+Z142","v":3241301.2880952666},{"$f":"+AA55+AA62+AA106+AA120+AA142","v":884001.71190473356}]
[]
[]
[]
[]
[]
[]
["Disposals"]
["36-a","3 Axle trailer ",null,1993,7,0,"SL",7,{"$f":"+D151+H151","v":2000},null,null,{"$f":"+I151+E151/12","v":2000.5833333333333},{"$f":"24737-4947","v":19790},null,{"$f":"M151-M151*F151","v":19790},{"$f":"O151/H151/12","v":235.5952380952381},{"$f":"+IF(L151<=$P$5,0,P151*12)","v":0},{"$f":"IF(N151=0,0,IF((AND((AF151>=AE151),(AF151<=AD151))),((AF151-AE151)*12)*P151,0))","v":0},{"$f":"IF(R151>0,R151,Q151)","v":0},1,{"$f":"T151*SUM(Q151:R151)","v":0},{"$f":"+IF(L151<=$P$6,M151,IF((D151+(E151/12))>=$P$6,0,((M151-((L151-$P$6)*12)*P151))))","v":19790},{"$f":"V151*T151","v":19790},1,{"$f":"W151*X151","v":19790},{"$f":"+IF(U151=0,M151,V151+U151)","v":19790},{"$f":"IF(N151>0,(M151-Y151)/2,IF(AB151>=AE151,(((M151*T151)*X151)-Z151)/2,((((M151*T151)*X151)-Y151)+(((M151*T151)*X151)-Z151))/2))","v":0},{"$f":"$D151+(($E151-1)/12)","v":1993.5},{"$f":"($O$5+1)-($O$2/12)","v":1}]
["36-SV","3 Axle trailer - salvage value",null,2017,12,0,"SL",7,2024,null,null,2025,4947,null,4947,58.892857142857139,706.71428571428567,0,706.71428571428567,1,706.71428571428567,3121.3214285714821,3121.3214285714821,1,3121.3214285714821,3828.0357142857679,559.48214285711606,2017.9166666666667,1]
["61-a","Ford Pickup",null,2001,7,0,"SL",5,2006,null,null,2006.5833333333333,{"$f":"31129-10273","v":20856},null,20856,347.59999999999997,0,0,0,1,0,20856,20856,1,20856,20856,0,2001.5,1]
["61-SV","Ford Pickup-Salvage Value",null,2017,12,0,"SL",5,2022,null,null,2023,10273,null,10273,171.21666666666667,0,0,0,1,0,9074.48333333349,9074.48333333349,1,9074.48333333349,10273,0,2017.9166666666667,1]
["81-a","07 Peterbuilt #10 - REFUSE",null,2007,7,0,"SL",7,2014,null,null,2014.5833333333333,{"$f":"230858-46172","v":184686},null,184686,2198.6428571428573,0,0,0,1,0,184686,184686,1,184686,184686,0,2007.5,1]
["81-SV","07 Peterbuilt #10 - REFUSE-Salvage Value",null,2017,12,0,"SL",7,2024,null,null,2025,46172,null,46172,549.66666666666663,6596,0,6596,1,6596,29132.333333333834,29132.333333333834,1,29132.333333333834,35728.333333333838,5221.8333333330811,2017.9166666666667,1]
["91-a","Roto Cart ",null,2009,10,null,"SL",10,2019,null,null,2019.8333333333333,13994,null,13994,116.61666666666667,0,0,0,1,0,13994,13994,1,13994,13994,0,2009.75,1]
["117-a","11 Chev Express",null,2017,3,0,"SL",5,2022,null,null,2022.25,26300,null,26300,438.33333333333331,0,0,0,1,0,26300,26300,1,26300,26300,0,2017.1666666666667,1]
[23,"2 Drop boxes/lids ",null,1987,9,null,"SL",10,1997,null,null,1997.75,1220,null,1220,10.166666666666666,0,0,0,1,0,1220,1220,1,1220,1220,0,1987.6666666666667,{"$f":"($O$5+1)-($O$2/12)","v":1}]
[24,"Dewald Drop Boxes ",null,1990,9,null,"SL",10,2000,null,null,2000.75,6451,null,6451,53.758333333333333,0,0,0,1,0,6451,6451,1,6451,6451,0,1990.6666666666667,1]
[29,"100 Gal totes (25) ",null,1996,2,null,"SL",10,2006,null,null,2006.1666666666667,1478,null,1478,12.316666666666668,0,0,0,1,0,1478,1478,1,1478,1478,0,1996.0833333333333,1]
[35,"30 100 F/A Containers ",null,1994,5,null,"SL",10,2004,null,null,2004.4166666666667,1790,null,1790,14.916666666666666,0,0,0,1,0,1790,1790,1,1790,1790,0,1994.3333333333333,1]
[44,"#15 Stretch & lift ",null,1993,3,null,"SL",10,2003,null,null,2003.25,8399,null,8399,69.99166666666666,0,0,0,1,0,8399,8399,1,8399,8399,0,1993.1666666666667,1]
[57,"Drop box kit ",null,1996,11,null,"SL",10,2006,null,null,2006.9166666666667,1130,null,1130,9.4166666666666661,0,0,0,1,0,1130,1130,1,1130,1130,0,1996.8333333333333,1]
[72,"Box 1130/1230/1330 ",null,1999,5,null,"SL",10,2009,null,null,2009.4166666666667,11326,null,11326,94.383333333333326,0,0,0,1,0,11326,11326,1,11326,11326,0,1999.3333333333333,1]
[73,"2 Drop Boxes ",null,1999,7,null,"SL",10,2009,null,null,2009.5833333333333,6200,null,6200,51.666666666666664,0,0,0,1,0,6200,6200,1,6200,6200,0,1999.5,1]
[80,"Box #'s L5 L6 L9 ",null,2001,1,null,"SL",10,2011,null,null,2011.0833333333333,11208,null,11208,93.399999999999991,0,0,0,1,0,11208,11208,1,11208,11208,0,2001,1]
[86,"Box's #L10 #L11 #L13 ",null,2002,8,null,"SL",10,2012,null,null,2012.6666666666667,10628,null,10628,88.566666666666663,0,0,0,1,0,10628,10628,1,10628,10628,0,2002.5833333333333,1]
[108,"Drop Box #2530 2630 2730 ",null,2006,6,null,"SL",10,2016,null,null,2016.5,16177,null,16177,134.80833333333334,0,0,0,1,0,16177,16177,1,16177,16177,0,2006.4166666666667,1]
[101,"Recycle Box #2330 ",null,2005,6,null,"SL",10,2015,null,null,2015.5,6079,null,6079,50.658333333333331,0,0,0,1,0,6079,6079,1,6079,6079,0,2005.4166666666667,1]
[104,"2 Drop Boxes #19 & 20 ",null,2005,10,null,"SL",10,2015,null,null,2015.8333333333333,8867,null,8867,73.891666666666666,0,0,0,1,0,8867,8867,1,8867,8867,0,2005.75,1]
[105,"Box #21 ",null,2006,1,null,"SL",10,2016,null,null,2016.0833333333333,4494,null,4494,37.449999999999996,0,0,0,1,0,4494,4494,1,4494,4494,0,2006,1]
[106,"Box #2430 4L40 5L40 ",null,2006,1,null,"SL",10,2016,null,null,2016.0833333333333,18621,null,18621,155.17499999999998,0,0,0,1,0,18621,18621,1,18621,18621,0,2006,1]
[110,"Box #22 23 L1 ",null,2006,7,null,"SL",10,2016,null,null,2016.5833333333333,14213,null,14213,118.44166666666666,0,0,0,1,0,14213,14213,1,14213,14213,0,2006.5,1]
[113,"Box#2830 2930 24 L2 3 4 ",null,2007,8,null,"SL",10,2017,null,null,2017.6666666666667,32460,null,32460,270.5,0,0,0,1,0,32460,32460,1,32460,32460,0,2007.5833333333333,1]
[115,"10 Drop Boxes ",null,2008,4,null,"SL",10,2018,null,null,2018.3333333333333,66121,null,66121,551.00833333333333,0,0,0,1,0,66121,66121,1,66121,66121,0,2008.25,1]
[119,"Box #1630 CB9 CB 10 ",null,2008,12,null,"SL",10,2018,null,null,2019,25411,null,25411,211.75833333333333,0,0,0,1,0,25411,25411,1,25411,25411,0,2008.9166666666667,1]
[120,"Box #C5 C6 C7 ",null,2008,11,null,"SL",10,2018,null,null,2018.9166666666667,24619,null,24619,205.15833333333333,0,0,0,1,0,24619,24619,1,24619,24619,0,2008.8333333333333,1]
[97,"Box #3L30",null,2012,1,null,"SL",10,2022,null,null,2022.0833333333333,9810,null,9810,81.75,0,0,0,1,0,9810,9810,1,9810,9810,0,2012,1]
[98,"Box #4730 #3730",null,2012,1,null,"SL",10,2022,null,null,2022.0833333333333,19621,null,19621,163.50833333333333,0,0,0,1,0,19621,19621,1,19621,19621,0,2012,1]
[126,"Drop Boxes C8,9,10,11",null,2018,11,null,"SL",10,2028,null,null,2028.9166666666667,40622,null,40622,338.51666666666665,{"$f":"+IF(L181<=$P$5,0,P181*12)","v":4062.2},0,4062.2,1,4062.2,14217.7,14217.7,1,14217.7,18279.900000000001,11171.05,2018.8333333333333,1]
["STAFF CAPITALIZED ITEMS - LAST RATE CASE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"Repair 11 Drop Boxes",null,2013,6,null,"SL",3,{"$f":"+D183+H183","v":2016},null,null,{"$f":"+I183+E183/12","v":2016.5},7852,null,{"$f":"M183-M183*F183","v":7852},{"$f":"O183/H183/12","v":218.11111111111111},{"$f":"+IF(L183<=$P$5,0,P183*12)","v":0},{"$f":"IF(N183=0,0,IF((AND((AF183>=AE183),(AF183<=AD183))),((AF183-AE183)*12)*P183,0))","v":0},{"$f":"IF(R183>0,R183,Q183)","v":0},1,{"$f":"T183*SUM(Q183:R183)","v":0},7852,{"$f":"V183*T183","v":7852},1,{"$f":"W183*X183","v":7852},{"$f":"+IF(U183=0,M183,V183+U183)","v":7852},{"$f":"IF(N183>0,(M183-Y183)/2,IF(AB183>=AE183,(((M183*T183)*X183)-Z183)/2,((((M183*T183)*X183)-Y183)+(((M183*T183)*X183)-Z183))/2))","v":0},{"$f":"$D183+(($E183-1)/12)","v":2013.4166666666667},1]
[null,"Repair 7 Drop Boxes",null,2013,6,null,"SL",3,{"$f":"+D184+H184","v":2016},null,null,2016.5,5065,null,{"$f":"M184-M184*F184","v":5065},{"$f":"O184/H184/12","v":140.69444444444443},0,{"$f":"IF(N184=0,0,IF((AND((AF184>=AE184),(AF184<=AD184))),((AF184-AE184)*12)*P184,0))","v":0},{"$f":"IF(R184>0,R184,Q184)","v":0},1,{"$f":"T184*SUM(Q184:R184)","v":0},5065,{"$f":"V184*T184","v":5065},1,{"$f":"W184*X184","v":5065},{"$f":"+IF(U184=0,M184,V184+U184)","v":5065},{"$f":"IF(N184>0,(M184-Y184)/2,IF(AB184>=AE184,(((M184*T184)*X184)-Z184)/2,((((M184*T184)*X184)-Y184)+(((M184*T184)*X184)-Z184))/2))","v":0},{"$f":"$D184+(($E184-1)/12)","v":2013.4166666666667},{"$f":"($O$5+1)-($O$2/12)","v":1}]
[]
[null,"Truck #10-Radiotor Replacment ",null,2013,7,0,"SL",5,{"$f":"+D186+H186","v":2018},null,null,{"$f":"+I186+E186/12","v":2018.5833333333333},4051,null,{"$f":"M186-M186*F186","v":4051},{"$f":"O186/H186/12","v":67.516666666666666},{"$f":"+IF(L186<=$P$5,0,P186*12)","v":0},{"$f":"IF(N186=0,0,IF((AND((AF186>=AE186),(AF186<=AD186))),((AF186-AE186)*12)*P186,0))","v":0},{"$f":"IF(R186>0,R186,Q186)","v":0},1,{"$f":"T186*SUM(Q186:R186)","v":0},{"$f":"+IF(L186<=$P$6,M186,IF((D186+(E186/12))>=$P$6,0,((M186-((L186-$P$6)*12)*P186))))","v":4051},{"$f":"V186*T186","v":4051},1,{"$f":"W186*X186","v":4051},{"$f":"+IF(U186=0,M186,V186+U186)","v":4051},{"$f":"IF(N186>0,(M186-Y186)/2,IF(AB186>=AE186,(((M186*T186)*X186)-Z186)/2,((((M186*T186)*X186)-Y186)+(((M186*T186)*X186)-Z186))/2))","v":0},{"$f":"$D186+(($E186-1)/12)","v":2013.5},1]
["109-a","2005 Peterbuilts #9 - REFUSE",null,2004,7,0,"SL",7,{"$f":"+D187+H187","v":2011},null,null,{"$f":"+I187+E187/12","v":2011.5833333333333},{"$f":"108373-21675","v":86698},null,{"$f":"M187-M187*F187","v":86698},{"$f":"O187/H187/12","v":1032.1190476190475},{"$f":"+IF(L187<=$P$5,0,P187*12)","v":0},{"$f":"IF(N187=0,0,IF((AND((AF187>=AE187),(AF187<=AD187))),((AF187-AE187)*12)*P187,0))","v":0},{"$f":"IF(R187>0,R187,Q187)","v":0},1,{"$f":"T187*SUM(Q187:R187)","v":0},{"$f":"+IF(L187<=$P$6,M187,IF((D187+(E187/12))>=$P$6,0,((M187-((L187-$P$6)*12)*P187))))","v":86698},{"$f":"V187*T187","v":86698},1,{"$f":"W187*X187","v":86698},{"$f":"+IF(U187=0,M187,V187+U187)","v":86698},{"$f":"IF(N187>0,(M187-Y187)/2,IF(AB187>=AE187,(((M187*T187)*X187)-Z187)/2,((((M187*T187)*X187)-Y187)+(((M187*T187)*X187)-Z187))/2))","v":0},{"$f":"$D187+(($E187-1)/12)","v":2004.5},1]
["109-SV","2005 Peterbuilts #9 - REFUSE - Salvage Value",null,2017,12,0,"SL",7,{"$f":"+D188+H188","v":2024},null,null,{"$f":"+I188+E188/12","v":2025},21675,null,{"$f":"M188-M188*F188","v":21675},{"$f":"O188/H188/12","v":258.03571428571428},{"$f":"+IF(L188<=$P$5,0,P188*12)","v":3096.4285714285716},{"$f":"IF(N188=0,0,IF((AND((AF188>=AE188),(AF188<=AD188))),((AF188-AE188)*12)*P188,0))","v":0},{"$f":"IF(R188>0,R188,Q188)","v":3096.4285714285716},1,{"$f":"T188*SUM(Q188:R188)","v":3096.4285714285716},{"$f":"+IF(L188<=$P$6,M188,IF((D188+(E188/12))>=$P$6,0,((M188-((L188-$P$6)*12)*P188))))","v":13675.892857143092},{"$f":"V188*T188","v":13675.892857143092},1,{"$f":"W188*X188","v":13675.892857143092},{"$f":"+IF(U188=0,M188,V188+U188)","v":16772.321428571664},{"$f":"IF(N188>0,(M188-Y188)/2,IF(AB188>=AE188,(((M188*T188)*X188)-Z188)/2,((((M188*T188)*X188)-Y188)+(((M188*T188)*X188)-Z188))/2))","v":2451.339285714168},{"$f":"$D188+(($E188-1)/12)","v":2017.9166666666667},1]
["71-a","Truck - REFUSE BODY FOR #9",null,2005,4,0,"SL",7,{"$f":"+D189+H189","v":2012},null,null,{"$f":"+I189+E189/12","v":2012.3333333333333},{"$f":"75906-15181","v":60725},null,{"$f":"M189-M189*F189","v":60725},{"$f":"O189/H189/12","v":722.91666666666663},{"$f":"+IF(L189<=$P$5,0,P189*12)","v":0},{"$f":"IF(N189=0,0,IF((AND((AF189>=AE189),(AF189<=AD189))),((AF189-AE189)*12)*P189,0))","v":0},{"$f":"IF(R189>0,R189,Q189)","v":0},1,{"$f":"T189*SUM(Q189:R189)","v":0},{"$f":"+IF(L189<=$P$6,M189,IF((D189+(E189/12))>=$P$6,0,((M189-((L189-$P$6)*12)*P189))))","v":60725},{"$f":"V189*T189","v":60725},1,{"$f":"W189*X189","v":60725},{"$f":"+IF(U189=0,M189,V189+U189)","v":60725},{"$f":"IF(N189>0,(M189-Y189)/2,IF(AB189>=AE189,(((M189*T189)*X189)-Z189)/2,((((M189*T189)*X189)-Y189)+(((M189*T189)*X189)-Z189))/2))","v":0},{"$f":"$D189+(($E189-1)/12)","v":2005.25},1]
["71-SV","Truck - REFUSE BODY FOR #9-Salvage Val",null,2017,12,0,"SL",7,{"$f":"+D190+H190","v":2024},null,null,{"$f":"+I190+E190/12","v":2025},15181,null,{"$f":"M190-M190*F190","v":15181},{"$f":"O190/H190/12","v":180.72619047619048},{"$f":"+IF(L190<=$P$5,0,P190*12)","v":2168.7142857142858},{"$f":"IF(N190=0,0,IF((AND((AF190>=AE190),(AF190<=AD190))),((AF190-AE190)*12)*P190,0))","v":0},{"$f":"IF(R190>0,R190,Q190)","v":2168.7142857142858},1,{"$f":"T190*SUM(Q190:R190)","v":2168.7142857142858},{"$f":"+IF(L190<=$P$6,M190,IF((D190+(E190/12))>=$P$6,0,((M190-((L190-$P$6)*12)*P190))))","v":9578.4880952382591},{"$f":"V190*T190","v":9578.4880952382591},1,{"$f":"W190*X190","v":9578.4880952382591},{"$f":"+IF(U190=0,M190,V190+U190)","v":11747.202380952545},{"$f":"IF(N190>0,(M190-Y190)/2,IF(AB190>=AE190,(((M190*T190)*X190)-Z190)/2,((((M190*T190)*X190)-Y190)+(((M190*T190)*X190)-Z190))/2))","v":1716.8988095237273},{"$f":"$D190+(($E190-1)/12)","v":2017.9166666666667},1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q151:Q190)","v":16630.057142857142},null,null,null,null,null,null,null,null,null,{"$f":"SUM(AA151:AA184)","v":16952.365476190196}]