Solved How To Add A 3rd Dimension To A Spreadsheet

April 6, 2019 at 20:38:05
Specs: several
I have used MS Excel in the dim, ancient past, and still have it
installed on my old Dell laptop running Windows 98 SE. On my
much newer HP laptop I have Open Office Calc, which I have
never used.

I'm looking for suggestions on how to get started, presumeably
using Open Office Calc.

I want to make a grid of 55 rows and 55 columns, with the same
headings on the rows and colums. Each cell needs to contain the
combination of the row heading and column heading concatenated
together, like this:

X    a   b   c   d
a   aa  ab  ac  ad
b   ba  bb  bc  bd
c   ca  cb  cc  cd
d   da  db  dc  dd

Some combinations might not be allowed. I would have to mark
those manually. Perhaps by making those cells a different color,
or by putting in a different character, or by making the cell empty.

Spreadheets like this are basically two-dimensional. Rows and
columns. Making cells different colors is sort of a third dimension.
How can I go farther with that, perhaps adding fourth, fifth, sixth,
or higher dimensions? For example, I'd like to click on a cell to
play a sound sample unique to that cell. Or maybe choose from
a list of 55 options for aaa, aab, aac, aad, and so forth.

Note that 55 x 55 = 3,025 cells, which is kind of a lot to populate
manually, but doable. On the other hand, 55 x 55 x 55 = 166,375,
which is way too many to do manually. That would require some
kind of automated filling of the cells.

-- Jeff, in Minneapolis

message edited by Jeff Root


See More: How To Add A 3rd Dimension To A Spreadsheet

Report •

✔ Best Answer
April 7, 2019 at 17:10:57
or...

Use Excel's built-in Camera tool and create 3D tables directly within Excel

https://alesandrab.wordpress.com/20...

message edited by DerbyDad03



#1
April 6, 2019 at 22:33:11
First, a posting tip:

First, when posting in a Help forum such as this, please try to use a Subject Line that tells us something about your question. If everyone used a generic Subject Line such as "Spreadsheet Question" we wouldn't be able to tell one question from another and the Archives would essentially be useless.

I have edited the subject line of your post to show you what I mean. Scan the list of questions in this forum to see the types of Subject Lines that others have used.

As for your questions...

re: "Note that 55 x 55 = 3,025 cells, which is kind of a lot to populate manually, but doable."

You should be able to create 1 formula and drag it to fill all of your cells. The following process works in Excel. I can't test it in Open Office, but the functions are available, so it should work.

1 - Enter your headings in Column A and Row 1.

2 - Place this in B2 and drag it to the right as far as you need. Then, with the Row 2 formulas still selected, drag it down:

=INDIRECT(ADDRESS(ROW(),1))&INDIRECT(ADDRESS(1,COLUMN()))

3 - Select All...Copy...Paste Special: Values (Excel version)

Your table should look like the one in your example.

You might even be able to use an IF formula to eliminate combinations that aren't allowed, but we couldn't help with that unless we knew the criteria.

re: "On the other hand, 55 x 55 x 55 = 166,375, which is way too many to do manually"

I don't get this one. How can you create a 55 x 55 x 55 table, since (as you already pointed out) a spreadsheet is only 2 dimensional?

re: "I'd like to click on a cell to play a sound sample unique to that cell"

This could probably be done with a Worksheet_SelectionChange macro, but I don't know how to write Open Office macros. I could probably figure it out in Excel VBA, but it wouldn't translate to Open Office because the coding language is completely different. You might need to do some Google searches on Open Office macros for help on this question. Just as an example, here is a page on playing wav files with Excel VBA.

https://en.wikibooks.org/wiki/Visua...


re: " Or maybe choose from a list of 55 options for aaa, aab, aac, aad, and so forth"

Open Office has a Drop Down feature as described here, as well as many other sites:

https://openoffice.blogs.com/openof...

So, it could certainly be done, but I'm not really sure where or how you want to use this option. Maybe some more details would help.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Report •

#2
April 7, 2019 at 06:41:29
Just a thought, but you could probably add a "3rd dimension" by duplicating Sheet 1 multiple times,
that should give you the illusion of 3 dimensions.

Working with all the data on multiple sheets is another matter.

MIKE

http://www.skeptic.com/


Report •

#3
April 7, 2019 at 11:00:35
There is a program called Teapot:

https://www.syntax-k.de/projekte/te...

an excerpt from it's web page states:

"Another interesting feature is its modern approach to spread sheet theory: It sports true three-dimensional tables and iterative expressions."

I have not used this software, but I was able to download & open it on my Win 7

The download was a 2012 version 2.3.0

It has a very minimalist appearance and several requirements that I do not
have on may computer, so I was only able to simply open the program.

But if you want 3D this might be something to look into.

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
April 7, 2019 at 17:10:57
✔ Best Answer
or...

Use Excel's built-in Camera tool and create 3D tables directly within Excel

https://alesandrab.wordpress.com/20...

message edited by DerbyDad03


Report •

#5
April 7, 2019 at 19:38:18
DerbyDad03,

Very Nice. ;-)

MIKE

http://www.skeptic.com/


Report •

Ask Question