{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Calculator","Revision History","Data Format"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":5,"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":106,"n_cols":10,"rows_kept":106,"cut":false,"hidden":false,"merged":[[15,2,15,10],[17,4,17,5],[18,1,29,1],[18,2,29,2],[18,4,18,5],[18,9,18,10],[19,3,19,7],[20,3,29,3],[20,4,21,4],[20,9,20,10],[21,9,21,10],[29,4,29,5],[29,9,29,10],[23,4,24,4],[26,4,27,4],[26,9,26,10],[27,9,27,10],[24,9,24,10],[23,9,23,10],[98,9,98,10],[98,4,99,4],[98,3,100,3],[99,9,99,10],[100,4,100,5],[102,4,102,5],[102,9,102,10],[103,2,105,2],[103,4,103,5],[103,9,103,10],[105,4,105,5],[105,9,105,10],[100,9,100,10],[96,2,100,2],[96,4,96,5],[96,9,96,10],[95,4,95,5],[95,9,95,10],[70,2,70,10],[74,9,74,10],[75,9,75,10],[72,9,72,10],[73,9,73,10],[49,4,50,4],[57,4,57,5],[77,9,77,10],[74,7,74,8],[80,9,80,10],[87,9,87,10],[90,9,90,10],[83,2,90,2],[84,9,84,10],[85,9,85,10],[82,9,82,10],[83,9,83,10],[85,7,85,8],[90,4,90,5],[73,2,80,2],[77,4,77,5],[79,4,80,4],[34,9,34,10],[37,9,37,10],[61,9,61,10],[59,9,59,10],[44,4,45,4],[58,9,58,10],[57,9,57,10],[55,2,55,10],[58,2,61,2],[36,4,36,5],[46,8,47,8],[42,9,42,10],[44,9,44,10],[45,9,45,10],[47,9,47,10],[49,9,49,10],[50,9,50,10],[51,9,51,10],[75,7,75,8],[73,4,73,5],[65,9,65,10],[61,4,61,5],[64,4,65,4],[67,9,67,10],[64,9,64,10],[63,9,63,10],[63,4,63,5],[32,2,32,10],[35,2,52,2],[39,3,52,3],[41,9,41,10],[52,9,52,10],[34,4,34,5],[35,4,35,5],[37,4,37,5],[39,4,40,4],[35,3,37,3],[35,9,35,10],[39,9,39,10],[40,9,40,10],[51,4,52,5],[46,4,47,5],[41,4,42,5],[41,6,42,6],[41,7,42,7],[41,8,42,8],[46,6,47,6],[46,7,47,7],[51,6,52,6],[51,7,52,7],[51,8,52,8],[93,2,93,10],[79,3,80,3],[64,2,67,2],[46,9,46,10],[36,9,36,10],[88,9,88,10],[87,3,88,3],[87,4,88,4],[79,7,80,8],[83,3,85,3],[82,4,82,5],[83,4,83,5],[84,4,84,5],[85,4,85,5],[84,7,84,8],[79,9,79,10],[67,4,67,5],[74,4,74,5],[75,4,75,5],[72,4,72,5],[73,3,75,3],[58,3,59,3],[64,3,65,3],[58,4,59,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Fill BLANK CELLS"]
[]
[null,null,"SOURCE REGULATION VOLTAGE IN CONSTANT VOLTAGE MODE"]
[]
[null,null,null,null,"Parameter",null,"Value","Min.","Max.","Description"]
[null,null,"Source \nRegulation Voltage \nConfiguration","Target Value","VSRC,REG [V]",null,0.75,"0.300 V","4.318 V","Define the source regulation voltage value"]
[]
[null,null,null,"Results","LVL[7:0] value (integer)","Hex.",{"$f":"\"0x\"&DEC2HEX(G22, 2)","v":"0x43"},"0x25","0xC3","Hexadecimal value corresponding to the selected source regulation voltage value"]
[null,null,null,null,null,"Dec.",{"$f":"IF(G19<0.296,ROUND(13+(G19-0.12)/0.0075,0),IF(G19<1.474,ROUND(37+(G19-0.3)/0.015,0),IF(G19<2.21,ROUND(116+(G19-1.47761194029851)/0.0223880597014927,0),ROUND(149+(G19-2.22727272727273)/0.0454545454545454,0))))","v":67},37,195,"Decimal representation of the above value"]
[]
[null,null,null,null,"Register value SRCxREGU0  (integer)","Hex.",{"$f":"\"0x\"&DEC2HEX(G25, 2)","v":"0x06"},"0x00","0x0E","Value to write to the SRCREGU0 register (addresses 0x01)"]
[null,null,null,null,null,"Dec.",{"$f":"_xlfn.BITAND(_xlfn.BITLSHIFT(_xlfn.BITAND(G22,7),1),254)","v":6},0,14,"Decimal representation of the above value"]
[]
[null,null,null,null,"Register value SRCxREGU1  (integer)","Hex.",{"$f":"\"0x\"&DEC2HEX(G28, 2)","v":"0x08"},"0x04","0x18","Value to write to the SRCREGU1 register (addresses 0x02)"]
[null,null,null,null,null,"Dec.",{"$f":"_xlfn.BITAND(_xlfn.BITRSHIFT(G22,3),31)","v":8},4,24,"Decimal representation of the above value"]
[]
[null,null,null,null,"VSRC,REG [V]",null,{"$f":"IF(G22<37,ROUND(0.12+0.0075*(G22-13),3),IF(G22<116,ROUND(0.3+0.015*(G22-37),3),IF(G22<149,ROUND(1.47761194029851+0.0223880597014927*(G22-116),3),ROUND(2.22727272727273+0.0454545454545454*(G22-149),3))))","v":0.75},"0.300 V","4.318 V","Corresponding source regulation voltage"]
[]
[]
[null,null,"STORAGE ELEMENT PROTECTION THRESHOLDS"]
[]
[null,null,null,null,"Parameter",null,"Value","Min.","Max.","Description"]
[null,null,"Storage Element Thresholds Configuration ","Target Values","VOVDIS  [V]",null,2.5,"2.400 V","3.581 V","Define the overdischarge level for the storage element ( VOVDIS < VCHRDY )"]
[null,null,null,null,"VCHRDY [V]",null,2.7,"2.456 V","4.312 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(G41, 2)","v":"0x05"},"0x00","0x3F","Value to write to the VOVDIS register (address 0x05)"]
[null,null,null,null,null,"Dec.",{"$f":"ROUND((G36-2.4)/0.01875, 0)","v":5},0,63,"Decimal representation of the above value"]
[null,null,null,null,"VOVDIS [V]",null,{"$f":"ROUND(2.4+G41*0.01875,3)","v":2.4940000000000002},{"$f":"H36","v":"2.400 V"},{"$f":"I36","v":"3.581 V"},"Corresponding overdischarge voltage level for the storage element\n\n"]
[null,null,null,null,null,null,null,null,null,"Cell color is red if not respecting the 100mV margin with VCHRDY explained in the datasheet"]
[]
[null,null,null,null,"Register value VCHRDY (integer)","Hex.",{"$f":"\"0x\"&DEC2HEX(G46, 2)","v":"0x0D"},"0x00","0x63","Value to write to the VCHRDY register (address 0x06)"]
[null,null,null,null,null,"Dec.",{"$f":"ROUND((G37-2.456)/0.01875, 0)","v":13},0,99,"Decimal representation of the above value"]
[null,null,null,null,"VCHRDY [V]",null,{"$f":"IF(AND(G46<66,MOD(G46+1,4)=0), ROUND(2.456+G46*0.01875,3)+0.001, IF(AND(G46>65,MOD(G46+2,4)=0),ROUND(2.456+G46*0.01875,3)-0.001,ROUND(2.456+G46*0.01875,3)))","v":2.7},{"$f":"H37","v":"2.456 V"},{"$f":"I37","v":"4.312 V"},"Corresponding charge ready voltage level for the storage element\n\n"]
[null,null,null,null,null,null,null,null,null,"Cell color is red if not respecting the 100mV margin with VOVDIS and VOVCH explained in the datasheet"]
[]
[null,null,null,null,"Register value VOVCH (integer)","Hex.",{"$f":"\"0x\"&DEC2HEX(G51, 2)","v":"0x3B"},"0x00","0x7F","Value to write to the VOVCH register (address 0x07)"]
[null,null,null,null,null,"Dec.",{"$f":"ROUND((G38-2.7)/0.01875, 0)","v":59},0,127,"Decimal representation of the above value"]
[null,null,null,null,"VOVCH [V]",null,{"$f":"ROUND(2.7+G51*0.01875,3)","v":3.806},{"$f":"H37","v":"2.456 V"},{"$f":"I37","v":"4.312 V"},"Corresponding overcharge voltage level for the storage element"]
[null,null,null,null,null,null,null,null,null,"Cell color is red if not respecting the 100mV margin with VCHRDY explained in the datasheet"]
[]
[]
[null,null,"STORAGE ELEMENT AND SOURCE 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(F59=\"Dec.  ▼\", 0, \"0x00\")","v":"0x00"},{"$f":"IF(F59=\"Dec.  ▼\", 255, \"0xFF\")","v":"0xFF"},{"$f":"IF(F59=\"Dec.  ▼\",\"Integer decimal value read from STO register (address 0x29)\",\"Hexadecimal value read from STO register (address 0x29)\")","v":"Hexadecimal value read from STO register (address 0x29)"}]
[null,null,null,null,null,{"$f":"IF(F59=\"Dec.  ▼\", \"Hex.\", \"Dec.\")","v":"Dec."},{"$f":"IF(F59=\"Dec.  ▼\", IF(LEFT(G59, 2)=\"0x\",\"error\",\"0x\"&DEC2HEX(G59, 2)), IF(LEFT(G59, 2)=\"0x\",HEX2DEC(RIGHT(G59, 2)), \"error\"))","v":192},{"$f":"IF(F59=\"Dec.  ▼\", \"0x00\", 0)","v":0},{"$f":"IF(F59=\"Dec.  ▼\",\"0xFF\",255)","v":255},{"$f":"IF(F59=\"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(F59=\"Dec.  ▼\", IF(LEFT(G59, 2)=\"0x\",\"error\",4.8*G59/256), IF(LEFT(G59, 2)=\"0x\",4.8*G60/256,\"error\"))","v":3.5999999999999996},"0.000 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(F65=\"Dec.  ▼\", 0, \"0x00\")","v":"0x00"},{"$f":"IF(F65=\"Dec.  ▼\", 185, \"0xB9\")","v":"0xB9"},{"$f":"IF(F65=\"Dec.  ▼\",\"Integer decimal value read from SRC register (addresses 0x2A)\",\"Hexadecimal value read from SRC register (addresses 0x2A)\")","v":"Hexadecimal value read from SRC register (addresses 0x2A)"}]
[null,null,null,null,null,{"$f":"IF(F65=\"Dec.  ▼\", \"Hex.\", \"Dec.\")","v":"Dec."},{"$f":"IF(F65=\"Dec.  ▼\", IF(LEFT(G65, 2)=\"0x\",\"error\",\"0x\"&DEC2HEX(G65, 2)), IF(LEFT(G65, 2)=\"0x\",HEX2DEC(RIGHT(G65, 2)), \"error\"))","v":33},{"$f":"IF(F65=\"Dec.  ▼\", \"0x00\", 0)","v":0},{"$f":"IF(F65=\"Dec.  ▼\",\"0xB9\",185)","v":185},{"$f":"IF(F65=\"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(F65=\"Dec.  ▼\", IF(LEFT(G65, 2)=\"0x\",\"error\",IF(G65<=6,0.113,IF(AND(G65>=7,G65<=18),(2*G65-9)*0.0075+0.09,IF(AND(G65>=19,G65<=57),(2*G65-37)*0.015+0.3,IF(AND(G65>=104,G65<=121),((2*G65-165)*0.015+0.3)/0.67,IF(AND(G65>=159,G65<=185),((2*G65-293)*0.015+0.3)/0.33,\"error\")))))), IF(LEFT(G65, 2)=\"0x\",IF(G66<=6,0.113,IF(AND(G66>=7,G66<=18),(2*G66-9)*0.0075+0.09,IF(AND(G66>=19,G66<=57),(2*G66-37)*0.015+0.3,IF(AND(G66>=104,G66<=121),((2*G66-165)*0.015+0.3)/0.67,IF(AND(G66>=159,G66<=185),((2*G66-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 Thresholds 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":"ROUND((256*((G76*1000)*EXP(G75*((1/(G78+273.15))-(1/(25+273.15))))))/((G74*1000)+((G76*1000)*EXP(G75*(1/(G78+273.15)-1/(25+273.15))))),0)","v":80},"Depends on the \nthermistor",null,"Value to write to TEMPCOLDCH, TEMPHOTCH, TEMPCOLDDIS  or TEMPHOTDIS \nregisters (addresses 0x0D, 0x0E, 0x0F and 0x10 resp.)"]
[null,null,null,null,null,"Hex.",{"$f":"\"0x\"&DEC2HEX(G80, 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(F88=\"Dec.  ▼\", 1, \"0x01\")","v":"0x01"},{"$f":"IF(F88=\"Dec.  ▼\", 255, \"0xFF\")","v":"0xFF"},{"$f":"IF(F88=\"Dec.  ▼\",\"Integer decimal value read from TEMP register (address 0x28)\",\"Hexadecimal value read from TEMP register (address 0x28)\")","v":"Hexadecimal value read from TEMP register (address 0x28)"}]
[null,null,null,null,null,{"$f":"IF(F88=\"Dec.  ▼\", \"Hex.\", \"Dec.\")","v":"Dec."},{"$f":"IF(F88=\"Dec.  ▼\", IF(LEFT(G88, 2)=\"0x\",\"error\",\"0x\"&DEC2HEX(G88, 2)), IF(LEFT(G88, 2)=\"0x\",HEX2DEC(RIGHT(G88, 2)), \"error\"))","v":80},{"$f":"IF(F88=\"Dec.  ▼\", \"0x01\", 1)","v":1},{"$f":"IF(F88=\"Dec.  ▼\",\"0xFF\",255)","v":255},{"$f":"IF(F88=\"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","Temperature  [°C]",null,{"$f":"IF(F88=\"Dec.  ▼\", IF(LEFT(G88, 2)=\"0x\",\"error\",(1/((1/(25+273.15))+((LN((((G84*1000)*G88)/(256-G88))/(G86*1000)))/G85)))-273.15), IF(LEFT(G88, 2)=\"0x\",(1/((1/(25+273.15))+((LN((((G84*1000)*G89)/(256-G89))/(G86*1000)))/G85)))-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 Stop Voltage Threshold","Target Value","V5V,STOP [V]",null,3.81,"2.65 V","4.70 V","Stop voltage threshold for the storage element when using the 5 V charger in constant voltage (CV) mode"]
[]
[null,null,null,"Result","CHG5V.THRESH value (integer)","Dec.",{"$f":"IF(G97<3.27,ROUND((G97-2.65)/0.1,0),IF(G97<4.3,ROUND(7+(G97-3.3)/0.05,0),ROUND(28+(G97-4.4)/0.1,0)))","v":17},0,31,"Value to write to the CHG5V register, bits [6:2] (address 0x0C)"]
[null,null,null,null,null,"Hex.",{"$f":"\"0x\"&DEC2HEX(G99, 2)","v":"0x11"},"0x00","0x1F","Hexadecimal representation of the above value"]
[null,null,null,null,"V5V,STOP [V]",null,{"$f":"IF(G99<7,2.65+0.1*G99,IF(G99<28,3.3+0.05*(G99-7),4.4+0.1*(G99-28)))","v":3.8},"2.65 V","4.70 V","Corresponding 5 V charger stop voltage"]
[]
[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/G104","v":2000},"370 Ω","3704 Ω","Resistor corresponding to the maximum charging current"]

{"sheet":"Revision History","index":1,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Revision","Date","Description"]
[null,"v1.0","November, 2025","Creation of the document"]
[null,"v1.1","December, 2025","Corrected SRC register formula"]

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