{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Sheet1","INPUT","Sheet3","Sheet2","Sheet4","Order List","Export"],"not_rendered":{"charts":0,"images":59,"macros":1,"external_links":0,"defined_names":2,"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":"Sheet1","index":0,"n_rows":155,"n_cols":27,"rows_kept":155,"cut":false,"hidden":true,"merged":[[49,4,49,5],[49,6,49,7],[49,12,49,13],[49,14,49,15],[56,4,56,5],[56,6,56,7],[49,8,49,9],[49,10,49,11],[28,14,28,15],[28,12,28,13],[28,6,28,7],[28,4,28,5],[35,4,35,5],[35,6,35,7],[28,8,28,9],[28,10,28,11]]}
[null,false,{"$f":"IF(B1,12,IF(B2,19,IF(B3,22,28)))","v":22},false,null,false,{"$f":"IF(F1,\"Thunderbolt\",IF(F2,\"Cobra\",\"Trulock\"))","v":"Cobra"}]
[null,false,null,{"$f":"CONCATENATE(C1,\"mm\")","v":"22mm"},null,true]
[null,true,null,null,null,false]
[null,false]
[]
[null,false,{"$f":"IF(B6,35,IF(B7,45,55))","v":45},{"$f":"CONCATENATE(C6,\"mm\")","v":"45mm"},null,false,{"$f":"IF(F6,35,IF(F7,45,55))","v":45},{"$f":"CONCATENATE(G6,\"mm\")","v":"45mm"}]
[null,true,null,null,null,true]
[null,false,null,null,null,false]
[]
[null,false,{"$f":"IF(B10,\"RH\",\"LH\")","v":"LH"},{"$f":"C10","v":"LH"}]
[null,true]
[]
[null,true,false,{"$f":"IF(B13,\"Slave Only\",\"Slave and Master\")","v":"Slave Only"}]
[null,false]
[]
[null,"1050",null,{"$f":"CONCATENATE(B16,\"mm\")","v":"1050mm"}]
[null,"2100",null,{"$f":"CONCATENATE(B17,\"mm\")","v":"2100mm"}]
[]
[]
[null,null,null,"Min","Max",null,"Min","Max"]
[null,"Handle Height",{"$f":"IF(ISERROR(VALUE(B16)),0,VALUE(B16))","v":1050},{"$f":"F24","v":977},{"$f":"F25","v":1042},null,{"$f":"IF(B13,D42,D21)","v":977},{"$f":"IF(D1,IF(E42<1050,E42,1050),IF(B13,E42,E21))","v":1247},{"$f":"CONCATENATE(\"Min \",G21,\"mm\")","v":"Min 977mm"},{"$f":"CONCATENATE(\"Max \",H21,\"mm\")","v":"Max 1247mm"},null,{"$f":"IF(AND(C21>0,C21<G21),TRUE,FALSE)","v":false},{"$f":"IF(C21>H21,TRUE,FALSE)","v":false},{"$f":"OR(L21,M21,L22,M22,C21=0,C22=0)","v":false}]
[null,"Total Height",{"$f":"IF(ISERROR(VALUE(B17)),0,VALUE(B17))","v":2100},{"$f":"F26","v":2035},{"$f":"F27","v":3012},null,{"$f":"IF(B13,D43,D22)","v":1891},{"$f":"IF(D1,IF(OR(M21,L21,C21=0),2050,C21+1000),IF(B13,E43,E22))","v":3012},{"$f":"CONCATENATE(\"Min \",G22,\"mm\")","v":"Min 1891mm"},{"$f":"CONCATENATE(\"Max \",H22,\"mm\")","v":"Max 3012mm"},null,{"$f":"IF(AND(C22>0,C22<G22),TRUE,FALSE)","v":false},{"$f":"IF(C22>H22,TRUE,FALSE)","v":false}]
[]
[null,"Min Handle Height",{"$f":"C37+E37","v":977},{"$f":"C22-(C30+P30)","v":138},{"$f":"IF(D24<C24,C24,D24)","v":977},{"$f":"IF(OR(C22=0,C22>C27),C24,E24)","v":977}]
[null,"Max Handle Height",{"$f":"C37+H37","v":1247},{"$f":"C22-(C30+E30)","v":1042},{"$f":"IF(D25>C25,C25,D25)","v":1042},{"$f":"IF(OR(C22=0,C22<C26),C25,E25)","v":1042}]
[null,"Min Total Height",{"$f":"C24+C30+E30","v":2035},{"$f":"C21+(C30+E30)","v":2108},{"$f":"IF(D26<C26,C26,D26)","v":2108},{"$f":"IF(OR(C21=0,C21>E21),C26,E26)","v":2035}]
[null,"Max Total Height",{"$f":"C25+C30+P30","v":3209},{"$f":"C21+(C30+P30)","v":3012},{"$f":"IF(D27>C27,C27,D27)","v":3012},{"$f":"IF(OR(C21=0,C21<D21),C27,E27)","v":3012}]
[]
[null,null,null,null,175,null,372,null,489,null,773,null,"372 + VR",null,"773 + VR"]
[null,"Master Upper",{"$f":"730+226","v":956},{"$f":"C22-C21-C30","v":94},102,175,176,372,373,489,490,773,774,822,823,{"$f":"1223-217","v":1006}]
[null,null,null,null,{"$f":"AND($D$30>=E30,$D$30<=F30)","v":false},null,{"$f":"AND($D$30>=G30,$D$30<=H30)","v":false},null,{"$f":"AND($D$30>=I30,$D$30<=J30)","v":false},null,{"$f":"AND($D$30>=K30,$D$30<=L30)","v":false},null,{"$f":"AND($D$30>=M30,$D$30<=N30)","v":false},null,{"$f":"AND($D$30>=O30,$D$30<=P30)","v":false}]
[null,null,null,null,null,{"$f":"IF(E31,175-$D30,0)","v":0},null,{"$f":"IF(G31,H30-$D30,0)","v":0},null,{"$f":"IF(I31,J30-$D30,0)","v":0},null,{"$f":"IF(K31,L30-$D30,0)","v":0},null,{"$f":"IF(M31,N30-$D30,0)","v":0},null,{"$f":"IF(O31,P30-$D30,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(F32<=73,F32,73)","v":0},null,{"$f":"IF(H32<=207,H32,207)","v":0},null,{"$f":"IF(J32<=284,J32,284)","v":0},null,{"$f":"IF(L32<=284,L32,284)","v":0},null,{"$f":"IF(N32<=207,N32,207)","v":0},null,{"$f":"IF(P32<=284,P32,284)","v":0},null,{"$f":"H33+N33+P33+J33+L33+F33","v":0},{"$f":"R33-(S34-R34)","v":-30}]
[null,null,null,null,null,{"$f":"IF(F32>73,F32-73,0)","v":0},null,{"$f":"IF(H32>207,H32-207,0)","v":0},null,{"$f":"IF(J32>284,J32-284,0)","v":0},null,{"$f":"IF(L32>284,L32-284,0)","v":0},null,{"$f":"IF(N32>207,N32-207,0)","v":0},null,{"$f":"IF(P32>284,P32-284,0)","v":0},null,{"$f":"H34+N34+P34+J34+L34+F34","v":0},{"$f":"IF(R34<30,30,R34)","v":30}]
[]
[null,null,null,null,175,null,372]
[null,"Master Lower",875,{"$f":"C21-C37","v":175},102,175,176,372]
[null,null,null,null,{"$f":"AND($D$37>=E37,$D$37<=F37)","v":true},null,{"$f":"AND($D$37>=G37,$D$37<=H37)","v":false}]
[null,null,null,null,null,{"$f":"IF(E38,175-$D37,0)","v":0},null,{"$f":"IF(G38,H37-$D37,0)","v":0},null,{"$f":"F39+H39","v":0}]
[]
[null,null,null,"Min","Max"]
[null,"Handle Height",{"$f":"C21","v":1050},{"$f":"F45","v":977},{"$f":"F46","v":1247}]
[null,"Total Height",{"$f":"C22","v":2100},{"$f":"F47","v":1891},{"$f":"F48","v":3012}]
[]
[null,"Min Handle Height",{"$f":"IF($C$13,C58+G58,C58+E58)","v":977},{"$f":"IF($C$13,C43-(C51+H51),C43-(C51+P51))","v":138},{"$f":"IF(D45<C45,C45,D45)","v":977},{"$f":"IF(OR(C43=0,C43>C48),C45,E45)","v":977}]
[null,"Max Handle Height",{"$f":"C58+H58","v":1247},{"$f":"IF($C$13,C43-(C51+G51),C43-(C51+E51))","v":1259},{"$f":"IF(D46>C46,C46,D46)","v":1247},{"$f":"IF(OR(C43=0,C43<C47),C46,E46)","v":1247}]
[null,"Min Total Height",{"$f":"IF($C$13,C45+C51+G51,C45+C51+E51)","v":1818},{"$f":"IF($C$13,C42+(C51+G51),C42+(C51+E51))","v":1891},{"$f":"IF(D47<C47,C47,D47)","v":1891},{"$f":"IF(OR(C42=0,C42>E42),C47,E47)","v":1891}]
[null,"Max Total Height",{"$f":"IF($C$13,C46+C51+H51,C46+C51+P51)","v":3209},{"$f":"IF($C$13,C42+(C51+H51),C42+(C51+P51))","v":3012},{"$f":"IF(D48>C48,C48,D48)","v":3012},{"$f":"IF(OR(C42=0,C42<D42),C48,E48)","v":3012}]
[]
[null,null,null,null,175,null,372,null,489,null,773,null,"372 + VR",null,"773 + VR"]
[null,"Master Upper",739,{"$f":"C43-C42-C51","v":311},102,{"$f":"IF($C$13,164,175)","v":175},{"$f":"IF($C$13,165,176)","v":176},372,373,489,490,773,774,822,823,1223]
[null,null,null,null,{"$f":"AND($D$51>=E51,$D$51<=F51)","v":false},null,{"$f":"AND($D$51>=G51,$D$51<=H51)","v":true},null,{"$f":"AND($D$51>=I51,$D$51<=J51)","v":false},null,{"$f":"AND($D$51>=K51,$D$51<=L51)","v":false},null,{"$f":"AND($D$51>=M51,$D$51<=N51)","v":false},null,{"$f":"AND($D$51>=O51,$D$51<=P51)","v":false}]
[null,null,null,null,null,{"$f":"IF(E52,175-$D51,0)","v":0},null,{"$f":"IF(G52,H51-$D51,0)","v":61},null,{"$f":"IF(I52,J51-$D51,0)","v":0},null,{"$f":"IF(K52,L51-$D51,0)","v":0},null,{"$f":"IF(M52,N51-$D51,0)","v":0},null,{"$f":"IF(O52,P51-$D51,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(F53<=73,F53,73)","v":0},null,{"$f":"IF(H53<=207,H53,207)","v":61},null,{"$f":"IF(J53<=284,J53,284)","v":0},null,{"$f":"IF(L53<=284,L53,284)","v":0},null,{"$f":"IF(N53<=207,N53,207)","v":0},null,{"$f":"IF(P53<=284,P53,284)","v":0},null,{"$f":"H54+N54+P54+J54+L54+F54","v":61},{"$f":"R54-(S55-R55)","v":31}]
[null,null,null,null,null,{"$f":"IF(F53>73,F53-73,0)","v":0},null,{"$f":"IF(H53>207,H53-207,0)","v":0},null,{"$f":"IF(J53>284,J53-284,0)","v":0},null,{"$f":"IF(L53>284,L53-284,0)","v":0},null,{"$f":"IF(N53>207,N53-207,0)","v":0},null,{"$f":"IF(P53>284,P53-284,0)","v":0},null,{"$f":"H55+N55+P55+J55+L55+F55","v":0},{"$f":"IF(R55<30,30,R55)","v":30}]
[]
[null,null,null,null,175,null,372]
[null,"Master Lower",875,{"$f":"C42-C58","v":175},102,{"$f":"IF($C$13,164,175)","v":175},{"$f":"IF($C$13,165,176)","v":176},372]
[null,null,null,null,{"$f":"AND($D$58>=E58,$D$58<=F58)","v":true},null,{"$f":"AND($D$58>=G58,$D$58<=H58)","v":false}]
[null,null,null,null,null,{"$f":"IF(E59,175-$D58,0)","v":0},null,{"$f":"IF(G59,H58-$D58,0)","v":0},null,{"$f":"F60+H60","v":0}]
[]
[null,{"$f":"AND($C$1=F62,$C$6=G62,$C$10=H62)","v":false},5014080,"STV-FGTE Slave 2062-909/45 92/8 LH",null,12,45,"LH",null,{"$f":"VLOOKUP(TRUE,$B$62:$D$75,2,FALSE)","v":5013846},{"$f":"VLOOKUP(TRUE,$B$62:$D$75,3,FALSE)","v":"STV-FGTE Slave 2062-908/45 92/8 LH"},null,null,null,null,null,null,{"$f":"AND($G$1=V62,$G$6=W62,$C$10=X62)","v":false},4936988,"MASTER STV-TRULOCK LL 2062/35 RH",null,"Trulock",35,"RH",null,{"$f":"VLOOKUP(TRUE,$R$62:$T$75,2,FALSE)","v":5003720},{"$f":"VLOOKUP(TRUE,$R$62:$T$75,3,FALSE)","v":"MASTER FGTE LOCK COBRA F20/45 "}]
[null,false,5014078,"STV-FGTE Slave 2062-909/45 92/8 RH",null,12,45,"RH",null,null,null,null,null,null,null,null,null,{"$f":"AND($G$1=V63,$G$6=W63,$C$10=X63)","v":false},4936989,"MASTER STV-TRULOCK LL 2062/35 LH",null,"Trulock",35,"LH"]
[null,false,5014038,"STV-FGTE Slave 2062-915/45 92/8 LH",null,19,45,"LH",null,null,null,null,null,null,null,null,null,false,5004895,"MASTER STV-TRULOCK LL 2062/45 RH",null,"Trulock",45,"RH"]
[null,false,5014037,"STV-FGTE Slave 2062-915/45 92/8 RH",null,19,45,"RH",null,null,null,null,null,null,null,null,null,false,5004894,"MASTER STV-TRULOCK LL 2062/45 LH",null,"Trulock",45,"LH"]
[null,false,5014082,"STV-FGTE Slave 2062-908/35 92/8 LH",null,22,35,"LH",null,null,null,null,null,null,null,null,null,{"$f":"AND($G$1=V66,$G$6=W66)","v":true},5003720,"MASTER FGTE LOCK COBRA F20/45 ",null,"Cobra",45]
[null,false,5014081,"STV-FGTE Slave 2062-908/35 92/8 RH",null,22,35,"RH",null,null,null,null,null,null,null,null,null,{"$f":"AND($G$1=V67,$G$6=W67)","v":false},5017256,"MASTER FGTE LOCK COBRA F20/55 ",null,"Cobra",55]
[null,true,5013846,"STV-FGTE Slave 2062-908/45 92/8 LH",null,22,45,"LH",null,null,null,null,null,null,null,null,null,false,5016084,"MASTER FGTE LOCK THUNDERBOLT F20/45",null,"Thunderbolt",45]
[null,false,5013845,"STV-FGTE Slave 2062-908/45 92/8 RH",null,22,45,"RH"]
[null,false,5013986,"STV-FGTE Slave 2062-908/55 92/8 LH",null,22,55,"LH"]
[null,false,5013984,"STV-FGTE Slave 2062-908/55 92/8 RH",null,22,55,"RH"]
[null,false,5013991,"STV-FGTE Slave 2062-912/45 92/8 LH",null,28,45,"LH"]
[null,false,5013992,"STV-FGTE Slave 2062-912/45 92/8 RH",null,28,45,"RH"]
[null,false,5013993,"STV-FGTE Slave 2062-912/55 92/8 LH",null,28,55,"LH"]
[null,false,5013994,"STV-FGTE Slave 2062-912/55 92/8 RH",null,28,55,"RH"]
[]
[null,{"$f":"AND($C$10=H77)","v":true},2968234,"FGTE Alu 44 Rebate LH White (5 Pack)",null,19,45,"LH",{"$f":"D1","v":false},{"$f":"VLOOKUP(TRUE,$B$77:$D$78,2,FALSE)","v":2968234},{"$f":"VLOOKUP(TRUE,$B$77:$D$78,3,FALSE)","v":"FGTE Alu 44 Rebate LH White (5 Pack)"},0.2]
[null,{"$f":"AND($C$10=H78)","v":false},2968242,"FGTE Alu 44 Rebate RH White (5 Pack)",null,19,45,"RH"]
[]
[null,{"$f":"B13","v":true},2933744,"F24 FGTE Shootbolt Keep Radius End",null,null,null,null,null,{"$f":"VLOOKUP(TRUE,$B$80:$D$81,2,FALSE)","v":2933744},{"$f":"VLOOKUP(TRUE,$B$80:$D$81,3,FALSE)","v":"F24 FGTE Shootbolt Keep Radius End"}]
[null,{"$f":"B14","v":false},2938393,"F24-908 MV1 Keep Radius End"]
[]
[null,null,"Part Number","Description","Qty","Size"]
[1,"Master Lock",{"$f":"Z62","v":5003720},{"$f":"AA62","v":"MASTER FGTE LOCK COBRA F20/45 "},1,{"$f":"\"\"","v":""}]
[2,"Bottom Shootbolt",2500480,"STV-A 175 Shootbolt",{"$f":"IF(E38,1,0)","v":1},{"$f":"CONCATENATE(175-J39,\"mm\")","v":"175mm"}]
[3,"Bottom Shootbolt",2930754,"STV-A 372 Shootbolt",{"$f":"IF(G38,1,0)","v":0},{"$f":"CONCATENATE(372-J39,\"mm\")","v":"372mm"}]
[4,"Top Extension",5003674,"FGTE Master Lock Reversing Mech",1,{"$f":"\"\"","v":""}]
[5,{"$f":"\"\"","v":""},5003676,"VR450/20 Extension",{"$f":"IF(OR(M31,O31),1,0)","v":0},{"$f":"CONCATENATE(450-R34,\"mm\",G88)","v":"450mm"},{"$f":"IF(E88=2,\" (On 1 x VR0/20)\",\"\")","v":""}]
[6,"Top Shootbolt",{"$f":"C85","v":2500480},"STV-A 175 Shootbolt",{"$f":"IF(E31,1,0)","v":0},{"$f":"CONCATENATE(175-R33,\"mm\")","v":"175mm"}]
[7,"Top Shootbolt",2930754,"STV-A 372 Shootbolt",{"$f":"IF(OR(G31,M31),1,0)","v":0},{"$f":"CONCATENATE(372-R33,\"mm\")","v":"372mm"}]
[8,"Top Shootbolt",2500498,"STV-A 489 Shootbolt",{"$f":"IF(I31,1,0)","v":0},{"$f":"CONCATENATE(489-R33,\"mm\")","v":"489mm"}]
[9,"Top Shootbolt",2096392,"STV-A 773 Shootbolt",{"$f":"IF(OR(K31,O31),1,0)","v":0},{"$f":"CONCATENATE(773-R33,\"mm\")","v":"773mm"}]
[999,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""}]
[null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""}]
[1,"Master Lock",{"$f":"C84","v":5003720},{"$f":"D84","v":"MASTER FGTE LOCK COBRA F20/45 "},1,{"$f":"F84","v":""},null,{"$f":"IF(E95=0,999,A95)","v":1},{"$f":"SMALL(H$95:H$103,A95)","v":1}]
[2,"Bottom Shootbolt",{"$f":"C85","v":2500480},"STV-A 175 Shootbolt",{"$f":"IF($B$13,0,E85)","v":0},"175mm",null,{"$f":"IF(E96=0,999,A96)","v":999},{"$f":"SMALL(H$95:H$103,A96)","v":999}]
[3,"Bottom Shootbolt",2930754,"STV-A 372 Shootbolt",0,"372mm",null,999,999]
[4,"Top Extensions",{"$f":"C87","v":5003674},"FGTE Master Lock Reversing Mech",0,"",null,999,999]
[5,{"$f":"\"\"","v":""},{"$f":"C88","v":5003676},"VR450/20 Extension",0,"450mm",null,999,999]
[6,"Top Shootbolt",{"$f":"C89","v":2500480},"STV-A 175 Shootbolt",0,"175mm",null,999,999]
[7,"Top Shootbolt",2930754,"STV-A 372 Shootbolt",0,{"$f":"F90","v":"372mm"},null,999,999]
[8,"Top Shootbolt",2500498,"STV-A 489 Shootbolt",{"$f":"IF($B$13,0,E91)","v":0},"489mm",null,999,999]
[9,"Top Shootbolt",2096392,"STV-A 773 Shootbolt",0,"773mm",null,999,999]
[999,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""}]
[null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""}]
[null,{"$f":"VLOOKUP($I95,$A$95:$F$104,2,FALSE)","v":"Master Lock"},{"$f":"VLOOKUP($I95,$A$95:$F$104,3,FALSE)","v":5003720},{"$f":"VLOOKUP($I95,$A$95:$F$104,4,FALSE)","v":"MASTER FGTE LOCK COBRA F20/45 "},{"$f":"VLOOKUP($I95,$A$95:$F$104,5,FALSE)","v":1},{"$f":"VLOOKUP($I95,$A$95:$F$104,6,FALSE)","v":""}]
[null,"","","","",""]
[null,"","","","",""]
[null,"","","","",""]
[null,"","","","",""]
[null,"","","","",""]
[]
[]
[null,null,"Part Number","Description","Qty","Size"]
[1,"Slave Lock",{"$f":"J62","v":5013846},{"$f":"K62","v":"STV-FGTE Slave 2062-908/45 92/8 LH"},1,{"$f":"\"\"","v":""},null,{"$f":"IF(E115=0,999,A115)","v":1},{"$f":"SMALL(H$115:H$122,A115)","v":1}]
[2,"Bottom Shootbolt",{"$f":"C85","v":2500480},"STV-A 175 Shootbolt",{"$f":"IF(E59,1,0)","v":1},{"$f":"CONCATENATE(175-J60,\"mm\")","v":"175mm"},null,{"$f":"IF(E116=0,999,A116)","v":2},{"$f":"SMALL(H$115:H$122,A116)","v":2},{"$f":"CONCATENATE(J60,\"mm\")","v":"0mm"}]
[3,"Bottom Shootbolt",2930754,"STV-A 372 Shootbolt",{"$f":"IF(G59,1,0)","v":0},{"$f":"CONCATENATE(372-J60,\"mm\")","v":"372mm"},null,999,6]
[4,"Top Extension",{"$f":"C88","v":5003676},"VR450/20 Extension",{"$f":"IF(OR(M52,O52),1,0)","v":0},{"$f":"CONCATENATE(450-R55,\"mm\",G118)","v":"450mm"},{"$f":"IF(E118=2,\" (On 1 x VR0/20)\",\"\")","v":""},{"$f":"IF(E118=0,999,A118)","v":999},999]
[5,"Top Shootbolt",{"$f":"C89","v":2500480},"STV-A 175 Shootbolt",{"$f":"IF(E52,1,0)","v":0},{"$f":"CONCATENATE(175-R54,\"mm\")","v":"114mm"},null,999,999]
[6,"Top Shootbolt",2930754,"STV-A 372 Shootbolt",{"$f":"IF(OR(G52,M52),1,0)","v":1},{"$f":"CONCATENATE(372-R54,\"mm\")","v":"311mm"},null,6,999]
[7,"Top Shootbolt",2500498,"STV-A 489 Shootbolt",{"$f":"IF(I52,1,0)","v":0},{"$f":"CONCATENATE(489-R54,\"mm\")","v":"428mm"},null,999,999]
[8,"Top Shootbolt",2096392,"STV-A 773 Shootbolt",{"$f":"IF(OR(K52,O52),1,0)","v":0},{"$f":"CONCATENATE(773-R54,\"mm\")","v":"712mm"},null,999,999]
[999,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""}]
[null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""}]
[null,{"$f":"VLOOKUP($I115,$A$115:$F$123,2,FALSE)","v":"Slave Lock"},{"$f":"VLOOKUP($I115,$A$115:$F$123,3,FALSE)","v":5013846},{"$f":"VLOOKUP($I115,$A$115:$F$123,4,FALSE)","v":"STV-FGTE Slave 2062-908/45 92/8 LH"},{"$f":"VLOOKUP($I115,$A$115:$F$123,5,FALSE)","v":1},{"$f":"VLOOKUP($I115,$A$115:$F$123,6,FALSE)","v":""}]
[null,"Bottom Shootbolt",2500480,"STV-A 175 Shootbolt",1,"175mm"]
[null,"Top Shootbolt",2930754,"STV-A 372 Shootbolt",1,"311mm"]
[null,"","","","",""]
[null,"","","","",""]
[null,"","","","",""]
[]
[null,"Shootbolt Keeps",{"$f":"J80","v":2933744},{"$f":"K80","v":"F24 FGTE Shootbolt Keep Radius End"},2,{"$f":"\"\"","v":""}]
[null,{"$f":"IF(I77,\"Alu Edge Strip\",\"\")","v":""},{"$f":"IF(I77,J77,\"\")","v":""},{"$f":"IF(I77,K77,\"\")","v":""},{"$f":"IF(I77,L77,\"\")","v":""}]
[]
[1,null,{"$f":"C95","v":5003720},{"$f":"D95","v":"MASTER FGTE LOCK COBRA F20/45 "},{"$f":"E95","v":1},null,null,{"$f":"IF(E135=0,999,A135)","v":1},{"$f":"SMALL(H$135:H$144,A135)","v":1},null,null,null,{"$f":"INDIRECT(\"Sheet2!A02\")","v":1},{"$f":"IF(M135>0,1,0)","v":1}]
[2,null,{"$f":"C115","v":5013846},{"$f":"D115","v":"STV-FGTE Slave 2062-908/45 92/8 LH"},{"$f":"E115","v":1},null,null,{"$f":"IF(E136=0,999,A136)","v":2},{"$f":"SMALL(H$135:H$144,A136)","v":2},null,null,null,{"$f":"INDIRECT(\"Sheet2!A12\")","v":0},{"$f":"IF(M136>0,1,0)","v":0}]
[3,null,{"$f":"C96","v":2500480},{"$f":"D96","v":"STV-A 175 Shootbolt"},{"$f":"E96+E100+E116+E119","v":1},null,null,3,3,null,null,null,{"$f":"INDIRECT(\"Sheet2!A22\")","v":0},0]
[4,null,{"$f":"C97","v":2930754},{"$f":"D97","v":"STV-A 372 Shootbolt"},{"$f":"E97+E101+E117+E120","v":1},null,null,4,4,null,null,null,{"$f":"INDIRECT(\"Sheet2!A32\")","v":0},0]
[5,null,{"$f":"C102","v":2500498},{"$f":"D102","v":"STV-A 489 Shootbolt"},{"$f":"E102+E121","v":0},null,null,999,9,null,null,null,{"$f":"INDIRECT(\"Sheet2!A42\")","v":0},0]
[6,null,{"$f":"C103","v":2096392},{"$f":"D103","v":"STV-A 773 Shootbolt"},{"$f":"E103+E122","v":0},null,null,999,999,null,null,null,{"$f":"INDIRECT(\"Sheet2!A52\")","v":0},0]
[7,null,{"$f":"C98","v":5003674},{"$f":"D98","v":"FGTE Master Lock Reversing Mech"},{"$f":"E98","v":0},null,null,999,999,null,null,null,{"$f":"INDIRECT(\"Sheet2!A62\")","v":0},0]
[8,null,{"$f":"C99","v":5003676},{"$f":"D99","v":"VR450/20 Extension"},{"$f":"E99+E118","v":0},null,null,999,999,null,null,null,{"$f":"INDIRECT(\"Sheet2!A72\")","v":0},0]
[9,null,{"$f":"C132","v":2933744},{"$f":"D132","v":"F24 FGTE Shootbolt Keep Radius End"},{"$f":"E132","v":2},null,null,9,999,null,null,null,{"$f":"INDIRECT(\"Sheet2!A82\")","v":0},0]
[10,null,{"$f":"J77","v":2968234},{"$f":"K77","v":"FGTE Alu 44 Rebate LH White (5 Pack)"},{"$f":"IF(E133=0.2,0.2,0)","v":0},null,null,999,999,null,null,null,{"$f":"INDIRECT(\"Sheet2!A92\")","v":0},0]
[999,null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""}]
[]
[{"$f":"OR(F148=0,ISERROR(F148))","v":false},null,"Part Number","Description","Qty Per Door Set","Total Qty",null,null,null,null,null,null,null,{"$f":"SUM(N135:N144)","v":1}]
[1,null,{"$f":"VLOOKUP($I135,$A$135:$F$145,3,FALSE)","v":5003720},{"$f":"VLOOKUP($I135,$A$135:$F$145,4,FALSE)","v":"MASTER FGTE LOCK COBRA F20/45 "},{"$f":"VLOOKUP($I135,$A$135:$F$145,5,FALSE)","v":1},{"$f":"IF(E148=\"\",\"\",$A$148*E148)","v":1}]
[{"$f":"D2","v":"22mm"},null,{"$f":"VLOOKUP($I136,$A$135:$F$145,3,FALSE)","v":5013846},{"$f":"VLOOKUP($I136,$A$135:$F$145,4,FALSE)","v":"STV-FGTE Slave 2062-908/45 92/8 LH"},{"$f":"VLOOKUP($I136,$A$135:$F$145,5,FALSE)","v":1},1]
[{"$f":"D6","v":"45mm"},null,2500480,"STV-A 175 Shootbolt",1,1]
[{"$f":"D10","v":"LH"},null,2930754,"STV-A 372 Shootbolt",1,1]
[{"$f":"D13","v":"Slave Only"},null,2933744,"F24 FGTE Shootbolt Keep Radius End",2,2]
[{"$f":"D16","v":"1050mm"},null,"","","",""]
[{"$f":"D17","v":"2100mm"},null,"","","",""]
[null,null,"","","",""]

