Populating spreadsheets using relational information from documents

US10699069B2 · kind B2 · utility

Assignee

• International Business Machines Corporation · US

Inventors

• Alfio Massimiliano Gliozzo · New York, US
• Aaron J. Chavez · Denver, US
• Robert G. Farrell · Towners, US
• Gaetano Rossiello · Palo del Colle, IT
• Nicolas Rodolfo Fauceglia · New York, US
• Mudita Singhal · Sunnyvale, US

Key dates

• Filing date: Oct 11, 2018
• Grant date: Jun 30, 2020
• Expiry date: Dec 27, 2038

Classification

• Technology area (CPC G): Physics
• CPC primary: G06F40/30
• WIPO field: Computer technology
• WIPO sector: Electrical engineering

Abstract

A spreadsheet population method, system, and computer program product include associating text with a spreadsheet, the text including candidate data items for populating the spreadsheet, building a multi-dimensional analogy model where each dimension comprises a unique pair of data items where the data items co-occur within a same context window, accepting example data items in the spreadsheet where the data items form tuples in a same implicit relationship according to a spatial configuration, and performing an assistance operation on the spreadsheet using the data item tuples retrieved using the analogy model from the example data items.