Spreadsheet: 834320d1687665066-bill-of-material-example-2
Sheet: Blad1

level | bom
0 | 1 |  |  |  | 1 |  |  |  |  |  | The level is 0 therefore bom is 1
1 | 1.1 |  |  |  | 1 | 1 |  |  |  |  | The level rises from 0 to 1, thus level 1 material will be underlying bom 1 and will result in bom 1.1
2 | 1.1.1 |  |  |  | 1 | 1 | 1 |  |  |  | The level rises from 1 to 2, thus level 2 material will be underlying bom 1.1 and will result in bom 1.1.1
2 | 1.1.2 |  |  |  | 1 | 1 | 2 |  |  |  | The level stays equal, thus level 2 will be underlying bom 1.1. However it's the second level 2 in sequence, therefore it has to result in bom 1.1.2
2 | 1.1.3 |  |  |  | 1 | 1 | 3 |  |  |  | The level stays equal, thus level 2 will be underlying bom 1.1. However it's the third level 2 in sequence, therefore it has to result in bom 1.1.3
2 | 1.1.4 |  |  |  | 1 | 1 | 4 |  |  |  | The level stays equal, thus level 2 will be underlying bom 1.1. However it's the fourth level 2 in sequence, therefore it has to result in bom 1.1.4
2 | 1.1.5 |  |  |  | 1 | 1 | 5 |  |  |  | The level stays equal, thus level 2 will be underlying bom 1.1. However it's the fifth level 2 in sequence, therefore it has to result in bom 1.1.5
1 | 1.2 |  |  |  | 1 | 2 |  |  |  |  | The level lowers from 2 to 1, thus level 1 material will be underlying bom 1. However it's the second level 1 in sequence, therefore it has to result in 1.2
2 | 1.2.1 |  |  |  | 1 | 2 | 1 |  |  |  | The level rises from 1 to 2, thus level 2 will be underlying bom 1. However it's the second level 1 in sequence, therefore it hase to result in bom 1.2.1
3 | 1.2.1.1 |  |  |  | 1 | 2 | 1 | 1 |  |  | The level rises from 2 to 3, thus level 3 will be underlying bom 1.2.1 and will result in bom 1.2.1.1
3 | 1.2.1.2 |  |  |  | 1 | 2 | 1 | 2 |  |  | The level stays equal, thus level 3 will be underlying bom 1.2.1. However it's the second level 3 in sequence, therefore it has to result in 1.2.1.2
3 | 1.2.1.3 |  |  |  | 1 | 2 | 1 | 3
4 | 1.2.1.3.1 |  |  |  | 1 | 2 | 1 | 3 | 1 |  | Etc.. Please scroll down for other scenario's
3 | 1.2.1.4 |  |  |  | 1 | 2 | 1 | 4
3 | 1.2.1.5 |  |  |  | 1 | 2 | 1 | 5
3 | 1.2.1.6 |  |  |  | 1 | 2 | 1 | 6
3 | 1.2.1.7 |  |  |  | 1 | 2 | 1 | 7
4 | 1.2.1.7.1 |  |  |  | 1 | 2 | 1 | 7 | 1
3 | 1.2.1.8 |  |  |  | 1 | 2 | 1 | 8
4 | 1.2.1.8.1 |  |  |  | 1 | 2 | 1 | 8 | 1
3 | 1.2.1.9 |  |  |  | 1 | 2 | 1 | 9
4 | 1.2.1.9.1 |  |  |  | 1 | 2 | 1 | 9 | 1
4 | 1.2.1.9.2 |  |  |  | 1 | 2 | 1 | 9 | 2
4 | 1.2.1.9.3 |  |  |  | 1 | 2 | 1 | 9 | 3
5 | 1.2.1.9.3.1 |  |  |  | 1 | 2 | 1 | 9 | 3 | 1
4 | 1.2.1.9.4 |  |  |  | 1 | 2 | 1 | 9 | 4
4 | 1.2.1.9.5 |  |  |  | 1 | 2 | 1 | 9 | 5
4 | 1.2.1.9.6 |  |  |  | 1 | 2 | 1 | 9 | 6
5 | 1.2.1.9.6.1 |  |  |  | 1 | 2 | 1 | 9 | 6 | 1
4 | 1.2.1.9.7 |  |  |  | 1 | 2 | 1 | 9 | 7
4 | 1.2.1.9.8 |  |  |  | 1 | 2 | 1 | 9 | 8
4 | 1.2.1.9.9 |  |  |  | 1 | 2 | 1 | 9 | 9
5 | 1.2.1.9.9.1 |  |  |  | 1 | 2 | 1 | 9 | 9 | 1
4 | 1.2.1.9.10 |  |  |  | 1 | 2 | 1 | 9 | 10
4 | 1.2.1.9.11 |  |  |  | 1 | 2 | 1 | 9 | 11
4 | 1.2.1.9.12 |  |  |  | 1 | 2 | 1 | 9 | 12
4 | 1.2.1.9.13 |  |  |  | 1 | 2 | 1 | 9 | 13
4 | 1.2.1.9.14 |  |  |  | 1 | 2 | 1 | 9 | 14
4 | 1.2.1.9.15 |  |  |  | 1 | 2 | 1 | 9 | 15
4 | 1.2.1.9.16 |  |  |  | 1 | 2 | 1 | 9 | 16
3 | 1.2.1.10 |  |  |  | 1 | 2 | 1 | 10
3 | 1.2.1.11 |  |  |  | 1 | 2 | 1 | 11
3 | 1.2.1.12 |  |  |  | 1 | 2 | 1 | 12
3 | 1.2.1.12 |  |  |  | 1 | 2 | 1 | 12
4 | 1.2.1.12.1 |  |  |  | 1 | 2 | 1 | 12 | 1
2 | 1.2.2 |  |  |  | 1 | 2 | 2 |  |  |  | the level lowers from 4 to 2, therefore level 2 will underly bom 1.2.1 because it's the second and not seventh level 2 in the sequence. The sequence has to reset the level is lower than the level of the current sequence. Therefore it needs to result in bom 1.2.2
3 | 1.2.2.1 |  |  |  | 1 | 2 | 2 | 1
3 | 1.2.2.2 |  |  |  | 1 | 2 | 2 | 2
4 | 1.2.2.2.1 |  |  |  | 1 | 2 | 2 | 2 | 1
3 | 1.2.2.3 |  |  |  | 1 | 2 | 2 | 3
2 | 1.2.3 |  |  |  | 1 | 2 | 3
3 | 1.2.3.1 |  |  |  | 1 | 2 | 3 | 1
4 | 1.2.3.1.1 |  |  |  | 1 | 2 | 3 | 1 | 1
3 | 1.2.3.2 |  |  |  | 1 | 2 | 3 | 2
3 | 1.2.3.3 |  |  |  | 1 | 2 | 3 | 3
4 | 1.2.3.3.1 |  |  |  | 1 | 2 | 3 | 3 | 1
3 | 1.2.3.4 |  |  |  | 1 | 2 | 3 | 4
4 | 1.2.3.4.1 |  |  |  | 1 | 2 | 3 | 4 | 1
3 | 1.2.3.5 |  |  |  | 1 | 2 | 3 | 5
4 | 1.2.3.5.1 |  |  |  | 1 | 2 | 3 | 5 | 1
3 | 1.2.3.6 |  |  |  | 1 | 2 | 3 | 6
3 | 1.2.3.7 |  |  |  | 1 | 2 | 3 | 7
3 | 1.2.3.8 |  |  |  | 1 | 2 | 3 | 8
3 | 1.2.3.9 |  |  |  | 1 | 2 | 3 | 9
4 | 1.2.3.9.1 |  |  |  | 1 | 2 | 3 | 9 | 1
3 | 1.2.3.10 |  |  |  | 1 | 2 | 3 | 10
3 | 1.2.3.11 |  |  |  | 1 | 2 | 3 | 11
3 | 1.2.3.12 |  |  |  | 1 | 2 | 3 | 12
3 | 1.2.3.13 |  |  |  | 1 | 2 | 3 | 13
3 | 1.2.3.14 |  |  |  | 1 | 2 | 3 | 14
3 | 1.2.3.15 |  |  |  | 1 | 2 | 3 | 15
3 | 1.2.3.16 |  |  |  | 1 | 2 | 3 | 16
2 | 1.2.4 |  |  |  | 1 | 2 | 4
3 | 1.2.4.1 |  |  |  | 1 | 2 | 4 | 1
4 | 1.2.4.1.1 |  |  |  | 1 | 2 | 4 | 1 | 1
3 | 1.2.4.2 |  |  |  | 1 | 2 | 4 | 2
4 | 1.2.4.2.1 |  |  |  | 1 | 2 | 4 | 2 | 1
3 | 1.2.4.3 |  |  |  | 1 | 2 | 4 | 3
4 | 1.2.4.3.1 |  |  |  | 1 | 2 | 4 | 3 | 1
3 | 1.2.4.4 |  |  |  | 1 | 2 | 4 | 4
4 | 1.2.4.4.1 |  |  |  | 1 | 2 | 4 | 4 | 1
3 | 1.2.4.5 |  |  |  | 1 | 2 | 4 | 5
4 | 1.2.4.5.1 |  |  |  | 1 | 2 | 4 | 5 | 1
3 | 1.2.4.6 |  |  |  | 1 | 2 | 4 | 6
4 | 1.2.4.6.1 |  |  |  | 1 | 2 | 4 | 6 | 1
3 | 1.2.4.7 |  |  |  | 1 | 2 | 4 | 7
4 | 1.2.4.7.1 |  |  |  | 1 | 2 | 4 | 7 | 1
3 | 1.2.4.8 |  |  |  | 1 | 2 | 4 | 8
4 | 1.2.4.8.1 |  |  |  | 1 | 2 | 4 | 8 | 1
3 | 1.2.4.9 |  |  |  | 1 | 2 | 4 | 9
4 | 1.2.4.9.1 |  |  |  | 1 | 2 | 4 | 9 | 1
2 | 1.2.5 |  |  |  | 1 | 2 | 5
2 | 1.2.6 |  |  |  | 1 | 2 | 6
2 | 1.2.7 |  |  |  | 1 | 2 | 7
2 | 1.2.8 |  |  |  | 1 | 2 | 8
3 | 1.2.8.1 |  |  |  | 1 | 2 | 8 | 1
2 | 1.2.9 |  |  |  | 1 | 2 | 9
2 | 1.2.10 |  |  |  | 1 | 2 | 10
2 | 1.2.11 |  |  |  | 1 | 2 | 11
2 | 1.2.12 |  |  |  | 1 | 2 | 12
2 | 1.2.13 |  |  |  | 1 | 2 | 13
2 | 1.2.14 |  |  |  | 1 | 2 | 14
3 | 1.2.14.1 |  |  |  | 1 | 2 | 14 | 1
2 | 1.2.15 |  |  |  | 1 | 2 | 15
2 | 1.2.16 |  |  |  | 1 | 2 | 16
2 | 1.2.17 |  |  |  | 1 | 2 | 17
3 | 1.2.17.1 |  |  |  | 1 | 2 | 17 | 1
3 | 1.2.17.2 |  |  |  | 1 | 2 | 17 | 2
3 | 1.2.17.3 |  |  |  | 1 | 2 | 17 | 3
3 | 1.2.17.4 |  |  |  | 1 | 2 | 17 | 4
3 | 1.2.17.5 |  |  |  | 1 | 2 | 17 | 5
4 | 1.2.17.5.1 |  |  |  | 1 | 2 | 17 | 5 | 1
3 | 1.2.17.6 |  |  |  | 1 | 2 | 17 | 6
3 | 1.2.17.7 |  |  |  | 1 | 2 | 17 | 7
4 | 1.2.17.7.1 |  |  |  | 1 | 2 | 17 | 7 | 1
2 | 1.2.18 |  |  |  | 1 | 2 | 18
2 | 1.2.19 |  |  |  | 1 | 2 | 19
2 | 1.2.20 |  |  |  | 1 | 2 | 20
2 | 1.2.21 |  |  |  | 1 | 2 | 21
2 | 1.2.22 |  |  |  | 1 | 2 | 22
2 | 1.2.23 |  |  |  | 1 | 2 | 23
3 | 1.2.23.1 |  |  |  | 1 | 2 | 23 | 1
2 | 1.2.24 |  |  |  | 1 | 2 | 24
2 | 1.2.25 |  |  |  | 1 | 2 | 25
3 | 1.2.25.1 |  |  |  | 1 | 2 | 25 | 1
2 | 1.2.26 |  |  |  | 1 | 2 | 26
2 | 1.2.27 |  |  |  | 1 | 2 | 27
2 | 1.2.28 |  |  |  | 1 | 2 | 28
2 | 1.2.29 |  |  |  | 1 | 2 | 29
1 | 1.3 |  |  |  | 1 | 3
2 | 1.3.1 |  |  |  | 1 | 3 | 1
2 | 1.3.2 |  |  |  | 1 | 3 | 2
2 | 1.3.3 |  |  |  | 1 | 3 | 3
2 | 1.3.4 |  |  |  | 1 | 3 | 4
2 | 1.3.5 |  |  |  | 1 | 3 | 5
3 | 1.3.5.1 |  |  |  | 1 | 3 | 5 | 1
2 | 1.3.6 |  |  |  | 1 | 3 | 6
2 | 1.3.7 |  |  |  | 1 | 3 | 7
2 | 1.3.8 |  |  |  | 1 | 3 | 8
2 | 1.3.9 |  |  |  | 1 | 3 | 9
2 | 1.3.10 |  |  |  | 1 | 3 | 10
3 | 1.3.10.1 |  |  |  | 1 | 3 | 10 | 1
2 | 1.3.11 |  |  |  | 1 | 3 | 11
2 | 1.3.12 |  |  |  | 1 | 3 | 12
2 | 1.3.13 |  |  |  | 1 | 3 | 13
3 | 1.3.13.1 |  |  |  | 1 | 3 | 13 | 1
4 | 1.3.13.1.1 |  |  |  | 1 | 3 | 13 | 1 | 1
3 | 1.3.13.2 |  |  |  | 1 | 3 | 13 | 2
4 | 1.3.13.2.1 |  |  |  | 1 | 3 | 13 | 2 | 1
3 | 1.3.13.3 |  |  |  | 1 | 3 | 13 | 3
2 | 1.3.14 |  |  |  | 1 | 3 | 14
2 | 1.3.15 |  |  |  | 1 | 3 | 15
2 | 1.3.16 |  |  |  | 1 | 3 | 16
3 | 1.3.16.1 |  |  |  | 1 | 3 | 16 | 1
2 | 1.3.17 |  |  |  | 1 | 3 | 17
2 | 1.3.18 |  |  |  | 1 | 3 | 18
2 | 1.3.19 |  |  |  | 1 | 3 | 19
2 | 1.3.20 |  |  |  | 1 | 3 | 20
3 | 1.3.20.1 |  |  |  | 1 | 3 | 20 | 1
2 | 1.3.21 |  |  |  | 1 | 3 | 21
2 | 1.3.22 |  |  |  | 1 | 3 | 22
2 | 1.3.23 |  |  |  | 1 | 3 | 23