Zoe: Nobody's saying that, sir. Wash: Yeah, we're pretty much just giving each other significant glances and laughing incessantly.

'Our Mrs. Reynolds'


Buffistechnology 3: "Press Some Buttons, See What Happens."

Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!


Lee - Jun 22, 2009 7:51:24 pm PDT #10528 of 25501
The feeling you get when your brain finally lets your heart get in its pants.

Does anyone have a rec for underwater cameras?


omnis_audis - Jun 22, 2009 11:20:39 pm PDT #10529 of 25501
omnis, pursue. That's an order from a shy woman who can use M-16. - Shir

I seem to recall some rather inexpensive contraptions that let your current camera become an underwater camera. I think it was REI, not positive. Or how good they work. They are like double bubbles, so if the first layer starts to leak, you still have the 2nd layer to keep it protected. Not sure how deep they went. Just an idea if you want to go that route, you can research it.


flea - Jun 23, 2009 2:30:48 am PDT #10530 of 25501
information libertarian

I read this as "underwear cameras." I think I need more coffee.


Gudanov - Jun 23, 2009 4:38:39 am PDT #10531 of 25501
Coding and Sleeping

I read this as "underwear cameras."

Now there's a Flickr photostream I never want to see.


brenda m - Jun 23, 2009 6:18:35 am PDT #10532 of 25501
If you're going through hell/keep on going/don't slow down/keep your fear from showing/you might be gone/'fore the devil even knows you're there

Excel question - if someone set up a workbook and spaced all their content by including an extra row between each item, is there a simple way to get rid of those empty rows other than deleting one by one?


tommyrot - Jun 23, 2009 6:20:49 am PDT #10533 of 25501
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.

Can you do a sort (forcing all the spaces to either the beginning or end)?


brenda m - Jun 23, 2009 6:26:52 am PDT #10534 of 25501
If you're going through hell/keep on going/don't slow down/keep your fear from showing/you might be gone/'fore the devil even knows you're there

The cells with actual input don't follow any sortable pattern so I think I'd end up with a bigger mess than I have, unfortunately. Maybe I'll play with that a little and see if I can figure out a workaround.


Kristen - Jun 23, 2009 7:03:41 am PDT #10535 of 25501

Excel question - if someone set up a workbook and spaced all their content by including an extra row between each item, is there a simple way to get rid of those empty rows other than deleting one by one?

You can select multiple rows by holding down CTRL as you click the start of each blank row. Then you can delete them all at once.

Or, depending on what you're doing with the spreadsheet, you could cheat. Turn on Filter and filter out the blanks.

ETA: I also have a solution that involves IF statements, if you need it.


Jon B. - Jun 23, 2009 7:15:40 am PDT #10536 of 25501
A turkey in every toilet -- only in America!

Or, create a new column with a formula like (assume this example is in row 3): =if(a3="","",row(a3)) That'll put the row number in all rows that aren't blank. Copy/Paste Value this column, then sort by it. That'll keep the order the same, but put all the blanks together.


Typo Boy - Jun 23, 2009 9:01:52 am PDT #10537 of 25501
Calli: My people have a saying. A man who trusts can never be betrayed, only mistaken.Avon: Life expectancy among your people must be extremely short.

John McGrath, an email acquaintence who posts on Dymaxion Blog and who is one of the good guys (and who really ought to be a Buffista) has had a disasterous data loss while working a project for his masters: [link]

I'm working on a large article as my final assignment for my Master's degree, which has to date involved at least 5 hours of interviews with some pretty interesting people.

Last night I was consolidating the files scattered across three different hard drives when the USB drive I was using decided to cack out on me. I have, it seems, lost all of the recordings of my interviews.

Gun in mouth ---> pull trigger.

Man, I fucking hate computers. Anyone know a good service that can recover data from a corrupted USB drive?

If anyone wants to help him out either by commenting on the post linked, or by posting here... Cause google shows lots of data recovery services out there, and I suspect someone on this board knows who the good ones are.