Addendum - Local Reports Formulas

# Dosing Sheet Report

The following data are displayed on the Dosing Sheet report: cage
number, animal number, dose (in milliliters and micro liters), weight,
weight date/time, treatment group number, treatment group text, sex, and
area. From these fields the dose field is the only one calculated. The
dose for an individual animal is determined as follows:

1.  The most recent animal weight is retrieved from the database. This
    is data that has been collected by a facility. The animal weight
    data is stored in decigrams, and is converted by LDASII to grams for
    the calculation.

> (1 decigram = .1 gram)

2.  The dose volume is retrieved from the database. This is data that
    has been determined by a value included in the in life protocol
    download.

3.  The dose for an individual animal in milliliters is calculated as
    follows:

> Dose = ((dose volume / 1000) \* animal weight)

4.  The dose for an individual animal in micro liters is calculated as
    follows:

> Dose (in micro liters) = Dose (in milliliters) \* 1000

An example calculation:

> Animal weight = 37.5 grams
>
> Dose volume = 10
>
> Dose (in milliliters) = (10 / 1000) \* 37.5 = 0.375
>
> Dose (in micro liters) = 0.375 \* 1000 = 375

The dosing sheet report would display this information as ". 4 mL or 375
uL" for rats and ". 38 mL or 375 uL" for other species.

# Food Consumption Report

The following data are displayed on the Food Consumption report: cage
number, treatment group number, treatment group text, dose date, sex,
treatment, area, full container data (day, date/time, operator, number
of animals, container weight), used container data (day, date/time,
operator, number of animals, container weight), amount consumed, animal
hours, consumption. From these fields the following fields must be
calculated: amount consumed, animal hours (for cage), and consumption.
The calculations for these fields follow:

[Amount Consumed\
]{.underline}

1.  Amount Consumed = full container weight -- used container weight

2.  All container weights are displayed in grams on the report.

[Animal Hours (for cage)\
]{.underline}

1.  Animal Hours (for cage) = Sum of animal hours (for animal) for every
    individual animal in a cage

2.  This calculation must take into account the possibility that one or
    more animals may have been removed between container weights.

3.  This calculation is rounded to the nearest hour after the time for
    all animals in a cage has been added together. 29 minutes and under
    is rounded down. 30 minutes and over is rounded up. For example,
    take three animals in a cage for 40 hours and 13 minutes. The total
    time in the cage is 120 hours and 39 minutes, which rounds up to 121
    hours. If the calculation were made by rounding the individual
    animal's time before adding the times together, an incorrect number
    of hours would be generated.

[Animal Hours (for animal)\
]{.underline}

1.  Animal Hours (for animal that has not been removed) = Time span from
    full container date/time until used container date/time

2.  Animal Hours (for animal that has been removed) = Time span from
    full container date/time until animal removal date/time

3.  This time span value is stored in a ColeDateTimeSpan object that
    contains the hours and minutes that will be used in the total for
    Animal Hours (for cage).

[Consumption\
]{.underline}

1.  Consumption (grams per animal per day) = (((Amount Consumed / Animal
    Minutes (for cage)) \* 60) \* 24)

2.  The consumption is rounded to one decimal place for display on the
    report.

Animal Minutes (for cage)

1.  Animal Minutes (for cage) = Sum of animal minutes (for animal) for
    every individual animal in a cage

2.  This calculation must take into account the possibility that one or
    more animals may have been removed between container weights.

[Animal Minutes (for animal)\
]{.underline}

1.  Animal Minutes (for an animal that has not been removed) = Time span
    from full container date/time until used container date/time

2.  Animal Minutes (for an animal that has been removed) = Time span
    from full container date/time until animal removal date/time

3.  This time span value is stored in a ColeDateTimeSpan object that
    contains the hours and minutes that will be used in the total for
    Animal Minutes (for cage).

# Water Consumption Report

The Water Consumption Report displays the same data and makes the same
calculations as the Food Consumption Report. The only difference between
the two reports is the type of container information.

