Analytical system of informational-marketing center

FIELD: computer science, in particular, analytical system for informational-marketing center.

SUBSTANCE: system contains three registers, three adders, device for forming base recording address, device for forming current record address, device for forming temporal period address, block for forming recording and reading signals, device for selection of base reading address, device for selection of temporal period address, counter, memory block, trend detection block, block for counting number of deals, comparator and comparison block.

EFFECT: increased system speed of operation by excluding search for data of marketing research across whole electronic trade database and localization of search only by temporal and characteristic signs of goods identifier.

10 dwg

 

The invention relates to computing, and in particular to an analytic system information and marketing centre (EMC).

One of the main functions of information and marketing center along with the other is to conduct analytical studies of market goods e-Commerce, including marketing research.

Marketing research is the process of collecting, processing and analyzing data in order to use the results when making marketing decisions. The basis for conducting marketing studies are constantly emerging issues in this field.

Most common today are studies in the following areas:

- current market characteristics and trends of its development;

- the behavior of consumers;

- consumer preferences;

- competitors;

- the internal environment of the manufacturer;

- characteristics of the goods;

- pricing;

- distribution channels;

communication and sales promotion.

For any successful business marketing research serve as the beginning and the logical end of any cycle of its marketing activities. They significantly reduce the uncertainty when making important marketing decisions that allows

to determine potentially the th capacity market,

- to identify its share of the market,

- analyze consumer behavior and analysis of competitors;

- analyze sales channels and to select the most effective ones.

Known systems that could be used to solve the task (1, 2).

The first of the known systems contains blocks receiving and storing data, connected to the control blocks and data blocks search and selection, connected to the blocks of the data storage and display, the clock inputs are connected to outputs of the control unit (1).

A significant disadvantage of this system is that you cannot solve the problem of updating data stored in memory in the form of relevant documents simultaneously with the solution of the issue of the content of these documents to users in real time.

Known and other system containing a Central processing unit, the input of which is connected to the memory blocks and blocks of training and input data, and outputs connected to the respective memory blocks, the data processing unit, the information input of which is connected to the outputs of the respective memory blocks, the clock inputs connected to the control outputs of the Central processor unit, and the output unit is an information output system (2).

the Last of the above technical solutions closest to being described.

Its disadvantage is the low system performance, due to the fact that the procedures of marketing research goods market e-Commerce is implemented through the search data across the database, that when large amounts of data, which contains the database of the EMC, inevitably leads to unnecessarily high costs time to obtain analytical estimates.

The purpose of the invention is the improvement of the system performance by avoiding search marketing research data across the database of the EMC and localization of search only temporary and distinctive characteristics of the product identifier.

This objective is achieved in that in the known system, containing the first register, the information input of which is the first information input system clock input is the first synchronizing input of the system, and the first output of the first register is the first information output system, the second register, the information input of which is the second information input of the system, and the clock input is the second synchronizing input of the system, the third register, the information input which is the third information input of the system, and the clock input is the third synchronizing input of the system, the counter information is the course which is the fourth information input system, and the clock input connected to the second clock input of the system, the signal recording and reading information, the output of which is the address of the system output and clock output of the write and read are the first and second clock outputs of the system, respectively, the block defining trend information the input of which is connected to the appropriate information outputs group outputs of the memory block, and the output is the second information output system, the device forming the current address of record, the output of which is connected with one of the information input of the first adder, entered forming device base address write, data input connected to the second output of the first register and the clock input connected to the first clock input of the system, the information output device forming the base address of the account connected to another information input of the first adder, a clock output connected to the clock input of the first adder, and outputs the first and second groups of outputs of the device forming the base address of the account connected to respective inputs of the first and second groups of inputs of the device forming the current address of record, the device address generation BP the time period, an information input connected to the third output of the first register, the clock input is connected to the synchronizing output of the device forming the base address of record, and the clock output is connected with one clock input signal writing and reading, the second adder, the information input of which is connected to data outputs of the first adder and the device address generation time period, the clock input is connected to the synchronizing output of the device address generation time period, and the output of the second adder is connected to one information input signal recording and reading device selection address time period, an information input connected to the output of the second register, and the clock output is connected to another clock input of the signal recording and reading device selection base address read, the first and second control inputs of which are the first and second control inputs of the system, information input is connected to the output of the counter, the clock input connected to the second clock input of the system, one clock output selection base address read is connected to sync the dominant input device selection address time period, another clock output connected to the control input of the memory unit, an information input connected to one information output device selection base address read, the third adder, one data input of which is connected to the information output device selection address time period, another information input is connected with the corresponding information output device selection base address read clock input is connected to the clock output selection time period, and the output of the third adder connected to another information input signal writing and reading, the block count of the number of transactions, the information input of which is connected with the corresponding information output device selection base address read and information output is the third information output system, one clock output unit counting the number of transactions is signaled by the output of the system, and the other is connected to a counter input of the signal writing and reading, a comparator, one data input is the fifth information input system, second information input is connected to the information output of the memory block, the clock input of the comparator is connected to the synchronizing output of the memory block, one output of the comparator is connected to the clock input of block trend detection, and the other output of the comparator is connected to the third clock input device selection base address read with counter input of the counter, and the unit of comparison, one data input of which is the sixth information input system, second information input is connected to the output of the third register, the clock input unit of comparison is connected to the third clock input system, and the outputs of the unit of comparison is connected to the corresponding inputs of the block count of the number of deals, the clock input connected to the third clock input device selection base address read.

