JP3089712U - Device for creating diary software - Google Patents

Abstract

(57) [Summary] [Problem] To provide a diary software which is easy to use and easy to make on its own, and an apparatus for creating a macro for creating diary software. SOLUTION: A general-purpose spreadsheet software or a general-purpose database software is incorporated in a personal computer. In a state where the general-purpose spreadsheet software or the general-purpose database software is started, a user command provided in the software is used. Along with arranging a plurality of rectangular unit areas vertically and horizontally on the worksheet with a blank cell row interposed between adjacent areas, and allocating each of the rectangular unit areas arranged in a row horizontally to different dates of the same year, By performing an operation of sequentially allocating the rectangular unit areas arranged in a line vertically to the same month and date of another year, diary software or a macro for diary software creation is created.

Description

[Detailed description of the invention]

[0001]

[Technical field to which the invention belongs]

 The present invention relates to a diary software for displaying a diary on a personal computer screen, and more particularly to a diary software that is easy to use and easy to make.

[0002]

[Prior art]

 Keeping a daily record, such as a diary, on a regular basis has long been evaluated as useful for organizing memories and thinking. Diary recording methods (recording media) include the most common recording on paper media (the use of a so-called diary), and the recording using personal computer word processing software that has developed in recent years.

[0003]

[Problems to be solved by the invention]

 However, when a paper medium such as a diary is used as a diary recording medium, the key of the diary or the like can be easily destroyed, so the confidentiality is not sufficient, and most of the recording media for more than ten years can be recorded. And the information recording capacity is small. In addition, there is a problem that it is difficult to search for information to search.

On the other hand, when word processing software or the like is used, the problem that the capacity is small is solved, but there is a problem that the data expands in a band and is difficult to read.

The present invention has been made in view of the above-mentioned problems, and a purpose thereof is to provide a diary software that is easy to use and easy to make.

Another object of the present invention is to provide a diary software which has good confidentiality and can store a long-term record.

It is another object of the present invention to provide a diary software which makes it easy to search for data on a predetermined date and can display diaries for a plurality of years on one screen.

[0008] Other objects and operational effects of the present invention will be easily understood by those skilled in the art by referring to the following description.

[0009]

[Means for Solving the Problems]

 In order to achieve the above object, the diary software of the present invention uses a user command provided with the general-purpose spreadsheet software or general-purpose database software in a state where the general-purpose spreadsheet software or the general-purpose database software has been started. A plurality of rectangular unit areas are arranged vertically and horizontally with a blank cell row intervening between adjacent areas, and each of the rectangular unit areas arranged in a horizontal row is sequentially assigned to different days of the same year, The rectangular unit areas arranged in the above are sequentially allocated to the same month and day of another year.

According to such a configuration, the diary software is configured using general-purpose spreadsheet software or general-purpose database software. The advantage of can be fully utilized.

For example, by locking the diary software (or recording file) with a password, it is possible to prevent others from browsing with high confidentiality. Also, unlike the paper diary, the information recording capacity is large, so it is possible to store records for several decades. In addition, since the diary entry fields for multiple days are arranged on the worksheet so that they can be seen at a glance, the records of the same day in the previous year and the records several days before the same year can be easily checked.

[0012] In addition, since the diary is an electronic diary, it is easy to incorporate image data such as photographs into the diary. The digital image data is very preferable as a recording format because unlike a conventional silver lead photograph, it does not deteriorate over time and the images can be easily reused and redistributed.

[0013] The rectangular unit area is further divided into nine small areas by dividing into three vertical rows by three horizontal rows along the vertical frame line, and is divided into nine small areas. In the item description area, each of the eight peripheral small areas surrounding the central small area may be assigned to the specific item description area.

Here, the “frame line” is a dividing line between cells. The “cell” is the minimum unit cell for data entry in spreadsheet software and database software.

According to such a configuration, the diary entry field is divided into nine small areas, and the central small area is a common matter description area. Is set to be recorded in the central common item description area, information can be easily checked.

In a preferred embodiment of the present invention, in the central small area, date information unique to the small area may be described in a fixed mode.

According to such a configuration, since the unique date information is described in the fixed mode, when the common matter other than the date information is entered in the central small area, the date is erroneously entered. Errors such as deleting or changing the date information are unlikely to occur.

In another preferred embodiment of the present invention, an item title entry field is defined at the top of each of the peripheral small areas, and the corresponding item letter is described in a fixed mode in the item title entry field. It may be.

According to such a configuration, when writing is performed in the eight peripheral small areas surrounding the central small area, the problem of changing or erasing the item title hardly occurs.

In the diary software of the present invention, when the general-purpose spreadsheet software or the general-purpose database software is started, the following programming procedures (a) to (d) are performed by using a command provided in the software. It is characterized by being created including. (A) A step of selecting, on a worksheet, a rectangular area for one day including at least six or more cells in the vertical direction and three or more cells in the horizontal direction using the range setting command. (B) Using a ruled line command, outline the outline of the rectangular area for one day, and divide the inside into three vertical rows along the horizontal frame line and three horizontal columns along the vertical frame line. Forming 9 small areas by using (C) Using a ruled line command, a title description column is formed by partitioning the upper part of each of the small regions along a horizontal frame line, and the title description column of the central small region has a title description column unique to the small region. A step of describing in a fixed mode a title specific to the small area in the title entry column of the date and the surrounding small areas surrounding the date. (D) using the fill command to copy the one-day diary area created in (a) to (c) onto the worksheet for the required number of days in the horizontal direction and the required number of years in the vertical direction.

According to such a configuration, it is possible to obtain diary software that is easy to use and makes it easy to check the contents of the description retroactively over the past several years.

The macro for creating the diary software of the present invention uses the following programming procedures (a) to () using commands provided in the general-purpose spreadsheet software or the general-purpose database software in a state where the software is started. d) is stored in a series. (A) A step of selecting, on a worksheet, a rectangular area for one day including at least six or more cells in the vertical direction and three or more cells in the horizontal direction using the range setting command. (B) Using a ruled line command, outline the outline of the rectangular area for one day, and divide the inside into three vertical rows along the horizontal frame line and three horizontal columns along the vertical frame line. Forming 9 small areas by using (C) Using a ruled line command, a title description column is formed by partitioning the upper part of each of the small regions along a horizontal frame line, and the title description column of the central small region has a title description column unique to the small region. A step of describing in a fixed mode a title specific to the small area in the title entry column of the date and the surrounding small areas surrounding the date. (D) using the fill command to copy the one-day diary area created in (a) to (c) onto the worksheet for the required number of days in the horizontal direction and the required number of years in the vertical direction.

Here, the “macro” is a function for automating scanning of application software, and is installed in spreadsheet software, word processing software, or the like.

According to such a configuration, it is possible to obtain a macro for creating diary software that is easy to use and easy to check the contents of description back to the past several years. Also, since the diary software according to the present invention is provided as a macro of general-purpose spreadsheet software or general-purpose database software, the program portion of the diary software itself is small in capacity, and the load on personal computers is small.

[0025]

[Embodiment of the invention]

 Hereinafter, a preferred embodiment of the present invention will be described in detail with reference to the accompanying drawings.

As described above, the diary software according to the present invention starts the general-purpose spreadsheet software or the general-purpose database software, and uses a user command provided in the software to execute the worksheet. A plurality of rectangular unit areas are arranged vertically and horizontally with a blank cell row interposed between adjacent areas, and each of the rectangular unit areas arranged in a horizontal row is sequentially assigned to different days of the same year, The rectangular unit areas arranged in a line are allocated in order on the same month and day of another year.

As described above, the diary software according to the present invention is desirably provided as a macro of general-purpose spreadsheet software or general-purpose database software. FIG. 1 shows an example of a configuration of one day of a diary sheet created using the diary software according to the present invention. In the figure, 1 is a unit frame (one day entry column), 2a to 2h are title columns, 3a to 3h are text columns, and 4a to 4d are basic data columns.

In this example, 2a “political activities”, 2b “people”, 2c “human education”, 2d “money / things”, 2e “hobbies”, 2f “food” , 2g "Health & sex", 2h "Family", and the contents corresponding to each title are entered in the corresponding text boxes 3a to 3h. In addition, since it is based on general-purpose spreadsheet software or general-purpose database software, when information exceeding the display limit of the entry columns 3a to 3h is entered, the sentence column 3 with a large amount of information is automatically enlarged. It is also possible to adopt a configuration in which a normal text is displayed to the extent that it can be displayed (that is, the text can be displayed halfway) and a full text can be displayed by selecting a predetermined location.

In this example, the basic data columns 4a to 4d include 4a “2002, 38 years old, 2002”, 4b “April 15”, 4c “what day”, “anniversary”, “birth date”, respectively. "The anniversary", 4d "Weather", "Get up", "Bed", "Physical condition". In this example, the basic data column 4a contains the year data and the age of the creator, the basic data column 4b contains the date data, the basic data column 4c contains the anniversary data, and the basic data column 4d contains the current day data. It is configured to be.

In the present invention, since the same day data of the previous year is arranged in a column on the same sheet in order, the data of the anniversary and the like can be easily checked by checking the basic data column 4c of the same day of the previous year. . In addition, a function may be formed so that the contents written in the basic data column 4c are reflected on the same day in the next year and thereafter.

The contents to be entered in the title columns 2a to 2h and the basic data columns 4a to 4d can be set as appropriate according to the preference of each person. Similarly, the balance between the aspect ratio of the unit frame 1 and the size of each column can be set as appropriate.

The frame 1, which is a recording field for one day described above, is displayed side by side on a work sheet in a grid pattern. FIG. 2 shows an example of the overall configuration of such a diary sheet according to the present invention. In this example, the horizontal axis indicates the date, and the vertical axis indicates the year, so that frames of consecutive dates of the same year in the horizontal direction and frames of the same day of consecutive years in the vertical direction are arranged side by side.

For example, if the uppermost leftmost frame 1a1 is a diary of “January 1, 2000”, the frame 1b1 arranged on the right side is a diary of “January 2, 2000”. "January 3, 2000", "January 4, 2000" ... "December 31, 2000" are sequentially arranged in the right direction. Further, in the vertical direction, the frame 1a2 is a diary of "January 1, 2001", the frame 1a3 is a diary of "January 1, 2002", and so on, "January 1, 2003", "January 2004". 1 day ”.

With this configuration, the same day several years ago can be seen at a glance, and the basic data columns 4a to 4d of the same day of the previous year or two years before can be easily referred to. This is almost impossible with conventional paper diaries or diaries using word processing software.

Further, by utilizing the magnification adjustment function (zoom function) of general-purpose spreadsheet software or general-purpose database software, when opening a file (starting a program), the file is displayed in a reduced size as shown in FIG. May be configured to be displayed enlarged (the state of FIG. 1). The frame of the corresponding date may be enlarged and displayed by referring to the clock information of the personal computer at startup.

