Free XLC upgrade!
Older versions of XLC will cease to work on 30th September 2007. Collect your upgrade now. (see FAQ's for why XLC has an expiry date).
XLC addin version 09.07 - Excel 2007 compatible!
Description - XLC software enhances MS Excel so that cell formulae can be displayed as mathematical equations and your worksheets read like maths textbooks. Previous versions of this software have been downloaded 6398 times.
Installation - Download and unzip the installation file. Run setup.exe. When you next start MS Excel you will see the XLC toolbar. For a quick start go to the on-line help tutorials.
Manual Installation Method - Many users are not given software installation rights at work and this prevents installation of XLC using the setup program. Users may be interested to not that there is a manual installation method available which may get around this problem.
Forum Link
Comment upon or discuss this in the Forum.
Calculation Repository Update
There have been some great new calculation uploads this week. Many thanks to ExcelCalcs users mstickma, b1akeh, dino & Clyde! One of the files was in response to a 'Repository Request' made in the forum. I have added a couple of 'repository requests' of my own. Is anyone prepared to take them on? (see circular motion and pendulum motion). Is'nt it time you uploaded a calculation?
Snap Fit Beam Calculator.xls
Snap Fit Stress/Strain Calculator: Calculate
stresses, strain based on inputs for the snap fit beam parameters.
Submitted By: mstickma
Calculation Reference
http://www.solvayadvancedpolymers.com - SnapFitDesign.pdf
Useful Books
Snap-fit Handbook
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Joining of Plastics
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Injection Moulding
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Designing Plastic parts
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
AASHTO-LRFD_Slab.xls
AASHTO 2004 LRFD SLAB DESIGN: This spreadsheet was created to
aid in the rapid design and/or checking of Bridge Decks or Reinforced Concrete
Boxes in accordance with AASHTO 2004 LRFD. The 2nd Bar layer is particularly
handy for different bar sizes used in the same layer, such as in Bridge Deck
Cantilevers.
Submitted By: b1akeh
Calculation Reference
AASHTO LRFD
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Tank level.xls
Calculation of time taken for level to drop from H to H1 in a
tank with known diameter and discharge piping (length, diameter, fittings).
Direct(integrated) and iterative methods have been used to check the accuracy.
Author Dino Dzananovic.
Submitted By: dino
Calculation Reference
Fluid Mechanics
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Hydraulics
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Three buckling cases considered on separate
worksheets (many more cases are available in the calculation reference).
1)
Calculate the buckling stress of a flat plate subject to shear load.
Edges a
& b simply supported.
2) Calculate the buckling stress of a flat
plate.
Edges a & b simply supported 3) Calculate the buckling stress of a
flat plate. Edges b simply supported; one edge a clamped the other free.
Calculation Reference
Roark's Formulas for Stress and
Strain
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find
on Amazon.ca |
Motion Calculations.xls
There are four physical quantities associated with
motion calculations: position (x); its first derivative, velocity (v); its
second derivative, acceleration (a), and of course, time (t). These quantities
are related by several familiar equations, which can in turn be expanded by
substitution to cover any combination.
Submitted By: Clyde
Calculation Reference
Systems in Motion
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
This is big download from www.pipingdesign.com (over 3Mb) but it is a real swiss army knife for piping engineers. Here is a listing of all the worksheets included:
150 lb.
150 lb. (M)
1500 lb.
1500 lb. (M)
1500 lb. RJT
1500 lb. RJT (M)
300 lb.
300 lb. (M)
600 lb.
600 lb. (M)
900 lb.
900 lb. (M)
900 lb. RJT
900 lb. RJT (M)
Adding Calculator
Angles
Bolts
Brace Formulas
Channels
ELL. Head Dim
ELL's
Flanges
Flg Weights
Girder wt
Grating
HP Shapes
Ladders
M Shapes
MC Channels
Oblique Triang.
Pipe Spans
Pipe Tables
Rt. Triang.
S Shapes
S Tees
Screwed Fittings
Screwed Fittings (M)
Stairs
Tee's & Reducers
Tubing
Vessel Platf.
W Shapes
W Tees
Weights
Weld-o-Lets
Weld-o-Lets (M)
The sheets are password protected but you can unprotect them with the following password "ABB". There are plenty of other good utilities for piping engineers on http://www.pipingdesign.com.
Calculation ReferencePiping Calculations Manual
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Pipeline Rules of Thumb Handbook
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Piping Design Handbook by John J. McKetta
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Piping Handbook by Mohinder L. Nayyar
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Am! azon.de | Find on Amazon.ca |
The Fundamentals of Piping Design
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Pocket Guide to Flanges
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Piping Databook by Mohinder L. Nayyar
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Am! azon.de | Find on Amazon.ca |