PMP Application Assistant Spreadsheet

Probably The Best PMP Spreadsheet In The World!

Looking for a PMP spreadsheet to help organize your project experience quickly and easily? You are in the right place!

If you are just here for the PMP Spreadsheet...

No need to go any further...just let us know where to e-mail you a copy for FREE!

If you want to learn more, have any questions, or are just a spreadsheet nerd...keep reading...

So you are planning on taking the PMP exam. You end up on PMI's Project Management Professional (PMP)® page or maybe even our PMP® Credential Overview page where you learn that one of the prerequisites to be eligible to apply for the PMP exam is to have either 4500 or 7500 (depending on your degree) hours of project experience. For most of us, that is likely to be a dozen or more projects going back quite a few years. All of which you will need to document on your PMP application.

I don't know about you but I can barely remember stuff that I worked on last week let alone years ago. But hey, if you have a photographic memory and can remember every project and how many hours you've worked going back multiple years, just skip this page and head on over to pmi.org and start filling out your application now. For us mere mortals, we will have to spend a little time researching, remembering, and organizing all of our project experience.

So your options are:

  • Use and archaic writing device (aka a pen or pencil) to write down all of those projects manually. (not recommended)
  • Try to build your own spreadsheet that organizes all of those project exactly how PMI wants them. (not recommended)
  • Simply download and start right away with the most ridiculously awesome PMP Spreadsheet ever built, for free! (highly recommended)

 Sure there are plenty of other PMP spreadsheets out there but there is only one that holds the title of "Probably the Best PMP Application Assistant Spreadsheet in the World".

What all does this PMP Spreadsheet do?

This PMP Spreadsheet has many nifty little features, here are a few of the highlights:

  • Easily organize all your project info in one location (dates, hours, company info, etc...)
  • Quickly break down your project hours into the Domain Areas that PMI requires (initiating, planning, executing, etc...)
  • Provides tips and examples of how to write a good project summary in a format that PMI will be looking for (required on all projects)

So what are you waiting for?

Get your FREE copy of the PMP Application Assistant Spreadsheet right now!

 

One more thing...

This ridiculously awesome PMP spreadsheet didn't get that way on it's own...it is through your feedback (and maybe a little help from our design ninjas) that this bad boy has obtained the title of "Probably the Best PMP Application Assistant Spreadsheet in the World".

Seriously though, this thing had some pretty humble beginnings. With your suggestions and feedback however, we have added quite a bit of functionality over the years. So if you have any questions, comments, suggestions, or ridiculously awesome praise, please leave your comments below. Thanks!

For additional resources please be sure to check out our PMP Information and Resources page.

Last thing...I promise...

We receive many comments below and they tend to be one of three things:

  1. "The spreadsheet is locked, can you send me the password".
    • Yes the spreadsheet is locked but that is only to protect cells with formulas. All of the cells you need for entering data are unlocked and editable, no password required.
  2. Love!
    • Many folks like to share the love and we love that! Keep 'em coming!
  3. Suggestions for feature adds and bug fixes.
    • We need you for this! Help ensure that this spreadsheet retains its title of Probably the Best...

