Apr 042012

Version 6.0

Xnumbers v.6.0 for Excel 2010 (and earlier versions) is an extension of the the original xnumbers.xla v.5.6, still available from the website of Leonardo Volpi, the author of Xnumbers, at Foxes Team for Excel 2000/XP/2003:  It has many useful functions and the ability to calculate with up to 250 digits (the errors of standard “double precision” are sometimes intolerable).  It is a great Add-In!  If you have installed Office 2007 or 2010, spreadsheets might not calculate correctly with xnumbers.xla prior to v.5.6.3, as in some versions of Excel xPow(2,8) returned 128 instead of 256.  Currently undocumented on Leonardo’s website is that the download “v.5.6 Feb 2008” is actually “v.5.6.3 Sept 2008”, which has a fix for the “xPow bug”.  Even though his website warns that it does not support Excel 2007 or Vista, as far as I know the “xPow bug” was the only major problem.

My brother John, a highly skilled programmer, has extensively rewritten most of the code in Visual Basic.  Xnumbers v.6.0 is not only much faster but can now calculate up to 4030 digits, depending on the compiled version that you use.  It also has additional code to facilitate access to all of the functions from a Visual Basic Project, so that it can easily be used in the manner of xnumbers.dll.  Vista and Windows 7 are supported in all versions.  This newer version 6.0.5 has a few new functions, some bug fixes, and some great improvements for both speed & accuracy.  More detailed changes to all versions are documented in the included file XN60_review.txt

Note: due to a Windows security measure the .zip files that you download might be “Blocked”.  Before unzipping right-click the .zip, choose “Properties”, then in the “General” tab click “Unblock”, “Apply”, and “OK”.  Otherwise you might need to perform these steps on each individual file (especially .chm helpfiles).  If you are unsure whether you have 32-bit or 64-bit Office 2010, open Excel, go to the File Tab, select Help: on the right-hand side under About Microsoft Excel it will display your version number and either (32-bit) or (64-bit).

Packet size is digits per packet.

 Posted by at 9:38 pm

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>