钢材价格换算表
- 格式:xls
- 大小:45.00 KB
- 文档页数:4
产品名称材料名称型号规格比重比重单位 数量单位钢板中板δ539.25kg/㎡ 54.36㎡钢板中板δ1078.6kg/㎡ 18.12㎡钢板中板δ16125.6kg/㎡ 3.08㎡钢板薄板δ17.85kg/㎡ 2.98㎡等边角钢∠4#∠40*40*4 2.422kg/m 12.00m 等边角钢∠5#∠50*50*5 3.77kg/m 270.00m 槽钢[20#B [200*75*925.777kg/m 114.00m 无缝管Φ60+Φ60*3.5 4.88kg/m 24.00m 无缝管Φ300+Φ325*1077.68kg/m 6.00m H 型钢(HW )HW250*250HW250*250*9*1472.4kg/m 36.00m H 型钢(HM )HM400*300HM390*300*10*16107kg/m 12.00m 方管□50*50*4□50*50*4 5.74kg/m 6.00m 方管□70*70*5□70*70*510.2kg/m 6.00m 无缝管Φ30+Φ32*8 4.74kg/m 6.00m -㎡ -㎡ -㎡ -㎡ -㎡ -㎡ -㎡ -㎡ -㎡ -㎡ -㎡ -㎡ -㎡ -㎡ -㎡ -㎡ -㎡ -㎡ -㎡ -㎡ -㎡ -㎡ -㎡ -㎡ -㎡ -㎡ -㎡ -㎡ -㎡ -㎡ -㎡ -㎡ -㎡ -㎡ 570.530“基数数据”工作表中的数据共分为三组,其结构和要求如下:1、每组数据的第一列只用于排序,各组数据中不能有空行,一级数据和二级数据中不能有重复。
2、二级数据所属一级数据和三级数据所属二级数据中相同的数据应确保连续。
所定义的名称如下:Me =INDIRECT("R C",0)Data1=OFFSET(基数数据!$B$1,1,0,C OUNTA(基数数据!$B:$B)-1)Data2=OFFSET(基数数据!$F$1,1,0,C OUNTA(基数数据!$F:$F)-1)Data3=OFFSET(基数数据!$K$1,1,0,C OUNTA(基数数据!$K:$K)-1)Data12=OFFSET(基数数据!$E$1,1,0,C OUNTA(基数数据!$E:$E)-1)Data23=OFFSET(基数数据!$J$1,1,0,CO UNTA(基数数据!$J:$J)-1)List1=Data1List2=OFFSET(基数数据!$F$1,MATC H(Me,Data12,0 ),0,COUNTIF( Data12,Me))List3=OFFSET(基数数据!$K$1,MATC H(Me,Data23,0 ),0,COUNTIF( Data23,Me))List =IF(NOT(ISNA( MATCH(Me,Da ta1,0))),List2,IF (NOT(ISNA(M ATCH(Me,Data 2,0))),List3,List 1))各名称的含义说明:Me:当前的单元格,使用的是“R1C1”引Data1、Data2、Data3:一、二、三级数据的全部数据Data12、Data23:二级数据所属的一级数据、三级数据所属的二级数据List2、List3:根据当前单元格的实际内容所对应的一、二、三级菜单List:根据当前单元格的内容实际出现的菜单如果希望是在相邻的三个单元格里显示分级菜单,应再定义如下:LeftCell LeftCell List1A=Data1List2A =OFFSET(基数数据!$F$1,MATC H(LeftCell,Data 12,0),0,COUN TIF(Data12,Lef tCell))List3A =OFFSET(基数数据!$K$1,MATC H(LeftCell,Data 23,0),0,COUN TIF(Data23,Lef tCell))说明:1、在定义第二列、第三列数据有效性时会提示有错误,这是因为其左边的单元格为空,不用理会,直接确定即可据是针对同一单元格设计的,如在三个单元格里显示分级菜单,则显的很冗余,请根据实际使用情况进行修改。
钢管吨价换算米价公式在咱们的日常生活和工作中,经常会碰到跟钢管相关的事儿。
比如说搞建筑工程啦,或者做一些金属加工的活儿,这时候就常常需要在吨价和米价之间进行换算。
那今天咱们就来好好唠唠这个钢管吨价换算米价的公式。
先来说说为啥要搞清楚这个换算。
你想啊,假如咱去买钢管,卖家给咱报的是吨价,可咱心里头想的是每米得花多少钱,这要是不会换算,那不是抓瞎嘛!那这个换算公式到底是啥呢?其实很简单,就是米价 = 吨价 ÷(每米重量×1000)。
这里头的每米重量咋算呢?这就得看钢管的规格啦。
比如说,有一次我在一个建筑工地上,就碰到了这么个事儿。
当时负责采购的小李,一脸愁容地跑过来跟我说:“师傅,这钢管卖家给的是吨价,我这脑袋都大了,不知道咋算出米价来。
”我就跟他说:“别着急,咱先看看这钢管的规格。
” 我们找来尺子量了量,这钢管的外径是 50 毫米,壁厚是 3 毫米。
然后我们就按照公式来算每米的重量。
先算出钢管的横截面积,就是外径的圆面积减去内径的圆面积。
外径的半径就是 25 毫米,也就是0.025 米;内径的半径就是外径减去壁厚,也就是 0.022 米。
这圆面积的公式咱都知道,π乘以半径的平方。
算出来横截面积,再乘以钢管的长度 1 米,再乘以钢材的密度 7850 千克/立方米,这样就能得出每米的重量啦。
算出来每米的重量,再用卖家给的吨价除以每米重量乘以 1000,就能得出米价。
小李按照我教的方法,很快就算出了米价,心里一下子就有底了,脸上也露出了笑容。
所以说啊,掌握这个钢管吨价换算米价的公式,真的能在关键时刻派上大用场。
不管是买钢管还是做预算,都能让咱心里明明白白的,不被价格给搞迷糊了。
在实际应用中,大家可得注意量准钢管的规格,算的时候也仔细点,别马虎。
要不然,算错了价格,那可就亏大啦!总之,这个小小的换算公式虽然看起来不复杂,但用好了能帮咱解决不少问题,让咱在和钢管打交道的时候更加得心应手。
钢材价格的计算公式圆钢、螺纹钢:0.00617×直径×直径=每米重量(公斤)理论重量/支/吨×吨价×米数=支价圆钢重量(公斤)=0.00617×直径×直径×长度方钢:0.00785×边宽×边宽=每米重量/吨(保留3位小数)×吨价×米数=支价方钢重量(公斤)=0.00785×边宽×边宽×长度扁钢:0.00785×边宽×厚度=每米重量×米数×吨价=支价扁钢重量(公斤)=0.00785×厚度×边宽×长度六角钢:0.006798≈0.0068×对边距离的平方=每米重量六角钢重量(公斤)=0.0068×对边宽×对边宽×长度八角钢:0.0065×对边距离的平方=每米重量八角钢重量(公斤)=0.0065×对边宽×对边宽×长度角钢:理论重量×吨价×米数=支价支重×过磅价/1000=支价角钢重量(公斤)=0.00785×(边宽+边宽-边厚)×边厚×长度槽钢、工字钢、H型钢:理论重量×吨价×米数=支价矩形管:(长+宽)×2×壁厚×0.00785×吨价×米数=支价方管:长×4×壁厚×0.00785×吨价×米数=支价焊管、无缝管:(外径-壁厚)×壁厚×0.02466=每米重量焊管、无缝管重量(公斤)=0.02466×壁厚×(外径-壁厚)×长度冷板、热板、开平板、中板、镀锌板:长×宽×厚度×7.85/1000000000=每张重量/吨×吨价=每张价格钢板:7.85×厚度=每平方米的重量每张重量÷每平方米的重量=平方米注:(张价×张数)÷(每张重量×张数)=吨价花纹板:7.85×厚度+3=每平方米的重量每平方米的重量×长×宽×吨价=单张价格。
市场价普通管市场价普通管市场价普通管市场价普通管市场价普通管元/吨元/米元/吨元/米元/吨元/米元/吨元/米元/吨元/米15525078.754900 6.174700 5.924700 5.924700 5.92205250105.0049007.9947007.6647007.6647007.66255200130.00490011.86465011.25465011.25465011.25325200166.40485015.18465014.55465014.55465014.55405100204.00510019.58455017.47450017.28450017.28505100255.00510024.89455022.20450021.96450021.96705100357.00475031.54455030.21465030.88465030.88805100408.00475039.62455037.95465038.78465038.781005100510.00475051.54455049.37465050.45465050.451255100637.50475063.75455061.06465062.40465062.401505100765.00515091.67455080.99450080.10450080.1020051001020.004800151.304550143.424500141.844500141.8425051001275.005000229.604550208.944500206.644500206.6430051001530.005000312.704550284.564500281.434500281.431561508.1858007.7156007.4556007.4556007.4520600010.3857009.8655009.5255009.5255009.5225595015.29565014.52545014.01545014.01545014.0132595019.75565018.76545018.09545018.09545018.09规格2011-62012-22012-42012-1焊接钢管理论重量表镀锌钢管理2012-340585023.81555022.59535021.77535021.77535021.7750585030.24555028.69535027.66535027.66535027.6670585041.18555039.07535037.66535037.66535037.6680585051.71555049.06535047.29535047.29535047.29100585067.28555063.83535061.53535061.53535061.53125595079.85565075.82535071.80535071.80535071.801505950111.865650106.225450102.465450102.465450102.462005950187.605650178.145450171.845450171.845450171.842505950314.165650298.325450287.765450287.765450287.763005950372.115650353.355450340.845450340.845450340.840.5000.0000.0000.000.000.000.6000.0000.0000.000.000.000.7500.0000.0000.000.000.001.0000.0000.0000.000.000.001.2000.0000.0000.000.000.00405075110160锌钢管理论重量表PVCP排水管镀锌钢板200152025324050708010012515020020253240507080钢 塑管排水管PPR管100125150152025324050152025324050DN800077009986001108600110DN10000770012286001368600136DN15000640015473001757300175DN20000640020773002367300236K B G电线管 球墨管定尺重PVC电线管DN25000627026673003107300310DN30000610032866003556600355DN40000610049065005226500522DN50000610068065007256500725DN60000615090465009566500956DN80000615014296500151065001510DN15DN20DN25DN32DN40DN50DN15DN20DN25DN32DN40DN50DN65DN80DN100DN50球墨管定尺重量螺纹截止阀门J11T-16K 螺纹闸阀Z15T-10K 闸阀DN65DN80DN100DN125DN150DN200DN250DN300DN50DN65DN80DN100DN125DN150DN200DN250DN300DN50DN65DN80DN100DN125DN150DN200法兰止回阀H44T-10法兰闸阀Z41T-10法兰闸阀Z41H-10C市场价普通管市场价普通管市场价普通管市场价普通管市场价普通管市场价普通管元/吨元/米元/吨元/米元/吨元/米元/吨元/米元/吨元/米元/吨元/米47505.994550 5.734450 5.614200 5.294100 5.174250 5.3647507.7445507.4244507.254200 6.854100 6.684250 6.93470011.37455011.01445010.77415010.0440509.80420010.16470014.71455014.24445013.93415012.99405012.68420013.15460017.66440016.90430016.51405015.55395015.17410015.74460022.45440021.47430020.98405019.76395019.28410020.01460030.54440029.22430028.55405026.89395026.23410027.22460038.36440036.70430035.86405033.78395032.94410034.19460049.91440047.74430046.66405043.94395042.86410044.49460061.73440059.05430057.71405054.35395053.01410055.02460081.88440078.32430076.54405072.09395070.31410072.984600144.994400138.694300135.544050127.663950124.504100129.234600211.234400202.054300197.464050185.983950181.384100188.274600287.684400275.184300268.924050253.293950247.034100256.4156007.4554007.1853007.055150 6.855050 6.725200 6.9255009.5253009.1752009.0049508.5648508.3950008.65545014.01525013.49515013.24490012.59480012.34495012.72545018.09525017.43515017.10490016.27480015.94495016.432012-102012-92012-52012-62012-72012-8540021.98520021.16510020.76485019.74475019.33490019.94540027.92520026.88510026.37485025.07475024.56490025.33540038.02520036.61510035.90485034.14475033.44490034.50540047.74520045.97510045.08485042.87475041.99490043.32540062.10520059.80510058.65485055.78475054.63490056.35540072.47520069.78510068.44485065.09485065.09500067.105500103.40530099.64520097.76495093.06485091.18500094.005500173.425300167.115200163.964950156.074850152.925000157.655500290.405300279.845200274.564950261.364850256.085000264.005500343.975300331.465200325.214950309.574850303.325000312.700.000.000.00515021.63510021.42535022.470.000.000.00515025.67510025.42525026.170.000.000.00515031.74510031.43525032.360.000.000.00505041.03500040.63515041.840.000.000.00505048.96500048.48515049.9336.5334.718.8917.9536.539.9318.895.285.7255.72 5.4310.4510.455.28444628.8812712195.89112795.835.7534.028.627.1735.7528.623.322.1415.0214.2723.327.4417216417232632631075.271.4458.95675.258.9 6.679.539.0517.741.2343.443.49.5315.0257.7654.8757.7618.5928.884618.5911.7711.7711.184.74 4.57.027.024.7464.996264.9986001107500967400957100917100917100918600136750011974001177100112710011271001127300175620014961001465800139580013958001397300236620020061001975800188580018858001886.066.384.536.38 3.34.774.773.473.47 2.091.492.152.151.571.57 1.11.161.162.673.345.84 2.673.345.849.4511.618.169.4511.618.169.4511.612.673.345.848.1693.6393.6390138138300300285131730031060702585970254567024156702415670241 660035559003185800312550029655002965500296 650052259004745800466550044255004425500442 650072559006585800647550061355006135500613 650095659508755850860555081655508165550816 650015105950138258501359555012895550128955501289市场价普通管市场价普通管市场价普通管市场价普通管市场价普通管元/吨元/米元/吨元/米元/吨元/米元/吨元/米元/吨元/米42505.364200 5.294300 5.424350 5.483950 4.9842506.934200 6.8543007.0143507.093950 6.44420010.16415010.04425010.29430010.4139009.44420013.15415012.99425013.30430013.46390012.21410015.74405015.55415015.94420016.13380014.59410020.01405019.76415020.25420020.50380018.54410027.22405026.89415027.56420027.89380025.23410034.19405033.78415034.61420035.03380031.69410044.49405043.94415045.03420045.57380041.23410055.02405054.35415055.69420056.36380051.00410072.98410072.98415073.87420074.76380067.644100129.234100129.234150130.814200132.383800119.784100188.274100188.274150190.574200192.863800174.504100256.414100256.414150259.544200262.673800237.6552006.925150 6.855250 6.9853007.054900 6.5250008.6549508.5650508.7451008.8247008.13495012.72490012.59500012.85505012.98465011.95495016.43490016.27500016.60505016.77465015.442013-22012-112012-122013-12013-3490019.94485019.74495020.15500020.35460018.72490025.33485025.07495025.59500025.85460023.78490034.50485034.14495034.85500035.20460032.38490043.32485042.87495043.76500044.20460040.66490056.35485055.78495056.93500057.50460052.90500067.10495066.43495066.43500067.10470063.07500094.00495093.06505094.94510095.88470088.365000157.654950156.075050159.235100160.804700148.195000264.004950261.365050266.645100269.284700248.165000312.704950309.575050315.835100318.954700293.94530022.26525022.05535022.47540022.68540022.68520025.92515025.67525026.17530026.42530026.42520032.05515031.74525032.36530032.66530032.66510041.44505041.03515041.84520042.25520042.25510049.44505048.96515049.93520050.41520050.4155.439.9317.9534.717.9534.755.439.9317.9534.755.439.9317.9534.755.439.9318.234.955.25.6710.144623104.56.6711.1817.727.4441.235671.449112116454.879.0514.2722.1427.1734.054.879.0541.235671.449114.2722.1427.1734.06.6711.1817.727.441211643104.5446254.879.0541.235671.449114.2722.1427.1734.06.6711.1817.727.441211643104.5446254.879.0541.235671.449114.2722.1427.1734.06.6711.1817.727.441211643104.5446254.879.0541.235671.449114.2722.1427.1734.06.6711.1817.727.441211643104.5446271009170097050907100917100917100112570090705011271001126700106580013957001375750138580013954001305800188557018057501865800188580018811.613.345.848.169.451.492.093.34.536.062.67901312851.12851.11.492.099013111.613.345.848.169.453.34.536.062.672851.11.492.099013111.613.345.848.169.453.34.536.062.672851.11.492.099013111.613.345.848.169.453.34.536.062.672851.11.492.09901313.345.848.169.453.34.536.062.6711.6156702415400230562023956702415670241 55002965400291545029355002965500296 55004425400434545043855004425500442 55006135450608545060855006135500613 55508165450801550080955508165550816 555012895450126655001278555012895550128921.8528.53862.77610522.827.5540.8558.979.8118238278373243330 446 679 850 1176 1735 2438 3740 504 791 938 1206 1646 2088 2917 4377 6257 257 373 558 725 1083 1388 2152。