0
\$\begingroup\$

I have the data of power generated by a solar panel per minute in kW. I need to calculate the total number of kWh generated per day. How do I do this?

So far, I divided each value of kW by 60 and then added all the 1440 values(minutes per day) thus obtained. I don't think this is the right approach though. Can anyone please help?

\$\endgroup\$
  • \$\begingroup\$ Are you looking for coding solution or a spreadsheet solution? Do you want statistics like Min, Max , Mean % time per day Don't you want a histogram of solar kW/h per day or hourly charts. These can be useful too. in addition to Cum. daily total. Our energy provide does this online for us in any date range and by hour , day of week or charts for hourly daily, weekly, monthly hourly, historical trends etc and for you % capacity is important. \$\endgroup\$ – Sunnyskyguy EE75 Feb 25 at 6:49
  • \$\begingroup\$ I was looking to show this data in a spreadsheet. I have the data of power generated per day per minute. I have to calculate the total number of units generated per day. \$\endgroup\$ – Niteesh Shanbog Feb 25 at 6:49
  • \$\begingroup\$ the approach you took sounds correct. the result is the number of kWh you generated that day. \$\endgroup\$ – Jasen Feb 25 at 6:56
  • 1
    \$\begingroup\$ Assuming constant power conversion, the quantity of electrical energy produced in one day is: kW multiplied by 24 hours. So 10 kW over a 24-hour period would be 240 kW-hour. Note that kW per hour is meaningless in this context. \$\endgroup\$ – Chu Feb 25 at 7:58
  • 1
    \$\begingroup\$ Voltage per minute would be the rate of change of voltage. You mean one voltage sample per minute. You need to do some reading on units; it's important. \$\endgroup\$ – Chu Feb 25 at 17:32
0
\$\begingroup\$

Convert 60x24 data kW/minute to Energy readings in kWh/day

Correction = SUM {Range of kW readings/min} / 60min/hr = kWh for any array period you choose day week, month

( Range = 1440 results of kW/minute every minute for 24 hrs )

If you use =SUM( ) or use SUBTOTAL() for each hour,
- then you can plot hourly data then plot sum daily day and other interesting trends.

You can create a dummy column of numbers or convert time to the Hour

  • then use =Subtotal{,} on the range for each hour and grand total per day

    • this uses a type number index so you can choose sum, max, min, average
  • then use the group icons (-)to hide the day and plot the subtotal's per hour and or per day using grand-total of [kWh]

Then you can get daily plots averaged by the hour to examine your loss from the solar angle or cumulative plots per day

Here's is my consumption data online.

enter image description here

\$\endgroup\$
  • \$\begingroup\$ So I add all the 1440 values of kW and divide by 24? \$\endgroup\$ – Niteesh Shanbog Feb 25 at 8:13
  • \$\begingroup\$ oops sorry ... time to go to bed \$\endgroup\$ – Sunnyskyguy EE75 Feb 25 at 8:27
  • \$\begingroup\$ no, divide by 60 (which it the ration between a minute and an hour). dividing before of after adding will get the same result, but dividing after adding is less work. \$\endgroup\$ – Jasen Feb 26 at 8:52
  • \$\begingroup\$ =SUM {Range of kW readings/min} / 60 is 1 step \$\endgroup\$ – Sunnyskyguy EE75 Feb 26 at 8:54
1
\$\begingroup\$

The approach you took sounds correct.

The result is the number of kWh you generated that day

\$\endgroup\$
0
\$\begingroup\$

The idea of converting kilowatt-hours to kilowatt-days with a cumulative sum is no different than converting kilowatt-minutes to a cumulative sum of kilowatt-hours. Start by thinking you have 1 kilowatt load, and what it is in hour, minute or day of time.

\$\endgroup\$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.