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
#1597
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  
Zipped file attached
File Attachment:
File Name: DEERE_PDC_20090430_BEAMS.zip
File Size: 48252
 
Logged Logged  
  The administrator has disabled public write access.
#1598
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 8 Years, 6 Months ago Karma: 493  
Currently there is no way of compressing the length of equations by removing the space characters. I can add it to my "to do" list it should be a relatively simple modification (famous last words).

You can 'slim' down equations using the following techniques. First a screen shot comparing the two approaches:

Here are a couple of ideas I used to reduce the length of equations:
1) Uncheck the "Show all multiplication signs" which can be found on the "About XLC and settings" button on the XLC toolbar. To read equations clearly all variable need to one full sized character followed by subscripted characters (as many as you like).
2) Use the OVD()/UND() functions to display above and below the division signs.

I have also attached the revised calculation if you want to play around with it.
File Attachment:
File Name: Revised_BEAM_Calculation.xls
File Size: 150528
 
Logged Logged  
 
Last Edit: 2009/05/01 02:10 By JohnDoyle[Admin].
 
  The administrator has disabled public write access.
Go to top
We have 10 guests and 41 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