{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["IoTA Pricing - Devices Based","IoTA Pricing - Data Based"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":16,"comments":2,"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":"IoTA Pricing - Devices Based","index":0,"n_rows":32,"n_cols":58,"rows_kept":32,"cut":false,"hidden":false,"merged":[[6,3,6,4],[6,7,6,8],[6,31,6,32],[6,36,6,37],[31,2,32,16],[31,30,32,45]]}
[]
[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,"Data storage",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,"Data storage"]
[null,null,null,"AWS IoT Analytics - Pricing Calculator   updated Feb 14, 2019",null,null,null,null,null,null,null,null,null,null,"Option 1 : Estimation using devices and their data",null,null,null,"Devices",10000,100000,1000000,null,null,"Data processing (GB)","Processed data (GB)","Raw data - S3","Query execution (TB)","Compute (ACU-Hours)",null,null,"AWS IoT Analytics - Pricing Calculator   updated Feb 01, 2019",null,null,null,null,null,null,null,null,null,null,null,"Option 2 : Estimation using data ingested",null,null,null,"Data (GB)",1,10,100,1000,null,"Data processing (GB)","Processed data (GB)","Raw data - S3","Query execution (TB)","Compute (ACU-Hours)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US East (N. Virginia)",0.2,0.03,"Ranges",6.5,0.36,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US East (N. Virginia)",0.2,0.03,"Ranges",6.5,0.36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimated Price    (USD)",null,null,null,null,"Devices",{"$f":"D7","v":500},null,null,null,"US East (Ohio)",0.2,0.03,"Ranges",6.5,0.36,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimated Price    (USD)",null,null,null,null,null,null,null,null,null,"US East (Ohio)",0.2,0.03,"Ranges",6.5,0.36]
[null,null,null,"# Devices sending data",null,null,null,"AWS Region",null,null,null,null,null,null,"Month",null,"Year",null,"Messages per device",{"$f":"F10","v":10764},null,"incoming raw data",null,"US West (Oregon)",0.2,0.03,"Ranges",6.5,0.36,null,null,"Data Ingested per Month (GB)",null,null,null,null,"AWS Region",null,null,null,null,null,null,"Month",null,"Year",null,"Raw data",{"$f":"AG16","v":1000},"GB","stored raw",null,"US West (Oregon)",0.2,0.03,"Ranges",6.5,0.36]
[null,null,null,500,null,null,null,"US East (N. Virginia)",null,null,null,null,null,"Total   ",{"$f":"Y19","v":344.04791592434049},null,{"$f":"Z19","v":7626.6433911547065},null,"Message size",{"$f":"F11","v":199510},"bytes",null,null,"EU (Ireland)",0.2,0.03,"Ranges",6.5,0.36,null,null,1000,null,null,null,null,"US East (N. Virginia)",null,null,null,null,null,"Total   ",{"$f":"BB20","v":344.04296875},null,{"$f":"BC20","v":7626.515625},null,"Processed data",{"$f":"AG18","v":1000},"GB","stored processed",null,"EU (Ireland)",0.2,0.03,"Ranges",6.5,0.36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Raw data",{"$f":"F16","v":1000.0195540487766},"GB","stored raw",null,"APAC (Tokyo)",0.26,0.04,"Ranges",8.4499999999999993,0.47,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pipeline processing",{"$f":"AG11","v":1000},"GB",null,null,"APAC (Tokyo)",0.26,0.04,"Ranges",8.4499999999999993,0.47]
[null,null,null,"Data Processing",null,null,null,null,{"$f":"Y14","v":200.00391080975533},null,null,null,null,null,null,null,null,null,"Processed message size",{"$f":"F11+G12-G13","v":199510},"bytes",null,null,"EU (Frankfurt)",0.2,0.03,"Ranges",6.5,0.36,null,null,"Data Processing",null,null,null,null,{"$f":"BB15","v":200},"per month",null,null,null,null,null,null,null,null,null,"Queries",{"$f":"AI23","v":30},null,null,null,"EU (Frankfurt)",0.2,0.03,"Ranges",6.5,0.36]
[null,null,null,"Each device sends ",null,10764,"messages per month",null,null,null,null,null,null,null,null,null,null,null,"Processed data",{"$f":"E18","v":1000.0195540487766},"GB",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,"Each scan",{"$f":"AI25","v":100},"GB"]
[null,null,null,"Each message size is",null,199510,"bytes",null,null,null,null,null,null,null,null,null,null,null,"Queries",{"$f":"G23","v":30},null,null,null,"Region","Price",null,null,null,null,null,null,"Sending",{"$f":"AF7","v":1000},"  GB per month to be processed in a pipeline",null,null,null,null,null,null,null,null,null,null,null,null,null,"Total data scanned",{"$f":"AW10*AW9/1024","v":2.9296875},"TB"]
[null,null,null,"I'll enrich each message with",null,null,500,"bytes per message",null,null,null,null,null,null,null,null,null,null,"Each scan",{"$f":"G25","v":100},"GB",null,null,{"$f":"H7","v":"US East (N. Virginia)"},{"$f":"VLOOKUP($X$12,$X$4:$AC$9,2,FALSE)","v":0.2},{"$f":"VLOOKUP($X$12,$X$4:$AC$9,3,FALSE)","v":0.03},{"$f":"VLOOKUP($X$12,$X$4:$AC$7,4,FALSE)","v":"Ranges"},{"$f":"VLOOKUP($X$12,$X$4:$AC$9,5,FALSE)","v":6.5},{"$f":"VLOOKUP($X$12,$X$4:$AC$9,6,FALSE)","v":0.36},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Compute ACU Hours",{"$f":"AL29*AI29","v":200},null,null,null,"Region","Price"]
[null,null,null,"I'll filter out",null,null,500,"bytes per message",null,null,null,null,null,null,null,null,null,null,"Total data scanned",{"$f":"(T11*T12)/1024","v":2.9296875},"TB",null,null,"Input",{"$f":"T8","v":1000.0195540487766},{"$f":"T10","v":1000.0195540487766},{"$f":"T8","v":1000.0195540487766},{"$f":"T13","v":2.9296875},{"$f":"T21","v":200},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AK7","v":"US East (N. Virginia)"},{"$f":"VLOOKUP($BA$13,$BA$4:$BF$9,2,FALSE)","v":0.2},{"$f":"VLOOKUP($BA$13,$BA$4:$BF$9,3,FALSE)","v":0.03},{"$f":"VLOOKUP($BA$13,$BA$4:$BF$9,4,FALSE)","v":"Ranges"},{"$f":"VLOOKUP($BA$13,$BA$4:$BF$9,5,FALSE)","v":6.5},{"$f":"VLOOKUP($BA$13,$BA$4:$BF$9,6,FALSE)","v":0.36}]
[null,null,null,"Data Storage",null,null,null,null,{"$f":"SUM(Z14:AA14)","v":53.001036364585161},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculated cost",{"$f":"Y13*Y12","v":200.00391080975533},{"$f":"Z13*Z12","v":30.000586621463299},{"$f":"VLOOKUP(T8,$X$23:$Z$25,3,TRUE)","v":23.000449743121862},19.04296875,{"$f":"AC12*AC13","v":72},null,null,"Data Storage",null,null,null,null,{"$f":"SUM(BC15:BD15)","v":53},"per month",null,null,null,null,null,null,null,null,null,"Raw data",1,{"$f":"AF7","v":1000},null,null,"Input",{"$f":"AW6","v":1000},{"$f":"AW7","v":1000},{"$f":"AW6","v":1000},{"$f":"AW11","v":2.9296875},{"$f":"AW12","v":200}]
[null,null,null,null,null,null,null,null,null,null,"Months",null,null,null,null,null,null,null,"messages","enrich","filter",null,null,"With Retention",null,{"$f":"((($K$18*$T$10)/2)*(1+$K$18)+(12-$K$18)*$K$18*$T$10)*$Z12","v":2340.0457564741373},{"$f":"((($K$18*$T$10)/2)*(1+$K$18)+(12-$K$18)*$K$18*$T$10)*VLOOKUP(T8,$X$23:$AA$25,4,TRUE)","v":1794.0350799635053},null,null,null,null,null,null,null,null,null,null,null,null,"Months",null,null,null,null,null,null,null,null,0.9,{"$f":"0.9*AF7","v":900},null,null,"Calculated cost",{"$f":"BB14*BB13","v":200},{"$f":"BC14*BC13","v":30},{"$f":"VLOOKUP(BD14,BA24:BC26,3,TRUE)","v":23},{"$f":"BE14*BE13","v":19.04296875},{"$f":"BF13*BF14","v":72}]
[null,null,null,"The devices will send",null,{"$f":"($D$7*$F$11*$F$10)/(1024^3)","v":1000.0195540487766},"  GB of raw data per month.",null,"Raw Data Retention",null,12,null,null,null,null,null,null,null,500,0,0,null,null,null,null,null,null,null,null,null,null,"I'll store",{"$f":"$AF$7","v":1000},"  GB of raw data per month.",null,null,null,"Raw Data Retention",null,12,null,null,null,null,null,null,null,null,0.75,{"$f":"0.75*AF7","v":750},null,null,"With Retention",null,{"$f":"((($AN$18*$AW$7)/2)*(1+$AN$18)+(12-$AN$18)*$AN$18*$AW$7)*$BC13","v":2340},{"$f":"((($AN$16*$AW$6)/2)*(1+$AN$16)+(12-$AN$16)*$AN$16*$AW$6)*VLOOKUP(BD14,BA24:BD26,4,TRUE)","v":1794}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,50,50,null,null,null,"Month","Year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.1000000000000001,{"$f":"1.1*AF7","v":1100}]
[null,null,null,"and",{"$f":"($D$7*$F$10*($F$11+$G$12-$G$13))/(1024^3)","v":1000.0195540487766},"  GB of processed data per month.",null,null,"Processed Data Retention",null,12,null,null,null,null,null,null,null,10000,100,100,null,null,"Per device",{"$f":"Y19/T5","v":0.68809583184868095},{"$f":"Z19/T5","v":15.253286782309413},null,null,null,null,null,"and",{"$f":"$AG$11","v":1000},"  GB of processed data per month.",null,null,null,"Processed Data Retention",null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,"Month","Year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100000,500,250,null,null,"Total",{"$f":"SUM(Y14:AC14)","v":344.04791592434049},{"$f":"SUM(Y14,AB14,AC14)*12+Z15+AA15","v":7626.6433911547065},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Processed data"]
[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,1,{"$f":"AF7","v":1000},null,null,"Total",{"$f":"SUM($BB15:$BF15)","v":344.04296875},{"$f":"(SUM($BB15,$BE15,$BF15)*12)+$BC16+$BD16","v":7626.515625}]
[null,null,null,"Query Execution",null,null,null,null,{"$f":"AB14","v":19.04296875},null,null,null,null,null,null,null,null,null,"Total Compute ACU Hours",{"$f":"J29*G29","v":200},null,null,null,null,null,null,null,null,null,null,null,"Query Execution",null,null,null,null,{"$f":"BE15","v":19.04296875},"per month",null,null,null,null,null,null,null,null,null,null,0.75,{"$f":"0.75*AF7","v":750}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Range 1","Range 2","Total Price","Price",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,{"$f":"0.5*AF7","v":500}]
[null,null,null,"Each month, I'll execute",null,null,30,"   queries",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,50000,{"$f":"T8*AA23","v":23.000449743121862},2.3E-2,null,null,null,null,"Each month, I'll execute",null,null,30,"   queries",null,null,null,null,null,null,null,null,null,null,null,null,1.25,{"$f":"1.25*AF7","v":1250},null,null,"Range 1","Range 2","Total Price","Price"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50000.000999999997,500000,{"$f":"AA23*Y23+AA24*(T8-Y23)","v":72.000430189073086},2.1999999999999999E-2,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,0,50000,{"$f":"AW6*BD24","v":23},2.3E-2]
[null,null,null,"Each query will scan",null,null,100,"   GB of data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500000.00099999999,{"$f":"5*10^12","v":5000000000000},{"$f":"AA23*Y23+AA24*450000+AA25*(T8-500000)","v":571.00041063502431},2.1000000000000001E-2,null,null,null,null,"Each query will scan",null,null,100,"   GB of data",null,null,null,null,null,null,null,null,null,null,null,"scanned <= processed data",null,null,null,null,50000.000999999997,500000,{"$f":"BD24*BB24+BD25*(AW6-BB24)","v":72},2.1999999999999999E-2]
[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,"can't scan more than data processed",null,null,null,null,500000.00099999999,{"$f":"5*10^12","v":5000000000000},{"$f":"BD24*BB24+BD25*450000+BD26*(AW6-500000)","v":571},2.1000000000000001E-2]
[null,null,null,"Custom Analysis Execution",null,null,null,null,{"$f":"AC14","v":72},null,null,null,null,null,null,null,null,null,"scanned <= processed data",null,null,null,null,null,null,null,null,null,null,null,null,"Custom Analysis Execution",null,null,null,null,{"$f":"BF15","v":72},null,null,null,null,null,null,null,null,null,null,"calculate S3 tiers based on monthly raw data"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"can't scan more than data processed"]
[null,null,null,"Each month, I'll execute my custom container using",null,null,2,"ACU","for",100,"hours",null,null,null,null,null,null,null,"calculate S3 tiers based on monthly raw data",null,null,null,null,null,null,null,null,null,null,null,null,"Each month, I'll execute my custom container using",null,null,2,"ACU","for",100,"hours"]
[]
[]
[null,null,"This Calculator provides an estimate of usage charges for AWS services based on certain information you provide. \nMonthly charges will be based on your actual usage of AWS services, and may vary from the estimates the Calculator has provided. \nPrices effective April 24, 2018.",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,"This Calculator provides an estimate of usage charges for AWS services based on certain information you provide. \nMonthly charges will be based on your actual usage of AWS services, and may vary from the estimates the Calculator has provided. \nPrices effective April 24, 2018."]

{"sheet":"IoTA Pricing - Data Based","index":1,"n_rows":32,"n_cols":58,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,2,32,16],[31,30,32,45],[6,31,6,32],[6,3,6,4],[6,7,6,8],[6,36,6,37]]}
[]
[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,"Data storage",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,"Data storage"]
[null,null,null,"AWS IoT Analytics - Pricing Calculator   updated Aug 23, 2018",null,null,null,null,null,null,null,null,null,null,"Option 1 : Estimation using devices and their data",null,null,null,"Devices",10000,100000,1000000,null,null,"Data processing (GB)","Processed data (GB)","Raw data - S3","Query execution (TB)","Compute (ACU-Hours)",null,null,"AWS IoT Analytics - Pricing Calculator   updated Feb 14, 2019",null,null,null,null,null,null,null,null,null,null,null,"Option 2 : Estimation using data ingested",null,null,null,"Data (GB)",1,10,100,1000,null,"Data processing (GB)","Processed data (GB)","Raw data - S3","Query execution (TB)","Compute (ACU-Hours)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US East (N. Virginia)",0.2,0.03,"Ranges",6.5,0.36,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US East (N. Virginia)",0.2,0.03,"Ranges",6.5,0.36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimated Price    (USD)",null,null,null,null,"Devices",{"$f":"D7","v":500},null,null,null,"US East (Ohio)",0.2,0.03,"Ranges",6.5,0.36,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimated Price    (USD)",null,null,null,null,null,null,null,null,null,"US East (Ohio)",0.2,0.03,"Ranges",6.5,0.36]
[null,null,null,"# Devices sending data",null,null,null,"AWS Region",null,null,null,null,null,null,"Month",null,"Year",null,"Messages per device",{"$f":"F10","v":10764},null,"incoming raw data",null,"US West (Oregon)",0.2,0.03,"Ranges",6.5,0.36,null,null,"Data Ingested per Month (GB)",null,null,null,null,"AWS Region",null,null,null,null,null,null,"Month",null,"Year",null,"Raw data",{"$f":"AG16","v":1000},"GB","stored raw",null,"US West (Oregon)",0.2,0.03,"Ranges",6.5,0.36]
[null,null,null,500,null,null,null,"US East (N. Virginia)",null,null,null,null,null,"Total   ",{"$f":"Y19","v":344.04791592434049},null,{"$f":"Z19","v":7626.6433911547065},null,"Message size",{"$f":"F11","v":199510},"bytes",null,null,"EU (Ireland)",0.2,0.03,"Ranges",6.5,0.36,null,null,1000,null,null,null,null,"US East (N. Virginia)",null,null,null,null,null,"Total   ",{"$f":"BB20","v":344.04296875},null,{"$f":"BC20","v":7626.515625},null,"Processed data",{"$f":"AG18","v":1000},"GB","stored processed",null,"EU (Ireland)",0.2,0.03,"Ranges",6.5,0.36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Raw data",{"$f":"F16","v":1000.0195540487766},"GB","stored raw",null,"APAC (Tokyo)",0.26,0.04,"Ranges",8.4499999999999993,0.47,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pipeline processing",{"$f":"AG11","v":1000},"GB",null,null,"APAC (Tokyo)",0.26,0.04,"Ranges",8.4499999999999993,0.47]
[null,null,null,"Data Processing",null,null,null,null,{"$f":"Y14","v":200.00391080975533},null,null,null,null,null,null,null,null,null,"Processed message size",{"$f":"F11+G12-G13","v":199510},"bytes",null,null,"EU (Frankfurt)",0.2,0.03,"Ranges",6.5,0.36,null,null,"Data Processing",null,null,null,null,{"$f":"BB15","v":200},"per month",null,null,null,null,null,null,null,null,null,"Queries",{"$f":"AI23","v":30},null,null,null,"EU (Frankfurt)",0.2,0.03,"Ranges",6.5,0.36]
[null,null,null,"Each device sends ",null,10764,"messages per month",null,null,null,null,null,null,null,null,null,null,null,"Processed data",{"$f":"E18","v":1000.0195540487766},"GB",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,"Each scan",{"$f":"AI25","v":100},"GB"]
[null,null,null,"Each message size is",null,199510,"bytes",null,null,null,null,null,null,null,null,null,null,null,"Queries",{"$f":"G23","v":30},null,null,null,"Region","Price",null,null,null,null,null,null,"Sending",{"$f":"AF7","v":1000},"  GB per month to be processed in a pipeline",null,null,null,null,null,null,null,null,null,null,null,null,null,"Total data scanned",{"$f":"AW10*AW9/1024","v":2.9296875},"TB"]
[null,null,null,"I'll enrich each message with",null,null,500,"bytes per message",null,null,null,null,null,null,null,null,null,null,"Each scan",{"$f":"G25","v":100},"GB",null,null,{"$f":"H7","v":"US East (N. Virginia)"},{"$f":"VLOOKUP($X$12,$X$4:$AC$9,2,FALSE)","v":0.2},{"$f":"VLOOKUP($X$12,$X$4:$AC$9,3,FALSE)","v":0.03},{"$f":"VLOOKUP($X$12,$X$4:$AC$7,4,FALSE)","v":"Ranges"},{"$f":"VLOOKUP($X$12,$X$4:$AC$9,5,FALSE)","v":6.5},{"$f":"VLOOKUP($X$12,$X$4:$AC$9,6,FALSE)","v":0.36},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Compute ACU Hours",{"$f":"AL29*AI29","v":200},null,null,null,"Region","Price"]
[null,null,null,"I'll filter out",null,null,500,"bytes per message",null,null,null,null,null,null,null,null,null,null,"Total data scanned",{"$f":"(T11*T12)/1024","v":2.9296875},"TB",null,null,"Input",{"$f":"T8","v":1000.0195540487766},{"$f":"T10","v":1000.0195540487766},{"$f":"T8","v":1000.0195540487766},{"$f":"T13","v":2.9296875},{"$f":"T21","v":200},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AK7","v":"US East (N. Virginia)"},{"$f":"VLOOKUP($BA$13,$BA$4:$BF$9,2,FALSE)","v":0.2},{"$f":"VLOOKUP($BA$13,$BA$4:$BF$9,3,FALSE)","v":0.03},{"$f":"VLOOKUP($BA$13,$BA$4:$BF$9,4,FALSE)","v":"Ranges"},{"$f":"VLOOKUP($BA$13,$BA$4:$BF$9,5,FALSE)","v":6.5},{"$f":"VLOOKUP($BA$13,$BA$4:$BF$9,6,FALSE)","v":0.36}]
[null,null,null,"Data Storage",null,null,null,null,{"$f":"SUM(Z14:AA14)","v":53.001036364585161},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculated cost",{"$f":"Y13*Y12","v":200.00391080975533},{"$f":"Z13*Z12","v":30.000586621463299},{"$f":"VLOOKUP(T8,$X$23:$Z$25,3,TRUE)","v":23.000449743121862},19.04296875,{"$f":"AC12*AC13","v":72},null,null,"Data Storage",null,null,null,null,{"$f":"SUM(BC15:BD15)","v":53},"per month",null,null,null,null,null,null,null,null,null,"Raw data",1,{"$f":"AF7","v":1000},null,null,"Input",{"$f":"AW6","v":1000},{"$f":"AW7","v":1000},{"$f":"AW6","v":1000},{"$f":"AW11","v":2.9296875},{"$f":"AW12","v":200}]
[null,null,null,null,null,null,null,null,null,null,"Months",null,null,null,null,null,null,null,"messages","enrich","filter",null,null,"With Retention",null,{"$f":"((($K$18*$T$10)/2)*(1+$K$18)+(12-$K$18)*$K$18*$T$10)*$Z12","v":2340.0457564741373},{"$f":"((($K$18*$T$10)/2)*(1+$K$18)+(12-$K$18)*$K$18*$T$10)*VLOOKUP(T8,$X$23:$AA$25,4,TRUE)","v":1794.0350799635053},null,null,null,null,null,null,null,null,null,null,null,null,"Months",null,null,null,null,null,null,null,null,0.9,{"$f":"0.9*AF7","v":900},null,null,"Calculated cost",{"$f":"BB14*BB13","v":200},{"$f":"BC14*BC13","v":30},{"$f":"VLOOKUP(BD14,BA24:BC26,3,TRUE)","v":23},{"$f":"BE14*BE13","v":19.04296875},{"$f":"BF13*BF14","v":72}]
[null,null,null,"The devices will send",null,{"$f":"($D$7*$F$11*$F$10)/(1024^3)","v":1000.0195540487766},"  GB of raw data per month.",null,"Raw Data Retention",null,12,null,null,null,null,null,null,null,500,0,0,null,null,null,null,null,null,null,null,null,null,"I'll store",{"$f":"$AF$7","v":1000},"  GB of raw data per month.",null,null,null,"Raw Data Retention",null,12,null,null,null,null,null,null,null,null,0.75,{"$f":"0.75*AF7","v":750},null,null,"With Retention",null,{"$f":"((($AN$18*$AW$7)/2)*(1+$AN$18)+(12-$AN$18)*$AN$18*$AW$7)*$BC13","v":2340},{"$f":"((($AN$16*$AW$6)/2)*(1+$AN$16)+(12-$AN$16)*$AN$16*$AW$6)*VLOOKUP(BD14,BA24:BD26,4,TRUE)","v":1794}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,50,50,null,null,null,"Month","Year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.1000000000000001,{"$f":"1.1*AF7","v":1100}]
[null,null,null,"and",{"$f":"($D$7*$F$10*($F$11+$G$12-$G$13))/(1024^3)","v":1000.0195540487766},"  GB of processed data per month.",null,null,"Processed Data Retention",null,12,null,null,null,null,null,null,null,10000,100,100,null,null,"Per device",{"$f":"Y19/T5","v":0.68809583184868095},{"$f":"Z19/T5","v":15.253286782309413},null,null,null,null,null,"and",{"$f":"$AG$11","v":1000},"  GB of processed data per month.",null,null,null,"Processed Data Retention",null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,"Month","Year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100000,500,250,null,null,"Total",{"$f":"SUM(Y14:AC14)","v":344.04791592434049},{"$f":"SUM(Y14,AB14,AC14)*12+Z15+AA15","v":7626.6433911547065},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Processed data"]
[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,1,{"$f":"AF7","v":1000},null,null,"Total",{"$f":"SUM($BB15:$BF15)","v":344.04296875},{"$f":"(SUM($BB15,$BE15,$BF15)*12)+$BC16+$BD16","v":7626.515625}]
[null,null,null,"Query Execution",null,null,null,null,{"$f":"AB14","v":19.04296875},null,null,null,null,null,null,null,null,null,"Total Compute ACU Hours",{"$f":"J29*G29","v":200},null,null,null,null,null,null,null,null,null,null,null,"Query Execution",null,null,null,null,{"$f":"BE15","v":19.04296875},"per month",null,null,null,null,null,null,null,null,null,null,0.75,{"$f":"0.75*AF7","v":750}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Range 1","Range 2","Total Price","Price",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,{"$f":"0.5*AF7","v":500}]
[null,null,null,"Each month, I'll execute",null,null,30,"   queries",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,50000,{"$f":"T8*AA23","v":23.000449743121862},2.3E-2,null,null,null,null,"Each month, I'll execute",null,null,30,"   queries",null,null,null,null,null,null,null,null,null,null,null,null,1.25,{"$f":"1.25*AF7","v":1250},null,null,"Range 1","Range 2","Total Price","Price"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50000.000999999997,500000,{"$f":"AA23*Y23+AA24*(T8-Y23)","v":72.000430189073086},2.1999999999999999E-2,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,0,50000,{"$f":"AW6*BD24","v":23},2.3E-2]
[null,null,null,"Each query will scan",null,null,100,"   GB of data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500000.00099999999,{"$f":"5*10^12","v":5000000000000},{"$f":"AA23*Y23+AA24*450000+AA25*(T8-500000)","v":571.00041063502431},2.1000000000000001E-2,null,null,null,null,"Each query will scan",null,null,100,"   GB of data",null,null,null,null,null,null,null,null,null,null,null,"scanned <= processed data",null,null,null,null,50000.000999999997,500000,{"$f":"BD24*BB24+BD25*(AW6-BB24)","v":72},2.1999999999999999E-2]
[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,"can't scan more than data processed",null,null,null,null,500000.00099999999,{"$f":"5*10^12","v":5000000000000},{"$f":"BD24*BB24+BD25*450000+BD26*(AW6-500000)","v":571},2.1000000000000001E-2]
[null,null,null,"Custom Analysis Execution",null,null,null,null,{"$f":"AC14","v":72},null,null,null,null,null,null,null,null,null,"scanned <= processed data",null,null,null,null,null,null,null,null,null,null,null,null,"Custom Analysis Execution",null,null,null,null,{"$f":"BF15","v":72},null,null,null,null,null,null,null,null,null,null,"calculate S3 tiers based on monthly raw data"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"can't scan more than data processed"]
[null,null,null,"Each month, I'll execute my custom container using",null,null,2,"ACU","for",100,"hours",null,null,null,null,null,null,null,"calculate S3 tiers based on monthly raw data",null,null,null,null,null,null,null,null,null,null,null,null,"Each month, I'll execute my custom container using",null,null,2,"ACU","for",100,"hours"]
[]
[]
[null,null,"This Calculator provides an estimate of usage charges for AWS services based on certain information you provide. \nMonthly charges will be based on your actual usage of AWS services, and may vary from the estimates the Calculator has provided. \nPrices effective April 24, 2018.",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,"This Calculator provides an estimate of usage charges for AWS services based on certain information you provide. \nMonthly charges will be based on your actual usage of AWS services, and may vary from the estimates the Calculator has provided. \nPrices effective April 24, 2018."]