Recent content by James989

Thank you very much ! Cheers

I am looking for random numbers with decimal value.

My bad, just ignore Rnd. How to apply this RAND() directly into Excel Macro VBA codes ?

Rnd() in VBA only has a short period of 2^24

Hi, There are two types of random number generators (RNG) in MS EXCEL :- 1) Rnd ---- Please ignore this, because it is a flawed/bad RNG (https://www.montecarloexceladdin.com/mersenne-twister-pseudorandom-number-generator-algorithm ) 2) RAND() ----- May I know how to apply this RNG directly...

Please read this link : https://www.montecarloexceladdin.com/mersenne-twister-pseudorandom-number-generator-algorithm Rnd() in VBA only have period of 2^24 while Mersenne Twister have period of 2^19937 ! So Rnd() in VBA is NOT a good RNG.

Thanks for your reply However, I was told that Rnd() is a flawed RNG(No ?) and try to avoid it.

Hi, I am looking for high quality Random Number Generator(RNG) similar to Mersenne Twister as a comprehensive MS OFFICE EXCEL add-in, enable users to generate random number in Excel VBA for Monte Carlo simulations. One of the software that can meet this requirement is the Excel version of...

1) Yes. However, what important setting should I look into ? 2) While one next Excel-file macro is running, I try to open other excel file but failed( keep loading) 3) Yes, can open 2nd excel file alone and run macro of this 2nd file. Can you try to run macro of your own excel file? While...

Before this, I am able to open up to max 8 different file and run the macro of each file(I never use DoEvents) ! Off course, I open it one by one . . . However, after re-installation(due to computer problem) MS office 2016, I only can open 1 excel and run the macro, when try to open the second...

Hi, While running macro in a excel file, I tried to open another different excel file to do some other work, but this excel just kept loading and never opened successfully. . . .How to solve? I am using MS office Pro Plus 2016 on a machine with WINDOWS 7 64 bits. Regards James

Hi, I know that I can get solve the problem(less than 30s) by simulation BEFORE I posted here ! What I want is to run through the complete cycle for the case of card game( Not the Pi case !) so that I can get the EXACT answer.

You may need 70 days all less to run through the complete cycle. If you can separate a single workbook( iteration from 1 to r) to 5 workbooks for iterations from 1 to n, n+1 to m, m+1 to p, p+1 to q and q+1 to r, then run this 5 workbooks simulteneously, your total time may reduce to 70/5=14 days ?

why you need to hold all the outcome/results after each iteration in excel ? You can just sum it and only show the final results after 20 trillion iterations ! Am I missing something ?

1) Both wookbooks run simulteneously OR wookbook1 first and then follow by wookbook2 ? 2) why wookbook1 always runs twice ?