Patent ID: 11861735
Assignee: USA AS REP BY THE SECRETARY OF THE NAVY
Field: IT methods for management (Electrical engineering)
Classification: CPC G | IPC G

Claim 2:
3. A computer program product for generating a balance sheet based on information contained in an enterprise resource planning system, the computer program product comprising a non-transitory computer-readable storage medium having computer-readable program code portions stored therein for execution by a computer, the computer-readable program code portions including:
a first executable portion, for selecting at least one transaction code in an enterprise resource planning system, wherein each said transaction code includes a plurality of cost elements that are each substantially directed to operating materials and supplies costs;
a second executable portion, for generating a plurality of enterprise resource planning reports in said enterprise resource planning system, wherein said generating of said plurality of said enterprise resource planning reports includes drilling down, with respect to said plurality of said cost elements, to costs associated with commitments, obligations, and actual costs, and wherein said generating of each said enterprise resource planning report includes drilling down, with respect at least one said cost element, to costs associated with at least one of said commitments, said obligations, and said actual costs;
a third executable portion, for producing at least three macros in a spreadsheet program, said at least three macros including a first macro, a second macro, and a third macro, wherein each said macro is used for generating at least one tabbed worksheet;
a fourth executable portion, for generating a plurality of said tabbed worksheets in said spreadsheet program, wherein said plurality of tabbed worksheets includes a plurality of raw spreadsheet worksheets, a plurality of intermediate pivot table worksheets, a composite spreadsheet report worksheet, a plurality of summary pivot table worksheets, and a plurality of customized spreadsheet worksheets, wherein said generating of each said tabbed worksheet is performed using a said macro, wherein each said tabbed worksheet is characterized by a tab usable for accessing said worksheet, wherein said fourth executable portion includes at least three worksheet-generative executable sub-portions, said at least three worksheet-generative executable sub-portions including;
a first executable worksheet-generative sub-portion, for generating said plurality of said raw spreadsheet worksheets in said spreadsheet program, wherein said generating of said plurality of said raw spreadsheet worksheets is performed using said first macro and includes importing data from every said enterprise resource planning report, wherein said generating of each said raw spreadsheet worksheet includes importing data from at least one said enterprise resource planning report;
a second executable worksheet-generative sub-portion, for generating said plurality of said intermediate pivot table worksheets in said spreadsheet program, wherein said generating of said plurality of said intermediate pivot table worksheets is performed using said second macro and includes organizing data from every said raw spreadsheet worksheet, wherein said generating of each said intermediate pivot table worksheet includes organizing data from at least one said raw spreadsheet worksheet;
a third executable worksheet-generative sub-portion, for generating said composite spreadsheet report in said spreadsheet program, wherein said generating of said composite spreadsheet report worksheet is performed using said second macro and includes combining data from every said pivot table worksheet;
a fourth executable worksheet-generative sub-portion, for generating said plurality of said summary pivot table worksheets in said spreadsheet program, wherein said generating of said plurality of said summary pivot table worksheets is performed using said second macro and includes organizing data from said composite spreadsheet report worksheet, wherein said generating of each said summary pivot table worksheet includes organizing data from said composite spreadsheet report worksheet;
a fifth executable worksheet-generative sub-portion, for generating said plurality of said customized spreadsheet worksheets in said spreadsheet program, wherein said generating of said plurality of said customized spreadsheet worksheets is performed using said third macro and includes organizing data from every said summary pivot table worksheet and from said composite spreadsheet report worksheet, wherein said generating of each customized spreadsheet worksheet includes organizing data from at least one of: (i) said composite spreadsheet report worksheet; (ii) at least one said summary pivot table worksheet;

a fifth executable portion, for navigating between said tabbed worksheets, wherein said navigating includes accessing every said tabbed worksheet by using the corresponding said tab.