• 제목/요약/키워드: EXCEL

검색결과 829건 처리시간 0.028초

공간예측모형에 기반한 산사태 취약성 지도 작성과 품질 평가 (Mapping Landslide Susceptibility Based on Spatial Prediction Modeling Approach and Quality Assessment)

  • 알-마문;박현수;장동호
    • 한국지형학회지
    • /
    • 제26권3호
    • /
    • pp.53-67
    • /
    • 2019
  • The purpose of this study is to identify the quality of landslide susceptibility in a landslide-prone area (Jinbu-myeon, Gangwon-do, South Korea) by spatial prediction modeling approach and compare the results obtained. For this goal, a landslide inventory map was prepared mainly based on past historical information and aerial photographs analysis (Daum Map, 2008), as well as some field observation. Altogether, 550 landslides were counted at the whole study area. Among them, 182 landslides are debris flow and each group of landslides was constructed in the inventory map separately. Then, the landslide inventory was randomly selected through Excel; 50% landslide was used for model analysis and the remaining 50% was used for validation purpose. Total 12 contributing factors, such as slope, aspect, curvature, topographic wetness index (TWI), elevation, forest type, forest timber diameter, forest crown density, geology, landuse, soil depth, and soil drainage were used in the analysis. Moreover, to find out the co-relation between landslide causative factors and incidents landslide, pixels were divided into several classes and frequency ratio for individual class was extracted. Eventually, six landslide susceptibility maps were constructed using the Bayesian Predictive Discriminant (BPD), Empirical Likelihood Ratio (ELR), and Linear Regression Method (LRM) models based on different category dada. Finally, in the cross validation process, landslide susceptibility map was plotted with a receiver operating characteristic (ROC) curve and calculated the area under the curve (AUC) and tried to extract success rate curve. The result showed that Bayesian, likelihood and linear models were of 85.52%, 85.23%, and 83.49% accuracy respectively for total data. Subsequently, in the category of debris flow landslide, results are little better compare with total data and its contained 86.33%, 85.53% and 84.17% accuracy. It means all three models were reasonable methods for landslide susceptibility analysis. The models have proved to produce reliable predictions for regional spatial planning or land-use planning.

ProphetNet 모델을 활용한 시계열 데이터의 열화 패턴 기반 Health Index 연구 (A Study on the Health Index Based on Degradation Patterns in Time Series Data Using ProphetNet Model)

  • 원선주;김용수
    • 산업경영시스템학회지
    • /
    • 제46권3호
    • /
    • pp.123-138
    • /
    • 2023
  • The Fourth Industrial Revolution and sensor technology have led to increased utilization of sensor data. In our modern society, data complexity is rising, and the extraction of valuable information has become crucial with the rapid changes in information technology (IT). Recurrent neural networks (RNN) and long short-term memory (LSTM) models have shown remarkable performance in natural language processing (NLP) and time series prediction. Consequently, there is a strong expectation that models excelling in NLP will also excel in time series prediction. However, current research on Transformer models for time series prediction remains limited. Traditional RNN and LSTM models have demonstrated superior performance compared to Transformers in big data analysis. Nevertheless, with continuous advancements in Transformer models, such as GPT-2 (Generative Pre-trained Transformer 2) and ProphetNet, they have gained attention in the field of time series prediction. This study aims to evaluate the classification performance and interval prediction of remaining useful life (RUL) using an advanced Transformer model. The performance of each model will be utilized to establish a health index (HI) for cutting blades, enabling real-time monitoring of machine health. The results are expected to provide valuable insights for machine monitoring, evaluation, and management, confirming the effectiveness of advanced Transformer models in time series analysis when applied in industrial settings.

