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.
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 NEWSNew items uploaded since the last newsletter
This 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.
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
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.
For evaluating net allowable bearing capacity of shallow foundations on granular soils:
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!