Intermediate range compensation voltage prediction method and system based on VBA

Abstract

The present invention discloses a method and system for predicting an intermediate range compensation voltage based on VBA, and the method includes: performing interval division processing on the historical compensation voltage and historical compensation current of the intermediate range to obtain interval data; establishing a relationship curve model according to the interval data; calculating the initial current variable of the detector according to the current compensation voltage and current compensation current of the detector at a certain moment, and the relationship curve model; fitting the initial current variable and the relationship curve model to obtain a true relationship curve; calculating the predicted compensation voltage according to the preset compensation current of the detector and the true relationship curve. The implementation of the present invention only requires inputting the preset compensation current to quickly calculate the corresponding predicted compensation voltage and predicted source range count rate, which not only has high calculation efficiency and reduces the workload of the staff, but also reduces the risk of human calculation errors and improves the calculation accuracy.

Description

Technical Field

[0001] The present invention relates to the technical field of nuclear power plant instruments, and in particular to a VBA-based intermediate range compensation voltage prediction method and system. Background Art

[0002] In the instrumentation and control system of a nuclear power plant, the intermediate range γ compensation ionization chamber eliminates the influence of γ rays by setting the compensation voltage. The compensation voltage needs to be calculated for each unit overhaul in order to correct the ability of the compensation ionization chamber to compensate for γ. However, the compensation voltage setting of the ionization chamber is not fixed and will be adjusted continuously as the detector ages. Each round of overhaul needs to evaluate whether the setting is appropriate and the adjustment range in the current state. If the compensation voltage is not adjusted properly, it will not be displayed during power operation, but it will be displayed during the reactor shutdown. If the compensation voltage is over-compensated, the source range channel will be put into operation at a high injection rate, and the injection rate may be greater than the tripping and stopping setting value of the source range channel, resulting in a tripping and stopping. During the reactor startup, the compensation voltage is over-compensated, which will also cause the output of the source range channel to be always small, and there is a risk that the intermediate range detector will be delayed in entering the range. On the contrary, if the compensation voltage is under-compensated, there will be a risk of delaying the commissioning of the source range channel.

[0003] The setting of compensation voltage needs to be integrated and calculated based on the source range count rate and intermediate range compensation current parameters of each downlink stage of the unit. For different units and different detectors, manual calculation is required each time. At the same time, if the source range count rate and compensation current of the next operation are to be predicted based on the set compensation voltage, a very complicated calculation process is required. Manual calculation is inefficient and only engineers who are very familiar with the system can master this calculation method. In addition, manual calculation has a great risk of human error and certain errors. For different detectors, only one compensation voltage can be calculated each time. Multiple steps are required to complete all calculations, and it is also very inconvenient to verify the calculation results, which is very time-consuming. Summary of the invention

[0004] The technical problem to be solved by the present invention is to provide a method and system for predicting an intermediate range compensation voltage based on VBA in view of at least one defect in the prior art.

[0005] The technical solution adopted by the present invention to solve the technical problem is: constructing a VBA-based intermediate range compensation voltage prediction method, comprising the following steps:

[0006] S10, dividing the historical compensation voltage and historical compensation current of the middle range into intervals to obtain interval data;

[0007] S20, establishing a relationship curve model for characterizing the relationship between the compensation voltage and the compensation current according to the interval data;

[0008] S30, calculating the initial current variable of the detector according to the current compensation voltage and current compensation current of the detector at a certain moment and the relationship curve model;

[0009] S40, fitting the initial current variable and the relationship curve model to obtain a real relationship curve for characterizing the relationship between the real compensation voltage and the real compensation current of the detector;

[0010] S50, calculating a predicted compensation voltage according to the preset compensation current of the detector and the real relationship curve;

[0011] The steps S20 to S50 are implemented by VBA codes.

[0012] In the VBA-based intermediate-range compensation voltage prediction method described in the present invention, in the step S10, the interval division processing of the historical compensation voltage and the historical compensation current of the intermediate range includes: based on the preset multiples of the historical compensation current of the intermediate range, the historical compensation voltage of the intermediate range is divided into a number of compensation voltage intervals, so that the ratio of the upper limit compensation current to the lower limit compensation current of each of the several compensation voltage intervals is the preset multiple, and the compensation voltage interval and the preset multiple constitute the interval data.

