JP2018077844A - Calculation system, calculation method, calculation program, accounting program, accounting system, accounting terminal device and accounting method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide an information processing system which has higher convenience to a user while utilizing an advantage of spreadsheet software and to provide a calculation processing method, a calculation processing program, an accounting program, an accounting system, an accounting terminal device and an accounting method.SOLUTION: An information processing system 10 includes input means, output means, basic processing means, and state update means. The basic processing means executes processing using an expression or a value (hereafter, regarded as "definition information".) defined in relation to at least one cell of spreadsheet software to execute routine processing. The state update means has redefinition information defined in advance in areas other than an area (hereafter, regarded as "an operation planned area".) with an operation planned when a user performs the routine processing, and uses the redefinition information to update a state about an operable object when an operation is performed about at least any operable object of a cell, a row, a column, and a sheet with the definition information related to.SELECTED DRAWING: Figure 11

Description

  The present invention relates to a calculation system using spreadsheet software, a calculation method, a calculation program, an accounting program, an accounting system, an accounting terminal device, and an accounting method.

  2. Description of the Related Art Conventionally, various information processing systems corresponding to business operations are used when performing aggregation and calculation processing handled in the business operations.

  For example, one of the tasks that requires enormous calculation is accounting. Prior to computerization, accounting documents were prepared in the form and format suitable for the actual situation according to the scale of the business. Quality and financial statements are prepared.

  Therefore, there is an invention for easily creating a construction ledger even if the knowledge of financial accounting and its software is not sufficient (see, for example, Patent Document 1). According to Patent Document 1, a bill is displayed on a display on a monthly basis, and bill information issued by a supplier is input to the display, and a payment table is displayed on the display to input payment information. Is disclosed.

  A system that handles accounting data by spreadsheet software has also been developed (see, for example, Patent Document 2).

  Furthermore, a system using spreadsheet software is designed and used not only for accounting processing but also for various business processes (see, for example, Patent Document 3).

JP 2000-123075 A JP 2017-174130 JP 2013-97565 A

  Accounting software distributed in the market today is created on the assumption that large companies including listed companies will use it. Large companies such as listed companies submit financial statements to the tax office, submit them to business partners such as banks, and report to shareholders. Careful attention should be paid to the appearance of documents in financial statements submitted to business partners. When preparing economic statistics, the financial statements are used to provide the original data for aggregation. For this reason, detailed rules are strictly determined to be useful for statistics and tabulation.

  In contrast, small companies and private business owners submit their financial statements only to the tax office. In this case, a simple and simple financial statement is often sufficient. In addition, even when participating in statistics, only a rough summary value is obtained. For this reason, small companies and individual business owners seek a simple and inexpensive accounting system that specializes in financial statements for tax office submission. In addition, there is a need for an accounting system that is easy to use for managers and their employees.

  In the case of accounting processing and the like, it is particularly suitable to construct a system using spreadsheet software. This makes it possible to provide a system that is relatively inexpensive and easy to use for users such as managers and their employees.

  In general, spreadsheet software can be easily customized as a function of spreadsheet software itself (for example, addition or deletion of rows / columns in a table-type sheet by interactive operation using GUI). In addition, when the customization is performed, a function for automatically correcting an expression defined in each cell of the sheet (hereinafter referred to as “automatic correction function”) is provided.

  However, the allowable range of customization as an inherent function of the spreadsheet software and the range in which the automatic correction function associated therewith is effective are limited in constructing a user-friendly (convenient) system. I do not get.

  In other words, if you try to operate beyond these ranges, giving priority to the convenience of the system, for example, the consistency of the data at the reference destination that is the source of the calculation will not be achieved, and the expected appropriate result will not be obtained. May become a fatal problem.

  This problem exists not only in the accounting processing system but also in the entire information processing system using spreadsheet software.

  In view of such circumstances, the present invention can be constructed at low cost, and is an information processing system using spreadsheet software having a slight customization by a user and an automatic correction function associated therewith, a calculation processing method, a calculation processing program, an accounting program, In the accounting system, accounting terminal device and accounting method, while taking advantage of spreadsheet software, the information processing system, calculation processing method, calculation processing program, accounting program, accounting system, accounting terminal device, which are more convenient for the user, and It is intended to provide an accounting method.

  The present invention is an information processing system that performs predetermined routine processing using spreadsheet software, and includes an input unit, an output unit, a basic processing unit, and a state update unit, and the basic processing unit includes In order to execute the standard processing, it is possible to execute processing using an expression or value (hereinafter referred to as “definition information”) defined in relation to at least one cell of the spreadsheet software, and the state update The means includes redefinition information defined in advance in an area other than an area where an operation is scheduled when the user performs the routine process (hereinafter referred to as “operation scheduled area”), and the definition information is related to When the operation is performed on at least one of a cell, a row, a column, and a sheet that can be operated, the state of the operable object can be updated using the redefinition information. It is a processing system.

  In addition, the present invention is an information processing method for performing predetermined routine processing using spreadsheet software, and is defined in relation to at least one cell of the spreadsheet software for executing the routine processing. When an operation is performed on at least one of a cell, a row, a column, and a sheet that can be processed by using a formula or a value (hereinafter, referred to as “definition information”) And updating the state of the operable object using redefinition information previously defined in an area other than the area that is scheduled to be operated when the user performs the predetermined process. Is an information processing method characterized by

  The present invention is also an information processing program using spreadsheet software that causes a computer to execute the processing according to the above information processing method.

  Further, the present invention is an accounting program installed in a computer equipped with spreadsheet software presetting a plurality of accounting processing sheets, and between cells in one sheet of the plurality of accounting processing sheets and a plurality of An accounting program for giving an automatic processing unit for performing either one or both of automatic assignment and automatic restoration to the computer with respect to a mathematical expression relating cells in a sheet.

  Moreover, this invention is an accounting system provided with the computer which stored the spreadsheet software and the accounting program in any one of Claims 1 thru | or 3.

  Further, the present invention relates an accounting processing unit by spreadsheet software in which a plurality of accounting processing sheets are set in advance, and between cells in one sheet of the plurality of accounting processing sheets and between cells in the plurality of sheets. An accounting apparatus including an automatic processing unit that performs either one or both of automatic assignment and automatic repair, an input unit, and an output unit.

  The present invention is an accounting method in which a plurality of accounting processing sheets are set in advance for spreadsheet software, and daily transactions are input to the plurality of accounting processing sheets. When transitioning between sheets, when starting or ending spreadsheet software, when entering a formula other than a planned formula that is a cell in any of the plurality of accounting sheets, It is an accounting method in which either or both of automatic assignment and automatic repair are performed with respect to mathematical expressions relating cells in one sheet of the accounting processing sheet and cells in a plurality of sheets.

  Further, the present invention is an accounting terminal device that presets a plurality of accounting processing sheets for spreadsheet software and inputs daily transactions to the plurality of accounting processing sheets, When transitioning between processing sheets, when starting or ending spreadsheet software, when entering a formula other than the expected formula that is a cell in any of the plurality of accounting processing sheets An accounting terminal apparatus comprising an automated processing unit that performs either one or both of automatic assignment and automatic repair for a mathematical expression relating cells in one sheet of the accounting processing sheet and cells in a plurality of sheets. .

  According to the present invention, an information processing system, a calculation processing method, a calculation processing program, an accounting program, an accounting system, an accounting system that uses a spreadsheet software that can be constructed inexpensively, and has a user-customized customization and an automatic correction function associated therewith. In the terminal device and accounting method, providing information processing system, calculation processing method, calculation processing program, accounting program, accounting system, accounting terminal device, and accounting method that are more convenient for users while taking advantage of spreadsheet software can do.

It is a functional block block diagram of an accounting system when the accounting program according to the first embodiment of the present invention is installed and executed. It is a figure which shows an example of the sheet | seat of sales and purchase among several accounting process sheets which concern on 1st Embodiment of this invention. It is a figure which shows an example of the sheet | seat of a daily balance among the some accounting process sheets which concern on 1st Embodiment of this invention. It is a figure which shows an example of the sheet | seat of profit / loss calculation among the some accounting process sheets which concern on 1st Embodiment of this invention. It is a figure which shows an example of the sheet | seat of expense among the some accounting process sheets which concern on 1st Embodiment of this invention. In the accounting system concerning a 1st embodiment of the present invention, it is a flow figure showing processing of automatic grant of a numerical formula, and automatic restoration. It is a figure which shows the display condition of the output part of an accounting system regarding the condition of the automatic repair of the numerical formula by a macro in the scene where an operator deletes a mathematical expression unintentionally. It is a figure which shows the display condition of the output part of an accounting system regarding the condition of the automatic repair of the numerical formula by a macro in the scene which an operator changes a numerical formula unintentionally. It is a figure which shows the display condition of the output part of an accounting system regarding the condition of the automatic repair of the numerical formula by a macro in the scene where an operator inserts a line. It is a figure which shows the display condition of the output part of an accounting system regarding the situation where the automatic repair of the numerical formula by a macro is not made in the scene where an operator inputs a constant. It is a schematic diagram of the accounting processing system which concerns on 2nd Embodiment of this invention. It is an example of the sheet | seat of the accounting processing system which concerns on 2nd Embodiment of this invention. It is a schematic diagram explaining the state update means which concerns on 2nd Embodiment of this invention. It is a schematic diagram explaining the state update means which concerns on 2nd Embodiment of this invention. It is a schematic diagram explaining the state update means which concerns on 2nd Embodiment of this invention. It is a schematic diagram explaining the state update means which concerns on 2nd Embodiment of this invention. It is a schematic diagram explaining the state update means which concerns on 2nd Embodiment of this invention. It is a schematic diagram explaining the state update means which concerns on 2nd Embodiment of this invention. It is a schematic diagram explaining the state update means which concerns on 2nd Embodiment of this invention. It is a schematic diagram explaining the state update means which concerns on 2nd Embodiment of this invention. It is a conceptual diagram of the skewering calculation process in the accounting processing system which concerns on 2nd Embodiment of this invention. It is a schematic diagram explaining the state update means which concerns on 2nd Embodiment of this invention. It is a schematic diagram explaining the state update means which concerns on 2nd Embodiment of this invention. It is a schematic diagram explaining the state update means which concerns on 2nd Embodiment of this invention. It is a schematic diagram explaining the state update means which concerns on 2nd Embodiment of this invention. It is a schematic diagram explaining the state update means which concerns on 2nd Embodiment of this invention.

  Embodiments of the present invention will be described below with reference to the accompanying drawings.

<First Embodiment>
First, a first embodiment of the present invention will be described with reference to FIGS.

  FIG. 1 is a functional block configuration diagram of an accounting system when an accounting program according to an embodiment of the present invention is installed and executed. As shown in FIG. 1, the accounting system 1 includes at least an input unit 2, an arithmetic processing unit 3, a storage unit 4 that stores spreadsheet software and an accounting program, and an output unit 5.

  The accounting system 1 uses a computer having an input unit 2, an arithmetic processing unit 3, a spreadsheet software and a storage unit 4 storing an accounting program, and an output unit 5, and uses the computer with the spreadsheet software and accounting program 3 This is realized by processing. Here, a plurality of accounting processing sheets are preset in the spreadsheet software.

  Therefore, the arithmetic processing unit 3 constitutes an accounting processing unit 3a realized by accounting software and an automation processing unit 3b. The automation processing unit 3b performs either one or both of automatic assignment and automatic repair on a mathematical expression relating cells in one sheet of a plurality of accounting processing sheets and cells in a plurality of sheets.

  This automatic assignment or automatic repair is scheduled for a cell in one of the plurality of accounting sheets at the start or end of the accounting program when transitioning between multiple accounting sheets. This is done when at least one of the following is entered.

  As a premise for explaining automatic grant / automatic repair, the process from the start of the accounting program to the calculation of the daily profit amount and the process from the preparation of the financial statements will be explained.

  Step 1: Start the accounting program. This accounting program can be started on spreadsheet software such as Excel (registered trademark). Then, a plurality of sheets already input on the accounting program can be displayed. Sheets that can be displayed are sheets such as “sales / purchase”, “daily balance”, “income calculation”, and “expense”.

