image
 
image
Excel-Based Apps


Excel-Based Applications
These applications are Excel-based, meaning I built them to run in Microsoft Excel in order to take advantage of Excel's user interface features and/or its built-in computational capabilities. Therefore, to use them, you must have Excel installed on your computer.

In all cases, these Excel-based applications utilize the Excel programming model known as VBA to create the applications' functionalities. Consequently, to run any of these applications, you must configure Excel on your computer (via Excel's "Options") to allow the VBA programming code to run. You can find the instructions for how to do this configuration if you click here.

Personality Type Identifier
This application is a psychometric questionnaire designed to measure psychological preferences in how you perceive the world and make decisions. Psychometrics is the field of study concerned with the theory and technique of psychological measurement, which includes the measurement of knowledge, abilities, attitudes, personality traits, and educational measurement.

This self-assessed personality questionnaire is designed to help you better understand yourself. It is inspired primarily by The Keirsey Temperament Sorter (KTS), which is in turn closely associated with the Myers-Briggs Type Indicator (MBTI). KTS and MBTI are both currently being used by the Fortune 500, Global 1000, the US Government and Military, by major academic institutions, non-profit organizations, and faith based organizations worldwide to help them leverage the best strengths of their people. Additionally, the American Management Association reports that nearly 40 percent of companies surveyed use personality testing as part of their hiring process.

This application attempts to more accurately identify your personality type than other tests do. It does this by providing an enhanced question set and by using a unique scoring method to better capture nuanced responses than the KTS or MBTI either/or scoring methods. The application provides multiple options for the question set. You can choose to use any one of three variations of the KTS question set, the Montgomery Shorter Sorter questions, the Robinson-Shur Type Indicator questions, or a "HiRes" set that combines questions from each the other sets.

Based on your answers to the questionnaire, the application assigns one of 16 four-letter type codes to you. These are the same codes as are produced by either KTS or MBTI and they are used to reveal your temperament and character type.

Color Tool
This application is a color tool that simplifies correlating disparate color representations, picking colors and copy/pasting their CSS, hexadecimal, and decimal encodings. The tool specializes in conversions between the three RGB color representations: RGB, HSL, and HSV. It also does color harmonization for you based on the current color selection. Among other uses, it is handy for picking colors and pasting their numbers into your CSS or HTML code or copying the numbers from your code and pasting into the tool to see what the color is and to find colors harmonious with it.

Color design often involves switching among several color and graphics tools to address different aspects of the design. It is very common for each different tool to use a different combination of color representation and scaling factors. In addition to the RGB, HSL, HSV representations, any number of different scales for each color component are in use. Hues can be measured from 0 to 1, from 0 to 100, from 0 to 240, from 0 to 255, from 0 to 360 or anything else. This application supports ranges of from zero to any integer number. The same is true for saturation, luminosity, value, red, green, and blue. Converting manually from one tool's representation to another's to get the same color is a clunky and time consuming nuisance. This application does the conversions for you.

You pick a color and the tool displays the selected color as a color patch as well as in decimal and hexadecimal numbers in each of the representations using your choice of scaling factors. You can change from one representation to another and all your input values are automatically transformed to the new representation. You can change your scaling factors to anything you want at any time and all the numbers are automatically rescaled. You can change your number representation back and forth between decimal and hexadecimal and all the numbers are automatically converted. When you click on any number - and with no additional keystrokes, the tool copies the number to the Windows clipboard from which you can paste anywhere into this application or into any other Windows application.

You can choose a color using your eyedropper tool, the Excel color picker, a set of color buttons, an HTML-formatted RGB word, a Windows-formatted RGB word, or by entering each of the three component values - R, G, and B or H, S, and L or H, S, and V. You can enter the numbers in either hex or decimal.

When you select a color using any of those methods, the tool will set all the representations and numbers for that color and will generate color harmonies based on the selected color. The harmonies include Split Compliments, Triads, Rectangular Tetrads, Square Tetrads, and Analogous Colors. Multiple instances of each harmony are generated. The selected color anchors one instance of each harmony. Additional colors spaced at equal intervals around the color circle from the selected color anchor the other instances of each harmony.

In addition to the features listed above, the tool finds a font color to go with your selected color . It keeps track of the sixteen most recently selected unique colors as clickable, colored buttons. It provides the NCS primary colors in a button palette and it includes color circles illustrating the color harmony patterns. For convenient use with the eyedropper tool , it provides separate tabs (sheets or pages in the Excel workbook) containing color picker images as well as the complete W3C CSS color table with names and values.

Starting Salary Modeler
This application is a modeling tool that allows you to "try out" different starting salary scenarios to see the effect of each on both you and your new employer. Its aim is to help you identify a starting salary and a corresponding set of other assumptions that results in the fairest possible return of value to both sides in a salary negotiation.

Possibly, the most difficult thing about a job search is figuring out what a fair starting salary will be for a particular job. Job postings sometimes specify a salary or a salary range for the job. During the interview process, the employer will usually ask you what salary you expect. The job offer will almost certainly specify a salary. How do you know what salary is fair to both you and to the employer? This Excel application uses facts, data, and graphical analysis to help you find the answer.

Multiple variables are in play simultaneously when considering what a fair salary is and that is what makes it difficult. You and the employer may make different assumptions about the initial values of these variables and how they change over time. Some of the variables involved are:
=> The dollar value to the employer of different levels of job mastery,
=> The initial level of mastery you can bring to the job on day one,
=> The time it will take you to go from your initial level of mastery to full job mastery,
=> The size of the annual raises, as a percentage, that you can reasonably expect from the employer as your mastery of the job increases,
=> The amount of time you would be content to stay in the job before wanting to move on to something else.
This Excel application uses all these variables to depict graphically the effect of a proposed starting salary in a way that makes it immediately apparent if it is fair to both you and the employer.