Fill This Form To Receive Instant Help
Homework answers / question archive / Shelly Cashman Excel 2019 | Module 9: SAM Project 1a Maxwell Training FORMULA AUDITING, DATA VALIDATION, AND COMPLEX PROBLEM SOLVING Open the file SC_EX19_9a_FirstLastName_1
Shelly Cashman Excel 2019 | Module 9: SAM Project 1a
Maxwell Training
FORMULA AUDITING, DATA VALIDATION, AND COMPLEX PROBLEM SOLVING
Table 1: Cell Values for the Max Attendance Scenario
Cell |
Value |
Orientation_Trainees (cell B8) |
24 |
Tech_Skills_Trainees (cell C8) |
8 |
Soft_Skills_Trainees (cell D8) |
32 |
Product_Trainees (cell E8) |
24 |
Mandatory_Trainees (cell F8) |
32 |
Table 2: Cell Values for the Low Attendance Scenario
Cell |
Value |
Orientation_Trainees (cell B8) |
10 |
Tech_Skills_Trainees (cell C8) |
2 |
Soft_Skills_Trainees (cell D8) |
16 |
Product_Trainees (cell E8) |
10 |
Mandatory_Trainees (cell F8) |
15 |
Table 3: Solver Constraints
Constraint |
Cell or Range |
Each webinar is scheduled at least once on Tuesday and once on Thursday |
B4:F5 |
Each Tuesday and Thursday webinar value is an integer |
B4:F5 |
Each type of webinar is scheduled 1 time per week or more |
B6:F6 |
Each type of webinar is scheduled 3 times per week or less |
B6:F6 |
The total number of Tuesday webinars is 5 or less |
Total_Tuesday_Webinars |
The total number of Thursday webinars is 15 or less |
Total_Thursday_Webinars |
The total number of webinars per week is 13 |
Total_Weekly_Webinars |
The total number of Tuesday consultations is 2 or less |
Tuesday_Consultations |
The total number of Thursday consultations is 2 or less |
Thursday_Consultations |
The total number of consultations per week is 5 or less |
Total_Consultations |
Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project.
Already member? Sign In