Hoja1COEFICIENTES PRIMERA HIPOTESISCOEFICIENTES SEGUNDA HIPTESISDatos de Trabajo del ConductorExiste Vano Crtico entre Hiptesis I y II?Existe Vano Crtico entre Hiptesis I y III?Hiptesis I con IIHiptesis I con IIIA2B2A3B3Formula2Vale HastaFormula3Vale HastaHiptesis II con IHiptesis II con IIIA1B1A3B3Formula 1Vale HastaFormula 3Vale hastaHiptesis III con IHiptesis III con IIA1B1A2B2Formula 1Vale HastaFormula 3Vale hastaVariableUnidadesValorVanokg%TRSe cumplekg%TRSe cumplekg%TRSe cumplekg%TRSe cumplekg%TRSe cumplekg%TRSe cumpleSeccin TotalA(mm^2)557Trmino A=0.0086519738Trmino A=0.0158228654??????DimetroD (mm)30.66Trmino B=-2765.62Trmino B=-1092.0291753105512.548894872743.85131568594231.632588306233.6618613341-4408.139115685533561020081.4507-2357.418290685433561020081.450700004490.04032856435.71744752662860.868275024222.7576825632-811.064429087274169854380.00591239.656395912833561020081.450701014893.221098468338.92467662453948.342092199731.4083373813-1795.53257284774169854380.0059-1795.53257284733561020081.45070100Mdulo de ElasticidadE(kg/mm^2)6403506258.948136705149.7887847964234.628356653233.685692122-6236.6612673175873075444.366562-4185.9404423175873075444.36656200003598.422792552728.62479351331700.584946454313.5278414323-3449.41133270261929496732.0501-1398.6905077026873075444.36656201015177.065678727941.18260821525138.145295522640.8730037031-5105.07492874211929496732.0501-5105.0749287421873075444.3665620100Coeficiente de Dilatacin (1/C)0.000023Vano Crtico=ERROR:#NUM!Vano CrticoERROR:#NUM!756226.285801434149.52896190784234.449108439433.6842662353-6175.61285146441964419749.82477-4124.89202646441964419749.8247700003681.619473070429.2866078521871.4780426214.8872646776-3361.32549858084341367647.11273-1310.60467358081964419749.8247701015157.773263629641.02914059055070.972737402340.33865832-4994.58005841984341367647.11273-4994.58005841981964419749.824770100Pesow(kg/m)1.5331006181.539241526749.17301122844234.214018266833.6823961361-6090.14506927013492301777.46625-4039.42424427013492301777.4662500003778.571390865230.05784258112032.588410445116.1688681127-3238.00533081037717986928.20041-1187.28450581033492301777.4662501015132.834545773340.83075766274980.665935845139.6202842721-4839.88723996857717986928.20041-4839.88723996853492301777.466250100Carga de RoturaCR (kg)125711256125.677707745448.72864296994233.936078629433.6801851772-5980.25792073455456721527.29101-3929.53709573455456721527.2910100003880.355770824630.86751866062178.507330153417.3296263635-3079.450829391112059354575.3131-1028.73000439115456721527.2910101015103.926401204740.60079867324870.981146278738.7477618827-4640.996473388212059354575.3131-4640.99647338825456721527.2910101001506059.924817332648.2055907834233.628756557133.6777404865-5845.95140585777857678999.29906-3795.23058085777857678999.2990600003981.250632002531.67011878132308.898035684618.3668605177-2885.661994323217365470588.4509-834.94116932327857678999.2990601015072.746782630440.35277052454746.660718708137.7588156766-4397.90775867917365470588.4509-4397.9077586797857678999.2990601001755985.73173089347.61539838434233.304689422433.6751625919-5687.225524639610695174193.4904-3636.504699639610695174193.490400004077.963831624632.43945455112424.852750570519.2892590134-2656.638825606623636334967.6138-605.918000606610695174193.490401015040.823024224240.09882287984613.180084816336.6970017088-4110.621095840923636334967.6138-4110.621095840910695174193.49040100Condiciones Ambientales 2005904.735541472846.97108854884232.974813138933.6725384865-5504.080277080313969207109.865-3453.359452080313969207109.86500004168.792445595533.16197952112527.815611455320.1083096926-2392.381323241330871947712.8016-341.660498241313969207109.86501015009.389480367339.84877480214476.298451845835.608133417-3779.136484873930871947712.8016-3779.136484873913969207109.8650100VariableUnidadesValorExiste Vano Crtico entre Hiptesis II y I?Existe Vano Crtico entre Hiptesis II y III?2255818.701047444546.2866999244232.647936278933.669938241-5296.515663179817679777748.4229-3245.794838179817679777748.422900004253.005771163333.83188108472619.239543121620.8355703056-2092.889487227339072308824.0146-42.168662227317679777748.422901014979.341540894839.60974895314341.459309965734.5355127672-3403.453925777939072308824.0146-3403.453925777917679777748.42290100Temperatura Mnima AmbienteC102505729.447039887845.57670065944232.330677767333.6674145077-5064.53168293821826886109.1641-3013.81085793821826886109.164100004330.446290588134.44790621742700.475056538821.4817839196-1758.163317564548237418301.2526292.557507435521826886109.164101014951.251586192139.3862985144213.18996762233.5151536681-2983.573418552948237418301.2526-2983.573418552921826886109.16410100Temperatura Media AmbienteC35Trmino A=-0.0086519738Trmino A=0.00717089162755638.762141680844.8553189224232.027647901133.6650039607-4808.12833635526410532192.0885-2757.40751135526410532192.088500004401.283433783735.01140270292772.738854388922.0566291814-1388.202814253158367276144.5156662.518010746926410532192.088501014925.422229714239.18083071924094.691562422332.5725205825-2519.49496319958367276144.5156-2519.49496319926410532192.08850100Temperatura Mxima AmbienteC60Trmino B=2765.62Trmino B=1673.5908253005548.318994561744.13586027024231.74175782533.6627297576-4527.305623430731430715997.1962-2476.584798430731430715997.196200004465.864125309335.52513026262837.111412673822.5687010793-983.007977292969461882353.80371067.712847707131430715997.196201014901.953200382938.99413889413987.737886970631.7217237051-2011.218559716269461882353.8037-2011.218559716231430715997.19620100Presin del Viento Mximakg/m^2553255459.5977165143.43009877114231.474569724733.6606043252-4222.063544165236887437524.4873-2171.342719165236887437524.487300004524.622625971335.99254336152894.545156622123.0255759814-542.57880668481521236929.11681508.14201831636887437524.487301014880.805414869838.8259121383892.85920881830.9669812172-1458.744208104481521236929.1168-1458.744208104436887437524.48730100Vano Crtico=ERROR:#NUM!Vano Crtico483.1011428673505373.82887143542.74782333494231.226631722633.6586320239-3892.402098558542780696773.9616-1841.681273558542780696773.961600004578.02646637236.41736111982945.876172886923.4339048038-66.915302426494545339870.4551983.805522573642780696773.961601014861.853895046638.67515627273809.682977901330.3053295514-862.071908363794545339870.455-862.071908363742780696773.96160100Hiptesis IHiptesis IIHiptesis IIIHiptesis IV3755291.962599239142.09659215054230.997768305233.6568114574-3538.321286610549110493745.6191-1487.600461610549110493745.619100004626.544441389536.80331271492991.836633367623.7995118397443.9825354798108534191177.8182494.703360479849110493745.619101014844.927258142538.54050797983737.292598570629.7294773572-221.2016604941108534191177.818-221.201660494149110493745.61910100Tensin6285.5Tensin3519.88Tensin3142.75Tensin-4005214.665228659241.48170574074230.787315939633.6551373474-3159.821108321355876828439.46-1109.100283321355876828439.4600004670.62818469837.15399080983033.066780105924.1274900971990.1147070348123487790851.2073040.835532034955876828439.4601014829.834927296938.42045125523674.518430160329.2301203577463.8665355045123487790851.207463.866535504555876828439.460100Peso2.278968339Peso1.533Peso1.533Peso1.5334255142.339534755840.90636810724230.594304831933.6536019794-2756.901563690863079700855.4841-706.180738690863079700855.484100004710.702148980437.47277184773070.126015408424.42228951881571.4812122386139406138890.623622.202037238663079700855.484101014816.384569523238.31345612543620.135235617228.79751201671193.132679632139406138890.621193.13267963263079700855.48410100Temperatura Ambiente10Temperatura Ambiente10Temperatura Ambiente35Temperatura 60Existe Vano Crtico entre Hiptesis III y I?Existe Vano Crtico entre Hiptesis III y II?4505075.161424603940.37197855864230.417593424833.6521962726-2329.562652719170719110993.6915-278.841827719170719110993.691500004747.158793992737.76277777423103.502942443324.68779685342188.082051091156289235296.0584238.80287609170719110993.691501014804.392417818738.21806075743572.977003291728.42237692541966.5967718885156289235296.0581966.596771888570719110993.691501004755013.124863865539.87848909294230.255964231133.650910542-1877.804375406278795058854.0823172.916449593978795058854.082300004780.356980562638.02686326123133.624337215824.92740702582839.9172235921174137080067.5224890.638048592178795058854.082301014793.688740335538.13291496573531.992618720128.0963536612784.2588122739174137080067.5222784.258812273978795058854.08230100Trmino A=-0.0158228654Trmino A=-0.00717089165004956.087896710439.42477047744230.108189547833.6497350215-1401.62673175287307544436.6562649.09409324887307544436.656200004810.622303772838.26761835793160.863095579625.14408635413526.986729742192949673205.015577.707554741987307544436.656201004784.120177586438.05679880353496.264692178727.81214455633646.1188007883192949673205.013646.118800788387307544436.65620101Trmino B=1092.029175Trmino B=-1673.5908255254903.814728618939.00894700994229.973074560233.6486602065-901.029721756596256567741.41351149.691103243596256567741.413500004838.248558069338.48738014533185.545227762325.340428194249.2905695405212727014708.5246300.011394540596256567741.413501004775.550165864337.98862593163465.007991771127.56350323584552.1767374316212727014708.5244552.176737431696256567741.413501015504856.011122035338.62867808484229.849483988933.6476770662-376.0133454199105642128768.3541674.7074795801105642128768.35400004863.499818696738.68824929363207.955984874425.51870165365006.8287429878233469104578.0627057.5495679878105642128768.35401004767.858265695737.92743827623437.558038944627.34514389425502.4326222038233469104578.0625502.4326222038105642128768.3540101Vano Crtico=ERROR:#NUM!Vano Crtico483.1011428675754812.352218934338.28137951584229.736357080733.6467771624173.422397258115464227517.4782224.143222258115464227517.47800004886.612811447638.8721089133228.345204974125.6808941615799.6012500837255175942813.6267850.3220750837115464227517.47801004760.938923009537.87239617383413.356009738727.15262118966496.886455105255175942813.6266496.886455105115464227517.47801016004772.503142915437.96438742284229.632714567933.6459527052747.2775062772125722863988.7852797.9983312772125722863988.78500004907.799364561339.04064405823246.931964431225.82874842446627.6080908284277847529415.2158678.3289158284125722863988.78501004754.699989846637.82276660453391.933214498626.98220678157535.5382361352277847529415.2157535.5382361352125722863988.78501016254736.133389913637.67507270634229.537660258533.64519656561345.5519816376136418038182.2753396.2728066376136418038182.27500004927.248816253139.19536088023263.908615723625.96379457267490.8492652218301483864382.8299541.5700902218136418038182.27501004749.061198272237.77791105143372.896719614326.83077495528618.3879652942301483864382.8298618.3879652942136418038182.27501016504702.926245411837.41091596064229.450379170733.64450226051968.2458233392147549750097.9494018.9666483392147549750097.94900004945.130303517839.3376048327ERROR:#NUM!ERROR:#NUM!8389.3247732639326084947716.46710440.0455982639147549750097.94901ERROR:#NUM!ERROR:#NUM!4743.952695652937.73727384983355.916724410426.69570220679745.4356425822326084947716.4679745.4356425822147549750097.9490101Precise aqu el vano=3206754672.584433603337.16955241114229.370133558933.64386392142615.359031382159117999735.8064666.079856382159117999735.80600004961.594891906139.4685776144ERROR:#NUM!ERROR:#NUM!9323.0346149547351650779416.13111373.7554399547159117999735.80601ERROR:#NUM!ERROR:#NUM!4739.313696158437.7003714594ERROR:#NUM!ERROR:#NUM!10916.6812679992351650779416.13110916.6812679992159117999735.80601ERROR:#NUM!ERROR:#NUM!Parmetro en Caliente para dicho vano=2388.93829528947004644.833042023136.94879517964229.296257762533.6432762533286.8916057661171122787095.8465337.6124307662171122787095.84600004976.777528007839.5893527007ERROR:#NUM!ERROR:#NUM!10291.9787902942378181359481.8212342.6996152942171122787095.84601ERROR:#NUM!ERROR:#NUM!4735.091271143237.6667828426ERROR:#NUM!ERROR:#NUM!12132.1248415451378181359481.8212132.1248415451171122787095.84601ERROR:#NUM!ERROR:#NUM!7254619.42056037236.74664354764229.228152504533.64273448813982.8435464915183564112178.076033.5643714915183564112178.0700004990.798810393139.7008894312ERROR:#NUM!ERROR:#NUM!11296.1572992824405676687913.53413346.8781242824183564112178.0701ERROR:#NUM!ERROR:#NUM!4731.239282366437.6361409782ERROR:#NUM!ERROR:#NUM!13391.7663632199405676687913.53413391.7663632199183564112178.0701ERROR:#NUM!ERROR:#NUM!XYX en Escala 200Y en Escala 5007504596.118673078736.56128130684229.165279054433.64223434144703.2148535581196441974982.4776753.9356785581196441974982.47700005003.766583418839.8040456878ERROR:#NUM!ERROR:#NUM!12335.5701419194434136764711.27314386.2909669194196441974982.47701ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!14695.6058330237434136764711.27314695.6058330237196441974982.477ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!12000-179046.00129484360-358.09200258977754574.721273752236.39106891864229.10715351833.64177196345448.0055269659209756375509.0677498.7263519659209756375509.06700005015.777363398139.8995892403ERROR:#NUM!ERROR:#NUM!13410.217318205463561589875.03715460.938143205209756375509.06701ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!16043.6432509564463561589875.03716043.6432509564209756375509.067ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!11800-164476.18338159259-328.95236676328004555.043032572836.23453211824229.053341411233.64134389796217.215566715223507313757.848267.936391715223507313757.8400005026.917609360139.9882078543ERROR:#NUM!ERROR:#NUM!14520.0988281394493951163404.82616570.8196531394223507313757.8401ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!17435.8786170181493951163404.82617435.8786170181223507313757.84ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!11600-151076.59038777858-302.15318077568254536.917743274336.09034876524229.003452607233.64094704177010.8449728053237694789728.7979061.5657978053237694789728.7970000ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!15665.2146717225525305485300.6417715.9354967225237694789728.797ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!18872.3119312086525305485300.6418872.3119312086237694789728.797ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!11400-138753.25098209857-277.50650196428504520.196599709235.95733513414228.957136696133.64057860717828.8937452368252318803421.9379879.6145702368252318803421.9370000ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!16845.5648489542557624555562.4818896.2856739542252318803421.937ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!20352.9431935282557624555562.4820352.9431935282252318803421.937ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!11200-127419.74159851256-254.8394831978754504.74649731735.83443240254228.914078765833.64023608918671.3618840096267379354837.2610722.0827090096267379354837.260000ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!18061.1493598347590908374190.34420111.8701848347267379354837.26ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!21877.7724039767590908374190.34421877.7724039767267379354837.26ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!11000-116996.58034786355-233.99316069579004490.44841677835.72069379354228.873995596133.63991723499538.2493891236282876443974.76611588.9702141236282876443974.7660000ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!19311.9682043639625156941184.23321362.6890293639282876443974.766ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!23446.7995625541625156941184.23323446.7995625541282876443974.766ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!10800-107410.66961147354-214.82133922299254477.195921312235.6152726224228.836632241833.639620016210429.5562605789298810070834.45612480.2770855789298810070834.4560000ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!20598.0213825418660370256544.14822648.7422075418298810070834.456ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!25060.0246692605660370256544.14825060.0246692605298810070834.456ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!10600-98594.78340762653-197.18956681539504464.893781985735.5174113594ERROR:#NUM!ERROR:#NUM!11345.2824983754315180235416.32913396.0033233754315180235416.32900ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!21919.3088943684696548320270.08723970.0297193684315180235416.329ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!26717.4477240958696548320270.08726717.4477240958315180235416.329ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!10400-90487.095935823652-180.97419187169754453.456734405135.4264317429ERROR:#NUM!ERROR:#NUM!12285.4281025132331986937720.38514336.1489275132331986937720.38500ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!23275.8307398438733691132362.05125326.5515648438331986937720.385ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!28419.06872706733691132362.05128419.06872706331986937720.385ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!10200-83030.747992518351-166.06149598510004442.80836341535.3417259042ERROR:#NUM!ERROR:#NUM!13249.9930729921349230177746.62515300.7138979921349230177746.62500ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!24667.5869189678771798692820.04126718.3077439678349230177746.625ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!30164.8876781532771798692820.04130164.8876781532349230177746.625ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!10000-76173.44821757750-152.34689643529800-69867.106375029349-139.7342127501Hiptesis 1Hiptesis 2Hiptesis 3Tcaliente9600-64067.496096294148-128.1349921926VANOkg%CRkg%CRkg%CRTc (kg)Vano A BTcFormula9400-58733.944720703847-117.4678894414254490.04032856435.71744752663519.88282860.868275024222.7576825632455.023570088325599.1788168244218268861.091641455.023570088309200-53829.048058179346-107.6580961164503598.422792552728.62479351333519.88281700.584946454313.5278414323780.642761028150652.0303172974873075444.366562780.642761028109000-49318.408073684445-98.6368161474753681.619473070429.2866078523519.88281871.4780426214.88726467761048.108246303575740.11615141921964419749.824771048.108246303508800-45170.391653843344-90.34078330771003778.571390865230.05784258113519.88282032.588410445116.16886811271277.2578248613100863.43631918973492301777.466251277.257824861308600-41355.908763950543-82.71181752791253880.355770824630.86751866063519.88282178.507330153417.32962636351477.53317358431251021.99082060895456721527.291011477.533173584308400-37848.208439588542-75.69641687921503981.250632002531.67011878133519.88282308.898035684618.36686051771654.55401192131501215.77965567687857678999.299061654.554011921308200-34622.691182142941-69.24538236431754077.963831624632.43945455113519.88282424.852750570519.28925901341812.13058887891751444.802824393410695174193.49041812.130588878908000-31656.736442544940-63.31347288512004168.792445595533.16197952113519.88282527.815611455320.10830969261953.07415803692001709.060326758713969207109.8651953.074158036907800-28929.543983385539-57.85908796682254253.005771163333.83188108473519.88282619.239543121620.83557030562079.58116386612252008.552162772817679777748.42292079.581163866107600-26421.988006872138-52.84397601372504330.446290588134.44790621743519.88282700.475056538821.48178391962193.43684325662502343.278332435521826886109.16412193.436843256607400-24116.483025629637-48.23296605132754401.283433783735.01140270293519.88282772.738854388922.05662918142296.13257493062752713.238835746926410532192.08852296.132574930607200-21996.860535696236-43.99372107143004465.864125309335.52513026263519.88282837.111412673822.56870107932388.93829528943003118.433672707131430715997.19622388.938295289407000-20048.255626822235-40.09651125363254524.622625971335.99254336153519.88282894.545156622123.02557598142472.94990119913253558.86284331636887437524.48732472.949901199106800-18257.002734870734-36.51400546973504578.02646637236.41736111983519.88282945.876172886923.43390480382549.12196453613504034.526347573642780696773.96162549.121964536106600-16610.539805230633-33.22107961053754626.544441389536.80331271493519.88282991.836633367623.79951183972618.29141739133754545.424185479949110493745.61912618.291417391306400-15097.320195141532-30.19464039034004670.62818469837.15399080983519.88283033.066780105924.12749009712681.19544948474005091.556357034955876828439.462681.195449484706200-13706.731697100131-27.41346339424254710.702148980437.47277184773519.88283070.126015408424.42228951882738.48554273154255672.922862238663079700855.48412738.485542731506000-12429.022115460230-24.85804423094504747.158793992737.76277777423519.88283103.502942443324.68779685342790.73882196414506289.52370109170719110993.69152790.738821964105800-11255.230874295729-22.51046174864754780.356980562638.02686326123519.88283133.624337215824.92740702582838.46746482054756941.358873592178795058854.08232838.467464820505600-10177.126176890628-20.35425235385004784.120177586438.05679880353496.264692178727.81214455633142.75252882.12665256385007628.42837974287307544436.65622882.126652563805400-9187.147276157627-18.37429455235254775.550165864337.98862593163465.007991771127.56350323583142.75252922.12138381045258350.732219540596256567741.41352922.121383810405200-8278.351451127426-16.55670290235504767.858265695737.92743827623437.558038944627.34514389423142.7525ERROR:#NUM!5509108.2703929878105642128768.354ERROR:#NUM!ERROR:#NUM!5000-7444.365317653125-14.88873063535754760.938923009537.87239617383413.356009738727.15262118963142.7525ERROR:#NUM!5759901.0429000837115464227517.478ERROR:#NUM!ERROR:#NUM!4800-6679.340131874824-13.35868026376004754.699989846637.82276660453391.933214498626.98220678153142.7525ERROR:#NUM!60010729.0497408284125722863988.785ERROR:#NUM!ERROR:#NUM!4600-5977.910772984723-11.9558215466254749.061198272237.77791105143372.896719614326.83077495523142.7525ERROR:#NUM!62511592.2909152218136418038182.275ERROR:#NUM!ERROR:#NUM!4400-5335.15811764122-10.6703162353650ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!65012490.7664232639147549750097.949ERROR:#NUM!ERROR:#NUM!4200-4746.574542160721-9.4931490843675ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!67513424.4762649547159117999735.806ERROR:#NUM!ERROR:#NUM!4000-4208.032310559920-8.4160646211700ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!70014393.4204402942171122787095.846ERROR:#NUM!ERROR:#NUM!3800-3715.754626745919-7.4315092535725ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!72515397.5989492824183564112178.07ERROR:#NUM!ERROR:#NUM!3600-3266.289147849618-6.5325782957750ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!75016437.0117919194196441974982.477ERROR:#NUM!ERROR:#NUM!3400-2856.483772949517-5.7129675459775ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!77517511.658968205209756375509.067ERROR:#NUM!ERROR:#NUM!3200-2483.464537390816-4.9669290748800ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!80018621.5404781394223507313757.84ERROR:#NUM!ERROR:#NUM!3000-2144.615457674315-4.2892309153825ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!82519766.6563217225237694789728.797ERROR:#NUM!ERROR:#NUM!2800-1837.560185567214-3.6751203711850ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!85020947.0064989542252318803421.937ERROR:#NUM!ERROR:#NUM!2600-1560.145342775513-3.1202906856875ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!87522162.5910098347267379354837.26ERROR:#NUM!ERROR:#NUM!2400-1310.425419303912-2.6208508386900ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!90023413.4098543639282876443974.766ERROR:#NUM!ERROR:#NUM!2200-1086.64912959711-2.1732982592925ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!92524699.4630325418298810070834.456ERROR:#NUM!ERROR:#NUM!2000-887.247130774910-1.7744942615950ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!95026020.7505443684315180235416.329ERROR:#NUM!ERROR:#NUM!1800-710.82101683369-1.4216420337975ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!97527377.2723898438331986937720.385ERROR:#NUM!ERROR:#NUM!1600-556.13351162528-1.11226702331000ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!100028769.0285689678349230177746.625ERROR:#NUM!ERROR:#NUM!1400-422.09979184157-0.84419958371200-307.77987914936-0.61555975831000-212.37204812355-0.4247440962800-135.20720374744-0.2704144075600-75.74418905013-0.1514883781400-33.56598997322-0.0671319799200-8.37681085191-0.01675362170000-200-8.3768108519-1-0.0167536217-400-33.5659899732-2-0.0671319799-600-75.7441890501-3-0.1514883781-800-135.2072037474-4-0.2704144075-1000-212.3720481235-5-0.4247440962-1200-307.7798791493-6-0.6155597583-1400-422.0997918415-7-0.8441995837-1600-556.1335116252-8-1.1122670233-1800-710.8210168336-9-1.4216420337-2000-887.2471307749-10-1.7744942615-2200-1086.649129597-11-2.1732982592-2400-1310.4254193039-12-2.6208508386-2600-1560.1453427755-13-3.1202906856-2800-1837.5601855672-14-3.6751203711-3000-2144.6154576743-15-4.2892309153-3200-2483.4645373908-16-4.9669290748-3400-2856.4837729495-17-5.7129675459-3600-3266.2891478496-18-6.5325782957-3800-3715.7546267459-19-7.4315092535-4000-4208.0323105599-20-8.4160646211-4200-4746.5745421607-21-9.4931490843-4400-5335.158117641-22-10.6703162353-4600-5977.9107729847-23-11.955821546-4800-6679.3401318748-24-13.3586802637-5000-7444.3653176531-25-14.8887306353-5200-8278.3514511274-26-16.5567029023-5400-9187.1472761576-27-18.3742945523-5600-10177.1261768906-28-20.3542523538-5800-11255.2308742957-29-22.5104617486-6000-12429.0221154602-30-24.8580442309-6200-13706.7316971001-31-27.4134633942-6400-15097.3201951415-32-30.1946403903-6600-16610.5398052306-33-33.2210796105-6800-18257.0027348707-34-36.5140054697-7000-20048.2556268222-35-40.0965112536-7200-21996.8605356962-36-43.9937210714-7400-24116.4830256296-37-48.2329660513-7600-26421.9880068721-38-52.8439760137-7800-28929.5439833855-39-57.8590879668-8000-31656.7364425449-40-63.3134728851-8200-34622.6911821429-41-69.2453823643-8400-37848.2084395885-42-75.6964168792-8600-41355.9087639505-43-82.7118175279-8800-45170.3916538433-44-90.3407833077-9000-49318.4080736844-45-98.6368161474-9200-53829.0480581793-46-107.6580961164-9400-58733.9447207038-47-117.4678894414-9600-64067.4960962941-48-128.1349921926-9800-69867.1063750293-49-139.7342127501-10000-76173.448217577-50-152.3468964352-10200-83030.7479925183-51-166.061495985-10400-90487.0959358236-52-180.9741918716-10600-98594.783407626-53-197.1895668153-10800-107410.669611473-54-214.8213392229-11000-116996.580347863-55-233.9931606957-11200-127419.741598512-56-254.839483197-11400-138753.250982098-57-277.5065019642-11600-151076.590387778-58-302.1531807756-11800-164476.183381592-59-328.9523667632-12000-179046.001294843-60-358.0920025897

