copy of precios de tuberias- marzo

6
PE-100, PN-10 FACTOR ESPESOR DIAMETRO AREA (MM2) PRECIO $ PRECIO S/. 4.5 75 2120.575041 3.010105058 3.1 9.61 5.4 90 3053.628059 4.316379283 4.4 13.64 6.6 110 4561.592533 6.427529546 6.5 20.15 9.5 160 9550.441667 13.5 13.5 41.85 11.9 200 14953.98103 21.11 21.11 65.441 14.8 250 23247.78564 32.8 32.8 101.68 18.7 315 37011.10305 51.85684427 51.9 160.89 PE-100, PN-6 ESPESOR DIAMETRO AREA (MM2) PRECIO $ PRECIO S/. 2.9 75 1366.592804 0.84 0.85 3.5 90 1979.203372 1.76 1.8 4.2 110 2902.831612 3.15 3.15 9.77 6.2 160 6232.919825 9.12 9.15 28.37 7.7 200 9676.105373 11.55 11.55 35.81 9.6 250 15079.64474 21.95 21.95 68.05 12.1 315 23948.3608 34.71 34.71 107.60 5000 10000 15000 20000 25000 0 5 10 15 20 25 30 35 f(x) = 0.0014090703599566 x + 0.0412595377640201 R² = 0.999999950827894 Column D Linear (Column D) 4000 6000 8000 10000120001400016000 0 5 10 15 20 25 f(x) = 0.00149237142882944 x − 1.20886854281146 R² = 0.953596813916444 Column D Linear (Column D)

Upload: naomi-bj

Post on 16-Dec-2015

221 views

Category:

Documents


5 download

DESCRIPTION

Precios

TRANSCRIPT

Hoja1PE-100, PN-10FACTOR3.1PE-80, PN-8ESPESORDIAMETROAREA (MM2)PRECIO $PRECIOS/.ESPESORDIAMETROAREA (MM2)PRECIO $PRECIOS/.4.5752120.57504117313.01010505763.19.613.6751696.46003293852.42354404612.57.755.4903053.62805928934.3163792834.413.644.3902431.59271387853.45272979943.510.856.61104561.59253301246.42752954626.520.155.31103663.09703408575.17683584775.2216.1829.51609550.44166691313.513.541.857.71607740.884298445211.111.134.4111.920014953.981031087421.1121.1165.4419.620012063.715789784817.2817.2853.56814.825023247.785636564532.832.8101.6811.925018692.476288859326.7426.7482.89418.731537011.103051941451.856844272751.9160.891531529688.050576423541.61177080741.7129.27PE-100, PN-6PE-100, PN-4ESPESORDIAMETROAREA (MM2)PRECIO $PRECIOS/.SDRESPESORPRECIO $PRECIOS/.2.9751366.59280431160.840.851718.751.9051.9160.893.5901979.20337176161.761.8211541.7041.7129.274.21102902.8316119173.153.159.772612.133.7058833.41103.576.21606232.91982472229.129.1528.37339.727.0944727.184.017.72009676.105373056611.5511.5535.81417.721.5822721.666.969.625015079.64473723121.9521.9568.0512.131523948.36079831534.7134.71107.60

Hoja2DIAMETRO 160 MMFACTORSDRESPESORPRECIO $179.513.513.5217.711.111.1266.29.099769.12DIAMETRO 200 MMSDRESPESORPRECIO $1711.921.1121.11219.617.2817.28267.711.5281411.55DIAMETRO 250 MMSDRESPESORPRECIO $1714.832.832.82111.926.7426.74269.621.9342221.95DIAMETRO 315 MMSDRESPESORPRECIO $1718.751.951.9211541.741.72612.133.7058833.71339.727.0944727.1417.721.5822721.6

Hoja3