Copy WordPress Pages and Posts

Average City of Chicago Income Per Capita – Broken Down by Neighborhoods

This data is compiled using public dataset released by the City of Chicago
Date Created 10/30/2014

 

Average of PER CAPITA INCOME $25,597.00
COMMUNITY AREA NAME Average
Near North Side $88,669.00
Lincoln Park $71,551.00
Loop $65,526.00
Lake View $60,058.00
Near South Side $59,077.00
North Center $57,123.00
Near West Side $44,689.00
Forest Glen $44,164.00
West Town $43,198.00
Edison Park $40,959.00
Beverly $39,523.00
Hyde Park $39,056.00
Lincoln Square $37,524.00
Kenwood $35,911.00
Uptown $35,787.00
Mount Greenwood $34,381.00
Edgewater $33,385.00
Norwood Park $32,875.00
Logan Square $31,908.00
Calumet Heights $28,887.00
CHICAGO $28,202.00
Jefferson Park $27,751.00
Irving Park $27,249.00
Morgan Park $27,149.00
North Park $26,576.00
Garfield Ridge $26,353.00
Dunning $26,282.00
O’Hare $25,828.00
Clearing $25,113.00
Avalon Park $24,454.00
Portage Park $24,336.00
Rogers Park $23,939.00
Douglas $23,791.00
Ashburn $23,482.00
Grand Boulevard $23,472.00
West Ridge $23,040.00
Bridgeport $22,694.00
Hegewisch $22,677.00
Montclaire $22,014.00
Albany Park $21,323.00
Pullman $20,588.00
Avondale $20,039.00
Washington Height $19,713.00
South Shore $19,398.00
Oakland $19,252.00
Chatham $18,881.00
Woodlawn $18,672.00
Roseland $17,949.00
Greater Grand Crossing $17,285.00
East Side $17,104.00
McKinley Park $16,954.00
West Lawn $16,907.00
South Chicago $16,579.00
West Pullman $16,563.00
Lower West Side $16,444.00
Armour Square $16,148.00
Archer Heights $16,134.00
Austin $15,957.00
West Elsdon $15,754.00
Auburn Gresham $15,528.00
Belmont Cragin $15,461.00
Hermosa $15,089.00
South Deering $14,685.00
Washington Park $13,785.00
Humboldt park $13,781.00
Chicago Lawn $13,231.00
Brighton Park $13,089.00
East Garfield Park $12,961.00
New City $12,765.00
Burnside $12,515.00
Gage Park $12,171.00
North Lawndale $12,034.00
Englewood $11,888.00
West Englewood $11,317.00
West Garfield Park $10,934.00
Fuller Park $10,432.00
South Lawndale $10,402.00
Riverdale $8,201.00

Provided by http://www.houstoncomputerclasses.com/

Copy WordPress Pages and Posts

Average City of Chicago Employee Salary – What Do City Employees Really Make?

This data is compiled using public dataset released by the City of Chicago
Date Created 10/30/2014

 

Average of Employee Annual Salary  $75,559.11
by Department
DoIT $94,083.53
BUILDINGS $91,814.51
FIRE $88,247.96
MAYOR’S OFFICE $86,765.19
HUMAN RELATIONS $85,095.33
BUDGET & MGMT $84,022.27
IPRA $82,412.05
BOARD OF ETHICS $82,334.67
WATER MGMNT $82,287.46
COMMUNITY DEVELOPMENT $81,502.14
GENERAL SERVICES $80,859.86
TREASURER $80,614.71
TRANSPORTN $79,869.23
INSPECTOR GEN $79,786.04
POLICE BOARD $79,068.00
PROCUREMENT $77,989.61
HEALTH $77,601.17
CULTURAL AFFAIRS $77,374.00
POLICE $76,925.82
DISABILITIES $73,565.24
BUSINESS AFFAIRS $72,114.07
ADMIN HEARNG $71,112.90
LAW $70,746.43
HUMAN RESOURCES $70,678.85
AVIATION $70,665.27
STREETS & SAN $70,260.79
FINANCE $68,608.02
LICENSE APPL COMM $65,436.00
CITY CLERK $57,845.33
CITY COUNCIL $56,850.31
BOARD OF ELECTION $55,953.41
OEMC $53,791.29
ANIMAL CONTRL $53,674.78
PUBLIC LIBRARY $51,374.80
FAMILY & SUPPORT $38,635.30

Provided by http://www.houstoncomputerclasses.com/

Add a New WorkSheet in Excel – VBA Macro Code

This VBA code will add a new worksheet in your Excel project.

Convert CrossTab Table to Database List Table – Excel VBA Macro Code

If you work with databases and regular data tables you probably had a situation when someone gave you a regular Excel 2 dimensional spreadsheet that is not that useful if you need to use the data within a database and run some queries or just make PivotTables in Excel. The Macro code below will transform your CrossTab table to a regular database list table.

This script will create a new sheet and prompt you to enter a starting point for your converted data. Then it will render the data in 3 columns as a regular database data table.

Posted by Excel Instructor:
http://www.houstoncomputerclasses.com/excel-classes/

Delete All Hidden Columns and Rows – VBA Excel – Code

This VBA code can help you delete all hidden columns and rows from your excel sheet with a click of a button.