[0013] In the VBA-based intermediate-range compensation voltage prediction method described in the present invention, the step S20 includes: assuming that the upper limit compensation current of a certain compensation voltage interval is the initial current variable, and calculating the upper limit compensation current variable and the lower limit compensation current variable of each compensation voltage interval according to the initial current variable, the compensation voltage interval and the preset multiple, and establishing a relationship curve model according to the compensation voltage interval, the upper limit compensation current variable and the lower limit compensation current variable.

[0014] In the VBA-based intermediate range compensation voltage prediction method of the present invention, step S30 includes:

[0015] S301, performing interval positioning processing on the current compensation voltage of the detector at a certain moment by using a loop statement, and determining the compensation voltage interval where the current compensation voltage is located;

[0016] S302: Calculate an initial current variable of the detector according to the compensation voltage interval in which the current compensation voltage is located, and the current compensation voltage and current compensation current of the detector at a certain moment.

[0017] In the VBA-based intermediate range compensation voltage prediction method described in the present invention, the step S50 also includes: calculating the predicted compensation voltage based on the current source range count rate corresponding to the current compensation current of the detector at a certain moment, the preset source range count rate, and the real relationship curve.

[0018] The VBA-based intermediate range compensation voltage prediction method of the present invention further includes:

[0019] S01. Based on the VBA code, a human-computer interaction interface is established for obtaining the current compensation voltage, the current compensation current, the current source range count rate, the preset compensation current, and the preset source range count rate at the certain moment; the human-computer interaction interface is also used to display the predicted compensation voltage.

[0020] The present invention also provides a VBA-based intermediate range compensation voltage prediction system, comprising:

[0021] An interval division processing unit is used to perform interval division processing on the historical compensation voltage and historical compensation current of the intermediate range and output interval data;

[0022] A model making unit, used for establishing a relationship curve model for characterizing the relationship between the compensation voltage and the compensation current according to the interval data;

[0023] An initial current variable calculation unit, used to calculate the initial current variable of the detector according to the current compensation voltage and current compensation current of the detector at a certain moment and the relationship curve model;

[0024] A curve making unit, used for fitting the initial current variable and the relationship curve model, and outputting a real relationship curve for characterizing the relationship between the real compensation voltage and the real compensation current of the detector;

[0025] A predicted compensation voltage calculation unit, used to calculate the predicted compensation voltage according to the preset compensation current of the detector and the real relationship curve;

[0026] The model making unit, the initial current variable calculating unit, the curve making unit and the predicted compensation voltage calculating unit are made using VBA code.

[0027] In the VBA-based intermediate-range compensation voltage prediction system described in the present invention, in the interval division processing unit, the interval division processing of the historical compensation voltage and the historical compensation current of the intermediate range includes: based on a preset multiple of the historical compensation current of the intermediate range, dividing the historical compensation voltage of the intermediate range into a number of compensation voltage intervals, so that the ratio of the upper limit compensation current to the lower limit compensation current of each of the several compensation voltage intervals is the preset multiple, and the compensation voltage interval and the preset multiple constitute the interval data.

[0028] In the VBA-based intermediate-range compensation voltage prediction system described in the present invention, the model making unit is used to assume that the upper limit compensation current of a certain compensation voltage interval is an initial current variable, and calculate the upper limit compensation current variable and the lower limit compensation current variable of each compensation voltage interval according to the initial current variable, the compensation voltage interval and the preset multiple, and make a relationship curve model according to the upper limit compensation current variable and the lower limit compensation current variable.

[0029] The VBA-based intermediate range compensation voltage prediction system of the present invention further includes:

[0030] The human-computer interaction interface is used to obtain the current compensation voltage and the current compensation current at the certain moment, as well as the preset compensation current, and display the predicted compensation voltage.

[0031] The present invention has the following beneficial effects: The present invention provides a method for predicting the compensation voltage of an intermediate range based on VBA: first, the historical compensation voltage and the historical compensation current of the intermediate range are divided into intervals to obtain interval data; then a relationship curve model is established according to the interval data; then the initial current variable of the detector is calculated according to the current compensation voltage, the current compensation current, and the relationship curve model, and the initial current variable and the relationship curve model are fitted to obtain a true relationship curve; finally, the predicted compensation voltage is calculated according to the preset compensation current and the true relationship curve. The implementation of the present invention only requires inputting the preset compensation current to quickly calculate the corresponding predicted compensation voltage and predicted source range count rate, which not only has high calculation efficiency and reduces the workload of the staff, but also reduces the risk of human calculation errors and improves the calculation accuracy, and can also calculate the corresponding predicted compensation voltage and predicted compensation current according to the preset source range count rate, so that the staff can predict in advance whether the compensation voltage is appropriate, which plays a positive role in on-site work. BRIEF DESCRIPTION OF THE DRAWINGS

