{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Barcoder"],"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":"Barcoder","index":0,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["NYAB Barcode Generator (Code128)"]
[]
[]
["This form will generate a unique NYAB receiving dock barcode for both Direct and Indirect suppliers.  "]
[]
["Please enter the following information:","Data Entry Column:"]
[]
["1) Delivery note number (Packing Slip Number) of the Supplier.","MH14194",{"$f":"IsAlphaNumeric(B8)","v":true}]
["- If alphanumeric, only capital letters are allowed."]
[]
[]
["2) NYAB purchase order number (without purchasing group attached)",6500054271]
["- 10 digits, numeric values only"]
[]
[]
["3) NYAB purchase order line item (not the delivery line item) ",11]
["- Numeric values only, 5-digit maximum"]
["- PO line items (Materials with NYAB P/N’s) starts with 10 or 20 not 1 or 2"]
["- MRO (tools, operating supplies) PO line items start with line 1, 2 etc."]
[]
[]
["4) Delivered quantity in NYAB unit of measurement",10.5]
["- Numeric values only - no unit of measurement"]
["- Commas and decimal points are allowed"]
[]
["5) Generate Barcode"]
["- Click on Generate Barcode to Desktop button"]
["- Click OK when box pops up"]
[]
["NYAB Barcode"]
[{"$f":"IF(B22=\"\",\"\",Code128_Str(A32))","v":"ÑMHÌ.3Í4#ÌaÔ%JgÍ#11#10.5)Ó"}]
[{"$f":"IF(B$8=\"\",\"\",(CONCATENATE(B$8,\"#\",B$12,\"#\",B$16,\"#\",B$22)))","v":"MH14194#6500054271#11#10.5"}]