• Journal of the Korean Geosynthetics Society
• /
• v.22 no.4
• /
• pp.17-26
• /
• 2023

To consider the risk of damage and fracture of P.C strands, the existing post-maintenance system alone has the limitations, hence it is necessary to quantitatively evaluate and predict the deterioration, durability and safety of facilities and establish a reasonable maintenance system considering the asset value of facilities. Therefore, it is worth considering a preventive maintenance plan that allows proactive measures to be taken before a major defect occurs in the temporary anchor. This study devised a preventive over tension method, reviewed its effectiveness through design and field tests, by calculating the resistance factors by performing a reliability-based optimization design. At this time, the over tension anchor method was evaluated using the ratio of the residual tension force after the fracture of P.C strands to the effective tension force before the fracture of P.C strand, followed by the resistance factor calculated by the optimal solution for each random variables using Excel solver and applying it to the limit state equations. As a result of the study, if the over tension ratio is 125% to 130%, the remaining strands showed a high resistance effect even after the fracture of P.C strand. As a result of the optimization design, it was found that it is appropriate to apply the load factor (γ) of 1.25, and the resistance factors of Φ₁, Φ₂, Φ₃ as 0.7, 0.5, 0.6.

• Textile Coloration and Finishing
• /
• v.18 no.4
• /
• pp.43-48
• /
• 2006

A phthalocyanine reactive dye was applied to nylon fibers to study the effects of the temperature and pH on % exhaustion and fixation. In addition, appropriate predictable empirical models, relatively new approaches in dyeing process, were developed incorporating interactions effects of temperature and pH for predicting the both % exhaustion and fixation. The significance of the mathematical model developed was ascertained using Excel regression (solver) analysis module. A very high correlation coefficient was obtained ($R^2=0.9895$ for % exhaustion, $R^2=0.9932$ for fixation) for the model which shows prominent prediction capacity of the model for the unknown conditions. The predictable polynomial equations developed from the Experimental results were thoroughly analyzed by ANOVA (Analysis of Variance) statistical concepts.

• Journal of Korea Water Resources Association
• /
• v.37 no.9
• /
• pp.719-727
• /
• 2004

Water quality models can be applied to manage the regional water quality problems and to estimate the target and allowable pollution load in watershed effectively. The optimization of state variables in the given water quality model Is necessary to build up more effective model. The least-squares method is applied to fit field observations in QUAL2E developed by U.S. EPA, which is most widely used one in the world to simulate the stream water quality, and the optimization model with constraints is constructed to estimate the parameters. The objective function of the optimization model is solved by Solver in Microsoft Excel and Monte Carlo simulation is conducted to know the influence of parameter in conventional pollutants. It is found that this technique is easily implemented and rapidly convergent computational procedure to calibrate the parameters after appling this approach in Anyang stream located in Kyonggi province mainly.

• Structural Engineering and Mechanics
• /
• v.78 no.5
• /
• pp.611-622
• /
• 2021

Composite material-due to low density-causes weight savings, which results in lower fuel consumption of transport vehicles. The aim of the research was to change the existing base-plate of the aluminum airplane container with the composite sandwich plate in order to reduce the weight of the containers of cargo aircrafts. The newly constructed sandwich plate consists of aluminum honeycomb core and composite face-sheets. The face-sheets consist of glass or carbon or hybrid fiber layers. The orientations of the fibers in the face-sheets were 0°, 90° and ±45°. Multi-objective optimization method was elaborated for the newly constructed sandwich plates. Based on the design aim, the importance of the objective functions (weight and cost of sandwich plates) was the same (50%). During the optimization nine design constraints were considered: stiffness, deflection, facing stress, core shear stress, skin stress, plate buckling, shear crimping, skin wrinkling, intracell buckling. The design variables were core thickness and number of layers of the face-sheets. During the optimization both the Weighted Normalized Method of the Excel Solver and the Genetic Algorithm Solver of Matlab software were applied. The mechanical properties of composite face-sheets were calculated by Laminator software according to the Classical Lamination Plate Theory and Tsai-Hill failure criteria. The main added-value of the study is that the multi-objective optimization method was elaborated for the newly constructed sandwich structures. It was confirmed that the optimal new composite sandwich construction-due to weight savings and lower fuel consumption of cargo aircrafts - is more advantageous than conventional all-aluminum container.

• Journal of Microbiology and Biotechnology
• /
• v.19 no.4
• /
• pp.378-386
• /
• 2009

A sequential optimization strategy, based on statistical experimental designs, is employed to enhance the production of alkaline protease by a Bacillus pseudofirmus local isolate. To screen the bioprocess parameters significantly influencing the alkaline protease activity, a 2-level Plackett-Burman design was applied. Among 15 variables tested, the pH, peptone, and incubation time were selected based on their high positive significant effect on the protease activity. A near-optimum medium formulation was then obtained that increased the protease yield by more than 5-fold. Thereafter, the response surface methodology(RSM) was adopted to acquire the best process conditions among the selected variables, where a 3-level Box-Behnken design was utilized to create a polynomial quadratic model correlating the relationship between the three variables and the protease activity. The optimal combination of the major medium constituents for alkaline protease production, evaluated using the nonlinear optimization algorithm of EXCEL-Solver, was as follows: pH of 9.5, 2% peptone, and incubation time of 60 h. The predicted optimum alkaline protease activity was 3,213 U/ml/min, which was 6.4 times the activity with the basal medium.

