Exhibit 4-Instructions for Colorado FY27 Vehicle BID Template.pdf

Exhibit 4-Instructions to use Colorado FY27 Vehicle BID Information

Please read through the following information to ensure that your submitted responses are complete. The file has been made as accessible as possible. Alternatively, you can print the Body Type Code and Vehicle Package sheets from Excel and submit them separately. Please let us know if you require a different format.

● Bid Responses are to be entered in the Excel workbook, Exhibit 5-Colorado FY27 Vehicle BID template.xlsm.

● Refer to the Exhibit 4-Bypassing Security Warning Messages video (also included in Exhibit 4) to prepare your downloaded workbook for use (instructions can also be found later in this document).

● The Exhibit 4-Colorado BID Template Review Webinar (included in Exhibit 4) provides an in-depth review of the template’s functionality. We highly recommend that you review the webinar before you begin the bidding process (detailed instructions are also included in the workbook, identified as light gray tabs, for reference).

● Use the legend that is listed in the instructions tab to identify the required fields on each tab.

● Each Body Type tab allows the end user to add OEM specifications not already listed (scroll to the end of the list).

● Any other vehicle information that you would like to submit, including available Vehicle Colors, should be submitted at the same time as the completed workbook. Provide your documentation with the necessary information, ensuring that the applicable Body Type(s) for which the information applies are clearly identified in every document (refer to the Body Types tab in the workbook for a complete list).

● The Bidder Notes tab provides a space for the end user to include any information that may have been missed or overlooked in the template for which the dealer does not have existing documentation. This tab is optional; if you choose to include information on this tab, be sure to identify the Body Type for which the information applies.

● Before you submit your completed file, be sure that all of the required information has been added to all open tabs in the file (these will change based on your selections).

https://drive.google.com/file/d/1zdV4MC6E9e5JB1PUdZ1aNsdvNwUmAFw1/view?usp=drive_link https://drive.google.com/file/d/1YdJ2i0dzV-b09GAbUNlNguNfxsnOhQOQ/view?usp=drive_link

When you download the Exhibit 5-Colorado FY27 Vehicle BID Template.xlsm bid template file, you may receive warning/error messages that prevent you from utilizing the workbook. The first is the Protected View message, which appears in yellow as shown in image 1. This is a warning to be cautious about using a file that has been downloaded from the internet or another outside source. A simple click on the “Enable Editing” button will allow you to proceed.

Image 1

The next message is a Security Risk message, which appears in red as shown in image

2. This message notifies the end user that the macros in the file have been blocked, which requires adjustments to the file’s settings. If you would like to learn about enabling macros before proceeding, click the Learn More button within the security notification.

Image 2

When you are ready to enable macros on the form, use the following steps:

1. Open Windows File Explorer and navigate to the folder where you saved the file.

This will likely be your download folder unless you saved it elsewhere.

2. Right-click the file and choose Properties from the menu.

3. Ensure the General tab is selected. At the bottom, in the Security section, select the Unblock checkbox, select Apply, and then OK to close the box.

4. Reopen the file. You may have to bypass a yellow message again by clicking Enable.