Step 2: Select “Sales / Purchase” from the sheet, and enter the contents of the invoice, that is, the customer (business partner) name, sales, and purchase. Then, sales, purchases, etc. are integrated and reflected in “Profit / Loss Calculation” and “Daily Balance”.

  Step 3: Select "Expense" from the sheet and enter various expenses. Then, expenses, miscellaneous income, etc. are accumulated and reflected in “Profit / Loss Calculation” and “Daily Balance”.

  Step 4: Select “daily balance” from the sheet, and display the daily cash balance and deposit balance. This provides information for finding human errors such as input errors and omissions.

  Step 5: When “Profit / Loss” is selected from the sheet, the daily profit amount is automatically generated. At the time of settlement, after the settlement process, the sheet can be printed and submitted to the tax office as part of the settlement report.

  Here, each sheet as a form created by the accounting program will be described. FIG. 2 is a diagram showing an example of a sales / purchase sheet among a plurality of accounting processing sheets according to the embodiment of the present invention. FIG. 3 is a daily view of a plurality of accounting processing sheets according to the embodiment of the present invention. FIG. 4 is a diagram illustrating an example of a balance sheet, FIG. 4 is a diagram illustrating an example of a profit / loss calculation sheet among a plurality of accounting processing sheets according to the embodiment of the present invention, and FIG. 4 is a plurality of accounting according to the embodiment of the present invention. It is a figure which shows an example of the sheet | seat of expense among process sheets.

  The “sales / purchase” sheet is divided into two major items: “sales / purchase, movement of goods” and “settlement information, movement of money”. The former major item “sales / purchase, movement of goods” is “No”, “date of transaction”, “account”, “customer name”, “content, quantity”, “transaction” It consists of items such as “Amount”. The latter major item “settlement information, movement of money” includes “date, month, day”, “first half / second half”, “remittance fee for our share”, “cash” deposit and withdrawal, This includes items such as deposit and withdrawal of “deposit 1”, deposit and withdrawal of “deposit 2”, deposit and withdrawal of “deposit 3”, and the like.

  The “Daily Balance” sheet is composed of items such as “cash”, “deposit 1”, “deposit 2”, “deposit 3”, etc. .

  The “Profit / Loss” sheet is broadly divided into “Monthly total” and “Total from the beginning of the year”, which are “Sales”, “Purchase”, “Sales profit”, “Miscellaneous income”, It consists of items "Expense" and "Gross profit".

  The “Expense” sheet is composed of “Date, Date”, “Expense Identification Code”, “Account”, “Cash”, and “Deposit” items that indicate the transaction date. Each deposit is made up of the following items: “Deposit”, “Withdrawal”, and “Transfer fee”. “Accounts” include communication expenses, office supplies, travel expenses, transportation expenses, outsourcing processing expenses, salary, utilities, etc. The “Profit / Loss” sheet is linked to other values using the “Expense identification code” as a key.

  The cells of each item constituting these sheets are related by mathematical formulas given by this program, and the information in the cells between the sheets is related. Relevance is well known in the accounting field. In addition, a mechanism for associating cells is known. However, the relationship formula itself is not known. It was created by the inventor himself. For example, in the “expense” sheet, the formula of the column to be automatically repaired is as follows.

  "= IF (OR (ISERR (DATEVALUE (INT (RC5 / 100) +1988 &" / "& MOD (RC5,100) &" / "& OFFSET (RC5,, 1))), RC5> 3100, RC5 < 2601), 1, IF (RC5 <OFFSET (RC5,1,), IF (RC5 = EVEN (RC5), 55,44), IF (RC6 = OFFSET (RC6, -1,)), IF (OR (OFFSET ( RC, -1,) = 4, OFFSET (RC, -1,) = 5, OFFSET (RC, -1,) = 1), OFFSET (RC, -1,), IF (RC5 = EVEN (RC5), 5,4)), IF (OR (OFFSET (RC, -1,) = 1, OFFSET (RC, -1,) = 44, OFFSET (RC, -1,) = 55), IF (RC5 = EVEN ( RC5), 5,4), 1)))) "

  Here, RC5, RC and RC6 indicate reference cells.

  Also, the linkage between the four sheets of “sales / purchase”, “daily balance”, “profit calculation”, and “expense” depends only on the formula. Even with these 4 sheets, the corporate tax can be filed in white.

  In an embodiment of the present invention, when a formula is related between cells in a certain sheet or a formula is related between cells of a certain sheet and another sheet, automatic assignment and automatic formula It has a function related to restoration.

  FIG. 6 is a flowchart showing the processing for automatically assigning mathematical expressions and automatically repairing them in the accounting system according to the embodiment of the present invention.

  First, it is determined whether to move from one sheet to another sheet or whether there is any input in a cell in a certain sheet (step 11).

  If Yes in Step 11, a cell in which a formula is to be entered in a certain sheet is examined, and it is determined whether or not a correct formula is input to the cell (Step 12).

  If No in Step 12, the correct mathematical formula is automatically given (Step 13).

  For example, in Step 12, when the cell in which the formula is to be input is blank (blank) and the determination is No, in Step 13, the formula is automatically assigned to the cell. It is possible to cope with a case where an operator unintentionally deletes a value (information) in a cell.

  For example, in Step 12, if a formula that is different from the formula that should be originally defined for a cell in which a formula is to be input on a certain sheet is input, A formula is automatically assigned to the cell. It is possible to cope with a case where an operator unintentionally selects a cell and erroneously performs a repair operation.

  For example, in Step 12, if a cell in which a formula is not input is generated because a row is inserted on a certain sheet and the determination is No, the formula is automatically assigned to the cell in Step 13. It is possible to handle the case where an operator inserts a row.

  In Step 12, if the determination is No because a constant is input to a cell on a certain sheet, the formula is not automatically input to the cell in Step 13. This is to cope with a case where an operator consciously inputs a constant into the cell. The case where it is necessary to consciously put a constant in the cell is, for example, the case where a plurality of accounts such as an account of “deposit 1” and an account of “cash” are simultaneously used for settlement of certain accounts receivable, or “deposit 2” In this case, an account that does not correspond to a mathematical expression such as “deposit 3” is used. In the “sales / purchase” sheet, a formula is defined on the assumption that when the accounts receivable is collected, the entire account is settled in either the “deposit 1” account or the “cash” account. In practice, however, other payment methods appear well. In order to be able to cope with such a case, input of a constant value is permitted.

  As shown in FIG. 1, the accounting terminal device 1 according to the embodiment of the present invention is realized by executing an accounting program in the accounting system 1, and is based on spreadsheet software in which a plurality of accounting processing sheets are set in advance. An accounting processing unit 3A, and an automation processing unit 3B that performs either or both of automatic assignment and automatic repair on a mathematical expression relating cells in one sheet of a plurality of accounting processing sheets and cells in a plurality of sheets , An input unit 2 and an output unit 5.

  By using such an accounting terminal device 1, as an accounting method according to the embodiment of the present invention, a plurality of accounting processing sheets are set in advance for spreadsheet software, and a plurality of accounting processing sheets are When a transaction is entered, when transitioning between multiple accounting sheets, the spreadsheet software is activated or terminated, and is scheduled to be a cell in any of the multiple accounting sheets. When entering a formula other than a formula, one or both of automatic assignment and automatic repair can be performed on a formula that relates cells in one sheet of a plurality of accounting sheets and cells in a plurality of sheets. .

  In the embodiment of the present invention, since the formulas are automatically assigned and automatically repaired in this way, the correct calculation result is displayed by defining the correct formula in a cell within a certain sheet or between sheets. Can do. Therefore, even if there is one or both of insertion and deletion of a row in a certain sheet, it is possible to automatically assign a mathematical expression and automatically repair it in accordance with the insertion and deletion. As a technique for defining a correct formula in a cell, Excel (registered trademark) has a function of “cell protection and worksheet protection”. If these functions are incorporated, the system becomes inconvenient. The automatic assignment / restoration of formulas according to the present invention is a technique with excellent robustness and flexibility that allows a constant formula to be input when necessary while defining a correct formula in a cell.

  This automatic formula addition and repair function not only determines whether to move from one sheet to another or whether there is any input in a cell on a certain sheet, but also allows an operator to specify a specific instruction, for example, “ You may turn on the “Repair” button or save the file.

  Hereinafter, a description will be given assuming a specific scene. FIG. 7 is a diagram illustrating a display status of the output unit 4 of the accounting system 1 regarding a status of automatic repair of a mathematical formula by a macro in a scene where an operator unintentionally deletes the mathematical formula.

  In the “sales / purchase” sheet, it is assumed that a mathematical formula is input in advance for the deposit of “deposit” in “settlement information, movement of money”. That is, as shown in FIG. 7A, the formula is displayed in the formula bar at the top of the screen of the display unit 4.

  Thereafter, as shown in FIG. 7B, if the operator deletes the formula, the state immediately after that is a cell to which the formula is to be input as shown in FIG. Blank).

  After a while, for example, after waiting for about 1 second, a correct mathematical expression is given as shown in FIG.

  FIG. 8 is a diagram illustrating a display status of the output unit 4 of the accounting system 1 regarding a status of automatic repair of a mathematical formula by a macro in a scene where an operator unintentionally changes the mathematical formula.

  In the “sales / purchase” sheet, it is assumed that a mathematical formula is input in advance for the deposit of “deposit” in “settlement information, movement of money”. That is, as shown in FIG. 8A, the mathematical formula is displayed in the mathematical formula bar at the top of the screen of the display unit 4.

  Thereafter, as shown in FIG. 8B, if the operator adds “+456” to the mathematical expression, the state immediately after that is the mathematical expression to be originally defined as shown in FIG. 8B. Since a different mathematical formula is input, the modified mathematical formula is calculated, and the amount of money of 456 yen is displayed in the cell of the “deposit” column.

  After a while, for example, after waiting for about 1 second, the correct mathematical formula is restored as shown in FIG.

  FIG. 9 is a diagram illustrating a display status of the output unit 4 of the accounting system 1 regarding a status of automatic repair of a mathematical expression by a macro in a scene where an operator inserts a row.

  When the operator tries to insert a row in the “sales / purchase” sheet, as shown in FIG. 9A, “OK”, “Cancel” regarding whether or not the cell can be inserted in the entire row. Selected state.

  When “OK” is selected, as shown in FIG. 9B, a row is inserted, and thus a cell in which no mathematical expression is input is generated.

  After a while, for example, after waiting for about 1 second, a correct mathematical formula is given as shown in FIG.

  FIG. 10 is a diagram illustrating a display state of the output unit 4 of the accounting system 1 in a situation where the mathematical formula is not automatically repaired by the macro in a scene where the operator inputs a constant.

  In the “sales / purchase” sheet, it is assumed that a mathematical formula is input in advance for the deposit of “deposit” in “settlement information, movement of money”. That is, as shown in FIG. 10A, the mathematical formula is displayed in the mathematical formula bar at the top of the screen of the display unit 4.

  Thereafter, as shown in FIG. 10B, the operator inputs “234000” as a constant after deleting the mathematical expression. Then, the macro does not work, and the input of the constant “234000” is accepted as shown in FIG.

  As described above, the accounting program of the present embodiment is an accounting program installed in a computer on which spreadsheet software in which a plurality of accounting processing sheets are set in advance is installed. An accounting program that assigns an automatic processing unit that performs either or both of automatic assignment and automatic repair to the computer with respect to mathematical formulas that relate cells in a sheet and cells in a plurality of sheets.

  In the accounting program, the plurality of accounting processing sheets are a set of a sales / purchase sheet, a daily balance sheet, a profit / loss calculation sheet, and an expense sheet.

  In the accounting program, the automation processing unit performs a plurality of accounting processing sheets at the time of either starting or ending the accounting program when transitioning between the plurality of accounting processing sheets for automatic grant and automatic repair. This is performed when at least one of the cells in any one of the sheets is input other than the expected formula.

  Further, the accounting system of this embodiment includes a computer storing spreadsheet software and the accounting program of the present invention.

  In addition, the accounting terminal device according to the present embodiment includes an accounting processing unit using spreadsheet software in which a plurality of accounting processing sheets are set in advance, cells between one sheet in a plurality of accounting processing sheets, and cells in a plurality of sheets. An automatic processing unit that performs either one or both of automatic assignment and automatic repair, an input unit, and an output unit are provided.

  The accounting method of the present embodiment is an accounting method in which a plurality of accounting processing sheets are set in advance for spreadsheet software, and daily transactions are input to the plurality of accounting processing sheets. When transitioning between accounting sheets, when starting or ending spreadsheet software, when entering a non-scheduled formula that is a cell in any sheet of multiple accounting sheets One or both of automatic assignment and automatic repair are performed with respect to mathematical formulas relating cells in one sheet and between cells in a plurality of sheets.

  According to the invention according to the above-described embodiment, with respect to spreadsheet software in which a plurality of accounting processing sheets is set in advance, between cells in one sheet of a plurality of accounting processing sheets and between cells in a plurality of sheets. Regarding the arithmetic expression to be related, either one or both of automatic assignment and automatic repair is performed. Therefore, a plurality of accounting processing sheets can be set according to the scale of the individual business owner or the small company, and any person who has a minimum knowledge about the spreadsheet software can use it. Therefore, it is possible to provide an accounting program and an accounting system that can be created according to the scale and appearance of a small company or individual business owner.

Second Embodiment
Next, an information processing system (information processing apparatus) 10 will be described as a second embodiment of the present invention with reference to FIGS.

<Overall configuration>
FIG. 11 is a schematic diagram illustrating an example of the configuration of the information processing system 10 according to the present embodiment. FIG. 11A is a schematic diagram illustrating the hardware configuration of the information processing system 10, and FIG. 2C is a block diagram illustrating an example of functions of the information processing system 10.

  As shown in FIG. 2A, the information processing system 10 of the second embodiment includes an information processing terminal 19 that can execute spreadsheet software. Here, as an example, a case where the information processing system 10 is configured by a single information processing terminal 19, that is, the information processing system 10 is also an information processing device will be described.

  The information processing terminal 19 is, for example, a known personal computer including an input unit 11, an output unit 12, a control unit 13, a storage unit 14, and the like. The input unit 11 is, for example, a keyboard or a touch panel, and may include a mouse, a microphone, and a monitor that realizes a pointing device function in cooperation with the mouse. The output unit 12 is a display, for example, and may include other speakers, printers, and the like.

  The control means 13 is a CPU (Central Processing Unit) that comprehensively controls the information processing terminal 19 (information processing system 10). The storage means 14 is, for example, a memory device such as a RAM (Random Access Memory) and a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, and the like, and an OS (Operating System) or the like. Stores control programs, programs that define various processing procedures, and required data. The control means 13 executes various information processing based on these programs stored in the storage means 14.

  In addition, the storage unit 14 includes, for example, an application program for the spreadsheet software 16 and a program for realizing the information processing system 10 of the present embodiment constructed by using the spreadsheet software (information processing program 20). Is stored.

  The information processing system 10 may include an information processing terminal 19 having a communication interface, a server (not shown), and a network that connects the information processing terminal 19 and the server so that they can communicate with each other. In this case, the server stores, for example, various data including accounting data and various application programs including spreadsheet software, and the information processing terminal 19 acquires these data and application programs via the network, and stores the storage means 14. It may be configured to be able to execute various processes by storing in the storage.

  The information processing terminal 19 is not limited to a personal computer, and may be a portable information processing device such as a PDA (Personal Digital Assistant), a smartphone, or a tablet terminal.

  Referring to FIG. 1B, an information processing system (information processing apparatus) 10 according to the present embodiment includes the hardware described above, an OS and a spreadsheet software 16 program, and an information processing program 20 according to the present embodiment. In cooperation with software, an information processing function including a basic processing function and a state update function for executing a predetermined routine process is realized.

  That is, the information processing system (information processing apparatus) 10 is configured to be able to execute predetermined routine processing using the spreadsheet software 16 as its function, and realizes input means 11, output means 12, and basic processing functions. Basic processing means 15 for performing the state update processing, and state update processing means 17 for realizing the state update function.

  Here, in the following example, a case where the predetermined fixed process is an accounting process and the information processing system 10 is an accounting process system will be described.

  In addition, the information processing system 10 of the second embodiment may or may not include the accounting system 1 of the first embodiment. When the accounting system 1 of the first embodiment is included in the information processing system 10 of the second embodiment, the basic processing means 15 of the second embodiment includes, for example, the accounting processing unit 3a of the first embodiment. The state update processing unit 17 of the second embodiment may include, for example, the automation processing unit 3b of the first embodiment.

  An information processing program 20 constituting the information processing system 10 of this embodiment (an accounting processing program 20 constituting the accounting processing system 10) is a program designed by the provider of the accounting processing system 10 using the spreadsheet software 16. is there. The spreadsheet software 16 is also called a spreadsheet. By defining information in a plurality of cells arranged in a row direction and a column direction, processing including various operations can be executed.

  As a system that handles a large amount of data, a relational database (RDB) is generally used in many cases. However, a system using RDB has problems that are difficult to handle for a small user, such as a function that is too complex or difficult to customize. On the other hand, the spreadsheet software 16 is configured so that the user operates in the first place while creating a mechanism in a table format (writing necessary calculations and the like in the cells). For this reason, it becomes possible to operate while reproducing an environment familiar to the user like a conventional handwritten book. In this embodiment, a case where Excel (registered trademark) of Microsoft Corporation is used as an example of spreadsheet software will be described.

  The spreadsheet software 16 is known as described above, and includes various functions provided by the manufacturer of the spreadsheet software 16. Hereinafter, various functions originally provided in the spreadsheet software 16 are collectively referred to as “basic functions”. Basic functions include operators, functions, macro recording means, addition / deletion of rows / columns, addition / deletion of sheets, and the like for performing various operations. In addition, it is configured such that rows and columns can be added or deleted by interactive operation using a GUI (Graphical User Interface), and arithmetic expressions (formulas and character string formulas that span rows or columns in a certain cell. The same applies hereinafter). ) Is set, a function that automatically corrects the arithmetic expression (hereinafter referred to as an “automatic correction function”) when a row or column is added or deleted by interactive operation using the GUI. Also have. This automatic correction function is also included in the basic function.

  As shown in FIG. 5B, the accounting processing program 20 has an accounting basic processing program 21 and a state update processing program 23. The accounting basic processing program 21 uses each basic function of the spreadsheet software 16 so that predetermined routine processing (accounting processing) can be executed, that is, in order to realize the original function of accounting processing, Is a program designed using definitions of functions and macros for macros, etc., and by executing the program, accounting processing such as ordinary profit and loss calculation, balance calculation and journal entry can be performed.

  The state update processing program 23 operates the operation target (cell, row, sheet) when the accounting processing system 10 is started, when some processing of the accounting basic processing program 21 is executed, or by an end user. Specifically, there are cell operations (input, deletion, etc.), row / column operations (insertion, deletion, movement), sheet operations (addition, deletion, replacement), etc. When the original configuration (the configuration intended by the designer) is changed, the state of the operation target object so that the original configuration of the accounting basic processing program 21 can be executed or returned to the original configuration. Is a program that updates (automatically repairs). The state update processing program 23 is designed using basic functions (functions, operators, macros, etc.) of the spreadsheet software 16, and will be described in detail later. A function for invalidating a part of the function (for example, an automatic correction function) is also included.

  Referring to FIG. 5C to FIG. 8E, the basic processing means 15 includes an accounting basic processing program 21 and includes a standard processing (in this case, accounting processing (obtaining the desired result in accounting processing). In order to execute the calculation processing for the calculation processing), the same applies hereinafter, the definition information S defined in relation to at least one cell of the spreadsheet software 16 can be executed as the accounting basic processing program 21.

  The definition information S in this embodiment is information that constitutes a part of the basic accounting processing program 21, and functions and calculations that are defined (set) in the cell in advance using the basic function of the spreadsheet software 16. All values that can be entered in a cell, such as formulas (formulas, character string formulas), character strings, and numerical values. Further, the definition information S is defined for a cell in an area (hereinafter referred to as “operation scheduled area 22”) that is scheduled for a user operation (numerical value input or the like) on the sheet of the spreadsheet software 16. Information (value). In this case, information that is directly defined (described) in the scheduled operation area 22 and information that is defined (described) in the target cell (in the cell specified by the macro) by executing the macro are included.

  The basic processing means 15 is a means for executing basic functions of the spreadsheet software 16 (including an automatic correction function and execution of a macro included in the accounting basic processing program 21).

  The basic processing means 15 executes the basic accounting processing program 21 based on the numerical value or the like input by the user to the cell of the scheduled operation area 22, and executes the desired accounting processing using the definition information S and the macro.

  The state update processing unit 17 includes the state update processing program 23 and is a unit that can update the state of the operable object using the redefinition information R. The timing at which the status update processing means 17 updates the status is when the accounting processing system 10 is started, when some processing is executed by the accounting basic processing program 21, or the cell, row, column, sheet to which the definition information S is related. This is a time when a user (end user of the accounting processing system 10, the same applies hereinafter) is operated on at least one of the operable targets.

  Specifically, the state update processing unit 17 can execute the redefinition information R and a macro using the same by executing the state update processing program 23, and thereby update the state of the operable target. In the following description, the macro constituting the accounting basic processing program 21 is referred to as “accounting basic macro”, and the macro constituting the state update processing program 23 is referred to as “redefinition macro”.

  Here, the “macro” in the present embodiment refers to a set of instructions that can be executed inside the application, and in this example, refers to a set of instructions that automate a series of processing procedures in the spreadsheet software 16. In more detail, the “macro” of the present embodiment uses a macro or macro language (computer language describing a macro) that automatically stores and executes a plurality of procedures using a keyboard macro that records and reproduces key operations as they are. Macros that call and execute processing procedures described by programming, those that control the existing functions of the spreadsheet software 16 in programming languages such as VisualBasic, and the existing functions (basic functions such as arithmetic expressions) of the spreadsheet software 16 This refers to all or part of the functions that are combined to form a single function (control by language is not essential).

  For example, the accounting basic macro may be a set of instructions that automatically execute a single function by combining the basic functions of the spreadsheet software 16, and the redefinition macro is a basic function of the spreadsheet software 16. May be a set of instructions that automatically execute a predetermined function using a macro language or a programming language.

  The status update processing means 17 has been operated (addition, insertion, deletion, copying) at a certain timing when the accounting processing system 10 is started or when the accounting basic processing program 21 is executed, or a row or column related to the definition information S. And when any value is overwritten in the cell in which the definition information S is defined or the contents of the cell are deleted, the definition information is assigned to at least one cell by using the redefinition information R and the redefinition macro. Redefine S.

  The redefinition information R is a function, arithmetic expression (formula, character string expression) that is defined (set) in advance in at least one cell of the spreadsheet software 16 as part of the state update processing program 23 in the same manner as the definition information S. ), All values that can be entered in the cell, such as character strings and numerical values. However, while the definition information S is defined for the cell in the scheduled operation area 22, the redefinition information R is set in the redefinition information setting area 25 other than the scheduled operation area 22 on the sheet. . The redefinition information setting area 25 is normally an area that is not visually recognized by the user and is not a user operation target (an operation by the user is not scheduled).

  The redefinition information R re-defines the definition information S originally defined when the cell in which the definition information S is defined is changed (deleted, overwritten, etc.) to a value other than the definition information S by a user operation. Information for defining. More specifically, as shown in (C) and (D) of the figure, when certain definition information S included in the definition information generation field 27 is changed by a user operation, the (E) of FIG. As shown, the definition information S is information for restoring the definition information S that was originally defined by copying the redefinition information R in the definition information generation field 27. The content (value) of the redefinition information R may be the same as the content (value) of the definition information S in the definition information generation column 27, or the value of the redefinition information R is copied to a cell in the definition information generation column 27 As a result, the value may be the same as the content of the definition information S by the automatic correction function of the spreadsheet software 16.

  In addition, the basic processing unit 15 executes processing for a plurality of sheets by executing the accounting basic processing program 21 (for example, the definition information S defined in the cells in one sheet is defined in the cells in other sheets. In some cases, the definition information S is referred to, or the definition information S of the cells existing in the same area (address) in a plurality of sheets is calculated by skewing. The state update processing unit 17 refers to a sheet that has been added or replaced when the basic processing unit 15 executes processing for a plurality of sheets when a sheet is added or replaced. Thus, the state of the operable target is updated.

  The accounting processing system 10 according to the present embodiment uses the spreadsheet software 16 to reproduce an environment familiar to the user like a conventional handwritten book and to allow the user to make slight customizations. It is possible to operate highly.

  That is, in order to improve the convenience and versatility of the user's operation, the user's input restriction and operation restriction are reduced as much as possible. For this reason, the basic functions are utilized as much as possible, and slight customization (insertion / deletion of rows, addition / deletion / duplication of sheets, etc.) by the user is allowed, and the operation scheduled area 22 is as wide as possible (non-display area) (As much as possible) (allows operation of sheets and cells), and allows arbitrary input in the scheduled operation area 22.

  However, in the case of the spreadsheet software 16, the input of information (such as values) by the user, the definition (setting) of the definition information S, and the output format (such as a form) are all shared by cells in the sheet. For this reason, it is very difficult to customize the input screen alone or the output form alone. Specifically, when the definition information S is defined as the accounting basic processing program 21 for a certain cell on the input screen, the user inadvertently deletes the cell to make a desired input screen. If overwriting is performed, the definition information S is deleted, and a desired calculation result cannot be obtained. Thus, if there is customization by the user, stability as the accounting processing system 10 cannot be guaranteed.

  The spreadsheet software 16 generally has an automatic correction function. However, the automatic correction function is effective only within a certain operation range, and customization (line correction) exceeding the range is possible. , Deletion, etc.), or if the correction is made mechanically by an automatic correction function within a range that is not assumed by the user, there is a problem that consistency of calculation results cannot be maintained.

  Therefore, in the present embodiment, the changed definition information S is updated (redefined) using the redefinition information R and the redefinition macro outside the scheduled operation area 22 as necessary.

  Thus, for example, when the user operates (adds, deletes, etc.) an operation target of at least one of a row, a column, a cell, and a sheet related to a cell in which the definition information S is defined (set), Even when the processing system 10 is in a state in which the processing originally assumed cannot be performed (the expected appropriate result cannot be obtained), the state update processing unit 17 displays the redefinition information R and the redefinition macro. By using and redefining the definition information S in at least one cell, it is possible to return the operable target to a state where the originally assumed processing can be performed (a proper expected result can be obtained).

  Hereinafter, further explanation will be given while showing a specific example of the accounting processing system 10. The processing contents and configuration of the accounting processing (calculation) executed by the accounting basic processing program 21 are the same as those of the known accounting processing, so the following mainly describes the state update processing means 17 of the present embodiment. An example will be described.

