CN113051210A

CN113051210A - Special calculator for financial accounting

Info

Publication number: CN113051210A
Application number: CN201911377889.4A
Authority: CN
Inventors: 汪峻峰; 汪风珍
Original assignee: Zhangjiajie Institute of Aeronautical Engineering
Current assignee: Zhangjiajie Institute of Aeronautical Engineering
Priority date: 2019-12-27
Filing date: 2019-12-27
Publication date: 2021-06-29

Abstract

The hardware of the special calculator for finance and accounting mainly comprises a singlechip, keys, a loudspeaker connecting wire, a display screen, a USB interface, a USB flat cable, a power socket and a battery socket, a function operation page and a common operation page are arranged, and the mutual switching of the two pages is arranged, the special calculator for finance and accounting utilizes a function technology to finish most finance and accounting operation data by utilizing functions, thus reducing the use of the operation keys, the function operation page does not need the participation of the operation keys during data operation, meanwhile, the application provides the mutual switching of the function operation page and the common operation page, is convenient for operators to use, in addition, in the function operation page, the data arrangement is orderly, and the data review function is provided, the previous page and the next page are provided, the operation of a large amount of data can be finished, the computer is connected by utilizing the USB, and an external function is written, the functions of the device can be expanded.

Description

Special calculator for financial accounting

Technical Field

The application belongs to electronic products, and particularly relates to an electronic calculator.

Background

The applicant searches for the application number 201210550385X, and the abstract of the specification is as follows: a calculator comprises an input module, a calculation module and a display module, wherein the input module is used for receiving user input operation through keys and generating corresponding input signals, the calculation module is used for receiving the input signals and calculating, the display module is used for displaying calculation results of the calculation module, and the calculator further comprises: the calculator comprises a microphone, an identification module and a reminding module, wherein the microphone is used for collecting sound information, the identification module is used for detecting whether the input module generates an input signal when the sound information amplitude reaches a preset threshold value, the reminding module is used for sending reminding information when the identification module identifies that the sound information reaches the preset threshold value and the input module does not generate the input signal, and the calculator can find the condition of unsuccessful input in time through key sound and the input signal and remind a user.

From the actual situation of financial accounting work, financial accounting work is mainly added, namely, the summary of various data is a main working point, and financial accounting work has the characteristics of large data volume and complexity, but the current calculator or calculator on a mobile phone mostly has a single line function, or can display multiple lines, but the data volume displayed on a display screen between lines is limited, and most of the time, accounting needs rechecking, but the current calculator does not support rechecking, and under the condition of large data, the problem of digit progression is involved, foreign counting is progressed in thousands of digits, but the Chinese is progressed in thousands of digits, and the big data is progressed in thousands of digits, so that the counting habit of the Chinese is better met.

Disclosure of Invention

The technical problems to be solved are as follows:

the carry problem of big data needs to be solved;

the data rechecking problem needs to be solved;

the problem that the page is insufficient when the data is more needs to be solved;

the switching problem of a common operation page and a function operation page needs to be solved;

the technical scheme is as follows: the hardware of the calculator for finance and accounting mainly comprises a singlechip, keys, a loudspeaker, loudspeaker wiring, a display screen, a USB interface, a USB flat cable, a power supply interface and a battery interface, wherein the singlechip is used as the hardware of a control circuit, the singlechip comprises a mainboard, a CPU, a key circuit, an external memory, an internal memory, an output buffer and an input buffer, the keys are divided into three types, namely, a numeric key, an operation key and a function key, and the numeric key refers to a 0 key, a1 key, a2 key, a3 key, a4 key, a5 key, a6 key, a7 key, an 8 key, a 9 key and a number key; the operation keys comprise an addition key, a subtraction key, a multiplication key, a division key and an equal sign key; the function keys comprise function keys, sound keys, double-core keys, power keys, self-defining keys, a previous page key and a next page key,

the key is connected with a key circuit, after the key circuit converts high and low level electric signals into digital signals, the digital signals of the key enter an input buffer, the input buffer is connected with a CPU, the digital signals are transmitted to the CPU and processed by a program, the CPU is connected with an output buffer, the digital signals are transmitted to the output buffer after being processed by the program, the output buffer is connected with a display screen, a loudspeaker and an external memory, the output buffer transmits the processed signals to the display screen to display a calculation result, the program result is stored in an instruction, the output result is stored in the external memory without the instruction and transmitted to the external memory, the program result instruction transmits signals to the loudspeaker, sound data is output to the loudspeaker to make sound, the instruction is not transmitted to the loudspeaker, the loudspeaker is connected with a loudspeaker wire, the loudspeaker wire is connected with a mainboard, and the loudspeaker can receive audio data sent by the mainboard, the special calculator for the financial accounting has a USB interface, and the USB interface passes through the USB winding displacement, and the USB winding displacement is connected with the mainboard, through the USB data line, USB inserts the USB winding displacement, and the USB winding displacement inserts the mainboard, and the special calculator for the financial accounting passes through USB data line and computer communication, and the special calculator for the financial accounting has the power supply after battery powered and the illumination voltage step down.

There are 6 signal lines under the key, these 6 signal lines can transmit two kinds of signals of high level and low level, wherein high level represents 1, then low level represents 0, otherwise, low level represents 1, then high level represents 0, the preferred scheme is that high level represents 1, low level represents 0, when pressing the key, transmit the corresponding electrical signal to the one-chip computer, convert into 0 and 1 data by the key circuit, in the 6bit data, one is the parity check code, the other 5 are used for differentiating the key, the key design lies in that these 5 binary data need to have uniqueness, namely there is not any two binary data of key are identical.

The number keys are used for inputting numbers and point numbers;

one of the operation keys is used for operating data according to the rule of an operator;

secondly, one of the program appointed operation keys is a switching key for switching the function operation page to the common operation page, after the financial accounting uses the special calculator to start and enter the function operation page, the appointed operation key is pressed to enter the common operation page before any data is input;

and thirdly: in the function operation page, data is input, the page is required to be switched to a common operation page, any one of a plus key, a minus key, a multiply key and a divide key is pressed to enter the common operation page, and after the page enters the common operation page, a program takes the operation result of a total function in the function operation as first data to participate in data operation of the common operation page;

fourthly, the method comprises the following steps: setting an operation key as a switching key of a default page by a program, after starting up, and before data is not input, double-clicking the set operation key, and switching the default page between a function operation page and a common operation page;

in the common operation page, the equal sign key is used for calculating the result according to the rule of four arithmetic operations,

in the function operation page, the function of the equal-sign key is equivalent to the function of the sum function equal-sign key, and the function operation page equal-sign key may or may not be available;

the function key is used for switching a common operation page, a function operation page and an import function, and specifically comprises the following steps:

the switching of the common operation page and the function operation page is divided into 6 types:

when the computer is started, the default of the page mode is set as a common operation page, and before any data is not input, the function key is pressed to enter the function operation page in four types, which are respectively:

type 1, pressing a function key, namely entering a function operation page, popping up a function selection page at the moment, not taking care of the function, and entering a default function operation mode after the time set by the system;

type 2, pressing the function key twice, namely double-clicking the function key, and directly entering a default function operation mode;

type 3, pressing the function key, namely entering a function operation page, at the moment, popping up a function selection page, searching a function by using a previous page key and a next page key, and after searching a relevant function, pressing the function key to enter the function operation mode;

type 4, pressing a function key, namely entering a function operation page, at the moment, popping up a function selection page, searching a function by using a previous page key and a next page key, pressing an equal-sign key after searching a relevant function, entering a function operation mode, modifying the function into a default function, and generating an identifier of the default function;

if the current page is a common operation page and related operation is already carried out, pressing function keys is divided into two types, namely:

type 5, if the equal-sign key is not pressed on the current page, the function key is pressed, and no reaction is caused;

pressing an equal-sign key on the type 6 current page, then pressing a function key, wherein the function key is divided into four types, namely entering a function operation page according to the related operations of the type 1, the type 2, the type 3 and the type 4, and leading the result of the common operation page as data into a first input box of the function operation page to participate in the operation;

the function is introduced into the system in such a way that,

the import function is divided into the following steps:

step 1: a special calculator for finance and accounting is connected into a computer by a USB interface;

step 2: opening an Excel of a computer or a Jinshan form of Jinshan office, and writing a function: or writing a function by using text processing software;