84 Comments

  1. Drew on July 31, 2012 at 11:25 am

    Looks like a great help, but I keep getting the spreadsheet as locked
    how do I open it for use
    Thanks

    • Devin Fremouw Devin Fremouw on July 21, 2012 at 11:45 am

      Hi Drew,

      Yes the spreadsheet is locked in order to prevent any accidental deletion of the formulas. All of the cells in which you need to input your information however, are unlocked and are available to be edited.

      I just double checked that all of the necessary cells are unlock and available for editing and it is good to go.

      Thanks!

    • Fauzia Qureshi on October 4, 2017 at 7:44 am

      Thank you!!!!! This is exactly what I was looking for, I am actually surprised that I was able to download for free! Thank you again!

  2. Faysal Yatim on April 6, 2013 at 6:20 am

    Dear Mrs/Sirs,
    I’m a trainer and would like to use your “PMP Application Assistant Spreadsheet” during the training sessions of project management. I may have also to give a modified copy to the attendees. Is this possible?
    Thank you in advance

    • Devin Fremouw Devin Fremouw on April 6, 2013 at 9:15 am

      Hello Faysal,
      I will contact you via e-mail regarding your request.
      Thank you!

  3. Lacey Hogness on February 24, 2014 at 12:51 pm

    Hi-

    Thank you for building that awesome PM hours tracking spread sheet. I have exceeded the 15 projects that the spread sheet is built with; can you provide me with the password to unlock the spreadsheet so I am able to add more projects?

    Thanks!

    • Devin Fremouw Devin Fremouw on February 24, 2014 at 3:17 pm

      Hello Lacey and thank you for you kind words.

      There are many formulas that and logic that is happening behind the scenes on the spreadsheet so adding additional project tabs is going to be somewhat of a complicated process. We have recently received many requests asking for more project tabs. I am currently in the middle of updating the spreadsheet to double the number of project tabs from 15 to 30. I will contact you via e-mail and send you a copy upon completion.

      Thank you!

  4. Olga Kasjanova on July 21, 2014 at 10:52 am

    Hi Devin,

    I love the template that is available through your website. The issue is with
    some locked cells. The reason I’d need to unlock them is to change the number
    of hours required for experience from 7,500 to 4,500.

    Would love any help with this.

    Thanks
    Olga

    • Devin Fremouw Devin Fremouw on July 21, 2014 at 3:33 pm

      Hello Olga,

      The number of experience hours is a formula that is calculated based off of the education level that you select…if you select your education level first it will automatically update the number of hours required. 🙂

      Thank you!

      • Olga Kasjanova on July 22, 2014 at 11:58 am

        ah! that’s so easy – thank you!

  5. Holly Miller on August 4, 2014 at 11:43 am

    Hi, I’m using this very helpful spreadsheet to document my projects for my PMP cert. Thank you! Since there is a requirement that project months do not overlap in the total project hours, I’m wondering if the formulas in this sheet account for that?
    thanks again!

    • Belinda Fremouw Belinda Fremouw on August 4, 2014 at 12:07 pm

      Hi Holly,
      Yes, the spreadsheet does account for that and will not double count any overlapping months.

      Have a wonderful day!!!
      Belinda

      • Holly Miller on August 6, 2014 at 10:34 am

        Wonderful, thank you so much!

      • Holly Miller on August 6, 2014 at 10:36 am

        Oh one more question if you don’t mind…

        The project summaries are limited to 550 characters. Why is that? I’m finding it nearly impossible to do a summary of each process with that limitation. Do you have an example?

        thank you,

        • Belinda Fremouw Belinda Fremouw on August 16, 2014 at 11:06 am

          Yes, it’s a bit crazy, isn’t it? I’m not sure why PMI limits it to that amount.

          Here is a sample (430 characters):
          The objective of the learning concept project was to develop and publish relevant exam topics. As project manager I was responsible for: identifying the stakeholders, including SMEs, obtaining project authorization, working with the SMEs, monitoring project progress, providing status updates, QC’ing draft posts, validating post quality, and securing final sign-off of the project. Project launched successfully on time and on budget.

          Let me know if you have any additional questions – I’m happy to help!!
          Belinda

  6. Mark M on December 14, 2014 at 6:34 am

    Hi, I downloaded your excel template…which I LOVE…but the application date cell is locked. That seems to be a big deal in entering experience.
    Can you please tell me how to unlock that, as it’s password protected.

    I wanted to leave a comment, but there is no area for me to do so.

    Thank you.

    Regards, Mark

    • Devin Fremouw Devin Fremouw on December 14, 2014 at 9:24 am

      Hi Mark,
      I’m sorry you’re experiencing difficulty. I just went into the spreadsheet and confirmed that the application submission date on the “Experience Summary” tab is not locked. You do have to use the drop-downs, however, maybe that was the issue?

      The only cells that are locked are those that are auto-calculating and do not need any type of manual update.

      Please let me know if you are able to make it work.

      Again, my apologies for any inconvenience.

      • Mark M on December 14, 2014 at 9:56 am

        Wow, I did NOT expect a response on the weekend. Thank you!

        You know what, I feel really stupid because I wasn’t clicking on the dropdown box for that. I deleted the copy I had and downloaded a new and it’s working great.

        Thank you!

  7. sainad on July 6, 2015 at 11:23 pm

    Can you explain me how to caluclate number of hours? I have worked for 3 years on projects continously that means how many hours i should enter is it 3 years x 12 months x30daysx 24 hrs or should i take only 12 hrs working hrs of the day ,should i exclude sundays and all?

    • Devin Fremouw Devin Fremouw on July 7, 2015 at 11:03 am

      Hello Sainadh,

      The actual PMP application will require that you list each project separately and the spreadsheet is set up in a similar manner with separate project tabs (P1, P2, etc…) for each project that you have worked on. On each project tab, you will enter the total number of qualified hours that you have worked on the project and then estimate what percentage of that total time was spent on each project domain (Initiating, Planning, etc…).

      A few things to keep in mind as it relates to ‘qualified hours’:

      • They must be within the last 8 years
      • You may only take up to 40 hours per week (even if you may have worked on two projects at the same time, you may only take up to 40 hours per week between the two projects)

      I hope this provides the clarification that you are looking for. Thank you!

  8. Jane H on July 8, 2015 at 6:08 am

    I just discovered your awesome spreadsheet. I was searching for a good way to document my experience from the beginning and I thought your spreadsheet might just be it. But now I am bit scared, because I just noticed, that the end date cannot be later than 2015. What I am going to do when the year turns 2016 and I want to continue to input my PM hours. Will I be able to easily copy my input into a new version of your table?

    • Devin Fremouw Devin Fremouw on July 9, 2015 at 10:02 am

      Hello Jane,
      The spreadsheet is set up in such a way that the dates you are referring to are based on the current date and will therefore any future dates (years) will be available once we are at that date. In other words, once it is 2016, the year 2016 will be available as an option in the spreadsheet.
      Thank you!

  9. Jen on July 9, 2015 at 9:24 am

    Hi,
    I’m working on filling out the spreadsheet, and only see room to put in 1 class for PM Education. Where can I input additional coursework?
    Thanks!

    • Devin Fremouw Devin Fremouw on July 9, 2015 at 10:10 am

      Hello Jen,

      At this time there is only one place to put list your PM Education. When designing the spreadsheet and through our experience, most folks tend to get their entire education requirement from one class. It is possible however that the 35 hours of education may come from multiple classes and the actual PMP application on PMI’s site will allow you to list multiple classes. I will add this functionality to the list of revisions to be added to the next version of the spreadsheet.

      One suggestion that I would make to anyone that has more than the 35 contact hours required…you don’t get any extra credit with PMI if you have more than the minimum requirement so if you do have one class that meets the minimum, I would suggest listing only that class on the PMP application. In the event of an audit, you will be required to document everything listed on your application and that is one instance where the less you have to document the easier it may be.

      Thank you!

  10. Alicia on July 18, 2015 at 9:09 am

    When I say your spreadsheet is AMAZING, please know that is a clear understatement. I appreciate the time and “passion” under which this was created. It has been extremely helpful in organizing my experience and potentially highlighting areas of improvement. I actually found I had many more hours than necessary to qualify. Thanks again.

  11. kanchan on July 26, 2015 at 12:01 pm

    Really impressed… Thank you !!!

  12. Saki on August 3, 2015 at 2:12 am

    HI,
    I just downloaded ur sheet, Seems very useful…
    Is it the latest version(6.3)?
    Some told we need to have % breakdowns within domain..
    Please help

    • Devin Fremouw Devin Fremouw on August 4, 2015 at 10:34 am

      Hi Saki,

      Yes, the latest version is 6.3b as of 8/1/2015. Within each individual project that is to be input on each of the project tabs (P1, P2, etc..) you will enter the total number of hours for that project and then estimate what percentage of time was spent in each domain (Initiating, Planning, etc…) and that will automatically carry over to the “Experience Summary” tab that will then show the total number of hours by domain for all projects.

      Please keep in mind that not every project requires time spent in all domains but overall it is required that you have some hours spent in each domain. For example…project 1 may have hours spent in Initiating, Planning, and Executing but none in M&C or Closing…Project two may have hours spent in only M&C and Closing. Cumulatively you will have some hours spent in all domains and that is the key.

      I hope that helps, thank you!

  13. Bob Williams on August 3, 2015 at 1:16 pm

    Over the last year or so I have began looking into the PMP certification process. I have finally decided to take the next step and move forward with collecting PM detailed information. I have many years of Project and resource management mostly in the execution area. My question to you (and this spreadsheet is “incredible”) is… Once collecting previous years information and placing into this format, can this then be effectively used as the document to file for with. I mean I am assuming that this level of information will pass an audit with no issues….???

    • Devin Fremouw Devin Fremouw on August 4, 2015 at 10:49 am

      Hi Bob,

      Thank you very much for the kind words, there has been a lot of time and effort that has gone into this spreadsheet.

      If i am understanding you correctly you are asking if this spreadsheet can be used as your application/documentation to be submitted to PMI. The answer to that is no…you will be required to set up and account on PMI’s website and fill out a complete application there. The spreadsheet however, is designed to have all of the same information that will be on the acctual PMP application on PMI’s website. The purpose of the spreadsheet is to allow you to gather, organize, and count up all of your information to assure that you meet the requirements prior to begining your acctual application. Once the spreadsheet is completed entirely then it should be a great reference for you to simply carry over all of your info directly to the acctual application.

      In regards to an audit…the level of detail on the application has nothing to do with an audit. An audit will simply be a matter of verifying the information you put on your application. For more details on PMI audits please refer to our blogpost concerning PMI audits.

  14. Helen on August 4, 2015 at 8:53 pm

    Hello,

    Great tool! Thank you for all the effort spent putting this spreadsheet together. I’ve started entering my projects. For one of the projects that ended in January 2015, I get a red message saying that “This is a future date”. Glitch?

    • Devin Fremouw Devin Fremouw on August 4, 2015 at 9:33 am

      Hi Helen, you are very welcome and thank you for the kind words. Nope, not a glitch…make sure you change the ‘application submission date’ on the ‘Experience Summary’ tab to a future date…it is most likely set to a date in the past and that is what is giving you the future date warning on the project tabs.

      I have actually received quite a few e-mails with this same question so I have committed to some type of change or further instruction in the next release.

      Thank you very much and best of luck in your application process and on your exam! 🙂

  15. Anna on August 13, 2015 at 7:06 am

    I love the spreadsheet, super well designed, and amazing GUI.

    Is there a way to change the color of the tab to green when all the required cells are filled in? Or is it possible to unlock the Recolor Tab option so it can be done manually? This is kind of a minor thing, but it’d be nice for visual project completion types.

    • Devin Fremouw Devin Fremouw on August 13, 2015 at 8:58 am

      Hello Anna,

      Thank you very much for the kind words!

      I really like the new design idea that you mention. I have looked into it a bit and found that it is not possible to simply unlock the ‘Tab Color’ option by itself…to unlock that option would require unlocking other options that would potentially allow the workbook structure and functionality to be compromised or broken.

      The other option would be to set up the sheet to automatically recolor the tabs based on the completion of certain cells. To do this however would require a pretty lengthy custom VBA script to be written and tested. I do not have the time to work on that right now but I will definitely add that to my list of enhancements to look into making for the next updated version of the spreadsheet. Because v6.3b was just released on 8/1/2015, it may be a while before I work on an updated version again.

      Sorry that those options don’t help you right now with what you are looking for but I sincerely thank you for such a great design suggestion!

      Best of luck on your road to the PMP! 🙂

  16. Penny on August 14, 2015 at 8:22 am

    Love this tool!!! This made the application process so much easier! Thank you!!

  17. Kerry on August 16, 2015 at 8:48 pm

    Hi Devin,

    I am a project manager and I am in the process of getting the PMP certificate. Your spreadsheet of the PM work experience is just awsome. Can I get the unlocked version?

    Thanks in advance!
    Kerry

    • Devin Fremouw Devin Fremouw on August 18, 2015 at 8:19 am

      Hello Kerry and thank you!

      As stated in the comment directly above yours:

      the spreadsheet is locked in order to prevent any accidental deletion of the formulas. All of the cells in which you need to input your information however, are unlocked and are available to be edited. I just double checked that all of the necessary cells are unlock and available for editing and it is good to go.

      Thanks!

  18. Doug on September 29, 2015 at 10:54 am

    Devin,

    I just graduated with a BS Degree in Project Management and Administration this year. The drop down on the education tab only goes through 2012, and I obviously need to indicate 2015. I tried to edit the dropdown by I don’t have the password to do so.

    Is there a way you can help me out?

    Thanks!!
    Doug

    • Devin Fremouw Devin Fremouw on September 29, 2015 at 12:01 pm

      Hi Doug,

      Indeed you are correct, the drop down only goes through 2012…I know that I’ve corrected that issue with the spreadsheet in the past but I guess with the v6.3b release it somehow made it’s way back in. Anyway, I have corrected the issue, made some other slight modifications, and have released v6.4. The download link at the top of this page has been updated.

      Thank you and best wishes in your exam preparation and testing!

  19. Ed on September 30, 2015 at 2:03 pm

    Excellent spreadsheet, makes the processing of collecting the required data less daunting.
    Many thanks!

  20. Barbara on October 6, 2015 at 1:30 pm

    It is true. Ridiculously awesome. Took no time at all. Thanks for your passionate project management. Very helpful.

  21. Rob Sylvester on October 22, 2015 at 7:32 am

    Is there a way to add additional projects past 30? I need the 7500 hours and will exceed the 30 projects to achieve the required number of hours… can this be doubled to 60?

    • Devin Fremouw Devin Fremouw on October 23, 2015 at 2:25 pm

      Hi Rob,

      I have had a few requests recently to add more project tabs and it is on my to-do list however it is a pretty major overhaul and so I might not be able to get to it for a while. In the mean time, a work around could be to simply save a separate copy of the spreadsheet and use that for any project past the current limit of 30.

      Sorry, but I will try to get to this as soon as I can. Thank you!

  22. David on November 19, 2015 at 10:28 am

    I really like the spreadsheet, but projects are not able to be finished in 2016 (or later) on the project specifics tabs. Is there a way I’m supposed to update that to have more years listed on the drop-down? Otherwise, will you be updating the file soon? Thanks

    • Devin Fremouw Devin Fremouw on November 20, 2015 at 2:40 pm

      Hello David,

      The original design of the spreadsheet was for folks that already had enough experience and were simply looking to get it organized before submitting their actual application. For that reason, I coded the project finish dates so that only the current calendar year could be selected and the formulas were such that when the current date rolls over to the next year the formulas would change and that year would become and option in drop downs.

      I have recently learned from many users that there are quite a few folks that do not yet have enough experience but are still using the spreadsheet to track as they progress over time and approach the required experience hours. Because of this many people were needing to be able to select future dates, just as your are asking.

      Well, the people have spoken and I have listened…I have recently updated the spreadsheet to v6.5 which now allows future dates to be selected! The new version 6.5 can now be downloaded via the link at the top of the page.

      ***Please note that the ‘Application Submission Date’ that you select on the ‘Experience Summary’ tab will now set up the available dates that can be selected on each of the ‘Project Tabs’***

      Thank you David and best of luck on your exam preparation!

  23. Emre on November 21, 2015 at 7:21 am

    Devin,
    I’ve been studying for a while for the PMP exam, concurrently thinking about a decent and practical way of prepping my PMP Experience Summary. I’d already found an Excel template online and had started jotting down stuff into that but your template is way better than that one.
    No need to be humble; yours is not “probably” the best PMP template, but “the best one” to my mind.
    I am in the Military industry and your template has swept much of the “fog of war” through my application process.
    Bottom line; your effort is much appreciated. Thanks for the great work and contribution!!
    Best…
    Emre

    • Devin Fremouw Devin Fremouw on December 3, 2015 at 2:43 pm

      Outstanding! Always great to hear such good feedback. I humbly say thank you for your very kind words! 🙂 Best of luck on your exam preparation Emre!

  24. Melanie on November 24, 2015 at 8:43 am

    I typed in the data in P1 to P5 and when looking at the tab Experience Summary it gives me a Reference error on the P1 line and does not display anything it typed in. I made sure the timelines are not parallel and it still shows up as #REF! error. Any ideas? Thank you.

    • Devin Fremouw Devin Fremouw on December 3, 2015 at 4:49 am

      Hello Melanie,

      Sorry for the delayed response… I am unable to replicate the error you describe. First thing…I have recently updated the spreadsheet to v6.5 (download link is available at the top of this page), I would give that one a try and see if you are still getting the same error. If you are still getting the same error, may I suggest you send us an e-mail using our contact form that I can reply to and you can attach a screen shot of the error so that I can investigate further.

      Thank you!

  25. Kelly MacDonald on November 25, 2015 at 5:29 pm

    Hello – this spreadsheet is JUST what I have been looking for – I really appreciate all your hard work!
    I started as a Project Manager in March of 2013. My education level (High School Diploma) means that I need 60 Project Months, therefore my expected month and year of application will be around March of 2018. Your pull-downs on the “Experience Summary” tab do not go as far ahead as 2018. Will you be making this change anytime soon? Also – I have already worked on 36 different projects, so I am fairly certain I will need more than 30 project tabs – do you expect to be increasing the number of project wroksheets? Again — this is really an excellent spreadsheet, you must have spent a lot of time on it! Kelly

    • Devin Fremouw Devin Fremouw on December 3, 2016 at 4:56 am

      Hi Kelly,

      Thank you very much for the kind words! 🙂

      The original design of the spreadsheet was for folks that already had enough experience and were simply looking to get it organized before submitting their actual application. For that reason, I coded the project finish dates so that only the current calendar year could be selected and the formulas were such that when the current date rolls over to the next year the formulas would change and that year would become and option in drop downs.

      I have recently learned from many users that there are quite a few folks that do not yet have enough experience but are still using the spreadsheet to track as they progress over time and approach the required experience hours. Because of this many people were needing to be able to select future dates, just as your are asking.

      Well, the people have spoken and I have listened…I have recently updated the spreadsheet to v6.5 which now allows future dates to be selected! The new version 6.5 can now be downloaded via the link at the top of the page.

      ***Please note that the ‘Application Submission Date’ that you select on the ‘Experience Summary’ tab will now set up the available dates that can be selected on each of the ‘Project Tabs’***

      Regarding the limit of 30 projects…I have had quite a few requests lately to increase the number of project tabs. This however, is a bit more of an overhaul and while it is still on my to-do list, I may not be able to get to that for a while. In the mean time, a work around would be to simply save two seperate copies of the spreadsheet and use the second one to keep track of any projects over the current limit of 30.

      Thank you an best of lock on your road to becoming a PMP!

  26. Ranjith Chinnaswamy on November 25, 2015 at 9:38 pm

    Hi i am using the PMP application excel .Am a beginner on PMP.
    on Education Worksheet –> What do you mean by Project Managment Education section for ?
    What to fill ? is this my Bachelors degree information or the PMP course details which i took ?
    Please clarify.

    • Devin Fremouw Devin Fremouw on December 3, 2015 at 3:10 pm

      Hello Ranjith,

      The Project Management Education section on the Education Worksheet is intended to be for the PMI requirement of “35 hours of project management education”. This could be a PMP course however it is not limited to that…it could be any type of traing course that has to do with project management.

      I hope that answers your question. Thank you Ranjith!

  27. Jessie on November 26, 2015 at 12:26 pm

    I have searched and searched and tried to make my own spreadsheet to track my project hours but this one definitely makes the process MUCH easier! Thank you for designing and sharing!

    • Devin Fremouw Devin Fremouw on December 3, 2015 at 3:12 pm

      Yessss! That is what we like to hear!

      Thank you Jessie and best of luck on your road to becoming a PMP!!!

  28. Kay Ross on November 27, 2015 at 8:06 pm

    This was the best thing I have ever had to help manage a task. Wow this made my hard task so much easier. Thanks

    • Devin Fremouw Devin Fremouw on December 3, 2015 at 3:14 pm

      Awesome, glad to hear it! Thank you Kay!

  29. Hafeez on November 29, 2015 at 12:19 pm

    Hi Devin,
    This is an awesome sheet. I wish I could use the free version to fill in my application form but it is password protected and the cells in which the date or year needs to be filled, is not working too. Please help.

    Thank you
    Hafeez

  30. Pat on January 6, 2016 at 8:03 am

    Thanks for creating this! I had been putting off taking the test because I couldn’t overcome the application bit. All set now!

  31. Michelle K on February 2, 2016 at 9:19 am

    Hello, When reviewing the Experience Summary I am not seeing/experiencing an update to PM Experience Months. It continues to say I have a need of 36 months. I have entered in 4 different projects for a total of 6000 hours and have 40 hours of PM Education but nothing is changing the PM Experience. Please advise.

    • Devin Fremouw Devin Fremouw on February 9, 2016 at 12:36 pm

      Hi Michelle,

      I apologize for the delayed response…i have looked into the issue that youare describing and I think that I may have found the cause. On the Project Tabs (P1, P2, etc…), if you have not filled in anything yet for the ‘Project Title’ in cell E7 then the “Experience Summary” tab is not pulling over the dates of the project and therefore not counting the PM Experience Months. It will still pull over the hours and count those but not the months.

      Give that a shot and see if it fixes your issue. In my next release i will look into changing the logic of some formulas so this won’t be an issue for anyone in the future.

      Thank you for your feedback, let me know if there is anything that I can do to assist, and best of luck on your road to the PMP! 🙂

      Devin

  32. Tochi on February 4, 2016 at 2:53 am

    Thank you so much for creating and sharing this outstanding form! Just thinking about logging my exeperience for the PMP exam made it seem so daunting. Now I’ve found your form, I’m not worried at all anymore!
    Your work is greatly appreciated!
    Best wishes,
    Tochi

  33. Pat on February 11, 2016 at 8:32 am

    Hi Devin,
    Thanks for the sheet I really like it but I need some help! When I enter the month and year on the experience summary (where the tag said the only thing for you to do on this page is this) it won’t populate the rest of the months and years. Is there something else I need to do?

    • Devin Fremouw Devin Fremouw on February 11, 2016 at 9:46 am

      Hi Pat,

      I am not entirely sure I understand what you mean. The Application Submission Date that you reference on the Experience Summary tab should set all of the dates in row 11, from column P and everything to the right. Once you enter your projects on the Project tabs (P1, P2, etc…) the data will carry over to the Experience Summary sheet and you should start to see things taking shape.

      If you are still having trouble please let me know.

      Thanks!

  34. Shika on February 12, 2016 at 1:36 pm

    This excel sheet is work of a genius and is very helpful. It has significantly reduced time to fill out PMP application.
    I would recommend this to everyone who is filling out application. Keep up the good work.
    Bonus its free!

    • Devin Fremouw Devin Fremouw on February 12, 2016 at 2:26 pm

      Thank you very much Shikha!

      I have put a lot of time into developing, maintaining, and improving this over the years…your kind words are very much appreciated!

      Best of luck on your exam!

  35. T. Morgan on February 15, 2016 at 11:36 am

    Devin,

    This spreadsheet is AMAZING !! I have been dreading documenting my project hours, I’ve tried a couple of other spreadsheets and was almost at the point of creating my own, or an Access database, until I found this spreadsheet referenced in the book Crack the New (2016) PMP Exam in 4 weeks by Shiv Shenoy. Anything I would have created could not compare to this masterpiece. Words can not thank you enough for the role this spreadsheet will play in helping me obtain my PMP certification. I truly appreciate you sharing your work.

    • Devin Fremouw Devin Fremouw on February 17, 2016 at 12:26 pm

      Thank you very much for the kind words, they are very much appreciated! 🙂

  36. David on March 31, 2016 at 2:40 pm

    Devin,

    As i’m sure you are aware, this is an OUTSTANDING worksheet. It totally mimics PMIs PMP application–down to the ‘experience’ character count! Thank you for taking the time to create this for those of us with aspirations of becoming a PMP certified practitioner.

    David

  37. David on June 24, 2016 at 6:43 am

    Devin – What a useful tool! Thank You for the time and effort you’ve put into making such a helpful resource.

  38. Madeh on July 18, 2016 at 7:53 am

    Good job! Very helpful stuff.

  39. Jake on July 18, 2016 at 11:49 am

    Hi,

    This spreadsheet was really well thought out and easy to use. Thank you for putting the time in to simplify the process for us! I especially appreciated the screenshots of the actual application process. This was a really useful exercise for me to validate that I have the required project hours and months to take the PM Training hours and apply to take the PMP exam.

  40. Hari on October 5, 2016 at 10:44 am

    Thank you for sharing the spreadsheet with the world. I have come across this great tool after playing around with half-a-dozen other spreadsheets that just didn’t it. Yours is user-friendly – easy to understand, easy to fill out the tabs, and easy to get a holistic view of project experience. I’d say this is the best in the world.

  41. Kristen on December 16, 2016 at 8:38 am

    I just want to thank you for providing this spreadsheet! I am in my first 6 months of PM experience and I am using this document to track my projects from day 1. I am already more organized in my preparation for the PMP exam than my more tenured colleagues. Thank you, this has been tremendously helpful!

  42. Kim on December 29, 2016 at 10:48 am

    A million thanks! This truly impressive spreadsheet made documenting my experience requirement for the PMP a breeze. I appreciate the work that went into creating and refining this awesome tool, and sharing it for free. You have a lot of good karma coming your way!

  43. Priyank on February 24, 2017 at 11:05 am

    Devin,
    Thank you for providing such an incredible tool!! This spreadsheet has every thing that any PMP certification aspirant would need, from an application standpoint and specifically for managing education and experience. I have tried many spreadsheets, from colleagues and other sources that cannot even come close to providing the level of usability that this tool can. This is a really very well thought out tool, which is “necessary” for every PMP aspirant. Fantastic job and have a great day!!!

    Regards,
    Priyank

  44. Rob N on June 7, 2017 at 11:39 am

    Just completed logging my hours and experience on your sheet. It was incredibly easy to use and intuitive. I appreciated the built in functions to guide me along the way. Nice Job! Thank you!

  45. KR on June 19, 2017 at 8:03 am

    I don’t have the words to describe this spreadsheet. Unbeliveably awesome (yes, bad grammar, I know). One question. Why WHY WHY aren’t you charging money for this??? I would have paid to use something that is so incredibly well built. With best wishes, K

  46. CK on June 23, 2017 at 12:08 pm

    Hello! Your Excel sheet was very helpful in helping me record my Project Management experience… Thank you for sending it to me to my email! Please continue to help other aspiring project managers in the future, I’m sure they’ll give you several good wishes and many thanks! With best wishes,
    -CK

  47. Sahee Katamraju on August 1, 2017 at 9:45 am

    This is a FANTASTIC spreadsheet and really helped with the calculations. I did not expect to receive all of this good useable information for FREE. I am trul grateful and now will have more success with passing the PMP exam.

    THANK YOU!!
    Sahee

  48. Patrick Wilson on August 28, 2017 at 8:53 pm

    I’m on the bandwagon! Hands down, this is the best tool I found to track experience and be able to easily copy & paste the data into the PMI website application. It worked too, as once I filled out the worksheet and transposed to the PMI application I was accepted with no further clarification required.The formulae make everything a breeze and prevent drafting too much information that won’t fit on the PMI application. My only recommendation — if you can figure a way to do it in Excel — is to enable duplicating the administrative info (organization details, organization’s phone number, organization’s contact, contact’s phone number) from project tab to project tab. I found that only changed once in my set of 10 projects and it would have been nice not to have to re-enter that on every tab on the worksheet.

    • Devin Fremouw Devin Fremouw on August 29, 2017 at 10:00 am

      Hi Patrick,
      Thank you so much for the high praise!
      Your suggestion sounds like a great addition, I have thought about this feature in the past but haven’t found an easy way to do it yet. It is definitely on the list up upgrades for the next release, hopefully I can figure it out and get it incorporated.
      Thanks for the recommendation!

  49. Jacqu'e Cumberbatch on September 15, 2017 at 10:55 am

    Hello Devin,

    I saw on PPM’s website, that this spreadsheet was described as the most “ridiculously awesome PMP spreadsheet ever built” What an accurate description!!!

    Thank you/PPM for the time and effort put into developing this spreadsheet. From the Instructions Tab, to the Project Tabs, the spreadsheet really simplifies the PMP application process. I agonized for three month, over the PMP application process, and procrastinated. But, once I found your spreadsheet, I was able to quickly document my projects and get the application submitted/approved. That felt like a huge weight had been lifted off of my shoulders

    In addition, I thank you for the other freebies, like the Quick Start Guide and the Question of the Day.

    Regards,

    Jacqu’e

  50. Finlay McCallum on October 4, 2017 at 10:50 am

    Hello Devin,
    Well, you went and did it!This spreadsheet is such a valuable tool in the application and verification process.

    I am grateful and thank you and your Team for designing this and making it public.

Leave a Comment





Passionate Project Management

2550 W Union Hills Dr

Suite 350-310

Phoenix, AZ 85027

(623) 466-6777

Mon - Fri | 9:00 - 5:00 MST

PMI REP
Better Business Bureau
PMP Quick Start Guide

PMP Quick Start Guide

All the upfront stuff you need to know before you even start studying for your PMP® exam.

 

Everything you need to know about PMI, the PMP credential, the application process, various study methods, the exam experience, and more!

Thank you for your request, you will receive an e-mail shortly with a download link.

Top