We all make mistakes - Last week I posted a calculation to determine the centre of a circle knowing three points on its circumference. Within 10 minutes of uploading ExcelCalcs user xmarks102 drew my attention to an error via the forum, the calculation was immediately corrected and reissued to version 1.2. Xmarks102 did me a great service as I was using the calculation at the time. This demonstrates the benefits of uploading and working together with the ExcelCalcs Community and thanks again xmarks102!
Who's gagged? - More forum comments required!
Always rate and comment on document downloads to help other users by:
Guiding other users to good content on the site.
Leaving links to related internet resources.
Thanking authors.
Pointing out any errors.
Four ExcelCalcs Users prove that they are no plunderers - I was pleased to receive uploads from ExcelCalcs users IanFitzJo, asidler, TerryFoxon & ALIMA in response to my request in the last newsletter. They all made debut repository uploads. Well Done! Isn't it time you contributed rather than plundered too?
REPOSITORY NEWS
New items uploaded since the last newsletterThis file contains user-defined functions for many of the thermodynamic and physical properties of water (saturated liquid and saturated/superheated steam). In order to make use of these, the user will need to open the VB modules and copy them into his/her own calculation. One of the modules is a series of functions for converting between metric, English and Imperial units. I hope the front sheet will give users a good idea about how to use the functions.
Calculation Reference
Thermodynamic and Transport Properties of Fluids -
Rogers and Mayhew
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Comment upon or discuss this document in the Forum
IBC 2006 Seismic Calc.xls
The IBC 2006 Seismic Calc contains three
worksheets:
1): Base shear calculation using the Equivalent Lateral Force
Method IBC 2006 and ASCE 7-05
2): Seismic Vertical Force Distribution based
on the IBC 2006 and ASCE 7-05
3): Rigid Diaphragm Horizontal Distribution
based on IBC 2006 and ASCE 7-05
Calculation Reference
2006 International Building Code
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find
on Amazon.ca |
Forum Link
Comment
upon or discuss this document in the Forum
This spreadsheet was developed to calculate the tension
and sag of a wire over a wide temperature range. Calculations such as these are
required and made by utility companies before stringing new aerial transmission
lines. The calculation here is based on a theory by A. C. Gholke - my effort is
pretty amateurish but I'd appreciate comments from other contributors.
Forum Link
Comment
upon or discuss this document in the Forum
NABC.XLS
For evaluating net allowable bearing capacity of shallow
foundations on granular soils:
Calculation Reference
2006 International Building Code
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find
on Amazon.ca |
XLC Version 09.07 Beta Release - Click here for XLC version 09.07 - first version to work with Excel 2007!
Until recently I had not bought myself a copy of Excel 2007 (I
assumed that XLC would just work with the latest version). Using the site forum Excel Users Clyde and ZeroSignal alerted me to
some XLC addin compatibility issues with Excel 2007 which I have now
addressed. I would welcome some feedback before I put it up for general release
- here is the forum topic link . Thanks for your help Clyde & ZeroSignal!