Worksheet Specifications
The following technical specifications for the worksheet include the number of cells allowed in the worksheet and the nature of the numbers allowed in the worksheet.
-
Maximum numeric precision: 15 digits (Counting the digits before and after the decimal place)
-
Maximum numeric resolution: 2.22E-16 (The smallest detectable difference between two numbers)
-
Maximum absolute value: 1.79769E+308 (The largest value that can be represented)
-
Minimum absolute value: 2.22507E-308 (The smallest value that is different from zero)
-
Double precision floating-point numbers can only represent approximately 15 significant decimal digits.
-
Approximate memory requirements for unformatted numeric data: 10.5 bytes per cell + 24 bytes per column
Example 1
10,000 rows of numbers in 3 columns
30,000 cells x 10.5 bytes/cell = 315,000 bytes (308 Kbytes)
3 columns x 24 bytes/column = 72 bytes
TOTAL MEMORY NEEDED (in addition to memory needed to run the program): 308 Kbytes
Example 2
3 rows of numbers in 10,000 columns
30,000 cells x 10.5 bytes/cell = 315,000 bytes (308 Kbytes)
10,000 columns x 24 bytes/column = 240,000 bytes (234 Kbytes)
TOTAL MEMORY NEEDED (in addition to memory needed to run the program): 542 Kbytes