어린이급식관리지원센터에서 제공하는 어린이집 식단의 식품군 및 음식군 다양성에 관한 기술연구 (Food and dish group diversity on menus of daycare centers provided by Center for Children's Foodservice Management in Korea: a descriptive study)

  • 강연록;임경숙;김형숙
    • 대한지역사회영양학회지
    • /
    • 제28권6호
    • /
    • pp.449-465
    • /
    • 2023
  • Objectives: This study aimed to analyze menu patterns and food group diversity in daycare centers managed by the Center for Children's Foodservice Management in South Korea. Methods: Data from 18 Center for Children's Foodservice Management centers across various provinces (excluding Jeju Island) were analyzed. We examined 8,796 meals served in February, May, August, and December 2021, focusing on seasonal lunch and snack menus for children aged 3-5. Foods were categorized into 19 groups for lunch and 21 for snacks. The frequency of food groups and dietary patterns were assessed using the Dietary Diversity Score. Analyses were conducted using Excel 2016 and IBM SPSS Statistics version 28. Results: Most lunch menus (89%) included five menu items, with a ratio of grain, meat, and vegetables at 88%. Snack menus typically had one item (57%), with significantly more items in the afternoon compared to the morning (P < 0.001). Regarding snack patterns, 75.2% of morning snacks and 61.1% of afternoon snacks contained only one solid food and drink (P < 0.001). Fruit and milk (22.4%) was the most prevalent pattern in morning snacks, while grain and milk (31%) dominated afternoon snacks (P < 0.001). Only 48% of daycare center menus (all snacks and lunch) included all five food groups (grain, meat, vegetables, fruit, and milk). Notably, only 83% included milk and 57% included fruit. Conclusions: These findings highlight the need to improve food variety and diversity in the Center for Children's Foodservice Management-managed daycare center menus. Developing more detailed guidelines for menu structure and food composition is crucial to ensure children receive balanced and diverse nutrition.

Fabrication of Activated Carbon Fibers from Polyacrylonitrile-Derived Carbon Fibers: Investigating CO2 Adsorption Capability in Relation to Surface Area

  • Seung Geon Kim;Sujin Lee;Inchan Yang;Doo-Won Kim;Dalsu Choi
    • Composites Research
    • /
    • 제36권6호
    • /
    • pp.402-407
    • /
    • 2023
  • Activated carbon fibers (ACFs) are fibrous form of activated carbon (AC) with higher mechanical strength and flexibility, which make them suitable for building modules for applications including directional gas flow such as air and gas purification. Similarly, ACFs are anticipated to excel in the efficient capture of CO2. However, due to the difficulties in fabricating monofilament carbon fibers at a laboratory scale, most of the studies regarding ACFs for CO2 capture have relied on electrospun carbon fibers. In this study, we fabricated monofilament carbon fibers from PAN-based monofilament precursors by stabilization and carbonization. Then, ACFs were successfully prepared by chemical activation using KOH. Different weight ratios ranging from 1:1 to 1:4 were employed in the fabrication of ACFs, and the samples were designated as ACF-1 to ACF-4, respectively. As a function of KOH ratio, increase in surface area could be observed. However, the CO2 adsorption trend did not follow the surface area trend, and the ACF-3 with second largest surface area exhibited the highest CO2 adsorption capacity. To understand the phenomena, nitrogen content and ultramicropore distribution, which are important factors determining CO2 adsorption capacity, were considered. As a result, while nitrogen content could not explain the phenomena, ultramicropore distribution could provide a reasoning that the excessive etching led ACF-4 to develop micropore structure with a broader distribution, resulting in high surface area yet deteriorated CO2 adsorption.

의약품 부작용 정보 전달의 중요성: 설문조사 기반 고찰 (Enhancing Communication on Medication Side Effects: Insights from a Survey Study)

  • 최지혜;한혜성;심미경;손현순
    • 한국임상약학회지
    • /
    • 제34권2호
    • /
    • pp.126-133
    • /
    • 2024
  • Background: Medication's benefits and harms require careful management. Laws mandate pharmacists to provide essential medication details since inadequate counseling may pose risks. This study explores public expectations for pharmacist-provided side effect information to enhance safety. Methods: A self-developed questionnaire was created for participant to self-report, refined through pilot surveys with experts and laypersons. Nineteen items were categorized into four sections, using closed-ended questions. Adults over 20, having obtained prescription medications within the past year, were surveyed via convenience sampling. Data analysis employed descriptive statistics and T-tests using IBM SPSS Statistics 21 and Microsoft Excel. Results: The study involved 189 participants, with a slightly higher proportion of females (59.3%) than males (40.7%), predominantly in their 20s (45.0%) and college graduates (57.1%). Health professionals represented 76.2% of respondents. Over half visited pharmacies at least 5 times yearly for prescriptions. Indirect experience with side effects was more common (30.2%) than direct experience (17.5%). Most (82.0%) showed interest in media-reported side effect events. Satisfaction with pharmacist-provided side effect explanations was low (59.7%), but importance was high (98.9%). Preferences favored combined verbal and written explanations (65.1%), with a majority desiring explanations for common but less serious side effects (82.5%). Healthcare professionals found explanations significantly more sufficient than non-professionals did. Older individuals, those living with elderly, and frequent pharmacy visitors attributed greater importance to pharmacist-provided explanations. Conclusion: Koreans view pharmacist-provided medication side effect explanations as vital but find current services lacking. Enhancements in content and delivery methods are needed in pharmacy counseling to meet public expectations.

Development of Workplace Risk Assessment System Based on AI Video Analysis

  • Jeong-In Park
    • 한국컴퓨터정보학회논문지
    • /
    • 제29권1호
    • /
    • pp.151-161
    • /
    • 2024
  • 이 논문에서는 제조공장 사업장 현장 내 각 공정을 촬영한 영상을 인공지능(AI)으로 분석하여 위험·유해 요인을 파악할 수 있도록 작업장 위험지도(Danger Map)를 개발하고 이 Danger Map 에서 도출된 빈도·강도에 기반한 위험도와 안전도를 실제 현장상황에 맞추어 자동으로 도출하여 유사 제조 업종에 적용할 수 있는 시스템을 제시히였다. 특히, 사업장의 안전도(위험도)를 엑셀 등 수동으로 평가하던 종래의 평가방식에서 영상으로부터 취득된 유해·위험 요인별 위험성 수준을 자동으로 산정 평가하여 시스템에 의한 안전 확보와 안전도(위험도)를 계산함으로써 이에 따라 기업에서 적절한 활동 및 조치를 마련할 수 있도록 하였다. 안전도(위험도) 산출 및 평가 자동화를 위해 '하인리히의 법칙(Heinrich's law)'을 모델로 하였으며, 위험한 행동 패턴에 대해 5X4점 평가척도를 계산하였다. 이 시스템을 실증적용하기 위해 금속주물주조공장에 적용하였으며 매월 안전도(위험도) 계산에 추가되는 시간적 비용 및 노동력을 2명 절감할 수 있었다.

