Cálculo Óptimo de Tuberia Forzada

download Cálculo Óptimo de Tuberia Forzada

of 21

description

excel de calculo para una centra hidroeletrica

Transcript of Cálculo Óptimo de Tuberia Forzada

PARAMETROSPARAMETROS PARA LA DETERMINACION DEL DIAMETRO OPTIMOCENTRAL HIDROELECTRICASTA.LORENZADATOS DEL SISTEMACaudalm3/s3Caudal por tuberiam3/s3Nivel de operacin normalmsnm490.24Nivel del agua valvulamsnm485.335Nivel eje de Turbinamsnm403.3Altura Brutam86.94Sobrepresion (Golpe de ariete)%25Rendimiento Hidraulico%1Rendimiento Turbina%0.91Rendimento Generador%0.96Vida utilaos30Horas operacin al aohr8760DATOS DE LA TUBERIABifurcacionSINumero de tuberiasu1Longitud de tuberiam303.4Resistencia del materialkg/cm22500Esfuerzo admisiblePa/m2114000000??Densidad del materialkg/m37850Coeficiente de rugosidad Manning0.01Espesor por Corrosionm0.002Eficiencia junta soldada0.85COSTOSFabricacionUS $/kg4MontajeUS $/kg1.5Obras CivilesUS $/kg2EnergaUS $/kw-hr0.06Tasa de descuento anual%12DIAMETRO ECONOMICO SUGERIDODiametro 1m1.15DIAMETROS DE ANALISISD1cm100D2cm105D3cm110D4cm115D5cm120D6cm125D7cm130OTROS VARIABLESViscosidad del aguaPa-s0.0011382Gravedadm/s29.78Peso especifico de aguaN/m39751.394478Coeficiente Hazen150Rugosidad absolutam0.00004572Densidad del fluidokg/m3997.0751Factor K1.7

COSTO PERDIDA ENERGIALongitudDiametroAlt. BCaudalEfic. GrupoVel.NReynoldsCoef. Fric.FriccionLocalesTot.Alt.perd.Alt.NetagPot.Pot.PerdHrs. opePerdidaPerdidaValor actual(m)(m)(m)(m3/s)(m/s)(m)(m)(m)(m)(m/s2)(kW)(kW)(h/ao)(kW-hr)(US$/ao)(US$)303.41.0086.930.87363.8133409760.01132.3061.2643.57083.3709.78213792876080163348098387438303.41.0586.930.87363.4631819130.01131.8181.0402.85884.0829.78215573876064180638508310192303.41.1086.930.87363.1530373080.01131.4500.8632.31384.6279.78216959876051939131163251027303.41.1586.930.87362.8829052770.01131.1680.7231.89085.0509.78218048876042445125467205142303.41.2086.930.87362.6527842480.01130.9490.6101.55985.3819.78218840876034997320998169146303.41.2586.930.87362.4426729000.01130.7780.5181.29685.6449.78219533876029093617456140613303.41.3086.930.87362.2625701160.01120.6430.4431.08585.8559.78220128876024368614621117776

