{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["封面","30","45"],"not_rendered":{"external_links":3,"defined_names":7},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"封面","index":0,"n_rows":89,"n_cols":10,"rows_kept":89,"merged":[[1,0,6,11],[10,0,10,11],[12,2,12,11],[14,2,14,10],[16,3,16,10],[22,0,22,11],[23,0,23,11],[27,0,28,11],[49,2,49,3],[53,2,53,3],[54,2,54,3],[54,7,55,7],[54,8,55,8],[55,2,55,3],[76,1,77,1],[76,3,76,4],[76,5,76,6],[77,3,77,4],[77,5,77,6],[78,3,78,4],[78,5,78,6],[79,3,79,4],[79,5,79,6],[80,3,80,4],[80,5,80,6],[81,3,81,4],[81,5,81,6],[82,3,82,4],[82,5,82,6],[83,3,83,4],[83,5,83,6],[84,3,84,4],[84,5,84,6],[85,3,85,4],[85,5,85,6],[86,3,86,4],[86,5,86,6],[87,3,87,4],[87,5,87,6],[88,3,88,4],[88,5,88,6]],"flags":["formulas_cached_only"]}
[]
[" 工 艺 文 件 "]
{"$rows_empty":8}
["共   页"]
[]
[null,null,"       名 称：HZCB200应急装配式公路钢桥交货清单"]
[]
[null,null,"       编 号：GW2023-2-21-01GY"]
[]
[]
[]
[]
[]
[{"$nulls":3},"编制：",null,"校对:",null,"审核:",null,"批准:"]
[]
["湖北华舟应急装备科技有限公司"]
["2023-05-22"]
[]
[]
[]
["编制说明"]
[]
["1、本工艺根据公司工号GW2023-2  总计10座CB200型钢桥清单编制而成。包含9座30米、1座45米钢桥；"]
["   架设说明书需要装在包装箱内。分桥包装。不同桥梁采用不同颜色唛头。"]
[]
["2、包装要求："]
["    A、所有货物采取防潮、防震、防锈、防压等措施，适合于海运及内陆远程搬运（满足集装箱装运）。钢结构件为裸装，零散"]
["件由铁箱包装，达到出口标准。包装箱两侧面应注明发货标记（唛头）、长×宽×高、毛重、净重及编号，箱内需附有装箱单"]
["（货物名称必须是中英文的）。装箱前需提供货物照片方便现场提前办理清关手续。"]
["    B、装箱件均应照装箱件清单填写装箱单：由包装单位自制标有箱内构件清单的卡片（中英文对照）,并放在每个包装箱内。"]
["即铁箱内需放置2个装箱单。"]
["    C、采用铁箱包装及捆装件包装构件均需要制作包装唛头。铁箱包装唛头要求每个铁箱外面张贴2处（箱子前、后侧面或左、右"]
["侧面醒目位置），要求具有防水、张贴牢固（必要时采用铝牌制作并采用铆钉固定）；捆装件唛头采用A4纸制作并悬挂在构件上，"]
["A4纸制造的唛头要求过塑，悬挂要求牢靠，也可采用铁丝或扎带捆扎在构件上，每捆2处；"]
["    D、唛头制作要求：制作时要求保证唛头清晰、美观。包装箱还应喷涂放置标识，以便装卸和搬运。唛头内容按合同要求执行。"]
["    E、唛头应额外制作备份（用于运输过程中丢失的补充，满足港口交货要求）"]
["    F、架设说明书等交货文件需要装在包装箱内。无要求时，放入最后一个铁质包装箱内。"]
["    G、桥头标示牌在产品镀锌后用抽芯铆钉（规格4*20）固定到阴阳头端柱中部120mmx120mm钢板上（每座桥1件阴头端柱"]
["及1件阳头端柱需固定桥牌），固定桥牌时应注意方向。"]
[]
[]
[]
[]
[]
[]
[null,"桥梁体积重量参考数据："]
[null,"序号","名称",null,"数量","体积m³","单重Kg","总体积m³","总重Kg"]
[null,1,"30.48米桥",null,9,79.72,45156.6,{"v":908.64,"d":"908.6"},506435]
[null,2,"45.72米桥",null,1,191.16,100025.6]
{"$rows_empty":19}
[null,"2022贸4，GW2022-2唛头信息"]
[null,"序号","Province","Bridge Name",null,"Serial No",null,"Length (m)","Shipping Time"]
[null,null,"省名","桥名",null,"序列号",null,"桥长","发运时间"]
[null,1,"Enga","EMERGENCY BRIDGE",null,"UPB-21-ENG-0038",null,21,"Sep.,2022"]
[null,2,"Hela","EMERGENCY BRIDGE",null,"UPB-21-HLA-0039",null,21,"Sep.,2022"]
[null,3,"Morobe","EMERGENCY BRIDGE",null,"UPB-21-MRB-0040",null,21,"Sep.,2022"]
[null,4,"Jiwaka","EMERGENCY BRIDGE",null,"UPB-21-JWK-0041",null,21,"Sep.,2022"]
[null,5,"EHP","EMERGENCY BRIDGE",null,"UPB-21-EHP-0042",null,21,"Sep.,2022"]
[null,6,"Gulf","EMERGENCY BRIDGE",null,"UPB-30-GLF-0033",null,30,"Sep.,2022"]
[null,7,"CENTRAL","EMERGENCY BRIDGE",null,"UPB-30-CNT-0034",null,30,"Sep.,2022"]
[null,8,"Milne Bay","EMERGENCY BRIDGE",null,"UPB-30-MLB-0035",null,30,"Sep.,2022"]
[null,9,"WHP","EMERGENCY BRIDGE",null,"UPB-30-WHP-0036",null,30,"Sep.,2022"]
[null,10,"EHP","EMERGENCY BRIDGE",null,"UPB-30-EHP-0037",null,30,"Sep.,2022"]
[null,11,"Enga","EMERGENCY BRIDGE",null,"UPB-45-ENG-0032",null,45,"Sep.,2022"]

