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

Staff timeline

Sep 3, 2010 7:54AM PDT

I am doing an inquiry of staff at an institution over about a 30 year time period involving about 90 persons who were at the institution at varying years. I want to be able to look at something and see what staff were working at a particular time. My problem is that not all the staff were there at the same time i.e some commenced employment in 1962 and ceased in 1969 while others commenced in 1955 and ceased in 1972.

The persons in the institution were likewise not all there at the same time.

So it involves about 50 staff, about 90 persons names and one institution over about a 30 year time period.

My wish list, would be to look at the page and see when various staff were there at the same time that various particular plaintiffs were there. I have a colour printer. I just cannot get my little mind around how to do it or even where to start.

If anyone has any suggestions it would be greatly appreciated. i have both office for mac + beta of office 2010 on vista & pages

Thanks in advance for any suggestions and have a good weekend.

Cheers

Discussion is locked

- Collapse -
Possible options.
Sep 3, 2010 8:42PM PDT

1. Use a spreadsheet. Each row is a person. Each column is a certain period of time (day, week, month, quarter, year, you didn't tell how fine your scale should be). Use a background color for 'present'.

2. Use a project management tool. They are excellent for planning resources (people) across time, but work just as well for history, of course.

Kees

- Collapse -
staff/patient timeline
Sep 4, 2010 8:26AM PDT

Thanks Kees but it wouldnt show in a snapshot what staff were working when that person was there.

I could use it with either the staff in the rows or the persons but not both.

maybe if i did what you suggested and in the columns included the staff names along with the various year periods (years is fine enough) - its difficult for me to imagine whether that would work or if it would even be readable?

cheers & thanks for the suggestions.