ESPESOR & TUBERIAESPESOR DE TUBERIA Y PESOCon formula ASMEAltura de presion (m)Espesor tuberia(mm)Peso(kg)PUNTONIVELProgresivaANCLAJEHidrosta.SobrepresionTotalAnguloAng.tuboDif.alt. tramoLong.tramoLong. Acum.PresionDiam.inter.Efic.junta=0.85Corros.+2Real(inc.+20%)N(golpe ariete)radmmmN/m2m1485.34Valvula4.911.476.40.000.0000.000.000.00621801.000.322.328.002485.34A14.901.476.40.000.000-0.004.164.16621161.000.322.328.09933481.758.492.5511.024.010.4193.598.8212.981076121.000.562.568.021054478.0912.153.6515.824.010.4193.669.0021.981540401.000.802.808.021485474.4315.814.7420.624.010.4193.669.0030.982004691.001.043.048.021486470.7619.485.8425.324.010.4193.669.0039.982468981.001.283.288.021487467.1023.146.9430.124.010.4193.669.0048.982933271.001.523.528.021488463.4426.808.0434.824.010.4193.669.0057.983397561.001.763.768.021489459.7830.469.1439.624.010.4193.669.0066.983861851.002.004.008.0214810456.30A233.9410.1844.124.010.4193.488.5575.534302921.002.234.238.0204011456.2633.9810.1944.20.110.0020.0317.2992.824307081.002.234.238.0412612456.25A333.9910.2044.20.110.0020.029.00101.824309241.002.234.238.0214813454.5935.6510.6946.312.240.2141.657.80109.624518811.002.344.348.0186014452.6937.5511.2748.812.240.2141.919.00118.624760771.002.464.468.0214815450.7839.4611.8451.312.240.2141.919.00127.625002731.002.594.598.0214816448.8741.3712.4153.812.240.2141.919.00136.625244691.002.724.728.0214817446.9643.2812.9856.312.240.2141.919.00145.625486661.002.844.848.0214818445.0545.1913.5658.712.240.2141.919.00154.625728621.002.974.978.0214819443.1447.1014.1361.212.240.2141.919.00163.625970581.003.095.098.0214820441.2349.0114.7063.712.240.2141.919.00172.626212551.003.225.228.0214821439.63A450.6115.1865.812.240.2141.617.58180.196416221.003.325.328.0180822435.6354.6116.3871.018.240.3184.0012.78192.976923381.003.595.598.0305023432.8157.4317.2374.718.240.3182.829.00201.977280571.154.346.348.0246724429.9960.2518.0778.318.240.3182.829.00210.977637751.003.965.968.0214825427.1763.0718.9282.018.240.3182.829.00219.977994931.004.156.158.0214826424.3665.8819.7785.718.240.3182.829.00228.978352111.004.336.338.0214827421.5468.7020.6189.318.240.3182.829.00237.978709301.004.526.528.0214828418.7271.5221.4693.018.240.3182.829.00246.979066481.004.706.708.0214829415.9074.3422.3096.618.240.3182.829.00255.979423661.004.896.898.0214830412.00A578.2423.47101.718.240.3183.9012.47268.449918561.005.157.158.0297631410.1080.1424.04104.210.490.1831.9010.43278.8710159241.005.287.288.0248932408.24A682.0024.60106.610.490.1831.8610.21289.0810394851.005.407.408.0243733403.40A786.8426.05112.923.200.4054.8412.29301.3711008631.005.727.728.0293334403.40Casa Maq.86.8426.05112.90.000.0000.002.15303.5211008631.005.727.728.0512TOTAL303.5272752Con formula ASMEAltura de presion (m)Espesor tuberia(mm)Peso(kg)PUNTONIVELProgresivaANCLAJEHidrosta.SobrepresionTotalAnguloAng.tuboDif.alt. tramoLong.tramoLong. Acum.PresionDiam.inter.Efic.junta=0.85Corros.+2Real(inc.+20%)N(golpe ariete)radmmmN/m2m1485.34Valvula4.901.476.40.000.0000.000.000.00621161.050.342.348.002485.34A14.901.476.40.000.0000.004.164.16621161.050.342.348.010423481.758.492.5511.024.010.4193.598.8212.981076121.050.582.588.022094478.0912.153.6515.824.010.4193.669.0021.981540401.050.842.848.022545474.4315.814.7420.624.010.4193.669.0030.982004691.051.093.098.022546470.7619.485.8425.324.010.4193.669.0039.982468981.051.343.348.022547467.1023.146.9430.124.010.4193.669.0048.982933271.051.593.598.022548463.4426.808.0434.824.010.4193.669.0057.983397561.051.843.848.022549459.7830.469.1439.624.010.4193.669.0066.983861851.052.104.108.0225410456.30A233.9410.1844.124.010.4193.488.5575.534302921.052.344.348.0214211456.2633.9810.1944.20.110.0020.0317.2992.824307081.052.344.348.0433112456.25A333.9910.2044.20.110.0020.029.00101.824309241.052.344.348.0225413454.5935.6510.6946.312.240.2141.657.80109.624518811.052.464.468.01953433114452.6937.5511.2748.812.240.2141.919.00118.624760771.052.594.598.0225415450.7839.4611.8451.312.240.2141.919.00127.625002731.052.724.728.0225416448.8741.3712.4153.812.240.2141.919.00136.625244691.052.854.858.0225417446.9643.2812.9856.312.240.2141.919.00145.625486661.052.984.988.02254225418445.0545.1913.5658.712.240.2141.919.00154.625728621.053.115.118.02254195319443.1447.1014.1361.212.240.2141.919.00163.625970501.053.255.258.0225420441.2349.0114.7063.712.240.2141.919.00172.626212381.053.385.388.022548537.92821439.63A450.6115.1865.812.240.2141.617.58180.196415991.053.495.498.0189822435.6354.6116.3871.018.240.3184.0012.78192.976923151.053.775.778.0320123432.8157.4317.2374.718.240.3182.829.00201.977280341.053.965.968.0225424429.9960.2518.0778.318.240.3182.829.00210.977637521.054.166.168.0225425427.1763.0718.9282.018.240.3182.829.00219.977994701.054.356.358.0225426424.3665.8819.7685.618.240.3182.829.00228.978351881.054.556.558.0225427421.5468.7020.6189.318.240.3182.829.00237.978709071.054.746.748.0225428418.7271.5221.4693.018.240.3182.829.00246.979066251.054.946.948.0225429415.9074.3422.3096.618.240.3182.829.00255.979423431.055.147.148.0225430412.00A578.2423.47101.718.240.3183.9012.47268.449918331.055.417.418.0312431410.1080.1424.04104.210.490.1831.9010.43278.8710159011.055.547.548.0261332408.24A682.0024.60106.610.490.1831.8610.21289.0810394621.055.677.678.0255733403.40A786.8426.05112.923.200.4054.8412.29301.3711008391.056.018.019.0346634403.40Casa Maq.86.8426.05112.900.0000.002.15303.5211008391.056.018.019.0605TOTAL303.5276481Con formula ASMEAltura de presion (m)Espesor tuberia(mm)Peso(kg)PUNTONIVELProgresivaANCLAJEHidrosta.SobrepresionTotalAnguloAng.tuboDif.alt. tramoLong.tramoLong. Acum.PresionDiam.inter.Efic.junta=0.85Corros.+2Real(inc.+20%)N(golpe ariete)radmmmN/m2m1485.34Valvula4.901.476.40.000.0000.000.000.00621161.100.352.358.002485.3414.901.476.40.000.0000.004.164.16621161.100.352.358.010913481.758.492.5511.024.010.4193.598.8212.981076061.100.612.618.023131485.34Valvula4.901.476.424.010.419-3.599.000.00621161.100.352.358.023612481.68A18.562.5711.124.010.4193.669.009.001085401.100.622.628.023613478.0212.223.6715.924.010.4193.669.0018.001549691.100.882.888.023617474.3515.894.7720.724.010.4193.669.0027.002013971.101.143.148.023618470.6919.555.8625.424.010.4193.669.0036.002478261.101.413.418.023619467.0323.216.9630.224.010.4193.669.0045.002942551.101.673.678.0236110463.55A226.698.0134.724.010.4193.488.5553.553383631.101.923.928.0224311463.5226.728.0234.70.110.0020.0317.2970.843387781.101.933.938.0453612463.50A326.748.0234.80.110.0020.029.0079.843389941.101.933.938.0236113461.8528.398.5236.912.240.2141.657.8087.643599511.102.054.058.0204514459.9430.309.0939.412.240.2141.919.0096.643841391.102.194.198.0236115458.0332.219.6641.912.240.2141.919.00105.644083351.102.324.328.0236116456.1234.1210.2444.412.240.2141.919.00114.644325241.102.464.468.0236117454.2136.0310.8146.812.240.2141.919.00123.644567201.102.604.608.0236118452.3037.9411.3849.312.240.2141.919.00132.644809081.102.744.748.0236119450.4039.8411.9551.812.240.2141.919.00141.645051041.102.884.888.0236120448.4941.7512.5354.312.240.2141.919.00150.645293011.103.015.018.0236121446.88A443.3613.0156.412.240.2141.617.58158.215496621.103.135.138.0198722442.8847.3614.2161.618.240.3184.0012.78170.996003661.103.425.428.0335223440.0650.1815.0565.218.240.3182.829.00179.996360771.103.625.628.0236124437.2552.9915.9068.918.240.3182.829.00188.996717871.103.835.838.0236125434.4355.8116.7472.618.240.3182.829.00197.997074981.104.036.038.0236126431.6158.6317.5976.218.240.3182.829.00206.997432081.104.246.248.0236127428.8061.4418.4379.918.240.3182.829.00215.997789181.104.446.448.0236128425.9864.2619.2883.518.240.3182.829.00224.998146291.104.656.658.0236129423.1667.0820.1287.218.240.3182.829.00233.998503391.104.856.858.0236113030421.00A569.2420.7790.010.000.1752.1712.47246.468777891.105.017.018.0327131419.1071.1421.3492.510.490.1831.9010.43256.899018621.105.157.158.0273632417.24A673.0021.9094.910.490.1831.8610.21267.109254261.105.287.288.0267833412.40A777.8423.35101.223.200.4054.8412.29279.399868021.105.647.648.0322434412.40Casa Maq.77.8423.35101.200.0000.002.15281.549868021.105.647.648.0563TOTAL303.5279618Con formula ASMEAltura de presion (m)Espesor tuberia(mm)Peso(kg)PUNTONIVELProgresivaANCLAJEHidrosta.SobrepresionTotalAnguloAng.tuboDif.alt. tramoLong.tramoLong. Acum.PresionDiam.inter.Efic.junta=0.85Corros.+2Real(inc.+20%)N(golpe ariete)radmmmN/m2m0.001485.34Valvula4.901.476.40.000.0000.000.000.00621161.150.372.376.404.1602485.34A14.901.476.40.000.0000.004.164.16621161.150.372.376.49118.8193481.758.492.5511.024.010.4193.598.8212.981076121.150.642.646.419329.0004478.0912.153.6515.824.010.4193.669.0021.981540401.150.912.916.419719.0005474.4315.814.7420.624.010.4193.669.0030.982004691.151.193.196.419719.0006470.7619.485.8425.324.010.4193.669.0039.982468981.151.473.476.419719.0007467.1023.146.9430.124.010.4193.669.0048.982933271.151.743.746.419719.0008463.4426.808.0434.824.010.4193.669.0057.983397561.152.024.026.419719.0009459.7830.469.1439.624.010.4193.669.0066.983861851.152.304.306.419718.55010456.30A233.9410.1844.124.010.4193.488.5575.534302921.152.564.566.4187317.29111456.2633.9810.1944.20.110.0020.0317.2992.824307081.152.564.566.437879.00012456.25A333.9910.2044.20.110.0020.029.00101.824309241.152.564.566.419717.79513454.5935.6510.6946.312.240.2141.657.80109.624518811.152.694.696.417079.00014452.6937.5511.2748.812.240.2141.919.00118.624760691.152.834.836.419719.00015450.7839.4611.8451.312.240.2141.919.00127.625002651.152.984.986.419719.00016448.8741.3712.4153.812.240.2141.919.00136.625244531.153.125.126.419719.00017446.9643.2812.9856.312.240.2141.919.00145.625486411.153.275.276.419719.00018445.0545.1913.5658.712.240.2141.919.00154.625728381.153.415.416.419719.00019442.9947.2514.1761.413.240.2312.069.00163.625989681.153.575.576.419719.00020440.7849.4614.8464.314.240.2492.219.00172.626270331.153.745.746.419717.57621439.17A451.0715.3266.412.240.2141.617.58180.196474011.153.865.866.4165912.77922436.4653.7816.1369.912.240.2142.7112.78192.976817451.154.066.066.427999.00023434.5555.6916.7172.412.240.2141.919.00201.977059331.154.216.216.41971147.209.00024431.7458.5017.5576.118.240.3182.829.00210.977416441.154.426.428.0246764.009.00025428.9261.3218.4079.718.240.3182.829.00219.977773541.154.646.648.0246728.509.000228.9726426.1064.1419.2483.418.240.3182.829.00228.978130641.154.856.858.02467278.879.00027423.2966.9520.0987.018.240.3182.829.00237.978487751.155.067.068.024679.00028420.4769.7720.9390.718.240.3182.829.00246.978844851.155.287.288.024679.00029417.6572.5921.7894.418.240.3182.829.00255.979201951.155.497.498.0246712.47030413.75A576.4922.9599.418.240.3183.9012.47268.449696741.155.797.798.0341910.43031411.8578.3923.52101.910.490.1831.9010.43278.879937461.155.937.938.0285910.21032409.99A680.2524.07104.310.490.1831.8610.21289.0810173111.156.078.079.5332812.29033405.15A785.0925.53110.623.200.4054.8412.29301.3710786861.156.448.449.540062.14674.546303.5234405.15Casa Maq.85.0925.53110.600.0000.002.15303.5210786861.156.448.449.570024.65TOTAL303.5273353Con formula ASMEAltura de presion (m)Espesor tuberia(mm)Peso(kg)PUNTONIVELProgresivaANCLAJEHidrosta.SobrepresionTotalAnguloAng.tuboDif.alt. tramoLong.tramoLong. Acum.PresionDiam.inter.Efic.junta=0.85Corros.+2Real(inc.+20%)N(golpe ariete)radmmmN/m2m1485.34Valvula4.901.476.40.000.0000.000.000.00621161.200.382.388.002485.34A14.901.476.40.000.0000.004.164.16621161.200.382.388.011903481.758.492.5511.024.010.4193.598.8212.981076061.200.672.678.025224478.0912.153.6515.824.010.4193.669.0021.981540291.200.952.958.025745474.4315.814.7420.624.010.4193.669.0030.982004531.201.243.248.025746470.7719.475.8425.324.010.4193.669.0039.982468761.201.533.538.025747467.1023.146.9430.124.010.4193.669.0048.982932991.201.823.828.025748463.4426.808.0434.824.010.4193.669.0057.983397231.202.114.118.025749459.7830.469.1439.624.010.4193.669.0066.983861461.202.404.408.0257410456.30A233.9410.1844.124.010.4193.488.5575.534302481.202.674.678.0244511456.2733.9710.1944.20.110.0020.0317.2992.824306691.202.674.678.0494512456.25A333.9910.2044.20.110.0020.029.00101.824308881.202.684.688.0257413454.6035.6410.6946.312.240.2141.657.80109.624518381.202.814.818.0222914452.6937.5511.2748.812.240.2141.919.00118.624760261.202.964.968.0257415450.7839.4611.8451.312.240.2141.919.00127.625002141.203.115.118.0257416448.8741.3712.4153.812.240.2141.919.00136.625244021.203.265.268.0257417446.9643.2812.9856.312.240.2141.919.00145.625485901.203.415.418.0257418445.0645.1813.5558.712.240.2141.919.00154.625727781.203.565.568.0257419443.1547.0914.1361.212.240.2141.919.00163.625969671.203.715.718.0257420441.2449.0014.7063.712.240.2141.919.00172.626211551.203.865.868.0257421439.63A450.6115.1865.812.240.2141.617.58180.196415161.203.995.998.0216722435.6354.6116.3871.018.240.3184.0012.78192.976922211.204.306.308.0365523432.8257.4217.2374.618.240.3182.829.00201.977279311.204.536.538.0257424430.0060.2418.0778.318.240.3182.829.00210.977636411.204.756.758.0257425427.1863.0618.9282.018.240.3182.829.00219.977993521.204.976.978.0257426424.3765.8719.7685.618.240.3182.829.00228.978350621.205.207.208.0257427421.5568.6920.6189.318.240.3182.829.00237.978707721.205.427.428.0257428418.7371.5121.4593.018.240.3182.829.00246.979064831.205.647.648.0257429415.9274.3222.3096.618.240.3182.829.00255.979421931.205.877.878.0257430412.01A578.2323.47101.718.240.3183.9012.47268.449916721.206.188.189.0401531410.1180.1324.04104.210.490.1831.9010.43278.8710157441.206.338.339.0335932408.25A681.9924.60106.610.490.1831.8610.21289.0810393091.206.488.489.0328833403.41A786.8326.05112.923.200.4054.8412.29301.3711006861.206.868.869.0395834403.41Casa Maq.86.8326.05112.90.000.0000.002.15303.5211006861.206.868.869.0691TOTAL303.5288516Con formula ASMEAltura de presion (m)Espesor tuberia(mm)Peso(kg)PUNTONIVELProgresivaANCLAJEHidrosta.SobrepresionTotalAnguloAng.tuboDif.alt. tramoLong.tramoLong. Acum.PresionDiam.inter.Efic.junta=0.85Corros.+2Real(inc.+20%)N(golpe ariete)radmmmN/m2m1485.34Valvula4.901.476.40.000.0000.000.000.00621161.250.402.408.002485.34A14.901.476.40.000.0000.004.164.16621161.250.402.408.012393481.758.492.5511.024.010.4193.598.8212.981076061.250.692.698.026274478.0912.153.6515.824.010.4193.669.0021.981540291.250.992.998.026805474.4315.814.7420.624.010.4193.669.0030.982004531.251.293.298.026806470.7719.475.8425.324.010.4193.669.0039.982468761.251.593.598.026807467.1023.146.9430.124.010.4193.669.0048.982932991.251.903.908.026808463.4426.808.0434.824.010.4193.669.0057.983397231.252.204.208.026809459.7830.469.1439.624.010.4193.669.0066.983861461.252.504.508.0268010456.30A233.9410.1844.124.010.4193.488.5575.534302481.252.784.788.0254611456.2733.9710.1944.20.110.0020.0317.2992.824306691.252.794.798.0515012456.25A333.9910.2044.20.110.0020.029.00101.824308881.252.794.798.0268013454.6035.6410.6946.312.240.2141.657.80109.624518381.252.924.928.0232214452.6937.5511.2748.812.240.2141.919.00118.624760261.253.085.088.0268015450.7839.4611.8451.312.240.2141.919.00127.625002141.253.245.248.0268016448.8741.3712.4153.812.240.2141.919.00136.625244021.253.395.398.0268017446.9643.2812.9856.312.240.2141.919.00145.625485901.253.555.558.0268018445.0645.1813.5558.712.240.2141.919.00154.625727781.253.715.718.0268019443.1547.0914.1361.212.240.2141.919.00163.625969671.253.865.868.0268020441.2449.0014.7063.712.240.2141.919.00172.626211551.254.026.028.0268021439.63A450.6115.1865.812.240.2141.617.58180.196415161.254.156.158.0225622435.6354.6116.3871.018.240.3184.0012.78192.976922211.254.486.488.0380623432.8257.4217.2374.618.240.3182.829.00201.977279311.254.726.728.0268024430.0060.2418.0778.318.240.3182.829.00210.977636411.254.956.958.0268025427.1863.0618.9282.018.240.3182.829.00219.977993521.255.187.188.0268026424.3765.8719.7685.618.240.3182.829.00228.978350621.255.417.418.0268027421.5568.6920.6189.318.240.3182.829.00237.978707721.255.657.658.0268028418.7371.5121.4593.018.240.3182.829.00246.979064831.255.887.888.0268029415.9274.3222.3096.618.240.3182.829.00255.979421931.256.118.119.0301830412.01A578.2323.47101.718.240.3183.9012.47268.449916721.256.448.449.0418231410.1180.1324.04104.210.490.1831.9010.43278.8710157441.256.598.599.0349732408.25A681.9924.60106.610.490.1831.8610.21289.0810393091.256.758.759.0342433403.41A786.8326.05112.923.200.4054.8412.29301.3711006861.257.159.1512.0550834403.41Casa Maq.86.8326.05112.90.000.0000.002.15303.5211006861.257.159.1512.0962TOTAL303.5294146Con formula ASMEAltura de presion (m)Espesor tuberia(mm)Peso(kg)PUNTONIVELProgresivaANCLAJEHidrosta.SobrepresionTotalAnguloAng.tuboDif.alt. tramoLong.tramoLong. Acum.PresionDiam.inter.Efic.junta=0.85Corros.+2Real(inc.+20%)N(golpe ariete)radmmmN/m2m1485.34Valvula4.901.476.40.000.0000.000.000.00621161.300.422.428.002485.34A14.901.476.40.000.0000.004.164.16621161.300.422.428.012883481.758.492.5511.024.010.4193.598.8212.981076061.300.722.728.027314478.0912.153.6515.824.010.4193.669.0021.981540291.301.033.038.027875474.4315.814.7420.624.010.4193.669.0030.982004531.301.353.358.027876470.7719.475.8425.324.010.4193.669.0039.982468761.301.663.668.027877467.1023.146.9430.124.010.4193.669.0048.982932991.301.973.978.027878463.4426.808.0434.824.010.4193.669.0057.983397231.302.284.288.027879459.7830.469.1439.624.010.4193.669.0066.983861461.302.604.608.0278710456.30A233.9410.1844.124.010.4193.488.5575.534302481.302.894.898.0264811456.2733.9710.1944.20.110.0020.0317.2992.824306691.302.904.908.0535412456.25A333.9910.2044.20.110.0020.029.00101.824308881.302.904.908.0278713454.6035.6410.6946.312.240.2141.657.80109.624518381.303.045.048.0241414452.6937.5511.2748.812.240.2141.919.00118.624760261.303.205.208.0278715450.7839.4611.8451.312.240.2141.919.00127.625002141.303.375.378.0278716448.8741.3712.4153.812.240.2141.919.00136.625244021.303.535.538.0278717446.9643.2812.9856.312.240.2141.919.00145.625485901.303.695.698.0278718445.0645.1813.5558.712.240.2141.919.00154.625727781.303.865.868.0278719443.1547.0914.1361.212.240.2141.919.00163.625969671.304.026.028.0278720441.2449.0014.7063.712.240.2141.919.00172.626211551.304.186.188.0278721439.63A450.6115.1865.812.240.2141.617.58180.196415161.304.326.328.0234622435.6354.6116.3871.018.240.3184.0012.78192.976922211.304.666.668.0395723432.8257.4217.2374.618.240.3182.829.00201.977279311.304.916.918.0278724430.0060.2418.0778.318.240.3182.829.00210.977636411.305.157.158.0278725427.1863.0618.9282.018.240.3182.829.00219.977993521.305.397.398.0278726424.3765.8719.7685.618.240.3182.829.00228.978350621.305.637.638.0278727421.5568.6920.6189.318.240.3182.829.00237.978707721.305.877.878.0278728418.7371.5121.4593.018.240.3182.829.00246.979064831.306.118.119.0313829415.9274.3222.3096.618.240.3182.829.00255.979421931.306.368.369.0313830412.01A578.2323.47101.718.240.3183.9012.47268.449916721.306.698.699.0434831410.1180.1324.04104.210.490.1831.9010.43278.8710157441.306.868.869.0363632408.25A681.9924.60106.610.490.1831.8610.21289.0810393091.307.029.0212.0475733403.41A786.8326.05112.923.200.4054.8412.29301.3711006861.307.439.4312.0572634403.41Casa Maq.86.8326.05112.90.000.0000.002.15303.5211006861.307.439.4312.01000TOTAL303.5299435

