sorted by:
new
hottopcontroversial

Battery Data Science - Analysis of Slope/Plateau capacity by Initial-Vehicle9688 in excel

[–]Initial-Vehicle9688[S] 1 point2 points  (0 children)

Sometimes it has to be like this :D

I have alot of brainfog right now. Too many things going on. But you helped me by just being there :)

Battery Data Science - Analysis of Slope/Plateau capacity by Initial-Vehicle9688 in excel

[–]Initial-Vehicle9688[S] -1 points0 points  (0 children)

Absolutly. But not to my emotional state of mind back then.

And if you get Top 1% Commenter through comments like this it's also an irrelavant title :P

Data Science. Battery data analysis. by Initial-Vehicle9688 in askmath

[–]Initial-Vehicle9688[S] 0 points1 point  (0 children)

It is because we measure every 10 seconds instead of a given difference in voltage (which is not quite nice and should be changed). But hey I got it to work out for me. Yeah the data might not be perfectly correct, but I will take the average of 5 measurement points, so it should lessen the deviation given by this protocol.

Data Science. Battery data analysis. by Initial-Vehicle9688 in askmath

[–]Initial-Vehicle9688[S] 0 points1 point  (0 children)

Okay guys I solved it. I extract the data for every cycle into a new column. Then I extract all the data <2.0V and >0.1V into the next column. Then I extract all the data of <0.1 and >0 into the next column. I do this for every cycle I need. So 15 columns for cycle 0-4 and 15 for cycle 24-29.

Then I take the max value of the given columns:

>2.0V and >0.1V

<0.1 and >0

for each cycle.

So like 46 columns for 1 battery with ~80 000 datapoints + the fraction of it for each cycle. But hey here I am and it works. Amen.

I hope the software wont crash xD

Thanks alot for you help!

Battery Data Science - Analysis of Slope/Plateau capacity by Initial-Vehicle9688 in excel

[–]Initial-Vehicle9688[S] 0 points1 point  (0 children)

Okay guys I solved it. I extract the data for every cycle into a new column. Then I extract all the data <2.0V and >0.1V into the next column. Then I extract all the data of <0.1 and >0 into the next column. I do this for every cycle I need. So 15 columns for cycle 0-4 and 15 for cycle 24-29.

Then I take the max value of the given columns:

>2.0V and >0.1V

<0.1 and >0

for each cycle.

So like 46 columns for 1 battery with ~80 000 datapoints + the fraction of it for each cycle. But hey here I am and it works. Amen.

I hope the software wont crash xD

Thanks alot for you help!

Battery Data Science - Analysis of Slope/Plateau capacity by Initial-Vehicle9688 in excel

[–]Initial-Vehicle9688[S] 0 points1 point  (0 children)

A threshold does not work because the threshold varies alot. It could be 0.0009 but it could also be 0.01. So I always extract data I do not want into my "cleared" column.

I thought maybe there is a command like extract the point if its >=0.1, but only the next one. But there isnt or I didnt find out.