The attached spreadsheet has three different TABS:
<ul>
[*]SALARY - contains the information that was found at the BOE web site. Columns were the information was the same or sections that contained no data were deleted.
[*]DATA - has 2 PIVOT tables. The first one in broken down by the different employee TITLES. Listed next to each TITLE is:
<ul>
[*]# of Employees
[*]TOTAL salary of all employees under that TITLE.
[*]MAXIMUM SALARY
[*]MINIMUM SALARY
[*]AVERGE SALARY
[*]The GRAND TOTAL indicates the aforementioned values for all TITLES.[/list][/list]The second table lists employees by LAST NAME and indicates how many employees have the same LAST NAME. Since there is no indicator to familial relationship this is NOT meant to indicate how many family members are employed. By clicking a row in the right-most column of either table the various employees who comprise that data will appear in a new TAB.
<ul>
[*]DAYS - simply a breakdown of the year to determine how workdays the average worker puts in, sans vacation days.[/list]Be advised that the data was culled from the BOE web site. It consists of only those employees whose base salary is greater than $75K. If the remaining individuals can be obtained I will incorporate them into an updated report.
BOE Salaries
