Forum Discussion
Matrix with Three Axes
If all you require is to collect data then a common practice is simply to repeat the block of data.
The spreadsheet is probably better than any other software for representing such data.
It gets complicated if you want to perform calculations based upon data held in such formats. The methods I showed were aimed at supporting such calculation and demonstrated new functionality emerging within Excel 365.
The other strategy for storing data is to place it within a single column and then add fields to describe the remaining attributes. Such database tables form a good basis for subsequent calculation.
Hello there Jan,
I've attached a model for what I'm trying to develope.
Actually it's the first TWO dimensions of a 3D matrix I'd like to create.
You will see I've created sort of an X and Y axis in the spread sheet.
I use the gray cells to allow me to put an "X" wherever there is an intersection between items on each axis.
What is missing is the third axis. I need a way to be able to identify a third set of items -- and then be able to put an "X" where those items on the 3rd axis intersect with axis 1 and axis 2.
I don't now if this is possible.
>> Please share your thoughts. OR... another tool other than Excel ???
thanks.
