Stay on top of your Powerwall's longevity with our DIY degradation calculator. Monitor health, understand degradation, and be proactive.

Battery state of health estimator spreadsheet

Most of us know that home batteries inevitably degrade over time, but understanding how to quantify that degradation and take proactive steps remains a mystery.

In this article, I’m excited to introduce you to a DIY battery health estimator spreadsheet. By the time you finish reading, you’ll have this handy tool at your fingertips and the know-how to assess your battery’s State of Health (SoH) and make informed decisions about its performance.

What’s This Spreadsheet All About Then?

Recently, SolarQuotes blogger/installer Anthony wrote two interesting articles about why and how a battery degrades, and how to measure it using a monitoring app. I recommend reading both of them as a starting point for this article.

Anthony outlines a method to estimate a battery’s health by manually calculating and estimating its round-trip efficiency and SoH using selected data points over 24 hours. You can do the same thing with this spreadsheet by simply adding the data. The spreadsheet will do the rest.

Note that this method provides a rough estimate only, and may not be as accurate as more sophisticated battery management systems or monitoring tools that use other metrics and specified test conditions.

Anthony Bennett battery degradation articles

Recommended reading – Anthony Bennett’s battery degradation articles.

What Is Round-Trip Efficiency And SoH?

These are two of the metrics used to measure the condition and performance of a battery.

Battery Round-Trip Efficiency: Represents the ratio of the energy output from the battery during discharge to the energy input during charging, accounting for losses in the process. A higher round-trip efficiency indicates that a battery can store and release energy more effectively.

Battery State of Health (SoH): Indicates the current overall condition and health of a battery relative to its original capacity. It is expressed as a percentage and considers factors such as capacity degradation, internal resistance, and other wear-related effects.

How To Use The DIY Battery Health Estimator

In a nutshell, to measure the SoH over 24 hours, there on only four parameters we need to know.

  1. The SoC at the beginning and end of each charging cycle.
  2. The SoC at the beginning and end of each discharging cycle.
  3. The daily kWh used to charge the battery.
  4. The daily kWh discharged from the battery.

Sounds simple enough, but the bad news is that not all monitoring apps will give you this information.

However, the Tesla Powerwall’s app will! The following example uses the Tesla monitoring app to estimate the round-trip efficiency and SoH of a Powerwall 2.

Tesla app - main and Powerwall screens

Tesla app main screen (left) – click on ‘Powerwall’ tab to open the Powerwall screen (right). Discharged and Charged kWh are shown numerically on top, by graph (middle), and by battery Charge Level by graph (bottom). Use the touch screen on the lower graph to obtain numerical percentages.


  1. Download the spreadsheet from the link at the bottom of this page and open it up. All the data entry cells are marked with a red border. Enter your battery’s rated capacity into the first cell (C7).
  2. Open the Tesla app on your phone and click on the ‘Powerwall’ tab.
    Make sure the tab on the top-right is set to ‘Day’.
  3. Swipe the ‘Discharge/Charge’ graph to the right, until you find a suitable day to measure. The charge level at the end of the day should match the start (%).
  4. Note the kWh charged and kWh discharged for that day, then go back to the spreadsheet and enter those figures into cells G12 and G26 marked ‘Charged kWh’ and ‘Discharged kWh’.

Battery SoH spreadsheet plus Tesla app

You must toggle between the spreadsheet and the Tesla app as you enter data. Easiest is to view the spreadsheet (left) on desktop, and Tesla app (right) on phone.

Charge Cycle

  1.  Go back to the Tesla app and look at the ‘Charge Level’ graph on the lower part of the screen.
  2. Touch the screen at the left-hand side of the graph and note the ‘Charge Level’ at the start of the 24-hour period.
  3. Go to the spreadsheet and write the number down in cell C16 marked ‘Charge Cycle/s Over 24 Hours/ Cycle No.1/ Battery Level (Start).’
  4. Go back to the Tesla app and place your finger on the touch screen to the right of your previous %. Locate the highest level the battery was then charged to in the same charging cycle and note the number.
  5. Go back to the spreadsheet and enter the number into cell E16 marked ‘Charge Cycle/s Over 24 Hours/ Cycle No.1/ Battery Level (End).’

Discharge Cycle

  1. Also write the same number (step 11) into cell C30 below in the ‘Discharge Cycle/s Over 24 Hours/ Cycle No.1/ Battery Level (Start).’
  2. Go back to the Tesla app and place your finger on the touch screen to the right of your previous %. Find the lowest percentage the battery was charged to in that discharging cycle and note the number.
  3. Go back to the spreadsheet and enter the number into the cell E30 marked ‘Discharge Cycle/s Over 24 Hours/ Cycle No.1/ Battery Level (End).’

