RUAD Parser

RUAD data can be cumbersome to work with. For my admin officer workflow, I was manually parsing the data every drill weekend and copying/pasting into Excel and Powerpoint to display what was most useful for the CO/SEL and fellow department heads. Rather than expending a thousand mouseclicks and a couple hours every DWE, I wrote a program to parse the information automatically and to rewrite it into an Excel spreadsheet and Powerpoint.

Program requirements:

  • Windows 10/11
  • Microsoft Office; the program makes use of Visual Basic bindings to manipulate the files. Be sure to close out of Microsoft Excel and PowerPoint before using the program.

Program inputs:

  • Smart RUAD downlaoded from NRRM (requires special access). Previously an Excel format was available for download (.xlsx), but it seems that as of July 2022 only .csv format is available. RUAD Parser works with both formats.
  • Note: The smart RUAD file name should be formatted as <TRUIC>_SMART_RUAD.csv, where <TRUIC> is your unit's TRUIC.

Program outputs:

  • Formatted Excel spreadsheet.
  • Formatted PowerPoint slides.

Download

RUADParser is available for download from Sourceforge (295 MB).