Spreadsheet: 795976d1663052232-formula-referencing-an-intersection-between-row-and-column-excel-data-set-question
Sheet: Sheet2

 | APPLICANT NAME
 | NAME
 | COST SUMMARY FOR LABOR/EQUIPMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Intended Result
 | APPLICANT - FIPS# |  |  |  | DISASTER #: |  |  | PROJECT #: |  |  |  |  | FEMA CAT A-G |  |  | SUBMISSION TYPE |  |  |  | PERIOD COVERING
 | FIPS |  |  |  | DISASTER NUMBER |  |  | PROJECT NUMBER |  |  |  |  | B |  |  | 100% Complete
 | Employee/ Equipment |  | RATE w/ | STATUS | COST CODE | RATE | 2020-06-28 00:00:00 | 2020-06-29 00:00:00 | 2020-06-30 00:00:00 | 2020-07-01 00:00:00 | 2020-07-02 00:00:00 | 2020-07-03 00:00:00 | 2020-07-04 00:00:00 | 2020-07-05 00:00:00 | 2020-07-06 00:00:00 | 2020-07-07 00:00:00 | 2020-07-08 00:00:00 | 2020-07-09 00:00:00 | 2020-07-10 00:00:00 | 2020-07-11 00:00:00 | REG | OT1 | REG TIME COST | OT1 COST |  |  | 2020-06-28 00:00:00 | 2020-06-29 00:00:00 | 2020-06-30 00:00:00 | 2020-07-01 00:00:00 | 2020-07-02 00:00:00 | 2020-07-03 00:00:00 | 2020-07-04 00:00:00 | 2020-07-05 00:00:00 | 2020-07-06 00:00:00 | 2020-07-07 00:00:00 | 2020-07-08 00:00:00 | 2020-07-09 00:00:00 | 2020-07-10 00:00:00 | 2020-07-11 00:00:00 | 2020-07-12 00:00:00 | 2020-07-13 00:00:00 | 2020-07-14 00:00:00 | 2020-07-15 00:00:00 | 2020-07-16 00:00:00 | 2020-07-17 00:00:00 | 2020-07-18 00:00:00 | 2020-07-19 00:00:00 | 2020-07-20 00:00:00 | 2020-07-21 00:00:00 | 2020-07-22 00:00:00 | 2020-07-23 00:00:00 | 2020-07-24 00:00:00 | 2020-07-25 00:00:00
 |  |  | FRINGE |  |  |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  |  |  |  |  | [NAME]
 | [NAME] | REG | 40.2616123861648 | T |  |  | 7 | 8 | 8 | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  |  | 0 |  | 0 |  |  | [NAME]
 |  | OT1 | 56.75714079075622 | T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | [NAME]
 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  |  | Rocky
 | [NAME] | REG | 51.76592146947302 | T |  |  |  | 8 |  | 4 | 4 |  |  |  | 4 |  | 4 |  | 2 |  | 0 |  | 0 |  |  | [NAME]
 |  | OT1 | 72.97486411686116 | T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | [NAME]
 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  |  | [NAME]
 | [NAME] | REG | 43.13751020498768 | T |  |  |  | 8 | 8 |  |  |  |  |  | 8 | 8 |  |  |  |  | 0 |  | 0 |  |  | [NAME]
 |  | OT1 | 60.81131864725084 | T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 | Rocky | REG | 46.01149386909943 | T |  |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  | 0 |  | 0 |  |  | Name
 |  | OT1 | 64.86279810340835 | T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | Date
 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 | [NAME] | REG | 43.06848100071709 | T |  |  | 8 |  |  |  |  |  | 8 | 8 |  |  |  |  |  | 8 | 0 |  | 0
 |  | OT1 | 60.71400758509363 | T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 | [NAME] | REG | 40.2616123861648 | T |  |  |  |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 0 |  | 0
 |  | OT1 | 56.75714079075622 | T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 | [NAME] | REG | 40.2616123861648 | T |  |  |  | 8 | 8 | 8 | 8 | 8 | 8 |  | 8 | 8 | 8 | 8 | 8 | 8 | 0 |  | 0
 |  | OT1 | 56.75714079075622 | T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 | [NAME] | REG | 43.13751020498768 | T |  |  |  | 8 | 8 | 8 | 8 | 8 | 8 |  | 8 | 8 | 8 | 8 | 8 | 8 | 0 |  | 0
 |  | OT1 | 60.81131864725084 | T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LABOR - Page Total |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EQUIPMENT - Page Total |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LABOR - Grand Total |  |  |  | 10304 | 0 | 464773.5624872608 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EQUIPMENT - Grand Total |  |  |  | 0 |  | 0
 | page 2
 | APPLICANT - FIPS# |  |  |  | DISASTER #: |  |  | PROJECT #: |  |  |  |  | FEMA CAT A-G |  |  | SUBMISSION TYPE |  |  |  | PERIOD COVERING
 | FIPS |  |  |  | DISASTER NUMBER |  |  | PROJECT NUMBER |  |  |  |  | B |  |  | 100% Complete
 | Employee/ Equipment |  | RATE w/ | STATUS | COST CODE | RATE | 2020-07-12 00:00:00 | 2020-07-13 00:00:00 | 2020-07-14 00:00:00 | 2020-07-15 00:00:00 | 2020-07-16 00:00:00 | 2020-07-17 00:00:00 | 2020-07-18 00:00:00 | 2020-07-19 00:00:00 | 2020-07-20 00:00:00 | 2020-07-21 00:00:00 | 2020-07-22 00:00:00 | 2020-07-23 00:00:00 | 2020-07-24 00:00:00 | 2020-07-25 00:00:00 | REG | OT1 | REG TIME COST | OT1 COST
 |  |  | FRINGE |  |  |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 | [NAME] | REG | 0 | 0 |  |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  | 0 |  | 0
 |  | OT1 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 | [NAME] | REG | 0 | 0 |  |  |  | 4 |  | 8 |  | 8 |  |  |  | 2 |  | 8 | 5 |  | 0 |  | 0
 |  | OT1 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 | [NAME] | REG | 0 | 0 |  |  |  |  | 4 |  | 6 |  |  |  |  |  | 7 |  | 6 |  | 0 |  | 0
 |  | OT1 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 | Rocky | REG | 0 | 0 |  |  | 7 |  | 7 |  | 7 |  | 7 | 7 |  | 7 |  | 7 |  | 7 | 0 |  | 0
 |  | OT1 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 | [NAME] | REG | 0 | 0 |  |  |  | 8 | 8 |  | 8 |  |  | 8 |  | 8 | 8 |  |  | 8 | 0 |  | 0
 |  | OT1 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 | [NAME] | REG | 0 | 0 |  |  | 8 |  |  |  |  |  | 8 | 8 |  |  |  |  |  | 8 | 0 |  | 0
 |  | OT1 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 | [NAME] | REG | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  | OT1 | 0 | 0 |  |  |  | 8 | 8 | 8 | 8 | 8 | 8 |  | 8 | 8 | 8 | 8 | 8 | 8 |  | 0 |  | 0
 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 | [NAME] | REG | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  | OT1 | 0 | 0 |  |  |  | 8 | 8 | 8 | 8 | 8 | 8 |  | 8 | 8 | 8 | 8 | 8 | 8 |  | 0 |  | 0
 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LABOR - Page Total |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EQUIPMENT - Page Total |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LABOR - Grand Total |  |  |  | 10304 | 0 | 464773.5624872608 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EQUIPMENT - Grand Total |  |  |  | 0 |  | 0