Spreadsheet: 752723d1634911213-simifs-between-a-range-help
Sheet: Sheet1

BOM Lvl | Material Number | Current estimated Cost TOT | Assembly # top lvl | Assembly #2 for piece part | Assembly? | Sub Assembly Cost 1
0 | 10553066 | 18272.175 | 10553066 |  | Yes
1 | H0E5510300 | 1971.66134 | 10553066 | 10553066 | No
1 | H0E0987000RT | 15089.08 | 10553066 | 10553066 | No
1 | H0E0987200 | 1737.9 | 10553066 | 10553066 | No
2 | HTA13709000300 | 1248.0195 | 10553066 | 10553066 | No
2 | HTA13709000300 | 243.516 | 10553066 | 10553066 | No
0 | H16108C303RT | 32618.735 | H16108C303RT |  | Yes
1 | HWWGE1M0HB | 27.09 | H16108C303RT | H16108C303RT | No
1 | H095793104RT | 11797.4655 | H16108C303RT | H16108C303RT | Yes
1 | H095987732 | 6125.22 | H16108C303RT | H16108C303RT | Yes
1 | H0E0546402 | 3540.32 | H16108C303RT | H16108C303RT | Yes
1 | H0E0308602 | 3965.15 | H16108C303RT | H16108C303RT | Yes
1 | H096167100 | 688.06 | H16108C303RT | H16108C303RT | Yes
1 | H096168000RT | 3057.43 | H16108C303RT | H16108C303RT | Yes
1 | HT05007263 | 2.5 | H16108C303RT | H16108C303RT | No
1 | HWWS108000 | 0.42 | H16108C303RT | H16108C303RT | No
1 | HWWB254H30 | 2.21 | H16108C303RT | H16108C303RT | No
1 | HWWG51H0S0 | 0.39 | H16108C303RT | H16108C303RT | No
1 | H096167200 | 586.78 | H16108C303RT | H16108C303RT | Yes
0 | H150400037 | 54062.53508 | H150400037 |  | Yes
1 | H095564100 | 3337.5 | H150400037 | H150400037 | Yes
1 | H0E0871501 | 5770.049999999999 | H150400037 | H150400037 | Yes
1 | 10011761 | 771.24 | H150400037 | H150400037 | No
1 | H095562600 | 2117.52 | H150400037 | H150400037 | Yes
1 | HWWLA10300 | 41.28 | H150400037 | H150400037 | No
1 | H0E0861400 | 5148.84 | H150400037 | H150400037 | Yes
1 | H0E0864208 | 13385.401 | H150400037 | H150400037 | Yes
1 | HWWGE1M0MB | 54 | H150400037 | H150400037 | No
1 | HWWS104004 | 0.33 | H150400037 | H150400037 | No
1 | HWWB258H40 | 5.31 | H150400037 | H150400037 | No
1 | HWWB244H40 | 2.58 | H150400037 | H150400037 | No
1 | HWWB228H40 | 0.78 | H150400037 | H150400037 | No
1 | [NAME] | 20.16 | H150400037 | H150400037 | No
1 | HWWG11D0H0 | 0.24 | H150400037 | H150400037 | No
1 | HWWG51B0H0 | 0.36 | H150400037 | H150400037 | No
1 | H028851500 | 336.24 | H150400037 | H150400037 | No
1 | H095551600 | 1203.63 | H150400037 | H150400037 | Yes
1 | HWWG20B0S0 | 0.12 | H150400037 | H150400037 | No
1 | H0E1037900 | 2669.49 | H150400037 | H150400037 | Yes
1 | H096062400 | 7423.559999999999 | H150400037 | H150400037 | Yes
1 | H0E1070800 | 4322.22 | H150400037 | H150400037 | Yes
1 | HWWGE1H10G | 88.2 | H150400037 | H150400037 | No
2 | HT29010903 | 154.26 | H150400037 | H150400037 | No
2 | H0E0666000 | 285.12 | H150400037 | H0E0864208 | No
2 | [NAME] | 7106.782499999999 | H150400037 | H0E0864208 | Yes
0 | H014055700 | 1126.2392 | H014055700 |  | Yes
0 | H014055700 | 2534.0382 | H014055700 |  | Yes
0 | H486900239 | 20633.274 | H486900239 |  | Yes
0 | H486900239 | 55022.06400000001 | H486900239 |  | Yes
1 | H066770524 | 0 | H486900239 | H486900239 | No
1 | H0K8004804 | 2433.3186 | H486900239 | H486900239 | No
1 | H066770524 | 0 | H486900239 | H486900239 | No
1 | H0K8004804 | 6488.8496 | H486900239 | H486900239 | No
2 | H485070550 | 6270.76 | H486900239 | H486900239 | No
2 | H485070550 | 2351.535 | H486900239 | H486900239 | No
0 | [NAME] | 13216.04975 | [NAME] |  | Yes
1 | H095988800RT | 8501.09344 | [NAME] | [NAME] | Yes
1 | H095988100 | 463.51 | [NAME] | [NAME] | Yes
0 | H274120302GT1 | 47715.74944 | H274120302GT1 |  | Yes
1 | HWWB268H40 | 18.56 | H274120302GT1 | H274120302GT1 | No
1 | H079039202 | 7706.6 | H274120302GT1 | H274120302GT1 | Yes
1 | H079039493D80 | 36162.88 | H274120302GT1 | H274120302GT1 | No
1 | H079039102 | 1816.99924 | H274120302GT1 | H274120302GT1 | Yes
1 | H078008040 | 2798.04 | H274120302GT1 | H274120302GT1 | No
1 | H079171400 | 2397.72 | H274120302GT1 | H274120302GT1 | No
0 | H296690006 | 40864.53 | H296690006 |  | Yes
0 | H296690006 | 70475.15871999999 | H296690006 |  | Yes
1 | H079966400 | 2073.66 | H296690006 | H296690006 | Yes
1 | HWWL1180W0 | 0.16 | H296690006 | H296690006 | No
1 | H079968400 | 851.32 | H296690006 | H296690006 | Yes
1 | H079966100 | 557.52 | H296690006 | H296690006 | Yes
1 | H0G0654600 | 9005.82012 | H296690006 | H296690006 | Yes
1 | H0G0664301 | 134.6 | H296690006 | H296690006 | No
1 | HWWG5180D1 | 0.16 | H296690006 | H296690006 | No
1 | H0G0614400 | 2351.88 | H296690006 | H296690006 | Yes
1 | H0G0281990 | 4562.6246 | H296690006 | H296690006 | Yes
1 | H0G0562800 | 211.44 | H296690006 | H296690006 | No
1 | HWWB379A40 | 148.32 | H296690006 | H296690006 | No
1 | H0G0610409 | 15590.80498 | H296690006 | H296690006 | Yes
1 | H079966200 | 213 | H296690006 | H296690006 | No
1 | HWWB376A40 | 191.02 | H296690006 | H296690006 | No
1 | 10360905 | 86.24000000000001 | H296690006 | H296690006 | No
1 | [NAME] | 29321.98 | H296690006 | H296690006 | Yes
2 | HTP11012500800 | 12192.943125 | H296690006 | H0P4084110 | No
0 | 10564627 | 3438.66 | 10564627 |  | Yes
0 | 10541299 | 2107.105 | 10541299 |  | Yes
0 | 10541299 | 8428.42 | 10541299 |  | Yes
1 | 10131394 | 43.6 | 10541299 | 10541299 | No
1 | 10540145 | 5.600000000000001 | 10541299 | 10541299 | No
1 | HWWGE0B0HB | 28.05 | 10541299 | 10541299 | No
1 | [NAME] | 170.595 | 10541299 | 10541299 | No
1 | H079562301 | 1782 | 10541299 | 10541299 | Yes
1 | HWWB348H40 | 10.65 | 10541299 | 10541299 | No
1 | HWWB344H40 | 3.7 | 10541299 | 10541299 | No
1 | [NAME] | 0 | 10541299 | 10541299 | No
1 | H079562301 | 7128 | 10541299 | 10541299 | Yes
1 | [NAME] | 682.38 | 10541299 | 10541299 | No
1 | HWWGE0B0HB | 112.2 | 10541299 | 10541299 | No
1 | 10131394 | 174.4 | 10541299 | 10541299 | No
1 | 10540145 | 22.4 | 10541299 | 10541299 | No
1 | HWWB348H40 | 42.59999999999999 | 10541299 | 10541299 | No
1 | HWWB344H40 | 14.8 | 10541299 | 10541299 | No
1 | [NAME] | 0 | 10541299 | 10541299 | No
0 | H078225000 | 1521.33568 | H078225000 |  | Yes
1 | HTA13705500350 | 260.60895 | H078225000 | H078225000 | No
0 | H296450139 | 97872.73872 | H296450139 |  | Yes
1 | HWWB271A40 | 148.8 | H296450139 | H296450139 | No
1 | H078044517 | 63 | H296450139 | H296450139 | No
1 | HWWB447A40 | 122.1371 | H296450139 | H296450139 | No
1 | HWWG51H0D0 | 1.44 | H296450139 | H296450139 | No
1 | HWWGE1F0MB | 39.36 | H296450139 | H296450139 | No
1 | H079113900 | 4556.46 | H296450139 | H296450139 | Yes
1 | H079113800 | 2349.92 | H296450139 | H296450139 | Yes
1 | H079113600 | 1950.52 | H296450139 | H296450139 | Yes
1 | HWWL1180H0 | 0.36 | H296450139 | H296450139 | No
1 | HWWB447A40 | 122.1371 | H296450139 | H296450139 | No
1 | H079113400 | 907.04 | H296450139 | H296450139 | Yes
1 | [NAME] | 689.52 | H296450139 | H296450139 | No
1 | H079113200 | 0 | H296450139 | H296450139 | Yes
1 | H0G0151403 | 12980.78 | H296450139 | H296450139 | Yes
1 | H079113500 | 316 | H296450139 | H296450139 | No
1 | H0G0151501 | 13745.8217 | H296450139 | H296450139 | Yes
1 | [NAME] | 663 | H296450139 | H296450139 | Yes
1 | H079114100 | 561.72 | H296450139 | H296450139 | No
1 | HWWB374A40 | 85.42 | H296450139 | H296450139 | No
1 | H079114200 | 3258.48 | H296450139 | H296450139 | Yes
1 | H079114500 | 262.72 | H296450139 | H296450139 | No
1 | HWWB375A40 | 62.94 | H296450139 | H296450139 | No
1 | H079114300 | 5559.39 | H296450139 | H296450139 | Yes
1 | HWWG518080 | 0.08 | H296450139 | H296450139 | No
1 | H079114700 | 6201.168 | H296450139 | H296450139 | Yes
1 | H079114600 | 3202.32 | H296450139 | H296450139 | Yes
1 | H0930007C2 | 118.34 | H296450139 | H296450139 | No
1 | HWWGE1D0MB | 7.62 | H296450139 | H296450139 | No
1 | H079114800 | 2379.02 | H296450139 | H296450139 | Yes
1 | H093000915 | 1391.64 | H296450139 | H296450139 | Yes
1 | H093000701 | 361.62 | H296450139 | H296450139 | No
1 | H079307114 | 19255.68 | H296450139 | H296450139 | Yes
2 | [NAME] | 13534.30485 | H296450139 | H0G0151501 | No
0 | 10169057 | 7369.887 | 10169057 |  | Yes
1 | HWWB362P40 | 6.899999999999999 | 10169057 | 10169057 | No
1 | 10165411 | 187.14 | 10169057 | 10169057 | No
1 | HWWB346P40 | 2.1408 | 10169057 | 10169057 | No
1 | H033083800 | 133.5 | 10169057 | 10169057 | No
1 | HWWB343P40 | 3.24 | 10169057 | 10169057 | No
1 | H036487600 | 90.57000000000001 | 10169057 | 10169057 | No
1 | 10165368 | 185.46 | 10169057 | 10169057 | No
1 | HWWB339P40 | 1.6056 | 10169057 | 10169057 | No
1 | HWWB244P40 | 3.21 | 10169057 | 10169057 | No
1 | 10164653 | 356.04 | 10169057 | 10169057 | No
1 | HWWB340P40 | 7.11 | 10169057 | H036552400 | No
1 | 10165367 | 225.84 | 10169057 | 10169057 | No
1 | HWWB234P40 | 4.68 | 10169057 | 10169057 | No
1 | H036552400 | 1457.2275 | 10169057 | 10169057 | Yes
1 | 10165369 | 179.94 | 10169057 | 10169057 | No
1 | HWWB362P40 | 6.899999999999999 | 10169057 | 10169057 | No
1 | H035733300 | 300.03 | 10169057 | 10169057 | Yes
1 | H035883202 | 176.47105 | 10169057 | 10169057 | No
1 | H035883202 | 176.47105 | 10169057 | 10169057 | No
1 | H035883202 | 174.27 | 10169057 | 10169057 | No
1 | H035883302 | 225.4976 | 10169057 | 10169057 | No
1 | H035883302 | 450.9952 | 10169057 | 10169057 | No
1 | H035740600 | 226.9917 | 10169057 | 10169057 | No
1 | H035740600 | 217.36 | 10169057 | 10169057 | No
1 | H035819900 | 622.06378 | 10169057 | 10169057 | Yes
1 | H035819900 | 479.7525199999999 | 10169057 | 10169057 | Yes
1 | H035819900 | 318.25 | 10169057 | 10169057 | Yes
1 | H036259200 | 137.13 | 10169057 | 10169057 | No
2 | H036540900 | 306.45 | 10169057 | H036552400 | Yes
2 | HWWB340P40 | 2.37 | 10169057 | H036552400 | No
2 | 10165414 | 205.86 | 10169057 | H036552400 | No
2 | H036541000 | 819.5250000000001 | 10169057 | H036552400 | No
2 | HBA60608750000 | 1682.499768167015 | 10169057 | H035819900 | No
2 | HBA60608750000 | 606.1705458459065 | 10169057 | H035819900 | No
2 | HBA60608750000 | 1682.499768167015 | 10169057 | H035819900 | No
0 | HWWB357A40 | 1092.7 | HWWB357A40 |  | Yes