{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["SAN_MH","Field Descriptions"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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_MH","index":0,"n_rows":56,"n_cols":48,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
["CEG_UNITID","ASBUILT","DSGN_MHID","LOCATION","LOC_CODE","GRND_SURF","SURF_CODE","MANHOLE_DESC","MH_CODE","COMPTYPE_DESC","COMPTYPE","VALVE_DESC","VALVE_CODE","MH_TOR","MH_ELEV","MH_DPTH","BARL_DIAM","CVR_DIAM","CVRTYPE","CVR_CODE","FRAME_TYPE","FRM_CODE","RING_TYPE","RING_CODE","CONE_TYPE","CONE_CODE","WALL_TYPE","WALL_CODE","BENCH_TYPE","BENCH_CODE","CHNL_TYPE","CHNL_CODE","BASETYPE","BASE_CODE","STEP_TYPE","STEP_CODE","METERED","DROP_MH","DROP_PIPE_DIA","DROP_PIPE_INV","DOG_HSE","DATE_INSTALLED","PCPIRNO","SPEC_INST","OWNER","OWNER_CODE","SERV_STAT","SRVC_STAT_CODE"]
[null,null,null,null,{"$f":"LOOKUP($D2,$D$28:$E$35)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP($F2,$F$28:$G$35)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP($H2,$H$28:$I$34)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP($J2,$J$28:$K$57)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP($L2,$L$28:$M$34)","v":{"$error":"#N/A"}},null,null,{"$f":"(N2-O2)","v":0},null,null,null,{"$f":"LOOKUP($S2,$S$28:$T$29)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP($U2,$U$28:$V$29)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP($W2,$W$28:$X$29)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP($Y2,$Y$28:$Z$29)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP($AA2,$AA$28:$AB$29)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP($AC2,$AC$28:$AD29)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP($AE2,$AE$28:$AF$29)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP($AG2,$AG$28:$AH$29)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP($AI2,$AI$28:$AJ$29)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP($AS2,$AS$28:$AT$29)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP($AU2,$AU$28:$AV$29)","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,{"$f":"(N3-O3)","v":0},null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"LOOKUP($AC3,$AC$28:$AD30)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,0,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"LOOKUP($AC4,$AC$28:$AD31)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,0,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"LOOKUP($AC5,$AC$28:$AD32)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,0,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"LOOKUP($AC6,$AC$28:$AD33)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,0,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"LOOKUP($AC7,$AC$28:$AD34)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,0,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"LOOKUP($AC8,$AC$28:$AD35)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,0,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"LOOKUP($AC9,$AC$28:$AD36)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,0,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"LOOKUP($AC10,$AC$28:$AD37)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,0,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"LOOKUP($AC11,$AC$28:$AD38)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,0,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"LOOKUP($AC12,$AC$28:$AD39)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,0,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"LOOKUP($AC13,$AC$28:$AD30)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,0,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"LOOKUP($AC14,$AC$28:$AD31)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,0,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"LOOKUP($AC15,$AC$28:$AD32)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,0,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"LOOKUP($AC16,$AC$28:$AD33)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"LOOKUP($J17,$J$28:$K$56)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,null,0,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"LOOKUP($AC17,$AC$28:$AD34)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"LOOKUP($J18,$J$28:$K$57)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,null,{"$f":"(N18-O18)","v":0},null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"LOOKUP($AC18,$AC$28:$AD45)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,0,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"LOOKUP($AC19,$AC$28:$AD46)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,0,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"LOOKUP($AC20,$AC$28:$AD47)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,0,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"LOOKUP($AC21,$AC$28:$AD48)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,0,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"LOOKUP($AC22,$AC$28:$AD49)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,0,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"LOOKUP($AC23,$AC$28:$AD40)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,0,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"LOOKUP($AC24,$AC$28:$AD41)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,0,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"LOOKUP($AC25,$AC$28:$AD42)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[]
[]
[null,null,null,"Alley","K","Asphalt Street","ASPH","Diversion Manhole","DIV","Abandoned Air Relief Valve",35,"Air Release Valved Plugged","ARVP",null,null,null,null,null,"Bolted Down","D","Cast Iron","I","Precast Concrete","E","Precast Concrete","E","Precast Concrete","E","Precast Concrete","E","Pipe","P","Pipe","P","Fiberglass","FIB","Yes","Yes-Inside",null,null,"Yes",null,null,null,"Citizens Energy","CEG","In Service","I"]
[null,null,null,"Easement, Good Access","G","Concrete","CONC","Drop Manhole","DMH","Abandoned Manhole",22,"Air Relief Valve","ARV",null,null,null,null,null,"Solid","S",null,null,null,null,null,null,null,null,null,null,"Precast Concrete","E","Precast Concrete","E",null,null,"No","Yes-Outside",null,null,"No",null,null,null,"Private","PRIV","Out of Service","O"]
[null,null,null,"Easement,Adj To Street Row","D","Dirt / Grass","DIRT","Lamphole","LMP","Air Release Valve",35,"Gate Valve","GV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,null,null,"Greenways and Trails","GRWY","Gravel","GRAV","Net Structure","NET","Air Release Valve Plugged",35,"Isolation Valve","ISO"]
[null,null,null,"Parking Lot, Good Access","J","Highway Or Runway","L","Regulator Manhole","REG","Blind Tie",24,"Low Pressure Cleanout","CLNOUT"]
[null,null,null,"Parking Lot, Poor Access","I","Railroad","RR","Sanitary Manhole","SMH","Capped Stub Out",24,"Terminal Flushing Valve","TERM"]
[null,null,null,"Street Row, Heavy Traffic","B","Sidewalk","WALK","Summit Manhole","SMT","Combined Manhole",22,"Trace Wire Access","TRA"]
[null,null,null,"Street Row, Light Traffic","C","Waterway Or Railway","K",null,null,"Combined Outfall (CSO)",24]
[null,null,null,null,null,null,null,null,null,"Dead End/Plugged Line",25]
[null,null,null,null,null,null,null,null,null,"Divergence Structure",22]
[null,null,null,null,null,null,null,null,null,"Gate Valve",35]
[null,null,null,null,null,null,null,null,null,"Inflatable Dam Access Manhole",22]
[null,null,null,null,null,null,null,null,null,"Inflatable Dam Equipment Vault",69]
[null,null,null,null,null,null,null,null,null,"Inflatable Dam Point",24]
[null,null,null,null,null,null,null,null,null,"Isolation Valve",35]
[null,null,null,null,null,null,null,null,null,"Lamp Hole",24]
[null,null,null,null,null,null,null,null,null,"Manhole",22]
[null,null,null,null,null,null,null,null,null,"Metering Structure",69]
[null,null,null,null,null,null,null,null,null,"Netting Structure",22]
[null,null,null,null,null,null,null,null,null,"Node",24]
[null,null,null,null,null,null,null,null,null,"Odor Control Structure",69]
[null,null,null,null,null,null,null,null,null,"Pinch Valve Access Manhole",22]
[null,null,null,null,null,null,null,null,null,"Pinch Valve Equipment Vault",69]
[null,null,null,null,null,null,null,null,null,"Real Time Control",69]
[null,null,null,null,null,null,null,null,null,"Regulator Manhole",22]
[null,null,null,null,null,null,null,null,null,"Sludge Access Structure",22]
[null,null,null,null,null,null,null,null,null,"Term Flush Valve",35]
[null,null,null,null,null,null,null,null,null,"Treatment Plant Structure",98]
[null,null,null,null,null,null,null,null,null,"Weir",24]

{"sheet":"Field Descriptions","index":1,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["FIELD","TYPE","LENGTH","PRECISION","SCALE","REQUIRED","DESCRIPTION"]
[]
["CEG_UNITID","SHORT",6,null,null,"NO","CEG Manhole Identification - Reserved for CEG"]
["ASBUILT","TEXT",10,null,null,"NO","As-built number - Reserved for CEG"]
["DESGN_MHID","TEXT",16,null,null,"YES","Design Manhole Identification"]
["LOCATION","TEXT",75,null,null,"YES","Surface location and access description from pick list"]
["LOC_CODE","TEXT",4,null,null,"AUTO","Code required for Asset Management Software - will auto populate"]
["GRND_SURF","TEXT",25,null,null,"YES","Surface cover material around manhole from pick list"]
["SURF_CODE","TEXT",5,null,null,"AUTO","Code required for Asset Management Software - will auto populate"]
["MANHOLE_DESC","TEXT",50,null,null,"YES","Manhole description from pick list"]
["MH_CODE","TEXT",4,null,null,"AUTO","Code required for Asset Management Software - will auto populate"]
["COMPTYPE_DESC","TEXT",50,null,null,"YES","Manhole Type from pick list"]
["COMPTYPE","SHORT",2,null,null,"AUTO","Code required for Asset Management Software - will auto populate"]
["VALVE_DESC","TEXT",50,null,null,"YES","Valve type from pick list"]
["VALVE_CODE","TEXT",10,null,null,"AUTO","Code required for Asset Management Software - will auto populate"]
["MH_TOR","DOUBLE",null,6,2,"YES","Manhole top of rim - decimal feet"]
["MH_INV","DOUBLE",null,6,2,"YES","Elevation invert of manhole - decimal feet"]
["MH_DPTH","DOUBLE",null,6,2,"AUTO","Difference bewtween manhole top of rim and manhole invert -   auto calculated in this sheet"]
["BARL_DIAM","DOUBLE",null,6,2,"YES","Barrel diameter in inches"]
["CVR_DIAM","DOUBLE",null,6,2,"YES","Cover diameter in inches"]
["CVRTYPE","TEXT",25,null,null,"YES","Cover type from pick list"]
["CVR_CODE","TEXT",4,null,null,"AUTO","Code required for Asset Management Software - will auto populate"]
["FRAME_TYPE","TEXT",25,null,null,"YES","Manhole casting material from pick list"]
["FRM_CODE","TEXT",4,null,null,"AUTO","Code required for Asset Management Software - will auto populate"]
["RING_TYPE","TEXT",25,null,null,"YES","Riser ring material from pick list"]
["RING_CODE","TEXT",4,null,null,"AUTO","Code required for Asset Management Software - will auto populate"]
["CONE_TYPE","TEXT",25,null,null,"YES","Cone material from pick list"]
["CONE_CODE","TEXT",4,null,null,"AUTO","Code required for Asset Management Software - will auto populate"]
["WALL_TYPE","TEXT",25,null,null,"YES","Wall material from pick list"]
["WALL_CODE","TEXT",4,null,null,"AUTO","Code required for Asset Management Software - will auto populate"]
["BENCH_TYPE","TEXT",25,null,null,"YES","Bench type from pick list"]
["BENCH_CODE","TEXT",4,null,null,"AUTO","Code required for Asset Management Software - will auto populate",null,"z"]
["CHNL_TYPE","TEXT",25,null,null,"YES","Channel type from pick list"]
["CHNL_CODE","TEXT",4,null,null,"AUTO","Code required for Asset Management Software - will auto populate"]
["BASETYPE","TEXT",25,null,null,"YES","Base material from pick list"]
["BASE_CODE","TEXT",4,null,null,"AUTO","Code required for Asset Management Software - will auto populate"]
["STEP_TYPE","TEXT",25,null,null,"YES","Type of steps from pick list"]
["STEP_CODE","TEXT",4,null,null,"AUTO","Code required for Asset Management Software - will auto populate"]
["METERED","TEXT",4,null,null,"YES","Yes or No from pick list"]
["DROP_MH","TEXT",4,null,null,"YES","Yes or No from pick list"]
["DROP_PIPE_DIA","DOUBLE",null,3,2,"YES","Diameter of Drop Pipe - Inches"]
["DROP_PIPE_INV","DOUBLE",null,3,2,"YES","Invert of drop pipe - decimal feet"]
["DOG_HSE","TEXT",4,null,null,"YES","Yes or No from pick list"]
["DATE_INSTALLED","DATE",null,null,null,"YES","Date Installed MM/DD/YYYY (Estimate for As-Bid submission)"]
["PCPIRNO","TEXT",15,null,null,"OPTIONAL","Project number of PC/PIR project if applicable"]
["SPEC_INST","TEXT",254,null,null,"OPTIONAL","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"]