Tangential Ramblings | a^2=n(n+x)+y

Thursday 21 October, 2004

a^2=n(n+x)+y

In response to Ms. Scott's conundrum in the earlier post Prime factorisations, I've created a spreadsheet that does this for you. It's not iterative (so I've taken it up to values of n up to around 12,000). It'd need some macros to automate it. Also, not sure how Excel deals with very big numbers (I think it starts rounding them) so not sure if Excel's the best tool for this.

Enjoy...

Posted by dan at 8:01am | Permalink | Comments (2) | Trackbacks (0)

Comments

You are correct, Excel does tend to do rounding with big/small numbers. BTW - FX calculations involving Turkish Lira to eight decimal places (trading system) is how I discovered this!

Posted by Simon, 12:40pm, Thursday 21 October 2004

Just to save confusion, I'm sure this comment is from Simon E. as opposed to Simon B., unless Simon B. has changed somewhat...

Posted by Dan, 1:25pm, Thursday 21 October 2004

Add comment (all comments are currently moderated)

Your name*
Your web page (if any)
Enter the confirmation code*