Instuctions for spreadsheet.doc

This is an instructional document from the State of Maine regarding the completion of a catalog spreadsheet template required for vendor contract uploads into the AdvantageME system. Vendors must complete the Catalog_Template.xls spreadsheet according to specified formatting requirements without altering the spreadsheet's structure or deleting optional columns. The document provides detailed guidelines for completing required and optional fields, including supplier part numbers, item descriptions, extended descriptions, units of measure, list pricing, and delivery timeframes. Required fields are clearly marked and include supplier part number, supplier name, item description, extended description, unit of measure, list price, and delivery days. Optional fields encompass vendor customer code, manufacturer information, commodity codes, product categories, specifications, dimensions, colors, and image file names.

The spreadsheet template maintains strict formatting standards with specified character limits for each field and data types including alpha-numeric, text, and numeric entries. Supplier part numbers must be formatted as text with no duplicate entries allowed. List prices require a 14-character field with 6 decimal places, while delivery days allow up to 10 characters. Vendors are directed to reference NIGP 5-digit commodity codes from the State of Maine purchasing website and to select units of measure from an attached Unit_of_Measure.xls file. The State of Maine Buyer will complete the vendor customer code column if left blank by the supplier. Picture file names may be included only if vendors have associated product images, with a maximum field size of 255 characters.