Fire House Stats (suggestions?)

  • Resolved trigger113

    (@trigger113)


    3 years, 7 months ago

    Hello,

    I’m trying to recreate a table like the “FIRE/EMS Stats” wordpress plugin. The plugin recently stopped working for me, and the developer of that plugin recently passed from COVID (finally connected the dots today why he hasn’t been responding:(. So trying to find another solution for our fire house to calc calls for each month based on EMS/FIRE and total for the month and year.

    What I am doing is trying to use tablepress to help me rebuild something similar to what he had developed… so hoping yall can give me tips on what I could do…or if maybe another solution would be better…

    In tablepress, it seems like I can get close…but have a couple hangups:
    1) I’m currently stuck in trying to understand how to SUM each row without having to change the row number in the formula (by using a variable)…something like this: =SUM(B{ROW}:C{ROW}), but it doesn’t seem to sum.

    2) Also, I am not sure how I would summarize the stats for the YEAR (like total for calls in 2020, calls for total in 2021, 2022, etc.). Anyone have any suggestions of how I could keep this simple for non-tech folks keying in stat data each month, and having it do its magic to display stats on our site by MONTH and YEAR? I’m scratching my head.

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    3 years, 7 months ago

    Hi,

    thanks for your post, and sorry for the trouble.

    I don’t know that FIRE/EMS Stats plugin and don’t have time to take a look at it right now, so I’ll try to help with the questions that are related to TablePress as much as possible.

    1) This is not possible right now with TablePress 1.14 (it’s formula calculation engine does not allow for cell references to be constructed/calculated dynamically) — but: This should be doable with the new formula engine in the upcoming TablePress 2.0 (which will be even closer to formulas like those in Excel). And the good news: There’s already a beta version that you could try for this: https://tablepress.org/8-million-downloads-tablepress-2-0/
    (The actual formula will be a bit different, maybe by using the ADDRESS() formula:

    =SUM( ADDRESS( 2, ROW() ) : ADDRESS( 3, ROW() ) )

    2) This sounds like you’ll just have to find the right formula, based on conditions (i.e. comparing cells to a year value with IF, and only then summing it)?

    Regards,
    Tobias

Viewing 1 replies (of 1 total)

The topic ‘Fire House Stats (suggestions?)’ is closed to new replies.