{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Data","Brine and WW","LaneMiles","Trucks","Events","Cost","DataSummary","DistrictSummaryData"],"not_rendered":{"charts":2,"images":12,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":4},"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":"Data","index":0,"n_rows":237,"n_cols":13,"rows_kept":237,"cut":false,"hidden":false,"merged":[]}
["Type","District","County","Facility","Wash Water Disposal","Lane Miles","Number of Trucks","5 Year Average Volume of Salt Brine Made","# Events (2008-2009)","# Events (2009-2010)","# Events (2010-2011)","Three Year Avg Events","Estimated WW Volume"]
["COUNTY       ",1,"ALL"," Allen County Garage (ALLCG)","Public Sanitary Sewer",470.04,8,141132,27,27,35,{"$f":"AVERAGE(I2:K2)","v":29.666666666666668},{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G2*((DataSummary!$C$19/100)*Data!L2),1.1*330*Data!G2*Data!L2)","v":86152.000000000015}]
["COUNTY       ",1,"DEF"," Defiance County Garage (DEFCG)","Public Sanitary Sewer",325.60000000000002,13,63349.4,23,24,28,25,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G3*((DataSummary!$C$19/100)*Data!L3),1.1*330*Data!G3*Data!L3)","v":117975.00000000003}]
["COUNTY       ",1,"HAN"," Hancock County Garage (HANCG)","Public Sanitary Sewer",577.88,15,126879,29,34,31,31.333333333333332,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G4*((DataSummary!$C$19/100)*Data!L4),1.1*330*Data!G4*Data!L4)","v":170610.00000000003}]
["COUNTY       ",1,"HAR"," Hardin County Garage (HARCG)","Public Sanitary Sewer",334.46000000000004,9,13898.4,26,33,34,31,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G5*((DataSummary!$C$19/100)*Data!L5),1.1*330*Data!G5*Data!L5)","v":101277.00000000001}]
["COUNTY       ",1,"PAU"," Paulding County Garage (PAUCG)","Public Sanitary Sewer",392.64,12,48100.55,22,24,32,26,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G6*((DataSummary!$C$19/100)*Data!L6),1.1*330*Data!G6*Data!L6)","v":113256.00000000003}]
["COUNTY       ",1,"PUT"," Putnam County Garage (PUTCG)","Public Sanitary Sewer",421.82,15,144928.58000000002,19,20,30,23,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G7*((DataSummary!$C$19/100)*Data!L7),1.1*330*Data!G7*Data!L7)","v":125235.00000000001}]
["COUNTY       ",1,"VAN"," Van Wert  County Garage (VANCG)","Public Sanitary Sewer",379.66399999999999,15,115553.18000000001,25,23,29,25.666666666666668,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G8*((DataSummary!$C$19/100)*Data!L8),1.1*330*Data!G8*Data!L8)","v":139755.00000000003}]
["COUNTY       ",1,"WYA"," Wyandot County Garage (WYACG)","Public Sanitary Sewer",472.97999999999996,14,420273.44000000006,26,34,34,31.333333333333332,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G9*((DataSummary!$C$19/100)*Data!L9),1.1*330*Data!G9*Data!L9)","v":159236.00000000003}]
["COUNTY       ",2,"FUL"," Fulton County Garage (FULCG)","Public Sanitary Sewer",277.04000000000002,10,37676.6,25,16,19,20,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G10*((DataSummary!$C$19/100)*Data!L10),1.1*330*Data!G10*Data!L10)","v":72600.000000000015}]
["COUNTY       ",2,"HEN"," Henry County Garage (HENCG)","Lagoon for Brine",355.01,10,51849.2,26,19,26,23.666666666666668,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G11*((DataSummary!$C$19/100)*Data!L11),1.1*330*Data!G11*Data!L11)","v":85910.000000000015}]
["COUNTY       ",2,"LUC"," Lucas County Garage (LUCCG)","Washing at Fulton County",420.82,16,42103.4,28,25,31,28,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G12*((DataSummary!$C$19/100)*Data!L12),1.1*330*Data!G12*Data!L12)","v":162624.00000000003}]
["COUNTY       ",2,"OTT"," Ottawa County Garage (OTTCG)","Public Sanitary Sewer",357.51,10,7399.8,30,23,33,28.666666666666668,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G13*((DataSummary!$C$19/100)*Data!L13),1.1*330*Data!G13*Data!L13)","v":104060.00000000001}]
["COUNTY       ",2,"SAN"," Sandusky County Garage (SANCG)","Public Sanitary Sewer",394.64,12,63242.8,38,22,30,30,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G14*((DataSummary!$C$19/100)*Data!L14),1.1*330*Data!G14*Data!L14)","v":130680.00000000003}]
["COUNTY       ",2,"SEN"," Seneca  County Garage (SENCG)","Public Sanitary Sewer",407.44,14,37618.9,30,32,29,30.333333333333332,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G15*((DataSummary!$C$19/100)*Data!L15),1.1*330*Data!G15*Data!L15)","v":154154.00000000003}]
["COUNTY       ",2,"WIL"," Williams County Garage (WILCG)","Public Sanitary Sewer",373.24,14,44166.6,33,23,33,29.666666666666668,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G16*((DataSummary!$C$19/100)*Data!L16),1.1*330*Data!G16*Data!L16)","v":150766.00000000003}]
["COUNTY       ",2,"WOO"," Wood County Garage (WOOCG)","Public Sanitary Sewer",750.25,21,170978.45199999999,37,37,37,37,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G17*((DataSummary!$C$19/100)*Data!L17),1.1*330*Data!G17*Data!L17)","v":282051.00000000006}]
["COUNTY       ",3,"ASD"," Ashland County Garage (ASDCG)","Public Sanitary Sewer",601.36,16,34989.968000000001,45,41,49,45,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G18*((DataSummary!$C$19/100)*Data!L18),1.1*330*Data!G18*Data!L18)","v":261360.00000000003}]
["COUNTY       ",3,"CRA"," Crawford County Garage (CRACG)","Public Sanitary Sewer",412.05,14,88158,37,37,42,38.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G19*((DataSummary!$C$19/100)*Data!L19),1.1*330*Data!G19*Data!L19)","v":196504.00000000003}]
["COUNTY       ",3,"ERI"," Erie County Garage (ERICG)","Public Sanitary Sewer",380.13,12,29244.659999999996,37,36,39,37.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G20*((DataSummary!$C$19/100)*Data!L20),1.1*330*Data!G20*Data!L20)","v":162624.00000000006}]
["COUNTY       ",3,"HUR"," Huron County Garage (HURCG)","Holding Tank",459.24,13,26050,45,39,47,43.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G21*((DataSummary!$C$19/100)*Data!L21),1.1*330*Data!G21*Data!L21)","v":206063.00000000003}]
["COUNTY       ",3,"LOR"," Lorain County Garage (LORCG)","Public Sanitary Sewer",536.61,12,48451.240000000005,45,41,45,43.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G22*((DataSummary!$C$19/100)*Data!L22),1.1*330*Data!G22*Data!L22)","v":190212.00000000003}]
["COUNTY       ",3,"MED"," Medina County Garage (MEDCG)","Public Sanitary Sewer",635.67999999999984,22,50206.2,56,47,59,54,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G23*((DataSummary!$C$19/100)*Data!L23),1.1*330*Data!G23*Data!L23)","v":431244.00000000006}]
["COUNTY       ",3,"RIC"," Richland County Garage (RICCG)","Public Sanitary Sewer",618.1,12,46351.8,41,44,48,44.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G24*((DataSummary!$C$19/100)*Data!L24),1.1*330*Data!G24*Data!L24)","v":193116.00000000006}]
["COUNTY       ",3,"WAY"," Wayne County Garage (WAYCG)","Public Sanitary Sewer",590.66000000000008,17,22732.400000000001,34,36,44,38,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G25*((DataSummary!$C$19/100)*Data!L25),1.1*330*Data!G25*Data!L25)","v":234498.00000000003}]
["COUNTY       ",4,"ATB"," Ashtabula County Garage (ATBCG)","Public Sanitary Sewer",840.07999999999993,9,296016.59999999998,64,56,71,63.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G26*((DataSummary!$C$19/100)*Data!L26),1.1*330*Data!G26*Data!L26)","v":207999.00000000003}]
["COUNTY       ",4,"MAH"," Mahoning County (Canfield) County Garage (MAHCG)","Public Sanitary Sewer",645.15,9,212376.19,47,45,50,47.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G27*((DataSummary!$C$19/100)*Data!L27),1.1*330*Data!G27*Data!L27)","v":154638.00000000003}]
["COUNTY       ",4,"POR"," Portage County / Rootstown County Garage (PORCG)","Public Sanitary Sewer",494.97,11,254911.9,47,45,51,47.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G28*((DataSummary!$C$19/100)*Data!L28),1.1*330*Data!G28*Data!L28)","v":190333}]
["COUNTY       ",4,"STA"," Stark County Garage (STACG)","Public Sanitary Sewer",750.04000000000008,17,456846.8,46,41,47,44.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G29*((DataSummary!$C$19/100)*Data!L29),1.1*330*Data!G29*Data!L29)","v":275638}]
["COUNTY       ",4,"SUM"," Summit (Boston Heights) County Garage (SUMCG)","Class 5 Well (Septic Tank and Mound System or Leach Field)",579.84,10,427736.3,57,45,54,52,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G30*((DataSummary!$C$19/100)*Data!L30),1.1*330*Data!G30*Data!L30)","v":188760.00000000003}]
["COUNTY       ",4,"TRU"," Trumbull (Cortland) County Garage (TRUCG)","Public Sanitary Sewer",843.58,8,144389.20000000001,46,45,55,48.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G31*((DataSummary!$C$19/100)*Data!L31),1.1*330*Data!G31*Data!L31)","v":141328.00000000003}]
["COUNTY       ",5,"COS"," Coshocton County Garage (COSCG)","Public Sanitary Sewer",448.65000000000003,16,75077.399999999994,30,32,33,31.666666666666668,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G32*((DataSummary!$C$19/100)*Data!L32),1.1*330*Data!G32*Data!L32)","v":183920.00000000003}]
["COUNTY       ",5,"FAI"," (New) Fairfield Co garage (land) (FAICG)","Public Sanitary Sewer",414.27,15,87525.1,23,31,28,27.333333333333332,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G33*((DataSummary!$C$19/100)*Data!L33),1.1*330*Data!G33*Data!L33)","v":148830.00000000003}]
["COUNTY       ",5,"GUE"," Guernsey County Garage (GUECG)","Public Sanitary Sewer",622.15000000000009,12,157530.56199999998,30,34,36,{"$f":"AVERAGE(I34:K34)","v":33.333333333333336},{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G34*((DataSummary!$C$19/100)*Data!L34),1.1*330*Data!G34*Data!L34)","v":145200.00000000003}]
["COUNTY       ",5,"KNO"," Knox County Garage (KNOCG)","Public Sanitary Sewer",382.57,13,84096.9,29,32,38,33,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G35*((DataSummary!$C$19/100)*Data!L35),1.1*330*Data!G35*Data!L35)","v":155727.00000000003}]
["COUNTY       ",5,"LIC"," Utica Oupost Yard (LICPNW)","Class 5 Well (Septic Tank and Mound System or Leach Field)",693.28,6,106706.8,31,38,35,34.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G36*((DataSummary!$C$19/100)*Data!L36),1.1*330*Data!G36*Data!L36)","v":75504.000000000015}]
["COUNTY       ",5,"MUS"," Muskingum County Garage (MUSCG)","Class 5 Well (Septic Tank and Mound System or Leach Field)",694.44,11,68750.600000000006,32,37,37,35.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G37*((DataSummary!$C$19/100)*Data!L37),1.1*330*Data!G37*Data!L37)","v":141086.00000000003}]
["COUNTY       ",5,"PER"," Perry County Garage (PERCG)","Public Sanitary Sewer",363.51999999999992,15,78313.899999999994,20,30,26,25.333333333333332,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G38*((DataSummary!$C$19/100)*Data!L38),1.1*330*Data!G38*Data!L38)","v":137940.00000000003}]
["COUNTY       ",6,"DEL"," Delaware County Garage (DELCG)","Public Sanitary Sewer",556.56999999999994,11,141060.6,28,35,34,32.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G39*((DataSummary!$C$19/100)*Data!L39),1.1*330*Data!G39*Data!L39)","v":129107.00000000003}]
["COUNTY       ",6,"FAY"," Fayette County Garage (FAYCG)","Holding Tank",465.01,7,52385.7,29,32,38,33,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G40*((DataSummary!$C$19/100)*Data!L40),1.1*330*Data!G40*Data!L40)","v":83853.000000000015}]
["COUNTY       ",6,"FRA"," Franklin County Garage (FRACG)","Holding Tank",1456.1,13,121682.3,30,41,32,34.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G41*((DataSummary!$C$19/100)*Data!L41),1.1*330*Data!G41*Data!L41)","v":162019.00000000003}]
["COUNTY       ",6,"MAD"," Madison County Garage (MADCG)","Package Plant",613.0100000000001,8,27142.3,29,36,40,35,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G42*((DataSummary!$C$19/100)*Data!L42),1.1*330*Data!G42*Data!L42)","v":101640.00000000001}]
["COUNTY       ",6,"MAR"," Marion County Garage (MARCG)","Public Sanitary Sewer",422.6,14,86546.959999999992,29,32,38,33,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G43*((DataSummary!$C$19/100)*Data!L43),1.1*330*Data!G43*Data!L43)","v":167706.00000000003}]
["COUNTY       ",6,"MRW"," Morrow County Garage (MRWCG)","Holding Tank",408.54,10,63493.4,37,41,46,41.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G44*((DataSummary!$C$19/100)*Data!L44),1.1*330*Data!G44*Data!L44)","v":150040.00000000003}]
["COUNTY       ",6,"PIC"," Pickaway County Garage (PICCG)","holding tank/ oil water seperator",415.8,15,30724.379999999997,18,25,21,21.333333333333332,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G45*((DataSummary!$C$19/100)*Data!L45),1.1*330*Data!G45*Data!L45)","v":116160.00000000001}]
["COUNTY       ",6,"UNI"," Union County Garage (UNICG)","Public Sanitary Sewer",459.14,10,97577.8,25,36,38,33,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G46*((DataSummary!$C$19/100)*Data!L46),1.1*330*Data!G46*Data!L46)","v":119790.00000000001}]
["COUNTY       ",7,"AUG"," Auglaize County Garage (AUGCG)","Public Sanitary Sewer",466.07000000000005,17,32561.4,26,30,30,28.666666666666668,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G47*((DataSummary!$C$19/100)*Data!L47),1.1*330*Data!G47*Data!L47)","v":176902.00000000003}]
["COUNTY       ",7,"CHP"," Champaign County Garage (CHPCG)","Public Sanitary Sewer",407.53,10,51547.6,26,29,37,30.666666666666668,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G48*((DataSummary!$C$19/100)*Data!L48),1.1*330*Data!G48*Data!L48)","v":111320.00000000001}]
["COUNTY       ",7,"CLA"," Clark County Garage (CLACG)","Public Sanitary Sewer",493.82000000000005,9,96340.08,30,35,35,33.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G49*((DataSummary!$C$19/100)*Data!L49),1.1*330*Data!G49*Data!L49)","v":108900.00000000003}]
["COUNTY       ",7,"DAR"," Darke County Garage (DARCG)","Public Sanitary Sewer",536.47,14,51950,31,28,34,31,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G50*((DataSummary!$C$19/100)*Data!L50),1.1*330*Data!G50*Data!L50)","v":157542.00000000003}]
["COUNTY       ",7,"LOG"," Logan County Garage (LOGCG)","Public Sanitary Sewer",496.93,10,31114.402000000002,32,31,38,33.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G51*((DataSummary!$C$19/100)*Data!L51),1.1*330*Data!G51*Data!L51)","v":122210}]
["COUNTY       ",7,"MER"," Mercer County Garage (MERCG)","Public Sanitary Sewer",416.88,10,27680.2,23,22,30,25,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G52*((DataSummary!$C$19/100)*Data!L52),1.1*330*Data!G52*Data!L52)","v":90750.000000000015}]
["COUNTY       ",7,"MIA"," Miami County Garage (MIACG)","Public Sanitary Sewer",430.78,12,49070.75,26,30,34,30,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G53*((DataSummary!$C$19/100)*Data!L53),1.1*330*Data!G53*Data!L53)","v":130680.00000000003}]
["COUNTY       ",7,"MOT"," Montgomery County Garage (MOTCG)","Public Sanitary Sewer",534.51,11,113209.55,18,20,19,19,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G54*((DataSummary!$C$19/100)*Data!L54),1.1*330*Data!G54*Data!L54)","v":75867.000000000015}]
["COUNTY       ",7,"SHE"," Shelby County Garage (SHECG)","Public Sanitary Sewer",362.5,14,15907.6,29,30,31,30,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G55*((DataSummary!$C$19/100)*Data!L55),1.1*330*Data!G55*Data!L55)","v":152460.00000000003}]
["COUNTY       ",8,"BUT"," Butler County Garage (BUTCG)","Public Sanitary Sewer",410.99,15,37146,25,29,29,27.666666666666668,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G56*((DataSummary!$C$19/100)*Data!L56),1.1*330*Data!G56*Data!L56)","v":150645.00000000003}]
["COUNTY       ",8,"CLE"," Clermont County Garage (CLECG)","Public Sanitary Sewer",758.29000000000008,12,34113,21,21,25,22.333333333333332,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G57*((DataSummary!$C$19/100)*Data!L57),1.1*330*Data!G57*Data!L57)","v":97284.000000000015}]
["COUNTY       ",8,"CLI"," Clinton County Garage (CLICG)","Public Sanitary Sewer",509.95,12,22863,29,32,37,32.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G58*((DataSummary!$C$19/100)*Data!L58),1.1*330*Data!G58*Data!L58)","v":142296.00000000003}]
["COUNTY       ",8,"GRE"," Greene County Garage (GRECG)","Public Sanitary Sewer",447.29,14,19236,29,34,36,33,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G59*((DataSummary!$C$19/100)*Data!L59),1.1*330*Data!G59*Data!L59)","v":167706.00000000003}]
["COUNTY       ",8,"HAM"," Hamilton County Garage (new) (HAMCG)","Public Sanitary Sewer",940.81999999999994,18,43305.8,23,22,27,24,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G60*((DataSummary!$C$19/100)*Data!L60),1.1*330*Data!G60*Data!L60)","v":156816.00000000003}]
["COUNTY       ",8,"PRE"," Preble County Garage (PRECG)","Aeration System",411.11,null,18025.05,29,33,41,34.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G61*((DataSummary!$C$19/100)*Data!L61),1.1*330*Data!G61*Data!L61)","v":0}]
["COUNTY       ",8,"WAR"," Warren County Garage (WARCG)","Public Sanitary Sewer",559.58000000000004,14,14686.6,24,29,30,27.666666666666668,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G62*((DataSummary!$C$19/100)*Data!L62),1.1*330*Data!G62*Data!L62)","v":140602.00000000003}]
["COUNTY       ",9,"ADA"," Adams County GarageI (ADACG)","The county will begin hookup to a sanitary sewer June 6",488.1,10,7466.2,16,18,20,18,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G63*((DataSummary!$C$19/100)*Data!L63),1.1*330*Data!G63*Data!L63)","v":65340.000000000007}]
["COUNTY       ",9,"BRO"," Brown County Garage (BROCG)","Public Sanitary Sewer",474.90999999999997,10,3982,16,17,22,18.333333333333332,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G64*((DataSummary!$C$19/100)*Data!L64),1.1*330*Data!G64*Data!L64)","v":66550}]
["COUNTY       ",9,"HIG"," Highland County Garage (HIGCG)","Public Sanitary Sewer",495.56,15,null,20,20,25,21.666666666666668,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G65*((DataSummary!$C$19/100)*Data!L65),1.1*330*Data!G65*Data!L65)","v":117975.00000000003}]
["COUNTY       ",9,"JAC"," Jackson County Garage (JACCG)","Package Plant",450.5,14,5925,15,22,19,{"$f":"AVERAGE(I66:K66)","v":18.666666666666668},{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G66*((DataSummary!$C$19/100)*Data!L66),1.1*330*Data!G66*Data!L66)","v":94864.000000000029}]
["COUNTY       ",9,"LAW"," LAWRENCE CO GARAGE (LAWCG)","Public Sanitary Sewer",409.89000000000004,7,4552,11,15,15,13.666666666666666,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G67*((DataSummary!$C$19/100)*Data!L67),1.1*330*Data!G67*Data!L67)","v":34727.000000000007}]
["COUNTY       ",9,"PIK"," Pike County Garage (PIKCG)","Public Sanitary Sewer",360.78000000000003,12,1280,8,15,16,13,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G68*((DataSummary!$C$19/100)*Data!L68),1.1*330*Data!G68*Data!L68)","v":56628.000000000015}]
["COUNTY       ",9,"ROS"," Ross County Garage (ROSCG)","Public Sanitary Sewer",552.84999999999991,18,10605.6,17,25,19,20.333333333333332,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G69*((DataSummary!$C$19/100)*Data!L69),1.1*330*Data!G69*Data!L69)","v":132858}]
["COUNTY       ",9,"SCI"," Scioto County Garage (SCICG)","Public Sanitary Sewer",444.96000000000004,9,5684,10,15,14,13,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G70*((DataSummary!$C$19/100)*Data!L70),1.1*330*Data!G70*Data!L70)","v":42471.000000000007}]
["COUNTY       ",10,"ATH"," Athens County Garage (ATHCG)","Public Sanitary Sewer",515.20000000000005,12,105152.2,17,25,21,21,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G71*((DataSummary!$C$19/100)*Data!L71),1.1*330*Data!G71*Data!L71)","v":91476.000000000015}]
["COUNTY       ",10,"GAL"," Gallia County Garage (GALCG)","Public Sanitary Sewer",448.08,13,16147,11,19,17,15.666666666666666,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G72*((DataSummary!$C$19/100)*Data!L72),1.1*330*Data!G72*Data!L72)","v":73931.000000000015}]
["COUNTY       ",10,"HOC"," Hocking County Garage (HOCCG)","Public Sanitary Sewer",367.82,13,53664,22,26,19,22.333333333333332,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G73*((DataSummary!$C$19/100)*Data!L73),1.1*330*Data!G73*Data!L73)","v":105391.00000000001}]
["COUNTY       ",10,"MEG"," Meigs County Garage (MEGCG)","Holding Tank",423.58,15,53918.8,11,20,17,16,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G74*((DataSummary!$C$19/100)*Data!L74),1.1*330*Data!G74*Data!L74)","v":87120.000000000015}]
["COUNTY       ",10,"MOE"," Monroe County Garage (MOECG)","Public Sanitary Sewer",434.11,12,24247.8,25,27,27,26.333333333333332,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G75*((DataSummary!$C$19/100)*Data!L75),1.1*330*Data!G75*Data!L75)","v":114708.00000000001}]
["COUNTY       ",10,"MRG"," Morgan County Garage (MRGCG)","Holding Tank",384.15,12,66936,23,23,25,23.666666666666668,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G76*((DataSummary!$C$19/100)*Data!L76),1.1*330*Data!G76*Data!L76)","v":103092.00000000003}]
["COUNTY       ",10,"NOB"," Noble County County Garage (NOBCG)","Public Sanitary Sewer",474.02,15,31097,21,29,24,24.666666666666668,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G77*((DataSummary!$C$19/100)*Data!L77),1.1*330*Data!G77*Data!L77)","v":134310.00000000003}]
["COUNTY       ",10,"VIN"," Vinton County Garage (VINCG)","Holding Tank",337.57,10,16824,16,25,22,21,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G78*((DataSummary!$C$19/100)*Data!L78),1.1*330*Data!G78*Data!L78)","v":76230.000000000015}]
["COUNTY       ",10,"WAS"," Washington County Garage (WASCG)","Public Sanitary Sewer",605.68000000000006,24,50049,23,26,24,24.333333333333332,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G79*((DataSummary!$C$19/100)*Data!L79),1.1*330*Data!G79*Data!L79)","v":211992.00000000003}]
["COUNTY       ",11,"BEL"," Belmont County Garage (BELCG)","Public Sanitary Sewer",690.24,12,52723.9,34,39,35,36,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G80*((DataSummary!$C$19/100)*Data!L80),1.1*330*Data!G80*Data!L80)","v":156816.00000000003}]
["COUNTY       ",11,"CAR"," Carroll County Garage (CARCG)","Public Sanitary Sewer",305.09000000000003,13,20607.400000000001,30,34,36,33.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G81*((DataSummary!$C$19/100)*Data!L81),1.1*330*Data!G81*Data!L81)","v":157300.00000000003}]
["COUNTY       ",11,"COL"," Columbiana County Garage (COLCG)","Class 5 Well (Septic Tank and Mound System or Leach Field)",653.87,14,33686.800000000003,37,38,47,40.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G82*((DataSummary!$C$19/100)*Data!L82),1.1*330*Data!G82*Data!L82)","v":206668.00000000003}]
["COUNTY       ",11,"HAS"," Harrison County Garage (HASCG)","Public Sanitary Sewer",349.59000000000003,8,2639,34,37,40,37,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G83*((DataSummary!$C$19/100)*Data!L83),1.1*330*Data!G83*Data!L83)","v":107448.00000000001}]
["COUNTY       ",11,"HOL"," Holmes County Garage (HOLCG)","Public Sanitary Sewer",350.52000000000004,10,null,27,31,33,30.333333333333332,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G84*((DataSummary!$C$19/100)*Data!L84),1.1*330*Data!G84*Data!L84)","v":110110.00000000001}]
["COUNTY       ",11,"JEF"," Jefferson County Garage (JEFCG)","Public Sanitary Sewer",457.24,12,39285,36,40,39,38.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G85*((DataSummary!$C$19/100)*Data!L85),1.1*330*Data!G85*Data!L85)","v":166980.00000000006}]
["COUNTY       ",11,"TUS"," Tuscarawas County Garage (TUSCG)","Class 5 Well (Septic Tank and Mound System or Leach Field)",521.64,11,48040.563999999998,31,38,34,34.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G86*((DataSummary!$C$19/100)*Data!L86),1.1*330*Data!G86*Data!L86)","v":137093.00000000003}]
["COUNTY       ",12,"GEA"," Geauga County Garage (GEACG)","Runoff / Storm Sewer",412.51,8,208667.4,54,51,79,61.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G87*((DataSummary!$C$19/100)*Data!L87),1.1*330*Data!G87*Data!L87)","v":178112.00000000003}]
["COUNTY       ",12,"LAK"," Lake County Garage (New) (LAKCG)","Public Sanitary Sewer",364.76,null,7502,59,53,70,60.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G88*((DataSummary!$C$19/100)*Data!L88),1.1*330*Data!G88*Data!L88)","v":0}]
["DISTRICT     ",1,"ALL"," District 1 HQ (New) (ALLHQ)",0,null,null,null,27,27,35,29.666666666666668,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G89*((DataSummary!$C$19/100)*Data!L89),1.1*330*Data!G89*Data!L89)","v":0}]
["DISTRICT     ",2,"WOO"," District 2 HQ Office (WOOHQ)",0,null,null,null,37,37,37,37,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G90*((DataSummary!$C$19/100)*Data!L90),1.1*330*Data!G90*Data!L90)","v":0}]
["DISTRICT     ",3,"ASD"," District 3 HQ Office (New) (ASDHQ)","Public Sanitary Sewer",null,null,null,45,41,49,45,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G91*((DataSummary!$C$19/100)*Data!L91),1.1*330*Data!G91*Data!L91)","v":0}]
["DISTRICT     ",4,"SUM"," District Four Headquarters (SUMHQ)","Public Sanitary Sewer",null,null,null,57,45,54,52,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G92*((DataSummary!$C$19/100)*Data!L92),1.1*330*Data!G92*Data!L92)","v":0}]
["DISTRICT     ",5,"LIC"," District 5 HQ Office & Garage (LICHQ)","Package Plant",null,null,null,31,38,35,34.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G93*((DataSummary!$C$19/100)*Data!L93),1.1*330*Data!G93*Data!L93)","v":0}]
["DISTRICT     ",6,"DEL"," Dist. 6 HQ Office(renov'd. 1992) (DELHQ)","Holding Tank",null,null,null,28,35,34,32.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G94*((DataSummary!$C$19/100)*Data!L94),1.1*330*Data!G94*Data!L94)","v":0}]
["DISTRICT     ",7,"SHE"," District 7 HQ Office (SHEHQ)","Public Sanitary Sewer",null,null,null,29,30,31,30,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G95*((DataSummary!$C$19/100)*Data!L95),1.1*330*Data!G95*Data!L95)","v":0}]
["DISTRICT     ",8,"WAR"," District 8 HQ Office (WARHQ)","Public Sanitary Sewer",null,null,null,24,29,30,27.666666666666668,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G96*((DataSummary!$C$19/100)*Data!L96),1.1*330*Data!G96*Data!L96)","v":0}]
["DISTRICT     ",9,"ROS"," District 9 HQ Office (ROSHQ)","Public Sanitary Sewer",null,null,null,17,25,19,20.333333333333332,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G97*((DataSummary!$C$19/100)*Data!L97),1.1*330*Data!G97*Data!L97)","v":0}]
["DISTRICT     ",10,"WAS"," District 10 HQ Garage (WASDG)","Public Sanitary Sewer",null,null,null,23,26,24,{"$f":"AVERAGE(I98:K98)","v":24.333333333333332},{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G98*((DataSummary!$C$19/100)*Data!L98),1.1*330*Data!G98*Data!L98)","v":0}]
["DISTRICT     ",10,"WAS"," District 10 HQ Office (WASHQ)",0,null,null,38212.303999999996,23,26,24,24.333333333333332,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G99*((DataSummary!$C$19/100)*Data!L99),1.1*330*Data!G99*Data!L99)","v":0}]
["DISTRICT     ",11,"TUS"," District 11 HQ Office (New) (TUSHQ)","Public Sanitary Sewer",null,null,null,31,38,34,null,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G100*((DataSummary!$C$19/100)*Data!L100),1.1*330*Data!G100*Data!L100)","v":0}]
["DISTRICT     ",12,"CUY"," District 12 HQ Office (CUYHQ)","Public Sanitary Sewer",1030.5600000000002,null,null,65,54,77,null,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G101*((DataSummary!$C$19/100)*Data!L101),1.1*330*Data!G101*Data!L101)","v":0}]
["OUTPOST     ",1,"ALL","Beaverdam Outpost Garage (ALLPNE)","Public Sanitary Sewer",null,4,null,27,27,35,{"$f":"AVERAGE(I102:K102)","v":29.666666666666668},{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G102*((DataSummary!$C$19/100)*Data!L102),1.1*330*Data!G102*Data!L102)","v":43076.000000000007}]
["OUTPOST     ",1,"ALL"," Delphos Outpost Garage (ALLPNW)","Public Sanitary Sewer",null,3,null,27,27,35,29.666666666666668,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G103*((DataSummary!$C$19/100)*Data!L103),1.1*330*Data!G103*Data!L103)","v":32307.000000000007}]
["OUTPOST     ",1,"ALL"," Lima / 4th St. Outpost Garage (ALLPCT)","Public Sanitary Sewer",null,4,null,27,27,35,29.666666666666668,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G104*((DataSummary!$C$19/100)*Data!L104),1.1*330*Data!G104*Data!L104)","v":43076.000000000007}]
["OUTPOST     ",1,"DEF"," Hicksville Outpost Garage (DEFPSW)","Public Sanitary Sewer",null,1,null,23,24,28,25,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G105*((DataSummary!$C$19/100)*Data!L105),1.1*330*Data!G105*Data!L105)","v":9075.0000000000018}]
["OUTPOST     ",1,"HAN"," Findlay Outpost Garage (HANPCT)","Public Sanitary Sewer",null,12,null,29,34,31,31.333333333333332,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G106*((DataSummary!$C$19/100)*Data!L106),1.1*330*Data!G106*Data!L106)","v":136488.00000000003}]
["OUTPOST     ",1,"HAR"," Roundhead Outpost Garage (HARPSW)",0,null,2,null,26,33,34,31,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G107*((DataSummary!$C$19/100)*Data!L107),1.1*330*Data!G107*Data!L107)","v":22506.000000000004}]
["OUTPOST     ",1,"PAU"," Paulding County Outpost (PAUPNO)",0,null,null,null,22,24,32,26,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G108*((DataSummary!$C$19/100)*Data!L108),1.1*330*Data!G108*Data!L108)","v":0}]
["OUTPOST     ",1,"WYA"," Carey Outpost Garage (WYAPNW)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,2,null,26,34,34,31.333333333333332,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G109*((DataSummary!$C$19/100)*Data!L109),1.1*330*Data!G109*Data!L109)","v":22748.000000000004}]
["OUTPOST     ",2,"OTT"," Edison Bridge Outpost Garage (OTTPEA)",0,null,4,null,30,23,33,28.666666666666668,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G110*((DataSummary!$C$19/100)*Data!L110),1.1*330*Data!G110*Data!L110)","v":41624.000000000007}]
["OUTPOST     ",2,"WOO"," Northwood Outpost Garage (WOOPNE)","Public Sanitary Sewer",null,16,null,37,37,37,37,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G111*((DataSummary!$C$19/100)*Data!L111),1.1*330*Data!G111*Data!L111)","v":214896.00000000003}]
["OUTPOST     ",3,"ASD"," Nova Outpost (ASDPNW)",0,null,null,null,45,41,49,{"$f":"AVERAGE(I112:K112)","v":45},{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G112*((DataSummary!$C$19/100)*Data!L112),1.1*330*Data!G112*Data!L112)","v":0}]
["OUTPOST     ",3,"ASD"," Perrysville Outpost Garage (ASDPSO)","Runoff / Storm Sewer",null,4,null,45,41,49,45,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G113*((DataSummary!$C$19/100)*Data!L113),1.1*330*Data!G113*Data!L113)","v":65340.000000000007}]
["OUTPOST     ",3,"ERI"," Vermillion Outpost Garage (ERIPNE)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,2,null,37,36,39,37.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G114*((DataSummary!$C$19/100)*Data!L114),1.1*330*Data!G114*Data!L114)","v":27104.000000000007}]
["OUTPOST     ",3,"HUR"," Plymouth Outpost Garage (HURPSE)","Runoff / Storm Sewer",null,2,null,45,39,47,43.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G115*((DataSummary!$C$19/100)*Data!L115),1.1*330*Data!G115*Data!L115)","v":31702.000000000004}]
["OUTPOST     ",3,"LOR"," Avon Outpost Garage (LORPNE)","Public Sanitary Sewer",null,6,null,45,41,45,43.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G116*((DataSummary!$C$19/100)*Data!L116),1.1*330*Data!G116*Data!L116)","v":95106.000000000015}]
["OUTPOST     ",3,"MED"," Burbank Outpost Garage (MEDPSW)","Runoff / Storm Sewer",null,7,null,56,47,59,54,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G117*((DataSummary!$C$19/100)*Data!L117),1.1*330*Data!G117*Data!L117)","v":137214.00000000003}]
["OUTPOST     ",3,"RIC"," Lexington Outpost Garage (RICPSW)","Runoff / Storm Sewer",null,8,null,41,44,48,44.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G118*((DataSummary!$C$19/100)*Data!L118),1.1*330*Data!G118*Data!L118)","v":128744.00000000003}]
["OUTPOST     ",4,"ATB"," Conneaut Outpost Garage (ATBPNE)","Package Plant",null,5,null,64,56,71,63.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G119*((DataSummary!$C$19/100)*Data!L119),1.1*330*Data!G119*Data!L119)","v":115555.00000000001}]
["OUTPOST     ",4,"ATB"," Dorset Outpost Garage (ATBPCT)","Holding Tank",null,4,null,64,56,71,63.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G120*((DataSummary!$C$19/100)*Data!L120),1.1*330*Data!G120*Data!L120)","v":92444.000000000015}]
["OUTPOST     ",4,"ATB"," Harperfield Outpost Garage (ATBPNW)",0,null,3,null,64,56,71,63.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G121*((DataSummary!$C$19/100)*Data!L121),1.1*330*Data!G121*Data!L121)","v":69333.000000000015}]
["OUTPOST     ",4,"ATB"," Rome Outpost Garage (ATBPSW)","Holding Tank",null,4,null,64,56,71,63.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G122*((DataSummary!$C$19/100)*Data!L122),1.1*330*Data!G122*Data!L122)","v":92444.000000000015}]
["OUTPOST     ",4,"ATB"," Williamsfield Outpost Garage (ATBPSE)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,4,null,64,56,71,63.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G123*((DataSummary!$C$19/100)*Data!L123),1.1*330*Data!G123*Data!L123)","v":92444.000000000015}]
["OUTPOST     ",4,"MAH"," Bailey Road Outpost Garage (MAHPNW)","Public Sanitary Sewer",null,4,null,47,45,50,47.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G124*((DataSummary!$C$19/100)*Data!L124),1.1*330*Data!G124*Data!L124)","v":68728.000000000015}]
["OUTPOST     ",4,"MAH"," N. Lima Outpost (MAHPSE)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,8,null,47,45,50,47.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G125*((DataSummary!$C$19/100)*Data!L125),1.1*330*Data!G125*Data!L125)","v":137456.00000000003}]
["OUTPOST     ",4,"MAH"," Sebring Outpost Garage (MAHPWE)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,2,null,47,45,50,47.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G126*((DataSummary!$C$19/100)*Data!L126),1.1*330*Data!G126*Data!L126)","v":34364.000000000007}]
["OUTPOST     ",4,"MAH"," South Avenue Outpost Yard (MAHPNE)",0,null,null,null,47,45,50,47.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G127*((DataSummary!$C$19/100)*Data!L127),1.1*330*Data!G127*Data!L127)","v":0}]
["OUTPOST     ",4,"POR"," Drakesburg Outpost Garage (PORPNE)","Holding Tank",null,5,null,47,45,51,47.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G128*((DataSummary!$C$19/100)*Data!L128),1.1*330*Data!G128*Data!L128)","v":86515}]
["OUTPOST     ",4,"POR"," Yale Outpost Garage (PORPSE)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,4,null,47,45,51,47.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G129*((DataSummary!$C$19/100)*Data!L129),1.1*330*Data!G129*Data!L129)","v":69212.000000000015}]
["OUTPOST     ",4,"STA"," Alliance Outpost Yard (STAPNE)",0,null,null,null,46,41,47,44.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G130*((DataSummary!$C$19/100)*Data!L130),1.1*330*Data!G130*Data!L130)","v":0}]
["OUTPOST     ",4,"STA"," Canal Fulton Outpost Yard (STAPNW)",0,null,null,null,46,41,47,44.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G131*((DataSummary!$C$19/100)*Data!L131),1.1*330*Data!G131*Data!L131)","v":0}]
["OUTPOST     ",4,"STA"," Millersburg Rd. Outpost Yard (STAPWE)",0,null,null,null,46,41,47,44.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G132*((DataSummary!$C$19/100)*Data!L132),1.1*330*Data!G132*Data!L132)","v":0}]
["OUTPOST     ",4,"SUM"," Greensburg Airport Outpost Garage (SUMPSE)","Runoff / Storm Sewer",null,4,null,57,45,54,52,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G133*((DataSummary!$C$19/100)*Data!L133),1.1*330*Data!G133*Data!L133)","v":75504.000000000015}]
["OUTPOST     ",4,"SUM"," Interchange / Norton Outpost Garage (SUMPWE)","Package Plant",null,7,null,57,45,54,52,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G134*((DataSummary!$C$19/100)*Data!L134),1.1*330*Data!G134*Data!L134)","v":132132.00000000003}]
["OUTPOST     ",4,"SUM"," Kelly Avenue Outpost Garage (SUMPEA)","Public Sanitary Sewer",null,null,null,57,45,54,52,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G135*((DataSummary!$C$19/100)*Data!L135),1.1*330*Data!G135*Data!L135)","v":0}]
["OUTPOST     ",4,"SUM"," Twinsburg Outpost Garage (SUMPNE)","Runoff / Storm Sewer",null,5,null,57,45,54,52,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G136*((DataSummary!$C$19/100)*Data!L136),1.1*330*Data!G136*Data!L136)","v":94380.000000000015}]
["OUTPOST     ",4,"TRU"," Brookfield Outpost Garage (TRUPSE)","Holding Tank",null,7,null,46,45,55,48.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G137*((DataSummary!$C$19/100)*Data!L137),1.1*330*Data!G137*Data!L137)","v":123662.00000000001}]
["OUTPOST     ",4,"TRU"," Gustavus Outpost Garage (TRUPNO)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,6,null,46,45,55,48.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G138*((DataSummary!$C$19/100)*Data!L138),1.1*330*Data!G138*Data!L138)","v":105996.00000000001}]
["OUTPOST     ",4,"TRU"," Trumbull Construction Office (TRUCON)",0,null,null,null,46,45,55,48.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G139*((DataSummary!$C$19/100)*Data!L139),1.1*330*Data!G139*Data!L139)","v":0}]
["OUTPOST     ",4,"TRU"," Warren Outpost Yard (TRUPSW)",0,null,5,null,46,45,55,48.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G140*((DataSummary!$C$19/100)*Data!L140),1.1*330*Data!G140*Data!L140)","v":88330}]
["OUTPOST     ",4,"TRU"," West Farmington Outpost Garage (TRUPEA)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,4,null,46,45,55,48.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G141*((DataSummary!$C$19/100)*Data!L141),1.1*330*Data!G141*Data!L141)","v":70664.000000000015}]
["OUTPOST     ",5,"COS"," New Castle Outpost Yard (COSPWE)",0,null,0,null,30,32,33,31.666666666666668,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G142*((DataSummary!$C$19/100)*Data!L142),1.1*330*Data!G142*Data!L142)","v":0}]
["OUTPOST     ",5,"FAI"," Baltimore Outpost Garage (FAIPNO)","Public Sanitary Sewer",null,null,null,23,31,28,27.333333333333332,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G143*((DataSummary!$C$19/100)*Data!L143),1.1*330*Data!G143*Data!L143)","v":0}]
["OUTPOST     ",5,"FAI"," US Route 664 (FAIPEA)",0,null,0,null,23,31,28,27.333333333333332,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G144*((DataSummary!$C$19/100)*Data!L144),1.1*330*Data!G144*Data!L144)","v":0}]
["OUTPOST     ",5,"GUE"," Cumberland Outpost Yard (GUEPSW)",0,null,0,null,30,34,36,33.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G145*((DataSummary!$C$19/100)*Data!L145),1.1*330*Data!G145*Data!L145)","v":0}]
["OUTPOST     ",5,"GUE"," North Salem Outpost Garage (GUEPNW)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,5,null,30,34,36,33.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G146*((DataSummary!$C$19/100)*Data!L146),1.1*330*Data!G146*Data!L146)","v":60500.000000000015}]
["OUTPOST     ",5,"GUE"," Old Washington Outpost Garage (GUEPCT)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,6,null,30,34,36,33.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G147*((DataSummary!$C$19/100)*Data!L147),1.1*330*Data!G147*Data!L147)","v":72600.000000000015}]
["OUTPOST     ",5,"KNO"," Fredricktown Outpost Garage (KNOPNW)","Public Sanitary Sewer",null,2,null,29,32,38,33,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G148*((DataSummary!$C$19/100)*Data!L148),1.1*330*Data!G148*Data!L148)","v":23958.000000000004}]
["OUTPOST     ",5,"KNO"," Millwood Outpost Garage (KNOPEA)",0,null,0,null,29,32,38,33,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G149*((DataSummary!$C$19/100)*Data!L149),1.1*330*Data!G149*Data!L149)","v":0}]
["OUTPOST     ",5,"LIC"," Brownsville Outpost Garage (LICPSE)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,5,null,31,38,35,34.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G150*((DataSummary!$C$19/100)*Data!L150),1.1*330*Data!G150*Data!L150)","v":62920}]
["OUTPOST     ",5,"LIC"," Etna Outpost Garage (LICPSW)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,7,null,31,38,35,34.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G151*((DataSummary!$C$19/100)*Data!L151),1.1*330*Data!G151*Data!L151)","v":88088.000000000015}]
["OUTPOST     ",5,"LIC"," Marne Outpost Yard (LICPEA)",0,null,0,null,31,38,35,34.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G152*((DataSummary!$C$19/100)*Data!L152),1.1*330*Data!G152*Data!L152)","v":0}]
["OUTPOST     ",5,"MUS"," Dresden Outpost Garage (MUSPNO)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,5,null,32,37,37,35.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G153*((DataSummary!$C$19/100)*Data!L153),1.1*330*Data!G153*Data!L153)","v":64130.000000000015}]
["OUTPOST     ",5,"MUS"," Duncan Falls Outpost Garage (MUSPSO)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,5,null,32,37,37,35.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G154*((DataSummary!$C$19/100)*Data!L154),1.1*330*Data!G154*Data!L154)","v":64130.000000000015}]
["OUTPOST     ",5,"MUS"," Moxahala Outpost Garage (MUSPSW)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,3,null,32,37,37,35.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G155*((DataSummary!$C$19/100)*Data!L155),1.1*330*Data!G155*Data!L155)","v":38478.000000000007}]
["OUTPOST     ",5,"PER"," Shawnee Outpost Yard (PERPSO)",0,null,null,null,20,30,26,25.333333333333332,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G156*((DataSummary!$C$19/100)*Data!L156),1.1*330*Data!G156*Data!L156)","v":0}]
["OUTPOST     ",6,"DEL"," Sunbury Outpost Garage (DELPEA)",0,null,null,null,28,35,34,32.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G157*((DataSummary!$C$19/100)*Data!L157),1.1*330*Data!G157*Data!L157)","v":0}]
["OUTPOST     ",6,"FAY"," Jeffersonville Outpost Garage (FAYPNW)","Holding Tank",null,6,null,29,32,38,33,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G158*((DataSummary!$C$19/100)*Data!L158),1.1*330*Data!G158*Data!L158)","v":71874.000000000015}]
["OUTPOST     ",6,"FRA"," Canal Winchester Outpost Yard (FRAPSE)",0,null,null,null,30,41,32,34.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G159*((DataSummary!$C$19/100)*Data!L159),1.1*330*Data!G159*Data!L159)","v":0}]
["OUTPOST     ",6,"FRA"," Fifth Avenue Outpost Garage (FRAPEA)","Holding Tank",null,15,null,30,41,32,34.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G160*((DataSummary!$C$19/100)*Data!L160),1.1*330*Data!G160*Data!L160)","v":186945.00000000006}]
["OUTPOST     ",6,"FRA"," Grove City Outpost Garage (FRAPSW)","Holding Tank",null,13,null,30,41,32,34.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G161*((DataSummary!$C$19/100)*Data!L161),1.1*330*Data!G161*Data!L161)","v":162019.00000000003}]
["OUTPOST     ",6,"FRA"," Roberts Road (Hilliard) Outpost Garage (FRAPWE)","Holding Tank",null,13,null,30,41,32,34.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G162*((DataSummary!$C$19/100)*Data!L162),1.1*330*Data!G162*Data!L162)","v":162019.00000000003}]
["OUTPOST     ",6,"FRA"," Worthington/Wilson Bridge Outpost Garage (FRAPNO)","Holding Tank",null,null,null,30,41,32,34.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G163*((DataSummary!$C$19/100)*Data!L163),1.1*330*Data!G163*Data!L163)","v":0}]
["OUTPOST     ",6,"MAD"," Land Outpost (MADPNW)",0,null,null,null,29,36,40,35,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G164*((DataSummary!$C$19/100)*Data!L164),1.1*330*Data!G164*Data!L164)","v":0}]
["OUTPOST     ",6,"MAD"," Mount Sterling Outpost Garage (MADPSE)","Runoff / Storm Sewer",null,6,null,29,36,40,35,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G165*((DataSummary!$C$19/100)*Data!L165),1.1*330*Data!G165*Data!L165)","v":76230.000000000015}]
["OUTPOST     ",6,"MAD"," West Jefferson Outpost Garage (MADPEA)","Package Plant",null,6,null,29,36,40,35,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G166*((DataSummary!$C$19/100)*Data!L166),1.1*330*Data!G166*Data!L166)","v":76230.000000000015}]
["OUTPOST     ",6,"MRW"," Chesterville Outpost Garage (MRWPEA)","Holding Tank",null,4,null,37,41,46,41.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G167*((DataSummary!$C$19/100)*Data!L167),1.1*330*Data!G167*Data!L167)","v":60016.000000000015}]
["OUTPOST     ",6,"UNI"," Richwood Outpost Garage (UNIPNE)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,6,null,25,36,38,33,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G168*((DataSummary!$C$19/100)*Data!L168),1.1*330*Data!G168*Data!L168)","v":71874.000000000015}]
["OUTPOST     ",7,"AUG"," Saint Marys Outpost Garage (AUGPWE)","Public Sanitary Sewer",null,null,null,26,30,30,28.666666666666668,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G169*((DataSummary!$C$19/100)*Data!L169),1.1*330*Data!G169*Data!L169)","v":0}]
["OUTPOST     ",7,"CHP"," Mechanicsburg Outpost Garage (CHPPEA)","Holding Tank",null,3,null,26,29,37,30.666666666666668,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G170*((DataSummary!$C$19/100)*Data!L170),1.1*330*Data!G170*Data!L170)","v":33396.000000000007}]
["OUTPOST     ",7,"CHP"," Saint Paris Outpost Garage (CHPPWE)","Holding Tank",null,2,null,26,29,37,30.666666666666668,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G171*((DataSummary!$C$19/100)*Data!L171),1.1*330*Data!G171*Data!L171)","v":22264.000000000004}]
["OUTPOST     ",7,"CLA"," Enon Outpost Garage (CLAPSW)","Holding Tank",null,5,null,30,35,35,33.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G172*((DataSummary!$C$19/100)*Data!L172),1.1*330*Data!G172*Data!L172)","v":60500.000000000015}]
["OUTPOST     ",7,"CLA"," Harmony Outpost Garage (CLAPEA)","Holding Tank",null,4,null,30,35,35,33.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G173*((DataSummary!$C$19/100)*Data!L173),1.1*330*Data!G173*Data!L173)","v":48400.000000000015}]
["OUTPOST     ",7,"DAR"," Dawn Outpost Garage (DARPNO)","Holding Tank",null,5,null,31,28,34,31,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G174*((DataSummary!$C$19/100)*Data!L174),1.1*330*Data!G174*Data!L174)","v":56265.000000000007}]
["OUTPOST     ",7,"DAR"," Fort Jefferson Outpost Yard (DARPSO)",0,null,null,null,31,28,34,31,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G175*((DataSummary!$C$19/100)*Data!L175),1.1*330*Data!G175*Data!L175)","v":0}]
["OUTPOST     ",7,"LOG"," East Liberty Outpost Garage (LOGPSE)","Holding Tank",null,5,null,32,31,38,{"$f":"AVERAGE(I176:K176)","v":33.666666666666664},{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G176*((DataSummary!$C$19/100)*Data!L176),1.1*330*Data!G176*Data!L176)","v":61105}]
["OUTPOST     ",7,"LOG"," Lakeview Outpost Garage (LOGPNW)","Public Sanitary Sewer",null,3,null,32,31,38,33.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G177*((DataSummary!$C$19/100)*Data!L177),1.1*330*Data!G177*Data!L177)","v":36663.000000000007}]
["OUTPOST     ",7,"LOG"," Old Northwood Outpost (LOGPCE)",0,null,null,null,32,31,38,33.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G178*((DataSummary!$C$19/100)*Data!L178),1.1*330*Data!G178*Data!L178)","v":0}]
["OUTPOST     ",7,"MER"," Cassella Outpost Garage (MERPSO)","Holding Tank",null,3,null,23,22,30,25,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G179*((DataSummary!$C$19/100)*Data!L179),1.1*330*Data!G179*Data!L179)","v":27225.000000000007}]
["OUTPOST     ",7,"MER"," Mercer Outpost Garage (MERPNO)","Holding Tank",null,3,null,23,22,30,25,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G180*((DataSummary!$C$19/100)*Data!L180),1.1*330*Data!G180*Data!L180)","v":27225.000000000007}]
["OUTPOST     ",7,"MIA"," Ludlow Falls Outpost Land (MIAPSW)",0,null,null,null,26,30,34,30,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G181*((DataSummary!$C$19/100)*Data!L181),1.1*330*Data!G181*Data!L181)","v":0}]
["OUTPOST     ",7,"MIA"," Piqua Outpost Garage (MIAPNO)","Public Sanitary Sewer",null,5,null,26,30,34,30,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G182*((DataSummary!$C$19/100)*Data!L182),1.1*330*Data!G182*Data!L182)","v":54450.000000000007}]
["OUTPOST     ",7,"MOT"," 5994 Poe Avenue (MOTPCT)",0,null,null,null,18,20,19,19,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G183*((DataSummary!$C$19/100)*Data!L183),1.1*330*Data!G183*Data!L183)","v":0}]
["OUTPOST     ",7,"MOT"," Lyons Road Outpost Garage (MOTPSE)","Public Sanitary Sewer",null,10,null,18,20,19,19,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G184*((DataSummary!$C$19/100)*Data!L184),1.1*330*Data!G184*Data!L184)","v":68970.000000000015}]
["OUTPOST     ",7,"MOT"," Shull Road Outpost Garage (MOTPNE)","Public Sanitary Sewer",null,null,null,18,20,19,19,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G185*((DataSummary!$C$19/100)*Data!L185),1.1*330*Data!G185*Data!L185)","v":0}]
["OUTPOST     ",7,"SHE"," Dixie Outpost Yard (SHEPNO)",0,null,null,null,29,30,31,30,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G186*((DataSummary!$C$19/100)*Data!L186),1.1*330*Data!G186*Data!L186)","v":0}]
["OUTPOST     ",7,"SHE"," Newport Outpost Garage (SHEPSW)",0,null,null,null,29,30,31,30,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G187*((DataSummary!$C$19/100)*Data!L187),1.1*330*Data!G187*Data!L187)","v":0}]
["OUTPOST     ",8,"BUT"," Middletown Outpost Garage (BUTPNE)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,3,null,25,29,29,27.666666666666668,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G188*((DataSummary!$C$19/100)*Data!L188),1.1*330*Data!G188*Data!L188)","v":30129.000000000007}]
["OUTPOST     ",8,"CLE"," Milford Outpost Garage (CLEPNW)","Public Sanitary Sewer",null,8,null,21,21,25,22.333333333333332,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G189*((DataSummary!$C$19/100)*Data!L189),1.1*330*Data!G189*Data!L189)","v":64856.000000000007}]
["OUTPOST     ",8,"CLE"," Old Milford Outpost Garage (CLEPNWO)",0,null,null,null,21,21,25,22.333333333333332,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G190*((DataSummary!$C$19/100)*Data!L190),1.1*330*Data!G190*Data!L190)","v":0}]
["OUTPOST     ",8,"CLE"," Richmond Outpost Garage (CLEPSW)","Public Sanitary Sewer",null,7,null,21,21,25,22.333333333333332,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G191*((DataSummary!$C$19/100)*Data!L191),1.1*330*Data!G191*Data!L191)","v":56749.000000000007}]
["OUTPOST     ",8,"CLI"," Wilmington Outpost Garage (CLIPNO)","Aeration System",null,5,null,29,32,37,32.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G192*((DataSummary!$C$19/100)*Data!L192),1.1*330*Data!G192*Data!L192)","v":59290}]
["OUTPOST     ",8,"HAM"," Blue Ash Outpost Garage (HAMPNE)","Public Sanitary Sewer",null,9,null,23,22,27,24,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G193*((DataSummary!$C$19/100)*Data!L193),1.1*330*Data!G193*Data!L193)","v":78408.000000000015}]
["OUTPOST     ",8,"HAM"," Miamitown Outpost Garage (HAMPWE)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,8,null,23,22,27,24,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G194*((DataSummary!$C$19/100)*Data!L194),1.1*330*Data!G194*Data!L194)","v":69696.000000000015}]
["OUTPOST     ",8,"HAM"," Sharonville Outpost Garage (HAMPNO)",0,null,null,null,23,22,27,24,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G195*((DataSummary!$C$19/100)*Data!L195),1.1*330*Data!G195*Data!L195)","v":0}]
["OUTPOST     ",8,"PRE"," Eaton Outpost Garage (PREPCT)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,null,null,29,33,41,34.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G196*((DataSummary!$C$19/100)*Data!L196),1.1*330*Data!G196*Data!L196)","v":0}]
["OUTPOST     ",8,"PRE"," Morning Sun Outpost Garage (PREPSW)",0,null,null,null,29,33,41,34.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G197*((DataSummary!$C$19/100)*Data!L197),1.1*330*Data!G197*Data!L197)","v":0}]
["OUTPOST     ",8,"WAR"," Monroe Outpost Garage (WARPWE)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,10,null,24,29,30,27.666666666666668,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G198*((DataSummary!$C$19/100)*Data!L198),1.1*330*Data!G198*Data!L198)","v":100430.00000000001}]
["OUTPOST     ",9,"ADA"," Peebles Outpost Garage (ADAPNO)",0,null,3,null,16,18,20,18,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G199*((DataSummary!$C$19/100)*Data!L199),1.1*330*Data!G199*Data!L199)","v":19602.000000000004}]
["OUTPOST     ",9,"BRO"," White Oak Outpost Garage (BROPCT)",0,null,3,null,16,17,22,18.333333333333332,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G200*((DataSummary!$C$19/100)*Data!L200),1.1*330*Data!G200*Data!L200)","v":19965.000000000004}]
["OUTPOST     ",9,"LAW"," Proctorville Outpost Garage (LAWPSE)",0,null,3,null,11,15,15,13.666666666666666,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G201*((DataSummary!$C$19/100)*Data!L201),1.1*330*Data!G201*Data!L201)","v":14883.000000000002}]
["OUTPOST     ",9,"LAW"," Wilgus Outpost Yard (LAWPCT)",0,null,2,null,11,15,15,13.666666666666666,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G202*((DataSummary!$C$19/100)*Data!L202),1.1*330*Data!G202*Data!L202)","v":9922.0000000000018}]
["OUTPOST     ",9,"SCI"," Wheelersburg Outpost Garage (SCIPSE)",0,null,4,null,10,15,14,13,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G203*((DataSummary!$C$19/100)*Data!L203),1.1*330*Data!G203*Data!L203)","v":18876.000000000004}]
["OUTPOST     ",10,"ATH"," Hollister Outpost Garage (ATHPNO)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,2,null,17,25,21,21,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G204*((DataSummary!$C$19/100)*Data!L204),1.1*330*Data!G204*Data!L204)","v":15246.000000000002}]
["OUTPOST     ",10,"HOC"," Laurelville Outpost Garage (HOCPSW)","Public Sanitary Sewer",null,1,null,22,26,19,22.333333333333332,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G205*((DataSummary!$C$19/100)*Data!L205),1.1*330*Data!G205*Data!L205)","v":8107.0000000000009}]
["OUTPOST     ",10,"MEG"," Tuppers Plains Outpost (MEGPNE)","Public Sanitary Sewer",null,3,null,11,20,17,16,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G206*((DataSummary!$C$19/100)*Data!L206),1.1*330*Data!G206*Data!L206)","v":17424.000000000004}]
["OUTPOST     ",10,"MOE"," Duffy Outpost Garage (MOEPSE)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,2,null,25,27,27,26.333333333333332,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G207*((DataSummary!$C$19/100)*Data!L207),1.1*330*Data!G207*Data!L207)","v":19118.000000000004}]
["OUTPOST     ",10,"NOB"," Belle Valley Outpost Garage (NOBPWE)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,4,null,21,29,24,24.666666666666668,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G208*((DataSummary!$C$19/100)*Data!L208),1.1*330*Data!G208*Data!L208)","v":35816.000000000007}]
["OUTPOST     ",10,"VIN"," Wilkesville Outpost Garage (VINPSE)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,2,null,16,25,22,21,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G209*((DataSummary!$C$19/100)*Data!L209),1.1*330*Data!G209*Data!L209)","v":15246.000000000002}]
["OUTPOST     ",10,"WAS"," Bartlett Outpost Garage (WASPWE)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,3,null,23,26,24,24.333333333333332,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G210*((DataSummary!$C$19/100)*Data!L210),1.1*330*Data!G210*Data!L210)","v":26499.000000000004}]
["OUTPOST     ",10,"WAS"," Belpre Outpost Garage (WASPSW)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,5,null,23,26,24,24.333333333333332,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G211*((DataSummary!$C$19/100)*Data!L211),1.1*330*Data!G211*Data!L211)","v":44165}]
["OUTPOST     ",10,"WAS"," Macksburg Outpost Garage (WASPNO)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,3,null,23,26,24,24.333333333333332,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G212*((DataSummary!$C$19/100)*Data!L212),1.1*330*Data!G212*Data!L212)","v":26499.000000000004}]
["OUTPOST     ",11,"BEL"," Barnesville Outpost Garage (BELPSW)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,4,null,34,39,35,36,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G213*((DataSummary!$C$19/100)*Data!L213),1.1*330*Data!G213*Data!L213)","v":52272.000000000007}]
["OUTPOST     ",11,"BEL"," Saint Clairsville Outpost Garage (BELPCT)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,7,null,34,39,35,36,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G214*((DataSummary!$C$19/100)*Data!L214),1.1*330*Data!G214*Data!L214)","v":91476.000000000015}]
["OUTPOST     ",11,"BEL"," Shadyside Outpost Yard (BELPSE)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,null,null,34,39,35,36,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G215*((DataSummary!$C$19/100)*Data!L215),1.1*330*Data!G215*Data!L215)","v":0}]
["OUTPOST     ",11,"CAR"," Malvern Outpost Yard (CARPNW)",0,null,null,null,30,34,36,33.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G216*((DataSummary!$C$19/100)*Data!L216),1.1*330*Data!G216*Data!L216)","v":0}]
["OUTPOST     ",11,"COL"," Apples Corner Outpost Garage (COLPSE)","Holding Tank",null,4,null,37,38,47,40.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G217*((DataSummary!$C$19/100)*Data!L217),1.1*330*Data!G217*Data!L217)","v":59048.000000000007}]
["OUTPOST     ",11,"COL"," Unity Outpost Garage (COLPEA)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,4,null,37,38,47,40.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G218*((DataSummary!$C$19/100)*Data!L218),1.1*330*Data!G218*Data!L218)","v":59048.000000000007}]
["OUTPOST     ",11,"HAS"," Freeport Outpost Yard (HASPSW)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,3,null,34,37,40,37,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G219*((DataSummary!$C$19/100)*Data!L219),1.1*330*Data!G219*Data!L219)","v":40293.000000000007}]
["OUTPOST     ",11,"HAS"," Scio Outpost Garage (HASPNO)","Public Sanitary Sewer",null,3,null,34,37,40,37,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G220*((DataSummary!$C$19/100)*Data!L220),1.1*330*Data!G220*Data!L220)","v":40293.000000000007}]
["OUTPOST     ",11,"HOL"," Nashville Outpost Garage (HOLPWE)","Holding Tank",null,3,null,27,31,33,30.333333333333332,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G221*((DataSummary!$C$19/100)*Data!L221),1.1*330*Data!G221*Data!L221)","v":33033.000000000007}]
["OUTPOST     ",11,"JEF"," Bergholz Outpost Yard (JEFPNW)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,1,null,36,40,39,38.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G222*((DataSummary!$C$19/100)*Data!L222),1.1*330*Data!G222*Data!L222)","v":13915.000000000004}]
["OUTPOST     ",11,"JEF"," Dillonvale Outpost Garage (JEFPSO)","Public Sanitary Sewer",null,null,null,36,40,39,38.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G223*((DataSummary!$C$19/100)*Data!L223),1.1*330*Data!G223*Data!L223)","v":0}]
["OUTPOST     ",11,"JEF"," Toronto Outpost Garage (JEFPCT)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,3,null,36,40,39,38.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G224*((DataSummary!$C$19/100)*Data!L224),1.1*330*Data!G224*Data!L224)","v":41745.000000000015}]
["OUTPOST     ",11,"TUS"," Dennison Outpost Garage (TUSPSE)","Public Sanitary Sewer",null,2,null,31,38,34,34.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G225*((DataSummary!$C$19/100)*Data!L225),1.1*330*Data!G225*Data!L225)","v":24926.000000000007}]
["OUTPOST     ",11,"TUS"," Newcomerstown Outpost Garage (TUSPSW)","Public Sanitary Sewer",null,4,null,31,38,34,34.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G226*((DataSummary!$C$19/100)*Data!L226),1.1*330*Data!G226*Data!L226)","v":49852.000000000015}]
["OUTPOST     ",11,"TUS"," Zoar Outpost Garage (TUSPNO)","Class 5 Well (Septic Tank and Mound System or Leach Field)",null,2,null,31,38,34,34.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G227*((DataSummary!$C$19/100)*Data!L227),1.1*330*Data!G227*Data!L227)","v":24926.000000000007}]
["OUTPOST     ",12,"CUY"," Cleveland I90 Garage (CUYPCE)","Runoff / Storm Sewer",null,12,null,65,54,77,65.333333333333329,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G228*((DataSummary!$C$19/100)*Data!L228),1.1*330*Data!G228*Data!L228)","v":284592.00000000006}]
["OUTPOST     ",12,"CUY"," Independence Garage (CUYPCT)","Public Sanitary Sewer",null,13,null,65,54,77,65.333333333333329,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G229*((DataSummary!$C$19/100)*Data!L229),1.1*330*Data!G229*Data!L229)","v":308308.00000000006}]
["OUTPOST     ",12,"CUY"," Mayfield Garage #1 (CUYPNE)","Public Sanitary Sewer",null,12,null,65,54,77,65.333333333333329,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G230*((DataSummary!$C$19/100)*Data!L230),1.1*330*Data!G230*Data!L230)","v":284592.00000000006}]
["OUTPOST     ",12,"CUY"," Riveredge County Garage (CUYCG)","Runoff / Storm Sewer",null,12,null,65,54,77,65.333333333333329,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G231*((DataSummary!$C$19/100)*Data!L231),1.1*330*Data!G231*Data!L231)","v":284592.00000000006}]
["OUTPOST     ",12,"CUY"," Warrensville Heights Garage (CUYPEA)","Runoff / Storm Sewer",null,13,null,65,54,77,65.333333333333329,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G232*((DataSummary!$C$19/100)*Data!L232),1.1*330*Data!G232*Data!L232)","v":308308.00000000006}]
["OUTPOST     ",12,"GEA"," Montville Outpost Garage (GEAPNE)","Holding Tank",null,3,null,54,51,79,61.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G233*((DataSummary!$C$19/100)*Data!L233),1.1*330*Data!G233*Data!L233)","v":66792.000000000015}]
["OUTPOST     ",12,"GEA"," Munson Outpost Garage (GEAPNO)","Runoff / Storm Sewer",null,3,null,54,51,79,61.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G234*((DataSummary!$C$19/100)*Data!L234),1.1*330*Data!G234*Data!L234)","v":66792.000000000015}]
["OUTPOST     ",12,"GEA"," Parkman Outpost Garage (GEAPSE)","Runoff / Storm Sewer",null,5,null,54,51,79,61.333333333333336,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G235*((DataSummary!$C$19/100)*Data!L235),1.1*330*Data!G235*Data!L235)","v":111320.00000000001}]
["OUTPOST     ",12,"LAK"," Unionville Outpost Garage (LAKPNE)","Runoff / Storm Sewer",null,null,null,59,53,70,60.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G236*((DataSummary!$C$19/100)*Data!L236),1.1*330*Data!G236*Data!L236)","v":0}]
["OUTPOST     ",12,"LAK"," Vrooman Road Outpost Garage (LAKPSE)","Runoff / Storm Sewer",null,null,null,59,53,70,60.666666666666664,{"$f":"IF(AND(DataSummary!$C$19<>0,DataSummary!$C$19<>\"\",(ISNUMBER(DataSummary!$C$19)),DataSummary!$C$15<>\"\",DataSummary!$C$15<>0,(ISNUMBER(DataSummary!$C$15))),1.1*DataSummary!$C$15*Data!G237*((DataSummary!$C$19/100)*Data!L237),1.1*330*Data!G237*Data!L237)","v":0}]

