Quantrix launches new enterprise Software-as-a-Service capabilities

Quantrix launches new enterprise Software-as-a-Service capabilities

Quantrix’s enterprise customers now have access to a full SaaS, end-to-end model management solution for enterprise business modeling.

September 11, 2017

Executive Insight: Michael SalisburyExecutive Insight: Michael Salisbury

Executive Insight: Michael Salisbury

Michael Salisbury discusses Quantrix's ethics and goals in this interview with Finance Monthly.

September 23, 2017

Fintech Offerings are Challenging the Traditional Banking SystemFintech Offerings are Challenging the Traditional Banking System

Fintech Offerings are Challenging the Traditional Banking System

The last decade has seen an explosion of disruptive FinTech offerings that are challenging to the traditional banking system.

August 17, 2017

Analysing financial data: Best practices for banksAnalysing financial data: Best practices for banks

Analysing financial data: Best practices for banks

Mike Salisbury discusses the key points of analysing financial data for the banking industry.

August 7, 2017

How to capture and analyse your financial data more effectivelyHow to capture and analyse your financial data more effectively

How to capture and analyse your financial data more effectively

James Kipling explores ways to effectively capture and analyse financial data.

July 27, 2017

Video: Quantrix Authority – Dependency InspectorVideo: Quantrix Authority – Dependency Inspector

Video: Quantrix Authority – Dependency Inspector

Rich Lopez explores Quantrix Modeler's Dependency Inspector in this short video.

Dimension 2017 is shaping up to be a memorable conference

Dimension 2017 is shaping up to be a memorable conference

Towards the bank of tomorrowTowards the bank of tomorrow

Towards the bank of tomorrow

This article looks at a selection of emerging trends and the role they will play in solving problems for the banks of tomorrow.

July 11, 2017

University of Osnabrueck uses Quantrix to educate future decision makers
University of Osnabrueck uses Quantrix to educate future decision makers

University of Osnabrueck uses Quantrix to educate future decision makers

Dr.-Ing. Bodo Rieger from University of Osnabrueck talks through why they chose Quantrix to teach powerful and efficient modeling capabilities to their students.

Video: Rich Lopez, Quantrix AuthorityVideo: Rich Lopez, Quantrix Authority

Video: Rich Lopez, Quantrix Authority

Rich Lopez gives insight into his YouTube channel, Quantrix Authority, which provides short tutorials on the power of Quantrix Modeler.

6 Reasons why you should replace spreadsheets now!

6 Reasons why you should replace spreadsheets now!

Cloud procurement best practices by Laurence Painell

Cloud procurement best practices by Laurence Painell

Cloud Adoption for Fintech SystemsCloud Adoption for Fintech Systems

Cloud Adoption for Fintech Systems

What do you need to consider when evaluating Finech cloud-based products?

May 12, 2017

Best practice for accurately capturing and analysing financial dataBest practice for accurately capturing and analysing financial data

Best practice for accurately capturing and analysing financial data

What is the best practice for accurately capturing and analysing financial data?

May 2, 2017

How to Stay Certain in Uncertain Times

How to Stay Certain in Uncertain Times

What’s The Real Value Of A ‘Forecasting First’ Approach?What’s The Real Value Of A ‘Forecasting First’ Approach?

What’s The Real Value Of A ‘Forecasting First’ Approach?

James Kipling outlines the importance of good forecasting and gives an insight into its impact on businesses.

April 24, 2017

Webinar: Next Generation Spreadsheets

On-demand Webinar: Next Generation Spreadsheets

Watch this webinar and see why thousands of users have already made the jump from excel to the next generation business modeling platform.

LivingWorks Customer Success Stories
LivingWorks Customer Success Stories

LivingWorks Customer Success Stories

LivingWorks had many challenges using Excel for their budgeting process. By using Quantrix they made their budgeting process faster and more efficient.

Discounted Cash Flow for Business

Discounted Cash Flow for Business

This model contains a discounted cash flow analysis that can be used to evaluate an investment opportunity. Multiple companies are layered into the model to easily compare different investment opportunities.

