Find dates in table for specific asset and populate Gantt

I'm trying to build a utilization chart (Gantt) showing utilization of assets over a certain time period. I have multiple assets, A-E which are re-used throughout the year for various projects. Asset A may be used Jan 1 through Jan 15th then sit idle and used again Feb 15-March 30. I want to display that use in a single row with columns being dates over the year.

Existing List from which I want to populate the output:
Project 1 Asset A 1/1/2013 to 1/15/2013
Project 2 Asset B 1/5/2013 to 2/15/2013
Project 3 Asset A 2/15/2013 to 3/30/2013

Desired OUTPUT:

Column A 1/1/2013 1/15/2013 1/30/2013 .....etc.
ASSET A COLORFILLCOLORFILL EMPTYEMPTYEMPTY ....COLORFILL...etc.
ASSET B
ASSET C

Any thoughts on how to use a formula in the desired output that searches the input to populate the OUTPUT?

Thanks,
JK

Close. Except I don't want to manually have to create the lines. I have a master schedule with hundreds of rows assigning various assets to various projects. I'd like to use the visual with each asset listed on one row and the corresponding dates colored to the right. I'm looking for the formula that would help populate the cells for each date which I can then conditional format to color.
Attached is what I did manually as a sample.

Yes! Now just imagine all the assets being re-used multiple times at various date ranges.

This looks great! Thank you for your help.