{"sheet":"Brine and WW","index":1,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
["District",4]
[]
["Row Labels","Five Year Average Volume of Salt Brine Made","Estimated Wash Water Volume"]
[" Alliance Outpost Yard (STAPNE)",null,0]
[" Ashtabula County Garage (ATBCG)",296016.59999999998,207999.00000000003]
[" Bailey Road Outpost Garage (MAHPNW)",null,68728.000000000015]
[" Brookfield Outpost Garage (TRUPSE)",null,123662.00000000001]
[" Canal Fulton Outpost Yard (STAPNW)",null,0]
[" Conneaut Outpost Garage (ATBPNE)",null,115555.00000000001]
[" District Four Headquarters (SUMHQ)",null,0]
[" Dorset Outpost Garage (ATBPCT)",null,92444.000000000015]
[" Drakesburg Outpost Garage (PORPNE)",null,86515]
[" Greensburg Airport Outpost Garage (SUMPSE)",null,75504.000000000015]
[" Gustavus Outpost Garage (TRUPNO)",null,105996.00000000001]
[" Harperfield Outpost Garage (ATBPNW)",null,69333.000000000015]
[" Interchange / Norton Outpost Garage (SUMPWE)",null,132132.00000000003]
[" Kelly Avenue Outpost Garage (SUMPEA)",null,0]
[" Mahoning County (Canfield) County Garage (MAHCG)",212376.19,154638.00000000003]
[" Millersburg Rd. Outpost Yard (STAPWE)",null,0]
[" N. Lima Outpost (MAHPSE)",null,137456.00000000003]
[" Portage County / Rootstown County Garage (PORCG)",254911.9,190333]
[" Rome Outpost Garage (ATBPSW)",null,92444.000000000015]
[" Sebring Outpost Garage (MAHPWE)",null,34364.000000000007]
[" South Avenue Outpost Yard (MAHPNE)",null,0]
[" Stark County Garage (STACG)",456846.8,275638]
[" Summit (Boston Heights) County Garage (SUMCG)",427736.3,188760.00000000003]
[" Trumbull (Cortland) County Garage (TRUCG)",144389.20000000001,141328.00000000003]
[" Trumbull Construction Office (TRUCON)",null,0]
[" Twinsburg Outpost Garage (SUMPNE)",null,94380.000000000015]
[" Warren Outpost Yard (TRUPSW)",null,88330]
[" West Farmington Outpost Garage (TRUPEA)",null,70664.000000000015]
[" Williamsfield Outpost Garage (ATBPSE)",null,92444.000000000015]
[" Yale Outpost Garage (PORPSE)",null,69212.000000000015]
["Grand Total",1792276.99,2707859.0000000005]

{"sheet":"LaneMiles","index":2,"n_rows":34,"n_cols":2,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
["District",4]
[]
["Row Labels","Sum of Lane Miles"]
[" Alliance Outpost Yard (STAPNE)"]
[" Ashtabula County Garage (ATBCG)",840.07999999999993]
[" Bailey Road Outpost Garage (MAHPNW)"]
[" Brookfield Outpost Garage (TRUPSE)"]
[" Canal Fulton Outpost Yard (STAPNW)"]
[" Conneaut Outpost Garage (ATBPNE)"]
[" District Four Headquarters (SUMHQ)"]
[" Dorset Outpost Garage (ATBPCT)"]
[" Drakesburg Outpost Garage (PORPNE)"]
[" Greensburg Airport Outpost Garage (SUMPSE)"]
[" Gustavus Outpost Garage (TRUPNO)"]
[" Harperfield Outpost Garage (ATBPNW)"]
[" Interchange / Norton Outpost Garage (SUMPWE)"]
[" Kelly Avenue Outpost Garage (SUMPEA)"]
[" Mahoning County (Canfield) County Garage (MAHCG)",645.15]
[" Millersburg Rd. Outpost Yard (STAPWE)"]
[" N. Lima Outpost (MAHPSE)"]
[" Portage County / Rootstown County Garage (PORCG)",494.97]
[" Rome Outpost Garage (ATBPSW)"]
[" Sebring Outpost Garage (MAHPWE)"]
[" South Avenue Outpost Yard (MAHPNE)"]
[" Stark County Garage (STACG)",750.04000000000008]
[" Summit (Boston Heights) County Garage (SUMCG)",579.84]
[" Trumbull (Cortland) County Garage (TRUCG)",843.58]
[" Trumbull Construction Office (TRUCON)"]
[" Twinsburg Outpost Garage (SUMPNE)"]
[" Warren Outpost Yard (TRUPSW)"]
[" West Farmington Outpost Garage (TRUPEA)"]
[" Williamsfield Outpost Garage (ATBPSE)"]
[" Yale Outpost Garage (PORPSE)"]
["Grand Total",4153.6600000000008]

{"sheet":"Trucks","index":3,"n_rows":34,"n_cols":2,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
["District",4]
[]
["Row Labels","Sum of Number of Trucks"]
[" Alliance Outpost Yard (STAPNE)"]
[" Ashtabula County Garage (ATBCG)",9]
[" Bailey Road Outpost Garage (MAHPNW)",4]
[" Brookfield Outpost Garage (TRUPSE)",7]
[" Canal Fulton Outpost Yard (STAPNW)"]
[" Conneaut Outpost Garage (ATBPNE)",5]
[" District Four Headquarters (SUMHQ)"]
[" Dorset Outpost Garage (ATBPCT)",4]
[" Drakesburg Outpost Garage (PORPNE)",5]
[" Greensburg Airport Outpost Garage (SUMPSE)",4]
[" Gustavus Outpost Garage (TRUPNO)",6]
[" Harperfield Outpost Garage (ATBPNW)",3]
[" Interchange / Norton Outpost Garage (SUMPWE)",7]
[" Kelly Avenue Outpost Garage (SUMPEA)"]
[" Mahoning County (Canfield) County Garage (MAHCG)",9]
[" Millersburg Rd. Outpost Yard (STAPWE)"]
[" N. Lima Outpost (MAHPSE)",8]
[" Portage County / Rootstown County Garage (PORCG)",11]
[" Rome Outpost Garage (ATBPSW)",4]
[" Sebring Outpost Garage (MAHPWE)",2]
[" South Avenue Outpost Yard (MAHPNE)"]
[" Stark County Garage (STACG)",17]
[" Summit (Boston Heights) County Garage (SUMCG)",10]
[" Trumbull (Cortland) County Garage (TRUCG)",8]
[" Trumbull Construction Office (TRUCON)"]
[" Twinsburg Outpost Garage (SUMPNE)",5]
[" Warren Outpost Yard (TRUPSW)",5]
[" West Farmington Outpost Garage (TRUPEA)",4]
[" Williamsfield Outpost Garage (ATBPSE)",4]
[" Yale Outpost Garage (PORPSE)",4]
["Grand Total",145]

{"sheet":"Events","index":4,"n_rows":34,"n_cols":2,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
["District",4]
[]
["Row Labels","Sum of Three Year Avg Events"]
[" Alliance Outpost Yard (STAPNE)",44.666666666666664]
[" Ashtabula County Garage (ATBCG)",63.666666666666664]
[" Bailey Road Outpost Garage (MAHPNW)",47.333333333333336]
[" Brookfield Outpost Garage (TRUPSE)",48.666666666666664]
[" Canal Fulton Outpost Yard (STAPNW)",44.666666666666664]
[" Conneaut Outpost Garage (ATBPNE)",63.666666666666664]
[" District Four Headquarters (SUMHQ)",52]
[" Dorset Outpost Garage (ATBPCT)",63.666666666666664]
[" Drakesburg Outpost Garage (PORPNE)",47.666666666666664]
[" Greensburg Airport Outpost Garage (SUMPSE)",52]
[" Gustavus Outpost Garage (TRUPNO)",48.666666666666664]
[" Harperfield Outpost Garage (ATBPNW)",63.666666666666664]
[" Interchange / Norton Outpost Garage (SUMPWE)",52]
[" Kelly Avenue Outpost Garage (SUMPEA)",52]
[" Mahoning County (Canfield) County Garage (MAHCG)",47.333333333333336]
[" Millersburg Rd. Outpost Yard (STAPWE)",44.666666666666664]
[" N. Lima Outpost (MAHPSE)",47.333333333333336]
[" Portage County / Rootstown County Garage (PORCG)",47.666666666666664]
[" Rome Outpost Garage (ATBPSW)",63.666666666666664]
[" Sebring Outpost Garage (MAHPWE)",47.333333333333336]
[" South Avenue Outpost Yard (MAHPNE)",47.333333333333336]
[" Stark County Garage (STACG)",44.666666666666664]
[" Summit (Boston Heights) County Garage (SUMCG)",52]
[" Trumbull (Cortland) County Garage (TRUCG)",48.666666666666664]
[" Trumbull Construction Office (TRUCON)",48.666666666666664]
[" Twinsburg Outpost Garage (SUMPNE)",52]
[" Warren Outpost Yard (TRUPSW)",48.666666666666664]
[" West Farmington Outpost Garage (TRUPEA)",48.666666666666664]
[" Williamsfield Outpost Garage (ATBPSE)",63.666666666666664]
[" Yale Outpost Garage (PORPSE)",47.666666666666664]
["Grand Total",1544.3333333333337]

{"sheet":"Cost","index":5,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,7,1,10],[13,1,13,3],[1,1,1,3],[27,1,27,3],[16,1,16,3],[3,1,3,3],[8,1,8,3],[6,7,6,10],[3,7,3,10]]}
[]
[null,"User Input ",null,null,null,"Cost Summary",null,"Output "]
[]
[null,"Volume",null,null,null,null,null,"Volume"]
[null,"Volume/Truck/Event",330,"gallons",null,null,null,"Est. Annual WW Volume",{"$f":"IF(AND(ISNUMBER(C5),ISNUMBER(C6),ISNUMBER(C7)),C5*C6*C7*1.1, \"\")","v":130680.00000000001}]
[null,"Annual Number of Events",30,"events"]
[null,"Number of Trucks",12,"trucks",null,null,null,"Management Option Costs and Savings"]
[null,null,null,null,null,null,null,null,"Annual Cost","Annual Savings","Project Savings"]
[null,"Planning",null,null,null,null,null,"Sewer Tie In ",{"$f":"IF(AND(C15<>\"\", C15<>0,C10<>\"\",C10<>0,C11<>\"\",C11<>0,C10<1,I5<>\"\",I5<>0),(C15*(C10/(((1+C10)^C11)-1)+C10))+(I5*0.01),0)","v":23809.541662083098}]
[null,"Interest Rate ",7.0000000000000007E-2,null,null,null,null,"Commercial Disposal",{"$f":"IF(AND(C12<>\"\",C10<>\"\",C10<1,C20<>\"\",I5<>\"\",I5<>0),(C18*(C10/(((1+C10)^C12)-1)+C10))+((I5*C20)+C23), 0)","v":44366.059659650615},{"$f":"$I$9-I10","v":-20556.517997567516},{"$f":"J10*$C$12","v":-246678.21597081021}]
[null,"Planning Period Sewer",40,"years",null,null,null,"Disposal at WWTP",{"$f":"IF(AND(C10<>\"\",C10<1, C12<>\"\",C19<>\"\",C21<>\"\",C24<>\"\",I5<>\"\",I5<>0,C21<>0),(C18*(C10/(((1+C10)^C12)-1)+C10))+((I5*C19)+(C23)+((I5/C24)*((((C21/45)+1)*C25)+(C26*C21)))),\"\")","v":19547.023659650615},{"$f":"$I$9-I11","v":4262.5180024324836},{"$f":"J11*$C$12","v":51150.216029189804}]
[null,"Planning Period (Holding Tank/Filtration)",12,"years",null,null,null,"Disposal at County Garage",{"$f":"IF(AND(C10<>\"\",C10<1,C12<>\"\",C22<>\"\",C24<>\"\",I5<>\"\",I5<>0,C22<>0),(C18*(C10/(((1+C10)^C12)-1)+C10))+((I5*0.01)+(C23)+((I5/C24)*((((C22/45)+1)*C25)+(C26*C22)))),\"\")","v":14319.823659650616},{"$f":"$I$9-I12","v":9489.7180024324825},113876.61602918978]
[null,null,null,null,null,null,null,"Filtration and Disposal",{"$f":"IF(AND(C10<>\"\",C10<1,C12<>\"\",C22<>\"\",C24<>\"\",I5<>\"\",I5<>0,C22<>0),((C18+C29)*(C10/(((1+C10)^C12)-1)+C10))+((I5*0.01)+C23+C30+(((I5/C24)*((((C22/45)+1)*C25)+(C26*C22))))),IF(C22=0, ((C18+C29)*(C10/(((1+C10)^C12)-1)+C10))+((I5*0.01)+C23+C30),\"\"))","v":22696.883319301229},{"$f":"$I$9-I13","v":1112.6583427818696},13351.900113382435]
[null,"Sanitary Sewer Costs",null,null,null,null,null,"Filtration and Reuse",{"$f":"IF(AND(C10<>\"\",C10<1,C12<>\"\",C22<>\"\",C24<>\"\",I5<>\"\",I5<>0, C22<>0),((C18+C29)*(C10/(((1+C10)^C12)-1)+C10))+(C23+C30+(((I5/C24)*((((C22/45)+1)*C25)+(C26*C22))))),IF(C22=0,(((C18+C29)*(C10/(((1+C10)^C12)-1)+C10))+(C23+C30)),\"\"))","v":21390.083319301229},{"$f":"$I$9-I14","v":2419.4583427818689},29033.500113382426]
[null,"Capital Cost of Sewer Tie In",300000,"dollars"]
[]
[null,"Other",null,null,null,null,null,"Notes:"]
[null,"Capital cost of holding tank system",30000,"dollars",null,null,null,"Volume/truck/event is estimated volume of wash water generated"]
[null,"Disposal Rate WWTP",0.05,"$/gallon",null,null,null,"Planning period refers to the expected life of the option (sewer/non-sewer)"]
[null,"Commercial disposal rate",0.3,"$/gallon",null,null,null,"Loaded labor rate=hourly rate * 1.5 to account for benefits"]
[null,"Rountrip Distance to WWTP",55,"miles",null,null,null,"Vehicle operation = fuel cost/7mpg + .53 in other operating costs"]
[null,"Roundtrip Distance to nearest county garage",55,"miles",null,null,null,"Project savings is the savings over the planning period of the non-sewer options"]
[null,"Annual Monitoring Costs",1385,"dollars"]
[null,"Tanker Truck Volume",2000,"gallons"]
[null,"Loaded Labor Rate ",26.35,"$/hour"]
[null,"Unit Cost to Operate Vehicle",1.1200000000000001,"$/mile"]
[]
[null,"Filtration"]
[null,"Capital cost of filtration unit",30000,"dollars"]
[null,"Annual media replacement cost",4600,"$/year"]

{"sheet":"DataSummary","index":6,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Vol/Truck/Event",330,"gallons"]
[]
[]
[]
[null,"Percent of Events",100,"% events"]

{"sheet":"DistrictSummaryData","index":7,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Location","Trucks","Avg No. Events"]
[" Alliance Outpost Yard (STAPNE)",null,44.666666666666664]
[" Ashtabula County Garage (ATBCG)",9,63.666666666666664]
[" Bailey Road Outpost Garage (MAHPNW)",4,47.333333333333336]
[" Brookfield Outpost Garage (TRUPSE)",7,48.666666666666664]
[" Canal Fulton Outpost Yard (STAPNW)",null,44.666666666666664]
[" Conneaut Outpost Garage (ATBPNE)",5,63.666666666666664]
[" District Four Headquarters (SUMHQ)",null,52]
[" Dorset Outpost Garage (ATBPCT)",4,63.666666666666664]
[" Drakesburg Outpost Garage (PORPNE)",5,47.666666666666664]
[" Greensburg Airport Outpost Garage (SUMPSE)",4,52]
[" Gustavus Outpost Garage (TRUPNO)",6,48.666666666666664]
[" Harperfield Outpost Garage (ATBPNW)",3,63.666666666666664]
[" Interchange / Norton Outpost Garage (SUMPWE)",7,52]
[" Kelly Avenue Outpost Garage (SUMPEA)",null,52]
[" Mahoning County (Canfield) County Garage (MAHCG)",9,47.333333333333336]
[" Millersburg Rd. Outpost Yard (STAPWE)",null,44.666666666666664]
[" N. Lima Outpost (MAHPSE)",8,47.333333333333336]
[" Portage County / Rootstown County Garage (PORCG)",11,47.666666666666664]
[" Rome Outpost Garage (ATBPSW)",4,63.666666666666664]
[" Sebring Outpost Garage (MAHPWE)",2,47.333333333333336]
[" South Avenue Outpost Yard (MAHPNE)",null,47.333333333333336]
[" Stark County Garage (STACG)",17,44.666666666666664]
[" Summit (Boston Heights) County Garage (SUMCG)",10,52]
[" Trumbull (Cortland) County Garage (TRUCG)",8,48.666666666666664]
[" Trumbull Construction Office (TRUCON)",null,48.666666666666664]
[" Twinsburg Outpost Garage (SUMPNE)",5,52]
[" Warren Outpost Yard (TRUPSW)",5,48.666666666666664]
[" West Farmington Outpost Garage (TRUPEA)",4,48.666666666666664]
[" Williamsfield Outpost Garage (ATBPSE)",4,63.666666666666664]
[" Yale Outpost Garage (PORPSE)",4,47.666666666666664]