Whitepaper: Quantrix and Excel 3 key differencesWhitepaper: Quantrix and Excel 3 key differences

Whitepaper: Quantrix and Excel: 3 Key Differences

Find out the key differences between Excel and Quantrix Modeler, and learn the key advantages of Quantrix Modeler.

Whitepaper: What is the True Cost of Spreadsheets?Whitepaper: What is the True Cost of Spreadsheets?

Whitepaper: What is the True Cost of Spreadsheets?

Have you ever thought about the true cost of spreadsheets to your business?

Everyone’s thinking about your customers, but who’s thinking about you? By Holly Perry

Everyone’s thinking about your customers, but who’s thinking about you? By Holly Perry

Commercial Real Estate Valuation and Feasibility

Commercial Real Estate Valuation and Feasibility

This model shows a typical analysis to estimate the value of commercial property and to project future financial results for a ten year holding period. This model calculates for two properties, but could easily be expanded to handle more. This model is based on a spreadsheet model created by Questor Consulting.

Quantrix – Business Modeling of the Future: Litehouse Foods
Quantrix – Business Modeling of the Future: Litehouse Foods

Quantrix – Business Modeling of the Future: Litehouse Foods

Rich Lopez, FP&A Analyst, talks us through how he uses Quantrix Modeler to create scalable, robust models over 10 times faster than he used to in Microsoft Excel.

Video: Quantrix in 60 SecondsVideo: Quantrix in 60 Seconds

Video: Quantrix in 60 Seconds

Discover Quantrix, next generation multi-dimensional modeling software.

Video: Quantrix OverviewVideo: Quantrix Overview

Video: Quantrix Overview

Discover the key benefits and capabilities of Quantrix Modeler

Brochure – Services & TrainingBrochure – Services & Training

Brochure – Services & Training

Our professional services can help support you whether you’re evaluating alternatives to a spreadsheet-based process or have a mandate for an enterprise-wide modelling platform.

Whitepaper: The Forecasting Value ChangeWhitepaper: The Forecasting Value Change

Whitepaper: The Forecasting Value Change

Have you ever thought about your Forecasting challenges?

Adjustable Rate Mortgage (ARM)

Adjustable Rate Mortgage (ARM)

This model enables scenario based comparison of adjustable rate mortgages. It makes use of the canvas to present this data in an interactive way.

QA-E151 Creating ScenariosQA-E151 Creating Scenarios

Quantrix Authority | Episode 151: Creating Scenarios in Quantrix

Creating scenarios in Quantrix is a simple as creating a new category tile then linking it to your calculations and assumptions matrix. This truly shows the power of Quantrix. No matter how complex your model as long as it has the scenarios category linked it works quite easily.

QA-E148 EclipseQA-E148 Eclipse

Quantrix Authority | Episode 148: Eclipse in Quantrix Formula

Learn what a formula eclipse is and how to fix it using a skip.

Canvas Component Examples

Canvas Component Examples

This model demonstrated in the 2014 seminar shows various canvas components availble in Quantrix and how they can be used to make interactive dashboards for users.

Mischler Financial Group Uses Quantrix Qloud to Stand Apart
Mischler Financial Group Uses Quantrix Qloud to Stand Apart

Mischler Financial Group Uses Quantrix Qloud to Stand Apart

Mischler Financial created a series of models developed on the Quantrix Qloud platform has created a “slam dunk” edge for the firm.

QA-E117 Conditional Formatting Recursion ExpressionQA-E117 Conditional Formatting Recursion Expression

Quantrix Authority | Episode 117: Conditional Formatting with Recursion Expressions

Learn how to use a recursion expression to format a cell when it's value changes over time.

Mike Salisbury on the Quantrix Product Roadmap

Mike Salisbury on the Quantrix Product Roadmap

People of Quantrix: Brian Cabana, Engineering Manager

People of Quantrix: Brian Cabana, Engineering Manager

Webinar: Quantrix Version 6 – Salesforce & Tableau Integrations

On-demand Webinar: Quantrix Version 6 - Salesforce & Tableau Integrations

