Instuctions for spreadsheet.doc

This is an instruction document from the State of Maine regarding the completion of a catalog template spreadsheet for vendor contract uploads into the AdvantageME system. The document provides detailed formatting guidelines for vendors submitting product and service catalogs for state procurement. The spreadsheet template is pre-formatted to ensure compatibility with the AdvantageME upload system, and vendors are explicitly instructed not to alter the spreadsheet's structure or delete optional columns. The document specifies the required fields, optional fields, and data types for each column in the catalog template.

The spreadsheet requires vendors to complete 23 columns of information, including mandatory fields such as Supplier Part Number (formatted as text), Supplier Name, Commodity Code (using 5-digit NIGP codes), Item Description, Extended Description (up to 1,500 characters), Unit of Measure, and List Price (formatted as a number with 14 digits before and 6 after the decimal point). Optional fields include Manufacturer Name, Manufacturer 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. Units of Measure must be selected from a separate Unit_of_Measure.xls file, and commodity codes must reference the NIGP Codes available on Maine's purchases website. Picture file names may be included if vendors have images associated with their contract items.