2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Battery Data Science - Analysis of Slope/Plateau capacity

Hello fellow people,

I have a problem I cannot solve since 2 hours.

I have data for a battery which includes.

  1. Voltage (0-2V) (Got recorded every 0.01 to 0.05V - so there is no repetition)

  2. Cycle number (0-35) however I just need Cycle 0-4 and 25-29

  3. Capacity of my discharge

  4. Capacity of my charge

I want to calculate my sloping and plateau capacity. Means. My capacity at point ~0.1 and ~0.0 (for discharge) and ~0.1 and ~2V (for charge)

However I do not have values for exactly 0.1, but something along 0.10008.

I never get to extract the 1 point that is around i.e., ~0.1V, for me it could just be the next dataset above 0.1V.

Because I have alot of data I do not want to do this by hand for each of the 10 cycles of each of my batteries, but want to get a script for OriginPro or Excel.

I cant get it done alone. I asked AI. I cant get done.

I know it seems like such a small problem, but I am not experienced enough in OriginPro or Excel to get it to work.

I hope you can help me or recommend me a community that can help me! Thanks alot!

submitted by /u/Initial-Vehicle9688
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article