Actuarial Outpost
 
Go Back   Actuarial Outpost > Search Forums
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions

Salary Surveys
Property & Casualty, Life, Health & Pension

Health Actuary Jobs
Insurance & Consulting jobs for Students, Associates & Fellows

Actuarial Recruitment
Visit DW Simpson's website for more info.
www.dwsimpson.com/about

Casualty Jobs
Property & Casualty jobs for Students, Associates & Fellows


Showing results 1 to 25 of 55
Search took 0.11 seconds.
Search: Posts Made By: Piranha
Forum: Software & Technology 09-22-2014, 12:57 AM
Replies: 31
Views: 1,912
Posted By Piranha
You should just start your own cable company.

You should just start your own cable company.
Forum: Software & Technology 09-22-2014, 12:53 AM
Replies: 20
Views: 1,102
Posted By Piranha
Dave Barry on signs of stroke and/or heart...

Dave Barry on signs of stroke and/or heart failure:

"When certain ordinarily familiar written words begin to appear difoonable, and remulatious weedle volcranitude understand them, it's time to...
Forum: Software & Technology 09-17-2014, 03:47 PM
Replies: 27
Views: 1,343
Posted By Piranha
I think we were all confused because you said you...

I think we were all confused because you said you were using DoCmd.RunSql.

Maybe you don't have a working macro yet, but if you are as far as the above command suggests, we presumed you weren't...
Forum: Software & Technology 09-17-2014, 03:43 PM
Replies: 27
Views: 1,343
Posted By Piranha
Assuming you have a sheet that looks like this: ...

Assuming you have a sheet that looks like this:

http://i.imgur.com/tQKZdIb.png

You could use code in excel such as this:


Public Sub ForGodsSakeDoSomethingDammit()

'if any of these dim...
Forum: Software & Technology 09-17-2014, 03:05 PM
Replies: 27
Views: 1,343
Posted By Piranha
Ok, so it's an excel macro then? Are you...

Ok, so it's an excel macro then?

Are you getting an "object doesn't support this property or method"? I don't think DoCmd returns an object, rather it can execute a sql statement, but it's really...
Forum: Software & Technology 09-16-2014, 07:07 PM
Replies: 22
Views: 1,842
Posted By Piranha
I usually use ctrl-g for that, and it's only...

I usually use ctrl-g for that, and it's only useful for named cells or ranges to me.
Forum: Software & Technology 09-15-2014, 07:08 PM
Replies: 22
Views: 1,842
Posted By Piranha
I don't recall ever seeing the colored boxes on...

I don't recall ever seeing the colored boxes on tabs other than the tab containing the cell whose formula I'm editing.

I concur with Roger_TIA to disable editing cells directly in formula. It's...
Forum: Software & Technology 09-15-2014, 03:39 PM
Replies: 25
Views: 2,252
Posted By Piranha
Not that this is necessarily a coders nightmare,...

Not that this is necessarily a coders nightmare, but its related to the second response, where there's no answers to the very question your asking that was posted two years ago or more.

I am...
Forum: Software & Technology 06-25-2014, 01:07 PM
Replies: 4
Views: 502
Posted By Piranha
I suppose you could use a more helpful response...

I suppose you could use a more helpful response though. There are third party query tools which may not provide you with the explain utility, but at least give you a nimble query editing environment...
Forum: Software & Technology 06-25-2014, 12:50 PM
Replies: 4
Views: 502
Posted By Piranha
DB2 has something called "Control Center". It's...

DB2 has something called "Control Center". It's terrible. Actually it's worse than terrible.

IBM made a strategic decision back in 1991 that it if they had to ingratiatingly make GUI interfaces,...
Forum: Long-Term Actuarial Math 08-29-2013, 03:07 PM
Replies: 17
Views: 2,044
Posted By Piranha
I can down a few beers in 15 minutes.

I can down a few beers in 15 minutes.
Forum: Investment / Financial Markets 07-17-2013, 06:17 PM
Replies: 156
Views: 19,568
Posted By Piranha
I just passed the exam about an hour ago. I also...

