ExcelCalcs Calculation Template

This Excel calculation can be downloaded by ExcelCalcs subscribers.Please login or Subscribe.


This is a very good way of starting your new calculation. The template comes loaded with a utility to manage units so that you can easily switch between Metric and US unit systems. It set out a calculation header so that your calculations can be easily understood by a reader and information that allows another user to use the calculation in the confidence that thecalculation is correct. The template calculation includes the following headers:

Purpose of calculation
All calculations should set out the objective of the calculation so that it can be readily understood.

Calculation Reference
All calculation reference material should be listed so that readers can trace the source material if necessary.

Calculation Validation
Validation of a calculation is provided by evidence that demonstrates that the calculation is correct. Traditionally this evidence is provided by:
  • Reproduction of a published calculation.
  • Reaching the same answer by an alternate method.
  • Independent checking by a colleague.

At ExcelCalcs.com check the calculation download page for user comments which endorse or verify the calculation. Always try to leave any such comments yourself if you are able to do so.  This is much appreciated by the community and adds great value to the download.

Calculation Units
Select a consistent set of units using the drop down list box so if you select the SI units system when you enter the formula“=speed” in a cell “m/s” will be shown. If you then change the units system to the US Unit (ft) system the same formula will show “ft/s”. The ExcelCalcs template uses a table of compatible units which can be found in hidden rows 1 to 10 starting at cell AC1. The advantage of using the table is that all formulas are valid for whatever system of units you select. This is all achieved using named cells in cells AC2 to AV2 (all names on sheet are listed in the drop down box to the left of Excel’s formula entry bar). They comprise:

Length, Mass, Time, Temp, Angle, AngleD, Area, Volume, Speed, Accel, Force, Stiffness, LDForce, Work, Energy, Power, Density, Pressure & Stress.

A sketch is an essential part of any calculation to help readers visualise the problem.

Version History

Check the version history to see how this calculation has changed over time.

Submitted On:
03 Jun 2011
Submitted By:
File Date:
03 Jun 2011
File Version:
File Size:
92.00 Kb
File Type:
This download requires the XLC Add-in for Excel to be installed.
stars/4.gifTotal Votes:18
HTML Link:
Copy code below to your web page to create link to this page:
HTML Window:
Copy code below to your web page to create a dynamic window to this download:
Like This?:
View the profile of the person who submitted this calculation and see all their other calculations hosted at ExcelCalcs.
Need Help?:
Use the comment feature below to raise any questions relating to this download. The question will be automatically emailed the author and all users subscribing to this comment thread.


#6 Atherton62 2016-08-02 16:12
Thanks John, had a brief review of spreed sheet functionality, this is cool. good upload.
#5 crystalinv 2010-12-06 17:57
Just downloaded it. watched your YouTube tutorial and its really perfect. simple but extraordinary. keep up the good work...
#4 relu59 2010-09-07 17:26
#3 Don Thompson 2008-07-02 08:08
#2 chapman01956 2008-03-14 13:24
John, Thank you for your contributions to xlc. The YouTube presentation is great.

Please sign in or register to add a comment.

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.



Real Time Analytics