{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Read Me","A2A (East US to West US)","A2A (DIY)","EASTUS DISKS","WESTUS DISKS","A2A Sheet Formulas","A2A Retention Days","V2A","H2A"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":21,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Read Me","index":0,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Please Note:"]
["This Calculator is applicable only for Azure to Azure scenario using Managed Disks in Azure Site Recovery and its estimates are for directionary purposes and do not reflect the exact costs.\nUS Dollar ($) has been used as the currency across this workbook."]
["The workbook contains two sheets named as:\n1) A2A (East US to West US)\n2) A2A (DIY)"]
[]
["Steps to use the A2A (East US to West US):\n\n1) This sample sheet has source region as East US and target region as West US by default.\n2) All the fields which require inputs are coloured.\n3) The input fields are to be filled as per the user requirements of their cloud infrastructure.\n4) The fees fields are automated and will fetch the correct data automatically."]
[]
["Steps to use the A2A (DIY):\n\n1) This sheet requires all the inputs from the user and can be used to calculate for any regions.\n2) All the fields which require inputs are coloured.\n3) The input fields are to be filled as per the user requirements of their cloud infrastructure.\n4) All the fees required have been provided with the reference link which should be used to verify the cost and input accordingly."]
[]
["There are additional costs for Test Failover, Failover and Resync which are not calculated as part of this calculator. \nPrices are estimates only. Actual prices may vary."]
[]
["In case of any queries, reach out to askasr@microsoft.com"]

