{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["计量设备检定、校准","计量设备安装、拆除及维护等服务"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"计量设备检定、校准","index":0,"n_rows":43,"n_cols":9,"rows_kept":43,"merged":[[0,0,0,8],[1,0,1,8],[2,0,2,8],[3,0,3,8],[4,0,6,0],[4,1,6,1],[4,2,6,2],[4,3,6,3],[4,4,4,6],[4,8,6,8],[4,9,6,9],[4,10,6,10],[4,11,6,11],[5,4,5,5],[5,6,6,6],[5,7,6,7],[42,0,42,8],[46,3,47,3]]}
["附件一"]
["计量设备安装、拆除计价情况"]
["文件要求：\n（一）应用户要求，对其计量设备检定、校准，以及相应的计量设备安装及拆除产生的费用，包含材料费用、检定费、校准费、安装工程服务费用。\n（二）按照“谁委托、谁付费”原则，检定费用由委托方支付，但计量装置经检定确有问题的，由供水企业承担检定费用，并免费为用户更换合格的计量装置。"]
["工作流程：\n应用户要求、对其计量设备检定、校准的工作流程：由用户申请计量设备检定、校准；我司收到申请后，预约用户到水表位置，与用户进行工作交底；拆除水表，封装水表；由用户把水表送到第三方检测出检测，检测完成后如水表准确，则用户把水表送回自来水公司或原水表位置处；我司派人对检核后的水表进行复装；费用由用户支付。如：水表校准有误，则所有费用全免。"]
["表径","水表类型","拆除、复装水表所需工时（多少人工/小时）","拆除、复装机械工时（载货汽车吨位/小时）","按工料计价计算（含税）",null,null,"按相关定额标准计价(不含水表价格）","工料计价/定额计价"]
[{"$nulls":4},"工料计算组成",null,"合计","合计"]
[{"$nulls":4},"人工","机械费"]
["DN15","LXS-15F旋翼式液封表","2人/2小时","1.5T/3小时",{"$f":"315/8*4","v":157.5},{"$f":"86.84*3","v":260.52},{"$f":"E8+F8","v":418.02},154.27,{"$f":"G8/H8","v":{"v":2.70966487327413,"d":"2.71"}}]
["DN20","LXS-20F旋翼式液封表","2人/2小时","1.5T/3小时",{"$f":"315/8*4","v":157.5},{"$f":"86.84*3","v":260.52},{"$f":"E9+F9","v":418.02},154.27,{"$f":"G9/H9","v":{"v":2.70966487327413,"d":"2.71"}}]
["DN25","LXS-25F旋翼式液封表","2人/2.5小时","1.5T/3.5小时",{"$f":"315/8*5","v":{"v":196.875,"d":"196.88"}},{"$f":"86.84*3.5","v":303.94},{"v":500.815,"d":"500.82"},201.58,{"v":2.48444786189106,"d":"2.48"}]
["DN40","LXS-40F旋翼式液封表","2人/2.5小时","1.5T/3.5小时",{"$f":"315/8*5","v":{"v":196.875,"d":"196.88"}},{"$f":"86.84*3.5","v":303.94},{"v":500.815,"d":"500.82"},299.42,{"v":1.67261705964865,"d":"1.67"}]
["DN50","LXS-50F旋翼式液封表","2人/3小时","1.5T/4小时",{"$f":"315/8*6","v":236.25},{"$f":"86.84*4","v":347.36},583.61,299.42,{"v":1.94913499432236,"d":"1.95"}]
["DN80","WS垂直螺翼式表","4人/3.5小时","1.5T/4.5小时",{"$f":"315/8*14","v":551.25},{"$f":"86.84*4.5","v":390.78},942.03,{"v":405.8,"d":"405.80"},{"v":2.3214144898965,"d":"2.32"}]
["DN100","WS垂直螺翼式表","4人/4小时","1.5T/5小时",{"$f":"315/8*16","v":630},{"$f":"86.84*5","v":434.2},{"v":1064.2,"d":"1064.20"},529.79,{"v":2.00872043639933,"d":"2.01"}]
["DN150","WS垂直螺翼式表","5人/4.5小时","1.5T/5.5小时",{"$f":"315/8*22.5","v":{"v":885.9375,"d":"885.94"}},{"$f":"86.84*5.5","v":477.62},{"v":1363.5575,"d":"1363.56"},745.63,{"v":1.82873207891313,"d":"1.83"}]
["DN200","WS垂直螺翼式表","6人/5小时","1.5T/6小时",{"$f":"315/8*30","v":1181.25},{"$f":"86.84*6","v":521.04},1702.29,995.53,{"v":1.70993340230832,"d":"1.71"}]
["DN250","LXLC可拆卸螺翼式表","6人/5.5小时","1.5T/6.5小时",{"$f":"315/8*33","v":{"v":1299.375,"d":"1299.38"}},{"$f":"86.84*6.5","v":564.46},{"v":1863.835,"d":"1863.84"},1209.83,{"v":1.54057594868701,"d":"1.54"}]
["DN300","LXLC可拆卸螺翼式表","6人/6小时","1.5T/7小时",{"$f":"315/8*36","v":1417.5},{"$f":"86.84*7","v":607.88},2025.38,1579.81,{"v":1.28204024534596,"d":"1.28"}]
["DN20","智能山科脉冲表","2人/3小时","1.5T/4小时",{"$f":"315/8*6","v":236.25},{"$f":"86.84*4","v":347.36},583.61,154.27,{"v":3.7830427173138,"d":"3.78"}]
["DN20","智能立式脉冲表","2人/3小时","1.5T/4小时",236.25,347.36,583.61,154.27,{"v":3.7830427173138,"d":"3.78"}]
["DN20","智能浙江宁波表","2人/3小时","1.5T/4小时",236.25,347.36,583.61,154.27,{"v":3.7830427173138,"d":"3.78"}]
["DN20","智能北京京源表","2人/3小时","1.5T/4小时",236.25,347.36,583.61,154.27,{"v":3.7830427173138,"d":"3.78"}]
["DN20","智能NB无线表","2人/3小时","1.5T/4小时",236.25,347.36,583.61,154.27,{"v":3.7830427173138,"d":"3.78"}]
["DN20","智能山科摄像表","2人/3小时","1.5T/4小时",236.25,347.36,583.61,154.27,{"v":3.7830427173138,"d":"3.78"}]
["DN25","智能山科脉冲表","2人/3.5小时","1.5T/4.5小时",{"$f":"315/8*7","v":275.625},{"$f":"86.84*4.5","v":390.78},{"v":666.405,"d":"666.41"},201.58,{"v":3.30590832423852,"d":"3.31"}]
["DN25","智能浙江宁波表","2人/3.5小时","1.5T/4.5小时","/","/","/","/","/"]
["DN25","智能北京京源表","2人/3.5小时","1.5T/4.5小时",275.625,{"$f":"86.84*4.5","v":390.78},{"$f":"E27+F27","v":{"v":666.405,"d":"666.41"}},201.58,{"v":3.30590832423852,"d":"3.31"}]
["DN25","智能NB无线表","2人/3.5小时","1.5T/4.5小时",275.625,{"$f":"86.84*4.5","v":390.78},{"$f":"E28+F28","v":{"v":666.405,"d":"666.41"}},201.58,{"v":3.30590832423852,"d":"3.31"}]
["DN40","智能山科脉冲表","2人/3.5小时","1.5T/4.5小时",275.625,{"$f":"86.84*4.5","v":390.78},{"$f":"E29+F29","v":{"v":666.405,"d":"666.41"}},299.42,{"v":2.22565292899606,"d":"2.23"}]
["DN40","智能浙江宁波表","2人/3.5小时","1.5T/4.5小时","/","/","/","/","/"]
["DN40","智能北京京源表","2人/3.5小时","1.5T/4.5小时",{"$f":"315/8*7","v":275.625},{"$f":"86.84*4.5","v":390.78},{"$f":"E31+F31","v":{"v":666.405,"d":"666.41"}},299.42,{"v":2.22565292899606,"d":"2.23"}]
["DN40","智能NB无线表","2人/3.5小时","1.5T/4.5小时",{"$f":"315/8*7","v":275.625},{"$f":"86.84*4.5","v":390.78},{"$f":"E32+F32","v":{"v":666.405,"d":"666.41"}},299.42,{"v":2.22565292899606,"d":"2.23"}]
["DN50","智能山科脉冲表","2人/4小时","1.5T/5小时",{"$f":"315/8*8","v":315},{"$f":"86.84*5","v":434.2},{"$f":"E33+F33","v":{"v":749.2,"d":"749.20"}},299.42,{"v":2.50217086366976,"d":"2.50"}]
["DN50","智能浙江宁波表","2人/4小时","1.5T/5小时","/","/","/","/","/"]
["DN50","智能北京京源表","2人/4小时","1.5T/5小时",315,{"$f":"86.84*5","v":434.2},{"$f":"+E35+F35","v":{"v":749.2,"d":"749.20"}},299.42,{"v":2.50217086366976,"d":"2.50"}]
["DN50","智能NB无线表","2人/4小时","1.5T/5小时",315,{"$f":"86.84*5","v":434.2},{"$f":"+E36+F36","v":{"v":749.2,"d":"749.20"}},299.42,{"v":2.50217086366976,"d":"2.50"}]
["DN80","远传表","4人/4.5小时","1.5T/5.5小时",{"$f":"315/8*18","v":708.75},{"$f":"86.84*5.5","v":477.62},1186.37,405.8,{"v":2.92353376047314,"d":"2.92"}]
["DN100","远传表","4人/5小时","1.5T/6小时",{"$f":"315/8*20","v":787.5},{"$f":"86.84*6","v":521.04},1308.54,529.79,{"v":2.4699220445837,"d":"2.47"}]
["DN150","远传表","5人/5.5小时","1.5T/6.5小时",{"$f":"315/8*27.5","v":{"v":1082.8125,"d":"1082.81"}},{"$f":"86.84*6.5","v":564.46},{"v":1647.2725,"d":"1647.27"},745.63,{"v":2.20923581400963,"d":"2.21"}]
["DN200","远传表","6人/5.5小时","1.5T/6小时",{"$f":"315/8*33","v":{"v":1299.375,"d":"1299.38"}},{"$f":"86.84*6","v":521.04},{"v":1820.415,"d":"1820.42"},995.53,{"v":1.82858879189979,"d":"1.83"}]
["DN250","远传表","6人/6.5小时","1.5T/7.5小时",{"$f":"315/8*39","v":{"v":1535.625,"d":"1535.63"}},{"$f":"86.84*7.5","v":651.3},{"v":2186.925,"d":"2186.93"},1209.83,{"v":1.80762999760297,"d":"1.81"}]
["DN300","远传表","6人/7小时","1.5T/8小时",{"$f":"315/8*42","v":1653.75},{"$f":"86.84*8","v":694.72},2348.47,1575.71,{"v":1.49042019153271,"d":"1.49"}]
["备注：1、人工单价按《广州市建设工程造价管理站关于发布2021年9月份广州市建设工程价格信息及有关计价办法的通知》管工单价\n         315元/工日（8小时）计算。\n     2、机械费按《广东省市政工程综合定额2018》计算，计算结果为:694.65元/台班（8小时）。\n     3、定额标准计价按照《工程量清单项目计算规范（2013—广东）》、《广东省市政工程综合定额2018》计算。\n     4、不含围蔽费用。\n     5、拆除、复装水表所需工时和工程量及机械工时由表务中心提供。\n     6、不含水表检定费用。"]

{"sheet":"计量设备安装、拆除及维护等服务","index":1,"n_rows":43,"n_cols":10,"rows_kept":43,"merged":[[1,0,1,9],[2,0,2,9],[3,0,3,9],[4,0,6,0],[4,1,6,1],[4,2,6,2],[4,3,6,3],[4,4,4,7],[4,9,6,9],[4,11,6,11],[4,12,6,12],[4,13,6,13],[5,4,5,6],[5,7,6,7],[5,8,6,8],[42,0,42,9],[46,3,47,3]]}
["附件二"]
["计量设备更换计价情况"]
["文件要求：\n应用户要求，提供更换或安装水表、改移安装、维护等服务时产生的费用，主要包括材料费用、安装工程服务费用等。"]
["工作流程：\n由用户申请计量设备安装、拆除申请；我司收到申请后，预约用户到水表位置，与用户进行工作交底；按申请要求，对水表进行更换、复装。"]
["表径","水表类型","拆除、复装水表所需工时（多少人工/小时）","拆除、复装机械工时\n（载货汽车吨位/小时）","按工料计价计算（含税）",{"$nulls":3},"按相关定额标准计价(含水表价格）","工料计价/定额计价"]
[{"$nulls":4},"工料计算组成",null,null,"合计","合计"]
[{"$nulls":4},"材料","人工","机械费"]
["DN15","LXS-15F旋翼式液封表","2人/1小时","1.5T/2小时",55,{"$f":"315/8*2","v":78.75},{"$f":"86.84*2","v":173.68},{"$f":"E8+F8+G8","v":307.43},207.33,{"$f":"H8/I8","v":{"v":1.48280518979405,"d":"1.48"}}]
["DN20","LXS-20F旋翼式液封表","2人/2小时","1.5T/2小时",60,{"$f":"315/8*2","v":78.75},{"$f":"86.84*2","v":173.68},312.43,212.15,{"$f":"H9/I9","v":{"v":1.47268442139995,"d":"1.47"}}]
["DN25","LXS-25F旋翼式液封表","2人/1.5小时","1.5T/2.5小时",85,{"$f":"315/8*3","v":{"v":118.125,"d":"118.13"}},{"$f":"86.84*2.5","v":217.1},{"v":420.225,"d":"420.23"},283.59,{"v":1.48180471807892,"d":"1.48"}]
["DN40","LXS-40F旋翼式液封表","2人/1.5小时","1.5T/2.5小时",190,{"$f":"315/8*3","v":{"v":118.125,"d":"118.13"}},{"$f":"86.84*2.5","v":217.1},{"v":525.225,"d":"525.23"},482.71,{"v":1.08807565619109,"d":"1.09"}]
["DN50","LXS-50F旋翼式液封表","2人/2小时","1.5T/3小时",280,{"$f":"315/8*4","v":157.5},{"$f":"86.84*3","v":260.52},698.02,569.51,{"v":1.22565012027884,"d":"1.23"}]
["DN80","WS垂直螺翼式表","4人/2.5小时","1.5T/3.5小时",930,{"$f":"315/8*10","v":393.75},{"$f":"86.84*3.5","v":303.94},1627.69,1302.98,{"v":1.24920566700947,"d":"1.25"}]
["DN100","WS垂直螺翼式表","4人/3小时","1.5T/4小时",1060,{"$f":"315/8*12","v":472.5},{"$f":"86.84*4","v":347.36},1879.86,1552.28,{"v":1.21103151493287,"d":"1.21"}]
["DN150","WS垂直螺翼式表","5人/3.5小时","1.5T/4.5小时",1950,{"$f":"315/8*17.5","v":{"v":689.0625,"d":"689.06"}},{"$f":"86.84*4.5","v":390.78},{"v":3029.8425,"d":"3029.84"},2626.61,{"v":1.15351822310887,"d":"1.15"}]
["DN200","WS垂直螺翼式表","6人/4小时","1.5T/5小时",3750,{"$f":"315/8*24","v":945},{"$f":"86.84*5","v":434.2},{"v":5129.2,"d":"5129.20"},4613.24,{"v":1.11184330318821,"d":"1.11"}]
["DN250","LXLC可拆卸螺翼式表","6人/4.5小时","1.5T/5.5小时",2780,{"$f":"315/8*27","v":{"v":1063.125,"d":"1063.13"}},{"$f":"86.84*5.5","v":477.62},{"v":4320.745,"d":"4320.75"},3891.43,{"v":1.11032319738502,"d":"1.11"}]
["DN300","LXLC可拆卸螺翼式表","6人/5小时","1.5T/6小时",5200,{"$f":"315/8*30","v":1181.25},{"$f":"86.84*6","v":521.04},6902.29,6595.74,{"v":1.04647696846753,"d":"1.05"}]
["DN20","智能山科脉冲表","2人/2小时","1.5T/3小时",{"$f":"60+480","v":540},{"$f":"315/8*4","v":157.5},{"$f":"86.84*3","v":260.52},958.02,675.16,{"v":1.41895254458203,"d":"1.42"}]
["DN20","智能立式脉冲表","2人/2小时","1.5T/3小时",540,157.5,260.52,958.02,675.16,{"v":1.41895254458203,"d":"1.42"}]
["DN20","智能浙江宁波表","2人/2小时","1.5T/3小时",335,157.5,260.52,753.02,477.42,{"v":1.57726949017636,"d":"1.58"}]
["DN20","智能北京京源表","2人/2小时","1.5T/3小时",340,157.5,260.52,758.02,482.24,{"v":1.57187292634373,"d":"1.57"}]
["DN20","智能NB无线表","2人/2小时","1.5T/3小时",282.5,157.5,260.52,700.52,426.77,{"v":1.64144621224547,"d":"1.64"}]
["DN20","智能山科摄像表","2人/2小时","1.5T/3小时",{"$f":"60+480","v":540},157.5,260.52,958.02,675.16,{"v":1.41895254458203,"d":"1.42"}]
["DN25","智能山科脉冲表","2人/2.5小时","1.5T/3.5小时",{"$f":"85+480","v":565},{"$f":"315/8*5","v":{"v":196.875,"d":"196.88"}},{"$f":"86.84*3.5","v":303.94},{"v":1065.815,"d":"1065.82"},746.58,{"v":1.42759650673739,"d":"1.43"}]
["DN25","智能浙江宁波表","2人/2.5小时","1.5T/3.5小时","/","/","/","/","/","/"]
["DN25","智能北京京源表","2人/2.5小时","1.5T/3.5小时",490,{"v":196.875,"d":"196.88"},{"$f":"86.84*3.5","v":303.94},{"$f":"E27+F27+G27","v":{"v":990.815,"d":"990.82"}},674.24,{"v":1.46952865448505,"d":"1.47"}]
["DN25","智能NB无线表","2人/2.5小时","1.5T/3.5小时",301,{"v":196.875,"d":"196.88"},{"$f":"86.84*3.5","v":303.94},{"v":801.815,"d":"801.82"},491.94,{"v":1.62990405333984,"d":"1.63"}]
["DN40","智能山科脉冲表","2人/2.5小时","1.5T/3.5小时",{"$f":"190+480","v":670},{"v":196.875,"d":"196.88"},{"$f":"86.84*3.5","v":303.94},{"v":1170.815,"d":"1170.82"},945.72,{"v":1.23801442287358,"d":"1.24"}]
["DN40","智能浙江宁波表","2人/2.5小时","1.5T/3.5小时","/","/","/","/","/","/"]
["DN40","智能北京京源表","2人/2.5小时","1.5T/3.5小时",1100,{"$f":"315/8*5","v":{"v":196.875,"d":"196.88"}},{"$f":"86.84*3.5","v":303.94},{"$f":"E31+F31+G31","v":{"v":1600.815,"d":"1600.82"}},1360.49,{"v":1.17664591433969,"d":"1.18"}]
["DN40","智能NB无线表","2人/2.5小时","1.5T/3.5小时",975,{"$f":"315/8*5","v":{"v":196.875,"d":"196.88"}},{"$f":"86.84*3.5","v":303.94},{"v":1475.815,"d":"1475.82"},1239.92,{"v":1.1902501774308,"d":"1.19"}]
["DN50","智能山科脉冲表","2人/3小时","1.5T/4小时",{"$f":"280+480","v":760},{"$f":"315/8*6","v":236.25},{"$f":"86.84*4","v":347.36},1343.61,1032.52,{"v":1.30129198465889,"d":"1.30"}]
["DN50","智能浙江宁波表","2人/3小时","1.5T/4小时","/","/","/","/","/","/"]
["DN50","智能北京京源表","2人/3小时","1.5T/4小时",1910,{"$f":"315/8*6","v":236.25},{"$f":"86.84*4","v":347.36},{"$f":"E35+F35+G35","v":2493.61},2141.82,{"v":1.16424816277745,"d":"1.16"}]
["DN50","智能NB无线表","2人/3小时","1.5T/4小时",1787,{"$f":"315/8*6","v":236.25},{"$f":"86.84*4","v":347.36},2370.61,2023.17,{"v":1.17173050213279,"d":"1.17"}]
["DN80","远传表","4人/3.5小时","1.5T/4.5小时",2290,{"$f":"315/8*14","v":551.25},{"$f":"86.84*4.5","v":390.78},3232.03,2614.74,{"v":1.23608083404086,"d":"1.24"}]
["DN100","远传表","4人/4小时","1.5T/5小时",2480,{"$f":"315/8*16","v":630},{"$f":"86.84*5","v":434.2},{"v":3544.2,"d":"3544.20"},2922.02,{"v":1.21292804292921,"d":"1.21"}]
["DN150","远传表","5人/4.5小时","1.5T/5.5小时",3590,{"$f":"315/8*22.5","v":{"v":885.9375,"d":"885.94"}},{"$f":"86.84*5.5","v":477.62},{"v":4953.5575,"d":"4953.56"},4208.56,{"v":1.17701957439124,"d":"1.18"}]
["DN200","远传表","6人/5小时","1.5T/6小时",4750,{"$f":"315/8*30","v":1181.25},{"$f":"86.84*6","v":521.04},6452.29,5577.39,{"v":1.15686548726196,"d":"1.16"}]
["DN250","远传表","6人/5.5小时","1.5T/6.5小时",5800,{"$f":"315/8*39","v":{"v":1535.625,"d":"1535.63"}},{"$f":"86.84*6.5","v":564.46},{"v":7900.085,"d":"7900.09"},6804.53,{"v":1.16100377248686,"d":"1.16"}]
["DN300","远传表","6人/6小时","1.5T/7小时",9900,{"$f":"315/8*36","v":1417.5},{"$f":"86.84*7","v":607.88},11925.38,11125.28,{"v":1.07191729107043,"d":"1.07"}]
["备注：1、人工单价按《广州市建设工程造价管理站关于发布2021年9月份广州市建设工程价格信息及有关计价办法的通知》管\n         工单价315元/工日（8小时）计算。\n     2、机械费按《广东省市政工程综合定额2018》计算，计算结果为:694.65元/台班（8小时）。\n     3、定额标准计价按照《工程量清单项目计算规范（2013—广东）》、《广东省市政工程综合定额2018》计算。\n     4、不含围蔽费用。\n     5、拆除、复装水表所需工时及机械工时工程量由表务中心提供。\n     6、工料计价水表价格按采购合同部提供的材料采购价计算。\n     "]