SPREADSHEET-BASED TEMPLATES FOR SUPPORTING THE SYSTEMS ENGINEERING PROCESS
First Claim
Patent Images
1. A method of modeling a system comprising a plurality of components, the method comprising:
- using a computer to provide a spreadsheet environment;
defining a plurality of shape objects within the spreadsheet environment, the shape objects representing the components of the system, wherein at least one component is a subsystem comprising a plurality of elements;
using the spreadsheet environment to interact with a plurality of applications for working with the system;
using the spreadsheet environment to generate a plurality of diagrams of the system in a graphical system modeling language;
using the spreadsheet environment to diagram a plurality of system models for system simulation, process automation, and performance index calculations;
using a macro in the spreadsheet environment to perform at least one action on at least one of the system models; and
storing the system model using a templated workbook in the spreadsheet environment, the templated workbook comprising data representing a physical view and a functional view of the system model.
1 Assignment
0 Petitions
Accused Products
Abstract
A spreadsheet environment is used as a graphical user interface (GUI) for depicting and interacting with the various aspects of a system. In particular, the spreadsheet environment supports using OMG SysML to model a system, and to execute tasks associated with the systems engineering process. The spreadsheet environment also supports the use of pre-defined templates whose contents and features are common to a multiplicity of projects that a company or company unit may undertake, and which can be made specific or modified based on a project'"'"'s needs.
45 Citations
24 Claims
-
1. A method of modeling a system comprising a plurality of components, the method comprising:
-
using a computer to provide a spreadsheet environment; defining a plurality of shape objects within the spreadsheet environment, the shape objects representing the components of the system, wherein at least one component is a subsystem comprising a plurality of elements; using the spreadsheet environment to interact with a plurality of applications for working with the system; using the spreadsheet environment to generate a plurality of diagrams of the system in a graphical system modeling language; using the spreadsheet environment to diagram a plurality of system models for system simulation, process automation, and performance index calculations; using a macro in the spreadsheet environment to perform at least one action on at least one of the system models; and storing the system model using a templated workbook in the spreadsheet environment, the templated workbook comprising data representing a physical view and a functional view of the system model. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A method of modeling a system comprising a plurality of components, the method comprising:
-
using a computer to provide a spreadsheet environment; defining a plurality of shape objects within the spreadsheet environment, the shape objects representing the components of the system, wherein at least one component is a subsystem comprising a plurality of elements; using the spreadsheet environment to interact with a plurality of applications for working with the system; using the spreadsheet environment to generate a plurality of diagrams of the system in a graphical system modeling language; using the spreadsheet environment to diagram a plurality of system models for dynamic system simulation, process automation, and performance index calculations; using a macro in the spreadsheet environment to perform at least one action on at least one of the system models; storing the system model using a templated master workbook in the spreadsheet environment, the templated master workbook comprising a plurality of worksheets; receiving a user selection of the templated master workbook and a worksheet of the plurality of worksheets; and copying the selected worksheet to a client workbook. - View Dependent Claims (8, 9, 10, 11, 12)
-
-
13. A computer system comprising:
-
a processor configured to receive and to execute processor-executable instructions; a memory device in communication with the processor and storing processor-executable instructions that, when executed by the processor, cause the processor to model a system comprising a plurality of components by using the processor to provide a spreadsheet environment; defining a plurality of shape objects within the spreadsheet environment, the shape objects representing the components of the system, wherein at least one component is a subsystem comprising a plurality of elements; using the spreadsheet environment to interact with a plurality of applications for working with the system; using the spreadsheet environment to generate a plurality of diagrams of the system in a graphical system modeling language; using the spreadsheet environment to diagram a plurality of system models for system simulation, process automation, and performance index calculations; using a macro in the spreadsheet environment to perform at least one action on at least one of the system models; and storing the system model using a templated workbook in the spreadsheet environment, the templated workbook comprising data representing a physical view and a functional view of the system model. - View Dependent Claims (14, 15, 16, 17, 18)
-
-
19. A computer system comprising:
-
a processor configured to receive and to execute processor-executable instructions; a memory device in communication with the processor and storing processor-executable instructions that, when executed by the processor, cause the processor to model a system comprising a plurality of components by using a computer to provide a spreadsheet environment; defining a plurality of shape objects within the spreadsheet environment, the shape objects representing the components of the system, wherein at least one component is a subsystem comprising a plurality of elements; using the spreadsheet environment to interact with a plurality of applications for working with the system; using the spreadsheet environment to generate a plurality of diagrams of the system in a graphical system modeling language; using the spreadsheet environment to diagram a plurality of system models for dynamic system simulation, process automation, and performance index calculations; using a macro in the spreadsheet environment to perform at least one action on at least one of the system models; storing the system model using a templated master workbook in the spreadsheet environment, the templated master workbook comprising a plurality of worksheets; receiving a user selection of the templated master workbook and a worksheet of the plurality of worksheets; and copying the selected worksheet to a client workbook. - View Dependent Claims (20, 21, 22, 23, 24)
-
Specification