{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["填写说明","线表","点表"],"read":"whole","date_system":"1900"}

{"sheet":"填写说明","index":0,"n_rows":90,"n_cols":6,"rows_kept":90,"merged":[[1,0,1,5],[2,0,2,5],[3,0,3,16383],[4,0,4,5],[5,0,5,5],[6,0,6,5],[9,0,11,0],[12,0,13,0],[14,0,43,0],[44,0,50,0],[51,0,53,0],[54,0,55,0],[56,0,60,0],[61,0,64,0],[67,0,67,1],[68,0,70,0],[68,1,68,2],[69,2,70,2],[69,3,70,3]]}
["一、总体填写要求："]
["1、有关日期信息的单元格格式必须为日期型XXXX-XX-XX 。"]
["2、横坐标、纵坐标、埋设深度、地面高程、管顶高程小数点后保留2位。"]
["4、本点号生成规则：本点号=BDH+-+序号（每份工程序号从1开始）。举例：BDH-1,BDH-2"]
["5、点表中的本点号必须都存在于线表的本点号和上点号中。点表本点号不能为空，且不能重复。不同本点号对应的横坐标、纵坐标不允许重复（即使实际是同一坐标，在制作点线表时必须进行偏移，偏移量为1毫米）。"]
["6、线表中的本点号、上点号必须都被包含在点表的本点号中。线表中本点号、上点号不能为空，且不能重复。"]
["7、物探表文件名称不能重复。物探表命名规则：工程编号+WT.xls。"]
[]
["二、设备属性：",{"$nulls":3},"设备类别"]
["目前状态","损坏",null,null,"!!!","虚拟管道"]
[null,"发生故障",null,null,300,"75~300mm管道"]
[null,"正常",null,null,"3T","三通"]
["阀门转向","逆时针",null,null,"4T","四通"]
[null,"顺时针",null,null,500,"300~500mm管道"]
["口径",1600,null,null,75,"75mm以下管道"]
[null,1400,null,null,800,"500~800mm管道"]
[null,3000,null,null,"800+","800mm以上管道"]
[null,2800,null,null,"???","待确认管道"]
[null,2500,null,null,"B","泵"]
[null,2400,null,null,"BCD","变材"]
[null,2200,null,null,"BF","泵房"]
[null,2000,null,null,"BJD","变径"]
[null,1800,null,null,"BSD","变深点"]
[null,1500,null,null,"BZ","泵站"]
[null,1200,null,null,"CLD","测流点"]
[null,1000,null,null,"CSK","出水口"]
[null,900,null,null,"CYD","测压点"]
[null,800,null,null,"DESIGNA","管网设计图"]
[null,700,null,null,"DESIGNP","设备设计图"]
[null,600,null,null,"DF","蝶阀"]
[null,500,null,null,"DT","多通"]
[null,400,null,null,"FG300","75~300mm废管管道"]
[null,300,null,null,"FG3T","废管三通"]
[null,200,null,null,"FG4T","废管四通"]
[null,150,null,null,"FG500","300~500mm废管管道"]
[null,100,null,null,"FG75","75mm以下废管管道"]
[null,80,null,null,"FG800","500~800mm废管管道"]
[null,75,null,null,"FG800+","800mm以上废管管道"]
[null,50,null,null,"FG???","待确认废管管道"]
[null,40,null,null,"FGBJD","废管变径点"]
[null,32,null,null,"FGFM","废管阀门"]
[null,25,null,null,"FGST","废管管堵"]
[null,20,null,null,"FGXHS","废管消火栓"]
[null,15,null,null,"FJSD","非居民用户接水点"]
["管网材质","白铁",null,null,"FL","法兰"]
[null,"PE",null,null,"FM","阀门"]
[null,"塑料",null,null,"FMJ","阀门井"]
[null,"混凝土",null,null,"FPCQ","非普查区"]
[null,"球墨铸铁",null,null,"FWZD","服务站点"]
[null,"钢",null,null,"FYH","非居民用户水表"]
[null,"铸铁",null,null,"JCJ","检查井"]
["阀门材质","不锈钢梗",null,null,"JSB","生活监视表"]
[null,"铁梗",null,null,"JSD","用户接水点"]
[null,"铜梗",null,null,"JSF","接水阀"]
["阀门转向","逆开",null,null,"JSK","进水口"]
[null,"顺开",null,null,"JYBZ","加压泵站"]
["阀门功能","放水阀门",null,null,"JYF","减压阀"]
[null,"旁通阀门",null,null,"KSL","块水量"]
[null,"主干线阀门",null,null,"LLY","流量仪"]
[null,"联通阀门",null,null,"LSJCD","漏水检测点"]
[null,"分支线阀门",null,null,"NODE","节点"]
["阀门类型","方闸板",null,null,"PNF","排泥阀"]
[null,"闸阀",null,null,"PQF","排气阀"]
[null,"蝶阀",null,null,"PSF","排水阀"]
[null,"软密封闸阀",null,null,"PXD","偏心点"]
[{"$nulls":4},"SC","水厂"]
[{"$nulls":4},"SCHEMEA","管网规划图"]
["三、埋深、高程定义",{"$nulls":3},"SCHEMEP","设备规划图"]
["类别","属性定义",null,null,"SHT","水塔"]
[null,"埋深                      ","高程",null,"SK","水库"]
[null,"（管件或设备在地面以下是正值，在地面以上是负值）",null,null,"SSJ","伸缩节"]
["节点","该节点所在管道管面距安装点地面的垂直高度。","安装点平面位置的绝对高程",null,"ST","堵板"]
["阀门","阀体与管道连接处顶部距安装地点地面的垂直距离","安装点平面位置的绝对高程",null,"SYD","水源"]
["消防栓","消防栓最高点到安装点地面的垂直高度。","安装点平面位置的绝对高程",null,"SZCYD","水质监测点"]
["水表","测流设备中心点距安装点地面的垂直高度。","安装点平面位置的绝对高程",null,"TCD","探测点"]
["测压计","压力传感器距安装点地面的垂直高度","安装点平面位置的绝对高程",null,"TQD","透气洞"]
[{"$nulls":4},"WT","弯头"]
[{"$nulls":4},"XFJSB","消防监视表"]
[{"$nulls":4},"XHS","消火栓"]
[{"$nulls":4},"YH","用户水表"]
[{"$nulls":4},"YLK","预留口"]
[{"$nulls":4},"YS300","75~300mm原水管道"]
[{"$nulls":4},"YS500","300~500mm原水管道"]
[{"$nulls":4},"YS75","75mm以下原水管道"]
[{"$nulls":4},"YS800","500~800mm原水管道"]
[{"$nulls":4},"YS800+","800mm以上原水管道"]
[{"$nulls":4},"YS???","待确认原水管道"]
[{"$nulls":4},"ZF","闸阀"]
[{"$nulls":4},"ZHF","止回阀"]
[{"$nulls":4},"ZXD","直通"]

