• Title/Summary/Keyword: excel

Search Result 832, Processing Time 0.023 seconds

Veterans Hospital Medical Expenses Increase & Decrease Characteristics and Convergence Phenomenon-Focusing on the implications of the medical support system for national veterans-

  • Yu, Tae Gyu
    • International Journal of Advanced Culture Technology
    • /
    • v.9 no.1
    • /
    • pp.16-21
    • /
    • 2021
  • As the average age of national veterans has increased from 69 years old(2011) to 71 years old(since 2015) over the past five years, the overall medical service cost of veterans has increased by about 20%. The main cause of this phenomenon is 'ultra-aging', which accounts for 67% of veterans, while the proportion of health insurance patients aged 70 or older is 9%. Therefore, it is judged that the analysis of the trend of use of medical services at veterans hospitals in each region that is in charge of severe medical services of national veterans can serve as an opportunity to seek countermeasures for the severe medical system of national veterans. First of all, based on the details of major medical expenses (hospitalization, outpatient, pharmaceutical expenses) by region for the last 10 years(2010-2019), data significance was performed through a chi-square test, and the Central Veterans Hospital and Non-Central Veterans Hospital using EXCEL. 'Expected frequency' was calculated by year. By applying the CHITEST(observation frequency, expected frequency) function again, the p-value(p<0.05) was calculated, and the profit bias of each region's veterans hospital could be determined. The specific research method is for the last 10 years(2010-2019) for state-sponsored patients_outpatient treatment income, state-sponsored patients_hospitalization income, exempt patients_outpatients at the Central Veterans Hospital, Busan Veterans Hospital, Gwangju Veterans Hospital, Daegu Veterans Hospital, and Daejeon Veterans Hospital. A one-way analysis of variance was conducted to verify the significance of the difference between group averages on the status of 5 medical revenues of veterans hospitals in each of the 5 regions, including medical treatment income, reduced patients_hospitalization income, and reduced patients_medicine expenses. It was found to be significant(p<0.05) at all levels, including region and type. Finally, the bias in the profit structure of regional veterans hospitals was the highest in 2017(p=0.0004) and the lowest in 2013(p=0.0349). In addition, in the profit structure of the Veterans Hospital, the year in which the'regional' variable worked the most was 2019, and the year with the least affected was 2010. The order of the former is Jungang(=31,674,713), Busan(=12,314,614), Gwangju(=11,957,038), Daegu(=10,168,015), and Daejeon(=6,991,034), and the order of the latter is Jungang(=57,868,791), and Busan(=19,183,194). Gwangju(=17,904,712), Daegu(=15,656,034), and Daejeon(=14,377,395). In conclusion, the profit bias of veterans hospitals repeatedly raced the lowest(p=0.01986) and highest(p=0.03499) for the past five years(2010-2014) year by year, with the 'regional' variable being the most in the veterans hospital's profit structure It was identified as a major influence factor. On the other hand, for the last 5 years (2015-2019), the influence factors of the'regional' variable every year were in 2015(p=0.02015), 2016(p=0.01741), 2017(p=0.00045), and 2018(p=0.00394). in 2019(p=0.00227), a significant difference was confirmed at a very low level.

Calculation of Expected Life of Hydrogen Pressure Vessels by Fracture and Fatigue Mechanics assuming Semi-elliptical Cracks and Analysis of the Effect of Thickness and Radius (반타원형 균열을 가정한 파괴 및 피로역학에 의한 수소 압력용기의 예상 수명 계산과 두께와 내경이 미치는 영향 분석)

  • Kim, Jeong Hwan;Lee, Hwa Young;Lee, Min-Kyung;Lee, Jae-Hun;Lyu, Geunjun
    • Journal of the Korean Institute of Gas
    • /
    • v.25 no.6
    • /
    • pp.53-65
    • /
    • 2021
  • While the hydrogen refueling station is rapidly expanded and installed, the safety inspection of the hydrogen pressure vessel in the station should be very important. Of these, according to ASME, hydrogen embrittlement tests must be performed for hydrogen vessel that store hydrogen above a certain pressure. The main test method for hydrogen embrittlement inspection is to carry out fracture tests and fatigue fracture tests in a high pressure hydrogen atmosphere, which allows the durability limit of the pressure vessel to be measured and the endurable limit to be determined in the hydrogen atmosphere. In detail, the critical crack depth can be calculated by the stress intensity factor(K), and the service life can be determined by da/dN (fatigue growth rate). API579-1/ ASME FFS-1 part 9 exemplifies the calculation method according to the mode of crack-like flaws, but for various shapes such as plates and cylinders, there are about 55 modes according to the shape and location of the crack. Due to the fairly complex formula, it is not easily accessible. In this study, we will show you how to calculate fracture mechanics numerically via Excel and VBA. In addition, this was applied to analyze the effects of the thickness and inner diameter of the pressure vessel on the service life.