Gain more valuable insight about your corporate data and share it with more people in your organization. Learn more about these out-of-the-box integrations to Salesforce and Tableau available in V6. Plus also get a sneak-peek at our new data filtering functionality!

Webinar: Quantrix Version 6 – Qloud Integration and Tablet Compatibility

On-demand Webinar: Quantrix Version 6 - Qloud Integration and Tablet Compatibility

Version 6 introduces self-service modeling for the entire enterprise. Seamless storage and access to models, plus Qloud compatibility with tablet devices.

Webinar: Quantrix Version 6 – New User Interface

On-demand Webinar Quantrix Version 6 - New User Interface

Redesigned UI on the desktop that is clean, sleek, modern, and easier to use. New icons and toolbars, new color themes, and a new launch panel. Plus, customizable formula syntax highlighting with colors.

Webinar: Introduction to Quantrix – 5 Key Concepts

On-demand Webinar: Introduction to Quantrix - 5 Key Concepts

This webinar is intended for users new to Quantrix. We will cover 5 key concepts including Dimensions, Formulas, Data Integration, Presentation Canvas and Qloud.

Webinar: Quantrix Version 6.2 Desktop and Qloud Overview

On-demand Webinar: Quantrix Version 6.2 Desktop and Qloud Overview

We released version 6.2 of Qloud and Desktop on June 2nd, 2016! This is a recording of a webinar from June 22nd providing an overview on the new features and enhancements.

Webinar: Quantrix Version 6 – Dependency Inspector

On-demand Webinar: Quantrix Version 6 - Dependency Inspector

Quantrix Version 6 features a complete redesign of the tool that helps you decipher formulas and visually track their dependencies. These improvements are a must see for the serious modeler.

Quantrix Updates Business Modeling Solution to Improve Business Planning for Data and Finance Professionals

Quantrix Updates Business Modeling Solution to Improve Business Planning for Data and Finance Professionals

Out-of-the-box Integrations to Tableau and Salesforce, revamped formula debugging tool, and enhanced cloud capabilities are included in Quantrix Modeler version 6

January 27, 2016

Logistics Capital and Strategy uses Quantrix for Quantitative Modeling
Logistics Capital and Strategy uses Quantrix for Quantitative Modeling

Logistics Capital and Strategy uses Quantrix for Quantitative Modeling

Logistics Capital and Strategy is a financial advisory firm focused on the transportation and logistics sector. It switched to Quantrix for quantitative modeling because its Excel model had gotten out of control.

Validus Uses Quantrix for Financial Planning
Validus Uses Quantrix for Financial Planning

Validus Uses Quantrix for Financial Planning

Validus, a holding company for reinsurance, insurance operating companies and investment advisors, use Quantrix for scenario testing and for building capital models, of which some with over a billion cells.

Jackson Laboratory
Jackson Laboratory

Jackson Laboratory

Nathan Briggs, Senior Treasury Analyst at Jackson Laboratory, uses the Quantrix business planning and modeling solution to manage endowment and treasury portfolios.

QA-E069 Slider en MasseQA-E069 Slider en Masse

Quantrix Authority | Episode 069: Change Slider Bounds En Masse on Presentation Canvas

Learn how to change slider bounds en-masse on the presentation canvas. Don't do them individually.

Vedanta Partners Chooses Quantrix for Business Modeling Solution in Australia and New Zealand

Vedanta Partners Chooses Quantrix for Business Modeling Solution in Australia and New Zealand

Business consulting firm will use Quantrix to develop financial simulations for its customers in markets including mining, oil and gas, energy, and utilities

October 12, 2015

Dan Murray of Interworks to Speak at Seminar by the Sea

Dan Murray of Interworks to Speak at Seminar by the Sea

University of Trento
University of Trento

University of Trento

Luca Erzegovesi of the University of Trento has been using Quantrix in the classroom for more than seven years to teach students about financial planning.

 

Rich Lopez, aka the “QuantrixAuthority”, Creates YouTube Channel for Quantrix Users

Rich Lopez, aka the “QuantrixAuthority”, Creates YouTube Channel for Quantrix Users

