# Summing up values in an automatic generated table based on a meta tag

I am generating a table automated with a macro based on my other question (Time calculation with spreadtab). There will be three (maybe four, maybe n - don’t know if the answer to this question can easily be implemented generic) meta-types of entries (for the example let’s say they are A, B, C):

So my table would look like this:

So I want to generate a pie chart based on the duration times, e.g. for the example above:

A: 00:30

B: 00:30

C: 00:10

Therefore I need to add the durations based on a meta-tag given to a specific row. Not part of the question, but to get an overall look at my problem: My final goal is to pass these values to something like described here: (Package for pie charts, e.g. this answer).

So how do I do this meta-tag based adding (and dividing through the sum), and storing the values? MWE:



Replay

Category: macros Time: 2016-07-31 Views: 3