# 75|EXCEL – Audit Schedule Solver

**URL:** https://www.techhub.training/t/75-excel-audit-schedule-solver/641
**Category:** Challenges
**Tags:** solver, excel, beginner, audit
**Created:** [May 12, 2023, 5:05am UTC](https://www.techhub.training/t/75-excel-audit-schedule-solver/641 "2023-05-12T05:05:40Z")
**Posts on this page:** 19
**Page:** 10

<div class="post-metadata">

### Author: ![Jake\_Rich](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/jake_rich/32/7454_2.png) [@Jake\_Rich](https://www.techhub.training/u/Jake_Rich)
#### Post date: [March 12, 2025, 5:26pm UTC](https://www.techhub.training/t/75-excel-audit-schedule-solver/641/182 "2025-03-12T17:26:01Z")

</div>

[Challenge75.xlsx](https://www.techhub.training/uploads/short-url/y0x6AOacZjHYSPsJkmbph8ekaJZ.xlsx) (11.5 KB)

---

<div class="post-metadata">

### Author: ![McKay\_Larsen](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/mckay_larsen/32/7469_2.png) [@McKay\_Larsen](https://www.techhub.training/u/McKay_Larsen)
#### Post date: [March 12, 2025, 6:21pm UTC](https://www.techhub.training/t/75-excel-audit-schedule-solver/641/183 "2025-03-12T18:21:18Z")

</div>

[Challenge75\_Data.xlsx](https://www.techhub.training/uploads/short-url/igkXop76LOJ2oAfrI3KT2dxrTdA.xlsx) (13.0 KB)

---

<div class="post-metadata">

### Author: ![Canon\_Rogers](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/canon_rogers/32/7487_2.png) [@Canon\_Rogers](https://www.techhub.training/u/Canon_Rogers)
#### Post date: [March 12, 2025, 6:25pm UTC](https://www.techhub.training/t/75-excel-audit-schedule-solver/641/184 "2025-03-12T18:25:16Z")

</div>

![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/7/7f799aee3afb2dddd8285221813a43e66de5ee58.png)  
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!

---

<div class="post-metadata">

### Author: ![Helina\_Uibel](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/helina_uibel/32/7578_2.png) [@Helina\_Uibel](https://www.techhub.training/u/Helina_Uibel)
#### Post date: [March 12, 2025, 10:28pm UTC](https://www.techhub.training/t/75-excel-audit-schedule-solver/641/185 "2025-03-12T22:28:23Z")

</div>

Time to complete: 25 minutes  
[Challenge75\_Data (1).xlsx](https://www.techhub.training/uploads/short-url/buglbacItEJywByL8e02UXkkxSL.xlsx) (11.5 KB)

---

<div class="post-metadata">

### Author: ![Preston\_Dudley](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/preston_dudley/32/7403_2.png) [@Preston\_Dudley](https://www.techhub.training/u/Preston_Dudley)
#### Post date: [March 12, 2025, 10:34pm UTC](https://www.techhub.training/t/75-excel-audit-schedule-solver/641/186 "2025-03-12T22:34:04Z")

</div>

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

 ![Screen Shot 2025-03-12 at 4.32.35 PM](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/1/14c8c0da928461bad835c31292d4ae17a0bcfc2f.jpeg)

---

<div class="post-metadata">

### Author: ![William\_Kirk](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/william_kirk/32/7063_2.png) [@William\_Kirk](https://www.techhub.training/u/William_Kirk)
#### Post date: [March 12, 2025, 11:13pm UTC](https://www.techhub.training/t/75-excel-audit-schedule-solver/641/187 "2025-03-12T23:13:06Z")

</div>

Time: 17 Minutes, Difficulty: 5/10  
[Challenge75\_Data\_WK.xlsx](https://www.techhub.training/uploads/short-url/xogPyrk05PooSOdlxrj1ohItrD3.xlsx) (11.5 KB)

---

<div class="post-metadata">

### Author: ![Alejandro\_Sanchez](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/alejandro_sanchez/32/7426_2.png) [@Alejandro\_Sanchez](https://www.techhub.training/u/Alejandro_Sanchez)
#### Post date: [March 12, 2025, 11:23pm UTC](https://www.techhub.training/t/75-excel-audit-schedule-solver/641/188 "2025-03-12T23:23:25Z")

</div>

Time to complete: 20 Minutes  
Difficulty: Intermediate  
[Challenge75\_Data5.xlsx](https://www.techhub.training/uploads/short-url/4553MqyxMmVXdMGKiOH87Bq6qbI.xlsx) (12.9 KB)

---

<div class="post-metadata">

### Author: ![Faith\_Bangerter](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/faith_bangerter/32/7395_2.png) [@Faith\_Bangerter](https://www.techhub.training/u/Faith_Bangerter)
#### Post date: [March 13, 2025, 1:35am UTC](https://www.techhub.training/t/75-excel-audit-schedule-solver/641/189 "2025-03-13T01:35:15Z")

</div>

[Challenge75\_DataCompleted.xlsx](https://www.techhub.training/uploads/short-url/ygLFkMzXHh5mFMDpaLj9g4YYXeB.xlsx) (12.9 KB)

---

<div class="post-metadata">

### Author: ![Adlee\_Baird](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/adlee_baird/32/7627_2.png) [@Adlee\_Baird](https://www.techhub.training/u/Adlee_Baird)
#### Post date: [March 13, 2025, 1:54am UTC](https://www.techhub.training/t/75-excel-audit-schedule-solver/641/190 "2025-03-13T01:54:55Z")

</div>

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

 ![solver](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/1/1772cc8c8cc591a8bb2b4b7b8c90fa02c96ac716.png)

---

<div class="post-metadata">

### Author: ![Adlee\_Baird](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/adlee_baird/32/7627_2.png) [@Adlee\_Baird](https://www.techhub.training/u/Adlee_Baird)
#### Post date: [March 13, 2025, 1:55am UTC](https://www.techhub.training/t/75-excel-audit-schedule-solver/641/191 "2025-03-13T01:55:49Z")

</div>

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

---

<div class="post-metadata">

### Author: ![Isaac\_Hall](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/isaac_hall/32/7133_2.png) [@Isaac\_Hall](https://www.techhub.training/u/Isaac_Hall)
#### Post date: [March 13, 2025, 2:29am UTC](https://www.techhub.training/t/75-excel-audit-schedule-solver/641/192 "2025-03-13T02:29:52Z")

</div>

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

[Challenge75\_Data.xlsx](https://www.techhub.training/uploads/short-url/47HXdNBKnCKTxOHl1Em7T56STaL.xlsx) (13.0 KB)

---

<div class="post-metadata">

### Author: ![Matthew\_Herrod](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/matthew_herrod/32/7593_2.png) [@Matthew\_Herrod](https://www.techhub.training/u/Matthew_Herrod)
#### Post date: [March 13, 2025, 3:19am UTC](https://www.techhub.training/t/75-excel-audit-schedule-solver/641/193 "2025-03-13T03:19:06Z")

</div>

Time to Solve: 20 minutes  
Level: Intermediate  
Fun time refreshing how to do solver!  
[Challenge75\_Data.xlsx](https://www.techhub.training/uploads/short-url/6pPQfBoS2KKlfzvepuYBe6tEIHn.xlsx) (11.6 KB)

---

<div class="post-metadata">

### Author: ![Caden\_Vance](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/caden_vance/32/7587_2.png) [@Caden\_Vance](https://www.techhub.training/u/Caden_Vance)
#### Post date: [March 13, 2025, 3:25am UTC](https://www.techhub.training/t/75-excel-audit-schedule-solver/641/194 "2025-03-13T03:25:51Z")

</div>

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

 ![75 EXCEL Audit Schedule Solver A](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/8/8082e7c8ac48acbffc3d099ad716ad97ef15f624.jpeg)  
 ![75 EXCEL Audit Schedule Solver B](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/5/5492aace03a22ae1b285d68e61beb5c9258a3df8.jpeg)

---

<div class="post-metadata">

### Author: ![Ainsley\_Barlow](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/ainsley_barlow/32/7491_2.png) [@Ainsley\_Barlow](https://www.techhub.training/u/Ainsley_Barlow)
#### Post date: [March 13, 2025, 3:32am UTC](https://www.techhub.training/t/75-excel-audit-schedule-solver/641/195 "2025-03-13T03:32:11Z")

</div>

![challenge 75](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/f/ff43c264ace878a80963d0817736e3cc9e3433ff.png)

---

<div class="post-metadata">

### Author: ![Luke\_Herron](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/luke_herron/32/7616_2.png) [@Luke\_Herron](https://www.techhub.training/u/Luke_Herron)
#### Post date: [March 13, 2025, 3:56am UTC](https://www.techhub.training/t/75-excel-audit-schedule-solver/641/196 "2025-03-13T03:56:06Z")

</div>

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.

 ![Screenshot 2025-03-12 215500](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/c/ca50b00e411a7c688769b43d051e93d886c2a5b7.png)

---

<div class="post-metadata">

### Author: ![Isabel\_McKinlay](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/isabel_mckinlay/32/7528_2.png) [@Isabel\_McKinlay](https://www.techhub.training/u/Isabel_McKinlay)
#### Post date: [March 13, 2025, 4:10am UTC](https://www.techhub.training/t/75-excel-audit-schedule-solver/641/197 "2025-03-13T04:10:51Z")

</div>

![Screenshot 2025-03-12 220942](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/3/32297ab52031f5754ddab71c0c9d465da7ac7f5e.png)

---

<div class="post-metadata">

### Author: ![Shawn\_McDougal](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/shawn_mcdougal/32/7519_2.png) [@Shawn\_McDougal](https://www.techhub.training/u/Shawn_McDougal)
#### Post date: [March 13, 2025, 4:29am UTC](https://www.techhub.training/t/75-excel-audit-schedule-solver/641/198 "2025-03-13T04:29:47Z")

</div>

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

 ![Screenshot 2025-03-12 22.28.56](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/8/8d4bb0ac6905182164e796206eb516c97c7119b0.png)

---

<div class="post-metadata">

### Author: ![Ethan\_Anderson](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/ethan_anderson/32/7465_2.png) [@Ethan\_Anderson](https://www.techhub.training/u/Ethan_Anderson)
#### Post date: [March 13, 2025, 3:31pm UTC](https://www.techhub.training/t/75-excel-audit-schedule-solver/641/199 "2025-03-13T15:31:08Z")

</div>

Time to complete: 10 minutes  
Difficulty: easy  
Solution:  
[Challenge75\_Data.xlsx](https://www.techhub.training/uploads/short-url/dteoWFUhpJVZxLkT9UMCWHgoPHG.xlsx) (11.0 KB)

---

<div class="post-metadata">

### Author: ![Andrew\_Dolphin](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/andrew_dolphin/32/7520_2.png) [@Andrew\_Dolphin](https://www.techhub.training/u/Andrew_Dolphin)
#### Post date: [March 13, 2025, 5:02pm UTC](https://www.techhub.training/t/75-excel-audit-schedule-solver/641/200 "2025-03-13T17:02:29Z")

</div>

![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/f/f0cd40da6ebd24daa45ec693683193835074040c.png)  
Not too bad, like 10ish mins

[Previous page](https://www.techhub.training/t/75-excel-audit-schedule-solver/641.md?page=9)