{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Calculator","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Calculator","index":0,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[[5,3,5,5],[3,3,3,5],[7,3,7,5]]}
[]
[null,null,"2016 RQX Battery Life Calculator"]
[]
[null,1,"Select a radio model.","RQX-111 (800mW, use 3 D-cell batteries)"]
[]
[null,2,"Select a battery type.","D-cell Alkaline"]
[]
[null,3,"Select Automatic Turn-Off, Always On, or Battery Saver operation."]
[]
[null,4,"How many times per day will the Callbox be used?",1]
[]
[null,5,"How long does it take to respond to a call from the Callbox?",10,"seconds","(Reset Time)"]
[null,null,"NOTE:  The Reset Time must be programmed to allow for the longest response time. (10 second factory default)"]
[]
[null,6,"How many times will the Callbox transmit each time it is used?",1]
[]
[null,7,"What is the average length of each transmission?",5,"seconds"]
[]
[null,8,"What is the average length of each received response message?",5,"seconds"]
[]
[null,9,"What is the Battery Saver Sleep Time?",0.5,"seconds","(Battery Saver \"Sleep\" Time)"]
[]
[null,null,"BATTERY LIFE"]
[]
[null,null,"Battery Capacity:",{"$f":"Data!B24","v":14997.924382716048},"mAH"]
[]
[null,null,"Total Daily Use:",{"$f":"Data!F33","v":2232.8527777777781},"mAH"]
[]
[null,null,"Battery life (days)",{"$f":"Data!F34","v":6.7169338399652867},"Days"]
[]
[null,null,"Total transmissions",{"$f":"Data!F35","v":6.7169338399652867},"Transmissions"]
[]
[]
[]
[null,null,"NOTE: When a \"7-Series\" model is selected an 8 second \"Greeting\" message and 3 second \"Alert\" message are added"]

{"sheet":"Data","index":1,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
["WARNING!  DO NOT CHANGE ANY VALUES ON THIS SHEET",null,null,null,null,null,null,null,null,null,null,null,null,"Sleep","RX","TX","SB "]
[null,null,null,null,null,null,null,null,"<25mA","100mA","200mA","500mA","1A","time","time","time","time"]
["Current Requirements","RQX-111","RQX-117","RQX-411","RQX-417",null,null,"Batteries","mAH","mAH","mAH","mAH","mAH","<25m","200-500mA","500mA-1A","100mA"]
["Off",0,0,0,0,"mA",null,"D-cell Alkaline",{"$f":"600*25","v":15000},{"$f":"110*100","v":11000},{"$f":"42*200","v":8400},{"$f":"8*500","v":4000},{"$f":"2*1000","v":2000},{"$f":"($B$31/(24*60))*I4","v":899677.08333333337},{"$f":"IF(B14>1,($B$27/(24*60))*(L4+((K4-L4)/300)*(500-$D$27)),($B$27/($B$30))*(L4+((K4-L4)/300)*(500-$D$27)))","v":24.074074074074073},{"$f":"IF(B14>1,($B$26/(24*60))*(M4+((L4-M4)/500)*(1000-D26)),($B$26/($B$30))*(M4+((L4-M4)/500)*(1000-D26)))","v":13.888888888888888},{"$f":"IF(B14>1,($B$28+$B$25+$B$29)/(24*60)*J4,($B$28+$B$25+$B$29)/($B$30)*J4)","v":160.41666666666666},{"$f":"IF(B14>1,SUM((N4:Q4))/60,SUM((O4:Q4)))","v":14997.924382716048}]
["Sleep",16,16,16,16,"mA",null,"D-cell NiMH",10000,10000,10000,10000,10000,{"$f":"($B$31/(24*60))*I5","v":599784.72222222225},{"$f":"IF(B15>1,($B$27/(24*60))*(L5+((K5-L5)/300)*(500-$D$27)),($B$27/($B$30))*(L5+((K5-L5)/300)*(500-$D$27)))","v":1612.9032258064515},{"$f":"IF(B15>1,($B$26/(24*60))*(M5+((L5-M5)/500)*(1000-D27)),($B$26/($B$30))*(M5+((L5-M5)/500)*(1000-D27)))","v":1612.9032258064515},{"$f":"IF(B15>1,($B$28+$B$25+$B$29)/(24*60)*J5,($B$28+$B$25+$B$29)/($B$30)*J5)","v":6774.1935483870966},{"$f":"IF(B15>1,SUM((N5:Q5))/60,SUM((O5:Q5)))","v":10000}]
["Standby",94,94,94,94,"mA",null,"AA-cell Alkaline",{"$f":"110*25","v":2750},{"$f":"24.4*100","v":2440},{"$f":"10.4*200","v":2080},{"$f":"2.8*500","v":1400},{"$f":"0.8*1000","v":800},164940.79861111112,6.4351851851851842,6.5569444444444436,35.583333333333336,2749.8229012345687]
["Receive",300,300,300,300,"mA",null,"AA-cell Lithium",{"$f":"120*25","v":3000},{"$f":"30*100","v":3000},{"$f":"15*200","v":3000},{"$f":"6*500","v":3000},{"$f":"3*1000","v":3000},179935.41666666666,483.87096774193549,483.87096774193549,2032.2580645161288,3000]
["Transmit (low power)",500,590,580,590,"mA",null,"AA-cell NiMH",2500,2500,2500,{"$f":"(300/60)*460","v":2300},{"$f":"(110/60)*1200","v":2200},149946.18055555556,8.4490740740740744,8.3333333333333321,36.458333333333336,2499.990354938272]
["Transmit (high power)",500,760,720,900,"mA",null,"C-cell Alkaline",6800,6300,5500,3000,1000,407853.61111111112,16.203703703703702,16.069444444444443,91.875,6799.6293209876549]
[null,null,null,null,null,null,null,"NOTE: Capacity rated at 1.1V EOL for D-cell, 1.0V EOL for AA"]
["User Configuration"]
["Radio Model",{"$f":"Calculator!$D$4","v":"RQX-111 (800mW, use 3 D-cell batteries)"},null,null,null,null,null,"Battery data","<25mA","100mA","200mA","500mA","1A"]
["Battery",{"$f":"Calculator!$D$6","v":"D-cell Alkaline"},null,null,null,null,null,null,"mAH","mAH","mAH","mAH","mAH"]
["Auto Turn-Off / Intercom",2,{"$f":"IF(B14=1,\"Auto Turn-Off\",(IF(B14=2,\"Intercom\",\"Power Saver\")))","v":"Intercom"},null,null,null,null,"Energizer E95 Alkaline D",{"$f":"600*25","v":15000},{"$f":"110*100","v":11000},{"$f":"42*200","v":8400},{"$f":"8*500","v":4000},{"$f":"2*1000","v":2000}]
["Daily Usage",{"$f":"Calculator!D10","v":1},null,null,null,null,null,"Energizer EN95 Alkaline D",{"$f":"600*25","v":15000},{"$f":"110*100","v":11000},{"$f":"42*200","v":8400},{"$f":"9*500","v":4500},{"$f":"2.2*1000","v":2200},null,null,null,{"$f":"(L4+((K4-L4)/300)*(500-$D$27))","v":6933.333333333333}]
["Initial Response",{"$f":"Calculator!D12","v":10},"sec.",null,null,null,null,"Duracell MN1300 Alkaline D",{"$f":"600*25","v":15000},{"$f":"110*100","v":11000},{"$f":"38*250","v":9500},{"$f":"11*500","v":5500},{"$f":"2.5*1000","v":2500},"@1.1V EOL"]
["Number of Transmissions",{"$f":"Calculator!D15","v":1},null,null,null,null,null,"Procell PC1300 Alkaline D",{"$f":"600*25","v":15000},{"$f":"110*100","v":11000},{"$f":"37*250","v":9250},{"$f":"11.5*500","v":5750},{"$f":"2.1*1000","v":2100}]
["Length of Transmissions",{"$f":"Calculator!D17","v":5},"sec.",null,null,null,null,"Duracell Coppertop MN1500 AA",{"$f":"110*25","v":2750},{"$f":"24.4*100","v":2440},{"$f":"10.4*200","v":2080},{"$f":"2.8*500","v":1400},{"$f":"0.8*1000","v":800}]
["Length of Response",{"$f":"Calculator!D19","v":5},"sec.",null,null,null,null,"Energizer E91 Alkaline AA",2450,2000,1800,700,{"$f":"((2*$B$16)+($B$17*$B$18)+($B$17*$B$19))","v":30}]
["RQX Turn-Off Time",{"$f":"IF($B$16 > 10,$B$16,10)","v":10},"sec.",null,null,null,null,"Energizer EA91 Lithium AA",3250,3200,3200,2950,{"$f":"((2*$B$16)+($B$17*$B$18)+($B$17*$B$19))","v":30}]
["Power Saver Time",{"$f":"Calculator!D21","v":0.5},"sec.",null,null,null,null,"Energizer EN91 Alkaline AA",null,null,null,{"$f":"2.25*500","v":1125},{"$f":"((2*$B$16)+($B$17*$B$18)+($B$17*$B$19))","v":30}]
[null,null,null,null,null,null,null,"Energizer L91 Lithium AA",{"$f":"120*25","v":3000},{"$f":"30*100","v":3000},{"$f":"15*200","v":3000},{"$f":"6*500","v":3000},{"$f":"3*1000","v":3000}]
["Daily Usage",null,null,null,null,null,null,"Duracell Procell PC1500 AA",{"$f":"50*50","v":2500},{"$f":"23*100","v":2300},{"$f":"9.85*200","v":1970},{"$f":"2.25*500","v":1125},{"$f":"((2*$B$16)+($B$17*$B$18)+($B$17*$B$19))","v":30}]
["Battery capacity:",{"$f":"VLOOKUP($B$13,$H$4:$R$9,11,FALSE)","v":14997.924382716048},"mAH",null,null,null,null,"Tenergy 10320 AA NiMH",2500,2500,2500,{"$f":"(300/60)*460","v":2300},{"$f":"(110/60)*1200","v":2200}]
["Initial response time:",{"$f":"B16*B15","v":10},"sec.",{"$f":"VLOOKUP($B$12,$A$38:$F$49,4,FALSE)","v":93},"mA",{"$f":"(B25/3600)*D25","v":0.25833333333333336},"mAH","Tenergy 10105 D NiMH",10000,10000,10000,10000,10000]
["Transmitted messages:",{"$f":"IF(MID(B12,7,1)=\"7\",(B17*B18*B15)+(3*B15),(B17*B18*B15))","v":5},"sec.",{"$f":"VLOOKUP($B$12,$A$38:$F$49,6,FALSE)","v":500},"mA",{"$f":"(B26/3600)*D26","v":0.69444444444444442},"mAH","Energizer EN93 Alkaline C",6750,6300,6000,2650,930,"@1.0V EOL"]
["Received messages:",{"$f":"IF(MID(B12,7,1)=\"7\",(B17*B19*B15)+(8*B15),(B17*B19*B15))","v":5},"sec.",{"$f":"VLOOKUP($B$12,$A$38:$F$49,5,FALSE)","v":300},"mA",0.41666666666666669,"mAH","Duracell MN1400 Alkaline C",null,null,5175,3375,1300,"@1.0V EOL"]
["TX/RX dead time:",{"$f":"B17*1*B15","v":1},"sec.",{"$f":"VLOOKUP($B$12,$A$38:$F$49,4,FALSE)","v":93},"mA",2.5833333333333333E-2,"mAH"]
["RQX Turn-Off time:",{"$f":"B20*B15","v":10},"sec.",{"$f":"VLOOKUP($B$12,$A$38:$F$49,4,FALSE)","v":93},"mA",0.25833333333333336,"mAH"]
["Total Call Time:",{"$f":"SUM(B25:B29)","v":31},"sec."]
["Off Time:",{"$f":"(60*60*24)-B30","v":86369},"sec.",{"$f":"IF(B14=1,VLOOKUP($B$12,$A$38:$G$49,2,FALSE),IF(B14=2,VLOOKUP($B$12,$A$38:$G$49,4,FALSE),VLOOKUP($B$12,$A$38:$G$49,7,FALSE)))","v":93},"mA",2231.1991666666668,"mAH"]
[]
["Total Daily Use:",null,null,null,null,{"$f":"SUM(F25:F31)","v":2232.8527777777781},"mAH"]
["Battery Life (days):",null,null,null,null,{"$f":"B24/F33","v":6.7169338399652867},"days"]
["Total number of transmissions:",null,null,null,null,{"$f":"B15*B17*F34","v":6.7169338399652867},"transmissions"]
[]
["Models","Off","Sleep","Standby","RX","TX","PS"]
["RQX-111 (800mW, use 3 D-cell batteries)",0,13,93,300,500,{"$f":"($B$54*C38)+((1-$B$54)*D38)","v":20.272727272727273}]
["RQX-117 (800mW, use 3 D-cell batteries)",0,13,93,300,500,20.272727272727273]
["RQX-121 (2.5W, use 6 AA or D-cell batteries)",0,13,100,500,760,20.909090909090914]
["RQX-127 (2.5W, use 6 AA or D-cell batteries)",0,13,100,500,760,20.909090909090914]
["RQX-411 (700mW, use 3 D-cell batteries)",0,13,93,300,580,20.272727272727273]
["RQX-417 (700mW, use 3 D-cell batteries)",0,13,93,300,580,20.272727272727273]
["RQX-421 (2W, use 6 AA or D-cell batteries)",0,13,100,500,900,20.909090909090914]
["RQX-427 (2W, use 6 AA or D-cell batteries)",0,13,100,500,900,20.909090909090914]
["RQX-156-XT (1.5W, use 6 D-cell batteries)",0,60,107,189,550,64.27272727272728]
["RQX-157-XT (1.5W, use 6 D-cell batteries)",0,60,107,189,550,64.27272727272728]
["RQX-456-XT (2W, use 6 D-cell batteries)",0,60,107,189,427,64.27272727272728]
["RQX-457-XT (2W, use 6 D-cell batteries)",0,60,107,189,427,64.27272727272728]
[]
["Power Saver"]
["Off Time",{"$f":"B21","v":0.5},"ms"]
["On time",0.05,"ms"]
["percent off",{"$f":"B52/(B52+B53)","v":0.90909090909090906}]