Attachment D - 36C10B24Q0251 - EMSS Reports.xlsx
XLSX spreadsheet 21 KB Posted
- Solicitation number
- 36C10B24Q0251
About this file
This document is an Excel file containing Executive Actions Statistics related to the National Veterans Small Business Engagement (NVSBE) event in 2017. It provides detailed metrics on participant registration, event host registration, exhibitor registration, and VA attendee participation broken down by socioeconomic categories such as SDVOSB, VOSB, SDB, WOSB, and HUBZone. The file also includes reporting requirements for changes to the registration process, such as modifying questions about VA business and SAM registration. Additionally, it outlines the need for a new "FOT Business Report" and requests the creation of an Executive Actions statistics dashboard with hyperlinked data. The document references a related federal contract opportunity, Solicitation Number 36C10B24Q0251, for the "DA10--Follow-on - OSDBU Event Management System Software as a Service (VA-24-00045626)".
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 36C10B24Q0251 0002.docx | DOCX document | |
| 36C10B24Q0251 Q_A.docx | DOCX document | |
| 36C10B24Q0251-amd 1.docx | DOCX document | |
| Attachment G - Service Model Questions.docx | DOCX document | |
| 36C10B24Q0251 0001_1.docx | DOCX document | |
| Attachment A - Required Capabilities Summary.docx | DOCX document | |
| Synopsis - EMSS 36C10B24Q0251.docx | DOCX document | |
| Attachment C - 36C10B24Q0251 - Business Rules.xlsx | XLSX spreadsheet | |
| 36C10B24Q0251_2.docx | DOCX document | |
| 36C10B24Q0251-FINAL.docx | DOCX document | |
| Attachment E - 36C10B24Q0251 -EMSS Role and Permissions.docx | DOCX document | |
| Attachment B - 36C10B24Q0251 - User Profiles.xlsx | XLSX spreadsheet |
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
Executive Actions Statistics
| Statistic categories | Sub-categories | Columns(if multiple) | |
| Pre-NVSBE | NVSBE Participant Report - total number of small businesses that registered and submitted payment for NVSBE 2017 | ||
| NVSBE Activity Host Report - total number of PDMS that registered and submitted payment for NVSBE 2017 | |||
| Small Business Registration - number of NVSBE 2017 registered attendees | Small business (socio economic category), other small business, large business, federal government, non-profits, other staff/VIP/volunteers) | ||
| Exhibitors/Sponsors - number of NVSBE 2017 registered exhibitors and sponsors | |||
| VA Attendees by Function - number of VA attendees | Total small business, SDVOSB, VOSB, SDB, WOSB, HUBZone, 8(A) Total large business, Total Federal, VA staff, Other fed, Non-profit, Other (Staff/VIP/Volunteers/Press), Total | ||
| During | Attendees | Participants: Total small business, SDVOSB, VOSB, Overlap of SDVOSB and VOSB, WOSB, HUBZone, 8(A), Other Small Businesses, Total large business, Non-profit, Academia, Total |
| Hosts: VA Staff, OGA, Commercial, Academia, Non-profit, Total | Registered, Checked in | |||
| Activities - sessions by type | [List of all session types] | Scheduled, Completed | ||
| Small Business Expo - number of booths | Tabletop, standard, silver sponsors, gold, platinum, diamond, total; Government, Small Business, Large Business, Non-profit |
Statistics mockup
| Pre-NVSBE | During | |||||||||||
| NVSBE Participant Report | ||||||||||||
| Total number of small businesses that registered and submitted payment for NVSBE 2017 | 657 | Registered | Checked in | |||||||||
| NVSBE Activity Host Report | ||||||||||||
| Total number of PDMS that registered and submitted payment for NVSBE 2017 | 340 | VA Attendees by Function | ||||||||||
| Number of VA attendees | 650 | 569 | ||||||||||
| Small Business Registration | ||||||||||||
| Number of NVSBE 2017 registered attendees | 210 | Total small business | 214 | 197 | ||||||||
| Small business socio1 | 43 | SDVOSB | 32 | 30 | ||||||||
| Small business socio2 | 54 | VOSB | 54 | 28 | ||||||||
| Other small business | 28 | SDB | 48 | 47 | ||||||||
| Large business | 51 | WOSB | 58 | 50 | ||||||||
| Federal government | 40 | HUBZone | 72 | 48 | ||||||||
| Exhibitors/Sponsors | ||||||||||||
| Number of NVSBE 2017 registered exhibitors and sponsors | 250 | # of registrations | % of total VA registrations | # of Speakers/PDMs | % of total Speakers/PDMs | |||||||
| VA Attendees by Function | ||||||||||||
| Number of VA attendees | 210 | Small Business VA registration | ||||||||||
| VA Agency (# of registrations, % of total VA registrations, # of Speaker/PDM, % of total Speaks/PDMs) | 342 | 100 | 2 | 100 | ||||||||
| Total small business | 39 | Acquisition, Logistics, and Construction | 40 | 12 | 1 | 50 | ||||||
| SDVOSB | 84 | Advisory Committee Management Office | 54 | 14 | ||||||||
| VOSB | 58 | Congressional and Legislative Affairs | 12 | 2.5 | 1 | 50 | ||||||
| SDB | 27 | General Counsel | 16 | 3.3 | ||||||||
| WOSB | 57 | |||||||||||
| HUBZone | 72 |
Reporting Requirements
| Requirement ID | High Level Requirement | Solution/Report/Dropdown/Checkboxes/Search? | Priority/High/Medium/Low | Questions/Comments | |
| Registration - Change the question “Do you currently do business with the Department of Veterans Affairs (VA)?” to “Do you currently have a contract with the Department of Veterans Affairs (VA)?” (Y/N) | This is only applicable to VOSBs/SDVOSBs/Exhibitors/Sponsors. Commercial should be 'Do you currently subcontract to Veteran Owned Small Businesses' and 'Do you have opportunities for VOSBs?' - GI 6/9 | ||||
| Registration - Change the question “Have you ever done business with the Department of Veterans Affairs (VA) within the last 5 years?” to “Have you previously had a contract with the Department of Veterans Affairs (VA) within the last 5 years?” (Y/N) | This is only applicable to VOSBs/SDVOSBs/Exhibitors/Sponsors - GI 6/9 | ||||
| Registration - Add a new field – “Are you registered in the Systems for Awards Management (SAM)?” (Y/N) | |||||
| Build a new ad-hoc report located in Admin dashboard - Reports, labeled 'FOT Business Report' with fields [name of company, address, zip code, email, phone number, DUNS, primary NAICS, specific socio economic category, have current contract with VA?, registered in SAM?] | This is already in there the questions being added will be applied to reports automatically. Admin users will automatically see these options as a checkbox either under the participant or host tab that the small business is registedered to participate in. | Ray's Feedback: I think what they're looking for is a standard report with the specific fields that they've identified. They just want to click on the report and have the data refresh and be able to view and download. | |||
| Create an Executive Actions statistics page on the dashboard (see Executive Actions Statistics sheet) with values that are hyperlinked to the list of attendees that make up each particular statistic | We have not been confirmed to take sponsor registration as that was not something in the propoosal that would take time to develop or develop an API with whatever contractor ASBA decides to use for Sponsorship. When the word submitted payment is on there it is giving the assumption that we do not want the total number since there are going to be individuals with payment codes to bypass entering in payment so technically they would not be paid but still registered. Are they wanting to remove the ones that registered with coupon codes from that list? I will need to see how the expected view of these statisitcs will be in order to estimate properly the level of effort and set a timeline with the team. What is the expected view of these statistcs and how do they want them represented? | Ray's Feedback: Keep in mind that this dashboard doesn't have to be ready until we're actually onsite. This is for the report that Beth provides to the SecVA leadership and the JOC on a daily basis. Ideally, we would like to have the data converted to the bars and graphs that can be easily downloaded or cut & paste into a PowerPoint presentation. If that's not feasible, then what we would like to do is put all of the information in a single view so that all Beth has to do is grab the data and insert it into the .ppt. |
WRT, the Sponsorship data. Unless the sponsor are going to use our system to register then that info will have to come direclty from ASBA.
File details come from the government source that posted it. Updated .