Ratio and Trend Analysis Tool

The Excel Spreadsheet on this site can be used to calculate finance and other program related indicators for Local Public Health Agencies. The Public Health Uniform National Data System (PHUND$) is a web-based portal hosted by NACCHO that is designed to collect these data annually for Local Health Agencies. PHUND$ includes features for comparative analysis between agencies (Benchmarking) and measures of program sustainability. This spreadsheet can be used for periodic analysis of periods less than 12 months (monthly, quarterly, etc) before or after annual reporting into PHUND$.  The attached Data Dictionary provides descriptions of each account in the spreadsheet.