[0032] The present invention will be further described below with reference to the accompanying drawings and embodiments, in which:

[0033] Figure 1 It is a structural diagram of the intermediate range compensation voltage prediction method based on VBA provided by the present invention;

[0034] Figure 2 It is a structural diagram of step S30 in the VBA-based intermediate range compensation voltage prediction method provided by the present invention;

[0035] Figure 3 is a schematic diagram of a human-computer interaction interface provided by the present invention;

[0036] Figure 4 It is a structural diagram of the intermediate range compensation voltage prediction system based on VBA provided by the present invention. DETAILED DESCRIPTION

[0037] In order to have a clearer understanding of the technical features, purposes and effects of the present invention, specific embodiments of the present invention are now described in detail with reference to the accompanying drawings.

[0038] It should be noted that the flowcharts shown in the accompanying drawings are only exemplary and do not necessarily include all the contents and operations / steps, nor do they have to be executed in the order described. For example, some operations / steps can be decomposed, while some operations / steps can be combined or partially combined, so the actual execution order may change according to actual conditions.

[0039] Since the initial current of each detector is different, in order to quickly calculate the compensation voltage of each detector, refer to Figure 1 The present invention provides a method for predicting an intermediate range compensation voltage based on VBA, comprising: step S10, step S20, step S30, step S40 and step S50. Among them, steps S20 to S50 can be implemented using VBA code.

[0040] S10, dividing the historical compensation voltage and historical compensation current of the middle range into intervals to obtain interval data.

[0041] Furthermore, the interval division processing of the historical compensation voltage and the historical compensation current of the middle range in step S10 includes: obtaining the historical compensation voltage and the historical compensation current of the middle range of the sample detector, and based on a preset multiple of the historical compensation current of the middle range, dividing the historical compensation voltage of the middle range into a number of compensation voltage intervals, so that the ratio of the upper limit compensation current to the lower limit compensation current of each of the several compensation voltage intervals is a preset multiple, and the compensation voltage interval and the preset multiple constitute interval data.

[0042] Specifically, in one embodiment, the preset multiple is set to 2, the range of the historical compensation voltage obtained is -150V to 0V, and the historical compensation current corresponding to the historical compensation voltage of 0V is 16A, the upper limit compensation voltage of the first compensation voltage interval is set to 0V, the upper limit compensation current of the compensation voltage interval corresponds to 16A, and the corresponding lower limit compensation current corresponds to 8A (upper limit compensation current / preset multiple), and then the historical compensation voltage with a historical compensation current of 8A is retrieved, and the historical compensation voltage is set to the lower limit compensation voltage of the compensation voltage interval. Assuming that the lower limit compensation voltage is -10V, the final result is The compensation voltage interval is (0V, -10V); further, the upper limit compensation voltage of the next compensation voltage interval is set to -10V, and the corresponding upper limit compensation current is 8A, then the lower limit compensation current is 4A, and then the historical compensation voltage with a historical compensation current of 4A is retrieved and set as the lower limit compensation voltage of the compensation voltage interval. Assuming that the lower limit compensation voltage is -20V, the next compensation voltage interval is finally obtained as (-10V, -25V); based on the above principle, the historical compensation voltage is divided into several compensation voltage intervals, and each compensation voltage interval and the preset multiple are recorded to form interval data. In this example, the compensation voltage and compensation current at the boundary of each compensation voltage interval can be referred to Table 1.

[0043] Table 1

[0044] Compensation voltage / V Compensation current / A 1 0 16 2 -10 8 3 -25 4 4 -40 2 5 -50 1 6 -60 0.5 7 -70 0.25 8 -80 0.125 9 -90 0.0625 10 -150 0

