Welcome, Guest. Please login or register.
Did you miss your activation email?
April 22, 2019, 02:27:49 AM
Home Help Login Register
News:

CAP Talk  |  General Discussion  |  Membership  |  Topic: PD course eligibility report
0 Members and 1 Guest are viewing this topic.
Pages: [1] Send this topic Print
Author Topic: PD course eligibility report  (Read 888 times)
cobra6987
Recruit

Posts: 24

« on: January 22, 2019, 07:18:23 AM »

I know we can pull a Training Status report that shows who has or has not completed something. But is there an easy way to use that to show who is eligible to take a course?

Basically, I'm planning a CLC course coming up and I want a list of people that have not attended CLC yet. Easy enough. However, when you run the Training Status report for those that have not completed CLC, it will pull everyone that hasn't taken it, including those that are on day one of CAP. Is there an easy way that I can filter to say "Has not completed CLC, but has completed SLS"?
Report to moderator   Logged
SSgt, USAF (Separated)
Major, CAP
Shiprock 10
Ham - N5TCL
MSG Mac
Salty & Seasoned Contributor

Posts: 1,976
Unit: MER-MD-071

« Reply #1 on: January 22, 2019, 08:27:44 AM »

run a report that lists everyone who has completed SLS, and another that shows who hasnít completed CLC
Remove the ones who havenít completed SLS.
Report to moderator   Logged
Michael P. McEleney
Lt Col CAP
MSG USA (Retired)
Spam
Salty & Seasoned Contributor

Posts: 1,198
Unit: GA-001

« Reply #2 on: January 22, 2019, 09:17:39 AM »


Should be able to just run one report.

Will it let you run the dl as an Excel file and apply the filter?

Vr
Spam

Report to moderator   Logged
cobra6987
Recruit

Posts: 24

« Reply #3 on: January 22, 2019, 09:27:07 AM »

I wouldn't mind do that if it was just for a unit, but I'm looking at about 500 people throughout the wing.I can narrow down to 236, but if I'm going line by line, that's still pretty tedious. I know I have 236 that do not have CLC, and 174 that do not have SLS, so that leaves 62 people to find. there's got to be away to filter this a lot easier than line by line examination.

The excel down load separates by unit and whatever course, looks just like the PDF. the contact report prints it in a way that is easy to set as a table, but it will still require a line by line review to see who to remove.
Report to moderator   Logged
SSgt, USAF (Separated)
Major, CAP
Shiprock 10
Ham - N5TCL
dwb
Salty & Seasoned Contributor

Posts: 1,347

« Reply #4 on: January 22, 2019, 01:17:15 PM »

No way to do it in the current system. I just did this manually last week looking for people eligible to attend RSC. It would be nice if you could "AND" the criteria together in the training status report.
Report to moderator   Logged
baronet68
Forum Regular

Posts: 143
Unit: PCR-WA-001

McChord.org
« Reply #5 on: January 22, 2019, 08:31:16 PM »

...but it will still require a line by line review to see who to remove.

In today's world, nobody has the time (or the eyes) for a line-by-line review of Excel files.  There are a lot of underused functions in Excel that can be helpful.  In this case, with two sets of data (report A with SLS, and report B with CLC), you can use the "=COUNTIF()" function in Excel to identify and remove everyone in report A who is also in report B. 

Even if the report is rendered with the most screwed up of Excel formatting, the whole process shouldn't take more than 15 minutes to get a usable list of candidates. 

Not being one to just say, "it can be done," and then walking away... PM me and I'll give you a hand.

Report to moderator   Logged
Michael Moore, Maj, CAP
Secret Wing Staff Dude, WAWG
Pages: [1] Send this topic Print 
CAP Talk  |  General Discussion  |  Membership  |  Topic: PD course eligibility report
 


Powered by MySQL Powered by PHP SMF 2.0.14 | SMF © 2017, Simple Machines Valid XHTML 1.0! Valid CSS!
Page created in 0.054 seconds with 26 queries.
click here to email me