{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["background calcs","MAIN MENU","SPACE CALCULATOR","CONFIGURATOR"],"not_rendered":{"charts":3,"images":5,"macros":1,"external_links":0,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"background calcs","index":0,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
[null,"mm","inch",null,null,"grade range"]
["Width",3000,{"$f":"B2/25.4","v":118.11023622047244},null,"Board Angle","lower"]
["Height",3000,{"$f":"B3/25.4","v":118.11023622047244},1,"20 Degrees","f6c - f8b"]
["Centre Y",1500,{"$f":"B4/25.4","v":59.055118110236222},2,"27.5 Degrees","f7b - f9a"]
["Centre Z",1500,{"$f":"B5/25.4","v":59.055118110236222}]
["Ratio",25.4,1]
[]
[]
[null,null,null,0,1]
[null,null,null,{"$f":"'background calcs'!F13","v":3210},{"$f":"'SPACE CALCULATOR'!D9","v":3400}]
[]
["Sufficient Space ✓",2910,null,null,0,0]
["Not Enough Space ✘",2750,null,null,{"$f":"'SPACE CALCULATOR'!D14","v":1168.3444519945094},{"$f":"'SPACE CALCULATOR'!D10","v":3210}]
[null,null,null,null,0,{"$f":"vertical","v":3210}]
[null,null,null,null,"max"]
[null,null,2750,null,{"$f":"'background calcs'!B18","v":2910},{"$f":"'background calcs'!B18","v":2910}]
[null,null,3000,null,0,{"$f":"'SPACE CALCULATOR'!$D$11","v":3500}]
["Lower Limit",{"$f":"IF(angle=27.5,'background calcs'!B13,'background calcs'!B12)","v":2910}]
[]
[]
[null,null,null,null,0,0,{"$f":"'SPACE CALCULATOR'!$D$15","v":1700},{"$f":"'SPACE CALCULATOR'!$D$16","v":1708.0053248238389}]
[null,null,null,"overhang length",0,{"$f":"'SPACE CALCULATOR'!D19","v":3416.0106496476778}]
[null,null,null,null,{"$f":"'SPACE CALCULATOR'!D9","v":3400},{"$f":"F22","v":3416.0106496476778}]
[null,null,null,null,{"$f":"E23","v":3400},0]
[null,null,null,null,0,0]
[]
[1,{"$f":"IF('SPACE CALCULATOR'!D19>=3100,1,2)","v":1},null,1]
[2,{"$f":"IF('SPACE CALCULATOR'!D20>=50,1,2)","v":1}]
[null,{"$f":"IF('SPACE CALCULATOR'!D21>=50,1,2)","v":1}]
[null,{"$f":"SUM(B27:B29)","v":3}]

{"sheet":"MAIN MENU","index":1,"n_rows":34,"n_cols":53,"rows_kept":34,"cut":false,"hidden":false,"merged":[[53,2,53,7],[53,19,53,42],[17,16,18,45],[17,3,18,6],[3,3,7,7],[2,8,14,45]]}
[]
[]
[null,null,null,null,null,null,null,null,"Welcome to the Lattice Board Configurator, here you can check the sapce you need for the Lattice Board and select the angle most appropriate for you, it's easy just click the space & angle link below. \n\nFollowing this please click navigate to the Lattice Board Configurator page to fully customise your board colour and pattern. Once you are happy with your layout and colours, please save the document and then save a PDF by selecting; File > Save As > Save As Type > PDF.\n\nOnce you have name the file (example: Joe Bloggs_Lattice Board.pdf), please return to products@latticetraining.com and we shall process your order. If you need help with the configurator or need some inspiration, please don't hestiate to contact us."]
[null,null,null,"LATTICE BOARD CONFIGURATOR"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[null,null,null,"SPACE & ANGLE CALCULATOR",null,null,null,null,null,null,null,null,null,null,null,null,"CONFIGURATOR"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   "]

{"sheet":"SPACE CALCULATOR","index":2,"n_rows":29,"n_cols":15,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,11,30,21],[19,3,19,4],[20,3,20,4],[22,2,22,3],[23,2,25,4],[27,2,31,3],[27,5,31,8],[18,3,18,4],[1,2,2,4],[1,6,3,13],[1,14,3,22],[3,2,3,3],[5,3,5,4],[7,2,7,4],[12,2,12,3],[13,3,13,4],[14,3,14,4],[15,3,15,4],[17,2,17,3]]}
[]
[null,null,"INPUT DIMENSIONS",null,null,null,"Board Side View\n",null,null,null,null,null,null,null,"Board Front View \n(normal to board angle)"]
[]
[null,null,"Board Angle - Please Select"]
[null,null,"Overhang Angle (θ)",{"$f":"IF(E5=1,20,27.5)","v":20},1]
[null,null,"Red Point Grade",{"$f":"IF(angle=27.5,'background calcs'!F4,'background calcs'!F3)","v":"f6c - f8b"}]
[]
[null,null,"Available Space Dimensions - Please Select"]
[null,null,"Horizontal Width (z)",3400]
[null,null,"Vertical Height (y)",3210]
[null,null,"Horizontal Depth (x)",3500]
[]
[null,null,"Reference Dimensions"]
[null,null,"Projection Depth (d)",{"$f":"vertical*TAN(RADIANS(angle))","v":1168.3444519945094}]
[null,null,"Centre from Side",{"$f":"D9/2","v":1700}]
[null,null,"Centre from Top ",{"$f":"D19/2","v":1708.0053248238389}]
[]
[null,null,"Board Clearance"]
[null,null,"Overhang Length (h)",{"$f":"D10/COS(RADIANS(D5))","v":3416.0106496476778}]
[null,null,"Boarder Each Side",{"$f":"SUM('SPACE CALCULATOR'!D9-'background calcs'!B2)/2","v":200}]
[null,null,"Boarder Top & Bottom",{"$f":"SUM($D$19-'background calcs'!B3)/2","v":208.00532482383892}]
[]
[null,null,"Result"]
[null,null,{"$f":"IF('background calcs'!B30<=3,'background calcs'!A12,'background calcs'!A13)","v":"Sufficient Space ✓"}]
[]
[]
[]
[null,null,"Return to Main Menu",null,null,"Switch to Configurator"]
[null,null,null,null,null,null,null,null,null,null,null,"Step 1. Select you board angle\nStep 2. Enter your space dimensions"]

{"sheet":"CONFIGURATOR","index":3,"n_rows":51,"n_cols":48,"rows_kept":51,"cut":false,"hidden":false,"merged":[[48,2,52,3],[48,5,52,6],[2,40,7,41],[2,22,7,23],[2,24,7,25],[2,26,7,27],[2,28,7,29],[2,30,7,31],[2,32,7,33],[2,34,7,35],[2,36,7,37],[8,22,9,23],[8,24,9,25],[8,38,9,39],[8,40,9,41],[8,28,9,29],[8,30,9,31],[8,32,9,33],[8,34,9,35],[2,38,7,39],[8,36,9,37],[2,20,7,21],[2,12,7,13],[2,14,7,15],[2,16,7,17],[2,18,7,19],[9,2,18,6],[42,11,45,13],[42,20,45,22],[21,9,23,10],[12,17,13,19],[14,18,14,19],[12,14,13,15],[14,15,16,17],[17,9,19,10],[12,23,14,24],[12,25,13,25],[8,26,9,27],[14,25,16,27],[8,10,9,11],[8,12,9,13],[8,14,9,15],[8,16,9,17],[8,18,9,19],[8,20,9,21],[14,35,16,37],[12,33,14,34],[12,35,13,35],[12,37,13,39],[14,38,14,39],[17,43,19,44],[21,43,23,44],[24,15,28,17],[18,11,22,13],[47,15,49,18],[47,25,49,28],[18,40,22,42],[30,40,34,42],[29,43,31,44],[33,43,35,44],[19,19,22,23],[19,29,22,33],[30,19,34,23],[30,29,34,33],[24,25,28,27],[24,35,28,37],[39,43,43,44],[44,43,48,44],[50,22,51,25],[50,28,51,31],[50,38,51,41],[50,32,51,35],[42,40,45,42],[36,25,40,28],[36,35,40,38],[47,35,49,38],[2,3,7,6],[42,30,45,32],[50,16,51,17],[44,9,48,10],[50,12,51,15],[50,18,51,21],[39,9,43,10],[36,15,40,18],[12,28,14,28],[12,27,13,27],[12,29,14,29],[30,11,34,13],[29,9,32,10],[33,9,36,10],[19,2,20,3],[19,5,20,6]]}
[]
[]
[null,null,null,"LATTICE BOARD CONFIGURATOR",null,null,null,null,null,null,null,null,"BLACK",null,"GREY",null,"WHITE",null,"BLUE",null,"LIGHT BLUE",null,"GREEN",null,"BRIGHT GREEN",null,"RED",null,"BROWN",null,"BRIGHT ORANGE",null,"ORANGE",null,"YELLOW",null,"BRIGHT YELLOW",null,"BRIGHT PINK",null,"BRIGHT PURPLE"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,1,null,2,null,3,null,4,null,5,null,6,null,7,null,8,null,9,null,10,null,11,null,12,null,13,null,14,null,15]
[null,null,"Using the configurator is simple, type in the colour reference you want for each component and its position, to see your board take shape. \n\nOnce you are happy with your layout and colours, please save the document and then save a PDF by selecting; File > Save As > Save As Type > PDF. Then name it and return to products@latticetraining.com and we shall process your order."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G23","v":13},null,null,{"$f":"G35","v":13},null,null,null,null,null,{"$f":"G24","v":8},null,{"$f":"X13","v":8},null,{"$f":"G36","v":8},{"$f":"AB13","v":8},{"$f":"AC13","v":8},null,null,null,{"$f":"G25","v":13},null,{"$f":"AH13","v":13},null,{"$f":"G37","v":13}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O13","v":13},{"$f":"$D23","v":13},null,null,{"$f":"R13","v":13},null,null,null,null,null,null,{"$f":"D24","v":8},null,null,null,null,null,null,null,null,null,{"$f":"D25","v":13},null,null,{"$f":"AL13","v":13},null,null,null,null,null,null,null,null," "]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"G34","v":13},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G38","v":13}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"D26","v":13},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D29","v":13}]
[null,null,"DIAMOND CONNECTORS",null,null,"END CAPS",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D27","v":13},null,null,null,null,null,null,null,null,null,{"$f":"D28","v":13}]
[]
[null,null,"CODE","COLOUR",null,"CODE","COLOUR",null,null,{"$f":"G33","v":13},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G39","v":13}]
[null,null,"D1",13,null,"LC1",13]
[null,null,"D2",8,null,"LC2",8]
[null,null,"D3",13,null,"LC3",13,null,null,null,null,null,null,null,null,{"$f":"D30","v":13},null,null,null,null,null,null,null,null,null,{"$f":"D31","v":13},null,null,null,null,null,null,null,null,null,{"$f":"D32","v":13}]
[null,null,"D4",13,null,"LC4",5]
[null,null,"D5",13,null,"LC5",5]
[null,null,"D6",13,null,"LC6",5]
[null,null,"D7",13,null,"LC7",5]
[null,null,"D8",13,null,"LC8",5,null,null,{"$f":"G32","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G40","v":5}]
[null,null,"D9",13,null,"LC9",5,null,null,null,null,{"$f":"D33","v":5},null,null,null,null,null,null,null,{"$f":"D34","v":13},null,null,null,null,null,null,null,null,null,{"$f":"D35","v":13},null,null,null,null,null,null,null,null,null,null,{"$f":"D36","v":5}]
[null,null,"D10",13,null,"LC10",5]
[null,null,"D11",5,null,"LC11",13]
[null,null,"D12",13,null,"LC12",13,null,null,{"$f":"G31","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G41","v":5}]
[null,null,"D13",13,null,"RC1",13]
[null,null,"D14",5,null,"RC2",8]
[null,null,"D15",5,null,"RC3",13,null,null,null,null,null,null,null,null,{"$f":"D37","v":5},null,null,null,null,null,null,null,null,null,{"$f":"D38","v":13},null,null,null,null,null,null,null,null,null,{"$f":"D39","v":5}]
[null,null,"D16",13,null,"RC4",13]
[null,null,"D17",5,null,"RC5",13]
[null,null,"D18",5,null,"RC6",5,null,null,{"$f":"G30","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G42","v":5}]
[null,null,"D19",5,null,"RC7",5]
[null,null,"D20",5,null,"RC8",5]
[null,null,"D21",5,null,"RC9",5,null,null,null,null,{"$f":"D40","v":5},null,null,null,null,null,null,null,null,{"$f":"D41","v":5},null,null,null,null,null,null,null,null,null,{"$f":"D42","v":5},null,null,null,null,null,null,null,null,null,{"$f":"D43","v":5}]
[null,null,"D22",5,null,"RC10",5]
[null,null,"D23",5,null,"RC11",5,null,null,{"$f":"G29","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G43","v":5}]
[null,null,"D24",5,null,"RC12",5]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D44","v":5},null,null,null,null,null,null,null,null,null,{"$f":"D45","v":5},null,null,null,null,null,null,null,null,null,{"$f":"D46","v":5}]
[null,null,"Return to Main Menu",null,null,"Switch to Calculator"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G28","v":5},null,null,null,{"$f":"P48","v":5},null,{"$f":"G46","v":5},null,null,null,{"$f":"G27","v":5},null,null,null,null,null,{"$f":"G45","v":5},null,null,null,{"$f":"G26","v":5},null,null,null,null,null,{"$f":"G44","v":5}]