{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["SAN_LS","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_LS","index":0,"n_rows":35,"n_cols":37,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["CEG_LISID","CEG_LSNAME","ASBUILT","DSGN_LSID","LOCATION","LOC_CODE","LSTYPE_DESC","LSTYPE_CODE","LSCOMP_DESC","LSCOMP_CODE","WETWLELEV","WETWLVOL","OVELEV","NOPUMPS","PUMP_ID","PUMP_MFTR","PUMP_SERIAL","PUMP_MODEL","PUMP_CAPAC","PUMP_HP","PUMP_GPM","PUMP_TDH","PUMP_VSD","PUMP_VOLT","PUMP_PHASE","PUMP_DISCH","PUMP_ON","PUMP_OFF","ALARM","PUDISSIZE","INSTDATE","PCPIRNO","SPECINST","OWNER","OWNER_CODE","SERVSTAT","SRVC_STAT"]
[null,null,null,null,null,{"$f":"LOOKUP($E2,$E$28:$F$35)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP($G2,$G$28:$H$30)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP(I2,$I$28:$J$29)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP($AH2,$AH$28:$AI$29)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP($AJ2,$AJ$28:$AK$29)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"LOOKUP(I3,$I$28:$J$29)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"LOOKUP(I18,$I$28:$J$29)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"LOOKUP(I19,$I$28:$J$29)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"LOOKUP(I20,$I$28:$J$29)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"LOOKUP(I21,$I$28:$J$29)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"LOOKUP(I25,$I$28:$J$29)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[]
[]
[null,null,null,null,"Alley","K","Dry Well","DRY","Sanitary Lift Station",15,null,null,null,1,"Pump 1",null,null,null,null,null,null,null,"Yes",null,null,null,null,null,null,null,null,null,null,"Citizens Energy","CEG","In Service","I"]
[null,null,null,null,"Easement, Good Access","G","Interceptor Station","INT",null,null,null,null,null,2,"Pump 2",null,null,null,null,null,null,null,"No",null,null,null,null,null,null,null,null,null,null,"Private","PRIV","Out of Service","O"]
[null,null,null,null,"Easement,Adj To Street Row","D","Submersible","SUB",null,null,null,null,null,3,"Pump 3"]
[null,null,null,null,"Greenways and Trails","GRWY",null,null,null,null,null,null,null,4,"Pump 4"]
[null,null,null,null,"Parking Lot, Good Access","J"]
[null,null,null,null,"Parking Lot, Poor Access","I"]
[null,null,null,null,"Street Row, Heavy Traffic","B"]
[null,null,null,null,"Street Row, Light Traffic","C"]

{"sheet":"Field Descriptions","index":1,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["FIELD","TYPE","LENGTH","PRECISION","SCALE","REQUIRED","DESCRIPTION"]
[]
["CEG_LISID","SHORT",6,null,null,"NO","CEG Manhole Identification - Reserved for CEG"]
["CEG_LSNAME","TEXT",150,null,null,"NO","CEG Lift Station Name - Reserved for CEG"]
["ASBUILT","TEXT",10,null,null,"NO","As-built number - Reserved for CEG"]
["DESGN_LSID","TEXT",16,null,null,"YES","Design Lift Station Identification"]
["LOCATION","TEXT",75,null,null,"YES","Surface location and access description"]
["LOC_CODE","TEXT",4,null,null,"AUTO","Code required for Asset Management Software - will auto populate"]
["LSTYPE_DESC","TEXT",6,null,null,null,"Lift station type"]
["LSTYPE_CODE","TEXT",20,null,null,"AUTO","Code required for Asset Management Software - will auto populate"]
["LSCOMP_DESC","TEXT",20,null,null,null,"Asset Management Software descriptor"]
["LSCOMP_CODE","TEXT",30,null,null,"AUTO","Code required for Asset Management Software - will auto populate"]
["WETWLELEV","DOUBLE",null,7,2,"YES","Wet well elevation in decimal feet (floor elevation)"]
["WETWLVOL","DOUBLE",null,7,2,"YES","Wet well volume in gallons"]
["OVELEV","DOUBLE",null,7,2,"YES","Wet well overflow elevation in decimal feet (equal to top or rim)"]
["NOPUMPS","SHORT",5,null,null,"YES","Number of pumps in the lift station - Select from pick list"]
["PUMP_ID","TEXT",10,null,null,"YES","Pump ID - Labeled Left to Right in Wet Well looking in the direction of discharge"]
["PUMP_MFTR","TEXT",254,null,null,"YES","Manufacturer of Pump"]
["PUMP_SERIAL","TEXT",50,null,null,null,"Serial number of pump"]
["PUMP_MODEL","TEXT",50,null,null,null,"Model number of pump"]
["PUMP_CAPAC","DOUBLE",null,9,1,null,"Pump capacity of station in GPM"]
["PUMP_HP","DOUBLE",null,7,2,null,"Pump Horsepower Rating"]
["PUMP_GPM","DOUBLE",null,7,2,null,"Pump rated GPM at the Design Point"]
["PUMP_TDH","DOUBLE",null,7,2,null,"TDH of pump in feet"]
["PUMP_VSD","TEXT",10,null,null,null,"Pump Variable Speed Drive - Yes or No"]
["PUMP_VOLT","SHORT",10,null,null,null,"Pump Volt Rating"]
["PUMP_PHASE","SHORT",10,null,null,null,"Pump Phasing Required"]
["PUMP_DISCH","DOUBLE",null,7,2,"YES","Diameter of Pump Discharge"]
["PUMP_ON","DOUBLE",null,7,2,"YES","Pump ON Elevation"]
["PUMP_OFF","DOUBLE",null,7,2,"YES","Pump OFF Elevation"]
["ALARM","DOUBLE",null,7,2,"YES","Wet Well Alarm Elevation"]
["PUDISSIZE","DOUBLE",null,7,2,"YES","Size of the Forcemain in inches"]
["INSTDATE","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"]
["SPECINST","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,"AUTO","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"]