{"sheet":"30","index":1,"n_rows":50,"n_cols":13,"rows_kept":50,"merged":[[0,0,0,12],[1,0,2,0],[1,1,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,1,8],[1,9,2,9],[1,10,2,10],[3,0,4,0],[3,1,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,9,4,9],[5,1,5,2],[5,3,7,3],[6,1,6,2],[7,0,8,0],[7,1,7,2],[7,5,8,5],[7,7,8,7],[7,8,8,8],[7,9,8,9],[7,10,8,10],[7,11,8,11],[7,12,8,12],[8,1,8,2],[9,1,9,2],[10,1,11,2],[10,3,11,3],[10,4,11,4],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,0,17,0],[16,1,16,2],[16,5,17,5],[16,7,17,7],[16,8,17,8],[16,9,17,9],[16,10,17,10],[16,11,17,11],[16,12,17,12],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[24,0,25,12],[26,0,27,0],[26,1,27,2],[26,3,27,3],[26,4,27,4],[26,5,27,5],[26,6,26,8],[26,9,27,9],[26,10,27,10],[28,0,29,0],[28,1,29,2],[28,3,29,3],[28,4,29,4],[28,5,29,5],[28,6,29,6],[28,9,29,9],[30,0,31,0],[30,1,30,2],[30,5,31,5],[30,7,31,7],[30,8,31,8],[30,9,31,9],[30,10,31,10],[30,11,31,11],[30,12,31,12],[31,1,31,2],[32,0,47,0],[32,1,32,2],[32,5,47,5],[32,7,47,7],[32,8,47,8],[32,9,47,9],[32,10,47,10],[32,11,47,11],[32,12,47,12],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,1,47,2]],"flags":["formulas_cached_only"]}
["1座30.48米桥捆装件清单（总计9座）"]
["箱号","构件名称",null,"数量","单件重量","箱数","每箱Each case",null,null,"外形尺寸","单箱体积","小计体积","小计重量"]
[{"$nulls":6},"件数","毛重","净重",null,null,"Total","Total"]
["No.","Name  component",null,"Qty","Kg/piece","Cases","pieces","G.W.","N.W.","Overall Size","Vol. of  ","Volume","Weights"]
[{"$nulls":7},"(Kg)","(Kg)",null,"each  case","(m3)","(Kg)"]
["1~2","桁架 Panel-standard",null,32,322,2,5,1613.9,1610,"3163*2350*712",{"v":5.2923316,"d":"5.29"},{"v":10.5846632,"d":"10.58"},3227.8]
["3~5","桁架 Panel-standard",null,null,322,3,7,2259.2,2254,"3163*2350*980",{"v":7.284389,"d":"7.28"},{"v":21.853167,"d":"21.85"},{"v":6777.599999999999,"d":"6777.6"}]
["6","桁架 Panel-standard",null,null,322,1,1,3032.7,3026,"3163*2350*1296",{"v":9.6332328,"d":"9.63"},{"v":9.6332328,"d":"9.63"},3032.7]
[null,"高剪桁架 High shear panel",null,8,338,null,8]
["7~14","加强弦杆 Chord Reinforcement",null,64,89,8,8,715.7,712,"3163*800*176",{"v":0.44535040000000004,"d":"0.45"},{"v":3.5628032000000003,"d":"3.56"},5725.6]
["15~16","超宽道横梁(5.8米)ExtreTransom-5.8m",null,11,409,2,4,1667,1636,"5800*800*525",{"v":2.436,"d":"2.44"},{"v":4.872,"d":"4.87"},{"v":3334,"d":"3334.0"}]
["17",{"$nulls":4},1,3,1250,1227,"5800*590*525",{"v":1.7965499999999999,"d":"1.80"},{"v":1.7965499999999999,"d":"1.80"},{"v":1250,"d":"1250.0"}]
["18~19","水平支撑架TR Bracing Frame",null,20,57.4,2,10,576.7,574,"2376*770*560",{"v":1.0245312000000002,"d":"1.02"},{"v":2.0490624000000004,"d":"2.05"},1153.4]
["20~21","竖向支撑架TR Vertical Frame",null,18,37,2,9,334.7,333,"1776*450*560",{"v":0.44755200000000006,"d":"0.45"},{"v":0.8951040000000001,"d":"0.90"},669.4]
["22","抗风拉杆 Sway Brace",null,20,43,1,20,877,860,"5076*340*430",{"v":0.7421112,"d":"0.74"},{"v":0.7421112,"d":"0.74"},{"v":877,"d":"877.0"}]
["23","竖向风构 Vertical Brace",null,20,15,1,20,307.1,300,"3001*270*230",{"v":0.18636210000000003,"d":"0.19"},{"v":0.18636210000000003,"d":"0.19"},307.1]
["24~25","阴头端柱Post-End-Female",null,4,89,2,2,342.5,332,"2629*432*390",{"v":0.44293392000000004,"d":"0.44"},{"v":0.8858678400000001,"d":"0.89"},{"v":685,"d":"685.00"}]
[null,"阳头端柱Post-End-Male",null,4,77,null,2]
["26~30","桥面板146 Deck-146",null,40,395,5,8,3166.3,3160,"3040*1260*1050",{"v":4.021920000000001,"d":"4.02"},{"v":20.109600000000004,"d":"20.11"},{"v":15831.5,"d":"15831.50"}]
["31","路缘 Kerb",null,20,26,1,20,535.9,520,"3040*536*430",{"v":0.7006592,"d":"0.70"},{"v":0.7006592,"d":"0.70"},{"v":535.9,"d":"535.90"}]
["32","加隙板4.2m Deck Eob Filler4.2m",null,2,69,1,2,139.3,138,"4200*332*97",{"v":0.1352568,"d":"0.14"},{"v":0.1352568,"d":"0.14"},{"v":139.3,"d":"139.30"}]
[]
[]
[]
["1座30.48米桥装箱件清单（总计9座）"]
[]
["箱号","构件名称",null,"数量","单件重量","箱数","每箱Each case",null,null,"外形尺寸","单箱体积","小计体积","小计重量"]
[{"$nulls":6},"件数","毛重","净重",null,null,"Total","Total"]
["No.","Name  component",null,"Qty","Kg/piece","Cases","pieces","G.W.","N.W.","Overall Size","Vol. of  ","Volume","Weights"]
[{"$nulls":7},"(Kg)","(Kg)",null,"each  case","(m3)","(Kg)"]
[33,"桁架销 Penal Pin",null,152,3,1,152,575.56,460.56,"1200*720*685",{"v":0.59184,"d":"0.59"},{"v":0.59184,"d":"0.59"},{"v":575.56,"d":"575.6"}]
[null,"保险卡环 Safety Pin",null,152,0.03,null,152]
[34,"联系梁TR Tie Beam",null,4,5.3,1,4,1034.77,896.77,"1280*880*1000",{"v":1.1264,"d":"1.13"},{"v":1.1264,"d":"1.13"},{"v":1034.77,"d":"1034.8"}]
[null,"支座  Bearing",null,8,13.4,null,8]
[null,"支座板 Baseplate",null,8,13,null,8]
[null,"弦杆螺栓Chord  Reinforcement  Bolt",null,269,0.98,null,269]
[null,"加隙板螺栓Deck Eob Filler Bolt",null,17,0.35,null,17]
[null,"撑架螺栓 Brace Bolt",null,214,0.5,null,214]
[null,"螺纹板 Nut-Deck-Clamp",null,185,0.35,null,185]
[null,"横梁螺栓Transom Bolt",null,46,0.8,null,46]
[null,"地脚螺栓 螺母 平垫圈 Bastplate Bolt",null,17,2,null,17]
[null,"拉杆螺栓Swaybrace Bolt",null,42,0.6,null,42]
[null,"风构螺栓Vertical Brace Bolt",null,63,0.5,null,63]
[null,"螺母M24 NutM24",null,634,"/",null,634]
[null,"螺母M20 NutM20",null,105,"/",null,105]
[null,"弹垫20  Washer",null,185,"/",null,185]
[null,"桥面板螺栓 Deck Screw  ",null,168,0.35,null,168]
[null,"路缘螺栓 Kerb-Bolt",null,105,0.35,null,105]
[{"$nulls":10},"单桥总重量",null,{"v":45156.63,"d":"45156.6"}]
[{"$nulls":10},"单桥总体积",null,{"v":79.72467974,"d":"79.72"}]

