I have a table. It is for physical windows in a house. Each window gets 3 data points captured. Measure the header. Measure the legs. Measure the depth (board width). From these inputs, many more columns extrapolate additional output dimensions; pieces of wood to cut.
Then I want to re-present this data as a vertical linear list. I am doing this manually now with 3 copy/paste actions per “part” [WinExtJam_Head, WinExtJam_Leg, WinCasingHead(LP), WinCasingLeg_Miter, etc].
Then I am sorting the new table on its own tab with a custom sort, first by part type (all WinExtJam_Head, then Width largest to smallest, then length largest to smallest … then all WinExtJam_Leg, width, length, and so on). The “part” dictates the source board stock to use (the carpenter knows this).
So the carpenter can take the wide board stock, make the correct quantity of longest cuts, then next length down, and so on … then they grab the next board width stock down, make cuts starting with longest. And so on.
For example, you can see in image4 that this helps us consolidate that there are 9 identical [5-1/2width x 29-3/8length] boards to cut for windows [13, 14, 19, and 7]
Sometimes we need to change an input measure, and i want the cascading changes to auto-populate to the other tab table without the manual/copy paste workflow every time.