Hoja2COEFICIENTES PRIMERA HIPOTESISCOEFICIENTES SEGUNDA HIPTESISDatos de Trabajo del ConductorExiste Vano Crtico entre Hiptesis I y II?Existe Vano Crtico entre Hiptesis I y III?Hiptesis I con IIHiptesis I con IIIA2B2A3B3Formula2Vale HastaFormula3Vale HastaHiptesis II con IHiptesis II con IIIA1B1A3B3Formula 1Vale HastaFormula 3Vale hastaHiptesis III con IHiptesis III con IIA1B1A2B2Formula 1Vale HastaFormula 3Vale hastaVariableUnidadesValorVanokg%TRSe cumplekg%TRSe cumplekg%TRSe cumplekg%TRSe cumplekg%TRSe cumplekg%TRSe cumpleSeccin TotalA(mm^2)38Trmino A=0.0000069612Trmino A=0.0001568933??????DimetroD (mm)8Trmino B=-1684.0697244773Trmino B=-1706.140595997253827.182724072975.78579651633619.621353583571.675670368-3827.06719531941692187.5-3619.49219531941692187.500002144.152966993942.45847459391935.869660114238.3340526755-2142.99312008595332270.83333333-1935.41812008591692187.501002122.012716926442.02005380052121.204623676842.004051954-2120.82854097995332270.83333333-2120.82854097991692187.50101Mdulo de ElasticidadE(kg/mm^2)19000503826.437500327175.77103961043618.917039466171.6617235538-3825.97520529586768750-3618.4002052958676875000002146.517250936542.50529209781936.118773153338.338985607-2141.888077793921329083.3333333-1934.3130777939676875001002124.169465891542.06276170082120.947072087141.9989519225-2119.442375928821329083.3333333-2119.442375928867687500101Coeficiente de Dilatacin (1/C)0.0000115Vano Crtico=ERROR:#NUM!Vano CrticoERROR:#NUM!753825.196061008275.74645665363617.743853139771.6384921414-3824.155221923115229687.5-3616.580221923115229687.500002150.424168066742.58265679341936.532419736538.3471766284-2140.046340640547990437.5-1932.471340640515229687.501002127.732462196842.13331608312120.519034126641.9904759233-2117.132100843547990437.5-2117.132100843515229687.50101Pesow(kg/m)0.31003823.459307198875.71206548913616.102800951771.6059960584-3821.607245201327075000-3614.03224520132707500000002155.825054232342.68960503431937.10831267338.358580449-2137.467908625785316333.3333333-1929.89290862572707500001002132.655891825242.23080973912119.922320617241.9786598142-2113.897715724285316333.3333333-2113.8977157242270750000101Carga de RoturaCR (kg)50501253821.228501801275.66789112483613.99529286771.5642632251-3818.331275130442304687.5-3610.756275130442304687.500002162.654939881342.82485029471937.843300111738.3731346557-2134.1527817495133306770.833333-1926.577781749542304687.501002138.878576441442.35403121672119.15944442841.963553355-2109.7392205707133306770.833333-2109.739220570742304687.501011503818.505270910675.61396576063611.423143525271.5133295748-3814.327311710460918750-3606.75231171046091875000002170.835324092742.98683810081938.73341382538.3907606698-2130.100960012191961750-1922.5259600126091875001002146.326576400442.50151636442118.233598523641.9452197727-2104.6566153832191961750-2104.65661538326091875001011753815.291605558775.55032882293608.388573570471.4532390806-3809.595354941482917187.5-3602.020354941482917187.500002180.277265576343.17380723911939.773928647438.4113649237-2125.3124434131261281270.833333-1917.737443413182917187.501002154.916095517342.67160585182117.148628206541.923735212-2098.6499001615261281270.833333-2098.649900161582917187.50101Condiciones Ambientales 2003811.589863814275.47702700623604.894211230171.3840437867-3804.1354048232108300000-3596.560404823210830000000002190.884545347343.38385238311940.959431284338.4348402235-2119.7872319528341265333.333333-1912.212231952810830000001002164.556458581842.86250413032115.908997898741.8991880772-2091.7190749058341265333.333333-2091.71907490581083000000101VariableUnidadesValorExiste Vano Crtico entre Hiptesis II y I?Existe Vano Crtico entre Hiptesis II y III?2253807.402773219975.39411432123600.943094115871.3058038439-3797.947461356137067187.5-3590.372461356137067187.500002202.556689876343.61498395791942.283896512338.4610672577-2113.5253256312431913937.5-1905.9503256312137067187.501002175.152963518543.07233591132114.519752877541.8716782748-2083.8641396159431913937.5-2083.8641396159137067187.50101Temperatura Mnima AmbienteC102503802.733433542475.30165214943596.538671211371.2185875487-3791.0315245397169218750-3583.456524539716921875000002215.191695916843.86518209741943.740768684938.4899162116-2106.5267244482533227083.333333-1898.951724448216921875001002186.609458247843.2991971932112.986476441541.8413163652-2075.085094292533227083.333333-2075.0850942921692187500101Temperatura Media AmbienteC35Trmino A=-0.0000069612Trmino A=0.00014993212753797.585319807975.19970930313591.684805010571.1224713863-3783.3875943743204754687.5-3575.8125943743204754687.500002228.688356782444.13244270861945.323046450138.5212484446-2098.7914284038645204770.833333-1891.2164284038204754687.501002198.830546545743.54119894152111.315243047741.8082226346-2065.3819389339645204770.833333-2065.3819389339204754687.50101Temperatura Mxima AmbienteC60Trmino B=1684.0697244773Trmino B=-22.07087151963003791.962285592675.08836209093586.385773759671.0175400744-3775.0156708598243675000-3567.440670859824367500000002242.948144661344.41481474581947.023368655138.5549181912-2090.3194374981767847000-1882.744437498124367500001002211.723378324543.79650254112109.51256800841.7725260992-2054.7546735418767847000-2054.75467354182436750000101Presin del Viento Mximakg/m^2553253785.868566529574.96769438673580.646273752570.903886609-3765.9157539962285979687.5-3558.3407539962285979687.500002257.876648303744.71042867931948.834099558838.5907742487-2081.110751731901153770.833333-1873.535751731285979687.501002225.199021815744.06334696662107.585354378341.734363453-2043.2032981155901153770.833333-2043.2032981155285979687.50101Vano Crtico=ERROR:#NUM!Vano CrticoERROR:#NUM!3503779.30878399374.83779770283574.471421624670.7816123094-3756.0878437836331668750-3548.512843783633166875000002273.384597464445.01751678151950.747411673938.6286616173-2071.16537110251045125083.33333-1863.590371102533166875001002239.173445545444.34006822862105.540837708841.6938779744-2030.72781265521045125083.33333-2030.72781265523316687500101Hiptesis IHiptesis IIHiptesis IIIHiptesis IV3753772.28794891374.69877126563567.866756580570.650826863-3745.5319402218380742187.5-3537.9569402218380742187.500002289.388525044745.33442623851952.755364796138.6684230653-2060.48329561271199760937.5-1852.9082956127380742187.501002253.568156827444.62511201642103.386529345541.6512184029-2017.32821716071199760937.5-2017.3282171607380742187.50101Tensin3827.431191994Tensin2143.3614675166Tensin1913.715595997Tensin-4003764.811465668674.55072209243560.838242488570.5116483661-3734.248043311433200000-3526.67304331143320000000002305.811126893345.65962627511954.849980046538.709900595-2049.06452526151365061333.33333-1841.489525261543320000001002268.310552460544.91704064282101.130158984541.6065378017-2003.00451163221365061333.33333-2003.00451163224332000000101Peso0.5325410782Peso0.3Peso0.3Peso0.34253756.88513600374.39376506943553.392269765170.3642033617-3722.2361530511489042187.5-3514.6611530511489042187.500002322.581380394445.99171050291957.02330801938.7529367925-2036.90906004891541026270.83333-1829.3340600489489042187.501002283.334038851745.21453542282098.779617181641.5599924194-1987.75669606951541026270.83333-1987.7566960695489042187.50101Temperatura Ambiente10Temperatura Ambiente10Temperatura Ambiente35Temperatura 60Existe Vano Crtico entre Hiptesis III y I?Existe Vano Crtico entre Hiptesis III y II?4503748.515162898374.22802302773545.535656969770.2086268707-3709.4962694421548268750-3501.921269442154826875000002339.634478947546.32939562271959.267490391538.7973760474-2024.0168999751727655750-1816.44189997554826875001002298.577975349745.51639555152096.342898502441.5117405644-1971.58477047281727655750-1971.584770472854826875001014753739.708154340374.05362681863537.275652020970.0450624163-3696.028392484610879687.5-3488.453392484610879687.500002356.911632511646.67151747551961.574814608738.8430656358-2010.38804503971924949770.83333-1802.8130450397610879687.501002313.987488296345.82153442172093.828045975341.4619415045-1954.48873484191924949770.83333-1954.4887348419610879687.50101Trmino A=-0.0001568933Trmino A=-0.00014993215003730.47112689973.87071538413528.619932941369.8736620384-3681.8325221768676875000-3474.257522176867687500000002374.359776251847.01702527231963.93776146738.8898566627-1996.0224952432132908333.33333-1788.44749524367687500001002329.513195794646.12897417412091.243097468241.4107544053-1936.46858917692132908333.33333-1936.46858917696768750000101Trmino B=1706.140595997Trmino B=22.07087151965253720.811509043973.67943582273519.576608031769.6945862977-3666.9086585206746254687.5-3459.3336585206746254687.500002391.931221137547.3649746761966.349045626738.9376048639-1980.92025058492351531437.5-1773.3452505849746254687.501002345.110875552346.43783911982088.596034560241.358337318-1917.52433347792351531437.5-1917.5243334779746254687.501015503710.737144105573.47994344763510.154215369269.5080042647-3651.2568015152819018750-3443.681801515281901875000002409.583272798747.71452025341968.801649242138.9861712721-1965.08131106552580819083.33333-1757.506311065581901875001002360.741101069246.7473485362085.894734420241.3048462261-1897.65596774472580819083.33333-1897.65596774478190187500101Vano Crtico=ERROR:#NUM!Vano CrticoERROR:#NUM!5753700.256292791673.27240183753500.361721520269.3140934954-3634.8769511608895167187.5-3427.3019511608895167187.500002427.277838397948.0649076911971.288849025139.035422753-1948.50567668472820771270.83333-1740.9306766847895167187.501002376.368865237247.05680921262083.146925132641.250434161-1876.86349197752820771270.83333-1876.8634919775895167187.501016003689.377635155773.05698287443490.208519353669.1130399872-3617.7691074573974700000-3410.194107457397470000000002444.981035822648.41546605591973.804237160739.085232419-1931.19334744263071388000-1723.618347442697470000001002391.963205240347.36560802462080.360144837841.1952503928-1855.14690617613071388000-1855.146906176197470000001016253678.110271913472.83386677063479.704424838268.9050381156-3599.93327040471057617187.5-3392.35827040471057617187.500002462.662815132948.76560029971976.341736559539.1354799319-1913.14432333913332669270.83333-1705.56932333911057617187.501002407.496838460147.6732047222077.541704972741.1394397024-1832.50621034073332669270.83333-1832.50621034071057617187.501016503666.463724995672.60324207913468.859672702668.6902905486-3581.3694400031143918750-3373.794440003114391875000002480.296598786949.11478413441978.89561097639.1860517025-1894.35860437423604615083.33333-1686.7836043742114391875001002422.945815816247.97912506572074.698657815941.0831417389-1808.94140447113604615083.33333-1808.9414044711114391875001016753654.447937220172.36530568753457.684910838368.4690081354-3562.07761625231233604687.5-3354.50261625221233604687.500002497.858944581249.4625533581981.460470544539.2368410009-1874.83619054793887225437.5-1667.26119054791233604687.501002438.289196475748.28295438572071.837768459641.0264904645-1784.45248856753887225437.5-1784.45248856751233604687.501017003642.073270963272.12026279143446.191193323468.2414097688-3542.05779915241326675000-3334.4827991524132667500000002515.329233332849.808499671984.031273283239.2877479858-1854.57708186034180500333.33333-1647.0020818603132667500001002453.508746012348.58433160422068.965491249940.9696136881-1759.03946262974180500333.33333-1759.0394626297132667500001017253629.350505703971.86832684563434.389971949468.0077222168-3521.30998870351423129687.5-3313.73498870351423129687.500002532.689381956350.15226498921986.603323109539.3386796655-1833.58127831134484439770.83333-1626.00627831131423129687.501002468.588658754848.88294373772066.087950663440.9126326864-1732.70232665794484439770.83333-1732.70232665791423129687.501017503616.29083431671.60971949143422.293086133967.7681799234-3499.83418490541522968750-3292.2591849054152296875000002549.923581635950.493536271989.172264883239.3895497997-1811.84877990094799043750-1604.273779901152296875001002483.515304131949.17852087392063.210926516940.8556619112-1705.44108065194799043750-1705.4410806519152296875001017753602.905857978671.3446704553409.912751110967.5230247745-3477.63038775831626192187.5-3270.05538775831626192187.500002567.018060156550.83204079521991.734076963939.4402787518-1789.37958662925124312270.83333-1581.80458662921626192187.501002498.276996186649.47083160772060.339843347840.7988087792-1677.25572461185124312270.83333-1677.25572461181626192187.501018003589.207579576871.07341741743397.261544294567.2725058276-3454.69859726211732800000-3247.1235972621173280000000002583.960867058751.1675419221994.28506173139.4907933016-1766.17369849615460245333.33333-1558.5986984961173280000001002512.863785035849.75967891162057.479763745240.7421735395-1648.14625853775460245333.33333-1648.1462585377173280000001018253575.208395466670.79620585083384.352389725767.0168790045-3431.03881341691842792187.5-3223.46381341681842792187.500002600.741680056451.49983524861996.821834477139.5410264253-1742.23111550175806842937.5-1534.65611550171842792187.501002527.267268820350.04489641232054.635385373140.6858492153-1618.11268242945806842937.5-1618.11268242941842792187.501018503560.921085481670.51328882143371.198540522166.756406743-3406.65103622251956168750-3199.0760362225195616875000002617.351631052851.82874516941999.341311041139.5909170503-1717.55183764586164105083.33333-1509.9768376458195616875001002541.480424575850.32634504112051.811041388540.6299216117-1587.15499628716164105083.33333-1587.1549962871195616875001018753546.358801065970.22492675383357.813559266366.4913576092-3381.5352656792072929687.5-3173.9602656792072929687.500002633.783150072552.15412178362001.840694506739.6404097922-1692.13586492866532031770.83333-1484.56086492862072929687.501002555.497456433350.60391002842049.010703933340.5744693848-1555.27320011066532031770.83333-1555.27320011062072929687.501019003531.535051423669.93138715693344.211296288266.2220058671-3355.69150178652193075000-3148.1165017865219307500000002650.029825469252.47583812812004.317461253639.6894546783-1665.98319735016910623000-1458.4081973501219307500001002569.313659586550.87749820962046.237990364240.5195641656-1522.46729396910623000-1522.4672939219307500001019253516.463687590569.63294430873330.405865813365.9486310062-3329.11974454492316604687.5-3121.54474454492316604687.500002666.086278842752.79378769992006.769346607739.7380068635-1639.09383491017299878770.83333-1431.51883491012316604687.501002582.925298530651.14703561452043.496171876240.4652707302-1488.73727765547299878770.83333-1488.73727765542316604687.501019503501.158884342269.32987889793316.41161997765.6715172273-3301.81999395422443518750-3094.2449939541244351875000002681.948053200653.10788224162009.19433030239.7860263426-1611.46777760887699799083.33333-1403.8927776088244351875001002596.329498169451.41246531032040.78818417640.4116472114-1454.08315137667699799083.33333-1454.0831513766244351875001019753485.635119874569.02247762133302.243120727365.3909528857-3273.79225001442573817187.5-3066.21725001442573817187.500002697.611513007953.41804976252011.590621928439.8334776619-1583.10502544618110383937.5-1375.53002544612573817187.501002609.524146487751.6737454752038.116639868740.3587453439-1418.50491506388110383937.5-1418.50491506382573817187.5010110003469.907153207168.71103273683287.915109665865.1072298944-3245.03651272552707500000-3037.4615127255270750000000002713.073754882653.724232772013.956646527639.8803296342-1554.00557842218531633333.33333-1346.4305784221270750000001002622.507807594251.93084767512035.483842235640.3066107373-1382.00256871688531633333.33333-1382.002568716827075000000101

