Pre-formatted AuxInfo Reports for Divisions

Access password protected Rudy's Reports via the sign-in webpage. Members must use their ID and password established for the e-Director to gain access to the reports. (Note - the sign-in link will not work using a Foxfire browser since a php file extension is used.)

The following tools are provided to help flotillas develop data, record information and determine at a glance the flotilla progress towards achieving the award. Complete details about the award is available on the District Awards website.

Division Captains are to certify all qualifying flotillas to the District Award Chairperson by February 1 following the year in which the award is earned. The certification form is available in MS Word (57 KB) and Adobe Acrobat (97 KB).

**Award Worksheet**

The above image displays a sample COMO Flotilla Honor Streamer Award worksheet designed to simplify recording and determining flotilla progress towards meeting the award requirements. The worksheet is in MS Excel (21KB) and may be downloaded for your use.

The Member Training, Operations and Vessel Safety Checks variable data may be obtained from the respective pre-formatted AuxInfo reports. The division link will reveal a report that contains all flotillas for the respective division. Select the information from the report that applies to the user's flotilla.

**Award Variables - Pre-formatted AuxInfo Reports - 2010 data**
Note: Due to the size of the MT & OPS reports it was necessary to develop separate pre-formatted reports for each category. To arrive at the combined MT variable value for the Award, the total value on each MT report must be added together. Likewise, the OPS reports must each be added together to arrive at the OPS value for the Award. Additionally, the OPS Patrol & Training report shows both lead and non-lead time. The cumulative lead and non-lead total on each report should be used.
MT (06a, 06b, 06c)	MT CG OP Sup (22b)	OPS Patrol & Training (01a, 02, 03, 22a, 55a)	OPS Radio, QE (07c, 20b, 26)	OPS SAR (24)	OPS Fed, State & Local Agcy (41, 42, 43)	MEP 70b, 70d, 70e, 70f, 70m, 70n)	MEP (28g)	VSC & Facility Inspections
Division 1	Division 1	Division 1	Division 1	Division 1	Division 1	Division 1	Division 1	Division 1
Division 2	Division 2	Division 2	Division 2	Division 2	Division 2	Division 2	Division 2	Division 2
Division 3	Division 3	Division 3	Division 3	Division 3	Division 3	Division 3	Division 3	Division 3
Division 5	Division 5	Division 5	Division 5	Division 5	Division 5	Division 5	Division 5	Division 5
Division 8	Division 8	Division 8	Division 8	Division 8	Division 8	Division 8	Division 8	Division 8
Division 9	Division 9	Division 9	Division 9	Division 9	Division 9	Division 9	Division 9	Division 9
Division 11	Division 11	Division 11	Division 11	Division 11	Division 11	Division 11	Division 11	Division 11
Division 15	Division 15	Division 15	Division 15	Division 15	Division 15	Division 15	Division 15	Division 15
Division 16	Division 16	Division 16	Division 16	Division 16	Division 16	Division 16	Division 16	Division 16
Division 30	Division 30	Division 30	Division 30	Division 30	Division 30	Division 30	Division 30	Division 30
Division 31	Division 31	Division 31	Division 31	Division 31	Division 31	Division31	Division 31	Division 31
Division 33	Division 33	Division 33	Division 33	Division 33	Division 33	Division 33	Division 33	Division 33

Preformatted reports in AuxInfo and an MS Excel worksheet (worksheet not currently available as award criteria currently being revised) have been developed to assist members who are interested in following their progress towards earning the Recreational Boating Safety device. The preformatted reports reflect all members in the respective division who have earned points in a given category for a particular year. The points by category for a member can then be inserted into the MS Excel worksheet which will total the points earned in all categories.

The device is earned based on points earned over a two year period. The preformatted reports give a year-to-date accumulation of points by category for the current year. The user must change the calendar year on the preformatted report to view the points earned in the prior year. As members reach the points required in the given period of time, AuxData will automatically generate for DirAux the names of members who have qualified for the device. Learn more about the device. Also, browse the U.S. Coat Guard Auxiliary Department of Boating website.

2009 data

Public Education
Lead & Aide

Public Affairs
10b, 10c, 10f

Facilities
Count

VSC's
Count

RBS
Visits

Legislative
Outreach
65a, 65b, 65c

Division 1

Division 2

Division 3

Division 5

Division 8