# Excel Technical Calculation - PowerPoint by kxx13921

VIEWS: 0 PAGES: 26

• pg 1
```									Roark’s Formulas for Excel   Universal Technical Systems, Inc.   www.uts.us.com
The perfect marriage...

Between two great engineering tools.
Roark’s Formulas for Excel      Universal Technical Systems, Inc.   www.uts.us.com
Excel provides a
calculation tool that
everyone uses and
knows...

Roark’s Formulas for Excel   Universal Technical Systems, Inc.   www.uts.us.com
Roark’s gives you
the formulas to
solve thousands of
problems...

Roark’s Formulas for Excel   Universal Technical Systems, Inc.   www.uts.us.com
Put them
together and
design analysis
becomes a

Snap!

Roark’s Formulas for Excel   Universal Technical Systems, Inc.                 www.uts.us.com
Roark’s Formulas for Stress and Strain
by 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...

Roark’s Formulas for Excel    Universal Technical Systems, Inc.             www.uts.us.com
With Roark’s for Excel
you can:
    Enter your numbers and
get solutions instantly.

Roark’s Formulas for Excel   Universal Technical Systems, Inc.   www.uts.us.com
With Roark’s for Excel
you can:
    Enter your numbers and
get solutions instantly.
    Create plots of deflection,
stress, bending moments
and more.

Roark’s Formulas for Excel    Universal Technical Systems, Inc.   www.uts.us.com
With Roark’s for Excel
you can:
    Enter your numbers and
get solutions instantly.
    Create plots of deflection,
stress, bending moments
and more.
    Solve problems with

Roark’s Formulas for Excel    Universal Technical Systems, Inc.   www.uts.us.com
Create Reports with Diagrams from the Book

Roark’s Formulas for Excel   Universal Technical Systems, Inc.   www.uts.us.com
With Roark’s 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.

Roark’s Formulas for Excel   Universal Technical Systems, Inc.   www.uts.us.com
Let’s see how Roark’s
for Excel solves a
typical problem...

Roark’s Formulas for Excel   Universal Technical Systems, Inc.   www.uts.us.com
Launch

Roark’s is launched
from a toolbar on

Roark’s Formulas for Excel   Universal Technical Systems, Inc.   www.uts.us.com

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

Roark’s Formulas for Excel   Universal Technical Systems, Inc.   www.uts.us.com
Setup

Once you have
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.

Roark’s Formulas for Excel   Universal Technical Systems, Inc.   www.uts.us.com

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

Roark’s Formulas for Excel   Universal Technical Systems, Inc.   www.uts.us.com
Materials

You can select from a wide range of materials
or enter your own.

Roark’s Formulas for Excel     Universal Technical Systems, Inc.   www.uts.us.com
Plots

Plots are created when appropriate for the
case, including:

       Deflection
       Shear
       Slope
       Bending Moment
       And more

Roark’s Formulas for Excel   Universal Technical Systems, Inc.                www.uts.us.com
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.
Roark’s Formulas for Excel   Universal Technical Systems, Inc.   www.uts.us.com
Superposition Wizard

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

Roark’s Formulas for Excel       Universal Technical Systems, Inc.   www.uts.us.com
Power User Mode

For those of you who want more
flexibility in your known and unknowns,
the power user mode can be used.

Roark’s Formulas for Excel           Universal Technical Systems, Inc.   www.uts.us.com
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 Mincer
Well known pioneer and educator in the application of
Excel/VBA in the field of Engineering

Roark’s Formulas for Excel      Universal Technical Systems, Inc.                   www.uts.us.com
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 Hagland
Senior Materials Analyst
Gyrus Medical Limited

Roark’s Formulas for Excel        Universal Technical Systems, Inc.                      www.uts.us.com
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 Solver’s backsolving capability
to create Interactive Roark’s Formulas for TK Solver. It is
an application that simplifies an engineer’s life immensely.
I can’t count the hours it has saved me from re–creating
spreadsheets from a textbook.

Now, UTS has done it again. They’ve 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 Pilgrim
Weatherford Incorporated

Roark’s Formulas for Excel       Universal Technical Systems, Inc.                        www.uts.us.com
Along with your copy of the
Roark’s Formulas for Excel
software, you will also
•Hardcover, 7th Edition of
Roark’s Formulas for Stress
and Strain

•PDF Documentation with an
example from each table
•Telephone and E-
Mail Support
Roark’s Formulas for Excel   Universal Technical Systems, Inc.      www.uts.us.com
Try this great combination for yourself....

Free Trial
Today!
Universal Technical Systems, Inc.
USA and Worldwide          Europe                                    India
202 W State Street         2 Richmond Road                           1-B, Rohit Residence, S.
Suite 700                  Bedford, MK40 3DG,                        No. 1-1A/1,2,3 Baner Road
Rockford, Illinois 61101   United Kingdom                            Pune
Phone: (815) 963-2220      Phone : (44) (0) 1234-302-618             411 045
Fax: (815) 963-8884        Fax : (44) (0) 1234-296-587               INDIA
Email: sales@uts.us.com    Email : euro@uts.us.com                   Phone : (91) 20-2769 1200
Fax : (91) 20-2769 1500
Email : sales_india@uts.us.com

Roark’s Formulas for Excel         Universal Technical Systems, Inc.                       www.uts.us.com

```
To top