Home
ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
multiplication formatting (1 viewing) (1) Guest
Please post any suggestions or ideas that you think the ExcelCalcs team should consider.
Go to bottom Favoured: 1
TOPIC: multiplication formatting
#107
DaveCwork (Visitor)
Froglet (Expert Boarder)
Posts: 16
graphgraph
User Offline
multiplication formatting 10 Years, 7 Months ago Karma: 10  
When creating equations using other tools such as equation editor I often find that the equation looks a little crowded (particularly when greek characters are used). The solution to this is to include the multiplication operator to help space the parameters.

XLC allows the use of an x for this although this doesn't always help and could be confused for a parameter in some cases. Brackets can also be used to help break up the equation. However my preference is to use a combination of spaces, brackets and a dot operator (a full stop or period at mid height).

So my suggestion is to add the option to use a dot for the multiplication operator and include the facility to add a space between characters (less important but sometimes helps for things such as Cos^2(theta)).
 
Logged Logged  
  The administrator has disabled public write access.
#116
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:multiplication formatting 10 Years, 7 Months ago Karma: 493  
Thanks for the suggestion I should be able to do this quite easily. I'll add this to my 'todo' list. Subscribe to this topic to be advised of developments.<br><br>Post edited by: JohnDoyle, at: 2007/04/08 17:03
 
Logged Logged  
 
  The administrator has disabled public write access.
#170
yogia (User)
Frog Prince (Platinum Boarder)
Posts: 35
graphgraph
User Offline Click here to see the profile of this user
Re:multiplication formatting 10 Years, 7 Months ago Karma: 9  
Regarding incorporating the multiplication sign, what do you guys think about using the * character as is used in EXCEL? This may help in back checking ( and/or synchronizing) the equation generated by XLC. I know the use of * character is not as in traditional equations, but this would almost simulate the use of the dot operator and will also be consistent with what is used in EXCEL.
 
Logged Logged  
 
Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
http://www.energyefficientbuild.com
  The administrator has disabled public write access.
#172
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:multiplication formatting 10 Years, 7 Months ago Karma: 493  
I am planning allow users to set their own multiplication character as a program option. I hope this will keep everyone happy.
 
Logged Logged  
 
  The administrator has disabled public write access.
#1595
jpriley485 (User)
Frog (Gold Boarder)
Posts: 25
graphgraph
User Offline Click here to see the profile of this user
Re:multiplication formatting 8 Years, 6 Months ago Karma: 0  
This is probably too nit-picky.

See attached *.pdf file and look at last equation.

It appears there are extra spaces added before and after the multiplication and division operator symbols, causing the XLC equation to be far wider than necessary.

Is there a way to compact the equation?

Thanks.
 
Logged Logged  
  The administrator has disabled public write access.
#1596
jpriley485 (User)
Frog (Gold Boarder)
Posts: 25
graphgraph
User Offline Click here to see the profile of this user
Re:multiplication formatting 8 Years, 6 Months ago Karma: 0  
Wouldn't let me attach *.pdf, will try *.xls
 
Logged Logged  
 
Last Edit: 2009/05/01 01:18 By jpriley485. Reason: attach zip file
  The administrator has disabled public write access.
Go to top
We have 13 guests and 36 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.