5
r R f 0 10921912 0.008 7.03829867173454,0.4 7.03829867 0 7214823.38 0.0085 6.8582257040903,0.425 6.8582257 0 4931911.03 0.009 6.69301523370867,0.45 6.69301523 0 3472991.17 0.0095 6.54070367926238,0.475 6.54070368 0 2510000 0.01 6.39967372148104,0.5 6.39967372 0 1856006.26 0.0105 6.26857943668873,0.525 6.26857944 0 1400523.26 0.011 6.14629032512989,0.55 6.14629033 0 1076090.61 0.0115 6.0318488425058,0.575 6.03184884 0 840306.541 0.012 5.92443774433361,0.6 5.92443774 0 665816.679 0.0125 5.82335466997659,0.625 5.82335467 0 534554.687 0.013 5.72799214186277,0.65 5.72799214 0 434331.839 0.0135 5.63782166635289,0.675 5.63782167 0 356763.961 0.014 5.5523809772845,0.7 5.55238098 0 295980.918 0.0145 5.47126371305055,0.725 5.47126371 r R f 0.06 -1735.4831 0.008 Err:502 0.06 -1734.4017 0.00801 Err:502 5.25402032 0.06 -1733.3223 0.00802 Err:502 5.1779309 0.06 -1732.2449 0.00803 Err:502 5.10679041 0.06 -1731.1696 0.00804 Err:502 5.03989797 0.06 -1730.0962 0.00805 Err:502 4.97670791 0.06 -1729.0249 0.00806 Err:502 4.91678549 0.06 -1727.9556 0.00807 Err:502 4.8597774 0.06 -1726.8883 0.00808 Err:502 4.80539163 0.06 8.2917698 1.008 0.918647236318327,50.4 4.75338322 0.06 8.29167897 1.00801 0.91864247930864,50.4005 4.70354406 0.06 8.29158815 1.00802 0.918637722359848,50.401 4.65569536 0.06 8.29149733 1.00803 0.918632965471952,50.4015 4.60968194 0.06 8.29140652 1.00804 0.918628208644948,50.402 4.565368 0.06 8.2913157 1.00805 0.918623451878837,50.4025 0.06 8.2917698 1.008 0.918647236318327,50.4 0.06 8.29167897 1.00801 0.91864247930864,50.4005 0.06 8.29158815 1.00802 0.918637722359848,50.401 0.06 8.29149733 1.00803 0.918632965471952,50.4015 0.06 8.29140652 1.00804 0.918628208644948,50.402 r R f #VALUE! R= 2.51/(√f×(10^((-1)/(2√f))-r/3.71) )

Trabajo de Diagrama

Embed Size (px)

Citation preview

