Use of temporary optimized settings to reduce cycle time of automatically created spreadsheets
AssigneeInternational Business Machines Corporation
InventorsScott D. Hicks, James A. Martin, Jr., Douglas G. Murray
Life of this patent
Estimating the term…
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.
Claims20
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.
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.
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.
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.
Dependencies are inferred from the claim text.