ALERT

[FREE DEMO] Deploy Your Enterprise Cloud in Minutes

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:

=SUM(Sheet:Sheet3!B2)

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
Tweat cdn.techopedia.com
"Techopedia" on Twitter


'@Techopedia'
Sign up for Techopedia's Free Newsletter!

Email Newsletter

Join thousands of others with our weekly newsletter

Resources
The 4th Era of IT Infrastructure: Superconverged Systems
The 4th Era of IT Infrastructure: Superconverged Systems:
Learn the benefits and limitations of the 3 generations of IT infrastructure – siloed, converged and hyperconverged – and discover how the 4th...
Approaches and Benefits of Network Virtualization
Approaches and Benefits of Network Virtualization:
Businesses today aspire to achieve a software-defined datacenter (SDDC) to enhance business agility and reduce operational complexity. However, the...
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.