{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["PV field Calculator","Feuil2"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":21,"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":93,"n_cols":37,"rows_kept":93,"cut":false,"hidden":false,"merged":[[36,4,36,7],[36,9,36,10],[36,13,36,33],[37,0,77,0],[38,11,56,11],[57,11,77,11],[80,0,85,0],[24,1,24,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[30,1,30,2],[31,1,31,2],[35,13,35,33]]}
[null,"Project Name :"]
[null,"Customer :"]
[null,"Date :"]
[]
["1. Module features"]
[]
[null,"Height :",1684.0,null,{"$f":"$AJ$37&\" :\"","v":"Junction Box :"},"Single"]
[null,"Width :",1002.0,null,{"$f":"$AK$37&\" :\"","v":"Rear support bar(s) :"},"NO"]
[null,"Thickness :",35.0]
["2.  Components data : Tray(s) & clamps references"]
[]
[null,null,{"$f":"AJ42","v":"Portrait"},{"$f":"AJ43","v":"Landscape"}]
[null,"GSE references","1710_1005","Tray(s) selection"]
[null,"Clamps",{"$f":"INDEX(rech_etrier,MATCH($C$13,Ref_plaques,0),MATCH($C$9,Epaisseur_module__mm,0))","v":"H21"},{"$f":"INDEX(rech_etrier,MATCH($D$13,Ref_plaques,0),MATCH($C$9,Epaisseur_module__mm,0))","v":"#N/A"}]
[null,"Ref. Height (mm)",{"$f":"VLOOKUP($C$13,base_po,7,0)","v":1710},{"$f":"VLOOKUP($D$13,base_pa,7,0)","v":"#N/A"}]
[null,"Ref. Width (mm)",{"$f":"VLOOKUP($C$13,base_po,8,0)","v":1005},{"$f":"VLOOKUP($D$13,base_pa,8,0)","v":"#N/A"}]
[null,"Graduation (mm)",{"$f":"IF((C7-C15)>0,MROUND(C7-C15,5),0)","v":0},{"$f":"IF((C8-D15)>0,MROUND(C8-D15,5),0)","v":"#N/A"}]
[null,"Rows spacing (mm)",{"$f":"10-(C7-MROUND(C15,5)-C17)","v":36},{"$f":"10-(C8-MROUND(D15,5)-D17)","v":"#N/A"}]
[]
["3. PV-Field data"]
[]
[null,"Configuration","Rows","Columns"]
[null,"Portrait",2.0,6.0]
[]
[null,"Field dimensions"]
[null,null,null,"Height (m)"]
[null,"GSE plates only (A+B)",null,{"$f":"((MROUND(HLOOKUP($B$23,données_plaques,4,0),5)+HLOOKUP($B$23,données_plaques,6,0)+10)*$C$23+(160-HLOOKUP($B$23,données_plaques,6,0)))/1000","v":3.6}]
[null,"Layout to the gutter (A+B+C+D)",null,{"$f":"D27+0.15+0.05","v":3.8}]
[null,"Layout in the center (A+B+C+D+E)",null,{"$f":"D28+0.1","v":3.9}]
[null,null,null,"Length (m)"]
[null,"GSE plates only (≈F)",null,{"$f":"((HLOOKUP($B$23,données_plaques,5,0)+36.5)*$D$23+30)/1000","v":6.279}]
[null,"w/ lateral flashings (F+2G)",null,{"$f":"((HLOOKUP($B$23,données_plaques,5,0)+36.5)*$D$23+165*2)/1000","v":6.579}]
[]
[]
[]
[null,null,null,null,-50.0,40.0,-5.0,0.0,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,"Epaisseur module (mm)",null,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)"]
["Base Plaque",null,null,"PLAQUE","HAUTEUR MINIMUM","HAUTEUR MAXIMUM","LARGEUR MINIMUM","LARGEUR MAXIMUM",null,"Hauteur ref","Larg ref",null,null,30.0,31.0,32.0,33.0,34.0,35.0,36.0,37.0,38.0,39.0,40.0,41.0,42.0,43.0,44.0,45.0,46.0,47.0,48.0,49.0,50.0,null,"Single","YES"]
[null,{"$f":"\"OK\"&IF(C39=\"faux\",0,COUNTIF($C$39:C39,C39))","v":"OK0"},{"$f":"IF($F$7=$AJ$39,\"FAUX\",IF(AND($C$7>=E39,$C$7<=F39,$C$8>=G39,$C$8<=H39,$C$9>=35),\"OK\",\"FAUX\"))","v":"FAUX"},"1559 / 1046",{"$f":"$J39+E$36","v":1525},1615,{"$f":"$K39+G$36","v":1041},1046,null,1575.0,1046.0,"PORTRAIT",null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31",null,"Split","NO"]
[null,"OK0","FAUX","1575 / 1053",{"$f":"$J40+E$36","v":1525},1615,{"$f":"$K40+G$36","v":1048},1053,null,1575.0,1053.0,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,"OK0","FAUX","1575 / 1082",{"$f":"$J41+E$36","v":1525},1615,{"$f":"$K41+G$36","v":1077},1082,null,1575.0,1082.0,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,"OK0","FAUX","1580 / 808",{"$f":"$J42+E$36","v":1530},1620,{"$f":"$K42+G$36","v":803},808,null,1580.0,808.0,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31",null,"Portrait"]
[null,"OK0","FAUX","1640 / 992",{"$f":"$J43+E$36","v":1590},1680,{"$f":"$K43+G$36","v":987},992,null,1640.0,992.0,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31",null,"Landscape"]
[null,"OK0","FAUX","1640 / 1001",{"$f":"$J44+E$36","v":1590},1680,{"$f":"$K44+G$36","v":996},1001,null,1640.0,1001.0,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,"OK0",{"$f":"IF($F$7=$AJ$39,\"FAUX\",IF(AND($C$7>=E45,$C$7<=F45,$C$8>=G45,$C$8<=H45,$C$9>=32),\"OK\",\"FAUX\"))","v":"FAUX"},"1640 / 1001 P33",{"$f":"$J45+E$36","v":1590},1680,{"$f":"$K45+G$36","v":996},1001,null,1640.0,1001.0,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,"OK0",{"$f":"IF($F$7=$AJ$39,\"FAUX\",IF(AND($C$7>=E46,$C$7<=F46,$C$8>=G46,$C$8<=H46,$C$9>=35),\"OK\",\"FAUX\"))","v":"FAUX"},"1686 / 1016",{"$f":"$J46+E$36","v":1635},1725,{"$f":"$K46+G$36","v":1011},1016,null,1685.0,1016.0,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,"OK0",{"$f":"IF(AND($C$7>=E47,$C$7<=F47,$C$8>=G47,$C$8<=H47,$C$9>=30),\"OK\",\"FAUX\")","v":"FAUX"},"1710_995",{"$f":"$J47+E$36","v":1660},1750,{"$f":"$K47+G$36","v":990},995,null,1710.0,995.0,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,"OK0","FAUX","1710_1000",{"$f":"$J48+E$36","v":1660},1750,{"$f":"$K48+G$36","v":995},1000,null,1710.0,1000.0,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,"OK1","OK","1710_1005",{"$f":"$J49+E$36","v":1660},1750,{"$f":"$K49+G$36","v":1000},1005,null,1710.0,1005.0,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,"OK0","FAUX","1710_1010",{"$f":"$J50+E$36","v":1660},1750,{"$f":"$K50+G$36","v":1005},1010,null,1710.0,1010.0,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,"OK0","FAUX","1710_1020",{"$f":"$J51+E$36","v":1660},1750,{"$f":"$K51+G$36","v":1015},1020,null,1710.0,1020.0,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,"OK0","FAUX","1710_1025",{"$f":"$J52+E$36","v":1660},1750,{"$f":"$K52+G$36","v":1020},1025,null,1710.0,1025.0,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,"OK0","FAUX","1710_1030",{"$f":"$J53+E$36","v":1660},1750,{"$f":"$K53+G$36","v":1025},1030,null,1710.0,1030.0,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,"OK0","FAUX","1710_1040",{"$f":"$J54+E$36","v":1660},1750,{"$f":"$K54+G$36","v":1035},1040,null,1710.0,1040.0,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,"OK0","FAUX","1710_1050",{"$f":"$J55+E$36","v":1660},1750,{"$f":"$K55+G$36","v":1045},1050,null,1710.0,1050.0,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,"OK0","FAUX","1710_1055",{"$f":"$J56+E$36","v":1660},1750,{"$f":"$K56+G$36","v":1050},1055,null,1710.0,1055.0,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,"OK0","FAUX","1710_1060",{"$f":"$J57+E$36","v":1660},1750,{"$f":"$K57+G$36","v":1055},1060,null,1710.0,1060.0,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,{"$f":"\"OK\"&IF(C58=\"faux\",0,COUNTIF($C$58:C58,C58))","v":"OK0"},{"$f":"IF($F$8=$AK$38,\"FAUX\",IF($F$7=$AJ$39,\"FAUX\",IF(AND($C$8>=E58,$C$8<=F58,$C$7>=G58,$C$7<=H58,$C$9>=35),\"OK\",\"FAUX\")))","v":"FAUX"},"1559 / 1046",{"$f":"$J58+E$36","v":1032},1122.0,{"$f":"$K58+G$36","v":1554},1559,null,1082.0,1559.0,"PAYSAGE",null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,"OK0","FAUX","1575 / 1082",1032,1122.0,{"$f":"$K59+G$36","v":1570},1575,null,1082.0,1575.0,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,"OK0","FAUX","1580 / 808",758,848.0,{"$f":"$K60+G$36","v":1575},1580,null,808.0,1580.0,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,"OK0","FAUX","1640 / 992",942,1032.0,{"$f":"$K61+G$36","v":1635},1640,null,992.0,1640.0,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,"OK0","FAUX","1650 / 992 ",942,1032.0,{"$f":"$K62+G$36","v":1645},1650,null,992.0,1650.0,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,"OK0","FAUX","1660 / 992",942,1032.0,{"$f":"$K63+G$36","v":1655},1660,null,992.0,1660.0,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,"OK0","FAUX","1670 / 992",942,1032.0,{"$f":"$K64+G$36","v":1665},1670,null,992.0,1670.0,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,"OK0",{"$f":"IF($F$8=$AK$38,\"FAUX\",IF($F$7=$AJ$39,\"FAUX\",IF(AND($C$8>=E65,$C$8<=F65,$C$7>=G65,$C$7<=H65,$C$9>=32),\"OK\",\"FAUX\")))","v":"FAUX"},"1675 / 992 P33",942,1032.0,{"$f":"$K65+G$36","v":1670},1675,null,992.0,1675.0,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,"OK0",{"$f":"IF($F$8=$AK$38,\"FAUX\",IF($F$7=$AJ$39,\"FAUX\",IF(AND($C$8>=E66,$C$8<=F66,$C$7>=G66,$C$7<=H66,$C$9>=35),\"OK\",\"FAUX\")))","v":"FAUX"},"1680 / 992",942,1032.0,{"$f":"$K66+G$36","v":1675},1680,null,992.0,1680.0,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,"OK1","OK","1686 / 1016",942,1032.0,{"$f":"$K67+G$36","v":1681},1686,null,992.0,1686.0,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,"OK0","FAUX","1700 / 1016",942,1032.0,{"$f":"$K68+G$36","v":1695},1700,null,992.0,1700.0,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,"OK0",{"$f":"IF($F$8=$AK$38,\"FAUX\",IF(AND($C$8>=E69,$C$8<=F69,$C$7>=G69,$C$7<=H69,$C$9>=30),\"OK\",\"FAUX\"))","v":"FAUX"},"1665_1020",970,1060.0,{"$f":"$K69+G$36","v":1660},1665,null,1020.0,1665.0,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,"OK0","FAUX","1675_1020",970,1060.0,{"$f":"$K70+G$36","v":1670},1675,null,1020.0,1675.0,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,"OK0","FAUX","1680_1020",970,1060.0,{"$f":"$K71+G$36","v":1675},1680,null,1020.0,1680.0,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,"OK2","OK","1685_1020",970,1060.0,{"$f":"$K72+G$36","v":1680},1685,null,1020.0,1685.0,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,"OK0","FAUX","1690_1020",970,1060.0,{"$f":"$K73+G$36","v":1685},1690,null,1020.0,1690.0,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,"OK0","FAUX","1695_1020",970,1060.0,{"$f":"$K74+G$36","v":1690},1695,null,1020.0,1695.0,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,"OK0","FAUX","1700_1020",970,1060.0,{"$f":"$K75+G$36","v":1695},1700,null,1020.0,1700.0,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,"OK0","FAUX","1705_1020",970,1060.0,{"$f":"$K76+G$36","v":1700},1705,null,1020.0,1705.0,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,"OK0","FAUX","1720_1020",970,1060.0,{"$f":"$K77+G$36","v":1715},1720,null,1020.0,1720.0,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,"OK0","FAUX","1740_1020",970,1060.0,{"$f":"$K78+G$36","v":1735},1740,null,1020.0,1740.0,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>=D81,$C$9<=E81),\"OK\",\"FAUX\")","v":"OK"},"H16",31.0,35.0]
[null,"FAUX","H19",37.0,38.0]
[null,"FAUX","H21",39.0,40.0]
[null,"FAUX","H23",41.0,42.0]
[null,"FAUX","H27",45.0,46.0]
[null,"FAUX","H31",49.0,50.0]
[]
[null,null,null,null,null,{"$f":"AJ42","v":"Portrait"},{"$f":"AJ43","v":"Landscape"}]
[null,null,null,null,1.0,{"$f":"IFERROR(IF($F$7=\"OUI\",VLOOKUP(\"OK\"&$E89,rech_po_hc,3,0),VLOOKUP(\"OK\"&$E89,rech_po,3,0)),\"\")","v":"1710_1005"},{"$f":"IFERROR(IF($F$7=\"OUI\",VLOOKUP(\"OK\"&$E89,rech_pa_hc,3,0),VLOOKUP(\"OK\"&$E89,rech_pa,3,0)),\"\")","v":"1686 / 1016"}]
[null,null,null,null,2.0,{"$f":"IFERROR(IF($F$7=\"OUI\",VLOOKUP(\"OK\"&$E90,rech_po_hc,3,0),VLOOKUP(\"OK\"&$E90,rech_po,3,0)),\"\")","v":""},{"$f":"IFERROR(IF($F$7=\"OUI\",VLOOKUP(\"OK\"&$E90,rech_pa_hc,3,0),VLOOKUP(\"OK\"&$E90,rech_pa,3,0)),\"\")","v":"1685_1020"}]
[null,null,null,null,3.0,{"$f":"IFERROR(IF($F$7=\"OUI\",VLOOKUP(\"OK\"&$E91,rech_po_hc,3,0),VLOOKUP(\"OK\"&$E91,rech_po,3,0)),\"\")","v":""},{"$f":"IFERROR(IF($F$7=\"OUI\",VLOOKUP(\"OK\"&$E91,rech_pa_hc,3,0),VLOOKUP(\"OK\"&$E91,rech_pa,3,0)),\"\")","v":""}]
[null,null,null,null,4.0,{"$f":"IFERROR(IF($F$7=\"OUI\",VLOOKUP(\"OK\"&$E92,rech_po_hc,3,0),VLOOKUP(\"OK\"&$E92,rech_po,3,0)),\"\")","v":""},{"$f":"IFERROR(IF($F$7=\"OUI\",VLOOKUP(\"OK\"&$E92,rech_pa_hc,3,0),VLOOKUP(\"OK\"&$E92,rech_pa,3,0)),\"\")","v":""}]
[null,null,null,null,5.0,{"$f":"IFERROR(IF($F$7=\"OUI\",VLOOKUP(\"OK\"&$E93,rech_po_hc,3,0),VLOOKUP(\"OK\"&$E93,rech_po,3,0)),\"\")","v":""},{"$f":"IFERROR(IF($F$7=\"OUI\",VLOOKUP(\"OK\"&$E93,rech_pa_hc,3,0),VLOOKUP(\"OK\"&$E93,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"]
["Landscape","feuil2!C2"]