2d cutting stock problem in google sheets

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).

1 - pieces size (Xi x Yi, and how many)

2 - saw thickness

3 - master blank sizes

----------------

Output:

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.

I.e.

User input

1.

1500 | 1000 | 3

1500 | 500 | 2

820 | 220 | 4

400 | 400 | 5

600 | 400 | 9

100 | 300 | 4

2.

0,5 (saw thickness)

3.

2800 | 2070

example output:

[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:
1.
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:
0,5

3. Master blank size
2800 x 2700

Sample output attached

Compétences : Javascript

Concernant l'employeur :
( 0 commentaires ) Toszek, Poland

N° du projet : #12706738

Décerné à :

mdkass

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

250 € EUR en 10 jours
(12 Commentaires)
4.4

7 freelance ont fait une offre moyenne de 211 € pour ce travail

shaochao555

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.

111 € EUR en 3 jours
(11 Commentaires)
3.9
mehulprajapati91

Dear Hiring Manager, I am professional software,website & mobile app. developer.I can start working as soon as possible. [url removed, login to view] -- My previously Worked proje Plus

140 € EUR en 10 jours
(8 Commentaires)
3.5
kabukii919

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

140 € EUR en 3 jours
(1 Commentaire)
3.3

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

155 € EUR en 3 jours
(8 Commentaires)
2.8
yamaf555

Oh,friendly dear!!! I have the expensive experience of 5 years in developing Javascript and can carry out your any proposal in time completely. I understand your proposal enough,so I have mind to perform the task a Plus

155 € EUR en 3 jours
(2 Commentaires)
2.0
250 € EUR en 3 jours
(3 Commentaires)
1.6
hawkscodeaus

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

200 € EUR en 3 jours
(1 Commentaire)
0.6
370 € EUR en 3 jours
(0 Commentaires)
0.0
nwnz

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

147 € EUR en 3 jours
(0 Commentaires)
0.0