[0045] Therefore, it can be seen from Table 1 that the compensation voltage intervals of this example include (0V, -10V), (-10V, -25V), (-25V, -40V), (-40V, -50V), (-50V, -60V), (-60V, -70V), (-70V, -80V), (-80V, -90V) and (-90V, -150V). For the compensation voltage interval (-90, -150), according to experience, when the mid-range current exceeds 10 -9 A, the effect of the compensation voltage is no longer obvious. According to the above interval division principle, it can still be further divided into intervals, but considering that the actual influence becomes smaller and smaller when the compensation current further decreases, when a certain historical compensation current is retrieved to be lower than the preset lower limit value, the historical compensation voltage corresponding to the historical compensation current and the lower limit compensation voltage of the historical compensation voltage range can be set to the compensation voltage interval at the end to reduce the calculation workload of the software. It can be understood that the smaller the preset multiple is, the more compensation voltage intervals it divides and the smaller the range is. Correspondingly, the relationship curve model established later will also be more accurate.

[0046] S20, establishing a relationship curve model for characterizing the relationship between the compensation voltage and the compensation current according to the interval data. It can be understood that the relationship curve model is applicable to detectors of the same type as the sample detector.

[0047] Furthermore, step S20 includes: assuming that the upper limit compensation current of a certain compensation voltage interval is the initial current variable, calculating the upper limit compensation current variable and the lower limit compensation current variable of each compensation voltage interval according to the initial current variable, the compensation voltage interval and the preset multiple, and establishing a relationship curve model according to the compensation voltage interval, the upper limit compensation current variable and the lower limit compensation current variable.

[0048] Specifically, taking the embodiment of Table 1 as an example, assuming that the upper limit compensation current of the compensation voltage interval (-50V, -60V) is X (initial current variable), the compensation current variable at the boundary of each compensation voltage interval is calculated based on the preset multiple, and finally Table 2 is obtained, which serves as the relationship curve model of this embodiment.

[0049] Table 2

[0050] Compensation voltage / V Compensation current variable 1 0 16X 2 -10 8X 3 -25 4X 4 -40 2X 5 -50 X 6 -60 0.5X 7 -70 0.25X 8 -80 0.125X 9 -90 0.0625X 10 -150 0

[0051] It can be understood that when the compensation current variable at the boundary of each compensation voltage interval is calculated, the upper limit compensation current variable and the lower limit compensation current variable of each compensation voltage interval are obtained. Referring to Table 2, taking the compensation voltage interval (0V, -10V) as an example, the upper limit compensation current variable is 16X and the lower limit compensation current variable is 8X.

[0052] S30, calculating the initial current variable of the detector according to the current compensation voltage and current compensation current of the detector at a certain moment and the relationship curve model.

[0053] Further, such as Figure 2 As shown, step S30 includes: step S301 and step S302.

[0054] S301, using a loop statement to perform interval positioning processing on the current compensation voltage of the detector at a certain moment, and determine the compensation voltage interval where the current compensation voltage is located.

[0055] Specifically, assuming that the current compensation voltage at a certain moment is V0, and its current compensation current is I0; taking the embodiment of Table 2 as an example, the relationship curve model is stored in EXCEL, and based on the loop statement embedded in VBA, starting from the smallest lower limit compensation voltage, comparisons are performed one by one in an incremental manner. If the compensation voltage is less than V0, V0 is temporarily set to be in the compensation voltage interval whose lower limit compensation voltage is the compensation voltage; then the next round of comparison is performed, and if the compensation voltage this time is also less than V0, V0 is temporarily set to be in the compensation voltage interval whose lower limit compensation voltage is the compensation voltage compared this time, that is, the compensation voltage interval where the current compensation voltage is located is updated; until the compared compensation voltage is greater than V0, the compensation voltage interval where the current compensation voltage is located is finally obtained, and the finally obtained compensation voltage interval is stored in EXCEL. Assume that the current compensation voltage is -84V, taking Table 2 as an example; when performing the first comparison, since -150V is less than -84V, the compensation voltage interval of -84V is temporarily determined to be (-90V, -150V); then the next round of comparison is performed, since -90V is less than -84V, the compensation voltage interval of -84V is temporarily determined to be (-90V, -80V); then the next round of comparison is performed, since -70V is greater than -84V, the cycle ends, and the compensation voltage interval is not updated, that is, the compensation voltage interval of -84V is determined to be (-90V, -80V).

[0056] S302, calculating the initial current variable of the detector according to the compensation voltage interval in which the current compensation voltage is located, and the current compensation voltage and current compensation current of the detector at a certain moment.

[0057] Specifically, after knowing the compensation voltage interval in which the current compensation voltage is located, the upper limit compensation current variable and the lower limit compensation current variable of the compensation voltage interval are obtained according to the relationship curve model, and then the initial current variable of the relationship curve model is calculated according to the slope relationship.

[0058] The specific process is as follows:

