Home
ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
Nesting OVD and UND (1 viewing) (1) Guest
Use this forum to discuss any problems, user suggestions or any other issue regarding the XLC software.
Go to bottom Favoured: 1
TOPIC: Nesting OVD and UND
#870
Clyde (User)
Frog (Gold Boarder)
Posts: 23
graphgraph
User Offline Click here to see the profile of this user
Nesting OVD and UND 9 Years, 11 Months ago Karma: 5  
Hi John,
I'm having trouble with formatting (see attached file). I'd like to know if EXCEL Calcs can format the formula like the Microsoft Equation 3.0 example (shown in the spreadsheet). By the way, I am having to scroll down to the bottom of the page on your site again.
Thanks,
Clyde
File Attachment:
File Name: Nested_OVD_UND.xls
File Size: 12800
 
Logged Logged  
  The administrator has disabled public write access.
#885
JohnDoyle[Admin] (Admin)
Mechanical Engineer.
Moderator
Posts: 1747
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:Nesting OVD and UND 9 Years, 11 Months ago Karma: 493  
I am not going to be much help here Clyde because XLC can't handle nested OVD and UND statements. The equation is rendered on two lines. I could improve on this I guess but it would take quite a bit of work and there is a work around. You are not the first to request this. Thanks for your comment.

With regard to scrolling down the page to see the forum - I check that the site works with IE version 7 and Firefox/2.0.0.11 but I am aware that there are occasionally problems when content is rendered below the main menu. This looks like a blank page to the user - if this ever happens then scroll down and you'll find the content below the main menu. The joy of websites!
 
Logged Logged  
 
  The administrator has disabled public write access.
#3509
JoshuaTurley (User)
Egg (Fresh Boarder)
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
Re:Nesting OVD and UND 2 Years, 2 Months ago Karma: 0  
What was the work around? Was it just using the equation editor and manually putting the equation in?
 
Logged Logged  
  The administrator has disabled public write access.
#3510
JohnDoyle[Admin] (Admin)
Mechanical Engineer.
Moderator
Posts: 1747
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:Nesting OVD and UND 2 Years, 2 Months ago Karma: 493  
The work around is just to use equations with two lines one above the division line and one below the division line. In the example below you could write the term for a6 over three lines and just use 'a' terms (and one division line above another). However using XLC I need to stick to two line and introduce a new variable 'b'. I hope this helps.
 
Logged Logged  
 
Last Edit: 2015/09/15 16:16 By JohnDoyle[Admin].
 
  The administrator has disabled public write access.
Go to top
We have 11 guests and 37 members online
Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.

 

 

Google Analytics Alternative