Trying to clarify:
Tasks have a start and end date. Two resources are required to support that task. The resource value is in percentage required of the total resource required by the task. For instance, Resource A is a conference room and 100% utilization means they are using that room for 100% of the available time for that day or range of days. Resource B could be a effort expected by a particular team, with 100% being the amount of time the team spends on that task during the duration of the task. Tasks durations will overlap wrt to start and finish dates, and utilize a portion of the available resources.
For a particular day on the calendar, I want to see the total utilization of the resources by looking at all the tasks that have fall within that particular date. If any are above 100%, then we have to modify the task and/or resource loading to get it below 100%. Essentually, we have all the data in MS Project, but many are scared to death by MS Project and want to see a nice, date dependant resource loading chart. Rows 1 through 4 are a sample of what the raw MS Project export would look like.
