{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["FR"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":2,"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":"FR","index":0,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["Algarve/ Aero - Montage sur la façade / Position des trous de fixation"]
[]
["Dimension",null,null,"par pas de lame ou au mm ","pas de lame",null,null,"mm"]
["couverture terrace",null,null,"Pivot",5000,null,"Span",3000]
[]
[]
["Specifications",null,null,"Nombre de trous Pivot",{"$f":"IF(Pivot<=5000,ROUNDUP(Pivot/1000,0),6)","v":5},null,"Nombre de trous Span",{"$f":"IF(SPAN<=4000,ROUNDUP(SPAN/1000,0),4)","v":3}]
[null,null,null,"Nombre de lames",{"$f":"IF(E3=\"stap\",bankersround((Pivot-245)/215,0),ROUNDDOWN((Pivot-306)/215,0))","v":21},null,"Abaissement de trou",{"$f":"IF(E3=\"mm\",15.5,0)","v":0}]
[null,null,null,"longueur restante",{"$f":"IF(E3=\"stap\",0,(Pivot-(E8-1)*215-80-130)/2)","v":245},null,"Drainage vers","P1"]
[null,null,null,"lamel gat 1",{"$f":"IF(E3=\"mm\",E9+40+128.6,70+186.5+40)","v":296.5}]
[]
["Trous de fixation dans le mur"]
[]
["S1"]
[]
[]
[null,null,null,null,null,null,"mm",null,"mm"]
[null,null,null,null,null,"X1",{"$f":"150+110","v":260},"Y1",{"$f":"IF($H$9=\"P1\",50+$H$8,30+$H$8)","v":50},150]
[null,null,null,null,null,"X2",{"$f":"IF(SPAN<=2000,0,IF(SPAN<=3000,J19+110,IF(SPAN<=4500,J19+110,0)))","v":1500},"Y2",{"$f":"IF(SPAN<=3000,0,IF(I21>I18,37+$H$8,43+$H$8))","v":0},{"$f":"IF(SPAN<=2000,0,IF(SPAN<=3000,bankersround(J18+(J21-J18)/2,1),IF(SPAN<=4500,bankersround(J18+(J21-J18)/3,1),0)))","v":1390}]
[null,null,null,null,null,"X3",{"$f":"IF(SPAN<=3000,0,J20+110)","v":0},"Y3",{"$f":"IF(SPAN<=2000,0,IF(SPAN<=3000,40+$H$8,IF(I21>I18,43+$H$8,37+$H$8)))","v":40},{"$f":"IF(SPAN<=3000,0,bankersround(J18+(J21-J18)*(2/3),1))","v":0}]
[null,null,null,null,null,"X4",{"$f":"(SPAN-150-110)","v":2740},"Y4",{"$f":"IF($H$9=\"P1\",30+$H$8,50+$H$8)","v":30},{"$f":"SPAN-J18-2*110","v":2630}]
[]
[]
["S2"]
[]
[]
[null,null,null,null,null,null,"mm",null,"mm"]
[null,null,null,null,null,"X1",{"$f":"150+110","v":260},"Y1",{"$f":"IF($H$9=\"P2\",30,50)","v":50},150]
[null,null,null,null,null,"X2",{"$f":"IF(SPAN<=2000,0,IF(SPAN<=3000,J29+110,IF(SPAN<=4500,J29+110,0)))","v":1500},"Y2",{"$f":"IF(SPAN<=2000,0,IF(SPAN<=3000,40,IF(I28>I31,43,37)))","v":40},{"$f":"IF(SPAN<=2000,0,IF(SPAN<=3000,bankersround(J28+(J31-J28)/2,1),IF(SPAN<=4500,bankersround(J28+(J31-J28)/3,1),0)))","v":1390}]
[null,null,null,null,null,"X3",{"$f":"IF(SPAN<=3000,0,J30+110)","v":0},"Y3",{"$f":"IF(SPAN<=3000,0,IF(I28>I31,37,43))","v":0},{"$f":"IF(SPAN<=3000,0,bankersround(J28+(J31-J28)*(2/3),1))","v":0}]
[null,null,null,null,null,"X4",{"$f":"(SPAN-150-110)","v":2740},"Y4",{"$f":"IF($H$9=\"P2\",50,30)","v":30},{"$f":"SPAN-J28-2*110","v":2630}]
[]
[]
[]
["P1"]
[]
[]
["P1"]
["P2"]
[]
[]
[]
[]
[null,null,null,null,null,null,null," P1 + P2"]
[]
[null,null,null,null,null,null,null,"mm","trou lame"]
[null,null,null,null,null,null,"X1",{"$f":"E10+(I47-1)*215","v":511.5},2]
[null,null,null,null,null,null,"X2",{"$f":"IF(I51=0,0,E10+(E8-I51)*215)","v":0},{"$f":"IF(E7<=2,0,IF(E7<=3,I47+bankersround((I52-I47)/2,0),IF(E7<=4,I47+bankersround((I52-I47)*(1/3),0),IF(E7<=5,I47+bankersround((I52-I47)*(1/4),0),IF(E7<=6,I47+bankersround((I52-I47)*(1/5),0),0)))))","v":6}]
["P2",null,null,null,null,null,"X3",{"$f":"IF(I50=0,0,E10+((E8-I50)*215))","v":1371.5},{"$f":"IF(E7<=3,0,IF(E7<=4,I47+bankersround((I52-I47)*(2/3),0),IF(E7<=5,I47+bankersround((I52-I47)*(2/4),0),IF(E7<=6,I47+bankersround((I52-I47)*(2/5),0),0))))","v":11}]
[null,null,null,null,null,null,"X4",{"$f":"IF(I49=0,0,E10+((E8-I49)*215))","v":2446.5},{"$f":"IF(E7<=3,0,IF(E7<=4,0,IF(E7<=5,I47+bankersround((I52-I47)*(3/4),0),IF(E7<=6,I47+bankersround((I52-I47)*(3/5),0),0))))","v":16}]
[null,null,null,null,null,null,"X5",{"$f":"IF(I48=0,0,E10+((E8-I48))*215)","v":3521.5},{"$f":"IF(E7<=5,0,I47+bankersround((I52-I47)*(4/5),0))","v":0}]
[null,null,null,null,null,null,"X6",{"$f":"E10+(I52-1)*215","v":4381.5},{"$f":"E8-1","v":20}]