Home
ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
Automatic equation formatting issues (1 viewing) (1) Guest
If none of the forum headings seem to fit your question or comment then post it here.
Go to bottom Favoured: 0
TOPIC: Automatic equation formatting issues
#2330
gfs_se (User)
Froglet (Expert Boarder)
Posts: 14
graphgraph
User Offline Click here to see the profile of this user
Automatic equation formatting issues 6 Years, 5 Months ago Karma: 0  
John,
I find that I often want to format a named variable so that the second character is not a subscript. This particularly happens when applying a Greek letter phi before a variable, such as phiMn. The XLC add-in automatically formats all characters after the first as subscripted. I can manually change the format, which takes a lot of time, but if the global re-write all equations is used, all of the manual formatting gets switched back to the XLC format. I have also found that text strings that include an equal, even if they were not set as named variables, will switch to a named and subsripted, left-justified variable.

You can see what I an referring too by looking at the program I recently submitted called Steel beam with web openings. You corrected some errors and saved it as version 1. I have just up-loaded version 2, which tried to clean up some of my equation formatting. In the second tab, at the end is a summary of the reinforcement required inside of a red box. The headings were originally entered as text, but after you did a global update of the equations in V1, the text became named variables with subsripts. I had a hard tiome getting the spreadsheet to reconize the text with out the XLC formatting automatically being applied. Is there some rule I need to follo about text so that this does not continue to happen?

Thank you for fixing the OVD/UND error on the second tab. I had tried to fix it but ccould not find the mistake. I apologize for the reference to a previous edition. I inadvertently deleted one of the sheets and had to import it from an earlier version. I didn't notice that it had carried in a reference to the first workbook. I will look more carefully next time.

Finally, when uploading a revised version of a workbook, is it necessary to re-write the description. I didn't do so with version 2, thinking it would automatically bring in the description from version 1, but when I viewed the up-load, it had no description. Is there a different method of sending a new version that I should have used?

Thanks for the great add-in, and for all of the time you have put into this.
 
Logged Logged  
  The administrator has disabled public write access.
#2333
JohnDoyle[Admin] (Admin)
Mechanical Engineer.
Moderator
Posts: 1729
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:Automatic equation formatting issues 6 Years, 5 Months ago Karma: 492  
Hi

I'm not sure if you read my last reply to your questions which you'll find here but I think we are covering some of the same ground. When you post to the forum checking the subscribe tick box makes sure that you are notified of any replies to that forum thread. Your registered email address is used for notifications.

The headings were originally entered as text, but after you did a global update of the equations in V1, the text became named variables with subscripts. I had a hard time getting the spreadsheet to recognize the text with out the XLC formatting automatically being applied. Is there some rule I need to follow about text so that this does not continue to happen?
Any cell with a text string ending in "=" is assumed to be a name. If it ends in " =" the automatic subscripting is applied. That's all XLC does but see my previous post.

Thank you for fixing the OVD/UND error on the second tab. I had tried to fix it but ccould not find the mistake. I apologize for the reference to a previous edition. I inadvertently deleted one of the sheets and had to import it from an earlier version. I didn't notice that it had carried in a reference to the first workbook. I will look more carefully next time.
No apologies required gfs_se we are delighted that you want to keep looking after your calculation. The reason for the forum links and commenting features is so that the whole community can work together to improve content. I hope you find the collaborative nature of the site useful.

Finally, when uploading a revised version of a workbook, is it necessary to re-write the description. I didn't do so with version 2, thinking it would automatically bring in the description from version 1, but when I viewed the up-load, it had no description. Is there a different method of sending a new version that I should have used?
OK I can see what has happened here you uploaded version 2 of the calculation but our system recognised it as a completely new upload. The way to up-issue a calculation is to navigate to the version 1 down load page and if you are logged in the site recognises you as the author and presents you with a "Update Submission" link just under the download title. If you use this you can just upload the new version and change the version number. The description remains the same (unless you want to edit this too). When I update a submission I also use the forum link to say why the calculation has changed and all subscribers to this forum thread are emailed and so keep up to date with any changes. I'll delete your last update and perhaps you could use the "Update Submission" link as I have suggested.

As always we are very appreciative of your interest in the site. Thank you very much.
 
Logged Logged  
 
  The administrator has disabled public write access.
Go to top
We have 21 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.