Indicators 1

Community Indicators

The following issues provide you with links to the discussion of the indicator as well as Excel Worksheets that allow you to do community comparisons and create customized bar charts. If you are using Windows 98 or earlier versions of Microsoft Excel, the Pivot Chart functions will not work (this is what allows you to select communities from a drop-down menu):

Mobility: A Culture On the Move - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here.
- PowerPoint presentation demonstrating how to download and manipulate this data from the Census Factfinder Web site
- Excel Worksheet*: Median Number of Years householder lived in current dwelling (You pick the Wisconsin communities you are interested in viewing)*.
  - Prior version (before 4/1/2004)
  - New! version
- Excel Worksheet*: Year householder moved into current dwelling (You pick the Wisconsin communities you are interested in viewing).
  - Prior version (before 4/1/2004)
  - New! version
- Excel Worksheet*: Where Did People Move From? (Data on WI communities which shows where people moved from between 1995-2000)
  - Prior version (before 4/1/2004)
  - New! versio
Age COHORTS: New Insights on Population Data - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here.
- Excel Worksheet*: Age COHORTS (You pick the Wisconsin communities you are interested in viewing).
  - Prior version (before 4/1/2004)
  - New! version
- PowerPoint presentation demonstrating how to use the Excel Spreadsheet to obtain data and charts for any Wisconsin county or community.
Understanding Worker Flow Data - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here.
- An Excel Worksheet that calculates "self sufficiency" and the exporting/importing of jobs for all Wisconsin counties*
- New! Exel worksheet* with worker flow data by place of residence for Wisconsin cities, towns and villages. (Note: This is a large file, around 13MB)
- New! Exel worksheet* with worker flow data by place of work for Wisconsin cities, towns and villages. (Note: This is a large file, around 10 MB)
- County to county worker flow files for Wisconsin (Wisconsin Department of Workforce Development web site)
- U.S. Census worker flow files for all U.S. Counties (U.S. Census web site)
- The Regional Village: A report of a study of values and behaviors of residents of small Wisconsin villages, Robert N. Dick, University of Wisconsin Extension , August 1992 (This is a large 4 meg pdf file, as it is a scanned image of the report)
- Labor Market Resources (Authored by Gary Green, Department of Rural Sociology, U.W. Madison/U.W. Extension)
Location Quotients - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here.
- Excel Worksheet*: Location Quotients Pick any Wisconsin county or community. Then, pick up to ten other Wisconsin counties or communities as Comparison Communities.
- Power Point presentation: demonstrating how to use the Excel worksheet
- Community Economic Analysis: A How To Manual, Hustedde, Shaffer, and Pulver, Revised Edition, December 1993, NCRCRD. This manual is available in pdf file format on the EPA web site, or it may be ordered from the NCRCRD for $12.
- Location Quotient Calculator, U.S. Department of Labor
- Shift-Share Analysis Calculator, University of Georgia
Philanthropy: Does Charity Begin at Home? - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here.
- Excel Worksheet*: Philanthropy in Wisconsin
- The Catalogue for Philanthropy publishes an annual "Generosity Index" for all 50 states based on IRS tax return data. There is always a two year lag in the data, so the 2005 report is based on 2003 data. Unlike the Chronicle of Philanthropy study, this index makes no attempt to determine giving as a percentage of discretionary income. It would however, give you a sense as to whether chartitable giving was going up or down at the state and national level.
- New! "Center on Wealth and Philanthropy Charitable Giving Indices: Social Indicators of Philanthropy by State, Boston College, November 3, 2006
- New! Data on 501(c)(3) and Non-501(c)(3) organizations for all Wisconsin Counties (2005)
- New! Data on Revenues for 501(c)(3) organizations for all Wisconsin Counties (2004)
Get an Education and Double Your Salary (Part 1 of a 2-part series) - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here.
Get an Education and Double Your Salary (Part 2 of a 2-part series) - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here.
- Excel Worksheet*: Data on educational attainment levels for all Wisconsin Counties and Municipalities
- Job Training Publications (Authored by Gary Green, Department of Rural Sociology, U.W. Madison/U.W. Extension):
Increased Fuel Expenditures Flowing Out-of-State - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here.
- Excel Worksheet*: Estimated added fuel expenditures for all Wisconsin Counties, Cities, and Villages
- New! For an updated version of this issue (9-2-05, Click Here!)
- See Also, "The Impact of Rising Gas Costs on Wisconsin's Commuters"...The first issue of "Mapping Wisconsin's Economy"
- Sample News Release for this Community Indicator Issue - To be customized for your community (Microsoft Word file)
Self-Sufficiency: Defining Poverty - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here
- Excel Worksheet* includes the self-sufficiency estimates for all Wisconsin Counties and
  Tribes (2000 & 2004)