and step 3: writing function name by using one form, writing brief description of the function by using another form, after writing, pressing function key 2, making the financial accounting use storage chip of special calculator communicate with computer, storing computer-written Excel function into special calculator for financial accounting, where the function name supports Chinese name and the function name is remarked function identification name, but not function identification name

When writing and importing functions, the following points need to be noted:

the key point 1, the writing of the row function can not change the attribute of the fixed function box, the row function can only use the column number and the row number of the table of the 1 st row as the table elements in the function, otherwise, errors can be generated during the importing process;

the key point 2, the writing of the column function needs to take the data after the operation in the fixed function frame in the current page as a data source, when the data is imported, the column number and the row number of the function frame of the column function need to be specified, and after the data is imported, the column number and the row number of the table of the function frame of the column function and the column number and the row number of the specified function frame have no relation;

the key point 3, the compiling of the totalizing function needs to take the data after the operation in all the fixed function boxes as the data source data, when the data is imported, the column number and the row number of the function box of the totalizing function need to be appointed, after the data is imported, the column number and the row number of the table of the function box of the totalizing function have no relation with the column number and the row number of the appointed function box;

the key point 4, recording the function, the recording function is processed by using a page turning program;

the key point 5, when a function is imported, a table of function names and a table of brief explanation need to be specified;

the key point 6, function expansion and display, when writing the function, the function import has three conditions,

the method comprises the following steps: when the method is imported into a row function, an option of whether to expand appears, the default is expansion, and the option is not expanded and only applied to the row;

when the current page is imported into the column function, an option of whether to expand appears, the default is expansion, and the option of not expanding is selected and only applied to the current page;

importing the data into a summary function without selecting whether to expand;

the recording function is not required to be written and imported, and the financial accounting special calculator takes the recording function as a built-in program part;

the sound key is pressed, and the corresponding number key and the number key are pressed, so that the corresponding sound is emitted, and the sound is emitted after the corresponding number key and the number key are pressed again;

the method comprises the steps that a recheck key is pressed, corresponding data is clicked, a checked character pattern appears at the lower right corner of the data or the data becomes a designed recheck background color, the recheck has three states, namely unchecked state, checked state and modified state, and the data cannot be input in the unchecked state, so that the data cannot be changed even if a number key is pressed, the data is clicked once in an input frame, the unchecked state becomes the checked state, and if no error exists, the data enters the recheck of the next form, if the data is found to have the error, the data is modified, the next form is entered after the data is modified, the modified form is modified, when the recheck is carried out, one column of a state column displays original data, the other column displays the result after the recheck, the page number column is unchanged, and after the recheck key is pressed, the recheck is finished;

the power key is used for turning on and turning off the power supply, and in order to prevent the power supply from being turned on or turned off by mistake, the power key is set by a program and the power supply is turned on or turned off after the power key is continuously pressed for a time set by the program;

the self-defining key is a key for expanding functions, the functions of the self-defining key are different in each function, but the functions of the self-defining key are required to be the same in the associated functions, and the self-defining key cannot be used when the functions of the self-defining key are not defined in the functions;

a clear key, wherein the program setting clear key can clear data after continuously pressing the program setting time to prevent mistaken clearing;

the previous page key and the next page key are used for searching functions and turning pages,

the page turning function can be realized in the page turning or reviewing state or the input state or the viewing state, the previous page is entered when the previous page is pressed, the next page is entered when the next page is pressed,

when searching the function, the screen area displays 10 functions at a time, the function name and the brief introduction are displayed, the function position is moved one function position at a time through the previous page key and the next page key, the page is not turned, the color of the selected function is changed, after the required function is searched, the function key is pressed down, the code of the function is displayed, after the time required by the program setting is passed, the function operation page is entered,

the function operation page is a page which inputs data by using an input frame, performs function operation by using functions in a function frame and a hidden frame, and outputs an operation result by using the function frame;

the common operation page is a page which is calculated by using number keys and operation keys according to operation rules and obtains a calculation result by using equal-sign keys;

the default page is a page automatically entered after the computer is started;

the default functions are functions which are automatically loaded if the automatically-entered page is a function operation page after the computer is started, and four default functions are respectively a default row function and a default column function; defaulting a total function and recording the function;

the row function refers to a function of which the table elements of the function are all composed of tables in the same row;

the column function is a function of adding values of all row functions of the current page, and is positioned in the status bar;

the total function and the total function are functions of adding the values of all the column functions or are formed by alternative forms of adding the values of all the column functions, and the total function is positioned in a status column;

the recording function is a paging function, and records the current page value and the total number of records;

the extension is divided into row extension, row function extension and column function extension:

the line expansion means that the line number of the next line and the next line automatically appears along with the input of data, or the line number of the next page automatically appears when the next page is pressed, and the column number is kept unchanged;

the line function expansion means that the line function is applied to the current line along with the input of data, and the line number in the table element of the line function is switched to the line number and the column number of the current line and is not changed;

the column function expansion means that when the page is turned by using the next page key, the column number in the table element on the left of the equal number in the column function is unchanged, the page number is converted into the page number of the current page, the column number in the table element on the right of the equal number is unchanged, and the line number is changed into the minimum value and the maximum value of the line number of the current page.

The desktop of the display screen is divided into two types, namely a desktop of a common operation page and a desktop of a function operation page, wherein the desktop of the common operation page is a working area of the whole screen, data and operators are directly input, and a calculation result is obtained by using equal signs.

The desktop of the function operation page is composed of a working area and a status bar, the status bar is positioned at the bottom of the working area, the working area is composed of rows and columns to form a table, cells in the table are divided into a function frame, an input frame and a hidden frame, the function frame is used for operating the data of the input frame by using a designed function and obtaining a result, the input frame is used for inputting the data, the hidden frame is one of the function frames, the hidden frame cannot be displayed on a display screen of a special calculator for finance, the status bar is composed of 1 row of tables, the tables of the status bar are all the function frames or the hidden frames, the function frames of the working area and the status bar can only be connected with a computer through a USB to write a function or use a built-in function, the function frames cannot input the data, and compared with Excel, the following differences exist:

1) the program sets a fixed function frame as a function frame, the fixed function frame is positioned on the right side of a working area, the column number of the fixed function frame set by the program cannot be modified or deleted, the number of rows and columns need to be defined when the function is written, the row number is selected to be expanded during program design, and the column number cannot be expanded after the definition of the column number is completed;

2) the line number and the column number are not displayed in the working area and the status bar, and are displayed in the background, so that the line spacing and the column width of the working area and the status bar cannot be changed at all when the financial accounting is operated by using a special calculator, and only can be modified by connecting a USB (universal serial bus) with a computer;

3) the forms of the working area are divided into a function frame, an input frame and a hidden frame, the forms of the status bar are divided into the function frame and the hidden frame, the function frame and the hidden frame are both writing functions, the data of the input frame are operated by the functions, the result after operation is displayed in the function frame, the functions of the function frame and the hidden frame can only be deleted by a computer after writing, the external functions cannot be deleted on a special calculator for finance, and the internal functions cannot be deleted on the computer, namely the internal functions are designed on a read-only memory and cannot be deleted, so that the function is prevented from being deleted by mistake;

4) the function of the working area is a row function, and the row function means that the function can only operate on the data of the same row;

5) the row number and the column number of the working area are automatically distributed by a program, only the number of rows and the number of columns are required to be appointed when the program is compiled, and the number of rows and the number of columns are appointed with upper limits; the row height is divided by the height of the working area by the designated row number, the row height is evenly distributed without designation, the column width is designated, when the column is a hidden column, no width parameter exists, and the upper limit of the column number does not include a hidden frame;

6) the status bar has only one line, the column number of the status bar is represented by capital English, the line number of the current page number, and when the status bar has a hidden frame, the hidden frame has no width parameter; when the status bar is used as a function frame, the width needs to be specified, the function frame of the status bar is set with an upper limit, the upper limit of the number of columns does not comprise a hidden frame, the status bar is specified with a fixed function frame, and the column number of the function frame specified by a program cannot be modified or deleted;

7) the functions of the status bar are divided into 3 types, namely a column function, a total function and a record function, wherein the column function is a statistical function of all the line functions of the current page, and the total function is a statistical function of the line functions of all the pages.

Writing built-in functions in the following steps;

step 1, defining the number of rows and columns;

step 2, defining an input frame, a function frame, a hidden frame and a fixed function frame, wherein only a column number needs to be specified when the input frame, the function frame and the hidden frame are defined, and after the column number is specified, all tables in the column belong to one of the input frame, the function frame, the hidden frame and the fixed function frame;

