IT RESOURCE CHART - ADDING % Availability

Good day!

I am working on a spreadsheet to monitor project resource availability. While I can show and indicate overlapping projects and availability by DATES, I need some help with representing the % availability.

Attached is a spreadhseet with the "AVAILABILITY" tab indicating overlapping projects and availabiliity by dates.

I was wondering if anyone could help me with putting a total percentage availability into each timeslot on the "AVAILABILITY" tab.

The "PROJECT/RESOURCE" tab is where I enter the % Allocation per resource. I would like the %s to add up per resource and be represented in each DAY SLOT in the "AVAILABILITY" tab. So along with the colour to indicate projects overlapping, I would like to show the % totals per day as well.

For instance, MICHAEL R has 4 parallel projects, 20% per project...i would like it total 80% throughout the "RED" bar. In some cases, it might go over 100% which is ok.

ANY HELP IS APPRECIATED. TOTALLY STUCK.

THANK YOU KINDLY!

Attached is the spreadsheet.