leedrake5
Mistakes in the table?
Hello!
It seems that information in the table https://docs.google.com/spreadsheets/d/1bngHbR0YPS7XH1oSA1VxoL4R34z60SJcR3NxguZM9GI/edit#gid=0 became incorrect, namely in columns: K, M (?), N, Q, AI, BD (?), BE.
The contents of these columns has been dramatically changed nearly a week ago. Sign "?" means a slight change that can be a plausible (downgrade) revision.
Thank you!
Thank you, now fixed.
- Lee
On Sat, Aug 20, 2022 at 05:48 stochastic-stories @.***> wrote:
Hello!
It seems that information in the table https://docs.google.com/spreadsheets/d/1bngHbR0YPS7XH1oSA1VxoL4R34z60SJcR3NxguZM9GI/edit#gid=0 became incorrect, namely in columns: K, M (?), N, Q, AI, BD (?), BE.
The contents of these columns has been dramatically changed nearly a week ago. Sign "?" means a slight change that can be a plausible (downgrade) revision.
Thank you!
— Reply to this email directly, view it on GitHub https://github.com/leedrake5/Russia-Ukraine/issues/12, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAJMFZQ7L2EMSZQ2DWYBAVTV2DA2TANCNFSM57DDNV6A . You are receiving this because you are subscribed to this thread.Message ID: @.***>
-- --- B. Lee Drake University of New Mexico +1 505.510.1518 @.***
Great!
But what about AI, AJ? They seem to be a duplicate for AC, AD.
I see that AI, AJ can be correctly derived directly from the table data with a few arithmetic operations, so this is minor issue.
There is another issue: anti-air systems. By your aggregation, Ukraine have lost more "anti-air" equipment than Russia: 115 vs 99. But according to primary sources if we add categories "Anti-Aircraft Guns", "Self-Propelled Anti-Aircraft Guns", "Surface-To-Air Missile Systems", "Radars And Communications Equipment"/"Radars", "Jammers And Deception Systems" we will get 71 for Ukraine and 116 for Russia, and it seems that there is no more categories for Ukraine which can be regarded as "anti-air".
Thank you!
I've addressed the issue for anti-air (any time Oryx adds a new category of equipment it breaks spreadsheet column references, the source of the error here). Keep in mind the google spreadsheet is public - anyone can correct these errors as well.
Not sure who is responsible for the table itself. But columns for Ukraine AFV (Y) and Ukraine APC (AG) contain same data. Which is incorrect.
Thank you @isergieienkov, table references corrected. Sometimes Oryx or Jakob will change names of categories, or add new ones. So every month or so the table needs fresh eyes to make sure references are correct - fixes can be made by anyone.