Roark

1
Roarks Formulas for Excel Universal Technical Systems, Inc. www.uts.com
2
The perfect marriage...
Between two great engineering tools.
3
Excel provides a calculation tool that everyone
uses and knows...
4
Roarks gives you the formulas to solve thousands
of problems...
5
Put them together and design analysis becomes a
Snap!
6
Roarks Formulas for Stress and Strainby Warren
Young Richard Budynas

• Ultimate reference for designers, engineers and
  analysts who make design calculations for
  stresses, deflections, etc.
• Provides you with the required formulas in an
  easy-to-use, thumb-through format.
• Imagine these same formulas, ready to solve, in
  Excel...

7
With Roarks for Excelyou can

• Enter your numbers and get solutions instantly.

8
With Roarks for Excelyou can

• Enter your numbers and get solutions instantly.
• Create plots of deflection, stress, bending
  moments and more.

9
With Roarks for Excelyou can

• Enter your numbers and get solutions instantly.
• Create plots of deflection, stress, bending
  moments and more.
• Solve problems with multiple loads.

10
Create Reports with Diagrams from the Book
11
With Roarks Formulas...

• Analyze design alternatives without hours of math
  or programming.
• No need to use look-up tables for coefficients.
• Material data is set up for you...
• Or add your own custom materials.

12
Lets see how Roarks for Excel solves a typical
problem...
13
Launch
Roarks is launched from a toolbar on your Excel
menu.
14
Menu

• The easy-to-use menu takes you through hundreds
  of cases to find the one you need to solve your
  problem.
• Diagrams of each case appear just like in the
  book, making the selection of the proper case and
  load condition easy.

15
Setup
Once you have chosen your case RFE will ask you
to decide which inputs, outputs, plots and tables
you would like to see, which will help you
customize your screens and reports.
16
Load

• RFE loads all the information into Excel and
  provides starting values.
• Table look-ups for coefficients are already done.
• Enter your values and Excel calculates your
  solution.

17
Materials
You can select from a wide range of materials or
enter your own.
18
Plots
Plots are created when appropriate for the case,
including

• Deflection
• Shear
• Slope
• Bending Moment
• And more

19
Report Wizard

• Reports can be created with custom headings and
  logos.
• Change fonts or margins.
• Save your report as PDF or RTF.
• Diagrams from the book are included in the report.

20
Superposition Wizard

• To calculate multiple loads on beams and plates
  the Superposition Wizard does the trick.
• A special report showing the combined loads is
  generated.

21
Power User Mode
For those of you who want more flexibility in
your known and unknowns, the power user mode can
be used.
22
From a Professional Standpoint...
This product is awesome! Both the idea of
implementing Roark in Excel as well as how UTS
has done it are brilliant. No engineer should be
without it.    --Tom MincerSpreadsheetWorld.com
Well known pioneer and educator in the
application of Excel/VBA in the field of
Engineering
23
From a Professional Standpoint...
As a TK Solver / Roark user of nearly two
decades, I am very impressed to see that Roark's
formulas is now presented as a robust plug and
play module within Excel.Just select the
model(s) you want, select the parameters of
interest, solve and then click to produce a well
presented report that clearly and accurately
presents the data in a coherent and
understandable form for your peers.If a picture
paints a thousand words, then Roark's Formulas
for Excel solves a million Engineering problems.
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 judgement and
results. --Mike HaglandSenior Materials Analyst
Gyrus Medical Limited
24
From a Professional Standpoint...
UTS looks like they have another winner on their
hands. First they merged one of the most popular
engineering references with TK Solvers
backsolving capability to create Interactive
Roarks Formulas for TK Solver. It is an
application that simplifies an engineers life
immensely. I cant count the hours it has saved
me from recreating spreadsheets from a textbook.
Now, UTS has done it again. Theyve taken the
same powerful application and wrapped it in
arguably the most widely used engineer's tool
amazing. UTS continues to be the best kept secret
in the engineering software world. --Wayne
PilgrimWeatherford Incorporated
25
Additional Resources
Along with your copy of the Roarks Formulas for
Excel software, you will also receive

• PDF Documentation with an example from each table

• Telephone and Email Support

26
Try this great combination for yourself....
Download a
Free Trial
Today!
For more information, Contact
Universal Technical Systems, Inc. Universal Technical Systems, Inc. Universal Technical Systems, Inc.
USA and Worldwide Europe India
4053 North Perryville Road Loves Park, Illinois 61111 USA Phone [phone] Fax [phone] Email sales_at_uts.com 2 Richmond Road Bedford, MK40 3DG United Kingdom Phone [phone] Fax     [phone] Email euro_at_uts.com 1-B Rohit Residence No. 1-1A/1,2,3 Baner Road Pune 411 045 INDIA Phone [phone] Phone [phone] Email sales_india_at_uts.com