Home

Clipboard

Control Elements:

Paste
Inserts the clipboard contents
Menu:
- Paste Link
  Inserts a reference to the clipboard contents
- Paste Deep
  Inserts a copy of the clipboard contents
- Paste Format
  Apply Formats to the selected Component
- Paste Special...
  Pastes formats or other selected items from the clipboard
Cut
Cuts the selection and moves it to the Clipboard
Menu:
- Delete
  Deletes the selection
- Delete All
  Erases everything
- Delete Formats
  Erases formatting
- Delete Contents
  Erases values
- Delete Properties
  Erases properties
- Delete Permanently
  Deletes the selected items permanently from the current list and the original
Copy
Copies the selection to the Clipboard
Menu:
- Copy URL
  Puts the URL of the current worksheet into the system clipboard
- Copy Worksheet
  Copy the current worksheet
Apply Format
Applies format settings from a source to one or more targets
Menu:
- Define
- Other...

Methods

Control Elements:

Add Tool
Inserts a new method or tool from the template catalog

Insert

Control Elements:

Insert Item After
Inserts a single item after/below the selected item
Insert Sub Item
Inserts a single item as subitem of the selected item
Insert Parameter
Inserts a single item as subitem of the selected item and marks it as parameter
Insert Next Item
Inserts an item of the next matrix
Insert Next Parameter
Inserts a parameter of the next cascaded matrix
Insert
Insert
Insert Item Before
Inserts a single item before/above the selected item
Insert Layer
Adds a new item to this layer
Insert Task
Adds a task to the list of tasks
Menu:
- FMEA Current Control
- FMEA Optimization
- FMEA MSR Current Control
- FMEA MSR Optimization
- Enable MSR
- Select...

Focus

Control Elements:

Show all
Toggle display of paramters and system elements
Menu:
- Show System Elements
  Show system elements only
- Show Parameters
  Show parameter items only
- Show All
  Show items of all types
- Show Constraints
  Show or hide items marked as constraints
- Show Notes
  Show or expand notes and images
- Convert To
  - Convert To Parameter
    Marks the selected item as parameter
  - Convert To System Element
    Marks the selected item as system element
  - Convert To Comment
Set Focus
Sets the focus on the selected item or releases the focus again
Insert
Insert

Knowledge

Control Elements:

Knowledge
Functions to document knowledge and additional information
Menu:
- No Knowledge
  Use this state to indicate that the value has not been confirmed yet
- Assumed
  Use this state to indicate that there is some evidence for this value
- Confirmed
  Use this state to indicate that the value has been confirmed
- Effect Unlikely
- Confirmed not relevant
  Indicates that there is definitely no correlation
- Unknown
Priority
Sets the priority of the selected item
Menu:
- Very High
- High
- Middle
- Low
- Very Low
- None
- Constraint
- Clear All
Insert Picture
Insert a picture from a file into the selected cell
Insert Task
Adds a task to the list of tasks
Insert Comment
Inserts a comment to the selected item
Attach Document
Import an external document into the workbook
Progress
Sets the progress state of the selected item
Menu:
- Not Started
- Started
- 50% Completed
- 75% Completed
- Completed
- Discarded
- Clear
Category
Changes the category (color) of the selected item
Menu:
- None
- Define...
  Setup user States

FMEA

Control Elements:

Severity
Sets the serverity for the selected failure effect
Menu:
- 10: Hazardous without warning
- 9: Hazardous with warning
- 8: Very High
- 7: High
- 6: Moderate
- 5: Low
- 4: Very Low
- 3: Minor
- 2: Very Minor
- 1: None
- Unknown
Detection
Sets the probability of detecting the selected failure cause
Menu:
- 10: Absolute Uncertainly
- 9: Very Remote
- 8: Remote
- 7: Very Low
- 6: Low
- 5: Moderate
- 4: Moderately High
- 3: High
- 2: Very Minor
- 1: Almost Certain
- Unknown
Occurence
Sets the occurence for the selected failure cause
Menu:
- 10: Very High (>100000 ppm)
- 9: Very High (>50000 ppm)
- 8: High (>20000 ppm)
- 7: High (>10000 ppm)
- 6: Moderate (>5000 ppm)
- 5: Moderate (>2000 ppm)
- 4: Moderate (>1000 ppm)
- 3: Low (>500 ppm)
- 2: Low (>100 ppm)
- 1: Remove (<10ppm)
- Unknown
- Probability
Insert Task
Adds a task to the list of tasks
Attach Document
Import an external document into the workbook
FMEA
Frequency
Sets the MSR frequency Rating
Menu:
- 10: Extremely high
- 9: High
- 8: High
- 7: Medium
- 6: Medium
- 5: Medium
- 4: Low
- 3: Very low
- 2: Extremely low
- 1: Cannot occur
- Unknown
Monitoring
Sets the MSR monitoring rating
Menu:
- 10: Not effective
- 9: Very low
- 8: Low
- 7: Moderately low
- 6: Moderate
- 5: Moderate
- 4: Moderately High
- 3: High
- 2: Very High
- 1: Reliable
- Unknown
Category
Changes the category (color) of the selected item
Menu:
- None
- Define...
  Setup user States

Format

Control Elements:

Sort && Filter
Sort and filter items
Menu:
- Auto Filter...
  Sort and filter items
- Reset Filter
  Removes all filters on the worksheet
- Advanced Filter Options
  Selects advanced filter and sorting criteria for the list
- Sort Smallest to Largest
- Sort Largest to Smallest
- Filter
- Apply Filter Again
  Activates the last defined filter again
- Filter: Parameters
  Show parameter items only
- Filter: System
  Show system elements only
