C04c_Attachment 3 SWLIPS_12760426Q0212.xlsx
XLSX spreadsheet 37 KB Posted
- Attached to
- Dell Hardware and Firmware Maintenance
- Solicitation number
- 12760426Q0212
- Issued by
-
Department of Agriculture Forest Service
About this file
This file is a Software Data Template form designed by the USDA to collect and track Microsoft software procurement information. The template requires contractors and USDA agency points of contact to document comprehensive details for each software purchase, including vendor information, product specifications, licensing terms, and pricing. Required fields include the USDA POC name and contact information, contract/BPA number, purchase and delivery dates, vendor/reseller details, part numbers, software manufacturer and product name, version numbers, serial/license numbers, and GUID/UUID identifiers. The form specifically addresses Microsoft product licensing by requiring specification of whether licenses are perpetual (one-time purchase), subscription (annual recurring payment), or maintenance-based, along with corresponding start and end dates.
The template mandates collection of upgrade rights, downgrade rights, and cross-edition rights information for Microsoft products, along with quantity ordered, metric units, unit price, and total price calculations. Submissions must be verified for completeness and accuracy by agency CORs before forwarding to SM.OCIO.CIO.Category.Management@usda.gov. The form includes comprehensive field descriptions and examples for each data element to ensure consistent reporting. Questions regarding completion should be directed to Reginia Hinrickson at Reginia.Hinrickson@usda.gov or 202-720-8705, or submitted to ITCategoryManagement@ocio.usda.gov. The form supports multiple licensing metrics including CAL (Client Access License), concurrent devices, concurrent users, installations, processor cores, and users, with an "other" option available for non-standard metrics.
View the file
Other files
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
Software Data Template
| Yes | Perpetual | Yes | Yes | Yes | Yes | ||
| No | Subscription | No | No | No | No | ||
| Subscription | |||||||
| If you have questions regarding the completion of this worksheet please contact Reginia Hinrickson at Reginia.Hinrickson@usda.gov or at 202 720-8705. Questions may also be sent to ITCategoryManagement@ocio.usda.gov. Agency CORs - once you have verified that the information is complete and accurate, please forward the spreadsheet to SM.OCIO.CIO.Category.Management@usda.gov. | |||||||
| This is specific to Microsoft products only. | |||||||
| USDA POC Name | USDA POC Phone |
Enter digits only
| EX: 2027209018 | USDA POC Email | Contract/BPA Number | Purchase Date |
| MM/DD/YY | Delivery Date | ||
| MM/DD/YY | Vendor / Reseller Name | Vendor / Reseller | |
| POC Name | Vendor / Reseller | ||
| POC Email | Vendor / Reseller POC Phone |
Enter digits only
| EX: 2027209018 | Part Number / | |||||
| Stock-Keeping Unit (SKU) | Software Manufacturer | Product Name (Software Title) | Version Numbers | Serial Numbers/License Numbers to be provided Y/N | GUID/UUID | Is the License Perpetual, Subscription or Maintenance? |
| Enter (P, S or M) or use dropdown menu | Subscription / Maintenance start date: |
MM/DD/YY
| Subscription / Maintenance end date: | ||||||||||||
| MM/DD/YY | Upgrade Rights Y/N | Is Upgrade Y/N | Downgrade Rights Y/N | Cross Edition Rights Y/N | Quantity Ordered | Metric | Unit Price | Total Price | Comments | |||
| Richard Sheresh | (40-6493-9688) | richard.sheresh@usda.gov | 10/2/26 | 10/1/27 | 2 |
mailto:richard.sheresh@usda.gov Field Descriptions
| Field Name | ||||
| Data Type | Required | Description | Example | |
| USDA POC Name | Text | Yes | Primary Point of Contact (POC) Full Name who performed procurement (to include first and last name) | Jon Snow |
| USDA POC Phone | Numerical | Yes | Primary Verified phone number of POC who performed procurement (include area code) | |
| USDA POC Email | Text | Yes | Primary Verified email of POC who performed procurement | jon.jones@XXXX.usda.gov |
| Contract/BPA Number | Text | Yes | Official Government or USDA contract/BPA number (use entire identification, including letters, numbers and dashes) | AG-3144-B-15-0011 (Microsoft Dynamics), Dell Federal Systems, L.P. |
| Purchase Date | Date | Yes | Date of actual purchase | 3/15/18 |
| Delivery Date | Date | Yes | Date order was shipped by vendor to customer | 6/6/18 |
| Vendor / Reseller Name | Text | Yes | Name of vendor or reseller that this software item was procured from | Alliant SB, Adobe |
| Vendor / Reseller POC Name | Text | Yes | Full Name of vendor POC (to include first and last name) | Carl Grimes |
| Vendor / Reseller POC Email | Text | Yes | Verified vendor email address | carl.grimes@XXXX.usda.gov |
| Vendor / Reseller POC Phone | Text | Yes | Verified vendor phone (office or mobile). Utilize area code for U.S. and for international include 011 (U.S. exit code) then country code then remaining extensions | 202-123-4567 or Germany example 011-49-area code-phone number |
| Part Number/Stock-Keeping Unit (SKU) | Text | Yes | A SKU is a number or string of alpha and numeric characters that uniquely identify a product. | KS944BR72 |
| Software Manufacturer | Text | Yes | The company that manufactures the software | Microsoft, Adobe, Oracle |
| Product Name (Software Title) | Text | Yes | Specific product name to include any ancillary identifiers (any separate costs per product (i.e., license, key, maintenance) should be listed as a separate line item) | Adobe Professional, Adobe Reader, Microsoft Office 2013, Pulse Secure |
| Version Numbers | Numerical | Yes | Unique number or set of numbers assigned to a specific version and release identification of a software program | 2, 4.2, 7 |
| Serial Numbers/License Numbers Y/N | Text | Yes | Indicates that Serial Numbers/License Numbers are/are not provided with the order | |
| GUID/UUID | Numerical | Yes | Globally Unique Identifier and/or Universally Unique Identifier is a 128-bit integer number used to identify resources. | |
| Perpetual, Subscription or Maintenance | Text | Yes | Indicate if perpetual (own and pay for maintenance) , subscription (leased software without maintenance costs) or maintenance (maintenance on a perpetual license). Perpetual is a license the USDA would own and would be a one-time purchase. There are some perpetual licenses that have an annual maintenance fee. Perpetual license versions are usually the version at purchase. If an upgrade was needed it would require an additional purchase, or upgrades could be covered by maintenance. Subscription licenses require the subscription to be paid every year in order to use the software. If the subscription is not paid the software would cease to function. Perpetual license would continue to work for as long as the software is installed. | Perpetual "P", Subscription "S" or Maintenance "M" |
| Subscription / Maintenance Start Date | Enter the date the subscription begins | |||
| Subscription / Maintenance End Date | Enter the Date the Subscription ends | |||
| Upgrade Rights Yes/No | Text | Yes | Indicates that Upgrade Rights are/are not provided with the order. This is specific to Microsoft products only. | |
| Is Upgrade Yes/No | Text | Yes | Indicates that this order is or is not an Upgrade. This is specific to Microsoft products only. | |
| Down Grade Rights Yes/No | Text | Yes | Indicates that this order contains Down Grade Rights. This is specific to Microsoft products only. | |
| Cross Edition Rights Yes/No | Text | Yes | Indicates that this order contains Cross Edition Rights. This is specific to Microsoft products only. | |
| Quantity Ordered | Numerical | Yes | Total number of software items procured | 50, 568, 5,000 |
| Metric | Text | Yes | Unit of measure to determine how the product is sold. If your metric isn’t listed then you can use “other” and you may make a comment. For example: metric used is by user. | |
| Unit Price | Numerical in US Dollars | Yes | Value paid for single software unit or item | $1.50 |
| Total Price | Numerical in US Dollars | Yes | Quantity ordered * Unit Price | 5,000*$1.50 = $4998.50 (formula identified in cell - do not alter) |
| *If Applicable | ||||
| Comments | Text | No | Provide any additional notes or comments. Supported custom field data types are: |
▪ Text
▪ Date
▪ Yes|No
▪ Digit
▪ Currency
▪ Decimal
| SOFTWARE | Root | |
| MAINTENANCE | Yes | |
| SUPPORT | No | |
| PURCHASE | ||
| ORACLE | ||
| OTHER |
mailto:jon.jones@XXXX.usda.gov Drop Downs
| Perpetual / Subscription | CAL (Client Access license) | Yes |
| Perpetual | Concurrent Devices | No |
| Subscription | Concurrent Users | |
| Maintenance | Custom Compare Value | |
| Devices | ||
| Installations | ||
| Number of processor Cores | ||
| Number of processors | ||
| PVU | ||
| Users | ||
| Other |
File details come from the government source that posted it. Updated .