When the whole is displayed in reduced size, the date column (or basic data column) is displayed large even at the time of reduction so that the frame of a predetermined date can be easily searched. When the mouse pointer is put on the frame, the date is displayed. A configuration such as pop-up display is also conceivable.

In the above description, an example is shown in which the frame 1 for 365 days (or 366 days) is arranged on the horizontal axis, and data for several decades is written on one sheet. The number of days can be composed of six months, one month, half month, one week, and so on. In this case, the data capacity per sheet becomes lighter, but there is also the aspect that it is necessary to open another file or sheet when referring to a diary at a distant time. In consideration of the above points, the number of frames arranged in the horizontal direction per sheet is preferably about 15 to 30 (that is, a diary for half a month to January).

In this example, the horizontal axis is configured so that the number of days advances from left to right (the number of days is added), and the vertical axis is configured such that the year advances from top to bottom (the number of years is added). However, the parameters of the vertical and horizontal axes can be changed according to the preference of the entrant (the vertical axis is the number of days and the horizontal axis is the number of years). It may be configured.

Next, an example of a specific procedure for starting the present invention software and creating the diary sheet described with reference to FIGS. 1 and 2 will be described below. The procedure described below is an example of the case where the present invention is implemented using Microsoft Excel 2000 (a product name of spreadsheet software of Microsoft Corporation).

First, the program is started and a new worksheet is opened. Select a cell at an appropriate location on this worksheet with the left mouse button and drag it while holding down the left mouse button to select an appropriate area (see Fig. 3). Since an area having a size of 6 squares by 3 squares is created by a later operation, the range is selected with a minimum of 6 rows by 3 columns or more. (In the figure, 24 rows by 6 columns are selected.) Since the vertical and horizontal widths of each column can be changed as appropriate, the title column can be adjusted by adjusting the width of some columns or rows. Although it is possible to adjust the size of 2 and the text column 3, in order to simplify the operation, the size of each column is controlled by the number of rows and the number of columns in this example. For this reason, it is preferable to select the range of the number of rows by a multiple of 6 and the number of columns by a multiple of 3 in consideration of the appearance balance in the completed state.

While the color of the selected range is inverted (different from the background color), left-click the down arrow on the right end of the [Rule] button on the toolbar arranged at the top of the screen. Left-click the down arrow to display a list of available ruled line patterns. From the displayed ruled line pattern, select the [outer frame] ruled line that surrounds the four sides of the selected range and left-click to select the [outer frame] ruled line (similar to the pattern) around the selected range. (See FIG. 4).

If the ruled line pattern displayed on the [ruled line] button on the toolbar is the pattern to be used (in this case, [outer frame] ruled line), simply press the [ruled line] button to select [ Since the [Outer Frame] rule is added, there is no need to press the down arrow on the right end of the [Rule] button and select from the displayed patterns.

Next, a process of dividing the selection range separated from the other area by the outer frame into sections of 3 rows × 3 columns using ruled lines is performed.

First, the entire range (area Z1 in FIG. 5) of two columns from the left end of the selection range delimited by the outer frame is selected, and [Outer frame] or [Right ruled line] in the ruled line menu is used. To surround the perimeter of the selection. By the same operation, the center two rows (area Z2 in FIG. 5) and the right end two rows (area Z3 in FIG. 5) also surround the outer periphery. When dividing in the vertical direction, it is easier to process by using [Outer frame], [Right rule], [Left rule], etc. in the ruled line menu.

At this time, an area divided by left and right frame lines (l1 and l2) and two vertical lines (l3 and l4), that is, an area (Z1) surrounded by upper and lower frame lines and l1 and l2, The upper and lower frame lines and the area (Z2) surrounded by l2 and l3, and the upper and lower frame lines and the area (Z3) surrounded by l3 and l4 may be different sizes, respectively. Someone has a better balance of appearance. Similarly, the arrangement of the upper and lower frame lines and the two horizontal lines may not be equally spaced, but the equal spacing provides better visual balance (see FIG. 5).

Next, a process of similarly dividing into three horizontal rows is performed. If you want to separate horizontally, after selecting the area, press the [Border] button on the toolbar and select one of “Outer Border”, “Bottom Border”, or “Upper Border + Bottom Border” from the displayed Border menu. (See Figure 6).

In this example, two vertical lines are divided into three vertical columns and then two horizontal lines are divided into three horizontal lines. However, even if the order is reversed, there is no problem. Absent. If the same appearance as when the ruled line menu is used can be obtained, the area may be similarly divided using functions other than the ruled line.

After the area divided by the outer frame is divided into nine small areas, the center section is determined by using one of [Outer frame], [Lower ruled line], and [Upper ruled line + Lower ruled line] in the ruled line menu. To separate multiple lines. In this example, it is divided into eight lines using seven horizontal lines (see FIG. 7).

The eight small areas surrounding the center section are divided into a title section (2a to 2h) and a text section (3a to 3h). In this example, the title column has one vertical line and the text column has seven vertical lines (see FIG. 7).

With the above operation, the area surrounded by the outer frame is divided using the ruled lines into the title columns 2a to 2h, the text columns 3a to 3h, and the basic data columns 4a to 4d. However, since the range surrounded by the ruled line is merely a collection of disjointed cells by this alone, next, the cells are combined for each region (divided range) to form a single region.

More specifically, a plurality of cells are combined by dragging 14 cells constituting the text entry field 3a to select a range, and pressing a [merge and align cells] button on the toolbar. Into one cell (see FIG. 8). In the same way, for the area delimited by other ruled lines, select multiple cells in the range delimited by the ruled line by dragging. → Repeat the operation of pressing the [Combine and Center] button on the toolbar. Then, the cell combining process is repeated (see FIG. 9).

[Cell Formatting] displayed by dragging and selecting the cells to be merged without using the [Combine and Center Cells] button on the toolbar, and pressing the [Format] button on the toolbar Select and press the [Cell] button from the menu. The same effect can be obtained by selecting the [Merge cells] check box in the [Arrangement] tab of the [Cell formatting] menu that is displayed. The [Cell Formatting] menu can also be displayed by right-clicking on a selected area and pressing the [Cell Formatting] button from the displayed menu.

When the same operation is repeated like this cell merging operation, a predetermined operation is performed only once (in this case, the [merge cell and align center] button is pressed). It is also possible to perform continuous processing by pressing the [Edit] button on the toolbar, pressing the [Repeat] button that is displayed, or repeating a predetermined operation using a shortcut key.

Specifically, after the cell merging process is performed once, the range can be selected by dragging and then the [Repeat] button is pressed (or the shortcut key for instructing the [Repeat] process is pressed), thereby making it easier. Can be repeated. The same [Repeat] button and shortcut key can be used for the same process in succession (repetition).

Although a plurality of cells are combined for each area by the above operation, the display position and the like of the character when the character is written are inappropriate as it is. For this reason, the following operation sets the character layout.

Select the text entry field 3a by right-clicking and select [Format cell] from the displayed menu. Click the [Alignment] tab in the displayed [Cell Format] menu, select [Standard] from the [Horizontal] selection menu in the [Character alignment] column, and similarly select [Vertical]. Select [Top] from the menu. Also, turn on the [wrap around and display entire] check box in the [Character Control] menu. Set the format in the other text fields 3b to 3h in the same manner (you may right-click to display the [Cell Format] menu and make the settings in sequence, but the [Repeat] button or shortcut key May be used).

Thus, when a sentence is entered in the sentence column 3a, the sentence is displayed in order from left to right at the top of the column, and when the right end is reached, the sentence is successively carried over to the next row, so that the sentence is displayed in a legible manner. (See FIG. 11).

Next, the title column 2 a is selected by right-clicking, and “Format cell setting” is selected from the displayed menu. From the displayed [Cell Format] menu, click the [Alignment] tab. In the [Text Arrangement] menu, set [Horizontal] to [Center] and [Vertical] to [Center]. . The [Character Control] menu does not need to be changed, but the [Reduce and Display Entirely] check box may be turned ON in consideration of the case where the title becomes long. Set the format for the other title fields 2b to 2h in the same way (you can display the [Cell Format] menu by right-clicking and make the settings in sequence, but you can use the [Repeat] button or the shortcut key as described above). May be used).

Thus, when the title corresponding to the sentence column 3a is entered in the title column 2a, the title is arranged in the center of the title column 2a in a well-balanced manner, and the title is too long to fit in the title column 2a. However, the characters in the title column 2a are automatically reduced and displayed, so that the entire title can be read.

Next, the format of the basic data columns 4 a to 4 d will be described. For the basic data columns 4a and 4b, display the [Cell Format] menu by one of the methods described above, set [Horizontal Position] in the [Character Arrangement] menu to [Center], and select [Vertical Position]. Is [centered]. The [Character Control] menu does not need to be changed. However, in consideration of the case where the title becomes longer, the [Reduce and Display Entirely] check box or [Wrap and Display Entirely] is selected. Any of the check boxes may be turned on.

For the basic data fields 4c and 4d, display the [Cell Format] menu by any of the methods described above, and set [Horizontal Position] in the [Character Arrangement] menu to [Standard] or [Center] and [Vertical Position] are [Center]. The [Character Control] menu does not need to be changed. However, in consideration of the case where the title becomes long, the [Reduce and display the whole] check box or the [Wrap and display the whole] check box is selected. Any of the boxes may be turned on.

Next, a desired color is given to each column according to preference, and the appearance is adjusted. As a specific operation, select a cell to which a color is to be assigned (for example, the title entry field 2a), and left-click the down arrow on the right end of the [fill color] button on the toolbar. Left-click on the down arrow to see a list of available fill colors. From the displayed list of fill colors, select a preferred color to fill the selected range, and left-click to fill the selected range with the specified color. You can also perform the same process by right-clicking the cell to which you want to add a color, selecting [Format cell] from the menu that appears, and selecting the [Pattern] tab.

If the color displayed on the surface of the “fill color” button on the toolbar is the color to be used, the user only needs to press the “fill color” button. You do not need to press the down arrow on the right end of the button to select from the displayed colors.

The title fields 2a to 2h, the text entry fields 3a to 3h, and the data fields 4a to 4d are visually attractive and easy to see if they are given different colors. In this example, the title columns 2a to 2h are pale colors, the text entry columns 3a to 3h are colorless (white or ground color), and the data columns 4a, 4c, and 4d are slightly darker colors than the title columns 2a to 2h. The data column 4b is set to a darker color than the data columns 4a, 4c and 4d.

It should be noted that the color assignment processing may be performed on each column immediately after the cell combination processing, or may be performed after the subsequent processing (the order in which the color assignment processing is performed is not particularly specified). .

