Excel question: Can I enter just a 1-31 value into one cell and have a complete date appear in a different cell based on fixed month and year values? [more inside]
Has anyone found a reliable source for Lego Technic Power Functions builds? [more inside]
Is there an off-the-shelf MSExcel function or 2.0 tool that will allow me to "return" a US City/State based on 5-digit US postal codes. I have 160 postal code queries to perform. The postal code data is in MSExcel. Something like this. I do not have MSAccess and I am a Mac user.
I'm looking for brilliant metaphors to explain the ins and outs of object-oriented programming. Know any? [more inside]
I need help disabling php.ini functions using SSH (putty) on my dedicated server. [more inside]
Programmers: know any good algorithms for picking colors, modifying colors or choosing colors that go well together? This is specifically for code. I'm NOT looking for apps that let you choose colors. [more inside]
At my gmail sign-on using Firefox, I could type the first initial in my email name and it would drop down where I could click on my email name and automatically insert it (then password). It stopped doing that and I have been messing with Firefox autofill and that seems mainly for filling out forms. Yes, I am sure this is an easy thing for someone (me) to fix but for some reason it is stumping me. My wife and I liked the utter simplicity on our home computer of this function. Can you help? Merry Christmas/Happy Holidays to all MeFi users
How do I store a string in one cell in Excel and interpret it as a (or for a) function in another cell? More info inside. [more inside]
I listened in on an engineering design lecture a few days ago, and was fascinated to find out that there are apparently databases out there that contain all the different ways some common functions can be accomplished - for example, getting liquid out of a cup. What are these databases called and where can I find them?
Question about functions. Probably pretty easy for those who know something about math. [more inside]
Why am I pooping SO MUCH all of a sudden? Diet, exercise, and general lifestyle have remained constant. Grossness inside. [more inside]
What are the secrets to the efficient coding of my Wordpress core file using functions.php? Oh, and by the way, I'm a PHP idiot! [more inside]
Sum of data for all months, including months with no rows, in MySQL? [more inside]
Why is it that when I solve the inequality 0 ≤ arccos(x) <> cos(π/4)? Why do the operators switch direction?> [more inside]
Excel Filter: Concatenating fields through VLOOKUP. Is it possible? What I'm trying to accomplish inside... [more inside]
MS Excel: How do I convert a number representing seconds into minutes:seconds? [more inside]
Help me teach people how to program: I need simple examples of functions, classes, etc. [more inside]
What are some of the coolest, oddest, or most unusual uses you've come up with for your personal computer?