JNG:Se duplica por ser dos ramalesJNG:Se duplica por ser dos ramalesJNG:Se duplica por ser dos ramalesJNG:Se duplica por ser dos ramalesJNG:Se duplica por ser dos ramalesJNG:Se duplica por ser dos ramalesJNG:Se duplica por ser dos ramalesJNG:Se duplica por ser dos ramalesJNG:Se duplica por ser dos ramalesJNG:Se duplica por ser dos ramalesJNG:Se duplica por ser dos ramalesJNG:Se duplica por ser dos ramalesJNG:Se duplica por ser dos ramalesJNG:Se duplica por ser dos ramales

COSTO TUBERIACOSTO FABRICACION E INSTALACION TUBERIAMoneda= US $Costo FabricacionCosto MontajeCosto Obras CivilesCOSTOCOSTODiametro(cm)PESO(kg)UnitarioSub totalUnitarioSub totalUnitarioSub totalTOTALANUAL10072752.014.00291008.061.5109128.022145504.03545,64067,73810576481.124.00305924.471.5114721.682152962.24573,60871,21011079618.164.00318472.621.5119427.232159236.31597,13674,13111573352.844.00293411.351.5110029.262146705.67550,14668,29712088516.314.00354065.241.5132774.472177032.62663,87282,41612594145.974.00376583.901.5141218.962188291.95706,09587,65713099434.814.00397739.241.5149152.222198869.62745,76192,582

