Capabilities

  • Resolved burlingtonpress

    (@burlingtonpress)


    6 years, 8 months ago

    I’m hoping your plugin can help me. My client has provided me with a spreadsheet of hundreds of photography competition scores, and here’s what I need to do with it:

    1. Column C designates 1 of 12 groupings which will need to be separated into it’s own table. For instance, I’ll need to pull everyone in the “Digital Advanced” grouping and output that into a new table. So, in the end, this 1 table will show as 12 different tables.

    2. Column F shows the score. However, a photographer may have multiple entries so I need to output just their total score from that particular grouping. For instance, if John Smith has 4 entries in “Digital Advanced”, it will tally up all 4 and output that total.

    Is all of this possible?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    I don’t see a way to directly achieve this inside TablePress. Your best chance probably is to do all of this “pre-processing” offline, e.g. in Excel and then just import the final tables into TablePress for display.

    Regards,
    Tobias

    Thread Starter burlingtonpress

    (@burlingtonpress)

    That’s what I thought. Thanks for the quick response!

    Thread Starter burlingtonpress

    (@burlingtonpress)

    If I was able to get my client to separate the CSV into the 12 different tables first, is there a way to set it up to combine any entries with the same name to show a total score instead of individual scores?

    For example:

    If the table data is…
    John Smith 9
    John Smith 8
    John Smith 8
    John Smith 10

    Could I output…
    John Smith 35
    ?

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    you could try working with formulas here. As those can work on hidden rows as well, you could hide the individual rows and use a formula in the one that then shows the total. See https://tablepress.org/tablepress-features-formulas/ for more information.

    Regards,
    Tobias

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Capabilities’ is closed to new replies.