I was wondering if anyone out there on RallyPoint utilizes Excel in tracking APFT and Weapons Qualification?

2016-07-06T17:25:41-04:00

Response by SSG Private RallyPoint Member made Jul 6 at 2016 5:35 PM

2016-07-06T17:35:22-04:00

I am asking because the one i am currently using is out of date and is locked.

Response by MSG Pat Colby made Jul 6 at 2016 5:47 PM

2016-07-06T17:47:44-04:00

I used Excel for both APFT and Qual but that was 15 years ago.

It's a good tool but keeping it maintained is a pain in the ass.

Response by TSgt Private RallyPoint Member made Jul 6 at 2016 6:24 PM

2016-07-06T18:24:01-04:00

our squadron has an excel template that keeps track of almost 200 people with great efficiency. if you'd like, i can send you a copy of the template for you to try.

Response by SFC Private RallyPoint Member made Jul 7 at 2016 11:29 AM

2016-07-07T11:29:55-04:00

I was just thinking you must be in 212th CSH in Miesau, Germany. The one I used there was locked and it was a major headache to get it updated after we changed to one standard for the sit-ups. I had to copy everything into a new workbook and basically start over. Now there are some great websites that can teach you how to program excel sheets. Get cracking SPC and tell the family to put your dinner in the microwave because you won't be home anytime soon. Good luck.

Response by SPC Matthew Cournoyer made Jul 7 at 2016 1:11 PM

2016-07-07T13:11:46-04:00

I did this for a while in Germany, it's painful and time consuming. Talk to your 42As and see if they can provide you a AAA-162 on digits and just recreate the spreadsheet. The 162 on digits should be an excel that you can manipulate. DTMS isn't much better for usability but it will store and maintain that data and maintain a record of it while making the info accessible to the leadership as well and really the army is pushing towards mandatory use of DMTS anyway.

Response by 1SG Private RallyPoint Member made Jul 7 at 2016 5:33 PM

2016-07-07T17:33:38-04:00

I have a pretty good tracker I use for my company. It even breaks down scores by average per squad so you can see which platoons/squads are performing better on the metrics.

Response by SGT Private RallyPoint Member made Jul 10 at 2016 1:58 PM

2016-07-10T13:58:53-04:00

Doesn't the military already utilize a newish system (5+ years old) to track everything to do with a soldier including POC information.it also generates excel spreadsheet reports. I would look into that system perhaps S1 can point you in the right direction