TE I-001_AFH Inventory and Space Assignment.xlsx

This file is an inventory and space assignment spreadsheet for Armed Forces Housing (AFH) and General Flag Officer Quarters (GFOQ) at USAG Stuttgart. The document contains two primary sections: a space assignment summary and a detailed bedroom room inventory.

The space assignment section lists 1,321 total housing units across multiple buildings, with a combined capacity measurement of 551,810 and net square footage of 3,426,686. Units are categorized by occupant rank/designation (LTC/MAJ, CO/W0, SR NCO, JR NCO/ENL, Colonel, General Officers) and include both family housing (ranging from 1-bedroom to 5-bedroom units) and general flag officer quarters (GFOQ). Buildings are designated by functional location codes (GE70V, GE80J, GE09D, GE43X, GE55T) and numbered identifiers (154-187, 2400-2452, 2500-2540, 3100-3436). The inventory section provides granular detail on individual units within each building, specifying bedroom configurations (2BDR through 6BDR) with corresponding functional location codes and system status classifications. Several units are noted with status indicators such as "Q4_pause" and "FY25 pause all PMO," indicating scheduling or funding constraints. The document references WBS elements and funding codes (M.0090729.18.2.1 and M.0090729.18.1.1) associated with housing projects and maintenance programs.