Spreadsheet: 753839d1635782194-power-query-present-data-from-colom-to-row-bq-v3e-for-expert-group3
Sheet: Table5 (2)

Entry ID | Equip ID | Location and Equip ID | Group | Service | [NAME] ([NAME]) | Height ([NAME]) | Length (m) | Area (m2) | Material Description | Value
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 | Qty / Area / Length | 139.3
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 | EXT25 | 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 | Qty / Area / Length | 137.9
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 | PAINT | 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 | Qty / Area / Length | 105.9
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 | FR2HR | 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 | Qty / Area / Length | 101.4
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 | FR2HR | 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 | Qty / Area / Length | 14
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 | FR2HR | 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 | Qty / Area / Length | 13.4
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 | RD Straight Duct | 1
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 | [NAME] 90 | 2
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 | [NAME] 45 | 3
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 | RD Reducer | 4
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 | RD Collar | 5
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 | RD End Cap | 6
7 | CEF-B3-Z02-A,B,C | B2, ZONE 01, CEF-B3-Z02-A,B,C (Sheet 1) | GI | EAD |  |  |  |  | Component / Accessories | Access Door
7 | CEF-B3-Z02-A,B,C | B2, ZONE 01, CEF-B3-Z02-A,B,C (Sheet 1) | GI | EAD |  |  |  |  | Component / Accessories Qty | 2
8 | CEF-B3-Z02-A,B,C | B2, ZONE 01, CEF-B3-Z02-A,B,C (Sheet 1) | GI | EAD |  |  |  |  | Component / Accessories | VCD
8 | CEF-B3-Z02-A,B,C | B2, ZONE 01, CEF-B3-Z02-A,B,C (Sheet 1) | GI | EAD |  |  |  |  | Component / Accessories Qty | 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 | Qty / Area / Length | 4.699999999999999
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 | FR2HR | 6.84
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 | INT50 | 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 | Qty / Area / Length | 17.2
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 | FR2HR | 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 | Qty / Area / Length | 3.2
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 | EXT25 | 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 | Qty / Area / Length | 6
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 | EXT25 | 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 | Qty / Area / Length | 16.8
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 | EXT25 | 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 | Qty / Area / Length | 1.2
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 | EXT25 | 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 | Qty / Area / Length | 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 | Qty / Area / Length | 3.3
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 | EXT25 | 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 | Qty / Area / Length | 3.6
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 | EXT25 | 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 | Qty / Area / Length | 2.1
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 | EXT25 | 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 |  |  |  |  | Component / Accessories | Access Door
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 |  |  |  |  | Component / Accessories Qty | 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 |  |  |  |  | Component / Accessories | VCD
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 |  |  |  |  | Component / Accessories Qty | 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 |  |  |  |  | Component / Accessories | FD
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 |  |  |  |  | Component / Accessories Qty | 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 |  |  |  |  | Component / Accessories | Mesh
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 |  |  |  |  | Component / Accessories Qty | 2