{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["2020年全区海绵城市建设目标完成情况表","2019年海绵城市建设计划"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"2020年全区海绵城市建设目标完成情况表","index":0,"n_rows":28,"n_cols":11,"rows_kept":28,"merged":[[1,0,2,7],[26,1,26,7],[27,1,27,7]]}
["附件4"]
["2020年广西海绵城市建设目标完成情况表"]
[]
["序号","城市","2019年建成区面积（k㎡）","2019年已实现海绵面积（k㎡）","2020年计划新增海绵面积（k㎡）","2020年底合计完成海绵面积（k㎡）","2020年建成区海绵城市目标完成率（%）","备注"]
[1,"南宁市",319.69,{"v":54.6,"d":"54.60"},{"v":9.967,"d":"9.97"},{"$f":"D5+E5","v":{"v":64.56700000000001,"d":"64.57"}},{"$f":"F5/C5*100","v":{"v":20.196753104570057,"d":"20.20"}},{"$nulls":3},"未上报2020年工作计划"]
[2,"柳州市",240.23,36.05,13.45,{"v":49.5,"d":"49.50"},{"$f":"F6/C6*100","v":{"v":20.605253298921866,"d":"20.61"}},{"$nulls":3},"已上报2020年计划但不能支撑今年目标"]
[3,"桂林市",128.13,11.89,0.43,12.32,{"v":9.615234527433076,"d":"9.62"},"不能完成今年目标"]
[4,"梧州市",66.34,9.32,{"v":4.091,"d":"4.09"},{"v":13.411000000000001,"d":"13.41"},{"v":20.215556225504976,"d":"20.22"}]
[5,"北海市",85.97,{"v":18,"d":"18.00"},{"v":0,"d":"0.00"},{"v":18,"d":"18.00"},{"v":20.937536349889495,"d":"20.94"}]
[6,"防城港市",50.73,{"v":10.2,"d":"10.20"},{"v":0.194,"d":"0.19"},{"v":10.394,"d":"10.39"},{"v":20.488862605953088,"d":"20.49"}]
[7,"钦州市",90.51,{"v":11.4,"d":"11.40"},{"v":6.7,"d":"6.70"},{"v":18.1,"d":"18.10"},{"v":19.99779029941443,"d":"20.00"}]
[8,"贵港市",86.09,{"v":7.491,"d":"7.49"},10.48,{"v":17.971,"d":"17.97"},{"v":20.87466604715995,"d":"20.87"}]
[9,"玉林市",{"v":76.5,"d":"76.50"},{"v":10.5,"d":"10.50"},{"v":0,"d":"0.00"},{"v":10.5,"d":"10.50"},{"v":13.725490196078432,"d":"13.73"},"不能完成今年目标"]
[10,"百色市",55.32,5.33,{"v":0,"d":"0.00"},5.33,{"v":9.634851771511208,"d":"9.63"},"不能完成今年目标"]
[11,"贺州市",54.74,8.76,2.19,10.95,{"v":20.00365363536719,"d":"20.00"}]
[12,"河池市",{"v":26.5,"d":"26.50"},2.51,2.79,{"v":5.3,"d":"5.30"},{"v":20,"d":"20.00"}]
[13,"来宾市",51.92,{"v":5.169,"d":"5.17"},{"v":5.233,"d":"5.23"},{"v":10.402,"d":"10.40"},{"v":20.034668721109398,"d":"20.03"}]
[14,"崇左市",{"v":38,"d":"38.00"},3.67,3.99,7.66,{"v":20.157894736842106,"d":"20.16"}]
[15,"岑溪市",{"v":22.6,"d":"22.60"},{"v":2.6,"d":"2.60"},{"v":0,"d":"0.00"},{"v":2.6,"d":"2.60"},{"v":11.504424778761061,"d":"11.50"},"不能完成今年目标"]
[16,"东兴市",{"v":13.3,"d":"13.30"},{"v":2.468,"d":"2.47"},{"v":0.2,"d":"0.20"},{"v":2.668,"d":"2.67"},{"v":20.060150375939852,"d":"20.06"}]
[17,"桂平市",{"v":37.6,"d":"37.60"},null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"未上报"]
[18,"北流市",{"v":28.7,"d":"28.70"},null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"未上报"]
[19,"合山市",7.54,{"v":0,"d":"0.00"},0.07,0.07,{"v":0.9283819628647216,"d":"0.93"},"未上报"]
[20,"凭祥市",13.11,{"v":2.578,"d":"2.58"},{"v":0.097,"d":"0.10"},{"v":2.675,"d":"2.68"},{"v":20.404271548436306,"d":"20.40"}]
[21,"靖西市",{"v":20,"d":"20.00"},2.34,{"v":0,"d":"0.00"},2.34,{"v":11.7,"d":"11.70"},"不能完成今年目标"]
[22,"宜州市",18.39,{"v":0,"d":"0.00"},{"v":0.276,"d":"0.28"},{"v":0.276,"d":"0.28"},{"v":1.500815660685155,"d":"1.50"},"现河池市宜州区，宜州市16年撤市设区，尚在过渡期中，暂按县级市单独考核，不能完成今年目标"]
["备注：","1.2020年计划新增海绵面积需与2020年广西海绵城市建设计划表（附件3）对应，并且需确保是2020年12月31日前能完成的项目。"]
[null,"2.请各市认真核对附件3和附件4并及时反馈，有修改的地方请标红，并将可编辑的电子版原表于8月20日前反馈至我厅城建处。"]

{"sheet":"2019年海绵城市建设计划","index":1,"n_rows":18,"n_cols":10,"rows_kept":18,"hidden":true,"merged":[[0,0,1,9]]}
["2019年全区海绵城市建设计划及完成表"]
[]
["序号","城市","建成区面积（k㎡）","2019年已实现海绵面积（k㎡）","计划新增海绵面积（k㎡）","计划2020年完成海绵面积（k㎡）","2020年底合计完成海绵面积（k㎡）","2020年建成区海绵完成率（%）","按计划建成区海绵完成率（%）","备注"]
[1,"南宁市",{"v":289.3,"d":"289.300"},{"v":51.9,"d":"51.900"},14.465,{"$f":"E4","v":14.465},{"$f":"D4+F4","v":66.365},{"$f":"G4/C4*100","v":{"v":22.939854821984095,"d":"22.940"}},{"$f":"(E4+D4)/C4*100","v":{"v":22.939854821984095,"d":"22.940"}}]
[2,"柳州市",{"v":225.09,"d":"225.090"},{"v":25.19,"d":"25.190"},{"v":11.25,"d":"11.250"},{"v":1.04,"d":"1.040"},{"$f":"D5+F5","v":{"v":26.23,"d":"26.230"}},{"$f":"G5/C5*100","v":{"v":11.653116531165312,"d":"11.653"}},{"$f":"(E5+D5)/C5*100","v":{"v":16.18907992358612,"d":"16.189"}}]
[3,"桂林市",{"v":110.27,"d":"110.270"},{"v":11.89,"d":"11.890"},{"v":4.65,"d":"4.650"},null,{"$f":"D6+F6","v":{"v":11.89,"d":"11.890"}},{"v":10.782624467216833,"d":"10.783"},{"v":14.999546567516099,"d":"15.000"}]
[4,"梧州市",{"v":57.19,"d":"57.190"},{"v":5.73,"d":"5.730"},{"v":2.85,"d":"2.850"},{"v":0.0466,"d":"0.047"},{"v":5.7766,"d":"5.777"},{"v":10.100716908550448,"d":"10.101"},{"v":15.002622836160167,"d":"15.003"}]
[5,"北海市",{"v":77.26,"d":"77.260"},{"v":8.59,"d":"8.590"},{"v":3,"d":"3.000"},{"v":0,"d":"0.000"},{"v":8.59,"d":"8.590"},{"v":11.11830183794978,"d":"11.118"},{"v":15.001294330830959,"d":"15.001"}]
[6,"防城港市",{"v":41.38,"d":"41.380"},{"v":4.23,"d":"4.230"},{"v":1.98,"d":"1.980"},{"v":0,"d":"0.000"},{"v":4.23,"d":"4.230"},{"v":10.222329627839537,"d":"10.222"},{"v":15.007249879168683,"d":"15.007"}]
[7,"钦州市",{"v":90.51,"d":"90.510"},{"v":10.88,"d":"10.880"},{"v":4.5,"d":"4.500"},{"$f":"E10","v":{"v":4.5,"d":"4.500"}},{"v":15.38,"d":"15.380"},{"v":16.992597503038336,"d":"16.993"},{"v":16.992597503038336,"d":"16.993"}]
[8,"贵港市",{"v":73.23,"d":"73.230"},{"v":7.49,"d":"7.490"},{"v":3.6,"d":"3.600"},{"v":7.498999999999999,"d":"7.499"},{"$f":"D11+F11","v":{"v":14.988999999999999,"d":"14.989"}},{"$f":"G11/C11*100","v":{"v":20.468387272975555,"d":"20.468"}},{"v":15.144066639355454,"d":"15.144"}]
[9,"玉林市",{"v":70.1,"d":"70.100"},{"v":7.1,"d":"7.100"},{"v":3.5,"d":"3.500"},{"v":0,"d":"0.000"},{"$f":"D12+F12","v":{"v":7.1,"d":"7.100"}},{"$f":"G12/C12*100","v":{"v":10.128388017118404,"d":"10.128"}},{"v":15.121255349500714,"d":"15.121"}]
[10,"百色市",{"v":49.08,"d":"49.080"},{"v":5.33,"d":"5.330"},{"v":2.45,"d":"2.450"},{"v":0,"d":"0.000"},{"$f":"D13+F13","v":{"v":5.33,"d":"5.330"}},{"$f":"G13/C13*100","v":{"v":10.859820700896496,"d":"10.860"}},{"v":15.851670741646293,"d":"15.852"}]
[11,"贺州市",{"v":31.43,"d":"31.430"},{"v":3.2,"d":"3.200"},{"v":1.51,"d":"1.510"},{"$f":"E14","v":{"v":1.51,"d":"1.510"}},{"$f":"D14+F14","v":{"v":4.71,"d":"4.710"}},{"$f":"G14/C14*100","v":{"v":14.985682468978684,"d":"14.986"}},{"v":14.985682468978684,"d":"14.986"}]
[12,"河池市",{"v":23.8,"d":"23.800"},{"v":2.51,"d":"2.510"},{"v":1.19,"d":"1.190"},0.026,{"$f":"D15+F15","v":{"v":2.5359999999999996,"d":"2.536"}},{"$f":"G15/C15*100","v":{"v":10.655462184873947,"d":"10.655"}},{"v":15.546218487394956,"d":"15.546"},"建议建成区面积不含宜州区"]
[13,"来宾市",{"v":43.1,"d":"43.100"},{"v":4.37,"d":"4.370"},{"v":2.1,"d":"2.100"},null,{"v":4.37,"d":"4.370"},{"v":10.139211136890951,"d":"10.139"},{"v":15.011600928074248,"d":"15.012"}]
[14,"崇左市",{"v":35,"d":"35.000"},{"v":3.67,"d":"3.670"},{"v":1.58,"d":"1.580"},{"v":0.52792,"d":"0.528"},{"$f":"D17+F17","v":{"v":4.19792,"d":"4.198"}},{"$f":"G17/C17*100","v":{"v":11.994057142857143,"d":"11.994"}},{"v":15,"d":"15.000"}]
[null,null,{"$f":"SUM(C4:C17)","v":{"v":1216.7399999999998,"d":"1216.740"}},{"$f":"SUM(D4:D17)","v":{"v":152.07999999999998,"d":"152.080"}},{"$f":"SUM(E4:E17)","v":58.625}]