FT Diagram Generation Aid Device Markup Conversion

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

The generation and modification of Fault Tree (FT) diagrams using spreadsheet programs like Excel are inefficient, requiring extensive knowledge and labor for editing, especially when adding, deleting, or modifying events.

Innovation Solution

A device and program that import and export FT diagrams from spreadsheet programs to markup language, allowing for easy editing of the tree structure, including functions for importing connection relationships, editing events, analyzing events, verifying consistency, and exporting modified diagrams back to the spreadsheet format.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Ease of manufacture

If FT diagrams are generated and edited using spreadsheet programs, then the diagrams can be created with high diffusion rate and accessibility, but the editing process becomes inefficient and labor-intensive

Engineering Contradiction:
ImproveAccessibility of toolVSAvoidEditing efficiency
Core Design Contradiction:
Ease of manufactureVSProductivity

Solution Approach 1:

The patent introduces a conversion program that acts as an intermediary between spreadsheet programs and markup language editors. This mediator converts FT diagrams from spreadsheet format to markup language format, enabling efficient editing while maintaining accessibility. The conversion program translates the visual spreadsheet representation into a structured markup format that supports easier modification and management.

Inventive Principle:
Principle #24Intermediary (Mediator)

2Adaptability or versatility

If FT diagrams are generated using spreadsheet programs, then they can be easily shared among engineers, but modification and maintenance become complex and time-consuming

Engineering Contradiction:
ImproveShareability of diagramVSAvoidTime for modification
Core Design Contradiction:
Adaptability or versatilityVSLoss of time

Solution Approach 1:

The patent changes the data format parameter of FT diagrams from spreadsheet format to markup language format. This parameter change enables more efficient storage, editing, and management of the diagram data. The markup language provides a structured representation that facilitates automated processing, version control, and easier modification compared to spreadsheet formats.

Inventive Principle:
Principle #35Parameter changes

3Reliability

If FT diagrams are created with extensive knowledge and specialization requirements, then the diagrams maintain high reliability and accuracy, but the generation process becomes complex and difficult

Engineering Contradiction:
ImproveAccuracy of analysisVSAvoidComplexity of generation process
Core Design Contradiction:
ReliabilityVSDevice complexity

Solution Approach 1:

The patent implements automated functions that enable the FT diagram system to serve itself. The conversion program automatically translates spreadsheet data to markup language, and the system provides automated validation and consistency checking. This self-service capability reduces the need for manual intervention and specialized knowledge during the editing and maintenance phases.

Inventive Principle:
Principle #25Self-service

Data Source

PatentUS9524288B2FT diagram generation aid device and FT diagram generation aid program
Publication Date: 2016.12.20 JATCO LTD
  • US9524288B2 patent drawing
  • US9524288B2 patent drawing
  • US9524288B2 patent drawing

AI summary

An FT diagram aid device is provided with an import portion for obtaining a connection relationship of ruled lines and character strings from first data which is data of an FT diagram expressing a tree structure by the ruled lines and the character strings on a sheet of a spreadsheet program, acquiring an event included in the FT diagram and a connection relationship between events from an obtained connection relationship of the ruled lines and the character strings, and generating second data describing the tree structure of the FT diagram in a markup language based on the same and an editing portion for editing the second data to generate third data describing the tree structure of the edited FT diagram in the markup language.