Recordkeeping Calculations (BioSecurity and Custom)

These calculations were added during the development of AIM-2575 in Version 1.47.07.2 on 9/11/2019

Calculations

Stats_Biosecurity_RodentCount_PD

Stats_Biosecurity_RodentCount_PrPD

Stats_Biosecurity_RodentCount_LTD

Stats_Biosecurity_RodentCount_4wk

These calculations will report the total amount for the respective period.

Stats_Biosecurity_TrapCount_PD

Stats_Biosecurity_TrapCount_PrPD

Stats_Biosecurity_TrapCount_LTD

Stats_Biosecurity_TrapCount_4wk

These calculations will report the total amount for the respective period.

Stats_Biosecurity_TrapCount_Avg_PD

Stats_Biosecurity_TrapCount_Avg_PrPD

Stats_Biosecurity_TrapCount_Avg_LTD

Stats_Biosecurity_TrapCount_Avg_4wk

These calculations will report the average amount for the respective period. The average calculation will not consider days with "0" as the entry.

For example:

  • We have 7 days of traps entered at 12 per day. The period result = 12 ( (12*7)/7 )

  • We have 7 days of values for a 7-day period: 12,0,0,0,0,0,0. The period result = 12 ( 12/1 )



Stats_AmmoniaPPM_Avg_PD

Stats_AmmoniaPPM_Avg_PrPD

Stats_AmmoniaPPM_Avg_LTD

Stats_AmmoniaPPM_Avg_4wk

These calculations will report the average amount for the respective period. The average calculation will not consider days with "0" as the entry.

For example:

  • We have 7 days of values for a 7-day period: 15,0,0,20,21,18,0. The period result = 18.5 ( (15+20+21+18)/4 )

  • We have 7 days of values for a 7-day period: 100,0,0,0,0,0,0. The period result = 100 ( 100/1 )

Stats_Biosecurity_FlyCount_Avg_PD

Stats_Biosecurity_FlyCount_Avg_PrPD

Stats_Biosecurity_FlyCount_Avg_LTD

Stats_Biosecurity_FlyCount_Avg_4wk

These calculations will report the average amount for the respective period. The average calculation will not consider days with "0" as the entry.

For example:

  • We have 7 days of values for a 7-day period: 15,0,0,20,21,18,0. The period result = 18.5 ( (15+20+21+18)/4 )

  • We have 7 days of values for a 7-day period: 100,0,0,0,0,0,0. The period result = 100 ( 100/1 )



Stats_CustomValue01_PD

Stats_CustomValue01_PrPD

Stats_CustomValue01_LTD

Stats_CustomValue01_4wk



Stats_CustomValue02_*

Stats_CustomValue03_*

Stats_CustomValue04_*

These calculations will report on the four custom fields added to the recordkeeping form. These calculations will total the values for their respective period.