Optoma HD70 projector flickering crazy colors, then whimpering out - just over a year old, with a brand new bulb installed 6 months ago -- tech support not very helpful. Anyone have ideas, or sympathy at least? [more inside]
posted by icetaco on Mar 30, 2009 - 3 answers

i had power go out to a portion of the house because a pump was running and pushing against water that couldnt move because ice was in the outlet pipe. i turned off the light switch and shut the pump off. i came back 4 hours later and there was no power from that switch. it was 12 degrees out. 2 days later it warmed up and all of a sudden i had power again. any ideas, i am worried
posted by blizzardm17 on Jan 3, 2009 - 11 answers

I've got an Excel spreadsheet with numbers ranging from 2,000 to 600,000. I want Excel to look at each cell and essentially categorize all of those into five categories in a new column. If the value is less than 10,000, I want Excel to give it a 1, if the value is between 10,000 and 50,000 I want it to be 2, if the value is between 50,000 and 100,000, I want it to return 3, if it's between 100,000 and 500,000, I want a 4, and if it's above 500,000, I want a 5. I tried the IF function, but I can't figure out how to a) make it recognize multiple variables, and b) I don't know how to tell it to look for numbers within a range. The Excel help section about arrays and lookups is fairly mystifying. Anyone got an idea? (I know I could sort the data and do this manually, but I'd like to learn how to do this Excel's way.) Thank you!
posted by stonefruit on Nov 9, 2006 - 14 answers