The invention is illustrated by drawings, where figure 1 shows the block diagram of the system, figure 2 shows an example of a specific design implementation of the device forming the base address of record, figure 3 shows an example of a specific design implementation of the device forming the current address of record, figure 4 shows an example of a specific design implementation device address generation time period, figure 5 shows a concrete example of the constructive realization of the signal writing and reading, figure 6 shows a specific example of konstruktivnoi implementing device selection base address read figure 7 - example of a specific design implementation device selection address time period, Fig shows an example of a specific design implementation of the memory block, figure 9 shows an example of a specific design implementation unit counting the number of transactions figure 10 shows an example of a specific design implementation Comparer.

The system (figure 1) contains the first 1, second 2 and third 3 registers, the first 4, second 5 and third 6 adders, unit 7 forming the base address of the recording device 8 forming the current address of record, the device 9 address generation time period, block 10 forming the signal recording and reading device 11 breeding base address reading device 12 of the selection addresses of the time counter 13, memory unit 14, block 15 of trend detection, block 16 counts the number of transactions, the comparator 17 and block 18 of the comparison.

Figure 1 also shows the first 21, second 22, third 23 and fourth 24, 25 fifth and sixth 26 information input system, the first 27 and second 28, third 29 clock inputs of the system, the first 30 and second 31 control inputs of the system, the first 32 and second 33 and third 34 information system outputs, address 35 output, the first 36 and second 37 clock outputs and signal 38 output system.

Unit 7 forming the base address of record (figure 2) soda is incorporated memory block 41, made in the form of a persistent storage device, the decoder 42, the register 43, the items 44-49 And elements 50-53 delay. The drawing shows information 54 and the clock 27 inputs, as well as information 55 and the clock 56 outputs the first 57-59 and second 60-62 group of outputs of the device.

Unit 8 forming the current address of record (figure 3) contains counters 71-73, group 74-76 elements And group elements 77 OR. The drawing also shows the first 78-80 and second 81-83 group of inputs, as well as information 84 exit.

Unit 9 address generation time period (figure 4) contains the memory block 91, made in the form of a persistent storage device, register 92, the decoder 93, the elements 94-96 And elements 97, 98 delay. The drawing also shows information 99 and clock 100 inputs information 101 and the clock 102 exits.

Unit 10 a signal recording and reading (figure 5) contains a counter 111, the trigger 112, the group 113-114 elements And the elements 115-116 And elements 117-119 OR elements 120-122 delay. The drawing shows information 123, 124 inputs, clock 125, 126 inputs, counting 127 entrance, as well as information 128 output and outputs record 129-read-130.

The device 11 breeding base address read (figure 6) contains the memory block 131 made in the form of a persistent storage device is VA, registers 132, 133, the decoder 134, the trigger 135, elements 136-140 And element 141 OR elements 142, 143 delay. The drawing shows information 144, the first 28 and second 145 clock inputs, the first 30 and second 31 control inputs, as well as information 147, 148 and 149 synchronizing, 150 outputs of the device.

The device 12 selection addresses the time period (Fig.7) contains the memory block 161, made in the form of a persistent storage device, register 162, the decoder 163, items 164-166 And elements 167, 168 delay. The drawing also shows information 155 and clock 156 inputs, information 170 and synchronizing 169 outputs.

The memory unit 14 (Fig) contains a counter 171, the decoder 172, registers 173-175, elements, 176-178 And elements 179, 180 delay. The drawing shows information 181 synchronizing 182 and installation 183 inputs, as well as the group 184-186 information outputs, clock 187 and information 188 outputs.

Unit 16 counts the number of transactions (Fig.9) contains a comparator 191, counters 192, 193, item 194 OR element 195 delay. The drawing shows information 196 and 197 first and second 198 clock inputs, as well as information 34, the first 38 and second 199 synchronizing the outputs of the block.

Block 18 comparison (figure 10) contains a comparator 201 and the element 202 delays. The drawing shows information 26 and 203 and the clock whodi, as well as 204, 205 outputs of the block.

All nodes and elements of the system are made on the standard of potentially switching elements.

The system works as follows.

In the process of conducting electronic trading after the conclusion of each transaction between the seller and the buyer with information input 21 of the system to the input of the register 1 receive codogram follows:

CODECODECODECODECODECODE
CODEDATEVOLUMEPRICESOLDBUYER
Producttransactionstransactionsfor ED.

This codogram will be entered into the register 1 clock pulse received at the clock input 27 of the system. From the first output register 1 full contents of codogram is issued for informational output 32 of the system.

From the second output register 1 product code is supplied to the information input device 54 7, whence it is fed to the input of the decoder 42, deciphering the code of the product and outstanding on one of its outputs a high potential supplied to corresponding inputs of elements 44-49 I.

For definiteness, doPost is m, the high potential on the first output of the decoder 42 will be opened to the elements 44 and 47 And, in addition, the high potential on the first output of the decoder will be issued at the output 57 of the device.

