Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

How to chart resource allocations automatically

Mar 21, 2011 8:56PM PDT

Hi

I'm looking for an application or a method of doing this in an existing application such as Access/Excel etc. to do the following ...

I have a list of resource allocations as follows ..

2 0900-0935
2 1000-1400
3 0730-0830
4 1100-1130
4 1310-1340

Where the first number is for example a room number, and the times for when this room is occupied.

I would like to graph this data for a 24-hour period, where each horizontal line on the chart is the room, with lines etc. marking when it is occupied.

I've done a lot of searching but haven't been able to find a way of doing this. Any ideas?

Thanks

Andy

Discussion is locked

- Collapse -
Sure, and a spreadsheet is ideal for this
Mar 21, 2011 9:01PM PDT

I would use an Excel spreadsheet for this. It is made for this type of graphical analysis.

What experience of spreadsheet design do you have? I ask because while what you show is easy to create, this is not the place to "start from the beginning".

Mark

- Collapse -
I'm less optimistic then Mark.
Mar 21, 2011 9:14PM PDT

I think this can't be done without a lot of programming. Visual Basic might be a good tool.

Assuming the 'resolution' has to be 5 minutes and 12 hours to plot, there are 12 (hours) * 12 ( parts of an hour) = 144 line segments for each room that would have to be drawn (or not drawn), each say, 5 pixels wide.


Kees

- Collapse -
Thanks for your responses
Mar 22, 2011 1:08AM PDT

Thanks Mark/Kees

My knowledge of Excel I'd say is basic-medium, and I'm afraid I don't know anything about VB.

Andy