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 Search this Thread Display Modes
  #121  
Old 04-29-2010, 04:08 PM
Nobody22's Avatar
Nobody22 Nobody22 is offline
Member
 
Join Date: Oct 2008
Posts: 766
Default


2007 żupgrade? THIS IS WORSE!
__________________
VEEs | P FM MFE L C | CA1 CA2 | 5 6 | 7 8 9

Correlation doesn't imply causation, but it does waggle its eyebrows suggestively and gesture furtively while mouthing 'look over there'. - xkcd.com/552
Reply With Quote
  #122  
Old 05-05-2010, 02:42 PM
ADoubleDot's Avatar
ADoubleDot ADoubleDot is offline
Member
SOA
 
Join Date: Nov 2007
Location: Slightly Dusty South
Studying for the rest of my life
Posts: 37,151
Default

__________________
ADoubleDot: I'm an actuarial icon.

**** Juan.
Reply With Quote
  #123  
Old 05-05-2010, 02:57 PM
ADoubleDot's Avatar
ADoubleDot ADoubleDot is offline
Member
SOA
 
Join Date: Nov 2007
Location: Slightly Dusty South
Studying for the rest of my life
Posts: 37,151
Default

Is there a way to find external references?
__________________
ADoubleDot: I'm an actuarial icon.

**** Juan.
Reply With Quote
  #124  
Old 05-05-2010, 03:08 PM
Ginormous76's Avatar
Ginormous76 Ginormous76 is offline
Member
 
Join Date: Feb 2008
Posts: 23,654
Default

Quote:
Originally Posted by ADoubleDot View Post
Is there a way to find external references?
Yes, give me just a second to remember.
__________________
Rubber ducky, you're the one!
Reply With Quote
  #125  
Old 05-05-2010, 03:08 PM
Ginormous76's Avatar
Ginormous76 Ginormous76 is offline
Member
 
Join Date: Feb 2008
Posts: 23,654
Default

Edit -> Links
__________________
Rubber ducky, you're the one!
Reply With Quote
  #126  
Old 05-05-2010, 03:11 PM
SirVLCIV's Avatar
SirVLCIV SirVLCIV is offline
Member
SOA
 
Join Date: Feb 2006
Posts: 46,909
Default

Quote:
Originally Posted by Ginormous76 View Post
Edit -> Links
Doesn't work well if the links are in range names.

I usually do two things; 1) search all formulas in workbook for ".xls", then 2) check all range names.
Reply With Quote
  #127  
Old 05-05-2010, 03:22 PM
MountainHawk's Avatar
MountainHawk MountainHawk is offline
Member
CAS AAA
 
Join Date: Dec 2001
Location: Salem, MA
Studying for Nothing!!!!
College: Lehigh University Alum
Favorite beer: Yuengling
Posts: 64,850
Default

Quote:
Originally Posted by SirVLCIV View Post
Doesn't work well if the links are in range names.

I usually do two things; 1) search all formulas in workbook for ".xls", then 2) check all range names.
What if someone named their sheets 'Data.xls', 'Exhibit.xls', etc.
__________________

Play in the AO Prediction Game now!



1
Reply With Quote
  #128  
Old 05-05-2010, 04:00 PM
ADoubleDot's Avatar
ADoubleDot ADoubleDot is offline
Member
SOA
 
Join Date: Nov 2007
Location: Slightly Dusty South
Studying for the rest of my life
Posts: 37,151
Default

Quote:
Originally Posted by Ginormous76 View Post
Edit -> Links
Thanks!
__________________
ADoubleDot: I'm an actuarial icon.

**** Juan.
Reply With Quote
  #129  
Old 05-05-2010, 04:02 PM
ADoubleDot's Avatar
ADoubleDot ADoubleDot is offline
Member
SOA
 
Join Date: Nov 2007
Location: Slightly Dusty South
Studying for the rest of my life
Posts: 37,151
Default

Quote:
Originally Posted by SirVLCIV View Post
Doesn't work well if the links are in range names.

I usually do two things; 1) search all formulas in workbook for ".xls", then 2) check all range names.
People do the bolded?? Thats a firable offense to me

The first numbered solution is a good idea.
__________________
ADoubleDot: I'm an actuarial icon.

**** Juan.
Reply With Quote
  #130  
Old 05-05-2010, 05:52 PM
KandaBer KandaBer is offline
Member
SOA AAA
 
Join Date: Nov 2006
Studying for FSA Modules
Posts: 696
Default

Quote:
Originally Posted by ADoubleDot View Post
People do the bolded?? Thats a firable offense to me
Links in range names can happen accidently, in copying tabs from file to file.

I agree that they are worse than regular links.
Reply With Quote
Reply

Tags
data science

Thread Tools Search this Thread
Search this Thread:

Advanced Search
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 05:19 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.23778 seconds with 9 queries