{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Main","Junction","Reservoir","Tank","Pipe","Pump","Valve","Vertice","Pattern","Curve","Chart"],"not_rendered":{"charts":2,"images":25,"macros":1,"external_links":0,"defined_names":18,"comments":8,"pivot_tables":0},"unopened":[{"sheet":"Chart","index":10,"reason":"not_a_worksheet"}],"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":"Main","index":0,"n_rows":55,"n_cols":23,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,1,0,11],[15,5,15,10],[1,1,1,3],[2,1,2,3],[6,11,7,11],[6,1,7,1],[6,2,7,2],[6,3,6,10]]}
[null,"Network Survey Manager"]
[null,"Name of the project :",null,null,null,"X Coord (E/W)","Y Coord (N/S)","Elevation","Datum","WGS_1984",null,null,null,"Options",null,null,null,"Names"]
[null,"Empty",null,null,"Max",800000,10000000,5000,"UTM Zone",null,null,null,null,"Main",null,null,null,"PipeStatus","Node","CurvePump","CurveVolume","CurveEfficency","CurveHeadloss"]
[null,null,null,null,"Min",100000,0,0,null,null,null,null,null,"HighlightErrors",true,null,null,"Open","J1"]
[null,null,null,null,"Decimals",1,1,2,null,null,null,null,null,"DistanceToNodes",2,null,null,"Closed","J2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"IDs Length",9,"max9min2",null,"CV","J3"]
[null,"Sheet","Records","Check Base Data columns",null,null,null,null,null,null,null,"Other warnings",null,"Max connections",4,"max9min2",null,null,"J4"]
[null,null,null,"ID","Col 2","Col 3","Col 4","Col 5","Col 6","Col 7","Col 8",null,null,"Reformat",true,null,null,"ValveType","J5"]
[null,"Junction",{"$f":"COUNTA(INDIRECT(\"Junction!J:J\"))-2","v":0},"OK","OK","OK","OK","OK","OK","OK",null,null,null,"AltitudeSource","geonamesAster","geonames/googleapis",null,"PRV","J6"]
[null,"Reservoir",{"$f":"COUNTA(INDIRECT(\"Reservoir!J:J\"))-2","v":0},"OK","OK","OK","OK","OK",null,null,null,null,null,"UserName","demo",null,null,"PSV","J7"]
[null,"Tank",{"$f":"COUNTA(INDIRECT(\"Tank!J:J\"))-2","v":0},"OK","OK","OK","OK","OK","OK","OK","OK",null,null,null,null,null,null,"PBV","R1"]
[null,"Pipe",{"$f":"COUNTA(INDIRECT(\"Pipe!H:H\"))-2","v":0},"OK","OK","OK","OK","OK","OK","OK","OK",null,null,null,null,null,null,"FCV"]
[null,"Pump",{"$f":"COUNTA(INDIRECT(\"Pump!H:H\"))-2","v":0},"OK","OK","OK","OK","OK",null,null,null,null,null,"KML",null,null,null,"TCV"]
[null,"Valve",{"$f":"COUNTA(INDIRECT(\"Valve!H:H\"))-2","v":0},"OK","OK","OK","OK","OK","OK","OK",null,null,null,"Small Pipe",100,null,null,"GPV"]
[null,"Vertice",{"$f":"COUNTA(INDIRECT(\"Vertice!J:J\"))-2","v":0},"OK","OK","OK",null,null,null,null,null,null,null,"Main Pipe",200]
[null,"Pattern",{"$f":"COUNTA(INDIRECT(\"Pattern!A:A\"))-2","v":6},"OK","OK",null,null,null,null,null,null,null,null,"AltitudeMode","clampToGround","clampToGround/relativeToGrond/absolute",null,"CurveType"]
[null,"Curve",{"$f":"COUNTA(INDIRECT(\"Curve!A:A\"))-2","v":2},"OK","OK","OK","OK","OK",null,null,null,null,null,"Extrude",true,null,null,"PUMP"]
[null,"Total",{"$f":"SUM(C9:C15)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VOLUME"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EFFICIENCY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HEADLOSS"]
[]
[]
[null,"NSM 3.8",null,"Apache License, Version 2.0, applies for the VBA code : www.apache.org",null,null,null,null,null,"© Laurent Wismer",null,"Updated : 17.06.2014",null,"Epanet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TimesDuration","24:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Timestep","01:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"BackdropFile"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"BackdropOffsetX",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"BackdropOffsety",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"DemandMultiplier",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Controls"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Rules"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Flow Units","CMH","Headloss","D-W","D-W/H-W/C-M"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"GPX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"links to road/tracks","trk","trk/rte/none"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Chart"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"AutoScale",true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ChLabels","node","node/link/none"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"LabelFont",6,"1 to 9"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"DrawLinks","link","branch/link/not/noupdate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"SizePipe","diameter","diameter/roughness/not"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"DrawNode","circle","junction/not/noupdate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"SizeNode","demand","demand/emitter/not"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ColorNode",false]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"LossCoef","average","min/average/max"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CalRedEn",true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CalInDis",true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CalElbVer",true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CalElbPip",true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CalTCon",true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CalXCon",true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"AddCom",true]

{"sheet":"Junction","index":1,"n_rows":2,"n_cols":26,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,17,0,25],[0,0,0,8],[0,9,0,16]]}
["Surveying data",null,null,null,null,null,null,null,null,"Base data",null,null,null,null,null,null,null,"Additional info"]
["Form Index","Field O","Date","GPS ID","Map ID","GPS pos No","Map Pos No","Locality","District","Junction ID","X-Coord","Y-Coord","Elev","Demand","Pattern","Emitter","Description","Type","Benef","Consumption","Ground Level","Depth","Distrib points","Date Installed","State","Comments"]

{"sheet":"Reservoir","index":2,"n_rows":2,"n_cols":28,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,23,0,27],[0,0,0,8],[0,9,0,14],[0,15,0,22]]}
["Surveying data",null,null,null,null,null,null,null,null,"Base data",null,null,null,null,null,"Additional info",null,null,null,null,null,null,null,"Quality"]
["Form Index","Field O","Date","GPS ID","Map ID","GPS pos No","Map Pos No","Locality","District","Reservoir ID","X-Coord","Y-Coord","Head","Pattern","Description","Type","Yield l/d","Protected","Ground Level","Depth","Date Installed","State","Comments","PH","Turbidity","Colour","Conductivity","CommentsQ"]

