Smart Device Controller Using Spreadsheet Programming

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Current smart home systems face challenges with high costs, reliability issues due to single points of failure, and interoperability problems caused by conflicting commercial interests in control hubs, making it difficult for users to set up complex device interactions without professional programming.

Innovation Solution

The introduction of clusters of smart devices that can operate in both hub-based and hub-less modes, allowing autonomous cooperation and using spreadsheets for programming, enabling users to set up device interactions without needing professional programming skills.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If control hubs are used to manage smart devices, then device cooperation and control are achieved, but costs increase and reliability decreases due to single point of failure

Engineering Contradiction:
Improvesystem reliabilityVSAvoidcontrol hub dependency
Core Design Contradiction:
ReliabilityVSDevice complexity

Solution Approach 1:

The patent extracts the control hub from the system and distributes its functions to individual smart devices. Each device becomes autonomous with its own controller that can independently make decisions and execute actions based on received commands, eliminating the single point of failure while maintaining system functionality.

Inventive Principle:
Principle #2Taking out (Extraction)

Solution Approach 2:

The control functionality is segmented from a centralized hub and distributed across multiple smart devices. Each device has its own controller that can operate independently, dividing the monolithic control function into smaller, redundant units that continue operating even if one fails.

Inventive Principle:
Principle #1Segmentation

2Adaptability or versatility

If control hubs are used to manage smart devices, then centralized control is achieved, but interoperability deteriorates due to conflicting commercial interests

Engineering Contradiction:
ImproveinteroperabilityVSAvoidhub-based architecture
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent implements universal controllers in smart devices that can receive commands from multiple sources including other smart devices, mobile applications, and cloud services. This multi-functional approach allows different devices from various manufacturers to interoperate seamlessly without requiring a proprietary hub ecosystem.

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

Solution Approach 2:

The controller in each smart device acts as an intermediary that translates and executes commands from diverse sources. It mediates between different communication protocols and control methods, enabling interoperability without requiring a centralized hub that would have conflicting commercial interests.

Inventive Principle:
Principle #24Intermediary (Mediator)

3Ease of operation

If professional programming is required for device cooperation, then precise control is achieved, but ease of operation decreases

Engineering Contradiction:
Improveuser setup capabilityVSAvoidprogramming requirements
Core Design Contradiction:
Ease of operationVSDevice complexity

Solution Approach 1:

The patent implements self-service functionality where smart devices automatically configure and establish cooperation with each other without requiring professional programming. The autonomous controllers can independently negotiate communication protocols, establish connections, and execute coordinated actions based on simple user-initiated commands.

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The system performs preliminary actions by pre-configuring communication protocols and coordination mechanisms within each device's controller. This preparation allows devices to autonomously establish complex cooperative behaviors without requiring users to program them, simplifying setup while maintaining precise control capabilities.

Inventive Principle:
Principle #10Preliminary action

Data Source

PatentUS11012253B2Controller for smart devices
Publication Date: 2021.05.18 TEICHER MORDECHAI
  • US11012253B2 patent drawing
  • US11012253B2 patent drawing
  • US11012253B2 patent drawing

AI summary

A controller for connecting to and controlling active units of smart devices according to a spreadsheet received from a programming device and stored in the controller's memory and current states received from other smart devices. The controller may operate to provide to programming devices the spreadsheet stored in the memory for restoring a cluster of smart devices. The controller may include a real-time clock and interpret spreadsheet formulas that include time parameters.