UncleBajubjubs
Board Regular
- Joined
- Jul 11, 2017
- Messages
- 111
- Office Version
- 2010
I'm trying to make a table for planning the construction of several different designs. Currently there are 11 different designs, totaling 17 builds.
The user will change the order column to set the build order.
This table will generate a second table, which lists the build order for all 17.
The first line is easy, as it can just lookup whichever Design is first. But then the second line will have to check the quantity of the first design, and either repeat that design if the quantity is 2 or more, or go to the next design. So since design C is quantity 2, it is build 3 and 4, and Design D, the 4th design, is the fifth build.
I'm not sure the most efficient way to make this table operate. I could probably make it work with a ton of if statements, but I'm assuming there's a more elegant formula I can use.
| Order | Design | Quantity to build |
1 | A | 1 |
2 | B | 1 |
3 | C | 2 |
4 | D | 1 |
5 | E | 1 |
6 | F | 1 |
7 | G | 4 |
8 | H | 2 |
9 | I | 2 |
10 | J | 1 |
11 | K | 1 |
The user will change the order column to set the build order.
This table will generate a second table, which lists the build order for all 17.
| Build Order | Design |
1 | A |
2 | B |
3 | C |
4 | C |
5 | D |
6 | E |
7 | F |
8 | G |
9 | G |
10 | G |
11 | G |
12 | H |
13 | H |
14 | I |
15 | I |
16 | J |
17 | K |
The first line is easy, as it can just lookup whichever Design is first. But then the second line will have to check the quantity of the first design, and either repeat that design if the quantity is 2 or more, or go to the next design. So since design C is quantity 2, it is build 3 and 4, and Design D, the 4th design, is the fifth build.
I'm not sure the most efficient way to make this table operate. I could probably make it work with a ton of if statements, but I'm assuming there's a more elegant formula I can use.
