{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Rekenblad","Rekenblad data"],"not_rendered":{"images":2,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Rekenblad","index":0,"n_rows":34,"n_cols":7,"rows_kept":34,"merged":[[5,2,5,6],[6,2,6,6],[7,2,7,6],[8,2,8,6],[9,2,9,6],[10,2,10,6]]}
[]
[]
["Aanvraag Quickscan ",null,"Oranje velden invullen s.v.p."]
[null,null,"Bij de lichtblauwe velden een keuze maken s.v.p. (klik op het pijltje)."]
[]
["Naam aanvrager:"]
["Bedrijfsnaam aanvrager:"]
["Mailadres aanvrager:"]
["Datum aanvraag:"]
["Project:"]
["Soort ruimte:"]
[]
[]
[]
[null,"Soort ruimte:","Lux norm:","Lengte (m)","Breedte (m)","Hoogte (m)","Oppervlakte (m2)"]
["Ruimte 1:",null,{"$f":"IF(B16=\"Kantoor\", \"500\", IF(B16=\"Magazijn\", \"100\",IF(B16= \"Productieruimte\",300,\"\")))","v":""},{"$nulls":3},{"$f":"D16*E16","v":0}]
["Ruimte 2:",null,{"$f":"IF(B17=\"Kantoor\", \"500\", IF(B17=\"Magazijn\", \"100\",IF(B17= \"Productieruimte\",300,\"\")))","v":""},{"$nulls":3},{"$f":"D17*E17","v":0}]
["Ruimte 3:",null,{"$f":"IF(B18=\"Kantoor\", \"500\", IF(B18=\"Magazijn\", \"100\",IF(B18= \"Productieruimte\",300,\"\")))","v":""},{"$nulls":3},{"$f":"D18*E18","v":0}]
[]
[]
[]
[null,null,"Ruimte 1","Ruimte 2","Ruimte 3"]
["Optie 1 - Benodigd aantal armaturen",null,{"$f":"IF('Rekenblad data'!E8=\"1\",'Rekenblad data'!E14,IF('Rekenblad data'!E8=\"4\",'Rekenblad data'!E22,IF('Rekenblad data'!E8=\"2\",'Rekenblad data'!E39,IF('Rekenblad data'!E8=\"3\",'Rekenblad data'!E56,IF('Rekenblad data'!E8=\"5\",'Rekenblad data'!E68,IF('Rekenblad data'!E8=\"7\",'Rekenblad data'!E31,IF('Rekenblad data'!E8=\"6\",'Rekenblad data'!E62,IF('Rekenblad data'!E8=\"8\",'Rekenblad data'!E74,IF('Rekenblad data'!E8=\"11\",'Rekenblad data'!E47,IF('Rekenblad data'!E8=\"12\",'Rekenblad data'!E92,IF('Rekenblad data'!E8=\"13\",'Rekenblad data'!E98,\"\")))))))))))","v":""},{"$f":"IF('Rekenblad data'!F8=\"1\",'Rekenblad data'!E15,IF('Rekenblad data'!F8=\"4\",'Rekenblad data'!E23,IF('Rekenblad data'!F8=\"2\",'Rekenblad data'!E40,IF('Rekenblad data'!F8=\"3\",'Rekenblad data'!E57,IF('Rekenblad data'!F8=\"5\",'Rekenblad data'!E69,IF('Rekenblad data'!F8=\"7\",'Rekenblad data'!E32,IF('Rekenblad data'!F8=\"6\",'Rekenblad data'!E63,IF('Rekenblad data'!F8=\"8\",'Rekenblad data'!E75,IF('Rekenblad data'!F8=\"11\",'Rekenblad data'!E48,IF('Rekenblad data'!F8=\"12\",'Rekenblad data'!E93,IF('Rekenblad data'!F8=\"13\",'Rekenblad data'!E99,\"\")))))))))))","v":""},{"$f":"IF('Rekenblad data'!G8=\"1\",'Rekenblad data'!E16,IF('Rekenblad data'!G8=\"4\",'Rekenblad data'!E24,IF('Rekenblad data'!G8=\"2\",'Rekenblad data'!E49,IF('Rekenblad data'!G8=\"3\",'Rekenblad data'!E58,IF('Rekenblad data'!G8=\"5\",'Rekenblad data'!E70,IF('Rekenblad data'!G8=\"7\",'Rekenblad data'!E33,IF('Rekenblad data'!G8=\"6\",'Rekenblad data'!E64,IF('Rekenblad data'!G8=\"8\",'Rekenblad data'!E76,IF('Rekenblad data'!G8=\"11\",'Rekenblad data'!E49,IF('Rekenblad data'!G8=\"12\",'Rekenblad data'!E94,IF('Rekenblad data'!G8=\"13\",'Rekenblad data'!E100,\"\")))))))))))","v":""}]
["Type",null,{"$f":"IF('Rekenblad data'!E8=\"1\",\"Winled Office\",IF(OR('Rekenblad data'!E8=\"2\",'Rekenblad data'!E8=\"11\"),\"Winled Skyline 4000lm\",IF('Rekenblad data'!E8=\"3\",\"Winled Highbay 120 W 120°\",IF('Rekenblad data'!E8=\"4\",\"Winled Highbay 120 W 90°\",IF('Rekenblad data'!E8=\"5\",\"Winled Highbay 120 W 45°\",IF('Rekenblad data'!E8=\"6\",\"Winled Highbay 160 W 120°\",IF('Rekenblad data'!E8=\"7\",\"Winled Highbay 160 W 90°\",IF('Rekenblad data'!E8=\"8\",\"Winled Highbay 160 W 45°\",IF(OR('Rekenblad data'!E8=\"9\",'Rekenblad data'!E8=\"12\"),\"Winled Skyline 7000lm\",IF(OR('Rekenblad data'!E8=\"10\",'Rekenblad data'!E8=\"13\"),\"Skyline 10000lm\",\"\"))))))))))","v":""},{"$f":"IF('Rekenblad data'!F8=\"1\",\"Winled Office\",IF(OR('Rekenblad data'!F8=\"2\",'Rekenblad data'!F8=\"11\"),\"Winled Skyline 4000lm\",IF('Rekenblad data'!F8=\"3\",\"Winled Highbay 120 W 120°\",IF('Rekenblad data'!F8=\"4\",\"Winled Highbay 120 W 90°\",IF('Rekenblad data'!F8=\"5\",\"Winled Highbay 120 W 45°\",IF('Rekenblad data'!F8=\"6\",\"Winled Highbay 160 W 120°\",IF('Rekenblad data'!F8=\"7\",\"Winled Highbay 160 W 90°\",IF('Rekenblad data'!F8=\"8\",\"Winled Highbay 160 W 45°\",IF(OR('Rekenblad data'!F8=\"9\",'Rekenblad data'!F8=\"12\"),\"Winled Skyline 7000lm\",IF(OR('Rekenblad data'!F8=\"10\",'Rekenblad data'!F8=\"13\"),\"Skyline 10000lm\",\"\"))))))))))","v":""},{"$f":"IF('Rekenblad data'!G8=\"1\",\"Winled Office\",IF(OR('Rekenblad data'!G8=\"2\",'Rekenblad data'!G8=\"11\"),\"Winled Skyline 4000lm\",IF('Rekenblad data'!G8=\"3\",\"Winled Highbay 120 W 120°\",IF('Rekenblad data'!G8=\"4\",\"Winled Highbay 120 W 90°\",IF('Rekenblad data'!G8=\"5\",\"Winled Highbay 120 W 45°\",IF('Rekenblad data'!G8=\"6\",\"Winled Highbay 160 W 120°\",IF('Rekenblad data'!G8=\"7\",\"Winled Highbay 160 W 90°\",IF('Rekenblad data'!G8=\"8\",\"Winled Highbay 160 W 45°\",IF(OR('Rekenblad data'!G8=\"9\",'Rekenblad data'!G8=\"12\"),\"Winled Skyline 7000lm\",IF(OR('Rekenblad data'!G8=\"10\",'Rekenblad data'!G8=\"13\"),\"Skyline 10000lm\",\"\"))))))))))","v":""}]
["Totaal vermogen (Watt)",null,{"$f":"IF('Rekenblad data'!E8=\"1\",'Rekenblad data'!F14,IF('Rekenblad data'!E8=\"4\",'Rekenblad data'!F22,IF('Rekenblad data'!E8=\"2\",'Rekenblad data'!F39,IF('Rekenblad data'!E8=\"3\",'Rekenblad data'!F56,IF('Rekenblad data'!E8=\"5\",'Rekenblad data'!F68,IF('Rekenblad data'!E8=\"7\",'Rekenblad data'!F31,IF('Rekenblad data'!E8=\"6\",'Rekenblad data'!F62,IF('Rekenblad data'!E8=\"8\",'Rekenblad data'!F74,IF('Rekenblad data'!E8=\"11\",'Rekenblad data'!F47,IF('Rekenblad data'!E8=\"12\",'Rekenblad data'!F92,IF('Rekenblad data'!E8=\"13\",'Rekenblad data'!F98,\"\")))))))))))","v":""},{"$f":"IF('Rekenblad data'!F8=\"1\",'Rekenblad data'!F15,IF('Rekenblad data'!F8=\"4\",'Rekenblad data'!F23,IF('Rekenblad data'!F8=\"2\",'Rekenblad data'!F40,IF('Rekenblad data'!F8=\"3\",'Rekenblad data'!F57,IF('Rekenblad data'!F8=\"5\",'Rekenblad data'!F69,IF('Rekenblad data'!F8=\"7\",'Rekenblad data'!F32,IF('Rekenblad data'!F8=\"6\",'Rekenblad data'!F63,IF('Rekenblad data'!F8=\"8\",'Rekenblad data'!F75,IF('Rekenblad data'!F8=\"11\",'Rekenblad data'!F48,IF('Rekenblad data'!F8=\"12\",'Rekenblad data'!F93,IF('Rekenblad data'!F8=\"13\",'Rekenblad data'!F99,\"\")))))))))))","v":""},{"$f":"IF('Rekenblad data'!G8=\"1\",'Rekenblad data'!F16,IF('Rekenblad data'!G8=\"4\",'Rekenblad data'!F24,IF('Rekenblad data'!G8=\"2\",'Rekenblad data'!F49,IF('Rekenblad data'!G8=\"3\",'Rekenblad data'!F58,IF('Rekenblad data'!G8=\"5\",'Rekenblad data'!F70,IF('Rekenblad data'!G8=\"7\",'Rekenblad data'!F33,IF('Rekenblad data'!G8=\"6\",'Rekenblad data'!F64,IF('Rekenblad data'!G8=\"8\",'Rekenblad data'!F76,IF('Rekenblad data'!G8=\"11\",'Rekenblad data'!F49,IF('Rekenblad data'!G8=\"12\",'Rekenblad data'!F94,IF('Rekenblad data'!G8=\"12\",'Rekenblad data'!F100,\"\")))))))))))","v":""}]
["Optie 2 - Benodigd aantal armaturen",null,{"$f":"IF('Rekenblad data'!E10=\"2\",'Rekenblad data'!E39,IF('Rekenblad data'!E10=\"9\",'Rekenblad data'!E86,IF('Rekenblad data'!E10=\"10\",'Rekenblad data'!E80,\"\")))","v":""},{"$f":"IF('Rekenblad data'!F10=\"2\",'Rekenblad data'!E40,IF('Rekenblad data'!F10=\"9\",'Rekenblad data'!E87,IF('Rekenblad data'!F10=\"10\",'Rekenblad data'!E81,\"\")))","v":""},{"$f":"IF('Rekenblad data'!G10=\"2\",'Rekenblad data'!E41,IF('Rekenblad data'!G10=\"9\",'Rekenblad data'!E88,IF('Rekenblad data'!G10=\"10\",'Rekenblad data'!E82,\"\")))","v":""}]
["Type",null,{"$f":"IF('Rekenblad data'!E10=\"2\",\"WinLed Skyline 4000lm\",IF('Rekenblad data'!E10=\"9\",\"Winled Skyline 7200lm\",IF('Rekenblad data'!E10=\"10\",\"Winled Skyline 10.000\",\"\")))","v":""},{"$f":"IF('Rekenblad data'!F10=\"2\",\"WinLed Skyline 4000lm\",IF('Rekenblad data'!F10=\"9\",\"Winled Skyline 7200lm\",IF('Rekenblad data'!F10=\"10\",\"Winled Skyline 10.000\",\"\")))","v":""},{"$f":"IF('Rekenblad data'!G10=\"2\",\"WinLed Skyline 4000lm\",IF('Rekenblad data'!G10=\"9\",\"Winled Skyline 7200lm\",IF('Rekenblad data'!G10=\"10\",\"Winled Skyline 10.000\",\"\")))","v":""}]
["Totaal vermogen (Watt)",null,{"$f":"IF('Rekenblad data'!E10=\"2\",'Rekenblad data'!F39,IF('Rekenblad data'!E10=\"9\",'Rekenblad data'!F86,IF('Rekenblad data'!E10=\"10\",'Rekenblad data'!F80,\"\")))","v":""},{"$f":"IF('Rekenblad data'!F10=\"2\",'Rekenblad data'!F40,IF('Rekenblad data'!F10=\"9\",'Rekenblad data'!F87,IF('Rekenblad data'!F10=\"10\",'Rekenblad data'!F81,\"\")))","v":""},{"$f":"IF('Rekenblad data'!G10=\"2\",'Rekenblad data'!F41,IF('Rekenblad data'!G10=\"9\",'Rekenblad data'!F88,IF('Rekenblad data'!G10=\"10\",'Rekenblad data'!F82,\"\")))","v":""}]
[]
[]
[]
[{"$nulls":6},","]
["Deze tool is voor indicatieve doeleinden voor algemene verlichting."]
["Wenst u een speciale toepassing, vraag dan een lichtadvies aan via:",null,null,"info@winled.nl"]