DIA. ECO.Diametro (m)Costo Anual $Costo de Perdida $Costo Total $1.0067,73848098115,8361.0571,21038508109,7181.1074,13131163105,2941.1568,2972546793,7641.2082,41620998103,4141.2587,65717456105,1131.3092,58214621107,203Diametro Economico = 1.15 m

DIA. ECO.

Costo Anual de TuberiaCosto de Perdida de EnergiaCosto TotalDiametro (m)Costo Anual ($)Costo Anual ($) vs Diametro (m)

ExtraDiametro (m)Costo Total $Costo de Perdida $Costo Total $1.00545,640387438933,0781.05573,608310192883,8001.10597,136251027848,1641.15550,146205142755,2881.20663,872169146833,0181.25706,095140613846,7071.30745,761117776863,537Diametro Economico = 1.15 m

Extra1111.051.051.051.11.11.11.151.151.151.21.21.21.251.251.251.31.31.3

Costo Total de TuberiaCosto de Perdida de EnergiaCosto TotalDiametro (m)Costo ($)Costo Total ($) vs Diametro (m)

Hoja1Densidad Acero ASTMA367,850Longitud (m)Espesor (mm)Peso (Ton)Valor propuestaLongitud 1230.6896.442.1158.73Longitud 272.754816.62Propuesta62.3Valor calcualdoLongitud 1147.26.432.2459.35Calculado PEPSA59.35Longitud 265817.82Diferencia-2.95Longitud 328.59.59.29Diferencia %4.7352Costo Obras CivilesCOSTODiametro(cm)Costo FabricacionCosto MontajeSub totalUnitarioSub totalTOTAL115PESO(kg)UnitarioSub totalUnitario126093.309255892168124.41630466.55Nuevos soles84062.20617059374336248.821.5$1,762,784.462.796$940,151.71