People of Quantrix: James Kipling, Product Manager

People of Quantrix: James Kipling, Product Manager

Quantrix Announces 9th Annual Seminar by the Sea User Conference

Quantrix Announces 9th Annual Seminar by the Sea User Conference

Best practices in business model development for novice and experienced users of Quantrix Modeler at 2015 Seminar by the Sea

April 28, 2015

QA-E016 Not two-dimensionalQA-E016 Not two-dimensional

Quantrix Authority | Episode 016: Quantrix is not two-dimensional

Learn the benefits of being able to model using a multi-dimensional modeling tool as opposed to a traditional two-dimensional spreadsheet

People of Quantrix: Tom Ahern Joins Quantrix

People of Quantrix: Tom Ahern Joins Quantrix

QA-E007 Datalink csvQA-E007 Datalink csv

Quantrix Authority | Episode 007: DataLink csv

How to Use DataLink in Quantrix Modeler to import data from a .csv file

RAC Outgrows Excel and Switches to Quantrix for International Budgeting (Customer Interview)
RAC Outgrows Excel and Switches to Quantrix for International Budgeting (Customer Interview)

RAC Outgrows Excel and Switches to Quantrix for International Budgeting (Customer Interview)

Reiter Affiliated Companies (RAC), the largest fresh, multi-berry producer in the world, reduce 566 Excel workbooks to 60 fully integrated Quantrix models for multi-year international budgeting.

Whitepaper: You Can’t Always Get from A to BWhitepaper: You Can’t Always Get from A to B

Whitepaper: You Can't Always Get from A to B

Finance and data modeling professionals are challenged on a daily basis to deliver accurate and timely answers to business questions using a 25 year old paradigm.

New features in Quantrix Modeler 5.3 boost business model performance

New features in Quantrix Modeler 5.3 boost business model performance

People of Quantrix: Shane Davison, Senior Software Developer

People of Quantrix: Shane Davison, Senior Software Developer

QA-E002 Sum SelectQA-E002 Sum Select

Quantrix Authority | Episode 002: Sum Select

Learn the Power of the Select Function in Quantrix Modeler

ATK Improve Business Management with Consolidated Plans and Forecasts
ATK Improve Business Management with Consolidated Plans and Forecasts

ATK Improve Business Management with Consolidated Plans and Forecasts

Many companies use Excel for business planning and forecasting as a default, but those who explore alternate tools can reap huge business benefits.

People of Quantrix: Dr. Alison Campbell, Lead Support Analyst

People of Quantrix: Dr. Alison Campbell, Lead Support Analyst

Capital Investment Planning

Capital Investment Planning

This model forecasts the power demand for a renewable wind farm and analyses scenarios for investment comparing ROI, IRR and NPV.

Quantrix Offers Collaborative Environment for Essla International

Quantrix Offers Collaborative Environment for Essla International

Business Pro

Business Pro

Business Pro is a Mexico City-based consulting firm that helps large companies in Mexico and throughout the world to improve their business forecasting and budgeting.

Lipkie Consulting
Lipkie Consulting

Lipkie Consulting

At the 2014 Seminar by the Sea, Christie Kent of Lipkie Consulting delivered a presentation to the attendees on developing cash flow waterfalls using Quantrix.

Converting A Uniform Distribution Into A Normal Distribution

Converting A Uniform Distribution Into A Normal Distribution

This model demonstrates how to convert a uniform distribution into a normal distribution. The model uses the RAND() function to generate a probability between 0 and 1 and the NORMINV() function to convert that probability into an occurrence within a normal distribution based on a defined mean and standard deviation. The model also charts the results to illustrate the distribution of occurrences calculated with this logic. Inverse distribution functions such as NORMINV() are available for most probability distributions, and could be used similarly to convert a uniform distribution.

New Platforms Bring Public vs. Private Clouds into Focus

New Platforms Bring Public vs. Private Clouds into Focus

At the moment, there is no greater priority in enterprise IT than building out and leveraging the cloud. Organizations that make the transition successfully will reap the benefits of a more agile infrastructure and lower costs. Those that don’t will fall into obsolescence.

