The Cellar  

Go Back   The Cellar > Main > Nothingland

Nothingland Something about nothing - game threads, diversions, time-wasters

Reply
 
Thread Tools Display Modes
Old 09-25-2009, 02:32 AM   #1966
xoxoxoBruce
The future is unwritten
 
Join Date: Oct 2002
Posts: 71,105
Quote:
Originally Posted by classicman View Post
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.
__________________
The descent of man ~ Nixon, Friedman, Reagan, Trump.
xoxoxoBruce is offline   Reply With Quote
Old 09-25-2009, 09:02 AM   #1967
classicman
barely disguised asshole, keeper of all that is holy.
 
Join Date: Nov 2007
Posts: 23,401
Quote:
Originally Posted by ZenGum View Post
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.
__________________
"like strapping a pillow on a bull in a china shop" Bullitt
classicman is offline   Reply With Quote
Old 09-25-2009, 01:30 PM   #1968
Shawnee123
Why, you're a regular Alfred E Einstein, ain't ya?
 
Join Date: Jun 2006
Posts: 21,206
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
__________________
A word to the wise ain't necessary - it's the stupid ones who need the advice.
--Bill Cosby
Shawnee123 is offline   Reply With Quote
Old 09-25-2009, 01:36 PM   #1969
glatt
 
Join Date: Jul 2003
Location: Arlington, VA
Posts: 27,717
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.
glatt is offline   Reply With Quote
Old 09-25-2009, 01:44 PM   #1970
Shawnee123
Why, you're a regular Alfred E Einstein, ain't ya?
 
Join Date: Jun 2006
Posts: 21,206
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
__________________
A word to the wise ain't necessary - it's the stupid ones who need the advice.
--Bill Cosby
Shawnee123 is offline   Reply With Quote
Old 09-25-2009, 02:58 PM   #1971
SteveDallas
Your Bartender
 
Join Date: Jan 2002
Location: Philly Burbs, PA
Posts: 7,651
Quote:
Originally Posted by Shawnee123 View Post
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:
    Code:
    =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 . . .
SteveDallas is offline   Reply With Quote
Old 09-25-2009, 03:04 PM   #1972
Shawnee123
Why, you're a regular Alfred E Einstein, ain't ya?
 
Join Date: Jun 2006
Posts: 21,206
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.
__________________
A word to the wise ain't necessary - it's the stupid ones who need the advice.
--Bill Cosby
Shawnee123 is offline   Reply With Quote
Old 09-26-2009, 09:12 AM   #1973
morethanpretty
Thats "Miss Zipper Neck" to you.
 
Join Date: Sep 2006
Location: little town (but not the littlest) in texas
Posts: 2,957
Headache, blehck.
I want to lie down, take happy pills and lie down. Can't do either. Stupid work.
__________________
Addicts may suck dick for coke, but love came up with the idea to put a dick in there to begin with.
-Jack O'Brien
morethanpretty is offline   Reply With Quote
Old 09-26-2009, 09:23 AM   #1974
Shawnee123
Why, you're a regular Alfred E Einstein, ain't ya?
 
Join Date: Jun 2006
Posts: 21,206
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.
__________________
A word to the wise ain't necessary - it's the stupid ones who need the advice.
--Bill Cosby
Shawnee123 is offline   Reply With Quote
Old 09-26-2009, 09:46 AM   #1975
morethanpretty
Thats "Miss Zipper Neck" to you.
 
Join Date: Sep 2006
Location: little town (but not the littlest) in texas
Posts: 2,957
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.
__________________
Addicts may suck dick for coke, but love came up with the idea to put a dick in there to begin with.
-Jack O'Brien
morethanpretty is offline   Reply With Quote
Old 09-26-2009, 10:26 AM   #1976
Shawnee123
Why, you're a regular Alfred E Einstein, ain't ya?
 
Join Date: Jun 2006
Posts: 21,206
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?
__________________
A word to the wise ain't necessary - it's the stupid ones who need the advice.
--Bill Cosby
Shawnee123 is offline   Reply With Quote
Old 09-26-2009, 11:13 AM   #1977
Shawnee123
Why, you're a regular Alfred E Einstein, ain't ya?
 
Join Date: Jun 2006
Posts: 21,206
And about the kamikaze fly in this office *swat*
__________________
A word to the wise ain't necessary - it's the stupid ones who need the advice.
--Bill Cosby
Shawnee123 is offline   Reply With Quote
Old 09-26-2009, 12:21 PM   #1978
Undertoad
Radical Centrist
 
Join Date: Jan 2001
Location: Cottage of Prussia
Posts: 31,423
New crepes restaurant in Phoenixville is closed. We can't have anything nice around here
Undertoad is offline   Reply With Quote
Old 09-26-2009, 12:31 PM   #1979
Griff
still says videotape
 
Join Date: Feb 2001
Posts: 26,813
You will eat scrapple and like it.
__________________
If you would only recognize that life is hard, things would be so much easier for you.
- Louis D. Brandeis
Griff is offline   Reply With Quote
Old 09-26-2009, 03:57 PM   #1980
SteveDallas
Your Bartender
 
Join Date: Jan 2002
Location: Philly Burbs, PA
Posts: 7,651
Quote:
Originally Posted by Shawnee123 View Post
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.

Quote:
Originally Posted by Shawnee123 View Post
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.
SteveDallas is offline   Reply With Quote
Reply

Tags
mild cheddar


Currently Active Users Viewing This Thread: 19 (0 members and 19 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT -5. The time now is 11:37 AM.


Powered by: vBulletin Version 3.8.1
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.