{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["AWS IoT Pricing Calculator"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"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":"AWS IoT Pricing Calculator","index":0,"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 Aug 23, 2018",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":1000000},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":4320},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":12069940.567016602},"GB","stored raw",null,"US West (Oregon)",0.2,0.03,"Ranges",6.5,0.36]
[null,null,null,1000000,null,null,null,"US East (N. Virginia)",null,null,null,null,null,"Total   ",{"$f":"Y17","v":205250.68852424622},null,{"$f":"Z17","v":2463008.2622909546},null,"Message size",{"$f":"F11","v":200000},"bytes",null,null,"EU (Ireland)",0.2,0.03,"Ranges",6.5,0.36,null,null,12069940.567016602,null,null,null,null,"US East (N. Virginia)",null,null,null,null,null,"Total   ",{"$f":"BB17","v":3032775.082321167},null,{"$f":"BC17","v":36393300.987854004},null,"Processed data",{"$f":"AG18","v":12069940.567016602},"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":804662.70446777344},"GB","stored raw",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,"Pipeline processing",{"$f":"AG11","v":12069940.567016602},"GB"]
[null,null,null,"Data Processing",null,null,null,null,{"$f":"Y12","v":160932.54089355469},null,null,null,null,null,null,null,null,null,"Processed message size",{"$f":"F11+G12-G13","v":200500},"bytes",null,null,"Region","Price",null,null,null,null,null,null,"Data Processing",null,null,null,null,{"$f":"BB12","v":2413988.1134033203},"per month",null,null,null,null,null,null,null,null,null,"Queries",{"$f":"AI23","v":30},null,null,null,"Region","Price"]
[null,null,null,"Each device sends ",null,4320,"messages per month",null,null,null,null,null,null,null,null,null,null,null,"Processed data",{"$f":"E18","v":806674.36122894287},"GB",null,null,{"$f":"H7","v":"US East (N. Virginia)"},{"$f":"VLOOKUP($X$10,$X$4:$AC$7,2,FALSE)","v":0.2},{"$f":"VLOOKUP($X$10,$X$4:$AC$7,3,FALSE)","v":0.03},{"$f":"VLOOKUP($X$10,$X$4:$AC$7,4,FALSE)","v":"Ranges"},{"$f":"VLOOKUP($X$10,$X$4:$AC$7,5,FALSE)","v":6.5},{"$f":"VLOOKUP($X$10,$X$4:$AC$7,6,FALSE)","v":0.36},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Each scan",{"$f":"AI25","v":10240},"GB",null,null,{"$f":"AK7","v":"US East (N. Virginia)"},{"$f":"VLOOKUP($BA$10,$BA$4:$BF$7,2,FALSE)","v":0.2},{"$f":"VLOOKUP($BA$10,$BA$4:$BF$7,3,FALSE)","v":0.03},{"$f":"VLOOKUP($BA$10,$BA$4:$BF$7,4,FALSE)","v":"Ranges"},{"$f":"VLOOKUP($BA$10,$BA$4:$BF$7,5,FALSE)","v":6.5},{"$f":"VLOOKUP($BA$10,$BA$4:$BF$7,6,FALSE)","v":0.36}]
[null,null,null,"Each message size is",null,200000,"bytes",null,null,null,null,null,null,null,null,null,null,null,"Queries",{"$f":"G23","v":30},null,null,null,"Input",{"$f":"T8","v":804662.70446777344},{"$f":"T10","v":806674.36122894287},{"$f":"T8","v":804662.70446777344},{"$f":"T13","v":300},{"$f":"T21","v":2000},null,null,"Sending",{"$f":"AF7","v":12069940.567016602},"  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":300},"TB",null,null,"Input",{"$f":"AW6","v":12069940.567016602},{"$f":"AW7","v":12069940.567016602},{"$f":"AW6","v":12069940.567016602},{"$f":"AW11","v":300},{"$f":"AW12","v":2000}]
[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":10240},"GB",null,null,"Calculated cost",{"$f":"Y11*Y10","v":160932.54089355469},{"$f":"Z11*Z10","v":24200.230836868286},{"$f":"VLOOKUP(T8,$X$21:$Z$23,3,TRUE)","v":17447.916793823242},1950,{"$f":"AC10*AC11","v":720},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":2000},null,null,null,"Calculated cost",{"$f":"BB11*BB10","v":2413988.1134033203},{"$f":"BC11*BC10","v":362098.21701049805},{"$f":"VLOOKUP(BD11,BA21:BC23,3,TRUE)","v":254018.75190734866},{"$f":"BE11*BE10","v":1950},{"$f":"BF10*BF11","v":720}]
[null,null,null,"I'll filter out",null,null,0,"bytes per message",null,null,null,null,null,null,null,null,null,null,"Total data scanned",{"$f":"(T11*T12)/1024","v":300},"TB"]
[null,null,null,"Data Storage",null,null,null,null,{"$f":"SUM(Z12:AA12)","v":41648.147630691528},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,{"$f":"SUM(BC12:BD12)","v":616116.96891784668},"per month",null,null,null,null,null,null,null,null,null,"Raw data",1,{"$f":"AF7","v":12069940.567016602}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"messages","enrich","filter",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,0.9,{"$f":"0.9*AF7","v":10862946.510314941},null,null,null,"Month","Year"]
[null,null,null,"The devices will send",null,{"$f":"($D$7*$F$11*$F$10)/(1024^3)","v":804662.70446777344},"  GB of raw data per month.",null,null,null,null,null,null,null,null,null,null,null,500,0,0,null,null,"Per device",{"$f":"Y17/T5","v":0.20525068852424622},{"$f":"Z17/T5","v":2.4630082622909546},null,null,null,null,null,"I'll store",12069940.567016602,"  GB of raw data per month.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.75,{"$f":"0.75*AF7","v":9052455.4252624512}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,50,50,null,null,"Total",{"$f":"SUM(Y12:AC12)","v":205250.68852424622},{"$f":"Y17*12","v":2463008.2622909546},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":13276934.623718264},null,null,"Total",{"$f":"SUM(BB12:BF12)","v":3032775.082321167},{"$f":"BB17*12","v":36393300.987854004}]
[null,null,null,"and",{"$f":"($D$7*$F$10*($F$11+$G$12-$G$13))/(1024^3)","v":806674.36122894287},"  GB of processed data per month.",null,null,null,null,null,null,null,null,null,null,null,null,10000,100,100,null,null,null,null,null,null,null,null,null,null,"and",12069940.567016602,"  GB of processed data per month."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100000,500,250,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,"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,"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,1,{"$f":"AF7","v":12069940.567016602},null,null,"Range 1","Range 2","Total Price","Price"]
[null,null,null,"Query Execution",null,null,null,null,{"$f":"AB12","v":1950},null,null,null,null,null,null,null,null,null,"Total Compute ACU Hours",{"$f":"J29*G29","v":2000},null,null,null,0,50000,{"$f":"T8*AA21","v":18507.242202758789},2.3E-2,null,null,null,null,"Query Execution",null,null,null,null,{"$f":"BE12","v":1950},"per month",null,null,null,null,null,null,null,null,null,null,0.75,{"$f":"0.75*AF7","v":9052455.4252624512},null,null,0,50000,{"$f":"AW6*BD21","v":277608.63304138184},2.3E-2]
[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":"AA21*Y21+AA22*(T8-Y21)","v":17752.579498291016},2.1999999999999999E-2,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":6034970.2835083008},null,null,50000.000999999997,500000,{"$f":"BD21*BB21+BD22*(AW6-BB21)","v":265588.69247436523},2.1999999999999999E-2]
[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,500000.00099999999,{"$f":"5*10^12","v":5000000000000},{"$f":"AA21*Y21+AA22*450000+AA23*(T8-500000)","v":17447.916793823242},2.1000000000000001E-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":15087425.708770752},null,null,500000.00099999999,{"$f":"5*10^12","v":5000000000000},{"$f":"BD21*BB21+BD22*450000+BD23*(AW6-500000)","v":254018.75190734866},2.1000000000000001E-2]
[]
[null,null,null,"Each query will scan",null,null,10240,"   GB of data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Each query will scan",null,null,10240,"   GB of data",null,null,null,null,null,null,null,null,null,null,null,"scanned <= 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,"can't scan more than data processed"]
[null,null,null,"Custom Analysis Execution",null,null,null,null,{"$f":"AC12","v":720},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":"BF12","v":720},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",1000,"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",1000,"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."]