3 (4,5) dimensional table in Excel?Possible?How?

  TomJerry 14:10 23 Jul 2004
Locked

I have asked a similar question in another thread
click here, but I think I better to ask the question more specificly.

I got a task to find out staff working hour
statistics for a small company working on
a large number of projects at any point
of time. Each project involves multiple
tasks and multiple staff member, each
staff involes in multiple projects
at anytime.

What I need is just a 3-dimensional table.
Dimension 1: Task Types, Dimension 2: Projects,
Dimension 3: Staff Involved. I can do 2 dimensional table using Excel, but I do not know if I can do 3 even 4 & 5 dimensional table with Excel. I will start with 3 dimensions and add
Dimension 4 (customers) and Dimension 5
(Location) in future. Staff number is
around 30 with some temps addon.

  cga 14:18 23 Jul 2004

I guess 3 dimensions is not too difficult :-

D1 - Rows

D2 - Columns

D3 - Sheets (duplicated multiple sheets with the same row/column layout. Totals sheet that totals down through the sheets - this could get to be a complex statement though.)

The remaining dimensions may need a little more creativeness.

  TomJerry 14:52 23 Jul 2004

it will be 30 something sheets, do not really facy that.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

Halloween Photoshop & Illustrator tutorials: 20 step-by-step guides to creating spook-tacular…

iPhone X news: Release date, price, new features & specs

Comment créer, modifier et réinitialiser un compte Apple ?