Further, processing may be performed such that the data in the title columns 2 a to 2 h and the data in the basic data columns 4 a and 4 b are fixed and cannot be changed in accordance with the color assignment. This processing may also be performed at another time as in the case of color application.

With the above operation, the frame 1 as an entry column for one day is completed. Next, a process of creating a predetermined number of copies of the frame 1 in the horizontal and vertical directions will be described.

First, the upper end and the left and right widths are set to match the frame 1, and the lower end is subjected to range selection including the lower two lines of the lower frame of the frame 1 (see FIG. 12). The reason why the width is selected to be wider than the outer frame of frame 1 is to provide an appropriate interval between frames when copying is performed so that the frame can be easily viewed.

Next, place the mouse pointer on a black square called “fill handle” displayed at the lower right corner of the selection range (the cursor changes from a white cross with a thick and short side to a thin and long side It changes to a black cross). With the mouse pointer on the file handle 10, right-click and drag downward (see Fig. 13). When the user drags downward, the scheduled copy area 10a is displayed surrounded by a dotted line, and the user can see at a glance how far the area is to be copied. After dragging the appropriate amount and releasing the right-click, a shortcut menu for the fill operation is displayed. By selecting [Continuous Data (Yearly)] from the shortcut menu and left-clicking, frames 1a2 to 1a4 for the same day in the consecutive years in the lower row are completed (see FIG. 14).

In FIG. 14, when the date “(2002) April 15” is displayed in the 4b column of the frame 1a1 (the parentheses are not displayed), the data of the frame 1a1 is continuously displayed on a yearly basis. In the 4b column of the frames 1a2 to 1a4 copied in such a manner, the date of April 15 of each successive year is registered. That is, "(2005) April 15" is displayed in the 4b column of the frame 1a2, "(2004) April 15" is displayed in the 4b column of the frame 1a3, and "(2005) is displayed in the 4b column of the frame 1a4. Year) April 15 "is registered.

Next, a procedure for copying in the horizontal direction with reference to 1a1 will be described. As in the case of copying in the downward direction, the left end and the upper and lower widths are selected according to the size of the frame 1a1, and the right end is selected including the right column of the right frame of the frame 1a1. This is because, as described above, after copying, an appropriate space is provided between frames to make it easier to see the entire screen. Next, right-click and drag the fill handle 10 displayed at the lower right corner of the selection range to the right (see FIG. 15). After dragging an appropriate amount to the right, release the right-click, select [Continuous Data (daily)] from the displayed shortcut menu for the fill process, and left-click. Thus, frames 1b1 to 1d1 having continuous date data of the same year in the right direction are completed (see FIG. 16).

In FIG. 16, when the date “(2002) April 15” is displayed in the column 4b of the frame 1a1 (not shown in parentheses), the data of the frame 1a1 is continuously displayed on a yearly basis. In the 4b column of the frames 1b1 to 1d1 copied so as to become, consecutive dates after April 15 of the same year are registered, respectively. That is, "(2002) April 16" is in the 4b column of frame 1b1, "(2002) April 17" is in the 4b column of frame 1c1, and "(2002) is in the 4b column of frame 1d1. The date "April 18" is registered.

By continuously performing the above-described copy processing, a diary worksheet in which the frames 1 are laid out in a grid pattern is completed (see FIG. 17). Although an example has been described in which copying is performed in the vertical direction and then in the horizontal direction, the order may be reversed, or a plurality of columns may be processed collectively. In addition, the setting of the continuous number may be performed using a fill menu or may be changed manually.

The procedure for creating the diary worksheet described above is an example, and the command used may be changed or the procedure may be changed.

The macro for creating a diary according to the present invention may be sold as a set of programs corresponding to a plurality of spreadsheet software and database software, and may be individually set for each corresponding spreadsheet software and database software. May be sold.

[0076]

[Effect of the invention]

 As is apparent from the above description, the diary software and the macro for creating diary software of the present invention make it easy to create a diary worksheet that is easy to use and excellent in appearance.

Also, the entry column for one day is divided into nine, basic data such as date is provided in the center entry column, and title fields are provided in eight peripheral small areas, and different contents are written. With this configuration, you do not have to worry about the contents you write when writing your diary, and you can easily find what you want to look for later when you read your diary again.

Further, since it is an electronic medium diary, it is easy to incorporate digital image data such as photographs into the diary, and there is no deterioration of the image and excellent storability.

[Submission date] April 25, 2002 (2002. 4.25)

[Procedure amendment 1]

[Document name to be amended] Statement

[Correction target item name] Full text

[Correction method] Change

[Correction contents] [Detailed description of the invention]

[0001]

[Technical field to which the invention belongs]

 The present invention relates to an apparatus for creating diary software that allows a diary to appear on the screen of a personal computer.

[0002]

[Prior art]

 Keeping a daily record, such as a diary, on a regular basis has long been evaluated as useful for organizing memories and thinking. Diary recording methods (recording media) include the most common recording on paper media (the use of a so-called diary), and the recording using personal computer word processing software that has developed in recent years.

[0003]

[Problems to be solved by the invention]

 However, when a paper medium such as a diary is used as a diary recording medium, the key of the diary or the like can be easily destroyed, so the confidentiality is not sufficient, and most of the recording media for more than ten years can be recorded. And the information recording capacity is small. In addition, there is a problem that it is difficult to search for information to search.

On the other hand, when word processing software or the like is used, the problem that the capacity is small is solved, but there is a problem that the data expands in a band and is difficult to read.

The present invention has been made in view of the above-mentioned problems, and an object of the present invention is to provide an apparatus for creating easy-to-use diary software.

Another object of the present invention is to provide an apparatus for creating diary software which has good confidentiality and can store a long-term record. .

Another object of the present invention is to provide an apparatus for creating diary software which makes it easy to search for data on a predetermined date and can display diaries for a plurality of years on one screen. It is in.

[0008] Other objects and operational effects of the present invention will be easily understood by those skilled in the art by referring to the following description.

[0009]

[Means for Solving the Problems]

 In order to achieve the above objectives, the diary software creation device of the present invention incorporates general-purpose spreadsheet software or general-purpose database software into a personal computer, and launched general-purpose spreadsheet software or general-purpose database software. In this state, using the user commands provided with the software, rectangular unit areas are arranged vertically and horizontally on the worksheet with blank cell rows interposed between adjacent areas, and are arranged in a horizontal line. The diary software is created by assigning each of the rectangular unit areas in turn to the same month on the same month in the same year, and assigning the rectangular unit areas arranged in a vertical line to the same month on the same year in the same year. It is characterized by the following.

[0010] According to such a configuration, since the diary software is created using general-purpose spreadsheet software or general-purpose database software, operability is improved using general-purpose spreadsheet software or general-purpose database software. Good diary software can be created.

For example, by locking the diary software (or recording file) with a password, it is possible to prevent others from browsing with high confidentiality. Also, unlike the paper diary, the information recording capacity is large, so it is possible to store records for several decades. In addition, since the diary entry fields for multiple days are arranged on the worksheet so that they can be seen at a glance, the records of the same day in the previous year and the records several days before the same year can be easily checked.

The rectangular unit area is further divided into nine small areas by being divided into three vertical rows by three horizontal rows along a vertical frame line, and divided into nine small areas. In the item description area, each of the eight peripheral small areas surrounding the central small area may be assigned to the specific item description area.

Here, the “frame line” is a dividing line between each cell. The “cell” is the minimum unit cell for data entry in spreadsheet software and database software.

According to such a configuration, the diary entry field is divided into nine small areas, and the central small area is a common matter description area. Is set to be recorded in the central common item description area, it is easy to confirm information.

In a preferred embodiment of the present invention, date information unique to the small area may be described in a fixed mode in the central small area.

According to such a configuration, since the unique date information is described in the fixed mode, when the common matter other than the date information is entered in the central small area, the date is erroneously entered. Errors such as deleting or changing the date information are unlikely to occur.

[0017] In another preferred embodiment of the present invention, an item title entry field is defined at the top of each of the peripheral small areas, and the corresponding item text is described in the fixed mode in the item title entry field. It may be.

According to such a configuration, when writing is performed in the eight peripheral small areas surrounding the central small area, the problem of changing or erasing the item title hardly occurs.

Further, the apparatus for creating the diary software according to the present invention uses the commands provided in the general-purpose spreadsheet software or the general-purpose database software in a state where the general-purpose spreadsheet software or the general-purpose database software has been started. By performing the operation including d), diary software is created. (A) A step of selecting, on a worksheet, a rectangular area for one day including at least six or more cells in the vertical direction and three or more cells in the horizontal direction using the range setting command. (B) Using a ruled line command, outline the outline of the rectangular area for one day, and divide the inside into three vertical rows along the horizontal frame line and three horizontal columns along the vertical frame line. Forming 9 small areas by using (C) Using a ruled line command, a title description column is formed by partitioning the upper part of each of the small regions along a horizontal frame line, and the title description column of the central small region has a title description column unique to the small region. A step of describing in a fixed mode a title specific to the small area in the title entry column of the date and the surrounding small areas surrounding the date. (D) using the fill command to copy the one-day diary area created in (a) to (c) onto the worksheet for the required number of days in the horizontal direction and the required number of years in the vertical direction.

According to such a configuration, there is provided an apparatus for creating diary software which is easy to use, and which can easily create diary software which can easily check the contents of contents in the past several years. Obtainable.

The apparatus for creating a macro for creating diary software of the present invention uses the commands provided with the general-purpose spreadsheet software or general-purpose database software in a state where the software has been started, and the following programming procedure (a) It is characterized in that by performing (d) to (d), these procedures are stored in series and a diary creating macro is created. (A) A step of selecting, on a worksheet, a rectangular area for one day including at least six or more cells in the vertical direction and three or more cells in the horizontal direction using the range setting command. (B) Using a ruled line command, outline the outline of the rectangular area for one day, and divide the inside into three vertical rows along the horizontal frame line and three horizontal columns along the vertical frame line. Forming 9 small areas by using (C) Using a ruled line command, a title description column is formed by partitioning the upper part of each of the small regions along a horizontal frame line, and the title description column of the central small region has a title description column unique to the small region. A step of describing in a fixed mode a title specific to the small area in the title entry column of the date and the surrounding small areas surrounding the date. (D) using the fill command to copy the one-day diary area created in (a) to (c) onto the worksheet for the required number of days in the horizontal direction and the required number of years in the vertical direction.

Here, the “macro” is a function for automating scanning of application software, and is installed in spreadsheet software, word processing software, or the like.

According to such a configuration, it is possible to obtain a macro for creating diary software that is easy to use and makes it easy to check the contents of the description retroactively over the past several years. Also, since the diary software created by the present invention is provided as a macro of general-purpose spreadsheet software or general-purpose database software, the program portion of the diary software itself is small in capacity and the load on the personal computer is small.

