|
|
Responses |
Responses |
|
Insert a new sheet titled San Francisco Salaries |
|
Important data into the above sheet from San Francisco Salaries.txt |
|
Format appropriately |
|
Insert a column in H titled Total Pay & Benefits |
|
Populate this column with the total of base pay, OT, Other pay, and benefits |
|
In column M create a formula to determine the Base Pay as a percent of Total Pay & Benefits |
|
In 2011, what job title had the most employees & how many were there? |
|
How many total employees were there in 2011? |
|
How many total employees were there in 2014? |
|
In 2012, what was the Average Base pay as a percent of total pay & benefits for the Accountant II position? |
|
In 2013, which individual (name) had the highest total pay & benefits? |
|
In 2013, which job title had the highest average total pay & benefits? |
|
In 2012, which job title had the highest average of OT pay? |
|
In 2012, which job title had the highest average Other pay? |
|
In 2014, which Part Time (PT) job title had the highest total pay & benefits and how much was it? |
|
In 2014, which Full Time (FT) job title had the highest total pay & benefits and how much was it? |
|
In 2014, how many Full Time (FT) Pharmacist were employed? |
|
In 2014, how many Part Time (PT) Storekeepers were employed? |
|
In 2014, what was the average (FT) Lieutenant, Fire Suppression average base pay as a percent of total pay? |
|
All years combined, how much was paid in all forms to custodians? |
|
In 2013, who was the highest total paid Accountant IV and what was the total pay? |
|
In 2014, what was Michael R Rottmayer’s % base pay as a percent of total? |
|
In 2014, how many full time employees were there? |
|
In 2014, how many part time employees were there? |
|
All years combined, what percent of the total pay & benefits went to Firefighters? (one decimal place) |
|
All years combined, how much was paid to all positions? |
Leave a Reply
Want to join the discussion?Feel free to contribute!