JPS6144351B2 - - Google Patents

Description

[Detailed Description of the Invention] The present invention relates to an electronic spreadsheet calculator that executes two or more preset functions corresponding to one column of a spreadsheet to be printed. .

Conventional spreadsheet calculators only execute one function for each column of a spreadsheet to be printed, so for example, after printing the last column of a spreadsheet, the printer's carriage is I had to operate the carriage return key to return it to its position.

Therefore, in the present invention, it is possible to set two or more functions corresponding to the column of the tabulation sheet to be printed, and when the execution key is pressed, the set function is first executed, and then the other functions are executed. By executing functions sequentially,
The purpose of this invention is to solve the problems of the above-mentioned conventional example.

An embodiment of the present invention will be described below with reference to the drawings. FIG. 1 shows the external appearance of the electronic spreadsheet calculator in this embodiment. In the figure, reference numeral 1 denotes a housing, in which a printer 2 is provided on the top surface, a display 3 is provided on the upper front surface, and a keyboard 4 is provided on the lower front surface. The printer 2 is a serial printer in which a print head is mounted on a carriage that reciprocates along a platen 5. Further, at the rear of the platen 5, a scale 6 having graduations provided over the entire length of the platen 5 and a plurality of indicators 7 that slide in correspondence with the graduations of the scale 6 are provided.

FIG. 2 shows the keyboard 4. As shown in FIG. This keyboard 4 includes, in addition to numeric keys 11 and function keys 12 for "0", "00" to "9",
Mode change switch 13 for switching between four modes: "program mode", "automatic mode", "manual mode", and "1 column mode", decimal point designation switch 14, rounding selection switch 15, display switch 16, counter switch 17, memory switch 18, a line feed pitch selection switch 19, etc. are provided, respectively. The function key 12
These include the carriage turn key "←", the tab skip key "→", the backward paper feed key "↓" which commands line feed according to the line pitch set by the line feed pitch selection switch 19, and the forward key. Paper feed key "↑", total memory read key "*T""〓"
T” (however, “*T” clears the cumulative memory),
Clear key "C", date key "D", division key "÷", equal key "=", multiplication key "×", non-add key "#", percent key "%", clear entry key "CE", decimal point Input key "・", Execution key "Execute", Arithmetic memory addition key "+""+"
"+", calculation memory subtraction key "-""-""-"
”, calculation memory read key “〓” “〓” “〓”,
"*", "*", and "*" are provided respectively.

Note that the program mode is a job that sets date data and tab data (tab position data that defines each column position of the tabulation sheet, function code data and numerical data in that column) to a predetermined memory area. , the automatic mode is the operation of automatically executing the function according to the tab data set by the program mode, and the manual mode is the operation of automatically executing the function according to the tab data set by the program mode, and the manual mode is the operation of automatically executing the function by pressing the function key 12. The one-column mode refers to a task of executing a function based on a preset function or a pressed function key 12 in one column.

FIG. 3 shows the circuit configuration of the tabulation calculator. In the figure, 21 is a central processing unit (CPU). This CPU 21 includes a keyboard control circuit 2.
2 and the display 3 via the display control circuit 23.
A memory [ROM] 24 and a random access memory [RAM] 25 are connected to the printer 2 via a printer control circuit 26, respectively. The ROM 24 includes the keyboard 4.
A processing program is written in advance that causes the upper key to be operated to execute a process based on the input key according to each mode specified by the mode changeover switch 13. Also, the above
As shown in FIG. 4, the RAM 25 has first and second
Each time the processing based on the operation of the execution key "Run" is completed in a state where the number buffer memories 27, 28, the function code buffer memory 29, and the mode changeover switch 13 specify "program mode". A setting counter 30 that counts up, a date data memory 31, first to eighth tab data memories 32a to 32h corresponding to each column of the tabulation sheet in order, and an arithmetic memory 33.
and arithmetic operations, arithmetic memories 34 and 35, a total memory 36 to which the data in the arithmetic memory 33 is transferred when the arithmetic memory read key "*" is pressed while the memory switch 18 is on, and the counter switch 17 is on. In the state, the arithmetic memory 33 and the arithmetic memory 34, 35
A counter 37 that counts the number of data processed to
and counters 38, 39, the function code data of the function keys 12 except for the backward paper feed key "↓", the forward paper feed key "↑", the clear key "C" and the execution key "execute" are stored respectively. function code memory 4
0, a print buffer memory 41 and a display buffer memory 42 are respectively allocated to predetermined addresses. As shown in FIG. 5, each of the first to eighth tab data memories 32a to 32h includes a numerical data storage area 43 for storing numerical data, a tab position data storage area 44 for storing tab position data, and a tab position data storage area 44 for storing tab position data. First and second function code data storage areas 45 and 46 are provided for storing first and second function code data, respectively.

