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 number of rows in a worksheet: 1 billion

Maximum number of columns in a worksheet: 1 billion

Approximate memory requirements (for unformatted numeric data): 10.5 bytes per cell + 24 bytes per column

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)

Example: 10,000 rows of numbers in three 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: three 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