Search results

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...

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...

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, .....and automatically run the macro in each file ? I have five different excel files and stored in :- c:\temp\file1.xls . . . c:\temp\file5.xls Regards James

Hi, I have created a macro :- For i = 1 To d Step 1 R = Rnd ^ 2 + Rnd ^ 2 If R <= 1 Then count = count + 1 End If Next My problem here is "d " is a very large number(billions) and it takes very long time to run this macro. It it possible to do...

Hi, Someone sent me this codes. Is it VBA codes ? Is it for random number generator ? Public i97, j97, u(97) As Double, c As Double, cd As Double, cm As Double, uni As Double Public Sub Init() Dim i, ii, j, k, ij, kl, l, m, jj, ivec, i5, j5, s As Double, t As Double ij = Seed1 kl = Seed2 i...

Hi , 1)I am using WINDOWS VISTA, M.S EXCEL 2007. I have installed an EXCEL Add-In program call EasyFitXL(from www.mathwave.com) to my computer. My VBA codes are as follow :- Sub Easy6() EasyFitXL.Randomize seed:=0 Rnum = EasyFitXL.UniformRand(0, 1) Range("a1").Value = Rnum End Sub...