The clock pulse from the input 27 of the system, the detainee element 50 during operation of the decoder 42, receives, firstly, through the element 44 And to the input of fixed cells of the ROM 41, which stores the base address of the memory areas of the database selected for recording all transactions on this product, and reads its contents to the input of the register 43.

Secondly, this same pulse, the delayed element 51 at the time of reading the base address of the ROM 41, is fed to the clock input of the register 43 and enters a code base address, which is output 55 of the register 43 is supplied to one data input of the adder 4. To another input of the adder 4 to the output 84 of the device 8 receives the code from the output of the counter 71 through the elements 74 And open at a second output a high potential from the output 57 of the device 7.

The same clock pulse, the delayed element 52 at the time of entry code base address register 43, first, through the output 56 of the device 7 is supplied to the clock input of the adder 4, providing the sum of the base address and code of the counter 71. Considering, however, that to the present time counter 71 was in the initial state, and it is testimony to be equal to zero, the result of the summation of the code base address at the output of the adder 4 will remain unchanged and output 103 will come to one input of the adder 5.

Secondly, the clock pulse from the output of the element 52 is delayed by element 53 at the time of actuation of the accumulator 4, and then through the element 47 and the output 69 of the device 7 is fed to the input 78 of the device 8 and then to the counting input of the counter 71, increasing his testimony on the unit and thereby forming the counter 71 for the next cycle of operation.

In parallel with the above described process date code transaction with the third output of the register 1 is supplied to the information input 99 of the device 9 and then fed to the input of the decoder 93, deciphering date code transaction and outstanding on one of its outputs a high potential supplied to corresponding inputs of elements 94-96 I.

For definiteness, let us assume that the high potential from the first output of the decoder 93 will be open element 94 I. the Clock pulse from the output 56 of the device 7 receives, firstly, through the element 44 And to the input 100 of the device 9 and then through the element 94 And fed to the input of a fixed cell ROM 91 in which is stored the address of the memory areas of the database selected for recording all transactions in a specified period of time, and reads its contents to the input of register 92.

Secondly, the clock pulse from the input 10 is delayed element 97 to read time code time period, and is supplied to the clock input of the register 92 and enters a code time period, which output 101 of the register 92 is supplied to the other information input of the adder 5. Recall that at the first input of the adder 5 from the output 103 of the adder 4 receives the code base address of the item.

The clock pulse from the output element 97, the detainee element 98 at the time of entry code time period in the register 92, the output 102 of the device 9 is supplied to the clock input of the adder 5, fixing the total address of record, which is output from the adder 5 is supplied to the input 123 of the block 10. In addition, the clock pulse from the output 102 of the device 9 is supplied to the clock input 125 of the block 10.

Input 123 of the block 10 is formed address of record supplied to one inputs of elements 113 And the first group that will be revealed high potential with inverted output of the trigger 112. The state of the trigger 12 is determined by the clock pulses entries received at the input 125 of the block 10, and a word clock reading at the input 126 of the block 10.

Given that at this point in time to the input 125 of the block 10 has received the sync pulse recording, after installation on the input of the trigger 12, the momentum will confirm it in the original condition in which a high potential with inverted output of the trigger 12 will be opened as elements 113 And groups, and element 116 I.

Address code writing output elements 113 And group the s passes through the elements 119 OR group on the information input of the counter 111, at the clock input of which receives a pulse from the input 125 of the block 10, the last in the chain: element 117 and OR element 120 delay, delaying the impulse response time of the adder 5.

In addition, this same pulse from the output element 120 delay pass element 116 And the delay element 122 at the time of entry code address counter 111 and then through the outlet 36 of the system is fed to the input of the first interrupt server database.

With receipt of this signal, the database server passes to the routine recording the indications of the register 1 output 32 system address generated at the output 35 of the system.

The write procedure subsequent patterns of transactions e-Commerce is carried out in the manner described above.

Carrying out of marketing researches of the market of electronic trading should provide answers to the following questions:

- What goods are transacted with the highest trading volume?

- In what time periods, there is increased trading activity with large volumes of transactions?

To this end, an automated operator position-expert is formed corresponding to the request, codogram which has the following structure:

PRODUCT CODECODE YEAR time period, starting from the top of the showing will be conducted marketing research CODE DURATION time PERIOD the Number of years set for marketing researchCODE SPECIFIED VOLUME of TRANSACTIONS for marketing research
Enter a numeric valueEnter a numeric valueEnter a numeric valueEnter the numeric value of the volume of transactions

The code of the selected item from the information input 22 system is supplied to the information input of the register 2, the digital code value of the year with information input 24 system is supplied to the information input of the counter 13, the code length of the time period from the information input 25 is supplied to the information input 207 of the comparator 17, and the code specified volume deals with information input 26 of the system is fed to one input of the block comparison 18.

Receipt codogram request with ArmA expert accompanied by a synchronization pulse received at the input 28 of the system and then to the clock inputs of the counter 13 and the register 2, recorded in the digital counter value of the year, and the case 2 code of the selected item. Secondly, this same clock pulse is supplied to the first 28 synchronizing the input device 11, whence it passes through the element 141 OR delay element 142 at the time of entering the code in the meter 1, register 2 and the response time of the decoder 134, and goes on to survey the state of the elements 136-138 OR.