<Accounting system sheet>
FIG. 12 is a diagram illustrating an example of various sheets used in the accounting processing system 10 (accounting processing program 20) according to the present embodiment. The accounting processing system 10 has, for example, an expense sheet, a sales / purchase sheet, a regular journal sheet, an additional sheet, and a form sheet. These sheets and programs are not necessarily configured in a single file (workbook). All or a part of these may be stored in a computer or storage on a network as well as in a single information processing terminal 19.

  Expense sheets, sales / purchase sheets, and regular journal sheets can be inserted at least (the number of data items can be added in the line direction), for example, and the display range on the output means (display) 12 is changed by a vertical scroll bar. This is a list format sheet. A sheet in a form format is a sheet that cannot be inserted into a row (the number of data items cannot be added in the row direction) and does not have a vertical scroll bar. A plurality of form sheets are prepared for one additional sheet (can be added at any time), and predetermined areas of the plurality of form sheets are gathered together by a skewer operation and collected into the additional sheet.

  An accounting basic processing program 21 is set so that predetermined accounting processing can be executed for each of the sheets. Specifically, predetermined definition information S is appropriately defined in each sheet cell, and an accounting basic macro is defined (set).

  Further, a state update processing program 23 is set for some or all sheets. That is, the redefinition information R is defined in the redefinition information setting area 25, and a redefinition macro is defined (set).

  In the present embodiment, these sheets can be used to customize the book organization (addition or change of functions for each user) for each user as in a conventional handwritten book. In addition, the sheet | seat of the accounting processing system 10 is not restricted to the example shown in FIG.

<State update processing means>
FIG. 13 is a diagram showing an overview of the state update processing means 17. As shown in FIG. 2A, the state update processing means 17 updates the cell definition information S at an arbitrary timing such as when the accounting processing system 10 is started or when the accounting basic processing program 21 is executed. A first state update processing unit 171 that performs a state update process, a second state update processing unit 172 that performs a second state update process that repairs the definition information S defined in a certain cell, and A third state update processing unit 173 that performs a third state update process according to a change state (changed value) with respect to a cell in which the definition information S is defined, and a sheet is operated in a process across a plurality of sheets. And fourth state update processing means 174 for performing the fourth state update processing in the case of

<Status update processing means / first status update processing means (first status update processing)>
The first state update processing means 171 will be described with reference to FIGS.

  The first state update processing unit 171 maintains the automatic correction function as a basic function as it is, and even after a row / column operation has been performed, if the cell content is changed, the cell can be By updating the definition information S, it is a means for maintaining the consistency of the accounting process executed by the accounting basic macro. For example, the state updating process is executed in the accounting basic macro. As a result, predetermined definition information S (for example, in a cell referred to by the accounting basic macro at any timing such as when the accounting processing system 10 is started up or when a user operation is performed during the processing of the accounting basic processing program 21). It is configured to redefine (reset) default arithmetic expressions.

  As a result, even when the definition information S of a certain cell referred to by the accounting basic macro is changed when the user performs a row / column operation, the consistency is the same as when the user does not perform the operation. The defined definition information S is referred to.

[Status update processing for each column]
First, the state update processing for each column will be described with reference to FIGS. These are examples for explaining the method of maintaining the consistency of accounting basic macro processing by updating the cell definition information S for each column. When the user operates the column, the automatic correction function works and the cell An example in which the content of is shifted in the column direction is shown.

  As shown in the upper part of FIG. 5B, as a part of the basic accounting macro processing, for example, “Title 1” is assigned to, for example, the 2017/10/2 row (“D4” address cell) in the “Title 3” column. For the purpose of calculating the sum of the value of the column 2017/10/2 in the column and the value of the column 2017/10/2 in the “title 2” column (determining the sum of the information of the address B4 and the address C4), “= B4 + C4 ”Is defined (set) as a character string.

  In this case, when the user inserts a column into the C column, as shown in the lower part of FIG. At this time, the contents of the cells in the columns C and subsequent columns (definition information S) are also corrected by the automatic correction function of the spreadsheet software 16, for example, the content of the cell at the address “E4” is changed to “= B4 + D4”. (Hereafter, the cell address is described only in the row and column, and the description of “address” is omitted). That is, even if a column is inserted, the content of the “E4” cell is changed to the value of 2017/10/2 row in the “title 1” column and 2017/10/2 in the “title 2” column by the automatic correction function. The row value is modified to be added up, and the value before the column insertion is maintained.

  Here, if each cell is not protected in the upper part of the figure (B) and any input by the user is possible, the contents of the “D4” cell are overwritten by other values unintentionally by the user. Or it may be deleted. In such a case, as a means for automatically returning the “D4” cell to the original state, as shown in FIG. 6, a repair macro (redefinition macro including at least an instruction “write“ = B4 + C4 ”in the“ D4 ”cell” ”. ).

  However, in this repair macro, after the column is inserted as shown in the lower part of FIG. 5B, the “D4” cell is written instead of the “E4” cell to be originally repaired. In other words, repair macros that directly redefine cells to be repaired cannot handle repairs after row or column operations have been performed. Need to be rewritten after insertion).

  Therefore, in the present embodiment, even when the first state update processing unit 171 repairs the cell after the user performs an operation such as row / column, the state of the cell that should be repaired is updated, The restoration was made so that the expected result (predetermined result) was obtained.

  Specifically, as shown in FIGS. 10C and 10D, the first state update processing means 171 redefines the redefinition information R for redefining the cells included in the definition information generation column 27 in the column direction. And have a redefinition macro. This redefinition information R is set in a redefinition information setting area 25 other than the scheduled operation area 22. Here, the redefinition information setting area 25 is provided in a line (in this example, the first line) above the line in which the title is defined (in this example, the second line). By providing the redefinition information setting area 25 in a line above the line where the title is defined (outside area), it is possible to prevent the user from inadvertently operating (changing) the redefinition information R. Note that the line where the title is set and the line where the redefinition information setting area 25 is provided are not limited to this example. For example, the title is set as the fifth line and the redefinition information setting area 25 is set as the second line. May be.

  The value of the redefinition information R is a value that is the same as the value of the definition information S that was originally defined as a result of being copied (copied) to the cell in the definition information generation field 27 (that is, the cell to be repaired). is there. Further, the redefinition macro “redefines the redefinition information R set in the redefinition information setting area 25 of the column in which the repair target cell exists, the cell of the definition information generation column 27 in the same column (that is, the repair target cell). A macro that executes at least an instruction of “copy to”).

  For example, when the content (value) of the “D4” cell shown in FIG. 6C is defined as “= B4 + C4” as in the upper part of FIG. 5B, the redefinition information R in the D column is “= B1 + C1”. " Then, if the contents of the “D4” cell are deleted by the user's operation and then the “D4” cell is to be returned to the original state, the cell in the definition information generation column 27 in the same row as the redefinition information R by the redefinition macro (In this example, “D4” cell). Then, the automatic correction function of the spreadsheet software 16 works, and the content (value) of the “D4” cell is defined (redefined) as “= B4 + C4”.

  When the user inserts a column into the C column from the state shown in FIG. 8C, the columns after the C column move one column to the right as shown in FIG. At this time, by the automatic correction function of the spreadsheet software 16, the redefinition information R and the definition information generation column 27 are also moved to the E column, and the content (value) of the redefinition information R is also corrected to “= B1 + D1”.

  After that, the contents of the “E4” cell are deleted by the user's operation, and when it is desired to return the “E4” cell to the original state thereafter, the redefinition macro R1 sets the redefinition information R of the “E1” cell in the same column. Copy to the cell of the definition information generation column 27 (in this example, “E4” cell). Then, the automatic correction function of the spreadsheet software 16 works, and the content (value) of the “E4” cell is defined (redefined) as “= B4 + D4”. There are two types of cell notation in Excel (registered trademark): R1C1 format and A1 format. Here, the notation of the cell is expressed in “A1 format”. The same can be expressed in the R1C1 format, but is omitted.

  Thus, even if the definition information S defined by the accounting basic processing program is changed by the user after the column direction operation by the user is performed, the first state updating unit 171 does not change the changed cell. On the other hand, the definition information S can be redefined in the cell in which the change has been made (so that a result as expected can be obtained by the accounting basic processing program 21).

  As described above, the state update processing unit 17 of the present embodiment is configured to maintain the consistency of the calculation result when the cell is referred to in the accounting basic macro while utilizing the automatic correction function of the spreadsheet software 16. Has been.

  In this example, the redefinition information setting area 25 in the column direction is set in the second row ("D2" cell in the same figure (C)), but the redefinition information setting area 25 is outside the scheduled operation area 22. The area may be set to an area that the user does not carelessly operate, and is not limited to the second line. The redefinition information setting area 25 may be provided in a different column from the definition information generation field 27.

  In addition, the accounting basic macro and the state update processing macro are not limited to being completely separated, and when the cell is referenced in the accounting basic macro, the redefinition information R and the redefinition macro are included (re- In some cases, the target cell may be referred to (in the defined state). In other words, at least a part of the redefinition macro may be described in the basic accounting macro. A plurality of redefinition information R and redefinition information setting area 25 may be provided in the column direction.

  As described above, the redefinition information R in the column direction is the definition information S applied to the predetermined definition information generation column 27 (one or a plurality in the row direction) of each column in which the redefinition information setting area 25 is provided. Is information (for example, an arithmetic expression) for redefining (in some cases, initial setting).

  The case of inserting a column has been described above, but the same applies when a column is deleted. Further, when an arithmetic expression including a cell address is defined as the redefinition information R, the cell reference may be a relative reference or an absolute reference depending on the processing content. Furthermore, the redefinition information R may be a function, a fixed value, a character string, or the like.

[State update process for each row]
Although not shown, the first state updating unit 171 can maintain the consistency of the accounting basic macro process by updating the cell definition information S for each row.

  In this case, the redefinition information setting area 25 in the row direction is set in the outer area (for example, the second column) of the scheduled operation area 22, and the redefinition information R in the row direction is defined. The redefinition information R in the row direction redefines the definition information S applied to a predetermined definition information generation column 27 (one or more arranged in the column direction) of each row in which the redefinition information setting area 25 is provided ( Information (for example, an arithmetic expression).

  The first state update processing unit 171 updates the state of the reference target cell with the redefinition information R in the row direction and the redefinition macro. That is, for example, when a certain cell is referred to by the accounting basic macro, the redefinition macro using the redefinition information R in the row direction is executed (within the accounting basic macro) before the reference. The redefinition macro in this case is “the redefinition information R set in the redefinition information setting area 25 of the row where the cell to be repaired exists is changed to the cell of the definition information generation column 27 in the same row (that is, the target of repair This is a macro that executes and executes at least the instruction "copy to cell)"

  When a cell adjacent in the row direction and / or column direction is referred to in a certain cell (reference cell), the reference cell and the movement position (row, column) from the reference cell It is advisable to define the redefinition information R using a function that designates (OFFSET function in the case of Excel (registered trademark)). According to the OFFSET function, it is possible to refer to adjacent cells without being affected by the operation of the row / column by the user.

  The first status update processing unit 171 can update the status of any sheet of the accounting processing system 10. That is, the first state update processing by the first state update processing unit 171 is a basic concept of the state update processing in the present embodiment. In the second state update processing unit 172 to the fourth state update processing unit 174, the cell The process using the first state update process described above is performed in accordance with the sheet repair status. Further, in the accounting processing system 10 of the present embodiment, the first state update processing unit is not limited to the state update processing in the second state update processing unit 172 to the fourth state update processing unit 174 described below, but also in the cell repair. In some cases, state update processing (utilizing this) 171 is performed.

  Various settings of sheets (cells) for performing state update processing by the state update processing unit 17 are also a part of the state update processing unit 17 (the same applies hereinafter).

<State update processing means / second state update processing means (second state update processing)>
The second state update processing unit 172 will be described with reference to FIGS. The second state update processing means 172 is a means for performing second state update processing for repairing, when the definition information S defined in a certain cell is changed, regardless of the change contents of the cell. The sheet to be subjected to the second state update process is, for example, at least one of an expense sheet, a sales / purchase sheet, a regular journal sheet, and an additional sheet (see FIG. 12). In addition, the sheet | seat demonstrated by this embodiment is an example, and there may exist other sheets.

  The second state update processing unit 172 moves, for example, an event when the value of a cell is changed (for example, a change event in Excel (registered trademark)), or moves to another sheet (a sheet that has been active until then is not displayed). The second state update process for redefining part or all of the cells in which the definition information S is defined is triggered by an event that occurs at the time of activation (for example, DeActivate event in Excel (registered trademark)). .

  Further, the second state update processing unit 172 updates the state of a certain range of specific cells in the scheduled operation area 22. In detail, a predetermined name (“cell range name” in Excel (registered trademark)) is given in advance to a range of a cell subject to state update, and the cells in the range to which the cell range name is attached When cell input, information pasting, clearing, cutting, etc. are performed (in such a case, a Change event occurs, hereinafter referred to as “when a Change event occurs”), or when moving to another sheet (such as this In such a case, a DeActivate event occurs (hereinafter referred to as “when the DeActivate event occurs”), and the state update process is performed for the cells in the cell range name.

  This will be specifically described with reference to FIGS. Both figures show an expense sheet as an example. In this example, as shown in FIG. 14A, the cell range name “n sort column” is assigned to the 4, 5, 6, 7, and 10 columns of the second row in advance, and these are redefined information. Predetermined redefinition information R is defined for each setting area 25. In addition, the cell range name “n year and month” is assigned to the 33rd to 4999th rows in columns other than the column to which the cell range name is assigned (for example, the eighth column). In this example, the cell range of the cell range name “n year and month” is not limited to this example, and varies depending on the row insertion or row deletion.

  Then, the range indicated by the broken line in FIG. 5B specified by the column of the cell range name “n sort column” and the row of “n year and month” (for example, 33 rows of 4, 5, 6, 7, and 10 columns) 4999 line) is the target range of the second state update process. In the example shown in the figure, the ranges of the 2nd to 31st rows and the 3rd, 4th, and 7th columns in the sheet are areas that are not displayed during operation by the user as management areas of the accounting system 10.

  The second state update process is performed by the following procedure using a redefinition macro.

[When a change event occurs]
First, the redefinition macro acquires a cell including one or more cells that have been operated as the trigger of the occurrence of the Change event, and whether the changed cell is included in the target range of the second state update process. Judge whether or not.

  For example, with reference to FIG. 15 (A), it is assumed that the contents of cells indicated by bold lines in the target range of the second state update process are deleted (cleared). Since the 6th, 7th, and 10th columns of the area indicated by the bold line are all included in the target range of the second state update process, the 6th, 7th, and 10th cells of the area indicated by the bold line are the second status update. A cell to be processed (a correction target cell). The redefinition macro acquires the correction target cell and updates the state (redefinition of the cell definition information S). In the second status update process, if there is one or more correction target cells, the status is updated. If there is no correction target cell, this process is terminated.

  The redefinition macro divides the cell to be corrected into columns, and redefines information setting area 25 for each column (in this example, the second row of six columns, the second row of seven columns, and the second row of ten columns). The redefinition information R (for example, a normal function or an arithmetic expression) set in the (line)) is sequentially overwritten on the correction target cell of the column, and the state of the correction target cell is updated (rewritten in the definition information S). ) The redefinition macro updates the status of the next column when the status update of one column is completed.

  As described in the first state update processing, the redefinition information R defined in the redefinition information setting area 25 that is outside the scheduled operation area 22 and is normally hidden when the user operates is corrected. By overwriting the target cell, the content of the correction target cell can be restored to the content (definition information S) assumed in the accounting basic macro. In addition, even if there is a row operation (row insertion or row deletion) related to the correction target cell, it is possible to maintain the consistency of the calculation results when referring to the correction target cell in the accounting basic macro (below) The same applies to the state update process in FIG.

  Even if the contents of the correction target cell are deleted (values are cleared) by such processing, for example, as shown in FIG. 5B, as shown in FIG. With R, normal definition information S (for example, a normal function or an arithmetic expression) is redefined for each cell to be corrected.

  In the state shown in FIG. 6C, the definition information S is redefined and displayed in the 6th and 7th columns, but the 10th column is blank. This is because the normal definition information S is redefined by the redefinition information R.

  For example, the redefinition information R defined in the second row of the tenth column is the following arithmetic expression.

      "= IFERROR (TEXT (DATEVALUE (INT ($ H2 / 100) +1988 &" / "& MOD ($ H2,100) &" / "& $ I2)," aaa ")," ")"

  The meaning of this arithmetic expression is “when a value that can be interpreted as a date is given, the day of the week is displayed, otherwise a blank is displayed”. That is, blank 10 is displayed in column 10 in FIG. 10C because normal definition information S is redefined by redefinition information R, but a value that can be interpreted as a date is not given. .

  FIG. 16 is a schematic diagram illustrating an example of the second state update process when a row is inserted. In this case, the target range of the second state update process is specified from the C column to the F column of the cell range name “n sort column” and the 33rd to 4999 rows of the cell range name “n year and month” as illustrated. Range.

  In this state, when one line is inserted between the 101st line and the 102nd line by the user's operation, a Change event occurs, and the 102th to 4999th lines are moved down one line at a time, as shown on the right side of FIG. Lines to 5000 lines. That is, the correction target cell is a new cell from the C column to the F column of 102 rows.

  In the second state update process, if even one correction target cell exists in a certain column (column of the inserted row), the arithmetic expression of the entire column is updated. In other words, the arithmetic expression of one or a plurality of cells in which an operation that triggered the occurrence of the Change event is updated.

  When the change event occurs, the redefinition macro divides the correction target cell for each column, and redefines information setting area 25 (in the order of C column, D column, E column, and F column) for each column. In this example, the redefinition information R (for example, a normal function or an arithmetic expression) set in the second row is sequentially overwritten on the correction target cell in the column, and the state of the correction target cell is updated (definition information) Rewrite to S). The redefinition macro updates the status of the next column when the status update of one column is completed.

