{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Calculator","Data Format"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":3,"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":79,"n_cols":10,"rows_kept":79,"cut":false,"hidden":false,"merged":[[78,4,78,5],[78,9,78,10],[18,9,18,10],[75,4,75,5],[75,9,75,10],[50,2,50,10],[54,9,54,10],[55,9,55,10],[52,9,52,10],[53,9,53,10],[24,4,24,5],[32,4,32,5],[30,4,31,4],[37,4,37,5],[57,9,57,10],[54,7,54,8],[76,2,78,2],[76,4,76,5],[76,9,76,10],[60,9,60,10],[67,9,67,10],[70,9,70,10],[63,2,70,2],[64,9,64,10],[65,9,65,10],[62,9,62,10],[63,9,63,10],[65,7,65,8],[70,4,70,5],[53,2,60,2],[57,4,57,5],[59,4,60,4],[17,9,17,10],[20,9,20,10],[41,9,41,10],[39,9,39,10],[26,4,27,4],[26,9,27,10],[28,4,28,5],[38,9,38,10],[37,9,37,10],[35,2,35,10],[38,2,41,2],[19,4,19,5],[55,7,55,8],[53,4,53,5],[45,9,45,10],[41,4,41,5],[44,4,45,4],[47,9,47,10],[44,9,44,10],[43,9,43,10],[43,4,43,5],[47,4,47,5],[54,4,54,5],[55,4,55,5],[52,4,52,5],[53,3,55,3],[38,3,39,3],[44,3,45,3],[38,4,39,4],[15,2,15,10],[18,2,32,2],[22,3,32,3],[24,9,24,10],[32,9,32,10],[17,4,17,5],[18,4,18,5],[20,4,20,5],[22,4,23,4],[18,3,20,3],[22,9,23,10],[30,9,31,10],[73,2,73,10],[59,3,60,3],[44,2,47,2],[28,9,28,10],[19,9,19,10],[68,9,68,10],[67,3,68,3],[67,4,68,4],[59,7,60,8],[63,3,65,3],[62,4,62,5],[63,4,63,5],[64,4,64,5],[65,4,65,5],[64,7,64,8],[59,9,59,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Fill BLANK CELLS"]
[]
[null,null,"STORAGE ELEMENT THRESHOLD VOLTAGES"]
[]
[null,null,null,null,"Parameter",null,"Value","Min.","Max.","Description"]
[null,null,"Storage Element Thresholds Configuration ","Target Values","VOVDIS  [V]",null,2.4,"2.400 V","3.581 V","Define the overdischarge level for the storage element ( VOVDIS < VCHRDY )"]
[null,null,null,null,"VCHRDY [V]",null,3,"2.456 V","3.637 V","Define the charge ready level for the storage element (VOVDIS < VCHRDY < VOVCH)"]
[null,null,null,null,"VOVCH  [V]",null,3.8,"2.700 V","4.594 V","Define the overcharge level for the storage element (VCHRDY < VOVCH)"]
[]
[null,null,null,"Results","Register value VOVDIS (integer)","Hex.",{"$f":"\"0x\"&DEC2HEX(G24, 2)","v":"0x00"},"0x00","0x3F","Value to write to the VOVDIS register (address 0x05)"]
[null,null,null,null,null,"Dec.",{"$f":"ROUND((G19-2.4)/0.01875, 0)","v":0},0,63]
[null,null,null,null,"VOVDIS [V]",null,{"$f":"ROUND(2.4+G24*0.01875,3)","v":2.4},{"$f":"H19","v":"2.400 V"},{"$f":"I19","v":"3.581 V"},"Corresponding overdischarge voltage level for the battery"]
[]
[null,null,null,null,"Register value VOVDIS (integer)","Hex.",{"$f":"\"0x\"&DEC2HEX(G28, 2)","v":"0x1D"},"0x00","0x3F","Value to write to the VCHRDY register (address 0x06)"]
[null,null,null,null,null,"Dec.",{"$f":"ROUND((G20-2.456)/0.01875, 0)","v":29},0,63]
[null,null,null,null,"VCHRDY [V]",null,{"$f":"ROUND(2.456+G28*0.01875,3)","v":3},{"$f":"H20","v":"2.456 V"},{"$f":"I20","v":"3.637 V"},"Corresponding overdischarge voltage level for the battery"]
[]
[null,null,null,null,"Register value VOVCH (integer)","Hex.",{"$f":"\"0x\"&DEC2HEX(G32, 2)","v":"0x3B"},"0x00","0x7F","Value to write to the VOVCH register (address 0x07)"]
[null,null,null,null,null,"Dec.",{"$f":"ROUND((G21-2.7)/0.01875, 0)","v":59},0,127]
[null,null,null,null,"VOVCH [V]",null,{"$f":"ROUND(2.7+G32*0.01875,3)","v":3.806},{"$f":"H21","v":"2.700 V"},{"$f":"I21","v":"4.594 V"},"Corresponding overcharge voltage level for the battery"]
[]
[]
[null,null,"STORAGE ELEMENT AND SOURCES READ REGISTERS"]
[]
[null,null,null,null,"Parameter",null,"Value","Min.","Max.","Description"]
[null,null,"Storage Element Voltage Data Register","Read Value","STO register (integer)","Hex.  ▼","0xC0",{"$f":"IF(F39=\"Dec.  ▼\", 0, \"0x00\")","v":"0x00"},{"$f":"IF(F39=\"Dec.  ▼\", 255, \"0xFF\")","v":"0xFF"},{"$f":"IF(F39=\"Dec.  ▼\",\"Integer decimal value read from STO register (address 0x24).\",\"Hexadecimal value read from STO register (address 0x24).\")","v":"Hexadecimal value read from STO register (address 0x24)."}]
[null,null,null,null,null,{"$f":"IF(F39=\"Dec.  ▼\", \"Hex.\", \"Dec.\")","v":"Dec."},{"$f":"IF(F39=\"Dec.  ▼\", IF(LEFT(G39, 2)=\"0x\",\"error\",\"0x\"&DEC2HEX(G39, 2)), IF(LEFT(G39, 2)=\"0x\",HEX2DEC(RIGHT(G39, 2)), \"error\"))","v":192},{"$f":"IF(F39=\"Dec.  ▼\", \"0x00\", 0)","v":0},{"$f":"IF(F39=\"Dec.  ▼\",\"0xFF\",255)","v":255},{"$f":"IF(F39=\"Dec.  ▼\",\"Hexadecimal representation of the number entered above.\",\"Decimal representation of the number entered above.\")","v":"Decimal representation of the number entered above."}]
[]
[null,null,null,"Result","Storage element voltage [V]",null,{"$f":"IF(F39=\"Dec.  ▼\", IF(LEFT(G39, 2)=\"0x\",\"error\",4.8*G39/256), IF(LEFT(G39, 2)=\"0x\",4.8*G40/256,\"error\"))","v":3.5999999999999996},"0.00 V","4.781 V","Storage element voltage corresponding to the value read in STO register."]
[]
[null,null,null,null,"Parameter",null,"Value","Min.","Max.","Description"]
[null,null,"Source Voltage Data Register","Read Value","SRC register (integer)","Hex.  ▼","0x21",{"$f":"IF(F45=\"Dec.  ▼\", 0, \"0x00\")","v":"0x00"},{"$f":"IF(F45=\"Dec.  ▼\", 255, \"0xFF\")","v":"0xFF"},{"$f":"IF(F45=\"Dec.  ▼\",\"Integer decimal value read from SRC1/SRC2 registers (addresses 0x25/0x26).\",\"Hexadecimal value read from SRC1/SRC2 registers (addresses 0x25/0x26).\")","v":"Hexadecimal value read from SRC1/SRC2 registers (addresses 0x25/0x26)."}]
[null,null,null,null,null,{"$f":"IF(F45=\"Dec.  ▼\", \"Hex.\", \"Dec.\")","v":"Dec."},{"$f":"IF(F45=\"Dec.  ▼\", IF(LEFT(G45, 2)=\"0x\",\"error\",\"0x\"&DEC2HEX(G45, 2)), IF(LEFT(G45, 2)=\"0x\",HEX2DEC(RIGHT(G45, 2)), \"error\"))","v":33},{"$f":"IF(F45=\"Dec.  ▼\", \"0x00\", 0)","v":0},{"$f":"IF(F45=\"Dec.  ▼\",\"0xFF\",255)","v":255},{"$f":"IF(F45=\"Dec.  ▼\",\"Hexadecimal representation of the number entered above.\",\"Decimal representation of the number entered above.\")","v":"Decimal representation of the number entered above."}]
[]
[null,null,null,"Result","Source voltage [V]",null,{"$f":"IF(F45=\"Dec.  ▼\", IF(LEFT(G45, 2)=\"0x\",\"error\",IF(G45<=6,0.113,IF(AND(G45>=7,G45<=18),(2*G45-9)*0.0075+0.09,IF(AND(G45>=19,G45<=57),(2*G45-37)*0.015+0.3,IF(AND(G45>=106,G45<=121),((2*G45-165)*0.015+0.3)/0.67,IF(AND(G45>=161,G45<=185),((2*G45-293)*0.015+0.3)/0.33,\"error\")))))), IF(LEFT(G45, 2)=\"0x\",IF(G46<=6,0.113,IF(AND(G46>=7,G46<=18),(2*G46-9)*0.0075+0.09,IF(AND(G46>=19,G46<=57),(2*G46-37)*0.015+0.3,IF(AND(G46>=106,G46<=121),((2*G46-165)*0.015+0.3)/0.67,IF(AND(G46>=161,G46<=185),((2*G46-293)*0.015+0.3)/0.33,\"error\"))))),\"error\"))","v":0.73499999999999999},"0.113 V","4.409 V","Source voltage corresponding to the value read in SRC register."]
[]
[]
[null,null,"THERMAL MONITORING"]
[]
[null,null,null,null,"Parameter",null,"Value","Min.","Max.","Description"]
[null,null,"Thermal Monitoring Threshold Configuration","Parameters","RDIV [kΩ]",null,22,"5 kΩ","33 kΩ","Resistor that creates a resistive voltage divider with RTH."]
[null,null,null,null,"β",null,3380,"Typ. 3380",null,"Beta of RTH thermistor."]
[null,null,null,null,"RTH [kΩ]",null,10,"Typ. 10 kΩ",null,"Resistance of the of RTH thermistor at 25°C."]
[]
[null,null,null,"Target Value","Temperature [°C]",null,25,-40,125,"Desired temperature threshold for TEMPCOLDCH, TEMPCOLDDIS, TEMPHOTCH or TEMPHOTDIS (min. and max. temperatures specified according to AEM specifications)."]
[]
[null,null,null,"Result","Register value (integer)","Dec.",{"$f":"(256*((G56*1000)*EXP(G55*((1/(G58+273.15))-(1/(25+273.15))))))/((G54*1000)+((G56*1000)*EXP(G55*(1/(G58+273.15)-1/(25+273.15)))))","v":80},"Depends on the \nthermistor",null,"Value to write to TEMPCOLDCH, TEMPHOTCH, TEMPCOLDDIS  or TEMPHOTDIS \nregisters (addresses 0x0B, 0x0C, 0x0D and 0x0E resp.)."]
[null,null,null,null,null,"Hex.",{"$f":"\"0x\"&DEC2HEX(G60, 2)","v":"0x50"},null,null,"Hexadecimal representation of the above value ."]
[]
[null,null,null,null,"Parameter",null,"Value","Min.","Max.","Description"]
[null,null,"Thermal Monitoring Data Register","Parameters","RDIV [kΩ]",null,22,"5 kΩ","33 kΩ","Resistor that creates a resistive voltage divider with RTH."]
[null,null,null,null,"β",null,3380,"Typ. 3380",null,"Beta of RTH thermistor."]
[null,null,null,null,"RTH [kΩ]",null,10,"Typ. 10 kΩ",null,"Resistance of the of RTH thermistor at 25°C."]
[]
[null,null,null,"Target Value","TEMP register value (integer)","Hex.  ▼","0x50",{"$f":"IF(F68=\"Dec.  ▼\", 1, \"0x01\")","v":"0x01"},{"$f":"IF(F68=\"Dec.  ▼\", 255, \"0xFF\")","v":"0xFF"},{"$f":"IF(F68=\"Dec.  ▼\",\"Integer decimal value read from TEMP register (address 0x23).\",\"Hexadecimal value read from TEMP register (address 0x23).\")","v":"Hexadecimal value read from TEMP register (address 0x23)."}]
[null,null,null,null,null,{"$f":"IF(F68=\"Dec.  ▼\", \"Hex.\", \"Dec.\")","v":"Dec."},{"$f":"IF(F68=\"Dec.  ▼\", IF(LEFT(G68, 2)=\"0x\",\"error\",\"0x\"&DEC2HEX(G68, 2)), IF(LEFT(G68, 2)=\"0x\",HEX2DEC(RIGHT(G68, 2)), \"error\"))","v":80},{"$f":"IF(F68=\"Dec.  ▼\", \"0x01\", 1)","v":1},{"$f":"IF(F68=\"Dec.  ▼\",\"0xFF\",255)","v":255},{"$f":"IF(F68=\"Dec.  ▼\",\"Hexadecimal representation of the above value.\",\"Decimal representation of the above value.\")","v":"Decimal representation of the above value."}]
[]
[null,null,null,"Result","Temperature  [°C]",null,{"$f":"IF(F68=\"Dec.  ▼\", IF(LEFT(G68, 2)=\"0x\",\"error\",(1/((1/(25+273.15))+((LN((((G64*1000)*G68)/(256-G68))/(G66*1000)))/G65)))-273.15), IF(LEFT(G68, 2)=\"0x\",(1/((1/(25+273.15))+((LN((((G64*1000)*G69)/(256-G69))/(G66*1000)))/G65)))-273.15,\"error\"))","v":25},-40,125,"Temperature corresponding to the value read from TEMP register."]
[]
[]
[null,null,"5 V CHARGER"]
[]
[null,null,null,null,"Parameter",null,"Value","Min.","Max.","Description"]
[null,null,"5 V Charger Current Limit","Target Value","I5V,CC [mA]",null,25,"13.5 mA","135 mA","Maximum charging current."]
[]
[null,null,null,"Result","R5V_IMAX [Ω]",null,{"$f":"50000/G77","v":2000},"370 Ω","3700 Ω","Resistor corresponding to the maximum charging current."]

{"sheet":"Data Format","index":1,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Data Format"]
["Hex.  ▼"]
["Dec.  ▼"]