{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Startpagina","Rechthoekig","Romaanse trap","Ovaal","Achthoek","Rond","Info","Gegevens","TestFile voor Afgeronde Hoeken"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":0,"comments":5,"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":"Startpagina","index":0,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[[22,2,22,5],[23,2,23,5],[19,2,19,5],[21,2,21,5],[9,1,9,6],[10,2,10,5],[13,2,13,5],[15,2,15,5],[17,1,17,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Pollet Pool Group"]
[null,null,"Bestelformulier zomerzeilen"]
[]
[]
[null,null,"Kies uw zwembad:"]
[]
[null,null,"Rechthoekig zwembad"]
[]
[null,"Rechthoekig zwembad met romaanse trap"]
[]
[null,null,"Ovaal zwembad"]
[]
[null,null,"Octagonaal zwembad"]
[]
[null,null,"Rond zwembad"]

{"sheet":"Rechthoekig","index":1,"n_rows":59,"n_cols":15,"rows_kept":59,"cut":false,"hidden":false,"merged":[[24,1,24,4],[42,1,45,1],[36,9,36,10],[41,9,41,10],[29,4,29,5],[43,7,44,9],[36,1,36,3],[41,1,41,3],[56,1,56,2],[54,5,55,5],[56,8,56,10],[25,9,25,13],[29,6,29,7],[56,6,56,7],[56,3,56,4],[46,1,46,3],[32,12,32,14],[56,12,56,14],[51,1,51,3],[43,2,44,3],[46,9,46,10],[51,9,51,10],[42,10,45,10],[54,3,54,4],[3,2,3,4],[23,0,23,4],[13,1,13,4],[16,1,16,4],[9,6,9,7],[21,0,21,1],[6,6,6,7],[7,6,7,7],[20,4,20,5],[21,2,21,3],[21,4,21,5],[20,6,20,7],[21,6,21,7],[5,2,5,3],[23,6,23,7],[4,2,4,4],[6,1,6,4],[7,1,7,4],[12,1,12,4],[7,9,7,10],[17,1,17,4],[9,8,9,9],[13,6,13,9],[54,6,54,7],[13,12,13,13],[21,9,21,13],[6,12,6,13],[6,9,6,10],[20,9,20,13]]}
[]
[]
[]
["Klant:"]
["Referentie:"]
["Afdekking",null,"(meer info)"]
["Configuratie","Omschrijving",null,null,null,"Prijs/m2","Breedte(mm)",null,"x","Lengte(mm)",null,null,"Opp.",null,"Catalogusprijs"]
[{"$f":"IF($B$8=Gegevens!$B$3,Gegevens!A3,IF($B$8=Gegevens!$B$4,Gegevens!A4,IF($B$8=Gegevens!$B$5,Gegevens!A5,IF($B$8=Gegevens!$B$6,Gegevens!A6,IF($B$8=Gegevens!$B$7,Gegevens!A7,IF($B$8=Gegevens!$B$9,Gegevens!A9,IF($B$8=Gegevens!$B$8,Gegevens!A8,\"\")))))))","v":3044030023},"Sol + Guard Geobubble",null,null,null,{"$f":"IF($B$8=Gegevens!$B$3,Gegevens!C3,IF($B$8=Gegevens!$B$4,Gegevens!C4,IF($B$8=Gegevens!$B$5,Gegevens!C5,IF($B$8=Gegevens!$B$6,Gegevens!C6,IF($B$8=Gegevens!$B$7,Gegevens!C7,IF($B$8=Gegevens!$B$9,Gegevens!C9,IF($B$8=Gegevens!$B$8,Gegevens!C8,\"\")))))))","v":13.58},null,null,"x",null,null,{"$f":"$G$8/1000*$J$8/1000","v":0},{"$f":"ROUND(L8,0)","v":0},"m2",{"$f":"M8*F8","v":0}]
[]
["Hoeken",null,null,null,null,{"$f":"IF(O34=1,\"\",\"Radius:\")","v":""},null,null,{"$f":"IF(O34=1,\"\",\"mm\")","v":""},null,null,null,null,null,{"$f":"IF(O34=2,IF(G10=\"\",\"RADIUS TE KORT\",\"OK\"),\"\")","v":""}]
[]
["Bevestigingen"]
["Configuratie","Omschrijving",null,null,null,"Prijs/stuk",null,null,null,null,"A-zijde",null,"C-zijde",null,"Catalogusprijs"]
[{"$f":"IF(B14=Gegevens!B12,Gegevens!A12,IF(B14=Gegevens!B13,Gegevens!A13,\"\"))","v":3044030010},"Verstevigde oog-opening",null,null,null,{"$f":"IF($B$14=Gegevens!$B$12,Gegevens!C12,IF($B$14=Gegevens!$B$13,Gegevens!C13,Gegevens!C14))","v":13.66},{"$f":"IF(A8=Gegevens!A9,\"Niet mogelijk\",IF(AND(A14=3044030021,M14<>0),\"Steeds ogen vooraan\",\"\"))","v":""},null,null,null,0,null,0,null,{"$f":"IF(A8=3044030006,0,M14*Gegevens!C12+K14*F14)","v":0}]
[]
["Ladderuitsnijding"]
["Configuratie","Zijde",null,null,null,"Prijs/stuk",null,null,null,null,null,null,null,null,"Catalogusprijs"]
[{"$f":"IF($B$18=Gegevens!$B$21,\"\",IF(A8=Gegevens!A7,Gegevens!E17,IF(A8=Gegevens!A9,Gegevens!E17,IF(A8=Gegevens!A8,Gegevens!E17,Gegevens!C18))))","v":""},"Geen",null,null,null,{"$f":"IF($B$18=Gegevens!$B$21,\"\",IF($A$8=Gegevens!$A$7,Gegevens!F17,IF($A$8=Gegevens!$A$9,Gegevens!F17,IF($A$8=Gegevens!$A$8,Gegevens!F17,Gegevens!D17))))","v":""},{"$f":"IF(AND(B18=\"C-zijde\",M14<>0),\"JA\",\"NEE\")","v":"NEE"},null,null,null,null,null,null,null,{"$f":"IF(F18<>\"\",F18,0)","v":0}]
[]
["Afmetingen in mm"]
["A",null,"B",null,"C",null,"D",null,null,"Test"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B18=M44,IF(OR(A22=\"\",C22=\"\",E22=\"\",G22=\"\"),\"WAARDE TE KORT\",IF(A22+E22+G22=J8,\"OK\",\"FOUT\")),IF(B18=F59,IF(OR(A22=\"\",C22=\"\",E22=\"\",G22=\"\"),\"WAARDE TE KORT\",IF(A22+E22+G22=G8,\"OK\",\"FOUT\")),IF(B18=A44,IF(OR(A22=\"\",C22=\"\",E22=\"\",G22=\"\"),\"WAARDE TE KORT\",IF(A22+E22+G22=J8,\"OK\",\"FOUT\")),\"\")))","v":""}]
[]
["Verstevigde drijfboord",null,null,null,null,"NEEN","(meer info)"]
["Configuratie","Omschrijving",null,null,null,null,null,null,null,null,null,null,null,null,"Catalogusprijs"]
[{"$f":"IF(OR($F$24=Gegevens!F4,M14<>0),\"\",IF($G$8<=3960,IF($J$8<=9150,3044030029,IF($J$8<=12200,3044030030,IF($J$8<=15250,3044030031,\"Te lang\"))),IF($G$8<=5180,IF($J$8<=12200,3044030030,IF($J$8<=15250,3044030031,\"Te lang\")),IF($G$8<=6400,IF($J$8<=15250,3044030031,\"Te lang\"),\"Te breed\"))))","v":""},{"$f":"IF(A26=Gegevens!A38,Gegevens!B38,IF(A26=Gegevens!A39,Gegevens!B39,IF(A26=Gegevens!A40,Gegevens!B40,\"\")))","v":""},null,null,null,null,null,null,null,{"$f":"IF(A8=Gegevens!A9,\"Niet mogelijk\",IF(L8>6400,\"Op aanvraag\",IF(P8>15250,\"Op aanvraag\",\"\")))","v":""},null,null,null,null,{"$f":"IF(F24=\"NEEN\",0,IF(A8=3044030006,0,IF(A26=Gegevens!A38,Gegevens!F38,IF(A26=Gegevens!A39,Gegevens!F39,IF(A26=Gegevens!A40,Gegevens!F40,0)))))","v":0}]
[]
["TOTAAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O26+O18+O14+O8","v":0}]
[]
[null,null,null,null,"Total Width:",null,{"$f":"$G$8&\"mm\"","v":"mm"}]
[null,null,null,null,null,"A-zijde"]
[null,{"$f":"IF(B14=\"Geen\",\"\",IF(A14=3044030010,\"\",IF($K$14=2,\"|\",IF($K$14=3,\"|\",IF($K$14=4,\"|\",IF($K$14=5,\"|\",IF($K$14=6,\"|\",IF($K$14=7,\"|\",IF($K$14=8,\"|\",IF($K$14=9,\"|\",IF($K$14=10,\"|\",\"\")))))))))))","v":""},{"$f":"IF(B14=\"Geen\",\"\",IF(A14=3044030010,\"\",IF(A14=3044030010,\"\",IF(K14=9,\"|\",IF(K14=10,\"|\",\"\")))))","v":""},{"$f":"IF(B14=\"Geen\",\"\",IF(A14=3044030010,\"\",IF(K14=6,\"|\",IF(K14=5,\"|\",IF(K14=7,\"|\",IF(K14=8,\"|\",IF(K14=9,\"|\",IF(K14=10,\"|\",\"\"))))))))","v":""},{"$f":"IF(B14=\"Geen\",\"\",IF(A14=3044030010,\"\",IF(K14=4,\"|\",IF(K14=6,\"|\",IF(K14=7,\"|\",IF(K14=8,\"|\",IF(K14=9,\"|\",IF(K14=10,\"|\",\"\"))))))))","v":""},{"$f":"IF(B14=\"Geen\",\"\",IF(A14=3044030010,\"\",IF(K14=1,\"|\",IF(K14=3,\"|\",IF(K14=5,\"|\",IF(K14=7,\"|\",IF(K14=8,\"|\",IF(K14=9,\"|\",IF(K14=10,\"|\",\"\")))))))))","v":""},{"$f":"IF(B14=\"Geen\",\"\",IF(A14=3044030010,\"\",IF(K14=4,\"|\",IF(K14=6,\"|\",IF(K14=7,\"|\",IF(K14=8,\"|\",IF(K14=9,\"|\",IF(K14=10,\"|\",\"\"))))))))","v":""},{"$f":"IF(B14=\"Geen\",\"\",IF(A14=3044030010,\"\",IF(K14=5,\"|\",IF(K14=8,\"|\",IF(K14=9,\"|\",IF(K14=10,\"|\",\"\"))))))","v":""},{"$f":"IF(B14=\"Geen\",\"\",IF(A14=3044030010,\"\",IF(K14=6,\"|\",IF(K14=7,\"|\",IF(K14=8,\"|\",IF(K14=9,\"|\",IF(K14=10,\"|\",\"\")))))))","v":""},{"$f":"IF(B14=\"Geen\",\"\",IF(A14=3044030010,\"\",IF(K14=10,\"|\",\"\")))","v":""},{"$f":"IF(B14=\"Geen\",\"\",IF(A14=3044030010,\"\",IF(A14=3044030010,\"\",IF(K14=2,\"|\",IF(K14=3,\"|\",IF(K14=4,\"|\",IF(K14=5,\"|\",IF(K14=6,\"|\",IF(K14=7,\"|\",IF(K14=8,\"|\",IF(K14=9,\"|\",IF(K14=10,\"|\",\"\"))))))))))))","v":""}]
[{"$f":"IF($O$34=2,IF($G$10=\"\",\"\",\"R:\"&\" \"&$G$10&\"mm\"),\"\")","v":""},{"$f":"IF(B14=\"Geen\",\"\",IF(A14=Gegevens!A13,\"\",IF($K$14=2,\"O\",IF($K$14=3,\"O\",IF($K$14=4,\"O\",IF($K$14=5,\"O\",IF($K$14=6,\"O\",IF($K$14=7,\"O\",IF($K$14=8,\"O\",IF($K$14=9,\"O\",IF($K$14=10,\"O\",\"\")))))))))))","v":""},{"$f":"IF(B14=\"Geen\",\"\",IF(A14=Gegevens!A13,\"\",IF(K14=9,\"O\",IF(K14=10,\"O\",\"\"))))","v":""},{"$f":"IF(B14=\"Geen\",\"\",IF(A14=Gegevens!A13,\"\",IF(K14=6,\"O\",IF(K14=5,\"O\",IF(K14=7,\"O\",IF(K14=8,\"O\",IF(K14=9,\"O\",IF(K14=10,\"O\",\"\"))))))))","v":""},{"$f":"IF(B14=\"Geen\",\"\",IF(A14=Gegevens!A13,\"\",IF(K14=4,\"O\",IF(K14=6,\"O\",IF(K14=7,\"O\",IF(K14=8,\"O\",IF(K14=9,\"O\",IF(K14=10,\"O\",\"\"))))))))","v":""},{"$f":"IF(B14=\"Geen\",\"\",IF(A14=Gegevens!A13,\"\",IF(K14=1,\"O\",IF(K14=3,\"O\",IF(K14=5,\"O\",IF(K14=7,\"O\",IF(K14=8,\"O\",IF(K14=9,\"O\",IF(K14=10,\"O\",\"\")))))))))","v":""},{"$f":"IF(B14=\"Geen\",\"\",IF(A14=Gegevens!A13,\"\",IF(K14=4,\"O\",IF(K14=6,\"O\",IF(K14=7,\"O\",IF(K14=8,\"O\",IF(K14=9,\"O\",IF(K14=10,\"O\",\"\"))))))))","v":""},{"$f":"IF(B14=\"Geen\",\"\",IF(A14=Gegevens!A13,\"\",IF(K14=5,\"O\",IF(K14=8,\"O\",IF(K14=9,\"O\",IF(K14=10,\"O\",\"\"))))))","v":""},{"$f":"IF(B14=\"Geen\",\"\",IF(A14=Gegevens!A13,\"\",IF(K14=6,\"O\",IF(K14=7,\"O\",IF(K14=8,\"O\",IF(K14=9,\"O\",IF(K14=10,\"O\",\"\")))))))","v":""},{"$f":"IF(B14=\"Geen\",\"\",IF(A14=Gegevens!A13,\"\",IF(K14=10,\"O\",\"\")))","v":""},{"$f":"IF(B14=\"Geen\",\"\",IF(A14=Gegevens!A13,\"\",IF(K14=2,\"O\",IF(K14=3,\"O\",IF(K14=4,\"O\",IF(K14=5,\"O\",IF(K14=6,\"O\",IF(K14=7,\"O\",IF(K14=8,\"O\",IF(K14=9,\"O\",IF(K14=10,\"O\",\"\")))))))))))","v":""},null,{"$f":"IF($O$34=2,IF($G$10=\"\",\"\",\"R:\"&\" \"&$G$10&\"mm\"),\"\")","v":""},null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Recht",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Afgerond"]
[]
[null,{"$f":"IF($B$18=$A$44,IF($A$22<>\"\",$A$22&\"mm\",\"A\"),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF($B$18=$M$44,IF($A$22<>\"\",$A$22&\"mm\",\"A\"),\"\")","v":""}]
[]
[]
[]
[]
[null,{"$f":"IF(B18=A44,IF(C22<>\"\",C22&\"mm\",\"B\"),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(B18=M44,IF(C22<>\"\",C22&\"mm\",\"B\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Length"]
["D-zijde",null,{"$f":"IF(B18=A44,IF(E22<>\"\",E22&\"mm\",\"C\"),\"\")","v":""},null,null,null,null,{"$f":"IF(B18=M44,IF(E22<>\"\",E22&\"mm\",\"C\"),\"\")","v":""},null,null,null,null,"B-zijde",null,{"$f":"J8&\"mm\"","v":"mm"}]
[]
[]
[null,{"$f":"IF(B18=A44,IF(C22<>\"\",C22&\"mm\",\"B\"),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(B18=M44,IF(C22<>\"\",C22&\"mm\",\"B\"),\"\")","v":""}]
[]
[]
[]
[]
[null,{"$f":"IF(B18=A44,IF(G22<>\"\",G22&\"mm\",\"D\"),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(B18=M44,IF(G22<>\"\",G22&\"mm\",\"D\"),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(M14<>0,IF(B18=F59,IF(E22<>\"\",E22&\"mm\",\"C\"),\"\"),IF(M14=1,\"O\",IF(M14=3,\"O\",IF($M$14=5,\"O\",IF($M$14=7,\"O\",IF($M$14=8,\"O\",IF($M$14=9,\"O\",IF($M$14=10,\"O\",\"\"))))))))","v":""}]
[]
[null,null,null,{"$f":"IF(M14<>0,IF(B18=F59,IF(C22<>\"\",C22&\"mm\",\"B\"),\"\"),\"\")","v":""},null,{"$f":"IF(M14=0,IF(B18=F59,IF(E22<>\"\",E22&\"mm\",\"C\"),\"\"),IF(M14=1,\"O\",IF(M14=3,\"O\",IF($M$14=5,\"O\",IF($M$14=7,\"O\",IF($M$14=8,\"O\",IF($M$14=9,\"O\",IF($M$14=10,\"O\",\"\"))))))))","v":""},{"$f":"IF(M14<>0,IF($B$18=$F$59,IF($C$22<>\"\",$C$22&\"mm\",\"B\"),\"\"),\"\")","v":""}]
[null,{"$f":"IF(M14=2,\"O\",IF(M14=3,\"O\",IF(M14=4,\"O\",IF(M14=5,\"O\",IF($M$14=6,\"O\",IF($M$14=7,\"O\",IF($M$14=8,\"O\",IF($M$14=9,\"O\",IF($M$14=10,\"O\",\"\")))))))))","v":""},{"$f":"IF($M$14=9,\"O\",IF($M$14=10,\"O\",\"\"))","v":""},{"$f":"IF($M$14=6,\"O\",IF($M$14=5,\"O\",IF($M$14=7,\"O\",IF($M$14=8,\"O\",IF($M$14=9,\"O\",IF($M$14=10,\"O\",\"\"))))))","v":""},{"$f":"IF(M14=4,\"O\",IF($M$14=6,\"O\",IF($M$14=7,\"O\",IF($M$14=8,\"O\",IF($M$14=9,\"O\",IF($M$14=10,\"O\",\"\"))))))","v":""},null,{"$f":"IF(M14=4,\"O\",IF($M$14=6,\"O\",IF($M$14=7,\"O\",IF($M$14=8,\"O\",IF($M$14=9,\"O\",IF($M$14=10,\"O\",\"\"))))))","v":""},{"$f":"IF($M$14=5,\"O\",IF($M$14=8,\"O\",IF($M$14=9,\"O\",IF($M$14=10,\"O\",\"\"))))","v":""},{"$f":"IF($M$14=6,\"O\",IF($M$14=7,\"O\",IF($M$14=8,\"O\",IF($M$14=9,\"O\",IF($M$14=10,\"O\",\"\")))))","v":""},{"$f":"IF($M$14=10,\"O\",\"\")","v":""},{"$f":"IF(M14=2,\"O\",IF(M14=3,\"O\",IF(M14=4,\"O\",IF($M$14=5,\"O\",IF($M$14=6,\"O\",IF($M$14=7,\"O\",IF($M$14=8,\"O\",IF($M$14=9,\"O\",IF($M$14=10,\"O\",\"\")))))))))","v":""}]
[{"$f":"IF($O$34=2,IF($G$10=\"\",\"\",\"R:\"&\" \"&$G$10&\"mm\"),\"\")","v":""},{"$f":"IF($B$18=$F$59,IF($A$22<>\"\",$A$22&\"mm\",\"A\"),\"\")","v":""},null,{"$f":"IF(M14=0,IF(B18=F59,IF(C22<>\"\",C22&\"mm\",\"B\"),\"\"),\"\")","v":""},null,{"$f":"IF(F24=\"JA\",\"Leading Edge\",\"\")","v":""},{"$f":"IF(M14=0,IF($B$18=$F$59,IF($C$22<>\"\",$C$22&\"mm\",\"B\"),\"\"),\"\")","v":""},null,{"$f":"IF(B18=F59,IF(G22<>\"\",G22&\"mm\",\"D\"),\"\")","v":""},null,null,null,{"$f":"IF($O$34=2,IF($G$10=\"\",\"\",\"R:\"&\" \"&$G$10&\"mm\"),\"\")","v":""}]
[]
[null,null,null,null,null,"C-zijde"]

{"sheet":"Romaanse trap","index":2,"n_rows":54,"n_cols":15,"rows_kept":54,"cut":false,"hidden":false,"merged":[[53,4,53,6],[45,1,45,3],[45,9,45,10],[12,12,12,13],[12,1,12,4],[15,1,15,4],[19,4,19,5],[19,6,19,7],[20,0,20,1],[20,2,20,3],[20,4,20,5],[20,6,20,7],[24,6,24,7],[24,4,24,5],[26,12,26,14],[37,1,37,3],[3,2,3,4],[4,2,4,4],[6,1,6,4],[6,6,6,7],[12,7,12,10],[5,2,5,3],[37,9,37,10],[31,1,31,3],[31,9,31,10],[32,1,32,3],[6,12,6,13],[7,1,7,4],[7,6,7,7],[7,9,7,10],[11,1,11,4],[6,9,6,10],[9,6,9,7],[9,8,9,9],[51,8,51,10],[51,4,51,6],[50,1,50,3],[50,9,50,10],[42,1,42,3],[42,9,42,10],[53,9,54,12],[19,0,19,1],[19,2,19,3],[20,12,20,14],[19,12,19,14],[19,8,19,10],[20,8,20,10],[36,12,39,12],[32,9,32,10],[38,1,41,1],[38,10,41,10],[39,2,40,3],[39,9,40,9],[31,12,35,12],[51,12,51,14],[51,2,51,3]]}
[]
[]
[]
["Klant:"]
["Referentie:"]
["Afdekking",null,"(meer info)"]
["Configuratie","Omschrijving",null,null,null,"Prijs/m2","Breedte(mm)",null,"x","Lengte(mm)",null,null,"Opp.",null,"Catalogusprijs"]
[{"$f":"IF($B$8=Gegevens!$B$3,Gegevens!A3,IF($B$8=Gegevens!$B$4,Gegevens!A4,IF($B$8=Gegevens!$B$5,Gegevens!A5,IF($B$8=Gegevens!$B$6,Gegevens!A6,IF($B$8=Gegevens!$B$7,Gegevens!A7,IF($B$8=Gegevens!$B$9,Gegevens!A9,IF($B$8=Gegevens!$B$8,Gegevens!A8,\"\")))))))","v":3044030023},"Sol + Guard Geobubble",null,null,null,{"$f":"IF($B$8=Gegevens!$B$3,Gegevens!C3,IF($B$8=Gegevens!$B$4,Gegevens!C4,IF($B$8=Gegevens!$B$5,Gegevens!C5,IF($B$8=Gegevens!$B$6,Gegevens!C6,IF($B$8=Gegevens!$B$7,Gegevens!C7,IF($B$8=Gegevens!$B$9,Gegevens!C9,IF($B$8=Gegevens!$B$8,Gegevens!C8,\"\")))))))","v":13.58},null,null,"x",null,null,{"$f":"$G$8/1000*($J$8/1000+G21/1000)","v":0},{"$f":"IF(G21<>\"\",ROUND(L8,0),\"\")","v":""},"m2",{"$f":"IF(M8<>\"\",M8*F8,0)","v":0}]
[]
["Hoeken",null,null,null,null,{"$f":"IF(O36=1,\"\",\"Radius:\")","v":""},null,null,{"$f":"IF(O36=1,\"\",\"mm\")","v":""},null,null,null,null,null,{"$f":"IF(O36=2,IF(G10=\"\",\"RADIUS TE KORT\",\"OK\"),\"\")","v":""}]
[]
["Configuratie","Omschrijving",null,null,null,"Prijs/stuk",null,null,null,null,null,null,"Totaal #",null,"Catalogusprijs"]
[{"$f":"IF($B$13=Gegevens!$B$12,Gegevens!A12,IF($B$13=Gegevens!$B$13,Gegevens!A13,\"\"))","v":3044030010},"Verstevigde oog-opening",null,null,null,{"$f":"IF($B$13=Gegevens!$B$12,Gegevens!C12,IF($B$13=Gegevens!$B$13,Gegevens!C13,Gegevens!C14))","v":13.66},null,{"$f":"IF(A8=Gegevens!A9,\"Niet mogelijk\",\"\")","v":""},null,null,null,null,0,null,{"$f":"IF(A8=3044030006,0,M13*F13)","v":0}]
[]
["Romaanse trap"]
["Configuratie","Zijde",null,null,null,"Prijs/stuk",null,null,null,null,null,null,null,null,"Catalogusprijs"]
[{"$f":"IF($A$8=Gegevens!$A$7,Gegevens!$A$44,IF($A$8=Gegevens!$A$9,Gegevens!$A$44,IF($A$8=Gegevens!$A$8,Gegevens!$A$44,Gegevens!$A$43)))","v":3044030012},{"$f":"IF('Romaanse trap'!$A$17=Gegevens!$A$43,Gegevens!$B$43,Gegevens!$B$44)","v":"Roman End shaping surcharge (price/piece)"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($A$17=Gegevens!$A$43,Gegevens!$F$43,Gegevens!$F$44)","v":41.79}]
[]
["Afmetingen in mm"]
["A",null,"B",null,"C",null,"D",null,"Radius",null,null,"Test","Test"]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(C21=\"\",G21=\"\"),\"\",IF(G21*2<=C21,ROUND(((C21/2)^2+G21^2)/(2*G21),0),C21/2))","v":""},null,null,null,{"$f":"IF(OR(A21=\"\",C21=\"\",E21=\"\",G21=\"\"),\"WAARDE TE KORT\",IF(A21+C21+E21=G8,\"OK\",\"FOUT\"))","v":"WAARDE TE KORT"}]
[]
["TOTAAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O17+O13+O8","v":41.79}]
[]
[null,null,null,null," Width:",null,{"$f":"$G$8&\"mm\"","v":"mm"}]
[]
[{"$f":"IF($O$36,IF($G$10=\"\",\"\",\"R:\"&\" \"&$G$10&\"mm\"),\"\")","v":""},{"$f":"IF(M13=2,\"O\",IF(M13=3,\"O\",IF(M13=4,\"O\",IF(M13=5,\"O\",IF($M$13=6,\"O\",IF($M$13=7,\"O\",IF($M$13=8,\"O\",IF($M$13=9,\"O\",IF($M$13=10,\"O\",\"\")))))))))","v":""},{"$f":"IF($M$13=9,\"O\",IF($M$13=10,\"O\",\"\"))","v":""},{"$f":"IF($M$13=6,\"O\",IF($M$13=5,\"O\",IF($M$13=7,\"O\",IF($M$13=8,\"O\",IF($M$13=9,\"O\",IF($M$13=10,\"O\",\"\"))))))","v":""},{"$f":"IF(M13=4,\"O\",IF($M$13=6,\"O\",IF($M$13=7,\"O\",IF($M$13=8,\"O\",IF($M$13=9,\"O\",IF($M$13=10,\"O\",\"\"))))))","v":""},{"$f":"IF(M13=1,\"O\",IF(M13=3,\"O\",IF($M$13=5,\"O\",IF($M$13=7,\"O\",IF($M$13=8,\"O\",IF($M$13=9,\"O\",IF($M$13=10,\"O\",\"\")))))))","v":""},{"$f":"IF(M13=4,\"O\",IF($M$13=6,\"O\",IF($M$13=7,\"O\",IF($M$13=8,\"O\",IF($M$13=9,\"O\",IF($M$13=10,\"O\",\"\"))))))","v":""},{"$f":"IF($M$13=5,\"O\",IF($M$13=8,\"O\",IF($M$13=9,\"O\",IF($M$13=10,\"O\",\"\"))))","v":""},{"$f":"IF($M$13=6,\"O\",IF($M$13=7,\"O\",IF($M$13=8,\"O\",IF($M$13=9,\"O\",IF($M$13=10,\"O\",\"\")))))","v":""},{"$f":"IF($M$13=10,\"O\",\"\")","v":""},{"$f":"IF(M13=2,\"O\",IF(M13=3,\"O\",IF(M13=4,\"O\",IF($M$13=5,\"O\",IF($M$13=6,\"O\",IF($M$13=7,\"O\",IF($M$13=8,\"O\",IF($M$13=9,\"O\",IF($M$13=10,\"O\",\"\")))))))))","v":""},null,{"$f":"IF($O$36,IF($G$10=\"\",\"\",\"R:\"&\" \"&$G$10&\"mm\"),\"\")","v":""}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Short Length:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Recht"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Afgerond",1]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J8&\"mm\"","v":"mm"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Length"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$J$8+G21&\"mm\"","v":"0mm"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF($O$36,IF($G$10=\"\",\"\",\"R:\"&\" \"&$G$10&\"mm\"),\"\")","v":""},null,{"$f":"IF(A21<>\"\",A21&\"mm\",\"A\")","v":"A"},null,{"$f":"IF(C21<>\"\",C21&\"mm\",\"B\")","v":"B"},null,null,null,{"$f":"IF(E21<>\"\",E21&\"mm\",\"C\")","v":"C"},null,null,null,{"$f":"IF($O$36,IF($G$10=\"\",\"\",\"R:\"&\" \"&$G$10&\"mm\"),\"\")","v":""}]
[]
[null,null,null,null,{"$f":"\"Radius=\"&IF($I$21<>\"\",$I$21&\"mm\",\"\")","v":"Radius="},null,null,null,null,{"$f":"IF(G21=\"\",\"D\",G21&\"mm\")","v":"D"}]

{"sheet":"Ovaal","index":3,"n_rows":56,"n_cols":15,"rows_kept":56,"cut":false,"hidden":false,"merged":[[13,1,13,4],[22,6,22,7],[22,4,22,5],[18,4,18,5],[18,11,18,12],[18,6,18,10],[19,0,19,1],[19,2,19,3],[19,4,19,5],[19,11,19,12],[19,6,19,10],[13,7,13,10],[13,12,13,13],[5,2,5,3],[12,12,12,13],[3,2,3,4],[4,2,4,4],[6,1,6,4],[6,6,6,7],[6,9,6,10],[6,12,6,13],[7,1,7,4],[7,6,7,7],[7,9,7,10],[11,1,11,4],[12,1,12,4],[12,7,12,10]]}
[]
[]
[]
["Klant:"]
["Referentie:"]
["Afdekking",null,"(meer info)"]
["Configuratie","Omschrijving",null,null,null,"Prijs/m2","Breedte(mm)",null,"x","Lengte(mm)",null,null,"Opp.",null,"Catalogusprijs"]
[{"$f":"IF($B$8=Gegevens!$B$3,Gegevens!A3,IF($B$8=Gegevens!$B$4,Gegevens!A4,IF($B$8=Gegevens!$B$5,Gegevens!A5,IF($B$8=Gegevens!$B$6,Gegevens!A6,IF($B$8=Gegevens!$B$7,Gegevens!A7,IF($B$8=Gegevens!$B$9,Gegevens!A9,IF($B$8=Gegevens!$B$8,Gegevens!A8,\"\")))))))","v":3044030023},"Sol + Guard Geobubble",null,null,null,{"$f":"IF($B$8=Gegevens!$B$3,Gegevens!C3,IF($B$8=Gegevens!$B$4,Gegevens!C4,IF($B$8=Gegevens!$B$5,Gegevens!C5,IF($B$8=Gegevens!$B$6,Gegevens!C6,IF($B$8=Gegevens!$B$7,Gegevens!C7,IF($B$8=Gegevens!$B$9,Gegevens!C9,IF($B$8=Gegevens!$B$8,Gegevens!C8,\"\")))))))","v":13.58},null,null,"x",null,null,{"$f":"$G$8/1000*$J$8/1000","v":0},{"$f":"ROUND(L8,0)","v":0},"m2",{"$f":"M8*F8","v":0}]
[{"$f":"IF(A8=Gegevens!A7,Gegevens!A48,IF(A8=Gegevens!A9,Gegevens!A48,IF(A8=Gegevens!A8,Gegevens!A48,Gegevens!A47)))","v":3044030009},{"$f":"IF(A9=Gegevens!A47,Gegevens!B47,Gegevens!B48)","v":"Shaping surcharge "},null,null,null,{"$f":"IF(A9=Gegevens!A47,Gegevens!F47,Gegevens!F48)","v":4.12},null,null,null,null,null,null,{"$f":"M8","v":0},"m2",{"$f":"M9*F9","v":0}]
[]
["Bevestigingen"]
["Configuratie","Omschrijving",null,null,null,"Prijs/stuk",null,null,null,null,null,null,"Totaal #",null,"Catalogusprijs"]
[{"$f":"IF($B$13=Gegevens!$B$12,Gegevens!A12,IF($B$13=Gegevens!$B$13,Gegevens!A13,\"\"))","v":3044030010},"Verstevigde oog-opening",null,null,null,{"$f":"IF($B$13=Gegevens!$B$12,Gegevens!C12,IF($B$13=Gegevens!$B$13,Gegevens!C13,Gegevens!C14))","v":13.66},null,"Vooraan",null,null,null,null,null,null,{"$f":"IF(A8=3044030006,0,(M13+M14)*F13)","v":0}]
[null,{"$f":"IF(Ovaal!A8=Gegevens!A9,\"Niet mogelijk\",\"\")","v":""},null,null,null,null,null,"Achteraan"]
[]
["Resterende afmetingen"]
[]
["Afmetingen in mm"]
["Radius",null,"Korte lengte",null,null,null,"Test"]
[null,null,null,null,null,null,{"$f":"IF(OR(A20<>\"\",C20<>\"\"),IF(G8=2*A20,IF(J8=A20*2+C20,\"OK\",\"FOUT\"),\"FOUT\"),\"\")","v":""}]
[]
["TOTAAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O13+O9+O8","v":0}]
[null,null,null,null,"Total Width:",null,{"$f":"$G$8&\"mm\"","v":"mm"}]
[]
[]
[]
[null,null,null,null,{"$f":"IF(M13=2,\"o\",IF(M13=4,\"o\",IF(M13=5,\"o\",IF(M13=6,\"o\",IF(M13=7,\"o\",\"\")))))","v":""},{"$f":"IF(M13=1,\"o\",IF(M13=3,\"o\",IF(M13=5,\"o\",IF(M13=7,\"o\",\"\"))))","v":""},{"$f":"IF(M13=2,\"o\",IF(M13=4,\"o\",IF(M13=5,\"o\",IF(M13=6,\"o\",IF(M13=7,\"o\",\"\")))))","v":""}]
[null,null,null,null,{"$f":"IF(M13=3,\"o\",IF(M13=6,\"o\",IF(M13=7,\"o\",\"\")))","v":""},null,{"$f":"IF(M13=3,\"o\",IF(M13=6,\"o\",IF(M13=7,\"o\",\"\")))","v":""}]
[null,null,null,{"$f":"IF(M13=4,\"o\",IF(M13=5,\"o\",IF(M13=6,\"o\",IF(M13=7,\"o\",\"\"))))","v":""},null,null,null,{"$f":"IF(M13=4,\"o\",IF(M13=5,\"o\",IF(M13=6,\"o\",IF(M13=7,\"o\",\"\"))))","v":""}]
["Radius"]
[{"$f":"IF($A$20<>\"\",$A$20&\"mm\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Length"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J8&\"mm\"","v":"mm"}]
["Length"]
[{"$f":"IF($C$20<>\"\",$C$20&\"mm\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Radius"]
[{"$f":"IF($A$20<>\"\",$A$20&\"mm\",\"\")","v":""}]
[null,null,null,{"$f":"IF(M14=4,\"o\",IF(M14=5,\"o\",IF(M14=6,\"o\",IF(M14=7,\"o\",\"\"))))","v":""},null,null,null,{"$f":"IF(M14=4,\"o\",IF(M14=5,\"o\",IF(M14=6,\"o\",IF(M14=7,\"o\",\"\"))))","v":""}]
[null,null,null,{"$f":"IF(M14=3,\"o\",IF(M14=6,\"o\",IF(M14=7,\"o\",\"\")))","v":""},null,null,null,{"$f":"IF(M14=3,\"o\",IF(M14=6,\"o\",IF(M14=7,\"o\",\"\")))","v":""}]
[null,null,null,null,{"$f":"IF(M14=2,\"o\",IF(M14=4,\"o\",IF(M14=5,\"o\",IF(M14=6,\"o\",IF(M14=7,\"o\",\"\")))))","v":""},{"$f":"IF(M14=1,\"o\",IF(M14=3,\"o\",IF(M14=5,\"o\",IF(M14=7,\"o\",\"\"))))","v":""},{"$f":"IF(M14=2,\"o\",IF(M14=4,\"o\",IF(M14=5,\"o\",IF(M14=6,\"o\",IF(M14=7,\"o\",\"\")))))","v":""}]

{"sheet":"Achthoek","index":4,"n_rows":61,"n_cols":22,"rows_kept":61,"cut":false,"hidden":false,"merged":[[7,15,7,17],[27,0,27,7],[28,1,28,7],[32,7,32,9],[25,0,25,1],[25,7,25,9],[25,16,25,20],[12,14,12,17],[12,19,12,20],[13,11,13,13],[13,14,13,17],[13,19,13,20],[25,10,25,13],[29,16,29,20],[18,13,18,17],[33,1,33,4],[34,0,38,0],[10,19,10,20],[21,1,21,7],[22,1,22,7],[24,7,24,9],[24,11,24,13],[24,16,24,20],[11,1,11,4],[11,5,11,7],[11,8,11,10],[11,11,11,13],[11,14,11,17],[11,19,11,20],[33,14,33,17],[12,11,12,13],[6,1,6,7],[6,11,6,13],[7,1,7,7],[7,11,7,13],[3,2,3,7],[4,2,4,7],[5,2,5,5],[6,19,6,20],[25,2,25,6],[50,15,52,15],[53,5,53,7],[49,16,52,17],[6,15,6,17],[34,1,36,3],[34,15,36,17],[17,1,17,7],[18,1,18,7],[18,19,18,20],[10,1,10,4],[10,5,10,7],[10,8,10,10],[10,11,10,13],[10,14,10,17],[54,6,55,7],[50,1,52,2],[43,0,49,0],[55,0,58,2],[56,11,56,12],[55,10,57,10],[55,8,57,8],[50,11,53,13],[55,11,55,12],[55,9,56,9],[53,20,56,20],[55,15,57,17],[53,19,57,19],[34,19,38,19],[59,13,59,17],[42,19,49,19],[59,1,59,5],[52,0,54,0],[12,5,12,7],[12,1,12,4],[12,8,12,10],[13,1,13,4],[13,5,13,7],[13,8,13,10],[24,2,24,6],[14,5,14,8],[14,9,14,13],[32,10,32,13],[27,10,27,12],[27,8,27,9],[56,6,56,7],[50,3,52,5]]}
[]
[]
[]
["Klant:"]
["Referentie:"]
["Afdekking",null,"(meer info)"]
["Configuratie","Omschrijving",null,null,null,null,null,null,null,"Prijs/m2",null,"Breedte(mm)",null,null,"x","Lengte(mm)",null,null,null,"Opp.",null,"Catalogusprijs"]
[{"$f":"IF($B$8=Gegevens!$B$3,Gegevens!A3,IF($B$8=Gegevens!$B$4,Gegevens!A4,IF($B$8=Gegevens!$B$5,Gegevens!A5,IF($B$8=Gegevens!$B$6,Gegevens!A6,IF($B$8=Gegevens!$B$7,Gegevens!A7,IF($B$8=Gegevens!$B$9,Gegevens!A9,IF($B$8=Gegevens!$B$8,Gegevens!A8,\"\")))))))","v":3044030023},"Sol + Guard Geobubble",null,null,null,null,null,null,null,{"$f":"IF($B$8=Gegevens!$B$3,Gegevens!C3,IF($B$8=Gegevens!$B$4,Gegevens!C4,IF($B$8=Gegevens!$B$5,Gegevens!C5,IF($B$8=Gegevens!$B$6,Gegevens!C6,IF($B$8=Gegevens!$B$7,Gegevens!C7,IF($B$8=Gegevens!$B$9,Gegevens!C9,IF($B$8=Gegevens!$B$8,Gegevens!C8,\"\")))))))","v":13.58},null,null,null,null,"x",null,null,null,{"$f":"$L$8/1000*$P$8/1000","v":0},{"$f":"ROUND(S8,0)","v":0},"m2",{"$f":"T8*J8","v":0}]
[{"$f":"IF(A8=Gegevens!A9,Gegevens!A48,IF(A8=Gegevens!A7,Gegevens!A48,IF(A8=Gegevens!A8,Gegevens!A48,Gegevens!A47)))","v":3044030009},{"$f":"IF(A9=Gegevens!A48,Gegevens!B48,Gegevens!B47)","v":"Shaping surcharge "},null,null,null,null,null,null,null,{"$f":"IF(A9=Gegevens!A48,Gegevens!F48,Gegevens!F47)","v":4.12},null,null,null,null,null,null,null,null,null,{"$f":"T8","v":0},"m2",{"$f":"T9*J9","v":0}]
[]
["A (mm)","B (mm)",null,null,null,"C (mm)",null,null,"D (mm)",null,null,"E (mm)",null,null,"F (mm)",null,null,null,null,"G (mm)",null,"H (mm)"]
[]
["I (mm)","J (mm)",null,null,null,"K (mm)",null,null,"L (mm)",null,null,"M (mm)",null,null,"N (mm)",null,null,null,null,"O (mm)",null,"P (mm)"]
[]
[null,null,null,null,null,"Test",null,null,null,{"$f":"IF(AND(L8<>\"\",P8<>\"\",A12<>\"\",B12<>\"\",F12<>\"\",I12<>\"\",L12<>\"\",O12<>\"\",T12<>\"\",V12<>\"\",A14<>\"\",B14<>\"\",F14<>\"\",I14<>\"\",L14<>\"\",O14<>\"\",T14<>\"\",V14<>\"\"),IF(AND(ROUND(A12,0)=ROUND(SQRT(B14*B14+A14*A14),0),ROUND(F12,0)=ROUND(SQRT(F14*F14+I14*I14),0),ROUND(L12,0)=ROUND(SQRT(L14*L14+O14*O14),0),ROUND(T12,0)=ROUND(SQRT(T14*T14+V14*V14),0),B14+B12+F14=L8,I14+I12+L14=P8,O14+O12+T14=L8,V14+V12+A14=P8),\"OK\",\"Geometrische Fout\"),\"Waarde te kort\")","v":"Waarde te kort"}]
[]
["Bevestigingen"]
["Configuratie","Omschrijving",null,null,null,null,null,null,null,"Prijs/stuk",null,null,null,null,null,null,null,null,null,"Totaal #",null,"Catalogusprijs"]
[{"$f":"IF($B$19=Gegevens!$B$12,Gegevens!A12,IF($B$19=Gegevens!$B$13,Gegevens!A13,\"\"))","v":3044030010},"Verstevigde oog-opening",null,null,null,null,null,null,null,{"$f":"IF($B$19=Gegevens!$B$12,Gegevens!C12,IF($B$19=Gegevens!$B$13,Gegevens!C13,Gegevens!C14))","v":13.66},null,null,null,{"$f":"IF(A8=Gegevens!A9,\"Niet mogelijk\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(A8=3044030006,0,T19*J19)","v":0}]
[]
["Ladderuitsnijding"]
["Configuratie","Zijde",null,null,null,null,null,null,null,"Prijs/stuk",null,null,null,null,null,null,null,null,null,null,null,"Catalogusprijs"]
[{"$f":"IF($B$23=Gegevens!$B$21,\"\",IF(A8=Gegevens!A7,Gegevens!E17,IF(A8=Gegevens!A9,Gegevens!E17,IF(A8=Gegevens!A8,Gegevens!E17,Gegevens!C18))))","v":""},"Geen",null,null,null,null,null,null,null,{"$f":"IF($B$23=Gegevens!$B$21,\"\",IF($A$8=Gegevens!$A$7,Gegevens!F17,IF($A$8=Gegevens!$A$9,Gegevens!F17,IF($A$8=Gegevens!$A$8,Gegevens!F17,Gegevens!D17))))","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J23<>\"\",J23,0)","v":0}]
[]
["A (mm)",null,"B (mm)",null,null,null,null,"C (mm)",null,null,null,"D (mm)",null,null,null,null,"Test"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(A26<>\"\",C26<>\"\",H26<>\"\",K26<>\"\"),IF(B23=Gegevens!B21,\"\",IF(B23=Gegevens!B17,IF(L12=A26+H26+K26,\"OK\",\"FOUT\"),IF(B23=Gegevens!B18,IF(O12=A26+H26+K26,\"OK\",\"FOUT\"),IF(Achthoek!B23=Gegevens!B19,IF(A26+H26+K26=T12,\"OK\",\"FOUT\"),\"FOUT\")))),\"\")","v":""}]
[]
["Verstevigde drijfboord",null,null,null,null,null,null,null,"NEEN",null,"(meer info)"]
["Configuratie","Omschrijving",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Catalogusprijs"]
[{"$f":"IF($I$28=Gegevens!F4,\"\",IF($L$8<>\"\",IF($L$8<=3960,IF($P$8<=9150,3044030029,IF($P$8<=12200,3044030030,IF($P$8<=15250,3044030031,\"Te lang\"))),IF($L$8<=5180,IF($P$8<=12200,3044030030,IF($P$8<=15250,3044030031,\"Te lang\")),IF($L$8<=6400,IF($P$8<=15250,3044030031,\"Te lang\"),\"Te breed\"))),\"\"))","v":""},{"$f":"IF(A30=Gegevens!A38,Gegevens!B38,IF(A30=Gegevens!A39,Gegevens!B39,IF(A30=Gegevens!A40,Gegevens!B40,\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A8=Gegevens!A9,\"Niet mogelijk\",IF(L8>6400,\"Op aanvraag\",IF(P8>15250,\"Op aanvraag\",\"\")))","v":""},null,null,null,null,{"$f":"IF(I28=\"NEEN\",0,IF(A8=3044030006,0,IF(A30=Gegevens!A38,Gegevens!F38,IF(A30=Gegevens!A39,Gegevens!F39,IF(A30=Gegevens!A40,Gegevens!F40,0)))))","v":0}]
[]
["TOTAAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V30+V23+V19+V9+V8","v":0}]
[null,null,null,null,null,null,null,"Total Width:",null,null,{"$f":"$L$8&\"mm\"","v":"mm"}]
[null,{"$f":"IF(B14<>\"\",B14&\"mm\",\"J\")","v":"J"},null,null,null,null,null,null,null,{"$f":"IF(B12<>\"\",B12&\"mm\",\"B\")","v":"B"},null,null,null,null,{"$f":"IF(F14<>\"\",F14&\"mm\",\"K\")","v":"K"}]
[{"$f":"IF(A14<>\"\",A14&\"mm\",\"I\")","v":"I"},{"$f":"IF(A12<>\"\",ROUND(A12,0)&\"mm\",\"A\")","v":"A"},null,null,null,null,{"$f":"IF($B$23=$A$44,IF($A$26<>\"\",$A$26&\"mm\",\"A\"),\"\")","v":""},{"$f":"IF(T19=2,\"O\",IF(T19=3,\"O\",IF(T19=5,\"O\",IF(T19=6,\"O\",IF(T19=7,\"O\",IF(T19=9,\"O\",\"\"))))))","v":""},{"$f":"IF(T19=4,\"O\",IF(T19=6,\"O\",IF(T19=7,\"O\",IF(T19=9,\"O\",\"\"))))","v":""},{"$f":"IF(T19=1,\"O\",IF(T19=3,\"O\",IF(T19=5,\"O\",IF(T19=7,\"O\",IF(T19=9,\"O\",\"\")))))","v":""},{"$f":"IF(T19=4,\"O\",IF(T19=6,\"O\",IF(T19=7,\"O\",IF(T19=9,\"O\",\"\"))))","v":""},{"$f":"IF(T19=2,\"O\",IF(T19=3,\"O\",IF(T19=5,\"O\",IF(T19=6,\"O\",IF(T19=7,\"O\",IF(T19=9,\"O\",\"\"))))))","v":""},null,null,null,{"$f":"IF(F12<>\"\",ROUND(F12,0)&\"mm\",\"C\")","v":"C"},null,null,null,{"$f":"IF(I14<>\"\",I14&\"mm\",\"L\")","v":"L"}]
[null,null,null,null,null,null,{"$f":"IF(T19=4,\"O\",IF(T19=6,\"O\",IF(T19=7,\"O\",IF(T19=5,\"O\",IF(T19=9,\"O\",\"\")))))","v":""},null,null,null,null,null,{"$f":"IF(T19=4,\"O\",IF(T19=6,\"O\",IF(T19=7,\"O\",IF(T19=5,\"O\",IF(T19=9,\"O\",\"\")))))","v":""}]
[null,null,null,null,{"$f":"IF($B$23=$A$44,IF($A$26<>\"\",$A$26&\"mm\",\"A\"),\"\")","v":""},{"$f":"IF(T19=9,\"O\",\"\")","v":""},{"$f":"IF($B$23=$A$44,IF($A$26<>\"\",$A$26&\"mm\",\"A\"),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(T19=9,\"O\",\"\")","v":""}]
[null,null,null,{"$f":"IF($B$23=$A$44,IF($A$26<>\"\",$A$26&\"mm\",\"A\"),\"\")","v":""},"",{"$f":"IF($B$23=$A$44,IF($A$26<>\"\",$A$26&\"mm\",\"A\"),\"\")","v":""},""]
[null,null,{"$f":"IF($B$23=$A$44,IF($A$26<>\"\",$A$26&\"mm\",\"A\"),\"\")","v":""},"","","",""]
[null,{"$f":"IF($B$23=$A$44,IF($A$26<>\"\",$A$26&\"mm\",\"A\"),\"\")","v":""},"","","","","",{"$f":"IF($B$23=$A$44,IF($A$26<>\"\",$A$26&\"mm\",\"A\"),\"\")","v":""}]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","","",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I12<>\"\",I12&\"mm\",\"D\")","v":"D"}]
[{"$f":"IF(V12<>\"\",V12&\"mm\",\"H\")","v":"H"},"","","","","","",""]
[null,"","","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Length"]
[null,"","","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P8&\"mm\"","v":"mm"}]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","","",null,null,null,null,null,null,null,null,{"$f":"IF(B23=Gegevens!G17,IF(H26<>\"\",H26&\"mm\",\"C\"),\"\")","v":""}]
[null,{"$f":"IF(B23=Gegevens!G19,IF(K26<>\"\",K26&\"mm\",\"D\"),\"\")","v":""},null,{"$f":"IF(B23=Gegevens!G19,IF(C26<>\"\",C26&\"mm\",\"B\"),\"\")","v":""},null,null,"","",null,null,null,{"$f":"IF(Achthoek!B23=Gegevens!G17,IF(A26<>\"\",A26&\"mm\",\"A\"),\"\")","v":""},null,null,null,{"$f":"IF(Achthoek!B23=Gegevens!G17,IF(C26<>\"\",C26&\"mm\",\"B\"),\"\")","v":""}]
[null,null,null,null,null,null,"",""]
[{"$f":"IF(V14<>\"\",V14&\"mm\",\"P\")","v":"P"},null,null,null,null,null,"",""]
[null,{"$f":"IF($B$23=$A$44,IF($A$26<>\"\",$A$26&\"mm\",\"A\"),\"\")","v":""},{"$f":"IF($B$23=$A$44,IF($A$26<>\"\",$A$26&\"mm\",\"A\"),\"\")","v":""},null,null,{"$f":"IF(B23=Gegevens!G19,IF(A26<>\"\",A26&\"mm\",\"A\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L14<>\"\",L14&\"mm\",\"M\")","v":"M"}]
[null,{"$f":"IF($B$23=$A$44,IF($A$26<>\"\",$A$26&\"mm\",\"A\"),\"\")","v":""},{"$f":"IF($B$23=$A$44,IF($A$26<>\"\",$A$26&\"mm\",\"A\"),\"\")","v":""},{"$f":"IF($B$23=$A$44,IF($A$26<>\"\",$A$26&\"mm\",\"A\"),\"\")","v":""},{"$f":"IF($B$23=$A$44,IF($A$26<>\"\",$A$26&\"mm\",\"A\"),\"\")","v":""},null,{"$f":"IF(B23=Gegevens!G19,IF(C26<>\"\",C26&\"mm\",\"B\"),\"\")","v":""}]
[{"$f":"IF(T12<>\"\",ROUND(T12,0)&\"mm\",\"G\")","v":"G"},null,null,null,{"$f":"IF($B$23=$A$44,IF($A$26<>\"\",$A$26&\"mm\",\"A\"),\"\")","v":""},null,null,null,{"$f":"IF(B23=Gegevens!G18,IF(C26<>\"\",C26&\"mm\",\"B\"),\"\")","v":""},{"$f":"IF(B23=Gegevens!G18,IF(A26<>\"\",A26&\"mm\",\"A\"),\"\")","v":""},{"$f":"IF(B23=Gegevens!G18,IF(C26<>\"\",C26&\"mm\",\"B\"),\"\")","v":""},{"$f":"IF(B23=Gegevens!G17,IF(C26<>\"\",C26&\"mm\",\"B\"),\"\")","v":""},null,null,null,{"$f":"IF(L12<>\"\",ROUND(L12,0)&\"mm\",\"E\")","v":"E"}]
[null,null,null,null,{"$f":"IF($B$23=$A$44,IF($A$26<>\"\",$A$26&\"mm\",\"A\"),\"\")","v":""},{"$f":"IF($B$23=$A$44,IF($A$26<>\"\",$A$26&\"mm\",\"A\"),\"\")","v":""},{"$f":"IF(B23=Gegevens!G19,IF(H26<>\"\",H26&\"mm\",\"C\"),\"\")","v":""},null,null,null,null,{"$f":"IF(B23=Gegevens!G17,IF(K26<>\"\",K26&\"mm\",\"D\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF($B$23=$A$44,IF($A$26<>\"\",$A$26&\"mm\",\"A\"),\"\")","v":""},{"$f":"IF($B$23=$A$44,IF($A$26<>\"\",$A$26&\"mm\",\"A\"),\"\")","v":""},null,{"$f":"IF(B23=Gegevens!G18,IF(K26<>\"\",K26&\"mm\",\"D\"),\"\")","v":""},null,null,null,{"$f":"IF(B23=Gegevens!G18,IF(H26<>\"\",H26&\"mm\",\"C\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J29=\"JA\",\"Leading Edge\",\"\")","v":""}]
[null,{"$f":"IF(T14<>\"\",T14&\"mm\",\"O\")","v":"O"},null,null,null,null,null,null,null,{"$f":"IF($I$28=\"JA\",\"Leading Edge\",\"\")","v":""},null,null,null,{"$f":"IF(O14<>\"\",O14&\"mm\",\"N\")","v":"N"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(O12<>\"\",O12&\"mm\",\"F\")","v":"F"}]

{"sheet":"Rond","index":5,"n_rows":43,"n_cols":15,"rows_kept":43,"cut":false,"hidden":false,"merged":[[12,1,12,4],[12,7,12,10],[12,12,12,13],[3,2,3,4],[4,2,4,4],[5,2,5,3],[6,1,6,4],[7,6,7,10],[6,6,6,10],[6,12,6,13],[7,1,7,4],[11,1,11,4],[22,4,22,5],[22,6,22,7],[13,1,13,4],[13,7,13,10],[13,12,13,13],[18,4,18,5],[18,6,18,10],[18,11,18,12],[18,0,18,3],[19,0,19,3],[19,4,19,5],[19,6,19,10],[19,11,19,12]]}
[]
[]
[]
["Klant:"]
["Referentie:"]
["Afdekking",null,"(meer info)"]
["Configuratie","Omschrijving",null,null,null,"Prijs/m2","Diameter (mm)",null,null,null,null,null,"Opp.",null,"Catalogusprijs"]
[{"$f":"IF($B$8=Gegevens!$B$3,Gegevens!A3,IF($B$8=Gegevens!$B$4,Gegevens!A4,IF($B$8=Gegevens!$B$5,Gegevens!A5,IF($B$8=Gegevens!$B$6,Gegevens!A6,IF($B$8=Gegevens!$B$7,Gegevens!A7,IF($B$8=Gegevens!$B$9,Gegevens!A9,IF($B$8=Gegevens!$B$8,Gegevens!A8,\"\")))))))","v":3044030023},"Sol + Guard Geobubble",null,null,null,{"$f":"IF($B$8=Gegevens!$B$3,Gegevens!C3,IF($B$8=Gegevens!$B$4,Gegevens!C4,IF($B$8=Gegevens!$B$5,Gegevens!C5,IF($B$8=Gegevens!$B$6,Gegevens!C6,IF($B$8=Gegevens!$B$7,Gegevens!C7,IF($B$8=Gegevens!$B$9,Gegevens!C9,IF($B$8=Gegevens!$B$8,Gegevens!C8,\"\")))))))","v":13.58},null,null,null,null,null,{"$f":"$G$8/1000*$G$8/1000","v":0},{"$f":"ROUND(L8,0)","v":0},"m2",{"$f":"M8*F8","v":0}]
[{"$f":"IF(A8=Gegevens!A7,Gegevens!A48,IF(A8=Gegevens!A9,Gegevens!A48,IF(A8=Gegevens!A8,Gegevens!A48,Gegevens!A47)))","v":3044030009},{"$f":"IF(A9=Gegevens!A47,Gegevens!B47,Gegevens!B48)","v":"Shaping surcharge "},null,null,null,{"$f":"IF(A9=Gegevens!A47,Gegevens!F47,Gegevens!F48)","v":4.12},null,null,null,null,null,null,{"$f":"M8","v":0},"m2",{"$f":"M9*F9","v":0}]
[]
["Bevestigingen"]
["Configuratie","Omschrijving",null,null,null,"Prijs/stuk",null,null,null,null,null,null,"Totaal #",null,"Catalogusprijs"]
[{"$f":"IF($B$13=Gegevens!$B$12,Gegevens!A12,IF($B$13=Gegevens!$B$13,Gegevens!A13,\"\"))","v":3044030010},"Verstevigde oog-opening",null,null,null,{"$f":"IF($B$13=Gegevens!$B$12,Gegevens!C12,IF($B$13=Gegevens!$B$13,Gegevens!C13,Gegevens!C14))","v":13.66},null,"Vooraan",null,null,null,null,0,null,{"$f":"IF(A8=3044030006,0,(M13+M14)*F13)","v":0}]
[null,{"$f":"IF(Rond!A8=Gegevens!A9,\"Niet mogelijk\",\"\")","v":""},null,null,null,null,null,"Achteraan",null,null,null,null,0]
[]
["Resterende afmetingen"]
[]
["Afmetingen in mm"]
["Radius",null,null,null,null,null,"Test"]
[null,null,null,null,null,null,{"$f":"IF(A20<>\"\",IF(G8=2*A20,\"OK\",\"FOUT\"),\"\")","v":""}]
[]
["TOTAAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O13+O9+O8","v":0}]
[null,null,null,null,"Total Width:",null,{"$f":"$G$8&\"mm\"","v":"mm"}]
[]
[]
[]
[null,null,null,null,{"$f":"IF(M13=2,\"o\",IF(M13=4,\"o\",IF(M13=5,\"o\",IF(M13=6,\"o\",IF(M13=7,\"o\",\"\")))))","v":""},{"$f":"IF(M13=1,\"o\",IF(M13=3,\"o\",IF(M13=5,\"o\",IF(M13=7,\"o\",\"\"))))","v":""},{"$f":"IF(M13=2,\"o\",IF(M13=4,\"o\",IF(M13=5,\"o\",IF(M13=6,\"o\",IF(M13=7,\"o\",\"\")))))","v":""}]
[null,null,null,null,{"$f":"IF(M13=3,\"o\",IF(M13=6,\"o\",IF(M13=7,\"o\",\"\")))","v":""},null,{"$f":"IF(M13=3,\"o\",IF(M13=6,\"o\",IF(M13=7,\"o\",\"\")))","v":""}]
[null,null,null,{"$f":"IF(M13=4,\"o\",IF(M13=5,\"o\",IF(M13=6,\"o\",IF(M13=7,\"o\",\"\"))))","v":""},null,null,null,{"$f":"IF(M13=4,\"o\",IF(M13=5,\"o\",IF(M13=6,\"o\",IF(M13=7,\"o\",\"\"))))","v":""}]
["Radius"]
[{"$f":"IF($A$20<>\"\",$A$20&\"mm\",\"\")","v":""}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Length"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G8&\"mm\"","v":"mm"}]
[]
[]
[]
[]
[null,null,null,{"$f":"IF($M$14=4,\"o\",IF($M$14=5,\"o\",IF($M$14=6,\"o\",IF($M$14=7,\"o\",\"\"))))","v":""},null,null,null,{"$f":"IF($M$14=4,\"o\",IF($M$14=5,\"o\",IF($M$14=6,\"o\",IF($M$14=7,\"o\",\"\"))))","v":""}]
[{"$f":"IF($C$20<>\"\",$C$20&\"mm\",\"\")","v":""},null,null,{"$f":"IF($M$14=3,\"o\",IF($M$14=6,\"o\",IF($M$14=7,\"o\",\"\")))","v":""},null,null,null,{"$f":"IF($M$14=3,\"o\",IF($M$14=6,\"o\",IF($M$14=7,\"o\",\"\")))","v":""}]
[null,null,null,null,{"$f":"IF($M$14=2,\"o\",IF($M$14=4,\"o\",IF($M$14=5,\"o\",IF($M$14=6,\"o\",IF($M$14=7,\"o\",\"\")))))","v":""},{"$f":"IF($M$14=1,\"o\",IF($M$14=3,\"o\",IF($M$14=5,\"o\",IF($M$14=7,\"o\",\"\"))))","v":""},{"$f":"IF($M$14=2,\"o\",IF($M$14=4,\"o\",IF($M$14=5,\"o\",IF($M$14=6,\"o\",IF($M$14=7,\"o\",\"\")))))","v":""}]

