{"text_format":"3","workbook":"xls","n_sheets":4,"sheets":["封面","汇总表","计算表","单位库"],"not_rendered":{"external_links":1,"defined_names":8},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"封面","index":0,"n_rows":20,"n_cols":1,"rows_kept":20,"flags":["formulas_cached_only"]}
[]
[]
[]
[]
["×××工程"]
[]
[]
[]
[]
[]
[]
["电缆工程量计算书"]
[]
[]
[]
[]
["        建设单位：×××××××"]
["        编制单位：××××××××"]
["        编  制 人："]
["        日      期：2008年1月"]

{"sheet":"汇总表","index":1,"n_rows":301,"n_cols":5,"rows_kept":301,"merged":[[0,0,0,4]],"flags":["formulas_cached_only"]}
["工程量汇总表"]
["序号","项目名称","单位","汇总量","汇总说明"]
[1,"一、10KV外电缆部分"]
[2,"高压交联电缆 YFY-JV22-8.7/15KV-3×300","m",{"v":0,"d":"0.00"}]
[3,"二、10KV配电设备部分"]
[4,"高压交联电力电缆|YJV22-8.7/15KV-3*70","m",{"v":0,"d":"0.00"}]
[5,"三、0.4KV配电设备部分","m",{"v":0,"d":"0.00"}]
[6,"低压电力电缆 YJV-1KV-4×240+1×120","m",{"v":0,"d":"0.00"}]
[7,"四、0.4KV低压出线部分（21-45#楼电缆）","m",{"v":0,"d":"0.00"}]
[8,"低压电力电缆 YJV-1KV-4×300+1×150（21-45#）","m",{"v":0,"d":"0.00"}]
[9,"低压电力电缆 YJV-1KV-4×240+1×120（21-45#）","m",{"v":0,"d":"0.00"}]
[10,"低压电力电缆 YJV-1KV-4×150+1×70（21-45#）","m",{"v":0,"d":"0.00"}]
[11,"低压电力电缆 YJV-1KV-4×95+1×50（21-45#）","m",{"v":0,"d":"0.00"}]
[12,"低压电力电缆 YJV-1KV-5×16（21-45#）","m",{"v":0,"d":"0.00"}]
[13,"五、0.4KV低压出线部分（46#楼电缆）",null,{"v":0,"d":"0.00"}]
[14,"低压电力电缆 YJV-1KV-4×240+1×120（46#）","m",{"v":0,"d":"0.00"}]
[15,"低压电力电缆 YJV-1KV-4×185+1×95（46#）","m",{"v":0,"d":"0.00"}]
[16,"低压电力电缆 YJV-1KV-4×120+1×70（46#）","m",{"v":0,"d":"0.00"}]
[17,"低压电力电缆 YJV-1KV-4×95+1×50（46#）","m",{"v":0,"d":"0.00"}]
[18,"低压电力电缆 YJV-1KV-4×70+1×35（46#）","m",{"v":0,"d":"0.00"}]
[19,"低压电力电缆 YJV-1KV-5×16（46#）","m",{"v":0,"d":"0.00"}]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]