Next, the processing operation of the tabulation calculator will be explained along with the flowcharts shown in FIGS. 6 to 9.
Now, when the power is turned on, the CPU 21
According to the main routine shown in the figure, initial settings are first made, and then a loop of determining whether or not there is a key input is repeated. Here, when a key input is detected, it is then determined whether or not the mode changeover switch 13 is in the "program mode", and the mode changeover switch 13 is
3 is the "program mode", all input key signals are processed according to the program mode processing routine shown in FIG. Also, if the mode changeover switch 13 is not in the "program mode", that is, in one of the "automatic mode", "manual mode", and "1 column mode", whether the next key input is the numeric key 11 or not. It is sequentially determined whether or not the execution key is "execute", and whether the date key is "D". At this time, if the numeric key is 11, numeric data processing is performed, if the execution key is "execute", processing is performed according to the execution key processing routine shown in FIG. 8, and if the date key is "D" Processing is performed according to the date key processing routine shown in FIG. Further, if the number key 11, the execution key "execute", and the date key "D" are not selected, that is, if it is any other function key 12, the function key input from the function code memory 40 is After reading the function code data corresponding to the function key 12 and performing function key processing according to the function code data, it is determined whether or not to print based on the processed function. When printing, it is determined whether the mode changeover switch 13 is in "1 column mode" and the mode changeover switch 13 is
If is in "1 column mode", one column printing process is performed, that is, printing process is performed in the vertical direction along one column, and if it is not in "1 column mode", parallel printing process is performed, that is, printing process is performed in the horizontal direction along the line.

In addition, in the infix number data processing explained above,
Processing is performed to store the numeric data inputted by the numeric key 11 into the first numeric buffer memory 27. Also, in the date key processing routine,
According to the date key processing routine shown in FIG. 9, it is determined whether there is numeric data in the first numeric buffer memory 27, and if there is numeric data, the numeric data is printed as date data, and the If there is no numerical data, a process of printing the date data in the date data memory 31 is performed. Further, typical examples of the function key processing are as follows.

If the carriage return key is "←" (function code data "←"), the carriage is moved to the left home position.

If the tab skip key is "→" (function code data "→"), the carriage moves to the next tab position.

If it is a non-add key "#" (function code data "#"), the numeric data in the first numeric buffer memory 27 is printed and displayed.

If the arithmetic memory addition key is "+" (function code data "+"), when there is numeric data in the first numeric buffer memory 27, the numeric data is added to the arithmetic memory 33 and printed and displayed. However, when there is no numeric data, the data in the calculation memory 33 is printed and displayed on the condition that the data in the calculation memory 33 is not zero (if the data in the calculation memory 33 is zero, it is not printed).

If the arithmetic memory subtraction key is “-” (function code data “-”), the numeric data in the first numeric buffer memory 27 is transferred to the arithmetic memory 3.
It is subtracted from 3 and printed and displayed.

If the calculation memory read key is "*" (function code data "*"), the calculation memory 3
Print and display the contents of 3.

