{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"Sheet1","index":0,"n_rows":104,"n_cols":12,"rows_kept":104,"cut":false,"hidden":false,"merged":[[74,3,74,7],[38,3,38,7],[36,1,36,2],[47,0,47,2],[50,0,50,1],[103,0,103,7],[62,0,62,1],[51,0,51,2],[102,0,102,1],[101,0,101,1],[98,3,98,7],[99,3,99,7],[97,3,97,7],[97,0,97,2],[96,0,96,2],[96,3,96,7],[99,0,99,1],[102,3,102,7],[101,3,101,7],[100,3,100,7],[98,0,98,2],[100,0,100,1],[94,0,94,2],[55,0,55,2],[58,0,58,1],[7,3,7,7],[12,3,12,7],[5,1,5,2],[27,0,27,2],[35,1,35,2],[45,1,45,2],[37,3,37,7],[41,3,41,7],[50,3,50,7],[39,3,39,7],[39,0,39,2],[46,0,46,2],[47,3,47,7],[46,3,46,7],[44,1,44,2],[43,1,43,2],[42,1,42,2],[41,1,41,2],[37,0,37,2],[38,0,38,2],[42,3,42,7],[48,3,48,7],[48,0,48,1],[40,3,40,7],[6,1,6,2],[7,1,7,2],[5,0,7,0],[11,1,11,2],[10,1,10,2],[8,1,8,2],[15,0,15,1],[18,0,18,1],[12,1,12,2],[13,1,13,2],[9,1,9,2],[34,0,34,2],[28,0,28,2],[29,0,29,2],[20,0,21,0],[26,3,26,7],[25,0,25,2],[25,3,25,7],[32,0,32,2],[28,3,29,7],[33,0,33,2],[33,3,33,7],[26,1,26,2],[20,1,20,2],[21,1,21,2],[22,0,22,2],[27,3,27,7],[34,3,34,7],[32,3,32,7],[30,0,30,2],[31,0,31,2],[30,3,31,7],[51,3,51,7],[59,0,59,2],[68,3,68,7],[0,0,0,4],[9,5,9,7],[9,3,9,4],[10,3,10,4],[10,5,10,7],[22,3,22,7],[5,3,5,7],[6,3,6,7],[8,3,8,7],[13,3,13,7],[14,3,14,7],[15,3,15,7],[16,3,16,7],[11,3,11,7],[20,3,20,7],[17,3,17,7],[18,3,18,7],[19,3,19,7],[21,3,21,7],[2,0,2,2],[2,3,2,7],[93,0,93,2],[94,3,94,7],[93,3,93,7],[90,0,90,2],[89,0,89,2],[88,0,88,2],[90,3,90,7],[56,0,56,1],[68,0,68,1],[84,0,84,1],[85,0,85,1],[84,3,84,7],[85,3,85,7],[73,3,73,7],[72,3,72,7],[71,3,71,7],[70,3,70,7],[69,3,69,7],[67,0,67,2],[66,0,66,2],[60,0,60,1],[67,3,67,7],[66,3,66,7],[65,3,65,7],[95,0,95,2],[95,3,95,7],[40,0,40,1],[4,3,4,7],[3,3,3,7],[3,0,3,1],[4,0,4,1],[89,3,89,7],[88,3,88,7],[41,0,45,0],[45,3,45,7],[44,3,44,7],[43,3,43,7],[82,3,82,7],[81,3,81,7],[82,0,82,1],[81,0,81,1],[49,0,49,1],[49,3,49,7],[61,0,61,2],[57,0,57,2],[65,0,65,2],[72,0,74,1],[69,0,71,1]]}
["INSTRUCTIONS: All fields in YELLOW are required to ensure an accurate article setup.  Fields highlighted in light orange are BDL specific, fields in green are TBS specific. Entries can be completed by selecting from drop-down menus (where available) or manually entering the required data. Failure to complete required fields may delay listing in TBS and/or BDL.",null,null,null,null,null,null,"Revised: May 8, 2024"]
["BREWER INFORMATION",null,null,null,null,null,null,null,null,0,{"$f":"IF(J2=1,ISBLANK(D2))","v":false}]
["Are you new to TBS/BDL?",null,null,null,null,null,null,null,null,1,{"$f":"IF(J3=1,ISBLANK(D3))","v":true}]
["Are you a Contract Brewer?",null,"(TBS)",null,null,null,null,null,null,1,{"$f":"IF(J4=1,ISBLANK(D4))","v":true}]
["Who is the Manufacturing Brewer?",null,"(TBS)",null,null,null,null,null,null,1,{"$f":"IF(J5=1,ISBLANK(D5))","v":true}]
["Brewery Name:","Full Legal Name",null,null,null,null,null,null,null,1,{"$f":"IF(J6=1,ISBLANK(D6))","v":true}]
[null,"Operating As (if applicable)",null,null,null,null,null,null,null,0,false]
[null,"Authorized Agent  (if applicable)",null,null,null,null,null,null,null,0,false]
["Brewery Address:","Street Name",null,null,null,null,null,null,null,{"$f":"IF($D$3=\"YES\",1,0)","v":0},false]
[null,"Building/Unit Number",null,null,null,null,null,null,null,{"$f":"IF($D$3=\"YES\",1,0)","v":0},false]
[null,"City/Region (Prov/State)",null,null,null,null,null,null,null,{"$f":"IF($D$3=\"YES\",1,0)","v":0},{"$f":"IF(J11=1,NOT(AND(NOT(ISBLANK(D11)),NOT(ISBLANK(F11)))))","v":false}]
[null,"Country",null,null,null,null,null,null,null,{"$f":"IF($D$3=\"YES\",1,0)","v":0},false]
[null,"Postal Code",null,null,null,null,null,null,null,0,false]
[null,"PO Box",null,null,null,null,null,null,null,0,false]
["Brewer Contact for:","TBS/BDL Distribution:","Name",null,null,null,null,null,null,0,false]
[null,null,"Telephone",null,null,null,null,null,null,0,false]
[null,null,"Email",null,null,null,null,null,null,0,false]
[null,"TBS/BDL Finance:","Name",null,null,null,null,null,null,0,false]
[null,null,"Telephone",null,null,null,null,null,null,0,false]
[null,null,"Email",null,null,null,null,null,null,0,false]
["Recipient Emails","For Purchase Order",null,null,null,null,null,null,null,0,false]
[null,"For EFT Payment Remittance",null,null,null,null,null,null,null,0,false]
["Worldwide Production in HL's",null,null,null,null,null,null,null,null,0,false]
[null,null,null,null,null,null,null,null,null,0,false]
["BRAND INFORMATION",null,null,null,null,null,null,null,null,0,false]
["Is this Brand new to TBS/BDL?",null,null,null,null,null,null,null,null,1,{"$f":"IF(J26=1,ISBLANK(D26))","v":true}]
["Brand Name:","Short Name",null,null,null,null,null,null,{"$f":"IFERROR(LEN(D27),\"\")","v":0},1,{"$f":"IF(J27=1,ISBLANK(D27))","v":true}]
["Full Name *For B4B Channels",null,null,null,null,null,null,null,{"$f":"IFERROR(LEN(D28),\"\")","v":0},{"$f":"IF(D26=\"NO\",0,1)","v":1},true]
["Brand Description (required for New Brands only)",null,null,null,null,null,null,null,null,{"$f":"IF(OR(D26=\"YES\",D26=\"\"),1,0)","v":1},true]
["The description will appear on the TBS website at www.thebeerstore.ca)",null,null,null,null,null,null,null,null,0,false]
["Brand Assets (required for our digital channels)",null,null,null,null,null,null,null,null,0,false]
["Refer to our Brand Asset Guidelines for file requirements and specifications or contact ecommercesupport@thebeerstore.ca",null,null,null,null,null,null,null,null,0,{"$f":"IF(J32=1,ISBLANK(D32))","v":false}]
["Beverage Type",null,null,null,null,null,null,null,null,{"$f":"IF(OR(D26=\"YES\",D26=\"\"),1,0)","v":1},{"$f":"IF(J33=1,ISBLANK(D33))","v":true}]
["Alcohol Content percentage (ABV)",null,null,null,null,null,null,null,null,{"$f":"IF(OR(D26=\"YES\",D26=\"\"),1,0)","v":1},true]
["Beer Type ",null,null,null,null,null,null,null,null,{"$f":"IF(OR(D26=\"YES\",D26=\"\"),1,0)","v":1},true]
["Beer Style","(select up to 3 styles)",null,null,null,null,null,null,null,0,false]
["Beer Attribute","(select up to 3 attributes)",null,null,null,null,null,null,null,0,false]
["Container Type",null,null,null,null,null,null,null,null,1,true]
["What type of Coupler is Required? (if Keg)",null,null,null,null,null,null,null,null,{"$f":"IF(D38=\"KEG\",1,0)","v":0},false]
["Container Material",null,null,null,null,null,null,null,null,1,true]
["Do you want the empty container returned to you?",null,"(TBS)",null,null,null,null,null,null,1,true]
["Date Code/Shelf Life:","Shelf Life - Retail (days)",null,null,null,null,null,null,null,1,true]
[null,"Shelf Life - DC's (days)",null,null,null,null,null,null,null,1,true]
[null,"Format (Best Before or Production)",null,null,null,null,null,null,null,1,true]
[null,"Actual Date Code Sample",null,null,null,null,null,null,null,1,true]
[null,"Explanation of the Date Code",null,null,null,null,null,null,null,1,true]
["UPC or EAN Code (Include All Digits, No spaces or dashes)",null,null,null,null,null,null,null,null,1,true]
["SCC (Mother Carton or Tray Code)",null,null,null,null,null,null,null,null,0,false]
["Permanent/Seasonal Rotational/Seasonal",null,"(TBS)",null,null,null,null,null,null,{"$f":"IF(H56=\"Y\",1,0)","v":0},false]
[{"$f":"IF(D49=\"Seasonal Rotational\",\"Which product is being replaced?\",\"\")","v":""},null,"(TBS)",null,null,null,null,null,null,{"$f":"IF(H56<>\"y\",0, IF(D49=\"Seasonal Rotational\",1,0))","v":0},{"$f":"IF(J50=1,ISBLANK(D50))","v":false}]
[{"$f":"IF(D49=\"Seasonal Promotional\",\"6 Month Seasonal Promotional End Date:\",\"\")","v":""},null,"(TBS)",{"$f":"IF(AND(J51=1,H58=\"\"),\"Please fill out the Ontario Launch Date Below\",IF(AND(J51=1,H58<>\"\"),H58+180,\"\"))","v":""},null,null,null,null,null,{"$f":"IF(AND(H56=\"Y\",D49=\"Seasonal Promotional\"),1,0)","v":0},{"$f":"IF(L51>0,TRUE,FALSE)","v":false},{"$f":"IF(AND(H56=\"Y\",H58=\"\",D49=\"Seasonal Promotional\",D51=\"Please fill out the Ontario Launch Date Below\"),1,0)","v":0}]
["Season (if applicable)",null,null,null,null,null,null,null,null,0,false]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(J53=1,ISBLANK(D53))","v":false}]
["ADDITIONAL BRAND INFORMATION",null,null,null,null,null,null,null,null,0,false]
[null,null,null,"BC","AB","SK","MB","ON (TBS)",null,0,false]
["Will Be Available To:",null,null,null,null,null,null,null,null,1,{"$f":"IF(COUNTA($D$56:$H$56)=0,TRUE,FALSE)","v":true}]
["First Ship to BDL Sites:",null,"(BDL)",null,null,null,null,null,null,{"$f":"IF(COUNTA(D55:H55)=0,0,1)","v":1},{"$f":"IF(L57>0,TRUE,FALSE)","v":false},{"$f":"IF(J57=1,SUM(IF(($D$56:$H$56=\"Y\")=(D57:H57<>\"\"),0,1)),0)","v":0}]
["Launch Date (BDL) | Effective Date (TBS):",null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(D56:H56)=0,0,1)","v":0},{"$f":"IF(L58>0,TRUE,FALSE)","v":false},{"$f":"IF(J58=1,SUM(IF(($D$56:$H$56=\"Y\")=(D58:H58<>\"\"),0,1)),0)","v":0}]
["Sold As (Singles, Pack, Case)",null,"(BDL)",null,null,null,null,null,null,{"$f":"IF(COUNTA(D56:G56)=0,0,1)","v":0},{"$f":"IF(L59>0,TRUE,FALSE)","v":false},{"$f":"IF(J59=1,SUM(IF(($D$56:$G$56=\"Y\")=(D59:G59<>\"\"),0,1)),0)","v":0}]
["Is the container refillable?",null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(D56:H56)=0,0,1)","v":0},{"$f":"IF(L60>0,TRUE,FALSE)","v":false},{"$f":"IF(J60=1,SUM(IF(($D$56:$H$56=\"Y\")=(D60:H60<>\"\"),0,1)),0)","v":0}]
["Promo: Hard, Soft, Parallel",null,"(BDL)",null,null,null,null,null,null,0,{"$f":"IF(J61=1,ISBLANK(D61))","v":false}]
["CSPC/LCBO Code:",null,null,null,null,null,null,null,null,0,false]
["Hold/Bypass Removal",null,"(BDL)",null,null,null,null,null,null,0,{"$f":"IF(J63=1,ISBLANK(D63))","v":false}]
[null,null,null,null,null,null,null,null,null,0,false]
["PACKAGING INFORMATION (Full Goods)",null,null,null,null,null,null,null,null,0,false]
["Selling packs per Mother Carton/Tray",null,null,null,null,null,null,null,null,1,{"$f":"IF(J66=1,ISBLANK(D66))","v":true}]
["Units per selling pack",null,null,null,null,null,null,null,null,1,true]
["Unit volume (ml)",null,null,null,null,null,null,null,null,1,true]
["Additional Price Points (Non-Shippable Sizes)",null,"(TBS)",null,null,null,null,null,null,0,false]
["Selling Pack Dimensions (mm)",null,"Height",null,null,null,null,null,null,1,true]
[null,null,"Width",null,null,null,null,null,null,1,true]
[null,null,"Length",null,null,null,null,null,null,1,true]
["Mother Carton/Tray Dimensions (mm)",null,"Height",null,null,null,null,null,null,{"$f":"IF($D$66>1,1,0)","v":0},false]
[null,null,"Width",null,null,null,null,null,null,{"$f":"IF($D$66>1,1,0)","v":0},false]
[null,null,"Length",null,null,null,null,null,null,0,false]
["Layer Dimensions (LH): Height (mm)",null,null,null,null,null,null,null,null,null,false]
["Layer Dimensions (LW): Width (mm)",null,null,null,null,null,null,null,null,null,false]
["Layer Dimensions (LL): Length (mm)",null,null,null,null,null,null,null,null,null,false]
["Pallet Dimensions: Height (mm); excluding wood pallet",null,null,null,null,null,null,null,null,null,false]
["Pallet Dimensions: Width (mm); excluding wood pallet",null,null,null,null,null,null,null,null,null,false]
["Pallet Dimensions: Length (mm); excluding wood pallet",null,null,null,null,null,null,null,null,null,false]
["Selling Pack Full Weight",null,"(kg)",null,null,null,null,null,null,1,true]
["Mother Carton (Shipping Case/Tray Full Weight)",null,"(kg)",null,null,null,null,null,null,{"$f":"IF($D$66>1,1,0)","v":0},false]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(J84=1,ISBLANK(D84))","v":false}]
["Minimum Order Quantity (PAC)",null,"(TBS)"]
["Multiple Order Quantity",null,"(TBS)"]
[null,null,null,null,null,null,null,null,null,0,false]
["PALLET CONFIGURATION",null,null,null,null,null,null,null,null,0,false]
["Selling Packs per Tier",null,null,null,null,null,null,null,null,1,{"$f":"IF(J89=1,ISBLANK(D89))","v":true}]
["Mother Carton (Shipping Case/Tray per Tier)",null,null,null,null,null,null,null,null,1,true]
["Tiers per Pallet",null,null,null,null,null,null,null,null,1,true]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(J92=1,ISBLANK(D92))","v":false}]
["TBS - PRODUCT AVAILABILITY",null,null,null,null,null,null,null,null,0,false]
["TBS Retail Stores",null,null,null,null,null,null,null,null,{"$f":"IF(H56=\"y\",1,0)","v":0},{"$f":"IF(J94=1,ISBLANK(D94))","v":false}]
["TBS Distribution Centers",null,null,null,null,null,null,null,null,{"$f":"IF(H56=\"y\",1,0)","v":0},false]
["Home Consumers",null,null,null,null,null,null,null,null,{"$f":"IF(H56=\"y\",1,0)","v":0},{"$f":"IF(J96=1,ISBLANK(D96))","v":false}]
["Beer Store will deliver to the following locations:",null,null,"(TBS does not supply LCBOs or Agencies with imports or kegs)",null,null,null,null,null,0,false]
["Licensees/Restaurants",null,null,null,null,null,null,null,null,{"$f":"IF(H56=\"y\",1,0)","v":0},{"$f":"IF(J98=1,ISBLANK(D98))","v":false}]
["Retail Partners",null,null,null,null,null,null,null,null,{"$f":"IF(H56=\"y\",1,0)","v":0},false]
["Northern Agencies",null,"(CSPC req'd)",null,null,null,null,null,null,{"$f":"IF(H56=\"y\",1,0)","v":0},false]
["LCBO 6 Pack Stores (w/LCBO Authorization)",null,"(CSPC req'd)",null,null,null,null,null,null,{"$f":"IF(H56=\"y\",1,0)","v":0},false]
["LCBO Combo",null,"(CSPC req'd)",null,null,null,null,null,null,{"$f":"IF(H56=\"y\",1,0)","v":0},false]
["Grocery",null,"(CSPC req'd)",null,null,null,null,null,null,{"$f":"IF(H56=\"y\",1,0)","v":0},false]
["**All BDL and TBS submissions must include this form completed in full and submitted along with all other submission requirements a minimum of three weeks prior to launch date. (Monday to Monday for TBS).",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(K2:K103,\"True\")","v":31}]