[When DeActivate event occurs]
When the DeActivate event occurs, the target range of the second state update process (for example, the range of the broken line in FIG. 15A) is divided for each column, and the contents of each cell are determined for the total number of cells one column at a time. This determination compares the contents of each cell with the redefinition information R (for example, a normal function or an arithmetic expression) set in the redefinition information setting area 25 (second row in this example) of the column. By doing. If the contents of each cell and the contents of the redefinition information R match, it moves to the next (lower) cell as it is and sequentially determines, and even the contents of the cell and the redefinition information in one of the columns If there is a cell whose contents of R do not match, the redefinition information R (for example, a normal function or an arithmetic expression) set in the redefinition information setting area 25 (second row in this example) of the column Are sequentially overwritten on the cells in the target range of the second state update process of the column, and the states of all the cells in the target range of the second state update process of the column are updated (rewritten in the definition information S). The redefinition macro updates the status of the next column when the status update of one column is completed.

  In addition, although the example which determines the content about the total number of the cells of the target range of the second state update process has been described here, the following simple determination may be performed.

  In the simple determination, first, the number (N1) of cells in the target range of the second state update process for each column is grasped. For example, in the case of Excel (registered trademark), this number can be grasped by referring to the “Range.cells.count” property.

  Next, the number (N2) of cells whose contents are arithmetic expressions among the cells whose number is known is grasped. For example, in the case of Excel (registered trademark), this can be grasped by referring to the property “Range.SpecialCells (xlCellTypeFormulas) .cells.count”.

  Then, the values of (N1) and (N2) are compared for each column, and if they match, it is determined as normal and the next column is processed. On the other hand, the values of (N1) and (N2) are compared, and if they do not match, it is determined as abnormal, and the state is updated (rewritten to definition information S) for all cells in the target range of the second state update process in the column. ).

  The update processing of the second state update processing means 172 is particularly the case where the number of target sheets and columns is large and the number of data items is large, but the same arithmetic expression is defined for each column (user input This is effective for state update (repair of cell contents).

  In addition, when the contents of the target cell are changed, the second state update process is usually executed only with the Change event as a trigger. However, instead of the occurrence of the Change event or in addition to the occurrence of the Change event, by performing the second state update process triggered by the occurrence of the DeActivate event, the cell state can be updated (restoring the cell contents). This can be done more reliably.

  For example, in the accounting basic macro, there is a case where the occurrence of an event for a specified object is switched as necessary (switching a flag), and a case where there is no occurrence of an event (Excel (registered trademark) ) In the case of “Application.EnableEvents = False”), when the user operates the cell (such as rewriting), the occurrence of the Change event is not determined. In some cases, the switching of the occurrence of an event by the accounting macro does not always succeed.

  In such a case, by performing the second state update process triggered by the occurrence of the DeActivate event, it is possible to reliably update the state of the cell (restoration of the cell contents).

  As described above, the second state update processing unit 172 unintentionally changes the definition information S (for example, a function or an arithmetic expression) set in a predetermined cell by the user by an interactive operation. When overwriting, pasting, cutting, deleting, etc.) are performed, the (predetermined) definition information S defined in the automatically changed cell is overwritten by the redefinition information R and the redefinition macro.

  In the above example, the expense sheet has been described as an example. However, the sales / purchase sheet, the ordinary journal sheet, and the additional sheet also have, for example, n sort column ranges (for example, 2 rows for the sales / purchase sheet). The third column to the sixth column of the eye), and the range of n years (for example, the fourth row to the 252nd row in the sales / purchase sheet) differ according to each other. The state update process can be performed.

<State update processing means / third state update processing means (third state update processing)>
Next, the third state update processing unit 173 will be described with reference to FIG. The third state update processing unit 173 is a unit that performs the third state update process according to the state (value) of the cell after the change when the cell in which the definition information S is defined is changed.

  The sheets subject to the third state update process are mainly sales / purchase sheets (see FIG. 12), and FIGS. (A) to (D) show sales / purchase sheets. Other sheets may be used.

  The third state update processing unit 173 performs, for example, a third state update process for redefining a part or all of the cells in which the definition information S is defined in response to the occurrence of the Change event or the occurrence of the DeActivate event. .

  Also in this case, a predetermined cell range name is attached to a range of a certain cell (for example, a cell in which an arithmetic expression or function is defined as the definition information S) in advance, and the cell range name is When cell input, information pasting, clearing, cutting, etc. have been performed on the attached range of cells (Change event occurs), or when moving from the target sheet to another sheet (DeActivate event has occurred) Then, the state update process is performed for the cell having the cell range name.

  That is, first, as in the case of the second state update process, the target range of the third state update process specified by the column with the cell range name in the column direction and the row with the cell range name in the row direction Among the cells that have been changed by obtaining a cell range that includes one or more cells that have been operated to trigger the Change event, and that are included in the target range of the third state update process Is specified as a correction target cell. In the third state update process, if there is one or more correction target cells, the state is updated. If there is no correction target cell, this process is terminated.

  The redefinition macro divides the correction target cell for each column, determines the cell contents one column at a time, and is set in the redefinition information setting area 25 (for example, the second row) of the column according to the cell contents. The redefinition information R (for example, a normal function or an arithmetic expression) is overwritten sequentially on the correction target cell in the column, and the state of the correction target cell is updated (rewritten to the definition information S). The redefinition macro updates the status of the next column when the status update of one column is completed.

  Here, in the third state update process, the content of the cell operated according to the following criteria (cases 1 to 5) is determined, and when the content is determined to be “abnormal”, the content of the cell is determined. Redefine with redefinition information R.

  [Case 1] When the content of the operated cell is “blank” (when the user presses the space key, etc.) → Judgment is “abnormal”

  [Case 2] When there is no content of the operated cell (such as when the user presses the Delete key, or the cell is cut or inserted) → The judgment is “abnormal”

  [Case 3] When a fixed value (constant) other than a blank is entered in the operated cell (when there is an input by keyboard operation by the user or when a value is pasted) → Judgment "normal"

  [Case 4] When an arithmetic expression is input to the operated cell and the arithmetic expression matches the redefinition information R set in the redefinition information setting area 25 → the determination is “normal”

  [Case 5] When an arithmetic expression is input to the operated cell and the arithmetic expression does not match the redefinition information R set in the redefinition information setting area 25 → Judgment is “abnormal”

  That is, in the third state update process, even when a constant other than a blank is input by the user to the cell in which the definition information S is set, and the definition information S previously defined by the input is lost, the user Allow the constant entered in (handle as normal, do not redefine). On the other hand, with respect to other inputs, the definition information S is redefined by determining that the input is an abnormal value unless the input matches the definition information S defined in advance.

  In addition, when the DeActivate event occurs, as in the case of the second state update processing unit 172, the target range of the third state update process is divided for each column, and the contents of each cell and the relevant number are related to the total number of cells one column at a time. The redefinition information R set in the column redefinition information setting area 25 is compared, and the redefined information R is redefined (overwrites a correct arithmetic expression or the like) in a mismatched cell.

  In this case, the method of acquiring the cell range of all cells that satisfy the specified condition by specifying the type of cell to be acquired (for example, in the case of Excel (registered trademark), a Range object is returned). Properties, methods, functions such as “Range.SpecialCells”, macros, etc.) may be used. By using such a method, the cell range of the cells that satisfy the specified conditions (for example, cells in which constants are input in this case) is returned instead of determining the total number, so that the processing can be speeded up. it can.

  This will be specifically described with reference to FIG. Here, for example, the cells after the 132nd row of the 18th column and the 20th column are correction target cells, and a value based on the definition information S is set in an initial state, and a fixed value input by the user is accepted. That is, although not shown, predetermined redefinition information S is defined in the redefinition information setting area 25 (for example, the second row) of the 18th and 20th columns.

  In the initial state shown in FIG. 6A, the cell values in the 20th column (“Deposit” item) in the 140th row are “23,717” according to the definition information S, and the 18th column is blank. .

  In this case, as shown in FIG. 5B, when the user corrects the cell value in the 140th row and the 20th column to “23, 217” and the cell value in the 18th column to “500”, The input of this value is accepted (allowed) according to the determination criterion “Case 3”.

  On the other hand, as shown in FIG. 5C, when the user deletes the value of the cell in the 140th row and the 20th column (for example, when the Delete key is pressed), the above-mentioned determination criterion “Case 2” indicates “abnormal”. And the redefinition information S set in the redefinition information setting area 25 (here, for example, the second row in the 20th column not shown) is copied to the cell in the 140th row and the 20th column by the redefinition macro. As shown in FIG. 4D, the initial state value is redefined (see display column CN for displaying the cell contents).

  By such a process, for example, from the initial state shown in FIG. 5A, the cell (for example, 18 columns) included in the target range of the third state update process as shown in FIG. When a numerical value (numerical value indicating a monetary amount) is input in the 140th row and 20th column and 140th row (cell), the value is processed as normal, and is deleted or blanked as shown in FIG. Can be corrected to a predetermined arithmetic expression or function as shown in FIG.

  In particular, in an accounting system, the content of a sheet is often easy to understand (clear) by allowing a user to input a numerical value (amount of money, etc.) for a certain item (cell). In such a case, if the user wants to input a fixed value intentionally, or keeps it or wants to maintain the arithmetic expression (return to the original arithmetic expression), by accepting the input numerical value as normal The operation such as redefining a predetermined arithmetic expression becomes possible, and the convenience of the user can be greatly improved.

  The second state update process and the third state update process are similar processes, but differ in the following points.

  First, in the second state update process, the redefinition information R is copied to all cells to be redefined. On the other hand, in the third state update process, when a fixed value (constant) is input by the user, the redefinition information R is not copied.

  In the case of the accounting system 10, the second state update process is a cost sheet, a sales / purchase sheet, a regular journal sheet, and an additional sheet that are suitable for processing. A target range (a target range specified by a cell range name in the row direction and a cell range name in the column direction) is set. On the other hand, sheets suitable for the third state update process are mainly sales / purchase sheets. For example, even for the same sales / purchase sheet, the target range of the second state update process is different from the target range of the third state update process.

  Further, when compared with the number of cells in the target range of the second state update process and the target range of the third state update process, the target range of the second state update process is significantly larger.

  Further, in the second state update process, when redefinition is performed (in the case of total number process), the total number is redefined (overwritten) in units of columns, but in the third state update process, input of a fixed value is permitted. Therefore, cells are individually determined in units of columns and selectively redefined (overwritten).

  It should be noted that arithmetic columns are also included in columns that are not input by the user (for example, sort key columns), but such columns are used for management purposes as sort keys and the like. In addition to the amount of money, user input includes text information such as account code, account item, customer name, description, date / time, other codes, flags, etc. It becomes a target of the state update process (process for repairing the cell definition information S) of the embodiment.