Hiptesis 1Hiptesis 2Hiptesis 3TcalienteVANOkg%CRkg%CRkg%CRTc (kg)Vano A BTcFormula252122.012716926442.02005380052121.204623676842.0040519541913.71559599737.89535833661728.409561713825-1727.84312008591692187.51728.40956171380502124.169465891542.06276170082120.947072087141.99895192251913.71559599737.89535833661729.002291090550-1726.738077793967687501729.00229109050752127.732462196842.13331608312120.519034126641.99047592331913.71559599737.89535833661729.985034215175-1724.896340640515229687.51729.985034215101002132.655891825242.23080973912119.922320617241.97865981421913.71559599737.89535833661731.3502140635100-1722.3179086257270750001731.350214063501252138.878576441442.35403121672119.15944442841.9635533551913.71559599737.89535833661733.0874791835125-1719.002781749542304687.51733.087479183501502146.326576400442.50151636442118.233598523641.94521977271913.71559599737.89535833661735.1839442162150-1714.950960012609187501735.183944216201752154.916095517342.67160585182117.148628206541.9237352121913.71559599737.89535833661737.6244780693175-1710.162443413182917187.51737.624478069302002164.556458581842.86250413032115.908997898741.89918807721913.71559599737.89535833661740.3920264924200-1704.63723195281083000001740.392026492402252175.152963518543.07233591132114.519752877541.87167827481913.71559599737.89535833661743.4679552684225-1698.3753256312137067187.51743.467955268402502186.609458247843.2991971932112.986476441541.84131636521913.71559599737.89535833661746.8324006441250-1691.37672444821692187501746.832400644102752198.830546545743.54119894152111.315243047741.80822263461913.71559599737.89535833661750.4646148279275-1683.6414284038204754687.51750.464614827903002211.723378324543.79650254112109.51256800841.77252609921913.71559599737.89535833661754.3432961563300-1675.16943749812436750001754.343296156303252225.199021815744.06334696662107.585354378341.7343634531913.71559599737.89535833661758.4468956599325-1665.960751731285979687.51758.446895659903502239.173445545444.34006822862105.540837708841.69387797441913.71559599737.89535833661762.7538940061350-1656.01537110253316687501762.753894006103752253.568156827444.62511201642103.386529345541.65121840291913.71559599737.89535833661767.2430449849375-1645.3332956127380742187.51767.243044984904002268.310552460544.91704064282101.130158984541.60653780171913.71559599737.89535833661771.8935836835400-1633.91452526154332000001771.893583683504252283.334038851745.21453542282098.779617181641.55999241941913.71559599737.89535833661776.6853991861425-1621.7590600489489042187.51776.685399186104502298.577975349745.51639555152096.342898502441.51174056441913.71559599737.89535833661781.5991729808450-1608.8668999755482687501781.599172980804752313.987488296345.82153442172093.828045975341.46194150451913.71559599737.89535833661786.6164852614475-1595.2380450397610879687.51786.616485261405002329.513195794646.12897417412091.243097468241.41075440531913.71559599737.89535833661791.7198919874500-1580.8724952436768750001791.719891987405252345.110875552346.43783911982088.596034560241.3583373181913.71559599737.89535833661796.8929759671525-1565.7702505849746254687.51796.892975967105502360.741101069246.7473485362085.894734420241.30484622611913.71559599737.89535833661802.1203753901550-1549.93131106558190187501802.120375390105752376.368865237247.05680921262083.146925132641.2504341611913.71559599737.89535833661807.3877932171575-1533.3556766847895167187.51807.387793217106002391.963205240347.36560802462080.360144837841.19525039281913.71559599737.89535833661812.6819906867600-1516.04334744269747000001812.681990686706252407.496838460147.6732047222077.541704972741.13943970241913.71559599737.89535833661817.9907679567625-1497.99432333911057617187.51817.990767956706502422.945815816247.97912506572074.698657815941.08314173891913.71559599737.89535833661823.3029346031650-1479.208604374211439187501823.302934603106752438.289196475748.28295438572071.837768459641.02649046451913.71559599737.89535833661828.6082723825675-1459.68619054791233604687.51828.608272382507002453.508746012348.58433160422068.965491249940.96961368811913.71559599737.89535833661833.8974923373700-1439.427081860313266750001833.897492337307252468.588658754848.88294373772066.087950663440.91263268641913.71559599737.89535833661839.1621880131725-1418.43127831131423129687.51839.162188013107502483.515304131949.17852087392063.210926516940.85566191121913.71559599737.89535833661844.3947862634750-1396.69877990115229687501844.394786263407752498.276996186649.47083160772060.339843347840.79880877921913.71559599737.89535833661849.5884968546775-1374.22958662921626192187.51849.588496854608002512.863785035849.75967891162057.479763745240.74217353951913.71559599737.89535833661854.737261847800-1351.023698496117328000001854.73726184708252527.267268820350.04489641232054.635385373140.68584921531913.71559599737.89535833661859.8357055249825-1327.08111550171842792187.51859.835705524908502541.480424575850.32634504112051.811041388540.62992161171913.71559599737.89535833661864.87908547850-1302.401837645819561687501864.8790854708752555.497456433350.60391002842049.010703933340.57446938481913.71559599737.89535833661869.8632452273875-1276.98586492862072929687.51869.863245227309002569.313659586550.87749820962046.237990364240.51956416561913.71559599737.89535833661874.7845688873900-1250.833197350121930750001874.784568887309252582.925298530651.14703561452043.496171876240.46527073021913.71559599737.89535833661879.6399378054925-1223.94383491012316604687.51879.639937805409502596.329498169451.41246531032040.78818417640.41164721141913.71559599737.89535833661884.4266896004950-1196.317777608824435187501884.426689600409752609.524146487751.6737454752038.116639868740.35874534391913.71559599737.89535833661889.1425795037975-1167.95502544622573817187.51889.1425795037010002622.507807594251.93084767512035.483842235640.30661073731913.71559599737.89535833661893.78574408141000-1138.855578422127075000001893.78574408140