{"sheet":"Tank","index":3,"n_rows":2,"n_cols":26,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,20,0,25],[0,0,0,8],[0,9,0,19]]}
["Surveying data",null,null,null,null,null,null,null,null,"Base data",null,null,null,null,null,null,null,null,null,null,"Additional info"]
["Form Index","Field O","Date","GPS ID","Map ID","GPS pos No","Map Pos No","Locality","District","Tank ID","X-Coord","Y-Coord","Elevation","InitLevel","MinLevel","MaxLevel","Diameter","MinVol","VolCurve","Description","Type","Ground Level","Height","Date Installed","State","Comments"]

{"sheet":"Pipe","index":4,"n_rows":2,"n_cols":25,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,16,0,24],[0,0,0,6],[0,7,0,15]]}
["Surveying data",null,null,null,null,null,null,"Base data",null,null,null,null,null,null,null,null,"Additional info"]
["Form Index","Field O","Date","Map ID","Map Pos No","Locality","District","Pipe ID","Node 1","Node 2","Length","Diameter","Roughness","MinorLoss","Status","Description","Material","PN","External Diameter","Thickness","Date Installed","State","Downstr demand","Downstr Distr Pt","Comments"]

{"sheet":"Pump","index":5,"n_rows":2,"n_cols":19,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,13,0,18],[0,0,0,6],[0,7,0,12]]}
["Surveying data",null,null,null,null,null,null,"Base data",null,null,null,null,null,"Additional info"]
["Form Index","Field O","Date","Map ID","Map Pos No","Locality","District","Pump ID","Node 1","Node 2","PumpCurve","Pattern","Description","Type","Power kVA","Model No","Date Installed","State","Comments"]

{"sheet":"Valve","index":6,"n_rows":2,"n_cols":19,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,15,0,18],[0,0,0,6],[0,7,0,14]]}
["Surveying data",null,null,null,null,null,null,"Base data",null,null,null,null,null,null,null,"Additional info"]
["Form Index","Field O","Date","Map ID","Map Pos No","Locality","District","Valve ID","Node 1","Node 2","Diameter","Type","Setting","MinorLoss","Description","Material","Date Installed","State","Comments"]

{"sheet":"Vertice","index":7,"n_rows":2,"n_cols":21,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,9,0,11],[0,0,0,8],[0,12,0,20]]}
["Surveying data",null,null,null,null,null,null,null,null,"Base data",null,null,"Additional info"]
["Form Index","Field O","Date","GPS ID","Map ID","GPS pos No","Map Pos No","Locality","District","Link ID (pipe)","X-Coord","Y-Coord","Elev","Ex ID","Description","Type","GL","Depth","Date Installed","State","Comments"]

{"sheet":"Pattern","index":8,"n_rows":8,"n_cols":27,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,25],[0,26,1,26]]}
["Define the patterns to run your modele ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Comments"]
["Pattern ID","Description","C1","C2","C3","C4","C5","C6","C7","C8","C9","C10","C11","C12","C13","C14","C15","C16","C17","C18","C19","C20","C21","C22","C23","C24"]
["paFlat","Flat",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
["paOnOFF","On/Off",0,0,0,0,0,0,2,2,2,2,2,2,2,2,2,2,2,2,0,0,0,0,0,0]
["paRural","Rural",0.1,0.1,0.1,0.1,0.3,1,1.9,2,2,1.9,1.5,1.1000000000000001,1,0.9,1.1000000000000001,1.8,2,2,1.5,1,0.3,0.1,0.1,0.1]
["paBigCity","Big city",0.56000000000000005,0.52,0.5,0.5,0.54,0.7,0.9,1.1000000000000001,1.3,1.4,1.38,1.3,1,1.06,1.1000000000000001,1.1599999999999999,1.1000000000000001,1.08,1.3,1.4,1.34,1.2,0.9,0.66]
["paSwiss","Swiss",0.5,0.45,0.4,0.4,0.5,0.7,0.8,1.1000000000000001,1.4,1.5,1.5,1.4,1,1.05,1.1000000000000001,1.1499999999999999,1.1000000000000001,1.05,1.3,1.5,1.6,1.2,0.7,0.6]
["paPump",null,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0]

{"sheet":"Curve","index":9,"n_rows":4,"n_cols":16,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,14],[0,15,1,15]]}
["Curve",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Comments"]
["Curve ID","Description","Type","X1","Y1","X2","Y2","X3","Y3","X4","Y4","X5","Y5","X6","Y6"]
["Us-KM","Description","PUMP",225,40,82,131,123,125,164,117,205,104,246,84,"Surpression Kahembe-Mapendo"]
["LK-G1",null,"PUMP",1065,79,82,131,123,125,164,117,205,104,246,84,"Ref Ndosho"]