<State update processing means / fourth state update processing means (fourth state update processing)>
Next, the fourth state update processing unit 174 will be described with reference to FIGS. The fourth state update processing unit 174 is a unit that performs a fourth state update process when a sheet is operated in a process over a plurality of sheets.

  The accounting basic processing program 21 includes processing over a plurality of sheets. For example, the processing over a plurality of sheets refers to the definition information S defined in the cells in one sheet from the definition information S defined in the cells in one sheet, or the same area in the plurality of sheets. For example, the cell definition information S existing at (address) is calculated by skew. In the basic function of the spreadsheet software 16, when performing processing for a plurality of sheets, if the sheet is added or replaced, the sheet may not be referred to. It may be missing. The fourth state update processing unit 174, when performing processing for a plurality of sheets in the accounting basic processing program 21, performs an operation for adding or replacing a sheet (especially a reference target). The state of the operable target is updated while partially using the first state update processing by the first state update processing unit 171 so that all the sheets to be referred to can be referred to.

  First, in order to refer to an additional / replacement sheet, the sheet specified by specifying the sheet name is specified to be a reference target, the name of the sheet is obtained, and the sheet name (on the reference side) is acquired. It is necessary to save it in a format that can be referred to from the arithmetic expressions defined on the sheet (the arithmetic expressions already described in the accounting basic macro and the redefinition macro). The fourth state update processing means 174 is configured to automatically perform these processes continuously.

  There are two methods for describing and referencing cells on a sheet from an arithmetic expression: a method for describing a sheet name or address as a “character string” and a method for describing a sheet name or address as a “character string expression”. .

  The former is a method in which the sheet name or address of the cell to be referred to is referred to directly in the arithmetic expression when describing the sheet name or address of the cell to be referred to, and the sheet name or address reference must be described as a “character string”. For this reason, when it is desired to change the sheet to be referenced to another sheet, it is necessary to manually rewrite the arithmetic expression in the sheet to be referenced. Therefore, a great deal of labor is required when it is necessary to add or replace sheets. It is also possible to automate the work using a macro, but the macro becomes complicated and its practicality is low.

  On the other hand, the latter uses a function for indirectly specifying a cell to be referred to in the arithmetic expression. For example, in the case of Excel (registered trademark), an Indirect function is described, and a sheet name and an address are described as function arguments. In this case, the sheet name or address can be a character string expression including a cell reference or a function. For example, if you define an arithmetic expression such as "= Indirect (A1 &"! C3 ") and write the sheet name of the sheet referenced in the" A1 "cell, the" C3 "cell of any sheet Can refer to the value. In this case, the part of “A1 &“! C3 ”” is a character string expression, and if you set a macro to write the sheet name on the side referenced in the “A1” cell, The sheet on the side that is dynamically referenced can be changed.

  The sheet name of the sheet to be referred to may be a simple designation method such as selecting from the options displayed on the screen using the GUI, in addition to the method of inputting characters in the cells. For example, a tool such as a drop-down list may be used as a function for displaying the options of the spreadsheet software 16.

  In addition, a GUI screen may be defined by an own code, and a function may be provided that can manage the replacement or return of the referenced sheet at once. In that case, although illustration is omitted, for example, when the user double-clicks the “A1” cell in the sheet on the reference side (either the profit and loss calculation sheet or the daily balance sheet), the GUI screen appears. Two drop-down lists are defined in the GUI screen, and the versions to be referred to (for example, the latest version) of the two sheets of expense, sales and purchase (these are mainly the targets of the replacement function), respectively. ) Is selected. When the user clicks on a drop-down list (for example, “expense”), the sheet name of the sheet having the book level range name “g expense” comes first, and the sheet name of the sheet having the sheet level range name “g expense” It is then displayed in a list. When the user selects a sheet name of a version to be referred to, a macro activated from the GUI screen copies the sheet name of the selected sheet to the reference sheet name column 30 of both the profit and loss calculation sheet and the daily balance sheet. .

  According to this method, even when the sheet name is changed by the user, when a new sheet is added, or when it is desired to refer to a transplanted sheet from another file or the like, it becomes possible as a series of procedures. .

  Therefore, in this embodiment, as a method for referring to and specifying a sheet specified by specifying a sheet name, a method in which the sheet name is described as a “character string expression” and the referenced sheet is dynamically specified by a redefinition macro. It was adopted.

  Next, a method for specifying a sheet will be described. As a basic function of the spreadsheet software 16, for example, a method for specifying a sheet is, for example, a method for specifying a sheet name to be referred to, a method for specifying the position of a sheet tab of a sheet to be referenced from the left, CodeName There are a method of designating by a method, a method of designating by providing a specific object (mark) in the sheet, and the like.

  In the present embodiment, in order to dynamically specify a sheet name within a macro, a method of specifying a specific object (mark) in the sheet is adopted. According to this method, when a sheet is added or replaced, the added / replaced sheet can be referred to without any special operation, and the same sheet can be used even when the user changes the sheet name. You can continue to see.

  As a method of providing a specific object in a sheet, a method using a cell range name or a comment, a method of defining a specific character in a specific cell (for example, “A1” cell), or a format of a specific cell And a specific shape (for example, ruled line color designation). In the present embodiment, the cell range name is adopted as the object because the influence of the user's careless operation is hard to be affected and the definition of the macro is relatively simple.

  That is, the fourth state update processing unit 174 performs identification of the referenced sheet and acquisition of the sheet name by the following method.

  In order to specify the sheet on the reference side, a cell range name is set for one or a plurality of cells of the sheet, and this is used. For example, when referring to another sheet from one sheet, if the referenced sheet is replaced, the specified cell range is specified in the referenced sheet. Set the name. When a sheet is replaced with a new one, the name is generally changed by copying the sheet. That is, in this case, there are a plurality of expense sheets with different names. In this embodiment, the cell range name at the book level is used in order to specify one target from the new and old expense sheets.

  Specifically, for example, when an expense sheet is used as a sheet to be referred to, a cell range name of “g expense” is set in one or a plurality of cells in the expense sheet. Then, the expense sheet in which the cell range name “g expense” is set is referred to as the latest expense sheet. Since sheet replacement specifies one sheet, in this case, a cell range name at the book level is used.

    Further, for example, in the case of skewering calculation (aggregation), a cell range name named “n expense” is set in one or a plurality of cells in the target sheet, and skewering calculation (aggregation) is performed using the cell range name. Specify the target sheet. Since the skew calculation is performed on a plurality of sheets, the cell range name at the sheet level is used in this case. This range name can be regarded as an object belonging to the sheet, and is copied simultaneously with the sheet when the sheet is copied. Utilizing this property, it is used together with the book level range name as a mark for identifying the sheet.

  Here, “cell range name” will be described. As described above, the “cell range name” is a name (character string) set for quick cell reference, and can be associated with one or more ranges of cells. By associating a cell range name with a cell and referring to the cell not by an address but by a cell range name, it is not necessary to modify a macro or an arithmetic expression even if a column or row is added or deleted.

In addition, the “cell range name” of Excel (registered trademark) has the following types depending on the difference in the range of the referenceable range (variable application range, scope, effective range).
Macros and those that can be referred to from arithmetic expressions in all sheets in the book (file) (this is referred to as “book level range name” in the following description).

The “book level range name” can be used to refer to a cell across sheets only by specifying a sheet name. Therefore, in this embodiment, in addition to specifying a cell, the “book level range name” is also applied to specifying a sheet.
A macro and an arithmetic expression in a single sheet (only when the reference sheet and the reference sheet are the same) can be referred to (this will be referred to as “sheet level range name” in the following description).

  The “sheet level range name” can be referred to from all the arithmetic expressions in the sheet having the cell associated with the range name. In other words, it should basically be used for calculations within a sheet, but if a sheet name is specified and this is specified, cells can be referenced across sheets. In the present embodiment, this is used in order to easily specify cells in the sheet.

  In addition to the above-mentioned “book level range name” and “sheet level range name”, there are macros and expressions that can be referenced from a single sheet arithmetic expression (reference source and reference destination are different). Since this is not used in the present embodiment, the description is omitted.

  Note that the “sheet level” in the present embodiment can also be regarded as, for example, “module level”, “local level”, “local level”, and the “book level” is, for example, “public level”, “global level”. It can also be regarded as “global level”.

  In this embodiment, “range name definition” is described, but this can also be referred to as “named cell range definition”.

  Specifically, as a function of Excel (registered trademark), when a cell range name is defined using an interactive UI (window display) in a state where a sheet is displayed, a “Thisworkbook.Names” object (directly under the “Thisworkbook object”) A list of cell range names is stored in the “Names object.” In order to define cell range names, a GUI screen such as a name box NB is provided in Excel (registered trademark). To perform a series of deletion and deletion, it is recommended to create a dedicated screen (own code).

  In that case, although illustration is omitted, when the user double-clicks the “A1” cell of the sheet on the reference side (either the profit and loss calculation sheet or the daily balance sheet), the GUI screen appears. The GUI screen displays a list of range names currently defined in the file (a combination of the sheet name and range name of the sheet to which the reference cell belongs) and “book level / sheet level” as a list. Has been. When there are many range names, a vertical scroll bar also appears. When the user selects a range name and changes the check box next to the range name from OFF to ON, the macro activated from the GUI screen changes the range name to the book level. When there is a range name with the same name, all the range names with the same name that are not selected are changed to the sheet level. When the user selects a range name and changes the check box next to the range name from ON to OFF, the macro activated from the GUI screen changes the range name to the sheet level.

  When the book level range name is defined, only the book level range name is set as the value of the Name property of the Names object, but this does not include the sheet name. The cell of the reference destination is linked to the RefersTo property in the object by describing it in the form of “sheet name + address”.

  On the other hand, when the sheet level range name is defined, the sheet name is included as the value of the Name property of the Names object. The reference cell is linked to the RefersTo property in the object by describing it in the form of “sheet name + address”.

  Then, only one book level range name can be set for one book, and the cell range name can be specified by the cell range name even in another sheet. On the other hand, the sheet level range name is a valid cell range name only for the sheet (one with the same name can be defined in the sheet), and the same number as the number of sheets can be defined in the book. The same cell range name can be set for different sheets. The book level range name and the sheet level range name with the same name cannot be defined simultaneously in the same sheet.

  In this way, in the fourth state update process, the sheet can be specified, and the sheet specified by the basic function of the spreadsheet software 16 is acquired.

  Next, for the method of saving the specified sheet name in a form that can be referenced from the arithmetic expression (the method of giving the sheet name as an argument to the Indirect function described earlier), the method of writing the sheet name as a value to the cell is adopted. To do. Also, in this embodiment, when saving the specified sheet name, a method of saving in the cell of the sheet on the side to which reference is made (data is stored) and a special sheet for saving the sheet name are defined. Adopt the method to do. These are selected depending on the operation content of the sheet. That is, in an environment in which one sheet is referred to another sheet, when the referred side sheet is replaced (for example, old and new) (for this reason, there are a plurality of referred side sheets), The method for saving the sheet name as a cell value in the referenced sheet is selected, and in the case of multi-sheet skewing calculation processing, the method for defining a special sheet for saving the sheet name is selected. Is done.

  Note that the method for saving sheet names is not limited to this, for example, a method for saving as a cell value in a sheet on the side of reference (utilizing data), or a method for writing to a list of cell range names (Names object) A method using a mechanism (function, property, user-defined function, macro, etc.) that returns a sheet name to which the cell belongs when a cell range is given may be used.

  As described above, in the fourth state update process, the sheet to be referred to is specified using the cell range name, and the sheet name of the specified sheet is stored in a form that can be referred to from the arithmetic expression.

  Next, a method for specifying a sheet to be referred to and a method for specifying a sheet in an arithmetic expression will be specifically described. The fourth state update process includes a sheet configuration (setting) described below, and at least when a sheet replacement operation is performed according to the configuration, and when a plurality of sheets are skewed, the operation is performed from within the macro. A sheet can be specified and the referenced sheet can be updated. Hereinafter, these two cases will be described.

[1. Specifying a sheet when there is a sheet replacement operation]
The sheet replacement operation means that, for example, there is a replacement of the old and new sheets referenced from one sheet, and for this reason, there are multiple similar sheets in the file (workbook) (a mixture of new and old versions). Operation.

  Here, a method of uniquely specifying an intended sheet from an arithmetic expression on a sheet on the reference side and acquiring a cell value of the sheet will be described. The spreadsheet software 16 has a method of uniquely specifying a sheet, but it is not easy to replace the old and new with this method. According to this method, it is necessary to rewrite all arithmetic expressions on the sheet on the reference side. This method is a means for easily replacing the old and new, and is a means for uniquely specifying the sheet, but this means causes a problem when the user changes the sheet name. The automatic correction function of the spreadsheet software 16 is a mechanism that keeps a referenced sheet unique even when the user changes the name of the sheet that is referred to via the GUI (hereinafter referred to as a “sheet reference maintenance function”). ) However, if the process in the state update process in the present embodiment is assumed, the sheet reference maintenance function incorporated in the spreadsheet software 16 falls outside the target range.

  For this reason, the fourth state update processing unit 174 realizes a function for easily replacing the old and new, and a sheet reference maintaining function corresponding to the function.

  Referring to FIG. 18, the sheet configuration used in the fourth state update unit 174, that is, the sheet on the side of reference (utilizing data) (for example, “profit / loss calculation sheet”), other sheets (referenced sheets, For example, an example of a configuration for referring to data of “expense sheet” will be described. In the figure, a profit and loss calculation sheet (FIG. (A)) is shown as a reference side sheet, and an expense sheet (FIGS. (B) and (C)) is shown as a reference side sheet.

  Referring to FIG. 5B, the following settings are made on the referenced sheet (for example, “expense sheet”). First, a “book level range name” is defined in an arbitrary cell in the referenced sheet (for example, “expense sheet”). This is registered as a book level range name by selecting an arbitrary cell (eg, “C2” cell) and entering a name (eg, “g expense”) in the name box NB.

  The book level range name can be used as a means for specifying the target sheet from the sheets in the workbook. As a means for specifying the target sheet, generally, a method of specifying the sheet by the sheet name is frequently used, but the target sheet can be specified more flexibly than that.

  Also, a macro is defined that acquires the sheet name of the referenced sheet (its own sheet name) and overwrites the sheet name in the sheet name cell (cell “C2” linked to the book level range name). To do. The macro is included in the redefinition macro and is executed when moving from the referenced sheet to another sheet.

  In other words, the “C2” cell associated with the book level range name “g expense” is a cell (sheet name cell) in which the sheet name of the sheet to which the cell belongs is defined.

  For example, in FIG. 5B, the content of the “C2” cell is a character string (character string of the sheet tab) “expense” which is the sheet name of the “expense sheet” to which the cell belongs. Then, as shown in FIG. 5C, the user changes the sheet name of this “expense sheet” from “expense” to “expense 2908” (name change of sheet, not copying), and moves other sheets. Then, when returning to the expense sheet again, the contents of the “C2” cell are updated by a redefinition macro that overwrites the sheet name in the “C2” cell. The redefinition macro for overwriting the sheet name will be described in detail later.

  In other words, the redefinition macro monitors the DeActivate event, and triggered by the occurrence of the DeActivate event, the sheet name of the reference side sheet (for example, “expense sheet”) (its own sheet name, “expense 2908 after change”) ]) And the obtained sheet name is overwritten on the cell of the sheet name ("C2" cell linked to the book level range name). As a result, the sheet name after the change (for example, “expense 2908”) is overwritten in the “C2” cell of the expense 2908 sheet ((C) in the figure). In this case, the “C2” cell is hidden by, for example, the entire second row so that the user does not inadvertently update it.

  As shown in FIGS. 2B and 2C, the range name associated with the “C2” cell is a book level range name “g expense” unique in the workbook. For a sheet with a book level range name, only the contents (values) of the “C2” cell associated with “g expense” are changed when the sheet name is changed. That is, here, the character string “expense” is changed to “expense 2908”.

  On the other hand, in the reference of data in the sheet on the reference side (for example, “Profit / Loss Calculation Sheet”), as shown in FIG. 5A, the reference that defines (inputs and displays) the sheet name of the reference side sheet A destination sheet name column 30 is provided. The data to be referred to is specified by using a function for indirectly specifying the cell to be referred to in the reference destination sheet.

  For example, as shown in FIG. 3A, an arbitrary cell (for example, “K5” cell) of a reference side (utilizing data) sheet is referred to as a reference destination for defining a sheet name on the reference side. The sheet name column 30 is used.

  The reference destination sheet name column 30 defines (describes) “= g expense” using the book level range name of the referenced sheet (for example, “expense sheet”). As a result, the sheet with “g expense” added as the book level range name, that is, in this example, the sheet name of the referenced sheet can be acquired. The reference destination sheet name field 30 also accepts input by the user.

  The sheet on the reference side is configured to refer to the sheet name defined in the reference destination sheet name field 30, and the user inputs an arbitrary sheet name in the reference destination sheet name field 30, It is also possible to change the reference destination of the sheet on the reference side.

  Further, the value (definition information S) in the reference destination sheet name field 30 is obtained by the third state updating unit 173 that accepts the input of a fixed value by the user, or by providing the fourth state updating unit 174 with the same update. The redefinition information R can be redefined.

  That is, the redefinition information setting area 25 is provided on the sheet on the reference side. The redefinition information setting area 25 is, for example, the second row (for example, “K2” cell) in the same row as the reference destination sheet name column 30 and the book of the sheet (for example, “expense sheet”) referred to as the redefinition information R. Define an expression that uses the level range name (for example, “= g expense”).

  Also, as a redefinition macro, a command for copying redefinition information defined in the redefinition information setting area 25 in the same row to the reference destination sheet name column 30 is defined and executed. Thus, the arithmetic expression stored as the redefinition information R is redefined in the reference destination sheet name column 30 at a predetermined timing.