October 22, 2014

Quantrix Launches Private Cloud for Enterprise Business Planning, Budgeting, and Forecasting Models

Quantrix Launches Private Cloud for Enterprise Business Planning, Budgeting, and Forecasting Models

Enterprise version of Quantrix Qloud enables customers to host models behind their own firewalls for secure sharing and collaboration

October 21, 2014

Quantrix Customers Extend Education at 2014 Seminar by the Sea

Quantrix Customers Extend Education at 2014 Seminar by the Sea

Discounted Cash Flow Analysis

Discounted Cash Flow Analysis

This model calculates the unlevered free cash flow from simple assumptions and then performs two types of analysis on the data to determine the price per share: 1. EBITA Multiple Method. 2. Perpetuity Growth Method.

Financial Ratio Analysis

Financial Ratio Analysis

This template contains a quarterly income statement, balance sheet and a matrix that calculates the relevant financial ratios. (Earnings per Share, Gross Margin, Quick Ratio, etc.) Multiple companies are layered into the model for easy, side-by-side analysis.

Financial Planning

Financial Planning

This model provides a structure for a multi-year business financial planning with a detailed sales and gross margin calculation for multiple products. Schedules to track production costs, operating costs and labor costs are built into the model.

Flash Tour Cars

Flash Tour Cars

This model shows an expanded version of the Quantrix model file built during the flash tour. The model includes a revenue and costs forecast.

Payroll Quarterly Tax Reporting

Payroll Quarterly Tax Reporting

This model allows for input of an SMB payroll and withholding amounts for each pay period. The model summarizes employee withholdings on a quarterly basis and the employer's share of Social Security and Medicare taxes. It also calculates the employer's unemployment tax for the year allowing for easy quarterly tax reporting.

Investment Banking

Investment Banking

This model is built using statistical functions provided in Quantrix Modeler to analyze the return of a portfolio with a given level of risk.

Black-Scholes Option Pricing

Black-Scholes Option Pricing

Use this Quantrix model to determine option values using the Black-Scholes Model.

Integrated Financial Statements

Integrated Financial Statements

This model is an example of an integrated financial statement with a balance sheet, income statement and cash flow statement. This model presents a forecast of these statements based on simple income, inventory and tax assumptions.

Accounts Receivable Payment Planning

Accounts Receivable Payment Planning

With the INDIRECT function, this model uses the customer’s historical payment habits to calculate projected cash flow from sales

Capital Investment Payback

Capital Investment Payback

This model analyzes the length of time between an initial investment and the recovery of the investment from its annual cash flow. Multiple investment scenarios are layered into the model

Getting Started with Quantrix – Tips from Quantrix Training Expert Valerie Grenier

Getting Started with Quantrix – Tips from Quantrix Training Expert Valerie Grenier

Range Data Categories

Range Data Categories

This model shows a technique of categorizing data into range ‘buckets’ using the SELECTGREATERTHAN function.

For Daktari Diagnostics, Point-of-Care Testing Requires Real-Time Data Access

For Daktari Diagnostics, Point-of-Care Testing Requires Real-Time Data Access

In remote regions of sub-Saharan Africa, health authorities are giving more and more thought to how they can deliver health services to patients far from large medical hubs.

July 10, 2014

Bond Pricing

Bond Pricing

This model calculates the bond price and par amount owned for multiple bond types, yields and lengths of bonds. This model can be easily expanded to include more types of bonds at varying yields under different scenarios.

Balance Sheet

Balance Sheet

A simple balance sheet model with some quick ratios. This model was created using copy and paste techniques from a two-dimensional spreadsheet.

Unique Rank

Unique Rank

The standard RANK function found in typical spreadsheet applications is also included with Quantrix Modeler. The RANK function assigns equal ranks to duplicate values, which is not always desirable. This template shows how you can use the RANK function to assign unique ranks by adding conditions to the formula.

Top-Performing Organizations Look Beyond Spreadsheets

Top-Performing Organizations Look Beyond Spreadsheets

LBO Feasibility

LBO Feasibility

