Blog
Concatenating A Range In Excel
One of the things that Excel is missing is a way of joining a range of cell values with a common delimiter such as a comma. Here is an example of a range of cells that would be nice to Read more…
Blog
Understanding Cell References In Excel
One of the commonly misunderstood things about using formulas within Excel is writing cell references. By this, I mean, many people don’t know when to and when not to use the dollar sign before a column name or row number. Read more…
Blog
Using COUNTIF In Excel
Why would you use the COUNTIF function? This is a question that you may wonder at times. First of all, you could use it to figure out how many cells in a range match the specified criteria. You could also Read more…
Blog
Forcing A Constructor In JavaScript
Did you know that you can force a function to only act as a constructor? The following is an example of a Person pseudo-class which can be defined with or without the new keyword: One of the things that you Read more…
Blog
POW – Quick Escape
This is the first of a new series of posts called the “Problem of the Week” (POW). As is evidenced by the title, these problems will be posted weekly. Every Sunday, I will post the answer to the previous week’s Read more…
Blog
Divisibility Rules for 11 and 12
On Wednesday I explained how to determine if a number is divisible by 3, 6, and/or 9. I also posted a comment with a link to rules for 2, 3, 4, 5, 6, 7, 8, 9, and 10. Therefore, I Read more…
Blog
View Saved Password
In different browsers, there are different ways to view saved passwords. If you don’t know how to do it in your password, and you are fortunate enough to find this page š , you could you simply do the following: Read more…
Blog
Divisibility By Three, Six & Nine
When people say that being able to do simple math is what counts the most, they may not be far off. Did you know that as long as you can add, you can look at any number and tell whether Read more…
Blog
Solid Type Checking Functions
Now Available in YourJS John Resig definitely has some awesome code inside of jQuery. One of the things that I think is cool is how jQuery does type checking. After looking through the code, I developed my own flavor of Read more…
Blog
Function Overloading in JavaScript
Method overloading is one of the nice things that exists in real programming languages such as Java. Even though JavaScript starts with “Java”, there are very few similarities between the two languages. Still, due to the power of the scripting Read more…