power4XL Microsoft Excel Resource Center
Free Macros, Formulas, Functions, Tutorials, Downloads, Add-Ins & More!

Modeling normal distributions with the Excel Monte Carlo VBA - SAT example #3 output

ShareThis

Finally, in the SAT example #3 the first section of output on the worksheet also appears identical to the previous example.

The difference is that the range from F35 through F53 here contains "countif()" formulas tallying the raw data.

 

 


Below this section of output is the "data dump" where the VBA code writes the entire contents of the data array to the worksheet.  Only a few rows are shown here; the number of actual rows of data in the worksheet is equal to the number of iterations the user has selected:

 

Prev | Contents | Next

Copyright notice:  This site and all content, including computer code and spreadsheet examples, are copyright 2006 by Fritz Dooley.  License is granted for individual users to download examples and to copy code directly into user's spreadsheets and Visual Basic for Applications files.  Users may not redistribute code in any way.  Providing hyperlinks to this web site is encouraged, but posting code and examples on other web sites is expressly forbidden.  "Microsoft" is a registered trademark of Microsoft Corporation.   Neither this web site nor Fritz Dooley is affiliated with Microsoft Corporation.