EXHIBIT G VAP Tracking Sheet Template.xlsx
XLSX spreadsheet 36 KB Posted
- Attached to
- RFP 26-18 Visitor Assistance Program - Kaua‘i
- Solicitation number
- P26002870
- Issued by
- Kauai County, Hawaii
About this file
This is a Visitor Assistance Program (VAP) Tracking Sheet Template developed by the Hawai'i Tourism Authority (HTA) for use in managing and reporting on visitor assistance services provided on Kaua'i. The template is designed to collect and organize data on visitor assistance cases throughout the fiscal year, with monthly tracking capability and year-to-date reporting summaries.
The tracking sheet contains five comprehensive reporting tables. Table 1 captures the source of referrals for VAP cases, including airlines, car rental agencies, county police, cruise lines, hospitals, hotels, and walk-in visitors. Table 2 tracks visitors assisted by their market of origin, including geographic regions such as the U.S. West and East, Japan, Canada, Europe, Australia, Asia, and Latin America, as well as visitor type categorization (land-based or cruise). Table 3 documents incident and adversity types handled by the program, including physical and sexual assault, auto accidents, burglary, court cases, death, lost items, medical emergencies, property damage, theft, and visitor services. Table 4 specifically tracks causes of death by category, including auto accident, homicide, natural causes, ocean/water incidents, and suicide. Table 5 addresses engagement and outreach metrics on a quarterly basis, measuring partnerships established or maintained, distribution points or locations across islands, and volunteer or ambassador participant engagement. All tables include columns for monthly data entry (January through December) and year-to-date totals with percentage calculations.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| HTA RFP 26 18 Visitor Assistance Program Kauai FINAL 051426.pdf | ||
| ATTACHMENT 02 Proposal Transmittal Letter.docx | DOCX document | |
| AG-008 103D General Conditions (1.10.23).pdf | ||
| ATTACHMENT 01 Offeror Check List.docx | DOCX document | |
| EXHIBIT H VAP Quarterly Report Template.docx | DOCX document | |
| ATTACHMENT 06 Subcontractor References if applicable.docx | DOCX document | |
| EXHIBIT F VAP Monthly Report Template.docx | DOCX document | |
| ATTACHMENT 03 Corporate Resolution.docx | DOCX document | |
| EXHIBIT J Financial Reports of Actual Expenses and Income.xlsx | XLSX spreadsheet | |
| ATTACHMENT 07 Confidential Information List if applicable.docx | DOCX document | |
| ATTACHMENT 08 Conflicts of Interest Disclosures and Attestation.pdf | ||
| ATTACHMENT 05 Contractor References.docx | DOCX document | |
| EXHIBIT I VAP Final Report Template.docx | DOCX document | |
| ATTACHMENT 04 Standard Qualifications Questionnaire.docx | DOCX document |
Show all 14
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
Table 1 - Referral Source
| Source of Referral (by case) | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | YTD | YTD % |
| Airlines/Airports | 0 | |||||||||||||
| Car Rental Agency | 0 | |||||||||||||
| County Police | 0 | |||||||||||||
| Cruise Lines | 0 | |||||||||||||
| Hospitals | 0 | |||||||||||||
| Hotels | 0 | |||||||||||||
| Non-Hotel Accommodations | 0 | |||||||||||||
| Other Agencies | 0 | |||||||||||||
| Other VAP Provider | 0 | |||||||||||||
| Visitor Bureau | 0 | |||||||||||||
| Tour/Travel Agents | 0 | |||||||||||||
| Walk In/Direct | 0 | |||||||||||||
| Other (Specify Below) | LEAVE BLANK | |||||||||||||
| 0 | ||||||||||||||
| 0 | ||||||||||||||
| 0 | ||||||||||||||
| 0 | ||||||||||||||
| 0 | ||||||||||||||
| 0 | ||||||||||||||
| 0 | ||||||||||||||
| 0 | ||||||||||||||
| Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100% |
&"Corbel,Bold"VAP Tracking Reports - Tables 1 through 4 Table 1: Source of Referral <Time Period> <VAP PROVIDER> &"Arial,Bold Italic"&14EXHIBIT G
Table 2 - MMA Source
| MMA of Assisted Person/People (by pax) | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | YTD | YTD% |
| U.S. West: Pacific-AL, CA, OR, WA and Mountain-AZ, CO, ID, MT, NV, UT, WY | 0 | |||||||||||||
| U.S. East: all other U.S. continental states | 0 | |||||||||||||
| Japan | 0 | |||||||||||||
| Canada | 0 | |||||||||||||
| Europe: United Kingdom, Germany, France, Italy and Switzerland | 0 | |||||||||||||
| Australia | 0 | |||||||||||||
| New Zealand | 0 | |||||||||||||
| China | 0 | |||||||||||||
| Korea | 0 | |||||||||||||
| Other Asia: Hong Kong, Taiwan and Singapore | 0 | |||||||||||||
| Latin America: Argentina, Brazil and Mexico | 0 | |||||||||||||
| All Other Countries/Territories: (Specify Below) | LEAVE BLANK | |||||||||||||
| Hawai‘i (Neighbor Island) | 0 | |||||||||||||
| 0 | ||||||||||||||
| 0 | ||||||||||||||
| 0 | ||||||||||||||
| 0 | ||||||||||||||
| 0 | ||||||||||||||
| 0 | ||||||||||||||
| 0 | ||||||||||||||
| 0 | ||||||||||||||
| 0 | ||||||||||||||
| 0 | ||||||||||||||
| 0 | ||||||||||||||
| Total** | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100% |
| Land-based visitor | 0 | |||||||||||||
| Cruise visitor | 0 | |||||||||||||
| Total** | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100% |
| ** Totals should match |
Table 2: Visitors Assisted by MMA <Time Period> <VAP PROVIDER> &"Arial,Bold Italic"&14EXHIBIT G
Table 3 - Adversity Type
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | YTD | YTD % | |||||||||||||||
| Incident/Adversity | Cases | People | Cases | People | Cases | People | Cases | People | Cases | People | Cases | People | Cases | People | Cases | People | Cases | People | Cases | People | Cases | People | Cases | People | Cases | People | Cases | People |
| Assault - Physical | 0 | 0 | ||||||||||||||||||||||||||
| Assault - Sexual | 0 | 0 | ||||||||||||||||||||||||||
| Auto Accident | 0 | 0 | ||||||||||||||||||||||||||
| Burglary | 0 | 0 | ||||||||||||||||||||||||||
| Court Case | 0 | 0 | ||||||||||||||||||||||||||
| Death (SeeTable 4) | 0 | 0 | ||||||||||||||||||||||||||
| Lost Items | 0 | 0 | ||||||||||||||||||||||||||
| Medical Emergency | 0 | 0 | ||||||||||||||||||||||||||
| Other Accident | 0 | 0 | ||||||||||||||||||||||||||
| Property Damage | 0 | 0 | ||||||||||||||||||||||||||
| Terroristic Threatening | 0 | 0 | ||||||||||||||||||||||||||
| Theft | 0 | 0 | ||||||||||||||||||||||||||
| UEMV | 0 | 0 | ||||||||||||||||||||||||||
| Visitor Services | 0 | 0 | ||||||||||||||||||||||||||
| Other (Specify Below) | ||||||||||||||||||||||||||||
| 0 | 0 | |||||||||||||||||||||||||||
| 0 | 0 | |||||||||||||||||||||||||||
| 0 | 0 | |||||||||||||||||||||||||||
| 0 | 0 | |||||||||||||||||||||||||||
| 0 | 0 | |||||||||||||||||||||||||||
| Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100% | 100% |
| ERROR:#REF! |
&"Corbel,Bold"VAP Tracking Report - Tables 1 through 4 Table 3: Incident/Adversity Type <Time Period> <VAP PROVIDER> &"Arial,Bold Italic"&14EXHIBIT D
Table 4 - Cause of Death
| Cause of Death (by pax) | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | YTD | YTD% |
| Auto Accident | 0 | |||||||||||||
| Homicide | 0 | |||||||||||||
| Natural Causes | 0 | |||||||||||||
| Ocean/Water Incident | 0 | |||||||||||||
| Other Accident | 0 | |||||||||||||
| Sickness | 0 | |||||||||||||
| Suicide | 0 | |||||||||||||
| Other (Specify Below) | LEAVE BLANK | |||||||||||||
| 0 | ||||||||||||||
| 0 | ||||||||||||||
| 0 | ||||||||||||||
| 0 | ||||||||||||||
| 0 | ||||||||||||||
| 0 | ||||||||||||||
| 0 | ||||||||||||||
| 0 | ||||||||||||||
| Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100% |
&"Corbel,Bold"VAP Tracking Report - Tables 1 through 4 Table 4: Cause of Death <Time Period> <VAP PROVIDER> &"Arial,Bold Italic"&14EXHIBIT G
Table 5 - Engagement & Outreach
| Reporting Metric | FY27 Q1 | |||||||
| Jul 26 - Sep 26 | FY27 Q2 | |||||||
| Oct 26 - Dec 26 | FY27 Q3 | |||||||
| Jan 27 - Mar 27 | FY27 Q4 | |||||||
| Apr 27 - Jun 27 | FY28 Q1 | |||||||
| Jul 27 - Sep 27 | FY28 Q2 | |||||||
| Oct 27 - Dec 27 | Total | Target | ||||||
| Number of partnerships established or maintained that support visitor education and outreach | 0 | |||||||
| Number of distribution points or locations (e.g., hotels by island, airports, activity providers, etc.) | 0 | |||||||
| Number of volunteer or ambassador participants engaged | 0 | |||||||
| Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
*This sheet to be used for Quarterly & Final Reporting
Table 1: Source of Referral <Time Period> <VAP PROVIDER> &"Arial,Bold Italic"&14EXHIBIT G
File details come from the government source that posted it. Updated .