Schedule H1 GeoAccess Actives.xlsm

This file is a GeoAccess Reporting Template developed by Willis Towers Watson (WTW) for use in analyzing provider network access for health plan coverage types, specifically configured for the Michigan Public School Employees' Retirement System (MPSERS) vision coverage. The template is designed to generate vendor requests for provider access analysis across multiple provider types, including optometrists, ophthalmologists, opticians, and all vision providers. The tool allows clients to specify access standards (defined as a number of providers within a specified mile radius) that vary by population density classification (urban, suburban, or rural), and to indicate whether only providers accepting new patients should be included. The template includes suggested standards for multiple coverage types—including medical, dental, mental health/substance abuse (MHSA), pharmacy, and vision—with access standards ranging from 1 provider in 5 miles (urban acute care hospitals) to 2 providers in 30 miles (rural ophthalmologists). The file contains comprehensive ZIP code classification data updated February 2020, mapping U.S. locations including Puerto Rico, U.S. Virgin Islands, and multiple states to their respective metropolitan statistical areas (MSAs) with urban, suburban, or rural designations.

This template is proprietary WTW intellectual capital intended solely for loading onto the Proposal Tech platform for Willis Towers Watson-sponsored requests for proposal or contract renewals. The document includes detailed instructions for completing the request in five steps: entering basic client information, selecting provider types and access standards, choosing data output formats (with "Access - With" and "Distance - Without" recommended as standard reports), adding employee census data by ZIP code, and finalizing the submission through macro processing that removes internal WTW information and formulas before sending to vendors. The file explicitly restricts distribution to clients, vendors, or third parties outside of authorized RFP contexts and requires consultation with WTW H&B Professional Excellence Leaders or the Compliance and Operations Manager regarding proper use and modification procedures.