Tesla app showing Powerwall charge/discharge cycles over 24 hours

Tesla app with red arrows showing charging and discharging cycle data points through 24 hours. From left to right – 20%, 43%, 20% 100%, 20%.

Additional Charge/Discharge Cycles

If there are more charging and discharging cycles during the 24 hours, continue the above method by moving sequentially right on the Tesla app Charge Level graph, then entering data into the spreadsheet ‘Cycle No.2’ cells for charging and discharging, and so on, until the end of the day. Most days will have two charging and two discharging cycles, however, it’s possible to have less or more. The spreadsheet has allowed for up to four of each.

After entering the data above, the Round-Trip Efficiency Estimate and Battery SoH Estimate will appear in the output cells (G44 and G54) below. Once you have these figures, cross-reference them with other days to ensure your data has been entered correctly. You should get a similar result. The next step might be to retrieve the data from the start of your battery’s life and compare.

Spreadsheet Calculations

For those who like to dig a little deeper and find out how this spreadsheet works, I would suggest first reading Anthony’s article ‘Battery Degradation Part II: How To Measure It‘. The following spreadsheet calculations are based on his methodology.

  • Percentage Charged Total: [G21=SUM(G16:G19)] – the sum of all charging cycles.
  • Percentage Discharged Total: [G35=SUM(G30:G33)] – the sum of all discharging cycles.
  • kWh per % Charge (Test): [G39=G21/G12] – % Charged Total divided by Charged kWh.
  • kWh per % Discharge (Test): [G41=G35/G26] – % Discharged Total divided by Discharged kWh.
  • Round-Trip Efficiency Estimate: [G44=G39/G41] – kWh per % Charge (Test) divided by kWh per % Discharge (Test).
  • Discharge Capacity Pro Rata (rated): [G48=C7*G35] – Battery Capacity (kWh) multiplied by % Discharged Total.
  • Discharge Capacity Pro Rata (test): [G50=G26] – Discharged kWh.
  • Battery SoH (State of Health) Estimate: [G54=G50/G48] – Discharge Capacity Pro Rata (test) divided by Discharge Capacity Pro Rata (rated).

Battery SoH estimator spreadsheet

Desktop view of the DIY Battery Health Estimator Spreadsheet. It can be easily printed on an A4 sheet of paper. This is Finn’s 6-year-old Powerwall performance estimate from yesterday’s energy data.

What To Do If The Readings Appear Lower Than Expected

If, after using this method, you’re concerned that the battery is not performing to the specification outlined in your warranty, what’s the next step? Is the data collected from this method useful when approaching a company for a warranty claim due to suspected early battery degradation?


The data collected from your estimation method may not provide the same level of accuracy as more advanced battery testing methods. However, it can still serve as a starting point for your warranty claim. Here’s what you can consider doing:

Document the Data: Ensure you have a well-documented record of all the data you collected, including SoC percentages, kWh used, and any calculations or formulas used to estimate SoH. This documentation will be crucial when presenting your case for a warranty claim.

Review Warranty Terms: Before contacting the company, thoroughly review the terms and conditions of the battery warranty. Pay close attention to any specifications related to the State of Health, capacity loss, or degradation that would make your case eligible for a warranty claim.

Contact Customer Support: Contact your installer or the battery company’s customer support. Provide them with the collected data and calculations, explaining your concerns about early battery degradation. Be prepared to explain your estimation method and how it suggests the battery is not meeting the specified SoH under the warranty period.

Request Inspection: In many cases, the company may want to conduct its own assessment of the battery’s health before approving a warranty claim. They might ask you to provide access to the battery for inspection and testing.

Be Persistent: If the initial response is unsatisfactory, consider escalating your concern through appropriate channels. This could involve speaking to a higher-level customer support representative or submitting a formal written complaint.

Taking Charge of Your Battery’s Health

The DIY battery health estimator spreadsheet demystifies degradation and empowers you to monitor and address it proactively. Armed with this tool, you can assess your battery’s State of Health (SoH) and confidently engage with manufacturers if performance falls short.

Download the DIY Battery Health Estimator Spreadsheet here, and feel free to post your results in the comments section. I’d also be interested to know of other monitoring apps that give SoC percentages in real-time and daily charge/discharge kWh.


We have collected RSS feeds from some of our favorite websites and given our customers full access! We know that you want to sit back and enjoy the post, article and gossip and you have the choice to either click here Source or continue with the article. Afterwards, feel free to search our site for related information or both! Thank you for your Support!

Spread the word. Share this post!

Leave a comment

Your email address will not be published. Required fields are marked *