cálculo Óptimo de tuberia forzada

Upload: omunnoz

Post on 02-Nov-2015

229 views

Category:

Documents


0 download

DESCRIPTION

excel de calculo para una centra hidroeletrica

TRANSCRIPT

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