Translation and Cross-Cultural Adaptation Study on a Korean of Sensory Processing Measure Home Form (가정용 Sensory Processing Measure(SPM)의 국내적용을 위한 번역연구)

  • Lee, Hye-Rim;Yoo, Eun-Jung;Kim, Kyeong-Mi
    • The Journal of Korean Academy of Sensory Integration
    • /
    • v.19 no.3
    • /
    • pp.22-31
    • /
    • 2021
  • Purpose : This study aimed to conduct a translation, backtranslation, and content validity test of the Sensory Processing Measure (SPM) for Korean children. Methods : The translation and content validation process involved direct and backward translation; a test of equivalence between the two versions (the original SPM and the Korean version SPM; K-SPM) was performed using content-related evidence collected by a group of experts and a group of parents. Data analysis was carried out using Excel Content validity indices (CVI), mean, and standard deviation were used for the analysis of content validity. Results : The result of the comparison between the original SPM and K-SPM in the group of experts was 3.54 ± .74, the S-CVI/Avg for semanticity was .92, and the S-CVI/Avg for structure was .86. The results for the mean of the understanding test and the S-CVI/Avg were 3.48 ± .63 and .94, respectively. Conclusion : K-SPM will considerately be used as an assessment to identify sensory processing, praxis, and social participation issues for children in Korea. Further studies are suggested to increase the age range and the sample size for a more comprehensive applicability of the K-SPM to Korean children.

Composition of Visit-customized Movement Program Utilizing Care Workers for the Home-cared Elderly with Dementia (방문요양보호사를 활용한 재가 치매노인대상 방문 맞춤형 움직임 프로그램 구성요소)

  • Hong, Misung
    • 한국체육학회지인문사회과학편
    • /
    • v.58 no.5
    • /
    • pp.201-217
    • /
    • 2019
  • The purpose of this study was to consider composition of the movement program for the elderly with dementia to develop visit-customized movement program. For the study, 20 experts were selected including 8 dance therapists, 2 dementia-specialized doctors, 5 physical education leaders of the elderly, and 5 geriatric care helpers. First Delphi data, which listed items, was used to analyze content. Second and third Delphi questionnaires, which evaluated importance in Likert scale, was used to calculate content validity rate, average, standard deviation, quartile, convergence degree, and concurrence degree of each composition. 46 core composition of movement program for the elderly, which were selected and highlighted by the experts, were departmentalized into 6 considered compositions of movement program. 7 required composition of movement program, 1 Appropriate frequency of 3 times in a week and 1 30 minutes for each exercise, 1 operation method, 5 appropriate exercise of rhythm expression, 4 appropriate aerobic exercise, 4 appropriate muscle exercises, 5 appropriate stretches, 3 appropriate partner exercises 4 Appropriate massages, 5 appropriate tools

Survey of Point-of-Care Testing Devices for Pre-hospital EMS Equipment of Glucometer on Local Area (지역 EMS의 현장검사 혈당측정기 사용에 대한 실태조사)

  • Byeong-Hyun, Kim;Dai-Hai, Choi;Gyoung-Yim, Ha
    • Journal of agricultural medicine and community health
    • /
    • v.47 no.4
    • /
    • pp.220-228
    • /
    • 2022
  • Objective: glucometer is one of POCT(point-of-care testing) devices used by EMS. Accurate measurement value is important for patient decision making. Quality control is necessary for this, but most EMS are still using glucometer without quality control it. Therefore, management status and quality control status of glucometers used by 119 paramedics waswere investigated. Methods: 6 and 8 of glucometers and blood glucose test strips were submitted from 4 safety centers in 2010 and 8 safety centers in 2012, respectively. Glucometers submitted by local safety centers were analyzed in 2010 and 2012. The control glucometer, which was well managed at A University Hospital, was assumed to be accurate for at blood glucose measurement. Glucose values of various quality control materials control solutions were measured and analyzed using linear regression and Pearson's correlation test. Error rates were obtained via error tolerance range required by the 2011 ISO(International Organization for Standardization) guideline. For statistics, Excel and MedCalC programs were used. Results: mong 14 safety centers in the region, 4 centers(28.5%) in 2010 and 8 centers(57.1%) in 2012 submitted 6 and 8 glucometers. In the first evaluation in 2010, 2 out of 6(33.3%) glucometers were untestable due to error, and 45 out of 6(66.683.3%) blood glucose test strips' validity were expired. In the second evaluation in 2012, 1 out of 8(13.5%) glucometers were untestable due to lack of battery, and 2 out of 8(25%) blood glucose test strips' validity were expired. All correlation coefficients were above 0.989 in 2010 and above 0.997 in 2012. Error rates were generally high when using expired blood glucose test strips. Conclusion: Among 119 paramedics' guideline, quantity and operation status of POCT devices are well managed, but quality control is not. Therefore, it is necessary to add management status and quality control status of POCT devices to the EMS' field work guideline.

