Need help setting up these scenarios in Excel. If you can explain to me how to separate employees in a fast manner instead of looking through all 12000 of them. There are different departments in the Excel file. So if you could just tell me how to use those keywords to select only the ones I need.

Second, explain to me the exact Excel formulas you will be needing to use. Please don't just say calculate this and that. I am needing the exact formula one would use. I also have no idea how to utilize a pension rate in the formula.

I have the excel file but it doesnt allow me to post it here. I could send it over email or we could message on Discord if needed. Thank you.

3. Costs to provide a 5% salary increase for civilian employees effective October 1st and a 5% salary increase for uniformed employees effective April 1; provide the first- and second- year costs.

4. Costs for a 5% salary increase for all employees effective October 1st split out by fund type: a. Enterprise funds b. General fund Your answers should include the following pension rates associated with merit not the full salary amount:

a. Use 28.95% for uniformed employees salary b. Use 11.93% for civilian employees salary