{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Home","Shape Limits","Image"],"not_rendered":{"charts":0,"images":74,"macros":1,"external_links":0,"defined_names":135,"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":"Home","index":0,"n_rows":21,"n_cols":15,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,12,1,14],[12,2,20,4],[12,5,20,9]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Manufacturing Data"]
[null,null,"Shapes Limitation"]
[null,null,null,"Brickmould",null,"Extrusion",null,"Model No.",null,null,null,1,{"$f":"VLOOKUP($L3,'Shape Limits'!$S:$U,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($L3,'Shape Limits'!$S:$U,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF((VLOOKUP($L3,'Shape Limits'!$S:$V,4,FALSE))=1,\"Z\",\"\")","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"VLOOKUP($L4,'Shape Limits'!$S:$U,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($L4,'Shape Limits'!$S:$U,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF((VLOOKUP($L4,'Shape Limits'!$S:$V,4,FALSE))=1,\"Z\",\"\")","v":{"$error":"#N/A"}}]
[null,null,null,null,"Width","Height",{"$f":"IF(SHAPE=140,\"Leg\",\"Dim. 3\")","v":"Dim. 3"},{"$f":"IF(SHAPE=140,\"CMR\",\"Dim. 4\")","v":"Dim. 4"},null,null,null,3,{"$f":"VLOOKUP($L5,'Shape Limits'!$S:$U,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($L5,'Shape Limits'!$S:$U,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF((VLOOKUP($L5,'Shape Limits'!$S:$V,4,FALSE))=1,\"Z\",\"\")","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"VLOOKUP($L6,'Shape Limits'!$S:$U,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($L6,'Shape Limits'!$S:$U,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF((VLOOKUP($L6,'Shape Limits'!$S:$V,4,FALSE))=1,\"Z\",\"\")","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"IF(AND(SHAPE=120,SHAPEW>0),\"Width is measured diagonally\",\"\")","v":""},null,null,null,null,null,null,5,{"$f":"VLOOKUP($L7,'Shape Limits'!$S:$U,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($L7,'Shape Limits'!$S:$U,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF((VLOOKUP($L7,'Shape Limits'!$S:$V,4,FALSE))=1,\"Z\",\"\")","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"IF(AND(SHAPELINK>1,EXTLINK=2,BM_SELECT>1),\"BRICKMOULD NOT AVAILABLE FOR REGENCY\",\"\")","v":""},null,null,null,null,null,null,null,6,{"$f":"VLOOKUP($L8,'Shape Limits'!$S:$U,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($L8,'Shape Limits'!$S:$U,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF((VLOOKUP($L8,'Shape Limits'!$S:$V,4,FALSE))=1,\"Z\",\"\")","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"IF(AND(SHAPEW>0,SHAPELIMIT>0,EXT>1),\"SIZE IS OUTSIDE LIMITATION\",\"\")","v":""},null,null,null,null,null,null,null,7,{"$f":"VLOOKUP($L9,'Shape Limits'!$S:$U,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($L9,'Shape Limits'!$S:$U,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF((VLOOKUP($L9,'Shape Limits'!$S:$V,4,FALSE))=1,\"Z\",\"\")","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"IF(ISERROR(VLOOKUP(SHAPE,IMAGE_MODEL,3,FALSE)),\"\",VLOOKUP(SHAPE,IMAGE_MODEL,3,FALSE))","v":""},null,null,null,null,null,null,null,8,{"$f":"VLOOKUP($L10,'Shape Limits'!$S:$U,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($L10,'Shape Limits'!$S:$U,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF((VLOOKUP($L10,'Shape Limits'!$S:$V,4,FALSE))=1,\"Z\",\"\")","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"IF(AND(SHAPELINK>1,EXTLINK=1),\"Please Select Extrusion and/or BM\",\"\")","v":""},null,null,null,null,null,null,null,9,{"$f":"VLOOKUP($L11,'Shape Limits'!$S:$U,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($L11,'Shape Limits'!$S:$U,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF((VLOOKUP($L11,'Shape Limits'!$S:$V,4,FALSE))=1,\"Z\",\"\")","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,10,{"$f":"VLOOKUP($L12,'Shape Limits'!$S:$U,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($L12,'Shape Limits'!$S:$U,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF((VLOOKUP($L12,'Shape Limits'!$S:$V,4,FALSE))=1,\"Z\",\"\")","v":{"$error":"#N/A"}}]
[null,null,{"$f":"IF(ISERROR(VLOOKUP(SHAPE,IMAGE_MODEL,2,FALSE)),\"\",VLOOKUP(SHAPE,IMAGE_MODEL,2,FALSE))","v":""},null,null,{"$f":"IF(ISERROR(VLOOKUP(IMAGE,IMAGE_BM,2,FALSE)),\"\",VLOOKUP(IMAGE,IMAGE_BM,2,FALSE))","v":""},null,null,null,null,null,11,{"$f":"VLOOKUP($L13,'Shape Limits'!$S:$U,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($L13,'Shape Limits'!$S:$U,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF((VLOOKUP($L13,'Shape Limits'!$S:$V,4,FALSE))=1,\"Z\",\"\")","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,12,{"$f":"VLOOKUP($L14,'Shape Limits'!$S:$U,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($L14,'Shape Limits'!$S:$U,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF((VLOOKUP($L14,'Shape Limits'!$S:$V,4,FALSE))=1,\"Z\",\"\")","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,13,{"$f":"VLOOKUP($L15,'Shape Limits'!$S:$U,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($L15,'Shape Limits'!$S:$U,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF((VLOOKUP($L15,'Shape Limits'!$S:$V,4,FALSE))=1,\"Z\",\"\")","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,14,{"$f":"VLOOKUP($L16,'Shape Limits'!$S:$U,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($L16,'Shape Limits'!$S:$U,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF((VLOOKUP($L16,'Shape Limits'!$S:$V,4,FALSE))=1,\"Z\",\"\")","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,15,{"$f":"VLOOKUP($L17,'Shape Limits'!$S:$U,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($L17,'Shape Limits'!$S:$U,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF((VLOOKUP($L17,'Shape Limits'!$S:$V,4,FALSE))=1,\"Z\",\"\")","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,16,{"$f":"VLOOKUP($L18,'Shape Limits'!$S:$U,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($L18,'Shape Limits'!$S:$U,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF((VLOOKUP($L18,'Shape Limits'!$S:$V,4,FALSE))=1,\"Z\",\"\")","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,17,{"$f":"VLOOKUP($L19,'Shape Limits'!$S:$U,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($L19,'Shape Limits'!$S:$U,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF((VLOOKUP($L19,'Shape Limits'!$S:$V,4,FALSE))=1,\"Z\",\"\")","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,18,{"$f":"VLOOKUP($L20,'Shape Limits'!$S:$U,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($L20,'Shape Limits'!$S:$U,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF((VLOOKUP($L20,'Shape Limits'!$S:$V,4,FALSE))=1,\"Z\",\"\")","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,19,{"$f":"VLOOKUP($L21,'Shape Limits'!$S:$U,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($L21,'Shape Limits'!$S:$U,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF((VLOOKUP($L21,'Shape Limits'!$S:$V,4,FALSE))=1,\"Z\",\"\")","v":{"$error":"#N/A"}}]

{"sheet":"Shape Limits","index":1,"n_rows":352,"n_cols":67,"rows_kept":352,"cut":false,"hidden":true,"merged":[[2,26,2,27],[0,1,0,2],[0,3,0,10],[0,11,0,12],[9,14,17,14],[19,14,26,14],[2,11,6,12],[29,14,36,14],[39,14,45,14],[47,14,55,14],[59,14,66,14],[71,14,79,14],[83,14,91,14],[94,14,99,14],[103,14,111,14],[114,14,120,14],[123,14,131,14],[134,14,140,14],[145,14,151,14],[157,14,165,14],[228,14,235,14],[238,14,246,14],[248,14,256,14],[168,14,176,14],[180,14,188,14],[192,14,200,14],[204,14,212,14],[216,14,224,14]]}
[null,{"$f":"MAX(D5,D13,D23,D32,D43,D51,D61,D74,D87,D97,D106,D118,D126,D138,D146,D161,D171,D183,D195,D207,D219,D231,D242,D252)","v":0},null,"Shapes Min. Max. Limitations",null,null,null,null,null,null,null,{"$f":"IF(O1>\"\",O1,IF(O2>\"\",O2,IF(O3>\"\",O3,IF(O4>\"\",O4,\"\"))))","v":""},null,null,{"$f":"IF($F$5>\"\",$F$5,IF($F$13>\"\",$F$13,IF($F$23>\"\",$F$23,IF($F$32>\"\",$F$32,IF($F$43>\"\",$F$43,IF($G$51>\"\",$G$51,\"\"))))))","v":""}]
[null,105,"Min R","Max W","Max UI","Max Sq.ft",null,"Frame Height:",{"$f":"IF(AND(SHAPEW>0,SHAPE=B2),SHAPEW/2,0)","v":0},null,null,null,null,null,{"$f":"IF(F61>\"\",F61,IF(G74>\"\",G74,IF(F87>\"\",F87,IF(F97>\"\",F97,IF(F106>\"\",F106,IF(F118>\"\",F118,\"\"))))))","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,null,null,null,null,null,null,null,null,null,null,"Min. W","Min. H 113","Min. H 115","Max. W","Max. H","Max. UI","Max. SF","Min. R","Min. Leg","CutLength","Min. Angle"]
[null,{"$f":"EXT","v":1},{"$f":"MIN_R","v":""},{"$f":"MAX_W","v":""},{"$f":"MAX_UI","v":""},{"$f":"MAX_SF","v":""},null,"Glass R:",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=B2),I2-OFFSET,0)","v":0},"BM R:",{"$f":"IF(AND(SHAPEW>0,SHAPE=B2),I2+(BM-BM_DEDUCT),0)","v":0},{"$f":"VLOOKUP(B2,IMAGE_MODEL,2,FALSE)","v":{"$error":"#VALUE!"}},null,null,{"$f":"IF(F126>\"\",F126,IF(F138>\"\",F138,IF(G146>\"\",G146,IF(F161>\"\",F161,IF(F195>\"\",F195,IF(G207>\"\",G207,\"\"))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,"Shapes",null,null,null,null,null,null,"DYE#","OFFSET","EXTOFFSET",null,null,null,null,"Model","Width","Height","Area",null,null,"SS (2.2)","DS (3.2)","4 mm","TS (5.0)",null,null,null,null,null,7627,12,{"$f":"(TRUNC(SQRT(SHAPEW+5.75)*16+0.5)/16)+(OFFSET*2)","v":2.375},{"$f":"(TRUNC(SQRT(SHAPEW+5.75)*16+0.5)/16)+(OFFSET*2)","v":2.375},108,108,162,56,13,6,10,8.5]
[null,{"$f":"BM_DYE","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPE=B2,(SHAPEW/2)<C3),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=B2,SHAPEW>D3),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=B2,(SHAPEW+SHAPEH)>E3),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=B2,((SHAPEW*SHAPEH)/144)>F3),1,0)","v":0},null,"Glass H:",{"$f":"IF(AND(SHAPEW>0,SHAPE=B2),I2-(OFFSET*2),0)","v":0},"BM H:",{"$f":"IF(AND(SHAPEW>0,SHAPE=B2),I2+((BM-BM_DEDUCT)*2),0)","v":0},null,null,null,{"$f":"IF(G171>\"\",G171,IF(G183>\"\",G183,IF(G219>\"\",G219,IF(G231>\"\",G231,IF(G242>\"\",G242,IF(G252>\"\",G252,\"\"))))))","v":""},null,null,null,null,null,null,null,null,null,null,1,"Select","Select",null,"<< Cut Angle",null,1,"Select",1,0,0,null,null,null,null,105,{"$f":"GW_105","v":0},{"$f":"GH_105","v":0},{"$f":"(AP4*AQ4)/144","v":0},null,"Max. Short",{"$f":"IF(OR($AP$29>41,$AP$43>41),0,41)","v":41},{"$f":"IF(OR($AP$29>56,$AP$43>56),0,56)","v":56},{"$f":"IF(OR($AP$29>76,$AP$43>76),0,76)","v":76},{"$f":"IF(OR($AP$29>76,$AP$43>76),0,76)","v":76},"Annealed",null,null,null,null,7631,12,{"$f":"(TRUNC(SQRT(SHAPEW+7.3125)*16+0.5)/16)+(OFFSET*2)","v":2.6875},{"$f":"(TRUNC(SQRT(SHAPEW+7.3125)*16+0.5)/16)+(OFFSET*2)","v":2.6875},108,108,162,56,13.5,6,10,8.5]
[null,null,{"$f":"MAX(C4:F4)","v":0},{"$f":"IF(AND(SHAPE=B2,C5=1),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=B2,SHAPEH<>(SHAPEW/2)),1,0)","v":0},{"$f":"IF(AND(SHAPE=105,E5=1),\"HEIGHT MUST BE 1/2 THE WIDTH\",IF(AND(SHAPE=105,SHAPEW>0,C4>0),\"RADIUS MUST BE GREATER THAN \"&C3,IF(AND(SHAPE=105,I5>0,I5<GlassMinW),\"Glass Width is Under Minimum\",IF(AND(SHAPE=105,I4>0,I4<GlassMinH),\"Glass Height is Under Minimum\",\"\"))))","v":""},null,"Glass W:",{"$f":"IF(AND(SHAPEW>0,SHAPE=B2,EXTRUSION=\"Mezzo\"),(2*(SQRT(I4*((2*((SHAPEW/2)-OFFSET))-I4))))-0.1875,IF(AND(SHAPEW>0,SHAPE=B2),2*(SQRT(I4*((2*((SHAPEW/2)-OFFSET))-I4))),0))","v":0},"BM W:",{"$f":"IF(AND(SHAPEW>0,SHAPE=B2),SHAPEW+((BM-BM_DEDUCT)*2),0)","v":0},null,null,null,null,null,null,105,{"$f":"IF(SHAPE=R5,1,0)","v":0},{"$f":"IF(S5>0,\"Frame Width:\",0)","v":0},{"$f":"IF(S5>0,SHAPEW,0)","v":0},{"$f":"IF(AND(S5>0,SHAPEW>0,D4>0),1,0)","v":0},null,null,null,2,105,"105 (Circle Top)",null,null,null,2,"Regency","PI7301",1.4375,1.86,null,null,null,null,110,{"$f":"GW_110","v":0},{"$f":"GH_110","v":0},{"$f":"(AP5*AQ5)/144","v":0},null,"Max. Long",{"$f":"IF(OR($AQ$29>62,$AQ$43>62),0,62)","v":62},{"$f":"IF(OR($AQ$29>76,$AQ$43>76),0,76)","v":76},{"$f":"IF(OR($AQ$29>110,$AQ$43>110),0,110)","v":110},{"$f":"IF(OR($AQ$29>110,$AQ$43>110),0,110)","v":110},"Annealed",null,null,null,null,"PI7301",10,{"$f":"(TRUNC(SQRT(SHAPEW+5.75)*16+0.5)/16)+(OFFSET*2)","v":2.375},{"$f":"(TRUNC(SQRT(SHAPEW+5.75)*16+0.5)/16)+(OFFSET*2)","v":2.375},95,95,154,56,13,6,10,8.5]
[null,null,null,null,null,null,null,null,null,"BM Leg:",{"$f":"IF(AND(SHAPEW>0,SHAPE=B2),BM,0)","v":0},null,null,null,null,null,null,105,{"$f":"IF(SHAPE=R6,2,0)","v":0},{"$f":"IF(S6>0,\"Frame Height:\",0)","v":0},{"$f":"IF(S6>0,I2,0)","v":0},null,null,null,null,3,110,"110 (Circle Top w/Ex Leg)",null,null,null,3,"3000 Series",7627,1.25,1.871,null,null,null,null,111,{"$f":"GW_111","v":0},{"$f":"GW_111","v":0},0,null,"Max Sq.Ft.",{"$f":"IF(OR($AR$29>12,$AR$43>12),0,12)","v":12},{"$f":"IF(OR($AR$29>22,$AR$43>22),0,22)","v":22},{"$f":"IF(OR($AR$29>42,$AR$43>42),0,42)","v":42},{"$f":"IF(OR($AR$29>42,$AR$43>42),0,42)","v":42},"Annealed",null,null,null,null,"1556A",12,12,12,108,108,162,56,13,6,10,8.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,105,{"$f":"IF(SHAPE=R7,3,0)","v":0},{"$f":"IF(S7>0,\"Frame Radius:\",0)","v":0},{"$f":"IF(S7>0,I2,0)","v":0},{"$f":"IF(AND(S7>0,SHAPEW>0,C4>0),1,0)","v":0},null,null,null,4,111,"111 (Quarter Arch)",null,null,null,4,"4000 Series",7631,1.7849999999999999,2.3386,null,null,null,null,112,{"$f":"GW_112","v":0},{"$f":"GH_112","v":0},0,null,"Max. Short",0,{"$f":"IF(OR($AP$29>42,$AP$43>42),0,42)","v":42},{"$f":"IF(OR($AP$29>70,$AP$43>70),0,70)","v":70},{"$f":"IF(OR($AP$29>70,$AP$43>70),0,70)","v":70},"Tempered",null,null,null,null,1556,12,12,12,108,108,162,56,13,6,10,8.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,105,{"$f":"IF(SHAPE=R8,4,0)","v":0},{"$f":"IF(S8>0,\"Glass Radius:\",0)","v":0},{"$f":"IF(S8>0,I3,0)","v":0},null,null,null,null,5,112,"112 (Quarter Arch w/Ex Leg)",null,null,null,1,{"$f":"VLOOKUP(EXTLINK,EXTCHART,2,FALSE)","v":"Select"},{"$f":"VLOOKUP(EXTLINK,EXTCHART,3,FALSE)","v":1},{"$f":"VLOOKUP(EXTLINK,EXTCHART,4,FALSE)","v":0},{"$f":"VLOOKUP(EXTLINK,EXTCHART,5,FALSE)","v":0},null,null,null,null,113,{"$f":"GW_113","v":0},{"$f":"GH_113","v":0},0,null,"Max. Long",0,{"$f":"IF(OR($AQ$29>84,$AQ$43>84),0,84)","v":84},{"$f":"IF(OR($AQ$29>129,$AQ$43>129),0,129)","v":129},{"$f":"IF(OR($AQ$29>129,$AQ$43>129),0,129)","v":129},"Tempered",null,null,null,null,6184,12,12,12,108,108,162,56,13,6,10,8.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,105,{"$f":"IF(SHAPE=R9,5,0)","v":0},{"$f":"IF(S9>0,\"Glass Width:\",0)","v":0},{"$f":"IF(S9>0,I5,0)","v":0},{"$f":"IF(AND(U9>0,SHAPEW>0,GW_105<GlassMinW),1,0)","v":0},null,null,null,6,113,"113 (Eyebrow)",null,null,null,null,null,null,null,null,null,null,null,null,114,{"$f":"GW_114","v":0},{"$f":"GH_114","v":0},0,null,"Max Sq.Ft.",0,{"$f":"IF(OR($AR$29>24.5,$AR$43>24.5),0,24.5)","v":24.5},{"$f":"IF(OR($AR$29>42,$AR$43>42),0,42)","v":42},{"$f":"IF(OR($AR$29>42,$AR$43>42),0,42)","v":42},"Tempered",null,null,null,null,7634,12,12,12,108,108,162,56,16,6,10,8.5]
[null,110,"Min R","Max W","Max UI","Max H","Min Leg",null,"Frame Height:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=110),SHAPEH,0)","v":0},null,null,null,null,{"$f":"VLOOKUP(B10,IMAGE_MODEL,2,FALSE)","v":{"$error":"#VALUE!"}},null,null,105,{"$f":"IF(SHAPE=R10,6,0)","v":0},{"$f":"IF(S10>0,\"Glass Height:\",0)","v":0},{"$f":"IF(S10>0,I4,0)","v":0},{"$f":"IF(AND(U10>0,SHAPEW>0,GH_105<GlassMinH),1,0)","v":0},null,null,null,7,114,"114 (Eyebrow w/Ex Leg)",null,null,null,{"$f":"EXTLINK&\"-\"&BM_SELECT","v":"1-1"},"Image Selection",null,null,null,null,null,null,null,115,{"$f":"GW_115","v":0},{"$f":"GH_115","v":0},0,null,null,{"$f":"IF(AND(AU4>0,AU5>0,AU6>0),1,0)","v":1},{"$f":"IF(AND(AV4>0,AV5>0,AV6>0),1,0)","v":1},{"$f":"IF(AND(AW4>0,AW5>0,AW6>0),1,0)","v":1},{"$f":"IF(AND(AX4>0,AX5>0,AX6>0),1,0)","v":1},{"$f":"IF(AU10>0,\"≥SS Annealed\",IF(AV10>0,\"≥DS Annealed\",IF(AX10>0,\"TS Annealed\",\"\")))","v":"≥SS Annealed"},null,null,null,null,7635,12,12,12,108,108,162,56,13,6,10,8.5]
[null,{"$f":"EXT","v":1},{"$f":"MIN_R","v":""},{"$f":"MAX_W","v":""},{"$f":"MAX_UI","v":""},{"$f":"MAX_H","v":""},6.25E-2,null,"Glass W:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=110),SHAPEW-(OFFSET*2),0)","v":0},null,null,null,null,null,null,null,105,{"$f":"IF(SHAPE=R11,7,0)","v":0},{"$f":"IF(S11>0,\"Max Width:\",0)","v":0},{"$f":"IF(S11>0,D3,0)","v":0},{"$f":"IF(AND(S11>0,SHAPEW>0,I2>U11),1,0)","v":0},null,null,null,8,115,"115 (Half Eyebrow)",null,null,null,null,null,null,null,null,null,null,null,null,116,{"$f":"GW_116","v":0},{"$f":"GH_116","v":0},0,null,null,null,{"$f":"IF(AND(AV7>0,AV8>0,AV9>0),1,0)","v":1},{"$f":"IF(AND(AW7>0,AW8>0,AW9>0),1,0)","v":1},{"$f":"IF(AND(AX7>0,AX8>0,AX9>0),1,0)","v":1},{"$f":"IF(AV11>0,\"≥DS Tempered\",IF(AX11>0,\"TS Tempered\",\"\"))","v":"≥DS Tempered"},null,null,null,null,"15182A",12,12,12,108,108,162,56,13,6,10,8.5]
[null,{"$f":"BM_DYE","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPE=B10,(SHAPEW/2)<C11),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=B10,SHAPEW>D11),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=B10,(SHAPEW+SHAPEH)>E11),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=B10,SHAPEH>F11),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=110,(SHAPEH-SHAPEW/2)<G11),1,0)","v":0},null,"Glass H:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=110),SHAPEH-(OFFSET*2),0)","v":0},null,null,null,null,null,null,null,105,{"$f":"IF(SHAPE=R12,8,0)","v":0},{"$f":"IF(S12>0,\"Max UI:\",0)","v":0},{"$f":"IF(S12>0,E3,0)","v":0},{"$f":"IF(AND(S12>0,SHAPEW>0,E4>0),1,0)","v":0},null,null,null,9,116,"116 (Half Eyebrow w/Ex Leg)",null,null,null,null,"Brickmould Description","Dye","BM_THICK","BM_3000","BM_4000",null,null,null,117,{"$f":"GW_117","v":0},{"$f":"GH_117","v":0},0,null,null,"2.5 mm","3.2 mm","4 mm","5 mm",null,null,null,null,null,15182,12,12,12,108,108,162,56,13,6,10,8.5]
[null,null,{"$f":"MAX(C12:G12)","v":0},{"$f":"IF(AND(SHAPE=B10,C13=1),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,OFFSET>0,DIM_4>0,SHAPEH>0,SHAPE=B10,(SHAPEH-DIM_4)<>(SHAPEW/2)),1,0)","v":0},{"$f":"IF(AND(SHAPE=110,E13=1),\"HEIGHT MUST BE 1/2 THE WIDTH + Leg\",IF(AND(SHAPE=110,SHAPEW>0,C12>0),\"RADIUS MUST BE GREATER THAN \"&C11,IF(AND(SHAPE=110,J13>0,J13<GlassMinW),\"Glass Width is Under Minimum\",IF(AND(SHAPE=110,J14>0,J14<GlassMinH),\"Glass Height is Under Minimum\",\"\"))))","v":""},null,null,"Glass Leg H:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=110,((SHAPEH-SHAPEW/2)-OFFSET)>0),(SHAPEH-SHAPEW/2)-OFFSET,0)","v":0},null,null,null,null,null,null,null,105,{"$f":"IF(SHAPE=R13,9,0)","v":0},{"$f":"IF(S13>0,\"Max Sq.ft:\",0)","v":0},{"$f":"IF(S13>0,F3,0)","v":0},{"$f":"IF(AND(S13>0,SHAPEW>0,F4>0),1,0)","v":0},null,null,null,10,117,"117 (Ellipse)",null,null,null,1,"No Brickmould",0,0,0,0,null,null,null,118,{"$f":"GW_118","v":0},{"$f":"GH_118","v":0},0,null,"Max. Short",{"$f":"IF(OR($AQ$29>41,$AQ$43>41),0,41)","v":41},{"$f":"IF(OR($AQ$29>56,$AQ$43>56),0,56)","v":56},{"$f":"IF(OR($AQ$29>76,$AQ$43>76),0,76)","v":76},{"$f":"IF(OR($AQ$29>76,$AQ$43>76),0,76)","v":76},"Annealed",null,null,null,null,"15184A",12,12,12,108,108,162,56,13,6,10,8.5]
[null,null,null,null,null,null,null,null,"Glass R:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=B10),(SHAPEW/2)-OFFSET,0)","v":0},null,null,null,null,null,null,null,105,{"$f":"IF(AND(BM_SELECT>1,SHAPE=R14),10,0)","v":0},{"$f":"IF(S14>0,\"Brickmould Width:\",0)","v":0},{"$f":"IF(S14>0,K5,0)","v":0},null,null,null,null,11,118,"118 (Full Circle)",null,null,null,2,"Slope Sill - No Nail Fin","1556A",0.92400000000000004,1.133,1.6679999999999999,null,null,null,119,{"$f":"GW_119","v":0},{"$f":"GH_119","v":0},0,null,"Max. Long",{"$f":"IF(OR($AP$29>62,$AP$43>62),0,62)","v":62},{"$f":"IF(OR($AP$29>76,$AP$43>76),0,76)","v":76},{"$f":"IF(OR($AP$29>110,$AP$43>110),0,110)","v":110},{"$f":"IF(OR($AP$29>110,$AP$43>110),0,110)","v":110},"Annealed",null,null,null,null,15184,12,12,12,108,108,162,56,13,6,10,8.5]
[null,null,null,null,null,null,null,null,"BM Leg H:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=110),(SHAPEH-SHAPEW/2)+(BM-BM_DEDUCT),0)","v":0},null,null,null,null,null,null,null,105,{"$f":"IF(AND(BM_SELECT>1,SHAPE=R15),11,0)","v":0},{"$f":"IF(S15>0,\"Brickmould Height:\",0)","v":0},{"$f":"IF(S15>0,K4,0)","v":0},null,null,null,null,12,119,"119 (Oval)",null,null,null,3,"Slope Sill - Nail Fin",1556,2.7989999999999999,1.133,1.6679999999999999,null,null,null,120,{"$f":"GW_120","v":0},{"$f":"GH_120","v":0},0,null,"Max Sq.Ft.",{"$f":"IF(OR($AR$29>12,$AR$43>12),0,12)","v":12},{"$f":"IF(OR($AR$29>22,$AR$43>22),0,22)","v":22},{"$f":"IF(OR($AR$29>42,$AR$43>42),0,42)","v":42},{"$f":"IF(OR($AR$29>42,$AR$43>42),0,42)","v":42},"Annealed",null,null,null,null,"15184B",12,12,12,108,108,162,56,13,6,10,8.5]
[null,null,null,null,null,null,null,null,"BM W:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=110),SHAPEW+((BM-BM_DEDUCT)*2),0)","v":0},null,null,null,null,null,null,null,105,{"$f":"IF(AND(BM_SELECT>1,SHAPE=R16),12,0)","v":0},{"$f":"IF(S16>0,\"Brickmould Radius:\",0)","v":0},{"$f":"IF(S16>0,K3,0)","v":0},null,null,null,null,13,120,"120 (Hexagon)",null,null,null,4,"Extended 2-1/4\"",6184,2.6890000000000001,1.425,1.9590000000000001,null,null,null,121,{"$f":"GW_121","v":0},{"$f":"GH_121","v":0},0,null,"Max. Short",0,{"$f":"IF(OR($AQ$29>42,$AQ$43>42),0,42)","v":42},{"$f":"IF(OR($AQ$29>70,$AQ$43>70),0,70)","v":70},{"$f":"IF(OR($AQ$29>70,$AQ$43>70),0,70)","v":70},"Tempered",null,null,null,null,"15368A",12,12,12,108,108,162,56,13,6,10,8.5]
[null,null,null,null,null,null,null,null,"BM H:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=110),SHAPEH+((BM-BM_DEDUCT)*2),0)","v":0},null,null,null,null,null,null,null,105,{"$f":"IF(AND(BM_SELECT>1,SHAPE=R17),13,0)","v":0},{"$f":"IF(S17>0,\"Brickmould Leg:\",0)","v":0},{"$f":"IF(S17>0,K6,0)","v":0},null,null,null,null,14,121,"121 (Hexagon w/Ex Leg)",null,null,null,5,"3-1/2\" Brickmould",7634,4.8170000000000002,1.569,2.1040000000000001,null,null,null,122,{"$f":"GW_122","v":0},{"$f":"GH_122","v":0},0,null,"Max. Long",0,{"$f":"IF(OR($AP$29>84,$AP$43>84),0,84)","v":84},{"$f":"IF(OR($AP$29>129,$AP$43>129),0,129)","v":129},{"$f":"IF(OR($AP$29>129,$AP$43>129),0,129)","v":129},"Tempered",null,null,null,null,15368,12,12,12,108,108,162,56,13,6,10,8.5]
[null,null,null,null,null,null,null,null,"BM R",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=110),(SHAPEW/2)+((BM-BM_DEDUCT)),0)","v":0},null,null,null,null,null,null,null,110,{"$f":"IF(SHAPE=R18,1,0)","v":0},{"$f":"IF(S18>0,\"Frame Width:\",0)","v":0},{"$f":"IF(S18>0,SHAPEW,0)","v":0},{"$f":"IF(AND(S18>0,SHAPEW>0,SHAPEH>0,D12>0),1,0)","v":0},null,null,null,15,122,"122 (Octagon)",null,null,null,6,"2\" Reno Brickmould",7635,3.3170000000000002,1.569,2.1040000000000001,null,null,null,123,{"$f":"GW_123","v":0},{"$f":"GH_123","v":0},0,null,"Max Sq.Ft.",0,{"$f":"IF(OR($AR$29>24.5,$AR$43>24.5),0,24.5)","v":24.5},{"$f":"IF(OR($AR$29>42,$AR$43>42),0,42)","v":42},{"$f":"IF(OR($AR$29>42,$AR$43>42),0,42)","v":42},"Tempered",null,null,null,null,null,{"$f":"IF(EXT=1,\"\",VLOOKUP(EXT,DATA,2,FALSE))","v":""},{"$f":"IF(EXT=1,\"\",VLOOKUP(EXT,DATA,3,FALSE))","v":""},{"$f":"IF(EXT=1,\"\",VLOOKUP(EXT,DATA,4,FALSE))","v":""},{"$f":"IF(EXT=1,\"\",VLOOKUP(EXT,DATA,5,FALSE))","v":""},{"$f":"IF(EXT=1,\"\",VLOOKUP(EXT,DATA,6,FALSE))","v":""},{"$f":"IF(EXT=1,\"\",VLOOKUP(EXT,DATA,7,FALSE))","v":""},{"$f":"IF(EXT=1,\"\",VLOOKUP(EXT,DATA,8,FALSE))","v":""},{"$f":"IF(EXT=1,\"\",VLOOKUP(EXT,DATA,9,FALSE))","v":""},{"$f":"IF(EXT=1,\"\",VLOOKUP(EXT,DATA,10,FALSE))","v":""},{"$f":"IF(EXT=1,\"\",VLOOKUP(EXT,DATA,11,FALSE))","v":""},{"$f":"IF(EXT=1,\"\",VLOOKUP(EXT,DATA,12,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,110,{"$f":"IF(SHAPE=R19,2,0)","v":0},{"$f":"IF(S19>0,\"Frame Height:\",0)","v":0},{"$f":"IF(S19>0,J10,0)","v":0},{"$f":"IF(AND(S19>0,SHAPEW>0,SHAPEH>0,F12>0),1,0)","v":0},null,null,null,16,123,"123 (Octagon w/Ex Leg)",null,null,null,7,"2\" Brickmould - No Nail Fin","15182A",2.3170000000000002,1.569,2.1040000000000001,null,null,null,124,{"$f":"GW_124","v":0},{"$f":"GH_124","v":0},0,null,null,{"$f":"IF(AND(AU13>0,AU14>0,AU15>0),1,0)","v":1},{"$f":"IF(AND(AV13>0,AV14>0,AV15>0),1,0)","v":1},{"$f":"IF(AND(AW13>0,AW14>0,AW15>0),1,0)","v":1},{"$f":"IF(AND(AX13>0,AX14>0,AX15>0),1,0)","v":1},{"$f":"IF(AU19>0,\"≥SS Annealed\",IF(AV19>0,\"≥DS Annealed\",IF(AX19>0,\"TS Annealed\",\"\")))","v":"≥SS Annealed"}]
[null,111,"Min R","Max W","Max UI","Max Sq.ft",null,"Frame H:",{"$f":"IF(AND(SHAPEW>0,SHAPE=B20),SHAPEW,0)","v":0},null,null,null,null,null,{"$f":"VLOOKUP(B20,IMAGE_MODEL,2,FALSE)","v":{"$error":"#VALUE!"}},null,null,110,{"$f":"IF(SHAPE=R20,3,0)","v":0},{"$f":"IF(S20>0,\"Frame Radius:\",0)","v":0},{"$f":"IF(S20>0,SHAPEW/2,0)","v":0},{"$f":"IF(AND(S20>0,SHAPEW>0,SHAPEH>0,C12>0),1,0)","v":0},null,null,null,17,124,"124 (Pentagon Equilateral)",null,null,null,8,"2\" Brickmould - Nail Fin",15182,3.3170000000000002,1.569,2.1040000000000001,null,null,null,125,{"$f":"GW_125","v":0},{"$f":"GH_125","v":0},0,null,null,null,{"$f":"IF(AND(AV16>0,AV17>0,AV18>0),1,0)","v":1},{"$f":"IF(AND(AW16>0,AW17>0,AW18>0),1,0)","v":1},{"$f":"IF(AND(AX16>0,AX17>0,AX18>0),1,0)","v":1},{"$f":"IF(AV20>0,\"≥DS Tempered\",IF(AX20>0,\"TS Tempered\",\"\"))","v":"≥DS Tempered"}]
[null,{"$f":"EXT","v":1},{"$f":"MIN_R","v":""},{"$f":"MAX_W","v":""},{"$f":"MAX_UI","v":""},{"$f":"MAX_SF","v":""},null,"Frame R:",{"$f":"IF(AND(SHAPEW>0,SHAPE=B20),SHAPEW,0)","v":0},"BM R:",{"$f":"IF(AND(SHAPEW>0,SHAPE=B20),SHAPEW+((BM-BM_DEDUCT)),0)","v":0},null,null,null,null,null,null,110,{"$f":"IF(SHAPE=R21,4,0)","v":0},{"$f":"IF(S21>0,\"Frame Leg:\",0)","v":0},{"$f":"IF(S21>0,SHAPEH-SHAPEW/2,0)","v":0},{"$f":"IF(AND(S25>0,SHAPEW>0,SHAPEH>0,G12>0),1,0)","v":0},null,null,null,18,125,"125 (Half Pentagon)",null,null,null,9,"1-1/4\" Brickmould - No Nail Fin","15184A",1.5669999999999999,1.569,2.1040000000000001,null,null,null,126,{"$f":"GW_126","v":0},{"$f":"GH_126","v":0},0,null,"This is not being used"]
[null,{"$f":"BM_DYE","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPE=B20,SHAPEW<C21),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=B20,SHAPEW>D21),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=B20,(SHAPEW+I20)>E21),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPEH>0,SHAPE=B20,((SHAPEW*SHAPEH)/144)>F21),1,0)","v":0},null,"Glass R:",{"$f":"IF(AND(SHAPEW>0,SHAPE=B20),SHAPEW-OFFSET,0)","v":0},"BM W:",{"$f":"IF(AND(SHAPEW>0,SHAPE=B20),SHAPEW+((BM-BM_DEDUCT)*2)-K26,0)","v":0},null,null,null,null,null,null,110,{"$f":"IF(SHAPE=R22,5,0)","v":0},{"$f":"IF(S22>0,\"Glass Radius:\",0)","v":0},{"$f":"IF(S22>0,GH_110,0)","v":0},null,null,null,null,19,126,"126 (Pentagon)",null,null,null,10,"1-1/4\" Brickmould - Nail Fin",15184,2.5670000000000002,1.569,2.1040000000000001,null,null,null,127,{"$f":"GW_127","v":0},{"$f":"GH_127","v":0},0,null,{"$f":"IF(RADIUS>\"\",RADIUS,IF(SHAPEW>0,\"Available Glass Options: \"&GLASSOPT1&IF(AND(GLASSOPT1>\"\",GLASSOPT2>\"\"),\" Or \",\"\")&GLASSOPT2&\".\"&IF(EXTLINK=5,\" TIG only in SS & DS. Dual IG in all Available Strengths.\",\" No TIG. Dual IG in all Available Strengths.\"),\"\"))","v":""}]
[null,null,{"$f":"MAX(C22:F22)","v":0},{"$f":"IF(AND(SHAPE=B20,C23=1),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPE=111,SHAPEH>0,SHAPEH<>SHAPEW),1,0)","v":0},{"$f":"IF(AND(SHAPE=111,E23=1),\"HEIGHT MUST BE EQUAL TO THE WIDTH\",IF(AND(SHAPE=111,SHAPEW>0,C22>0),\"RADIUS MUST BE GREATER THAN \"&C21,IF(AND(SHAPE=111,I23>0,I23<GlassMinW),\"Glass Width or Height is Under Minimum\",\"\")))","v":""},null,"Glass W & H:",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=B20),SHAPEW-(OFFSET*2)-I26,0)","v":0},"BM H:",{"$f":"IF(AND(SHAPEW>0,SHAPE=B20),SHAPEW+((BM-BM_DEDUCT)*2)-K26,0)","v":0},null,null,null,null,null,null,110,{"$f":"IF(SHAPE=R23,6,0)","v":0},{"$f":"IF(S23>0,\"Glass Width:\",0)","v":0},{"$f":"IF(S23>0,J11,0)","v":0},{"$f":"IF(AND(U23>0,SHAPEW>0,SHAPEH>0,GW_110<GlassMinW),1,0)","v":0},null,null,null,20,127,"127 (Cathedral)",null,null,null,11,"1-1/4\" Brickmould - No J With Fin","15184B",2.5670000000000002,1.569,2.1040000000000001,null,null,null,128,{"$f":"GW_128","v":0},{"$f":"GH_128","v":0},0]
[null,null,null,null,null,null,null,"F",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=B20),2*(ASIN((OFFSET*2)/(2*I22))),0)","v":0},"F",{"$f":"IF(AND(SHAPEW>0,SHAPE=B20),2*(ASIN(((BM-BM_DEDUCT)*2)/(2*K21))),0)","v":0},null,null,null,null,null,null,110,{"$f":"IF(SHAPE=R24,7,0)","v":0},{"$f":"IF(S24>0,\"Glass Height:\",0)","v":0},{"$f":"IF(S24>0,J12,0)","v":0},{"$f":"IF(AND(U24>0,SHAPEW>0,SHAPEH>0,GH_110<GlassMinH),1,0)","v":0},null,null,null,21,128,"128 (Cathedral w/Ex Leg)",null,null,null,12,"3/8\" Brickmould - No Nail Fin","15368A",0.69199999999999995,1.569,2.1040000000000001,null,null,null,129,{"$f":"GW_129","v":0},{"$f":"GH_129","v":0},0]
[null,null,null,null,null,null,null,"d",{"$f":"IF(AND(SHAPEW>0,SHAPE=B20),I22*COS(I24/2),0)","v":0},"d",{"$f":"IF(AND(SHAPEW>0,SHAPE=B20),K21*COS(K24/2),0)","v":0},null,null,null,null,null,null,110,{"$f":"IF(SHAPE=R25,8,0)","v":0},{"$f":"IF(S25>0,\"Glass Leg Height:\",0)","v":0},{"$f":"IF(S25>0,GW_110,0)","v":0},null,null,null,null,22,129,"129 (Trapezoid)",null,null,null,13,"3/8\" Brickmould - With Fin",15368,1.6919999999999999,1.569,2.1040000000000001,null,null,null,130,{"$f":"GW_130","v":0},{"$f":"GH_130","v":0},0]
[null,null,null,null,null,null,null,"h",{"$f":"I22-I25","v":0},"h",{"$f":"IF(AND(SHAPEW>0,SHAPE=B20),K21-K25,0)","v":0},null,null,null,null,null,null,110,{"$f":"IF(SHAPE=R26,9,0)","v":0},{"$f":"IF(S26>0,\"Max Width:\",0)","v":0},{"$f":"IF(S26>0,D11,0)","v":0},{"$f":"IF(AND(S26>0,SHAPEW>0,SHAPEH>0,D12>0),1,0)","v":0},null,null,null,23,130,"130 (Right Triangle)",null,null,null,1,{"$f":"VLOOKUP(BM_SELECT,BM_TABLE,2,FALSE)","v":"No Brickmould"},{"$f":"VLOOKUP(BM_SELECT,BM_TABLE,3,FALSE)","v":0},{"$f":"VLOOKUP(BM_SELECT,BM_TABLE,4,FALSE)","v":0},{"$f":"VLOOKUP(BM_SELECT,BM_TABLE,5,FALSE)","v":0},{"$f":"VLOOKUP(BM_SELECT,BM_TABLE,6,FALSE)","v":0},null,null,null,131,{"$f":"GW_131","v":0},{"$f":"GH_131","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,110,{"$f":"IF(SHAPE=R27,10,0)","v":0},{"$f":"IF(S27>0,\"Max Height:\",0)","v":0},{"$f":"IF(S27>0,F11,0)","v":0},{"$f":"IF(AND(S27>0,SHAPEW>0,SHAPEH>0,F12>0),1,0)","v":0},null,null,null,24,131,"131 (Equilateral Triangle)",null,null,null,{"$f":"IF(EXTLINK=2,EXTOFFSET-BM_3000,IF(EXTLINK=3,EXTOFFSET-BM_4000,0))","v":0},null,null,null,null,null,null,null,null,132,{"$f":"GW_132","v":0},{"$f":"GH_132","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,110,{"$f":"IF(SHAPE=R28,11,0)","v":0},{"$f":"IF(S28>0,\"Max UI:\",0)","v":0},{"$f":"IF(S28>0,E11,0)","v":0},{"$f":"IF(AND(S28>0,SHAPEW>0,SHAPEH>0,E12>0),1,0)","v":0},null,null,null,25,132,"132 (Isosceles Triangle)",null,null,null,null,null,null,null,null,null,null,null,null,140,{"$f":"GW_140","v":0},{"$f":"GH_140","v":0},{"$f":"(AP28*AQ28)/144","v":0}]
[null,112,"Min R","Max W","Max UI","Max H","Min Leg",null,"Frame Height:",{"$f":"IF(AND(SHAPEW>0,SHAPE=B29,SHAPEH>0),SHAPEH,0)","v":0},null,null,null,null,null,null,null,110,{"$f":"IF(AND(BM_SELECT>1,SHAPE=R29),12,0)","v":0},{"$f":"IF(S29>0,\"Brickmould Width:\",0)","v":0},{"$f":"IF(S29>0,J16,0)","v":0},null,null,null,null,26,140,"140 (Operating Cathidral)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SHAPE","v":"Select"},{"$f":"IF(AND(SHAPELINK>1,SHAPEW>0),VLOOKUP(SHAPE,GLASSCHART,2,FALSE),0)","v":0},{"$f":"IF(AND(SHAPELINK>1,SHAPEW>0),VLOOKUP(SHAPE,GLASSCHART,3,FALSE),0)","v":0},{"$f":"IF(AND(SHAPELINK>1,SHAPEW>0),VLOOKUP(SHAPE,GLASSCHART,4,FALSE),0)","v":0}]
[null,{"$f":"EXT","v":1},{"$f":"MIN_R","v":""},{"$f":"MAX_W","v":""},{"$f":"MAX_UI","v":""},{"$f":"MAX_H","v":""},6.25E-2,null,"Frame R:",{"$f":"IF(AND(SHAPEW>0,SHAPE=B29),SHAPEW,0)","v":0},"BM R:",{"$f":"IF(AND(SHAPEW>0,SHAPE=B29,SHAPEH>0),J30+((BM-BM_DEDUCT)),0)","v":0},null,null,{"$f":"VLOOKUP(B29,IMAGE_MODEL,2,FALSE)","v":{"$error":"#VALUE!"}},null,null,110,{"$f":"IF(AND(BM_SELECT>1,SHAPE=R29),13,0)","v":0},{"$f":"IF(S30>0,\"Brickmould Height:\",0)","v":0},{"$f":"IF(S30>0,J17,0)","v":0},null,null,null,null,1,{"$f":"VLOOKUP($Z$30,SHAPECHART,2,FALSE)","v":"Select"},{"$f":"VLOOKUP($Z$30,SHAPECHART,3,FALSE)","v":"Select"},{"$f":"IF(AND(SHAPELINK>1,OR($Z$30=14,$Z$30=16,$Z$30=18,$Z$30=19,$Z$30=22,$Z$30=26)),1,0)","v":0},{"$f":"IF(AND(SHAPELINK>1,OR($Z$30=7,$Z$30=9,$Z$30=18,$Z$30=21,$Z$30=26)),1,0)","v":0},null,null,"Glass Min. Max.",null,null,null,null,null,null,null,"Glass Options"]
[null,{"$f":"BM_DYE","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPE=B29,SHAPEW<C30),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=B29,SHAPEW>D30),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=B29,(SHAPEW+SHAPEH)>E30),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=B29,SHAPEH>D30),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPE=B29,(SHAPEH-SHAPEW)<G30),1,0)","v":0},null,"Glass R:",{"$f":"IF(AND(SHAPEW>0,SHAPE=B29),SHAPEW-OFFSET,0)","v":0},"BM W:",{"$f":"IF(AND(SHAPEW>0,SHAPE=B29,SHAPEH>0),SHAPEW+((BM-BM_DEDUCT)*2),0)","v":0},null,null,null,null,null,110,{"$f":"IF(AND(BM_SELECT>1,SHAPE=R29),14,0)","v":0},{"$f":"IF(S31>0,\"Brickmould Leg:\",0)","v":0},{"$f":"IF(S31>0,J15,0)","v":0},null,null,null,null,null,null,null,"DIM3","DIM4",null,null,"Glass Min Width",6,null,null,null,null,null,null,{"$f":"IF(AY10>\"\",AY10,IF(AY19>\"\",AY19,\"\"))","v":"≥SS Annealed"},null,{"$f":"IF(AND(OR(AY10=\"≥SS Annealed\",AY10=\"≥DS Annealed\",AY11=\"≥DS Tempered\",AY19=\"≥SS Annealed\",AY19=\"≥DS Annealed\",AY20=\"≥DS Tempered\"),OR(EXTLINK=5,PWSELECT>1)),\"TIG\",\"\")","v":""}]
[null,null,{"$f":"MAX(C31:G31)","v":0},{"$f":"IF(AND(SHAPE=B29,C32=1),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,SHAPE=112,SHAPEH<>(SHAPEW+DIM_4)),1,0)","v":0},{"$f":"IF(AND(SHAPE=112,E32=1),\"HEIGHT MUST BE EQUAL TO THE WIDTH + DIM4\",IF(AND(SHAPE=112,SHAPEW>0,C31>0),\"RADIUS MUST BE GREATER THAN \"&C30,IF(AND(SHAPE=112,J32>0,J32<GlassMinW),\"Glass Width is Under Minimum\",IF(AND(SHAPE=112,J33>0,J33<GlassMinH),\"Glass Height is Under Minimum\",\"\"))))","v":""},null,null,"Glass W:",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=B29),SHAPEW-(OFFSET*2),0)","v":0},"BM H:",{"$f":"IF(AND(SHAPEW>0,SHAPE=B29,SHAPEH>0),SHAPEH+((BM-BM_DEDUCT)*2),0)","v":0},null,null,null,null,null,110,{"$f":"IF(AND(BM_SELECT>1,SHAPE=R29),15,0)","v":0},{"$f":"IF(S32>0,\"Brickmould Radius:\",0)","v":0},{"$f":"IF(S32>0,J18,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Glass Min Height",6,null,null,null,null,null,null,{"$f":"IF(AY11>\"\",AY11,IF(AY20>\"\",AY20,\"\"))","v":"≥DS Tempered"}]
[null,null,null,null,null,null,null,null,"Glass H:",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=B29,SHAPEH>0),SHAPEH-(OFFSET*2)-J37,0)","v":0},"BM LEG:",{"$f":"IF(AND(SHAPEW>0,SHAPE=B29,SHAPEH>0),(SHAPEH-SHAPEW)+(BM-BM_DEDUCT),0)","v":0},null,null,null,null,null,111,{"$f":"IF(SHAPE=R33,1,0)","v":0},{"$f":"IF(S33>0,\"Frame Width:\",0)","v":0},{"$f":"IF(S33>0,SHAPEW,0)","v":0},{"$f":"IF(AND(S33>0,SHAPEW>0,D22>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,"Glass Leg H:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=B29,OFFSET>0),(SHAPEH-SHAPEW)-OFFSET,0)","v":0},null,null,null,null,null,null,null,111,{"$f":"IF(SHAPE=R34,2,0)","v":0},{"$f":"IF(S34>0,\"Frame Height:\",0)","v":0},{"$f":"IF(S34>0,I20,0)","v":0},{"$f":"IF(AND(S34>0,SHAPEW>0,D22>0),1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Model","Width","Height","Area"]
[null,null,null,null,null,null,null,{"$f":"IF(AND(SHAPEW>0,SHAPE=B29,SHAPEH>0),2*(ASIN(((BM-BM_DEDUCT)*2)/(2*L30))),0)","v":0},"F",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=B29),2*(ASIN((OFFSET*2)/(2*J31))),0)","v":0},null,null,null,null,null,null,null,111,{"$f":"IF(SHAPE=R35,3,0)","v":0},{"$f":"IF(S35>0,\"Frame Radius:\",0)","v":0},{"$f":"IF(S35>0,I21,0)","v":0},{"$f":"IF(AND(S35>0,SHAPEW>0,C22>0),1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Select"]
[null,null,null,null,null,null,null,{"$f":"IF(AND(SHAPEW>0,SHAPE=B29,SHAPEH>0),L30*COS(H35/2),0)","v":0},"d",{"$f":"IF(AND(SHAPEW>0,SHAPE=B29),J31*COS(J35/2),0)","v":0},null,null,null,null,null,null,null,111,{"$f":"IF(SHAPE=R36,4,0)","v":0},{"$f":"IF(S36>0,\"Glass Radius:\",0)","v":0},{"$f":"IF(S36>0,I22,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"0504",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0),SHAPEW-4.625,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0),SHAPEH-4.625,0)","v":0},{"$f":"(AP36*AQ36)/144","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(AND(SHAPEW>0,SHAPE=B29,SHAPEH>0),L30-H36,0)","v":0},"h",{"$f":"J31-J36","v":0},null,null,null,null,null,null,null,111,{"$f":"IF(SHAPE=R37,5,0)","v":0},{"$f":"IF(S37>0,\"Glass Width:\",0)","v":0},{"$f":"IF(S37>0,I23,0)","v":0},{"$f":"IF(AND(S37>0,SHAPEW>0,GW_111<GlassMinW),1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"0614",0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,111,{"$f":"IF(SHAPE=R38,6,0)","v":0},{"$f":"IF(S38>0,\"Glass Height:\",0)","v":0},{"$f":"IF(S38>0,I23,0)","v":0},{"$f":"IF(AND(U38>0,SHAPEW>0,GW_111<GlassMinH),1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"0970",0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,111,{"$f":"IF(SHAPE=R39,7,0)","v":0},{"$f":"IF(S39>0,\"Max Width:\",0)","v":0},{"$f":"IF(S39>0,D21,0)","v":0},{"$f":"IF(AND(S39>0,SHAPEW>0,D22>0),1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"8014",0,0,0]
[null,113,"Min R","Max W","Max UI","Max Sq.ft","Cut L","Min H","Frame Radius",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=B40),((SHAPEW/2)^2+SHAPEH^2)/(2*SHAPEH),0)","v":0},null,null,null,null,{"$f":"VLOOKUP(B40,IMAGE_MODEL,2,FALSE)","v":{"$error":"#VALUE!"}},null,null,111,{"$f":"IF(SHAPE=R40,8,0)","v":0},{"$f":"IF(S40>0,\"Max sq.ft.:\",0)","v":0},{"$f":"IF(S40>0,F21,0)","v":0},{"$f":"IF(AND(S40>0,SHAPEW>0,F22>0),1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"8070",0,0,0]
[null,{"$f":"EXT","v":1},{"$f":"MIN_R","v":""},{"$f":"MAX_W","v":""},{"$f":"MAX_UI","v":""},{"$f":"MAX_SF","v":""},{"$f":"CUT_LENGTH","v":""},{"$f":"MIN_H","v":""},"Glass Radius",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=B40),J40-OFFSET,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=B40),J40-EXTOFFSET,0)","v":0},"BM R:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=B40),J40+((BM-BM_DEDUCT)),0)","v":0},null,null,null,null,111,{"$f":"IF(AND(BM_SELECT>1,SHAPE=R41),9,0)","v":0},{"$f":"IF(S41>0,\"Brickmould Width:\",0)","v":0},{"$f":"IF(S41>0,K22,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"9014",0,0,0]
[null,{"$f":"BM_DYE","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=B40,J40<C41),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=B40,SHAPEW>D41),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPEH>0,SHAPE=B40,(SHAPEW+SHAPEH)>E41),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPEH>0,SHAPE=B40,((SHAPEW*SHAPEH)/144)>F41),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPE=B40,SHAPEH>0,J45>G41),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=113,SHAPEH<H41),1,0)","v":0},"Glass Height",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=B40),SHAPEH-(2*OFFSET),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,SHAPE=113),SHAPEH-(2*EXTOFFSET),0)","v":0},"BM W:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=B40),2*(SQRT(M43*((2*M41)-M43))),0)","v":0},null,null,null,null,111,{"$f":"IF(AND(BM_SELECT>1,SHAPE=R42),10,0)","v":0},{"$f":"IF(S42>0,\"Brickmould Height:\",0)","v":0},{"$f":"IF(S42>0,K23,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"9070",0,0,0]
[null,null,{"$f":"MAX(C42:H42)","v":0},{"$f":"IF(AND(SHAPE=B40,C43=1),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=113,SHAPEH>=(SHAPEW/2)),1,0)","v":0},{"$f":"IF(AND(SHAPE=113,E43=1),\"FRAME HEIGHT MUST BE LESS THAN 1/2 THE WIDTH\",IF(AND(SHAPE=113,SHAPEW>0,C42>0),\"RADIUS MUST BE GREATER THAN \"&C41,IF(AND(SHAPE=113,J43>0,J43<GlassMinW),\"Glass Width is Under Minimum\",IF(AND(SHAPE=113,J42>0,J42<GlassMinH),\"Glass Height is Under Minimum\",\"\"))))","v":""},null,null,"Glass Width",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=B40),2*(SQRT(J42*((2*J41)-J42))),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=B40),2*(SQRT(K42*((2*K41)-K42))),0)","v":0},"BM H:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=B40),SHAPEH+(2*(BM-BM_DEDUCT)),0)","v":0},null,null,null,null,111,{"$f":"IF(AND(BM_SELECT>1,SHAPE=R43),11,0)","v":0},{"$f":"IF(S43>0,\"Brickmould Radius:\",0)","v":0},{"$f":"IF(S43>0,K21,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AND(PWSELECT>1,SHAPEW>0,SHAPEH>0),VLOOKUP(PWSELECT,PWTABLE,2,FALSE),0)","v":0},{"$f":"IF(AND(PWSELECT>1,SHAPEW>0,SHAPEH>0),VLOOKUP(PWSELECT,PWTABLE,3,FALSE),0)","v":0},{"$f":"IF(AND(PWSELECT>1,SHAPEW>0,SHAPEH>0),VLOOKUP(PWSELECT,PWTABLE,4,FALSE),0)","v":0},{"$f":"IF(AND(PWSELECT>1,SHAPEW>0,SHAPEH>0),VLOOKUP(PWSELECT,PWTABLE,5,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,"Angle of cut",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=B40),DEGREES(ATAN(EXTOFFSET/((SHAPEW-K43)/2))),0)","v":0},null,null,null,null,null,null,null,112,{"$f":"IF(SHAPE=R44,1,0)","v":0},{"$f":"IF(S44>0,\"Frame Width:\",0)","v":0},{"$f":"IF(S44>0,SHAPEW,0)","v":0},{"$f":"IF(AND(S44>0,SHAPEW>0,SHAPEH>0,D31>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,"Cut Length",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=B40),SQRT(EXTOFFSET^2+((SHAPEW-K43)/2)^2),0)","v":0},null,null,null,null,null,null,null,112,{"$f":"IF(SHAPE=R45,2,0)","v":0},{"$f":"IF(S45>0,\"Frame Height:\",0)","v":0},{"$f":"IF(S45>0,J29,0)","v":0},{"$f":"IF(AND(S45>0,SHAPEW>0,SHAPEH>0,F31>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,"Arc Length:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=B40),J40*(2*(ASIN(SHAPEW/(2*J40)))),0)","v":0},null,null,null,null,null,null,null,112,{"$f":"IF(SHAPE=R46,3,0)","v":0},{"$f":"IF(S46>0,\"Frame Radius:\",0)","v":0},{"$f":"IF(S46>0,J30,0)","v":0},{"$f":"IF(AND(S46>0,SHAPEW>0,SHAPEH>0,C31>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,112,{"$f":"IF(SHAPE=R47,4,0)","v":0},{"$f":"IF(S47>0,\"Frame Leg:\",0)","v":0},{"$f":"IF(AND(S47>0,SHAPEH>0,SHAPEW>0,EXTLINK>1),SHAPEH-SHAPEW,0)","v":0},{"$f":"IF(AND(S47>0,SHAPEW>0,SHAPEH>0,OR(G31>0,U47<=0)),1,0)","v":0}]
[null,114,"Min R","Max W","Max H","Max UI","Min Leg","Cut L","Frame Radius",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,SHAPE=B48),((SHAPEW/2)^2+(SHAPEH-DIM_4)^2)/(2*(SHAPEH-DIM_4)),0)","v":0},null,null,null,null,{"$f":"VLOOKUP(B48,IMAGE_MODEL,2,FALSE)","v":{"$error":"#VALUE!"}},null,null,112,{"$f":"IF(SHAPE=R48,5,0)","v":0},{"$f":"IF(S48>0,\"Glass Radius:\",0)","v":0},{"$f":"IF(S48>0,J31,0)","v":0}]
[null,{"$f":"EXT","v":1},{"$f":"MIN_R","v":""},{"$f":"MAX_W","v":""},{"$f":"MAX_H","v":""},{"$f":"MAX_UI","v":""},{"$f":"MIN_LEG","v":""},{"$f":"CUT_LENGTH","v":""},"Glass Radius",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,OFFSET>0,SHAPE=B48),J48-OFFSET,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,OFFSET>0,SHAPE=B48),J48-EXTOFFSET,0)","v":0},"BM R",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,SHAPE=B48),J48+((BM-BM_DEDUCT)),0)","v":0},null,null,null,null,112,{"$f":"IF(SHAPE=R49,6,0)","v":0},{"$f":"IF(S49>0,\"Glass Width:\",0)","v":0},{"$f":"IF(S49>0,J32,0)","v":0},{"$f":"IF(AND(U49>0,SHAPEW>0,SHAPEH>0,GW_112<GlassMinW),1,0)","v":0}]
[null,{"$f":"BM_DYE","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=B48,J48<C49),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPEH>0,SHAPE=B48,OR(SHAPEW>D49,SHAPEH>D49)),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPEH>0,SHAPE=B48,SHAPEH>E49),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPEH>0,SHAPE=B48,DIM_4>0,(SHAPEW+SHAPEH)>F49),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=B48,DIM_4>0,J56<G49),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPE=B48,SHAPEH>0,OR(J53>H49,J54>H49)),1,0)","v":0},"Glass Height",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,OFFSET>0,SHAPE=B48),SHAPEH-(2*OFFSET),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,OFFSET>0,SHAPE=B48),SHAPEH-(2*EXTOFFSET),0)","v":0},"BM W",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,SHAPE=B48),SHAPEW+(2*(BM-BM_DEDUCT)),0)","v":0},null,null,null,null,112,{"$f":"IF(SHAPE=R50,7,0)","v":0},{"$f":"IF(S50>0,\"Glass Height:\",0)","v":0},{"$f":"IF(S50>0,J33,0)","v":0},{"$f":"IF(AND(U50>0,SHAPEW>0,SHAPEH>0,GH_112<GlassMinH),1,0)","v":0}]
[null,null,{"$f":"MAX(C50:H50)","v":0},{"$f":"IF(AND(SHAPE=B48,C51=1),1,0)","v":0},null,{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=B48,(SHAPEH-J56)>=(SHAPEW/2)),1,0)","v":0},{"$f":"IF(AND(SHAPE=114,F51=1),\"FRAME HEIGHT MINUS DIM4 MUST BE LESS THAN 1/2 THE WIDTH\",IF(AND(SHAPE=114,SHAPEW>0,C50>0),\"RADIUS MUST BE GREATER THAN \"&C49,IF(AND(SHAPE=114,J51>0,J51<GlassMinW),\"Glass Width is Under Minimum\",IF(AND(SHAPE=114,J50>0,J50<GlassMinH),\"Glass Height is Under Minimum\",IF(AND(SHAPE=114,J56>157),\"Arc Length Must be Less than 157 inch\",\"\")))))","v":""},null,"Glass Width",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,OFFSET>0,SHAPE=B48),SHAPEW-(2*OFFSET),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,OFFSET>0,SHAPE=B48),SHAPEW-(2*EXTOFFSET),0)","v":0},"BM H",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,SHAPE=B48),SHAPEH+(2*(BM-BM_DEDUCT)),0)","v":0},null,null,null,null,112,{"$f":"IF(SHAPE=R51,8,0)","v":0},{"$f":"IF(S51>0,\"Glass Leg Height:\",0)","v":0},{"$f":"IF(S51>0,J34,0)","v":0}]
[null,null,null,null,null,null,null,null,"Glass Leg Height",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,DIM_4>0,SHAPE=114),DIM_4-(OFFSET+((J48*COS((2*(ASIN(SHAPEW/(2*J48))))/2))-(J49*COS((2*(ASIN((SHAPEW-(2*OFFSET))/(2*J49))))/2)))),0)","v":0},{"$f":"IF(AND(SHAPEW>0,OFFSET>0,DIM_4>0,SHAPE=114),DIM_4-(EXTOFFSET+((J48*COS((2*(ASIN(SHAPEW/(2*J48))))/2))-(K49*COS((2*(ASIN((SHAPEW-(2*EXTOFFSET))/(2*K49))))/2)))),0)","v":0},"BM LEG",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,SHAPE=B48),DIM_4+(BM-BM_DEDUCT)+M55,0)","v":0},null,null,null,null,112,{"$f":"IF(SHAPE=R52,9,0)","v":0},{"$f":"IF(S52>0,\"Max Width:\",0)","v":0},{"$f":"IF(S52>0,D30,0)","v":0},{"$f":"IF(AND(S52>0,SHAPEW>0,SHAPEH>0,D31>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,"Cut L @ Sill & Vert",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,OFFSET>0,SHAPE=114),SQRT(EXTOFFSET^2+((SHAPEW-K51)/2)^2),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,OFFSET>0,SHAPE=114),SQRT(EXTOFFSET^2+((SHAPEW-K51)/2)^2),0)","v":0},"d (Frame)",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,SHAPE=B48),SQRT(J48^2-(SHAPEW/2)^2),0)","v":0},null,null,null,null,112,{"$f":"IF(SHAPE=R53,10,0)","v":0},{"$f":"IF(S53>0,\"Max Height:\",0)","v":0},{"$f":"IF(S53>0,F30,0)","v":0},{"$f":"IF(AND(S53>0,SHAPEW>0,SHAPEH>0,F31>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,"Cut L @ Leg & Arc:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,OFFSET>0,SHAPE=114),SQRT(EXTOFFSET^2+((DIM_4-EXTOFFSET)-K52)^2),0)","v":0},null,"d (BM)",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,SHAPE=B48),SQRT(M49^2-(M50/2)^2),0)","v":0},null,null,null,null,112,{"$f":"IF(SHAPE=R54,11,0)","v":0},{"$f":"IF(S54>0,\"Max UI:\",0)","v":0},{"$f":"IF(S54>0,E30,0)","v":0},{"$f":"IF(AND(S54>0,SHAPEW>0,SHAPEH>0,E31>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,"Angle of Cut @ Leg & Arc:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,OFFSET>0,SHAPE=114),DEGREES(ACOS(EXTOFFSET/J54)),0)","v":0},null,null,{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,SHAPE=B48),M54-M53,0)","v":0},null,null,null,null,112,{"$f":"IF(AND(SHAPE=R55,BM_SELECT>1),12,0)","v":0},{"$f":"IF(S55>0,\"Brickmould Width:\",0)","v":0},{"$f":"IF(S55>0,L31,0)","v":0}]
[null,null,null,null,null,null,null,null,"Arc Length:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,OFFSET>0,SHAPE=114),J48*(2*(ASIN(SHAPEW/(2*J48)))),0)","v":0},null,null,null,null,null,null,null,112,{"$f":"IF(AND(SHAPE=R56,BM_SELECT>1),13,0)","v":0},{"$f":"IF(S56>0,\"Brickmould Height:\",0)","v":0},{"$f":"IF(S56>0,L32,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,112,{"$f":"IF(AND(SHAPE=R57,BM_SELECT>1),14,0)","v":0},{"$f":"IF(S57>0,\"Brickmould Leg:\",0)","v":0},{"$f":"IF(S57>0,L33,0)","v":0}]
[null,115,"Min R","Max W","Min Leg","Max UI","Cut L","Max H","Min H",null,null,null,null,null,null,null,null,112,{"$f":"IF(AND(SHAPE=R58,BM_SELECT>1),15,0)","v":0},{"$f":"IF(S58>0,\"Brickmould Radius:\",0)","v":0},{"$f":"IF(S58>0,L30,0)","v":0}]
[null,{"$f":"EXT","v":1},{"$f":"MIN_R","v":""},{"$f":"MAX_W","v":""},{"$f":"MIN_LEG","v":""},{"$f":"MAX_UI","v":""},{"$f":"CUT_LENGTH","v":""},{"$f":"MAX_H","v":""},{"$f":"MIN_H1","v":""},null,null,null,null,null,null,null,null,113,{"$f":"IF(SHAPE=R59,1,0)","v":0},{"$f":"IF(S59>0,\"Frame Width:\",0)","v":0},{"$f":"IF(AND(S59>0,EXTLINK>3),TRUNC((2*(SQRT((U60*((2*J40)-U60)))))*16+0.5)/16,IF(AND(S59>0,EXTLINK>1,EXTLINK<=3),SHAPEW,0))","v":0},{"$f":"IF(AND(S59>0,SHAPEW>0,SHAPEH>0,D42>0),1,0)","v":0}]
[null,{"$f":"BM_DYE","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=B58,D63<C59),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=B58,SHAPEW>D59),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=B58,OR(SHAPEW<E59,SHAPEH<E59)),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPEH>0,SHAPE=B58,(SHAPEW+SHAPEH)>F59),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=B58,OR(H65>G59,H64>G59)),1,0)","v":0},{"$f":"IF(AND(SHAPEH>0,EXTLINK>1,SHAPE=115,SHAPEH>H59),1,0)","v":0},{"$f":"IF(AND(SHAPEH>0,EXTLINK>1,SHAPE=115,OR(SHAPEH<I59,SHAPEW<I59)),1,0)","v":0},null,null,null,null,null,{"$f":"VLOOKUP(B58,IMAGE_MODEL,2,FALSE)","v":{"$error":"#VALUE!"}},null,null,113,{"$f":"IF(SHAPE=R60,2,0)","v":0},{"$f":"IF(S60>0,\"Frame Height:\",0)","v":0},{"$f":"IF(AND(S60>0,EXTLINK>3),TRUNC((SHAPEH-(2*BM))*16+0.5)/16,IF(AND(S60>0,EXTLINK>1,EXTLINK<=3),SHAPEH,0))","v":0},{"$f":"IF(AND(S60>0,SHAPEW>0,SHAPEH>0,OR(H42>0,E43>0)),1,0)","v":0}]
[null,null,{"$f":"MAX(C60:I60)","v":0},{"$f":"IF(AND(SHAPE=B58,C61=1),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPEH=SHAPEW),1,0)","v":0},{"$f":"IF(AND(SHAPE=115,E61=1),\"THIS IS A QUARTER ROUND\",IF(AND(SHAPE=115,SHAPEW>0,C60>0),\"RADIUS MUST BE GREATER THAN \"&C59,IF(AND(SHAPE=115,D65>0,D65<GlassMinW),\"Glass Width is Under Minimum\",IF(AND(SHAPE=115,D64>0,D64<GlassMinH),\"Glass Height is Under Minimum\",\"\"))))","v":""},null,null,null,null,null,null,null,null,null,null,null,113,{"$f":"IF(SHAPE=R61,3,0)","v":0},{"$f":"IF(S59>0,\"Frame Radius:\",0)","v":0},{"$f":"IF(S59>0,J40,0)","v":0},{"$f":"IF(AND(S61>0,SHAPEW>0,SHAPEH>0,C42>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,113,{"$f":"IF(SHAPE=R62,4,0)","v":0},{"$f":"IF(S60>0,\"Glass Radius:\",0)","v":0},{"$f":"IF(S60>0,J41,0)","v":0}]
[null,null,"Frame R",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=115),IF(SHAPEH>SHAPEW,(SHAPEW/2)+((SHAPEH*2)^2/(8*SHAPEW)),((SHAPEW)^2+SHAPEH^2)/(2*SHAPEH)),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=115),D63-EXTOFFSET,0)","v":0},null,"Cut Angle",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=115),IF(SHAPEW>SHAPEH,DEGREES(ATAN(EXTOFFSET/(SHAPEW-(E65+EXTOFFSET)))),DEGREES(ATAN(EXTOFFSET/(SHAPEH-(E64+EXTOFFSET))))),0)","v":0},null,null,null,null,null,null,null,null,null,113,{"$f":"IF(SHAPE=R63,5,0)","v":0},{"$f":"IF(S61>0,\"Glass Width:\",0)","v":0},{"$f":"IF(S61>0,J43,0)","v":0},{"$f":"IF(AND(U63>0,SHAPEW>0,SHAPEH>0,GW_113<GlassMinW),1,0)","v":0}]
[null,null,"Glass R",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=115),D63-OFFSET,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=115),IF(SHAPEW>SHAPEH,SHAPEH-((EXTOFFSET*2)+H68),SHAPEH-EXTOFFSET-SQRT(H65^2-EXTOFFSET^2)),0)","v":0},null,"CUT Length",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=115),SQRT(EXTOFFSET^2+((SHAPEW-(E65+EXTOFFSET))^2)),0)","v":0},null,null,null,null,null,null,null,null,null,113,{"$f":"IF(SHAPE=R64,6,0)","v":0},{"$f":"IF(S62>0,\"Glass Height:\",0)","v":0},{"$f":"IF(S62>0,J42,0)","v":0},{"$f":"IF(AND(U64>0,SHAPEW>0,SHAPEH>0,GH_113<GlassMinH),1,0)","v":0}]
[null,null,"Glass H",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=115),IF(SHAPEW>SHAPEH,SHAPEH-((OFFSET*2)+H67),((2*SQRT((D66+H67)*((2*D64)-(D66+H67))))/2)-OFFSET),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=115),IF(SHAPEW>SHAPEH,((2*SQRT((E64+H68)*((2*E63)-(E64+H68))))/2)-EXTOFFSET,SHAPEW-((EXTOFFSET*2)+H68)),0)","v":0},null,"Cut L @ Peak",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=115),SQRT((SHAPEH-EXTOFFSET-(IF(SHAPEW>SHAPEH,SHAPEH-((EXTOFFSET*2)+H68),((2*SQRT((E65+H68)*((2*E63)-(E65+H68))))/2)-EXTOFFSET)))^2+EXTOFFSET^2),0)","v":0},null,null,null,null,null,null,null,null,null,113,{"$f":"IF(SHAPE=R65,7,0)","v":0},{"$f":"IF(S63>0,\"Angle of Cut:\",0)","v":0},{"$f":"IF(S63>0,J44,0)","v":0},{"$f":"IF(AND(S65>0,SHAPEW>0,SHAPEH>0,U65<MIN_ANGLE),1,0)","v":0}]
[null,null,"Glass W",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=115),IF(SHAPEW>SHAPEH,((2*SQRT((D65+H67)*((2*D64)-(D65+H67))))/2)-OFFSET,SHAPEW-((OFFSET*2)+H67)),0)","v":0},null,null,"Cut Angle @ Peak",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=115),90-(DEGREES(ACOS(EXTOFFSET/H65))),0)","v":0},null,null,null,null,null,null,null,null,null,113,{"$f":"IF(SHAPE=R66,8,0)","v":0},{"$f":"IF(S64>0,\"Cut Length:\",0)","v":0},{"$f":"IF(S64>0,J45,0)","v":0},{"$f":"IF(AND(S66>0,SHAPEW>0,SHAPEH>0,G42>0),1,0)","v":0}]
[null,null,"BM W",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=115),((2*(SQRT(D68*((2*D69)-D68))))/2)+(BM-BM_DEDUCT),0)","v":0},null,null,"Difference Glass",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=115),D64-(D64*(COS((2*(ASIN((OFFSET*2)/(2*D64))))/2))),0)","v":0},null,null,null,null,null,null,null,null,null,113,{"$f":"IF(SHAPE=R67,9,0)","v":0},{"$f":"IF(S64>0,\"Min. Height:\",0)","v":0},{"$f":"IF(S65>0,H41,0)","v":0},{"$f":"IF(AND(S67>0,SHAPEW>0,SHAPEH>0,H42>0),1,0)","v":0}]
[null,null,"BM H",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=115),SHAPEH+((BM-BM_DEDUCT)*2),0)","v":0},null,null,"Difference Cut",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=115),E63-(E63*(COS((2*(ASIN((EXTOFFSET*2)/(2*E63))))/2))),0)","v":0},null,null,null,null,null,null,null,null,null,113,{"$f":"IF(SHAPE=R68,10,0)","v":0},{"$f":"IF(S66>0,\"Max Width:\",0)","v":0},{"$f":"IF(S66>0,D41,0)","v":0},{"$f":"IF(AND(S68>0,SHAPEW>0,SHAPEH>0,D42>0),1,0)","v":0}]
[null,null,"BM R",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=115),D63+((BM-BM_DEDUCT)),0)","v":0},null,null,"Difference BM",{"$f":"D69-(D69*(COS((2*(ASIN(((BM-BM_DEDUCT)*2)/(2*D69))))/2)))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,113,{"$f":"IF(SHAPE=R69,11,0)","v":0},{"$f":"IF(S67>0,\"Max UI:\",0)","v":0},{"$f":"IF(S67>0,E41,0)","v":0},{"$f":"IF(AND(S69>0,SHAPEW>0,SHAPEH>0,E42>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,113,{"$f":"IF(AND(SHAPE=R70,BM_SELECT>1),12,0)","v":0},{"$f":"IF(S70>0,\"Brickmould Width:\",0)","v":0},{"$f":"IF(S70>0,M42,0)","v":0}]
[null,116,"Min R","Max W","Max H","Max UI","Cut L","Dim. 4",null,null,null,null,null,null,null,null,null,113,{"$f":"IF(AND(SHAPE=R71,BM_SELECT>1),13,0)","v":0},{"$f":"IF(S71>0,\"Brickmould Height:\",0)","v":0},{"$f":"IF(S71>0,M43,0)","v":0}]
[null,{"$f":"EXT","v":1},{"$f":"MIN_R","v":""},{"$f":"MAX_W","v":""},{"$f":"MAX_H","v":""},{"$f":"MAX_UI","v":""},{"$f":"CUT_LENGTH","v":""},{"$f":"MIN_LEG","v":""},null,"BM R",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_4>0,SHAPE=B71),D76+((BM-BM_DEDUCT)),0)","v":0},"d(frame)",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_4>0,SHAPE=B71),D76-(SQRT(D76^2-(SHAPEW/2)^2)),0)","v":0},null,{"$f":"VLOOKUP(B71,IMAGE_MODEL,2,FALSE)","v":{"$error":"#VALUE!"}},null,null,113,{"$f":"IF(AND(SHAPE=R72,BM_SELECT>1),14,0)","v":0},{"$f":"IF(S72>0,\"Brickmould Radius:\",0)","v":0},{"$f":"IF(S72>0,M41,0)","v":0}]
[null,{"$f":"BM_DYE","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=116,D76<C72),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=116,SHAPEW>D72),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=116,SHAPEH>E72),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,SHAPE=116,(SHAPEW+SHAPEH)>F72),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=116,H78>G72),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPE=B71,H79<H72),1,0)","v":0},null,"BM W",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_4>0,SHAPE=B71),SHAPEW+(2*(BM-BM_DEDUCT)),0)","v":0},"d(BM)",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_4>0,SHAPE=B71),K72-(SQRT(K72^2-(K73/2)^2)),0)","v":0},null,null,null,null,114,{"$f":"IF(SHAPE=R73,1,0)","v":0},{"$f":"IF(S73>0,\"Frame Radius:\",0)","v":0},{"$f":"IF(S73>0,J48,0)","v":0},{"$f":"IF(AND(S73>0,SHAPEW>0,SHAPEH>0,DIM_4>0,C50>0),1,0)","v":0}]
[null,null,{"$f":"MAX(C73:H73)","v":0},{"$f":"IF(AND(SHAPE=B71,C74=1),1,0)","v":0},null,null,{"$f":"IF(AND(SHAPE=116,SHAPEW>0,C73>0),\"RADIUS MUST BE GREATER THAN \"&C72,IF(AND(SHAPE=116,D79>0,D79<GlassMinW),\"Glass Width is Under Minimum\",IF(AND(SHAPE=116,D78>0,D78<GlassMinH),\"Glass Height is Under Minimum\",IF(AND(SHAPE=116,SHAPEW>0,SHAPEH>0,DIM_4>0,SHAPEW=(SHAPEH-DIM_4)),\"This is a 1/4 Round with Extended Leg\",\"\"))))","v":""},null,null,"BM H",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_4>0,SHAPE=B71),SHAPEH+(2*(BM-BM_DEDUCT)),0)","v":0},null,{"$f":"M73-M72","v":0},null,null,null,null,114,{"$f":"IF(SHAPE=R74,2,0)","v":0},{"$f":"IF(S74>0,\"Frame Leg:\",0)","v":0},{"$f":"IF(S74>0,DIM_4,0)","v":0},{"$f":"IF(AND(S74>0,SHAPEW>0,SHAPEH>0,DIM_4>0,G50>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,"BM Leg",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_4>0,SHAPE=B71),DIM_4+((BM-BM_DEDUCT)+((K72*COS((2*(ASIN((K73*2)/(2*K72))))/2))-(D76*COS((2*(ASIN(((K73*2)-(2*(BM-BM_DEDUCT)))/(2*D76))))/2)))),0)","v":0},null,null,null,null,null,null,114,{"$f":"IF(SHAPE=R75,3,0)","v":0},{"$f":"IF(S75>0,\"Glass Radius:\",0)","v":0},{"$f":"IF(S75>0,J49,0)","v":0}]
[null,null,"Frame Radius",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_4>0,SHAPE=B71,SHAPEW>(SHAPEH-DIM_4)),(((SHAPEW*2)/2)^2+(SHAPEH-DIM_4)^2)/(2*(SHAPEH-DIM_4)),IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_4>0,SHAPE=B71,SHAPEW<=(SHAPEH-DIM_4)),(SHAPEW/2)+(((SHAPEH-DIM_4)*2)^2)/(8*SHAPEW),0))","v":0},null,null,"Angle @ Peak",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,OFFSET>0,SHAPE=116),90-(DEGREES(ACOS(EXTOFFSET/H78))),0)","v":0},null,null,null,null,null,null,null,null,null,114,{"$f":"IF(SHAPE=R76,4,0)","v":0},{"$f":"IF(S76>0,\"Glass Width:\",0)","v":0},{"$f":"IF(S76>0,GW_114,0)","v":0},{"$f":"IF(AND(U56>0,SHAPEW>0,SHAPEH>0,DIM_4>0,GW_114<GlassMinW),1,0)","v":0}]
[null,null,"Glass Radius",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_4>0,SHAPE=B71),D76-OFFSET,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_4>0,SHAPE=B71),D76-EXTOFFSET,0)","v":0},null,"Cut L @ Sill & Vert",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_4>0,SHAPE=B71),SQRT(EXTOFFSET^2+((SHAPEW-E79)/2)^2),0)","v":0},null,null,null,null,null,null,null,null,null,114,{"$f":"IF(SHAPE=R77,5,0)","v":0},{"$f":"IF(S77>0,\"Glass Height:\",0)","v":0},{"$f":"IF(S77>0,GH_114,0)","v":0},{"$f":"IF(AND(U57>0,SHAPEW>0,SHAPEH>0,DIM_4>0,GH_114<GlassMinH),1,0)","v":0}]
[null,null,"Glass Height",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_4>0,SHAPE=B71),SHAPEH-((OFFSET*2)+I80),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_4>0,SHAPE=B71),SHAPEH-((EXTOFFSET*2)+K80),0)","v":0},null,"Cut L @ Peak",{"$f":"IF(AND(SHAPEH>0,OFFSET>0,DIM_4>0,SHAPE=B71),SQRT(EXTOFFSET^2+(SHAPEH-(E78+EXTOFFSET))^2),0)","v":0},{"$f":"IF(AND(OFFSET>0,SHAPEW>0,SHAPEH>0,SHAPE=B71,SHAPEW>=(SHAPEH-DIM_4)),2*(ASIN((OFFSET*2)/(2*D77))),IF(AND(OFFSET>0,SHAPEW>0,SHAPEH>0,SHAPE=B71,SHAPEW<(SHAPEH-DIM_4)),2*(ASIN(((D77-D79)*2)/(2*D77))),0))","v":0},"F",{"$f":"IF(AND(OFFSET>0,SHAPEW>0,SHAPEH>0,SHAPE=B71,SHAPEW>=(SHAPEH-DIM_4)),2*(ASIN((EXTOFFSET*2)/(2*E77))),IF(AND(OFFSET>0,SHAPEW>0,SHAPEH>0,SHAPE=B71,SHAPEW<(SHAPEH-DIM_4)),2*(ASIN(((E77-E79)*2)/(2*E77))),0))","v":0},null,null,null,null,null,null,114,{"$f":"IF(SHAPE=R78,6,0)","v":0},{"$f":"IF(S78>0,\"Glass Leg:\",0)","v":0},{"$f":"IF(S78>0,J52,0)","v":0}]
[null,null,"Glass Width",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_4>0,SHAPE=B71),SHAPEW-(2*OFFSET),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_4>0,SHAPE=B71),SHAPEW-(2*EXTOFFSET),0)","v":0},null,"Cut Angle @ Leg & Arc",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,OFFSET>0,SHAPE=B71),DEGREES(ACOS(EXTOFFSET/H80)),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_4>0,SHAPE=B71),D77*COS(I78/2),0)","v":0},"d",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_4>0,SHAPE=B71),E77*COS(K78/2),0)","v":0},null,null,null,null,null,null,114,{"$f":"IF(SHAPE=R79,7,0)","v":0},{"$f":"IF(S79>0,\"Angle @ Sill & Leg:\",0)","v":0},{"$f":"IF(S79>0,45,0)","v":0}]
[null,null,"Glass Leg Height",{"$f":"IF(AND(SHAPEW>0,SHAPE=B71,DIM_4>0,OFFSET>0,SHAPEW>(SHAPEH-DIM_4)),DIM_4-(OFFSET+((D76*COS((2*(ASIN((SHAPEW*2)/(2*D76))))/2))-(D77*COS((2*(ASIN(((SHAPEW*2)-(2*OFFSET))/(2*D77))))/2)))),IF(AND(SHAPEW>0,SHAPE=B71,DIM_4>0,OFFSET>0,SHAPEW<=(SHAPEH-DIM_4)),DIM_4-OFFSET,0))","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPE=B71,DIM_4>0,OFFSET>0,SHAPEW>(SHAPEH-DIM_4)),DIM_4-(EXTOFFSET+((D76*COS((2*(ASIN((SHAPEW*2)/(2*D76))))/2))-(E77*COS((2*(ASIN(((SHAPEW*2)-(2*EXTOFFSET))/(2*E77))))/2)))),IF(AND(SHAPEW>0,SHAPE=B71,DIM_4>0,EXTOFFSET>0,SHAPEW<=(SHAPEH-DIM_4)),DIM_4-EXTOFFSET,0))","v":0},null,"Cut L @ Leg & Arc",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,OFFSET>0,SHAPE=B71),SQRT(EXTOFFSET^2+((DIM_4-EXTOFFSET)-E80)^2),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_4>0,SHAPE=B71,SHAPEW>=(SHAPEH-DIM_4)),D77-I79,IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_4>0,SHAPE=B71,SHAPEW<(SHAPEH-DIM_4)),(SHAPEH-DIM_4)-I79-OFFSET,0))","v":0},"h",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_4>0,SHAPE=B71,SHAPEW>=(SHAPEH-DIM_4)),E77-K79,IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_4>0,SHAPE=B71,SHAPEW<(SHAPEH-DIM_4)),(SHAPEH-DIM_4)-K79-EXTOFFSET,0))","v":0},null,null,null,null,null,null,114,{"$f":"IF(SHAPE=R80,8,0)","v":0},{"$f":"IF(S80>0,\"Cut L @ Sill & Leg:\",0)","v":0},{"$f":"IF(S80>0,J53,0)","v":0},{"$f":"IF(AND(S80>0,SHAPEW>0,SHAPEH>0,DIM_4>0,H50>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,114,{"$f":"IF(SHAPE=R81,9,0)","v":0},{"$f":"IF(S81>0,\"Angle @ Leg & Arc:\",0)","v":0},{"$f":"IF(S81>0,J55,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,114,{"$f":"IF(SHAPE=R82,10,0)","v":0},{"$f":"IF(S82>0,\"Cut L @ Leg & Arc:\",0)","v":0},{"$f":"IF(S82>0,J54,0)","v":0},{"$f":"IF(AND(S82>0,SHAPEW>0,SHAPEH>0,DIM_4>0,H50>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,114,{"$f":"IF(SHAPE=R83,11,0)","v":0},{"$f":"IF(S83>0,\"Max Width:\",0)","v":0},{"$f":"IF(S83>0,D41,0)","v":0},{"$f":"IF(AND(S83>0,SHAPEW>0,SHAPEH>0,DIM_4>0,SHAPEW>U83),1,0)","v":0}]
[null,117,"Min R","Max W","Max UI","Arc Length",null,"Peak R",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=117),SHAPEW/2-SHAPEH,0)","v":0},"Angle",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=117),ACOS((SHAPEW/2)/(I84+I85)),0)","v":0},null,null,null,{"$f":"VLOOKUP(B84,IMAGE_MODEL,2,FALSE)","v":{"$error":"#VALUE!"}},null,null,114,{"$f":"IF(SHAPE=R84,12,0)","v":0},{"$f":"IF(S84>0,\"Max Height:\",0)","v":0},{"$f":"IF(S84>0,E49,0)","v":0},{"$f":"IF(AND(S84>0,SHAPEW>0,SHAPEH>0,DIM_4>0,SHAPEH>U84),1,0)","v":0}]
[null,{"$f":"EXT","v":1},{"$f":"MIN_R","v":""},{"$f":"MAX_W","v":""},{"$f":"MAX_UI","v":""},157,null,"1/2 Hyp",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=117),(SQRT((SHAPEW/2)^2+SHAPEH^2))-I84,0)","v":0},"F",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=117),2*ACOS(((I87-OFFSET)-((I87-(OFFSET*2))))/(I87-OFFSET)),0)","v":0},null,null,null,null,null,null,114,{"$f":"IF(SHAPE=R85,13,0)","v":0},{"$f":"IF(S85>0,\"Max UI:\",0)","v":0},{"$f":"IF(S85>0,F49,0)","v":0},{"$f":"IF(AND(S85>0,SHAPEW>0,SHAPEH>0,DIM_4>0,F50>0),1,0)","v":0}]
[null,{"$f":"BM_DYE","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=B84,OR(I86<C85,I87<C85)),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=B84,SHAPEW>D85),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,SHAPE=B84,(SHAPEW+SHAPEH)>E85),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,SHAPE=B84,OR(D89>F85,D90>F85,D91>F85)),1,0)","v":0},null,"Frame Major R:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=117),SHAPEH+(((SHAPEW/2)-I87)/TAN(K84)),0)","v":0},null,null,null,null,null,null,null,null,114,{"$f":"IF(SHAPE=R86,14,0)","v":0},{"$f":"IF(S86>0,\"Arc Length:\",0)","v":0},{"$f":"IF(S86>0,J56,0)","v":0},{"$f":"IF(AND(S86>0,SHAPEW>0,SHAPEH>0,DIM_4>0,J56>157),1,0)","v":0}]
[null,null,{"$f":"MAX(C86:F86)","v":0},{"$f":"IF(AND(SHAPE=B84,C87=1),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,SHAPE=117,SHAPEH>=SHAPEW/2),1,0)","v":0},{"$f":"IF(AND(SHAPE=117,SHAPEW>0,C86>0),\"RADIUS MUST BE GREATER THAN \"&C85,IF(AND(SHAPE=117,J91>0,J91<GlassMinW),\"Glass Width is Under Minimum\",IF(AND(SHAPE=117,J92>0,J92<GlassMinH),\"Glass Height is Under Minimum\",\"\")))","v":""},null,"Frame Minor R:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=117),SQRT(((I85/2)*TAN(K84))^2+(I85/2)^2),0)","v":0},"BM W",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=117),SHAPEW+((BM-BM_DEDUCT)*2),0)","v":0},null,null,null,null,null,null,114,{"$f":"IF(AND(SHAPE=R87,BM_SELECT>1),15,0)","v":0},{"$f":"IF(S87>0,\"Brickmould Width:\",0)","v":0},{"$f":"IF(S87>0,M50,0)","v":0}]
[null,null,null,null,null,null,null,"Glass Width:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=117),SHAPEW-(2*(OFFSET+(((2*(I87-OFFSET))-(2*(I87-OFFSET)*(SIN(K85/2))))/2))),0)","v":0},"BM H",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=117),SHAPEH+((BM-BM_DEDUCT)*2),0)","v":0},null,null,null,null,null,null,114,{"$f":"IF(AND(SHAPE=R88,BM_SELECT>1),16,0)","v":0},{"$f":"IF(S88>0,\"Brickmould Height:\",0)","v":0},{"$f":"IF(S88>0,M51,0)","v":0}]
[null,null,"Major Arc Length:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0),((((SHAPEW/2)-(SQRT(((((SQRT((SHAPEW/2)^2+SHAPEH^2))-((SHAPEW/2)-SHAPEH))/2)*TAN((ACOS((SHAPEW/2)/(SQRT((SHAPEW/2)^2+SHAPEH^2))))))^2+(((SQRT((SHAPEW/2)^2+SHAPEH^2))-((SHAPEW/2)-SHAPEH))/2)^2)))/(TAN((ACOS((SHAPEW/2)/(SQRT((SHAPEW/2)^2+SHAPEH^2)))))))+SHAPEH)*((ACOS((SHAPEW/2)/(SQRT((SHAPEW/2)^2+SHAPEH^2))))*2),0)","v":0},null,null,null,"Glass Height:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=117),SHAPEH-(OFFSET*2),0)","v":0},"BM Major R",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=117),I86+(BM-BM_DEDUCT),0)","v":0},null,null,null,null,null,null,114,{"$f":"IF(AND(SHAPE=R89,BM_SELECT>1),17,0)","v":0},{"$f":"IF(S89>0,\"Brickmould Leg:\",0)","v":0},{"$f":"IF(S89>0,M52,0)","v":0}]
[null,null,"Minor Arc Length:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0),(SQRT(((((SQRT((SHAPEW/2)^2+SHAPEH^2))-((SHAPEW/2)-SHAPEH))/2)*TAN((ACOS((SHAPEW/2)/(SQRT((SHAPEW/2)^2+SHAPEH^2))))))^2+(((SQRT((SHAPEW/2)^2+SHAPEH^2))-((SHAPEW/2)-SHAPEH))/2)^2))*(2*(RADIANS(90-(DEGREES(ACOS((SHAPEW/2)/(SQRT((SHAPEW/2)^2+SHAPEH^2)))))))),0)","v":0},null,null,null,"Glass Major R:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=117),I86-OFFSET,0)","v":0},"BM Minor R",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=117),I87+(BM-BM_DEDUCT),0)","v":0},null,null,null,null,null,null,114,{"$f":"IF(AND(SHAPE=R90,BM_SELECT>1),18,0)","v":0},{"$f":"IF(S90>0,\"Brickmould Radius:\",0)","v":0},{"$f":"IF(S90>0,M49,0)","v":0}]
[null,null,"Arc Length:",{"$f":"D89+D90","v":0},null,null,null,"Glass Minor R:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=117),I87-OFFSET,0)","v":0},null,null,null,null,null,null,null,null,115,{"$f":"IF(SHAPE=R91,1,0)","v":0},{"$f":"IF(S91>0,\"Frame Radius:\",0)","v":0},{"$f":"IF(S91>0,D63,0)","v":0},{"$f":"IF(AND(S91>0,SHAPEW>0,SHAPEH>0,C60>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,115,{"$f":"IF(SHAPE=R92,2,0)","v":0},{"$f":"IF(S92>0,\"Glass Radius:\",0)","v":0},{"$f":"IF(S92>0,D64,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,115,{"$f":"IF(SHAPE=R93,3,0)","v":0},{"$f":"IF(S93>0,\"Glass Width:\",0)","v":0},{"$f":"IF(S93>0,GW_115,0)","v":0},{"$f":"IF(AND(U93>0,SHAPEW>0,SHAPEH>0,GW_115<GlassMinW),1,0)","v":0}]
[null,118,"Min R","Max W","Max UI",null,null,null,null,null,null,null,null,null,null,null,null,115,{"$f":"IF(SHAPE=R94,4,0)","v":0},{"$f":"IF(S94>0,\"Glass Height:\",0)","v":0},{"$f":"IF(S94>0,GH_115,0)","v":0},{"$f":"IF(AND(U94>0,SHAPEW>0,SHAPEH>0,GH_115<GlassMinH),1,0)","v":0}]
[null,{"$f":"EXT","v":1},{"$f":"MIN_R","v":""},{"$f":"MAX_W","v":""},{"$f":"MAX_UI","v":""},null,null,"Frame Height:",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=118),SHAPEW,0)","v":0},"BM W",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=118),SHAPEW+((BM-BM_DEDUCT)*2),0)","v":0},null,null,null,{"$f":"VLOOKUP(B94,IMAGE_MODEL,2,FALSE)","v":{"$error":"#VALUE!"}},null,null,115,{"$f":"IF(SHAPE=R95,5,0)","v":0},{"$f":"IF(S95>0,\"Angle @ Sill & Arc:\",0)","v":0},{"$f":"IF(S95>0,H63,0)","v":0}]
[null,{"$f":"BM_DYE","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPE=118,(SHAPEW/2)<C95),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=118,SHAPEW>D95),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPE=118,EXTLINK>1,(SHAPEW+SHAPEH)>E95),1,0)","v":0},null,null,"Glass Width:",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=118),SHAPEW-(OFFSET*2),0)","v":0},"BM H",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=118),SHAPEH+((BM-BM_DEDUCT)*2),0)","v":0},null,null,null,null,null,null,115,{"$f":"IF(SHAPE=R96,6,0)","v":0},{"$f":"IF(S96>0,\"Cut L @ Sill & Arc:\",0)","v":0},{"$f":"IF(S96>0,H64,0)","v":0},{"$f":"IF(AND(S96>0,SHAPEW>0,SHAPEH>0,G60>0),1,0)","v":0}]
[null,null,{"$f":"MAX(C96:F96)","v":0},{"$f":"IF(AND(SHAPE=B94,C97=1),1,0)","v":0},null,{"$f":"IF(AND(SHAPE=118,SHAPEW>0,C96>0),\"RADIUS MUST BE GREATER THAN\"&\" \"&C95,IF(AND(SHAPE=118,SHAPEW>0,SHAPEH>0,SHAPEW<>SHAPEH),\"WIDTH AND HEIGHT MUST BE EQUAL\",IF(AND(SHAPE=118,I96>0,I96<GlassMinW),\"Glass Width is Under Minimum\",IF(AND(SHAPE=118,I97>0,I97<GlassMinH),\"Glass Height is Under Minimum\",\"\"))))","v":""},null,"Glass Height:",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=118),SHAPEW-(OFFSET*2),0)","v":0},"BM R",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=118),I98+(BM-BM_DEDUCT),0)","v":0},null,null,null,null,null,null,115,{"$f":"IF(SHAPE=R97,7,0)","v":0},{"$f":"IF(S97>0,\"Angle @ Peak:\",0)","v":0},{"$f":"IF(S97>0,H66,0)","v":0}]
[null,null,null,null,null,null,null,"Frame Radius:",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=118),SHAPEW/2,0)","v":0},null,null,null,null,null,null,null,null,115,{"$f":"IF(SHAPE=R98,8,0)","v":0},{"$f":"IF(S98>0,\"Cut L @ Peak:\",0)","v":0},{"$f":"IF(S98>0,H65,0)","v":0},{"$f":"IF(AND(S98>0,SHAPEW>0,SHAPEH>0,G60>0),1,0)","v":0}]
[null,null,null,null,null,null,null,"Glass Radius:",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=118),(SHAPEW/2)-OFFSET,0)","v":0},null,null,null,null,null,null,null,null,115,{"$f":"IF(SHAPE=R99,9,0)","v":0},{"$f":"IF(S99>0,\"Min Height:\",0)","v":0},{"$f":"IF(S99>0,I59,0)","v":0},{"$f":"IF(AND(S99>0,SHAPEW>0,SHAPEH>0,SHAPEH<U99),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,115,{"$f":"IF(SHAPE=R100,10,0)","v":0},{"$f":"IF(S100>0,\"Max Width:\",0)","v":0},{"$f":"IF(S100>0,D59,0)","v":0},{"$f":"IF(AND(S100>0,SHAPEW>0,SHAPEH>0,SHAPEW>U100),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,115,{"$f":"IF(SHAPE=R101,11,0)","v":0},{"$f":"IF(S101>0,\"Max Height:\",0)","v":0},{"$f":"IF(S101>0,H59,0)","v":0},{"$f":"IF(AND(S101>0,SHAPEW>0,SHAPEH>0,SHAPEH>U101),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,115,{"$f":"IF(SHAPE=R102,12,0)","v":0},{"$f":"IF(S102>0,\"Max UI:\",0)","v":0},{"$f":"IF(S102>0,F59,0)","v":0},{"$f":"IF(AND(S102>0,SHAPEW>0,SHAPEH>0,F60>0),1,0)","v":0}]
[null,119,"Min R","Max W","Max H","Max UI","Max sq.ft",null,"Peak R",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=119),SHAPEW/2-(SHAPEH/2),0)","v":0},"Angle",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=119),ACOS((SHAPEW/2)/(J103+J104)),0)","v":0},null,null,null,null,null,115,{"$f":"IF(AND(SHAPE=R103,BM_SELECT>1),13,0)","v":0},{"$f":"IF(S103>0,\"Brickmould Width:\",0)","v":0},{"$f":"IF(S103>0,D67,0)","v":0}]
[null,{"$f":"EXT","v":1},{"$f":"MIN_R","v":""},{"$f":"MAX_W","v":""},{"$f":"MAX_H","v":""},{"$f":"MAX_UI","v":""},{"$f":"MAX_SF","v":""},null,"1/2 Hyp",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=119),(SQRT((SHAPEW/2)^2+(SHAPEH/2)^2))-J103,0)","v":0},"F",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=119),2*ACOS(((J106-OFFSET)-((J106-(OFFSET*2))))/(J106-OFFSET)),0)","v":0},null,null,{"$f":"VLOOKUP(B103,IMAGE_MODEL,2,FALSE)","v":{"$error":"#VALUE!"}},null,null,115,{"$f":"IF(AND(SHAPE=R104,BM_SELECT>1),14,0)","v":0},{"$f":"IF(S104>0,\"Brickmould Height:\",0)","v":0},{"$f":"IF(S104>0,D68,0)","v":0}]
[null,{"$f":"BM_DYE","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPE=119,OR(J105<C104,J106<C104)),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=119,SHAPEW>D104),1,0)","v":0},{"$f":"IF(AND(SHAPEH>0,EXTLINK>1,SHAPE=119,SHAPEH>E104),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=119,EXTLINK>1,(FM8+SHAPEH)>F104),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=119,EXTLINK>1,((SHAPEW*SHAPEH)/144)>G104),1,0)","v":0},null,"Frame Major R:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=119),(SHAPEH/2)+(((SHAPEW/2)-J106)/TAN(L103)),0)","v":0},null,null,null,null,null,null,null,115,{"$f":"IF(AND(SHAPE=R105,BM_SELECT>1),15,0)","v":0},{"$f":"IF(S105>0,\"Brickmould Radius:\",0)","v":0},{"$f":"IF(S105>0,D69,0)","v":0}]
[null,null,{"$f":"MAX(C105:G105)","v":0},{"$f":"IF(AND(SHAPE=B103,C106=1),1,0)","v":0},null,{"$f":"IF(AND(SHAPE=119,SHAPEW>0,C105>0),\"RADIUS MUST BE GREATER THAN \"&C104,IF(AND(SHAPE=119,SHAPEW>0,SHAPEH>0,SHAPEW=SHAPEH),\"THIS IS A CIRCLE\",IF(AND(SHAPE=119,U151>0,U151<GlassMinW),\"Glass Width is Under Minimum\",IF(AND(SHAPE=119,U152>0,U152<GlassMinH),\"Glass Height is Under Minimum\",\"\"))))","v":""},null,null,"Frame Minor R:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=119),SQRT(((J104/2)*TAN(L103))^2+(J104/2)^2),0)","v":0},"BM W",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=119),SHAPEW+((BM-BM_DEDUCT)*2),0)","v":0},null,null,null,null,null,116,{"$f":"IF(SHAPE=R106,1,0)","v":0},{"$f":"IF(S106>0,\"Frame Radius:\",0)","v":0},{"$f":"IF(S106>0,D76,0)","v":0},{"$f":"IF(AND(S106>0,C73>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,"Glass Width:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=119),SHAPEW-(2*OFFSET),0)","v":0},"BM H",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=119),SHAPEH+((BM-BM_DEDUCT)*2),0)","v":0},null,null,null,null,null,116,{"$f":"IF(SHAPE=R107,2,0)","v":0},{"$f":"IF(S107>0,\"Frame Leg:\",0)","v":0},{"$f":"IF(S107>0,DIM_4,0)","v":0},{"$f":"IF(AND(S107>0,H73>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,"Glass Height:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=119),SHAPEH-(2*OFFSET),0)","v":0},"BM Major R",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=119),J105+(BM-BM_DEDUCT),0)","v":0},null,null,null,null,null,116,{"$f":"IF(SHAPE=R108,3,0)","v":0},{"$f":"IF(S108>0,\"Glass Radius:\",0)","v":0},{"$f":"IF(S108>0,D77,0)","v":0}]
[null,null,null,null,null,null,null,null,"Glass Major R:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=119),J105-OFFSET,0)","v":0},"BM Minor R",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=119),J106+(BM-BM_DEDUCT),0)","v":0},null,null,null,null,null,116,{"$f":"IF(SHAPE=R109,4,0)","v":0},{"$f":"IF(S109>0,\"Glass Width:\",0)","v":0},{"$f":"IF(S109>0,D79,0)","v":0},{"$f":"IF(AND(U109>0,U109<GlassMinW),1,0)","v":0}]
[null,null,null,null,null,null,null,null,"Glass Minor R:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=119),J106-OFFSET,0)","v":0},null,null,null,null,null,null,null,116,{"$f":"IF(SHAPE=R110,5,0)","v":0},{"$f":"IF(S110>0,\"Glass Height:\",0)","v":0},{"$f":"IF(S110>0,D78,0)","v":0},{"$f":"IF(AND(U110>0,U110<GlassMinH),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,116,{"$f":"IF(SHAPE=R111,6,0)","v":0},{"$f":"IF(S111>0,\"Glass Leg:\",0)","v":0},{"$f":"IF(S111>0,D80,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,116,{"$f":"IF(SHAPE=R112,7,0)","v":0},{"$f":"IF(S112>0,\"Angle @ Sill & Vert:\",0)","v":0},{"$f":"IF(S112>0,45,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,116,{"$f":"IF(SHAPE=R113,8,0)","v":0},{"$f":"IF(S113>0,\"Cut L @ Sill & Vert:\",0)","v":0},{"$f":"IF(S113>0,H77,0)","v":0},{"$f":"IF(AND(S113>0,H77>CUT_LENGTH),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,116,{"$f":"IF(SHAPE=R114,9,0)","v":0},{"$f":"IF(S114>0,\"Angle @ Leg & Arc:\",0)","v":0},{"$f":"IF(S114>0,H79,0)","v":0}]
[null,120,"Min Side","Max W","Max UI","Max sq.ft",null,null,"Frame Height:",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=120),SHAPEW,0)","v":0},null,null,null,null,{"$f":"VLOOKUP(B115,IMAGE_MODEL,2,FALSE)","v":{"$error":"#VALUE!"}},null,null,116,{"$f":"IF(SHAPE=R115,10,0)","v":0},{"$f":"IF(S115>0,\"Cut L @ Leg & Arc:\",0)","v":0},{"$f":"IF(S115>0,H80,0)","v":0},{"$f":"IF(AND(S115>0,H80>CUT_LENGTH),1,0)","v":0}]
[null,{"$f":"EXT","v":1},{"$f":"MIN_LEG","v":""},{"$f":"MAX_W","v":""},{"$f":"MAX_UI","v":""},{"$f":"MAX_SF","v":""},null,null,"Leg Length:",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=120),((TAN(30*(PI()/180)))*SHAPEW/2)*2,0)","v":0},"BM H",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=120),L118+(2*(L118*SIN(RADIANS(30)))),0)","v":0},null,null,null,null,null,116,{"$f":"IF(SHAPE=R116,11,0)","v":0},{"$f":"IF(S116>0,\"Angle @ Peak:\",0)","v":0},{"$f":"IF(S116>0,H76,0)","v":0}]
[null,{"$f":"BM_DYE","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPE=120,J116<C116),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=120,SHAPEW>D116),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,SHAPE=120,(SHAPEW+SHAPEH)>E116),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,SHAPE=120,((SHAPEW*SHAPEH)/144)>F116),1,0)","v":0},null,null,"Glass Leg Length:",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=120),(((SHAPEW/2)-OFFSET)*TAN(RADIANS(30)))*2,0)","v":0},"BM W",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=120),SHAPEW+((BM-BM_DEDUCT)*2),0)","v":0},null,null,null,null,null,116,{"$f":"IF(SHAPE=R117,12,0)","v":0},{"$f":"IF(S117>0,\"Cut L @ Peak:\",0)","v":0},{"$f":"IF(S117>0,H78,0)","v":0},{"$f":"IF(AND(S90>0,H78>CUT_LENGTH),1,0)","v":0}]
[null,null,{"$f":"MAX(C117:F117)","v":0},{"$f":"IF(AND(SHAPE=B115,C118=1),1,0)","v":0},null,{"$f":"IF(AND(SHAPE=120,J118>0,J118<GlassMinW),\"Glass Width is Under Minimum\",IF(AND(SHAPE=120,J119>0,J119<GlassMinH),\"Glass Height is Under Minimum\",\"\"))","v":""},null,null,"Glass Width:",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=120),SHAPEW-(OFFSET*2),0)","v":0},"BM Leg",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=120),((TAN(30*(PI()/180)))*L117/2)*2,0)","v":0},null,null,null,null,null,116,{"$f":"IF(SHAPE=R118,13,0)","v":0},{"$f":"IF(S118>0,\"Max Width:\",0)","v":0},{"$f":"IF(S118>0,D72,0)","v":0},{"$f":"IF(AND(S118>0,D73>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,"Glass Height:",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=120),J117+(2*(J117*SIN(RADIANS(30)))),0)","v":0},null,null,null,null,null,null,null,116,{"$f":"IF(SHAPE=R119,14,0)","v":0},{"$f":"IF(S119>0,\"Max Height:\",0)","v":0},{"$f":"IF(S119>0,E72,0)","v":0},{"$f":"IF(AND(S119>0,E73>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,116,{"$f":"IF(SHAPE=R120,15,0)","v":0},{"$f":"IF(S120>0,\"Max UI:\",0)","v":0},{"$f":"IF(S120>0,F72,0)","v":0},{"$f":"IF(AND(S120>0,F73>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,116,{"$f":"IF(AND(SHAPE=R121,BM_SELECT>1),16,0)","v":0},{"$f":"IF(S121>0,\"Brickmould Width:\",0)","v":0},{"$f":"IF(S121>0,K73,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,116,{"$f":"IF(AND(SHAPE=R122,BM_SELECT>1),17,0)","v":0},{"$f":"IF(S122>0,\"Brickmould Height:\",0)","v":0},{"$f":"IF(S122>0,K74,0)","v":0}]
[null,121,"Min Angle","Max Cut","Max W","Max H","Min Side","Max UI",null,null,null,null,null,null,null,null,null,116,{"$f":"IF(AND(SHAPE=R123,BM_SELECT>1),18,0)","v":0},{"$f":"IF(S123>0,\"Brickmould Leg:\",0)","v":0},{"$f":"IF(S123>0,K75,0)","v":0}]
[null,{"$f":"EXT","v":1},{"$f":"MIN_ANGLE","v":""},{"$f":"CUT_LENGTH","v":""},{"$f":"MAX_W","v":""},{"$f":"MAX_H","v":""},{"$f":"MIN_LEG","v":""},{"$f":"MAX_UI","v":""},null,null,null,null,null,null,{"$f":"VLOOKUP(B123,IMAGE_MODEL,2,FALSE)","v":{"$error":"#VALUE!"}},null,null,116,{"$f":"IF(AND(SHAPE=R124,BM_SELECT>1),19,0)","v":0},{"$f":"IF(S124>0,\"Brickmould Radius:\",0)","v":0},{"$f":"IF(S124>0,K72,0)","v":0}]
[null,{"$f":"BM_DYE","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPE=121,OR(D128<C124,D131<C124)),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_3>0,SHAPE=121,OR(D129>D124,D130>D124,H129>D124,H130>D124)),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=121,SHAPEW>E124),1,0)","v":0},{"$f":"IF(AND(SHAPEH>0,EXTLINK>1,SHAPE=121,SHAPEH>F124),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,DIM_3>0,SHAPE=121,OR(DIM_3<G124,D132<G124)),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,SHAPE=121,(SHAPEW+SHAPEH)>H124),1,0)","v":0},null,null,null,null,null,null,null,null,null,117,{"$f":"IF(SHAPE=R125,1,0)","v":0},{"$f":"IF(S125>0,\"Frame Major R:\",0)","v":0},{"$f":"IF(S125>0,I86,0)","v":0},{"$f":"IF(AND(S125>0,C86>0),1,0)","v":0}]
[null,null,{"$f":"MAX(C125:H125)","v":0},{"$f":"IF(AND(SHAPE=B123,C126=1),1,0)","v":0},null,{"$f":"IF(AND(SHAPE=121,G128>0,G128<GlassMinW),\"Glass Width is Under Minimum\",IF(AND(SHAPE=121,G129>0,G129<GlassMinH),\"Glass Height is Under Minimum\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,117,{"$f":"IF(SHAPE=R126,2,0)","v":0},{"$f":"IF(S126>0,\"Frame Minor R:\",0)","v":0},{"$f":"IF(S126>0,I87,0)","v":0},{"$f":"IF(AND(S126>0,C86>0),1,0)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,DIM_3>0,SHAPE=121),OFFSET/SIN(RADIANS(D128)),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,DIM_3>0,SHAPE=121),OFFSET/(COS(RADIANS(90-D131))),0)","v":0},null,null,null,null,null,null,null,null,null,117,{"$f":"IF(SHAPE=R127,3,0)","v":0},{"$f":"IF(S127>0,\"Frame Arc Length:\",0)","v":0},{"$f":"IF(S127>0,D91,0)","v":0},{"$f":"IF(AND(S127>0,F86>0),1,0)","v":0}]
[null,null,"outer peak angle",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_3>0,EXTLINK>1,SHAPE=121),90-DEGREES(ATAN(((SHAPEW-DIM_3)/2)/(SHAPEH/2))),0)","v":0},null,"Glass Width:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=121),SHAPEW-(2*G127),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,DIM_3>0,SHAPE=121),ROUND((12*TAN(RADIANS(D128))),1)&\" /12\",0)","v":0},null,"BM W",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_3>0,EXTLINK>1,SHAPE=121),SHAPEW+(H131*2),0)","v":0},null,null,null,null,null,null,117,{"$f":"IF(SHAPE=R128,4,0)","v":0},{"$f":"IF(S128>0,\"Glass Major R:\",0)","v":0},{"$f":"IF(S128>0,I90,0)","v":0}]
[null,null,"outer peak Hor. Cut",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,DIM_3>0,SHAPE=121),EXTOFFSET/SIN(RADIANS(D128)),0)","v":0},null,"Glass Height:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,DIM_3>0,SHAPE=121),SHAPEH-(2*OFFSET),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=121,DIM_3>0,AF8=3,SHAPE=121),(OFFSET+0.625)/SIN(RADIANS(D128)),0)","v":0},null,"BM H",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_3>0,EXTLINK>1,SHAPE=121),SHAPEH+((BM-BM_DEDUCT)*2),0)","v":0},null,null,null,null,null,null,117,{"$f":"IF(SHAPE=R129,5,0)","v":0},{"$f":"IF(S129>0,\"Glass Minor R:\",0)","v":0},{"$f":"IF(S129>0,I91,0)","v":0}]
[null,null,"Bottom & Top Cut",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,DIM_3>0,SHAPE=121),EXTOFFSET/(COS(RADIANS(90-D131))),0)","v":0},null,"Glass Dim3:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,DIM_3>0,SHAPE=121),DIM_3-((SQRT(H127^2-OFFSET^2))*2),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_3>0,SHAPE=121,EXTLINK<=3),(OFFSET+0.625)/(COS(RADIANS(90-D131))),0)","v":0},null,"BM LEG",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,DIM_3>0,SHAPE=121),DIM_3+((SQRT(H132^2-(BM-BM_DEDUCT)^2))*2),0)","v":0},null,null,null,null,null,null,117,{"$f":"IF(SHAPE=R130,6,0)","v":0},{"$f":"IF(S130>0,\"Glass Width:\",0)","v":0},{"$f":"IF(S130>0,GW_117,0)","v":0},{"$f":"IF(AND(U130>0,GW_117<GlassMinW),1,0)","v":0}]
[null,null,"Angles at long legs",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,DIM_3>0,SHAPE=121),90-D128/2,0)","v":0},null,"Glass Slant Leg:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,DIM_3>0,SHAPE=121),SQRT(((G128/2)-(G130/2))^2+(G129/2)^2),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,DIM_3>0,SHAPE=121),(BM-BM_DEDUCT)/SIN((ATAN((SHAPEH/2)/((SHAPEW-DIM_3)/2)))),0)","v":0},null,"BM Slanted",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,DIM_3>0,SHAPE=121),SQRT(((K128/2)-(K130/2))^2+(K129/2)^2),0)","v":0},null,null,null,null,null,null,117,{"$f":"IF(SHAPE=R131,7,0)","v":0},{"$f":"IF(S131>0,\"Glass Height:\",0)","v":0},{"$f":"IF(S131>0,I89,0)","v":0},{"$f":"IF(AND(U131>0,GH_117<GlassMinH),1,0)","v":0}]
[null,null,"Slanted leg Length",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,DIM_3>0,SHAPE=121),SQRT(((SHAPEW-DIM_3)/2)^2+(SHAPEH/2)^2),0)","v":0},null,null,null,{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,DIM_3>0,SHAPE=121),(BM-BM_DEDUCT)/(COS(RADIANS(90-D131))),0)","v":0},null,null,null,null,null,null,null,null,null,117,{"$f":"IF(SHAPE=R132,8,0)","v":0},{"$f":"IF(S132>0,\"Max Width:\",0)","v":0},{"$f":"IF(S132>0,D85,0)","v":0},{"$f":"IF(AND(S132>0,D86>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,117,{"$f":"IF(SHAPE=R133,9,0)","v":0},{"$f":"IF(S133>0,\"Max UI:\",0)","v":0},{"$f":"IF(S133>0,E85,0)","v":0},{"$f":"IF(AND(S133>0,E86>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,117,{"$f":"IF(AND(SHAPE=R134,BM_SELECT>1),10,0)","v":0},{"$f":"IF(S134>0,\"Brickmould Width:\",0)","v":0},{"$f":"IF(S134>0,K87,0)","v":0}]
[null,122,"Min Side","Max W","Max UI","Max sq.ft",null,"Leg Length",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=122),((TAN(22.5*(PI()/180)))*SHAPEW/2)*2,0)","v":0},null,null,null,null,null,{"$f":"VLOOKUP(B135,IMAGE_MODEL,2,FALSE)","v":{"$error":"#VALUE!"}},null,null,117,{"$f":"IF(AND(SHAPE=R134,BM_SELECT>1),11,0)","v":0},{"$f":"IF(S135>0,\"Brickmould Height:\",0)","v":0},{"$f":"IF(S135>0,K88,0)","v":0}]
[null,{"$f":"EXT","v":1},{"$f":"MIN_LEG","v":""},{"$f":"MAX_W","v":""},{"$f":"MAX_UI","v":""},{"$f":"MAX_SF","v":""},null,"Frame H:",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=122),SHAPEW,0)","v":0},null,null,null,null,null,null,null,null,117,{"$f":"IF(AND(SHAPE=R134,BM_SELECT>1),12,0)","v":0},{"$f":"IF(S136>0,\"BM Major Radius:\",0)","v":0},{"$f":"IF(S136>0,K89,0)","v":0}]
[null,{"$f":"BM_DYE","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPE=122,I135<C136),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=122,SHAPEW>D136),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,SHAPE=122,(SHAPEW+SHAPEH)>E136),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=122,((SHAPEW*SHAPEH)/144)>F136),1,0)","v":0},null,"Glass W:",{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=122),SHAPEW-(OFFSET*2),0)","v":0},"BM W:",{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=122),SHAPEW+((BM-BM_DEDUCT)*2),0)","v":0},null,null,null,null,null,null,117,{"$f":"IF(AND(SHAPE=R134,BM_SELECT>1),13,0)","v":0},{"$f":"IF(S137>0,\"BM Minor Radius:\",0)","v":0},{"$f":"IF(S137>0,K90,0)","v":0}]
[null,null,{"$f":"MAX(C137:F137)","v":0},{"$f":"IF(AND(SHAPE=122,C138=1),1,0)","v":0},null,{"$f":"IF(AND(SHAPE=122,SHAPEW>0,SHAPEH>0,SHAPEW<>SHAPEH),\"WIDTH AND HEIGHT MUST BE EQUAL\",IF(AND(SHAPE=122,I137>0,I137<GlassMinW),\"Glass Width is Under Minimum\",IF(AND(SHAPE=122,I138>0,I138<GlassMinH),\"Glass Height is Under Minimum\",\"\")))","v":""},null,"Glass H:",{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=122),SHAPEW-(OFFSET*2),0)","v":0},"BM H:",{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=122),SHAPEW+((BM-BM_DEDUCT)*2),0)","v":0},null,null,null,null,null,null,118,{"$f":"IF(SHAPE=R138,1,0)","v":0},{"$f":"IF(S138>0,\"Frame Width:\",0)","v":0},{"$f":"IF(S138>0,SHAPEW,0)","v":0}]
[null,null,null,null,null,null,null,"Glass Legs:",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=122),(((SHAPEW/2)-OFFSET)*TAN(RADIANS(22.5)))*2,0)","v":0},"BM Legs:",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=122),(((SHAPEW/2)+(BM-BM_DEDUCT))*TAN(RADIANS(22.5)))*2,0)","v":0},null,null,null,null,null,null,118,{"$f":"IF(SHAPE=R139,2,0)","v":0},{"$f":"IF(S139>0,\"Frame Height:\",0)","v":0},{"$f":"IF(S139>0,SHAPEH,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,118,{"$f":"IF(SHAPE=R140,3,0)","v":0},{"$f":"IF(S140>0,\"Frame Radius:\",0)","v":0},{"$f":"IF(S140>0,I98,0)","v":0},{"$f":"IF(AND(S140>0,C96>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,118,{"$f":"IF(SHAPE=R141,4,0)","v":0},{"$f":"IF(S141>0,\"Glass Radius:\",0)","v":0},{"$f":"IF(S141>0,I99,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,118,{"$f":"IF(SHAPE=R142,5,0)","v":0},{"$f":"IF(S142>0,\"Glass Width:\",0)","v":0},{"$f":"IF(S142>0,I96,0)","v":0},{"$f":"IF(AND(U142>0,U142<GlassMinW),1,0)","v":0}]
[null,123,"Min Cut","Min Side","Max W","Max H","Max UI",null,null,null,null,null,null,null,null,null,null,118,{"$f":"IF(SHAPE=R143,6,0)","v":0},{"$f":"IF(S143>0,\"Glass Height:\",0)","v":0},{"$f":"IF(S143>0,I97,0)","v":0},{"$f":"IF(AND(U143>0,U143<GlassMinH),1,0)","v":0}]
[null,{"$f":"EXT","v":1},{"$f":"CUT_LENGTH","v":""},{"$f":"MIN_LEG","v":""},{"$f":"MAX_W","v":""},{"$f":"MAX_H","v":""},{"$f":"MAX_UI","v":""},null,null,null,null,null,null,null,null,null,null,118,{"$f":"IF(SHAPE=R144,7,0)","v":0},{"$f":"IF(S144>0,\"Max Width:\",0)","v":0},{"$f":"IF(S144>0,D95,0)","v":0},{"$f":"IF(AND(S144>0,SHAPEW>0,SHAPEW>U144),1,0)","v":0}]
[null,{"$f":"BM_DYE","v":0},null,{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_3>0,SHAPE=123,OR(D149<D144,D151<D144,D150<D144)),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=123,OR(SHAPEW>E144,SHAPEH>E144)),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=123,SHAPEH>F144),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=123,EXTLINK>1,(SHAPEW+SHAPEH)>G144),1,0)","v":0},null,null,{"$f":"IF(SHAPEW<=SHAPEH,((TAN(22.5*(PI()/180)))*SHAPEW/2)*2,((TAN(22.5*(PI()/180)))*SHAPEH/2)*2)","v":0},null,null,null,null,null,null,null,118,{"$f":"IF(SHAPE=R145,8,0)","v":0},{"$f":"IF(S145>0,\"Max UI:\",0)","v":0},{"$f":"IF(S145>0,E95,0)","v":0},{"$f":"IF(AND(S145>0,E96>0),1,0)","v":0}]
[null,null,{"$f":"MAX(C145:G145)","v":0},{"$f":"IF(AND(SHAPE=B143,C146=1),1,0)","v":0},null,null,{"$f":"IF(AND(SHAPE=123,SHAPEW>0,GW_123<GlassMinW),\"Glass Width is Under Minimum\",IF(AND(SHAPE=123,J156>0,GH_123<GlassMinH),\"Glass Height is Under Minimum\",\"\"))","v":""},null,null,{"$f":"J145*SIN(RADIANS(45))","v":0},"Used for Slanted Leg",null,null,null,{"$f":"VLOOKUP(B143,IMAGE_MODEL,2,FALSE)","v":{"$error":"#VALUE!"}},null,null,118,{"$f":"IF(AND(SHAPE=R146,BM_SELECT>1),9,0)","v":0},{"$f":"IF(S146>0,\"Brickmould Width:\",0)","v":0},{"$f":"IF(S146>0,K95,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(SHAPEH>SHAPEW,SHAPEH-(2*J146),SHAPEW-(2*J146))","v":0},null,null,null,null,null,null,null,118,{"$f":"IF(AND(SHAPE=R147,BM_SELECT>1),10,0)","v":0},{"$f":"IF(S147>0,\"Brickmould Height:\",0)","v":0},{"$f":"IF(S147>0,K96,0)","v":0}]
[null,null,"Roof Pitch",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=123),ROUND((TAN(RADIANS(90-E149))*12),1)&\" /12\",0)","v":0},null,null,null,null,null,{"$f":"(DIM_3-J147)/2","v":0},null,null,null,null,null,null,null,118,{"$f":"IF(AND(SHAPE=R148,BM_SELECT>1),11,0)","v":0},{"$f":"IF(S148>0,\"Brickmould Radius:\",0)","v":0},{"$f":"IF(S148>0,K97,0)","v":0}]
[null,null,"Vertical Leg",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=123),IF(SHAPEW<=SHAPEH,DIM_3,((TAN(22.5*(PI()/180)))*SHAPEH/2)*2),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=123),IF(SHAPEW<=SHAPEH,((TAN(22.5*(PI()/180)))*SHAPEW/2)*2,((TAN(22.5*(PI()/180)))*SHAPEH/2)*2),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=123),IF(SHAPEW<=SHAPEH,((TAN(22.5*(PI()/180)))*I149/2)*2,((TAN(22.5*(PI()/180)))*I150/2)*2),0)","v":0},null,"BM W",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=123),SHAPEW+((BM-BM_DEDUCT)*2),0)","v":0},{"$f":"J146-J148","v":0},"Used for Slanted Leg",null,null,null,null,null,null,119,{"$f":"IF(SHAPE=R149,1,0)","v":0},{"$f":"IF(S151>0,\"Frame Major R:\",0)","v":0},{"$f":"IF(S149>0,J105,0)","v":0},{"$f":"IF(AND(S149>0,C105>0),1,0)","v":0}]
[null,null,"Horizontal Leg",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=123),IF(SHAPEW<=SHAPEH,((TAN(22.5*(PI()/180)))*SHAPEW/2)*2,DIM_3),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=123),E149*SIN(RADIANS(45)),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=123),F149*SIN(RADIANS(45)),0)","v":0},null,"BM H",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=123),SHAPEH+((BM-BM_DEDUCT)*2),0)","v":0},{"$f":"SQRT(J146^2+J149^2)","v":0},null,null,null,null,null,null,null,119,{"$f":"IF(SHAPE=R150,2,0)","v":0},{"$f":"IF(S152>0,\"Frame Minor R:\",0)","v":0},{"$f":"IF(S150>0,J106,0)","v":0},{"$f":"IF(AND(S150>0,C105>0),1,0)","v":0}]
[null,null,"Slanted Leg:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=123),SQRT(J146^2+J149^2),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=123),IF(SHAPEH>SHAPEW,SHAPEH-(2*E150),SHAPEW-(2*E150)),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=123),IF(SHAPEH>SHAPEW,I150-(2*F150),I149-(2*F150)),0)","v":0},null,"BM Vert. Leg",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=123),IF(SHAPEW>=SHAPEH,D149+(F154*2),D149+(F156*2)))","v":false},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=123),90-E154,0)","v":0},null,null,null,null,null,null,null,119,{"$f":"IF(SHAPE=R151,3,0)","v":0},{"$f":"IF(S153>0,\"Glass Major R:\",0)","v":0},{"$f":"IF(S151>0,J109,0)","v":0}]
[null,null,"Glass Vert. Leg",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=123),IF(SHAPEW>=SHAPEH,D149-(2*J154),D149-(2*J155)),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=123),(DIM_3-E151)/2,0)","v":0},null,null,"BM Hor. Leg",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=123),IF(SHAPEW<SHAPEH,D150+(F154*2),D150+(F156*2)))","v":false},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=123),90-(E154/2),0)","v":0},null,null,null,null,null,null,null,119,{"$f":"IF(SHAPE=R152,4,0)","v":0},{"$f":"IF(S154>0,\"Glass Minor R:\",0)","v":0},{"$f":"IF(S152>0,J110,0)","v":0}]
[null,null,"Glass Hor. Leg",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=123),IF(SHAPEW<SHAPEH,D150-(2*J154),D150-(2*J155)),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=123),E150-E152,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=123),RADIANS(90-J152),0)","v":0},null,"BM Slant Leg",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=123),D151+F154+F156,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=123),E154+(J151/2),0)","v":0},null,null,null,null,null,null,null,119,{"$f":"IF(SHAPE=R153,5,0)","v":0},{"$f":"IF(S155>0,\"Glass Width:\",0)","v":0},{"$f":"IF(S153>0,GW_119,0)","v":0},{"$f":"IF(AND(,S153>0,U153>0,GW_119<GlassMinW),1,0)","v":0}]
[null,null,"Glass Width:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=123),SHAPEW-(2*OFFSET),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=123),DEGREES(ATAN(E153/E150)),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=123),(BM-BM_DEDUCT)*TAN(F153),0)","v":0},null,null,null,{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=123),OFFSET/TAN(RADIANS(J152)),0)","v":0},"Used for glass Vert./Hor. Leg",null,null,null,null,null,null,119,{"$f":"IF(SHAPE=R154,6,0)","v":0},{"$f":"IF(S156>0,\"Glass Height:\",0)","v":0},{"$f":"IF(S154>0,GH_119,0)","v":0},{"$f":"IF(AND(S154>0,U154>0,GH_119<GlassMinH),1,0)","v":0}]
[null,null,"Glass Height:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=123),SHAPEH-(2*OFFSET),0)","v":0},null,{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=123),RADIANS(90-J153),0)","v":0},null,null,null,{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=123),OFFSET/TAN(RADIANS(J153)),0)","v":0},"Used for glass Vert./Hor. Leg",null,null,null,null,null,null,119,{"$f":"IF(SHAPE=R155,7,0)","v":0},{"$f":"IF(S157>0,\"Max Width:\",0)","v":0},{"$f":"IF(S155>0,D104,0)","v":0},{"$f":"IF(AND(S155>0,SHAPEW>U155),1,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=123),(BM-BM_DEDUCT)*TAN(F155),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,119,{"$f":"IF(SHAPE=R156,8,0)","v":0},{"$f":"IF(S158>0,\"Max Height:\",0)","v":0},{"$f":"IF(S156>0,E104,0)","v":0},{"$f":"IF(AND(S156>0,SHAPEH>U156),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,119,{"$f":"IF(SHAPE=R157,9,0)","v":0},{"$f":"IF(S159>0,\"Max UI:\",0)","v":0},{"$f":"IF(S157>0,F104,0)","v":0},{"$f":"IF(AND(S157>0,F105>0),1,0)","v":0}]
[null,124,"Min Cut","Min Side","Max H","Max UI",null,"Unit Height:",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=124),(SHAPEW*COS(RADIANS(54)))+(SHAPEW*SIN(RADIANS(72))),0)","v":0},null,null,null,null,null,{"$f":"VLOOKUP(B158,IMAGE_MODEL,2,FALSE)","v":{"$error":"#VALUE!"}},null,null,119,{"$f":"IF(AND(SHAPE=R158,BM_SELECT>1),10,0)","v":0},{"$f":"IF(S158>0,\"Brickmould Width:\",0)","v":0},{"$f":"IF(S158>0,L106,0)","v":0}]
[null,{"$f":"EXT","v":1},{"$f":"CUT_LENGTH","v":""},{"$f":"MIN_LEG","v":""},{"$f":"MAX_W","v":""},{"$f":"MAX_UI","v":""},null,"Cut Length:",{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=124),EXTOFFSET/SIN(RADIANS(54)),0)","v":0},"BM W:",{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=124),SHAPEW+(G164*2),0)","v":0},null,null,null,null,null,null,119,{"$f":"IF(AND(SHAPE=R159,BM_SELECT>1),11,0)","v":0},{"$f":"IF(S159>0,\"Brickmould Height:\",0)","v":0},{"$f":"IF(S159>0,L107,0)","v":0}]
[null,{"$f":"BM_DYE","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPE=124,I159>C159),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPE=124,I162<D159),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPE=124,EXTLINK>1,I158>E159),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPE=124,EXTLINK>1,(SHAPEW+I158)>F159),1,0)","v":0},null,"Peak Deduct:",{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=124),OFFSET/SIN(RADIANS(54)),0)","v":0},"BM H:",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=124),(K159*COS(RADIANS(54)))+(K159*SIN(RADIANS(72))),0)","v":0},null,null,null,null,null,null,119,{"$f":"IF(AND(SHAPE=R160,BM_SELECT>1),12,0)","v":0},{"$f":"IF(S160>0,\"BM Major Radius:\",0)","v":0},{"$f":"IF(S160>0,L108,0)","v":0}]
[null,null,{"$f":"MAX(C160:F160)","v":0},{"$f":"IF(AND(SHAPE=B158,C161=1),1,0)","v":0},null,{"$f":"IF(AND(SHAPE=124,I163>0,I163<GlassMinW),\"Glass Width is Under Minimum\",IF(AND(SHAPE=124,I161>0,I161<GlassMinH),\"Glass Height is Under Minimum\",\"\"))","v":""},null,"Glass Height:",{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=124),I158-(I160+OFFSET),0)","v":0},null,null,null,null,null,null,null,null,119,{"$f":"IF(AND(SHAPE=R161,BM_SELECT>1),13,0)","v":0},{"$f":"IF(S161>0,\"BM Minor Radius:\",0)","v":0},{"$f":"IF(S161>0,L109,0)","v":0}]
[null,null,null,null,null,null,null,"Segment Length:",{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=124),SHAPEW,0)","v":0},null,null,null,null,null,null,null,null,120,{"$f":"IF(SHAPE=R162,1,0)","v":0},{"$f":"IF(S162>0,\"Frame Height:\",0)","v":0},{"$f":"IF(S162>0,J115,0)","v":0}]
[null,null,null,null,null,null,{"$f":"OFFSET/TAN(RADIANS(54))","v":0},"Glass Width:",{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=124),SHAPEW-(G163*2),0)","v":0},null,null,null,null,null,null,null,null,120,{"$f":"IF(SHAPE=R163,2,0)","v":0},{"$f":"IF(S163>0,\"Frame Segment:\",0)","v":0},{"$f":"IF(S163>0,J116,0)","v":0},{"$f":"IF(AND(S163>0,C117>0),1,0)","v":0}]
[null,null,null,null,null,null,{"$f":"(BM-BM_DEDUCT)/TAN(RADIANS(54))","v":0},"Glass Leg:",{"$f":"I163","v":0},null,null,null,null,null,null,null,null,120,{"$f":"IF(SHAPE=R164,3,0)","v":0},{"$f":"IF(S164>0,\"Min Leg:\",0)","v":0},{"$f":"IF(S164>0,C116,0)","v":0},{"$f":"IF(AND(S164>0,C117>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120,{"$f":"IF(SHAPE=R165,4,0)","v":0},{"$f":"IF(S165>0,\"Glass Width:\",0)","v":0},{"$f":"IF(S165>0,GW_120,0)","v":0},{"$f":"IF(AND(U165>0,U165<GlassMinW),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120,{"$f":"IF(SHAPE=R166,5,0)","v":0},{"$f":"IF(S166>0,\"Glass Height:\",0)","v":0},{"$f":"IF(S166>0,GH_120,0)","v":0},{"$f":"IF(AND(U166>0,U166<GlassMinH),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120,{"$f":"IF(SHAPE=R167,6,0)","v":0},{"$f":"IF(S167>0,\"Glass Leg:\",0)","v":0},{"$f":"IF(S167>0,J117,0)","v":0}]
[null,125,"Min Side","Min Cut","Max W","Max H","Max UI","Min Angle",null,null,null,null,null,null,null,null,null,120,{"$f":"IF(SHAPE=R168,7,0)","v":0},{"$f":"IF(S168>0,\"Max Width:\",0)","v":0},{"$f":"IF(S168>0,D116,0)","v":0},{"$f":"IF(AND(S168>0,SHAPEW>0,SHAPEW>U168),1,0)","v":0}]
[null,{"$f":"EXT","v":1},{"$f":"MIN_LEG","v":""},{"$f":"CUT_LENGTH","v":""},{"$f":"MAX_W","v":""},{"$f":"MAX_H","v":""},{"$f":"MAX_UI","v":""},{"$f":"MIN_ANGLE","v":""},null,null,null,null,null,null,{"$f":"VLOOKUP(B168,IMAGE_MODEL,2,FALSE)","v":{"$error":"#VALUE!"}},null,null,120,{"$f":"IF(SHAPE=R169,8,0)","v":0},{"$f":"IF(S169>0,\"Max UI:\",0)","v":0},{"$f":"IF(S169>0,E116,0)","v":0},{"$f":"IF(AND(S169>0,E117>0),1,0)","v":0}]
[null,{"$f":"BM_DYE","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_3>0,DIM_4>0,EXTLINK>1,SHAPE=125,OR(DIM_3<C169,DIM_4<C169,G176<C169)),1,0)","v":0},null,{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=125,SHAPEW>E169),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=125,SHAPEH>F169),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,SHAPE=125,(SHAPEW+SHAPEH)>G169),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,SHAPE=125,OR(D173<H169,G174<H169,G175<H169)),1,0)","v":0},null,null,null,null,null,null,null,null,null,120,{"$f":"IF(AND(SHAPE=R170,BM_SELECT>1),9,0)","v":0},{"$f":"IF(S170>0,\"Brickmould Width:\",0)","v":0},{"$f":"IF(S170>0,L117,0)","v":0}]
[null,null,{"$f":"MAX(C170:H170)","v":0},{"$f":"IF(AND(SHAPE=B168,C171=1),1,0)","v":0},null,null,{"$f":"IF(AND(SHAPE=125,G177>0,G177<GlassMinW),\"Glass Width is Under Minimum\",IF(AND(SHAPE=125,G178>0,G178<GlassMinH),\"Glass Height is Under Minimum\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,120,{"$f":"IF(AND(SHAPE=R171,BM_SELECT>1),10,0)","v":0},{"$f":"IF(S171>0,\"Brickmould Height:\",0)","v":0},{"$f":"IF(S171>0,L116,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120,{"$f":"IF(AND(SHAPE=R172,BM_SELECT>1),11,0)","v":0},{"$f":"IF(S172>0,\"Brickmould Segment:\",0)","v":0},{"$f":"IF(S172>0,L118,0)","v":0}]
[null,null,"Roof Pitch:",{"$f":"IF(AND(SHAPEH>0,SHAPEW>0,DIM_3>0,DIM_4>0,OFFSET>0,SHAPE=125),90-DEGREES(ATAN((SHAPEH-DIM_3)/(SHAPEW-DIM_4))),0)","v":0},null,"Glass Dim4:",{"$f":"IF(AND(SHAPEH>0,SHAPEW>0,DIM_3>0,DIM_4>0,OFFSET>0,SHAPE=125),DIM_4-OFFSET-(OFFSET*TAN(RADIANS(90-G175))),0)","v":0},{"$f":"IF(AND(SHAPEH>0,SHAPEW>0,DIM_3>0,DIM_4>0,OFFSET>0,SHAPE=125),ROUND((12*((SHAPEH-DIM_3)/(SHAPEW-DIM_4))),1)&\" / 12\",0)","v":0},"BM W:",{"$f":"IF(AND(SHAPEH>0,SHAPEW>0,DIM_3>0,DIM_4>0,OFFSET>0,SHAPE=125),SHAPEW+((BM-BM_DEDUCT)*2),0)","v":0},null,null,null,null,null,null,null,121,{"$f":"IF(SHAPE=R173,1,0)","v":0},{"$f":"IF(S173>0,\"Roof Pitch:\",0)","v":0},{"$f":"IF(S173>0,H128,0)","v":0},{"$f":"IF(AND(S129>0,D128>=90),1,0)","v":0}]
[null,null,"Peak & Slant Cut:",{"$f":"IF(AND(SHAPEH>0,SHAPEW>0,DIM_3>0,DIM_4>0,OFFSET>0,SHAPE=125),EXTOFFSET/COS(RADIANS((90-D173)/2)),0)","v":0},null,"Angle @ Vert & Slant:",{"$f":"IF(AND(SHAPEH>0,SHAPEW>0,DIM_3>0,DIM_4>0,OFFSET>0,SHAPE=125),DEGREES(ASIN(EXTOFFSET/D175)),0)","v":0},null,"BM H:",{"$f":"IF(AND(SHAPEH>0,SHAPEW>0,DIM_3>0,DIM_4>0,OFFSET>0,SHAPE=125),SHAPEH+((BM-BM_DEDUCT)*2),0)","v":0},null,null,null,null,null,null,null,121,{"$f":"IF(SHAPE=R174,2,0)","v":0},{"$f":"IF(S174>0,\"Horizontal Leg:\",0)","v":0},{"$f":"IF(AND(S174>0,DIM_3>0),DIM_3,0)","v":0},{"$f":"IF(AND(S130>0,DIM_3<G124),1,0)","v":0}]
[null,null,"Vert & Slant Cut:",{"$f":"IF(AND(SHAPEH>0,SHAPEW>0,DIM_3>0,DIM_4>0,OFFSET>0,SHAPE=125),EXTOFFSET/COS(RADIANS((D173/2))),0)","v":0},null,"Angle @ Hor. & Slant:",{"$f":"IF(AND(SHAPEH>0,SHAPEW>0,DIM_3>0,DIM_4>0,OFFSET>0,SHAPE=125),DEGREES(ASIN(EXTOFFSET/D174)),0)","v":0},null,"BM H. LEG:",{"$f":"IF(AND(SHAPEH>0,SHAPEW>0,DIM_3>0,DIM_4>0,OFFSET>0,SHAPE=125),DIM_3+(BM-BM_DEDUCT)+((BM-BM_DEDUCT)*TAN(RADIANS(90-G174))),0)","v":0},{"$f":"((BM-BM_DEDUCT)*TAN(RADIANS(90-G174)))","v":0},null,null,null,null,null,null,121,{"$f":"IF(SHAPE=R175,3,0)","v":0},{"$f":"IF(S175>0,\"Slanted Leg:\",0)","v":0},{"$f":"IF(S175>0,D132,0)","v":0},{"$f":"IF(AND(S175>0,DIM_3>0,D132<G124),1,0)","v":0}]
[null,null,"All 45O Cuts:",{"$f":"IF(AND(SHAPEH>0,SHAPEW>0,DIM_3>0,DIM_4>0,OFFSET>0,SHAPE=125),EXTOFFSET/COS(RADIANS(45)),0)","v":0},null,"Slanted Leg:",{"$f":"IF(AND(SHAPEH>0,SHAPEW>0,DIM_3>0,DIM_4>0,OFFSET>0,SHAPE=125),SQRT((SHAPEW-DIM_4)^2+(SHAPEH-DIM_3)^2),0)","v":0},null,"BM V LEG:",{"$f":"IF(AND(SHAPEH>0,SHAPEW>0,DIM_3>0,DIM_4>0,OFFSET>0,SHAPE=125),DIM_4+(BM-BM_DEDUCT)+((BM-BM_DEDUCT)*TAN(RADIANS(90-G175))),0)","v":0},{"$f":"((BM-BM_DEDUCT)*TAN(RADIANS(90-G175)))","v":0},null,null,null,null,null,null,121,{"$f":"IF(SHAPE=R176,4,0)","v":0},{"$f":"IF(S176>0,\"Outer Peak Angle:\",0)","v":0},{"$f":"IF(S176>0,D128,0)","v":0},{"$f":"IF(AND(S176>0,DIM_3>0,C125>0,D128<C123),1,0)","v":0}]
[null,null,"Glass Dim3:",{"$f":"IF(AND(SHAPEH>0,SHAPEW>0,DIM_3>0,DIM_4>0,OFFSET>0,SHAPE=125),DIM_3-OFFSET-(OFFSET*TAN(RADIANS(90-G174))),0)","v":0},null,"Glass Width:",{"$f":"IF(AND(SHAPEH>0,SHAPEW>0,DIM_3>0,DIM_4>0,OFFSET>0,SHAPE=125),SHAPEW-(OFFSET*2),0)","v":0},null,"BM SLANT LEG:",{"$f":"IF(AND(SHAPEH>0,SHAPEW>0,DIM_3>0,DIM_4>0,OFFSET>0,SHAPE=125),G176+K175+K176,0)","v":0},null,null,null,null,null,null,null,121,{"$f":"IF(SHAPE=R177,5,0)","v":0},{"$f":"IF(S177>0,\"Outer Peak Cut L:\",0)","v":0},{"$f":"IF(S177>0,D129,0)","v":0},{"$f":"IF(AND(S177>0,D125>0,DIM_3>0,MAX(D129:D130)>D124),1,0)","v":0}]
[null,null,null,null,null,"Glass Height:",{"$f":"IF(AND(SHAPEH>0,SHAPEW>0,DIM_3>0,DIM_4>0,OFFSET>0,SHAPE=125),SHAPEH-(OFFSET*2),0)","v":0},null,null,null,null,null,null,null,null,null,null,121,{"$f":"IF(SHAPE=R178,6,0)","v":0},{"$f":"IF(S178>0,\"Top & Bott Angles:\",0)","v":0},{"$f":"IF(S178>0,D131,0)","v":0},{"$f":"IF(AND(S178>0,DIM_3>0,C125>0,D131<C124),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,121,{"$f":"IF(SHAPE=R179,7,0)","v":0},{"$f":"IF(S179>0,\"Top & Bott Cut L:\",0)","v":0},{"$f":"IF(S179>0,D130,0)","v":0},{"$f":"IF(AND(S179>0,D125>0,DIM_3>0,MAX(D129:D130)>D124),1,0)","v":0}]
[null,126,"Min Side","Min Cut","Max W","Max H","Max UI","Min Angle",null,null,null,null,null,null,null,null,null,121,{"$f":"IF(SHAPE=R180,8,0)","v":0},{"$f":"IF(S180>0,\"Glass Width:\",0)","v":0},{"$f":"IF(S180>0,GW_121,0)","v":0},{"$f":"IF(AND(U180>0,U180<GlassMinW),1,0)","v":0}]
[null,{"$f":"EXT","v":1},{"$f":"MIN_LEG","v":""},{"$f":"CUT_LENGTH","v":""},{"$f":"MAX_W","v":""},{"$f":"MAX_H","v":""},{"$f":"MAX_UI","v":""},{"$f":"MIN_ANGLE","v":""},null,null,null,null,null,null,{"$f":"VLOOKUP(B180,IMAGE_MODEL,2,FALSE)","v":{"$error":"#VALUE!"}},null,null,121,{"$f":"IF(SHAPE=R181,9,0)","v":0},{"$f":"IF(S181>0,\"Glass Height:\",0)","v":0},{"$f":"IF(S181>0,GH_121,0)","v":0},{"$f":"IF(AND(U181>0,U181<GlassMinH),1,0)","v":0}]
[null,{"$f":"BM_DYE","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_3>0,SHAPE=126,OR(DIM_3<C181,G187<C181)),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_3>0,SHAPE=126,OR(D189>D181,D187>D181,D188>D181)),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPE=126,EXTLINK>1,SHAPEW>E181),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPE=126,EXTLINK>1,SHAPEH>F181),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=126,EXTLINK>1,(SHAPEW+SHAPEH)>G181),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_3>0,SHAPE=126,OR(D185<H181,G189<H181)),1,0)","v":0},null,"BM W:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_3>0,OFFSET>0,SHAPE=126),SHAPEW+((BM-BM_DEDUCT)*2),0)","v":0},null,null,null,null,null,null,121,{"$f":"IF(SHAPE=R182,10,0)","v":0},{"$f":"IF(S182>0,\"Glass Hor. Leg:\",0)","v":0},{"$f":"IF(S182>0,G130,0)","v":0}]
[null,null,{"$f":"MAX(C182:H182)","v":0},{"$f":"IF(AND(SHAPE=126,C183=1),1,0)","v":0},null,null,{"$f":"IF(AND(SHAPE=126,G188>0,G188<GlassMinW),\"Glass Width is Under Minimum\",IF(AND(SHAPE=126,G185>0,G185<GlassMinH),\"Glass Height is Under Minimum\",\"\"))","v":""},null,null,"BM H:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_3>0,OFFSET>0,SHAPE=126),SHAPEH+(BM-BM_DEDUCT)+L183,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=126),(BM-BM_DEDUCT)/(SIN(RADIANS(D185))),0)","v":0},null,null,null,null,null,121,{"$f":"IF(SHAPE=R183,11,0)","v":0},{"$f":"IF(S183>0,\"Glass Slanted Leg:\",0)","v":0},{"$f":"IF(S183>0,G131,0)","v":0}]
[null,null,null,null,null,null,null,null,null,"BM Leg:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_3>0,OFFSET>0,SHAPE=126),DIM_3+(BM-BM_DEDUCT)+(TAN(RADIANS(90-G189))*(BM-BM_DEDUCT)),0)","v":0},null,null,null,null,null,null,121,{"$f":"IF(SHAPE=R184,12,0)","v":0},{"$f":"IF(S184>0,\"Max W & H:\",0)","v":0},{"$f":"IF(S184>0,E124,0)","v":0},{"$f":"IF(AND(S184>0,SHAPEW>0,SHAPEW>U184),1,0)","v":0}]
[null,null,"Roof Pitch:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_3>0,OFFSET>0,SHAPE=126),90-DEGREES(ATAN((SHAPEH-DIM_3)/(SHAPEW/2))),0)","v":0},null,"Glass Height:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_3>0,OFFSET>0,SHAPE=126),SHAPEH-OFFSET-D186,0)","v":0},{"$f":"IF(AND(SHAPEH>0,DIM_3>0,SHAPEW>0,OFFSET>0,SHAPE=126),ROUND((12*((SHAPEH-DIM_3)/(SHAPEW/2))),1)&\" /12\",0)","v":0},null,"BM Slant Leg:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_3>0,OFFSET>0,SHAPE=126),SQRT((K183-K184)^2+(K182/2)^2),0)","v":0},null,null,null,null,null,null,121,{"$f":"IF(SHAPE=R185,13,0)","v":0},{"$f":"IF(S185>0,\"Max UI:\",0)","v":0},{"$f":"IF(S185>0,H124,0)","v":0},{"$f":"IF(AND(S185>0,H125>0),1,0)","v":0}]
[null,null,"IG Offset @ Peak:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=126),OFFSET/(SIN(RADIANS(D185))),0)","v":0},null,"Glass Leg Height:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_3>0,OFFSET>0,SHAPE=126),DIM_3-OFFSET-(TAN(RADIANS(90-G189))*OFFSET),0)","v":0},null,null,null,null,null,null,null,null,null,null,121,{"$f":"IF(AND(SHAPE=R186,BM_SELECT>1),14,0)","v":0},{"$f":"IF(S186>0,\"Brickmould Width:\",0)","v":0},{"$f":"IF(S186>0,K128,0)","v":0}]
[null,null,"Cut L @ Peak:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=126),EXTOFFSET/(SIN(RADIANS(D185))),0)","v":0},null,"Slanted Leg:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_3>0,OFFSET>0,SHAPE=126),SQRT((SHAPEH-DIM_3)^2+(SHAPEW/2)^2),0)","v":0},null,null,null,null,null,null,null,null,null,null,121,{"$f":"IF(AND(SHAPE=R187,BM_SELECT>1),15,0)","v":0},{"$f":"IF(S187>0,\"Brickmould Height:\",0)","v":0},{"$f":"IF(S187>0,K129,0)","v":0}]
[null,null,"Cut L @ Vert & Slant:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_3>0,OFFSET>0,SHAPE=126),EXTOFFSET/SIN(RADIANS((180-D185)/2)),0)","v":0},null,"Glass Width:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_3>0,OFFSET>0,SHAPE=126),SHAPEW-(OFFSET*2),0)","v":0},null,null,null,null,null,null,null,null,null,null,121,{"$f":"IF(AND(SHAPE=R188,BM_SELECT>1),16,0)","v":0},{"$f":"IF(S188>0,\"Bm Hor. Leg:\",0)","v":0},{"$f":"IF(S188>0,K130,0)","v":0}]
[null,null,"All 45O Cuts:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_3>0,OFFSET>0,SHAPE=126),EXTOFFSET/COS(RADIANS(45)),0)","v":0},null,"Angle @ Leg & Slant",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_3>0,OFFSET>0,SHAPE=126),(180-D185)/2,0)","v":0},null,null,null,null,null,null,null,null,null,null,121,{"$f":"IF(AND(SHAPE=R189,BM_SELECT>1),17,0)","v":0},{"$f":"IF(S189>0,\"BM Slanted Leg:\",0)","v":0},{"$f":"IF(S189>0,K131,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,122,{"$f":"IF(SHAPE=R190,1,0)","v":0},{"$f":"IF(S190>0,\"Frame Height:\",0)","v":0},{"$f":"IF(S190>0,I136,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,122,{"$f":"IF(SHAPE=R191,2,0)","v":0},{"$f":"IF(S191>0,\"Frame Leg:\",0)","v":0},{"$f":"IF(S191>0,I135,0)","v":0},{"$f":"IF(AND(S191>0,C137>0),1,0)","v":0}]
[null,127,"Min R","Max W","Max H","Max UI","Cut L","Min W",null,null,null,null,null,null,null,null,null,122,{"$f":"IF(SHAPE=R192,3,0)","v":0},{"$f":"IF(S192>0,\"Min. Leg:\",0)","v":0},{"$f":"IF(S192>0,C136,0)","v":0},{"$f":"IF(AND(S192>0,C137>0),1,0)","v":0}]
[null,{"$f":"EXT","v":1},{"$f":"MIN_R","v":""},{"$f":"MAX_W","v":""},{"$f":"MAX_H","v":""},{"$f":"MAX_UI","v":""},{"$f":"CUT_LENGTH","v":""},18,null,null,null,null,null,null,{"$f":"VLOOKUP(B192,IMAGE_MODEL,2,FALSE)","v":{"$error":"#VALUE!"}},null,null,122,{"$f":"IF(SHAPE=R193,4,0)","v":0},{"$f":"IF(S193>0,\"Glass Width:\",0)","v":0},{"$f":"IF(S193>0,I137,0)","v":0},{"$f":"IF(AND(U193>0,U193<GlassMinW),1,0)","v":0}]
[null,{"$f":"BM_DYE","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPE=127,D197<C193),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPE=127,EXTLINK>1,SHAPEW>D193),1,0)","v":0},{"$f":"IF(AND(SHAPEH>0,SHAPE=127,EXTLINK>1,SHAPEH>E193),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=127,EXTLINK>1,(SHAPEW+SHAPEH)>F193),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=127,OR(G200>G193,G201>G193)),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=127,EXTLINK>1,SHAPEW<H193),1,0)","v":0},null,null,null,null,null,null,null,null,null,122,{"$f":"IF(SHAPE=R194,5,0)","v":0},{"$f":"IF(S194>0,\"Glass Height:\",0)","v":0},{"$f":"IF(S194>0,I138,0)","v":0},{"$f":"IF(AND(U194>0,U194<GlassMinH),1,0)","v":0}]
[null,null,{"$f":"MAX(C194:H194)","v":0},{"$f":"IF(AND(SHAPE=B192,C195=1),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=127,SHAPEH<=(SHAPEW/2)),1,0)","v":0},{"$f":"IF(AND(SHAPE=127,E195=1),\"FRAME HEIGHT MUST BE GREATER THAN 1/2 THE WIDTH\",IF(AND(SHAPE=127,D199>0,GW_127<GlassMinW),\"Glass Width is Under Minimum\",IF(AND(SHAPE=127,D200>0,GH_127<GlassMinH),\"Glass Height is Under Minimum\",\"\")))","v":""},null,null,null,null,"BM W:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=127),((SHAPEW/2)+(BM-BM_DEDUCT)-L200)*2,0)","v":0},null,null,null,null,null,122,{"$f":"IF(SHAPE=R195,6,0)","v":0},{"$f":"IF(S195>0,\"Glass Leg:\",0)","v":0},{"$f":"IF(S195>0,I139,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"BM H:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=127),((SQRT(L201*((2*L197)-L201))))+(BM-BM_DEDUCT),0)","v":0},null,null,null,null,null,122,{"$f":"IF(SHAPE=R196,7,0)","v":0},{"$f":"IF(S196>0,\"Max Width:\",0)","v":0},{"$f":"IF(S196>0,D136,0)","v":0},{"$f":"IF(AND(S196>0,SHAPEW>0,SHAPEW>U196),1,0)","v":0}]
[null,null,"Frame Radius:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=127),((SHAPEH)^2+(SHAPEW/2)^2)/(2*(SHAPEW/2)),0)","v":0},null,"d",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=127),D198*COS(D201/2),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=127),D197-EXTOFFSET,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=127),H197*COS(H200/2),0)","v":0},null,"BM R:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=127),D197+(BM-BM_DEDUCT),0)","v":0},null,null,null,null,null,122,{"$f":"IF(SHAPE=R197,8,0)","v":0},{"$f":"IF(S197>0,\"Max UI:\",0)","v":0},{"$f":"IF(S197>0,E136,0)","v":0},{"$f":"IF(AND(S197>0,E137>0),1,0)","v":0}]
[null,null,"Glass Radius:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=127),D197-OFFSET,0)","v":0},null,"h",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=127),D198-G197,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=127),(((SHAPEW/2)-((EXTOFFSET*2)+I198))*2)+(EXTOFFSET*2),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=127),H197-I197,0)","v":0},null,"F",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=127),2*(ASIN(((BM-BM_DEDUCT)*2)/(2*L197))),0)","v":0},null,null,null,null,null,122,{"$f":"IF(AND(SHAPE=R198,BM_SELECT>1),9,0)","v":0},{"$f":"IF(S198>0,\"Brickmould Width:\",0)","v":0},{"$f":"IF(S198>0,K137,0)","v":0}]
[null,null,"Glass Width:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=127),(((SHAPEW/2)-((OFFSET*2)+G198))*2)+(OFFSET*2),0)","v":0},null,"h_Glass",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=127),((SHAPEW/2)-((OFFSET*2)+G198)+OFFSET+G198),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=127),((SQRT(I199*((2*H197)-I199))))-EXTOFFSET,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=127),((SHAPEW/2)-((EXTOFFSET*2)+I198)+EXTOFFSET+I198),0)","v":0},null,"d",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=127),L197*COS(L198/2),0)","v":0},null,null,null,null,null,122,{"$f":"IF(AND(SHAPE=R198,BM_SELECT>1),10,0)","v":0},{"$f":"IF(S199>0,\"Brickmould Height:\",0)","v":0},{"$f":"IF(S199>0,K138,0)","v":0}]
[null,null,"Glass Height:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=127),((SQRT(G199*((2*D198)-G199))))-OFFSET,0)","v":0},null,"Cut @ Peak:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=127),SHAPEH-EXTOFFSET-H199,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=127),2*(ASIN((EXTOFFSET*2)/(2*H197))),0)","v":0},null,null,"h",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=127),L197-L199,0)","v":0},null,null,null,null,null,122,{"$f":"IF(AND(SHAPE=R198,BM_SELECT>1),11,0)","v":0},{"$f":"IF(S200>0,\"Brickmould Segment:\",0)","v":0},{"$f":"IF(S200>0,K139,0)","v":0}]
[null,null,"F",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=127),2*(ASIN((OFFSET*2)/(2*D198))),0)","v":0},null,"Cut @ Corners:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=127),SQRT(EXTOFFSET^2+((SHAPEW/2)-(I199-I198))^2),0)","v":0},null,null,null,"h_BM",{"$f":"(SHAPEW/2)+2.243","v":2.2429999999999999},null,null,null,null,null,123,{"$f":"IF(SHAPE=R201,1,0)","v":0},{"$f":"IF(S201>0,\"Roof Pitch:\",0)","v":0},{"$f":"IF(S201>0,D148,0)","v":0}]
[null,null,null,{"$f":"DEGREES(D201)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,123,{"$f":"IF(SHAPE=R202,2,0)","v":0},{"$f":"IF(S202>0,\"Horizontal Segment:\",0)","v":0},{"$f":"IF(S202>0,D150,0)","v":0},{"$f":"IF(AND(S202>0,D145>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,123,{"$f":"IF(SHAPE=R203,3,0)","v":0},{"$f":"IF(S203>0,\"Vertical Segment:\",0)","v":0},{"$f":"IF(S203>0,D149,0)","v":0},{"$f":"IF(AND(S203>0,D145>0),1,0)","v":0}]
[null,128,"Min R","Max W","Max H","Min Leg","Max UI","Cut L","Min W",null,null,null,null,null,null,null,null,123,{"$f":"IF(SHAPE=R204,4,0)","v":0},{"$f":"IF(S204>0,\"Slanted Segment:\",0)","v":0},{"$f":"IF(S204>0,D151,0)","v":0},{"$f":"IF(AND(S204>0,D145>0),1,0)","v":0}]
[null,{"$f":"EXT","v":1},{"$f":"MIN_R","v":""},{"$f":"MAX_W","v":""},{"$f":"MAX_H","v":""},{"$f":"MIN_LEG","v":""},{"$f":"MAX_UI","v":""},{"$f":"CUT_LENGTH","v":""},18,null,"BM Leg:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=128),DIM_4+(BM-BM_DEDUCT),0)","v":0},null,null,{"$f":"VLOOKUP(B204,IMAGE_MODEL,2,FALSE)","v":{"$error":"#VALUE!"}},null,null,123,{"$f":"IF(SHAPE=R205,5,0)","v":0},{"$f":"IF(S205>0,\"Glass Width:\",0)","v":0},{"$f":"IF(S205>0,GW_123,0)","v":0},{"$f":"IF(AND(U205>0,U205<GlassMinW),1,0)","v":0}]
[null,{"$f":"BM_DYE","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,EXTLINK>1,SHAPE=128,D208<C205),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPE=128,EXTLINK>1,SHAPEH>0,DIM_4>0,SHAPEW>D205),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPE=128,EXTLINK>1,SHAPEH>0,DIM_4>0,SHAPEH>E205),1,0)","v":0},{"$f":"IF(AND(SHAPEH>0,SHAPE=128,EXTLINK>1,DIM_4<F205),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=128,EXTLINK>1,(SHAPEW+SHAPEH)>G205),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,OFFSET>0,SHAPE=128,OR(G212>H205,G213>H205)),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=128,SHAPE=127,EXTLINK>1,SHAPEW<I205),1,0)","v":0},null,"BM W:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=128),SHAPEW+((BM-BM_DEDUCT)*2),0)","v":0},null,null,null,null,null,123,{"$f":"IF(SHAPE=R206,6,0)","v":0},{"$f":"IF(S206>0,\"Glass Height:\",0)","v":0},{"$f":"IF(S206>0,GH_123,0)","v":0},{"$f":"IF(AND(U206>0,U206<GlassMinH),1,0)","v":0}]
[null,null,{"$f":"MAX(C206:I206)","v":0},{"$f":"IF(AND(SHAPE=B204,C207=1),1,0)","v":0},null,{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,(SHAPEH-DIM_4)<=(SHAPEW/2)),1,0)","v":0},{"$f":"IF(AND(SHAPE=128,F207=1),\"FRAME HEIGHT MINUS DIM4, MUST BE GREATER THAN 1/2 THE WIDTH\",IF(AND(SHAPE=128,SHAPEW>0,C206>0),\"RADIUS MUST BE GREATER THAN \"&C205,IF(AND(SHAPE=128,D210>0,GW_128<GlassMinW),\"Glass Width is Under Minimum\",IF(AND(SHAPE=128,D211>0,GH_128<GlassMinH),\"Glass Height is Under Minimum\",\"\"))))","v":""},null,null,null,"BM H:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=128),((SQRT(L212*((2*L208)-L201))))+(BM-BM_DEDUCT)+DIM_4,0)","v":0},null,null,null,null,null,123,{"$f":"IF(SHAPE=R207,7,0)","v":0},{"$f":"IF(S207>0,\"Glass Hor. Leg:\",0)","v":0},{"$f":"IF(S207>0,D153,0)","v":0}]
[null,null,"Frame Radius:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,OFFSET>0,SHAPE=128),(((SHAPEH-DIM_4))^2+(SHAPEW/2)^2)/(2*(SHAPEW/2)),0)","v":0},null,"F",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,OFFSET>0,SHAPE=128),2*(ASIN((OFFSET*2)/(2*D209))),0)","v":0},null,null,null,"BM R:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=128),D208+(BM-BM_DEDUCT),0)","v":0},null,null,null,null,null,123,{"$f":"IF(SHAPE=R208,8,0)","v":0},{"$f":"IF(S208>0,\"Glass Vert. Leg:\",0)","v":0},{"$f":"IF(S208>0,D152,0)","v":0}]
[null,null,"Glass Radius:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,OFFSET>0,SHAPE=128),D208-OFFSET,0)","v":0},null,"d",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,OFFSET>0,SHAPE=128),D209*COS(G208/2),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,OFFSET>0,SHAPE=128),D208-EXTOFFSET,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,OFFSET>0,SHAPE=128),2*(ASIN((EXTOFFSET*2)/(2*H209))),0)","v":0},null,"F",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=128),2*(ASIN(((BM-BM_DEDUCT)*2)/(2*L208))),0)","v":0},null,null,null,null,null,123,{"$f":"IF(SHAPE=R209,9,0)","v":0},{"$f":"IF(S209>0,\"Max Width:\",0)","v":0},{"$f":"IF(S209>0,E144,0)","v":0},{"$f":"IF(AND(S209>0,E145>0),1,0)","v":0}]
[null,null,"Glass Width:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,EXTLINK>1,SHAPE=128),SHAPEW-(OFFSET*2),0)","v":0},null,"h",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,OFFSET>0,SHAPE=128),D209-G209,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,OFFSET>0,SHAPE=128),SHAPEW-(EXTOFFSET*2),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,OFFSET>0,SHAPE=128),H209*COS(I209/2),0)","v":0},null,"d",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=128),L208*COS(L209/2),0)","v":0},null,null,null,null,null,123,{"$f":"IF(SHAPE=R210,10,0)","v":0},{"$f":"IF(S210>0,\"Max Height:\",0)","v":0},{"$f":"IF(S210>0,F144,0)","v":0},{"$f":"IF(AND(S210>0,F145>0),1,0)","v":0}]
[null,null,"Glass Height:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,EXTLINK>1,SHAPE=128),(((SQRT((D209-(((SHAPEW/2)-OFFSET)/2))*(8*((SHAPEW/2)-OFFSET))))/2)-OFFSET)+DIM_4,0)","v":0},null,"h_Glass",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,OFFSET>0,SHAPE=128),((SHAPEW/2)-((OFFSET*2)+G210)+OFFSET+G210),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,OFFSET>0,SHAPE=128),(((SQRT(I212*((2*H209)-I212))))-EXTOFFSET)+DIM_4,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,OFFSET>0,SHAPE=128),H209-I210,0)","v":0},null,"h",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=128),L208-L210,0)","v":0},null,null,null,null,null,123,{"$f":"IF(SHAPE=R211,11,0)","v":0},{"$f":"IF(S211>0,\"Max UI:\",0)","v":0},{"$f":"IF(S212>0,G144,0)","v":0},{"$f":"IF(AND(S211>0,G145>0),1,0)","v":0}]
[null,null,"Glass Leg H:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,EXTLINK>1,SHAPE=128),DIM_4-OFFSET,0)","v":0},null,"Cut @ Peak:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,OFFSET>0,SHAPE=128),SHAPEH-EXTOFFSET-H211,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,OFFSET>0,SHAPE=128),DIM_4-EXTOFFSET,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,OFFSET>0,SHAPE=128),((SHAPEW/2)-((EXTOFFSET*2)+I211)+EXTOFFSET+I211),0)","v":0},null,"h_BM",{"$f":"(SHAPEW/2)+2.243","v":2.2429999999999999},null,null,null,null,null,123,{"$f":"IF(AND(SHAPE=R212,BM_SELECT>1),12,0)","v":0},{"$f":"IF(S212>0,\"Brickmould Width:\",0)","v":0},{"$f":"IF(S212>0,I149,0)","v":0}]
[null,null,null,null,null,"Cut @ Corners:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_4>0,OFFSET>0,SHAPE=128),SQRT(EXTOFFSET^2+EXTOFFSET^2),0)","v":0},null,null,null,null,null,null,null,null,null,null,123,{"$f":"IF(AND(SHAPE=R213,BM_SELECT>1),13,0)","v":0},{"$f":"IF(S213>0,\"Brickmould Height:\",0)","v":0},{"$f":"IF(S213>0,I150,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,123,{"$f":"IF(AND(SHAPE=R214,BM_SELECT>1),14,0)","v":0},{"$f":"IF(S214>0,\"BM Hor. Leg:\",0)","v":0},{"$f":"IF(S214>0,I152,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,123,{"$f":"IF(AND(SHAPE=R215,BM_SELECT>1),15,0)","v":0},{"$f":"IF(S215>0,\"BM Vert. Leg:\",0)","v":0},{"$f":"IF(S215>0,I151,0)","v":0}]
[null,129,"Min Side","Min Cut","Max W","Max H","Max UI","Min Angle",null,null,null,null,null,null,null,null,null,123,{"$f":"IF(AND(SHAPE=R216,BM_SELECT>1),16,0)","v":0},{"$f":"IF(S216>0,\"BM Slanted Leg:\",0)","v":0},{"$f":"IF(S216>0,I153,0)","v":0}]
[null,{"$f":"EXT","v":1},{"$f":"MIN_LEG","v":""},{"$f":"CUT_LENGTH","v":""},{"$f":"MAX_W","v":""},{"$f":"MAX_H","v":""},{"$f":"MAX_UI","v":""},{"$f":"MIN_ANGLE","v":""},null,null,null,null,null,null,{"$f":"VLOOKUP(B216,IMAGE_MODEL,2,FALSE)","v":{"$error":"#VALUE!"}},null,null,124,{"$f":"IF(SHAPE=R217,1,0)","v":0},{"$f":"IF(S217>0,\"Frame Width:\",0)","v":0},{"$f":"IF(S217>0,SHAPEW,0)","v":0},{"$f":"IF(AND(S217>0,D160>0),1,0)","v":0}]
[null,{"$f":"BM_DYE","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_3>0,EXTLINK>1,SHAPE=129,OR(DIM_3<C217,G223<C217)),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_3>0,EXTLINK>1,SHAPE=129,OR(D224>D217,D223>D217,D222>D217)),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPE=129,EXTLINK>1,SHAPEW>E217),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPE=129,EXTLINK>1,SHAPEH>F217),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=129,EXTLINK>1,(SHAPEW+SHAPEH)>G217),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,DIM_3>0,SHAPE=129,G224<H217),1,0)","v":0},null,null,null,null,null,null,null,null,null,124,{"$f":"IF(SHAPE=R218,2,0)","v":0},{"$f":"IF(S218>0,\"Frame Height:\",0)","v":0},{"$f":"IF(S218>0,I158,0)","v":0},{"$f":"IF(AND(S218>0,E160>0),1,0)","v":0}]
[null,null,{"$f":"MAX(C218:G218)","v":0},{"$f":"IF(AND(SHAPE=B216,C219=1),1,0)","v":0},null,null,{"$f":"IF(AND(SHAPE=129,G221>0,GW_129<GlassMinW),\"Glass Width is Under Minimum\",IF(AND(SHAPE=129,G222>0,GH_129<GlassMinH),\"Glass Height is Under Minimum\",IF(AND(SHAPE=129,SHAPEW>0,SHAPEH>0,G224<0),\"Angle can not be negative\",\"\")))","v":""},null,null,"BM W:",{"$f":"IF(AND(SHAPEH>0,SHAPEW>0,DIM_3>0,OFFSET>0,SHAPE=129),SHAPEW+((BM-BM_DEDUCT)*2),0)","v":0},null,null,null,null,null,null,124,{"$f":"IF(SHAPE=R219,3,0)","v":0},{"$f":"IF(S219>0,\"Segment Length:\",0)","v":0},{"$f":"IF(S219>0,I162,0)","v":0},{"$f":"IF(AND(S219>0,D160>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,"BM H:",{"$f":"IF(AND(SHAPEH>0,SHAPEW>0,DIM_3>0,OFFSET>0,SHAPE=129),SHAPEH+(BM-BM_DEDUCT)+(SQRT(K223^2-(BM-BM_DEDUCT)^2)),0)","v":0},null,null,null,null,null,null,124,{"$f":"IF(SHAPE=R220,4,0)","v":0},{"$f":"IF(S220>0,\"Cut Length:\",0)","v":0},{"$f":"IF(S220>0,I159,0)","v":0},{"$f":"IF(AND(S220>0,C160>0),1,0)","v":0}]
[null,null,"Roof Pitch:",{"$f":"IF(AND(SHAPEH>0,SHAPEW>0,DIM_3>0,OFFSET>0,SHAPE=129),DEGREES(ATAN((SHAPEH-DIM_3)/SHAPEW)),0)","v":0},null,"Glass Width:",{"$f":"IF(AND(SHAPEH>0,SHAPEW>0,DIM_3>0,OFFSET>0,SHAPE=129),SHAPEW-(OFFSET*2),0)","v":0},{"$f":"IF(AND(SHAPEH>0,DIM_3>0,SHAPEW>0,OFFSET>0,SHAPE=129),ROUND((12*((SHAPEH-DIM_3)/SHAPEW)),1)&\" /12\",0)","v":0},null,"BM Leg:",{"$f":"IF(AND(SHAPEH>0,SHAPEW>0,DIM_3>0,OFFSET>0,SHAPE=129),DIM_3+(BM-BM_DEDUCT)+(SQRT(K224^2-(BM-BM_DEDUCT)^2)),0)","v":0},null,null,null,null,null,null,124,{"$f":"IF(SHAPE=R221,5,0)","v":0},{"$f":"IF(S221>0,\"Glass Width:\",0)","v":0},{"$f":"IF(S221>0,I163,0)","v":0},{"$f":"IF(AND(U221>0,U221<GlassMinW),1,0)","v":0}]
[null,null,"Peak & Slant Cut:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=129),EXTOFFSET/SIN(RADIANS((90-D221)/2)),0)","v":0},null,"Glass Height:",{"$f":"IF(AND(SHAPEH>0,SHAPEW>0,DIM_3>0,OFFSET>0,SHAPE=129),SHAPEH-OFFSET-(SQRT(H222^2-OFFSET^2)),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=129),OFFSET/SIN(RADIANS((90-D221)/2)),0)","v":0},null,"BM Slant Leg:",{"$f":"IF(AND(SHAPEH>0,SHAPEW>0,DIM_3>0,OFFSET>0,SHAPE=129),SQRT(K219^2+(K220-K221)^2),0)","v":0},null,null,null,null,null,null,124,{"$f":"IF(SHAPE=R222,6,0)","v":0},{"$f":"IF(S222>0,\"Glass Height:\",0)","v":0},{"$f":"IF(S222>0,I161,0)","v":0},{"$f":"IF(AND(U222>0,U222<GlassMinH),1,0)","v":0}]
[null,null,"Vert & Slant Cut:",{"$f":"IF(AND(SHAPEH>0,SHAPEW>0,DIM_3>0,OFFSET>0,SHAPE=129),EXTOFFSET/COS(RADIANS(((90-D221)/2))),0)","v":0},null,"Slanted Leg:",{"$f":"IF(AND(SHAPEH>0,SHAPEW>0,DIM_3>0,OFFSET>0,SHAPE=129),SQRT(SHAPEW^2+(SHAPEH-DIM_3)^2),0)","v":0},{"$f":"IF(AND(SHAPEH>0,SHAPEW>0,DIM_3>0,OFFSET>0,SHAPE=129),OFFSET/COS(RADIANS(((90-D221)/2))),0)","v":0},null,null,{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,DIM_3>0,SHAPE=129),(BM-BM_DEDUCT)/SIN(RADIANS((90-D221)/2)),0)","v":0},null,null,null,null,null,null,124,{"$f":"IF(SHAPE=R223,7,0)","v":0},{"$f":"IF(S223>0,\"Glass Leg:\",0)","v":0},{"$f":"IF(S223>0,I164,0)","v":0}]
[null,null,"All 45O Cuts:",{"$f":"IF(AND(SHAPEH>0,SHAPEW>0,DIM_3>0,OFFSET>0,SHAPE=129),EXTOFFSET/COS(RADIANS(45)),0)","v":0},null,"Peak Cut Angle:",{"$f":"IF(AND(SHAPEH>0,SHAPEW>0,DIM_3>0,OFFSET>0,SHAPE=129),DEGREES(ASIN(EXTOFFSET/D222)),0)","v":0},{"$f":"IF(AND(SHAPEH>0,SHAPEW>0,DIM_3>0,OFFSET>0,SHAPE=129),OFFSET/COS(RADIANS(45)),0)","v":0},null,null,{"$f":"IF(AND(SHAPEH>0,SHAPEW>0,DIM_3>0,OFFSET>0,SHAPE=129),(BM-BM_DEDUCT)/COS(RADIANS(((90-D221)/2))),0)","v":0},null,null,null,null,null,null,124,{"$f":"IF(SHAPE=R224,8,0)","v":0},{"$f":"IF(S224>0,\"Max Height:\",0)","v":0},{"$f":"IF(S224>0,E159,0)","v":0},{"$f":"IF(AND(S224>0,SHAPEW>0,SHAPEH>E159),1,0)","v":0}]
[null,null,"Glass Dim3:",{"$f":"IF(AND(SHAPEH>0,SHAPEW>0,DIM_3>0,OFFSET>0,SHAPE=129),DIM_3-OFFSET-(SQRT(H223^2-OFFSET^2)),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,124,{"$f":"IF(SHAPE=R225,9,0)","v":0},{"$f":"IF(S225>0,\"Max UI:\",0)","v":0},{"$f":"IF(S225>0,F159,0)","v":0},{"$f":"IF(AND(S225>0,F160>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,124,{"$f":"IF(AND(SHAPE=R226,BM_SELECT>1),10,0)","v":0},{"$f":"IF(S226>0,\"Brickmould Width:\",0)","v":0},{"$f":"IF(S226>0,K159,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,124,{"$f":"IF(AND(SHAPE=R226,BM_SELECT>1),11,0)","v":0},{"$f":"IF(S227>0,\"Brickmould Height:\",0)","v":0},{"$f":"IF(S227>0,K160,0)","v":0},{"$f":"IF(AND(S227>0,SHAPEW>0,SHAPEH>E162),1,0)","v":0}]
[null,130,"Min Side","Min Cut","Max W","Max H","Max UI","Min Angle",null,null,null,null,null,null,null,null,null,124,{"$f":"IF(AND(SHAPE=R226,BM_SELECT>1),12,0)","v":0},{"$f":"IF(S228>0,\"BM Segment:\",0)","v":0},{"$f":"IF(S228>0,K159,0)","v":0},{"$f":"IF(AND(S228>0,F163>0),1,0)","v":0}]
[null,{"$f":"EXT","v":1},{"$f":"MIN_LEG","v":""},{"$f":"CUT_LENGTH","v":""},{"$f":"MAX_W","v":""},{"$f":"MAX_H","v":""},{"$f":"MAX_UI","v":""},{"$f":"MIN_ANGLE","v":""},null,null,null,null,null,null,{"$f":"VLOOKUP(B228,IMAGE_MODEL,2,FALSE)","v":{"$error":"#VALUE!"}},null,null,125,{"$f":"IF(SHAPE=R229,1,0)","v":0},{"$f":"IF(S229>0,\"Roof Pitch:\",0)","v":0},{"$f":"IF(S229>0,H173,0)","v":0}]
[null,{"$f":"BM_DYE","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=130,OR(SHAPEW<C229,SHAPEH<C229)),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=130,EXTLINK>1,OR(D233>D229,D234>D229,D235>D229)),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,SHAPE=130,SHAPEW>E229),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,SHAPE=130,SHAPEH>F229),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,SHAPE=130,(SHAPEW+SHAPEH)>G229),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,SHAPE=130,OR(G235<H229,G236<H229)),1,0)","v":0},null,null,null,null,null,null,null,null,null,125,{"$f":"IF(SHAPE=R230,2,0)","v":0},{"$f":"IF(S230>0,\"Horizontal Leg:\",0)","v":0},{"$f":"IF(S230>0,DIM_4,0)","v":0},{"$f":"IF(AND(S230>0,C170>0),1,0)","v":0}]
[null,null,{"$f":"MAX(C230:H230)","v":0},{"$f":"IF(AND(SHAPE=B228,C231=1),1,0)","v":0},null,null,{"$f":"IF(AND(SHAPE=130,D236>0,GW_130<GlassMinW),\"Glass Width is Under Minimum\",IF(AND(SHAPE=130,G233>0,GH_130<GlassMinH),\"Glass Height is Under Minimum\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,125,{"$f":"IF(SHAPE=R231,3,0)","v":0},{"$f":"IF(S231>0,\"Vertical Leg:\",0)","v":0},{"$f":"IF(S231>0,DIM_3,0)","v":0},{"$f":"IF(AND(S231>0,C170>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,"BM W:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=130),SHAPEW+(BM-BM_DEDUCT)+(SQRT(K235^2-(BM-BM_DEDUCT)^2)),0)","v":0},null,null,null,null,null,null,125,{"$f":"IF(SHAPE=R232,4,0)","v":0},{"$f":"IF(S232>0,\"Slanted Leg:\",0)","v":0},{"$f":"IF(S232>0,G176,0)","v":0},{"$f":"IF(AND(S232>0,C170>0),1,0)","v":0}]
[null,null,"Bottom Cut L:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=130),EXTOFFSET/(SIN(RADIANS((DEGREES(ATAN(SHAPEH/SHAPEW)))/2))),0)","v":0},null,"Glass Height:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=130),SHAPEH-OFFSET-(SQRT(H236^2-OFFSET^2)),0)","v":0},null,null,"BM H:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=130),SHAPEH+(BM-BM_DEDUCT)+(SQRT(K236^2-(BM-BM_DEDUCT)^2)),0)","v":0},null,null,null,null,null,null,125,{"$f":"IF(SHAPE=R233,5,0)","v":0},{"$f":"IF(S233>0,\"Vert & Slant Angle:\",0)","v":0},{"$f":"IF(S233>0,G174,0)","v":0},{"$f":"IF(AND(S233>0,H170>0),1,0)","v":0}]
[null,null,"Top Cut Length:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=130),EXTOFFSET/(SIN(RADIANS((DEGREES(ATAN(SHAPEW/SHAPEH)))/2))),0)","v":0},null,"Roof Pitch:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=130),DEGREES(ATAN(SHAPEH/SHAPEW)),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=130),ROUND((12*(TAN(RADIANS(G234)))),1)&\" /12\",0)","v":0},null,"BM Slant Leg:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=130),SQRT(K232^2+K233^2),0)","v":0},null,null,null,null,null,null,125,{"$f":"IF(SHAPE=R234,6,0)","v":0},{"$f":"IF(S234>0,\"Hor & Slant Angle:\",0)","v":0},{"$f":"IF(S234>0,D173,0)","v":0},{"$f":"IF(AND(S234>0,H170>0),1,0)","v":0}]
[null,null,"Corner Cut L:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=130),SQRT(EXTOFFSET^2+EXTOFFSET^2),0)","v":0},null,"Peak Angle:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=130),(180-G234-90)/2,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=130),OFFSET/(SIN(RADIANS((DEGREES(ATAN(SHAPEH/SHAPEW)))/2))),0)","v":0},null,null,{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=130),(BM-BM_DEDUCT)/(SIN(RADIANS((DEGREES(ATAN(SHAPEH/SHAPEW)))/2))),0)","v":0},null,null,null,null,null,null,125,{"$f":"IF(SHAPE=R235,7,0)","v":0},{"$f":"IF(S235>0,\"Glass Width:\",0)","v":0},{"$f":"IF(S235>0,GW_125,0)","v":0},{"$f":"IF(AND(S235>0,SHAPEW>0,SHAPEH>0,DIM_3>0,DIM_4>0,GW_125<GlassMinW),1,0)","v":0}]
[null,null,"Glass Width:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=130),SHAPEW-OFFSET-(SQRT(H235^2-OFFSET^2)),0)","v":0},null,"Bott Corner Angle:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=130),G234/2,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=130),OFFSET/(SIN(RADIANS((DEGREES(ATAN(SHAPEW/SHAPEH)))/2))),0)","v":0},null,null,{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=130),(BM-BM_DEDUCT)/(SIN(RADIANS((DEGREES(ATAN(SHAPEW/SHAPEH)))/2))),0)","v":0},null,null,null,null,null,null,125,{"$f":"IF(SHAPE=R236,8,0)","v":0},{"$f":"IF(S236>0,\"Glass Height:\",0)","v":0},{"$f":"IF(S236>0,GH_125,0)","v":0},{"$f":"IF(AND(S236>0,SHAPEW>0,SHAPEH>0,DIM_3>0,DIM_4>0,GH_125<GlassMinH),1,0)","v":0}]
[null,null,"Slanted Leg:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=130),SQRT(SHAPEW^2+SHAPEH^2),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,125,{"$f":"IF(SHAPE=R237,9,0)","v":0},{"$f":"IF(S237>0,\"Glass Dim3:\",0)","v":0},{"$f":"IF(S237>0,G176,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,125,{"$f":"IF(SHAPE=R238,10,0)","v":0},{"$f":"IF(S238>0,\"Glass Dim4:\",0)","v":0},{"$f":"IF(S238>0,G177,0)","v":0}]
[null,131,"Min Side","Min Cut","Max W","Max H","Max UI","Min W",null,null,null,null,null,null,{"$f":"VLOOKUP(B239,IMAGE_MODEL,2,FALSE)","v":{"$error":"#VALUE!"}},null,null,125,{"$f":"IF(SHAPE=R239,11,0)","v":0},{"$f":"IF(S239>0,\"Max Width:\",0)","v":0},{"$f":"IF(S239>0,E169,0)","v":0},{"$f":"IF(AND(S239>0,SHAPEW>0,SHAPEW>U239),1,0)","v":0}]
[null,{"$f":"EXT","v":1},{"$f":"MIN_LEG","v":""},{"$f":"CUT_LENGTH","v":""},{"$f":"MAX_W","v":""},{"$f":"MAX_H","v":""},{"$f":"MAX_UI","v":""},12,null,null,null,null,null,null,null,null,null,125,{"$f":"IF(SHAPE=R240,12,0)","v":0},{"$f":"IF(S240>0,\"Max Height:\",0)","v":0},{"$f":"IF(S240>0,F169,0)","v":0},{"$f":"IF(AND(S240>0,SHAPEH>0,SHAPEH>U240),1,0)","v":0}]
[null,{"$f":"BM_DYE","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=131,SHAPEW<C240),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=131,D245>D240),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=131,SHAPEW>E240),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=131,SHAPEH>F240),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=131,(SHAPEW+SHAPEH)>G240),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,EXTLINK>1,SHAPE=131,SHAPEW<H240),1,0)","v":0},null,null,null,null,null,null,null,null,null,125,{"$f":"IF(SHAPE=R241,13,0)","v":0},{"$f":"IF(S241>0,\"Max UI:\",0)","v":0},{"$f":"IF(S241>0,G169,0)","v":0},{"$f":"IF(AND(S241>0,G170>0),1,0)","v":0}]
[null,null,{"$f":"MAX(C241:H241)","v":0},{"$f":"IF(AND(SHAPE=B239,C242=1),1,0)","v":0},null,null,{"$f":"IF(AND(SHAPE=131,G244>0,G244<GlassMinW),\"Glass Width is Under Minimum\",IF(AND(SHAPE=131,G245>0,G245<GlassMinH),\"Glass Height is Under Minimum\",\"\"))","v":""},null,null,"BM W:",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=131),SHAPEW+((SQRT(K245^2-(BM-BM_DEDUCT)^2))*2),0)","v":0},null,null,null,null,null,null,125,{"$f":"IF(AND(SHAPE=R242,BM_SELECT>1),14,0)","v":0},{"$f":"IF(S242>0,\"Brickmould Width:\",0)","v":0},{"$f":"IF(S242>0,J173,0)","v":0}]
[null,null,null,null,null,null,null,null,null,"BM H:",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=131),K242*SIN(RADIANS(60)),0)","v":0},null,null,null,null,null,null,125,{"$f":"IF(AND(SHAPE=R242,BM_SELECT>1),15,0)","v":0},{"$f":"IF(S243>0,\"Brickmould Height:\",0)","v":0},{"$f":"IF(S243>0,J174,0)","v":0}]
[null,null,"Corner Cut L:",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=131),EXTOFFSET/(SIN(RADIANS(30))),0)","v":0},null,"Glass Height:",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=131),G245-OFFSET-H245,0)","v":0},{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=131),OFFSET/(SIN(RADIANS(30))),0)","v":0},null,"BM Slant Leg:",{"$f":"K242","v":0},null,null,null,null,null,null,125,{"$f":"IF(AND(SHAPE=R242,BM_SELECT>1),16,0)","v":0},{"$f":"IF(S244>0,\"BM Hor. Leg:\",0)","v":0},{"$f":"IF(S244>0,J175,0)","v":0}]
[null,null,"Top Cut Length:",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=131),EXTOFFSET/(SIN(RADIANS(30))),0)","v":0},null,"Frame Height:",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=131),SHAPEW*SIN(RADIANS(60)),0)","v":0},{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=131),OFFSET/(SIN(RADIANS(30))),0)","v":0},null,null,{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=131),(BM-BM_DEDUCT)/(SIN(RADIANS(30))),0)","v":0},null,null,null,null,null,null,125,{"$f":"IF(AND(SHAPE=R242,BM_SELECT>1),17,0)","v":0},{"$f":"IF(S245>0,\"BM Vert. Leg:\",0)","v":0},{"$f":"IF(S245>0,J176,0)","v":0}]
[null,null,"Glass Width:",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=131),SHAPEW-((SQRT(H244^2-OFFSET^2))*2),0)","v":0},null,"Roof Pitch:",{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=131),ROUND((TAN(RADIANS((60)))*12),1)&\" /12\",0)","v":0},null,null,null,{"$f":"IF(AND(SHAPEW>0,OFFSET>0,SHAPE=131),(BM-BM_DEDUCT)/(SIN(RADIANS(30))),0)","v":0},null,null,null,null,null,null,125,{"$f":"IF(AND(SHAPE=R242,BM_SELECT>1),18,0)","v":0},{"$f":"IF(S246>0,\"BM Slanted Leg:\",0)","v":0},{"$f":"IF(S246>0,J177,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,126,{"$f":"IF(SHAPE=R247,1,0)","v":0},{"$f":"IF(S247>0,\"Roof Pitch:\",0)","v":0},{"$f":"IF(S247>0,H185,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,126,{"$f":"IF(SHAPE=R248,2,0)","v":0},{"$f":"IF(S248>0,\"Slanted Leg:\",0)","v":0},{"$f":"IF(S248>0,G187,0)","v":0},{"$f":"IF(AND(S248>0,C218>0),1,0)","v":0}]
[null,132,"Min Side","Min Cut","Max W","Max H","Max UI","Min Angle","Min W",null,null,null,null,null,{"$f":"VLOOKUP(B249,IMAGE_MODEL,2,FALSE)","v":{"$error":"#VALUE!"}},null,null,126,{"$f":"IF(SHAPE=R249,3,0)","v":0},{"$f":"IF(S249>0,\"Vertical Leg:\",0)","v":0},{"$f":"IF(S249>0,DIM_3,0)","v":0},{"$f":"IF(AND(S249>0,C218>0),1,0)","v":0}]
[null,{"$f":"EXT","v":1},{"$f":"MIN_LEG","v":""},{"$f":"CUT_LENGTH","v":""},{"$f":"MAX_W","v":""},{"$f":"MAX_H","v":""},{"$f":"MAX_UI","v":""},{"$f":"MIN_ANGLE","v":""},12,null,null,null,null,null,null,null,null,126,{"$f":"IF(SHAPE=R250,4,0)","v":0},{"$f":"IF(S250>0,\"Leg & Slant Angle:\",0)","v":0},{"$f":"IF(S250>0,G189,0)","v":0},{"$f":"IF(AND(S250>0,H182>0),1,0)","v":0}]
[null,{"$f":"BM_DYE","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,SHAPE=132,OR(SHAPEW<C250,D256<C250)),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,SHAPE=132,OR(D253>D250,D254>D250)),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,SHAPE=132,SHAPEW>E250),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,SHAPE=132,SHAPEH>F250),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,SHAPE=132,(SHAPEW+SHAPEH)>G250),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,EXTLINK>1,SHAPE=130,OR(G253/2>H250,G254/2>H250)),1,0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,SHAPE=132,EXTLINK>1,SHAPEW<I250),1,0)","v":0},null,null,null,null,null,null,null,null,126,{"$f":"IF(SHAPE=R251,5,0)","v":0},{"$f":"IF(S251>0,\"Leg & Slant Cut L:\",0)","v":0},{"$f":"IF(S251>0,D188,0)","v":0},{"$f":"IF(AND(S251>0,C18>0),1,0)","v":0}]
[null,null,{"$f":"MAX(C251:I251)","v":0},{"$f":"IF(AND(SHAPE=B249,C252=1),1,0)","v":0},null,null,{"$f":"IF(AND(SHAPE=132,D255>0,GW_132<GlassMinW),\"Glass Width is Under Minimum\",IF(AND(SHAPE=132,D256>0,GH_132<GlassMinH),\"Glass Height is Under Minimum\",\"\"))","v":""},null,null,null,"BM W:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=132),SHAPEW+((SQRT(L255^2-(BM-BM_DEDUCT)^2))*2),0)","v":0},null,null,null,null,null,126,{"$f":"IF(SHAPE=R252,6,0)","v":0},{"$f":"IF(S252>0,\"Peak Cut Length:\",0)","v":0},{"$f":"IF(S252>0,D187,0)","v":0},{"$f":"IF(AND(S252>0,C218>0),1,0)","v":0}]
[null,null,"Bottom Cut L:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=132),EXTOFFSET/(SIN(RADIANS(G253/2))),0)","v":0},null,"Bottom Angles:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=132),DEGREES(ATAN(SHAPEH/(SHAPEW/2))),0)","v":0},null,null,null,"BM H:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=132),SHAPEH+(BM-BM_DEDUCT)+L256,0)","v":0},null,null,null,null,null,126,{"$f":"IF(SHAPE=R253,7,0)","v":0},{"$f":"IF(S253>0,\"Corners Cut L:\",0)","v":0},{"$f":"IF(S253>0,D189,0)","v":0},{"$f":"IF(AND(S253>0,C218>0),1,0)","v":0}]
[null,null,"Top Cut Length:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=132),EXTOFFSET/(SIN(RADIANS(G254/2))),0)","v":0},null,"Peak Angle:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=132),180-(G253*2),0)","v":0},{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=132),ROUND((12*(TAN(RADIANS(G253)))),1)&\" /12\",0)","v":0},"Roof Pitch",null,"BM Slant Leg:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=132),SQRT(L253^2+(L252/2)^2),0)","v":0},null,null,null,null,null,126,{"$f":"IF(SHAPE=R254,8,0)","v":0},{"$f":"IF(S254>0,\"Glass Width:\",0)","v":0},{"$f":"IF(S254>0,GW_126,0)","v":0},{"$f":"IF(AND(U254>0,GW_126<GlassMinW),1,0)","v":0}]
[null,null,"Glass Width:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=132),SHAPEW-((SQRT(G256^2-OFFSET^2))*2),0)","v":0},null,"Sides Length:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=132),SQRT(SHAPEH^2+(SHAPEW/2)^2),0)","v":0},null,null,null,null,{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=132),(BM-BM_DEDUCT)/(SIN(RADIANS(G253/2))),0)","v":0},null,null,null,null,null,126,{"$f":"IF(SHAPE=R255,9,0)","v":0},{"$f":"IF(S255>0,\"Glass Height:\",0)","v":0},{"$f":"IF(S255>0,GH_126,0)","v":0},{"$f":"IF(AND(U255>0,GH_126<GlassMinH),1,0)","v":0}]
[null,null,"Glass Height:",{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=132),SHAPEH-OFFSET-G257,0)","v":0},null,null,{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=132),OFFSET/(SIN(RADIANS(G253/2))),0)","v":0},null,null,null,null,{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=132),(BM-BM_DEDUCT)/(SIN(RADIANS(G254/2))),0)","v":0},null,null,null,null,null,126,{"$f":"IF(SHAPE=R256,10,0)","v":0},{"$f":"IF(S256>0,\"Glass Leg:\",0)","v":0},{"$f":"IF(S256>0,G186,0)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(AND(SHAPEW>0,SHAPEH>0,OFFSET>0,SHAPE=132),OFFSET/(SIN(RADIANS(G254/2))),0)","v":0},null,null,null,null,null,null,null,null,null,null,126,{"$f":"IF(SHAPE=R257,11,0)","v":0},{"$f":"IF(S257>0,\"Max Width:\",0)","v":0},{"$f":"IF(S257>0,E181,0)","v":0},{"$f":"IF(AND(S257>0,E182>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,126,{"$f":"IF(SHAPE=R258,12,0)","v":0},{"$f":"IF(S258>0,\"Max Height:\",0)","v":0},{"$f":"IF(S258>0,F181,0)","v":0},{"$f":"IF(AND(S258>0,F182>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,126,{"$f":"IF(SHAPE=R259,13,0)","v":0},{"$f":"IF(S259>0,\"Max UI:\",0)","v":0},{"$f":"IF(S259>0,G181,0)","v":0},{"$f":"IF(AND(S259>0,G182>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,126,{"$f":"IF(AND(SHAPE=R260,BM_SELECT>1),14,0)","v":0},{"$f":"IF(S260>0,\"Brickmould Width:\",0)","v":0},{"$f":"IF(S260>0,K182,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,126,{"$f":"IF(AND(SHAPE=R260,BM_SELECT>1),15,0)","v":0},{"$f":"IF(S261>0,\"Brickmould Height:\",0)","v":0},{"$f":"IF(S261>0,K183,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,126,{"$f":"IF(AND(SHAPE=R260,BM_SELECT>1),16,0)","v":0},{"$f":"IF(S262>0,\"Brickmould Leg:\",0)","v":0},{"$f":"IF(S262>0,K184,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,126,{"$f":"IF(AND(SHAPE=R260,BM_SELECT>1),17,0)","v":0},{"$f":"IF(S263>0,\"BM Slanted Leg:\",0)","v":0},{"$f":"IF(S263>0,K185,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,127,{"$f":"IF(SHAPE=R264,1,0)","v":0},{"$f":"IF(S264>0,\"Frame Radius:\",0)","v":0},{"$f":"IF(S264>0,D197,0)","v":0},{"$f":"IF(AND(S264>0,SHAPEW>0,SHAPEH>0,C194>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,127,{"$f":"IF(SHAPE=R265,2,0)","v":0},{"$f":"IF(S265>0,\"Peak Cut Length:\",0)","v":0},{"$f":"IF(S265>0,G200,0)","v":0},{"$f":"IF(AND(S265>0,G194>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,127,{"$f":"IF(SHAPE=R266,3,0)","v":0},{"$f":"IF(S266>0,\"Corner Cut Length:\",0)","v":0},{"$f":"IF(S266>0,G201,0)","v":0},{"$f":"IF(AND(S266>0,SHAPEW>0,SHAPEH>0,G194>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,127,{"$f":"IF(SHAPE=R267,4,0)","v":0},{"$f":"IF(S267>0,\"Glas Width:\",0)","v":0},{"$f":"IF(S267>0,GW_127,0)","v":0},{"$f":"IF(AND(U267>0,GW_127<GlassMinW),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,127,{"$f":"IF(SHAPE=R268,5,0)","v":0},{"$f":"IF(S268>0,\"Glass Height:\",0)","v":0},{"$f":"IF(S268>0,GH_127,0)","v":0},{"$f":"IF(AND(U268>0,GH_127<GlassMinH),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,127,{"$f":"IF(SHAPE=R269,6,0)","v":0},{"$f":"IF(S269>0,\"Glass Radius:\",0)","v":0},{"$f":"IF(S269>0,D198,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,127,{"$f":"IF(SHAPE=R270,7,0)","v":0},{"$f":"IF(S270>0,\"Max Width:\",0)","v":0},{"$f":"IF(S270>0,MAX_W,0)","v":0},{"$f":"IF(AND(U270>0,D194>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,127,{"$f":"IF(SHAPE=R271,8,0)","v":0},{"$f":"IF(S271>0,\"Max Height:\",0)","v":0},{"$f":"IF(S271>0,MAX_H,0)","v":0},{"$f":"IF(AND(U271>0,E194>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,127,{"$f":"IF(SHAPE=R272,9,0)","v":0},{"$f":"IF(S272>0,\"Max UI:\",0)","v":0},{"$f":"IF(S272>0,MAX_UI,0)","v":0},{"$f":"IF(AND(S272>0,SHAPEW>0,F194>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,127,{"$f":"IF(SHAPE=R273,10,0)","v":0},{"$f":"IF(S273>0,\"Minimum Width:\",0)","v":0},{"$f":"IF(S273>0,H193,0)","v":0},{"$f":"IF(AND(S273>0,SHAPEH>0,I206>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,127,{"$f":"IF(SHAPE=R274,11,0)","v":0},{"$f":"IF(S274>0,\"Brickmould Width:\",0)","v":0},{"$f":"IF(S274>0,L195,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,127,{"$f":"IF(SHAPE=R275,12,0)","v":0},{"$f":"IF(S275>0,\"Brickmould Height:\",0)","v":0},{"$f":"IF(S275>0,L196,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,127,{"$f":"IF(SHAPE=R276,12,0)","v":0},{"$f":"IF(S276>0,\"Brickmould Radius:\",0)","v":0},{"$f":"IF(S276>0,L197,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,128,{"$f":"IF(SHAPE=R277,1,0)","v":0},{"$f":"IF(S277>0,\"Frame Radius:\",0)","v":0},{"$f":"IF(S277>0,D208,0)","v":0},{"$f":"IF(AND(S277>0,C206>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,128,{"$f":"IF(SHAPE=R278,2,0)","v":0},{"$f":"IF(S278>0,\"Frame Leg:\",0)","v":0},{"$f":"IF(S278>0,DIM_4,0)","v":0},{"$f":"IF(AND(S278>0,F206>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,128,{"$f":"IF(SHAPE=R279,3,0)","v":0},{"$f":"IF(S279>0,\"Peak Cut Length:\",0)","v":0},{"$f":"IF(S279>0,G212,0)","v":0},{"$f":"IF(AND(S279>0,H206>1),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,128,{"$f":"IF(SHAPE=R280,4,0)","v":0},{"$f":"IF(S280>0,\"Corner Cut Length:\",0)","v":0},{"$f":"IF(S280>0,G213,0)","v":0},{"$f":"IF(AND(S280>0,H206>1),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,128,{"$f":"IF(SHAPE=R281,5,0)","v":0},{"$f":"IF(S281>0,\"Glas Width:\",0)","v":0},{"$f":"IF(S281>0,GW_128,0)","v":0},{"$f":"IF(AND(U281>0,GW_128<GlassMinW),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,128,{"$f":"IF(SHAPE=R282,6,0)","v":0},{"$f":"IF(S282>0,\"Glass Height:\",0)","v":0},{"$f":"IF(S282>0,D209,0)","v":0},{"$f":"IF(AND(U282>0,GH_128<GlassMinH),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,128,{"$f":"IF(SHAPE=R283,7,0)","v":0},{"$f":"IF(S283>0,\"Glass Radius:\",0)","v":0},{"$f":"IF(S283>0,D209,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,128,{"$f":"IF(SHAPE=R284,8,0)","v":0},{"$f":"IF(S284>0,\"Glass Leg:\",0)","v":0},{"$f":"IF(S284>0,D212,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,128,{"$f":"IF(SHAPE=R285,9,0)","v":0},{"$f":"IF(S285>0,\"Max Width:\",0)","v":0},{"$f":"IF(S285>0,MAX_W,0)","v":0},{"$f":"IF(AND(S285>0,E206>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,128,{"$f":"IF(SHAPE=R286,10,0)","v":0},{"$f":"IF(S286>0,\"Min Width:\",0)","v":0},{"$f":"IF(S286>0,MIN_W,0)","v":0},{"$f":"IF(AND(S286>0,I206>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,128,{"$f":"IF(SHAPE=R287,11,0)","v":0},{"$f":"IF(S287>0,\"Max Height:\",0)","v":0},{"$f":"IF(S287>0,MAX_H,0)","v":0},{"$f":"IF(AND(S287>0,E206>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,128,{"$f":"IF(SHAPE=R288,12,0)","v":0},{"$f":"IF(S288>0,\"Max UI:\",0)","v":0},{"$f":"IF(S288>0,MAX_UI,0)","v":0},{"$f":"IF(AND(S288>0,G206>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,128,{"$f":"IF(AND(SHAPE=R289,BM_SELECT>1),13,0)","v":0},{"$f":"IF(S289>0,\"Brickmould Width:\",0)","v":0},{"$f":"IF(S289>0,L206,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,128,{"$f":"IF(AND(SHAPE=R289,BM_SELECT>1),14,0)","v":0},{"$f":"IF(S290>0,\"Brickmould Height:\",0)","v":0},{"$f":"IF(S290>0,L207,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,128,{"$f":"IF(AND(SHAPE=R289,BM_SELECT>1),15,0)","v":0},{"$f":"IF(S291>0,\"Brickmould Leg:\",0)","v":0},{"$f":"IF(S291>0,L205,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,128,{"$f":"IF(AND(SHAPE=R289,BM_SELECT>1),16,0)","v":0},{"$f":"IF(S292>0,\"Brickmould Radius:\",0)","v":0},{"$f":"IF(S292>0,L208,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,129,{"$f":"IF(SHAPE=R293,1,0)","v":0},{"$f":"IF(S293>0,\"Roof Pitch:\",0)","v":0},{"$f":"IF(S293>0,H221,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,129,{"$f":"IF(SHAPE=R294,2,0)","v":0},{"$f":"IF(S294>0,\"Slanted Leg Length:\",0)","v":0},{"$f":"IF(S294>0,G223,0)","v":0},{"$f":"IF(AND(S294>0,C218>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,129,{"$f":"IF(SHAPE=R295,3,0)","v":0},{"$f":"IF(S295>0,\"Peak Cut Angle:\",0)","v":0},{"$f":"IF(S295>0,G224,0)","v":0},{"$f":"IF(AND(S295>0,,H218>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,129,{"$f":"IF(SHAPE=R296,4,0)","v":0},{"$f":"IF(S296>0,\"Peak Cut Length:\",0)","v":0},{"$f":"IF(S296>0,D222,0)","v":0},{"$f":"IF(AND(S296>0,D218>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,129,{"$f":"IF(SHAPE=R297,5,0)","v":0},{"$f":"IF(S297>0,\"Leg & Slant Cut L:\",0)","v":0},{"$f":"IF(S297>0,D223,0)","v":0},{"$f":"IF(AND(S297>0,D218>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,129,{"$f":"IF(SHAPE=R298,6,0)","v":0},{"$f":"IF(S298>0,\"Corners Cut Length:\",0)","v":0},{"$f":"IF(S298>0,D224,0)","v":0},{"$f":"IF(AND(S298>0,D218>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,129,{"$f":"IF(SHAPE=R299,7,0)","v":0},{"$f":"IF(S299>0,\"Glass Width:\",0)","v":0},{"$f":"IF(S299>0,GW_129,0)","v":0},{"$f":"IF(AND(U281>0,GW_129<GlassMinW),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,129,{"$f":"IF(SHAPE=R300,8,0)","v":0},{"$f":"IF(S300>0,\"Glass Height:\",0)","v":0},{"$f":"IF(S300>0,GH_129,0)","v":0},{"$f":"IF(AND(U281>0,GH_129<GlassMinH),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,129,{"$f":"IF(SHAPE=R301,9,0)","v":0},{"$f":"IF(S301>0,\"Glass Leg:\",0)","v":0},{"$f":"IF(S301>0,D225,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,129,{"$f":"IF(SHAPE=R302,10,0)","v":0},{"$f":"IF(S302>0,\"Min. Segment:\",0)","v":0},{"$f":"IF(S302>0,C217,0)","v":0},{"$f":"IF(AND(U302>0,C218>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,129,{"$f":"IF(SHAPE=R303,11,0)","v":0},{"$f":"IF(S303>0,\"Max Width:\",0)","v":0},{"$f":"IF(S303>0,MAX_W,0)","v":0},{"$f":"IF(AND(S303>0,E218>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,129,{"$f":"IF(SHAPE=R304,12,0)","v":0},{"$f":"IF(S304>0,\"Max Height:\",0)","v":0},{"$f":"IF(S304>0,MAX_H,0)","v":0},{"$f":"IF(AND(S304>0,F218>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,129,{"$f":"IF(SHAPE=R305,13,0)","v":0},{"$f":"IF(S305>0,\"Max UI:\",0)","v":0},{"$f":"IF(S305>0,MAX_UI,0)","v":0},{"$f":"IF(AND(S305>0,G218>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,129,{"$f":"IF(AND(SHAPE=R306,BM_SELECT>1),14,0)","v":0},{"$f":"IF(S306>0,\"Brickmould Width:\",0)","v":0},{"$f":"IF(S306>0,K219,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,129,{"$f":"IF(AND(SHAPE=R306,BM_SELECT>1),15,0)","v":0},{"$f":"IF(S307>0,\"Brickmould Height:\",0)","v":0},{"$f":"IF(S307>0,K220,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,129,{"$f":"IF(AND(SHAPE=R306,BM_SELECT>1),16,0)","v":0},{"$f":"IF(S308>0,\"Brickmould Leg:\",0)","v":0},{"$f":"IF(S308>0,K221,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,129,{"$f":"IF(AND(SHAPE=R306,BM_SELECT>1),17,0)","v":0},{"$f":"IF(S309>0,\"BM Slanted Leg:\",0)","v":0},{"$f":"IF(S309>0,K222,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130,{"$f":"IF(SHAPE=R310,1,0)","v":0},{"$f":"IF(S310>0,\"Roof Pitch:\",0)","v":0},{"$f":"IF(S310>0,H234,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130,{"$f":"IF(SHAPE=R311,2,0)","v":0},{"$f":"IF(S311>0,\"Slanted Leg:\",0)","v":0},{"$f":"IF(S311>0,D237,0)","v":0},{"$f":"IF(AND(S311>0,C230>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130,{"$f":"IF(SHAPE=R312,3,0)","v":0},{"$f":"IF(S312>0,\"Peak Cut Angle:\",0)","v":0},{"$f":"IF(S312>0,G235,0)","v":0},{"$f":"IF(AND(S312>0,H230>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130,{"$f":"IF(SHAPE=R313,4,0)","v":0},{"$f":"IF(S313>0,\"Peak Cut Length:\",0)","v":0},{"$f":"IF(S313>0,D234,0)","v":0},{"$f":"IF(AND(S313>0,D230>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130,{"$f":"IF(SHAPE=R314,5,0)","v":0},{"$f":"IF(S314>0,\"Sill & Slant Angle:\",0)","v":0},{"$f":"IF(S314>0,G236,0)","v":0},{"$f":"IF(AND(S314>0,H230>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130,{"$f":"IF(SHAPE=R315,6,0)","v":0},{"$f":"IF(S315>0,\"Sill & Slant Cut L:\",0)","v":0},{"$f":"IF(S315>0,D233,0)","v":0},{"$f":"IF(AND(S315>0,D230>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130,{"$f":"IF(SHAPE=R316,7,0)","v":0},{"$f":"IF(S316>0,\"Corner Cut L:\",0)","v":0},{"$f":"IF(S316>0,D235,0)","v":0},{"$f":"IF(AND(S316>0,D230>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130,{"$f":"IF(SHAPE=R317,8,0)","v":0},{"$f":"IF(S317>0,\"Glass Width:\",0)","v":0},{"$f":"IF(S317>0,GW_130,0)","v":0},{"$f":"IF(AND(U317>0,GW_130<GlassMinW),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130,{"$f":"IF(SHAPE=R318,9,0)","v":0},{"$f":"IF(S318>0,\"Glass Height:\",0)","v":0},{"$f":"IF(S318>0,GH_130,0)","v":0},{"$f":"IF(AND(U318>0,GH_130<GlassMinH),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130,{"$f":"IF(SHAPE=R319,10,0)","v":0},{"$f":"IF(S319>0,\"Max Width:\",0)","v":0},{"$f":"IF(S319>0,MAX_W,0)","v":0},{"$f":"IF(AND(U319>0,SHAPEW>MAX_W),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130,{"$f":"IF(SHAPE=R320,11,0)","v":0},{"$f":"IF(S320>0,\"Max Height:\",0)","v":0},{"$f":"IF(S320>0,MAX_H,0)","v":0},{"$f":"IF(AND(U320>0,SHAPEH>MAX_H),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130,{"$f":"IF(SHAPE=R321,12,0)","v":0},{"$f":"IF(S321>0,\"Max UI:\",0)","v":0},{"$f":"IF(S321>0,MAX_UI,0)","v":0},{"$f":"IF(AND(S321>0,SHAPEW>0,SHAPEH>0,G230>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130,{"$f":"IF(AND(SHAPE=R322,BM_SELECT>1),13,0)","v":0},{"$f":"IF(S322>0,\"Brickmould Width:\",0)","v":0},{"$f":"IF(S322>0,K232,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130,{"$f":"IF(AND(SHAPE=R322,BM_SELECT>1),14,0)","v":0},{"$f":"IF(S323>0,\"Brickmould Height:\",0)","v":0},{"$f":"IF(S323>0,K233,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130,{"$f":"IF(AND(SHAPE=R322,BM_SELECT>1),15,0)","v":0},{"$f":"IF(S324>0,\"BM Slanted Leg:\",0)","v":0},{"$f":"IF(S324>0,K234,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,131,{"$f":"IF(SHAPE=R325,1,0)","v":0},{"$f":"IF(S325>0,\"Roof Pitch:\",0)","v":0},{"$f":"IF(S325>0,G246,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,131,{"$f":"IF(SHAPE=R326,2,0)","v":0},{"$f":"IF(S326>0,\"Frame Height:\",0)","v":0},{"$f":"IF(S326>0,G245,0)","v":0},{"$f":"IF(AND(S326>0,F241>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,131,{"$f":"IF(SHAPE=R327,3,0)","v":0},{"$f":"IF(S327>0,\"All Cut Length:\",0)","v":0},{"$f":"IF(S327>0,D245,0)","v":0},{"$f":"IF(AND(S327>0,D241>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,131,{"$f":"IF(SHAPE=R328,4,0)","v":0},{"$f":"IF(S328>0,\"All Cut Angles:\",0)","v":0},{"$f":"IF(S328>0,30,0)","v":0},{"$f":"IF(AND(S328>0,H251>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,131,{"$f":"IF(SHAPE=R329,5,0)","v":0},{"$f":"IF(S329>0,\"Glass Width:\",0)","v":0},{"$f":"IF(S329>0,GW_131,0)","v":0},{"$f":"IF(AND(U329>0,GW_131<GlassMinW),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,131,{"$f":"IF(SHAPE=R330,6,0)","v":0},{"$f":"IF(S330>0,\"Glass Height:\",0)","v":0},{"$f":"IF(S330>0,GH_131,0)","v":0},{"$f":"IF(AND(U330>0,GH_131<GlassMinH),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,131,{"$f":"IF(SHAPE=R331,7,0)","v":0},{"$f":"IF(S331>0,\"Max Width:\",0)","v":0},{"$f":"IF(S331>0,MAX_W,0)","v":0},{"$f":"IF(AND(U331>0,E241>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,131,{"$f":"IF(SHAPE=R332,8,0)","v":0},{"$f":"IF(S332>0,\"Max UI:\",0)","v":0},{"$f":"IF(S332>0,MAX_UI,0)","v":0},{"$f":"IF(AND(S332>0,G241>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,131,{"$f":"IF(SHAPE=R333,9,0)","v":0},{"$f":"IF(S333>0,\"Min Width:\",0)","v":0},{"$f":"IF(S333>0,MIN_W,0)","v":0},{"$f":"IF(AND(S333>0,H241>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,131,{"$f":"IF(AND(SHAPE=R334,BM_SELECT>1),10,0)","v":0},{"$f":"IF(S334>0,\"Brickmould Width:\",0)","v":0},{"$f":"IF(S334>0,K242,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,131,{"$f":"IF(AND(SHAPE=R334,BM_SELECT>1),11,0)","v":0},{"$f":"IF(S335>0,\"Brickmould Height:\",0)","v":0},{"$f":"IF(S335>0,K243,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,131,{"$f":"IF(AND(SHAPE=R334,BM_SELECT>1),12,0)","v":0},{"$f":"IF(S336>0,\"BM Slanted Leg:\",0)","v":0},{"$f":"IF(S336>0,K244,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,132,{"$f":"IF(SHAPE=R337,1,0)","v":0},{"$f":"IF(S337>0,\"Roof Pitch:\",0)","v":0},{"$f":"IF(S337>0,H254,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,132,{"$f":"IF(SHAPE=R338,2,0)","v":0},{"$f":"IF(S338>0,\"Min Segment:\",0)","v":0},{"$f":"IF(S338>0,C250,0)","v":0},{"$f":"IF(AND(S338>0,C251>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,132,{"$f":"IF(SHAPE=R339,3,0)","v":0},{"$f":"IF(S339>0,\"Sides Length:\",0)","v":0},{"$f":"IF(S339>0,G255,0)","v":0},{"$f":"IF(AND(S339>0,C251>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,132,{"$f":"IF(SHAPE=R340,4,0)","v":0},{"$f":"IF(S340>0,\"Peak Cut Angle:\",0)","v":0},{"$f":"IF(S340>0,G254/2,0)","v":0},{"$f":"IF(AND(S340>0,SHAPEW>0,SHAPEH>0,H251>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,132,{"$f":"IF(SHAPE=R341,5,0)","v":0},{"$f":"IF(S341>0,\"Peak Cut L:\",0)","v":0},{"$f":"IF(S341>0,D254,0)","v":0},{"$f":"IF(AND(S341>0,D251>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,132,{"$f":"IF(SHAPE=R342,6,0)","v":0},{"$f":"IF(S342>0,\"Corner Cut Angle:\",0)","v":0},{"$f":"IF(S342>0,G253/2,0)","v":0},{"$f":"IF(AND(S342>0,SHAPEW>0,SHAPEH>0,H251>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,132,{"$f":"IF(SHAPE=R343,7,0)","v":0},{"$f":"IF(S343>0,\"Corner Cut L:\",0)","v":0},{"$f":"IF(S343>0,D253,0)","v":0},{"$f":"IF(AND(S343>0,D251>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,132,{"$f":"IF(SHAPE=R344,8,0)","v":0},{"$f":"IF(S344>0,\"Glass Width:\",0)","v":0},{"$f":"IF(S344>0,GW_132,0)","v":0},{"$f":"IF(AND(U344>0,GW_132<GlassMinW),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,132,{"$f":"IF(SHAPE=R345,9,0)","v":0},{"$f":"IF(S345>0,\"Glass Height:\",0)","v":0},{"$f":"IF(S345>0,GH_132,0)","v":0},{"$f":"IF(AND(U345>0,GH_132<GlassMinH),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,132,{"$f":"IF(SHAPE=R346,10,0)","v":0},{"$f":"IF(S346>0,\"Max Width:\",0)","v":0},{"$f":"IF(S346>0,MAX_W,0)","v":0},{"$f":"IF(AND(S346>0,SHAPEW>0,SHAPEW>MAX_W),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,132,{"$f":"IF(SHAPE=R347,11,0)","v":0},{"$f":"IF(S347>0,\"Max Height:\",0)","v":0},{"$f":"IF(S347>0,MAX_H,0)","v":0},{"$f":"IF(AND(S347>0,SHAPEH>0,SHAPEH>MAX_H),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,132,{"$f":"IF(SHAPE=R348,12,0)","v":0},{"$f":"IF(S348>0,\"Max UI:\",0)","v":0},{"$f":"IF(S348>0,MAX_UI,0)","v":0},{"$f":"IF(AND(S348>0,G251>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,132,{"$f":"IF(SHAPE=R349,13,0)","v":0},{"$f":"IF(S349>0,\"Min Widht:\",0)","v":0},{"$f":"IF(S349>0,MIN_W,0)","v":0},{"$f":"IF(AND(S349>0,SHAPEW>0,I251>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,132,{"$f":"IF(AND(SHAPE=R350,BM_SELECT>1),14,0)","v":0},{"$f":"IF(S350>0,\"Brickmould Width:\",0)","v":0},{"$f":"IF(S350>0,L252,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,132,{"$f":"IF(AND(SHAPE=R350,BM_SELECT>1),15,0)","v":0},{"$f":"IF(S351>0,\"Brickmould Height:\",0)","v":0},{"$f":"IF(S351>0,L253,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,132,{"$f":"IF(AND(SHAPE=R350,BM_SELECT>1),16,0)","v":0},{"$f":"IF(S352>0,\"BM Slanted Leg:\",0)","v":0},{"$f":"IF(S352>0,L254,0)","v":0}]

{"sheet":"Image","index":2,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
[]
[null,105,{"$error":"#VALUE!"},{"$f":"LIMIT_105","v":""},null,null,"2-1",{"$error":"#VALUE!"},"Regency"]
[null,110,{"$error":"#VALUE!"},{"$f":"LIMIT_110","v":""},null,null,"3-1",{"$error":"#VALUE!"},3000]
[null,111,{"$error":"#VALUE!"},{"$f":"LIMIT_111","v":""},null,null,"4-1",{"$error":"#VALUE!"},4000]
[null,112,{"$error":"#VALUE!"},{"$f":"LIMIT_112","v":""},null,null,"3-2",{"$error":"#VALUE!"},"1556A"]
[null,113,{"$error":"#VALUE!"},{"$f":"LIMIT_113","v":""},null,null,"3-3",{"$error":"#VALUE!"},1556]
[null,114,{"$error":"#VALUE!"},{"$f":"LIMIT_114","v":""},null,null,"3-4",{"$error":"#VALUE!"},6184]
[null,115,{"$error":"#VALUE!"},{"$f":"LIMIT_115","v":""},null,null,"3-5",{"$error":"#VALUE!"},7634]
[null,116,{"$error":"#VALUE!"},{"$f":"LIMIT_116","v":""},null,null,"3-6",{"$error":"#VALUE!"},7635]
[null,117,{"$error":"#VALUE!"},{"$f":"LIMIT_117","v":""},null,null,"3-7",{"$error":"#VALUE!"},"15182A"]
[null,118,{"$error":"#VALUE!"},{"$f":"LIMIT_118","v":""},null,null,"3-8",{"$error":"#VALUE!"},15182]
[null,119,{"$error":"#VALUE!"},{"$f":"LIMIT_119","v":""},null,null,"3-9",{"$error":"#VALUE!"},"15184A"]
[null,120,{"$error":"#VALUE!"},{"$f":"LIMIT_120","v":""},null,null,"3-10",{"$error":"#VALUE!"},15184]
[null,121,{"$error":"#VALUE!"},{"$f":"LIMIT_121","v":""},null,null,"3-11",{"$error":"#VALUE!"},"15184B"]
[null,122,{"$error":"#VALUE!"},{"$f":"LIMIT_122","v":""},null,null,"3-12",{"$error":"#VALUE!"},"15368A"]
[null,123,{"$error":"#VALUE!"},{"$f":"LIMIT_123","v":""},null,null,"3-13",{"$error":"#VALUE!"},15368]
[null,124,{"$error":"#VALUE!"},{"$f":"LIMIT_124","v":""},null,null,"4-2",{"$error":"#VALUE!"},"1556A"]
[null,125,{"$error":"#VALUE!"},{"$f":"LIMIT_125","v":""},null,null,"4-3",{"$error":"#VALUE!"},1556]
[null,126,{"$error":"#VALUE!"},{"$f":"LIMIT_126","v":""},null,null,"4-4",{"$error":"#VALUE!"},6184]
[null,127,{"$error":"#VALUE!"},{"$f":"LIMIT_127","v":""},null,null,"4-5",{"$error":"#VALUE!"},7634]
[null,128,{"$error":"#VALUE!"},{"$f":"LIMIT_128","v":""},null,null,"4-6",{"$error":"#VALUE!"},7635]
[null,129,{"$error":"#VALUE!"},{"$f":"LIMIT_129","v":""},null,null,"4-7",{"$error":"#VALUE!"},"15182A"]
[null,130,{"$error":"#VALUE!"},{"$f":"LIMIT_130","v":""},null,null,"4-8",{"$error":"#VALUE!"},15182]
[null,131,{"$error":"#VALUE!"},{"$f":"LIMIT_131","v":""},null,null,"4-9",{"$error":"#VALUE!"},"15184A"]
[null,132,{"$error":"#VALUE!"},{"$f":"LIMIT_132","v":""},null,null,"4-10",{"$error":"#VALUE!"},15184]
[null,null,null,null,null,null,"4-11",{"$error":"#VALUE!"},"15184B"]
[null,null,null,null,null,null,"4-12",{"$error":"#VALUE!"},"15368A"]
[null,null,null,null,null,null,"4-13",{"$error":"#VALUE!"},15368]