[0059] (V0-V1) / (I0-I1*X)=(V2-V1) / (I2*X-I1*X) (1);

[0060] Among them, V0 is the current compensation voltage; I0 is the current compensation current; V1 is the lower limit voltage variable of the compensation voltage interval where V0 is located; X is the initial current variable assumed in step S20; I1*X is the lower limit voltage variable of the compensation voltage interval where V0 is located; V2 is the upper limit voltage variable of the compensation voltage interval where V0 is located; I2*X is the upper limit voltage variable of the compensation voltage interval where V0 is located; in addition, I1 and I2 are multiple factors of the corresponding voltage variables. Taking Table 2 as an example, the multiple factor I1 of the lower limit voltage variable of the compensation voltage interval (-90V, -80V) corresponds to 0.0625, and the multiple factor I2 of the upper limit voltage variable corresponds to 0.125;

[0061] According to formula (1), we can deduce:

[0062] X=I0 / [I1+(I2-I1)*(V0-V1) / (V2-V1)] (2);

[0063] Substituting the values ​​of I0, V0, I1, V1, I2 and V2 into formula (2), the initial current variable X can be obtained.

[0064] S40, fitting the initial current variable and the relationship curve model to obtain a real relationship curve for characterizing the relationship between the real compensation voltage and the real compensation current of the detector. Specifically, the initial current variable is substituted into the relationship curve model to obtain the real compensation current at the boundary of each compensation voltage interval of the detector, and based on the upper limit compensation voltage, the lower limit compensation voltage of each compensation voltage interval, and the corresponding real compensation current, a curve fitting process is performed to obtain the real relationship curve.

[0065] S50, calculating the predicted compensation voltage according to the preset compensation current of the detector and the real relationship curve. Specifically, the compensation voltage interval where the preset compensation current is located is determined through a loop statement, and further, the upper limit compensation voltage and the lower limit compensation voltage of the compensation voltage interval are obtained according to the real relationship curve, and then the predicted compensation voltage corresponding to the preset compensation current is obtained through the slope relationship.

[0066] Since the source range count rate and current are both proportional to the neutron flux, it can be considered that the relationship between the source range count rate and the compensation current of the intermediate range is also proportional, and thus:

[0067] I3 / I4=ICS3 / ICS4 (3);

[0068] Among them, I3 is the first compensation current; ICS3 corresponds to the first source range count rate under the first compensation current; I4 is the second compensation current; ICS4 corresponds to the second source range count rate under the second compensation current.

[0069] Therefore, in some embodiments, step S50 further includes: calculating a predicted compensation voltage according to a current source range count rate corresponding to a current compensation current of the detector at a certain moment, a preset source range count rate, and a real relationship curve.

[0070] Specifically, the current compensation current, the current source range count rate and the preset source range count rate are substituted into formula (3) to obtain the corresponding preset compensation current, and then the predicted compensation voltage corresponding to the preset source range count rate is calculated based on the preset compensation current.

[0071] In some embodiments, step S50 also includes: performing inverse operation on the preset compensation voltage and the true relationship curve of the detector to calculate the predicted source range count rate and predicted compensation current corresponding to the preset compensation voltage, thereby effectively helping the staff to quickly know whether the preset compensation voltage is suitable.

[0072] In some embodiments, the VBA-based mid-range compensation voltage prediction method further includes: step S01.

[0073] S01. Based on VBA code, a human-computer interaction interface is established for obtaining the current compensation voltage, current compensation current, current source range count rate, preset compensation current, and preset source range count rate at a certain moment; the human-computer interaction interface is also used to display the predicted compensation voltage.

[0074] Furthermore, the human-computer interaction interface can also obtain the preset compensation voltage through the display window of the predicted compensation voltage, and display the predicted source range count rate and predicted compensation current obtained after the inverse operation in the acquisition window of the preset source range count rate and the preset compensation current. Figure 3 .

[0075] like Figure 4 As shown, the present invention also constructs a VBA-based intermediate range compensation voltage prediction system, which includes an interval division processing unit, a model making unit, an initial current variable calculation unit, a curve making unit and a predicted compensation voltage calculation unit.

[0076] The interval division processing unit is used to perform interval division processing on the historical compensation voltage and historical compensation current of the intermediate range and output interval data.

