Fill This Form To Receive Instant Help
Homework answers / question archive / Shelly Cashman Excel 2019 | Module 9: SAM Critical Thinking Project 1c Maxwell Training FORMULA AUDITING, DATA VALIDATION, AND COMPLEX PROBLEM SOLVING GETTING STARTED Open the file SC_EX19_CT9c_FirstLastName_1
Shelly Cashman Excel 2019 | Module 9: SAM Critical Thinking Project 1c
Maxwell Training
FORMULA AUDITING, DATA VALIDATION, AND COMPLEX PROBLEM SOLVING
Table 1: Cell Values for the Max Attendance Scenario
Cell |
Value |
Orientation_Trainees |
24 |
Tech_Skills_Trainees |
8 |
Soft_Skills_Trainees |
32 |
Product_Trainees |
24 |
Mandatory_Trainees |
32 |
Table 2: Cell Values for the Low Attendance Scenario
Cell |
Value |
Orientation_Trainees |
10 |
Tech_Skills_Trainees |
2 |
Soft_Skills_Trainees |
16 |
Product_Trainees |
10 |
Mandatory_Trainees |
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.