{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Vægtfylde","Kapacitet","Ladespænding","Cellespænding","Info","Log"],"not_rendered":{"charts":6,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Vægtfylde","index":0,"n_rows":45,"n_cols":23,"rows_kept":45,"cut":false,"hidden":false,"merged":[[32,7,32,14],[34,7,34,14],[36,7,36,14],[38,7,38,14],[39,20,39,22],[30,7,30,14],[4,8,4,9],[0,1,0,18],[2,1,2,3],[3,1,3,3],[3,17,3,18]]}
[null,"Temperaturens indflydelse på syrens vægtfylden (fuldt opladt). Når temperaturen falder stiger vægtfylden"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(R4,R5,O5)","v":"Vfnominel ved 30 °C 1,29 Kg/L"},null,null,null,{"$f":"IF(R5=K3,\"\",IF(R5<K3,\"Batteriet trænger til opladning\",IF(R3>K3,\"\",\"\")))","v":""}]
[null,"Vægtfylde ",null,null,1.3320000000000001,1.325,1.3180000000000001,1.3109999999999999,1.304,1.2969999999999999,1.29,1.2829999999999999,"Kg/L"]
[null,"Syre temperatur ",null,null,-30,-20,-10,0,10,20,30,40,"°C","Vfmålt"," ved ","Tmålt",null,"Vfnominel ved 30 °C ",null,"Korrektions faktor K1"]
[null,"Korrektionsberegning af vægtfylden som funktion af syre temperaturen",null,null,null,null,null,null,"Vfnominel =",null,"Vfmålt + (K1*(Tmålt - 30 °C)) =",null,null,1.29," Kg/L",30," °C",{"$f":"$N$5+($T$5*($P$5-30))","v":1.29},"Kg/L",6.9999999999999999E-4,"Kg/L/°C"]
[null,"Vfnominel er den vægtfylde, cellen ville have haft, hvis temperaturen havde været 30 °C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Batteri type"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(B4,M4)","v":"Syre temperatur °C"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(B3,M3)","v":"Vægtfylde Kg/L"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"If you want the password to the spreadsheet, send me an email."]
[]
[null,null,null,null,null,null,null,"Udarbejdet af Jørgen Walter ©"]
[]
[]
[]
[null,null,null,null,null,null,null,"www.walter-lystfisker.dk "]
[]
[null,null,null,null,null,null,null,"COPYRIGHT © 2014"]
[null,"walter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reg. No. 1275"]
[]
[]
[null,null,"http://conversion1.smartequip.net/manufacturers/TOUCAN/OPS_DK/MA0272-01_PAGE_64.swf "]
[]
[null,null,"http://www.campingferie.dk/2004Design/forumThread.asp?postGuid=714741 "]

{"sheet":"Kapacitet","index":1,"n_rows":40,"n_cols":23,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,1,0,18],[3,1,3,3],[4,1,4,3],[4,17,4,18],[39,20,39,22],[30,7,30,14],[32,7,32,14],[36,7,36,14],[38,7,38,14],[3,17,3,18]]}
[null,"Temperaturens indflydelse på batteriets kapacitet. Når temperaturen falder, bliver batteriets kapacitet mindre"]
[null,"Årsagen er, at viskositeten ved minus grader er meget højere end ved plus grader. Diffusionen i syren bliver træg både ved afladning og opladning. Derved falder batteriets kapacitet"]
[]
[null,"Batteriets kapacitet ",null,null,0.35,0.5,0.7,0.8,0.9,0.95,1,"%"]
[null,"Syre temperatur ",null,null,-30,-20,-10,0,10,20,30,"°C"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(B5,L5)","v":"Syre temperatur °C"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(B4,L4)","v":"Batteriets kapacitet %"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"If you want the password to the spreadsheet, send me an email."]
[]
[null,null,null,null,null,null,null,"Udarbejdet af Jørgen Walter ©"]
[]
[]
[]
[null,null,null,null,null,null,null,"www.walter-lystfisker.dk "]
[]
[null,null,null,null,null,null,null,"COPYRIGHT © 2014"]
[null,"walter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reg. No. 1275"]

