JP2536976Y2 - Small computer - Google Patents

Description

[Detailed description of the invention] [Industrial application field] The present invention is a small-sized model that can be placed on a spreadsheet such as a numerical calculation table or ledger, and data input or calculation can be performed while moving on the spreadsheet. Related to electronic computers.

[Outline of the invention]

The present invention relates to a small-sized computer capable of inputting or calculating data while being moved while being placed on a spreadsheet for numerical calculation, and a spreadsheet is provided in a housing having a display unit for displaying a part of the spreadsheet and key input means. It has a pointer for indicating a position on a sheet and a movement detection unit for detecting the amount of movement of the housing in the vertical or horizontal direction, and according to the position information indicated by the pointer and the detected amount of movement. A small electronic calculator for spreadsheets that is displayed at a specified position.

[Conventional technology]

2. Description of the Related Art Conventionally, a large number of calculation software that assumes a spreadsheet screen for spreadsheets has been used in general-purpose personal computers and the like. However, since only a part of the large screen is displayed, the user scrolls the screen while moving the cursor and checks the position on the spreadsheet by comparing it with the form at hand. According to this method, it is often necessary to compare the screen with the form at hand, which is a burden on the operator. As one of the techniques that can contribute to solving such a problem, the applicant of the present invention has proposed a large spreadsheet while displaying a part of a virtual screen for spreadsheet, which was previously proposed in Japanese Utility Model Application Laid-Open No. 1-272640. There is a small computer that can handle sheets.

According to the technique of Japanese Utility Model Application Laid-Open No. 1-72640, a virtual screen of a small electronic computer in which a mechanical XY direction input means using a ball (a so-called mouse or the like) and a display device are integrated and a spreadsheet on a desk are provided. Can be easily overlapped, so that the work of inputting the data on the spreadsheet to the computer while the small computer is placed and moved on the spreadsheet can be easily performed.

However, when the above-mentioned input operation or the like is performed using a small-sized computer of Japanese Utility Model Application Laid-Open No. 1-72640, there is the following problem.

First, when the input document data frame of the reference document is input with one hand and a number is input with the other hand, there is a ball for inputting XY directions on the bottom surface of the housing of the small computer. However, there is a problem that it is difficult to perform an input operation with one hand.

Secondly, there is a method of inputting while indicating the input target data frame of the reference document by using the ruler at the upper end of the small computer, but since the ball on the bottom of the housing moves on the document, the paper such as a ledger is not flat. In the case of documents, the ball may not function well, and furthermore, the contact between the ball and the paper surface may be small, and the paper surface may be soiled.

Third, even if the small computer rotates around the ball and becomes inclined with respect to the numerical table, the display content does not change, so that the virtual screen may not correspond to the form paper.

[Problems to be solved by the invention]

In the present invention, the various problems described in the section of the prior art are solved, and the correspondence of the positional relationship between the display screen of a small computer placed on a spreadsheet such as a form and the spreadsheet surface is not broken. An object of the present invention is to provide a small-sized electronic calculator for spreadsheets that allows easy input.

[Means for solving the problem]

In the present invention, a display unit that displays a part of a virtual screen corresponding to a spreadsheet for spreadsheets, key input means for providing numerical information for the calculation, and a lower surface of a housing having the display unit And a movement detecting unit (for example, having a roller) for detecting a movement of the spreadsheet in a vertical direction or a horizontal direction, provided with a pointer such as a slide lever for pointing a position on the spreadsheet. A small spreadsheet electronic computer displays input data or a calculation result at a position specified by the position information specified by the indicator and the movement amount information detected by the movement detection unit.

[Action]

In the present invention, the movement detection unit provided on the lower surface of the housing of the small computer is not a ball, but has a configuration in which one-dimensional movement in a vertical or horizontal direction is allowed, such as a roller, for example, so that a form or the like can be obtained. Is better seated on the paper surface and the area of contact with the paper surface is increased, so that the detection of the movement amount is accurate and the rotation of the ball in the horizontal plane is eliminated. In addition, the position on the spreadsheet can be indicated by an indicator such as a slide lever, and the reference point of movement can be set, so that the display screen of the small computer and the position of the sheet of the spreadsheet are accurately aligned. Can be done.

〔Example〕