Hoja3TRAMO 1TerrenoVanoParmetrosSoportesNroProgresivaCota BasenguloReal MedioGrav. Req.Grav. Obt.FicticioFroCalienteTipoSuspensinAmarreAlt. UtilSg1230.1838329976171875166.390--350.682296.0732388.988HX23.38189.77Sg2168.5719464787272236.68181430BX23.38204.38372495211254342197230.1838329976BX14.38225.38472845.96247.2828286270151.33168.5719464787HX14.38261.66

TRAMO 2TerrenoVanoParmetrosSoportesSg1NroProgresivaCota BasenguloReal MedioGrav. Req.Grav. Obt.FicticioFroCalienteTipoSuspensinAmarreAlt. Util257.9093200993172845.96247.2828--345.972296.0732388.988HX11.38258.66249.8056680162273150.55201310BX21.38222.38316.7653880464373550.85163390350177.15257.9093200993BX29.38192.38326.4879779267473892163342366281249.8056680162BX20.38183.38308.464309719574247.67161.5354348345.78316.7653880464BX17.38178.88289.6600138147674593160.5344349349326.4879779267BX17.38177.88774948.41161346345353.8308.464309719BX21.38182.38875255.911810318332316.47289.6600138147HX11.38192.382404

Hoja4Lista de Herrajes para Torre de AmarreLista de Herrajes para Torre de SuspensinCable de GuardaConductorCable de GuardaConductorNombre HerrajeCantidadPeso p/u (kg)Peso TotalNombre de HerrajeCantidadPeso p/u (kg)Peso TotalNombre HerrajeCantidadPeso p/u (kg)Peso TotalNombre de HerrajeCantidadPeso p/u (kg)Peso TotalGrapa de cua43.714.8Aisladores Estndar325160Mordaza de Susp.45.2521Cadena de Aisladores14570Grilletes Revirados41.14.4Amortiguadores10.8450.845Caballete23.67.2Amortiguadores10.8450.845Conexin21.12.2Grillete Recto20.951.9Conector Conductor41.14.4Varilla10.5940.594Aprieta Hilos20.460.92Yugo de Cruce10.920.92Conector a tierra40.351.4Abrazadera20.0670.134Grillete40.953.8Grapas 24.69.20Esfera20.40.8Rotula de Horquilla22.14.2Grapa Suspensin14.64.6TOTAL26.12Total sin aisladores17.065Total 177.065TOTAL34Yugo Estampado166Total 928.51Eslabn derivado10.40.4Total sin aisladores13.373Total83.373464.238