{"sheet":"Ladespænding","index":2,"n_rows":40,"n_cols":23,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,1,0,18],[3,13,3,14],[3,17,3,18],[39,20,39,22],[4,8,4,9],[3,15,3,16],[30,7,30,14],[32,7,32,14],[34,7,34,14],[36,7,36,14],[38,7,38,14]]}
[null,"Temperaturens indflydelse på ladespændingen. Når temperaturen falder skal ladespændingen stige"]
[null,"Indsæt nominel batterispænding fra listen",null,null,null,null,2,"Volt",{"$f":"IF($G$2=6,3,IF($G$2=12,6,IF($G$2=24,12,1)))","v":1},"Celle(r) i batteriet",null,null,null,{"$f":"CONCATENATE(B3,\" \",N5,O5,\"ved \",B4,\" \",P5,Q5)","v":"Ladespænding per celle 2,4 Volt ved Syre temperatur  30 °C"}]
[null,{"$f":"+N3","v":"Ladespænding per celle"},null,null,{"$f":"$I$2*2.64","v":2.64},{"$f":"$I$2*2.6","v":2.6},{"$f":"$I$2*2.56","v":2.56},{"$f":"$I$2*2.52","v":2.52},{"$f":"$I$2*2.48","v":2.48},{"$f":"$I$2*2.44","v":2.44},{"$f":"$I$2*2.4","v":2.4},{"$f":"$I$2*2.36","v":2.36},"volt",{"$f":"IF($G$2=2,\"Ladespænding per celle\",IF($G$2=6,\"Ladespænding for 6 V batteri\",IF($G$2=12,\"Ladespænding for 12 V batteri\",IF($G$2=24,\"Ladespænding for 24 V batteri\",\"\"))))","v":"Ladespænding per celle"}]
[null,"Syre temperatur ",null,null,-30,-20,-10,0,10,20,30,40,"°C","Ladespænding   ved",null,"målt temperatur",null,"Volt/Celle ved 30 °C",null,"Korrektions faktor K3"]
[null,"Korrektionsberegning af ladespændingen som funktion af syre temperaturen",null,null,null,null,null,null,"Vkorrektion",null,"2,4 + (K3*(30 °C-Tmålt)) =",null,null,{"$f":"($R$5+($T$5*(30-$P$5)))*$I$2","v":2.4}," Volt ",30," °C",2.4,"Volt",4.0000000000000001E-3,"V/°C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Batteri type"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(B4,M4)","v":"Syre temperatur °C"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"If you want the password to the spreadsheet, send me an email."]
[]
[null,null,null,null,null,null,null,"Udarbejdet af Jørgen Walter ©"]
[]
[]
[]
[null,null,null,null,null,null,null,"www.walter-lystfisker.dk "]
[]
[null,null,null,null,null,null,null,"COPYRIGHT © 2014"]
[null,"walter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reg. No. 1275"]

{"sheet":"Cellespænding","index":3,"n_rows":40,"n_cols":23,"rows_kept":40,"cut":false,"hidden":false,"merged":[[32,7,32,14],[34,7,34,14],[36,7,36,14],[38,7,38,14],[39,20,39,22],[4,8,4,9],[0,1,0,18],[3,13,3,14],[3,15,3,16],[30,7,30,14]]}
[null,"Temperaturens indflydelse på cellespændingen (fuldt opladt). Når temperaturen falder stiger spændingen"]
[null,"Indsæt nominel cellespænding fra listen",null,null,null,null,2,"Volt",{"$f":"IF(G2=6,3,IF(G2=12,6,IF(G2=24,12,1)))","v":1},"Celle(r) i dit batteri",null,null,null,{"$f":"CONCATENATE(B3,\" \",N5,O5,\"ved \",B4,\" \",P5,Q5)","v":"Cellespænding 2,13 Volt ved Syre temperatur  30 °C"}]
[null,{"$f":"+N3","v":"Cellespænding"},null,null,{"$f":"$I$2*2.172","v":2.1720000000000002},{"$f":"$I$2*2.165","v":2.165},{"$f":"$I$2*2.158","v":2.1579999999999999},{"$f":"$I$2*2.151","v":2.1509999999999998},{"$f":"$I$2*2.144","v":2.1440000000000001},{"$f":"$I$2*2.137","v":2.137},{"$f":"$I$2*2.13","v":2.13},{"$f":"$I$2*2.123","v":2.1230000000000002},"volt",{"$f":"IF($G$2=2,\"Cellespænding\",IF($G$2=6,\"Cellespænding for 6 V batteri\",IF($G$2=12,\"Cellespænding for 12 V batteri\",IF($G$2=24,\"Cellespænding for 24 V batteri\",\"\"))))","v":"Cellespænding"}]
[null,"Syre temperatur ",null,null,-30,-20,-10,0,10,20,30,40,"°C","Cellespænding ved",null,"målt temperatur",null,{"$f":"+N3","v":"Cellespænding"},null,"Korrektions faktor K4"]
[null,"Korrektionsberegning af cellespændigen som funktion af syre temperaturen",null,null,null,null,null,null,"Vkorrektion =",null,"2,13 + (K4*(Tmålt - 30 °)) =",null,null,{"$f":"($R$5+($T$5*(30-$P$5)))*$I$2","v":2.13}," Volt ",30," °C",2.13,"Volt",6.9999999999999999E-4,"V/°C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Batteri type"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(B4,M4)","v":"Syre temperatur °C"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"If you want the password to the spreadsheet, send me an email."]
[]
[null,null,null,null,null,null,null,"Udarbejdet af Jørgen Walter ©"]
[]
[]
[]
[null,null,null,null,null,null,null,"www.walter-lystfisker.dk "]
[]
[null,null,null,null,null,null,null,"COPYRIGHT © 2014"]
[null,"walter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reg. No. 1275"]

{"sheet":"Info","index":4,"n_rows":100,"n_cols":23,"rows_kept":100,"cut":false,"hidden":false,"merged":[[22,13,22,16],[21,1,21,6],[21,10,21,11],[21,15,21,16],[22,9,22,12],[22,1,22,8],[18,9,18,12],[23,1,23,2],[23,5,23,6],[23,9,23,10],[15,2,15,4],[15,10,15,12],[99,20,99,22],[0,1,0,18],[88,7,88,14],[90,7,90,14],[94,7,94,14],[25,1,25,3],[26,1,26,3],[28,1,28,3],[13,2,13,4],[13,10,13,12],[19,1,19,2],[19,13,19,14],[19,5,19,6],[17,1,17,6],[23,13,23,14],[30,12,31,13],[30,14,31,15],[30,16,31,17],[6,11,6,14],[30,1,31,3],[30,6,31,7],[30,8,31,9],[30,4,31,5],[30,10,31,11],[17,15,17,16],[27,1,27,3],[18,13,18,16],[19,9,19,10],[17,10,17,11],[18,1,18,8],[24,1,24,16],[96,7,96,14],[59,12,60,13],[59,14,60,15],[59,16,60,17],[59,1,60,3],[59,4,60,5],[59,6,60,7],[59,8,60,9],[59,10,60,11]]}
[null,"Peukerts formel beregner kan benyttes til at forudsige en ny afladetid ved en anden afladestrøm for et batteri med kendt batterikapacitet"]
[null,"Hvis et batteri er opgivet til 100 Ah₅, betyder det, at batteriet i 20 timer kan afgive 5 A  (5A*20h = 100Ah). Afladetiden er fastsat til 20 timer (C20) og spændingen er faldet til 10,5 V ved 25 °C for et 12 volts batteri."]
[null,"Skal batteriet yde en større strøm end den nominelle (5 A), på en kortere tid end 20 timer, så har batteriet ikke længere den anvendelige kapacitet [Ah] til rådighed. Værdien  falder progressivt med tiden."]
[null,"Til beregning af Batterikapacitet C = [Ah], afladestrøm I = [A] og afladetiden H = [timer], anvendes den modificerede Peukerts lov, hvor k er Peukerts konstant, som er afhængig af batteritype:"]
[]
[null,"Følgende definitioner anvendes",null,null,null,"Følgende k værdier anvendes"]
[null,"C = Batterikapacitet [A*h = Coulomb]",null,null,null,"AGM fra 1,05 til 1,15",null,null,"Absorbed Glass Mat",null,null,"Default data input for brugeren"]
[null,"H = Afladetid [timer]",null,null,null,"GEL fra 1,1 til 1,25",null,null,"Gele"]
[null,"k = Peukert konstant",null,null,null,"VRLA fra 1,2 til 1,6",null,null,"Vedligeholdelsesfrit batteri"]
[null,"I = Afladestrøm [A]",null,null,null,"Bly/Syre fra 1,1 til 1,3",null,null,"Bly og Svovlsyre/destilleret vand"]
[null,"t= tid [timer]"]
[]
[null,null,"Værdierne C, H og I er normalt oplyst på batteriet eller i databladet. Antag et batteri på 100 Ah₅ - hvor(₅) betyder 5 A afladestrøm, (C20) normværdi 20 timer afladetid og k = 1,3 fås:"]
[null,"H1:","Peukerts lov: t=H*(C/(I*H))ᵏ =",null,null,{"$f":"$H$20*(POWER(($D$20/($P$20*$H$20)),$L$20))","v":20},"timer","kan omskrives til",null,"C1:","Peukerts lov: I*t=C*(C/(I*H))ᵏ⁻¹ =",null,null,{"$f":"$D$20*(POWER(($D$20/($P$20*$H$20)),($L$20-1)))","v":100},"Ah"]
[null,null,"Det samme batteri hvor afladestrømmen er ændret til:",null,null,null,null,{"$f":"+P24","v":20},"A","giver følgende data:"]
[null,"H2:","Peukerts lov: t=H*(C/(I*H))ᵏ =",null,null,{"$f":"$H$24*(POWER(($D$24/($P$24*$H$24)),$L$24))","v":3.2987697769322351},"timer","kan omskrives til",null,"C2:","Peukerts lov: I*t=C*(C/(I*H))ᵏ⁻¹ =",null,null,{"$f":"$D$24*(POWER(($D$24/($P$24*$H$24)),($L$24-1)))","v":65.975395538644705},"Ah"]
[]
[null,"C1 cellekapaciteten som funktion af forbruget på et",null,null,null,null,null,{"$f":"+N14","v":100},"Ah","batteri","med afladestrøm på",null,{"$f":"+P20","v":5},"A     og",{"$f":"+F14","v":20},"timer afladetid"]
[null,"Indsæt norm værdierne for batteriet, som skal beregnes i gule celler",null,null,null,null,null,null,null,"Batteritype vælg værdien k",null,null,null,"Her aflæses norm afladestrømmen"]
[null,"C = Batterikapacitet",null,100,"[Ah]","H = Afladetid ",null,20," [timer]","Peukert konstant",null,1.3,"[k]","I = Afladestrøm ",null,{"$f":"+ROUND(D20/H20,3)","v":5}," [A]"]
[]
[null,"C2 cellekapaciteten på det samme batteri med ændret aflæadestrøm",null,null,null,null,null,{"$f":"+N16","v":65.975395538644705},"Ah","batteri","med afladestrøm på",null,{"$f":"+P24","v":20},"A     og",{"$f":"+F16","v":3.2987697769322351},"timer afladetid"]
[null,"Beregnede værdier for batteriet med ny afladestrøm",null,null,null,null,null,null,null,"Batteritype som overfor",null,null,null,"Herunder indsættes en ny afladestrøm"]
[null,"C = Batterikapacitet",null,{"$f":"H24*P24","v":65.975395538644705},"[Ah]","H = Afladetid ",null,{"$f":"(D20*(D20/H20)^(L20-1))/P24^(L20)","v":3.2987697769322351}," [timer]","Peukert konstant",null,{"$f":"+L20","v":1.3},"[k]","I = Afladestrøm ",null,20," [A]"]
[null,"Beregnede resultater indsat i diagram"]
[null,"Afladnings strøm [A]",null,null,{"$f":"($W$26/10)*0.1","v":1},{"$f":"($W$26/10)*0.2","v":2},{"$f":"($W$26/10)*0.3","v":3},{"$f":"($W$26/10)*0.4","v":4},{"$f":"($W$26/10)*0.5","v":5},{"$f":"($W$26/10)*0.6","v":6},{"$f":"($W$26/10)*0.7","v":7},{"$f":"($W$26/10)*0.8","v":8},{"$f":"($W$26/10)*0.9","v":9},{"$f":"($W$26/10)*1","v":10},{"$f":"($W$26/10)*2","v":20},{"$f":"($W$26/10)*3","v":30},{"$f":"($W$26/10)*4","v":40},{"$f":"($W$26/10)*5","v":50},{"$f":"($W$26/10)*6","v":60},{"$f":"($W$26/10)*7","v":70},{"$f":"($W$26/10)*8","v":80},{"$f":"($W$26/10)*9","v":90},{"$f":"+D20","v":100}]
[null,"Tid [h]",null,null,{"$f":"$H$20*(POWER(($D$20/(E26*$H$20)),$L$20))","v":162.06565966927624},65.819110216711877,38.853788356357192,26.730864999779701,{"$f":"$H$20*(POWER(($D$20/(I26*$H$20)),$L$20))","v":20},{"$f":"$H$20*(POWER(($D$20/(J26*$H$20)),$L$20))","v":15.779541349984566},12.914082284940132,10.856104576373042,9.3148472830162738,8.1225239635623545,3.2987697769322355,1.9473022702262184,1.3397168281703666,1.0023744672545445,0.79085046771059164,0.64723731752241043,0.54409410206007758,0.46684825414354375,0.40709053153690433]
[null,"Peukerts korrigerede amp. Ip",null,null,{"$f":"E26^$L$20/($D$20/$H$20)^($L$20-1)","v":0.6170338627200096},1.5193155858647478,2.573751601332285,3.7409937912904851,{"$f":"I26^$L$20/($D$20/$H$20)^($L$20-1)","v":5},{"$f":"J26^$L$20/($D$20/$H$20)^($L$20-1)","v":6.3373198106355497},7.7434848093399467,9.2114072130105971,10.735549060726918,12.311444133449168,30.314331330207967,51.35309578229117,74.642639322944618,99.763115748443965,126.44615396066821,154.50283426609988,183.79173679952552,214.20236471367963,245.6456052231583]
[null,"Total [Ah] tilgængelig",null,null,{"$f":"E26*E27","v":162.06565966927624},131.63822043342375,116.56136506907157,106.9234599991188,{"$f":"I26*I27","v":100},{"$f":"J26*J27","v":94.677248099907388},90.398575994580924,86.848836610984335,83.833625547146468,81.225239635623552,65.975395538644705,58.419068106786554,53.588673126814669,50.118723362727224,47.451028062635501,45.306612226568731,43.527528164806206,42.016342872918941,40.709053153690434]
[]
[null,{"$f":"+B26","v":"Afladnings strøm [A]"},null,null,{"$f":"+P24","v":20},null,{"$f":"+B27","v":"Tid [h]"},null,{"$f":"$H$20*(POWER(($D$20/(E31*$H$20)),$L$20))","v":3.2987697769322355},null,{"$f":"+B28","v":"Peukerts korrigerede amp. Ip"},null,{"$f":"E31^$L$20/($D$20/$H$20)^($L$20-1)","v":30.314331330207967},null,{"$f":"+B29","v":"Total [Ah] tilgængelig"},null,{"$f":"E31*I31","v":65.975395538644705}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"CONCATENATE(B60,\", \",G60,\", \",K60,\" og \",O60)","v":"Afladnings strøm [A], Tid [h], Peukerts korrigerede amp. Ip og Total [Ah] tilgængelig"}]
[null,{"$f":"+B31","v":"Afladnings strøm [A]"},null,null,{"$f":"+E31","v":20},null,{"$f":"+G31","v":"Tid [h]"},null,{"$f":"+I31","v":3.2987697769322355},null,{"$f":"+K31","v":"Peukerts korrigerede amp. Ip"},null,{"$f":"+M31","v":30.314331330207967},null,{"$f":"+O31","v":"Total [Ah] tilgængelig"},null,{"$f":"+Q31","v":65.975395538644705}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Se også disse website",null,null,null,null,null,"If you want the password to the spreadsheet, send me an email."]
[null,"https://en.wikipedia.org/wiki/Automotive_battery "]
[null,"https://en.wikipedia.org/wiki/Deep_cycle_battery ",null,null,null,null,null,"Udarbejdet af Jørgen Walter ©"]
[null,"https://en.wikipedia.org/wiki/Peukert%27s_law "]
[null,"https://en.wikipedia.org/wiki/VRLA_battery "]
[null,"https://en.wikipedia.org/wiki/Battery_electric_vehicle "]
[null,"http://www.smartgauge.co.uk/peukert_depth.html ",null,null,null,null,null,"www.walter-lystfisker.dk "]
[null,"https://en.wikipedia.org/wiki/Coulomb "]
[null,"https://en.wikipedia.org/wiki/Rechargeable_battery ",null,null,null,null,null,"COPYRIGHT © 2014"]
[]
[]
[null,"walter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reg. No. 1275"]

{"sheet":"Log","index":5,"n_rows":50,"n_cols":21,"rows_kept":50,"cut":false,"hidden":false,"merged":[[12,13,13,13],[12,14,13,16],[47,5,47,12],[49,20,49,22],[2,11,2,14],[0,1,0,20],[39,5,39,12],[41,5,41,12],[45,5,45,12],[28,3,28,4],[12,2,12,4],[13,2,13,4],[12,1,13,1],[12,5,13,5],[6,17,6,18],[12,10,13,11]]}
[null,"En matematisk analyse bagved Peukerts ligning (Peukerts lov)"]
[null,"Følgende definitioner anvendes",null,null,"Følgende k værdier anvendes"]
[null,"C = Batterikapacitet [A*h]",null,null,"AGM fra 1,05 til 1,15",null,null,"Absorbed Glass Mat",null,null,null,"Default data input for brugeren"]
[null,"H = Afladetid [timer]",null,null,"GEL fra 1,1 til 1,25",null,null,"Gele"]
[null,"k = Peukert konstant",null,null,"VRLA fra 1,2 til 1,6",null,null,"Vedligeholdelsesfrit batteri"]
[null,"I = Afladestrøm [A]",null,null,"Bly/Syre fra 1,1 til 1,3",null,null,"Bly og Svovlsyre/destilleret vand"]
[null,"t= tid [timer]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indsæt dine værdier"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H1","C1"]
[null,"Afladetid 1 (H1)",{"$f":"+Info!H20","v":20},"timer",null,"Capacity (C1)",{"$f":"+Info!D20","v":100}," Ah",{"$f":"+Info!P20","v":5},"[A]","t1=C*(C/H)ᵏ⁻¹/Iᵏ =",{"$f":"($G$9*($G$9/$C$9)^($F$13-1))/$I$9^$F$13","v":20},"timer","afladning med",{"$f":"+I9","v":5},{"$f":"+J9","v":"[A]"},null,20,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H2","C2"]
[null,"Afladetid 2 (H2)",{"$f":"+Info!H24","v":3.2987697769322351},"timer",null,"Capacity (C2)",{"$f":"+Info!D24","v":65.975395538644705}," Ah",{"$f":"+Info!P24","v":20},{"$f":"+J9","v":"[A]"},"t2=C*(C/H)ᵏ⁻¹/Iᵏ =",{"$f":"($G$9*($G$9/$C$9)^($F$13-1))/$I$11^$F$13","v":3.2987697769322351},"timer","afladning med",{"$f":"+I11","v":20},{"$f":"+P9","v":"[A]"},null,10.3,10.3]
[]
[null,"Peukert's konstant = k","          Log (H2/H1)",null,null,{"$f":"((LOG10(C11))-(LOG10(C9)))/((LOG10(G9/C9))-(LOG10(G11/C11)))","v":1.3},null,null,null,null,"Peukert's konstant = k",null,null,{"$f":"((LOG10(R11))-(LOG10(R9)))/((LOG10(S9/R9))-(LOG10(S11/R11)))","v":1.2990506886208804},"for dit batteri"]
[null,null,"Log (C1/H1)-Log(C2/H2)"]
[]
[null,"Antag at et batteridatablad viser en kapacitet på 100 Ah og 20 timer eller 65,98 Ah og 3,30 timer, dvs. 100 Ah @ 20 timer eller 65,98 Ah @ 3,30 timer, så taler vi om det samme batteri."]
[null,"Forskellen ligger i, at det første sæt data aflader med 5 A, og det andet sæt data med 20 A. Jeg har valgt disse værdier, efter som jeg har beregnet dem på Ark Info, så det gør kontrollen med formlen lettere."]
[null,"Disse tal svare til et batteri normeret til 100 Ah, 5 A afladestrøm ved 20 timer med en Peukerts konstant k på 1,3. Det er benævnt som batteriets \"omdrejnings\" punkt. Data på batteriet er listet således 100 Ah₅."]
[null,"[ ₅ betyder 5 A og normtiden (20) er vedtaget til 20 timer, så 5*20=100. Peukerts konstant opgives sjældent]"]
[]
[null,"Strøm højere end 5 A vil medføre kortere \"batteritid\" end en simpel ampere*tid beregning ville indikere. (Vi ser bort fra selvafladning i batteriet)"]
[null,"Strøm lavere end 5 A vil medføre længere \"batteritid\" end en simpel ampere*tid beregning ville indikere. (Vi ser bort fra selvafladning i batteriet)"]
[null,"Lad os kalde dette batteriets \"omdrejnings\" punktet ved 5 A."]
[]
[null,"Anvendes den modificerede ligning [t = C* (C / H)ᵏ⁻¹ / Iᵏ] findes batteriets \"omdrejnings\" punktet til at være normværdien af afladestrømmen for det valgte batteri her:",null,null,null,null,null,null,null,null,null,null,null,null,null,"I",{"$f":"+Info!P20","v":5},{"$f":"+P9","v":"[A]"}]
[null,"som svarer til batteriets kapacitet, divideret med afladetiden dvs. C /H. På grund af dette vil Peukerts korrigerede ampere (IP) være forskellig i hvert enkelt tilfælde her:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Ip",{"$f":"+Info!M31","v":30.314331330207967},{"$f":"+R25","v":"[A]"}]
[null,"men den endelige batterikapacitet beregnet med begge ligninger vil være identiske, fordi batteriet kapacitet er blevet angivet forskelligt i hvert enkelt tilfælde."]
[]
[null,"Batterikapacitet 1 = H1 * Afladestrøm 1 = ",null,{"$f":"C9*I9","v":100},null,"[Ah]",null,"Batterikapacitet 2 = H2 * Peukerts korrigerede afladestrøm  = ",null,null,null,null,null,{"$f":"C11*Q26","v":100},"[Ah]"]
[]
[null,"Forhåbentligt et det nu klart, hvorfor Peukerts ligning den normale [t=C/Iᵏ], ikke kan bruges med normale batteri data."]
[null,"Man kan enten bruge den modificerede udgave af ligningen [t = C* (C / H)ᵏ⁻¹ / Iᵏ]. Som i sagens natur korrigerer for det specifikke batteri"]
[null,"med en afladningsstrøm som ikke er 1 A, hvor man ellers kunne bruge den normale version t = C / Iᵏ."]
[]
[null,"Hvad betyder så dette? Oftest indeholder producentens manual eller websted ikke Peukerts konstant k for batteriet."]
[null,"Men der er ofte en graf, der viser afladningstid mod afladningsstrøm. Eller undertiden en tabel, der viser tilgængelige afladningstider ved forskellige afladningsstrømme."]
[null,"Denne information kan bruges til at beregne Peukerts konstant for batteritype."]
[null,"Alt hvad der behøves er 2 afladningstider og 2 afladningsstrømme. Disse kan enten aflæses direkte i tabellen eller fra grafen."]
[]
[null,null,null,null,null,"If you want the password to the spreadsheet, send me an email."]
[]
[null,null,null,null,null,"Udarbejdet af Jørgen Walter ©"]
[]
[]
[]
[null,null,null,null,null,"www.walter-lystfisker.dk "]
[]
[null,null,null,null,null,"COPYRIGHT © 2014"]
[]
[null,"walter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reg. No. 1275"]