From Blast Holes to the Board Room.
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
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
Click on link and Save file, do not open
Change the downloaded file name to:
Calculate Pi by throwing Hotdogs.xlsm
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
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
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