I just passed the exam about an hour ago. I also had repeated failures and wasn't able to sit for it a couple of times, so the timeframe devoted to this exam for me was absurdly long.

I'm an old...
Forum: Software & Technology 01-31-2013, 06:49 PM
Replies: 94
Views: 15,185
Posted By Piranha
I also tend to use the regular hotkeys for...

I also tend to use the regular hotkeys for formatting and navigation. Switching to 2010 (from 2000) has been painful.

I do have a personal.xlsb with something geekier, though: I have a library...
Forum: Investment / Financial Markets 10-18-2012, 11:37 AM
Replies: 5
Views: 1,277
Posted By Piranha
Made my day!

Made my day!
Forum: Software & Technology 08-07-2012, 11:18 AM
Replies: 808
Views: 142,501
Posted By Piranha
No. NO. ...

No.

NO.

NOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO!
Forum: Software & Technology 02-09-2012, 07:00 PM
Replies: 100
Views: 9,168
Posted By Piranha
Just read this whole thread. It was very...

Just read this whole thread. It was very cathartic for me.

Right now we're converting from 2003 to 2010. I'm surprised that we didn't have to make many changes macros in excel or access, but...
Forum: Non-Actuarial Topics 02-02-2012, 10:48 AM
Replies: 27
Views: 1,519
Posted By Piranha
rn

rn
Forum: Non-Actuarial Topics 02-02-2012, 03:17 AM
Replies: 56
Views: 2,501
Posted By Piranha
Is that code for watching Downton Abbey? If...

Is that code for watching Downton Abbey?

If it weren't for the good company we'll have, I would give Pats vs. Giants a miss.
Forum: Software & Technology 01-18-2012, 01:51 PM
Replies: 21
Views: 1,652
Posted By Piranha
Can't we just let supply and demand determine the...

Can't we just let supply and demand determine the price? Like by making it so that the internet only has so many letter "J"s today?

The internet killed the library star.
Forum: Investment / Financial Markets 01-17-2012, 01:08 PM
Replies: 4
Views: 1,190
Posted By Piranha
Looks like it just opened up.

Looks like it just opened up.
Forum: Software & Technology 01-10-2012, 03:49 PM
Replies: 14
Views: 1,057
Posted By Piranha
In SQL you use a HAVING clause. SELECT...

In SQL you use a HAVING clause.

SELECT GroupIndex, SUM(Loss) AS TotalLoss
FROM YourTable
GROUP BY GroupIndex
HAVING SUM(Loss) < 1000

The HAVING clause performs the filter after the group by...
Forum: Software & Technology 01-09-2012, 05:50 PM
Replies: 14
Views: 1,057
Posted By Piranha
You'd probably want to add [at least] a column to...

You'd probably want to add [at least] a column to the target table, containing a substring of the claim ID or a generated grouping "key" that allows you to group one way or another in subsequent...
Forum: Software & Technology 04-26-2011, 04:13 PM
Replies: 11
Views: 1,275
Posted By Piranha
Printers are just bad. My wife and kids always...

Printers are just bad. My wife and kids always need to print cr@p. I can't understand why they don't just memorize recipes, news articles, and 20 page wikipedia entries.

Don't get me started on...
Forum: Software & Technology 04-26-2011, 01:49 PM
Replies: 11
Views: 1,275
Posted By Piranha
Thanks for hearing my petty gripe about the...

Thanks for hearing my petty gripe about the startup "gonkulations".

Thank you also for prompting my further ventilation - their "bloatware" is the worst! To me a printer should provide no more...
Forum: Software & Technology 04-26-2011, 01:58 AM
Replies: 11
Views: 1,275
Posted By Piranha
My HP 3-in-1

No problems here. Nothing to troubleshoot.

But, upon being turned on, my HP printer sounds like the everlasting gobstopper making machine from the Willy Wonka factory.

It does this for at...
Showing results 1 to 25 of 55

 

All times are GMT -4. The time now is 06:37 PM.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.34093 seconds with 7 queries