The Microsoft Exchange Team released an important update of the Exchange Mailbox Role Calculator, bringing it to version 14.1.

This version includes the following fixes since 12.8:

• Fixed the Activation Results Scenarios to no longer display #NAME when dealing with dedicated lagged copy servers;
• Fixed 2 LUNs / Backup Set formula for the 11th database grouping set in the DB and Log LUN Design / Server table to display the correct number of databases in the grouping set;
• Fixed “Number of Active Databases / SDC Server (After First PDC Server Failure)” calculations to take into account stretched Single DAG without dedicated DR servers;
• Fixed “Number of Required Mailbox Processor Cores (Primary Datacenter)” formula to respect when site resilience is disabled and A/A (Single DAG) is selected;
• Fixed formatting for scenario that resulted in more HA database copies being deployed in the secondary datacenter than in the primary datacenter and also improved validation checks;
• Updated “Custom Number of Databases” (Input Section) and “Number of Databases” (Role Requirements section) text to indicate in standalone situations that the “Custom Number of Databases” is per server and “Number of Databases” is for the environment;
• Fixed 2nd PDC failure formula to enable site resilient scenarios that have 3 copies in PDC to allow double server failure event;
• Optimized Number of Mailboxes per Database (I/O Driven) to not round up odd numbers to the next even number;
• Fixed text in various comment fields.

This version also contains the following enhancements:

• Added conditional formatting for Exchange Native Data Protection input factor to alert when you are deploying with less than the recommended number of HA copies;
• The calculator now includes the ability to select different disk types and capacities for the storage architecture being deployed in the secondary data center.

Consult the changeblog here.You can download the calculator here. Usage instructions can be found here.