Quote:
Originally Posted by gd_barnes
I agree that the spreadsheet needs some sort of integration (calculus) so that it is accurate over a wide nrange. 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.