Further, when referring to the data on the referenced sheet on the referencing sheet, a function for indirectly specifying the cell to be referred to is used. For example, in the case of Excel (registered trademark), the cell address of the reference destination can be described as a character string or a character string expression by “InDirect function”. Thereby, in order to define a reference from one sheet to another sheet, a cell reference or a function can be included in the definition of the reference destination address.
As an example of addressing by a character string, there is an arithmetic expression that refers to the “F12” cell of the expense sheet by “= InDirect (“ expense! F12 ”)”. As an example of a character string expression, there is an arithmetic expression such as “= InDirect (InDirect (“ g expense ”) &“! F12 ”)” using a book level range name defined in the expense sheet. This is an example of using the InDirect function as an argument to the InDirect function and nesting the function. The two examples result in the same value.

  In addition, the sheet name of the referenced sheet can be defined in the cell. That is, in this example, “= InDirect (K5 &“! F12 ”)” is used in an arbitrary cell (for example, “N12” cell) on the reference side using the reference destination sheet name column 30 (“K5” cell). In the “N12” cell of the profit and loss calculation sheet, the “F12” cell of the sheet (expense sheet) having the sheet name defined in the reference sheet name column 30 (“K5” cell) of the profit and loss calculation sheet Can be referred to. In this example, the “K5” part is a cell reference.

  The fourth state update unit 174 performs a fourth state update process as necessary when an operation is performed between a plurality of sheets using the sheet set in this way. This will be further described below.

[1-1. For temporary replacement of sheets]
19 and 20 are diagrams illustrating an example of the fourth state update process in the case where the sheet on the reference side is temporarily replaced and reflected on the sheet on the reference side. This is an example in which an expense sheet is used as a sheet and a profit and loss calculation sheet is used as a sheet on the reference side.

  Referring to FIG. 19A, for example, the “K5” cell of the profit and loss calculation sheet is the reference destination sheet name column 30, and the content is an arithmetic expression using the book level range name of the expense sheet (for example, “= g Expense ") is defined. Similarly to the case of FIG. 18, the reference destination sheet name column 30 is configured to be input by the user and can be redefined by the redefinition information R. In other words, the redefinition information R (in this example, an arithmetic expression (for example, “K”) is stored in the redefinition information setting area 25 provided in, for example, the second row (“K2” cell) in the same row as the reference destination sheet name field 30. = G expense ")) is overwritten in the" K5 "cell by a certain operation of the user (such as value deletion).

  Here, a case where there are a plurality of referenced sheets (expense sheets) will be described as an example. In this example, as shown in FIGS. 6B and 6C, as a result of the user copying the expense sheet, the sheet whose name is “expense 111” and the sheet whose name is “expense 222” are shown. Is present. Then, for the sheet whose sheet name is “expense 222”, the value of the deposit in November 2017 (the column indicated by the broken line) is changed.

  Here, as a basic function of Excel (registered trademark), when a sheet having a cell range name is copied, the cell range name is also copied, but when the cell range name is a book level range name, the copy destination Now replaces the sheet level range name. That is, even if the cell range name is the book level range name in the copy source sheet (expense 111 sheet), the cell range name is the sheet level range name in the copy destination sheet (expense 222 sheet). This is due to the specification of Excel (registered trademark) that only one book level range name of the same name can be defined in one file (workbook).

  That is, in this example, as a result of copying the expense sheet by the user, the sheet with the sheet name “expense 111” with “g expense” added as the book level range name to the “C2” cell, and the sheet level range name “ There is a sheet having the name “expense 222” with “g expense” attached.

  As described above, the “K5” cell (reference sheet name column 30) of the profit and loss calculation sheet defines an arithmetic expression (for example, “= g expense”) using the book level range name of the expense sheet. As a result, the sheet with “g expense” attached as the book level range name is referred to. That is, by defining “= g expense” in the reference destination sheet name column 30, a sheet with “g expense” added as the book level range name is referred to.

  Therefore, in this case, as shown in FIG. 5A, the profit and loss calculation sheet refers to the sheet of “expense 111” with “g expense” as the book level range name.

  In this state, in the profit and loss calculation sheet, the sheet with the sheet name “expense 111” (the sheet with the book level range name “g expense”) is not the sheet with the expense name “expense 111” (the sheet is newly generated by copying the sheet) The state update process in the case of referring to the sheet (the sheet on the reference side is temporarily replaced) will be described.

  In order to temporarily refer to a sheet other than the sheet having the book level range name “g expense”, as shown in FIG. 20A, the user can refer to the reference sheet name column 30 (“K5”) of the profit and loss calculation sheet. In cell, a fixed value “expense 222” is entered. As a result, the reference sheet is changed to a sheet having the sheet name “expense 222” and, for example, a function (for example, “= InDirect”) defined in an arbitrary cell (for example, “M8” cell) of the profit and loss calculation sheet. ($ K $ 5 & “! $ M $ 5”) ”), the value of the sheet cell of the sheet name“ expense 222 ”(in the above example, the value of the“ M5 ”cell) can be referred to.

  Further, when the sheet on the reference side is returned from the sheet with the sheet name “expense 222” to the sheet with the sheet name “expense 111”, the value in the reference destination sheet name column 30 is changed as shown in FIG. Clear (for example, press the Delete Key).

  As a result, as shown in FIG. 5C, the third state update unit 173 causes the cell in the reference destination sheet name column 30 to be an arithmetic expression (for example, “= g expense” of the redefinition information R in the redefinition information setting area 25. )). The value of this arithmetic expression (the value of the cell linked to the book level range name “g expense” (the value of the C2 cell of the “expense 111” sheet)) is “expense 111”. The value of the cell is “expense 111”. As a result, the sheet referred to returns to the sheet whose sheet name is “expense 111”.

[1-2. For permanent replacement of seats]
Next, a description will be given of a fourth state update process in the case where the referenced sheet is permanently replaced and reflected on the referenced sheet.

  For example, the case of FIGS. 19 and 20 (in the case where “expense 111” sheet (sheet having the book level range name “g expense”) is copied to create “expense 222”) will be described as an example. In this example, when the referenced sheet is permanently replaced, the range name given to the referenced sheet is changed from the sheet level to the book level.

  As a basic function of the spreadsheet software 16, the book level range name cannot be changed to the sheet level range name, or vice versa. Therefore, when changing the level of the cell range name, it is necessary to delete the cell range name once and give it again.

  Specifically, the book level range name “g expense” defined in the sheet (copy source) with the sheet name “expense 111” of the copy source is deleted, and an arbitrary on the sheet with the sheet name “expense 222” The book level range name “g expense” is newly defined in the cell (for example, “C2” cell).

  When the sheet being referred to (the sheet having the sheet name “expense 222”) is moved to another sheet, a “DeActivate event” is generated in the referenced sheet. With this as a trigger, the sheet name (“expense 222”) is assigned to the cell associated with the book level range name “g expense” (for example, the “C2” cell of the sheet with the sheet name “expense 222”) by the redefinition macro. ) Is overwritten. Thereafter, the sheet on the side to be referred to is the sheet with the sheet name “expense 222”.

[1-3. Processing to maintain consistency between sheet name and sheet name saved in a referenceable form]
The sheet name is a character string uniquely specified for each sheet, and is displayed in the “sheet tab” area in the spreadsheet software 16. This character string can be changed by the user through an operation via the GUI.

  Since the calculation formula of the spreadsheet software 16 cannot refer to the character string of “sheet tab” (hereinafter referred to as “actual sheet name”), in the present embodiment, another place (for example, the book level range name “ Save the same character string as the sheet tab (by defining a redefinition macro in that way) in the “C2” cell associated with “g expense” (hereinafter referred to as “referenceable sheet name”). Refer to.

  By the way, if the user changes the actual sheet name, a mismatch occurs between the actual sheet name and the referable sheet name. Due to this mismatch, the target sheet cannot be identified from the reference side sheet, and the target cell cannot be referred to.

  Specifically, a case where the user changes a sheet named “expense 111” to a name “expense AAA” by a GUI operation will be described as an example. In this case, inconvenience occurs in the arithmetic expression defined in the sheet (for example, profit / loss sheet) that referred to the sheet named “expense 111”.

  This is because the sheet name displayed on the sheet tab is updated to “expense AAA” by, for example, a determination process (for example, pressing the Enter key) after the user inputs to the sheet tab, but the book level range name “g” This is because the value of the cell (“C2” cell) linked to “expense” remains “expense 111” and is not updated only by the determination process.

  In this state, the calculation formula in the profit and loss sheet tries to refer to the sheet “expense 111” by regarding “expense 111”, which is the value of the cell linked to “g expense”, as the sheet name. . However, the sheet that was named “Expense 111” has been renamed to “Expense AAA”.

  In such a case, the arithmetic expression in the profit / loss sheet misunderstands that the reference destination sheet has disappeared, and an error of “reference destination indefinite” occurs. However, since the profit / loss sheet is in a non-active state at this point, this inconvenience is not visible to the user. This defect is visible for the first time when the user sets the profit / loss sheet to Active (that is, displayed on the screen).

  Therefore, the fourth state update processing unit 174 performs state update processing for repairing the reference destination sheet name.

  Whenever the user changes the name of the referenced sheet by an operation via the GUI, the referenced sheet (for example, expense sheet) is always active, and the referenced sheet (generally the profit / loss sheet) Sheet for the purpose of aggregation) is non-active. On the contrary, when the user performs an operation of making the reference sheet active, the referenced sheet becomes non-active before the reference sheet becomes active.

  The fourth state update processing unit 174 resolves the mismatch between the sheet name and the sheet name stored in a referable form at the timing when the sheet to be changed becomes non-active. Specifically, the redefinition macro is activated at the timing when the sheet to be changed becomes non-active, and overwrites the sheet name saved in a referable form. This redefinition macro includes at least an instruction “copy the sheet name displayed in the sheet tab to a cell associated with the book level range name“ g expense ”” and has been described with reference to FIG. “Redefine macro to overwrite sheet name”.

  Specifically, when the user changes the sheet named “expense” to the name “expense AAA” by the GUI operation, and then moves to another sheet, the fourth state update processing unit 174 A four-state update process is executed. Then, the redefinition macro for overwriting the sheet name described above links the sheet name “expense AAA” (“expense 2908” in FIG. 18C) displayed on the sheet tab with the book level range name “g expense”. Copy to the attached cell ("C2" cell).

  As a result, the calculation formula in the profit and loss sheet refers to the sheet named “Expense AAA” instead of the sheet named “Expense” (see FIG. 18 and FIG. 18, this sheet name is overwritten). The sheet named “Expense 2908” is referred to by the redefining macro.) Therefore, when the user places the profit / loss sheet in an active state (that is, displayed on the screen), the correction of the defect is completed, and the defect is not touched by the user.

  The above is the mechanism for keeping the referenced sheet unique even when the user changes the name of the sheet to be referred to via the GUI, together with the means for easily performing the new / old replacement.

[2. [Specify sheet for skewer calculation of multiple sheets]
Next, with reference to FIG. 21 to FIG. 26, an example in which the fourth state update unit 174 dynamically designates a sheet from within a macro and updates a sheet to be referred to in the case of skewing calculation of a plurality of sheets. explain.

  First, FIG. 21 is a diagram illustrating an outline of skewering calculation according to the present embodiment. The skewering calculation of this embodiment has a list sheet, a total data sheet, and an original data sheet as shown in FIG. The skewering calculation is executed in a data unit (skewing calculation data unit) including a combination of one list sheet, one total data sheet, and a plurality (up to 99) of original data sheets.

  The list sheet is a sheet that lists the sheet names of the original data sheet. A column for enumerating sheet names is specified as a certain column.

  The total data sheet is a sheet that acquires the sheet name of the original data sheet from the list sheet and lists the values of common items of the original data sheet. In this sheet, a sheet name acquired from the list sheet and common item data acquired from the original data sheet are defined by an arithmetic expression.

  Each original data sheet defines a sheet level range name in an arbitrary cell range in the sheet. In addition, the layout of common item data to be copied to the aggregate data sheet is also defined. A part of the original data sheet is displayed in a form format, for example, and becomes a screen for accepting input from the user, but the common items are normally hidden from the user. In the common items, data is aggregated (edited) by the accounting basic processing program 21 from various other input fields (lower right). Various input fields can be customized by the user. At that time, common items can be edited.

  A plurality of skewer calculation data units (a data unit including a combination of one list sheet, one total data sheet, and plural (up to 99) original data sheets) can be defined in the accounting system 10. . Within a skew calculation data unit, the common item must be a cell range of the same layout. In this case, common items may be composed of the same items or different items among a plurality of skewering calculation data units (for example, unit A, unit B).

  FIG. 5B is a diagram showing an outline of the relationship between the aggregate data sheet and the output form (form such as profit and loss calculation and balance). The accounting processing system 10 of the present embodiment has an expense sheet, a sales / purchase sheet, an ordinary journal sheet, and an additional sheet as sheets into which data is input. Apart from these, one set of skewering calculation data units is defined independently. A plurality of skewering calculation data units can be defined in the accounting processing system 10. In this case, common items may be composed of the same items or different items among a plurality of skewering calculation data units (for example, unit A, unit B). For example, in the profit and loss calculation sheet and the daily balance sheet, data is collected in units of the skew calculation data, and the profit and loss calculation and the daily balance calculation are performed.

The redefinition macro for updating the state in the case of skewering calculation is defined to be activated when a sheet is moved in the book (DeActivate event occurs). The contents of this redefinition macro are as follows.
(1) Step 1 for determining whether the sheet is a target sheet

Search for whether the target sheet level range name is defined in the source sheet (hereinafter referred to as TagetSheet), and if there is no target sheet level range name (for example, if a blank sheet is simply added) Etc.) ends the processing.
(2) Step 2 for determining whether the sheet is a target sheet

Search whether the sheet name of TagetSheet is already enumerated in the list sheet. If it is enumerated, it is determined that it is not a newly added original data sheet (existing original data sheet), and the process is performed. finish.
(3) All sheets in the file are read sequentially, and a sheet name list of sheets in which the target sheet level range name is defined is created. If the original data sheet is created (copied or the like) for the purpose of making it a target sheet for skewering calculation processing, a sheet level range name is set, and a list is created based on this.
(4) The list of (3) (list of sheet names of the original data sheet) is pasted to a predetermined column of the list sheet (update the list sheet).

  Also, before pasting, the value of the cells in the FLG column (column C) is cleared (all contents set by the user last time are deleted). The value of this column is set on a “selection of sheet to be referred to” (GUI screen by own code), which will be described later, and is referred to from an arithmetic expression in the total data sheet.

