{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Worksheet","Costs"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":38,"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":"Worksheet","index":0,"n_rows":256,"n_cols":9,"rows_kept":256,"cut":false,"hidden":false,"merged":[[163,2,164,3],[158,0,158,1],[107,2,122,3],[149,0,149,1],[156,0,156,1],[103,0,103,1],[105,0,105,1],[134,0,134,1],[136,0,136,1],[139,0,139,1],[146,0,146,1]]}
["Smarter Balanced Hosting Requirements Cost Calculation Spreadsheet Version 2"]
["2014-03-30"]
[]
["This spreadsheet models the hosting costs for a state wishing to deploy the Smarter Balanced open source system. The following assumptions apply:"]
[]
["1. Cloud deployment on Amazon Web Services (AWS) is assumed. AWS is selected because it is a ubiquitous, robust and full-featured cloud environment, but vendors are under no obligation to use AWS."]
["2. Deployment units are assumed as described in the accompanying Smarter Balanced Hosting Requirements document. These deployment configurations are preliminary and subject to change."]
["3. AWS pricing is valid as of 9 September 2013. AWS pricing is subject to change without notice."]
["4. User input is required about state information such as total and concurrent students and for technological input such as database overhead factors, AWS Availability Zones and instance types."]
["    The validity of the costs calculated by this spreadsheet are dependent on the validity of the inputs provided. Some of these inputs require some knowledge of the AWS infrastructure."]
["5. A single Test Registration and Administration deployment group is assumed here that will support multiple Test Delivery nodes. At this time, we are unsure that one single Test Registration and"]
["    Administration deployment group can be scaled sufficiently with AWS cloud resources alone to support a state as large as California."]
["6. This spreadsheet only encompasses the components being developed by Smarter Balanced Contract 11, Test Delivery System. Additional costs may be incurred by deployment of components from"]
["    other contracts such Item Authoring and Item Bank (RFP-07), Data Warehouse and Reporting (RFP-15) and Digital Library (RFP-23) that are not represented here."]
["7. In order for a state to deploy Test Delivery, all deployment groups in this spreadsheet are required except Assessment Creation and Management. A means of making thew Assessment"]
["    Creation and Management deployment group optional is provided for states that do not need this component."]
["8. This spreadsheet is primed with inputs consistent with the State of California as a model, and so assumes a worst-case scenario in terms of scale. Other states should input data specific to their needs."]
["9. The costs provided here are estimates based on the information provided and best information known at the time of writing. Actual results may differ somewhat from these estimates."]
["10. The costs calculated by this spreadsheet are strictly cloud-based infrastructure and support contract costs. They do not include staffing costs, management costs or any other incidental costs."]
[]
[]
["Please enter information in the green cells only. Information in the white cells automatically recalculate based on other settings"]
[]
["STATE INFORMATION"]
["The ratio of concurrent students to total students depends on the length of the testing window and other factors. This ratio is displayed to the right of the green input fields."]
[]
["Total number of students for Test Delivery",3400000]
["Maximum expected number of concurrent students",265229,null,"% concurrent students",{"$f":"B28/B27","v":7.8008529411764713E-2},"percent"]
[]
["TEST DELIVERY INFORMATION",null,null,null,null,null," "]
["These inputs provide information about the amount of expected traffic per student and the amount of students a single web server can handle. This is combined with the state information above.",null,null,null,null,null," "]
[]
["Number of assessments loaded into Test Delivery System",50]
["Average number of items per assessment",20]
["Average size of each item on disk in KB",800]
["Items per student per hour",20,null,"DB Server size",{"$f":"MAX(E37/10,MinTDStorage)","v":500},"GB"]
["Average KB per item",20,null,"Student DB Server IOPS",{"$f":"MAX(100,B28/AverageStudentsPerIops)","v":884.09666666666669},"Provisioned IOPS"]
["Maximum number of concurrent students per web server",8000,null,"Exam DB Server IOPS",{"$f":"CEILING(MAX(100,B28/AverageStudentsPerIops * 2.5), 1)","v":2211},"Provisioned IOPS"]
[]
[]
["TEST INTEGRATION & SCORING INFORMATION"]
[]
["Number of items",200000,null,"DB Size",{"$f":"MAX(CEILING(B43*B45*B44*B46*(100%+B47)/1024^2,1),MinTISStorage)","v":239},"GB"]
["Average size of an item in KB",20]
["Item Version Overhead (copy item assets for versioning)",5]
["Test Package overhead (items are replicated in packages)",10]
["Database overhead",0.25]
[]
["TEST REGISTATION AND ADMINISTRATION INFORMATION"]
["These inputs provide information about the amount of non-student users and data that is required for Test Registration."]
[]
["Average KB of registration information per student",50,null,"Data Transfer",{"$f":"CEILING(B27*B52*(100%+B53)*(100%+B54)*((B55*B56)/(24*365))*B57*B58/1025^2,1)","v":92},"GB/hr"]
["Multiplier for users and entities based on students",0.25,null,"DB Size",{"$f":"MAX(CEILING(B27*B52*(100%+B53)*(100%+B54)/1024^2,1),MinTRAStorage)","v":254},"GB"]
["Database overhead",0.25]
["Data upload hours per day",6]
["Data upload days",60]
["Data out multiplier (a factor to account for the number of times the data will be resent or the amount of incremental data sent)",4]
["Data Out Component Multiplier (data goes to Data Warehouse, partial data goes to Test Delivery and SSO",2.2000000000000002]
[]
["SSO INFORMATION"]
["Due to the critical nature of SSO, it is deployed in its own deployment group separate from any other shared service. The same is true for Monitoring and Alerting."]
[]
["Peak authentication per hour as a &% of total users",0.25,null,"Total number of users",{"$f":"B27*B53","v":850000},"Users"]
["size in KB of each authentication",50,null,"Peak authentications/hr",{"$f":"B63*E63","v":212500},"Authentications/hr"]
["DB overhead including session storage",0.5,null,"Data Transfer",{"$f":"CEILING(E64*B64/1025^2,1)","v":11},"GB/hr"]
[null,null,null,"DB Size",{"$f":"MAX(CEILING(E63*B64*(100%+B65)/1024^2,1),MinSSOStorage)","v":61},"GB"]
[]
["ASSESSMENT CREATION AND MANAGEMENT INFORMATION"]
["If Test Authoring is required in your deployment, select \"Yes\" otherwise select \"No\""]
[]
["Is Test Authoring required in your deployment?","Yes"]
[]
["SERVER INPUTS"]
[]
["Selected Amazon Availability Zone","N. Virginia"]
["Data Transfer Capacity Overhead",0.25]
[]
["Web Servers (EC2 load balancer and server instances)","Test Int & Scoring","Test Reg & Adm","SSO","Mon & Alerting","Shared Services","Assmt Creation & Mgmt"]
["Number of component groups",{"$f":"CEILING(B28/MaxConcurrentStudentsLegacy,1)","v":6},1,1,1,1,1]
["Number of load balancers",1,1,2,null,1,1]
["Data transfer GB per hour OUT",1,{"$f":"E52","v":92},{"$f":"E65","v":11},1,1,5]
["Web server instance type","m3.xlarge (GP)","c4.4xlarge (CO)","c4.8xlarge (CO)","No Web Server","m3.xlarge (GP)","m3.xlarge (GP)"]
["Number of baseline web servers",2,2,4,1,2,2,"GP=General Purpose"]
["Max number of on-demand web servers",1,1,0,null,2,1,"CO=Compute Optimized"]
["Hours per day of on-demand web server operation",16,16,8,null,10,16,"MO=Memory Optimized"]
["Number of days per year of on-demand web server operation",200,200,200,null,200,200,"SO=Storage Optimized"]
["Web Server Storage (per instance)"]
["Std EBS Storage (GB)"]
["Std EBS Storage I/O Requests (expected avg IOPS/sec)"]
["Std S3 Snapshot (GB)"]
["Std Prov IOPS EBS Storage (GB)",null,null,{"$f":"MAX(E66,MinSSOStorage)","v":61},250]
["Std Prov IOPS EBS Storage IOPs (IOPS/sec)",null,null,{"$f":"CEILING(D91*3,100)","v":200},750]
["Std Prov IOPS S3 Snapshot (GB)",null,null,{"$f":"D91*2","v":122},350]
["Database Server (single RDS instance)"]
["Database server instance type","db.m3.xlarge (DB-GP-MZ)","db.m3.xlarge (DB-GP-MZ)","No DB Server","No DB Server","db.m3.large (DB-GB-MZ)","db.m2.xl (DB-MO)","Legend"]
["Database Storage (single instance)",null,null,null,null,null,null,"DB-GP=Database, General Purpose"]
["DB Std EBS Storage",null,null,null,null,null,null,"DB-MO=Database, memory Optimized"]
["DB Std EBS Storage I/O Requests",null,null,null,null,null,null,"DB-GP-MZ=Databse, General Purpose, Multi-Availability Zone"]
["DB Prov IOPS EBS Storage",null,null,null,null,null,null,"DB-MO-MZ=Database, Memory Optimized, Multi-Availability Zone"]
["DB Prov IOPS EBS Storage IOPs"]
["DB MultiAZ Prov IOPS EBS Storage",{"$f":"E43","v":239},{"$f":"E53","v":254},null,null,100,1000]
["DB MultiAZ Prov IOPS EBS Storage IOPs",{"$f":"CEILING(B101*3,100)","v":800},{"$f":"CEILING(C101*3,100)","v":800},null,null,300,3000]
[]
["Test Delivery System Configuration"]
[]
["Kubernetes Cluster Environment"]
["Number of load balancers",1]
["Number of Kubernetes master nodes",1,"Note:  The master and worker nodes are AWS EC2 instances.  Since they are not physical servers, the service pods do not affect cost; they are hosted on the Kuberneetes worker nodes.  The pod quantities are shown to assist with deployment configuration."]
["Master node instance type","m3.xlarge (GP)"]
["Master node EBS storage in GB",20]
["Master node EBS Storage I/O Requests (expected average IOPS/sec)"]
["Master node S3 Snapshot in GB"]
["Master node Provisioned IOPS EBS Storage (GB)"]
["Master node Provisioned IOPS EBS Storage IOPS (IOPS/sec)"]
["Master node IOPS S3 Snapshot (GB)"]
["Number of Kubernetes worker nodes",{"$f":"CEILING(B28/MaxConcurrentStudents,1)","v":39}]
["Worker node instance type","m3.2xlarge (GP)"]
["Worker node EBS storage in GB",8]
["Worker node EBS Storage I/O Requests (expected average IOPS/sec)"]
["Worker node S3 Snapshot in GB"]
["Worker node Provisioned IOPS EBS Storage (GB)"]
["Worker node Provisioned IOPS EBS Storage IOPS (IOPS/sec)"]
["Worker node IOPS S3 Snapshot (GB)"]
["Number of Assessment Service pods",2]
["Number of Config Service pods",2]
["Number of Exam Service pods",{"$f":"CEILING(B28/MaxConcurrentStudentsExamService,1)","v":80}]
["Number of Exam Results Transmitter pods",2]
["Number of Session Service pods",2]
["Number of Student Service pods",2]
["Number of Proctor WAR application pods",{"$f":"CEILING(B28/MaxConcurrentStudentsProctorWar,1)","v":18}]
["Number of Student WAR application pods",{"$f":"CEILING(B28/MaxConcurrentStudentsStudentWar,1)","v":71}]
["Data transfer GB per hour OUT",{"$f":"CEILING(B28*B36*B37*(100%+DataCapacityOH)/1024^2, 1)","v":127}]
["Hours per day of environment operation",8]
["Days per year of environment operation",120]
["AWS Elasticache Redis Cluster"]
["Node type"]
["Student WAR Database Server"]
["Databse engine","MySQL"]
["Instance type","db.m3.large (DB-GB)"]
["Student WAR Database Server Storage"]
["DB Std EBS Storage"]
["DB Std EBS Storage I/O Requests"]
["DB Prov IOPS EBS Storage"]
["DB Prov IOPS EBS Storage IOPs"]
["DB MultiAZ Prov IOPS EBS Storage",{"$f":"E36","v":500}]
["DB MultiAZ Prov IOPS EBS Storage IOPs",{"$f":"E37","v":884.09666666666669}]
["Exam Service Database Server"]
["Databse engine","Aurora"]
["Instance type","db.r3.2xlarge"]
["Exam Service Database Server Storage"]
["DB Std EBS Storage"]
["DB Std EBS Storage I/O Requests"]
["DB Prov IOPS EBS Storage"]
["DB Prov IOPS EBS Storage IOPs"]
["DB MultiAZ Prov IOPS EBS Storage",{"$f":"E36","v":500}]
["DB MultiAZ Prov IOPS EBS Storage IOPs",{"$f":"E38","v":2211}]
["S3 Storage for Assessment Item Content"]
["Storage for Assessment Items in MB",{"$f":"B33*B34*B35/1024","v":781.25}]
["Centralized Logging"]
["Elastic Search master instance type","m4.large.elasticsearch  (GP)"]
["Number of Elastic Search master instances",3]
["Elastics Search data instance","m4.large.elasticsearch  (GP)"]
["Number of Elasticsearch data instances",3]
["Elasticsearch node EBS storage in GB (per instance)",400,"Note:  The master and data nodes are all configured to have the same amount of storage space"]
["Logstash node instances type ","c4.large (CO)"]
["Number of Logstash instances",3]
["LogStash node EBS storage in GB (per instance)",8]
["LogStash node EBS Storage I/O Requests (expected average IOPS/sec)"]
["LogStash node S3 Snapshot in GB (per instance)"]
["LogStash node Provisioned IOPS EBS Storage (GB) (per instance)"]
["LogStash node Provisioned IOPS EBS Storage IOPS (IOPS/sec) (per instance)"]
["LogStash node IOPS S3 Snapshot (GB) (per instance)"]
[]
["UNIT COSTS"]
["Unit costs","Test Delivery","Test Int & Scoring","Test Reg & Adm","SSO & Perm","Mon & Alerting","Shared Services","Assmt Creation & Mgmt","Units"]
["Load Balancer",{"$f":"IFERROR(VLOOKUP($A176,EC2costs,VLOOKUP(SelectedRegion,Region,2,FALSE),FALSE),0)","v":2.5000000000000001E-2},{"$f":"IFERROR(VLOOKUP($A176,EC2costs,VLOOKUP(SelectedRegion,Region,2,FALSE),FALSE),0)","v":2.5000000000000001E-2},2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,{"$f":"IFERROR(VLOOKUP($A176,EC2costs,5,FALSE),0)","v":"each"}]
["Load Balancer Data",8.0000000000000002E-3,8.0000000000000002E-3,8.0000000000000002E-3,8.0000000000000002E-3,8.0000000000000002E-3,8.0000000000000002E-3,8.0000000000000002E-3,{"$f":"IFERROR(VLOOKUP($A177,EC2costs,5,FALSE),0)","v":"GB/hour"}]
["Data Transfer Out",0.12,0.12,0.12,0.12,0.12,0.12,0.12,{"$f":"IFERROR(VLOOKUP($A178,EC2costs,5,FALSE),0)","v":"GB/hour"}]
["Web server","Not Applicable",{"$f":"IFERROR(VLOOKUP(B82,EC2costs,VLOOKUP(SelectedRegion,Region,2,FALSE),FALSE),0)","v":0.26600000000000001},{"$f":"IFERROR(VLOOKUP(C82,EC2costs,VLOOKUP(SelectedRegion,Region,2,FALSE),FALSE),0)","v":0.83799999999999997},{"$f":"IFERROR(VLOOKUP(D82,EC2costs,VLOOKUP(SelectedRegion,Region,2,FALSE),FALSE),0)","v":1.675},{"$f":"IFERROR(VLOOKUP(E82,EC2costs,VLOOKUP(SelectedRegion,Region,2,FALSE),FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(F82,EC2costs,VLOOKUP(SelectedRegion,Region,2,FALSE),FALSE),0)","v":0.26600000000000001},{"$f":"IFERROR(VLOOKUP(G82,EC2costs,VLOOKUP(SelectedRegion,Region,2,FALSE),FALSE),0)","v":0.26600000000000001},"each"]
["Kubernetes master node",{"$f":"IFERROR(VLOOKUP(B109,EC2costs,VLOOKUP(SelectedRegion,Region,2,FALSE),FALSE),0)","v":0.26600000000000001},"Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","each"]
["Kubernetes worker node",{"$f":"IFERROR(VLOOKUP(B117,EC2costs,VLOOKUP(SelectedRegion,Region,2,FALSE),FALSE),0)","v":0.53200000000000003},"Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","each"]
["Std EBS Storage",{"$f":"IFERROR(VLOOKUP($A182,EC2storagecosts,VLOOKUP(SelectedRegion,Region,2,FALSE),FALSE),0)","v":0.1},{"$f":"IFERROR(VLOOKUP($A182,EC2storagecosts,VLOOKUP(SelectedRegion,Region,2,FALSE),FALSE),0)","v":0.1},0.1,0.1,0.1,0.1,0.1,{"$f":"IFERROR(VLOOKUP($A182,EC2storagecosts,5,FALSE),0)","v":"GB"}]
["Std EBS Storage I/O Requests",0.05,0.05,0.05,0.05,0.05,0.05,0.05,"10^6 I/O Requests"]
["Std S3 Snapshot",9.5000000000000001E-2,9.5000000000000001E-2,9.5000000000000001E-2,9.5000000000000001E-2,9.5000000000000001E-2,9.5000000000000001E-2,9.5000000000000001E-2,"GB"]
["Std Prov IOPS EBS Storage",0.125,0.125,0.125,0.125,0.125,0.125,0.125,"GB"]
["Std Prov IOPS EBS Storage IOPs",6.5000000000000002E-2,6.5000000000000002E-2,6.5000000000000002E-2,6.5000000000000002E-2,6.5000000000000002E-2,6.5000000000000002E-2,6.5000000000000002E-2,"Provisioned IOPS per sec"]
["Std Prov IOPS S3 Snapshot",9.5000000000000001E-2,9.5000000000000001E-2,9.5000000000000001E-2,9.5000000000000001E-2,9.5000000000000001E-2,9.5000000000000001E-2,9.5000000000000001E-2,"GB"]
["Database server","Not Applicable",{"$f":"IFERROR(VLOOKUP(B95,RDScosts,VLOOKUP(SelectedRegion,Region,2,FALSE),FALSE),0)","v":0.37},{"$f":"IFERROR(VLOOKUP(C95,RDScosts,VLOOKUP(SelectedRegion,Region,2,FALSE),FALSE),0)","v":0.37},{"$f":"IFERROR(VLOOKUP(D95,RDScosts,VLOOKUP(SelectedRegion,Region,2,FALSE),FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(E95,RDScosts,VLOOKUP(SelectedRegion,Region,2,FALSE),FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(F95,RDScosts,VLOOKUP(SelectedRegion,Region,2,FALSE),FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(G95,RDScosts,VLOOKUP(SelectedRegion,Region,2,FALSE),FALSE),0)","v":0.33},"each"]
["Student WAR Database server",{"$f":"IF(B$138=\"MySQL\", IFERROR(VLOOKUP(B139,RDScosts,VLOOKUP(SelectedRegion,Region,2,FALSE),FALSE),0), IFERROR(VLOOKUP(B139,RDSauroracosts,VLOOKUP(SelectedRegion,Region,2,FALSE),FALSE),0))","v":0.185},"Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","each"]
["Exam Service Database server",{"$f":"IF(B$148=\"MySQL\", IFERROR(VLOOKUP(B149,RDScosts,VLOOKUP(SelectedRegion,Region,2,FALSE),FALSE),0), IFERROR(VLOOKUP(B149,RDSauroracosts,VLOOKUP(SelectedRegion,Region,2,FALSE),FALSE),0))","v":1.1599999999999999},"Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","each"]
["DB Std EBS Storage",{"$f":"IFERROR(VLOOKUP($A191,RDSstoragecosts,VLOOKUP(SelectedRegion,Region,2,FALSE),FALSE),0)","v":0.115},{"$f":"IFERROR(VLOOKUP($A191,RDSstoragecosts,VLOOKUP(SelectedRegion,Region,2,FALSE),FALSE),0)","v":0.115},0.115,0.115,0.115,0.115,0.115,{"$f":"IFERROR(VLOOKUP($A191,RDSstoragecosts,5,FALSE),0)","v":"GB"}]
["DB Std EBS Storage I/O Requests",0.1,0.1,0.1,0.1,0.1,0.1,0.1,"Million I/O Requests"]
["DB Prov IOPS EBS Storage",0.125,0.125,0.125,0.125,0.125,0.125,0.125,"GB"]
["DB Prov IOPS EBS Storage IOPs",0.1,0.1,0.1,0.1,0.1,0.1,0.1,"Provisioned IOPS per sec"]
["DB MultiAZ Prov IOPS EBS Storage",0.25,0.25,0.25,0.25,0.25,0.25,0.25,"GB"]
["DB MultiAZ Prov IOPS EBS Storage IOPs",0.2,0.2,0.2,0.2,0.2,0.2,0.2,"Provisioned IOPS per sec"]
["Elasticsearch Provisioned IOPS EBS Storage",{"$f":"IFERROR(VLOOKUP($A197,ESstoragecosts,VLOOKUP(SelectedRegion,Region,2,FALSE),FALSE),0)","v":0.16900000000000001},"Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable",{"$f":"IFERROR(VLOOKUP($A197,ESstoragecosts,5,FALSE),0)","v":"GB"}]
["Elasticsearch Provisioned IOPS EBS Rate",{"$f":"IFERROR(VLOOKUP($A198,ESstoragecosts,VLOOKUP(SelectedRegion,Region,2,FALSE),FALSE),0)","v":8.7999999999999995E-2},"Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable",{"$f":"IFERROR(VLOOKUP($A198,ESstoragecosts,5,FALSE),0)","v":"Provisioned IOPS per month"}]
["CloudWatch Monitoring",{"$f":"IFERROR(VLOOKUP($A199,CloudwatchCosts,VLOOKUP(SelectedRegion,Region,2,FALSE),FALSE),0)","v":3.5},{"$f":"IFERROR(VLOOKUP($A199,CloudwatchCosts,VLOOKUP(SelectedRegion,Region,2,FALSE),FALSE),0)","v":3.5},3.5,3.5,3.5,3.5,3.5,0]
["Elastic Search master instance",{"$f":"IFERROR(VLOOKUP(B160,EScosts,VLOOKUP(SelectedRegion,Region,2,FALSE),FALSE),0)","v":0.151},"Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable"]
["Elastic Search data instance",{"$f":"IFERROR(VLOOKUP(B162,EScosts,VLOOKUP(SelectedRegion,Region,2,FALSE),FALSE),0)","v":0.151},"Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable"]
["Logstash/nginx node",{"$f":"IFERROR(VLOOKUP(B165,EC2costs,VLOOKUP(SelectedRegion,Region,2,FALSE),FALSE),0)","v":0.105},"Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable"]
[]
["On-demand web server utilization",{"$f":"(B133*B134)/(24*365)","v":0.1095890410958904},{"$f":"(B85*B86)/(24*365)","v":0.36529680365296802},{"$f":"(C85*C86)/(24*365)","v":0.36529680365296802},{"$f":"(D85*D86)/(24*365)","v":0.18264840182648401},{"$f":"(E85*E86)/(24*365)","v":0},{"$f":"(F85*F86)/(24*365)","v":0.22831050228310501},{"$f":"(G85*G86)/(24*365)","v":0.36529680365296802}]
["On-demand web server weighted utilization",{"$f":"(B133*B134)/(24*365)","v":0.1095890410958904},{"$f":"B84*C204","v":0.36529680365296802},{"$f":"C84*D204","v":0.36529680365296802},{"$f":"D84*E204","v":0},{"$f":"E84*F204","v":0},{"$f":"F84*G204","v":0.45662100456621002},{"$f":"G84*H204","v":0.36529680365296802}]
["Weighted utilization",{"$f":"SUM(B205:H205)/SUM(B84:G84)","v":0.33242009132420092}]
[]
["TOTAL COSTS PER MONTH"]
["Monthly Costs","Test Delivery","Test Int & Scoring","Test Reg & Adm","SSO","Mon & Alerting","Shared Services","Assmt Creation & Mgmt","Total"]
["Load balancer",{"$f":"CEILING(B107*(24*DaysPerMonth*B176)+(B132*B133*B134/12*(1+DataCapacityOH)*B177),0.01)","v":119.9},{"$f":"B$79*CEILING(B80*(24*DaysPerMonth*C176)+(B81*B85*B86/12*(1+DataCapacityOH)*C177),0.01)","v":125.82},{"$f":"C$79*CEILING(C80*(24*DaysPerMonth*D176)+(C81*C85*C86/12*(1+DataCapacityOH)*D177),0.01)","v":263.64},{"$f":"D$79*CEILING(D80*(24*DaysPerMonth*E176)+(D81*D85*D86/12*(1+DataCapacityOH)*E177),0.01)","v":51.27},{"$f":"E$79*CEILING(E80*(24*DaysPerMonth*F176)+(E81*E85*E86/12*(1+DataCapacityOH)*F177),0.01)","v":0},{"$f":"F$79*CEILING(F80*(24*DaysPerMonth*G176)+(F81*F85*F86/12*(1+DataCapacityOH)*G177),0.01)","v":19.97},{"$f":"IF(AssmtCreationMgmt=\"No\",0,G$79*CEILING(G80*(24*DaysPerMonth*H176)+(G81*G85*G86/12*(1+DataCapacityOH)*H177),0.01))","v":31.64},{"$f":"SUM(B210:H210)","v":612.24}]
["Data transfer out",{"$f":"CEILING(B132*B133*(B134/12)*B178,0.01)","v":1219.2},{"$f":"CEILING(B81*B85*(B86/12)*C178,0.01)","v":32},{"$f":"CEILING(C81*C85*(C86/12)*D178,0.01)","v":2944},{"$f":"CEILING(D81*D85*(D86/12)*E178,0.01)","v":176},{"$f":"CEILING(E81*E85*(E86/12)*F178,0.01)","v":0},{"$f":"CEILING(F81*F85*(F86/12)*G178,0.01)","v":20},{"$f":"IF(AssmtCreationMgmt=\"No\",0,CEILING(G81*G85*(G86/12)*H178,0.01))","v":160},4551.2]
["Baseline web server","Not Applicable",{"$f":"B$79*CEILING(B83*24*DaysPerMonth*C179,0.01)","v":2336.58},{"$f":"C$79*CEILING(C83*24*DaysPerMonth*D179,0.01)","v":1226.8399999999999},{"$f":"D$79*CEILING(D83*24*DaysPerMonth*E179,0.01)","v":4904.4000000000005},{"$f":"E$79*CEILING(E83*24*DaysPerMonth*F179,0.01)","v":0},{"$f":"F$79*CEILING(F83*24*DaysPerMonth*G179,0.01)","v":389.43},{"$f":"IF(AssmtCreationMgmt=\"No\",0,G$79*CEILING(G83*24*DaysPerMonth*H179,0.01))","v":389.43},9246.68]
["On-demand web server","Not Applicable",{"$f":"B$79*CEILING(B84*24*DaysPerMonth*((B85*B86)/(24*365))*C179,0.01)","v":426.78},{"$f":"C$79*CEILING(C84*24*DaysPerMonth*((C85*C86)/(24*365))*D179,0.01)","v":224.08},{"$f":"D$79*CEILING(D84*24*DaysPerMonth*((D85*D86)/(24*365))*E179,0.01)","v":0},{"$f":"E$79*CEILING(E84*24*DaysPerMonth*((E85*E86)/(24*365))*F179,0.01)","v":0},{"$f":"F$79*CEILING(F84*24*DaysPerMonth*((F85*F86)/(24*365))*G179,0.01)","v":88.91},{"$f":"IF(AssmtCreationMgmt=\"No\",0,G$79*CEILING(G84*24*DaysPerMonth*((G85*G86)/(24*365))*H179,0.01))","v":71.13},810.9]
["Kubernetes master node",{"$f":"CEILING(B108*24*DaysPerMonth*B180,0.01)","v":194.72},"Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable",{"$f":"B214","v":194.72}]
["Kubernetes worker node",{"$f":"CEILING(B116*24*DaysPerMonth*B181,0.01)","v":15187.54},"Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable",{"$f":"B215","v":15187.54}]
["Web server storage",{"$f":"CEILING(((B108*B110)+(B116*B118)*B182)+(B108*B111*B183*SecondsPerMonth/10^6)+(B116*B119*B183*SecondsPerMonth/10^6)+(B108*B112*B184)+(B116*B120*B184)+(B108*B113*B185)+(B116*B121*B185)+(B108*B114)+(B116*B122*B185)+(B108*B186)+(B116*B123*B186),0.01)","v":51.27},{"$f":"B$79*CEILING((B83+B84)*((B88*C182)+(B89*C183*SecondsPerMonth/10^6)+(B90*C184)+(B91*C185)+(B92*C186)+(B93*C187)),0.01)","v":0},{"$f":"C$79*CEILING((C83+C84)*((C88*D182)+(C89*D183*SecondsPerMonth/10^6)+(C90*D184)+(C91*D185)+(C92*D186)+(C93*D187)),0.01)","v":0},{"$f":"D$79*CEILING((D83+D84)*((D88*E182)+(D89*E183*SecondsPerMonth/10^6)+(D90*E184)+(D91*E185)+(D92*E186)+(D93*E187)),0.01)","v":128.86000000000001},{"$f":"E$79*CEILING((E83+E84)*((E88*F182)+(E89*F183*SecondsPerMonth/10^6)+(E90*F184)+(E91*F185)+(E92*F186)+(E93*F187)),0.01)","v":113.25},{"$f":"F$79*CEILING((F83+F84)*((F88*G182)+(F89*G183*SecondsPerMonth/10^6)+(F90*G184)+(F91*G185)+(F92*G186)+(F93*G187)),0.01)","v":0},{"$f":"IF(AssmtCreationMgmt=\"No\",0,G$79*CEILING((G83+G84)*((G88*H182)+(G89*H183*SecondsPerMonth/10^6)+(G90*H184)+(G91*H185)+(G92*H186)+(G93*H187)),0.01))","v":0},{"$f":"SUM(B216:H216)","v":293.38}]
["Database server","Not Applicable",{"$f":"B$79*CEILING(C188*24*DaysPerMonth,0.01)","v":1625.0400000000002},{"$f":"C$79*CEILING(D188*24*DaysPerMonth,0.01)","v":270.84000000000003},{"$f":"D$79*CEILING(E188*24*DaysPerMonth,0.01)","v":0},{"$f":"E$79*CEILING(F188*24*DaysPerMonth,0.01)","v":0},{"$f":"F$79*CEILING(G188*24*DaysPerMonth,0.01)","v":0},{"$f":"G$79*CEILING(H188*24*DaysPerMonth,0.01)","v":241.56},{"$f":"SUM(C217:H217)","v":2137.44}]
["Database server storage","Not Applicable",{"$f":"B$79*CEILING((B97*C191)+(B98*C192*SecondsPerMonth/1000000)+(B99*C193)+(B100*C194)+(B101*C195)+(B102*C196),0.01)","v":1318.5},{"$f":"C$79*CEILING((C97*D191)+(C98*D192*SecondsPerMonth/1000000)+(C99*D193)+(C100*D194)+(C101*D195)+(C102*D196),0.01)","v":223.5},{"$f":"D$79*CEILING((D97*E191)+(D98*E192*SecondsPerMonth/1000000)+(D99*E193)+(D100*E194)+(D101*E195)+(D102*E196),0.01)","v":0},{"$f":"E$79*CEILING((E97*F191)+(E98*F192*SecondsPerMonth/1000000)+(E99*F193)+(E100*F194)+(E101*F195)+(E102*F196),0.01)","v":0},{"$f":"F$79*CEILING((F97*G191)+(F98*G192*SecondsPerMonth/1000000)+(F99*G193)+(F100*G194)+(F101*G195)+(F102*G196),0.01)","v":85},{"$f":"G$79*CEILING((G97*H191)+(G98*H192*SecondsPerMonth/1000000)+(G99*H193)+(G100*H194)+(G101*H195)+(G102*H196),0.01)","v":850},{"$f":"SUM(C218:H218)","v":2477}]
["Student WAR Database server",{"$f":"CEILING(B189*24*DaysPerMonth,0.01)","v":135.42000000000002},"Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable",135.42000000000002]
["Student WAR Database server storage",{"$f":"CEILING((B141*B191)+(B142*B192*SecondsPerMonth/1000000)+(B143*B193)+(B144*B194)+(B145*B195)+(B146*B196),0.01)","v":301.82},"Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable",301.82]
["Exam Database server",{"$f":"CEILING(B190*24*DaysPerMonth,0.01)","v":849.12},"Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable",{"$f":"SUM(B221:H221)","v":849.12}]
["Exam Database server storage",{"$f":"CEILING((B151*B191)+(B152*B192*SecondsPerMonth/1000000)+(B153*B193)+(B154*B194)+(B155*B195)+(B156*B196),0.01)","v":567.20000000000005},"Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable",567.20000000000005]
["CloudWatch Monitoring",{"$f":"CEILING((B108+B116)*B199,0.01)","v":140},{"$f":"B$79*CEILING((B83+B84)*C199,0.01)","v":63},{"$f":"C$79*CEILING((C83+C84)*D199,0.01)","v":10.5},{"$f":"D$79*CEILING((D83+D84)*E199,0.01)","v":14},{"$f":"E$79*CEILING((E83+E84)*F199,0.01)","v":3.5},{"$f":"F$79*CEILING((F83+F84)*G199,0.01)","v":14},{"$f":"IF(AssmtCreationMgmt=\"No\",0,G$79*CEILING((G83+G84)*H199,0.01))","v":10.5},255.5]
["Elastic Search master ",{"$f":"CEILING(B161*24*DaysPerMonth*B200,0.01)","v":331.6},"Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable",{"$f":"B224","v":331.6}]
["Elastic Search data ",{"$f":"CEILING(B163*24*DaysPerMonth*B201,0.01)","v":331.6},"Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable",{"$f":"B225","v":331.6}]
["Logstash server",{"$f":"CEILING(B166*24*DaysPerMonth*B202,0.01)","v":230.58},"Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable",{"$f":"B226","v":230.58}]
["LogStash server storage",{"$f":"B$166*CEILING((B167*B182)+(B168*B183*SecondsPerMonth/10^6)+(B169*B184)+(B170*B185)+(B171*B186)+(B172*B187),0.01)","v":2.4000000000000004},"Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable",{"$f":"B227","v":2.4000000000000004}]
["Elasticserach cluster storage",{"$f":"(B161+B163)*CEILING((B164*B197)+(B164*B198*DaysPerMonth),0.01)","v":6847.2000000000007},"Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable",{"$f":"B228","v":6847.2000000000007}]
["Subtotal",{"$f":"SUM(B210:B228)","v":26509.57},{"$f":"SUM(C210:C228)","v":5927.72},{"$f":"SUM(D210:D228)","v":5163.3999999999996},{"$f":"SUM(E210:E228)","v":5274.5300000000007},{"$f":"SUM(F210:F228)","v":116.75},{"$f":"SUM(G210:G228)","v":617.30999999999995},{"$f":"SUM(H210:H228)","v":1754.26},{"$f":"SUM(I210:I228)","v":45363.539999999994}]
["AWS Support Costs",null,null,null,null,null,null,null,{"$f":"CEILING(I229*VLOOKUP(I229,SupportCost,2,TRUE),0.01)","v":4536.3599999999997}]
["Ubuntu Cloud Support Costs",null,null,null,null,null,null,null,{"$f":"CEILING(UbuntuSupportCost/12,0.01)","v":6250}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I229:I231)","v":56149.899999999994}]
[]
["TOTAL COSTS PER YEAR"]
["Monthly Costs","Test Delivery","Test Int & Scoring","Test Reg & Adm","SSO & Perm","Mon & Alerting","Shared Services","Assmt Creation & Mgmt","Total"]
["Load balancer",{"$f":"B210*12","v":1438.8000000000002},{"$f":"C210*12","v":1509.84},{"$f":"D210*12","v":3163.68},{"$f":"E210*12","v":615.24},{"$f":"F210*12","v":0},{"$f":"G210*12","v":239.64},{"$f":"H210*12","v":379.68},{"$f":"I210*12","v":7346.88}]
["Data transfer out",{"$f":"B211*12","v":14630.400000000001},{"$f":"C211*12","v":384},{"$f":"D211*12","v":35328},{"$f":"E211*12","v":2112},{"$f":"F211*12","v":0},{"$f":"G211*12","v":240},{"$f":"H211*12","v":1920},{"$f":"I211*12","v":54614.399999999994}]
["Baseline web server","Not Applicable",{"$f":"C212*12","v":28038.959999999999},{"$f":"D212*12","v":14722.079999999998},{"$f":"E212*12","v":58852.800000000003},{"$f":"F212*12","v":0},{"$f":"G212*12","v":4673.16},{"$f":"H212*12","v":4673.16},{"$f":"I212*12","v":110960.16}]
["On-demand web server","Not Applicable",{"$f":"C213*12","v":5121.3599999999997},{"$f":"D213*12","v":2688.96},{"$f":"E213*12","v":0},{"$f":"F213*12","v":0},{"$f":"G213*12","v":1066.92},{"$f":"H213*12","v":853.56},{"$f":"I213*12","v":9730.7999999999993}]
["Kubernetes master node",{"$f":"B214*12","v":2336.64},"Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable",{"$f":"B240","v":2336.64}]
["Kubernetes worker node",{"$f":"B215*12","v":182250.48},"Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable",{"$f":"B241","v":182250.48}]
["Web server storage",{"$f":"B216*12","v":615.24},{"$f":"C216*12","v":0},0,1546.3200000000002,1359,0,0,3520.56]
["Database server","Not Applicable",{"$f":"C218*12","v":15822},2682,0,0,1020,10200,29724]
["Student WAR Database server",{"$f":"B219*12","v":1625.0400000000002},"Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable",{"$f":"I218*12","v":29724}]
["Exam Service Database server",{"$f":"B221*12","v":10189.44},"Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable",{"$f":"I219*12","v":1625.0400000000002}]
["Database server storage","Not Applicable",{"$f":"C218*12","v":15822},2682,0,0,1020,10200,{"$f":"I219*12","v":1625.0400000000002}]
["Student WAR Database server storage",{"$f":"B220*12","v":3621.84},"Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable",{"$f":"I220*12","v":3621.84}]
["Exam Service Database server storage",{"$f":"B222*12","v":6806.4000000000005},"Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable",{"$f":"I220*12","v":3621.84}]
["CloudWatch Monitoring",{"$f":"B223*12","v":1680},{"$f":"C223*12","v":756},126,{"$f":"E223*12","v":168},{"$f":"F223*12","v":42},{"$f":"G223*12","v":168},126,{"$f":"I223*12","v":3066}]
["Elasticsearch cluster",{"$f":"(B224+B225+B228)*12","v":90124.800000000003},"Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable",{"$f":"B250","v":90124.800000000003}]
["Elasticsearch data node",{"$f":"B225*12","v":3979.2000000000003},"Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable",{"$f":"B251","v":3979.2000000000003}]
["Logstash node",{"$f":"B226*12","v":2766.96},"Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable",{"$f":"B252","v":2766.96}]
["Subtotal",{"$f":"SUM(B236:B252)","v":322065.24000000005},{"$f":"SUM(C236:C252)","v":67454.16},{"$f":"SUM(D236:D252)","v":61392.719999999994},{"$f":"SUM(E236:E252)","v":63294.36},{"$f":"SUM(F236:F252)","v":1401},{"$f":"SUM(G236:G252)","v":8427.7200000000012},{"$f":"SUM(H236:H252)","v":28352.400000000001},{"$f":"I229*12","v":544362.48}]
["AWS Support Costs",null,null,null,null,null,null,null,{"$f":"I230*12","v":54436.319999999992}]
["Ubuntu Cloud Support Costs",null,null,null,null,null,null,null,{"$f":"UbuntuSupportCost","v":75000}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I253:I255)","v":673798.79999999993}]

