DOCSERVER (1).xls

XLS spreadsheet 2 MB Posted Nov 2, 2015

Attached to: 1130-16-R-NBID-00007-V01
Solicitation number: 3130000250
Issued by: Mississippi

About this file

Written by GovTribe AI · Jan 6, 2025

This is an Excel template file provided by the Mississippi Office of Purchasing, Travel and Fleet Management (OPTFM) for suppliers to submit product information for Incontinence Care Products (formerly Adult and Children's Disposable Briefs). The submission deadline is December 15, 2015 at 5:00 PM CT. The template requires detailed product information including supplier name, supplier ID, part numbers, descriptions, NIGP codes, pricing, delivery timeframes, and manufacturer details.

The file specifies formatting requirements for pricing submissions, with fields for both discounted contract price and MSRP to be entered with two decimal places in USD. All entries must be unique within their respective columns, with no duplicate information allowed. The template includes validation rules and formatting that highlights duplicate entries in red. Suppliers must provide manufacturer website links for product images and specifications, and delivery times must be specified as a maximum number of days rather than a range.

View the file

Other files

File	Type	Posted
DOCSERVER (1).xls.crdownload	CRDOWNLOAD file	Nov 2, 2015
DOCSERVER (1).xlsx.crdownload	CRDOWNLOAD file	Nov 2, 2015
DOCSERVER (1).pdf.crdownload	CRDOWNLOAD file	Nov 2, 2015
DOCSERVER.xlsx	XLSX spreadsheet	Nov 2, 2015
DOCSERVER (1).pdf	PDF	Nov 2, 2015
DOCSERVER.xls	XLS spreadsheet	Nov 2, 2015
DOCSERVER.pdf	PDF	Nov 2, 2015
DOCSERVER (2).pdf	PDF	Nov 2, 2015
DOCSERVER (1).xlsx	XLSX spreadsheet	Nov 2, 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 Incontinence Care
	2	Supplier ID	Supplier ID	Required	CHAR(10)	See Proposal, Format & Guidelines	3000000121
	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	Incontinence Care
	5	Long Description	Long Description	Required	CHAR(2000)	Full long description	Incontinence Care Products
	6	Product Group	NIGP 5 digit code	Required	CHAR(5)	5 Digit NIGP Classification code; Must use from list provided in NIGP Choices Tab	02066
	7	Price	Discounted Price	Required	Real	Amount with 2 decimal places	$87.50
	8	MSRP	MSRP Price	Required	Real	MSRP Amount with 2 decimal places	$102.00
	9	Special Search Terms	Search terms, tags	Required	CHAR(100)	Searchable term to identify your items	Skin Cream, Briefs, Diapers
	10	Delivery In Days	Delivery days	Required	Integer	Delivery Days	60
	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.Incontinencecare.com
	13	Manufacturer	Manufacturer Name	Required		Name of the Manufacturer	ABC Incontinence Care
	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.Incontinencecare.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