{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Order Entry","Pictures","Database Info ","CSV"],"not_rendered":{"charts":0,"images":52,"macros":0,"external_links":0,"defined_names":100,"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":"Order Entry","index":0,"n_rows":39,"n_cols":37,"rows_kept":39,"cut":false,"hidden":false,"merged":[[37,0,37,1],[12,2,12,5],[13,2,13,5],[25,2,25,5],[26,2,26,5],[27,2,27,5],[24,2,24,5],[18,2,18,5],[17,2,17,5],[16,2,16,5],[15,2,15,5],[14,2,14,5],[35,0,35,1],[19,0,19,1],[20,0,20,1],[36,0,36,1],[8,2,8,5],[9,2,9,5],[10,2,10,5],[11,2,11,5],[7,7,17,9],[19,2,19,5],[20,2,20,5],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[23,2,23,5],[28,2,28,5],[29,2,29,3],[31,0,31,1],[32,0,32,1],[30,0,30,1],[34,0,34,1],[30,2,30,5],[14,0,14,1],[15,0,15,1],[17,0,17,1],[16,0,16,1],[18,0,18,1]]}
[null,null,null,"845 Prosper Road",null,null,null,null,null,null,null,"Frame Code","Width","Height","Hinge","Ends","Qty","Guides","Notes",{"$f":"IF(L2<>\"\",\"Frame\",)","v":0},{"$f":"IF(L3<>\"\",\"Frame\",)","v":0},{"$f":"IF(L6<>\"\",\"Frame\",)","v":0},{"$f":"IF(L7<>\"\",\"Frame\",)","v":0},{"$f":"IF(L10<>\"\",\"Frame\",)","v":0},{"$f":"IF(L11<>\"\",\"Frame\",)","v":0},{"$f":"IF(L14<>\"\",\"Frame\",)","v":0},{"$f":"IF(L15<>\"\",\"Frame\",)","v":0},{"$f":"IF(L18<>\"\",\"Frame\",)","v":0},{"$f":"IF(L19<>\"\",\"Frame\",)","v":0},{"$f":"IF(L22<>\"\",\"Frame\",)","v":0},{"$f":"IF(L23<>\"\",\"Frame\",)","v":0},{"$f":"IF(L26<>\"\",\"Frame\",)","v":0},{"$f":"IF(L27<>\"\",\"Frame\",)","v":0},{"$f":"IF(L30<>\"\",\"Frame\",)","v":0},{"$f":"IF(L31<>\"\",\"Frame\",)","v":0},{"$f":"IF(L34<>\"\",\"Frame\",)","v":0},{"$f":"IF(L35<>\"\",\"Frame\",)","v":0}]
[null,null,null,"De Pere, WI 54115",null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"IF(L2<>\"\",K2,)","v":0},{"$f":"IF(L3<>\"\",K3,)","v":0},{"$f":"IF(L6<>\"\",K6,)","v":0},{"$f":"IF(L7<>\"\",K7,)","v":0},{"$f":"IF(L10<>\"\",K10,)","v":0},{"$f":"IF(L11<>\"\",K11,)","v":0},{"$f":"IF(L14<>\"\",K14,)","v":0},{"$f":"IF(L15<>\"\",K15,)","v":0},{"$f":"IF(L18<>\"\",K18,)","v":0},{"$f":"IF(L19<>\"\",K19,)","v":0},{"$f":"IF(L22<>\"\",K22,)","v":0},{"$f":"IF(L23<>\"\",K23,)","v":0},{"$f":"IF(L26<>\"\",K26,)","v":0},{"$f":"IF(L27<>\"\",K27,)","v":0},{"$f":"IF(L30<>\"\",K30,)","v":0},{"$f":"IF(L31<>\"\",K31,)","v":0},{"$f":"IF(L34<>\"\",K34,)","v":0},{"$f":"IF(L35<>\"\",K35,)","v":0}]
[null,null,null,"Toll Free 888-815-9648▪ Fax 920-336-5956",null,null,null,"VCD#",null,null,{"$f":"K2+1","v":2},null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(T2,$K$2:$P$44,2,FALSE),\"BLANK\")","v":"BLANK"},{"$f":"IFERROR(VLOOKUP(U2,$K$2:$N$44,2,FALSE),\"BLANK\")","v":"BLANK"},"BLANK","BLANK","BLANK","BLANK",{"$f":"IFERROR(VLOOKUP(Z2,$K$2:$P$44,2,FALSE),\"BLANK\")","v":"BLANK"},{"$f":"IFERROR(VLOOKUP(AA2,$K$2:$N$44,2,FALSE),\"BLANK\")","v":"BLANK"},"BLANK","BLANK","BLANK","BLANK",{"$f":"IFERROR(VLOOKUP(AF2,$K$2:$P$44,2,FALSE),\"BLANK\")","v":"BLANK"},{"$f":"IFERROR(VLOOKUP(AG2,$K$2:$N$44,2,FALSE),\"BLANK\")","v":"BLANK"},"BLANK","BLANK",{"$f":"IFERROR(VLOOKUP(AJ2,$K$2:$N$44,2,FALSE),\"BLANK\")","v":"BLANK"},"BLANK"]
[null,null,null,"Email: vcd@valleycustomdoor.com",null,null,null,null,null,null,{"$f":"K3+1","v":3},null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(T2,$K$2:$S$44,7,FALSE),\"BLANK\")","v":"BLANK"},"BLANK","BLANK","BLANK","BLANK","BLANK","BLANK","BLANK","BLANK","BLANK","BLANK","BLANK","BLANK","BLANK","BLANK","BLANK","BLANK","BLANK"]
[null,null,null,"Website: www.valleycustomdoor.com",null,null,null,"Lead Time",null,null,4]
[null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,"Job Comments:",null,null,6]
["Customer Info",null,null,null,null,null,null,null,null,null,7]
["Customer # :  ",null,null,null,null,null,null,null,null,null,8]
["Company Name:",null,null,null,null,null,null,null,null,null,9]
["Mailing Address:  ",null,null,null,null,null,null,null,null,null,10]
["Shipping Address: ",null,null,null,null,null,null,null,null,null,11]
["City/State/Zip: ",null,null,null,null,null,null,null,null,null,12]
["Order Date:",null,{"$f":"+TODAY()","v":"2021-02-17"},null,null,null,null,null,null,null,13]
["Phone: ",null,null,null,null,null,null,null,null,null,14]
["Fax/Email: ",null,null,null,null,null,null,null,null,null,15]
["Job Name: ",null,null,null,null,null,null,null,null,null,16]
["P.O #:",null,null,null,null,null,null,null,null,null,17]
["Prefinish Color:",null,null,null,null,null,null,null,null,null,18]
["Gloss: ",null,null,null,null,null,null,"Drawer Box Info",null,null,19,null,null,null,null,null,null,null,null,{"$f":"IF(L4<>\"\",\"Frame\",)","v":0},{"$f":"IF(L5<>\"\",\"Frame\",)","v":0},{"$f":"IF(L8<>\"\",\"Frame\",)","v":0},{"$f":"IF(L9<>\"\",\"Frame\",)","v":0},{"$f":"IF(L12<>\"\",\"Frame\",)","v":0},{"$f":"IF(L13<>\"\",\"Frame\",)","v":0},{"$f":"IF(L16<>\"\",\"Frame\",)","v":0},{"$f":"IF(L17<>\"\",\"Frame\",)","v":0},{"$f":"IF(L20<>\"\",\"Frame\",)","v":0},{"$f":"IF(L21<>\"\",\"Frame\",)","v":0},{"$f":"IF(L24<>\"\",\"Frame\",)","v":0},{"$f":"IF(L25<>\"\",\"Frame\",)","v":0},{"$f":"IF(L28<>\"\",\"Frame\",)","v":0},{"$f":"IF(L29<>\"\",\"Frame\",)","v":0},{"$f":"IF(L32<>\"\",\"Frame\",)","v":0},{"$f":"IF(L33<>\"\",\"Frame\",)","v":0},{"$f":"IF(L36<>\"\",\"Frame\",)","v":0},{"$f":"IF(L37<>\"\",\"Frame\",)","v":0}]
["Glaze: ",null,null,null,null,null,null,"VCD Supply Drawer Boxes:",null,null,20,null,null,null,null,null,null,null,null,{"$f":"IF(L4<>\"\",K4,)","v":0},{"$f":"IF(L5<>\"\",K5,)","v":0},{"$f":"IF(L8<>\"\",K8,)","v":0},{"$f":"IF(L9<>\"\",K9,)","v":0},{"$f":"IF(L12<>\"\",K12,)","v":0},{"$f":"IF(L13<>\"\",K13,)","v":0},{"$f":"IF(L16<>\"\",K16,)","v":0},{"$f":"IF(L17<>\"\",K17,)","v":0},{"$f":"IF(L20<>\"\",K20,)","v":0},{"$f":"IF(L21<>\"\",K21,)","v":0},{"$f":"IF(L24<>\"\",K24,)","v":0},{"$f":"IF(L25<>\"\",K25,)","v":0},{"$f":"IF(L28<>\"\",K28,)","v":0},{"$f":"IF(L29<>\"\",K29,)","v":0},{"$f":"IF(L32<>\"\",K32,)","v":0},{"$f":"IF(L33<>\"\",K33,)","v":0},{"$f":"IF(L36<>\"\",K36,)","v":0},{"$f":"IF(L37<>\"\",K37,)","v":0}]
[null,null,null,null,null,null,null,"Drawer Box Construction:",null,null,21,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(T21,$K$2:$N$44,2,FALSE),\"BLANK\")","v":"BLANK"},"BLANK","BLANK","BLANK","BLANK","BLANK",{"$f":"IFERROR(VLOOKUP(Z21,$K$2:$N$44,2,FALSE),\"BLANK\")","v":"BLANK"},"BLANK","BLANK","BLANK","BLANK","BLANK","BLANK","BLANK","BLANK","BLANK",{"$f":"IFERROR(VLOOKUP(AJ21,$K$2:$N$44,2,FALSE),\"BLANK\")","v":"BLANK"},"BLANK"]
["Door/Drawer Front Information",null,null,null,null,null,null,"Box Material:",null,null,22,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(T21,$K$2:$S$44,7,FALSE),\"BLANK\")","v":"BLANK"},"BLANK","BLANK","BLANK","BLANK","BLANK","BLANK","BLANK","BLANK","BLANK","BLANK","BLANK","BLANK","BLANK","BLANK","BLANK","BLANK","BLANK"]
["Door Style:",null,null,null,null,null,null,"Box Side Thickness:",null,null,23]
["Material:",null,null,null,null,null,null,"Box Bottom Thickness:",null,null,24]
["Outside Profile:",null,null,null,null,null,null,"Track Style:",null,null,25]
["S/R Profile:",null,null,null,null,null,null,"Under Notch:",null,null,26]
["Panel Profile:",null,null,null,null,null,null,"Box Finish:",null,null,27]
["Drawer Style:",null,null,null,null,null,null,"Bottom Application:",null,null,28]
["Drawer Edge Profile:",null,null,null,"S/R:",null,null,"VCD Supply Tracks:",null,null,29]
["Drawer Panel Profile:",null,null,null,null,null,null,null,null,null,{"$f":"K30+1","v":30}]
["L & R Overlay",null,null,"T & B Overlay",null,null,null,"Hinge Info",null,null,31]
[null,null,null,null,null,null,null,"VCD to Drill Hinge:",null,null,32]
["Face Frame Standards Rail Sizes 1-1/2\" Unless Noted",null,null,null,null,null,null,"VCD Supply Hinge:",null,null,33]
["Frame Style",null,null,"Frame Application",null,null,null,"35mm Hinge:",null,null,34]
[null,null,null,null,null,null,null,"Cup Depth:",null,null,35]
["Job Type",null,null,null,null,null,null,"Drill Distance:",null,null,36]
[]
[{"$f":"EVEN((ROUNDUP((COUNTIF($L$2:$L$37,\"*\")),0))/2)","v":0},"Rev. 07/02/19"]

