# How To Calculate SMAC (Stage Monthly Active Clusters) in BQE CORE | Arithmix

Learn how to accurately calculate SMAC (Stage Monthly Active Clusters) in BQE CORE with our step-by-step guide. Increase your understanding of this important metric and improve your project management skills today.

Calculating SMAC (Stage Monthly Active Clusters) in BQE CORE is a simple process that can provide valuable insights into your business operations. SMAC is a metric that measures the number of active clusters in a given month, where a cluster is defined as a group of projects that share the same stage in the project lifecycle. By tracking SMAC, you can gain a better understanding of how your projects are progressing and identify areas for improvement.

To calculate SMAC in BQE CORE, you will need to first define the stages of your project lifecycle. This can vary depending on your industry and specific business needs, but common stages include planning, design, development, testing, and deployment. Once you have defined your stages, you can use BQE CORE's reporting tools to generate a list of all projects that are currently in each stage.

Next, you will need to group these projects by stage to create clusters. For example, if you have 10 projects in the planning stage, these would form a single planning cluster. Repeat this process for each stage in your project lifecycle.

Finally, you can calculate your SMAC by counting the number of active clusters in a given month. An active cluster is one that has at least one project in progress during the month. For example, if you have 5 active clusters in the month of June, your SMAC for June would be 5.

## What Is SMAC (Stage Monthly Active Clusters)?

SMAC (Stage Monthly Active Clusters) is a metric that measures the number of active clusters in a given month, where a cluster is defined as a group of projects that share the same stage in the project lifecycle. By tracking SMAC, you can gain a better understanding of how your projects are progressing and identify areas for improvement.

SMAC is particularly useful for businesses that have a large number of projects in progress at any given time. By grouping projects into clusters based on their stage in the project lifecycle, you can more easily track progress and identify bottlenecks or areas where projects are getting stuck.

SMAC can also be used to identify trends over time. For example, if you notice that your SMAC is consistently low for a particular stage, this may indicate that you need to allocate more resources or adjust your processes to improve efficiency.

## When Is It Valuable To Calculate SMAC (Stage Monthly Active Clusters)?

SMAC (Stage Monthly Active Clusters) can be valuable for businesses of all sizes and industries. However, it is particularly useful for businesses that have a large number of projects in progress at any given time, or for businesses that have complex project lifecycles with multiple stages.

If you are struggling to keep track of your projects or identify areas for improvement, SMAC can provide valuable insights into your business operations. By tracking the number of active clusters in each stage of your project lifecycle, you can more easily identify bottlenecks or areas where projects are getting stuck.

SMAC can also be useful for businesses that are looking to improve their project management processes. By identifying trends over time, you can make data-driven decisions about how to allocate resources or adjust your processes to improve efficiency and productivity.

In summary, calculating SMAC (Stage Monthly Active Clusters) in BQE CORE is a simple process that can provide valuable insights into your business operations. By tracking SMAC, you can gain a better understanding of how your projects are progressing and identify areas for improvement. Whether you are a small business owner or a project manager at a large corporation, SMAC can help you make data-driven decisions and improve your project management processes.

## How Do You Calculate SMAC (Stage Monthly Active Clusters) in BQE CORE

BQE CORE itself isn�t naturally geared towards letting you calculate complex metrics like SMAC (Stage Monthly Active Clusters). As an alternative, teams typically use products like Arithmix to import data from BQE CORE and build out dashboards.

## What is Arithmix?

Arithmix is the next generation spreadsheet - a collaborative, web-based platform for working with numbers that�s powerful yet easy to use. With Arithmix you can import data from systems like BQE CORE, combine it with data from other systems, and create calculations like SMAC (Stage Monthly Active Clusters).

In Arithmix, data is organized into Tables and referenced by name, not by cell location like a spreadsheet, simplifying calculation creation. Data and calculations can be shared with others and re-used like building blocks, vastly streamlining analysis, model building, and reporting in a highly scalable and easy to maintain platform. Data can be edited, categorized (by dimensions) and freely pivoted. Calculations are automatically copied across a dimension - eliminating copy and paste of formulas.