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 (ZIP File)

  • Citrix on Azure (v1.0)
  • Citrix Cloud & Azure (v.1.1)

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.

CostEstimate_1

Guidance Notes:

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

CostEstimate_2

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!

CostEstimate_3

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.

CostEstimate_4

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.

CostEstimate_5

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.

CostEstimate_6

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.

CostEstimate_7

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.

CostEstimate_8.PNG

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.

12 comments

  1. The spreadsheet looks good and seems pretty accurate. One problem – You cannot chose the storage type (cell B23 on the Input page) as it says the cell is protected.

    Like

  2. in Input tab in B23 cell (Storage Type)_ I see storage sizings instead of storage types.
    Also, as I understand for each infrastructure component you are attaching data disks – 32 GBs ? It is for app installation and data?

    Like

    • Hi Giedrius,

      I’ll update B23 to the correct label, the 32GB relates to additional data disks if required for infrastructure component. I’ll set this 0 by default now as it optional and not everyone requires nor needs it.

      David

      Like

  3. I have a concern regarding Storage in Guidance Notes:
    User Storage – Blob storage for user data/files, such as Documents / Desktop / Profile redirection.
    I think it is wrong… Will we be able provide NTFS permissions in user level, mount blob storage to endpoint as a disk. I think we need consider additionally File Servers – DFSR, Storage Spaces Direct or Azure File. Also Citrix App Layers doesn’t support DFSR , so I guess the best option for File Services – https://docs.microsoft.com/en-us/windows-server/remote/remote-desktop-services/rds-storage-spaces-direct-deployment .

    Like

    • Hi Giedrius,

      I based the spreadsheet on the original cost calculator by citrix which used blob storage. There is the option to include a separate file server and disks on citrix on azure , so ‘ill need to port that across to cloud cloud and azure.
      Thanks for the feedback, anything to improve and help community is a great thing. I’ll let you know when this is available and ready.

      Cheers
      David

      Like

      • hi Wilky, great job on this spreadsheet. I really like it over the original one that lacks flexibility. I’d like to estimate for South Central US with other instance types (D2S_V3, D4S_V3, D8S_V3). Can you please send me the updated calculator? thanks!

        Like

      • hi David,

        thanks for the help! Did you ever get a chance to update the spreadsheet with pricing from South Central US?

        Best Regards,
        Bao Tran

        Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s