METHOD FOR BUILDING A SPREADSHEET TEMPLATE WITH DYNAMIC DATA TRANSFER CAPABILITIES TO A REMOTE APPLICATION
A method for creating a spreadsheet template to facilitate creation of a spreadsheet is disclosed. The method comprises marking a cell in the range of cells as being a potential record cell; and creating a save map to define attributes to be assembled into a record for an actual record cell.
Embodiments of the present invention relate to spreadsheets. In particular, embodiments of the present invention relate to templates for spreadsheets.
BACKGROUNDSpreadsheets may be used for organization and analysis of data in tabular form. Within a spreadsheet, data is represented as cells of an array, organized in rows and columns. For example in the case of a budget, each column may be used to represent a fiscal period, whereas each row may be used to represent an account.
Within an organization/enterprise spreadsheet templates, e.g. with predefined cell ranges and formulas, may be used to save time.
SUMMARYA method for generating a spreadsheet template is disclosed. The method comprises marking at least one cell as being a potential record cell; selectively converting the at least one cell into an actual record cell; and creating a save map to define attributes to be assembled into a record for an actual record cell.
Other aspects of the invention will be apparent from the detailed description below.
In the following description, for purposes of explanation, numerous specific details are set forth in order to provide a thorough understanding of the invention. It will be apparent, however, to one skilled in the art that the invention can be practiced without these specific details. In other instances, structures and devices are shown in block or flow diagram form only in order to avoid obscuring the invention.
Reference in this specification to “one embodiment” or “an embodiment” means that a particular feature, structure, or characteristic described in connection with the embodiment is included in at least one embodiment of the invention. The appearance of the phrase “in one embodiment” in various places in the specification are not necessarily all referring to the same embodiment, nor are separate or alternative embodiments mutually exclusive of other embodiments. Moreover, various features are described which may be exhibited by some embodiments and not by others. Similarly, various requirements are described which may be requirements for some embodiments but not other embodiments.
Moreover, although the following description contains many specifics for the purposes of illustration, anyone skilled in the art will appreciate that many variations and/or alterations to the details are within the scope of the present invention. Similarly, although many of the features of the present invention are described in terms of each other, or in conjunction with each other, one skilled in the art will appreciate that many of these features can be provided independently of other features. Accordingly, this description of the invention is set forth without any loss of generality to, and without imposing limitations upon, the invention.
The record cell-tagging component 304 allows the template builder 108 to tag or identify a spreadsheet cell as being a “potential” record cell. A potential record cell is one that has the potential to become an “actual” record cell. In one embodiment, a potential record cell may be selectively converted in to an actual record cell based on a condition associated with the actual record cell. The condition is to control when the potential record cell is to become an actual record cell. In some cases, a potential record cell may be converted into an actual record cell by default if there is no condition associated with the potential record cell. In one embodiment, the record cell tagging component 304 allows the template builder 108 to specify the conditions under which a cell marked as a potential record cell becomes an actual record cell, as will explained later.
In one embodiment, a behavior of a potential record cell may be extended in a relative manner to other cells using the repeating range component 302.
The save map component 306 provides the template builder 108 a capability to define record attributes for any cell determined to be an actual record cell during execution of a spreadsheet based on the spreadsheet template 106. In one embodiment, the record attributes may be based on other cells in the current spreadsheet, other spreadsheets, or other data sources. The record attributes for each record cell are saved in a save map, in one embodiment.
The record construction component 308 provides logic to construct records for the remote application 208. In one embodiment, said logic executes at runtime after the end user 204 has input data into the spreadsheet 206 and selected a command to save the spreadsheet.
Turning now to
By way of a further spreadsheet example, consider the spreadsheet 800 shown in
To illustrate the creation of the records in the remote application 208, in one embodiment, consider that the remote application 208 includes the tables shown in
Table 1000 shown in
By way of summary, the template builder 108 may perform the following steps to create a template that can be using to dynamically assemble data into records for the remote application 208:
(a) Using the repeating data range capability, identify which cells comprise a range whose behavior will repeat as like data (same attributes, possibly different values) is retrieved from an outside source or as spreadsheet rows are copied/pasted elsewhere in the spreadsheet. In the example of
(b) Using the Record Cell Tagging Component:
-
- 1. Mark cell H11 as being a Potential Record Cell. This also means that as new repeating rows are created or retrieved based on 1 above, that they would inherit the Potential Cell tag as well (including 2 below)
- 2. Create a condition that if K11>0, it should become an Actual Record Cell. This step is optional as in some embodiments no condition is associated with a Potential Record Cell. In the latter case all Potential Record Cells are converted into Actual Record Cells.
(c) Using Save Map Component: Define the attributes that would need to be assembled into a record for an actual record cell.
Step 1100: to define a repeating range of cells in a spreadsheet for storing like data. This step may be optional in some embodiments;
Step 1102: to mark a cell in the range of cells or an independent cell as being a potential record cell;
Step 1104: to associate at least one condition with the potential record cell, said condition to control when the potential record cell becomes an actual record cell. This step is optional in some embodiments; and
Step 1106: to create a save map to define attributes to be assembled into a record for an actual record cell
The hardware 1200 also typically receives a number of inputs and outputs for communicating information externally. For interface with a user or operator, the hardware may include one or more user input/output devices 1206 (e.g., keyboard, mouse, etc.) and a display 1208. For additional storage, the hardware 1200 may also include one or more mass storage devices 1110, e.g., a Universal Serial Bus (USB) or other removable disk drive, a hard disk drive, a Direct Access Storage Device (DASD), an optical drive (e.g. a Compact Disk (CD) drive, a Digital Versatile Disk (DVD) drive, etc.) and/or a USB drive, among others. Furthermore, the hardware may include an interface with one or more networks 1212 (e.g., a local area network (LAN), a wide area network (WAN), a wireless network, and/or the Internet among others) to permit the communication of information with other computers coupled to the networks. It should be appreciated that the hardware typically includes suitable analog and/or digital interfaces between the processor 1202 and each of the components, as is well known in the art.
The hardware 1200 operates under the control of an operating system 1214, and executes application software 1216 which includes various computer software applications, components, programs, objects, modules, etc. to perform the techniques described above.
In general, the routines executed to implement the embodiments of the invention, may be implemented as part of an operating system or a specific application, component, program, object, module or sequence of instructions referred to as “computer programs.” The computer programs typically comprise one or more instructions set at various times in various memory and storage devices in a computer, and that, when read and executed by one or more processors in a computer, cause the computer to perform operations necessary to execute elements involving the various aspects of the invention. Moreover, while the invention has been described in the context of fully functioning computers and computer systems, those skilled in the art will appreciate that the various embodiments of the invention are capable of being distributed as a program product in a variety of forms, and that the invention applies equally regardless of the particular type of machine or computer-readable media used to actually effect the distribution. Examples of computer-readable media include but are not limited to recordable type media such as volatile and non-volatile memory devices, USB and other removable media, hard disk drives, optical disks (e.g., Compact Disk Read-Only Memory (CD ROMS), Digital Versatile Disks, (DVDs), etc.), flash drives among others.
Although the present invention has been described with reference to specific exemplary embodiments, it will be evident that the various modification and changes can be made to these embodiments without departing from the broader spirit of the invention. Accordingly, the specification and drawings are to be regarded in an illustrative sense rather than in a restrictive sense.
Claims
1. A computer-implemented method for generating a spreadsheet template, comprising:
- marking at least one cell in a spreadsheet as being a potential record cell;
- selectively converting said at least one cell into an actual record cell; and
- creating a save map to define attributes to be assembled into a record for each potential record cell
2. The method of claim 1, wherein said selective converting is based on at least one condition associated with each cell marked as a potential record cell, the condition to control when said cell becomes an actual record cell.
3. The method of claim 2, wherein said selective converting is performed by default if no condition is associated with a potential record cell.
4. The method of claim 3, further comprising defining a repeating range of cells in the spreadsheet, each cell in the range to store like data, and marking a first cell in the repeating range of cells as a potential record cell.
5. The method of claim 4, wherein defining the repeating range of cells comprises defining a repeat attribute to control a direction in which cells in the repeating range of cells are repeated relative to the first cell in the range.
6. The method of claim 5, further comprising configuring cells in the repeating range of cells to repeat on a row-by-row basis, wherein each new cell that is based on the first cell is itself marked as being a potential record cell.
7. The method of claim 6, wherein each new cell that is based on the first cell as the potential record cell also inherits the at least one condition associated with the first cell.
8. The method of claim 7, wherein the at least one condition comprises a condition that a specified cell in the range of cells has an input data value greater than zero.
9. The method of claim 4, further comprising creating a record construction component comprising logic to identify an actual record cell and to construct a database record based on the save map and an actual record cell.
10. A non-transitory computer-readable medium having stored thereon a sequence of instructions which when executed by a system causes the system to perform a method, comprising:
- marking at least one cell in a spreadsheet as being a potential record cell;
- selectively converting said at least one cell into an actual record cell is based on satisfaction of a condition associated with said cell, the condition to control when said cell becomes and actual record cell; wherein said converting is performed by default for cells marked as potential record cells but have no condition associated therewith; and
- creating a save map to define attributes to be assembled into a record for an actual record cell.
11. The computer-readable medium of claim 10, wherein the method further comprises defining a repeating range of cells in the spreadsheet, each cell in the range to store like data, and marking a first cell in the repeating range of cells as a potential record cell.
12. The computer-readable medium of claim 11, wherein defining the repeating range of cells comprises defining a repeat attribute to control a direction in which cells in the repeating range of cells are repeated relative to the first cell in the range.
13. The computer-readable medium of claim 12, wherein the method further comprises configuring cells in the repeating range of cells to repeat on a row-by-row basis, wherein each new cell that is based on the first cell is itself marked as being a potential record cell
14. The computer-readable medium of claim 13, wherein each new cell that is based on the first cell also inherits the at least one condition associated with the first cell.
15. The computer-readable medium of claim 11, wherein the at least one condition comprises the condition that a specified cell in the range of cells has an input data value greater than zero.
16. The computer-readable medium of claim 15, wherein the method further comprises creating a record construction component comprising logic to identify an actual record cell and to construct a database record based on the save map and an actual record cell.
17. A system, comprising:
- a processor; and
- a memory coupled to the processor, the memory storing instructions which when executed by the system causes the system to perform a method for creating a spreadsheet template to facilitate creation of a spreadsheet, comprising: marking at least one cell in a spreadsheet as being a potential record cell; selectively converting said at least one cell into an actual record cell based on satisfaction of at least one condition associated with said cell, the condition to control when a potential record cell becomes an actual record cell; wherein said converting is performed by default if no condition is associated with said cell; and creating a save map to define attributes to be assembled into a record for an actual record cell.
18. The system of claim 17, wherein the method further comprises defining a repeating range of cells in the spreadsheet, each cell in the range to store like data, and marking a first cell in the repeating range of cells as a potential record cell.
19. The system of claim 18, wherein defining the repeating range of cells comprises defining a repeat attribute to control a direction in which cells in the repeating range of cells are repeated relative to the first cell in the range.
20. The system of claim 19, wherein the method further comprises configuring cells in the repeating range of cells to repeat on a row-by-row basis, wherein each new cell that is based on the first cell is itself marked as being a potential record cell.
Type: Application
Filed: Aug 9, 2018
Publication Date: Dec 6, 2018
Inventor: Kirk Krappe (Portola Valley, CA)
Application Number: 16/059,602