{"sheet":"INPUT","index":1,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"MASTER DOOR","Part Number","Description","Qty","Shoot/Ext Size"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Sheet1!B106","v":"Master Lock"},{"$f":"Sheet1!Z62","v":5003720},{"$f":"Sheet1!AA62","v":"MASTER FGTE LOCK COBRA F20/45 "},{"$f":"Sheet1!E106","v":1},{"$f":"Sheet1!F106","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Sheet1!B107","v":""},{"$f":"Sheet1!C107","v":""},{"$f":"Sheet1!D107","v":""},{"$f":"Sheet1!E107","v":""},{"$f":"Sheet1!F107","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Sheet1!B108","v":""},{"$f":"Sheet1!C108","v":""},{"$f":"Sheet1!D108","v":""},{"$f":"Sheet1!E108","v":""},{"$f":"Sheet1!F108","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Sheet1!B109","v":""},{"$f":"Sheet1!C109","v":""},{"$f":"Sheet1!D109","v":""},{"$f":"Sheet1!E109","v":""},{"$f":"Sheet1!F109","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Sheet1!B110","v":""},{"$f":"Sheet1!C110","v":""},{"$f":"Sheet1!D110","v":""},{"$f":"Sheet1!E110","v":""},{"$f":"Sheet1!F110","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,"SLAVE DOOR","Part Number","Description","Qty","Shoot/Ext Size"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Sheet1!B125","v":"Slave Lock"},{"$f":"Sheet1!C125","v":5013846},{"$f":"Sheet1!D125","v":"STV-FGTE Slave 2062-908/45 92/8 LH"},{"$f":"Sheet1!E125","v":1},{"$f":"Sheet1!F125","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Sheet1!B126","v":"Bottom Shootbolt"},{"$f":"Sheet1!C126","v":2500480},{"$f":"Sheet1!D126","v":"STV-A 175 Shootbolt"},{"$f":"Sheet1!E126","v":1},{"$f":"Sheet1!F126","v":"175mm"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Sheet1!B127","v":"Top Shootbolt"},{"$f":"Sheet1!C127","v":2930754},{"$f":"Sheet1!D127","v":"STV-A 372 Shootbolt"},{"$f":"Sheet1!E127","v":1},{"$f":"Sheet1!F127","v":"311mm"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Sheet1!B128","v":""},{"$f":"Sheet1!C128","v":""},{"$f":"Sheet1!D128","v":""},{"$f":"Sheet1!E128","v":""},{"$f":"Sheet1!F128","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,"ADDITIONAL PARTS","Part Number","Description","Qty"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Sheet1!B132","v":"Shootbolt Keeps"},{"$f":"Sheet1!C132","v":2933744},{"$f":"Sheet1!D132","v":"F24 FGTE Shootbolt Keep Radius End"},{"$f":"Sheet1!E132","v":2}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Sheet1!B133","v":""},{"$f":"Sheet1!C133","v":""},{"$f":"Sheet1!D133","v":""},{"$f":"Sheet1!E133","v":""}]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet2","index":3,"n_rows":91,"n_cols":6,"rows_kept":91,"cut":false,"hidden":true,"merged":[]}
[null,null,"Part Number","Description","Qty Per Door Set","Total Qty"]
[1,null,5016084,"MASTER FGTE LOCK THUNDERBOLT F20/45",1,1]
["22mm",null,5013845,"STV-FGTE Slave 2062-908/45 92/8 RH",1,1]
["45mm",null,2500480,"STV-A 175 Shootbolt",1,1]
["RH",null,2930754,"STV-A 372 Shootbolt",1,1]
["Slave Only",null,2933744,"F24 FGTE Shootbolt Keep Radius End",2,2]
["1050mm"]
["2100mm"]
[]
[]
[null,null,"Part Number","Description","Qty Per Door Set","Total Qty"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Part Number","Description","Qty Per Door Set","Total Qty"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Part Number","Description","Qty Per Door Set","Total Qty"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Part Number","Description","Qty Per Door Set","Total Qty"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Part Number","Description","Qty Per Door Set","Total Qty"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Part Number","Description","Qty Per Door Set","Total Qty"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Part Number","Description","Qty Per Door Set","Total Qty"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Part Number","Description","Qty Per Door Set","Total Qty"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Part Number","Description","Qty Per Door Set","Total Qty"]