{"sheet":"Info","index":6,"n_rows":90,"n_cols":4,"rows_kept":90,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,7],[14,0,14,8],[49,0,49,8],[84,0,84,3],[72,0,72,3],[48,0,48,3],[36,0,36,3],[25,0,25,3],[13,0,13,3],[61,0,61,3]]}
["Sol + Guard Geobubble"]
["Uniek aan de Sol+Guard is de dubbele laag, die gevormd wordt door een doorschijnende bovenkant in combinatie met een getinte, doorlatende onderkant."]
[]
[null,null,null,"Eigenschappen:"]
[null,null,null,"1) De temperatuur van uw zwembad kan met 8° stijgen"]
[null,null,null,"2) U kunt uw zwembadseizoen met 2 maanden verlengen"]
[null,null,null,"3) De waterverdamping vermindert met 98%"]
[null,null,null,"4) Het chemicaliënverbruik daalt met 30%"]
[null,null,null,"5) Het energieverbruik halveert"]
[null,null,null,"6) Het zwembad wordt minder vervuild"]
[null,null,null,"7) Alle kanten zijn voorzien van een blauwe zoom"]
[]
[]
["Energyguard Geobubble"]
["Dankzij de vernieuwende Energyguard afdekking, groeien er minder algen in uw zwembad en bespaar u geld, tijd, water en energie. De afdekking combineert een donkergrijze bovenkant met een zwarte onderkant, waardoor de energyguard tal van voordelen biedt voor de zwembadeigenaar."]
[]
[null,null,null,"Eigenschappen"]
[null,null,null,"1) Het chemicaliënverbruik met 70% verlagen"]
[null,null,null,"2) De pomp- en filtertijd halveren"]
[null,null,null,"3) Het zwembad met 4°C opwarmen"]
[null,null,null,"4) Kan gebruikt worden als winterafdekking"]
[]
[]
[]
[]
["Blauw 400/m2"]
[]
[null,null,null,"Eigenschappen"]
[null,null,null,"1) 400 micron"]
[null,null,null,"2) Anti-UV behandeling"]
[null,null,null,"3) Blauwe onder- en bovenkant"]
[]
[]
[]
[]
[]
["Apollo Geobubble"]
[]
[null,null,null,"Eigenschappen"]
[null,null,null,"1) Geobubble technologie"]
[null,null,null,"2) Zilveren onderkant voor extra warmte-isolatie"]
[null,null,null,"3) Blauwe bovenkant"]
[]
[]
[]
[]
[]
[]
["Supercover 5 mm"]
["Door middel van een 5mm dikke, isolerende supercover met een U-waarde van 6,8 W/m2, kunt u 87% van het potentieel warmteverlies besparen"]
[]
[null,null,null,"Eigenschappen:"]
[null,null,null,"1) 5mm polyolefin schuim-afdekking"]
[null,null,null,"2) Harde geweven bovenkant en onderlaag"]
[null,null,null,"3) Gevormd en afgewerkt naar uw wens"]
[null,null,null,"4 ) Max. temperatuur van 29°C"]
[null,null,null,"5) Afdekkingen van meer dan 12m vereisen versterkingsrail"]
[]
[]
[]
[]
["Supercover 8 mm"]
[]
[null,null,null,"Eigenschappen:"]
[null,null,null,"1) 8mm schuim-afdekking met reliëf onderzijde"]
[null,null,null,"2) Bovenkant van een gelamineerde UV-beschermlaag"]
[null,null,null,"3) Gevormd en afgewerkt naar uw wens"]
[null,null,null,"4 ) Max. temperatuur van 29°C (39°c max voor hydrotherapy zwembaden)"]
[null,null,null,"5) Afdekkingen van meer dan 12m vereisen versterkingsrail"]
[null,null,null,"6) Ook geschikt voor Hydrotherapy zwembaden"]
[]
[]
["Spa cover 12 mm"]
[]
[null,null,null,"Eigenschappen:"]
[null,null,null,"1) Speciaal ontworpen voor spa's en hydrotherapie-zwembaden"]
[null,null,null,"2) 12mm schuim"]
[null,null,null,"3) Onder- en bovenkant van een gelamineerde beschermlaag"]
[null,null,null,"4) max. Temperatuur van 39°C"]
[null,null,null,"5) Geen afboording, ogen en niet compatibel met oprolsystemen"]
[]
[]
[]
[]
["Verstevigde drijvboord + Trekkoord"]
[]
[null,null,null,"Eigenschappen:"]
[null,null,null,"1) Zorgt voor een vlotte geleiding bij oprollen en afrollen"]
[null,null,null,"2) Cover blijft perfect drijven"]
[null,null,null,"3) Dankzij het touw gaat het afrollen heel gemakkelijk"]