{"sheet":"Costs","index":1,"n_rows":150,"n_cols":17,"rows_kept":150,"cut":false,"hidden":false,"merged":[]}
["Region","Table column",null,null,null,null,null,null,null,null,null,"Category","Instance Type","N. Virginia","N. California","Oregon","Units"]
["N. Virginia",2,null,null,null,null,null,null,null,null,null,"No Web Server","No Web Server",0,0,0,"each"]
["N. California",3,null,null,null,null,null,null,null,null,null,"Data Transfer","Data Transfer Out",0.12,0.12,0.12,"GB/hour"]
["Oregon",4,null,null,null,null,null,null,null,null,null,"Load Balancer","Load Balancer",2.5000000000000001E-2,2.8000000000000001E-2,2.5000000000000001E-2,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"Load Balancer","Load Balancer Data",8.0000000000000002E-3,8.0000000000000002E-3,8.0000000000000002E-3,"GB/hour"]
["Ubuntu Support Costs","Percent",null,null,null,null,null,null,null,null,null,"EC2 General Purpose","m3.medium (GP)",6.7000000000000004E-2,7.6999999999999999E-2,6.7000000000000004E-2,"each"]
["Ubuntu Cloud Support Costs",75000,null,null,null,null,null,null,null,null,null,"EC2 General Purpose","m3.large (GP)",0.13300000000000001,0.154,0.13300000000000001,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"EC2 General Purpose","m3.xlarge (GP)",0.26600000000000001,0.308,0.26600000000000001,"each"]
["AWS Support Tiers","Percent",null,null,null,null,null,null,null,null,null,"EC2 General Purpose","m3.2xlarge (GP)",0.53200000000000003,0.61599999999999999,0.53200000000000003,"each"]
[0,0.1,null,null,null,null,null,null,null,null,null,"EC2 General Purpose","m4.large (GP)",0.12,0.14000000000000001,0.12,"each"]
[150000,7.0000000000000007E-2,null,null,null,null,null,null,null,null,null,"EC2 General Purpose","m4.xlarge (GP)",0.23899999999999999,0.27900000000000003,0.23899999999999999,"each"]
[500000,0.05,null,null,null,null,null,null,null,null,null,"EC2 General Purpose","m4.2xlarge (GP)",0.47899999999999998,0.55900000000000005,0.47899999999999998,"each"]
[1000000,0.03,null,null,null,null,null,null,null,null,null,"EC2 General Purpose","m4.4xlarge (GP)",0.95799999999999996,1.117,0.95799999999999996,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"EC2 General Purpose","m4.10xlarge (GP)",2.3940000000000001,2.7930000000000001,2.3940000000000001,"each"]
["Storage Type","Cost GB/mo",null,null,null,null,null,null,null,null,null,"EC2 Compute Optimized","c3.large (CO)",0.105,0.12,0.105,"each"]
["EBS Standard",0.1,null,null,null,null,null,null,null,null,null,"EC2 Compute Optimized","c3.xlarge (CO)",0.21,0.23899999999999999,0.21,"each"]
["EBS Provisioned IOPS",0.125,null,null,null,null,null,null,null,null,null,"EC2 Compute Optimized","c3.2xlarge (CO)",0.42,0.47799999999999998,0.42,"each"]
["EBS Snapshot to EC3",9.5000000000000001E-2,null,null,null,null,null,null,null,null,null,"EC2 Compute Optimized","c3.4xlarge (CO)",0.84,0.95599999999999996,0.84,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"EC2 Compute Optimized","c3.8xlarge (CO)",1.68,1.9119999999999999,1.68,"each"]
["Seconds per month","Percent","Million I/O",null,null,null,null,null,null,null,null,"EC2 Compute Optimized","c4.large (CO)",0.105,0.13100000000000001,0.105,"each"]
["Days per month",30.5,0.1,null,null,null,null,null,null,null,null,"EC2 Compute Optimized","c4.xlarge (CO)",0.20899999999999999,0.26200000000000001,0.20899999999999999,"each"]
["Seconds per month",{"$f":"ROUND(60*60*24*30.5,0)","v":2635200},0.1,null,null,null,null,null,null,null,null,"EC2 Compute Optimized","c4.2xlarge (CO)",0.41899999999999998,0.52400000000000002,0.41899999999999998,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"EC2 Compute Optimized","c4.4xlarge (CO)",0.83799999999999997,1.0489999999999999,0.83799999999999997,"each"]
["Maximum number of concurrent students","Number","Legacy Number",null,null,null,null,null,null,null,null,"EC2 Compute Optimized","c4.8xlarge (CO)",1.675,2.0979999999999999,1.675,"each"]
["Maximum number of concurrent students",6850,45000,null,null,null,null,null,null,null,null,"EC2 Memory Optimized","r3.large (MO)",0.16600000000000001,0.185,0.16600000000000001,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"EC2 Memory Optimized","r3.xlarge (MO)",0.33300000000000002,0.371,0.33300000000000002,"each"]
["Minimum Test Delivery Database Server Storage","Number",null,null,null,null,null,null,null,null,null,"EC2 Memory Optimized","r3.2xlarge (MO)",0.66500000000000004,0.74099999999999999,0.66500000000000004,"each"]
["Minimum Test Delivery Database Server Storage",500,null,null,null,null,null,null,null,null,null,"EC2 Memory Optimized","r3.4xlarge (MO)",1.33,1.482,1.33,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"EC2 Memory Optimized","r3.8xlarge (MO)",2.66,2.964,2.66,"each"]
["Minimum Test Integration and Scoring Database Server Storage","Number",null,null,null,null,null,null,null,null,null,"EC2 Storage Optimized","i2.xlarge (SO)",0.85299999999999998,0.93799999999999994,0.85299999999999998,"each"]
["Minimum Test Integration and Scoring Database Server Storage",100,null,null,null,null,null,null,null,null,null,"EC2 Storage Optimized","i2.2xlarge (SO)",1.7050000000000001,1.8759999999999999,1.7050000000000001,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"EC2 Storage Optimized","i2.4xlarge (SO)",3.41,3.7509999999999999,3.41,"each"]
["Minimum Test Registration and Administraton Database Server Storage","Number",null,null,null,null,null,null,null,null,null,"EC2 Storage Optimized","i2.8xlarge (SO)",6.82,7.5019999999999998,6.82,"each"]
["Minimum Test Registration and Administraton Database Server Storage",100]
[null,null,null,null,null,null,null,null,null,null,null,"EBS Storage","Std EBS Storage",0.1,0.12,0.1,"GB"]
["Minimum Single Sign-On Database Server Storage","Number",null,null,null,null,null,null,null,null,null,"EBS Storage","Std EBS Storage I/O Requests",0.05,0.08,0.05,"10^6 I/O Requests"]
["Minimum Single Sign-On Database Server Storage",50,null,null,null,null,null,null,null,null,null,"EBS Storage","Std S3 Snapshot",9.5000000000000001E-2,0.105,9.5000000000000001E-2,"GB"]
[null,null,null,null,null,null,null,null,null,null,null,"EBS Storage","Std Prov IOPS EBS Storage",0.125,0.13800000000000001,0.125,"GB"]
["Yes/No List",null,null,null,null,null,null,null,null,null,null,"EBS Storage","Std Prov IOPS EBS Storage IOPs",6.5000000000000002E-2,7.1999999999999995E-2,6.5000000000000002E-2,"Provisioned IOPS per sec"]
[null,"Yes",null,null,null,null,null,null,null,null,null,"EBS Storage","Std Prov IOPS S3 Snapshot",9.5000000000000001E-2,0.105,9.5000000000000001E-2,"GB"]
[null,"No"]
[null,null,null,null,null,null,null,null,null,null,null,"No DB Server","No DB Server",0,0,0,"each"]
["Database Engine List",null,null,null,null,null,null,null,null,null,null,"RDS Instance","db.m3.medium (DB-GP)",0.09,9.5000000000000001E-2,0.09,"each"]
["MySQL",null,null,null,null,null,null,null,null,null,null,"RDS Instance","db.m3.large (DB-GB)",0.185,0.2,0.185,"each"]
["Aurora",null,null,null,null,null,null,null,null,null,null,"RDS Instance","db.m3.xlarge (DB-GP)",0.37,0.4,0.37,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Instance","db.m3.2xlarge (DB-GP)",0.74,0.79500000000000004,0.74,"each"]
["Maximum number of concurrent students per pod","Number",null,null,null,null,null,null,null,null,null,"RDS Instance","db.m4.large (DB-GP)",0.17499999999999999,0.20399999999999999,0.17499999999999999,"each"]
["Student WAR",3750,null,null,null,null,null,null,null,null,null,"RDS Instance","db.m4.xlarge (DB-GP)",0.35,0.40799999999999997,0.35,"each"]
["Proctor WAR",15000,null,null,null,null,null,null,null,null,null,"RDS Instance","db.m4.2xlarge (DB-GP)",0.7,0.81699999999999995,0.7,"each"]
["Exam Service",3333,null,null,null,null,null,null,null,null,null,"RDS Instance","db.m4.4xlarge (DB-GP)",1.401,1.6339999999999999,1.401,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Instance","db.m4.10xlarge (DB-GP)",3.5019999999999998,4.0860000000000003,3.5019999999999998,"each"]
["Average number of students per IOPS","Number",null,null,null,null,null,null,null,null,null,"RDS Instance","db.r3.large (DB-MO)",0.24,0.26500000000000001,0.24,"each"]
[null,300,null,null,null,null,null,null,null,null,null,"RDS Instance","db.r3.xlarge (DB-MO)",0.47499999999999998,0.53,0.47499999999999998,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Instance","db.r3.2xlarge (DB-MO)",0.94499999999999995,1.0549999999999999,0.94499999999999995,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Instance","db.r3.4xlarge (DB-MO)",1.89,2.11,1.89,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Instance","db.r3.8xlarge (DB-MO)",3.78,4.2149999999999999,3.78,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Instance","db.m2.xl (DB-MO)",0.33,0.36,0.33,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Instance","db.m2.2xl (DB-MO)",0.66,0.72,0.66,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Instance","db.m2.4xl (DB-MO)",1.32,1.44,1.32,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Instance","db.cr1.8xl (DB-MO)",4.7249999999999996,"N/A",4.7249999999999996,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Instance","db.m3.medium (DB-GP-MZ)",0.9,9.5000000000000001E-2,0.9,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Instance","db.m3.large (DB-GP-MZ)",0.185,0.2,0.185,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Instance","db.m3.xlarge (DB-GP-MZ)",0.37,0.4,0.37,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Instance","db.m3.2xlarge (DB-GP-MZ)",0.74,0.79500000000000004,0.74,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Instance","db.m4.large (DB-GP-MZ)",0.35,0.40799999999999997,0.35,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Instance","db.m4.xlarge (DB-GP-MZ)",0.7,0.81599999999999995,0.7,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Instance","db.m4.2xlarge (DB-GP-MZ)",1.4,1.6339999999999999,1.4,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Instance","db.m4.4xlarge (DB-GP-MZ)",2.802,3.2679999999999998,2.802,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Instance","db.m4.10xlarge (DB-GP-MZ)",7.0039999999999996,8.1720000000000006,7.0039999999999996,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Instance","db.r3.large (DB-MO-MZ)",0.48,0.53,0.48,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Instance","db.r3.xlarge (DB-MO-MZ)",0.95,1.06,0.95,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Instance","db.r3.2xlarge (DB-MO-MZ)",1.89,2.11,1.89,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Instance","db.r3.4xlarge (DB-MO-MZ)",3.78,4.22,3.78,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Instance","db.r3.8xlarge (DB-MO-MZ)",7.56,8.43,7.56,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Instance","db.m2.xl (DB-MO-MZ)",0.66,0.72,0.66,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Instance","db.m2.2xl (DB-MO-MZ)",1.32,1.44,1.32,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Instance","db.m2.4xl (DB-MO-MZ)",2.64,2.88,2.64,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Instance","db.cr1.8xl (DB-MO-MZ)",8.0350000000000001,"N/A",8.0350000000000001,"each"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Storage","DB Std EBS Storage",0.115,0.13800000000000001,0.115,"GB"]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Storage","DB Std EBS Storage I/O Requests",0.1,0.11,0.1,"Million I/O Requests"]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Storage","DB Prov IOPS EBS Storage",0.125,0.13800000000000001,0.125,"GB"]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Storage","DB Prov IOPS EBS Storage IOPs",0.1,0.11,0.1,"Provisioned IOPS per sec"]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Storage","DB MultiAZ Prov IOPS EBS Storage",0.25,0.27600000000000002,0.25,"GB"]
[null,null,null,null,null,null,null,null,null,null,null,"RDS Storage","DB MultiAZ Prov IOPS EBS Storage IOPs",0.2,0.22,0.2,"Provisioned IOPS per sec"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"CloudWatch Monitoring","CloudWatch Monitoring",3.5,3.5,3.5,"Provisioned IOPS per sec"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Elasticach Instance Type","No Cache Server",0,0,0,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"Elasticach Instance Type","cache.t2.micro (GP)",1.7000000000000001E-2,2.1999999999999999E-2,1.7000000000000001E-2,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"Elasticach Instance Type","cache.t2.small (GP)",3.4000000000000002E-2,4.3999999999999997E-2,3.4000000000000002E-2,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"Elasticach Instance Type","cache.t2.medium (GP)",6.8000000000000005E-2,8.7999999999999995E-2,6.8000000000000005E-2,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"Elasticach Instance Type","cache.m3.medium (GP)",0.09,9.5000000000000001E-2,0.09,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"Elasticach Instance Type","cache.m3.large (GP)",0.182,0.2,0.182,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"Elasticach Instance Type","cache.m3.xlarge (GP)",0.36399999999999999,0.4,0.36399999999999999,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"Elasticach Instance Type","cache.m3.2xlarge (GP)",0.72799999999999998,0.79500000000000004,0.72799999999999998,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"Elasticach Instance Type","cache.m4.large (GP)",0.156,0.182,0.156,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"Elasticach Instance Type","cache.m4.xlarge (GP)",0.311,0.36299999999999999,0.311,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"Elasticach Instance Type","cache.m4.2xlarge (GP)",0.623,0.72699999999999998,0.623,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"Elasticach Instance Type","cache.m4.4xlarge (GP)",1.2450000000000001,1.452,1.2450000000000001,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"Elasticach Instance Type","cache.m4.10xlarge (GP)",3.1120000000000001,3.6309999999999998,3.1120000000000001,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"Elasticach Instance Type","cache.r3.large (MO)",0.22800000000000001,0.254,0.22800000000000001,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"Elasticach Instance Type","cache.r3.xlarge (MO)",0.45500000000000002,0.50700000000000001,0.45500000000000002,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"Elasticach Instance Type","cache.r3.2xlarge (MO)",0.91,1.014,0.91,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"Elasticach Instance Type","cache.r3.4xlarge (MO)",1.82,2.028,1.82,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"Elasticach Instance Type","cache.43.8xlarge (MO)",3.64,4.056,3.64,"each"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"No DB Server","No DB Server",0,0,0,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"Aurora Instance","db.t2.small",4.1000000000000002E-2,5.2999999999999999E-2,4.1000000000000002E-2,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"Aurora Instance","db.t2.medium",8.2000000000000003E-2,0.106,8.2000000000000003E-2,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"Aurora Instance","db.r3.large",0.28999999999999998,0.32,0.28999999999999998,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"Aurora Instance","db.r3.xlarge",0.57999999999999996,0.64,0.57999999999999996,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"Aurora Instance","db.r3.2xlarge",1.1599999999999999,1.28,1.1599999999999999,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"Aurora Instance","db.r3.4xlarge",2.3199999999999998,2.56,2.3199999999999998,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"Aurora Instance","db.r3.8xlarge",4.6399999999999997,5.12,4.6399999999999997,"each"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"ES General Purpose","t2.micro.elasticsearch (GP)",1.7999999999999999E-2,2.4E-2,1.7999999999999999E-2,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"ES General Purpose","t2.small.elasticsearch  (GP)",3.5999999999999997E-2,4.8000000000000001E-2,3.5999999999999997E-2,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"ES General Purpose","t2.medium.elasticsearch  (GP)",7.2999999999999995E-2,9.5000000000000001E-2,7.2999999999999995E-2,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"ES General Purpose","m3.medium.elasticsearch  (GP)",9.4E-2,0.108,9.4E-2,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"ES General Purpose","m3.large.elasticsearch  (GP)",0.188,0.216,0.188,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"ES General Purpose","m3.xlarge.elasticsearch  (GP)",0.376,0.432,0.376,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"ES General Purpose","m3.2xlarge.elasticsearch  (GP)",0.752,0.86399999999999999,0.752,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"ES General Purpose","m4.large.elasticsearch  (GP)",0.151,0.17599999999999999,0.151,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"ES General Purpose","m4.xlarge.elasticsearch  (GP)",0.30099999999999999,0.35099999999999998,0.30099999999999999,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"ES General Purpose","m4.2xlarge.elasticsearch  (GP)",0.60299999999999998,0.70399999999999996,0.60299999999999998,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"ES General Purpose","m4.4xlarge.elasticsearch  (GP)",1.2070000000000001,1.407,1.2070000000000001,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"ES General Purpose","m4.10xlarge.elasticsearch  (GP)",3.0169999999999999,3.52,3.0169999999999999,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"ES Compute Optimized","c4.large.elasticsearch (CO)",0.14799999999999999,0.183,0.14799999999999999,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"ES Compute Optimized","c4.xlarge.elasticsearch (CO)",0.29399999999999998,0.36699999999999999,0.29399999999999998,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"ES Compute Optimized","c4.2xlarge.elasticsearch (CO)",0.58699999999999997,0.73499999999999999,0.58699999999999997,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"ES Compute Optimized","c4.4xlarge.elasticsearch (CO)",1.1739999999999999,1.4710000000000001,1.1739999999999999,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"ES Compute Optimized","c4.8xlarge.elasticsearch (CO)",2.347,2.94,2.347,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"ES Memory Optimized","r3.large.elasticsearch (MO)",0.245,0.27300000000000002,0.245,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"ES Memory Optimized","r3.xlarge.elasticsearch (MO)",0.49,0.54600000000000004,0.49,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"ES Memory Optimized","r3.2xlarge.elasticsearch (MO)",0.98,1.0920000000000001,0.98,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"ES Memory Optimized","r3.4xlarge.elasticsearch (MO)",1.96,2.1840000000000002,1.96,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"ES Memory Optimized","r3.8xlarge.elasticsearch (MO)",3.92,4.3680000000000003,3.92,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"ES Memory Optimized","r4.large.elasticsearch (MO)",0.19600000000000001,0.218,0.19600000000000001,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"ES Memory Optimized","r4.xlarge.elasticsearch (MO)",0.39200000000000002,0.437,0.39200000000000002,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"ES Memory Optimized","r4.2xlarge.elasticsearch (MO)",0.78500000000000003,0.875,0.78500000000000003,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"ES Memory Optimized","r4.4xlarge.elasticsearch (MO)",1.5960000000000001,1.7490000000000001,1.5960000000000001,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"ES Memory Optimized","r4.8xlarge.elasticsearch (MO)",3.1389999999999998,3.4969999999999999,3.1389999999999998,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"ES Memory Optimized","r4.16xlarge.elasticsearch (MO)",6.2779999999999996,6.9939999999999998,6.2779999999999996,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"ES Storage Optimized","i2.xlarge.elasticsearch (SO)",1.194,1.3129999999999999,1.194,"each"]
[null,null,null,null,null,null,null,null,null,null,null,"ES Storage Optimized","i2.2xlarge.elasticsearch (SO)",2.387,2.6259999999999999,2.387,"each"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"ES Storage","Elasticsearch EBS Storage",0.13500000000000001,0.16200000000000001,0.13500000000000001,"GB"]
[null,null,null,null,null,null,null,null,null,null,null,"ES Storage","Elasticsearch Provisioned IOPS EBS Storage",0.16900000000000001,0.186,0.16900000000000001,"GB"]
[null,null,null,null,null,null,null,null,null,null,null,"ES Storage","Elasticsearch Provisioned IOPS EBS Rate",8.7999999999999995E-2,9.7000000000000003E-2,8.7999999999999995E-2,"Provisioned IOPS per month"]