I run a cutting centre where I cut pieces(dimension Xi x Yi) of wood from one big stock each time different sizes (mostly 2800 x 2070). I want to know how to cut the big stock in order to minimize waste. All data should be gathered from a google spreadsheet and the solution should be written in GAS(google apps script).
User input into google spreadsheet:
1 - pieces size (Xi x Yi, and how many)
2 - saw thickness
3 - master blank sizes
Printable drawing (it can be pdf or google drawing or whatever) in A4 format, showing how I should cut the master wood blank into smaller pieces to minimize waste.
Small table with % waste.
1500 | 1000 | 3
1500 | 500 | 2
820 | 220 | 4
400 | 400 | 5
600 | 400 | 9
100 | 300 | 4
0,5 (saw thickness)
2800 | 2070
[url removed, login to view]
What is also required is to add: based on which length I should print out "graphics".
Based on length Xi or Yi
so user inputs in spreadsheet:
Xi | Yi | How many | graphics according to dim X or Y, where 1 represent X and 2 represent Y
1500 | 1000 | 3 | 1
1500 | 500 | 2 | 2
820 | 220 | 4 | 1
400 | 400 | 5 | 2
600 | 400 | 9 | 1
100 | 300 | 4 | 1
2. Saw thickness:
3. Master blank size
2800 x 2700
Sample output attached
Hello, I'm a G-suite developer, the optimization part of this project is tricky but is doable using apps script, but there is no draw support and no one can draw even a line inside an image without the use of an exter Plus
7 freelance font une offre moyenne de €211 pour ce travail
Hi employer. I am a web developer. I have many experience and affection with field of web specialty. We can discuss for good results. I will effort for complete your job satisfactorily.
Dear Hiring Manager, I am professional software,website & mobile app. developer.I can start working as soon as possible. https://www.freelancer.com/u/mehulprajapati91.html -- My previously Worked proje Plus
Honorable Seniors,I will work for you all my best. i have experience of 6 years in developing wordpress,Magento,PHP,Javascrip,json,android,iPhon,Java so on programming and Delphi. Please hire me. I hope you are succe Plus
I have more than 5 years experience in PHP programming and well versed in open-sources / Framework like Codeigniter , OpenCart, Wordpress and other Web solutions . My strengths are web development, PHP, ajax, CSS, HTML Plus
Hi, I can start work on your project immediately once you confirm me and i am also open for further discussion if you want. I have 7+ years in web designing & development with good experience in following skills Plus
Dear Hiring Manager, I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. My work experience as shown in my profile have helped me develop mastery in We Plus