Use of temporary optimized settings to reduce cycle time of automatically created spreadsheets
First Claim
Patent Images
1. A method for reducing cycle time of automatically created spreadsheets, comprising:
- obtaining a first control document having optimized settings for the spreadsheet, wherein the optimized settings include;
disabling automatic saving, automatic calculation, and background error checking;
optimizing a spreadsheet application by applying the optimized settings to the spreadsheet application;
creating the spreadsheet by importing data from a source document different from the control document in a natural format that is different from a format of the spreadsheet into the spreadsheet using the optimized settings in the spreadsheet application;
obtaining a second control document having final settings for the spreadsheet;
setting the final settings; and
outputting the created spreadsheet.
2 Assignments
0 Petitions
Accused Products
Abstract
Aspects of the present invention provide a solution for reducing cycle time of automatically created spreadsheets. Specifically, an embodiment of the present invention provides a way to create a spreadsheet from data that is in a native format more quickly and/or efficiently. To do so, the invention accesses a control file using optimized settings to create the spreadsheet. Then, after creation of the spreadsheet, the invention uses a second control file having the final settings to modify the spreadsheet in preparation for output. The invention may use agents to perform all or a portion of these activities.
52 Citations
20 Claims
-
1. A method for reducing cycle time of automatically created spreadsheets, comprising:
-
obtaining a first control document having optimized settings for the spreadsheet, wherein the optimized settings include;
disabling automatic saving, automatic calculation, and background error checking;optimizing a spreadsheet application by applying the optimized settings to the spreadsheet application; creating the spreadsheet by importing data from a source document different from the control document in a natural format that is different from a format of the spreadsheet into the spreadsheet using the optimized settings in the spreadsheet application; obtaining a second control document having final settings for the spreadsheet; setting the final settings; and outputting the created spreadsheet. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A system for automatically creating a spreadsheet, comprising:
-
an optimized settings obtainer for obtaining a first control document having optimized settings for the spreadsheet, wherein the optimized settings include;
disabling automatic saving, automatic calculation, and background error checking;an optimized settings setter that optimizes a spreadsheet application by applying the optimized settings to the spreadsheet application; a spreadsheet creator for creating the spreadsheet by importing data from a source document different from the control document in a natural format that is different from a format of the spreadsheet into the spreadsheet using the optimized settings in the spreadsheet application; a final settings obtainer for obtaining a second control document having final settings for the spreadsheet; a final settings setter for setting the final settings; and an outputter for outputting the created spreadsheet. - View Dependent Claims (8, 9, 10, 11, 12)
-
-
13. A program product stored on a non-transitory computer readable medium for automatically creating a spreadsheet, the computer readable medium comprising:
-
program code for obtaining a first control document having optimized settings for the spreadsheet, wherein the optimized settings include;
disabling automatic saving, automatic calculation, and background error checking;program code for optimizing a spreadsheet application by applying the optimized settings to the spreadsheet application; program code for creating the spreadsheet by importing data from a source document different from the control document in a natural format that is different from a format of the spreadsheet into the spreadsheet using the optimized settings in the spreadsheet application; program code for obtaining a second control document having final settings for the spreadsheet; program code for setting the final settings; and program code for outputting the created spreadsheet. - View Dependent Claims (14, 15, 16, 17, 18)
-
-
19. A method for deploying a system for automatically creating a spreadsheet, comprising:
providing a computer infrastructure being operable to; obtain a first control document having optimized settings for the spreadsheet, wherein the optimized settings include;
disabling automatic saving, automatic calculation, and background error checking;optimize a spreadsheet application by applying the optimized settings to the spreadsheet application, create the spreadsheet by importing data from a source document different from the control document in a natural format that is different from a format of the spreadsheet into the spreadsheet using the optimized settings in the spreadsheet application; obtain a second control document having final settings for the spreadsheet; set the final settings; and output the created spreadsheet. - View Dependent Claims (20)
Specification