여성 난임 한의표준임상진료지침 개작을 위한 일반인 대상 의료 이용 경험 조사 (A Survey on the Public's Experience of Medical Use for Developing Korean Medicine Clinical Practice Guideline of Female Infertility)

  • 이성주;성수현;김동일;윤영진;박장경
    • 대한한방부인과학회지
    • /
    • 제37권2호
    • /
    • pp.109-119
    • /
    • 2024
  • Objectives: This study is aimed to survey public's experience of medical use for developing Korean medicine clinical practice guideline of female infertility. Methods: The study engaged women who had experienced infertility despite regular conjugal relations, selected from an online survey company's national panel. Participants were surveyed from November 3 to 8, 2021. The questionnaire, developed from prior studies on Korean medicine, was emailed to 29,465 adults; 550 responses were analyzed after exclusions. The study received an IRB exemption from Pusan National University Korean Medicine Hospital and utilized Microsoft Excel for statistical analysis. Results: Among 550 respondents, 32.2% had experienced infertility, predominantly due to unexplained causes (52%). About half had received medical treatment (49.3%), primarily at hospitals and general hospitals (54.2%) and obstetrics and gynecology clinics (49.4%), with Korean medicine facilities also utilized (24.7% for clinics, 14.4% for hospitals). The most common treatments included herbal medicine in Korean medicine and ovulation induction in Western medicine, with most treatments lasting less than six months (71.4%) and costing between 1 to 5 million won (50.5%). Efforts to conceive included lifestyle adjustments such as maintaining a warm lower abdomen, supplement intake, and avoiding alcohol and tobacco. Conclusions: It is necessary that the guidelines be revised to address female infertility and to integrate recommendations for combining Korean medical treatments and Western medical treatments, which will enhance patient care in managing female infertility.

Evaluation of the effectiveness of tell-show-do and ask-tell-ask in the management of dental fear and anxiety: a double-blinded randomized control trial

  • Niharika Reddy Elicherla;Kanamarlapudi Venkata Saikiran;Karthik Anchala;Sainath Reddy Elicherla;Sivakumar Nuvvula
    • Journal of Dental Anesthesia and Pain Medicine
    • /
    • 제24권1호
    • /
    • pp.57-65
    • /
    • 2024
  • Background: The objective of behavioral guidance is to establish effective communication that aligns with a child's requirements to manage disruptive behavior. This study aimed to evaluate the effectiveness of the Tell-Show-Do and Ask-Tell-Ask techniques in managing dental anxiety in children during their initial appointment. Methods: The study included 50 children (28 boys and 22 girls) without any prior experience between the ages of 7 and 11 at their first dental visit. The children were randomly categorized into two groups: Group 1, Tell Shows Do, and Group 2, Ask-Tell-Ask. Subsequently, all children underwent noninvasive treatment procedures such as restorations, sealants, and oral prophylaxis. Furthermore, behavioral management techniques were employed based on the allocated group. Finally, anxiety levels for all children were assessed using the Raghavendra, Madhuri, and Sujata Pictorial Scale (RMS-PS) and heart rate at three different intervals (before, during, and after). The obtained data were entered into Microsoft Excel, and statistical analysis was performed using SPSS software. A paired t-test and Mann-Whitney U-test were used to compare the mean and median values of the two groups and determine their effectiveness. Results: Children in the TSD group exhibited statistically significant heart rates and RMS-PS scores in intra-group comparisons. However, children in the ask-tell-ask group showed a significant reduction only in the RMS-PS scores (P < 0.001) but not in the measures used to assess heart rate (P < 0.001). Conclusion: Tell-Show-Do was more effective than ask-tell-ask in alleviating dental anxiety in children. The simultaneous application of these two strategies can synergistically alleviate dental anxiety during a child's initial dentist appointment.

대한가정학회지 연구 동향 및 공저자 네트워크 분석: 2010~2022년 게재 논문을 중심으로 (Research Trends and Co-author Network Analysis of the Journal of the Korean Home Economics Association: Articles Published from 2010 to 2022)

  • 박미정;채정현;한주
    • Human Ecology Research
    • /
    • 제62권1호
    • /
    • pp.15-32
    • /
    • 2024
  • The purpose of this study was to analyze the research trends and co-author networks of academic articles published in the Journal of the Korean Home Economics Association from 2010 to 2022. The network analysis was conducted using Excel and NetMiner 4.4, and the results were as follows. First, the number of published articles has been maintained at around 40 per year since 2019. By field, most articles were published in the field of child studies and family studies, followed by consumer studies, home management, clothing studies, home economics education, food and nutrition, and housing. The research methods were primarily quantitative (71.61%). Second, the most common keywords in the titles of the published articles were "influence" and "relationship", with "influence", "consumer", "mediating effect", "parent", and "control" identified as influential keywords. Third, the published articles were categorized into nine topics based on subject matter, while the number of topic types varied by year. Fourth, the total number of authors of the 627 articles was 712, with 1.92 authors per article, as well as the number of authors who published two or fewer articles accounted for 85.5% of the total. By institution, Yonsei University had the highest number of authors and the highest number of published articles, while Korea National Open University played a leading role in the network of co-authors by institution. This study is significant in providing basic data for the future development of the Korean Home Economics Association and the field of home economics.

뇌졸중 환자의 체간안정화 훈련이 자세조절과 일상생활동작에 미치는 영향: 단일사례연구 (The Effects of Trunk Stabilization Training on a Stroke Patient's Postural Control and Activities of Daily Living: A Sing Subject Design)

  • 남주현;심경보;곽성원
    • 대한지역사회작업치료학회지
    • /
    • 제4권1호
    • /
    • pp.75-84
    • /
    • 2014
  • 목적 : 이 연구에서는 단일 뇌졸중환자를 대상으로 체간안정화 훈련 프로그램 적용하여 자세조절과 일상생활 동작에 미치는 영향을 알아보고 분석함으로써 뇌졸중환자의 효과적인 임상적 중재 방안을 제시하고자 한다. 연구방법 : 경북 경주시에 소재한 C병원에 입원중인 75세 여성 뇌졸중 환자 1명을 대상으로 하였다. 연구 설계는 단일사례연구(single subject design)로써 ABA반전설계를 사용하였고, 연구기간은 2014년 4월 21일부터 5월 23일까지 총 5주 동안 진행되었다. 실험 과정은 기초선(A) 3회, 중재 기간(B) 9회 유지(A') 3회로 총 15회 진행하였고 중재기간 동안 체간안정화 프로그램을 적용하였다. 연구 참여자의 자세조절과 일상생활동작의 평가를 위해 Postural Assessment Scale for Stroke(PASS)와 Modified Barthel Index(MBI)를 사용하였다. 수집된 자료는 마이크로 소프트 오피스 Excel 2013 을 사용하여 그래프로 나타내는 시각적 분석(visual analysis)을 사용하였다. 결과 : 자세조절 검사에서 평균 점수는 기초선 구간 11.7점, 중재 구간 14.8점, 유지 구간 15.3점으로 향상되었고, 일상생활동작 평가에서 기초선 기간 66점으로 보통의 의존을 보였지만 중재 후와 유지 구간에서는 80점으로 향상되어 가벼운 의존을 나타냈다. 결론 : 체간안정화 훈련 프로그램이 뇌졸중 환자의 신체의 자세조절이나 정렬에 효과를 나타내고 나아가 일상생활활동의 수행에도 유익한 향상을 보이는 것으로 확인되었다.

  • PDF