7720123150Instructions.pdf
PDF 266 KB Posted
- Contract number
- Not on record
- Issued by
- New York
About this file
This document provides technical instructions for contractors participating in New York State's IFSSS (Information Technology Umbrella Contract) Equipment Product Search Tool process. The instructions are issued by the New York State Office of General Services (OGS) to contractors holding pricing workbooks under contract number 7720123150PL. The document guides contractors through a multi-step process to integrate an Equipment Cheat Sheet containing prohibited items into their pricing workbooks, requiring coordination with OGS Procurement Services for unprotected file copies.
The instructions focus on IT equipment and services procurement, specifically detailing how contractors must use Excel-based tools to cross-reference their proposed products against a master list of prohibited items. Contractors must download the Equipment Cheat Sheet, create connections between their pricing workbooks and the prohibited items database, and implement specific formulas to flag items for removal. The process culminates in contractors submitting updated pricing pages that clearly identify prohibited items marked as "Yes" while maintaining all flagged items in their submissions. The document emphasizes that contractors cannot remove or filter out flagged items and must submit their final pricing workbooks as part of contract update requests to OGS.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 7720123150AppendixC.pdf | ||
| 7720123150HowToUse.pdf | ||
| 7720123150ContractorPage.pdf | ||
| 7720123150CraneVehicle.xlsx | XLSX spreadsheet | |
| 7720123150Distributors.xlsx | XLSX spreadsheet | |
| 7720123150History.pdf | ||
| 7720123150ProjectChecklist.xlsx | XLSX spreadsheet | |
| 7720123150ra.pdf | ||
| 7720123150Attachment1.xlsx | XLSX spreadsheet | |
| 7720123150CheatSheet.xlsx | XLSX spreadsheet | |
| 7720123150ProductLines.xlsx | XLSX spreadsheet | |
| 7720123150pm.pdf |
Show all 12
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
IFSSS - PL Equipment Product Search Tool Instructions
1. Download the Equipment Cheat Sheet (will be needed in step 4)
(Unless you specified where to save the file, it will most likely automatically save in your “Downloads” folder.)
2. Open your Pricing Workbook (“7720123150PL_”)
(OGS PS will provide an unprotected copy: send request to OGS.sm.SST_security@ogs.ny.gov)
3. Add a new tab/worksheet to the same file. Be Sure to name the tab Product Cheat Sheet (not Equipment Cheat
Sheet as it appears that when OGS previously named as Product Cheat Sheet, it cannot be further amended).
4. The following Instructions are for making a connection to the Equipment Cheat Sheet which is for the listing of prohibited items.
a. In your Pricing Workbook (“7720123150PL_Contractor”) Select cell A1 in the new worksheet
b. In the above ribbon select Data
Click on Get Data
From File
From Workbook
c. Navigate to where the Equipment Cheat Sheet Master Copy file is saved
Select it and click Import.
5. A Navigator box will appear (see image below)
On the left-hand side: select Product Cheat Sheet.
On the bottom right: Then on the bottom of the same box there will be a Load button. Click on the down facing arrow next to it, which will pop up two selections – Load and Load to ---- select Load To…
6. An Import Data dialogue box will appear (see image below)
a. Be Sure Table is selected
b. Select Existing worksheet
In the box underneath type: ='Product Cheat Sheet'!$A$1
c. Click OK.
Once you click OK, the connection to the Product Cheat Sheet is now complete.
The Master Copy will now contain the same table that is within the Product Cheat Sheet.
7. Add a new column (if needed) in the Equipment Pricing tab (Column K).
a. In cell K4 type: “Remove?”
b. In cell K5: Copy and paste the formula below:
Be sure the formula appears in cell K5 exactly the same as it is below.
=INDEX('Product Cheat Sheet'!$E$2:$E$31000,MATCH(1,('Product Cheat
Sheet'!$A$2:$A$35000=$B5)*('Product Cheat Sheet'!$B$2:$B$35000=$C5),0))
c. DO NOT HIT ENTER
Instead press/hold the Ctrl+Shift+Enter keys (this will make the formula an array) If done correctly, brackets will appear at the beginning and at the end of the formula.
If you click on cell K5, the brackets will appear (see highlighted below):
{=INDEX('Product Cheat Sheet'!$E$2:$E$31000,MATCH(1,('Product Cheat
Sheet'!$A$2:$A$35000=$B5)*('Product Cheat Sheet'!$B$2:$B$35000=$C5),0))}
8. Drag this formula down far enough to cover all possible entries.
(Dragging the formula down will copy it into the cells)
9. If the item/term was flagged, it will be indicated as “Yes” and the reason for removal will appear.
If the item/term was not flagged, it will be marked “N/A”.
This is the end of the Contractors’ obligation to complete.
10. Please note the following:
• Please do not remove any of the “Yes” items, or filter out to only the “Yes”’ or “N/A”, etc.
• Once this and any other changes are completed by the Contractor, the file MUST be “Save As” and submit this file as their final Contractor’s Proposed Pricing Pages as part of the update request.
File details come from the government source that posted it. Updated .