The decoder 134 decodes the digital value of the year by throwing on one of its outputs a high potential, and thus opening one of the elements 136-138 I.

Given the fact that open on one input will be only one of the elements 136-138 And, after the corresponding element And the sync pulse is fed to the input of the read fixed memory permanent storage device 131 that stores the base address of the partition server memory (not shown), from which this section are stored in the memory all the records of transactions executed in a given year.

The structure of the read code from the fixed memory ROM 131 is as follows:

CodeCode
the base address of the partition memory database serverthe total number of records of transactions executed in the current year

Codes of the base address and the total number of records of transactions from outputs of the ROM 131 receives information inputs of the registers 132 and 133, respectively, where and are recorded synchronizing pulse from the output element 143, delaying the clock pulse on the read time code from ROM.

The code base address section is and the memory of the database server from the output 147 of the device 11 is given to one input of the adder 6, and the code for the total number of records of transactions with output 148 is provided as information to the input 181 of the memory unit 14, and an information input unit 16 counts the number of transactions.

In addition, the clock pulse from the output element 143 delay is fed to one input elements 139 and 140 And controlled by the trigger mode 135, the condition of which is determined by the choice of expert is one of the two modes of marketing research, asked signals to the control inputs 30 and 31 of the system.

In the first mode, the trigger 135 is in original condition and has high potential with inverted output opens the element 140 And causing the clock pulse from the output element 143 passes element 140 And output 149 of the device 11 is supplied to the clock input 156 of the device 12, the information input 155 whose output register 2 filed code of the selected item.

The decoder 163 decodes the code characteristic of the products passing to one of the inputs of the elements 164-166 high potential. As a result of this clock pulse input 156 of the block 12, firstly, is the corresponding element 164-166 And outdoor decoder 163, and is fed to the input of the read fixed memory ROM 161.

In the result, the reference address of the selected item is read from the ROM 161 to the input of the register 162, where he recorded soundbite is siraudin pulse input 156, detainees element 167 to read time code from the ROM 161.

Output 170 of the block 12 reference read address of the goods supplied to the information input of the adder 6, the other input of which is filed with the address given year is read from the output 147 of the device 11. In parallel, the clock pulse from the output element 167 unit 12 is delayed element 168 at the time of actuation of the register 162 and output 169 is supplied as the clock input of the adder 6, and the clock input 126 of the block 10.

By synchronizing the pulse adder 6 generates a result address read data from the database server, which is the output of the adder 6 through the inlet 124 of the block 10 is supplied to the inputs of elements 114 And groups.

Simultaneously, the pulse input 126 unit 10 immediately fed to a single input trigger 112 and sets it in one state, where the elements 114 And group and element 115 And will be open. In addition, this same pulse input 126 passes the element 117 OR delay element 120 at the time of trigger 112, and, first of all, is fed to the clock input of the counter 111, putting him in the result code read address input 124 through the elements 114 And groups and elements 119 OR group.

Secondly, the same clock pulse from the output element 120 delay is element 115 And element 118 OR the and the input of the delay element 121.

After a delay element 121 at the time of entry code address counter 111 clock pulse passes to the output 37 of the system and then delivered to the input of the second interrupt of the database server.

With the arrival of this signal, the server goes to the subroutine reads the contents of the database at the address generated at the output 35 of the system and write first, read the testimony of codogram database in the receiving register workstation expert (not shown), and, secondly, the records of the volume deals with the entrance 23 to the register 3 clock signal server, coming from the entrance 29 to the clock input of the register 3.

From the output of the register 3 read value of the transaction amount is transferred to the input unit 203 comparison 18, the other input of which the input 26 receives set by the expert threshold value of transactions of interest to the expert. On the clock pulse input 29, the detainee element 202 at the time of enrollment code in register 3, the comparator 201 compares the input codes.

If the value of the volume of transactions recorded in the register 3, is less than the threshold value set by the expert, the output 204 of the block 18 is formed by a pulse received on the input 197 of the block 16 and then through the element 194 OR directly to the sync input of the comparator 191, one of the information input with the input 196 enters the code number of transactions in read year from the output 148 of the device 11, and on another input the code counter 192, fixing the number of read records of transactions from the memory of the database server.

Given that to date, the counter 192 were in the initial state, his readings were equal to zero, and when comparing the input code comparator 191 generates a signal less than that from the output 199 is fed to the input 127 of the block 10 and then fed to the counting input of the counter 111, incrementing the read address by one. In addition, the same pulse passes the element 118 OR delay element 121 at the time of actuation of the counter 111 and then through the outlet 37 of the system is fed to the input of the second channel interrupt the database server.

With the arrival of this signal, the server returns to the routine of reading the contents of the database at the address generated at the output 35 of the system and write first, read the testimony of the next codogram database in the receiving register workstation expert (not shown), and, secondly, the records of the volume deals with the entrance 23 to the register 3 clock signal server, coming from the entrance 29 to the clock input of the register 3.

If the value of the read transaction volume will exceed the threshold level set by the expert, the Comparer 18 generates a pulse at the output 205 from which the pulse is fed to the input 18 of the block 16 and then fed as the counting input of the counter 193, fixing the number of transactions, the volume of which exceeded the threshold level and the clock input of the comparator 191, comparing the number of records of transactions contained in the current year, with the number of read records.

