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

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#conversational data analysis
#Excel compatibility
#big data management in spreadsheets
#real-time data collaboration
#intelligent data visualization
#rows.com
#large dataset processing
#Battery
#Voltage
#Capacity
#Cycle number
#Discharge
#Charge
#Data analysis
#Sloping capacity
#Plateau capacity
#Data extraction