| Reinforcement engineering is related to the safety of the structure, has a significant effecton cost, so under the reinforcement measure and site construction blanking and concealmentacceptance must follow certain rules concealment acceptance need reference basis should beclear. Arrangement of reinforcement number and determination of location, node processingmust have detailed and graphical picture. Construction personnel and supervisors, or theconstructions’ technical personnel at the site of the construction contrast the graphics toshortening the time of acceptance and improve the efficiention. Reinforcement engineeringmeasurement is the basis of reinforced blanking under construction. Standard reinforcement isuseful to decrease error between reinforcement engineering measurement and blanking to laysfoundation for late settlement and audit of quantities.The measurement and blanking and concealed acceptance of reinforcement engineeringis separated and closely linked, they are belong to the reinforcement engineering of extensionof longitudinal, but that are artificially divided in currently. It is a reinforced calculation tablewhen bidding,and a reinforced blanking table when in the site of construction, and need tocarry the drawings to the site of construction to accept the concealment what caused thereinforcement engineering is no consistency in the quantity. Therefore, be summarized thereinforced engineering measurement, blanking and acceptance in Excel spreadsheet can forma trinity of effective Excel to deal with above qustion.The principle of specifications and atlas is more and calculation is complicated inreinforced engineering measurement. In this paper, generalized the frame beam and columnand slab reinforcement calculation principle of the cast-in-situ reinforced concrete. Using thenested in the Excel sheet and function of the Excel VBA language to embed the principle inmeasurement and blanking and drawing beam and slab reinforced acceptance of rendering inthat to some extent can realize intergration research and application of measurement, blankingand concealment acceptance in reinforcement engineering. The results will eventually reducethe the project cost, at the same time guide field reinforced sample worker for reinforcedblanking and save steel and optimizing blanking. That can be concealed engineeringacceptance as a basis for the acceptance to save the time of concealment acceptance andrealize the reinforcement engineering process management ideas.The intergration form of measurement, blanking and concealment acceptance inreinforcement engineering mainly includes the worksheet of general information sheet, theworksheet of difference of reinforced scarfskin in size, the worksheet of basic anchoragelength of reinforced, the worksheet of reinforced calculation and blanking of beam, slab, module, the worksheet of stirrup measurment and blanking module, the worksheet ofreinforced engineering of measurment and blanking, the worksheet of summary statistics. Inthe of measurement, blanking and acceptance reinforced engineering, and usually it is iscomposed of three parts in reinforced calculation, which are including horizontal or verticalcomponent, calculate of stirrups, and the component of summary statistics. In this thesis ismainly to set module of reinforced engineering about beam, plate and stirrup and whichsetting module is embedded into Excel with the calculation principle of beam, plate, columnto realize the automatic calculation. The reinforced module of beam and slab mainly set up26types, and stirrup set up four kinds of main forms which was divided into single limb hoopand double limb hoop. If actually use need to combinate of calculation. |