If the arithmetic memory addition key is "+" (function code data "+"), the numeric data in the first numeric buffer memory 27 is added to the arithmetic memory 34 and printed and displayed.

If the arithmetic memory read key is "*" (function code data "*"), the contents of the arithmetic memory 34 are printed and displayed.

If the cumulative memory read key is "*T" (function code data "*T"), the contents of the cumulative memory 36 are printed and displayed.

The above is the processing operation of this spreadsheet calculator.Next, the operations for each of the four modes selected by the mode changeover switch 13, ie, "program mode", "automatic mode", "manual mode", and "1 column mode" are explained. The processing based on this will be explained.

[Program mode] In program mode, press mode selector switch 1.
3 is switched to the "program mode", the data of the setting counter 30 is displayed on the leftmost digit of the display 3, and when the switch is switched to the "program mode", the numeric key 11, the function key 12, and the execution key are pressed. When the "execute" key is pressed, the following processing is performed.

When the numeric key 11 is pressed, the numeric data is stored in the first numeric buffer memory 27.

If function key 12 is pressed,
The function code data corresponding to the pressed function key 12 is read from the function code memory 40, transferred to the function code buffer memory 29, and then transferred to the first numeric buffer memory 27. On the condition that there is numeric data, the numeric data is transferred to the second numeric buffer memory 28.

When the execution key "Execute" is pressed, it is first determined whether or not date data is to be set in the date data memory 31 according to the flowchart of FIG. At this time, if the data in the setting counter 30 is "0", it is determined that the date data is being set in the date data memory 31, and the first
After writing the data (date data) in the number buffer memory 27 to the date data memory 31, the setting counter 30 is counted up. Also, if the data of the setting counter 30 is “1” other than “0”
~ "8", it is determined that the tab data is set to the first to eighth tab data memories 32a to 32h, and then the first number buffer memory 2 is set.
7, whether numeric data (numeric data) is set in the second numeric buffer memory 28, whether numeric data (tab position data) is set in the second numeric buffer memory 28, and whether the function code buffer memory 29 is set.
It is determined whether or not function code data is set. If numerical data is set in the first buffer memory 27, the numerical data is transferred to the first to eighth tab data memories 32 corresponding to the data of the setting counter 30.
Write to the numerical data storage area 43 of a to 32h. Further, if tab position data is set in the second buffer memory 28, the tab position data is transferred to the tab position data of the first to eighth tab data memories 32a to 32h corresponding to the data of the setting counter 30. Write to storage area 44. Furthermore,
If the function code data is set in the function code buffer memory 29,
Next, it is determined whether or not there is one function code data, and if there is one, the first function code data is used as the first to eighth function code data corresponding to the data of the setting counter 30. If there is no one, then the first and second function code data are sent to the first function data storage area 45 of the tab data memories 32a to 32h by the setting counter 30.
After writing the corresponding data into the first and second function code data storage areas 45 and 46 of the first to eighth tab data memories 32a to 32h, the setting counter 30 is counted up.

The above is the keyboard 4 in program mode.
This is the process when the above various keys are pressed.Next, in this program mode, date data is set in the date data memory 31, and each tab data is set in the first to eighth tab data memories 32a to 32h. Let's explain the case. In the case of date data setting operation, the display on the display 3 is "0", that is, the data on the setting counter 30 is "0".
In the initial state, when date data, for example, day, month, and year, is entered in order using the numeric key 11 and the decimal point key ".", the date data is stored in the first numeric buffer memory 27. After this, when the execution key "Execute" is pressed, since the data in the setting counter 30 is "0", it is determined that date data is to be set, and the date stored in the first numeric buffer memory 27 is The data is written to date data memory 31. Then, the data of the setting counter 30 is counted up by 1, so
Next, a state is reached in which tab data can be set in the first tab data memory 32a.

