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)
Fresh Boarder
Posts: 8
graphgraph
User Offline Click here to see the profile of this user
OVD/UND function 10 Months, 1 Week 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 (Admin)
Admin
Posts: 400
graph
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 10 Months, 1 Week ago Karma: 469  
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  
 
Talk to me about training.
Talk to me about engineering consultancy work and finite element analysis.
  The administrator has disabled public write access.
#687
BridgerJeff (User)
Fresh Boarder
Posts: 8
graphgraph
User Offline Click here to see the profile of this user
Re:OVD/UND function 10 Months, 1 Week 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 (Admin)
Admin
Posts: 400
graph
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 10 Months, 1 Week ago Karma: 469  
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  
 
Talk to me about training.
Talk to me about engineering consultancy work 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