Table Calculation

Hi,

I am trying to create a table calculation to go in the attached file (at least I believe a table calc is the best course of action).

For background, the table currently shown in the tab "View 2" gives the count of distinct "resource names" (or people) considered available by office and rank over the next 3 weeks.

• For the CTL rank, they are considered available if they have less than 87.5 hours booked in the column "value" over the next 3 weeks
• For any other rank, they are considered available if they have less than 16 hours booked in the column "value" over the next 3 weeks

I am then trying to create a count of total teams by office. A team is defined as follows:

• 1 available CTL
• 1 available WSL (experienced or new)
• 2 available associates (experienced or new, can even be one of each)

Outcome:

1. I am hoping to have a row at the bottom that gives the number of teams available for each city
2. Another row that gives the number of teams if you were to pool all people of the same rank across offices
   1. I understand that this will be one number, so it is fine if it is repeated across each office
   2. One exception: I do not want to include the office "Boston-2" in this table calculation

I was thinking this could be some sort of table calculation, but I am having trouble creating it. If you believe that the calculated field for each team member needs to be re-written, please feel free to do so.

Happy to answer any questions on this.

Thanks in advance!

Courtney