{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Welcome","Designer","Segen instructions","Logistics","Données"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":4,"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":"Welcome","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Designer","index":1,"n_rows":49,"n_cols":15,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,7,48,8],[33,4,33,5],[32,4,32,5],[31,4,31,5],[30,4,30,5],[46,4,46,5],[45,4,45,5],[37,1,37,8],[44,1,44,8],[34,4,34,5],[43,4,43,5],[39,4,39,5],[41,4,41,5],[38,4,38,5],[40,4,40,5],[3,4,3,6],[35,4,35,5],[5,2,5,4],[36,1,36,8],[25,4,25,5],[24,4,24,5],[29,4,29,5],[21,5,21,7],[19,1,20,4],[5,5,5,7],[10,3,10,4],[10,5,10,6],[28,4,28,5],[27,4,27,5],[26,4,26,5],[8,14,8,15],[29,14,29,15],[30,11,30,12]]}
[]
[]
[]
[null,null,null,"Project reference :"]
[]
[null,null,"Sizing per kit",null,null,"Sizing per piece"]
[null,null,null,"2 panels",0,null,"Columns (C) :"]
[null,null,null,"4 panels",0,null,"Rows (L) :"]
[null,null,null,"6 panels",0,null,null,null,null,null,null,null,null,null,"Z Bar Option"]
[]
[null,null,"Fixation type :","Clamps (Rails On-Roof)",null,"Solar Panel :"]
[]
[null,null,null,"Finition étriers  :","NOIR"]
[null,null,null,"Back fixation support kit :",0,"Height :"]
[null,null,null,"Corrosion protection spray :",0,"Width :"]
[null,null,null,null,null,"Thickness :"]
[null,null,null,"Number of modules :",{"$f":"SUM(2*E7,4*E8,6*E9,H7*H8)","v":0}]
[null,null,null,"Total power :",{"$f":"$E$17*$G$18/1000","v":0},"Power :"]
[]
[null,"If you have selected the fixation type \"Clamps (Rails On-Roof)\", pick rail lengthes you would wish for the conception of your structure: ",null,null,null,"Choice of rail 1 to prioritize :","2,40 m"]
[null,null,null,null,null,"Choice of rail 2 (secundary) :","//"]
[null,null,null,null,null,"                             WARNING: Choose rail 1 to prioritize before choosing rail 2      "]
[]
[]
[null,"NUM.","GSEI Code","Segen Part number","DESIGNATION",null,"UNIT PRICE","QUANTITY","TOTAL PRICE"]
[null,1,"ART102866","GSE-GM-BOX-BASE",{"$f":"VLOOKUP(C26,Ref_art,2,FALSE)","v":"BOTTOM WALL OF BALLASTING BOX (THICKNESS 1mm) V2"},null,0,{"$f":"SUM(2*$E$7,2*$E$8,3*$E$9,IF($H$7=2,2*$H$8,($H$7*$H$8)/2))","v":0},{"$f":"G26*H26","v":0}]
[null,2,"ART102852","GSE-GM-FRNT-BCK-BASE","FRONT AND BACK WALL OF BALLASTING BOX (THICKNESS 1mm) V2",null,0,{"$f":"2*$H$26","v":0},{"$f":"G27*H27","v":0}]
[null,3,"ART102859","GSE-GM-LATERAL-LF-RT","RIGHT AND LEFT SIDE WALL OF BALLASTING BOX (THICKNESS 1mm) V2",null,0,{"$f":"2*$H$26","v":0},0]
[null,4,"ART100002","GSE-GM-FRONTAL-BRCKT","FRONT FIXING SQUARE BOTTOM PART (THICKNESS 3mm)",null,0,0,0]
[null,5,"ART100036","GSE-GM-REAR-BRCKT","BACK FIXING SQUARE TOP PART (THICKNESS 3mm)",null,0,0,0,null,null,null,null,null,"On-Roof Option"]
[null,6,"ART102873","GSE-GM-CORNER-PIECE-FIX","CORNER PIECE  L (THICKNESS 2mm) FIXED LENGTH 550mm v2",null,0,0,0,null,null,"Cdt rounded"]
[null,7,"ART102880","GSE-GM-CORNER-PIECE-ADJUST","CORNER PIECE L (THICKNESS 2mm) ADJUSTABLE LENGTH 1233mm v2",null,0,0,0,null,"Useful Screws","per kit","global"]
[null,8,"ART100125","GSE-GM-BOLT-CORNER-PIECE-FIX",{"$f":"VLOOKUP(C33,Ref_art,2,FALSE)&\" (Cdt 100p)\"","v":"M6 SCREW AND WASHER TIGHTNING  - FIX. CORNER (100pcs) (Cdt 100p)"},null,0,{"$f":"SUM($E$7*CEILING(2*36,100),$E$8*CEILING(2*36,100),$E$9*CEILING(3*36,100),CEILING(IF($H$7=2,2*$H$8,($H$7*$H$8)/2)*36,100))","v":0},0,null,{"$f":"H26*36","v":0},{"$f":"SUM($E$7*CEILING(2*36,100),$E$8*CEILING(2*36,100),$E$9*CEILING(3*36,100),CEILING(IF($H$7=2,2*$H$8,($H$7*$H$8)/2)*36,100))","v":0},{"$f":"CEILING($H$26*36,100)","v":0}]
[null,9,"ART101184","GSE-GM-NUT-CORNER-PIECE-T",{"$f":"VLOOKUP(C34,Ref_art,2,FALSE)&\" (Cdt 100p)\"","v":"M6 WASHER FOR M6 SCREW (100pcs) (Cdt 100p)"},null,0,{"$f":"H33","v":0},0,null,{"$f":"K33","v":0},{"$f":"L33","v":0},{"$f":"$M$33","v":0}]
[null,10,"ART100938","GSE-GM-BOLT-2PER-SQR",{"$f":"VLOOKUP(C35,Ref_art,2,FALSE)&\" (Cdt 20p)\"","v":"M10 PANS BOLT WITH AUTOBLOCKING BINDING WASHER FOR FIXING SQUARE & JUNCTION CORNER PIECE(20pcs) (Cdt 20p)"},null,0,{"$f":"SUM($E$7*CEILING(2*8,20),$E$8*CEILING(2*8+IF($D$11=Données!$E$5,2*4,0),20),$E$9*CEILING(3*8+IF($D$11=Données!$E$5,4*4,0),20),CEILING(IF($H$7=2,2*$H$8*8,($H$7*$H$8)/2*8+IF($D$11=Données!$E$5,($H$7-2)*$H$8*4,0)),20))","v":0},0,null,{"$f":"SUM(2*$H$29,2*$H$30,#REF!*4)","v":{"$error":"#REF!"}},{"$f":"SUM($E$7*CEILING(2*8,20),$E$8*CEILING(2*8+IF($D$11=Données!$E$5,2*4,0),20),$E$9*CEILING(3*8+IF($D$11=Données!$E$5,4*4,0),20),CEILING(IF($H$7=2,2*$H$8*8,($H$7*$H$8)/2*8+IF($D$11=Données!$E$5,($H$7-2)*$H$8*4,0)),20))","v":0},{"$f":"CEILING(SUM(2*$H$29,2*$H$30,#REF!*4),20)","v":{"$error":"#REF!"}}]
[null,11,"ART100213","GSE-GM-NUT-2PER-SQR-T",{"$f":"VLOOKUP(C36,Ref_art,2,FALSE)&\" (Cdt 20p)\"","v":"M10 PANS NUT WITH BINDING WASHER FOR M10 SCREW (20pcs) (Cdt 20p)"},null,0,{"$f":"H35","v":0},0,null,{"$f":"K35","v":{"$error":"#REF!"}},{"$f":"L35","v":0},{"$f":"$M$35","v":{"$error":"#REF!"}}]
[]
[null,"ON ROOF OPTION : RAILS + CLAMPS"]
[null,16,"ART104707","GSE-GM-RAIL-2.4",{"$f":"VLOOKUP(C39,Ref_art,2,FALSE)","v":"RAIL ON ROOF 40X60 - 2.40 M"},null,0,{"$f":"SUM(Données!K15:K18)","v":0},0]
[null,16,"ART100778","GSE-GM-RAIL-3.15","RAIL ON ROOF 40X60 - 3.15 M",null,0,{"$f":"SUM(Données!L15:L18)","v":0},0]
[null,16,"ART105078","GSE-GM-RAIL-3.58","RAIL ON ROOF 40x60 - 3.58 M",null,0,{"$f":"SUM(Données!M15:M18)","v":0},0]
[null,17,"ART100511","GSE-GM-RAIL-CONN","RAIL CONNECTOR ON ROOF + 4 x SCREW",null,0,{"$f":"SUM(Données!N15:N18)","v":0},0]
[null,18,{"$f":"IF(E13=\"ALU\",VLOOKUP(G16,choix_etriers,3,0),VLOOKUP(G16,choix_etriers,5,0))","v":{"$error":"#N/A"}},"GSE-GM-D-CLAMP-B",{"$error":"#N/A"},null,0,{"$f":"IF($D$11=Données!$E$4,IF(SUM($E$7*2,$E$8*6,$E$9*10,($H$7+$H$7-2)*$H$8)>-2,SUM($E$7*2,$E$8*6,$E$9*10,($H$7+$H$7-2)*$H$8),0),0)","v":0},0]
[null,19,{"$f":"IF(E13=\"ALU\",VLOOKUP(G16,choix_etriers,8,0),VLOOKUP(G16,choix_etriers,10,0))","v":{"$error":"#N/A"}},"GSE-GM-S-CLAMP-B\n-(30, 32, 35 or 40)",{"$error":"#N/A"},null,0,{"$f":"IF($E$17=0,0,IF($D$11=Données!$E$4,SUM(4*$E$7,4*$E$8,4*$E$9,4*$H$8),0))","v":0},0]
[null,"ACCESSORIES"]
[null,20,"ART101525","GSE-GM-BCK-FIX-SUP-KIT-GRND",{"$f":"VLOOKUP(C46,Ref_art,2,FALSE)","v":"BACK FIXING SUPPORT KIT - GROUND SYSTEM"},null,0,{"$f":"$E$14","v":0},0]
[null,21,"ART101025","GSE-GM-TOUCH-UP-SPRAY",{"$f":"VLOOKUP(C47,Ref_art,2,FALSE)","v":"ANTI-CORROSIVE PROTECTION SPRAY 400mL"},null,0,{"$f":"$E$15","v":0},0]
[]
[null,null,null,null,null,null,"Total Price :",{"$f":"SUM(I26:I47)","v":0}]

