Nice work!
Challenge75_Data (1).xlsx (13.2 KB)
great challenge!
This was a super fun refresher!
0306_Ashcroft_Challenge75_Data.xlsx (15.2 KB)
My file also didn’t upload, so I submitted a picture. This was super fun and was a good refresher of IS 201 material!
Challenge75_Data.xlsx (12.2 KB)
A great challenge and review of solver!
HallieAnderson_Challenge75_Data.xlsx (14.6 KB)
This was a great reminder! I had highlighted one of my constraints in the wrong row and couldn’t figure it out for longest time. It really helped me understand what I was doing for each task!
Challenge75_Data.xlsx (11.5 KB)
Challenge75_Data.xlsx (15.0 KB)
I enjoyed this review of the solver function, it helped me get back into the groove.
Challenge75_Data.xlsx (13.2 KB)
Here is my answer!
1 Like
Great refresher on the solver tool in excel! Also I was able to do it with only 5 constraints instead of the recommended eight, I don’t know if its more efficient but I thought I would share.
2 Likes
Good review on how to use the solver tool!
Challenge75_Data.xlsx (11.9 KB)
Here is my solution!
Jenna Sofoul- Challenge 75.xlsx (11.5 KB)
I haven’t used the solver tool in a while- so this was a great review/practice!
Challenge75_Data.xlsx (11.0 KB)
Here is my solution to the challenge! This was a great challenge! It reminded me of all that we could do with solver and how it can create so many great plans with it!
Challenge75_Data.xlsx (11.5 KB)
Here is my solution.
Here is my solution! I think the most challenging part for me was just remembering to use sumproduct. Also, spare yourself time and use arrays in the constraints rather than setting constraints for every cell.
0611_Doles_Challenge75_Data.xlsx (11.6 KB)
Challenge75_Data_Skyler_Beckstead.xlsx (11.5 KB)
This is my solution! It was a good refresher course from the IS 201 class!