{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Calculate Here","Supporting Data"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Calculate Here","index":0,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,2],[2,0,2,2],[12,0,12,2],[22,0,23,2],[24,0,24,2],[1,0,1,2]]}
["CloudLabs VM Labs - Cost Calculator\nVersion: 1.0"]
["Please visit https://help.cloudlabs.ai/docs/pricing for more information about CloudLabs VM Labs Pricing and to download latest version of this calculator. "]
["Section-1: Lab Requirements (Please complete this section to determine the cost of hosting labs)"]
["Item","Unit","Remarks"]
["Azure Subscription Type ","CloudLabs Managed Azure Subscription"]
["Lab VM Size (SKU)* ","Small_Standard_F2s_v2_StandardSSD_128GB","Select appropriate VM SKU"]
["Lab VM OS* ","Windows","Select Operating System for your Lab"]
["Number of Lab Seats(VMs) Required* ",15,"One Seat per student + one instructor seat additional if needed."]
["Lab Duration (In Days)* ",30,"Lab progress and disks will be preserved for specified number of days, typically you would want to preserve the lab for the total duration of course/training. Number of days = End Date - Start Date. Min Value 1, Max Value 365. Lab VM will deleted after given number of days"]
["Uptime Quota (In Hours)* ",40,"Active Hours per student. Each student will be running  the lab VM for given hours over the total duration specific in cell B8."]
[]
[]
["Section-2: Estimated Cost (Auto-Generated, Do Not Change)"]
["Lab Name","Per Seat Rate (USD)","Total Cost (USD)"]
["Estimated Azure Expenses",{"$f":"'Supporting Data'!B33","v":18.994285714285706},{"$f":"B15*B8","v":284.9142857142856}]
["Estimated CloudLabs Platform Cost",{"$f":"IF(OR(B5=\"Bring your own Azure Subscription\", B5=\"CloudLabs Managed Azure Subscription\"), 'Supporting Data'!B40, 'Supporting Data'!B41)","v":12},{"$f":"B16*B8","v":180}]
[]
[]
["Total Cost",{"$f":"B15+B16","v":30.994285714285706},{"$f":"C15+C16","v":464.9142857142856}]
[]
[]
[]
["Please contact cloudlabs-sales@spektrasystems.com for any sales questions or next steps."]
[]
["1. Please note that the calculation is based on East US Azure region, there may be a slight variation in cost for different regions. \n2. Please note that if there may be bandwidth charges for outbound data transfer, additionaly based on total data transfered outside the machines. Calculator does not consider any outbound data transfer.\n3. If you wish to use a diffrent VM Series/Disk SKU etc, please contact our sales team for custom pricing. \n4. CloudLabs offer discounted pricing, when subscribing to annual plans. "]

{"sheet":"Supporting Data","index":1,"n_rows":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["This sheet contains refrence data for calculation. Please do not make any changes, that may break the calculator"]
[]
["VM SKU","Windows Hourly","Linux Hourly","Storage Hourly Cost","IP Address Hourly Cost"]
["Small_Standard_F2s_v2_StandardSSD_128GB",0.192,9.9000000000000005E-2,1.37142857142857E-2,2E-3]
["Medium \nStandard_F4s_v2_StandardSSD_256GB",0.33,0.17,2.7E-2,2E-3]
["Large/Standard Large \nStandard_F8s_v2_StandardSSD_256GB",0.65100000000000002,0.34,2.7E-2,2E-3]
["Medium - Nested virtualization \nStandard_D4s_v4_PremiumSSD_256GB",0.376,0.192,5.3999999999999999E-2,2E-3]
["Large - Nested virtualization \nStandard_D8s_v4_PremiumSSD_256GB",0.752,0.38400000000000001,5.3999999999999999E-2,2E-3]
["Small GPU - Compute \nStandard_NV8as_v4_StandardSSD_256GB",0.83399999999999996,"NA",2.7E-2,2E-3]
["Alternative Small GPU - Visualization \nStandard_NV6ads_A10_v5_StandardSSD_256GB",0.73,0.45400000000000001,2.7E-2,2E-3]
["Medium GPU - Visualization\nStandard_NV12s_v3_StandardSSD_256GB",1.6919999999999999,1.1399999999999999,2.7E-2,2E-3]
["Medium GPU - Accelerated Visualization Standard_NV6ads_A10_v5_StandardSSD_256GB",0.73,0.45400000000000001,2.7E-2,2E-3]
["Large GPU - Accelerated Visualization Standard_NV12ads_A10_v5_StandardSSD_256GB",1.46,0.90800000000000003,2.7E-2,2E-3]
[]
[]
[]
[]
[]
["VM OS List"]
["Windows"]
["Linux"]
[]
[]
[]
["Temporary Calculation Data","Calcualted Cost"]
["Selected VM SKU",{"$f":"'Calculate Here'!B6","v":"Small_Standard_F2s_v2_StandardSSD_128GB"}]
["Selected VM OS",{"$f":"'Calculate Here'!B7","v":"Windows"}]
["Selected Duration (Days)",{"$f":"'Calculate Here'!B9","v":30}]
["Selected Uptime (Hours)",{"$f":"'Calculate Here'!B10","v":40}]
["Total Uptime Based Hourly Calaulted",{"$f":"IF(B27=\"Windows\",\n     VLOOKUP(B26, $A$4:$E$11, MATCH(\"Windows Hourly\", $A$3:$E$3, 0), FALSE),\n     IF(B27=\"Linux\",\n        VLOOKUP(B26, $A$4:$E$11, MATCH(\"Linux Hourly\", $A$3:$E$3, 0), FALSE),\n        \"OS not found\")\n   )","v":0.192}]
["Total Storage Cost Hourly Calculated",{"$f":" VLOOKUP(B26, $A$4:$E$11, MATCH(\"Storage Hourly Cost\", $A$3:$E$3, 0), FALSE)","v":1.37142857142857E-2}]
["Total IP Address Cost Hourly Calculated",{"$f":" VLOOKUP(B26, $A$4:$E$11, MATCH(\"IP Address Hourly Cost\", $A$3:$E$3, 0), FALSE)","v":2E-3}]
["Total Cost",{"$f":"(B30*B29)+(B31*B28*24)+(B32*B28*24)","v":18.994285714285706}]
[]
[]
[]
[]
[]
["CloudLabs Platform Cost ",0.2]
["Bring your own Azure Subscription",12]
["CloudLabs Managed Azure Subscription",6]