• Title/Summary/Keyword: excel

Search Result 832, Processing Time 0.03 seconds

A Study on the Effects of Franchise's Factors and Performance : Analysis Disclosure Agreement (프랜차이즈 가맹본부의 특성과 가맹점 사업 성과간의 영향에 관한 연구 : 정보공개서를 중심으로)

  • Lee, Eun-Ji;Cho, Chul-Ho
    • The Korean Journal of Franchise Management
    • /
    • v.3 no.2
    • /
    • pp.20-38
    • /
    • 2012
  • After being introduced into franchises industry, franchise has made a phenomenal growth in a short time and a substantial contribution to job creation and economic revitalization. Nevertheless, franchise business operators failed a business or low profit because of a lack of information and indiscriminate foundation. Therefore the first object of this study is characteristics of franchise's factors on disclosure agreement in franchise associate website. second is examinations about casual relationship between factor and franchise performance with using Excel and SPSS 18.0 versions. The findings of present study were as follows. First, franchises manage small business mostly(financial data, scale so on) and franchise's type focused the food service industry. Specially, a business district select unprotected contract. Second, in franchise's factors, we could find statistically significant effect on annual average sales and annual average net profit. However growth rate of franchise don't have statistically significant effect. Third, we could find statistically significant difference on analysis both franchises' factors and financial data. In conclusion, we must consider of franchise industry environment and success effect on performance in starting one's business. Furthermore franchises plan ways for their sustained growth and protection of rights and interests. Finally business operator draw up their information and upgrade continuously for franchises industry growth. Discussion and theoretical and managerial implications of the results were described along with future franchise research suggestions.

Optimized Hardware Design using Sobel and Median Filters for Lane Detection

  • Lee, Chang-Yong;Kim, Young-Hyung;Lee, Yong-Hwan
    • Journal of Advanced Information Technology and Convergence
    • /
    • v.9 no.1
    • /
    • pp.115-125
    • /
    • 2019
  • In this paper, the image is received from the camera and the lane is sensed. There are various ways to detect lanes. Generally, the method of detecting edges uses a lot of the Sobel edge detection and the Canny edge detection. The minimum use of multiplication and division is used when designing for the hardware configuration. The images are tested using a black box image mounted on the vehicle. Because the top of the image of the used the black box is mostly background, the calculation process is excluded. Also, to speed up, YCbCr is calculated from the image and only the data for the desired color, white and yellow lane, is obtained to detect the lane. The median filter is used to remove noise from images. Intermediate filters excel at noise rejection, but they generally take a long time to compare all values. In this paper, by using addition, the time can be shortened by obtaining and using the result value of the median filter. In case of the Sobel edge detection, the speed is faster and noise sensitive compared to the Canny edge detection. These shortcomings are constructed using complementary algorithms. It also organizes and processes data into parallel processing pipelines. To reduce the size of memory, the system does not use memory to store all data at each step, but stores it using four line buffers. Three line buffers perform mask operations, and one line buffer stores new data at the same time as the operation. Through this work, memory can use six times faster the processing speed and about 33% greater quantity than other methods presented in this paper. The target operating frequency is designed so that the system operates at 50MHz. It is possible to use 2157fps for the images of 640by360 size based on the target operating frequency, 540fps for the HD images and 240fps for the Full HD images, which can be used for most images with 30fps as well as 60fps for the images with 60fps. The maximum operating frequency can be used for larger amounts of the frame processing.

Methods for Quantitative Disassembly and Code Establishment of CBS in BIM for Program and Payment Management (BIM의 공정과 기성 관리 적용을 위한 CBS 수량 분개 및 코드 정립 방안)

  • Hando Kim;Jeongyong Nam;Yongju Kim;Inhye Ryu
    • Journal of the Computational Structural Engineering Institute of Korea
    • /
    • v.36 no.6
    • /
    • pp.381-389
    • /
    • 2023
  • One of the crucial components in building information modeling (BIM) is data. To systematically manage these data, various research studies have focused on the creation of object breakdown structures and property sets. Specifically, crucial data for managing programs and payments involves work breakdown structures (WBSs) and cost breakdown structures (CBSs), which are indispensable for mapping BIM objects. Achieving this requires disassembling CBS quantities based on 3D objects and WBS. However, this task is highly tedious owing to the large volume of CBS and divergent coding practices employed by different organizations. Manual processes, such as those based on Excel, become nearly impossible for such extensive tasks. In response to the challenge of computing quantities that are difficult to derive from BIM objects, this study presents methods for disassembling length-based quantities, incorporating significant portions of the bill of quantities (BOQs). The proposed approach recommends suitable CBS by leveraging the accumulated history of WBS-CBS mapping databases. Additionally, it establishes a unified CBS code, facilitating the effective operation of CBS databases.