# Mean Body Weight (Current) Report

The following data are displayed on the Mean Body (Weight Current)
report: treatment group text, group number, sex, weight date (most
recent), number of animals (includes only non-removed animals at the
time the report is run) and mean body weight (of animals in treatment
group that have not been removed). The only field to be calculated for
this report display is mean body weight. Mean body weight is calculated
as follows:

1.  Mean Body Weight = Sum of animal weights / Count of animals

2.  This sum and count only relate to animals that have not been removed
    at the time the report was run. For example if you take body weights
    on 10 animals on Tuesday and run the report after taking body
    weights, the report will display the mean for the 10 animal weights.
    If, on Wednesday, you remove one of these 10 animals and run the
    report afterwards, the report will show the mean for the 9 animals
    whose weights were taken on Tuesday that are still in the cage on
    Wednesday.

# Mean Body Weight (Change) Report

The following data are displayed on the Mean Body Weight (change)
report: treatment group number, treatment group text, sex, previous
number of animals, current number of animals, previous mean body weight,
current mean body weight, mean percent change, previous standard
deviation, current standard deviation and standard deviation percent
change. The following fields are calculated: previous mean body weight,
current mean body weight, mean percent change, previous standard
deviation, current standard deviation and standard deviation percent
change. The term current refers to the last data collection session. The
term previous refers to the data collection session prior to the last
data collection session. The calculations are made as follows:

[Previous mean body weight\
]{.underline}

Previous Mean Body Weight = Sum of previous animal weights / Count of
previous animals

[Current mean body weight\
]{.underline}

Current Mean Body Weight = Sum of current animal weights / Count of
current animals

Mean percent change

> Percent change = ((Current Mean Body Weight - Previous Mean Body
> Weight) / Previous Mean Body Weight) \* 100

[Previous standard deviation\
]{.underline}

> Standard deviation is calculated by the Oracle database function,
> stddev. It returns the standard deviation of the animal weights taken
> during the previous data collection session.

[Current standard deviation\
]{.underline}

> Standard deviation is calculated by the Oracle database function,
> stddev. It returns the standard deviation of the animal weights taken
> during the current data collection session.

[Standard deviation percent change\
]{.underline}

Standard deviation percent change = ((Current standard deviation --
Previous standard deviation) / Previous standard deviation) \* 100

### [Stddev ]{.underline}

> The standard deviation function, stddev, is documented on
> [http://technet.oracle.com](http://technet.oracle.com/). A brief
> summary of information found on the oracle site follows.

-   "Oracle calculates the standard deviation as the square root of the
    variance defined for the VARIANCE aggregate function."

-   "VARIANCE returns variance of expr. You can use it as an aggregate
    or analytic function."

-   "Oracle calculates the variance of expr as follows:

    -   0 if the number of rows in expr = 1

    -   VAR_SAMP if the number of rows in expr \> 1"

-   "VAR_SAMP returns the sample variance of a set of numbers after
    discarding the nulls in this set. You can use it as both an
    aggregate and analytic function."

-   "The expr is a number expression, and the function returns a value
    of type NUMBER. If the function is applied to an empty set, it
    returns null. The function makes the following calculation:

> (SUM (expr^2^) - SUM (expr) ^2^ / COUNT (expr)) / (COUNT (expr) - 1)"

# Percent Weight Change Report 

The following data are displayed on the Percent Weight Change report:
treatment group number, treatment group text, sex, cage number, animal
number, previous weight date, previous weight operator, previous weight,
current weight date, current weight operator, current weight, percent
change, weight status, clinical observations (sign, site, size and
count). The only field to be calculated is the percent change field. The
percent change field is calculated as follows:

1.  Percent change = ((current weight -- previous weight) / previous
    weight) \* 100

2.  Note that if the previous weight is zero or null the percent weight
    change displayed on the report is an empty string.

3.  The percent weight change is rounded to one decimal place.

> End of Document