{"sheet":"Sheet4","index":4,"n_rows":101,"n_cols":28,"rows_kept":101,"cut":false,"hidden":true,"merged":[]}
[null,null,null,{"$f":"INDIRECT(\"Sheet2!C1\")","v":"Part Number"},{"$f":"INDIRECT(\"Sheet2!D1\")","v":"Description"},{"$f":"INDIRECT(\"Sheet2!F1\")","v":"Total Qty"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Part Number","Description","Total Qty",null,null,"Part Number","Description","Total Qty"]
[1,{"$f":"VALUE(CONCATENATE(IF(AND(D2>0,D2<9999999),D2,999999999),\".\",A2))","v":5016084.0999999996},null,{"$f":"INDIRECT(\"Sheet2!C2\")","v":5016084},{"$f":"INDIRECT(\"Sheet2!D2\")","v":"MASTER FGTE LOCK THUNDERBOLT F20/45"},{"$f":"INDIRECT(\"Sheet2!F2\")","v":1},null,null,{"$f":"SMALL(B:B,A2)","v":2500480.2999999998},1,{"$f":"IF(I2>999999999,\"\",VLOOKUP(I2,B:F,3,FALSE))","v":2500480},{"$f":"IF(I2>999999999,\"\",VLOOKUP(I2,B:F,4,FALSE))","v":"STV-A 175 Shootbolt"},{"$f":"IF(I2>999999999,\"\",VLOOKUP(I2,B:F,5,FALSE))","v":1},null,{"$f":"M2","v":1},{"$f":"IF(K2=K3,0,O2)","v":1},null,{"$f":"IF(P2=0,999,J2)","v":1},{"$f":"SMALL(R:R,J2)","v":1},{"$f":"IF(S2=999,999,COUNTIF($V$2:$V$41,\"<=\"&V2))","v":38},{"$f":"VLOOKUP(S2,J:P,2,FALSE)","v":2500480},{"$f":"VLOOKUP(S2,J:P,3,FALSE)","v":"STV-A 175 Shootbolt"},{"$f":"VLOOKUP(S2,J:P,7,FALSE)","v":1},null,{"$f":"SMALL(T:T,A2)","v":36},{"$f":"VLOOKUP(Y2,T:W,2,FALSE)","v":2933744},{"$f":"VLOOKUP(Y2,T:W,3,FALSE)","v":"F24 FGTE Shootbolt Keep Radius End"},{"$f":"VLOOKUP(Y2,T:W,4,FALSE)","v":2}]
[2,5013845.2,null,{"$f":"INDIRECT(\"Sheet2!C3\")","v":5013845},{"$f":"INDIRECT(\"Sheet2!D3\")","v":"STV-FGTE Slave 2062-908/45 92/8 RH"},{"$f":"INDIRECT(\"Sheet2!F3\")","v":1},null,null,2930754.4,2,2930754,"STV-A 372 Shootbolt",1,null,{"$f":"IF(K3=K2,M3+O2,M3)","v":1},{"$f":"IF(K3=K4,0,O3)","v":1},null,{"$f":"IF(P3=0,999,J3)","v":2},2,39,2930754,"STV-A 372 Shootbolt",1,null,37,{"$f":"VLOOKUP(Y3,T:W,2,FALSE)","v":5016084},{"$f":"VLOOKUP(Y3,T:W,3,FALSE)","v":"MASTER FGTE LOCK THUNDERBOLT F20/45"},{"$f":"VLOOKUP(Y3,T:W,4,FALSE)","v":1}]
[3,2500480.2999999998,null,{"$f":"INDIRECT(\"Sheet2!C4\")","v":2500480},{"$f":"INDIRECT(\"Sheet2!D4\")","v":"STV-A 175 Shootbolt"},{"$f":"INDIRECT(\"Sheet2!F4\")","v":1},null,null,2933744.5,3,2933744,"F24 FGTE Shootbolt Keep Radius End",2,null,{"$f":"IF(K4=K3,M4+O3,M4)","v":2},{"$f":"IF(K4=K5,0,O4)","v":2},null,3,3,36,2933744,"F24 FGTE Shootbolt Keep Radius End",2,null,38,2500480,"STV-A 175 Shootbolt",1]
[4,2930754.4,null,{"$f":"INDIRECT(\"Sheet2!C5\")","v":2930754},{"$f":"INDIRECT(\"Sheet2!D5\")","v":"STV-A 372 Shootbolt"},{"$f":"INDIRECT(\"Sheet2!F5\")","v":1},null,null,5013845.2,4,5013845,"STV-FGTE Slave 2062-908/45 92/8 RH",1,null,1,1,null,4,4,40,5013845,"STV-FGTE Slave 2062-908/45 92/8 RH",1,null,39,2930754,"STV-A 372 Shootbolt",1]
[5,2933744.5,null,{"$f":"INDIRECT(\"Sheet2!C6\")","v":2933744},{"$f":"INDIRECT(\"Sheet2!D6\")","v":"F24 FGTE Shootbolt Keep Radius End"},{"$f":"INDIRECT(\"Sheet2!F6\")","v":2},null,null,5016084.0999999996,5,5016084,"MASTER FGTE LOCK THUNDERBOLT F20/45",1,null,1,1,null,5,5,37,5016084,"MASTER FGTE LOCK THUNDERBOLT F20/45",1,null,40,5013845,"STV-FGTE Slave 2062-908/45 92/8 RH",1]
[6,999999999.60000002,null,{"$f":"INDIRECT(\"Sheet2!C7\")","v":0},{"$f":"INDIRECT(\"Sheet2!D7\")","v":0},{"$f":"INDIRECT(\"Sheet2!F7\")","v":0},null,null,999999999.10000002,6,"","","",null,"",0,null,999,999,999,"","","",null,999,"","",""]
[7,999999999.70000005,null,{"$f":"INDIRECT(\"Sheet2!C8\")","v":0},{"$f":"INDIRECT(\"Sheet2!D8\")","v":0},{"$f":"INDIRECT(\"Sheet2!F8\")","v":0},null,null,999999999.10000002,7,"","","",null,{"$error":"#VALUE!"},0,null,999,999,999,"","","",null,999,"","",""]
[8,999999999.79999995,null,{"$f":"INDIRECT(\"Sheet2!C9\")","v":0},{"$f":"INDIRECT(\"Sheet2!D9\")","v":0},{"$f":"INDIRECT(\"Sheet2!F9\")","v":0},null,null,999999999.11000001,8,"","","",null,{"$error":"#VALUE!"},0,null,999,999,999,"","","",null,999,"","",""]
[9,999999999.89999998,null,{"$f":"INDIRECT(\"Sheet2!C10\")","v":0},{"$f":"INDIRECT(\"Sheet2!D10\")","v":0},{"$f":"INDIRECT(\"Sheet2!F10\")","v":0},null,null,999999999.12,9,"","","",null,{"$error":"#VALUE!"},0,null,999,999,999,"","","",null,999,"","",""]
[10,999999999.10000002,null,{"$f":"INDIRECT(\"Sheet2!C11\")","v":"Part Number"},{"$f":"INDIRECT(\"Sheet2!D11\")","v":"Description"},{"$f":"INDIRECT(\"Sheet2!F11\")","v":"Total Qty"},null,null,999999999.13,10,"","","",null,{"$error":"#VALUE!"},0,null,999,999,999,"","","",null,999,"","",""]
[11,999999999.11000001,null,{"$f":"INDIRECT(\"Sheet2!C12\")","v":0},{"$f":"INDIRECT(\"Sheet2!D12\")","v":0},{"$f":"INDIRECT(\"Sheet2!F12\")","v":0},null,null,999999999.13999999,11,"","","",null,{"$error":"#VALUE!"},0,null,999,999,999,"","","",null,999,"","",""]
[12,999999999.12,null,{"$f":"INDIRECT(\"Sheet2!C13\")","v":0},{"$f":"INDIRECT(\"Sheet2!D13\")","v":0},{"$f":"INDIRECT(\"Sheet2!F13\")","v":0},null,null,999999999.14999998,12,"","","",null,{"$error":"#VALUE!"},0,null,999,999,999,"","","",null,999,"","",""]
[13,999999999.13,null,{"$f":"INDIRECT(\"Sheet2!C14\")","v":0},{"$f":"INDIRECT(\"Sheet2!D14\")","v":0},{"$f":"INDIRECT(\"Sheet2!F14\")","v":0},null,null,999999999.15999997,13,"","","",null,{"$f":"IF(K14=K13,M14+O13,M14)","v":{"$error":"#VALUE!"}},0,null,999,999,999,"","","",null,999,"","",""]
[14,999999999.13999999,null,{"$f":"INDIRECT(\"Sheet2!C15\")","v":0},{"$f":"INDIRECT(\"Sheet2!D15\")","v":0},{"$f":"INDIRECT(\"Sheet2!F15\")","v":0},null,null,999999999.16999996,14,"","","",null,{"$error":"#VALUE!"},0,null,999,999,999,"","","",null,999,"","",""]
[15,999999999.14999998,null,{"$f":"INDIRECT(\"Sheet2!C16\")","v":0},{"$f":"INDIRECT(\"Sheet2!D16\")","v":0},{"$f":"INDIRECT(\"Sheet2!F16\")","v":0},null,null,999999999.17999995,15,"","","",null,{"$f":"IF(K16=K15,M16+O15,M16)","v":{"$error":"#VALUE!"}},0,null,999,999,999,"","","",null,999,"","",""]
[16,999999999.15999997,null,{"$f":"INDIRECT(\"Sheet2!C17\")","v":0},{"$f":"INDIRECT(\"Sheet2!D17\")","v":0},{"$f":"INDIRECT(\"Sheet2!F17\")","v":0},null,null,999999999.19000006,16,"","","",null,{"$error":"#VALUE!"},0,null,999,999,999,"","","",null,999,"","",""]
[17,999999999.16999996,null,{"$f":"INDIRECT(\"Sheet2!C18\")","v":0},{"$f":"INDIRECT(\"Sheet2!D18\")","v":0},{"$f":"INDIRECT(\"Sheet2!F18\")","v":0},null,null,999999999.20000005,17,"","","",null,{"$error":"#VALUE!"},0,null,999,999,999,"","","",null,999,"","",""]
[18,999999999.17999995,null,{"$f":"INDIRECT(\"Sheet2!C19\")","v":0},{"$f":"INDIRECT(\"Sheet2!D19\")","v":0},{"$f":"INDIRECT(\"Sheet2!F19\")","v":0},null,null,999999999.21000004,18,"","","",null,{"$error":"#VALUE!"},0,null,999,999,999,"","","",null,999,"","",""]
[19,999999999.19000006,null,{"$f":"INDIRECT(\"Sheet2!C20\")","v":0},{"$f":"INDIRECT(\"Sheet2!D20\")","v":0},{"$f":"INDIRECT(\"Sheet2!F20\")","v":0},null,null,999999999.22000003,19,"","","",null,{"$error":"#VALUE!"},0,null,999,999,999,"","","",null,999,"","",""]
[20,999999999.20000005,null,{"$f":"INDIRECT(\"Sheet2!C21\")","v":"Part Number"},{"$f":"INDIRECT(\"Sheet2!D21\")","v":"Description"},{"$f":"INDIRECT(\"Sheet2!F21\")","v":"Total Qty"},null,null,999999999.23000002,20,"","","",null,{"$error":"#VALUE!"},0,null,999,999,999,"","","",null,999,"","",""]
[21,999999999.21000004,null,{"$f":"INDIRECT(\"Sheet2!C22\")","v":0},{"$f":"INDIRECT(\"Sheet2!D22\")","v":0},{"$f":"INDIRECT(\"Sheet2!F22\")","v":0},null,null,999999999.24000001,21,"","","",null,{"$error":"#VALUE!"},0,null,999,999,999,"","","",null,999,"","",""]
[22,999999999.22000003,null,{"$f":"INDIRECT(\"Sheet2!C23\")","v":0},{"$f":"INDIRECT(\"Sheet2!D23\")","v":0},{"$f":"INDIRECT(\"Sheet2!F23\")","v":0},null,null,999999999.25,22,"","","",null,{"$error":"#VALUE!"},0,null,999,999,999,"","","",null,999,"","",""]
[23,999999999.23000002,null,{"$f":"INDIRECT(\"Sheet2!C24\")","v":0},{"$f":"INDIRECT(\"Sheet2!D24\")","v":0},{"$f":"INDIRECT(\"Sheet2!F24\")","v":0},null,null,999999999.25999999,23,"","","",null,{"$error":"#VALUE!"},0,null,999,999,999,"","","",null,999,"","",""]
[24,999999999.24000001,null,{"$f":"INDIRECT(\"Sheet2!C25\")","v":0},{"$f":"INDIRECT(\"Sheet2!D25\")","v":0},{"$f":"INDIRECT(\"Sheet2!F25\")","v":0},null,null,999999999.26999998,24,"","","",null,{"$error":"#VALUE!"},0,null,999,999,999,"","","",null,999,"","",""]
[25,999999999.25,null,{"$f":"INDIRECT(\"Sheet2!C26\")","v":0},{"$f":"INDIRECT(\"Sheet2!D26\")","v":0},{"$f":"INDIRECT(\"Sheet2!F26\")","v":0},null,null,999999999.27999997,25,"","","",null,{"$error":"#VALUE!"},0,null,999,999,999,"","","",null,999,"","",""]
[26,999999999.25999999,null,{"$f":"INDIRECT(\"Sheet2!C27\")","v":0},{"$f":"INDIRECT(\"Sheet2!D27\")","v":0},{"$f":"INDIRECT(\"Sheet2!F27\")","v":0},null,null,999999999.28999996,26,"","","",null,{"$error":"#VALUE!"},0,null,999,999,999,"","","",null,999,"","",""]
[27,999999999.26999998,null,{"$f":"INDIRECT(\"Sheet2!C28\")","v":0},{"$f":"INDIRECT(\"Sheet2!D28\")","v":0},{"$f":"INDIRECT(\"Sheet2!F28\")","v":0},null,null,999999999.29999995,27,"","","",null,{"$f":"IF(K28=K27,M28+O27,M28)","v":{"$error":"#VALUE!"}},{"$f":"IF(K28=K29,0,O28)","v":0},null,999,999,999,"","","",null,999,"","",""]
[28,999999999.27999997,null,{"$f":"INDIRECT(\"Sheet2!C29\")","v":0},{"$f":"INDIRECT(\"Sheet2!D29\")","v":0},{"$f":"INDIRECT(\"Sheet2!F29\")","v":0},null,null,999999999.30999994,28,"","","",null,{"$error":"#VALUE!"},0,null,999,999,999,"","","",null,999,"","",""]
[29,999999999.28999996,null,{"$f":"INDIRECT(\"Sheet2!C30\")","v":0},{"$f":"INDIRECT(\"Sheet2!D30\")","v":0},{"$f":"INDIRECT(\"Sheet2!F30\")","v":0},null,null,999999999.32000005,29,"","","",null,{"$error":"#VALUE!"},0,null,999,999,999,"","","",null,999,"","",""]
[30,999999999.29999995,null,{"$f":"INDIRECT(\"Sheet2!C31\")","v":"Part Number"},{"$f":"INDIRECT(\"Sheet2!D31\")","v":"Description"},{"$f":"INDIRECT(\"Sheet2!F31\")","v":"Total Qty"},null,null,999999999.33000004,30,"","","",null,{"$error":"#VALUE!"},0,null,999,999,999,"","","",null,999,"","",""]
[31,999999999.30999994,null,{"$f":"INDIRECT(\"Sheet2!C32\")","v":0},{"$f":"INDIRECT(\"Sheet2!D32\")","v":0},{"$f":"INDIRECT(\"Sheet2!F32\")","v":0},null,null,999999999.34000003,31,"","","",null,{"$error":"#VALUE!"},0,null,999,999,999,"","","",null,999,"","",""]
[32,999999999.32000005,null,{"$f":"INDIRECT(\"Sheet2!C33\")","v":0},{"$f":"INDIRECT(\"Sheet2!D33\")","v":0},{"$f":"INDIRECT(\"Sheet2!F33\")","v":0},null,null,999999999.35000002,32,"","","",null,{"$error":"#VALUE!"},0,null,999,999,999,"","","",null,999,"","",""]
[33,999999999.33000004,null,{"$f":"INDIRECT(\"Sheet2!C34\")","v":0},{"$f":"INDIRECT(\"Sheet2!D34\")","v":0},{"$f":"INDIRECT(\"Sheet2!F34\")","v":0},null,null,999999999.36000001,33,{"$f":"IF(I34>999999999,\"\",VLOOKUP(I34,B:F,3,FALSE))","v":""},{"$f":"IF(I34>999999999,\"\",VLOOKUP(I34,B:F,4,FALSE))","v":""},{"$f":"IF(I34>999999999,\"\",VLOOKUP(I34,B:F,5,FALSE))","v":""},null,{"$error":"#VALUE!"},0,null,999,999,999,"","","",null,999,"","",""]
[34,999999999.34000003,null,{"$f":"INDIRECT(\"Sheet2!C35\")","v":0},{"$f":"INDIRECT(\"Sheet2!D35\")","v":0},{"$f":"INDIRECT(\"Sheet2!F35\")","v":0},null,null,999999999.37,34,"","","",null,{"$error":"#VALUE!"},0,null,999,999,999,"","","",null,999,"","",""]
[35,999999999.35000002,null,{"$f":"INDIRECT(\"Sheet2!C36\")","v":0},{"$f":"INDIRECT(\"Sheet2!D36\")","v":0},{"$f":"INDIRECT(\"Sheet2!F36\")","v":0},null,null,999999999.38,35,"","","",null,{"$error":"#VALUE!"},0,null,999,999,999,"","","",null,999,"","",""]
[36,999999999.36000001,null,{"$f":"INDIRECT(\"Sheet2!C37\")","v":0},{"$f":"INDIRECT(\"Sheet2!D37\")","v":0},{"$f":"INDIRECT(\"Sheet2!F37\")","v":0},null,null,999999999.38999999,36,"","","",null,{"$error":"#VALUE!"},0,null,999,999,999,"","","",null,999,"","",""]
[37,999999999.37,null,{"$f":"INDIRECT(\"Sheet2!C38\")","v":0},{"$f":"INDIRECT(\"Sheet2!D38\")","v":0},{"$f":"INDIRECT(\"Sheet2!F38\")","v":0},null,null,999999999.39999998,37,"","","",null,{"$error":"#VALUE!"},0,null,999,999,999,"","","",null,999,"","",""]
[38,999999999.38,null,{"$f":"INDIRECT(\"Sheet2!C39\")","v":0},{"$f":"INDIRECT(\"Sheet2!D39\")","v":0},{"$f":"INDIRECT(\"Sheet2!F39\")","v":0},null,null,999999999.40999997,38,"","","",null,{"$error":"#VALUE!"},0,null,999,999,999,"","","",null,999,"","",""]
[39,999999999.38999999,null,{"$f":"INDIRECT(\"Sheet2!C40\")","v":0},{"$f":"INDIRECT(\"Sheet2!D40\")","v":0},{"$f":"INDIRECT(\"Sheet2!F40\")","v":0},null,null,999999999.41999996,39,"","","",null,{"$error":"#VALUE!"},0,null,999,999,999,"","","",null,999,"","",""]
[40,999999999.39999998,null,{"$f":"INDIRECT(\"Sheet2!C41\")","v":"Part Number"},{"$f":"INDIRECT(\"Sheet2!D41\")","v":"Description"},{"$f":"INDIRECT(\"Sheet2!F41\")","v":"Total Qty"},null,null,999999999.42999995,40,"","","",null,{"$error":"#VALUE!"},0,null,999,999,999,"","","",null,999,"","",""]
[41,999999999.40999997,null,{"$f":"INDIRECT(\"Sheet2!C42\")","v":0},{"$f":"INDIRECT(\"Sheet2!D42\")","v":0},{"$f":"INDIRECT(\"Sheet2!F42\")","v":0},null,null,999999999.44000006,41,"","","",null,{"$error":"#VALUE!"},0,null,999]
[42,999999999.41999996,null,{"$f":"INDIRECT(\"Sheet2!C43\")","v":0},{"$f":"INDIRECT(\"Sheet2!D43\")","v":0},{"$f":"INDIRECT(\"Sheet2!F43\")","v":0},null,null,999999999.45000005,42,"","","",null,{"$error":"#VALUE!"},0,null,999]
[43,999999999.42999995,null,{"$f":"INDIRECT(\"Sheet2!C44\")","v":0},{"$f":"INDIRECT(\"Sheet2!D44\")","v":0},{"$f":"INDIRECT(\"Sheet2!F44\")","v":0},null,null,999999999.46000004,43,"","","",null,{"$error":"#VALUE!"},0,null,999]
[44,999999999.44000006,null,{"$f":"INDIRECT(\"Sheet2!C45\")","v":0},{"$f":"INDIRECT(\"Sheet2!D45\")","v":0},{"$f":"INDIRECT(\"Sheet2!F45\")","v":0},null,null,{"$f":"SMALL(B:B,A45)","v":999999999.47000003},44,"","","",null,{"$error":"#VALUE!"},0,null,999]
[45,{"$f":"VALUE(CONCATENATE(IF(AND(D46>0,D46<9999999),D46,999999999),\".\",A46))","v":999999999.45000005},null,{"$f":"INDIRECT(\"Sheet2!C46\")","v":0},{"$f":"INDIRECT(\"Sheet2!D46\")","v":0},{"$f":"INDIRECT(\"Sheet2!F46\")","v":0},null,null,999999999.48000002,45,"","","",null,{"$error":"#VALUE!"},0,null,999]
[46,999999999.46000004,null,{"$f":"INDIRECT(\"Sheet2!C47\")","v":0},{"$f":"INDIRECT(\"Sheet2!D47\")","v":0},{"$f":"INDIRECT(\"Sheet2!F47\")","v":0},null,null,999999999.49000001,46,"","","",null,{"$error":"#VALUE!"},0,null,999]
[47,999999999.47000003,null,{"$f":"INDIRECT(\"Sheet2!C48\")","v":0},{"$f":"INDIRECT(\"Sheet2!D48\")","v":0},{"$f":"INDIRECT(\"Sheet2!F48\")","v":0},null,null,999999999.5,47,"","","",null,{"$error":"#VALUE!"},0,null,999]
[48,999999999.48000002,null,{"$f":"INDIRECT(\"Sheet2!C49\")","v":0},{"$f":"INDIRECT(\"Sheet2!D49\")","v":0},{"$f":"INDIRECT(\"Sheet2!F49\")","v":0},null,null,999999999.50999999,48,"","","",null,{"$error":"#VALUE!"},0,null,999]
[49,999999999.49000001,null,{"$f":"INDIRECT(\"Sheet2!C50\")","v":0},{"$f":"INDIRECT(\"Sheet2!D50\")","v":0},{"$f":"INDIRECT(\"Sheet2!F50\")","v":0},null,null,999999999.51999998,49,"","","",null,{"$error":"#VALUE!"},0,null,999]
[50,999999999.5,null,{"$f":"INDIRECT(\"Sheet2!C51\")","v":"Part Number"},{"$f":"INDIRECT(\"Sheet2!D51\")","v":"Description"},{"$f":"INDIRECT(\"Sheet2!F51\")","v":"Total Qty"},null,null,999999999.52999997,50,"","","",null,{"$error":"#VALUE!"},0,null,999]
[51,999999999.50999999,null,{"$f":"INDIRECT(\"Sheet2!C52\")","v":0},{"$f":"INDIRECT(\"Sheet2!D52\")","v":0},{"$f":"INDIRECT(\"Sheet2!F52\")","v":0},null,null,999999999.53999996,51,"","","",null,{"$error":"#VALUE!"},0,null,999]
[52,999999999.51999998,null,{"$f":"INDIRECT(\"Sheet2!C53\")","v":0},{"$f":"INDIRECT(\"Sheet2!D53\")","v":0},{"$f":"INDIRECT(\"Sheet2!F53\")","v":0},null,null,999999999.54999995,52,"","","",null,{"$error":"#VALUE!"},0,null,999]
[53,999999999.52999997,null,{"$f":"INDIRECT(\"Sheet2!C54\")","v":0},{"$f":"INDIRECT(\"Sheet2!D54\")","v":0},{"$f":"INDIRECT(\"Sheet2!F54\")","v":0},null,null,999999999.55999994,53,"","","",null,{"$error":"#VALUE!"},0,null,999]
[54,999999999.53999996,null,{"$f":"INDIRECT(\"Sheet2!C55\")","v":0},{"$f":"INDIRECT(\"Sheet2!D55\")","v":0},{"$f":"INDIRECT(\"Sheet2!F55\")","v":0},null,null,999999999.57000005,54,"","","",null,{"$error":"#VALUE!"},0,null,999]
[55,999999999.54999995,null,{"$f":"INDIRECT(\"Sheet2!C56\")","v":0},{"$f":"INDIRECT(\"Sheet2!D56\")","v":0},{"$f":"INDIRECT(\"Sheet2!F56\")","v":0},null,null,999999999.58000004,55,"","","",null,{"$error":"#VALUE!"},0,null,999]
[56,999999999.55999994,null,{"$f":"INDIRECT(\"Sheet2!C57\")","v":0},{"$f":"INDIRECT(\"Sheet2!D57\")","v":0},{"$f":"INDIRECT(\"Sheet2!F57\")","v":0},null,null,999999999.59000003,56,"","","",null,{"$error":"#VALUE!"},0,null,999]
[57,999999999.57000005,null,{"$f":"INDIRECT(\"Sheet2!C58\")","v":0},{"$f":"INDIRECT(\"Sheet2!D58\")","v":0},{"$f":"INDIRECT(\"Sheet2!F58\")","v":0},null,null,999999999.60000002,57,"","","",null,{"$error":"#VALUE!"},0,null,999]
[58,999999999.58000004,null,{"$f":"INDIRECT(\"Sheet2!C59\")","v":0},{"$f":"INDIRECT(\"Sheet2!D59\")","v":0},{"$f":"INDIRECT(\"Sheet2!F59\")","v":0},null,null,999999999.60000002,58,"","","",null,{"$error":"#VALUE!"},0,null,999]
[59,999999999.59000003,null,{"$f":"INDIRECT(\"Sheet2!C60\")","v":0},{"$f":"INDIRECT(\"Sheet2!D60\")","v":0},{"$f":"INDIRECT(\"Sheet2!F60\")","v":0},null,null,999999999.61000001,59,"","","",null,{"$error":"#VALUE!"},0,null,999]
[60,999999999.60000002,null,{"$f":"INDIRECT(\"Sheet2!C61\")","v":"Part Number"},{"$f":"INDIRECT(\"Sheet2!D61\")","v":"Description"},{"$f":"INDIRECT(\"Sheet2!F61\")","v":"Total Qty"},null,null,999999999.62,60,"","","",null,{"$error":"#VALUE!"},0,null,999]
[61,999999999.61000001,null,{"$f":"INDIRECT(\"Sheet2!C62\")","v":0},{"$f":"INDIRECT(\"Sheet2!D62\")","v":0},{"$f":"INDIRECT(\"Sheet2!F62\")","v":0},null,null,999999999.63,61,"","","",null,{"$error":"#VALUE!"},0,null,999]
[62,999999999.62,null,{"$f":"INDIRECT(\"Sheet2!C63\")","v":0},{"$f":"INDIRECT(\"Sheet2!D63\")","v":0},{"$f":"INDIRECT(\"Sheet2!F63\")","v":0},null,null,999999999.63999999,62,"","","",null,{"$error":"#VALUE!"},0,null,999]
[63,999999999.63,null,{"$f":"INDIRECT(\"Sheet2!C64\")","v":0},{"$f":"INDIRECT(\"Sheet2!D64\")","v":0},{"$f":"INDIRECT(\"Sheet2!F64\")","v":0},null,null,999999999.64999998,63,"","","",null,{"$error":"#VALUE!"},0,null,999]
[64,999999999.63999999,null,{"$f":"INDIRECT(\"Sheet2!C65\")","v":0},{"$f":"INDIRECT(\"Sheet2!D65\")","v":0},{"$f":"INDIRECT(\"Sheet2!F65\")","v":0},null,null,999999999.65999997,64,"","","",null,{"$error":"#VALUE!"},0,null,999]
[65,999999999.64999998,null,{"$f":"INDIRECT(\"Sheet2!C66\")","v":0},{"$f":"INDIRECT(\"Sheet2!D66\")","v":0},{"$f":"INDIRECT(\"Sheet2!F66\")","v":0},null,null,999999999.66999996,65,{"$f":"IF(I66>999999999,\"\",VLOOKUP(I66,B:F,3,FALSE))","v":""},{"$f":"IF(I66>999999999,\"\",VLOOKUP(I66,B:F,4,FALSE))","v":""},{"$f":"IF(I66>999999999,\"\",VLOOKUP(I66,B:F,5,FALSE))","v":""},null,{"$error":"#VALUE!"},0,null,999]
[66,999999999.65999997,null,{"$f":"INDIRECT(\"Sheet2!C67\")","v":0},{"$f":"INDIRECT(\"Sheet2!D67\")","v":0},{"$f":"INDIRECT(\"Sheet2!F67\")","v":0},null,null,999999999.67999995,66,"","","",null,{"$error":"#VALUE!"},0,null,{"$f":"IF(P67=0,999,J67)","v":999}]
[67,999999999.66999996,null,{"$f":"INDIRECT(\"Sheet2!C68\")","v":0},{"$f":"INDIRECT(\"Sheet2!D68\")","v":0},{"$f":"INDIRECT(\"Sheet2!F68\")","v":0},null,null,999999999.69000006,67,"","","",null,{"$error":"#VALUE!"},0,null,999]
[68,999999999.67999995,null,{"$f":"INDIRECT(\"Sheet2!C69\")","v":0},{"$f":"INDIRECT(\"Sheet2!D69\")","v":0},{"$f":"INDIRECT(\"Sheet2!F69\")","v":0},null,null,999999999.70000005,68,"","","",null,{"$error":"#VALUE!"},0,null,999]
[69,999999999.69000006,null,{"$f":"INDIRECT(\"Sheet2!C70\")","v":0},{"$f":"INDIRECT(\"Sheet2!D70\")","v":0},{"$f":"INDIRECT(\"Sheet2!F70\")","v":0},null,null,999999999.70000005,69,"","","",null,{"$error":"#VALUE!"},0,null,999]
[70,999999999.70000005,null,{"$f":"INDIRECT(\"Sheet2!C71\")","v":"Part Number"},{"$f":"INDIRECT(\"Sheet2!D71\")","v":"Description"},{"$f":"INDIRECT(\"Sheet2!F71\")","v":"Total Qty"},null,null,999999999.71000004,70,"","","",null,{"$error":"#VALUE!"},0,null,999]
[71,999999999.71000004,null,{"$f":"INDIRECT(\"Sheet2!C72\")","v":0},{"$f":"INDIRECT(\"Sheet2!D72\")","v":0},{"$f":"INDIRECT(\"Sheet2!F72\")","v":0},null,null,999999999.72000003,71,"","","",null,{"$error":"#VALUE!"},0,null,999]
[72,999999999.72000003,null,{"$f":"INDIRECT(\"Sheet2!C73\")","v":0},{"$f":"INDIRECT(\"Sheet2!D73\")","v":0},{"$f":"INDIRECT(\"Sheet2!F73\")","v":0},null,null,999999999.73000002,72,"","","",null,{"$error":"#VALUE!"},0,null,999]
[73,999999999.73000002,null,{"$f":"INDIRECT(\"Sheet2!C74\")","v":0},{"$f":"INDIRECT(\"Sheet2!D74\")","v":0},{"$f":"INDIRECT(\"Sheet2!F74\")","v":0},null,null,999999999.74000001,73,"","","",null,{"$error":"#VALUE!"},0,null,999]
[74,999999999.74000001,null,{"$f":"INDIRECT(\"Sheet2!C75\")","v":0},{"$f":"INDIRECT(\"Sheet2!D75\")","v":0},{"$f":"INDIRECT(\"Sheet2!F75\")","v":0},null,null,999999999.75,74,"","","",null,{"$error":"#VALUE!"},0,null,999]
[75,999999999.75,null,{"$f":"INDIRECT(\"Sheet2!C76\")","v":0},{"$f":"INDIRECT(\"Sheet2!D76\")","v":0},{"$f":"INDIRECT(\"Sheet2!F76\")","v":0},null,null,999999999.75999999,75,"","","",null,{"$error":"#VALUE!"},0,null,999]
[76,999999999.75999999,null,{"$f":"INDIRECT(\"Sheet2!C77\")","v":0},{"$f":"INDIRECT(\"Sheet2!D77\")","v":0},{"$f":"INDIRECT(\"Sheet2!F77\")","v":0},null,null,999999999.76999998,76,"","","",null,{"$error":"#VALUE!"},0,null,999]
[77,999999999.76999998,null,{"$f":"INDIRECT(\"Sheet2!C78\")","v":0},{"$f":"INDIRECT(\"Sheet2!D78\")","v":0},{"$f":"INDIRECT(\"Sheet2!F78\")","v":0},null,null,999999999.77999997,77,"","","",null,{"$error":"#VALUE!"},0,null,999]
[78,999999999.77999997,null,{"$f":"INDIRECT(\"Sheet2!C79\")","v":0},{"$f":"INDIRECT(\"Sheet2!D79\")","v":0},{"$f":"INDIRECT(\"Sheet2!F79\")","v":0},null,null,999999999.78999996,78,"","","",null,{"$error":"#VALUE!"},0,null,999]
[79,999999999.78999996,null,{"$f":"INDIRECT(\"Sheet2!C80\")","v":0},{"$f":"INDIRECT(\"Sheet2!D80\")","v":0},{"$f":"INDIRECT(\"Sheet2!F80\")","v":0},null,null,999999999.79999995,79,"","","",null,{"$error":"#VALUE!"},0,null,999]
[80,999999999.79999995,null,{"$f":"INDIRECT(\"Sheet2!C81\")","v":"Part Number"},{"$f":"INDIRECT(\"Sheet2!D81\")","v":"Description"},{"$f":"INDIRECT(\"Sheet2!F81\")","v":"Total Qty"},null,null,999999999.79999995,80,"","","",null,{"$error":"#VALUE!"},0,null,999]
[81,999999999.80999994,null,{"$f":"INDIRECT(\"Sheet2!C82\")","v":0},{"$f":"INDIRECT(\"Sheet2!D82\")","v":0},{"$f":"INDIRECT(\"Sheet2!F82\")","v":0},null,null,999999999.80999994,81,"","","",null,{"$error":"#VALUE!"},0,null,999]
[82,999999999.82000005,null,{"$f":"INDIRECT(\"Sheet2!C83\")","v":0},{"$f":"INDIRECT(\"Sheet2!D83\")","v":0},{"$f":"INDIRECT(\"Sheet2!F83\")","v":0},null,null,999999999.82000005,82,"","","",null,{"$error":"#VALUE!"},0,null,999]
[83,999999999.83000004,null,{"$f":"INDIRECT(\"Sheet2!C84\")","v":0},{"$f":"INDIRECT(\"Sheet2!D84\")","v":0},{"$f":"INDIRECT(\"Sheet2!F84\")","v":0},null,null,999999999.83000004,83,"","","",null,{"$error":"#VALUE!"},0,null,999]
[84,999999999.84000003,null,{"$f":"INDIRECT(\"Sheet2!C85\")","v":0},{"$f":"INDIRECT(\"Sheet2!D85\")","v":0},{"$f":"INDIRECT(\"Sheet2!F85\")","v":0},null,null,999999999.84000003,84,"","","",null,{"$error":"#VALUE!"},0,null,999]
[85,999999999.85000002,null,{"$f":"INDIRECT(\"Sheet2!C86\")","v":0},{"$f":"INDIRECT(\"Sheet2!D86\")","v":0},{"$f":"INDIRECT(\"Sheet2!F86\")","v":0},null,null,999999999.85000002,85,"","","",null,{"$error":"#VALUE!"},0,null,999]
[86,999999999.86000001,null,{"$f":"INDIRECT(\"Sheet2!C87\")","v":0},{"$f":"INDIRECT(\"Sheet2!D87\")","v":0},{"$f":"INDIRECT(\"Sheet2!F87\")","v":0},null,null,999999999.86000001,86,"","","",null,{"$error":"#VALUE!"},0,null,999]
[87,999999999.87,null,{"$f":"INDIRECT(\"Sheet2!C88\")","v":0},{"$f":"INDIRECT(\"Sheet2!D88\")","v":0},{"$f":"INDIRECT(\"Sheet2!F88\")","v":0},null,null,999999999.87,87,"","","",null,{"$error":"#VALUE!"},0,null,999]
[88,999999999.88,null,{"$f":"INDIRECT(\"Sheet2!C89\")","v":0},{"$f":"INDIRECT(\"Sheet2!D89\")","v":0},{"$f":"INDIRECT(\"Sheet2!F89\")","v":0},null,null,999999999.88,88,"","","",null,{"$error":"#VALUE!"},0,null,999]
[89,999999999.88999999,null,{"$f":"INDIRECT(\"Sheet2!C90\")","v":0},{"$f":"INDIRECT(\"Sheet2!D90\")","v":0},{"$f":"INDIRECT(\"Sheet2!F90\")","v":0},null,null,999999999.88999999,89,"","","",null,{"$error":"#VALUE!"},0,null,999]
[90,999999999.89999998,null,{"$f":"INDIRECT(\"Sheet2!C91\")","v":"Part Number"},{"$f":"INDIRECT(\"Sheet2!D91\")","v":"Description"},{"$f":"INDIRECT(\"Sheet2!F91\")","v":"Total Qty"},null,null,999999999.89999998,90,"","","",null,{"$error":"#VALUE!"},0,null,999]
[91,999999999.90999997,null,{"$f":"INDIRECT(\"Sheet2!C92\")","v":0},{"$f":"INDIRECT(\"Sheet2!D92\")","v":0},{"$f":"INDIRECT(\"Sheet2!F92\")","v":0},null,null,999999999.89999998,999,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""}]
[92,999999999.91999996,null,{"$f":"INDIRECT(\"Sheet2!C93\")","v":0},{"$f":"INDIRECT(\"Sheet2!D93\")","v":0},{"$f":"INDIRECT(\"Sheet2!F93\")","v":0},null,null,999999999.90999997]
[93,999999999.92999995,null,{"$f":"INDIRECT(\"Sheet2!C94\")","v":0},{"$f":"INDIRECT(\"Sheet2!D94\")","v":0},{"$f":"INDIRECT(\"Sheet2!F94\")","v":0},null,null,999999999.91999996]
[94,999999999.94000006,null,{"$f":"INDIRECT(\"Sheet2!C95\")","v":0},{"$f":"INDIRECT(\"Sheet2!D95\")","v":0},{"$f":"INDIRECT(\"Sheet2!F95\")","v":0},null,null,999999999.92999995]
[95,999999999.95000005,null,{"$f":"INDIRECT(\"Sheet2!C96\")","v":0},{"$f":"INDIRECT(\"Sheet2!D96\")","v":0},{"$f":"INDIRECT(\"Sheet2!F96\")","v":0},null,null,999999999.94000006]
[96,999999999.96000004,null,{"$f":"INDIRECT(\"Sheet2!C97\")","v":0},{"$f":"INDIRECT(\"Sheet2!D97\")","v":0},{"$f":"INDIRECT(\"Sheet2!F97\")","v":0},null,null,999999999.95000005]
[97,999999999.97000003,null,{"$f":"INDIRECT(\"Sheet2!C98\")","v":0},{"$f":"INDIRECT(\"Sheet2!D98\")","v":0},{"$f":"INDIRECT(\"Sheet2!F98\")","v":0},null,null,999999999.96000004]
[98,999999999.98000002,null,{"$f":"INDIRECT(\"Sheet2!C99\")","v":0},{"$f":"INDIRECT(\"Sheet2!D99\")","v":0},{"$f":"INDIRECT(\"Sheet2!F99\")","v":0},null,null,999999999.97000003]
[99,999999999.99000001,null,{"$f":"INDIRECT(\"Sheet2!C100\")","v":0},{"$f":"INDIRECT(\"Sheet2!D100\")","v":0},{"$f":"INDIRECT(\"Sheet2!F100\")","v":0},null,null,999999999.98000002]
[100,999999999.10000002,null,null,null,null,null,null,999999999.99000001]

{"sheet":"Order List","index":5,"n_rows":107,"n_cols":12,"rows_kept":107,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[null,"TOTAL ORDER QUANTITY",null,null,null,"ITEMISED PARTS"]
[]
[null,"Part Number","Description","Total Qty",null,{"$f":"IF(G8=\"\",\"\",\"Quantity\")","v":"Quantity"},{"$f":"IF(INDIRECT(\"sheet2!A2\")=0,\"\",INDIRECT(\"sheet2!A2\"))","v":1},null,{"$f":"IF(INDIRECT(\"sheet2!C2\")=0,\"\",INDIRECT(\"sheet2!C1\"))","v":"Part Number"},{"$f":"IF(INDIRECT(\"sheet2!D2\")=0,\"\",INDIRECT(\"sheet2!D1\"))","v":"Description"},{"$f":"IF(INDIRECT(\"sheet2!E2\")=0,\"\",INDIRECT(\"sheet2!E1\"))","v":"Qty Per Door Set"},{"$f":"IF(INDIRECT(\"sheet2!F2\")=0,\"\",INDIRECT(\"sheet2!F1\"))","v":"Total Qty"}]
[null,{"$f":"Sheet4!Z2","v":2933744},{"$f":"Sheet4!AA2","v":"F24 FGTE Shootbolt Keep Radius End"},{"$f":"Sheet4!AB2","v":2},null,{"$f":"IF(G9=\"\",\"\",\"Lock Centre Line\")","v":"Lock Centre Line"},{"$f":"IF(INDIRECT(\"sheet2!A3\")=0,\"\",INDIRECT(\"sheet2!A3\"))","v":"22mm"},null,{"$f":"IF(INDIRECT(\"sheet2!C2\")=0,\"\",INDIRECT(\"sheet2!C2\"))","v":5016084},{"$f":"IF(INDIRECT(\"sheet2!D2\")=0,\"\",INDIRECT(\"sheet2!D2\"))","v":"MASTER FGTE LOCK THUNDERBOLT F20/45"},{"$f":"IF(INDIRECT(\"sheet2!E2\")=0,\"\",INDIRECT(\"sheet2!E2\"))","v":1},{"$f":"IF(INDIRECT(\"sheet2!F2\")=0,\"\",INDIRECT(\"sheet2!F2\"))","v":1}]
[null,{"$f":"Sheet4!Z3","v":5016084},{"$f":"Sheet4!AA3","v":"MASTER FGTE LOCK THUNDERBOLT F20/45"},{"$f":"Sheet4!AB3","v":1},null,{"$f":"IF(G10=\"\",\"\",\"Slave Backset\")","v":"Slave Backset"},{"$f":"IF(INDIRECT(\"sheet2!A4\")=0,\"\",INDIRECT(\"sheet2!A4\"))","v":"45mm"},null,{"$f":"IF(INDIRECT(\"sheet2!C3\")=0,\"\",INDIRECT(\"sheet2!C3\"))","v":5013845},{"$f":"IF(INDIRECT(\"sheet2!D3\")=0,\"\",INDIRECT(\"sheet2!D3\"))","v":"STV-FGTE Slave 2062-908/45 92/8 RH"},{"$f":"IF(INDIRECT(\"sheet2!E3\")=0,\"\",INDIRECT(\"sheet2!E3\"))","v":1},{"$f":"IF(INDIRECT(\"sheet2!F3\")=0,\"\",INDIRECT(\"sheet2!F3\"))","v":1}]
[null,{"$f":"Sheet4!Z4","v":2500480},{"$f":"Sheet4!AA4","v":"STV-A 175 Shootbolt"},{"$f":"Sheet4!AB4","v":1},null,{"$f":"IF(G11=\"\",\"\",\"Handing\")","v":"Handing"},{"$f":"IF(INDIRECT(\"sheet2!A5\")=0,\"\",INDIRECT(\"sheet2!A5\"))","v":"RH"},null,{"$f":"IF(INDIRECT(\"sheet2!C4\")=0,\"\",INDIRECT(\"sheet2!C4\"))","v":2500480},{"$f":"IF(INDIRECT(\"sheet2!D4\")=0,\"\",INDIRECT(\"sheet2!D4\"))","v":"STV-A 175 Shootbolt"},{"$f":"IF(INDIRECT(\"sheet2!E4\")=0,\"\",INDIRECT(\"sheet2!E4\"))","v":1},{"$f":"IF(INDIRECT(\"sheet2!F4\")=0,\"\",INDIRECT(\"sheet2!F4\"))","v":1}]
[null,{"$f":"Sheet4!Z5","v":2930754},{"$f":"Sheet4!AA5","v":"STV-A 372 Shootbolt"},{"$f":"Sheet4!AB5","v":1},null,{"$f":"IF(G12=\"\",\"\",\"Shootbolt Options\")","v":"Shootbolt Options"},{"$f":"IF(INDIRECT(\"sheet2!A6\")=0,\"\",INDIRECT(\"sheet2!A6\"))","v":"Slave Only"},null,{"$f":"IF(INDIRECT(\"sheet2!C5\")=0,\"\",INDIRECT(\"sheet2!C5\"))","v":2930754},{"$f":"IF(INDIRECT(\"sheet2!D5\")=0,\"\",INDIRECT(\"sheet2!D5\"))","v":"STV-A 372 Shootbolt"},{"$f":"IF(INDIRECT(\"sheet2!E5\")=0,\"\",INDIRECT(\"sheet2!E5\"))","v":1},{"$f":"IF(INDIRECT(\"sheet2!F5\")=0,\"\",INDIRECT(\"sheet2!F5\"))","v":1}]
[null,{"$f":"Sheet4!Z6","v":5013845},{"$f":"Sheet4!AA6","v":"STV-FGTE Slave 2062-908/45 92/8 RH"},{"$f":"Sheet4!AB6","v":1},null,{"$f":"IF(G13=\"\",\"\",\"Handle Height\")","v":"Handle Height"},{"$f":"IF(INDIRECT(\"sheet2!A7\")=0,\"\",INDIRECT(\"sheet2!A7\"))","v":"1050mm"},null,{"$f":"IF(INDIRECT(\"sheet2!C6\")=0,\"\",INDIRECT(\"sheet2!C6\"))","v":2933744},{"$f":"IF(INDIRECT(\"sheet2!D6\")=0,\"\",INDIRECT(\"sheet2!D6\"))","v":"F24 FGTE Shootbolt Keep Radius End"},{"$f":"IF(INDIRECT(\"sheet2!E6\")=0,\"\",INDIRECT(\"sheet2!E6\"))","v":2},{"$f":"IF(INDIRECT(\"sheet2!F6\")=0,\"\",INDIRECT(\"sheet2!F6\"))","v":2}]
[null,{"$f":"Sheet4!Z7","v":""},{"$f":"Sheet4!AA7","v":""},{"$f":"Sheet4!AB7","v":""},null,{"$f":"IF(G14=\"\",\"\",\"Door Rebate Height\")","v":"Door Rebate Height"},{"$f":"IF(INDIRECT(\"sheet2!A8\")=0,\"\",INDIRECT(\"sheet2!A8\"))","v":"2100mm"},null,{"$f":"IF(INDIRECT(\"sheet2!C7\")=0,\"\",INDIRECT(\"sheet2!C7\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D7\")=0,\"\",INDIRECT(\"sheet2!D7\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E7\")=0,\"\",INDIRECT(\"sheet2!E7\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F7\")=0,\"\",INDIRECT(\"sheet2!F7\"))","v":""}]
[null,{"$f":"Sheet4!Z8","v":""},{"$f":"Sheet4!AA8","v":""},{"$f":"Sheet4!AB8","v":""},null,null,null,null,{"$f":"IF(INDIRECT(\"sheet2!C8\")=0,\"\",INDIRECT(\"sheet2!C8\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D8\")=0,\"\",INDIRECT(\"sheet2!D8\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E8\")=0,\"\",INDIRECT(\"sheet2!E8\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F8\")=0,\"\",INDIRECT(\"sheet2!F8\"))","v":""}]
[null,{"$f":"Sheet4!Z9","v":""},{"$f":"Sheet4!AA9","v":""},{"$f":"Sheet4!AB9","v":""},null,null,null,null,{"$f":"IF(INDIRECT(\"sheet2!C9\")=0,\"\",INDIRECT(\"sheet2!C9\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D9\")=0,\"\",INDIRECT(\"sheet2!D9\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E9\")=0,\"\",INDIRECT(\"sheet2!E9\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F9\")=0,\"\",INDIRECT(\"sheet2!F9\"))","v":""}]
[null,{"$f":"Sheet4!Z10","v":""},{"$f":"Sheet4!AA10","v":""},{"$f":"Sheet4!AB10","v":""},null,null,null,null,{"$f":"IF(INDIRECT(\"sheet2!C10\")=0,\"\",INDIRECT(\"sheet2!C10\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D10\")=0,\"\",INDIRECT(\"sheet2!D10\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E10\")=0,\"\",INDIRECT(\"sheet2!E10\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F10\")=0,\"\",INDIRECT(\"sheet2!F10\"))","v":""}]
[null,{"$f":"Sheet4!Z11","v":""},{"$f":"Sheet4!AA11","v":""},{"$f":"Sheet4!AB11","v":""},null,{"$f":"IF(G18=\"\",\"\",\"Quantity\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A12\")=0,\"\",INDIRECT(\"sheet2!A12\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C12\")=0,\"\",INDIRECT(\"sheet2!C11\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D12\")=0,\"\",INDIRECT(\"sheet2!D11\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E12\")=0,\"\",INDIRECT(\"sheet2!E11\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F12\")=0,\"\",INDIRECT(\"sheet2!F11\"))","v":""}]
[null,{"$f":"Sheet4!Z12","v":""},{"$f":"Sheet4!AA12","v":""},{"$f":"Sheet4!AB12","v":""},null,{"$f":"IF(G19=\"\",\"\",\"Lock Centre Line\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A13\")=0,\"\",INDIRECT(\"sheet2!A13\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C12\")=0,\"\",INDIRECT(\"sheet2!C12\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D12\")=0,\"\",INDIRECT(\"sheet2!D12\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E12\")=0,\"\",INDIRECT(\"sheet2!E12\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F12\")=0,\"\",INDIRECT(\"sheet2!F12\"))","v":""}]
[null,{"$f":"Sheet4!Z13","v":""},{"$f":"Sheet4!AA13","v":""},{"$f":"Sheet4!AB13","v":""},null,{"$f":"IF(G20=\"\",\"\",\"Slave Backset\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A14\")=0,\"\",INDIRECT(\"sheet2!A14\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C13\")=0,\"\",INDIRECT(\"sheet2!C13\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D13\")=0,\"\",INDIRECT(\"sheet2!D13\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E13\")=0,\"\",INDIRECT(\"sheet2!E13\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F13\")=0,\"\",INDIRECT(\"sheet2!F13\"))","v":""}]
[null,{"$f":"Sheet4!Z14","v":""},{"$f":"Sheet4!AA14","v":""},{"$f":"Sheet4!AB14","v":""},null,{"$f":"IF(G21=\"\",\"\",\"Handing\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A15\")=0,\"\",INDIRECT(\"sheet2!A15\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C14\")=0,\"\",INDIRECT(\"sheet2!C14\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D14\")=0,\"\",INDIRECT(\"sheet2!D14\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E14\")=0,\"\",INDIRECT(\"sheet2!E14\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F14\")=0,\"\",INDIRECT(\"sheet2!F14\"))","v":""}]
[null,{"$f":"Sheet4!Z15","v":""},{"$f":"Sheet4!AA15","v":""},{"$f":"Sheet4!AB15","v":""},null,{"$f":"IF(G22=\"\",\"\",\"Shootbolt Options\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A16\")=0,\"\",INDIRECT(\"sheet2!A16\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C15\")=0,\"\",INDIRECT(\"sheet2!C15\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D15\")=0,\"\",INDIRECT(\"sheet2!D15\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E15\")=0,\"\",INDIRECT(\"sheet2!E15\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F15\")=0,\"\",INDIRECT(\"sheet2!F15\"))","v":""}]
[null,{"$f":"Sheet4!Z16","v":""},{"$f":"Sheet4!AA16","v":""},{"$f":"Sheet4!AB16","v":""},null,{"$f":"IF(G23=\"\",\"\",\"Handle Height\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A17\")=0,\"\",INDIRECT(\"sheet2!A17\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C16\")=0,\"\",INDIRECT(\"sheet2!C16\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D16\")=0,\"\",INDIRECT(\"sheet2!D16\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E16\")=0,\"\",INDIRECT(\"sheet2!E16\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F16\")=0,\"\",INDIRECT(\"sheet2!F16\"))","v":""}]
[null,{"$f":"Sheet4!Z17","v":""},{"$f":"Sheet4!AA17","v":""},{"$f":"Sheet4!AB17","v":""},null,{"$f":"IF(G24=\"\",\"\",\"Door Rebate Height\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A18\")=0,\"\",INDIRECT(\"sheet2!A18\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C17\")=0,\"\",INDIRECT(\"sheet2!C17\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D17\")=0,\"\",INDIRECT(\"sheet2!D17\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E17\")=0,\"\",INDIRECT(\"sheet2!E17\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F17\")=0,\"\",INDIRECT(\"sheet2!F17\"))","v":""}]
[null,{"$f":"Sheet4!Z18","v":""},{"$f":"Sheet4!AA18","v":""},{"$f":"Sheet4!AB18","v":""},null,null,null,null,{"$f":"IF(INDIRECT(\"sheet2!C18\")=0,\"\",INDIRECT(\"sheet2!C18\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D18\")=0,\"\",INDIRECT(\"sheet2!D18\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E18\")=0,\"\",INDIRECT(\"sheet2!E18\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F18\")=0,\"\",INDIRECT(\"sheet2!F18\"))","v":""}]
[null,{"$f":"Sheet4!Z19","v":""},{"$f":"Sheet4!AA19","v":""},{"$f":"Sheet4!AB19","v":""},null,null,null,null,{"$f":"IF(INDIRECT(\"sheet2!C19\")=0,\"\",INDIRECT(\"sheet2!C19\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D19\")=0,\"\",INDIRECT(\"sheet2!D19\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E19\")=0,\"\",INDIRECT(\"sheet2!E19\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F19\")=0,\"\",INDIRECT(\"sheet2!F19\"))","v":""}]
[null,{"$f":"Sheet4!Z20","v":""},{"$f":"Sheet4!AA20","v":""},{"$f":"Sheet4!AB20","v":""},null,null,null,null,{"$f":"IF(INDIRECT(\"sheet2!C20\")=0,\"\",INDIRECT(\"sheet2!C20\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D20\")=0,\"\",INDIRECT(\"sheet2!D20\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E20\")=0,\"\",INDIRECT(\"sheet2!E20\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F20\")=0,\"\",INDIRECT(\"sheet2!F20\"))","v":""}]
[null,{"$f":"Sheet4!Z21","v":""},{"$f":"Sheet4!AA21","v":""},{"$f":"Sheet4!AB21","v":""},null,{"$f":"IF(G28=\"\",\"\",\"Quantity\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A22\")=0,\"\",INDIRECT(\"sheet2!A22\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C22\")=0,\"\",INDIRECT(\"sheet2!C21\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D22\")=0,\"\",INDIRECT(\"sheet2!D21\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E22\")=0,\"\",INDIRECT(\"sheet2!E21\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F22\")=0,\"\",INDIRECT(\"sheet2!F21\"))","v":""}]
[null,{"$f":"Sheet4!Z22","v":""},{"$f":"Sheet4!AA22","v":""},{"$f":"Sheet4!AB22","v":""},null,{"$f":"IF(G29=\"\",\"\",\"Lock Centre Line\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A23\")=0,\"\",INDIRECT(\"sheet2!A23\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C22\")=0,\"\",INDIRECT(\"sheet2!C22\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D22\")=0,\"\",INDIRECT(\"sheet2!D22\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E22\")=0,\"\",INDIRECT(\"sheet2!E22\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F22\")=0,\"\",INDIRECT(\"sheet2!F22\"))","v":""}]
[null,{"$f":"Sheet4!Z23","v":""},{"$f":"Sheet4!AA23","v":""},{"$f":"Sheet4!AB23","v":""},null,{"$f":"IF(G30=\"\",\"\",\"Slave Backset\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A24\")=0,\"\",INDIRECT(\"sheet2!A24\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C23\")=0,\"\",INDIRECT(\"sheet2!C23\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D23\")=0,\"\",INDIRECT(\"sheet2!D23\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E23\")=0,\"\",INDIRECT(\"sheet2!E23\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F23\")=0,\"\",INDIRECT(\"sheet2!F23\"))","v":""}]
[null,{"$f":"Sheet4!Z24","v":""},{"$f":"Sheet4!AA24","v":""},{"$f":"Sheet4!AB24","v":""},null,{"$f":"IF(G31=\"\",\"\",\"Handing\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A25\")=0,\"\",INDIRECT(\"sheet2!A25\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C24\")=0,\"\",INDIRECT(\"sheet2!C24\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D24\")=0,\"\",INDIRECT(\"sheet2!D24\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E24\")=0,\"\",INDIRECT(\"sheet2!E24\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F24\")=0,\"\",INDIRECT(\"sheet2!F24\"))","v":""}]
[null,{"$f":"Sheet4!Z25","v":""},{"$f":"Sheet4!AA25","v":""},{"$f":"Sheet4!AB25","v":""},null,{"$f":"IF(G32=\"\",\"\",\"Shootbolt Options\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A26\")=0,\"\",INDIRECT(\"sheet2!A26\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C25\")=0,\"\",INDIRECT(\"sheet2!C25\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D25\")=0,\"\",INDIRECT(\"sheet2!D25\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E25\")=0,\"\",INDIRECT(\"sheet2!E25\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F25\")=0,\"\",INDIRECT(\"sheet2!F25\"))","v":""}]
[null,{"$f":"Sheet4!Z26","v":""},{"$f":"Sheet4!AA26","v":""},{"$f":"Sheet4!AB26","v":""},null,{"$f":"IF(G33=\"\",\"\",\"Handle Height\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A27\")=0,\"\",INDIRECT(\"sheet2!A27\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C26\")=0,\"\",INDIRECT(\"sheet2!C26\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D26\")=0,\"\",INDIRECT(\"sheet2!D26\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E26\")=0,\"\",INDIRECT(\"sheet2!E26\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F26\")=0,\"\",INDIRECT(\"sheet2!F26\"))","v":""}]
[null,{"$f":"Sheet4!Z27","v":""},{"$f":"Sheet4!AA27","v":""},{"$f":"Sheet4!AB27","v":""},null,{"$f":"IF(G34=\"\",\"\",\"Door Rebate Height\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A28\")=0,\"\",INDIRECT(\"sheet2!A28\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C27\")=0,\"\",INDIRECT(\"sheet2!C27\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D27\")=0,\"\",INDIRECT(\"sheet2!D27\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E27\")=0,\"\",INDIRECT(\"sheet2!E27\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F27\")=0,\"\",INDIRECT(\"sheet2!F27\"))","v":""}]
[null,{"$f":"Sheet4!Z28","v":""},{"$f":"Sheet4!AA28","v":""},{"$f":"Sheet4!AB28","v":""},null,null,null,null,{"$f":"IF(INDIRECT(\"sheet2!C28\")=0,\"\",INDIRECT(\"sheet2!C28\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D28\")=0,\"\",INDIRECT(\"sheet2!D28\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E28\")=0,\"\",INDIRECT(\"sheet2!E28\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F28\")=0,\"\",INDIRECT(\"sheet2!F28\"))","v":""}]
[null,{"$f":"Sheet4!Z29","v":""},{"$f":"Sheet4!AA29","v":""},{"$f":"Sheet4!AB29","v":""},null,null,null,null,{"$f":"IF(INDIRECT(\"sheet2!C29\")=0,\"\",INDIRECT(\"sheet2!C29\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D29\")=0,\"\",INDIRECT(\"sheet2!D29\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E29\")=0,\"\",INDIRECT(\"sheet2!E29\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F29\")=0,\"\",INDIRECT(\"sheet2!F29\"))","v":""}]
[null,{"$f":"Sheet4!Z30","v":""},{"$f":"Sheet4!AA30","v":""},{"$f":"Sheet4!AB30","v":""},null,null,null,null,{"$f":"IF(INDIRECT(\"sheet2!C30\")=0,\"\",INDIRECT(\"sheet2!C30\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D30\")=0,\"\",INDIRECT(\"sheet2!D30\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E30\")=0,\"\",INDIRECT(\"sheet2!E30\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F30\")=0,\"\",INDIRECT(\"sheet2!F30\"))","v":""}]
[null,{"$f":"Sheet4!Z31","v":""},{"$f":"Sheet4!AA31","v":""},{"$f":"Sheet4!AB31","v":""},null,{"$f":"IF(G38=\"\",\"\",\"Quantity\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A32\")=0,\"\",INDIRECT(\"sheet2!A32\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C32\")=0,\"\",INDIRECT(\"sheet2!C31\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D32\")=0,\"\",INDIRECT(\"sheet2!D31\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E32\")=0,\"\",INDIRECT(\"sheet2!E31\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F32\")=0,\"\",INDIRECT(\"sheet2!F31\"))","v":""}]
[null,{"$f":"Sheet4!Z32","v":""},{"$f":"Sheet4!AA32","v":""},{"$f":"Sheet4!AB32","v":""},null,{"$f":"IF(G39=\"\",\"\",\"Lock Centre Line\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A33\")=0,\"\",INDIRECT(\"sheet2!A33\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C32\")=0,\"\",INDIRECT(\"sheet2!C32\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D32\")=0,\"\",INDIRECT(\"sheet2!D32\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E32\")=0,\"\",INDIRECT(\"sheet2!E32\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F32\")=0,\"\",INDIRECT(\"sheet2!F32\"))","v":""}]
[null,{"$f":"Sheet4!Z33","v":""},{"$f":"Sheet4!AA33","v":""},{"$f":"Sheet4!AB33","v":""},null,{"$f":"IF(G40=\"\",\"\",\"Slave Backset\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A34\")=0,\"\",INDIRECT(\"sheet2!A34\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C33\")=0,\"\",INDIRECT(\"sheet2!C33\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D33\")=0,\"\",INDIRECT(\"sheet2!D33\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E33\")=0,\"\",INDIRECT(\"sheet2!E33\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F33\")=0,\"\",INDIRECT(\"sheet2!F33\"))","v":""}]
[null,{"$f":"Sheet4!Z34","v":""},{"$f":"Sheet4!AA34","v":""},{"$f":"Sheet4!AB34","v":""},null,{"$f":"IF(G41=\"\",\"\",\"Handing\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A35\")=0,\"\",INDIRECT(\"sheet2!A35\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C34\")=0,\"\",INDIRECT(\"sheet2!C34\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D34\")=0,\"\",INDIRECT(\"sheet2!D34\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E34\")=0,\"\",INDIRECT(\"sheet2!E34\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F34\")=0,\"\",INDIRECT(\"sheet2!F34\"))","v":""}]
[null,{"$f":"Sheet4!Z35","v":""},{"$f":"Sheet4!AA35","v":""},{"$f":"Sheet4!AB35","v":""},null,{"$f":"IF(G42=\"\",\"\",\"Shootbolt Options\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A36\")=0,\"\",INDIRECT(\"sheet2!A36\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C35\")=0,\"\",INDIRECT(\"sheet2!C35\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D35\")=0,\"\",INDIRECT(\"sheet2!D35\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E35\")=0,\"\",INDIRECT(\"sheet2!E35\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F35\")=0,\"\",INDIRECT(\"sheet2!F35\"))","v":""}]
[null,{"$f":"Sheet4!Z36","v":""},{"$f":"Sheet4!AA36","v":""},{"$f":"Sheet4!AB36","v":""},null,{"$f":"IF(G43=\"\",\"\",\"Handle Height\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A37\")=0,\"\",INDIRECT(\"sheet2!A37\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C36\")=0,\"\",INDIRECT(\"sheet2!C36\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D36\")=0,\"\",INDIRECT(\"sheet2!D36\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E36\")=0,\"\",INDIRECT(\"sheet2!E36\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F36\")=0,\"\",INDIRECT(\"sheet2!F36\"))","v":""}]
[null,{"$f":"Sheet4!Z37","v":""},{"$f":"Sheet4!AA37","v":""},{"$f":"Sheet4!AB37","v":""},null,{"$f":"IF(G44=\"\",\"\",\"Door Rebate Height\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A38\")=0,\"\",INDIRECT(\"sheet2!A38\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C37\")=0,\"\",INDIRECT(\"sheet2!C37\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D37\")=0,\"\",INDIRECT(\"sheet2!D37\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E37\")=0,\"\",INDIRECT(\"sheet2!E37\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F37\")=0,\"\",INDIRECT(\"sheet2!F37\"))","v":""}]
[null,{"$f":"Sheet4!Z38","v":""},{"$f":"Sheet4!AA38","v":""},{"$f":"Sheet4!AB38","v":""},null,null,null,null,{"$f":"IF(INDIRECT(\"sheet2!C38\")=0,\"\",INDIRECT(\"sheet2!C38\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D38\")=0,\"\",INDIRECT(\"sheet2!D38\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E38\")=0,\"\",INDIRECT(\"sheet2!E38\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F38\")=0,\"\",INDIRECT(\"sheet2!F38\"))","v":""}]
[null,{"$f":"Sheet4!Z39","v":""},{"$f":"Sheet4!AA39","v":""},{"$f":"Sheet4!AB39","v":""},null,null,null,null,{"$f":"IF(INDIRECT(\"sheet2!C39\")=0,\"\",INDIRECT(\"sheet2!C39\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D39\")=0,\"\",INDIRECT(\"sheet2!D39\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E39\")=0,\"\",INDIRECT(\"sheet2!E39\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F39\")=0,\"\",INDIRECT(\"sheet2!F39\"))","v":""}]
[null,{"$f":"Sheet4!Z40","v":""},{"$f":"Sheet4!AA40","v":""},{"$f":"Sheet4!AB40","v":""},null,null,null,null,{"$f":"IF(INDIRECT(\"sheet2!C40\")=0,\"\",INDIRECT(\"sheet2!C40\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D40\")=0,\"\",INDIRECT(\"sheet2!D40\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E40\")=0,\"\",INDIRECT(\"sheet2!E40\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F40\")=0,\"\",INDIRECT(\"sheet2!F40\"))","v":""}]
[null,{"$f":"Sheet4!Z41","v":""},{"$f":"Sheet4!AA41","v":""},{"$f":"Sheet4!AB41","v":""},null,{"$f":"IF(G48=\"\",\"\",\"Quantity\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A42\")=0,\"\",INDIRECT(\"sheet2!A42\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C42\")=0,\"\",INDIRECT(\"sheet2!C41\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D42\")=0,\"\",INDIRECT(\"sheet2!D41\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E42\")=0,\"\",INDIRECT(\"sheet2!E41\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F42\")=0,\"\",INDIRECT(\"sheet2!F41\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G49=\"\",\"\",\"Lock Centre Line\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A43\")=0,\"\",INDIRECT(\"sheet2!A43\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C42\")=0,\"\",INDIRECT(\"sheet2!C42\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D42\")=0,\"\",INDIRECT(\"sheet2!D42\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E42\")=0,\"\",INDIRECT(\"sheet2!E42\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F42\")=0,\"\",INDIRECT(\"sheet2!F42\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G50=\"\",\"\",\"Slave Backset\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A44\")=0,\"\",INDIRECT(\"sheet2!A44\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C43\")=0,\"\",INDIRECT(\"sheet2!C43\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D43\")=0,\"\",INDIRECT(\"sheet2!D43\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E43\")=0,\"\",INDIRECT(\"sheet2!E43\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F43\")=0,\"\",INDIRECT(\"sheet2!F43\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G51=\"\",\"\",\"Handing\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A45\")=0,\"\",INDIRECT(\"sheet2!A45\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C44\")=0,\"\",INDIRECT(\"sheet2!C44\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D44\")=0,\"\",INDIRECT(\"sheet2!D44\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E44\")=0,\"\",INDIRECT(\"sheet2!E44\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F44\")=0,\"\",INDIRECT(\"sheet2!F44\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G52=\"\",\"\",\"Shootbolt Options\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A46\")=0,\"\",INDIRECT(\"sheet2!A46\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C45\")=0,\"\",INDIRECT(\"sheet2!C45\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D45\")=0,\"\",INDIRECT(\"sheet2!D45\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E45\")=0,\"\",INDIRECT(\"sheet2!E45\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F45\")=0,\"\",INDIRECT(\"sheet2!F45\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G53=\"\",\"\",\"Handle Height\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A47\")=0,\"\",INDIRECT(\"sheet2!A47\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C46\")=0,\"\",INDIRECT(\"sheet2!C46\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D46\")=0,\"\",INDIRECT(\"sheet2!D46\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E46\")=0,\"\",INDIRECT(\"sheet2!E46\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F46\")=0,\"\",INDIRECT(\"sheet2!F46\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G54=\"\",\"\",\"Door Rebate Height\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A48\")=0,\"\",INDIRECT(\"sheet2!A48\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C47\")=0,\"\",INDIRECT(\"sheet2!C47\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D47\")=0,\"\",INDIRECT(\"sheet2!D47\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E47\")=0,\"\",INDIRECT(\"sheet2!E47\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F47\")=0,\"\",INDIRECT(\"sheet2!F47\"))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(INDIRECT(\"sheet2!C48\")=0,\"\",INDIRECT(\"sheet2!C48\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D48\")=0,\"\",INDIRECT(\"sheet2!D48\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E48\")=0,\"\",INDIRECT(\"sheet2!E48\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F48\")=0,\"\",INDIRECT(\"sheet2!F48\"))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(INDIRECT(\"sheet2!C49\")=0,\"\",INDIRECT(\"sheet2!C49\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D49\")=0,\"\",INDIRECT(\"sheet2!D49\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E49\")=0,\"\",INDIRECT(\"sheet2!E49\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F49\")=0,\"\",INDIRECT(\"sheet2!F49\"))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(INDIRECT(\"sheet2!C50\")=0,\"\",INDIRECT(\"sheet2!C50\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D50\")=0,\"\",INDIRECT(\"sheet2!D50\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E50\")=0,\"\",INDIRECT(\"sheet2!E50\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F50\")=0,\"\",INDIRECT(\"sheet2!F50\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G58=\"\",\"\",\"Quantity\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A52\")=0,\"\",INDIRECT(\"sheet2!A52\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C52\")=0,\"\",INDIRECT(\"sheet2!C51\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D52\")=0,\"\",INDIRECT(\"sheet2!D51\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E52\")=0,\"\",INDIRECT(\"sheet2!E51\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F52\")=0,\"\",INDIRECT(\"sheet2!F51\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G59=\"\",\"\",\"Lock Centre Line\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A53\")=0,\"\",INDIRECT(\"sheet2!A53\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C52\")=0,\"\",INDIRECT(\"sheet2!C52\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D52\")=0,\"\",INDIRECT(\"sheet2!D52\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E52\")=0,\"\",INDIRECT(\"sheet2!E52\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F52\")=0,\"\",INDIRECT(\"sheet2!F52\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G60=\"\",\"\",\"Slave Backset\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A54\")=0,\"\",INDIRECT(\"sheet2!A54\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C53\")=0,\"\",INDIRECT(\"sheet2!C53\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D53\")=0,\"\",INDIRECT(\"sheet2!D53\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E53\")=0,\"\",INDIRECT(\"sheet2!E53\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F53\")=0,\"\",INDIRECT(\"sheet2!F53\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G61=\"\",\"\",\"Handing\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A55\")=0,\"\",INDIRECT(\"sheet2!A55\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C54\")=0,\"\",INDIRECT(\"sheet2!C54\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D54\")=0,\"\",INDIRECT(\"sheet2!D54\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E54\")=0,\"\",INDIRECT(\"sheet2!E54\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F54\")=0,\"\",INDIRECT(\"sheet2!F54\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G62=\"\",\"\",\"Shootbolt Options\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A56\")=0,\"\",INDIRECT(\"sheet2!A56\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C55\")=0,\"\",INDIRECT(\"sheet2!C55\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D55\")=0,\"\",INDIRECT(\"sheet2!D55\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E55\")=0,\"\",INDIRECT(\"sheet2!E55\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F55\")=0,\"\",INDIRECT(\"sheet2!F55\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G63=\"\",\"\",\"Handle Height\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A57\")=0,\"\",INDIRECT(\"sheet2!A57\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C56\")=0,\"\",INDIRECT(\"sheet2!C56\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D56\")=0,\"\",INDIRECT(\"sheet2!D56\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E56\")=0,\"\",INDIRECT(\"sheet2!E56\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F56\")=0,\"\",INDIRECT(\"sheet2!F56\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G64=\"\",\"\",\"Door Rebate Height\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A58\")=0,\"\",INDIRECT(\"sheet2!A58\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C57\")=0,\"\",INDIRECT(\"sheet2!C57\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D57\")=0,\"\",INDIRECT(\"sheet2!D57\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E57\")=0,\"\",INDIRECT(\"sheet2!E57\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F57\")=0,\"\",INDIRECT(\"sheet2!F57\"))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(INDIRECT(\"sheet2!C58\")=0,\"\",INDIRECT(\"sheet2!C58\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D58\")=0,\"\",INDIRECT(\"sheet2!D58\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E58\")=0,\"\",INDIRECT(\"sheet2!E58\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F58\")=0,\"\",INDIRECT(\"sheet2!F58\"))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(INDIRECT(\"sheet2!C59\")=0,\"\",INDIRECT(\"sheet2!C59\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D59\")=0,\"\",INDIRECT(\"sheet2!D59\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E59\")=0,\"\",INDIRECT(\"sheet2!E59\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F59\")=0,\"\",INDIRECT(\"sheet2!F59\"))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(INDIRECT(\"sheet2!C60\")=0,\"\",INDIRECT(\"sheet2!C60\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D60\")=0,\"\",INDIRECT(\"sheet2!D60\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E60\")=0,\"\",INDIRECT(\"sheet2!E60\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F60\")=0,\"\",INDIRECT(\"sheet2!F60\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G68=\"\",\"\",\"Quantity\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A62\")=0,\"\",INDIRECT(\"sheet2!A62\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C62\")=0,\"\",INDIRECT(\"sheet2!C61\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D62\")=0,\"\",INDIRECT(\"sheet2!D61\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E62\")=0,\"\",INDIRECT(\"sheet2!E61\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F62\")=0,\"\",INDIRECT(\"sheet2!F61\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G69=\"\",\"\",\"Lock Centre Line\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A63\")=0,\"\",INDIRECT(\"sheet2!A63\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C62\")=0,\"\",INDIRECT(\"sheet2!C62\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D62\")=0,\"\",INDIRECT(\"sheet2!D62\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E62\")=0,\"\",INDIRECT(\"sheet2!E62\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F62\")=0,\"\",INDIRECT(\"sheet2!F62\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G70=\"\",\"\",\"Slave Backset\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A64\")=0,\"\",INDIRECT(\"sheet2!A64\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C63\")=0,\"\",INDIRECT(\"sheet2!C63\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D63\")=0,\"\",INDIRECT(\"sheet2!D63\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E63\")=0,\"\",INDIRECT(\"sheet2!E63\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F63\")=0,\"\",INDIRECT(\"sheet2!F63\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G71=\"\",\"\",\"Handing\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A65\")=0,\"\",INDIRECT(\"sheet2!A65\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C64\")=0,\"\",INDIRECT(\"sheet2!C64\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D64\")=0,\"\",INDIRECT(\"sheet2!D64\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E64\")=0,\"\",INDIRECT(\"sheet2!E64\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F64\")=0,\"\",INDIRECT(\"sheet2!F64\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G72=\"\",\"\",\"Shootbolt Options\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A66\")=0,\"\",INDIRECT(\"sheet2!A66\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C65\")=0,\"\",INDIRECT(\"sheet2!C65\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D65\")=0,\"\",INDIRECT(\"sheet2!D65\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E65\")=0,\"\",INDIRECT(\"sheet2!E65\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F65\")=0,\"\",INDIRECT(\"sheet2!F65\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G73=\"\",\"\",\"Handle Height\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A67\")=0,\"\",INDIRECT(\"sheet2!A67\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C66\")=0,\"\",INDIRECT(\"sheet2!C66\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D66\")=0,\"\",INDIRECT(\"sheet2!D66\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E66\")=0,\"\",INDIRECT(\"sheet2!E66\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F66\")=0,\"\",INDIRECT(\"sheet2!F66\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G74=\"\",\"\",\"Door Rebate Height\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A68\")=0,\"\",INDIRECT(\"sheet2!A68\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C67\")=0,\"\",INDIRECT(\"sheet2!C67\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D67\")=0,\"\",INDIRECT(\"sheet2!D67\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E67\")=0,\"\",INDIRECT(\"sheet2!E67\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F67\")=0,\"\",INDIRECT(\"sheet2!F67\"))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(INDIRECT(\"sheet2!C68\")=0,\"\",INDIRECT(\"sheet2!C68\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D68\")=0,\"\",INDIRECT(\"sheet2!D68\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E68\")=0,\"\",INDIRECT(\"sheet2!E68\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F68\")=0,\"\",INDIRECT(\"sheet2!F68\"))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(INDIRECT(\"sheet2!C69\")=0,\"\",INDIRECT(\"sheet2!C69\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D69\")=0,\"\",INDIRECT(\"sheet2!D69\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E69\")=0,\"\",INDIRECT(\"sheet2!E69\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F69\")=0,\"\",INDIRECT(\"sheet2!F69\"))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(INDIRECT(\"sheet2!C70\")=0,\"\",INDIRECT(\"sheet2!C70\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D70\")=0,\"\",INDIRECT(\"sheet2!D70\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E70\")=0,\"\",INDIRECT(\"sheet2!E70\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F70\")=0,\"\",INDIRECT(\"sheet2!F70\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G78=\"\",\"\",\"Quantity\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A72\")=0,\"\",INDIRECT(\"sheet2!A72\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C72\")=0,\"\",INDIRECT(\"sheet2!C71\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D72\")=0,\"\",INDIRECT(\"sheet2!D71\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E72\")=0,\"\",INDIRECT(\"sheet2!E71\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F72\")=0,\"\",INDIRECT(\"sheet2!F71\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G79=\"\",\"\",\"Lock Centre Line\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A73\")=0,\"\",INDIRECT(\"sheet2!A73\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C72\")=0,\"\",INDIRECT(\"sheet2!C72\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D72\")=0,\"\",INDIRECT(\"sheet2!D72\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E72\")=0,\"\",INDIRECT(\"sheet2!E72\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F72\")=0,\"\",INDIRECT(\"sheet2!F72\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G80=\"\",\"\",\"Slave Backset\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A74\")=0,\"\",INDIRECT(\"sheet2!A74\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C73\")=0,\"\",INDIRECT(\"sheet2!C73\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D73\")=0,\"\",INDIRECT(\"sheet2!D73\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E73\")=0,\"\",INDIRECT(\"sheet2!E73\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F73\")=0,\"\",INDIRECT(\"sheet2!F73\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G81=\"\",\"\",\"Handing\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A75\")=0,\"\",INDIRECT(\"sheet2!A75\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C74\")=0,\"\",INDIRECT(\"sheet2!C74\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D74\")=0,\"\",INDIRECT(\"sheet2!D74\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E74\")=0,\"\",INDIRECT(\"sheet2!E74\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F74\")=0,\"\",INDIRECT(\"sheet2!F74\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G82=\"\",\"\",\"Shootbolt Options\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A76\")=0,\"\",INDIRECT(\"sheet2!A76\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C75\")=0,\"\",INDIRECT(\"sheet2!C75\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D75\")=0,\"\",INDIRECT(\"sheet2!D75\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E75\")=0,\"\",INDIRECT(\"sheet2!E75\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F75\")=0,\"\",INDIRECT(\"sheet2!F75\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G83=\"\",\"\",\"Handle Height\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A77\")=0,\"\",INDIRECT(\"sheet2!A77\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C76\")=0,\"\",INDIRECT(\"sheet2!C76\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D76\")=0,\"\",INDIRECT(\"sheet2!D76\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E76\")=0,\"\",INDIRECT(\"sheet2!E76\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F76\")=0,\"\",INDIRECT(\"sheet2!F76\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G84=\"\",\"\",\"Door Rebate Height\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A78\")=0,\"\",INDIRECT(\"sheet2!A78\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C77\")=0,\"\",INDIRECT(\"sheet2!C77\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D77\")=0,\"\",INDIRECT(\"sheet2!D77\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E77\")=0,\"\",INDIRECT(\"sheet2!E77\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F77\")=0,\"\",INDIRECT(\"sheet2!F77\"))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(INDIRECT(\"sheet2!C78\")=0,\"\",INDIRECT(\"sheet2!C78\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D78\")=0,\"\",INDIRECT(\"sheet2!D78\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E78\")=0,\"\",INDIRECT(\"sheet2!E78\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F78\")=0,\"\",INDIRECT(\"sheet2!F78\"))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(INDIRECT(\"sheet2!C79\")=0,\"\",INDIRECT(\"sheet2!C79\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D79\")=0,\"\",INDIRECT(\"sheet2!D79\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E79\")=0,\"\",INDIRECT(\"sheet2!E79\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F79\")=0,\"\",INDIRECT(\"sheet2!F79\"))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(INDIRECT(\"sheet2!C80\")=0,\"\",INDIRECT(\"sheet2!C80\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D80\")=0,\"\",INDIRECT(\"sheet2!D80\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E80\")=0,\"\",INDIRECT(\"sheet2!E80\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F80\")=0,\"\",INDIRECT(\"sheet2!F80\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G88=\"\",\"\",\"Quantity\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A82\")=0,\"\",INDIRECT(\"sheet2!A82\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C82\")=0,\"\",INDIRECT(\"sheet2!C81\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D82\")=0,\"\",INDIRECT(\"sheet2!D81\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E82\")=0,\"\",INDIRECT(\"sheet2!E81\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F82\")=0,\"\",INDIRECT(\"sheet2!F81\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G89=\"\",\"\",\"Lock Centre Line\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A83\")=0,\"\",INDIRECT(\"sheet2!A83\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C82\")=0,\"\",INDIRECT(\"sheet2!C82\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D82\")=0,\"\",INDIRECT(\"sheet2!D82\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E82\")=0,\"\",INDIRECT(\"sheet2!E82\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F82\")=0,\"\",INDIRECT(\"sheet2!F82\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G90=\"\",\"\",\"Slave Backset\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A84\")=0,\"\",INDIRECT(\"sheet2!A84\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C83\")=0,\"\",INDIRECT(\"sheet2!C83\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D83\")=0,\"\",INDIRECT(\"sheet2!D83\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E83\")=0,\"\",INDIRECT(\"sheet2!E83\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F83\")=0,\"\",INDIRECT(\"sheet2!F83\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G91=\"\",\"\",\"Handing\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A85\")=0,\"\",INDIRECT(\"sheet2!A85\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C84\")=0,\"\",INDIRECT(\"sheet2!C84\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D84\")=0,\"\",INDIRECT(\"sheet2!D84\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E84\")=0,\"\",INDIRECT(\"sheet2!E84\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F84\")=0,\"\",INDIRECT(\"sheet2!F84\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G92=\"\",\"\",\"Shootbolt Options\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A86\")=0,\"\",INDIRECT(\"sheet2!A86\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C85\")=0,\"\",INDIRECT(\"sheet2!C85\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D85\")=0,\"\",INDIRECT(\"sheet2!D85\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E85\")=0,\"\",INDIRECT(\"sheet2!E85\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F85\")=0,\"\",INDIRECT(\"sheet2!F85\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G93=\"\",\"\",\"Handle Height\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A87\")=0,\"\",INDIRECT(\"sheet2!A87\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C86\")=0,\"\",INDIRECT(\"sheet2!C86\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D86\")=0,\"\",INDIRECT(\"sheet2!D86\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E86\")=0,\"\",INDIRECT(\"sheet2!E86\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F86\")=0,\"\",INDIRECT(\"sheet2!F86\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G94=\"\",\"\",\"Door Rebate Height\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A88\")=0,\"\",INDIRECT(\"sheet2!A88\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C87\")=0,\"\",INDIRECT(\"sheet2!C87\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D87\")=0,\"\",INDIRECT(\"sheet2!D87\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E87\")=0,\"\",INDIRECT(\"sheet2!E87\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F87\")=0,\"\",INDIRECT(\"sheet2!F87\"))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(INDIRECT(\"sheet2!C88\")=0,\"\",INDIRECT(\"sheet2!C88\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D88\")=0,\"\",INDIRECT(\"sheet2!D88\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E88\")=0,\"\",INDIRECT(\"sheet2!E88\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F88\")=0,\"\",INDIRECT(\"sheet2!F88\"))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(INDIRECT(\"sheet2!C89\")=0,\"\",INDIRECT(\"sheet2!C89\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D89\")=0,\"\",INDIRECT(\"sheet2!D89\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E89\")=0,\"\",INDIRECT(\"sheet2!E89\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F89\")=0,\"\",INDIRECT(\"sheet2!F89\"))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(INDIRECT(\"sheet2!C90\")=0,\"\",INDIRECT(\"sheet2!C90\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D90\")=0,\"\",INDIRECT(\"sheet2!D90\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E90\")=0,\"\",INDIRECT(\"sheet2!E90\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F90\")=0,\"\",INDIRECT(\"sheet2!F90\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G98=\"\",\"\",\"Quantity\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A92\")=0,\"\",INDIRECT(\"sheet2!A92\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C92\")=0,\"\",INDIRECT(\"sheet2!C91\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D92\")=0,\"\",INDIRECT(\"sheet2!D91\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E92\")=0,\"\",INDIRECT(\"sheet2!E91\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F92\")=0,\"\",INDIRECT(\"sheet2!F91\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G99=\"\",\"\",\"Lock Centre Line\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A93\")=0,\"\",INDIRECT(\"sheet2!A93\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C92\")=0,\"\",INDIRECT(\"sheet2!C92\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D92\")=0,\"\",INDIRECT(\"sheet2!D92\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E92\")=0,\"\",INDIRECT(\"sheet2!E92\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F92\")=0,\"\",INDIRECT(\"sheet2!F92\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G100=\"\",\"\",\"Slave Backset\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A94\")=0,\"\",INDIRECT(\"sheet2!A94\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C93\")=0,\"\",INDIRECT(\"sheet2!C93\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D93\")=0,\"\",INDIRECT(\"sheet2!D93\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E93\")=0,\"\",INDIRECT(\"sheet2!E93\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F93\")=0,\"\",INDIRECT(\"sheet2!F93\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G101=\"\",\"\",\"Handing\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A95\")=0,\"\",INDIRECT(\"sheet2!A95\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C94\")=0,\"\",INDIRECT(\"sheet2!C94\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D94\")=0,\"\",INDIRECT(\"sheet2!D94\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E94\")=0,\"\",INDIRECT(\"sheet2!E94\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F94\")=0,\"\",INDIRECT(\"sheet2!F94\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G102=\"\",\"\",\"Shootbolt Options\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A96\")=0,\"\",INDIRECT(\"sheet2!A96\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C95\")=0,\"\",INDIRECT(\"sheet2!C95\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D95\")=0,\"\",INDIRECT(\"sheet2!D95\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E95\")=0,\"\",INDIRECT(\"sheet2!E95\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F95\")=0,\"\",INDIRECT(\"sheet2!F95\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G103=\"\",\"\",\"Handle Height\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A97\")=0,\"\",INDIRECT(\"sheet2!A97\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C96\")=0,\"\",INDIRECT(\"sheet2!C96\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D96\")=0,\"\",INDIRECT(\"sheet2!D96\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E96\")=0,\"\",INDIRECT(\"sheet2!E96\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F96\")=0,\"\",INDIRECT(\"sheet2!F96\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(G104=\"\",\"\",\"Door Rebate Height\")","v":""},{"$f":"IF(INDIRECT(\"sheet2!A98\")=0,\"\",INDIRECT(\"sheet2!A98\"))","v":""},null,{"$f":"IF(INDIRECT(\"sheet2!C97\")=0,\"\",INDIRECT(\"sheet2!C97\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D97\")=0,\"\",INDIRECT(\"sheet2!D97\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E97\")=0,\"\",INDIRECT(\"sheet2!E97\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F97\")=0,\"\",INDIRECT(\"sheet2!F97\"))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(INDIRECT(\"sheet2!C98\")=0,\"\",INDIRECT(\"sheet2!C98\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D98\")=0,\"\",INDIRECT(\"sheet2!D98\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E98\")=0,\"\",INDIRECT(\"sheet2!E98\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F98\")=0,\"\",INDIRECT(\"sheet2!F98\"))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(INDIRECT(\"sheet2!C99\")=0,\"\",INDIRECT(\"sheet2!C99\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D99\")=0,\"\",INDIRECT(\"sheet2!D99\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E99\")=0,\"\",INDIRECT(\"sheet2!E99\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F99\")=0,\"\",INDIRECT(\"sheet2!F99\"))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(INDIRECT(\"sheet2!C100\")=0,\"\",INDIRECT(\"sheet2!C100\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!D100\")=0,\"\",INDIRECT(\"sheet2!D100\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!E100\")=0,\"\",INDIRECT(\"sheet2!E100\"))","v":""},{"$f":"IF(INDIRECT(\"sheet2!F100\")=0,\"\",INDIRECT(\"sheet2!F100\"))","v":""}]

{"sheet":"Export","index":6,"n_rows":107,"n_cols":12,"rows_kept":107,"cut":false,"hidden":true,"merged":[]}
[null,"FGTE Configurator (Oct 2014).xlsm"]
[]
[]
[]
[]
[null,"TOTAL ORDER QUANTITY",null,null,null,"ITEMISED PARTS"]
[]
[null,"Part Number","Description","Total Qty",null,"Quantity",1,null,"Part Number","Description","Qty Per Door Set","Total Qty"]
[null,2933744,"F24 FGTE Shootbolt Keep Radius End",2,null,"Lock Centre Line","22mm",null,5016084,"MASTER FGTE LOCK THUNDERBOLT F20/45",1,1]
[null,5016084,"MASTER FGTE LOCK THUNDERBOLT F20/45",1,null,"Slave Backset","45mm",null,5013845,"STV-FGTE Slave 2062-908/45 92/8 RH",1,1]
[null,2500480,"STV-A 175 Shootbolt",1,null,"Handing","RH",null,2500480,"STV-A 175 Shootbolt",1,1]
[null,2930754,"STV-A 372 Shootbolt",1,null,"Shootbolt Options","Slave Only",null,2930754,"STV-A 372 Shootbolt",1,1]
[null,5013845,"STV-FGTE Slave 2062-908/45 92/8 RH",1,null,"Handle Height","1050mm",null,2933744,"F24 FGTE Shootbolt Keep Radius End",2,2]
[null,"","","",null,"Door Rebate Height","2100mm",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,"","","",""]
[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,"","","",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,"","",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,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,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,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,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,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,"","",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,"","","",""]