In the case of setting tab data, for example, the first
As shown in Figure 0, a tabulation sheet with columns such as "previous stock", "transaction number", "receipt/output", "current stock", etc. is set in the printer 2, and an indicator 7 is placed on the vertical line on the right side of each column. Then, the scale (tab position data) on the scale 6 where each indicator 7 is located is read. Then, after inputting the tab position data, function code data, and numerical data from the leftmost "previous stock" column, the execution key "execute" is pressed. That is, first, use the number key 11 to set the tab position data in the first column, and then enter 1 corresponding to the function code data to be programmed in the first column.
Or, press the function key 12 of 2, and then input numerical data using the numeric key 11. Then, numerical data is stored in the first numeric buffer memory 27, tab position data is stored in the second numeric buffer memory 28, and function code data 1 or 2 is stored in the function code buffer memory 29. The state will be as follows. After that, when the execution key "Execute" is pressed, since the data in the setting counter 30 is "1", it is determined that the tab data is to be set in the first tab data memory 32a, and the first set number is set. The numerical data of the buffer memory 27 is transferred to the numerical data storage area 43 of the first tab data memory 32a, and the numerical data of the buffer memory 27 is transferred to the numerical data storage area 43 of the first tab data memory 32a.
8 tab position data is stored in the first tab data memory 3
1 or 2 of the function code buffer memory 29 to the tab position data storage area 44 of 2a.
The function code data is written into the first and second function code data storage areas 45 and 46 of the first tab data memory 32a, respectively. When the setting in the first tab data memory 32a corresponding to the first column is completed through the above processing, the data in the setting counter 30 becomes 1.
Since it is counted up, it becomes possible to set tab data in the second tab data memory 32b. Therefore, from now on, in the same way, the second to
Tab data can be sequentially set in the fourth tab data memories 32b to 32d.

〔auto mode〕

In the automatic mode, when the execution key ``execute'' is pressed while the mode changeover switch 13 is switched to the ``auto mode'', the following processing is performed according to the execution key processing routine shown in FIG.

1st to 8th tab data memories 32a to 32a corresponding to the column of the tabulation sheet in which the carriage is located;
If function code data is not set in 32h, the carriage is moved to the next tab position and then returns to waiting for a key. Therefore, in a column for which function code data has not been set in advance, if the data in that column is all "0" and there is no need to print the "0", press the execution key "Execute". It is possible to move to the print waiting state for the next column without printing anything in that column.

1st to 8th tab data memories 32a to 32a corresponding to the column of the tabulation sheet in which the carriage is located;
When function code data is set in column 32h and there is numeric data in the first numeric buffer memory 27, the first to eighth tab data memories 32a to 32 corresponding to that column are
After performing arithmetic processing on the numeric data in the first numeric buffer memory 27 according to the first function code data set in h, it is determined whether or not to print based on the processed function. . Here, if printing is not desired, the process returns to the key wait process. On the other hand, when printing, after parallel printing processing, if the second function code data is set in the second function code data storage area 46, the second
Processing is performed according to the function code data. Therefore, for example, the first to eighth tab data memories 32a corresponding to the last column of the tabulation sheet
The calculation memory 33 is stored in the first and second function code data storage areas 45 and 46 of ~32h.
If you set the function code data "*" for reading the data and the function code data "←" for the carriage return, you can simply press the execution key "Execute" to read the data in the calculation memory 33 in the last column. After printing, the carriage can be automatically returned to the home position on the left side.

1st to 8th tab data memories 32a to 32a corresponding to the column of the tabulation sheet in which the carriage is located;
When function code data is set in 32h, numerical data is not set, and there is no numeric data in the first numeric buffer memory 27, it is determined that the "0" key has been pressed, and the column corresponds to that column. After performing arithmetic processing according to the function code data set in the first to eighth tab data memories 32a to 32h, the same processing as described above is performed. Therefore,
If the number data is zero in a column where function code data is set in advance, if you press only the execution key "Execute", it will be regarded as a 0 input and the process will be executed according to the set function. be able to.