[0077] In some embodiments, in the interval division processing unit, the interval division processing of the historical compensation voltage and the historical compensation current of the middle range includes: based on the preset multiples of the historical compensation current of the middle range, the historical compensation voltage of the middle range is divided into several compensation voltage intervals, so that the ratio of the upper limit compensation current to the lower limit compensation current of each of the several compensation voltage intervals is a preset multiple, and the compensation voltage interval and the preset multiple constitute the interval data.

[0078] The model making unit is used to establish a relationship curve model for characterizing the relationship between the compensation voltage and the compensation current according to the interval data.

[0079] Furthermore, the model making unit is used to assume that the upper limit compensation current of a certain compensation voltage interval is the initial current variable, and calculate the upper limit compensation current variable and the lower limit compensation current variable of each compensation voltage interval according to the initial current variable, the compensation voltage interval and the preset multiple, and establish a relationship curve model according to the compensation voltage interval, the upper limit compensation current variable and the lower limit compensation current variable.

[0080] The initial current variable calculation unit is used to calculate the initial current variable of the detector according to the current compensation voltage and current compensation current of the detector at a certain moment and the relationship curve model.

[0081] Furthermore, the initial current variable calculation unit performs interval positioning processing on the current compensation voltage of the detector at a certain moment through a loop statement to determine the compensation voltage interval in which the current compensation voltage is located; and calculates the initial current variable of the detector based on the compensation voltage interval in which the current compensation voltage is located, as well as the current compensation voltage and current compensation current of the detector at a certain moment.

[0082] The curve making unit is used to fit the initial current variable and the relationship curve model, and output a real relationship curve for characterizing the relationship between the real compensation voltage and the real compensation current of the detector.

[0083] The predicted compensation voltage calculation unit is used to calculate the predicted compensation voltage according to the preset compensation current of the detector and the real relationship curve.

[0084] Furthermore, the predicted compensation voltage calculation unit is also used to calculate the predicted compensation voltage according to the current source range count rate corresponding to the current compensation current of the detector at a certain moment, the preset source range count rate, and the real relationship curve.

[0085] Furthermore, the predicted compensation voltage calculation unit is further used to perform inverse operation processing on the preset compensation voltage of the detector and the real relationship curve to calculate the predicted source range count rate and predicted compensation current corresponding to the preset compensation voltage.

[0086] like Figure 4 As shown, in some embodiments, the VBA-based intermediate-range compensation voltage prediction system also includes a human-computer interaction interface; the human-computer interaction interface is used to obtain the current compensation voltage, current compensation current, current source range count rate, preset compensation current, and preset source range count rate at a certain moment, and display the predicted compensation voltage.

[0087] Furthermore, the human-computer interaction interface can also obtain the preset compensation voltage through the display window of the predicted compensation voltage, and correspondingly display the predicted source range count rate and predicted compensation current obtained after the inverse operation in the acquisition window of the preset source range count rate and the preset compensation current.

[0088] The model making unit, the initial current variable calculation unit, the curve making unit, the predicted compensation voltage calculation unit and the human-computer interaction interface can all be made by VBA codes.

[0089] It can be understood that the implementation of the present invention only requires inputting a preset compensation current to quickly calculate the corresponding predicted compensation voltage and predicted source range count rate, which not only has high calculation efficiency and reduces the workload of staff, but also reduces the risk of human calculation errors and improves calculation accuracy. In addition, the corresponding predicted compensation voltage and predicted compensation current can be calculated according to the preset source range count rate, so that staff can predict in advance whether the compensation voltage is appropriate, which plays a positive role in on-site work.

[0090] It can be understood that the above embodiments only express the preferred implementation modes of the present invention, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the patent scope of the present invention. It should be pointed out that, for ordinary technicians in this field, the above technical features can be freely combined without departing from the concept of the present invention, and several deformations and improvements can be made, which all belong to the protection scope of the present invention. Therefore, all equivalent changes and modifications made to the scope of the claims of the present invention should belong to the coverage of the claims of the present invention.

Claims

1. A method for predicting the intermediate range compensation voltage based on VBA, It is characterized in that The following steps are involved: S10, dividing the historical compensation voltage and historical compensation current of the middle range into intervals to obtain interval data; S20, establishing a relationship curve model for characterizing the relationship between the compensation voltage and the compensation current according to the interval data; S30, calculating the initial current variable of the detector according to the current compensation voltage and current compensation current of the detector at a certain moment and the relationship curve model; S40, fitting the initial current variable and the relationship curve model to obtain a real relationship curve for characterizing the relationship between the real compensation voltage and the real compensation current of the detector; S50, calculating a predicted compensation voltage according to the preset compensation current of the detector and the real relationship curve; The steps S20 to S50 are implemented by VBA codes.

