Maximo_SMMC_Assets.xlsx

This file is a Maximo Asset Management System (SMMC_Assets.xlsx) spreadsheet maintained by San Mateo County, California, documenting a comprehensive inventory of facility equipment and systems across approximately 100 county facilities totaling approximately 4.5 million gross square feet. The spreadsheet contains detailed asset records organized by location (F49441 facility code), asset type, and operational status, with columns for asset numbers, location codes, asset classification (PEQ = Plant Equipment), operational status (all listed as OPERATING), failure codes, equipment descriptions, manufacturers, zone assignments, and ownership designations. The asset inventory encompasses over 2,000 individual equipment items including fire extinguishers, emergency lighting units, ice machines, refrigeration equipment, pumps, chillers, boilers, air handling units, exhaust fans, cooling towers, electrical panels, transfer switches, backflow preventors, doors, emergency medical vacuum systems, and miscellaneous mechanical, electrical, and plumbing systems. Equipment manufacturers referenced include Carrier, Trane, Gylord, Ajax, Belgos, Watts, Febco, Reco, Hobart, and numerous others, with most assets assigned to SMC Zone 2 and designated as County (CO) ownership.

This asset register serves as a foundational baseline document directly supporting the County of San Mateo's Facility Condition Assessment and Asset Management Solution initiative, wherein a qualified contractor will conduct on-site facility condition assessments following ASTM E2018-24 standards, perform discrete equipment inventories, affix durable 2D barcode tags to maintainable systems, and compile and validate a unified Master Equipment Register that establishes identical data baseline synchronization between IBM Maximo Application Suite SaaS and a cloud-based Facility Condition Information System (FCIS). The existing Maximo asset data represented in this spreadsheet will be migrated, validated, and enhanced through the assessment process to support real-time Facility Condition Index calculations, multi-year capital renewal modeling, and RSMeans-based cost estimating, with optional Phase 2 scope including development of standard preventive maintenance job plans and task check-sheets formatted for batch upload into Maximo environments.