×

System of english language sentences and words stored in spreadsheet cells that read those cells and use selected sentences that analyze columns of text and compare cell values to read other cells in one or more spreadsheets

  • US 10,698,978 B1
  • Filed: 03/27/2017
  • Issued: 06/30/2020
  • Est. Priority Date: 03/27/2017
  • Status: Active Grant
First Claim
Patent Images

1. A method that comprises English language processing of text stored in text databases, knowledge management (KM) structured query language (SQL) databases, and spreadsheet cell databases, wherein processing comprising deconstructing input text of an English language sentence into its grammar parts comprising noun and verb phrases, further comprising computer hardware, computer software, and a computer application, wherein a computer application reads Natural language text in SQL and spreadsheet cells to make natural language decisions by processing SQL databases and spreadsheet cells, comprising the steps of:

  • placing English language text sentences in selected SQL database, wherein selecting the sentences in a SQL drop down menu will automatically store the sentences in save mode in a designated spreadsheet cell, wherein the English language text sentence is attached to a designated spreadsheet by running a spreadsheet'"'"'s executable program, wherein a selected sentence is processed by the computer application and connects to the attached designated spreadsheet to process data in the attached designated spreadsheet or other spreadsheets;

    linking together English language sentences with their attachments in spreadsheet cells throughout one or more spreadsheets;

    placing spreadsheet cell text characters in rows or columns of spreadsheet cells that are concatenated to a row or column cell, wherein a concatenated text character data is used in a decision-making process;

    storing English language sentence text in the SQL database, wherein SQL English language text is attached to text characters, wherein the computer application reads the SQL English language sentence text and places attached sentence text characters in spreadsheet column or row cells or places text characters in row or column cells, wherein the computer application reads a concatenation sentence that concatenates text characters placed in row and column cells, wherein the concatenated text characters are compared to cells in the spreadsheet, wherein a comparison results in the computer application selecting one of two cells to read containing English language sentences or text characters;

    storing if then else (IfThenElse) sentences in the SQL databases and the spreadsheet cell databases that will compare a concatenated row or column text character data to another concatenated row or column of text character data or will compare the concatenated row or column text character data to the designated spreadsheet cell in the spreadsheet or other spreadsheets and after the comparison will cause the computer application to read a spreadsheet cell or to read the spreadsheet cell containing English language text sentences; and

    testing a spreadsheet Natural language decision to determine if correct sentences are read from a decision made by the spreadsheet, wherein English language text is sent to the spreadsheet requesting the spreadsheet to retrieve information and make a decision, wherein the computer application transmits and receives text messages to and from spreadsheet cells on local and wide area computer networks.

View all claims
  • 0 Assignments
Timeline View
Assignment View
    ×
    ×