{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Startpage","Rectangular","Roman Stair","Oval","Octagonal","Round","Info","Gegevens","TestFile voor Afgeronde Hoeken"],"not_rendered":{"charts":0,"images":10,"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":"Startpage","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,"Orderform Summer Covers"]
[]
[]
[null,null,"Choose your Pool:"]
[]
[null,null,"Rectangular Pool"]
[]
[null,"Rectangular Pool with Roman End"]
[]
[null,null,"Oval Pool"]
[]
[null,null,"Octagonal Pool"]
[]
[null,null,"Round Pool"]

{"sheet":"Rectangular","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],[31,12,31,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],[3,2,3,4],[23,0,23,4],[13,1,13,4],[16,1,16,4],[13,7,13,10],[9,6,9,7],[9,8,9,9],[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],[20,9,20,13],[5,2,5,3],[23,6,23,7],[4,2,4,4],[13,12,13,13],[21,9,21,13],[6,12,6,13],[6,9,6,10],[6,1,6,4],[7,1,7,4],[12,1,12,4],[7,9,7,10],[17,1,17,4]]}
[]
[]
[]
["Customer:"]
["Reference:"]
["Cover",null,"(more info)"]
["Reference","Description",null,null,null,"Price/m2","Width(mm)",null,"x","Length(mm)",null,null,"Surface",null,"Price Catalog."]
[{"$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$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$8,Gegevens!C8))))))","v":12.4},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}]
[]
["Corners",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 NEEDED\",\"OK\"),\"\")","v":""}]
[]
["Connections"]
["Reference","Description",null,null,null,"Price/piece",null,null,null,null,null,null,"Total #",null,"Price Catalog."]
[{"$f":"IF($B$14=Gegevens!$B$11,Gegevens!A11,IF($B$14=Gegevens!$B$12,Gegevens!A12,\"\"))","v":3044030010},"Reinforced Eyelet",null,null,null,{"$f":"IF($B$14=Gegevens!$B$11,Gegevens!C11,IF($B$14=Gegevens!$B$12,Gegevens!C12,Gegevens!C13))","v":7.5},null,{"$f":"IF(A8=Gegevens!A8,\"Niet mogelijk\",\"\")","v":""},null,null,null,null,0,null,{"$f":"IF(A8=3044030006,0,M14*F14)","v":0}]
[]
["Cut-out for step"]
["Reference","Side",null,null,null,"Price/piece",null,null,null,null,null,null,null,null,"Price Catalog."]
[{"$f":"IF($B$18=Gegevens!$B$20,\"\",IF(A8=Gegevens!A7,Gegevens!E16,IF(A8=Gegevens!A8,Gegevens!E16,Gegevens!C17)))","v":""},"None",null,null,null,{"$f":"IF($B$18=Gegevens!$B$20,\"\",IF($A$8=Gegevens!$A$7,Gegevens!F16,IF($A$8=Gegevens!$A$8,Gegevens!F16,Gegevens!D16)))","v":""},null,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=\"\"),\"FAULT\",IF(A22+E22+G22=J8,\"OK\",\"FAULT\")),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":""}]
[]
["Leading Edge",null,null,null,null,"NO","(more info)"]
["Reference","Description",null,null,null,null,null,null,null,null,null,null,null,null,"Price Catalog."]
[{"$f":"IF($F$24=Gegevens!F4,\"\",IF($G$8<=3960,IF($J$8<=9150,3044030029,IF($J$8<=12200,3044030030,IF($J$8<=15250,3044030031,\"Too long\"))),IF($G$8<=5180,IF($J$8<=12200,3044030030,IF($J$8<=15250,3044030031,\"Too long\")),IF($G$8<=6400,IF($J$8<=15250,3044030031,\"Too long\"),\"Too wide\"))))","v":""},{"$f":"IF(A26=Gegevens!A37,Gegevens!B37,IF(A26=Gegevens!A38,Gegevens!B38,IF(A26=Gegevens!A39,Gegevens!B39,\"\")))","v":""},null,null,null,null,null,null,null,{"$f":"IF(A8=Gegevens!A8,\"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!A37,Gegevens!F37,IF(A26=Gegevens!A38,Gegevens!F38,IF(A26=Gegevens!A39,Gegevens!F39,0)))))","v":0}]
[]
["TOTAL",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-side"]
[{"$f":"IF($O$34=2,IF($G$10=\"\",\"\",\"R:\"&\" \"&$G$10&\"mm\"),\"\")","v":""},{"$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":""},{"$f":"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=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":""},null,{"$f":"IF($O$34=2,IF($G$10=\"\",\"\",\"R:\"&\" \"&$G$10&\"mm\"),\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Straight",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Rounded"]
[]
[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-side",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-side",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(B18=F59,IF(E22<>\"\",E22&\"mm\",\"C\"),\"\")","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(B18=F59,IF(C22<>\"\",C22&\"mm\",\"B\"),\"\")","v":""},null,{"$f":"IF(F24=\"JA\",\"Leading Edge\",\"\")","v":""},{"$f":"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-side"]

{"sheet":"Roman Stair","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],[19,9,19,13],[20,0,20,1],[20,2,20,3],[20,4,20,5],[20,6,20,7],[20,9,20,13],[24,6,24,7],[24,4,24,5],[3,2,3,4],[4,2,4,4],[6,1,6,4],[6,6,6,7],[12,7,12,10],[5,2,5,3],[42,1,42,3],[42,9,42,10],[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],[26,12,26,14],[37,1,37,3],[37,9,37,10],[31,1,31,3],[31,9,31,10],[32,1,32,3],[51,12,51,14],[51,2,51,3],[51,8,51,10],[51,4,51,6],[50,1,50,3],[50,9,50,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]]}
[]
[]
[]
["Customer:"]
["Reference:"]
["Cover",null,"(more info)"]
["Reference","Description",null,null,null,"Price/m2","Width(mm)",null,"x","Length(mm)",null,null,"Surface",null,"Price Catalog."]
[{"$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$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$8,Gegevens!C8))))))","v":12.4},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}]
[]
["Corners",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 MISSING\",\"OK\"),\"\")","v":""}]
[]
["Reference","Description",null,null,null,"Price/piece",null,null,null,null,null,null,"Total #",null,"Price Catalog."]
[{"$f":"IF($B$13=Gegevens!$B$11,Gegevens!A11,IF($B$13=Gegevens!$B$12,Gegevens!A12,\"\"))","v":3044030010},"Reinforced Eyelet",null,null,null,{"$f":"IF($B$13=Gegevens!$B$11,Gegevens!C11,IF($B$13=Gegevens!$B$12,Gegevens!C12,Gegevens!C13))","v":7.5},null,{"$f":"IF(A8=Gegevens!A8,\"Not possible\",\"\")","v":""},null,null,null,null,0,null,{"$f":"IF(A8=3044030006,0,M13*F13)","v":0}]
[]
["Roman End"]
["Reference","Description",null,null,null,null,null,null,null,null,null,null,null,null,"Price Catalog."]
[{"$f":"IF($A$8=Gegevens!$A$7,Gegevens!$A$43,IF($A$8=Gegevens!$A$8,Gegevens!$A$43,Gegevens!$A$42))","v":3044030012},{"$f":"IF('Roman Stair'!$A$17=Gegevens!$A$42,Gegevens!$B$42,Gegevens!$B$43)","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$42,Gegevens!$F$42,Gegevens!$F$43)","v":36.200000000000003}]
[]
["Dimensions in mm"]
["A",null,"B",null,"C",null,"Radius",null,null,"Test"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(A21=\"\",C21=\"\",E21=\"\",G21=\"\"),\"FAULT\",IF(A21+C21+E21=G8,IF(C21=2*G21,\"OK\",\"FAULT\"),\"FAULT\"))","v":"FAULT"}]
[]
["TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O17+O13+O8","v":36.200000000000003}]
[]
[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,"Straight"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Rounded",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($G$21<>\"\",$G$21&\"mm\",\"\")","v":"Radius="}]

{"sheet":"Oval","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]]}
[]
[]
[]
["Customer:"]
["Reference:"]
["Cover",null,"(more info)"]
["Reference","Description",null,null,null,"Price/m2","Width(mm)",null,"x","Length(mm)",null,null,"Surface",null,"Price Catalog."]
[{"$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$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$8,Gegevens!C8))))))","v":12.4},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!A47,IF(A8=Gegevens!A8,Gegevens!A47,Gegevens!A46))","v":3044030009},{"$f":"IF(A9=Gegevens!A46,Gegevens!B46,Gegevens!B47)","v":"Shaping surcharge "},null,null,null,{"$f":"IF(A9=Gegevens!A46,Gegevens!F46,Gegevens!F47)","v":3.6},null,null,null,null,null,null,{"$f":"M8","v":0},"m2",{"$f":"M9*F9","v":0}]
[]
["Connections"]
["Reference","Description",null,null,null,"Price/piece",null,null,null,null,null,null,"Total #",null,"Price Catalog."]
[{"$f":"IF($B$13=Gegevens!$B$11,Gegevens!A11,IF($B$13=Gegevens!$B$12,Gegevens!A12,\"\"))","v":3044030010},"Reinforced Eyelet",null,null,null,{"$f":"IF($B$13=Gegevens!$B$11,Gegevens!C11,IF($B$13=Gegevens!$B$12,Gegevens!C12,Gegevens!C13))","v":7.5},null,"Front",null,null,null,null,0,null,{"$f":"IF(A8=3044030006,0,(M13+M14)*F13)","v":0}]
[null,{"$f":"IF(Oval!A8=Gegevens!A8,\"Niet mogelijk\",\"\")","v":""},null,null,null,null,null,"Back",null,null,null,null,0]
[]
["Additional Dimensions"]
[]
["Dimensions in mm"]
["Radius",null,"Short length",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\",\"FAULT\"),\"FAULT\"),\"\")","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":"Octagonal","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]]}
[]
[]
[]
["Customer:"]
["Reference:"]
["Cover",null,"(more info)"]
["Reference:","Description",null,null,null,null,null,null,null,"Price/m2",null,"Width(mm)",null,null,"x","Length mm",null,null,null,"Surface",null,"Price Catalog."]
[{"$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$8,Gegevens!A8))))))","v":3044030005},"Supercover 5 mm",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$8,Gegevens!C8))))))","v":21.8},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!A8,Gegevens!A47,IF(A8=Gegevens!A7,Gegevens!A47,Gegevens!A46))","v":3044030018},{"$f":"IF(A9=Gegevens!A47,Gegevens!B47,Gegevens!B46)","v":"Foam Shaping surcharge "},null,null,null,null,null,null,null,{"$f":"IF(A9=Gegevens!A47,Gegevens!F47,Gegevens!F46)","v":3.5},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\",\"Geometric fault\"),\"Fill in completely\")","v":"Fill in completely"}]
[]
["Connections"]
["Reference","Description",null,null,null,null,null,null,null,"Price/pcs",null,null,null,null,null,null,null,null,null,"Total #",null,"Price Catalog."]
[{"$f":"IF($B$19=Gegevens!$B$11,Gegevens!A11,IF($B$19=Gegevens!$B$12,Gegevens!A12,\"\"))","v":3044030010},"Reinforced Eyelet",null,null,null,null,null,null,null,{"$f":"IF($B$19=Gegevens!$B$11,Gegevens!C11,IF($B$19=Gegevens!$B$12,Gegevens!C12,Gegevens!C13))","v":7.5},null,null,null,{"$f":"IF(A8=Gegevens!A8,\"Niet mogelijk\",\"\")","v":""},null,null,null,null,null,0,null,{"$f":"IF(A8=3044030006,0,T19*J19)","v":0}]
[]
["Cut-out for step"]
["Reference","Side",null,null,null,null,null,null,null,"Price/pcs",null,null,null,null,null,null,null,null,null,null,null,"Price Catalog."]
[{"$f":"IF($B$23=Gegevens!$B$20,\"\",IF(A8=Gegevens!A7,Gegevens!E16,IF(A8=Gegevens!A8,Gegevens!E16,Gegevens!C17)))","v":""},"None",null,null,null,null,null,null,null,{"$f":"IF($B$23=Gegevens!$B$20,\"\",IF($A$8=Gegevens!$A$7,Gegevens!F16,IF($A$8=Gegevens!$A$8,Gegevens!F16,Gegevens!D16)))","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!B20,\"\",IF(B23=Gegevens!B16,IF(L12=A26+H26+K26,\"OK\",\"FAULT\"),IF(B23=Gegevens!B17,IF(O12=A26+H26+K26,\"OK\",\"FAULT\"),IF(Octagonal!B23=Gegevens!B18,IF(A26+H26+K26=T12,\"OK\",\"FAULT\"),\"FAULT\")))),\"\")","v":""}]
[]
["Leading Edge",null,null,null,null,null,null,null,"NO",null,"(more info)"]
["Reference","Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Price Catalog."]
[{"$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,\"Too long\"))),IF($L$8<=5180,IF($P$8<=12200,3044030030,IF($P$8<=15250,3044030031,\"Too long\")),IF($L$8<=6400,IF($P$8<=15250,3044030031,\"Too long\"),\"Too wide\"))),\"\"))","v":""},{"$f":"IF(A30=Gegevens!A37,Gegevens!B37,IF(A30=Gegevens!A38,Gegevens!B38,IF(A30=Gegevens!A39,Gegevens!B39,\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A8=Gegevens!A8,\"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!A37,Gegevens!F37,IF(A30=Gegevens!A38,Gegevens!F38,IF(A30=Gegevens!A39,Gegevens!F39,0)))))","v":0}]
[]
["TOTAL",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!G16,IF(H26<>\"\",H26&\"mm\",\"C\"),\"\")","v":""}]
[null,{"$f":"IF(B23=Gegevens!G18,IF(K26<>\"\",K26&\"mm\",\"D\"),\"\")","v":""},null,{"$f":"IF(B23=Gegevens!G18,IF(C26<>\"\",C26&\"mm\",\"B\"),\"\")","v":""},null,null,"","",null,null,null,{"$f":"IF(Octagonal!B23=Gegevens!G16,IF(A26<>\"\",A26&\"mm\",\"A\"),\"\")","v":""},null,null,null,{"$f":"IF(Octagonal!B23=Gegevens!G16,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!G18,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!G18,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!G17,IF(C26<>\"\",C26&\"mm\",\"B\"),\"\")","v":""},{"$f":"IF(B23=Gegevens!G17,IF(A26<>\"\",A26&\"mm\",\"A\"),\"\")","v":""},{"$f":"IF(B23=Gegevens!G17,IF(C26<>\"\",C26&\"mm\",\"B\"),\"\")","v":""},{"$f":"IF(B23=Gegevens!G16,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!G18,IF(H26<>\"\",H26&\"mm\",\"C\"),\"\")","v":""},null,null,null,null,{"$f":"IF(B23=Gegevens!G16,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!G17,IF(K26<>\"\",K26&\"mm\",\"D\"),\"\")","v":""},null,null,null,{"$f":"IF(B23=Gegevens!G17,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":"Round","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,12,6,13],[7,1,7,4],[11,1,11,4],[6,6,6,7],[6,9,6,10],[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]]}
[]
[]
[]
["Customer:"]
["Reference:"]
["Cover",null,"(moreinfo)"]
["Reference","Description",null,null,null,"Price/m2","Width(mm)",null,"x","Length(mm)",null,null,"Surface",null,"Price Catalog."]
[{"$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$8,Gegevens!A8))))))","v":3044030005},"Supercover 5 mm",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$8,Gegevens!C8))))))","v":21.8},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!A47,IF(A8=Gegevens!A8,Gegevens!A47,Gegevens!A46))","v":3044030018},{"$f":"IF(A9=Gegevens!A46,Gegevens!B46,Gegevens!B47)","v":"Foam Shaping surcharge "},null,null,null,{"$f":"IF(A9=Gegevens!A46,Gegevens!F46,Gegevens!F47)","v":3.5},null,null,null,null,null,null,{"$f":"M8","v":0},"m2",{"$f":"M9*F9","v":0}]
[]
["Connections"]
["Reference","Description",null,null,null,"Price/piece",null,null,null,null,null,null,"Total #",null,"Price Catalog."]
[{"$f":"IF($B$13=Gegevens!$B$11,Gegevens!A11,IF($B$13=Gegevens!$B$12,Gegevens!A12,\"\"))","v":3044030010},"Reinforced Eyelet",null,null,null,{"$f":"IF($B$13=Gegevens!$B$11,Gegevens!C11,IF($B$13=Gegevens!$B$12,Gegevens!C12,Gegevens!C13))","v":7.5},null,"Vooraan",null,null,null,null,null,null,{"$f":"IF(A8=3044030006,0,(M13+M14)*F13)","v":0}]
[null,{"$f":"IF(Round!A8=Gegevens!A8,\"Niet mogelijk\",\"\")","v":""},null,null,null,null,null,"Achteraan"]
[]
["Additional Dimensions"]
[]
["Dimensions in mm"]
["Radius",null,null,null,null,null,"Test"]
[null,null,null,null,null,null,{"$f":"IF(A20<>\"\",IF(G8=2*A20,\"OK\",\"FAULT\"),\"\")","v":""}]
[]
["TOTAL",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":80,"n_cols":4,"rows_kept":80,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,7],[73,0,73,3],[61,0,61,3],[49,0,49,3],[37,0,37,3],[26,0,26,3],[13,0,13,3],[14,0,15,8]]}
["Sol + Guard Geobubble"]
["Sol + Guard™ has a unique two ply combination, a clear top\nsurface and a translucent tinted underside for"]
[]
[]
[null,null,null,"1. Best solar gain properties - up to 8 degrees extra heat !"]
[null,null,null,"2. Extends your swimming pool season by up to two months !"]
[null,null,null,"3. Eliminate water evaporation by 98%."]
[null,null,null,"4. Reduce chemical consumption by up to 30%."]
[null,null,null,"5. Lower energy consumption by over 50%."]
[null,null,null,"6. Reduce debris contamination."]
[null,null,null,"7. Blue hemming on all sides"]
[]
[]
["Energyguard Geobubble"]
["The innovative EnergyGuard cover inhibits swimming pool algae and saves money, time, water and energy usage. The product has a dark blue top surface and a black underside. It is this combination that gives the EnergyGuard cover the ability to provide a variety of benefits to the pool owner."]
[]
[]
[null,null,null,"Features"]
[null,null,null,"1. Greatly reduce chemical consumption - up to 70%"]
[null,null,null,"2. Reduce pump and filtration time by 50%"]
[null,null,null,"3. Heat the pool by up to 4 degrees Celsius"]
[null,null,null,"4. Can be used as a winter cover"]
[]
[]
[]
[]
["Blauw 400/m2"]
[]
[null,null,null,"Features"]
[null,null,null,"• 400 micron"]
[null,null,null,"• UV stabilised"]
[null,null,null,"• Blue top and underside"]
[null,null,null,"• Blue hemming on all sides"]
[]
[]
[]
[]
["Apollo Geobubble"]
[]
[null,null,null,"Features"]
[null,null,null,"• 400 micron"]
[null,null,null,"• Silver underside gives extra heat retention"]
[null,null,null,"• Blue top with silver underside"]
[null,null,null,"• Blue hemming on all sides"]
[]
[]
[]
[]
[]
["Supercover 5 mm"]
[]
[null,null,null,"Features"]
[null,null,null,"• 5mm thick heat retention Supercover with an U value of 6,8w/sq.m.°C will save 87% of heat loss."]
[null,null,null,"• 5mm polyolefin closed cell foam cover"]
[null,null,null,"• Tough woven top and bottom sheet for maximum heat retention and strength"]
[null,null,null,"• Heat welded ,shaped and hemmed to your specification"]
[null,null,null,"• 29°C max. temperature"]
[null,null,null,"• Covers over 12m should have a leading edge."]
[null,null,null,"• Possible to use with a reel system"]
[null,null,null,"• Blue hemming on all sides"]
[]
["Spa cover 8 mm"]
[]
[null,null,null,"Features"]
[null,null,null,"• 8mm foam centre with embossed underside"]
[null,null,null,"• Polyolefine woven top laminate with UV stabilised coating"]
[null,null,null,"• Shaped and hemmed to your specification"]
[null,null,null,"• Suitable for hydrotherapy pools"]
[null,null,null,"• Weighs 0.53kg per sq.m"]
[null,null,null,"• 29°C maximum temperature (39°C max for hydrotherapy pools)"]
[null,null,null,"• 4 year pro-rata guarantee (one year on hydrotherapy pools)"]
[]
[]
["Verstevigde drijvboord + Trekkoord"]
[]
[null,null,null,"Features"]
[null,null,null,"• Guides the cover perfectly while rolling up or of."]
[null,null,null,"• The front of the cover floats perfectly and doesn’t sink anymore."]
[null,null,null,"• Thanks to the rope, closing the pool is child’s play."]
[null,null,null,"Not for 12mm cover."]

{"sheet":"Gegevens","index":7,"n_rows":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
[]
["Zomerzeilen"]
[3044030023,"Sol + Guard Geobubble",12.4,null,null,"YES"]
[3044030024,"Energyguard Geobubble",12.4,null,null,"NO"]
[3044030014,"Blauw 400/m2",9.6]
[3044030016,"Apollo Geobubble",11.5]
[3044030005,"Supercover 5 mm",21.8]
[3044030006,"Foam spa cover 8 mm",30.7]
[]
["Bevestigingen"]
[3044030010,"Reinforced Eyelet",7.5]
[3044030011,"Attached Strap",12.2]
[null,"None",0]
[]
["Trapuitsnijding"]
[null,"A-side",3044016025,46,3044030020,46,"A-side"]
[null,"B-side",3044016025,46,3044030020,46,"B-side"]
[null,"C-side",3044016025,46,3044030020,46,"C-side"]
[null,"D-side",3044016025,46,3044030020,46,"None"]
[null,"None"]
[]
["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,"Leading Edge for width 2,74m - 3,96m (max length 9,15m)",null,null,null,146]
[3044030030,"Leading Edge for width 3,96m - 5,18m (max length 12,2m)",null,null,null,174]
[3044030031,"Leading Edge for width 5,18m - 6,4m (max length 15,25m)",null,null,null,200]
[]
["Romaanse trap"]
[3044030012,"Roman End shaping surcharge (price/piece)",null,null,null,36.200000000000003]
[3044030019,"Foam Roman End surcharge (price per piece)",null,null,null,38.299999999999997]
[]
["Shaping surcharge"]
[3044030009,"Shaping surcharge ",null,null,null,3.6]
[3044030018,"Foam Shaping surcharge ",null,null,null,3.5]

{"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"]