[WEBINAR] The New Normal: Dealing with the Reality of an Unsecure World

3-D Spreadsheet

Definition - What does 3-D Spreadsheet mean?

A 3-D spreadsheet is a spreadsheet that has multiple interacting sheets and 3-D functions to carry out organization, analysis, computation and storage of data. The data are arranged in the form of a stack of tables of the same size and shape. A 3-D spreadsheet application allows users to analyze these data tables either individually or as groups. 3-D spreadsheets are used for tracking, compiling and formulating huge amounts of information as they allow multiple calculations to be executed on multiple worksheets easily.

A 3-D spreadsheet is also known as a multidimensional spreadsheet.

Techopedia explains 3-D Spreadsheet

A spreadsheet is organized as a table of rows and columns that enable users to store, organize and manipulate data. The information stored in each cell can be easily accessed with its row and column identifiers. Spreadsheet applications allow the use of formulas to automatically calculate values depending upon the information present in other cells. These formulas can be used to perform various operations from basic arithmetic operations to advanced financial and statistical calculations.

When a spreadsheet allows cross-referencing of cells from different worksheets, it is known as a 3-D spreadsheet. 3-D spreadsheets allow users to include cells from a different spreadsheet or worksheet to be included in a formula used in the current worksheet.

3D-Calc is one of the oldest 3-D spreadsheet applications and can handle up to 13 pages of 2048 rows and 256 columns with its cross-referencing feature.

Most of modern spreadsheet applications also provide cross-referencing functionality and are hence inherently 3-dimensional. Microsoft Excel and similar applications also provide certain 3-D functions that enable users to add an extra dimension to their spreadsheet application. Excel has a feature for making 3-D tables that can have data arranged according to three criteria. For example, one can show the business sales volume with respect to both country and year using a 3-D table.

Excel also allows the use of 3-D formulas where users are allowed to reference cells from other sheets. An example 3-D formula that implements the 3-dimensional scope of a spreadsheet application is:


Using 3-D functions enables users to effectively manage interrelated data and carry out complex calculations easily.

Techopedia Deals

Connect with us

Techopedia on Linkedin
Techopedia on Linkedin
"Techopedia" on Twitter

Sign up for Techopedia's Free Newsletter!

Email Newsletter

Join thousands of others with our weekly newsletter

Free Whitepaper: The Path to Hybrid Cloud
Free Whitepaper: The Path to Hybrid Cloud:
The Path to Hybrid Cloud: Intelligent Bursting To Amazon Web Services & Microsoft Azure
Free E-Book: Public Cloud Guide
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.