Trying to figure out how to create a spreadsheet that will help show availabilities between auditors and suppliers. We have 20 auditors and 100 suppliers. We need to audit these suppliers. Suppliers will need from 1 to 3 auditors during audits. Can this be done with Excel? Any help would be great.
Here is an example
How can I create a schedulers that will compare the availabilities of all of the suppliers and the combination of auditors ?
Here is an example
| Supplier A | Available for audit on Jan 15-19, 2024 | Need auditors 1 and 3 |
|---|---|---|
| Supplier B | Available for audit on Feb 12-16, 2024 | Need auditors 1 and 2 |
| Supplier C | Available for audit on Oct 21-25, 2024 | Need auditor 2 |
| Auditor 1 | Available to perform audit all of 2024 |
|---|---|
| Auditor 2 | Available to perform audit all of 2024 |
| Auditor 3 | Available to perform audit all of 2024 |
How can I create a schedulers that will compare the availabilities of all of the suppliers and the combination of auditors ?