Describes the process of reading the records of transactions from the database server will continue up until the comparator 191 unit 16 will not fix the equality codes on its inputs the signal on output 38 of the system, indicating that the sample of transactions exceeding the specified level is completed, and the number of such transactions is recorded in the counter 193 unit 16.

If the subject of marketing research will be the total number of transactions by year held electronic trading, in this case, the expert selects the second mode in which the trigger signal 135 from the entrance 30 of the system will be installed in one state, which will open the item 139 I. contrast to the first mode of operation is that when recording a few codes from the ROM 131 in the registers 132 and 133 of the pulse from the output of the delay element 143 passes not through the element 140 And, as in the first case, and through the element 139 And the output of which the clock pulse is output 150 device 11 and further to the input 182 of the memory block 14.

In the initial state, the counter 171 unit 14 to zero and zero code with its output to the input of the decoder 172, which is zero decoding the input code, opens the first element 176 And one entrance. With the arrival of the clock pulse at input 182 he immediately passes through the element 176 And the clock input of the register 173 and enters a code number of transactions in a year with input 181 of the block.

After a delay element 179 at the time of enrollment code in register 1, this pulse is fed to the counting input of the counter 171, fixing the fact of the entry of the code number of transactions per year in the first register 173.

The counter 171 is issued through the output 188 of the block 14 to the input 206 of the comparator 17, the other input of which the input 25 enters code duration time period during which it is necessary to conduct marketing research.

Given the fact that the counter 171 recorded data on transactions of only one year, then the comparator 17 produces a pulse at the output 210 from which the specified pulse is supplied to the counting input of the counter 13, increasing his testimony on the unit, and the clock input 145 of the device 11.

The decoder 134 decodes the digital value of the year coming from the output of the counter 13, throwing on one of its outputs a high potential, and thus opening one of the elements 136-138 I.

Given the fact that open on one input will be only one of the elements 136-138 And, after the corresponding element, And the clock pulse enters the entrance-read fixed memory permanent storage device 131, stores the base address of the partition server memory (not shown), from which this section are stored in the memory all the records of transactions executed in a given year.

As previously noted, the structure of the read code from the fixed memory ROM 131 is as follows:

CodeCode
the base address of the partition memory database serverthe total number of records of transactions executed in the current year

Codes of the base address and the total number of records of transactions from outputs of the ROM 131 receives information inputs of the registers 132 and 133, respectively, where and are recorded synchronizing pulse from the output element 143, delaying the clock pulse on the read time code from ROM.

The code base address of the partition of the database server from the output 147 of the device 11 in this system mode is not used, and the code for the total number of records of transactions with output 148 is again given as to the information input 181 unit 14 of the memory.

The clock pulse from the output 150 of the device 11 through the inlet 182 unit 14 receives now through another element 177 And to the clock input of the next now 174 register and writes the data input 181.

This process of recording data on the number of deals by year prodoljaetsa until until the comparator 17 to maintain the equality of the input codes, generating a pulse at the output 209. The specified pulse is supplied to the clock input unit 15, the information the input of which is filed with numerical data about the transactions during each of the years included in the selected time period.

When conducting marketing research unit 15 implements a function of statistical data processing using software from a software library Excel 2000 [3].

In particular, the unit 15 predicts the quantitative value of transactions in the electronic Commerce using the standard features of Excel 2000 - TREND.

This function allows a linear extrapolation, or, in other words, to calculate the most suitable straight line which passes through a sequence of set points. In fact we are talking about the task, in which a graph is a set of points, and then selected straight line defined by the equation Y=ax+b, by which it is possible to trace the development of functions with the smallest error.

