CN105912817A - Excel software based method for judging concrete strength guarantee rate - Google Patents
Excel software based method for judging concrete strength guarantee rate Download PDFInfo
- Publication number
- CN105912817A CN105912817A CN201610296496.0A CN201610296496A CN105912817A CN 105912817 A CN105912817 A CN 105912817A CN 201610296496 A CN201610296496 A CN 201610296496A CN 105912817 A CN105912817 A CN 105912817A
- Authority
- CN
- China
- Prior art keywords
- concrete strength
- actual measurement
- parameter
- measurement value
- concrete
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F30/00—Computer-aided design [CAD]
- G06F30/20—Design optimisation, verification or simulation
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Computer Hardware Design (AREA)
- Evolutionary Computation (AREA)
- Geometry (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses an Excel software based method for judging a concrete strength guarantee rate. The method comprises the following steps of establishing a parameter matrix based on Excel; determining a computing formula of each parameter in the parameter matrix and inputting the computing formula into a position corresponding to each parameter in the parameter matrix; and based on the computing formula of each parameter and actually measured concrete strength, obtaining an actual value of each parameter by utilizing an interpolation method. The method can be used for calculating the concrete strength guarantee rate in hydraulic and hydropower engineering and highway engineering, and is wide in application range; a method for inserting a function by utilizing Excel is simple and easy to learn; and the method is convenient in operation, quick and accurate, can be used in a computer and also can be imported in a mobile phone for use at a construction site.
Description
Technical field
The present invention relates to concrete index calculating method.Sentence based on Excel software more particularly, to one
The method determining probability of ensuring strength of concrete.
Background technology
Concrete for hydraulic structure the strength factor of assurance is the units such as construction, construction, management, quality testing, quality surveillance
Concrete is carried out quality management and prevailing quality project during quality grade evaluation, at present it is being counted
During calculation, the method proposed in most SDJ207 of employing " concrete construction specification ".The method root
According to coefficient of dispersion, concrete strength meansigma methods, concrete design strength, difference probability of ensuring strength of concrete curve
Figure etc. obtains probability of ensuring strength of concrete.The weak point of this method is: 1. calculate cumbersome, and holds
Error-prone, 2. calculate the time long, 3. look into curve chart precision the highest, 4. look into figure judgement when fraction reaches 80%
Just acquire a certain degree of difficulty and subjectivity.To this, arrange and use interpolation computed in software probability of ensuring strength of concrete, can
Overcome the weakness of above computational methods, accurate concrete strength can be calculated again in the short period of time and ensure
Rate, provides guarantee for evaluating concrete quality accurately.
Summary of the invention
It is an object of the present invention to provide a kind of based on Excel software judgement probability of ensuring strength of concrete
Method, uses interpolation calculation probability of ensuring strength of concrete based on Excel software, and method is simple, operation side
Just, practical.
For reaching above-mentioned purpose, the present invention uses following technical proposals:
A kind of method judging probability of ensuring strength of concrete based on Excel software, the method comprises the steps:
1) parameter matrix is set up based on Excel；
2) computing formula of each parameter in described parameter matrix is determined and by computing formula input and described ginseng
The position that in matrix number, each parameter is corresponding；
3) computing formula based on each parameter and actual measurement concrete strength, utilize interpolation to obtain each parameter
Real-valued.
Further, step 1) described in parameter matrix in parameter include:
Qualified index, group number, meansigma methods, maximum, minima, standard deviation, coefficient of dispersion, fraction,
Qualification rate, qualified lower limit and concrete strength.
Further, described qualified lower limit is the qualified lower limit of concrete, and described concrete strength is actual measurement coagulation
Soil intensity.
Further, step 2) computing formula of described each parameter is as follows:
Qualified index >=design load；
Group number=COUNT (N number of actual measurement value of concrete strength)；
Meansigma methods=AVERAGE (N number of actual measurement value of concrete strength)；
Maximum=MAX (N number of actual measurement value of concrete strength)；
Minima=MIN (N number of actual measurement value of concrete strength)；
Standard deviation=STDEV (N number of actual measurement value of concrete strength)；
Coefficient of dispersion=STDEV (N number of actual measurement value of concrete strength)/AVERAGE (N number of actual measurement coagulation
Soil intensity level)；
Fraction=NORMSDIST ((AVERAGE (N number of actual measurement value of concrete strength)-qualified lower limit)
/ STDEV (N number of actual measurement value of concrete strength) * 100；
Qualification rate=COUNT (N number of actual measurement value of concrete strength, design load)/COUNT (N number of actual measurement
Value of concrete strength) * 100；
N is positive integer.
Beneficial effects of the present invention is as follows:
This method can calculate in the strength factor of assurance use at Hydraulic and Hydro-Power Engineering, highway engineering concrete, is suitable for
Scope is wide, and the method utilizing Excel insertion function is easy to learn, easy to operate, quick and precisely, and can be at electricity
Brain uses, it is possible to imports mobile phone and uses at the construction field (site).
Accompanying drawing explanation
Fig. 1 is the calculating schematic diagram utilizing Excel software to judge probability of ensuring strength of concrete.
Detailed description of the invention
In order to be illustrated more clearly that the present invention, below in conjunction with preferred embodiments and drawings, the present invention is done further
Explanation.
A kind of method based on Excel software judgement probability of ensuring strength of concrete comprises the steps:
The first step: beginning → program → Microsoft Excel → newly-built worksheet；
Second step: as it is shown in figure 1, in newly-built Excel worksheet, sequentially input from A2 to K2:
Qualified index, group number, meansigma methods, maximum, minima, standard deviation, coefficient of dispersion, fraction, conjunction
Lattice rate, qualified lower limit and concrete strength parameters title；
3rd step: insert formula；
In worksheet A3, input the qualified index of concrete, i.e. concrete strength ＞=design load (note:
Now input ＞ time must not use insertion method, keyboard to be adjusted to English, pin shift+ ".",
Use on keyboard=key directly inputs=)；In the present embodiment, design load takes 40.
Insertion group number function=COUNT (K4:K500) in worksheet B3；
Mean function=AVERAGE (K4:K500) is inserted in worksheet C3；
Max function=MAX (K4:K500) is inserted in worksheet D3；
Minimum value function=MIN (K4:K500) is inserted in worksheet E3；
Standard deviation function=STDEV (K4:K500) is inserted in worksheet F3；
Coefficient of dispersion computing formula is inserted: coefficient of dispersion=standard deviation is divided by meansigma methods, i.e. in worksheet G3
Function=F3/C3 is inserted in G3；
Probability of ensuring strength of concrete function is inserted in worksheet H3
=NORMSDIST ((C3-J3)/F3) * 100；
Qualification rate function=COUNTIF (K4:K500, A3)/B3*100 is inserted in worksheet I3；
Inputting the qualified lower limit of concrete in worksheet J3, general provision is Concrete Design value；
All above function can preserve Excel after having inserted and forever use；
4th step: insert actual measurement concrete strength in worksheet K4 to K23,
In the form of K4 to K23, sequentially input 43.3,42.1,44.5,44.5,45.1,45.7,46.3,
46.9,47.5,48.1,48.7,49.3,49.9,50.5,51.1,51.7,52.3,52.9,53.5 and
54.1；Inputting qualified lower limit in J3, in the present embodiment, qualified lower limit takes 40；
Worksheet B3 to I3 calculates automatically and generates accordingly result；
Value in B3 is 20；
Value in C3 is 48.4；
Value in D3 is 54.1；
Value in E3 is 42.1；
Value in F3 is 3.5656254；
Value in G3 is 0.0736699；
Value in H3 is 99.075926；
Value in I3 is 100%.
Obviously, the above embodiment of the present invention is only for clearly demonstrating example of the present invention, and also
Non-is the restriction to embodiments of the present invention, for those of ordinary skill in the field, above-mentioned
Can also make other changes in different forms on the basis of explanation, here cannot be to all of enforcement
Mode gives exhaustive, every belongs to the obvious change or variation that technical scheme extended out
Row still in protection scope of the present invention.
Claims (4)
1. the method judging probability of ensuring strength of concrete based on Excel software, it is characterised in that the party
Method comprises the steps:
1) parameter matrix is set up based on Excel；
2) computing formula of each parameter in described parameter matrix is determined and by computing formula input and described ginseng
The position that in matrix number, each parameter is corresponding；
3) computing formula based on each parameter and actual measurement concrete strength, utilize interpolation to obtain each parameter
Real-valued.
Method the most according to claim 1, it is characterised in that step 1) described in parameter matrix in
Parameter include:
Qualified index, group number, meansigma methods, maximum, minima, standard deviation, coefficient of dispersion, fraction,
Qualification rate, qualified lower limit and concrete strength.
Method the most according to claim 2, it is characterised in that: described qualified lower limit is that concrete closes
Lattice lower limit, described concrete strength is actual measurement concrete strength.
Method the most according to claim 3, it is characterised in that step 2) meter of described each parameter
Calculation formula is as follows:
Qualified index >=design load；
Group number=COUNT (N number of actual measurement value of concrete strength)；
Meansigma methods=AVERAGE (N number of actual measurement value of concrete strength)；
Maximum=MAX (N number of actual measurement value of concrete strength)；
Minima=MIN (N number of actual measurement value of concrete strength)；
Standard deviation=STDEV (N number of actual measurement value of concrete strength)；
Coefficient of dispersion=STDEV (N number of actual measurement value of concrete strength)/AVERAGE (N number of actual measurement coagulation
Soil intensity level)；
Fraction=NORMSDIST ((AVERAGE (N number of actual measurement value of concrete strength)-qualified lower limit)
/ STDEV (N number of actual measurement value of concrete strength) * 100；
Qualification rate=COUNT (N number of actual measurement value of concrete strength, design load)/COUNT (N number of actual measurement
Value of concrete strength) * 100；
N is positive integer.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610296496.0A CN105912817A (en) | 2016-05-06 | 2016-05-06 | Excel software based method for judging concrete strength guarantee rate |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610296496.0A CN105912817A (en) | 2016-05-06 | 2016-05-06 | Excel software based method for judging concrete strength guarantee rate |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105912817A true CN105912817A (en) | 2016-08-31 |
Family
ID=56747802
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610296496.0A Pending CN105912817A (en) | 2016-05-06 | 2016-05-06 | Excel software based method for judging concrete strength guarantee rate |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105912817A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108009359A (en) * | 2017-12-01 | 2018-05-08 | 中国空气动力研究与发展中心高速空气动力研究所 | A kind of boundary layer parameters computational methods and system based on Excel |
| CN114516742A (en) * | 2022-02-25 | 2022-05-20 | 中铁二十三局集团轨道交通工程有限公司 | Concrete mixing proportion selection method doped with gel reducer |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101266597A (en) * | 2008-04-09 | 2008-09-17 | 顾宝仁 | Method for generating quality management common tool drawing at Excel |
| CN102831105A (en) * | 2012-07-19 | 2012-12-19 | 缪建军 | Method for making coefficient table for *-R control chart by using EXCEL software and MINITAB15 software |
-
2016
- 2016-05-06 CN CN201610296496.0A patent/CN105912817A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101266597A (en) * | 2008-04-09 | 2008-09-17 | 顾宝仁 | Method for generating quality management common tool drawing at Excel |
| CN102831105A (en) * | 2012-07-19 | 2012-12-19 | 缪建军 | Method for making coefficient table for *-R control chart by using EXCEL software and MINITAB15 software |
Non-Patent Citations (4)
| Title |
|---|
| 彭文成 等: ""利用Excel软件计算水工混凝土强度保证率"", 《四川省水利学会2004年学术年会》 * |
| 彭文成: ""利用Excel软件计算水工混凝土强度保证率"", 《四川水利》 * |
| 沈鹤鸣: ""利用计算表格快速评定混凝土强度"", 《住宅科技》 * |
| 缪景洪: ""利用Excel计算混凝土的强度指标"", 《城市建设理论研究（电子版）》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108009359A (en) * | 2017-12-01 | 2018-05-08 | 中国空气动力研究与发展中心高速空气动力研究所 | A kind of boundary layer parameters computational methods and system based on Excel |
| CN108009359B (en) * | 2017-12-01 | 2021-06-11 | 中国空气动力研究与发展中心高速空气动力研究所 | Excel-based boundary layer parameter calculation method and system |
| CN114516742A (en) * | 2022-02-25 | 2022-05-20 | 中铁二十三局集团轨道交通工程有限公司 | Concrete mixing proportion selection method doped with gel reducer |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| WO2021129039A1 (en) | Method and system for calculating cross-reservoir drainage basin river runoff | |
| CN109376925B (en) | Dynamic self-adaptive optimization method for node flow of water supply pipe network | |
| CN104392274B (en) | The short-term electro-load forecast method in city based on power load and temperature trend | |
| CN110619432A (en) | Feature extraction hydrological forecasting method based on deep learning | |
| CN106354940B (en) | Landscape water quality simulation and method for early warning based on the input of WASP water quality model uncertainty | |
| CN107341328A (en) | Based on the Ground Settlement method for improving Verhulst curves | |
| CN105912817A (en) | Excel software based method for judging concrete strength guarantee rate | |
| CN106202935A (en) | The bearing calibration of a kind of Watershed Runoff forecast and system thereof | |
| CN107391778B (en) | A kind of Analytic Calculation Method of circular tunnel seepage discharge | |
| CN105488307A (en) | Evaluation method of slope monitoring and early warning system based on Big Dipper | |
| CN105260586A (en) | Automatic meteorological station wind speed data processing method aiming at overhead transmission line | |
| CN106651054A (en) | Method for identifying roughness of water conveyance channel of long-distance water transfer project based on genetic algorithm | |
| CN110186533A (en) | A kind of short-term tide prediction method in high-precision river mouth | |
| CN114021078A (en) | Optimal statistical model optimization method for dam monitoring quantity | |
| CN104866715A (en) | Electrical power system robust state estimation method based on self-adaptive kernel density estimation | |
| JPH11194803A (en) | Dam discharging flow rate prediction model constructing method and dam discharging flow rate predicting method | |
| CN109146239A (en) | Based on FDA and theoretical Seepage Safety integrated evaluating method can be opened up | |
| CN107017624A (en) | Electric load cycle characteristics modeling method | |
| CN112528563B (en) | Urban waterlogging early warning method based on SVM algorithm | |
| CN104537418A (en) | From-bottom-to-top high-dimension-data causal network learning method | |
| CN109101759A (en) | A kind of parameter identification method based on forward and reverse response phase method | |
| CN103164625B (en) | A kind of method being estimated each parameter in PAS system by measured data | |
| Qiu et al. | The use of an integrated variable fuzzy sets in water resources management | |
| Lu et al. | RISK ANALYSIS OF HYDRAULIC ENGINEERING CONSTRUCTIONS. | |
| CN110633532B (en) | High-precision calibration method for SWMM model parameters |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20160831 |
|
| RJ01 | Rejection of invention patent application after publication |