Helping You Make and Share Calculations with MS Excel

ExcelCalcs is a community who share an interest in making calculations with MS Excel. Use our XLC add-in for Excel to display cell formulas as easily readable mathematical equations. Downloading worked solutions from our Repository gives you a head start in solving technical problems. We charge members an annual subscription fee, we offer 50% discounts to academic members, we award free subscriptions to contributors and we offer free trials for the curious. See our subscription plans...

Our Excel addin software displays cell formulae as mathematical equations. This innovative cell formula verification tool turns Excel into an engineer's calculation pad. It is essential for all engineers, teachers and students. It works with Excel 2000, 2003, 2007, 2010, 2013 and 2016.Download XLC...

Our Calcs are template Excel solutions covering many subjects including Strength, Beams, Buckling, Civil Engineering, Cracks, Finite Element, Frames, Materials, Plates, Stress Concentration, Structural Details, Torsion, Pressure Vessels, Machine Design, Bolts and Threads, Gears, Pins and Joints, Ropes and Cables, Shafts, Welds, Math, Geometry, Heat Transfer (Conduction, Convection, Radiation & Combined), Dynamics, Fluids Mechanics, Piping, Electricity and Finance. Browse our calcs...

Increase Productivity

Builds on existing Excel skills
Use Excel files to distribute knowledge widely
Fast learning curve compared to other Maths software
Reuse of Repository items
Access to expert knowledge via comments feature

Reduce Errors

Double check cell formulae with mathematical equations
Check directly against the textbook
Learn quickly by example
Reduce rework
Quality assurance through comments feature

Great Value

Low cost & higher return on your existing Excel software
Insignificant cost when compared with MathCAD, Mathematica or Maple
Free XLC Pro subscriptions to contributors
Volume discount incentives

Anyone can view our calculations pages for inspiration
Free subscriptions for contributors!
Free trial of XLC add-in and trial downloads
$99 for a 12 month professional subscription and full site access
50% discount for students and teachers!

Consultancy

Engineering consultants
Finite Element Analysis
Strain gauge testing
World renowned client list
Provided services since 1995

Training

Select training modules
1 to 5 days duration
In-house any location
Spreadsheets design tools
Free XLC Pro subscriptions

Software

Excel Addins
Custom spreadsheets
Proven track record
Fixed price contracts
Support

Recommendations

"This standalone tool makes generation of equations directly from cell formulae’s in the smartest and fastest way." Freedownloadscentre Editor's review.

"With this add-in, you can finally turn those cryptic Excel formulas into recognizable mathematical equations." Vertex42 Five Star Review

"an addin that displays excel formulas symbolically for easy checking and for presentation. Displaying formulas is a real kick!" Eng-Tips Forum Five Star tip.

"I've had a play with it and it's great, it's driven me nuts for years having to do all my equations in equation editor and then update them when things change". Institute of Mechanical Engineers Forum Administrator

"The best thing about XLC is that equations are a really great check on the cell formula. It's easy to make a mistake with Excel formulas (as I know because I make them all the time) but its easy to see where you have gone wrong when you check against equations." Debbie_Williams.

"I have only been using it for a week or so but XLC is an answer to my prayers. I had been using the MS equation editor which took hours of my time and I often mistyped. Now I can generate equations directly from cell formulas instantaneously. Great idea. Thanks again and well done." Helen_Miller.

"I think I will be ditching MathCAD and using this instead. Then I can send my calculations to anyone, we all have Excel whereas only a few of us have MathCAD." Boffin.

"There are loads of useful web calculations on the internet but the ExcelCalcs Repository gives it to me in an Excel format so I can easily copy and integrate them into my own calculations. This afternoon you saved me hours by downloading a repository calculation rather than authoring my own - thank you!" Mark_Rawlings.

"What a great plug-in I have been looking for something like this for years. Highly recommended!" jhardy.

	XLC Trial (1M)	XLC Ed (12M)	XLC Pro (12M)
Hover over ticks and crosses for further detail.	A little taste of what we have to offer	Reduced price for students and teachers	For engineering professionals and corporations
Website
Repository Trial Folder
Full Repository access
Hide site Google Ads
Document control and update notification
Forum access to expert community
Commercial use of Repository downloads.
XLC add-in
XLC Add-in Toolbar version
Full XLC equation functionality
XLC Multiple installations
XLC reinstalls not required
XLC support
Commercial use of XLC add-in
Payment
Instant site access with PayPal
Instant site access with Credit Card
Full 12 month term applied on sign up
Volume Discount
Alternative Payment methods
On-site training/engineering consultancy.
Subscription duration	1 month	12 month	12 month
Cost of subscription	Free	$45 USD	$90 USD

Copy to Native Excel:
Click in the text area below and copy. Then paste into cell A1 of a worksheet. All the formulas are brought in intact but Excel default behaviour controls formatting. A better transfer can be achieved using our XLC add-in for Excel (see below).

