<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><b>From:</b> extropy-chat [mailto:extropy-chat-bounces@lists.extropy.org] <b>On Behalf Of </b>John Clark<br><b>…</b><br><b>Subject:</b> Re: [ExI] isaac's number<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal><span style='font-family:"Arial",sans-serif'>On Wed, Aug 2, 2017 at 12:04 PM, spike <<a href="mailto:spike66@att.net" target="_blank">spike66@att.net</a>> wrote:<o:p></o:p></span></p></div><div><div><p class=MsoNormal><o:p> </o:p></p></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in'><div><p class=MsoNormal><span style='font-size:14.0pt;font-family:"Arial",sans-serif'>> >…</span><span style='font-size:14.0pt'>I don’t know John. I need to learn up on this, figure out how the rand() function works in VBA. </span><span style='font-size:14.0pt;font-family:"Arial",sans-serif'><o:p></o:p></span></p></div></blockquote><div><p class=MsoNormal><span style='font-size:14.0pt'><o:p> </o:p></span></p></div><div><div><p class=MsoNormal><span style='font-size:14.0pt'><o:p></o:p></span></p></div><p class=MsoNormal><span style='font-size:14.0pt'>>…You got me curious so I looked it up, it's 32 bit pseudorandom<o:p></o:p></span></p><div><p class=MsoNormal><span style='font-size:14.0pt'> <o:p></o:p></span></p></div><p class=MsoNormal><span style='font-size:14.0pt'>Generator is called called "MT19937"…<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:14.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:14.0pt'>Cool thanks for that.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:14.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:14.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:14.0pt'>>… super long period of 2^19937 -1 (a Mersenne prime)…<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:14.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:14.0pt'>That comment was worth the price of admission. I recall hearing of the discovery of that Mersenne prime, way back when I was in fifth grade. I was just then learning about Mersenne primes. It made the Scholastic News for breaking the record for the largest known prime number. I was in college before that record was broken.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:14.0pt'><o:p> </o:p></span></p><div><p class=MsoNormal><span style='font-size:14.0pt'>… <o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:14.0pt'><o:p></o:p></span></p></div><p class=MsoNormal><span style='font-size:14.0pt'>>…through even a simple hash function will greatly improve it, although of course that would also slow things down. John K Clark<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:14.0pt'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:14.0pt'>I have used the Excel VBA random function since macros first appeared, which was in 1993. That too brings back fond memories, for I recall hearing that a new embedded language was coming with the new Excel 5.0, which was much more practical than the previous macro code. If you were a geek back in those days, you may recall before 1993, instruction sets resided in a worksheet. The code didn’t care if you modified that sheet. So you could write self-modifying code. That was kinda cool for some applications, but it made for extremely brittle code that could run perfectly for months, then suddenly stop working, and the programmer could never figure out what broke on it, regardless of how geeky he was.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:14.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:14.0pt'>I wrote and ran a ton of Monte Carlo sims in those days. One of them was a rocket ascent program which I think Keith Henson still has and might still use.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:14.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:14.0pt'>Heh.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:14.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:14.0pt'>Things got better. They got waaaay better.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:14.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:14.0pt'>spike<o:p></o:p></span></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div></div></div></div></body></html>