The worksheet is a standalone website aid. It does not connect PETICO, call an MCP tool or read saved pet records.
Before entering values
Choose one signal and one unit. Keep the observation dates, local time windows and collection method beside the entries. Use measured amounts with measured amounts, not estimates or descriptions silently converted into quantities.
Include a value in the primary calculation only when its intended window is a complete day and its numeric basis is comparable. Keep partial and unknown entries visible but excluded. Leave missing amounts blank; do not enter zero unless zero was actually recorded.
Enter your two periods
Dates are calendar-day labels, without local time conversion. Each period starts inclusively and ends exclusively. Use a 1–366-day window and at most 64 records per period; keep periods separate.
Your supplied entries — kept only in this page. Use one pet and one measured signal.
Displayed arithmetic is rounded to two decimals where appropriate; very small nonzero values use scientific notation. Calculations use unrounded values. The CSV uses the underlying numbers.
Entries and results stay in this page's memory. They are not sent to a backend, stored by the worksheet or included in marketing events. Clear worksheet removes entries and results. A CSV you choose to download contains your supplied entries and local source references; text cells are protected against spreadsheet formulas. The file remains under your control and does not promise PETICO import compatibility.
Worksheet field guide
For each period, enter dated rows containing the value, completeness and collection context. Choose complete, partial or unknown coverage. Review the included and excluded rows before calculating.
Input labels: Signal; Unit; Collection basis; Period A label; Period B label; Date; Value; Completeness; Source note.
Actions: Add observation; Remove observation; Compare periods; Clear worksheet; Load fictional example.
Result labels: Period A complete-day count; Period A mean; Period B complete-day count; Period B mean; B minus A; Percentage relative to A; Excluded partial entries; Excluded unknown-completeness entries; Missing numeric entries.
Fictional example with a checkable result
The example is fictional:
- Period A: complete-day measured amounts of 100, 110 and 120 mL.
- Period B: complete-day measured amounts of 140 and 150 mL.
- One separate B entry: 80 mL, partial day, excluded from the primary mean.
Expected results: A mean 110 mL; B mean 145 mL; difference 35 mL; percentage 31.82%; included counts 3 and 2.
The partial-day record remains visible. These amounts are not recommendations for any animal. The result is arithmetic, not a PETICO tool response.
How the calculation works
For each period, sum the eligible complete numeric values and divide by their count. Subtract A's mean from B's mean. When A's mean is nonzero, divide that difference by A's mean and multiply by 100.
Keep full precision during calculation and round only the displayed result. Show the counts and exclusions alongside the means.
If A's mean is zero, the percentage is unavailable. If either period lacks eligible observations, its mean and the comparison are unavailable. Never fill those results with zero.
Errors should help you correct the input
Mixed units or signals cannot form one comparison. Missing dates, impossible dates, duplicate complete-day entries for the same series, nonfinite numbers and negative quantities need correction before comparison. A missing numeric value is allowed as a visible gap.
A descriptive appetite entry belongs in a log, not this numerical calculation. See the appetite guide.
Keep a record you can reuse
Use the blank template for the original observations. Read the worked method if you want to check each step.
If your concern is about your pet's condition, use the record to prepare a question for a veterinarian. The worksheet cannot assess that condition.