{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Calcul"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":19,"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":"Calcul","index":0,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[[10,3,10,4],[2,1,2,4],[1,1,1,4],[3,2,3,4]]}
[]
[null,"CALCUL DU BALANCEMENT D'UN ESCALIER"]
[null,"Méthode du Trapèze de proportion"]
[null,"mise à jour le 15-08-2017"]
[]
[null,"Giron de la marche :",24,"cm"]
[null,"Nombre de marches entières à balancer :",4,{"$f":"IF(Marches>1,\"marches\",\"marche\")","v":"marches"}]
[null,"Longueur de la ligne de collet à balancer :",81.599999999999994,"cm"]
[null,"Largeur du collet partiel :",6,"cm",null,null,null,"ligne collet",{"$f":"ligne_à_balancer-C9","v":75.599999999999994},"cm"]
[null,null,null,null,null,null,null,"moyenne",{"$f":"I9/Marches","v":18.899999999999999},"cm"]
[null,{"$f":"IF(Marches>10,\"ERREUR : Le nombre maxi de marches est de 10\",\"Dimensions des collets de marche\")","v":"Dimensions des collets de marche"},null,"Collet marche",null,null,null,"talon",{"$f":"Moyenne-(Giron-Moyenne)","v":13.799999999999997},"cm"]
[null,{"$f":"IF(C12=\"\",\"\",\"Ligne de collet de la plus petite marche :\")","v":"Ligne de collet de la plus petite marche :"},{"$f":"IF(ROW(C12)-ROW(C$11)>Marches,\"\",ROW(C12)-ROW(C$11))","v":1},{"$f":"IF(B12=\"\",\"\",Talon+(unité_allongement*G12))","v":15.839999999999998},{"$f":"IF(C12=\"\",\"\",\"cm\")","v":"cm"},null,1,"nbre unité all.",{"$f":"SUM(C12:C21)","v":10}]
[null,{"$f":"IF(C13=\"\",\"\",\"Numéro de la marche :\")","v":"Numéro de la marche :"},2,17.88,"cm",null,2,"unité allongement",{"$f":"(I9-(Marches*Talon))/Nbre_unités.","v":2.0400000000000005},"cm"]
[null,{"$f":"IF(C14=\"\",\"\",\"Numéro de la marche :\")","v":"Numéro de la marche :"},3,19.919999999999998,"cm",null,3]
[null,"Numéro de la marche :",4,21.96,"cm",null,4]
[null,"","","","",null,5]
[null,"","","","",null,6]
[null,"","","","",null,7]
[null,"","","","",null,8]
[null,"","","","",null,9]
[null,"","","","",null,10]
[null,null,null,null,"Lionel Ponnelle"]