Mzamose Holdings (Pty) Ltd | Modelling and Simulations Servicess

Modern Charts

Our Modern Charts

It is not always easy to explain one simple set of data to people for them to fully understand by just using an Excel/PowerPoint chart. Sometimes it may need few charts and even some narration and it takes a long time to develop those. don’t worry about developing all those. For that, you have Modern Charts!

                        A Microsoft Office charting add-in to help you present your data better and effectively. Modern Charts allows you to show ONE set of data in FOUR different perspectives, i.e.

                        Overall Sum/Average; 
Summarised by Data Series; 
Summarised along axis; and
The actual detailed data (with average lines, % change between to points, etc).


                        These perspective and interactions with data, allows you have more effective presentations of your data, so your audience can quickly have a comprehensive understanding of what the data says. If better understanding of what data says is attained better decisions are made and made quickly.
                        Modern Charts is the only Office add-in that can allow you to show the properties and messages about your data and if very easy to use.


Key Features:Presents ONE set of data in FOUR different perspectives;
Professionally designed charts and visualizations;
Pre-designed and easily customizable layouts;
Narration; and
Transpose data on chart.

Activity Timer

If you wanted to time how long it take to complete certain activities in place of work, at home or during outdoor events, you would usually need a STOPWATCH and a PAPER to record the activities and times. If you wanted to do process that data, you will have to CAPTURE them in a computer (in Excel). That process may take be cumbersome and time consuming, but don’t worry, Activity Timer Excel add-in is here!

Activity Timer is a Microsoft Office add-in that us a STOPWATCH + PAPER + CAPTURING all in ONE.

Key Activities

Add and many activities as you want;

Records same activity times as many times as you want;

Automated average calculated for all time recorded per activity; and

Paste data inside Excel sheet with 1-click of a button;

Lease balance

The International Financial Reporting Standard (IFRS 16) was introduced in 2016 and a lot of companies would require adapting the standard on annual reporting periods beginning on or after 1 January 2019. IFRS 16 specifies how an IFRS reporter will recognise, measure, present and disclose leases. The standard provides a single lessee accounting model, requiring lessees to recognise assets and liabilities for all leases unless the lease term is 12 months or less or the underlying asset has a low value. Lessors continue to classify leases as operating or finance, with IFRS 16’s approach to lessor accounting substantially unchanged from its predecessor, IAS 17.

Balance allows companies to capture all relevant leases and calculates Monthly liability and asset values while leases are active. Lease Liability value is recognizable when a company has large number of leases with different start and end dates, that its impossible for accountants to do them manually. This tool is mainly directed for use of the LESSEE.

Key Features:Can easily set to integrate with SAP;
Can be set for Monthly, Quarterly and Annual liability and asset calculation;
Global settings of escalations, interest rate and VAT treatment;
Liability and Asset adjustment when dates and interest rate changes; and
Shows historical movements of liability and asset.

Systematic Rail

Have you ever wondered how much of your current operational challenges has been affected by previous operational decision you made? How much decisions you make today will solve or create other problems in the future? If you are running a complex enough operation, it is very difficult to calculate impact of decisions made today to tomorrow’s challenges. Therefore we created SystematicRail decision assist solution!

SystematicRail is a design to assist operations managers in a rail environment to have an improved quality of operational decisions made. SystematicRail take current state and location of assets and predict, on a rolling 7 days, impact of operational decisions made today. An operational manager can run different decisions scenarios in order to choose best decision to make today. This tool runs algorithms to show an operations manager what is the likely impact the decision made today solves a problem today and also in the future.

Key Features:

Operational Status hourly for next 24 hours;

Marshalling yards utilization per hour;

Train movements diagram per day;

“Bird’s Eye view” of state of operation per hour; and

Future production prediction rolling 7-days.

Modern Charts Excel add-in (on market)

Modern Charts is an innovative Microsoft® Excel® add-in for creating professional and rich data visualizations. The add-in has an ability to blend chart types in a way that helps users explain their data better to their audiences. Modern Charts classifies charts types that are great for detailed data presentation and the ones that are great for summarised data presentation and allows users to create a combination of both to create storytelling data visualizations in seconds. These charts are plotted on different presentation layouts based on personal preferences and also the density of data being plotted.

Modern Charts employs the power of web applications technology and cloud computing to give users an ability to prepare the best data presentations at minimum possible time. This is a new and convenient way of creating data stories for presentations using normal data in Microsoft® Excel® spreadsheets. Using modern Charts saves time and as a result, saves money.

Consulting Services

If you need large mathematical models for your planning needs, Mzamose has over 10 years’ experience the mathematical modelling and prediction models. Mzamose consults in the following modelling fields:

Operations Simulations;

Future capacity predictions;

Scheduling;

Mixed Integer and Linear Programming;

Activity Based staffing and costing models; and

Forex and Derivatives forecasting (Technical Analysis and Autoregressive models)

We can assist you in either developing models from stretch or assist you in modernizing and updating your existing models. We have also worked in partnerships with major players in the management consulting fields such as McKinsey and Company and Deloitte.