Spreadsheet: 753782d1635761605-power-query-present-data-from-colom-to-row-bq-v3e-for-expert-group3
Sheet: Input

Entry ID | Equip ID | Location and Equip ID | Group | Service | [NAME] ([NAME]) | Height ([NAME]) | Length (m) | Area (m2) | Material Description | Qty / Area / Length | Component / Accessories | Component / Accessories Qty | RD Straight Duct | [NAME] 90 | [NAME] 45 | RD Reducer | RD Collar | RD End Cap | FR2HR | FR2HRCDS | INT25 | INT50 | EXT25 | [NAME] | KF25 | IPA | PAINT | GI-JACKET-50
1 | CEF-B3-Z02-A,B,C | B2, ZONE 01, CEF-B3-Z02-A,B,C (Sheet 1) | GI | EAD | 750 | 500 | 55.7 | 139.25 | A1 - GI Group, TDF Joint, Pittsburge Seam, GI 0.8mm (501 - 1000) | 139.3 |  |  |  |  |  |  |  |  |  |  |  |  | 139.25
2 | CEF-B3-Z02-A,B,C | B2, ZONE 01, CEF-B3-Z02-A,B,C (Sheet 1) | GI HG | CEAD | 2200 | 850 | 22.6 | 137.86 | A5 - GI HG Group, TDF Joint, Pittsburge Seam, GI 1.2mm (1 - 10000) | 137.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 137.86
3 | CEF-B3-Z02-A,B,C | B2, ZONE 01, CEF-B3-Z02-A,B,C (Sheet 1) | GI HG | EAD | 550 | 400 | 55.7 | 105.83 | A5 - GI HG Group, TDF Joint, Pittsburge Seam, GI 1.2mm (1 - 10000) | 105.9 |  |  |  |  |  |  |  |  | 139.25
4 | CEF-B3-Z02-A,B,C | B2, ZONE 01, CEF-B3-Z02-A,B,C (Sheet 1) | GI HG | EAD | 450 | 400 | 59.6 | 101.32 | A5 - GI HG Group, TDF Joint, Pittsburge Seam, GI 1.2mm (1 - 10000) | 101.4 |  |  |  |  |  |  |  |  | 137.08
5 | CEF-B3-Z02-A,B,C | B2, ZONE 01, CEF-B3-Z02-A,B,C (Sheet 1) | GI HG | EAD | 750 | 500 | 5.6 | 14 | A5 - GI HG Group, TDF Joint, Pittsburge Seam, GI 1.2mm (1 - 10000) | 14 |  |  |  |  |  |  |  |  | 17.36
6 | CEF-B3-Z02-A,B,C | B2, ZONE 01, CEF-B3-Z02-A,B,C (Sheet 1) | GI RD | CEAD | 500 | RD | 8.5 | 13.3535 | Z2 - GI RD Group, Socket Joint, Spiral / Gore Seam, GI 0.6mm (101 - 500) | 13.4 |  |  | 1 | 2 | 3 | 4 | 5 | 6
7 | CEF-B3-Z02-A,B,C | B2, ZONE 01, CEF-B3-Z02-A,B,C (Sheet 1) | GI | EAD |  |  |  |  |  |  | Access Door | 2
8 | CEF-B3-Z02-A,B,C | B2, ZONE 01, CEF-B3-Z02-A,B,C (Sheet 1) | GI | EAD |  |  |  |  |  |  | VCD | 2
9 | ACMV-EAF-B2-1.103-ME-01-A,B | B2, ZONE 01, ACMV-EAF-B2-1.103-ME-01-A,B (Sheet 2) | GI | EAD | 350 | 300 | 3.6 | 4.680000000000001 | A1 - GI Group, TDF Joint, Pittsburge Seam, GI 0.6mm (1 - 500) | 4.699999999999999 |  |  |  |  |  |  |  |  | 6.84 |  |  | 4.680000000000001
10 | ACMV-EAF-B2-1.103-ME-01-A,B | B2, ZONE 01, ACMV-EAF-B2-1.103-ME-01-A,B (Sheet 2) | GI | EAD | 350 | 300 | 13.2 | 17.16 | A1 - GI Group, TDF Joint, Pittsburge Seam, GI 0.6mm (1 - 500) | 17.2 |  |  |  |  |  |  |  |  | 25.08
11 | ACMV-EAF-B2-1.103-ME-01-A,B | B2, ZONE 01, ACMV-EAF-B2-1.103-ME-01-A,B (Sheet 2) | GI | EAD | 500 | 500 | 1.6 | 3.2 | A1 - GI Group, TDF Joint, Pittsburge Seam, GI 0.6mm (1 - 500) | 3.2 |  |  |  |  |  |  |  |  |  |  |  |  | 3.2
12 | ACMV-EAF-B2-1.103-ME-01-A,B | B2, ZONE 01, ACMV-EAF-B2-1.103-ME-01-A,B (Sheet 2) | GI | EAD | 450 | 400 | 3.5 | 5.95 | A1 - GI Group, TDF Joint, Pittsburge Seam, GI 0.6mm (1 - 500) | 6 |  |  |  |  |  |  |  |  |  |  |  |  | 5.95
13 | ACMV-EAF-B2-1.103-ME-01-A,B | B2, ZONE 01, ACMV-EAF-B2-1.103-ME-01-A,B (Sheet 2) | GI | EAD | 350 | 300 | 12.9 | 16.77 | A1 - GI Group, TDF Joint, Pittsburge Seam, GI 0.6mm (1 - 500) | 16.8 |  |  |  |  |  |  |  |  |  |  |  |  | 16.77
14 | ACMV-EAF-B2-1.103-ME-01-A,B | B2, ZONE 01, ACMV-EAF-B2-1.103-ME-01-A,B (Sheet 2) | GI | EAD | 500 | 250 | 0.8 | 1.2 | A1 - GI Group, TDF Joint, Pittsburge Seam, GI 0.6mm (1 - 500) | 1.2 |  |  |  |  |  |  |  |  |  |  |  |  | 1.2
15 | ACMV-EAF-B2-1.103-ME-01-A,B | B2, ZONE 01, ACMV-EAF-B2-1.103-ME-01-A,B (Sheet 2) | GI | EAD | 750 | 500 | 0 | 0 | A1 - GI Group, TDF Joint, Pittsburge Seam, GI 0.8mm (501 - 1000) | 0
16 | ACMV-EAF-B2-1.103-ME-01-A,B | B2, ZONE 01, ACMV-EAF-B2-1.103-ME-01-A,B (Sheet 2) | GI | EAD | 350 | 600 | 1.7 | 3.23 | A1 - GI Group, TDF Joint, Pittsburge Seam, GI 0.8mm (501 - 1000) | 3.3 |  |  |  |  |  |  |  |  |  |  |  |  | 3.23
17 | ACMV-EAF-B2-1.103-ME-01-A,B | B2, ZONE 01, ACMV-EAF-B2-1.103-ME-01-A,B (Sheet 2) | GI | EAD | 1600 | 600 | 0.8 | 3.52 | A1 - GI Group, TDF Joint, Pittsburge Seam, GI 1.0mm (1001 - 2450) | 3.6 |  |  |  |  |  |  |  |  |  |  |  |  | 3.52
18 | ACMV-EAF-B2-1.103-ME-01-A,B | B2, ZONE 01, ACMV-EAF-B2-1.103-ME-01-A,B (Sheet 2) | GI | EAD | 1600 | 450 | 0.5 | 2.05 | A1 - GI Group, TDF Joint, Pittsburge Seam, GI 1.0mm (1001 - 2450) | 2.1 |  |  |  |  |  |  |  |  |  |  |  |  | 2.05
19 | ACMV-EAF-B2-1.103-ME-01-A,B | B2, ZONE 01, ACMV-EAF-B2-1.103-ME-01-A,B (Sheet 2) | GI | EAD |  |  |  |  |  |  | Access Door | 2
20 | ACMV-EAF-B2-1.103-ME-01-A,B | B2, ZONE 01, ACMV-EAF-B2-1.103-ME-01-A,B (Sheet 2) | GI | EAD |  |  |  |  |  |  | VCD | 2
21 | ACMV-EAF-B2-1.103-ME-01-A,B | B2, ZONE 01, ACMV-EAF-B2-1.103-ME-01-A,B (Sheet 2) | GI | EAD |  |  |  |  |  |  | FD | 2
22 | ACMV-EAF-B2-1.103-ME-01-A,B | B2, ZONE 01, ACMV-EAF-B2-1.103-ME-01-A,B (Sheet 2) | GI | EAD |  |  |  |  |  |  | Mesh | 2