{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["12V-10A","24V-15A","Datasheet"],"not_rendered":{"images":3,"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"12V-10A","index":0,"n_rows":48,"n_cols":22,"rows_kept":48,"merged":[[4,13,4,14],[4,15,4,16],[4,18,4,21],[5,18,5,21],[24,19,24,20],[26,19,26,20],[28,19,28,20],[29,19,29,20],[32,19,32,20],[34,13,34,14],[34,15,34,16],[35,19,35,20],[38,13,38,14],[38,15,38,16],[39,19,39,20],[42,13,42,14],[42,15,42,16],[43,19,43,20],[46,13,46,14],[46,15,46,16],[47,19,47,20]],"flags":["formulas_cached_only"]}
[]
[null,null,"Utilisation : Entrer les valeurs dans les cellules sur fond jaune",{"$nulls":7},"Protection SANS mot de passe"]
[]
[]
[null,null,"Désignations","Data",null,"Value","U",null,"Formule",null,"Résultat","U",null,"(E24)",null,"(E48)",null,null,"Schéma"]
[{"$nulls":10},"théorique",{"$nulls":7},"actuel"]
[null,null,"TRANSFO (Vac)","VTR",null,15,"V",null,"= VTR",null,15,"V"]
[{"$nulls":3},"ITR",null,10,"A",null,"= ITR",null,10,"A"]
[null,null,"Chute D1","VD1",null,0.6,"V",null,"=VD1",null,0.6,"V"]
[null,null,"Chute T1e-c","VT1",null,0.6,"V",null,"= VT1",null,0.6,"V"]
[null,null,"Chutes…?","VCH",null,null,"V",null,"= VD1 + VT1",null,1.2,"V"]
[null,null,"ALIM Vcc","VIN",null,null,"V",null,"= VTR * 1,414",null,{"v":21.209999999999997,"d":"21.2"},"V"]
[null,null,"BATTERIE"]
[null,null,"Bat Mini } ?","VF",null,11,"V",null,"= VF…?",null,11,"V"]
[null,null,"Bat OK } ?","VT",null,12,"V",null,"= VT…?",null,12,"V"]
[null,null,"Bat Maxi } ?","VOC",null,13,"V",null,"= VOC…?",null,13,"V"]
[null,null,"Capacité } ?","AhBAT",null,7,"Ah",null,"= AhBAT",null,7,"Ah"]
[null,null,"UC3906 (schéma)"]
[null,null,"? }","V12",null,null,"V",null,"=0,95VOC'",null,12.35,"V"]
[null,null,"? }","V31",null,null,"V",null,"=0,90VF'",null,9.9,"V"]
[{"$nulls":3},"Vref",null,2.3,"V",null,"= Vref",null,2.3,"V"]
[{"$nulls":3},"Vchg",null,0.25,"V",null,"= Vsht",null,0.25,"V"]
[null,null,"? }","IT",null,null,"A",null,"=AhBAT*20/100…?",null,1.4,"A"]
[{"$nulls":3},"ID",null,75,"µA",null,"= ID",null,75,"µA"]
[null,null,"r12","RC",null,null,"kW",null,"= Vref / ID * 1000",null,30.666666666666664,"kW",null,30,"kW",30.9,"kW",null,null,"6,8k",null,"r12"]
[{"$nulls":3},"RSUM",null,null,"kW",null,"= (VF - Vref) / ID * 1000",null,115.99999999999999,"kW",null,"(102)",null,"(117)"]
[null,null,"r13","RD",null,null,"kW",null,"= Vref * RSUM / (VOC - VF)",null,133.39999999999998,"kW",null,120,"kW",133,"kW",null,null,"10k",null,"r13"]
[{"$nulls":3},"Rx",null,null,"kW",null,"= RC * RD / (RC +RD)",null,24.934579439252335,"kW",null,24,"kW",{"v":25.074435631482608,"d":"25"},"kW"]
[null,null,"r10","RA",null,null,"kW",null,"= (RSUM + Rx) * (1 - Vref / VT)",null,113.9221183800623,"kW",null,100,"kW",115,"kW",null,null,"15k",null,"r10"]
[null,null,"r11","RB",null,null,"kW",null,"= RSUM - RA",null,2.077881619937685,"kW",null,2,"kW",{"v":2,"d":"2.00"},"kW",null,null,"560W",null,"r11"]
[null,null,"Courant de Charge",{"$nulls":8},"brut }",null,"(16)",null,"(1)"]
[]
[null,null,"0 strap","RS0",null,1,"W",null,"= RS0",null,1,"W",null,1,"W",1,"W",null,null,"1W / 1W",null,"r5 à r8"]
[null,null,"(r5)","Imax0",null,null,"A",null,"= Vsht / RS0",null,0.25,"A"]
[null,null,"? }","IOCT0",null,null,"mA",null,"= Imax0 / 10 * 1000",null,25,"mA",null,"RT0",null,"RT0"]
[null,null,"r9","RT0",null,null,"W",null,"=(VIN - VT - 2,5) / IT0 (Imax0…?)",null,26.83999999999999,"W",null,{"v":27,"d":"27.00"},"W",{"v":27.4,"d":"27.40"},"W",null,null,"330W",null,"r9"]
[null,null,"1 strap","RS1",null,null,"W",null,"= RS0 / 2",null,0.5,"W"]
[null,null,"(r5//r6)","Imax1",null,null,"A",null,"= Vsht / RS1",null,0.5,"A"]
[null,null,"? }","IOCT1",null,null,"mA",null,"= Imax1 / 10 * 1000",null,50,"mA",null,"RT0/2",null,"RT0/2"]
[null,null,"r9","RT1",null,null,"W",null,"=(VIN - VT - 2,5) / IT1 (Imax1…?)",null,13.419999999999995,"W",null,{"v":13.5,"d":"13.50"},"W",{"v":13.7,"d":"13.70"},"W",null,null,"330W",null,"r9"]
[null,null,"2 straps","RS2",null,null,"W",null,"= RS0 / 3",null,0.3333333333333333,"W"]
[null,null,"(r5//r6//r7)","Imax2",null,null,"A",null,"= Vsht / RS2",null,0.75,"A"]
[null,null,"? }","IOCT2",null,null,"mA",null,"= Imax2 / 10 * 1000",null,75,"mA",null,"RT0/3",null,"RT0/3"]
[null,null,"r9","RT2",null,null,"W",null,"=(VIN - VT - 2,5) / IT2 (Imax2…?)",null,8.946666666666664,"W",null,{"v":9,"d":"9.00"},"W",{"v":9.1,"d":"9.10"},"W",null,null,"330W",null,"r9"]
[null,null,"3 straps","RS3",null,null,"W",null,"= RS0 / 4",null,0.25,"W"]
[null,null,"(r5//r6//r7//r8)","Imax3",null,null,"A",null,"= Vsht / RS3",null,1,"A"]
[null,null,"? }","IOCT3",null,null,"mA",null,"= Imax3 / 10 * 1000",null,100,"mA",null,"RT0/4",null,"RT0/4"]
[null,null,"r9","RT3",null,null,"W",null,"=(VIN - VT - 2,5) / IT3 (Imax3…?)",null,6.709999999999997,"W",null,6.75,"W",6.85,"W",null,null,"330W",null,"r9"]

{"sheet":"24V-15A","index":1,"n_rows":48,"n_cols":22,"rows_kept":48,"merged":[[4,13,4,14],[4,15,4,16],[4,18,4,21],[5,18,5,21],[24,19,24,20],[26,19,26,20],[28,19,28,20],[29,19,29,20],[32,19,32,20],[34,13,34,14],[34,15,34,16],[35,19,35,20],[38,13,38,14],[38,15,38,16],[39,19,39,20],[42,13,42,14],[42,15,42,16],[43,19,43,20],[46,13,46,14],[46,15,46,16],[47,19,47,20]],"flags":["formulas_cached_only"]}
[]
[null,null,"Utilisation : Entrer les valeurs dans les cellules sur fond jaune",{"$nulls":7},"Protection SANS mot de passe"]
[]
[]
[null,null,"Désignations","Data",null,"Value","U",null,"Formule",null,"Résultat","U",null,"(E24)",null,"(E48)",null,null,"Schéma"]
[{"$nulls":10},"théorique",{"$nulls":7},"actuel"]
[null,null,"TRANSFO (Vac)","VTR",null,20,"V",null,"= VTR",null,20,"V"]
[{"$nulls":3},"ITR",null,15,"A",null,"= ITR",null,15,"A"]
[null,null,"Chute D1","VD1",null,0.6,"V",null,"=VD1",null,0.6,"V"]
[null,null,"Chute T1e-c","VT1",null,0.6,"V",null,"= VT1",null,0.6,"V"]
[null,null,"Chutes…?","VCH",null,null,"V",null,"= VD1 + VT1",null,1.2,"V"]
[null,null,"ALIM Vcc","VIN",null,null,"V",null,"= VTR * 1,414",null,{"v":28.279999999999998,"d":"28.3"},"V"]
[null,null,"BATTERIE"]
[null,null,"Bat Mini } ?","VF",null,23,"V",null,"= VF…?",null,23,"V"]
[null,null,"Bat OK } ?","VT",null,24,"V",null,"= VT…?",null,24,"V"]
[null,null,"Bat Maxi } ?","VOC",null,25,"V",null,"= VOC…?",null,25,"V"]
[null,null,"Capacité } ?","AhBAT",null,10,"Ah",null,"= AhBAT",null,10,"Ah"]
[null,null,"UC3906 (schéma)"]
[null,null,"? }","V12",null,null,"V",null,"=0,95VOC'",null,23.75,"V"]
[null,null,"? }","V31",null,null,"V",null,"=0,90VF'",null,20.7,"V"]
[{"$nulls":3},"Vref",null,2.3,"V",null,"= Vref",null,2.3,"V"]
[{"$nulls":3},"Vchg",null,0.25,"V",null,"= Vsht",null,0.25,"V"]
[null,null,"? }","IT",null,null,"A",null,"=AhBAT*20/100…?",null,2,"A"]
[{"$nulls":3},"ID",null,75,"µA",null,"= ID",null,75,"µA"]
[null,null,"r12","RC",null,null,"kW",null,"= Vref / ID * 1000",null,30.666666666666664,"kW",null,30,"kW",30.9,"kW",null,null,"1,5k",null,"r12"]
[{"$nulls":3},"RSUM",null,null,"kW",null,"= (VF - Vref) / ID * 1000",null,275.99999999999994,"kW",null,"(271)",null,"(275)"]
[null,null,"r13","RD",null,null,"kW",null,"= Vref * RSUM / (VOC - VF)",null,317.3999999999999,"kW",null,330,"kW",316,"kW",null,null,"10k",null,"r13"]
[{"$nulls":3},"Rx",null,null,"kW",null,"= RC * RD / (RC +RD)",null,27.964757709251096,"kW",null,{"v":27.5,"d":"28"},"kW",{"v":28.1475929662727,"d":"28"},"kW"]
[null,null,"r10","RA",null,null,"kW",null,"= (RSUM + Rx) * (1 - Vref / VT)",null,274.83480176211447,"kW",null,270,"kW",274,"kW",null,null,"15k",null,"r10"]
[null,null,"r11","RB",null,null,"kW",null,"= RSUM - RA",null,1.1651982378854768,"kW",null,1.2,"kW",1.15,"kW",null,null,"560W",null,"r11"]
[null,null,"Courant de Charge",{"$nulls":8},"brut }",null,"(6)",null,"(2)"]
[]
[null,null,"0 strap","RS0",null,1,"W",null,"= RS0",null,1,"W",null,1,"W",1,"W",null,null,"1W / 1W",null,"r5 à r8"]
[null,null,"(r5)","Imax0",null,null,"A",null,"= Vsht / RS0",null,0.25,"A"]
[null,null,"? }","IOCT0",null,null,"mA",null,"= Imax0 / 10 * 1000",null,25,"mA",null,"RT0",null,"RT0"]
[null,null,"r9","RT0",null,null,"W",null,"=(VIN - VT - 2,5) / IT0 (Imax0…?)",null,7.11999999999999,"W",null,{"v":6.8,"d":"6.80"},"W",7.15,"W",null,null,"330W",null,"r9"]
[null,null,"1 strap","RS1",null,null,"W",null,"= RS0 / 2",null,0.5,"W"]
[null,null,"(r5//r6)","Imax1",null,null,"A",null,"= Vsht / RS1",null,0.5,"A"]
[null,null,"? }","IOCT1",null,null,"mA",null,"= Imax1 / 10 * 1000",null,50,"mA",null,"RT0/2",null,"RT0/2"]
[null,null,"r9","RT1",null,null,"W",null,"=(VIN - VT - 2,5) / IT1 (Imax1…?)",null,3.559999999999995,"W",null,{"v":3.4,"d":"3.40"},"W",{"v":3.575,"d":"3.58"},"W",null,null,"330W",null,"r9"]
[null,null,"2 straps","RS2",null,null,"W",null,"= RS0 / 3",null,0.3333333333333333,"W"]
[null,null,"(r5//r6//r7)","Imax2",null,null,"A",null,"= Vsht / RS2",null,0.75,"A"]
[null,null,"? }","IOCT2",null,null,"mA",null,"= Imax2 / 10 * 1000",null,75,"mA",null,"RT0/3",null,"RT0/3"]
[null,null,"r9","RT2",null,null,"W",null,"=(VIN - VT - 2,5) / IT2 (Imax2…?)",null,2.37333333333333,"W",null,{"v":2.2666666666666666,"d":"2.27"},"W",{"v":2.4,"d":"2.40"},"W",null,null,"330W",null,"r9"]
[null,null,"3 straps","RS3",null,null,"W",null,"= RS0 / 4",null,0.25,"W"]
[null,null,"(r5//r6//r7//r8)","Imax3",null,null,"A",null,"= Vsht / RS3",null,1,"A"]
[null,null,"? }","IOCT3",null,null,"mA",null,"= Imax3 / 10 * 1000",null,100,"mA",null,"RT0/4",null,"RT0/4"]
[null,null,"r9","RT3",null,null,"W",null,"=(VIN - VT - 2,5) / IT3 (Imax3…?)",null,1.7799999999999976,"W",null,{"v":1.7,"d":"1.70"},"W",{"v":1.7875,"d":"1.79"},"W",null,null,"330W",null,"r9"]

{"sheet":"Datasheet","index":2,"n_rows":88,"n_cols":11,"rows_kept":88,"merged":[[3,2,3,3],[65,2,66,2],[66,8,66,9],[68,2,69,2],[68,8,69,9],[68,10,69,10],[71,2,72,2],[71,8,71,9]],"flags":["formulas_cached_only"]}
[]
[null,"Datasheet UC3906",null,"Exemple en 12V"]
[]
[null,null,"(Straps)",{"$nulls":3},"Imax = 0,25A à 1 A selon straps"]
[null,"              VIN",{"$nulls":7},"12V ou 24V"]
[]
[]
[]
[]
[{"$nulls":3},"Vsht"]
[]
[]
[]
[]
[]
[]
[{"$nulls":3},"            Vref"]
{"$rows_empty":28}
[{"$nulls":9},"Faible"]
[{"$nulls":9},"Fort"]
[{"$nulls":9},"Normal"]
{"$rows_empty":17}
[null,null,"Pin10"]
[{"$nulls":8},"STATE1 : 10=Vss+9=Vin",null,"Jaune"]
[]
[null,null,"Pin9",{"$nulls":5},"STATE2 : 9=Vss",null,"Rouge"]
[]
[]
[null,null,"Pin1&8",{"$nulls":5},"STATE3 : 10=Vin",null,"Vert"]
[]
[]
[]
[]
[null,"A - Mise sous tension (VIN) : la batterie se charge au taux de courant de maintien (IOCT...?) : Pin 7 à l'état bas"]
[null,"B - La tension de la batterie atteint VT, activant le pilote et désactivant la sortie de polarisation d'entretien. Chargement de la batterie à Imax"]
[null,"C - La tension de transition V12 est atteinte et le chargeur indique qu'il est désormais à State 2 (état de surcharge : Pin 9 état bas )"]
[null,"D - La tension de la batterie s'approche du niveau de surcharge VOC et le courant de charge commence à diminuer"]
[null,"E - Le courant de charge diminue jusqu'à l'IOCT (?). La sortie de l'amplificateur de détection de courant, dans ce cas, l'entrée OC TERMINATE"]
[null,"      Pin 8 passe au niveau haut. Le chargeur passe à l'état float et maintient la tension de la batterie à VF"]
[null,"F - Ici une charge (>Imax) commence à décharger la batterie"]
[null,"G - Elle décharge la batterie, et lorsque la tension de la batterie tombe en dessous de V31. Le chargeur est à nouveau à State 1."]
[]
[null,"?  ?  ?  ?","IT ?"]
[null,null,"IOCT ?"]
[null,null,"CD4093 : Utiliser Pin10 pour affichage STATE 3 (ajout de 2 diodes shottky d5 et d6)?"]