[0024]

[Embodiment of the invention]

 Hereinafter, a preferred embodiment of the present invention will be described in detail with reference to the accompanying drawings.

As described above, the apparatus for creating diary software according to the present invention incorporates general-purpose spreadsheet software or general-purpose database software into a personal computer. In the raised state, using the user commands provided with the software, arrange a plurality of rectangular unit areas vertically and horizontally on the worksheet with blank cell rows interposed between adjacent areas, and The diary software is created by allocating each of the arranged rectangular unit areas in the order of the same month on the same month in the same year, and assigning the rectangular unit areas arranged in a vertical line in the same month on the same month in the different year. It is configured as follows.

As described above, the diary software according to the present invention is desirably provided as a macro of general-purpose spreadsheet software or general-purpose database software. FIG. 1 shows an example of the configuration of one day of a diary sheet created using the diary software according to the present invention. In the figure, 1 is a unit frame (one day entry field), 2a to 2h are title fields, 3a to 3h are text fields, and 4a to 4d are basic data fields.

In this example, 2a “political activities”, 2b “people”, 2c “human education”, 2d “money / things”, 2e “hobbies”, 2f “food” , 2g "Health & sex", 2h "Family", and the contents corresponding to each title are entered in the corresponding text boxes 3a to 3h. In addition, since it is based on general-purpose spreadsheet software or general-purpose database software, when information exceeding the display limit of the entry columns 3a to 3h is entered, the sentence column 3 with a large amount of information is automatically enlarged. It is also possible to adopt a configuration in which a normal text is displayed to the extent that it can be displayed (that is, the text can be displayed halfway) and a full text can be displayed by selecting a predetermined location.

In this example, the basic data fields 4a to 4d include 4a “2002, 38 years old, 2002”, 4b “April 15”, 4c “what day”, “anniversary”, “birth date”, respectively. "The anniversary", 4d "Weather", "Get up", "Bed", "Physical condition". In this example, the basic data column 4a contains the year data and the age of the creator, the basic data column 4b contains the date data, the basic data column 4c contains the anniversary data, and the basic data column 4d contains the current day data. It is configured to be.

In the present invention, since the same day data of the past year is arranged in order in the column of the same sheet, the data of the anniversary and the like can be easily checked by checking the basic data column 4c of the same day of the previous year. . In addition, a function may be formed so that the contents written in the basic data column 4c are reflected on the same day in the next year and thereafter.

The contents to be entered in the title columns 2a to 2h and the basic data columns 4a to 4d can be set as appropriate according to the preference of each person. Similarly, the balance between the aspect ratio of the unit frame 1 and the size of each column can be set as appropriate.

The frame 1, which is a recording column for one day, is displayed side by side on a work sheet like a grid. FIG. 2 shows an example of the overall configuration of such a diary sheet according to the present invention. In this example, the horizontal axis indicates the date, and the vertical axis indicates the year, so that frames of consecutive dates of the same year in the horizontal direction and frames of the same day of consecutive years in the vertical direction are arranged side by side.

For example, if the leftmost frame 1a1 at the top is a diary of “January 1, 2000”, the frame 1b1 arranged on the right side is a diary of “January 2, 2000”. In other words, "January 3, 2000", "January 4, 2000" ... "December 31, 2000" are sequentially arranged in the right direction. In the vertical direction, frame 1a2 is a diary of "January 1, 2001", frame 1a3 is a diary of "January 1, 2002", and so on. Month 1 "...

With this configuration, the same day several years ago can be seen at a glance, and the basic data columns 4 a to 4 d of the same day of the previous year or two years before can be easily referred to. This is almost impossible with conventional paper diaries or diaries using word processing software.

When a file is opened (a program is started) using a magnification adjustment function (zoom function) of general-purpose spreadsheet software or general-purpose database software, a reduced display is performed as shown in FIG. May be configured to be displayed enlarged (the state of FIG. 1). The frame of the corresponding date may be enlarged and displayed by referring to the clock information of the personal computer at startup.

When displaying the entire image in reduced size, the date column (or basic data column) is displayed large even when the image is reduced so that the frame of a predetermined date can be easily searched. When the mouse pointer is put on the frame, the date is displayed. A configuration such as pop-up display is also conceivable.

In the above description, an example is shown in which frame 1 for 365 days (or 366 days) is arranged on the horizontal axis and data for several decades is written on one sheet. The number of days can be composed of six months, one month, half month, one week, and so on. In this case, the data capacity per sheet becomes lighter, but there is also the aspect that it is necessary to open another file or sheet when referring to a diary at a distant time. In consideration of the above points, the number of frames arranged in the horizontal direction per sheet is preferably about 15 to 30 (that is, a diary for half a month to January).

In this example, the horizontal axis is configured so that the number of days advances from left to right (the number of days is added), and the vertical axis is configured so that the year advances from the top to the bottom (the number of years is added). However, it is possible to change the parameters of the vertical and horizontal axes according to the preference of the entrant (the vertical axis is the number of days and the horizontal axis is the years), and that the number of days and years is increased from right to left and from bottom to top. It may be configured.

