Which Program Can Calculate 100-Digit Numbers with High Precision?

Click For Summary

Discussion Overview

The discussion revolves around finding a software program capable of calculating 100-digit numbers with high precision, specifically to 20-30 decimal places. Participants explore various options, including spreadsheet applications and plugins, while addressing limitations and features of the suggested tools.

Discussion Character

  • Exploratory, Technical explanation, Debate/contested

Main Points Raised

  • One participant inquires about spreadsheet programs that can handle 100-digit numbers with high precision.
  • Another participant provides links to several software options, including both free and paid versions, suggesting they may be suitable for arbitrary precision calculations.
  • A participant expresses concern that the recommended Excel plugins do not support very large numbers, prompting a challenge regarding the documentation of these limitations.
  • One participant mentions the limitations of the free version of a suggested program, noting the requirement for a confirmation code for each calculation, which may not be practical.
  • A question is raised about whether the solution must specifically be a spreadsheet application.
  • A suggestion is made to consider a program called XNUMBERS as an alternative option.

Areas of Agreement / Disagreement

Participants do not reach a consensus on the capabilities of the suggested software, with some asserting that certain tools can handle large numbers while others express skepticism about their effectiveness.

Contextual Notes

There are unresolved questions regarding the specific capabilities of the software mentioned, particularly in relation to handling very large numbers and the practical limitations of free versions.

Who May Find This Useful

This discussion may be of interest to individuals seeking software solutions for high-precision calculations, particularly in mathematical or scientific contexts.

physuser
Messages
3
Reaction score
0
Hi.

Does anyone know a spreadysheet type of a program that can calculate 100 digit numbers to 20-30 decimal places?
 
Physics news on Phys.org
Thank you I'll try moving it to the software section.

The excel plugins that you recomended do not handle very large numers.
 
physuser said:
The excel plugins that you recomended do not handle very large numers.

?

Scraped directly from the web pages I gave you:

"Numerate Pro allows full arbitrary precision calculations in any cell simply by setting the desired precision."

"If you're a programmer, you can also call xlPrecision's arbitrary-precision (bignum, multi-precision) arithmetic library functions directly from your own programming code."

"Recent Features
Arbitrary precision integer functions.
Arbitrary precision floating-point functions."

Where are you finding it documented that these do not handle "very large numbers"?
 
I looked at the example on the front page. But it seems that you can get 2,147,483,648 digits which is great. But its a paid version. And for the free version you have to get a confirmation code for every calculation. That would not work for me.

I tried to look for the Math&Science Software section on this forum but could not find it.
 
Does it have to be a spreadsheet?
 

Similar threads

  • · Replies 3 ·
Replies
3
Views
3K
  • · Replies 6 ·
Replies
6
Views
962
  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 4 ·
Replies
4
Views
2K
  • · Replies 4 ·
Replies
4
Views
3K
  • · Replies 10 ·
Replies
10
Views
2K
  • · Replies 12 ·
Replies
12
Views
3K
  • · Replies 11 ·
Replies
11
Views
3K
Replies
4
Views
2K
  • · Replies 28 ·
Replies
28
Views
3K