Challenge #213: Optimized Flower Arrangements

[Ladarthure]

my solution

[OllieClarke]

Struggled with this one (more info in Spoiler).

Spoiler

I spent a while trying to get 'Constraints in Rows' to work, but it kept on totalling to more than 950. 

*I did try sorting the data by price ascending, which got the answer closer to 950, but was still over  🤔

 

I asked my go to optimisation guy @PhilipMannering to help, but he couldn't solve my issue. I've kept the original way I had the tool set up so if anyone with more nous than I can have a look and tell me what I was doing wrong I'd be a very happy Ollie 🙂

[RWvanLeeuwen]

Input some objective to maximise; input some cost matrix; input some constraints; receive an error; debug using sample workflows; ...; success!

Spoiler

[Hannah_Lissaman]

This was fun - dredging up knowledge on a tool I have not used in a while!

[ScottyLeung]

I have compute 2 set of results.

1st consider the green filler is one kind of flowers

2nd the green filler is not classified as flowers, so I simply minimise the number of the and apply the budget to max the number of flowers.  

[huynv96]

Interesting challenge! Thanks

Spoiler

[bmarx112]

Spoiler

[OllieClarke]

I think I've worked out the issue I was having. The cross-tab puts the headers in alphabetical order, which the flowers aren't, so they didn't line up properly in the Optimisation tool. Sorting alphabetically by flower name fixed my issue 🙂 (cc: @PhilipMannering)

Spoiler

[jv1]

Seems to be impossible for me to remember how to use optimization tool since it always feels like I have never seen it before when I need it.. Maybe the next time will be easier (most likely not)

Spoiler

[AMansour]

Hello

Here's my solution

Spoiler

@johnemery thank you for the video that helped me a lot to understand these tool beside the tool mastery.