钢材理论重量及价格计算表

1、常常用用钢钢材材理理论论重重量量计计算算公公式式1. 无缝钢管：每米重量=（外径-臂厚）臂厚0.024662. 螺旋焊管计算方法与无缝钢管相同，双面焊每米另加0.5kg3. 钢板（或扁钢）：钢板重量（kg） =长（m）宽（m）厚（mm）7.854. 花纹板：花纹板重量（kg） =长（m）宽（m）每平米理重5. 圆钢、螺纹钢：每米重量(kg)=直径（cm）直径（cm）0.6176. 矩形管公式 是： （长+宽）20.00785 厚度 米数7. 方管的计算公式是： 边长40.00785 厚度 米数8. 热镀锌角钢理论重量的计算公式是：角钢理论重量1.069. 热镀锌槽钢理论重量的计算公式是：槽钢理

2、论重量1.0610. 热镀锌工字钢理论重量的计算公式是：工字钢理论重量1.0611. 热镀锌方管理论重量的计算公式是：方管理论重量1.0612.不等边角钢理重计算：W(kg/m)=0.00785*边厚*（长边宽+短边宽边厚）边长系数厚度米数重量750.00785358.86.7824产产品品名名称称材材料料名名称称型型号号规规格格比比重重比比重重单单位位数数量量单单位位重重量量单单价价钢板中板539.25kg/54.362,133.634250钢板中板1078.6kg/18.121,424.234300钢板中板16125.6kg/3.08386.324680钢板薄板17.85kg/2.9823

3、.37155等边角钢4#40*40*42.422kg/m12.00m29.064150等边角钢5#50*50*53.77kg/m270.00m1,017.904150槽钢20#B200*75*925.777kg/m114.00m2,938.584200无缝管60+60*3.54.88kg/m24.00m117.124700无缝管300+325*1077.68kg/m6.00m466.085600H型钢（HW）HW250*250 HW250*250*9*1472.4kg/m36.00m2,606.404550H型钢（HM）HM400*300 HM390*300*10*16107kg/m12.00

4、m1,284.004550方管50*50*450*50*45.74kg/m6.00m34.44140方管70*70*570*70*510.2kg/m6.00m61.20165无缝管30+32*84.74kg/m6.00m28.4468-570.53012,550.77“基数数据”工作表中的数据共分为三组，其结构和要求如下：1、每组数据的第一列只用于排序，各组数据中不能有空行，一级数据和二级数据中不能有重复。2、二级数据所属一级数据 和 三级数据所属二级数据 中相同的数据应确保连续。所定义的名称如下：Me=INDIRECT(RC,0)Data1=OFFSET(基数数据!$B$1,1,0,COUN

5、TA(基数数据!$B:$B)-1)Data2=OFFSET(基数数据!$F$1,1,0,COUNTA(基数数据!$F:$F)-1)Data3=OFFSET(基数数据!$K$1,1,0,COUNTA(基数数据!$K:$K)-1)Data12=OFFSET(基数数据!$E$1,1,0,COUNTA(基数数据!$E:$E)-1)Data23=OFFSET(基数数据!$J$1,1,0,COUNTA(基数数据!$J:$J)-1)List1=Data1List2=OFFSET(基数数据!$F$1,MATCH(Me,Data12,0),0,COUNTIF(Data12,Me)List3=OFFSET(基数数

6、据!$K$1,MATCH(Me,Data23,0),0,COUNTIF(Data23,Me)List=IF(NOT(ISNA(MATCH(Me,Data1,0),List2,IF(NOT(ISNA(MATCH(Me,Data2,0),List3,List1)各名称的含义说明：Me：当前的单元格，使用的是“R1C1”引用样式Data1、Data2、Data3：一、二、三级数据的全部数据Data12、Data23：二级数据所属的一级数据、三级数据所属的二级数据List1、List2、List3：根据当前单元格的实际内容所对应的一、二、三级菜单List：根据当前单元格的内容实际出现的菜单如果希望是在

7、相邻的三个单元格里显示分级菜单，应再定义如下：LeftCellLeftCellList1A=Data1List2A=OFFSET(基数数据!$F$1,MATCH(LeftCell,Data12,0),0,COUNTIF(Data12,LeftCell)List3A=OFFSET(基数数据!$K$1,MATCH(LeftCell,Data23,0),0,COUNTIF(Data23,LeftCell)说明：1、在定义第二列、第三列数据有效性时会提示有错误，这是因为其左边的单元格为空，不用理会，直接确定即可2、由于数据是针对同一单元格设计的，如在三个单元格里显示分级菜单，则显的很冗余，请根据实际使

8、用情况进行修改金金额额长长宽宽件件数数数数量量9,067.939069.51.571.516654.366,124.206114.6-9.601.516218.121,807.981806.48-1.501.821.6913.07583.62155151.381.222.4412.9768120.62120.35-0.27612124,224.294224.70.41614527012,342.0312343.81.776119114550.46549.9-0.56614242,610.052105.6-504.45611611,859.1211857.3-1.821213365,842.20

9、5842.2-1211124.82611610.1061161.936116-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0序序号号材材料料名名称称序序号号材材料料名名称称型型号号序序号号1001001H型钢（HM）1001001H型钢（HM）HM100*5010010011002001H型钢（HW）1001002H型钢（HM）HM125*6010010021003001 不等边角钢1001003H型钢（HM）HM150*10010010031004001 槽钢1001004H型钢（HM）HM150*751

10、0010041005001 等边角钢1001005H型钢（HM）HM175*9010010051006001 方管1001006H型钢（HM）HM200*10010010061007001 钢板1001008H型钢（HM）HM200*15010010071008001 工字钢1001009H型钢（HM）HM250*12510010081009001 花纹板1001011H型钢（HM）HM250*17510010091010001 螺纹钢1001012H型钢（HM）HM300*15010010101011001 无缝管1001014H型钢（HM）HM300*20010010111013001 圆

11、钢1001015H型钢（HM）HM350*17510010121001017H型钢（HM）HM350*25010010131001018H型钢（HM）HM400*15010010141001019H型钢（HM）HM400*20010010151001021H型钢（HM）HM400*30010010161001022H型钢（HM）HM450*15010010171001023H型钢（HM）HM450*20010010181001025H型钢（HM）HM450*30010010191001026H型钢（HM）HM500*15010010201001027H型钢（HM）HM500*200100102

12、11001030H型钢（HM）HM500*30010010221001032H型钢（HM）HM600*20010010231001035H型钢（HM）HM600*30010010241001038H型钢（HM）HM700*30010010251001040H型钢（HM）HM800*30010010261001042H型钢（HM）HM900*30010010271002001H型钢（HW）HW200*20010010281002003H型钢（HW）HW250*25010010291002005H型钢（HW）HW300*30010010301002008H型钢（HW）HW350*350100103

13、11002010H型钢（HW）HW400*40010010321003001 不等边角钢L14/910010331003004 不等边角钢L16/1010010341003008 不等边角钢L18/1110010351003012 不等边角钢L20/12.510010361004001 槽钢10#10010371004002 槽钢12#10010381004003 槽钢12.6#10010391004004 槽钢14#A10010401004005 槽钢14#B10010411004006 槽钢16#A10010421004007 槽钢16#B10010431004008 槽钢18#A1001

14、0441004009 槽钢18#B10020011004010 槽钢20#A10020021004011 槽钢20#B10020031004012 槽钢22#A10020041004013 槽钢22#B10020051004014 槽钢24#A10020061004015 槽钢24#B10020071004016 槽钢25#A10020081004017 槽钢25#B10020091004018 槽钢27#A10020101004019 槽钢27#B10020111004020 槽钢28#A10020121004021 槽钢28#B10020131004022 槽钢30#A1002014100

15、4023 槽钢30#B10020151004024 槽钢32#A10020161004025 槽钢32#B10020171004026 槽钢36#A10030011004027 槽钢36#B10030021004028 槽钢40#A10030031004029 槽钢40#B10030041004030 槽钢5#10030051004031 槽钢6.3#10030061004032 槽钢6.5#10030071004033 槽钢8#10030081005001 等边角钢2#10030091005003 等边角钢2.5#10030101005005 等边角钢3#10030111005007 等边角

16、钢3.6#10030121005010 等边角钢4#10030131005013 等边角钢4.5#10030141005017 等边角钢5#10030151005021 等边角钢5.6#10040011005025 等边角钢6.3#10040021005030 等边角钢7#10040031005035 等边角钢7.5#10040041005040 等边角钢8#10040051005045 等边角钢9#10040061005050 等边角钢10#10040071005057 等边角钢11#10040081005062 等边角钢12.5#10040091005065 等边角钢14#10040101

17、005069 等边角钢16#10040111005073 等边角钢18#10040121005077 等边角钢20#10040131006001 方管100*100*410040141006002 方管100*100*810040151006003 方管100*60*310040161006004 方管100*60*410040171006005 方管100*60*4.510040181006006 方管100*60*510040191006007 方管120*120*410040201006008 方管160*160*4.510040211006009 方管160*80*4.51004022

18、1006010 方管20*20*1.210040231006011 方管220*80*610040241006012 方管25*25*1.210040251006013 方管40*40*210040261006014 方管40*40*2.510040271006015 方管40*40*410040281006016 方管50*30*2.510040291006017 方管50*30*310040301006018 方管50*32*210040311006019 方管50*35*2.510040321006020 方管50*50*2.510040331006021 方管50*50*3100500

19、11006022 方管50*50*410050021006023 方管55*38*210050031006024 方管60*40*2.510050041006025 方管60*40*310050051006026 方管60*40*410050061006027 方管60*60*2.510050071006028 方管60*60*310050081006029 方管60*60*410050091006030 方管70*50*410050101006031 方管70*70*410050111006032 方管70*70*510050121006033 方管80*60*310050131006034

20、 方管80*60*410050141006035 方管80*60*510050151006036 方管80*80*410050161006037 方管80*80*610050171006038 方管90*40*2.510050181006039 方管90*60*510050191007001 钢板薄板10050201007034 钢板厚板10050211007057 钢板中板10050221008001 工字钢10#10050231008002 工字钢12#10050241008003 工字钢14#10050251008004 工字钢16#10050261008005 工字钢18#100502

21、71008006 工字钢20#A10050281008007 工字钢20#B10050291008008 工字钢22#A10050301008009 工字钢22#B10050311008010 工字钢24#A10050321008011 工字钢24#B10050331008012 工字钢25#A10050341008013 工字钢25#B10050351008014 工字钢27#A10050361008015 工字钢27#B10050371008016 工字钢28#A10050381008017 工字钢28#B10050391008018 工字钢30#A10050401008019 工字钢30

22、#B10050411008020 工字钢32#A10050421008021 工字钢32#B10050431008022 工字钢36#A10050441008023 工字钢36#B10050451008024 工字钢40#A10050461008025 工字钢40#B10050471008026 工字钢45#10050481008027 工字钢45#A10050491008028 工字钢50#A10050501008029 工字钢50#B10050511008030 工字钢56#A10050521008031 工字钢56#B10050531008032 工字钢63#A1005054100803

23、3 工字钢63#B10050551009001 花纹板扁豆形10050561009011 花纹板菱形10050571009021 花纹板圆豆形10050581010001 螺纹钢810050591010002 螺纹钢1010050601010003 螺纹钢1210050611010004 螺纹钢1410050621010005 螺纹钢1610050631010006 螺纹钢1810050641010007 螺纹钢2010050651010008 螺纹钢2210050661010009 螺纹钢2510050671010010 螺纹钢2810050681010011 螺纹钢321005069101

24、0012 螺纹钢3610050701010013 螺纹钢4010050711011001 无缝管100+10050721011403 无缝管200+10050731011579 无缝管30+10050741011603 无缝管300+10050751011713 无缝管40+10050761011745 无缝管400+10050771011920 无缝管50+10050781011970 无缝管500+10050791012090 无缝管60+10050801012130 无缝管600+10050811012179 无缝管70+10060011012248 无缝管80+100600210122

25、97 无缝管90+10060031013001 圆钢5.510060041013002 圆钢610060051013003 圆钢6.510060061013004 圆钢710060071013005 圆钢810060081013006 圆钢910060091013007 圆钢1010060101013008 圆钢1210060111013009 圆钢1310060121013010 圆钢1410060131013011 圆钢1510060141013012 圆钢1610060151013013 圆钢1710060161013014 圆钢1810060171013015 圆钢1910060181

26、013016 圆钢2010060191013017 圆钢2110060201013018 圆钢2210060211013019 圆钢2410060221013020 圆钢2510060231013021 圆钢2610060241013022 圆钢2810060251013023 圆钢3010060261013024 圆钢3210060271013025 圆钢3410060281013026 圆钢3610060291013027 圆钢3810060301013028 圆钢4010060311013029 圆钢4210060321013030 圆钢4510060331013031 圆钢481006

27、0341013032 圆钢5010060351013033 圆钢5310060361013034 圆钢5610060371013035 圆钢6010060381013036 圆钢6310060391013037 圆钢7010070011013038 圆钢7510070021013039 圆钢8010070031013040 圆钢8510070041013041 圆钢9010070051013042 圆钢9510070061013043 圆钢10010070071013044 圆钢10510070081013045 圆钢11010070091013046 圆钢11510070101013047

28、圆钢12010070111013048 圆钢12510070121013049 圆钢13010070131013050 圆钢14010070141013051 圆钢15010070151013052 圆钢16010070161013053 圆钢17010070171013054 圆钢18010070181013055 圆钢19010070191013056 圆钢20010070201013057 圆钢22010070211013058 圆钢25010070221013059 圆钢* 1110070231013060 圆钢* 2310070241013061 圆钢* 27100702510130

29、62 圆钢* 2910070261013063 圆钢* 3110070271013064 圆钢* 3310070281013065 圆钢* 3510070291013066 圆钢* 5510070301013067 圆钢* 5810070311013068 圆钢* 6510070321013069 圆钢* 68100703310070341007035100703610070371007038100703910070401007041100704210070431007044100704510070461007047100704810070491007050100705110070521007

30、053100705410070551007056100705710070581007059100706010070611007062100706310070641007065100706610070671007068100706910070701007071100707210080011008002100800310080041008005100800610080071008008100800910080101008011100801210080131008014100801510080161008017100801810080191008020100802110080221008023100

31、802410080251008026100802710080281008029100803010080311008032100803310090011009002100900310090041009005100900610090071009008100900910090101009011100901210090131009014100901510090161009017100901810090191009020100902110090221009023100902410090251009026100902710090281009029100903010100011010002101000310

32、100041010005101000610100071010008101000910100101010011101001210100131011001101100210110031011004101100510110061011007101100810110091011010101101110110121011013101101410110151011016101101710110181011019101102010110211011022101102310110241011025101102610110271011028101102910110301011031101103210110331

33、011034101103510110361011037101103810110391011040101104110110421011043101104410110451011046101104710110481011049101105010110511011052101105310110541011055101105610110571011058101105910110601011061101106210110631011064101106510110661011067101106810110691011070101107110110721011073101107410110751011076

34、101107710110781011079101108010110811011082101108310110841011085101108610110871011088101108910110901011091101109210110931011094101109510110961011097101109810110991011100101110110111021011103101110410111051011106101110710111081011109101111010111111011112101111310111141011115101111610111171011118101111

35、910111201011121101112210111231011124101112510111261011127101112810111291011130101113110111321011133101113410111351011136101113710111381011139101114010111411011142101114310111441011145101114610111471011148101114910111501011151101115210111531011154101115510111561011157101115810111591011160101116110111

36、621011163101116410111651011166101116710111681011169101117010111711011172101117310111741011175101117610111771011178101117910111801011181101118210111831011184101118510111861011187101118810111891011190101119110111921011193101119410111951011196101119710111981011199101120010112011011202101120310112041011

37、205101120610112071011208101120910112101011211101121210112131011214101121510112161011217101121810112191011220101122110112221011223101122410112251011226101122710112281011229101123010112311011232101123310112341011235101123610112371011238101123910112401011241101124210112431011244101124510112461011247101

38、124810112491011250101125110112521011253101125410112551011256101125710112581011259101126010112611011262101126310112641011265101126610112671011268101126910112701011271101127210112731011274101127510112761011277101127810112791011280101128110112821011283101128410112851011286101128710112881011289101129010

39、112911011292101129310112941011295101129610112971011298101129910113001011301101130210113031011304101130510113061011307101130810113091011310101131110113121011313101131410113151011316101131710113181011319101132010113211011322101132310113241011325101132610113271011328101132910113301011331101133210113331

40、011334101133510113361011337101133810113391011340101134110113421011343101134410113451011346101134710113481011349101135010113511011352101135310113541011355101135610113571011358101135910113601011361101136210113631011364101136510113661011367101136810113691011370101137110113721011373101137410113751011376

41、101137710113781011379101138010113811011382101138310113841011385101138610113871011388101138910113901011391101139210113931011394101139510113961011397101139810113991011400101140110114021011403101140410114051011406101140710114081011409101141010114111011412101141310114141011415101141610114171011418101141

42、910114201011421101142210114231011424101142510114261011427101142810114291011430101143110114321011433101143410114351011436101143710114381011439101144010114411011442101144310114441011445101144610114471011448101144910114501011451101145210114531011454101145510114561011457101145810114591011460101146110114

43、621011463101146410114651011466101146710114681011469101147010114711011472101147310114741011475101147610114771011478101147910114801011481101148210114831011484101148510114861011487101148810114891011490101149110114921011493101149410114951011496101149710114981011499101150010115011011502101150310115041011

44、505101150610115071011508101150910115101011511101151210115131011514101151510115161011517101151810115191011520101152110115221011523101152410115251011526101152710115281011529101153010115311011532101153310115341011535101153610115371011538101153910115401011541101154210115431011544101154510115461011547101

45、154810115491011550101155110115521011553101155410115551011556101155710115581011559101156010115611011562101156310115641011565101156610115671011568101156910115701011571101157210115731011574101157510115761011577101157810115791011580101158110115821011583101158410115851011586101158710115881011589101159010

46、115911011592101159310115941011595101159610115971011598101159910116001011601101160210116031011604101160510116061011607101160810116091011610101161110116121011613101161410116151011616101161710116181011619101162010116211011622101162310116241011625101162610116271011628101162910116301011631101163210116331

47、011634101163510116361011637101163810116391011640101164110116421011643101164410116451011646101164710116481011649101165010116511011652101165310116541011655101165610116571011658101165910116601011661101166210116631011664101166510116661011667101166810116691011670101167110116721011673101167410116751011676

48、101167710116781011679101168010116811011682101168310116841011685101168610116871011688101168910116901011691101169210116931011694101169510116961011697101169810116991011700101170110117021011703101170410117051011706101170710117081011709101171010117111011712101171310117141011715101171610117171011718101171

49、910117201011721101172210117231011724101172510117261011727101172810117291011730101173110117321011733101173410117351011736101173710117381011739101174010117411011742101174310117441011745101174610117471011748101174910117501011751101175210117531011754101175510117561011757101175810117591011760101176110117

50、621011763101176410117651011766101176710117681011769101177010117711011772101177310117741011775101177610117771011778101177910117801011781101178210117831011784101178510117861011787101178810117891011790101179110117921011793101179410117951011796101179710117981011799101180010118011011802101180310118041011

51、805101180610118071011808101180910118101011811101181210118131011814101181510118161011817101181810118191011820101182110118221011823101182410118251011826101182710118281011829101183010118311011832101183310118341011835101183610118371011838101183910118401011841101184210118431011844101184510118461011847101

52、184810118491011850101185110118521011853101185410118551011856101185710118581011859101186010118611011862101186310118641011865101186610118671011868101186910118701011871101187210118731011874101187510118761011877101187810118791011880101188110118821011883101188410118851011886101188710118881011889101189010

53、118911011892101189310118941011895101189610118971011898101189910119001011901101190210119031011904101190510119061011907101190810119091011910101191110119121011913101191410119151011916101191710119181011919101192010119211011922101192310119241011925101192610119271011928101192910119301011931101193210119331

54、011934101193510119361011937101193810119391011940101194110119421011943101194410119451011946101194710119481011949101195010119511011952101195310119541011955101195610119571011958101195910119601011961101196210119631011964101196510119661011967101196810119691011970101197110119721011973101197410119751011976

55、101197710119781011979101198010119811011982101198310119841011985101198610119871011988101198910119901011991101199210119931011994101199510119961011997101199810119991012000101200110120021012003101200410120051012006101200710120081012009101201010120111012012101201310120141012015101201610120171012018101201

56、910120201012021101202210120231012024101202510120261012027101202810120291012030101203110120321012033101203410120351012036101203710120381012039101204010120411012042101204310120441012045101204610120471012048101204910120501012051101205210120531012054101205510120561012057101205810120591012060101206110120

57、621012063101206410120651012066101206710120681012069101207010120711012072101207310120741012075101207610120771012078101207910120801012081101208210120831012084101208510120861012087101208810120891012090101209110120921012093101209410120951012096101209710120981012099101210010121011012102101210310121041012

58、105101210610121071012108101210910121101012111101211210121131012114101211510121161012117101211810121191012120101212110121221012123101212410121251012126101212710121281012129101213010121311012132101213310121341012135101213610121371012138101213910121401012141101214210121431012144101214510121461012147101

59、214810121491012150101215110121521012153101215410121551012156101215710121581012159101216010121611012162101216310121641012165101216610121671012168101216910121701012171101217210121731012174101217510121761012177101217810121791012180101218110121821012183101218410121851012186101218710121881012189101219010

60、121911012192101219310121941012195101219610121971012198101219910122001012201101220210122031012204101220510122061012207101220810122091012210101221110122121012213101221410122151012216101221710122181012219101222010122211012222101222310122241012225101222610122271012228101222910122301012231101223210122331