{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Main","Data","Head","Import","Config","Help","Export"],"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":"Main","index":0,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Click Enable Content or answer Yes/OK if prompted about macros"]
[]
[]
[null,null,"LCV Wholesale Sales Reporting CSV File Builder"]

{"sheet":"Data","index":1,"n_rows":1,"n_cols":36,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Licence Number","Postcode","Beer Low <=48 Ltrs $","Beer Low <=48 Ltrs Vol","Beer Low >48 Ltrs $","Beer Low >48 Ltrs Vol","Beer Medium <=48 Ltrs $","Beer Medium <=48 Ltrs Vol","Beer Medium >48 Ltrs $","Beer Medium >48 Ltrs Vol","Beer Heavy <=48 Ltrs $","Beer Heavy <=48 Ltrs Vol","Beer Heavy >48 Ltrs $","Beer Heavy >48 Ltrs Vol","Wine Small <2.0 Ltrs $","Wine Small <2.0 Ltrs Vol","Wine Large >= 2 Ltrs <= 20 Ltrs $","Wine Large >= 2 Ltrs <= 20 Ltrs Vol","Wine Bulk > 20 Ltrs $","Wine Bulk > 20 Ltrs Vol","Wine Bulk For bottling elsewhere or blending $","Wine Bulk For bottling elsewhere or blending Vol","Fortified Wine Small <2.0 Ltrs $","Fortified Wine Small <2.0 Ltrs Vol","Fortified Wine Large >= 2 Ltrs <= 20 Ltrs $","Fortified Wine Large >= 2 Ltrs <= 20 Ltrs Vol","Fortified Wine Bulk > 20 Ltrs $","Fortified Wine Bulk > 20 Ltrs Vol","Fortified Wine Bulk For bottling elsewhere or blending $","Fortified Wine Bulk For bottling elsewhere or blending Vol","Spirits Standard $","Spirits Standard Vol","Spirits Ready to Drink $","Spirits Ready to Drink Vol","Cider $","Cider Vol"]

{"sheet":"Head","index":2,"n_rows":30,"n_cols":36,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
["Beer Low <=48 Ltrs ","Beer","C","D",null,null,null,"Beer","Y","C,D,E,F,G,H,I,J,K,L,M,N"]
["Beer Low >48 Ltrs ","Beer","E","F",null,null,null,"Wine","Y","O,P,Q,R,S,T,U,V,W,X,Y,Z,AA,AB,AC,AD"]
["Beer Medium <=48 Ltrs ","Beer","G","H",null,null,null,"Spirits","Y","AE,AF,AG,AH"]
["Beer Medium >48 Ltrs ","Beer","I","J",null,null,null,"Cider","Y","AI,AJ"]
["Beer Heavy <=48 Ltrs ","Beer","K","L"]
["Beer Heavy >48 Ltrs ","Beer","M","N"]
["Wine Small <2.0 Ltrs","Wine","O","P"]
["Wine Large >= 2 Ltrs <= 20 Ltrs ","Wine","Q","R"]
["Wine Bulk > 20 Ltrs ","Wine","S","T"]
["Wine Bulk For bottling elsewhere or blending ","Wine","U","V"]
["Fortified Wine Small <2.0 Ltrs","Wine","W","X"]
["Fortified Wine Large >= 2 Ltrs <= 20 Ltrs ","Wine","Y","Z"]
["Fortified Wine Bulk > 20 Ltrs ","Wine","AA","AB"]
["Fortified Wine Bulk For bottling elsewhere or blending ","Wine","AC","AD"]
["Spirits Standard ","Spirits","AE","AF"]
["Spirits Ready to Drink ","Spirits","AG","AH"]
["Cider ","Cider","AI","AJ"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Licence Number","Postcode","Beer Low <=48 Ltrs $","Beer Low <=48 Ltrs Vol","Beer Low >48 Ltrs $","Beer Low >48 Ltrs Vol","Beer Medium <=48 Ltrs $","Beer Medium <=48 Ltrs Vol","Beer Medium >48 Ltrs $","Beer Medium >48 Ltrs Vol","Beer Heavy <=48 Ltrs $","Beer Heavy <=48 Ltrs Vol","Beer Heavy >48 Ltrs $","Beer Heavy >48 Ltrs Vol","Wine Small <2.0 Ltrs $","Wine Small <2.0 Ltrs Vol","Wine Large >= 2 Ltrs <= 20 Ltrs $","Wine Large >= 2 Ltrs <= 20 Ltrs Vol","Wine Bulk > 20 Ltrs $","Wine Bulk > 20 Ltrs Vol","Wine Bulk For bottling elsewhere or blending $","Wine Bulk For bottling elsewhere or blending Vol","Fortified Wine Small <2.0 Ltrs $","Fortified Wine Small <2.0 Ltrs Vol","Fortified Wine Large >= 2 Ltrs <= 20 Ltrs $","Fortified Wine Large >= 2 Ltrs <= 20 Ltrs Vol","Fortified Wine Bulk > 20 Ltrs $","Fortified Wine Bulk > 20 Ltrs Vol","Fortified Wine Bulk For bottling elsewhere or blending $","Fortified Wine Bulk For bottling elsewhere or blending Vol","Spirits Standard $","Spirits Standard Vol","Spirits Ready to Drink $","Spirits Ready to Drink Vol","Cider $","Cider Vol"]

{"sheet":"Import","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Config","index":4,"n_rows":3,"n_cols":28,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Your product identifier","VCGLR Category",null,"Last Import Heads",null,"2023-12-15",null,null,"Your licence identifier","LCV licence number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SameInOutLic","N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SameInOutProd","N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SameInOutprod","N"]

{"sheet":"Help","index":5,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["About the LCV Wholesale Sales Reporting CSV File Builder","Help for importing sales data","Step 1 – file selection.","Step 2 - column allocation.","Step 3 - Recipient licence translation","Step 4 - Product translation"]
["This CSV builder provides you with an easy way to enter your sales data for the prior financial year.","You can import your sales data using an Excel workbook file, CSV file, or other delimited text file.","The file being imported must have at least 5 data columns:","The selected file is read and checked. If it is valid and can be processed, the application will attempt to recognise the columns for licence number, postcode and product.","A list of your recipient licence identifiers will be shown."," A list of your product identifiers will be shown."]
["When you have finished you can have the application generate a CSV file in the required format ready to upload to the LCV Wholesale Sales portal.","The import process includes translating your recipient licensee identifiers to LCV licence numbers and product names to LCV categories.  If you want to use LCV product categories in your data file, use the link on this page to get a list of the values.","·         Recipient licence number","You can then change any column allocations. For each of the 5 columns, select the drop down value for the column in your data that corresponds to the heading above the drop down.","If your data already has LCV licence numbers, just click 'Same In/Out'.","If your data already has LCV product categories, just click 'Same In/Out'."]
["Options:","There are basically five steps to completing your import.","·         Recipient post code","When you are happy with all five column selections, click Next.","Otherwise…","Note that LCV categories in your data must correspond to the values listed in the categories drop down. To get a list, click the link below."]
["     Import sales - Import your sales data using an Excel, CSV or other delimited text file. The process includes translating your own recipient licence and product identifiers to LCV values. If you want to use LCV product categories in your data file, use the link on this page to get a list of the values.","1. Compile your data into a file.","·         Product (can be your product name or code)","This will read your data file into a temporary location ready for the next step - recipient licence and product translations.","For any that have a blank LCV value, you click on the item to display it under ‘For my licence number/identifier’.","Otherwise…"]
["     Add new sales - Click to add a new sales record; on the Add form complete your data entry, then click Add.","The file can be an Excel workbook, a CSV format file, or a text file with a specific delimiter.","·         Dollar value",null,"Then you must either select a value from LCV drop down and click Save, or enter a new value and click Add.","For any that have a blank LCV value, you click on the item to display it under ‘For product’."]
["     Edit selected - Select (click on) an item and then click ‘Edit selected’ to view and change the data.","The file must contain at least five fields - recipient licence identifier, recipient post code, product identifier, sales value and sales litres. ","·         Litre value.",null,"When you add new LCV licence numbers, they are saved in case you repeat the import.","Then you must select a category value from LCV drop down and click Save."]
["     Delete selected - Select (click on) an item and then click ‘Delete selected’ to delete an item.","You do not need to summarise your data.","You do not need to summarise your data.",null,"Keep going until you have no blank LCV values.","Keep going until you have no blank LCV values."]
["     Clear all data - Clear ALL your data. Only do this if you have it so wrong you want to start again.","2. Specify the type of file you are importing, and then locate and select the file.","You must specify the type of file you are importing - Excel file, CSV file, delimited text file.",null,"If you have a file containing a list of your recipient  licence identifiers and LCV licences, you can import them in bulk as long as the file is an Excel workbook or CSV text file."]
["As you add or change sales records, you will see a grand total at the bottom of the sales list. You can use this to verify that you have completed your sales entries accurately.","3. Confirm the column allocations for licence number, postcode, product, sales dollars and sales litres.","For the latter, you must specify the delimiting character.",null,"Column A must contain your licence identifiers. Column B must contain 8 digit LCV licence numbers.","You will be able to import your data only when there are no blank LCV categories in the list."]
["WHEN YOU HAVE FINISHED you can click ‘Produce CSV’ to generate a CSV file that is in the format required for uploading your sales into the LCV Wholesale Sales Portal web site.","4. Set any translations from your recipient licencee identifiers to LCV licence numbers.","Then you must locate and select the file."]
["You will be prompted for the folder in which to save the CSV file.","5. Set any translations from your product identifiers to LCV categories.","Once the file is selected it will be evaluated and you can move on to step 2.",null,"You will be able to import your data only when there are no blank LCV licences in the list.","Also note that your translation settings will be saved for any subsequent imports."]
["WHEN YOU WANT TO EXIT THE CSV BUILDER click Exit.","6. Proceed with importing your sales data."]
[null,"For each of these steps there is further help available by clicking the ‘?’ button.",null,null,"Also note that your translation settings will be saved for any subsequent imports."]

{"sheet":"Export","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}