Skip to content

NtRand Ver 3.3.0

Latest

Choose a tag to compare

@siawkz siawkz released this 10 Aug 04:20
cf31840

NtRand 3.3 supports Excel 97 – 2016 running on the Windows XP or later operating system in any language version.

NtRand 32bit supports Excel 97 – 2016 running on the Windows 95 or later operating system in any language version. NtRand 32bit is also designed to be operated in Excel 5.0 on 95/98, but the correct operation is not verified in this environment.
And sample sheets are not for Excel 5.0.

With regard to the Excel function, the maximum number of data passable at one time is limited to 32,767 records (both in row and column directions) for an array formula, or to 32,767 records (in row) and 256 records (in column) as a general expression.
In Windows 95/98, the 16-bit limitation in addition to the above restrictions restrains the maximum passable data size at one time to 64 KB. So, the Excel’s standard “Numeric” type (double-precision floating-point number) data cannot be transferred more than 8,192 records.
Thus, the 32-bit Windows NT/2000/XP operating system is recommended for a higher dimension multivariate Monte Carlo with NtRand 32bit.
Basically, these limitations are caused from the Excel and Windows, and not by NtRand 32bit.

Excel 2007 or later can treat more than 32,767 records.