{"sheet":"线表","index":1,"n_rows":3,"n_cols":24,"rows_kept":3}
["ID","BDH","SDH","PROJECT","PRJNAME","ROADNAME","DEPTH","LENGTH","SBLB","DIAMETER","MATERIAL","INS_TYPE","ELEV_S","ELEV_E","DEPTH_S","DEPTH_E","IN_DATE","PURPOSE","PAVEMENT","COMP_NAME","SSQX","SSZS","SOURCE","MEMO"]
["管线编号","本点号","上点号","工程编号","工程名称","所在道路","平均埋深","管长","设备类别","管径","管材","埋设方式","起点标高","终点标高","起点埋深","终点埋深","埋设日期","管网用途","路面情况","所属公司","所属区县","管理单位","数据来源","备注"]
[{"$nulls":6},"仅数字","仅数字",null,"仅数字",null,null,"仅数字","仅数字","仅数字","仅数字","2006-01-01"]

{"sheet":"点表","index":2,"n_rows":3,"n_cols":20,"rows_kept":3}
["SBLB","ID","BDH","PROJECT","PRJNAME","ROADNAME","DEPTH","DATE_I","COMP_NAME","SSQX","SSZS","DIAMETER","MATERIAL","TYPE","MODEL","ELEV","X","Y","SOURCE","MEMO"]
["设备类别","设备编号","本点号","工程编号","工程名称","所在道路","埋设深度","安装日期","所属公司","所属区县","管理单位","设备口径","设备材质","设备类型","设备型号","设备高程","横坐标","纵坐标","数据来源","备注"]
[{"$nulls":6},"仅数字","2010-08-24",{"$nulls":3},"仅数字",{"$nulls":3},"仅数字","仅数字","仅数字"]