A first embodiment of the present invention will be described with reference to FIG. FIG. 1A is a plan view of a small computer according to the first embodiment placed on a spreadsheet placed on a desk. A housing 1 includes a display element 2 such as a liquid crystal, a keypad ( Key input means) 3, with slide levers 11, 12,
13 and 14 are provided so that the position on the spreadsheet and the position on the display screen can be matched. By pressing the reference set button 15, the movement amount of the housing 1 can be calculated based on the position. FIG. 1 (b) is a front view of the first embodiment, and FIG. 1 (c) is a side view, in which a roller 4 is provided on the bottom surface of the housing 1 and a moving direction and a moving amount are detected by rotation of the roller. Although FIG. 1 shows an example in which the rollers can be moved in the vertical direction of the spreadsheet, the direction of the rollers may be rotated by approximately 90 degrees so that the rollers can be switched between vertical movement and horizontal movement. . The slide levers 12 and 14 designate X and Y coordinates for indicating the point of interest on the display screen, and the slide levers 11 and 13 correspond to X and Y for indicating the point of interest on the spreadsheet. Used to specify coordinates.

FIG. 2 (a) is a diagram showing the definition of the position dimensions related to the position setting of the slide levers 11, 12, 13, and 14 of the small computer of the first embodiment. The coordinates can be expressed in, for example, millimeters (mm) with the downward direction (X direction) and the right direction (Y direction) being positive with reference to the upper left end of the figure. Here, the movement amount of the slide lever 11 from the uppermost position is p1
And the amount of movement of the slide lever 12 from the topmost position
Let p2 be the amount of movement of the slide lever 13 from the leftmost position, and p3 the amount of movement of the slide lever 14 from the leftmost position. Further, the distance between the uppermost position of the slide lever 11 and the uppermost position of the slide lever 12 is represented by o1.
The distance between the leftmost position of the slide lever 13 and the leftmost position of the slide lever 14 is defined as o2. Further, the distance between the leftmost position of the slide lever 13 and the left end of the housing is represented by o0, and the total amount of movement in the X direction due to the rotation of the roller 4 is represented by r. With this definition, the coordinates on the spreadsheet and the coordinates on the display screen can be expressed as a function of the position of the slide lever, and the two can be matched. For example, the coordinates on the spreadsheet indicated by the slide levers 11 and 13 are the coordinates x = r + p in the X direction.
1. Coordinates in the Y direction can be represented by y = o0 + p3. Then, if the uppermost end (reference point) of the housing is set to a predetermined position on the spreadsheet and the reference set button 15 is pressed, the position is set to zero, and the respective slide lever positions and the cursor positions on the display screen are calculated. As shown in FIG. 2 (b), the size of the data display frame (entry frame) of the spreadsheet is w in the X direction and h in the Y direction.

Next, assuming a list of division coordinates of the data entry frame of the spreadsheet, the vertical division list is represented as xlist, and the horizontal division list is represented as ylist. The number of vertical division coordinates (maximum value of vertical division number) is expressed as maxx, and the number of horizontal division coordinates (maximum value of horizontal division number) is expressed as maxy. Also, the operated data list is represented as dlist.

An example of the operation of the small-sized computer according to the present invention will be described with reference to the flowcharts of FIGS. 3 and 4 which have been defined and written.

First, FIG. 3 is a flowchart showing the operation when storing input data. In step S1, when the coordinates x, y of the data input target position on the spreadsheet and the operated data data from the keypad 3 are input by the slide levers 11, 13 and the roller 4, first, the vertical division number is set. Do the work you want. In step S2, the variable of the vertical division number is set to i, and first, i = 0. Next, in step S3, 1 is added to i, and in step S4, it is determined whether or not i ≦ maxx. For example, when there is an existing vertical division list and i ≦ maxx, the process proceeds to step S5, and when a new vertical division list is created or i exceeds the maximum value of the existing vertical division number, i> maxx If, the process proceeds to step S7.

In step S5, it is determined whether or not the input coordinate x is within an error range (for example, within 0.5 mm of the positive / negative value) with the i-th coordinate xlist [i] of the existing vertical division list. Is regarded as the data frame and the process proceeds to step S9. If not within the error range, the process proceeds to step S6, where x <
It is determined whether or not xlist [i], and x is xlist [i].
If it is larger, the process returns to step S3 and repeats the steps from step S3. If x is smaller than xlist [i], the process proceeds to step S7.

When the process proceeds from step S4 or step S6 to step S7, it is interpreted as a new data frame that does not correspond to the data frame of the existing vertical division list, and generation (eg, addition, insertion, etc.) of a new data frame is performed. Do. When a new data frame is generated in step S7, the size minw of the data frame in the X direction is calculated in step S8, and the process proceeds to step S9. In step S9, the data frame (vertical division) number i at the position designated by the cursor is given.

Although not shown, the variable of the horizontal division number is j,
By performing the same operation from step S2 to step S9 in order from j = 0, the data frame (horizontal division) number at the position designated by the cursor is given to i. Then, in step S10, the data to be processed is stored in a data frame dlist [i, j] given by i and j of the data to be processed.
data is stored.

By repeating the operation described above with reference to FIG. 3 for each change in the coordinates x and y on the spreadsheet, the data on the spreadsheet can be stored in the small computer as a data list dlist to be operated on.

