{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Cover","Summary","Journal Entry","Appraisal summary","Acquisition costs","APA","Settlement Sheet"],"not_rendered":{"charts":0,"images":7,"macros":0,"external_links":2,"defined_names":99,"comments":1,"pivot_tables":0},"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":"Cover","index":0,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
["CAUSE No. 45461"]
["Indiana American Water Company"]
["Update to ATTACHMENT GDS-1 to reflect actual Acquisition Costs"]

{"sheet":"Summary","index":1,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["CAUSE No. 45461"]
[]
["Indiana American Water acquisition of Wastewater One, DBA River's Edge Utility"]
[]
["Summary Schedule"]
[]
["Purchase of Asset",null,null,"1.)",420000]
[]
["Inclusion of Acquisition Costs:"]
["Legal",null,null,null,102006]
["Engineering Contract Services",null,null,null,18160]
["Real Property Rants",null,null,null,7350]
["Closing Costs and Document Fees",null,null,null,3776.12]
[null,null,null,"2.)",{"$f":"SUM(E10:E13)","v":131292.12}]
[]
["Total Asset Booked",null,null,"3.) = 1.) + 2.)",{"$f":"+E7+E14","v":551292.12}]

{"sheet":"Journal Entry","index":2,"n_rows":230,"n_cols":25,"rows_kept":230,"cut":false,"hidden":false,"merged":[[18,1,23,12],[10,5,10,6],[10,9,10,10],[11,5,11,6],[11,9,11,10],[12,9,12,10],[16,1,16,3],[16,8,16,10],[9,5,9,6],[9,9,9,10],[2,2,2,12],[3,0,5,12],[7,9,7,10],[8,5,8,6],[8,9,8,10],[7,5,7,6]]}
[]
[]
[]
["JOURNAL ENTRY REQUEST\nOne Water Street, Camden, NJ 08102         \n(866) 777-8426"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standard","Description","Non-Standard","Description","Reserve/Write-Off","Description",null,"Drop Down List"]
[null,null,null,null,"BL Journal # :",null,null,null,"Document Type","UA",null,null,null,null,"SA","G/L Account Document","SY","Adjustment Decument -Int","SW","JE Write-Offs",null,"SY"]
[null,null,null,null,"Journal Entry Type","Non-Standard",null,null,"SAP Journal # :",null,null,null,null,null,"SG","JE Reversal","UA","Acquisitions","",null,null,"UA"]
[null,null,null,null,"Company Code:","1010 - Indiana American",null,null,"Document Date","2021-09-30",null,null,null,null,"SH","Gen Tax Recurring JE","",null,"",null,null,""]
[null,null,null,null,"Prepared By (Operating Unit):","Julie Leystra",null,null,"Posting Date","2021-09-30",null,null,null,null,"SI","Income Tax Recurring JE","",null,"",null,null,""]
[null,null,null,null,"Prepared By (SSC):",null,null,null,"Requested By (Operating Unit):",null,null,null,null,null,"SJ ","Income Tax Provision Accrual","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"Approved By (SSC):",null,null,null,null,null,"SM","GA Global Recurring JE","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SN ","Use Tax Reversals","",null,"",null,null,""]
[null,null,null,null,"Quarter Impacted","3rd",null,null,null,"This is not a Reversing Entry",null,null,null,null,"SQ","UPA Recurring JE","",null,"",null,null,""]
[null,"Doc Header Text",null,null,null,null,null,null,null,null,null,null,null,null,"SR","GA Recurring JE","",null,"",null,null,""]
[null,"Z07 - Rivers Edge Acq",null,null,"25 Character Maximum",null,null,null,"Validation totals between the two tabs",null,null,0,0,null,"SS","Topside Reversals","",null,"",null,null,""]
[null,"JOURNAL ENTRY DESCRIPTION:",null,null,null,null,null,null,null,null,null,null,null,null,"ST ","Topside - Z1 Ledger ","",null,"",null,null,""]
[null,"Record Rivers Edge Water and WW acquisition.  Rivers Edge is an asset acquisition with a $424K purchase price with an additional $127K of acquisition costs as approved by the commission.  The assets are recorded net and allocated to rate base/appraisal/purchase price of $551K.",null,null,null,null,null,null,null,null,null,null,null,null,"SV","Reversing JE","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SX","Adjustment Decument - Ext","",null,"",null,null,""]
[]
[]
[]
[]
[null,"Please add rows as necessary to the table below in order to complete your requested journal entry.",null,null,null,null,null,null,null,null,"TOTAL",551292.12,551292.12,"True",null,null,null,null,null,null,null,null,null,null,0]
[null,"Company Code","GL Account","Trading Partner","Posting Key","Explanation","Cost Center","Profit Center","WBS Element","Internal Order","Assignment","Debit Amount","Credit Amount",null,null,"1010 - Indiana American",null,null,"1st"]
[null,1010,10400000,null,"50","reclass cash paid to asset value",null,1075,null,null,null,null,254265.67,"Utility Plant Purchased or Sold",null,"1011 - Iowa American",null,null,"2nd"]
[1024,1010,10400000,null,"50","reclass cash paid to asset value",null,1076,null,null,null,null,169510.45,"Utility Plant Purchased or Sold",null,"1012 - Kentucky American",null,null,"3rd"]
[1024,1010,53110000,null,"50","reclass acquisition costs to asset value",null,null,null,60004961,null,null,18160,"Contract Svc-Eng - Natural Account",null,"1013 - Maryland American",null,null,"4th"]
[1024,1010,54110000,null,"50","reclass acquisition costs to asset value",null,null,null,60004961,null,null,7350,"Rents-Real Property - Natural Account",null,"1014 - Bluefield Valley"]
[1024,1010,53155000,null,"50","reclass acquisition costs to asset value",null,null,null,60008663,null,null,102006,"Contract Services - Legal",null,"1015 - California American"]
[1024,1010,10130320,null,"40","record net UPIS assets for Rivers Edge Water",null,1075,null,null,null,6685,null,"UPIS - Land & Land Rights - Source of Supply",null,"1016 - Michigan American"]
[1024,1010,10130350,null,"40","record net UPIS assets for Rivers Edge Water",null,1075,null,null,null,129795,null,"UPIS - Land & Land Rights - Transmission & Distrib",null,"1017 - Missouri American"]
[1024,1010,10130700,null,"40","record net UPIS assets for Rivers Edge Water",null,1075,null,null,null,22897.43,null,"UPIS - Wells & Springs",null,"1018 - New Jersey American"]
[1024,1010,10131150,null,"40","record net UPIS assets for Rivers Edge Water",null,1075,null,null,null,1984.2,null,"UPIS - Pumping Equipment - Other",null,"1020 - American Water Works"]
[1024,1010,10133100,null,"40","record net UPIS assets for Rivers Edge Water",null,1075,null,null,null,47312.02,null,"UPIS - Transmission & Distribution Mains",null,"1021 - AWR"]
[1024,1010,10133300,null,"40","record net UPIS assets for Rivers Edge Water",null,1075,null,null,null,17923.560000000001,null,"UPIS - Services",null,"1024 - Pennsylvania American"]
[1024,1010,10133410,null,"40","record net UPIS assets for Rivers Edge Water",null,1075,null,null,null,8770.7999999999993,null,"UPIS - Meters",null,"1025 - Illinois American"]
[1024,1010,10133500,null,"40","record net UPIS assets for Rivers Edge Water",null,1075,null,null,null,2255.0500000000002,null,"UPIS - Hydrants",null,"1026 - Tennessee American"]
[1024,1010,10134500,null,"40","record net UPIS assets for Rivers Edge Water",null,1075,null,null,null,33368.14,null,"UPIS - Power Operated Equipment",null,"1027 - Virginia American",null,null,null,null,null,null,null,null," "]
[1024,1010,10135340,null,"40","record net UPIS assets for Rivers Edge WW",null,1076,null,null,null,84068.12,null,"UPIS - WW Land & Land Rights - TDP",null,"1028 - West Virginia American"]
[1024,1010,10135420,null,"40","record net UPIS assets for Rivers Edge WW",null,1076,null,null,null,6014.33,null,"UPIS - WW Struct & Imp - Coll",null,"1030 - Hawaii American"]
[1024,1010,10135440,null,"40","record net UPIS assets for Rivers Edge WW",null,1076,null,null,null,47515.18,null,"UPIS - WW Struct & Imp - TDP",null,"1033 - Service Company"]
[1024,1010,10136110,null,"40","record net UPIS assets for Rivers Edge WW",null,1076,null,null,null,133771.04,null,"UPIS - WW Collecting Mains",null,"1038 - New York American"]
[1024,1010,10136300,null,"40","record net UPIS assets for Rivers Edge WW",null,1076,null,null,null,8932.25,null,"UPIS - WW Services Sewer",null,"1044 - Illinois Lake Water"]
[1024,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1051 - Etown Corp"]
[1024,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1057 - Etown Properties"]
[1024,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1046 - AWCC"]
[1024,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1080 - Laurel Oak Property"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1090 - Thames Water Holding"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1091 - TW North America"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]

{"sheet":"Appraisal summary","index":3,"n_rows":107,"n_cols":17,"rows_kept":107,"cut":false,"hidden":false,"merged":[]}
["River's Edge Utility"]
["Utility Valuation"]
[null,"PURCHASE PRICE",420000]
[null,"ACQUISTION COSTS (Est.)",131292]
["Replacement Cost Depreciated",null,null,null,null,null,null,null,null,null,"Less:",null,"Adjusted",null,"Spread",null,"Total"]
[null,null,null,null,null,"Replacement Cost",null,"Current Value",null,null,"Reduce",null,"Asset Value",null,"of Est.",null,"Appraised Value"]
[null,null,null,null,null,null,null,"(Depreciated)",null,null,"value to",null,"to Match ",null,"Acquisition",null,"With Acquisition"]
["Description",null,"Subsidiary Account","Units","Qty","Unit Price","Total","Bal Useful","Total",null,"Purchase",null,"Purchase",null,"Costs",null,"Transaction Costs"]
[null,null,null,null,null,null,null,"Life",{"$f":"+I104","v":1613201.9},null,{"$f":"+C3-I104","v":-1193201.8999999999},null,{"$f":"+C3","v":420000},null,{"$f":"+'Acquisition costs'!O10","v":131292.12},null,{"$f":"+Q104","v":551292.02}]
[]
["Original Water System - 1989"]
[null,"Well House",307000,"LS",1,50000,{"$f":"+F12*E12","v":50000},0.44,{"$f":"+G12*H12","v":22000},null,{"$f":"ROUND((I12/$I$104)*$K$9,0)","v":-16272},null,{"$f":"+K12+I12","v":5728},null,{"$f":"+M12/$M$104*$O$9","v":1790.5748628987772},null,{"$f":"+M12+O12","v":7518.5748628987767}]
[null,"Water Chlorination System",null,"LS",1,28000,28000,0,0,null,0,null,0,null,0,null,0]
[null,"3-inch PVC Water Main","331100","LF",10700,20,214000,0.63,134820,null,-99719,null,35101,null,10972.585241377441,null,46073.585241377441]
[null,"2-inch PVC Water Main","331100","LF",250,18,4500,0.63,2835,null,-2097,null,738,null,230.69906578549191,null,968.69906578549194]
[null,"Water Meter (5/8\")","334100","EA",27,800,21600,0.44,9504,null,-7030,null,2474,null,773.37329099364092,null,3247.3732909936407]
[null,"Service Lines","333000","EA",149,800,119200,0.44,52448,null,-38793,null,13655,null,4268.5579177518857,null,17923.557917751885]
[null,"3-inch Valves","331100","EA",6,900,5400,0,0,null,0,null,0,null,0,null,0]
[null,"Flush Hydrants","335000","EA",5,3000,15000,0.44,6600,null,-4882,null,1718,null,537.04741872557599,null,2255.0474187255759]
[null,"Water Supply Well",307000,"EA",1,50000,50000,0.44,22000,null,-16272,null,5728,null,1790.5748628987772,null,7518.5748628987767]
[]
["System Improvements - 1990"]
[null,"Water Supply Well",307000,"EA",1,50000,{"$f":"+F23*E23","v":50000},0.46,{"$f":"+G23*H23","v":23000},null,{"$f":"ROUND((I23/$I$104)*$K$9,0)","v":-17012},null,{"$f":"+K23+I23","v":5988},null,{"$f":"+M23/$M$104*$O$9","v":1871.8509565359423},null,{"$f":"+M23+O23","v":7859.8509565359418}]
[]
["System Improvements - 2007"]
[null,"Hydropneumatic Pressure Tanks",311500,"EA",4,1200,{"$f":"+F26*E26","v":4800},0.6,{"$f":"+G26*H26","v":2880},null,{"$f":"ROUND((I26/$I$104)*$K$9,0)","v":-2130},null,{"$f":"+K26+I26","v":750},null,{"$f":"+M26/$M$104*$O$9","v":234.45027010720722},null,{"$f":"+M26+O26","v":984.45027010720719}]
[]
["System Improvements - 2011"]
[null,"Chlorine Pumps",311500,"LS",1,3850,{"$f":"+F29*E29","v":3850},0.76,{"$f":"+G29*H29","v":2926},null,{"$f":"ROUND((I29/$I$104)*$K$9,0)","v":-2164},null,{"$f":"+K29+I29","v":762},null,{"$f":"+M29/$M$104*$O$9","v":238.20147442892252},null,{"$f":"+M29+O29","v":1000.2014744289226}]
[null,"Water Chlorination System Expansion","345000","LS",1,5600,5600,0.76,4256,null,-3148,null,1108,null,346.36119903838079,null,1454.3611990383808]
[null,"Water Well Pump w/Valve","345000","EA",1,1920,1920,0.76,1459.2,null,-1079,null,380.20000000000005,null,118.85065692634693,null,499.05065692634696]
[null,"Water Well Piping","345000","LS",1,7850,7850,0.92,7222,null,-5342,null,1880,null,587.68867706873277,null,2467.6886770687329]
[null,"Lift Station Pump and Floats","345000","LS",1,2200,2200,0.4,880,null,-651,null,229,null,71.585482472733943,null,300.58548247273393]
[null,"Valve Guide w/ Crockmeter","345000","LS",1,2200,2200,0.4,880,null,-651,null,229,null,71.585482472733943,null,300.58548247273393]
[null,"Misc Pumps and Valves","345000","LS",1,7200,7200,0.76,5472,null,-4047,null,1425,null,445.45551320369373,null,1870.4555132036937]
[null,"Generator Replacement","345000","LS",1,9000,9000,0.7,6300,null,-4660,null,1640,null,512.66459063442642,null,2152.6645906344265]
[null,"Dosing Station Improvements","345000","EA",1,600,600,0.76,456,null,-337,null,119,null,37.199442857010212,null,156.19944285701021]
[null,"Misc Electrical Equipment","345000","LS",1,8300,8300,0.76,6308,null,-4666,null,1642,null,513.28979135471229,null,2155.2897913547122]
[null,"Misc Valves and Piping","345000","LS",1,6600,6600,0.92,6072,null,-4491,null,1581,null,494.22116938599277,null,2075.2211693859927]
[]
["System Improvements - 2012"]
[null,"Chlorine Feed System","345000","LS",1,5600,{"$f":"+F42*E42","v":5600},0.8,{"$f":"+G42*H42","v":4480},null,{"$f":"ROUND((I42/$I$104)*$K$9,0)","v":-3314},null,{"$f":"+K42+I42","v":1166},null,{"$f":"+M42/$M$104*$O$9","v":364.49201992667145},null,{"$f":"+M42+O42","v":1530.4920199266714}]
[null,"Valves","345000","LS",1,830,830,0.93,771.90000000000009,null,-571,null,200.90000000000009,null,62.801412352717271,null,263.70141235271734]
[null,"Lift Station Pumps","345000","LS",1,19200,19200,0.5,9600,null,-7101,null,2499,null,781.18829999721447,null,3280.1882999972145]
[null,"Pressure Switches W/ Controls","345000","LS",1,2790,2790,0.5,1395,null,-1032,null,363,null,113.47393073188829,null,476.47393073188829]
[null,"3\" PVC Water Main","331100","LS",1,850,850,0.93,790.5,null,-585,null,205.5,null,64.239374009374785,null,269.73937400937479]
[null,"Water Meter (5/8\")","334100","EA",13,800,10400,0.5,5200,null,-3846,null,1354,null,423.26088763354471,null,1777.2608876335448]
[null,"Misc Repairs","345000","LS",1,13220,13220,0.5,6610,null,-4889,null,1721,null,537.98521980600492,null,2258.9852198060048]
[]
["System Improvements - 2013"]
[null,"Pumps (Non-specified)","345000","LS",1,2000,{"$f":"+F51*E51","v":2000},0.84,{"$f":"+G51*H51","v":1680},null,{"$f":"ROUND((I51/$I$104)*$K$9,0)","v":-1243},null,{"$f":"+K51+I51","v":437},null,{"$f":"+M51/$M$104*$O$9","v":136.60635738246606},null,{"$f":"+M51+O51","v":573.60635738246606}]
[null,"Electrical Controls","345000","LS",1,500,{"$f":"+F52*E52","v":500},0.84,{"$f":"+G52*H52","v":420},null,{"$f":"ROUND((I52/$I$104)*$K$9,0)","v":-311},null,{"$f":"+K52+I52","v":109},null,{"$f":"+M52/$M$104*$O$9","v":34.07343925558078},null,{"$f":"+M52+O52","v":143.07343925558078}]
[null,"Water Main Valves","345000","LS",1,790,{"$f":"+F53*E53","v":790},0.95,{"$f":"+G53*H53","v":750.5},null,{"$f":"ROUND((I53/$I$104)*$K$9,0)","v":-555},null,{"$f":"+K53+I53","v":195.5},null,{"$f":"+M53/$M$104*$O$9","v":61.113370407945347},null,{"$f":"+M53+O53","v":256.61337040794535}]
[null,"Water Meter (5/8\")","334100","EA",1,800,{"$f":"+F54*E54","v":800},0.6,{"$f":"+G54*H54","v":480},null,{"$f":"ROUND((I54/$I$104)*$K$9,0)","v":-355},null,{"$f":"+K54+I54","v":125},null,{"$f":"+M54/$M$104*$O$9","v":39.075045017867872},null,{"$f":"+M54+O54","v":164.07504501786786}]
[null,"Meter Set and Tap","345000","LS",1,2340,{"$f":"+F55*E55","v":2340},0.6,{"$f":"+G55*H55","v":1404},null,{"$f":"ROUND((I55/$I$104)*$K$9,0)","v":-1038},null,{"$f":"+K55+I55","v":366},null,{"$f":"+M55/$M$104*$O$9","v":114.41173181231711},null,{"$f":"+M55+O55","v":480.4117318123171}]
[]
["System Improvements - 2014"]
[null,"Meter Set and Tap","345000","LS",1,2180,{"$f":"+F58*E58","v":2180},0.7,{"$f":"+G58*H58","v":1526},null,{"$f":"ROUND((I58/$I$104)*$K$9,0)","v":-1129},null,{"$f":"+K58+I58","v":397},null,{"$f":"+M58/$M$104*$O$9","v":124.10234297674835},null,{"$f":"+M58+O58","v":521.10234297674833}]
[null,"Misc Repairs","345000","LS",1,9560,{"$f":"+F59*E59","v":9560},0.7,{"$f":"+G59*H59","v":6692},null,{"$f":"ROUND((I59/$I$104)*$K$9,0)","v":-4950},null,{"$f":"+K59+I59","v":1742},null,{"$f":"+M59/$M$104*$O$9","v":544.54982736900661},null,{"$f":"+M59+O59","v":2286.5498273690064}]
[null,"New Sample Taps","345000","LS",1,530,{"$f":"+F60*E60","v":530},0.7,{"$f":"+G60*H60","v":371},null,{"$f":"ROUND((I60/$I$104)*$K$9,0)","v":-274},null,{"$f":"+K60+I60","v":97},null,{"$f":"+M60/$M$104*$O$9","v":30.322234933865467},null,{"$f":"+M60+O60","v":127.32223493386547}]
[null,"Meter Pit, Ball Valve, Adaptor, Coupling, Steel Lid","345000","LS",1,400,{"$f":"+F61*E61","v":400},0.7,{"$f":"+G61*H61","v":280},null,{"$f":"ROUND((I61/$I$104)*$K$9,0)","v":-207},null,{"$f":"+K61+I61","v":73},null,{"$f":"+M61/$M$104*$O$9","v":22.819826290434836},null,{"$f":"+M61+O61","v":95.819826290434833}]
[]
["System Improvements - 2015"]
[null,"Mound System","345000","LS",1,2200,{"$f":"+F64*E64","v":2200},0.96,{"$f":"+G64*H64","v":2112},null,{"$f":"ROUND((I64/$I$104)*$K$9,0)","v":-1562},null,{"$f":"+K64+I64","v":550},null,{"$f":"+M64/$M$104*$O$9","v":171.93019807861864},null,{"$f":"+M64+O64","v":721.93019807861867}]
[null,"2-inch Joints","345000","EA",4,560,{"$f":"+F65*E65","v":2240},0.97,{"$f":"+G65*H65","v":2172.7999999999997},null,{"$f":"ROUND((I65/$I$104)*$K$9,0)","v":-1607},null,{"$f":"+K65+I65","v":565.79999999999973},null,{"$f":"+M65/$M$104*$O$9","v":176.86928376887704},null,{"$f":"+M65+O65","v":742.66928376887677}]
[null,"Meter Set, Change Meter, and Reset Valve","345000","LS",1,1830,{"$f":"+F66*E66","v":1830},0.8,{"$f":"+G66*H66","v":1464},null,{"$f":"ROUND((I66/$I$104)*$K$9,0)","v":-1083},null,{"$f":"+K66+I66","v":381},null,{"$f":"+M66/$M$104*$O$9","v":119.10073721446126},null,{"$f":"+M66+O66","v":500.10073721446128}]
[null,"Water Meter (5/8\")","334100","EA",4,800,{"$f":"+F67*E67","v":3200},0.8,{"$f":"+G67*H67","v":2560},null,{"$f":"ROUND((I67/$I$104)*$K$9,0)","v":-1893},null,{"$f":"+K67+I67","v":667},null,{"$f":"+M67/$M$104*$O$9","v":208.50444021534295},null,{"$f":"+M67+O67","v":875.50444021534292}]
[null,"Misc Repairs","345000","LS",1,5000,{"$f":"+F68*E68","v":5000},0.8,{"$f":"+G68*H68","v":4000},null,{"$f":"ROUND((I68/$I$104)*$K$9,0)","v":-2959},null,{"$f":"+K68+I68","v":1041},null,{"$f":"+M68/$M$104*$O$9","v":325.41697490880364},null,{"$f":"+M68+O68","v":1366.4169749088037}]
[]
["System Improvements - 2016"]
[null,"Replacement of Well, Meters, and Pumps","345000","LS",1,4100,{"$f":"+F71*E71","v":4100},0.98,{"$f":"+G71*H71","v":4018},null,{"$f":"ROUND((I71/$I$104)*$K$9,0)","v":-2972},null,{"$f":"+K71+I71","v":1046},null,{"$f":"+M71/$M$104*$O$9","v":326.97997670951833},null,{"$f":"+M71+O71","v":1372.9799767095183}]
[null,"Water Meter (5/8\")","334100","EA",11,800,{"$f":"+F72*E72","v":8800},0.9,{"$f":"+G72*H72","v":7920},null,{"$f":"ROUND((I72/$I$104)*$K$9,0)","v":-5858},null,{"$f":"+K72+I72","v":2062},null,{"$f":"+M72/$M$104*$O$9","v":644.58194261474841},null,{"$f":"+M72+O72","v":2706.5819426147482}]
[null,"Misc Repairs","345000","LS",1,9550,{"$f":"+F73*E73","v":9550},0.9,{"$f":"+G73*H73","v":8595},null,{"$f":"ROUND((I73/$I$104)*$K$9,0)","v":-6357},null,{"$f":"+K73+I73","v":2238},null,{"$f":"+M73/$M$104*$O$9","v":699.59960599990632},null,{"$f":"+M73+O73","v":2937.5996059999061}]
["Original Wastewater System - 1989"]
[null,"6-inch PVC Force Main","361000","LF",1450,30,{"$f":"+F75*E75","v":43500},0.63,{"$f":"+G75*H75","v":27405},null,{"$f":"ROUND((I75/$I$104)*$K$9,0)","v":-20270},null,{"$f":"+K75+I75","v":7135},null,{"$f":"+M75/$M$104*$O$9","v":2230.403569619898},null,{"$f":"+M75+O75","v":9365.4035696198989}]
[null,"4-inch PVC Force Main","361000","LF",1100,26,28600,0.63,{"$f":"+G76*H76","v":18018},null,-13327,null,4691,null,1466.4082894305454,null,6157.4082894305457]
[null,"3-inch PVC Force Main","361000","LF",11000,20,220000,0.63,{"$f":"+G77*H77","v":138600},null,-102515,null,36085,null,11280.183995758096,null,47365.183995758096]
[null,"8-inch Sanitary Sewer","361100","LF",3500,80,280000,0.63,{"$f":"+G78*H78","v":176400},null,-130474,null,45926,null,14356.484139924798,null,60282.484139924796]
[null,"Sanitary Manhole","361100","EA",9,5500,49500,0.63,31020,null,-22944,null,8076,null,2524.560508514407,null,10600.560508514407]
[null,"Sanitary Laterals","363000","LF",2700,22,59400,0.44,26136,null,-19331,null,6805,null,2127.2454507727271,null,8932.2454507727271]
[null,"Lift Station (Wetwell & Valve Vault Structures)","354200","EA",2,10000,20000,0.44,{"$f":"+G81*H81","v":8800},null,-6509,null,2291,null,716.16742508748234,null,3007.1674250874821]
[null,"3,000 Gallon Septic Tank (Concrete Structure)","354200","EA",4,5000,20000,0.44,{"$f":"+G82*H82","v":8800},null,-6509,null,2291,null,716.16742508748234,null,3007.1674250874821]
[null,"Dosing Station (Concrete Structure)","354400","EA",2,8000,16000,0.44,{"$f":"+G83*H83","v":7040},null,-5207,null,1833,null,572.99646014201437,null,2405.9964601420143]
[null,"Mound System","354400","EA",3,100000,300000,0.44,{"$f":"+G84*H84","v":132000},null,-97634,null,34366,null,10742.823976672376,null,45108.823976672378]
[]
[null,null,null,null,null,"Total Replacement",{"$f":"SUM(G12:G84)","v":1763730},"Total Value",{"$f":"SUM(I12:I84)","v":967829.9},null,{"$f":"SUM(K10:K84)","v":-715854},null,{"$f":"SUM(M10:M84)","v":251975.9},null,{"$f":"SUM(O10:O84)","v":78767.757087342165},null,{"$f":"SUM(Q10:Q84)","v":330743.65708734217}]
[null,null,null,null,null,null,null,"Depreciated"]
[]
[]
[]
[]
[]
["Summary of Land Values"]
[null,null,null,null,"Indicated","Indicated"]
[null,"Parcel",null,"Acres","Unit Value","Value"]
[null,"Utility Easement Land","Water View",1.48,70000,{"$f":"+D96*E96","v":103600},null,null,{"$f":"+F96","v":103600},null,{"$f":"ROUND((I96/$I$104)*$K$9,0)","v":-76628},null,{"$f":"+K96+I96","v":26972},null,{"$f":"+M96/$M$104*$O$9","v":8431.456913775457},null,{"$f":"+M96+O96","v":35403.456913775459}]
[null,"Utility Easement Land","Water Access",2.79,99000,{"$f":"+D97*E97","v":276210},null,null,{"$f":"+F97","v":276210},null,{"$f":"ROUND((I97/$I$104)*$K$9,0)","v":-204298},null,{"$f":"+K97+I97","v":71912},null,{"$f":"+M97/$M$104*$O$9","v":22479.717098599311},null,{"$f":"+M97+O97","v":94391.717098599314}]
[null,"Water Wells Land",null,1.99,3800,{"$f":"+E98*D98","v":7562},null,null,{"$f":"+F98","v":7562},null,{"$f":"ROUND((I98/$I$104)*$K$9,0)","v":-5593},null,{"$f":"+K98+I98","v":1969},null,{"$f":"+M98/$M$104*$O$9","v":615.51010912145466},null,{"$f":"+M98+O98","v":2584.5101091214547}]
[null,"Water Wells Land",null,null,null,12000,null,null,{"$f":"+F99","v":12000},null,{"$f":"ROUND((I99/$I$104)*$K$9,0)","v":-8876},null,{"$f":"+K99+I99","v":3124},null,{"$f":"+M99/$M$104*$O$9","v":976.5635250865538},null,{"$f":"+M99+O99","v":4100.5635250865535}]
[null,"Septic Field",null,8.1999999999999993,30000,{"$f":"+D100*E100","v":245999.99999999997},null,null,{"$f":"+F100","v":245999.99999999997},null,{"$f":"ROUND((I100/$I$104)*$K$9,0)","v":-181953},null,{"$f":"+K100+I100","v":64046.999999999971},null,{"$f":"+M100/$M$104*$O$9","v":20021.115266075059},null,{"$f":"+M100+O100","v":84068.115266075038}]
[null,"Total",null,null,null,{"$f":"SUM(F96:F100)","v":645372},null,null,{"$f":"SUM(I96:I100)","v":645372},null,{"$f":"SUM(K96:K100)","v":-477348},null,{"$f":"SUM(M96:M100)","v":168023.99999999997},null,{"$f":"SUM(O96:O100)","v":52524.362912657831},null,{"$f":"SUM(Q96:Q100)","v":220548.36291265782}]
[null,"Rounded",null,null,null,646000]
[]
[null,"TOTAL APPRAISED VALUE WITH LAND AND ASSETS",null,null,null,null,null,null,{"$f":"+I86+I101","v":1613201.9},null,{"$f":"+K86+K101","v":-1193202},null,{"$f":"+K104+I104","v":419999.89999999991},null,{"$f":"+O86+O101","v":131292.12},null,{"$f":"+Q101+Q86","v":551292.02}]
[]
[null,null,"Water"]
[null,null,"Wastewater"]

{"sheet":"Acquisition costs","index":4,"n_rows":33,"n_cols":17,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Costs per IO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Costs per IO 60008663",102006]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Costs per IO 60004961",25510]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Costs expected to settle to IO",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Subtotal of IO",{"$f":"SUM(O5:O7)","v":127516}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Add'l Settlement Costs",3776.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"+O8+O9","v":131292.12}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Preliminary","Costs expected to settle","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,53110000,18160,null,{"$f":"+SUM(O18:P18)","v":18160}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,54110000,7350,null,{"$f":"+SUM(O19:P19)","v":7350}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,53155000,102006,null,102006]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O18:O32)","v":127516},{"$f":"SUM(P18:P32)","v":0},127516]

{"sheet":"APA","index":5,"n_rows":1,"n_cols":8,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"Purchase Price",420000]

{"sheet":"Settlement Sheet","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}