© 2019 by Mining Solutions Pty Ltd. ABN 13 085 754 114

Excel Development

Mining Solution's Founder, Ian Huitson, is a Mining Engineer by trade who throughout his career has developed high level Excel skills.

Ian participates in the Global Excel community in developing other peoples skills and problem solving.

Ian has been recognized by Microsoft by the award of the Most Valuable Professional (MVP-Excel).

The MVP (Excel) is a prestigious award recognized throughout the world and only held  by 4 people in Australia. Ian is the only Mining Engineer in the world to hold the award.

Ian has held the award continuously since first receiving it in 2013.

Ian publishes his Excel work at Chandoo.org.

You can see a library of Ian's Excel work here: Chandoo.org - About Hui

Some of Ian's notable Excel projects are displayed below:

Scheduling Basic 

Matrix Approach

You have a list of resources, that need to be accounted for in a First In - First Out basis. You need to report a property associated with the scheduled parcels properties.

 

This model achieves that allowing you to vary the usage per period and see what impact the change has on the output.

Excel Level - Basic

Requires VBA - No

Scheduling Advanced

Single formula

This model achieves the same as the above model except completes it using a single formula.

Four alternatives solutions are offered

 

Excel Level - Advanced

Requires VBA - No

Financial Modelling

Financial Models developed by Mining Solutions between 2015 and 2018 have assisted Australian Mining Companies to raise over A$80M as well as advance resource development programs from Scoping Study to PFS level studies and beyond.

Models include:

  • Multiple Scenario Analysis & Reporting

  • Sensitivity Analysis

  • Montecarlo Simulation

  • Torpedo and Waterfall Reporting

Excel Level - Medium

Requires VBA - No

FinMod1.png
FinMod2.png

Click on the images to the right for more detail

Download samples not available

Iterative Functions

Calculate the Mandelbrot Set in Excel

 (Without VBA !)

The mandelbrot set is the display of contours of the count of escape orbits from the solution to the complex formula Z^2 = Z^2 + 1

This requires 3 levels of iteration to achieve a solution.

Mining Solutions principle Ian Huitson solved this conundrum in 2003 with Hui's Excel Mandelbrot.

This was recognized in John Walkenbach's Excel 2007 Bible

Excel Level - Medium

Requires VBA - No

Simulations

Calculate Pi by Throwing Hotdogs !

Did you know you can calculate Pi, The ratio of a Circles Circumfrence to its Diameter, by throwing Hot Dogs?

Mining Solutions loves simulations and we can simulate just about anything, even Pi.

Excel Level - Medium

Requires VBA - Yes

Download sample file

Click on link and Save file, do not open

Change the downloaded file name to:

Calculate Pi by throwing Hotdogs.xlsm

Huis-Excel-Mandelbrot.png
Calculate Pi by Throwing Hotdogs

Download sample file

Click on link and Save file, do not open

Change the downloaded file name to

Huis-3D-Dancing-Pendulum.xlsm

To understand how this was made: Click here

Watch real pendulums swing hypnotically, then watch the simulation developed by Mining Solutions

Excel Level - Advanced

Requires VBA - Yes, Simple code for animation purposes only

Simulation & Animation

3D Dancing Pendulums

Huis-3D-Excel-Pendulums.gif

Extreme Excel

Hui's World

Hui's World is an extreme Excel solution and took 10+ years to develop. Ten years was thinking about the problem and about 20 hours was approximately how long it took to implement.

This is an extreme example of what can be achieved in Excel.

The Model is a single Excel X-Y Scatter Chart containing 111 Series. The series are driven by over 380 Named Formula about a quarter of which are Arrays of Latitude and Longitudes for the approximately 2,550 data points defining the countries of the globe. The remainder contain transformation calculations to shift the data to an X/Y Grid, Hide data when it is behind the earth and allow display of annotation.

Excel Level - Extreme

Requires VBA - Yes, Simple code for animation purposes only

Download sample file

Click on link and Save file, do not open

Change the downloaded file name to Huis-World.xlsm

To understand how this was made: Click here

Huis World.gif

Have you ever said "I wish I could do ... in Excel ? "

Contact Mining Solutions to ask us How