Attachment11_Component_Inventory_Schedule_Form.xlsx
XLSX spreadsheet 66 KB Posted
- Attached to
- EVERGLADES MSD VISITOR CENTER EXHIBITS Federal contract opportunity
- Solicitation number
- 140P2125R0021
About this file
This is a Component Inventory Schedule Form template used for tracking and managing exhibit components for National Park Service projects. The Excel spreadsheet includes detailed tracking fields for various exhibit elements including wayside panels, bases, structures, cases, custom elements, graphics, electronic programs, and equipment. The form captures key information such as tracking numbers, descriptions, quantities, replacement costs, installation dates, dimensions, materials, and accessibility compliance for each component type. It includes a summary sheet for calculating total costs across different exhibit elements and general conditions like project management and installation. While this template appears related to the Everglades MSD Visitor Center Exhibits project, it is a blank form that would be used to inventory and track exhibit components once they are specified and installed.
The form uses a standardized coding system with specific prefixes (WP, WB, ST, CA, etc.) and government FMSS tracking numbers (G909401, G909402, etc.) to organize different exhibit elements. It contains multiple reference lists for materials, equipment types, and specifications that would be used in exhibit construction and installation. The form is designed to maintain detailed records of exhibit components for both initial installation and future maintenance/replacement purposes, with particular attention to accessibility compliance and technical specifications.
View the file
Other files for this federal contract opportunity
Show all 20
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Guide
| Attachment 11 Component Inventory Schedule Form | ||||||||||
| Type | - | Scene | . | Content Group | ID Number | Final Key Number | Description | Notes | Requirement | |
| SC | 01 | Not a direct reporting number, indicates the Area or Room, gathers Content Groups | Not Required | |||||||
| CG | 23 | Not a direct reporting number, Gathers all remaining "types" is used as class A estimate for project budgets | Not Required | |||||||
| WP | - | 01 | . | 23 | - | 456 | WP-01.23-456 | Wayside Panel | The graphic panel assembly in a wayside exhibit (Arguably part of an exhibit structure) | Required |
| WB | - | 01 | . | 23 | - | 456 | WB-01.23-456 | Wayside Base | The Wayside Base component (Arguably part of an exhibit structure) | Required |
| ST | - | 01 | . | 23 | - | 456 | ST-01.23-456 | Structures | Is a collector of GL, AO, CE, EE, EP. Fabricated from Sheet goods and stock | Required |
| CA | - | 01 | . | 23 | - | 456 | CA-01.23-456 | Cases | Is a collector of GL, AO, CE, EE, EP. Specialty Enclosure featres glass and acrylics | Required |
| CE | - | 01 | . | 23 | - | 456 | CE-01.23-456 | Custom Elements | Created by Model makers, Scenic producers, content reproductions, purchased consumables | Required |
| GL | - | 01 | . | 23 | - | 456 | GL-01.23-456 | Graphic Layouts | Gathers Ims and LA, for 2D Printed content, and used to manage production of Tactile signage and Maps | Required |
| EP | - | 01 | . | 23 | - | 456 | EP-01.23-456 | Electronic Programs | Software, visual media, interactive Software, movies | Required |
| EE | - | 01 | . | 23 | - | 456 | EE-01.23-456 | Electronic Equipment | Equipment, typically AV Hardware, playback and listening devices, controllers | Required |
| IM | - | 01 | . | 23 | - | 456 | IM-01.23-456 | Images | Photographs, illustrations, typically repurposed in Graphic Layouts | Not Required |
| AO | - | 01 | . | 23 | - | 456 | AO-01.23-456 | Acessioned Objects | Accessioned Objects, Artifacts, Park Collection elements | Not Required |
| LA | - | 01 | . | 23 | - | 456 | LA-01.23-456 | Labels | Script elements, Titles, Audio Descriptions, typically gathered into Graphic Layouts, but is used in Audio Description spreadhseets | Not Required |
| This is TXT | This is TXT | This is TXT | Number | Concatented string | ||||||
| Tracking Numbers | ||||||||||
| G909401 | Wayside Panel | |||||||||
| G909402 | Wayside Base | |||||||||
| G909403 | ST Structures | |||||||||
| G909404 | Graphic Layouts | |||||||||
| G909405 | Exhibit Cases | |||||||||
| G909406 | Lighting Systems | |||||||||
| G909407 | Custom Elements | |||||||||
| G909408 | Historic Furnishings (Captured on the Custom Elements Tab) | |||||||||
| G909409 | Electronic Programs | |||||||||
| G909409 | Electronic Equipment (Same As Programs) | |||||||||
| G123456 | Lighting Fixtures - NOT CURRENTLY A TRACKED ELEMENT. | |||||||||
| Notes: | ||||||||||
| 01 | The first number in the series should reflect the scene number | |||||||||
| 01-G123456 | The Middle sereis represents the Govt FMSS Tracking series description | |||||||||
| 01-G123456-123 | The last 3 digit number, can be any arrangement, advise making it a unique number progression after sorting by Key Number | |||||||||
| Notes | ||||||||||
| A | This spreadsheet can be populated directly from data entered into the HFC Museum Exhibit Planner | |||||||||
| B | Calculations fields must be checked to make sure all fields are included in summaries, and are within range of the summary |
Summary Sheet Interpretive Media Asset Inventory Cost Summary Enter data into green cells
Project: Fordyce Bathhouse Exhibits Awarded Contract Amount $0.00
| General Conditions: For each item below, enter value from original contract | Notes | Cost |
| Project Management, | Administrative, Overhead | $0 |
| Pre-Production | Drawings, Samples, Mock-ups | $0 |
| Shipping | $0 | |
| On-site Installation | Includes items not recoverable elsewhere, such as electrical upgrades, interior finishes, etc. included in the fabrication contract. | $0 |
| Closeout | $0 | |
| Total General Conditions: | $0 |
| Replacement Fabrication Costs by Type | Replacement Cost |
| ST Structures | $0 |
| CA Cases | $0 |
| GL Graphics | $0 |
| CE Custom Elements | $0 |
| LS Lighting System | $0 |
| FX Lighting Fixtures | $0 |
| EP Electronic Programs | $0 |
| EE Electronic Equipment | $0 |
| WP Wayside Panel | $0 |
| WB Wayside Base | $0 |
Total Fabrication Replacement Cost $0
Grand Total $0
Please recheck summary total calcs capture the all the cells
&"Arial Black,Regular"&8_x000D__x000D_
&"Arial Bold,Regular"&8Valor in the Pacific National Monument • Pearl Harbor Historic Sites, Hawaii &"Arial,Bold"&8Summary Page &P
Wayside Exhibit
| Wayside Exhibit | |
| Enter park district, trail, etc. where project is installed: |
Wayside Total (Calculated): $0
| G909401 Wayside Panel | Subtotal: | $0 | G909401 Wayside Panel | ||||||||||||||||
| Tracking # | Short Description | Tracking # of Parent (if applicable) | Quantity | Replacement Cost | Install Date | Est. Design Life (Yrs) | Panel Material | Panel Width in inches | Panel Height in inches | Panel Area in SF (calculated) | Digital File # | NPS Identity Compliance | Accessibility Compliance | Audio System | Brochure Holder | Replacement Location | GPS Latitude | GPS Longitude | Comment |
| 01-G909401-01 | 0.00 | ||||||||||||||||||
| 01-G909401-02 | 0.00 | ||||||||||||||||||
| 01-G909401-03 | |||||||||||||||||||
| 01-G909401-04 | |||||||||||||||||||
| 01-G909401-05 | |||||||||||||||||||
| (insert additional rows as needed) | 0.00 |
| G909402 Wayside Base | Subtotal: | $0 | G909402 Wayside Base | ||||||||||||||||
| Tracking # | Short Description | Tracking # of Parent (if applicable) | Quantity | Replacement Cost | Install Date | Est. Design Life (Yrs) | Base Type | Base Material | Carrier W" x H" | Base Height in. | Number of Core Panels | Upright Cluster Configuration | Base Finish | Base Mounting | Accessibility Compliance | Designated Accessible | GPS Latitude | GPS Longitude | Comment |
| 01-G909402-01 | |||||||||||||||||||
| 01-G909402-02 | |||||||||||||||||||
| 01-G909402-03 | |||||||||||||||||||
| 01-G909402-04 | |||||||||||||||||||
| 01-G909402-05 | |||||||||||||||||||
| (insert additional rows as needed) |
&"Arial,Bold"&9 Component Inventory: Approach and Aloha Court &"Arial,Bold"&9Page &P of &N
WP Wayside Panel
| Total | $0.00 | G909401 | |||||||||||||||||
| Tracking # | Short Description | Tracking # of Parent (if applicable) | Quantity | Replacement Cost | Install Date | Est. Design Life (Yrs) | Panel Material | Panel Width in inches | Panel Height in inches | Panel Area in SF (calculated) | Digital File # | NPS Identity Compliance | Accessibility Compliance | Audio System | Brochure Holder | Replacement Location | GPS Latitude | GPS Longitude | Comment |
| XX-G909401-XXX |
WB Wayside Base
| Total | $0.00 | G909402 | |||||||||||||||||
| Tracking # | Short Description | Tracking # of Parent (if applicable) | Quantity | Replacement Cost | Install Date | Est. Design Life (Yrs) | Base Type | Base Material | Carrier W" x H" | Base Height in. | Number of Core Panels | Upright Cluster Configuration | Base Finish | Base Mounting | Accessibility Compliance | Designated Accessible | GPS Latitude | GPS Longitude | Comment |
| XX-G909402-XXX |
ST Structures
| $0.00 | G909403 | |||||||||||
| Tracking # | Short Description | Quantity | Replacement Cost | Install Date | Est. Design Life (Yrs) | Exhibit ID# | Structure Type | Material / Construction | Size W" x H" x D" | Exposure to Environment | Accessibility Compliance | Comment |
| XX-G909403-XXX |
GL Graphic Layouts
| $0.00 | ||||||||||||||
| Tracking # | Short Description | Quantity | Replacement Cost | Install Date | Est. Design Life (Yrs) | Exhibit ID# | Graphic Type | Imaging Process | Substrate | Mount | Size W" x H" x D" | Exposure to Environment | Accessibility Compliance | Comment |
| XX-G909404-XXX |
CA Cases
| $0.00 | ||||||||||||||||
| Tracking # | Short Description | Quantity | Replacement Cost | Install Date | Est. Design Life (Yrs) | Exhibit ID# | Case Type | Conservation Grade Case? | Base Matl. / Finish | Base WxHxD | Vitrine Type | Vitrine Material | Vitrine WxHxD | Internal Lighting System | Accessibility Compliance | Comment |
| XX-G909405-XXX |
LS Lighting System
| $0.00 | |||||||||||
| Tracking # | Short Description | Quantity | Unit Cost | Replacement Cost | Install Date | Exhibit ID | Est. Design Life (Yrs) | Fixture/ System Type | No. of Fixtures | System Voltage | Placement |
| XX-G909406-XXX |
CE Custom Elements
| $0.00 | |||||||||||||
| Tracking # | Short Description | Quantity | Replacement Cost | Install Date | Est. Design Life (Yrs) | Exhibit ID# | 3D Element Type | Primary Mat'l or Construction | W x H x D inch | Exhibit Tactile / Touchable | Exposure to Environment | Accessibility Compliance | Comment |
| XX-G909407-XXX | Custom Element | ||||||||||||
| XX-G909408-XXX | Historic Furnishing |
EP Electronic Programs
| $0.00 | |||||||||||
| Tracking # | Name | Replacement Cost | Install Date | Est. Design Life (Yrs) | AV Program ID# | AV Program Type | Program/ Software Media | Programmed Lighting System | Exposure to Environment | Accessibility Compliance | Comment |
| XX-G909409-XXX |
EE Electronic Equipment
| $0.00 | ||||||||||||||
| Tracking # | Name | Parent ID | Quantity | Unit Cost | Replacement Cost | Install Date | Est. Design Life (Yrs) | Equipment ID | Proj Lamp | Eq. Size | Screen Ratio | Exposure to Environment | Accessibility Compliance | Comment |
| XX-G909409-XXX | REQUIRED |
FX Lighting Fixtures
| $0.00 | |||||||||||
| Tracking # | Short Description | Quantity | Unit Cost | Replacement Cost | Install Date | Exhibit ID | Est. Design Life (Yrs) | Fixture/ System Type | Specification | System Voltage | Placement |
| XX-G123456-XXX |
Legacy Lists
| WaysidePanelMaterials | WaysideBaseType | ExStructureType | GraphicType | CaseType | FixtureAccessories | Custom3DElementType | HistoricFurnishingType | AVProgramType | SoundEquipType | SignPanelMaterial |
| Acrylic | Upright | Exhibit Wall | Graphic Panel | Wall-mounted | Framing Projector | Natural History Model | Period Object | Video/ with sound | Amplifier | Acrylic |
| Aluminum | Low Profile | Platform/Base | Compound Graphic | Free-standing | Diffuser | Taxidermy | Wall/Ceiling Papers | Video/ no sound | Loudspeakers | Aluminum |
| Cast Iron | Wall Mount | Rail / Rail System | Banner / Flexible Graphic | Built-in | Gobos | Prop | Wall Coverings | Audio Station | Headphones | Concrete |
| Cast Aluminum | Kiosk | Ceiling / Overhead Struct | Applied Graphic | Barn Doors | Scale Model | Window Treatments | Soundscape | Handset | Fiberglass Embed. | |
| Concrete | Info Desk | BaseMaterial/Finish | Filters | Dimensional Map | Room Fixtures | Portable/Handheld Tour | Audio Wand | Fiberglass | ||
| Fiberglass | WaysideBaseMaterial | Storage Unit | Imaging Process | Acrylic | Diorama/Tableau | Multimedia/Interactive | Glass | |||
| Fiberglass Embed | Aluminum | Seating | Inkjet / Photo Output | Aluminum | LampType | Life-size Figure/Mannequin | HistoricFurnishingMaterial | AVControlSysType | High Press. Laminate | |
| Etched/Anod. Alum | Galvanized Steel | High Press. Laminate (HPL) | Concrete | Halogen | Interactive (non-electronic) | Paper | Program/SoftwareMedia | Pushbutton | Masonry/Stone | |
| Laminate | Weathering Steel | Cut / Routed | Fiberglass Embedment | Standard Incandescent | Mechanical/Electromech Device | Wood | DVD | Simple Microproc. (Superbox) | Metal | |
| High Pres Laminate | Stainless Steel | ExStructureMaterial | Silk Screen | FiberglassGlass | Compact Fluorescent | Metal | CD | Complex Microproc. (AMX/Creston) | Plastic | |
| Masonry/Stone | Wood | Wood Structure | Hand Painted | High Pressure Laminate | Standard Fluorescent | Custom3dElementMaterial | Fabric | LaserDisc | Relay Logic (Potter&Brum/Omron) | Recycled Plastic |
| Plastic | Metal Structure | Multiple Processes | Masonry/Stone | Metal Halide | Wood | Glass/Ceramic | Audiotape | Programmable Logic (GE Farnum) | Steel | |
| Recycled Plastic | UpClustConfig | Plastic / Composite | Metal | LED | Metal | Plastic | Flash Drive | Timber | ||
| Porcelain Enamel | Single | Paint | Fiberglass | Videotape | AVProgrammed Lighting Sys. | Wood | ||||
| Steel | Double Inline | GraphicSubstrate | Plastic | LightPlacement | Coated Foam | Computer Hard Drive | Lighting Dimmers | |||
| Timber | Double Offset | Environment | Paper | Recycled Plastic | Room Ceiling | Acrylic | 35mm Slides | Fixtures | SignLocation | |
| Wood | Triangle | Climate Controlled Bldg | Fabric | Steel | Mounted on Exhibit | Plastic | Medium Format Slides (Hasselblad) | Lamps | Interior | |
| Bulletin Board | Square | Non Climate Controlled Bldg | Vinyl | Timber | Multiple Locations | Glass | 16mm Motion Picture | Ancillary Equip. | Exterior | |
| Glass | Outside Under Roof | None (applied direct to structure) | Wood | Room Wall | Fabric | 35mm Motion Picture | ||||
| Outside Exposed | Structure | Stone/Aggregate | AVAccessEquip | SignType | ||||||
| WayBase Finish | Treated Organic Mat'l | AVPlayerType | Caption Board | Kiosk | ||||||
| Paint | Graphic Mount | Vitrine Type | LightAncilliary | Multiple Mat'ls | DVD Player | Caption Decoder | Entrance Sign | |||
| YesNo | Brushed | Wood | 1 side (window) | Lighting track (lin ft.) | CD, Videodisk Player | Audio Descrip.Transmitter | Visitor Info. | |||
| Yes | Sandblasted | Metal | 2 sides | Dimmers | CustomExTactile | Computer/Media Server | Audio Descript. Receiver | Regulatory | ||
| No | Stained | Plastic / Composite | 3 sides | Motion Sensors | Not Touchable | Solid-State (Flash Drive) | Assistive Listening | Identification | ||
| Sealed | Alumin. w/overlam & backing panel | 4 sides | External Transformers | Can Be Touched | Portable/Handheld | Transmitter Assist Listening Receiver | ||||
| ReplaceAvail | none | Fabric / Banner | 5 sides | Fiber Optic Components | Touch Encouraged | Videocassette (VCR) | SignDesign | |||
| Park | Substrate applied direct to structure | AVAncillaryEquip | Carved | |||||||
| HFC | WayBase Mount | FixtureAccessories | CustomExAncil | VideoMonitorType | Equipment Racks | Painted | ||||
| Not Available | Direct embed (in ground) | VitrineMaterial | Framing Projector | Electrical Equip | Cathode Ray Tube (CRT) | Cables | Etched Photo | |||
| Rail Mount | Acrylic | Diffuser | Mechanical Equip | Liquid Crystal (LCD) | Connectors | Routed | ||||
| Sled Mount | Non-glare Acrylic | Gobos | Plasma | Surge Protectors | Applied Vinyl | |||||
| Base Plate | Glass | Barn Doors | Touch Screen | Cast Alum/Bronze | ||||||
| Wall Mount | Non-glare Glass | Filters | ||||||||
| Special Security (describe in comments) | VideoAspectRatio | SignFrameStructMatl | ||||||||
| LightSystemType | 4:3 Standard | Aluminum | ||||||||
| CaseInternalLighting | Track Mounted | 16:9 Widescreen | Alum. Painted | |||||||
| Fiber optic | Permanently Mounted | Concrete Masonary Unit | ||||||||
| Incandescent | Fiber Optic | Video Resolution | Concrete | |||||||
| LED | Portable Fixtures | Standard Definition | Fiberglass | |||||||
| Fluorescent | High Definition | Masonry/Stone | ||||||||
| None | Metal | |||||||||
| ProjectorType | Recycled Plastic | |||||||||
| CRT Video/Data | Steel Galvanized | |||||||||
| CaseAncilliaryEquip | LCD Video/Data | Steel Weathering | ||||||||
| Motion Sensor | DLP Video/Data | Wood | ||||||||
| Breakage Sensor | 35mm Slide Carousel | |||||||||
| Motion and Breakage Sensor | Medium Format Hasselblad | SignFrameStructType | ||||||||
| Passive buffering (desiccant) | 16mm Motion Picture Film | Single Post | ||||||||
| Dedicated HVAC System | 35mm Motion Picture Film | Double Post | ||||||||
| Triple Post | ||||||||||
| ProjectorLampType | Monolithic Base | |||||||||
| Halogen | Base w/ Side Column | |||||||||
| Metal Haide | Wall Mount | |||||||||
| LED | ||||||||||
| SignBaseType | ||||||||||
| ProjectorScreenType | Upright | |||||||||
| Fixed Wall Front Projection | Reverse Angle/Low Profile | |||||||||
| Fixed Wall Rear Projection | ||||||||||
| Retractable Wall (Manual) | PostType | |||||||||
| Retractable Wall (Motorized) | Standard Post | |||||||||
| Portable Screen | Breakaway Post | |||||||||
| PostSize | ||||||||||
| 2x2 | ||||||||||
| 4x4 | ||||||||||
| 4x6 | ||||||||||
| W10 | ||||||||||
| W20 |
File details come from the government source that posted it. Updated .