Daily Archives: 23-December-2020

Optimized Piecewise Linear Model Using Excel

I was recently asked to create a piecewise linear model for a rather complex battery discharge curve, which is a type of task that I have performed dozens of times. I was told to perform this task in Excel because that is the only computation tool that this customer uses. I normally do this task in R because I like the segmented package, however, Excel does a very good job with the task, especially if you use the Solver add-in to "tune" the model. Continue reading

Posted in Batteries, Excel | Leave a comment