How Can I Get Monthly Totals...?

[Luis R. Ramos]

Hi-

I did not keep track of our squadron's members for 2012 on a monthly basis. Now I want to know how many members we had monthly for all of 2012. Is there a report I can request from NHQ that would list this?

Take care

Flyer

[MSG Mac]

I don't think there is. But a good hint for the future is to print out a copy of the membership rosters on the first of the month and maintain them in a binder. at the end of the year buy another binder and start over. 

[Eclipse]

NHQ can produce custom reports on request - don't know if the data exists to produce this, but it doesn't hurt to ask.

Send an email to the Helpdesk.

[rebowman]

Go to the CAPWATCH download in E-Services

[Eclipse]

That will only give you current numbers - if you start collecting them on a scheduled basis you can accrue the data going forward,
but it won't give you any history.

[rebowman]

Yes, collecting your own numbers is ideal BUT CAPWATCH DOES give a report that goes back to 2000

[Luis R. Ramos]

Rebow-

That produced the report I needed. Hard to use, yet the information was there for me to sift through. Thank you.

Flyer

[Eclipse]

You can pull history by month from CAPWatch? 

Which report?  Or is it parsing the tables?

[Luis R. Ramos]

As I stated on my answer to Rebow, it was difficult to read, for me. It lists by year and month, "total cadets," "total seniors," "total patrons." All the way to 2000.

The report is "Orgstatistics," and a line from it is:

1566,"RRR","SS","XXX","CADET","TOTAL",22,"02/29/2000"

Note that I replaced the Region with "RRR" but here appears the initials for your region. Likewise "SS" lists the Wing, and "XXX" is the unit. This line lists the total number of cadets for Feb 2000. Similar line gives seniors and patrons.

I do not know what "1566" represents.

Other lines before the totals lists how many were renewals, another how many were new.

Flyer

[Eclipse]

I'm going to have to check that out, that could be really useful.

[cm42]

Tip for those not familiar: CAPWATCH was (is still?) based on database tables, so import the .txt files in Excel using the Text Import function or Text To Columns, and things will make more sense. For instance, the 1566 is an index number from the Organization table (text file), and you'll find 1566 has your basic squadron info (unit ID, unit name, type of unit, etc.). It also makes it a LOT easier to manipulate the data, including putting it into a pivot table to make it more readable, or do calculations on it, such as change in number of members per month.

[a2capt]

I'm going to have to check that out, that could be really useful.

This is actually useful, ironic that a debate about unit size came up in the last week or so ..and this is perfect. With wing-wide CAPWATCH data I can put together a graph showing statistical history of all the units in question for the last 12 years. More than ample enough to back up a rebuttal.


Timely hints, just one of the many things great about CT

[JeffDG]

I don't think there is. But a good hint for the future is to print out a copy of the membership rosters on the first of the month and maintain them in a binder. at the end of the year buy another binder and start over.

I would suggest the last of every month, so you catch your membership total before the drops due to non-renewal.

[UWONGO2]

Has anyone come up with a spreadsheet that uses this data that you'd be willing to share? I'd like to put together a line chart that shows our unit's cadet and senior membership totals over time.

Thanks!