View Single Post
Old 2013-09-30, 15:12   #11
Account Deleted
Mini-Geek's Avatar
"Tim Sorbera"
Aug 2006
San Antonio, TX USA

3×1,423 Posts

Originally Posted by gd_barnes View Post
I agree that the spreadsheet needs some sort of integration (calculus) so that it is accurate over a wide n-range. I wouldn't begin to claim to now how that might be done, especially in Excel. The spreadsheet was originally designed for a large range of k with millions of candidates over a small range of n. For that it is highly accurate. Even with nmax/nmin = 2, it's not too far off.
Another option is my calcPrimes jar. It uses the math behind the spreadsheet, along with simple arithmetic going through each number in the given input file. It should be highly accurate.
Mini-Geek is offline   Reply With Quote