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.

Alternatively, can anyone recommend a way to represent the availability 20% in a neat way without having to fill in every time in the graph on the "AVAILABILITY" tab?

Any help is appreciated.

I had a thought..maybe instead of colour coding everything, perhaps just list the percentages across the line on the "AVAILABILITY" tab. Then, with some conditional formatting they could be colourized?

Can any help me with trying to add the total percentage availability per resource, and add them alone the timeline in the "AVAILABILITY" tab?

Can't wrap my brain around how to do this.

Please and thank you...any assistance would be golden at this point.