Spreadsheet: 827737d1683011126-confused-using-countif-s-across-multiple-worksheets-with-drop-down-menus-copy-of-fy-23-icass-count-2023-2024-gerson-changes-aligw
Sheet: FY23 Workload

ICASS WORKLOAD COUNTS |  |  |  |  |  |  |  | Sheets
 |  |  |  |  |  |  |  | May-23
FISCAL YEAR:   2023 |  |  |  |  |  |  |  | June-23
 |  |  |  |  |  |  |  | July-23
POST CODE:     240 GERMANY |  |  |  |  |  |  |  | August-23
 |  |  |  |  |  |  |  | September-23
 |  |  | Prepared by (please provide section, name and date) |  |  |  |  | October-23
 |  |  |  |  |  |  |  | November-23
[NAME] (see below & tab 2 & 3 for further guidance*): |  |  | (Please enter location here) |  |  |  |  | December-23
 |  |  |  |  |  |  |  | January-24
COST CENTER: |  |  | (Please enter cost center here) |  |  |  |  | February-24
 |  |  |  |  |  |  |  | March-24
AGENCY CODE | AGENCY NAME | WORKLOAD | AGENCY CODE | AGENCY NAME | WORKLOAD |  |  | April-24
1150 | DSCA - Defense Security Cooperation Agency |  | 2117 | ARMY - FUTURES COMMAND (AFC)
1156 | DSCA - Defense Wide Program |  | 2121.1 | ARMY - EUCOM, US European Cmd
1205 | AG - APHIS (Animal, Plant, Health and Insp Svcs) |  | 2122.5 | ARMY - HQ AFRICOM
1235 | AG - FAS (Foreign Agricultural Service) |  | 2144.9 | ARMY - DASA - Deputy [NAME]. And Coop
1302 | DOC - BIS (Bureau of Industry and Security) |  | 2150 | ARMY - G2 INTEL LIAISON PROGRAM
1330 | DOC - ITA - Global Markets |  | 2800 | SSA - Social Security Administration
1510 | DOJ - DEA (Drug Enforcement Administration) |  | 3100 | NRC - Nuclear Regulatory Commission
1525 | DOJ - FBI - LEGATT, [NAME] |  | 3600 | VA -DEPARTMENT OF VETERANS AFFAIRS
1712 | US MARINE CORPS |  | 4700 | GSA - General Services Administration
1754.1 | NAVY- Olmsted Scholars |  | 5705 | AIR FORCE - Headquarters
1900 | STATE - DP (DIPLOMATIC PROGRAMS) |  | 5713 | AIR FORCE - Seat of Govt Detachments
1901 | STATE - ICASS |  | 5718 | AIR FORCE - USAF Students
1904.1 | STATE -  EUR - OSCE |  | 5725 | AIR FORCE - PATRICK AFB
1904.2 | STATE - IO - UNVIE |  | 5741 | AIR FORCE - Professional Exchange Program
1904.8 | STATE - EUR - RSC/Frankfurt |  | 7004 | DHS - USSS, US Secret Service
1905.1 | STATE - NEA - POST TO POST SUPPORT TO IRAQ |  | 7005.1 | DHS - TSA (Transportation Security Administration)
1920 | STATE - OBO - CONSTRUCTION PROJECTS |  | 7020 | DHS - ICE - HSI - Intl Affairs Office
1920.2 | STATE - OBO - REGIONAL SUPPORT CENTER |  | 7023 | DHS - CBP - International Affairs Office
1927.1 | STATE - MED (REG MED MGT OFFICE) |  | 7024 | DHS - (IAP) and (NTC)
1929.1 | STATE - OIG - MERO - MEIB |  | 7025 | DHS - CBP - Container Security Initiative
1931 | STATE - DS - MSG SUPPORT |  | 7203.1 | USAID - Operating Expenses, Missions
1932.9 | STATE - DS -  H - L VISA FRAUD |  | 7203.2 | USAID - Operating Expenses, Regional Orgs
1939 | STATE - AVC - ARMS CONTROL VERIFICATION AND COMP |  | 7210 | USAID - Inspector General [NAME]
1939.1 | STATE - ISN/ECC/EXBS |  | 8900 | DOE - Department of Energy
1939.2 | STATE - PM, POLITICAL MILITARY AFFAIRS |  | 9568.2 | USAGM - Monitoring Offices
1939.5 | STATE - AVC - VIENNA CTBT UNVIE |  | 9568.3 | USAGM - Transmitting Stations
1942 | STATE - DS (DIPLOMATIC SECURITY) |  | 9700.3 | DOD - U S Special Ops Command - USASOC G3X-SR
1947.2 | STATE - CSO (Conflict and Stabilization Ops) |  | 9705 | DOD - DIA, Defense Intelligence Agency
1954 | STATE - CA (CONSULAR AFFAIRS) |  | 9705.1 | DOD - DIA LIAISON
1967 | STATE - PD (PUBLIC DIPLOMACY) |  | 9705.2 | DOD - DIA - FSB (Forward Support Base)
1981 | STATE - A - EX - FRANKFURT REG PROCUREMENT OFF |  | 9715 | DOD - NGA - National Geospatial Agency
1984 | STATE - A - GPS - PRINTING OPERATIONS |  | 9733 | DOD - DTRA (Defense Threat Reduction Agency)
2025 | TREASURY - IRS (Internal Revenue Service) |  | 9782 | DOD - TSG
2105.2 | ARMY - HQDA - DCSOPS (Strategic Leadership Div) |  | 9993.2 | EUR - MCLASS
2111.1 | ARMY - CINCUSAREUR/USFLO/ENTEC |  | 9993.3 | EUR - Service Provider Embassy Support
2112.1 | ARMY - TRADOC, Training and Doctrine Cmd
SUBTOTAL |  | 0 | SUBTOTAL |  | 0
 |  |  |  | GRAND TOTAL COUNT | 0
