{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["WDI_Standard_Order_Form","Colors_2020","Casings_2020","Stool_Template","Round_top_Template","Round_top_Template_Extended","Octagon_Template","Trapezoid_Template","OSC_Calcs","Revisions"],"not_rendered":{"images":7,"defined_names":25},"read":"whole","date_system":"1900"}

{"sheet":"WDI_Standard_Order_Form","index":0,"n_rows":46,"n_cols":97,"rows_kept":46,"merged":[[5,3,6,3],[5,40,6,40],[5,62,6,62]]}
["WDI Company - Window Box Order Form",{"$nulls":6},"WDI  (651) 464-6190        Fax: (651) 464-6191",{"$nulls":5},"Both:",{"$f":"IF(+L5<1,+CONCATENATE(\"#\",C5,\" \",I4,+\" PO#\",+C3,\" \",+C2,\" - \",+I5,\" Bx in Color #\", +M9,\" - Due: \",+AF5), +CONCATENATE(\"#\",+C5,\" \",+I4,+\" PO#\",+C3,\" \",+C2,\" - \",+I5,\" Bx in Color #\",+M9,\" + \",+L5,\" Parts - Due: \",+AF5))","v":"#-  PO#  - - Bx in Color # + - Parts - Due: -"},null,"WDI Company",{"$nulls":6},"*Email this Excel order form to orders email below",{"$nulls":4},"",{"$nulls":8},"Error Codes --->",{"$nulls":14},"Other logic faults -->"]
[null,"Job Name:",{"$nulls":5},"Order Date:",{"$f":"\"-\"","v":"-"},{"$nulls":4},"Box:",{"$f":"IF(+L5<1,+CONCATENATE(\"#\",C5,\" \",I4,+\" PO#\",+C3,\" \",+C2,\" - \",+I5,\" Bx in Color #\", +M9,\" - Due: \",+AF5), +CONCATENATE(\"#\",+C5,\" \",+I4,+\" PO#\",+C3,\" \",+C2,\" - \",+I5,\" Bx in Color #\",+M9,\" + \",+AF5))","v":"#-  PO#  - - Bx in Color # + -"},null,"Main:","651.464.6190","Email:","orders@thewoodster.com",{"$nulls":10},"Price Deck:","w","Formulas include casing width, stop size",{"$nulls":5},{"v":1,"d":"1.0"},{"v":2,"d":"2.0"},{"v":3,"d":"3.0"},3.1,3.2,{"v":4,"d":"4.0"},{"v":5,"d":"5.0"},{"v":7,"d":"7.0"},{"v":8,"d":"8.0"},{"v":9,"d":"9.0"},{"v":10,"d":"10.0"},{"v":11,"d":"11.0"},{"v":12,"d":"12.0"},{"v":13,"d":"13.0"},{"v":14,"d":"14.0"},{"v":15,"d":"15.0"},{"v":16,"d":"16.0"},{"v":17,"d":"17.0"},{"v":18,"d":"18.0"}]
[null,"PO #:",{"$nulls":5},"WDI Ship Date:",{"$f":"\"-\"","v":"-"},{"$nulls":3},{"$f":"IF(I3-I2<14,\"Short lead time, Rush charges may apply\",IF(I3-I2>30,\"Ship date is >30 days\",\"\"))","v":{"$error":"#VALUE!"}},"Parts:",{"$f":"IF(+L5<1,+CONCATENATE(\"#\",C5,\" \",I4,+\" PO#\",+C3,\" \",+C2,\" - \",\" - Due: \",+AF5), +CONCATENATE(\"#\",+C5,\" \",+I4,+\" PO#\",+C3,\" \",+C2,\" - \",+M9,\" + \",+SUM(B21:B24),\" Millwork Parts - Due: \",+AF5))","v":"#-  PO#  -  + 0 Millwork Parts - Due: -"},null,"Orders Ext:",109,"Website:","www.wdi-windowtrimkits.com",{"$nulls":10},"Scaler:",{"v":0.5,"d":"0.50"},"white premium, CRI vs WDI Pricing",{"$nulls":27},"Errors"]
[null,"Ordered By:",{"$nulls":5},"WDI Customer Name:",{"$nulls":8},"Accounting Ext:",108,"Video:","http://www.wdicustomwood.com/building-products",{"$nulls":14},"CALCS",{"$nulls":3},"*Box width too small/large ","*Box height too small/large ","*Opening Type Error ","*Dim A & No stool selected","*Dim B & No stool selected","*Jamb Species not stock ","*Jamb depth too small/large ","*Casing Profile not stock ","*Casing width not stock ",null,"*Stop/Mull Profile not stock ","*Stop width too small/large ","*Not a stock color","*Notes Err ","*White on Oak",null,"*Stop is wider than jamb",{"$nulls":5},{"$f":"+AM4","v":"*Box width too small/large "},{"$f":"+AN4","v":"*Box height too small/large "},{"$f":"+AO4","v":"*Opening Type Error "},"*Dim A & No stool selected","*Dim B & No stool selected",{"$f":"+AR4","v":"*Jamb Species not stock "},{"$f":"+AS4","v":"*Jamb depth too small/large "},{"$f":"+AT4","v":"*Casing Profile not stock "},"*Casing width not stock ",0,"*Stop/Mull Profile not stock ","*Stop width too small/large ","*Not a stock color",{"$f":"+AZ4","v":"*Notes Err "},"*White on Oak",0,"*Stop is wider than jamb",0,0,null,"string errors",null,null,"Line Count check",null,"Weight Calcs -->"]
[null,"WDI Job #",{"$f":"\"-\"","v":"-"},{"$nulls":4},"# Window Line Items:","-",null,"# Parts Line Items:","-","Total Items:","-",{"$f":"IF(+I5+L5<>+N5,\"Error - Line Count Off !!\",\"\")","v":{"$error":"#VALUE!"}},{"$nulls":15},"Due:",{"$f":"TEXT(I3,\"MM/DD\")","v":"-"},{"$nulls":56},"Weights -->",null,null,"Total"]
[null,"Jamb Box Size (O.D.)",null," Opening Type"," Stools",null,"Species","Jamb Depth","Casing Profile #","Casing","Stop/Mull (WDST-numbers)","Stop/Mull","Window","Notes","Order messages & errors",null,"Window","Jamb + Casing Cost","+ Stop Cost","Other","Other","Other","Other","Total",{"$nulls":9},"Casing","Casing Profile #",{"$nulls":3},"Box Size (O.D.)",null,"Opening Type","Stools",null,"Jamb","Jamb Depth","Casing Profile #","Casing",null,"Stop/Mull (WDST-numbers)","Stop/Mull","Window","Notes",null,"Open 7/11/14",{"$nulls":6},"Box Size (O.D.)",null,"Opening Type","Stools",null,"Jamb","Jamb Depth","Casing Profile #","Casing",null,"Stop/Mull (WDST #....)","Stop/Mull","Window","Notes",{"$nulls":11},"UI","lft","Jamb Width","Casing #/Lft","Stop #/lft","1\" Jamb #/lft","Weight","Jamb?","Casing ?","Stop?"]
["#","Width","Height",null,"Dim A","Dim B","Species (Oak, Maple, Poplar)","From inside of Window","(WDI #113, #115, #118)","Width (2.25\", 2.5\", 3.25\")","Stock Profiles #006, 007, 009, 011 *","Width (Standard = 1.25\")","Color # (from color chips dated 2019 or newer)","Descriptions",null,null,"Pricing Length (Inches)","sub-cost","sub-cost","Items & Charges","Items & Charges","Items & Charges","Items & Charges","Total Cost",null,null,"Weight (lbs)",{"$nulls":6},"Width (2.25\", 2.5\", 3.25\")","Revised Casing Name",{"$nulls":3},"Width","Height",null,"Dim A","Dim B","Species (Oak, Maple, Poplar)","From inside of Window","(WDI #113, #115, #118, etc.)","Width (2.25\", 2.5\", 3.25\")",null,"Stock Profiles #006, 007, 009, 011","Width (Standard = 1.25\")","Color","Descriptions","White on Oak check",null,"Stop wider than jamb",{"$nulls":3},"SUM",null,"Width","Height",null,"Dim A","Dim B","Species (Oak, Maple, Poplar)","From inside of Window","(WDI #113, #115, #118, etc.)","Width (2.25, 3.25, 5.0\")",null,"Profile #004, 006, 007, 008, 009, 011)","Width (Standard = 1.25\")","Color","Descriptions",{"$nulls":6},"<-- ERROR MESSAGES -->",{"$nulls":7},0.42,0.15,0.23]
[1,2,3,{"$nulls":3},4,5,6,8,9,null,10,11,null,12,13,14,{"$nulls":4},16,17,null,null,16,null,19,20,{"$nulls":3},8,6]
[1,null,null,"W",{"$nulls":7},{"$f":"IF(K9=\"\",\"\",IF(K9=\"006\",IF(H9>2,1.25,1), IF(K9=\"007\",2, IF(K9=\"009\",0.75, IF(K9=\"011\",1.25,IF(K9=\"001\",0.75,0.754))))))","v":""},null,null,{"$f":"+CC9","v":"- Invalid Line -"},null,{"$f":"SUM(B9:C9)","v":0},{"$nulls":6},{"$f":"SUM(R9:W9)","v":0},null,null,{"$f":"+CN9","v":0},{"$nulls":6},{"$f":"IF(J9=2.25,\"R \",IF(J9=2.5,\"W \",IF(J9=3.25,\"EW\",\"\")))","v":""},{"$f":"+CONCATENATE(I9,AH9)","v":""},null,null,{"$f":"IF(D9=\"W\",1,IF(D9=\"S\",1,IF(D9=\"D\",1,IF(D9=\"H\",1,IF(D9=\"O\",1,IF(D9=\"C\",1,\"Error**\"))))))","v":1},{"$f":"IF(B9<10,IF(B9>96,10,0),0)","v":0},{"$f":"IF(C9<10,IF(C9>96,20,0),0)","v":0},{"$f":"IF(D9=\"W\",0,IF(D9=\"S\",0,IF(D9=\"D\",0,IF(D9=\"H\",0,IF(D9=\"O\",0,IF(D9=\"C\",0,30))))))","v":0},{"$f":"IF(D9<>\"S\",IF(E9<>0,31,0),0)","v":0},{"$f":"IF(D9<>\"S\",IF(F9<>0,31,0),0)","v":0},{"$f":"IF(G9=\"Oak\",0,IF(G9=\"Maple\",0,IF(G9=\"Poplar\",0,40)))","v":40},{"$f":"IF(B9<>0,IF(H9<1,50, IF(H9>6.5,51,0)),0)","v":0},{"$f":"IF(I9=113,0,IF(I9=115,0,IF(I9=118,0,70)))","v":70},{"$f":"IF(J9=2.25,0,IF(J9=2.5,0,IF(J9=3.25,0,80)))","v":80},null,{"$f":"IF(K9=\"006\",0,IF(K9=\"007\",0,IF(K9=\"009\",0,IF(K9=\"011\",0,IF(K9=\"001\",0,100)))))","v":100},{"$f":"IF(L9<0.5,IF(L9>3,110,0),0)","v":0},{"$f":"IF(M9>=50,IF(M9<=76,0,IF(M9=30,0,121)),120)","v":120},null,{"$f":"IF(M9=75,IF(G9=\"Oak\",150,0),0)","v":0},null,{"$f":"IF(L9>H9,160,0)","v":0},{"$nulls":3},{"$f":"SUM(AM9:BF9)","v":410},null,{"$f":"IF(AM9=0,\"\",+AM$4)","v":""},{"$f":"IF(AN9=0,\"\",+AN$4)","v":""},{"$f":"IF(AO9=0,\"\",+AO$4)","v":""},{"$f":"IF(AP9=0,\"\",+AP$4)","v":""},{"$f":"IF(AQ9=0,\"\",+AQ$4)","v":""},{"$f":"IF(AR9=0,\"\",+AR$4)","v":"*Jamb Species not stock "},{"$f":"IF(AS9=0,\"\",+AS$4)","v":""},{"$f":"IF(AT9=0,\"\",+AT$4)","v":"*Casing Profile not stock "},{"$f":"IF(AU9=0,\"\",+AU$4)","v":"*Casing width not stock "},{"$f":"IF(AV9=0,\"\",+AV$4)","v":""},{"$f":"IF(AW9=0,\"\",+AW$4)","v":"*Stop/Mull Profile not stock "},{"$f":"IF(AX9=0,\"\",+AX$4)","v":""},{"$f":"IF(AY9=0,\"\",+AY$4)","v":"*Not a stock color"},{"$f":"IF(AZ9=0,\"\",+AZ$4)","v":""},{"$f":"IF(BA9=0,\"\",+BA$4)","v":""},{"$f":"IF(BB9=0,\"\",+BB$4)","v":""},{"$f":"IF(BC9=0,\"\",+BC$4)","v":""},{"$f":"IF(BD9=0,\"\",+BD$4)","v":""},{"$f":"IF(BE9=0,\"\",+BE$4)","v":""},null,{"$f":"IF(B9<>\"\",+CONCATENATE(BI9,BJ9,BK9,BL9,BM9,BN9,BO9,BP9,BQ9,BS9,BT9,BU9,BV9,BW9,BX9,BY9,BZ9,CA9),\"- Invalid Line -\")","v":"- Invalid Line -"},{"$nulls":4},{"$f":"+Q9","v":0},{"$f":"+CH9*2/12","v":0},{"$f":"+E9+H9","v":0},{"$f":"IF(CP9<>0,+CI9*$CK$7,0)","v":0},{"$f":"IF(CQ9<>0,+CI9*$CL$7,0)","v":0},{"$f":"+CI9*CJ9*$CM$7","v":0},{"$f":"SUM(CK9:CM9)","v":0},{"$f":"+H9","v":0},{"$f":"+J9","v":0},{"$f":"+L9","v":""},null,{"$f":"+AT9","v":70}]
[2,null,null,"W",{"$nulls":7},{"$f":"IF(K10=\"\",\"\",IF(K10=\"006\",IF(H10>2,1.25,1), IF(K10=\"007\",2, IF(K10=\"009\",0.75, IF(K10=\"011\",1.25,IF(K10=\"001\",0.75,0.754))))))","v":""},{"$f":"IF(M9=\"\",\"\",+M9)","v":""},null,"- Invalid Line -",null,{"$f":"SUM(B10:C10)","v":0},{"$nulls":6},{"$f":"SUM(R10:W10)","v":0},null,null,{"$f":"+CN10","v":0},{"$nulls":6},"","",null,null,1,0,0,0,0,0,40,0,70,80,null,100,0,{"$f":"IF(M10>=50,IF(M10<=76,0,IF(M10=30,0,121)),120)","v":121},null,{"$f":"IF(M10=75,IF(G10=\"Oak\",150,0),0)","v":0},null,0,{"$nulls":3},{"$f":"SUM(AM10:BF10)","v":411},null,{"$f":"IF(AM10=0,\"\",+AM$4)","v":""},"","","","","*Jamb Species not stock ","","*Casing Profile not stock ","*Casing width not stock ","","*Stop/Mull Profile not stock ","","*Not a stock color","","","","","","",null,"- Invalid Line -",{"$nulls":4},0,{"$f":"+CH10*2/12","v":0},0,{"$f":"IF(CP10<>0,+CI10*$CK$7,0)","v":0},{"$f":"IF(CQ10<>0,+CI10*$CL$7,0)","v":0},{"$f":"+CI10*CJ10*$CM$7","v":0},{"$f":"SUM(CK10:CM10)","v":0},0,{"$f":"+J10","v":0},{"$f":"+L10","v":""}]
[3,null,null,"W",{"$nulls":7},"","",null,"- Invalid Line -",null,0,{"$nulls":6},0,null,null,0,{"$nulls":6},"","",null,null,1,0,0,0,0,0,40,0,70,80,null,100,0,121,null,0,null,0,{"$nulls":3},411,null,"","","","","","*Jamb Species not stock ","","*Casing Profile not stock ","*Casing width not stock ","","*Stop/Mull Profile not stock ","","*Not a stock color","","","","","","",null,"- Invalid Line -",{"$nulls":4},0,0,0,0,0,0,0,0,0,""]
[4,null,null,"W",{"$nulls":7},"","",null,"- Invalid Line -",null,0,{"$nulls":6},0,null,null,0,{"$nulls":6},"","",null,null,1,0,0,0,0,0,40,0,70,80,null,100,0,121,null,0,null,0,{"$nulls":3},411,null,"","","","","","*Jamb Species not stock ","","*Casing Profile not stock ","*Casing width not stock ","","*Stop/Mull Profile not stock ","","*Not a stock color","","","","","","",null,"- Invalid Line -",{"$nulls":4},0,0,0,0,0,0,0,0,0,""]
[5,null,null,"W",{"$nulls":7},"","",null,"- Invalid Line -",null,0,{"$nulls":6},0,null,null,0,{"$nulls":6},"","",null,null,1,0,0,0,0,0,40,0,70,80,null,100,0,121,null,0,null,0,{"$nulls":3},411,null,"","","","","","*Jamb Species not stock ","","*Casing Profile not stock ","*Casing width not stock ","","*Stop/Mull Profile not stock ","","*Not a stock color","","","","","","",null,"- Invalid Line -",{"$nulls":4},0,0,0,0,0,0,0,0,0,""]
[6,null,null,"W",{"$nulls":7},"","",null,"- Invalid Line -",null,0,{"$nulls":6},0,null,null,0,{"$nulls":6},"","",null,null,1,0,0,0,0,0,40,0,70,80,null,100,0,121,null,0,null,0,{"$nulls":3},411,null,"","","","","","*Jamb Species not stock ","","*Casing Profile not stock ","*Casing width not stock ","","*Stop/Mull Profile not stock ","","*Not a stock color","","","","","","",null,"- Invalid Line -",{"$nulls":4},0,0,0,0,0,0,0,0,0,""]
[7,null,null,"W",{"$nulls":7},"","",null,"- Invalid Line -",null,0,{"$nulls":6},0,null,null,0,{"$nulls":6},"","",null,null,1,0,0,0,0,0,40,0,70,80,null,100,0,121,null,0,null,0,{"$nulls":3},411,null,"","","","","","*Jamb Species not stock ","","*Casing Profile not stock ","*Casing width not stock ","","*Stop/Mull Profile not stock ","","*Not a stock color","","","","","","",null,"- Invalid Line -",{"$nulls":4},0,0,0,0,0,0,0,0,0,""]
[8,null,null,"W",{"$nulls":7},"",{"$f":"IF(M15=\"\",\"\",+M15)","v":""},null,"- Invalid Line -",null,0,{"$nulls":6},0,null,null,0,{"$nulls":6},"","",null,null,1,0,0,0,0,0,40,0,70,80,null,100,0,121,null,0,null,0,{"$nulls":3},411,null,"","","","","","*Jamb Species not stock ","","*Casing Profile not stock ","*Casing width not stock ","","*Stop/Mull Profile not stock ","","*Not a stock color","","","","","","",null,"- Invalid Line -",{"$nulls":4},0,0,0,0,0,0,0,0,0,""]
[9,null,null,"W",{"$nulls":7},"",{"$f":"IF(M16=\"\",\"\",+M16)","v":""},null,"- Invalid Line -",null,0,{"$nulls":6},0,null,null,0,{"$nulls":6},"","",null,null,1,0,0,0,0,0,40,0,70,80,null,100,0,121,null,0,null,0,{"$nulls":3},411,null,"","","","","","*Jamb Species not stock ","","*Casing Profile not stock ","*Casing width not stock ","","*Stop/Mull Profile not stock ","","*Not a stock color","","","","","","",null,"- Invalid Line -",{"$nulls":4},0,0,0,0,0,0,0,0,0,""]
[10,null,null,"W",{"$nulls":7},"",{"$f":"IF(M17=\"\",\"\",+M17)","v":""},null,"- Invalid Line -",null,0,{"$nulls":6},0,null,null,0,{"$nulls":6},"","",null,null,1,0,0,0,0,0,40,0,70,80,null,100,0,121,null,0,null,0,{"$nulls":3},411,null,"","","","","","*Jamb Species not stock ","","*Casing Profile not stock ","*Casing width not stock ","","*Stop/Mull Profile not stock ","","*Not a stock color","","","","","","",null,"- Invalid Line -",{"$nulls":4},0,0,0,0,0,0,0,0,0,""]
[11,null,null,"W",{"$nulls":7},"",{"$f":"IF(M18=\"\",\"\",+M18)","v":""},null,"- Invalid Line -",null,0,{"$nulls":6},0,null,null,0,{"$nulls":6},"","",null,null,1,0,0,0,0,0,40,0,70,80,null,100,0,121,null,0,null,0,{"$nulls":3},411,null,"","","","","","*Jamb Species not stock ","","*Casing Profile not stock ","*Casing width not stock ","","*Stop/Mull Profile not stock ","","*Not a stock color","","","","","","",null,"- Invalid Line -",{"$nulls":4},0,0,0,0,0,0,0,0,0,""]
[null," Amount "," Length (Inches) ",{"$nulls":3},"Species","Jamb","Cas. Prof."," Cas. Width ","Misc profile","Misc. Wid.","Color #","Last 4 lines for Parts",null,null,"Length (lft)",{"$nulls":9},0]
[1,null,null,"P",{"$nulls":7},{"$f":"IF(K21=\"\",\"\",IF(OR(K21=\"006\",K21=\"WDST-006\"),1.25, IF(OR(K21=\"007\",K21=\"WDST-007\"),2,IF(OR(K21=\"012\",K21=\"WDST-012\"),3,IF(OR(K21=\"009\",K21=\"WDST-009\"),0.75, IF(OR(K21=\"011\",K21=\"WDST-011\"),1.25,IF(OR(K21=\"001\",K21=\"WDSH-001\"),0.75,IF(OR(K21=\"002\",K21=\"WDSH-002\"),0.75,IF(K21=\"WDBB-001\",1,IF(OR(K21=\"022\",K21=\"WDBC-022\"),0.9875,IF(OR(K21=\"007\",K21=\"CC-007\"),1.125,IF(K21=\"COVE\",0.75,\"*error-check code*\"))))))))))))","v":""},{"$f":"+M19","v":""},null,{"$f":"+BZ21","v":""},null,{"$f":"+B21*C21/12","v":0},{"$nulls":6},{"$f":"SUM(R21:W21)","v":0},null,null,0,{"$nulls":6},{"$f":"IF(J21=2.25,\"R \",IF(J21=2.5,\"W \",IF(J21=3.25,\"EW\",\"\")))","v":""},{"$f":"+CONCATENATE(I21,AH21)","v":""},null,null,{"$f":"IF(D21=\"P\",1,\"Error\")","v":1},{"$nulls":5},{"$f":"IF(G21=\"Oak\",0,IF(G21=\"Maple\",0,IF(G21=\"Poplar\",0,40)))","v":40},{"$f":"IF(B21<>0,IF(H21=0,0,IF(H21<1,50, IF(H21>6.5,51,0))),0)","v":0},{"$f":"IF(I21=113,0,IF(I21=115,0,IF(I21=118,0,IF(I21=\"\",0,70))))","v":0},{"$f":"IF(I21=0,0,IF(J21=2.25,0,IF(J21=2.5,0,IF(J21=3.25,0,80))))","v":0},null,{"$f":"IF(K21=0,0,IF(K21=\"006\",0,IF(K21=\"007\",0,IF(K21=\"009\",0,IF(K21=\"011\",0,IF(K21=\"001\",0,100))))))","v":0},null,121,null,0,{"$nulls":5},161,null,"","","","","","*Jamb Species not stock ","","","","","","","*Not a stock color",{"$f":"IF(AZ21=0,\"\",+AZ$4)","v":""},"","","","","",null,{"$f":"IF(B21<>\"\",+CONCATENATE(BI21,BJ21,BK21,BL21,BM21,BN21,BO21,BP21,BQ21,BS21,BT21,BU21,BV21,BW21,BX21,BY21,BZ21,CA21),\"- Invalid Line -\")","v":"- Invalid Line -"},{"$nulls":5},{"$f":"+Q21","v":0},{"$f":"+E21+H21","v":0},{"$f":"IF(CP21<>0,+CI21*$CK$7,0)","v":0},{"$f":"IF(CQ21<>0,+CI21*$CL$7,0)","v":0},{"$f":"+CI21*CJ21*$CM$7","v":0},{"$f":"SUM(CK21:CM21)","v":0},null,{"$f":"+J21","v":0},""]
[2,null,null,"P",{"$nulls":7},{"$f":"IF(K22=\"\",\"\",IF(OR(K22=\"006\",K22=\"WDST-006\"),1.25, IF(OR(K22=\"007\",K22=\"WDST-007\"),2,IF(OR(K22=\"012\",K22=\"WDST-012\"),3,IF(OR(K22=\"009\",K22=\"WDST-009\"),0.75, IF(OR(K22=\"011\",K22=\"WDST-011\"),1.25,IF(OR(K22=\"001\",K22=\"WDSH-001\"),0.75,IF(OR(K22=\"002\",K22=\"WDSH-002\"),0.75,IF(K22=\"WDBB-001\",1,IF(OR(K22=\"022\",K22=\"WDBC-022\"),0.9875,IF(OR(K22=\"007\",K22=\"CC-007\"),1.125,IF(K22=\"COVE\",0.75,\"*error-check code*\"))))))))))))","v":""},{"$f":"IF(M21=\"\",\"\",+M21)","v":""},null,{"$f":"+BZ22","v":""},null,{"$f":"+B22*C22/12","v":0},{"$nulls":6},{"$f":"SUM(R22:W22)","v":0},null,null,0,{"$nulls":6},{"$f":"IF(J22=2.25,\"R \",IF(J22=2.5,\"W \",IF(J22=3.25,\"EW\",\"\")))","v":""},{"$f":"+CONCATENATE(I22,AH22)","v":""},null,null,{"$f":"IF(D22=\"P\",1,\"Error\")","v":1},{"$nulls":5},{"$f":"IF(G22=\"Oak\",0,IF(G22=\"Maple\",0,IF(G22=\"Poplar\",0,40)))","v":40},{"$f":"IF(B22<>0,IF(H22=0,0,IF(H22<1,50, IF(H22>6.5,51,0))),0)","v":0},{"$f":"IF(I22=113,0,IF(I22=115,0,IF(I22=118,0,IF(I22=\"\",0,70))))","v":0},{"$f":"IF(I22=0,0,IF(J22=2.25,0,IF(J22=2.5,0,IF(J22=3.25,0,80))))","v":0},null,{"$f":"IF(K22=0,0,IF(K22=\"006\",0,IF(K22=\"007\",0,IF(K22=\"009\",0,IF(K22=\"011\",0,IF(K22=\"001\",0,100))))))","v":0},null,121,null,0,{"$nulls":5},161,null,"","","","","","*Jamb Species not stock ","","","","","","","*Not a stock color","","","","","","",null,{"$f":"IF(B22<>\"\",+CONCATENATE(BI22,BJ22,BK22,BL22,BM22,BN22,BO22,BP22,BQ22,BS22,BT22,BU22,BV22,BW22,BX22,BY22,BZ22,CA22),\"- Invalid Line -\")","v":"- Invalid Line -"},{"$nulls":5},{"$f":"+Q22","v":0},{"$f":"+E22+H22","v":0},0,{"$f":"IF(CQ22<>0,+CI22*$CL$7,0)","v":0},0,0,null,0,""]
[3,null,null,"P",{"$nulls":7},"",{"$f":"IF(M22=\"\",\"\",+M22)","v":""},null,{"$f":"+BZ23","v":""},null,{"$f":"+B23*C23/12","v":0},{"$nulls":6},{"$f":"SUM(R23:W23)","v":0},null,null,0,{"$nulls":6},{"$f":"IF(J23=2.25,\"R \",IF(J23=2.5,\"W \",IF(J23=3.25,\"EW\",\"\")))","v":""},{"$f":"+CONCATENATE(I23,AH23)","v":""},null,null,{"$f":"IF(D23=\"P\",1,\"Error\")","v":1},{"$nulls":5},{"$f":"IF(G23=\"Oak\",0,IF(G23=\"Maple\",0,IF(G23=\"Poplar\",0,40)))","v":40},{"$f":"IF(B23<>0,IF(H23=0,0,IF(H23<1,50, IF(H23>6.5,51,0))),0)","v":0},{"$f":"IF(I23=113,0,IF(I23=115,0,IF(I23=118,0,IF(I23=\"\",0,70))))","v":0},{"$f":"IF(I23=0,0,IF(J23=2.25,0,IF(J23=2.5,0,IF(J23=3.25,0,80))))","v":0},null,{"$f":"IF(K23=0,0,IF(K23=\"006\",0,IF(K23=\"007\",0,IF(K23=\"009\",0,IF(K23=\"011\",0,IF(K23=\"001\",0,100))))))","v":0},null,121,null,0,{"$nulls":5},161,null,"","","","","","*Jamb Species not stock ","","","","","","","*Not a stock color","","","","","","",null,{"$f":"IF(B23<>\"\",+CONCATENATE(BI23,BJ23,BK23,BL23,BM23,BN23,BO23,BP23,BQ23,BS23,BT23,BU23,BV23,BW23,BX23,BY23,BZ23,CA23),\"- Invalid Line -\")","v":"- Invalid Line -"},{"$nulls":5},{"$f":"+Q23","v":0},{"$f":"+E23+H23","v":0},0,{"$f":"IF(CQ23<>0,+CI23*$CL$7,0)","v":0},0,0,null,0,""]
[4,null,null,"P",{"$nulls":7},"",{"$f":"IF(M23=\"\",\"\",+M23)","v":""},null,{"$f":"+BZ24","v":""},null,{"$f":"+B24*C24/12","v":0},{"$nulls":6},{"$f":"SUM(R24:W24)","v":0},null,null,0,{"$nulls":6},{"$f":"IF(J24=2.25,\"R \",IF(J24=2.5,\"W \",IF(J24=3.25,\"EW\",\"\")))","v":""},{"$f":"+CONCATENATE(I24,AH24)","v":""},null,null,{"$f":"IF(D24=\"P\",1,\"Error\")","v":1},{"$nulls":5},{"$f":"IF(G24=\"Oak\",0,IF(G24=\"Maple\",0,IF(G24=\"Poplar\",0,40)))","v":40},{"$f":"IF(B24<>0,IF(H24=0,0,IF(H24<1,50, IF(H24>6.5,51,0))),0)","v":0},{"$f":"IF(I24=113,0,IF(I24=115,0,IF(I24=118,0,IF(I24=\"\",0,70))))","v":0},{"$f":"IF(I24=0,0,IF(J24=2.25,0,IF(J24=2.5,0,IF(J24=3.25,0,80))))","v":0},null,{"$f":"IF(K24=0,0,IF(K24=\"006\",0,IF(K24=\"007\",0,IF(K24=\"009\",0,IF(K24=\"011\",0,IF(K24=\"001\",0,100))))))","v":0},null,121,null,0,{"$nulls":5},161,null,"","","","","","*Jamb Species not stock ","","","","","","","*Not a stock color","","","","","","",null,{"$f":"IF(B24<>\"\",+CONCATENATE(BI24,BJ24,BK24,BL24,BM24,BN24,BO24,BP24,BQ24,BS24,BT24,BU24,BV24,BW24,BX24,BY24,BZ24,CA24),\"- Invalid Line -\")","v":"- Invalid Line -"},{"$nulls":5},{"$f":"+Q24","v":0},{"$f":"+E24+H24","v":0},0,{"$f":"IF(CQ24<>0,+CI24*$CL$7,0)","v":0},0,0,null,0,""]
[{"$nulls":10},"ff",{"$nulls":69},{"$f":"+CONCATENATE(BI25,BJ25,BK25,BL25,BM25,BN25,BO25,BP25,BQ25,BS25,BT25,BU25,BV25,BW25,BX25,BY25,BZ25,CA25)","v":""}]
[{"$nulls":4},"Type is (W)indow, (D)oor, (S)tool, (H)eader, (O)ctagon, or (C)ustom",{"$nulls":5},"* - also accepts  \"001\" for WDSH-001",{"$nulls":5},{"$f":"SUM(Q9:Q25)","v":0},{"$nulls":6},"*Receive final total via email",null,null,{"$f":"SUM(AA9:AA25)","v":0}]
["Orders in  by 2:00 PM",{"$nulls":10},"OTHER SPECIAL REQUIREMENTS:"]
["Lead Times (Expedited):",{"$nulls":4},"Rush Charges:",{"$nulls":4},"DELIVERY ADDRESS:",{"$nulls":5},"Confirmation Information",{"$nulls":6},"*Email this Excel order form to orders email listed at top of this page"]
["   3 Days for pick & pull parts",{"$nulls":4},"2 Day = 75% Up Charge",null,"1 Day = 100% up charge",null,null,"CONTACT:",{"$nulls":5},"  Customer Acceptance Signature: ________________________"]
["   5 Days for finished windows using stock parts",{"$nulls":4},"n/a",null,"n/a",null,null,"PHONE:",{"$nulls":5},"Sign & Fax to:","651.464.6191",{"$nulls":5}," Date: ______________"]
["   7 Days for finished windows with custom parts",{"$nulls":4},"n/a",null,"n/a",null,null,"OTHER SPECIAL INFORMATION:",{"$nulls":5},"  or Email to:","orders@thewoodster.com"]
[null,null,{"v":12,"d":"12.000"},{"$nulls":13},"   THIS ORDER WILL BE ENTERED INTO WDI PRODUCTION"]
[{"$f":"+Revisions!A28","v":"v2002Feb-T1-Sales"},null,{"$f":"+AF3","v":{"v":0.5,"d":"0.500"}},{"$f":"+AF2","v":"w"},{"$nulls":12},"   SCHEDULE ON RECEIPT OF SIGNED CONFIRMATION"]
[{"$nulls":28},""]
[]
[]
[]
[{"$f":"+A8","v":1},{"$f":"+B8","v":2},{"$f":"+C8","v":3},{"$nulls":3},{"$f":"+G8","v":4},5,6,8,9,0,10,11,0,12,13,14,0,0,0,0,16,17,0,0,16,0,19,20,0,0,0,8,6,0,0,0,0,0]
[{"$nulls":22},"$$/U.I:",{"$f":"+X40/6","v":{"$error":"#VALUE!"}}]
[{"$nulls":6},"Stool calls out stool vs bottom casing",{"$nulls":15},"$$/lft:",{"$f":"+X26/Q41","v":{"$error":"#VALUE!"}}]
[{"$nulls":6},"Door eliminates bottom jamb & casing",{"$nulls":9},{"$f":"+Q26/6","v":0},"lft pricing",{"$nulls":4},"$$/Window",{"$f":"+X26/I5","v":{"$error":"#VALUE!"}}]
[{"$nulls":6},"Header calls out 3 sides of casing & cut to same reveal",{"$nulls":15},"lft/Window",{"$f":"+Q41/I5","v":{"$error":"#VALUE!"}}]
[{"$nulls":6},"Round calls out amounts at zero -> custom calculations"]
[{"$nulls":22},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":22},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":22},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]

