{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Interface","Parameters","Backsets","Installation","Drawing"],"not_rendered":{"charts":0,"images":20,"macros":1,"external_links":0,"defined_names":117,"comments":2,"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":"Interface","index":0,"n_rows":45,"n_cols":53,"rows_kept":45,"cut":false,"hidden":false,"merged":[[24,41,24,42],[6,25,7,28],[0,12,3,38],[24,25,24,27],[16,32,17,34],[14,32,15,34],[4,25,5,27],[16,25,17,31],[10,32,11,34],[14,7,15,14],[14,20,15,24],[16,20,17,24],[8,47,9,51],[10,25,11,31],[4,22,5,24],[8,40,9,46],[6,20,7,24],[10,20,11,24],[10,15,11,19],[12,25,13,31],[12,7,13,14],[6,47,7,51],[0,39,5,51],[6,32,7,35],[6,36,7,39],[6,40,7,46],[6,29,7,31],[8,20,9,24],[8,29,9,31],[8,36,9,39],[8,32,9,35],[8,25,9,28],[10,35,17,51],[12,20,13,24],[38,24,38,29],[6,1,7,6],[8,1,9,6],[10,1,11,6],[23,6,23,8],[22,6,22,8],[12,1,13,6],[14,1,15,6],[16,1,17,6],[19,25,19,30],[20,5,20,7],[6,15,7,19],[16,7,17,14],[12,15,13,19],[23,12,23,16],[21,5,21,7],[21,26,21,30],[6,7,7,14],[8,7,9,14],[10,7,11,14],[8,15,9,19],[14,25,15,31],[14,15,15,19],[16,15,17,19],[24,49,24,51],[40,24,40,29],[39,24,39,30],[60,31,60,32],[25,13,25,16],[74,18,75,19],[25,3,25,4],[23,1,23,3],[24,1,24,4],[26,1,26,3],[59,19,59,20],[44,4,47,46],[61,30,61,31],[63,29,63,30],[62,30,62,31],[62,28,62,29],[61,19,61,20],[27,12,27,15],[24,11,24,15],[73,11,73,15],[72,11,72,13],[62,11,62,12],[64,11,64,12],[67,15,67,17],[20,46,20,48],[23,49,23,51],[11,67,12,69],[20,24,20,29],[22,45,22,48],[38,50,38,51],[18,58,18,59],[19,58,19,59],[20,58,20,59],[37,25,37,28],[25,42,25,44],[24,44,24,47],[26,46,26,48],[21,45,21,48],[25,45,25,48],[22,24,22,30],[23,44,23,47],[26,50,26,51],[37,50,37,51],[27,50,27,51],[25,50,25,51],[20,53,20,54],[21,52,32,60],[12,32,13,34]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"CUT DOWN FORMULATOR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Parameters!D29","v":""}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INPUT",null,null,"OUTPUT"]
[]
[null,"Date:",null,null,null,null,null,{"$f":"TODAY()","v":"2021-12-15"},null,null,null,null,null,null,null,"Series:",null,null,null,null,60,null,null,null,null,"Door Stop\n(Reference only)",null,null,null,{"$f":"Parameters!I20","v":0.625},null,null,"Application",null,null,null,{"$f":"Parameters!A22","v":"CVR"},null,null,null,"Extrusion",null,null,null,null,null,null,{"$f":"Parameters!C22","v":"EXTL1"}]
[]
[null,"Name/Email:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Strike:",null,null,null,null,"95T",null,null,null,null,"Door Gap\n(Reference only)",null,null,null,{"$f":"Parameters!F15","v":0.5},null,null,"Backset",null,null,null,{"$f":"Parameters!A20","v":1.06},null,null,null,"Minimum Door Width",null,null,null,null,null,null,{"$f":"Parameters!G22","v":26.285000000000004}]
[]
[null,"PO/SO#:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Endcap:",null,null,null,null,"EC1",null,null,null,null,"Possible",null,null,null,null,null,null,{"$f":"Parameters!I24","v":"YES"}]
[]
[null,"Quantity:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Device Width:",null,null,null,null,"3-O",null,null,null,null,"Cut Down Required",null,null,null,null,null,null,{"$f":"IF(Possible?=YES,Parameters!E24,\"\")","v":0}]
[]
[null,"Line item#:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Function:",null,null,null,null,"LD",null,null,null,null,"Length of Baseplate",null,null,null,null,null,null,{"$f":"IF(Possible?=YES,Parameters!I22,\"\")","v":30.75}]
[]
[null,"Type of Door:",null,null,null,null,null," Hollow Metal/Wood",null,null,null,null,null,null,null,"Door Width:",null,null,null,null,36,null,null,null,null,"Length of Fillerplate",null,null,null,null,null,null,{"$f":"IF(Possible?=YES,Parameters!B24,\"\")","v":11.32}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Parameters!H38","v":""}]
[null,null,null,null,null,{"$f":"Parameters!G35","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Parameters!H36","v":34.83}]
[null,null,null,null,null,{"$f":"Parameters!G37","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Parameters!I38","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Parameters!B36","v":""},null,null,null,null,null,null,{"$f":"IF(Possible?=YES,\"\",Parameters!A29&Parameters!B29&Parameters!E30&Parameters!B30&Parameters!C30&Parameters!F30)","v":""}]
[null,null,null,null,null,null,{"$f":"Parameters!F35","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Parameters!I36","v":30.75},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Parameters!A37","v":1.06}]
[null,{"$f":"Parameters!C38","v":""},null,null,null,null,{"$f":"Parameters!F37","v":2.08},null,null,null,null,null,{"$f":"Parameters!D39","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Parameters!B38","v":""}]
[null,{"$f":"Parameters!C37","v":0.5},null,null,null,null,null,null,null,null,null,{"$f":"Parameters!D38","v":11.32},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Parameters!E37","v":""}]
[null,null,null,{"$f":"Parameters!C35","v":""},null,null,null,null,null,null,null,null,null,{"$f":"Parameters!D36","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Parameters!A38","v":0.59},null,null,{"$f":"Parameters!B35","v":""}]
[null,{"$f":"Parameters!E35","v":0.625}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Parameters!J38","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Parameters!J37","v":36}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Parameters!J39","v":""}]
[]
[]
[]
[null,null,null,null,"*The general arrangement drawing shown is not to scale and generic in nature in that it includes some application assumptions. While the accuracy of the stated dimensions is maintained, the geometry may not exactly match the configuration being represented.  Your particular configuration may not be shown; contact detex technical support at 800-729-3839 (option 2)*"]

{"sheet":"Parameters","index":1,"n_rows":39,"n_cols":17,"rows_kept":39,"cut":false,"hidden":true,"merged":[[0,0,1,9],[2,5,2,6],[8,2,8,3],[22,1,22,2],[22,4,22,5],[22,6,22,7],[16,0,17,9],[20,6,20,7],[22,8,22,9],[18,0,18,1],[18,5,18,6],[18,8,18,9],[33,0,33,1],[33,5,33,6],[31,0,32,9],[26,0,27,9],[2,8,2,9]]}
["PARAMETERS"]
[]
["SERIES:","STRIKES:","TYPE OF DOOR","DOOR STOP","EXTRUSION:","FILLER-PLATE",null,"DEVICE TYPE:","BACKSETS"]
[10,90," Hollow Metal/Wood",0.625,"STD1",7.875,11.32,"3-O",3.38,2.94]
[20,91,"Aluminum Glass",0.25,"STD2",9,12.445,"4-O",2.88,2.75]
[30,92,"Double w/ Mullion",0.625,"EXTL1",9.32,15.32,"30\"",2.69,2.44]
[40,93,"Double w/o Mullion",0.625,"EXTL2",10.445,16.445,"DOOR LENGTH",2.5,2.25]
[50,94,"Gate Door",0,"PUSH-PAD",9.32,17.32,36,2.19,2]
[60,99,"FUNCTION:",null,14.1,10.445,18.445,48,1.82,1.75]
[62,98,"LD",2,18.100000000000001,"ENDCAP:","ENDCAP",30,1.72,1.69,null,null,null,null,null,null,{"$f":"IF(AND(Series=_V40,Function=LD,Door=_3_O,Extrusion=_STD1),Parameters!W26,IF(AND(Series=_V40,Function=HD,Door=_3_O,Extrusion=_STD1),Parameters!W27,IF(AND(Series=_V40,Function=ED,Door=_3_O,Extrusion=_STD1),Parameters!W27,IF(AND(Series=_V40,Function=EA,Door=_3_O,Extrusion=_STD1),Parameters!W28,IF(AND(Series=_V40,Function=ER,Door=_3_O,Extrusion=_STD1),Parameters!W30,IF(AND(Series=_V40,Function=LD,Door=_4_O,Extrusion=_STD1),Parameters!W31,IF(AND(Series=_V40,Function=HD,Door=_4_O,Extrusion=_STD1),Parameters!W30,IF(AND(Series=_V40,Function=ED,Door=_4_O,Extrusion=_STD1),Parameters!W40,IF(AND(Series=_V40,Function=EA,Door=_4_O,Extrusion=_STD1),Parameters!W40,IF(AND(Series=_V40,Function=ER,Door=_4_O,Extrusion=_STD1),Parameters!W33,IF(AND(Series=_V40,Function=EE,Door=_3_O,Extrusion=_STD1),Parameters!W30,IF(AND(Series=_V40,Function=EE,Door=_4_O,Extrusion=_STD1),Parameters!W33,\"\"))))))))))))","v":""}]
[70,97,"HD-CD-EX",3,24.1,"EC1",2.08,"APPLICATION",1.22,1.19]
[80,96,"EB-EI-EA",5.8,"POSSIBILITY :","EC2",0.93,"RIM",1.1299999999999999,1.06]
["V40","NS-96","ED",5.9,"YES","DOOR GAP","EXTRUSION","SVR","BACKSET TO BASEPLATE","BASEPLATE TO PUSHPAD"]
["V50","95T","ER",8.8000000000000007,"NO",0.5,"STD","CVR",0.59,1.33]
[null,"999T","EE",8.3000000000000007,"SO",{"$f":"IF(AND(Series<>\"\",TypeDoor<>\"\"),F14,\"\")","v":0.5},"EXTL",null,1.41,1]
[null,null,"EE-ER",8.8000000000000007,null,{"$f":"I15+I14+J15","v":3},null,null,{"$f":"I15+I14","v":2},{"$f":"I15+I14+F14","v":2.5}]
["FORMULAS"]
[]
["F-BACKSETS",null,"BACKSET TO PUSH-PAD","F-PUSH-PAD","F-FILLER","F-ENDCAP",null,"F-DOOR GAP","F-DOOR STOP"]
[{"$f":"IF(AND(Series<>\"\",Strike<>\"\",TypeDoor<>\"\"),B20,\"\")","v":1.06},{"$f":"IF(AND(Series=_10,G24=G14,TypeDoor=HollowMetal),J4,IF(AND(Series=_10,G24=G15,TypeDoor=HollowMetal),J6,IF(AND(Series=_10,G24=G14,TypeDoor=Glass),J6,IF(AND(Series=_10,G24=G15,TypeDoor=Glass),I9,IF(AND(Series=_10,G24=G14,TypeDoor=C8),J6,IF(AND(Series=_10,G24=G15,TypeDoor=C8),I9,IF(AND(Series=_10,G24=G14,TypeDoor=DwMullion),I4,IF(AND(Series=_10,G24=G15,TypeDoor=DwMullion),I5,IF(AND(Series=_10,G24=G14,TypeDoor=Doublewo),J4,IF(AND(Series=_10,G24=G15,TypeDoor=Doublewo),J6,IF(AND(Series=_20s,G24=G14),J5,IF(AND(Series=_20s,G24=G15),J7,IF(AND(Series=_30s),J5,IF(AND(Series=_40,G24=G14,TypeDoor=HollowMetal),J7,IF(AND(Series=_40,G24=G15,TypeDoor=HollowMetal),J9,IF(AND(Series=_40,G24=G14,TypeDoor=Glass),I10,IF(AND(Series=_40,G24=G15,TypeDoor=Glass),I11,IF(AND(Series=_40,G24=G14,TypeDoor=C8),I10,IF(AND(Series=_40,G24=G15,TypeDoor=C8),I11,IF(AND(Series=_40,G24=G14,TypeDoor=DwMullion),I6,IF(AND(Series=_40,G24=G15,TypeDoor=DwMullion),I8,IF(AND(Series=_40,G24=G14,TypeDoor=Doublewo),J7,IF(AND(Series=_40,G24=G15,TypeDoor=Doublewo),J9,IF(AND(Series=_50s,G24=G14),J10,IF(AND(Series=_50s,G24=G15),J11,IF(AND(Series=_60s),J12,IF(AND(Series=_62),J12,IF(AND(Series=_70s,TypeDoor=HollowMetal),J7,IF(AND(Series=_70s,TypeDoor=Glass),J8,IF(AND(Series=_70s,TypeDoor=C8),J8,IF(AND(Series=_70s,TypeDoor=DwMullion),J7,IF(AND(Series=_70s,TypeDoor=Doublewo),J7,IF(AND(Series=_80s,TypeDoor=HollowMetal),J5,IF(AND(Series=_80s,TypeDoor=Glass),I7,IF(AND(Series=_80s,TypeDoor=C8),I7,IF(AND(Series=_80s,TypeDoor=DwMullion),J5,IF(AND(Series=_80s,TypeDoor=Doublewo),J5,IF(AND(Series=_V40,G24=G14,TypeDoor=HollowMetal),J7,IF(AND(Series=_V40,G24=G15,TypeDoor=HollowMetal),J9,IF(AND(Series=_V40,G24=G14,TypeDoor=Glass),I10,IF(AND(Series=_V40,G24=G15,TypeDoor=Glass),I11,IF(AND(Series=_V40,G24=G14,TypeDoor=C8),I10,IF(AND(Series=_V40,G24=G15,TypeDoor=C8),I11,IF(AND(Series=_V40,G24=G14,TypeDoor=DwMullion),I6,IF(AND(Series=_V40,G24=G15,TypeDoor=DwMullion),I8,IF(AND(Series=_V40,G24=G14,TypeDoor=Doublewo),J7,IF(AND(Series=_V40,G24=G15,TypeDoor=Doublewo),J9,IF(AND(Series=_V50,G24=G14),J7,IF(AND(Series=_V50,G24=G15),I12,M7)))))))))))))))))))))))))))))))))))))))))))))))))","v":1.06},{"$f":"I14+J14","v":1.92},{"$f":"IF(AND(Door=_3_O),Parameters!E10,IF(AND(Door=_4_O),Parameters!E11,IF(AND(Door=_30IN),Parameters!E9,M7)))","v":18.100000000000001},{"$f":"IF(AND(Door=_30IN,Extrusion=_STD1),Parameters!F4,IF(AND(Door=_30IN,Extrusion=_STD2),Parameters!F5,IF(AND(Door=_30IN,Extrusion=_EXTL1),Parameters!F6,IF(AND(Door=_30IN,Extrusion=_EXTL2),Parameters!F7,IF(AND(Door=_3_O,Extrusion=_STD1),Parameters!F8,IF(AND(Door=_3_O,Extrusion=_STD2),Parameters!F9,IF(AND(Door=_3_O,Extrusion=_EXTL1),Parameters!G4,IF(AND(Door=_3_O,Extrusion=_EXTL2),Parameters!G5,IF(AND(Door=_4_O,Extrusion=_STD1),Parameters!G6,IF(AND(Door=_4_O,Extrusion=_STD2),Parameters!G7,IF(AND(Door=_4_O,Extrusion=_EXTL1),Parameters!G8,IF(AND(Door=_4_O,Extrusion=_EXTL2),Parameters!G9,M7))))))))))))","v":11.32},{"$f":"IF(EndCap<>\"\",G20,\"\")","v":2.08},{"$f":"IF(AND(EndCap=Parameters!F11),Parameters!G11,IF(AND(EndCap=Parameters!F12),Parameters!G12,M7))","v":2.08},0.5,{"$f":"IF(TypeDoor<>\"\",J20,\"\")","v":0.625},{"$f":"IF(OR(TypeDoor=HollowMetal,TypeDoor=Doublewo,TypeDoor=DwMullion),Parameters!D7,IF(OR(TypeDoor=Glass),Parameters!D5,IF(OR(TypeDoor=C8),D8,M7)))","v":0.625}]
["F-APPLICATION","Strike Filter","EndCap Extrusion","F-DETEX","F-FUNCTION","F-FILLER CUTDOWN","F-MINIMUM ALLOWED",null,"F-BASEPLATE LENGTH","DEVICE LENTGH"]
[{"$f":"IF(OR(Series=_10,Series=_30s,Series=_40,Series=_V40),Parameters!H12,IF(OR(Series=_60s,Series=_70s,Series=_80s,Series=_62),Parameters!H14,IF(OR(Series=_V50,Series=_20s,Series=_50s),Parameters!H13,\"\")))","v":"CVR"},{"$f":"IF(OR(Series=_10,Series=_40,Series=_V40),\"Diez\", IF(OR(Series=_20s,Series=_50s),\"Cuarenta\",IF(OR(Series=_30s),\"Trenta\",IF(OR(Series=_60s,Series=_70s,Series=_62,Series=_80s),\"Sesenta\",IF(OR(Series=_V50),\"cincuenta\",M7)))))","v":"Sesenta"},{"$f":"IF(AND(G24=G14,EndCap=_EC1),_STD1,IF(AND(G24=G14,EndCap=_EC2),_STD2,IF(AND(G24=G15,EndCap=_EC1),_EXTL1,IF(AND(G24=G15,EndCap=_EC2),_EXTL2,\"\"))))","v":"EXTL1"},{"$f":"B20+C20+D20+E20+G20+H20+J20","v":35.605000000000004},{"$f":"IF(OR(Function=LD),Parameters!D10,IF(OR(Function=HD),Parameters!D11,IF(OR(Function=ED),Parameters!D13,IF(OR(Function=EA),Parameters!D12,IF(OR(Function=EE),Parameters!D14,IF(OR(Function=ER),Parameters!D15,IF(OR(Function=EE_ER),Parameters!D16,M7)))))))","v":2},{"$f":"Parameters!E20-Parameters!E22","v":9.32},{"$f":"IF(AND(Door<>\"\",Series<>\"\",TypeDoor<>\"\",Function<>\"\"),Parameters!H22,\"\")","v":26.285000000000004},{"$f":"Parameters!D22-Parameters!F22","v":26.285000000000004},{"$f":"D20+B24+J14","v":30.75},{"$f":"I22+G20+D24","v":34.83}]
["DOOR LENGTH","F-FILLER LENGTH",null,"BASEPLATE TO EDGE","F-CUTDOWN REQUIRED",null,"F-EXTRUSION",null,"F-POSSIBLE?"]
[{"$f":"IF(AND(Door=_3_O),_36,IF(AND(Door=_4_O),_48,IF(AND(Door=_30IN),_30,M7)))","v":36},{"$f":"E20-E24","v":11.32},{"$f":"IF(OR(Door=\"\",Series=\"\",TypeDoor=\"\",Function=\"\",Resquest_=\"\"),\"\",Parameters!B24)","v":11.32},{"$f":"IF(AND(A22=H13),I16,IF(AND(A22=H14),I16,IF(AND(A22=H12,G24=G14),F16,IF(AND(A22=H12,G24=G15),J16,\"\"))))","v":2},{"$f":"MAX(0,Parameters!F24)","v":0},{"$f":"Parameters!D22-Resquest_","v":-0.39499999999999602},{"$f":"H24&G25","v":"EXTL"},{"$f":"IF(AND(Series=_60s,Strike=_95T),G15,IF(AND(Series=_62,Strike=_95T),G15,IF(AND(Series=_70s,Strike=_95T),G14,IF(AND(Series=_80s,Strike=_95T),G14,IF(AND(Series=_V50,Strike=NS_96),G15,IF(AND(Series=_V50,Strike=_96),G14,IF(AND(Series=_50s,Strike=_96),G15,IF(AND(Series=_20s,Strike=_96),G15,\"\"))))))))","v":"EXTL"},{"$f":"IF(OR(I25=NO),NO,IF(OR(I26=NO),NO,I25))","v":"YES"},{"$f":"IF(OR(J25=NO),NO,IF(OR(I26=NO),NO,YES))","v":"YES"}]
[null,null,null,null,null,null,{"$f":"IF(OR(Strike=_90,Strike=_91,Strike=_92,Strike=_93,Strike=_94,Strike=_99,Strike=_97),G14,IF(OR(Strike=_98),G15,\"\"))","v":""},null,{"$f":"IF(AND(Resquest_=\"\"),\"\",IF(AND(TypeDoor=\"\"),\"\",IF(AND(Series=_V40,EndCap=_EC2),NO,IF(AND(Series=_V50,EndCap=_EC2),NO,IF(AND(Function=EE,Door=_30IN),NO,IF(AND(Function=EE_ER,Door=_30IN),NO,J24))))))","v":"YES"},{"$f":"IF(Resquest_<H22,NO,YES)","v":"YES"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(Resquest_>Doortype,NO,YES)","v":"YES"},{"$f":"IF(AND(Series=_V40,EndCap=_EC2),NO,IF(AND(Series=_V50,EndCap=_EC2),NO,YES))","v":"YES"}]
["ERROR MESSAGES"]
[]
[{"$f":"IF(Resquest_>Doortype,\" (Error-01) Door Width cannot be GREATER than the Device Width!  \",\"\")","v":""},{"$f":"IF(AND(Series=_V40,EndCap=_EC2),\"(Error-02) Value Series can only have EC1\",IF(AND(Series=_V50,EndCap=_EC2),\"(Error-02) Value Series can only have EC1\",\"\"))","v":""},{"$f":"IF(AND(Series=_60s,Extrusion=_STD1),\" (Error-05) 60 Series can only have 95T strike\",IF(AND(Series=_60s,Extrusion=_STD2),\" (Error-05) 60 Series can only have 95T strike\",IF(AND(Series=_62,Extrusion=_STD1),\" (Error-05) 60 Series can only have 95T strike\",IF(AND(Series=_62,Extrusion=_STD2),\" (Error-05) 60 Series can only have 95T strike\",\"\"))))","v":""},{"$f":"IF(AND(Series=_10,TypeDoor=Glass,G24=G14),G29,IF(AND(Series=_20s,G24=G15),G29,IF(AND(Series=_20s,TypeDoor=DwMullion),G29,IF(AND(Series=_30s,TypeDoor=DwMullion),G29,IF(AND(Series=_30s,TypeDoor=Doublewo),G29,IF(AND(Series=_40,TypeDoor=Glass,G24=G14),G29,IF(AND(Series=_50s,G24=G14),G29,IF(AND(Series=_50s,TypeDoor=DwMullion),G29,IF(AND(Series=_60s,TypeDoor=DwMullion),G29,IF(AND(Series=_62,TypeDoor=DwMullion),G29,IF(AND(Series=_70s,TypeDoor=DwMullion),G29,IF(AND(Series=_80s,TypeDoor=DwMullion),G29,IF(AND(Series=_V40,TypeDoor=Glass,G24=G14),G29,IF(AND(Series=_V50,TypeDoor=DwMullion),G29,\"\"))))))))))))))","v":""},{"$f":"IF(AND(Function=EE,Door=_30IN),\" (Error-006) EE function can NOT be applied in a 30 inch device (14 inch pushpad)!\",IF(AND(Function=EE_ER,Door=_30IN),\" (Error-006) EE function can NOT be applied in a 30 inch device (14 inch pushpad)!\",\"\"))","v":""},{"$f":"IF(AND(Series=_30s,Extrusion=_EXTL1),\" 30 serie devices can only have 90,91,92, and 93 strike! \",IF(AND(Series=_30s,Extrusion=_EXTL2),\"30 serie devices can only have 90,91,92, and 93 strike! \",\"\"))","v":""},"Template Is Not Provided With This Configuration"]
[{"$f":"IF(Resquest_<Parameters!H22, \"(Error-03) The Door Width cannot be SMALLER than the minimun size!\",\"\")","v":""},{"$f":"IF(AND(Series=_V50,Door=_30IN),\" (Error-04) Values Series 50 can NOT have a 14 inch pushpad\",IF(AND(Series=_V40,Door=_30IN),\" (Error-04) Values Series can NOT have a 14 inch pushpad\",\"\"))","v":""},{"$f":"C29&E29&F29","v":""},{"$f":"IF(MinSize=\"\",\"\",A30)","v":""},{"$f":"IF(Resquest_=\"\",\"\",Parameters!D30)","v":""},{"$f":"IF(AND(Series<>\"\",TypeDoor=\"\"),\"    (Error-08) Type of Door have to be selected  \",IF(AND(Series<>\"\",TypeDoor=\"\"),\"    (Error-08) Type of Door have to be selected  \",IF(AND(Series<>\"\",TypeDoor=\"\"),\"    (Error-08) Type of Door have to be selected  \",\"\")))","v":""}]
[]
["Dimensions for Diagram"]
[]
["BACKSETS",null,"GAP","FILLER","STOP","ENDCAP",null,"DEVICE","BASEPLATE","WIDTH"]
[{"$f":"IF(OR(Series=_20s,Series=_30s,Series=_60s,Series=_70s,Series=_80s,Series=_62,Series=_10,Series=_V40),A20,\"\")","v":1.06},{"$f":"IF(AND(TypeDoor<>\"\",Strike<>\"\"),B39,\"\")","v":""},{"$f":"IF(AND(Series=_10,TypeDoor<>\"\"),F14,\"\")","v":""},{"$f":"IF(Series=_10,C24,\"\")","v":""},{"$f":"IF(TypeDoor<>\"\",J20,\"\")","v":0.625},{"$f":"IF(AND(Series=_10,EndCap<>\"\"),F20,\"\")","v":""},{"$f":"IF(EndCap<>\"\",F38,\"\")","v":""},{"$f":"IF(OR(Series=_10,Series=_20s,Series=_30s,Series=_60s,Series=_70s,Series=_V40,Series=_80s,Series=_40,Series=_62),J22,\"\")","v":34.83},{"$f":"IF(OR(Series=_10,Series=_20s,Series=_30s,Series=_60s,Series=_70s,Series=_V40,Series=_80s,Series=_40,Series=_62),I22,\"\")","v":30.75},{"$f":"IF(OR(Series=_40,Series=_V40),Resquest_,\"\")","v":""}]
[{"$f":"IF(AND(Series=_V40,Strike<>\"\",TypeDoor<>\"\"),A20,\"\")","v":""},{"$f":"IF(OR(Series=_40),A20,\"\")","v":""},{"$f":"IF(OR(Series=_20s,Series=_30s,Series=_60s,Series=_70s,Series=_80s,Series=_62),F14,\"\")","v":0.5},{"$f":"IF(AND(Function<>\"\",Door<>\"\",Series<>\"\",TypeDoor<>\"\",Resquest_<>\"\"),D35,\"\")","v":""},null,{"$f":"IF(OR(Series=_20s,Series=_30s,Series=_60s,Series=_70s,Series=_80s,Series=_62),F20,\"\")","v":2.08},{"$f":"IF(OR(Series=_40,Series=_V40),F20,\"\")","v":""},{"$f":"IF(AND(Function<>\"\",Door<>\"\",Series<>\"\",TypeDoor<>\"\",Resquest_<>\"\"),H35,\"\")","v":34.83},{"$f":"IF(AND(Function<>\"\",Door<>\"\",Series<>\"\",TypeDoor<>\"\",Resquest_<>\"\"),I35,\"\")","v":30.75},{"$f":"IF(OR(Series=_20s,Series=_30s,Series=_60s,Series=_70s,Series=_80s,Series=_50s,Series=_62,Series=_V50),Resquest_,\"\")","v":36}]
[{"$f":"IF(AND(Strike<>\"\",TypeDoor<>\"\"),A35,\"\")","v":1.06},{"$f":"IF(AND(Strike<>\"\",TypeDoor<>\"\"),B36,\"\")","v":""},{"$f":"IF(TypeDoor<>\"\",C36,\"\")","v":0.5},{"$f":"IF(OR(Series=_20s,Series=_30s,Series=_60s,Series=_62,Series=_70s,Series=_80s),B24,\"\")","v":11.32},{"$f":"IF(AND(Series=_10,TypeDoor<>\"\",Strike<>\"\"),I14,\"\")","v":""},{"$f":"IF(EndCap<>\"\",F36,\"\")","v":2.08},{"$f":"IF(EndCap<>\"\",G36,\"\")","v":""},{"$f":"IF(OR(Series=_50s,Series=_V50),J22,\"\")","v":""},{"$f":"IF(OR(Series=_50s,Series=_V50),I22,\"\")","v":""},{"$f":"IF(Resquest_<>\"\",J36,\"\")","v":36}]
[{"$f":"IF(AND(Strike<>\"\",TypeDoor<>\"\",Series<>\"\"),A39,\"\")","v":0.59},{"$f":"IF(AND(TypeDoor<>\"\",Strike<>\"\"),E38,\"\")","v":""},{"$f":"IF(TypeDoor<>\"\",C39,\"\")","v":""},{"$f":"IF(AND(Function<>\"\",Door<>\"\",Series<>\"\",TypeDoor<>\"\",Function<>\"\",Resquest_<>\"\"),D37,\"\")","v":11.32},{"$f":"IF(OR(Series=_50s,Series=_V50),A20,\"\")","v":""},{"$f":"IF(OR(Series=_50s,Series=_V50),F20,\"\")","v":""},null,{"$f":"IF(AND(Function<>\"\",Door<>\"\",Series<>\"\",TypeDoor<>\"\",Resquest_<>\"\"),H37,\"\")","v":""},{"$f":"IF(AND(Function<>\"\",Door<>\"\",Series<>\"\",TypeDoor<>\"\",Resquest_<>\"\"),I37,\"\")","v":""},{"$f":"IF(Resquest_<>\"\",J35,\"\")","v":""}]
[{"$f":"IF(OR(Series=_20s,Series=_30s,Series=_60s,Series=_70s,Series=_80s,Series=_62,Series=_40,Series=_V40),I14,\"\")","v":0.59},{"$f":"IF(OR(Series=_50s,Series=_V50),I14,\"\")","v":""},{"$f":"IF(OR(Series=_40,Series=_V50,Series=_50s,Series=_V40),F14,\"\")","v":""},{"$f":"IF(AND(Function<>\"\",Door<>\"\",Series<>\"\",TypeDoor<>\"\",Function<>\"\",Resquest_<>\"\"),E39,\"\")","v":""},{"$f":"IF(OR(Series=_40,Series=_50s,Series=_V40,Series=_V50),B24,\"\")","v":""},null,null,null,null,{"$f":"IF(AND(Series=_10,Resquest_<>\"\"),Resquest_,\"\")","v":""}]

{"sheet":"Backsets","index":2,"n_rows":28,"n_cols":17,"rows_kept":28,"cut":false,"hidden":true,"merged":[[22,11,23,13],[9,8,9,10],[4,4,5,4],[10,4,11,4],[22,4,23,4],[20,4,21,4],[16,4,17,4],[22,8,23,10],[20,8,21,10],[18,8,19,10],[13,8,13,10],[14,8,14,10],[18,11,19,13],[15,5,15,7],[20,5,21,7],[16,5,17,7],[8,2,9,3],[10,2,11,3],[12,11,12,13],[10,11,11,13],[8,5,8,7],[10,5,11,7],[10,8,11,10],[9,11,9,13],[8,8,8,10],[12,8,12,10],[8,11,8,13],[12,5,12,7],[0,5,3,15],[4,2,5,3],[4,5,5,7],[4,8,5,10],[6,2,7,3],[4,11,5,13],[6,8,7,10],[6,5,6,7],[7,5,7,7],[6,11,6,13],[7,11,7,13],[26,2,27,3],[26,5,26,7],[27,5,27,7],[14,2,15,3],[12,2,13,3],[16,2,17,3],[22,5,23,7],[22,2,23,3],[20,2,21,3],[25,5,25,7],[24,5,24,7],[18,2,19,3],[18,4,19,4],[13,5,13,7],[14,5,14,7],[24,2,25,3],[27,11,27,13],[24,8,25,10],[24,11,24,13],[25,11,25,13],[26,11,26,13],[26,8,26,10],[27,8,27,10],[20,11,21,13],[18,5,19,7],[9,5,9,7],[15,8,15,10],[16,8,17,10],[13,11,13,13],[14,11,14,13],[15,11,15,13],[16,11,17,13]]}
[null,null,null,null,null,"Backsets"]
[]
[]
[]
[null,null,"Series",null,"Strike","Hollow Metal ",null,null,"Aluminum Glass",null,null,"Double Door",null,null,null,null,"Backsets"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.375]
[null,null,10,null,99,{"$f":"2.9375","v":2.9375},null,null,1.8125,null,null,3.375,null,null,null,null,2.9375]
[null,null,null,null,98,2.4375,null,null,null,null,null,2.875,null,null,null,null,2.875]
[null,null,20,null,97,2.75,null,null,2.75,null,null,null,null,null,null,null,2.75]
[null,null,null,null,96,2.25,null,null,2.25,null,null,null,null,null,null,null,2.6875]
[null,null,30,null,90,2.75,null,null,2.75,null,null,null,null,null,null,null,2.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.4375]
[null,null,40,null,99,2.25,null,null,1.71875,null,null,2.6875,null,null,null,null,2.25]
[null,null,null,null,98,1.75,null,null,1.21875,null,null,2.1875,null,null,null,null,2.1875]
[null,null,50,null,97,1.6875,null,null,1.6875,null,null,null,null,null,null,null,2]
[null,null,null,null,96,1.1875,null,null,1.1875,null,null,null,null,null,null,null,1.8125]
[null,null,"60-61",null,"95T",1.06,null,null,1.06,null,null,null,null,null,null,null,1.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.71875]
[null,null,"62-63",null,"95T",2,null,null,2,null,null,null,null,null,null,null,1.6875]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.21875]
[null,null,70,null,"95T",2.25,null,null,2,null,null,null,null,null,null,null,1.1875]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.125]
[null,null,80,null,"95T",2.75,null,null,2.5]
[]
[null,null,"v40",null,99,2.25,null,null,1.21875,null,null,2.6875]
[null,null,null,null,98,1.75,null,null,null,null,null,2.1875]
[null,null,"v50",null,96,2.25,null,null,2.25]
[null,null,null,null,"NS-96",1.125,null,null,1.125]

{"sheet":"Installation","index":3,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[null,"_10_"]
[null,"_20_"]
[null,"_30_",{"$f":"Series","v":60}]
[null,"_40_",{"$f":"IF(AND(C3=_10),B1,IF(AND(C3=_20s),B2,IF(AND(C3=_30s),B3,IF(AND(C3=_40),B4,IF(AND(C3=_50s),B5,IF(AND(C3=_60s),B6,IF(AND(C3=_70s),B7,IF(AND(C3=_80s),B10,IF(AND(C3=_V40),B8,IF(AND(C3=_V50),B9,\"\"))))))))))","v":"_60_"},null,{"$f":"Series","v":60}]
[null,"_50_"]
[null,"_60_"]
[null,"_70_"]
[null,"_V40_"]
[null,"_V50_"]
[null,"_80_"]

{"sheet":"Drawing","index":4,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[null,"TEN"]
[null,"TWENTY"]
[null,"THIRTY",{"$f":"Series","v":60}]
[null,"FORTY",{"$f":"IF(AND(C3=_10),B1,IF(AND(C3=_20s),B2,IF(AND(C3=_30s),B3,IF(AND(C3=_40),B4,IF(AND(C3=_50s),B5,IF(AND(C3=_60s),B6,IF(AND(C3=_70s),B7,IF(AND(C3=_80s),B10,IF(AND(C3=_V40),B8,IF(AND(C3=_V50),B9,\"\"))))))))))","v":"SIXTY"}]
[null,"FIFTY"]
[null,"SIXTY"]
[null,"SEVENTY"]
[null,"VFORTY"]
[null,"VFIRTY"]
[null,"EIGHTY"]