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

{"sheet":"封面","index":0,"n_rows":64,"n_cols":20,"rows_kept":64,"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],[28,0,29,11],[46,3,46,4],[47,3,47,4],[47,8,50,8],[47,9,50,9],[48,3,48,4],[49,3,49,4],[50,3,50,4],[52,1,53,1],[52,3,52,4],[52,5,52,6],[53,3,53,4],[53,5,53,6],[54,3,54,4],[54,5,54,6],[55,3,55,4],[55,5,55,6],[56,3,56,4],[56,5,56,6],[56,14,56,15],[57,3,57,4],[57,5,57,6],[57,14,57,15],[58,3,58,4],[58,5,58,6],[58,14,58,15],[59,3,59,4],[59,5,59,6],[59,14,59,15],[60,3,60,4],[60,5,60,6],[61,3,61,4],[61,5,61,6],[62,3,62,4],[62,5,62,6],[63,3,63,4],[63,5,63,6],[67,1,67,2],[68,1,68,2],[69,1,69,2]],"flags":["formulas_cached_only"]}
[]
[" 工 艺 文 件 "]
{"$rows_empty":8}
["共   页"]
[]
[null,null,"       名 称：HZCB200应急装配式公路钢桥交货清单"]
[]
[null,null,"       编 号：GW2023-1-21-01GY"]
[]
[]
[]
[]
[]
[{"$nulls":3},"编制：",null,"校对:",null,"审核:",null,"批准:"]
[]
["中国船舶重工集团应急预警与救援装备股份有限公司赤壁分公司"]
["2023年2月  日"]
[]
[]
[]
[]
["编制说明"]
[]
["1、本工艺根据GW2023-1十座CB200型钢桥清单编制而成。包含1座18米钢桥、5座21米钢桥、3座30米钢桥、1座45米钢桥构件。"]
[]
["2、包装要求："]
["    A、所有货物采取防潮、防震、防锈、防压等措施，适合于海运及内陆远程搬运（满足集装箱装运）。钢结构件为裸装，零散"]
["件由铁箱包装，达到出口标准。包装箱两侧面应注明发货标记（唛头）、长×宽×高、毛重、净重及编号，箱内需附有装箱单"]
["（货物名称必须是中英文的）。装箱前需提供货物照片方便现场提前办理清关手续。"]
["    B、装箱件均应照装箱件清单填写装箱单：由包装单位自制标有箱内构件清单的卡片（中英文对照）,并放在每个包装箱内。"]
["即铁箱内需放置2个装箱单。"]
["    C、采用铁箱包装及捆装件包装构件均需要制作包装唛头。铁箱包装唛头要求每个铁箱外面张贴2处（箱子前、后侧面或左、右"]
["侧面醒目位置），要求具有防水、张贴牢固（必要时采用铝牌制作并采用铆钉固定）；捆装件唛头采用A4纸制作并悬挂在构件上，"]
["A4纸制造的唛头要求过塑，悬挂要求牢靠，也可采用铁丝或扎带捆扎在构件上，每捆2处；"]
["    D、唛头制作要求：制作时要求保证唛头清晰、美观。包装箱还应喷涂放置标识，以便装卸和搬运。唛头内容按合同要求执行。"]
["    E、唛头应额外制作备份（用于运输过程中丢失的补充，满足港口交货要求）"]
["    F、架设说明书需要装在包装箱内。"]
[]
[null,null,"桥梁体积重量参考数据："]
[null,null,"序号","名称",null,"数量","单座体积m³","单座重Kg","总体积m³","总重Kg"]
[null,null,1,"18米桥",null,1,46.59,23865.58,748.4200000000001,397083.17000000004,null,null,192.02,99458.3]
[null,null,2,"21米桥",null,5,54.13,27691.3,{"$nulls":4},239.16,135302.79]
[null,null,3,"30米桥",null,3,79.72,45100.93,{"$nulls":4},270.65000000000003,138456.5]
[null,null,4,"45米桥",null,1,192.02,99458.3,{"$nulls":4},46.59,23865.58]
["2023贸1，GW2022-2唛头信息",{"$nulls":11},748.4200000000001,397083.17000000004]
[null,"序号","Province","Bridge Name",null,"Serial No.",null,"Length(m)"]
[null,null,"省名","桥名",null,"序列号",null,"桥长"]
[null,1,"待定","Emergency Bridge",null,"UPB-18-STB-0043",null,18,{"$nulls":8},"单台","单台","合计","合计"]
[null,2,"待定","Emergency Bridge",null,"UPB-21-STB-0044",null,21,{"$nulls":5},"数量",null,null,"捆装件数量","箱子数量","捆装件数量","箱子数量"]
[null,3,"待定","Emergency Bridge",null,"UPB-21-STB-0045",null,21,{"$nulls":5},1,"18米桥",null,17,1,17,1]
[null,4,"待定","Emergency Bridge",null,"UPB-21-STB-0046",null,21,{"$nulls":5},5,"21米桥",null,18,1,90,5]
[null,5,"待定","Emergency Bridge",null,"UPB-21-STB-0047",null,21,{"$nulls":5},3,"30米桥",null,32,2,96,6]
[null,6,"待定","Emergency Bridge",null,"UPB-21-STB-0048",null,21,{"$nulls":5},1,"45米桥",null,69,2,69,2]
[null,7,"待定","Emergency Bridge",null,"UPB-30-STB-0049",null,30,{"$nulls":10},272,14]
[null,8,"待定","Emergency Bridge",null,"UPB-30-STB-0050",null,30]
[null,9,"待定","Emergency Bridge",null,"UPB-30-STB-0051",null,30]
[null,10,"待定","Wara Kabu Bridge",null,"UPB-45-ENB-0052",null,45]

{"sheet":"18","index":1,"n_rows":45,"n_cols":14,"rows_kept":45,"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,8,2],[7,3,8,3],[7,4,8,4],[7,15,7,16],[7,28,7,29],[7,41,7,42],[7,54,7,55],[7,67,7,68],[7,80,7,81],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,0,14,0],[13,1,13,2],[13,5,14,5],[13,7,14,7],[13,8,14,8],[13,9,14,9],[13,10,14,10],[13,11,14,11],[13,12,14,12],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[19,0,20,12],[21,0,22,0],[21,1,22,2],[21,3,22,3],[21,4,22,4],[21,5,22,5],[21,6,21,8],[21,9,22,9],[21,10,22,10],[23,0,24,0],[23,1,24,2],[23,3,24,3],[23,4,24,4],[23,5,24,5],[23,6,24,6],[23,9,24,9],[25,0,41,0],[25,1,25,2],[25,5,41,5],[25,7,41,7],[25,8,41,8],[25,9,41,9],[25,10,41,10],[25,11,41,11],[25,12,41,12],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[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]],"flags":["formulas_cached_only"]}
["1座18.288米桥捆装件清单（总计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,24,322,2,5,1613.94,1610,"3163*2350*712",{"v":5.2923316,"d":"5.29"},{"v":10.5846632,"d":"10.58"},{"v":3227.88,"d":"3227.9"}]
["3~4","桁架 Panel-standard",null,null,322,2,7,2257.94,2254,"3163*2350*980",{"v":7.284389,"d":"7.28"},{"v":14.568778,"d":"14.57"},{"v":4515.88,"d":"4515.9"}]
[5,"超宽道横梁(5.8米)ExtreTransom-5.8m",null,7,440.3,1,4,1792.2,1761.2,"5800*800*525",{"v":2.436,"d":"2.44"},{"v":2.436,"d":"2.44"},1792.2]
[6,{"$nulls":4},1,3,1343.9,1320.9,"5800*600*525",{"v":1.827,"d":"1.83"},{"v":1.827,"d":"1.83"},1343.9]
[7,"水平支撑架TR Bracing Frame",null,12,57.4,1,12,690.3,688.8,"2376*925*560",{"v":1.230768,"d":"1.23"},{"v":1.230768,"d":"1.23"},690.3]
[8,"竖向支撑架TR Vertical Frame",null,10,37,1,10,371,370,"1776*510*560",{"v":0.5072256,"d":"0.51"},{"v":0.5072256,"d":"0.51"},{"v":371,"d":"371.0"}]
[9,"抗风拉杆 Sway Brace",null,12,43,1,12,533,516,"5076*425*260",{"v":0.560898,"d":"0.56"},{"v":0.560898,"d":"0.56"},{"v":533,"d":"533.0"}]
[10,"竖向风构 Vertical Brace",null,12,15,1,12,180.5,180,"3001*270*190",{"v":0.1539513,"d":"0.15"},{"v":0.1539513,"d":"0.15"},180.5]
["11~12","阴头端柱Post-End-Female",null,4,89,2,2,343.5,332,"2629*432*370",{"v":0.42021936000000004,"d":"0.42"},{"v":0.8404387200000001,"d":"0.84"},{"v":687,"d":"687.00"}]
[null,"阳头端柱Post-End-Male",null,4,77,null,2]
["13~15","桥面板146 Deck-146",null,24,385,3,8,3084.3,3080,"3040*1260*1050",{"v":4.021920000000001,"d":"4.02"},{"v":12.065760000000001,"d":"12.07"},{"v":9252.900000000001,"d":"9252.90"}]
[16,"路缘 Kerb",null,12,26,1,12,332.8,312,"3040*536*340",{"v":0.5540096000000001,"d":"0.55"},{"v":0.5540096000000001,"d":"0.55"},{"v":332.8,"d":"332.80"}]
[17,"加隙板4.2m Deck Eob Filler4.2m",null,2,69,1,2,140.3,138,"4200*332*97",{"v":0.1352568,"d":"0.14"},{"v":0.1352568,"d":"0.14"},{"v":140.3,"d":"140.30"}]
[]
["1座18.288米桥装箱件清单（总计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)"]
[18,"桁架销 Penal Pin",null,59,3,1,59,797.9200000000001,677.9200000000001,"1280*880*1000",{"v":1.1264,"d":"1.13"},{"v":1.1264,"d":"1.13"},{"v":797.9200000000001,"d":"797.9"}]
[null,"保险卡环 Safety Pin",null,59,0.03,null,59]
[null,"联系梁TR Tie Beam",null,4,5.3,null,4]
[null,"支座  Bearing",null,8,13.4,null,8]
[null,"支座板 Baseplate",null,8,13,null,8]
[null,"加隙板螺栓Deck Eob Filler Bolt",null,17,0.35,null,17,{"$nulls":6},"M20×60"]
[null,"撑架螺栓 Brace Bolt",null,130,0.5,null,130]
[null,"螺纹板 Nut-Deck-Clamp",null,118,0.4,null,118]
[null,"横梁螺栓Transom Bolt",null,29,0.8,null,29]
[null,"地脚螺栓 螺母 平垫圈 Bastplate Bolt",null,17,2,null,17]
[null,"拉杆螺栓Swaybrace Bolt",null,25,0.6,null,25]
[null,"风构螺栓Vertical Brace Bolt",null,38,0.5,null,38]
[null,"螺母M24 NutM24",null,222,"/",null,222]
[null,"螺母M20 NutM20",null,63,"/",null,63]
[null,"弹垫20  Washer",null,118,"/",null,118]
[null,"桥面板螺栓 Deck Screw  ",null,101,0.35,null,101]
[null,"路缘螺栓 Kerb-Bolt",null,63,0.35,null,63]
[]
[{"$nulls":10},"单桥总重量",null,{"v":23865.58,"d":"23865.6"}]
[{"$nulls":10},"单桥总体积",null,{"v":46.591149220000005,"d":"46.59"}]

{"sheet":"21","index":2,"n_rows":47,"n_cols":14,"rows_kept":47,"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,9,8,9],[7,10,8,10],[7,11,8,11],[7,12,8,12],[8,1,8,2],[9,1,9,2],[9,21,9,22],[9,34,9,35],[9,47,9,48],[9,60,9,61],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,0,15,0],[14,1,14,2],[14,5,15,5],[14,7,15,7],[14,8,15,8],[14,9,15,9],[14,10,15,10],[14,11,15,11],[14,12,15,12],[15,1,15,2],[16,1,16,2],[16,3,17,3],[17,1,17,2],[18,1,18,2],[19,1,19,2],[21,0,22,12],[23,0,24,0],[23,1,24,2],[23,3,24,3],[23,4,24,4],[23,5,24,5],[23,6,23,8],[23,9,24,9],[23,10,24,10],[25,0,26,0],[25,1,26,2],[25,3,26,3],[25,4,26,4],[25,5,26,5],[25,6,26,6],[25,9,26,9],[27,0,43,0],[27,1,27,2],[27,5,43,5],[27,7,43,7],[27,8,43,8],[27,9,43,9],[27,10,43,10],[27,11,43,11],[27,12,43,12],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[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]],"flags":["formulas_cached_only"]}
["1座21.336米桥捆装件清单（总计5座）"]
["箱号","构件名称",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,"桁架 Panel-standard",null,20,322,1,5,1613.94,1610,"3163*2350*712",{"v":5.2923316,"d":"5.29"},{"v":5.2923316,"d":"5.29"},{"v":1613.94,"d":"1613.9"}]
["2~3","桁架 Panel-standard",null,null,322,2,7,2257.94,2254,"3163*2350*980",{"v":7.284389,"d":"7.28"},{"v":14.568778,"d":"14.57"},{"v":4515.88,"d":"4515.9"}]
[4,"桁架 Panel-standard",null,null,322,1,1,3029.94,322,"3163*2350*1296",{"v":9.6332328,"d":"9.63"},{"v":9.6332328,"d":"9.63"},{"v":3029.94,"d":"3029.9"}]
[null,"高剪桁架 High shear panel",null,8,338,null,8,null,2704]
["5~6","超宽道横梁(5.8米)ExtreTransom-5.8m",null,8,440.3,2,4,1792.2,1761.2,"5800*800*525",{"v":2.436,"d":"2.44"},{"v":4.872,"d":"4.87"},3584.4]
[7,"水平支撑架TR Bracing Frame",null,14,57.4,1,14,805.1,803.6,"2376*1100*560",{"v":1.463616,"d":"1.46"},{"v":1.463616,"d":"1.46"},805.1]
[8,"竖向支撑架TR Vertical Frame",null,12,37,1,12,445,444,"1776*610*560",{"v":0.6066816000000002,"d":"0.61"},{"v":0.6066816000000002,"d":"0.61"},{"v":445,"d":"445.0"}]
[9,"抗风拉杆 Sway Brace",null,14,43,1,14,619,602,"5076*425*300",{"v":0.6471899999999999,"d":"0.65"},{"v":0.6471899999999999,"d":"0.65"},{"v":619,"d":"619.0"}]
[10,"竖向风构 Vertical Brace",null,14,15,1,14,210.5,210,"3001*270*200",{"v":0.16205400000000003,"d":"0.16"},{"v":0.16205400000000003,"d":"0.16"},210.5]
["11~12","阴头端柱Post-End-Female",null,4,89,2,2,343.5,332,"2629*432*370",{"v":0.42021936000000004,"d":"0.42"},{"v":0.8404387200000001,"d":"0.84"},{"v":687,"d":"687.00"}]
[null,"阳头端柱Post-End-Male",null,4,77,null,2]
["13~15","桥面板146 Deck-146",null,28,385,3,8,3084.3,3080,"3040*1260*1050",{"v":4.021920000000001,"d":"4.02"},{"v":12.065760000000001,"d":"12.07"},{"v":9252.900000000001,"d":"9252.90"}]
[16,"桥面板146 Deck-146",null,null,385,1,4,1544.3,1540,"3040*665*1050",{"v":2.1226800000000003,"d":"2.12"},{"v":2.1226800000000003,"d":"2.12"},{"v":1544.3,"d":"1544.30"},"外形尺寸已核对"]
[17,"路缘 Kerb",null,14,26,1,14,384.8,364,"3040*536*365",{"v":0.5947456000000001,"d":"0.59"},{"v":0.5947456000000001,"d":"0.59"},{"v":384.8,"d":"384.80"}]
[18,"加隙板4.2m Deck Eob Filler4.2m",null,2,69,1,2,140.3,138,"4200*332*97",{"v":0.1352568,"d":"0.14"},{"v":0.1352568,"d":"0.14"},{"v":140.3,"d":"140.30"}]
[]
["1座21.336米桥装箱件清单（总计5座）"]
[]
["箱号","构件名称",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)"]
[19,"桁架销 Penal Pin",null,67,3,1,67,858.2599999999999,738.2599999999999,"1280*880*1000",{"v":1.1264,"d":"1.13"},{"v":1.1264,"d":"1.13"},{"v":858.2599999999999,"d":"858.3"}]
[null,"保险卡环 Safety Pin",null,67,0.03,null,67]
[null,"联系梁TR Tie Beam",null,4,5.3,null,4]
[null,"支座  Bearing",null,8,13.4,null,8]
[null,"支座板 Baseplate",null,8,13,null,8]
[null,"加隙板螺栓Deck Eob Filler Bolt",null,17,0.35,null,17]
[null,"撑架螺栓 Brace Bolt",null,151,0.5,null,151]
[null,"螺纹板 Nut-Deck-Clamp",null,134,0.4,null,134]
[null,"横梁螺栓Transom Bolt",null,34,0.8,null,34]
[null,"地脚螺栓 螺母 平垫圈 Bastplate Bolt",null,17,2,null,17]
[null,"拉杆螺栓Swaybrace Bolt",null,29,0.6,null,29]
[null,"风构螺栓Vertical Brace Bolt",null,44,0.5,null,44]
[null,"螺母M24 NutM24",null,258,"/",null,258]
[null,"螺母M20 NutM20",null,74,"/",null,74]
[null,"弹垫20  Washer",null,135,"/",null,135]
[null,"桥面板螺栓 Deck Screw  ",null,118,0.35,null,118]
[null,"路缘螺栓 Kerb-Bolt",null,74,0.35,null,74]
[]
[{"$nulls":10},"单桥总重量",null,{"v":27691.32,"d":"27691.3"}]
[{"$nulls":10},"单桥总体积",null,{"v":54.13116512000001,"d":"54.13"}]

{"sheet":"30","index":3,"n_rows":49,"n_cols":14,"rows_kept":49,"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,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],[22,0,23,12],[24,0,25,0],[24,1,25,2],[24,3,25,3],[24,4,25,4],[24,5,25,5],[24,6,24,8],[24,9,25,9],[24,10,25,10],[26,0,27,0],[26,1,27,2],[26,3,27,3],[26,4,27,4],[26,5,27,5],[26,6,27,6],[26,9,27,9],[28,0,29,0],[28,1,28,2],[28,5,29,5],[28,7,29,7],[28,8,29,8],[28,9,29,9],[28,10,29,10],[28,11,29,11],[28,12,29,12],[29,1,29,2],[30,0,45,0],[30,1,30,2],[30,5,45,5],[30,7,45,7],[30,8,45,8],[30,9,45,9],[30,10,45,10],[30,11,45,11],[30,12,45,12],[31,1,31,2],[32,1,32,2],[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]],"flags":["formulas_cached_only"]}
["1座30.48米桥捆装件清单（总计3座）"]
["箱号","构件名称",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,322,"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,null,2704]
["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,440.3,2,4,1792.2,1761.2,"5800*800*525",{"v":2.436,"d":"2.44"},{"v":4.872,"d":"4.87"},3584.4]
[17,{"$nulls":4},1,3,1343.9,1320.9,"5800*590*525",{"v":1.7965499999999999,"d":"1.80"},{"v":1.7965499999999999,"d":"1.80"},1343.9]
["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,385,5,8,3086.3,3080,"3040*1260*1050",{"v":4.021920000000001,"d":"4.02"},{"v":20.109600000000004,"d":"20.11"},{"v":15431.5,"d":"15431.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米桥装箱件清单（总计3座）"]
[]
["箱号","构件名称",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":45100.93,"d":"45100.9"}]
[{"$nulls":10},"单桥总体积",null,{"v":79.72467974,"d":"79.72"}]

{"sheet":"45","index":4,"n_rows":50,"n_cols":14,"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,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],[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],[18,1,18,2],[19,1,19,2],[21,0,22,12],[23,0,24,0],[23,1,24,2],[23,3,24,3],[23,4,24,4],[23,5,24,5],[23,6,23,8],[23,9,24,9],[23,10,24,10],[25,0,26,0],[25,1,26,2],[25,3,26,3],[25,4,26,4],[25,5,26,5],[25,6,26,6],[25,9,26,9],[27,0,29,0],[27,1,27,2],[27,5,29,5],[27,7,29,7],[27,8,29,8],[27,9,29,9],[27,10,29,10],[27,11,29,11],[27,12,29,12],[28,1,28,2],[29,1,29,2],[30,0,46,0],[30,1,30,2],[30,5,46,5],[30,7,46,7],[30,8,46,8],[30,9,46,9],[30,10,46,10],[30,11,46,11],[30,12,46,12],[31,1,31,2],[32,1,32,2],[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座45米桥捆装件清单（总计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","水平支撑架TR 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","竖向支撑架TR 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~67","桥面板146 Deck-146",null,60,385,10,6,2316.3,2310,"3040*965*1050",{"v":3.0802799999999997,"d":"3.08"},{"v":30.802799999999998,"d":"30.80"},{"v":23163,"d":"23163.00"},"外形尺寸已核对"]
["68","路缘 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"}]
["69","加隙板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米桥装箱件清单（总计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)"]
[70,"桁架销 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"},{"v":1546.15,"d":"1546.2"}]
[null,"无头桁架销Headless Penal Pin",null,235,3,null,235]
[null,"保险卡环 Safety Pin",null,705,0.03,null,705]
[71,"弦杆螺栓Chord  Reinforcement  Bolt",null,874,0.98,1,874,{"v":2344.02,"d":"2344"},{"v":2154.02,"d":"2154"},"1580*1290*1020",{"v":2.0789640000000005,"d":"2.08"},{"v":2.0789640000000005,"d":"2.08"},{"v":2344.02,"d":"2344.0"}]
[null,"联系梁TR 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,571,0.5,null,571]
[null,"水平撑架螺栓 Brace Bolt",null,67,0.8,null,67]
[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":99458.27,"d":"99458.3"}]
[{"$nulls":10},"单桥总体积",null,{"v":192.01847308,"d":"192.02"}]