{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["WDI_Standard_Order_Form","OSC_Calcs","Casing_Profiles","Colors","Stool_Template","Round_top_Template","Trapezoid_Sheet_v3","LISTS"],"not_rendered":{"images":7,"defined_names":20},"read":"whole","date_system":"1900"}

{"sheet":"WDI_Standard_Order_Form","index":0,"n_rows":131,"n_cols":97,"rows_kept":131,"merged":[[5,3,6,3],[5,40,6,40],[5,62,6,62]]}
["WDI Company - Trim Kit/Parts Order Form",{"$nulls":15},"CONTACT WDI COMPANY",{"$nulls":11},"",{"$nulls":8},"Error Codes --->",{"$nulls":14},"Other logic faults -->"]
[null,"Job Name:",{"$nulls":5},"Order Date:",{"$nulls":8},"OFFICE:","651.464.6190",null,"LINKS:",{"$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:",{"$nulls":4},{"$f":"IF(I3-I2<14,\"Short lead time, Rush charges may apply\",IF(I3-I2>30,\"Ship date is >30 days\",\"\"))","v":"Short lead time, Rush charges may apply"},{"$nulls":3},"TOLL FREE:","800.899.4265",null,"WDI WEBSITE LINK",{"$nulls":10},"Scaler:",{"v":0.5,"d":"0.50"},"white premium, CRI vs WDI Pricing",{"$nulls":27},"Errors"]
[null,"Ordered By:",{"$nulls":5},"Customer Name:",{"$nulls":8},"FAX:","651.464.6191",null,"INSTALL VIDEO LINK",{"$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 #",{"$nulls":5},"# Window Line Items:",null,null,"# Parts Line Items:",null,"Total Items:",{"$f":"+L5+I5","v":0},{"$f":"IF(+I5+L5<>+N5,\"Error - Line Count Off !!\",\"\")","v":""},{"$nulls":73},"Weights -->",null,null,"Total"]
[null,"JAMB BOX SIZE (O.D.)",null," Opening Type","STOOL DIM'S",null,"WOOD SPECIES","JAMB DEPTH","CASING PROFILE #","CASING WIDTH","STOP PROFILE #","STOP WIDTH","COLOR #","Notes",null,null,"TRIM KIT","TRIM KIT","TRIM KIT","Additional","Additional","Additional","Additional","TRIM KIT",{"$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 2017)","Descriptions: Ex. Room Location","*Order messages & errors*",null,"Pricing Length (United Inches)","PRICE: JAMB & CASING","PRICE: STOPS","Items & Charges","Items & Charges","Items & Charges","Items & Charges","TOTAL COST PER LINE ITEM",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",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>=1,IF(M9<=23,0,IF(M9=30,0,121)),120)","v":120},null,{"$f":"IF(M9=4,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(M9=\"\",\"\",+M9)","v":""},null,"- Invalid Line -",null,0,{"$nulls":6},0,null,null,{"$f":"+CN10","v":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},{"$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},{"$f":"+H10","v":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},{"$f":"IF(K12=\"\",\"\",IF(K12=\"006\",IF(H12>2,1.25,1), IF(K12=\"007\",2, IF(K12=\"009\",0.75, IF(K12=\"011\",1.25,IF(K12=\"001\",0.75,0.754))))))","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,""]
[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},{"$f":"IF(K14=\"\",\"\",IF(K14=\"006\",IF(H14>2,1.25,1), IF(K14=\"007\",2, IF(K14=\"009\",0.75, IF(K14=\"011\",1.25,IF(K14=\"001\",0.75,0.754))))))","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,""]
[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",{"$nulls":3},"Misc profile",null,"Color #","Last 4 lines for Parts",null,null,"Length (lft)",{"$nulls":9},0]
[1,null,null,"P",{"$nulls":7},{"$f":"IF(K21=\"\",\"\",IF(K21=\"006\",1.25, IF(K21=\"007\",2, IF(K21=\"009\",0.75, IF(K21=\"011\",1.25,IF(K21=\"001\",0.75,0.755))))))","v":""},{"$f":"IF(M19=\"\",\"\",+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,{"$f":"IF(M21>=1,IF(M21<=23,0,IF(M21=30,0,121)),120)","v":121},null,{"$f":"IF(M21=4,IF(G21=\"Oak\",150,0),0)","v":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(K22=\"006\",1.25, IF(K22=\"007\",2, IF(K22=\"009\",0.75, IF(K22=\"011\",1.25,IF(K22=\"001\",0.75,0.755))))))","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,{"$f":"IF(M22>=1,IF(M22<=23,0,IF(M22=30,0,121)),120)","v":121},null,{"$f":"IF(M22=4,IF(G22=\"Oak\",150,0),0)","v":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(K23=\"\",\"\",IF(K23=\"006\",1.25, IF(K23=\"007\",2, IF(K23=\"009\",0.75, IF(K23=\"011\",1.25,IF(K23=\"001\",0.75,0.755))))))","v":""},{"$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,{"$f":"IF(M23>=1,IF(M23<=23,0,IF(M23=30,0,121)),120)","v":121},null,{"$f":"IF(M23=4,IF(G23=\"Oak\",150,0),0)","v":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(K24=\"\",\"\",IF(K24=\"006\",1.25, IF(K24=\"007\",2, IF(K24=\"009\",0.75, IF(K24=\"011\",1.25,IF(K24=\"001\",0.75,0.755))))))","v":""},{"$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,{"$f":"IF(M24>=1,IF(M24<=23,0,IF(M24=30,0,121)),120)","v":121},null,{"$f":"IF(M24=4,IF(G24=\"Oak\",150,0),0)","v":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},{"$f":"SUM(R9:R25)","v":0},{"$f":"SUM(S9:S25)","v":0},0,{"$f":"SUM(U9:U25)","v":0},0,0,{"$f":"SUM(X9:X25)","v":0},null,null,{"$f":"SUM(AA9:AA25)","v":0}]
["Orders in  by 2:00 PM",{"$nulls":10},"DELIVERY INFORMATION:"]
["Lead Times (Expedited):",{"$nulls":4},"Rush Charges:",{"$nulls":4},"ADDRESS:",{"$nulls":5},"Confirmation Information"]
["   3 Days for pick & pull parts",{"$nulls":4},"2 Day = 75% Up Charge",null,"1 Day = 100% up charge",null,null,"CONTACT NAME:",{"$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},"  Fax to: (651) 464-6191",{"$nulls":5}," Date: ______________"]
["   7 Days for finished windows with custom parts",{"$nulls":4},"n/a",null,"n/a",{"$nulls":8},"  or Email: CustomerService@WDICustomWood.com"]
[{"$nulls":16},"   THIS ORDER WILL BE ENTERED INTO WDI PRODUCTION"]
["v1712Dec",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,{"$f":"+I8","v":6},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+J8","v":8},{"$f":"+K8","v":9},null,{"$f":"+M8","v":10},{"$f":"+N8","v":11},12,13,14,{"$nulls":4},16,17,{"$f":"+Y8","v":0},{"$nulls":3},19,20,{"$nulls":3},{"$f":"+AH8","v":8},{"$f":"+AD8","v":20}]
[{"$nulls":22},"$$/U.I:",{"$f":"+X40/6","v":{"$error":"#DIV/0!"}}]
[{"$nulls":6},"Stool calls out stool vs bottom casing",{"$nulls":15},"$$/lft:",{"$f":"+X26/Q41","v":{"$error":"#DIV/0!"}}]
[{"$nulls":6},"Door eliminates bottom jamb & casing",{"$nulls":9},{"$f":"+Q26/6","v":0},"lft pricing",{"$nulls":4},"$$/Window",{"$f":"+X26/I5","v":{"$error":"#DIV/0!"}}]
[{"$nulls":6},"Header calls out 3 sides of casing & cut to same reveal",{"$nulls":15},"lft/Window",{"$f":"+Q41/I5","v":{"$error":"#DIV/0!"}}]
[{"$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!"}}]
{"$rows_empty":83}
[null,"standard stop profile # and width"]
[null,"006",1.25,"IN."]

{"sheet":"OSC_Calcs","index":1,"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":"Casing_Profiles","index":2,"n_rows":4,"n_cols":12,"rows_kept":4,"merged":[[0,10,0,11]]}
[{"$nulls":8},"PROFILE NAME","PROFILE REFERENCE #","STANDARD WIDTHS"]
[{"$nulls":8},"RANCH",113,2.25,"IN."]
[{"$nulls":8},"COLONIAL",115,2.5,"IN."]
[{"$nulls":8},"PRINCETON",118,3.25,"IN."]

{"sheet":"Colors","index":3,"n_rows":29,"n_cols":32,"rows_kept":29}
["WDI Company - Window Box Colors & Profiles",{"$nulls":11},"",{"$nulls":18},1]
[null,"Colors",null,null,"2015-10-26",{"$nulls":26},2]
[null,null,"#",null,"Sorted by Name",{"$nulls":3},"Sorted by Number",{"$nulls":22},3]
[null,"AWS",5,null,"American Walnut Oak",null,null,"DOS",1,null,"Dark Oak Supreme",{"$nulls":20},4]
[null,"BBC",17,null,"BRI Brazilian Cherry",null,null,"LOS",2,null,"Light Oak Supreme",{"$nulls":20},5]
[null,"BCO",16,null,"BRI Cherry Oak",null,null,"COS",3,null,"Cherry Oak Supreme",{"$nulls":20},6]
[null,"BLO",14,null,"BRI Light Oak",null,null,"WS",4,null,"White Supreme (paint)",{"$nulls":20},7]
[null,"BMA",18,null,"BRI Maple",null,null,"AWS",5,null,"American Walnut Oak",{"$nulls":20},8]
[null,"BMO",15,null,"BRI Medium Oak ",null,null,"Cinn Oak",6,null,"Cinnamon Oak",{"$nulls":20},9]
[null,"COS",3,null,"Cherry Oak Supreme",null,null,"GO",7,null,"Golden Oak",{"$nulls":20},10]
[null,"Cinn Oak",6,null,"Cinnamon Oak",null,null,"TC",8,null,"Traditional Cherry Oak",{"$nulls":20},11]
[null,"CLR",22,null,"Clear coat only",null,null,"CB",9,null,"Coffee Bean Oak #2",{"$nulls":20},12]
[null,"CB",9,null,"Coffee Bean Oak #2",null,null,"RC",10,null,"Rich Cherry Oak",{"$nulls":20},13]
[null,"#23",23,null,"Color #23",null,null,"WO",11,null,"White Oak",{"$nulls":20},14]
[null,"CP",13,null,"Country Pine Oak",null,null,"TM",12,null,"Traditional Mahogany Oak",{"$nulls":20},15]
[null,"CU",30,null,"Custom color match",null,null,"CP",13,null,"Country Pine Oak",{"$nulls":20},16]
[null,"DOS",1,null,"Dark Oak Supreme",null,null,"BLO",14,null,"BRI Light Oak",{"$nulls":20},17]
[null,"GO",7,null,"Golden Oak",null,null,"BMO",15,null,"BRI Medium Oak ",{"$nulls":11},"WOOD SPECIES",{"$nulls":8},18]
[null,"LOS",2,null,"Light Oak Supreme",null,null,"BCO",16,null,"BRI Cherry Oak",{"$nulls":11},"OAK",{"$nulls":8},19]
[null,"RAW",21,null,"Raw - no finish",null,null,"BBC",17,null,"BRI Brazilian Cherry",{"$nulls":11},"MAPLE",{"$nulls":8},20]
[null,"RC",10,null,"Rich Cherry Oak",null,null,"BMA",18,null,"BRI Maple",{"$nulls":11},"POPLAR",{"$nulls":8},21]
[null,"RM",20,null,"Rich Maple",null,null,"SM",19,null,"Soft Maple",{"$nulls":20},22]
[null,"SM",19,null,"Soft Maple",null,null,"RM",20,null,"Rich Maple",{"$nulls":20},23]
[null,"TC",8,null,"Traditional Cherry Oak",null,null,"RAW",21,null,"Raw - no finish",{"$nulls":20},24]
[null,"TM",12,null,"Traditional Mahogany Oak",null,null,"CLR",22,null,"Clear coat only",{"$nulls":20},"M100"]
[null,"WO",11,null,"White Oak",null,null,"#23",23,null,"Color #23"]
[null,"WS",4,null,"White Supreme (paint)",null,null,"CU",30,null,"Custom color match"]
[null,"#24",24,null,"Color #24",null,null,"#24",24,null,"Color #24"]
[{"$nulls":12},""]

{"sheet":"Stool_Template","index":4,"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":5,"n_rows":28,"n_cols":7,"rows_kept":28}
["WDI Company - Window Round Top template",{"$nulls":5},""]
{"$rows_empty":26}
[{"$nulls":6},""]

{"sheet":"Trapezoid_Sheet_v3","index":6,"n_rows":8,"n_cols":29,"rows_kept":8,"hidden":true}
["Trapezoid Calcs","Short Side","Base","Long side",null,"Top"]
["Version 2","Length","Length","Length",null,"Length","Angle",{"$nulls":17},"Length","Angle","Angle","Hyp","Less Jamb"]
[null,"A","B","C",null,"d","e",{"$nulls":17},"E","e","f","Length","Length"]
[null,12,74.5,27.25,null,{"$f":"+AB4","v":{"v":76.04480587127566,"d":"76.04"}},{"$f":"+Z4","v":{"v":11.5685190204243,"d":"11.57"}},{"$nulls":17},{"$f":"+D4-B4","v":15.25},{"$f":"DEGREES(ATAN(Y4/C4))","v":{"v":11.5685190204243,"d":"11.57"}},{"$f":"90-Z4","v":{"v":78.4314809795757,"d":"78.43"}},{"$f":"+SQRT(C4*C4+Y4*Y4)","v":{"v":76.04480587127566,"d":"76.04"}}]
[{"$nulls":6},{"$f":"90-G4","v":{"v":78.4314809795757,"d":"78.43"}}]
[null,"Input green area"]
[]
[null,"Cut top - glue & screw together"]

{"sheet":"LISTS","index":7,"n_rows":8,"n_cols":1,"rows_kept":8,"hidden":true}
["LISTS"]
[]
["OPENING TYPE"]
["W"]
["D"]
["S"]
["C"]
["O"]