• Title/Summary/Keyword: Excel-solver

Search Result 26, Processing Time 0.018 seconds

Coloration behaviors of phthalocyanine reactive dye on nylon substrates: experiments, empirical modeling and statistical analysis

  • Kim, Byung-Soon;Ravikumar, K.;Yoon, Seok-Han;Son, Young-A
    • Textile Coloration and Finishing
    • /
    • v.19 no.2
    • /
    • pp.14-23
    • /
    • 2007
  • This research article explores the use of phthalocyanine reactive dye on nylon substrate. The effect of factors such as pH, temperature, liquor ratio and alkali addition on level of dye exhaustion, fixation and total fixation efficiency. Low pH, high temperature and low liquor ratio were found to be suitable conditions for maximum % exhaustion values. The effect of sulphatoethylsulphone(SES) and vinylsulphone(VS) form of the dyes on level of dye fixation was also discussed. The optimized exhaustion (%E), fixation(%F) and total fixation efficiency were determined. Modification of the dyeing process with alkali addition displayed that dye fixation(%) increased by alkali addition. Vinylsulphone(VS) moiety of the dye was found to be superior to. maximum fixation (%F). Appropriate predictable empirical models, relatively a new approach in dyeing processes, were developed incorporating interactions effects of temperature, pH and liquor ratio for predicting % exhaustion, fixation and total fixation efficiency. The significance of the mathematical model developed was ascertained using microsoft excel regression(solver) analysis module. High correlation coefficient was obtained (R2=0.9895 for % exhaustion, R2=0.9932 for fixation, R2=0.9965 for total fixation efficiency) for the model which shows prominent prediction capacity of the model for my conditions. The predictable polynomial equations developed from tile experimental results were thoroughly analyzed by ANOVA (Analysis of Variance) statistical concepts.

A Study on the Method of Optimizing the Test Order of Explosive Detection System Using Analytic Hierarchy Process and Objective Rating (계층분석방법 및 객관적평가법을 활용한 폭발물탐지장비 시험순서 최적화 방법에 관한 연구)

  • Sun-Ju, Won;Hyun Su, Sim;Yong Soo, Kim
    • Journal of Korean Society for Quality Management
    • /
    • v.50 no.4
    • /
    • pp.793-810
    • /
    • 2022
  • Purpose: As improving the search performance of aviation security equipment is considered essential, this study proposes the need for research on how to find an optimized test sequence that can reduce test time and operator power during the search function test of explosive detection systems. We derive the weights and work difficulty adjustment factor required to find the optimized test order. Methods: First, after setting the test factors, the time of each test and the difficulty scale determined by the worker who performed the test directly were used to derive weights. Second, the work difficulty adjustment coefficient was determined by combining the basic weight adjustment factor and corresponding to the body part used by the test using objective rating. Then the final standard time was derived by calculating the additional weights for the changeability of the test factors. Results: The order in which the final standard time is minimized when 50 tests are performed was defined as the optimized order. 50 tests should be conducted without duplication and the optimal order of tests was obtained when compared to previously numbered tests. As a result of minimizing the total standard time by using Excel's solver parameters, it was reduced by 379.14 seconds, about 6.32 minutes. Conclusion: We tried to express it in mathematical formulas to propose a method for setting an optimized test sequence even when testing is performed on other aviation security equipment. As a result, the optimal test order was derived from the operator's point of view, and it was demonstrated by minimizing the total standard time.

Sensitivity analysis for freight rate change in liner shipping industry - Comparison between slot chartering model and non-collaborating model - (정기선 해운사의 해상운송 요율 변화에 대한 민감도 분석 - 단독 운송과 제휴 운송 비교 -)

  • Chung, Ki-Ho
    • Management & Information Systems Review
    • /
    • v.34 no.4
    • /
    • pp.1-13
    • /
    • 2015
  • This paper presents a mathematical formulation for container slot chartering model through strategic alliance between liner shipping companies. This paper develops a solution procedure to apply the model to real world problems and its applicability is demonstrated by a numerical example. The model presented in this paper has some important features which have never been considered in the previous researches. The model is linear model and pursuits profit maximization. And also it considers slot chartering capacity selection. This paper attempts to perform sensitivity analysis and compares slot chartering model with basic non-collaborating model in which there is no alliance and collaboration. As a result of sensitivity analysis, some interesting findings are obtained; Even though freight rate is more and more decreasing, the profit by slot chartering model is always higher than the basic model but the profit gaps become smaller. But The ratio of the profit gap to the profit of basic model is more increasing.

  • PDF

