Roark’s Formulas for Excel a “Confidence Booster”

January 2006

Lots of TK Solver users will tell you about its ease of use. If you want to hear about TK’s power as a programming environment, ask Dr. Kurt Lund.

Mike Hagland  
Home: UK  
User Since: Late 1980's  
Uses Roark's Formulas for Excel For: Designing keyhole surgery devices  

Recently Universal Technical Systems, Inc. has added a new product to their line of high-productivity problem-solving software products and custom developed solutions: Roark’s Formulas for Excel.

Since its first release in 1938, Roark’s Formulas for Stress and Strain, by Warren Young and Richard Budynas, has been used by engineers all over the world for engineering design. It contains over five thousand formulas on shells, plates, beams, bars, columns, and other components, making it the ultimate resource. Roark’s Formulas for Excel combines this indispensable tool with one of the most widely used spreadsheet programs: Microsoft Excel.

Roark’s Formulas for Excel follows the book’s organization of formulas by chapter, table and case. With the entire collection of formulas pre-programmed and ready to use at the click of a button, Roark’s Formulas for Excel makes applying multiple formulas even faster and easier than before. Simply open the application in Excel, load the model in the format you wish and watch the formulas come alive in this truly interactive software that allows you to input values and solve. Roark’s well organized format allows for easy access and rapid results.

“If a picture paints a thousand words, then Roark's Formulas for Excel solves a million Engineering problems,” says Mike Hagland, one of the first to take Roark’s Formulas for Excel for a test drive. “I look forward to using it alongside my regular finite element stress analysis software and actual mechanical testing as a confidence booster to give accurate engineering judgment and results."
Mike Hagland is no stranger to engineering design; he is a Senior Materials Analyst for Gyrus Medical Limited in the UK. He uses TK Solver, (Universal Technical Systems’ powerful problem solving engine behind many of their products), to design keyhole, or “minimum access,” surgery devices, combining precision instrument design with radio frequency energy delivery.
Hagland has a Mechanical Engineering Degree from the Polytechnic of Wales; 20 years design / test / technical services experience in the diaphragm valve industry; and 8 years in the medical device industry, where he works with stress analysis, design, materials analysis, and theoretical simulation from prototype stage through to production.
Hagland has used Interactive Roark’s Formulas since the late 1980’s for testing for data analysis, CAD design, finite element stress analysis, spring design, wire heating formulae, ceramic materials data analysis (Weibull Modulus routines), and more. For Hagland,
Interactive Roark’s Formulas handles routines in such a way that makes building up a working model a breeze compared to writing programs in BASIC code.
Roark’s Formulas for Excel takes the same powerful problem solving tool, with thousands of ready-to-use formulas, and places it in an extremely accessible platform with which most are already familiar.
“Obviously, the main benefit for me is that it is a tool for all stages of a design project,” says Hagland. “On a Friday afternoon pressure job I can often load up a previous model I have for a certain case and quickly input relevant data to give a sound, accurate response to resolve issues. Used in conjunction with FEA, I have a powerful set of analysis tools at my disposal.
“I use [it] on nearly every project I work on, almost as second nature, [including] any preliminary calculations for mechanical or electrical analysis to give confidence in a design. I also use it for failure mode analysis, such as fracture / stress concentration, etc.”
As for the quality and responsiveness of support received from UTS? “[UTS] has always sorted out any problems quickly,” says Hagland.