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

  TomJerry 14:10 23 Jul 04
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 04

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 04

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

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

New Google phones UK release date | Pixel XL price, new features, specifications: Pixel X and…

1995-2015: How technology has changed the world in 20 years

iOS 10 troubleshooting tips: Simple fixes for the most common iOS 10 problems, from network…