{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["FAA ORDER FORM","Ctrl_Selections","Widths","Projection check","Codes"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":17,"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":"FAA ORDER FORM","index":0,"n_rows":64,"n_cols":29,"rows_kept":64,"cut":false,"hidden":false,"merged":[[14,1,15,3],[10,27,11,27],[13,15,13,26],[12,15,12,26],[36,2,36,4],[24,2,24,12],[26,2,26,12],[28,2,28,12],[30,2,30,12],[51,1,51,27],[8,15,8,26],[9,15,9,26],[10,15,11,26],[10,12,11,12],[38,2,38,3],[10,8,10,10],[10,2,10,5],[11,2,11,5],[14,4,15,10],[11,8,11,10],[13,3,13,10],[22,2,22,12],[37,2,37,3],[36,9,36,22],[17,6,17,8],[39,2,39,3],[54,5,54,6],[55,5,56,5],[2,6,2,9],[8,2,8,10],[6,1,7,2],[6,3,7,5],[9,2,9,10],[6,6,7,6],[6,7,7,10],[40,2,40,3],[45,6,46,7],[45,9,45,15],[54,1,54,3],[55,2,55,3],[55,1,56,1]]}
[]
[]
[null,"ORDER FORM - AWNINGS",null,null,null,null,"NOTES: \n1. 78 AL HD Tube option only available under 6m widths.\n2. Add 200mm to minimum width when using the Motion Sensor inside the terminal bar.\n3. 1x 1.8m Crank Handle is included with every Manual awning kit. "]
[null,"Fax Nr. : +61 3 9355 0110",null," E-mail: custsvc@rolleaseacmeda.com"]
[]
[]
[null,"Customer Purchase Number:",null,null,null,null,"Date (dd/mm/yy):"]
[]
[null,"Company Name:",null,null,null,null,null,null,null,null,null,null,"Version:",null,null,"Changes",null,null,null,null,null,null,null,null,null,null,null,"Date effective:"]
[null,"Company Adress:",null,null,null,null,null,null,null,null,null,null,"3.17a",null,null,"Fixed error for YUKI 2.5m code. ",null,null,null,null,null,null,null,null,null,null,null,"2024-07-10"]
[null,"E-Mail:",null,null,null,null,null,"Tel :",null,null,null,null,3.18,null,null,"Removed 'Fascia Mounting Bracket' compatibility with YUKI.",null,null,null,null,null,null,null,null,null,null,null,"2024-08-01"]
[null,"Contact:",null,null,null,null,null,"Fax:"]
[]
[null,"To the attention of:"]
[null,"Requested delivery date (dd/mm/yy):"]
[]
[]
[null,"Delivered by Rollease Acmeda (X):",null,null,"Transport organised by Customer (X):",null,"Authorised Signature:"]
[]
[]
[null,"System","Colour","Control Type","Motor Type","Control side","Awning Options","Tube Option","Width (mm)","Exact Width (Overall, mm)","Projection (mm)","Installation","Quantity","START","END","Width Check","System","Control","Projection","Colour","Width","Cntr Supps","Mnt Brkts",null,"# Arms\n(Each)","Min width","Arm Check","Awning Kit Code","Awning Protection Hood Kit Code"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($B22&$I22,Widths!$C:$E,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B22&$I22,Widths!$C:$E,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(J22=\"\",\"\",IFERROR(IF(SUM(J22<N22,J22>O22),\"ERROR\",\"OK\"),\"\"))","v":""},{"$f":"VLOOKUP(B22,Codes!$A$10:$B$16,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D22&IF(OR(G22=\"\",G22=\"NO\"),\"\",INDEX(Codes!$B$46:$B$51,MATCH(G22,Codes!$A$46:$A$51,0))),Codes!$A$19:$C$25,IF(H22=\"78 AL HD\",3,2),FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K22,Codes!$A$30:$B$38,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C22,Codes!$A$38:$B$39,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"LEFT(O22/10,3)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP($B22&$I22&($K22/10),Widths!$G:$J,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B22&$I22&($K22/10),Widths!$G:$J,3,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($B22&$I22&($K22/10),Widths!$G:$J,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B22&(K22/10)&Y22,'Projection check'!$A$23:$B$44,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(OR(P22=\"\",K22=\"\"),\"\",IF(J22>=Z22,\"OK\",\"ERROR\")),\"\")","v":""},{"$f":"IFERROR(IF(OR(AA22=\"ERROR\",AA22=\"\"),\"\",Q22&R22&S22&T22&U22),\"\")","v":""},{"$f":"IF(G22=\"Add Hood\",\"AW57-1000-\"&T22&ROUNDUP(J22/1000,0)&\"00\",\"\")","v":""}]
[null,"Assembly notes:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($B24&$I24,Widths!$C:$E,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B24&$I24,Widths!$C:$E,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(J24=\"\",\"\",IFERROR(IF(SUM(J24<N24,J24>O24),\"ERROR\",\"OK\"),\"\"))","v":""},{"$f":"VLOOKUP(B24,Codes!$A$10:$B$16,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D24&IF(OR(G24=\"\",G24=\"NO\"),\"\",INDEX(Codes!$B$46:$B$51,MATCH(G24,Codes!$A$46:$A$51,0))),Codes!$A$19:$C$25,IF(H24=\"78 AL HD\",3,2),FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K24,Codes!$A$30:$B$35,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C24,Codes!$A$38:$B$39,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"LEFT(O24/10,3)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP($B24&$I24&($K24/10),Widths!$G:$J,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B24&$I24&($K24/10),Widths!$G:$J,3,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($B24&$I24&($K24/10),Widths!$G:$J,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B24&(K24/10)&Y24,'Projection check'!$A$23:$B$44,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(OR(P24=\"\",K24=\"\"),\"\",IF(J24>=Z24,\"OK\",\"ERROR\")),\"\")","v":""},{"$f":"IFERROR(IF(AA24=\"ERROR\",\"\",Q24&R24&S24&T24&U24),\"\")","v":""},{"$f":"IF(G24=\"Add Hood\",\"AW57-1000-\"&T24&ROUNDUP(J24/1000,0)&\"00\",\"\")","v":""}]
[null,"Assembly notes:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($B26&$I26,Widths!$C:$E,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B26&$I26,Widths!$C:$E,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(J26=\"\",\"\",IFERROR(IF(SUM(J26<N26,J26>O26),\"ERROR\",\"OK\"),\"\"))","v":""},{"$f":"VLOOKUP(B26,Codes!$A$10:$B$16,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D26&IF(OR(G26=\"\",G26=\"NO\"),\"\",INDEX(Codes!$B$46:$B$51,MATCH(G26,Codes!$A$46:$A$51,0))),Codes!$A$19:$C$25,IF(H26=\"78 AL HD\",3,2),FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K26,Codes!$A$30:$B$35,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C26,Codes!$A$38:$B$39,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"LEFT(O26/10,3)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP($B26&$I26&($K26/10),Widths!$G:$J,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B26&$I26&($K26/10),Widths!$G:$J,3,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($B26&$I26&($K26/10),Widths!$G:$J,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B26&(K26/10)&Y26,'Projection check'!$A$23:$B$41,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(OR(P26=\"\",K26=\"\"),\"\",IF(J26>=Z26,\"OK\",\"ERROR\")),\"\")","v":""},{"$f":"IFERROR(IF(AA26=\"ERROR\",\"\",Q26&R26&S26&T26&U26),\"\")","v":""},{"$f":"IF(G26=\"Add Hood\",\"AW57-1000-\"&T26&ROUNDUP(J26/1000,0)&\"00\",\"\")","v":""}]
[null,"Assembly notes:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($B28&$I28,Widths!$C:$E,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B28&$I28,Widths!$C:$E,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(J28=\"\",\"\",IFERROR(IF(SUM(J28<N28,J28>O28),\"ERROR\",\"OK\"),\"\"))","v":""},{"$f":"VLOOKUP(B28,Codes!$A$10:$B$16,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D28&IF(OR(G28=\"\",G28=\"NO\"),\"\",INDEX(Codes!$B$46:$B$51,MATCH(G28,Codes!$A$46:$A$51,0))),Codes!$A$19:$C$25,IF(H28=\"78 AL HD\",3,2),FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K28,Codes!$A$30:$B$35,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C28,Codes!$A$38:$B$39,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"LEFT(O28/10,3)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP($B28&$I28&($K28/10),Widths!$G:$J,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B28&$I28&($K28/10),Widths!$G:$J,3,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($B28&$I28&($K28/10),Widths!$G:$J,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B28&(K28/10)&Y28,'Projection check'!$A$23:$B$41,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(OR(P28=\"\",K28=\"\"),\"\",IF(J28>=Z28,\"OK\",\"ERROR\")),\"\")","v":""},{"$f":"IFERROR(IF(AA28=\"ERROR\",\"\",Q28&R28&S28&T28&U28),\"\")","v":""},{"$f":"IF(G28=\"Add Hood\",\"AW57-1000-\"&T28&ROUNDUP(J28/1000,0)&\"00\",\"\")","v":""}]
[null,"Assembly notes:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($B30&$I30,Widths!$C:$E,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B30&$I30,Widths!$C:$E,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(J30=\"\",\"\",IFERROR(IF(SUM(J30<N30,J30>O30),\"ERROR\",\"OK\"),\"\"))","v":""},{"$f":"VLOOKUP(B30,Codes!$A$10:$B$16,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D30&IF(OR(G30=\"\",G30=\"NO\"),\"\",INDEX(Codes!$B$46:$B$51,MATCH(G30,Codes!$A$46:$A$51,0))),Codes!$A$19:$C$25,IF(H30=\"78 AL HD\",3,2),FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K30,Codes!$A$30:$B$35,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C30,Codes!$A$38:$B$39,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"LEFT(O30/10,3)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP($B30&$I30&($K30/10),Widths!$G:$J,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B30&$I30&($K30/10),Widths!$G:$J,3,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($B30&$I30&($K30/10),Widths!$G:$J,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B30&(K30/10)&Y30,'Projection check'!$A$23:$B$41,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(OR(P30=\"\",K30=\"\"),\"\",IF(J30>=Z30,\"OK\",\"ERROR\")),\"\")","v":""},{"$f":"IFERROR(IF(AA30=\"ERROR\",\"\",Q30&R30&S30&T30&U30),\"\")","v":""},{"$f":"IF(G30=\"Add Hood\",\"AW57-1000-\"&T30&ROUNDUP(J30/1000,0)&\"00\",\"\")","v":""}]
[null,"Assembly notes:"]
[]
[]
[null,"(Rollease Acmeda can supply only Automate motors for awnings. If a different motor is requested this info will be used only for profile deductions - Motors will not be supplied)"]
[]
[]
[null,null,"AUTOMATE ACCESSORIES",null,null,"QTY",null,null,null,"AWNING PROTECTION HOODS (Automatically populated)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QTY"]
[null,null,"Remote - PUSH 1CH (White)",null,"MT02-0101-067010",null,null,null,null,{"$f":"IFERROR(IF(M38<>\"\",\"Protection Hood Kit | \"&ROUNDUP(J22/1000,0)&\"m\",\"\"),\"\")","v":""},null,null,{"$f":"IFERROR(AC22,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M38<>\"\",M22,\"\")","v":""}]
[null,null,"Remote - PUSH 1CH (Black)",null,"MT02-0101-050010",null,null,null,null,{"$f":"IFERROR(IF(M39<>\"\",\"Protection Hood Kit | \"&ROUNDUP(J23/1000,0)&\"m\",\"\"),\"\")","v":""},null,null,{"$f":"IFERROR(AC24,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M39<>\"\",M23,\"\")","v":""}]
[null,null,"Remote - PUSH 5CH (White)",null,"MT02-0101-067004",null,null,null,null,"",null,null,{"$f":"IFERROR(AC26,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Remote - PUSH 5CH (Black)",null,"MT02-0101-050004",null,null,null,null,"",null,null,{"$f":"IFERROR(AC28,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Remote - PUSH 15CH (White)",null,"MT02-0101-067008",null,null,null,null,"",null,null,{"$f":"IFERROR(AC30,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Remote - PUSH 15CH (Black)",null,"MT02-0101-050008"]
[null,null,"Solar Sun & Wind Sensor",null,"MT02-0301-072001"]
[null,null,"240V Sun & Wind Sensor",null,"MT02-0301-072003"]
[null,null,"Motion Sensor (White)",null,"MT02-0301-072002",null,"Add 200mm to minimum width when using the Motion Sensor inside the terminal bar.",null,null,"FASCIA MOUNTING BRACKETS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QTY"]
[null,null,"Motion Sensor (Black)",null,"MT02-0301-050002",null,null,null,null,{"$f":"IF(W47=\"\",\"AW92-2101-033°°°\",\"AW92-2101-033\"&INDEX(Ctrl_Selections!O23:O25,MATCH('FAA ORDER FORM'!W47,L_Angle,0)))","v":"AW92-2101-033°°°"},null,"Fascia Mounting Bracket - LOW",null,null,null,null,null,null,null,null,null,null,null,null,null,"Use with: PIUMA"]
[null,null,"AX30 Motor",null,"MT01-1145-069013",null,null,null,null,{"$f":"IF(W48=\"\",\"AW92-2102-033°°°\",\"AW92-2102-033\"&INDEX(Ctrl_Selections!O23:O25,MATCH('FAA ORDER FORM'!W48,L_Angle,0)))","v":"AW92-2102-033°°°"},null,"Fascia Mounting Bracket - HIGH",null,null,null,null,null,null,null,null,null,null,null,null,null,"Use with: PIUMA"]
[null,null,"AX50 Motor",null,"MT01-1145-069015"]
[null,null,"Zamak Adaptor (Optional, AX only)",null,"RB56-0766-014050"]
[]
[]
[null,"MINIMUM AWNING WIDTHS (mm)"]
[]
[null,"PIUMA - MIN. WIDTH (mm)",null,null,null,"YUKI - MIN. WIDTH (mm)"]
[null,"System Proj. (mm)","No. of arms",null,null,"System Proj. (mm)","No. of arms"]
[null,null,2,3,null,null,2]
[null,2040,2230,3460,null,2090,2220]
[null,2540,2730,4210,null,2590,2720]
[null,3040,3230,4960,null,3090,3220]
[]
[]
[]
[null,"RECOMMENDED MOTOR SELECTION"]

{"sheet":"Ctrl_Selections","index":1,"n_rows":191,"n_cols":17,"rows_kept":191,"cut":false,"hidden":true,"merged":[[140,3,140,11],[132,3,132,11],[2,0,2,1],[4,4,4,11],[6,2,10,2],[6,3,10,3],[108,4,108,11],[110,2,112,2],[110,3,112,3],[157,4,157,11],[159,2,161,2],[159,3,161,3],[175,3,175,11],[183,3,183,11]]}
[null,null,"=IF(INDIRECT(\"i_\"&SUBSTITUTE(D55,\" \",\"\")),0,\"No\") if a default value is required"]
[]
["Configuration Matrix"]
[]
[null,null,"Enter DEPENDENCIES","SELECTION OPTIONS","CONFIGURATIONS",null,null,null,null,null,null,null,null,"L_MotorOptions","L_LeftRight"]
[null,null,"Ref Position →",{"$f":"COUNTA(D7:D14)","v":1},{"$f":"SUM(COUNTIF(E7:E14,$C7:$C14))","v":0},{"$f":"SUM(COUNTIF(F7:F14,$C7:$C14))","v":0},{"$f":"SUM(COUNTIF(G7:G14,$C7:$C14))","v":0},{"$f":"SUM(COUNTIF(H7:H14,$C7:$C14))","v":0},{"$f":"SUM(COUNTIF(I7:I14,$C7:$C14))","v":0},{"$f":"SUM(COUNTIF(J7:J14,$C7:$C14))","v":0},{"$f":"SUM(COUNTIF(K7:K14,$C7:$C14))","v":0},{"$f":"SUM(COUNTIF(L7:L14,$C7:$C14))","v":0},null,"AUTOMATE - Motor Required","LEFT",null,"Star Head Adaptor"]
[null,"Enter Selection 1 ->",null,"System","PIUMA","FENG","YUKI","KUMO",null,null,null,null,null,"AUTOMATE - Motor Not Required","RIGHT",null,"Square Shaft Adaptor"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"SOMFY"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"L_System"]
[null,"Enter Selection 2->",null,null,null,null,null,null,null,null,null,null,null,"PIUMA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"YUKI"]
[]
[]
[null,null,null,null,{"$f":"COUNTA(E17:E21)","v":2},{"$f":"COUNTA(F17:F21)","v":1},2,3,0,0,0,0]
[null,"Dependent (Output List) 1 -> ",null,"Colour","White (074)","Graphite (315)","White (074)","Black (050)"]
[null,null,null,null,"Graphite (315)",null,"Graphite (315)","White (074)"]
[null,null,null,null,null,null,null,"Graphite (315)"]
[]
[]
[null,null,null,"DO NOT FILL",null,null,null,null,null,null,null,null,null,"L_Angle"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"10°","010"]
[null,null,null,null,{"$f":"COUNTA(E25:E29)","v":2},{"$f":"COUNTA(F25:F29)","v":1},{"$f":"COUNTA(G25:G29)","v":2},{"$f":"COUNTA(H25:H29)","v":2},{"$f":"COUNTA(I25:I29)","v":0},{"$f":"COUNTA(J25:J29)","v":0},{"$f":"COUNTA(K25:K29)","v":0},{"$f":"COUNTA(L25:L29)","v":0},null,"22°","022"]
[null,"Dependent (Output List) 1 -> ",null,"ControlOption","Motor","Motor","Motor","Motor",null,null,null,null,null,"33°","033"]
[null,null,null,null,"Manual",null,"Manual","Manual"]
[]
[]
[]
[null,null,null,"DO NOT FILL"]
[]
[null,null,null,null,{"$f":"COUNTA(E33:E37)","v":2},{"$f":"COUNTA(F33:F37)","v":2},{"$f":"COUNTA(G33:G37)","v":2},{"$f":"COUNTA(H33:H37)","v":2},{"$f":"COUNTA(I33:I37)","v":0},{"$f":"COUNTA(J33:J37)","v":0},{"$f":"COUNTA(K33:K37)","v":0},{"$f":"COUNTA(L33:L37)","v":0}]
[null,"Dependent (Output List) 1 -> ",null,"InstallationOption","Face Fix","Face Fix Bkt","Face Fix","Face Fix"]
[null,null,null,null,"Top Fix","Top Fix Bkt","Top Fix","Top Fix"]
[]
[]
[]
[null,null,null,"DO NOT FILL"]
[]
[null,null,null,null,{"$f":"COUNTA(E41:E45)","v":2},{"$f":"COUNTA(F41:F45)","v":4},{"$f":"COUNTA(G41:G45)","v":2},{"$f":"COUNTA(H41:H45)","v":2},{"$f":"COUNTA(I41:I45)","v":0},{"$f":"COUNTA(J41:J45)","v":0},{"$f":"COUNTA(K41:K45)","v":0},{"$f":"COUNTA(L41:L45)","v":0}]
[null,"Dependent (Output List) 1 -> ",null,"AwningOptions","None","None","None","None"]
[null,null,null,null,"Add Hood","Upgrade to LED Arms","Add Hood","Add Hood"]
[null,null,null,null,null,"Upgrade to Cassette LED Strip"]
[null,null,null,null,null,"Upgrade to LED Arms + Cassette LED Strip"]
[]
[null,null,null,"DO NOT FILL"]
[]
[null,null,null,null,{"$f":"COUNTA(E49:E53)","v":3},{"$f":"COUNTA(F49:F53)","v":3},{"$f":"COUNTA(G49:G53)","v":3},{"$f":"COUNTA(H49:H53)","v":3},{"$f":"COUNTA(I49:I53)","v":0},{"$f":"COUNTA(J49:J53)","v":0},{"$f":"COUNTA(K49:K53)","v":0},{"$f":"COUNTA(L49:L53)","v":0}]
[null,"Dependent (Output List) 1 -> ",null,"ProjectionOption",2040,2650,2090,2200]
[null,null,null,null,2540,3150,2590,2700]
[null,null,null,null,3040,3650,3090,3200]
[]
[]
[]
[null,null,null,"DO NOT FILL"]
[]
[null,null,null,null,{"$f":"COUNTA(E58:E71)","v":5},{"$f":"COUNTA(F58:F71)","v":5},2,3,0,0,0,0]
[null,"Dependent (Output List) 1 -> ",null,"WidthOption","2230 - 3600","3110 - 4000","2220 - 4000","2390 - 4000"]
[null,null,null,null,"3601 - 4800","4001 - 4500","4001 - 5000","4001 - 5000"]
[null,null,null,null,"4801 - 5400","4501 - 5000",null,"5001 - 6000"]
[null,null,null,null,"5401 - 6000","5001 - 6000"]
[null,null,null,null,"6001 - 7000","6001 - 7000"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"DO NOT FILL"]
[]
[]
[]
[]
[]
[null,null,null,null,"2230 - 2400","3110 - 3500","2220 - 2720","2390 - 2890"]
[null,null,null,null,"2401 - 3000","3501 - 4000","2721 - 3220","2891 - 3390"]
[null,null,null,null,"3001 - 3600","4001 - 4500","3221 - 5000","3391 - 4000"]
[null,null,null,null,"3601 - 4000","4501 - 5000",null,"4001 - 5000"]
[null,null,null,null,"4001 - 5000","5001 - 6000",null,"5001 - 6000"]
[null,null,null,null,"5001 - 5400","6001 - 7000"]
[null,null,null,null,"5401 - 6000","7001 - 8000"]
[null,null,null,null,"6001 - 7000","8001 - 9000"]
[null,null,null,null,null,"9001 - 10000"]
[null,null,null,null,null,"10001 - 11000","2721 - 3220"]
[null,null,null,null,null,"11001 - 12000","3221 - 5000"]
[null,null,null,null,null,"12001 - 13000"]
[null,null,null,null,null,"13001 - 14000"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Enter DEPENDENCIES","SELECTION OPTIONS","CONFIGURATIONS"]
[null,null,"Ref Position →",{"$f":"COUNTA(D111:D125)","v":3},{"$f":"SUM(COUNTIF(E111:E125,$C111:$C125))","v":0},{"$f":"SUM(COUNTIF(F111:F125,$C111:$C125))","v":0},{"$f":"SUM(COUNTIF(G111:G125,$C111:$C125))","v":0},{"$f":"SUM(COUNTIF(H111:H125,$C111:$C125))","v":0},{"$f":"SUM(COUNTIF(I111:I125,$C111:$C125))","v":0},{"$f":"SUM(COUNTIF(J111:J125,$C111:$C125))","v":0},{"$f":"SUM(COUNTIF(K111:K125,$C111:$C125))","v":0},{"$f":"SUM(COUNTIF(L111:L125,$C111:$C125))","v":0}]
[null,"Enter Selection 2->",null,"System"]
[]
[]
[null,null,null,"Width"]
[null,null,null,"Projection"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Enter Selection 3->"]
[null,"Enter Selection 4->"]
[]
[null,null,null,{"$f":"MAX(E127:L127)","v":0},{"$f":"IF(E110<>$D110,0,COUNTA(E128:E132))","v":0},0,0,0,0,0,0,0]
[null,"Dependent (Output List) 1 -> "]
[]
[]
[]
[]
[null,null,null,"DO NOT FILL"]
[]
[null,null,null,{"$f":"MAX(E135:L135)","v":0},{"$f":"IF(E110<>$D110,0,COUNTA(E136:E140))","v":0},0,0,0,0,0,0,0]
[null,"Dependent (Output List) 1 -> "]
[]
[]
[]
[]
[null,null,null,"DO NOT FILL"]
[]
[null,null,null,{"$f":"D128","v":0},{"$f":"D136","v":0},null,{"$f":"SUBSTITUTE(\" \",\"\",#REF!)","v":{"$error":"#REF!"}}]
[null,null,"row",{"$f":"MATCH(D143,$D110:$D141,0)","v":18},{"$f":"MATCH(E143,$D110:$D141,0)","v":18}]
[null,null,"column",{"$f":"MATCH(OFFSET($D110,MATCH(D143,$D110:$D134,0)-2,0),OFFSET($D110,MATCH(D143,$D110:$D134,0)-2,1,1,11),0)+1","v":{"$error":"#N/A"}},{"$f":"MATCH(OFFSET($D110,MATCH(E143,$D110:$D141,0)-2,0),OFFSET($D110,MATCH(E143,$D110:$D141,0)-2,1,1,11),0)+1","v":{"$error":"#N/A"}}]
[null,null,"Size",{"$f":"OFFSET($D110,MATCH(D143,$D110:$D134,0)-2,0,)","v":0},{"$f":"OFFSET($D110,MATCH(E143,$D110:$D141,0)-2,0,)","v":0}]
[null,null,"Test →"]
[null,null,"Data Validation Name",{"$f":"\"L_\"&SUBSTITUTE(D143,\" \",\"\")","v":"L_0"},{"$f":"\"L_\"&SUBSTITUTE(E143,\" \",\"\")","v":"L_0"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Enter DEPENDENCIES","SELECTION OPTIONS","CONFIGURATIONS"]
[null,null,"Ref Position →",{"$f":"COUNTA(D160:D168)","v":0},{"$f":"SUM(COUNTIF(E160:E168,$C160:$C168))","v":0},{"$f":"SUM(COUNTIF(F160:F168,$C160:$C168))","v":0},{"$f":"SUM(COUNTIF(G160:G168,$C160:$C168))","v":0},{"$f":"SUM(COUNTIF(H160:H168,$C160:$C168))","v":0},{"$f":"SUM(COUNTIF(I160:I168,$C160:$C168))","v":0},{"$f":"SUM(COUNTIF(J160:J168,$C160:$C168))","v":0},{"$f":"SUM(COUNTIF(K160:K168,$C160:$C168))","v":0},{"$f":"SUM(COUNTIF(L160:L168,$C160:$C168))","v":0}]
[null,"Enter Selection 2->"]
[]
[]
[]
[]
[]
[]
[null,"Enter Selection 3->"]
[null,"Enter Selection 4->"]
[]
[null,null,null,{"$f":"MAX(E170:L170)","v":0},{"$f":"IF(E159<>$D159,0,COUNTA(E171:E175))","v":0},0,0,0,0,0,0,0]
[null,"Dependent (Output List) 1 -> "]
[]
[]
[]
[]
[null,null,null,"DO NOT FILL"]
[]
[null,null,null,{"$f":"MAX(E178:L178)","v":0},{"$f":"IF(E159<>$D159,0,COUNTA(E179:E183))","v":0},0,0,0,0,0,0,0]
[null,"Dependent (Output List) 1 -> "]
[]
[]
[]
[]
[null,null,null,"DO NOT FILL"]
[]
[null,null,null,{"$f":"D171","v":0},{"$f":"D179","v":0},null,{"$f":"SUBSTITUTE(\" \",\"\",#REF!)","v":{"$error":"#REF!"}}]
[null,null,"row",{"$f":"MATCH(D186,$D159:$D184,0)","v":1},{"$f":"MATCH(E186,$D159:$D184,0)","v":1}]
[null,null,"column",{"$f":"MATCH(OFFSET($D159,MATCH(D186,$D159:$D177,0)-2,0),OFFSET($D159,MATCH(D186,$D159:$D177,0)-2,1,1,11),0)+1","v":{"$error":"#N/A"}},{"$f":"MATCH(OFFSET($D159,MATCH(E186,$D159:$D184,0)-2,0),OFFSET($D159,MATCH(E186,$D159:$D184,0)-2,1,1,11),0)+1","v":{"$error":"#N/A"}}]
[null,null,"Size",{"$f":"OFFSET($D159,MATCH(D186,$D159:$D177,0)-2,0,)","v":"SELECTION OPTIONS"},{"$f":"OFFSET($D159,MATCH(E186,$D159:$D184,0)-2,0,)","v":"SELECTION OPTIONS"}]
[null,null,"Test →"]
[null,null,"Data Validation Name",{"$f":"\"L_\"&SUBSTITUTE(D186,\" \",\"\")","v":"L_0"},{"$f":"\"L_\"&SUBSTITUTE(E186,\" \",\"\")","v":"L_0"}]

{"sheet":"Widths","index":2,"n_rows":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":true,"merged":[]}
[null,"System","WIDTH","MIN","MAX","Projection","CODE","ARMS","Mnt Brackets","Cntr Supps"]
[null,"PIUMA",{"$f":"B2&D2&\" - \"&E2","v":"PIUMA2230 - 3600"},2230,3600,204,{"$f":"B2&D2&\" - \"&E2&F2","v":"PIUMA2230 - 3600204"},2,2,0]
[null,"PIUMA",{"$f":"B3&D3&\" - \"&E3","v":"PIUMA2230 - 3600"},2230,3600,254,{"$f":"B3&D3&\" - \"&E3&F3","v":"PIUMA2230 - 3600254"},2,2,0]
[null,"PIUMA",{"$f":"B4&D4&\" - \"&E4","v":"PIUMA2230 - 3600"},2230,3600,304,{"$f":"B4&D4&\" - \"&E4&F4","v":"PIUMA2230 - 3600304"},2,2,0]
[null,"PIUMA","PIUMA3601 - 4800",3601,4800,204,"PIUMA3601 - 4800204",2,3,0]
[null,"PIUMA","PIUMA3601 - 4800",3601,4800,254,"PIUMA3601 - 4800254",2,3,0]
[null,"PIUMA","PIUMA3601 - 4800",3601,4800,304,"PIUMA3601 - 4800304",2,3,0]
[null,"PIUMA","PIUMA4801 - 5400",4801,5400,204,"PIUMA4801 - 5400204",2,4,0]
[null,"PIUMA","PIUMA4801 - 5400",4801,5400,254,"PIUMA4801 - 5400254",2,4,0]
[null,"PIUMA","PIUMA4801 - 5400",4801,5400,304,"PIUMA4801 - 5400304",2,4,0]
[null,"PIUMA","PIUMA5401 - 6000",5401,6000,204,"PIUMA5401 - 6000204",2,4,1]
[null,"PIUMA","PIUMA5401 - 6000",5401,6000,254,"PIUMA5401 - 6000254",2,4,1]
[null,"PIUMA","PIUMA5401 - 6000",5401,6000,304,"PIUMA5401 - 6000304",2,4,1]
[null,"PIUMA","PIUMA6001 - 7000",6001,7000,204,"PIUMA6001 - 7000204",3,5,1]
[null,"PIUMA","PIUMA6001 - 7000",6001,7000,254,"PIUMA6001 - 7000254",3,5,1]
[null,"PIUMA","PIUMA6001 - 7000",6001,7000,304,"PIUMA6001 - 7000304",3,5,1]
[null,"KUMO",{"$f":"B17&D17&\" - \"&E17","v":"KUMO2390 - 4000"},2390,4000,220,{"$f":"B17&D17&\" - \"&E17&F17","v":"KUMO2390 - 4000220"},2,2,0]
[null,"KUMO","KUMO2390 - 4000",2390,4000,270,"KUMO2390 - 4000270",2,2,0]
[null,"KUMO","KUMO2390 - 4000",2390,4000,320,"KUMO2390 - 4000320",2,2,0]
[null,"KUMO","KUMO4001 - 5000",4001,5000,220,"KUMO4001 - 5000220",2,2,1]
[null,"KUMO","KUMO4001 - 5000",4001,5000,270,"KUMO4001 - 5000270",2,2,1]
[null,"KUMO","KUMO4001 - 5000",4001,5000,320,"KUMO4001 - 5000320",2,2,1]
[null,"KUMO","KUMO5001 - 6000",5001,6000,220,"KUMO5001 - 6000220",2,2,1]
[null,"KUMO","KUMO5001 - 6000",5001,6000,270,"KUMO5001 - 6000270",2,2,1]
[null,"KUMO","KUMO5001 - 6000",5001,6000,320,"KUMO5001 - 6000320",2,2,1]
[null,"FENG","FENG3110 - 4000",3110,4000,265,"FENG3110 - 4000265",2,2,0]
[null,"FENG","FENG3110 - 4000",3110,4000,315,"FENG3110 - 4000315",2,2,0]
[null,"FENG","FENG3110 - 4000",3110,4000,365,"FENG3110 - 4000365",2,2,0]
[null,"FENG","FENG4001 - 4500",4001,4500,265,"FENG4001 - 4500265",2,3,0]
[null,"FENG","FENG4001 - 4500",4001,4500,315,"FENG4001 - 4500315",2,3,0]
[null,"FENG","FENG4001 - 4500",4001,4500,365,"FENG4001 - 4500365",2,3,0]
[null,"FENG","FENG4501 - 5000",4501,5000,265,"FENG4501 - 5000265",2,3,1]
[null,"FENG","FENG4501 - 5000",4501,5000,315,"FENG4501 - 5000315",2,3,1]
[null,"FENG","FENG4501 - 5000",4501,5000,365,"FENG4501 - 5000365",2,3,1]
[null,"FENG",{"$f":"B35&D35&\" - \"&E35","v":"FENG5001 - 6000"},5001,6000,265,{"$f":"B35&D35&\" - \"&E35&F35","v":"FENG5001 - 6000265"},2,3,1]
[null,"FENG","FENG5001 - 6000",5001,6000,315,"FENG5001 - 6000315",2,3,1]
[null,"FENG","FENG5001 - 6000",5001,6000,365,"FENG5001 - 6000365",2,3,1]
[null,"FENG","FENG6001 - 7000",6001,7000,265,"FENG6001 - 7000265",3,4,1]
[null,"FENG","FENG6001 - 7000",6001,7000,315,"FENG6001 - 7000315",3,4,1]
[null,"FENG","FENG6001 - 7000",6001,7000,365,"FENG6001 - 7000365",3,4,1]
[null,"YUKI",{"$f":"B41&D41&\" - \"&E41","v":"YUKI2220 - 4000"},2220,4000,209,{"$f":"B41&D41&\" - \"&E41&F41","v":"YUKI2220 - 4000209"},2,2,0]
[null,"YUKI",{"$f":"B42&D42&\" - \"&E42","v":"YUKI2220 - 4000"},2220,4000,259,{"$f":"B42&D42&\" - \"&E42&F42","v":"YUKI2220 - 4000259"},2,2,0]
[null,"YUKI",{"$f":"B43&D43&\" - \"&E43","v":"YUKI2220 - 4000"},2220,4000,309,{"$f":"B43&D43&\" - \"&E43&F43","v":"YUKI2220 - 4000309"},2,2,0]
[null,"YUKI",{"$f":"B44&D44&\" - \"&E44","v":"YUKI4001 - 5000"},4001,5000,209,{"$f":"B44&D44&\" - \"&E44&F44","v":"YUKI4001 - 5000209"},2,2,0]
[null,"YUKI",{"$f":"B45&D45&\" - \"&E45","v":"YUKI4001 - 5000"},4001,5000,259,{"$f":"B45&D45&\" - \"&E45&F45","v":"YUKI4001 - 5000259"},2,2,0]
[null,"YUKI",{"$f":"B46&D46&\" - \"&E46","v":"YUKI4001 - 5000"},4001,5000,309,{"$f":"B46&D46&\" - \"&E46&F46","v":"YUKI4001 - 5000309"},2,2,0]

{"sheet":"Projection check","index":3,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["PIUMA",2,3,null,null,null,null,null,null,2]
[2040,2230,3460,null,null,null,null,{"$f":"$A$1&A2","v":"PIUMA2040"},null,{"$f":"$H2&J$1","v":"PIUMA20402"},{"$f":"B2","v":2230}]
[2540,2730,4210,null,null,null,null,{"$f":"$A$1&A3","v":"PIUMA2540"},null,{"$f":"$H3&J$1","v":"PIUMA25402"},{"$f":"B3","v":2730}]
[3040,3230,4960,null,null,null,null,"PIUMA3040",null,"PIUMA30402",3230]
[]
["KUMO","MIN. WIDTH",null,null,null,null,null,null,null,2]
[2200,2390,null,null,null,null,null,{"$f":"$A$6&A7","v":"KUMO2200"},null,{"$f":"$H7&J$6","v":"KUMO22002"},{"$f":"B7","v":2390}]
[2700,2890,null,null,null,null,null,{"$f":"$A$6&A8","v":"KUMO2700"},null,{"$f":"$H8&J$6","v":"KUMO27002"},2890]
[3200,3390,null,null,null,null,null,"KUMO3200",null,"KUMO32002",3390]
[]
["FENG",2,3,null,null,null,null,null,null,2,null,3]
[2650,3110,4560,null,null,null,null,null,null,{"$f":"$A$11&$A12&J$11","v":"FENG26502"},{"$f":"B12","v":3110},{"$f":"$A$11&$A12&L$11","v":"FENG26503"},{"$f":"C12","v":4560}]
[3150,3650,5370,null,null,null,null,null,null,{"$f":"$A$11&$A13&J$11","v":"FENG31502"},{"$f":"B13","v":3650},{"$f":"$A$11&$A13&L$11","v":"FENG31503"},{"$f":"C13","v":5370}]
[3650,4110,6060,null,null,null,null,null,null,{"$f":"$A$11&$A14&J$11","v":"FENG36502"},4110,{"$f":"$A$11&$A14&L$11","v":"FENG36503"},6060]
[]
["YUKI",2,null,null,null,null,null,null,null,2]
[2090,2220,null,null,null,null,null,{"$f":"$A$16&A17","v":"YUKI2090"},null,{"$f":"$H17&J$1","v":"YUKI20902"},{"$f":"B17","v":2220}]
[2590,2720,null,null,null,null,null,{"$f":"$A$16&A18","v":"YUKI2590"},null,{"$f":"$H18&J$1","v":"YUKI25902"},{"$f":"B18","v":2720}]
[3090,3220,null,null,null,null,null,"YUKI3090",null,"YUKI30902",3220]
[]
[]
[]
["PIUMA2042",2230]
["PIUMA2542",2730]
["PIUMA3042",3230]
["KUMO2202",2390]
["KUMO2702",2890]
["KUMO3202",3390]
["FENG2652",3110]
["FENG3152",3650]
["FENG3652",4110]
["PIUMA2043",3460]
["PIUMA2543",4210]
["PIUMA3043",4960]
["FENG2653",4560]
["FENG3153",5370]
["FENG3653",6060]
["YUKI2092",2220]
["YUKI2592",2720]
["YUKI3092",3220]

{"sheet":"Codes","index":4,"n_rows":77,"n_cols":8,"rows_kept":77,"cut":false,"hidden":true,"merged":[[8,12,8,14]]}
[null,"CODE","CONTROL","PROJECTION","COLOUR","WIDTH"]
[]
[null,null,null,null,null,null,null,"EMPTY"]
[]
[]
[]
[]
[]
["CODE"]
["PIUMA",{"$f":"\"AW56-\"","v":"AW56-"}]
["YUKI","AW50-"]
["KLIP",{"$f":"\"AW51-\"","v":"AW51-"}]
["STEIN",{"$f":"\"AW54-\"","v":"AW54-"}]
["KUMO",{"$f":"\"AW52-\"","v":"AW52-"}]
["SHAN",{"$f":"\"AW53-\"","v":"AW53-"}]
["FENG","AW59-"]
[]
["CONTROL","78 STEEL (2x)","78 AL HD (3x)"]
["Motor",{"$f":"\"20\"","v":"20"},30]
["MotorHood",20,30,"x1"]
["Manual",{"$f":"\"22\"","v":"22"},32]
["ManualHood",22,32,"x3"]
["MotorLEDArms",{"$f":"\"24\"","v":"24"},34]
[]
[]
[]
[]
[]
["PROJECTION (mm)"]
[2040,"20-",null,null,2]
[2090,"20-",null,null,2]
[2540,"25-",null,null,2.5]
[2590,"25-",null,null,2.5]
[3040,{"$f":"\"30-\"","v":"30-"},null,null,3]
[3090,"30-",null,null,3]
[]
["COLOUR"]
["White (074)",{"$f":"\"074\"","v":"074"}]
["Graphite (315)",{"$f":"\"315\"","v":"315"}]
[]
["WIDTH"]
[]
[]
[]
["Option Input","Output Text"]
["Upgrade to LED Arms","LEDArms"]
["Upgrade to Cassette LED Strip"]
["Upgrade to LED Arms + Cassette LED Strip","LEDArms"]
["Add Hood","HOOD"]
["Upgrade KLIP - POD (max 3.5m Proj.)","POD"]
["None"]
[]
[]
[]
["Tube Type"]
["78 STEEL"]
["78 AL HD"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Hood Code","Hood Description","Hood Colour"]
["AW57-1000-074300","Protection Hood Kit | 3m","074","Textured White"]
["AW57-1000-074400","Protection Hood Kit | 4m","074","Textured White"]
["AW57-1000-074500","Protection Hood Kit | 5m","074","Textured White"]
["AW57-1000-074600","Protection Hood Kit | 6m","074","Textured White"]
["AW57-1000-074700","Protection Hood Kit | 7m","074","Textured White"]
["AW57-1000-315300","Protection Hood Kit | 3m",315,"Graphite, Shadelab"]
["AW57-1000-315400","Protection Hood Kit | 4m",315,"Graphite, Shadelab"]
["AW57-1000-315500","Protection Hood Kit | 5m",315,"Graphite, Shadelab"]
["AW57-1000-315600","Protection Hood Kit | 6m",315,"Graphite, Shadelab"]
["AW57-1000-315700","Protection Hood Kit | 7m",315,"Graphite, Shadelab"]