This model uses assumptions to perform an LBO feasibility analysis to tell you whether an LBO is likely to occur. The user can perform 'what-if' analysis to see what would happen if these assumptions might change.

Merger

Merger

This model shows how Quantrix can model a company merger. It calculates the pro-forma financials post merger and also calculates the accretion/dilution of the share price for the company formed after the merger. Quantrix makes it easy to model different purchase scenarios and see the effects these will have on the combined statement.

Sales Analysis with Dashboard And Direct Connection to Database

Sales Analysis with Dashboard And Direct Connection to Database

This model leverages DataPush and the open source database H2. The model includes a direct connection to database for rapid access of data.

Planning Models Ltd
Planning Models Ltd

Planning Models Ltd

John Taylor is the Founder and Director of Planning Models Ltd., a UK-based company that specializes in business planning.

Hold the Date – Quantrix Seminar by the Sea Scheduled for September 10-12

Hold the Date – Quantrix Seminar by the Sea Scheduled for September 10-12

RAG Uses Quantrix Modeler for Project Economics, Portfolio Analysis and Business Planning
RAG Uses Quantrix Modeler for Project Economics, Portfolio Analysis and Business Planning

RAG Uses Quantrix Modeler for Project Economics, Portfolio Analysis and Business Planning

Oil and gas exploration and production is a complex and risky business where the success or failure of each project relies on numerous, fluctuating variables.

Rolling Average

Rolling Average

This template shows a rolling average calculation for an interest rate problem, all with one formula.

Is that Season Pass Worth It? Quantrix for Personal Finance

Is that Season Pass Worth It? Quantrix for Personal Finance

Montaña & Associates
Montaña & Associates

Montaña & Associates

John Montaña is the founder of Montaña & Associates, a leading provider of global records management and information governance solutions.

Quantrix helped Merrill Lynch Overcome Data Silos
Quantrix helped Merrill Lynch Overcome Data Silos

Quantrix helped Merrill Lynch Overcome Data Silos

Merrill Lynch is a leading global trader and underwriter of securities and derivatives across a broad range of asset classes, with offices in 37 countries.

Completed Flash Tutorial

Completed Flash Tutorial

This is the completed model file built during the flash presentation of the tutorial. This model demonstrates a simple revenue model, P&L for multiple product lines and simple charting.

Accounts Receivable Payment Planning

Accounts Receivable Payment Planning

With the INDIRECT function, this model uses the customer’s historical payment habits to calculate projected cash flow from sales.

Multi-Company And Multi-Currency

Multi-Company And Multi-Currency

This financial model incorporates multiple companies as well as multiple currencies.

Multidimensional modeling a key for medical diagnostics

Multidimensional modeling a key for medical diagnostics

Power Market Consulting Customer Success Story
Power Market Consulting Customer Success Story

Power Market Consulting Customer Success Story

Hear how Henry Shin, Principal of Power Market Consulting, has used Quantrix to develop OASISLive, a tool that models congestion revenue rights (CRR) in California’s power market.

 

The Value of Multidimensional Modeling with Quantrix – An Interview with Software Executive George Pappas

The Value of Multidimensional Modeling with Quantrix – An Interview with Software Executive George Pappas

Quantrix Customer Montana Associates Featured on Sandhill.com

Quantrix Customer Montana Associates Featured on Sandhill.com

Daktari Uses Quantrix to Improve Healthcare Diagnostics
Daktari Uses Quantrix to Improve Healthcare Diagnostics

Daktari Uses Quantrix to Improve Healthcare Diagnostics

Daktari Diagnostics has a big mission: to improve point-of-care diagnostics for patients in resource-poor markets.

Quantrix Survey Outlines Challenges Faced by Business and Finance Professionals

Quantrix Survey Outlines Challenges Faced by Business and Finance Professionals

Loan Amortization with Scenarios

Loan Amortization with Scenarios

One of the most powerful concepts of Quantrix is demonstrated in this model where scenario categories analyze different ‘what-if’ situations in a loan amortization problem.

Balanced Scorecard

Balanced Scorecard

