Instuctions for spreadsheet.doc

This is an instructional document from the State of Maine outlining the requirements for completing a catalog template spreadsheet necessary for vendor contract uploads into the AdvantageME system. The document specifies that vendors must complete and return the accompanying Catalog_Template.xls Microsoft Excel spreadsheet without making any modifications to its established format or deleting optional columns. The spreadsheet format is designed to align precisely with AdvantageME's system requirements, ensuring proper data integration for contract loading.

The spreadsheet contains 20 columns with specific data field requirements, including mandatory fields such as Supplier Part Number (formatted as text), Supplier Name, Commodity Code (formatted using NIGP 5-digit codes available at the Maine purchasing website), Item Description, Extended Description (up to 1,500 characters), Unit of Measure (selected from an attached Unit_of_Measure.xls file), and List Price (numeric format with 14 digits before and 6 after the decimal point). Optional fields include Manufacturer Name and Part Number, Product/Category, Model, Drawing, Piece, Serial Number, Specifications, Size, Color, and Picture File Name. The Vendor Customer Code column must be left blank for completion by the State of Maine buyer. All text fields have specified character limits, and vendors are instructed to include picture file names only if images are available for their contract offerings.