Calculated PFT/CFT Performance Worksheet (NAVMC 11622) in Excel v4.1.0 dtd 30 Jun 2017

Calculated PFT/CFT Performance Worksheet (NAVMC 11622) in Excel v4.1.0 dtd 30 Jun 2017
    Features:

  • All PFT and CFT event points are autocalculated.
  • Ability to copy/paste bulk personnel information from existing spreadsheets.
  • Tab or arrow key navigation between cells.
  • Formatted for Electronic Data Interchange Personal Identifier (EDIPI).
  • High altitude compensation.

Facebook page
YouTube tutorials


Download version 4.1.0

– via Google Drive
– via Dropbox


Changelog:

    v4.1.0 30 Jun 2017

  • Added body fat calculator to Quick Calc sheet.
  • Added contextual prompts for missing required information in the Quick
    Calc sheet.
  • Added body fat percentage chart.
  • Widened the weight columns to allow for extended entries such as 205/18%.
    v4.0.0 24 May 2017

  • Expanded to 50 personnel per page, up to 200 personnel.
  • Added PFT and CFT input sheets for easier copying and pasting of bulk data, as well as “”in the field”” printable, preformatted rosters of personnel.
  • Removed DOB requirement, as scores are for reference only since MCTIMS calculates them based on MCTFS data.
  • Equalized NAVMC row heights.
  • In Resources sheet, updated instructions.
  • In Troubleshooting sheet, removed absolute cell and column references.
    v3.2.0 – 18 May 2017

  • Added a Quick Calc tab for score-only inquires.
    v3.1.0 – 09 Feb 2017

  • Various formatting changes for better page balance.
    v3.0.0 – 01 Jan 2017

  • All score tables and height and weight chart adjusted in accordance with MCBul 6100 – Marine Corps Physical Fitness and Combat Fitness Tests, and MCO 6110.3a – Marine Corps Body Composition and Military Appearance Program dtd 15 Dec 2016.
    v2.5.0 – 24 Oct 2016

  • Adapted for sorting and filtering.
    v2.4.1 – 07 Oct 2016

  • Fixed bug where CFT points wouldn’t calculate for Marines 46 years old and older.
    v2.4.0 – 18 Nov 2015

  • Added Privacy Act Statement.
    v2.3.1 – 16 Nov 2015

  • Expanded Column A row count to prevent truncated numbers.
    v2.3.0 – 30 Jul 2015

  • Reduced worksheet to 45 rows for better page balance.
  • Some small cosmetic changes.
    v2.2.1 – 14 Jul 2015

  • In Troubleshooting tab, changed references to cell G3, to cell G2.
  • In Resources tab, changed reference to Row 3, to Row 2, as well as reference to range B6:J55, to B5:J54.
    v2.2.0 – 27 May 2015

  • Remove assorted links from main worksheet header.
  • Created Resources sheet which consolidated Instructions, Facebook, Youtube, Contact, and Subscribe links.
  • Hid PFT/CFT score tables.
  • Protected Workbook to prevent sheet manipulation.
  • Replaced goo.gl URLs to facilitate Facebook Page and YouTube video tutorials access via government computer.
    v2.1.0 – 25 May 2015

  • Added link to Facebook page and YouTube video tutorials.
  • Reformatted EDIPI column to allow for leading zeros.
  • Added version number and date to header.
    v2.0.1 – 16 May 2015

  • Completed missing MTC (High Altitude) data after 4:56.
  • Recoded crunches, run, MTC, and MANUF to align with minimum requirements by age.
  • Clarified comments in cell L5 for Female pullups and flexed arm hang data ranges.
  • Female flexed arm hang now scores times between 9 and 39 seconds.
  • Changed Female pullups to a range of 0-8.
    v2.0.0 – 23 Mar 2015

  • Added Female pullups.
  • Expanded Worksheet to 50 rows.
  • Recoded Crunches score to reflect 100 points for crunches greater than 99, and 0 points for crunches less than 40.
  • Added data validation to EDIPI, height, weight, and crunches. Centered Worksheet both horizontally and vertically on Print.
  • Fixed various typos and verbiage in Instructions sheet.
    v1.5.0 – 05 Mar 2015

  • Fixed inconsistent text formatting in cell C6.
  • Increased overall text size.
  • Added cell indent to Rank and Name columns.
  • Middle aligned most cells.
  • Increased padding of row numbers to increase readability.
  • Added asterisk to Age for worksheet note reference.
  • Changed EDIPI, height, and weight columns to number format to allow for conditional formatting.
  • Adjusted some columns widths for better space management.
    v1.4.0 – 13 Feb 2015

  • Added subscription update hyperlink.
  • Added troubleshooting tab for common errors.
  • NAVMC worksheet version now references Changelog.
  • Added personal email in Cc: line.
  • Expanded Monitor block for print and sign.
  • Changed some Instructions verbiage.
  • Changed some Comment verbiage and formatting. Removed cell highlighting.
    v1.3.0 – 12 Jan 2015

  • Changed age calculation to use event date rather than Now().
  • Formatted event date to be consistent with DOB.
    v1.2.0 – 05 Nov 2014

  • Fixed alignment on various cells.
  • Allowed cell formatting.
  • Modified instructions for paste clarification.
  • Added date modification to version number on worksheet.
  • Added drop down input messages and error alerts.
  • Removed ability to select locked cells.
    v1.1.0 – 30 Oct 2014

  • Removed permalink to current version, as is blocked by gov computers.
  • Added row numbers.
  • Enabled Freeze Panes.
  • Expanded sheet to 40 rows.
    v1.0.1 – 08 May 2014

  • Fixed some calculation bugs where incorrect columns were referenced.
    v1.0.0 – 14 Apr 2014

  • First stable release. All tables and calculations complete.
    v0.2.0 – 09 Apr 2014

  • Beta release. Calculates scores for PFT only to include high altitude compensation.
    v0.1.0 – 24 Mar 2014

  • Alpha release. Formatting and columns complete.