Keeping Them Down on the Farm - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here
- Excel Worksheet* includes national, state, and Wisconsin County data on the number of days that the principal farm operator worked off of farm (You have the option of selecting the county you are interested in from the drop-down menu and creating a pie chart to illustrate the data).
- Excel Worksheet * This worksheet includes national, state and Wisconsin County data on nontraditional ag sales for the years 1997 & 2002
- Map of the U.S. Data (Off Farm Employment Days) on the National Ag Statististics Service Web Site For access to dozens of Agricultural Atlas Maps, click here.
- Link to: Health Status, Use of Medical Services and Health Insurance Coverage: A Comparison Between Farmers, Other Self-Employed, and Wage/Salary Workers in Wisconsin
- For a copy of a County or State Profile on Agriculture, click here.
Increased Fuel Expenditures Flowing Out-of-State...Revisited (Updated to reflect increased fuel prices as of 9-2-05) - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here.
- Excel Worksheet*: Estimated added fuel expenditures for all Wisconsin Counties, Cities, and Villages (Updated to reflect increased fuel prices as of 9-2-05!)
It's Tax Time: Do you know where Your Federal Tax Dollars are Going? -If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here.
- Excel Worksheet*: Federal expenditures and obligations data for Wisconsin Counties (2000-2004).
High Speed Internet Access - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here.
Increasing Public Investments in Economic Development - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here.
- Excel Worksheet* with data and charts on County expenditures for economic development activities
Lending Data Offers Insight Into Housing issues - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here
- A brief Powerpoint presentation illustrating how to access the data highlighted in this issue of the "Community Indicator Series"
County Foreclosure Data - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here
County Civil Court Data Is the Key to Understanding Foreclosure Issues - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here
- Excel Worksheet with Wisconsin County Foreclosure data from the Wisconsin’s Consolidated Court Automation Programs (CCAP) system. Includes data for 71 of Wisconsin's 72 Counties for the years 2000-2007.
- NEW: Data for 71 counties from Jan. 1 - April 30, 2008 is now available. This worksheet includes pivot charts which compares Jan-April, 2007 to the same period in 2008. The data includes the total number of civil mortgage foreclosure cases (all) as well as adjusted numbers which subtract multiple cases for the same property.

*Note: Excel worksheets are best viewed by saving the file to disk and then viewing the file within Excel rather then opening the file from its current location. If your browser is not configured in a way that prompts you for the option you would prefer, you can right click on an Excel hypertext link, and select "save target as", and then determine where you would like to place the file on your system (file name and directory).

	© 2001-2006 Board of Regents of the University of Wisconsin System, doing business as the Division of Cooperative Extension of University of Wisconsin-Extension. For more information, questions and comments, please contact the web manager at: cced@uwex.edu
If you have trouble accessing this page, require this information in an alternative format or wish to request a reasonable accommodation because of a disability contact: cced@uwex.edu. University of Wisconsin-Extension - Cooperative Extension, University of Wisconsin-Extension