Clipboard

en
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
      Stores the format settings of the selected component as a re-usable set.
    • Other...
      Shows a dialog with all sets of format settings. Use it to add / remove / edit sets of formats.

Font

en
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

en
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

en
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

en
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

Insert

en
Control Elements:
  • Insert Item Before
    Inserts a single item before/above the selected item
  • 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 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...
  • Insert
    Insert

Knowledge

en
Control Elements:
  • Knowledge
    Functions to document knowledge and additional information
    Menu:
    • No Knowledge
      Indicates that the value has not been confirmed yet
    • Assumed
      Indicates that there is some evidence for this value
    • Confirmed
      Indicates that the value has been confirmed
    • Assumed not relevant
      Indicates that there is probably no correlation
    • Confirmed not relevant
      Indicates that there is definitely no correlation
    • Unknown
  • Priority
    Sets the priority of the selected item
    Menu:
    • Very High
      Marks this element with a very high priority
    • High
      Marks this element with a high priority
    • Middle
      Marks this element with a middle priority
    • Low
      Marks this element with a low priority
    • Very Low
      Marks this element with a very low priority
    • None
    • Constraint
      Marks this element as a 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
      Changes the progress state
    • Started
      Changes the progress state
    • 50% Completed
      Changes the progress state
    • 75% Completed
      Changes the progress state
    • Completed
      Changes the progress state
    • Discarded
      Changes the progress state
    • Clear
  • Category
    Changes the category (color) of the selected item
    Menu:
    • None
    • Define...
      Setup user States

FMEA

en
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

Fault Tree Analysis

en
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
      Indicates that the value has not been confirmed yet
    • Assumed
      Indicates that there is some evidence for this value
    • Confirmed
      Indicates that the value has been confirmed
    • Confirmed not relevant
      Indicates that there is definitely no correlation
    • Unknown
    • Assumed not relevant
      Indicates that there is probably no correlation
  • Priority
    Sets the priority of the selected item
    Menu:
    • Very High
      Marks this element with a very high priority
    • High
      Marks this element with a high priority
    • Middle
      Marks this element with a middle priority
    • Low
      Marks this element with a low priority
    • Very Low
      Marks this element with a very low priority
    • None
    • Constraint
      Marks this element as a constraint
    • Clear All
  • Category
    Changes the category (color) of the selected item
    Menu:
    • None
    • Define...
      Setup user States
  • Fault Tree Analysis
    Fault Tree Analysis

Format

en
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
    • Filter: Related
    • Filter: Knowledge State
  • 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
  • Set Focus
    Sets the focus on the selected item or releases the focus again
  • Format
    Format

Conditional Formatting

en
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

Open

en
Control Elements:
  • Open
    Open an existing document
  • Close
    Closes the active document

Copy

en
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

en
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

Feedback

Did you find what you needed?

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

=