What's mildly irritating you today?

[xoxoxoBruce]

Originally Posted by classicman

Also, the saltwater and rougher conditions (banging around) cause the manufacturer to design and protect the innards differently.

If you need a hardened one for the boat, just take the cheaper landlubber version, and give it Viagra.

[classicman]

Originally Posted by ZenGum

Haggis at Capn and Lookout.

As I understand it, the marine epirbs are different.

(1) signal strength is the same, because the signals all go directly to satellite.
(2) Marine EPIRBs (a) must work for 48 hours rather than 24 for PLBs, even after 7 years storage; (b) must float upright with the antenna clear of the water (PLBs merely have to float so you don't lose them) and (c) many come with mounting brackets, float-free release systems, and water immersion activation features. (i.e if your boat sinks, the EPIRB automatically detaches itself and starts transmitting).

And they're big and tough and go HOOO-AHHH!!!! a lot.

I was told the signal strength was different. Although upon further reflection, that doesn't make a lot of sense.
I will say this though, They do NOT automatically detach AFAIK. At least they ALL do not.

Side note, It still amazes me how many boaters go so far 70 - 100+ miles offshore without 1/2 the stuff they'd need in the event of a bad situation.

[Shawnee123]

I needed to find duplicate SSNs in an Excel spreadsheet WITHOUT having to delete the dupes (which is the only way I could find to do it within excel itself) because I need to find which ones were erroneously reported twice to the feds. There's an add-on, for which I got a free trial. I am able to just color the rows of the duplicate IDs. I love it.

NOW I need to sort these colored rows out and combine back into another spreadsheet. There's an add-on for THAT, too. No free trial.

Does anyone know if Excel 2007 (can you believe I still have Office 03 at work...sheesh) has these capabilities because if so I'm going to copy the whole damn thing to a thumb drive and work on it at home where I have software from this damn decade.

grumble grumble

[glatt]

I don't know, but my firm converted over to Office 2007 a couple months ago and it made everything slow way the hell down. Be glad you have that old software. The newer stuff is like molasses on a cold winter morning.

[Shawnee123]

Hmmm...the switchover at my old job was no problem...but I had killer computer extraordinaire when I was there.

They did upgrade my computer here, but failed to upgrade to office 07 even though "eventually" everyone should be on 07...like, when? In 3009?

grrrr grumble grumble grrrr

[SteveDallas]

Originally Posted by Shawnee123

grumble grumble

If it makes you feel better, I'm still inflicting Office 2000 on my users. (Have you seen my Wikipedia page??)

There are different ways to do this, of course. Quick & Dirty? Here's what I'd do.

1. Sort by SSN. (We'll assume they're all in the same format.)
2. You now have all the duplicates next to each other. You can look to see where they are if you only have a dozen or so records. Since I know you have a bajillion times that many, what you want to do is go to a free column over on the right and put in a formula:

   =if(a2=a3,"DUPE","")

   where column a is the column of SSNs, row 2 is the row you're typing the formula on, and row 3 is the next row down. If you auto-fill this forumla down the column, you'll end up with the word "DUPE" on every row for which the SSN matches the SSN on the following row.
3. Now you can use the Data -> Filter -> Advanced filter to copy only the records that say DUPE in your extra column to another range on the worksheet. (Simply sorting on the column won't work; that will put the SSNs out of order and make the formula you put in useless.)

P.S. I know you're aware of the security risks inherent in carrying the information out on a thumb drive . . .

[Shawnee123]

Thank you thank you thank you. That will work divinely. You rock! A simple formula, who woulda thunk? (translation: duh to me!) I tried to make it much harder than it is.

I know about the security issues, so I was hoping it didn't come to that.

[morethanpretty]

Headache, blehck.
I want to lie down, take happy pills and lie down. Can't do either. Stupid work.

[Shawnee123]

Cheer up, mtp, you only have to do it another...50 years or so.

Eh, I'm at work too, second job. I'll see your blehck and raise you a blah.

[morethanpretty]

I have fixed 4 issues on just one register so far, I'm on the 5th issue. THEY JUST KEEP POPPING UP!!! Devil REGISTER. I give this store full permission to smash it to pieces.

[Shawnee123]

Jebus. How BAD could someone have been at a job? I'm batting clean-up here, and chickie-poo who took my old job and lasted 5 months made such a mess some of it can't even be fixed.

So I'll sit here and swear at the computer.

Anyone got any good jokes?

[Shawnee123]

And about the kamikaze fly in this office *swat*

[Undertoad]

New crepes restaurant in Phoenixville is closed. We can't have anything nice around here

[Griff]

You will eat scrapple and like it.

[SteveDallas]

Originally Posted by Shawnee123

Jebus. How BAD could someone have been at a job? I'm batting clean-up here, and chickie-poo who took my old job and lasted 5 months made such a mess some of it can't even be fixed.

Wait, you're moonlighting weekends at your old job? Are they grovelling and begging you to come back? (If they are, I'd recommend smiling demurely as you inform them that your hourly rate just increased to account for the mess.)

So I'll sit here and swear at the computer.

Originally Posted by Shawnee123

Anyone got any good jokes?

A baby harp seal goes into a bar. The bartender asks what he wants.

"I don't care... whatever you have," said the seal. "As long as it's not Canadian Club.