Ask Your Question
0

Summing up Power Plant Data [closed]

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-09 11:39:00.402725

2 Answers

Sort by » oldest newest most voted
0

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

robleyd gravatar image

Have you considered a pivot table?

https://wiki.documentfoundation.org/D...

edit flag offensive delete link more
0

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

Comments

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

robleyd gravatar imagerobleyd ( 2017-07-05 01:14:11 +0200 )edit

Question Tools

1 follower

Stats

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

Seen: 84 times

Last updated: Jul 04 '17