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

{"sheet":"1","index":0,"n_rows":92,"n_cols":18,"rows_kept":92,"merged":[[0,0,0,17],[2,0,36,0],[2,3,35,3],[2,6,37,6],[2,9,22,9],[2,12,29,12],[2,15,12,15],[13,15,22,15],[23,9,24,9],[23,10,24,10],[23,15,33,15],[25,9,33,9],[30,12,33,12],[34,9,35,9],[34,10,35,10],[34,12,34,17],[35,13,35,17],[36,9,46,9],[36,13,36,17],[37,0,38,0],[37,3,46,3],[37,13,37,17],[38,13,38,17],[39,0,46,0],[39,13,39,17],[40,13,40,17],[41,13,41,17],[42,13,42,17],[43,13,43,17],[44,13,44,17],[45,13,45,17],[46,10,46,12],[46,13,46,17],[49,1,49,7],[50,0,50,1],[50,5,50,6],[51,0,51,1],[51,5,51,6],[54,1,54,7],[55,0,55,1],[55,2,55,3],[55,5,55,6],[56,0,56,1],[56,2,56,3],[56,5,56,6],[59,1,59,7],[60,3,60,4],[60,5,60,7],[61,3,61,4],[61,5,61,7],[65,1,65,13],[66,3,66,4],[66,5,66,13],[67,1,68,1],[67,2,68,2],[67,3,67,4],[67,5,67,13],[68,3,68,4],[68,5,68,13],[69,1,70,1],[69,2,70,2],[69,3,69,4],[69,5,69,13],[70,3,70,4],[70,5,70,13],[71,1,72,1],[71,2,72,2],[71,3,71,4],[71,5,71,13],[72,3,72,4],[72,5,72,13],[73,1,74,1],[73,2,74,2],[73,3,73,4],[73,5,73,13],[74,3,74,4],[74,5,74,13],[75,1,76,1],[75,2,76,2],[75,3,75,4],[75,5,75,13],[76,3,76,4],[76,5,76,13],[77,1,78,1],[77,2,78,2],[77,3,77,4],[77,5,77,13],[78,3,78,4],[78,5,78,13],[79,1,81,1],[79,2,81,2],[79,3,81,4],[79,5,79,13],[80,5,80,13],[81,5,81,13],[82,1,83,1],[82,2,83,2],[82,3,82,4],[82,5,82,13],[83,3,83,4],[83,5,83,13],[84,1,85,1],[84,2,85,2],[84,3,84,4],[84,5,84,13],[85,3,85,4],[85,5,85,13],[86,1,87,1],[86,2,87,2],[86,3,86,4],[86,5,86,13],[87,3,87,4],[87,5,87,13],[88,1,89,1],[88,2,89,2],[88,3,88,4],[88,5,88,13],[89,3,89,4],[89,5,89,13],[90,1,91,1],[90,2,91,2],[90,3,90,4],[90,5,90,13],[91,3,91,4],[91,5,91,13]],"flags":["formulas_cached_only"]}
["常用钢材理论重量表"]
["名称","规格","Kg/M","名称","规格","Kg/M","名称","规格","Kg/M","名称","规格","Kg/M2","名称","规格","Kg/M","名称","规格","Kg/M"]
["工字钢","工10",11.216,"槽钢","［5",{"v":5.44,"d":"5.440"},"角钢","┗25×4",1.459,"钢板","∫=1",{"v":7.85,"d":"7.850"},"H型钢","150×150×7×10",{"v":31.9,"d":"31.90"},"钢管","Dg15",{"v":1.26,"d":"1.260"}]
[null,"工12",13.987,null,"［6.3",6.634,null,"┗30×4",1.786,null,"∫=1.5",{"v":11.78,"d":"11.780"},null,"200×200×8×12",{"v":50.5,"d":"50.50"},null,"Dg20",{"v":1.63,"d":"1.630"}]
[null,"工12.6",14.223,null,"［8",8.045,null,"┗40×4",2.422,null,"∫=2",{"v":15.7,"d":"15.700"},null,"248×124×5×8",{"v":25.8,"d":"25.80"},null,"Dg25",{"v":2.42,"d":"2.420"}]
[null,"工14",{"v":16.89,"d":"16.890"},null,"［10",10.007,null,"┗50×5",{"v":3.7,"d":"3.700"},null,"∫=2.5",{"v":19.63,"d":"19.630"},null,"250×125×6×9",{"v":29.7,"d":"29.70"},null,"Dg32",{"v":3.13,"d":"3.130"}]
[null,"工16",20.513,null,"［12",12.059,null,"┗50×6",4.465,null,"∫=3",{"v":23.55,"d":"23.550"},null,"250×250×9×14",{"v":72.4,"d":"72.40"},null,"Dg40",{"v":3.84,"d":"3.840"}]
[null,"工18",24.143,null,"［12.6",12.318,null,"┗56×5",4.251,null,"∫=4",{"v":31.4,"d":"31.400"},null,"250×255×14×14",{"v":82.2,"d":"82.20"},null,"Dg50",{"v":4.88,"d":"4.880"}]
[null,"工20a",27.929,null,"［14a",14.535,null,"┗60×6",{"v":5.42,"d":"5.420"},null,"∫=5",{"v":39.25,"d":"39.250"},null,"294×200×8×12",{"v":57.3,"d":"57.30"},null,"Dg70",{"v":6.64,"d":"6.640"}]
[null,"工20b",31.069,null,"［14b",16.733,null,"┗63×5",4.822,null,"∫=6",{"v":47.1,"d":"47.100"},null,"294×302×12×12",{"v":85,"d":"85.00"},null,"Dg80",{"v":8.34,"d":"8.340"}]
[null,"工22a",{"v":33.07,"d":"33.070"},null,"［16a",{"v":17.24,"d":"17.240"},null,"┗63×6",5.721,null,"∫=8",{"v":62.8,"d":"62.800"},null,"300×150×6.5×9",{"v":37.3,"d":"37.30"},null,"Dg100",{"v":10.85,"d":"10.850"}]
[null,"工22b",36.524,null,"［16",19.752,null,"┗70×6",6.406,null,"∫=10",{"v":78.5,"d":"78.500"},null,"300×300×10×15",{"v":94.5,"d":"94.50"},null,"Dg125",{"v":15.04,"d":"15.040"}]
[null,"工24a",37.477,null,"［18a",20.174,null,"┗70×7",7.398,null,"∫=12",{"v":94.2,"d":"94.200"},null,"300×305×15×15",{"v":106,"d":"106.00"},null,"Dg150",{"v":17.81,"d":"17.810"}]
[null,"工24b",41.245,null,"［18",{"v":23,"d":"23.000"},null,"┗70×8",8.373,null,"∫=14",{"v":109.9,"d":"109.900"},null,"340×250×9×14",{"v":79.7,"d":"79.70"},"镀锌管","Dg15",{"v":1.31,"d":"1.310"}]
[null,"工25a",38.105,null,"［20a",22.637,null,"┗75×6",6.905,null,"∫=16",{"v":125.6,"d":"125.600"},null,"344×348×10×16",{"v":115,"d":"115.00"},null,"Dg20",{"v":1.7,"d":"1.700"}]
[null,"工25b",{"v":42.03,"d":"42.030"},null,"［21a",25.777,null,"┗75×8",{"v":9.03,"d":"9.030"},null,"∫=18",{"v":141.3,"d":"141.300"},null,"350×175×7×11",{"v":50,"d":"50.00"},null,"Dg25",{"v":2.53,"d":"2.530"}]
[null,"工28a",43.492,null,"［22a",24.999,null,"┗80×6",7.376,null,"∫=20",{"v":157,"d":"157.000"},null,"390×300×10×16",{"v":107,"d":"107.00"},null,"Dg32",{"v":3.27,"d":"3.270"}]
[null,"工28b",47.888,null,"［22",28.453,null,"┗80×8",9.658,null,"∫=22",{"v":172.7,"d":"172.700"},null,"396×199×7×11",{"v":56.7,"d":"56.70"},null,"Dg40",{"v":4.01,"d":"4.010"}]
[null,"工30a",48.084,null,"［24b",30.628,null,"┗80×10",11.874,null,"∫=25",{"v":196.3,"d":"196.300"},null,"400×200×8×13",{"v":66,"d":"66.00"},null,"Dg50",{"v":5.1,"d":"5.100"}]
[null,"工30b",52.794,null,"［25a",{"v":27.41,"d":"27.410"},null,"┗90×6",{"v":8.35,"d":"8.350"},null,"∫=28",{"v":219.8,"d":"219.800"},null,"440×300×11×18",{"v":124,"d":"124.00"},null,"Dg70",{"v":6.93,"d":"6.930"}]
[null,"工30c",57.504,null,"［25b",31.335,null,"┗90×8",10.946,null,"∫=30",{"v":235.5,"d":"235.500"},null,"450×200×9×14",{"v":76.5,"d":"76.50"},null,"Dg80",{"v":8.71,"d":"8.710"}]
[null,"工32a",52.717,null,"［25c",{"v":35.26,"d":"35.260"},null,"┗90×10",13.476,null,"∫=32",{"v":251.2,"d":"251.200"},null,"482×300×11×15",{"v":115,"d":"115.00"},null,"Dg100",{"v":11.34,"d":"11.340"}]
[null,"工32b",57.741,null,"［28a",31.427,null,"┗90×12",{"v":15.94,"d":"15.940"},null,"∫=36",{"v":282.6,"d":"282.600"},null,"488×300×11×18",{"v":129,"d":"129.00"},null,"Dg150",{"v":18.61,"d":"18.610"}]
[null,"工32c",62.765,null,"［28b",35.823,null,"┗100×6",9.366,"名称","规格","菱形",null,"500×200×10×16",{"v":89.6,"d":"89.60"},"螺纹钢","φ12",0.888]
[null,"工36a",60.037,null,"［28c",40.219,null,"┗100×8",12.276,null,null,"Kg/M2",null,"582×300×12×17",{"v":137,"d":"137.00"},null,"φ14",{"v":1.21,"d":"1.210"}]
[null,"工36b",65.689,null,"［30a",34.463,null,"┗100×10",{"v":15.12,"d":"15.120"},"花纹板","δ=2.5",{"v":21.6,"d":"21.600"},null,"588×300×12×20",{"v":151,"d":"151.00"},null,"φ16",{"v":1.58,"d":"1.580"}]
[null,"工36c",71.341,null,"［30b",39.173,null,"┗100×12",17.898,null,"δ=3",{"v":25.6,"d":"25.600"},null,"596×199×10×15",{"v":95.1,"d":"95.10"},null,"φ18",{"v":2,"d":"2.000"}]
[null,"工40a",67.598,null,"［30c",43.886,null,"┗110×8",13.532,null,"δ=3.5",{"v":29.5,"d":"29.500"},null,"600×200×11×17",{"v":106,"d":"106.00"},null,"φ20",{"v":2.47,"d":"2.470"}]
[null,"工40b",73.878,null,"［32a",38.088,null,"┗110×10",{"v":16.69,"d":"16.690"},null,"δ=4",{"v":33.4,"d":"33.400"},null,"700×300×13×24",{"v":185,"d":"185.00"},null,"φ22",{"v":2.98,"d":"2.980"}]
[null,"工40c",80.158,null,"［32b",43.107,null,"┗110×12",19.782,null,"∫=4.5",{"v":37.3,"d":"37.300"},null,"700×300×13×24",{"v":185,"d":"185.00"},null,"φ25",{"v":3.85,"d":"3.850"}]
[null,"工45b",87.485,null,"［32c",48.131,null,"┗125×8",15.504,null,"∫=5",{"v":42.3,"d":"42.300"},"钢轨","38K",38.73,null,"φ28",{"v":4.83,"d":"4.830"}]
[null,"工45c",{"v":94.55,"d":"94.550"},null,"［36a",47.814,null,"┗125×10",19.133,null,"∫=5.5",{"v":46.2,"d":"46.200"},null,"43K",44.65,null,"φ32",{"v":6.31,"d":"6.310"}]
[null,"工56b",115.108,null,"［36b",53.466,null,"┗125×12",22.696,null,"∫=6",{"v":50.1,"d":"50.100"},null,"50K",51.51,null,"φ36",{"v":7.99,"d":"7.990"}]
[null,"工56c",{"v":123.9,"d":"123.900"},null,"［36c",59.118,null,"┗140×10",21.488,null,"δ=8",{"v":66.8,"d":"66.800"},null,"QU80",63.69,null,"φ40",{"v":9.87,"d":"9.870"}]
[null,"工63b",131.298,null,"［40a",58.928,null,"┗140×12",25.522,"名称","规格","扁豆形","钢材理论重量简易计算方法"]
[null,"工63c",141.189,null,"［40b",65.204,null,"┗140×14",{"v":29.49,"d":"29.490"},null,null,"Kg/M2","圆钢：","每米重量（Kg）=.00617×直径×直径"]
[{"$nulls":4},"［40c",71.488,null,"┗140×16",33.393,"花纹板","δ=2.5",{"v":22.6,"d":"22.600"},"方管：","每米重量（Kg）=.00785×边宽×边宽"]
["线材","φ6.5",{"v":0.26,"d":"0.260"},"圆钢","φ25",{"v":3.85,"d":"3.850"},null,"┗160×12",29.391,null,"δ=3",{"v":26.6,"d":"26.600"},"六角钢：","每米重量（Kg）=.0068×对边直径×对边直径"]
[null,"φ8",0.395,null,"φ30",{"v":5.55,"d":"5.550"},null,"┗160×14",33.987,null,"δ=3.5",{"v":30.5,"d":"30.500"},"八角钢：","每米重量（Kg）=.0065×对边直径×对边直径"]
["圆钢","φ10",0.617,null,"φ32",{"v":6.31,"d":"6.310"},null,"┗160×16",38.518,null,"δ=4",{"v":34.4,"d":"34.400"},"螺纹钢：","每米重量（Kg）=.00617×d0直径×d0直径"]
[null,"φ12",0.888,null,"φ36",{"v":7.99,"d":"7.990"},null,"┗180×14",30.589,null,"∫=4.5",{"v":38.3,"d":"38.300"},"*角钢：","每米重量（Kg）=.00785×（边宽＋边宽－边厚）×边厚"]
[null,"φ14",{"v":1.21,"d":"1.210"},null,"φ40",{"v":9.87,"d":"9.870"},null,"┗180×16",43.542,null,"∫=5",{"v":42.3,"d":"42.300"},"扁钢：","每米重量（Kg）=.00785×厚度×边宽"]
[null,"φ16",{"v":1.58,"d":"1.580"},null,"φ42",{"v":11.99,"d":"11.990"},null,"┗180×18",48.634,null,"∫=5.5",{"v":46.2,"d":"46.200"},"无缝钢管：","每米重量（Kg）=.02466×壁厚×（外经－壁厚）"]
[null,"φ18",{"v":2,"d":"2.000"},null,"φ45",{"v":12.48,"d":"12.480"},null,"┗200×16",{"v":48.68,"d":"48.680"},null,"∫=6",{"v":50.1,"d":"50.100"},"接缝钢管：","每米重量（Kg）=.02466×壁厚×（外经－壁厚）"]
[null,"φ20",{"v":2.47,"d":"2.470"},null,"φ48",{"v":14.21,"d":"14.210"},null,"┗200×18",54.401,null,"δ=8",{"v":65.8,"d":"65.800"},"中厚钢板：","每米m2 重量（Kg）=.00785×厚度"]
[null,"φ22",{"v":2.98,"d":"2.980"},null,"φ50",{"v":15.42,"d":"15.420"},null,"┗200×20",60.056,null,"δ=8",{"v":65.8,"d":"65.800"},"薄钢板：","每米m2 重量（Kg）=.00786×厚度"]
[null,"φ24",{"v":3.55,"d":"3.550"},null,"φ56",{"v":19.3,"d":"19.300"},null,"┗200×24",71.168]
[]
[]
[null,"法兰重量公式"]
["净重(公斤)",null,"外径","内径","厚度","净重"]
[null,null,800,0,55,{"v":217.021728,"d":"217.02"},null,"（公斤）"]
[]
[]
[null,"钢管重量公式"]
["外径mm",null,"壁厚mm",null,"长度m","净重"]
[160,null,5,null,6,{"v":114.676254,"d":"114.68"},null,"（公斤）"]
[]
[]
[null,"钢板重量公式"]
[null,"长mm","宽mm","厚度mm",null,"重量（公斤）"]
[null,1000,1000,5,null,39.25]
[]
[]
[null," "]
[null,"钢材理论重量计算公式"]
[null,"名称","单位","计算公式",null,"计算举例"]
[null,"圆钢盘条","kg／m","w=0.006165×d²",null,"直径80mm的圆钢，求每米质量"]
[{"$nulls":3},"式中，d为直径(mm)",null,"每米质量=0.00617×80²kg=39.488kg"]
[null,"螺纹钢","kg／m","W=0.00617×d²",null,"断面直径为12mm的螺纹钢，求每米质量"]
[{"$nulls":3},"式中，d为断面直径(mm)",null,"每米质量=0.00617x12²kg=0.89kg"]
[null,"方钢","kg／m","W=0.00785×d²",null,"边宽30mm的方钢，求每米质量"]
[{"$nulls":3},"式中，d为边宽(MM)",null,"每米质量=0.00785×30²kg=7.07kg"]
[null,"扁钢","kg／m","W=0.00785×d×b ",null,"边宽40mm、厚5mm的扁钢，求每米质量"]
[{"$nulls":3},"式中，d为边宽(mm)b为厚(mm)",null,"每米质量=0.00785×40×5kg=1.57kg"]
[null,"六角钢","kg／m","W =0.006798×d²",null,"对边距离50mm的六角钢，求每米质量"]
[{"$nulls":3},"式中，d为对边距离(mm)",null,"每米质量=0.006798×50²kg=17kg"]
[null,"八角钢","kg／m","W=0.006798×d²",null,"对边距离80mm的八角钢，求每米质量"]
[{"$nulls":3},"式中，d为对边距离(mm)",null,"每米质量: 0.0065 x 80²kg=41.60kg"]
[null,"等边角钢","kg／m","W=0.00785×[d(2b-d)+0.215(R²一2r²)]式中，b为边宽，d为边厚，R  为内弧_半径，r为端弧半径",null,"求4mmx20mm等边角钢的每米质量"]
[{"$nulls":5},"GB9787中查出4mm×20mm等边角钢的R为3.5，r为1.2"]
[{"$nulls":5},"每米质量=0.00785×[4(2×20—4)+0.215(3.5²一2×1.2²)]kg=1.15kg"]
[null,"不等边角钢","kg／m","w=0.00785×[d(B+6一d)+0.215(R²一2 r²)]",null,"求30rnm×20mm x 4mm不等边角钢每米质量。从GB9788中查出30x 20x 4不等边角钢的R为3.5，r为1.2"]
[{"$nulls":3},"式中，B为长边宽，b为短边, 宽，d为边厚，R为内弧半径,r为端弧半径",null,"每米质量=0.00785×[4(30+20—4)+0.215(3.5²—2×1.2²)]kg  =1.46kg"]
[null,"槽钢","kg／m","w=0.00785[hd+2t(b一d)+0.349(R²一r2)]",null,"求80mm×43mm×5mm的槽钢每米质量。从GB707中查出该槽钢t为8，R为8，r为4"]
[{"$nulls":3},"式中，h为高，b为腿长，d为腰厚，t为平均腿厚，R为内弧半径，r为端弧半径",null,"每米质量=0.00785[80×5十2×8(43—5)+0.349(8²-4²)]kg=8.04kg"]
[null,"工字钢","kg／m","w=0.00785[hd+2t(b一d)+0.8584(R²一r²)]",null,"求250rnm×118mm×10mm的工字钢每米质量。从GB706中查出该工字钢t为13。R为10，r为5"]
[{"$nulls":3},"式中，h为高，b为腿长，d为腰厚，t为平均腿厚，R为内弧半径，r为端弧半径",null,"每米质量=0.00785[250×10+2×13 x(118一10)+0.8584(10²—5²)]kg=42.2kg"]
[null,"钢板","kg／m²","w=7.85×6",null,"厚度6mm的钢板，求每平方米的质量"]
[{"$nulls":3},"式中，6为厚",null,"每平方米质量=7.85×6kg=47.1kg"]
[null,"钢管(包括无缝钢管及焊接钢管)","kg／m","w=0.02466×S(D—S)",null,"外径60mm，壁厚4mm的无缝钢管，求每米质量每米质量=0.02466×4×(60-4)kg: 5.52kg"]
[{"$nulls":3},"式中，D为外径，s为壁厚"]