This model summarizes data from product management, finance and the support desk for a software company and performs a detailed analysis on the data to automatically generate periodic Quarterly Business Reviews with accompanying scorecard. This model was demonstrated at the Quantrix Seminar by the Sea 2014.

Integrated Financial Statements

Integrated Financial Statements

This model is an example of an integrated financial statement with a balance sheet, income statement and discount cash flow analysis.

Financial Planning

Financial Planning

This model provides a structure for a multi-year business financial planning with a detailed sales and gross margin calculation for multiple products. Schedules to track production costs, operating costs and labor costs are built into the model.

Retail Sales

Retail Sales

This would be a typical model for a large retail brand. The model incorporates roll ups for product lines, regions and stores. It also includes functionality for forecasting revenues based on a growth matrix.

Investment Capital Budgeting

Investment Capital Budgeting

This simulates a complex model that calculates the return and risk scenarios of financing particular investment projects.

Commercial Real Estate Valuation And Feasibility

Commercial Real Estate Valuation And Feasibility

This model shows a typical analysis to estimate the value of commercial property and to project future financial results for a ten year holding period. This model calculates for two properties, but could easily be expanded to handle more. This model is based on a spreadsheet model created by Questor Consulting.

Analysis Of Diprotic Acids For Fixed PH

Analysis Of Diprotic Acids For Fixed PH

This model performs a multi-dimensional analysis of diprotic acids and includes a chart of fractional composition [á(H2A), á(HA-) and á(A2-)] relative to pH.

Recursion Relations in Population Genetics

Recursion Relations in Population Genetics

This spreadsheet simulates the behavior of a population of diploid organisms having two alleles (A & a) for a given gene where the viabilities of the homozygotes AA and aa and the heterozygote Aa may be different.

Comparison of Population Growth in The US and China

Comparison of Population Growth in The US and China

An interesting model that compares the projected population growth rates of China and the United States. Export this model to HTML for an insightful presentation.

Major League Baseball Statistics

Major League Baseball Statistics

This is a fun model that takes the individual player statistics from the 2004 Major League Baseball season and calculates the top ten teams’ batting statistics.

Automatic Vs Manual Summary Items

Automatic Vs Manual Summary Items

This model shows the difference between automatic and manual summary items and how to use SKIP and IF statements in a model.

Cumulative Total

Cumulative Total

This model uses recursion formulas to calculate a cumulative total for data over a series of months. It also demonstrates advanced recursion techniques to get data totals for first, next, previous and last three months.

Student Grading

Student Grading

This model shows a method in grading and ranking student test scores over two sessions and a final grade. This is a good example of the use of the SELECT and RANK function to sort grade results.

Circular Reference

Circular Reference

A circular reference is needed when determining federal and state taxes when the two calculations depend on each other. Learn how to control circular references in Quantrix by downloading this file and reading the associated Modeler Note.

Time Roll Up

Time Roll Up

This model demonstrates how to incorporate year, month and quarter time elements into your models and write formulas to create quarterly and yearly summaries.

Inter-Model Formulas Example

Inter-Model Formulas Example

Using inter-model formulas, this set of models shows how division model data can be rolled up into a master model. Download and unzip the files into the same directory to see these models in action

Statistical Defect Analysis

Statistical Defect Analysis

This model takes raw data from a test report and then generates 'six sigma' control charts measuring defects, and thus product quality, by project and by date. These are used to identify statistical outliers, whilst being sensitive to the quantity of data presented for analysis.

Flash Tour Cars

Flash Tour Cars

This model shows an expanded version of the Quantrix model file built during the flash tour.

Management Summary

Management Summary

This model demonstrates a technique to take raw sales data and roll up into summary matrices based on the class or group the sales data is part of.

The 7th Annual Seminar by the Sea

The 7th Annual Seminar by the Sea

Developing a Legal Risk Model for Big Volumes of Unstructured Data

Developing a Legal Risk Model for Big Volumes of Unstructured Data

A not-so-hidden secret in information management is the out-of-control growth of unstructured data in corporate America.

June 25, 2013

