US 11,726,753 B2
Spreadsheet-based software application development
Thomas Stachura, Edmonton (CA)
Filed by Thomas Stachura, Edmonton (CA)
Filed on Sep. 3, 2021, as Appl. No. 17/466,649.
Application 17/466,649 is a continuation of application No. 16/745,976, filed on Jan. 17, 2020, granted, now 11,113,041, issued on Sep. 7, 2021.
Application 16/745,976 is a continuation of application No. 15/829,979, filed on Dec. 3, 2017, granted, now 10,540,153, issued on Jan. 21, 2020.
Application 15/829,979 is a continuation in part of application No. 15/455,909, filed on Mar. 10, 2017, granted, now 10,216,494, issued on Feb. 26, 2019.
Claims priority of provisional application 62/429,749, filed on Dec. 3, 2016.
Prior Publication US 2021/0397420 A1, Dec. 23, 2021
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 8/38 (2018.01); G06F 8/34 (2018.01); G06F 40/18 (2020.01); G06F 40/186 (2020.01)
CPC G06F 8/38 (2013.01) [G06F 8/34 (2013.01); G06F 40/18 (2020.01); G06F 40/186 (2020.01)] 28 Claims
OG exemplary drawing
 
1. A computer implemented method comprising:
determining at least one primary data source within a spreadsheet, wherein the at least one primary data source corresponds to a first worksheet of the spreadsheet;
determining at least one secondary data source, wherein the at least one secondary data source corresponds to a different second worksheet;
determining a relationship between records of the primary data source and records of the secondary data source, wherein determining the relationship between the records of the primary data source and the records of the secondary data source comprises automatically detecting the relationship based on:
one or more characteristics of the first worksheet and the second worksheet, or
content of the records of the primary data source and content of the records of the second data source;
generating, automatically and based on the determined relationship, a third worksheet comprising at least a portion of the records of the primary data source and at least a portion of the records of the secondary data source, wherein content of the third worksheet is synchronized with content of the first worksheet and content of the second worksheet, and wherein a first row of the third worksheet comprises:
at least one first cell selected from the primary data source; and
at least one different second cell selected from the second data source based on the determined relationship and the at least one first cell;
receiving user input modifying a record of the third worksheet; and
updating at least one record of the secondary data source corresponding to the record of the third worksheet based on the received user input and based on the determined relationship.