75|EXCEL – Audit Schedule Solver

Challenges
, , ,
81

Challenge75_Data.xlsx (54.4 KB)
Not quite so many constraint rules need to be added as the solution shows if sells with identical rules are grouped together.

2 Likes
82

Here is my solution!
Challenge75_Data.xlsx (11.0 KB)

83

0301_Taylor_Challenge75_Data.xlsx (15.1 KB)
This was such a fun challenge. I haven’t used solver in a long time, so it definitely took me a second to figure out how to do it. Overall, it was a great review of solver. While doing the challenge, I was thinking of ways I can use solver in my job and other possibilities for future employment.

84

Done! Thanks to those who have posted solutions. I’m realizing there were much better ways to write the conditions for the solver than how I did. This has been a helpful refresher.

Challenge75_Data.xlsx (17.3 KB)

85

Good job, Jack!

86

image
image2646×1183 181 KB

Here’s my solution. I could’ve been more efficient but it works!

87

Challenge75_Data.xlsx (11.5 KB)
Thanks for the solver challenge! Here’s my solution.

1 Like
88

Challenge75_Data.xlsx (11.5 KB)
Here is my solution!

1 Like
89

Challenge75_Data_Micah_Nishimura.xlsx (11.5 KB)

Great refresher on using solver.

90

A much needed Solver refresher!

Isom-Challenge75.xlsx (11.8 KB)

91

Here’s the solution of what the final numbers should be.

Solution
Solution978×840 25.2 KB

92

Here’s my answer!
Challenge75_Data_FaithCall.xlsx (15.1 KB)

93

Thanks for the refresher! That was very helpful.

solver solution
solver solution1292×685 51.9 KB

2 Likes
94

Challenge75_Data.xlsx (18.4 KB)
This was a good refresher! It is always cool to learn all the crazy things you can do with Excel.

95

This was a great refresher for using solver to manipulate data faster than it can be accomplished manually. Here is my file!

Challenge75_Data.xlsx (11.6 KB)

96

Debenham_Challenge75_Data.xlsx (15.0 KB)

Here is my solution! This was a great review for Solver.

97

Here is my solution. Thank you for this challenge.

Screenshot 2023-09-20 at 9.27.58 AM
Screenshot 2023-09-20 at 9.27.58 AM1920×1107 172 KB

1 Like
98

Pieper Nelson Challenge 75.xlsx (13.1 KB)

99

Challenge75_Data.xlsx (11.6 KB)

100

Attached is my solution. The MOST helpful thing for this solution was honestly watching the video. I wanted a refresher on using the solver tool and this challenge was perfect for that. I would recommend watching the video after attempting the challenge.
Challenge75_Solution AA.xlsx (11.5 KB)