Note that, in the determination of (2) above, it is determined that the sheet name of TagetSheet is not already listed in the list sheet, and the state of proceeding to (3) includes the following modes.
・ In the case of “existing sheet, there is a target“ sheet level range name ”in the sheet, but there is no name in the list sheet”, and it is described in the list sheet when the user changes the sheet name This is a case where there is a discrepancy between the registered sheet name and the actual sheet name.
-“In the case of an existing sheet, there is a target“ sheet level range name ”in the sheet, but there is no name in the list sheet”. When the user copies the sheet, the sheet is added to the list sheet. The name should be added, but not yet added to the list.
This is a case where the user has given a target sheet level range name to a new sheet, and the sheet name should be added to the list sheet, but has not yet been added to the list.

  The skewering calculation according to the present embodiment is executed by the accounting basic processing program 21, but the fourth state updating unit 174 according to the present embodiment uses the configuration (setting) of each sheet shown in FIG. 21 and the skewering calculation described above. The redefinition macro for updating the status of the sheet allows the processing target of skewering calculation to be referred to (all scheduled sheets can be referred to) when the sheet is operated (added, deleted, renamed) by the user. Update its state).

  A specific example will be described with reference to FIGS.

  FIG. 22 is a diagram illustrating an example of the original data sheet. FIG. 4A is an example of an original data sheet displayed as a user input screen, and FIG. 4B is an entire configuration of the original data sheet including a portion that is not displayed in FIG. It is an example.

  The figure is an example of a deposit slip. On the input screen, it is usually displayed as shown in Fig. 2A (for example, 2nd to 44th rows, Bth to Jth columns are not displayed). For example, the user double-clicks cell A1 as necessary. Then, the whole is displayed as shown in FIG. A broken line region in FIG. 5B is displayed in FIG.

  In the example of FIG. 9A, the range of arrows (for example, 15 rows in the row direction) is data that is tabulated as common items. The number of lines is not limited to 15 and can be changed as appropriate.

  Here, the layout of the deposit slip is shown. However, the layout is not limited to this. For example, a layout such as a transfer slip or a receipt may be used, or a layout other than a form originally used for accounting processing such as a daily report may be used. .

  As shown in FIG. 7B, the data of the common items displayed in FIG. 6A are collected in the normally non-displayed upper left area (referred to as an aggregation area 33) in the same sheet. A sheet level range name (for example, “n additional sht”) is defined in the aggregation area 33. There are up to 99 original data sheets for each skew calculation data unit.

  When the sheet level range name (for example, “n added sht”) is defined, the redefinition macro is a target of aggregation (the above (1) and (2)).

  FIG. 23 is an example of a list sheet. For example, in the C column, a sheet name list of sheets having a sheet level range name of “n added sht” (that is, “original data sheet”) is created. Up to 99 sheet names can be registered, for example, and a cell range name (for example, “g-added SHT name”) is defined in column C (99 cell ranges). The cell range “g added SHT name” is referred to from the total data sheet (sheet name is “added sheet”). In addition, a cell range name “g addition sht” is defined as a book level range name in an arbitrary cell (for example, “B2” cell) of the list sheet.

  FIG. 24 is a diagram illustrating an example of a total data sheet. In this example, column A refers to the cell range (namely, column C of the sheet in FIG. 23) linked to the book level range name “g added sht name” (see display column CN), and The sheet name (character string) included in the list is repeatedly described 15 lines at a time. The number of repeated rows is specified in the “A3” cell of this sheet.

  The calculation formula for column A is “= IFERROR (OFFSET (gAdditional SHT name, INT ((CELL (" row ", A9) -4) / n number of rows), 0,1,1 ), “**”) ”, and the cell range“ g added SHT name ”refers to the cell range belonging to the list sheet (sheet name is“ added sht ”). “Number of n rows” is a range name given to the “A3” cell (the cell value is 15 and the number of repeated rows is specified by the value of this cell) of the total data sheet. The value of "INT ((CELL (" row ", A9) -4)" in the arithmetic expression is 1, and the entire arithmetic expression refers to the value in the first row of the cell range. Is an example when it is described in the “A9” cell.

  The fourth state update processing unit 174 performs sheet operations (addition, deletion, name change) by the various sheets configured as described above and the redefinition macro for updating the state in the case of the above-described skewering calculation. In the case of a cut, the processing target of skewering calculation is updated (so that all the scheduled sheets can be referred to).

  The fourth state update processing means 174 provides a means for referring to the sheet on the side to be referred from the sheet to be referred to. That is, it is possible to select a sheet on the side to be referred to in the sheet to be referred to, and it is also possible to set only the selected sheet as a target of aggregation. As a selection method, a list of sheet names can be displayed on another sheet or on the GUI screen depending on the content of data on the referenced sheet or by marking the referenced sheet different from the reference sheet. There is a method of displaying and allowing the user to select. The spreadsheet software 16 is provided with means such as an auto filter and a check box as simple functions that can be used when the user selects a sheet.

  In order to select a sheet on the reference side, a GUI screen (“screen for selecting a sheet on the reference side”) by an own code may be defined. In this case, the GUI screen is activated when the user double-clicks the “A1” cell of the list sheet or the total data sheet. A list of sheet names of the original data sheets is displayed on this screen. When many sheet names are displayed, a vertical scroll bar also appears on the screen. A check box is added next to each sheet name. When the user wants to exclude a certain sheet from the aggregation target, the check next to the sheet name of the sheet is removed. Thereafter, when the user presses the OK button, the macro is activated from the GUI screen. When there is a sheet that is not subject to aggregation, the macro sets the cell value in the “non-target flag” column of the sheet that is excluded from the list sheet to 1, and the “non-target flag” column of the sheet that is not. Leave the cell value blank. When the “excluded flag” corresponding to a certain original data sheet is 1, the calculation formula in the aggregate data sheet is to copy the value from that original data sheet (using the “If Then branch” function). The specification is not made. The “non-target flag” column of the list sheet is cleared when the list of the original data sheet is pasted and edited on this screen.

  For example, also in the original data sheet, the update process by the third state update unit 173 is possible. FIG. 25 is a diagram showing the original data sheet shown in FIG. Referring to FIG. 22B and FIG. 25, for example, in a deposit slip sheet, for example, an arithmetic expression for converting a partner code into a name in “N51” cell (hereinafter referred to as “name conversion formula”. In Excel (registered trademark), a simple means using a function such as “Vlookup” is widely used). Further, in the area of the receipt slip sheet that is normally hidden (name conversion formula reference area 35, see FIG. 22B), a partner list for converting partner codes into names is defined. Yes. The name conversion method is not limited to the above, and includes a method using a self-created function, a method of executing a macro by capturing an event, and the like. In addition to the other party, the code conversion can be various conversions such as place name, establishment name, product name, and account item.

  Then, as shown in FIG. 6A, when a numerical value is input in the partner code column ("N50" cell), the name conversion formula is entered by referring to the partner list in the name conversion formula reference area 35. If there is a partner name that matches the numerical value, the partner name is displayed in the partner name column ("N51" cell). The partner code field, the name conversion formula reference area 35, and the partner name field need not be in a single sheet. For example, the name conversion formula reference area 35 can be provided in a separate sheet, a separate file (workbook), or placed on another computer or storage on the network. The roles of the destination code column and the destination name column can be assigned to a single cell.

  A redefinition information setting area 25 is provided in, for example, the second row (“N2” cell) in the same column as the “N51” cell in which the name conversion formula is defined (see FIG. 22B). As the redefinition information R, a name conversion formula (an arithmetic formula defined in the “N51” cell) for converting a partner code into a name is defined.

  When conversion by the name conversion formula is unnecessary, the user directly inputs the partner name in the partner name column as shown in FIG. When it is desired to restore the conversion function based on the name conversion formula, the value is deleted (the Delete key is pressed) in the partner name column (cell “N51”) as shown in FIG. As a result, the third state updating unit 173 redefines the name conversion formula in the “N51” cell using the redefinition information R and the redefinition macro defined in the “N2” cell.

  Thus, in this embodiment, when the definition information S (mainly arithmetic expression etc.) used by the accounting basic processing program 21 is defined, the state update means 17 is set, and the cell, row, column, When there is a sheet operation, the definition information S can be redefined.

  FIG. 26 is a diagram illustrating another example of saving the sheet name list of “original data sheet”. In the figure, the functions of the list sheet are aggregated in the aggregate data sheet.

  In the above example, the method of writing as a list on a dedicated sheet, that is, a list sheet, as a sheet for storing the sheet name list of the “original data sheet” has been described.

  On the other hand, in the case of FIG. 26, the sheet name list of “original data sheet” is stored in the sheet on the reference side. That is, as shown in the figure, an area for storing a list of sheet names of “original data sheet” is defined in the total data sheet. As a result, the sheets constituting the skew calculation data unit can be divided into two types, that is, the original data sheet, and the aggregate sheet of the list sheet and the aggregate data sheet shown in FIG. Can do.

<Cell display mode changing means>
The accounting processing system 10 of the present embodiment further includes cell display mode changing means for changing the display mode of the cells according to a predetermined condition.

  The cell display mode changing means is a means for displaying the cell in a certain display mode when the content of the cell (definition information S) is a predetermined condition. Since the display mode of the cell may change depending on the input value, the user can determine whether or not the input value is appropriate, and in that sense, it can also be called a warning function.

Specifically, in the accounting basic processing program 21, as a cell display mode changing means, a display mode is set as a “conditional format” in advance in a cell within the target range for a sheet to be subjected to warning processing. Here, the “conditional format” is a basic function of the spreadsheet software 16 and is a function for designating a format relating to a display mode (character color or cell color) applied when a designated condition is met.
For example, for an arithmetic cell (default), the cell background color is set to light red, and for cells containing a fixed value, the cell background color is set to dark red.

  For example, the user inputs a constant (fixed value) for a cell in which an arithmetic expression is defined. In this case, in the above example, a constant (fixed value) is input to the cell of the light red background color and is no longer an arithmetic expression, so the background color is changed to dark red by the cell display mode changing means. By such a change in display mode, the user can visually check whether the definition information S set by default in the cell is an arithmetic expression or a fixed value, which can be useful for verification of calculation results. it can. Moreover, since the display mode of the cell in which the arithmetic expression is defined on the sheet and the cell in which the fixed value is defined are different, the appearance can be improved.

  The cell display mode changing means changes the mode triggered by the user's input on the sheet. The user visually determines whether the content of the cell is an arithmetic expression or a fixed value according to the display mode according to the set “conditional format”. For example, regarding a cell that should be a fixed value, if a fixed value is intentionally input, it is normal. If a fixed value is input by mistake, the value is deleted (the Delete key is pressed). .

  Then, triggered by the change event generated by “value deletion” for a certain cell in this way, the third state update unit 173 performs state update processing, and the redefinition information R defined in the operated cell is redefined. The

  As a specification of the automatic correction function of the spreadsheet software 16, when a row / column is inserted / deleted, the cell arithmetic expression (predetermined definition information S) is not maintained. Therefore, in the present embodiment, the calculation formula (predetermined definition information S) is maintained by the second state update unit 172 and the third state update unit 173. On the other hand, the “conditional format” set by the cell display mode changing means is maintained by the automatic correction function of the spreadsheet software 16 when a row / column is inserted / deleted.

  However, the automatic correction function of the spreadsheet software 16 does not maintain the “conditional format” of the cut cell when “cut the cell” is performed on the sheet. Therefore, the state update processing unit 17 of this embodiment redefines “conditional format”. Specifically, the state update processing means 17 executes the state update process when the sheet is deactivated, regardless of whether the “conditional format” in the sheet is normal or not, and the default “conditional format”. Is redefined. This process may be performed by, for example, the second state update processing unit 172 or may be performed by a separate state update processing unit. The default “conditional format” may be stored on the sheet as the redefinition information R as in the second state update processing unit 172, or may be stored in the macro source code. Further, “conditional format” may be copied from normal cells on the sheet.

  In addition to the background color, this display mode may be cell shading, underlining, font style change, or the like.

  In addition, the cell display mode changing means, for example, pays attention to the date input in the sheet, and changes the display mode (background color, etc.) of the entire row every time the date changes, or pays attention to the transaction type column. (For example, the sales line is light blue, the purchase line is pink, etc.). In this way, in addition to the warning function, the appearance of the sheet can be improved.

<Appendix>
Hereinafter, descriptions from other viewpoints of the present embodiment will be added, including what has been described so far.

[State update processing means]
The state update processing unit 17 according to the present embodiment performs a cell operation when a cell, row / column, or sheet is subjected to an operation (input or the like) that is different from or not assumed to be in the initial state in the accounting basic processing program 21. The definition information S originally defined in (1) is redefined, that is, the cell state is restored. Here, “restoration” has two types of meanings such as the following (X) and (Y).
(X) Correction function as basic function of spreadsheet software 16

This is what the spreadsheet software 16 performs to maintain the consistency of the arithmetic expression and display when the user edits the sheet (“automatic correction function” as a basic function). The unit functions include a change in arithmetic expression when adding / deleting a column, and a correction of the arithmetic expression when a user renames a sheet referred to as a sheet unit function.
(Y) State update processing function of this embodiment

  In order to maintain a predetermined result assumed by the accounting basic processing program 21, it is a function of repairing by the state update processing means 17 (the first state update processing means 171 to the fourth state update processing means 174 described above). For example, as a function of a cell unit, when the content of a specific cell is blank by the user, an arithmetic expression defined for each cell (definition information S) is overwritten (redefined by redefinition information R) And a function that automatically repairs when a format (conditional format) defined in a cell is deleted.

  In addition, as a sheet unit function, when a sheet is replaced or a sheet skewing operation is performed, the added or changed sheet is reflected on a reference subject.

  That is, in the present embodiment, the automatic correction function as a basic function of the spreadsheet software 16 is partially utilized, and the part that is insufficient in the automatic correction function is replaced with the state update processing means 17 (redefinition macro and redefinition information R, sheet Are provided with a repair function that is highly convenient for the user.

The accounting processing system 10 of the present embodiment has the following functions (means).
(A) When the contents of a cell are changed after the user has operated a row or column, the cell of the cell referred to by the accounting basic processing program 21 (accounting basic macro) is not inconsistent. Function for redefining contents (first state update processing means 171)
(B) A function of redefining the initial cell definition information S when the user performs any operation (input, etc.) on the cell, regardless of the type of input value (arithmetic expression, fixed value, etc.) ( Second state update processing means 172)

  In this case, in the case of the accounting processing system 10, the target sheets are, for example, an expense sheet, a sales / purchase sheet, an ordinary journal sheet, and an additional sheet. In addition, a sheet | seat is an example and is not restricted to this example.

  In addition, the update target cells are all the cells in the valid row range in the same column as the cell operated by the user. In this case, the cell range to be corrected is a cell that is long in the vertical direction. Become a group.

  In addition, the update target cell is updated (repaired) by the redefinition information R defined in the redefinition information setting area 25.

In addition, when a row is inserted in the target sheet, all cells in the valid row range in the column in which the arithmetic expression is to be inserted are updated (repaired) by the redefinition information R. That is, if there is at least one cell to be corrected in a certain column, the arithmetic expression for the entire column (of the inserted row) is updated. In this case, all the arithmetic expressions in the sheet may be updated. Further, when the sheet is moved, the arithmetic expression of the entire column of the inserted row may be updated (or all the arithmetic expressions in the sheet may be updated) or may not be performed.
(C) When a certain operation (input, etc.) is performed on a certain cell by the user, the input is allowed if the type of the input value is a fixed value (constant), otherwise, the initial cell Function for redefining the definition information S (third state update processing means 173)

  In this case, the target sheet is, for example, a sales sheet. Also, a certain cell to be updated is a cell belonging to a specific column in the list (a unit of a vertically long group), or a cell that displays a name conversion formula on a form sheet (one cell) Unit). However, if the cell does not satisfy the determination criterion (case 1 to case 5) of the third state update process described above, the process ends. In the determination, all the cells that have been input are determined in units of one.

  In addition, in the update process of a cell that performs display using a name conversion formula, when there are a plurality of cells in which the name conversion formula is defined in the same column, another area is appropriately selected as the definition area of the redefinition information R. Further, the redefinition information R may be directly described in the redefinition macro, but in that case, maintenance of the redefinition macro is necessary as appropriate.

  Also, when there is a row insertion in the target sheet, update processing is performed for all cells in the effective row range in the column where the arithmetic expression is to be placed. In this case, the cell range to be corrected is a group of cells that are long in the horizontal direction. Since all cells are blank when inserting a row, all cells are updated.

