I am looking for someone who can help create a spreadsheet for a somewhat complex situation.
I have physical products that I ship and in order to reduce my shipping costs I am able to nest some products inside others. I have the problem of figuring out what items can nest inside of others from a large list of items.
My products come in sizes that range from 5" to 16". I can nest up to 3 items inside one another if it is a 12", 10", and 9". The 9" goes inside the 10" and they both fit inside the 12".
I may have a list of items to ship such as:
0, 8" items
4, 7" items
0, 10" items
0, 12" items
0, 11" items
0, 6" items
Using a Google Sheet I would like to enter in the quantity of the different size items I have and then have a report that tells me how many nestings I can do and with which items in the most efficient manner.
So in this case I may have:
3 nestings of 12", 11", 10"
2 nestings of 11", 10", 8"
1 nesting of 11”, 8”, 7”
1 nesting of 8”, 7”, 6”
1 nesting of 8”, 7”,
4 single items of 7”
If it is acceptable to do so in this forum, I am willing to compensate for a quality solution to this problem.
Thank you
--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/15b39051-3f66-4111-98f2-748014329696n%40googlegroups.com.
Crystal Tones
SAMUEL G POTTER |
Operations / Technology Officer 5684 S 900 E Murray, UT 84121 (Cell) 1-360-989-4748 (Office) 1-385-799-2800 (EMAIL) s...@crystaltones.com |
DISCLOSURES: ANY MATERIAL EXCHANGED BETWEEN THE PARTIES HERETO IS FOR DISCUSSION PURPOSES
ONLY AND ARE PRIVATE IN NATURE AND ARE NOT A SOLICITATION TO THE PUBLIC. Sender declares that he is not a licensed United States Securities broker or Dealer or U.S. investment advisor, and both parties maintain that this email is not intended for the buying, selling, or trading or securities, or the offering of counsel or advice concerning any such activities. **By accepting and opening this email, you have agreed to a binding non-disclosure & non-circumvent that ensures complete confidentiality between the reader and creator of the contents/attachments presented in this email, which further prohibits any promotion, discussion, replication or additions without the consent of VIP Consulting Service. *The content of this email does NOT constitute a contract of services or promise of services or investment or promised investment capital toward any concept, idea or project referenced or directly addressed in the body or relating portions of this email. This email is merely designed as an exchange of ideas. ** This email transmission and any attachments are for the sole use of the intended recipient(s) and may contain confidential and privileged information that is the exclusive property of VIP Consulting Service, Consultants, Owners, Directors, Operators, and any Affiliated Organization Associated Companies. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and destroy and delete all copies of this email and any attachments. These Confidential communications are protected under Gramm-Leach-Bailey Act 15 USC, Subchapter 1, sections 6801-6809 and other laws addressing the disclosure of Non-Public Personal Information. Also, see http://www.ftc.gov/privacy/glbact/glbsub1.htm Gramm-Leach-Bliley Act 15 USC, Subchapter 1, Sec. 6801-6809.
--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/9ba1c8e0-15a1-43a2-8de5-222031904f6bn%40googlegroups.com.
At what difference in size would you not allow nesting?
In the situation below, you indicated 12 and 8 would not be a good combo. Your desired less than 3 inch difference is fine, but at what point would you say no to a combo? Or is the 3 inch difference the limit?
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAAL80Z%2B9xCA2dcTw2iuW90wawytY_CRQJt3Pf27Ncu4pJzpu%3Dg%40mail.gmail.com.
Ok this seems like a nice little project. Would be happy to do it for you, unless others want to help.
Let me know and I can get started on it. To do so, please make a copy of the spreadsheet and provide edit access to this account.
Thanks,
George
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/1fc87495-d289-4598-9a43-66bf7b1ba969n%40googlegroups.com.
Crystal Tones
SAMUEL G POTTER |
Operations / Technology Officer 5684 S 900 E Murray, UT 84121 (Cell) 1-360-989-4748 (Office) 1-385-799-2800 (EMAIL) s...@crystaltones.com |
DISCLOSURES: ANY MATERIAL EXCHANGED BETWEEN THE PARTIES HERETO IS FOR DISCUSSION PURPOSES
ONLY AND ARE PRIVATE IN NATURE AND ARE NOT A SOLICITATION TO THE PUBLIC. Sender declares that he is not a licensed United States Securities broker or Dealer or U.S. investment advisor, and both parties maintain that this email is not intended for the buying, selling, or trading or securities, or the offering of counsel or advice concerning any such activities. **By accepting and opening this email, you have agreed to a binding non-disclosure & non-circumvent that ensures complete confidentiality between the reader and creator of the contents/attachments presented in this email, which further prohibits any promotion, discussion, replication or additions without the consent of VIP Consulting Service. *The content of this email does NOT constitute a contract of services or promise of services or investment or promised investment capital toward any concept, idea or project referenced or directly addressed in the body or relating portions of this email. This email is merely designed as an exchange of ideas. ** This email transmission and any attachments are for the sole use of the intended recipient(s) and may contain confidential and privileged information that is the exclusive property of VIP Consulting Service, Consultants, Owners, Directors, Operators, and any Affiliated Organization Associated Companies. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and destroy and delete all copies of this email and any attachments. These Confidential communications are protected under Gramm-Leach-Bailey Act 15 USC, Subchapter 1, sections 6801-6809 and other laws addressing the disclosure of Non-Public Personal Information. Also, see http://www.ftc.gov/privacy/glbact/glbsub1.htm Gramm-Leach-Bliley Act 15 USC, Subchapter 1, Sec. 6801-6809.
--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/c303c037-fe69-42ce-8fda-c7d7e2a40f0dn%40googlegroups.com.
Crystal Tones
SAMUEL G POTTER |
Operations / Technology Officer 5684 S 900 E Murray, UT 84121 (Cell) 1-360-989-4748 (Office) 1-385-799-2800 (EMAIL) s...@crystaltones.com |
DISCLOSURES: ANY MATERIAL EXCHANGED BETWEEN THE PARTIES HERETO IS FOR DISCUSSION PURPOSES
ONLY AND ARE PRIVATE IN NATURE AND ARE NOT A SOLICITATION TO THE PUBLIC. Sender declares that he is not a licensed United States Securities broker or Dealer or U.S. investment advisor, and both parties maintain that this email is not intended for the buying, selling, or trading or securities, or the offering of counsel or advice concerning any such activities. **By accepting and opening this email, you have agreed to a binding non-disclosure & non-circumvent that ensures complete confidentiality between the reader and creator of the contents/attachments presented in this email, which further prohibits any promotion, discussion, replication or additions without the consent of VIP Consulting Service. *The content of this email does NOT constitute a contract of services or promise of services or investment or promised investment capital toward any concept, idea or project referenced or directly addressed in the body or relating portions of this email. This email is merely designed as an exchange of ideas. ** This email transmission and any attachments are for the sole use of the intended recipient(s) and may contain confidential and privileged information that is the exclusive property of VIP Consulting Service, Consultants, Owners, Directors, Operators, and any Affiliated Organization Associated Companies. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and destroy and delete all copies of this email and any attachments. These Confidential communications are protected under Gramm-Leach-Bailey Act 15 USC, Subchapter 1, sections 6801-6809 and other laws addressing the disclosure of Non-Public Personal Information. Also, see http://www.ftc.gov/privacy/glbact/glbsub1.htm Gramm-Leach-Bliley Act 15 USC, Subchapter 1, Sec. 6801-6809.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/ece13a5b-d35f-4685-bd12-14844ddb1ed9n%40googlegroups.com.
Crystal Tones
SAMUEL G POTTER |
Operations / Technology Officer 5684 S 900 E Murray, UT 84121 (Cell) 1-360-989-4748 (Office) 1-385-799-2800 (EMAIL) s...@crystaltones.com |
DISCLOSURES: ANY MATERIAL EXCHANGED BETWEEN THE PARTIES HERETO IS FOR DISCUSSION PURPOSES
ONLY AND ARE PRIVATE IN NATURE AND ARE NOT A SOLICITATION TO THE PUBLIC. Sender declares that he is not a licensed United States Securities broker or Dealer or U.S. investment advisor, and both parties maintain that this email is not intended for the buying, selling, or trading or securities, or the offering of counsel or advice concerning any such activities. **By accepting and opening this email, you have agreed to a binding non-disclosure & non-circumvent that ensures complete confidentiality between the reader and creator of the contents/attachments presented in this email, which further prohibits any promotion, discussion, replication or additions without the consent of VIP Consulting Service. *The content of this email does NOT constitute a contract of services or promise of services or investment or promised investment capital toward any concept, idea or project referenced or directly addressed in the body or relating portions of this email. This email is merely designed as an exchange of ideas. ** This email transmission and any attachments are for the sole use of the intended recipient(s) and may contain confidential and privileged information that is the exclusive property of VIP Consulting Service, Consultants, Owners, Directors, Operators, and any Affiliated Organization Associated Companies. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and destroy and delete all copies of this email and any attachments. These Confidential communications are protected under Gramm-Leach-Bailey Act 15 USC, Subchapter 1, sections 6801-6809 and other laws addressing the disclosure of Non-Public Personal Information. Also, see http://www.ftc.gov/privacy/glbact/glbsub1.htm Gramm-Leach-Bliley Act 15 USC, Subchapter 1, Sec. 6801-6809.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/255c27b3-683c-4667-b394-851b00f465ben%40googlegroups.com.
Crystal Tones
SAMUEL G POTTER |
Operations / Technology Officer 5684 S 900 E Murray, UT 84121 (Cell) 1-360-989-4748 (Office) 1-385-799-2800 (EMAIL) s...@crystaltones.com |
DISCLOSURES: ANY MATERIAL EXCHANGED BETWEEN THE PARTIES HERETO IS FOR DISCUSSION PURPOSES
ONLY AND ARE PRIVATE IN NATURE AND ARE NOT A SOLICITATION TO THE PUBLIC. Sender declares that he is not a licensed United States Securities broker or Dealer or U.S. investment advisor, and both parties maintain that this email is not intended for the buying, selling, or trading or securities, or the offering of counsel or advice concerning any such activities. **By accepting and opening this email, you have agreed to a binding non-disclosure & non-circumvent that ensures complete confidentiality between the reader and creator of the contents/attachments presented in this email, which further prohibits any promotion, discussion, replication or additions without the consent of VIP Consulting Service. *The content of this email does NOT constitute a contract of services or promise of services or investment or promised investment capital toward any concept, idea or project referenced or directly addressed in the body or relating portions of this email. This email is merely designed as an exchange of ideas. ** This email transmission and any attachments are for the sole use of the intended recipient(s) and may contain confidential and privileged information that is the exclusive property of VIP Consulting Service, Consultants, Owners, Directors, Operators, and any Affiliated Organization Associated Companies. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and destroy and delete all copies of this email and any attachments. These Confidential communications are protected under Gramm-Leach-Bailey Act 15 USC, Subchapter 1, sections 6801-6809 and other laws addressing the disclosure of Non-Public Personal Information. Also, see http://www.ftc.gov/privacy/glbact/glbsub1.htm Gramm-Leach-Bliley Act 15 USC, Subchapter 1, Sec. 6801-6809.
Good luck Sam. Good job Rob.I'll post an update if I end up posting this to another site to canvas a larger audience.It reminds me a bit of the bin-packing problem. Although I never was an algorithms guy (I just like puzzles and problems), I once had to implement a heuristic approach to the "bin-packing" problem to put files of various sizes into zip files that could only be so large because of the web protocol. The bin packing problem is NP hard, and though this seems easier (maybe?), this very well could be also. So I'm curious about it.I'd love to hear if you get the problem on that site or do anything else with it Rob.
On Monday, June 27, 2022 at 2:49:11 PM UTC-7 s...@crystaltones.com wrote:
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/73563570-7c61-4b84-b87f-eae0748c898an%40googlegroups.com.
--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/1222b3fb-7a72-427b-8c9d-e2d8197512f3n%40googlegroups.com.
Interesting. However, it would have been nice if you requested a solution in JavaScript so we can understand better what he was suggesting to do with his solution.
From: google-apps-sc...@googlegroups.com <google-apps-sc...@googlegroups.com> On Behalf Of Steve Schlager
Sent: July 4, 2022 9:10 PM
To: Google Apps Script Community <google-apps-sc...@googlegroups.com>
Subject: Re: [Apps-Script] Re: Nesting Items based on quantity and sizing
For anyone interested:
https://stackoverflow.com/questions/72849330/nesting-bowls-for-shipping
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/776cea99-a543-4c28-b1df-e59241a57afan%40googlegroups.com.
Crystal Tones
SAMUEL G POTTER |
Operations / Technology Officer 5684 S 900 E Murray, UT 84121 (Cell) 1-360-989-4748 (Office) 1-385-799-2800 (EMAIL) s...@crystaltones.com |
DISCLOSURES: ANY MATERIAL EXCHANGED BETWEEN THE PARTIES HERETO IS FOR DISCUSSION PURPOSES
ONLY AND ARE PRIVATE IN NATURE AND ARE NOT A SOLICITATION TO THE PUBLIC. Sender declares that he is not a licensed United States Securities broker or Dealer or U.S. investment advisor, and both parties maintain that this email is not intended for the buying, selling, or trading or securities, or the offering of counsel or advice concerning any such activities. **By accepting and opening this email, you have agreed to a binding non-disclosure & non-circumvent that ensures complete confidentiality between the reader and creator of the contents/attachments presented in this email, which further prohibits any promotion, discussion, replication or additions without the consent of VIP Consulting Service. *The content of this email does NOT constitute a contract of services or promise of services or investment or promised investment capital toward any concept, idea or project referenced or directly addressed in the body or relating portions of this email. This email is merely designed as an exchange of ideas. ** This email transmission and any attachments are for the sole use of the intended recipient(s) and may contain confidential and privileged information that is the exclusive property of VIP Consulting Service, Consultants, Owners, Directors, Operators, and any Affiliated Organization Associated Companies. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and destroy and delete all copies of this email and any attachments. These Confidential communications are protected under Gramm-Leach-Bailey Act 15 USC, Subchapter 1, sections 6801-6809 and other laws addressing the disclosure of Non-Public Personal Information. Also, see http://www.ftc.gov/privacy/glbact/glbsub1.htm Gramm-Leach-Bliley Act 15 USC, Subchapter 1, Sec. 6801-6809.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/776cea99-a543-4c28-b1df-e59241a57afan%40googlegroups.com.
Crystal Tones
SAMUEL G POTTER |
Operations / Technology Officer 5684 S 900 E Murray, UT 84121 (Cell) 1-360-989-4748 (Office) 1-385-799-2800 (EMAIL) s...@crystaltones.com |
DISCLOSURES: ANY MATERIAL EXCHANGED BETWEEN THE PARTIES HERETO IS FOR DISCUSSION PURPOSES
ONLY AND ARE PRIVATE IN NATURE AND ARE NOT A SOLICITATION TO THE PUBLIC. Sender declares that he is not a licensed United States Securities broker or Dealer or U.S. investment advisor, and both parties maintain that this email is not intended for the buying, selling, or trading or securities, or the offering of counsel or advice concerning any such activities. **By accepting and opening this email, you have agreed to a binding non-disclosure & non-circumvent that ensures complete confidentiality between the reader and creator of the contents/attachments presented in this email, which further prohibits any promotion, discussion, replication or additions without the consent of VIP Consulting Service. *The content of this email does NOT constitute a contract of services or promise of services or investment or promised investment capital toward any concept, idea or project referenced or directly addressed in the body or relating portions of this email. This email is merely designed as an exchange of ideas. ** This email transmission and any attachments are for the sole use of the intended recipient(s) and may contain confidential and privileged information that is the exclusive property of VIP Consulting Service, Consultants, Owners, Directors, Operators, and any Affiliated Organization Associated Companies. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and destroy and delete all copies of this email and any attachments. These Confidential communications are protected under Gramm-Leach-Bailey Act 15 USC, Subchapter 1, sections 6801-6809 and other laws addressing the disclosure of Non-Public Personal Information. Also, see http://www.ftc.gov/privacy/glbact/glbsub1.htm Gramm-Leach-Bliley Act 15 USC, Subchapter 1, Sec. 6801-6809.
No worries Sam. Frankly the post in the other forum is a bit academic and a lot of effort to wade through (at least for me).I'm taking the guy's code that solved it and making it Javascript as time permits. I'm close to finished, just a few bugs to fix. When I finish I'll share it for whoever is interested.As stated previously Rob's solution is right most of the time and should get your shipping costs down and save you some headache figuring out how to package things.For me I got interested in the academic idea of an algorithm that always finds the best solution. Maybe I'll create a sheet with some metrics as well.
On Wednesday, July 6, 2022 at 6:36:35 AM UTC-7 s...@crystaltones.com wrote:
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/a69916c4-abb3-46c6-8746-7253e46b4d3dn%40googlegroups.com.