Function TREND () returns (i.e. the result is an array of numbers that can be used to construct a trend line (trend) is a straight line, which helps to understand the behavior of the actual data.

The function has four arguments:

=TREND (known what Yesenia; known_x's; new_x's; the intercept).

The first two represent the known values of the dependent and independent variables, respectively.

The known_y's argument is one column, one row or a rectangular range.

If known_y's argument consists of a single row or column, respectively, each column or row in the known_x's are treated as the independent variable.

- If known_y's is the rectangular range, it is possible to use only one independent variable. In this case, the known_x's argument must be rectangular range of the same size and shape as y-values.

The third and fourth arguments are optional.

If the constant b is the intercept, the value of this argument must be TRUE or FALSE (1 or 0). If this argument is omitted or equal to 1, then the constant b is calculated normally, otherwise it is assumed to be 0 and the equation of a straight line is y=ax.

Let us consider an example illustrating the analysis of changes in the number of transactions recorded in the registers of the block 14 for the time interval equal to seven consecutive years (table).

The ordinal number of the yearThe number of transactionsTrend
AndIn
1336501928
23365060834
363860119740
4214170178646
5274340237552
6285410296458
7345440355364
8455283 - forecast for 8 years.

In this example, to calculate the trend line, which approximates the known data, omitted the third and fourth arguments. The array results in the column that has the same size as the range of known x's in column A.

To find the value of each point on the regression line that fits the data column, use the TREND ().

In this example, the argument y is the range B1:B7. Known_x's is the range A1:A7. It stores the number of years for which the trend.

To calculate the forecast values of the levels of numerical values for one, two or more years should be entered in the number of function arguments massivesovietunion.

Thus, the introduction of new units and new constructive relationships significantly improve system performance by eliminating search marketing research data across the database of electronic trading.

Sources of information

1. U.S. patent No. 0505651, M CL G 06 F 13/40, 13/38, 1992.

2. U.S. patent No. 5129083, M CL G 06 F 12/00, 15/40, 1992 (prototype).

3. Mark Dodge, Craig Stinson., Effective work with Microsoft Excel 2000. Publishing house "Piter", 2002, s-565.

Analytical system information and marketing centre, containing the first register, the information input of which is the first information input of the subsystem clock is the first clock input subsystem, and the first output of the first register is the first information output subsystem, the second register, the information input of which is the second information input subsystem, and the clock input is the second clock input subsystem, a third register, the information input which is the third information input subsystem, and the clock input is the third clock input subsystem, a counter, an information input which is the fourth information input subsystem, and the clock input connected to the second clock is the input subsystem, the signal recording and reading information, the output of which is the address output of the subsystem clock and outputs the read and write are the first and second clock outputs of the subsystem, respectively, the block defining trend information the input of which is connected to the appropriate information outputs group outputs of the memory block, and the output is the second information output subsystem, and device for the formation of the current address of record, the output of which is connected with one of the information input of the first adder, wherein the subsystem includes the device forming the base address of record, the information input connected to the second output of the first register and the clock input connected to the first clock input subsystem, the data output device forming the base address of the account connected to another information input of the first adder, a clock output connected to the clock input of the first adder, and outputs the first and second groups of outputs of the device forming the base address of the account connected to respective inputs of the first and second groups of inputs of the device forming the current address of record, the device address generation time period, the information is first input connected to the third output of the first register, the clock input is connected to the synchronizing output of the device forming the base address of record, and the clock output is connected with one clock input signal writing and reading, the second adder, the information input of which is connected to data outputs of the first adder and the device address generation time period, the clock input is connected to the synchronizing output of the device address generation time period, and the output of the second adder is connected to one information input signal recording and reading device selection address time period, an information input connected to the output of the second register, and the clock output is connected to another clock input signal recording and reading device selection base address read, the first and second control inputs of which are the first and second control inputs of the system, information input is connected to the output of the counter, the clock input connected to the second clock input subsystem, one clock output selection base address read is connected with a synchronizing input device selection address time period, the other with hranitelyami output connected to the control input of the memory block, an information input connected to one information output device selection base address read, the third adder, one data input of which is connected to the information output device selection address time period, another information input is connected with the corresponding information output device selection base address read clock input is connected to the clock output selection time period, and the output of the third adder connected to another information input signal writing and reading, the block count of the number of transactions, the information input of which is connected with the corresponding information output device selection base address is read, and the information output is the third information output subsystem, one clock output unit counting the number of transactions is signaled by the output subsystem, and the other is connected to a counter input of the signal writing and reading, a comparator, an information input which is the fifth information input subsystem, another information input is connected to the information output of the memory block, the clock input of the comparator is connected to the synchronizing output of the memory block, one output to which paratore connected to the clock input of block trend detection, and the other output of the comparator is connected to the third clock input device selection base address read with counter input of the counter, and the unit of comparison, one data input of which is the sixth information input subsystem, another information input is connected to the output of the third register, the clock input unit of comparison is connected to the third clock input subsystem, while the outputs of the unit of comparison is connected to the corresponding inputs of the block count of the number of deals, the clock input connected to the third clock input device selection base address read.



 

Same patents:

FIELD: user registration method.

SUBSTANCE: method includes user sending a request to confidential unit through one of multiple financial terminals for servicing user cards, by inserting a card and personal PIN-code of card and selection of service type, user card servicing terminal checks PIN-code of card, forms and sends a request to processing center of bank, to which aforementioned terminal belongs and in which affiliation of card with payment system is determined and emitting bank is determined, service type is fixed and sum deducted from user account, processing center sends request to database server for emitted cards, presence and state of user account is checked, aforementioned sum of money is deducted, user data is received and sent to bank server for controlling registration of users, two series of code symbols are formed, one of which is sent to database server of registered users.

EFFECT: registration is performed fully in electronic mode and in automatic real time scale mode.

2 cl, 1 dwg

FIELD: electronic receipt system based on Internet and technology for realization of the same.

SUBSTANCE: system has pharmacy database 14, group server 18 of participating pharmaceutical company, web-server 10, group of terminal personal computers (KIOSK), meant for paying for medical examination, dispensing and sending via Internet of receipts based on examination results to pharmacy noted by patient or to pharmacy closest to patients home, pharmacy terminal and database systems of patients 16, while request of aforementioned data and controlling of them is performed via Internet-server. Methods describe operation of electronic receipt system, and generation of system of pharmacy database.

EFFECT: increased system speed of operation.

4 cl, 10 dwg

FIELD: technologies and systems for performing financial business operations for wireless or wired communication networks and Internet, providing transaction-related services between network resources.

SUBSTANCE: in accordance to method, network resource has unique network identifier assigned thereto, utilized as identifier of financial account of resource, while also performed is generation of File of resource, containing network identifier associated with resource, and also financial data and data of financial account of resource, output by Authenticating Center of Digital Certificate containing data of resource File for utilization during performing transactions between requesting and requested network resources, wherein Administrator of Digital Certificates preferably also acting as Address Administrator of Central Commutator, outputs Files and Digital Certificates of resources, transmits resource Files and Digital Certificate directly to resource or temporary network resource or reseller; reseller for payment assigns universal account/File/Digital Certificate to permanent or temporary network resource, while encryption of secret financial data and data of financial account prior to their positioning in File or Digital Certificate occurs with utilization of Open key of Authorization Center, which makes it possible to avoid leaking out of secret financial data and financial account data, and positioning of universal account identifier of Authorization Center in resources File together with financial data and data of financial account of resource, serves as address information for making connections to Authorization Center for providing services of performing transactions between resources.

EFFECT: possible providing of communication services utilizing unique network identifier as identifier of financial account of resource.

3 cl, 12 dwg

FIELD: technologies for realization of electronic payment circulation with utilization of mobile terminal.

SUBSTANCE: method includes following stages: transferring request for payment from mobile terminal into payment realization center, transfer of required payment parameters from mobile terminal to payment making center, assignment to each payment procedure of unique transaction code or permission code and transfer of assigned transaction code or permission code to mobile terminal and/or addressee of payment.

EFFECT: improved reliability of communication between payment requester and center for making payments.

2 cl, 9 dwg

FIELD: technology for automation of elections and cryptographic technologies used for this purpose.

SUBSTANCE: methods include encrypting selection in voting paper by means of first secret known only to operator, for generation of first component of encrypted voting paper, then selection is encrypted in voting paper by means of second secret, known only to operator, while second secret is selected independently on first secret, for generation of second component of encrypted voting paper. Then proof is generated, demonstrating that first and second components of encrypted voting paper are encrypted for one and the same selection in voting paper. First and second components of encrypted voting paper and proof are transmitted to computerized vote gathering system.

EFFECT: improved protection of voting platform from malicious software.

17 cl, 3 dwg

FIELD: technology for automation of elections and cryptographic technologies used for this purpose.

SUBSTANCE: methods include encrypting selection in voting paper by means of first secret known only to operator, for generation of first component of encrypted voting paper, then selection is encrypted in voting paper by means of second secret, known only to operator, while second secret is selected independently on first secret, for generation of second component of encrypted voting paper. Then proof is generated, demonstrating that first and second components of encrypted voting paper are encrypted for one and the same selection in voting paper. First and second components of encrypted voting paper and proof are transmitted to computerized vote gathering system.

EFFECT: improved protection of voting platform from malicious software.

17 cl, 3 dwg

FIELD: data processing technologies, possible use for verification of user rights for using a service.

SUBSTANCE: method for verification of user rights for using a service includes: provider provides for user at least one matrix of variable number and one matrix of variable signature. User forms his variable number on basis of variable number matrix and sends it to provider. On basis of results of check of variable number receiver from user provider determines whether this variable number belongs to this user. Then provider sends to user at least one query for variable signature. In response to query user forms his variable signature on basis of variable signature matrix and sends it to provider. If results of check of variable signature received from user are true, then provider verifies rights for usage of ordered service.

EFFECT: full confidentiality of user rights verification procedure, including when unprotected information channels are used for this purpose.

4 cl

FIELD: engineering of systems for marking and verifying objects, possible use for marking and identification of products, valuable papers and documents.

SUBSTANCE: system consists of verification center, data input stations, similar number of corporative databases of corporative control centers, n verification stations, system has blanks of protective marks with applied counting numbers, and cancelled marks, indexes show number of corporative control center acting as data provider. System provides for high protection of information applied onto protective mark.

EFFECT: possible marking of objects in several corporative subsystems and with reliable confirmation of authenticity of marked objects present in industrial circulation.

11 cl, 13 dwg

FIELD: recognition methods, possible use in industrial branches suffering from unsanctioned copying of serial products.

SUBSTANCE: method for protecting unique individual symbolic marking of serial product includes applying onto serial product of unique individual marking, visually recognizable and machine-readable, forming of interactive electronic database with unique symbolic machine-readable identifier, fully corresponding to symbolic value of unique individual marking on serial product and meant for positive authentication of serial product marking in aforementioned database, sending query for authentication of current marking of serial product in interactive electronic database, identification of aforementioned marking of serial product, automatic receipt of response about positive or negative authentication, automatic deletion of identifier corresponding to requested one from aforementioned database in case of and simultaneously with first positive authentication.

EFFECT: improved level of protection of serial product from unsanctioned access.

FIELD: computer science, in particular, engineering of information effect system of information-marketing centers in integrated electronic trading infrastructure.

SUBSTANCE: system has three registration devices, two adders, block for selecting supporting recording address, block for selecting supporting reading address, block for selecting query source address, block for selecting current record address, block for forming temporal period address, block for forming database addresses, block for controlling recording and reading of data and data dispensing block.

EFFECT: improved system speed of operation by excluding renewable data search across whole database of electronic trading and localizing search only by temporal and individual signs of goods identifiers.

9 dwg

FIELD: electric communications, possible utilization for engineering of automated technical information protection means for monitoring safety of automated systems and operative identification of family of communication protocols TCP/IP utilized by digital communication systems and, in particular, by data transfer network of Internet type.

SUBSTANCE: device has frequency splitter, receiving memory block, subtracting counter, supporting memory blocks, decoding blocks, counters, AND elements, address receipt blocks, comparison blocks, decoders, register, indication block.

EFFECT: improved trustworthiness of detection of an attack against an automated system.

2 dwg

FIELD: computer science, in particular, analytical system of governmental population register.

SUBSTANCE: system has three registers, three counters, block for selecting base reading address, block for signs identification, memory block, generator of reading signals for database, comparison block, control signals discriminator, block for detecting a tendency and prediction block.

EFFECT: higher speed of operation of system due to excluded data search for statistical analysis across whole database of population register and localization of search by means of exclusively time-based and individual signs of personal identifier.

8 dwg

FIELD: computers, in particular, system for receipt, storage and reading of data about competitive offers in governmental purchases.

SUBSTANCE: system has block for receiving applications for participation in competition, block for selection of support address of providers in database, block for identification of limiting values of number of competitions, block for modification of addresses of server database, block for identification of competition codes, block for identification of electronic digital signatures of providers, OR element, block for data receipt of server database, block for selecting number of competitions participants, block for controlling selection of applications, block for controlling reading and recording of database, block for launching competitions procedure, block for selecting addresses of applications of providers in database, block for identification of closed encryption keys, register and block for outputting confirmations to providers.

EFFECT: higher reliability of system defense against unauthorized access due to encryption of competitive applications of providers by data encryption keys.

11 dwg

FIELD: manufacture of aircraft instruments; display of flying vehicle and onboard equipment parameters.

SUBSTANCE: proposed complex includes two control onboard digital computers, port, central and starboard multi-functional color displays, collimator display on windshield and multi-functional control panel combined by multiplex information exchange channel, local all-round information exchange channel, first and second local radial information exchange channels, thus forming integral information system. Connected to this information system are system of mode parameter sensors, power supply system, generator subsystem and storage battery. Both onboard digital computers are connected by means of inter-computer information exchange channels. Proposed complex is also provided with TV image switching unit connected with multi-functional color displays for transmission of TV image.

EFFECT: enhanced operational reliability and survivability of complex.

2 cl, 1 dwg

FIELD: computer science.

SUBSTANCE: method includes performing a block of operations along N1 channels, where N1 is selected from 1 to 2256, wherein received information is separated on logically finished fragments, encoded on basis of preset algorithm, to produce a block of N-dimensional sets adequate for converted source information Aj with elements like {Bm, X1, X2,...,Xn}, where j - order number of set in range from 1 to 2256, Bm - identifier, X1-Xn - coordinate of element from its coordinates center, m and n are selected from 1 to 2256; received block of sets is compared to already accumulated and/or newly produced sets from multiple channels, intersecting portions of sets are found and cut out; after that cut intersections and sets remaining after cutting are distributed among databases, placing each same set into database appropriate for it and each of sets different with some parameter to databases appropriate for them and identifiers of databases storing these sets are substituted in place of cut sets.

EFFECT: higher speed of operation, higher precision, lower costs, broader functional capabilities, higher efficiency.

9 dwg

FIELD: electronic engineering.

SUBSTANCE: for each channel device has digital signal converter, block for setting conversion digitization frequency, conversion level adjustment block, block for transferring electric signals to physical values, block for observing converted signals, block of precision of signal conversion, block of signal conversion time, block for disabling unused channels, block for synchronization of analog signals, visualization block, converted signal recording block. Device allows to convert signals of different levels, to change digitization frequency and conversion time, to disable unused channels, transfer sensors signals to physical values with consideration of sensors scales, observe signals at different scales, appropriate to levels of converted signals, to measure precision of recording of converted signals.

EFFECT: higher efficiency.

5 dwg

FIELD: computers.

SUBSTANCE: device has base address selector, registers, delay elements, elements of OR groups, OR elements, memory block, reverse counter, comparator.

EFFECT: higher speed of operation.

3 dwg

FIELD: measuring technologies.

SUBSTANCE: method includes setting tolerance for controlled parameter, measuring physical value, associated with said controlled parameter, with numeric characteristic of its value, then measured value is compared to its tolerated values (tolerances for controlled parameter), and decision concerning level of match of measurement results to tolerances for parameter is taken, when determining tolerance for controlled parameter an affiliation function is set for phrase "parameter on basis of measurements in tolerance", and during taking of decision trustworthiness of phrase is evaluated, expressed in non-precise measure, as value of affiliation function, matching value of measured parameter.

EFFECT: higher trustworthiness.

2 dwg

FIELD: computers.

SUBSTANCE: device has control trigger, random pulse generators, block for forming program of functioning of modeled multimode system, working modes and technological mode blocks, operation time counters, random pulses generators, OR block, orders counters.

EFFECT: broader functional capabilities.

3 dwg

FIELD: computers.

SUBSTANCE: system has nine registers, four address selectors, triggers, AND elements, OR elements and delay elements.

EFFECT: higher speed.

8 dwg

FIELD: computers.

SUBSTANCE: system has nine registers, four address selectors, triggers, AND elements, OR elements and delay elements.

EFFECT: higher speed.

8 dwg

Up!