{"sheet":"Rekenblad data","index":1,"n_rows":100,"n_cols":11,"rows_kept":100,"hidden":true}
["Type armatuur:","Soort ruimte:","Gewenst lux niveau:",{"$nulls":4},"Gebruikte armaturen","Armatuur 1","Armatuur 2","Armatuur 3"]
[{"$nulls":7},"Kantoor","60 x 60 opaal 30 Watt"]
["Office 600x600 Prisma","Kantoor","500lx",{"$nulls":4},"Productieruimte","Lijnverlichting 4000 lm 31 Watt","Highbay 120 Watt 15000 lm 90*","Highbay 160 Watt 20000 lm 90*"]
["Office 600x600 Opaal","Productieruimte","300lx",{"$nulls":4},"Magazijn","Lijnverlichting 4000 lm 31 Watt"]
["Office 1200x300 Prisma","Magazijn","100lx"]
["Office 1200x300 Opaal","Parkeerplaats","200lx"]
["Skyline los armatuur","Laden / Lossen","Volgens de norm","voorstel","Ruimte 1","Ruimte 2","Ruimte 3","1=  office"]
["Skyline doorlopend",null,null,"Armentuur voorstel 1",{"$f":"IF(Rekenblad!B16=\"Kantoor\",\"1\",\nIF(AND(Rekenblad!B16=\"Productieruimte\",Rekenblad!F16>=3,Rekenblad!F16<4),\"2\",\nIF(AND(Rekenblad!B16=\"Productieruimte\",Rekenblad!F16>=4,Rekenblad!F16<4.5),\"3\",\nIF(AND(Rekenblad!B16=\"Productieruimte\",Rekenblad!F16>=4.5,Rekenblad!F16<8,G56<G62),\"3\",\n IF(AND(Rekenblad!B16=\"Productieruimte\",Rekenblad!F16>=4.5,Rekenblad!F16<8,G56>G62),\"6\",\nIF(AND(Rekenblad!B16=\"Productieruimte\",Rekenblad!F16>=8,Rekenblad!F16<9,G62<G22),\"6\",\nIF(AND(Rekenblad!B16=\"Productieruimte\",Rekenblad!F16>=8,Rekenblad!F16<9,G62>G22),\"4\",\nIF(AND(Rekenblad!B16=\"Productieruimte\",Rekenblad!F16>=9,Rekenblad!F16<9.5,G22<G31),\"4\",\nIF(AND(Rekenblad!B16=\"Productieruimte\",Rekenblad!F16>=9,Rekenblad!F16<9.5,G22>G31),\"7\",\nIF(AND(Rekenblad!B16=\"Productieruimte\",Rekenblad!F16>=9.5,Rekenblad!F16<10,G31<G68),\"7\",\nIF(AND(Rekenblad!B16=\"Productieruimte\",Rekenblad!F16>=9.5,Rekenblad!F16<10,G31>G68),\"5\",\nIF(AND(Rekenblad!B16=\"Productieruimte\",Rekenblad!F16>=10,Rekenblad!F16<13,G68<G74),\"5\",\nIF(AND(Rekenblad!B16=\"Productieruimte\",Rekenblad!F16>=10,Rekenblad!F16<13,G68>G74),\"8\",\nIF(AND(Rekenblad!B16=\"Productieruimte\",Rekenblad!F16>=13),\"8\",\nIF(AND(Rekenblad!B16=\"Magazijn\",Rekenblad!F16>=3,Rekenblad!F16<5.5), \"11\",\nIF(AND(Rekenblad!B16=\"Magazijn\",Rekenblad!F16>=5.5,Rekenblad!F16<6.5,G47<G92), \"11\",\nIF(AND(Rekenblad!B16=\"Magazijn\",Rekenblad!F16>=5.5,Rekenblad!F16<6.5,G47>G92), \"12\",\nIF(AND(Rekenblad!B16=\"Magazijn\",Rekenblad!F16>=6.5), \"13\",\"\"))))))))))))))))))","v":""},{"$f":"IF(Rekenblad!B17=\"Kantoor\",\"1\",\nIF(AND(Rekenblad!B17=\"Productieruimte\",Rekenblad!F17>=3,Rekenblad!F17<4),\"2\",\nIF(AND(Rekenblad!B17=\"Productieruimte\",Rekenblad!F17>=4,Rekenblad!F17<4.5),\"3\",\nIF(AND(Rekenblad!B17=\"Productieruimte\",Rekenblad!F17>=4.5,Rekenblad!F17<8,G57<G63),\"3\",\n IF(AND(Rekenblad!B17=\"Productieruimte\",Rekenblad!F17>=4.5,Rekenblad!F17<8,G57>G63),\"6\",\nIF(AND(Rekenblad!B17=\"Productieruimte\",Rekenblad!F17>=8,Rekenblad!F17<9,G63<G23),\"6\",\nIF(AND(Rekenblad!B17=\"Productieruimte\",Rekenblad!F17>=8,Rekenblad!F17<9,G63>G23),\"4\",\nIF(AND(Rekenblad!B17=\"Productieruimte\",Rekenblad!F17>=9,Rekenblad!F17<9.5,G23<G32),\"4\",\nIF(AND(Rekenblad!B17=\"Productieruimte\",Rekenblad!F17>=9,Rekenblad!F17<9.5,G23>G32),\"7\",\nIF(AND(Rekenblad!B17=\"Productieruimte\",Rekenblad!F17>=9.5,Rekenblad!F17<10,G32<G69),\"7\",\nIF(AND(Rekenblad!B17=\"Productieruimte\",Rekenblad!F17>=9.5,Rekenblad!F17<10,G32>G69),\"5\",\nIF(AND(Rekenblad!B17=\"Productieruimte\",Rekenblad!F17>=10,Rekenblad!F17<13,G69<G75),\"5\",\nIF(AND(Rekenblad!B17=\"Productieruimte\",Rekenblad!F17>=10,Rekenblad!F17<13,G69>G75),\"8\",\nIF(AND(Rekenblad!B17=\"Productieruimte\",Rekenblad!F17>=13),\"8\",\nIF(AND(Rekenblad!B17=\"Magazijn\",Rekenblad!F17>=3,Rekenblad!F17<5.5), \"11\",\nIF(AND(Rekenblad!B17=\"Magazijn\",Rekenblad!F17>=5.5,Rekenblad!F17<6.5,G48<G93), \"11\",\nIF(AND(Rekenblad!B17=\"Magazijn\",Rekenblad!F17>=5.5,Rekenblad!F17<6.5,G48>G93), \"12\",\nIF(AND(Rekenblad!B17=\"Magazijn\",Rekenblad!F17>=6.5), \"13\",\"\"))))))))))))))))))","v":""},{"$f":"IF(Rekenblad!B18=\"Kantoor\",\"1\",\nIF(AND(Rekenblad!B18=\"Productieruimte\",Rekenblad!F18>=3,Rekenblad!F18<4),\"2\",\nIF(AND(Rekenblad!B18=\"Productieruimte\",Rekenblad!F18>=4,Rekenblad!F18<4.5),\"3\",\nIF(AND(Rekenblad!B18=\"Productieruimte\",Rekenblad!F18>=4.5,Rekenblad!F18<8,G58<G64),\"3\",\n IF(AND(Rekenblad!B18=\"Productieruimte\",Rekenblad!F18>=4.5,Rekenblad!F18<8,G58>G64),\"6\",\nIF(AND(Rekenblad!B18=\"Productieruimte\",Rekenblad!F18>=8,Rekenblad!F18<9,G64<G24),\"6\",\nIF(AND(Rekenblad!B18=\"Productieruimte\",Rekenblad!F18>=8,Rekenblad!F18<9,G64>G24),\"4\",\nIF(AND(Rekenblad!B18=\"Productieruimte\",Rekenblad!F18>=9,Rekenblad!F18<9.5,G24<G33),\"4\",\nIF(AND(Rekenblad!B18=\"Productieruimte\",Rekenblad!F18>=9,Rekenblad!F18<9.5,G24>G33),\"7\",\nIF(AND(Rekenblad!B18=\"Productieruimte\",Rekenblad!F18>=9.5,Rekenblad!F18<10,G33<G70),\"7\",\nIF(AND(Rekenblad!B18=\"Productieruimte\",Rekenblad!F18>=9.5,Rekenblad!F18<10,G33>G70),\"5\",\nIF(AND(Rekenblad!B18=\"Productieruimte\",Rekenblad!F18>=10,Rekenblad!F18<13,G70<G76),\"5\",\nIF(AND(Rekenblad!B18=\"Productieruimte\",Rekenblad!F18>=10,Rekenblad!F18<13,G70>G76),\"8\",\nIF(AND(Rekenblad!B18=\"Productieruimte\",Rekenblad!F18>=13),\"8\",\nIF(AND(Rekenblad!B18=\"Magazijn\",Rekenblad!F18>=3,Rekenblad!F18<5.5), \"11\",\nIF(AND(Rekenblad!B18=\"Magazijn\",Rekenblad!F18>=5.5,Rekenblad!F18<6.5,G49<G94), \"11\",\nIF(AND(Rekenblad!B18=\"Magazijn\",Rekenblad!F18>=5.5,Rekenblad!F18<6.5,G49>G94), \"12\",\nIF(AND(Rekenblad!B18=\"Magazijn\",Rekenblad!F18>=6.5), \"13\",\"\"))))))))))))))))))","v":""},"2=  skyline 4000lm productie"]
["Higbay",{"$nulls":6},"3= highbay 120° 120w"]
["Outdoor",null,null,"Armentuur voorstel 2",{"$f":"IF(AND(Rekenblad!B16=\"Productieruimte\",Rekenblad!F16>=4,Rekenblad!F16<4.5),\"2\",\nIF(AND(Rekenblad!B16=\"Productieruimte\",Rekenblad!F16>=4.5,Rekenblad!F16<5.5,G39<G86),\"2\",\nIF(AND(Rekenblad!B16=\"Productieruimte\",Rekenblad!F16>=4.5,Rekenblad!F16<5.5,G39>G86),\"9\",\nIF(AND(Rekenblad!B16=\"Productieruimte\",Rekenblad!F16>=5.5),\"10\",\"\"))))","v":""},{"$f":"IF(AND(Rekenblad!B17=\"Productieruimte\",Rekenblad!F17>=4,Rekenblad!F17<4.5),\"2\",\nIF(AND(Rekenblad!B17=\"Productieruimte\",Rekenblad!F17>=4.5,Rekenblad!F17<5.5,G39<G86),\"2\",\nIF(AND(Rekenblad!B17=\"Productieruimte\",Rekenblad!F17>=4.5,Rekenblad!F17<5.5,G39>G86),\"9\",\nIF(AND(Rekenblad!B17=\"Productieruimte\",Rekenblad!F17>=5.5),\"10\",\"\"))))","v":""},{"$f":"IF(AND(Rekenblad!B18=\"Productieruimte\",Rekenblad!F18>=4,Rekenblad!F18<4.5),\"2\",\nIF(AND(Rekenblad!B18=\"Productieruimte\",Rekenblad!F18>=4.5,Rekenblad!F18<5.5,G39<G86),\"2\",\nIF(AND(Rekenblad!B18=\"Productieruimte\",Rekenblad!F18>=4.5,Rekenblad!F18<5.5,G39>G86),\"9\",\nIF(AND(Rekenblad!B18=\"Productieruimte\",Rekenblad!F18>=5.5),\"10\",\"\"))))","v":""},"4= highbay 90° 120w"]
[{"$nulls":7},"5= highbay 45° 120w"]
["quickscan berekening 60x60 opaal",{"$nulls":6},"6= highbay 120° 160w"]
["opp","Hoogte","Armature/m2","Onafgerond","Afgerond","vermogen",null,"7= highbay 90° 160w"]
[{"$f":"Rekenblad!G16","v":0},{"$f":"Rekenblad!F16","v":0},{"$f":"IF(AND(A14<50,B14<2.6),0.02,IF(AND(A14>=50,B14<2.6),0.15,IF(AND(B14>=2.6,B14<3.4,A14<70),0.22,IF(AND(B14>=2.6,B14<3.4,A14>=70,A14<250),0.17,IF(AND(B14>=2.6,B14<3.4,A14>=250),0.15,IF(AND(B14>=3.4,A14<70),0.25,IF(AND(B14>=3.4,A14>=70,A14<250),0.175,IF(AND(B14>=3.4,A14>=250),0.155))))))))","v":0.02},{"$f":"A14*C14","v":0},{"$f":"EVEN(D14)","v":0},{"$f":"30*E14","v":0},null,"8= highbay 45° 160w"]
[{"$f":"Rekenblad!G17","v":0},{"$f":"Rekenblad!F17","v":0},{"$f":"IF(AND(A15<50,B15<2.6),0.02,IF(AND(A15>=50,B15<2.6),0.15,IF(AND(B15>=2.6,B15<3.4,A15<70),0.22,IF(AND(B15>=2.6,B15<3.4,A15>=70,A15<250),0.17,IF(AND(B15>=2.6,B15<3.4,A15>=250),0.15,IF(AND(B15>=3.4,A15<70),0.25,IF(AND(B15>=3.4,A15>=70,A15<250),0.175,IF(AND(B15>=3.4,A15>=250),0.155))))))))","v":0.02},{"$f":"A15*C15","v":0},{"$f":"EVEN(D15)","v":0},{"$f":"30*E15","v":0},null,"9= skyline 7000lm productie"]
[{"$f":"Rekenblad!G18","v":0},{"$f":"Rekenblad!F18","v":0},{"$f":"IF(AND(A16<50,B16<2.6),0.02,IF(AND(A16>=50,B16<2.6),0.15,IF(AND(B16>=2.6,B16<3.4,A16<70),0.22,IF(AND(B16>=2.6,B16<3.4,A16>=70,A16<250),0.17,IF(AND(B16>=2.6,B16<3.4,A16>=250),0.15,IF(AND(B16>=3.4,A16<70),0.25,IF(AND(B16>=3.4,A16>=70,A16<250),0.175,IF(AND(B16>=3.4,A16>=250),0.155))))))))","v":0.02},{"$f":"A16*C16","v":0},{"$f":"EVEN(D16)","v":0},{"$f":"30*E16","v":0},null,"10= skyline 10000lm productie"]
[{"$nulls":7},"11= skyline 4000lm magazijn"]
[{"$nulls":7},"12= skyline 7000lm magazijn"]
[{"$nulls":7},"13= skyline 10000lm magazijn"]
["quickscan berekening highbay 120w 90 graden"]
["opp","Hoogte","amrature/m2","onafgerond","afgerond","vermogen","productkosten klant"]
[{"$f":"Rekenblad!G16","v":0},{"$f":"Rekenblad!F16","v":0},{"$f":"IF(AND(A22<500,B22<6),0.03,IF(AND(A22>=500,A22<1000,B22<6),0.025,IF(AND(A22>=1000,B22<6),0.022,IF(AND(A22<1000,B22>=6,B22<8),0.032,IF(AND(A22>=1000,A22<5000,B22>=6,B22<8),0.026,IF(AND(A22>=5000,B22>=6,B22<8),0.024,IF(AND(A22<700,B22>=8,B22<10),0.03,IF(AND(A22>=700,A22<8000,B22>=8,B22<10),0.025,IF(AND(A22>=8000,B22>=8,B22<10),0.022,IF(AND(A22<1000,B22>=10,B22<12.5),0.035,IF(AND(A22>=1000,A22<5000,B22>=10,B22<12.5),0.026,IF(AND(A22>=5000,B22>=10,B22<12.5),0.024,IF(AND(A22<500,B22>=12.5,B22<17.5),0.04,IF(AND(A22>=500,A22<1500,B22>=12.5,B22<17.5),0.03,IF(AND(A22>=1500,A22<9000,B22>=12.5,B22<17.5),0.026,IF(AND(A22>=9000,B22>=12.5,B22<17.5),0.024,IF(AND(A22<500,B22>=17.5),0.05,IF(AND(A22>=500,A22<1000,B22>=17.5),0.04,IF(AND(A22>=1000,A22<5000,B22>=17.5),0.03,IF(AND(A22>=5000,B22>=17.5),0.025))))))))))))))))))))","v":0.03},{"$f":"A22*C22","v":0},{"$f":"EVEN(D22)","v":0},{"$f":"120*E22","v":0},{"$f":"E22*440","v":0}]
[{"$f":"Rekenblad!G17","v":0},{"$f":"Rekenblad!F17","v":0},{"$f":"IF(AND(A23<500,B23<6),0.03,IF(AND(A23>=500,A23<1000,B23<6),0.025,IF(AND(A23>=1000,B23<6),0.022,IF(AND(A23<1000,B23>=6,B23<8),0.032,IF(AND(A23>=1000,A23<5000,B23>=6,B23<8),0.026,IF(AND(A23>=5000,B23>=6,B23<8),0.024,IF(AND(A23<700,B23>=8,B23<10),0.03,IF(AND(A23>=700,A23<8000,B23>=8,B23<10),0.025,IF(AND(A23>=8000,B23>=8,B23<10),0.022,IF(AND(A23<1000,B23>=10,B23<12.5),0.035,IF(AND(A23>=1000,A23<5000,B23>=10,B23<12.5),0.026,IF(AND(A23>=5000,B23>=10,B23<12.5),0.024,IF(AND(A23<500,B23>=12.5,B23<17.5),0.04,IF(AND(A23>=500,A23<1500,B23>=12.5,B23<17.5),0.03,IF(AND(A23>=1500,A23<9000,B23>=12.5,B23<17.5),0.026,IF(AND(A23>=9000,B23>=12.5,B23<17.5),0.024,IF(AND(A23<500,B23>=17.5),0.05,IF(AND(A23>=500,A23<1000,B23>=17.5),0.04,IF(AND(A23>=1000,A23<5000,B23>=17.5),0.03,IF(AND(A23>=5000,B23>=17.5),0.025))))))))))))))))))))","v":0.03},{"$f":"A23*C23","v":0},{"$f":"EVEN(D23)","v":0},{"$f":"120*E23","v":0},0]
[{"$f":"Rekenblad!G18","v":0},{"$f":"Rekenblad!F18","v":0},{"$f":"IF(AND(A24<500,B24<6),0.03,IF(AND(A24>=500,A24<1000,B24<6),0.025,IF(AND(A24>=1000,B24<6),0.022,IF(AND(A24<1000,B24>=6,B24<8),0.032,IF(AND(A24>=1000,A24<5000,B24>=6,B24<8),0.026,IF(AND(A24>=5000,B24>=6,B24<8),0.024,IF(AND(A24<700,B24>=8,B24<10),0.03,IF(AND(A24>=700,A24<8000,B24>=8,B24<10),0.025,IF(AND(A24>=8000,B24>=8,B24<10),0.022,IF(AND(A24<1000,B24>=10,B24<12.5),0.035,IF(AND(A24>=1000,A24<5000,B24>=10,B24<12.5),0.026,IF(AND(A24>=5000,B24>=10,B24<12.5),0.024,IF(AND(A24<500,B24>=12.5,B24<17.5),0.04,IF(AND(A24>=500,A24<1500,B24>=12.5,B24<17.5),0.03,IF(AND(A24>=1500,A24<9000,B24>=12.5,B24<17.5),0.026,IF(AND(A24>=9000,B24>=12.5,B24<17.5),0.024,IF(AND(A24<500,B24>=17.5),0.05,IF(AND(A24>=500,A24<1000,B24>=17.5),0.04,IF(AND(A24>=1000,A24<5000,B24>=17.5),0.03,IF(AND(A24>=5000,B24>=17.5),0.025))))))))))))))))))))","v":0.03},{"$f":"A24*C24","v":0},{"$f":"EVEN(D24)","v":0},{"$f":"120*E24","v":0},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[]
[]
["quickscan berekening highbay 160w 90 graden"]
["opp","Hoogte","amrature/m2","onafgerond","afgerond","vermogen","productkosten klant"]
[{"$f":"Rekenblad!G16","v":0},{"$f":"Rekenblad!F16","v":0},{"$f":"IF(AND(A31<2500,B31<6),0.019,IF(AND(A31>=2500,B31<6),0.017,IF(AND(A31<1000,B31>=6,B31<8),0.02,IF(AND(A31>=1000,A31<8000,B31>=6,B31<8),0.018,IF(AND(A31>=8000,B31>=6,B31<8),0.0165,IF(AND(A31<500,B31>=8,B31<10),0.023,IF(AND(A31>=500,A31<2000,B31>=8,B31<10),0.02,IF(AND(A31>=2000,A31<9000,B31>=8,B31<10),0.018,IF(AND(A31>=9000,B31>=8,B31<10),0.0165,IF(AND(A31<500,B31>=10,B31<12.5),0.026,IF(AND(A31>=500,A31<2500,B31>=10,B31<12.5),0.02,IF(AND(A31>=2500,A31<7000,B31>=10,B31<12.5),0.018,IF(AND(A31>=7000,B31>=10,B31<12.5),0.0175,IF(AND(A31<500,B31>=12.5,B31<17.5),0.032,IF(AND(A31>=500,A31<2000,B31>=12.5,B31<17.5),0.025,IF(AND(A31>=2000,A31<5000,B31>=12.5,B31<17.5),0.02,IF(AND(A31>=5000,B31>=12.5,B31<17.5),0.018,IF(AND(A31<500,B31>=17.5),0.041,IF(AND(A31>=500,A31<1200,B31>=17.5),0.03,IF(AND(A31>=1200,A31<4000,B31>=17.5),0.022,IF(AND(A31>=4000,A31<7000,B31>=17.5),0.02,IF(AND(A31>=7000,B31>=17.5),0.0185))))))))))))))))))))))","v":0.019},{"$f":"A31*C31","v":0},{"$f":"EVEN(D31)","v":0},{"$f":"160*E31","v":0},{"$f":"E31*490","v":0}]
[{"$f":"Rekenblad!G17","v":0},{"$f":"Rekenblad!F17","v":0},{"$f":"IF(AND(A32<2500,B32<6),0.019,IF(AND(A32>=2500,B32<6),0.017,IF(AND(A32<1000,B32>=6,B32<8),0.02,IF(AND(A32>=1000,A32<8000,B32>=6,B32<8),0.018,IF(AND(A32>=8000,B32>=6,B32<8),0.0165,IF(AND(A32<500,B32>=8,B32<10),0.023,IF(AND(A32>=500,A32<2000,B32>=8,B32<10),0.02,IF(AND(A32>=2000,A32<9000,B32>=8,B32<10),0.018,IF(AND(A32>=9000,B32>=8,B32<10),0.0165,IF(AND(A32<500,B32>=10,B32<12.5),0.026,IF(AND(A32>=500,A32<2500,B32>=10,B32<12.5),0.02,IF(AND(A32>=2500,A32<7000,B32>=10,B32<12.5),0.018,IF(AND(A32>=7000,B32>=10,B32<12.5),0.0175,IF(AND(A32<500,B32>=12.5,B32<17.5),0.032,IF(AND(A32>=500,A32<2000,B32>=12.5,B32<17.5),0.025,IF(AND(A32>=2000,A32<5000,B32>=12.5,B32<17.5),0.02,IF(AND(A32>=5000,B32>=12.5,B32<17.5),0.018,IF(AND(A32<500,B32>=17.5),0.041,IF(AND(A32>=500,A32<1200,B32>=17.5),0.03,IF(AND(A32>=1200,A32<4000,B32>=17.5),0.022,IF(AND(A32>=4000,A32<7000,B32>=17.5),0.02,IF(AND(A32>=7000,B32>=17.5),0.0185))))))))))))))))))))))","v":0.019},{"$f":"A32*C32","v":0},{"$f":"EVEN(D32)","v":0},{"$f":"160*E32","v":0},0]
[{"$f":"Rekenblad!G18","v":0},{"$f":"Rekenblad!F18","v":0},{"$f":"IF(AND(A33<2500,B33<6),0.019,IF(AND(A33>=2500,B33<6),0.017,IF(AND(A33<1000,B33>=6,B33<8),0.02,IF(AND(A33>=1000,A33<8000,B33>=6,B33<8),0.018,IF(AND(A33>=8000,B33>=6,B33<8),0.0165,IF(AND(A33<500,B33>=8,B33<10),0.023,IF(AND(A33>=500,A33<2000,B33>=8,B33<10),0.02,IF(AND(A33>=2000,A33<9000,B33>=8,B33<10),0.018,IF(AND(A33>=9000,B33>=8,B33<10),0.0165,IF(AND(A33<500,B33>=10,B33<12.5),0.026,IF(AND(A33>=500,A33<2500,B33>=10,B33<12.5),0.02,IF(AND(A33>=2500,A33<7000,B33>=10,B33<12.5),0.018,IF(AND(A33>=7000,B33>=10,B33<12.5),0.0175,IF(AND(A33<500,B33>=12.5,B33<17.5),0.032,IF(AND(A33>=500,A33<2000,B33>=12.5,B33<17.5),0.025,IF(AND(A33>=2000,A33<5000,B33>=12.5,B33<17.5),0.02,IF(AND(A33>=5000,B33>=12.5,B33<17.5),0.018,IF(AND(A33<500,B33>=17.5),0.041,IF(AND(A33>=500,A33<1200,B33>=17.5),0.03,IF(AND(A33>=1200,A33<4000,B33>=17.5),0.022,IF(AND(A33>=4000,A33<7000,B33>=17.5),0.02,IF(AND(A33>=7000,B33>=17.5),0.0185))))))))))))))))))))))","v":0.019},{"$f":"A33*C33","v":0},{"$f":"EVEN(D33)","v":0},{"$f":"160*E33","v":0},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[]
["quickscan berekening lijnverlichting productieruimte 4000lm"]
["opp","Hoogte","armature/m2","onafgerond","afgerond","vermogen","productkosten klant"]
[{"$f":"Rekenblad!G16","v":0},{"$f":"Rekenblad!F16","v":0},{"$f":"IF(AND(A39<800,B39<6),0.09,IF(AND(A39>=800,A39<5000,B39<6),0.078,IF(AND(A39>=5000,B39<6),0.073,IF(AND(A39<500,B39>=6,B39<8),0.1,IF(AND(A39>=500,A39<2000,B39>=6,B39<8),0.087,IF(AND(A39>=2000,A39<5000,B39>=6,B39<8),0.077,IF(AND(A39>=5000,B39>=6,B39<8),0.075,IF(AND(A39<1000,B39>=8,B39<10),0.108,IF(AND(A39>=1000,A39<5000,B39>=8,B39<10),0.082,IF(AND(A39>=5000,A39<8000,B39>=8,B39<10),0.079,IF(AND(A39>=8000,B39>=8,B39<10),0.075,IF(AND(A39<500,B39>=10,B39<12.5),0.133,IF(AND(A39>=500,A39<1000,B39>=10,B39<12.5),0.11,IF(AND(A39>=1000,A39<3500,B39>=10,B39<12.5),0.09,IF(AND(A39>=3500,A39<6000,B39>=10,B39<12.5),0.084,IF(AND(A39>=6000,B39>=10,B39<12.5),0.078,IF(AND(A39<400,B39>=12.5,B39<17.5),0.162,IF(AND(A39>=400,A39<1000,B39>=12.5,B39<17.5),0.129,IF(AND(A39>=1000,A39<4000,B39>=12.5,B39<17.5),0.095,IF(AND(A39>=4000,A39<7000,B39>=12.5,B39<17.5),0.086,IF(AND(A39>=7000,B39>=12.5,B39<17.5),0.082,IF(AND(A39<400,B39>=17.5),0.22,IF(AND(A39>=400,A39<800,B39>=17.5),0.162,IF(AND(A39>=800,A39<2000,B39>=17.5),0.126,IF(AND(A39>=2000,A39<5000,B39>=17.5),0.1,IF(AND(A39>=5000,A39<7000,B39>=17.5),0.092,IF(AND(A39>=7000,B39>=17.5),0.087)))))))))))))))))))))))))))","v":0.09},{"$f":"A39*C39","v":0},{"$f":"EVEN(D39)","v":0},{"$f":"31*E39","v":0},{"$f":"E39*300","v":0}]
[{"$f":"Rekenblad!G17","v":0},{"$f":"Rekenblad!F17","v":0},{"$f":"IF(AND(A40<800,B40<6),0.09,IF(AND(A40>=800,A40<5000,B40<6),0.078,IF(AND(A40>=5000,B40<6),0.073,IF(AND(A40<500,B40>=6,B40<8),0.1,IF(AND(A40>=500,A40<2000,B40>=6,B40<8),0.087,IF(AND(A40>=2000,A40<5000,B40>=6,B40<8),0.077,IF(AND(A40>=5000,B40>=6,B40<8),0.075,IF(AND(A40<1000,B40>=8,B40<10),0.108,IF(AND(A40>=1000,A40<5000,B40>=8,B40<10),0.082,IF(AND(A40>=5000,A40<8000,B40>=8,B40<10),0.079,IF(AND(A40>=8000,B40>=8,B40<10),0.075,IF(AND(A40<500,B40>=10,B40<12.5),0.133,IF(AND(A40>=500,A40<1000,B40>=10,B40<12.5),0.11,IF(AND(A40>=1000,A40<3500,B40>=10,B40<12.5),0.09,IF(AND(A40>=3500,A40<6000,B40>=10,B40<12.5),0.084,IF(AND(A40>=6000,B40>=10,B40<12.5),0.078,IF(AND(A40<400,B40>=12.5,B40<17.5),0.162,IF(AND(A40>=400,A40<1000,B40>=12.5,B40<17.5),0.129,IF(AND(A40>=1000,A40<4000,B40>=12.5,B40<17.5),0.095,IF(AND(A40>=4000,A40<7000,B40>=12.5,B40<17.5),0.086,IF(AND(A40>=7000,B40>=12.5,B40<17.5),0.082,IF(AND(A40<400,B40>=17.5),0.22,IF(AND(A40>=400,A40<800,B40>=17.5),0.162,IF(AND(A40>=800,A40<2000,B40>=17.5),0.126,IF(AND(A40>=2000,A40<5000,B40>=17.5),0.1,IF(AND(A40>=5000,A40<7000,B40>=17.5),0.092,IF(AND(A40>=7000,B40>=17.5),0.087)))))))))))))))))))))))))))","v":0.09},{"$f":"A40*C40","v":0},{"$f":"EVEN(D40)","v":0},{"$f":"31*E40","v":0},0]
[{"$f":"Rekenblad!G18","v":0},{"$f":"Rekenblad!F18","v":0},{"$f":"IF(AND(A41<800,B41<6),0.09,IF(AND(A41>=800,A41<5000,B41<6),0.078,IF(AND(A41>=5000,B41<6),0.073,IF(AND(A41<500,B41>=6,B41<8),0.1,IF(AND(A41>=500,A41<2000,B41>=6,B41<8),0.087,IF(AND(A41>=2000,A41<5000,B41>=6,B41<8),0.077,IF(AND(A41>=5000,B41>=6,B41<8),0.075,IF(AND(A41<1000,B41>=8,B41<10),0.108,IF(AND(A41>=1000,A41<5000,B41>=8,B41<10),0.082,IF(AND(A41>=5000,A41<8000,B41>=8,B41<10),0.079,IF(AND(A41>=8000,B41>=8,B41<10),0.075,IF(AND(A41<500,B41>=10,B41<12.5),0.133,IF(AND(A41>=500,A41<1000,B41>=10,B41<12.5),0.11,IF(AND(A41>=1000,A41<3500,B41>=10,B41<12.5),0.09,IF(AND(A41>=3500,A41<6000,B41>=10,B41<12.5),0.084,IF(AND(A41>=6000,B41>=10,B41<12.5),0.078,IF(AND(A41<400,B41>=12.5,B41<17.5),0.162,IF(AND(A41>=400,A41<1000,B41>=12.5,B41<17.5),0.129,IF(AND(A41>=1000,A41<4000,B41>=12.5,B41<17.5),0.095,IF(AND(A41>=4000,A41<7000,B41>=12.5,B41<17.5),0.086,IF(AND(A41>=7000,B41>=12.5,B41<17.5),0.082,IF(AND(A41<400,B41>=17.5),0.22,IF(AND(A41>=400,A41<800,B41>=17.5),0.162,IF(AND(A41>=800,A41<2000,B41>=17.5),0.126,IF(AND(A41>=2000,A41<5000,B41>=17.5),0.1,IF(AND(A41>=5000,A41<7000,B41>=17.5),0.092,IF(AND(A41>=7000,B41>=17.5),0.087)))))))))))))))))))))))))))","v":0.09},{"$f":"A41*C41","v":0},{"$f":"EVEN(D41)","v":0},{"$f":"31*E41","v":0},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[]
["quickscan berkenening lijverlichting magazijn 4000lm"]
["opp","Hoogte","armature/m2","onafgerond","afgerond","vermogen","productkosten"]
[{"$f":"Rekenblad!G16","v":0},{"$f":"Rekenblad!F16","v":0},{"$f":"IF(AND(A47<1000,B47<6),0.026,IF(AND(A47>=1000,A47<5000,B47<6),0.022,IF(AND(A47>=5000,B47<6),0.02,IF(AND(A47<500,B47>=6,B47<8),0.031,IF(AND(A47>=500,A47<2000,B47>=6,B47<8),0.026,IF(AND(A47>=2000,A47<5000,B47>=6,B47<8),0.023,IF(AND(A47>=5000,B47>=6,B47<8),0.021,IF(AND(A47<400,B47>=8,B47<10),0.0375,IF(AND(A47>=400,A47<1000,B47>=8,B47<10),0.03,IF(AND(A47>=1000,A47<5000,B47>=8,B47<10),0.025,IF(AND(A47>=5000,B47>=8,B47<10),0.021,IF(AND(A47<500,B47>=10,B47<12.5),0.04,IF(AND(A47>=500,A47<2000,B47>=10,B47<12.5),0.0308,IF(AND(A47>=2000,A47<4000,B47>=10,B47<12.5),0.026,IF(AND(A47>=4000,A47<7000,B47>=10,B47<12.5),0.024,IF(AND(A47>=7000,B47>=10,B47<12.5),0.0225,IF(AND(A47<500,B47>=12.5,B47<17.5),0.05,IF(AND(A47>=500,A47<1000,B47>=12.5,B47<17.5),0.042,IF(AND(A47>=1000,A47<2500,B47>=12.5,B47<17.5),0.032,IF(AND(A47>=2500,A47<5000,B47>=12.5,B47<17.5),0.028,IF(AND(A47>=5000,B47>=12.5,B47<17.5),0.024,IF(AND(A47<500,B47>=17.5),0.063,IF(AND(A47>=500,A47<1000,B47>=17.5),0.0455,IF(AND(A47>=1000,A47<2000,B47>=17.5),0.04,IF(AND(A47>=2000,A47<4000,B47>=17.5),0.033,IF(AND(A47>=4000,A47<6000,B47>=17.5),0.0295,IF(AND(A47>=6000,B47>=17.5),0.0255)))))))))))))))))))))))))))","v":0.026},{"$f":"A47*C47","v":0},{"$f":"EVEN(D47)","v":0},{"$f":"31*E47","v":0},{"$f":"300*E47","v":0}]
[{"$f":"Rekenblad!G17","v":0},{"$f":"Rekenblad!F17","v":0},{"$f":"IF(AND(A48<1000,B48<6),0.026,IF(AND(A48>=1000,A48<5000,B48<6),0.022,IF(AND(A48>=5000,B48<6),0.02,IF(AND(A48<500,B48>=6,B48<8),0.031,IF(AND(A48>=500,A48<2000,B48>=6,B48<8),0.026,IF(AND(A48>=2000,A48<5000,B48>=6,B48<8),0.023,IF(AND(A48>=5000,B48>=6,B48<8),0.021,IF(AND(A48<400,B48>=8,B48<10),0.0375,IF(AND(A48>=400,A48<1000,B48>=8,B48<10),0.03,IF(AND(A48>=1000,A48<5000,B48>=8,B48<10),0.025,IF(AND(A48>=5000,B48>=8,B48<10),0.021,IF(AND(A48<500,B48>=10,B48<12.5),0.04,IF(AND(A48>=500,A48<2000,B48>=10,B48<12.5),0.0308,IF(AND(A48>=2000,A48<4000,B48>=10,B48<12.5),0.026,IF(AND(A48>=4000,A48<7000,B48>=10,B48<12.5),0.024,IF(AND(A48>=7000,B48>=10,B48<12.5),0.0225,IF(AND(A48<500,B48>=12.5,B48<17.5),0.05,IF(AND(A48>=500,A48<1000,B48>=12.5,B48<17.5),0.042,IF(AND(A48>=1000,A48<2500,B48>=12.5,B48<17.5),0.032,IF(AND(A48>=2500,A48<5000,B48>=12.5,B48<17.5),0.028,IF(AND(A48>=5000,B48>=12.5,B48<17.5),0.024,IF(AND(A48<500,B48>=17.5),0.063,IF(AND(A48>=500,A48<1000,B48>=17.5),0.0455,IF(AND(A48>=1000,A48<2000,B48>=17.5),0.04,IF(AND(A48>=2000,A48<4000,B48>=17.5),0.033,IF(AND(A48>=4000,A48<6000,B48>=17.5),0.0295,IF(AND(A48>=6000,B48>=17.5),0.0255)))))))))))))))))))))))))))","v":0.026},{"$f":"A48*C48","v":0},{"$f":"EVEN(D48)","v":0},{"$f":"31*E48","v":0},0]
[{"$f":"Rekenblad!G18","v":0},{"$f":"Rekenblad!F18","v":0},{"$f":"IF(AND(A49<1000,B49<6),0.026,IF(AND(A49>=1000,A49<5000,B49<6),0.022,IF(AND(A49>=5000,B49<6),0.02,IF(AND(A49<500,B49>=6,B49<8),0.031,IF(AND(A49>=500,A49<2000,B49>=6,B49<8),0.026,IF(AND(A49>=2000,A49<5000,B49>=6,B49<8),0.023,IF(AND(A49>=5000,B49>=6,B49<8),0.021,IF(AND(A49<400,B49>=8,B49<10),0.0375,IF(AND(A49>=400,A49<1000,B49>=8,B49<10),0.03,IF(AND(A49>=1000,A49<5000,B49>=8,B49<10),0.025,IF(AND(A49>=5000,B49>=8,B49<10),0.021,IF(AND(A49<500,B49>=10,B49<12.5),0.04,IF(AND(A49>=500,A49<2000,B49>=10,B49<12.5),0.0308,IF(AND(A49>=2000,A49<4000,B49>=10,B49<12.5),0.026,IF(AND(A49>=4000,A49<7000,B49>=10,B49<12.5),0.024,IF(AND(A49>=7000,B49>=10,B49<12.5),0.0225,IF(AND(A49<500,B49>=12.5,B49<17.5),0.05,IF(AND(A49>=500,A49<1000,B49>=12.5,B49<17.5),0.042,IF(AND(A49>=1000,A49<2500,B49>=12.5,B49<17.5),0.032,IF(AND(A49>=2500,A49<5000,B49>=12.5,B49<17.5),0.028,IF(AND(A49>=5000,B49>=12.5,B49<17.5),0.024,IF(AND(A49<500,B49>=17.5),0.063,IF(AND(A49>=500,A49<1000,B49>=17.5),0.0455,IF(AND(A49>=1000,A49<2000,B49>=17.5),0.04,IF(AND(A49>=2000,A49<4000,B49>=17.5),0.033,IF(AND(A49>=4000,A49<6000,B49>=17.5),0.0295,IF(AND(A49>=6000,B49>=17.5),0.0255)))))))))))))))))))))))))))","v":0.026},{"$f":"A49*C49","v":0},{"$f":"EVEN(D49)","v":0},{"$f":"31*E49","v":0},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[]
[]
["quickscan berekening 120 watt 120 graden"]
["opp","Hoogte","amrature/m2","onafgerond","afgerond","vermogen","productkosten klant"]
[{"$f":"Rekenblad!G16","v":0},{"$f":"Rekenblad!F16","v":0},{"$f":"IF(AND(B56<6,A56<700),0.028,IF(AND(B56<6,A56>=700,A56<5000),0.023,IF(AND(B56<6,A56>=5000),0.022,IF(AND(B56>=6,A56<500),0.03,IF(AND(B56>=6,A56>=500,A56<5000),0.025,IF(AND(B56>=6,A56>=5000),0.023))))))","v":0.028},{"$f":"A56*C56","v":0},{"$f":"EVEN(D56)","v":0},{"$f":"120*E56","v":0},{"$f":"E56*440","v":0}]
[{"$f":"Rekenblad!G17","v":0},{"$f":"Rekenblad!F17","v":0},{"$f":"IF(AND(B57<6,A57<700),0.028,IF(AND(B57<6,A57>=700,A57<5000),0.023,IF(AND(B57<6,A57>=5000),0.022,IF(AND(B57>=6,A57<500),0.03,IF(AND(B57>=6,A57>=500,A57<5000),0.025,IF(AND(B57>=6,A57>=5000),0.023))))))","v":0.028},{"$f":"A57*C57","v":0},{"$f":"EVEN(D57)","v":0},{"$f":"120*E57","v":0},{"$f":"E57*440","v":0}]
[{"$f":"Rekenblad!G18","v":0},{"$f":"Rekenblad!F18","v":0},0.028,{"$f":"A58*C58","v":0},{"$f":"EVEN(D58)","v":0},{"$f":"120*E58","v":0},0]
[]
["quickscan berekening 160 watt 120 graden"]
["opp","Hoogte","amrature/m2","onafgerond","afgerond","vermogen","productkosten klant"]
[{"$f":"Rekenblad!G16","v":0},{"$f":"Rekenblad!F16","v":0},{"$f":"IF(AND(B62<6,A62<1500),0.02,IF(AND(B62<6,A62>=1500,A62<5000),0.018,IF(AND(B62<6,A62>=5000),0.017,IF(AND(B62>=6,B62<8,A62<500),0.024,IF(AND(B62>=6,B62<8,A62>=500,A62<5000),0.018,IF(AND(B62>=6,B62<8,A62>=5000),0.017,IF(AND(B62>=8,A62<2000),0.021,IF(AND(B62>=8,A62>=2000,A62<5000),0.018,IF(AND(B62>=8,A62>=5000),0.017)))))))))","v":0.02},{"$f":"A62*C62","v":0},{"$f":"EVEN(D62)","v":0},{"$f":"160*E62","v":0},{"$f":"E62*490","v":0}]
[{"$f":"Rekenblad!G17","v":0},{"$f":"Rekenblad!F17","v":0},{"$f":"IF(AND(B63<6,A63<1500),0.02,IF(AND(B63<6,A63>=1500,A63<5000),0.018,IF(AND(B63<6,A63>=5000),0.017,IF(AND(B63>=6,B63<8,A63<500),0.024,IF(AND(B63>=6,B63<8,A63>=500,A63<5000),0.018,IF(AND(B63>=6,B63<8,A63>=5000),0.017,IF(AND(B63>=8,A63<2000),0.021,IF(AND(B63>=8,A63>=2000,A63<5000),0.018,IF(AND(B63>=8,A63>=5000),0.017)))))))))","v":0.02},{"$f":"A63*C63","v":0},{"$f":"EVEN(D63)","v":0},{"$f":"160*E63","v":0},{"$f":"E63*490","v":0}]
[{"$f":"Rekenblad!G18","v":0},{"$f":"Rekenblad!F18","v":0},0.02,{"$f":"A64*C64","v":0},{"$f":"EVEN(D64)","v":0},0,0]
[]
["quickscan berekening 120 watt 45 graden"]
["opp","Hoogte","amrature/m2","onafgerond","afgerond","vermogen","productkosten klant"]
[{"$f":"Rekenblad!G16","v":0},{"$f":"Rekenblad!F16","v":0},{"$f":"IF(AND(B68<12.5,A68<1000),0.03,IF(AND(B68<12.5,A68>=1000,A68<5000),0.024,IF(AND(B68<12.5,A68>=5000),0.023,IF(AND(B68>=12.5,B68<17.5,A68<2000),0.03,IF(AND(B68>=12.5,B68<17.5,A68>=2000,A68<7000),0.025,IF(AND(B68>=12.5,B68<17.5,A68>=7000),0.024,IF(AND(B68>=17.5,A68<500),0.042,IF(AND(B68>=17.5,A68>=500,A68<1500),0.035,IF(AND(B68>=17.5,A68>=1500,A68<5000),0.027,IF(AND(B68>=17.5,A68>=5000),0.024))))))))))","v":0.03},{"$f":"A68*C68","v":0},{"$f":"EVEN(D68)","v":0},{"$f":"120*E68","v":0},{"$f":"E68*440","v":0}]
[{"$f":"Rekenblad!G17","v":0},{"$f":"Rekenblad!F17","v":0},{"$f":"IF(AND(B69<12.5,A69<1000),0.03,IF(AND(B69<12.5,A69>=1000,A69<5000),0.024,IF(AND(B69<12.5,A69>=5000),0.023,IF(AND(B69>=12.5,B69<17.5,A69<2000),0.03,IF(AND(B69>=12.5,B69<17.5,A69>=2000,A69<7000),0.025,IF(AND(B69>=12.5,B69<17.5,A69>=7000),0.024,IF(AND(B69>=17.5,A69<500),0.042,IF(AND(B69>=17.5,A69>=500,A69<1500),0.035,IF(AND(B69>=17.5,A69>=1500,A69<5000),0.027,IF(AND(B69>=17.5,A69>=5000),0.024))))))))))","v":0.03},{"$f":"A69*C69","v":0},{"$f":"EVEN(D69)","v":0},{"$f":"120*E69","v":0},{"$f":"E69*440","v":0}]
[{"$f":"Rekenblad!G18","v":0},{"$f":"Rekenblad!F18","v":0},0.03,{"$f":"A70*C70","v":0},{"$f":"EVEN(D70)","v":0},{"$f":"120*E70","v":0},0]
[]
["quickscan berekening 160 watt 45 graden"]
["opp","Hoogte","amrature/m2","onafgerond","afgerond","vermogen","productkosten klant"]
[{"$f":"Rekenblad!G16","v":0},{"$f":"Rekenblad!F16","v":0},{"$f":"IF(AND(B74<12.5,A74<1000),0.022,IF(AND(B74<12.5,A74>=1000,A74<5000),0.018,IF(AND(B74<12.5,A74>=5000),0.017,IF(AND(B74>=12.5,B74<17.5,A74<1000),0.024,IF(AND(B74>=12.5,B74<17.5,A74>=1000,A74<5000),0.019,IF(AND(B74>=12.5,B74<17.5,A74>=5000),0.0175,IF(AND(B74>=17.5,A74<500),0.032,IF(AND(B74>=17.5,A74>=500,A74<1000),0.026,IF(AND(B74>=17.5,A74>=1000,A74<5000),0.021,IF(AND(B74>=17.5,A74>=5000),0.018))))))))))","v":0.022},{"$f":"A74*C74","v":0},{"$f":"EVEN(D74)","v":0},{"$f":"160*E74","v":0},{"$f":"E74*490","v":0}]
[{"$f":"Rekenblad!G17","v":0},{"$f":"Rekenblad!F17","v":0},{"$f":"IF(AND(B75<12.5,A75<1000),0.022,IF(AND(B75<12.5,A75>=1000,A75<5000),0.018,IF(AND(B75<12.5,A75>=5000),0.017,IF(AND(B75>=12.5,B75<17.5,A75<1000),0.024,IF(AND(B75>=12.5,B75<17.5,A75>=1000,A75<5000),0.019,IF(AND(B75>=12.5,B75<17.5,A75>=5000),0.0175,IF(AND(B75>=17.5,A75<500),0.032,IF(AND(B75>=17.5,A75>=500,A75<1000),0.026,IF(AND(B75>=17.5,A75>=1000,A75<5000),0.021,IF(AND(B75>=17.5,A75>=5000),0.018))))))))))","v":0.022},{"$f":"A75*C75","v":0},{"$f":"EVEN(D75)","v":0},{"$f":"160*E75","v":0},{"$f":"E75*490","v":0}]
[{"$f":"Rekenblad!G18","v":0},{"$f":"Rekenblad!F18","v":0},0.022,{"$f":"A76*C76","v":0},{"$f":"EVEN(D76)","v":0},0,{"$f":"E76*490","v":0}]
[]
["quickscan berekening skyline 10000lm 300lx"]
["opp","Hoogte","Armature/m2","onafgerond","afgerond","vermogen","productiekosten klant"]
[{"$f":"Rekenblad!G16","v":0},{"$f":"Rekenblad!F16","v":0},{"$f":"IF(AND(A80<700,B80<6),0.04,\nIF(AND(A80>=700,A80<5000,B80<6),0.0335,\nIF(AND(A80>=5000,B80<6),0.032,\nIF(AND(A80<500,B80>=6,B80<8),0.05,\nIF(AND(A80>=500,A80<2000,B80>=6,B80<8),0.04,\nIF(AND(A80>=2000,B80>=6,B80<8),0.0325,\nIF(AND(A80<500,B80>=8,B80<10),0.05,\nIF(AND(A80>=500,A80<2500,B80>=8,B80<10),0.04,\nIF(AND(A80>=2500,A80<5000,B80>=8,B80<10),0.0365,\nIF(AND(A80>=5000,B80>=8,B80<10),0.034,\nIF(AND(A80<400,B80>=10,B80<12.5),0.06,\nIF(AND(A80>=400,A80<1000,B80>=10,B80<12.5),0.05,\nIF(AND(A80>=1000,A80<3500,B80>=10,B80<12.5),0.04,\nIF(AND(A80>=3500,B80>=10,B80<12.5),0.035,\nIF(AND(A80<400,B80>=12.5),0.075,\nIF(AND(A80>=400,A80<1000,B80>=12.5,),0.062,\nIF(AND(A80>=1000,A80<3500,B80>=12.5,),0.045,\nIF(AND(A80>=4000,A80<7000,B80>=12.5,),0.04,\nIF(AND(A80>=7000,B80>=12.5,),0.036,)))))))))))))))))))","v":0.04},{"$f":"A80*C80","v":0},{"$f":"EVEN(D80)","v":0},{"$f":"85*E80","v":0},{"$f":"E80*338.1","v":0}]
[{"$f":"Rekenblad!G17","v":0},{"$f":"Rekenblad!F17","v":0},0.04,0,0,0,0]
[{"$f":"Rekenblad!G18","v":0},{"$f":"Rekenblad!F18","v":0},0.04,0,0,0,0]
[]
["quickscan berekening skyline 7000lm 300lx"]
["opp","Hoogte","Armature/m2","onafgerond","afgerond","vermogen","productiekosten klant"]
[{"$f":"Rekenblad!G16","v":0},{"$f":"Rekenblad!F16","v":0},{"$f":"IF(AND(A86<700,B86>=4.5,B86<5.5),0.06,\nIF(AND(A86>=700,A86<2000,B86>=4.5,B86<5.5),0.053,\nIF(AND(A86>=2000,A86<7000,B86>=4.5,B86<5.5),0.048,\nIF(AND(A86>=7000,B86>=4.5,B86<5.5),0.0465,))))","v":0},{"$f":"A86*C86","v":0},{"$f":"EVEN(D86)","v":0},{"$f":"55*E86","v":0},{"$f":"E86*338.1","v":0}]
[{"$f":"Rekenblad!G17","v":0},{"$f":"Rekenblad!F17","v":0},{"$f":"IF(AND(A87<700,B87>=4.5,B87<5.5),0.06,\nIF(AND(A87>=700,A87<2000,B87>=4.5,B87<5.5),0.053,\nIF(AND(A87>=2000,A87<7000,B87>=4.5,B87<5.5),0.048,\nIF(AND(A87>=7000,B87>=4.5,B87<5.5),0.0465,))))","v":0},0,0,0,0]
[{"$f":"Rekenblad!G18","v":0},{"$f":"Rekenblad!F18","v":0},0,0,0,0,0]
[]
["quickscan berekening skyline 7000lm 100lx"]
["opp","Hoogte","Armature/m2","onafgerond","afgerond","vermogen","productiekosten klant"]
[{"$f":"Rekenblad!G16","v":0},{"$f":"Rekenblad!F16","v":0},{"$f":"IF(A40<500,0.013,IF(AND(A40>=500,A40<3000),0.01,IF(A40>=3000,0.009)))","v":0.013},{"$f":"A92*C92","v":0},{"$f":"EVEN(D92)","v":0},{"$f":"55*E92","v":0},{"$f":"E92*338.1","v":0}]
[{"$f":"Rekenblad!G17","v":0},{"$f":"Rekenblad!F17","v":0},0.013,0,0,0,0]
[{"$f":"Rekenblad!G18","v":0},{"$f":"Rekenblad!F18","v":0},0.013,0,0,0,0]
[]
["quickscan berekening skyline 10000lm 100lx"]
["opp","Hoogte","Armature/m2","onafgerond","afgerond","vermogen","productiekosten klant"]
[{"$f":"Rekenblad!G16","v":0},{"$f":"Rekenblad!F16","v":0},{"$f":"IF(AND(B98<8,A98<500),0.013,IF(AND(B98<8,A98>=500,A98<3000),0.01,IF(AND(B98<8,A98>=3000),0.009,IF(AND(B98>=8,B98<10,A98<500),0.017,IF(AND(B98>=8,B98<10,A98>=500,A98<3000),0.012,IF(AND(B98>=8,B98<10,A98>=3000,A98<6000),0.01,IF(AND(B98>=8,B98<10,A98>=6000),0.009,IF(AND(B98>=10,B98<12.5,A98<1000),0.015,IF(AND(B98>=10,B98<12.5,A98>=1000,A98<5000),0.012,IF(AND(B98>=10,B98<12.5,A98>=5000),0.0095,IF(AND(B98>=12.5,A98<1000),0.017,IF(AND(B98>=12.5,A98>=1000,A98<5000),0.012,IF(AND(B98>=12.5,A98>=5000),0.01)))))))))))))","v":0.013},{"$f":"A98*C98","v":0},{"$f":"EVEN(D98)","v":0},{"$f":"85*E98","v":0},{"$f":"E98*338.1","v":0}]
[{"$f":"Rekenblad!G17","v":0},{"$f":"Rekenblad!F17","v":0},0.013,0,0,0,0]
[{"$f":"Rekenblad!G18","v":0},{"$f":"Rekenblad!F18","v":0},0.013,0,0,0,0]