MACROS

1
MACROS
2
Is this your idea of saving time working
efficiently?
3
WHAT ARE MACROS?

• A MACRO is a series of commands and functions
  that are used to AUTOMATE repetitive tasks.
• In Exponent these tasks are
• Test Running and Control
• Data Analysis

4
WHY MACROS?

• Save TIME
• Multiple graphs analysed in one click
• Total CONTROL
• All major parts of test controlled
• ADVANCED functions
• Simplify complex analysis

5
MACROS OVERVIEW
MACRO name
6
AUTOMATING TESTING

• MACROS speed-up repetitive tests
• Control pre post-test tasks
• Command examples
• Calibration
• Sequence commands
• Product parameters
• File name save
• Printing

7
AUTOMATING TESTING

• Example MACRO

8
AUTOMATING ANALYSIS

• MACROS speed-up analysis
• Unlock calculation possibilities
• Perform complicated routines

9
AUTOMATING ANALYSIS

• Example MACRO

10
ADVANCED MACRO WRITING

• User defined variables
• Basic Commands
• MACRO based calculations
• Remove repetitive commands
• Can be conditional

11
ADVANCED MACRO WRITING

• Variable commands
• Defining variables
• Storing variables

12
ADVANCED MACRO WRITING

• IF/ENDIF

13
ADVANCED MACRO WRITING

• DO/WHILE

14
ADVANCED MACRO WRITING

• IF FAIL/IF NOT FAIL

15
MACRO BASED CALCULATIONS

• Efficient
• Control of results sheet
• Powerful

16
MACRO BASED CALCULATIONS

• Example
• Percentage Ratio of force loss during a hold test

17
MACRO BASED CALCULATIONS
60 Second Hold-Distance Test
Metal spring
Sponge
Honey
18
MACRO BASED CALCULATIONS
19
SUMMARY

• What have MACROS ever done for us?

• SAVE TIME
• CONTROL
• MAXIMISE

20
See the Feeling