Spreadsheet: 799958d1665414273-if-or-question-excel-forum
Sheet: Sheet1

 |  |  |  | CLIENT:
 |  |  |  | PROJECT
Installation Date | Seal ID | Fire Rating | Level | Location | Seal Type | X | Y | Penetrating Service | Drawing Ref | Cost Breakdown | SOR | Working Through Grid  + 0.5 Uplift | Identical seals | Total Cost
30 Sep 2022 | [NAME] | Working Through Grid - 60 min | 6 | 74 | Mastic Only Penetration | 50 | 50 | Cable | 652-586 B Fire Stretegy Plan - Floor 6 | Mastic Only Penetration: 19.20 |  |  |  | 19.2
30 Sep 2022 | BD-0230 | Working Through Grid - 60 min | 6 | 74 | Mastic Only Penetration | 50 | 50 | Cable | 652-586 B Fire Stretegy Plan - Floor 6 | Mastic Only Penetration: 38.40 |  |  | 1 | 38.4
30 Sep 2022 | BD-0229 | Working Through Grid - 60 min | 6 | 74 | Mastic Only Penetration | 50 | 50 | Cable | 652-586 B Fire Stretegy Plan - Floor 6 | Mastic Only Penetration: 38.40 |  |  | 2 | 57.6
30 Sep 2022 | BD-0228 | Working Through Grid - 60 min | 6 | 74 | Mastic Only Penetration | 50 | 50 | Cable | 652-586 B Fire Stretegy Plan - Floor 6 | Mastic Only Penetration: 19.20 |  |  | 3 | 76.8
30 Sep 2022 | BD-0227 | Working Through Grid - 60 min | 6 | 74 | Mastic Only Penetration | 50 | 50 | Cable | 652-586 B Fire Stretegy Plan - Floor 7 | Mastic Only Penetration: 19.20 |  |  | 4 | 96
30 Sep 2022 | jt-0185 | Working Through Grid - 60 min | Level 6 | 70 | Mastic Only Penetration | 50 | 50 | Cable | 652-586 B Fire Stretegy Plan - Floor 8 | Mastic Only Penetration: 19.20 |  |  | 5 | 115.2
30 Sep 2022 | jt-0184 | Working Through Grid - 60 min | Level 6 | 70 | Intumescent [NAME] and Mastic | 300 | 200 | Cable | 652-586 B Fire Stretegy Plan - Floor 6 | Intumescent [NAME] and Mastic: 41.70 |  |  |  | 41.7
30 Sep 2022 | TC-0187 | Working Through Grid - 60 min | 5 | 61 | [NAME] | 70 | 70 | Cable | 652-586 B Fire Stretegy Plan - Floor 5 | [NAME]: 11.40 Mastic Back Box: 11.25 |  |  |  | 22.65
30 Sep 2022 | TC-0186 | Working Through Grid - 60 min | 5 | 61 | [NAME] | 70 | 70 | Cable | 652-586 B Fire Stretegy Plan - Floor 5 | [NAME]: 13.35 |  |  |  | 13.35
30 Sep 2022 | BD-0226 | Air Seal | 6 | 75 | Mastic Only Penetration | 180 | 180 | Plastic Pipe | 652-586 B Fire Stretegy Plan - Floor 6 | Mastic Only Penetration: 18.80 |  |  |  | 18.8
30 Sep 2022 | BD-0225 | 60 Min | 6 | 75 | Intumescent [NAME] and Mastic | 250 | 200 | Plastic Pipe | 652-586 B Fire Stretegy Plan - Floor 6 | Intumescent [NAME] and Mastic: 18.80 Wrap or  High Expansion Mastic: 19.00 |  |  |  | 37.8
30 Sep 2022 | rs-0116 | Working Through Grid - 60 min | 6 | 11 | Mastic Only Penetration | 50 | 50 | Cable | 652-586 B Fire Stretegy Plan - Floor 6 | Mastic Only Penetration: 19.20 |  |  |  | 19.2
30 Sep 2022 | jt-0183 | Working Through Grid - 30 min | Level 6 | 70 | Trapezoidal Infills - Linear Meter | 1000 | 100 | Cable | 652-586 B Fire Stretegy Plan - Floor 6 | Trapezoidal Infills - Linear Meter: 57.00 |  |  |  | 57
30 Sep 2022 | BD-0226 | Air Seal | 6 | 75 | Mastic Only Penetration | 180 | 180 | Plastic Pipe | 652-586 B Fire Stretegy Plan - Floor 6 | Mastic Only Penetration: 18.80 | 18.8 |  |  | 18.8
30 Sep 2022 | BD-0225 | 60 Min | 6 | 75 | Intumescent [NAME] and Mastic | 250 | 200 | Plastic Pipe | 652-586 B Fire Stretegy Plan - Floor 6 | Intumescent [NAME] and Mastic: 18.80 Wrap or  High Expansion Mastic: 19.00 | 37.8 |  |  | 37.8