Spreadsheet Person Object Integration for Unified Data and Communication

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Existing spreadsheet systems lack a unified and integrated way to represent and interact with people-related data, requiring users to switch between different programs for tasks like communication, data retrieval, and social networking.

Innovation Solution

The introduction of a 'person object' within spreadsheets that allows for integration with formulas, charts, tables, and social networking, enabling actions like messaging, status updates, and social media posting directly within the spreadsheet.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If users utilize traditional spreadsheet systems for people-related data, then basic data organization is achieved, but users must switch between different programs for communication, data retrieval, and social networking tasks

Engineering Contradiction:
Improvefunctional integrationVSAvoidsystem integration
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent merges multiple previously separate functions (communication, data retrieval, social networking) into a single spreadsheet environment by introducing person objects that can be directly manipulated within the spreadsheet interface, eliminating the need to switch between different applications

Inventive Principle:
Principle #5Merging (Combining)

Solution Approach 2:

The person object serves multiple functions simultaneously: it represents contact information, enables communication actions (email, phone, text), provides social networking access, and integrates with spreadsheet formulas and visualizations, making a single object universally useful for various people-related tasks

Inventive Principle:
Principle #6Universality (Multi-functionality)

2Productivity

If users switch between different programs for people-related tasks, then specialized functions are accessed, but productivity is reduced due to context switching

Engineering Contradiction:
Improvetask completion efficiencyVSAvoidcontext switching time
Core Design Contradiction:
ProductivityVSLoss of time

Solution Approach 1:

By combining communication and social networking functions directly within the spreadsheet interface through person objects, the patent eliminates context switching between applications, allowing users to complete multiple tasks in a single workflow without losing time to program switching

Inventive Principle:
Principle #5Merging (Combining)

3Ease of operation

If a person object is integrated into spreadsheet formulas and objects, then seamless interaction is achieved, but the spreadsheet system complexity increases

Engineering Contradiction:
Improveuser interaction simplicityVSAvoidsystem architecture
Core Design Contradiction:
Ease of operationVSDevice complexity

Solution Approach 1:

The person object acts as an intermediary that bridges the simple spreadsheet interface and the complex backend systems for communication and social networking, presenting a simplified user interface while handling the complexity of integrating with multiple external services and formulas

Inventive Principle:
Principle #24Intermediary (Mediator)

Data Source

PatentUS10191898B2Representation of people in a spreadsheet
Publication Date: 2019.01.29 MICROSOFT TECHNOLOGY LICENSING LLC
  • US10191898B2 patent drawing
  • US10191898B2 patent drawing
  • US10191898B2 patent drawing

AI summary

A spreadsheet includes a native spreadsheet object that represents a person. The person object may be used within a spreadsheet just as any other spreadsheet objects are utilized. For example, the person object may be integrated with spreadsheet formulas and other spreadsheet objects such as charts, tables, pivot tables, sheets, and the like. Spreadsheet formulas may perform operations specific to a person object (e.g. send message, get contact information, get status, get other person specific information, sort, and the like). Common actions may be associated with the person object, such as initiating communication with the person represented by the person object (e.g. phone call, email, text message, collaboration invite, and the like). Social networking information may also be associated with a person object. For example, social networking posts may be included within a spreadsheet, a user may post to a social network from the spreadsheet, and the like.