9
DADOS Ea = H= 10.0 m 1.7 tf/m³ c= 1.5 tf/m² 30.0 ° 0.524 rad 20.0 ° 0.349 rad Sc= 1.0 tf/m² 25.0 ° 0.436 rad 1.0471976 2.0071286 γ = φ = δ = β= (90- φ )= (90+ β)=

Planilha Coulomb

Embed Size (px)

DESCRIPTION

Planilha que auxilia no cálculo de empuxo em paredes e estruturas de contenção. A teoria de base é a de Coulomb.

Citation preview

Plan1DADOSEa =ERROR:#DIV/0!tf/mH=10.0mERROR:#DIV/0!8.542.5g=1.7tf/mc=1.5tf/mf=30.00.524radr () =(I)(II)(III)(IV)ABCd=20.00.349rad1-17.8632058362-189.371747613-28.125018451660.28864874-239.3985837376-1.3532302198176.9089843149Sc=1.0tf/m2-18.446812809-197.0389045977-31.636972789465.3958145729-249.2445591902-1.4252846379174.8735323222b=25.00.436rad3-19.0758485977-205.3636744994-5.121299162671.1262773568-290.4445012913-1.5022304662193.34217207764-19.7555293072-214.440230430928.709151960377.5884049838-340.4933166823-1.584635247214.87172983955-20.4919068149-224.381567991938.115322486184.9154985989-367.9042958917-1.6731571851219.88627199396-21.2920428618-235.324458777511.667439138493.2730685082-361.557009286-1.7685640391204.43535053717-22.1642285613-247.4360550424-28.9028798368102.8687321756-343.5661359424-1.8717569405183.5527511658(90-f)=1.04719755128-23.1182637734-260.9228254097-46.0028998326113.9658802814-352.0040696319-1.9838007086177.4392297068(90+b)=2.00712863989-24.1658163037-276.0428414554-20.3259564319126.9028566463-406.7855579734-2.1059628273193.158945024310-25.3208888624-293.122978911828.5750167023142.1203704147-489.1392548912-2.2397641135218.388736537211-26.6004334861-312.583490800756.1936886021160.2014777939-555.5790906828-2.3870453876232.747602354512-28.0251707689-334.973921994632.4270683226181.9312456069-577.357406693-2.5500563657226.409664690213-29.6206982343-361.026981043-27.4732500011208.3881258155-571.5625550917-2.7315759259209.242785332614-31.4190143501-391.7417966115-70.5780530884241.0881176046-593.6708754778-2.9350774752202.267531436315-33.4606521495-428.5171277657-50.9099152034282.2201810709-693.2880457827-3.1649604609219.051092213516-35.7977272639-473.373381087825.019648107335.0465172901-869.2372737488-3.4268811035253.652591815717-38.4983927419-529.341140609193.9106077953404.6167729084-1066.3669140548-3.7282357729286.024537884618-41.65352128-601.182723369683.7731915218499.119236764-1225.7286729355-4.0788860541300.505740215519-45.3870323082-696.8352905087-19.492520693632.6306103982-1355.3604125221-4.4922793027301.708847823120-49.8724153297-830.585691627-142.4018711426831.2621528045-1569.3183886185-4.987241533314.666610438921-55.3602688232-1031.0075756461-163.05315039031148.739819243-2072.0545133219-5.5909655645370.607632871522-62.2264933245-1364.77272332932.29918714911713.6816200317-3142.9800238347-6.344240279495.406839217123-71.0617928666-2031.8963772759329.63346795132920.3178827555-5352.9095208492-7.3111620962732.155770921324-82.8506778644-4032.4545517058705.40362803946770.5133382384-11591.2221958479-8.59855792581348.042578291225-99.3652714649ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!-10.3987156608ERROR:#DIV/0!26-124.14982542863967.3407740407593.9977368369-10012.167588741313261.3608005165-13.0962104104-1012.610548006827-165.47426777961966.7825996108372.5430306214-6622.66722674448051.4325279542-17.5883831983-457.769906259228-248.14839341861299.658945664270.3696014525-6567.76989696127548.9108477543-26.5672557536-284.143417663129-496.2211984328965.893797981-129.3334922311-9765.179757479610364.1858492589-53.4929340462-193.748689131730.5992.4046077001692.5356810768-112.495969982514004.1286225243-12206.692363765108.0201290957-113.00386757531496.2211984328631.7215128436-52.54776346536386.7002174356-5206.209742693954.1769743329-96.096354711632248.1483934186536.068945704561.51206052632709.0010775822-1986.295798985427.2512960402-72.888122313633165.4742677796464.22736294497.67274339451563.1739587972-1031.145071468218.272423485-56.43176299634124.1498254286408.259603422745.97884727261030.3031178787-543.872536313.7802506971-39.4675356973599.3652714649363.4033501006-33.5216838598733.0092879967-236.718982571511.0827559474-21.35921639843682.8506778644326.6280189464-70.6615190851548.4102376265-68.27002173069.2825982124-7.354624233771.0617928666295.9132033778-42.0787031664425.2975836919-16.24388428117.9952023828-2.03170395243862.2264933245269.860144329517.9106395945338.8508294542-24.67483139477.0282805656-3.510792033955.3602688232247.469713135654.1597482237275.7286369669-27.05840323196.2750058511-4.31209211174049.8724153297228.009201246739.1374904017228.19490077710.54922539775.67128181961.86011306324145.3870323082210.9290637903-7.8233750018191.494581565972.64488953435.176319589414.03408121934241.65352128195.8090477446-42.6161596238162.5663191284117.512409524.762926340724.67231300964338.4983927419182.3222773773-36.5923528492139.3631551419118.04986782654.412276059526.75486896894435.7977272639170.21068111240.7391720758120.472544909984.79669139064.110921390220.627174144533.4606521495159.267790326833.821713663104.893320972254.01340784123.849000747614.03309881794631.4190143501149.326452765834.209161398491.899393215854.63691250173.619117761815.09674901384729.6206982343140.24989683434.484515971580.953542759384.43253633793.415616212624.71956188364828.0251707689131.9251269325-26.729704823271.6512572882115.02874523643.234096652335.5675038824926.6004334861124.2579699479-31.877879857363.6831790519119.05310423953.071085674338.76580364935025.3208888624117.1693105782-8.43997034356.809417952994.12075183072.923804400232.1911930315124.1658163037110.592195416620.784919090250.841620985963.13147164422.790003113922.62774235975223.1182637734104.469580563529.544283528545.630226841452.4133339672.667840995319.64634851165322.164228561398.752561882911.464913164241.05525703768.3966202432.555797227226.76136413185421.292042861893.3989714023-15.66908468237.019563131993.34053581412.452604325838.05772290015520.491906814988.3722544234-27.182576962433.4438078574102.60293034322.357197471843.5275073785619.755529307283.6405639555-13.766527880830.262688751286.89993239242.268675533638.30425775065719.075848597779.176024933111.189426601227.42206440959.64038252062.186270752827.2795043545818.44681280974.954132201124.78287878724.876744726743.74132149652.109324924520.73711877575917.863205836270.953254728715.479826655322.588775280550.74785862922.037270506524.90973018436017.320508075767.1542248041-7.224466225520.526093406571.17310569881.96961550636.13553278856116.814784109663.5399956862-22.344896917818.661466669884.03821004381.905931291844.09299034266216.342591451960.0953547619-16.697619591416.971647869576.16391793571.845842691141.26241001196315.900905886456.80668198323.695434434415.436697522953.57545591231.789019886829.94681965636415.487059982553.661745457119.874457618614.039436938335.23491088281.735171745320.30629589166515.098692151550.649527685317.486987757912.765003883435.49622819551.684040286721.07801605276614.733704195747.7600772206-0.550183365811.600489436551.44347534551.635396077431.45627903686714.390225741644.9843815047-17.381459124910.534639505266.2214268661.589034369741.67400537756814.066584291742.3142574358-17.89884470839.557608187264.72207824871.544771850141.89749977846913.761279883839.7422568478-2.2463640048.660752936947.08914779881.502443888831.34170144487013.472963553337.261584579114.87858346877.83646363928.01950102471.461902200119.16646751287113.200418948834.866027215317.97373587017.078019328323.01469096571.423012846816.17321376817212.942546575432.54989091494.71814300716.379467565834.39482691741.385654528124.82207954497312.69835023830.307946994-12.38043393865.735522474449.65120869631.349717106936.78638171117412.46692533528.1353841588-17.74548284465.141478209453.2063141291.315100337840.45798833747512.247448713926.0277664565-6.88177139724.59313525740.56385131061.281712764131.64816052897612.039169852423.98099615839.90292271474.086737435122.03050586091.24947075917.63186989577711.84140316621.991280908617.24353821713.618917860712.97022799681.218297688510.64618944847811.6535212820.05510457888.74909776433.186652459719.77287563481.188123179516.64210914867911.474949125818.1692013414-7.46281177222.787219840534.3197423991.158882476229.61451493488011.305158748516.3305325566-16.49453906842.418166560941.71206381251.130515874836.89648658698111.143664726314.5362661166-10.32894792232.077276977133.93160178811.102968223730.76389786898210.990020121212.78375794645.07735150421.762547000516.93387956291.076188481315.73505000058310.843812889511.070535399515.52334571171.47216119774.91884137961.05012932364.68403392728410.70466269329.394282321111.62835007681.20447275767.266122181.02474679567.09065128218510.57221806167.7528255861-2.76398425670.957985926720.1310419778120.13104197788610.44615385916.1441229382-14.35373982590.731340573630.21267604950.975850819330.96034296768710.32616902144.5662519846-12.65341076110.523298596127.0225331710.952263666528.377154488810.21198452913.01740021550.54009297150.332731926612.35655984660.929205262313.29798737528910.10334158891.495855934213.0088912430.1586119275-1.56830564740.9066444331-1.7297912942