step 3, defining the row width, and defining the row width according to the actual situation;

step 4, defining data types, wherein the association function needs to pay attention to the consistency of data:

step 5, compiling a function;

step 6, appointing the expansibility of the function, and setting the function in the function to appoint the expansion;

the expansion means that the line number of the function changes synchronously along with the change of the line number;

step 7, appointing a default function, starting up each time after the default function is appointed, and displaying the function if entering a function operation page;

step 8, appointing the association with the column function and the totaling function, wherein one row function can only appoint one associated column function and the totaling function, while different row functions can appoint the same column function and the totaling function as the association function, however, it should be noted that the appointed function can not cause problems to operate, and the association refers to loading the corresponding row function and synchronously loading the associated column function and the totaling function;

the association of the row functions and the record functions, all the row functions including the built-in row functions and the external row functions are associated with the record functions, and the record functions are associated with the row functions by default, so that the association does not need to be specified;

step 9, compiling column functions, wherein the

steps

7 and 8 are omitted in the process of compiling the column functions and the row functions, and the column functions cannot be independently shown in a function operation page;

and step 10, compiling the summary function, wherein the

steps

6, 7 and 8 are reduced compared with the row function, and the summary function cannot be singly appeared in the function operation page.

The financial accounting special purpose calculator as claimed in claim 1, wherein:

writing an external function in the following steps;

step 1; setting the column number and the row number of the table, wherein the column number and the row number of the table are consistent with the column number and the row number of the built-in function setting;

step 2, compiling a line function;

step 3, selecting function expansibility, and if the function expansibility is selected to be not expanded, finishing compiling the external row function and importing the external row function into a special calculator for finance and accounting;

step 4, if the expansion is selected in the step 3, continuing the next step;

step 5, appointing the relevance between the built-in column function and the built-in total function; after the assignment, the function is associated with the built-in column function and the built-in total function;

step 6, appointing a default function, and if the default function is selected, the external function which is compiled is the default function;

step 7, pressing down a function key, and leading the external row function into a special calculator for the financial accounting;

step 8, if the selection in step 5 is no, step 9 is entered;

step 9, prompting whether to write a column function appears, if so, entering the next step;

step 10, editing and clicking help, and providing default built-in column functions and brief descriptions to a writer for reference by the system;

step 11, after the writing is finished, clicking and storing, and automatically associating column functions with the row functions written in the step 2;

step 12, popping up a summary function compiling page, and repeating the steps of step 10 and step 11;

step 13, appointing a default function, and if the default function is selected, the written external function is the default function;

step 14, pressing a function key, and leading the external function into a special calculator for the financial accounting;

and step 15, if the selection in the step 9 is no, pressing a function key, and importing the external row function into the financial accounting special calculator.

Has the advantages that: the financial accounting uses the special calculator to utilize the function technology, utilize the function to accomplish most financial accounting operation data, thus, reduce the use of operation key, at the function operation page, do not need the participation of operation key during data operation, and simultaneously, this application provides the mutual switching of function operation page and ordinary operation page, make things convenient for the operator to use, in addition, at the function operation page, data arrangement is neat, and provide the data and recheck the function, last page, next page function, can accomplish the operation of a large amount of data, utilize USB to connect the computer, through compiling external function, can expand its function.

Drawings

FIG. 1 is a schematic front view of a calculator for financial accounting;

FIG. 2 is a schematic diagram showing a top view of a calculator for exclusive use in finance and accounting;

FIG. 3 is a schematic diagram showing a rear view of a calculator for exclusive use in finance and accounting;

FIG. 4 is a schematic diagram of the basic hardware architecture of a financial accounting special-purpose calculator;

FIG. 5 is a schematic diagram showing a row function and a column function Excel;

FIG. 6 is a schematic diagram of an Excel demonstration with a carry and a hundred million carry of a row function and a column function;

FIG. 7 is a schematic diagram of an Excel demonstration with identification number input;

FIG. 8 is a schematic diagram showing the front view structure of a calculator for exclusive use in finance and accounting.

In the figure, 1 is a1 key, 2 is a2 key, 3 is a3 key, 4 is a4 key, 5 is a5 key, 6 is a6 key, 7 is a7 key, 8 is an 8 key, 9 is a 9 key, 10 is a 0 key, 11 is an equal sign key, 12 is a function key, 13 is a sound key, 14 is a double check key, 15 is a power key, 16 is a custom key, 17 is a clear key, 18 is a previous page key, 19 is a next page key, 20 is a point key, 21 is a plus key, 22 is a minus key, 23 is a multiplier key, 24 is a minus key, 15 is a USB interface, 16 is a power interface, 25 is a desktop, 251 is a work area, 252 is a status column, 26 is a USB interface, 27 is a power interface, and 28 is a battery cover.

In fig. 4, a1 shows that a key is connected to a key circuit, a2 shows that a digital signal of the key enters an input buffer, A3 shows that the digital signal is sent from the input buffer to a CPU and processed by a program, a4 shows that a result of the processing by the program enters an output buffer, a5 shows that an output result enters a display screen and shows a calculation result, a6 shows that the output result is stored in an external memory, a7 shows that voice data is output to a speaker and sounds, B1 shows that the speaker is connected to a speaker wire, B2 shows that the speaker wire is connected to a main board, C1 shows that a USB is connected to a computer, C2 shows that the USB is connected to a USB cable, C3 shows that the USB cable is connected to the main board, D shows that a battery supplies power to the main board, E shows that a lighting power supply power to the main board after the lighting.

Detailed Description

First part, terminology:

1) the number keys and number keys refer to

keys

0, 1,2, 3, 4, 5, 6, 7, 8, 9 and number keys, namely the corresponding number and number keys are marked on the keys in the figure 1.

2) The operation keys and the operation keys refer to plus keys, minus keys, multiply keys, divide keys and equal sign keys.

3) The function key and the function key refer to a function key, a sound key, a double-core key, a power key, a self-defining key, a previous page key and a next page key.

4) Function operation page: the function operation page is a page which inputs data by using the input frame, performs function operation by using functions in the function frame and the hidden frame, and outputs an operation result by using the function frame.

5) A normal operation page: the ordinary operation page refers to a page which utilizes number keys and operation keys to calculate according to operation rules and utilizes equal-number keys to obtain calculation results.

6) The input box refers to a cell for inputting data in the working area, and is defined by a row number and a column number.

7) The function frame is a cell written with a function in a working area or a status bar, the function frame of the working area is defined by a row number and a column number, the function frame of the status bar is defined by a column number and a page number, and the function frame cannot input data.

8) The hidden frame is a unit cell of a writing function hidden in a working area or a status bar, the hidden frame of the working area is defined by a row number and a column number, the hidden frame of the status bar is defined by a column number and a page number, the hidden frame cannot input data, and the hidden frame cannot be displayed in the working area.

9) The fixed function box refers to a function box which is defined by a program and cannot be modified or changed, in the example of the application, C1 is a fixed function box of a row function, X1 is a fixed function box of a column function, Y1 is a fixed function box of a summary function, Z1 is a fixed function box of a record function, in a review state, X1 is a fixed function box of a summary function before review, and Y1 is a fixed function box of a summary function after review.

10) And the working area refers to the whole screen area for the common operation page, and refers to all the lines including the input boxes and the function boxes for the function operation page.

11) And the status bar is only aimed at the function operation page, the status bar refers to a line which only contains the function frame or only contains the function frame and the hidden frame, and the status bar is positioned at the lower part of the working area.

12) The row function and the row function refer to functions of which the table elements are composed of tables in the same row.

13) The column function is a function of adding values of all the row functions of the current page, and the column function is positioned in the status bar.

14) The total function, which is a function of adding the values of all the column functions, or an alternative form of adding the values of all the column functions, is located in the status bar.

15) And recording a function, wherein the recording function is a paging function, and records the current page value and the total number of records.

16) And the default page refers to a page displayed after the computer is started.

17) The default functions are functions which are automatically loaded after a program enters a function operation page after the computer is started, and the number of the default functions is four, namely default row functions and default column functions; the functions are recorded by default to the aggregate function.

18) The functions are built-in functions and external functions, the built-in functions are functions set by a special calculator program for the financial accounting or functions stored on a read-only memory, and the external functions are functions written or downloaded by a user.