Next, an example of a specific procedure for starting the present invention software and creating the diary sheet described in FIGS. 1 and 2 will be described below. The procedure shown below is an example of a case where the present invention is implemented using Microsoft Excel 2000 (product name of Microsoft's creation device. Corporation spreadsheet creation device.).

First, a program is started to open a new worksheet. Select a cell at an appropriate location on this worksheet with the left mouse button and drag it while holding down the left mouse button to select an appropriate area (see Fig. 3). Since an area having a size of 6 squares by 3 squares is created by a later operation, the range is selected with a minimum of 6 rows by 3 columns or more. (In the figure, 24 rows by 6 columns are selected.) Since the vertical and horizontal widths of each column can be changed as appropriate, the title column can be adjusted by adjusting the width of some columns or rows. Although it is possible to adjust the size of 2 and the text column 3, in order to simplify the operation, the size of each column is controlled by the number of rows and the number of columns in this example. For this reason, it is preferable to select the range of the number of rows by a multiple of 6 and the number of columns by a multiple of 3 in consideration of the appearance balance in the completed state.

In a state where the color of the selected range is inverted (different from the background color), left-click the down arrow of the right end of the [ruled line] button on the toolbar arranged at the top of the screen. Left-click the down arrow to display a list of available ruled line patterns. From the displayed ruled line pattern, select the [outer frame] ruled line that surrounds the four sides of the selected range and left-click to select the [outer frame] ruled line (similar to the pattern) around the selected range. (See FIG. 4).

If the ruled line pattern displayed on the surface of the [ruled line] button on the toolbar is the pattern to be used (in this case, [outer frame] ruled line), simply press the [ruled line] button and [ Since the [Outer Frame] rule is added, there is no need to press the down arrow on the right end of the [Rule] button and select from the displayed patterns.

Next, a process of dividing the selection range separated from the other area by the outer frame into sections of 3 rows × 3 columns using ruled lines is performed.

First, the entire range (area Z1 in FIG. 5) of two columns from the left end of the selection range delimited by the outer frame is selected, and [Outer frame] or [Right ruled line] in the ruled line menu is used. To surround the perimeter of the selection. By the same operation, the center two rows (area Z2 in FIG. 5) and the right end two rows (area Z3 in FIG. 5) also surround the outer periphery. When dividing in the vertical direction, it is easier to process by using [Outer frame], [Right rule], [Left rule], etc. in the ruled line menu.

At this time, an area delimited by left and right frame lines (l1 and l2) and two vertical lines (l3 and l4), that is, an area (Z1) surrounded by upper and lower frame lines and l1 and l2, The upper and lower frame lines and the area (Z2) surrounded by l2 and l3, and the upper and lower frame lines and the area (Z3) surrounded by l3 and l4 may be different sizes, respectively. Someone has a better balance of appearance. Similarly, the arrangement of the upper and lower frame lines and the two horizontal lines may not be equally spaced, but the equal spacing provides better visual balance (see FIG. 5).

Next, a process of similarly dividing into three horizontal rows is performed. If you want to separate horizontally, after selecting the range, press the [Border] button on the toolbar and select one of “Outer Border”, “Bottom Border”, or “Upper Border + Bottom Border” from the displayed Border menu. Used (see FIG. 6).

In this example, two vertical lines are divided into three vertical columns and then two horizontal lines are divided into three horizontal lines. However, even if the order is reversed, there is no problem. Absent. If the same appearance as when the ruled line menu is used can be obtained, the area may be similarly divided using functions other than the ruled line.

After the area divided by the outer frame is divided into nine small areas, the center section is determined by using one of [Outer frame], [Lower ruled line], and [Upper ruled line + Lower ruled line] in the ruled line menu. To separate multiple lines. In this example, it is divided into eight lines using seven horizontal lines (see FIG. 7).

The eight small areas surrounding the center section are divided into a title section (2a to 2h) and a text section (3a to 3h). In this example, the title column has one vertical line and the text column has seven vertical lines (see FIG. 7).

With the above operations, the area surrounded by the outer frame is divided using the ruled lines into the title columns 2a to 2h, the text columns 3a to 3h, and the basic data columns 4a to 4d. However, since the range surrounded by the ruled line is merely a collection of disjointed cells by this alone, next, the cells are combined for each region (divided range) to form a single region.

More specifically, a plurality of cells are combined by dragging 14 cells constituting the text entry field 3a, selecting a range, and pressing a [merge and center align] button on the toolbar. Into one cell (see FIG. 8). In the same way, for the area delimited by other ruled lines, select multiple cells in the range delimited by the ruled line by dragging. → Repeat the operation of pressing the [Combine and Center] button on the toolbar. Then, the cell combining process is repeated (see FIG. 9).

[Cell Formatting] menu displayed by dragging and selecting cells to be merged without using the [Cell Merge and Center] button on the toolbar, and pressing the [Format] button on the toolbar Select and press the [Cell] button. The same effect can be obtained by turning on the [Merge cells] check box in the [Arrangement] tab in the displayed [Format cells] menu. The [Cell Formatting] menu can also be displayed by right-clicking while selecting a predetermined range and pressing the [Cell Formatting] button from the displayed menu.

When the same operation is repeated as in the cell merging operation, a predetermined operation is performed only once (in this case, the [merge cell and align center] button is pressed). It is also possible to perform continuous processing by pressing the [Edit] button on the toolbar, pressing the [Repeat] button that is displayed, or repeating a predetermined operation using a shortcut key.

More specifically, after the cell merging process is performed once, the range can be selected by dragging and the [Repeat] button is pressed (or the shortcut key for instructing the [Repeat] process is pressed), thereby making it easier. Can be repeated. The same [Repeat] button and shortcut key can be used for the same process in succession (repetition).

Although a plurality of cells are combined for each area by the above operation, the display position of the character when the character is written is improper as it is. For this reason, the following operation sets the character layout.

Select the text entry field 3a by right-clicking and select [Format cell] from the displayed menu. Click the [Alignment] tab in the displayed [Cell Format] menu, select [Standard] from the [Horizontal] selection menu in the [Character alignment] column, and similarly select [Vertical]. Select [Top] from the menu. Also, turn on the [wrap around and display entire] check box in the [Character Control] menu. Set the format in the other text fields 3b to 3h in the same manner (you may right-click to display the [Cell Format] menu and make the settings in sequence, but the [Repeat] button or shortcut key May be used).

Thus, when a sentence is entered in the sentence column 3a, the sentence is displayed in order from left to right at the top of the column, and when the right end is reached, the sentence is sequentially carried over to the next row, so that the sentence is displayed in a legible manner. (See FIG. 11).

Next, the title column 2 a is selected by right-clicking, and “Format cell setting” is selected from the displayed menu. From the displayed [Cell Format] menu, click the [Alignment] tab. In the [Text Arrangement] menu, set [Horizontal] to [Center] and [Vertical] to [Center]. The [Character Control] menu does not need to be changed, but the [Reduce and Display Entirely] check box may be turned ON in consideration of the case where the title becomes long. Set the format for the other title fields 2b to 2h in the same manner. (You can right-click to display the [Cell Format Setting] menu and make the settings in sequence. However, the [Repeat] button or shortcut key May be used).

Thus, when the title corresponding to the text column 3a is entered in the title column 2a, the title is arranged in the center of the title column 2a in a well-balanced manner, and the title is too long to fit in the title column 2a. However, the characters in the title column 2a are automatically reduced and displayed, so that the entire title can be read.

Next, the format of the basic data columns 4 a to 4 d will be described. For the basic data columns 4a and 4b, display the [Cell Format] menu by one of the methods described above, set [Horizontal Position] in the [Character Arrangement] menu to [Center], and select [Vertical Position]. Is [centered]. The [Character Control] menu does not need to be changed. However, in consideration of the case where the title becomes longer, the [Reduce and Display Entirely] check box or [Wrap and Display Entirely] is selected. Any of the check boxes may be turned on.

For the basic data columns 4c and 4d, display the [Cell Format] menu by any of the methods described above, and change the [Horizontal Position] of the [Character Placement] menu to [Standard] or [Center] and [Vertical Position] are [Center]. The [Character Control] menu does not need to be changed. However, in consideration of the case where the title becomes long, the [Reduce and display the whole] check box or the [Wrap and display the whole] check box is selected. Any of the boxes may be turned on.

Next, a desired color is given to each column according to preference, and the appearance is adjusted. As a specific operation, select a cell to which a color is to be assigned (for example, the title entry field 2a), and left-click the down arrow on the right end of the [fill color] button on the toolbar. Left-click on the down arrow to see a list of available fill colors. From the displayed list of fill colors, select a preferred color to fill the selected range, and left-click to fill the selected range with the specified color. You can also perform the same process by right-clicking the cell to which you want to add a color, selecting [Format cell] from the menu that appears, and selecting the [Pattern] tab.

If the color displayed on the surface of the [Fill color] button on the toolbar is the color to be used, it is sufficient to press the [Fill color] button, and the [Fill color] is displayed. You do not need to press the down arrow on the right end of the button to select from the displayed colors.

The title columns 2a to 2h, the text entry columns 3a to 3h, and the data columns 4a to 4d are visually attractive and easy to see if they are given different colors. In this example, the title columns 2a to 2h are pale colors, the text entry columns 3a to 3h are colorless (white or ground color), and the data columns 4a, 4c, and 4d are slightly darker colors than the title columns 2a to 2h. The data column 4b is set to a darker color than the data columns 4a, 4c and 4d.

It should be noted that the color assignment processing may be performed on each column immediately after the cell merging processing, or may be performed after the subsequent processing (the order in which the color assignment processing is performed is not particularly specified). .

Further, processing may be performed such that the data in the title columns 2a to 2h and the basic data columns 4a and 4b are fixed and cannot be changed according to the color assignment. This processing may also be performed at another time as in the case of color application.

With the above operation, the frame 1 as an entry column for one day is completed. Next, a process of creating a predetermined number of copies of the frame 1 in the horizontal and vertical directions will be described.

First, the upper end and the left and right widths are set to the frame 1, and the lower end is selected for the range including the lower two lines of the lower frame of the frame 1 (see FIG. 12). The reason why the width is selected to be wider than the outer frame of frame 1 is to provide an appropriate interval between frames when copying is performed so that the frame can be easily viewed.

Next, move the mouse pointer to a black square called “fill handle” displayed at the lower right corner of the selection range. (When the cursor is moved, the cursor changes from a white cross with a thick and short side to a thin and long side. It changes to a black cross). With the mouse pointer on the file handle 10, right-click and drag downward (see Fig. 13). When the user drags downward, the scheduled copy area 10a is displayed surrounded by a dotted line, and the user can see at a glance how far the area is to be copied. After dragging the appropriate amount and releasing the right-click, a shortcut menu for the fill operation is displayed. By selecting [Continuous Data (Yearly)] from the shortcut menu and left-clicking, frames 1a2 to 1a4 for the same day in the consecutive years in the lower row are completed (see FIG. 14).

In FIG. 14, when the date “(2002) April 15” is displayed in the column 4b of the frame 1a1 (not shown in parentheses), the data of the frame 1a1 is continuously displayed on a yearly basis. In the 4b column of the frames 1a2 to 1a4 copied in such a manner, the date of April 15 of each successive year is registered. That is, "(2005) April 15" is displayed in the 4b column of the frame 1a2, "(2004) April 15" is displayed in the 4b column of the frame 1a3, and "(2005) is displayed in the 4b column of the frame 1a4. Year) April 15 "is registered.

Next, a procedure for copying in the horizontal direction with reference to 1a1 will be described. As in the case of copying downward, the left end and the upper and lower widths are selected according to the size of the frame 1a1, and the right end is selected including the right column of the right frame of the frame 1a1. This is because, as described above, after copying, an appropriate space is provided between frames to make it easier to see the entire screen. Next, the fill handle 10 displayed at the lower right corner of the selected range is right-clicked and dragged rightward (see FIG. 15). After dragging an appropriate amount to the right, release the right-click, select [Continuous data (daily)] from the displayed shortcut menu for fill processing, and left-click. Thus, frames 1 b1 to 1 d1 having continuous date data of the same year in the right direction are completed (see FIG. 16).

In FIG. 16, when the date “(2002) April 15” is displayed in the column 4b of the frame 1a1 (not shown in parentheses), the data of the frame 1a1 is continuously displayed on a yearly basis. In the 4b column of the frames 1b1 to 1d1 copied so as to become, consecutive dates after April 15 of the same year are registered, respectively. That is, "(2002) April 16" is displayed in the 4b column of the frame 1 b1, "(2002) April 17" is displayed in the 4b column of the frame 1c1, and "(2002) is displayed in the 4b column of the frame 1d1. ) April 18th is registered.

By continuously performing the above-described copying process, a diary worksheet in which the frames 1 are laid out in a grid pattern is completed (see FIG. 17). Although an example has been described in which copying is performed in the vertical direction and then in the horizontal direction, the order may be reversed, or a plurality of columns may be processed collectively. In addition, the setting of the continuous number may be performed using a fill menu or may be changed manually.

The procedure for creating the diary worksheet described above is an example, and the command used may be changed or the procedure may be changed.

The diary creating macro according to the present invention may be sold as a set of programs corresponding to a plurality of spreadsheet software and database software. Conversely, the macro may be individually prepared for each corresponding spreadsheet software and database software. May be sold.

[0075]

[Effect of the invention]

 As is apparent from the above description, the diary software creation device and the diary software creation macro creation device of the present invention make it easy to create a diary worksheet that is easy to use and has excellent appearance. Can be.

Also, the entry column for one day is divided into nine parts, and basic data such as date is provided in the center entry column, and title data is provided in eight peripheral small areas, and different contents are written. With this configuration, you do not have to worry about the contents you write when writing your diary, and you can easily find what you want to look for later when you read your diary again.

[Submission date] June 27, 2002 (2002.6.27)

[Procedure amendment 1]

[Document name to be amended] Statement

[Correction target item name] Full text

[Correction method] Change

[Correction contents] [Detailed description of the invention]

[0001]

[Technical field to which the invention belongs]

 The present invention relates to an apparatus for creating diary software that allows a diary to appear on the screen of a personal computer.

[0002]

[Prior art]

 Keeping a daily record, such as a diary, on a regular basis has long been evaluated as useful for organizing memories and thinking. Diary recording methods (recording media) include the most common recording on paper media (the use of a so-called diary), and the recording using personal computer word processing software that has developed in recent years.

[0003]

[Problems to be solved by the invention]

 However, when a paper medium such as a diary is used as a diary recording medium, the key of the diary or the like can be easily destroyed, so the confidentiality is not sufficient, and most of the recording media for more than ten years can be recorded. And the information recording capacity is small. In addition, there is a problem that it is difficult to search for information to search.

On the other hand, when word processing software or the like is used, the problem that the capacity is small is solved, but there is a problem that the data expands in a band and is difficult to read.

The present invention has been made in view of the above-mentioned problems, and a purpose thereof is to provide a diary software creation device that is easy to use and easy to make.

Another object of the present invention is to provide an apparatus for creating diary software which has good confidentiality and can store a long-term record. .

Another object of the present invention is to provide an apparatus for creating diary software which makes it easy to search for data on a predetermined date and can display diaries for a plurality of years on one screen. It is in.

[0008] Other objects and operational effects of the present invention will be easily understood by those skilled in the art by referring to the following description.

[0009]

[Means for Solving the Problems]

 In order to achieve the above object, a diary software creation device according to the present invention includes a personal computer having an input operator such as a mouse, an image display such as a CRT or an LCD, and a CPU for controlling them collectively. Includes general-purpose spreadsheet software or general-purpose database software installed on the personal computer, and uses a user command provided with the software to place a rectangular unit area on the worksheet with blank cell rows between adjacent areas. In addition to arranging only a plurality of rectangular unit areas vertically and horizontally, each of the rectangular unit areas arranged in a horizontal line is sequentially assigned to different days of the same year, and the rectangular unit areas arranged in a vertical line are sequentially assigned to the same month of the different year. It is characterized in that a diary software is created by performing the assignment operation.

[0010] According to such a configuration, by using a general-purpose spreadsheet software or a general-purpose database software to configure an apparatus for creating diary software, the general-purpose spreadsheet software or the general-purpose database software is used. Therefore, the advantages of the diary software creation device can be fully utilized.

For example, by locking the diary software (or recording file) with a password, it is possible to prevent others from browsing with high confidentiality. Also, unlike the paper diary, the information recording capacity is large, so it is possible to store records for several decades. In addition, since the diary entry fields for multiple days are arranged on the worksheet so that they can be seen at a glance, the records of the same day in the previous year and the records several days before the same year can be easily checked.

The rectangular unit area is further divided into nine small areas by being divided into three vertical rows by three horizontal rows along a vertical frame line, and divided into nine small areas. In the item description area, each of the eight peripheral small areas surrounding the central small area may be assigned to the specific item description area.

Here, the “frame line” is a dividing line between each cell. The “cell” is the minimum unit cell for data entry in spreadsheet software and database software.

According to such a configuration, the diary entry field is divided into nine small areas, and the central small area is a common matter description area. Is set to be recorded in the central common item description area, it is easy to confirm information.

In a preferred embodiment of the present invention, date information unique to the small area may be described in a fixed mode in the central small area.

According to such a configuration, since the unique date information is described in the fixed mode, when the common matter other than the date information is entered in the central small area, the date is erroneously entered. Errors such as deleting or changing the date information are unlikely to occur.

[0017] In another preferred embodiment of the present invention, an item title entry field is defined at the top of each of the peripheral small areas, and the corresponding item text is described in the fixed mode in the item title entry field. It may be.

According to such a configuration, when writing is performed in the eight peripheral small areas surrounding the central small area, the problem of changing or erasing the item title hardly occurs.

Further, the apparatus for creating diary software according to the present invention includes a personal computer having an input operator such as a mouse, an image display such as a CRT or an LCD, and a CPU for controlling them collectively. It is created by including the following programming procedures (a) to (d) by using the command provided in the software, including general-purpose spreadsheet software or general-purpose database software. is there. (A) A step of selecting, on a worksheet, a rectangular area for one day including at least six or more cells in the vertical direction and three or more cells in the horizontal direction using the range setting command. (B) Using a ruled line command, outline the outline of the rectangular area for one day, and divide the inside into three vertical rows along the horizontal frame line and three horizontal columns along the vertical frame line. Forming 9 small areas by using (C) Using a ruled line command, a title description column is formed by partitioning the upper part of each of the small regions along a horizontal frame line, and the title description column of the central small region has a title description column unique to the small region. A step of describing in a fixed mode a title specific to the small area in the title entry column of the date and the surrounding small areas surrounding the date. (D) using the fill command to copy the one-day diary area created in (a) to (c) onto the worksheet for the required number of days in the horizontal direction and the required number of years in the vertical direction.

According to such a configuration, it is possible to obtain an apparatus for creating diary software that is easy to use and easy to confirm the contents of descriptions in the past several years.

A device for creating a macro for creating diary book software according to the present invention is a personal computer having an input operator such as a mouse, an image display such as a CRT or an LCD, and a CPU for controlling them collectively. By performing the following programming procedures (a) to (d) using general-purpose spreadsheet software or general-purpose database software installed in the software and using the commands provided in the software, those procedures are stored in a series. Then, an apparatus for creating a macro for creating diary software is created. (A) A step of selecting, on a worksheet, a rectangular area for one day including at least six or more cells in the vertical direction and three or more cells in the horizontal direction using the range setting command. (B) Using a ruled line command, outline the outline of the rectangular area for one day, and divide the inside into three vertical rows along the horizontal frame line and three horizontal columns along the vertical frame line. Forming 9 small areas by using (C) Using a ruled line command, a title description column is formed by partitioning the upper part of each of the small regions along a horizontal frame line, and the title description column of the central small region has a title description column unique to the small region. A step of describing in a fixed mode a title specific to the small area in the title entry column of the date and the surrounding small areas surrounding the date. (D) using the fill command to copy the one-day diary area created in (a) to (c) onto the worksheet for the required number of days in the horizontal direction and the required number of years in the vertical direction.

Here, the “macro” is a function for automating scanning of application software, and is installed in spreadsheet software, word processing software, or the like.

According to such a configuration, it is possible to obtain a macro for creating diary software that is easy to use and makes it easy to check the contents of the description retroactively over the past several years. Also, since the diary software according to the present invention is provided as a macro of general-purpose spreadsheet software or general-purpose database software, the program portion of the diary software itself is small in capacity, and the load on personal computers is small.

[0024]

[Embodiment of the invention]

 Hereinafter, a preferred embodiment of the present invention will be described in detail with reference to the accompanying drawings.

As described above, the apparatus for creating diary software according to the present invention is a personal computer having an input operator such as a mouse, an image display such as a CRT or an LCD, and a CPU for controlling them collectively. And general-purpose spreadsheet software or general-purpose database software installed on the personal computer, using a user command provided with the software, interposing a rectangular unit area on a worksheet and inserting blank cell rows between adjacent areas In addition to arranging only a plurality of rectangular unit areas vertically and horizontally, each of the rectangular unit areas arranged in a horizontal line is sequentially assigned to the different day of the same year, and the rectangular unit areas arranged in a vertical line are assigned the same date of the different year. It is configured so that diary software is created by performing the operation of assigning in order.

As described above, the apparatus for creating diary software according to the present invention is preferably provided as a macro of general-purpose spreadsheet software or general-purpose database software. FIG. 1 shows an example of the configuration of one day of a diary sheet created using the diary software creating apparatus according to the present invention. In the figure, 1 is a unit frame (one day entry column), 2a to 2h are title columns, 3a to 3h are text columns, and 4a to 4d are basic data columns.

In this example, 2a “political activities”, 2b “people”, 2c “human education”, 2d “money / things”, 2e “hobbies”, 2f “food” , 2g "Health & sex", 2h "Family", and the contents corresponding to each title are entered in the corresponding text boxes 3a to 3h. In addition, since it is based on general-purpose spreadsheet software or general-purpose database software, when information exceeding the display limit of the entry columns 3a to 3h is entered, the sentence column 3 with a large amount of information is automatically enlarged. It is also possible to adopt a configuration in which a normal text is displayed to the extent that it can be displayed (that is, the text can be displayed halfway) and a full text can be displayed by selecting a predetermined location.

In this example, the basic data fields 4a to 4d include 4a “2002, 38 years old, 2002”, 4b “April 15”, 4c “what day”, “anniversary”, “birth date”, respectively. "The anniversary", 4d "Weather", "Get up", "Bed", "Physical condition". In this example, the basic data column 4a contains the year data and the age of the creator, the basic data column 4b contains the date data, the basic data column 4c contains the anniversary data, and the basic data column 4d contains the current day data. It is configured to be.

In the present invention, since the same day data of the past year is arranged in order in the column of the same sheet, the data of the anniversary and the like can be easily checked by checking the basic data column 4c of the same day of the previous year. . In addition, a function may be formed so that the contents written in the basic data column 4c are reflected on the same day in the next year and thereafter.

The contents to be entered in the title columns 2a to 2h and the basic data columns 4a to 4d can be set as appropriate according to the preference of each person. Similarly, the balance between the aspect ratio of the unit frame 1 and the size of each column can be set as appropriate.

The frame 1, which is a recording column for one day, is displayed side by side on a work sheet like a grid. FIG. 2 shows an example of the overall configuration of such a diary sheet according to the present invention. In this example, the horizontal axis indicates the date, and the vertical axis indicates the year, so that frames of consecutive dates of the same year in the horizontal direction and frames of the same day of consecutive years in the vertical direction are arranged side by side.

For example, if the leftmost frame 1a1 at the top is a diary of “January 1, 2000”, the frame 1b1 arranged on the right side is a diary of “January 2, 2000”. In other words, "January 3, 2000", "January 4, 2000" ... "December 31, 2000" are sequentially arranged in the right direction. In the vertical direction, frame 1a2 is a diary of "January 1, 2001", frame 1a3 is a diary of "January 1, 2002", and so on. Month 1 "...

With this configuration, the same day several years ago can be seen at a glance, and the basic data columns 4 a to 4 d of the same day of the previous year or two years before can be easily referred to. This is almost impossible with conventional paper diaries or diaries using word processing software.

When a file is opened (a program is started) using a magnification adjustment function (zoom function) of general-purpose spreadsheet software or general-purpose database software, a reduced display is performed as shown in FIG. May be configured to be displayed enlarged (the state of FIG. 1). The frame of the corresponding date may be enlarged and displayed by referring to the clock information of the personal computer at startup.

When displaying the entire image in reduced size, the date column (or basic data column) is displayed large even when the image is reduced so that the frame of a predetermined date can be easily searched. When the mouse pointer is put on the frame, the date is displayed. A configuration such as pop-up display is also conceivable.

In the above description, an example is shown in which frame 1 for 365 days (or 366 days) is arranged on the horizontal axis and data for several decades is written on one sheet. The number of days can be composed of six months, one month, half month, one week, and so on. In this case, the data capacity per sheet becomes lighter, but there is also the aspect that it is necessary to open another file or sheet when referring to a diary at a distant time. In consideration of the above points, the number of frames arranged in the horizontal direction per sheet is preferably about 15 to 30 (that is, a diary for half a month to January).

In this example, the horizontal axis is configured so that the number of days advances from left to right (the number of days is added), and the vertical axis is configured so that the year advances from the top to the bottom (the number of years is added). However, it is possible to change the parameters of the vertical and horizontal axes according to the preference of the entrant (the vertical axis is the number of days and the horizontal axis is the years), and that the number of days and years is increased from right to left and from bottom to top. It may be configured.

Next, an example of a specific procedure for starting the present invention software and creating the diary sheet described in FIGS. 1 and 2 will be described below. The procedure shown below is an example of a case where the present invention is implemented using Microsoft Excel 2000 (trade name of spreadsheet software of Microsoft Corporation).

First, a program is started to open a new worksheet. Select a cell at an appropriate location on this worksheet with the left mouse button and drag it while holding down the left mouse button to select an appropriate area (see Fig. 3). Since an area having a size of 6 squares by 3 squares is created by a later operation, the range is selected with a minimum of 6 rows by 3 columns or more. (In the figure, 24 rows by 6 columns are selected.) Since the vertical and horizontal widths of each column can be changed as appropriate, the title column can be adjusted by adjusting the width of some columns or rows. Although it is possible to adjust the size of 2 and the text column 3, in order to simplify the operation, the size of each column is controlled by the number of rows and the number of columns in this example. For this reason, it is preferable to select the range of the number of rows by a multiple of 6 and the number of columns by a multiple of 3 in consideration of the appearance balance in the completed state.

In a state where the color of the selected range is inverted (different from the background color), left-click the down arrow of the right end of the [ruled line] button on the toolbar arranged at the top of the screen. Left-click the down arrow to display a list of available ruled line patterns. From the displayed ruled line pattern, select the [outer frame] ruled line that surrounds the four sides of the selected range and left-click to select the [outer frame] ruled line (similar to the pattern) around the selected range. (See FIG. 4).

If the ruled line pattern displayed on the surface of the [ruled line] button on the toolbar is the pattern to be used (in this case, [outer frame] ruled line), simply press the [ruled line] button and [ Since the [Outer Frame] rule is added, there is no need to press the down arrow on the right end of the [Rule] button and select from the displayed patterns.

Next, a process of dividing the selection range separated from the other area by the outer frame into sections of 3 rows × 3 columns using ruled lines is performed.

First, the entire range (area Z1 in FIG. 5) of two columns from the left end of the selection range delimited by the outer frame is selected, and [Outer frame] or [Right ruled line] in the ruled line menu is used. To surround the perimeter of the selection. By the same operation, the center two rows (area Z2 in FIG. 5) and the right end two rows (area Z3 in FIG. 5) also surround the outer periphery. When dividing in the vertical direction, it is easier to process by using [Outer frame], [Right rule], [Left rule], etc. in the ruled line menu.

At this time, an area delimited by left and right frame lines (l1 and l2) and two vertical lines (l3 and l4), that is, an area (Z1) surrounded by upper and lower frame lines and l1 and l2, The upper and lower frame lines and the area (Z2) surrounded by l2 and l3, and the upper and lower frame lines and the area (Z3) surrounded by l3 and l4 may be different sizes, respectively. Someone has a better balance of appearance. Similarly, the arrangement of the upper and lower frame lines and the two horizontal lines may not be equally spaced, but the equal spacing provides better visual balance (see FIG. 5).

Next, a process of similarly dividing into three horizontal rows is performed. If you want to separate horizontally, after selecting the range, press the [Border] button on the toolbar and select one of “Outer Border”, “Bottom Border”, or “Upper Border + Bottom Border” from the displayed Border menu. Used (see FIG. 6).

In this example, two vertical lines are divided into three vertical columns and then two horizontal lines are divided into three horizontal lines. However, even if the order is reversed, there is no problem. Absent. If the same appearance as when the ruled line menu is used can be obtained, the area may be similarly divided using functions other than the ruled line.

After the area divided by the outer frame is divided into nine small areas, the center section is determined by using one of [Outer frame], [Lower ruled line], and [Upper ruled line + Lower ruled line] in the ruled line menu. To separate multiple lines. In this example, it is divided into eight lines using seven horizontal lines (see FIG. 7).

The eight small areas surrounding the center section are divided into a title section (2a to 2h) and a text section (3a to 3h). In this example, the title column has one vertical line and the text column has seven vertical lines (see FIG. 7).

With the above operations, the area surrounded by the outer frame is divided using the ruled lines into the title columns 2a to 2h, the text columns 3a to 3h, and the basic data columns 4a to 4d. However, since the range surrounded by the ruled line is merely a collection of disjointed cells by this alone, next, the cells are combined for each region (divided range) to form a single region.

More specifically, a plurality of cells are combined by dragging 14 cells constituting the text entry field 3a, selecting a range, and pressing a [merge and center align] button on the toolbar. Into one cell (see FIG. 8). In the same way, for the area delimited by other ruled lines, select multiple cells in the range delimited by the ruled line by dragging. → Repeat the operation of pressing the [Combine and Center] button on the toolbar. Then, the cell combining process is repeated (see FIG. 9).

[Cell Formatting] menu displayed by dragging and selecting cells to be merged without using the [Cell Merge and Center] button on the toolbar, and pressing the [Format] button on the toolbar Select and press the [Cell] button. The same effect can be obtained by turning on the [Merge cells] check box in the [Arrangement] tab in the displayed [Format cells] menu. The [Cell Formatting] menu can also be displayed by right-clicking while selecting a predetermined range and pressing the [Cell Formatting] button from the displayed menu.

When the same operation is repeated as in the cell merging operation, a predetermined operation is performed only once (in this case, the [merge cell and align center] button is pressed). It is also possible to perform continuous processing by pressing the [Edit] button on the toolbar, pressing the [Repeat] button that is displayed, or repeating a predetermined operation using a shortcut key.

More specifically, after the cell merging process is performed once, the range can be selected by dragging and the [Repeat] button is pressed (or the shortcut key for instructing the [Repeat] process is pressed), thereby making it easier. Can be repeated. The same [Repeat] button and shortcut key can be used for the same process in succession (repetition).

Although a plurality of cells are combined for each area by the above operation, the display position of the character when the character is written is improper as it is. For this reason, the following operation sets the character layout.

Select the text entry field 3a by right-clicking and select [Format cell] from the displayed menu. Click the [Alignment] tab in the displayed [Cell Format] menu, select [Standard] from the [Horizontal] selection menu in the [Character alignment] column, and similarly select [Vertical]. Select [Top] from the menu. Also, turn on the [wrap around and display entire] check box in the [Character Control] menu. Set the format in the other text fields 3b to 3h in the same manner (you may right-click to display the [Cell Format] menu and make the settings in sequence, but the [Repeat] button or shortcut key May be used).

Thus, when a sentence is entered in the sentence column 3a, the sentence is displayed in order from left to right at the top of the column, and when the right end is reached, the sentence is sequentially carried over to the next row, so that the sentence is displayed in a legible manner. (See FIG. 11).

Next, the title column 2 a is selected by right-clicking, and “Format cell setting” is selected from the displayed menu. From the displayed [Cell Format] menu, click the [Alignment] tab. In the [Text Arrangement] menu, set [Horizontal] to [Center] and [Vertical] to [Center]. The [Character Control] menu does not need to be changed, but the [Reduce and Display Entirely] check box may be turned ON in consideration of the case where the title becomes long. Set the format for the other title fields 2b to 2h in the same manner. (You can right-click to display the [Cell Format Setting] menu and make the settings in sequence. However, the [Repeat] button or shortcut key May be used).

Thus, when the title corresponding to the text column 3a is entered in the title column 2a, the title is arranged in the center of the title column 2a in a well-balanced manner, and the title is too long to fit in the title column 2a. However, the characters in the title column 2a are automatically reduced and displayed, so that the entire title can be read.

Next, the format of the basic data columns 4 a to 4 d will be described. For the basic data columns 4a and 4b, display the [Cell Format] menu by one of the methods described above, set [Horizontal Position] in the [Character Arrangement] menu to [Center], and select [Vertical Position]. Is [centered]. The [Character Control] menu does not need to be changed. However, in consideration of the case where the title becomes longer, the [Reduce and Display Entirely] check box or [Wrap and Display Entirely] is selected. Any of the check boxes may be turned on.

For the basic data columns 4c and 4d, display the [Cell Format] menu by any of the methods described above, and change the [Horizontal Position] of the [Character Placement] menu to [Standard] or [Center] and [Vertical Position] are [Center]. The [Character Control] menu does not need to be changed. However, in consideration of the case where the title becomes long, the [Reduce and display the whole] check box or the [Wrap and display the whole] check box is selected. Any of the boxes may be turned on.

Next, a desired color is given to each column according to preference, and the appearance is adjusted. As a specific operation, select a cell to which a color is to be assigned (for example, the title entry field 2a), and left-click the down arrow on the right end of the [fill color] button on the toolbar. Left-click on the down arrow to see a list of available fill colors. From the displayed list of fill colors, select a preferred color to fill the selected range, and left-click to fill the selected range with the specified color. You can also perform the same process by right-clicking the cell to which you want to add a color, selecting [Format cell] from the menu that appears, and selecting the [Pattern] tab.

If the color displayed on the surface of the [Fill color] button on the toolbar is the color to be used, it is sufficient to press the [Fill color] button, and the [Fill color] is displayed. You do not need to press the down arrow on the right end of the button to select from the displayed colors.

The title columns 2a to 2h, the text entry columns 3a to 3h, and the data columns 4a to 4d are visually attractive and easy to see if they are given different colors. In this example, the title columns 2a to 2h are pale colors, the text entry columns 3a to 3h are colorless (white or ground color), and the data columns 4a, 4c, and 4d are slightly darker colors than the title columns 2a to 2h. The data column 4b is set to a darker color than the data columns 4a, 4c and 4d.

It should be noted that the color assignment processing may be performed on each column immediately after the cell merging processing, or may be performed after the subsequent processing (the order in which the color assignment processing is performed is not particularly specified). .

Further, processing may be performed such that the data in the title columns 2a to 2h and the basic data columns 4a and 4b are fixed and cannot be changed according to the color assignment. This processing may also be performed at another time as in the case of color application.

With the above operation, the frame 1 as an entry column for one day is completed. Next, a process of creating a predetermined number of copies of the frame 1 in the horizontal and vertical directions will be described.

First, the upper end and the left and right widths are set to the frame 1, and the lower end is selected for the range including the lower two lines of the lower frame of the frame 1 (see FIG. 12). The reason why the width is selected to be wider than the outer frame of frame 1 is to provide an appropriate interval between frames when copying is performed so that the frame can be easily viewed.

Next, move the mouse pointer to a black square called “fill handle” displayed at the lower right corner of the selection range. (When the cursor is moved, the cursor changes from a white cross with a thick and short side to a thin and long side. It changes to a black cross). With the mouse pointer on the file handle 10, right-click and drag downward (see Fig. 13). When the user drags downward, the scheduled copy area 10a is displayed surrounded by a dotted line, and the user can see at a glance how far the area is to be copied. After dragging the appropriate amount and releasing the right-click, a shortcut menu for the fill operation is displayed. By selecting [Continuous Data (Yearly)] from the shortcut menu and left-clicking, frames 1a2 to 1a4 for the same day in the consecutive years in the lower row are completed (see FIG. 14).

In FIG. 14, when the date “(2002) April 15” is displayed in the column 4b of the frame 1a1 (not shown in parentheses), the data of the frame 1a1 is continuously displayed on a yearly basis. In the 4b column of the frames 1a2 to 1a4 copied in such a manner, the date of April 15 of each successive year is registered. That is, "(2005) April 15" is displayed in the 4b column of the frame 1a2, "(2004) April 15" is displayed in the 4b column of the frame 1a3, and "(2005) is displayed in the 4b column of the frame 1a4. Year) April 15 "is registered.

Next, a procedure for copying in the horizontal direction with reference to 1a1 will be described. As in the case of copying downward, the left end and the upper and lower widths are selected according to the size of the frame 1a1, and the right end is selected including the right column of the right frame of the frame 1a1. This is because, as described above, after copying, an appropriate space is provided between frames to make it easier to see the entire screen. Next, the fill handle 10 displayed at the lower right corner of the selected range is right-clicked and dragged rightward (see FIG. 15). After dragging an appropriate amount to the right, release the right-click, select [Continuous data (daily)] from the displayed shortcut menu for fill processing, and left-click. Thus, frames 1 b1 to 1 d1 having continuous date data of the same year in the right direction are completed (see FIG. 16).

In FIG. 16, when the date “(2002) April 15” is displayed in the column 4b of the frame 1a1 (not shown in parentheses), the data of the frame 1a1 is continuously displayed on a yearly basis. In the 4b column of the frames 1b1 to 1d1 copied so as to become, consecutive dates after April 15 of the same year are registered, respectively. That is, "(2002) April 16" is displayed in the 4b column of the frame 1 b1, "(2002) April 17" is displayed in the 4b column of the frame 1c1, and "(2002) is displayed in the 4b column of the frame 1d1. ) April 18th is registered.

By continuously performing the above-described copying process, a diary worksheet in which the frames 1 are laid out in a grid pattern is completed (see FIG. 17). Although an example has been described in which copying is performed in the vertical direction and then in the horizontal direction, the order may be reversed, or a plurality of columns may be processed collectively. In addition, the setting of the continuous number may be performed using a fill menu or may be changed manually.

The procedure for creating the diary worksheet described above is an example, and the command used may be changed or the procedure may be changed.

The device for creating a macro for creating diary software according to the present invention may sell a set of programs corresponding to a plurality of spreadsheet software and database software, and vice versa. May be sold separately.

[0075]

[Effect of the invention]

 As is apparent from the above description, the diary software creation device and the diary software creation macro creation device of the present invention make it easy to create a diary worksheet that is easy to use and has excellent appearance. Can be.

Also, the entry column for one day is divided into nine parts, and basic data such as date is provided in the center entry column, and title data is provided in eight peripheral small areas, and different contents are written. With this configuration, you do not have to worry about the contents you write when writing your diary, and you can easily find what you want to look for later when you read your diary again.

[Brief description of the drawings]

FIG. 1 is a diagram illustrating an example of a configuration (unit frame) for one day.

FIG. 2 is a diagram showing an example of an overall image of a diary worksheet.

FIG. 3 is a diagram (part 1) illustrating an example of a diary book worksheet creation procedure.

FIG. 4 is a diagram (part 2) illustrating an example of a diary book worksheet creation procedure.

FIG. 5 is a diagram (part 3) illustrating an example of a diary book worksheet creation procedure.

FIG. 6 is a diagram (part 4) illustrating an example of a diary book worksheet creation procedure.

FIG. 7 is a diagram (part 5) illustrating an example of a diary book worksheet creation procedure.

FIG. 8 is a diagram (part 6) illustrating an example of a diary book worksheet creation procedure.

FIG. 9 is a diagram (part 7) illustrating an example of a diary book worksheet creation procedure.

FIG. 10 is a diagram (No. 8) illustrating an example of a diary book worksheet creation procedure.

FIG. 11 is a diagram (part 9) illustrating an example of a diary book worksheet creation procedure.

FIG. 12 is a diagram (part 10) illustrating an example of a diary book worksheet creation procedure.

FIG. 13 is a diagram (part 11) illustrating an example of a diary book worksheet creation procedure.

FIG. 14 is a diagram (part 12) illustrating an example of a diary book worksheet creation procedure.

FIG. 15 is a diagram (part 13) illustrating an example of a diary book worksheet creation procedure.

FIG. 16 is a diagram (part 14) illustrating an example of a diary book worksheet creation procedure.

FIG. 17 is a diagram (part 15) illustrating an example of a diary book worksheet creation procedure.

[Explanation of symbols]

 1 Unit frame 2 Title field 3 Text field 4 Basic data field 10 Fill handle 10a Planned copy area

────────────────────────────────────────────────── ───

[Procedure amendment]

[Submission Date] April 25, 2002 (2002.4.2
5)

[Procedure amendment 1]

[Document name to be amended] Statement

[Correction target item name] Full text

[Correction method] Change

[Correction contents]

[Document Name] Statement

[Name of the device ] Diary software creation device

[Utility model registration claims]

[Brief description of the drawings]

FIG. 1 is a diagram illustrating an example of a configuration (unit frame) for one day.

FIG. 2 is a diagram showing an example of an overall image of a diary worksheet.

FIG. 3 is a diagram (part 1) illustrating an example of a diary book worksheet creation procedure.

FIG. 4 is a diagram (part 2) illustrating an example of a diary book worksheet creation procedure.

FIG. 5 is a diagram (part 3) illustrating an example of a diary book worksheet creation procedure.

FIG. 6 is a diagram (part 4) illustrating an example of a diary book worksheet creation procedure.

FIG. 7 is a diagram (part 5) illustrating an example of a diary book worksheet creation procedure.

FIG. 8 is a diagram (part 6) illustrating an example of a diary book worksheet creation procedure.

FIG. 9 is a diagram (part 7) illustrating an example of a diary book worksheet creation procedure.

FIG. 10 is a diagram (No. 8) illustrating an example of a diary book worksheet creation procedure.

FIG. 11 is a diagram (part 9) illustrating an example of a diary book worksheet creation procedure.

FIG. 12 is a diagram (part 10) illustrating an example of a diary book worksheet creation procedure.

FIG. 13 is a diagram (part 11) illustrating an example of a diary book worksheet creation procedure.

FIG. 14 is a diagram (part 12) illustrating an example of a diary book worksheet creation procedure.

FIG. 15 is a diagram (part 13) illustrating an example of a diary book worksheet creation procedure.

FIG. 16 is a diagram (part 14) illustrating an example of a diary book worksheet creation procedure.

FIG. 17 is a diagram (part 15) illustrating an example of a diary book worksheet creation procedure.

[Description of Signs] 1 Unit frame 2 Title field 3 Text field 4 Basic data field 10 Fill handle 10a Planned copy area ───────────────────────── ────────────────────────────

[Procedure amendment]

[Submission date] June 27, 2002 (2002.6.2
7)

[Procedure amendment 1]

[Document name to be amended] Statement

[Correction target item name] Full text

[Correction method] Change

[Correction contents]

[Document Name] Statement

[Name of the device] Diary software creation device

[Utility model registration claims]

[Brief description of the drawings]

FIG. 1 is a diagram illustrating an example of a configuration (unit frame) for one day.

FIG. 2 is a diagram showing an example of an overall image of a diary worksheet.

FIG. 3 is a diagram (part 1) illustrating an example of a diary book worksheet creation procedure.

FIG. 4 is a diagram (part 2) illustrating an example of a diary book worksheet creation procedure.

FIG. 5 is a diagram (part 3) illustrating an example of a diary book worksheet creation procedure.

FIG. 6 is a diagram (part 4) illustrating an example of a diary book worksheet creation procedure.

FIG. 7 is a diagram (part 5) illustrating an example of a diary book worksheet creation procedure.

FIG. 8 is a diagram (part 6) illustrating an example of a diary book worksheet creation procedure.

FIG. 9 is a diagram (part 7) illustrating an example of a diary book worksheet creation procedure.

FIG. 10 is a diagram (No. 8) illustrating an example of a diary book worksheet creation procedure.

FIG. 11 is a diagram (part 9) illustrating an example of a diary book worksheet creation procedure.

FIG. 12 is a diagram (part 10) illustrating an example of a diary book worksheet creation procedure.

FIG. 13 is a diagram (part 11) illustrating an example of a diary book worksheet creation procedure.

FIG. 14 is a diagram (part 12) illustrating an example of a diary book worksheet creation procedure.

FIG. 15 is a diagram (part 13) illustrating an example of a diary book worksheet creation procedure.

FIG. 16 is a diagram (part 14) illustrating an example of a diary book worksheet creation procedure.

FIG. 17 is a diagram (part 15) illustrating an example of a diary book worksheet creation procedure.

[Explanation of Signs] 1 Unit frame 2 Title field 3 Text field 4 Basic data field 10 Fill handle 10a Copy planned area

Claims (6)

[Utility model registration claims] 1. In a state where general-purpose spreadsheet software or general-purpose database software is started, a rectangular unit area is interposed on a worksheet and a blank cell column is interposed between adjacent areas using a user command provided in the software. In addition to arranging a plurality of rectangular unit areas vertically and horizontally, and assigning each of the rectangular unit areas arranged in a horizontal line in order to different month dates of the same year, the rectangular unit areas arranged in a vertical line are sequentially arranged in the same month date of the different year. Diary book software characterized by being assigned. 2. The rectangular unit area is further divided into nine small areas divided into three rows vertically and three columns horizontally along a vertical frame line along a horizontal frame line. The diary software according to claim 1, wherein each is assigned to a common item description area, and each of eight peripheral small areas surrounding the central small area is assigned to a specific item description area. 3. The diary book software according to claim 2, wherein date information unique to the small area is described in a fixed mode in the central small area. 4. An item title entry field is defined in an upper row of each of the peripheral small areas, and a corresponding item character is entered in the item title entry field in a fixed mode. Or the diary software described in 3. 5. In a state in which general-purpose spreadsheet software or general-purpose database software has been started, the program is created including the following programming procedures (a) to (d) by using a command provided in the software. A unique diary book software. (A) using a range setting command to select, on a worksheet, a one-day rectangular area including at least six or more cells in the vertical direction and three or more cells in the horizontal direction; (B) Using a ruled line command, outline the outline of the rectangular area for one day, and divide the inside of the rectangular area along the horizontal frame by 3
Forming 9 small areas by dividing into rows and 3 columns along a vertical frame line. (C) Using a ruled line command, a title description column is formed by partitioning the upper part of each of the small regions along a horizontal frame line, and a title description column of the central small region has a title description column unique to the small region. In a fixed mode, a date unique to the small area is described in the title entry column of the surrounding small area surrounding the date in the fixed mode. (D) using the fill command to copy the one-day diary area created in (a) to (c) on the worksheet for the required number of days in the horizontal direction and the required number of years in the vertical direction. 6. In a state where general-purpose spreadsheet software or general-purpose database software is started, the following programming procedures (a) to (d) using commands provided in the software are stored in series. Characteristic macro for creating diary software. (A) using a range setting command to select, on a worksheet, a one-day rectangular area including at least six or more cells in the vertical direction and three or more cells in the horizontal direction; (B) Using a ruled line command, outline the outline of the rectangular area for one day, and divide the inside of the rectangular area along the horizontal frame by 3
Forming 9 small areas by dividing into rows and 3 columns along a vertical frame line. (C) Using a ruled line command, a title description column is formed by partitioning the upper part of each of the small regions along a horizontal frame line, and a title description column of the central small region has a title description column unique to the small region. In a fixed mode, a date unique to the small area is described in the title entry column of the surrounding small area surrounding the date in the fixed mode. (D) using the fill command to copy the one-day diary area created in (a) to (c) on the worksheet for the required number of days in the horizontal direction and the required number of years in the vertical direction.