{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Calculs","Calculs manuels"],"not_rendered":{"charts":2,"images":2,"macros":1,"external_links":0,"defined_names":51,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Calculs","index":0,"n_rows":188,"n_cols":13,"rows_kept":188,"cut":false,"hidden":false,"merged":[[59,5,59,11],[61,1,62,1],[30,1,30,3],[9,3,9,4],[54,2,54,3],[54,5,54,6],[50,9,50,12],[1,1,1,4],[0,1,0,4],[20,1,20,3],[12,1,12,4],[45,9,45,12],[4,4,4,6],[3,4,3,7],[13,5,15,6],[4,2,5,2],[67,1,67,3],[78,4,80,4],[78,6,79,9],[83,1,86,1],[83,2,86,2],[83,3,83,4],[83,6,87,10],[84,3,86,3],[84,4,86,4],[84,5,86,5]]}
[]
[null,"Entrez vos valeurs dans les cellules jaunes",null,null,null,"L'application ne vérifie pas lles limites (hauteur en fonction de la longueur Lb ...)"]
[]
[null,null,null,null,"Positions"]
[null,"Long bras Lb","Hauteur HF\ncourante",null,"Pour table",null,null,"Pour charge"]
[null,"FG,HE",null,null,"Hr mini","Hr maxi","XGt","XGc"]
[null,"(mm)","(mm)",null,"(mm)","(mm)","(mm)","(mm)"]
[null,1800,600,null,200,1000,1000,900]
[]
[null,null,null,"Animation (hauteur)"]
[]
[]
[null,"Masses"]
[null,"Table","Charge","Bras FG","Bras HE","Un bras est l'ensemble de\n2 joues et 2 entretoises\n(poids considéré au milieu)"]
[null,"Mt","Mc","Mb1","Mb2"]
[null,"(kg)","(kg)","(kg)","(kg)"]
[null,30,2000,20,20]
[]
[]
[]
[null,"Résultats"]
[null,"XRf",{"$f":"MMULT(MINVERSE(B37:G42),H37:H42)","v":56881.083692208267},"  N"]
[null,"YRf",9532.0057767539529,"  N"]
[null,"XFk",-56881.083692208267,"  N"]
[null,"YFk",1242.6884464920945,"  N"]
[null,"XRe",-56881.083692208267,"  N"]
[null,"YRe",10774.694223246048,"  N"]
[]
[]
[null,"Fv",{"$f":"XRe","v":-56881.083692208267},"  N"]
[null,"(négatif = effort vérin en tirant)"]
[]
[]
[]
[]
[null,"XRf","YRf","XFk","YFk","XRe","YRe","=",null,"Vérif 1"]
["1",{"$f":"1","v":1},{"$f":"0","v":0},{"$f":"1","v":1},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},null,{"$f":"SUMPRODUCT($C$22:$C$27,TRANSPOSE(B37:G37))-H37","v":0}]
["2",{"$f":"0","v":0},{"$f":"1","v":1},{"$f":"0","v":0},{"$f":"1","v":1},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"-Fg-Pb1_","v":10774.694223246048},null,{"$f":"SUMPRODUCT($C$22:$C$27,TRANSPOSE(B38:G38))-H38","v":0}]
["3",{"$f":"-Yf","v":0},{"$f":"0","v":0},{"$f":"-Yk","v":-300},{"$f":"Xk","v":848.52813742385706},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"-Xg*Fg-Xk*Pb1_","v":18118781.220562562},null,{"$f":"SUMPRODUCT($C$22:$C$27,TRANSPOSE(B39:G39))-H39","v":0}]
["4",{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"-1","v":-1},{"$f":"0","v":0},{"$f":"1","v":1},{"$f":"0","v":0},{"$f":"0","v":0},null,{"$f":"SUMPRODUCT($C$22:$C$27,TRANSPOSE(B40:G40))-H40","v":0}]
["5",{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"-1","v":-1},{"$f":"0","v":0},{"$f":"1","v":1},{"$f":"-Fh-Pb2_","v":9532.0057767539529},null,{"$f":"SUMPRODUCT($C$22:$C$27,TRANSPOSE(B41:G41))-H41","v":0}]
["6",{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"Yk","v":300},{"$f":"-Xk","v":-848.52813742385706},{"$f":"-Ye","v":0},{"$f":"Xe","v":1697.0562748477141},{"$f":"-Xk*Pb2_","v":166481.22056256077},null,{"$f":"SUMPRODUCT($C$22:$C$27,TRANSPOSE(B42:G42))-H42","v":-2.1536834537982941E-9}]
[]
[]
[]
[null,"Coordonnées des points (mm)",null,null,null,null,null,"Pesanteur",null,"Poids (N)"]
[null,"Xf","Xe","Xk","Xh","Xg",null,"g",null,"Pt","Pc","Pb1","Pb2"]
[null,0,{"$f":"Lb*COS(alpha)","v":1697.0562748477141},{"$f":"Xe/2","v":848.52813742385706},0,{"$f":"Xe","v":1697.0562748477141},null,"(m/s/s)",null,"(N)","(N)","(N)","(N)"]
[null,null,null,null,null,null,null,9.81,null,{"$f":"-Mt*g","v":-294.3},{"$f":"-Mc*g","v":-19620},{"$f":"-Mb1_*g","v":-196.20000000000002},{"$f":"-Mb2_*g","v":-196.20000000000002}]
[null,"Yf","Ye","Yk","Yh","Yg"]
[null,0,0,{"$f":"HF/2","v":300},{"$f":"HF","v":600},{"$f":"HF","v":600},null,null,null,"Efforts"]
[null,null,null,null,null,null,null,null,null,"Rg","Rh","Fg","Fh"]
[null,null,null,null,null,null,null,null,null,"(N)","(N)","(N)","(N)"]
[null,null,null,null,null,null,null,null,null,{"$f":"-(XGt*Pt+XGc*Pc)/Xg","v":10578.494223246047},{"$f":"-Rg-Pt-Pc","v":9335.8057767539522},{"$f":"-Rg","v":-10578.494223246047},{"$f":"-Rh","v":-9335.8057767539522}]
[null,null,"Dessin",null,null,"Angle α bras FG / Ox"]
[null,"Points","X","Y",null,"(rad)","( ° )"]
[null,"H",{"$f":"Xh","v":0},{"$f":"Yh","v":600},null,{"$f":"ASIN(HF/Lb)","v":0.33983690945412193},{"$f":"DEGREES(F57)","v":19.471220634490692}]
[null,"E",{"$f":"Xe","v":1697.0562748477141},{"$f":"Ye","v":0}]
[null,"F",{"$f":"Xf","v":0},{"$f":"Yf","v":0}]
[null,"G",{"$f":"Xg","v":1697.0562748477141},{"$f":"Yg","v":600},null,"Equations utilisées ci-dessus",null,null,null,null,null,null,"Vérif 2"]
[null,null,null,null,null,"1","XFk+XRf = 0",null,null,null,null,null,{"$f":"XFk+XRf","v":0}]
[null,"Table",{"$f":"C57","v":0},{"$f":"D57","v":600},null,"2","Fg+YFk+Pb1_+Yrf = 0",null,null,null,null,null,{"$f":"Fg+YFk+Pb1_+YRf","v":0}]
[null,null,{"$f":"Lb+100","v":1900},{"$f":"D62","v":600},null,"3","Xg*Fg+Xk*YFk-Yk*XFk+Xk*Pb1_-Yf*XRf = 0",null,null,null,null,null,{"$f":"Xg*Fg+Xk*YFk-Yk*XFk+Xk*Pb1_-Yf*XRf","v":1.57160684466362E-9}]
[null,null,null,null,null,"4","-XFk+Xre = 0",null,null,null,null,null,{"$f":"-XFk+XRe","v":0}]
[null,"Gc",{"$f":"XGc","v":900},{"$f":"D57+100","v":700},null,"5","Fh+Pb2_-YFk+Yre = 0",null,null,null,null,null,{"$f":"Fh+Pb2_-YFk+YRe","v":0}]
[null,"Gt",{"$f":"XGt","v":1000},{"$f":"D57","v":600},null,"6","-Xk*YFk+Yk*XFk+Xk*Pb2_+Xe*YRe-Ye*XRe = 0",null,null,null,null,null,{"$f":"-Xk*YFk+Yk*XFk+Xk*Pb2_+Xe*YRe-Ye*XRe","v":-3.7252902984619141E-9}]
[]
[null,"Pour mise à jour échelle et proportions"]
[null,null,"X","Y"]
[null,"Min",0,0]
[null,"Max",{"$f":"1.2*Lb","v":2160},{"$f":"1.2*Hmax","v":1200}]
[]
[]
[]
[]
[]
[null,"Calcul de l'effort du vérin par les travaux virtuels (pour info.) et comparaison avec calcul par les équations ci-dessus (ne pas oublier de modifier éventuellement les valeurs des hauteurs mini et maxi)"]
[]
[null,null,null,null,"Charge* table+bras (N)",null,"* avec poids équivalent des bras ramené au niveau de la table pour le même déplacement des CdG"]
[]
[]
[null,null,null,null,{"$f":"Fh+Fg+(Pb1_+Pb2_)/2","v":-20110.5}]
[]
[null,"Hauteur table HF\n(mm)","Longueur vérin DB\n(mm)","Calcul force vérin (val. abs.)",null,null,"Les trois colonnes bleues sont remplies par le code VBA dès qu'une modification intervient dand les cellules jaunes ; la colonne orange est calculées par formule, en fonction des valeurs des colonnes bleues"]
[null,null,null,"par travaux virtuels\n(N)","par les équations\n(N)"]
[]
[]
[null,200,1788.8543819998317,null,179873.78024603808]
[null,208,1787.9418335057771,{"$f":"ChEqu*(B90-B88)/(C90-C88)","v":172865.57422287279},172867.3280899901]
[null,216,1786.9930050226833,166374.80297099683,166376.49457179938]
[null,224,1786.0078387285987,160344.39575888112,160346.02964621197]
[null,232,1784.9862744570335,154726.7235041052,154728.30376063869]
[null,240,1783.9282496782207,149480.50747052417,149482.0377714744]
[null,248,1782.8336994795673,144569.79501724427,144571.27868299934]
[null,256,1781.7025565452836,139963.12739469207,139964.56743517163]
[null,264,1780.5347511351749,135632.85885034085,135634.25800266641]
[null,272,1779.3302110625784,131554.59589219952,131555.95665284552]
[null,280,1778.0888616714296,127706.73267852636,127708.05733086888]
[null,288,1776.8106258124415,124070.06384260226,124071.35448055938]
[null,296,1775.4954238183775,120627.46010243487,120628.71865101176]
[null,304,1774.1431734783978,117363.59509000744,117364.82332314909]
[null,312,1772.7537900114612,114264.71420683574,114265.91376290219]
[null,320,1771.3271860387622,111318.43815098838,111319.61054635163]
[null,328,1769.8632715551785,108513.59519624276,108514.74183722687]
[null,336,1768.36195389971,105840.07743129814,105841.19962470273]
[null,344,1766.8231377248828,103288.71705859003,103289.81602097749]
[null,352,1765.2467249650967,100851.17956140095,100852.2564273028]
[null,360,1763.6326148038881,98519.871115225455,98520.926944482213]
[null,368,1761.9807036400823,96287.858075910903,96288.89386020074]
[null,376,1760.2908850528086,94148.79674583138,94149.813414506658]
[null,384,1758.5630497653476,92096.871919229729,92097.870344546915]
[null,392,1756.7970856077829,90126.742952592132,90127.723954375804]
[null,400,1754.9928774784244,88233.496306440094,88234.460656324634]
[null,408,1753.1503073039687,86412.603670419005,86413.552095677631]
[null,416,1751.2692539983677,84659.884920088763,84660.818107053303]
[null,424,1749.3495934203659,82971.475267154674,82972.393864340251]
[null,432,1747.39119832967,81343.796059613218,81344.700680576003]
[null,440,1745.3939383417144,79773.528767337266,79774.419993229647]
[null,448,1743.357679880982,78257.59175479367,78258.470136710894]
[null,456,1741.2822861328373,76793.11949868199,76793.985559812325]
[null,464,1739.1676169938307,{"$f":"ChEqu*(B122-B120)/(C122-C120)","v":75377.443955432216},75378.298193005263]
[null,472,1737.0135290204278,74008.07782341876,74008.920710519727]
[null,480,1734.8198753761153,72682.699478948198,72683.531466148692]
[null,488,1732.5865057768401,71399.139393839389,71399.960910707261]
[null,496,1730.3132664347229,70155.367867362205,70156.179323861885]
[null,504,1728,68949.483926523244,68950.28571428571]
[null,512,1725.6465455011348,67779.705266836492,67780.497760352693]
[null,520,1723.2527382830413,66644.359121604226,66645.142679309807]
[null,528,1720.818409943362,65541.873961155594,65542.648926450725]
[null,536,1718.3433882667341,64470.771935390738,64471.538637571175]
[null,544,1715.827497156984,63429.661983070466,63430.420738190311]
[null,552,1713.2705565671756,62417.233540204172,62417.984651891638]
[null,560,1710.6723824274479,61432.250787655292,61432.994547869981]
[null,568,1708.0327865705624,60473.547384793492,60474.284074519892]
[null,576,1705.3515766550895,59540.021641924497,59540.751531809321]
[null,584,1702.6285560861477,58630.63208937474,58631.355440360407]
[null,592,1699.8635239336127,57744.393405824048,57745.110469707623]
[null,600,1697.0562748477141,56880.372672245547,56881.083692208267]
[null,608,1694.2065989719201,56037.685921487762,56038.391132606579]
[null,616,1691.3142818530209,55215.494956671086,55216.194586372047]
[null,624,1688.3791043483095,54413.004414183495,54413.698682686976]
[null,632,1685.4008425297527,53629.459049655175,53630.148170402827]
[null,640,1682.379267585047,52864.141227423315,52864.825407451703]
[null,648,1679.3141457154463,52116.368595818283,52117.048036127286]
[null,656,1676.2052380302362,51385.491932444478,51386.166828364432]
[null,664,1673.052300437736,50670.893145172566,50671.563686676345]
[null,672,1669.8550835326998,49971.98341576539,49972.649787774353]
[null,680,1666.6133324799725,49288.201474427406,49288.863857115408]
[null,688,1663.3267868942651,48619.011994641587,48619.670563716732]
[null,696,1659.9951807158959,47963.904098587336,47964.559025556067]
[null,704,1656.6182420823452,47322.389964342066,47323.041416757114]
[null,712,1653.1956931954546,46694.003526843102,46694.651668549428]
[null,720,1649.7272501841023,{"$f":"ChEqu*(B154-B152)/(C154-C152)","v":46078.29926533968},46078.944256704708]
[null,728,1646.2126229621738,45474.851070656659,45475.493068792304]
[null,736,1642.6515150816376,44883.251186205969,44883.890345175641]
[null,744,1639.0436235805316,44303.109217173151,44303.745688193943]
[null,752,1635.3886388256462,43734.051202800707,43734.685134445688]
[null,760,1631.6862443496912,43175.718747138359,43176.350285519024]
[null,768,1627.9361166827155,42627.768203956482,42628.397492900702]
[null,776,1624.1379251775386,42089.869911916496,42090.497093148057]
[null,784,1620.29133182894,41561.707476418109,41562.3326897269]
[null,792,1616.3959910863425,41042.977094808368,41043.600478209461]
[null,800,1612.4515496597098,40533.386921893005,40534.00861178949]
[null,808,1608.4576463183605,40032.656472970986,40033.276604313593]
[null,816,1604.4139116823937,39540.516061813083,39541.134768246055]
[null,824,1600.3199680063985,39056.706271171774,39057.323685185278]
[null,832,1596.1754289551009,38580.977453656364,38581.593706732638]
[null,840,1591.979899370592,38113.08926092706,38113.7044836813]
[null,848,1587.7329750307513,37652.810199320476,37653.424521646135]
[null,856,1583.4342423984649,37199.917210186322,37200.530761395239]
[null,864,1579.0832783612143,36754.195273313322,36754.808182272216]
[null,872,1574.679649960588,36315.437031948211,36316.049427216065]
[null,880,1570.2229141112418,35883.442438023165,35884.054447993331]
[null,888,1565.7126173088086,35458.018416324456,35458.630169356751]
[null,896,1561.1482953262321,35038.978546374514,35039.59017093548]
[null,904,1556.5294728979595,34626.142760946263,34626.754385746033]
[null,912,1551.8556633914122,34219.337060160527,34219.948814290561]
[null,920,1547.1263684650974,33818.393240203142,33819.005253279713]
[null,928,1542.3410777127087,33423.148635783698,33423.761038083438]
[null,936,1537.499268292509,33033.44587546392,33034.058798073187]
[null,944,1532.600404541249,32649.132649117735,32649.746224074985]
[null,952,1527.6439375718414,32270.061486760245,32270.675847204322]
[null,960,1522.6293048539424,31896.089548077787,31896.70482840126]
[null,968,1517.5559297765601,31527.07842202525,31527.694758028421]
[null,976,1512.4232211917401,31162.893935885459,31163.511464934934]
[null,984,1507.2305729383279,30803.405973233013,30804.024834427084]
[null,992,1501.9773633447344,30448.488300283618,30449.108634621247]
[null,1000,1496.6629547095765,null,30098.640350686939]

{"sheet":"Calculs manuels","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}