{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["PV Field Calculator","Feuil2"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":25,"comments":1,"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":"PV Field Calculator","index":0,"n_rows":123,"n_cols":44,"rows_kept":123,"cut":false,"hidden":false,"merged":[[35,17,35,37],[26,1,26,2],[24,1,24,2],[110,0,115,0],[30,1,30,2],[31,1,31,2],[28,1,28,2],[27,1,27,2],[37,0,92,0],[72,15,92,15],[38,15,56,15],[36,17,36,37],[36,4,36,7],[36,9,36,10]]}
[null,"Project Name :"]
[null,"Customer :"]
[null,"Date :"]
[]
["1. Module features"]
[]
[null,"Height :",null,null,{"$f":"$AM$37&\" :\"","v":"Junction Box :"},"Single"]
[null,"Width :",null,null,{"$f":"$AN$37&\" :\"","v":"Rear support bar(s) :"},"NON"]
[null,"Thickness :"]
["2.  Components data : Tray(s) & clamps references"]
[]
[null,null,{"$f":"AM41","v":"Portrait"},{"$f":"AM42","v":"Landscape"}]
[null,"GSE references","Tray(s) selection","Tray(s) selection"]
[null,"Clamps",{"$f":"INDEX(rech_etrier,MATCH($C$13,Ref_plaques,0),MATCH($C$9,Epaisseur_module__mm,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(rech_etrier,MATCH($D$13,Ref_plaques,0),MATCH($C$9,Epaisseur_module__mm,0))","v":{"$error":"#N/A"}}]
[null,"Ref. Height (mm)",{"$f":"VLOOKUP($C$13,base_po,7,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($D$13,base_pa,7,0)","v":{"$error":"#N/A"}}]
[null,"Ref. Width (mm)",{"$f":"VLOOKUP($C$13,base_po,8,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($D$13,base_pa,8,0)","v":{"$error":"#N/A"}}]
[null,"Graduation (mm)",{"$f":"IF((C7-C15)>0,MROUND(C7-C15,5)*Ajust_haut,0)","v":{"$error":"#N/A"}},{"$f":"IF((C8-D15)>0,MROUND(C8-D15,5),0)","v":{"$error":"#N/A"}}]
[null,"Rows spacing (mm)",{"$f":"10-(C7-MROUND(C15,5)-C17/Ajust_haut)","v":{"$error":"#N/A"}},{"$f":"10-(C8-MROUND(D15,5)-D17)","v":{"$error":"#N/A"}}]
[]
["3. PV-Field data"]
[]
[null,"Configuration","Rows","Columns"]
[null,"Portrait"]
[]
[null,"Field dimensions"]
[null,null,null,"Height (m)"]
[null,"GSE plates only (A+B)",null,{"$f":"IFERROR(((MROUND(HLOOKUP($B$23,données_plaques,4,0),5)+HLOOKUP($B$23,données_plaques,6,0)/Ajust_haut+10)*$C$23+(Haut_Plaque-HLOOKUP($B$23,données_plaques,6,0)))/1000,\"\")","v":""}]
[null,"Layout to the gutter (A+B+C+D)",null,{"$f":"IFERROR(D27+0.15+0.05,\"\")","v":""}]
[null,"Layout in the center (A+B+C+D+E)",null,{"$f":"IFERROR(D28+0.1,\"\")","v":""}]
[null,null,null,"Length (m)"]
[null,"GSE plates only (≈F)",null,{"$f":"IFERROR(((HLOOKUP($B$23,données_plaques,5,0)+Pas_ondes)*$D$23+débord_ondes)/1000,\"\")","v":""}]
[null,"w/ lateral flashings (F+2G)",null,{"$f":"IFERROR(((HLOOKUP($B$23,données_plaques,5,0)+Pas_ondes)*$D$23+172*2)/1000,\"\")","v":""}]
[]
[]
[]
[null,null,null,null,-50,100,-4,0,null,null,null,null,null,null,null,null,null,"Etriers"]
[null,null,null,"Référence","Tolérances dimensionnelles",null,null,null,null,"Dimensions de référence de la plaque GSE",null,null,null,null,null,null,null,"Epaisseur module (mm)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Junction Box","Rear support bar(s)",{"$f":"L38","v":"Pas ondes"},{"$f":"M38","v":"Débord ondes"},"Ajust_haut","Haut_Plaque"]
["Base Plaque",null,null,"PLAQUE","HAUTEUR MINIMUM","HAUTEUR MAXIMUM","LARGEUR MINIMUM","LARGEUR MAXIMUM",null,"Hauteur ref","Larg ref","Pas ondes","Débord ondes","Ajust_haut","Haut  plaque",null,null,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,"Single","OUI",{"$f":"IF($B$23=$AM$41,VLOOKUP($C$13,base_po,9,0),VLOOKUP($D$13,base_pa,9,0))","v":{"$error":"#N/A"}},{"$f":"IF($B$23=$AM$41,VLOOKUP($C$13,base_po,10,0),VLOOKUP($D$13,base_pa,10,0))","v":{"$error":"#N/A"}},{"$f":"IF($B$23=$AM$41,VLOOKUP($C$13,base_po,11,0),VLOOKUP($D$13,base_pa,11,0))","v":{"$error":"#N/A"}},{"$f":"IF($B$23=$AM$41,VLOOKUP($C$13,base_po,12,0),VLOOKUP($D$13,base_pa,12,0))","v":{"$error":"#N/A"}}]
[null,{"$f":"\"OK\"&IF(C39=\"faux\",0,COUNTIF($C$39:C39,C39))","v":"OK0"},{"$f":"IF($F$8=$AN$38,\"FAUX\",IF($F$7=$AM$39,\"FAUX\",IF(AND($C$7>=E39,$C$7<=F39,$C$8>=G39,$C$8<=H39,$C$9>=35),\"OK\",\"FAUX\")))","v":"FAUX"},{"$f":"\"Po_\"&J39&\"_\"&K39","v":"Po_1575_1046"},{"$f":"$J39+E$36","v":1525},{"$f":"$J39+F$36","v":1675},{"$f":"$K39+G$36","v":1042},{"$f":"$K39+H$36","v":1046},null,1575,1046,36.5,30,1,160,"PORTRAIT",null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","Split","NON"]
[null,{"$f":"\"OK\"&IF(C40=\"faux\",0,COUNTIF($C$39:C40,C40))","v":"OK0"},"FAUX",{"$f":"\"Po_\"&J40&\"_\"&K40","v":"Po_1575_1053"},{"$f":"$J40+E$36","v":1525},{"$f":"$J40+F$36","v":1675},{"$f":"$K40+G$36","v":1049},{"$f":"$K40+H$36","v":1053},null,1575,1053,36.5,30,1,160,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,{"$f":"\"OK\"&IF(C41=\"faux\",0,COUNTIF($C$39:C41,C41))","v":"OK0"},"FAUX","Po_1575_1082",1525,1675,1078,{"$f":"$K41+H$36","v":1082},null,1575,1082,36.5,30,1,160,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","Portrait"]
[null,{"$f":"\"OK\"&IF(C42=\"faux\",0,COUNTIF($C$39:C42,C42))","v":"OK0"},"FAUX","Po_1580_808",1530,1680,804,808,null,1580,808,36.5,30,1,160,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","Landscape"]
[null,{"$f":"\"OK\"&IF(C43=\"faux\",0,COUNTIF($C$39:C43,C43))","v":"OK0"},"FAUX","Po_1640_992",1590,1740,988,992,null,1640,992,36.5,30,1,160,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,{"$f":"\"OK\"&IF(C44=\"faux\",0,COUNTIF($C$39:C44,C44))","v":"OK0"},"FAUX","Po_1640_1001",1590,1740,997,1001,null,1640,1001,36.5,30,1,160,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,{"$f":"\"OK\"&IF(C45=\"faux\",0,COUNTIF($C$39:C45,C45))","v":"OK0"},{"$f":"IF($F$8=$AN$38,\"FAUX\",IF($F$7=$AM$39,\"FAUX\",IF(AND($C$7>=E45,$C$7<=F45,$C$8>=G45,$C$8<=H45,$C$9>=32),\"OK\",\"FAUX\")))","v":"FAUX"},{"$f":"\"Po_\"&J45&\"_\"&K45&\" P33\"","v":"Po_1640_1001 P33"},1590,1740,997,1001,null,1640,1001,36.5,30,1,160,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C46=\"faux\",0,COUNTIF($C$39:C46,C46))","v":"OK0"},{"$f":"IF($F$8=$AN$38,\"FAUX\",IF($F$7=$AM$39,\"FAUX\",IF(AND($C$7>=E46,$C$7<=F46,$C$8>=G46,$C$8<=H46,$C$9>=35),\"OK\",\"FAUX\")))","v":"FAUX"},"Po_1685_1016",1635,{"$f":"$J46+F$36-30","v":1755},1012,1016,null,1685,1016,36.5,30,1,160,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,{"$f":"\"OK\"&IF(C47=\"faux\",0,COUNTIF($C$39:C47,C47))","v":"OK0"},{"$f":"IF(AND($C$7>=E47,$C$7<=F47,$C$8>=G47,$C$8<=H47,$C$9>=30),\"OK\",\"FAUX\")","v":"FAUX"},"Po_1710_995",1660,{"$f":"$J47+F$36-30","v":1780},{"$f":"$K47+G$36","v":991},995,null,1710,995,36.5,30,1,130,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C48=\"faux\",0,COUNTIF($C$39:C48,C48))","v":"OK0"},{"$f":"IF(AND($C$7>=E48,$C$7<=F48,$C$8>=G48,$C$8<=H48,$C$9>=30),\"OK\",\"FAUX\")","v":"FAUX"},"Po_1710_1000",1660,{"$f":"$J48+F$36-30","v":1780},{"$f":"$K48+G$36","v":996},1000,null,1710,1000,36.5,30,1,130,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C49=\"faux\",0,COUNTIF($C$39:C49,C49))","v":"OK0"},"FAUX","Po_1710_1005",1660,1780,{"$f":"$K49+G$36","v":1001},1005,null,1710,1005,36.5,30,1,130,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C50=\"faux\",0,COUNTIF($C$39:C50,C50))","v":"OK0"},{"$f":"IF(AND($C$7>=E50,$C$7<=F50,$C$8>=G50,$C$8<=H50,$C$9>=30),\"OK\",\"FAUX\")","v":"FAUX"},"Po_1710_1010",1660,1780,1006,1010,null,1710,1010,36.5,30,1,130,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C51=\"faux\",0,COUNTIF($C$39:C51,C51))","v":"OK0"},"FAUX","Po_1710_1020",1660,1780,1016,1020,null,1710,1020,36.5,30,1,130,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C52=\"faux\",0,COUNTIF($C$39:C52,C52))","v":"OK0"},"FAUX","Po_1710_1025",1660,1780,1021,1025,null,1710,1025,36.5,30,1,130,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C53=\"faux\",0,COUNTIF($C$39:C53,C53))","v":"OK0"},"FAUX","Po_1710_1030",1660,1780,1026,1030,null,1710,1030,36.5,30,1,130,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C54=\"faux\",0,COUNTIF($C$39:C54,C54))","v":"OK0"},"FAUX","Po_1710_1040",1660,1780,1036,1040,null,1710,1040,36.5,30,1,130,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C55=\"faux\",0,COUNTIF($C$39:C55,C55))","v":"OK0"},"FAUX","Po_1710_1050",1660,1780,1046,1050,null,1710,1050,36.5,30,1,130,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C56=\"faux\",0,COUNTIF($C$39:C56,C56))","v":"OK0"},{"$f":"IF(AND($C$7>=E56,$C$7<=F56,$C$8>=G56,$C$8<=H56,$C$9>=30),\"OK\",\"FAUX\")","v":"FAUX"},"Po_1710_1055",1660,1780,1051,1055,null,1710,1055,36.5,30,1,130,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C57=\"faux\",0,COUNTIF($C$39:C57,C57))","v":"OK0"},null,"Po_1710_1060",1660,1780,1056,1060,null,1710,1060,36.5,30,1,130,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[]
[]
[null,null,null,null,-80,150,-4,0]
[null,{"$f":"\"OK\"&IF(C61=\"faux\",0,COUNTIF($C$39:C61,C61))","v":"OK0"},{"$f":"IF(AND($C$7>=E61,$C$7<=F61,$C$8>=G61,$C$8<=H61,$C$9>=30),\"OK\",\"FAUX\")","v":"FAUX"},{"$f":"\"Dpo_\"&J61&\"_\"&K61","v":"Dpo_1650_995"},{"$f":"$J61+E$60","v":1570},{"$f":"$J61+F$60","v":1800},{"$f":"$K61+G$60","v":991},{"$f":"$K61+H$60","v":995},null,1650,995,40,33,0.5,160,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C62=\"faux\",0,COUNTIF($C$39:C62,C62))","v":"OK0"},"FAUX",{"$f":"\"Dpo_\"&J62&\"_\"&K62","v":"Dpo_1650_1070"},{"$f":"$J62+E$60","v":1570},1800,{"$f":"$K62+G$60","v":1066},1070,null,1650,1070,40,33,0.5,160,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C63=\"faux\",0,COUNTIF($C$39:C63,C63))","v":"OK0"},"FAUX","Dpo_1650_1100",1570,1800,1096,1100,null,1650,1100,40,33,0.5,160,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C64=\"faux\",0,COUNTIF($C$39:C64,C64))","v":"OK0"},"FAUX","Dpo_1650_1135",1570,1800,1131,1135,null,1650,1135,40,33,0.5,160,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C65=\"faux\",0,COUNTIF($C$39:C65,C65))","v":"OK0"},"FAUX","Dpo_1650_1140",1570,1800,1136,1140,null,1650,1140,40,33,0.5,160,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C66=\"faux\",0,COUNTIF($C$39:C66,C66))","v":"OK0"},"FAUX","Dpo_1650_1160",1570,1800,1156,1160,null,1650,1160,40,33,0.5,160,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C67=\"faux\",0,COUNTIF($C$39:C67,C67))","v":"OK0"},"FAUX","Dpo_1840_995",1760,1990,991,995,null,1840,995,40,33,0.5,160,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C68=\"faux\",0,COUNTIF($C$39:C68,C68))","v":"OK0"},"FAUX","Dpo_1840_1020",1760,1990,1016,1020,null,1840,1020,40,33,0.5,160,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C69=\"faux\",0,COUNTIF($C$39:C69,C69))","v":"OK0"},"FAUX","Dpo_1840_1030",1760,1990,1026,1030,null,1840,1030,40,33,0.5,160,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C70=\"faux\",0,COUNTIF($C$39:C70,C70))","v":"OK0"},"FAUX","Dpo_1840_1070",1760,1990,1066,1070,null,1840,1070,40,33,0.5,160,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C71=\"faux\",0,COUNTIF($C$39:C71,C71))","v":"OK0"},"FAUX","Dpo_1840_1135",1760,1990,1131,1135,null,1840,1135,40,33,0.5,160,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[]
[null,{"$f":"\"OK\"&IF(C73=\"faux\",0,COUNTIF($C$73:C73,C73))","v":"OK0"},{"$f":"IF($F$8=$AN$38,\"FAUX\",IF($F$7=$AM$39,\"FAUX\",IF(AND($C$8>=E73,$C$8<=F73,$C$7>=G73,$C$7<=H73,$C$9>=35),\"OK\",\"FAUX\")))","v":"FAUX"},{"$f":"\"Pa_\"&K73&\"_\"&J73","v":"Pa_1559_1082"},1032,{"$f":"$J73+F$36","v":1182},{"$f":"$K73+G$36","v":1555},1559,null,1082,1559,36.5,30,1,160,"PAYSAGE",null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,{"$f":"\"OK\"&IF(C74=\"faux\",0,COUNTIF($C$73:C74,C74))","v":"OK0"},"FAUX",{"$f":"\"Pa_\"&K74&\"_\"&J74","v":"Pa_1575_1082"},1032,1182,1571,1575,null,1082,1575,36.5,30,1,160,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,{"$f":"\"OK\"&IF(C75=\"faux\",0,COUNTIF($C$73:C75,C75))","v":"OK0"},"FAUX","Pa_1580_808",758,908,1576,1580,null,808,1580,36.5,30,1,160,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,{"$f":"\"OK\"&IF(C76=\"faux\",0,COUNTIF($C$73:C76,C76))","v":"OK0"},"FAUX","Pa_1640_992",942,1092,1636,1640,null,992,1640,36.5,30,1,160,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,{"$f":"\"OK\"&IF(C77=\"faux\",0,COUNTIF($C$73:C77,C77))","v":"OK0"},"FAUX","Pa_1650_992",942,1092,1646,1650,null,992,1650,36.5,30,1,160,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,{"$f":"\"OK\"&IF(C78=\"faux\",0,COUNTIF($C$73:C78,C78))","v":"OK0"},"FAUX","Pa_1660_992",942,1092,1656,1660,null,992,1660,36.5,30,1,160,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,{"$f":"\"OK\"&IF(C79=\"faux\",0,COUNTIF($C$73:C79,C79))","v":"OK0"},"FAUX","Pa_1670_992",942,1092,1666,1670,null,992,1670,36.5,30,1,160,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,{"$f":"\"OK\"&IF(C80=\"faux\",0,COUNTIF($C$73:C80,C80))","v":"OK0"},{"$f":"IF($F$8=$AN$38,\"FAUX\",IF($F$7=$AM$39,\"FAUX\",IF(AND($C$8>=E80,$C$8<=F80,$C$7>=G80,$C$7<=H80,$C$9>=32),\"OK\",\"FAUX\")))","v":"FAUX"},{"$f":"\"Pa_\"&K80&\"_\"&J80&\" P33\"","v":"Pa_1675_992 P33"},942,1092,1671,1675,null,992,1675,36.5,30,1,160,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C81=\"faux\",0,COUNTIF($C$73:C81,C81))","v":"OK0"},{"$f":"IF($F$8=$AN$38,\"FAUX\",IF($F$7=$AM$39,\"FAUX\",IF(AND($C$8>=E81,$C$8<=F81,$C$7>=G81,$C$7<=H81,$C$9>=35),\"OK\",\"FAUX\")))","v":"FAUX"},"Pa_1680_992",942,1092,1676,1680,null,992,1680,36.5,30,1,160,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,{"$f":"\"OK\"&IF(C82=\"faux\",0,COUNTIF($C$73:C82,C82))","v":"OK0"},{"$f":"IF($F$8=$AN$38,\"FAUX\",IF($F$7=$AM$39,\"FAUX\",IF(AND($C$8>=E82,$C$8<=F82,$C$7>=G82,$C$7<=H82,$C$9>=35),\"OK\",\"FAUX\")))","v":"FAUX"},"Pa_1686_992",942,1092,1682,1686,null,992,1686,36.5,30,1,160,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,{"$f":"\"OK\"&IF(C83=\"faux\",0,COUNTIF($C$73:C83,C83))","v":"OK0"},{"$f":"IF($F$8=$AN$38,\"FAUX\",IF($F$7=$AM$39,\"FAUX\",IF(AND($C$8>=E83,$C$8<=F83,$C$7>=G83,$C$7<=H83,$C$9>=35),\"OK\",\"FAUX\")))","v":"FAUX"},"Pa_1700_992",942,1092,1696,1700,null,992,1700,36.5,30,1,160,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,{"$f":"\"OK\"&IF(C84=\"faux\",0,COUNTIF($C$73:C84,C84))","v":"OK0"},{"$f":"IF($F$8=$AN$38,\"FAUX\",IF(AND($C$8>=E84,$C$8<=F84,$C$7>=G84,$C$7<=H84,$C$9>=30),\"OK\",\"FAUX\"))","v":"FAUX"},"Pa_1665_1020",970,1120,1661,1665,null,1020,1665,36.5,30,1,160,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C85=\"faux\",0,COUNTIF($C$73:C85,C85))","v":"OK0"},"FAUX","Pa_1675_1020",970,1120,1671,1675,null,1020,1675,36.5,30,1,160,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C86=\"faux\",0,COUNTIF($C$73:C86,C86))","v":"OK0"},"FAUX","Pa_1680_1020",970,1120,1676,1680,null,1020,1680,36.5,30,1,160,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C87=\"faux\",0,COUNTIF($C$73:C87,C87))","v":"OK0"},"FAUX","Pa_1685_1020",970,1120,1681,1685,null,1020,1685,36.5,30,1,160,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C88=\"faux\",0,COUNTIF($C$73:C88,C88))","v":"OK0"},"FAUX","Pa_1690_1020",970,1120,1686,1690,null,1020,1690,36.5,30,1,160,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C89=\"faux\",0,COUNTIF($C$73:C89,C89))","v":"OK0"},"FAUX","Pa_1695_1020",970,1120,1691,1695,null,1020,1695,36.5,30,1,160,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C90=\"faux\",0,COUNTIF($C$73:C90,C90))","v":"OK0"},"FAUX","Pa_1700_1020",970,1120,1696,1700,null,1020,1700,36.5,30,1,160,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C91=\"faux\",0,COUNTIF($C$73:C91,C91))","v":"OK0"},"FAUX","Pa_1705_1020",970,1120,1701,1705,null,1020,1705,36.5,30,1,160,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C92=\"faux\",0,COUNTIF($C$73:C92,C92))","v":"OK0"},"FAUX","Pa_1720_1020",970,1120,1716,1720,null,1020,1720,36.5,30,1,160,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C93=\"faux\",0,COUNTIF($C$73:C93,C93))","v":"OK0"},"FAUX","Pa_1740_1020",970,1120,1736,1740,null,1020,1740,36.5,30,1,160,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[]
[]
[]
[null,null,null,null,-80,150,-4,0]
[null,{"$f":"\"OK\"&IF(C98=\"faux\",0,COUNTIF($C$39:C98,C98))","v":"OK0"},{"$f":"IF(AND($C$7>=E98,$C$7<=F98,$C$8>=G98,$C$8<=H98,$C$9>=30),\"OK\",\"FAUX\")","v":"FAUX"},{"$f":"\"DPa_\"&J98&\"_\"&K98","v":"DPa__"},{"$f":"$J98+E$97","v":-80},{"$f":"$J98+F$97","v":150},{"$f":"$K98+G$97","v":-4},{"$f":"$K98+H$97","v":0},null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C99=\"faux\",0,COUNTIF($C$39:C99,C99))","v":"OK0"},"FAUX",{"$f":"\"DPa_\"&J99&\"_\"&K99","v":"DPa__"},{"$f":"$J99+E$97","v":-80},150,{"$f":"$K99+G$97","v":-4},0,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C100=\"faux\",0,COUNTIF($C$39:C100,C100))","v":"OK0"},"FAUX","DPa__",-80,150,-4,0,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C101=\"faux\",0,COUNTIF($C$39:C101,C101))","v":"OK0"},"FAUX","DPa__",-80,150,-4,0,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C102=\"faux\",0,COUNTIF($C$39:C102,C102))","v":"OK0"},"FAUX","DPa__",-80,150,-4,0,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C103=\"faux\",0,COUNTIF($C$39:C103,C103))","v":"OK0"},"FAUX","DPa__",-80,150,-4,0,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C104=\"faux\",0,COUNTIF($C$39:C104,C104))","v":"OK0"},"FAUX","DPa__",-80,150,-4,0,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C105=\"faux\",0,COUNTIF($C$39:C105,C105))","v":"OK0"},"FAUX","DPa__",-80,150,-4,0,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C106=\"faux\",0,COUNTIF($C$39:C106,C106))","v":"OK0"},"FAUX","DPa__",-80,150,-4,0,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C107=\"faux\",0,COUNTIF($C$39:C107,C107))","v":"OK0"},"FAUX","DPa__",-80,150,-4,0,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C108=\"faux\",0,COUNTIF($C$39:C108,C108))","v":"OK0"},"FAUX","DPa__",-80,150,-4,0,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[]
[null,null,"Réf. Etriers","Epaisseur Min","Epaisseur Max"]
["Base étriers",{"$f":"IF(AND($C$9>=D111,$C$9<=E111),\"OK\",\"FAUX\")","v":"FAUX"},"H16",31,35]
[null,"FAUX","H19",37,38]
[null,"FAUX","H21",39,40]
[null,"FAUX","H23",41,42]
[null,"FAUX","H27",45,46]
[null,"FAUX","H31",49,50]
[]
[null,null,null,null,null,"Portrait","Paysage"]
[null,null,null,null,1,{"$f":"IFERROR(VLOOKUP(\"OK\"&$E119,rech_po,3,0),\"\")","v":""},{"$f":"IFERROR(IF($F$7=\"OUI\",VLOOKUP(\"OK\"&$E119,rech_pa_hc,3,0),VLOOKUP(\"OK\"&$E119,rech_pa,3,0)),\"\")","v":""}]
[null,null,null,null,2,{"$f":"IFERROR(VLOOKUP(\"OK\"&$E120,rech_po,3,0),\"\")","v":""},{"$f":"IFERROR(IF($F$7=\"OUI\",VLOOKUP(\"OK\"&$E120,rech_pa_hc,3,0),VLOOKUP(\"OK\"&$E120,rech_pa,3,0)),\"\")","v":""}]
[null,null,null,null,3,{"$f":"IFERROR(VLOOKUP(\"OK\"&$E121,rech_po,3,0),\"\")","v":""},{"$f":"IFERROR(IF($F$7=\"OUI\",VLOOKUP(\"OK\"&$E121,rech_pa_hc,3,0),VLOOKUP(\"OK\"&$E121,rech_pa,3,0)),\"\")","v":""}]
[null,null,null,null,4,{"$f":"IFERROR(VLOOKUP(\"OK\"&$E122,rech_po,3,0),\"\")","v":""},{"$f":"IFERROR(IF($F$7=\"OUI\",VLOOKUP(\"OK\"&$E122,rech_pa_hc,3,0),VLOOKUP(\"OK\"&$E122,rech_pa,3,0)),\"\")","v":""}]
[null,null,null,null,5,{"$f":"IFERROR(VLOOKUP(\"OK\"&$E123,rech_po,3,0),\"\")","v":""},{"$f":"IFERROR(IF($F$7=\"OUI\",VLOOKUP(\"OK\"&$E123,rech_pa_hc,3,0),VLOOKUP(\"OK\"&$E123,rech_pa,3,0)),\"\")","v":""}]

{"sheet":"Feuil2","index":1,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Portrait","feuil2!C1"]
["Paysage","feuil2!C2"]