Advertisement
ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
ExcelCalcs XLC XLC Issues
Re:negative Powers Issue (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: 1
TOPIC: Re:negative Powers Issue
#284
chrisdale (User)
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
negative Powers Issue 1 Year, 2 Months ago Karma: 2  
I have been using XLC for a little while and have come across what i think is an issue.

I have a formula that contains a negative power i.e. 5.52 x 10^-14

XLC gives me the same value as typed (5.52 x 10^-14) and does not remove the caret or superscript the -14. If I remove the minus sign it works correctly but obviously the formula is now incorrect.

Do you have any ideas.

Regards
Chris Dale
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#286
JohnDoyle (Admin)
Admin
Posts: 414
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:negative Powers Issue 1 Year, 2 Months ago Karma: 470  
Hi Chris
I am aware of this and it is on my to do list. Its actually a little problematic but I'll nail it soon. You'll have to just bear with me until my day job calms down a bit. I'll keep you posted.
 
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.
#288
yogia (User)
Junior Boarder
Posts: 35
graphgraph
User Offline Click here to see the profile of this user
Re:negative Powers Issue 1 Year, 2 Months ago Karma: 9  
Hi John:

To add to what ChrisDale has reported,

if working = 1 is chosen in the EQS function, the exponent is not superscripted for numerical values regardless whether the numeric value is positive or negative. I have included an image for reference ...
 
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.
#290
JohnDoyle (Admin)
Admin
Posts: 414
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:negative Powers Issue 1 Year, 2 Months ago Karma: 470  
Thanks Yogia (nice to hear from you again) - I had not noticed this either. Please bear with me, it may take some time before I can get round to fix it. I'll let you know when I do.
 
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.
#1019
JohnDoyle (Admin)
Admin
Posts: 414
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:negative Powers Issue 4 Months, 1 Week ago Karma: 470  
Hopefully all these issues are addressed in XLC version 03-08.
 
Report to moderator   Logged Logged  
 
Last Edit: 2008/04/07 23:16 By JohnDoyle.
 
Talk to me about training.
Talk to me about engineering consultancy work and finite element analysis.
  The administrator has disabled public write access.
#1029
JohnDoyle (Admin)
Admin
Posts: 414
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:negative Powers Issue 4 Months ago Karma: 470  
Just a couple of glitches ironed out in version 03-08 build 03. Got there in the end.
 
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