

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 multipaste 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.
__________________
"Facebook is a toilet."  LWTwJO 
#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 peerreviewed the OP's link yet, so I'll see if there's anything interesting in it a bit later.
__________________
"Facebook is a toilet."  LWTwJO 
#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  

