ABCDE
1
2
ICS 209 RESOURCE COUNTER FROM IROC
3
4
The Resource Counter is designed to automate the Box 49 Resource Summary for the ICS 209 Report. The spreadsheet takes a QST1 - Request Status report from IROC and tabulates the data into a format that matches the 209 reporting criteria. It contains a "Status" sheet that will indicate if there are any warnings or errors. You can correct these on the Agency, Equipment, or Crew tabs. The Agency Tab is where you can categorize agencies as C&L, Out-of-State, etc, or add an agency that isn't in the list. The Equipment and Crew tabs are where you can set your counts for # of personnel per apparatus type. There is a feature that will filter out OES apparatus from the C&L.
5
6
For use questions contact SITL Jordan Abeel 760-445-6241 or jabeel@san-marcos.net
For code/formula questions contact the author: Andrew Klofas 408-384-9001 or aklofas@gmail.com
7
8
*** Begin by making a copy of this spreadsheet and saving it for the incident. ***
9
10
STEP 1: LOGIN TO IROC AND RUN REPORT "QST1 - REQUEST STATUS"
THIS IS ON THE LEFT TOOLBAR "ALL" UNDER "REPORTING LISTS"		*** IMPORTANT***
YOU MUST REMOVE THE DEFAULT "INCIDENT DISPATCH" FILTER AND
FILTER THE LIST INSTEAD BY INCIDENT NUMBER.
▼ ▼ ▼ ▼ ▼ ▼








11
STEP 2: RUN REPORT: Click on the filter icon and filter by incident name or number. Remove the default filter to make sure you capture more than only the GACC you are associated with. To reduce the file size, you could eliminate S# and A# or limit to Request Status "At Incident" though the 209 Spreadsheet will do this automatically so it is not necessary.
12
Use the gear icon and make sure the columns are set in this order : INCDIENT NAME, INCIDENT #, REQUEST #, REQUEST STATUS, REQUESTED ITEM, RESOURCE, GOVERMENT OWNED, PROVIDER ORGANIZATION.
13
STEP 4: EXPORT - At the top of any column, hover over the label and you will see three dots appear for "Column Options". Click the three dots and then select "Export" and "Excel (.xlsx)" as the file type. When the pop-up window opens, click "Download".
14
STEP 5: Open the spreadsheet in Excel or a different workbook, then copy and paste the entire IROC spreadsheet document into IMPORT page replacing any existing data.
15
STEP 6: Check the STATUS Page to validate number of processed records (number should be greater than zero).
16
STEP 7: On the STATUS page under Warnings, follow the directions to update or add missing data in the pages specified. Often this includes adding an agency.
17
The 209 COUNTS Page should now have the resource/personnel counts.
18
LAST REVISED 9/8/2024 JBA