
franck louis
New Member
Members

Forum Posts: 1
Member Since:
April 13, 2021
April 13, 2021

Can any help with this somewhat difficult problem?
I am wanting to create a spreadsheet where I can enter 48 values in a list which represent the lengths of picture framing moldings required to make say 12 picture frames of different sizes and using the same molding profile (4 sides for one frame).
The uncut moldings are 4 meters long. The spreadsheet needs to automatically generate arrays populated with the lengths to cut from each 4 meter length of profile in order to minimize off cut wastage.
Each array representing 1 full 4 meter length.
Basically the spreadsheet needs to optimize the mix of lengths to cut from each 4 meter long picture frame molding. for example the 12 frames to be made are as follows: 4 frames 80 x 120 cm, 2 frames 65 x 95 cm, 2 frames 70 x 110, 2 frames 30 x 50 cm, 1 frame 105 x 160, 1 frame 25 x 65.
The spreadsheet also needs to indicate how many lengths of moldings will be required.
Thanks in advance for any suggestions.
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Catalin Bombea, Velouria
Guest(s) 11
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 871
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
Jessica Stewart: 204
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Murat Hasanoglu
Brett Dryland
Saeed Aldousari
Bhuwan Devkota
Kathryn Patton
Maria Conatser
Jefferson Granemann
Glen Coulthard
Nikki Fox
Rachele Dickie
Forum Stats:
Groups: 3
Forums: 24
Topics: 6222
Posts: 27291
Member Stats:
Guest Posters: 49
Members: 31913
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