Elementary, Middle and High School Parents' Awareness of School Garden Education Service

  • Hong, In-Kyoung;Yun, Hyung-Kwon;Jung, Young-Bin;Lee, Sang-Mi;Lee, Choon-soo
    • Journal of People, Plants, and Environment
    • /
    • v.24 no.2
    • /
    • pp.169-178
    • /
    • 2021
  • Background and objective: Education based on agricultural experience in school gardens is coming to the fore as a solution to reduce the negative effect of rapid urbanization and the development of information technology (IT) on students. Accordingly, this study aimed to investigate how parents of elementary, middle, and high school students in Korea perceive the value of education service using school gardens, as well as their willingness to participate in and pay for such service, and to utilize the results in a quantitative assessment of the socioeconomic value of the education service. Methods: A contactless online survey on the perceived value of education service using school gardens was conducted on 1,010 parents of elementary, middle, and high school students in Korea's five major districts from October 22 to 26 (5 days) of 2020 by M, a Korean specialized survey agency. The data collected was analyzed using SPSS for Windows 25.0 and Excel to obtain the frequency and ratio of each measured item. Results: The respondents had an average of 1.83, of which 52.8% were male. 55.3% of the respondents were aware of the education service using school gardens, and 27.9% experienced the service. When asked if they saw the educational service using school gardens as necessary, 79% answered in the affirmative. In terms of the difference in perception of the need for the service according to experience, 91.8% of the parents who experienced the service responded that it was necessary, indicating that it is important to provide opportunities to experience this service to expand the scope of service. 54.9% of all respondents responded they were willing to pay the costs required for school gardens. When income tax was used as a payment method, the average amount parents were willing to pay was 13,193 KRW, and the tax rate was 2.02%. Based on experience, those who experienced this service had a higher need and willingness to pay for the service than those who had not experience, but the actual amount or tax rate was low as they knew how it was operated. Conclusion: As basic research on the assessment of the value of agricultural experience education using school gardens, this study determined how parents perceive this form of education service as well as their willingness to participate and pay for the service. These findings can be used to systemize the assessment indicators and promote the value of the education service using school gardens, allowing students to maintain a healthy and happy school life through agricultural experience.

Classification of submitted nuclear medicine dissertation and directional consideration (핵의학 투고 논문 분류 및 방향성 고찰)

  • Ho-Yeon, Cho;Yeong-Ran, Woo;Kang-Rok, Seo;Gun-Chul, Hong
    • The Korean Journal of Nuclear Medicine Technology
    • /
    • v.26 no.2
    • /
    • pp.37-42
    • /
    • 2022
  • Purpose Since 1985, the Korean society of nuclear medicine technology (KSNMT) has been engaged in academic activities related to nuclear medicine imaging. From 2017 to 2021, the papers published in the journal were classified by the specific fields to examine the trends in the research and the direction of nuclear medicine in comparison with the papers submitted to the Korean Society of Nuclear Medicine (KSNM) during the same period. Materials and Methods From 2017 to 2021, papers submitted to KSNMT and KSNM were classified and databaseization using the Excel program by submission type, examination equipment, and examination field. Through this data, the number of papers published in journals by year, the number of papers submitted by detailed fields, and key words by era were analyzed and compared. Results The papers included by journal was 57 KSNMT and 280 KSNM. The major large classification of equipment, PET, Planar and SPECT was 26.3%, 21.1%, 19.3% in the KSNMT, KSNM was 49.6%, 6.4%, and 9.3%, with 66.7% and 65.3%, respectively. the major medium classification of equipment, industrial safety, urogenital system, nervous system, and quality control accounted for 54.4% of the total papers of the total ratio in the KSNMT, while the medium classification of oncology, endocrine system, urogenital system, therapy, and nervous system accounted for 61.1% of KSNM. In the major small classification of image acquisition, improvement effect, and exposure management accounted for 70.2% in KSNMT, while the items of image acquisition, report, and improvement effect accounted for 60.7% in KSNM. The major keywords except for equipment-related keywords such as PET/CT, PET/MR, and SPECT were SUV, Planar Image, and Respiration Gating Method in KSNMT and Ga68, Thyroid, and Lymphoma in the KSNM. Conclusion When checking the last 5 years of submissions, we can see that KSNMT is mainly concerned with image acquisition using existing radiotracers, while KSNM has focused on new radiotracers such as 68Ga, 177Lu, etc., and new medical technologies of theranostic. It has been confirmed that more PET-related papers than other examination equipment will account for a greater number of papers, and it is believed that future submissions will also account for a higher proportion of PET-related papers than other equipment.