{"sheet":"A2A (East US to West US)","index":1,"n_rows":35,"n_cols":54,"rows_kept":35,"cut":false,"hidden":false,"merged":[[22,2,22,4],[0,0,0,4],[1,2,1,4],[2,2,2,4],[3,2,3,4],[9,2,9,4],[10,2,10,4],[13,2,13,4],[14,2,14,4],[15,2,15,4],[16,2,16,4],[17,2,17,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[4,2,4,4],[6,7,6,8],[5,2,5,4],[6,2,6,4],[8,2,8,4],[21,2,21,4],[11,2,11,4],[7,2,7,4],[7,7,8,8],[12,2,12,4]]}
["Input Variables"]
["Variable","Value","Description",null,null,null,null,"Source Location","Target Location"]
[null,"Workload Characteristics",null,null,null,null,null,"East US","West US"]
["Total Number of VMs",1,"Each VM protected with ASR has a Protected Instance fee"]
["Protected Instance Fee",25,"Charged for ASR services per protected instance"]
["Total Number of Data Disks in Source",1,"Count of total data disks attached to given number of source VMs"]
["Average Size of Each Data Disk in GiB",1,"Average provisioned size of each source data disk which is protected using ASR",null,null,null,null,"Fields in this colour require inputs from user"]
["Average percentage Data Disk filled",1,"Average percent of the data disk that is filled at the time of protecting with ASR",null,null,null,null,"This sheet contains all the datapoints for Source East US and Target West US. Only input datapoints for required variables."]
["Average Size of Each OS Disk in GiB",1,"Size of the Source VM OS Disk. We are assuming OS Data disks are 100% full."]
["Type of Source Managed Disks","Standard HDD Managed Disks","Premium SSDv2 / Premium SSD / Standard HDD / Standard SDD"]
["Type of Target Replica Disks","Standard HDD Managed Disks"," Premium SSD / Standard HDD / Standard SDD"]
["Total Cost of single Replica DataDisk in Target region",{"$f":"IF(\n   TargetReplicaDiskType=\"Premium SSD Managed Disks\",\n   IFERROR(INDEX('WESTUS DISKS'!C2:C15, MATCH(MIN(IF('WESTUS DISKS'!B2:B15>=B7, 'WESTUS DISKS'!B2:B15)), 'WESTUS DISKS'!B2:B15, 0)), \"No Match Found\"),\n   IF(\n      TargetReplicaDiskType=\"Standard HDD Managed Disks\",\n      IFERROR(INDEX('WESTUS DISKS'!J2:J12, MATCH(MIN(IF('WESTUS DISKS'!I2:I12>=B7, 'WESTUS DISKS'!I2:I12)), 'WESTUS DISKS'!I2:I12, 0)), \"No Match Found\"),\n      IF(\n         TargetReplicaDiskType=\"Standard SSD Managed Disks\",\n         IFERROR(INDEX('WESTUS DISKS'!Q2:Q15, MATCH(MIN(IF('WESTUS DISKS'!P2:P15>=B7, 'WESTUS DISKS'!P2:P15)), 'WESTUS DISKS'!P2:P15, 0)), \"No Match Found\"),\n         \"Invalid Disk Type\"\n      )\n   )\n)","v":1.54},"ASR replicates the source data disks to the target, charging for the provisioned disk size based on the target region's disk price. For Standard disks at the source, Standard pricing applies at the target. For Premium SSD or Premium SSDv2 disks, Premium V1 pricing applies at the target."]
["Total Cost of single Replica OS Disk in Target region",{"$f":"INDEX('WESTUS DISKS'!C2:C15, MATCH(MIN(IF('WESTUS DISKS'!B2:B15 >= B9, 'WESTUS DISKS'!B2:B15)),'WESTUS DISKS'!B2:B15, 0))","v":0.78},"For ease of calculation, we are assuming the OS disk is always Premium SSD. For different inputs please use the A2A (DIY) sheet."]
["Expected Daily Churn Rate in GB/day per VM in Source region",1,"The amount of new write data change in a day on the VM. We are assuming any new data churn will always be on a new block.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Premium Blobs","Standard General Purpose v2 (SGPV2)"]
["Churn Type","Normal Churn","The type of Churn selected decides whether standard or premium cache storage account  is used",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standard General Purpose v1 (SGPV1)"]
["Type of Cache Storage Account used","Standard General Purpose v2 (SGPV2)","If the churn type is High Churn, ASR uses Premium Blobs.\nIf the churn type is Normal Churn, ASR uses Standard General Purpose blob storage."]
["Source Location Standard Page Blob Snapshot Fee (per GB/Month)",4.4999999999999998E-2,"Used as snapshot in Standard SDD Disks"]
["Source location Premium Page Blob Snapshot Fee (per GB/Month)",0.12,"Used as snapshot in Premium SSD and Premium SSDv2 disks"]
["Target Location Page Blob Snapshot Fee (per GB/Month)",4.4999999999999998E-2,"Used as snapshot in Standard SDD Disks"]
["Target Location Page Blob Snapshot Fee (per GB/Month)",0.13200000000000001,"Used as snapshot in Premium SSD and Premium SSDv2 disks"]
["Retention Days",0,"No of days the Recovery Points are available between 0 to 15days"]
["Per gb Network Egress Cost at Source location",0.02,"When replicating an Azure virtual machine from one region to another region outbound data transfer charges apply. There is no egress charges when data is transferred between availability zones in the same region. Compression factor is 0.5."]
["Total Capacity Reservation Cost associated with ASR per month (Optional)",0,"Enter the on-demand capacity reservation cost. On-demand capacity reservation enables you to reserve compute capacity in target Azure region or an availability zone for any duration of time. "]
[]
[]
["Cost Components of A2A ASR","Cost of 1st month","Cost of 2nd month","Cost at 3rd month","Cost at 4th month","Cost at 5th month","Cost at 6th month","Cost at 7th month","Cost at 8th month","Cost at 9th month","Cost at 10th month","Cost at 11th month","Cost at 12th month"]
["Total Protected Instance Fee",{"$f":"0","v":0},{"$f":"B4*B5","v":25},{"$f":"B4*B5","v":25},{"$f":"B4*B5","v":25},{"$f":"B4*B5","v":25},{"$f":"B4*B5","v":25},{"$f":"B4*B5","v":25},{"$f":"B4*B5","v":25},{"$f":"B4*B5","v":25},{"$f":"B4*B5","v":25},{"$f":"B4*B5","v":25},{"$f":"B4*B5","v":25}]
["ASR Source Snapshot Fee",{"$f":"_xlfn.IFS(DiskType=\"Premium SSD Managed Disks\",B18*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Premium SSDv2 Managed Disks\",B18*(B7*B6*B8))","v":2.2499999999999999E-2},{"$f":"_xlfn.IFS(DiskType=\"Premium SSD Managed Disks\",B18*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Premium SSDv2 Managed Disks\",B18*11*(ChurnRatePerDay/24)+B28)","v":2.2499999999999999E-2},{"$f":"_xlfn.IFS(DiskType=\"Premium SSD Managed Disks\",B18*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Premium SSDv2 Managed Disks\",B18*11*(ChurnRatePerDay/24)+C28)","v":2.2499999999999999E-2},{"$f":"_xlfn.IFS(DiskType=\"Premium SSD Managed Disks\",B18*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Premium SSDv2 Managed Disks\",B18*11*(ChurnRatePerDay/24)+D28)","v":2.2499999999999999E-2},{"$f":"_xlfn.IFS(DiskType=\"Premium SSD Managed Disks\",B18*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Premium SSDv2 Managed Disks\",B18*11*(ChurnRatePerDay/24)+E28)","v":2.2499999999999999E-2},{"$f":"_xlfn.IFS(DiskType=\"Premium SSD Managed Disks\",B18*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Premium SSDv2 Managed Disks\",B18*11*(ChurnRatePerDay/24)+F28)","v":2.2499999999999999E-2},{"$f":"_xlfn.IFS(DiskType=\"Premium SSD Managed Disks\",B18*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Premium SSDv2 Managed Disks\",B18*11*(ChurnRatePerDay/24)+G28)","v":2.2499999999999999E-2},{"$f":"_xlfn.IFS(DiskType=\"Premium SSD Managed Disks\",B18*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Premium SSDv2 Managed Disks\",B18*11*(ChurnRatePerDay/24)+H28)","v":2.2499999999999999E-2},{"$f":"_xlfn.IFS(DiskType=\"Premium SSD Managed Disks\",B18*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Premium SSDv2 Managed Disks\",B18*11*(ChurnRatePerDay/24)+I28)","v":2.2499999999999999E-2},{"$f":"_xlfn.IFS(DiskType=\"Premium SSD Managed Disks\",B18*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Premium SSDv2 Managed Disks\",B18*11*(ChurnRatePerDay/24)+J28)","v":2.2499999999999999E-2},{"$f":"_xlfn.IFS(DiskType=\"Premium SSD Managed Disks\",B18*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Premium SSDv2 Managed Disks\",B18*11*(ChurnRatePerDay/24)+K28)","v":2.2499999999999999E-2},{"$f":"_xlfn.IFS(DiskType=\"Premium SSD Managed Disks\",B18*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Premium SSDv2 Managed Disks\",B18*11*(ChurnRatePerDay/24)+L28)","v":2.2499999999999999E-2}]
["ASR Target Snapshot Fee",{"$f":"IF('A2A (East US to West US)'!B11=\"Premium SSD Managed disks\", INDEX('A2A Retention Days'!C:C, MATCH('A2A (East US to West US)'!B21, 'A2A Retention Days'!A:A, 0)), IF(OR('A2A (East US to West US)'!B11=\"Standard HDD Managed Disks\", 'A2A (East US to West US)'!B11=\"Standard SSD Managed Disks\"), INDEX('A2A Retention Days'!B:B, MATCH('A2A (East US to West US)'!B21, 'A2A Retention Days'!A:A, 0)), \"\"))","v":0},{"$f":"IF('A2A (East US to West US)'!B11=\"Premium SSD Managed disks\", INDEX('A2A Retention Days'!C:C, MATCH('A2A (East US to West US)'!B21, 'A2A Retention Days'!A:A, 0)), IF(OR('A2A (East US to West US)'!B11=\"Standard HDD Managed Disks\", 'A2A (East US to West US)'!B11=\"Standard SSD Managed Disks\"), INDEX('A2A Retention Days'!B:B, MATCH('A2A (East US to West US)'!B21, 'A2A Retention Days'!A:A, 0)), \"\"))","v":0},{"$f":"IF('A2A (East US to West US)'!B11=\"Premium SSD Managed disks\", INDEX('A2A Retention Days'!C:C, MATCH('A2A (East US to West US)'!B21, 'A2A Retention Days'!A:A, 0)), IF(OR('A2A (East US to West US)'!B11=\"Standard HDD Managed Disks\", 'A2A (East US to West US)'!B11=\"Standard SSD Managed Disks\"), INDEX('A2A Retention Days'!B:B, MATCH('A2A (East US to West US)'!B21, 'A2A Retention Days'!A:A, 0)), \"\"))","v":0},{"$f":"IF('A2A (East US to West US)'!B11=\"Premium SSD Managed disks\", INDEX('A2A Retention Days'!C:C, MATCH('A2A (East US to West US)'!B21, 'A2A Retention Days'!A:A, 0)), IF(OR('A2A (East US to West US)'!B11=\"Standard HDD Managed Disks\", 'A2A (East US to West US)'!B11=\"Standard SSD Managed Disks\"), INDEX('A2A Retention Days'!B:B, MATCH('A2A (East US to West US)'!B21, 'A2A Retention Days'!A:A, 0)), \"\"))","v":0},{"$f":"IF('A2A (East US to West US)'!B11=\"Premium SSD Managed disks\", INDEX('A2A Retention Days'!C:C, MATCH('A2A (East US to West US)'!B21, 'A2A Retention Days'!A:A, 0)), IF(OR('A2A (East US to West US)'!B11=\"Standard HDD Managed Disks\", 'A2A (East US to West US)'!B11=\"Standard SSD Managed Disks\"), INDEX('A2A Retention Days'!B:B, MATCH('A2A (East US to West US)'!B21, 'A2A Retention Days'!A:A, 0)), \"\"))","v":0},{"$f":"IF('A2A (East US to West US)'!B11=\"Premium SSD Managed disks\", INDEX('A2A Retention Days'!C:C, MATCH('A2A (East US to West US)'!B21, 'A2A Retention Days'!A:A, 0)), IF(OR('A2A (East US to West US)'!B11=\"Standard HDD Managed Disks\", 'A2A (East US to West US)'!B11=\"Standard SSD Managed Disks\"), INDEX('A2A Retention Days'!B:B, MATCH('A2A (East US to West US)'!B21, 'A2A Retention Days'!A:A, 0)), \"\"))","v":0},{"$f":"IF('A2A (East US to West US)'!B11=\"Premium SSD Managed disks\", INDEX('A2A Retention Days'!C:C, MATCH('A2A (East US to West US)'!B21, 'A2A Retention Days'!A:A, 0)), IF(OR('A2A (East US to West US)'!B11=\"Standard HDD Managed Disks\", 'A2A (East US to West US)'!B11=\"Standard SSD Managed Disks\"), INDEX('A2A Retention Days'!B:B, MATCH('A2A (East US to West US)'!B21, 'A2A Retention Days'!A:A, 0)), \"\"))","v":0},{"$f":"IF('A2A (East US to West US)'!B11=\"Premium SSD Managed disks\", INDEX('A2A Retention Days'!C:C, MATCH('A2A (East US to West US)'!B21, 'A2A Retention Days'!A:A, 0)), IF(OR('A2A (East US to West US)'!B11=\"Standard HDD Managed Disks\", 'A2A (East US to West US)'!B11=\"Standard SSD Managed Disks\"), INDEX('A2A Retention Days'!B:B, MATCH('A2A (East US to West US)'!B21, 'A2A Retention Days'!A:A, 0)), \"\"))","v":0},{"$f":"IF('A2A (East US to West US)'!B11=\"Premium SSD Managed disks\", INDEX('A2A Retention Days'!C:C, MATCH('A2A (East US to West US)'!B21, 'A2A Retention Days'!A:A, 0)), IF(OR('A2A (East US to West US)'!B11=\"Standard HDD Managed Disks\", 'A2A (East US to West US)'!B11=\"Standard SSD Managed Disks\"), INDEX('A2A Retention Days'!B:B, MATCH('A2A (East US to West US)'!B21, 'A2A Retention Days'!A:A, 0)), \"\"))","v":0},{"$f":"IF('A2A (East US to West US)'!B11=\"Premium SSD Managed disks\", INDEX('A2A Retention Days'!C:C, MATCH('A2A (East US to West US)'!B21, 'A2A Retention Days'!A:A, 0)), IF(OR('A2A (East US to West US)'!B11=\"Standard HDD Managed Disks\", 'A2A (East US to West US)'!B11=\"Standard SSD Managed Disks\"), INDEX('A2A Retention Days'!B:B, MATCH('A2A (East US to West US)'!B21, 'A2A Retention Days'!A:A, 0)), \"\"))","v":0},{"$f":"IF('A2A (East US to West US)'!B11=\"Premium SSD Managed disks\", INDEX('A2A Retention Days'!C:C, MATCH('A2A (East US to West US)'!B21, 'A2A Retention Days'!A:A, 0)), IF(OR('A2A (East US to West US)'!B11=\"Standard HDD Managed Disks\", 'A2A (East US to West US)'!B11=\"Standard SSD Managed Disks\"), INDEX('A2A Retention Days'!B:B, MATCH('A2A (East US to West US)'!B21, 'A2A Retention Days'!A:A, 0)), \"\"))","v":0},{"$f":"IF('A2A (East US to West US)'!B11=\"Premium SSD Managed disks\", INDEX('A2A Retention Days'!C:C, MATCH('A2A (East US to West US)'!B21, 'A2A Retention Days'!A:A, 0)), IF(OR('A2A (East US to West US)'!B11=\"Standard HDD Managed Disks\", 'A2A (East US to West US)'!B11=\"Standard SSD Managed Disks\"), INDEX('A2A Retention Days'!B:B, MATCH('A2A (East US to West US)'!B21, 'A2A Retention Days'!A:A, 0)), \"\"))","v":0}]
["ASR Replica Disk",{"$f":"B12*B6+B13*B4","v":2.3200000000000003},{"$f":"B12*B6+B13*B4","v":2.3200000000000003},{"$f":"B12*B6+B13*B4","v":2.3200000000000003},{"$f":"B12*B6+B13*B4","v":2.3200000000000003},{"$f":"B12*B6+B13*B4","v":2.3200000000000003},{"$f":"B12*B6+B13*B4","v":2.3200000000000003},{"$f":"B12*B6+B13*B4","v":2.3200000000000003},{"$f":"B12*B6+B13*B4","v":2.3200000000000003},{"$f":"B12*B6+B13*B4","v":2.3200000000000003},{"$f":"B12*B6+B13*B4","v":2.3200000000000003},{"$f":"B12*B6+B13*B4","v":2.3200000000000003},{"$f":"B12*B6+B13*B4","v":2.3200000000000003}]
["Egress (First month includes Intial Replication Cost)",{"$f":"(B22*((B7*B6*B8+B9*B4)+(ChurnRatePerDay*30)*0.5))","v":0.34},{"$f":"(B22*(ChurnRatePerDay*30)*0.5)","v":0.3},{"$f":"(B22*(+ChurnRatePerDay*30)*0.5)","v":0.3},{"$f":"(B22*(+ChurnRatePerDay*30)*0.5)","v":0.3},{"$f":"(B22*(+ChurnRatePerDay*30)*0.5)","v":0.3},{"$f":"(B22*(+ChurnRatePerDay*30)*0.5)","v":0.3},{"$f":"(B22*(+ChurnRatePerDay*30)*0.5)","v":0.3},{"$f":"(B22*(+ChurnRatePerDay*30)*0.5)","v":0.3},{"$f":"(B22*(+ChurnRatePerDay*30)*0.5)","v":0.3},{"$f":"(B22*(+ChurnRatePerDay*30)*0.5)","v":0.3},{"$f":"(B22*(+ChurnRatePerDay*30)*0.5)","v":0.3},{"$f":"(B22*(+ChurnRatePerDay*30)*0.5)","v":0.3}]
["Cache Storage Account",{"$f":"_xlfn.IFS(B16=\"Premium Blobs\", 2.5*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v2 (SGPv2)\", 11.25*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v1 (SGPv1)\", 0.25*(ChurnRatePerDay*0.0124275674)*B6)","v":0.13981013325},{"$f":"_xlfn.IFS(B16=\"Premium Blobs\", 2.5*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v2 (SGPv2)\", 11.25*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v1 (SGPv1)\", 0.25*(ChurnRatePerDay*0.0124275674)*B6)","v":0.13981013325},{"$f":"_xlfn.IFS(B16=\"Premium Blobs\", 2.5*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v2 (SGPv2)\", 11.25*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v1 (SGPv1)\", 0.25*(ChurnRatePerDay*0.0124275674)*B6)","v":0.13981013325},{"$f":"_xlfn.IFS(B16=\"Premium Blobs\", 2.5*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v2 (SGPv2)\", 11.25*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v1 (SGPv1)\", 0.25*(ChurnRatePerDay*0.0124275674)*B6)","v":0.13981013325},{"$f":"_xlfn.IFS(B16=\"Premium Blobs\", 2.5*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v2 (SGPv2)\", 11.25*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v1 (SGPv1)\", 0.25*(ChurnRatePerDay*0.0124275674)*B6)","v":0.13981013325},{"$f":"_xlfn.IFS(B16=\"Premium Blobs\", 2.5*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v2 (SGPv2)\", 11.25*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v1 (SGPv1)\", 0.25*(ChurnRatePerDay*0.0124275674)*B6)","v":0.13981013325},{"$f":"_xlfn.IFS(B16=\"Premium Blobs\", 2.5*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v2 (SGPv2)\", 11.25*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v1 (SGPv1)\", 0.25*(ChurnRatePerDay*0.0124275674)*B6)","v":0.13981013325},{"$f":"_xlfn.IFS(B16=\"Premium Blobs\", 2.5*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v2 (SGPv2)\", 11.25*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v1 (SGPv1)\", 0.25*(ChurnRatePerDay*0.0124275674)*B6)","v":0.13981013325},{"$f":"_xlfn.IFS(B16=\"Premium Blobs\", 2.5*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v2 (SGPv2)\", 11.25*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v1 (SGPv1)\", 0.25*(ChurnRatePerDay*0.0124275674)*B6)","v":0.13981013325},{"$f":"_xlfn.IFS(B16=\"Premium Blobs\", 2.5*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v2 (SGPv2)\", 11.25*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v1 (SGPv1)\", 0.25*(ChurnRatePerDay*0.0124275674)*B6)","v":0.13981013325},{"$f":"_xlfn.IFS(B16=\"Premium Blobs\", 2.5*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v2 (SGPv2)\", 11.25*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v1 (SGPv1)\", 0.25*(ChurnRatePerDay*0.0124275674)*B6)","v":0.13981013325},{"$f":"_xlfn.IFS(B16=\"Premium Blobs\", 2.5*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v2 (SGPv2)\", 11.25*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v1 (SGPv1)\", 0.25*(ChurnRatePerDay*0.0124275674)*B6)","v":0.13981013325}]
["Temporary Source Disk (Charged only during Initial Replication)",{"$f":"IF(OR(B10=\"Standard HDD Managed Disks\",B10=\"Standard SSD Managed Disks\",B10=\"Premium SSD Managed Disks\"),(((B7*B6+B9*B4)/1000)*6)*(B12*B6)/(30*24),\"\")","v":2.5666666666666666E-5}]
["Capacity Reservation",{"$f":"$B$23","v":0},{"$f":"$B$23","v":0},0,0,0,0,0,0,0,0,0,0]
["Total Cost",{"$f":"SUM(B$27:B$34)","v":2.8223357999166669},{"$f":"SUM(C$27:C$34)","v":27.78231013325},27.78231013325,27.78231013325,27.78231013325,27.78231013325,27.78231013325,27.78231013325,27.78231013325,27.78231013325,27.78231013325,27.78231013325]

{"sheet":"A2A (DIY)","index":2,"n_rows":35,"n_cols":54,"rows_kept":35,"cut":false,"hidden":false,"merged":[[5,2,5,4],[0,0,0,5],[1,2,1,4],[2,2,2,4],[3,2,3,4],[4,2,4,4],[6,7,6,8],[13,2,13,4],[14,2,14,4],[15,2,15,4],[16,2,16,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[9,2,9,4],[10,2,10,4],[11,2,11,4],[7,7,8,8],[12,2,12,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[22,2,22,4],[17,2,17,4],[18,2,18,4]]}
["Input Variables"]
["Variable","Value","Description",null,null,"Link for Fee Details",null,"Source Location","Target Location"]
[null,"Workload Characteristics"]
["Total Number of VMs",0,"Each VM protected with ASR has a Protected Instance fee"]
["Protected Instance Fee",0,"Charged for ASR services per protected instance",null,null,"https://aka.ms/ASRProtectedInstanceFee"]
["Total Number of Data Disks in Source",0,"Count of total data disks attached to given number of source VMs"]
["Average Size of Each Data Disk in GiB",0,"Average provisioned size of each source data disk which is protected using ASR",null,null,null,null,"Fields in this colour require inputs from user"]
["Average percentage Data Disk filled",0,"Average percent of the data disk that is filled at the time of protecting with ASR",null,null,null,null,"In this sheet you can try different inputs for the Variables as per different Source and Target Locations, and would require all the inputs from user"]
["Average Size of Each OS Data Disk in GiB",0,"Size of the Source VM OS Disk. We are assuming OS Data disks are 100% full."]
["Type of Source Managed Disks","Standard HDD Managed Disks","Premium SSDv2 / Premium SSD / Standard HDD / Standard SDD"]
["Type of Target Replica Disks","Standard HDD Managed Disks"," Premium SSD / Standard HDD / Standard SDD"]
["Total Cost of single Replica Disk in Target region",0,"ASR replicates the source data disks to the target, charging for the provisioned disk size based on the target region's disk price. For Standard disks at the source, Standard pricing applies at the target. For Premium V1 or V2 disks, Premium V1 pricing applies at the target.",null,null,"Pricing - Managed Disks | Microsoft Azure"]
["Total Cost of single Replica OS Disk in Target region",0,"ASR replicates the source OS disks to the target, charging for the provisioned disk size based on the target region's disk price.",null,null,"Pricing - Managed Disks | Microsoft Azure"]
["Expected Daily Churn Rate in GB/day per VM in Source region",0,"The amount of new write data change in a day on the VM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Premium Blobs","Standard General Purpose v2 (SGPv2)"]
["Churn Type","Normal Churn","The type of Churn selected decides whether standard or premium cache storage account  is used",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standard General Purpose v1 (SGPv1)"]
["Type of Cache Storage Account used","Standard General Purpose v2 (SGPv2)","If the churn type is High Churn, ASR uses Premium Blobs.\nIf the churn type is Normal Churn, ASR uses Standard General Purpose blob storage."]
["Source Location Standard Page Blob Snapshot Fee (per GB/Month)",0.01,"Used as snapshot in Standard SDD Disks. Select the Source Region and verify the snapshot fee for Standard LRS storage.",null,null,"Azure Page Blobs Storage Pricing | Microsoft Azure"]
["Source location Premium Page Blob Snapshot Fee (per GB/Month)",0.01,"Used as snapshot in Pv1 and Pv2 disks. Select the Source Region and verify the snapshot fee for Premium Blob snapshot storage.",null,null,"Azure Page Blobs Storage Pricing | Microsoft Azure"]
["Target Location Page Blob Disk Snapshot Fee (per GB/Month)",0.01,"Used as snapshot in Standard SDD Disks. Select the Target Region and verify the snapshot fee for Standard LRS storage.",null,null,"Azure Page Blobs Storage Pricing | Microsoft Azure"]
["Target Location Page Blob Disk Snapshot Fee (per GB/Month)",0.01,"Used as snapshot in Pv1 and Pv2 disks. Select the Target Region and verify the snapshot fee for Premium Blob snapshot storage.",null,null,"Azure Page Blobs Storage Pricing | Microsoft Azure"]
["Retention Days",0,"No of days the Recovery Points are available between 0 to 15days"]
["Per gb Network Egress Cost at Source location",0.01,"When replicating an Azure virtual machine from one region to another region outbound data transfer charges apply. There is no egress charges when data is transferred between availability zones in the same region.",null,null,"Pricing - Bandwidth | Microsoft Azure"]
["Total Capacity Reservation Cost associated with ASR per month (Optional)",0,"Enter the on-demand capacity reservation cost. On-demand capacity reservation enables you to reserve compute capacity in target Azure region or an availability zone for any duration of time. "]
[]
[]
["Cost Components of A2A ASR","Cost of 1st month","Cost of 2nd month","Cost at 3rd month","Cost at 4th month","Cost at 5th month","Cost at 6th month","Cost at 7th month","Cost at 8th month","Cost at 9th month","Cost at 10th month","Cost at 11th month","Cost at 12th month"]
["Total Protected Instance Fee",null,{"$f":"B4*B5","v":0},{"$f":"B4*B5","v":0},{"$f":"B4*B5","v":0},{"$f":"B4*B5","v":0},{"$f":"B4*B5","v":0},{"$f":"B4*B5","v":0},{"$f":"B4*B5","v":0},{"$f":"B4*B5","v":0},{"$f":"B4*B5","v":0},{"$f":"B4*B5","v":0},{"$f":"B4*B5","v":0}]
["ASR Source Snapshot Fee",{"$f":"_xlfn.IFS(DiskType=\"Premium SSD Managed Disks\",B18*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Premium SSDv2 Managed Disks\",B18*(B7*B6*B8))","v":0},{"$f":"_xlfn.IFS(DiskType=\"Premium SSD Managed Disks\",B18*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Premium SSDv2 Managed Disks\",B18*11*(ChurnRatePerDay/24)+B28)","v":0},{"$f":"_xlfn.IFS(DiskType=\"Premium SSD Managed Disks\",B18*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Premium SSDv2 Managed Disks\",B18*11*(ChurnRatePerDay/24)+C28)","v":0},{"$f":"_xlfn.IFS(DiskType=\"Premium SSD Managed Disks\",B18*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Premium SSDv2 Managed Disks\",B18*11*(ChurnRatePerDay/24)+D28)","v":0},{"$f":"_xlfn.IFS(DiskType=\"Premium SSD Managed Disks\",B18*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Premium SSDv2 Managed Disks\",B18*11*(ChurnRatePerDay/24)+E28)","v":0},{"$f":"_xlfn.IFS(DiskType=\"Premium SSD Managed Disks\",B18*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Premium SSDv2 Managed Disks\",B18*11*(ChurnRatePerDay/24)+F28)","v":0},{"$f":"_xlfn.IFS(DiskType=\"Premium SSD Managed Disks\",B18*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Premium SSDv2 Managed Disks\",B18*11*(ChurnRatePerDay/24)+G28)","v":0},{"$f":"_xlfn.IFS(DiskType=\"Premium SSD Managed Disks\",B18*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Premium SSDv2 Managed Disks\",B18*11*(ChurnRatePerDay/24)+H28)","v":0},{"$f":"_xlfn.IFS(DiskType=\"Premium SSD Managed Disks\",B18*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Premium SSDv2 Managed Disks\",B18*11*(ChurnRatePerDay/24)+I28)","v":0},{"$f":"_xlfn.IFS(DiskType=\"Premium SSD Managed Disks\",B18*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Premium SSDv2 Managed Disks\",B18*11*(ChurnRatePerDay/24)+J28)","v":0},{"$f":"_xlfn.IFS(DiskType=\"Premium SSD Managed Disks\",B18*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Premium SSDv2 Managed Disks\",B18*11*(ChurnRatePerDay/24)+K28)","v":0},{"$f":"_xlfn.IFS(DiskType=\"Premium SSD Managed Disks\",B18*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Standard HDD Managed Disks\",B17*12*(ChurnRatePerDay/24),DiskType=\"Premium SSDv2 Managed Disks\",B18*11*(ChurnRatePerDay/24)+L28)","v":0}]
["ASR Target Snapshot Fee",{"$f":"IF('A2A (DIY)'!B11=\"Premium SSD Managed disks\", INDEX('A2A Retention Days'!C:C, MATCH('A2A (DIY)'!B21, 'A2A Retention Days'!A:A, 0)), IF(OR('A2A (DIY)'!B11=\"Standard HDD Managed Disks\", 'A2A (DIY)'!B11=\"Standard SSD Managed Disks\"), INDEX('A2A Retention Days'!B:B, MATCH('A2A (DIY)'!B21, 'A2A Retention Days'!A:A, 0)), \"\"))","v":0},{"$f":"IF('A2A (DIY)'!B11=\"Premium SSD Managed disks\", INDEX('A2A Retention Days'!C:C, MATCH('A2A (DIY)'!B21, 'A2A Retention Days'!A:A, 0)), IF(OR('A2A (DIY)'!B11=\"Standard HDD Managed Disks\", 'A2A (DIY)'!B11=\"Standard SSD Managed Disks\"), INDEX('A2A Retention Days'!B:B, MATCH('A2A (DIY)'!B21, 'A2A Retention Days'!A:A, 0)), \"\"))","v":0},{"$f":"IF('A2A (DIY)'!B11=\"Premium SSD Managed disks\", INDEX('A2A Retention Days'!C:C, MATCH('A2A (DIY)'!B21, 'A2A Retention Days'!A:A, 0)), IF(OR('A2A (DIY)'!B11=\"Standard HDD Managed Disks\", 'A2A (DIY)'!B11=\"Standard SSD Managed Disks\"), INDEX('A2A Retention Days'!B:B, MATCH('A2A (DIY)'!B21, 'A2A Retention Days'!A:A, 0)), \"\"))","v":0},{"$f":"IF('A2A (DIY)'!B11=\"Premium SSD Managed disks\", INDEX('A2A Retention Days'!C:C, MATCH('A2A (DIY)'!B21, 'A2A Retention Days'!A:A, 0)), IF(OR('A2A (DIY)'!B11=\"Standard HDD Managed Disks\", 'A2A (DIY)'!B11=\"Standard SSD Managed Disks\"), INDEX('A2A Retention Days'!B:B, MATCH('A2A (DIY)'!B21, 'A2A Retention Days'!A:A, 0)), \"\"))","v":0},{"$f":"IF('A2A (DIY)'!B11=\"Premium SSD Managed disks\", INDEX('A2A Retention Days'!C:C, MATCH('A2A (DIY)'!B21, 'A2A Retention Days'!A:A, 0)), IF(OR('A2A (DIY)'!B11=\"Standard HDD Managed Disks\", 'A2A (DIY)'!B11=\"Standard SSD Managed Disks\"), INDEX('A2A Retention Days'!B:B, MATCH('A2A (DIY)'!B21, 'A2A Retention Days'!A:A, 0)), \"\"))","v":0},{"$f":"IF('A2A (DIY)'!B11=\"Premium SSD Managed disks\", INDEX('A2A Retention Days'!C:C, MATCH('A2A (DIY)'!B21, 'A2A Retention Days'!A:A, 0)), IF(OR('A2A (DIY)'!B11=\"Standard HDD Managed Disks\", 'A2A (DIY)'!B11=\"Standard SSD Managed Disks\"), INDEX('A2A Retention Days'!B:B, MATCH('A2A (DIY)'!B21, 'A2A Retention Days'!A:A, 0)), \"\"))","v":0},{"$f":"IF('A2A (DIY)'!B11=\"Premium SSD Managed disks\", INDEX('A2A Retention Days'!C:C, MATCH('A2A (DIY)'!B21, 'A2A Retention Days'!A:A, 0)), IF(OR('A2A (DIY)'!B11=\"Standard HDD Managed Disks\", 'A2A (DIY)'!B11=\"Standard SSD Managed Disks\"), INDEX('A2A Retention Days'!B:B, MATCH('A2A (DIY)'!B21, 'A2A Retention Days'!A:A, 0)), \"\"))","v":0},{"$f":"IF('A2A (DIY)'!B11=\"Premium SSD Managed disks\", INDEX('A2A Retention Days'!C:C, MATCH('A2A (DIY)'!B21, 'A2A Retention Days'!A:A, 0)), IF(OR('A2A (DIY)'!B11=\"Standard HDD Managed Disks\", 'A2A (DIY)'!B11=\"Standard SSD Managed Disks\"), INDEX('A2A Retention Days'!B:B, MATCH('A2A (DIY)'!B21, 'A2A Retention Days'!A:A, 0)), \"\"))","v":0},{"$f":"IF('A2A (DIY)'!B11=\"Premium SSD Managed disks\", INDEX('A2A Retention Days'!C:C, MATCH('A2A (DIY)'!B21, 'A2A Retention Days'!A:A, 0)), IF(OR('A2A (DIY)'!B11=\"Standard HDD Managed Disks\", 'A2A (DIY)'!B11=\"Standard SSD Managed Disks\"), INDEX('A2A Retention Days'!B:B, MATCH('A2A (DIY)'!B21, 'A2A Retention Days'!A:A, 0)), \"\"))","v":0},{"$f":"IF('A2A (DIY)'!B11=\"Premium SSD Managed disks\", INDEX('A2A Retention Days'!C:C, MATCH('A2A (DIY)'!B21, 'A2A Retention Days'!A:A, 0)), IF(OR('A2A (DIY)'!B11=\"Standard HDD Managed Disks\", 'A2A (DIY)'!B11=\"Standard SSD Managed Disks\"), INDEX('A2A Retention Days'!B:B, MATCH('A2A (DIY)'!B21, 'A2A Retention Days'!A:A, 0)), \"\"))","v":0},{"$f":"IF('A2A (DIY)'!B11=\"Premium SSD Managed disks\", INDEX('A2A Retention Days'!C:C, MATCH('A2A (DIY)'!B21, 'A2A Retention Days'!A:A, 0)), IF(OR('A2A (DIY)'!B11=\"Standard HDD Managed Disks\", 'A2A (DIY)'!B11=\"Standard SSD Managed Disks\"), INDEX('A2A Retention Days'!B:B, MATCH('A2A (DIY)'!B21, 'A2A Retention Days'!A:A, 0)), \"\"))","v":0},{"$f":"IF('A2A (DIY)'!B11=\"Premium SSD Managed disks\", INDEX('A2A Retention Days'!C:C, MATCH('A2A (DIY)'!B21, 'A2A Retention Days'!A:A, 0)), IF(OR('A2A (DIY)'!B11=\"Standard HDD Managed Disks\", 'A2A (DIY)'!B11=\"Standard SSD Managed Disks\"), INDEX('A2A Retention Days'!B:B, MATCH('A2A (DIY)'!B21, 'A2A Retention Days'!A:A, 0)), \"\"))","v":0}]
["ASR Replica Disk",{"$f":"B12*B6+B13*B4","v":0},{"$f":"B12*B6+B13*B4","v":0},{"$f":"B12*B6+B13*B4","v":0},{"$f":"B12*B6+B13*B4","v":0},{"$f":"B12*B6+B13*B4","v":0},{"$f":"B12*B6+B13*B4","v":0},{"$f":"B12*B6+B13*B4","v":0},{"$f":"B12*B6+B13*B4","v":0},{"$f":"B12*B6+B13*B4","v":0},{"$f":"B12*B6+B13*B4","v":0},{"$f":"B12*B6+B13*B4","v":0},{"$f":"B12*B6+B13*B4","v":0}]
["Egress (First month includes Intial Replication Cost)",{"$f":"(B22*((B7*B6*B8+B9*B4)+(ChurnRatePerDay*30)*0.5))","v":0},{"$f":"(B22*(ChurnRatePerDay*30)*0.5)","v":0},{"$f":"(B22*(+ChurnRatePerDay*30)*0.5)","v":0},{"$f":"(B22*(+ChurnRatePerDay*30)*0.5)","v":0},{"$f":"(B22*(+ChurnRatePerDay*30)*0.5)","v":0},{"$f":"(B22*(+ChurnRatePerDay*30)*0.5)","v":0},{"$f":"(B22*(+ChurnRatePerDay*30)*0.5)","v":0},{"$f":"(B22*(+ChurnRatePerDay*30)*0.5)","v":0},{"$f":"(B22*(+ChurnRatePerDay*30)*0.5)","v":0},{"$f":"(B22*(+ChurnRatePerDay*30)*0.5)","v":0},{"$f":"(B22*(+ChurnRatePerDay*30)*0.5)","v":0},{"$f":"(B22*(+ChurnRatePerDay*30)*0.5)","v":0}]
["Cache Storage Account",{"$f":"_xlfn.IFS(B16=\"Premium Blobs\", 2.5*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v2 (SGPv2)\", 11.25*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v1 (SGPv1)\", 0.25*(ChurnRatePerDay*0.0124275674)*B6)","v":0},{"$f":"_xlfn.IFS(B16=\"Premium Blobs\", 2.5*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v2 (SGPv2)\", 11.25*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v1 (SGPv1)\", 0.25*(ChurnRatePerDay*0.0124275674)*B6)","v":0},{"$f":"_xlfn.IFS(B16=\"Premium Blobs\", 2.5*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v2 (SGPv2)\", 11.25*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v1 (SGPv1)\", 0.25*(ChurnRatePerDay*0.0124275674)*B6)","v":0},{"$f":"_xlfn.IFS(B16=\"Premium Blobs\", 2.5*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v2 (SGPv2)\", 11.25*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v1 (SGPv1)\", 0.25*(ChurnRatePerDay*0.0124275674)*B6)","v":0},{"$f":"_xlfn.IFS(B16=\"Premium Blobs\", 2.5*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v2 (SGPv2)\", 11.25*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v1 (SGPv1)\", 0.25*(ChurnRatePerDay*0.0124275674)*B6)","v":0},{"$f":"_xlfn.IFS(B16=\"Premium Blobs\", 2.5*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v2 (SGPv2)\", 11.25*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v1 (SGPv1)\", 0.25*(ChurnRatePerDay*0.0124275674)*B6)","v":0},{"$f":"_xlfn.IFS(B16=\"Premium Blobs\", 2.5*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v2 (SGPv2)\", 11.25*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v1 (SGPv1)\", 0.25*(ChurnRatePerDay*0.0124275674)*B6)","v":0},{"$f":"_xlfn.IFS(B16=\"Premium Blobs\", 2.5*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v2 (SGPv2)\", 11.25*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v1 (SGPv1)\", 0.25*(ChurnRatePerDay*0.0124275674)*B6)","v":0},{"$f":"_xlfn.IFS(B16=\"Premium Blobs\", 2.5*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v2 (SGPv2)\", 11.25*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v1 (SGPv1)\", 0.25*(ChurnRatePerDay*0.0124275674)*B6)","v":0},{"$f":"_xlfn.IFS(B16=\"Premium Blobs\", 2.5*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v2 (SGPv2)\", 11.25*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v1 (SGPv1)\", 0.25*(ChurnRatePerDay*0.0124275674)*B6)","v":0},{"$f":"_xlfn.IFS(B16=\"Premium Blobs\", 2.5*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v2 (SGPv2)\", 11.25*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v1 (SGPv1)\", 0.25*(ChurnRatePerDay*0.0124275674)*B6)","v":0},{"$f":"_xlfn.IFS(B16=\"Premium Blobs\", 2.5*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v2 (SGPv2)\", 11.25*(ChurnRatePerDay*0.0124275674)*B6, B16=\"Standard General Purpose v1 (SGPv1)\", 0.25*(ChurnRatePerDay*0.0124275674)*B6)","v":0}]
["Temporary Source Disk (Charged only during Initial Replication)",{"$f":"IF(OR(B10=\"Standard HDD Managed Disks\",B10=\"Standard SSD Managed Disks\",B10=\"Premium SSD Managed Disks\"),(((B7*B6+B9*B4)/1000)*6)*(B12*B6)/(30*24),\"\")","v":0}]
["Capacity Reservation",{"$f":"$B$23","v":0},{"$f":"$B$23","v":0},0,0,0,0,0,0,0,0,0,0]
["Total Cost",{"$f":"SUM(B27:B32)","v":0},{"$f":"SUM(C27:C32)","v":0},{"$f":"SUM(D27:D32)","v":0},0,0,0,{"$f":"SUM(H27:H32)","v":0},{"$f":"SUM(H27:H32)","v":0},{"$f":"SUM(H27:H32)","v":0},{"$f":"SUM(H27:H32)","v":0},{"$f":"SUM(H27:H32)","v":0},{"$f":"SUM(H27:H32)","v":0}]

{"sheet":"EASTUS DISKS","index":3,"n_rows":15,"n_cols":17,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["Pv1 Disks","Disk Size (in GiB)","Price per month",null,null,null,null,"Standard HDD Disks","Disk Size in GiB","Price per month",null,null,null,null,"Standard SSD Disks","Disk Size","Price per month"]
["P1",4,0.6,null,null,null,null,"S4",32,1.54,null,null,null,null,"E1",4,0.3]
["P2",8,1.2,null,null,null,null,"S6",64,3.01,null,null,null,null,"E2",8,0.6]
["P3",16,2.4,null,null,null,null,"S10",128,5.89,null,null,null,null,"E3",16,1.2]
["P4",32,5.28,null,null,null,null,"S15",256,11.33,null,null,null,null,"E4",32,2.4]
["P6",64,10.210000000000001,null,null,null,null,"S20",512,21.76,null,null,null,null,"E6",64,4.8]
["P10",128,19.71,null,null,null,null,"S30",1024,40.96,null,null,null,null,"E10",128,9.6]
["P15",256,38.020000000000003,null,null,null,null,"S40",2048,77.83,null,null,null,null,"E15",256,19.2]
["P20",512,73.22,null,null,null,null,"S50",4096,143.36000000000001,null,null,null,null,"E20",512,38.4]
["P30",1024,135.16999999999999,null,null,null,null,"S60",8192,262.14,null,null,null,null,"E30",1024,76.8]
["P40",2048,259.05,null,null,null,null,"S70",16384,491.52,null,null,null,null,"E40",2048,153.6]
["P50",4096,495.57,null,null,null,null,"S80",32768,953.55,null,null,null,null,"E50",4096,307.2]
["P60",8192,946.08,null,null,null,null,null,null,null,null,null,null,null,"E60",8192,614.4]
["P70",16384,1802.06,null,null,null,null,null,null,null,null,null,null,null,"E70",16384,1228.8]
["P80",32768,3604.11,null,null,null,null,null,null,null,null,null,null,null,"E80",32768,2457.6]

{"sheet":"WESTUS DISKS","index":4,"n_rows":17,"n_cols":17,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Pv1 Disks","Disk Size (in GiB)","Price per month",null,null,null,null,"Standard HDD Disks","Disk Size in GiB","Price per month",null,null,null,null,"Standard SSD Disks","Disk Size in GiB","Price per month"]
["P1",4,0.78,null,null,null,null,"S4",32,1.54,null,null,null,null,"E1",4,0.3]
["P2",8,1.56,null,null,null,null,"S6",64,3.01,null,null,null,null,"E2",8,0.6]
["P3",16,3.12,null,null,null,null,"S10",128,5.89,null,null,null,null,"E3",16,1.2]
["P4",32,5.28,null,null,null,null,"S15",256,11.33,null,null,null,null,"E4",32,2.4]
["P6",64,10.210000000000001,null,null,null,null,"S20",512,21.76,null,null,null,null,"E6",64,4.8]
["P10",128,19.71,null,null,null,null,"S30",1024,40.96,null,null,null,null,"E10",128,9.6]
["P15",256,38.020000000000003,null,null,null,null,"S40",2048,81.92,null,null,null,null,"E15",256,19.2]
["P20",512,73.22,null,null,null,null,"S50",4096,163.84,null,null,null,null,"E20",512,38.4]
["P30",1024,135.16999999999999,null,null,null,null,"S60",8192,327.68,null,null,null,null,"E30",1024,76.8]
["P40",2048,259.05,null,null,null,null,"S70",16384,655.36,null,null,null,null,"E40",2048,153.6]
["P50",4096,495.57,null,null,null,null,"S80",32768,1310.72,null,null,null,null,"E50",4096,307.2]
["P60",8192,946.08,null,null,null,null,null,null,null,null,null,null,null,"E60",8192,614.4]
["P70",16384,1802.06,null,null,null,null,null,null,null,null,null,null,null,"E70",16384,1228.8]
["P80",32768,3604.11,null,null,null,null,null,null,null,null,null,null,null,"E80",32768,2457.6]
[]
[null,"Pv1",null,null,null,null,null,null,"Standard HDD",null,null,null,null,null,"Standard SSD"]

{"sheet":"A2A Sheet Formulas","index":5,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Cost Components of A2A ASR","Formulas"]
["Total Protected Instance Fee","Flat PI fee ($)* Number of VMs"]
["ASR Source Snapshot Fee","IF DiskType=  Standard SSD/HDD Managed Disks  then ASR Source Snapshot fee cost = Standard Snapshot fee($)*12 bookmarks*(ChurnRatePerHour)\nIF DiskType= Premium SSD Managed Disks  then ASR Source Snapshot fee cost = Premium Snapshot fee*12 bookmarks*(ChurnRatePerHour)\nIf DiskType=Premium SSDv2 Managed Disks then ASR Source Snapshot fee cost=Premium Snapshot fee*(Total size of filled data disk)"]
["ASR Target Snapshot Fee","Monthly Cost=For Premium and Standard disks, respective type of monthly snapshot fee*churn rate per day*number of retention days"]
["ASR Replica Disk","Target disk cost"]
["Egress","Initial Replication=Percent of data disk filled in GiB*Total no. of disks*egress cost\nMonthly Replication=Churn per day*Egress per GB cost"]
["Cache Storage Account","For monthly cost below logic is used:\nGPv1 page blobs: ~0.25*Churn Rate MBps*Number of disks USD\nGPv2 page blobs: ~ 11.25*Churn Rate MBps*Number of disks USD\nPremium block blobs: ~2.5*Churn Rate MBps*Number of disks USD"]
["Temporary Disk","Source data disk size charged at source disk SKU pricing*number of hours IR takes which is disk size in Tb*6"]
["Capacity Reservation","Input from customer"]

{"sheet":"A2A Retention Days","index":6,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Number of Retention Days","Standard Snapshot Cost","Premium Snapshot Cost"]
[0,0,0]
[1,{"$f":"ChurnRatePerDay*'A2A (East US to West US)'!$B$19*A3","v":4.4999999999999998E-2},{"$f":"ChurnRatePerDay*'A2A (East US to West US)'!$B$20*A3","v":0.13200000000000001}]
[2,{"$f":"ChurnRatePerDay*'A2A (East US to West US)'!$B$19*A4","v":0.09},{"$f":"ChurnRatePerDay*'A2A (East US to West US)'!$B$20*A4","v":0.26400000000000001}]
[3,{"$f":"ChurnRatePerDay*'A2A (East US to West US)'!$B$19*A5","v":0.13500000000000001},{"$f":"ChurnRatePerDay*'A2A (East US to West US)'!$B$20*A5","v":0.39600000000000002}]
[4,{"$f":"ChurnRatePerDay*'A2A (East US to West US)'!$B$19*A6","v":0.18},{"$f":"ChurnRatePerDay*'A2A (East US to West US)'!$B$20*A6","v":0.52800000000000002}]
[5,{"$f":"ChurnRatePerDay*'A2A (East US to West US)'!$B$19*A7","v":0.22499999999999998},{"$f":"ChurnRatePerDay*'A2A (East US to West US)'!$B$20*A7","v":0.66}]
[6,{"$f":"ChurnRatePerDay*'A2A (East US to West US)'!$B$19*A8","v":0.27},{"$f":"ChurnRatePerDay*'A2A (East US to West US)'!$B$20*A8","v":0.79200000000000004}]
[7,{"$f":"ChurnRatePerDay*'A2A (East US to West US)'!$B$19*A9","v":0.315},{"$f":"ChurnRatePerDay*'A2A (East US to West US)'!$B$20*A9","v":0.92400000000000004}]
[8,{"$f":"ChurnRatePerDay*'A2A (East US to West US)'!$B$19*A10","v":0.36},{"$f":"ChurnRatePerDay*'A2A (East US to West US)'!$B$20*A10","v":1.056}]
[9,{"$f":"ChurnRatePerDay*'A2A (East US to West US)'!$B$19*A11","v":0.40499999999999997},{"$f":"ChurnRatePerDay*'A2A (East US to West US)'!$B$20*A11","v":1.1880000000000002}]
[10,{"$f":"ChurnRatePerDay*'A2A (East US to West US)'!$B$19*A12","v":0.44999999999999996},{"$f":"ChurnRatePerDay*'A2A (East US to West US)'!$B$20*A12","v":1.32}]
[11,{"$f":"ChurnRatePerDay*'A2A (East US to West US)'!$B$19*A13","v":0.495},{"$f":"ChurnRatePerDay*'A2A (East US to West US)'!$B$20*A13","v":1.452}]
[12,{"$f":"ChurnRatePerDay*'A2A (East US to West US)'!$B$19*A14","v":0.54},{"$f":"ChurnRatePerDay*'A2A (East US to West US)'!$B$20*A14","v":1.5840000000000001}]
[13,{"$f":"ChurnRatePerDay*'A2A (East US to West US)'!$B$19*A15","v":0.58499999999999996},{"$f":"ChurnRatePerDay*'A2A (East US to West US)'!$B$20*A15","v":1.7160000000000002}]
[14,{"$f":"ChurnRatePerDay*'A2A (East US to West US)'!$B$19*A16","v":0.63},{"$f":"ChurnRatePerDay*'A2A (East US to West US)'!$B$20*A16","v":1.8480000000000001}]
[15,{"$f":"ChurnRatePerDay*'A2A (East US to West US)'!$B$19*A17","v":0.67499999999999993},{"$f":"ChurnRatePerDay*'A2A (East US to West US)'!$B$20*A17","v":1.98}]

{"sheet":"V2A","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"H2A","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}