• 제목/요약/키워드: Excel environment

검색결과 106건 처리시간 0.023초

해양 석유 생산 및 수송 최적화 문제에 관한 연구 (A Study on the Optimization Problem for Offshore Oil Production and Transportation)

  • 김창수;김시화
    • 한국항해항만학회지
    • /
    • 제39권4호
    • /
    • pp.353-360
    • /
    • 2015
  • 해양 석유 생산은 '해양'이라는 특성에 기인하는 여러 가지 변수를 동반하면서 막대한 비용과 시간을 필요로 한다. 모든 관련된 프로세스는 인명, 환경 그리고 재산의 손실을 줄이기 위한 치밀한 일련의 계획에 의하여 통제된다. 이 논문은 해양 석유 생산 및 수송의 최적화 문제를 다룬다. 문제 영역의 범위를 정의하기 위해 해양 석유 생산 및 수송 네트워크를 제시하고 그 문제를 해결하기 위한 혼합정수계획모형을 구축하였다. 제안된 최적화 모형의 타당성을 확인하기 위해 가상의 해양 유전과 수요 시장을 바탕으로 MS Office Excel의 해찾기를 이용하여 계산실험들을 수행하였다. 해양 석유 생산 및 수송 네트워크 하위 흐름은 해양 유전에서 생산된 원유를 수요 시장으로 배분하는 해사수송문제가 된다. 이 해사수송문제를 해결하기 위해 집합 패킹 모형을 이용하여 구축된 MoDiSS(Model-based DSS in Ship Scheduling)를 사용하였다. 이러한 연구결과들은 실제적인 해양 석유 생산 및 수송 최적화 문제에 의미 있게 적용될 수 있으리라 사료된다.

