Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions


Reply
 
Thread Tools Display Modes
  #11  
Old 04-11-2007, 01:10 PM
Dr T Non-Fan Dr T Non-Fan is offline
Member
SOA AAA
 
Join Date: Sep 2001
Location: Just outside of Nowhere
Posts: 88,527
Default

When I copy and multi-paste a formula, I expect it to paste the same relative formula all the way down. I don't see how it could get pasted incorrectly. Of course, I'm usually perfect, in every way.

One formula that does deserve some scrutiny is "OFFSET". Even when hitting F2, this formula doesn't show (in different colors) which cells are actually being computed. Checking the formula's result with the specific range that is intended to be calculated (be it averaged or summarized) is paramount.
__________________
DTNF's Basic Philosophy Regarding Posting: There's no emoticon for what I'm feeling! -- Jeff Albertson (CBG)
DTNF's Trademarked Standard Career Advice: "pass some exams and get back to us."
DTNF's Major advice: "Doesn't matter. Choose major that helps you with goal of Career Advice."
DTNF's Résumé Advice: Have a good and interesting answer to every item on it for the interviews.
DTNF's Law of Job Offers: You not only have to qualify for the position, but you also have to be the best candidate available for the offer.
DTNF's Work Philosophy: I am actuary. Please insert data. -- Actuary Actuarying Rodriguez.
Twitches' Advice to Crazy Women: Please just go buy your 30 cats already.
Reply With Quote
  #12  
Old 04-11-2007, 01:26 PM
whisper's Avatar
whisper whisper is offline
Member
CAS AAA
 
Join Date: Jan 2002
Location: Chicago
Favorite beer: Hefewizen
Posts: 34,154
Default

Quote:
Originally Posted by Dr T Non-Fan View Post
When I copy and multi-paste a formula, I expect it to paste the same relative formula all the way down. I don't see how it could get pasted incorrectly. Of course, I'm usually perfect, in every way.
Its not a question of did the formula get entered correctly. Its more of a question of alterations in a spread sheet after the formula entry has made the values different.
Reply With Quote
  #13  
Old 04-11-2007, 02:46 PM
dumples dumples is offline
Member
CAS
 
Join Date: Sep 2003
Posts: 1,244
Default

Quote:
Originally Posted by whisper View Post
Its not a question of did the formula get entered correctly. Its more of a question of alterations in a spread sheet after the formula entry has made the values different.
Or when you have the pleasure of working on someone else's files.
Reply With Quote
  #14  
Old 04-11-2007, 04:43 PM
Expunge Expunge is offline
Member
 
Join Date: Jul 2003
Posts: 9,181
Default

wrt R1C1 vs A1, I'm going with his "Break the rules" statement on Page 11. The unfamiliarity with r1c1, and the visual style of it (ie. the [ ] + -) that goes with it, makes it more difficult to determine what a formula is doing how many ranges make up the formula etc.

anyways... On Page 9 in talks about common errors, and in the paragraph it says "...as long as you construct the range names automatically." How does one construct range names automatically?
__________________
John 3:16
Reply With Quote
  #15  
Old 04-11-2007, 04:46 PM
BassFreq's Avatar
BassFreq BassFreq is offline
Member
CAS
 
Join Date: Jun 2003
Location: Chicago
Studying for all eternity
Favorite beer: Duff
Posts: 1,686
Blog Entries: 2
Default

Insert>Name>Create
__________________
If at first you don't succeed, you have one data point.
Res ipsa loquitur, sed quid in infernos dicet?
Reply With Quote
  #16  
Old 04-11-2007, 04:47 PM
Expunge Expunge is offline
Member
 
Join Date: Jul 2003
Posts: 9,181
Default

Quote:
Originally Posted by BassFreq View Post
Insert>Name>Create
That doesn't seem so "automatic" to me.
__________________
John 3:16
Reply With Quote
  #17  
Old 04-11-2007, 04:55 PM
Expunge Expunge is offline
Member
 
Join Date: Jul 2003
Posts: 9,181
Default

Quote:
Originally Posted by Expunge View Post
That doesn't seem so "automatic" to me.
Oh, you can name multiple rows/columns at once, I guess thats quicker than what i was doing "editing in that dropdown box just above the top left cell"
Still I usually have a blank row between the label and first data point, although as long as that stays empty, it should still work most of the time.
__________________
John 3:16
Reply With Quote
  #18  
Old 04-11-2007, 05:03 PM
Dr T Non-Fan Dr T Non-Fan is offline
Member
SOA AAA
 
Join Date: Sep 2001
Location: Just outside of Nowhere
Posts: 88,527
Default

Quote:
Originally Posted by dumples View Post
Or when you have the pleasure of working on someone else's files.
This is probably more like it. There are such ranges of knowledge available in the distribution curves that if I get the "pleasure" of peer-reviewing someone's work (or even checking a source that I must use), I've found that the farther away they are from my knowledge base (either more or less -- I consider myself slightly more than average, based on a spreadsheet that I keep such information on), the more difficult it is to proofread their files.

I haven't peer-reviewed the OP's link yet, so I'll see if there's anything interesting in it a bit later.
__________________
DTNF's Basic Philosophy Regarding Posting: There's no emoticon for what I'm feeling! -- Jeff Albertson (CBG)
DTNF's Trademarked Standard Career Advice: "pass some exams and get back to us."
DTNF's Major advice: "Doesn't matter. Choose major that helps you with goal of Career Advice."
DTNF's Résumé Advice: Have a good and interesting answer to every item on it for the interviews.
DTNF's Law of Job Offers: You not only have to qualify for the position, but you also have to be the best candidate available for the offer.
DTNF's Work Philosophy: I am actuary. Please insert data. -- Actuary Actuarying Rodriguez.
Twitches' Advice to Crazy Women: Please just go buy your 30 cats already.
Reply With Quote
  #19  
Old 04-11-2007, 06:16 PM
whisper's Avatar
whisper whisper is offline
Member
CAS AAA
 
Join Date: Jan 2002
Location: Chicago
Favorite beer: Hefewizen
Posts: 34,154
Default

Quote:
Originally Posted by Expunge View Post
wrt R1C1 vs A1, I'm going with his "Break the rules" statement on Page 11. The unfamiliarity with r1c1, and the visual style of it (ie. the [ ] + -) that goes with it, makes it more difficult to determine what a formula is doing how many ranges make up the formula etc.

You can easily mix and match views. If you need to make sure a formula is correct - you can use the A1 format to understand what the formula is. If you need to check that the formulas are consistent, you can use the R1C1 format to easily check for consistency.
Reply With Quote
  #20  
Old 09-14-2007, 03:45 PM
campbell's Avatar
campbell campbell is offline
Mary Pat Campbell
SOA AAA
 
Join Date: Nov 2003
Location: NY
Studying for duolingo and coursera
Favorite beer: Murphy's Irish Stout
Posts: 79,748
Blog Entries: 6
Default

More links on spreadsheet errors, error rates, and the preventing thereof:
Block that Spreadsheet Error

Preventing Spreadsheet Problems

Methodology for the Audit of Spreadsheet Models

For fun, spreadsheet error horror stories
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
Reply

Tags
machine learning, predictive analytics, speadsheet error, spreadsheets

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


All times are GMT -4. The time now is 04:38 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, 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.22321 seconds with 10 queries