19) And (3) expanding, wherein the expanding is divided into row expanding, row function expanding and column function expanding:

19.1) line expansion means that the line number of the next line and the next line automatically appears along with the input of data, and the column number is kept unchanged; for example, when the data is input in line 48, line 49 will be displayed on the screen, the line number will be displayed only in the background, or when the next page key is pressed, the line number of the page will automatically appear, for example, 10 lines and 3 columns are designed, when the next page key is pressed, the line number of 11 to 20 lines will automatically appear, the column number of page 1 is A, B, C, page 2 is still A, B, C;

19.2) the line function extension means that as data is input, a line function is applied to a current line, and the line number in a table element of the line function is switched to be unchanged with the line number and the column number of the current line, for example, the line function is C1= SUM (a1+ B1), and when data is input on the 3 rd line, the line function is C3= SUM (A3 + B3);

19.3) column function extension means that when a page is turned by the next page key, the column number in the table element to the left of the equal sign in the column function is not changed, the page number is converted to the page number of the current page, the column number in the table element to the right of the equal sign is not changed, and the row number becomes the minimum value and the maximum value of the row number of the current page, for example, the column function is X1= SUM (C1: C10) when turning to the third page, the column function is extended to X3= SUM (C21: C30) since the current page number is 3, the current line number is 21 at the minimum and 30 at the maximum.

Second part, hardware design:

the hardware of the calculator for finance and accounting is composed of a singlechip, keys, a loudspeaker wiring, a display screen, a USB interface, a USB flat cable, a power supply interface and a battery interface, wherein the singlechip is used as a control circuit, the singlechip is composed of a mainboard, a CPU, a key circuit, an external memory, an internal memory, an output buffer and an input buffer, and the keys are divided into three types, namely, a numeric key, an operation key and a function key.

The design of data transmission line of the key, this application has 24 keys, from the keyboard technology, there are two kinds of full code keyboard and non-code keyboard, the keyboard is already known technology, the applicant briefly states, there are 6 signal lines, these 6 signal lines can transmit two kinds of signals of high level and low level, wherein high level represents 1, then low level represents 0, otherwise, low level represents 1, then high level represents 0, the preferred scheme is that high level represents 1, low level represents 0, when pressing the key, transmit the corresponding electrical signal to the one-chip computer, convert into 0 and 1 data by the key circuit, in the 6bit data, one is the parity check code, the other 5 represent data, a preferred design scheme is: 00000-0 key, 00001-1 key, 00010-2 key, 00011-3 key, 00100-4 key, 00101-5 key, 00110-6 key, 00111-7 key, 01000-8 key, 01001-9 key, 01010-dot key, 01011-plus key, 01100-minus key, 01101-multiply key, 01110-divide key, 01111-power key, 10000-self-defining key, 10001-clear key, 10010-previous page key, 10011-next page key, 10100-equal number key, 10101-function key, 10110-voice key, 10111-review key, the front part represents the binary data of the key, and the rear part represents the key.

The function of the key is as follows:

the function of the number keys, the number keys are the numbers on the input key labels, and are common knowledge.

The operation key is common knowledge and operates data according to the rules of programmed operators, and in addition, the operation key is used as a switching key of a function operation page and a common operation page, and the operation key is specifically as follows:

if the default operation page of the special calculator for finance is set as a function operation page, after the special calculator for finance is started, the function operation page is entered, at this time, if the ordinary operation page needs to be entered, an operation key needs to be pressed, and since the application of the division key is less, the division key is preferably used as a switching key of the function operation page and the ordinary operation page, the application provides that A1 has no input data, and other input boxes can not input data, therefore, the programming idea is designed that, if A1 is equal to null, the division key is clicked, the ordinary operation page is entered, that is, if an if judgment statement is used, after the ordinary operation page is entered, data and operation keys need to be input, and the result is obtained by using the equal-sign keys, for example, 25+45-12=58, 58/2=29, 29 x3= 87.

In the function operation page, if data is input, switching to a normal operation page is required, and a judgment statement is also used, in the function operation page, if A1 is not empty, any one of a plus key, a minus key, a multiply key and a divide key is pressed, then the operation is carried out in the normal operation page, and after the operation is carried out in the normal operation page, a program takes the operation result of a total function in the function operation as first data to participate in the operation.

Application example, a batch of corns is purchased at present, the total number of the corns is 49 weight data, obviously, the prices of the corns are the same, when the calculator is used for calculating, the 49 weight data needs to be added and then multiplied by unit price, if the function operation is adopted, the 49 weight data is added by an adding function, then the operation is switched to a multiplying function, the result in the adding function is used as a multiplier and multiplied by the unit price, the operation is troublesome, therefore, after the 49 weight data is calculated, only a multiplier key needs to be pressed, at the moment, the program only uses the result obtained by the summing function as a multiplier, only the unit price and a number key need to be input, the total price is obtained according to the common operation, for example, the result of the 49 weight data is 3468kg, the unit price is used as a multiplier, after the number key is pressed, the display state of a common page is 3468, and therefore, only the unit price needs to be input, e.g. 1.7, and then pressing the equal-sign key, the total price is obtained, i.e. 3468 x 1.7= 5895.6.

The default page is changed, no matter the default page is set as a function operation page or a common operation page, after the computer is started, an operation key needs to be double-clicked before data is not input, because the application of the number-dividing key is less, the preferred scheme is to use the number-dividing key as a switching key of the default pages of the function operation page and the common operation page, after the number-dividing key is double-clicked, the current default page is the function operation page, whether the prompt is to be switched to the common operation page is given, the default page is switched to the common operation page, otherwise, the current default page is the common operation page, whether the prompt is to be switched to the function operation page is given, and the default page is switched to the function operation page.

Bond number equal:

in the common operation page, the function of the equal-sign key is to calculate the result according to the rule of the four arithmetic operations, which is common knowledge.

In the function operation page, the function of the equal-sign key 1 is equivalent to the function of the equal-sign key of the summation function, according to the function operation rule, when the next data is input, the operation result of the previous data is already come out, for example, when the 48 th data is input, the operation result of the first 47 data is already come out, if we only need to input 48 data, then click the next input box, the operation result of the 48 data is already calculated, the operation result of the summation function can obtain the result through the equal-sign key or click the next input box, in the function operation page, the equal-sign key is available or unavailable, when the equal-sign key is used in the following two cases, an error occurs, one is that the divisor is 0, and the other is that only one multiplier is input in the multiplication operation.

Function key:

the switching of the normal operation page and the function operation page is classified into the following types,

when starting up, if the default of the page mode is set as a common operation page, and before any data is not input, pressing the function key to enter the function operation page in 4 types, respectively:

and type 1, pressing a function key, namely entering a function operation page, popping up a function selection page at the moment, rejecting a reason, and entering a default function operation mode after four seconds.

And 2, pressing the function key twice, namely double clicking the function key, and directly entering a default function operation mode.

And type 3, pressing a function key, namely entering a function operation page, popping up a function selection page, searching a function by using a previous page key and a next page key, and then pressing the function key to enter the function operation mode after searching a relevant function.

And 4, changing a default function, pressing a function key to enter a function operation page, popping up a function selection page, searching a function by using a previous page key and a next page key, pressing an equal-sign key after searching a relevant function, changing the function into the default function, generating a default function identifier, and entering the function operation mode.

if the equal sign key is not pressed on the type 5 and the current page, the function key is pressed, and no reaction is caused, for example, the current operation is 23+49 × 58, and at this time, the function key is pressed, and the function operation page cannot be successfully switched to.

The type 6 and current pages are pressed by an equal sign key, then function keys are pressed, the function keys are divided into three types, namely, the function operation pages are entered according to related operations of

types

1,2, 3 and 4, and the result of the common operation page is imported into an A1 input box as data to participate in operation, for example, the current operation is 23+49 × 58=2865, it is noted that four operations require multiplication and then addition, which is common knowledge, and after entering the function operation pages, 2865 is imported into an A1 input box.

Importing a function, accessing a special calculator for a financial accounting into a computer by using a USB interface 15, opening an Excel or Jinshan table of Jinshan office of the computer, writing the function, writing a function name by using one table, writing a brief description of the function by using another table, after writing is finished, pressing a function key 2, communicating the financial accounting with a storage chip of the special calculator with the computer, storing the Excel function written by the computer into the special calculator for the financial accounting, wherein the function name supports Chinese names, and the function name is not a function, and the function itself must be written in a format strictly conforming to the Excel function, for example, the function C1= SUM (A1+ B1), the function name is an addition function, the brief description adds data of the table A1 and the table B1, the function C1= SUM (A1 x B1), the function name is an addition function, the brief description multiplies data of the table A1 and the table B1 by the function, the function name of the financial special calculator does not refer to the function name of the SUM, but refers to the name of the remarked function,

