WO2006095365A3 - A system and method of defining a hierarchical datamodel and related computation and instruction rules using spreadsheet like user interface - Google Patents

A system and method of defining a hierarchical datamodel and related computation and instruction rules using spreadsheet like user interface Download PDF

Info

Publication number
WO2006095365A3
WO2006095365A3 PCT/IN2006/000085 IN2006000085W WO2006095365A3 WO 2006095365 A3 WO2006095365 A3 WO 2006095365A3 IN 2006000085 W IN2006000085 W IN 2006000085W WO 2006095365 A3 WO2006095365 A3 WO 2006095365A3
Authority
WO
WIPO (PCT)
Prior art keywords
spreadsheet
defining
datamodel
hierarchical
user interface
Prior art date
Application number
PCT/IN2006/000085
Other languages
French (fr)
Other versions
WO2006095365A2 (en
Inventor
Suresh Sambandam
Manivanna Karthikeyan
Prasanna Babu Jaganathan
Rajesh Manickadas
Dinesh Varadharajan
Original Assignee
Suresh Sambandam
Manivanna Karthikeyan
Prasanna Babu Jaganathan
Rajesh Manickadas
Dinesh Varadharajan
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Suresh Sambandam, Manivanna Karthikeyan, Prasanna Babu Jaganathan, Rajesh Manickadas, Dinesh Varadharajan filed Critical Suresh Sambandam
Priority to EP06728407A priority Critical patent/EP1859375A4/en
Priority to US11/885,896 priority patent/US8055995B2/en
Priority to CA2614059A priority patent/CA2614059C/en
Publication of WO2006095365A2 publication Critical patent/WO2006095365A2/en
Publication of WO2006095365A3 publication Critical patent/WO2006095365A3/en

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets

Abstract

The present invention relates to the field of information processing involving digital computers, embedded devices and more particularly, to a method and system for defining hierarchical data model and related computation and instructions rules using electronic spreadsheet like interface. The system and method of the invention are directed to user friendly, fast, development of multi-user, workflow enabled applications using spreadsheet as a tool for application modeling.
PCT/IN2006/000085 2005-03-11 2006-03-10 A system and method of defining a hierarchical datamodel and related computation and instruction rules using spreadsheet like user interface WO2006095365A2 (en)

Priority Applications (3)

Application Number Priority Date Filing Date Title
EP06728407A EP1859375A4 (en) 2005-03-11 2006-03-10 A system and method of defining a hierarchical datamodel and related computation and instruction rules using spreadsheet ldxe user interface
US11/885,896 US8055995B2 (en) 2005-03-11 2006-03-10 System and method of defining a hierarchical datamodel and related computation and instruction rules using spreadsheet like user interface
CA2614059A CA2614059C (en) 2005-03-11 2006-03-10 A system and method of defining a hierarchical datamodel and related computation and instruction rules using spreadsheet like user interface

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
IN244/CHE/2005 2005-03-11
IN244CH2005 2005-03-11

Publications (2)

Publication Number Publication Date
WO2006095365A2 WO2006095365A2 (en) 2006-09-14
WO2006095365A3 true WO2006095365A3 (en) 2007-12-06

Family

ID=36953758

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/IN2006/000085 WO2006095365A2 (en) 2005-03-11 2006-03-10 A system and method of defining a hierarchical datamodel and related computation and instruction rules using spreadsheet like user interface

Country Status (4)

Country Link
US (1) US8055995B2 (en)
EP (1) EP1859375A4 (en)
CA (1) CA2614059C (en)
WO (1) WO2006095365A2 (en)

Families Citing this family (28)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1892641A (en) * 2005-06-29 2007-01-10 国际商业机器公司 Method and system for hiding sensitive data within models in an electronic spreadsheet environment
JP4140919B2 (en) * 2006-03-14 2008-08-27 インターナショナル・ビジネス・マシーンズ・コーポレーション System and method for performing processing such as spreadsheet
US8375302B2 (en) * 2006-11-17 2013-02-12 Microsoft Corporation Example based video editing
US8140958B2 (en) * 2007-01-30 2012-03-20 International Business Machines Corporation Cyclical and synchronized multi-source spreadsheet imports and exports
US20080229184A1 (en) * 2007-03-15 2008-09-18 Microsoft Corporation Private sheets in shared spreadsheets
KR101455721B1 (en) * 2007-11-08 2014-10-28 삼성전자 주식회사 Method and Apparatus for switching an internet network for a portable terminal
US20090249192A1 (en) * 2008-03-31 2009-10-01 Microsoft Corporation Creating a view from multiple templates
US20100095195A1 (en) * 2008-10-15 2010-04-15 Apple Inc. Defining spreadsheet functions
US8335981B2 (en) * 2009-08-03 2012-12-18 Business Objects Software Ltd. Metadata creation
US9489366B2 (en) * 2010-02-19 2016-11-08 Microsoft Technology Licensing, Llc Interactive synchronization of web data and spreadsheets
US8433714B2 (en) 2010-05-27 2013-04-30 Business Objects Software Ltd. Data cell cluster identification and table transformation
US9075787B2 (en) * 2010-11-30 2015-07-07 Think-Cell Software Gmbh Defining a reusable spreadsheet-function by extracting the function from a complex calculation in a spreadsheet document
USD705787S1 (en) 2012-06-13 2014-05-27 Microsoft Corporation Display screen with animated graphical user interface
US9304765B1 (en) * 2013-03-05 2016-04-05 Emc Corporation Method and system for tracking changes to application model definitions for application model migration
US9424276B2 (en) 2014-05-30 2016-08-23 Avaya Inc. Efficient state change support for hierarchical data models in a virtualized system
USD763307S1 (en) * 2014-08-15 2016-08-09 Michael Shunock Display screen or portion thereof with animated graphical user interface
JP5758534B1 (en) * 2014-09-09 2015-08-05 インテグラート株式会社 Simulation system, simulation method, and simulation program
US9910843B2 (en) 2015-02-03 2018-03-06 Intuit Inc. Systems, methods and articles for a web-based spreadsheet application
US10175955B2 (en) * 2016-01-13 2019-01-08 Hamilton Sundstrand Space Systems International, Inc. Spreadsheet tool manager for collaborative modeling
US11113303B2 (en) * 2016-05-09 2021-09-07 Sap Se Ownership transfer of database artifacts between files
US11308269B1 (en) * 2019-08-23 2022-04-19 Hitps Llc Systems, devices, and methods for software coding
GB202002163D0 (en) 2020-02-17 2020-04-01 Microsoft Technology Licensing Llc Spreadsheet with reuse functionality
US11663199B1 (en) 2020-06-23 2023-05-30 Amazon Technologies, Inc. Application development based on stored data
US11514236B1 (en) 2020-09-30 2022-11-29 Amazon Technologies, Inc. Indexing in a spreadsheet based data store using hybrid datatypes
US11500839B1 (en) * 2020-09-30 2022-11-15 Amazon Technologies, Inc. Multi-table indexing in a spreadsheet based data store
US11768818B1 (en) 2020-09-30 2023-09-26 Amazon Technologies, Inc. Usage driven indexing in a spreadsheet based data store
US11714796B1 (en) 2020-11-05 2023-08-01 Amazon Technologies, Inc Data recalculation and liveliness in applications
CN112487107B (en) * 2020-11-28 2021-11-23 河北省科学技术情报研究院(河北省科技创新战略研究院) Processing method for presenting data index hierarchy and classification in electronic form

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20040122844A1 (en) * 2002-12-18 2004-06-24 International Business Machines Corporation Method, system, and program for use of metadata to create multidimensional cubes in a relational database
US20050034060A1 (en) * 2000-06-21 2005-02-10 Microsoft Corporation User interface for integrated spreadsheets and word processing tables

Family Cites Families (27)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5206951A (en) * 1987-08-21 1993-04-27 Wang Laboratories, Inc. Integration of data between typed objects by mutual, direct invocation between object managers corresponding to object types
US5416895A (en) * 1992-04-08 1995-05-16 Borland International, Inc. System and methods for improved spreadsheet interface with user-familiar objects
GB9320404D0 (en) * 1993-10-04 1993-11-24 Dixon Robert Method & apparatus for data storage & retrieval
AU4783796A (en) * 1995-02-22 1996-09-11 Plougmann, Ole Graphical environment for managing and developing applications
US5893123A (en) * 1995-06-22 1999-04-06 Tuinenga; Paul W. System and method of integrating a spreadsheet and external program having output data calculated automatically in response to input data from the spreadsheet
US6023715A (en) * 1996-04-24 2000-02-08 International Business Machines Corporation Method and apparatus for creating and organizing a document from a plurality of local or external documents represented as objects in a hierarchical tree
US5819293A (en) * 1996-06-06 1998-10-06 Microsoft Corporation Automatic Spreadsheet forms
US6378001B1 (en) * 1997-06-18 2002-04-23 International Business Machines Corp. Collaborative framework with shared objects
US6199078B1 (en) * 1998-09-15 2001-03-06 Sphere Software Engineering, Inc. Analytic network engine and spreadsheet interface system
EP1146438A3 (en) * 2000-04-14 2003-05-02 International Business Machines Corporation Handling absolute references in electronic spreadsheets during copy or cut and paste operation
US6898760B2 (en) * 2001-01-05 2005-05-24 Microsoft Corporation Reporting status of external references in a spreadsheet without updating
WO2003014987A2 (en) * 2001-08-09 2003-02-20 International Business Machines Corporation Spreadsheet system and method for transferring the content of input cells between scalable template instances
US7010779B2 (en) * 2001-08-16 2006-03-07 Knowledge Dynamics, Inc. Parser, code generator, and data calculation and transformation engine for spreadsheet calculations
US20040103365A1 (en) * 2002-11-27 2004-05-27 Alan Cox System, method, and computer program product for an integrated spreadsheet and database
US20040148566A1 (en) * 2003-01-24 2004-07-29 Jp Morgan Chase Bank Method to evaluate project viability
US20040163050A1 (en) * 2003-02-14 2004-08-19 Matter Bruce Edward Systems and methods for managing negotiated transactions
CN100378723C (en) * 2003-04-18 2008-04-02 国际商业机器公司 System and method in a data table for managing insertion operations in recursive scalable template instances
US7664804B2 (en) * 2004-06-01 2010-02-16 Microsoft Corporation Method, system, and apparatus for exposing workbook ranges as data sources
US8578399B2 (en) * 2004-07-30 2013-11-05 Microsoft Corporation Method, system, and apparatus for providing access to workbook models through remote function cells
US7533139B2 (en) * 2004-09-27 2009-05-12 Microsoft Corporation Method and system for multithread processing of spreadsheet chain calculations
US9047266B2 (en) * 2004-10-07 2015-06-02 International Business Machines Corporation Methods, systems and computer program products for processing cells in a spreadsheet
US7614000B2 (en) * 2004-12-20 2009-11-03 Microsoft Corporation File formats, methods, and computer program products for representing presentations
US7617444B2 (en) * 2004-12-20 2009-11-10 Microsoft Corporation File formats, methods, and computer program products for representing workbooks
US8726143B2 (en) * 2005-01-14 2014-05-13 Microsoft Corporation System and method for a spreadsheet application supporting diverse formulaic functions
US20070022128A1 (en) * 2005-06-03 2007-01-25 Microsoft Corporation Structuring data for spreadsheet documents
US7752536B2 (en) * 2005-09-09 2010-07-06 Microsoft Corporation Designating, setting and discovering parameters for spreadsheet documents
US20070220415A1 (en) * 2006-03-16 2007-09-20 Morgan Mao Cheng Excel spreadsheet parsing to share cells, formulas, tables or entire spreadsheets across an enterprise with other users

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20050034060A1 (en) * 2000-06-21 2005-02-10 Microsoft Corporation User interface for integrated spreadsheets and word processing tables
US20040122844A1 (en) * 2002-12-18 2004-06-24 International Business Machines Corporation Method, system, and program for use of metadata to create multidimensional cubes in a relational database

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
See also references of EP1859375A4 *

Also Published As

Publication number Publication date
CA2614059A1 (en) 2006-09-14
EP1859375A2 (en) 2007-11-28
EP1859375A4 (en) 2010-11-10
WO2006095365A2 (en) 2006-09-14
US8055995B2 (en) 2011-11-08
CA2614059C (en) 2014-11-04
US20080256432A1 (en) 2008-10-16

Similar Documents

Publication Publication Date Title
WO2006095365A3 (en) A system and method of defining a hierarchical datamodel and related computation and instruction rules using spreadsheet like user interface
WO2009134927A3 (en) Business software application system and method
EP1939729A4 (en) Software development production management system, computer program, and recording medium
WO2007019303A3 (en) Business intelligence system and methods
WO2006096282A3 (en) System and method for providing location information to applications
TWI370368B (en) Method and system for a runtime user account creation operation within a single-sign-on process in a federated computing environment
WO2008000498A3 (en) Defining a status model for a computer system
WO2005038560A3 (en) Method for providing physics simulation data
WO2007061784A3 (en) Application of optimization techniques to intermediate representations for code generation
WO2006036924A3 (en) System, method and apparatus for modeling and utilizing metrics, processes and technology in marketing applications
TWI370363B (en) Method, system, and computer program product of facilitating management of storage of a pageable mode virtual environment
WO2007117592A3 (en) System and method for managing product information
WO2010120579A3 (en) Utilizing spreadsheet user interfaces with flowsheets of a cpi simulation system
WO2009032776A3 (en) Power management of data processing resources, such as power adaptive management of data storage operations
WO2011104367A3 (en) Software application development tool
WO2009002949A3 (en) System, method and apparatus for predictive modeling of specially distributed data for location based commercial services
WO2006105139A3 (en) Communication of information between a plurality of network elements
WO2007111814A3 (en) Method and application tool for dynamically navigating a user customizable representation of a network device configuration
WO2007076509A3 (en) Generation of names related to organization actions
WO2009047502A8 (en) Improved method of creating a computer model of the physical world
WO2007134242A3 (en) Method for generating decision trees integrated with petro-technical workflows
WO2007038352A3 (en) Automated creation of model and view code
TW200725290A (en) Method for transmitting files between different computers
WO2008048958A3 (en) Integrated drug development software platform
TW200745977A (en) Visual role definition for identity management

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application
WWE Wipo information: entry into national phase

Ref document number: 2614059

Country of ref document: CA

WWE Wipo information: entry into national phase

Ref document number: 11885896

Country of ref document: US

WWE Wipo information: entry into national phase

Ref document number: 3913/CHENP/2007

Country of ref document: IN

NENP Non-entry into the national phase

Ref country code: DE

WWE Wipo information: entry into national phase

Ref document number: 2006728407

Country of ref document: EP

NENP Non-entry into the national phase

Ref country code: RU

WWW Wipo information: withdrawn in national office

Ref document number: RU

WWP Wipo information: published in national office

Ref document number: 2006728407

Country of ref document: EP