Here is my solution!
I forgot how amazing solver is. This was a great reminder of the potential of solver. This activity made me want to find things in my life that I can solve with this extraordinary excel function.
Here is my solution. I enjoyed playing around with the Solver function in Excel, it has been a while!
I had never used Solver before, and this was a good introduction to it! I technically used a different constraint compared to the solution, but it served the same purpose.
Did not find this one as hard as more of the smple shortcut excel challenges which surprised me! I have had a lot of practice with solver in my university classes which certainly made this challenge fairly simple. I certainly did not get it right on the first try, but just had to change a few of the constraints to get to the final result.
Really enjoyed this one and do see the value in the solver tool!!
Completed_ANS_Challenge75_Data.xlsx (11.5 KB)
Time to complete: 10 min
level: beginner
This was fun and great for beginners!
Challenge75_Data.xlsx (13.0 KB)
Here is my solution.
Challenge75_Data.xlsx (98.9 KB)
Time to Complete: 15 minutes
Difficulty: Intermediate
Comments: It has been awhile since I’ve used the solver tool so this was a nice reminder
Solution:
2 Likes
Time: 15 minutes
rating: easy
Comment: had to brush up on solver but after I figured it out it was alright
Time to Complete: 25
Difficulty: Easy
Solution:
I had to reset all my constraints so it took me some time to do that
Time to complete: 25 min
Difficulty: Medium
Challenge75_Data.xlsx (15.1 KB)