Advertisement
ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
ExcelCalcs XLC XLC Issues
Re:Fractions within fractions (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: Re:Fractions within fractions
#86
DvdHntr ()
User Offline Click here to see the profile of this user
Fractions within fractions 1 Year, 8 Months ago Karma: 21  
I am trying to display a formula that has:

Fsy*Ast[do-((Ast*Fsy)/(1.7*f'c*B))]
Then this equation is divided by 1000000.

The problem is that I want the 1000000 underneath and I can only get it to the side. I tried two pairs of OVD()/UND() but the middle pair is then displayed in the equation.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#87
DvdHntr ()
User Offline Click here to see the profile of this user
Re:Fractions within fractions 1 Year, 8 Months ago Karma: 21  
Can I just add one more part to this?

Is there a way to change the way a equation name formatted so that

|fM does not subscript the M.

Perhaps there is another mark to placed in to indicate that a character should be exempt from formatting (in the same way the | is used to display greek letters).
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#88
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:Fractions within fractions 1 Year, 8 Months ago Karma: 470  
XLC will only draw one division line in an equation. So you can't have a fraction within a fraction. You probably need to break down the calculation into a number of parts.
On your second point you can restrain XLC from automatically subscripting this is cover in the online help just below the flash tutorial. http://www.excelcalcs.com/content/view/52/126/
Hope this keeps you going.
 
Report to moderator   Logged Logged  
 
Training, engineering consultancy and finite element analysis.
  The administrator has disabled public write access.
#90
DvdHntr ()
User Offline Click here to see the profile of this user
Re:Fractions within fractions 1 Year, 8 Months ago Karma: 21  
Thanks,

Pity about the fractions. I will just not format the names of the equations with XLC.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#148
yogia ()
User Offline Click here to see the profile of this user
Re:Fractions within fractions 1 Year, 7 Months ago Karma: 9  
Hi DvdHntr:

I had a little play with the parameters you posted.

I used values of Fsy, Ast, do,f'c, and B in cells B6 though 10, and I used the following equation ...

=ODI(B6*B7*(B8-((B7*B6)/(1.7*B9*B10))))/UDI(1000000)

I have attached the graphic of the equation object and the associated worksheet herewith.

Please check these out and see what you think.
File Attachment:
File Name: XLC_1yae_101_02.xls
File Size: 15360


Regards!
Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC http://www.energyefficientbuild.com<br><br>Post edited by: yogia, at: 2007/04/10 02:03
 
Report to moderator   Logged Logged  
 
Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
http://www.energyefficientbuild.com
  The administrator has disabled public write access.
#149
DvdHntr ()
User Offline Click here to see the profile of this user
Re:Fractions within fractions 1 Year, 7 Months ago Karma: 21  
That's what I ended up using thanks.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Sponsored by MoreVision Engineering Consultantsget the latest posts directly to your desktop