{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["SAN_MAIN","Field Descriptions"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"SAN_MAIN","index":0,"n_rows":57,"n_cols":38,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["CEG_UNITID1","CEG_UNITID2","ASBUILT","DSGN_ID1","MAINCOMP1","COMPTYPE1","DSGN_ID2","MAINCOMP2","COMPTYPE2","PARLINEO","LOC","LOC_CODE","MAIN_TYPE","MAIN_TYPE_CODE","MAIN_COMP_DESCRIPTION","MAIN_COMP_CODE","PIPE_SHAPE","PSHAPE_CODE","PIPE_DIAM","PIPEHT","PIPETYPE","PIPE_CODE","UP_MH_TOR","UP_ELEV","UP_DPTH","DWN_MH_TOR","DWN_ELEV","DWN_DPTH","PIPELEN","SLOPE","TRACEWIRE","DATE_INSTALLED","PCPIRNO","SPECINST","OWNER","OWNER_CODE","SERVSTAT","SRVC_STAT"]
[null,null,null,null,null,{"$f":"LOOKUP($E2,$E$28:$F$57)","v":{"$error":"#N/A"}},null,null,{"$f":"LOOKUP($H2,$H$28:$I$57)","v":{"$error":"#N/A"}},null,null,{"$f":"LOOKUP($K2,$K$28:$L$35)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP($M2,$M$28:$N$37)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP($O2,$O$28:$P$40)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP($Q2,$Q$28:$R$30)","v":{"$error":"#N/A"}},null,null,null,{"$f":"LOOKUP($U2,$U$28:$V$41)","v":{"$error":"#N/A"}},null,null,{"$f":"(W2-X2)","v":0},null,null,{"$f":"(Z2-AA2)","v":0},null,{"$f":"($X2-$AA2)/$AC2","v":{"$error":"#DIV/0!"}},null,null,null,null,null,{"$f":"LOOKUP($AI2,$AI$28:$AJ$29)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP($AK2,$AK$28:$AL$29)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},null,null,{"$f":"(W3-X3)","v":0},null,null,{"$f":"(Z3-AA3)","v":0},null,{"$f":"($X3-$AA3)/$AC3","v":{"$error":"#DIV/0!"}},null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},null,null,0,null,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},null,null,0,null,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},null,null,0,null,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},null,null,0,null,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},null,null,0,null,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},null,null,0,null,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},null,null,0,null,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},null,null,0,null,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},null,null,0,null,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},null,null,0,null,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},null,null,0,null,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},null,null,0,null,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},null,null,0,null,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},null,null,0,null,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},null,null,{"$f":"(W18-X18)","v":0},null,null,{"$f":"(Z18-AA18)","v":0},null,{"$error":"#DIV/0!"},null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},null,null,0,null,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},null,null,0,null,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},null,null,0,null,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},null,null,{"$f":"(W22-X22)","v":0},null,null,{"$f":"(Z22-AA22)","v":0},null,{"$error":"#DIV/0!"},null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},null,null,0,null,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},null,null,0,null,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},null,null,0,null,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[]
[]
[null,null,null,null,"Abandoned Air Relief Valve",35,null,"Abandoned Air Relief Valve",35,"A","Alley","K","Combined Collection Line","CCL","Abandoned Force Main",21,"Circular","CIRC",null,null,"Cast Iron","CIP",null,null,null,null,null,null,null,null,"Yes",null,null,null,"Citizens Energy","CEG","In Service","I"]
[null,null,null,null,"Abandoned Manhole",22,null,"Abandoned Manhole",22,"B","Easement, Good Access","G","Force Main","F","Abandoned Main",21,"Egg Shape","EGG",null,null,"CIPP Over ABS","INA",null,null,null,null,null,null,null,null,"No",null,null,null,"Private","PRIV","Out of Service","O"]
[null,null,null,null,"Air Release Valve",35,null,"Air Release Valve",35,"C","Easement,Adj To Street Row","D","Interceptor","INT","Belmont Plant Drain",21,"Oval","OVAL",null,null,"CIPP Over Brick","INB"]
[null,null,null,null,"Air Release Valve Plugged",35,null,"Air Release Valve Plugged",35,"D","Greenways and Trails","GRWY","Low Pressure System","LP","Collection Line",21,null,null,null,null,"CIPP Over Concrete","INC"]
[null,null,null,null,"Blind Tie",24,null,"Blind Tie",24,"E","Parking Lot, Good Access","J","Overflow","O","Combined Collection Line",21,null,null,null,null,"CIPP Over RCP","INR"]
[null,null,null,null,"Capped Stub Out",24,null,"Capped Stub Out",24,"F","Parking Lot, Poor Access","I","Parallel Pipes","P","Combined Siphon",21,null,null,null,null,"CIPP Over Truss Pipe","INT"]
[null,null,null,null,"Combined Manhole",22,null,"Combined Manhole",22,"G","Street Row, Heavy Traffic","B","Sanitary Collection System","E","Force Main",21,null,null,null,null,"CIPP Over VCP","INV"]
[null,null,null,null,"Combined Outfall (CSO)",24,null,"Combined Outfall (CSO)",24,"H","Street Row, Light Traffic","C","Siphon","S","Interceptor",21,null,null,null,null,"Fiberglass Reinforced","FRP"]
[null,null,null,null,"Dead End/Plugged Line",25,null,"Dead End/Plugged Line",25,null,null,null,"Stream Crossing","X","Low Pressure Main",21,null,null,null,null,"High Density Polyethylene","HDPE"]
[null,null,null,null,"Divergence Structure",22,null,"Divergence Structure",22,null,null,null,"Suction Line","SUC","Overflow Line",21,null,null,null,null,"Polyethylene","PEP"]
[null,null,null,null,"Gate Valve",35,null,"Gate Valve",35,null,null,null,null,null,"Siphon",21,null,null,null,null,"Polyvinylchloride","PVC"]
[null,null,null,null,"Inflatable Dam Access Manhole",22,null,"Inflatable Dam Access Manhole",22,null,null,null,null,null,"Sludge Transfer Line",21,null,null,null,null,"Reinforce Concrete","RCP"]
[null,null,null,null,"Inflatable Dam Equipment Vault",69,null,"Inflatable Dam Equipment Vault",69,null,null,null,null,null,"Suction Line",21,null,null,null,null,"Truss","TRS"]
[null,null,null,null,"Inflatable Dam Point",24,null,"Inflatable Dam Point",24,null,null,null,null,null,null,null,null,null,null,null,"Vitrified Clay","VCP"]
[null,null,null,null,"Isolation Valve",35,null,"Isolation Valve",35]
[null,null,null,null,"Lamp Hole",24,null,"Lamp Hole",24]
[null,null,null,null,"Lift Station",15,null,"Lift Station",15]
[null,null,null,null,"Manhole",22,null,"Manhole",22]
[null,null,null,null,"Metering Structure",69,null,"Metering Structure",69]
[null,null,null,null,"Netting Structure",22,null,"Netting Structure",22]
[null,null,null,null,"Node",24,null,"Node",24]
[null,null,null,null,"Odor Control Structure",69,null,"Odor Control Structure",69]
[null,null,null,null,"Pinch Valve Access Manhole",22,null,"Pinch Valve Access Manhole",22]
[null,null,null,null,"Pinch Valve Equipment Vault",69,null,"Pinch Valve Equipment Vault",69]
[null,null,null,null,"Real Time Control",69,null,"Real Time Control",69]
[null,null,null,null,"Regulator Manhole",22,null,"Regulator Manhole",22]
[null,null,null,null,"Sludge Access Structure",22,null,"Sludge Access Structure",22]
[null,null,null,null,"Term Flush Valve",35,null,"Term Flush Valve",35]
[null,null,null,null,"Treatment Plant Structure",98,null,"Treatment Plant Structure",98]
[null,null,null,null,"Weir",24,null,"Weir",24]

{"sheet":"Field Descriptions","index":1,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["FIELD","TYPE","LENGTH","PRECISION","SCALE","REQUIRED","DESCRIPTION"]
[]
["CEG_UNITID1","SHORT",6,null,null,"NO","CEG Manhole Identification of Upstream Manhole - Reserved for CEG"]
["CEG_UNITID2","SHORT",6,null,null,"NO","CEG Manhole Identification of Downstream Manhole - Reserved for CEG"]
["ASBUILT","TEXT",10,null,null,"NO","As-built number - Reserved for CEG"]
["DSGN_ID1","TEXT",25,null,null,"YES","Design Plan Upstream Manhole"]
["MAINCOMP1","TEXT",50,null,null,"YES","Type of structure at upstream end of main from pick list"]
["COMPTYPE1","SHORT",2,null,null,"AUTO","Code required for Asset Management Software - will auto populate"]
["DSGN_ID2","TEXT",25,null,null,"YES","Design Plan Downstream Manhole"]
["MAINCOMP2","TEXT",50,null,null,"YES","Type of structure at downstream end of main from pick list"]
["COMPTYPE2","SHORT",2,null,null,"AUTO","Code required for Asset Management Software - will auto populate"]
["PARLINENO","TEXT",1,null,null,"YES","Used to distinguish between parallel pipes with the same upstream and downstream structures - define by labeling left to right along downstream flow direction"]
["LOC","TEXT",75,null,null,"YES","Surface location and access description"]
["LOC_CODE","TEXT",5,null,null,"AUTO","Code required for Asset Management Software - will auto populate"]
["MAIN_TYPE","TEXT",50,null,null,"YES","Sanitary main type"]
["MAIN_TYPE_CODE","TEXT",5,null,null,"AUTO","Code required for Asset Management Software - will auto populate"]
["MAIN_COMP_DESCRIPTION","TEXT",50,null,null,"YES","Sanitary main descriptor"]
["MAIN_COMP_CODE","TEXT",5,null,null,"AUTO","Code required for Asset Management Software - will auto populate"]
["PIPE_SHAPE","TEXT",4,null,null,"YES","Shape of main from pick list"]
["PSHAPE_CODE","TEXT",4,null,null,"AUTO","Code required for Asset Management Software - will auto populate"]
["PIPE_DIA","DOUBLE",null,6,2,"YES","Diameter of circular pipe in inches.  Width of non-circular pipe in inches."]
["PIPEHT","DOUBLE",null,6,2,"YES","Height of non-circular pipe in inches"]
["PIPETYPE","TEXT",6,null,null,"YES","Pipe material descriptor"]
["PIPE_CODE","TEXT",4,null,null,"AUTO","Code required for Asset Management Software - will auto populate"]
["UP_MH_TOR","DOUBLE",null,6,2,"YES","Upstream manhole top of rim - used for calculations in this sheet only"]
["UP_ELEV","DOUBLE",null,6,2,"YES","Upstream invert elevation of pipe in decimal feet"]
["UP_DEPTH","DOUBLE",null,6,2,"AUTO","Depth of the pipe at invert. Measured from top of rim of the upstream structure to the pipe invert in decimal feet (rounded to nearest 1/100th) - auto calculated in this sheet"]
["DWN_MH_TOR","DOUBLE",null,6,2,"YES","Downstream manhole top of rim - used for calculations in this sheet only"]
["DWN_ELEV","DOUBLE",null,6,2,"YES","Downstream invert elevation in of pipe decimal feet"]
["DWN_DEPTH","DOUBLE",null,6,2,"AUTO","Depth of the pipe at invert. Measured from top of rim of the downstream structure to the pipe invert in decimal feet (rounded to nearest 1/100th) - will auto populate"]
["PIPELEN","DOUBLE",null,7,2,"YES","Length of pipe in decimal feet"]
["SLOPE","DOUBLE",null,7,5,"YES","Slope of pipe in percent - auto calculated in this sheet"]
["TRACEWIRE","TEXT",5,null,null,"YES","Select from pick list if \"tracewire\" was in installed with pipe"]
["DATE_INSTALLED","DATE",null,null,null,"YES","Date Installed MM/DD/YYYY (Estimate for As-Bid submission)"]
["PCPIRNO","TEXT",15,null,null,null,"Project number of PC/PIR project if applicable"]
["SPECINST","TEXT",254,null,null,null,"Open comments regarding installation"]
["OWNER","TEXT",20,null,null,"YES","Description for owner of asset"]
["OWNER_CODE","TEXT",5,null,null,"YES","Code required for Asset Management Software - will auto populate"]
["SERVSTAT","TEXT",20,null,null,"YES","Select from pick list for \"in service\" or \"out of service\""]
["SRVC_STAT","TEXT",1,null,null,"AUTO","Code required for Asset Management Software - will auto populate"]