{"sheet":"Pictures","index":1,"n_rows":50,"n_cols":2,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
["Frame","Picture"]
["BLANK"]
["W"]
["W1D"]
["W2D"]
["W2DR"]
["W3D"]
["W3DR"]
["WHOOD"]
["DB_2"]
["DB_3"]
["DB_4"]
["B"]
["BCL"]
["BCR"]
["BD_2"]
["BFH"]
["BPP"]
["LP"]
["SB_BD"]
["SBFF"]
["SBFF1"]
["FRIDGE DBL LEG"]
["FRIDGE LEFT LEG"]
["FRIDGE RIGHT LEG"]
["KTU"]
["OCD"]
["OCMD"]
["UT_1"]
["UT"]
["UT1D"]
["UT3D"]
["UT3DR"]
["SEE_SKETCH"]
["VCDD6"]
["VCD_2"]
["VCD4L"]
["VCD4R"]
["VCDS4"]
["VCDS3"]
["VCDS33MS"]
["VCDD63MS"]
["VW2D"]
["VCD3L"]
["VCD3R"]
["VCD_3"]
["B_2DR"]
["BFH_2DR"]
["WW"]
["WW_2DR"]

{"sheet":"Database Info ","index":2,"n_rows":53,"n_cols":24,"rows_kept":53,"cut":false,"hidden":true,"merged":[]}
["FACE NAME","ENDS","HINGE","FACE STYLE","FACE APPLICATION","GLOSS","GLAZE","PREFINISH","Overlay L&R, T&B","Construction","Box Material","Side Thickness","Bottom","Blum Box","Full Ext Box","Box Finish","Under Notch","Bottom Application ","Tracks","VCD to hinge","VCD Supply Hinge","35mm Hinge","Cup Depth","Drill Distance"]
["B","L","L","OVERLAY 1 1/2 RAILS","OVERLAY","SATIN","BLACK GLAZE","UNFINISHED","0","DOVETAIL","STANDARD MIX","5/8\"","1/4\"","OMIT","OMIT","NATURAL","YES","INSET 1/2\"","BLUM","YES","NO","HBP 100","7/16\"","3/32\" 2.5mm"]
["B_2DR","R","R","INSET 1 1/2 RAILS","INSET","MATTE","BROWN GLAZE","ALANTIC BLUE","1/16","DOWEL","ALL BIRCH","1/2\"","1/2\"",9,12,"UNFINISHED","NO","INSET 1/4\"","FULLEXT","NO","YES -BLUM 38N","HBP 300","1/2\"","1/8\" 3.2mm"]
["B4DR","B","PR",null,"INSET BEADED",null,"BRUSHED BLACK GLAZE","AUTUMN WHEAT","1/8",null,"WALNUT","3/4\"",null,12,14,"PER SAMPLE",null,"BOTTOM MOUNT",null,null,"YES -BLUM 38C",null,null,"5/32\" 4mm"]
["B5DR","N","AS NOTED",null,"INSET*PIN HNG*",null,"BRUSHED BROWN GLAZE","BEECHWOOD","3/16",null,"CHERRY",null,null,15,16,null,null,null,null,null,"YES - HETTICH",null,null,"3/16\" 4.8mm"]
["BBCL",null,"OMIT",null,"INSET BEAD*PIN HNG*",null,"VINTAGE FINISH","BRANDY","1/4",null,"SELECT RED OAK",null,null,18,18]
["BBCR","Talls",null,"Lead Time",null,null,null,"BROWNSTONE","1/2",null,"SELECT HARD MAPLE",null,null,21,20]
["BCL",null,null,null,null,null,null,"BUTTERMILK","5/16",null,"SELECT HICKORY",null,null,"21 HD",22]
["BCR",null,null,"Expedite",null,null,null,"CARMEL","3/8",null,"SELECT CHERRY",null,null,"24 HD"]
["BD_2",null,null,"Standard ",null,null,null,"CASCADE","7/16",null,"SELECT WALNUT",null,null,"27 HD"]
["BFH","FRIDGE_DBL_LEG",null,null,null,null,null,"CHESTNUT","9/16",null,"SELECT WHITE ASH",null,null,"31 HD"]
["BFH_2DR","FRIDGE_LEFT_LEG",null,null,null,null,null,"CLASSIC GREY","5/8",null,"SELECT WHITE OAK"]
["BPP","FRIDGE_RIGHT_LEG",null,null,null,null,null,"COBBLESTONE","11/16",null,"WHITE MEL"]
["DB_2","KTU",null,null,null,null,null,"COBBLESTONE","3/4",null,"MAPLE VC"]
["DB_3","OCD",null,null,null,null,null,"CUSTARD","13/16",null,"RED OAK VC"]
["DB_4","OCMD",null,null,null,null,null,"CUSTOM PAINT MATCH","7/8",null,"CHERRY VC"]
["FRIDGE_DBL_LEG","UT",null,null,null,null,null,"CUSTOM STAIN MATCH","15/16",null,"BIRCH VC"]
["FRIDGE_LEFT_LEG","UT_1",null,null,null,null,null,"DARK PECAN","1"]
["FRIDGE_RIGHT_LEG","UT1D",null,"Job Type",null,null,null,"DESERT SAND","1-1/16"]
["KTU","UT3D",null,"Frames Only",null,null,null,"DRIFTWOOD","1-1/8"]
["LP","UT3DR",null,"Frames & Doors ",null,null,null,"EBONY","1-3/16"]
["OCD",null,null,null,null,null,null,"EGGSHELL","1-1/4"]
["OCMD",null,null,null,null,null,null,"FAWN","1-5/16"]
["SB_BD",null,null,null,null,null,null,"FIELDSTONE","1-3/8"]
["SBFF",null,null,null,null,null,null,"FROST","1-7/16"]
["SBFF1",null,null,null,null,null,null,"HARBOR BLUE","1-1/2"]
["SEE_SKETCH",null,null,null,null,null,null,"HARBOR GREY","1-9/16"]
["UT",null,null,null,null,null,null,"HARVEST","1-5/8"]
["UT_1",null,null,null,null,null,null,"HEARTHSTONE","1-11/16"]
["UT1D",null,null,null,null,null,null,"HONEY MAPLE","1-3/4"]
["UT3D",null,null,null,null,null,null,"INDIGO","1-13/16"]
["UT3DR",null,null,null,null,null,null,"IVORY","1-7/8"]
["VCD_2",null,null,null,null,null,null,"JAVA","1-15/16"]
["VCD_3",null,null,null,null,null,null,"LAVA STONE","2"]
["VCD3L",null,null,null,null,null,null,"MEADOW","AS NOTED"]
["VCD3R",null,null,null,null,null,null,"MUSHROOM"]
["VCD4L",null,null,null,null,null,null,"NATURAL"]
["VCD4R",null,null,null,null,null,null,"NIGHTFALL"]
["VCDD6",null,null,null,null,null,null,"PRIMED ONLY"]
["VCDD63MS",null,null,null,null,null,null,"REGAL CHERRY"]
["VCDS3",null,null,null,null,null,null,"RIVERWOOD"]
["VCDS33MS",null,null,null,null,null,null,"ROCKY ROAD"]
["VCDS4",null,null,null,null,null,null,"SAND"]
["VW2D",null,null,null,null,null,null,"SLATE"]
["W",null,null,null,null,null,null,"SNOW WHITE"]
["W1D",null,null,null,null,null,null,"STONEDUST"]
["W2D",null,null,null,null,null,null,"STONEGATE"]
["W2DR",null,null,null,null,null,null,"WHITE SKY"]
["W3D",null,null,null,null,null,null,"WILD CHERRY"]
["W3DR",null,null,null,null,null,null,"WILD HONEY"]
["WHOOD",null,null,null,null,null,null,"WINTER WHITE"]
["WW",null,null,null,null,null,null,"WOODLAND GREY"]
["WW_2DR"]

{"sheet":"CSV","index":3,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[{"$f":"IF($D1=\"PR\",'Order Entry'!L2&\"-P\",'Order Entry'!L2)","v":0},{"$f":"'Order Entry'!M2","v":0},{"$f":"'Order Entry'!N2","v":0},{"$f":"'Order Entry'!O2","v":0},{"$f":"'Order Entry'!Q2","v":0},{"$f":"'Order Entry'!P2","v":0}]
[{"$f":"IF($D2=\"PR\",'Order Entry'!L3&\"-P\",'Order Entry'!L3)","v":0},{"$f":"'Order Entry'!M3","v":0},{"$f":"'Order Entry'!N3","v":0},{"$f":"'Order Entry'!O3","v":0},{"$f":"'Order Entry'!Q3","v":0},{"$f":"'Order Entry'!P3","v":0}]
[{"$f":"IF($D3=\"PR\",'Order Entry'!L4&\"-P\",'Order Entry'!L4)","v":0},{"$f":"'Order Entry'!M4","v":0},{"$f":"'Order Entry'!N4","v":0},{"$f":"'Order Entry'!O4","v":0},{"$f":"'Order Entry'!Q4","v":0},{"$f":"'Order Entry'!P4","v":0}]
[{"$f":"IF($D4=\"PR\",'Order Entry'!L5&\"-P\",'Order Entry'!L5)","v":0},{"$f":"'Order Entry'!M5","v":0},{"$f":"'Order Entry'!N5","v":0},{"$f":"'Order Entry'!O5","v":0},{"$f":"'Order Entry'!Q5","v":0},{"$f":"'Order Entry'!P5","v":0}]
[{"$f":"IF($D5=\"PR\",'Order Entry'!L6&\"-P\",'Order Entry'!L6)","v":0},{"$f":"'Order Entry'!M6","v":0},{"$f":"'Order Entry'!N6","v":0},{"$f":"'Order Entry'!O6","v":0},{"$f":"'Order Entry'!Q6","v":0},{"$f":"'Order Entry'!P6","v":0}]
[{"$f":"IF($D6=\"PR\",'Order Entry'!L7&\"-P\",'Order Entry'!L7)","v":0},{"$f":"'Order Entry'!M7","v":0},{"$f":"'Order Entry'!N7","v":0},{"$f":"'Order Entry'!O7","v":0},{"$f":"'Order Entry'!Q7","v":0},{"$f":"'Order Entry'!P7","v":0}]
[{"$f":"IF($D7=\"PR\",'Order Entry'!L8&\"-P\",'Order Entry'!L8)","v":0},{"$f":"'Order Entry'!M8","v":0},{"$f":"'Order Entry'!N8","v":0},{"$f":"'Order Entry'!O8","v":0},{"$f":"'Order Entry'!Q8","v":0},{"$f":"'Order Entry'!P8","v":0}]
[{"$f":"IF($D8=\"PR\",'Order Entry'!L9&\"-P\",'Order Entry'!L9)","v":0},{"$f":"'Order Entry'!M9","v":0},{"$f":"'Order Entry'!N9","v":0},{"$f":"'Order Entry'!O9","v":0},{"$f":"'Order Entry'!Q9","v":0},{"$f":"'Order Entry'!P9","v":0}]
[{"$f":"IF($D9=\"PR\",'Order Entry'!L10&\"-P\",'Order Entry'!L10)","v":0},{"$f":"'Order Entry'!M10","v":0},{"$f":"'Order Entry'!N10","v":0},{"$f":"'Order Entry'!O10","v":0},{"$f":"'Order Entry'!Q10","v":0},{"$f":"'Order Entry'!P10","v":0}]
[{"$f":"IF($D10=\"PR\",'Order Entry'!L11&\"-P\",'Order Entry'!L11)","v":0},{"$f":"'Order Entry'!M11","v":0},{"$f":"'Order Entry'!N11","v":0},{"$f":"'Order Entry'!O11","v":0},{"$f":"'Order Entry'!Q11","v":0},{"$f":"'Order Entry'!P11","v":0}]
[{"$f":"IF($D11=\"PR\",'Order Entry'!L12&\"-P\",'Order Entry'!L12)","v":0},{"$f":"'Order Entry'!M12","v":0},{"$f":"'Order Entry'!N12","v":0},{"$f":"'Order Entry'!O12","v":0},{"$f":"'Order Entry'!Q12","v":0},{"$f":"'Order Entry'!P12","v":0}]
[{"$f":"IF($D12=\"PR\",'Order Entry'!L13&\"-P\",'Order Entry'!L13)","v":0},{"$f":"'Order Entry'!M13","v":0},{"$f":"'Order Entry'!N13","v":0},{"$f":"'Order Entry'!O13","v":0},{"$f":"'Order Entry'!Q13","v":0},{"$f":"'Order Entry'!P13","v":0}]
[{"$f":"IF($D13=\"PR\",'Order Entry'!L14&\"-P\",'Order Entry'!L14)","v":0},{"$f":"'Order Entry'!M14","v":0},{"$f":"'Order Entry'!N14","v":0},{"$f":"'Order Entry'!O14","v":0},{"$f":"'Order Entry'!Q14","v":0},{"$f":"'Order Entry'!P14","v":0}]
[{"$f":"IF($D14=\"PR\",'Order Entry'!L15&\"-P\",'Order Entry'!L15)","v":0},{"$f":"'Order Entry'!M15","v":0},{"$f":"'Order Entry'!N15","v":0},{"$f":"'Order Entry'!O15","v":0},{"$f":"'Order Entry'!Q15","v":0},{"$f":"'Order Entry'!P15","v":0}]
[{"$f":"IF($D15=\"PR\",'Order Entry'!L16&\"-P\",'Order Entry'!L16)","v":0},{"$f":"'Order Entry'!M16","v":0},{"$f":"'Order Entry'!N16","v":0},{"$f":"'Order Entry'!O16","v":0},{"$f":"'Order Entry'!Q16","v":0},{"$f":"'Order Entry'!P16","v":0}]
[{"$f":"IF($D16=\"PR\",'Order Entry'!L17&\"-P\",'Order Entry'!L17)","v":0},{"$f":"'Order Entry'!M17","v":0},{"$f":"'Order Entry'!N17","v":0},{"$f":"'Order Entry'!O17","v":0},{"$f":"'Order Entry'!Q17","v":0},{"$f":"'Order Entry'!P17","v":0}]
[{"$f":"IF($D17=\"PR\",'Order Entry'!L18&\"-P\",'Order Entry'!L18)","v":0},{"$f":"'Order Entry'!M18","v":0},{"$f":"'Order Entry'!N18","v":0},{"$f":"'Order Entry'!O18","v":0},{"$f":"'Order Entry'!Q18","v":0},{"$f":"'Order Entry'!P18","v":0}]
[{"$f":"IF($D18=\"PR\",'Order Entry'!L19&\"-P\",'Order Entry'!L19)","v":0},{"$f":"'Order Entry'!M19","v":0},{"$f":"'Order Entry'!N19","v":0},{"$f":"'Order Entry'!O19","v":0},{"$f":"'Order Entry'!Q19","v":0},{"$f":"'Order Entry'!P19","v":0}]
[{"$f":"IF($D19=\"PR\",'Order Entry'!L20&\"-P\",'Order Entry'!L20)","v":0},{"$f":"'Order Entry'!M20","v":0},{"$f":"'Order Entry'!N20","v":0},{"$f":"'Order Entry'!O20","v":0},{"$f":"'Order Entry'!Q20","v":0},{"$f":"'Order Entry'!P20","v":0}]
[{"$f":"IF($D20=\"PR\",'Order Entry'!L21&\"-P\",'Order Entry'!L21)","v":0},{"$f":"'Order Entry'!M21","v":0},{"$f":"'Order Entry'!N21","v":0},{"$f":"'Order Entry'!O21","v":0},{"$f":"'Order Entry'!Q21","v":0},{"$f":"'Order Entry'!P21","v":0}]
[{"$f":"IF($D21=\"PR\",'Order Entry'!L22&\"-P\",'Order Entry'!L22)","v":0},{"$f":"'Order Entry'!M22","v":0},{"$f":"'Order Entry'!N22","v":0},{"$f":"'Order Entry'!O22","v":0},{"$f":"'Order Entry'!Q22","v":0},{"$f":"'Order Entry'!P22","v":0}]
[{"$f":"IF($D22=\"PR\",'Order Entry'!L23&\"-P\",'Order Entry'!L23)","v":0},{"$f":"'Order Entry'!M23","v":0},{"$f":"'Order Entry'!N23","v":0},{"$f":"'Order Entry'!O23","v":0},{"$f":"'Order Entry'!Q23","v":0},{"$f":"'Order Entry'!P23","v":0}]
[{"$f":"IF($D23=\"PR\",'Order Entry'!L24&\"-P\",'Order Entry'!L24)","v":0},{"$f":"'Order Entry'!M24","v":0},{"$f":"'Order Entry'!N24","v":0},{"$f":"'Order Entry'!O24","v":0},{"$f":"'Order Entry'!Q24","v":0},{"$f":"'Order Entry'!P24","v":0}]
[{"$f":"IF($D24=\"PR\",'Order Entry'!L25&\"-P\",'Order Entry'!L25)","v":0},{"$f":"'Order Entry'!M25","v":0},{"$f":"'Order Entry'!N25","v":0},{"$f":"'Order Entry'!O25","v":0},{"$f":"'Order Entry'!Q25","v":0},{"$f":"'Order Entry'!P25","v":0}]
[{"$f":"IF($D25=\"PR\",'Order Entry'!L26&\"-P\",'Order Entry'!L26)","v":0},{"$f":"'Order Entry'!M26","v":0},{"$f":"'Order Entry'!N26","v":0},{"$f":"'Order Entry'!O26","v":0},{"$f":"'Order Entry'!Q26","v":0},{"$f":"'Order Entry'!P26","v":0}]
[{"$f":"IF($D26=\"PR\",'Order Entry'!L27&\"-P\",'Order Entry'!L27)","v":0},{"$f":"'Order Entry'!M27","v":0},{"$f":"'Order Entry'!N27","v":0},{"$f":"'Order Entry'!O27","v":0},{"$f":"'Order Entry'!Q27","v":0},{"$f":"'Order Entry'!P27","v":0}]
[{"$f":"IF($D27=\"PR\",'Order Entry'!L28&\"-P\",'Order Entry'!L28)","v":0},{"$f":"'Order Entry'!M28","v":0},{"$f":"'Order Entry'!N28","v":0},{"$f":"'Order Entry'!O28","v":0},{"$f":"'Order Entry'!Q28","v":0},{"$f":"'Order Entry'!P28","v":0}]
[{"$f":"IF($D28=\"PR\",'Order Entry'!L29&\"-P\",'Order Entry'!L29)","v":0},{"$f":"'Order Entry'!M29","v":0},{"$f":"'Order Entry'!N29","v":0},{"$f":"'Order Entry'!O29","v":0},{"$f":"'Order Entry'!Q29","v":0},{"$f":"'Order Entry'!P29","v":0}]
[{"$f":"IF($D29=\"PR\",'Order Entry'!L30&\"-P\",'Order Entry'!L30)","v":0},{"$f":"'Order Entry'!M30","v":0},{"$f":"'Order Entry'!N30","v":0},{"$f":"'Order Entry'!O30","v":0},{"$f":"'Order Entry'!Q30","v":0},{"$f":"'Order Entry'!P30","v":0}]
[{"$f":"IF($D30=\"PR\",'Order Entry'!L31&\"-P\",'Order Entry'!L31)","v":0},{"$f":"'Order Entry'!M31","v":0},{"$f":"'Order Entry'!N31","v":0},{"$f":"'Order Entry'!O31","v":0},{"$f":"'Order Entry'!Q31","v":0},{"$f":"'Order Entry'!P31","v":0}]
[{"$f":"IF($D31=\"PR\",'Order Entry'!L32&\"-P\",'Order Entry'!L32)","v":0},{"$f":"'Order Entry'!M32","v":0},{"$f":"'Order Entry'!N32","v":0},{"$f":"'Order Entry'!O32","v":0},{"$f":"'Order Entry'!Q32","v":0},{"$f":"'Order Entry'!P32","v":0}]
[{"$f":"IF($D32=\"PR\",'Order Entry'!L33&\"-P\",'Order Entry'!L33)","v":0},{"$f":"'Order Entry'!M33","v":0},{"$f":"'Order Entry'!N33","v":0},{"$f":"'Order Entry'!O33","v":0},{"$f":"'Order Entry'!Q33","v":0},{"$f":"'Order Entry'!P33","v":0}]
[{"$f":"IF($D33=\"PR\",'Order Entry'!L34&\"-P\",'Order Entry'!L34)","v":0},{"$f":"'Order Entry'!M34","v":0},{"$f":"'Order Entry'!N34","v":0},{"$f":"'Order Entry'!O34","v":0},{"$f":"'Order Entry'!Q34","v":0},{"$f":"'Order Entry'!P34","v":0}]
[{"$f":"IF($D34=\"PR\",'Order Entry'!L35&\"-P\",'Order Entry'!L35)","v":0},{"$f":"'Order Entry'!M35","v":0},{"$f":"'Order Entry'!N35","v":0},{"$f":"'Order Entry'!O35","v":0},{"$f":"'Order Entry'!Q35","v":0},{"$f":"'Order Entry'!P35","v":0}]
[{"$f":"IF($D35=\"PR\",'Order Entry'!L36&\"-P\",'Order Entry'!L36)","v":0},{"$f":"'Order Entry'!M36","v":0},{"$f":"'Order Entry'!N36","v":0},{"$f":"'Order Entry'!O36","v":0},{"$f":"'Order Entry'!Q36","v":0},{"$f":"'Order Entry'!P36","v":0}]
[{"$f":"IF($D36=\"PR\",'Order Entry'!L37&\"-P\",'Order Entry'!L37)","v":0},{"$f":"'Order Entry'!M37","v":0},{"$f":"'Order Entry'!N37","v":0},{"$f":"'Order Entry'!O37","v":0},{"$f":"'Order Entry'!Q37","v":0},{"$f":"'Order Entry'!P37","v":0}]