2. The method for predicting the intermediate range compensation voltage based on VBA according to claim 1, It is characterized in that In the step S10, the interval division processing of the historical compensation voltage and the historical compensation current of the middle range includes: based on the preset multiples of the historical compensation current of the middle range, the historical compensation voltage of the middle range is divided into a number of compensation voltage intervals, so that the ratio of the upper limit compensation current to the lower limit compensation current of each of the several compensation voltage intervals is the preset multiple, and the compensation voltage interval and the preset multiple constitute the interval data.

3. The method for predicting the intermediate range compensation voltage based on VBA according to claim 2, It is characterized in that The step S20 includes: assuming that the upper limit compensation current of a certain compensation voltage interval is an initial current variable, calculating the upper limit compensation current variable and the lower limit compensation current variable of each compensation voltage interval according to the initial current variable, the compensation voltage interval and the preset multiple, and establishing a relationship curve model according to the compensation voltage interval, the upper limit compensation current variable and the lower limit compensation current variable.

4. The method for predicting the intermediate range compensation voltage based on VBA according to claim 3, It is characterized in that The step S30 comprises: S301, performing interval positioning processing on the current compensation voltage of the detector at a certain moment by using a loop statement, and determining the compensation voltage interval where the current compensation voltage is located; S302: Calculate an initial current variable of the detector according to the compensation voltage interval in which the current compensation voltage is located, and the current compensation voltage and current compensation current of the detector at a certain moment.

5. The VBA-based intermediate range compensation voltage prediction method according to claim 4, It is characterized in that The step S50 further includes: calculating a predicted compensation voltage according to a current source range count rate corresponding to a current compensation current of the detector at a certain moment, a preset source range count rate, and a real relationship curve.

6. The method for predicting the intermediate range compensation voltage based on VBA according to claim 5, It is characterized in that Also includes: S01. Based on the VBA code, a human-computer interaction interface is established for obtaining the current compensation voltage, the current compensation current, the current source range count rate, the preset compensation current, and the preset source range count rate at the certain moment; the human-computer interaction interface is also used to display the predicted compensation voltage.

7. A VBA-based mid-range compensation voltage prediction system, It is characterized in that include: An interval division processing unit is used to perform interval division processing on the historical compensation voltage and historical compensation current of the intermediate range and output interval data; A model making unit, used for establishing a relationship curve model for characterizing the relationship between the compensation voltage and the compensation current according to the interval data; An initial current variable calculation unit, used to calculate the initial current variable of the detector according to the current compensation voltage and current compensation current of the detector at a certain moment and the relationship curve model; A curve making unit, used for fitting the initial current variable and the relationship curve model, and outputting a real relationship curve for characterizing the relationship between the real compensation voltage and the real compensation current of the detector; A predicted compensation voltage calculation unit, used to calculate the predicted compensation voltage according to the preset compensation current of the detector and the real relationship curve; The model making unit, the initial current variable calculating unit, the curve making unit and the predicted compensation voltage calculating unit are made using VBA code.

8. The VBA-based intermediate range compensation voltage prediction system according to claim 7, It is characterized in that In the interval division processing unit, the interval division processing of the historical compensation voltage and the historical compensation current of the middle range includes: based on the preset multiples of the historical compensation current of the middle range, the historical compensation voltage of the middle range is divided into a number of compensation voltage intervals, so that the ratio of the upper limit compensation current to the lower limit compensation current of each of the several compensation voltage intervals is the preset multiple, and the compensation voltage interval and the preset multiple constitute the interval data.

9. The VBA-based intermediate range compensation voltage prediction system according to claim 8, It is characterized in that The model making unit is used to assume that the upper limit compensation current of a certain compensation voltage interval is an initial current variable, calculate the upper limit compensation current variable and the lower limit compensation current variable of each compensation voltage interval according to the initial current variable, the compensation voltage interval and the preset multiple, and make a relationship curve model according to the upper limit compensation current variable and the lower limit compensation current variable.

10. The VBA-based intermediate range compensation voltage prediction system according to claim 7, It is characterized in that Also includes: The human-computer interaction interface is used to obtain the current compensation voltage and the current compensation current at the certain moment, as well as the preset compensation current, and display the predicted compensation voltage.

Images