Download calculated pft cft performance worksheet NAVMC 11622 in Excel, Download PFT score sheet in Excel, download CFT score sheet in excel, download pft spreadsheet, download cft spreadsheet, download calculated navmc 11622

ShareThis

3 Responses to “Calculated PFT/CFT Performance Worksheet (NAVMC 11622) in Excel v4.1.0 dtd 30 Jun 2017”

  1. Jayme says:

    Glad it helped. Accessing this page via government computer is hit or miss, but feel free to pass the spreadsheet along. There ARE a few design tweaks you may want to get approved for use by your S-3, however.

  2. old corps says:

    can you tell me why my pts for MTC and MANUF are not calculating? I followed the formatting help tab for the input number. shows “#” on screen and “false” when printed. thanks!

    • Jayme says:

      Errors will happen if you don’t fill in DOB and Gender. Take another look at what you might have forgotten to populate and let me know.

Leave a Reply

The author.Born in the year of the Dragon, the author grudgingly accepts the fact he has too many interests and not enough time. A cyclist as long as he can remember, an avid yet inconsistent writer since age eleven, and a U.S. Marine since age twenty-one, the author also adds peak bagging, diving, snowboarding, and computers to his list of interests. Incidentally, he is aware of his inability to make a living from any but the Corps. The author accepts this as fact and remains optimistic. Feel free to drop him a line.

  • Jayme on Drill Instructor duty, Parris Island: A retrospective: I remember PCA’ers didn’t get leave after school. But I took a month after my…
  • DD on Drill Instructor duty, Parris Island: A retrospective: DI school is approx 11 weeks, does anyone know if time off is granted upon…
  • Raymond Potter on Drill Instructor duty, Parris Island: A retrospective: Send me an email. I am very interested in talking to you. As I…
  • Jayme on Calculated PFT/CFT Performance Worksheet (NAVMC 11622) in Excel v4.1.0 dtd 30 Jun 2017: Errors will happen if you don’t fill in DOB and Gender. Take another look…
  • old corps on Calculated PFT/CFT Performance Worksheet (NAVMC 11622) in Excel v4.1.0 dtd 30 Jun 2017: can you tell me why my pts for MTC and MANUF are not calculating? …
  • Jayme on Calculated PFT/CFT Performance Worksheet (NAVMC 11622) in Excel v4.1.0 dtd 30 Jun 2017: Glad it helped. Accessing this page via government computer is hit or miss, but feel…
  • SeanD on Recruit survival guide (politically correct remix): Ppl seem to forget what Marines do, they would like. Hats to train recruits to…
  • Kaylee on A mother’s PostSecret: There’s always another way to interpret something. One’s interpretation is an opinion, not a fact….
  • Jayme on A mother’s PostSecret: In your words, it makes perfect sense. But they aren’t HER words. Her words are…
  • Kaylee on A mother’s PostSecret: Maybe she’s just scared to lose him. I have several very close friends that joined…
  • Jayme on Better off a memory: Yes, it is. What was haunting? The visit? Your memory of this? The story?…
  • Your goddaughter on Better off a memory: Is this when you gave me that blue dolphin necklace? This…this haunts me….
  • Adda on Drill Instructor duty, Parris Island: A retrospective: Jayme, Spot-on! This must be the 6th time I’ve read this and my reaction…
  • Jayme on 5 things men want women to know: For the record, I’m a closet Danielle Steele fan. Read a lot of her books…
  • Brittany on 5 things men want women to know: It’s nice to see a man’s perspective on relationships as so many articles are written…
  • Jayme on 2009 Eastern Division [rifle and pistol] Matches results: What’s so special about that score in particular? Contact the range where the matches were…
  • Percival on 2009 Eastern Division [rifle and pistol] Matches results: Hey how can i get the scoring roster from a 2009 Far east division championships…
  • Jayme on Drill Instructor duty, Parris Island: A retrospective: Plenty of good stuff. None of it comes to mind right now though….
  • John on Drill Instructor duty, Parris Island: A retrospective: I mean damn. Is there anything good about leaving to go the drill field? I’ve…
  • OLD BOOT on Drill Instructor duty, Parris Island: A retrospective: ANOTHER POST OF EXCELLENCE!…