On 3/14/26 4:39 PM, Mischief via agora-business wrote:
I'll highlight the three rows that don't match. Officially reported is quoted and zero-padded, my result is neither
I have resummed all of the transactions and you seem to be correct (though I haven't checked my results with yours line-by-line). I believe this is all due to an error in my "undo" function which seems to have summed instead of subtracted the results of a transaction (essentially applying it again rather than undoing it).
Unofficially, I believe everyone's values should look like this instead.
defaultdict(<function <lambda> at 0x7fe80d095170>,
{'Cosmo': [0, 0, 3, 0, 1, 0, 1, 0, 3, 4],
'Janet': [300, 88, 186, 5, 3, 2, 96, 3, 97, 10],
'Kate': [0, 0, 0, 0, 0, 0, 0, 0, 0, 0],
'Mischief': [107, 100, 10, 108, 101, 0, 0, 1, 3, 14],
'Murphy': [105, 200, 6, 7, 1, 1, 3, 2, 4, 115],
'Nilrem': [2, 0, 4, 1, 1, 0, 0, 0, 0, 8],
'Trigon': [2, 1, 3, 1, 1, 0, 1, 0, 0, 7],
'ais523': [7, 1, 5, 7, 0, 1, 3, 2, 2, 16],
'juan': [97, 80, 2, 85, 73, 0, 0, 0, 1, 2],
'literal': [99, 0, 92, 0, 0, 95, 0, 0, 0, 94]})
Also: if you are interested in seeing the data from my end, I am attaching the compressed postgres dump of my database to this email for your perusal.
I will likely be restarting from scratch with my automation once a fix proposal has been adopted. This database has turned out to be entirely insufficient for my needs in a way that can't be fixed by patching the schema.
-- Trigon Popular Polygon and Treasuror Extraordinaire
numerator0314.sql.zst
Description: application/zstd