1st to 8th tab data memories 32a to 32a corresponding to the column of the tabulation sheet in which the carriage is located;
When function code data and numerical data are set in 32h and there is no numeric data in the first numeric buffer memory 27, the data is set in the first to eighth tab data memories 32a to 32h corresponding to that column. After arithmetic processing is performed on the numerical data set according to the function code data, the same processing as described above is performed. Therefore, if a specific number is always printed in a specific column, for example, if a certain amount of data is always printed in a specific column when sequentially tallying a certain amount of sales, the specific column The first corresponding to
If you set specific numerical data in the numerical data storage area 43 of the eighth tab data memory 32a to 32h, you can set it in a specific column by simply pressing the execution key "Execute" without pressing the numeric key 11 each time. The displayed numerical data can be automatically printed.

On the other hand, if the numeric key 11, date key "D", and other function keys 12 are pressed in addition to the execution key "Execute", the sixth
Processing is performed according to the main routine shown in the figure and the date key processing routine shown in FIG. Therefore, even in this automatic mode, when these function keys 12 are pressed, the function code data preset in the first to eighth tab data memories 32a to 32h corresponding to each column is Processing is performed according to the function code data of the pressed function key 12, regardless of the presence or absence of the function key 12. Therefore, if you want to execute a function that differs by only one line in a column in which function code data is preset, press the desired function key 12 in the line of that column, and the set function code data will be executed. The function of the pressed function key 12 can be executed without affecting the function code data.

The above is the processing when various keys are pressed in the automatic mode. Next, the operation for an example of printing as shown in FIG. 11 in the automatic mode will be explained. In this case, the tab position data and the function code data "+" are stored in the first tab data memory 32a corresponding to the "previous stock" column, and the tab position data and the function code data "+" are stored in the second tab data memory 32a corresponding to the "transaction number" column. Tab data memory 32b
The tab position data and the function code data "#" are stored in the third tab data memory 32c corresponding to the "In/Out" column, and the tab position data is stored in the fourth tab data memory 32c corresponding to the "Current inventory" column. It is assumed that the tab position data, the first function code data "*", and the second function code data "←" are set in the tab data memory 32d.

Now, in the first line, if the tab skip key "→" is pressed three times, the carriage is moved to the "Current stock" column according to the process described above. Subsequently, when the execution key "Execute" is pressed, the above-mentioned processing is performed. In other words, after data "0" in the calculation memory 33 is printed according to the first function code data "*" set in the fourth tab data memory 32d, the second function code data Following "←", the carriage is automatically returned to the "previous stock" column on the left. next,
In the second line, when the execution key "execute" is first pressed, the aforementioned process, that is, the process is performed according to the function code data "+" set in the first tab data memory 32a. However, when processing this function code data "+", the data in the calculation memory 33 is "0".
Therefore, according to the above process, nothing is printed in the "previous stock" column. Next, use the numeric keys 11 to enter digits “1,” “2,” “3,” “4,” and “5,” and store the numeric data in the first numeric buffer memory 27.
After storing to , press the execution key "Execute" to perform the above processing. That is, the above processing is performed according to the function code data "#" set in the second tab data memory 32b. Then, in the "Transaction number" column,
The first numeric buffer memory 27 is
The numeric data 1, 2, 3, 4, and 5 are printed.
Furthermore, use the numeric key 11 to enter ``4'' and ``0'', and store the numeric data in the first numeric buffer memory 27.
When the arithmetic memory addition key "+" is pressed after storing the data to the arithmetic memory 33, the numeral data 40 in the first numeral buffer memory 27 is added to the arithmetic memory 33 and printed and displayed according to the process described above. lastly,
When the execution key "Execute" is pressed, the above processing is performed. After that, if the operation shown on the left side of the figure is performed in the third, fourth, and fifth lines,
It will be printed as shown in FIG.

[Manual mode]

