My Fire Rules Version Available:

My Fire Rules Alert

Zoll Alert

EFR Alert

My ePCR Metrics Alert

Attention ZOLL ePCR Users

  • Do you need a bridge to your DATA that compliments Insight Analytics without the drudgery of Crystal Reports?
  • Are you dreading moving to NEMSIS-3 and ePCR Version-6 because of the thought of all of those Crystal Reports that you need to Build or Edit to get at all of that NEW Data?
  • There IS an alternative to Crystal Reports that can save you from all that work and cost of writing or editing Crystal Reports.
  • For more information please email us at!

Insight Analytics Crystal Reports My ePCR Metrics

  • The above is a graphical representation of the Data Query tools available for you to explore your ePCR Data:
    • Insight Analytics is an “Express Elevator” giving you unparalleled high level insight to your ePCR Data (thanks to Dr. Mears and the ZOLL Team). However it does have some limitations such as not being able to “ drill-into all underlying data”.
    • Crystal Reports is a cumbersome tool (a never-ending climb) that takes time and effort to create, edit and manage, let alone the time and effort it takes to wade through Paper or PDF copies. Additionally, it too does not allow you to “drill-into” that underlying data, and if you want a different “viewpoint” of that data, it requires yet another Crystal Report be written.
    • My ePCR Metrics fills the gap in analyzing your ePCR Data by exposing ALL the underlying data. It is based on our “Auto-Updating Data Warehouse” (nothing is written to the ePCR Database) and uses a set of customizable “Preconfigured Excel Pivot Tables”. Don't let the label “Pivot Table” scare you – they are very easy to use, and Free “One-on-One Training” is available.
  • Combining My ePCR Metrics with Insight Analytics gives you Full, Complete and Easy access to ALL of your ZOLL ePCR Data!

  • The right tool for the right job
    • 7 different “views of the ePCR Data”
      • Trips ONLY
      • Trips & Interventions
      • Trip Interventions (Flattened with Qualifiers)
        • New addition
      • Trips & Vitals
      • Trips & Assessments
      • Trip Overview - includes Vitals, Interventions & Assessment in one view
      • Patients & Trips
        • Separate Workbook – protected by Password
    • Each of these Pivot Tables let you explore the full ePCR Data from a different point of view
  • Quickly Filter your data to what you are looking for.
    • Choose any item and filter to only what you want to interrogate your data concerning
  • Quickly Sort your data

    by simply dragging a field left or right

    • Such as Item per Time Period or Time Period per Item
  • Drill-Into the underlying data for Full Examination Once you have the Summary, you can “double-click” on a number and open a view of ALL of the underlying data There is a limitation to the number of Fields you can drill into (255), however there is a “Data Grouping Tool” which allows an administrator to set the Fields to those fields that are most appropriate and actually contain relevant data
  • When you get a Pivot Table the way you want it, you can “Copy and Save-As” so that the work in Filtering & Sorting need not be lost, allowing you to create your own Workbook or set of Workbooks that you can re-use (because the Link to the Data Warehouse is preserved).

  • A Data Warehouse is basically a Copy of your ePCR data which includes “Metrics” – pre-calculated additional fields that make the data more useful.
    • True Date-Time Fields (ePCR stores dates in one field and times in another field making time calculations difficult)
    • Pre-Calculated “Time Segments” (no need to add formulas to the data)
    • All Codes are translated to their “English counterpart”
    • Updated automatically every night
    • NO CHANGES MADE to the ePCR Database

  • To rearrange the worksheet, simply drag and drop column headings to a new location on the worksheet, and Microsoft Excel crunches the data accordingly. The diagram below depicts the “All Incidents” PivotTable and highlights its moveable elements as well as the “Refresh Data” buttons. (note: Do NOT “Refresh ALL” as this will load data from the SQL Server into ALL Pivot Tables; choose “Refresh” only on individual Pivot Tables.)