# 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 itinstalled on my old Dell laptop running Windows 98 SE. On mymuch newer HP laptop I have Open Office Calc, which I havenever used. I'm looking for suggestions on how to get started, presumeablyusing Open Office Calc. I want to make a grid of 55 rows and 55 columns, with the sameheadings on the rows and colums. Each cell needs to contain thecombination of the row heading and column heading concatenatedtogether, 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 markthose 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 andcolumns. 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 toplay a sound sample unique to that cell. Or maybe choose froma 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 populatemanually, but doable. On the other hand, 55 x 55 x 55 = 166,375,which is way too many to do manually. That would require somekind 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

April 7, 2019 at 17:10:57
 or...Use Excel's built-in Camera tool and create 3D tables directly within Excelmessage edited by DerbyDad03

#1
April 6, 2019 at 22:33:11

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.MIKEhttp://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 7The download was a 2012 version 2.3.0It has a very minimalist appearance and several requirements that I do nothave 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. MIKEhttp://www.skeptic.com/

Report •

Related Solutions

#4
April 7, 2019 at 17:10:57