Schedule H2 GeoAccess Retirees.xlsm

This is a GeoAccess Reporting Template from Willis Towers Watson (WTW) used to generate provider network access requests for health insurance analysis. The template is designed for the Michigan Public School Employees' Retirement System (MPSERS) to assess vision coverage provider availability across different geographic densities and regions.

The template enables clients to specify up to ten provider types for analysis, with customizable access standards (number of providers within specified mile radiuses) that vary by population density classification (urban, suburban, rural). For MPSERS vision coverage, the template includes four vision provider categories: all vision providers, optometrists, ophthalmologists, and opticians, with access standards ranging from 2 providers in 8 miles (urban) to 2 providers in 25-30 miles (rural). Users may select whether to analyze only providers accepting new patients and choose data outputs including "Access – With" and "Distance – Without" sheets. The template includes a comprehensive ZIP code reference table updated in February 2020 that classifies geographic locations across Puerto Rico, the U.S. Virgin Islands, and numerous mainland metropolitan statistical areas by urbanization status. The finalization process removes internal WTW worksheets and formulas before sending the request to vendors.

This template is proprietary WTW intellectual capital restricted to internal use and Willis Towers Watson-sponsored requests for proposal or renewals only; it should not be distributed directly to external clients, vendors, or third parties without appropriate modification for the specific engagement. The tool facilitates vendor communication by standardizing network adequacy assessment criteria and geographic parameters to ensure consistent provider accessibility analysis across the requested service areas.