In the manual mode, when the execution key ``execute'' is pressed with the mode changeover switch 13 set to ``manual mode'', the carriage is moved to the next tab position according to the flowchart in FIG. After that, the process returns to waiting for a key. In the case of the numeric key 11, date key "D", and other function keys 12, processing is performed according to the main routine shown in FIG. 6 and the date key processing routine shown in FIG. 9, which have already been described. Therefore, when these keys are pressed in the manual mode, the functions related to the function code data set in the first to eighth tab data memories 32a to 32h corresponding to each column of the spreadsheet are displayed. Instead, processing is performed according to the function code data of the pressed function key 12.

FIG. 12 shows an operation in this manual mode and an example of its printing. From this figure,
Some function key 1 in each column
When 2 is pressed, the pressed function key 1
It will be understood that the processing is performed according to the function code data corresponding to No. 2.

[One Column Mode] In the one column mode, the processing based on the various keys in the automatic mode is basically the same. However, the only difference from the automatic mode is that the printing mode is processed within one column.

FIGS. 13a and 13b show an example of operation and printing in this one-column mode. As is clear from this figure, when the mode changeover switch 13 is switched to the "1 column mode", each time the function key 12 is pressed, the tabulation sheet is fed and printed in the vertical direction. It is also possible to use it as

In this way, in this spreadsheet calculator, it is possible to switch between four modes: "program mode,""automaticmode,""manualmode," and "one column mode" simply by operating the mode changeover switch 13.

Note that in the above embodiment, each tab data memory 32
Although two function code data can be set for each of a to 32h, it is possible to set more than two function code data.

According to the present invention, in automatic mode, when the execution key is pressed, after executing a process according to one function code data set in advance,
Processing is performed sequentially according to other preset function code data, so if you set two or more function code data corresponding to one column, the process will be executed for that column. Processing can be executed sequentially according to two or more set function code data simply by pressing the execute key. By setting the function code data to return , it is possible to return the carriage to its original position after printing the total simply by pressing the execution key in the last column.

[Brief explanation of the drawing]

The figures show one embodiment of the present invention, in which Fig. 1 is a perspective view showing its external appearance, Fig. 2 is a front view showing the keyboard, Fig. 3 is a block diagram showing the circuit configuration,
FIG. 4 is an explanatory diagram showing the contents of the RAM, FIG. 5 is an explanatory diagram showing the contents of the tab data memory, FIG. 6 is a flowchart showing the main routine, FIG. 7 is a flowchart showing the program mode processing routine, Fig. 8 is a flowchart showing the execution key processing routine, Fig. 9 is a flowchart showing the date key processing routine, Fig. 10 is a perspective view showing a part of the printer, and Fig. 11 shows the operation in automatic mode and its operation. Sample tabulation sheet showing printing examples, No. 1
Figure 2 is a tabulation sheet sample showing the operation in manual mode and its printing example, Figure 13 a and b are 1
This is a sample tabulation sheet showing operations in column mode and examples of their printing. 11...Number key, 12...Function key, 13...Mode change switch, 21...
CPU, 24...ROM, 27...Number buffer memory, 29...Function code buffer memory, 32a to 32h...Tab data memory, 4
0...Function code memory.

Claims (1)

[Claims] 1. A numeric key, an execution key, other function keys, a numeric buffer memory that stores numeric data input by operating the numeric key, and a numeric buffer memory that stores numeric data input by operating the numeric keys, and a func- tion key that corresponds to the function key. a function code memory storing function code data; and a function code buffer storing two or more function code data read from the function code memory by operating the function key. A memory, a tab data memory that stores tab position data and two or more function code data corresponding to the column to be printed, and a mode changeover switch that selectively activates either program mode or automatic mode. When the execution key is pressed while the program mode is activated by this mode changeover switch, the data in the number buffer memory and function code buffer memory are set in the tab data memory, and the When the execution key is pressed while the automatic mode is activated by the mode changeover switch, processing is executed according to one function code data set in the tab data memory, and then the other fan is activated. 1. An electronic spreadsheet calculator comprising: an arithmetic and control device that executes processing according to cushion code data.