{"sheet":"Gegevens","index":7,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":true,"merged":[]}
[]
["Zomerzeilen"]
[3044030023,"Sol + Guard Geobubble",13.58,null,null,"JA"]
[3044030024,"Energyguard Geobubble",13.58,null,null,"NEEN"]
[3044030014,"Blauw 400/m2",8.43]
[3044030016,"Apollo Geobubble",9.89]
[3044030005,"Supercover 5 mm",41.17]
[3044030034,"Supercover 8 mm",57.91]
[3044030006,"Supercover 12 mm",51.02]
[]
["Bevestigingen"]
[3044030010,"Verstevigde oog-opening",13.66]
[3044030011,"Bevestigd lint",31.44]
[null,"Geen",0]
[]
["Trapuitsnijding"]
[null,"A-zijde",3044016025,53.1,3044030020,88.5,"A-zijde"]
[null,"B-zijde",3044016025,53.1,3044030020,88.5,"B-zijde"]
[null,"C-zijde",3044016025,53.1,3044030020,88.5,"C-zijde"]
[null,"D-zijde",3044016025,53.1,3044030020,88.5,"Geen"]
[null,"Geen"]
[]
["Aantal ogen"]
[0,0]
[1,1]
[2,2]
[3,3]
[4,4]
[5,5]
[6,6]
[7,7]
[8,9]
[9]
[10]
[]
[]
["Verstevigde drijvboord + Trekkoord"]
[3044030029,"Drijfboord voor breedte 2,74m - 3,96m (max lengte 9,15m)",null,null,null,242]
[3044030030,"Drijfboord voor breedte 3,96m - 5,18m (max lengte 12,2m)",null,null,null,288]
[3044030031,"Drijfboord voor breedte 5,18m - 6,4m (max lengte 15,25m)",null,null,null,331]
[]
["Romaanse trap"]
[3044030012,"Roman End shaping surcharge (price/piece)",null,null,null,41.79]
[3044030019,"Foam Roman End surcharge (price per piece)",null,null,null,73.69]
[]
["Shaping surcharge"]
[3044030009,"Shaping surcharge ",null,null,null,4.12]
[3044030018,"Foam Shaping surcharge ",null,null,null,6.73]

{"sheet":"TestFile voor Afgeronde Hoeken","index":8,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,null,"Recht",1]
[null,null,null,null,"Afgerond"]