![]() |
|
|
FlashChat | Actuarial Discussion | Preliminary Exams | CAS/SOA Exams | Cyberchat | Around the World | Suggestions |
|
![]() |
|
Thread Tools | Search this Thread | Display Modes |
#11
|
|||
|
|||
![]() 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. |
#14
|
|||
|
|||
![]() 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 |
#16
|
|||
|
|||
![]()
__________________
John 3:16 |
#17
|
|||
|
|||
![]() 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 |
#18
|
|||
|
|||
![]() Quote:
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. |
#19
|
||||
|
||||
![]() Quote:
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. |
#20
|
||||
|
||||
![]() 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 |
![]() |
Tags |
machine learning, predictive analytics, speadsheet error, spreadsheets |
Thread Tools | Search this Thread |
Display Modes | |
|
|