Please help with formulas referencing and analyzing data in second tab

I'd like to be able to do analysis on our work schedule to assess for fairness of distribution of shifts, so I'd like help in developing formulas to achieve an example output table. Please see ...