Bespoke Solutions

Need a Custom Solution?

You haven't been able to find an off-the-shelf solution for your requirement although you have all the data inputs you need and you know the business logic that needs to be followed.  Sometimes a bespoke solution is required and we at Analytical Models have extensive experience developing solutions where one did not previously exist.  We deliver exceptional results.  Trusted by businesses for decades, we can help you create the specific solution needed by your business.

How We Do It

Firstly, if you would like us to sign any confidentiality agreement we are more than happy to do so.  We handle your data and information extremely carefully and confidentially.

Once we have access to your data we then collate all the relevant data sources and make sure that these are structured in a way so that this data can either be easily appended to or refreshed, paying particular attention to how the data sources may change over time.  From this we can start to identify all the business drivers and organise these business drivers into categories.  These will be the assumptions driving the spreadsheet model.

We then would ask you about how you see that the spreadsheet model might be expanded in the future.  Knowing how the model might evolve allows us to consider how these dimensions can be expanded in our design.

Of course, if you have an existing spreadsheet model we can certainly also work with that.  If new components are needed they might be added in the manner described here.  However, if there are existing templates/conventions we will work with those - whatever makes the most sense.  If there are different options available we will discuss these with you highlighting the pros and cons of each option.

We then start to prepare the formulae that extract information, depending on how the information is structured and what we need to extract, we may use pivot tables or we may use Excel formulae to drive the calculations in the spreadsheet model.  Named ranges are set up with our hierarchical naming structure which makes the formulae far easier to read and to know from where the inputs are coming.  If appropriate we will use array formulae which acts as a safeguard against accidentally editing a formulae whilst also reducing the size of the spreadsheet model.

All changes made to the spreadsheet model are documented in our version control process so that we know what changes were made when and by whom.  Where possible we will validate the spreadsheet models accuracy using existing data sets so we can be confident in the results as well as doing sanity checks throughout the model.  We typically share the development of the spreadsheet model with our client as it is being built to make sure nothing has been missed and that methodology we are following is sound.  Development of these models is a very rapid process, usually completed in 6-12 weeks.

Our spreadsheet models are typically structured so that we can run sensitivities if required and to allow for future enhancements or developments.  When working with other team members we set up interface contracts at the start of the project so that the models can be quickly integrated.

Lastly, we document how the model works, how it is run and how it can be updated so that anyone else can pick up the model and use it.  Whenever we do any modelling work, the results of that modelling work belong to you.  You have full access to all the worksheets and code, if any is required.  We do not retain any intellectual property rights on what we build for you.

Many of our models continue to be used by the business for years to come which attests to their robust design and ongoing relevance to the business.

What Our Customers Are Saying

Andrew has been my Mr Fix it guy. Strongly recommend him for any analytical task whether big or small. He is honest and upfront with his time frames and capabilities. Will continue to use him moving forward as he is so reliable and delivers a quality outcome everytime.

Crichton & Associates Sam Crichton - Director

We had need for the use of some unusual charting for a presentation. I contacted Analytical Models . Their response was economical, service quick and the result was exactly what we wanted. We will use Analytical Models again.

Lenity Australia Geoff Henry - Chairman

A large client had a requirement for us to come up with a means of positioning mass on a large, high-capacity materials handling system. Which required a macro enabled excel spreadsheet that was both dynamic and that provided accurate output data which would then enable a task to be completed safely. After months of searching we found that Analytical Models, were the only company who could deliver a program that was suitable.

Highly recommend Andrew and his team, as being technically proficient, professional and able to adapt to changes in project scope seamlessly.

4B Australia (4B Group) Paul Dennis - Managing Director

Working with Andrew and his team at Analytical Models has been an exceptional experience. Andrew was patient, highly capable, and consistently available throughout the entire project. His commitment to the success of our work was evident at every stage — he kept strictly within the project brief and budget while delivering outstanding results.

Even when faced with a challenging assignment that involved managing and integrating a large volume of data from multiple sources, Andrew approached each task with professionalism and precision. His ability to translate complex data into clear, actionable insights was impressive.

Andrew’s team became an integral part of our own, working collaboratively and seamlessly to achieve our objectives. I would not hesitate to recommend Andrew and Analytical Models to anyone seeking a reliable, skilled, and solutions-focused partner.

Intertek Benjamin Rieck - General Manager

Andrew was extremely professional and is very proficient in excel development. Andrew helped us improve and develop out automations for our businesses pricelists and offered fantastic suggestions for improvements. Andrew was quick and efficient.

Master Pacific Patrick Carosella - Head of Product

I went to Andrew to gain assistance with making improvements to a few internal spreadsheets we use for various reporting and sales tracking requirements.

After a short discussion, Andrew went away to consolidate my information and put together a plan for us to focus on.

We decided to work on improving one document first, to see how we liked working together and if he was meeting the goal. Andrew was able to provide an improved and more efficient sheet for me to implement in our business, which was easy to understand and most importantly simple to update and interact with for the many people using it.

This has been a tremendous help, as my own excel skills are limited, and time constraints even more so.
We are now looking into the other sheets, and how Andrew can continue to help. Very happy with the input of time and the output of results.