FIG. 4 is a flowchart showing the operation when the stored data is displayed on the display element 2.

First, in step S11, i = 1 and j = 1, and in step S12, it is determined whether or not j ≦ maxy. If j ≦ maxy, in step S13, i ≦ maxy
It is determined whether it is x. If i ≦ maxx, in step S14, the coordinates dx, dy of the display position in the display element 2 are calculated from the vertical division number i and the horizontal division number j of the data frame to be displayed. Next, in step S15, the size of the character is selected so as to fit in the (vertical minw × horizontal minh) size frame calculated in the flowchart of FIG.
The value of the data list dlist [i, j] to be operated is displayed at the position of dx, dy. Next, in step S16, i is incremented by 1, and the process returns to step S13 to repeat the steps from step S13. If i> maxx is satisfied in step S13, 1 is added to j in step S17, and the process returns to step S12 to repeat the steps from step S12. Further, if j> maxy is satisfied in step S12, the display operation ends.

The display operation shown in FIG. 4 is performed whenever the roller 4 or the slide levers 11, 12, 13, and 14 move.

When the input results and the calculation results are displayed on the screen, the horizontal title on the spreadsheet and the corresponding data frame on the display screen completely match when the slide levers 11 and 12 are combined as shown in FIG. Slide lever 13 to 9
If the slide lever 14 is arranged near the horizontal title according to the month, the horizontal title and the data of September can be viewed side by side.

Next, a second embodiment of the present invention will be described with reference to FIG. In the second embodiment, the display screen is enlarged horizontally to make it easier to view the table, and the keypad is rotatable by 90 degrees so that it can be used vertically or horizontally. The screen display is switched by detecting the direction of the keypad. FIG. 6C is an enlarged view showing a configuration example of the slide lever.

For example, when inputting in order to post from a form,
By aligning the upper end of the housing with the specified column of the form to be referred to, and shifting the housing down each time one item is input, the data frame of the form and the data frame of the display screen can be directly associated with each other. The user's eyes move less and the input result can be easily confirmed. Of course, the data input to the small computer of the embodiment of the present invention can be transferred to a host computer for processing.

FIG. 7 is a diagram of a third embodiment of the present invention. this is,
This is an embodiment in which the display screen is made smaller and the slide levers 11, 12, and 14 are fixed so as to simplify and reduce the size.

In the above embodiment, an example is shown in which the variation of the rotation of the roller is integrated in order to detect the movement of the casing in, for example, the X direction. However, as long as a spreadsheet with ruled lines in both the vertical and horizontal directions is used, If the optical sensor detects the ruled line, the accumulated error can be reduced.

[Effect of the invention]

With the implementation of the present invention, the work of inputting data of an arbitrary point of interest while displaying a part of the data on a spreadsheet for spreadsheet according to the grid (data frame) of the spreadsheet and the display of the calculation result can be performed. A small computer which can be easily and stably performed on paper is obtained.

As a result, there is an effect that it is possible to prevent fatigue caused by working while comparing the display screen of the display device of a general OA device with the sheet of paper at hand.

[Brief description of the drawings]

FIG. 1 is a view of a first embodiment of the present invention, wherein (a) is a plan view when placed on a spreadsheet, (b) is a front view, and (c) is a side view. FIGS. 2A and 2B are diagrams showing the definition of the position dimensions of the first embodiment, FIG. 2A is a diagram showing the definition of the dimensions of the slide lever position, and FIG. 2B is a diagram showing a data display frame of the spreadsheet. FIG. 3 is a flowchart for storing input data. FIG. 4 is a storage data display flowchart. FIG. 5 is an example of data display in the first embodiment. 6A and 6B are views of a second embodiment of the present invention, wherein FIG. 6A is a plan view when placed on a spreadsheet, FIG. 6B is a side view, and FIG. 6C is an enlarged view of a slide lever. FIG. 7 is a diagram of a third embodiment of the present invention. DESCRIPTION OF SYMBOLS 1 ... Housing 2 ... Display element 3 ... Keypad (key input means) 4 ... Roller (movement detection part) 11 ... Slide lever (paper position indicator) 12 ... Slide lever (display position indicator) 13) Slide lever (page position indicator) 14 Slide lever (display position indicator) 15 Reference set button 21 Cursor

Claims (1)

(57) [Scope of request for utility model registration] 1. A display unit for displaying a part of a virtual screen corresponding to a spreadsheet for spreadsheets, key input means for providing numerical information for the calculation, and a display unit provided on a lower surface of the housing. And a movement detecting unit for detecting a vertical or horizontal movement of the spreadsheet provided, and an indicator for indicating a position on the spreadsheet is provided on the housing, and is indicated by the indicator. A small computer configured to display input data or a calculation result at a position designated by position information and movement amount information detected by the movement detection unit.