DOCSERVER (1).xls

XLS spreadsheet 2 MB Posted Jul 7, 2015

Attached to: 1130-16-R-NBID-00040
Solicitation number: 3130000201
Issued by: Jasper County, Mississippi

About this file

Written by GovTribe AI · Jan 6, 2025

This is a template spreadsheet file from the Mississippi Office of Purchasing, Travel and Fleet Management (OPTFM) for suppliers to submit product information for outboard motors. The file provides detailed instructions for vendors to input required data fields including supplier information, part numbers, product descriptions, pricing, NIGP codes, delivery terms, and manufacturer details. The template appears to be part of solicitation #1130-16-R-NBID-00040 for a negotiated contract for outboard motors.

The spreadsheet requires suppliers to provide both MSRP and discounted contract pricing, with amounts in USD to two decimal places. Technical requirements include unique supplier part numbers, character limits on description fields, mandatory manufacturer website links, and standardized unit of measure codes. The file emphasizes strict enforcement of data validation rules, particularly regarding duplicate entries and character limits across multiple fields. Base quantities are set at 1 unit, and delivery terms must be specified as a maximum number of days rather than a range.

View the file

Other files

File	Type	Posted
DOCSERVER (1).doc.crdownload	CRDOWNLOAD file	Jul 7, 2015
DOCSERVER (1).xlsx	XLSX spreadsheet	Jul 7, 2015
DOCSERVER (1).doc	DOC document	Jul 7, 2015
DOCSERVER.docx	DOCX document	Jul 7, 2015
DOCSERVER (1).xls.crdownload	CRDOWNLOAD file	Jul 7, 2015
DOCSERVER (1).docx	DOCX document	Jul 7, 2015
DOCSERVER.xls	XLS spreadsheet	Jul 7, 2015
DOCSERVER.xlsx	XLSX spreadsheet	Jul 7, 2015
DOCSERVER.doc	DOC document	Jul 7, 2015
DOCSERVER (2).xlsx	XLSX spreadsheet	Jul 7, 2015

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Instructions

	Sort	Field	Usage	Required/
Optional	Field Type	Explanation/ Values	Examples
	1	Supplier	Supplier Name	Required	CHAR(50)	Name of Company	ABC Outboard Motors Company
	2	Supplier ID	Supplier ID	Required	CHAR(10)	See Proposal, Format & Guidelines	3100031110
	3	Supplier Part Number	Supplier Part Number	Required	CHAR(50)	Supplier Part Number	ABC20131500
	4	Short Description	Short Description	Required	CHAR(99)	Short Description; Line Item Details; Include any special information such as packaging	Outboard Motors, Gasoline, 2 stroke
	5	Long Description	Long Description	Required	CHAR(2000)	Full long description	Outboard Motors, Gasoline, 2 stroke, oil injected
	6	Product Group	NIGP 5 digit code	Required	CHAR(5)	5 Digit NIGP Classification code; Must use from list provided in NIGP Choices Tab	34000
	7	Price	Discounted Price	Required	Real	Amount with 2 decimal places	$285.30
	8	MSRP	MSRP Price	Required	Real	MSRP Amount with 2 decimal places	$360.50
	9	Special Search Terms	Search terms, tags	Required	CHAR(100)	Searchable term to identify your items	Outboard Motors
	10	Delivery In Days	Delivery days	Required	Integer	Delivery Days	5
	11	UOM	Unit of Measure	Required	CHAR(3)	Base unit of measure (refer to tab UOM)	EA
	12	Hyperlink URL	Hyperlink URL	Required		Value = Manufacturer website	www.outboardmotors.com
	13	Manufacturer	Manufacturer Name	Required		Name of the Manufacturer	ABC Outboard Motors
	14	Manufacturer PN	Manufacturer Part Number	Required	CHAR(50)	Manufacturer Part Number	10369
		Field	Further Explanation
		Supplier	This field is for the Supplier. If you are a business dealing on behalf of a Manufacturer, the MANUFACTURER name goes in this field.
		Supplier ID	This number comes from OPTFM. If you are unsure of your Supplier ID, Please Call OPTFM at 601-359-3409. If you are authorized to deal on behalf of a Manufacturer, the MANUFACTURER'S supplier ID goes in this field. This is an unique field. This means that no duplicate information is allowed in the ENTIRE column.
		Supplier Part Number	The part numbers in this column can match the part numbers in the Manufacturer Part Number column; however, in the Supplier Part Number Column all values have to be unique. This means that no duplicate information is allowed.
		Short Description	This field provides a short description for the product being offered. Only 99 Characters will be allowed in this field. This is an unique field. This means that no duplicate information is allowed in the Entire Column. Please also include packaging information.
		Product Group	Use the NIGP Choices tab to populate the product group column sheet 1.
		Delivery in Days	This column should contain the MAX number of days that it will take for the line item to get to the purchaser. DO NOT INPUT A RANGE OF DAYS.
		Hyperlink URL	This is the preferred method is to send us the link to your website where the image of the line item can be viewed.
		Notes
		1.) The above spreadsheet is an example of how Sheet 1 should look once completed.
		2.) Populate Tab "Sheet1" with your data.
		3.) Do NOT change the name of the Tabs - other than Sheet 1 to reflect the Manufacturer Name.
		4.) See Examples column for ideas.
		5.) CHAR(#) - the allotted amount of characters for that field. This is strictly enforced.
		6.) If a cell appears to have this formatting (Red Highlighted Cell with Data in cell in Red font color), that cell contains duplicate information. Please change this information so that each cell in the column is unique. THIS IS STRICTLY ENFORCED.

www.outboardmotors.com

Sheet1

Supplier

Supplier ID

Supplier Part Number

Short Description

Long Description

Product Group

Service Item

Contract Price

MSRP

Price Base Qty

Currency

Contract Number

Contract Item ID

SAP Contract Item Category

Special Search Terms

Delivery In Days

UOM

Price Base Qty UOM

Image

Item Status

Hyperlink Type

Hyperlink MIME Type

Hyperlink URL

Hyperlink URL Description

Manufacturer

Manufacturer PN

Supplier Catalog Name