Log Sheet
After defining your metrics in the Metrics Inventory sheet, you will log the measurements in the log sheet. The log sheet has the following columns:
Metric ID
The unique identifier of the metric. This must match to the Metric ID defined in the Metric Inventory.
M-01
Value
The value of the measurement being reported. Do not format this column. Use decimal format for percentages.
0.8
Measurement Date
The date of the measurement.
08/31/2025
Notes
Any notes associated with the measurement.
We’ve seen a slight dip in coverage this month, primarily due to delays in onboarding new contractor workstations. A remediation plan is in place.
Recording Measurements
Once a metric has been added to the Metric Inventory Sheet, you will need to record measurements in the Log Sheet. A measurement is a single value for a metric tied to a measurement date. Metrics may have different measurement cadences: some may be measured quarterly, others weekly or even daily.
All measurements must be added to the log. To add a measurement, add the Metric ID the measurement is for, the measured value, the date of the measurement, and optionally add notes for added context.
Some things to keep in mind:
The Metric ID must match the ID from the Metric Inventory Sheet.
The value must be unformatted. Percentages should be in decimal format.
Last updated