{"sheet":"Segen instructions","index":2,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Instructions for using design tool"]
[]
[null,1,"After opening this configuration tool, please navigate to the 'Designer' tab and enter a project name/reference in cell F4 and then save this file to your computer using the project name."]
[]
[null,2,"Specify the layout using the tools available at the top of the sheet. You can either utilise the pre-set designs on the left hand side of the table, or you can specify the exact number of columns and rows using the table on the right hand side."]
[]
[null,3,"Leave fixation type set as 'Clamps (Rails On-Roof)' and then specify any panel specific details relevant to your project such as length, width, depth and rating."]
[]
[null,4,"When the details of the modules have been entered and the layout has been specified, the bill of materials below should update to reflect the actual bill of material required "]
[null,null,"Please note; cell D48 on the designer tab covers 3 part codes; GSE-GM-S-CLAMP-B-30, GSE-GM-S-CLAMP-B-32, GSE-GM-S-CLAMP-B-35, GSE-GM-S-CLAMP-B-40 - ensure you use the appropriate suffix relative to the depth of the module you have chosen."]
[]
[null,5,"Create a quote on the Segen system using the Segen part codes and the quantity recommended by the configurator. Alternatively you can use the part GSE-GM-TEMPLATE, modify the quantities and remove what is not needed."]

{"sheet":"Logistics","index":3,"n_rows":51,"n_cols":5,"rows_kept":51,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"GROUND SYSTEM"]
[null,"REFERENCE SAGE","REFERENCE NAV","DESIGNATION GSE","Segen DESIGNATION"]
[null,"KIT_AUTOC2","ART101545","KIT GROUND SYSTEM - 2 PANELS","NA"]
[null,"KIT_AUTOC","ART100496","KIT GROUND SYSTEM - 4 PANELS","NA"]
[null,"KIT_AUTOC1","ART101363","KIT GROUND SYSTEM - 6 PANELS","NA"]
[null,"OPTION_SUP_ARRIERE","ART101525","BACK FIXING SUPPORT KIT - GROUND SYSTEM","GSE-GM-BCK-FIX-SUP-KIT-GRND"]
[1,"PROFIL_CAISSON_FRO","ART100499","FRONT AND BACK WALL OF BALLASTING BOX (THICKNESS 1mm)","NA"]
[2,"PROFILE_LATERAL_CA","ART100087","RIGHT AND LEFT SIDE WALL OF BALLASTING BOX (THICKNESS 1mm)","NA"]
[3,"PROFIL_FOND_CAISSO","ART100439","BOTTOM WALL OF BALLASTING BOX (THICKNESS 1mm)","NA"]
[4,"EQUERRE_FRONTALE","ART100002","FRONT FIXING SQUARE BOTTOM PART (THICKNESS 3mm)","GSE-GM-FRONTAL-BRCKT"]
[5,"EQUERRE_ ARRIERE","ART100036","BACK FIXING SQUARE TOP PART (THICKNESS 3mm)","GSE-GM-REAR-BRCKT"]
[6,"CORNIERE_L_FIXE","ART100631","CORNER PIECE  L (THICKNESS 2mm) FIXED LENGTH 550mm","NA"]
[7,"CORNIERE _L_AJUSTAB","ART100848","CORNER PIECE L (THICKNESS 2mm) ADJUSTABLE LENGTH 1233mm","NA"]
[8,"PROFILE_Z_","ART104406","Z BAR SUPPORT FOR PV PANEL (THICKNESS 3mm x L 2320mm) ","NA"]
[9,"CORNIERES_RACCOR","ART101132","JUNCTION CORNER PIECE FOR Z BAR","NA"]
[10,"BOULONS_SERR_AUTOB","ART100938","M10 PANS BOLT WITH AUTOBLOCKING BINDING WASHER FOR FIXING SQUARE & JUNCTION CORNER PIECE(20pcs)","GSE-GM-BOLT-2PER-SQR"]
[11,"ECROUS_ROND_SERRAG","ART100213","M10 PANS NUT WITH BINDING WASHER FOR M10 SCREW (20pcs)","GSE-GM-NUT-2PER-SQR-T"]
[12,"VIS_FIXA_MODULE","ART100426","M8 ROUNDED-HEAD SCREW - MODULE FIXING / \"Z\" PAN (20pcs)"]
[13,"ECROUSROND_SERRAGE","ART100743","M8 PANS NUT WITH BINDING WASHER OFR M8 SCREW (20pcs)"]
[14,"BOULONS_FIX_CORNI","ART100125","M6 SCREW AND WASHER TIGHTNING  - FIX. CORNER (100pcs)","GSE-GM-BOLT-CORNER-PIECE-FIX"]
[15,"ECROUS_SERRAGE_AUT","ART101184","M6 WASHER FOR M6 SCREW (100pcs)","GSE-GM-NUT-CORNER-PIECE-T"]
[16,"GALVA_SPRAY_CLAIR","ART101025","ANTI-CORROSIVE PROTECTION SPRAY 400mL","GSE-GM-TOUCH-UP-SPRAY"]
[null,"SST01-CT02 V2","ART102852","FRONT AND BACK WALL OF BALLASTING BOX (THICKNESS 1mm) V2","GSE-GM-FRNT-BCK-BASE"]
[null,"SST01-CL03 V2","ART102859","RIGHT AND LEFT SIDE WALL OF BALLASTING BOX (THICKNESS 1mm) V2","GSE-GM-LATERAL-LF-RT"]
[null,"SST01-CB01 V2","ART102866","BOTTOM WALL OF BALLASTING BOX (THICKNESS 1mm) V2","GSE-GM-BOX-BASE"]
[null,"SST01-AF01 V2","ART102873","CORNER PIECE  L (THICKNESS 2mm) FIXED LENGTH 550mm v2","GSE-GM-CORNER-PIECE-FIX"]
[null,"SST01-AP02 V2","ART102880","CORNER PIECE L (THICKNESS 2mm) ADJUSTABLE LENGTH 1233mm v2","GSE-GM-CORNER-PIECE-ADJUST"]
[]
[null,null,"ON ROOF OPTION: RAILS + CLAMPS"]
[17,"RAIL_OR_2.10_40X60","ART104707","RAIL ON ROOF 40X60 - 2.40 M","GSE-GM-RAIL-2.4"]
[18,"RAIL_OR_3.15_40X60","ART100778","RAIL ON ROOF 40X60 - 3.15 M","GSE-GM-RAIL-3.15"]
[19,"RAIL_OR_3.58_40X60","ART105078","RAIL ON ROOF 40x60 - 3.58 M","GSE-GM-RAIL-3.58"]
[20,"CONN_RAIL_VIS","ART100511","RAIL CONNECTOR ON ROOF + 4 x SCREW","GSE-GM-RAIL-CONN"]
[21,"ED_ALU_30/40MM","ART101145","DOUBLE CLAMP ALU 30/40MM - ON ROOF"]
[22,"ED_ALU_40/46MM","ART101573","DOUBLE CLAMP ALU 40/46MM - ON ROOF"]
[23,"ED_NOIR_30/40MM","ART101240","DOUBLE CLAMP BLACK 30/40MM - ON ROOF","GSE-GM-D-CLAMP-B"]
[24,"ED_NOIR_40/46MM","ART101495","DOUBLE CLAMP BLACK 40/46MM - ON ROOF"]
[25,"ES_ALU_32MM","ART101574","SIMPLE CLAMP ALU 32MM - ON ROOF"]
[26,"ES_ALU_35MM","ART101076","SIMPLE CLAMP ALU 35MM - ON ROOF"]
[27,"ES_ALU_38MM","ART101575","SIMPLE CLAMP ALU 38MM - ON ROOF"]
[28,"ES_ALU_40MM","ART100261","SIMPLE CLAMP ALU 40MM - ON ROOF"]
[29,"ES_ALU_42MM","ART101576","SIMPLE CLAMP ALU 42MM - ON ROOF"]
[30,"ES_ALU_46MM","ART101577","SIMPLE CLAMP ALU 46MM - ON ROOF"]
[31,"ES_NOIR_30MM","ART104665","SIMPLE CLAMP BLACK 30MM - ON ROOF","GSE-GM-S-CLAMP-B-30"]
[32,"ES_NOIR_32MM","ART100411","SIMPLE CLAMP BLACK 32MM - ON ROOF"]
[33,"ES_NOIR_ 35MM","ART100064","SIMPLE CLAMP BLACK 35MM - ON ROOF","GSE-GM-S-CLAMP-B-35"]
[34,"ES_NOIR_38MM","ART101578","SIMPLE CLAMP BLACK 38MM - ON ROOF"]
[35,"ES_NOIR_40MM","ART100007","SIMPLE CLAMP BLACK 40MM - ON ROOF","GSE-GM-S-CLAMP-B-40"]
[36,"ES_NOIR_42MM","ART101579","SIMPLE CLAMP BLACK 42MM - ON ROOF"]
[37,"ES_NOIR_46MM","ART101580","SIMPLE CLAMP BLACK 46MM - ON ROOF"]

{"sheet":"Données","index":4,"n_rows":204,"n_cols":17,"rows_kept":204,"cut":false,"hidden":true,"merged":[[21,8,21,9],[19,14,19,15],[1,8,1,9],[1,15,1,16],[1,13,1,14],[1,10,1,11]]}
[]
[null,null,null,null,null,null,null,null,"DOUBLE CLAMP ALU",null,"DOUBLE CLAMP BLACK",null,null,"SIMPLE CLAMP ALU",null,"SIMPLE CLAMP BLACK"]
[null,"Number","Number 2 by 2","Clamps","Choice","Protection Box","Color",null,"Ref SAGE","Ref NAVISION","Ref SAGE","Ref NAVISION",null,"Ref SAGE","Ref NAVISION","Ref SAGE","Ref NAVISION"]
[null,0,0,32,"Clamps (Rails On-Roof)","OUI","ALU",30,"ED_ALU_30/40MM","ART101145","ED_NOIR_30/40MM","ART101240",null,null,null,null,"ART104665"]
[null,1,2,35,"Frame bolting (Z Bar)","NON","NOIR",32,"ED_ALU_30/40MM","ART101145","ED_NOIR_30/40MM","ART101240",null,"ES_ALU_32MM","ART101574","ES_NOIR_32MM","ART100411"]
[null,2,{"$f":"C5+2","v":4},38,null,null,null,35,"ED_ALU_30/40MM","ART101145","ED_NOIR_30/40MM","ART101240",null,"ES_ALU_35MM","ART101076","ES_NOIR_35MM","ART100064"]
[null,3,{"$f":"C6+2","v":6},40,null,null,null,38,"ED_ALU_30/40MM","ART101145","ED_NOIR_30/40MM","ART101240",null,"ES_ALU_38MM","ART101575","ES_NOIR_38MM","ART101578"]
[null,4,8,42,null,null,null,40,"ED_ALU_30/40MM","ART101145","ED_NOIR_30/40MM","ART101240",null,"ES_ALU_40MM","ART100261","ES_NOIR_40MM","ART100007"]
[null,5,10,46,null,null,null,42,"ED_ALU_40/46MM","ART101573","ED_NOIR_40/46MM","ART101495",null,"ES_ALU_42MM","ART101576","ES_NOIR_42MM","ART101579"]
[null,6,12,null,null,null,null,46,"ED_ALU_40/46MM","ART101573","ED_NOIR_40/46MM","ART101495",null,"ES_ALU_46MM","ART101577","ES_NOIR_46MM","ART101580"]
[null,7,14]
[null,8,16,null,null,null,null,null," RAILS' LENGTH"]
[null,9,18]
[null,10,20,null,null,null,null,null,"RAIL ON ROOF",null,"Nber of 2m40 rail","Nber of 3m15 rail","Nber of 3m58 rail","Rail connector","Z BAR",null,"Number of 2m32 rail"]
[null,11,22,null,null,null,null,null,"Rail length needed for sizing per piece*",{"$f":"IF(Designer!D11<>E4,0,Designer!H7*Designer!G15+22*(Designer!H7-1)+76)","v":54},{"$f":"IF(Designer!$D$11<>E4,0,IF(AND(J19=2400,J20=0),(INT(J15/J19)+1)*2*Designer!H8,IF(AND(J19=2400,J20<>0,MOD(J15,J19)<=J21,J15>54),(INT(J15/J19)-1)*2*Designer!H8,IF(AND(J19=2400,J20<>0,MOD(J15,J19)>J21),(INT(J15/J19)+1)*2*Designer!H8,IF(AND(J19<>2400,J20=2400,MOD(J15,J19)<=2400,J15>54),2*Designer!H8,0)))))","v":0},{"$f":"IF(Designer!$D$11<>E4,0,IF(AND(J19=3150,J20=0),(INT(J15/J19)+1)*2*Designer!H8,IF(AND(J19=3150,J20=3580,MOD(J15,J19)<=J21,J15>54),(INT(J15/J19)-1)*2*Designer!H8,IF(AND(J19=3150,J20=3580,MOD(J15,J19)>J21),(INT(J15/J19)+1)*2*Designer!H8, IF(AND(J19=3150,J20=2400,MOD(J15,J19)<=2400,J15>54),INT(J15/J19)*2*Designer!H8,IF(AND(J19=3150,J20=2400,MOD(J15,J19)>2400),(INT(J15/J19)+1)*2*Designer!H8,IF(AND(J19=2400,J20=3150,MOD(J15,J19)<=J21,J15>54),2*Designer!H8,IF(AND(J19=3580,J20=3150,MOD(J15,J19)<=3150,J15>54),2*Designer!H8,0))))))))","v":0},{"$f":"IF(Designer!$D$11<>E4,0,IF(AND(J19=3580,J20=0),(INT(J15/J19)+1)*2*Designer!H8,IF(AND(J19=3580,J20<>0,MOD(J15,J19)<=J20,J15>54),INT(J15/J19)*2*Designer!H8,IF(AND(J19=3580,J20<>0,MOD(J15,J19)>J20), (INT(J15/J19)+1)*2*Designer!H8, IF(AND(J19<>3580,J20=3580,MOD(J15,J19)<=J21,J15>54),2*Designer!H8,0)))))","v":0},{"$f":"IF(SUM(K15,M15)<>0,SUM(K15:M15)-2,0)","v":0},"Rail length needed for pour configuration personnalisée",{"$f":"IF(Designer!D11<>E5,0,IF(Designer!H7=0,0,Designer!H7*Designer!G15+10*(Designer!H7-1)))","v":0},{"$f":"IF(Designer!$D$11<>E5,0, IF(P15<>0, (INT(P15/P19)+1)*2*Designer!H8,0))","v":0}]
[null,12,24,null,null,null,null,null,"Rail length needed for 2 panels kit*",{"$f":"IF(Designer!D11<>E4,0,IF(Designer!E7=0,54,2*Designer!G15+22*(2-1)+76))","v":54},{"$f":"IF(Designer!$D$11<>E4,0,IF(AND(J19=2400,J20=0),(INT(J16/J19)+1)*2*Designer!E7,IF(AND(J19=2400,J20<>0,MOD(J16,J19)<=J21,J16>54),(INT(J16/J19)-1)*2*Designer!E7,IF(AND(J19=2400,J20<>0,MOD(J16,J19)>J21),(INT(J16/J19)+1)*2*Designer!E7,IF(AND(J19<>2400,J20=2400,MOD(J16,J19)<=2400,J16>54),2*Designer!E7,0)))))","v":0},{"$f":"IF(Designer!$D$11<>E4,0,IF(AND(J19=3150,J20=0),(INT(J15/J19)+1)*2*Designer!E7,IF(AND(J19=3150,J20=3580,MOD(J15,J19)<=J21,J15>54),(INT(J15/J19)-1)*2*Designer!E7,IF(AND(J19=3150,J20=3580,MOD(J15,J19)>J21),(INT(J15/J19)+1)*2*Designer!E7, IF(AND(J19=3150,J20=2400,MOD(J15,J19)<=2400,J15>54),INT(J15/J19)*2*Designer!E7,IF(AND(J19=3150,J20=2400,MOD(J15,J19)>2400),(INT(J15/J19)+1)*2*Designer!E7,IF(AND(J19=2400,J20=3150,MOD(J15,J19)<=J21,J15>54),2*Designer!E7,IF(AND(J19=3580,J20=3150,MOD(J15,J19)<=3150,J15>54),2*Designer!E7,0))))))))","v":0},{"$f":"IF(Designer!$D$11<>E4,0,IF(AND(J19=3580,J20=0),(INT(J16/J19)+1)*2*Designer!E7,IF(AND(J19=3580,J20<>0,MOD(J16,J19)<=3150,J16>54),INT(J16/J19)*2*Designer!E7,IF(AND(J19=3580,J20<>0,MOD(J16,J19)>3150), (INT(J16/J19)+1)*2*Designer!E7, IF(AND(J19<>3580,J20=3580,MOD(J16,J19)<=J21,J16>54),2*Designer!E7,0)))))","v":0},{"$f":"IF(SUM(K16,M16)<>0,SUM(K16:M16)-2,0)","v":0},"Rail length needed for 2 panels kit*",{"$f":"IF(Designer!D11<>E5,0,IF(Designer!E7=0,0,2*Designer!G15+10*(2-1)))","v":0},{"$f":"IF(Designer!$D$11<>E5,0, IF(P16<>0, (INT(P16/P19)+1)*2*Designer!E7,0))","v":0}]
[null,13,{"$f":"C16+2","v":26},null,null,null,null,null,"Rail length needed for 4 panels kit*",{"$f":"IF(Designer!D11<>E4,0,IF(Designer!E8=0,54,4*Designer!G15+22*(4-1)+76))","v":54},{"$f":"IF(Designer!$D$11<>E4,0,IF(AND(J19=2400,J20=0),(INT(J17/J19)+1)*2*Designer!E8,IF(AND(J19=2400,J20<>0,MOD(J17,J19)<=J21,J17>54),(INT(J17/J19)-1)*2*Designer!E8,IF(AND(J19=2400,J20<>0,MOD(J17,J19)>J21),(INT(J17/J19)+1)*2*Designer!E8,IF(AND(J19<>2400,J20=2400,MOD(J17,J19)<=2400,J17>54),2*Designer!E8,0)))))","v":0},{"$f":"IF(Designer!$D$11<>E4,0,IF(AND(J19=3150,J20=0),(INT(J17/J19)+1)*2*Designer!E8,IF(AND(J19=3150,J20=3580,MOD(J17,J19)<=J21,J17>54),(INT(J17/J19)-1)*2*Designer!E8,IF(AND(J19=3150,J20=3580,MOD(J17,J19)>J21),(INT(J17/J19)+1)*2*Designer!E8, IF(AND(J19=3150,J20=2400,MOD(J17,J19)<=2400,J17>54),INT(J17/J19)*2*Designer!E8,IF(AND(J19=3150,J20=2400,MOD(J17,J19)>2400),(INT(J17/J19)+1)*2*Designer!E8,IF(AND(J19=2400,J20=3150,MOD(J17,J19)<=J21,J17>54),2*Designer!E8,IF(AND(J19=3580,J20=3150,MOD(J17,J19)<=3150,J17>54),2*Designer!E8,0))))))))","v":0},{"$f":"IF(Designer!$D$11<>E4,0,IF(AND(J19=3580,J20=0),(INT(J17/J19)+1)*2*Designer!E8,IF(AND(J19=3580,J20<>0,MOD(J17,J19)<=3150,J17>54),INT(J17/J19)*2*Designer!E8,IF(AND(J19=3580,J20<>0,MOD(J17,J19)>3150), (INT(J17/J19)+1)*2*Designer!E8, IF(AND(J19<>3580,J20=3580,MOD(J17,J19)<=J21,J17>54),2*Designer!E8,0)))))","v":0},{"$f":"IF(SUM(K17,M17)<>0,SUM(K17:M17)-2,0)","v":0},"Rail length needed for 4 panels kit*",{"$f":"IF(Designer!D11<>E5,0,IF(Designer!E8=0,0,4*Designer!G15+10*(4-1)))","v":0},{"$f":"IF(Designer!$D$11<>E5,0, IF(P17<>0, (INT(P17/P19)+1)*2*Designer!E8,0))","v":0}]
[null,14,{"$f":"C17+2","v":28},null,null,null,null,null,"Rail length needed for 6 panels kit*",{"$f":"IF(Designer!D11<>E4,0,IF(Designer!E9=0,54,6*Designer!G15+22*(6-1)+76))","v":54},{"$f":"IF(Designer!$D$11<>E4,0,IF(AND(J19=2400,J20=0),(INT(J18/J19)+1)*2*Designer!E9,IF(AND(J19=2400,J20<>0,MOD(J18,J19)<=J21,J18>54),(INT(J18/J19)-1)*2*Designer!E9,IF(AND(J19=2400,J20<>0,MOD(J18,J19)>J21),(INT(J18/J19)+1)*2*Designer!E9,IF(AND(J19<>2400,J20=2400,MOD(J18,J19)<=2400,J18>54),2*Designer!E9,0)))))","v":0},{"$f":"IF(Designer!$D$11<>E4,0,IF(AND(J19=3150,J20=0),(INT(J18/J19)+1)*2*Designer!E9,IF(AND(J19=3150,J20=3580,MOD(J18,J19)<=J21,J18>54),(INT(J18/J19)-1)*2*Designer!E9,IF(AND(J18=3150,J20=3580,MOD(J18,J19)>J21),(INT(J18/J19)+1)*2*Designer!E9, IF(AND(J19=3150,J20=2400,MOD(J18,J19)<=2400,J18>54),INT(J18/J19)*2*Designer!E9,IF(AND(J19=3150,J20=2400,MOD(J18,J19)>2400),(INT(J18/J19)+1)*2*Designer!E9,IF(AND(J19=2400,J20=3150,MOD(J18,J19)<=J21,J18>54),2*Designer!E9,IF(AND(J19=3580,J20=3150,MOD(J18,J19)<=3150,J18>54),2*Designer!E9,0))))))))","v":0},{"$f":"IF(Designer!$D$11<>E4,0,IF(AND(J19=3580,J20=0),(INT(J18/J19)+1)*2*Designer!E9,IF(AND(J19=3580,J20<>0,MOD(J18,J19)<=3150,J18>54),INT(J18/J19)*2*Designer!E9,IF(AND(J19=3580,J20<>0,MOD(J18,J19)>3150), (INT(J18/J19)+1)*2*Designer!E9, IF(AND(J19<>3580,J20=3580,MOD(J18,J19)<=J21,J18>54),2*Designer!E9,0)))))","v":0},{"$f":"IF(SUM(K18,M18)<>0,SUM(K18:M18)-2,0)","v":0},"Rail length needed for 6 panels kit*",{"$f":"IF(Designer!D11<>E5,0,IF(Designer!E9=0,0,6*Designer!G15+10*(6-1)))","v":0},{"$f":"IF(Designer!$D$11<>E5,0, IF(P18<>0, (INT(P18/P19)+1)*2*Designer!E9,0))","v":0}]
[null,15,30,null,null,null,null,null,"Rail to prioritize",{"$f":"IF(Designer!D11=E5,0,IF(Designer!G20=\"2,10 m\",2100,IF(Designer!G20=\"2,40 m\",2400,IF(Designer!G20=\"3,15 m\",3150))))","v":2400},null,null,null,null,"Z Bar",2320]
[null,16,32,null,null,null,null,null,"Rail (secondary) available",{"$f":"IF(Designer!D11=E5,0,IF(Designer!G21=\"2,10 m\",2100,IF(Designer!G21=\"2,40 m\",2400,IF(Designer!G21=\"3,15 m\",3150,0))))","v":0}]
[null,17,34,null,null,null,null,null,"Rails' difference: limit of the remainder",{"$f":"IF(J19<J20, J20-J19,J19-J20)","v":2400}]
[null,18,36,null,null,null,null,null,"*If L=54, then the rail length needed must be considered null. "]
[null,19,38]
[null,20,40]
[null,21,42,null,null,null,null,null,"Rails - Choice 1","Rails - Choice 2"]
[null,22,44,null,null,null,null,null,"2,40 m",{"$f":"IF(Designer!G20=\"2,40 m\", \"//\",\"2,40 m\")","v":"//"}]
[null,23,46,null,null,null,null,null,"3,15 m",{"$f":"IF(Designer!G20=\"3,15 m\", \"//\",\"3,15 m\")","v":"3,15 m"}]
[null,24,48,null,null,null,null,null,"3,58 m",{"$f":"IF(Designer!G20=\"3,58 m\", \"//\",\"3,58 m\")","v":"3,58 m"}]
[null,25,50]
[null,26,52]
[null,27,54]
[null,28,56]
[null,29,58]
[null,30,60]
[null,31,62]
[null,32,64]
[null,33,66]
[null,34,68]
[null,35,70]
[null,36,72]
[null,37,74]
[null,38,76]
[null,39,78]
[null,40,80]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]
[null,51]
[null,52]
[null,53]
[null,54]
[null,55]
[null,56]
[null,57]
[null,58]
[null,59]
[null,60]
[null,61]
[null,62]
[null,63]
[null,64]
[null,65]
[null,66]
[null,67]
[null,68]
[null,69]
[null,70]
[null,71]
[null,72]
[null,73]
[null,74]
[null,75]
[null,76]
[null,77]
[null,78]
[null,79]
[null,80]
[null,81]
[null,82]
[null,83]
[null,84]
[null,85]
[null,86]
[null,87]
[null,88]
[null,89]
[null,90]
[null,91]
[null,92]
[null,93]
[null,94]
[null,95]
[null,96]
[null,97]
[null,98]
[null,99]
[null,100]
[null,101]
[null,102]
[null,103]
[null,104]
[null,105]
[null,106]
[null,107]
[null,108]
[null,109]
[null,110]
[null,111]
[null,112]
[null,113]
[null,114]
[null,115]
[null,116]
[null,117]
[null,118]
[null,119]
[null,120]
[null,121]
[null,122]
[null,123]
[null,124]
[null,125]
[null,126]
[null,127]
[null,128]
[null,129]
[null,130]
[null,131]
[null,132]
[null,133]
[null,134]
[null,135]
[null,136]
[null,137]
[null,138]
[null,139]
[null,140]
[null,141]
[null,142]
[null,143]
[null,144]
[null,145]
[null,146]
[null,147]
[null,148]
[null,149]
[null,150]
[null,151]
[null,152]
[null,153]
[null,154]
[null,155]
[null,156]
[null,157]
[null,158]
[null,159]
[null,160]
[null,161]
[null,162]
[null,163]
[null,164]
[null,165]
[null,166]
[null,167]
[null,168]
[null,169]
[null,170]
[null,171]
[null,172]
[null,173]
[null,174]
[null,175]
[null,176]
[null,177]
[null,178]
[null,179]
[null,180]
[null,181]
[null,182]
[null,183]
[null,184]
[null,185]
[null,186]
[null,187]
[null,188]
[null,189]
[null,190]
[null,191]
[null,192]
[null,193]
[null,194]
[null,195]
[null,196]
[null,197]
[null,198]
[null,199]
[null,200]