Hi folks,
After success on this board earlier this week, I’ve decided to put together a management information type system for my department at school.
I currently teach at different sites and I’m trying to ensure an even split of equipment between sites.
I’ve put a simple site, course and equipment matrix but need to work out how to create a summary dashboard for it. Ideally I’d like to avoid pivot tables as this is going to go into a bigger course planning matrix - but I’ve simplified the problem with the aim of learning how to apply a solution to my bigger matrix.
Thanks in advance you wonderful people. Hopefully I have included all of the info required, I’ve put my expected table based on the data in a second ‘dash’ tab.
Course Equipment Matrix Example
After success on this board earlier this week, I’ve decided to put together a management information type system for my department at school.
I currently teach at different sites and I’m trying to ensure an even split of equipment between sites.
I’ve put a simple site, course and equipment matrix but need to work out how to create a summary dashboard for it. Ideally I’d like to avoid pivot tables as this is going to go into a bigger course planning matrix - but I’ve simplified the problem with the aim of learning how to apply a solution to my bigger matrix.
Thanks in advance you wonderful people. Hopefully I have included all of the info required, I’ve put my expected table based on the data in a second ‘dash’ tab.
Course Equipment Matrix Example