Challenge #66: My Wine Problem
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I had good fun with that challenge. Almost popped a bottle
I must admit that I didn't unlock the DOUBLE BONUS.
The batch-macro will fail if the IDs are not numerical incl Null. That I guess is just the nature of the formula tool working with numbers. Furthermore I added a Test-tool to flag cases where Starting ID is greater than Ending ID.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can't add my macro...
The contents of the attachment doesn't match its file type.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I've attached my solution which is a bit of a different approach. The approach that I took was to minimize empty spaces in boxes (assuming that this would minimize our shipping costs). For example order number 4 is 270 bottles so the passes would break down as follows:
Pass
1 - 2: 96 bottles in a box
3 - 8: 12 bottles in a box
9: 6 bottles in a box
This would be a fun one to revisit as an optimization problem if we had the shipping costs per box, packing costs per box, cost per box, etc...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator