There has to be a way that I can track my mileage in Excel. [more inside]
I need a bike commuting jacket. I love love love this one from Betabrand BUT IT DOESN'T SHIP TIL JANUARY WHAT. Help me find an alternative to survive fall/winter in DC. [more inside]
I'm a person who excels very well in jobs and make great first impressions. However, a problem that has plagued me all my life is forgetting ONE detail that might seem small but very important. [more inside]
I am developing a sales lead sheet. I have on the B column a drop down list for the sales status (complete, no sale, and follow up). On the A column I have a dollar amount for the sales lead. Originally, I used the SUMIF function to add only the "follow up" figures referenced from Column B to track the dollar amount of outstanding leads. I then thought to convert my sheet into a table to make sorting easier, but now the SUMIF function is returning a value of zero. What did I miss? Thanks much!
Blogs devoted to objects, fascinating and everyday? [more inside]
How do I get better at managing multiple social cues? [more inside]
Need help with (possibly?) "indirect" in Excel. [more inside]
What does a bivariate cubic polynomial look like? [more inside]
Where should you put the space in function defs/callls in C-like languages? [more inside]
What is the purpose of the dome on this vending machine? [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]
Is there any ground breaking hope for a pre-teen who was born with mental retardation due to the umbilical cord wrapped tight around the neck while in the womb (restricting blood flow to the brain)? [more inside]
I've got a long function with two variables, encoding - I suspect - a hidden message. Most likely, the message is somehow encoded in the function's roots. Is there any good software to plot a function in two dimensions and only show the points where it evaluates to zero? [more inside]
What do we absolutely need? [more inside]
I have: An excel spreadsheet with a bunch of emails. I need: A self-updating text string that can be copy-pasted into an email TO: Field. I know about C1&","&D1 but is there a way for the list to be automatically updated when I or subtract an email, without specifically having to tell the formula to look in the newly added row? [more inside]
Excel filter: Is there a simple way to iterate through all pairs in a list, perform a calculation on each pair, and sum the result? [more inside]
whatever happened to the "earlier auctions" function on ebay? can't seem to find it.
What software can I use to plot functions? Excel and matplotlib seem to only plot data points. gnuplot plots simple functions but not the generalized harmonic number, which I need, e.g., H(n,1.5). It would be great if this software can also plot inverse functions, e.g. x=f(y) on a normal x-y axis to overlay on a normal y=f(x) plot.
SharePoint CQWP: How on earth can I use today's date to compare to another field in a calculated column or filter in SharePoint? [more inside]
How do you animate a parameter in the OSX Grapher utility? [more inside]
In Excel, how do I calculate the average of every 300 data points in a large data set? [more inside]
Trying to get some modified AVERAGE results in Excel. [more inside]
Since upgrading to the latest Firefox (3.51?) the Session Restore feature which restores windows, tabs has NEVER worked. I get a white screen which says how embarrassing it is my previous session can't be restored. I'd just like to start every session as a new one, it would save a lot of time, but can't figure out how to avoid the restore function. The Mozilla/Firefox support site is so dense and discombobulated I can't find anything helpful there. Any suggestions?
Where to host 90th birthday party for 30 people near Providence, RI? [more inside]
Please recommend some sites to me that are focused on art and design and are technology-friendly to boot. [more inside]
I am trying to partially automate a tedious list comparison procedure, I think I should be able to do it through excel without any coding (which I don't know how to do) [more inside]
Basic Mathematical NameFilter: Name This Sequence [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?
Can you identify the function of this mysterious jade object? [more inside]
Statistics Filter: Finding the top 10% from thousands of data points. Bonus question: inflection point value.
Statistics Filter: Finding the top 10% from thousands of data points. Bonus question: inflection point value. [more inside]
Is there a differentiable function f(x) such that the derivative is nowhere continuous? That is, f'(x) has no point of continuity? [more inside]
Within cell C2, If the content of a cell in $A$10:$A$900 is the same as the content in A2, I would like Excel to Average the contents of column H in the rows that match A2...does that even make sense? [more inside]
Why are sine waves considered "pure" tones? Why do we consider sinusoids the building blocks of periodic functions? [more inside]
Why do mathematicians (and/or programmers) describe information passed to a function as an 'argument'? [more inside]
Excel: How can I get text to stick in the cells after it's been copied from another spreadsheet? [more inside]
I need help writing a macro that will divide a 5000 row table into groups of 30 rows, and find the average of certain columns in each group. [more inside]
Excel question: How to define a range so that it always adds up to a constant value. [more inside]
Excel question: I'm looking to pull a months and years worth of spreadsheet information to a summary report. The days work is saved as reportxxxxxx (month/day/year) [more inside]
Help! Stumped by an SQL problem. [more inside]
I'm looking for examples that turn the aphorism "form follows function" on its head. The idea that functions can be inspired by new forms. [more inside]
Programming/geometry: in a Flash program (you don't need to know Flash to answer this), I'm trying to place rectangular images at random positions on the screen. There are already images on the screen. I need to make sure that the new, randomly-placed images don't obscure the images already there. [more inside]
Why does bandwidth cost anything? Short of hosting companies finding a means to make some money, what is the actual cost justification on charging for overages, etc? Is it a racket or does traffic actually put an expense on an ISP forcing them, in turn, to charge customers? Always wondered. Thanks.
All of the towels in my house have a stitched patter a couple inches from the vertical end. Anyone have any idea where this came from, or what the function is? [MI] [more inside]