청년창업 성공요인에 관한 연구: 창업전문가를 대상으로 (A Study on The Success Factors of Youth Enterprises)

  • 심현민;설병문
    • 벤처창업연구
    • /
    • 제17권2호
    • /
    • pp.1-13
    • /
    • 2022
  • 청년창업의 중요성과 청년창업 지원은 지속적으로 증가하고 있다. 하지만 청년창업은 일반창업 보다 실패할 가능성이 높으며 이에 대한 원인 또한 미시적·거시적으로 다양하다. 이러한 상황에서 청년창업자가 창업을 성공하기 위해 어떻게 대처해야하는지 대안이 제시되지 않는 실정이다. 따라서 본 연구는 청년창업자에게 창업교육, 창업보육, 창업 멘토링·코칭을 수행하는 창업전문가를 대상으로 델파이 기법을 적용하여 청년창업 성공요인을 도출하였다. 이를 통해 기존 사례 연구에서 파악하지 못하였던 창업현장에서의 청년창업 성공요인을 파악하여 청년창업자에게 청년창업 성공요인에 대한 궁금증을 해소할 수 있도록 도움을 주고자 한다. 또한 청년창업자가 창업을 진행하면서 고려해야 하는 여러 요인 중 우선적으로 확보하거나 수행해야하는 요인을 파악하고 제한된 자원을 효율적이고 효과적으로 사용하여 창업성공을 할 수 있도록 기여하는 것을 목적으로 한다. 본 연구에서 델파이 조사는 총 2차에 걸쳐 진행하였다. 델파이 1차 조사는 구조화된 폐쇄형 문항(Closed-ended)을 사용한 수정 델파이 기법(Modified Delphi Method)을 활용하였으며, 수정 델파이 기법의 문제를 보완하기 위해 청년창업자 및 창업전문가를 대상으로 사전조사(Pilot Test)를 실시하였다. 델파이 1차 조사에서 IBM SPSS Statistics 22와 Microsoft Office Excel 2016을 활용하여 평균(Mean), 표준편차(Standard Deviation), 중위수(Median), 사분범위(Inter Quartile Range), 내용타당도 비율(Content Validity Ratio)을 산출하였으며, 델파이 2차 조사에서는 1차 조사에서의 동일한 통계적 수치와 추가적으로 크론바흐 알파(cronbach's α)를 산출하였다. 델파이 조사결과, 창업자특성, 창업준비, 창업전략, 창업환경의 4개 상위요인과 22개의 하위요인을 청년창업 성공요인으로 도출하였다.

도시 내배수시스템 실시간 운영모형의 개발 (Development of a Real Time Control Model for Urban Drainage Systems)

  • 전환돈;이양재;이정호;김중훈
    • 한국물환경학회지
    • /
    • 제23권5호
    • /
    • pp.748-755
    • /
    • 2007
  • To develop an efficient pump operating rule for a retard basin, it is necessary to estimate inflow to the retard basin accurately which is affected by the backwater effect at the outlet of the conduit. The magnitude of the backwater effect is dependent on the water depth of a retard basin; however, the depth is determined by the amount of inflow and outflow. Thus, a real time simulation system that is able to simulate urban runoff and the pump operation with the consideration of the backwater effect is required to estimate the actual inflow to a retard basin. With this system, the efficient pump operating rule can be developed to diminish the possible flood damage on urban areas. In this study, a realtime simulation system is developed using the SWMM 5.0 DLL and Visual Basic 6.0 equipped with EXCEL to estimate inflow considering the backwater effect. The realtime simulation can be done by updating realtime input data such as minutely observed rainfall and the depth of a retard basin. Using those updated input data, the model estimates actual inflow, the amount of outflow discharged by pumps and gates, the depth of each junction, and flow rate at a sewer pipe on realtime basis. The developed model was applied to the Joonggok retard basin and demonstrated that it can be used to design a sewer system and to estimate actual inflow through the inlet sewer to reduce the inundation risk. As results, we find that the model can contribute to establish better operating practices for the pumps and the flood drainage system.

그린 패션제품에 대한 환경친화적 소비자의 특성 및 인지도분석 - 서울시 거주여성을 중심으로(1999년도와 2007년도의 연구비교) - (An Analysis of Environmentally Conscious Consumers' Features and Their Awareness of Green Fashion Products - Focusing on female residents of Seoul(Comparison between 1999 and 2007) -)

  • 이종숙;양리나;최나영
    • 한국의류산업학회지
    • /
    • 제9권4호
    • /
    • pp.401-408
    • /
    • 2007
  • The study aims to examine consumer awareness of green fashion products and demographic characteristics by subdividing environmentally conscious consumers of such products in the current domestic fashion market. It then compares the result with the characteristics of environmentally conscious consumers studied by 1999 in order to understand the trend of the consumer group in the fashion market and to promote the use of green fashion products. Marketing strategies for green fashion products suggested by the study are as follows: First, fashion firms are required to develop and publicize shops selling recycled or second-hand clothing that environmentally conscious consumers show constant interest. For instance, clothing patterns may be developed to enable consumers to make their kids' clothing easily at home, and various garments made from recycled materials may stimulate environmentally conscious consumers' desire to buy. Particularly, advanced technologies should be developed and publicized to manufacture garments that can excel existing ones made of normal materials in their features in order to satisfy consumers' interest in clothing made from recycled PET bottles. In addition, various natural dyes should be developed to decrease water pollution. Second, it seems imperative to develop clothing made of recycled knitted apparel that attracts consumers' interest more than ever, fashionable multi-purpose clothing, and environmentally friendly materials. As the use of natural fur or leather can cause the endangerment of wild animals and the destruction of the ecosystem, synthetic fur or leather may be used to develop sophisticated products with the same texture as real ones to attract environmentally conscious consumers' interest.

도로 비점오염 해석을 위한 ROADMOD개발 및 적용: 도로청소 효과 분석 (Development and Application of ROADMOD for Analysis of Non-point Source Pollutions from Road: Analysis of Removal Efficiency of Sediment in Road by Sweeping)

  • 강희만;전지홍
    • 한국물환경학회지
    • /
    • 제37권2호
    • /
    • pp.103-113
    • /
    • 2021
  • In this study, an Excel-based model (ROADMOD) was developed to estimate pollutant loading from the road and evaluate BMPs. ROADMOD employs the Chezy-Manning equation and empirical expression for estimating surface runoff, and power function for pollutant buildup, and exponential function for pollutant washoff in SWMM. The results of model calibration for buildup and washoff using observed data revealed a good match between the simulation results and the observed data. The long-term surface runoff and sediment simulated by ROADMOD demonstrated a good match with those by SWMM with 2 ~ 14% of relative error. The shorter sweeping interval (within 8 days) remarkably decreased sediment loads from the road. It was found that the effect of reducing sediment loads from the road was greatly affected not only by the sweeping interval but also by sweeping on the day before a rainfall event. The 48% of removal efficiency of sediment loads from the road was achieved with 26 times of road sweeping per year when sweeping was performed on the day before the rainfall event. A 4-day sweeping interval showed similar removal efficiency (48%) with 96 times of sweeping per year. It is considered that the road sweeping on the day before a rainfall event could maximize the effect of reducing the non-point source pollution from the road with minimization of the number of road sweeping. So, the road sweeping on the day before a rainfall event can be considered as one of the useful and best management practices (BMPs) on road.

공공임대주택에 거주중인 노령인구 인지특성에 관한 연구 (A Study on the Older Residents' Cognitive Characteristics of Public Rental Housing Complex)

  • 오예인;정다운;권순정
    • 의료ㆍ복지 건축 : 한국의료복지건축학회 논문집
    • /
    • 제24권4호
    • /
    • pp.17-25
    • /
    • 2018
  • Purpose: Korean society is undergoing the rapid increase and poverty of elderly population. Therefore, the appropriate supply and planning of public rental housing for the low-income elderly is more important. The purpose of this study is to present the basic data for the study and planning of the elderly housing complex by analyzing the cognitive characteristics of the elderly residing in the rental housing. Methods: A questionnaire survey was conducted to identify health characteristics of the elderly living in the 'Gongreung SH Apartment'. 100 random samples were collected and 82 valid samples were analysed. Statistical analysis was performed using Excel and R for the age, sex, health, outdoor walking frequency and characteristics of Cognitive map of the elderly. Results: The characteristics of cognitive map were classified into point shapes and linear shapes. The linear group was lower in average age than the point group and tended to draw the map wider. The wider the map was, the more the number of elements in cognitive map was. The number of elements on the cognitive map decreased as respondents' age increased. On the other hand it was not related to residence period and gender of the elderly. Implication: The cognitive extent of the residential environment tends to decrease with age. Men's cognitive range is wider than women's. There is no corelation between the number of cognitive elements and cognitive map type. Men tend to have a systematic image of city, whereas women focus on relational and social urban factors. For sustainable apartment complex design, various characteristics of the group including men and women, different age and different health status should be considered.

A Study on the Verification Method of Ships' Fuel Oil Consumption by using AIS

  • Yang, Jinyoung
    • 해양환경안전학회지
    • /
    • 제25권3호
    • /
    • pp.269-277
    • /
    • 2019
  • Since 2020, according to the International Convention for the Prevention of Pollution from Ships (MARPOL) amended in 2016, each Administration shall transfer the annual fuel consumption of its registered ships of 5,000 gross tonnage and above to the International Maritime Organization (IMO) after verifying them. The Administration needs stacks of materials, which must not be manipulated by ship companies, including the Engine log book and also bears an administrative burden to verify them by May every year. This study considers using the Automatic Identification System (AIS), mandatory navigational equipment, as an objective and efficient tool among several verification methods. Calculating fuel consumption using a ship's speed in AIS information based on the theory of a relationship between ship speed and fuel consumption was reported in several examples of relevant literature. After pre-filtering by excluding AIS records which had speed errors from the raw data of five domestic cargo vessels, fuel consumptions calculated using Excel software were compared to actual bunker consumptions presented by ship companies. The former consumptions ranged from 96 to 123 percent of the actual bunker consumptions. The difference between two consumptions could be narrowed to within 20 percent if the fuel consumptions for boilers were deducted from the actual bunker consumption. Although further study should be carried out for more accurate calculation methods depending on the burning efficiency of the engine, the propulsion efficiency of the ship, displacement and sea conditions, this method of calculating annual fuel consumption according to the difference between two consumptions is considered to be one of the most useful tools to verify bunker consumption.

Contents Analysis on the Media about the Working Conditions of Nurses

  • Chin, Young-Ran;Kwon, Mi-Hyoung
    • 한국컴퓨터정보학회논문지
    • /
    • 제26권2호
    • /
    • pp.109-117
    • /
    • 2021
  • 본 연구의 목적은 미디어의 언론매체에 보도된 한국 간호사의 근무환경과 관련된 연관 주요 키워드를 확인함으로써 간호사의 근무환경을 파악하고 문제점 개선을 위한 시사점을 제시하기 위함이다. '간호 NOT(간호사) or 간호사'를 BIG KINDS에서 검색하여 간호사의 부당한 처우와 관련된 기사를 선별, 최종 309건을 추출한 후 내용 분석을 통하여 기사가 보도된 시기, 기사에 나타난 병원급, 지역, 키워드, 통합키워드의 6개 항목으로 분류하였다. 관련 기사가 가장 많이 발표된 시기, 기관, 지역은 각각 2015년 11월~2016년 10월 31일 79건(22.56%), 3차 의료기관 92건(29.77%), 전국 121건(39.1%)으로 나타났다. 통합 키워드는 총 14개로 정리되었으며, 성폭행/성희롱(14.88%), 간호사 인력부족(11.65%), 간호사 태움(11.0%), 부당해고(10.67%), 신체적 폭행(10.35%) 등의 순이었다. 연구결과는 간호사의 긍정적인 근무환경을 구축하기 위한 기초자료로 활용될 수 있을 것이다.

Analysis of Plant Species in Elementary School Textbooks in South Korea

  • Kwon, Min Hyeong
    • 인간식물환경학회지
    • /
    • 제24권5호
    • /
    • pp.485-498
    • /
    • 2021
  • Background and objective: This study was conducted to find out the status of plant utilization in the current textbooks by analyzing the plants by grade and subject in the national textbooks for all elementary school grades in the 2015 revised curriculum in Korea. Methods: The data collected was analyzed using Microsoft Office Excel to obtain the frequency and ratio of collected plant data and SPSS for Windows 26.0 to determine learning content areas by grade and the R program was used to visualize the learning content areas. Results: A total of 232 species of plants were presented 1,047 times in the national textbooks. Based on an analysis of the plants presented by grade, the species that continued to increase in the lower grades tended to decrease in the fifth and sixth grades, the upper grades of elementary school. As for the number and frequency of plant species by subject, Korean Language had the highest number and frequency of plant species. The types of presentation of plants in textbooks were mainly text, followed by illustrations and photos of plants, which were largely used in first grade textbooks. In addition, as for the area of learning contents in which plants are used, in the lower grades, plants were used in the linguistic domain, and in the upper grades, in the botanical and environmental domains of the natural sciences. Herbaceous plants were presented more than woody plants, and according to an analysis of the plants based on the classification of crops, horticultural crops were presented the most, followed by food crops. Out of horticultural crops, flowering plants were found the most diversity with 63 species, but the plants that appeared most frequently were fruit trees that are commonly encountered in real life. Conclusion: As a result of this study, various plant species were included in elementary school textbooks, but most of them were horticultural crops encountered in real life depending on their use. Nevertheless, plant species with high frequency have continued a similar trend of frequency from the previous curriculums. Therefore, in the next curriculum, plant learning materials should be reflected according to social changes and students' preference for plants.

PHPP를 활용한 조적, 콘크리트, 목조 레이어 구성별 표준주택 냉·난방 에너지 요구량 평가 (Heating and Cooling Energy Demand Evaluating of Standard Houses According to Layer Component of Masonry, Concrete and Wood Frame Using PHPP)

  • 강유진;이준희;이화영;김수민
    • Journal of the Korean Wood Science and Technology
    • /
    • 제45권1호
    • /
    • pp.1-11
    • /
    • 2017
  • 건축물에서 냉방과 난방에 많은 양의 에너지가 소요되고 있다. 건축은 $CO_2$ 발생을 줄이고 에너지 소비 저감을 위하여 냉 난방 부하를 최소화할 필요성이 있다. 그리고 최근 주거문화는 친환경적이고 실내 쾌적성을 중시하는 방향으로 변화하면서 단독주택의 수요가 증가하고 있다. 국내 단독주택의 구조는 크게 조적조, 콘크리트조, 목조 주택으로 구분할 수 있다. 따라서 본 논문은 세 가지 구조방식(조적, 콘크리트, 목조)으로 구성된 동일 면적 단독주택의 냉 난방 부하와 에너지 요구량을 분석하였다. 구조방식별 벽체, 지붕, 바닥 레이어를 구성하였고, 각 레이어의 열관류율(U-value)은 목조 벽체와 같이 스터드를 고려해주기 위하여 PHPP 계산법을 이용하였다. 또한 스터드 유무에 따른 차이를 비교 분석하기 위하여 목조 벽체에서 스터드를 고려하지 않은 경우(비 스터드)를 분석하였다. 분석은 엑셀을 기반으로 자체 개발한 냉 난방 부하 산출 프로그램(CHLC)과 ECO2를 이용하였다. 냉 난방 부하와 에너지 요구량 결과, 목조 구조가 가장 높은 결과를 보였고 콘크리트 구조는 두 번째로 높은 값을 유지하는 것을 확인하였다. 두 구조방식은 에너지소비 측면에서 불리하다고 판단하였다. 결론적으로, 동일한 조건에서의 조적 구조는 다른 구조방식에 비하여 냉 난방 부하 및 에너지 요구량에 있어 유리하며, 목조 구조에서 스터드로 인한 열교를 제외한다면 에너지소비를 줄일 수 있다고 판단되었다.