Allocating OT Hours - SOLVED

Ok, after working on this for a few hours and then walking away right after I posted I had an epiphany moment.

I was able to develop a solution without using pivot tables.

I hope others can utilize this.