BrooksTech
Board Regular
- Joined
- May 9, 2011
- Messages
- 59
I wood say 
that one of the most practical uses of an advanced spreadsheet for the Average User, would be to create a sheet that determines the best use of several pieces of wood, such as plywood, based on a parts list. Im not saying its possible for the intended purpose, but if they could do it they should win MVP of the year cus that sheet could be used for decades. Ive yet to find any adequate App, free or otherwise that will do this. The sheet would have to follow principles of say, the game Tetris, to locate free dimensions after dimensions have been taken by other parts, until theres no more space. Then it goes on to the next piece of plywood.
It would start with a parts list with dimensions of the parts, plus 1/8 in for the saw blade. Another array would list available wood, such as plywood, and its dimensions. As pieces are cut, it leaves remaining pieces to be used up by remaining parts. Each dimension of the part would be checked against available area on the cut wood until all three dimensions were satisfied and added to a "Cut List." Then it goes on to the next one.
To raise the bar even more, it would be great to have it go through some algorythm of all the possibilities to create a result with the least amount of scrap wood left on each sheet of plywood.
Somewhere out there is a manufacturing assembly line that has already mastered this task, but as of today Im yet to find any software available for the consumer.
that one of the most practical uses of an advanced spreadsheet for the Average User, would be to create a sheet that determines the best use of several pieces of wood, such as plywood, based on a parts list. Im not saying its possible for the intended purpose, but if they could do it they should win MVP of the year cus that sheet could be used for decades. Ive yet to find any adequate App, free or otherwise that will do this. The sheet would have to follow principles of say, the game Tetris, to locate free dimensions after dimensions have been taken by other parts, until theres no more space. Then it goes on to the next piece of plywood.It would start with a parts list with dimensions of the parts, plus 1/8 in for the saw blade. Another array would list available wood, such as plywood, and its dimensions. As pieces are cut, it leaves remaining pieces to be used up by remaining parts. Each dimension of the part would be checked against available area on the cut wood until all three dimensions were satisfied and added to a "Cut List." Then it goes on to the next one.
To raise the bar even more, it would be great to have it go through some algorythm of all the possibilities to create a result with the least amount of scrap wood left on each sheet of plywood.
Somewhere out there is a manufacturing assembly line that has already mastered this task, but as of today Im yet to find any software available for the consumer.
