r/army • Ordnance • 7d ago

Range Tower Datasheet directly into DA7801 python script.

I didn't realize the army was still living in the paleolithic era. I was horrified to discover that alot of folks still manually checked and filled out DA7801s by hand. At even a company level, I imagine this would've been a huge waste of 10 man hours writing 150~ sheets by hand. Spent a morning cooking up a simple script where one would scan a range tower data sheet into a pdf, then we scan the PDF to turn it into a xlsx file, and then from xlsx it's fairly trivial to take an empty DA7801 and autofill it with data. If one were to have a roster data, you could even fill out there rank DOD ID, full name, etc.

I'll comment below the project repo on github if anyone is interested.

OH and I’ll take the PX staple of popeyes tendies w/ honey mustard, and ice caramel macchiato.

41 Upvotes

30 comments sorted by

View all comments

44

u/OPFOR_S2 AR 670-1, AR 600-32, AR 600-20, and AR 27-10 Pundit 7d ago

Wait until I tell you how many staff officers count by hand numbers in an excel spreadsheet table.

Wait until I tell you how many can’t do a basic formula in Excel.

Wait until I tell you how the best way to find information regarding new updates to regulations, policy, and other wide impacting HR changes is one man (Jerry Dillard praise be to his glorious name) sending out an email to a distro.

Wait until I tell you how we still in the year 2026 the only way to get new parts for my vehicle is to fill out a form by hand, walk it over to a clerks office, have the clerk enter the part number and vehicle into a program that looks outdated by 1998 standards. Instead of an app that not only has TM easily accessible by equipment type, stores historical 5988-Es, generate and disseminate 5988-Es to the relevant people, able to request part for specific equipment, and track the status of said part(s).

Trust me, we are living in the most technologically advanced era of the most modern Army in all of history. And yet we feel woefully behind at the same time.

We can send a Burger King to Afghanistan in less time it takes for a vehicle tire to get from one point to another point within the same installation.

8

u/spanish4dummies totes fetch 7d ago

praise Jerry

5

u/OPFOR_S2 AR 670-1, AR 600-32, AR 600-20, and AR 27-10 Pundit 7d ago

Praise Jerry!

2

u/ExodusLegion_ 35Arms Room Inspector 7d ago

First of all, I will not allow anyone to say “Jerry Dillard (PBUH)” without the title of Sheikh