Member Login

Contact Us
telephone US +1 617 5008224
telephone EU +44 113 8152220
post/email Forum or Email
Like this Page?

Follow Us
Follow us on twitter. Follow us on LinkedIn. Follow us on YouTube.
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.

Who's Online

We have 11 guests and 36 members online

Total Downloads


Enter Amount:

Home arrow ExcelCalcs News arrow Mathcad Functionality for Excel Users
Signup Now! Subscribe, login and start downloading. Latest Calculations! Follow us on Twitter.

Mathcad Functionality for Excel Users
Monday, 01 June 2009

A recent press release is included in this edition of the site Newsletter. Please pass it on to friends and colleagues with an interest in calculations.

Excel users can install two free downloads to obtain ‘Mathcad-like’ functionality to produce live calculation sheets. A live calculation sheet will not only perform the calculation it will also present the underlying equations so that the calculation method is transparent to the reader. This is important for engineers, scientists and students so that calculations can be independently checked and endorsed. Now Excel is more useful to the structural engineer who needs to show that he has satisfied building regulations, the physicist who needs to show how to calculate the half life of a radioactive isotope or the student showing his teacher how he calculated the roots of a quadratic equation. Best of all, as the calculations are saved in Excel format, files can be distributed with a degree of certainty that any recipient will be able to read and reused them. This is not at all certain for calculations prepared with specialist software like Mathcad.

The XLC Addin - This software can be downloaded from and it displays cell formulas as mathematical equations so that calculations can be read like a math text book. The site also features a library of live calculation sheets using Excel. The Addin has been developed by John Doyle. He is a UK chartered mechanical engineer, a graduate of Imperial College London and has presented a number of papers at the UK Institute of Mechanical Engineers. Working as a consultant in the fields of finite element analysis, test and simulation he has considerable knowledge of what is required of engineering calculations. His analysis and testing services have been used for railway vehicles, construction equipment, oil and gas plant, cranes and mechanical items for theme parks. He lives in Leeds which is located in the UK.

The ChangeUnits Addin - No one likes doing manual unit conversions: they are tedious, error-prone, and shift the focus from the underlying (and interesting) science and engineering to a mind-numbing chore. The ChangeUnits Addin from is designed to make this easy for Excel users. The Addin has been developed by Tony Renshaw who has an A.B. in Applied Mathematics from Harvard and a Ph.D. in Mechanical Engineering from U.C. Berkeley. As an engineer, he has worked on Space Station Freedom, designed washing machines and X-ray tubes at General Electric's Corporate Research and Development Center, and taught mechanical engineering as a professor at Columbia University. He holds seven US patents and has over 30 refereed publications. He currently lives in New York City and Hawaii.

Repository News

Update from Dr Tony Renshaw
Dr Tony Renshaw.

ChangeUnits is the original natural syntax unit conversion add-in for Excel. ChangeUnits understands virtually any combination of units and automatically checks to make sure each conversion is valid. A video demonstration of the software is available online (although FireFox users require the MediaPlayerConnectivity Firefox extension).

New from Alex Tomanovich
Alex Tomanovich

"TORSION9.xls", for quick and simplified torsion analysis of W, S, M, and HP steel beams. The workbook contains 6 calculation worksheets, each of which deals with a specific beam and torsional loading configuration. The combined stress ratio is determined as well as the angle of twist. The torsion analysis is based on the formulas found in the USS Steel Design Manual (1981). When applicable, I have used this reference for torsion analysis for years. The results for the cases considered compare very favorably to results obtained from the AISC Design Guide #9, "Torsional Analysis of Structural Steel Members", as well as other references with much more involved solutions. While this workbook deals with rather simplistic cases of torsion on beams, it should still prove useful for "quickie" solutions and conservative checks on torsional effects when required. Sorry, it's still more AISC 9th Edition ASD stuff. I'll be moving on to the AISC 13th Edition.....eventually.
Update from Alex Tomanovich
I made a minor change to the "Code Check" worksheet of the "BEAMANAL.xls workbook. Similar to the change that I made in some of the other workbooks related to structural steel design, I removed the input data validation which originally limited the user to specific values of Fy =33, 36, or 50 ksi. The updated workbook is now version 2.4.
Update from Alex Tomanovich
A potential "quirk" was found in the "MONORAIL.xls" workbook. From Table 6 (Values of Cb) on page 5-121 of the AISC 9th Edition Manual, the minimum value of the bending coefficient (Cb) is 1.0. A value of 1.0 for Cb is what is used most of the time in design, even if conservative. However, if for the cantilever portion of the monorail beam the user chooses to use the Lbo and Cbo values as determined off of the calculation page to the right per the AISC Journal Article by N.S. Tanner, then the calculated value of Cbo can be < 1.0. (The subscript "o" refers to the overhang or cantilever portion of the monorail beam). Specifically for the situation of a member with Lbo <= Lu and with an input value of Cbo < 1.0, the two worksheets were ignoring an input value of Cbo < 1.0, treating Cbo as if it were = 1.0, and thus deferring to Fb = 0.6*Fy. This problem involving the use of a Cbo value < 1.0 did not occur for Lbo > Lu. Again, this potential problem would have only arisen if a value of Cbo < 1.0 was used from the Tanner article in conjunction with Lbo <= Lu. The corrections have been made, and the updated workbook is now version 1.7.
 elevator engineer  FileLiftTools1.xls
