If you’ve ever aspired to try to track your finances to monitor and/or analyze your finances, this Excel spreadsheet may be the easiest and most self-motivating way you’ve yet seen! I haven’t seen any bank’s free or paid online financial tracking system give you this much information about your immediate financial status, nor as quickly. With that constant immediate feedback as you enter each new piece of data, don’t be surprised if you find yourself constantly setting your own financial targets to hit, either!
March 2016 Update
I have added a separate, but very detailed introversion / extraversion assessment from Scientific American magazine. This is the most confusing and misunderstood dimension of the four in the personality assessment below so you might want to try this Scientific American assessment to better understand yourself, and/or the concept of introversion / extraversion, itself, and possibly others with that better understanding.
January 2016 update
The personality assessment here is now available as a free iOS app in the iTunes App Store! (my version is an Excel spreadsheet that works like software)
Get a free, complete personality assessment via the personality typing system created by Carl Jung, popularized by personality assessments as the Myers-Briggs Type Indicator® (MBTI®)* and Keirsey Temperament Sorter® (KTS®). This assessment is neither the MBTI® nor the KTS® (both paid services), though it has the same objective to identify your personality type in Jung’s personality typing system. The questions are just slightly different from the KTS® to extract the most accurate answers from users so you can get the truest results for yourself.
Why is method so important?
All the personality assessments mentioned above rely on how honestly you answer questions about yourself. They are only as good as you can be honest about yourself. Unfortunately, being honest about ourselves is something we are all challenged with to some extent in life. We all have biased self-perception, misconception or ignorance of our nature, or inconsistent understandings of what it means to be something. To overcome that, the questions in the assessment here ask about common real life situations so people can recall how they reacted rather than theorizing how they would react. What people say and do can often be very different! Cultural biases, obscure expressions, words with stigmas or noble connotations, and the like, have also been minimized.
Why do this assessment or do it again?
Ultimately, you’d do this assessment to get an objective view of your personality, what you are generally like in life and how you interact with others of differing personalities. The assessment cover situations at work and play, in various types of relationships and general life, and interactions with all other personality types in Jung’s system.
A side reason, possibly funner and more practical reason, is to see how you compare with anyone else who has taken a version of this, MBTI® or KTS®… or can be persuaded to take one by you. You can even compare yourself to famous people and fictional characters who might have never taken the assessment! Jung’s personality typing system is actually a theory so experts have been able to type people who have never taken the assessments based on their known actions (not words).
If you’ve done MBTI® or KTS® some years before, you might want to try “it” again as people change over time. This is truer if they have lived through life changing events like marriage, children, trauma or otherwise.
Downloads for the personality assessment tool
There are two Excel files for download here, in which you can answer the questions to get your personality type identified and assessed. One file is a modified KTS® assessment with the “best” questions, in my opinion, from KTS® versions I and II. The other is the same assessment with very basic English or “plain language” for people not completely fluent in English. Theoretically, you should get the same result doing either assessment.
- Based on the best Jungian personality assessment tool available, in my opinion, developed by David Keirsey in his classic books Please Understand Me and Please Understand Me II.
- Version here is a “best of” KTS® versions I and II, using questions I thought would elicit most honest answers from most users. KTS-II® is used by the KTS site.
- Questions ask about real life situations, not abstract concepts like preferred words.
- Does not ask for absolute answers, but rather preferences.
- Has been extensively used around the world. Claims to be most popular personality assessment in the world and Web traffic seems to indicate that, but MBTI® is probably most well-known from its longer history (close to 50 years).
- Has flaws of challenging language, cultural bias, references and expressions which may be challenging to those not fluent in English or have low literacy.
- Mostly uses questions from the “best of” Modified KTS® version above, for the reasons that make it excellent.
- Language is simplified so those for whom English is a foreign language, or those with low grade reading levels, can do the assessment and do it accurately. This is actually an excellent ESL or EFL class exercise!
- Idioms or expressions are minimized.
- Terms with cultural bias, like noble or stigmatized words, are eliminated.
Doing the Personality Assessment (Fig 1)
Please refer to Figure 1 above.
- There are 74 multiple choice questions to the test.
- Just put A or B in the boxes beside each question.
- You can’t select any cells besides those so no worries about messing up the file.
- If you put anything besides A or B, the file will tell you to do otherwise.
Getting your Results Summary (Fig 2)
After you have entered an acceptable answer for all 74 questions, click on the RESULTS tab near the bottom left of the window to get your results.
The file tabulates your scores so there are no mistakes, and gives you a summary as shown above.
Click Print and it will print out all on one page automatically, if you want a print out.
Your Results Summary and Full Assessment (Fig 3)
Your results summary is just a brief part of your full assessment. There are multiple PDF files available with tens of pages of content for you to consider if you so wish.
* MBTI and Myers-Briggs Type Indicator are trademarks or registered trademarks of the MBTI Trust, Inc., in the United States and other countries.
Jan 2 2015 update
Everything below from the original post still applies. The link immediately below is for a MS Excel 2010 version so you don’t have to put up with “compatibility issues” of the old log. I hope you’ll like it. The MS Excel 97-2003 version is far below if you’re still using that version of Excel.
This is a much updated version of the year long Excel spreadsheet running log I had posted two years ago. You may want to refer to that post for some instructions. Thank you to all of you who had downloaded it, used it, suggested improvements and recommended it to others. If you liked that log, I think you’ll love this one! This new log has some great features I think you’ll love like a spot for your training plan next to what you did. While the focus is on running, there is room for other exercises and things you might want to track, like sleep, injuries, supplements, heart rate averages and maximums, etc. There is a race predictor using Jack Daniels’ running formula, with a short, simplified, but effective and practical explanation on how to use it. There is a calculator to determine any of time, distance or pace you need to run if you know 2 of the 3 variables. There is also a routes table to help calculate routes you take that are not your normal ones, but piece together bits of various routes you have ran. There is no new “summary” feature where what you input is number crunched, but that was because I didn’t perceive the need for any. Otherwise, most cells you shouldn’t touch are still locked up, but you have the ability to manipulate some partially for your use, like if you write a long comment one day and want to show it all rather than have some of it hidden away. As you use this spreadsheet, change the view size if the info is too small for your comfort. It can be at least twice as large. Don’t strain your eyes over using this or feel like you have to put on glasses to use it. You’ll use it less frequently for every little annoyance like this. The best way to see all this is to jump in so here goes! There are a lot of features to this log so don’t be intimidated by all the description. You need very little instruction to start and the rest should be pretty intuitive once you get going. Please click here to download the Advanced Excel Running Log by Minh Tan, 2011 version 2 (2.1 MB) The file is MS Excel 2003 version for greater compatibility for people. If you use a version later than this, please do a Save As and choose the latest version so you won’t get the “compatibility” pop-up each time you close the file. Continue reading