Instuctions for spreadsheet.doc
DOC document 44 KB Posted
- Attached to
- Printing, Letterhead Statioary
- Solicitation number
- RFQ - 18P - 07100900000000000297
- Issued by
- Kennebec County, Maine
About this file
This file provides instructions for completing a catalog template spreadsheet required by the State of Maine to load vendor contract information into the AdvantageME procurement system. The document outlines the specific format and data requirements for submitting product catalogs related to a Printing and Letterhead Stationery contract opportunity. Vendors must complete the Catalog_Template.xls spreadsheet without altering its format or deleting optional columns, ensuring data integrity for system upload.
The spreadsheet template includes 20 fields with specific requirements for data entry. Required fields include Supplier Part Number (formatted as text, 32 characters maximum), Supplier Name (60 characters), Commodity Code using NIGP 5-digit codes (alpha numeric, 5 characters), Item Description (60 characters), Extended Description (1500 characters), Unit of Measure selected from an attached reference file (4 characters), and List Price (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 (255 characters). The Vendor Customer Code field must be left blank for completion by the State of Maine Buyer. Vendors are directed to reference the NIGP Codes resource available on the Maine Department of Purchases website for proper commodity code classification.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| LetterheadQuoteOct07.rtf | RTF text file | |
| LetterheadSpreadsheet.xls | XLS spreadsheet | |
| Clauses Extenison Overrun 3.doc | DOC document | |
| Conditions and Instructions to Bidders.doc | DOC document |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Accompanying this memo is the Catalog_Template.xls Microsoft Excel spreadsheet you need to complete and return to us to load your contract into AdvantageME. The spreadsheet is set up in the exact format necessary to upload it into the system, so it is important that no changes are made to the spreadsheet’s format. Please DO NOT delete any of the optional columns if they will not be used. The following chart provides guidelines to complete the spreadsheet.
| Excel Column |
| Optional/Required |
| Field Type |
| Field Size (in characters) |
| Vendor Customer Code * |
| Leave Blank |
| Alpha Numeric |
| 20 |
| Supplier Part Number ** |
| Required |
| Text |
| 32 |
| Supplier Name |
| Required |
| Alpha Numeric |
| 60 |
| Manufacturer Name |
| Optional |
| Alpha Numeric |
| 25 |
| Manufacturer Part Number |
| Optional |
| Alpha Numeric |
| 25 |
| Commodity Code *** |
| Required |
| Alpha Numeric |
| 5 |
| Item Description |
| Required |
| Alpha Numeric |
| 60 |
| Extended Description |
| Required |
| Alpha Numeric |
| 1500 |
| Unit of Measure **** |
| Required |
| Alpha Numeric |
| 4 |
| List Price |
| Required |
| Number |
| 14 before and 6 after decimal pt |
| Deliver Days |
| Required |
| Number |
| 10 |
| Product / Category |
| Optional |
| Alpha Numeric |
| 25 |
| Model |
| Optional |
| Alpha Numeric |
| 25 |
| Drawing |
| Optional |
| Alpha Numeric |
| 25 |
| Piece |
| Optional |
| Alpha Numeric |
| 25 |
| Serial Number |
| Optional |
| Alpha Numeric |
| 25 |
| Specifications |
| Optional |
| Alpha Numeric |
| 25 |
| Size |
| Optional |
| Alpha Numeric |
| 25 |
| Color |
| Optional |
| Alpha Numeric |
| 25 |
| Picture File Name ***** |
| Optional |
| Alpha Numeric |
| 255 |
Leave blank. State of Maine Buyer will complete this column
Format as text, even if the Supplier Part Number contains only numbers
See NIGP Codes (5-digit) at: http://www.maine.gov/purchases/vendorinfo/vss.htm
(Note: Use 3-digit Class plus 2-digit Item to equal 5-digit Code.)
Select Units from the attached Unit_of_Measure.xls file Add picture file name only if you have images for the contract
File details come from the government source that posted it. Updated .