3-24 Developing the Damage Inventory: Filling the Template

Background visual information:

A Microsoft Excel Worksheet is displayed.

Pertinent visual information:

At the top on the left side is a drop-down menu that reads "M12," followed by three two buttons labeled with an X and a checkmark, followed by a function button, followed by the formula of the selected cell, which is blank. Below is a spread sheet with a label in the bottom left corner reading "Damage Inventory."

The spreadsheet displays columns A through Q and row 1 through 20. The spreadsheet has information spread throughout some of its cells: three rows have four columns of information, three rows have two columns of information, and two rows have 16 columns of information.

From top to bottom (rows), and left to right (columns), the three rows with four columns of information read as follows: row one reads "Disaster Number:" "4332DR," "Program Delivery Manager (PDMG) Name:" and "PDMG0125"; row two reads "Applicant Name:" "Glenville - PDMG0125 - 4332DR (4332DR - 125)," "Program Delivery Manager (PDMG) Phone:" and "(555) 555-5555"; row three reads "Applicant FIPS:" 4332DR - 125," Program Delivery Manager (PDMG) Email: PDMG0125@fema.gov."

From top to bottom (rows), and left to right (columns), the three rows with two columns of information read as follows: row one reads "Applicant Point of Contact Name:" and "Doe, John"; row two reads "Applicant Point of Contact Phone:" and "(555) 555-5555"; and row three reads "Applicant Point of Contact Email:" and "58922john@PDMG0125.gov."

From left to right, the first row with 16 columns reads, "Category," "Name of damage/facility," "Address 1," "Address 2," "City," "State," "Zip," "Latitude," "Longitude," "Describe Damage," "Primary Cause of Damage," "Approx. Cost," "% Work Complete," "Labor Type," "Has received grant(s) on the facility in a past?" and "Applicant priority." The second row with 16 columns reads, from left to right, "E," "Fire Station #9," "1611 Headway Cir," "Bldg 2," "Austin," "TX," "78754," "30.33234," "-97668259," "10000sf 2 story, no basement 5 dorm rooms with 1-2 ft. standing flood water for 1 day. Drywall, carpet, bed, chair and desk. 5 windows damage and Parking lot lights," "Hurricane," "$50,000," "30%," "FA," "U," and "High."