In addition, when moving from the target sheet to another sheet, the determination criteria (case 1 to case 5) of the third state update processing are performed for all cells in the valid row range in the column in which the arithmetic expression is to be entered. The determination is made on a cell-by-cell basis, and if there is an abnormal cell, it is updated.
(D) Basic accounting processing program 21 (accounting basic macro) When performing processing for a plurality of sheets, when a sheet is added or replaced, a function for reflecting them in processing for a plurality of sheets (fourth state) Update processing means 174)
(D-1) State update processing at the time of sheet replacement

  In this case, the trigger for starting the redefinition macro is when the sheet is moved from a referenced sheet (expense sheet, sales / purchase sheet, ordinary journal sheet, etc., hereinafter referred to as “target sheet”) to another sheet.

  Whether the source sheet belongs to the target sheet is determined by target sheet information serving as a mark. The target sheet information is, for example, a book level range name (in the above example, “g expense” of the expense sheet). This target sheet information is set to the latest target sheet.

  Further, the fourth state update processing unit 174 stores the target (added or the like) sheet name by a method that can be referred to from an arithmetic expression defined on the sheet on the side that refers to the sheet name.

  Here, it can be said that the function (d-1) is a function for performing generation management of a certain sheet (here, as an example, expense sheet). When replacing sheets, there will be multiple "expense" sheets. That is, there are a plurality of sheets having the same layout as the “old expense” sheet, the “new expense” sheet, the “second-generation expense” sheet, and so on. In this case, it is necessary to determine which sheet is the original, the latest, and from which sheet the amount is to be totaled. If this original is confirmed, the state update processing means 17 can automatically update the state. The target sheet information for determining the original is, for example, a book level range name (for example, “g expense”), and the target sheet information is set in a cell on the sheet in advance.

  The re-definition macro activation trigger may be when the sheet is moved from the referenced sheet to another sheet, or when the redefined macro is moved from another sheet to the referenced sheet.

  The target sheet information is not limited to the presence / absence of a range name, the presence / absence / content of a comment, a specific cell (such as the “A1” cell), a specific character format, and a specific cell format (for example, For example, the color of the ruled line may be specified).

  Further, the storage location of the sheet name may be a location that can be read from the arithmetic expression of the spreadsheet software 16, and may be, for example, any cell of the referenced sheet or the referenced sheet. Also, a special sheet for storing the sheet name may be defined, a method of writing in a list of range names (Names object), or a method of using a function that returns the sheet name.

The item stored by the redefinition macro may be a reference destination sheet name, a reference destination sheet name and a reference destination address, a cell reference, or the like. Any form that can be interpreted by the calculation formula of the spreadsheet software 16 may be used, and a range name may be used.
(D-2) State update processing during skewering calculation processing

  The redefinition macro for updating the state at the time of skewering calculation processing is executed when moving from the original data sheet to another sheet.

  Whether or not the movement source sheet is an original data sheet is determined by whether or not target sheet information (for example, a sheet level range name) is set for the sheet as in (d-1) above.

  The redefinition macro determines whether or not the name of the source sheet is included in the list sheet. If the sheet name is not included in the list sheet, processing continues. If the process ends, the process ends.

  The redefinition macro stores the sheet name of the original data sheet in a predetermined area of the list sheet. In the present embodiment, an independent sheet (list sheet) is defined in order to securely hold a list of sheet names. One list sheet is defined for one “skipping calculation data unit”. The redefinition macro is activated when moving from the original data sheet to another sheet (DeActivate event occurs).

  The target sheet information is not limited to the presence / absence of a range name, the presence / absence of a named range, the presence / absence / content of a comment, and the format of a specific cell that puts a specific character in a specific cell (such as the “A1” cell). It may be in a specific shape (for example, ruled line color designation).

  Further, the sheet name storage location may be any location that can be read from the calculation formula of the spreadsheet software 16, and a special sheet for storing the sheet name is defined (a list sheet that constitutes the "skew calculation data unit") Can be defined and written, or can be saved in the reference sheet ("cell region" for saving the sheet name can be defined and saved in the aggregate data sheet (see FIG. 26)) It may also be written in a list of range names (Names object).

  The item stored by the redefinition macro may be a reference destination sheet name, a reference destination sheet name and a reference destination address, a cell reference, or the like. The range name may be used as long as it can be interpreted by an arithmetic expression of the spreadsheet software 16.

  In addition, the “skeining calculation data unit” is a unit having one configuration, for example, three types of original data sheet, total data sheet, and list sheet, and the number of sheets is 1 to 99 for the original data sheet. , One total data sheet and one list sheet. The upper limit of the number of original data sheets belonging to a single “skew calculation data unit” depends on the upper limit of the number of sheet rows (according to the specifications of the spreadsheet software), the amount of memory installed in the computer, etc. Definition is also possible. Further, the original data sheet belonging to the “skewer calculation data unit” may be zero.

  For example, in the accounting processing system 10, a “skipping calculation data unit” is implemented. Within this unit, the sheet level range name “add n” is used to bundle data of a plurality of sheets. In other words, this sheet level range name “add n” corresponds to one “skew calculation data unit”. If the sheet level range name is changed, a plurality of “skipping data units” can be defined in the file (workbook). it can. In this case, the configuration of the “sticker data unit” may be different.

Moreover, the accounting processing system 10 of this embodiment is not restricted to what is comprised in the single file (workbook). Save one or more “skewer calculation data units” to another file, or save a part of “skewer calculation data units” to another file, that is, list sheets, summary data sheets and original data sheets can be saved separately. Saving to a file is also possible. In these cases, in addition to the macro, a data reference function between files included in the basic function of the spreadsheet software 16 can be used.
(E) Warning function according to cell input content (cell display mode changing means)

  When the cell content (definition information S) is a predetermined condition, it is a means for displaying the cell in a certain display mode, and the display mode of the cell changes according to the input value, so that it can be used as a warning function. . In addition, even in the initial state, cells having different display modes partially exist, so that the decorativeness and visibility of the sheet can be improved. This warning function and the setting that enhances the decoration and visibility are redefined and maintained by the macro.

  Any of these functions (a) to (e) is triggered by a macro (redefinition macro) of the state update processing means 17 triggered by a certain event and updates (redefines) the cell state. .

[Event]
In the present embodiment, the state update process is executed in response to the occurrence of the Change event and the DeActivate event. However, the state update processing by the first state update processing means 171 in (a) is used as necessary in each macro (accounting basic macro and / or redefinition macro) regardless of the event. .

  The function (b) is triggered by the occurrence of a Change event and a DeActivate event, and the function (c) is a function when the Change event occurs in a list format sheet or when the Change event occurs in a form format sheet. Or when the DeActivate event occurs (list, form, format unquestioned), the function in (d) above is triggered when the DeActivate event occurs on the target sheet. The function e) is triggered when the DeActivate event occurs in the target sheet.

  Note that these are only examples. For example, instead of the DeActivate event (occurs when the target sheet becomes non-active due to movement of the sheet), the Activate event (occurs when the target sheet becomes active due to movement of the sheet) ), Or both DeActivate and Activate events.

  Each event described above is an example, and an event having a similar function or another event can be applied. There is also a method of utilizing the mechanism that generates each event as an own code. In this case, for example, an event such as when a file is saved or when a user presses a button can be cited.

  In the present embodiment, the state update processing unit 17 has described the example of updating the state using the redefinition information R and the redefinition macro that copies this to the reference target cell. The address of the reference target cell may be described with a character string (for example, an arithmetic expression including the address is described with a character string), and the reference target cell may include a configuration that prohibits the user's operation. In this case, when a row or column is inserted and the cell address is moved, the address of the reference target cell (for example, an arithmetic expression including the address) described in the character string in the accounting basic macro is manually rewritten.

  The redefinition information R is recorded in an arbitrary cell of an arbitrary sheet (not necessarily a sheet in the same file as the definition information S), and the redefinition information setting area 25 records the redefinition information R. References (file name, sheet name, cell address, range name, etc.) to the designated cell may be recorded. Even in this case, when a row / column is added / deleted on the sheet to which the definition information S belongs (although there are certain conditions), the automatic correction function of the spreadsheet software 16 allows the redefinition information R to be changed. The content is modified.

  Alternatively, the redefinition information R may be recorded in an object or property belonging to the cell of the definition information generation field 27.

  For example, the fourth state update unit 174 records an arithmetic expression (in the form of a character string) in the value (property) of a comment (object) belonging to the destination name field (cell of the original data sheet). Also good. In this case, when a row or column is inserted and the cell address is moved, the address of the reference target cell described in the character string as the comment value (for example, an arithmetic expression including the address) is manually rewritten.

  Moreover, the structure which records the reference to the cell by which the redefinition information R was recorded on the value of the comment which belongs to the other party name column may be sufficient.

  In the state update process by the state update unit 17 of the present embodiment, an arithmetic expression is stored in the state update processing program 23, or redefinition information R (for example, an arithmetic expression including an address) is stored in the definition information S area. Or a method such as selection. Specifically, for example, when a unique event is generated when a line is inserted, an arithmetic expression may be copied from an adjacent line.

  In the above embodiment, an example in which Excel (registered trademark) is used as the spreadsheet software 16 has been described. However, other spreadsheet software having the same function can be implemented in the same manner, and the same effect can be obtained. It is done.

  The present invention is also an information processing method used in the information processing system described in the above embodiment. That is, in the information processing method for performing a predetermined fixed process using the spreadsheet software 16, the definition information S defined in relation to at least one cell of the spreadsheet software 16 is used to execute the fixed process. When an operation is performed on at least one of a cell, a row, a column, and a sheet to which the definition information S is related and a step of executing the used processing, an area other than the scheduled operation area 22 (redefinition information) And updating the state of the operable object using the redefinition information R defined in advance in the setting area 25).

  The present invention is also an information processing program using spreadsheet software that causes a computer to execute processing according to the above information processing method.

  Further, the present invention is a calculation processing apparatus that includes the above-described input means, output means, calculation processing means, and state update processing means, and performs calculation of predetermined processing using spreadsheet software. This calculation processing apparatus can be realized by, for example, mounting a program for causing a computer to execute the processing according to the calculation processing method described above.

  As described above, the accounting processing system 10 of the present embodiment uses the spreadsheet software 16 to reproduce an environment familiar to the user like a conventional handwritten book, and to further customize the user slightly. It allows for highly convenient operation while allowing.

  That is, in order to improve the convenience and versatility of the user's operation, the user's input restriction and operation restriction are reduced as much as possible. For this reason, the basic functions are utilized as much as possible, and slight customization (insertion / deletion of rows, addition / deletion / duplication of sheets, etc.) by the user is allowed, and the operation scheduled area 22 is as wide as possible (non-display area) (As much as possible) (cell operation such as addition or replacement of sheets, change of a table set, etc. is allowed) and arbitrary input is allowed in the scheduled operation area 22.

  Furthermore, when the user operates (adds, deletes, etc.) an operation target of at least one of a row, a column, a cell, and a sheet related to a cell in which the definition information S is defined (set), an accounting processing system Even in the case where the process assumed in FIG. 10 cannot be performed (the expected appropriate result cannot be obtained), the state update processing unit 17 uses the redefinition information R and the redefinition macro. By redefining the definition information S in at least one cell, the manipulable target can be returned to a state in which the originally assumed processing can be performed (assumed appropriate result is obtained). Thereby, for example, stable operation can be realized without using the functions of “sheet protection” and “book protection” in the spreadsheet software 16.

  The state updating unit 17 described above may be configured to include all of the first state updating unit 171 to the fourth state updating unit 174, or may include a part thereof. A part of them can be applied in appropriate combination.

  In the above embodiment, an accounting processing system that performs accounting processing as the information processing system 10 has been described as an example. However, the present invention is not limited to the above example as long as the information processing system uses spreadsheet software. For example, the above embodiment can be similarly applied to an information processing system using spreadsheet software used in various operations such as sales, results management, inventory and production management, and similar effects can be obtained. .

  It should be noted that the present invention is not limited to the above-described embodiment, and it is needless to say that various modifications can be made without departing from the gist of the present invention.

1 Accounting system (accounting terminal equipment)
2 Input unit 3 Arithmetic processing unit 3a Accounting processing unit 3b Automation processing unit 4 Output unit 10 Information processing system (accounting processing system)
DESCRIPTION OF SYMBOLS 11 Input means 12 Output means 13 Control means 14 Storage means 15 Basic processing means 16 Spreadsheet software 17 State update processing means 19 Information processing terminal 20 Information processing program (accounting processing program)
21 Accounting Basic Processing Program 22 Scheduled Operation Area 23 Status Update Processing Program 25 Redefinition Information Setting Area 27 Definition Information Generation Field 30 Reference Destination Sheet Name Field 33 Aggregation Area 35 Name Conversion Formula Reference Area 171 First State Update Processing Unit 172 2 state update processing means 173 3rd state update processing means 174 4th state update processing means

Claims (15)

An information processing system that performs predetermined routine processing using spreadsheet software,
An input unit, an output unit, a basic processing unit, and a state update unit;
The basic processing means is:
In order to execute the standard processing, it is possible to execute processing using an expression or value (hereinafter referred to as “definition information”) defined in association with at least one cell of the spreadsheet software,
The state update means includes
Redefinition information predefined in an area other than an area where an operation is scheduled when the user performs the routine processing (hereinafter referred to as “operation scheduled area”),
When an operation is performed on at least one of a cell, a row, a column, and a sheet that can be associated with the definition information, the state of the operable object can be updated using the redefinition information.
An information processing system characterized by this. The definition information is an expression or value defined for a cell in the operation planned area,
The state update means is configured such that when the row or the column related to the definition information is operated, an arbitrary value is overwritten in the cell in which the definition information is defined, or the contents of the cell are deleted. In at least any of the cases, the definition information can be redefined in at least one cell using the redefinition information.
The information processing system according to claim 1. The state update unit refers to a sheet that has been added or replaced when a process for adding or replacing a sheet is performed, or when processing for a plurality of sheets among the predetermined processes by the basic processing unit is executed. The sheet is specified so as to be an object of the sheet, and the name of the sheet is stored in a form that can be referred to from an arithmetic expression defined on the sheet on the reference side.
The information processing system according to claim 1, wherein the information processing system is an information processing system. Comprising a display mode changing means for changing the display mode of the cell according to a predetermined condition;
The information processing system according to any one of claims 1 to 3, wherein: The routine process is an accounting process.
The information processing system according to claim 1, wherein the information processing system is an information processing system. An information processing method for performing predetermined routine processing using spreadsheet software,
Executing a process using an expression or a value (hereinafter referred to as “definition information”) defined in association with at least one cell of the spreadsheet software in order to execute the routine process;
When an operation is performed on at least one of the cells, rows, columns, and sheets to which the definition information is related, the region is not the region where the operation is scheduled when the user performs the predetermined process. Updating the state of the operable object using pre-defined redefinition information,
An information processing method characterized by the above. The routine process is an accounting process.
The information processing method according to claim 6.   An information processing program using spreadsheet software that causes a computer to execute processing according to the information processing method according to claim 6. An accounting program installed in a computer equipped with spreadsheet software that pre-sets multiple accounting processing sheets.
An automatic processing unit that performs either one or both of automatic assignment and automatic repair is assigned to the computer with respect to a mathematical expression relating cells in one sheet of the plurality of accounting processing sheets and cells in the plurality of sheets. , Accounting program.   10. The accounting program according to claim 9, wherein the plurality of accounting processing sheets are a set of a sales / purchase sheet, a daily balance sheet, a profit and loss calculation sheet, and an expense sheet.   11. The accounting program according to claim 9, wherein the automation processing unit performs automatic granting and automatic repair when transitioning between the plurality of accounting processing sheets, or when the accounting program is started or ended. An accounting program that is performed at least one of the cells in any one of the accounting processing sheets when a mathematical expression other than a predetermined formula is input.   An accounting system, comprising: a computer storing spreadsheet software; and the accounting program according to claim 1. An accounting processing unit using spreadsheet software that presets a plurality of accounting sheets,
An automatic processing unit that performs either one or both of automatic assignment, automatic repair, and a mathematical expression relating cells in one sheet of the plurality of accounting processing sheets and cells in the plurality of sheets,
An input section;
An output section;
An accounting apparatus. It is an accounting method in which a plurality of accounting processing sheets are set in advance for spreadsheet software, and daily transactions are input to the plurality of accounting processing sheets,
When transitioning between a plurality of accounting processing sheets, at the time of starting or ending spreadsheet software, enter a formula other than the expected formula that is a cell in one of the plurality of accounting processing sheets An accounting method for performing either or both of automatic assignment and automatic repair on a mathematical expression relating cells in one sheet of the plurality of accounting processing sheets and cells in the plurality of sheets. A plurality of accounting processing sheets are set in advance for spreadsheet software, and a plurality of the accounting processing sheets are accounting terminal devices for inputting daily transactions,
When transitioning between a plurality of accounting processing sheets, at the time of starting or ending spreadsheet software, enter a formula other than the expected formula that is a cell in one of the plurality of accounting processing sheets An automatic processing unit that performs either one of or both of automatic assignment and automatic repair with respect to a mathematical expression that relates cells in one sheet of the plurality of accounting processing sheets and between cells in the plurality of sheets. Terminal device.