A Study of Reliability of Predictive Models for Permanent Deformation and Fatigue Failure Related to Flexible Pavement Design (연성포장설계의 소성변형과 피로파괴 예측모델에 대한 신뢰성 연구)

  • Kim, Dowan;Han, Beomsoo;Kim, Yeonjoo;Mun, Sungho
    • International Journal of Highway Engineering
    • /
    • v.16 no.6
    • /
    • pp.105-113
    • /
    • 2014
  • PURPOSES: The objective of this paper is to select the confidential intervals by utilizing the second moment reliability index(Hasofer and Lind; 1974) related to the number of load applications to failure which explains the fatigue failure and rut depth that it indicates the permanent deformation. By using Finite Element Method (FEM) Program, we can easily confirm the rut depth and number of load repetitions without Pavement Design Procedures for generally designing pavement depths. METHODS : In this study, the predictive models for the rut depth and the number of load repetitions to fatigue failure were used for determining the second moment reliability index (${\beta}$). From the case study results using KICTPAVE, the results of the rut depth and the number of load repetitions to fatigue failure were deducted by calculating the empirical predictive equations. Also, the confidential intervals for rut depth and number of load repetitions were selected from the results of the predictive models. To determine the second moment reliability index, the spreadsheet method using Excel's Solver was used. RESULTS : From the case studies about pavement conditions, the results of stress, displacement and strain were different with depth conditions of layers and layer properties. In the clay soil conditions, the values of strain and stresses in the directly loaded sections are relatively greater than other conditions. It indicates that the second moment reliability index is small and confidential intervals for rut depth and the number of load applications are narrow when we apply the clay soil conditions comparing to the applications of other soil conditions. CONCLUSIONS : According to the results of the second moment reliability index and the confidential intervals, the minimum and maximum values of reliability index indicate approximately 1.79 at Case 9 and 2.19 at Case 22. The broadest widths of confidential intervals for rut depth and the number of load repetitions are respectively occurred in Case 9 and Case 7.

A Study on the Development of Optimal Renewal Planning Model in Water Supply Facilities Connected to Future Financial Plan of Water Providers (수도사업자의 장래 재정계획과 연계한 상수도시설의 최적 개량계획 수립 모델 개발 연구)

  • Lim, Sanghyun;Shin, Hwisu;Seo, Jeewon;Kim, Kibum;Koo, Jayong
    • Journal of Korean Society of Water and Wastewater
    • /
    • v.31 no.2
    • /
    • pp.149-159
    • /
    • 2017
  • It is considered necessary to renewal a considerable number of water supply facilities in Korea because they began to be intensively buried in the period of rapid economic growth. Accordingly, local water providers are required to take measures against this situation, but they have currently been caught in a vicious circle of the lack of budget spent in renewing water supply facilities because county-based small-scale local water supply cannot afford to cover annual expenditures with their revenues from water rates. Therefore, this study developed an optimal renewal planning model capable of achieving a balance of financial revenue and expenditure in local water supply using nonlinear programming and furthermore of minimizing the total cost incurred during the analysis. To this end, this study selected the water supply area located in County Y as a research area to build the financial revenue and expenditure and used Solver function provided by Microsoft Excel to use nonlinear programming. As a result, this study developed an optimal renewal planning model minimizing incurred costs in consideration of 6 items in the financial revenue and expenditure. The optimal renewal plan was modeled according to the available annual budget. As a result, this study proposed SICD, a scenario to minimize total costs from the perspective of water suppliers, and SITS, a scenario to minimize the increase in water rates from the perspective of consumers. It can be said that the method proposed in this study is the core of the optimal financial and renewal plans as a final stage of asset management for water supply facilities. Therefore, it is considered possible for local water providers to use the method proposed in this study according to circumstances for the asset management of water supply facilities.

A Mathematical Model for Strategic Decision Making in Two Level Supply Chain Network Design (2단계 공급사슬 네트워크에서 전략적 의사결정을 위한 수리적 모형)

  • Chung, Ki-Ho
    • Management & Information Systems Review
    • /
    • v.32 no.3
    • /
    • pp.107-125
    • /
    • 2013
  • This study deals with a strategic decision making in two level supply chain network design. This study presents more realistic mathematical model than the previous studies by considering simultaneous location of plants and distribution centers, determination of capacity level for both plants and distribution centers, and upper limit condition for numbers of locating plants and distribution centers. This paper tries to help the strategic decision making for two level supply chain network design. For this purpose, three different sized numerical examples are generated and optimal solutions are obtained by applying Excel Solver program. And sensitivity analysis is performed for the biggest sized example problem, which has 10 potential plants, 20 potential distribution centers, and 200 customer zones. After the plants being located are fixed, optimal minimum costs are obtained and compared for each of 7 different numbers of distribution centers to be located. As the number of distribution centers increases, changes in inbound transportation cost and outbound transportation cost can be derived. In case of considering cost as well as customer satisfaction level for two level supply chain network design, the analysis of this changes may help more sophisticated decision making.

  • PDF