Hoja1R= 2.51/(f(10^((-1)/(2f))-r/3.71) )rRf010921911.96774060.0087.03829867173454,0.47.038298671707214823.382113290.00856.8582257040903,0.4256.85822570416.8582257040903,0.42504931911.032717230.0096.69301523370867,0.456.69301523376.69301523370867,0.4503472991.171071010.00956.54070367926238,0.4756.54070367936.54070367926238,0.475025100000.016.39967372148104,0.56.39967372156.39967372148104,0.501856006.260001990.01056.26857943668873,0.5256.26857943676.26857943668873,0.52501400523.257141620.0116.14629032512989,0.556.14629032516.14629032512989,0.5501076090.611884960.01156.0318488425058,0.5756.03184884256.0318488425058,0.5750840306.5413891530.0125.92443774433361,0.65.92443774435.92443774433361,0.60665816.6786202710.01255.82335466997659,0.6255.823354675.82335466997659,0.6250534554.6870611060.0135.72799214186277,0.655.72799214195.72799214186277,0.650434331.8385621610.01355.63782166635289,0.6755.63782166645.63782166635289,0.6750356763.9611778110.0145.5523809772845,0.75.55238097735.5523809772845,0.70295980.918147250.01455.47126371305055,0.7255.47126371315.47126371305055,0.725rRf0.06-1735.48310751020.008ERROR:#NUM!0.06-1734.40167037850.00801ERROR:#NUM!5.25402032175.25402032166519,0.8350.06-1733.32227163580.00802ERROR:#NUM!5.17793090255.17793090254451,0.860.06-1732.24490500640.00803ERROR:#NUM!5.10679041475.10679041467007,0.8850.06-1731.16956424220.00804ERROR:#NUM!5.03989796675.03989796667134,0.910.06-1730.09624312260.00805ERROR:#NUM!4.97670790974.97670790974076,0.9350.06-1729.0249354540.00806ERROR:#NUM!4.91678548934.91678548934321,0.960.06-1727.955635070.00807ERROR:#NUM!4.85977740314.85977740305292,0.9850.06-1726.8883358310.00808ERROR:#NUM!4.80539162784.80539162775363,1.010.068.29176979651.0080.918647236318327,50.44.75338321724.75338321723521,1.0350.068.29167897381.008010.91864247930864,50.40054.70354406344.70354406339098,1.060.068.29158815321.008020.918637722359848,50.4014.6556953594.65569535897006,1.0850.068.29149733481.008030.918632965471952,50.40154.60968194494.60968194487122,1.110.068.29140651851.008040.918628208644948,50.4024.56536799944.5653679994123,1.1350.068.29131570441.008050.918623451878837,50.40255.25402032170.060.068.29176979651.0080.918647236318327,50.45.17793090250.310.068.29167897381.008010.91864247930864,50.40055.10679041470.810.068.29158815321.008020.918637722359848,50.4015.03989796670.8350.068.29149733481.008030.918632965471952,50.40154.97670790970.860.068.29140651851.008040.918628208644948,50.4024.91678548930.8854.85977740310.914.80539162780.9354.75338321720.96rRfERROR:#VALUE!4.70354406340.9850.005-53763.43441735410.0012ERROR:#NUM!4.6556953591.010.0001-1202566.47632040.0062ERROR:#NUM!4.60968194491.0350.0001216762.4941820770.01625.33598413958745,0.814.56536799941.060.0001179481.7608625330.01675.25402032166519,0.8350.0001150636.7379895620.01725.17793090254451,0.860.0001127876.4038974930.01775.10679041467007,0.8850.0001109622.0619352330.01825.03989796667134,0.910.000194778.0806896540.01874.97670790974076,0.9350.000182563.00461911810.01924.91678548934321,0.960.000172406.47467145280.01974.85977740305292,0.9850.000163883.93038485780.02024.80539162775363,1.010.000156673.91535958990.02074.75338321723521,1.0350.000150529.39093115710.02124.70354406339098,1.060.000145258.0000907120.02174.65569535897006,1.0850.000140708.20424852420.02224.60968194487122,1.110.000136759.36490330360.02274.5653679994123,1.1350.000133314.53079649520.02324.52263370102219,1.16rRfERROR:#VALUE!0.005-20257.50012921080.0085ERROR:#NUM!0.0001-1174528.569411060.008501ERROR:#NUM!0.0001-1174600.080428820.008502ERROR:#NUM!0.0001-1225760.573816650.009002ERROR:#NUM!0.0001-1318450.65067750.009502ERROR:#NUM!0.0001-1481319.360213320.010002ERROR:#NUM!0.0001-1782288.60958810.010502ERROR:#NUM!0.0001-2429591.416765460.011002ERROR:#NUM!0.0001-4515474.343492570.011502ERROR:#NUM!-0.00098888897.85469235511.0090.895129179687409,50.45-0.00131555567.77001332711.0190.890421763703038,50.95-0.00164222227.03647048691.1190.847354870443426,55.95-0.00196888897.03135590641.11950.84703908119378,55.975-0.00229555567.0262482541.120.84672349038297,56-0.00262222227.0211475161.12050.846408097760067,56.025-0.00294888897.01605367851.1210.846092903074616,56.05-0.00327555567.01096672791.12150.845777906076636,56.075-0.00360222227.00588665061.1220.845463106516613,56.1-0.00392888893.98024095742.0090.599909364360245,100.45