{"sheet":"Colors_2020","index":1,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Casings_2020","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Stool_Template","index":3,"n_rows":28,"n_cols":7,"rows_kept":28}
["WDI Company - Window Box Stool template",{"$nulls":5},""]
{"$rows_empty":26}
[{"$nulls":6},""]

{"sheet":"Round_top_Template","index":4,"n_rows":28,"n_cols":7,"rows_kept":28}
["WDI Company - Window Round Top template",{"$nulls":5},""]
{"$rows_empty":26}
[{"$nulls":6},""]

{"sheet":"Round_top_Template_Extended","index":5,"n_rows":28,"n_cols":7,"rows_kept":28}
["WDI Company - Window Extended Round Top template",{"$nulls":5},""]
{"$rows_empty":26}
[{"$nulls":6},""]

{"sheet":"Octagon_Template","index":6,"n_rows":30,"n_cols":59,"rows_kept":30}
["Calculations for Octagon Windows",{"$nulls":3},"Job Name:",{"$f":"+WDI_Standard_Order_Form!C2","v":0},null,null,"Ordered By:",{"$f":"+WDI_Standard_Order_Form!C4","v":0},{"$nulls":13},"WDI Company - Window Box Order Form"]
[{"$nulls":4},"PO #:",{"$f":"+WDI_Standard_Order_Form!C3","v":0},null,null,"WDI Job #",{"$f":"+WDI_Standard_Order_Form!C5","v":"-"}]
[null,"Fill in the green shaded area:",{"$nulls":22},"Job Name:",{"$f":"+WDI_Standard_Order_Form!C2","v":0}]
[{"$nulls":6},"Cut Angle is 22.5o   ",{"$nulls":17},"PO #:",{"$f":"+WDI_Standard_Order_Form!C3","v":0},{"$nulls":12},"Box",null,"Jamb",null,"Thickness",{"$nulls":4},"Diameter","Casing","Stop",{"$nulls":4},"Segment",null,"PI=",{"$f":"PI()","v":{"v":3.141592653589793,"d":"3.14159"}}]
[null,"Information","Key from chart @ right",{"$nulls":21},"Ordered By:",{"$f":"+WDI_Standard_Order_Form!C4","v":0},{"$nulls":8},"Calcs:","OS Box","Casing width",null,"DIAMETER","MAX","SEGMENT LENGTH",null,"Jambs x 2","IS Box","Reveal x 2:","IS Casing","Casing x 2:","OS Casing","SEGMENT LENGTH","SEGMENT LENGTH",null,"Radius","Circum.",null,"Lengths"]
[null,"Outside of Octagon box (A):",{"$nulls":22},"WDI Job #",{"$f":"+WDI_Standard_Order_Form!C5","v":"-"},{"$nulls":30},"Radians of 22.5o",{"$f":"RADIANS(22.5)","v":{"v":0.39269908169872414,"d":"0.39270"}},"for octagonal cuts"]
[null,"Outside of Long side Octagon box (B):",null,{"$f":"+C7-C6","v":0},{"$nulls":20},"Box Size (O.D.)",null," Opening Type","Casing",{"$nulls":28},"COS(22.5)",{"$f":"COS(BF6)","v":{"v":0.9238795325112867,"d":"0.92388"}}]
[null,"Casing Width:",{"$nulls":21},"#","Width","Height",null,"Width"]
[{"$nulls":23},{"$f":"+WDI_Standard_Order_Form!A9","v":1},{"$f":"+WDI_Standard_Order_Form!B9","v":0},{"$f":"+WDI_Standard_Order_Form!C9","v":0},{"$f":"+WDI_Standard_Order_Form!D9","v":"W"},{"$f":"+WDI_Standard_Order_Form!J9","v":0},{"$nulls":6},"Line 1",{"$f":"+C6","v":0},{"$f":"+C8","v":0},null,{"$f":"+AJ9","v":0},{"$f":"SQRT((AO9/2)^2+AZ9^2)*2","v":0},{"$f":"+(AM9/2)*$BF$11*2","v":0},null,{"$f":"-$C$24*2","v":{"v":-1.25,"d":"(1.2500)"}},{"$f":"+AQ9+AJ9","v":{"v":-1.25,"d":"(1.2500)"}},{"$f":"+$C$25*2","v":{"v":0.375,"d":"0.3750"}},{"$f":"+AS9+AR9","v":{"v":-0.875,"d":"(0.8750)"}},{"$f":"+C8*2","v":0},{"$f":"+AU9+AT9","v":{"v":-0.875,"d":"(0.8750)"}},{"$f":"+(AV9/2)*$BF$11*2","v":{"v":-0.36243686707645817,"d":"(0.362)"}},{"$f":"+(AR9/2)*$BF$11*2","v":{"v":-0.5177669529663688,"d":"(0.518)"}},null,{"$f":"+AM9/2","v":0},{"$f":"++AM9*$BF$4","v":0},{"$nulls":3},"SIN(22.5)",{"$f":"SIN(BF6)","v":{"v":0.3826834323650898,"d":"0.38268"}}]
[{"$nulls":23},{"$f":"+WDI_Standard_Order_Form!A10","v":2},{"$f":"+WDI_Standard_Order_Form!B10","v":0},{"$f":"+WDI_Standard_Order_Form!C10","v":0},{"$f":"+WDI_Standard_Order_Form!D10","v":"W"},{"$f":"+WDI_Standard_Order_Form!J10","v":0}]
[{"$nulls":23},{"$f":"+WDI_Standard_Order_Form!A11","v":3},{"$f":"+WDI_Standard_Order_Form!B11","v":0},{"$f":"+WDI_Standard_Order_Form!C11","v":0},{"$f":"+WDI_Standard_Order_Form!D11","v":"W"},{"$f":"+WDI_Standard_Order_Form!J11","v":0},{"$nulls":28},"TAN(22.5)",{"$f":"TAN(BF6)","v":{"v":0.41421356237309503,"d":"0.41421"}}]
[{"$nulls":23},{"$f":"+WDI_Standard_Order_Form!A12","v":4},{"$f":"+WDI_Standard_Order_Form!B12","v":0},{"$f":"+WDI_Standard_Order_Form!C12","v":0},{"$f":"+WDI_Standard_Order_Form!D12","v":"W"},{"$f":"+WDI_Standard_Order_Form!J12","v":0}]
[{"$nulls":23},{"$f":"+WDI_Standard_Order_Form!A13","v":5},{"$f":"+WDI_Standard_Order_Form!B13","v":0},{"$f":"+WDI_Standard_Order_Form!C13","v":0},{"$f":"+WDI_Standard_Order_Form!D13","v":"W"},{"$f":"+WDI_Standard_Order_Form!J13","v":0},{"$nulls":28},"COS = Adj / Hyp"]
[null,"Jamb length (tip to tip):",{"$f":"+AO9","v":0},{"$nulls":20},{"$f":"+WDI_Standard_Order_Form!A14","v":6},{"$f":"+WDI_Standard_Order_Form!B14","v":0},{"$f":"+WDI_Standard_Order_Form!C14","v":0},{"$f":"+WDI_Standard_Order_Form!D14","v":"W"},{"$f":"+WDI_Standard_Order_Form!J14","v":0},{"$nulls":28},"TAN = OP / Adj"]
[null,"casing length (tip to tip):",{"$f":"+AW9","v":{"v":-0.36243686707645817,"d":"(0.3624)"}},{"$nulls":20},{"$f":"+WDI_Standard_Order_Form!A15","v":7},{"$f":"+WDI_Standard_Order_Form!B15","v":0},{"$f":"+WDI_Standard_Order_Form!C15","v":0},{"$f":"+WDI_Standard_Order_Form!D15","v":"W"},{"$f":"+WDI_Standard_Order_Form!J15","v":0},{"$nulls":28},"SIN = OP/Hyp"]
[null,"Stop length (tip to tip):",{"$f":"+AX9","v":{"v":-0.5177669529663688,"d":"(0.5178)"}},{"$nulls":20},{"$f":"+WDI_Standard_Order_Form!A16","v":8},{"$f":"+WDI_Standard_Order_Form!B16","v":0},{"$f":"+WDI_Standard_Order_Form!C16","v":0},{"$f":"+WDI_Standard_Order_Form!D16","v":"W"},{"$f":"+WDI_Standard_Order_Form!J16","v":0}]
[{"$nulls":23},{"$f":"+WDI_Standard_Order_Form!A17","v":9},{"$f":"+WDI_Standard_Order_Form!B17","v":0},{"$f":"+WDI_Standard_Order_Form!C17","v":0},{"$f":"+WDI_Standard_Order_Form!D17","v":"W"},{"$f":"+WDI_Standard_Order_Form!J17","v":0}]
[null,"Long side jamb length (pt to pt):",{"$f":"+C14+$D$7","v":0},{"$nulls":20},{"$f":"+WDI_Standard_Order_Form!A18","v":10},{"$f":"+WDI_Standard_Order_Form!B18","v":0},{"$f":"+WDI_Standard_Order_Form!C18","v":0},{"$f":"+WDI_Standard_Order_Form!D18","v":"W"},{"$f":"+WDI_Standard_Order_Form!J18","v":0}]
[null,"Long side casing length (pt to pt):",{"$f":"+C15+$D$7","v":{"v":-0.36243686707645817,"d":"(0.3624)"}},{"$nulls":20},{"$f":"+WDI_Standard_Order_Form!A19","v":11},{"$f":"+WDI_Standard_Order_Form!B19","v":0},{"$f":"+WDI_Standard_Order_Form!C19","v":0},{"$f":"+WDI_Standard_Order_Form!D19","v":"W"},{"$f":"+WDI_Standard_Order_Form!J19","v":0}]
[null,"Long side stop length (pt to pt):",{"$f":"+C16+$D$7","v":{"v":-0.5177669529663688,"d":"(0.5178)"}},{"$nulls":20},{"$f":"+WDI_Standard_Order_Form!A21","v":1},{"$f":"+WDI_Standard_Order_Form!B21","v":0},{"$f":"+WDI_Standard_Order_Form!C21","v":0},{"$f":"+WDI_Standard_Order_Form!D21","v":"P"},{"$f":"+WDI_Standard_Order_Form!J21","v":0}]
[{"$nulls":23},{"$f":"+WDI_Standard_Order_Form!A22","v":2},{"$f":"+WDI_Standard_Order_Form!B22","v":0},{"$f":"+WDI_Standard_Order_Form!C22","v":0},{"$f":"+WDI_Standard_Order_Form!D22","v":"P"},{"$f":"+WDI_Standard_Order_Form!J22","v":0}]
[{"$nulls":23},{"$f":"+WDI_Standard_Order_Form!A23","v":3},{"$f":"+WDI_Standard_Order_Form!B23","v":0},{"$f":"+WDI_Standard_Order_Form!C23","v":0},{"$f":"+WDI_Standard_Order_Form!D23","v":"P"},{"$f":"+WDI_Standard_Order_Form!J23","v":0}]
[{"$nulls":23},{"$f":"+WDI_Standard_Order_Form!A24","v":4},{"$f":"+WDI_Standard_Order_Form!B24","v":0},{"$f":"+WDI_Standard_Order_Form!C24","v":0},{"$f":"+WDI_Standard_Order_Form!D24","v":"P"},{"$f":"+WDI_Standard_Order_Form!J24","v":0}]
[null,"Jamb thickness:",{"v":0.625,"d":"0.6250"}]
[null,"Casing Reveal:",0.1875]
[]
[null,"Cut @ 22.5 degree angle to Outside of casing length"]
[]
[{"$nulls":3},{"$f":"SUM(D14:D28)","v":0}]
[{"$nulls":3},{"$f":"+D29/12","v":0}]

{"sheet":"Trapezoid_Template","index":7,"n_rows":8,"n_cols":29,"rows_kept":8}
["Trapezoid Calcs"]
[{"$nulls":24},"Length","Angle","Angle","Hyp","Less Jamb"]
[{"$nulls":24},"E","e","f","Length","Length"]
[{"$nulls":24},{"$f":"+D4-B4","v":0},{"$f":"DEGREES(ATAN(Y4/C4))","v":{"$error":"#DIV/0!"}},{"$f":"90-Z4","v":{"$error":"#DIV/0!"}},{"$f":"+SQRT(C4*C4+Y4*Y4)","v":0}]
[]
[]
[]
[null,"Cut top - glue & screw together"]

{"sheet":"OSC_Calcs","index":8,"n_rows":31,"n_cols":52,"rows_kept":31,"merged":[[5,3,6,3]]}
["WDI Company - Window Box Order Form",{"$nulls":5},"CALCULATIONS FOR OUTSIDE OF CASING / BOX SIZE",{"$nulls":11},"",{"$nulls":30},"Window OSC =  OSC","Door OSC =  OSC","Window OSC =  OSC"]
[null,"Job Name:",{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$nulls":9},"Enter in green areas only",{"$nulls":36},"-2 x casing","-1 x casing","-1 x casing"]
[null,"CRI PO #:",{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$nulls":10},"H=Header",{"$nulls":35},"-2 x reveal","-1 x reveal","-1 x reveal"]
[null,"Ordered By:",{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$nulls":46},"+2 x jamb (5/8\")","+1 x jamb (5/8\")","+1 x jamb (5/8\")"]
[null,"WDI Job #",{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$nulls":9},"Outside of Casing",{"$nulls":36},"= NET BOX","= NET BOX","= NET BOX"]
[null,"Box Size (O.D.)",null,"Type","Jamb","Jamb Depth","Profile #","Casing","Casing","Stop/Mull","Casing","Notes",null,"W","D","S",{"$nulls":34},"No Dado","Dado bottom, check apron, mfg stool"]
["#","Width","Height",null,"Species","From I.S of Window","(WDI #113, #115, #118, etc.)","Species","Width","Profile #","Color","Descriptions","Width","Height - Standard Window","Height - Door - OSC to floor","Height - OSC to bottom of stool",{"$nulls":30},"Reveal",null,null,{"$f":"+N6","v":"W"},{"$f":"+O6","v":"D"},{"$f":"+P6","v":"S"}]
[1,2,3,null,4,5,6,7,8,9,10,11,2,3,null,null,12,18,19,{"$nulls":25},20]
[1,{"$f":"IF(+I9=0,\"\",+M9-2*I9-0.375+1.25)","v":""},{"$f":"IF(I9=\"\",\"\",IF(+D9=\"W\",+AX9,+IF(+D9=\"D\",+AY9,+IF(+D9=\"S\",+AZ9,\"Err\"))))","v":""},"W",{"$nulls":42},{"$f":"3/16","v":0.1875},null,null,{"$f":"+N9-(2*I9)-(2*AU9)+(2*0.625)","v":0.875},{"$f":"+O9-I9-AU9+0.625","v":{"v":0.4375,"d":"0.438"}},{"$f":"+P9-I9-AU9+0.625","v":{"v":0.4375,"d":"0.438"}}]
[2,{"$f":"IF(+I10=0,\"\",+M10-2*I10-0.375+1.25)","v":""},{"$f":"IF(I10=\"\",\"\",IF(+D10=\"W\",+AX10,+IF(+D10=\"D\",+AY10,+IF(+D10=\"S\",+AZ10,\"Err\"))))","v":""},"W",{"$nulls":42},{"$f":"+AU9","v":0.1875},null,null,{"$f":"+N10-(2*I10)-(2*AU10)+(2*0.625)","v":0.875},{"$f":"+O10-I10-AU10+0.625","v":{"v":0.4375,"d":"0.438"}},{"$f":"+P10-I10-AU10+0.625","v":{"v":0.4375,"d":"0.438"}}]
[3,"","","W",{"$nulls":42},{"$f":"+AU10","v":0.1875},null,null,0.875,{"v":0.4375,"d":"0.438"},{"v":0.4375,"d":"0.438"}]
[4,"","","W",{"$nulls":42},0.1875,null,null,0.875,{"v":0.4375,"d":"0.438"},{"v":0.4375,"d":"0.438"}]
[5,"","","W",{"$nulls":42},0.1875,null,null,0.875,{"v":0.4375,"d":"0.438"},{"v":0.4375,"d":"0.438"}]
[6,"","","W",{"$nulls":42},0.1875,null,null,0.875,{"v":0.4375,"d":"0.438"},{"v":0.4375,"d":"0.438"}]
[7,"","","W",{"$nulls":42},0.1875,null,null,0.875,{"v":0.4375,"d":"0.438"},{"v":0.4375,"d":"0.438"}]
[8,"","","W",{"$nulls":42},0.1875,null,null,0.875,{"v":0.4375,"d":"0.438"},{"v":0.4375,"d":"0.438"}]
[9,"","","W",{"$nulls":42},0.1875,null,null,0.875,{"v":0.4375,"d":"0.438"},{"v":0.4375,"d":"0.438"}]
[10,{"$f":"IF(+I18=0,\"\",+M18-2*I18-0.375+1.25)","v":""},{"$f":"IF(I18=\"\",\"\",IF(+D18=\"W\",+AX18,+IF(+D18=\"D\",+AY18,+IF(+D18=\"S\",+AZ18,\"Err\"))))","v":""},"W",{"$nulls":42},{"$f":"+AU17","v":0.1875},null,null,{"$f":"+N18-(2*I18)-(2*AU18)+(2*0.625)","v":0.875},{"$f":"+O18-I18-AU18+0.625","v":{"v":0.4375,"d":"0.438"}},{"$f":"+P18-I18-AU18+0.625","v":{"v":0.4375,"d":"0.438"}}]
[11,"","","W",{"$nulls":42},0.1875,null,null,0.875,{"v":0.4375,"d":"0.438"},{"v":0.4375,"d":"0.438"}]
[12,"","","W",{"$nulls":42},0.1875,null,null,0.875,{"v":0.4375,"d":"0.438"},{"v":0.4375,"d":"0.438"}]
[13,"","","W",{"$nulls":42},0.1875,null,null,0.875,{"v":0.4375,"d":"0.438"},{"v":0.4375,"d":"0.438"}]
[14,"","","W",{"$nulls":42},0.1875,null,null,0.875,{"v":0.4375,"d":"0.438"},{"v":0.4375,"d":"0.438"}]
[15,"","","W",{"$nulls":42},0.1875,null,null,0.875,{"v":0.4375,"d":"0.438"},{"v":0.4375,"d":"0.438"}]
[{"$nulls":3},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$nulls":14},""]
[]
[]
[]
[{"$nulls":4},"Stool calls out stool vs bottom casing"]
[{"$nulls":4},"Door eliminates bottom jamb & casing"]
[{"$nulls":4},"Header calls out 3 sides of casing & cut to same reveal"]
[{"$nulls":4},"Round calls out amounts at zero -> custom calculations"]

{"sheet":"Revisions","index":9,"n_rows":28,"n_cols":3,"rows_kept":28,"hidden":true}
["Date","Description"]
["2018-12-14","Change pricing to 2019 price base"]
["2018-12-14","Add WDBB-001 to profile list"]
["2018-12-14","Add WDBC-022 @ 1.875\" to profile list"]
["2018-12-20","Add CRI pricing"]
[]
["2018-12-14","Following changes for version Jan-B2 to implement in January"]
["2018-12-31","Change colors to new color #'s"]
["2018-12-31","Specs, colors, & profiles updated"]
["2019-01-29","Color #50+","v1901Jan-B2-COLR"]
["2019-03-26","moved to Master Template area on server so everyone uses same master","v1903Mar-B2-COLR"]
["2019-12-23","Changed to 2020 pricing, updates templates","v2001Jan-T1-COLR"]
["2019-12-31","Changed to 2020 pricing, updates templates","v2001Jan-T2-COLR"]
["2020-01-09","Changed to 2020 for Sales use","v2001Jan-T2-Sales"]
["2020-02-12","Color chips 2019 or newer","v2002Feb-T1-Sales"]
{"$rows_empty":12}
["v2002Feb-T1-Sales","<-- Version label for page #1"]