{"sheet":"45","index":2,"n_rows":52,"n_cols":13,"rows_kept":52,"merged":[[0,0,0,12],[1,0,2,0],[1,1,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,1,8],[1,9,2,9],[1,10,2,10],[3,0,4,0],[3,1,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,9,4,9],[5,1,5,2],[5,3,6,3],[6,1,6,2],[7,1,7,2],[7,3,8,3],[8,1,8,2],[9,1,9,2],[10,1,10,2],[10,15,10,16],[10,28,10,29],[10,41,10,42],[10,54,10,55],[10,67,10,68],[10,80,10,81],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,0,16,0],[15,1,15,2],[15,5,16,5],[15,7,16,7],[15,8,16,8],[15,9,16,9],[15,10,16,10],[15,11,16,11],[15,12,16,12],[16,1,16,2],[17,1,17,2],[17,3,18,3],[18,1,18,2],[19,1,19,2],[20,1,20,2],[25,0,26,12],[27,0,28,0],[27,1,28,2],[27,3,28,3],[27,4,28,4],[27,5,28,5],[27,6,27,8],[27,9,28,9],[27,10,28,10],[29,0,30,0],[29,1,30,2],[29,3,30,3],[29,4,30,4],[29,5,30,5],[29,6,30,6],[29,9,30,9],[31,0,33,0],[31,1,31,2],[31,5,33,5],[31,7,33,7],[31,8,33,8],[31,9,33,9],[31,10,33,10],[31,11,33,11],[31,12,33,12],[32,1,32,2],[33,1,33,2],[34,0,49,0],[34,1,34,2],[34,5,49,5],[34,7,49,7],[34,8,49,8],[34,9,49,9],[34,10,49,10],[34,11,49,11],[34,12,49,12],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,1,47,2],[48,1,48,2],[49,1,49,2]],"flags":["formulas_cached_only"]}
["1座45.72米桥捆装件清单（总计1座）"]
["箱号","构件名称",null,"数量","单件重量","箱数","每箱Each case",null,null,"外形尺寸","单箱体积","小计体积","小计重量"]
[{"$nulls":6},"件数","毛重","净重",null,null,"Total","Total"]
["No.","Name  component",null,"Qty","Kg/piece","Cases","pieces","G.W.","N.W.","Overall Size","Vol. of  ","Volume","Weights"]
[{"$nulls":7},"(Kg)","(Kg)",null,"each  case","(m3)","(Kg)"]
["1~2","桁架 Panel-standard",null,88,322,2,9,2904.5,2898,"3163*2350*1248",{"v":9.2764464,"d":"9.28"},{"v":18.5528928,"d":"18.55"},{"v":5809,"d":"5809.0"}]
["3~12","桁架 Panel-standard",null,null,322,10,7,2259.2,2254,"3163*2350*980",{"v":7.284389,"d":"7.28"},{"v":72.84389,"d":"72.84"},{"v":22592,"d":"22592.0"}]
["13~14","高剪桁架 High shear panel",null,32,338,2,9,3048.7,3042,"3163*2350*1296",{"v":9.6332328,"d":"9.63"},{"v":19.2664656,"d":"19.27"},6097.4]
["15~16","高剪桁架 High shear panel",null,null,338,2,7,2371.3,2366,"3163*2350*1016",{"v":7.5519788,"d":"7.55"},{"v":15.1039576,"d":"15.10"},4742.6]
["17~42","加强弦杆 Chord Reinforcement",null,208,89,26,8,715.7,712,"3163*800*176",{"v":0.44535040000000004,"d":"0.45"},{"v":11.579110400000001,"d":"11.58"},18608.2]
["43~46","超宽道横梁(6.2米)ExtreTransom-6.2m",null,16,440.3,4,4,1792.2,1761.2,"6200*800*525",{"v":2.604,"d":"2.60"},{"v":10.416,"d":"10.42"},7168.8]
["47~49","水平支撑架QR Bracing Frame",null,30,69,3,10,692.7,690,"2376*770*810",{"v":1.4819112,"d":"1.48"},{"v":4.4457336000000005,"d":"4.45"},{"v":2078.1000000000004,"d":"2078.1"}]
["50~51","竖向支撑架QR Vertical Frame",null,28,43.8,2,14,614.9,613.1999999999999,"1776*810*710",{"v":1.0213775999999999,"d":"1.02"},{"v":2.0427551999999998,"d":"2.04"},1229.8]
["52","抗风拉杆 Sway Brace",null,30,43,1,30,1309.9,1290,"5076*380*510",{"v":0.9837288,"d":"0.98"},{"v":0.9837288,"d":"0.98"},1309.9]
["53","竖向风构 Vertical Brace",null,30,15,1,30,459.3,450,"3001*370*260",{"v":0.28869619999999996,"d":"0.29"},{"v":0.28869619999999996,"d":"0.29"},459.3]
["54~57","阴头端柱Post-End-Female",null,8,89,4,2,342.5,332,"2629*432*390",{"v":0.44293392000000004,"d":"0.44"},{"v":1.7717356800000001,"d":"1.77"},{"v":1370,"d":"1370.00"}]
[null,"阳头端柱Post-End-Male",null,8,77,null,2]
["58~59","桥面板146 Deck-146",null,60,395,2,6,2376.3,2370,"3040*910*1050",{"v":2.90472,"d":"2.90"},{"v":5.80944,"d":"5.81"},{"v":4752.6,"d":"4752.60"}]
["60~65","桥面板146 Deck-146",null,null,395,6,8,3166.3,3160,"3040*1260*1050",{"v":4.021920000000001,"d":"4.02"},{"v":24.131520000000002,"d":"24.13"},{"v":18997.800000000003,"d":"18997.80"}]
["66","路缘 Kerb",null,30,26,1,30,800.7,780,"3040*756*485",{"v":1.1146463999999998,"d":"1.11"},{"v":1.1146463999999998,"d":"1.11"},{"v":800.7,"d":"800.70"}]
["67","加隙板4.2m Deck Eob Filler4.2m",null,2,69,1,2,139.3,138,"4200*332*97",{"v":0.1352568,"d":"0.14"},{"v":0.1352568,"d":"0.14"},{"v":139.3,"d":"139.30"}]
[]
[]
[]
[]
["1座45.72米桥装箱件清单（总计1座）"]
[]
["箱号","构件名称",null,"数量","单件重量","箱数","每箱Each case",null,null,"外形尺寸","单箱体积","小计体积","小计重量"]
[{"$nulls":6},"件数","毛重","净重",null,null,"Total","Total"]
["No.","Name  component",null,"Qty","Kg/piece","Cases","pieces","G.W.","N.W.","Overall Size","Vol. of  ","Volume","Weights"]
[{"$nulls":7},"(Kg)","(Kg)",null,"each  case","(m3)","(Kg)"]
[68,"桁架销 Penal Pin",null,235,3,1,235,1546.15,1431.15,"1200*720*685",{"v":0.59184,"d":"0.59"},{"v":0.59184,"d":"0.59"},1546.15]
[null,"桁架销 Penal Pin",null,235,3,null,235]
[null,"保险卡环 Safety Pin",null,705,0.03,null,705]
[69,"弦杆螺栓Chord  Reinforcement  Bolt",null,874,0.98,1,874,2323.92,2133.92,"1580*1290*1020",{"v":2.0789640000000005,"d":"2.08"},{"v":2.0789640000000005,"d":"2.08"},{"v":2323.92,"d":"2323.9"}]
[null,"联系梁QR Tie Beam",null,4,7.6,null,4]
[null,"支座  Bearing",null,16,13.4,null,16]
[null,"支座板 Baseplate",null,16,13,null,16]
[null,"加隙板螺栓Deck Eob Filler Bolt",null,17,0.35,null,17]
[null,"撑架螺栓 Brace Bolt",null,638,0.5,null,638]
[null,"螺纹板 Nut-Deck-Clamp",null,270,0.35,null,270]
[null,"横梁螺栓Transom Bolt",null,135,0.8,null,135]
[null,"地脚螺栓 螺母 平垫圈 Bastplate Bolt",null,34,2,null,34]
[null,"拉杆螺栓Swaybrace Bolt",null,63,0.6,null,63]
[null,"风构螺栓Vertical Brace Bolt",null,95,0.5,null,95]
[null,"螺母M24 NutM24",null,1805,"/",null,1805]
[null,"螺母M20 NutM20",null,159,"/",null,159]
[null,"弹垫20  Washer",null,269,"/",null,269]
[null,"桥面板螺栓 Deck Screw  ",null,252,0.35,null,252]
[null,"路缘螺栓 Kerb-Bolt",null,159,0.35,null,159]
[{"$nulls":10},"单桥总重量",null,{"v":100025.57,"d":"100025.6"}]
[{"$nulls":10},"单桥总体积",null,{"v":191.15663308,"d":"191.16"}]