Cost Calculator spreadsheet for Citrix Cloud + Azure & Citrix on Azure

Following on from my post Deep dive into Citrix Cost Calculator for Azure, i have now developed a comprehensive spreadsheet which builds on the great work citrix has done on the calculator but will more granular control/understanding of the cost.

Both calculator are available here:        citrixonazure-costestimate_29092020(ZIP File)

• Citrix on Azure (v1.2) Last Updated 29/09/2020
• Citrix Cloud & Azure (v.1.3) Last Updated 29/09/2020

It includes the following Azure Regions at the minute with currency adjusting after selection of the azure region:-

• UK South/West
• Europe North/West
• Germany Central/North East
• Canada Central/East
• Australia East/South East

Overview

The below is a overview on the spreadsheet layout , both have the same layout with some variance/extras inputs required for additional components found in Citrix on Azure which required in Citrix Cloud.

Disclaimer:

Any specific notes, inclusions, exclusion are documented here as well as contact information for any suggestions, recommendations etc.

Guidance Notes:

This is detailed notes relating to the Input Tab and explanation of each input required.

Input:

This tab is the single most important tab, all the information here has a direct impact in costs and information displayed in the next set of tab. Guidance Notes should be referenced or Recommended/Tip followed throughout this document with some detail also displayed in comments.

NOTE: All Input coloured Green as adjustable!

Summary:

This provides a overall summary of cost incurred broken down in Standard(XenApp), Enhanced(XenDesktop), Core Infrastructure. It provide a graphical overview of the cost as well as per month cost for all users for the solution and broken down per Standard/Enhanced.

Azure Cost Summary:

This provides detail around Users/Hours and Cost breakdown per Standard/Enhanced including impact Smart Scaling has on the Cost. Core infrastructure cost is also detailed here.

Azure Sizing:

This provides a further breakdown of Network/Storage calculation/costs which ultimately feed the Azure Cost Summary tab. Also Users per Azure VM is detailed here and is adjustable and will impact the number of servers/cost if adjusted.

Azure VM Pricing:

There is the main azure pricing tab, all costs for VM, Network, Storage cost for each region. All Cells in green are adjustable and should be checked to ensure the pricing is correct.

NOTE: There is no automated updating of pricing of this spreadsheet, it must be done manually. This could be a further enhancement of the spreadsheet at a later stage.

ExpressRoute Pricing:

This details the ExpressRoute cost for each region, including metered, unmetered and with premium addon or not. All Cells in green are adjustable and should be checked to ensure the pricing is correct.

I hope this details sufficiently how the spreadsheet works and interested to hear peoples feedback on it/suggestion for improvement.

NOTE: This is intended to be cost estimator therefore a percentage of error needs to be factored in due to complexity of azure pricing/usage.