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.