{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Cover sheet","Frame","Door","Lookups","LH Door Glass Order Sheet","RH Door Glass Order Sheet","LH Cutting List","RH Cutting List","Frame Cutting List","Drawing Numbers","Images","Change record"],"not_rendered":{"charts":0,"images":20,"macros":1,"external_links":1,"defined_names":69,"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":"Cover sheet","index":0,"n_rows":106,"n_cols":16,"rows_kept":106,"cut":false,"hidden":false,"merged":[[43,18,44,20],[65,1,66,4],[65,5,66,5],[65,6,66,6],[65,7,66,7],[43,6,43,8],[43,0,44,1],[43,2,44,2],[43,3,44,3],[64,1,64,7],[43,12,44,14],[43,15,44,17],[44,6,44,8],[43,9,44,11],[37,1,37,5],[20,2,20,5],[20,6,20,7],[2,1,5,4],[2,5,3,16],[4,5,5,16],[16,2,16,7],[16,15,16,16],[18,13,18,14],[16,13,16,14],[18,15,18,16],[17,2,17,3],[17,5,17,6]]}
[]
[]
[null,100091,null,null,null,"Order template for Elite-Symmetry and Affinity 100mm doors "]
[]
[null,null,null,null,null,"and Microflush D660 frame"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(lock_digit=1,\"\",IF( lock_digit=4,\"Height of deadlock thumb-turn from top of floor covering\",\"Height of handle from top of floor covering\"))","v":""}]
[null,null,"Left hand",null,{"$f":"frame_height_L-DimE_frame_L-strike_height-floor_covering","v":{"$error":"#N/A"}},"Right hand",null,{"$f":"frame_height_R-DimE_frame_R-strike_height-floor_covering","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"colour_code","v":2}]
[]
[null,null,"floor covering thickness",null,null,null,8]
[]
[]
[]
[]
[null,"This sheet configures a D660 frame and matching Elite door(s).  MACROS MUST BE ENABLED"]
[null,"Select whether you want a door only, frame and door or just a frame using the blue tick boxes on THIS sheet"]
[null,"Select type of door (ELITE Symmetry or Affinity)"]
[null,"Select required lock option. "]
[null,"Select colour / finish requirements.  If a special colour is selected, enter it in the space required."]
[]
[null,"Select if a standard or bespoke strike height is required (for locking doors). "]
[null," If a bespoke is required, enter handle or lock height (as appropriate) from top of floor covering"]
[null,"Note:  A bespoke strike height or non-standard width will incur a one-off pattern-charge."]
[]
[]
[]
[null,"For comments or help, contact ",null,null,null,null,"peter.moss@optima-group.co.uk"]
[]
[]
[]
[]
[]
[{"$f":"'Change record'!$B$1","v":"Version 9.1"},null,null,null,"Client Name",null,null,null,null,"ST No.",null,null,null,null,null,"Works Order No."]
[null,null,null,null,"Project Name"]
[]
[]
[]
[null,"Door / lock choice",null,1]
[null,"Affinity or Symmetry",null,{"$f":"IF(door_lock>1, \"Affinity\",\"Symmetry\")","v":"Symmetry"}]
[null,"Lock",null,{"$f":"IF(door_lock=1,door_lock,door_lock-1)","v":1},{"$f":"HLOOKUP(D51,Lookups!B4:E6,3,FALSE)","v":"No lock"}]
[]
[]
[]
[]
[]
[null,"frame_or_door",null,2]
[]
[]
[]
[]
[]
[]
[]
[null,"FRAME COLOUR",null,null,null,null,null,null,"colour offset"]
[null,"DESCRIPTION",null,null,null,"RAL COLOUR","BORDER mm","COLOUR CODE",1]
[]
[null,"Standard Grey / Silver",null,null,null,9006,"Std",2,{"$f":"B68","v":"Standard Grey / Silver"}]
[null,"Standard White",null,null,null,9010,"Std",1,{"$f":"B69","v":"Standard White"}]
[null,"Anodised",null,null,null,null,null,8,"Anodised"]
[null,"Black",null,null,null,null,null,"AK","Black"]
[null,"Special",null,null,null,null,null," ","Special"]
[null,"Selected colour",null,null,null,null,null,{"$f":"INDEX(H68:H72,colour_offset)","v":2},{"$f":"INDEX(I68:I72,colour_offset,1)","v":"Standard Grey / Silver"}]
[]
[null,"Door",null,1]
[null,"Frame and door",null,2]
[null,"Door",null,3]
[null,null,null,1]
[]
[null,"Image numbers (used by macros to fetch correct images)"]
[null,"Door / lock combination",null,1,2,3,4,5]
[null,"Sections",null,{"$f":"D81","v":1},2,{"$f":"F81","v":3},4,5]
[null,"glass",null,{"$f":"D81","v":1},{"$f":"E81","v":2},{"$f":"E83","v":2},{"$f":"F83","v":2},2]
[null,"frame",null,{"$f":"D81","v":1},{"$f":"D84","v":1},{"$f":"E81","v":2},{"$f":"F84","v":2},{"$f":"G84","v":2}]
[]
[null,null,null,1,2,3,4,5,"Required"]
[null,"Section image",null,{"$f":"\"section\"&D82","v":"section1"},{"$f":"\"section\"&E82","v":"section2"},"section3","section4","section5",{"$f":"INDEX(D87:H87,1,MATCH(door_lock,$D$86:$H$86,FALSE))","v":"section1"}]
[null,"Left glass image",null,{"$f":"\"glass\"&D83&1","v":"glass11"},{"$f":"\"glass\"&E83&1","v":"glass21"},"glass21","glass21","glass21",{"$f":"INDEX(D88:H88,1,MATCH(door_lock,$D$86:$H$86,FALSE))","v":"glass11"}]
[null,"Right glass image",null,{"$f":"\"glass\"&D84&2","v":"glass12"},{"$f":"\"glass\"&E83&2","v":"glass22"},{"$f":"\"glass\"&F83&2","v":"glass22"},{"$f":"\"glass\"&G83&2","v":"glass22"},{"$f":"\"glass\"&H83&2","v":"glass22"},{"$f":"INDEX(D89:H89,1,MATCH(door_lock,$D$86:$H$86,FALSE))","v":"glass12"}]
[null,"Frame image",null,{"$f":"\"frame\"&D84","v":"frame1"},{"$f":"\"frame\"&E84","v":"frame1"},"frame2","frame2","frame2",{"$f":"INDEX(D90:H90,1,MATCH(door_lock,$D$86:$H$86,FALSE))","v":"frame1"}]
[]
[null,"Bespoke",1]
[]
[null,null,null,null,null,"LH","RH"]
[null,"Bespoke strike",null,1,null,{"$f":"Bespoke","v":1},{"$f":"Bespoke","v":1}]
[null,"Bespoke width",null,null,null,{"$f":"IF(frame_width_L=frame_std_width,1,2)","v":1},{"$f":"IF(frame_width_R=frame_std_width,1,2)","v":1}]
[]
[]
[null,"Bespoke frame",null,null,null,{"$f":"MAX(F95:F96)","v":1},{"$f":"MAX(G95:G96)","v":1},null,"Bespoke if either width or strike are non-standard"]
[]
[null,"Bespoke template charge",null,null,null,75]
[]
[null,"Door height minimum",null,null,2000]
[null,"Door height maximum",null,null,3000]
[]
[null,"levers",null,null,1]

{"sheet":"Frame","index":1,"n_rows":48,"n_cols":25,"rows_kept":48,"cut":false,"hidden":false,"merged":[[9,24,10,24],[46,7,46,12],[47,7,47,12],[9,17,10,22],[9,13,10,13],[9,23,10,23],[46,19,47,22],[46,13,47,15],[19,13,22,14],[19,15,22,16],[24,13,24,14],[24,15,24,16],[28,13,28,15],[29,13,29,15],[46,23,47,25],[46,16,47,18],[3,1,6,4],[9,9,10,12],[29,10,29,12],[28,10,28,12],[24,9,24,10],[24,11,24,12],[14,9,14,15],[18,9,18,10],[18,11,18,12],[18,13,18,14],[18,15,18,16],[15,9,15,12],[15,13,15,15],[27,9,27,15],[3,5,4,21],[5,5,6,21],[46,1,47,2],[46,3,47,3],[46,4,47,4],[18,17,18,19],[19,17,22,19],[24,17,24,19]]}
[]
[]
[]
[null,{"$f":"'Cover sheet'!B3","v":100091},null,null,null,"Order Template D660 Door Frame"]
[]
[null,null,null,null,null,{"$f":"\"Elite \" &door_type& \" with offset Pivots, \"& Lock_type","v":"Elite Symmetry with offset Pivots, No lock"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Template number",null,null,null,"HAND","W","A","E","PART NUMBER",null,null,null,null,null,"QTY","Pattern charge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Width","Height","Lock"]
[null,null,null,null,null,null,null,null,null,{"$f":"R12&S12&T12","v":"1018"},{"$f":"'Cover sheet'!P19","v":2},{"$f":"CEILING(P12,100)","v":0},27,"LH",1094,0,{"$f":"DimE_std_L","v":{"$error":"#N/A"}},1,{"$f":"IF(door_lock>2,'Cover sheet'!$F$99-1,0)","v":0},{"$f":"INDEX(Lookups!$B$96:$F$97,2,door_lock)","v":18},{"$f":"colour_code","v":2},{"$f":"VLOOKUP(frame_height_L,frame_height_bands,3)","v":{"$error":"#N/A"}},{"$f":"27","v":27},0,{"$f":"IF(qty_frame_L>0,IF('Cover sheet'!$F$99>1,'Cover sheet'!$F$101,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"R13&S13&T13","v":"2018"},{"$f":"K12","v":2},{"$f":"CEILING(P13,100)","v":0},27,"RH",1094,0,{"$f":"DimE_std_R","v":{"$error":"#N/A"}},"2",{"$f":"IF(door_lock>2,'Cover sheet'!$G$99-1,0)","v":0},{"$f":"INDEX(Lookups!$B$96:$F$97,2,door_lock)","v":18},{"$f":"colour_code","v":2},{"$f":"VLOOKUP(frame_height_R,frame_height_bands,3)","v":{"$error":"#N/A"}},27,0,{"$f":"IF(qty_frame_R>0,IF('Cover sheet'!$G$99>1,'Cover sheet'!$F$101,0),0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"FRAME COLOUR"]
[null,null,null,null,null,null,null,null,null,{"$f":"'Cover sheet'!$I$73","v":"Standard Grey / Silver"},null,null,null,{"$f":"K12","v":2}]
[]
[]
[null,null,null,null,null,null,null,null,null,"Jamb",null,"Head",null,"Pivot type",null,"Strike type",null,"Floor-spring Spindle"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"P6",null,{"$f":"HLOOKUP('Cover sheet'!D51,Lookups!B4:E7,4,FALSE)","v":"None"},null,{"$f":"VLOOKUP(floor_covering,spindle_table,2,FALSE)","v":"A"},null,null,null,null,"ü"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,440,null,437,null,"Quad strap",null,{"$f":"'Cover sheet'!E51","v":"No lock"},null,"Order separately"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Standard frame widths and heights (mm)"]
[null,null,null,null,null,null,null,null,null,"Frame","Width",null,null,"Height"]
[null,null,null,null,null,null,null,null,null,"D660",1094,null,null,3000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'Change record'!$B$1","v":"Version 9.1"},null,null,null,"Client Name",null,{"$f":"'Cover sheet'!G44","v":0},null,null,null,null,null,"ST No.",null,null,{"$f":"'Cover sheet'!M44","v":0},null,null,"Works Order No.",null,null,null,{"$f":"'Cover sheet'!S44","v":0}]
[null,null,null,null,null,"Project Name",null,{"$f":"'Cover sheet'!G45","v":0}]

{"sheet":"Door","index":2,"n_rows":48,"n_cols":23,"rows_kept":48,"cut":false,"hidden":false,"merged":[[19,19,19,21],[14,20,14,21],[15,20,15,21],[27,11,27,12],[28,11,28,12],[24,9,24,12],[15,11,15,12],[18,9,19,12],[18,13,19,13],[25,9,26,9],[25,11,25,12],[26,11,26,12],[18,15,18,21],[19,15,19,18],[3,1,6,4],[12,9,13,12],[3,5,4,17],[5,5,6,17],[14,11,14,12],[12,13,13,13],[31,9,34,10],[46,19,47,22],[46,13,47,15],[46,1,47,2],[46,3,47,3],[46,4,47,4],[46,16,47,18],[46,10,47,12],[46,7,46,9],[47,7,47,9]]}
[]
[]
[]
[null,{"$f":"'Cover sheet'!B3","v":100091},null,null,null,{"$f":"\"Order Template for Elite \"& door_type& \" Double Glazed Door\"","v":"Order Template for Elite Symmetry Double Glazed Door"}]
[]
[null,null,null,null,null,{"$f":"\"Offset Pivots, \"& Lock_type","v":"Offset Pivots, No lock"}]
[]
[]
[null,null,null,null,null,null,null,null,null,"● To complete the template, input data into the BLUE highlighted sections of the tables below."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"PART NUMBER",null,null,null,"HAND","W","A","F","G","E","QTY","LOW IRON GLASS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Width","Height","Handle Ht","Handle","Lock",null,"Yes or No"]
[null,null,null,null,null,null,null,null,null,{"$f":"MATCH(N15,Lookups!$A$16:$A$17,0)&LEFT(Lookups!$B$19,3)","v":"1153"},{"$f":"'Cover sheet'!P19","v":2},{"$f":"RIGHT(Lookups!$B$19,6)","v":"300061"},null,"LH",{"$f":"frame_width_L -frame_door_difference_width","v":1026},{"$f":"frame_height_L - frame_top-top_gap-bottom_gap-floor_covering","v":-24},null,null,{"$f":"DimE_frame_L-frame_top-top_gap","v":{"$error":"#N/A"}},{"$f":"qty_frame_L","v":0},"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"MATCH(N16,Lookups!$A$16:$A$17,0)&LEFT(Lookups!$B$19,3)","v":"2153"},{"$f":"K15","v":2},{"$f":"RIGHT(Lookups!$B$19,6)","v":"300061"},null,"RH",{"$f":"frame_width_R -frame_door_difference_width","v":1026},{"$f":"frame_height_R - frame_top-top_gap-bottom_gap-floor_covering","v":-24},null,null,{"$f":"DimE_frame_R-frame_top-top_gap","v":{"$error":"#N/A"}},{"$f":"qty_frame_R","v":0},"No"]
[]
[null,null,null,null,null,null,null,null,null,"Internal Use Only"]
[null,null,null,null,null,null,null,null,null,"DOOR NUMBERS",null,null,null,"HAND",null,"FRAME COLOUR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Cover sheet'!$I$73","v":"Standard Grey / Silver"},null,null,null,{"$f":"'Cover sheet'!P19","v":2},null,null,"ü"]
[null,null,null,null,null,null,null,null,null,6000,null,{"$f":"K15","v":2},61,"LH"]
[null,null,null,null,null,null,null,null,null,6000,null,{"$f":"L21","v":2},61,"RH"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Corridor view"]
[null,null,null,null,null,null,null,null,null,"HAND","Opening"]
[null,null,null,null,null,null,null,null,null,null,"Width (mm)"]
[null,null,null,null,null,null,null,null,null,"LH",{"$f":"door_width_L-Lookups!$B$61","v":966},null,null,null,null,null,null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,"RH",{"$f":"door_width_R-Lookups!$B$61","v":966},null,null,null,null,null,null,null,null,"No"]
[]
[null,null,null,null,null,null,null,null,null,"Handle options"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(door_lock=4,door_lock=3),IF(levers=1,\"Optima door handles required\",\"Customer will supply handles.  Optima handles not required.\"),\"\")","v":""}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"NOTES"]
[null,null,null,null,null,null,null,null,null,"Dim W is the door width on the office (inside) side.  The width on the corridor side will be smaller."]
[null,null,null,null,null,null,null,null,null,"Dim A is the door height on the office (inside) side.  The height on the corridor side will be smaller"]
[null,null,null,null,null,null,null,null,null,"1. Standard door includes: Framework, Glass, Door mounted offset pivot straps."]
[null,null,null,null,null,null,null,null,null,"2. Frame colour finish: Powdercoat standard RAL reference"]
[null,null,null,null,null,null,null,null,null,"3. Prices Exclude : Delivery, VAT."]
[null,null,null,null,null,null,null,null,null,"4. Low Iron Glass: Is not included. If required it is subject to a price surcharge"]
[null,null,null,null,null,null,null,null,null,"5. Manifestation: Is not included. If required it is subject to a price surcharge"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ü"]
[null,{"$f":"'Change record'!$B$1","v":"Version 9.1"},null,null,null,"Client Name",null,{"$f":"'Cover sheet'!G44","v":0},null,null,"ST No.",null,null,{"$f":"'Cover sheet'!M44","v":0},null,null,"Works Order No.",null,null,{"$f":"'Cover sheet'!S44","v":0}]
[null,null,null,null,null,"Project Name",null,{"$f":"'Cover sheet'!G45","v":0}]

{"sheet":"Lookups","index":3,"n_rows":122,"n_cols":8,"rows_kept":122,"cut":false,"hidden":false,"merged":[[94,2,94,5]]}
[]
[null,"Leading stiles"]
[null,"No lock","Sash lock","Latch","Dead lock"]
["Henry's",1,2,3,4]
["Karen's",1,3,4,2]
[null,{"$f":"B3","v":"No lock"},{"$f":"C3","v":"Sash lock"},{"$f":"D3","v":"Latch"},{"$f":"E3","v":"Dead lock"}]
["Strike","None","K30","K29","K28"]
[]
["Karen's codes for doors"]
[]
[null,null,null,null,null,"Digit","Value","Comment"]
["Digits 3&4","Symmetry","Affinity",null,null,1,null,"LH or RH"]
[null,null,null,null,null,2,{"$f":"INDEX(B4:E5,2,lock_digit)","v":1},"Lock"]
["Double Glazed",53,55,null,null,"3 & 4",{"$f":"HLOOKUP('Cover sheet'!D50,Lookups!B12:C14,3,FALSE)","v":53}]
[null,null,null,null,null,"5 & 6",{"$f":"colour_offset","v":1},"Colour"]
["LH",1,null,null,null,7,3]
["RH",2,null,null,null,8,0]
[null,null,null,null,null,9,0]
["Part number",{"$f":"CONCATENATE(G13,G14,G15,G16,G17,G18,G19,G20,G21)","v":"1531300061"},null,"excludes LH/ RH digit",null,10,0]
[null,null,null,null,null,11,6]
[null,null,null,null,null,12,1]
[]
[]
["Colours"]
["Colours","offset","Index","Code","Inking colour"]
["Std Grey / silver",1,"02","RAL 9006","Optima Silver"]
["Std White",2,"01","RAL 9010",{"$f":"D27","v":"RAL 9010"}]
["Anodised",3,null,"\"\""]
["Black",4,"AK","RAL 9005","RAL 9005"]
["Special",5]
[]
["Cutting lengths"]
[]
["cutting_lengths","Symmetry","Affinity"]
["Stiles",0,0]
["Top rail",0,0]
["Bottom rail",-96,-145]
["Stile gaskets",-63,-63]
["Head gasket",-93,-116]
["Base gasket",{"$f":"B37","v":-96},{"$f":"C37","v":-145}]
[]
["Glass"]
["glass_dimensions","Symmetry","Affinity"]
["Dim A",-67,-67]
["Dim W",-70,-119]
["Dim F",-32,"n/a"]
["DimG",null,"n/a"]
["6mm","6mm Toughened","6mm Toughened"]
["8mm","8mm Toughened","8.8mm Acoustic Laminated"]
[]
[]
["Frame logic"]
[]
[]
["Frame thickness (each side)",29]
["Side Gaps (each)",5]
["Head thickness",4,"frame_top"]
["Top gap",5,"top_gap"]
["Bottom gap",7,"bottom_gap"]
["Difference between inside and outside (widths)",{"$f":"2*(B55+B56)","v":68},"frame_door_difference_width"]
["Difference between inside of door and outside of door",60]
[]
["Lock type",{"$f":"B3","v":"No lock"},{"$f":"C3","v":"Sash lock"},"Latch","Dead lock"]
["Offset",{"$f":"B4","v":1},{"$f":"C4","v":2},3,4]
["Strike height",0,39,39,27]
["Frame codes",18,19,25,38]
[]
["Gap between handle and latch"]
["strike_height",{"$f":"INDEX(B64:E65,2,B71)","v":0}]
[]
[null,{"$f":"lock_digit","v":1}]
[null,{"$f":"Lock_type","v":"No lock"}]
[]
[]
[]
["Default Dim E height"]
["HEIGHT RANGE","A","E","Upper limit"]
["2000-2100",2000,1031,{"$f":"+B78+99","v":2099}]
["2101-2200",2101,1131,{"$f":"+B79+99","v":2200}]
["2201-2300",2201,1231,2300]
["2301-2400",2301,1331,2400]
["2401-2500",2401,1431,2500]
["2501-2600",2501,1531,2600,"frame_height_bands"]
["2601-2700",2601,1631,2700]
["2701-2800",2701,1731,2800]
["2801-2900",2801,1831,2900]
["2901-3000",2901,1931,3000]
[]
["DimE_std_L",null,{"$f":"VLOOKUP(frame_height_L,frame_height_bands,2)","v":{"$error":"#N/A"}},null,"this is the selected standard dimE"]
["DimE_std_R",null,{"$f":"VLOOKUP(frame_height_R,frame_height_bands,2)","v":{"$error":"#N/A"}}]
[]
["frame_std_width",null,1094]
["door_std_width",null,{"$f":"frame_std_width-frame_door_difference_width","v":1026}]
[]
["Frame codes","Symmetry","Affinity"]
[null,"No lock","No lock","Sash lock","Latch","Dead lock"]
[null,18,18,19,25,38]
[]
[]
["Optima spindles"]
["Floor covering","Spindle type"]
[0,"A","spindle_table"]
[1,"A"]
[2,"A"]
[3,"A"]
[4,"A"]
[5,"A"]
[6,"A"]
[7,"A"]
[8,"A"]
[9,"B"]
[10,"B"]
[11,"B"]
[12,"B"]
[13,"C"]
[14,"C"]
[15,"C"]
[16,"C"]
[17,"D"]
[18,"D"]
[19,"D"]
[20,"D"]

{"sheet":"LH Door Glass Order Sheet","index":4,"n_rows":48,"n_cols":20,"rows_kept":48,"cut":false,"hidden":false,"merged":[[3,1,6,4],[13,13,14,15],[13,16,14,16],[13,17,14,17],[15,10,15,12],[13,10,14,12],[5,5,6,17],[3,5,4,17],[9,13,11,18],[46,18,47,20],[47,7,47,9],[29,11,35,16],[46,1,47,2],[46,3,47,3],[46,4,47,4],[46,7,46,9],[46,10,47,11],[46,12,47,14],[46,15,47,17],[22,17,23,18],[13,18,14,18],[13,19,14,19],[20,17,21,18],[16,10,16,12]]}
[]
[]
[]
[null,{"$f":"'Cover sheet'!B3","v":100091},null,null,null,{"$f":"\"Glass prep order sheet for Elite \"& door_type& \" Double Glazed Door\"","v":"Glass prep order sheet for Elite Symmetry Double Glazed Door"}]
[]
[null,null,null,null,null,{"$f":"\"Offset Pivots, \"& Lock_type","v":"Offset Pivots, No lock"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Left Hand door"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Type of glass",null,null,"PART NUMBER",null,null,"DIM `A`","DIM `W`",{"$f":"IF(door_type=\"Affinity\",\"\",\"DIM `F`\")","v":"DIM `F`"},{"$f":"IF(door_type=\"Affinity\",\"\",\"DIM `G`\")","v":"DIM `G`"}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(glass_dimensions,7,MATCH(door_type,Lookups!$B$43:$C$43,0))","v":"8mm Toughened"},null,null,4000,{"$f":"Door!K21","v":0},61,{"$f":"door_height_L+INDEX(glass_dimensions,2,MATCH(door_type,Lookups!$B$43:$C$43,0))","v":-91},{"$f":"door_width_L+INDEX(glass_dimensions,3,MATCH(door_type,Lookups!$B$43:$C$43,0))","v":956},{"$f":"IF(door_type=\"Affinity\",\"\",Handle_Ht_L+INDEX(glass_dimensions,4,MATCH(door_type,Lookups!$B$43:$C$43,0)))","v":-32},{"$f":"IF(door_type=\"Affinity\",\"\",Handle_pitch_L)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(glass_dimensions,6,MATCH(door_type,Lookups!$B$43:$C$43,0))","v":"6mm Toughened"},null,null,5000,{"$f":"Door!K21","v":0},61,{"$f":"Q16","v":-91},{"$f":"R16","v":956},{"$f":"S16","v":-32},{"$f":"T16","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOW IRON"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Door!U15","v":"No"}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"ACOUSTIC LAMINATED OR TOUGHENED GLASS (AS APPROPRIATE) TO THE SIZES IN THE TABLE ABOVE.   ALL EDGES TO BE POLISHED & ARRISED.  TOUGHENED GLASS TO BE HEAT SOAKED"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'Change record'!$B$1","v":"Version 9.1"},null,"REV","A","Client Name",null,{"$f":"Door!H47:J47","v":0},null,null,"ST No.",null,{"$f":"Door!N47","v":0},null,null,"Works Order No.",null,null,{"$f":"Door!T47","v":0}]
[null,null,null,null,null,"Project Name",null,{"$f":"Door!H48:J48","v":0}]

{"sheet":"RH Door Glass Order Sheet","index":5,"n_rows":48,"n_cols":20,"rows_kept":48,"cut":false,"hidden":false,"merged":[[3,1,6,4],[13,13,14,15],[13,16,14,16],[13,17,14,17],[15,10,15,12],[13,10,14,12],[5,5,6,17],[3,5,4,17],[9,13,11,18],[46,18,47,20],[47,7,47,9],[29,11,35,16],[46,1,47,2],[46,3,47,3],[46,4,47,4],[46,7,46,9],[46,10,47,11],[46,12,47,14],[46,15,47,17],[22,17,23,18],[13,18,14,18],[13,19,14,19],[20,17,21,18],[16,10,16,12]]}
[]
[]
[]
[null,{"$f":"'Cover sheet'!B3","v":100091},null,null,null,{"$f":"\"Glass prep order sheet for Elite \"& door_type& \" Double Glazed Door\"","v":"Glass prep order sheet for Elite Symmetry Double Glazed Door"}]
[]
[null,null,null,null,null,{"$f":"\"Offset Pivots, \"& Lock_type","v":"Offset Pivots, No lock"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Right Hand door"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Type of glass",null,null,"PART NUMBER",null,null,"DIM `A`","DIM `W`",{"$f":"IF(door_type=\"Affinity\",\"\",\"DIM `F`\")","v":"DIM `F`"},{"$f":"IF(door_type=\"Affinity\",\"\",\"DIM `G`\")","v":"DIM `G`"}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(glass_dimensions,7,MATCH(door_type,Lookups!$B$43:$C$43,0))","v":"8mm Toughened"},null,null,4000,{"$f":"Door!K22","v":0},61,{"$f":"door_height_R+INDEX(glass_dimensions,2,MATCH(door_type,Lookups!$B$43:$C$43,0))","v":-91},{"$f":"door_width_L+INDEX(glass_dimensions,3,MATCH(door_type,Lookups!$B$43:$C$43,0))","v":956},{"$f":"IF(door_type=\"Affinity\",\"\",Handle_Ht_R+INDEX(glass_dimensions,4,MATCH(door_type,Lookups!$B$43:$C$43,0)))","v":-32},{"$f":"IF(door_type=\"Affinity\",\"\",handle_pitch_R)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(glass_dimensions,6,MATCH(door_type,Lookups!$B$43:$C$43,0))","v":"6mm Toughened"},null,null,5000,{"$f":"Door!K22","v":0},61,{"$f":"Q16","v":-91},{"$f":"R16","v":956},{"$f":"S16","v":-32},{"$f":"T16","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOW IRON"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Door!U16","v":"No"}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"ACOUSTIC LAMINATED OR TOUGHENED GLASS (AS APPROPRIATE) TO THE SIZES IN THE TABLE ABOVE.   ALL EDGES TO BE POLISHED & ARRISED.  TOUGHENED GLASS TO BE HEAT SOAKED"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'Change record'!$B$1","v":"Version 9.1"},null,"REV","A","Client Name",null,{"$f":"Door!H47:J47","v":0},null,null,"ST No.",null,{"$f":"Door!N47","v":0},null,null,"Works Order No.",null,null,{"$f":"Door!T47","v":0}]
[null,null,null,null,null,"Project Name",null,{"$f":"Door!H48:J48","v":0}]

{"sheet":"LH Cutting List","index":6,"n_rows":42,"n_cols":20,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,1,6,5],[3,6,4,17],[13,2,14,5],[13,6,14,6],[13,7,14,7],[13,8,14,8],[13,9,14,11],[13,12,15,17],[17,12,17,14],[17,15,17,16],[5,6,6,18],[17,18,17,19],[18,2,19,5],[18,6,19,8],[18,9,19,11],[18,12,19,14],[18,15,19,17],[18,18,19,20],[21,2,21,5],[21,6,21,8],[21,9,21,11],[21,12,21,14],[21,15,21,17],[21,18,21,20],[20,2,20,5],[20,6,20,8],[20,9,20,11],[20,12,20,14],[20,15,20,17],[20,18,20,20],[23,18,23,20],[22,2,22,5],[22,6,22,8],[22,9,22,11],[22,12,22,14],[22,15,22,17],[22,18,22,20],[25,2,25,5],[25,6,25,8],[25,9,25,11],[25,12,25,14],[25,15,25,17],[25,18,25,20],[24,2,24,5],[24,6,24,8],[24,9,24,11],[24,12,24,14],[24,15,24,17],[24,18,24,20],[23,2,23,5],[23,6,23,8],[23,9,23,11],[23,12,23,14],[23,15,23,17],[27,18,27,20],[26,2,26,5],[26,6,26,8],[26,9,26,11],[26,12,26,14],[26,15,26,17],[26,18,26,20],[29,2,29,5],[29,6,29,8],[29,9,29,11],[29,12,29,14],[29,15,29,17],[29,18,29,20],[28,2,28,5],[28,6,28,8],[28,9,28,11],[28,12,28,14],[28,15,28,17],[28,18,28,20],[27,2,27,5],[27,6,27,8],[27,9,27,11],[27,12,27,14],[27,15,27,17],[34,2,34,5],[34,6,34,8],[34,9,34,11],[30,2,30,5],[30,6,30,8],[30,9,30,11],[30,12,30,14],[30,15,30,17],[30,18,30,20],[31,2,31,5],[31,6,31,8],[31,9,31,11],[31,12,31,14],[31,15,31,17],[31,18,31,20],[33,2,33,5],[33,6,33,8],[33,9,33,11],[33,12,33,14],[33,15,33,17],[33,18,33,20],[32,2,32,5],[32,6,32,8],[32,9,32,11],[32,12,32,14],[32,15,32,17],[32,18,32,20],[34,12,34,14],[34,15,34,17],[34,18,34,20],[35,12,35,14],[35,15,35,17],[35,18,35,20],[35,2,35,5],[35,6,35,8],[35,9,35,11],[36,2,36,5],[40,16,41,18],[40,19,41,21],[41,8,41,10],[39,13,39,14],[40,1,41,2],[40,3,41,3],[40,5,41,5],[40,8,40,10],[40,11,41,12],[40,13,41,15],[36,6,36,8],[36,9,36,11],[36,12,36,14],[36,15,36,17]]}
[]
[]
[]
[null,{"$f":"'Cover sheet'!B3","v":100091},null,null,null,null,{"$f":"\"Cutting/Machining List for Elite \" &door_type","v":"Cutting/Machining List for Elite Symmetry"}]
[]
[null,null,null,null,null,null,{"$f":"\"Offset Pivots, \"& Lock_type","v":"Offset Pivots, No lock"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"FRAME PART NUMBER",null,null,null,"HAND","QTY",null,"O/A FRAME SIZE",null,null,"LEFT HAND DOOR"]
[]
[null,null,1000,{"$f":"Door!K21","v":0},{"$f":"Door!L21","v":2},61,"L/H",{"$f":"Door!T15","v":0},null,{"$f":"Door!O15","v":1026},"X",{"$f":"Door!P15","v":-24}]
[]
[]
[null,null,"LH FRAME COMPONENT SCHEDULE",null,null,null,"MATERIAL",null,null,"DRAWING",null,null,"CUTTING LENGTH",null,null,"MACRO 'DIM E'",null,null,"QTY REQUIRED"]
[]
[]
[null,null,"Leading Stile",null,null,null,{"$f":"LEFT(J22,4)&\" (\"&LEFT(J22,4)&\"09310003)\"","v":"0423 (042309310003)"},null,null,{"$f":"HLOOKUP(door_lock,'Drawing Numbers'!$E$9:$I$29,4,FALSE)","v":"0423-002"},null,null,{"$f":"$L$16","v":-24},null,null,{"$f":"IF(door_lock>=3,Door!S15,\"\")","v":""},null,null,{"$f":"H16","v":0}]
[]
[null,null,"Fixed (pivoted) Stile",null,null,null,{"$f":"LEFT(J24,4)&\" (\"&LEFT(J24,4)&\"09310003)\"","v":"0423 (042309310003)"},null,null,{"$f":"HLOOKUP(door_lock,'Drawing Numbers'!$E$9:$I$29,6,FALSE)","v":"0423-003"},null,null,{"$f":"$L$16","v":-24},null,null,null,null,null,{"$f":"H16","v":0}]
[]
[null,null,"Head Rail",null,null,null,{"$f":"LEFT(J26,4)&\" (\"&LEFT(J26,4)&\"09310003)\"","v":"0423 (042309310003)"},null,null,{"$f":"HLOOKUP(door_lock,'Drawing Numbers'!$E$9:$I$29,8,FALSE)","v":"0423-001"},null,null,{"$f":"$J$16","v":1026},null,null,null,null,null,{"$f":"H16","v":0}]
[]
[null,null,"Base Rail",null,null,null,{"$f":"LEFT(J28,4)&\" (\"&LEFT(J28,4)&\"09310003)\"","v":"0424 (042409310003)"},null,null,{"$f":"HLOOKUP(door_lock,'Drawing Numbers'!$E$9:$I$29,10,FALSE)","v":"0424-001"},null,null,{"$f":"$J$16+INDEX(cutting_lengths,4,MATCH(door_type,Lookups!$B$34:$C$34,0))","v":930},null,null,null,null,null,{"$f":"H16","v":0}]
[]
[null,null,"6mm Glass Gasket (bottom)",null,null,null,261241300031,null,null,null,null,null,{"$f":"$J$16+INDEX(cutting_lengths,7,MATCH(door_type,Lookups!$B$34:$C$34,0))","v":930},null,null,null,null,null,{"$f":"H16","v":0}]
[null,null,"6mm Glass Gasket (top)",null,null,null,261241300031,null,null,null,null,null,{"$f":"$J$16+INDEX(cutting_lengths,6,MATCH(door_type,Lookups!$B$34:$C$34,0))","v":933},null,null,null,null,null,{"$f":"H16","v":0}]
[null,null,"6mm Glass Gasket (stiles)",null,null,null,261241300031,null,null,null,null,null,{"$f":"$L$16+INDEX(cutting_lengths,5,MATCH(door_type,Lookups!$B$34:$C$34,0))","v":-87},null,null,null,null,null,{"$f":"H16*2","v":0}]
[]
[null,null,"8mm Glass Gasket (bottom)",null,null,null,261341300031,null,null,null,null,null,{"$f":"$J$16+INDEX(cutting_lengths,7,MATCH(door_type,Lookups!$B$34:$C$34,0))","v":930},null,null,null,null,null,{"$f":"H16","v":0}]
[null,null,"8mm Glass Gasket (top)",null,null,null,261341300031,null,null,null,null,null,{"$f":"$J$16+INDEX(cutting_lengths,6,MATCH(door_type,Lookups!$B$34:$C$34,0))","v":933},null,null,null,null,null,{"$f":"H16","v":0}]
[null,null,"8mm Glass Gasket (top)",null,null,null,261341300031,null,null,null,null,null,{"$f":"$L$16+INDEX(cutting_lengths,5,MATCH(door_type,Lookups!$B$34:$C$34,0))","v":-87},null,null,null,null,null,{"$f":"H16*2","v":0}]
[]
[]
[]
[]
[null,{"$f":"'Change record'!$B$1","v":"Version 9.1"},null,"REV",null,"A","Client Name",null,{"$f":"Door!H47","v":0},null,null,"ST No.",null,{"$f":"Door!N47","v":0},null,null,"Works Order No.",null,null,{"$f":"Door!T47","v":0}]
[null,null,null,null,null,null,"Project Name",null,{"$f":"Door!H48","v":0}]

{"sheet":"RH Cutting List","index":7,"n_rows":42,"n_cols":20,"rows_kept":42,"cut":false,"hidden":false,"merged":[[36,9,36,11],[36,12,36,14],[36,15,36,17],[18,2,19,5],[18,6,19,8],[18,9,19,11],[18,12,19,14],[18,15,19,17],[18,18,19,20],[21,2,21,5],[21,6,21,8],[21,9,21,11],[21,12,21,14],[21,15,21,17],[21,18,21,20],[20,2,20,5],[20,6,20,8],[20,9,20,11],[20,12,20,14],[20,15,20,17],[20,18,20,20],[23,2,23,5],[23,6,23,8],[23,9,23,11],[3,1,6,5],[3,6,4,17],[13,2,14,5],[13,6,14,6],[13,7,14,7],[13,8,14,8],[13,9,14,11],[13,12,15,17],[5,6,6,18],[23,12,23,14],[23,15,23,17],[23,18,23,20],[22,2,22,5],[22,6,22,8],[22,9,22,11],[22,12,22,14],[22,15,22,17],[22,18,22,20],[25,2,25,5],[25,6,25,8],[25,9,25,11],[25,12,25,14],[25,15,25,17],[25,18,25,20],[24,2,24,5],[24,6,24,8],[24,9,24,11],[24,12,24,14],[24,15,24,17],[24,18,24,20],[27,2,27,5],[27,6,27,8],[27,9,27,11],[27,12,27,14],[27,15,27,17],[27,18,27,20],[26,2,26,5],[26,6,26,8],[26,9,26,11],[26,12,26,14],[26,15,26,17],[26,18,26,20],[29,2,29,5],[29,6,29,8],[29,9,29,11],[29,12,29,14],[29,15,29,17],[29,18,29,20],[28,2,28,5],[28,6,28,8],[28,9,28,11],[28,12,28,14],[28,15,28,17],[28,18,28,20],[31,2,31,5],[31,6,31,8],[31,9,31,11],[31,12,31,14],[31,15,31,17],[31,18,31,20],[30,2,30,5],[30,6,30,8],[30,9,30,11],[30,12,30,14],[30,15,30,17],[30,18,30,20],[33,2,33,5],[33,6,33,8],[33,9,33,11],[33,12,33,14],[33,15,33,17],[33,18,33,20],[32,2,32,5],[32,6,32,8],[32,9,32,11],[32,12,32,14],[32,15,32,17],[32,18,32,20],[34,2,34,5],[34,6,34,8],[34,9,34,11],[34,12,34,14],[34,15,34,17],[34,18,34,20],[40,16,41,18],[40,19,41,21],[41,8,41,10],[39,13,39,14],[40,1,41,2],[40,3,41,3],[40,5,41,5],[40,8,40,10],[40,11,41,12],[40,13,41,15],[35,2,35,5],[35,6,35,8],[35,9,35,11],[35,12,35,14],[35,15,35,17],[35,18,35,20],[36,2,36,5],[36,6,36,8]]}
[]
[]
[]
[null,{"$f":"'Cover sheet'!B3","v":100091},null,null,null,null,{"$f":"\"Cutting/Machining List for Elite \" &door_type","v":"Cutting/Machining List for Elite Symmetry"}]
[]
[null,null,null,null,null,null,{"$f":"\"Offset Pivots, \"& Lock_type","v":"Offset Pivots, No lock"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"FRAME PART NUMBER",null,null,null,"HAND","QTY",null,"O/A FRAME SIZE",null,null,"RIGHT HAND DOOR"]
[]
[null,null,1000,{"$f":"Door!K22","v":0},{"$f":"Door!L22","v":2},61,"R/H",{"$f":"Door!T16","v":0},null,{"$f":"Door!O16","v":1026},"X",{"$f":"Door!P16","v":-24}]
[]
[]
[null,null,"RH FRAME COMPONENT SCHEDULE",null,null,null,"MATERIAL",null,null,"DRAWING",null,null,"CUTTING LENGTH",null,null,"MACRO 'DIM E'",null,null,"QTY REQUIRED"]
[]
[]
[null,null,"Leading Stile",null,null,null,{"$f":"LEFT(J22,4)&\" (\"&LEFT(J22,4)&\"09310003)\"","v":"0423 (042309310003)"},null,null,{"$f":"HLOOKUP(door_lock,'Drawing Numbers'!$E$9:$I$29,15,FALSE)","v":"0423-005"},null,null,{"$f":"$L$16","v":-24},null,null,{"$f":"IF(door_lock>=3,Door!S16,\"\")","v":""},null,null,{"$f":"H16","v":0}]
[]
[null,null,"Fixed (pivoted) Stile",null,null,null,{"$f":"LEFT(J24,4)&\" (\"&LEFT(J24,4)&\"09310003)\"","v":"0423 (042309310003)"},null,null,{"$f":"HLOOKUP(door_lock,'Drawing Numbers'!$E$9:$I$29,17,FALSE)","v":"0423-006"},null,null,{"$f":"$L$16","v":-24},null,null,null,null,null,{"$f":"H16","v":0}]
[]
[null,null,"Head Rail",null,null,null,{"$f":"LEFT(J26,4)&\" (\"&LEFT(J26,4)&\"09310003)\"","v":"0423 (042309310003)"},null,null,{"$f":"HLOOKUP(door_lock,'Drawing Numbers'!$E$9:$I$29,19,FALSE)","v":"0423-004"},null,null,{"$f":"$J$16","v":1026},null,null,null,null,null,{"$f":"H16","v":0}]
[]
[null,null,"Base Rail",null,null,null,{"$f":"LEFT(J28,4)&\" (\"&LEFT(J28,4)&\"09310003)\"","v":"0424 (042409310003)"},null,null,{"$f":"HLOOKUP(door_lock,'Drawing Numbers'!$E$9:$I$29,21,FALSE)","v":"0424-002"},null,null,{"$f":"$J$16+INDEX(cutting_lengths,4,MATCH(door_type,Lookups!$B$34:$C$34,0))","v":930},null,null,null,null,null,{"$f":"H16","v":0}]
[]
[null,null,"6mm Glass Gasket",null,null,null,261241300031,null,null,null,null,null,{"$f":"$J$16+INDEX(cutting_lengths,7,MATCH(door_type,Lookups!$B$34:$C$34,0))","v":930},null,null,null,null,null,{"$f":"H16","v":0}]
[null,null,"6mm Glass Gasket",null,null,null,261241300031,null,null,null,null,null,{"$f":"$J$16+INDEX(cutting_lengths,6,MATCH(door_type,Lookups!$B$34:$C$34,0))","v":933},null,null,null,null,null,{"$f":"H16","v":0}]
[null,null,"6mm Glass Gasket",null,null,null,261241300031,null,null,null,null,null,{"$f":"$L$16+INDEX(cutting_lengths,5,MATCH(door_type,Lookups!$B$34:$C$34,0))","v":-87},null,null,null,null,null,{"$f":"H16*2","v":0}]
[]
[null,null,"8mm Glass Gasket",null,null,null,261341300031,null,null,null,null,null,{"$f":"$J$16+INDEX(cutting_lengths,7,MATCH(door_type,Lookups!$B$34:$C$34,0))","v":930},null,null,null,null,null,{"$f":"H16","v":0}]
[null,null,"8mm Glass Gasket",null,null,null,261341300031,null,null,null,null,null,{"$f":"$J$16+INDEX(cutting_lengths,6,MATCH(door_type,Lookups!$B$34:$C$34,0))","v":933},null,null,null,null,null,{"$f":"H16","v":0}]
[null,null,"8mm Glass Gasket",null,null,null,261341300031,null,null,null,null,null,{"$f":"$L$16+INDEX(cutting_lengths,5,MATCH(door_type,Lookups!$B$34:$C$34,0))","v":-87},null,null,null,null,null,{"$f":"H16*2","v":0}]
[]
[]
[]
[]
[null,{"$f":"'Change record'!$B$1","v":"Version 9.1"},null,"REV",null,"A","Client Name",null,{"$f":"Door!H47","v":0},null,null,"ST No.",null,{"$f":"Door!N47","v":0},null,null,"Works Order No.",null,null,{"$f":"Door!T47","v":0}]
[null,null,null,null,null,null,"Project Name",null,{"$f":"Door!H48","v":0}]

{"sheet":"Frame Cutting List","index":8,"n_rows":42,"n_cols":20,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,1,6,5],[3,6,4,17],[5,6,6,17],[26,2,27,5],[26,6,27,6],[26,7,27,9],[26,10,27,10],[11,2,12,5],[11,6,12,6],[11,7,12,9],[11,10,12,10],[15,12,15,14],[15,15,15,16],[18,6,18,8],[18,9,18,11],[21,12,21,14],[21,15,21,17],[32,18,32,20],[30,2,31,5],[30,6,31,8],[30,9,31,11],[30,12,31,14],[30,15,31,17],[30,18,31,20],[32,12,32,14],[32,15,32,17],[32,2,32,5],[32,6,32,8],[32,9,32,11],[36,12,36,14],[36,15,36,17],[37,2,37,5],[37,6,37,8],[37,9,37,11],[37,12,37,14],[37,15,37,17],[34,18,34,20],[33,18,33,20],[34,2,34,5],[34,6,34,8],[34,9,34,11],[34,12,34,14],[34,15,34,17],[33,2,33,5],[33,6,33,8],[33,9,33,11],[33,12,33,14],[33,15,33,17],[40,16,41,18],[40,19,41,21],[41,8,41,10],[40,1,41,2],[40,3,41,4],[40,5,41,5],[40,8,40,10],[40,11,41,12],[40,13,41,15],[15,18,15,19],[16,2,17,5],[16,6,17,8],[16,9,17,11],[16,12,17,14],[16,15,17,17],[16,18,17,20],[37,18,37,20],[38,2,38,5],[38,6,38,8],[38,9,38,11],[38,12,38,14],[38,15,38,17],[38,18,38,20],[36,18,36,20],[35,2,35,5],[35,6,35,8],[35,9,35,11],[35,12,35,14],[35,15,35,17],[35,18,35,20],[36,2,36,5],[36,6,36,8],[36,9,36,11],[21,18,21,20],[20,2,20,5],[20,6,20,8],[20,9,20,11],[20,12,20,14],[20,15,20,17],[18,12,18,14],[18,15,18,17],[18,18,18,20],[19,2,19,5],[19,6,19,8],[19,9,19,11],[19,12,19,14],[19,15,19,17],[19,18,19,20],[18,2,18,5],[24,18,24,20],[11,11,13,20],[26,11,28,20],[24,2,24,5],[24,6,24,8],[24,9,24,11],[24,12,24,14],[24,15,24,17],[22,18,22,20],[23,2,23,5],[23,6,23,8],[23,9,23,11],[23,12,23,14],[23,15,23,17],[23,18,23,20],[22,2,22,5],[22,6,22,8],[22,9,22,11],[22,12,22,14],[22,15,22,17],[20,18,20,20],[21,2,21,5],[21,6,21,8],[21,9,21,11]]}
[]
[]
[]
[null,{"$f":"'Cover sheet'!B3","v":100091},null,null,null,null,"Cutting/Machining List D660 Door Frame"]
[]
[null,null,null,null,null,null,{"$f":"Frame!F6","v":"Elite Symmetry with offset Pivots, No lock"}]
[]
[]
[]
[]
[]
[null,null,"FRAME PART NUMBER",null,null,null,"HAND","O/A FRAME SIZE",null,null,"QTY","LEFT HAND DOOR FRAME"]
[]
[null,null,{"$f":"Frame!$J$12","v":"1018"},{"$f":"Frame!$K$12","v":2},{"$f":"Frame!$L$12","v":0},{"$f":"Frame!$M$12","v":27},"LH",{"$f":"Frame!$O$12","v":1094},"X",{"$f":"Frame!$L$12","v":0},{"$f":"Frame!$X$12","v":0}]
[]
[]
[null,null,"FRAME COMPONENT SCHEDULE",null,null,null,"MATERIAL",null,null,"DRAWING",null,null,"CUTTING LENGTH",null,null,"DIM  E",null,null,"QTY REQUIRED"]
[]
[]
[null,null,"Jamb Pivot Side ",null,null,null,{"$f":"LEFT(J20,4)&\" (\"&LEFT(J20,4)&\"09310003)\"","v":"0440 (044009310003)"},null,null,{"$f":"HLOOKUP(door_lock,'Drawing Numbers'!$E$46:$I$65,3)","v":"0440-001"},null,null,{"$f":"$J$14+50","v":50},null,null,null,null,null,{"$f":"$K$14","v":0}]
[]
[null,null,"Jamb Latch Side",null,null,null,{"$f":"LEFT(J22,4)&\" (\"&LEFT(J22,4)&\"09310003)\"","v":"0440 (044009310003)"},null,null,{"$f":"HLOOKUP(door_lock,'Drawing Numbers'!$E$46:$I$65,5)","v":"0440-005"},null,null,{"$f":"$J$14+50","v":50},null,null,{"$f":"Frame!Q12","v":{"$error":"#N/A"}},null,null,{"$f":"$K$14","v":0}]
[]
[null,null,"Head",null,null,null,{"$f":"LEFT(J24,4)&\" (\"&LEFT(J24,4)&\"09310003)\"","v":"0437 (043709310003)"},null,null,{"$f":"HLOOKUP(door_lock,'Drawing Numbers'!$E$46:$I$65,7)","v":"0437-001"},null,null,{"$f":"$H$14-58","v":1036},null,null,null,null,null,{"$f":"$K$14","v":0}]
[]
[]
[null,null,"FRAME PART NUMBER",null,null,null,"HAND","O/A FRAME SIZE",null,null,"QTY","RIGHT HAND DOOR FRAME"]
[]
[null,null,{"$f":"Frame!$J$13","v":"2018"},{"$f":"Frame!$K$13","v":2},{"$f":"Frame!$L$13","v":0},{"$f":"Frame!$M$13","v":27},"RH",{"$f":"Frame!$O$13","v":1094},"X",{"$f":"Frame!$L$13","v":0},{"$f":"Frame!$X$13","v":0}]
[]
[null,null,"FRAME COMPONENT SCHEDULE",null,null,null,"MATERIAL",null,null,"DRAWING",null,null,"CUTTING LENGTH",null,null,"DIM  E",null,null,"QTY REQUIRED"]
[]
[]
[null,null,"Jamb Pivot Side ",null,null,null,{"$f":"LEFT(J34,4)&\" (\"&LEFT(J34,4)&\"09310003)\"","v":"0440 (044009310003)"},null,null,{"$f":"HLOOKUP(door_lock,'Drawing Numbers'!$E$46:$I$65,16)","v":"0440-005"},null,null,{"$f":"$J$29+50","v":50},null,null,null,null,null,{"$f":"$K$29","v":0}]
[]
[null,null,"Jamb Latch Side",null,null,null,{"$f":"LEFT(J36,4)&\" (\"&LEFT(J36,4)&\"09310003)\"","v":"0440 (044009310003)"},null,null,{"$f":"HLOOKUP(door_lock,'Drawing Numbers'!$E$46:$I$65,18)","v":"0440-001"},null,null,{"$f":"$J$29+50","v":50},null,null,{"$f":"Frame!Q13","v":{"$error":"#N/A"}},null,null,{"$f":"$K$29","v":0}]
[]
[null,null,"Head",null,null,null,{"$f":"LEFT(J38,4)&\" (\"&LEFT(J38,4)&\"09310003)\"","v":"0437 (043709310003)"},null,null,{"$f":"HLOOKUP(door_lock,'Drawing Numbers'!$E$46:$I$65,20)","v":"0437-002"},null,null,{"$f":"$H$29-58","v":1036},null,null,null,null,null,{"$f":"$K$29","v":0}]
[]
[]
[null,{"$f":"'Change record'!$B$1","v":"Version 9.1"},null,"REV",null,"A","Client Name",null,{"$f":"Door!H47","v":0},null,null,"ST No.",null,{"$f":"Door!N47","v":0},null,null,"Works Order No.",null,null,{"$f":"Door!T47","v":0}]
[null,null,null,null,null,null,"Project Name",null,{"$f":"Door!H48","v":0}]

{"sheet":"Drawing Numbers","index":9,"n_rows":65,"n_cols":9,"rows_kept":65,"cut":false,"hidden":false,"merged":[[64,0,64,3],[65,0,65,3],[57,0,58,3],[59,0,59,3],[60,0,60,3],[61,0,61,3],[62,0,62,3],[63,0,63,3],[49,0,49,3],[50,0,50,3],[51,0,51,3],[52,0,52,3],[39,0,39,3],[44,0,45,3],[46,0,46,3],[47,0,47,3],[48,0,48,3],[41,0,41,8],[36,0,36,3],[37,0,37,3],[38,0,38,3],[33,0,33,3],[26,0,26,3],[28,0,28,3],[34,0,34,3],[35,0,35,3],[24,0,24,3],[11,0,11,3],[0,0,2,8],[13,0,13,3],[15,0,15,3],[17,0,17,3],[19,0,19,3],[22,0,22,3],[12,0,12,3],[23,0,23,3],[4,0,4,8],[5,0,5,8]]}
["Drawing numbers"]
[]
[]
[]
["Doors"]
[]
[null,null,null,null,"Symmetry","Affinity","Affinity","Affinity","Affinity"]
[null,null,null,null,"No lock","No lock","Sash lock","latch","Dead lock"]
[null,null,null,null,1,2,3,4,5]
["LH FRAME COMPONENT SCHEDULE",null,null,null,"DRAWING","DRAWING","DRAWING","DRAWING","DRAWING"]
[]
["Leading Stile",null,null,null,"0423-002","0425-007","0425-001","0425-003","0425-005"]
[]
["Fixed (pivoted) Stile",null,null,null,"0423-003","0423-003","0423-003","0423-003","0423-003"]
[]
["Head Rail",null,null,null,"0423-001","0423-007","0423-007","0423-007","0423-007"]
[]
["Base Rail",null,null,null,"0424-001","0424-003","0424-003","0424-003","0424-003"]
[]
[]
["RH FRAME COMPONENT SCHEDULE",null,null,null,"DRAWING","DRAWING","DRAWING","DRAWING","DRAWING"]
[]
["Leading Stile",null,null,null,"0423-005","0425-008","0425-002","0425-004","0425-006"]
[]
["Fixed (pivoted) Stile",null,null,null,"0423-006","0423-006","0423-006","0423-006","0423-006"]
[]
["Head Rail",null,null,null,"0423-004","0423-008","0423-008","0423-008","0423-008"]
[]
["Base Rail",null,null,null,"0424-002","0424-004","0424-004","0424-004","0424-004"]
[]
[]
["Gaskets"]
[]
["6mm Glass Gasket",null,null,null,261241300031]
["6mm Glass Gasket",null,null,null,261241300031]
["6mm Glass Gasket",null,null,null,261241300031]
[]
["8mm Glass Gasket",null,null,null,261341300031]
["8mm Glass Gasket",null,null,null,261341300031]
["8mm Glass Gasket",null,null,null,261341300031]
[]
["Frames"]
["LH FRAME COMPONENT SCHEDULE",null,null,null,"Symmetry","Affinity","Affinity","Affinity","Affinity"]
[null,null,null,null,"No lock","No lock","Sash lock","latch","Dead lock"]
["FRAME COMPONENT SCHEDULE"]
[null,null,null,null,1,2,3,4,5]
[]
["Jamb Pivot Side ",null,null,null,"0440-001","0440-001","0440-001","0440-001","0440-001"]
[]
["Jamb Latch Side",null,null,null,{"$f":"E61","v":"0440-005"},{"$f":"F61","v":"0440-005"},"0440-007","0440-006","0440-008"]
[]
["Head",null,null,null,"0437-001","0437-001","0437-001","0437-001","0437-001"]
[]
[]
[]
["RH FRAME COMPONENT SCHEDULE"]
[]
["FRAME COMPONENT SCHEDULE"]
[]
[]
["Jamb Pivot Side ",null,null,null,"0440-005","0440-005","0440-005","0440-005","0440-005"]
[]
["Jamb Latch Side",null,null,null,{"$f":"E48","v":"0440-001"},{"$f":"F48","v":"0440-001"},"0440-003","0440-002","0440-004"]
[]
["Head",null,null,null,"0437-002","0437-002","0437-002","0437-002","0437-002"]

{"sheet":"Images","index":10,"n_rows":251,"n_cols":22,"rows_kept":251,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Left hand glass",null,null,null,null,null,null,"Right hand glass"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Symmetry"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Affinity no lock"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Affinity sash lock"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Affinity Latch"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Affinity Dead lock"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Frames"]

{"sheet":"Change record","index":11,"n_rows":41,"n_cols":4,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Latest",{"$f":"INDEX(B3:B301,D1,1)","v":"Version 9.1"},null,{"$f":"IF(ISERROR(MATCH(9E+99+306,B3:B301)),MATCH(\"*\",B3:B301,-1))","v":39}]
[]
["2015-07-14","Version 1","First draft.  Single glazed only; DG disabled","For checking by Dave Webb"]
["2015-08-04","Version 2","Following review by Dave Webb"]
[null,null,"Instructions on frame sheet removed"]
[null,null,"Removal of door-only and frame-only options (unlikely to be needed)"]
[null,null,"Linking of customer details on door and frame sheets to the Cover sheet inputs"]
[null,null,"Addition of \"Corridor view\" dimensions"]
[null,null,"Combination of frame cutting lsits onto one sheet (in line with the Edge doors)"]
[null,null,"Addition of printing macros"]
[null,null,"Constraint added on width (max 1094mm, min 900mm) of frame"]
["2015-10-21","Version 3","Change to strike height - varies by lock type (dead lock is < sash and latch)"]
[null,null,"Update of printing macros"]
[null,null,"Initiation of handle heights depending on whether pull handles are needed"]
[null,null,"Bottom gap increased to 7mm"]
[null,null,"Strike plates awaiting names / codes"]
[null,null,"Title blocks on frame cutting sheet corrected"]
[null,null,"Hide lock Dims when no lock is required"]
["2015-11-13","Version 4","Strike plates names added"]
[null,null,"Bespoke option added"]
[null,null,"Default strike heights and roudned-up heights added to lookups"]
[null,null,"Print macros changed to allow change of selection"]
[null,null,"Bespoke pattern charge added"]
[null,null,"Frame numbers changed (as per Karen's list)"]
[null,null,"Special colour display changed"]
["2015-11-19","Version 5","Correction made to print macros (Dave W)."]
[null,null,"100091 number added"]
["2015-11-20","Version 6","Correction to door codes - wrong row of lookup table was used for the lock digit.  (Dave W)"]
[null,null,"Protection of special colour and colour code cells when std colour is selected (macro change)"]
["2015-11-24","Version 7","Frame print area corrected"]
[null,null,"Correction to \"handles\" macro to do handles for deadlock version"]
["2016-01-05","Version 8","New radio buttons on Cover sheet for lever options (and linked cell called \"Levers\")"]
[null,null,"New \"Levers\" macro added to show or hide these.  Note that levers is called from 3 different procedures to ensure it runs no matter what order the user makes choices"]
[null,null,"Addition of spindle table in lookups"]
[null,null,"Spindle choice displayed on Frame sheet"]
["2016-01-08","Version 9","Dim E calculation added to cutting lists for LH aand RH doors.  (spotted by Andy McKeown)"]
[null,null,"Dim X changed to Dim E on those sheets"]
[null,null,"Title changed on Cover sheeet"]
[null,null,"FIRST ISSUE"]
[null,null,"levers cell unprotected"]
["2016-03-10","Version 9.1","Prototype labels removed"]