{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["1","2"],"not_rendered":{"external_links":1,"defined_names":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"1","index":0,"n_rows":37,"n_cols":12,"rows_kept":37,"merged":[[0,0,0,11],[2,2,2,4],[2,5,2,7],[2,8,2,10],[3,2,3,4],[3,5,3,7],[3,8,3,10],[4,2,4,4],[4,5,4,7],[4,8,4,10],[5,2,5,4],[5,5,5,7],[5,8,5,10],[6,2,6,4],[6,5,6,7],[6,8,6,10],[7,2,7,4],[7,5,7,7],[7,8,7,10],[8,2,8,4],[8,5,8,7],[8,8,8,10],[9,2,9,4],[9,5,9,7],[9,8,9,10],[10,2,10,4],[10,5,10,7],[10,8,10,10],[11,2,11,4],[11,5,11,7],[11,8,11,10],[12,2,12,4],[12,5,12,7],[12,8,12,10],[13,2,13,4],[13,5,13,7],[13,8,13,10],[14,2,14,4],[14,5,14,7],[14,8,14,10],[15,2,15,4],[15,5,15,7],[15,8,15,10],[16,2,16,4],[16,5,16,7],[16,8,16,10],[17,2,17,4],[17,5,17,7],[17,8,17,10],[18,2,18,4],[18,5,18,7],[18,8,18,10],[19,2,19,4],[19,5,19,7],[19,8,19,10],[20,2,20,4],[20,5,20,7],[20,8,20,10],[21,2,21,4],[21,5,21,7],[21,8,21,10],[22,2,22,4],[22,5,22,7],[22,8,22,10],[23,2,23,4],[23,5,23,7],[23,8,23,10],[24,2,24,4],[24,5,24,7],[24,8,24,10],[25,2,25,4],[25,5,25,7],[25,8,25,10],[26,2,26,4],[26,5,26,7],[26,8,26,10],[27,2,27,4],[27,5,27,7],[27,8,27,10],[28,2,28,4],[28,5,28,7],[28,8,28,10],[29,2,29,4],[29,5,29,7],[29,8,29,10],[30,2,30,4],[30,5,30,7],[30,8,30,10],[31,2,31,4],[31,5,31,7],[31,8,31,10],[32,2,32,4],[32,5,32,7],[32,8,32,10],[33,2,33,4],[33,5,33,7],[33,8,33,10],[34,2,34,4],[34,5,34,7],[34,8,34,10],[35,2,35,4],[35,5,35,7],[35,8,35,10]],"flags":["formulas_cached_only"]}
["城镇供水企业基本情况表"]
["企业名称：雅安市雨城区水务投资有限公司"]
["项目名称","行次及关系","2017年",null,null,"2018年",null,null,"2019年",null,null,"备注"]
["一、企业财务情况",1]
["（一）资产（元）","2=3+4",{"v":77995017.59,"d":"77,995,017.59"},null,null,{"v":78097875.73,"d":"78,097,875.73"},null,null,{"v":143509340.85999998,"d":"143,509,340.86"}]
["  1、流动资产",3,{"v":76893619.78,"d":"76,893,619.78"},null,null,{"v":76996477.92,"d":"76,996,477.92"},null,null,{"v":142397001.39,"d":"142,397,001.39"}]
["  2、非流动资产",4,{"v":1101397.81,"d":"1,101,397.81"},null,null,{"v":1101397.81,"d":"1,101,397.81"},null,null,{"v":1112339.47,"d":"1,112,339.47"}]
["    其中：固定资产",5,{"v":35869049.71,"d":"35,869,049.71"},null,null,{"v":35869049.71,"d":"35,869,049.71"},null,null,{"v":35869049.71,"d":"35,869,049.71"}]
["（二）负债（元）","6=7+8",{"v":51627041.32,"d":"51,627,041.32"},null,null,{"v":52546687.6,"d":"52,546,687.60"},null,null,{"v":117598000.99,"d":"117,598,000.99"}]
["  1、流动负债",7,{"v":32574784,"d":"32,574,784.00"},null,null,{"v":15994430.28,"d":"15,994,430.28"},null,null,{"v":66395743.67,"d":"66,395,743.67"}]
["  2、非流动负债",8,{"v":19052257.32,"d":"19,052,257.32"},null,null,{"v":36552257.32,"d":"36,552,257.32"},null,null,{"v":51202257.32,"d":"51,202,257.32"}]
["（三）所有者权益（元）",9,{"v":26367976.27,"d":"26,367,976.27"},null,null,{"v":25551188.13,"d":"25,551,188.13"},null,null,{"v":25911339.87,"d":"25,911,339.87"}]
["（四）主营业务损益（元）",10]
["  1、主营业务收入",11,{"v":57382.52,"d":"57,382.52"},null,null,{"v":383796.15,"d":"383,796.15"},null,null,{"v":252120.86,"d":"252,120.86"}]
["  2、主营业务成本",12,{"v":91168.08,"d":"91,168.08"},null,null,{"v":527299.16,"d":"527,299.16"},null,null,{"v":1059676.56,"d":"1,059,676.56"}]
["  3、期间费用",13,{"v":507831.3,"d":"507,831.30"},null,null,{"v":668069.38,"d":"668,069.38"},null,null,{"v":422104.73,"d":"422,104.73"}]
["  4、主营业务税金及附加",14,{"v":25,"d":"25.00"},null,null,{"v":13590.11,"d":"13,590.11"},null,null,{"v":38813.36,"d":"38,813.36"}]
["  5、主营业务净利润","15=11-12-13-14",{"v":-541641.86,"d":"-541,641.86"},null,null,{"v":-825162.5,"d":"-825,162.50"},null,null,{"v":-1268473.79,"d":"-1,268,473.79"}]
["  6、主营业务净资产利润率","16=15/9*100",-2.05,null,null,-3.23,null,null,{"v":-4.9,"d":"-4.90"}]
["（五）其他业务利润（元）","17=18-19",{"v":14563.11,"d":"14,563.11"},null,null,{"v":6582.52,"d":"6,582.52"},null,null,{"v":1664665,"d":"1,664,665.00"}]
["  1、其他业务收入",18,{"v":14563.11,"d":"14,563.11"},null,null,{"v":6582.52,"d":"6,582.52"},null,null,{"v":1664665,"d":"1,664,665.00"}]
["  2、其他业务支出",19]
["二、供水与销售（m³）",20]
["  1、年供水总量",21,{"v":954788.46,"d":"954,788.46"},null,null,{"v":920109.02,"d":"920,109.02"},null,null,{"v":1311805.69,"d":"1,311,805.69"}]
["  2、年售水总量",22,{"v":57382.52,"d":"57,382.52"},null,null,{"v":383796.15,"d":"383,796.15"},null,null,{"v":252120.86,"d":"252,120.86"}]
["  3、设计日综合生产能力（m³/日）",23,{"v":7200,"d":"7,200.00"},null,null,{"v":7200,"d":"7,200.00"},null,null,{"v":7200,"d":"7,200.00"}]
["  4、实际日综合生产能力（M3/日）",24,{"v":2615.86,"d":"2,615.86"},null,null,{"v":383796.15,"d":"383,796.15"},null,null,{"v":252120.86,"d":"252,120.86"}]
["  5、高日供水量（M3/日）",25]
["  6、年销售收入（元）",26,{"v":57382.52,"d":"57,382.52"},null,null,{"v":383796.15,"d":"383,796.15"},null,null,{"v":252120.86,"d":"252,120.86"}]
["  7、供水价格（元/m³）",27,{"v":1,"d":"1.00"},null,null,{"v":1,"d":"1.00"},null,null,{"v":1,"d":"1.00"}]
["  8、居民用水按户抄表的水量",28,{"v":57382.52,"d":"57,382.52"},null,null,{"v":383796.15,"d":"383,796.15"},null,null,{"v":252120.86,"d":"252,120.86"}]
["  9、居民按户抄表的水量占居民用水总量率（%）",29,100,null,null,100,null,null,100]
["三、人员及工资情况",30]
["  1、企业定员数量（人）",31,8,null,null,17,null,null,17]
["  2、实有人员数量（人）",32,8,null,null,17,null,null,17]
["  3、年职工平均工资、津贴、补贴（元）",33,{"v":56955.6,"d":"56,955.60"},null,null,47346.19,null,null,42345.89]
[{"$nulls":6},"填表日期："]

{"sheet":"2","index":1,"n_rows":30,"n_cols":6,"rows_kept":30,"merged":[[0,0,0,5]],"flags":["formulas_cached_only"]}
["城镇供水成本费用表"]
["企业名称：雅安市雨城区水务投资有限公司"]
["项目名称","行次及关系","2017年","2018年","2019年","备注"]
["一、供水总成本（元）","1=2+11+17",{"v":2116555.92,"d":"2,116,555.92"},{"v":2764823.57,"d":"2,764,823.57"},{"v":3535034.65,"d":"3,535,034.65"}]
["（一）制水成本(元)","2=sum(3:8)",{"v":822195.84,"d":"822,195.84"},{"v":1225577.4,"d":"1,225,577.40"},{"v":1360924.99,"d":"1,360,924.99"}]
["1、原水费",3,{"v":88588.62,"d":"88,588.62"},{"v":85370.94,"d":"85,370.94"},{"v":121713.93,"d":"121,713.93"}]
["2、原材料费",4,{"v":304616.54,"d":"304,616.54"},{"v":289155.21,"d":"289,155.21"},{"v":419641.71,"d":"419,641.71"}]
["3、动力费                        ",5,{"v":2000,"d":"2,000.00"},{"v":10393.71,"d":"10,393.71"},{"v":18249.16,"d":"18,249.16"}]
["4、外购成品水费",6]
["5、修理费",7,{"v":10237,"d":"10,237.00"},{"v":75925.5,"d":"75,925.50"},{"v":7744,"d":"7,744.00"}]
["6、制水环节职工薪酬",8,{"v":60751.08,"d":"60,751.08"},{"v":408729.45,"d":"408,729.45"},{"v":437573.6,"d":"437,573.60"}]
["7、制水环节固定资产折旧",9,{"v":356002.6,"d":"356,002.60"},{"v":356002.6,"d":"356,002.60"},{"v":356002.6,"d":"356,002.60"}]
["8、其他制水费用",10]
["（二）输配成本(元)","11=sum(12:16)",{"v":786528.79,"d":"786,528.79"},{"v":871176.79,"d":"871,176.79"},{"v":1752004.93,"d":"1,752,004.93"}]
["1、输配环节职工薪酬",12,null,{"v":15397,"d":"15,397.00"},{"v":13663,"d":"13,663.00"}]
["2、输配环节固定资产折旧",13,{"v":786528.79,"d":"786,528.79"},{"v":786528.79,"d":"786,528.79"},{"v":786528.79,"d":"786,528.79"}]
["3、动力费",14,null,{"v":1506,"d":"1,506.00"}]
["4、修理费",15]
["5、其他输配费用",16]
["（三）期间费用(元)","17=18+19+20",{"v":507831.3,"d":"507,831.30"},{"v":668069.38,"d":"668,069.38"},{"v":422104.73,"d":"422,104.73"}]
["1、管理费用",18,{"v":572204.44,"d":"572,204.44"},{"v":584423.23,"d":"584,423.23"},{"v":352465.86,"d":"352,465.86"}]
["2、销售费用",19]
["3、财务费用",20,{"v":-64373.14,"d":"-64,373.14"},{"v":83646.15,"d":"83,646.15"},{"v":69638.87,"d":"69,638.87"}]
["二、水量及差率",21]
["1.年供水总量（m³）",22,{"v":954788.46,"d":"954,788.46"},{"v":920109.02,"d":"920,109.02"},{"v":1311805.69,"d":"1,311,805.69"}]
["2.年售水总量（m³）",23,{"v":57382.52,"d":"57,382.52"},{"v":383796.15,"d":"383,796.15"},{"v":252120.86,"d":"252,120.86"}]
["3.产销差率（%）","24=100-23/22*100",93.99,58.29,{"v":81,"d":"81.00"}]
["4.管网漏损率（%）",25,93.99,58.29,{"v":81,"d":"81.00"}]
["三、单位供水成本(元/m³)","26=1/22/(1-25/100)",36.89,{"v":7.2,"d":"7.20"},19.37]
[{"$nulls":3},"填表日期："]