{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Sheet2","Sheet3","Sheet4","LINELIGHT Spec Builder","LINELIGHT Code Finder","Orelle Spec Builder (2)","Driver Starter Lead Info"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":13,"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":"Sheet2","index":0,"n_rows":35,"n_cols":13,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["orelle pro","70w","up to 4m",null,"Please select from list"]
["orelle pro","175w","up to 11m",null,"LINELIGHT Stable white",null,{"$f":"CONCATENATE(E$2,\"/\",E7)","v":"LINELIGHT Stable white/EVG"},"LINELIGHT Stable white/EVG/320W","LINELIGHT DRIVER 1992A/320W EVG",21100298,{"$f":"CONCATENATE(I2,\" - \",J2)","v":"LINELIGHT DRIVER 1992A/320W EVG - 21100298"},"LINELIGHT DRIVER 1992A/70W EVG",21100296]
["orelle pro","350w","up to 18m",null,"LINELIGHT Balanced white",null,{"$f":"CONCATENATE(E$2,\"/\",E8)","v":"LINELIGHT Stable white/LDO"},"LINELIGHT Stable white/LDO/320W","LINELIGHT DRIVER 1992A/320W LDO",21100301,{"$f":"CONCATENATE(I3,\" - \",J3)","v":"LINELIGHT DRIVER 1992A/320W LDO - 21100301"},"LINELIGHT DRIVER 1992A/70W LDO",21100299]
["orelle pro dynamic white ","70w","up to 1.8m",null,"LINELIGHT Stable white (HO)",null,{"$f":"CONCATENATE(E$3,\"/\",E8)","v":"LINELIGHT Balanced white/LDO"},"LINELIGHT Balanced white/LDO/320W","LINELIGHT DRIVER 1992A/BW/320W LDO",21100304,{"$f":"CONCATENATE(I4,\" - \",J4)","v":"LINELIGHT DRIVER 1992A/BW/320W LDO - 21100304"},"LINELIGHT DRIVER 1992A/175W EVG",21100297]
["orelle pro dynamic white ","175w","up to 4m",null,null,null,null,"LINELIGHT Stable White (HO)/EVG/320W","LINELIGHT DRIVER 1992A/320W EVG",21100298,{"$f":"CONCATENATE(I5,\" - \",J5)","v":"LINELIGHT DRIVER 1992A/320W EVG - 21100298"},"LINELIGHT DRIVER 1992A/175W LDO",21100300]
["orelle pro dynamic white ","350w","up to 8m",null,"Choose dimming protocol",null,null,"LINELIGHT Stable White (HO)/LDO/320W","LINELIGHT DRIVER 1992A/320W LDO",21100301,"LINELIGHT DRIVER 1992A/320W LDO - 21100301","LINELIGHT DRIVER 1992A/320W EVG",21100298]
["orelle pro+","70w",1,null,"EVG",null,null,"LINELIGHT Stable white/EVG/175W","LINELIGHT DRIVER 1992A/175W EVG",21100297,"LINELIGHT DRIVER 1992A/175W EVG - 21100297","LINELIGHT DRIVER 1992A/320W LDO",21100301]
["orelle pro+","175w","up to 4m",null,"LDO",null,null,"LINELIGHT Stable white/LDO/175W","LINELIGHT DRIVER 1992A/175W LDO",21100300,"LINELIGHT DRIVER 1992A/175W LDO - 21100300","LINELIGHT DRIVER 1992A/BW/70W LDO",21100302]
["orelle pro+","350w",6,null,null,null,null,"LINELIGHT Balanced white/LDO/175W","LINELIGHT DRIVER 1992A/BW/175W LDO",21100303,"LINELIGHT DRIVER 1992A/BW/175W LDO - 21100303","LINELIGHT DRIVER 1992A/BW/320W LDO",21100304]
[null,null,null,null,null,null,null,"LINELIGHT Stable White (HO)/EVG/175W","LINELIGHT DRIVER 1992A/175W EVG",21100297,"LINELIGHT DRIVER 1992A/175W EVG - 21100297","LINELIGHT DRIVER 1992A/BW/175W LDO",21100303]
["Please select from list","Please select from list","Please select from list","Please select from list","Please select from list",null,null,"LINELIGHT Stable White (HO)/LDO/175W","LINELIGHT DRIVER 1992A/175W LDO",21100300,"LINELIGHT DRIVER 1992A/175W LDO - 21100300"]
["1810mm",827,"Diffuse","Cowl",null,null,null,"LINELIGHT Stable white/EVG/70W","LINELIGHT DRIVER 1992A/70W EVG",21100296,"LINELIGHT DRIVER 1992A/70W EVG - 21100296"]
["910mm",830,null,"No Cowl",null,null,null,"LINELIGHT Stable white/LDO/70W","LINELIGHT DRIVER 1992A/70W LDO",21100299,"LINELIGHT DRIVER 1992A/70W LDO - 21100299"]
["610mm",840,null,null,null,null,null,"LINELIGHT Balanced white/LDO/70W","LINELIGHT DRIVER 1992A/BW/70W LDO",21100302,{"$f":"CONCATENATE(I14,\" - \",J14)","v":"LINELIGHT DRIVER 1992A/BW/70W LDO - 21100302"}]
["310mm",null,null,null,null,null,null,"LINELIGHT Stable White (HO)/EVG/70W","LINELIGHT DRIVER 1992A/70W EVG",21100296,"LINELIGHT DRIVER 1992A/70W EVG - 21100296"]
["160mm",null,null,null,null,null,null,"LINELIGHT Stable White (HO)/LDO/70W","LINELIGHT DRIVER 1992A/70W LDO",21100299,"LINELIGHT DRIVER 1992A/70W LDO - 21100299"]
[]
[]
[]
[null,"Please select from list",null,"LINELIGHT Stable white","orellepro","dorellepro"]
[null,"827-65",null,"LINELIGHT Balanced white","orelleprodw","dorelleprodw"]
[null,null,null,"LINELIGHT Stable white (HO)","orelleproplus","dorelleproplus"]
[null,"Please select from list"]
[null,827,null,"Choose dimming protocol"]
[null,830,null,"EVG"]
[null,840,null,"LDO"]
[]
[]
[null,null,null,"Choose dimming protocol"]
[null,null,null,"EVG"]
[null,"Please select from list",null,"LDO"]
[null,827]
[null,830]
[null,840,null,"Choose dimming protocol"]
[null,null,null,"LDO"]

{"sheet":"Sheet3","index":1,"n_rows":111,"n_cols":15,"rows_kept":111,"cut":false,"hidden":true,"merged":[]}
["Zumtobel Product Code",1,2,3,4,5,6,7,8,9,10,"Zumtobel Product Code",12,"Linelight","SAP Code"]
["ORELLE PRO L01 180-827 AS FG CW 40","LINELIGHT","LINELIGHT Stable white","160mm",180,827,"AS","Diffuse","Cowl",40,{"$f":"CONCATENATE(C2,D2,F2,H2,I2)","v":"LINELIGHT Stable white160mm827DiffuseCowl"},"ORELLE PRO L01 180-827 AS FG CW 40",{"$f":"IFERROR(VLOOKUP(L2,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005393},"LINELIGHT 180-827 L160 CW SR",21013730]
["ORELLE PRO L01 180-827 AS FG 40","LINELIGHT","LINELIGHT Stable white","160mm",180,827,"AS","Diffuse","No Cowl",40,{"$f":"CONCATENATE(C3,D3,F3,H3,I3)","v":"LINELIGHT Stable white160mm827DiffuseNo Cowl"},"ORELLE PRO L01 180-827 AS FG 40",{"$f":"IFERROR(VLOOKUP(L3,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005394},"LINELIGHT 180-827 L160 SR",21013731]
["ORELLE PRO L01 180-830 AS FG CW 40","LINELIGHT","LINELIGHT Stable white","160mm",180,830,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white160mm830DiffuseCowl","ORELLE PRO L01 180-830 AS FG CW 40",{"$f":"IFERROR(VLOOKUP(L4,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005395},"LINELIGHT 180-830 L160 CW SR",21013700]
["ORELLE PRO L01 180-830 AS FG 40","LINELIGHT","LINELIGHT Stable white","160mm",180,830,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white160mm830DiffuseNo Cowl","ORELLE PRO L01 180-830 AS FG 40",{"$f":"IFERROR(VLOOKUP(L5,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005396},"LINELIGHT 180-830 L160 SR",21013701]
["ORELLE PRO L01 180-842 AS FG CW 40","LINELIGHT","LINELIGHT Stable white","160mm",180,840,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white160mm840DiffuseCowl","ORELLE PRO L01 180-840 AS FG CW 40",{"$f":"IFERROR(VLOOKUP(L6,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":"Contact acdc for SAP code"},"LINELIGHT 180-840 L160 CW SR","Create code in MyProduct VIVA"]
["ORELLE PRO L01 180-842 AS FG 40","LINELIGHT","LINELIGHT Stable white","160mm",180,840,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white160mm840DiffuseNo Cowl","ORELLE PRO L01 180-840 AS FG 40",{"$f":"IFERROR(VLOOKUP(L7,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":"Contact acdc for SAP code"},"LINELIGHT 180-840 L160 SR","Create code in MyProduct VIVA"]
["ORELLE PRO L03 400-827 AS FG CW 40","LINELIGHT","LINELIGHT Stable white","310mm",400,827,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white310mm827DiffuseCowl","ORELLE PRO L03 400-827 AS FG CW 40",{"$f":"IFERROR(VLOOKUP(L8,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005399},"LINELIGHT 400-827 L310 CW SR",21013732]
["ORELLE PRO L03 400-827 AS FG 40","LINELIGHT","LINELIGHT Stable white","310mm",400,827,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white310mm827DiffuseNo Cowl","ORELLE PRO L03 400-827 AS FG 40",{"$f":"IFERROR(VLOOKUP(L9,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005400},"LINELIGHT 400-827 L310 SR",21013733]
["ORELLE PRO L03 400-830 AS FG CW 40","LINELIGHT","LINELIGHT Stable white","310mm",400,830,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white310mm830DiffuseCowl","ORELLE PRO L03 400-830 AS FG CW 40",{"$f":"IFERROR(VLOOKUP(L10,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005401},"LINELIGHT 400-830 L310 CW SR",21013702]
["ORELLE PRO L03 400-830 AS FG 40","LINELIGHT","LINELIGHT Stable white","310mm",400,830,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white310mm830DiffuseNo Cowl","ORELLE PRO L03 400-830 AS FG 40",{"$f":"IFERROR(VLOOKUP(L11,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005402},"LINELIGHT 400-830 L310 SR",21013703]
["ORELLE PRO L03 400-842 AS FG CW 40","LINELIGHT","LINELIGHT Stable white","310mm",400,840,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white310mm840DiffuseCowl","ORELLE PRO L03 400-840 AS FG CW 40",{"$f":"IFERROR(VLOOKUP(L12,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":"Contact acdc for SAP code"},"LINELIGHT 400-840 L310 CW SR","Create code in MyProduct VIVA"]
["ORELLE PRO L03 400-842 AS FG 40","LINELIGHT","LINELIGHT Stable white","310mm",400,840,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white310mm840DiffuseNo Cowl","ORELLE PRO L03 400-840 AS FG 40",{"$f":"IFERROR(VLOOKUP(L13,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":"Contact acdc for SAP code"},"LINELIGHT 400-840 L310 SR","Create code in MyProduct VIVA"]
["ORELLE PRO L06 700-827 AS FG CW 40","LINELIGHT","LINELIGHT Stable white","610mm",700,827,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white610mm827DiffuseCowl","ORELLE PRO L06 700-827 AS FG CW 40",{"$f":"IFERROR(VLOOKUP(L14,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005405},"LINELIGHT 700-827 L610 CW SR",21013734]
["ORELLE PRO L06 700-827 AS FG 40","LINELIGHT","LINELIGHT Stable white","610mm",700,827,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white610mm827DiffuseNo Cowl","ORELLE PRO L06 700-827 AS FG 40",{"$f":"IFERROR(VLOOKUP(L15,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005406},"LINELIGHT 700-827 L610 SR",21013735]
["ORELLE PRO L06 700-830 AS FG CW 40","LINELIGHT","LINELIGHT Stable white","610mm",700,830,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white610mm830DiffuseCowl","ORELLE PRO L06 700-830 AS FG CW 40",{"$f":"IFERROR(VLOOKUP(L16,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005407},"LINELIGHT 700-830 L610 CW SR",21013704]
["ORELLE PRO L06 700-830 AS FG 40","LINELIGHT","LINELIGHT Stable white","610mm",700,830,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white610mm830DiffuseNo Cowl","ORELLE PRO L06 700-830 AS FG 40",{"$f":"IFERROR(VLOOKUP(L17,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005408},"LINELIGHT 700-830 L610 SR",21013705]
["ORELLE PRO L06 700-842 AS FG CW 40","LINELIGHT","LINELIGHT Stable white","610mm",700,840,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white610mm840DiffuseCowl","ORELLE PRO L06 700-840 AS FG CW 40",{"$f":"IFERROR(VLOOKUP(L18,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":"Contact acdc for SAP code"},"LINELIGHT 700-840 L610 CW SR","Create code in MyProduct VIVA"]
["ORELLE PRO L06 700-842 AS FG 40","LINELIGHT","LINELIGHT Stable white","610mm",700,840,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white610mm840DiffuseNo Cowl","ORELLE PRO L06 700-840 AS FG 40",{"$f":"IFERROR(VLOOKUP(L19,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":"Contact acdc for SAP code"},"LINELIGHT 700-840 L610 SR","Create code in MyProduct VIVA"]
["ORELLE PRO L09 1000-827 AS FG CW 40","LINELIGHT","LINELIGHT Stable white","910mm",1000,827,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white910mm827DiffuseCowl","ORELLE PRO L09 1000-827 AS FG CW 40",{"$f":"IFERROR(VLOOKUP(L20,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005411},"LINELIGHT 1000-827 L910 CW SR",21013736]
["ORELLE PRO L09 1000-827 AS FG 40","LINELIGHT","LINELIGHT Stable white","910mm",1000,827,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white910mm827DiffuseNo Cowl","ORELLE PRO L09 1000-827 AS FG 40",{"$f":"IFERROR(VLOOKUP(L21,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005412},"LINELIGHT 1000-827 L910 SR",21013737]
["ORELLE PRO L09 1000-830 AS FG CW 40","LINELIGHT","LINELIGHT Stable white","910mm",1000,830,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white910mm830DiffuseCowl","ORELLE PRO L09 1000-830 AS FG CW 40",{"$f":"IFERROR(VLOOKUP(L22,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005413},"LINELIGHT 1000-830 L910 CW SR",21013706]
["ORELLE PRO L09 1000-830 AS FG 40","LINELIGHT","LINELIGHT Stable white","910mm",1000,830,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white910mm830DiffuseNo Cowl","ORELLE PRO L09 1000-830 AS FG 40",{"$f":"IFERROR(VLOOKUP(L23,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005414},"LINELIGHT 1000-830 L910 SR",21013707]
["ORELLE PRO L09 1000-842 AS FG CW 40","LINELIGHT","LINELIGHT Stable white","910mm",1000,840,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white910mm840DiffuseCowl","ORELLE PRO L09 1000-840 AS FG CW 40",{"$f":"IFERROR(VLOOKUP(L24,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":"Contact acdc for SAP code"},"LINELIGHT 1000-840 L910 CW SR","Create code in MyProduct VIVA"]
["ORELLE PRO L09 1000-842 AS FG 40","LINELIGHT","LINELIGHT Stable white","910mm",1000,840,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white910mm840DiffuseNo Cowl","ORELLE PRO L09 1000-840 AS FG 40",{"$f":"IFERROR(VLOOKUP(L25,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":"Contact acdc for SAP code"},"LINELIGHT 1000-840 L910 SR","Create code in MyProduct VIVA"]
["ORELLE PRO L18 2200-827 AS FG CW 40","LINELIGHT","LINELIGHT Stable white","1810mm",2200,827,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white1810mm827DiffuseCowl","ORELLE PRO L18 2200-827 AS FG CW 40",{"$f":"IFERROR(VLOOKUP(L26,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005417},"LINELIGHT 2200-827 L1810 CW SR",21013738]
["ORELLE PRO L18 2200-827 AS FG 40","LINELIGHT","LINELIGHT Stable white","1810mm",2200,827,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white1810mm827DiffuseNo Cowl","ORELLE PRO L18 2200-827 AS FG 40",{"$f":"IFERROR(VLOOKUP(L27,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005418},"LINELIGHT 2200-827 L1810 SR",21013739]
["ORELLE PRO L18 2200-830 AS FG CW 40","LINELIGHT","LINELIGHT Stable white","1810mm",2200,830,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white1810mm830DiffuseCowl","ORELLE PRO L18 2200-830 AS FG CW 40",{"$f":"IFERROR(VLOOKUP(L28,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005419},"LINELIGHT 2200-830 L1810 CW SR",21013708]
["ORELLE PRO L18 2200-830 AS FG 40","LINELIGHT","LINELIGHT Stable white","1810mm",2200,830,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white1810mm830DiffuseNo Cowl","ORELLE PRO L18 2200-830 AS FG 40",{"$f":"IFERROR(VLOOKUP(L29,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005420},"LINELIGHT 2200-830 L1810 SR",21013709]
["ORELLE PRO L18 2200-842 AS FG CW 40","LINELIGHT","LINELIGHT Stable white","1810mm",2200,840,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white1810mm840DiffuseCowl","ORELLE PRO L18 2200-840 AS FG CW 40",{"$f":"IFERROR(VLOOKUP(L30,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":"Contact acdc for SAP code"},"LINELIGHT 2200-840 L1810 CW SR","Create code in MyProduct VIVA"]
["ORELLE PRO L18 2200-842 AS FG 40","LINELIGHT","LINELIGHT Stable white","1810mm",2200,840,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white1810mm840DiffuseNo Cowl","ORELLE PRO L18 2200-840 AS FG 40",{"$f":"IFERROR(VLOOKUP(L31,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":"Contact acdc for SAP code"},"LINELIGHT 2200-840 L1810 SR","Create code in MyProduct VIVA"]
["ORELLE PRO L01 140-927 AS FG CW 40","LINELIGHT","LINELIGHT Stable white","160mm",140,927,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white160mm927DiffuseCowl","ORELLE PRO L01 140-927 AS FG CW 40",{"$f":"IFERROR(VLOOKUP(L32,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005423},"LINELIGHT 140-927 L180 CW SR","Create code in MyProduct VIVA"]
["ORELLE PRO L01 140-927 AS FG 40","LINELIGHT","LINELIGHT Stable white","160mm",140,927,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white160mm927DiffuseNo Cowl","ORELLE PRO L01 140-927 AS FG 40",{"$f":"IFERROR(VLOOKUP(L33,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005424},"LINELIGHT 140-927 L180 SR","Create code in MyProduct VIVA"]
["ORELLE PRO L01 140-930 AS FG CW 40","LINELIGHT","LINELIGHT Stable white","160mm",140,930,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white160mm930DiffuseCowl","ORELLE PRO L01 140-930 AS FG CW 40",{"$f":"IFERROR(VLOOKUP(L34,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005425},"LINELIGHT 140-930 L180 CW SR","Create code in MyProduct VIVA"]
["ORELLE PRO L01 140-930 AS FG 40","LINELIGHT","LINELIGHT Stable white","160mm",140,930,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white160mm930DiffuseNo Cowl","ORELLE PRO L01 140-930 AS FG 40",{"$f":"IFERROR(VLOOKUP(L35,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005426},"LINELIGHT 140-930 L180 SR","Create code in MyProduct VIVA"]
["ORELLE PRO L03 300-927 AS FG CW 40","LINELIGHT","LINELIGHT Stable white","310mm",300,927,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white310mm927DiffuseCowl","ORELLE PRO L03 300-927 AS FG CW 40",{"$f":"IFERROR(VLOOKUP(L36,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005427},"LINELIGHT 300-927 L310 CW SR","Create code in MyProduct VIVA"]
["ORELLE PRO L03 300-927 AS FG 40","LINELIGHT","LINELIGHT Stable white","310mm",300,927,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white310mm927DiffuseNo Cowl","ORELLE PRO L03 300-927 AS FG 40",{"$f":"IFERROR(VLOOKUP(L37,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005428},"LINELIGHT 300-927 L310 SR","Create code in MyProduct VIVA"]
["ORELLE PRO L03 300-930 AS FG CW 40","LINELIGHT","LINELIGHT Stable white","310mm",300,930,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white310mm930DiffuseCowl","ORELLE PRO L03 300-930 AS FG CW 40",{"$f":"IFERROR(VLOOKUP(L38,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005429},"LINELIGHT 300-930 L310 CW SR","Create code in MyProduct VIVA"]
["ORELLE PRO L03 300-930 AS FG 40","LINELIGHT","LINELIGHT Stable white","310mm",300,930,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white310mm930DiffuseNo Cowl","ORELLE PRO L03 300-930 AS FG 40",{"$f":"IFERROR(VLOOKUP(L39,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005430},"LINELIGHT 300-930 L310 SR","Create code in MyProduct VIVA"]
["ORELLE PRO L06 600-927 AS FG CW 40","LINELIGHT","LINELIGHT Stable white","610mm",600,927,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white610mm927DiffuseCowl","ORELLE PRO L06 600-927 AS FG CW 40",{"$f":"IFERROR(VLOOKUP(L40,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005431},"LINELIGHT 600-927 L610 CW SR","Create code in MyProduct VIVA"]
["ORELLE PRO L06 600-927 AS FG 40","LINELIGHT","LINELIGHT Stable white","610mm",600,927,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white610mm927DiffuseNo Cowl","ORELLE PRO L06 600-927 AS FG 40",{"$f":"IFERROR(VLOOKUP(L41,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005432},"LINELIGHT 600-927 L610 SR","Create code in MyProduct VIVA"]
["ORELLE PRO L06 600-930 AS FG CW 40","LINELIGHT","LINELIGHT Stable white","610mm",600,930,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white610mm930DiffuseCowl","ORELLE PRO L06 600-930 AS FG CW 40",{"$f":"IFERROR(VLOOKUP(L42,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005433},"LINELIGHT 600-930 L610 CW SR","Create code in MyProduct VIVA"]
["ORELLE PRO L06 600-930 AS FG 40","LINELIGHT","LINELIGHT Stable white","610mm",600,930,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white610mm930DiffuseNo Cowl","ORELLE PRO L06 600-930 AS FG 40",{"$f":"IFERROR(VLOOKUP(L43,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005434},"LINELIGHT 600-930 L610 SR","Create code in MyProduct VIVA"]
["ORELLE PRO L09 900-927 AS FG CW 40","LINELIGHT","LINELIGHT Stable white","910mm",900,927,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white910mm927DiffuseCowl","ORELLE PRO L09 900-927 AS FG CW 40",{"$f":"IFERROR(VLOOKUP(L44,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005435},"LINELIGHT 900-927 L910 CW SR","Create code in MyProduct VIVA"]
["ORELLE PRO L09 900-927 AS FG 40","LINELIGHT","LINELIGHT Stable white","910mm",900,927,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white910mm927DiffuseNo Cowl","ORELLE PRO L09 900-927 AS FG 40",{"$f":"IFERROR(VLOOKUP(L45,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005436},"LINELIGHT 900-927 L910 SR","Create code in MyProduct VIVA"]
["ORELLE PRO L09 900-930 AS FG CW 40","LINELIGHT","LINELIGHT Stable white","910mm",900,930,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white910mm930DiffuseCowl","ORELLE PRO L09 900-930 AS FG CW 40",{"$f":"IFERROR(VLOOKUP(L46,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005437},"LINELIGHT 900-930 L910 CW SR","Create code in MyProduct VIVA"]
["ORELLE PRO L09 900-930 AS FG 40","LINELIGHT","LINELIGHT Stable white","910mm",900,930,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white910mm930DiffuseNo Cowl","ORELLE PRO L09 900-930 AS FG 40",{"$f":"IFERROR(VLOOKUP(L47,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005438},"LINELIGHT 900-930 L910 SR","Create code in MyProduct VIVA"]
["ORELLE PRO L18 1800-927 AS FG CW 40","LINELIGHT","LINELIGHT Stable white","1810mm",1800,927,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white1810mm927DiffuseCowl","ORELLE PRO L18 1800-927 AS FG CW 40",{"$f":"IFERROR(VLOOKUP(L48,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005439},"LINELIGHT 1800-927 L1810 CW SR","Create code in MyProduct VIVA"]
["ORELLE PRO L18 1800-927 AS FG 40","LINELIGHT","LINELIGHT Stable white","1810mm",1800,927,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white1810mm927DiffuseNo Cowl","ORELLE PRO L18 1800-927 AS FG 40",{"$f":"IFERROR(VLOOKUP(L49,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005440},"LINELIGHT 1800-927 L1810 SR","Create code in MyProduct VIVA"]
["ORELLE PRO L18 1800-930 AS FG CW 40","LINELIGHT","LINELIGHT Stable white","1810mm",1800,930,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white1810mm930DiffuseCowl","ORELLE PRO L18 1800-930 AS FG CW 40",{"$f":"IFERROR(VLOOKUP(L50,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005441},"LINELIGHT 1800-930 L1810 CW SR","Create code in MyProduct VIVA"]
["ORELLE PRO L18 1800-930 AS FG 40","LINELIGHT","LINELIGHT Stable white","1810mm",1800,930,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white1810mm930DiffuseNo Cowl","ORELLE PRO L18 1800-930 AS FG 40",{"$f":"IFERROR(VLOOKUP(L51,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005442},"LINELIGHT 1800-930 L1810 SR","Create code in MyProduct VIVA"]
["ORELLE PRO L01 100-DW AS FG CW 40","LINELIGHT","LINELIGHT Balanced white","160mm",100,"827-65","AS","Diffuse","Cowl",40,"LINELIGHT Balanced white160mm827-65DiffuseCowl","ORELLE PRO L01 100-DW AS FG CW 40",{"$f":"IFERROR(VLOOKUP(L52,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":"Contact acdc for SAP code"},"LINELIGHT 100-827-65 L160 CW SR",21013720]
["ORELLE PRO L01 100-DW AS FG 40","LINELIGHT","LINELIGHT Balanced white","160mm",100,"827-65","AS","Diffuse","No Cowl",40,"LINELIGHT Balanced white160mm827-65DiffuseNo Cowl","ORELLE PRO L01 100-DW AS FG 40",{"$f":"IFERROR(VLOOKUP(L53,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005494},"LINELIGHT 100-827-865 L160 SR",21013721]
["ORELLE PRO L03 200-DW AS FG CW 40","LINELIGHT","LINELIGHT Balanced white","310mm",200,"827-65","AS","Diffuse","Cowl",40,"LINELIGHT Balanced white310mm827-65DiffuseCowl","ORELLE PRO L03 200-DW AS FG CW 40",{"$f":"IFERROR(VLOOKUP(L54,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":"Contact acdc for SAP code"},"LINELIGHT 200-827-65 L310 CW SR",21013722]
["ORELLE PRO L03 200-DW AS FG 40","LINELIGHT","LINELIGHT Balanced white","310mm",200,"827-65","AS","Diffuse","No Cowl",40,"LINELIGHT Balanced white310mm827-65DiffuseNo Cowl","ORELLE PRO L03 200-DW AS FG 40",{"$f":"IFERROR(VLOOKUP(L55,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005496},"LINELIGHT 200-827-65 L310 SR",21013723]
["ORELLE PRO L06 400-DW AS FG CW 40","LINELIGHT","LINELIGHT Balanced white","610mm",400,"827-65","AS","Diffuse","Cowl",40,"LINELIGHT Balanced white610mm827-65DiffuseCowl","ORELLE PRO L06 400-DW AS FG CW 40",{"$f":"IFERROR(VLOOKUP(L56,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":"Contact acdc for SAP code"},"LINELIGHT 400-827-65 L610 CW SR",21013724]
["ORELLE PRO L06 400-DW AS FG 40","LINELIGHT","LINELIGHT Balanced white","610mm",400,"827-65","AS","Diffuse","No Cowl",40,"LINELIGHT Balanced white610mm827-65DiffuseNo Cowl","ORELLE PRO L06 400-DW AS FG 40",{"$f":"IFERROR(VLOOKUP(L57,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005498},"LINELIGHT 400-827-65 L610 SR",21013725]
["ORELLE PRO L09 600-DW AS FG CW 40","LINELIGHT","LINELIGHT Balanced white","910mm",600,"827-65","AS","Diffuse","Cowl",40,"LINELIGHT Balanced white910mm827-65DiffuseCowl","ORELLE PRO L09 600-DW AS FG CW 40",{"$f":"IFERROR(VLOOKUP(L58,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":"Contact acdc for SAP code"},"LINELIGHT 600-827-65 L910 CW SR",21013726]
["ORELLE PRO L09 600-DW AS FG 40","LINELIGHT","LINELIGHT Balanced white","910mm",600,"827-65","AS","Diffuse","No Cowl",40,"LINELIGHT Balanced white910mm827-65DiffuseNo Cowl","ORELLE PRO L09 600-DW AS FG 40",{"$f":"IFERROR(VLOOKUP(L59,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005500},"LINELIGHT 600-827-65 L910 SR",21013727]
["ORELLE PRO L18 1300-DW AS FG CW 40","LINELIGHT","LINELIGHT Balanced white","1810mm",1300,"827-65","AS","Diffuse","Cowl",40,"LINELIGHT Balanced white1810mm827-65DiffuseCowl","ORELLE PRO L18 1300-DW AS FG CW 40",{"$f":"IFERROR(VLOOKUP(L60,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":"Contact acdc for SAP code"},"LINELIGHT 1300-827-65 L1810 CW SR",21013728]
["ORELLE PRO L18 1300-DW AS FG 40","LINELIGHT","LINELIGHT Balanced white","1810mm",1300,"827-65","AS","Diffuse","No Cowl",40,"LINELIGHT Balanced white1810mm827-65DiffuseNo Cowl","ORELLE PRO L18 1300-DW AS FG 40",{"$f":"IFERROR(VLOOKUP(L61,Sheet4!B:C,2,0),\"Contact acdc for SAP code\")","v":21005502},"LINELIGHT 1300-827-65 L1810 SR",21013729]
["ORELLE PRO+ L01 380-827 AS FG CW 40","LINELIGHT","LINELIGHT Stable white (HO)","160mm",380,827,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white (HO)160mm827DiffuseCowl","ORELLE PRO+ L01 380-827 AS FG CW 40",21005443,"LINELIGHT 380-827 L160 CW SR",21013740]
["ORELLE PRO+ L01 380-827 AS FG 40","LINELIGHT","LINELIGHT Stable white (HO)","160mm",380,827,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white (HO)160mm827DiffuseNo Cowl","ORELLE PRO+ L01 380-827 AS FG 40",21005444,"LINELIGHT 380-827 L160 SR",21013741]
["ORELLE PRO+ L01 380-830 AS FG CW 40","LINELIGHT","LINELIGHT Stable white (HO)","160mm",380,830,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white (HO)160mm830DiffuseCowl","ORELLE PRO+ L01 380-830 AS FG CW 40",21005445,"LINELIGHT 380-830 L160 CW SR",21013710]
["ORELLE PRO+ L01 380-830 AS FG 40","LINELIGHT","LINELIGHT Stable white (HO)","160mm",380,830,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white (HO)160mm830DiffuseNo Cowl","ORELLE PRO+ L01 380-830 AS FG 40",21005446,"LINELIGHT 380-830 L160 SR",21013711]
["ORELLE PRO+ L01 380-842 AS FG CW 40","LINELIGHT","LINELIGHT Stable white (HO)","160mm",380,840,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white (HO)160mm840DiffuseCowl","ORELLE PRO+ L01 380-840 AS FG CW 40",21005447,0,"Create code in MyProduct VIVA"]
["ORELLE PRO+ L01 380-842 AS FG 40","LINELIGHT","LINELIGHT Stable white (HO)","160mm",380,840,"AS","Diffuse","No Cowl",40,{"$f":"CONCATENATE(C67,D67,F67,H67,I67)","v":"LINELIGHT Stable white (HO)160mm840DiffuseNo Cowl"},"ORELLE PRO+ L01 380-840 AS FG 40",21005448,0,"Create code in MyProduct VIVA"]
["ORELLE PRO+ L03 800-827 AS FG CW 40","LINELIGHT","LINELIGHT Stable white (HO)","310mm",800,827,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white (HO)310mm827DiffuseCowl","ORELLE PRO+ L03 800-827 AS FG CW 40",21005449,"LINELIGHT 800-827 L310 CW SR",21013742]
["ORELLE PRO+ L03 800-827 AS FG 40","LINELIGHT","LINELIGHT Stable white (HO)","310mm",800,827,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white (HO)310mm827DiffuseNo Cowl","ORELLE PRO+ L03 800-827 AS FG 40",21005450,"LINELIGHT 800-827 L310 SR",21013743]
["ORELLE PRO+ L03 800-830 AS FG CW 40","LINELIGHT","LINELIGHT Stable white (HO)","310mm",800,830,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white (HO)310mm830DiffuseCowl","ORELLE PRO+ L03 800-830 AS FG CW 40",21005451,"LINELIGHT 800-830 L310 CW SR",21013712]
["ORELLE PRO+ L03 800-830 AS FG 40","LINELIGHT","LINELIGHT Stable white (HO)","310mm",800,830,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white (HO)310mm830DiffuseNo Cowl","ORELLE PRO+ L03 800-830 AS FG 40",21005452,"LINELIGHT 800-830 L310 SR",21013713]
["ORELLE PRO+ L03 800-842 AS FG CW 40","LINELIGHT","LINELIGHT Stable white (HO)","310mm",800,840,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white (HO)310mm840DiffuseCowl","ORELLE PRO+ L03 800-840 AS FG CW 40",21005453,0,"Create code in MyProduct VIVA"]
["ORELLE PRO+ L03 800-842 AS FG 40","LINELIGHT","LINELIGHT Stable white (HO)","310mm",800,840,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white (HO)310mm840DiffuseNo Cowl","ORELLE PRO+ L03 800-840 AS FG 40",21005454,0,"Create code in MyProduct VIVA"]
["ORELLE PRO+ L06 1600-827 AS FG CW 40","LINELIGHT","LINELIGHT Stable white (HO)","610mm",1600,827,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white (HO)610mm827DiffuseCowl","ORELLE PRO+ L06 1600-827 AS FG CW 40",21005455,"LINELIGHT 1600-827 L610 CW SR",21013744]
["ORELLE PRO+ L06 1600-827 AS FG 40","LINELIGHT","LINELIGHT Stable white (HO)","610mm",1600,827,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white (HO)610mm827DiffuseNo Cowl","ORELLE PRO+ L06 1600-827 AS FG 40",21005456,"LINELIGHT 1600-827 L610 SR",21013745]
["ORELLE PRO+ L06 1600-830 AS FG CW 40","LINELIGHT","LINELIGHT Stable white (HO)","610mm",1600,830,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white (HO)610mm830DiffuseCowl","ORELLE PRO+ L06 1600-830 AS FG CW 40",21005457,"LINELIGHT 1600-830 L610 CW SR",21013714]
["ORELLE PRO+ L06 1600-830 AS FG 40","LINELIGHT","LINELIGHT Stable white (HO)","610mm",1600,830,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white (HO)610mm830DiffuseNo Cowl","ORELLE PRO+ L06 1600-830 AS FG 40",21005458,"LINELIGHT 1600-830 L610 SR",21013715]
["ORELLE PRO+ L06 1600-842 AS FG CW 40","LINELIGHT","LINELIGHT Stable white (HO)","610mm",1600,840,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white (HO)610mm840DiffuseCowl","ORELLE PRO+ L06 1600-840 AS FG CW 40",21005459,0,"Create code in MyProduct VIVA"]
["ORELLE PRO+ L06 1600-842 AS FG 40","LINELIGHT","LINELIGHT Stable white (HO)","610mm",1600,840,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white (HO)610mm840DiffuseNo Cowl","ORELLE PRO+ L06 1600-840 AS FG 40",21005460,0,"Create code in MyProduct VIVA"]
["ORELLE PRO+ L09 2400-827 AS FG CW 40","LINELIGHT","LINELIGHT Stable white (HO)","910mm",2400,827,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white (HO)910mm827DiffuseCowl","ORELLE PRO+ L09 2400-827 AS FG CW 40",21005461,"LINELIGHT 2400-827 L910 CW SR",21013746]
["ORELLE PRO+ L09 2400-827 AS FG 40","LINELIGHT","LINELIGHT Stable white (HO)","910mm",2400,827,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white (HO)910mm827DiffuseNo Cowl","ORELLE PRO+ L09 2400-827 AS FG 40",21005462,"LINELIGHT 2400-827 L910 SR",21013747]
["ORELLE PRO+ L09 2400-830 AS FG CW 40","LINELIGHT","LINELIGHT Stable white (HO)","910mm",2400,830,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white (HO)910mm830DiffuseCowl","ORELLE PRO+ L09 2400-830 AS FG CW 40",21005463,"LINELIGHT 2400-830 L910 CW SR",21013716]
["ORELLE PRO+ L09 2400-830 AS FG 40","LINELIGHT","LINELIGHT Stable white (HO)","910mm",2400,830,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white (HO)910mm830DiffuseNo Cowl","ORELLE PRO+ L09 2400-830 AS FG 40",21005464,"LINELIGHT 2400-830 L910 SR",21013717]
["ORELLE PRO+ L09 2400-842 AS FG CW 40","LINELIGHT","LINELIGHT Stable white (HO)","910mm",2400,840,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white (HO)910mm840DiffuseCowl","ORELLE PRO+ L09 2400-840 AS FG CW 40",21005465,0,"Create code in MyProduct VIVA"]
["ORELLE PRO+ L09 2400-842 AS FG 40","LINELIGHT","LINELIGHT Stable white (HO)","910mm",2400,840,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white (HO)910mm840DiffuseNo Cowl","ORELLE PRO+ L09 2400-840 AS FG 40",21005466,0,"Create code in MyProduct VIVA"]
["ORELLE PRO+ L18 4600-827 AS FG CW 40","LINELIGHT","LINELIGHT Stable white (HO)","1810mm",4600,827,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white (HO)1810mm827DiffuseCowl","ORELLE PRO+ L18 4600-827 AS FG CW 40",21005467,"LINELIGHT 4600-827 L1810 CW SR",21013748]
["ORELLE PRO+ L18 4600-827 AS FG 40","LINELIGHT","LINELIGHT Stable white (HO)","1810mm",4600,827,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white (HO)1810mm827DiffuseNo Cowl","ORELLE PRO+ L18 4600-827 AS FG 40",21005468,"LINELIGHT 4600-827 L1810 SR",21013749]
["ORELLE PRO+ L18 4600-830 AS FG CW 40","LINELIGHT","LINELIGHT Stable white (HO)","1810mm",4600,830,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white (HO)1810mm830DiffuseCowl","ORELLE PRO+ L18 4600-830 AS FG CW 40",21005469,"LINELIGHT 4600-830 L1810 CW SR",21013718]
["ORELLE PRO+ L18 4600-830 AS FG 40","LINELIGHT","LINELIGHT Stable white (HO)","1810mm",4600,830,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white (HO)1810mm830DiffuseNo Cowl","ORELLE PRO+ L18 4600-830 AS FG 40",21005470,"LINELIGHT 4600-830 L1810 SR",21013719]
["ORELLE PRO+ L18 4600-842 AS FG CW 40","LINELIGHT","LINELIGHT Stable white (HO)","1810mm",4600,840,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white (HO)1810mm840DiffuseCowl","ORELLE PRO+ L18 4600-840 AS FG CW 40",21005471,0,"Create code in MyProduct VIVA"]
["ORELLE PRO+ L18 4600-842 AS FG 40","LINELIGHT","LINELIGHT Stable white (HO)","1810mm",4600,840,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white (HO)1810mm840DiffuseNo Cowl","ORELLE PRO+ L18 4600-840 AS FG 40",21005472,0,"Create code in MyProduct VIVA"]
["ORELLE PRO+ L01 300-927 AS FG CW 40","LINELIGHT","LINELIGHT Stable white (HO)","160mm",300,927,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white (HO)160mm927DiffuseCowl","ORELLE PRO+ L01 300-927 AS FG CW 40",21005473,0,"Create code in MyProduct VIVA"]
["ORELLE PRO+ L01 300-927 AS FG 40","LINELIGHT","LINELIGHT Stable white (HO)","160mm",300,927,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white (HO)160mm927DiffuseNo Cowl","ORELLE PRO+ L01 300-927 AS FG 40",21005474,0,"Create code in MyProduct VIVA"]
["ORELLE PRO+ L01 300-930 AS FG CW 40","LINELIGHT","LINELIGHT Stable white (HO)","160mm",300,930,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white (HO)160mm930DiffuseCowl","ORELLE PRO+ L01 300-930 AS FG CW 40",21005475,0,"Create code in MyProduct VIVA"]
["ORELLE PRO+ L01 300-930 AS FG 40","LINELIGHT","LINELIGHT Stable white (HO)","160mm",300,930,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white (HO)160mm930DiffuseNo Cowl","ORELLE PRO+ L01 300-930 AS FG 40",21005476,0,"Create code in MyProduct VIVA"]
["ORELLE PRO+ L03 600-927 AS FG CW 40","LINELIGHT","LINELIGHT Stable white (HO)","310mm",600,927,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white (HO)310mm927DiffuseCowl","ORELLE PRO+ L03 600-927 AS FG CW 40",21005477,0,"Create code in MyProduct VIVA"]
["ORELLE PRO+ L03 600-927 AS FG 40","LINELIGHT","LINELIGHT Stable white (HO)","310mm",600,927,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white (HO)310mm927DiffuseNo Cowl","ORELLE PRO+ L03 600-927 AS FG 40",21005478,0,"Create code in MyProduct VIVA"]
["ORELLE PRO+ L03 600-930 AS FG CW 40","LINELIGHT","LINELIGHT Stable white (HO)","310mm",600,930,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white (HO)310mm930DiffuseCowl","ORELLE PRO+ L03 600-930 AS FG CW 40",21005479,0,"Create code in MyProduct VIVA"]
["ORELLE PRO+ L03 600-930 AS FG 40","LINELIGHT","LINELIGHT Stable white (HO)","310mm",600,930,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white (HO)310mm930DiffuseNo Cowl","ORELLE PRO+ L03 600-930 AS FG 40",21005480,0,"Create code in MyProduct VIVA"]
["ORELLE PRO+ L06 1200-927 AS FG CW 40","LINELIGHT","LINELIGHT Stable white (HO)","610mm",1200,927,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white (HO)610mm927DiffuseCowl","ORELLE PRO+ L06 1200-927 AS FG CW 40",21005481,0,"Create code in MyProduct VIVA"]
["ORELLE PRO+ L06 1200-927 AS FG 40","LINELIGHT","LINELIGHT Stable white (HO)","610mm",1200,927,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white (HO)610mm927DiffuseNo Cowl","ORELLE PRO+ L06 1200-927 AS FG 40",21005482,0,"Create code in MyProduct VIVA"]
["ORELLE PRO+ L06 1200-930 AS FG CW 40","LINELIGHT","LINELIGHT Stable white (HO)","610mm",1200,930,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white (HO)610mm930DiffuseCowl","ORELLE PRO+ L06 1200-930 AS FG CW 40",21005483,0,"Create code in MyProduct VIVA"]
["ORELLE PRO+ L06 1200-930 AS FG 40","LINELIGHT","LINELIGHT Stable white (HO)","610mm",1200,930,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white (HO)610mm930DiffuseNo Cowl","ORELLE PRO+ L06 1200-930 AS FG 40",21005484,0,"Create code in MyProduct VIVA"]
["ORELLE PRO+ L09 1900-927 AS FG CW 40","LINELIGHT","LINELIGHT Stable white (HO)","910mm",1900,927,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white (HO)910mm927DiffuseCowl","ORELLE PRO+ L09 1900-927 AS FG CW 40",21005485,0,"Create code in MyProduct VIVA"]
["ORELLE PRO+ L09 1900-927 AS FG 40","LINELIGHT","LINELIGHT Stable white (HO)","910mm",1900,927,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white (HO)910mm927DiffuseNo Cowl","ORELLE PRO+ L09 1900-927 AS FG 40",21005486,0,"Create code in MyProduct VIVA"]
["ORELLE PRO+ L09 1900-930 AS FG CW 40","LINELIGHT","LINELIGHT Stable white (HO)","910mm",1900,930,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white (HO)910mm930DiffuseCowl","ORELLE PRO+ L09 1900-930 AS FG CW 40",21005487,0,"Create code in MyProduct VIVA"]
["ORELLE PRO+ L09 1900-930 AS FG 40","LINELIGHT","LINELIGHT Stable white (HO)","910mm",1900,930,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white (HO)910mm930DiffuseNo Cowl","ORELLE PRO+ L09 1900-930 AS FG 40",21005488,0,"Create code in MyProduct VIVA"]
["ORELLE PRO+ L18 3800-927 AS FG CW 40","LINELIGHT","LINELIGHT Stable white (HO)","1810mm",3800,927,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white (HO)1810mm927DiffuseCowl","ORELLE PRO+ L18 3800-927 AS FG CW 40",21005489,0,"Create code in MyProduct VIVA"]
["ORELLE PRO+ L18 3800-927 AS FG 40","LINELIGHT","LINELIGHT Stable white (HO)","1810mm",3800,927,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white (HO)1810mm927DiffuseNo Cowl","ORELLE PRO+ L18 3800-927 AS FG 40",21005490,0,"Create code in MyProduct VIVA"]
["ORELLE PRO+ L18 3800-930 AS FG CW 40","LINELIGHT","LINELIGHT Stable white (HO)","1810mm",3800,930,"AS","Diffuse","Cowl",40,"LINELIGHT Stable white (HO)1810mm930DiffuseCowl","ORELLE PRO+ L18 3800-930 AS FG CW 40",21005491,0,"Create code in MyProduct VIVA"]
["ORELLE PRO+ L18 3800-930 AS FG 40","LINELIGHT","LINELIGHT Stable white (HO)","1810mm",3800,930,"AS","Diffuse","No Cowl",40,"LINELIGHT Stable white (HO)1810mm930DiffuseNo Cowl","ORELLE PRO+ L18 3800-930 AS FG 40",21005492,0,"Create code in MyProduct VIVA"]

{"sheet":"Sheet4","index":2,"n_rows":110,"n_cols":3,"rows_kept":110,"cut":false,"hidden":true,"merged":[]}
[21005393,"ORELLE PRO L01 180-827 AS FG CW 40",21005393]
[21005394,"ORELLE PRO L01 180-827 AS FG 40",21005394]
[21005395,"ORELLE PRO L01 180-830 AS FG CW 40",21005395]
[21005396,"ORELLE PRO L01 180-830 AS FG 40",21005396]
[21005397,"ORELLE PRO L01 180-842 AS FG CW 40",21005397]
[21005398,"ORELLE PRO L01 180-842 AS FG 40",21005398]
[21005399,"ORELLE PRO L03 400-827 AS FG CW 40",21005399]
[21005400,"ORELLE PRO L03 400-827 AS FG 40",21005400]
[21005401,"ORELLE PRO L03 400-830 AS FG CW 40",21005401]
[21005402,"ORELLE PRO L03 400-830 AS FG 40",21005402]
[21005403,"ORELLE PRO L03 400-842 AS FG CW 40",21005403]
[21005404,"ORELLE PRO L03 400-842 AS FG 40",21005404]
[21005405,"ORELLE PRO L06 700-827 AS FG CW 40",21005405]
[21005406,"ORELLE PRO L06 700-827 AS FG 40",21005406]
[21005407,"ORELLE PRO L06 700-830 AS FG CW 40",21005407]
[21005408,"ORELLE PRO L06 700-830 AS FG 40",21005408]
[21005409,"ORELLE PRO L06 700-842 AS FG CW 40",21005409]
[21005410,"ORELLE PRO L06 700-842 AS FG 40",21005410]
[21005411,"ORELLE PRO L09 1000-827 AS FG CW 40",21005411]
[21005412,"ORELLE PRO L09 1000-827 AS FG 40",21005412]
[21005413,"ORELLE PRO L09 1000-830 AS FG CW 40",21005413]
[21005414,"ORELLE PRO L09 1000-830 AS FG 40",21005414]
[21005415,"ORELLE PRO L09 1000-842 AS FG CW 40",21005415]
[21005416,"ORELLE PRO L09 1000-842 AS FG 40",21005416]
[21005417,"ORELLE PRO L18 2200-827 AS FG CW 40",21005417]
[21005418,"ORELLE PRO L18 2200-827 AS FG 40",21005418]
[21005419,"ORELLE PRO L18 2200-830 AS FG CW 40",21005419]
[21005420,"ORELLE PRO L18 2200-830 AS FG 40",21005420]
[21005421,"ORELLE PRO L18 2200-842 AS FG CW 40",21005421]
[21005422,"ORELLE PRO L18 2200-842 AS FG 40",21005422]
[21005423,"ORELLE PRO L01 140-927 AS FG CW 40",21005423]
[21005424,"ORELLE PRO L01 140-927 AS FG 40",21005424]
[21005425,"ORELLE PRO L01 140-930 AS FG CW 40",21005425]
[21005426,"ORELLE PRO L01 140-930 AS FG 40",21005426]
[21005427,"ORELLE PRO L03 300-927 AS FG CW 40",21005427]
[21005428,"ORELLE PRO L03 300-927 AS FG 40",21005428]
[21005429,"ORELLE PRO L03 300-930 AS FG CW 40",21005429]
[21005430,"ORELLE PRO L03 300-930 AS FG 40",21005430]
[21005431,"ORELLE PRO L06 600-927 AS FG CW 40",21005431]
[21005432,"ORELLE PRO L06 600-927 AS FG 40",21005432]
[21005433,"ORELLE PRO L06 600-930 AS FG CW 40",21005433]
[21005434,"ORELLE PRO L06 600-930 AS FG 40",21005434]
[21005435,"ORELLE PRO L09 900-927 AS FG CW 40",21005435]
[21005436,"ORELLE PRO L09 900-927 AS FG 40",21005436]
[21005437,"ORELLE PRO L09 900-930 AS FG CW 40",21005437]
[21005438,"ORELLE PRO L09 900-930 AS FG 40",21005438]
[21005439,"ORELLE PRO L18 1800-927 AS FG CW 40",21005439]
[21005440,"ORELLE PRO L18 1800-927 AS FG 40",21005440]
[21005441,"ORELLE PRO L18 1800-930 AS FG CW 40",21005441]
[21005442,"ORELLE PRO L18 1800-930 AS FG 40",21005442]
[21005443,"ORELLE PRO+ L01 380-827 AS FG CW 40",21005443]
[21005444,"ORELLE PRO+ L01 380-827 AS FG 40",21005444]
[21005445,"ORELLE PRO+ L01 380-830 AS FG CW 40",21005445]
[21005446,"ORELLE PRO+ L01 380-830 AS FG 40",21005446]
[21005447,"ORELLE PRO+ L01 380-842 AS FG CW 40",21005447]
[21005448,"ORELLE PRO+ L01 380-842 AS FG 40",21005448]
[21005449,"ORELLE PRO+ L03 800-827 AS FG CW 40",21005449]
[21005450,"ORELLE PRO+ L03 800-827 AS FG 40",21005450]
[21005451,"ORELLE PRO+ L03 800-830 AS FG CW 40",21005451]
[21005452,"ORELLE PRO+ L03 800-830 AS FG 40",21005452]
[21005453,"ORELLE PRO+ L03 800-842 AS FG CW 40",21005453]
[21005454,"ORELLE PRO+ L03 800-842 AS FG 40",21005454]
[21005455,"ORELLE PRO+ L06 1600-827 AS FG CW 40",21005455]
[21005456,"ORELLE PRO+ L06 1600-827 AS FG 40",21005456]
[21005457,"ORELLE PRO+ L06 1600-830 AS FG CW 40",21005457]
[21005458,"ORELLE PRO+ L06 1600-830 AS FG 40",21005458]
[21005459,"ORELLE PRO+ L06 1600-842 AS FG CW 40",21005459]
[21005460,"ORELLE PRO+ L06 1600-842 AS FG 40",21005460]
[21005461,"ORELLE PRO+ L09 2400-827 AS FG CW 40",21005461]
[21005462,"ORELLE PRO+ L09 2400-827 AS FG 40",21005462]
[21005463,"ORELLE PRO+ L09 2400-830 AS FG CW 40",21005463]
[21005464,"ORELLE PRO+ L09 2400-830 AS FG 40",21005464]
[21005465,"ORELLE PRO+ L09 2400-842 AS FG CW 40",21005465]
[21005466,"ORELLE PRO+ L09 2400-842 AS FG 40",21005466]
[21005467,"ORELLE PRO+ L18 4600-827 AS FG CW 40",21005467]
[21005468,"ORELLE PRO+ L18 4600-827 AS FG 40",21005468]
[21005469,"ORELLE PRO+ L18 4600-830 AS FG CW 40",21005469]
[21005470,"ORELLE PRO+ L18 4600-830 AS FG 40",21005470]
[21005471,"ORELLE PRO+ L18 4600-842 AS FG CW 40",21005471]
[21005472,"ORELLE PRO+ L18 4600-842 AS FG 40",21005472]
[21005473,"ORELLE PRO+ L01 300-927 AS FG CW 40",21005473]
[21005474,"ORELLE PRO+ L01 300-927 AS FG 40",21005474]
[21005475,"ORELLE PRO+ L01 300-930 AS FG CW 40",21005475]
[21005476,"ORELLE PRO+ L01 300-930 AS FG 40",21005476]
[21005477,"ORELLE PRO+ L03 600-927 AS FG CW 40",21005477]
[21005478,"ORELLE PRO+ L03 600-927 AS FG 40",21005478]
[21005479,"ORELLE PRO+ L03 600-930 AS FG CW 40",21005479]
[21005480,"ORELLE PRO+ L03 600-930 AS FG 40",21005480]
[21005481,"ORELLE PRO+ L06 1200-927 AS FG CW 40",21005481]
[21005482,"ORELLE PRO+ L06 1200-927 AS FG 40",21005482]
[21005483,"ORELLE PRO+ L06 1200-930 AS FG CW 40",21005483]
[21005484,"ORELLE PRO+ L06 1200-930 AS FG 40",21005484]
[21005485,"ORELLE PRO+ L09 1900-927 AS FG CW 40",21005485]
[21005486,"ORELLE PRO+ L09 1900-927 AS FG 40",21005486]
[21005487,"ORELLE PRO+ L09 1900-930 AS FG CW 40",21005487]
[21005488,"ORELLE PRO+ L09 1900-930 AS FG 40",21005488]
[21005489,"ORELLE PRO+ L18 3800-927 AS FG CW 40",21005489]
[21005490,"ORELLE PRO+ L18 3800-927 AS FG 40",21005490]
[21005491,"ORELLE PRO+ L18 3800-930 AS FG CW 40",21005491]
[21005492,"ORELLE PRO+ L18 3800-930 AS FG 40",21005492]
[21005493,"ORELLE PRO L01 100-DW AS FG CW IP4",21005493]
[21005494,"ORELLE PRO L01 100-DW AS FG 40",21005494]
[21005495,"ORELLE PRO L03 200-DW AS FG CW IP4",21005495]
[21005496,"ORELLE PRO L03 200-DW AS FG 40",21005496]
[21005497,"ORELLE PRO L06 400-DW AS FG CW IP4",21005497]
[21005498,"ORELLE PRO L06 400-DW AS FG 40",21005498]
[21005499,"ORELLE PRO L09 600-DW AS FG CW IP4",21005499]
[21005500,"ORELLE PRO L09 600-DW AS FG 40",21005500]
[21005501,"ORELLE PRO L18 1300-DW AS GF CW IP4",21005501]
[21005502,"ORELLE PRO L18 1300-DW AS FG 40",21005502]

{"sheet":"LINELIGHT Spec Builder","index":3,"n_rows":53,"n_cols":36,"rows_kept":53,"cut":false,"hidden":false,"merged":[[49,26,49,28],[50,26,50,28],[51,26,51,28],[52,26,52,28],[3,1,3,34],[6,1,9,1],[15,1,18,1],[24,1,27,1],[33,1,36,1],[44,26,44,28],[45,26,45,28],[46,26,46,28],[47,26,47,28],[48,26,48,28]]}
[]
[]
[]
[null,"Instructions for use: 1. Enter cove length. 2. Choose type of LINELIGHT from drop down list. 3. Choose dimming protocol from drop down list. 4. Choose fitting specific options (CRI/LED colour and whether a cowl is needed) from drop down lists."]
[]
[null,"Cove Length (m)","Cove Length 1 (m)",1.81,"Number of fittings","Length of 1800mm fittings","Remaining m",0.91,"Number of fittings","Length of 900mm fittings","Remaining m",0.61,"Number of fittings","Length of 600mm fittings","Remaining m",0.31,"Number of fittings","Length of 300mm fittings","Remaining m",0.16,"Number of fittings","Length of 150mm fittings","Remaining m",null,"Type of LINELIGHT",null,"Quantity of 1810mm",null,"Quantity of 910mm","Quantity of 610mm",null,"Quantity of 310mm","Quantity of 160mm",null,"Total Length (m)"]
[null,0,{"$f":"B7","v":0},{"$f":"C7/D6","v":0},{"$f":"ROUNDDOWN(D7,0)","v":0},{"$f":"E7*D6","v":0},{"$f":"C7-F7","v":0},{"$f":"G7/H6","v":0},{"$f":"ROUNDDOWN(H7,0)","v":0},{"$f":"I7*H6","v":0},{"$f":"G7-J7","v":0},{"$f":"K7/L6","v":0},{"$f":"ROUNDDOWN(L7,0)","v":0},{"$f":"M7*L6","v":0},{"$f":"K7-N7","v":0},{"$f":"O7/P6","v":0},{"$f":"ROUNDDOWN(P7,0)","v":0},{"$f":"Q7*P6","v":0},{"$f":"O7-R7","v":0},{"$f":"S7/T6","v":0},{"$f":"ROUNDDOWN(T7,0)","v":0},{"$f":"U7*T6","v":0},{"$f":"S7-V7","v":0},null,"Please select from list",{"$f":"VLOOKUP(Y7,Sheet2!D20:E22,2,0)","v":{"$error":"#N/A"}},{"$f":"E7","v":0},null,{"$f":"I7","v":0},{"$f":"M7","v":0},null,{"$f":"Q7","v":0},{"$f":"U7","v":0},null,{"$f":"F7+J7+N7+R7+V7","v":0}]
[null,null,null,18,"Number of drivers 350W","Metre run by 350W","Remaining m",11,"Number of drivers 175W","Metre run by 175W","Remaining m",4,"Number of drivers 70W"]
[null,null,"LINELIGHT Stable white",{"$f":"C7/D8","v":0},{"$f":"ROUND(D9,0)","v":0},{"$f":"E9*D8","v":0},{"$f":"C7-F9","v":0},{"$f":"IF(G9>0,G9/H8,\"0\")","v":"0"},{"$f":"ROUND(H9,0)","v":0},{"$f":"I9*H8","v":0},{"$f":"G9-J9","v":0},{"$f":"IF(K9>0,K9/L8,\"0\")","v":"0"},{"$f":"ROUNDUP(L9,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Dimming Protocol",null,"Quantity of 320W drivers",null,"Driver and SAP code","Quantity of 175W drivers",null,"Driver and SAP code","Quantity of 70W drivers",null,"Driver and SAP code"]
[null,null,null,8,"Number of drivers 350W","Metre run by 350W","Remaining m",4,"Number of drivers 175W","Metre run by 175W","Remaining m",1.8,"Number of drivers 70W",null,null,null,null,null,null,null,null,null,null,null,"Choose dimming protocol",{"$f":"VLOOKUP(Y7,Sheet2!D20:F22,3,0)","v":{"$error":"#N/A"}},{"$f":"IF(Y7=C9,E9,IF(Y7=C11,E11,IF(Y7=C13,E13,\"Please check options\")))","v":"Please check options"},{"$f":"CONCATENATE(Y7,\"/\",Y10,\"/\",\"320W\")","v":"Please select from list/Choose dimming protocol/320W"},{"$f":"IFERROR(VLOOKUP(AB10,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"},{"$f":"IF(Y7=C9,I9,IF(Y7=C11,I11,IF(Y7=C13,I13,\"Please check options\")))","v":"Please check options"},{"$f":"CONCATENATE(Y7,\"/\",Y10,\"/\",\"175W\")","v":"Please select from list/Choose dimming protocol/175W"},{"$f":"IFERROR(VLOOKUP(AE10,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"},{"$f":"IF(Y7=C9,M9,IF(Y7=C11,M11,IF(Y7=C13,M13,\"Please check options\")))","v":"Please check options"},{"$f":"CONCATENATE(Y7,\"/\",Y10,\"/\",\"70W\")","v":"Please select from list/Choose dimming protocol/70W"},{"$f":"IFERROR(VLOOKUP(AH10,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"}]
[null,null,"LINELIGHT Balanced white",{"$f":"C7/D10","v":0},{"$f":"ROUND(D11,0)","v":0},{"$f":"E11*D10","v":0},{"$f":"C7-F11","v":0},{"$f":"IF(G11>0,G11/H10,\"0\")","v":"0"},{"$f":"ROUND(H11,0)","v":0},{"$f":"I11*H10","v":0},{"$f":"G11-J11","v":0},{"$f":"IF(K11>0,K11/L10,\"0\")","v":"0"},{"$f":"ROUNDUP(L11,0)","v":0}]
[null,null,null,6,"Number of drivers 350W","Metre run by 350W","Remaining m",4,"Number of drivers 175W","Metre run by 175W","Remaining m",1,"Number of drivers 70W",null,null,null,null,null,null,null,null,null,null,null,"Please select from list"]
[null,null,"LINELIGHT Stable white (EB)",{"$f":"C7/D12","v":0},{"$f":"ROUND(D13,0)","v":0},{"$f":"E13*D12","v":0},{"$f":"C7-F13","v":0},{"$f":"IF(G13>0,G13/H12,\"0\")","v":"0"},{"$f":"ROUND(H13,0)","v":0},{"$f":"I13*H12","v":0},{"$f":"G13-J13","v":0},{"$f":"IF(K13>0,K13/L12,\"0\")","v":"0"},{"$f":"ROUNDUP(L13,0)","v":0}]
[]
[null,"Cove Length 2 (m)","Cove Length 2 (m)",1.81,"Number of fittings","Length of 1800mm fittings","Remaining m",0.91,"Number of fittings","Length of 900mm fittings","Remaining m",0.61,"Number of fittings","Length of 600mm fittings","Remaining m",0.31,"Number of fittings","Length of 300mm fittings","Remaining m",0.16,"Number of fittings","Length of 150mm fittings","Remaining m",null,"Type of Orelle",null,"Quantity of 1800mm",null,"Quantity of 900mm","Quantity of 600mm",null,"Quantity of 300mm","Quantity of 150mm",null,"Total Length (m)"]
[null,0,{"$f":"B16","v":0},{"$f":"C16/D15","v":0},{"$f":"ROUNDDOWN(D16,0)","v":0},{"$f":"E16*D15","v":0},{"$f":"C16-F16","v":0},{"$f":"G16/H15","v":0},{"$f":"ROUNDDOWN(H16,0)","v":0},{"$f":"I16*H15","v":0},{"$f":"G16-J16","v":0},{"$f":"K16/L15","v":0},{"$f":"ROUNDDOWN(L16,0)","v":0},{"$f":"M16*L15","v":0},{"$f":"K16-N16","v":0},{"$f":"O16/P15","v":0},{"$f":"ROUNDDOWN(P16,0)","v":0},{"$f":"Q16*P15","v":0},{"$f":"O16-R16","v":0},{"$f":"S16/T15","v":0},{"$f":"ROUNDDOWN(T16,0)","v":0},{"$f":"U16*T15","v":0},{"$f":"S16-V16","v":0},null,"Orelle Pro Single Colour (SB)",null,{"$f":"E16","v":0},null,{"$f":"I16","v":0},{"$f":"M16","v":0},null,{"$f":"Q16","v":0},{"$f":"U16","v":0},null,{"$f":"F16+J16+N16+R16+V16","v":0}]
[null,null,null,18,"Number of drivers 350W","Metre run by 350W","Remaining m",11,"Number of drivers 175W","Metre run by 175W","Remaining m",4,"Number of drivers 70W"]
[null,null,"Orelle Pro Single Colour (SB)",{"$f":"C16/D17","v":0},{"$f":"ROUND(D18,0)","v":0},{"$f":"E18*D17","v":0},{"$f":"C16-F18","v":0},{"$f":"IF(G18>0,G18/H17,\"0\")","v":"0"},{"$f":"ROUND(H18,0)","v":0},{"$f":"I18*H17","v":0},{"$f":"G18-J18","v":0},{"$f":"IF(K18>0,K18/L17,\"0\")","v":"0"},{"$f":"ROUNDUP(L18,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Dimming protocol",null,"Quantity of 320W drivers",null,"Driver and SAP code","Quantity of 175W drivers",null,"Driver and SAP code","Quantity of 70W drivers",null,"Driver and SAP code"]
[null,null,null,8,"Number of drivers 350W","Metre run by 350W","Remaining m",4,"Number of drivers 175W","Metre run by 175W","Remaining m",1.8,"Number of drivers 70W",null,null,null,null,null,null,null,null,null,null,null,"Non-Dimmable/HF",null,{"$f":"IF(Y16=C18,E18,IF(Y16=C20,E20,IF(Y16=C22,E22,\"Please check options\")))","v":0},{"$f":"CONCATENATE(Y16,\"/\",Y19,\"/\",\"320W\")","v":"Orelle Pro Single Colour (SB)/Non-Dimmable/HF/320W"},{"$f":"IFERROR(VLOOKUP(AB19,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"},{"$f":"IF(Y16=C18,I18,IF(Y16=C20,I20,IF(Y16=C22,I22,\"Please check options\")))","v":0},{"$f":"CONCATENATE(Y16,\"/\",Y19,\"/\",\"175W\")","v":"Orelle Pro Single Colour (SB)/Non-Dimmable/HF/175W"},{"$f":"IFERROR(VLOOKUP(AE19,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"},{"$f":"IF(Y16=C18,M18,IF(Y16=C20,M20,IF(Y16=C22,M22,\"Please check options\")))","v":0},{"$f":"CONCATENATE(Y16,\"/\",Y19,\"/\",\"70W\")","v":"Orelle Pro Single Colour (SB)/Non-Dimmable/HF/70W"},{"$f":"IFERROR(VLOOKUP(AH19,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"}]
[null,null,"Orelle Pro Dynamic White",{"$f":"C16/D19","v":0},{"$f":"ROUND(D20,0)","v":0},{"$f":"E20*D19","v":0},{"$f":"C16-F20","v":0},{"$f":"IF(G20>0,G20/H19,\"0\")","v":"0"},{"$f":"ROUND(H20,0)","v":0},{"$f":"I20*H19","v":0},{"$f":"G20-J20","v":0},{"$f":"IF(K20>0,K20/L19,\"0\")","v":"0"},{"$f":"ROUNDUP(L20,0)","v":0}]
[null,null,null,6,"Number of drivers 350W","Metre run by 350W","Remaining m",4,"Number of drivers 175W","Metre run by 175W","Remaining m",1,"Number of drivers 70W"]
[null,null,"Orelle Pro+ Single Colour (EB)",{"$f":"C16/D21","v":0},{"$f":"ROUND(D22,0)","v":0},{"$f":"E22*D21","v":0},{"$f":"C16-F22","v":0},{"$f":"IF(G22>0,G22/H21,\"0\")","v":"0"},{"$f":"ROUND(H22,0)","v":0},{"$f":"I22*H21","v":0},{"$f":"G22-J22","v":0},{"$f":"IF(K22>0,K22/L21,\"0\")","v":"0"},{"$f":"ROUNDUP(L22,0)","v":0}]
[]
[null,"Cove Length 3 (m)","Cove Length 3 (m)",1.81,"Number of fittings","Length of 1800mm fittings","Remaining m",0.91,"Number of fittings","Length of 900mm fittings","Remaining m",0.61,"Number of fittings","Length of 600mm fittings","Remaining m",0.31,"Number of fittings","Length of 300mm fittings","Remaining m",0.16,"Number of fittings","Length of 150mm fittings","Remaining m",null,"Type of Orelle",null,"Quantity of 1800mm",null,"Quantity of 900mm","Quantity of 600mm",null,"Quantity of 300mm","Quantity of 150mm",null,"Total Length (m)"]
[null,0,{"$f":"B25","v":0},{"$f":"C25/D24","v":0},{"$f":"ROUNDDOWN(D25,0)","v":0},{"$f":"E25*D24","v":0},{"$f":"C25-F25","v":0},{"$f":"G25/H24","v":0},{"$f":"ROUNDDOWN(H25,0)","v":0},{"$f":"I25*H24","v":0},{"$f":"G25-J25","v":0},{"$f":"K25/L24","v":0},{"$f":"ROUNDDOWN(L25,0)","v":0},{"$f":"M25*L24","v":0},{"$f":"K25-N25","v":0},{"$f":"O25/P24","v":0},{"$f":"ROUNDDOWN(P25,0)","v":0},{"$f":"Q25*P24","v":0},{"$f":"O25-R25","v":0},{"$f":"S25/T24","v":0},{"$f":"ROUNDDOWN(T25,0)","v":0},{"$f":"U25*T24","v":0},{"$f":"S25-V25","v":0},null,"Orelle Pro Single Colour (SB)",null,{"$f":"E25","v":0},null,{"$f":"I25","v":0},{"$f":"M25","v":0},null,{"$f":"Q25","v":0},{"$f":"U25","v":0},null,{"$f":"F25+J25+N25+R25+V25","v":0}]
[null,null,null,18,"Number of drivers 350W","Metre run by 350W","Remaining m",11,"Number of drivers 175W","Metre run by 175W","Remaining m",4,"Number of drivers 70W"]
[null,null,"Orelle Pro Single Colour (SB)",{"$f":"C25/D26","v":0},{"$f":"ROUND(D27,0)","v":0},{"$f":"E27*D26","v":0},{"$f":"C25-F27","v":0},{"$f":"IF(G27>0,G27/H26,\"0\")","v":"0"},{"$f":"ROUND(H27,0)","v":0},{"$f":"I27*H26","v":0},{"$f":"G27-J27","v":0},{"$f":"IF(K27>0,K27/L26,\"0\")","v":"0"},{"$f":"ROUNDUP(L27,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Dimming protocol",null,"Quantity of 320W drivers",null,"Driver and SAP code","Quantity of 175W drivers",null,"Driver and SAP code","Quantity of 70W drivers",null,"Driver and SAP code"]
[null,null,null,8,"Number of drivers 350W","Metre run by 350W","Remaining m",4,"Number of drivers 175W","Metre run by 175W","Remaining m",1.8,"Number of drivers 70W",null,null,null,null,null,null,null,null,null,null,null,"Non-Dimmable/HF",null,{"$f":"IF(Y25=C27,E27,IF(Y25=C29,E29,IF(Y25=C31,E31,\"Please check options\")))","v":0},{"$f":"CONCATENATE(Y25,\"/\",Y28,\"/\",\"320W\")","v":"Orelle Pro Single Colour (SB)/Non-Dimmable/HF/320W"},{"$f":"IFERROR(VLOOKUP(AB28,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"},{"$f":"IF(Y25=C27,I27,IF(Y25=C29,I29,IF(Y25=C31,I31,\"Please check options\")))","v":0},{"$f":"CONCATENATE(Y25,\"/\",Y28,\"/\",\"175W\")","v":"Orelle Pro Single Colour (SB)/Non-Dimmable/HF/175W"},{"$f":"IFERROR(VLOOKUP(AE28,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"},{"$f":"IF(Y25=C27,M27,IF(Y25=C29,M29,IF(Y25=C31,M31,\"Please check options\")))","v":0},{"$f":"CONCATENATE(Y25,\"/\",Y28,\"/\",\"70W\")","v":"Orelle Pro Single Colour (SB)/Non-Dimmable/HF/70W"},{"$f":"IFERROR(VLOOKUP(AH28,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"}]
[null,null,"Orelle Pro Dynamic White",{"$f":"C25/D28","v":0},{"$f":"ROUND(D29,0)","v":0},{"$f":"E29*D28","v":0},{"$f":"C25-F29","v":0},{"$f":"IF(G29>0,G29/H28,\"0\")","v":"0"},{"$f":"ROUND(H29,0)","v":0},{"$f":"I29*H28","v":0},{"$f":"G29-J29","v":0},{"$f":"IF(K29>0,K29/L28,\"0\")","v":"0"},{"$f":"ROUNDUP(L29,0)","v":0}]
[null,null,null,6,"Number of drivers 350W","Metre run by 350W","Remaining m",4,"Number of drivers 175W","Metre run by 175W","Remaining m",1,"Number of drivers 70W"]
[null,null,"Orelle Pro+ Single Colour (EB)",{"$f":"C25/D30","v":0},{"$f":"ROUND(D31,0)","v":0},{"$f":"E31*D30","v":0},{"$f":"C25-F31","v":0},{"$f":"IF(G31>0,G31/H30,\"0\")","v":"0"},{"$f":"ROUND(H31,0)","v":0},{"$f":"I31*H30","v":0},{"$f":"G31-J31","v":0},{"$f":"IF(K31>0,K31/L30,\"0\")","v":"0"},{"$f":"ROUNDUP(L31,0)","v":0}]
[]
[null,"Cove Length 4 (m)","Cove Length 4 (m)",1.81,"Number of fittings","Length of 1800mm fittings","Remaining m",0.91,"Number of fittings","Length of 900mm fittings","Remaining m",0.61,"Number of fittings","Length of 600mm fittings","Remaining m",0.31,"Number of fittings","Length of 300mm fittings","Remaining m",0.16,"Number of fittings","Length of 150mm fittings","Remaining m",null,"Type of Orelle",null,"Quantity of 1800mm",null,"Quantity of 900mm","Quantity of 600mm",null,"Quantity of 300mm","Quantity of 150mm",null,"Total Length (m)"]
[null,0,{"$f":"B34","v":0},{"$f":"C34/D33","v":0},{"$f":"ROUNDDOWN(D34,0)","v":0},{"$f":"E34*D33","v":0},{"$f":"C34-F34","v":0},{"$f":"G34/H33","v":0},{"$f":"ROUNDDOWN(H34,0)","v":0},{"$f":"I34*H33","v":0},{"$f":"G34-J34","v":0},{"$f":"K34/L33","v":0},{"$f":"ROUNDDOWN(L34,0)","v":0},{"$f":"M34*L33","v":0},{"$f":"K34-N34","v":0},{"$f":"O34/P33","v":0},{"$f":"ROUNDDOWN(P34,0)","v":0},{"$f":"Q34*P33","v":0},{"$f":"O34-R34","v":0},{"$f":"S34/T33","v":0},{"$f":"ROUNDDOWN(T34,0)","v":0},{"$f":"U34*T33","v":0},{"$f":"S34-V34","v":0},null,"Orelle Pro Single Colour (SB)",null,{"$f":"E34","v":0},null,{"$f":"I34","v":0},{"$f":"M34","v":0},null,{"$f":"Q34","v":0},{"$f":"U34","v":0},null,{"$f":"F34+J34+N34+R34+V34","v":0}]
[null,null,null,18,"Number of drivers 350W","Metre run by 350W","Remaining m",11,"Number of drivers 175W","Metre run by 175W","Remaining m",4,"Number of drivers 70W"]
[null,null,"Orelle Pro Single Colour (SB)",{"$f":"C34/D35","v":0},{"$f":"ROUND(D36,0)","v":0},{"$f":"E36*D35","v":0},{"$f":"C34-F36","v":0},{"$f":"IF(G36>0,G36/H35,\"0\")","v":"0"},{"$f":"ROUND(H36,0)","v":0},{"$f":"I36*H35","v":0},{"$f":"G36-J36","v":0},{"$f":"IF(K36>0,K36/L35,\"0\")","v":"0"},{"$f":"ROUNDUP(L36,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Dimming protocol",null,"Quantity of 320W drivers",null,"Driver and SAP code","Quantity of 175W drivers",null,"Driver and SAP code","Quantity of 70W drivers",null,"Driver and SAP code"]
[null,null,null,8,"Number of drivers 350W","Metre run by 350W","Remaining m",4,"Number of drivers 175W","Metre run by 175W","Remaining m",1.8,"Number of drivers 70W",null,null,null,null,null,null,null,null,null,null,null,"Non-Dimmable/HF",null,{"$f":"IF(Y34=C36,E36,IF(Y34=C38,E38,IF(Y34=C40,E40,\"Please check options\")))","v":0},{"$f":"CONCATENATE(Y34,\"/\",Y37,\"/\",\"320W\")","v":"Orelle Pro Single Colour (SB)/Non-Dimmable/HF/320W"},{"$f":"IFERROR(VLOOKUP(AB37,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"},{"$f":"IF(Y34=C36,I36,IF(Y34=C38,I38,IF(Y34=C40,I40,\"Please check options\")))","v":0},{"$f":"CONCATENATE(Y34,\"/\",Y37,\"/\",\"175W\")","v":"Orelle Pro Single Colour (SB)/Non-Dimmable/HF/175W"},{"$f":"IFERROR(VLOOKUP(AE37,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"},{"$f":"IF(Y34=C36,M36,IF(Y34=C38,M38,IF(Y34=C40,M40,\"Please check options\")))","v":0},{"$f":"CONCATENATE(Y34,\"/\",Y37,\"/\",\"70W\")","v":"Orelle Pro Single Colour (SB)/Non-Dimmable/HF/70W"},{"$f":"IFERROR(VLOOKUP(AH37,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"}]
[null,null,"Orelle Pro Dynamic White",{"$f":"C34/D37","v":0},{"$f":"ROUND(D38,0)","v":0},{"$f":"E38*D37","v":0},{"$f":"C34-F38","v":0},{"$f":"IF(G38>0,G38/H37,\"0\")","v":"0"},{"$f":"ROUND(H38,0)","v":0},{"$f":"I38*H37","v":0},{"$f":"G38-J38","v":0},{"$f":"IF(K38>0,K38/L37,\"0\")","v":"0"},{"$f":"ROUNDUP(L38,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Type","Length","CRI/LED Colour","Lens Type",null,"Cowl",null,null,null,"Article Number"]
[null,null,null,6,"Number of drivers 350W","Metre run by 350W","Remaining m",4,"Number of drivers 175W","Metre run by 175W","Remaining m",1,"Number of drivers 70W",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Y$7=\"Please select from list\",\"Please select from list above\",$Y$7)","v":"Please select from list above"},"1810mm","Please select from list","Diffuse",null,"Please select from list",null,{"$f":"CONCATENATE(AA39,AB39,AC39,AD39,AF39)","v":"Please select from list above1810mmPlease select from listDiffusePlease select from list"},null,{"$f":"IFERROR(VLOOKUP(AH39,Sheet3!K:O,5,0),\"Please check options\")","v":"Please check options"}]
[null,null,"Orelle Pro+ Single Colour (EB)",{"$f":"C34/D39","v":0},{"$f":"ROUND(D40,0)","v":0},{"$f":"E40*D39","v":0},{"$f":"C34-F40","v":0},{"$f":"IF(G40>0,G40/H39,\"0\")","v":"0"},{"$f":"ROUND(H40,0)","v":0},{"$f":"I40*H39","v":0},{"$f":"G40-J40","v":0},{"$f":"IF(K40>0,K40/L39,\"0\")","v":"0"},{"$f":"ROUNDUP(L40,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Y$7=\"Please select from list\",\"Please select from list above\",$Y$7)","v":"Please select from list above"},"910mm",{"$f":"$AC$39","v":"Please select from list"},{"$f":"$AD$39","v":"Diffuse"},null,{"$f":"$AF$39","v":"Please select from list"},null,{"$f":"CONCATENATE(AA40,AB40,AC40,AD40,AF40)","v":"Please select from list above910mmPlease select from listDiffusePlease select from list"},null,{"$f":"IFERROR(VLOOKUP(AH40,Sheet3!K:O,5,0),\"Please check options\")","v":"Please check options"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Y$7=\"Please select from list\",\"Please select from list above\",$Y$7)","v":"Please select from list above"},"610mm",{"$f":"$AC$39","v":"Please select from list"},{"$f":"$AD$39","v":"Diffuse"},null,{"$f":"$AF$39","v":"Please select from list"},null,{"$f":"CONCATENATE(AA41,AB41,AC41,AD41,AF41)","v":"Please select from list above610mmPlease select from listDiffusePlease select from list"},null,{"$f":"IFERROR(VLOOKUP(AH41,Sheet3!K:O,5,0),\"Please check options\")","v":"Please check options"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Y$7=\"Please select from list\",\"Please select from list above\",$Y$7)","v":"Please select from list above"},"310mm","Please select from list",{"$f":"$AD$39","v":"Diffuse"},null,{"$f":"$AF$39","v":"Please select from list"},null,{"$f":"CONCATENATE(AA42,AB42,AC42,AD42,AF42)","v":"Please select from list above310mmPlease select from listDiffusePlease select from list"},null,{"$f":"IFERROR(VLOOKUP(AH42,Sheet3!K:O,5,0),\"Please check options\")","v":"Please check options"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Y$7=\"Please select from list\",\"Please select from list above\",$Y$7)","v":"Please select from list above"},"160mm","Please select from list",{"$f":"$AD$39","v":"Diffuse"},null,{"$f":"$AF$39","v":"Please select from list"},null,{"$f":"CONCATENATE(AA43,AB43,AC43,AD43,AF43)","v":"Please select from list above160mmPlease select from listDiffusePlease select from list"},null,{"$f":"IFERROR(VLOOKUP(AH43,Sheet3!K:O,5,0),\"Please check options\")","v":"Please check options"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cove Summary",null,null,"Quantity",null,"Article Number"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"Please select from list\",CONCATENATE(AA39,\", \",AB39,\", \",AC39,\", \",AD39,\" Lens \",AF39))),\"Please check options\",CONCATENATE(AA39,\", \",AB39,\", \",AC39,\", \",AD39,\" Lens, \",AF39))","v":"Please check options"},null,null,{"$f":"AA7","v":0},null,{"$f":"IF(AD46=0,\"\",(IF(AJ39=\"Please check options\",\"\",AJ39)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"Please select from list\",CONCATENATE(AA40,\", \",AB40,\", \",AC40,\", \",AD40,\" Lens \",AF40))),\"Please check options\",CONCATENATE(AA40,\", \",AB40,\", \",AC40,\", \",AD40,\" Lens, \",AF40))","v":"Please check options"},null,null,{"$f":"AC7","v":0},null,{"$f":"IF(AD47=0,\"\",(IF(AJ40=\"Please check options\",\"\",AJ40)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please check options",null,null,{"$f":"AD7","v":0},null,{"$f":"IF(AD48=0,\"\",(IF(AJ41=\"Please check options\",\"\",AJ41)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"Please select from list\",CONCATENATE(AA42,\", \",AB42,\", \",AC42,\", \",AD42,\" Lens \",AF42))),\"Please check options\",CONCATENATE(AA42,\", \",AB42,\", \",AC42,\", \",AD42,\" Lens, \",AF42))","v":"Please check options"},null,null,{"$f":"AF7","v":0},null,{"$f":"IF(AD49=0,\"\",(IF(AJ42=\"Please check options\",\"\",AJ42)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please check options",null,null,{"$f":"AG7","v":0},null,{"$f":"IF(AD50=0,\"\",(IF(AJ43=\"Please check options\",\"\",AJ43)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEFT(AC10,LEN(AC10)-11)=\"Please ch\",\"Please check options\",LEFT(AC10,LEN(AC10)-11))","v":"Please check options"},null,null,{"$f":"IF(AA10=\"Please check options\",\"0\",AA10)","v":"0"},null,{"$f":"IF(AD51=0,\"\",(IF(RIGHT(AC10,8)=\" options\",\"\",RIGHT(AC10,8))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEFT(AF10,LEN(AF10)-11)=\"Please ch\",\"Please check options\",LEFT(AF10,LEN(AF10)-11))","v":"Please check options"},null,null,{"$f":"IF(AD10=\"Please check options\",\"0\",AD10)","v":"0"},null,{"$f":"IF(AD52=0,\"\",(IF(RIGHT(AF10,8)=\" options\",\"\",RIGHT(AF10,8))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEFT(AI10,LEN(AI10)-11)=\"Please ch\",\"Please check options\",LEFT(AI10,LEN(AI10)-11))","v":"Please check options"},null,null,{"$f":"IF(AG10=\"Please check options\",\"0\",AG10)","v":"0"},null,{"$f":"IF(AD53=0,\"\",(IF(RIGHT(AI10,8)=\" options\",\"\",RIGHT(AI10,8))))","v":""}]

{"sheet":"LINELIGHT Code Finder","index":4,"n_rows":56,"n_cols":36,"rows_kept":56,"cut":false,"hidden":false,"merged":[[9,1,12,1],[18,1,21,1],[27,1,30,1],[36,1,39,1],[47,26,47,28],[54,26,54,28],[55,26,55,28],[1,24,1,34],[48,26,48,28],[49,26,49,28],[50,26,50,28],[51,26,51,28],[52,26,52,28],[53,26,53,28]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions for use: 1. Choose type of LINELIGHT from drop down list. 2. Enter quantity of each length of fitting required. 3. Choose dimming protocol from drop down list. 4. Choose fitting specific options (CRI/LED colour and whether a cowl is needed) from drop down lists."]
[]
[]
[]
[]
[]
[]
[null,"Cove Length (m)","Cove Length 1 (m)",1.81,"Number of fittings","Length of 1800mm fittings",null,0.91,"Number of fittings","Length of 900mm fittings",null,0.61,"Number of fittings","Length of 600mm fittings",null,0.31,"Number of fittings","Length of 300mm fittings",null,0.16,"Number of fittings","Length of 150mm fittings",null,null,"Type of LINELIGHT",null,"Quantity of 1810mm",null,"Quantity of 910mm","Quantity of 610mm",null,"Quantity of 310mm","Quantity of 160mm",null,"Total Length (m)"]
[null,null,{"$f":"AI10","v":0},{"$f":"C10/D9","v":0},{"$f":"AA10","v":0},{"$f":"E10*D9","v":0},null,null,{"$f":"AC10","v":0},{"$f":"I10*H9","v":0},null,null,{"$f":"AD10","v":0},{"$f":"M10*L9","v":0},null,null,{"$f":"AF10","v":0},{"$f":"Q10*P9","v":0},null,null,{"$f":"AG10","v":0},{"$f":"U10*T9","v":0},null,null,"Please select from list",{"$f":"VLOOKUP(Y10,Sheet2!D20:E22,2,0)","v":{"$error":"#N/A"}},0,null,0,0,null,0,0,null,{"$f":"F10+J10+N10+R10+V10","v":0}]
[null,null,null,18,"Number of drivers 350W","Metre run by 350W","Remaining m",11,"Number of drivers 175W","Metre run by 175W","Remaining m",4,"Number of drivers 70W"]
[null,null,"LINELIGHT Stable white",{"$f":"C10/D11","v":0},{"$f":"ROUND(D12,0)","v":0},{"$f":"E12*D11","v":0},{"$f":"C10-F12","v":0},{"$f":"IF(G12>0,G12/H11,\"0\")","v":"0"},{"$f":"ROUND(H12,0)","v":0},{"$f":"I12*H11","v":0},{"$f":"G12-J12","v":0},{"$f":"IF(K12>0,K12/L11,\"0\")","v":"0"},{"$f":"ROUNDUP(L12,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Dimming Protocol",null,"Quantity of 320W drivers",null,"Driver and SAP code","Quantity of 175W drivers",null,"Driver and SAP code","Quantity of 70W drivers",null,"Driver and SAP code"]
[null,null,null,8,"Number of drivers 350W","Metre run by 350W","Remaining m",4,"Number of drivers 175W","Metre run by 175W","Remaining m",1.8,"Number of drivers 70W",null,null,null,null,null,null,null,null,null,null,null,"Choose dimming protocol",{"$f":"VLOOKUP(Y10,Sheet2!D20:F22,3,0)","v":{"$error":"#N/A"}},{"$f":"IF(Y10=C12,E12,IF(Y10=C14,E14,IF(Y10=C16,E16,\"Please check options\")))","v":"Please check options"},{"$f":"CONCATENATE(Y10,\"/\",Y13,\"/\",\"320W\")","v":"Please select from list/Choose dimming protocol/320W"},{"$f":"IFERROR(VLOOKUP(AB13,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"},{"$f":"IF(Y10=C12,I12,IF(Y10=C14,I14,IF(Y10=C16,I16,\"Please check options\")))","v":"Please check options"},{"$f":"CONCATENATE(Y10,\"/\",Y13,\"/\",\"175W\")","v":"Please select from list/Choose dimming protocol/175W"},{"$f":"IFERROR(VLOOKUP(AE13,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"},{"$f":"IF(Y10=C12,M12,IF(Y10=C14,M14,IF(Y10=C16,M16,\"Please check options\")))","v":"Please check options"},{"$f":"CONCATENATE(Y10,\"/\",Y13,\"/\",\"70W\")","v":"Please select from list/Choose dimming protocol/70W"},{"$f":"IFERROR(VLOOKUP(AH13,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"}]
[null,null,"LINELIGHT Balanced white",{"$f":"C10/D13","v":0},{"$f":"ROUND(D14,0)","v":0},{"$f":"E14*D13","v":0},{"$f":"C10-F14","v":0},{"$f":"IF(G14>0,G14/H13,\"0\")","v":"0"},{"$f":"ROUND(H14,0)","v":0},{"$f":"I14*H13","v":0},{"$f":"G14-J14","v":0},{"$f":"IF(K14>0,K14/L13,\"0\")","v":"0"},{"$f":"ROUNDUP(L14,0)","v":0}]
[null,null,null,6,"Number of drivers 350W","Metre run by 350W","Remaining m",4,"Number of drivers 175W","Metre run by 175W","Remaining m",1,"Number of drivers 70W",null,null,null,null,null,null,null,null,null,null,null,"Please select from list"]
[null,null,"LINELIGHT Stable white (EB)",{"$f":"C10/D15","v":0},{"$f":"ROUND(D16,0)","v":0},{"$f":"E16*D15","v":0},{"$f":"C10-F16","v":0},{"$f":"IF(G16>0,G16/H15,\"0\")","v":"0"},{"$f":"ROUND(H16,0)","v":0},{"$f":"I16*H15","v":0},{"$f":"G16-J16","v":0},{"$f":"IF(K16>0,K16/L15,\"0\")","v":"0"},{"$f":"ROUNDUP(L16,0)","v":0}]
[]
[null,"Cove Length 2 (m)","Cove Length 2 (m)",1.81,"Number of fittings","Length of 1800mm fittings","Remaining m",0.91,"Number of fittings","Length of 900mm fittings","Remaining m",0.61,"Number of fittings","Length of 600mm fittings","Remaining m",0.31,"Number of fittings","Length of 300mm fittings","Remaining m",0.16,"Number of fittings","Length of 150mm fittings","Remaining m",null,"Type of Orelle",null,"Quantity of 1800mm",null,"Quantity of 900mm","Quantity of 600mm",null,"Quantity of 300mm","Quantity of 150mm",null,"Total Length (m)"]
[null,0,{"$f":"B19","v":0},{"$f":"C19/D18","v":0},{"$f":"ROUNDDOWN(D19,0)","v":0},{"$f":"E19*D18","v":0},{"$f":"C19-F19","v":0},{"$f":"G19/H18","v":0},{"$f":"ROUNDDOWN(H19,0)","v":0},{"$f":"I19*H18","v":0},{"$f":"G19-J19","v":0},{"$f":"K19/L18","v":0},{"$f":"ROUNDDOWN(L19,0)","v":0},{"$f":"M19*L18","v":0},{"$f":"K19-N19","v":0},{"$f":"O19/P18","v":0},{"$f":"ROUNDDOWN(P19,0)","v":0},{"$f":"Q19*P18","v":0},{"$f":"O19-R19","v":0},{"$f":"S19/T18","v":0},{"$f":"ROUNDDOWN(T19,0)","v":0},{"$f":"U19*T18","v":0},{"$f":"S19-V19","v":0},null,"Orelle Pro Single Colour (SB)",null,{"$f":"E19","v":0},null,{"$f":"I19","v":0},{"$f":"M19","v":0},null,{"$f":"Q19","v":0},{"$f":"U19","v":0},null,{"$f":"F19+J19+N19+R19+V19","v":0}]
[null,null,null,18,"Number of drivers 350W","Metre run by 350W","Remaining m",11,"Number of drivers 175W","Metre run by 175W","Remaining m",4,"Number of drivers 70W"]
[null,null,"Orelle Pro Single Colour (SB)",{"$f":"C19/D20","v":0},{"$f":"ROUND(D21,0)","v":0},{"$f":"E21*D20","v":0},{"$f":"C19-F21","v":0},{"$f":"IF(G21>0,G21/H20,\"0\")","v":"0"},{"$f":"ROUND(H21,0)","v":0},{"$f":"I21*H20","v":0},{"$f":"G21-J21","v":0},{"$f":"IF(K21>0,K21/L20,\"0\")","v":"0"},{"$f":"ROUNDUP(L21,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Dimming protocol",null,"Quantity of 320W drivers",null,"Driver and SAP code","Quantity of 175W drivers",null,"Driver and SAP code","Quantity of 70W drivers",null,"Driver and SAP code"]
[null,null,null,8,"Number of drivers 350W","Metre run by 350W","Remaining m",4,"Number of drivers 175W","Metre run by 175W","Remaining m",1.8,"Number of drivers 70W",null,null,null,null,null,null,null,null,null,null,null,"Non-Dimmable/HF",null,{"$f":"IF(Y19=C21,E21,IF(Y19=C23,E23,IF(Y19=C25,E25,\"Please check options\")))","v":0},{"$f":"CONCATENATE(Y19,\"/\",Y22,\"/\",\"320W\")","v":"Orelle Pro Single Colour (SB)/Non-Dimmable/HF/320W"},{"$f":"IFERROR(VLOOKUP(AB22,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"},{"$f":"IF(Y19=C21,I21,IF(Y19=C23,I23,IF(Y19=C25,I25,\"Please check options\")))","v":0},{"$f":"CONCATENATE(Y19,\"/\",Y22,\"/\",\"175W\")","v":"Orelle Pro Single Colour (SB)/Non-Dimmable/HF/175W"},{"$f":"IFERROR(VLOOKUP(AE22,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"},{"$f":"IF(Y19=C21,M21,IF(Y19=C23,M23,IF(Y19=C25,M25,\"Please check options\")))","v":0},{"$f":"CONCATENATE(Y19,\"/\",Y22,\"/\",\"70W\")","v":"Orelle Pro Single Colour (SB)/Non-Dimmable/HF/70W"},{"$f":"IFERROR(VLOOKUP(AH22,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"}]
[null,null,"Orelle Pro Dynamic White",{"$f":"C19/D22","v":0},{"$f":"ROUND(D23,0)","v":0},{"$f":"E23*D22","v":0},{"$f":"C19-F23","v":0},{"$f":"IF(G23>0,G23/H22,\"0\")","v":"0"},{"$f":"ROUND(H23,0)","v":0},{"$f":"I23*H22","v":0},{"$f":"G23-J23","v":0},{"$f":"IF(K23>0,K23/L22,\"0\")","v":"0"},{"$f":"ROUNDUP(L23,0)","v":0}]
[null,null,null,6,"Number of drivers 350W","Metre run by 350W","Remaining m",4,"Number of drivers 175W","Metre run by 175W","Remaining m",1,"Number of drivers 70W"]
[null,null,"Orelle Pro+ Single Colour (EB)",{"$f":"C19/D24","v":0},{"$f":"ROUND(D25,0)","v":0},{"$f":"E25*D24","v":0},{"$f":"C19-F25","v":0},{"$f":"IF(G25>0,G25/H24,\"0\")","v":"0"},{"$f":"ROUND(H25,0)","v":0},{"$f":"I25*H24","v":0},{"$f":"G25-J25","v":0},{"$f":"IF(K25>0,K25/L24,\"0\")","v":"0"},{"$f":"ROUNDUP(L25,0)","v":0}]
[]
[null,"Cove Length 3 (m)","Cove Length 3 (m)",1.81,"Number of fittings","Length of 1800mm fittings","Remaining m",0.91,"Number of fittings","Length of 900mm fittings","Remaining m",0.61,"Number of fittings","Length of 600mm fittings","Remaining m",0.31,"Number of fittings","Length of 300mm fittings","Remaining m",0.16,"Number of fittings","Length of 150mm fittings","Remaining m",null,"Type of Orelle",null,"Quantity of 1800mm",null,"Quantity of 900mm","Quantity of 600mm",null,"Quantity of 300mm","Quantity of 150mm",null,"Total Length (m)"]
[null,0,{"$f":"B28","v":0},{"$f":"C28/D27","v":0},{"$f":"ROUNDDOWN(D28,0)","v":0},{"$f":"E28*D27","v":0},{"$f":"C28-F28","v":0},{"$f":"G28/H27","v":0},{"$f":"ROUNDDOWN(H28,0)","v":0},{"$f":"I28*H27","v":0},{"$f":"G28-J28","v":0},{"$f":"K28/L27","v":0},{"$f":"ROUNDDOWN(L28,0)","v":0},{"$f":"M28*L27","v":0},{"$f":"K28-N28","v":0},{"$f":"O28/P27","v":0},{"$f":"ROUNDDOWN(P28,0)","v":0},{"$f":"Q28*P27","v":0},{"$f":"O28-R28","v":0},{"$f":"S28/T27","v":0},{"$f":"ROUNDDOWN(T28,0)","v":0},{"$f":"U28*T27","v":0},{"$f":"S28-V28","v":0},null,"Orelle Pro Single Colour (SB)",null,{"$f":"E28","v":0},null,{"$f":"I28","v":0},{"$f":"M28","v":0},null,{"$f":"Q28","v":0},{"$f":"U28","v":0},null,{"$f":"F28+J28+N28+R28+V28","v":0}]
[null,null,null,18,"Number of drivers 350W","Metre run by 350W","Remaining m",11,"Number of drivers 175W","Metre run by 175W","Remaining m",4,"Number of drivers 70W"]
[null,null,"Orelle Pro Single Colour (SB)",{"$f":"C28/D29","v":0},{"$f":"ROUND(D30,0)","v":0},{"$f":"E30*D29","v":0},{"$f":"C28-F30","v":0},{"$f":"IF(G30>0,G30/H29,\"0\")","v":"0"},{"$f":"ROUND(H30,0)","v":0},{"$f":"I30*H29","v":0},{"$f":"G30-J30","v":0},{"$f":"IF(K30>0,K30/L29,\"0\")","v":"0"},{"$f":"ROUNDUP(L30,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Dimming protocol",null,"Quantity of 320W drivers",null,"Driver and SAP code","Quantity of 175W drivers",null,"Driver and SAP code","Quantity of 70W drivers",null,"Driver and SAP code"]
[null,null,null,8,"Number of drivers 350W","Metre run by 350W","Remaining m",4,"Number of drivers 175W","Metre run by 175W","Remaining m",1.8,"Number of drivers 70W",null,null,null,null,null,null,null,null,null,null,null,"Non-Dimmable/HF",null,{"$f":"IF(Y28=C30,E30,IF(Y28=C32,E32,IF(Y28=C34,E34,\"Please check options\")))","v":0},{"$f":"CONCATENATE(Y28,\"/\",Y31,\"/\",\"320W\")","v":"Orelle Pro Single Colour (SB)/Non-Dimmable/HF/320W"},{"$f":"IFERROR(VLOOKUP(AB31,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"},{"$f":"IF(Y28=C30,I30,IF(Y28=C32,I32,IF(Y28=C34,I34,\"Please check options\")))","v":0},{"$f":"CONCATENATE(Y28,\"/\",Y31,\"/\",\"175W\")","v":"Orelle Pro Single Colour (SB)/Non-Dimmable/HF/175W"},{"$f":"IFERROR(VLOOKUP(AE31,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"},{"$f":"IF(Y28=C30,M30,IF(Y28=C32,M32,IF(Y28=C34,M34,\"Please check options\")))","v":0},{"$f":"CONCATENATE(Y28,\"/\",Y31,\"/\",\"70W\")","v":"Orelle Pro Single Colour (SB)/Non-Dimmable/HF/70W"},{"$f":"IFERROR(VLOOKUP(AH31,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"}]
[null,null,"Orelle Pro Dynamic White",{"$f":"C28/D31","v":0},{"$f":"ROUND(D32,0)","v":0},{"$f":"E32*D31","v":0},{"$f":"C28-F32","v":0},{"$f":"IF(G32>0,G32/H31,\"0\")","v":"0"},{"$f":"ROUND(H32,0)","v":0},{"$f":"I32*H31","v":0},{"$f":"G32-J32","v":0},{"$f":"IF(K32>0,K32/L31,\"0\")","v":"0"},{"$f":"ROUNDUP(L32,0)","v":0}]
[null,null,null,6,"Number of drivers 350W","Metre run by 350W","Remaining m",4,"Number of drivers 175W","Metre run by 175W","Remaining m",1,"Number of drivers 70W"]
[null,null,"Orelle Pro+ Single Colour (EB)",{"$f":"C28/D33","v":0},{"$f":"ROUND(D34,0)","v":0},{"$f":"E34*D33","v":0},{"$f":"C28-F34","v":0},{"$f":"IF(G34>0,G34/H33,\"0\")","v":"0"},{"$f":"ROUND(H34,0)","v":0},{"$f":"I34*H33","v":0},{"$f":"G34-J34","v":0},{"$f":"IF(K34>0,K34/L33,\"0\")","v":"0"},{"$f":"ROUNDUP(L34,0)","v":0}]
[]
[null,"Cove Length 4 (m)","Cove Length 4 (m)",1.81,"Number of fittings","Length of 1800mm fittings","Remaining m",0.91,"Number of fittings","Length of 900mm fittings","Remaining m",0.61,"Number of fittings","Length of 600mm fittings","Remaining m",0.31,"Number of fittings","Length of 300mm fittings","Remaining m",0.16,"Number of fittings","Length of 150mm fittings","Remaining m",null,"Type of Orelle",null,"Quantity of 1800mm",null,"Quantity of 900mm","Quantity of 600mm",null,"Quantity of 300mm","Quantity of 150mm",null,"Total Length (m)"]
[null,0,{"$f":"B37","v":0},{"$f":"C37/D36","v":0},{"$f":"ROUNDDOWN(D37,0)","v":0},{"$f":"E37*D36","v":0},{"$f":"C37-F37","v":0},{"$f":"G37/H36","v":0},{"$f":"ROUNDDOWN(H37,0)","v":0},{"$f":"I37*H36","v":0},{"$f":"G37-J37","v":0},{"$f":"K37/L36","v":0},{"$f":"ROUNDDOWN(L37,0)","v":0},{"$f":"M37*L36","v":0},{"$f":"K37-N37","v":0},{"$f":"O37/P36","v":0},{"$f":"ROUNDDOWN(P37,0)","v":0},{"$f":"Q37*P36","v":0},{"$f":"O37-R37","v":0},{"$f":"S37/T36","v":0},{"$f":"ROUNDDOWN(T37,0)","v":0},{"$f":"U37*T36","v":0},{"$f":"S37-V37","v":0},null,"Orelle Pro Single Colour (SB)",null,{"$f":"E37","v":0},null,{"$f":"I37","v":0},{"$f":"M37","v":0},null,{"$f":"Q37","v":0},{"$f":"U37","v":0},null,{"$f":"F37+J37+N37+R37+V37","v":0}]
[null,null,null,18,"Number of drivers 350W","Metre run by 350W","Remaining m",11,"Number of drivers 175W","Metre run by 175W","Remaining m",4,"Number of drivers 70W"]
[null,null,"Orelle Pro Single Colour (SB)",{"$f":"C37/D38","v":0},{"$f":"ROUND(D39,0)","v":0},{"$f":"E39*D38","v":0},{"$f":"C37-F39","v":0},{"$f":"IF(G39>0,G39/H38,\"0\")","v":"0"},{"$f":"ROUND(H39,0)","v":0},{"$f":"I39*H38","v":0},{"$f":"G39-J39","v":0},{"$f":"IF(K39>0,K39/L38,\"0\")","v":"0"},{"$f":"ROUNDUP(L39,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Dimming protocol",null,"Quantity of 320W drivers",null,"Driver and SAP code","Quantity of 175W drivers",null,"Driver and SAP code","Quantity of 70W drivers",null,"Driver and SAP code"]
[null,null,null,8,"Number of drivers 350W","Metre run by 350W","Remaining m",4,"Number of drivers 175W","Metre run by 175W","Remaining m",1.8,"Number of drivers 70W",null,null,null,null,null,null,null,null,null,null,null,"Non-Dimmable/HF",null,{"$f":"IF(Y37=C39,E39,IF(Y37=C41,E41,IF(Y37=C43,E43,\"Please check options\")))","v":0},{"$f":"CONCATENATE(Y37,\"/\",Y40,\"/\",\"320W\")","v":"Orelle Pro Single Colour (SB)/Non-Dimmable/HF/320W"},{"$f":"IFERROR(VLOOKUP(AB40,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"},{"$f":"IF(Y37=C39,I39,IF(Y37=C41,I41,IF(Y37=C43,I43,\"Please check options\")))","v":0},{"$f":"CONCATENATE(Y37,\"/\",Y40,\"/\",\"175W\")","v":"Orelle Pro Single Colour (SB)/Non-Dimmable/HF/175W"},{"$f":"IFERROR(VLOOKUP(AE40,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"},{"$f":"IF(Y37=C39,M39,IF(Y37=C41,M41,IF(Y37=C43,M43,\"Please check options\")))","v":0},{"$f":"CONCATENATE(Y37,\"/\",Y40,\"/\",\"70W\")","v":"Orelle Pro Single Colour (SB)/Non-Dimmable/HF/70W"},{"$f":"IFERROR(VLOOKUP(AH40,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"}]
[null,null,"Orelle Pro Dynamic White",{"$f":"C37/D40","v":0},{"$f":"ROUND(D41,0)","v":0},{"$f":"E41*D40","v":0},{"$f":"C37-F41","v":0},{"$f":"IF(G41>0,G41/H40,\"0\")","v":"0"},{"$f":"ROUND(H41,0)","v":0},{"$f":"I41*H40","v":0},{"$f":"G41-J41","v":0},{"$f":"IF(K41>0,K41/L40,\"0\")","v":"0"},{"$f":"ROUNDUP(L41,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Type","Length","CRI/LED Colour","Lens Type",null,"Cowl",null,null,null,"Article Number"]
[null,null,null,6,"Number of drivers 350W","Metre run by 350W","Remaining m",4,"Number of drivers 175W","Metre run by 175W","Remaining m",1,"Number of drivers 70W",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Y$10=\"Please select from list\",\"Please select from list above\",$Y$10)","v":"Please select from list above"},"1810mm","Please select from list","Diffuse",null,"Please select from list",null,{"$f":"CONCATENATE(AA42,AB42,AC42,AD42,AF42)","v":"Please select from list above1810mmPlease select from listDiffusePlease select from list"},null,{"$f":"IFERROR(VLOOKUP(AH42,Sheet3!K:O,5,0),\"Please check options\")","v":"Please check options"}]
[null,null,"Orelle Pro+ Single Colour (EB)",{"$f":"C37/D42","v":0},{"$f":"ROUND(D43,0)","v":0},{"$f":"E43*D42","v":0},{"$f":"C37-F43","v":0},{"$f":"IF(G43>0,G43/H42,\"0\")","v":"0"},{"$f":"ROUND(H43,0)","v":0},{"$f":"I43*H42","v":0},{"$f":"G43-J43","v":0},{"$f":"IF(K43>0,K43/L42,\"0\")","v":"0"},{"$f":"ROUNDUP(L43,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Y$10=\"Please select from list\",\"Please select from list above\",$Y$10)","v":"Please select from list above"},"910mm",{"$f":"$AC$42","v":"Please select from list"},{"$f":"$AD$42","v":"Diffuse"},null,{"$f":"$AF$42","v":"Please select from list"},null,{"$f":"CONCATENATE(AA43,AB43,AC43,AD43,AF43)","v":"Please select from list above910mmPlease select from listDiffusePlease select from list"},null,{"$f":"IFERROR(VLOOKUP(AH43,Sheet3!K:O,5,0),\"Please check options\")","v":"Please check options"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Y$10=\"Please select from list\",\"Please select from list above\",$Y$10)","v":"Please select from list above"},"610mm",{"$f":"$AC$42","v":"Please select from list"},{"$f":"$AD$42","v":"Diffuse"},null,{"$f":"$AF$42","v":"Please select from list"},null,{"$f":"CONCATENATE(AA44,AB44,AC44,AD44,AF44)","v":"Please select from list above610mmPlease select from listDiffusePlease select from list"},null,{"$f":"IFERROR(VLOOKUP(AH44,Sheet3!K:O,5,0),\"Please check options\")","v":"Please check options"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Y$10=\"Please select from list\",\"Please select from list above\",$Y$10)","v":"Please select from list above"},"310mm","Please select from list",{"$f":"$AD$42","v":"Diffuse"},null,{"$f":"$AF$42","v":"Please select from list"},null,{"$f":"CONCATENATE(AA45,AB45,AC45,AD45,AF45)","v":"Please select from list above310mmPlease select from listDiffusePlease select from list"},null,{"$f":"IFERROR(VLOOKUP(AH45,Sheet3!K:O,5,0),\"Please check options\")","v":"Please check options"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Y$10=\"Please select from list\",\"Please select from list above\",$Y$10)","v":"Please select from list above"},"160mm","Please select from list",{"$f":"$AD$42","v":"Diffuse"},null,{"$f":"$AF$42","v":"Please select from list"},null,{"$f":"CONCATENATE(AA46,AB46,AC46,AD46,AF46)","v":"Please select from list above160mmPlease select from listDiffusePlease select from list"},null,{"$f":"IFERROR(VLOOKUP(AH46,Sheet3!K:O,5,0),\"Please check options\")","v":"Please check options"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cove Summary",null,null,"Quantity",null,"Article Number"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"Please select from list\",CONCATENATE(AA42,\", \",AB42,\", \",AC42,\", \",AD42,\" Lens \",AF42))),\"Please check options\",CONCATENATE(AA42,\", \",AB42,\", \",AC42,\", \",AD42,\" Lens, \",AF42))","v":"Please check options"},null,null,{"$f":"AA10","v":0},null,{"$f":"IF(AD49=0,\"\",(IF(AJ42=\"Please check options\",\"\",AJ42)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"Please select from list\",CONCATENATE(AA43,\", \",AB43,\", \",AC43,\", \",AD43,\" Lens \",AF43))),\"Please check options\",CONCATENATE(AA43,\", \",AB43,\", \",AC43,\", \",AD43,\" Lens, \",AF43))","v":"Please check options"},null,null,{"$f":"AC10","v":0},null,{"$f":"IF(AD50=0,\"\",(IF(AJ43=\"Please check options\",\"\",AJ43)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please check options",null,null,{"$f":"AD10","v":0},null,{"$f":"IF(AD51=0,\"\",(IF(AJ44=\"Please check options\",\"\",AJ44)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"Please select from list\",CONCATENATE(AA45,\", \",AB45,\", \",AC45,\", \",AD45,\" Lens \",AF45))),\"Please check options\",CONCATENATE(AA45,\", \",AB45,\", \",AC45,\", \",AD45,\" Lens, \",AF45))","v":"Please check options"},null,null,{"$f":"AF10","v":0},null,{"$f":"IF(AD52=0,\"\",(IF(AJ45=\"Please check options\",\"\",AJ45)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please check options",null,null,0,null,{"$f":"IF(AD53=0,\"\",(IF(AJ46=\"Please check options\",\"\",AJ46)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEFT(AC13,LEN(AC13)-11)=\"Please ch\",\"Please check options\",LEFT(AC13,LEN(AC13)-11))","v":"Please check options"},null,null,{"$f":"IF(AA13=\"Please check options\",\"0\",AA13)","v":"0"},null,{"$f":"IF(AD54=0,\"\",(IF(RIGHT(AC13,8)=\" options\",\"\",RIGHT(AC13,8))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEFT(AF13,LEN(AF13)-11)=\"Please ch\",\"Please check options\",LEFT(AF13,LEN(AF13)-11))","v":"Please check options"},null,null,{"$f":"IF(AD13=\"Please check options\",\"0\",AD13)","v":"0"},null,{"$f":"IF(AD55=0,\"\",(IF(RIGHT(AF13,8)=\" options\",\"\",RIGHT(AF13,8))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEFT(AI13,LEN(AI13)-11)=\"Please ch\",\"Please check options\",LEFT(AI13,LEN(AI13)-11))","v":"Please check options"},null,null,{"$f":"IF(AG13=\"Please check options\",\"0\",AG13)","v":"0"},null,{"$f":"IF(AD56=0,\"\",(IF(RIGHT(AI13,8)=\" options\",\"\",RIGHT(AI13,8))))","v":""}]

{"sheet":"Orelle Spec Builder (2)","index":5,"n_rows":53,"n_cols":36,"rows_kept":53,"cut":false,"hidden":true,"merged":[[44,26,44,28],[3,1,3,34],[6,1,9,1],[15,1,18,1],[24,1,27,1],[33,1,36,1],[51,26,51,28],[52,26,52,28],[45,26,45,28],[46,26,46,28],[47,26,47,28],[48,26,48,28],[49,26,49,28],[50,26,50,28]]}
[]
[]
[]
[null,"Instructions for use: 1. Enter cove length. 2. Choose type of Orelle from drop down list. 3. Choose dimming protocol from drop down list. 4. Choose fitting specific options (CRI/LED colour, Lens type and whether a cowl is needed) from drop down lists"]
[]
[null,"Cove Length (m)","Cove Length 1 (m)",1.81,"Number of fittings","Length of 1800mm fittings","Remaining m",0.91,"Number of fittings","Length of 900mm fittings","Remaining m",0.61,"Number of fittings","Length of 600mm fittings","Remaining m",0.31,"Number of fittings","Length of 300mm fittings","Remaining m",0.16,"Number of fittings","Length of 150mm fittings","Remaining m",null,"Type of Orelle",null,"Quantity of 1800mm",null,"Quantity of 900mm","Quantity of 600mm",null,"Quantity of 300mm","Quantity of 150mm",null,"Total Length (m)"]
[null,0,{"$f":"B7","v":0},{"$f":"C7/D6","v":0},{"$f":"ROUNDDOWN(D7,0)","v":0},{"$f":"E7*D6","v":0},{"$f":"C7-F7","v":0},{"$f":"G7/H6","v":0},{"$f":"ROUNDDOWN(H7,0)","v":0},{"$f":"I7*H6","v":0},{"$f":"G7-J7","v":0},{"$f":"K7/L6","v":0},{"$f":"ROUNDDOWN(L7,0)","v":0},{"$f":"M7*L6","v":0},{"$f":"K7-N7","v":0},{"$f":"O7/P6","v":0},{"$f":"ROUNDDOWN(P7,0)","v":0},{"$f":"Q7*P6","v":0},{"$f":"O7-R7","v":0},{"$f":"S7/T6","v":0},{"$f":"ROUNDDOWN(T7,0)","v":0},{"$f":"U7*T6","v":0},{"$f":"S7-V7","v":0},null,"Please select from list",{"$f":"VLOOKUP(Y7,Sheet2!D20:E22,2,0)","v":{"$error":"#N/A"}},{"$f":"E7","v":0},null,{"$f":"I7","v":0},{"$f":"M7","v":0},null,{"$f":"Q7","v":0},{"$f":"U7","v":0},null,{"$f":"F7+J7+N7+R7+V7","v":0}]
[null,null,null,18,"Number of drivers 350W","Metre run by 350W","Remaining m",11,"Number of drivers 175W","Metre run by 175W","Remaining m",4,"Number of drivers 70W"]
[null,null,"Orelle Pro Single Colour (SB)",{"$f":"C7/D8","v":0},{"$f":"ROUND(D9,0)","v":0},{"$f":"E9*D8","v":0},{"$f":"C7-F9","v":0},{"$f":"IF(G9>0,G9/H8,\"0\")","v":"0"},{"$f":"ROUND(H9,0)","v":0},{"$f":"I9*H8","v":0},{"$f":"G9-J9","v":0},{"$f":"IF(K9>0,K9/L8,\"0\")","v":"0"},{"$f":"ROUNDUP(L9,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Dimming Protocol",null,"Quantity of 320W drivers",null,"Driver and SAP code","Quantity of 175W drivers",null,"Driver and SAP code","Quantity of 70W drivers",null,"Driver and SAP code"]
[null,null,null,8,"Number of drivers 350W","Metre run by 350W","Remaining m",4,"Number of drivers 175W","Metre run by 175W","Remaining m",1.8,"Number of drivers 70W",null,null,null,null,null,null,null,null,null,null,null,"Choose dimming protocol",{"$f":"VLOOKUP(Y7,Sheet2!D20:F22,3,0)","v":{"$error":"#N/A"}},{"$f":"IF(Y7=C9,E9,IF(Y7=C11,E11,IF(Y7=C13,E13,\"Please check options\")))","v":"Please check options"},{"$f":"CONCATENATE(Y7,\"/\",Y10,\"/\",\"320W\")","v":"Please select from list/Choose dimming protocol/320W"},{"$f":"IFERROR(VLOOKUP(AB10,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"},{"$f":"IF(Y7=C9,I9,IF(Y7=C11,I11,IF(Y7=C13,I13,\"Please check options\")))","v":"Please check options"},{"$f":"CONCATENATE(Y7,\"/\",Y10,\"/\",\"175W\")","v":"Please select from list/Choose dimming protocol/175W"},{"$f":"IFERROR(VLOOKUP(AE10,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"},{"$f":"IF(Y7=C9,M9,IF(Y7=C11,M11,IF(Y7=C13,M13,\"Please check options\")))","v":"Please check options"},{"$f":"CONCATENATE(Y7,\"/\",Y10,\"/\",\"70W\")","v":"Please select from list/Choose dimming protocol/70W"},{"$f":"IFERROR(VLOOKUP(AH10,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"}]
[null,null,"Orelle Pro Dynamic White",{"$f":"C7/D10","v":0},{"$f":"ROUND(D11,0)","v":0},{"$f":"E11*D10","v":0},{"$f":"C7-F11","v":0},{"$f":"IF(G11>0,G11/H10,\"0\")","v":"0"},{"$f":"ROUND(H11,0)","v":0},{"$f":"I11*H10","v":0},{"$f":"G11-J11","v":0},{"$f":"IF(K11>0,K11/L10,\"0\")","v":"0"},{"$f":"ROUNDUP(L11,0)","v":0}]
[null,null,null,6,"Number of drivers 350W","Metre run by 350W","Remaining m",4,"Number of drivers 175W","Metre run by 175W","Remaining m",1,"Number of drivers 70W",null,null,null,null,null,null,null,null,null,null,null,"Please select from list"]
[null,null,"Orelle Pro+ Single Colour (EB)",{"$f":"C7/D12","v":0},{"$f":"ROUND(D13,0)","v":0},{"$f":"E13*D12","v":0},{"$f":"C7-F13","v":0},{"$f":"IF(G13>0,G13/H12,\"0\")","v":"0"},{"$f":"ROUND(H13,0)","v":0},{"$f":"I13*H12","v":0},{"$f":"G13-J13","v":0},{"$f":"IF(K13>0,K13/L12,\"0\")","v":"0"},{"$f":"ROUNDUP(L13,0)","v":0}]
[]
[null,"Cove Length 2 (m)","Cove Length 2 (m)",1.81,"Number of fittings","Length of 1800mm fittings","Remaining m",0.91,"Number of fittings","Length of 900mm fittings","Remaining m",0.61,"Number of fittings","Length of 600mm fittings","Remaining m",0.31,"Number of fittings","Length of 300mm fittings","Remaining m",0.16,"Number of fittings","Length of 150mm fittings","Remaining m",null,"Type of Orelle",null,"Quantity of 1800mm",null,"Quantity of 900mm","Quantity of 600mm",null,"Quantity of 300mm","Quantity of 150mm",null,"Total Length (m)"]
[null,0,{"$f":"B16","v":0},{"$f":"C16/D15","v":0},{"$f":"ROUNDDOWN(D16,0)","v":0},{"$f":"E16*D15","v":0},{"$f":"C16-F16","v":0},{"$f":"G16/H15","v":0},{"$f":"ROUNDDOWN(H16,0)","v":0},{"$f":"I16*H15","v":0},{"$f":"G16-J16","v":0},{"$f":"K16/L15","v":0},{"$f":"ROUNDDOWN(L16,0)","v":0},{"$f":"M16*L15","v":0},{"$f":"K16-N16","v":0},{"$f":"O16/P15","v":0},{"$f":"ROUNDDOWN(P16,0)","v":0},{"$f":"Q16*P15","v":0},{"$f":"O16-R16","v":0},{"$f":"S16/T15","v":0},{"$f":"ROUNDDOWN(T16,0)","v":0},{"$f":"U16*T15","v":0},{"$f":"S16-V16","v":0},null,"Orelle Pro Single Colour (SB)",null,{"$f":"E16","v":0},null,{"$f":"I16","v":0},{"$f":"M16","v":0},null,{"$f":"Q16","v":0},{"$f":"U16","v":0},null,{"$f":"F16+J16+N16+R16+V16","v":0}]
[null,null,null,18,"Number of drivers 350W","Metre run by 350W","Remaining m",11,"Number of drivers 175W","Metre run by 175W","Remaining m",4,"Number of drivers 70W"]
[null,null,"Orelle Pro Single Colour (SB)",{"$f":"C16/D17","v":0},{"$f":"ROUND(D18,0)","v":0},{"$f":"E18*D17","v":0},{"$f":"C16-F18","v":0},{"$f":"IF(G18>0,G18/H17,\"0\")","v":"0"},{"$f":"ROUND(H18,0)","v":0},{"$f":"I18*H17","v":0},{"$f":"G18-J18","v":0},{"$f":"IF(K18>0,K18/L17,\"0\")","v":"0"},{"$f":"ROUNDUP(L18,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Dimming protocol",null,"Quantity of 320W drivers",null,"Driver and SAP code","Quantity of 175W drivers",null,"Driver and SAP code","Quantity of 70W drivers",null,"Driver and SAP code"]
[null,null,null,8,"Number of drivers 350W","Metre run by 350W","Remaining m",4,"Number of drivers 175W","Metre run by 175W","Remaining m",1.8,"Number of drivers 70W",null,null,null,null,null,null,null,null,null,null,null,"Non-Dimmable/HF",null,{"$f":"IF(Y16=C18,E18,IF(Y16=C20,E20,IF(Y16=C22,E22,\"Please check options\")))","v":0},{"$f":"CONCATENATE(Y16,\"/\",Y19,\"/\",\"320W\")","v":"Orelle Pro Single Colour (SB)/Non-Dimmable/HF/320W"},{"$f":"IFERROR(VLOOKUP(AB19,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"},{"$f":"IF(Y16=C18,I18,IF(Y16=C20,I20,IF(Y16=C22,I22,\"Please check options\")))","v":0},{"$f":"CONCATENATE(Y16,\"/\",Y19,\"/\",\"175W\")","v":"Orelle Pro Single Colour (SB)/Non-Dimmable/HF/175W"},{"$f":"IFERROR(VLOOKUP(AE19,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"},{"$f":"IF(Y16=C18,M18,IF(Y16=C20,M20,IF(Y16=C22,M22,\"Please check options\")))","v":0},{"$f":"CONCATENATE(Y16,\"/\",Y19,\"/\",\"70W\")","v":"Orelle Pro Single Colour (SB)/Non-Dimmable/HF/70W"},{"$f":"IFERROR(VLOOKUP(AH19,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"}]
[null,null,"Orelle Pro Dynamic White",{"$f":"C16/D19","v":0},{"$f":"ROUND(D20,0)","v":0},{"$f":"E20*D19","v":0},{"$f":"C16-F20","v":0},{"$f":"IF(G20>0,G20/H19,\"0\")","v":"0"},{"$f":"ROUND(H20,0)","v":0},{"$f":"I20*H19","v":0},{"$f":"G20-J20","v":0},{"$f":"IF(K20>0,K20/L19,\"0\")","v":"0"},{"$f":"ROUNDUP(L20,0)","v":0}]
[null,null,null,6,"Number of drivers 350W","Metre run by 350W","Remaining m",4,"Number of drivers 175W","Metre run by 175W","Remaining m",1,"Number of drivers 70W"]
[null,null,"Orelle Pro+ Single Colour (EB)",{"$f":"C16/D21","v":0},{"$f":"ROUND(D22,0)","v":0},{"$f":"E22*D21","v":0},{"$f":"C16-F22","v":0},{"$f":"IF(G22>0,G22/H21,\"0\")","v":"0"},{"$f":"ROUND(H22,0)","v":0},{"$f":"I22*H21","v":0},{"$f":"G22-J22","v":0},{"$f":"IF(K22>0,K22/L21,\"0\")","v":"0"},{"$f":"ROUNDUP(L22,0)","v":0}]
[]
[null,"Cove Length 3 (m)","Cove Length 3 (m)",1.81,"Number of fittings","Length of 1800mm fittings","Remaining m",0.91,"Number of fittings","Length of 900mm fittings","Remaining m",0.61,"Number of fittings","Length of 600mm fittings","Remaining m",0.31,"Number of fittings","Length of 300mm fittings","Remaining m",0.16,"Number of fittings","Length of 150mm fittings","Remaining m",null,"Type of Orelle",null,"Quantity of 1800mm",null,"Quantity of 900mm","Quantity of 600mm",null,"Quantity of 300mm","Quantity of 150mm",null,"Total Length (m)"]
[null,0,{"$f":"B25","v":0},{"$f":"C25/D24","v":0},{"$f":"ROUNDDOWN(D25,0)","v":0},{"$f":"E25*D24","v":0},{"$f":"C25-F25","v":0},{"$f":"G25/H24","v":0},{"$f":"ROUNDDOWN(H25,0)","v":0},{"$f":"I25*H24","v":0},{"$f":"G25-J25","v":0},{"$f":"K25/L24","v":0},{"$f":"ROUNDDOWN(L25,0)","v":0},{"$f":"M25*L24","v":0},{"$f":"K25-N25","v":0},{"$f":"O25/P24","v":0},{"$f":"ROUNDDOWN(P25,0)","v":0},{"$f":"Q25*P24","v":0},{"$f":"O25-R25","v":0},{"$f":"S25/T24","v":0},{"$f":"ROUNDDOWN(T25,0)","v":0},{"$f":"U25*T24","v":0},{"$f":"S25-V25","v":0},null,"Orelle Pro Single Colour (SB)",null,{"$f":"E25","v":0},null,{"$f":"I25","v":0},{"$f":"M25","v":0},null,{"$f":"Q25","v":0},{"$f":"U25","v":0},null,{"$f":"F25+J25+N25+R25+V25","v":0}]
[null,null,null,18,"Number of drivers 350W","Metre run by 350W","Remaining m",11,"Number of drivers 175W","Metre run by 175W","Remaining m",4,"Number of drivers 70W"]
[null,null,"Orelle Pro Single Colour (SB)",{"$f":"C25/D26","v":0},{"$f":"ROUND(D27,0)","v":0},{"$f":"E27*D26","v":0},{"$f":"C25-F27","v":0},{"$f":"IF(G27>0,G27/H26,\"0\")","v":"0"},{"$f":"ROUND(H27,0)","v":0},{"$f":"I27*H26","v":0},{"$f":"G27-J27","v":0},{"$f":"IF(K27>0,K27/L26,\"0\")","v":"0"},{"$f":"ROUNDUP(L27,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Dimming protocol",null,"Quantity of 320W drivers",null,"Driver and SAP code","Quantity of 175W drivers",null,"Driver and SAP code","Quantity of 70W drivers",null,"Driver and SAP code"]
[null,null,null,8,"Number of drivers 350W","Metre run by 350W","Remaining m",4,"Number of drivers 175W","Metre run by 175W","Remaining m",1.8,"Number of drivers 70W",null,null,null,null,null,null,null,null,null,null,null,"Non-Dimmable/HF",null,{"$f":"IF(Y25=C27,E27,IF(Y25=C29,E29,IF(Y25=C31,E31,\"Please check options\")))","v":0},{"$f":"CONCATENATE(Y25,\"/\",Y28,\"/\",\"320W\")","v":"Orelle Pro Single Colour (SB)/Non-Dimmable/HF/320W"},{"$f":"IFERROR(VLOOKUP(AB28,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"},{"$f":"IF(Y25=C27,I27,IF(Y25=C29,I29,IF(Y25=C31,I31,\"Please check options\")))","v":0},{"$f":"CONCATENATE(Y25,\"/\",Y28,\"/\",\"175W\")","v":"Orelle Pro Single Colour (SB)/Non-Dimmable/HF/175W"},{"$f":"IFERROR(VLOOKUP(AE28,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"},{"$f":"IF(Y25=C27,M27,IF(Y25=C29,M29,IF(Y25=C31,M31,\"Please check options\")))","v":0},{"$f":"CONCATENATE(Y25,\"/\",Y28,\"/\",\"70W\")","v":"Orelle Pro Single Colour (SB)/Non-Dimmable/HF/70W"},{"$f":"IFERROR(VLOOKUP(AH28,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"}]
[null,null,"Orelle Pro Dynamic White",{"$f":"C25/D28","v":0},{"$f":"ROUND(D29,0)","v":0},{"$f":"E29*D28","v":0},{"$f":"C25-F29","v":0},{"$f":"IF(G29>0,G29/H28,\"0\")","v":"0"},{"$f":"ROUND(H29,0)","v":0},{"$f":"I29*H28","v":0},{"$f":"G29-J29","v":0},{"$f":"IF(K29>0,K29/L28,\"0\")","v":"0"},{"$f":"ROUNDUP(L29,0)","v":0}]
[null,null,null,6,"Number of drivers 350W","Metre run by 350W","Remaining m",4,"Number of drivers 175W","Metre run by 175W","Remaining m",1,"Number of drivers 70W"]
[null,null,"Orelle Pro+ Single Colour (EB)",{"$f":"C25/D30","v":0},{"$f":"ROUND(D31,0)","v":0},{"$f":"E31*D30","v":0},{"$f":"C25-F31","v":0},{"$f":"IF(G31>0,G31/H30,\"0\")","v":"0"},{"$f":"ROUND(H31,0)","v":0},{"$f":"I31*H30","v":0},{"$f":"G31-J31","v":0},{"$f":"IF(K31>0,K31/L30,\"0\")","v":"0"},{"$f":"ROUNDUP(L31,0)","v":0}]
[]
[null,"Cove Length 4 (m)","Cove Length 4 (m)",1.81,"Number of fittings","Length of 1800mm fittings","Remaining m",0.91,"Number of fittings","Length of 900mm fittings","Remaining m",0.61,"Number of fittings","Length of 600mm fittings","Remaining m",0.31,"Number of fittings","Length of 300mm fittings","Remaining m",0.16,"Number of fittings","Length of 150mm fittings","Remaining m",null,"Type of Orelle",null,"Quantity of 1800mm",null,"Quantity of 900mm","Quantity of 600mm",null,"Quantity of 300mm","Quantity of 150mm",null,"Total Length (m)"]
[null,0,{"$f":"B34","v":0},{"$f":"C34/D33","v":0},{"$f":"ROUNDDOWN(D34,0)","v":0},{"$f":"E34*D33","v":0},{"$f":"C34-F34","v":0},{"$f":"G34/H33","v":0},{"$f":"ROUNDDOWN(H34,0)","v":0},{"$f":"I34*H33","v":0},{"$f":"G34-J34","v":0},{"$f":"K34/L33","v":0},{"$f":"ROUNDDOWN(L34,0)","v":0},{"$f":"M34*L33","v":0},{"$f":"K34-N34","v":0},{"$f":"O34/P33","v":0},{"$f":"ROUNDDOWN(P34,0)","v":0},{"$f":"Q34*P33","v":0},{"$f":"O34-R34","v":0},{"$f":"S34/T33","v":0},{"$f":"ROUNDDOWN(T34,0)","v":0},{"$f":"U34*T33","v":0},{"$f":"S34-V34","v":0},null,"Orelle Pro Single Colour (SB)",null,{"$f":"E34","v":0},null,{"$f":"I34","v":0},{"$f":"M34","v":0},null,{"$f":"Q34","v":0},{"$f":"U34","v":0},null,{"$f":"F34+J34+N34+R34+V34","v":0}]
[null,null,null,18,"Number of drivers 350W","Metre run by 350W","Remaining m",11,"Number of drivers 175W","Metre run by 175W","Remaining m",4,"Number of drivers 70W"]
[null,null,"Orelle Pro Single Colour (SB)",{"$f":"C34/D35","v":0},{"$f":"ROUND(D36,0)","v":0},{"$f":"E36*D35","v":0},{"$f":"C34-F36","v":0},{"$f":"IF(G36>0,G36/H35,\"0\")","v":"0"},{"$f":"ROUND(H36,0)","v":0},{"$f":"I36*H35","v":0},{"$f":"G36-J36","v":0},{"$f":"IF(K36>0,K36/L35,\"0\")","v":"0"},{"$f":"ROUNDUP(L36,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Dimming protocol",null,"Quantity of 320W drivers",null,"Driver and SAP code","Quantity of 175W drivers",null,"Driver and SAP code","Quantity of 70W drivers",null,"Driver and SAP code"]
[null,null,null,8,"Number of drivers 350W","Metre run by 350W","Remaining m",4,"Number of drivers 175W","Metre run by 175W","Remaining m",1.8,"Number of drivers 70W",null,null,null,null,null,null,null,null,null,null,null,"Non-Dimmable/HF",null,{"$f":"IF(Y34=C36,E36,IF(Y34=C38,E38,IF(Y34=C40,E40,\"Please check options\")))","v":0},{"$f":"CONCATENATE(Y34,\"/\",Y37,\"/\",\"320W\")","v":"Orelle Pro Single Colour (SB)/Non-Dimmable/HF/320W"},{"$f":"IFERROR(VLOOKUP(AB37,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"},{"$f":"IF(Y34=C36,I36,IF(Y34=C38,I38,IF(Y34=C40,I40,\"Please check options\")))","v":0},{"$f":"CONCATENATE(Y34,\"/\",Y37,\"/\",\"175W\")","v":"Orelle Pro Single Colour (SB)/Non-Dimmable/HF/175W"},{"$f":"IFERROR(VLOOKUP(AE37,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"},{"$f":"IF(Y34=C36,M36,IF(Y34=C38,M38,IF(Y34=C40,M40,\"Please check options\")))","v":0},{"$f":"CONCATENATE(Y34,\"/\",Y37,\"/\",\"70W\")","v":"Orelle Pro Single Colour (SB)/Non-Dimmable/HF/70W"},{"$f":"IFERROR(VLOOKUP(AH37,Sheet2!$H$2:$K$17,4,0),\"Please check options\")","v":"Please check options"}]
[null,null,"Orelle Pro Dynamic White",{"$f":"C34/D37","v":0},{"$f":"ROUND(D38,0)","v":0},{"$f":"E38*D37","v":0},{"$f":"C34-F38","v":0},{"$f":"IF(G38>0,G38/H37,\"0\")","v":"0"},{"$f":"ROUND(H38,0)","v":0},{"$f":"I38*H37","v":0},{"$f":"G38-J38","v":0},{"$f":"IF(K38>0,K38/L37,\"0\")","v":"0"},{"$f":"ROUNDUP(L38,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Type","Length","CRI/LED Colour","Lens Type",null,"Cowl",null,null,null,"Article Number"]
[null,null,null,6,"Number of drivers 350W","Metre run by 350W","Remaining m",4,"Number of drivers 175W","Metre run by 175W","Remaining m",1,"Number of drivers 70W",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Y$7=\"Please select from list\",\"Please select from list above\",$Y$7)","v":"Please select from list above"},"1800mm","Please select from list","Please select from list",null,"Please select from list",null,{"$f":"CONCATENATE(AA39,AB39,AC39,AD39,AF39)","v":"Please select from list above1800mmPlease select from listPlease select from listPlease select from list"},null,{"$f":"IFERROR(VLOOKUP(AH39,Sheet3!K:M,3,0),\"Please check options\")","v":"Please check options"}]
[null,null,"Orelle Pro+ Single Colour (EB)",{"$f":"C34/D39","v":0},{"$f":"ROUND(D40,0)","v":0},{"$f":"E40*D39","v":0},{"$f":"C34-F40","v":0},{"$f":"IF(G40>0,G40/H39,\"0\")","v":"0"},{"$f":"ROUND(H40,0)","v":0},{"$f":"I40*H39","v":0},{"$f":"G40-J40","v":0},{"$f":"IF(K40>0,K40/L39,\"0\")","v":"0"},{"$f":"ROUNDUP(L40,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Y$7=\"Please select from list\",\"Please select from list above\",$Y$7)","v":"Please select from list above"},"900mm",{"$f":"$AC$39","v":"Please select from list"},{"$f":"$AD$39","v":"Please select from list"},null,{"$f":"$AF$39","v":"Please select from list"},null,{"$f":"CONCATENATE(AA40,AB40,AC40,AD40,AF40)","v":"Please select from list above900mmPlease select from listPlease select from listPlease select from list"},null,{"$f":"IFERROR(VLOOKUP(AH40,Sheet3!K:M,3,0),\"Please check options\")","v":"Please check options"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Y$7=\"Please select from list\",\"Please select from list above\",$Y$7)","v":"Please select from list above"},"600mm",{"$f":"$AC$39","v":"Please select from list"},{"$f":"$AD$39","v":"Please select from list"},null,{"$f":"$AF$39","v":"Please select from list"},null,{"$f":"CONCATENATE(AA41,AB41,AC41,AD41,AF41)","v":"Please select from list above600mmPlease select from listPlease select from listPlease select from list"},null,{"$f":"IFERROR(VLOOKUP(AH41,Sheet3!K:M,3,0),\"Please check options\")","v":"Please check options"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Y$7=\"Please select from list\",\"Please select from list above\",$Y$7)","v":"Please select from list above"},"300mm","Please select from list",{"$f":"$AD$39","v":"Please select from list"},null,{"$f":"$AF$39","v":"Please select from list"},null,{"$f":"CONCATENATE(AA42,AB42,AC42,AD42,AF42)","v":"Please select from list above300mmPlease select from listPlease select from listPlease select from list"},null,{"$f":"IFERROR(VLOOKUP(AH42,Sheet3!K:M,3,0),\"Please check options\")","v":"Please check options"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Y$7=\"Please select from list\",\"Please select from list above\",$Y$7)","v":"Please select from list above"},"150mm","Please select from list",{"$f":"$AD$39","v":"Please select from list"},null,{"$f":"$AF$39","v":"Please select from list"},null,{"$f":"CONCATENATE(AA43,AB43,AC43,AD43,AF43)","v":"Please select from list above150mmPlease select from listPlease select from listPlease select from list"},null,{"$f":"IFERROR(VLOOKUP(AH43,Sheet3!K:M,3,0),\"Please check options\")","v":"Please check options"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cove Summary",null,null,"Quantity",null,"Article Number"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"Please select from list\",CONCATENATE(AA39,\", \",AB39,\", \",AC39,\", \",AD39,\" Lens \",AF39))),\"Please check options\",CONCATENATE(AA39,\", \",AB39,\", \",AC39,\", \",AD39,\" Lens, \",AF39))","v":"Please check options"},null,null,{"$f":"AA7","v":0},null,{"$f":"IF(AD46=0,\"\",(IF(AJ39=\"Please check options\",\"\",AJ39)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"Please select from list\",CONCATENATE(AA40,\", \",AB40,\", \",AC40,\", \",AD40,\" Lens \",AF40))),\"Please check options\",CONCATENATE(AA40,\", \",AB40,\", \",AC40,\", \",AD40,\" Lens, \",AF40))","v":"Please check options"},null,null,{"$f":"AC7","v":0},null,{"$f":"IF(AD47=0,\"\",(IF(AJ40=\"Please check options\",\"\",AJ40)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please check options",null,null,{"$f":"AD7","v":0},null,{"$f":"IF(AD48=0,\"\",(IF(AJ41=\"Please check options\",\"\",AJ41)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"Please select from list\",CONCATENATE(AA42,\", \",AB42,\", \",AC42,\", \",AD42,\" Lens \",AF42))),\"Please check options\",CONCATENATE(AA42,\", \",AB42,\", \",AC42,\", \",AD42,\" Lens, \",AF42))","v":"Please check options"},null,null,{"$f":"AF7","v":0},null,{"$f":"IF(AD49=0,\"\",(IF(AJ42=\"Please check options\",\"\",AJ42)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please check options",null,null,{"$f":"AG7","v":0},null,{"$f":"IF(AD50=0,\"\",(IF(AJ43=\"Please check options\",\"\",AJ43)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEFT(AC10,LEN(AC10)-11)=\"Please ch\",\"Please check options\",LEFT(AC10,LEN(AC10)-11))","v":"Please check options"},null,null,{"$f":"IF(AA10=\"Please check options\",\"0\",AA10)","v":"0"},null,{"$f":"IF(AD51=0,\"\",(IF(RIGHT(AC10,8)=\" options\",\"\",RIGHT(AC10,8))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEFT(AF10,LEN(AF10)-11)=\"Please ch\",\"Please check options\",LEFT(AF10,LEN(AF10)-11))","v":"Please check options"},null,null,{"$f":"IF(AD10=\"Please check options\",\"0\",AD10)","v":"0"},null,{"$f":"IF(AD52=0,\"\",(IF(RIGHT(AF10,8)=\" options\",\"\",RIGHT(AF10,8))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEFT(AI10,LEN(AI10)-11)=\"Please ch\",\"Please check options\",LEFT(AI10,LEN(AI10)-11))","v":"Please check options"},null,null,{"$f":"IF(AG10=\"Please check options\",\"0\",AG10)","v":"0"},null,{"$f":"IF(AD53=0,\"\",(IF(RIGHT(AI10,8)=\" options\",\"\",RIGHT(AI10,8))))","v":""}]

{"sheet":"Driver Starter Lead Info","index":6,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":true,"merged":[[2,6,2,7],[1,2,1,7]]}
[]
[null,null,"DRIVER AND STARTER LEAD INFORMATION"]
[null,null,"24v Transformer","LINELIGHT Stable white","LINELIGHT Stable white (EB)","LINELIGHT Balanced white","Number of Starter Leads per Driver"]
[null,null,null,"Meterage Capacity (m) ","Meterage Capacity (m) ","Meterage Capacity (m) ","LINELIGHT 1807a/1m","LINELIGHT 1807a/DW/1m"]
[null,null,"EVG"]
[null,null,"LINELIGHT 1992A/70W EVG (21100296)",4,1,null,1]
[null,null,"LINELIGHT 1992A/175W EVG (21100297)",11,4,null,1]
[null,null,"LINELIGHT 1992A/320W EVG (21100298)",18,6,null,2]
[]
[null,null,"LDO"]
[null,null,"LINELIGHT 1992A/70W LDO (21100299)",4,1,null,1]
[null,null,"LINELIGHT 1992A/175W LDO (21100300)",11,4,null,1]
[null,null,"LINELIGHT 1992A/320W LDO (21100301)",18,6,null,2]
[]
[null,null,"DW LDO"]
[null,null,"LINELIGHT 1992A/DW/70W LDO (99999999)",null,null,1.8,null,1]
[null,null,"LINELIGHT 1992A/DW/175W LDO (99999999)",null,null,4,null,1]
[null,null,"LINELIGHT 1992A/DW/350W LDO (99999999)",null,null,8,null,2]