You will see the option to “View report output versions”. This will take you to a page that allows you to select the respective month. Once you navigate to the month page, you should select the later dated report within the month. (Each report runs twice in the month on the 1st and 3rd Sunday)Running this report will capture all ABAWD vs. Non ABAWD participants that are attached to the program for that month. You will need to do this for each of the respective five reports for each month. Once you have the report information pulled, you should copy and paste the information onto a separate master Excel spreadsheet. In order to find your counties percentage of ABAWDs vs Non-ABAWDs for a respective month, you should duplicate all these steps for each report identified in step (1). If you are looking for the annual percentage of ABAWD vs Non-ABAWD, you will need to run each of these reports for each month and put them on a master excel document. It is recommended that you freeze the top row with your headers. Do this by navigating to the “View” tab and find the “Freeze Panes” drop down on the ribbon. Now that you have your master Excel document we need to remove all the duplicate records. Navigate to the “Data” tab. Find the “Remove Duplicates” button on the ribbon. Ensure you select the entire spreadsheet by clicking the top left cell. Unselect all then select SSN and click OK.
You will see the option to “View report output versions”. This will take you to a page that allows you to select the respective month. Once you navigate to the month page, you should select the later dated report within the month. (Each report runs twice in the month on the 1st and 3rd Sunday)Running this report will capture all ABAWD vs. Non ABAWD participants that are attached to the program for that month. You will need to do this for each of the respective five reports for each month. Once you have the report information pulled, you should copy and paste the information onto a separate master Excel spreadsheet. In order to find your counties percentage of ABAWDs vs Non-ABAWDs for a respective month, you should duplicate all these steps for each report identified in step (1). If you are looking for the annual percentage of ABAWD vs Non-ABAWD, you will need to run each of these reports for each month and put them on a master excel document. It is recommended that you freeze the top row with your headers. Do this by navigating to the “View” tab and find the “Freeze Panes” drop down on the ribbon. Now that you have your master Excel document we need to remove all the duplicate records. Navigate to the “Data” tab. Find the “Remove Duplicates” button on the ribbon. Ensure you select the entire spreadsheet by clicking the top left cell. Unselect all then select SSN and click OK.