Advertisement
ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
ExcelCalcs XLC XLC Issues
OVD/UND function (1 viewing) (1) Guest
Use this forum to discuss any problems, user suggestions or any other issue regarding the XLC software.
Go to bottom Post Reply Favoured: 0
TOPIC: OVD/UND function
#683
BridgerJeff ()
User Offline Click here to see the profile of this user
OVD/UND function 1 Year, 2 Months ago Karma: 6  
The ovd/und function does not seem to work as anticipated in cell E141

(the file exceeds the allowable attachment size, i have sent a copy to your email)
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#684
JohnDoyle ()
Please support us with an XLC Pro Subscription.
User Online Now Click here to see the profile of this user
Gender: Male MoreVision Location: LEEDS, WEST YORKSHIRE, UK Birthdate: 1965-02-24
Re:OVD/UND function 1 Year, 2 Months ago Karma: 470  
Jeff the problem seems to be with the use of cell names. Your cell equation is: "=0.3*SQRT(OVD(E_Beam)/UND(Fy_Beam))"
E_Beam and Fy_Beam are cell names but need to be cell references to work with XLC. I hope this helps.
 
Report to moderator   Logged Logged  
 
Training, engineering consultancy and finite element analysis.
  The administrator has disabled public write access.
#687
BridgerJeff ()
User Offline Click here to see the profile of this user
Re:OVD/UND function 1 Year, 2 Months ago Karma: 6  
It seems odd that the OVD/UND function does not work in this cell with cell names when it works fine with cells E284, E139, etc.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#688
JohnDoyle ()
Please support us with an XLC Pro Subscription.
User Online Now Click here to see the profile of this user
Gender: Male MoreVision Location: LEEDS, WEST YORKSHIRE, UK Birthdate: 1965-02-24
Re:OVD/UND function 1 Year, 2 Months ago Karma: 470  
Its probably a bit of an oversight on my part because I rarely name cells but I understand that lots of people do. I'll give this some further thought and possibly add it to my XLC 'to do' list. Thanks for your feedback.
 
Report to moderator   Logged Logged  
 
Training, engineering consultancy and finite element analysis.
  The administrator has disabled public write access.
Go to top Post Reply
Sponsored by MoreVision Engineering Consultantsget the latest posts directly to your desktop