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

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)JanFebMarAprMayJunJulAugSepOctNovDecYTDYTD %
Airlines/Airports0
Car Rental Agency0
County Police0
Cruise Lines0
Hospitals0
Hotels0
Non-Hotel Accommodations0
Other Agencies0
Other VAP Provider0
Visitor Bureau0
Tour/Travel Agents0
Walk In/Direct0
Other (Specify Below)LEAVE BLANK
0
0
0
0
0
0
0
0
Total0000000000000100%

&"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)JanFebMarAprMayJunJulAugSepOctNovDecYTDYTD%
U.S. West: Pacific-AL, CA, OR, WA and Mountain-AZ, CO, ID, MT, NV, UT, WY0
U.S. East: all other U.S. continental states0
Japan0
Canada0
Europe: United Kingdom, Germany, France, Italy and Switzerland0
Australia0
New Zealand0
China0
Korea0
Other Asia: Hong Kong, Taiwan and Singapore0
Latin America: Argentina, Brazil and Mexico0
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**0000000000000100%
Land-based visitor0
Cruise visitor0
Total**0000000000000100%
** Totals should match

Table 2: Visitors Assisted by MMA <Time Period> <VAP PROVIDER> &"Arial,Bold Italic"&14EXHIBIT G

Table 3 - Adversity Type

JanFebMarAprMayJunJulAugSepOctNovDecYTDYTD %
Incident/AdversityCasesPeopleCasesPeopleCasesPeopleCasesPeopleCasesPeopleCasesPeopleCasesPeopleCasesPeopleCasesPeopleCasesPeopleCasesPeopleCasesPeopleCasesPeopleCasesPeople
Assault - Physical00
Assault - Sexual00
Auto Accident00
Burglary00
Court Case00
Death (SeeTable 4)00
Lost Items00
Medical Emergency00
Other Accident00
Property Damage00
Terroristic Threatening00
Theft00
UEMV00
Visitor Services00
Other (Specify Below)
00
00
00
00
00
Total00000000000000000000000000100%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)JanFebMarAprMayJunJulAugSepOctNovDecYTDYTD%
Auto Accident0
Homicide0
Natural Causes0
Ocean/Water Incident0
Other Accident0
Sickness0
Suicide0
Other (Specify Below)LEAVE BLANK
0
0
0
0
0
0
0
0
Total0000000000000100%

&"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 MetricFY27 Q1
Jul 26 - Sep 26FY27 Q2
Oct 26 - Dec 26FY27 Q3
Jan 27 - Mar 27FY27 Q4
Apr 27 - Jun 27FY28 Q1
Jul 27 - Sep 27FY28 Q2
Oct 27 - Dec 27TotalTarget
Number of partnerships established or maintained that support visitor education and outreach0
Number of distribution points or locations (e.g., hotels by island, airports, activity providers, etc.)0
Number of volunteer or ambassador participants engaged0
Total0000000

*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 .