CNG Conversion 23 - Item Export ~1.xlsx

XLSX spreadsheet 20 KB Posted

Attached to
CNG CONVERSION SYSTEM FOR LIGHT AND MEDIUM DUTY TRUCKS (MULTI-YEAR)
Solicitation number
FM-23-301
Issued by
California

About this file

This is an item export spreadsheet for a CNG Conversion System procurement for light and medium duty trucks in California. The file contains a standardized template for uploading vehicle line items to be included in a multi-year contract opportunity. The procurement encompasses 20 distinct Ford vehicle configurations across three primary truck series: F-250, F-350, and F-550. These vehicles are available in multiple cab styles (regular cab, super cab, and crew cab) and drivetrain options (2WD and 4WD where applicable), with five units of each configuration requested in the procurement. The vehicles include both traditional pickup bed configurations and service bed truck variants, all equipped with or converted to compressed natural gas (CNG) fuel systems. Each line item is designated with a quantity of 5 units measured in "EA" (each), and all items are noted as "In Progress" status within the system.

The spreadsheet serves as an instructional template for vendors responding to the procurement, detailing required data fields including item numbers (limited to four digits), print sequences, item types, descriptions, quantities, units of measure, cost information, discount structures, tax rates, NIGP class identifications, manufacturer details, and product specifications. All required fields must be completed with specific formatting requirements, and the final submission file must be saved in CSV format. The template does not display populated unit costs, discount percentages, or total pricing information in the provided export, indicating this may be a blank or example form distributed to potential bidders for standardizing their responses to the multi-year CNG conversion system contract opportunity.

View the file

Other files

File Type Posted
NOI to Award ITB FM-23-301.pdf PDF
7-01-2023 Appendix A - Multi Year Package Specs FY-23_~2.docx DOCX document
ITB Attachments~3.pdf PDF
Bid Recap.xlsx XLSX spreadsheet
ITB FM-23-301 Addendum 2 .pdf PDF
7-03-2023 CNG Conversion Specs Appendix B.docx DOCX document
ITB FM-23-301 Addendum .pdf PDF
ITB FM 23-301 CNG Conversion Review~3.pdf PDF

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

Item_Export_Upload_Example_inst

Item NumberPrint SequenceItem TypeStock Item NumberDescriptionDisable Pricing on QuoteFixed AssetQuantityUOMUnit CostDiscount %Total Discount AmountNet Unit CostTax RateNIGP Class IDNIGP Class ItemCommodity CodeManufacturerBrandModelMakePackagingProduct lengthProduct widthProduct heightProduct weightUPC/ISBNSKUTagsURLItem Status
FORD F-250 XL, 2WD SUPER CAB PICK UP, CNG5EA00In Progress
FORD F-250, 2WD CREW CAB PICK UP, CNG5
FORD F-250, 4WD REGULAR CAB PICK UP, CNG5
FORD F-250, 4WD SUPER CAB PICK UP, CNG5
FORD F-250, 4WD CREW CAB PICK UP, CNG5
FORD F-350, 2WD REGULAR CAB PICK UP, CNG5
FORD F-350, 2WD REGULAR CAB PICK UP, CNG5
FORD F-350, 2WD SUPER CAB PICK UP, CNG5
FORD F-350, 4WD REGULAR CAB PICK UP, CNG5
FORD F-350, 4WD SUPER CAB PICK UP, CNG5
FORD F-350, 4WD CREW CAB PICK UP, CNG5
FORD F-350, 4WD CREW CAB PICK UP, CNG5
FORD F-250 REGULAR CAB SERVICE BED TRUCK, CNG5
FORD F-250 SUPER CAB SERVICE BED TRUCK, CNG5
FORD F-250, CREW CAB SERVICE BED TRUCK, CNG5
FORD F-350, REGULAR CAB SERVICE BED TRUCK, CNG5
FORD F-350 SUPER CAB SERVICE BED TRUCK, CNG5
FORD F-350, CREW CAB SERVICE BED TRUCK, CNG5
FORD F-550, REGULAR CAB SERVICE BED TRUCK, CNG5
FORD F-550, SUPER CAB SERVICE BED TRUCK , CNG5
FORD F-550, CREW CAB SERVICE BED TRUCK, CNG5

INSTRUCTIONS ON COMPLETING AN ITEM UPLOAD:

Required FieldsMust Contain
Item Numberunique, numeric value no greater than 4 digits
Print Sequencenumeric value equal to 'Item Number'
Item Typemust be the letter 'I'
Descriptionalphanumeric
Quantitynumeric value
Unit of MeasureReference tab below
NIGP Class IDnumeric value, 3 digits
NIGP Class Itemnumeric value, 2 digits

File must be saved as a csv

File details come from the government source that posted it. Updated .