I have a file with several calculations, I have two pages I need to relate, in one I have data from several locations, and the other several options and Lifting Index calculation for scenario analysis. I want to include depending drop of lists on the second one, so user can only choose from available locations, and the specific options for that location. I want the drop-off lists to show unique values but I do not want to do a specific table each location and options, I want it to be compunded from locations table. Each table has much more data then the one used here.
My first table:
<tbody>
</tbody>
My second table:
<tbody>
</tbody>
Practically I want all the inputs of the first 5 colums of this one to be a drop off menu based on the data of the previous one
My first table:
| Production Line | Generic Location | Location | Improvement | Improvement Description | Platform Height Regarding Plant Floor (inch.) | Minimum lifting table Height (inch.) * | Maximum lifting table Height (inch.) * | Average lifting table Height (inch.) * |
| 3 | L3 - Blender | L3 - Blender Left | Original | None - Current | 87.00 | 9.50 | 35.00 | 22.25 |
| 3 | L3 - Blender | L3 - Blender Front | Original | None - Current | 87.00 | 14.50 | 39.75 | 27.13 |
| 4 | L4 - Bag Dump 1 | L4 - Bag Dump 1 | Original | None - Current | - | 18.00 | 53.00 | 35.50 |
| 4 | L4 - Bag Dump 2 | L4 - Bag Dump 2 - Red Lifter | Original | None - Current | - | 20.00 | 30.50 | 25.25 |
| 4 | L4 - Bag Dump 3 | L4 - Bag Dump 3 | Original | None - Current | - | 19.00 | 53.00 | 36.00 |
| 4 | L4 - Bag Dump 4 | L4 - Bag Dump 4 | Original | None - Current | 105.00 | 18.00 | 53.00 | 35.50 |
| 4 | L4 - Scale C | L4 - Scale C - Gray Lifter | Original | None - Current | - | 16.00 | 32.00 | 24.00 |
| 4 | L4 - Scale C | L4 - Scale C - White lifter | Original | None - Current | - | 16.00 | 28.50 | 22.25 |
| 4 | L4 - Premix | L4 - Premix | Original | None - Current | 62.00 | N/A | N/A | N/A |
| 3 | L3 - Blender | L3 - Blender Front | Restore | Restored Rotation | 87.00 | 14.50 | 39.75 | 27.13 |
| 4 | L4 - Bag Dump 2 | L4 - Bag Dump 2 - Red Lifter | Replacement | Redesign with Rollers | - | 11.25 | 36.20 | 23.73 |
| 4 | L4 - Bag Dump 3 | L4 - Bag Dump 3 | Replacement | Redesign with Rollers | - | 11.25 | 36.20 | 23.73 |
| 4 | L4 - Scale C | L4 - Scale C - Gray Lifter | Replacement | Lower Footprint Lifting Table | - | 7.25 | 32.20 | 19.73 |
| 4 | L4 - Scale C | L4 - Scale C - White Lifter | Replacement | Lower Footprint Lifting Table | - | 7.25 | 32.20 | 19.73 |
<tbody>
</tbody>
My second table:
| Line | General Location | Dumping Station | Configuration (Original / Improved) | Improvement Description | Calculated Point Description |
| 3 | L3 - Blender | L3 - Blender Front | Original | None - Current | Standard Pallet Height 40"Wx48"Lx50"H at TOS |
| 3 | L3 - Blender | L3 - Blender Left | Original | None - Current | Standard Pallet Height 40"Wx48"Lx50"H at TOS |
| 3 | L3 - Blender | L3 - Blender Front | Original | None - Current | Last Pallet Row at TOS |
| 3 | L3 - Blender | L3 - Blender Left | Original | None - Current | Last Pallet Row at TOS |
| 4 | L4 - Bag Dump 1 | L4 - Bag Dump 1 | Original | None - Current | Standard Pallet Height 40"Wx48"Lx50"H at TOS |
| 4 | L4 - Bag Dump 1 | L4 - Bag Dump 1 | Original | None - Current | Last Pallet Row at TOS |
| 4 | L4 - Bag Dump 3 | L4 - Bag Dump 3 | Original | None - Current | Standard Pallet Height 40"Wx48"Lx50"H at TOS |
| 4 | L4 - Bag Dump 3 | L4 - Bag Dump 3 | Original | None - Current | Last Pallet Row at TOS |
| 4 | L4 - Bag Dump 4 | L4 - Bag Dump 4 | Original | None - Current | Standard Pallet Height 40"Wx48"Lx50"H at TOS |
| 4 | L4 - Bag Dump 4 | L4 - Bag Dump 4 | Original | None - Current | Last Pallet Row at TOS |
| 4 | L4 - Scale C | L4 - Scale C - Gray Lifter | Original | None - Current | Standard Pallet Height 40"Wx48"Lx50"H at TOS |
| 4 | L4 - Scale C | L4 - Scale C - Gray Lifter | Original | None - Current | Last Pallet Row at TOS |
| 4 | L4 - Scale C | L4 - Scale C - White Lifter | Original | None - Current | Standard Pallet Height 40"Wx48"Lx50"H at TOS |
| 4 | L4 - Scale C | L4 - Scale C - White Lifter | Original | None - Current | Last Pallet Row at TOS |
| 4 | L4 - Bag Dump 2 | L4 - Bag Dump 2 - Red Lifter | Original | None - Current | Standard Pallet Height 40"Wx48"Lx50"H at TOS |
| 4 | L4 - Bag Dump 2 | L4 - Bag Dump 2 - Red Lifter | Original | None - Current | Last Pallet Row at TOS |
| 3 | L3 - Blender | L3 - Blender Front | Restore | Restored Rotation | Standard Pallet Height 40"Wx48"Lx50"H at TOS |
| 3 | L3 - Blender | L3 - Blender Front | Restore | Restored Rotation | Last Pallet Row at TOS |
| 4 | L4 - Bag Dump 3 | L4 - Bag Dump 3 | Replacement | Redesign with Rollers | Standard Pallet Height 40"Wx48"Lx50"H at TOS |
| 4 | L4 - Bag Dump 3 | L4 - Bag Dump 3 | Replacement | Redesign with Rollers | Last Pallet Row at TOS |
| 4 | L4 - Scale C | L4 - Scale C - Gray Lifter | Replacement | Lower Footprint Lifting Table | Standard Pallet Height 40"Wx48"Lx50"H at TOS |
| 4 | L4 - Scale C | L4 - Scale C - Gray Lifter | Replacement | Lower Footprint Lifting Table | Last Pallet Row at TOS |
| 4 | L4 - Scale C | L4 - Scale C - White Lifter | Replacement | Lower Footprint Lifting Table | Standard Pallet Height 40"Wx48"Lx50"H at TOS |
| 4 | L4 - Scale C | L4 - Scale C - White Lifter | Replacement | Lower Footprint Lifting Table | Last Pallet Row at TOS |
| 4 | L4 - Bag Dump 2 | L4 - Bag Dump 2 - Red Lifter | Replacement | Redesign with Rollers | Standard Pallet Height 40"Wx48"Lx50"H at TOS |
| 4 | L4 - Bag Dump 2 | L4 - Bag Dump 2 - Red Lifter | Replacement | Redesign with Rollers | Last Pallet Row at TOS |
<tbody>
</tbody>
Practically I want all the inputs of the first 5 colums of this one to be a drop off menu based on the data of the previous one
Last edited:
