1 / 21

Hints on Retrieving the Top 10 Series for the AEP From HQ BOA

Learn how to retrieve the top 10 series for the AEP from HQ BOA using filtering, sorting, and pivot tables. Customize your selection based on PATCOB, grade, and other EEO fields. Pay attention to the results and calculate percentages accordingly.

gfoley
Download Presentation

Hints on Retrieving the Top 10 Series for the AEP From HQ BOA

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Hints on Retrieving the Top 10 Series for the AEP From HQ BOA

  2. This is the raw data from BOA exported to excel (see the export power points)

  3. You can filter the raw data by PATCOB by using the auto filter

  4. The drop downs allow you to select any field you want

  5. You can select any one value

  6. By selecting custom you can select more than one value

  7. You can select administrative and professional but pay attention to the and/or conditions

  8. unsorted The data is not sorted but it is filtered as you can see by the change of color in the rows

  9. This is the sort dialog [under Data] box and you can use this to sort the filtered data. Look carefully at the ascending v descending options

  10. sorted

  11. Using the raw data you can also use a pivot table to filter the data even more

  12. You can simplify the selection process by starting with a pivot table (also called a cross tab) then follow the wizard steps to the layout button

  13. Make sure you have the dotted lines going around your data set. If they are not, restart your steps

  14. By adding the PATCOB and Grade fields you can filter your choices even more. Just drag them to the page box

  15. You can filter the results even further by clicking the series field in the layout and getting the advanced button

  16. You can use these settings to determine the results that you’ll get. Read the options carefully and use the ones that suit you best

  17. You’ll get the top 10 based on the sum But you’ll also see that because the grade field was included in the page of the layout that you can select the grades you want and this result allows you to select the top 10 series for grade 15..14.. 13 .. Etc.

  18. You can see here that professional grade 13 was selected. But remember that this entire selection is based on the top ten series that was set in the pivot table.

  19. Once you have selected the series and grades you need you can add the other EEO fields.

  20. You can also use the more advanced calculation features

  21. But when you use these advanced features pay attention to the results.. Just don’t click click click simply because the button is there Because of the multiple Asian RNO values, you will have to calculate the percentages in a more traditional way so that the multiple Asian values are reduced to Asian men and Asian women

More Related