The Analysis of Professional Education Needs for the Competencies of Occupational Therapists in Cognitive Rehabilitation: Focusing on the Professors in Occupational Therapy Departments of Universities/Colleges in Korea (작업치료사의 인지재활 직무역량에 대한 교육요구도 분석: 국내 대학 작업치료(학)과 교수자를 중심으로)

  • Hong, Seung-Pyo;Lee, Hee-Ryoung;Han, Dae-Sung;Ju, Yu-Mi;Kim, Young-Geun
    • Therapeutic Science for Rehabilitation
    • /
    • v.12 no.3
    • /
    • pp.45-59
    • /
    • 2023
  • Objective : This study aims to identify the status of education in cognitive rehabilitation (CR) in occupational therapy departments of Korean universities/colleges and to analyze the educational needs for professional competencies. Methods : This study was conducted by distributing a questionnaire to professors. The questionnaire extracted items related to professional competencies from the results of a previous Delphi study. A total of 39 respondents from 32 (51.6%) of 62 universities/colleges were analyzed. The questionnaire analysis was conducted using Excel 2010 and SPSS 18.0 to analyze the Borich requirements and the priority of education through the Locus for focus model. Results : The priority of competency in CR was followed by "clinical reasoning ability to explain cognitive problems from the occupational performance perspective", "ability to manage insurance billing for CR", "ability to establish a CR plan based on outcome evaluation", "ability to perform occupation-oriented CR", and "ability to solve problems that occur during CR evaluation and intervention". In the Locus for focus model, items such as occupation-based cognitive assessment, intervention, and skills for documentation were high priorities for education. Conclusion : This study is expected to reflect educational competencies for CR and establish a plan for CR specialists through continuing education.

Priority Area Prediction Service for Local Road Packaging Maintenance Using Spatial Big Data (공간 빅데이터를 활용한 지방도 포장보수 우선지역 예측 서비스)

  • Minyoung Lee;Jiwoo Choi;Inyoung Kim;Sujin Son;Inho Choi
    • Journal of Intelligence and Information Systems
    • /
    • v.29 no.3
    • /
    • pp.79-101
    • /
    • 2023
  • The current status of local road pavement management in Jeollabuk-do only relies on the accomplishments of the site construction company's pavement repair and is only managed through Microsoft Excel and word documents. Furthermore, the budget is irregular each year. Accordingly, a systematic maintenance plan for local roads is necessary. In this paper, data related to road damage and road environment were collected and processed to derive possible areas which could suffer from road damage. The effectiveness of the methodology was reviewed through the on-site inspection of the area. According to the Ministry of Land, Infrastructure and Transport, in 2018, the number of damages on general national roads were about 47,000. In 2019, it reached around 38,000. Furthermore, the number of lawsuits regarding the road damages were about 93 in 2018 and it increased to 119 in 2019. In the case of national roads, the number of damages decreased compared to 2018 due to pavement repairs. To measure the priorities in maintenance of local roads at Jeollabuk-do, data on maintenance history, local port hole occurrence site, overlapping business section, and emergency maintenance section were transformed into data. Eventually, it led to improvements in maintenance of local roads. Furthermore, spatial data were constructed using various current status data related to roads, and finally the data was processed into a new form that could be utilized in machine learning and predictions. Using the spatial data, areas requiring maintenance on pavement were predicted and the results were used to establish new budgets and policies on road management.

Acquisition and Analysis of Environmental Data for Smart Farm (스마트팜 생육환경 데이터 획득 및 분석)

  • Seok-Ho Han;Hoon-Seok Jang
    • The Journal of Korea Institute of Information, Electronics, and Communication Technology
    • /
    • v.16 no.3
    • /
    • pp.130-137
    • /
    • 2023
  • Smart farms, which have been receiving attention as a solution to recent rural problems, refer to technologies that optimize the growing environment of crops and increase the productivity and quality of crops through efficient management. If the relationships between environmental data in smart farms are analyzed, additional productivity enhancement and crop management will be possible. In this paper, we propose a method for acquiring and analyzing nine environmental data, including temperature, humidity, CO2, soil temperature, soil moisture, insolation, soil EC, EC, and pH. Data acquisition is done through RS-485 communication between the main board and the sensor board and stored in the database after acquisition. The stored data is downloaded in Excel sheet format and analyzed through histograms, data charts, and correlation heatmaps. First, we analyze the distribution of total, day, and night data through histogram analysis, and identifiy the average, median, minimum, and maximum values by month through data chart analysis separating day and night to see how the data changes by month. Finally, we analyze the correlation of the data through a correlation heatmap analysis separating day and night. The results show a very strong positive correlation between temperature and soil temperature and soil EC and EC during the day, and a very strong positive correlation between temperature and soil temperature and soil EC and EC at night, and a strong negative correlation between temperature and soil EC.