T Ultima e REFERENCE - Roark's Formulas

1 Roark s Formulas for Excel Long considered the most popular engineering handbook,Roark s Formulas for Stress and Strainhas been helping engineerssolve design problems for more than 60 years. Universal TechnicalSystems, Inc. (UTS) takes it one step further with Roark s Formulasfor Excel,a fully interactive version of the landmark referencecombined with powerful problem solving technology thatdramatically reduces design hours, production costs, and speedstime to not just words and Formulas on a page,but completely automated stress analysis of a comprehensiverange of structural components right on your desktop! Since its first publication,Roark is in constant use by mechanical,aerospace, civil,and many other types ofpracticing and powerfulRoark s Formulas for Stress and Strainhas been thoroughly user tested and incontinuous use since 's Formulas for Excel takes every table and casefrom the 7thedition and makes it interactive, includes calculations for all cases andtables with accompanying diagrams to help streamline the design process andreduce design iterations, as well as the need for complicat ed finite addition,International System of Units (SI) and United States Customary Units(USCU) conversion is automatic with Roark s Formulas for Excel,making worksharing among engineers easier than ever.

2 T he user friendly menu system lets youselect a problem by chapter, table, and case exactly as it is in the ,here is where the similarities formatted plots of deflection,stress, and bending moments let you refine thedesign like never before. What s more, a powerful math engine, with the uniqueability to solve for a variety of combinations of input and output variables (knownas backsolving),allows you to easily test what if scenarios and optimize designswithout hours of tedious calculations or programming. J ust point, click,and s Formulas for Excel at a GlanceRoark s Formulas for Excel includes a Superposition Data Entry Wizard,handlingmultiple load calculations on beams and plates with ease, creating plots of stress,deflection,and shear for the combined loads, every step of the way. What used totake hours now takes a matter of minutes! Interactive Calculations for all cases and tables Dynamic Plot Annotations for data analysis and visualization Full Mat erials Database for streamlined data entry Automatic Unit Conversion for model sharing flexibility Report Wizard for on demand custom reporting Superposition Wizard solves multiple loads on beams and platesTHEU ltimateREFERENCEI mage_1_1044=EMBED(" 10 Type a question for helpSheet2 Sheet1 ReadyNUMS heet312345678910111231321314151617181920 21222324252627282930 ABCJC hapter Eleven: Flat Plates TABLES Annular plate with a uniformly distributedCase: 2d Supported, FixedRoark's Formulas for ExcelInputValueUnitOutputValueUnitmatnum r0rqabtininininin200 1"Steel - A.)

3 S. T. M. A7-61T "29000000 '_'_caution 2 Material nameYoung's ModulusPoisson's ratioThickness CheckAnnular platesSupported, FixedSupported Condition:Beam Type:Load:Outer Radious:Inner Radious:PlateThickness:Uniform annular line load:Radious to annular line load:21405080ininReset AllCloseShow Combined for Load ConditionLoad Results for current load conditionResults for current load conditionTable , Case 1 [1d Supported, Fixed]Table , Case 1 [1d Supported, Fixed]Uniform annular line loadUniform annular line loadSteel - A7-61 TSteel - A7-61 Tnu: :E: Outer edge simply supported, inner edge fixedOuter edge simply supported, inner edge fixedpsiBottom Line:Roark s Formulas for Excel gives you the ability to tackle design challenges that would otherwise be too complicated or costly to attemptThe first software edition of Roark s Formulas , designed for TK Solver, was releasedby UTS in 1989,and was quickly received by consumers as a design engineer sdream, as described by Professor Warren Young, the co author of Roark s Formulasfor Stress and UTS is taking the next step by making their popularsoftware available to Excel s Formulas for Excel is available for Microsoft Excel 2000 and higherrunning on Microsoft Windows 2000 and XP s Formulas for Excel ALL TRADEMARKS ARE REGISTERED TO THEIR RESPECTIVE COMPANIES.

4 UTSR12 2005 2012 About Universal technical Systems, technical Systems, Inc., established in 1984,is the leading provider of high productivity problem solving software products and custom developedsolutions. With headquarters in Rockford, Illinois and subsidiaries in the UK and India,UTS serves customers worldwide. For over twenty years UTS has focusedexclusively on providing solutions that help companies in the scientific, engineering, operations research and management, and financial communities simplifycomplex calculations and streamline the processes that drive their businesses. UTS products and custom solutions are available for desktop and web technical Systems, Inc.,202 West State Street, Suite 700,Rockford,IL 61101,USATel:+1 815 963 2220 Fax:+1 815 963 8884 Canada Sales:800 435 for more information and online software This product isAWESOME!

5 Both the idea of implementingRoark in Excel as well as howUTS has done it are brilliant. No engineershould be without it. Dr. Tom Mincer Well known pioneer and educatorin the application of Excel/VBAin the field of Engineering rwoOuter edge fixed, inner edge guidedCase 1: Location [in] inMoment Concentrated Intermediate Load0-10000-20000-30000-40000 Distance from Left End [in]0 1020 30 40 50 6070 80 Moment lbf-inCase 1: Slope Location [in] Angle radPre formatted plots of deflection,stress, and bendingmoments let you refine the design like never user friendly menu system lets you select a problemby chapter, table, and case exactly as it is in the help streamline the design process and reduce design 10 Annular platesSupported, FixedSupported Condition:Beam Type:Load:Outer Radious:Inner Radious:PlateThickness:Uniform annular line load:Radious to annular line load.

6 21405080ininReset AllCloseShow Combined for Load ConditionLoad Results for current load conditionResults for current load conditionTable , Case 1 [1d Supported, Fixed]Table , Case 1 [1d Supported, Fixed]Uniform annular line loadUniform annular line loadSteel - A7-61 TSteel - A7-61 Tnu: :E: Outer edge simply supported, inner edge fixedpsiMETALS matlmatnumGEnugammaMaterialsMaterialsAlu minum - cast, pureYoung' - cast, 220 T4 Aluminum - wrought, 2014 T6 Aluminum - wrought, 6061 T6 Beryllium copperBrass - navalBronz - Phosphor, iron, gray, no. 20 Cast iron, gray, no. 30 Cast iron, gray, no. 40 Cast iron, gray, no. 601234567891011432567891011121314 Return to SpreadsheetUpdate Materials TableRoark's Formulas for Excel - TablesFull Customizable Materials DatabaseSuperposition WizardC:\Program Files\UTS\ Roark's Formulas for Excel\TKRoark's Formulas for ExcelRoark's Formulas for ExcelCompany LogoReport HeaderReport FooterBack ColorInputsPlotsNameCommentPage break between inputs and outputsOKCancelsection1 Section6 - Wide Flanged BeamOutputsFontArialFore ColorRoark's Formulas for Excel - Report WizardReport Wizard and Sample Report A Designer s Universal technical Systems (India),Pvt.

7 Ltd.,1-BRohit Residence,1-1A/1,2,3 Baner Road, 411045 Pune, Maharashtra State,IndiaTel:+91 20 2729 0306 or +91 93716 12493 technical Systems (Europe),Ltd.,2 Richmond Road,Bedford,MK40 3DG,UK (0) 1234 302 618 Fax:+44 (0) 1234 296 587