{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Project","Settings","Multidecks","Products"],"not_rendered":{"images":5,"defined_names":13},"read":"whole","date_system":"1900"}

{"sheet":"Project","index":0,"n_rows":75,"n_cols":18,"rows_kept":75,"merged":[[5,2,5,3],[5,4,17,6],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[23,2,23,6],[37,2,37,6],[70,2,70,3],[70,4,70,6],[71,2,71,3],[71,4,71,6],[72,2,72,3],[72,4,72,6],[73,2,73,3],[73,4,73,6],[74,2,74,3],[74,4,74,6]]}
[]
[null,"Project Planning",{"$nulls":7},"Shelf Planning Tool Version:","2025-07-16:1"]
[null,"TurnLoader"]
[null,"HL powered by EasyFill"]
[]
[null,"Date:",null,null,{"$f":"Picture","v":{"$error":"#VALUE!"}}]
[null,"Name:"]
[null,"Project:"]
[null,"TurnLoader Type","Multideck"]
[null,"TurnLoader Model",{"$f":"_xlfn.XLOOKUP(getMultideck,tableMultidecks[Multidecks],tableMultidecks[TurnLoader],\"\")","v":"TurnLoader MD 1250/550"}]
[]
[null,"TurnLoader Usable Height:",{"$f":"_xlfn.XLOOKUP(getMultideck,tableMultidecks[Multidecks],tableMultidecks[Usable Height],\"\")","v":1483},"mm"]
[]
[null,"Refrigeration Unit","Carrier MonaxEco 63"]
[null,"Inner height:",{"$f":"_xlfn.XLOOKUP(getMultideck,tableMultidecks[Multidecks],tableMultidecks[Inner height],\"\")","v":1785}]
[null,"Shelf depth:",{"$f":"_xlfn.XLOOKUP(getMultideck,tableMultidecks[Multidecks],tableMultidecks[Shelf depth],\"\")","v":500}]
[null,"Distance back wall to door",{"$f":"_xlfn.XLOOKUP(getMultideck,tableMultidecks[Multidecks],tableMultidecks[Distans backwall to door],\"\")","v":610}]
[]
[]
[null,"Number of Sectins",{"$f":"COUNTIF(C23:G23,\">0\")","v":2}]
[null,null,"Section 1","Section 2","Section 3","Section 4","Section 5"]
[null,"Section name"]
[null,"Number of existing shelves",{"$f":"COUNTA(C25:C33)","v":3},{"$f":"COUNTA(D25:D33)","v":3},0,0,0]
[null,"Total number of shelves",{"$f":"SUM(C23:G23)","v":6},{"$nulls":10},"Helper Table for Sizes"]
[null,"Product height Shelf 9",{"$nulls":7},{"$f":"\"Example with usable height \" & $C$12 & \" mm\"","v":"Example with usable height 1483 mm"},"mm",null,null,{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(C25,tableProducts[Name],tableProducts[Product Height],C25,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(D25,tableProducts[Name],tableProducts[Product Height],D25,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(E25,tableProducts[Name],tableProducts[Product Height],E25,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(F25,tableProducts[Name],tableProducts[Product Height],F25,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(G25,tableProducts[Name],tableProducts[Product Height],G25,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""}]
[null,"Product height Shelf 8",{"$nulls":7},"Avg. product height with 4 shelves",{"$f":"_xlfn.LET(\n_xlpm.noOfShelves,4,\nROUNDDOWN(($C$12-((shelfHeight+stdMarginSpace)*_xlpm.noOfShelves))/_xlpm.noOfShelves,0))","v":318},null,null,{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(C26,tableProducts[Name],tableProducts[Product Height],C26,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(D26,tableProducts[Name],tableProducts[Product Height],D26,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(E26,tableProducts[Name],tableProducts[Product Height],E26,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(F26,tableProducts[Name],tableProducts[Product Height],F26,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(G26,tableProducts[Name],tableProducts[Product Height],G26,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""}]
[null,"Product height Shelf 7",{"$nulls":7},"Avg. product height with 5 shelves",{"$f":"_xlfn.LET(\n_xlpm.noOfShelves,5,\nROUNDDOWN(($C$12-((shelfHeight+stdMarginSpace)*_xlpm.noOfShelves))/_xlpm.noOfShelves,0))","v":244},null,null,{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(C27,tableProducts[Name],tableProducts[Product Height],C27,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(D27,tableProducts[Name],tableProducts[Product Height],D27,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(E27,tableProducts[Name],tableProducts[Product Height],E27,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(F27,tableProducts[Name],tableProducts[Product Height],F27,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(G27,tableProducts[Name],tableProducts[Product Height],G27,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""}]
[null,"Product height Shelf 6",{"$nulls":7},"Avg. product height with 6 shelves",{"$f":"_xlfn.LET(\n_xlpm.noOfShelves,6,\nROUNDDOWN(($C$12-((shelfHeight+stdMarginSpace)*_xlpm.noOfShelves))/_xlpm.noOfShelves,0))","v":195},null,null,{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(C28,tableProducts[Name],tableProducts[Product Height],C28,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(D28,tableProducts[Name],tableProducts[Product Height],D28,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(E28,tableProducts[Name],tableProducts[Product Height],E28,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(F28,tableProducts[Name],tableProducts[Product Height],F28,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(G28,tableProducts[Name],tableProducts[Product Height],G28,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""}]
[null,"Product height Shelf 5",{"$nulls":7},"Avg. product height with 7 shelves",{"$f":"_xlfn.LET(\n_xlpm.noOfShelves,7,\nROUNDDOWN(($C$12-((shelfHeight+stdMarginSpace)*_xlpm.noOfShelves))/_xlpm.noOfShelves,0))","v":159},null,null,{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(C29,tableProducts[Name],tableProducts[Product Height],C29,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(D29,tableProducts[Name],tableProducts[Product Height],D29,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(E29,tableProducts[Name],tableProducts[Product Height],E29,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(F29,tableProducts[Name],tableProducts[Product Height],F29,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(G29,tableProducts[Name],tableProducts[Product Height],G29,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""}]
[null,"Product height Shelf 4",{"$nulls":7},"Avg. product height with 8 shelves",{"$f":"_xlfn.LET(\n_xlpm.noOfShelves,8,\nROUNDDOWN(($C$12-((shelfHeight+stdMarginSpace)*_xlpm.noOfShelves))/_xlpm.noOfShelves,0))","v":133},null,null,{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(C30,tableProducts[Name],tableProducts[Product Height],C30,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(D30,tableProducts[Name],tableProducts[Product Height],D30,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(E30,tableProducts[Name],tableProducts[Product Height],E30,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(F30,tableProducts[Name],tableProducts[Product Height],F30,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(G30,tableProducts[Name],tableProducts[Product Height],G30,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""}]
[null,"Product height Shelf 3","33 cl Classic Can","150 cl PET Bottle",{"$nulls":5},"Avg. product height with 9 shelves",{"$f":"_xlfn.LET(\n_xlpm.noOfShelves,9,\nROUNDDOWN(($C$12-((shelfHeight+stdMarginSpace)*_xlpm.noOfShelves))/_xlpm.noOfShelves,0))","v":112},null,null,{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(C31,tableProducts[Name],tableProducts[Product Height],C31,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":115},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(D31,tableProducts[Name],tableProducts[Product Height],D31,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":325},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(E31,tableProducts[Name],tableProducts[Product Height],E31,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(F31,tableProducts[Name],tableProducts[Product Height],F31,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(G31,tableProducts[Name],tableProducts[Product Height],G31,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""}]
[null,"Product height Shelf 2","50 cl PET Bottle","33 cl Classic Can",{"$nulls":9},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(C32,tableProducts[Name],tableProducts[Product Height],C32,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":213},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(D32,tableProducts[Name],tableProducts[Product Height],D32,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":115},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(E32,tableProducts[Name],tableProducts[Product Height],E32,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(F32,tableProducts[Name],tableProducts[Product Height],F32,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(G32,tableProducts[Name],tableProducts[Product Height],G32,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""}]
[null,"Product height Shelf 1","33 cl Classic Can","33 cl Sleek Can",{"$nulls":9},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(C33,tableProducts[Name],tableProducts[Product Height],C33,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":115},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(D33,tableProducts[Name],tableProducts[Product Height],D33,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":145},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(E33,tableProducts[Name],tableProducts[Product Height],E33,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(F33,tableProducts[Name],tableProducts[Product Height],F33,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""},{"$f":"_xlfn.LET(\n_xlpm.size,_xlfn.XLOOKUP(G33,tableProducts[Name],tableProducts[Product Height],G33,0),\nIF(_xlpm.size=0,\"\",_xlpm.size)\n)","v":""}]
[]
[null,"Number of TurnLoaders:",{"$f":"C20","v":2},{"$nulls":6},"Standard product heights","mm"]
[null,null,{"$f":"C21","v":"Section 1"},{"$f":"D21","v":"Section 2"},"Section 3","Section 4","Section 5",null,null,{"$f":"tableProducts[]","v":"25 cl Slim Can"},135]
[null,"Number of shelves",{"$f":"COUNTA(C25:C33)","v":3},{"$f":"COUNTA(D25:D33)","v":3},{"$f":"COUNTA(E25:E33)","v":0},{"$f":"COUNTA(F25:F33)","v":0},{"$f":"COUNTA(G25:G33)","v":0},null,null,"33 cl Classic Can",115]
[null,"Total number of shelves",{"$f":"SUM(C37:G37)","v":6},{"$nulls":6},"33 cl Sleek Can",145]
[null,{"$f":"\"Used height (max \" & C12 & \")\"","v":"Used height (max 1483)"},{"$f":"IFERROR(getUsedHeight(C$40,N$25:N$33,$C$12),\"\")","v":599},{"$f":"IFERROR(getUsedHeight(D$40,O$25:O$33,$C$12),\"\")","v":741},{"$f":"IFERROR(getUsedHeight(E$40,P$25:P$33,$C$12),\"\")","v":0},{"$f":"IFERROR(getUsedHeight(F$40,Q$25:Q$33,$C$12),\"\")","v":0},{"$f":"IFERROR(getUsedHeight(G$40,R$25:R$33,$C$12),\"\")","v":0},null,null,"33 cl Glass Bottle",240]
[null,"Distance above products","15 mm","15 mm","15 mm","15 mm","15 mm",null,null,"50 cl Std Can",168]
[null,"Even spacing",{"$f":"_xlfn.LET(\n_xlpm.isEvenlyDistributed,IF(_xlfn.XLOOKUP(C40,tableClearance[Description],tableClearance[Value],0,0)=\"even\",TRUE,FALSE),\n_xlpm.clearance,IFERROR(getClearance(C40,N25:N33,$C$12),\"\"),\nIF(_xlpm.isEvenlyDistributed,_xlpm.clearance,\"\"))","v":""},{"$f":"_xlfn.LET(\n_xlpm.isEvenlyDistributed,IF(_xlfn.XLOOKUP(D40,tableClearance[Description],tableClearance[Value],0,0)=\"even\",TRUE,FALSE),\n_xlpm.clearance,IFERROR(getClearance(D40,O25:O33,$C$12),\"\"),\nIF(_xlpm.isEvenlyDistributed,_xlpm.clearance,\"\"))","v":""},{"$f":"_xlfn.LET(\n_xlpm.isEvenlyDistributed,IF(_xlfn.XLOOKUP(E40,tableClearance[Description],tableClearance[Value],0,0)=\"even\",TRUE,FALSE),\n_xlpm.clearance,IFERROR(getClearance(E40,P25:P33,$C$12),\"\"),\nIF(_xlpm.isEvenlyDistributed,_xlpm.clearance,\"\"))","v":""},{"$f":"_xlfn.LET(\n_xlpm.isEvenlyDistributed,IF(_xlfn.XLOOKUP(F40,tableClearance[Description],tableClearance[Value],0,0)=\"even\",TRUE,FALSE),\n_xlpm.clearance,IFERROR(getClearance(F40,Q25:Q33,$C$12),\"\"),\nIF(_xlpm.isEvenlyDistributed,_xlpm.clearance,\"\"))","v":""},{"$f":"_xlfn.LET(\n_xlpm.isEvenlyDistributed,IF(_xlfn.XLOOKUP(G40,tableClearance[Description],tableClearance[Value],0,0)=\"even\",TRUE,FALSE),\n_xlpm.clearance,IFERROR(getClearance(G40,R25:R33,$C$12),\"\"),\nIF(_xlpm.isEvenlyDistributed,_xlpm.clearance,\"\"))","v":""},null,null,"50 cl PET Bottle",213]
[null,"Frontstopper 9",{"$f":"getFrontstop(C43)","v":""},{"$f":"getFrontstop(D43)","v":""},{"$f":"getFrontstop(E43)","v":""},{"$f":"getFrontstop(F43)","v":""},{"$f":"getFrontstop(G43)","v":""},null,null,"150 cl PET Bottle",325]
[null,"Product height Shelf 9",{"$f":"_xlfn.LET(_xlpm.value,_xlfn.XLOOKUP($B43,$B$25:$B$33,N$25:N$33,NA()),IF(ISBLANK(_xlpm.value),\"\",_xlpm.value))","v":""},{"$f":"_xlfn.LET(_xlpm.value,_xlfn.XLOOKUP($B43,$B$25:$B$33,O$25:O$33,NA()),IF(ISBLANK(_xlpm.value),\"\",_xlpm.value))","v":""},"","",""]
[null,"Shelf height H9",{"$f":"IF(AND(C43<>\"\",C46<>\"\"),C47+C46+getClearance(C$40,C$25:C$33,$C$12)+shelfHeight,\"\")","v":""},{"$f":"IF(AND(D43<>\"\",D46<>\"\"),D47+D46+getClearance(D$40,D$25:D$33,$C$12)+shelfHeight,\"\")","v":""},{"$f":"IF(AND(E43<>\"\",E46<>\"\"),E47+E46+getClearance(E$40,E$25:E$33,$C$12)+shelfHeight,\"\")","v":""},{"$f":"IF(AND(F43<>\"\",F46<>\"\"),F47+F46+getClearance(F$40,F$25:F$33,$C$12)+shelfHeight,\"\")","v":""},{"$f":"IF(AND(G43<>\"\",G46<>\"\"),G47+G46+getClearance(G$40,G$25:G$33,$C$12)+shelfHeight,\"\")","v":""}]
[null,"Frontstopper 8",{"$f":"getFrontstop(C46)","v":""},{"$f":"getFrontstop(D46)","v":""},{"$f":"getFrontstop(E46)","v":""},{"$f":"getFrontstop(F46)","v":""},{"$f":"getFrontstop(G46)","v":""}]
[null,"Product height Shelf 8",{"$f":"_xlfn.LET(_xlpm.value,_xlfn.XLOOKUP($B46,$B$25:$B$33,N$25:N$33,NA()),IF(ISBLANK(_xlpm.value),\"\",_xlpm.value))","v":""},{"$f":"_xlfn.LET(_xlpm.value,_xlfn.XLOOKUP($B46,$B$25:$B$33,O$25:O$33,NA()),IF(ISBLANK(_xlpm.value),\"\",_xlpm.value))","v":""},"","",""]
[null,"Shelf height H8",{"$f":"IF(AND(C46<>\"\",C49<>\"\"),C50+C49+getClearance(C$40,C$25:C$33,$C$12)+shelfHeight,\"\")","v":""},{"$f":"IF(AND(D46<>\"\",D49<>\"\"),D50+D49+getClearance(D$40,D$25:D$33,$C$12)+shelfHeight,\"\")","v":""},{"$f":"IF(AND(E46<>\"\",E49<>\"\"),E50+E49+getClearance(E$40,E$25:E$33,$C$12)+shelfHeight,\"\")","v":""},{"$f":"IF(AND(F46<>\"\",F49<>\"\"),F50+F49+getClearance(F$40,F$25:F$33,$C$12)+shelfHeight,\"\")","v":""},{"$f":"IF(AND(G46<>\"\",G49<>\"\"),G50+G49+getClearance(G$40,G$25:G$33,$C$12)+shelfHeight,\"\")","v":""}]
[null,"Frontstopper 7",{"$f":"getFrontstop(C49)","v":""},{"$f":"getFrontstop(D49)","v":""},{"$f":"getFrontstop(E49)","v":""},{"$f":"getFrontstop(F49)","v":""},{"$f":"getFrontstop(G49)","v":""}]
[null,"Product height Shelf 7",{"$f":"_xlfn.LET(_xlpm.value,_xlfn.XLOOKUP($B49,$B$25:$B$33,N$25:N$33,NA()),IF(ISBLANK(_xlpm.value),\"\",_xlpm.value))","v":""},{"$f":"_xlfn.LET(_xlpm.value,_xlfn.XLOOKUP($B49,$B$25:$B$33,O$25:O$33,NA()),IF(ISBLANK(_xlpm.value),\"\",_xlpm.value))","v":""},"","",""]
[null,"Shelf height H7",{"$f":"IF(AND(C49<>\"\",C52<>\"\"),C53+C52+getClearance(C$40,C$25:C$33,$C$12)+shelfHeight,\"\")","v":""},{"$f":"IF(AND(D49<>\"\",D52<>\"\"),D53+D52+getClearance(D$40,D$25:D$33,$C$12)+shelfHeight,\"\")","v":""},{"$f":"IF(AND(E49<>\"\",E52<>\"\"),E53+E52+getClearance(E$40,E$25:E$33,$C$12)+shelfHeight,\"\")","v":""},{"$f":"IF(AND(F49<>\"\",F52<>\"\"),F53+F52+getClearance(F$40,F$25:F$33,$C$12)+shelfHeight,\"\")","v":""},{"$f":"IF(AND(G49<>\"\",G52<>\"\"),G53+G52+getClearance(G$40,G$25:G$33,$C$12)+shelfHeight,\"\")","v":""}]
[null,"Frontstopper 6",{"$f":"getFrontstop(C52)","v":""},{"$f":"getFrontstop(D52)","v":""},{"$f":"getFrontstop(E52)","v":""},{"$f":"getFrontstop(F52)","v":""},{"$f":"getFrontstop(G52)","v":""}]
[null,"Product height Shelf 6",{"$f":"_xlfn.LET(_xlpm.value,_xlfn.XLOOKUP($B52,$B$25:$B$33,N$25:N$33,NA()),IF(ISBLANK(_xlpm.value),\"\",_xlpm.value))","v":""},{"$f":"_xlfn.LET(_xlpm.value,_xlfn.XLOOKUP($B52,$B$25:$B$33,O$25:O$33,NA()),IF(ISBLANK(_xlpm.value),\"\",_xlpm.value))","v":""},"","",""]
[null,"Shelf height H6",{"$f":"IF(AND(C52<>\"\",C55<>\"\"),C56+C55+getClearance(C$40,C$25:C$33,$C$12)+shelfHeight,\"\")","v":""},{"$f":"IF(AND(D52<>\"\",D55<>\"\"),D56+D55+getClearance(D$40,D$25:D$33,$C$12)+shelfHeight,\"\")","v":""},{"$f":"IF(AND(E52<>\"\",E55<>\"\"),E56+E55+getClearance(E$40,E$25:E$33,$C$12)+shelfHeight,\"\")","v":""},{"$f":"IF(AND(F52<>\"\",F55<>\"\"),F56+F55+getClearance(F$40,F$25:F$33,$C$12)+shelfHeight,\"\")","v":""},{"$f":"IF(AND(G52<>\"\",G55<>\"\"),G56+G55+getClearance(G$40,G$25:G$33,$C$12)+shelfHeight,\"\")","v":""}]
[null,"Frontstopper 5",{"$f":"getFrontstop(C55)","v":""},{"$f":"getFrontstop(D55)","v":""},{"$f":"getFrontstop(E55)","v":""},{"$f":"getFrontstop(F55)","v":""},{"$f":"getFrontstop(G55)","v":""}]
[null,"Product height Shelf 5",{"$f":"_xlfn.LET(_xlpm.value,_xlfn.XLOOKUP($B55,$B$25:$B$33,N$25:N$33,NA()),IF(ISBLANK(_xlpm.value),\"\",_xlpm.value))","v":""},{"$f":"_xlfn.LET(_xlpm.value,_xlfn.XLOOKUP($B55,$B$25:$B$33,O$25:O$33,NA()),IF(ISBLANK(_xlpm.value),\"\",_xlpm.value))","v":""},"","",""]
[null,"Shelf height H5",{"$f":"IF(AND(C55<>\"\",C58<>\"\"),C59+C58+getClearance(C$40,C$25:C$33,$C$12)+shelfHeight,\"\")","v":""},{"$f":"IF(AND(D55<>\"\",D58<>\"\"),D59+D58+getClearance(D$40,D$25:D$33,$C$12)+shelfHeight,\"\")","v":""},{"$f":"IF(AND(E55<>\"\",E58<>\"\"),E59+E58+getClearance(E$40,E$25:E$33,$C$12)+shelfHeight,\"\")","v":""},{"$f":"IF(AND(F55<>\"\",F58<>\"\"),F59+F58+getClearance(F$40,F$25:F$33,$C$12)+shelfHeight,\"\")","v":""},{"$f":"IF(AND(G55<>\"\",G58<>\"\"),G59+G58+getClearance(G$40,G$25:G$33,$C$12)+shelfHeight,\"\")","v":""}]
[null,"Frontstopper 4",{"$f":"getFrontstop(C58)","v":""},{"$f":"getFrontstop(D58)","v":""},{"$f":"getFrontstop(E58)","v":""},{"$f":"getFrontstop(F58)","v":""},{"$f":"getFrontstop(G58)","v":""}]
[null,"Product height Shelf 4",{"$f":"_xlfn.LET(_xlpm.value,_xlfn.XLOOKUP($B58,$B$25:$B$33,N$25:N$33,NA()),IF(ISBLANK(_xlpm.value),\"\",_xlpm.value))","v":""},{"$f":"_xlfn.LET(_xlpm.value,_xlfn.XLOOKUP($B58,$B$25:$B$33,O$25:O$33,NA()),IF(ISBLANK(_xlpm.value),\"\",_xlpm.value))","v":""},"","",""]
[null,"Shelf height H4",{"$f":"IF(AND(C58<>\"\",C61<>\"\"),C62+C61+getClearance(C$40,C$25:C$33,$C$12)+shelfHeight,\"\")","v":""},{"$f":"IF(AND(D58<>\"\",D61<>\"\"),D62+D61+getClearance(D$40,D$25:D$33,$C$12)+shelfHeight,\"\")","v":""},{"$f":"IF(AND(E58<>\"\",E61<>\"\"),E62+E61+getClearance(E$40,E$25:E$33,$C$12)+shelfHeight,\"\")","v":""},{"$f":"IF(AND(F58<>\"\",F61<>\"\"),F62+F61+getClearance(F$40,F$25:F$33,$C$12)+shelfHeight,\"\")","v":""},{"$f":"IF(AND(G58<>\"\",G61<>\"\"),G62+G61+getClearance(G$40,G$25:G$33,$C$12)+shelfHeight,\"\")","v":""}]
[null,"Frontstopper 3",{"$f":"getFrontstop(C61)","v":"54 mm"},{"$f":"getFrontstop(D61)","v":"143 mm"},{"$f":"getFrontstop(E61)","v":""},{"$f":"getFrontstop(F61)","v":""},{"$f":"getFrontstop(G61)","v":""}]
[null,"Product height Shelf 3",{"$f":"_xlfn.LET(_xlpm.value,_xlfn.XLOOKUP($B61,$B$25:$B$33,N$25:N$33,NA()),IF(ISBLANK(_xlpm.value),\"\",_xlpm.value))","v":115},{"$f":"_xlfn.LET(_xlpm.value,_xlfn.XLOOKUP($B61,$B$25:$B$33,O$25:O$33,NA()),IF(ISBLANK(_xlpm.value),\"\",_xlpm.value))","v":325},"","",""]
[null,"Shelf height H3",{"$f":"IF(AND(C61<>\"\",C64<>\"\"),C65+C64+getClearance(C$40,C$25:C$33,$C$12)+shelfHeight,\"\")","v":639},{"$f":"IF(AND(D61<>\"\",D64<>\"\"),D65+D64+getClearance(D$40,D$25:D$33,$C$12)+shelfHeight,\"\")","v":571},{"$f":"IF(AND(E61<>\"\",E64<>\"\"),E65+E64+getClearance(E$40,E$25:E$33,$C$12)+shelfHeight,\"\")","v":""},{"$f":"IF(AND(F61<>\"\",F64<>\"\"),F65+F64+getClearance(F$40,F$25:F$33,$C$12)+shelfHeight,\"\")","v":""},{"$f":"IF(AND(G61<>\"\",G64<>\"\"),G65+G64+getClearance(G$40,G$25:G$33,$C$12)+shelfHeight,\"\")","v":""}]
[null,"Frontstopper 2",{"$f":"getFrontstop(C64)","v":"113 mm"},{"$f":"getFrontstop(D64)","v":"54 mm"},{"$f":"getFrontstop(E64)","v":""},{"$f":"getFrontstop(F64)","v":""},{"$f":"getFrontstop(G64)","v":""}]
[null,"Product height Shelf 2",{"$f":"_xlfn.LET(_xlpm.value,_xlfn.XLOOKUP($B64,$B$25:$B$33,N$25:N$33,NA()),IF(ISBLANK(_xlpm.value),\"\",_xlpm.value))","v":213},{"$f":"_xlfn.LET(_xlpm.value,_xlfn.XLOOKUP($B64,$B$25:$B$33,O$25:O$33,NA()),IF(ISBLANK(_xlpm.value),\"\",_xlpm.value))","v":115},"","",""]
[null,"Shelf height H2",{"$f":"IF(AND(C64<>\"\",C67<>\"\"),C68+C67+getClearance(C$40,C$25:C$33,$C$12)+shelfHeight,\"\")","v":374},{"$f":"IF(AND(D64<>\"\",D67<>\"\"),D68+D67+getClearance(D$40,D$25:D$33,$C$12)+shelfHeight,\"\")","v":404},{"$f":"IF(AND(E64<>\"\",E67<>\"\"),E68+E67+getClearance(E$40,E$25:E$33,$C$12)+shelfHeight,\"\")","v":""},{"$f":"IF(AND(F64<>\"\",F67<>\"\"),F68+F67+getClearance(F$40,F$25:F$33,$C$12)+shelfHeight,\"\")","v":""},{"$f":"IF(AND(G64<>\"\",G67<>\"\"),G68+G67+getClearance(G$40,G$25:G$33,$C$12)+shelfHeight,\"\")","v":""}]
[null,"Frontstopper 1",{"$f":"getFrontstop(C67)","v":"54 mm"},{"$f":"getFrontstop(D67)","v":"54 mm"},{"$f":"getFrontstop(E67)","v":""},{"$f":"getFrontstop(F67)","v":""},{"$f":"getFrontstop(G67)","v":""}]
[null,"Product height Shelf 1",{"$f":"_xlfn.LET(_xlpm.value,_xlfn.XLOOKUP($B67,$B$25:$B$33,N$25:N$33,NA()),IF(ISBLANK(_xlpm.value),\"\",_xlpm.value))","v":115},{"$f":"_xlfn.LET(_xlpm.value,_xlfn.XLOOKUP($B67,$B$25:$B$33,O$25:O$33,NA()),IF(ISBLANK(_xlpm.value),\"\",_xlpm.value))","v":145},"","",""]
[null,"Shelf height H1",{"$f":"IF(C37>0,_xlfn.XLOOKUP(getMultideck,tableMultidecks[Multidecks],tableMultidecks[H1],\"\"),\"\")","v":207},{"$f":"IF(D37>0,_xlfn.XLOOKUP(getMultideck,tableMultidecks[Multidecks],tableMultidecks[H1],\"\"),\"\")","v":207},{"$f":"IF(E37>0,_xlfn.XLOOKUP(getMultideck,tableMultidecks[Multidecks],tableMultidecks[H1],\"\"),\"\")","v":""},{"$f":"IF(F37>0,_xlfn.XLOOKUP(getMultideck,tableMultidecks[Multidecks],tableMultidecks[H1],\"\"),\"\")","v":""},{"$f":"IF(G37>0,_xlfn.XLOOKUP(getMultideck,tableMultidecks[Multidecks],tableMultidecks[H1],\"\"),\"\")","v":""}]
[]
[null,"Order information"]
[null,{"$f":"\"Number of TurnLoaders \n(\" & getNoIncludedShelves($C$9)*E71 & \" shelves included)\"","v":"Number of TurnLoaders \n(8 shelves included)"},{"$f":"INDEX(tableArticleNumbers[],_xlfn.XMATCH(\"TurnLoader\",tableArticleNumbers[Article]),_xlfn.XMATCH($C$9,tableArticleNumbers[#Headers]))","v":"469347"},null,{"$f":"C35","v":2}]
[null,"Number of extra shelves",{"$f":"INDEX(tableArticleNumbers[],_xlfn.XMATCH(\"Extra Shelf\",tableArticleNumbers[Article]),_xlfn.XMATCH($C$9,tableArticleNumbers[#Headers]))","v":"469028"},null,{"$f":"MAX(0,C38-E71*getNoIncludedShelves($C$9))","v":0}]
[null,"Frontstopper 54 mm",{"$f":"INDEX(tableArticleNumbers[],_xlfn.XMATCH(\"FS54\",tableArticleNumbers[Article]),_xlfn.XMATCH($C$9,tableArticleNumbers[#Headers]))","v":"468942"},null,{"$f":"COUNTIF(C41:G67,\"54 mm\")","v":4}]
[null,"Frontstopper 113 mm",{"$f":"INDEX(tableArticleNumbers[],_xlfn.XMATCH(\"FS113\",tableArticleNumbers[Article]),_xlfn.XMATCH($C$9,tableArticleNumbers[#Headers]))","v":"---"},null,{"$f":"COUNTIF(C42:G68,\"113 mm\") & IF(OR(C9=\"Multideck\",C9=\"Coldfront\"),\" (included)\",\"\")","v":"1 (included)"}]
[null,"Frontstopper 143 mm",{"$f":"INDEX(tableArticleNumbers[],_xlfn.XMATCH(\"FS143\",tableArticleNumbers[Article]),_xlfn.XMATCH($C$9,tableArticleNumbers[#Headers]))","v":"468958"},null,{"$f":"COUNTIF(C43:G69,\"143 mm\")","v":1}]

{"sheet":"Settings","index":1,"n_rows":20,"n_cols":11,"rows_kept":20,"hidden":true}
["Frontstop","From","To",null,"Clearance","Value","Description",null,null,"TurnLoader Type","Picture"]
["54 mm",0,150,null,null,"even","Even",null,null,"ColdFront","PictureColdfront"]
["113 mm",151,280,null,null,15,"15 mm",null,null,"Multideck","PictureMultideck"]
["143 mm",280,1000]
[]
[]
[]
[]
[]
["Article","ColdFront","Multideck",{"$nulls":5},"Selected:",{"$f":"_xlfn.XLOOKUP(Project!C9, tableTurnLoaderTypes[TurnLoader Type], tableTurnLoaderTypes[Picture], \"nope\", 0)","v":"PictureMultideck"}]
["TurnLoader","473390","469347",{"$nulls":6},{"$error":"#VALUE!"}]
["Extra shelf","473391","469028",{"$nulls":6},{"$error":"#VALUE!"}]
["FS54","Art.No Missing","468942"]
["FS113","---","---"]
["FS143","Art.No Missing","468958"]
[]
[]
[]
["Multidecks for dropdown, dont write stuff underneath"]
[{"$f":"_xlfn._xlws.FILTER(tableMultidecks[Multidecks],tableMultidecks[Multidecks]<>\"Coldfront\",\"\")","v":"Carrier MonaxEco 63"}]

{"sheet":"Multidecks","index":2,"n_rows":4,"n_cols":9,"rows_kept":4}
["Multidecks","Inner height","Shelf depth","Distans backwall to door","Usable Height","H1","TurnLoader"]
["Coldfront",{"$nulls":3},1740,192,"TurnLoader CF 1250/550"]
["Carrier MonaxEco 63",1785,500,610,1483,207,"TurnLoader MD 1250/550"]
[{"$nulls":8},"<-- Add more multidecks here"]

{"sheet":"Products","index":3,"n_rows":9,"n_cols":3,"rows_kept":9}
["Name","Product Height"]
["25 cl Slim Can",135]
["33 cl Classic Can",115]
["33 cl Sleek Can",145]
["33 cl Glass Bottle",240]
["50 cl Std Can",168]
["50 cl PET Bottle",213]
["150 cl PET Bottle",325]
[null,null,"<-- Add more products here"]