Analytic Hierarchy Process approach to estimate weights of menu management in the school foodservice (계층적 분석과정을 적용한 학교급식 식단 구성의 중요도 분석)

  • Hyo Bin Im;Seo Ha Lee;Hojin Lee;Lana Chung;Min A Lee
    • Journal of Nutrition and Health
    • /
    • v.57 no.3
    • /
    • pp.349-364
    • /
    • 2024
  • Purpose: This study used the Analytic Hierarchy Process to evaluate the relative importance of the factors that school nutrition teachers and dietitians consider during menu planning for school foodservices across various educational levels. Methods: An online survey was conducted from December 2023 to January 2024. The hierarchical structure for school foodservice menu management was developed through content analysis, consisting of five high-level categories and 3-4 low-level factors. Questionnaires were distributed to 395 nutrition teachers and dietitians from kindergarten, elementary, middle, and high schools nationwide. One hundred and sixty-six responses were received, resulting in a 42.0% return rate. These responses were analyzed using Microsoft Excel and SPSS Statistics. Results: The most commonly referenced sources for school foodservice menu planning were 'menus obtained from websites' (19.4%). The most significant challenge encountered was 'incorporating students' preferences' (18.6%). In the hierarchy of categories considered for school foodservice menu management, 'employees and facilities' ranked highest (0.2347), followed by 'preference' (0.2312), 'nutrition balance' (0.2027), 'cooking process' (0.1726), and 'food materials' (0.1588). Within each category, the top-ranked factors were 'employees' cooking skills' (0.3759), 'students' preferences' (0.4310), 'dietary reference intakes' (0.4968), 'foodservice hygiene' (0.4374), and 'food costs' (0.4213). The study also compared the relative importance of factors according to the educational levels, and the top-ranked factors were the same across all educational levels. In particular, 'students' preferences', 'dietary reference intake', and 'food costs' aligned with the top three challenges in school foodservice menu planning. Conclusion: Enhancing working conditions for school foodservice employees and developing menu planning methods that accommodate students' preferences are necessary. These findings will provide foundational data for future school foodservice menu management strategies.

Attitudes on Medical Market Opening and Factors for Selecting a Foreign Hospital of Korean University Hospital Outpatients (환자들의 의료시장개방에 대한 인식도와 외국병원 선택요인 - S대학교병원 외래환자들을 대상으로 -)

  • Yoon, Yur-Yong;Yu, Seung-Hum;Kim, You-Young;Oh, Hyohn-Joo
    • Korea Journal of Hospital Management
    • /
    • v.8 no.3
    • /
    • pp.32-48
    • /
    • 2003
  • Korea is to open its medical markets to foreign hospitals starting in the year 2006 regardless of our will(DDA, Doha Development Agenda). To accurately understand the characteristics of Korean medical users, their detailed and various needs, their attitudes toward the opening of Korean medical markets, and factors affecting these users in choosing foreign medical service providers would be first step needs to be taken by the Korean medical facilities that need to survive and develope through the fiercely competitive era coming with the opening of Korean medical markets to foreign medical service providers and would be very important in hospital management. The subjects of this study were 500 patients randomly selected from the outpatients who visited one of university hospitals in Seoul on the 14th-16th days of April 2003, and conducted a self-completion questionnaire. The answers of 463 respondents among the selected patients(93% of a responding rate)were analyzed through the Excel and statistics programs. The attitudes on the opening of the medical markets were shown in agreement 56.5%(247 persons), disagreement 6.9%(30 persons), and no idea 36.6%(160 persons). In consideration of only the answers as agreement and disagreement exclusive of the answer as no idea, 89.2% of the respondents agreed to the opening of the medical markets while 10.8% objected to the opening. The approval rate was higher with the higher education and income levels. Moreover, The approval rate for the opening of the medical markets was relatively high regardless of the satisfaction in the medical service, and the most important reason of the agreement was the guarantee of the patients(national)option. The main reason of the disagreement was high medical fee(50.5%), and the other reasons showing low rates were outflow of the domestic fund to the foreign countries(13.6%), damage of medical influences on the public(11.4%), lack of competition of the domestic medical industry(9.1%)and so on. As for the factors of selecting the foreign hospitals in the opening of the medical markets, the patients considered the authority(competency)of doctors firstly, and the other principal factors were worldwide fame and reliance, specific explanation of doctors, modernized medical instruments, convenient consultation procedure, etc. The patients agreed to the opening of the medical markets at a high rate regardless of the satisfaction in the medical service, and the most principal reason of the agreement was the guarantee of the patients(national)option for the medical care. Connected with the factors to select the hospitals, the approval reasons for the opening of the medical markets were the authority(competency)of the doctors as the first one, and then fame and tradition, reliance, overall diagnosis and modernized medical instruments, doctors specific explanation, and so on. However, these factors are actually associated with the Quality of the medical care, and consequently the approval reasons for the opening of the medical markets are connected with the security of the medical care. Accordingly, the guarantee of the patients(national)option answered as the main reason of the agreement can be also understood as the awareness of the right to have a variety of options for the security of the medical quality.

  • PDF

