{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Online","_","Main","Matos","TMP"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":1,"defined_names":183,"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":"Online","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"_","index":1,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,"Ouverture en cours, merci de patienter quelques instants…"]
[null,null,null,null,null,null,null,null,"Ce fichier vous est offert par Méthodes BTP"]
[null,null,null,null,null,null,null,null,"http://www.methodesbtp.com"]
[]
[]
[null,null,null,null,"Vous patientez depuis plus de 30 secondes et rien ne se passe ?"]
[null,null,null,null,null,"1. Allez dans les options Excel et activez les Macros. Pour Excel 2003 : installez le package OWC11.exe"]
[null,null,null,null,null,"2. Placez les options de sécurité au plus faible et indiquez que vous faites confiance au projet Visual Basic"]
[null,null,null,null,null,"3. Fermez complètement toutes les instances d'Excel"]
[null,null,null,null,null,"4. Ré-ouvrez ce fichier"]

{"sheet":"Main","index":2,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[[17,1,17,3]]}
["Calepinage de coffrage modulaire de plancher"]
[]
[null,"Lg = Largeur de la pièce",6.8,null,"Dp = Distance mini entre l'axe des primaires et les murs",null,null,null,null,0.15]
[null,"La = Longueur de la pièce",6.12,null,"Ds = Distance mini entre l'axe des secondaires et les murs",null,null,null,null,0.1]
[null,null,null,null,"Es =  Espacement des poutrelles secondaires",null,null,null,null,0.4]
[null,"Poutrelles primaires parrallèles à la","Longueur"]
[]
[null,null,"Autoriser","Oui","Oui","Non","Non","Non",null,null,0]
[null,"Sens de la longueur",{"$f":"IF(C6=\"Longueur\",\"Primaires\",\"Secondaires\")","v":"Primaires"},{"$f":"INDIRECT(\"Matos!\" & ADDRESS(COUNTA($C9:C9)+1,MATCH($C9,LstTailles)))","v":2},{"$f":"INDIRECT(\"Matos!\" & ADDRESS(COUNTA($C9:D9)+1,MATCH($C9,LstTailles)))","v":1.8},{"$f":"INDIRECT(\"Matos!\" & ADDRESS(COUNTA($C9:E9)+1,MATCH($C9,LstTailles)))","v":1.5},{"$f":"INDIRECT(\"Matos!\" & ADDRESS(COUNTA($C9:F9)+1,MATCH($C9,LstTailles)))","v":1.1000000000000001},{"$f":"INDIRECT(\"Matos!\" & ADDRESS(COUNTA($C9:G9)+1,MATCH($C9,LstTailles)))","v":0.9},{"$f":"INDIRECT(\"Matos!\" & ADDRESS(COUNTA($C9:H9)+1,MATCH($C9,LstTailles)))","v":0},{"$f":"INDIRECT(\"Matos!\" & ADDRESS(COUNTA($C9:I9)+1,MATCH($C9,LstTailles)))","v":0},{"$f":"INDIRECT(\"Matos!\" & ADDRESS(COUNTA($C9:J9)+1,MATCH($C9,LstTailles)))","v":0},{"$f":"INDIRECT(\"Matos!\" & ADDRESS(COUNTA($C9:K9)+1,MATCH($C9,LstTailles)))","v":0},{"$f":"INDIRECT(\"Matos!\" & ADDRESS(COUNTA($C9:L9)+1,MATCH($C9,LstTailles)))","v":0},{"$f":"INDIRECT(\"Matos!\" & ADDRESS(COUNTA($C9:M9)+1,MATCH($C9,LstTailles)))","v":0},{"$f":"INDIRECT(\"Matos!\" & ADDRESS(COUNTA($C9:N9)+1,MATCH($C9,LstTailles)))","v":0}]
[null,"Longueur équipée",{"$f":"SUMPRODUCT((D9:O9)*(D10:O10))","v":5.8},{"$f":"IF(D8=\"Non\",0,INT((LongPièce-DiMiniFacade2*2)/D9))","v":2},{"$f":"IF(E9<>0,IF(E8=\"Non\",0,INT((LongPièce-DiMiniFacade2*2-SUMPRODUCT(($D9:D9)*($D10:D10)))/E9)),0)","v":1},{"$f":"IF(F9<>0,IF(F8=\"Non\",0,INT((LongPièce-DiMiniFacade2*2-SUMPRODUCT(($D9:E9)*($D10:E10)))/F9)),0)","v":0},{"$f":"IF(G9<>0,IF(G8=\"Non\",0,INT((LongPièce-DiMiniFacade2*2-SUMPRODUCT(($D9:F9)*($D10:F10)))/G9)),0)","v":0},{"$f":"IF(H9<>0,IF(H8=\"Non\",0,INT((LongPièce-DiMiniFacade2*2-SUMPRODUCT(($D9:G9)*($D10:G10)))/H9)),0)","v":0},{"$f":"IF(I9<>0,IF(I8=\"Non\",0,INT((LongPièce-DiMiniFacade2*2-SUMPRODUCT(($D9:H9)*($D10:H10)))/I9)),0)","v":0},{"$f":"IF(J9<>0,IF(J8=\"Non\",0,INT((LongPièce-DiMiniFacade2*2-SUMPRODUCT(($D9:I9)*($D10:I10)))/J9)),0)","v":0},{"$f":"IF(K9<>0,IF(K8=\"Non\",0,INT((LongPièce-DiMiniFacade2*2-SUMPRODUCT(($D9:J9)*($D10:J10)))/K9)),0)","v":0},{"$f":"IF(L9<>0,INT((LongPièce-DiMiniFacade2*2-SUMPRODUCT(($D9:K9)*($D10:K10)))/L9),0)","v":0},{"$f":"IF(M9<>0,INT((LongPièce-DiMiniFacade2*2-SUMPRODUCT(($D9:L9)*($D10:L10)))/M9),0)","v":0},{"$f":"IF(N9<>0,INT((LongPièce-DiMiniFacade2*2-SUMPRODUCT(($D9:M9)*($D10:M10)))/N9),0)","v":0},{"$f":"IF(O9<>0,INT((LongPièce-DiMiniFacade2*2-SUMPRODUCT(($D9:N9)*($D10:N10)))/O9),0)","v":0}]
[null,"Distance poutrelles/mur",{"$f":"(LongPièce-C10)/2","v":0.16000000000000014}]
[]
[null,null,"Autoriser","Non","Non","Oui","Oui"]
[null,"Sens de la largeur",{"$f":"IF(C6=\"Longueur\",\"Secondaires\",\"Primaires\")","v":"Secondaires"},{"$f":"INDIRECT(\"Matos!\" & ADDRESS(COUNTA($C14:C14)+1,MATCH($C14,LstTailles)))","v":1.8},{"$f":"INDIRECT(\"Matos!\" & ADDRESS(COUNTA($C14:D14)+1,MATCH($C14,LstTailles)))","v":1.5},{"$f":"INDIRECT(\"Matos!\" & ADDRESS(COUNTA($C14:E14)+1,MATCH($C14,LstTailles)))","v":1.1000000000000001},{"$f":"INDIRECT(\"Matos!\" & ADDRESS(COUNTA($C14:F14)+1,MATCH($C14,LstTailles)))","v":0},{"$f":"INDIRECT(\"Matos!\" & ADDRESS(COUNTA($C14:G14)+1,MATCH($C14,LstTailles)))","v":0},{"$f":"INDIRECT(\"Matos!\" & ADDRESS(COUNTA($C14:H14)+1,MATCH($C14,LstTailles)))","v":0},{"$f":"INDIRECT(\"Matos!\" & ADDRESS(COUNTA($C14:I14)+1,MATCH($C14,LstTailles)))","v":0},{"$f":"INDIRECT(\"Matos!\" & ADDRESS(COUNTA($C14:J14)+1,MATCH($C14,LstTailles)))","v":0},{"$f":"INDIRECT(\"Matos!\" & ADDRESS(COUNTA($C14:K14)+1,MATCH($C14,LstTailles)))","v":0},{"$f":"INDIRECT(\"Matos!\" & ADDRESS(COUNTA($C14:L14)+1,MATCH($C14,LstTailles)))","v":0},{"$f":"INDIRECT(\"Matos!\" & ADDRESS(COUNTA($C14:M14)+1,MATCH($C14,LstTailles)))","v":0},{"$f":"INDIRECT(\"Matos!\" & ADDRESS(COUNTA($C14:N14)+1,MATCH($C14,LstTailles)))","v":0}]
[null,"Longueur équipée",{"$f":"SUMPRODUCT((D14:O14)*(D15:O15))","v":5.5},{"$f":"IF(D13=\"Non\",0,INT((LargPièce-DiMiniFacade*2)/D14))","v":0},{"$f":"IF(E14<>0,IF(E13=\"Non\",0,INT((LargPièce-DiMiniFacade*2-SUMPRODUCT(($D14:D14)*($D15:D15)))/E14)),0)","v":0},{"$f":"IF(F14<>0,IF(F13=\"Non\",0,INT((LargPièce-DiMiniFacade*2-SUMPRODUCT(($D14:E14)*($D15:E15)))/F14)),0)","v":5},{"$f":"IF(G14<>0,IF(G13=\"Non\",0,INT((LargPièce-DiMiniFacade*2-SUMPRODUCT(($D14:F14)*($D15:F15)))/G14)),0)","v":0},{"$f":"IF(H14<>0,IF(H13=\"Non\",0,INT((LargPièce-DiMiniFacade*2-SUMPRODUCT(($D14:G14)*($D15:G15)))/H14)),0)","v":0},{"$f":"IF(I14<>0,IF(I13=\"Non\",0,INT((LargPièce-DiMiniFacade*2-SUMPRODUCT(($D14:H14)*($D15:H15)))/I14)),0)","v":0},{"$f":"IF(J14<>0,IF(J13=\"Non\",0,INT((LargPièce-DiMiniFacade*2-SUMPRODUCT(($D14:I14)*($D15:I15)))/J14)),0)","v":0},{"$f":"IF(K14<>0,IF(K13=\"Non\",0,INT((LargPièce-DiMiniFacade*2-SUMPRODUCT(($D14:J14)*($D15:J15)))/K14)),0)","v":0},{"$f":"IF(L14<>0,INT((LargPièce-DiMiniFacade*2-SUMPRODUCT(($D14:K14)*($D15:K15)))/L14),0)","v":0},{"$f":"IF(M14<>0,INT((LargPièce-DiMiniFacade*2-SUMPRODUCT(($D14:L14)*($D15:L15)))/M14),0)","v":0},{"$f":"IF(N14<>0,INT((LargPièce-DiMiniFacade*2-SUMPRODUCT(($D14:M14)*($D15:M15)))/N14),0)","v":0},{"$f":"IF(O14<>0,INT((LargPièce-DiMiniFacade*2-SUMPRODUCT(($D14:N14)*($D15:N15)))/O14),0)","v":0}]
[null,"Distance poutrelles/mur",{"$f":"(LargPièce-C15)/2","v":0.64999999999999991}]
[]
[null,"Débit de matériel"]
[null,"Contreplaqué",{"$f":"LargPièce*LongPièce","v":41.616}]
[null,"Poutelles primaires",{"$f":"IF(Choix=\"Longueur\",SUM(D10:P10)*(SUM(D15:P15)+1),SUM(D15:P15)*(SUM(D10:P10)+1))","v":18},{"$f":"IF(Choix=\"Longueur\",LgEquipLong*(1+SUM(D15:O15)),LgEquipLarg*(1+SUM(D10:O10)))","v":34.799999999999997}]
[null,"Poutrelles secondaires",{"$f":"IF(Choix=\"Longueur\",ROUNDUP((LgEquipLong)/EspaceSecondaires,0),ROUNDUP((LgEquipLarg)/EspaceSecondaires,0))","v":15},{"$f":"IF(Choix=\"Longueur\",LgEquipLarg*C21,LgEquipLong*C21)","v":82.5}]
[null,"Etais",{"$f":"(SUM(D10:P10)+1)*(SUM(D15:P15)+1)","v":24}]

{"sheet":"Matos","index":3,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Primaires","Secondaires"]
[2,1.8]
[1.8,1.5]
[1.5,1.1000000000000001]
[1.1000000000000001]
[0.9]

{"sheet":"TMP","index":4,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Non","Non","Oui","Oui"]