when writing and importing functions, the following points need to be noted:

the point 1, writing of a row function cannot change the attribute of a fixed function box, and the row function can only use the column number and the row number of the table in the 1 st row as table elements in the function, otherwise, errors occur during import, for example, only C1= SUM (a1+ B1), C2= SUM (a1+ B1), C1= SUM (a1+ B5), B2= SUM (a1+ D4) can not be written, otherwise, it is troublesome to process with a special calculator program.

Point 2, writing of column functions requires C1 to C10 data as data sources, for example, C11= SUM (C1: C10), or D11= SUM (C1: C10), when importing, it is necessary to specify the column number and row number of a function box, for example, if the column function is D11= SUM (C1: C10), then it is specified that D11 is the column number and row number of the function box, if the column function is C11= SUM (C1: C10), then it is specified that C11 is the column number and row number of the function box, after importing, the column number and row number of the table of the function box of the column function are unrelated to the column number and row number of the specified function box, and it is necessary to set a dedicated table for processing column functions by a dedicated calculator program.

To write the summary 3 and summary function, C1 to CN data are used as data sources, for example, C11= SUM (C1: CN), or D11= SUM (C1: CN), N is the total number of records, when importing, the column number and row number of the function box need to be specified, for example, if the column function is D11= SUM (C1: CN), D11 is specified as the column number and row number of the function box, if the column function is C11= SUM (C1: CN), C11 is specified as the column number and row number of the function box, after importing, the column number and row number of the table of the function box of the statistical function are unrelated to the column number and row number of the specified function box, a special calculator program is used to set a special table processing column function, and after importing, the program processes N in CN to the total number of data.

And 4, recording a function, wherein the recording function is processed by utilizing a page turning program.

Point 5, when importing a function, it is necessary to specify a table of function names and a table of brief descriptions, for example, the table of function names is E4, the table of brief descriptions is F4, after importing, the table of function names is irrelevant to E4, the table of brief descriptions is irrelevant to F4, and the financial accounting uses a special calculator program to set a special table to process the function names and brief descriptions.

Function expansion and display, when writing a function, function import has three conditions,

the method comprises the following steps: importing to a row function, namely to the table C1, will have an option of whether to expand, default to expand, and select not to expand, and only apply to the row;

importing to the column function, i.e., the X1 column of the status bar, importing to the table, the option of whether to expand appears, default is to expand, and the option of not expanding is applied only to the current page.

And importing the data into the aggregation function without selecting whether to expand the data.

The Z column is a recording function of the current page, is compiled by a paging program, has single function, and is a built-in function due to the difficulty of compiling the paging function.

The applicant illustrates that, after 20 data are inputted in columns a and B, there is no way to input the data again, at this time, the next page key is pressed, the input is continued, after the input is full, the one page key is pressed continuously, until the data input is completed, the equal number key is pressed, the operation result of the column function and the operation result of the summation function can be seen, the page turning is performed by using the previous page key and the next page key, the result of the summation function is always constant, and the column function result changes with the page turning, that is, the column function result is the data sum of the row functions of the current page, the summation result is the sum of the column function results, and when the next page key is pressed, the result of the previous page has been operated, the summation result is displayed as the already operated data sum, but the operation result of the last 1 line is displayed, in order to prevent the result from being wrong, the program gives a prompt to remind the operator, the operator presses the equal-number key or clicks the next input box, the program recalculates the result, the operator gives no visual prompt, and after the prompt box is closed, the power key is pressed again, and the power supply is closed.

The data of the function operation page and the common operation page are reserved, after the function operation page is switched to the common operation page, the related data of the function operation page is not lost, and after the function operation page is switched to the function operation page again, the related data is displayed, even if the related data is removed from the common operation page, the removed related data is only the related data of the common operation page, otherwise, after the common operation page is switched to the function operation page, the related data of the common operation page is not lost, and after the common operation page is switched to the common operation page again, the related data is displayed, even if the related data is removed from the function operation page, the removed related data is only the related data of the function operation page, however, if the power key is pressed, the computer is started again, and no data exists.

And the sound key is pressed, the corresponding number key and the number key are pressed, the corresponding sound is sent out, the sound is canceled by pressing once again, and the sound key is an on-off key, namely is used for controlling the opening and closing of the sound file.

A review key is pressed, the corresponding data is clicked, the checked character appears on the lower right corner of the data or becomes the background color of the designed review, for example, the red background color is designed to be checked, the white background color is unchecked, the input box becomes the red background color as long as the input box where the data is located is clicked,

the recheck has three states, namely unchecked, checked and modified, and data cannot be input in the unchecked state, so that the data cannot be changed even if a number key is pressed, the unchecked state is changed into the checked state when an input frame is clicked once, the recheck of the next table is entered if no error exists, if the data is found to have the error, the data is modified, the next table is entered after the data is modified, the modified table shows the modified data, when the recheck is performed, the original data is displayed in the X column of the state column, the result after the recheck is displayed in the Y column, it needs to be noted that after the recheck is modified, the data in the X column of the state column is changed immediately, and after the recheck is completed, a recheck key is pressed, and the recheck is finished.

The power key is used for turning on and turning off the power supply, and in order to prevent the power key from being touched by mistake and turned on or turned off, the power key needs to be continuously pressed for 4 seconds to turn on or turn off the power supply.

The function of the self-defining key is different in each function, but the function of the self-defining key must be the same in the associated function, and the self-defining key cannot be used when the function of the self-defining key is not defined in the function.

The clear key is a big defect that contents can be cleared only by pressing the clear key of a common calculator, because the existing calculator can not input too much data, the clear key of the application is the same as the power key, and the data can be cleared only by continuously pressing for four seconds, so that mistaken clearing is prevented.

The previous page key and the next page key are used in searching functions and turning pages, and it is noted that there is a difference in the usage in searching functions and turning pages,

page turning, rechecking, inputting and checking can be realized, when the previous page is pressed down, the previous page is entered, when the next page is pressed down, the next page is entered,

when searching the function, the screen area displays 10 functions at a time, the function name and the short introduction are displayed, the function position is moved one time through the previous page key and the next page key, the page is not turned, the color of the selected function is changed, after the required function is searched, the function key is pressed, the code of the function is displayed, the function comprises the association function, and after 4 seconds, the function enters the function operation page.

Introduction of parts function

A USB interface, which is an interface used for communicating with a computer, and is a preferred scheme used for communicating with the computer,

the power interface is used for supplying power to the calculator special for the financial accounting, the power supply adopts two power supply modes of battery power supply and illumination power supply,

and a third part: designing software:

the desktop of the display screen is divided into two types, namely the desktop of a common operation page and the desktop of a function operation page, the desktop of the common operation page is a working area, the whole screen is directly used for inputting data and operators, the desktop of the function operation page consists of the working area and a status bar, the status bar is positioned at the bottom of the working area, the working area consists of rows and columns to form a table, the table is divided into a function frame, an input frame and a hidden frame, the function frame is used for operating the data of the input frame by using a designed function and obtaining a result, the input frame is used for inputting data, the hidden frame is one of the function frames, the hidden frame cannot be displayed on the display screen of the financial accounting special calculator, the status bar consists of 1 row of tables, the tables of the status bar are both function frames or hidden frames, and the function frames of the working area and the status bar can only be connected with a computer through a USB to write functions, the function box can not input data, the software of the application is a reduced version of an Excel or Jinshan form, or a kernel which refers to the Excel or the Jinshan form, and the description is given based on the Excel software, so that the following differences exist compared with the Excel software;

1. when writing a program, the row number of the working area is represented by Arabic numerals, the column number is represented by English capital letters, a row number and a column number represent a table, the column number is in front of the table, the column number of the status bar is represented by English capital letters, the row number is represented by the page number of the current page, the working area program specifies C column as a function column, the C column is positioned at the right side of the working area, the column number of the function frame specified by the program cannot be modified and deleted, the rest columns are increased in the sequence of English letters, the same as Excel, except that when writing a function, the row number and the column number need to be defined, the row number is selected to be expanded during program design, the column number cannot be expanded after the definition is completed, for example, the row number is defined as 10, the column number is defined as 3, when turning a page next, the column number is increased by 10 rows each time, the column number is still 3, the tables on page 1 are A1, B1, C1 to A10, b10, C10, page 2 tables a11, B11, C11 to a20, B20, C20, and so on.

