{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Calculator","Wholesale Details","Calculations","Freight","Duty","Excise","National Markup","Small Producer Markup","COS","Enviro & Container","List"],"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":"Calculator","index":0,"n_rows":59,"n_cols":14,"rows_kept":59,"cut":false,"hidden":false,"merged":[[31,11,31,14],[5,6,5,9],[5,11,5,14],[1,1,1,14],[5,1,5,4],[3,1,3,14]]}
[]
[null,"SLGA Pricing Calculator Worksheet   Effective October 1, 2026"]
[]
[null,"Instructions: Please complete the product information section to produce the wholesale base price and review product details to ensure correctness of wholesale base price.  If necessary use the \"Target Wholesale Price\" section to work backwards from WBP to vendor quote. [All fields under the product information section must be complete for this to work]"]
[]
[null,"PRODUCT INFORMATION",null,null,null,null,"PRODUCT REVIEW",null,null,null,null,"WHOLESALE PRICE - SELLING UNIT"]
[]
[null,null,"1. Product Category",null,null,null,null,"Category:",{"$f":"'Wholesale Details'!D3","v":0},null,null,null,"Quote:",{"$f":"'Wholesale Details'!I4","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"2. Product Sub-Category",null,null,null,null,"Sub-Category:",{"$f":"IF('Wholesale Details'!D4=0,\"None\",'Wholesale Details'!D4)","v":"None"},null,null,null,"Freight:",{"$f":"'Wholesale Details'!I5","v":0}]
[]
[null,null,"3. Product Base",null,null,null,null,"Base:",{"$f":"IF('Wholesale Details'!D5=0,\"None\",'Wholesale Details'!D5)","v":"None"},null,null,null,"Duty:",{"$f":"'Wholesale Details'!I6","v":0}]
[]
[null,null,"4. Alcohol Content (ABV)",null,null,null,null,"ABV:",{"$f":"'Wholesale Details'!D6","v":0},null,null,null,"Excise:",{"$f":"'Wholesale Details'!I7","v":{"$error":"#N/A"}}]
[]
[null,null,"5. Container Type",null,null,null,null,"Container Type:",{"$f":"'Wholesale Details'!D7","v":0},null,null,null,"Tariff",{"$f":"'Wholesale Details'!I8","v":""}]
[]
[null,null,"6. Selling Units per Case",null,null,null,null,"Selling Units Per Case:",{"$f":"'Wholesale Details'!D8","v":0},null,null,null,"Landed Cost:",{"$f":"'Wholesale Details'!I9","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"7. Selling Unit Volume (L)",null,null,null,null,"Containers per Selling Unit:",{"$f":"'Wholesale Details'!D9","v":0},null,null,null,"Mark-up:",{"$f":"'Wholesale Details'!I10","v":0}]
[null,null,null,1]
[null,null,"8. Containers per selling Unit",null,null,null,null,"Container Volume:",{"$f":"'Wholesale Details'!D10","v":{"$error":"#DIV/0!"}},null,null,null,"Cost of Service:",{"$f":"'Wholesale Details'!I11","v":0}]
[]
[null,null,"9A. Seasonal Gift Pack?","No",null,null,null,"Selling Unit:",null,null,null,null,"Environmental Surcharge:",{"$f":"'Wholesale Details'!I13","v":0}]
[]
[null,null,"9B. Cost of Gift Packaging",null,null,null,null,"Volume:",{"$f":"'Wholesale Details'!D12","v":0},null,null,null,"Wholesale Base Price:",{"$f":"'Wholesale Details'!I14","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"10. Vendor Quote per Case",null,null,null,null,"Vendor Quote:",{"$f":"'Wholesale Details'!D13","v":{"$error":"#DIV/0!"}},null,null,null,"GST:",{"$f":"'Wholesale Details'!I15","v":{"$error":"#DIV/0!"}}]
[null,null,null,10.9]
[null,null,"11. Tariff Applied?",null,null,null,null,"Cost of Gift Packaging:",{"$f":"'Wholesale Details'!D14","v":{"$error":"#DIV/0!"}},null,null,null,"Refundable Deposit:",{"$f":"'Wholesale Details'!I17","v":0}]
[]
[null,null,"12. Origin",null,null,null,null,"Total Vendor Quote:",{"$f":"'Wholesale Details'!D15","v":{"$error":"#DIV/0!"}},null,null,"TARGET WHOLESALE PRICE"]
[]
[null,null,"13. Sourced from - Country",null,null,null,null,"Case:",null,null,null,null,"1. Data Tab -> What-if Analysis"]
[]
[null,null,"14. Sourced from - Location",null,null,null,null,"Volume:",{"$f":"'Wholesale Details'!D17","v":0},null,null,null,"2.  Goal Seek.."]
[]
[null,null,"15. Duty Status",null,null,null,null,"Vendor Quote:",{"$f":"'Wholesale Details'!D18","v":0},null,null,null,"3. Type the below values in:"]
[]
[null,null,"17. Does a Trade Agreement Apply?",null,null,null,null,"Cost of Gift Packaging:",{"$f":"'Wholesale Details'!D19","v":0}]
[]
[null,null,"18. Distributor",null,null,null,null,"Total Vendor Quote:",{"$f":"'Wholesale Details'!D20","v":0}]
[]
[null,null,"19. Production level [REQUIRED]",">200,000 L - National Producer",null,null,null,"Origin:",{"$f":"'Wholesale Details'!D21","v":0}]
[]
[null,null,null,null,null,null,null,"Sourced from - Country:",{"$f":"'Wholesale Details'!D22","v":0}]
[]
[null,null,null,null,null,null,null,"Sourced from - Location:",{"$f":"'Wholesale Details'!D23","v":0}]
[]
[null,null,null,null,null,null,null,"Duty Status:",{"$f":"'Wholesale Details'!D24","v":0}]
[]
[null,null,null,null,null,null,null,"Trade Agreement:",{"$f":"'Wholesale Details'!D25","v":0},null,null,null,"The result will indicate one of multiple Vendor "]
[]
[null,null,null,null,null,null,null,"Distributor:",{"$f":"'Wholesale Details'!D26","v":0},null,null,null,"Quotes that will accomplish the same WBP, and"]
[]
[null,null,null,null,null,null,null,"Production level:",{"$f":"'Wholesale Details'!D27","v":">200,000 L - National Producer"},null,null,null,"should be used only as a guide. "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Example: In one scenario, a Vendor Quote ranging"]
[null,null,null,null,null,null,null,null,null,null,null,null,"from $53.55 to $53.67 will all achieve a WBP of $6."]

{"sheet":"Wholesale Details","index":1,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":true,"merged":[[18,6,18,9],[2,6,2,9],[1,1,1,4],[1,6,1,9]]}
[]
[null,"INPUT INFORMATION",null,null,null,null,"OUTPUT INFORMATION"]
[null,null,"Category:",{"$f":"Calculator!D8","v":0},null,null,"SELLING UNIT"]
[null,null,"Sub-Category:",{"$f":"Calculator!D10","v":0},null,null,null,"Content Quote:",{"$f":"D15","v":{"$error":"#DIV/0!"}}]
[null,null,"Base:",{"$f":"Calculator!D12","v":0},null,null,null,"Freight:",{"$f":"Calculations!D10","v":0}]
[null,null,"ABV:",{"$f":"Calculator!D14","v":0},null,null,null,"Duty:",{"$f":"Calculations!I20","v":0}]
[null,null,"Container Type:",{"$f":"Calculator!D16","v":0},null,null,null,"Excise:",{"$f":"Calculations!N18","v":{"$error":"#N/A"}}]
[null,null,"Selling Units per Case:",{"$f":"Calculator!D18","v":0},null,null,null,"Tariff",{"$f":"IF(Calculator!D30=\"yes\",Calculator!N8*50%,\"\")","v":""}]
[null,null,"Containers per Selling Unit:",{"$f":"Calculator!D22","v":0},null,null,null,"Landed Cost:",{"$f":"SUM(I4:I8)","v":{"$error":"#DIV/0!"}}]
[null,null,"Container Volume:",{"$f":"D12/D9","v":{"$error":"#DIV/0!"}},null,null,null,"Mark-up:",{"$f":"Calculations!S18","v":0}]
[null,null,"Selling Unit:",null,null,null,null,"Cost of Service:",{"$f":"Calculations!X12","v":0}]
[null,null,"Volume:",{"$f":"Calculator!D20","v":0},null,null,null,"List Price:",{"$f":"ROUNDUP(SUM(I9:I11),2)","v":{"$error":"#DIV/0!"}}]
[null,null,"Content Quote:",{"$f":"D18/D8","v":{"$error":"#DIV/0!"}},null,null,null,"Environmental Surcharge:",{"$f":"Calculations!D25","v":0}]
[null,null,"Package Quote:",{"$f":"D19/D8","v":{"$error":"#DIV/0!"}},null,null,null,"Wholesale Base Price:",{"$f":"SUM(I12:I13)","v":{"$error":"#DIV/0!"}}]
[null,null,"Vendor Quote:",{"$f":"D20/D8","v":{"$error":"#DIV/0!"}},null,null,null,"GST:",{"$f":"Calculations!S26","v":{"$error":"#DIV/0!"}}]
[null,null,"Case:",null,null,null,null,"LCT:",{"$f":"Calculations!X22","v":{"$error":"#DIV/0!"}}]
[null,null,"Volume:",{"$f":"D12*D8","v":0},null,null,null,"Refundable Container Deposit:",{"$f":"Calculations!D28","v":0}]
[null,null,"Content Quote:",{"$f":"Calculator!D28","v":0},null,null,null,"Total Wholesale Price:",{"$f":"SUM(I14:I17)","v":{"$error":"#DIV/0!"}}]
[null,null,"Package Quote:",{"$f":"Calculator!D26","v":0},null,null,"CASE"]
[null,null,"Vendor Quote:",{"$f":"D18+D19","v":0},null,null,null,"Content Quote:",{"$f":"D20","v":0}]
[null,null,"Origin:",{"$f":"Calculator!D32","v":0},null,null,null,"Freight:",{"$f":"I5*D8","v":0}]
[null,null,"Sourced From:",{"$f":"Calculator!D34","v":0},null,null,null,"Duty:",{"$f":"I6*D8","v":0}]
[null,null,"Region",{"$f":"Calculator!D36","v":0},null,null,null,"Excise:",{"$f":"I7*D8","v":{"$error":"#N/A"}}]
[null,null,"Duty Status:",{"$f":"Calculator!D38","v":0},null,null,null,"Landed Cost:",{"$f":"SUM(I20:I23)","v":{"$error":"#N/A"}}]
[null,null,"Trade Agreement:",{"$f":"Calculator!D40","v":0},null,null,null,"Mark-up:",{"$f":"I10*D8","v":0}]
[null,null,"Distributor",{"$f":"Calculator!D42","v":0},null,null,null,"Cost of Service:",{"$f":"Calculations!X14","v":0}]
[null,null,"Previous Calendar Year Production:",{"$f":"Calculator!D44","v":">200,000 L - National Producer"},null,null,null,"List Price:",{"$f":"ROUNDUP(SUM(I24:I26),2)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,"Environmental Surcharge:",{"$f":"Calculations!D26","v":0}]
[null,null,null,null,null,null,null,"Wholesale Base Price:",{"$f":"SUM(I27:I28)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,"GST:",{"$f":"I15*D8","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"LCT:",{"$f":"I16*D8","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"Refundable Container Deposit:",{"$f":"Calculations!D29","v":0}]
[null,null,null,null,null,null,null,"Total Wholesale Price:",{"$f":"SUM(I29:I32)","v":{"$error":"#N/A"}}]

{"sheet":"Calculations","index":2,"n_rows":29,"n_cols":24,"rows_kept":29,"cut":false,"hidden":true,"merged":[[20,16,20,19],[16,21,16,24],[1,11,1,14],[1,1,1,4],[1,6,1,9],[1,16,1,19],[1,21,1,24],[12,1,12,4]]}
[]
[null,"FREIGHT",null,null,null,null,"DUTY",null,null,null,null,"Excise",null,null,null,null,"Mark-up",null,null,null,null,"Cost of Service"]
[null,null,"Region:",{"$f":"'Wholesale Details'!D23","v":0},null,null,null,"Category:",{"$f":"'Wholesale Details'!D3","v":0},null,null,null,"Category:",{"$f":"'Wholesale Details'!D3","v":0},null,null,null,"Category:",{"$f":"'Wholesale Details'!D3","v":0},null,null,null,"Category:"]
[null,null,"Distributor:",{"$f":"'Wholesale Details'!D26","v":0},null,null,null,"Sub-Category:",{"$f":"'Wholesale Details'!D4","v":0},null,null,null,"Sub-Category:",{"$f":"'Wholesale Details'!D4","v":0},null,null,null,"ABV:",{"$f":"'Wholesale Details'!D6","v":0},null,null,null,"Distributor:",{"$f":"'Wholesale Details'!D26","v":0}]
[null,null,"Freight Applied?",{"$f":"IF(D4=\"SLGA\",\"Yes\",\"No\")","v":"No"},null,null,null,"Base:",{"$f":"'Wholesale Details'!D5","v":0},null,null,null,"Base:",{"$f":"'Wholesale Details'!D5","v":0},null,null,null,"Previous Calendar Year Production:",{"$f":"'Wholesale Details'!D27","v":">200,000 L - National Producer"},null,null,null,"Origin:"]
[null,null,"Volume:",null,null,null,null,"ABV:",{"$f":"'Wholesale Details'!D6","v":0},null,null,null,"ABV:",{"$f":"'Wholesale Details'!D6","v":0},null,null,null,"National Producer?",{"$f":"IF(S5=List!Y8,\"Yes\",IF(S5=List!Y23,\"Yes\",\"No\"))","v":"Yes"},null,null,null,"Sourced From:",{"$f":"'Wholesale Details'!D22","v":0}]
[null,null,"Selling Unit:",{"$f":"'Wholesale Details'!D12","v":0},null,null,null,"Origin:",{"$f":"'Wholesale Details'!D21","v":0},null,null,null,"Duty Status:",{"$f":"'Wholesale Details'!D24","v":0},null,null,null,"Small Producer Markup",{"$f":"'Small Producer Markup'!L3","v":0},null,null,null,"Selling Units Per Case:",{"$f":"'Wholesale Details'!D8","v":0}]
[null,null,"Rate per Litre:",{"$f":"IF(D5=\"yes\",Freight!G4,0)","v":0},null,null,null,"Sourced From:",{"$f":"'Wholesale Details'!D22","v":0},null,null,null,"Distributor:",{"$f":"'Wholesale Details'!D26","v":0},null,null,null,"Small Producer UoM",{"$f":"'Small Producer Markup'!M3","v":{"$error":"#N/A"}},null,null,null,"COS applied?"]
[null,null,"Freight:",null,null,null,null,"Duty Status:",{"$f":"'Wholesale Details'!D24","v":0},null,null,null,"Volume:",null,null,null,null,"Landed Cost:"]
[null,null,"Selling Unit:",{"$f":"D8*D7","v":0},null,null,null,"Trade Agreement:",{"$f":"'Wholesale Details'!D25","v":0},null,null,null,"Selling Unit:",{"$f":"'Wholesale Details'!D12","v":0},null,null,null,"Selling Unit:",{"$f":"'Wholesale Details'!I9","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"Volume:",null,null,null,null,"Excise Applied?",{"$f":"IF(N8=\"SLGA\",IF(N7=\"duty paid\",\"No\",\"Yes\"),\"No\")","v":"No"},null,null,null,"Package Quote:"]
[null,null,null,null,null,null,null,"Selling Unit:",{"$f":"'Wholesale Details'!D12","v":0},null,null,null,"Litres of Pure Alcohol:",null,null,null,null,"Selling Unit:",{"$f":"'Wholesale Details'!D14","v":{"$error":"#DIV/0!"}},null,null,null,"COS:",{"$f":"COS!H3*'Wholesale Details'!D12","v":0}]
[null,"Environmental/Container",null,null,null,null,null,"Duty Applied?",{"$f":"IF(I9=\"Duty Paid\",\"No\",IF(I7=\"Domestic\",\"No\",IF(I10=\"yes\",\"No\",IF(I8=\"Canada\",\"No\",\"yes\"))))","v":"yes"},null,null,null,"Selling Unit:",{"$f":"N6*N10","v":0},null,null,null,"Landed Cost - Less Package Quote:"]
[null,null,"Container Type:",{"$f":"'Wholesale Details'!D7","v":0},null,null,null,"Litres of Pure Alcohol:",null,null,null,null,"Rate:",null,null,null,null,"Selling Unit:",{"$f":"S10-S12","v":{"$error":"#DIV/0!"}}]
[null,null,"Selling Units Per Case:",{"$f":"'Wholesale Details'!D8","v":0},null,null,null,"Selling Unit:",{"$f":"I6*I12","v":0},null,null,null,"Excise Rate:",{"$f":"Excise!V3","v":0},null,null,null,"Volume:"]
[null,null,"Containers per Selling Unit:",{"$f":"'Wholesale Details'!D9","v":0},null,null,null,"Rate:",null,null,null,null,"UoM:",{"$f":"Excise!W3","v":{"$error":"#N/A"}},null,null,null,"Selling Unit:",{"$f":"'Wholesale Details'!D12","v":0}]
[null,null,"Container Volume:",{"$f":"'Wholesale Details'!D10","v":{"$error":"#DIV/0!"}},null,null,null,"Duty Rate:",{"$f":"Duty!V3","v":0},null,null,null,"Excise:",null,null,null,null,"Markup:",null,null,null,"LCT"]
[null,null,"Volume:",null,null,null,null,"UoM:",{"$f":"Duty!W3","v":0},null,null,null,"Selling Unit:",{"$f":"IF(AND(N11=\"yes\",N16=\"LTR\"),N10*N15,IF(AND(N11=\"yes\",N16=\"LPA\"),N13*N15,0))","v":{"$error":"#N/A"}},null,null,null,"Selling Unit:",{"$f":"IF(S6=\"Yes\",'National Markup'!Q4,IF(S8=\"%\",S7*S10,IF(S8=\"/LTR\",S7*S16,\"Error\")))","v":0},null,null,null,"LCT Rate:",0]
[null,null,"Selling Unit:",{"$f":"'Wholesale Details'!D12","v":0},null,null,null,"Duty:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Base Price:"]
[null,null,"Case:",{"$f":"'Wholesale Details'!D17","v":0},null,null,null,"Selling Unit:",{"$f":"IF(AND(I13=\"yes\",I18=\"LTR\"),I12*I17,IF(AND(I13=\"yes\",I18=\"LPA\"),I15*I17,0))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Selling Unit:",{"$f":"'Wholesale Details'!I14","v":{"$error":"#DIV/0!"}}]
[null,null,"Rate:",null,null,null,null,null,null,null,null,null,null,null,null,null,"GST",null,null,null,null,null,"LCT:"]
[null,null,"Environmental:",{"$f":"'Enviro & Container'!L3","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"GST Rate:",0.05,null,null,null,"Selling Unit:",{"$f":"X20*X18","v":{"$error":"#DIV/0!"}}]
[null,null,"Container:",{"$f":"'Enviro & Container'!M3","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Base Price:"]
[null,null,"Environmental:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Selling Unit:",{"$f":"'Wholesale Details'!I14","v":{"$error":"#DIV/0!"}}]
[null,null,"Selling Unit:",{"$f":"D22*D16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"GST:"]
[null,null,"Case:",{"$f":"D25*D15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Selling Unit:",{"$f":"S22*S24","v":{"$error":"#DIV/0!"}}]
[null,null,"Container:"]
[null,null,"Selling Unit:",{"$f":"D23*D16","v":0}]
[null,null,"Case:",{"$f":"D28*D15","v":0}]

{"sheet":"Freight","index":3,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,"Freight"]
[null,"Region","Region Rule","Rate per Litre",null,"Region","Freight Rate per Litre"]
[null,"Alberta - Calgary",{"$f":"IF(B4=$F$4,1,0)","v":0},0.13,null,{"$f":"Calculations!D3","v":0},{"$f":"SUMIFS(D4:D42,C4:C42,1)","v":0}]
[null,"Alberta - Lethbridge",{"$f":"IF(B5=$F$4,1,0)","v":0},0.37]
[null,"Alberta - St. Albert",0,0.18]
[null,"British Columbia - Kelowna",0,0.31]
[null,"British Columbia - Oliver",0,0.28999999999999998]
[null,"British Columbia - Vancouver & Area ",0,0.25]
[null,"Manitoba - Winnipeg",0,0.5]
[null,"Ontario - Brampton",0,0.59]
[null,"Ontario - Toronto & Area",0,0.49]
[null,"Ontario - Walkerville",0,0.45]
[null,"Quebec - Montreal/Valleyfield",0,0.42]
[null,"Saskatchewan - Blaine Lake",{"$f":"IF(B15=$F$4,1,0)","v":0},0.3]
[null,"Saskatchewan - Regina",0,0]
[null,"Arkansas - Fort Smith",0,0.65]
[null,"California - Modesto",0,0.63]
[null,"California - Other",0,0.85]
[null,"Illinoism - Bolingbrook",0,0.56000000000000005]
[null,"Indiana - Lawrenceburg",0,0.44]
[null,"Kentucky - Clermont",0,0.79]
[null,"Kentucky - Frankfort/Lawrenceburg",0,0.87]
[null,"Kentucky - Louisville",0,0.83]
[null,"Minnesota - Minneapolis",0,0.39]
[null,"New York - Batavia",0,0.81]
[null,"New York - Canandaigua",0,1.57]
[null,"New York - Westfield",0,1.18]
[null,"Argentina",0]
[null,"Australia",0,0.91]
[null,"Belgium",0,1.78]
[null,"Chile",0,1.25]
[null,"Denmark",0,1.78]
[null,"France",0,2.5]
[null,"Germany",0,1.78]
[null,"Ireland",0,2.2200000000000002]
[null,"Italy",0,1.2]
[null,"Netherlands",0,1.78]
[null,"South Africa",0,1.03]
[null,"Spain",0,1.68]
[null,"United Kingdom (Scottish Port)",0,1.39]
[null,"United Kingdom (UK Port)",0,1.75]

{"sheet":"Duty","index":4,"n_rows":60,"n_cols":23,"rows_kept":60,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Category","Category Rule","Sub-Category","Sub-Category Rule","Base","Base Rule","Volume Low","Volume High","Volume Rule","ABV Low","ABV High","ABV Rule","Duty Rate","UoM",null,"Category","Sub-Category","Base","Volume","ABV","Duty Rate","UoM"]
[null,"Beer",{"$f":"IF($Q$3=B3,1,0)","v":0},0,{"$f":"IF($R$3=D3,1,0)","v":1},0,{"$f":"IF($S$3=F3,1,0)","v":1},0,9.9999999999999997E+98,{"$f":"IF(AND($T$3>H3,$T$3<=I3),1,0)","v":0},0,1,{"$f":"IF(AND($U$3>K3,$U$3<=L3),1,0)","v":0},0,0,null,{"$f":"Calculations!I3","v":0},{"$f":"Calculations!I4","v":0},{"$f":"Calculations!I5","v":0},{"$f":"Calculations!I12","v":0},{"$f":"Calculations!I6","v":0},{"$f":"SUMIFS(N3:N60,C3:C60,1,E3:E60,1,G3:G60,1,J3:J60,1,M3:M60,1)","v":0},{"$f":"VLOOKUP(V3,N3:O59,2,FALSE)","v":0}]
[null,"Wine",0,"Table Wine",{"$f":"IF($R$3=D4,1,0)","v":0},0,{"$f":"IF($S$3=F4,1,0)","v":1},0,2,{"$f":"IF(AND($T$3>H4,$T$3<=I4),1,0)","v":0},0,0.13700000000000001,{"$f":"IF(AND($U$3>K4,$U$3<=L4),1,0)","v":0},1.8700000000000001E-2,"LTR"]
[null,"Wine",0,"Table Wine",0,0,1,0,2,0,0.13700000000000001,0.14899999999999999,{"$f":"IF(AND($U$3>K5,$U$3<=L5),1,0)","v":0},4.6800000000000001E-2,"LTR"]
[null,"Wine",0,"Table Wine",0,0,1,0,2,0,0.14899999999999999,0.22900000000000001,{"$f":"IF(AND($U$3>K6,$U$3<=L6),1,0)","v":0},0,0]
[null,"Wine",0,"Table Wine",0,0,1,0,2,0,0.22900000000000001,1,0,0,0]
[null,"Wine",0,"Table Wine",0,0,1,2,9.9999999999999997E+98,0,0,0.22900000000000001,{"$f":"IF(AND($U$3>K8,$U$3<=L8),1,0)","v":0},0,0]
[null,"Wine",0,"Table Wine",0,0,1,2,9.9999999999999997E+98,0,0.22900000000000001,1,{"$f":"IF(AND($U$3>K9,$U$3<=L9),1,0)","v":0},0,0]
[null,"Wine",0,"Sparkling Wine",0,0,1,0,9.9999999999999997E+98,0,0,0.22900000000000001,{"$f":"IF(AND($U$3>K10,$U$3<=L10),1,0)","v":0},0,0]
[null,"Wine",0,"Sparkling Wine",0,0,1,0,9.9999999999999997E+98,0,0.22900000000000001,1,0,0,0]
[null,"Wine",0,"Dessert/Fortified Wine",0,0,1,0,9.9999999999999997E+98,0,0,0.22900000000000001,0,0,0]
[null,"Wine",0,"Dessert/Fortified Wine",0,0,1,0,9.9999999999999997E+98,0,0.22900000000000001,1,0,0,0]
[null,"Wine",0,"Fruit Wine/Sake",0,0,1,0,9.9999999999999997E+98,0,0,0.13700000000000001,{"$f":"IF(AND($U$3>K14,$U$3<=L14),1,0)","v":0},1.8700000000000001E-2,"LTR"]
[null,"Wine",0,"Fruit Wine/Sake",0,0,1,0,9.9999999999999997E+98,0,0.13700000000000001,0.14899999999999999,{"$f":"IF(AND($U$3>K15,$U$3<=L15),1,0)","v":0},7.0400000000000004E-2,"LTR"]
[null,"Wine",0,"Fruit Wine/Sake",0,0,1,0,9.9999999999999997E+98,0,0.14899999999999999,0.159,0,7.7799999999999994E-2,"LTR"]
[null,"Wine",0,"Fruit Wine/Sake",0,0,1,0,9.9999999999999997E+98,0,0.159,0.16900000000000001,0,8.5199999999999998E-2,"LTR"]
[null,"Wine",0,"Fruit Wine/Sake",0,0,1,0,9.9999999999999997E+98,0,0.16900000000000001,0.17899999999999999,0,9.2499999999999999E-2,"LTR"]
[null,"Wine",0,"Fruit Wine/Sake",0,0,1,0,9.9999999999999997E+98,0,0.17899999999999999,0.189,0,0.1,"LTR"]
[null,"Wine",0,"Fruit Wine/Sake",0,0,1,0,9.9999999999999997E+98,0,0.189,0.19900000000000001,0,0.10730000000000001,"LTR"]
[null,"Wine",0,"Fruit Wine/Sake",0,0,1,0,9.9999999999999997E+98,0,0.19900000000000001,0.20899999999999999,0,0.1148,"LTR"]
[null,"Wine",0,"Fruit Wine/Sake",0,0,1,0,9.9999999999999997E+98,0,0.20899999999999999,0.219,0,0.1221,"LTR"]
[null,"Wine",0,"Fruit Wine/Sake",0,0,1,0,9.9999999999999997E+98,0,0.219,0.22900000000000001,0,0.1295,"LTR"]
[null,"Wine",0,"Fruit Wine/Sake",0,0,1,0,9.9999999999999997E+98,0,0.22900000000000001,1,0,0.1295,"LTR"]
[null,"Wine",0,"Flavoured & Other",0,0,1,0,9.9999999999999997E+98,0,0,0.22900000000000001,0,2.8199999999999999E-2,"LTR"]
[null,"Wine",0,"Flavoured & Other",0,0,1,0,9.9999999999999997E+98,0,0.22900000000000001,1,0,0,0]
[null,"Spirit",0,"Whiskey",0,0,1,0,9.9999999999999997E+98,0,0,7.0000000000000007E-2,{"$f":"IF(AND($U$3>K27,$U$3<=L27),1,0)","v":0},0.12280000000000001,"LPA"]
[null,"Spirit",0,"Whiskey",0,0,1,0,9.9999999999999997E+98,0,7.0000000000000007E-2,0.8,{"$f":"IF(AND($U$3>K28,$U$3<=L28),1,0)","v":0},0,0]
[null,"Spirit",0,"Whiskey",0,0,1,0,9.9999999999999997E+98,0,0.8,1,0,0,0]
[null,"Spirit",0,"Brandy/Cognac",0,0,1,0,9.9999999999999997E+98,0,0,7.0000000000000007E-2,0,0.12280000000000001,"LPA"]
[null,"Spirit",0,"Brandy/Cognac",0,0,1,0,9.9999999999999997E+98,0,7.0000000000000007E-2,0.8,0,0,0]
[null,"Spirit",0,"Brandy/Cognac",0,0,1,0,9.9999999999999997E+98,0,0.8,1,0,0,0]
[null,"Spirit",0,"Tequila",0,0,1,0,9.9999999999999997E+98,0,0,7.0000000000000007E-2,0,0.12280000000000001,"LPA"]
[null,"Spirit",0,"Tequila",0,0,1,0,9.9999999999999997E+98,0,7.0000000000000007E-2,0.8,0,0,0]
[null,"Spirit",0,"Tequila",0,0,1,0,9.9999999999999997E+98,0,0.8,1,0,0,0]
[null,"Spirit",0,"Gin",0,0,1,0,9.9999999999999997E+98,0,0,7.0000000000000007E-2,0,0.12280000000000001,"LPA"]
[null,"Spirit",0,"Gin",0,0,1,0,9.9999999999999997E+98,0,7.0000000000000007E-2,0.8,0,4.9200000000000001E-2,"LPA"]
[null,"Spirit",0,"Gin",0,0,1,0,9.9999999999999997E+98,0,0.8,1,0,0,0]
[null,"Spirit",0,"Rum",0,0,1,0,9.9999999999999997E+98,0,0,7.0000000000000007E-2,0,0.12280000000000001,"LPA"]
[null,"Spirit",0,"Rum",0,0,1,0,9.9999999999999997E+98,0,7.0000000000000007E-2,0.8,0,0.24560000000000001,"LPA"]
[null,"Spirit",0,"Rum",0,0,1,0,9.9999999999999997E+98,0,0.8,1,0,0,0]
[null,"Spirit",{"$f":"IF($Q$3=B42,1,0)","v":0},"Miscellaneous",{"$f":"IF($R$3=D42,1,0)","v":0},0,{"$f":"IF($S$3=F42,1,0)","v":1},0,9.9999999999999997E+98,{"$f":"IF(AND($T$3>H42,$T$3<=I42),1,0)","v":0},0,7.0000000000000007E-2,{"$f":"IF(AND($U$3>K42,$U$3<=L42),1,0)","v":0},0.12280000000000001,"LPA"]
[null,"Spirit",0,"Miscellaneous",0,0,1,0,9.9999999999999997E+98,0,7.0000000000000007E-2,0.8,0,0.12280000000000001,"LPA"]
[null,"Spirit",0,"Miscellaneous",0,0,1,0,9.9999999999999997E+98,0,0.8,1,0,0,0]
[null,"Spirit",0,"Vodka",0,0,1,0,9.9999999999999997E+98,0,0,7.0000000000000007E-2,0,0.12280000000000001,"LPA"]
[null,"Spirit",0,"Vodka",0,0,1,0,9.9999999999999997E+98,0,7.0000000000000007E-2,0.8,0,0.12280000000000001,"LPA"]
[null,"Spirit",0,"Vodka",0,0,1,0,9.9999999999999997E+98,0,0.8,1,0,0,0]
[null,"Liqueur",0,"Liqueur",0,0,1,0,9.9999999999999997E+98,0,0,7.0000000000000007E-2,0,0.12280000000000001,"LPA"]
[null,"Liqueur",0,"Liqueur",0,0,1,0,9.9999999999999997E+98,0,7.0000000000000007E-2,0.8,0,0.12280000000000001,"LPA"]
[null,"Liqueur",0,"Liqueur",0,0,1,0,9.9999999999999997E+98,0,0.8,1,0,0,0]
[null,"Refreshment",0,"Cooler",0,"Malt",0,0,9.9999999999999997E+98,0,0,1,{"$f":"IF(AND($U$3>K51,$U$3<=L51),1,0)","v":0},0,0]
[null,"Refreshment",0,"Cooler",0,"Wine",0,0,9.9999999999999997E+98,0,0,0.22900000000000001,{"$f":"IF(AND($U$3>K52,$U$3<=L52),1,0)","v":0},0,0]
[null,"Refreshment",0,"Cooler",0,"Wine",0,0,9.9999999999999997E+98,0,0.22900000000000001,1,0,0,0]
[null,"Refreshment",0,"Cooler",0,"Spirit/Liqueur",0,0,9.9999999999999997E+98,0,0,7.0000000000000007E-2,{"$f":"IF(AND($U$3>K54,$U$3<=L54),1,0)","v":0},0.12280000000000001,"LPA"]
[null,"Refreshment",0,"Cooler",0,"Spirit/Liqueur",0,0,9.9999999999999997E+98,0,7.0000000000000007E-2,0.8,{"$f":"IF(AND($U$3>K55,$U$3<=L55),1,0)","v":0},0.12280000000000001,"LPA"]
[null,"Refreshment",0,"Cooler",0,"Spirit/Liqueur",0,0,9.9999999999999997E+98,0,0.8,1,{"$f":"IF(AND($U$3>K56,$U$3<=L56),1,0)","v":0},0,0]
[null,"Refreshment",0,"Cider",0,0,1,0,9.9999999999999997E+98,0,0,1,{"$f":"IF(AND($U$3>K57,$U$3<=L57),1,0)","v":0},0.12280000000000001,"LPA"]
[null,"Refreshment",0,"Non-Alcoholic",0,0,1,0,9.9999999999999997E+98,0,0,7.0000000000000007E-2,{"$f":"IF(AND($U$3>K58,$U$3<=L58),1,0)","v":0},0.12280000000000001,"LPA"]
[null,"Refreshment",0,"Non-Alcoholic",0,0,1,0,9.9999999999999997E+98,0,7.0000000000000007E-2,0.8,{"$f":"IF(AND($U$3>K59,$U$3<=L59),1,0)","v":0},0.12280000000000001,"LPA"]
[null,"Refreshment",0,"Non-Alcoholic",0,0,1,0,9.9999999999999997E+98,0,0.8,1,0,0,0]

{"sheet":"Excise","index":5,"n_rows":31,"n_cols":23,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Category","Category Rule","Sub-Category","Sub-Category Rule","Base","Base Rule","Volume Low","Volume High","Volume Rule","ABV Low","ABV High","ABV Rule","Excise Rate","UoM",null,"Category","Sub-Category","Base","Volume","ABV","Excise Rate","UoM"]
[null,"Beer",{"$f":"IF($Q$3=B3,1,0)","v":0},0,{"$f":"IF(B3=\"Refreshment\",IF($R$3=D3,1,0),1)","v":1},0,{"$f":"IF($S$3=F3,1,0)","v":1},0,9.9999999999999997E+98,{"$f":"IF(AND($T$3>H3,$T$3<=I3),1,0)","v":0},0,1.2E-2,{"$f":"IF(AND($U$3>K3,$U$3<=L3),1,0)","v":0},3.1280000000000002E-2,"LTR",{"$f":"+N3*$P$31","v":0},{"$f":"Calculations!I3","v":0},{"$f":"Calculations!I4","v":0},{"$f":"Calculations!I5","v":0},{"$f":"Calculations!I12","v":0},{"$f":"Calculations!N6","v":0},{"$f":"SUMIFS(N3:N30,C3:C30,1,E3:E30,1,G3:G30,1,J3:J30,1,M3:M30,1)","v":0},{"$f":"VLOOKUP(V3,N3:O30,2,FALSE)","v":{"$error":"#N/A"}}]
[null,"Beer",0,0,{"$f":"IF(B4=\"Refreshment\",IF($R$3=D4,1,0),1)","v":1},0,{"$f":"IF($S$3=F4,1,0)","v":1},0,9.9999999999999997E+98,0,1.2E-2,2.5000000000000001E-2,0,0.1885,"LTR",{"$f":"+N4*$P$31","v":0}]
[null,"Beer",0,0,1,0,1,0,9.9999999999999997E+98,0,2.5000000000000001E-2,0.11899999999999999,0,0.37690000000000001,"LTR",0]
[null,"Beer",0,0,1,0,1,0,9.9999999999999997E+98,0,0.11899999999999999,1,0,14.117000000000001,"LPA",0]
[null,"Wine",0,0,1,0,1,0,2,0,0,7.0000000000000007E-2,0,0.35799999999999998,"LTR",0]
[null,"Wine",0,0,1,0,1,0,2,0,7.0000000000000007E-2,0.22900000000000001,0,0.745,"LTR",0]
[null,"Wine",0,0,1,0,1,0,2,0,0.22900000000000001,1,0,14.117000000000001,"LPA",0]
[null,"Wine",0,0,1,0,1,2,9.9999999999999997E+98,0,0,0.14899999999999999,0,0.745,"LTR",0]
[null,"Wine",0,0,1,0,1,2,9.9999999999999997E+98,0,0.14899999999999999,0.22900000000000001,0,0.745,"LTR",0]
[null,"Wine",0,0,1,0,1,2,9.9999999999999997E+98,0,0.22900000000000001,1,0,14.117000000000001,"LPA",0]
[null,"Spirit",0,0,1,0,1,0,9.9999999999999997E+98,0,0,7.0000000000000007E-2,0,0.35799999999999998,"LTR",0]
[null,"Spirit",0,0,1,0,1,0,9.9999999999999997E+98,0,7.0000000000000007E-2,1,0,14.117000000000001,"LPA",0]
[null,"Liqueur",0,0,1,0,1,0,9.9999999999999997E+98,0,0,7.0000000000000007E-2,0,0.35799999999999998,"LTR",0]
[null,"Liqueur",0,0,1,0,1,0,9.9999999999999997E+98,0,7.0000000000000007E-2,1,0,14.117000000000001,"LPA",0]
[null,"Refreshment",0,"Cooler",0,"Malt",0,0,9.9999999999999997E+98,0,0,1.2E-2,0,3.0669999999999999E-2,"LTR",0]
[null,"Refreshment",0,"Cooler",0,"Malt",0,0,9.9999999999999997E+98,0,1.2E-2,2.5000000000000001E-2,0,0.18479999999999999,"LTR",0]
[null,"Refreshment",0,"Cooler",0,"Malt",0,0,9.9999999999999997E+98,0,2.5000000000000001E-2,0.11899999999999999,0,0.3695,"LTR",0]
[null,"Refreshment",0,"Cooler",0,"Malt",0,0,9.9999999999999997E+98,0,0.11899999999999999,1,0,14.117000000000001,"LPA",0]
[null,"Refreshment",0,"Cooler",0,"Wine",0,0,9.9999999999999997E+98,0,0,7.0000000000000007E-2,0,0.35799999999999998,"LTR",0]
[null,"Refreshment",0,"Cooler",0,"Wine",0,0,9.9999999999999997E+98,0,7.0000000000000007E-2,0.22900000000000001,0,0.745,"LTR",0]
[null,"Refreshment",0,"Cooler",0,"Wine",0,0,9.9999999999999997E+98,0,0.22900000000000001,1,0,14.117000000000001,"LPA",0]
[null,"Refreshment",0,"Cooler",0,"Spirit/Liqueur",0,0,9.9999999999999997E+98,0,0,7.0000000000000007E-2,0,0.35799999999999998,"LTR",0]
[null,"Refreshment",0,"Cooler",0,"Spirit/Liqueur",0,0,9.9999999999999997E+98,0,7.0000000000000007E-2,1,0,14.117000000000001,"LPA",0]
[null,"Refreshment",0,"Cider",0,0,1,0,9.9999999999999997E+98,0,0,7.0000000000000007E-2,0,0.35799999999999998,"LTR",0]
[null,"Refreshment",0,"Cider",0,0,1,0,9.9999999999999997E+98,0,7.0000000000000007E-2,0.22900000000000001,0,0.745,"LTR",0]
[null,"Refreshment",0,"Cider",0,0,1,0,9.9999999999999997E+98,0,0.22900000000000001,1,0,14.117000000000001,"LPA",0]
[null,"Refreshment",0,"Non-Alcoholic",0,0,1,0,9.9999999999999997E+98,0,0,7.0000000000000007E-2,0,0.35799999999999998,"LTR",0]
[null,"Refreshment",0,"Non-Alcoholic",0,0,1,0,9.9999999999999997E+98,0,7.0000000000000007E-2,1,{"$f":"IF(AND($U$3>K30,$U$3<=L30),1,0)","v":0},14.117000000000001,"LPA",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rate Increase"]

{"sheet":"National Markup","index":6,"n_rows":34,"n_cols":17,"rows_kept":34,"cut":false,"hidden":true,"merged":[[1,15,1,16]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Markup"]
[null,"Product Category","Catgeory Rule","ABV low","ABV high","ABV Rule","Mark-up","Landed Cost","Volume","Landed Cost/L","Low","High","Markup per Litre","Markup per Selling Unit",null,"Per Litre","Markup per Selling Unit"]
[null,"Wine",{"$f":"IF(Calculations!$S$3='National Markup'!B4,1,0)","v":0},0,5.0000000000000001E-3,{"$f":"IF(AND(Calculations!$S$4>=D4,Calculations!$S$4<=E4),\"1\",\"0\")","v":"1"},0.3,{"$f":"Calculations!$S$14","v":{"$error":"#DIV/0!"}},{"$f":"Calculations!$S$16","v":0},null,0,9.9999999999999997E+98,null,{"$f":"IF(AND(H4>$K4,H4<=$L4),H4*$G4,0)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUMIFS(M4:M34,C4:C34,1,F4:F34,1)","v":0},{"$f":"SUMIFS(N4:N34,C4:C34,1,F4:F34,1)","v":0}]
[null,"Wine",{"$f":"IF(Calculations!$S$3='National Markup'!B5,1,0)","v":0},6.0000000000000001E-3,7.0000000000000007E-2,{"$f":"IF(AND(Calculations!$S$4>D5,Calculations!$S$4<=E5),\"1\",\"0\")","v":"0"},0.88,{"$f":"Calculations!$S$14","v":{"$error":"#DIV/0!"}},{"$f":"Calculations!$S$16","v":0},{"$f":"H5/I5","v":{"$error":"#DIV/0!"}},0,9.9999999999999997E+98,{"$f":"IF(AND(J5>$K5,J5<=$L5),J5*$G5,$L5*$G5)","v":{"$error":"#DIV/0!"}},{"$f":"M5*I5","v":{"$error":"#DIV/0!"}}]
[null,"Wine",{"$f":"IF(Calculations!$S$3='National Markup'!B6,1,0)","v":0},7.0000000000000007E-2,0.16,{"$f":"IF(AND(Calculations!$S$4>D6,Calculations!$S$4<=E6),\"1\",\"0\")","v":"0"},0.99,{"$f":"Calculations!$S$14","v":{"$error":"#DIV/0!"}},{"$f":"Calculations!$S$16","v":0},{"$error":"#DIV/0!"},0,12.5,{"$f":"IF(AND(J6>$K6,J6<=$L6),J6*$G6,$L6*$G6)","v":{"$error":"#DIV/0!"}},{"$f":"M6*I6","v":{"$error":"#DIV/0!"}}]
[null,"Wine",{"$f":"IF(Calculations!$S$3='National Markup'!B7,1,0)","v":0},7.0000000000000007E-2,0.16,{"$f":"IF(AND(Calculations!$S$4>D7,Calculations!$S$4<=E7),\"1\",\"0\")","v":"0"},0.3,{"$f":"Calculations!$S$14","v":{"$error":"#DIV/0!"}},{"$f":"Calculations!$S$16","v":0},{"$error":"#DIV/0!"},12.5,9.9999999999999997E+98,{"$f":"IF(AND(J7>$K7,J7<=$L7),(J7-$K7)*$G7,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"Wine",{"$f":"IF(Calculations!$S$3='National Markup'!B8,1,0)","v":0},0.16,1,{"$f":"IF(AND(Calculations!$S$4>D8,Calculations!$S$4<=E8),\"1\",\"0\")","v":"0"},1.3,{"$f":"Calculations!$S$14","v":{"$error":"#DIV/0!"}},{"$f":"Calculations!$S$16","v":0},{"$error":"#DIV/0!"},0,25,{"$f":"IF(AND(J8>$K8,J8<=$L8),J8*$G8,$L8*$G8)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"Wine",{"$f":"IF(Calculations!$S$3='National Markup'!B9,1,0)","v":0},0.16,1,{"$f":"IF(AND(Calculations!$S$4>D9,Calculations!$S$4<=E9),\"1\",\"0\")","v":"0"},0.6,{"$f":"Calculations!$S$14","v":{"$error":"#DIV/0!"}},{"$f":"Calculations!$S$16","v":0},{"$error":"#DIV/0!"},25.01,37.5,{"$f":"IF(AND(J9>$K9,J9<=$L9),(J9-$K9)*$G9,IF(J9>$L9,($L9-K9)*$G9,))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"Wine",{"$f":"IF(Calculations!$S$3='National Markup'!B10,1,0)","v":0},0.16,1,{"$f":"IF(AND(Calculations!$S$4>D10,Calculations!$S$4<=E10),\"1\",\"0\")","v":"0"},0.3,{"$f":"Calculations!$S$14","v":{"$error":"#DIV/0!"}},{"$f":"Calculations!$S$16","v":0},{"$error":"#DIV/0!"},37.5,9.9999999999999997E+98,{"$f":"IF(AND(J10>$K10,J10<$L10),(J10-$K10)*$G10,0)","v":{"$error":"#DIV/0!"}},{"$f":"M10*I10","v":{"$error":"#DIV/0!"}}]
[null,"Spirit",{"$f":"IF(Calculations!$S$3='National Markup'!B11,1,0)","v":0},0,5.0000000000000001E-3,{"$f":"IF(AND(Calculations!$S$4>=D11,Calculations!$S$4<=E11),\"1\",\"0\")","v":"1"},0.3,{"$f":"Calculations!$S$14","v":{"$error":"#DIV/0!"}},{"$f":"Calculations!$S$16","v":0},null,0,9.9999999999999997E+98,null,{"$f":"IF(AND(H11>$K11,H11<=$L11),H11*$G11,0)","v":{"$error":"#DIV/0!"}}]
[null,"Spirit",{"$f":"IF(Calculations!$S$3='National Markup'!B12,1,0)","v":0},6.0000000000000001E-3,7.0000000000000007E-2,{"$f":"IF(AND(Calculations!$S$4>D12,Calculations!$S$4<=E12),\"1\",\"0\")","v":"0"},0.88,{"$f":"Calculations!$S$14","v":{"$error":"#DIV/0!"}},{"$f":"Calculations!$S$16","v":0},{"$f":"H12/I12","v":{"$error":"#DIV/0!"}},0,9.9999999999999997E+98,{"$f":"IF(AND(J12>$K12,J12<=$L12),J12*$G12,$L12*$G12)","v":{"$error":"#DIV/0!"}},{"$f":"M12*I12","v":{"$error":"#DIV/0!"}}]
[null,"Spirit",{"$f":"IF(Calculations!$S$3='National Markup'!B13,1,0)","v":0},7.0000000000000007E-2,0.14499999999999999,{"$f":"IF(AND(Calculations!$S$4>D13,Calculations!$S$4<=E13),\"1\",\"0\")","v":"0"},0.99,{"$f":"Calculations!$S$14","v":{"$error":"#DIV/0!"}},{"$f":"Calculations!$S$16","v":0},{"$error":"#DIV/0!"},0,12.5,{"$f":"IF(AND(J13>$K13,J13<=$L13),J13*$G13,$L13*$G13)","v":{"$error":"#DIV/0!"}},{"$f":"M13*I13","v":{"$error":"#DIV/0!"}}]
[null,"Spirit",{"$f":"IF(Calculations!$S$3='National Markup'!B14,1,0)","v":0},7.0000000000000007E-2,0.14499999999999999,{"$f":"IF(AND(Calculations!$S$4>D14,Calculations!$S$4<=E14),\"1\",\"0\")","v":"0"},0.3,{"$f":"Calculations!$S$14","v":{"$error":"#DIV/0!"}},{"$f":"Calculations!$S$16","v":0},{"$error":"#DIV/0!"},12.5,9.9999999999999997E+98,{"$f":"IF(AND(J14>$K14,J14<=$L14),(J14-$K14)*$G14,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"Spirit",{"$f":"IF(Calculations!$S$3='National Markup'!B15,1,0)","v":0},0.14499999999999999,1,{"$f":"IF(AND(Calculations!$S$4>D15,Calculations!$S$4<=E15),\"1\",\"0\")","v":"0"},1.3,{"$f":"Calculations!$S$14","v":{"$error":"#DIV/0!"}},{"$f":"Calculations!$S$16","v":0},{"$error":"#DIV/0!"},0,25,{"$f":"IF(AND(J15>$K15,J15<=$L15),J15*$G15,$L15*$G15)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"Spirit",{"$f":"IF(Calculations!$S$3='National Markup'!B16,1,0)","v":0},0.14499999999999999,1,{"$f":"IF(AND(Calculations!$S$4>D16,Calculations!$S$4<=E16),\"1\",\"0\")","v":"0"},0.6,{"$f":"Calculations!$S$14","v":{"$error":"#DIV/0!"}},{"$f":"Calculations!$S$16","v":0},{"$error":"#DIV/0!"},25.01,37.5,{"$f":"IF(AND(J16>$K16,J16<=$L16),(J16-$K16)*$G16,IF(J16>$L16,($L16-K16)*$G16,))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"Spirit",{"$f":"IF(Calculations!$S$3='National Markup'!B17,1,0)","v":0},0.14499999999999999,1,{"$f":"IF(AND(Calculations!$S$4>D17,Calculations!$S$4<=E17),\"1\",\"0\")","v":"0"},0.3,{"$f":"Calculations!$S$14","v":{"$error":"#DIV/0!"}},{"$f":"Calculations!$S$16","v":0},{"$error":"#DIV/0!"},37.5,9.9999999999999997E+98,{"$f":"IF(AND(J17>$K17,J17<$L17),(J17-$K17)*$G17,0)","v":{"$error":"#DIV/0!"}},{"$f":"M17*I17","v":{"$error":"#DIV/0!"}}]
[null,"Liqueur",{"$f":"IF(Calculations!$S$3='National Markup'!B18,1,0)","v":0},0,5.0000000000000001E-3,{"$f":"IF(AND(Calculations!$S$4>=D18,Calculations!$S$4<=E18),\"1\",\"0\")","v":"1"},0.3,{"$f":"Calculations!$S$14","v":{"$error":"#DIV/0!"}},{"$f":"Calculations!$S$16","v":0},null,0,9.9999999999999997E+98,null,{"$f":"IF(AND(H18>$K18,H18<=$L18),H18*$G18,0)","v":{"$error":"#DIV/0!"}}]
[null,"Liqueur",{"$f":"IF(Calculations!$S$3='National Markup'!B19,1,0)","v":0},6.0000000000000001E-3,7.0000000000000007E-2,{"$f":"IF(AND(Calculations!$S$4>D19,Calculations!$S$4<=E19),\"1\",\"0\")","v":"0"},0.88,{"$f":"Calculations!$S$14","v":{"$error":"#DIV/0!"}},{"$f":"Calculations!$S$16","v":0},{"$f":"H19/I19","v":{"$error":"#DIV/0!"}},0,9.9999999999999997E+98,{"$f":"IF(AND(J19>$K19,J19<=$L19),J19*$G19,$L19*$G19)","v":{"$error":"#DIV/0!"}},{"$f":"M19*I19","v":{"$error":"#DIV/0!"}}]
[null,"Liqueur",{"$f":"IF(Calculations!$S$3='National Markup'!B20,1,0)","v":0},7.0000000000000007E-2,0.14499999999999999,{"$f":"IF(AND(Calculations!$S$4>D20,Calculations!$S$4<=E20),\"1\",\"0\")","v":"0"},0.99,{"$f":"Calculations!$S$14","v":{"$error":"#DIV/0!"}},{"$f":"Calculations!$S$16","v":0},{"$error":"#DIV/0!"},0,12.5,{"$f":"IF(AND(J20>$K20,J20<=$L20),J20*$G20,$L20*$G20)","v":{"$error":"#DIV/0!"}},{"$f":"M20*I20","v":{"$error":"#DIV/0!"}}]
[null,"Liqueur",{"$f":"IF(Calculations!$S$3='National Markup'!B21,1,0)","v":0},7.0000000000000007E-2,0.14499999999999999,{"$f":"IF(AND(Calculations!$S$4>D21,Calculations!$S$4<=E21),\"1\",\"0\")","v":"0"},0.3,{"$f":"Calculations!$S$14","v":{"$error":"#DIV/0!"}},{"$f":"Calculations!$S$16","v":0},{"$error":"#DIV/0!"},12.5,9.9999999999999997E+98,{"$f":"IF(AND(J21>$K21,J21<=$L21),(J21-$K21)*$G21,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"Liqueur",{"$f":"IF(Calculations!$S$3='National Markup'!B22,1,0)","v":0},0.14499999999999999,1,{"$f":"IF(AND(Calculations!$S$4>D22,Calculations!$S$4<=E22),\"1\",\"0\")","v":"0"},1.3,{"$f":"Calculations!$S$14","v":{"$error":"#DIV/0!"}},{"$f":"Calculations!$S$16","v":0},{"$error":"#DIV/0!"},0,25,{"$f":"IF(AND(J22>$K22,J22<=$L22),J22*$G22,$L22*$G22)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"Liqueur",{"$f":"IF(Calculations!$S$3='National Markup'!B23,1,0)","v":0},0.14499999999999999,1,{"$f":"IF(AND(Calculations!$S$4>D23,Calculations!$S$4<=E23),\"1\",\"0\")","v":"0"},0.6,{"$f":"Calculations!$S$14","v":{"$error":"#DIV/0!"}},{"$f":"Calculations!$S$16","v":0},{"$error":"#DIV/0!"},25.01,37.5,{"$f":"IF(AND(J23>$K23,J23<=$L23),(J23-$K23)*$G23,IF(J23>$L23,($L23-K23)*$G23,))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"Liqueur",{"$f":"IF(Calculations!$S$3='National Markup'!B24,1,0)","v":0},0.14499999999999999,1,{"$f":"IF(AND(Calculations!$S$4>D24,Calculations!$S$4<=E24),\"1\",\"0\")","v":"0"},0.3,{"$f":"Calculations!$S$14","v":{"$error":"#DIV/0!"}},{"$f":"Calculations!$S$16","v":0},{"$error":"#DIV/0!"},37.5,9.9999999999999997E+98,{"$f":"IF(AND(J24>$K24,J24<$L24),(J24-$K24)*$G24,0)","v":{"$error":"#DIV/0!"}},{"$f":"M24*I24","v":{"$error":"#DIV/0!"}}]
[null,"Refreshment",{"$f":"IF(Calculations!$S$3='National Markup'!B25,1,0)","v":0},0,5.0000000000000001E-3,{"$f":"IF(AND(Calculations!$S$4>=D25,Calculations!$S$4<=E25),\"1\",\"0\")","v":"1"},0.3,{"$f":"Calculations!$S$14","v":{"$error":"#DIV/0!"}},{"$f":"Calculations!$S$16","v":0},null,0,9.9999999999999997E+98,null,{"$f":"IF(AND(H25>$K25,H25<=$L25),H25*$G25,0)","v":{"$error":"#DIV/0!"}}]
[null,"Refreshment",{"$f":"IF(Calculations!$S$3='National Markup'!B26,1,0)","v":0},6.0000000000000001E-3,7.0000000000000007E-2,{"$f":"IF(AND(Calculations!$S$4>D26,Calculations!$S$4<=E26),\"1\",\"0\")","v":"0"},0.88,{"$f":"Calculations!$S$14","v":{"$error":"#DIV/0!"}},{"$f":"Calculations!$S$16","v":0},{"$f":"H26/I26","v":{"$error":"#DIV/0!"}},0,9.9999999999999997E+98,{"$f":"IF(AND(J26>$K26,J26<=$L26),J26*$G26,$L26*$G26)","v":{"$error":"#DIV/0!"}},{"$f":"M26*I26","v":{"$error":"#DIV/0!"}}]
[null,"Refreshment",{"$f":"IF(Calculations!$S$3='National Markup'!B27,1,0)","v":0},7.0000000000000007E-2,0.14499999999999999,{"$f":"IF(AND(Calculations!$S$4>D27,Calculations!$S$4<=E27),\"1\",\"0\")","v":"0"},0.99,{"$f":"Calculations!$S$14","v":{"$error":"#DIV/0!"}},{"$f":"Calculations!$S$16","v":0},{"$f":"H27/I27","v":{"$error":"#DIV/0!"}},0,12.5,{"$f":"IF(AND(J27>$K27,J27<=$L27),J27*$G27,$L27*$G27)","v":{"$error":"#DIV/0!"}},{"$f":"M27*I27","v":{"$error":"#DIV/0!"}}]
[null,"Refreshment",{"$f":"IF(Calculations!$S$3='National Markup'!B28,1,0)","v":0},7.0000000000000007E-2,0.14499999999999999,{"$f":"IF(AND(Calculations!$S$4>D28,Calculations!$S$4<=E28),\"1\",\"0\")","v":"0"},0.3,{"$f":"Calculations!$S$14","v":{"$error":"#DIV/0!"}},{"$f":"Calculations!$S$16","v":0},{"$error":"#DIV/0!"},12.5,9.9999999999999997E+98,{"$f":"IF(AND(J28>$K28,J28<=$L28),(J28-$K28)*$G28,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"Refreshment",{"$f":"IF(Calculations!$S$3='National Markup'!B29,1,0)","v":0},0.14499999999999999,1,{"$f":"IF(AND(Calculations!$S$4>D29,Calculations!$S$4<=E29),\"1\",\"0\")","v":"0"},1.3,{"$f":"Calculations!$S$14","v":{"$error":"#DIV/0!"}},{"$f":"Calculations!$S$16","v":0},{"$error":"#DIV/0!"},0,25,{"$f":"IF(AND(J29>$K29,J29<=$L29),J29*$G29,$L29*$G29)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"Refreshment",{"$f":"IF(Calculations!$S$3='National Markup'!B30,1,0)","v":0},0.14499999999999999,1,{"$f":"IF(AND(Calculations!$S$4>D30,Calculations!$S$4<=E30),\"1\",\"0\")","v":"0"},0.6,{"$f":"Calculations!$S$14","v":{"$error":"#DIV/0!"}},{"$f":"Calculations!$S$16","v":0},{"$error":"#DIV/0!"},25.01,37.5,{"$f":"IF(AND(J30>$K30,J30<=$L30),(J30-$K30)*$G30,IF(J30>$L30,($L30-K30)*$G30,))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"Refreshment",{"$f":"IF(Calculations!$S$3='National Markup'!B31,1,0)","v":0},0.14499999999999999,1,{"$f":"IF(AND(Calculations!$S$4>D31,Calculations!$S$4<=E31),\"1\",\"0\")","v":"0"},0.3,{"$f":"Calculations!$S$14","v":{"$error":"#DIV/0!"}},{"$f":"Calculations!$S$16","v":0},{"$error":"#DIV/0!"},37.5,9.9999999999999997E+98,{"$f":"IF(AND(J31>$K31,J31<$L31),(J31-$K31)*$G31,0)","v":{"$error":"#DIV/0!"}},{"$f":"M31*I31","v":{"$error":"#DIV/0!"}}]
[null,"Beer",{"$f":"IF(Calculations!$S$3='National Markup'!B32,1,0)","v":0},0,5.0000000000000001E-3,{"$f":"IF(AND(Calculations!$S$4>=D32,Calculations!$S$4<=E32),\"1\",\"0\")","v":"1"},0.3,{"$f":"Calculations!$S$14","v":{"$error":"#DIV/0!"}},{"$f":"Calculations!$S$16","v":0},{"$error":"#DIV/0!"},0,9.9999999999999997E+98,null,{"$f":"H32*G32","v":{"$error":"#DIV/0!"}}]
[null,"Beer",{"$f":"IF(Calculations!$S$3='National Markup'!B33,1,0)","v":0},6.0000000000000001E-3,6.5000000000000002E-2,{"$f":"IF(AND(Calculations!$S$4>D33,Calculations!$S$4<=E33),\"1\",\"0\")","v":"0"},0.63,{"$f":"Calculations!$S$14","v":{"$error":"#DIV/0!"}},{"$f":"Calculations!$S$16","v":0},{"$f":"H33/I33","v":{"$error":"#DIV/0!"}},0,9.9999999999999997E+98,null,{"$f":"H33*G33","v":{"$error":"#DIV/0!"}}]
[null,"Beer",{"$f":"IF(Calculations!$S$3='National Markup'!B34,1,0)","v":0},6.5000000000000002E-2,1,{"$f":"IF(AND(Calculations!$S$4>D34,Calculations!$S$4<=E34),\"1\",\"0\")","v":"0"},0.98,{"$f":"Calculations!$S$14","v":{"$error":"#DIV/0!"}},{"$f":"Calculations!$S$16","v":0},{"$error":"#DIV/0!"},0,9.9999999999999997E+98,null,{"$f":"H34*G34","v":{"$error":"#DIV/0!"}}]

{"sheet":"Small Producer Markup","index":7,"n_rows":38,"n_cols":13,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Product Category","Product Category Rule","Global Production","Global Production Rule","Markup Amount","UoM",null,"ABV","Category:","Previous Calendar Year Production:","Small Producer Markup","Small Producer Markup UoM"]
[null,"Wine",{"$f":"IF($J$3=B3,1,0)","v":0},"<25,000 L",{"$f":"IF($K$3=D3,1,0)","v":0},0.45,"%",null,{"$f":"Calculations!S4","v":0},{"$f":"Calculations!S3","v":0},{"$f":"Calculations!S5","v":">200,000 L - National Producer"},{"$f":"SUMIFS(F3:F38,C3:C38,1,E3:E38,1)","v":0},{"$f":"VLOOKUP(L3,F3:G38,2,FALSE)","v":{"$error":"#N/A"}}]
[null,"Wine",0,"25,0001 to 50,000 L",{"$f":"IF($K$3=D4,1,0)","v":0},0.5,"%"]
[null,"Wine",0,"50,001 to 75,000 L",0,0.56000000000000005,"%"]
[null,"Wine",0,"75,001 to 100,000 L",0,0.64,"%"]
[null,"Wine",0,"100,001 to 150,000 L",0,0.74,"%"]
[null,"Wine",0,"150,001 to 200,000 L",0,0.85,"%"]
[null,"Spirit",0,"<25,000 L",0,0.73,"%"]
[null,"Spirit",0,"25,0001 to 50,000 L",0,0.8,"%"]
[null,"Spirit",0,"50,001 to 75,000 L",0,0.88,"%"]
[null,"Spirit",0,"75,001 to 100,000 L",0,0.98,"%"]
[null,"Spirit",0,"100,001 to 150,000 L",0,1.08,"%"]
[null,"Spirit",0,"150,001 to 200,000 L",0,1.19,"%"]
[null,"Liqueur",0,"<25,000 L",0,0.73,"%"]
[null,"Liqueur",0,"25,0001 to 50,000 L",0,0.8,"%"]
[null,"Liqueur",0,"50,001 to 75,000 L",0,0.88,"%"]
[null,"Liqueur",0,"75,001 to 100,000 L",0,0.98,"%"]
[null,"Liqueur",0,"100,001 to 150,000 L",0,1.08,"%"]
[null,"Liqueur",0,"150,001 to 200,000 L",0,1.19,"%"]
[null,"Refreshment",0,"<25,000 L",0,0.39,"%"]
[null,"Refreshment",0,"25,0001 to 50,000 L",0,0.43,"%"]
[null,"Refreshment",0,"50,001 to 75,000 L",0,0.5,"%"]
[null,"Refreshment",0,"75,001 to 100,000 L",0,0.6,"%"]
[null,"Refreshment",0,"100,001 to 150,000 L",0,0.66,"%"]
[null,"Refreshment",0,"150,001 to 200,000 L",0,0.75,"%"]
[null,"Beer",0,"<2,500 HL",0,0.08,"%"]
[null,"Beer",0,"2,501 - 30,000 HL",0,0.1,"%"]
[null,"Beer",0,"30,001 - 50,000 HL",0,0.12,"%"]
[null,"Beer",0,"50,001 - 100,000 HL",0,0.14000000000000001,"%"]
[null,"Beer",0,"100,001 - 150,000 HL",0,0.17,"%"]
[null,"Beer",0,"150,001 - 200,000 HL",0,0.2,"%"]
[null,"Beer",0,"200,001 - 250,000 HL",0,0.23,"%"]
[null,"Beer",0,"250,001 - 300,000 HL",0,0.26,"%"]
[null,"Beer",0,"300,001 - 350,000 HL",0,0.31,"%"]
[null,"Beer",0,"350,001 - 400,000 HL",0,0.38,"%"]
[null,"Beer",0,"400,001 - 450,000 HL",0,0.46,"%"]
[null,"Beer",0,"450,001 - 500,000 HL",0,0.54,"%"]

{"sheet":"COS","index":8,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Sourced From","Source Rule","Category","Category Rule","Rate $/Litre",null,"Rate"]
[null,"Canada",{"$f":"IF(B3=Calculations!$X$6,1,0)","v":0},"Wine",{"$f":"IF('Wholesale Details'!$D$3=\"Wine\",1,0)","v":0},0.36,null,{"$f":"IF(C19=\"SLGA\",SUMIFS(F3:F17,$E3:$E17,1,$C3:$C17,1),0)","v":0}]
[null,"Canada",{"$f":"IF(B4=Calculations!$X$6,1,0)","v":0},"Spirit",{"$f":"IF('Wholesale Details'!$D$3=\"Spirit\",1,0)","v":0},0.36]
[null,"Canada",{"$f":"IF(B5=Calculations!$X$6,1,0)","v":0},"Liqueur",{"$f":"IF('Wholesale Details'!$D$3=\"Liqueur\",1,0)","v":0},0.36]
[null,"Canada",{"$f":"IF(B6=Calculations!$X$6,1,0)","v":0},"Refreshment",{"$f":"IF('Wholesale Details'!$D$3=\"Refreshment\",1,0)","v":0},0.24]
[null,"Canada",{"$f":"IF(B7=Calculations!$X$6,1,0)","v":0},"Beer",{"$f":"IF('Wholesale Details'!$D$3=\"Beer\",1,0)","v":0},0.24]
[null,"USA",{"$f":"IF(B8=Calculations!$X$6,1,0)","v":0},"Wine",{"$f":"IF('Wholesale Details'!$D$3=\"Wine\",1,0)","v":0},0.55000000000000004]
[null,"USA",{"$f":"IF(B9=Calculations!$X$6,1,0)","v":0},"Spirit",{"$f":"IF('Wholesale Details'!$D$3=\"Spirit\",1,0)","v":0},0.55000000000000004]
[null,"USA",{"$f":"IF(B10=Calculations!$X$6,1,0)","v":0},"Liqueur",{"$f":"IF('Wholesale Details'!$D$3=\"Liqueur\",1,0)","v":0},0.55000000000000004]
[null,"USA",{"$f":"IF(B11=Calculations!$X$6,1,0)","v":0},"Refreshment",{"$f":"IF('Wholesale Details'!$D$3=\"Refreshment\",1,0)","v":0},0.52]
[null,"USA",{"$f":"IF(B12=Calculations!$X$6,1,0)","v":0},"Beer",{"$f":"IF('Wholesale Details'!$D$3=\"Beer\",1,0)","v":0},0.52]
[null,"Other",{"$f":"IF(B13=Calculations!$X$6,1,0)","v":0},"Wine",{"$f":"IF('Wholesale Details'!$D$3=\"Wine\",1,0)","v":0},0.85]
[null,"Other",{"$f":"IF(B14=Calculations!$X$6,1,0)","v":0},"Spirit",{"$f":"IF('Wholesale Details'!$D$3=\"Spirit\",1,0)","v":0},0.85]
[null,"Other",{"$f":"IF(B15=Calculations!$X$6,1,0)","v":0},"Liqueur",{"$f":"IF('Wholesale Details'!$D$3=\"Liqueur\",1,0)","v":0},0.85]
[null,"Other",{"$f":"IF(B16=Calculations!$X$6,1,0)","v":0},"Refreshment",{"$f":"IF('Wholesale Details'!$D$3=\"Refreshment\",1,0)","v":0},0.56999999999999995]
[null,"Other",{"$f":"IF(B17=Calculations!$X$6,1,0)","v":0},"Beer",{"$f":"IF('Wholesale Details'!$D$3=\"Beer\",1,0)","v":0},0.56999999999999995]
[]
[null,"Distributor",{"$f":"'Wholesale Details'!D26","v":0}]

{"sheet":"Enviro & Container","index":9,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Container Type","Container Rule","Volume Low","Volume High","Volume Rule","Environmental Charge","Container Deposit",null,"Container Type","Container Volume","Environmental Charge","Container Deposit"]
[null,"Aluminum Can",{"$f":"IF($J$3=B3,1,0)","v":0},0,1,{"$f":"IF(AND($K$3>D3,$K$3<E3),1,0)","v":{"$error":"#DIV/0!"}},7.0000000000000007E-2,0.1,null,{"$f":"Calculations!D14","v":0},{"$f":"Calculations!D17","v":{"$error":"#DIV/0!"}},{"$f":"SUMIFS(G3:G21,C3:C21,1,F3:F21,1)","v":0},{"$f":"SUMIFS(H3:H21,C3:C21,1,F3:F21,1)","v":0}]
[null,"Aluminum Can",0,1,9.9999999999999997E+98,{"$f":"IF(AND($K$3>=D4,$K$3<E4),1,0)","v":{"$error":"#DIV/0!"}},7.0000000000000007E-2,0.25]
[null,"Aluminum Pouch",0,0,9.9999999999999997E+98,{"$f":"IF(AND($K$3>D5,$K$3<E5),1,0)","v":{"$error":"#DIV/0!"}},0.08,0]
[null,"Aseptic Carton",0,0,1,{"$f":"IF(AND($K$3>D6,$K$3<E6),1,0)","v":{"$error":"#DIV/0!"}},0.05,0.1]
[null,"Aseptic Carton",0,1,9.9999999999999997E+98,{"$f":"IF(AND($K$3>=D7,$K$3<E7),1,0)","v":{"$error":"#DIV/0!"}},0.05,0.25]
[null,"Bag-in-Box",0,1,9.9999999999999997E+98,{"$f":"IF(AND($K$3>=D8,$K$3<E8),1,0)","v":{"$error":"#DIV/0!"}},0,0]
[null,"Keg",0,0,9.9999999999999997E+98,{"$f":"IF(AND($K$3>D9,$K$3<E9),1,0)","v":{"$error":"#DIV/0!"}},0,20]
[null,"Keg (No Deposit)",0,0,9.9999999999999997E+98,{"$f":"IF(AND($K$3>D10,$K$3<E10),1,0)","v":{"$error":"#DIV/0!"}},0,0]
[null,"Non-Refillable Glass",0,0,0.3,{"$f":"IF(AND($K$3>D11,$K$3<=E11),1,0)","v":{"$error":"#DIV/0!"}},0.09,0.1]
[null,"Non-Refillable Glass",0,0.3,1,{"$f":"IF(AND($K$3>D12,$K$3<E12),1,0)","v":{"$error":"#DIV/0!"}},0.09,0.2]
[null,"Non-Refillable Glass",0,1,9.9999999999999997E+98,{"$f":"IF(AND($K$3>=D13,$K$3<=E13),1,0)","v":{"$error":"#DIV/0!"}},0.09,0.4]
[null,"PET",0,0,1,{"$f":"IF(AND($K$3>D14,$K$3<E14),1,0)","v":{"$error":"#DIV/0!"}},0.08,0.1]
[null,"PET",0,1,5,{"$f":"IF(AND($K$3>=D15,$K$3<=E15),1,0)","v":{"$error":"#DIV/0!"}},0.08,0.25]
[null,"PET",0,5,9.9999999999999997E+98,{"$f":"IF(AND($K$3>D16,$K$3<=E16),1,0)","v":{"$error":"#DIV/0!"}},0.08,0]
[null,"Refillable Glass",0,0,9.9999999999999997E+98,{"$error":"#DIV/0!"},0,0.1]
[null,"Zero Dollar",0,0,9.9999999999999997E+98,{"$error":"#DIV/0!"},0,0]
[null,"Non Returnable",0,0,9.9999999999999997E+98,{"$error":"#DIV/0!"},0,0]
[null,"Earthenware",0,0,9.9999999999999997E+98,{"$error":"#DIV/0!"},0,0]
[null,"Plastic/Metal Pouch",0,0,9.9999999999999997E+98,{"$error":"#DIV/0!"},0,0]

{"sheet":"List","index":10,"n_rows":43,"n_cols":25,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
["Product Category",null,"Product Sub-Category - Wine",null,"Product Base - Cooler",null,"Vendor Quote",null,"Container Type",null,"Seasonal Gift Pack?",null,"Origin",null,"Sourced From - Domestic",null,"Region - Canada",null,"Duty Status",null,"Trade Agreement",null,"Distributor",null,"Production - Refreshment/Spirit/Liqueur/Wine"]
["Wine",null,"Table Wine",null,"Spirit/Liqueur",null,"per Case",null,"Aluminum Can",null,"Yes",null,"Domestic",null,"Canada",null,"Alberta - Calgary",null,"Duty Deferred",null,"Yes",null,"SLGA",null,"<25,000 L"]
["Spirit",null,"Sparkling Wine",null,"Wine",null,"per Selling Unit",null,"Aluminum Pouch",null,"No",null,"Import",null,"USA",null,"Alberta - Lethbridge",null,"Duty Paid",null,"No",null,"Privately Distributed",null,"25,0001 to 50,000 L"]
["Liqueur",null,"Dessert/Fortified Wine",null,"Malt",null,null,null,"Aseptic Carton",null,null,null,null,null,"Other",null,"Alberta - St. Albert",null,null,null,null,null,null,null,"50,001 to 75,000 L"]
["Refreshment",null,"Fruit Wine/Sake",null,null,null,"Unit Size",null,"Bag-in-Box",null,null,null,null,null,null,null,"British Columbia - Kelowna",null,null,null,null,null,null,null,"75,001 to 100,000 L"]
["Beer",null,"Flavoured & Other",null,null,null,"per Selling Unit",null,"Keg",null,null,null,"Tariff",null,null,null,"British Columbia - Oliver",null,null,null,null,null,null,null,"100,001 to 150,000 L"]
[null,null,"Non-Alcoholic",null,null,null,null,null,"Keg (No Deposit)",null,null,null,"Yes",null,null,null,"British Columbia - Vancouver & Area ",null,null,null,null,null,null,null,"150,001 to 200,000 L"]
[null,null,null,null,null,null,null,null,"Non-Refillable Glass",null,null,null,null,null,null,null,"Manitoba - Winnipeg",null,null,null,null,null,null,null,">200,000 L - National Producer"]
[null,null,"Product Sub-Category - Spirit",null,null,null,null,null,"PET",null,null,null,null,null,null,null,"Ontario - Brampton"]
[null,null,"Whiskey",null,null,null,null,null,"Refillable Glass",null,null,null,null,null,null,null,"Ontario - Toronto & Area",null,null,null,null,null,null,null,"Production - Beer"]
[null,null,"Brandy/Cognac",null,null,null,null,null,null,null,null,null,null,null,null,null,"Ontario - Walkerville",null,null,null,null,null,null,null,"<2,500 HL"]
[null,null,"Tequila",null,null,null,null,null,null,null,null,null,null,null,null,null,"Quebec - Montreal/Valleyfield",null,null,null,null,null,null,null,"2,501 - 30,000 HL"]
[null,null,"Gin",null,null,null,null,null,null,null,null,null,null,null,null,null,"Saskatchewan - Blaine Lake",null,null,null,null,null,null,null,"30,001 - 50,000 HL"]
[null,null,"Rum",null,null,null,null,null,null,null,null,null,null,null,null,null,"Saskatchewan - Regina",null,null,null,null,null,null,null,"50,001 - 100,000 HL"]
[null,null,"Vodka",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"100,001 - 150,000 HL"]
[null,null,"Miscellaneous",null,null,null,null,null,null,null,null,null,null,null,null,null,"Region - USA",null,null,null,null,null,null,null,"150,001 - 200,000 HL"]
[null,null,"Non-Alcoholic",null,null,null,null,null,null,null,null,null,null,null,null,null,"Arkansas - Fort Smith",null,null,null,null,null,null,null,"200,001 - 250,000 HL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"California - Modesto",null,null,null,null,null,null,null,"250,001 - 300,000 HL"]
[null,null,"Product Sub-Category - Liqueur",null,null,null,null,null,null,null,null,null,null,null,null,null,"California - Other",null,null,null,null,null,null,null,"300,001 - 350,000 HL"]
[null,null,"Liqueur",null,null,null,null,null,null,null,null,null,null,null,null,null,"Illinoism - Bolingbrook",null,null,null,null,null,null,null,"350,001 - 400,000 HL"]
[null,null,"Non-Alcoholic",null,null,null,null,null,null,null,null,null,null,null,null,null,"Indiana - Lawrenceburg",null,null,null,null,null,null,null,"400,001 - 450,000 HL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kentucky - Clermont",null,null,null,null,null,null,null,"450,001 - 500,000 HL"]
[null,null,"Product Sub-Category - Refreshment",null,null,null,null,null,null,null,null,null,null,null,null,null,"Kentucky - Frankfort/Lawrenceburg",null,null,null,null,null,null,null,">500,000 HL - National Producer"]
[null,null,"Cooler",null,null,null,null,null,null,null,null,null,null,null,null,null,"Kentucky - Louisville"]
[null,null,"Cider",null,null,null,null,null,null,null,null,null,null,null,null,null,"Minnesota - Minneapolis"]
[null,null,"Non-Alcoholic",null,null,null,null,null,null,null,null,null,null,null,null,null,"New York - Batavia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New York - Canandaigua"]
[null,null,"Product Sub-Category - Beer",null,null,null,null,null,null,null,null,null,null,null,null,null,"New York - Westfield"]
[null,null,"Beer"]
[null,null,"Non-Alcoholic",null,null,null,null,null,null,null,null,null,null,null,null,null,"Region - Other"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Australia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Belgium"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chile"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Denmark"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"France"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Germany"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ireland"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Italy"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netherlands"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"South Africa"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spain"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"United Kingdom (Scottish Port)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"United Kingdom (UK Port)"]