Spreadsheet: 866545d1713460792-sumproduct-and-subtotal-for-structured-table-example
Sheet: BALANCE

 |  | TOTAL BASE CASE - DIRECT COST [€] DECEMBER 2023
 |  | TOTAL BASE CASE - DIRECT COST [€] DECEMBER 2023
 |  | Product Type Description | BASE CASE (BUY FROM NASS) - DIRECT COST [€] | ANNUAL USAGE DECEMBER 2023
 |  | Pilot without Coil | 0 | 0
 |  | Pilot Valve | 0 | 0
 |  | Pilot Valve | 49.36 | 47
 |  | Pilot without Coil | 0 | 0
 |  | Pilot Valve | 16.01 | 148
 |  | Pilot Valve | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Pilot without Coil | 5.68 | 0
 |  | Pilot Valve | 27.9 | 325
 |  | Pilot without Coil | 9.1 | 100
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 8.55 | 310
 |  | Pilot without Coil | 7.62 | 387
 |  | Pilot Valve | 16.01 | 106
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 11.57 | 25
 |  | Pilot Valve | 0 | 0
 |  | Pilot Valve | 23.43 | 1
 |  | Pilot without Coil | 0 | 0
 |  | Pilot without Coil | 0 | 50
 |  | SBSA | 1.86 | 140892
 |  | Pilot Valve | 0 | 0
 |  | Pilot Valve | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Pilot Valve | 20.3 | 179
 |  | Pilot without Coil | 0 | 0
 |  | SBSA | 1.86 | 55437
 |  | Pilot without Coil | 0 | 0
 |  | Pilot Valve | 17.54 | 596
 |  | Pilot Valve | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 12.75 | 134
 |  | Pilot Valve | 0 | 0
 |  | Pilot Valve | 44.95 | 85
 |  | Coil | 3.09 | 104
 |  | Pilot Valve | 0 | 0
 |  | Pilot Valve | 37.9 | 42
 |  | Pilot without Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Pilot without Coil | 10.07 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Pilot without Coil | 12.12 | 834
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 12.51 | 45
 |  | Pilot Valve | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 2.25 | 6384
 |  | Coil | 2.99 | 109
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 2.25 | 919
 |  | Coil | 0 | 0
 |  | Coil | 1.42 | 1000
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 3.57 | 13289
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 8.07 | 11
 |  | SBSA | 4.62 | 5991
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | SBSA | 4.69 | 352
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | SBSA | 4.3 | 190
 |  | Coil | 1.73 | 1850
 |  | Coil | 16.88 | 7
 |  | SBSA | 2.27 | 395
 |  | Coil | 1.65 | 1398
 |  | Coil | 13.53 | 15
 |  | SBSA | 3.24 | 4200
 |  | Coil | 0 | 0
 |  | SBSA | 3.85 | 2883
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 7289
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | SBSA | 8.87 | 11
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 2430
 |  | Coil | 0 | 0
 |  | SBSA | 3.05 | 6918
 |  | Coil | 6.62 | 9
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 4.04 | 6820
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | SBSA | 4.69 | 283
 |  | Coil | 0 | 0
 |  | SBSA | 2.42 | 742
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 11 | 2971
 |  | Coil | 6.7 | 1440
 |  | SBSA | 4.69 | 154
 |  | Coil | 0 | 0
 |  | Coil | 4.55 | 5045
 |  | SBSA | 3.58 | 368
 |  | Coil | 12.37 | 2899
 |  | Coil | 0 | 0
 |  | Coil | 6.02 | 861
 |  | Coil | 15.08 | 117
 |  | SBSA | 4.44 | 811
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 18 | 80
 |  | Coil | 0 | 0
 |  | Pilot Valve | 7.57 | 4716
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 15.7 | 254
 |  | Coil | 0 | 0
 |  | Coil | 15.08 | 820
 |  | Coil | 0 | 0
 |  | Coil | 29.68 | 1486
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 9.91 | 309
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 9.91 | 1639
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 12.32 | 84
 |  | Pilot without Coil | 11.61 | 1288
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Pilot without Coil | 18.19 | 13
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 3.6 | 8644
 |  | Coil | 0 | 0
 |  | Pilot Valve | 18.5 | 405
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 15.9 | 4
 |  | Pilot without Coil | 0 | 0
 |  | Pilot without Coil | 13.53 | 1771
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 13.86 | 22
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 8.16 | 6095
 |  | Coil | 0 | 0
 |  | Pilot Valve | 12.6 | 5067
 |  | Coil | 6.56 | 83
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 7.78 | 4512
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 2467
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot Valve | 18.5 | 3964
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 21.11 | 0
 |  | Coil | 0 | 0
 |  | Pilot Valve | 12.6 | 2499
 |  | Coil | 24.9 | 174
 |  | Coil | 0 | 0
 |  | Pilot Valve | 12.6 | 601
 |  | Coil | 5.91 | 1176
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 8.07 | 182
 |  | Pilot Valve | 12.6 | 491
 |  | Pilot without Coil | 4.35 | 729
 |  | Coil | 0 | 0
 |  | Coil | 2.14 | 3859
 |  | Coil | 0 | 0
 |  | Pilot Valve | 0 | 0
 |  | Coil | 18.74 | 1731
 |  | Pilot without Coil | 4.81 | 823
 |  | Coil | 13.17 | 1520
 |  | Coil | 0 | 0
 |  | Pilot Valve | 15.12 | 122
 |  | Coil | 14.42 | 261
 |  | Pilot without Coil | 4.48 | 1104
 |  | Coil | 12.1 | 87
 |  | Coil | 13.6 | 68
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 18.27 | 321
 |  | Pilot without Coil | 9.46 | 54
 |  | Coil | 1.85 | 231
 |  | Pilot Valve | 0 | 0
 |  | Coil | 1.49 | 1417
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 1.64 | 641
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 1.49 | 5248
 |  | Coil | 1.64 | 2074
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 1.59 | 35437
 |  | Coil | 1.51 | 22803
 |  | Coil | 1.51 | 13008
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 16.32 | 57
 |  | Pilot Valve | 0 | 0
 |  | Coil | 11.2 | 20
 |  | Coil | 0 | 0
 |  | Pilot Valve | 0 | 0
 |  | Coil | 2.99 | 30
 |  | Pilot without Coil | 9.72 | 799
 |  | Coil | 1.54 | 2174
 |  | Pilot Valve | 0 | 0
 |  | Coil | 1.72 | 755
 |  | Coil | 0 | 0
 |  | Coil | 2.99 | 145
 |  | Coil | 3.38 | 621
 |  | Coil | 2.1 | 229
 |  | Pilot Valve | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 11.1 | 221
 |  | Coil | 2.99 | 69
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 2.63 | 11
 |  | Pilot Valve | 0 | 0
 |  | Coil | 2.99 | 561
 |  | Coil | 2.99 | 523
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot Valve | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot Valve | 0 | 0
 |  | Coil | 3.96 | 110
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 3.98 | 88
 |  | Coil | 4.86 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 3.98 | 76
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 2.59 | 1784
 |  | Coil | 2.99 | 268
 |  | Pilot Valve | 20.11 | 85
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot Valve | 20.24 | 125
 |  | Coil | 8.07 | 53
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 5.46 | 1527
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot Valve | 18.83 | 40
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot Valve | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot Valve | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 1.94 | 50895
 |  | Coil | 2.59 | 2301
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 2.57 | 922
 |  | Pilot Valve | 0 | 0
 |  | Coil | 4.87 | 5366
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 2.93 | 1221
 |  | Coil | 2.48 | 581
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 7.65 | 39
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot Valve | 0 | 0
 |  | Coil | 1.94 | 21451
 |  | Coil | 1.9 | 12184
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 4.83 | 575
 |  | Coil | 0 | 0
 |  | Pilot Valve | 21.33 | 142
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 11.1 | 22
 |  | Coil | 2.37 | 1949
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 6.89 | 268
 |  | Coil | 0 | 0
 |  | Coil | 2.71 | 653
 |  | Pilot Valve | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot Valve | 16.91 | 1043
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 628
 |  | Coil | 0 | 0
 |  | Pilot Valve | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 11.91 | 240
 |  | Coil | 0 | 0
 |  | Pilot Valve | 46.92 | 81
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 4.11 | 203
 |  | Pilot without Coil | 18.5 | 368
 |  | Coil | 5.51 | 118
 |  | Pilot without Coil | 12.61 | 96
 |  | Pilot Valve | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 11.92 | 550
 |  | Coil | 5.48 | 149
 |  | Pilot without Coil | 9.3 | 490
 |  | Coil | 0 | 0
 |  | Pilot Valve | 6.24 | 17241
 |  | Coil | 3.03 | 540
 |  | Coil | 0 | 0
 |  | Coil | 3.09 | 75
 |  | Pilot without Coil | 0 | 468
 |  | Coil | 0 | 0
 |  | Pilot Valve | 0 | 0
 |  | Coil | 4.49 | 794
 |  | Pilot without Coil | 0 | 431
 |  | Coil | 0 | 0
 |  | Pilot Valve | 17.3 | 47
 |  | Coil | 0 | 0
 |  | Pilot without Coil | 0 | 6
 |  | Coil | 0 | 0
 |  | Pilot Valve | 29.9 | 403
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot Valve | 15.66 | 344
 |  | Coil | 2.8 | 277
 |  | Pilot Valve | 31.42 | 0
 |  | Coil | 0 | 0
 |  | Coil | 2.59 | 199
 |  | Pilot Valve | 0 | 0
 |  | Coil | 7.27 | 216
 |  | Pilot Valve | 11.31 | 97
 |  | Coil | 0 | 0
 |  | Pilot Valve | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot Valve | 16.45 | 73
 |  | Coil | 0 | 0
 |  | Pilot Valve | 9.62 | 18
 |  | Coil | 0 | 0
 |  | Pilot Valve | 8 | 293
 |  | Coil | 0 | 0
 |  | Pilot Valve | 9.39 | 14906
 |  | Coil | 0 | 0
 |  | Pilot Valve | 21.64 | 902
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 2.08 | 786
 |  | Pilot Valve | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 2.48 | 5809
 |  | Coil | 5.82 | 141
 |  | Pilot Valve | 9.66 | 2152
 |  | Coil | 0 | 0
 |  | Coil | 4.56 | 3279
 |  | Coil | 0 | 0
 |  | Coil | 2.56 | 6771
 |  | Pilot Valve | 10.79 | 192
 |  | Pilot Valve | 0 | 0
 |  | Coil | 2.48 | 1430
 |  | Pilot Valve | 11.5 | 33
 |  | Coil | 0 | 0
 |  | Pilot Valve | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot Valve | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot Valve | 12.59 | 29
 |  | Coil | 0 | 0
 |  | Pilot Valve | 12.19 | 44
 |  | Pilot Valve | 0 | 0
 |  | Pilot Valve | 0 | 0
 |  | Pilot Valve | 20.74 | 160
 |  | Pilot Valve | 25.18 | 88
 |  | Pilot Valve | 0 | 0
 |  | Pilot Valve | 21.93 | 0
 |  | Pilot Valve | 42.42 | 0
 |  | Pilot Valve | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 12.54 | 582
 |  | Pilot Valve | 78.14 | 72
 |  | Coil | 1.46 | 6023
 |  | Pilot Valve | 0 | 0
 |  | Coil | 1.59 | 2387
 |  | Coil | 3.61 | 116
 |  | Pilot Valve | 0 | 0
 |  | Coil | 2.99 | 77
 |  | Coil | 0 | 0
 |  | Pilot Valve | 0 | 0
 |  | Coil | 6.91 | 97
 |  | Pilot Valve | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 2.79 | 645
 |  | Coil | 1.65 | 235
 |  | Pilot Valve | 31.29 | 34
 |  | Coil | 0 | 0
 |  | Coil | 1.65 | 148
 |  | Pilot Valve | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot Valve | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot Valve | 37.01 | 15
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot Valve | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 3.25 | 4186
 |  | Coil | 0 | 0
 |  | Coil | 5.05 | 1801
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot Valve | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 4.55 | 205
 |  | Pilot Valve | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot Valve | 20.74 | 102
 |  | Coil | 18 | 221
 |  | Coil | 0 | 0
 |  | Pilot Valve | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot Valve | 0 | 0
 |  | Coil | 0 | 1308
 |  | Coil | 0 | 0
 |  | Pilot Valve | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot Valve | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot Valve | 20.74 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot Valve | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 5.05 | 591
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot Valve | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot Valve | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Pilot Valve | 0 | 0
 |  | Pilot Valve | 0 | 105
 |  | Pilot Valve | 0 | 129
 |  | Pilot Valve | 0 | 0
 |  | Pilot Valve | 0 | 0
 |  | Pilot Valve | 0 | 707
 |  | Pilot Valve | 0 | 187
 |  | Pilot Valve | 0 | 0
 |  | Pilot Valve | 10.44 | 203
 |  | Pilot Valve | 0 | 57
 |  | Pilot Valve | 0 | 177
 |  | Pilot Valve | 35.2 | 538
 |  | Pilot Valve | 13.45 | 1837
 |  | Pilot Valve | 0 | 0
 |  | Pilot Valve | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0
 |  | Coil | 0 | 0