{"sheet":"计算表","index":2,"n_rows":30,"n_cols":21,"rows_kept":30,"merged":[[0,0,0,12]],"flags":["formulas_cached_only"]}
["工程量计算表"]
["序号","项目名称","校验","计量\n单位","工程\n数量","分部数量1","分部数量2","分部数量3","分部数量4","分部数量5","分部数量6","分部数量7","分部数量8","分部数量1","分部数量2","分部数量3","分部数量4","分部数量5","分部数量6","分部数量7","分部数量8"]
[1,"一、10KV外电缆部分","√",null,null,"1#电房-A","A-B","B-C","C-2#电房","定额预留",{"$nulls":3},"","","","","","","",""]
[2,"高压交联电缆 YFY-JV22-8.7/15KV-3×300","√","m",{"v":0,"d":"0.00"},"40*1.05","80*1.05","(65+15)*1.05","40*1.05","1.5*2",{"$nulls":3},"","","","","","","",""]
[3,"二、10KV配电设备部分",{"$nulls":11},"","","","","","","",""]
[4,"预留长度：1.5+1.1+2+3+1.5*2＝10.6米",{"$nulls":3},"从G03到1B","从G04到2B","从G05到3B",{"$nulls":5},"","","","","","","",""]
[5,"高压交联电力电缆|YJV22-8.7/15KV-3*70","√","m",{"v":0,"d":"0.00"},"(10.6+20)*1.025","(10.6+26.4)*1.025","(10.6+25.6)*1.025",{"$nulls":5},"","","","","","","",""]
[6,"三、0.4KV配电设备部分","√"]
[7,"低压电力电缆 YJV-1KV-4×240+1×120","√","m",{"v":0,"d":"0.00"},"11+4.5+6","3*6","1.5*6",{"$nulls":5},"","","","","","","",""]
[8,"四、0.4KV低压出线部分（21-45#楼电缆）","√"]
[9,"一级电缆：\n1、预备长度：(3+1.5)+(2+1.5)=8米；2、从2#电房到指定电井的电缆水平长度：150米；3、从桥架到低压柜及电表箱的垂直长度：1.4+（3－1.4）＝3米；综合长度：38+150+3＝161米。",{"$nulls":3},"电表箱 AW26（26-27#楼集中计量箱）（引自P23）","电表箱 AW29（28-29#楼集中计量箱）（引自P23）","电表箱 AW31（30-31#楼集中计量箱）（引自P23）","电表箱 AW33（32-34#楼集中计量箱）（引自P26）","电表箱 AW37（37-38#楼集中计量箱）（引自P09）","电表箱 AW39（39#楼、40#楼部分集中计量箱）（引自P09）","电表箱 AW44（44-45#楼集中计量箱）（引自P12）",null,"","","","","","","",""]
[10,"低压电力电缆 YJV-1KV-4×300+1×150（21-45#）","√","m",{"v":0,"d":"0.00"},null,"(161+13.5+256)*1.025",{"$nulls":6},"","","","","","","",""]
[11,"低压电力电缆 YJV-1KV-4×240+1×120（21-45#）","√","m",{"v":0,"d":"0.00"},"(161+13.5+225)*1.025",{"$nulls":3},"(161+19.5+136)*1.025","(161+19.5+46)*1.025","(161+17.5+6)*1.025",null,"","","","","","","",""]
[12,"低压电力电缆 YJV-1KV-4×150+1×70（21-45#）","√","m",{"v":0,"d":"0.00"},null,null,"(161+13.5+213)*1.025",{"$nulls":5},"","","","","","","",""]
[13,"低压电力电缆 YJV-1KV-4×95+1×50（21-45#）","√","m",{"v":0,"d":"0.00"},{"$nulls":3},"(161+16.5+208)*1.025",{"$nulls":4},"","","","","","","",""]
[14,"\n二级电缆：\n2*2(进电箱)+1.5*2(电缆头)+1.6*2=10.2米。",{"$nulls":3},"电表箱  AW25（24-25#楼集中计量箱）","电表箱 AW22（21-23#楼集中计量箱）",null,null,"电表箱 AW35（35-36#楼集中计量箱）","电表箱 AW41（40#楼部分、41#楼集中计量箱）","电表箱 AW42（42-43#楼集中计量箱）",null,"","","","","","","",""]
[15,"低压电力电缆 YJV-1KV-4×150+1×70（21-45#）","√","m",{"v":0,"d":"0.00"},null,"(10.2+28)*1.025",null,null,"(10.2+33)*1.025",{"$nulls":3},"","","","","","","",""]
[16,"低压电力电缆 YJV-1KV-4×95+1×50（21-45#）","√","m",{"v":0,"d":"0.00"},"(10+13)*1.025",{"$nulls":4},"(10+106)*1.025","(10+103)*1.025",null,"","","","","","","",""]
[17,"\n三级电缆：\n2*2(进电箱)+1.5*2(电缆头)+1.6+1.4=10米。",{"$nulls":3},"26-27#楼户内箱；24-25#楼户内箱","28-29#楼户内箱；21-23#楼户内箱","30-31#楼户内箱","32-34#楼户内箱","37-38#楼户内箱；35-36#楼户内箱","39-40#楼户内箱；40-41#楼户内箱","44-45#楼户内箱；42-43#楼户内箱",null,"","","","","","","",""]
[18,"低压电力电缆 YJV-1KV-5×16（21-45#）","√","m",{"v":0,"d":"0.00"},"10*18+(46+38+26+20+12+18+32+38)+(41+34+20+15+25+30+44+45+59+65)","10*22+(46+40+26+20+12+19+33+34+48+54)+(55+49+35+34+20+15+25+36+51+56+70+77)","10*10+53+47+33+32+18+12+20+26+40+46","10*8+52+40+23+12+20+26+40+46","10*18+(15+21+35+41+58+64+79+85)+(102+96+82+76+59+53+39+38+23+17)","10*16+(80+74+60+59+45+40+22+16)+(91+86+55+49+35+34+20+14)","10*16+(82+71+54+47+33+32+18+12)+(87+76+59+53+38+37+23+18)",null,"","","","","","","",""]
[19,"五、0.4KV低压出线部分（46#楼电缆）",{"$nulls":11},"","","","","","","",""]
[20,"一级电缆：\n1、预备长度：(3+1.5)+(2+1.5)=8米；2、从桥架到低压柜及电表箱的垂直长度：1.7+1.4＝3.1米；综合长度：38+3.1＝11.1米。",{"$nulls":3},"电表箱 AWs-46（商铺集中计量箱）（引自P19）","电表箱 AW2（46#楼2层集中计量箱）（引自P12）","电表箱 AW8（46#楼8层集中计量箱）（引自P12）","电表箱 AW14（46#楼14层集中计量箱）（引自P18）",{"$nulls":4},"","","","","","","",""]
[21,"低压电力电缆 YJV-1KV-4×240+1×120（46#）","√","m",{"v":0,"d":"0.00"},null,"(11.1+17.5+11+(4.05+1.9))*1.025","(11.1+17.5+11+(23.8+1.9))*1.025",{"$nulls":5},"","","","","","","",""]
[22,"低压电力电缆 YJV-1KV-4×185+1×95（46#）","√","m",{"v":0,"d":"0.00"},{"$nulls":3},"(11.1+4.5+11+(43.65+1.9))*1.025",{"$nulls":4},"","","","","","","",""]
[23,"低压电力电缆 YJV-1KV-4×120+1×70（46#）","√","m",{"v":0,"d":"0.00"},"(11.1+11.5+2)*1.025",{"$nulls":7},"","","","","","","",""]
[24,"二级电缆：\n2*2(进电箱)+1.5*2(电缆头)=7米。",{"$nulls":4},"电表箱 AW5（46#楼5层集中计量箱）","电表箱 AW11（46#楼11层集中计量箱）","电表箱 AW17（46#楼17层集中计量箱）",{"$nulls":4},"","","","","","","",""]
[25,"低压电力电缆 YJV-1KV-4×95+1×50（46#）","√","m",{"v":0,"d":"0.00"},null,"(7+3.3*3)*1.025","(7+3.3*3)*1.025",{"$nulls":5},"","","","","","","",""]
[26,"低压电力电缆 YJV-1KV-4×70+1×35（46#）","√","m",{"v":0,"d":"0.00"},{"$nulls":3},"(7+3.3*3)*1.025",{"$nulls":4},"","","","","","","",""]
[27,"三级电缆：\n商铺预备：2*2(进电箱)+1.5*2(电缆头)+(5.8-1.9-1.4)+1.4=10.9米。\n住宅户内箱：2*2(进电箱)+1.5*2(电缆头)+(3.3-1.4)*2=10.8米。",{"$nulls":3},"商铺配电箱","二、五户内配电箱","八、十一户内配电箱","十四、十七户内配电箱",{"$nulls":4},"","","","","","","",""]
[28,"低压电力电缆 YJV-1KV-5×16（46#）","√","m",{"v":0,"d":"0.00"},"(10.9*8+(9+7+19+32)*2+2*8)*1.025","(10.8*16+(13+23+24+37+38+50+51+54)*2)*1.025","(10.8*16+(13+23+24+37+38+50+51+54)*2)*1.025","(10.8*13+(13+23+24+37+38+50+51+54)+(5+20+33+46+55))*1.025",{"$nulls":4},"","","","","","","",""]

{"sheet":"单位库","index":3,"n_rows":8,"n_cols":1,"rows_kept":8,"flags":["formulas_cached_only"]}
["m"]
["m²"]
["m³"]
["kg"]
["t"]
["个"]
["组"]
["套"]