Monte Carlo Simulation Excel

If you are looking for a FREE excel calculator to perform Monte Carlo Simulations you have arrived at the right place. Just download my FREE Excel Monte Carlo Simulator and start doing Monte Carlo simulations right in your already familiar Excel Environment.  I will provide a short intro below, but feel free to download my Excel Monte Carlo Simulator to get started right away.

If you are searching the Word Wide Web for “Monte Carlo Excel” you probably already know or have a general idea of how Monte Carlo Simulations work. The user typically has one or more variables with known probability distributions as well as a transfer function (basically an equation) to translate these input variables into the desired output variable. The goal in a Monte Carlo Simulation is to randomly retrieve a value for each of the input variables according to their probability distribution. Do this over and over multiple times (1k, 100k, 500k, 1 million times, and so on) and you can now understand what your output distribution (and statistics) will look like in the limit as the number of iterations go to infinity.

Monte Carlo Simulations can be performed in a number of different software tools including Python, R, MATLAB, JMP, and many more. However, from my engineering experience, there is a broad audience of Excel users who would like to do this right within the familiar excel environment and without the need to code.  It is for this reason that I created my Free Excel Monte Carlo Simulator. This is a simple to use Excel Workbook where the user can perform Monte Carlo Simulations and use the results in any way they wish within Excel.

Disclaimer:

Every time a user runs a simulation using my Free Excel Monte Carlo Simulator, this website will open in their browser. I have done this to help support the development of tools just like this. However, if you would prefer for this not to occur, I have also included a for-purchase version here that will not open this website upon performing a simulation.

For Purchase:

https://gumroad.com/l/ZOzQL

Free:

https://onedrive.live.com/?id=B6BC22119A0A836B%21110&cid=B6BC22119A0A836B

Probability Calculator

Quick, Easy, and Simple to use Probability Calculator.

Step 1: Select your probability distribution

Step 2: Type in the required information

Step 3: Read the desired probability

 

All probability options are explicitly computed so there is no need to perform calculations, which could lead to silly mistakes. Simply read your answer off the chart.

Over 20 commonly use probability distribution functions are included:

Discrete Data	Continuous Data	Continuous Data (Inverse)
-Binomial	-Normal	-Inverse Normal
-Critical Binomial	-Standard Normal	-Inverse Standard Normal
-Negative Binomial	-Beta	-Inverse LogNormal
-Poisson	-Exponential	-Inverse Beta
-Hypergeometric	-Gamma	-Inverse Chi-Squared
-Uniform	-Chi-Squared	-Inverse F
	-F	-Inverse Student’s t
	-Student’s t
	-Uniform
	-Weibull

Runs on familiar Microsoft Excel environment

The probability calculator is recommended for:

• Students
• Technical professionals
• Six Sigma practitioners
• Data driven individuals
• Decision makers

Click here to download…

User must have Excel 2007 or higher to use this software.

Disclaimer: The author is not responsible for, and expressly disclaims all liability for, damages of any kind arising out of use, reference to, or reliance on any information provided by this calculator. While the information contained and provided by the calculator is believed to be correct, no guarantee is given that the information provided is correct, complete, and up-to-date.

Speed Test Windows 8

I just downloaded Network Speed Test for Windows 8. This free app brought to us by Microsoft Research, allow us to test the download, upload, and the network delay of the current internet connection. This app is very easy to use, and it has a great design. The app also keeps a result history for easy network speed comparisons over time.

This app is also available for Windows Phone.

Android Studio

A few days ago Google announced the release of Android Studio, an integrated development environment (IDE) for android. The software is intended to provide developers the tools needed for app development and debugging. I did have a chance to use the software and so far, it seems like a great tool. Here are some shots:

Accelerometer App for Android

Here is a great free app for android users. Accelerometer Monitor is an  android app that uses the accelerometer sensor in your smart phone to generate a plot of acceleration vs. time. Since smart phones have a 3-axis accelerometer, the app provides you with 3 components of acceleration (x, y, and z direction). I have been using this app for measuring vibrations for a few days and it works great. In my phone, the app collects data at a rate of approximately 15 Hz (although the sampling rate is not constant and it varies slightly from point to point).

A very useful feature is that this app allows you to save the data directly to the SD card memory in the phone inside a folder named “accData”.  In addition to the 3 components of acceleration and a differential time stamp at each data point, the saved data contains information about the starting and ending date and time, the resolution of your accelerometer sensor, the type of accelerometer sensor, and the range of the sensor. For example, in my phone, the resolution of my sensor is 0.01197 m/s^2 and acceleration range is +/-19.6 m/s^2.

You can  use your favorite data processing software to extract and visualize your data after extracting the file from your phone. For example, here is a Microsoft Office Excel plot of a set of data that I took after shaking my phone by hand in x (left to right), then y (forward and backward), and finally z (up and down) directions.

This app seems to be in Google Play under two different names since there is another identical app named Vibration Monitoring. Both of these apps are made by Mobile Tools.

As mentioned in the overview section of these apps, uses for the app includes:

“-shows vibrations in real time
- saves vibration data into SD card (*zip file also supported)
- provides configurable sound alarm that may be used to:
- detect the earthquakes when you sleep
- detect if somebody opens the door when you sleep“

Very useful app. If you have need for such a measurement, I recommend you check this app out.

ForceEffect for Android

A while back I wrote a post about an app called ForceEffect by Autodesk. This very useful app is now available for android on Google Play. Give it a try and see what you think. If you find it useful, also check out ForceEffect Motion.

 

Keep up the good work Autodesk!

EveryCircuit on Google Play

Here is a very useful android app for designing and simulating electronic circuits. This app provides a dynamic animation of voltage, current, and charge which makes the design of electronic circuits easy, intuitive, and fun! Take a look  and see what you think.

Earth Now

Check out this free iphone app developed by JPL (NASA) which gives you instant access to near-real-time global data from NASA’s Earth science satellites. Click on the image below and start discovering the key vital signs of our planet Earth.

 

Currently, available data includes Air Temperature, Carbon Dioxide, Carbon Monoxide, Gravity Field, Ozone, Sea Level, and Water Vapor.

10 iPad Apps for Engineers by ASME

Here are some cool and useful iPad apps for engineers. Click on the image below and see what you think.

ForceEffect By Autodesk

Here is another great app for your Iphone, Ipod Touch, or Ipad. ForceEffect is a FREE application developed by Autodesk that performs static force calculations (Yes, free-body-diagrams included).

This application is great for engineers at all levels (and architects too!). A static problem carried out by hand can take a significant amount of time. For instance, look at the following example:

While the same problem can be solved using ForceEffect in seconds, check it out:

It even gives you a report with the result summary:

 

Great app, I highly recommend it, good for checking your homework and brainstorming ideas for new design concepts.

Maple Player for iPad

Here is a great app for your iPad. Maple Player for iPad is a FREE app that allows viewing and interacting with documents created on desktop Maple. This app basically brings the power of Maple computing to your mobile device. At this moment, the available documents in the app are somewhat limited and restricted to only those provided by Maple Player. However, the possibilities in the future could be endless especially if you could develop and use your own desktop Maple documents on your mobile device. Great work MapleSoft.

Give this app a try. In the mean time, I would like to see this app open for user defined documents as well as availability for the android systems. I wonder if we will be seeing something similar from MathWorks to bring MATLAB computing to the mobile market.