Solved problems from the Elevator Traffic Handbook
 New from Sumnerdave  FileAnchor Reinforcement
"Anchor Reinf.xls" is a MS-Excel spreadsheet workbook for the analysis of anchor bolt reinforcement to supplement tension/shear concrete breakout per ACI 318-08, Appendix D (Section D5.2.9 / D6.2.9). The spreadsheet is designed to find the embedment strength of determined reinforcement within certain concrete parameters. Design References:
1. ACI 318-08
2. Strength Design of Anchorage to Concrete by Ronald A. Cook

Forum News

Follow some interesting discussions in the forum. Thank you all but especially timmythetank and MajorMagee.

Topic/Forum New posts Latest post author Posted at
BOEF.xls Show most recent message
Forum : Repository Discussion
2 ATomanovich 2009/06/01 15:03
"ExcelCalcs" videos Show most recent message
Forum : Website Issues
2 JohnDoyle 2009/05/29 15:43
Stress Life Fatigue.xls [Page: 1,2] Show most recent message
Forum : Repository Discussion
7 MajorMagee 2009/05/22 16:05
Is there a limit to number of equations? Show most recent message
Forum : XLC Issues
3 srmech_engr 2009/05/20 05:32
import image data [Page: 1,2] Show most recent message
Forum : Repository Requests
11 JohnDoyle 2009/05/14 14:30
XLC for Education Show most recent message
Forum : XLC Issues
2 JohnDoyle 2009/05/12 01:22
Reading graphical and tabular data with Excel Show most recent message
Forum : ExcelCalcs TV
4 MajorMagee 2009/05/11 17:16
Spreadsheet links for discussion [Page: 1,2] Show most recent message
Forum : Other Repository Issues
8 timmythetank 2009/05/09 05:12
Membership canceled? I think not! Show most recent message
Forum : Miscellaneous Topics
1 JohnDoyle 2009/05/06 17:32
Using Excel trendlines to generate equations from complex graphical or tabular data Show most recent message
Forum : ExcelCalcs TV
1 JohnDoyle 2009/05/06 13:34



Please sign in or register to add a comment.

Getting Started with ExcelWraps

The first thing to realise is that Wraps are accessed through your own ExcelWraps subdomain. You’ll become administrator of your subdomain and set up your users with at least one ‘role’. For example Unipart roles link to their competence management system (Production Operative 2,...

RIP Paperwork

ExcelWraps replaces all paper records at Unipart A quantum leap for the Hitachi 395 bogie overhaul as paper is superseded by Wraps. Now information is immediately available through the cloud and shared across Unipart, with its clients and its subcontractors. Bogie overhaul consists of 20 ...

Wabtec ExcelWraps Subdomain is Launched

We are delighted to launch from where Wabtec will be trialing wraps to monitor their rail overhaul business. Wabtec Rail undertakes the overhaul, refurbishment and conversion of all types of locomotive, passenger rolling stock and freight wagon bogies. Services includ...

Feedback from HitachiWraps Openday

HitachiWraps Open Day Feedback - We were very pleased to look through the positive comments in your feedback wraps. On Friday immediately after the event we were asked to present to the Unipart board so I guess it could not be more positive than this. A cross section of organisations across t...

HitachiWraps Open Day Wednesday March 12th 2014

  The high speed Class 395 fleet services are orchestrated from the Hitachi Rail depot in Ashford. The management team have a vision of replacing  clipboards with iPads so that the depot, their suppliers and clients can share live information. Hitachi engineers make spreadsheets wh...

Date to be Set for HitachiWraps Open Day

  The high speed Class 395 fleet services are orchestrated from the Hitachi Rail depot in Ashford. The management team have a vision of replacing  clipboards with iPads so that the depot, their suppliers and clients can share live information. Hitachi engineers make spreadsheets wh...

Introducing ExcelWraps

Just imagine if you could design your own App linked to a cloud data engine and working on any PC, tablet or smartphone……well now you can! You design your App in Excel. We make it device independent. We supercharge with our cloud data engine. You control access...

Training Courses For London Underground

"Thanks again for your excellent course this past week." "Thank you for the course last week, found it very interesting both from the perspective of a quick refresh, but also on how we can optimise the work we do." "Thanks for a very interesting and usef...

Try Excel 2013 for Free!

I am pleased to report that XLC Ribbon works with the 32bit and 64 bit versions of Excel 2013 obtained using the free Office 365 Home Premium Preview. Excel 2013 looks a little flat and dull compared to previous versions but I think this is the influence of the new Windows 8 'metro' look and f...