* GUIDANCE ON ICASS agency codes (please also refer to tab 2 "Staffing List - ALL LOCATIONS"):
Pls. find under tab 2 who/which section is counted under which ICASS agency code and in which location.
* GUIDANCE ON LOCATIONS (please also refer to tab 3 "FY22 - Where to Count"):
For the following cost centers, please provide your workload count for all locations separately -- i.e. Berlin, Düsseldorf, Frankfurt, Hamburg, Munich and Leipzig:
Building Operations cost centers:  7810, 7820, 7850 and 7860
Local Guard Program cost centers:  5821, 5822 and 5823  (The count for LGP CC5826, net square meters assigned, equals the count in CC7820.)
For all other cost centers, please include the count for [NAME], Hamburg and Leipzig (DHL) in the location that provides the service (Berlin or Frankfurt)
Agencies
1150 DSCA - Defense Security Cooperation Agency
1150.0 DSCA - Defense Security Cooperation Agency
1235  AG - FAS (Foreign Agricultural Service)
1235.0 AG - FAS (Foreign Agricultural Service)
1330  DOC - ITA - Global Markets
1330.0 DOC - ITA - Global Markets
1525  DOJ - FBI - LEGATT, [NAME]
1525.0 DOJ - FBI - LEGATT, [NAME]
1900  STATE - DP (DIPLOMATIC PROGRAMS)
1900.0 STATE - DP (DIPLOMATIC PROGRAMS)
1901   STATE - ICASS
1901.0 STATE - ICASS
1920   STATE - OBO - CONSTRUCTION PROJECTS
1920.0 STATE - OBO - CONSTRUCTION PROJECTS
1920.2  STATE - OBO - REGIONAL SUPPORT CENTER
1920.2 STATE - OBO - REGIONAL SUPPORT CENTER
1931  STATE - DS - MSG SUPPORT
1931.0 STATE - DS - MSG SUPPORT
1942   STATE - DS (DIPLOMATIC SECURITY)
1942.0 STATE - DS (DIPLOMATIC SECURITY)
1954   STATE - CA (CONSULAR AFFAIRS)
1954.0 STATE - CA (CONSULAR AFFAIRS) |  |  |  | Official shipment
1967  STATE - PD (PUBLIC DIPLOMACY) |  |  |  | UAB
1967.0 STATE - PD (PUBLIC DIPLOMACY) |  |  |  | HHE
2121.1 ARMY - EUCOM, US European Cmd |  |  |  | POV
2121.2   ARMY - EUCOM, US European Cmd |  |  |  | CNS
5713   AIR FORCE - Seat of Govt Detachments |  |  |  | HHE by air
5713.0 AIR FORCE - Seat of Govt Detachments |  |  |  | HHE to storage
7005.1  DHS - TSA (Transportation Security Administration) |  |  |  | POV to storage
7005.1 DHS - TSA (Transportation Security Administration) |  |  |  | POV registration
7020 DHS - ICE - HSI - Intl Affairs Office |  |  |  | POV deregistration
7023   DHS - CBP - International Affairs Office |  |  |  | GOV registration
7023.0 DHS - CBP - International Affairs Office |  |  |  | GOV deregistration
7024  DHS - (IAP) and (NTC)
7024.0 DHS - (IAP) and (NTC) |  |  |  | AFOSI
7025  DHS - CBP - Container Security Initiative |  |  |  | CBP
7025.0 DHS - CBP - Container Security Initiative |  |  |  | CBP HH/BHV
9705  DOD - DIA, Defense Intelligence Agency |  |  |  | CG Hamburg
9705.0 DOD - DIA, Defense Intelligence Agency |  |  |  | CG Hamburg
9705.1  DOD - DIA LIAISON |  |  |  | [NAME]
9705.1 DOD - DIA LIAISON |  |  |  | CONS
9715  DOD - NGA - National Geospatial Agency |  |  |  | DAO
9715.0 DOD - NGA - National Geospatial Agency |  |  |  | DCM
9782  DOD - TSG |  |  |  | DIAL
9782.0 DOD - TSG |  |  |  | ECON
 |  |  |  | ESO
 |  |  |  | ESO
 |  |  |  | EXEC
 |  |  |  | FAC
 |  |  |  | FAS
 |  |  |  | FCS
 |  |  |  | FMC
 |  |  |  | GSO
 |  |  |  | GSO Housing
 |  |  |  | GSO Mail
 |  |  |  | GSO MP
 |  |  |  | GSO Procurement
 |  |  |  | GSO TVU
 |  |  |  | GSO Warehouse
 |  |  |  | HR
 |  |  |  | [NAME]
 |  |  |  | IM
 |  |  |  | ICE
 |  |  |  | IPC
 |  |  |  | ISC
 |  |  |  | ITC
 |  |  |  | JIS
 |  |  |  | LEGAT
 |  |  |  | MAC
 |  |  |  | MGT
 |  |  |  | MSG
 |  |  |  | NGA
 |  |  |  | OBO
 |  |  |  | ODC
 |  |  |  | PA
 |  |  |  | POL
 |  |  |  | RSO
 |  |  |  | TSA
 |  |  |  | TSG
 |  |  |  | USAREUR