The Grifter Brewing Company Faith Wignall - General Manager
Finding this company via a Google Search was my lucky day. Andrew understood my not-very-clear instructions of what I was trying to achieve, and implemented a very clear spreadsheet and reporting system for a very customised commission based project. Andrew was patient, clear, and explained things to me in a calm and concise manner. I would highly recommend Andrew and his company for any custom reporting and spreadsheet requirements you and your business may need.
Natural Real Estate Amanda Lee - Operations Manager

I asked several people I knew who work with Excel daily whether the task I needed was possible—everyone told me it couldn’t be done.

Then I came across Andrew, who is an expert in Microsoft Excel. I explained what I was trying to achieve, and without hesitation, he said, “Absolutely—it’s possible.” He mentioned he’d just need to create a few macros for me.

Not only did Andrew deliver exactly what I asked for, but he also went above and beyond by suggesting improvements I hadn’t even considered. The result was far better than I imagined.

He’s saved me a huge amount of time. What used to take me 30 minutes to an hour now takes just two simple steps—and only about 15 seconds.

Andrew is an absolute legend!

Adam Spooner Photography Adam Spooner - Business Owner

First used your services back in Feb 2019 for assistance with Google ad words, and your professionalism and the results you got were excellent. Your punctuality and reliability in doing a wide range of analytical work now, often ad hoc, for us and our clients is truly appreciated. You guys are amazing!

Growth Potential Greg Betty - Managing Director

Council Jobs’ ability to provide councils with detailed subscriber profiling information than the big job seeking sites such as Seek and CareerOne make it more attractive site for councils as they can better target prospects. Analytical Models has helped Council Jobs to deliver on that key point of differentiation. Analytical Models’ extensive experience in working with data has been central to delivering insights we can share with councils allowing us to set ourselves as a superior destination than the larger players. Their ability to handle dirty data was certainly very handy as there was more than enough to cause problems for a company less experienced. We have found them to be extremely professional but also very easy to work with. Am already planning our next tranche of work with them and highly recommend them to others.

Council Jobs Tony Miller - Director

Andrew has been consulting to our company for since 2019 and his work has improved consistency in liability estimating, financial management reporting and intellectual property protection across a range of self insurance programs.
Andrew is very customer service orientated and we recommend his services to our clients across Australia

Health and Injury Management Solutions (HIMS) Chris Douglas - Managing Director

Andrew is one of those rare breeds where he can traverse effortlessly between the complex with strong attention to detail, but with the ability to communicate in a simple, understandable and value orientated manner. His professionalism is unquestionnable.

Engage Energy Solutions and Energy Bill Doctor Tim Wolfenden - Managing Director and Owner

I have had the pleasure of working with Andrew on a variety of projects since 2017. He is a highly reliable and vastly experienced expert in his field and always managed to impress me with his customer centricity and outstanding professionalism. His excellent, accurate and detail-oriented models often were a key factor in the successful delivery of our projects.
Furthermore, he is an excellent communicator and team player with an easy going and friendly nature who is always willing to go the extra mile to make a project a success. Highly recommended!

Detecon Dennis Juchem - Senior Consultant

Analytical Models has been a saving grace for our business. Their reports are accurate and reliable, which saves us time on tedious tasks like data crunching by providing quick updates about how things stand in Google AdWords or Marketing campaigns; not only do they provide this information but also insights into what needs adjusting so that we can improve results further down the line! Their marketing reporting and AdWords capabilities are second to none! We highly recommend them.

Sales SEO & Social Media Kaylene Grieve - Managing Director

Thanks for getting the AdWords set up so quickly. Very much appreciated!

MBE Parramatta and Australian Christmas Cards Charles Batt- Managing Director

Definitely a big improvement in a very short amount of time! Thank you so much for the updates, I really appreciate you checking in!

Mindful Me Kara Markovics - Business Owner

Analytical Models impressed us with their professionalism in being able to very quickly understand, extract the key information from our financial team with minimal effort from them and to quickly build an easy-to-use model which accurately modelled our complex business.  Without a doubt they plugged the key gap and created fantastic value for us, love their work and cannot recommend them highly enough.

Muscle Meals Direct Jochen Bonitz - Owner

Landcare’s very successful data migration was largely attributed to the expertise of our data migration partner Analytical Models.  Analytical Models’ extensive experience with complex data migration exercises was clear throughout the project as they led the migration effort with minimal involvement needed from Landcare.  They were responsive, professional and pro-active in the way they ran the project, we are very pleased with the outcome achieved.

Landcare Tessa Jakszewicz - CEO

Some of Our Clients

Vodafone
Virgin Mobile
Detecon Consulting

What Best Describes Your Situation

  • We have part of the solution automated but there are several other parts that are not yet incorporated but we would like them to be included
  • We have most of the solution under control but there are one or two areas that are currently clunky and we are looking for a solution for these
  • We haven't been able to automate any of the solution but we can tell you what we want
  • We don't have a solution and we would like your help

How Best Can We Help?

Fields marked with * are required