2 results about "Spreadsheet software" patented technology

This program provides the ability to identify the worksheet name, header row, target column, etc., when extracting input data within a specified range from a group of worksheets entered in a non-standard format. [Solution] The program includes: a worksheet group acquisition step of acquiring a group of worksheets including multiple worksheets in a spreadsheet software; a worksheet identification step of identifying a predetermined worksheet from the group of worksheets acquired in the worksheet group acquisition step; a first prompt creation step of creating a first prompt by including at least a part of the predetermined worksheet identified in the worksheet identification step in an instruction to identify a header row from the data entered in the worksheet; and a header row identification step of identifying a predetermined header row of a predetermined worksheet based on first output information output in response to inputting the first prompt created in the first prompt creation step into a large-scale language model.

To enable efficient data entry using a familiar spreadsheet software interface, and to facilitate understanding of a company's emissions and consideration of reduction measures by visualizing greenhouse gas emissions. [Solution] Server 1 comprises an input template provision unit 51, a data acquisition unit 52, and a GHG emission calculation unit 53. The input template provision unit 51 provides the user terminal with an input template in spreadsheet software format for inputting energy consumption data. The data acquisition unit 52 acquires data, including energy consumption data, entered into the input template by the user. The GHG emission calculation unit 53 calculates greenhouse gas emissions based on the data, including energy consumption data. The visualization unit 54 visualizes the calculated greenhouse gas emissions.