Ask Your Question

Summing up Power Plant Data

asked 2017-07-04 13:32:47 +0200

petterson gravatar image

I would like to get the power plant capacities from the 2015 Form EIA-860 Data on Generators (download the ZIP). The data there is give for individual generators (blocks), but no totals for power plants.

ID Plant Block Nameplate Capacity

8102 General James M Gavin 1 1,300.0

8102 General James M Gavin 2 1,300.0

So I would like to add up the Nameplate Capacities for all rows with the same ID:

8102 General James M Gavin 2,600.0

How can I achieve this with Calc? Thanks in advance..

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-07-04 13:37:59 +0200

robleyd gravatar image

Have you considered a pivot table?

edit flag offensive delete link more

answered 2017-07-04 14:59:23 +0200

petterson gravatar image

Yes, now I have a pivot table. But how can I sort such without destroying it?

edit flag offensive delete link more


Can you explain more? How is it being "destroyed" when you sort?

robleyd gravatar imagerobleyd ( 2017-07-05 01:14:11 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-07-04 13:32:47 +0200

Seen: 73 times

Last updated: Jul 04 '17