ing costas tarea .xlsx

23
i H (m) T (s) Hi^2 Sumatoria Hi 1 2.320 8.74 5.382 Altura media de la ola 2 2.308 8.64 5.327 Simatoria Hi^2 3 2.154 9.61 4.640 Altura cuadrática media 4 2.104 9.8 4.427 Sumarotia Hi (77) 5 2.029 9.54 4.117 Altura de ola un medio 6 1.888 8.74 3.565 Sumatoria Hi (51) 7 1.716 8.74 2.945 Altura de ola un tercio 8 1.654 9.45 2.736 Sumatoria Hi (15) 9 1.636 10.6 2.676 Altura de ola un décimo 10 1.630 9.7 2.657 Altura de ola un centésimo 11 1.622 11.1 2.631 Tmax=T1=T1:154 12 1.589 8.27 2.525 Sumatoria T(154) 13 1.533 7.78 2.350 Periodo de ola media 14 1.533 10.18 2.350 Sumatoria T(77) 15 1.484 8.72 2.202 Periodo de ola un medio 16 1.484 10.61 2.202 Sumatoria T(51) 17 1.482 9.66 2.196 Periodo de ola un tercio 18 1.443 9.75 2.082 Sumatoria T(15) 19 1.433 10.06 2.053 Periodo de ola un décimo 20 1.414 7.87 1.999 Periodo de ola un centésim 21 1.412 8.72 1.994 22 1.398 9.22 1.954 23 1.388 9.51 1.927 24 1.380 8.10 1.904 25 1.347 9.32 1.814 Gravedad (m/s^2) 26 1.339 8.53 1.793 Densidad agua salada(kg(m^ 27 1.337 9.87 1.788 28 1.329 7.93 1.766 29 1.314 10.22 1.727 30 1.312 9.54 1.721 31 1.292 9.64 1.669 32 1.281 8.36 1.641 33 1.279 9.06 1.636 34 1.233 9.42 1.520 35 1.232 8.12 1.518 36 1.218 8.89 1.484 37 1.217 8.05 1.481 38 1.195 8.61 1.428 39 1.193 10.71 1.423 40 1.175 6.93 1.381 41 1.154 10.74 1.332 42 1.151 11.29 1.325

Upload: edgar-alejandro-jp

Post on 25-Sep-2015

12 views

Category:

Documents


2 download

TRANSCRIPT

Hoja1iH (m)T (s)Hi^2Sumatoria Hi139.252T^2L0C (L0/t) (m/s)E (N/s)12.3208.745.382Altura media de la ola 0.904233766276.3876119.16465613.63446765.172222.3088.645.327Simatoria Hi^2157.46874.6496116.45337613.47846695.368654532.1549.614.640Altura cuadrtica media 1.022516662392.3521144.06927614.99165831.68803862542.1049.84.427Sumarotia Hi (77)96.66796.04149.822415.2885564.09269852.0299.544.117Altura de ola un medio 1.255415584491.0116141.97809614.88245174.483183156261.8888.743.565Sumatoria Hi (51)72.56776.3876119.16465613.63444480.29763271.7168.742.945Altura de ola un tercio 1.420519480576.3876119.16465613.63443701.156530581.6549.452.736Sumatoria Hi (15)27.20089.3025139.311914.7423438.53853862591.63610.62.676Altura de ola un dcimo1.8047792208112.36175.281616.5363364.1045505101.6309.72.657Altura de ola un centsimo2.315792207894.09146.780415.1323339.474215625111.62211.12.631Tmax=T1=T1:1548.74123.21192.207617.3163306.774542625121.5898.272.525Sumatoria T(154)1280.0468.3929106.69292412.90123173.5889856562131.5337.782.350Periodo de ola media 8.311948051960.528494.42430412.13682953.8415521562141.53310.182.350Sumatoria T(77)713.73103.6324161.66654415.88082953.8415521562151.4848.722.202Periodo de ola un medio 9.269220779276.0384118.61990413.60322768.0293305161.48410.612.202Sumatoria T(51) 472.79112.5721175.61247616.55162768.0293305171.4829.662.196Periodo de ola un tercio 9.281298701393.3156145.57233615.06962760.573362625181.4439.752.082Sumatoria T(15)139.6195.0625148.297515.212617.1917821562191.43310.062.053Periodo de ola un dcimo 9.3411688312101.2036157.87761615.69362581.0431584062201.4147.871.999Periodo de ola un centsimo8.704935064961.936996.62156412.27722513.053328625211.4128.721.99476.0384118.61990413.60322505.9492945221.3989.221.95485.0084132.61310414.38322456.502602625231.3889.511.92790.4401141.08655614.83562421.4851945241.3808.101.90465.61102.351612.6362393.6522625251.3479.321.814Gravedad (m/s^2)9.8186.8624135.50534414.53922280.5420121562261.3398.531.793Densidad agua salada(kg(m^3)102572.7609113.50700413.30682253.5336106562271.3379.871.78897.4169151.97036415.39722246.8066484062281.3297.931.76662.884998.10044412.37082219.9993519062291.31410.221.727104.4484162.93950415.94322170.169303625301.3129.541.72191.0116141.97809614.88242163.568032311.2929.641.66992.9296144.97017615.03842098.1083545321.2818.361.64169.8896109.02777613.04162062.5341369062331.2799.061.63682.0836128.05041614.13362056.0987769062341.2339.421.52088.7364138.42878414.69521910.8607459062351.2328.121.51865.9344102.85766412.66721907.762472361.2188.891.48479.0321123.29007613.86841864.650587625371.2178.051.48164.8025101.091912.5581861.5900209062381.1958.611.42874.1321115.64607613.43161794.8935476562391.19310.711.423114.7041178.93839616.70761788.8905634062401.1756.931.38148.024974.91884410.81081735.3161914062411.15410.741.332115.3476179.94225616.75441673.842163625421.15111.291.325127.4641198.84399617.61241665.1506569062431.1349.241.28685.3776133.18905614.41441616.326133625441.1278.241.27067.8976105.92025612.85441596.4330784062451.1208.361.25469.8896109.02777613.04161576.6632461.11811.171.250124.7689194.63948417.42521571.037287625471.1009.401.21088.36137.841614.6641520.8565625481.0997.221.20852.128481.32030411.26321518.0926256562491.08811.181.184124.9924194.98814417.44081487.855232501.0836.861.17347.059673.41297610.70161474.2115146562511.06612.781.136163.3284254.79230419.93681428.292958625521.05910.951.121119.9025187.047917.0821409.5964781562531.0578.191.11767.0761104.63871612.77641404.2772509062541.0378.941.07579.9236124.68081613.94641351.6380171562551.0309.451.06189.3025139.311914.7421333.451840625561.02711.161.055124.5456194.29113617.40961325.6954721562571.00810.821.016117.0724182.63294416.87921277.097192580.9709.390.94188.1721137.54847614.64841182.623090625590.96910.050.939101.0025157.563915.6781180.1859494062600.9699.620.93992.5444144.36926415.00721180.1859494062610.9489.400.89988.36137.841614.6641129.5866745620.9309.020.86581.3604126.92222414.07121087.098215625630.9298.910.86379.3881123.84543613.89961084.7616269062640.9279.580.85991.7764143.17118414.94481080.0959909062650.9076.200.82338.4459.96649.6721033.9926696562Qu relacin encuentras entre H y E?660.9056.920.81947.886474.70278410.79521029.4376414062670.88610.090.785101.8081158.82063615.7404986.666378625680.8819.350.77687.4225136.379114.586975.5616119062690.8775.920.76935.046454.6723849.2352966.7230471562700.8547.390.72954.612185.19487611.5284916.681838625710.85311.070.728122.5449191.17004417.2692914.5362996562720.8539.960.72899.2016154.75449615.5376914.5362996562730.85310.130.728102.6169160.08236415.8028914.5362996562740.85010.150.723103.0225160.715115.834908.114765625Qu relacin tiene T y C?750.84410.210.712104.2441162.62079615.9276895.3395705760.84010.850.706117.7225183.647116.926886.87305770.8377.220.70152.128481.32030411.2632880.5495546562780.8379.300.70186.49134.924414.508880.5495546562790.83512.700.697161.29251.612419.812876.3464601562800.8309.870.68997.4169151.97036415.3972865.882715625810.82910.960.687120.1216187.38969617.0976863.7975081562820.8267.150.68251.122579.751111.154857.556968625En trminos de energa, Qu olas producirin ms problemas en la construccin del viaducto alterno del Puerto de Progreso?830.82110.640.674113.2096176.60697616.5984847.2063456562840.81812.170.669148.1089231.04988418.9852841.026137625850.78312.900.613166.41259.599620.124770.5953959062860.7834.360.61319.009629.6549766.8016770.5953959062870.7797.560.60757.153689.15961611.7936762.7422456562880.7629.530.58190.8209141.68060414.8668729.815072625890.7609.760.57895.2576148.60185615.2256725.98905900.7578.820.57377.7924121.35614413.7592720.2688696562910.7526.180.56638.192459.5801449.6408710.785512920.74110.600.549112.36175.281616.536690.1433406562930.7286.290.53039.564161.7199969.8124666.140202940.72811.400.530129.96202.737617.784666.140202950.7188.300.51668.89107.468412.948647.965337625960.7186.700.51644.8970.028410.452647.965337625970.71710.150.514103.0225160.715115.834646.1616771562980.7078.260.50068.2276106.43505612.8856628.2633321562990.7004.990.49024.900138.8441567.7844615.88406251000.69110.360.477107.3296167.43417616.1616600.14885315621010.6839.130.46683.3569130.03676414.2428586.33293965621020.6785.070.46025.704940.0996447.9092577.7796926251030.6739.120.45383.1744129.75206414.2272569.28929090621040.6624.710.43822.184134.6071967.3476550.8316226251050.66010.230.436104.6529163.25852415.9588547.50836251060.6575.760.43233.177651.7570568.9856542.54232590621070.65610.770.430115.9929180.94892416.8012540.8920081080.6527.170.42551.408980.19788411.1852534.31587451090.6327.850.39961.622596.131112.246502.0385221100.63111.210.398125.6641196.03599617.4876500.45104940621110.62610.710.392114.7041178.93839616.7076492.5513936251120.61711.060.381122.3236190.82481617.2536478.49038340621130.6147.070.37749.984977.97644411.0292473.8486286251140.59212.930.350167.1849260.80844420.1708440.5003921150.5898.780.34777.0884120.25790413.6968436.04717315621160.5834.320.34018.662429.1133446.7392427.20860840621170.5828.300.33968.89107.468412.948425.7443126251180.57611.850.332140.4225219.059118.486417.0113281190.5759.760.33195.2576148.60185615.2256415.56462890621200.5705.200.32527.0442.18248.112408.3688406251210.5655.440.31929.593646.1660168.4864401.23589765621220.5534.700.30622.0934.46047.332384.37324340621230.5508.630.30374.4769116.18396413.4628380.2141406251240.54312.080.295145.9264227.64518418.8448370.59755090621250.5288.290.27968.7241107.20959612.9324350.4053521260.51711.460.267131.3316204.87729617.8776335.95721465621270.5089.650.25893.1225145.271115.054324.36225451280.5075.020.25725.200439.3126247.8312323.08649465621290.5029.410.25288.5481138.13503614.6796316.7454026251300.4905.380.24028.944445.1532648.3928301.7831906251310.4897.460.23955.651686.81649611.6376300.55267940621320.4858.940.23579.9236124.68081613.9464295.65577265621330.4814.510.23120.340131.7305567.0356290.79908690621340.4783.690.22813.616121.2411165.7564287.1829676251350.4644.610.21521.252133.1532767.1916270.6068881360.4415.040.19425.401639.6264967.8624244.44438440621370.4244.400.18019.3630.20166.864225.9615781380.3725.540.13830.691647.8788968.6424173.93571451390.3486.980.12148.720476.00382410.8888152.21637451400.3425.700.11732.4950.68448.892147.0127826251410.3055.300.09328.0943.82048.268116.92370390621420.2926.400.08540.9663.89769.984107.16885451430.2734.440.07519.713630.7532166.926493.67596590621440.2673.450.07111.902518.56795.38289.60358965621450.2512.690.0637.236111.2883164.196479.18635065621460.2472.850.0618.122512.67114.44676.68259340621470.2385.290.05727.984143.6551968.252471.1961976251480.1994.090.04016.728126.0958366.380449.77474440621490.1652.360.0275.56968.6885763.681634.21927265621500.1573.210.02510.304116.0743965.007630.98148215621510.1502.480.0236.15049.5946243.868828.2803906251520.1362.170.0184.70897.3458843.385223.2477381530.1002.490.0106.20019.6721563.884412.56906251540.0902.210.0084.88417.6191963.447610.180940625

Analizando bien las 2, podemos identificar primero que nada la H es la altura y E la energa de la ola. Por lo que la energa de la ola es proporcional a su altura. Un ejemplo de esto es que a mayor altura tiende a haber ms energa dentro de la ola, por lo que es ms fuerte.Puedo decir que al igual que la pregunta anterior a mayor tiempo, mayor velocidad, por lo que concluyo que es debido a que le da mas tiempo a la ola de agarrar velocidad.Yo pienso en que las olas que nos pueden afectar mucho podran ser las olas con mayor altura, energa y velocidad, digo esto por el choque que pueda tener las olas con la construccin sera muy incomodo y tendran que hacer estudios sobre el mar en el cual construyes para optimizar desde los cimientos, hasta la finalizacin de la obra

Hoja2H(m)T(s)H^2T^2L0 (m)C (m/s)E (N/S)2.3208.745.382476.3876119.16465613.634402.3088.645.32686474.6496116.45337613.478402.1549.614.63971692.3521144.06927614.991602.1049.84.42681696.04149.822415.28802.0299.544.11684191.0116141.97809614.882401.8888.743.56454476.3876119.16465613.634401.7168.742.94465676.3876119.16465613.634401.6549.452.73571689.3025139.311914.74201.63610.62.676496112.36175.281616.53601.6309.72.656994.09146.780415.13201.62211.12.630884123.21192.207617.31601.5898.272.52492168.3929106.69292412.901201.5337.782.35008960.528494.42430412.136801.53310.182.350089103.6324161.66654415.880801.4848.722.20225676.0384118.61990413.603201.48410.612.202256112.5721175.61247616.551601.4829.662.19632493.3156145.57233615.069601.4439.752.08224995.0625148.297515.2101.43310.062.053489101.2036157.87761615.693601.4147.871.99939661.936996.62156412.277201.4128.721.99374476.0384118.61990413.603201.3989.221.95440485.0084132.61310414.383201.3889.511.92654490.4401141.08655614.835601.3808.101.904465.61102.351612.63601.3479.321.81440986.8624135.50534414.539201.3398.531.79292172.7609113.50700413.306801.3379.871.78756997.4169151.97036415.397201.3297.931.76624162.884998.10044412.370801.31410.221.726596104.4484162.93950415.943201.3129.541.72134491.0116141.97809614.882401.2929.641.66926492.9296144.97017615.038401.2818.361.64096169.8896109.02777613.041601.2799.061.63584182.0836128.05041614.133601.2339.421.52028988.7364138.42878414.695201.2328.121.51782465.9344102.85766412.667201.2188.891.48352479.0321123.29007613.868401.2178.051.48108964.8025101.091912.55801.1958.611.42802574.1321115.64607613.431601.19310.711.423249114.7041178.93839616.707601.1756.931.38062548.024974.91884410.810801.15410.741.331716115.3476179.94225616.754401.15111.291.324801127.4641198.84399617.612401.1349.241.28595685.3776133.18905614.414401.1278.241.27012967.8976105.92025612.854401.1208.361.254469.8896109.02777613.041601.11811.171.249924124.7689194.63948417.425201.1009.401.2188.36137.841614.66401.0997.221.20780152.128481.32030411.263201.08811.181.183744124.9924194.98814417.440801.0836.861.17288947.059673.41297610.701601.06612.781.136356163.3284254.79230419.936801.05910.951.121481119.9025187.047917.08201.0578.191.11724967.0761104.63871612.776401.0378.941.07536979.9236124.68081613.946401.0309.451.060989.3025139.311914.74201.02711.161.054729124.5456194.29113617.409601.00810.821.016064117.0724182.63294416.879200.9709.390.940988.1721137.54847614.648400.96910.050.938961101.0025157.563915.67800.9699.620.93896192.5444144.36926415.007200.9489.400.89870488.36137.841614.66400.9309.020.864981.3604126.92222414.071200.9298.910.86304179.3881123.84543613.899600.9279.580.85932991.7764143.17118414.944800.9076.200.82264938.4459.96649.67200.9056.920.81902547.886474.70278410.795200.88610.090.784996101.8081158.82063615.740400.8819.350.77616187.4225136.379114.58600.8775.920.76912935.046454.6723849.235200.8547.390.72931654.612185.19487611.528400.85311.070.727609122.5449191.17004417.269200.8539.960.72760999.2016154.75449615.537600.85310.130.727609102.6169160.08236415.802800.85010.150.7225103.0225160.715115.83400.84410.210.712336104.2441162.62079615.927600.84010.850.7056117.7225183.647116.92600.8377.220.70056952.128481.32030411.263200.8379.300.70056986.49134.924414.50800.83512.700.697225161.29251.612419.81200.8309.870.688997.4169151.97036415.397200.82910.960.687241120.1216187.38969617.097600.8267.150.68227651.122579.751111.15400.82110.640.674041113.2096176.60697616.598400.81812.170.669124148.1089231.04988418.985200.78312.900.613089166.41259.599620.12400.7834.360.61308919.009629.6549766.801600.7797.560.60684157.153689.15961611.793600.7629.530.58064490.8209141.68060414.866800.7609.760.577695.2576148.60185615.225600.7578.820.57304977.7924121.35614413.759200.7526.180.56550438.192459.5801449.640800.74110.600.549081112.36175.281616.53600.7286.290.52998439.564161.7199969.812400.72811.400.529984129.96202.737617.78400.7188.300.51552468.89107.468412.94800.7186.700.51552444.8970.028410.45200.71710.150.514089103.0225160.715115.83400.7078.260.49984968.2276106.43505612.885600.7004.990.4924.900138.8441567.784400.69110.360.477481107.3296167.43417616.161600.6839.130.46648983.3569130.03676414.242800.6785.070.45968425.704940.0996447.909200.6739.120.45292983.1744129.75206414.227200.6624.710.43824422.184134.6071967.347600.66010.230.4356104.6529163.25852415.958800.6575.760.43164933.177651.7570568.985600.65610.770.430336115.9929180.94892416.801200.6527.170.42510451.408980.19788411.185200.6327.850.39942461.622596.131112.24600.63111.210.398161125.6641196.03599617.487600.62610.710.391876114.7041178.93839616.707600.61711.060.380689122.3236190.82481617.253600.6147.070.37699649.984977.97644411.029200.59212.930.350464167.1849260.80844420.170800.5898.780.34692177.0884120.25790413.696800.5834.320.33988918.662429.1133446.739200.5828.300.33872468.89107.468412.94800.57611.850.331776140.4225219.059118.48600.5759.760.33062595.2576148.60185615.225600.5705.200.324927.0442.18248.11200.5655.440.31922529.593646.1660168.486400.5534.700.30580922.0934.46047.33200.5508.630.302574.4769116.18396413.462800.54312.080.294849145.9264227.64518418.844800.5288.290.27878468.7241107.20959612.932400.51711.460.267289131.3316204.87729617.877600.5089.650.25806493.1225145.271115.05400.5075.020.25704925.200439.3126247.831200.5029.410.25200488.5481138.13503614.679600.4905.380.240128.944445.1532648.392800.4897.460.23912155.651686.81649611.637600.4858.940.23522579.9236124.68081613.946400.4814.510.23136120.340131.7305567.035600.4783.690.22848413.616121.2411165.756400.4644.610.21529621.252133.1532767.191600.4415.040.19448125.401639.6264967.862400.4244.400.17977619.3630.20166.86400.3725.540.13838430.691647.8788968.642400.3486.980.12110448.720476.00382410.888800.3425.700.11696432.4950.68448.89200.3055.300.09302528.0943.82048.26800.2926.400.08526440.9663.89769.98400.2734.440.07452919.713630.7532166.926400.2673.450.07128911.902518.56795.38200.2512.690.0630017.236111.2883164.196400.2472.850.0610098.122512.67114.44600.2385.290.05664427.984143.6551968.252400.1994.090.03960116.728126.0958366.380400.1652.360.0272255.56968.6885763.681600.1573.210.02464910.304116.0743965.007600.1502.480.02256.15049.5946243.868800.1362.170.0184964.70897.3458843.385200.1002.490.016.20019.6721563.884400.0902.210.00814.88417.6191963.44760