Evaluation of dose delivery accuracy due to variation in pitch and roll (세기변조방사선치료에서 Pitch와 Roll 변화에 따른 선량전달 정확성 평가)

  • Jeong, Chang Young;Bae, Sun Myung;Lee, Dong Hyung;Min, Soon Ki;Kang, Tae Young;Baek, Geum Mun
    • The Journal of Korean Society for Radiation Therapy
    • /
    • v.26 no.2
    • /
    • pp.239-245
    • /
    • 2014
  • Purpose : The purpose of this study is to verify the accuracy of dose delivery according to the pitch and roll rotational setup error with 6D robotic couch in Intensity Modulated Radiation Therapy (IMRT) for pelvic region in patients. Materials and Methods : Trilogy(Varian, USA) and 6D robotic couch(ProturaTM 1.4, CIVCO, USA) were used to measure and analyze the rotational setup error of 14 patients (157 setup cases) for pelvic region. The total 157 Images(CBCT 78, Radiography 79) were used to calculate the mean value and the incidence of pitch and roll rotational setup error with Microsoft Office Excel 2007. The measured data (3 mm, 3%) at the reference angle ($0^{\circ}$) without couch rotation of pitch and roll direction was compared to the others at different pitch and roll angles ($1^{\circ}$, $1.5^{\circ}$, $2^{\circ}$, $2.5^{\circ}$) to verify the accuracy of dose delivery by using 2D array ionization chamber (I'mRT Matrixx, IBA Dosimetry, Germany) and MultiCube Phantom(IBA Dosimetry, Germany). Result from the data, gamma index was evaluated. Results : The mean values of pitch and roll rotational setup error were $0.9^{\circ}{\pm}0.7$, $0.5^{\circ}{\pm}0.6$. The maximum values of them were $2.8^{\circ}$, $2.0^{\circ}$. All of the minimum values were zero. The mean values of gamma pass rate at four different pitch angles ($1^{\circ}$, $1.5^{\circ}$, $2^{\circ}$, $2.5^{\circ}$) were 97.75%, 96.65%, 94.38% and 90.91%. The mean values of gamma pass rate at four different roll angles ($1^{\circ}$, $1.5^{\circ}$, $2^{\circ}$, $2.5^{\circ}$) were 93.68%, 93.05%, 87.77% and 84.96%. when the same angles ($1^{\circ}$, $1.5^{\circ}$, $2^{\circ}$) of pitch and roll were applied simultaneously, The mean values of each angle were 94.90%, 92.37% and 87.88%, respectively. Conclusion : As a result of this study, it was able to recognize that the accuracy of dose delivered is lowered gradually as pitch and roll increases. In order to increase the accuracy of delivered dose, therefore, it is recommended to perform IGRT or correct patient's position in the pitch and roll direction, to improve the quality of treatment.

A Comparative Study of CTDI and the Effective Dose and the SNR according to the Area in the Abdominal CT (복부CT에서 면적에 따른 CTDI와 유효선량 및 SNR의 비교 연구)

  • Choi, Sung-Jun;Kang, Jun-Guk;Kim, Su-In;Kim, Youn-Ho;Lee, Do-Gyeong;Jung, Jin-Gyung;Cho, Ar-A;Jang, Jae-Hyeok;Kweon, Dae-Cheol
    • Journal of radiological science and technology
    • /
    • v.38 no.3
    • /
    • pp.245-252
    • /
    • 2015
  • To obtain the best SNR (signal to noise ratio) due to changes in CTDI (computed tomography dose index) made for the purpose of setting the optimum image obtained by reducing the dose in abdominal CT. Abdominal CT scans of 59 patients a $400-499cm^2$ (n = 12), $500-599cm^2$ (n = 21), $600-699cm^2$ (n = 17), $700-799cm^2$ (n = 9) were separated by four groups and the effective dose was used in the Excel to get the area of the patient using the ImageJ program. Patients of CTDI, DLP, SNR, the effective dose were analyzed. Abdominal CT area was increased to 13 mGy in CTDI is 7.3 mGy, DLP to 732 in $394.4mGy{\cdot}cm$, also effective dose was 5.9 mSv increase in 11mSv. SNR is 15 dB was maintained at 12.7. CTDI according to the average of the abdominal area of 8.9 mGy, the average of the DLP was $481.54mGy{\cdot}cm$, the effective dose is calculated to be 7.2 mSV. Effective dose was calculated by multiplying the load factor of DLP in the abdomen showed no statistically significant difference of (p < .05), there was a significant difference in SNR (p > . 05). To improve image quality of abdominal CT scan image in consideration of the CTDI according to the volume of the patient it should be able to reduce the radiation exposure of the patients.

Status of Health and Safety Management in Occupational Hygiene Laboratories in Korea

  • Yang, Hyukseung;Choi, Jaewook;Yoon, Seokjoon;FARR, Terry
    • Journal of Korean Society of Occupational and Environmental Hygiene
    • /
    • v.17 no.1
    • /
    • pp.53-62
    • /
    • 2007
  • 목적: 1990년대 초반부터 시작된 우리나라의 산업 보건에 대한 사회적 관심의 증대와 시장의 요구에 따라 산업위생기관의 양적인 팽창이 이루어지긴 하였으나 실험실 관련 안전보건규정이 미비한 상태에서 추진되어 산업위생 실험실에서 다양한 유해 위험성 인자를 취급함에도 불구하고 사용되는 량이 소규모로 인해 안전보건과 관련된 사항은 대부분 간과하고 있으며, 산업위생 실험실의 안전보건관리 실태는 선진외국에 비해 상당히 낙후되어 있는 실정이다. 따라서 본 연구는 우리나라 산업위생 실험실과 관련한 안전보건관리 실태를 평가함으로써 향후 실험실의 안전보건관리 수준을 향상 시키는데 효과적인 자료로 활용하는데 기여하고자 한다. 방법: 산업위생실험실의 안전보건 실태를 파악하기 위해 설문조사를 수행하였으며, 설문은 실험실의 전반적인 안전보건, 화학물질 저장 및 용기, 가연성 및 인화성 화학물질, 가스 실린더, 의사전달, 응급처치 및 비상사태 장비, 정리정돈, 소방안전, 전기안전, 개인보호구, 흄후드 및 환기, 및 이황화탄소 취급 사례로서 12개 영역으로 구성되었다. 연구대상은 2001년 한국산업안전공단 정도관리프로그램에 참여한 기관으로서 총 대상은 119개 기관이었다. 연구기간은 2002년 7월 01일부터 8월 30일까지 약 60일 이었다. 설문은 반송봉투에 넣어 설문완성 후 연구자에게 보낼 수 있도록 배려하였으며, 1차 설문을 보낸 후 2주 후에 설문 참여를 독려하기 위해 엽서를 발송하였고, 다시 2주 후에 각 산업위생기관에 개별 전화 연락을 취하였다. 그 결과 63% (75개 기관)의 완성된 설문을 얻을 수 있었다. 설문의 총 조사항목은 79문항으로 구성되어 있으며, 산업위생실험실의 안전보건 수준을 정량적으로 평가하기 위해 안전보건 매뉴얼, 교육훈련프로그램 및 한국산업안전공단 실험실 지침서를 보유한 기관과 그렇지 않은 기관간의 차이는 선별된 67문항에 대해 각 문항에 합당하거나 적절할 경우 1점을 부여하는 방식으로 점수화하였다. 이들의 관련성을 파악하기 위하여 Microsoft-Excel 2000 프로그램을 이용하여 two-tailed t-test 분석을 실시하였다. 결과 1. 산업위생실험실 운영과 관련한 67개 항목(항목별로 각 1점 부여)에 대한 안전보건 성과지수화 (100점으로 점수 환산) 결과 안전보건 매뉴얼을 보유한 기관은 $42.98{\pm}13.36$(p<0.001)점, 교육훈련프로그램을 보유한 기관은 $50.75{\pm}14.12$(p<0.01)점, 한국산업안전공단 실험실 지침서를 보유한 기관은 $43.58{\pm}11.92$(p<0.01)점으로 그렇지 않은 기관에 비해 통계적으로 유의하게 높은 점수분포를 보였다. 2. 화학물질 보관 캐비닛이 있는 기관 중 64.8%의 기관은 화학물질을 알파벳 순으로, 27.8%는 분류 기준에 따라, 그리고 7.4%는 무작위로 보관하고 있었다. 3. 단지 8.0% (6개)의 기관만이 실험실내에 눈세정 분수(2 개), 샤워기(3개) 및 눈세정물병(3개, 2개 중복 응답 기관)과 같은 응급처치 장치 및 물품을 갖추고 있었다. 4. 89.0%의 기관이 흄후드내에 화학물질을 보관하고 있었다. 5. 물질안전보건자료, 흄후드 기록지, 비상사태 절차서 및 한국산업안전공단 실험실 지침서와 같은 문서관리는 부적절하게 관리 및 기록되고 있었다. 6. 대부분의 산업위생 실험실은 응급처치 장비, 화학물질 또는 가스용기 보관실과 같은 실험실 안전설비가 부족할 뿐만 아니라 정리정돈, 화학물질 저장 캐비닛, 안전보호구 및 흄후드와 같은 관리가 미비하였다. 결론: 이상의 결과에 근거하여 기관장은 실험실의 안전보건관리를 위하여 문서관리체계를 제공하고, 모든 실험실 종사자가 적절한 개인보호구를 착용할 수 있도록 하며, 비상 장비를 설치하고, 실험실과 관련한 적절한 규정을 제정하며, 교육훈련 프로그램을 제공하여야 한다. 또한 실험실 종사자는 실험 중 적절한 개인보호구의 착용하고, 비상장비 이용에 대한 교육훈련에 참여하며, 적절한 실험실 운영관리에 대한 책임감을 가져야 한다. 위의 권고사항 이행을 위해서 KOSHA는 KQCP 프로그램에 실험실 안전보건관리 항목을 삽입하여 주기적인 평가를 수행할 필요가 있다. 우리나라 실험실의 특성을 고려할 때 본 연구결과는 일반 실험실에도 적용될 수 있을 것으로 생각된다.

Training Needs Analysis for the Roles and Competency of Field Representatives in Electric Work (전기공사 현장대리인의 역할 및 역량에 대한 교육요구분석)

  • Yun, Hyeon Woo;Yoon, Gwan Sik
    • 대한공업교육학회지
    • /
    • v.40 no.1
    • /
    • pp.142-162
    • /
    • 2015
  • The purpose of this study are to provide the basic data materials and implementations for successful performance of electric-work field representatives of South Korean firms by identifying their roles and competency and examining their educational need. For this research purposes, three phased analysis was followed on: (1) the roles of electric-work field representatives, (2) competency of electric-work field representatives and (3) educational need for their competency. This research method was to conduct a focus group interview for 10 expert field representatives along with survey. The collected data materials were processed by MS Excel and SPSS 21.0 for statistical analysis including average, standard deviation and other basic statistics; the gap in awareness of field representatives; and need values. For the needs analysis, the difference between significance of field representatives' competency and current status was examined by t test. And the awareness gap between competency importance and current status was identified based on the Borich equation. The Locus for Focus model was employed herein to identify the kinds of competency with high importance and high inconsistency to prioritize. As a result, this research has found as follows: first, the roles of field representatives were found to be in 13 different kinds of roles. Second, electric-work field representatives were found to need to have 16 different skills. Third, regarding the 16 abilities, the gap between current status and significance was analyzed herein. The results showed statistically significant differences in all cases. The Borich needs analysis found the first required ability was communication ability followed by power of execution, conflict management ability, analytical thinking and time management ability. Also, the results of Locus for Focus model analysis displayed that the first quadrant(HH) included 7 highly-demanded abilities of communication ability, analytical thinking, decision making ability, specialty, time management ability, power of execution and drive for work implementation. The top-priority group was found to have 5 items of communication ability, analytical thinking, time management ability, power of execution and drive for work implementation which were commonly seen in the Locus for Focus model outcomes. Based on these findings, this research could identify the roles and competency of electric-work field representatives and provide the basic data materials applicable to future personal management of electricity companies including recruitment, division of work, job description, evaluation, etc. Also this research offered guidelines on demanded abilities in the field and where to place priority. The kinds of abilities with high educational demand as found in this research must be considered in designing educational programs for the competency building of field representatives. This research is expected to provide useful information in developing such educational programs for field representatives.

Recommender Systems using Structural Hole and Collaborative Filtering (구조적 공백과 협업필터링을 이용한 추천시스템)

  • Kim, Mingun;Kim, Kyoung-Jae
    • Journal of Intelligence and Information Systems
    • /
    • v.20 no.4
    • /
    • pp.107-120
    • /
    • 2014
  • This study proposes a novel recommender system using the structural hole analysis to reflect qualitative and emotional information in recommendation process. Although collaborative filtering (CF) is known as the most popular recommendation algorithm, it has some limitations including scalability and sparsity problems. The scalability problem arises when the volume of users and items become quite large. It means that CF cannot scale up due to large computation time for finding neighbors from the user-item matrix as the number of users and items increases in real-world e-commerce sites. Sparsity is a common problem of most recommender systems due to the fact that users generally evaluate only a small portion of the whole items. In addition, the cold-start problem is the special case of the sparsity problem when users or items newly added to the system with no ratings at all. When the user's preference evaluation data is sparse, two users or items are unlikely to have common ratings, and finally, CF will predict ratings using a very limited number of similar users. Moreover, it may produces biased recommendations because similarity weights may be estimated using only a small portion of rating data. In this study, we suggest a novel limitation of the conventional CF. The limitation is that CF does not consider qualitative and emotional information about users in the recommendation process because it only utilizes user's preference scores of the user-item matrix. To address this novel limitation, this study proposes cluster-indexing CF model with the structural hole analysis for recommendations. In general, the structural hole means a location which connects two separate actors without any redundant connections in the network. The actor who occupies the structural hole can easily access to non-redundant, various and fresh information. Therefore, the actor who occupies the structural hole may be a important person in the focal network and he or she may be the representative person in the focal subgroup in the network. Thus, his or her characteristics may represent the general characteristics of the users in the focal subgroup. In this sense, we can distinguish friends and strangers of the focal user utilizing the structural hole analysis. This study uses the structural hole analysis to select structural holes in subgroups as an initial seeds for a cluster analysis. First, we gather data about users' preference ratings for items and their social network information. For gathering research data, we develop a data collection system. Then, we perform structural hole analysis and find structural holes of social network. Next, we use these structural holes as cluster centroids for the clustering algorithm. Finally, this study makes recommendations using CF within user's cluster, and compare the recommendation performances of comparative models. For implementing experiments of the proposed model, we composite the experimental results from two experiments. The first experiment is the structural hole analysis. For the first one, this study employs a software package for the analysis of social network data - UCINET version 6. The second one is for performing modified clustering, and CF using the result of the cluster analysis. We develop an experimental system using VBA (Visual Basic for Application) of Microsoft Excel 2007 for the second one. This study designs to analyzing clustering based on a novel similarity measure - Pearson correlation between user preference rating vectors for the modified clustering experiment. In addition, this study uses 'all-but-one' approach for the CF experiment. In order to validate the effectiveness of our proposed model, we apply three comparative types of CF models to the same dataset. The experimental results show that the proposed model outperforms the other comparative models. In especial, the proposed model significantly performs better than two comparative modes with the cluster analysis from the statistical significance test. However, the difference between the proposed model and the naive model does not have statistical significance.