- Filter: All
  Show items of all types
- Filter: Constraints
  Show or hide items marked as constraints
- Filter: Empty
Highlight Priority
Highlights cells that have a priority
Highlight Knowledge
Highlights cells according to its knowledge state
Highlight Conditional Formats
Shows the colors according to conditional formatting rules
Format
Format
Set Focus
Sets the focus on the selected item or releases the focus again

Open

Control Elements:

Open
Open an existing document
Close
Closes the active document

Copy

Control Elements:

Copy
Copies the selection to the Clipboard
Menu:
- Copy URL
  Puts the URL of the current worksheet into the system clipboard
- Copy Worksheet
  Copy the current worksheet

Print

Control Elements:

Print
Prints all or part of the document
Print Preview
Displays full pages
Page Setup
Changes the page layout settings
Publish Report
Publishes the report to a remote location

Font

Control Elements:

Font
Selects font for the current selection
Font Size
Shows the selected font size
Wrap text
Wraps the selected text
Formats the selected text bold\Bold
Formats the selected text bold\Bold
Italic
Formats the selected text italic
Underline
Underlines the selected text
Larger
Increases the text size
Smaller
Decreases the text size
Horizontal
Changes the horizontal text alignment
Vertical
Changes the vertical text alignment
Fill Color
Changes the background color
Font Color
Changes the selected text's color
Frame
Shows or hides the component frame or parts of it
Show Item Numbers
Shows or hides the list's item numbers
Toggle Orientation
Toggles the text orientation of the selected component

Lines && Bars

Control Elements:

Line Color
Changes the line color
Line Style
Changes the line style
Line Symbol
Changes the symbol of this line
Increase
Increases the size of a marker
Decrease
Decreases the size of a marker
Lines && Bars

Diagram

Control Elements:

Shape
Select a shape
Line Color
Changes the line color
Line Style
Changes the line style
Start
Changes the style of the line's start point
End
Changes the style of the line's end point
Diagram

Numbers

Control Elements:

Percent
Show values as percent
Increase Decimal
Increase the number of decimal places
Decrease Decimal
Decrease the number of decimal places
Numbers
Opens the formatting property sheet

Fault Tree Analysis

Control Elements:

Probability
Sets the probability for an error event
Menu:
- A - Frequent (0.1)
  Sets the probability of an error event
- B - Probable (0.03)
  Sets the probability of an error event
- C - Occasional (0.003)
  Sets the probability of an error event
- D - Remote (0.00003)
  Sets the probability of an error event
- E - Improbable (0.000001)
  Sets the probability of an error event
- F
- G
- H
- I
- J
- Set 1
- Set 2
- Set 3
- Edit...
Knowledge
Knowledge
Menu:
- No Knowledge
  Use this state to indicate that the value has not been confirmed yet
- Assumed
  Use this state to indicate that there is some evidence for this value
- Confirmed
  Use this state to indicate that the value has been confirmed
- Confirmed not relevant
  Indicates that there is definitely no correlation
- Unknown
Priority
Sets the priority of the selected item
Menu:
- Very High
- High
- Middle
- Low
- Very Low
- None
- Constraint
- Clear All
Category
Changes the category (color) of the selected item
Menu:
- None
- Define...
  Setup user States
Fault Tree Analysis
Fault Tree Analysis

Conditional Formatting

Control Elements:

Conditional Formatting
Administrates the conditional formatting
Menu:
- Apply Formatting Here
  Show conditional formats on selected component
- Highlights Outliers
  - Color Gradient Red / Green
    Assigns items to one of two groups
  - Color Gradient Red - Amber - Green
  - Color Gradient 3 Steps (Shades of Blue)
  - Color Gradient 3 Steps (Shades of Green)
  - Color Gradient 3 Steps (Shades of Grey)
  - Color Gradient 4 Steps (Red to Blue)
  - Color Gradient 4 Steps (Shades of Blue)
  - Color Gradient 4 Steps (Shades of Green)
  - Color Gradient 4 Steps (Shades of Grey)
  - Color Gradient 5 Steps (Red to Blue)
  - Color Gradient 5 Steps (Shades of Blue)
  - Color Gradient 5 Steps (Shades of Green)
  - Color Gradient 5 Steps (Shades of Grey)
  - Highlight Cells Greater Than...
  - Highlight Cells Less Than...
  - Highlight Cells Between...
  - Highlight Cells Equal To...
  - Highlight Cells Text That Contains...
  - Highlight Top / Bottom Top N Items
  - Highlight Top / Bottom Top N % of Range Total
  - Highlight Top / Bottom Bottom N Items
  - Highlight Top / Bottom Bottom N % of Range Total
  - Highlight Top / Bottom Above Mean
  - Highlight Top / Bottom Above Median
  - Highlight Top / Bottom Below Mean
  - Highlight Top / Bottom Below Median
  - Highlight Top / Bottom Above Upper Quartile
  - Highlight Top / Bottom Below Lower Quartile
  - Highlights Outliers More Than N Std Dev Above Mean
  - Highlights Outliers More Than N Std Dev Below Mean
  - Highlights Outliers More Than 1.5 IQR Above Upper Quartile
  - Highlights Outliers More Than 1.5 IQR Below Lower Quartile
- Reset
  Removes all format definitions
Highlight Priority
Highlights cells that have a priority
Highlight Knowledge
Highlights cells according to its knowledge state
Highlight Conditional Formats
Shows the colors according to conditional formatting rules

Feedback

Did you find what you needed?

If you have any further questions or suggestions to improve this page, please let us know:

Welcome Back!

Login to manage your account

Forgot your password?

Not registered yet? Signup