• Journal of the Korean Chemical Society
• /
• v.51 no.2
• /
• pp.125-128
• /
• 2007

In applying Numerov-Cooley method, Excel tool ‘Solver' is used to match those two wave functions propagated inward and outward, respectively. It is numerically confirmed that the same eigenvalue is obtained by using the average of two energy values of each inward and outward wave functions. This method is applied to a NO molecule potential, and we calculated the variations of the average bond distance and tunneling for a given vibrational energy. It is found that the average bond lengths increase proportionately to the vibrational energy, while the tunneling is not so sensitive to the energy changes. Rather substantial amount of tunnel effect is found for every vibrational state.

• The Journal of the Institute of Internet, Broadcasting and Communication
• /
• v.23 no.3
• /
• pp.139-143
• /
• 2023

The product portfolio problem(PPP) is an optimization problem that determines the production quantity of a particular product to obtain the maximum profit among the n products. Linear programming(LP) is known as the only way to solve this optimization problem. The linear programming method is a problem that optimizes n linear functions and uses LINGO or Excel solver. This paper proposes a simple algorithm that uses CPR, a product cost-profit ratio, to sort in CPR descending order and then determines the maximum allowed production quantity by hand as the actual production quantity. As a result of applying the proposed algorithm to six experimental data, it was shown that more accurate results can be obtained compared to the linear programming method.

• Journal of Navigation and Port Research
• /
• v.39 no.4
• /
• pp.353-360
• /
• 2015

The offshore oil production requires a huge amount of cost and time accompanied by multiple variables due to the peculiar nature of 'offshore'. And every process concerned is controlled by elaborate series of plans for reducing loss of lives, environment and property. This paper treats an optimization problem for offshore oil production and transportation. We present an offshore production and transportation network to define scope of the problem and construct a mixed integer linear programming model to tackle it. To demonstrate the validity of the optimization model presented, some computational experiments based on hypothetical offshore oil fields and demand markets are carried out by using MS Office Excel solver. The downstream of the offshore production and transportation network ends up with the maritime transportation problem distributing the crude oil produced from offshore fields to demand markets. We used MoDiSS(Model-based DSS in Ship Scheduling) which was built to resolve this maritime transportation problem. The paper concludes with the remark that the results of the study might be meaningfully applicable to the real world problems of offshore oil production and transportation.

• Journal of Microbiology and Biotechnology
• /
• v.17 no.12
• /
• pp.1930-1936
• /
• 2007

A sequential optimization strategy based on statistical experimental designs was employed to enhance the production of cyclosporin A (CyA) by Tolypocladium inflatum DSMZ 915 in a submerged culture. A 2-level Plackett-Burman design was used to screen the bioprocess parameters significantly influencing CyA production. Among the 11 variables tested, sucrose, ammonium sulfate, and soluble starch were selected, owing to their significant positive effect on CyA production. A response surface methodology (RSM) involving a 3-level Box-Behnken design was adopted to acquire the best process conditions. Thus, a polynomial model was created to correlate the relationship between the three variables and the CyA yield, and the optimal combination of the major media constituents for cyclosporin A production, evaluated using the nonlinear optimization algorithm of EXCEL-Solver, was as follows (g/l): sucrose, 20; starch, 20; and ammonium sulfate, 10. The predicted optimum CyA yield was 113 mg/l, which was 2-fold the amount obtained with the basal medium. Experimental verification of the predicted model resulted in a CyA yield of 110 mg/l, representing 97% of the theoretically calculated yield.

• Textile Coloration and Finishing
• /
• v.21 no.5
• /
• pp.41-50
• /
• 2009

Design of experiments (DoE) concept was successfully applied to determine the optimum processing conditions that yield maximum % exhaustion for berberine interaction with synthetic tanning agent pretreated polyamide substrates. The potential of synthetic tanning agent to provide anionic sites on the polyamide for berberine interaction which is cationic in nature was tested to increase the % exhaustion of berberine in this article. Experiments were designed according to Central Composite Rotatable Design (CCRD). The three factors for synthetic tanning agent pretreatment and two factors for berberine interaction each at five different levels, including central and axial points were considered. Experiments were conducted in a laboratory scale infra-red treatment instrument according to CCRD. For each response, second order polynomial models were developed using multiple linear regression analysis incorporating linear, interactions and squared effects of all variables and then optimized. The significance of the mathematical model developed was ascertained using Excel regression (solver) analysis module. Analysis of variance (ANOVA) was performed to check the adequacy and accuracy of the fitted models. The response surfaces and contour maps showing the interaction of process variables were constructed. Applying Monte Carlo simulation, response surface and contour plots, optimum operating conditions were found and at this optimum point, % exhaustion of 81% and 74% respectively for synthetic tanning agent pretreatment and berberine interaction were observed and subsequently the results were experimentally investigated.