{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["GTIN calculation tool","Range Values"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"GTIN calculation tool","index":0,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[16,6,22,7],[8,0,8,4],[9,0,9,4],[1,0,1,5],[3,0,3,14],[6,0,6,1],[7,0,7,1]]}
[]
["GTIN estimation calculator"]
[]
["This GTIN estimation sheet has been created to help you calculate how many GTINs you need for your products and therefore help you select the right membership plan. "]
[]
["How to use"]
["1. Enter the amount of product variations in the table below"]
["2. Your GTIN total will automatically be calculated"]
["3. A recommended membership plan will be highlighted based on your estimated GTINs and predicted range"]
["If you are close to using all the GTINs in a plan we would suggest choosing the next plan up to account for any future products you may release over the year."]
[]
["Product variable","Amount",null,null,null,null,"Recommended membership plan","No. of GTINs included"]
["Sizes",4,null,null,null,null,"Starter 10",10]
["Colours",3,null,null,null,null,"Starter 100",100]
["Styles",3,null,null,null,null,"Standard ","1000+"]
["Flavours",0]
["Scents",0,null,null,null,null,"Please note\nThis is an estimation only, based on the properties you enter to provide an idea of how many GTINs you will need.\n\nIf you need any extra help please contact member support on 0808 178 8799 or support@gs1uk.org"]
["Multipacks",0]
["Other variations",0]
[]
["Estimated number of GTINs",{"$f":"PRODUCT(IF(B13:B19>0,B13:B19,1))","v":36}]
["GTIN range value",{"$f":"IF(AND(B21>'Range Values'!$A$2,B21<'Range Values'!$B$2),'Range Values'!$C$2,(IF(AND(B21>'Range Values'!$A$3,B21<'Range Values'!$B$3),'Range Values'!$C$3,(IF(AND(B21>'Range Values'!$A$4,B21<'Range Values'!$B$4),'Range Values'!$C$4,(IF(AND(B21>'Range Values'!$A$5,B21<'Range Values'!$B$5),'Range Values'!$C$5,IF(AND(B21>'Range Values'!$A$6,B21<'Range Values'!$B$6),'Range Values'!$C$6,\"Additional GCP licence required\"))))))))","v":"10 - 100"}]

{"sheet":"Range Values","index":1,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Min","Max","Range value"]
[1,10,"1 - 10"]
[11,100,"10 - 100"]
[101,1000,"100 - 1,000"]
[1001,10000,"1,000 - 10,000"]
[10001,100000,"10,000 - 100,000"]