help on creating a 3 dimensional database in excel

[premPro]

Hi Guys,

I am trying to create an excek sheet which can hold the data for all the US states along with different labor laws which in turn contains different sub data fields.

Ex : State - Alabama

Wages & Hours Worked - > Sub menu is - Min Wage & Overtime Pay

I created all the states as Column fields, Row field - Wages & Hiours Worked - Sub Row Field - Min Wage & Overtime Pay.

Any advice on this is of great help please!

 

[xld]

It is not clear to me from this post what the question is.


You say that you have created the data and its structure, so what do you actually need?

 

[premPro]

Thanks for the reply xld.

My question is : how do I create a 3 dimensional data using Excel? Or what I am creating is already a 3D data?

 

[premPro]

Hi Xld,


Thank you for the reply.

My question is : how do we create a 3 dimensional data in excel? Or the one which I am creating is already a 3 dimensional? Please advice

 

[premPro]

Hi Xld,


Thank you for the reply.

My question is : how do we create a 3 dimensional data in excel? Or the one which I am creating is already a 3 dimensional? Please advice

 

[xld]

Normally, I create 3D data as separate tables.


For example a customer table


CusNum.......CustomerName

1............Company A

2............Company B

etc.


a Product table

ProductNum...ProductName...Price

1............Widget A......12.29

2............Gizmo B.......2.39

etc.


and a sales table


SalesNum...CusNum....ProductNum...Qty...InvoiceDate...PaymentDate

1..........1.........1............3.....12-Dec-2010...null

2..........1.........2............12....08-Aug-2010...12-Sep-2010

3..........2.........2............75....12-Nov-2010...null

4..........2.........2............75....01-Dec-2010...null

etc.


Of course, it can get much more complex, but this is the basics

 

[dan_l]

Clearly this is not possible because Alabama has not yet pass labor laws.


I kid.


Have you thought about about Access?