leedrake5 / Russia-Ukraine

Equipment Loss Tracking
MIT License
617 stars 26 forks source link

Mistakes in the table? #12

Open stochastic-stories opened 1 year ago

stochastic-stories commented 1 year ago

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!

leedrake5 commented 1 year ago

Thank you, now fixed.

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 @.***

stochastic-stories commented 1 year ago

Great!

But what about AI, AJ? They seem to be a duplicate for AC, AD.

stochastic-stories commented 1 year ago

I see that AI, AJ can be correctly derived directly from the table data with a few arithmetic operations, so this is minor issue.

stochastic-stories commented 1 year ago

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!

leedrake5 commented 1 year ago

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.

stochastic-stories commented 1 year ago

Great! Thank you!

isergieienkov commented 1 year ago

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.

leedrake5 commented 1 year ago

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.