Hoja5Vanocgctipo Htipo BFuerzaPresionMomento de VolcamientoFuerza en cada pataPesosMomento de arranque f(-)Volumen de tierra Momento de Compresion f(+)Peso de la tierraFactor de seguridad fsAlturaFuerza PresionMomento de arranque f(-)-56595.05430.000.0080.03066C.guarda40.95F='378.415495.48530244.2953024.429052peso de cable 64.5-56595.051.567730029149.197071130449453.80405288554.72803473621.790655536743040.95378.415495.481.57430.000.0080.03066Conductor33.38F='1450.2248408.27684peso de Conductores988.78533.381450.2248408.28Volumen de tierra 49.20430.000.0080.03066Conductor28.38F='1450.2241157.18684peso de aisladores4028.381450.2241157.19Momento de Compresion f(+)49453.80430.000.0080.03066Conductor23.38F='1450.2233906.09684peso de la torre220023.381450.2233906.10Peso de la tierra88554.73430.000.0080.03066Altura de torre40.95F='28665.00391277.25peso de los herrajes277.3440.9528665.00391277.25Factor de seguridad fs1.79254.000.0080.03066C.guarda38.38F='223.528578.6976425218.7542521.8754589333peso de cable 38.1-45496.371.260287214942.209379677839547.382458933375976.88342005631.9211608631Momento de volcamiento530244.29254.000.0080.03066Conductor33.38F='856.6428594.656552peso de Conductores584.073Fuerza en cada pata132561.07254.000.0080.03066Conductor28.38F='856.6424311.454552peso de aisladores17.5AlturaFuerza PresionMomento de arranque f(-)-45496.37254.000.0080.03066Conductor23.38F='856.6420028.252552peso de la torre220025438.38223.528578.701.26254.000.0080.03066Altura de torre38.38F='26866.00343705.69peso de los herrajes134.8233.38856.6428594.66Volumen de tierra 42.21286.000.0080.03066C.guarda29.38F='251.687394.3584264883.7826488.3779437333peso de cable 42.9-29541.250.818317311542.209379677823435.500943733375976.88342005633.241956875728.38856.6424311.45Momento de Compresion f(+)39547.38286.000.0080.03066Conductor24.38F='964.5623516.060568peso de Conductores657.65723.38856.6420028.25Peso de la tierra75976.88286.000.0080.03066Conductor19.38F='964.5618693.242568peso de aisladores17.538.3826866.00343705.69Factor de seguridad fs1.92286.000.0080.03066Conductor14.38F='964.5613870.424568peso de la torre2200Momento de volcamiento425218.75286.000.0080.03066Altura de torre29.38F='20566.00201409.69peso de los herrajes134.82Fuerza en cada pata106304.69286.000.0080.03066C.guarda14.38F='251.683619.158463574.357946.7938963333peso de cable 42.9-11119.480.494199039824.57341741484774.109396333344232.15134666569.2650058209286.000.0080.03066Conductor11.58F='964.5611169.646488peso de Conductores657.657286.000.0080.03066Conductor7.38F='964.567118.479368peso de aisladores40286.000.0080.03066Conductor3.18F='964.563067.312248peso de la torre2200286.000.0080.03066Altura de torre14.38F='8052.8038599.75peso de los herrajes232.1275AlturaFuerza PresionMomento de arranque f(-)-29541.25Tramo ii28629.38251.687394.360.82Vanocgctipo Htipo BFuerzaPresionMomento de VolcamientoFuerza en cada pataPesosMomento de arranque f(-)Volumen de tierra Momento de Compresion f(+)Peso de la tierraFactor de seguridad fs24.38964.5623516.06Volumen de tierra 42.21247.280.0080.03066C.guarda28.95F='217.60646299.70528242838.5624283.856186592peso de cable 37.092-27406.910.759194142649.197071130421160.80382659288554.72803473624.184847076719.38964.5618693.24Momento de Compresion f(+)23435.50247.280.0080.03066Conductor21.38F='833.97652817830.41816864peso de Conductores568.6203614.38964.5613870.42Peso de la tierra75976.88247.280.0080.03066Conductor16.38F='833.97652813660.53552864peso de aisladores4029.3820566.00201409.69Factor de seguridad fs3.24247.280.0080.03066Conductor11.38F='833.9765289490.65288864peso de la torre2200Momento de volcamiento264883.78247.280.0080.03066Altura de torre28.95F='20265.00195557.25peso de los herrajes277.34Fuerza en cada pata66220.94201.000.0080.03066C.guarda36.38F='176.886434.8944368901.0136890.1008097333peso de cable 30.15-39734.771.100686158242.209379677834045.431309733375976.88342005632.2316322777AlturaFuerza PresionMomento de arranque f(-)-27406.91201.000.0080.03066Conductor31.38F='677.892621272.269788peso de Conductores462.1995247.2828.95217.60646299.710.76201.000.0080.03066Conductor26.38F='677.892617882.806788peso de aisladores17.521.38833.97652817830.42Volumen de tierra 49.20201.000.0080.03066Conductor21.38F='677.892614493.343788peso de la torre220016.38833.97652813660.54Momento de Compresion f(+)21160.80201.000.0080.03066Altura de torre36.38F='25466.00308817.69peso de los herrajes134.8211.38833.9765289490.65Peso de la tierra88554.73163.000.0080.03066C.guarda44.38F='143.446365.8672522635.1052263.5104665333peso de cable 24.45-55120.111.526872824642.209379677849406.911966533375976.88342005631.537778428128.9520265.00195557.25Factor de seguridad fs4.18163.000.0080.03066Conductor39.38F='549.733821648.517044peso de Conductores374.8185Momento de volcamiento242838.56163.000.0080.03066Conductor34.38F='549.733818899.848044peso de aisladores17.5Fuerza en cada pata60709.64163.000.0080.03066Conductor29.38F='549.733816151.179044peso de la torre2200AlturaFuerza PresionMomento de arranque f(-)-39734.77163.000.0080.03066Altura de torre44.38F='31066.00459569.69peso de los herrajes239.8320136.38176.886434.891.10163.000.0080.03066C.guarda35.38F='143.445074.9072339005.3333900.5332065333peso de cable 24.45-36757.131.018203011342.209379677831043.937706533375976.88342005632.447398398331.38677.892621272.27Volumen de tierra 42.21163.000.0080.03066Conductor30.38F='549.733816700.912844peso de Conductores374.818526.38677.892617882.81Momento de Compresion f(+)34045.43163.000.0080.03066Conductor25.38F='549.733813952.243844peso de aisladores17.521.38677.892614493.34Peso de la tierra75976.88163.000.0080.03066Conductor20.38F='549.733811203.574844peso de la torre220036.3825466.00308817.69Factor de seguridad fs2.23163.000.0080.03066Altura de torre35.38F='24766.00292073.69peso de los herrajes239.827Momento de volcamiento368901.01161.500.0080.03066C.guarda32.38F='142.124601.8456285813.0128581.3011719333peso de cable 24.225-31329.220.867845302542.209379677825833.386921933375976.88342005632.9410345476Fuerza en cada pata92225.25161.500.0080.03066Conductor27.38F='544.674914913.198762peso de Conductores371.36925AlturaFuerza PresionMomento de arranque f(-)-55120.11161.500.0080.03066Conductor22.38F='544.674912189.824262peso de aisladores17.516344.38143.446365.871.53161.500.0080.03066Conductor17.38F='544.67499466.449762peso de la torre220039.38549.733821648.52Volumen de tierra 42.21161.500.0080.03066Altura de torre32.38F='22666.00244641.69peso de los herrajes134.8234.38549.733818899.85Momento de Compresion f(+)49406.91160.500.0080.03066C.guarda32.38F='141.244573.3512285558.0828555.8080955333peso de cable 24.075-31282.510.866551588542.209379677825829.103845533375976.88342005632.941522240729.38549.733816151.18Peso de la tierra75976.88160.500.0080.03066Conductor27.38F='541.302314820.856974peso de Conductores369.0697544.3831066.00459569.69Factor de seguridad fs1.54160.500.0080.03066Conductor22.38F='541.302312114.345474peso de aisladores17.5Momento de volcamiento522635.10160.500.0080.03066Conductor17.38F='541.30239407.833974peso de la torre2200Fuerza en cada pata130658.78160.500.0080.03066Altura de torre32.38F='22666.00244641.69peso de los herrajes116.0595AlturaFuerza PresionMomento de arranque f(-)-36757.13161.000.0080.03066C.guarda36.38F='141.685154.3184356944.1335694.4129537333peso de cable 24.15-38422.341.06433080242.209379677832966.483953733375976.88342005632.30467051116344.38143.446365.871.02161.000.0080.03066Conductor31.38F='542.988617038.982268peso de Conductores370.219539.38549.733821648.52Volumen de tierra 42.21161.000.0080.03066Conductor26.38F='542.988614324.039268peso de aisladores17.534.38549.733818899.85Momento de Compresion f(+)31043.94161.000.0080.03066Conductor21.38F='542.988611609.096268peso de la torre220029.38549.733816151.18Peso de la tierra75976.88161.000.0080.03066Altura de torre36.38F='25466.00308817.69peso de los herrajes116.059544.3831066.00459569.69Factor de seguridad fs2.45181.000.0080.03066C.guarda26.38F='159.284201.8064191870.0519187.0053791333peso de cable 27.15-22102.490.612257406649.197071130416271.518379133388554.72803473625.4423149685Momento de volcamiento522635.10181.000.0080.03066Conductor18.81F='610.440611482.387686peso de Conductores416.2095Fuerza en cada pata130658.78181.000.0080.03066Conductor13.81F='610.44068430.184686peso de aisladores40AlturaFuerza PresionMomento de arranque f(-)-31329.22181.000.0080.03066Conductor8.81F='610.44065377.981686peso de la torre2200161.532.38142.124601.850.87181.000.0080.03066Altura de torre26.38F='18466.00162377.69peso de los herrajes232.127527.38544.674914913.20Volumen de tierra 42.2122.38544.674912189.82Momento de Compresion f(+)25833.3917.38544.67499466.45Peso de la tierra75976.8832.3822666.00244641.69Factor de seguridad fs2.94Momento de volcamiento285813.01Fuerza en cada pata71453.25AlturaFuerza PresionMomento de arranque f(-)-31282.51160.532.38141.244573.350.8727.38541.302314820.86Volumen de tierra 42.2122.38541.302312114.35Momento de Compresion f(+)25829.1017.38541.30239407.83Peso de la tierra75976.8832.3822666.00244641.69Factor de seguridad fs2.94Momento de volcamiento285558.08Fuerza en cada pata71389.52AlturaFuerza PresionMomento de arranque f(-)-38422.3416136.38141.685154.321.0631.38542.988617038.98Volumen de tierra 42.2126.38542.988614324.04Momento de Compresion f(+)32966.4821.38542.988611609.10Peso de la tierra75976.8836.3825466.00308817.69Factor de seguridad fs2.30Momento de volcamiento356944.13Fuerza en cada pata89236.03AlturaFuerza PresionMomento de arranque f(-)-22102.4918126.38159.284201.810.6118.81610.440611482.39Volumen de tierra 49.2013.81610.44068430.18Momento de Compresion f(+)16271.528.81610.44065377.98Peso de la tierra88554.7326.3818466.00162377.69Factor de seguridad fs5.44Momento de volcamiento191870.05Fuerza en cada pata47967.51