Big Data Dives Clarify California Power Markets

Big Data Dives Clarify California Power Markets

Power markets have always been a complex proposition, perhaps especially so in the places where they could do the most good.

April 3, 2013

Change on the fly

Change on the fly

Far Bank Enterprises, a manufacturer and distributor of fly fishing equipment and apparel decided to work with Quantrix.

March 1, 2013

Adding Value with Quantrix Modeler Skills

Adding Value with Quantrix Modeler Skills

The 6th Annual Seminar by the Sea

The 6th Annual Seminar by the Sea

Overcoming Unproductive Time in Budgeting, Forecasting and Planning

Overcoming Unproductive Time in Budgeting, Forecasting and Planning

It's no secret that business and finance professionals are spending too much time on mundane tasks, and not enough on delivering insight and other value-added activities.

June 21, 2012

Quantrix Delivers Dynamic Forecasting to Molymet
Quantrix Delivers Dynamic Forecasting to Molymet

Quantrix Delivers Dynamic Forecasting to Molymet

Materials-intensive businesses need numerous ‘what-if’ financial scenarios to manage purchasing decisions effectively.

The Quantrix Survey Results are In!

The Quantrix Survey Results are In!

Quantrix Releases Results of 2012 Budgeting, Forecasting, and Planning Survey

Quantrix Releases Results of 2012 Budgeting, Forecasting, and Planning Survey

Survey finds routine tasks dominate business and finance professionals’ time, leaving little for in-depth analysis; many report plans to reduce reliance on spreadsheets for finance activities

April 17, 2012

10 Years at Quantrix

10 Years at Quantrix

Quantrix for Consultancies

Quantrix for Consultancies

Ernesto Seijas of Essla International
Ernesto Seijas of Essla International

Ernesto Seijas of Essla International

Essla International  is a Quantrix partner, and recently started using the business modeling solution to help its clients with budgeting and financial forecasting. At the 2014 Seminar by the Sea, Ernesto Seijas took some time to share his experiences using Quantrix.

It’s Getting Easier To Go Beyond Spreadsheets for Modeling

It’s Getting Easier To Go Beyond Spreadsheets for Modeling

One trend in business software that’s still in its early stages but gathering momentum is the availability of modeling tools that fill the gap between desktop spreadsheets and enterprise systems.

February 27, 2012

“Best Practices” Approach to Financial Modeling

“Best Practices” Approach to Financial Modeling

Scenario Planning and Quantrix Modeler

Scenario Planning and Quantrix Modeler

Annual Budgeting and Forecasting Survey – Please Help With 2012 Survey

Annual Budgeting and Forecasting Survey – Please Help With 2012 Survey

Logistics Capital & Strategy Powers its ‘What if’ Scenario Analysis with Quantrix
Logistics Capital & Strategy Powers its ‘What if’ Scenario Analysis with Quantrix

Logistics Capital & Strategy Powers its ‘What if’ Scenario Analysis with Quantrix

Logistics Capital & Strategy is a Washington, DC-based company that specializes in supply-chain-intensive industries that require analysis and modeling of large amounts of data with multiple views and often across many ‘what if’ scenarios.

IDBS Acquires Quantrix to Provide Integrated Business Intelligence and Modeling Solutions to a Global Customer Base

IDBS Acquires Quantrix to Provide Integrated Business Intelligence and Modeling Solutions to a Global Customer Base

Leading provider of innovative data management and analytics solutions enhances portfolio with advanced business modeling and analytics solutions from Quantrix

August 26, 2010

Quantrix DataPush Enables Distributed Budgeting and Planning

Quantrix DataPush Enables Distributed Budgeting and Planning

Quantrix announces DataPush™, an integration tool that allows organizations to "push" data from Quantrix models directly to databases and other business applications.

October 7, 2009

EVN Uses Quantrix to Forecast the Energy Market
EVN Uses Quantrix to Forecast the Energy Market

EVN Uses Quantrix to Forecast the Energy Market

EVN is an Austria-based conglomerate that provides electricity, gas, heating, water, waste incineration and related services to more than three million customers in 18 countries.