2. The line number and the column number are not displayed in the working area and the status bar, and are displayed in the background, so that the line spacing and the column width of the working area and the status bar cannot be changed at all when the financial accounting is operated by using a special calculator, and only the line spacing and the column width can be modified by connecting a USB (universal serial bus) with a computer.

3. The forms of the working area are divided into a function frame, an input frame and a hidden frame, the forms of the status bar are divided into the function frame and the hidden frame, the function frame and the hidden frame are all writing functions, the data of the input frame are operated by the functions, the operation result is displayed in the function frame, the functions of the function frame and the hidden frame can only be deleted by a computer after being written, the external functions cannot be deleted on a special calculator for finance, and the internal functions cannot be deleted on the computer, namely the internal functions are designed on a read-only memory and cannot be deleted, so that the function is prevented from being deleted by mistake.

4. The function of the work area is a row function, which means that the function can only operate on the data of the same row, for example, a table is defined as 3 columns A, B, C and 10 rows, a1 and B1 in the 1 st row 3 tables are input boxes, and C1 is a function box, so that the function written by C1 can only be C1= function (a1 "operator" B1) and cannot be C1= function (A3 "operator" B5), wherein the function represents the function.

5. The row number and the column number of the working area are automatically distributed by a program, only the row number and the column number need to be specified when the program is written, the C column is specified as a function column, for example, 10 rows and 3 columns are needed, the row number and the column number do not need to be specified, and the default is 10 rows and 3 columns; and the number of rows and columns is specified with an upper limit; the row height is divided by the working area height by the designated row number, the row height is evenly distributed without designation, the column width is designated, when the column is a hidden column, the width parameter is not provided, the upper limit of the column number does not comprise a hidden frame, for example, the maximum specified column number can only be set to 5 columns, the 5 columns refer to an input frame and a function frame, and if the specified column number is 7 columns, two columns are designated as the hidden frame.

6. The status bar has only one line, the column number of the status bar is represented by capital English, the line number of the current page number, and when the status bar has a hidden frame, the hidden frame has no width parameter; when the status bar is used as a function frame, the width needs to be specified, the function frame of the status bar is set with an upper limit, the upper limit of the column number does not comprise a hidden frame, the status bar specifies X, Y, Z three function frame column numbers, and the function frame column number specified by the program cannot be modified or deleted.

7. The functions of the status bar are divided into 3 types, namely a column function, a summation function and a recording function, wherein the column function is a statistical function of all the line functions of the current page, the summation function is a statistical function of the line functions of all the pages, for example, the program is designed to be 10 lines and 3 columns, 97 records are provided in total, when the page 2 is turned, the column function performs statistics on 11 to 20 records, when the page 3 is turned, the column function performs statistics on 21 to 30, and the summation function is a statistical result of the 97 records no matter which page is turned, the recording function records the current page and the number of the records through a page turning program, it needs to be noted that the money is limited by the screen size of a special calculator, therefore, 10 lines or 5 lines are preferentially adopted during the program design, so that the recording function only displays the number of the pages, does not display the number of the records and the number of the data, otherwise, the table occupied width of the recording function is too wide, resulting in insufficient pages.

The function box, the input box and the hidden box are in relation to the column number, the function box, the input box and the hidden box refer to a single table, and the attributes of the function box, the input box and the hidden box in each column of the working area are the same, for example, a1 is the input box, then a10 is the input box, that is, the function box, the input box and the hidden box are defined only by the column number.

Example 1, built-in function:

to illustrate the principle of embodiment 1, the applicant makes two simple Excel forms by using Excel, and inputs 20 data, where the 20 data are 23, 46, 89.23, 57, 56, 69, 89, 36, 53, 44, 78, 39, 92, 37, 77, 58, 67, 91, 31, respectively, fig. 5 is a screenshot of the two forms, the upper part of the screenshot is the result of adding the 20 numbers two by two, the following table is the result of multiplying the 20 numbers two by two, and it should be clear to the person who has learned the Excel form, which is realized by using the function SUM of Excel, that is, the boxes from a1 to a10, from B1 to B10 are input boxes, and from C1 to C10 are function boxes, and thus are the following 10 functions,

C1=SUM(A1+B1)；C1=SUM（A1×B1）；

C2=SUM(A2+B2)；C2=SUM（A2×B2）；

C3=SUM(A3+B3)；C3=SUM（A3×B3）；

C4=SUM(A4+B4)；C4=SUM（A4×B4）；

C5=SUM(A5+B5)；C5=SUM（A5×B5）；

C6=SUM(A6+B6)； C6=SUM（A6×B6）；

C7=SUM(A7+B7)；C7=SUM（A7×B7）；

C8=SUM(A8+B8)； C8=SUM（A8×B8）；

C9=SUM(A9+B9)； C9=SUM（A9×B9）；

C10=SUM(A10+B10)；C10=SUM（A10×B10）。

however, the Excel table function is very flexible, for example, an expression of C3= SUM (a5+ E7) is also true, and the function can be easily deleted, and the built-in function has some differences from the Excel function:

the built-in functions are divided into row functions, column functions, total functions and recording functions, wherein the number of the row functions is 5, and the number of the row functions is respectively as follows:

row function 1, C1= SUM (a1+ B1);

row function 2, C1= SUM (a1+ B1+ D1);

row function 3, C1= SUM (a1+ B1+ D1+ E1);

row function 4, C1= SUM (a1 × B1);

row function 5, C1= SUM (a1 × B1+ D1 × E1);

step 1, defining the number of rows and the number of columns, wherein the number of rows defined by the 5 row functions is 10, and the number of columns is 3 columns for the

row function

1,4 columns for the

row function

2, 5 columns for the

row function

3, 3 columns for the

row function

4, and 5 columns for the row function 5.

And 2, defining an input frame, a function frame and a hidden frame, wherein when the input frame, the function frame and the hidden frame are defined, only column numbers are required to be specified, the column numbers on the left side of the function equal number are defined as the function frame in a default mode, the column numbers on the right side are defined as the input frame, the built-in function is not provided with the hidden frame, and after the column numbers are specified, all tables in the column belong to one of the input frame, the function frame and the hidden frame.

And 3, defining the row width, and defining the row width according to the actual situation.

And 4, defining data types, wherein the data types of all columns of the row function 1, the row function 2 and the row function 3 are currency or numbers, the data types of columns A and D of the row function 4 and the row function 5 are currency or numbers, and columns B and E are numbers.

Step 5, writing a function, wherein in the Excel, the written function does not have a part on the left of the equal sign, but the complete function comprises the part on the left of the equal sign, and writing the function is to write the 5 functions.

Step 6, specifying the expansibility of the function, wherein the built-in function needs to specify the expansion, if the expansion is not specified, the line function only acts on the current line data, for example, C1= SUM (A1+ B1), if the expansion is not specified, the function only operates the data input in A1 and B1, after the expansion is specified, a series of functions are actually generated,

C1=SUM(A1+B1)；

C2=SUM(A2+B2)；

C3=SUM(A3+B3)；

C4=SUM(A4+B4)；

C5=SUM(A5+B5)；

C6=SUM(A6+B6)；

C7=SUM(A7+B7)；

C8=SUM(A8+B8)；

C9=SUM(A9+B9)；

c10= SUM (a10+ B10) up to CN = SUM (AN + BN), N being the total number of row numbers;

the expansion means that the line number of the function is changed synchronously along with the change of the line number, manual generation is needed in an Excel table, and a series of functions are automatically generated.

And 7, a default function is appointed, the computer is started every time after the default function is appointed, if a function operation page is entered, the function is displayed, and the default function can be changed.

For example, if row function 1 is designated as the default function, then the function calculation page is entered after power-on, and the table of the display screen is the same as that of fig. 5 except that there is no row number and no column number.

Step 8, specifying the association with the column function and the summation function, it should be noted that one row function can only specify one associated column function and summation function, and different row functions can specify the same column function and summation function as the association function, but it should be noted that the specified function cannot ensure that the operation is not problematic, for example, row function 1 specifies the data type as currency, then column function 1 or column function 2 is not problematic, but column function 3 is problematic because the currency data type has more dot numbers plus two decimal places, and the character strings intercepted by right (2345, 4) and right (2345.00, 4) are 2345 and 5.00 respectively, which may cause operation errors.