<table><tbody><tr><td></td>	<td>Length of sides</td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>b =</td>	<td>30</td>	<td>mm</td>	<td>in</td></tr>
				<tr><td></td>	<td></td>	<td>d =</td>	<td>50</td>	<td>mm</td>	<td>in</td></tr>
				<tr><td></td>	<td></td>	<td>d1 =</td>	<td>20</td>	<td>mm</td>	<td>in</td></tr>
				<tr><td></td>	<td></td>	<td>b1 =</td>	<td>5</td>	<td>mm</td>	<td>in</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td>Area and distances from centroid to extremities </td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td>Area of Rectangle</td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>A =</td>	<td>=D2*D3-D5*D4</td>	<td>mm²</td>	<td>in²</td></tr>
				<tr><td></td>	<td>Distance to Extreme Fiber</td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>y1 =</td>	<td>=(D3)/(2)</td>	<td>mm</td>	<td>in</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>y2 =</td>	<td>=(D2)/(2)</td>	<td>mm</td>	<td>in</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td>Moments and products of inertia and radii of gyration about central axes </td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td>Moment of inertia</td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>I1 =</td>	<td>=(D2*D3^3-D5*D4^3)/(12)</td>	<td>mm⁴</td>	<td>in⁴</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>I2 =</td>	<td>=(D3*D2^3-D4*D5^3)/(12)</td>	<td>mm⁴</td>	<td>in⁴</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td>Radius of gyration</td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>r1 =</td>	<td>=SQRT((D17)/(D9))</td>	<td>mm</td>	<td>mm</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>r2 =</td>	<td>=SQRT((D19)/(D9))</td>	<td>mm</td>	<td>mm</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td>Plastic section moduli shape factors, and locations of plastic neutral axes</td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td>Plastic section modulus </td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>Z1 =</td>	<td>=(D2*D3^2-D5*D4^2)/(4)</td>	<td>mm³</td>	<td>in³</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>Z2 =</td>	<td>=(D3*D2^2-D4*D5^2)/(4)</td>	<td>mm³</td>	<td>in³</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td>Shape Factor</td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>SF1 =</td>	<td>=(D28*D3)/(2*D17)</td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>SF2 =</td>	<td>=(D30*D2)/(2*D19)</td>	<td></td>	<td></td></tr></tbody></table>

Copy to XLC Enhanced Excel:
Click in the text area below and copy. Then use XLC’s ‘Web Paste’ button to paste at any position in worksheet. This method gives better format control, mathematical formatting and XLC equations.

<table><tbody><tr><td></td>	<td>Length of sides</td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>b =</td>	<td>30</td>	<td>mm</td>	<td>in</td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>d =</td>	<td>50</td>	<td>mm</td>	<td>in</td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>d1 =</td>	<td>20</td>	<td>mm</td>	<td>in</td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>b1 =</td>	<td>5</td>	<td>mm</td>	<td>in</td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td>Area and distances from centroid to extremities </td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td>Area of Rectangle</td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>A =</td>	<td>=D2*D3-D5*D4</td>	<td>mm²</td>	<td>in²</td>	<td>=EQS(D9,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp$H$33_2")</td></tr>
				<tr><td></td>	<td>Distance to Extreme Fiber</td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>y1 =</td>	<td>=OVD(D3)/UND(2)</td>	<td>mm</td>	<td>in</td>	<td>=EQS(D11,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp$H$36_2")</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>y2 =</td>	<td>=OVD(D2)/UND(2)</td>	<td>mm</td>	<td>in</td>	<td>=EQS(D13,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp$H$37_2")</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td>Moments and products of inertia and radii of gyration about central axes </td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td>Moment of inertia</td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>I1 =</td>	<td>=OVD(D2*D3^3-D5*D4^3)/UND(12)</td>	<td>mm⁴</td>	<td>in⁴</td>	<td>=EQS(D17,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp$H$45_2")</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>I2 =</td>	<td>=OVD(D3*D2^3-D4*D5^3)/UND(12)</td>	<td>mm⁴</td>	<td>in⁴</td>	<td>=EQS(D19,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp$H$47_2")</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td>Radius of gyration</td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>r1 =</td>	<td>=SQRT(OVD(D17)/UND(D9))</td>	<td>mm</td>	<td>mm</td>	<td>=EQS(D22,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp$H$51_2")</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>r2 =</td>	<td>=SQRT(OVD(D19)/UND(D9))</td>	<td>mm</td>	<td>mm</td>	<td>=EQS(D24,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp$H$52_2")</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td>Plastic section moduli shape factors, and locations of plastic neutral axes</td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td>Plastic section modulus </td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>Z1 =</td>	<td>=OVD(D2*D3^2-D5*D4^2)/UND(4)</td>	<td>mm³</td>	<td>in³</td>	<td>=EQS(D28,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp$H$56_2")</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>Z2 =</td>	<td>=OVD(D3*D2^2-D4*D5^2)/UND(4)</td>	<td>mm³</td>	<td>in³</td>	<td>=EQS(D30,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp$H$58_2")</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td>Shape Factor</td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>SF1 =</td>	<td>=OVD(D28*D3)/UND(2*D17)</td>	<td></td>	<td></td>	<td>=EQS(D33,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp$H$61_2")</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>SF2 =</td>	<td>=OVD(D30*D2)/UND(2*D19)</td>	<td></td>	<td></td>	<td>=EQS(D35,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp$H$63_2")</td></tr></tbody></table>

Units: SI(mm) & US(in) - delete as appropriate.

Repository Link
Check version history of this calculation; subscribe for revision history email notification; add a comment; add your rating; add to your favourites; download excel file including graphics.

Include in Your Website: Copy HTML code snippet to create a dynamic window to this page from your own website.