Laserfiche WebLink
The numbers just don't add up <br />We downloaded annual, quarterly, and monthly statistics (PDF files) for the 2020-2022 period <br />from the shelter's website. We converted these to Excel spreadsheets (through an Adobe <br />subscription service). These spreadsheets were grouped by year, and the files are named <br />"2020 Calculated.xlsx" and so on for 2021, 2022, 2023. <br />To do the data check, we added two rows to the spreadsheets of the shelter's statistics. The <br />added rows are yellow and tagged by a red square (empty cell) on the left. One row does the <br />calculation initial+intakes-outcomes to arrive at the expected final number of animals at <br />the shelter. The other row computes the discrepancy between the reported final number <br />and the expected one. A negative number means a deficit, i.e., the shelter is reporting fewer <br />animals at the end of the period than it should have based on the other numbers. A positive <br />number is a surplus, i.e., the shelter seems to have more animals than it should at the end of <br />the period. This second row, labeled "DIFF (ENDING - EXPECTED)" should have <br />contained all zeros. <br />For each year, we did this calculation not only for the full -year report but also for the monthly, <br />quarterly, or other part -year reports available on the shelter's website. We reiterate that the <br />numbers outside the two added rows are the ones in the shelter's public statistics, since we <br />started by converting the shelter's PDFs into spreadsheets. <br />Dog Miscount <br />30 <br />20 <br />10 <br />0 <br />.1 <br />ci <br />[V <br />CA <br />d <br />0 <br />C7 <br />o <br />r l l <br />rV <br />N <br />N <br />-10 <br />-20 <br />-30 <br />-40 <br />-50 <br />Dogs appearing <br />F-1^ n <br />q <br />c1 <br />cf <br />C <br />rI <br />N <br />N <br />N <br />N <br />N <br />N <br />N <br />N <br />N <br />N <br />Dogs disappearing <br />Animal Counts - Page 2 of 6 <br />