And the association of the row functions and the record functions, all the row functions including the built-in row functions and the external row functions are associated with the record functions, and the default of the record functions is associated with the row functions, so that the check is not needed.

The application of the line functions 1 to 5 in real life, the line functions 1 to 3 are addition, namely, several data are added, the difference is the number of input boxes, the situation is common, but in real life, another common situation exists, namely unit price and total price, if 10 goods are currently carried in, a column is unit price per piece, B column is number of pieces, a staff needs to calculate total SUM of the advance prices, and the Excel table is adopted to modify 'C1 = SUM (a1+ B1)' into 'C1 = SUM (a1 × B1)', so that the line function 4 is the line function 5, the line function 5 and the line function 4 are also products of the unit price and the number of pieces, and only the line function 5 can calculate the product of the unit price and the number of pieces of two goods.

Column functions, in fig. 5, C11 also has data, C11 in the above table has data of 1215.23, the data in the following table has data of 35172.11, Excel tables are all based on the same formula C11= SUM (C1: C10), i.e., the data of tables C1 to C10 are added, and the financial accounting calculator uses a function block input function of a status bar to count the data of the C column, for example, X1= SUM (C1: C10).

From the two tables, it can be seen that the amount of money involved is not very large, if data such as 35687821.23 is used, it may be necessary for the financial staff to see for a long time, and even to check for errors, it is quite clear that the situations are many when bank staff meet the data, and if 35687821.23 is modified into 3568 ten thousand 7821 yuan 2 jiao 3 min, however, the calculator at present does not generally have the function, and the function is implemented by using functions, and 2 functions are respectively:

the column function 1:

X1=SUM(C1：C10)

column function 2:

X1=IF(MID(RIGHT(SUM(C1:C10),2),1,1)=".",F1,IF(MID(RIGHT(SUM(C1:C10),3),1,1)=".",D1,E1))。

however, this column function cannot be implemented alone, and therefore, three hidden frames are required to be set in the status bar for writing three functions, and the row number of the three hidden frames is set as the current page number 1, and the column number is set as D, E, F, so that three functions are obtained;

the following functions 2.1:

