75|EXCEL – Audit Schedule Solver

[Jake_Rich]

Challenge75.xlsx (11.5 KB)

[McKay_Larsen]

Challenge75_Data.xlsx (13.0 KB)

[Canon_Rogers]

Rating: Beginner
Time: 15 minutes
Comment: I’m not sure if this is something I should have known, but it would have been nice for the hint to have included to use nonlinear solver. Other than that, very easy to understand what to do!

[Helina_Uibel]

Time to complete: 25 minutes
Challenge75_Data (1).xlsx (11.5 KB)

[Preston_Dudley]

Time to complete: 30 minutes
Learned how to use =SUMPRODUCTS,

[William_Kirk]

Time: 17 Minutes, Difficulty: 5/10
Challenge75_Data_WK.xlsx (11.5 KB)

[Alejandro_Sanchez]

Time to complete: 20 Minutes
Difficulty: Intermediate
Challenge75_Data5.xlsx (12.9 KB)

[Faith_Bangerter]

Challenge75_DataCompleted.xlsx (12.9 KB)

[Adlee_Baird]

Time: 15 min
Difficulty: easy once I figured out how to use solver again
solution:

[Adlee_Baird]

Agreed! I was thinking of how I could use it for my every day life.

[Isaac_Hall]

Time to complete: 10 mins
Level: Beginner
This was a good intro to show how solver can be effective.

Challenge75_Data.xlsx (13.0 KB)

[Matthew_Herrod]

Time to Solve: 20 minutes
Level: Intermediate
Fun time refreshing how to do solver!
Challenge75_Data.xlsx (11.6 KB)

[Caden_Vance]

Time to complete: 10 minutes
Rating: Beginner
Comments: I like the updated Solver! It is much more user friendly than the old one.
Solution:

[Ainsley_Barlow]

[Luke_Herron]

Time to complete: 20 minutes
Difficulty: Intermediate
That was a good refresher - I had to go watch a youtube video on how to do it haha.
I didn’t use sumproduct. I just did each box times the price per customer per office then summed all those together.

[Isabel_McKinlay]

[Shawn_McDougal]

Time to complete: 10 minutes
Difficulty: beginner
It was a great review of how to interpret data to prepare to use solver.

[Ethan_Anderson]

Time to complete: 10 minutes
Difficulty: easy
Solution:
Challenge75_Data.xlsx (11.0 KB)

[Andrew_Dolphin]

Not too bad, like 10ish mins