CubaRJ
New Member
- Joined
- Mar 21, 2022
- Messages
- 29
- Office Version
- 365
- 2019
- Platform
- Windows
Hi! I am struggling to find a suitable solution for this problem, and hoping you guys can help me.
The problem: how can I make a summary to reply to a couple of questions we have about these matrices?
For example:
Since Excel has several formulas and also Power Query or even VBA, I am not sure how to use them to achieve the results.
Can anyone help me?
PS: I did not find a way to post the sanitized spreadsheet for you guys to see it. If anyone know how to attach it, please let me know. But I am leaving the Link to file from my iCloud for download.
- I have 3 different worksheets containing training matrces for installations;
- Each tab belongs to an installation;
- The columns and structure are the same for all of them, and the difference between them is "Positions" and the training required to work in each installation.
- Important to note this matrix does not belong to me, so I cannot change its structure.
The problem: how can I make a summary to reply to a couple of questions we have about these matrices?
For example:
- How many training sessions are required for position X to work at Installation Z?
- How many days are necessary to attend training to act as Y at Installation W?
- How many hours of training are required to be fully competent in position G to work at Installation D?
- If we consider a new employee taking all training on Year 1 and each training having its own expiring date, what will be the year-over-year training backlog to avoid expiration?
Since Excel has several formulas and also Power Query or even VBA, I am not sure how to use them to achieve the results.
Can anyone help me?
PS: I did not find a way to post the sanitized spreadsheet for you guys to see it. If anyone know how to attach it, please let me know. But I am leaving the Link to file from my iCloud for download.