d1= IF (SUM (C1: C10) > =1000000000000, "input over range",

IF (SUM (C1: C10) > =100000000, LEFT (SUM (C1: C10), LEN (SUM (C1: C10)) -11) & "hundred million" &

RIGHT (LEFT (SUM (C1: C10), LEN (SUM (C1: C10)) -7),4) & "Wan" & MID (RIGHT (SUM (C1: C10),7),1,4) & "

Meta "& MID (RIGHT (SUM (C1: C10),2),1,1) &" Angle "& RIGHT (SUM (C1: C10),1) &"

Score ", IF (SUM (C1: C10) > =10000, LEFT (SUM (C1: C10), LEN (SUM (C1: C10)) -7) &"

Wan "& MID (RIGHT (SUM (C1: C10),7),1,4) &" Meta "& MID (RIGHT (SUM (C1: C10),2),1,1) &"

Angle "& RIGHT (SUM (C1: C10),1) &" Scoring ", MID (RIGHT (SUM (C1: C10),7),1,4) &"

Meta "& MID (RIGHT (SUM (C1: C10),2),1,1) &" Angle "& RIGHT (SUM (C1: C10),1) &" Branch "))).

Column function 2.2:

e1= IF (SUM (C1: C10) > =1000000000000, "input over range",

IF (SUM (C1: C10) >100000000, LEFT (SUM (C1: C10), LEN (SUM (C1: C10)) -8) & "hundred million" &

RIGHT (LEFT (SUM (C1: C10), LEN (SUM (C1: C10)) -4),4) & "ten thousand" &

RIGHT (SUM (C1: C10),4), IF (SUM (C1: C10) > =10000, LEFT (SUM (C1: C10), LEN (SUM (C1: C10)) -4) & "ten thousand" &

RIGHT (SUM (C1: C10),7), RIGHT (SUM (C1: C10),4))) & "Yuan".

Column function 2.3:

f1= IF (SUM (C1: C10) > =1000000000000, "input over range",

IF (SUM (C1: C10) > =100000000, LEFT (SUM (C1: C10), LEN (SUM (C1: C10)) -10) & "hundred million" &

RIGHT (LEFT (SUM (C1: C10), LEN (SUM (C1: C10)) -6),4) & "ten thousand" & MID (RIGHT (SUM (C1: C10),6),1,4) & "meta" & RIGHT (SUM (C1: C10),1) & "corner", IF (SUM (C1: C10) > = 10000), LEFT (SUM (C1: C10), LEN (SUM (C1: C10)) -6) & "ten thousand" & MID (RIGHT (SUM (C1: C10),6),1,4) & "meta" & RIGHT (SUM (C1: C10),1) & "corner", MID (RIGHT (SUM (C1: C395), 1,4) & meta "& SUM (C4623) & C57323), and angle" & MID (C1).

In addition, the numbers "hundred", "ten thousand" and "element" can be programmed to realize special colors for identification.

The above function states:

for convenience of understanding, the applicant compares the three types by using the screenshots, and referring to fig. 6, there are three types of currency data of the calculator, which are respectively only integers, one decimal, and two decimal, and accordingly, the calculated results are respectively 'element angle division', 'element angle', and 'element angle', so that the column functions 2.1, 2.2, and 2.3 correspond to the three types of currency data, namely 'element angle division', 'element' and 'element angle'.

The programmed meaning of the column function 2 is: if the data of SUM (C1: C10) is intercepted by the RIGHT function for two bits, namely the last two bits of the data, then intercepted by the MID function for 1 bit, and the value is the point number, the result of the cell F1 operation is displayed, if the data of SUM (C1: C10) is intercepted by the RIGHT function for three bits, namely the last three bits of the data, then intercepted by the MID function for 1 bit, and the value is the point number, the result of the cell D1 operation is displayed, otherwise, the result of the cell E1 operation is displayed.

The programmed meanings of the column functions 2.1, 2.2, and 2.3 are the same, that is, the data of the SUM (C1: C10) is divided into four cases of > =1000000000000, > =100000000, > =10000, and less than 10000 using the judgment statement, and the character strings are respectively intercepted, except that the starting and ending positions of the intercepted character strings are different.

Summary function:

the total functions are also 2, when the difference between the total functions and the column functions lies in statistical data, the column functions perform statistics on the current page, and the total functions perform statistics on all data, and the functions are as follows:

summary function 1:

y1= SUM (C1: CN), where N in CN represents the total number of records.

Summation function 2:

y1= IF (MID (RIGHT (SUM (C1: CN),2),1,1) = ".", FF1, IF (MID (RIGHT (SUM (C1: CN),3),1,1) = ".", DD1, EE1)), where N in CN represents the total number of records.

Similarly, the aggregate function requires the design of three hidden frames, which are illustrated as FF1, DD1, EE1, to write three functions, which differ from the column function 2.1, column function 2.2, column function 2.3 in that C10 becomes CN, where N in CN represents the total number of records.

The method comprises the steps of recording a function, wherein the function records the current page number through a page turning program, the function can also record the number of data, the starting and stopping number of the current record and the like, and because a special calculator screen for finance and accounting is limited, only the current page number is displayed in the attached figure 1 of the application.

The default function of the built-in function and the external function is converted, after a financial accounting is accessed into a computer by a special calculator, the default function option is clicked, after the default function is selected, the original default function is replaced, the default function only has one item, after the system is started every time, the system is initialized, the calculation formula of the default function is formed, the default function has an associated function, and the associated function and the default function appear at the same time.

For example, a unit of accounting has a lot of data, the default row function 1 only has A1 plus B1 as data input boxes, and an accounting uses the row function 3 as a default function to enhance the availability of a special calculator for financial accounting, so that 4 data can be input in one row.

The function is externally arranged on the basis of the function,

the external functions are self-written functions which can be deleted and modified, the external functions are various in types and complex in conditions, and the external functions are divided into row functions, column functions and total functions.

Writing an external function requires the following steps, and the writing of a SUM function is taken as an example for explanation;

example 2:

step 1; the column number and row number of the table are set, and it is noted that the column number and row number setting of the table is consistent with the column number and row number of the built-in function setting.

Step 2, write row functions, example function C1= SUM (a1+ B1 × D1+ E1).

And 3, selecting the function expansibility, and if the function expansibility is selected to be not expanded, finishing the external row function compiling and importing the external row function into the special calculator for the financial accounting.

And 4, if the expansion is selected in the step 3, continuing the next step.

Step 5, appointing relevance with built-in column function; after assignment, the column function is associated with the embedded column function.

And 6, specifying a default function, and if the selection is yes, writing the external function as the default function.

And 7, pressing a function key, and importing the external row function into the financial accounting special calculator.

And 8, if the selection in the step 5 is no, the step 9 is entered.

And 9, prompting whether to write a column function or not, and entering the next step if the column function is selected.

Step 10, editing and clicking help, and the system provides the default built-in column function and brief description to the writer for reference.

And step 11, after the writing is finished, clicking to store, and automatically associating the column function with the row function written in the step 2.

And step 12, popping up a summary function compiling page, and repeating the steps of step 10 and step 11.

And step 13, a default function is appointed, and if the default function is selected, the written external function is the default function.

And step 14, pressing a function key, and importing the external function into the financial accounting special calculator.

Example 3, the financial accounting uses a special calculator to calculate the ID number, in this example, a prompt page of the ID number input error, date of birth, sex, and the number of males and females need to be counted on a counting page,

step 1, setting the column number and the row number of a table, setting a working area as 10 rows and 6 columns, setting A1 as an input box, B1 and F1 as hidden boxes, setting C1, D1 and E1 as function boxes, setting a status column as 3 function boxes, keeping the column number unchanged, setting the column number as X, Y, Z, setting X1 statistical male number, Y1 statistical female number, setting Z1 as a recording function, inputting an identity card number into an A1 cell, setting a C1 cell as an identity card number error-inputting prompting cell, setting a D1 cell as a year and month cell, and setting an E1 cell as a gender cell.

Step 2, inputting a row function, which respectively comprises the following steps:

b1 column input function:

B1=LOOKUP(MOD(SUM(MID(A1,1,1)*7+MID(A1,2,1)*9+MID(A1,3,1)*10+MID(A1,4,1)*5+MID(A1,5,1)*8+MID(A1,6,1)*4+MID(A1,7,1)*2+MID(A1,8,1)+MID(A1,9,1)*6+MID(A1,10,1)*3+MID(A1,11,1)*7+MID(A1,12,1)*9+MID(A1,13,1)*10+MID(A1,14,1)*5+MID(A1,15,1)*8+MID(A1,16,1)*4+MID(A1,17,1)*2),11),{0,1,2,3,4,5,6,7,8,9,10},{"1","0","X","9","8","7","6","5","4","3","2"})

c1 cell input function: c1= IF (B1= F1, "error").

D1 cell input function: d1= MID (a1,7,4) & "year" & MID (a1,11,2) & "month" & MID (a1,13,2) & "day".

E1 cell input function: e1= IF (C1= "error", IF (MOD (MID (a1,17,1),2) =1, "male", "female")).

F1 cell input function: f1= RIGHT (a1, 1).

Step 3, selecting expansibility which needs to be expanded;

step 4, appointing relevance with built-in column function; selecting no;

step 5, appointing a default function, and if yes is selected, the external function which is written is the default function; if no, the original default function will not be changed, and no matter whether yes or no is selected, the step 6 is carried out;

step 6, entering a function editing page, editing functions of the function boxes X1 and Y1, entering an editing state, writing the functions,

x1 column input function: x1= "male is" & COUNTIF (E: E, "male") & "person".

Y1 is the input function: y1= "female is" & count (E: E, "female") & "human".

Step 7, after the writing is finished, clicking and storing, and automatically associating the function written in the step 6 with the line function written in the step 2;

and 8, pressing a function key, and leading the external function into the special calculator for the financial accounting.

Example 4, automatic continuous input of fixed length data:

in the Excel table, data can be input only by clicking the table when the data needs to be input, and for partial data, the data has fixed length, such as identification number, unified social credit code is 18 bits, mobile phone number is 11 bits, and patent number is 13 bits.

The data length is input by limiting the form, for example, the data length of the input identity card number is 18 bits, when 19 bits are input, the next form is automatically jumped to, and the process is circularly carried out later, so that the form does not need to be clicked, the form is automatically changed, and certainly, if the input personnel does not finish inputting 18 bits and enters the input of the next identity card number, a new problem is generated, therefore, the validity check is also needed, a validity check method is already recorded in the embodiment 3, the validity check can be carried out on the patent number with the verification code, the input error is prevented, but the mobile phone number does not have the validity check code, the input error is not checked, only one method is provided, the first bit of the current mobile phone number is 1, and therefore, whether the input error exists is checked by checking whether the first bit is 1.

For example, using the following function check, B1= IF (LEFT (a1,1) < > "1", "error", "") enters a cell phone number in a1, which checks whether the first digit entered is 1.

Claims

1. A calculator special for financial accounting is characterized in that: the hardware of the calculator for finance and accounting mainly comprises a singlechip, keys, a loudspeaker, loudspeaker wiring, a display screen, a USB interface, a USB flat cable, a power supply interface and a battery interface, wherein the singlechip is used as the hardware of a control circuit, the singlechip comprises a mainboard, a CPU, a key circuit, an external memory, an internal memory, an output buffer and an input buffer, the keys are divided into three types, namely, a numeric key, an operation key and a function key, and the numeric key refers to a 0 key, a1 key, a2 key, a3 key, a4 key, a5 key, a6 key, a7 key, an 8 key, a 9 key and a number key; the operation keys comprise an addition key, a subtraction key, a multiplication key, a division key and an equal sign key; the function keys comprise function keys, sound keys, double-core keys, power keys, self-defining keys, a previous page key and a next page key,

2. The financial accounting special purpose calculator as claimed in claim 1, wherein: there are 6 signal lines under the key, these 6 signal lines can transmit two kinds of signals of high level and low level, wherein high level represents 1, then low level represents 0, otherwise, low level represents 1, then high level represents 0, the preferred scheme is that high level represents 1, low level represents 0, when pressing the key, transmit the corresponding electrical signal to the one-chip computer, convert into 0 and 1 data by the key circuit, in the 6bit data, one is the parity check code, the other 5 are used for differentiating the key, the key design lies in that these 5 binary data need to have uniqueness, namely there is not any two binary data of key are identical.

3. The financial accounting special purpose calculator as claimed in claim 1, wherein:

the number keys are used for inputting numbers and point numbers;

the function is introduced into the system in such a way that,

the import function is divided into the following steps:

When writing and importing functions, the following points need to be noted:

importing the data into a summary function without selecting whether to expand;

the default page is a page automatically entered after the computer is started;

4. The financial accounting special purpose calculator as claimed in claim 1, wherein:

5. The financial accounting special purpose calculator as claimed in claim 1, wherein:

the desktop of the display screen is divided into two types, namely, the desktop of a common operation page and the desktop of a function operation page, the desktop of the function operation page consists of a working area and a status bar, the status bar is positioned at the bottom of the working area, the working area consists of rows and columns to form a table, cells in the table are divided into a function frame, an input frame and a hidden frame, the function frame performs operation on data of the input frame by using a designed function and obtains a result, the input frame is used for inputting the data, the hidden frame is one of function frames, the hidden frame cannot be displayed on a display screen of a special calculator for a meeting, the status bar consists of 1 row of tables, the tables of the status bar are function frames or hidden frames, the function frames of the working area and the status bar can only be connected with a computer through a USB (universal serial bus) to write functions or use built-in functions, the function frames cannot input the data, and compared with Excel, the:

6. The financial accounting special purpose calculator as claimed in claim 1, wherein:

writing built-in functions in the following steps;

step 1, defining the number of rows and columns;

step 5, compiling a function;

step 9, compiling column functions, wherein the steps 7 and 8 are omitted in the process of compiling the column functions and the row functions, and the column functions cannot be independently shown in a function operation page;

and step 10, compiling the summary function, wherein the steps 6, 7 and 8 are reduced compared with the row function, and the summary function cannot be singly appeared in the function operation page.

7. The financial accounting special purpose calculator as claimed in claim 1, wherein:

writing an external function in the following steps;

step 2, compiling a line function;

step 4, if the expansion is selected in the step 3, continuing the next step;

step 8, if the selection in step 5 is no, step 9 is entered;