User-programmable cluster of smart devices

• US 10,025,471 B1
• Filed: 11/08/2017
• Issued: 07/17/2018
• Est. Priority Date: 10/21/2017
• Status: Active Grant

• Current Assignee: Mordechai Teicher
• Original Assignee: Mordechai Teicher
• Inventors: Teicher, Mordechai
• Primary Examiner(s): Nguyen, Kevin
• Application Number:
  US15/806,357
• Time in Patent Office: 251 Days
• Field of Search: 715740, 715763, 715765
• CPC Class Codes: G06F 3/0484 for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: H04L 12/2816 Controlling appliance services of a home automation network by calling their functionalities arrangements in telecontrol or telemetry systems for selectively calling a substation from a main station; in which substation desired apparatus is selected for applying a control signal thereto or for obtaining measured values therefrom H04Q9/00

Abstract

Cooperation among functional units of a cluster of smart devices is programmed by a user using a spreadsheet. The user authors spreadsheet formulas to calculate target states of active units of the cluster according to the contents of spreadsheet cells that include current states of functional units of the cluster. Programming messages based on the spreadsheet formulas are received by the smart devices of the cluster and program those smart devices for autonomous operation. Processors of the smart devices then receive updated current states of functional units of the cluster, calculate the target states of the active units according to the received updated current states, and control the active units toward reaching their calculated target states.

Claims

1. A user-programmable system comprising:

a cluster of a plurality of smart devices, each smart device including;

at least one functional unit, each functional unit having a current state of the functional unit, and

a communication unit for communicating with other devices and for sending to other smart devices of the cluster updates on the current state of each functional unit of the smart device,

wherein at least two of the plurality of smart devices are active devices, each active device including a functional unit that is an active unit that performs an action, each active unit having a target state of the active unit; and

a user-operable programming device including;

a communication unit for selectably communicating with smart devices of the cluster,

a memory for storing a cluster spreadsheet, the cluster spreadsheet including;

(i) a plurality of current state cells, each current state cell corresponding to a functional unit of the cluster and is for storing a current state of the functional unit, and (ii) for each active unit of the cluster;

a formula cell for storing a spreadsheet formula authored by a user for calculating the target state of the active unit according to one or more cells of the cluster spreadsheet,

a user interface for enabling viewing and modifying the cluster spreadsheet by users, and

a processor programmed to;

(i) run a spreadsheet program for receiving from a user, via the user interface, spreadsheet formulas for formula cells, and (ii) send a programming message to each active device of the cluster, the programming message including instructions for calculating, by a processor of the active device, the target state of an active unit included in the active device, according to the spreadsheet formula corresponding to the active unit;

wherein, for autonomous operation of the cluster after the programming device is disconnected from the cluster, each active device of the cluster, that includes an active unit, further including;

a memory of the active device, and

a processor programmed to;

(i) receive a programming message from a programming device, the programming message including instructions for calculating a target state of the active unit according to one or more spreadsheet formulas, (ii) store instructions from the programming message in the memory of the active device, (iii) receive one or more current states of one or more functional units of the cluster, (iv) execute instructions from the programming message stored in the memory of the active device for calculating the target state of the active unit according to one or more received current states, and (v) control the active unit for reaching the calculated target state.

2. The user-programmable system of claim 1, wherein the processor of the programming device is further programmed to run the spreadsheet program in a cluster simulation mode, which includes:

receiving from the user, via the user interface, user-selected values for current state cells, calculating target states, and displaying the calculated target states.

3. The user-programmable system of claim 1, wherein, for each active device:

a programming message received by the active device from the programming device includes text from at least one spreadsheet formula authored by a user; and

the processor of the active device is programmed to interpret text of spreadsheet formulas to calculate target states according to the interpreted text.

4. The user-programmable system of claim 1, wherein, for each active device:

the programming message received by the processor of the active device from the processor of the programming device is in a form of a device spreadsheet that includes all or part of the cluster spreadsheet;

the current states received by the processor of the active device are entered by the processor of the active device into corresponding cells of the device spreadsheet; and

the calculating the target state is done by the processor of the active device interpreting the device spreadsheet.

5. The user-programmable system of claim 4, wherein each device spreadsheet received from the processor of the programming device is in textual format.

6. The user-programmable system of claim 1, wherein:

the cluster includes at least one smart device that include a real-time clock; and

at least one spreadsheet formula includes a time parameter.

7. The user-programmable system of claim 1, wherein:

the cluster spreadsheet includes a scratchpad area that includes one or more spreadsheet formulas authored by a user for performing intermediate calculations; and

the calculating a target state by the processor of at least one active device is affected by the intermediate calculations.

8. A method of operation of a cluster of a plurality of smart devices, the cluster including at least two active devices each including an active unit, the method comprising:

in each active device of the at least two active devices;

receiving from a user, via a programming device, at least one spreadsheet formula corresponding to the active unit included in the active device, and storing the at least one spreadsheet formula in a memory of the active device; and

in each active device of the at least two active devices;

(i) receiving from each of at least one other smart device of the cluster, a current state of at least one functional unit included in the respective other smart device;

(ii) autonomously, after the programming device is disconnected from the cluster, interpreting the at least one spreadsheet formula stored in the memory of the active device for calculating a target state of the active unit according to at least one received current state of a functional unit; and

(iii) operating the active unit for reaching the calculated target state.

9. The method of claim 8, wherein the at least one spreadsheet formula includes a formula for an intermediate calculation.

10. The method of claim 8, wherein:

an active device includes a real-time clock; and

at least one spreadsheet formula includes a time parameter.

11. A cluster of a plurality of smart devices, the cluster comprising at least two active devices, each active device of the at least two active devices including:

an active unit;

a memory for storing at least one spreadsheet formula corresponding to the active unit and received from a user via a programming device;

a communication unit for receiving, from each of at least one other smart device of the cluster, a current state of at least one functional unit included in the respective other smart device; and

a processor programmed to;

(i) autonomously, after the programming device is disconnected from the cluster, interpret the at least one spreadsheet formula stored in the memory for calculating a target state of the active unit according to at least one received current state of a functional unit,

and (ii) operate the active unit for reaching the calculated target state.

12. The cluster of claim 11, wherein at least one active device also including an information unit.

13. The cluster of claim 11, wherein the memory of an active device stores a formula for an intermediate calculation.

14. The cluster of claim 11, wherein at least one device of the cluster includes a real-time clock, and the at least one spreadsheet formula includes a time parameter.

15. The cluster of claim 11, wherein:

each of the at least one spreadsheet formula stored in the memory of an active unit forms part of a device spreadsheet; and

all device spreadsheets of all active units of the cluster include the same spreadsheet formulas.