US 11,983,490 B1
Spreadsheet interface for a transaction management platform
Sahil Rattan, Fairway, KS (US); and Roger Smith, Fairway, KS (US)
Assigned to TermSheet, LLC, Kansas City, MO (US)
Filed by TermSheet, LLC, Kansas City, MO (US)
Filed on Jun. 15, 2022, as Appl. No. 17/840,893.
Claims priority of provisional application 63/210,877, filed on Jun. 15, 2021.
Int. Cl. G06F 40/18 (2020.01); G06F 9/46 (2006.01); G06F 16/22 (2019.01); G06Q 50/16 (2012.01)
CPC G06F 40/18 (2020.01) [G06F 9/466 (2013.01); G06F 16/221 (2019.01); G06Q 50/16 (2013.01)] 18 Claims
OG exemplary drawing
 
1. A system comprising:
a transaction management platform; and
a plug-in for a spreadsheet program, wherein the plug-in comprises program code that, when executed by one or more processors, causes the one or more processors to perform operations comprising:
creating a list of transactions within the transaction management platform, wherein each respective transaction in the list of transactions is associated with a respective workbook in the spreadsheet program;
creating, in the respective workbook, a respective mapping sheet for the respective transaction, wherein the respective mapping sheet is a respective first spreadsheet within the respective workbook;
creating, in the respective workbook, a respective second spreadsheet including a respective underwriting model for the respective transaction;
wherein the respective first spreadsheet, including the respective mapping sheet, and the respective second spreadsheet, including the respective underwriting model, are both displayable in the spreadsheet program via respective tabs of the respective workbook;
displaying at least one of a custom ribbon or a custom panel within the spreadsheet program including:
a first control for selecting a transaction from the list of transactions for the transaction management platform; and
a second control for publishing data from the spreadsheet program to the transaction management platform;
allowing a user of the spreadsheet program to select, via the first control, a transaction from the list of transactions for the transaction management platform;
displaying data fields associated with the selected transaction within a mapping sheet of a workbook associated with the selected transaction;
allowing the user to map, within the mapping sheet of the workbook associated with the selected transaction rather than a separate application, the data fields associated with the selected transaction to corresponding cells of a second spreadsheet of the workbook associated with the selected transaction including an underwriting model; and
updating, in response to activation of the second control, the data fields associated with the selected transaction with data values from the corresponding cells of the second spreadsheet of the workbook associated with the selected transaction including the underwriting model.