SynMax Excel Add-in Documentation

---

This video will guide you through the basics of setting up and using the SynMax Excel Add-in, including authentication, the Formula Builder, graph creation, data aggregation, forecasting, and analysis.

Subscribe to Eric Anderson’s channel to receive regular updates on the SynMax Excel Add-in.

---

What’s New

Support for Multiple Values in Function Arguments

You can now input multiple values as arguments in a single function call. This feature is designed to provide you with more control and customization over your data queries.

For example, consider the function =@SMX.Fraccrews(). Previously, you could only input a single value for the Aggregate By argument. Now, you can input multiple parameters separated by semicolons.

Here’s an example:

=@SMX.Fraccrews("operator;region;date")

In the above example, the Aggregate By argument is given three parameters: operator, region, and date, each separated by a semicolon (“;”). This means that the function will aggregate the data by these three values.

To learn more about using this feature, please see the Creating Formulas section in the Usage page.

Explore the Docs

Table of Contents

Getting Started

• Introduction
• Installation
• Authentication
• Usage
• Terms of Use

Functions

• Completions
• DailyFrackedFeet
• DailyProduction
• DucsByOperator
• FracCrews Modified
• LongTermForecast
• OperatorClassification
• PipelineScrapes
• PipelineScrapeStatus
• ProductionByCountyandOperator
• ProductionByWell
• Regions
• Rigs
• ShortTermForecast
• ShortTermForecastHistory
• Wells

Glossary

• Glossary

---

Note

This project is under active development.