• International conference on construction engineering and project management
• /
• 2013.01a
• /
• pp.141-144
• /
• 2013

This paper presents a system called a Cash-flow based Construction Schedule Optimization system(CfSO). The existing CPM effectively handles schedule and cost management. However, funding strategy should be considered to obtain maximum profit and to progress a project favorably. One of measures is to coordinate the contract terms between owner and subcontractors (or suppliers). Contractor may decrease the interest cost attributed to project financing by adjusting the timing of cash-inflows and cash-outflows. It is an excellent method maximizing profits. This paper presents a method to estimate the amount of a cash-flow occurred periodically by integrating the terms of contract into scheduling. The proposed method is implemented as a system prototype in Microsoft Excel. This system provides a user an automated tool that identifies an optimal schedule that secures maximum profit by adjusting start and finish times of non-critical activities' free-floats without affecting on the project completion time. This system supports a project manager to establish an optimum project schedule and identifies profitable contractual conditions against to a construction owner.

• Korea Trade Review
• /
• v.47 no.3
• /
• pp.17-35
• /
• 2022

The Pandemic crisis caused by COVID-19 has raised awareness of the importance of supply chain risk management, such as the control of movement between countries and the simultaneous manufacturing paralysis in the world. Effective risk management within the supply chain of the company is a core competency in the global environment. Therefore, this study quantitatively analyzed the perspective of domestic large corporations and small and medium enterprises (SMEs) by using the hierarchical analysis method (AHP) to identify the factors that should be considered as the priority when establishing supply chain risk management plans for large and small business employees. In order to conduct the study, a survey was conducted on large corporations and small and medium enterprises in Gyeongnam and Busan, and AHP analysis was conducted using Microsoft 365 excel program. In addition, Mann-Whitney U test (independent sample-nonparametric test) was conducted using SPSS/18 version of statistical package program for comparative analysis between groups. As a result, the priority was highly evaluated in the order of financial ability, competitiveness, disaster in the overall priority evaluation. There were statistically significant differences in internal risk and strategic decision making of supply chain between groups. This suggests that fandemics such as COVID-19 can not be predicted, but strategic responses are needed to utilize opportunities expressed in the crisis through supply chain risk management and to increase the competitive advantage of domestic companies even in the crisis.

• Journal of Smart Tourism
• /
• v.4 no.1
• /
• pp.31-38
• /
• 2024

This study investigates the adoption of technology in smart tourist destinations, with a focus on the Baby Boomer generation. The objective is to analyze the perceived utility, intention to use, and risk perception of this generation regarding Information and Communication Technologies (ICT) in the context of smart tourist destinations. Data were collected through questionnaires administered to elderly groups belonging to the Baby Boomer generation in two Brazilian cities. Data analysis was conducted using statistical tools such as SPSS and Microsoft Excel, with an emphasis on regression analysis with moderation. The results indicate that when Baby Boomer tourists feel insecure about technology, they tend to not perceive its utility, impacting its acceptance. On the other hand, lower risk perceptions lead to an increase in perceived utility and, consequently, a greater intention to use technology in travel planning. The moderating role of risk perception in the relationship between perceived utility and intention to use is emphasized. The findings highlight the need for managers of smart destinations to consider the risks perceived by tourists, focus on diverse age groups, and implement strategies that address digital exclusion.

• Journal of Korean Society of Environmental Engineers
• /
• v.29 no.3
• /
• pp.277-282
• /
• 2007

For more accurate and practical design of the residual treatment train at water treatment plants(WTPs), a computational program based on the commercial spreadsheet, Microsoft Excel, was developed. The computational program for the design of a residual treatment train(DRTT) works in three steps which estimate the residual production to be treated, analyze the mass balance, and determine the size of each unit process. Of particular interest in the DRTT program, is provision for a filter backwash recycle system consisting of surge tank and sedimentation basin for more efficient recycling of backwash water. When the DRTT program was applied to the Chungju WTP, the program was very beneficial in avoiding errors which might have occurred during arithmetic calculations and in reducing the time needed to get the output. It is anticipated that the DRTT program could be used for design of new WTPs as well as the rehabilitation of existing ones.

• Journal of the Korea Society of Computer and Information
• /
• v.19 no.12
• /
• pp.299-307
• /
• 2014

Nowadays, SNS media has become one of the most common and economic communication methods in the modern word. With the rapid development of communication technology, a variety of SNS media makes easier for us to reach other people everywhere and people are getting more and more reliant on them. The surge in SNS media users and SNS media diversity gets more important every day, but academic research on SNS media evaluation program is scanty. In order to present an evaluation program on the SNS media, this study selected some applicable measurement factors based on reference research, and then evaluate major SNS medias by using AHP analysis method. With these purposes, Kakaotalk, Twitter and Facebook, are the three major SNS medias that were chosen for the analysis. Through collections and analysis of usability evaluation factors about SNS quality from related literature, some factors were concluded: system quality, information quality, interface quality and service quality, to build an AHP frame. And to achieve these purposes, this study applied comprehend mutual questionnaire survey for experts and users to gather research date. Empirical studies about the results were performed using AHP method with Microsoft Office Excel 2010. In this study, the final SNS media evaluation result is that Kakaotalk ranks first of the three SNS media, Facebook is in the second place, and Twitter as least. When SNS media are evaluated, system quality, information quality, interface quality and service quality should be considered. Among all factors, service quality is the most important.

• Journal of Korean Neurosurgical Society
• /
• v.63 no.1
• /
• pp.119-135
• /
• 2020

Objective : To investigate the epidemiology of newly-diagnosed, histologically-confirmed (NDHC) central nervous system (CNS) tumours and its changes over a 21-year period in a regional hospital in Hong Kong. Methods : This is a single-institute retrospective descriptive study of patients undergoing surgery for CNS tumours in a regional hospital of Hong Kong in the period from January 1996 to December 2016. The histological definition of CNS tumours was according to the World Health Organization classification, while the site definition for case ascertainment of CNS tumours was as set out by the Central Brain Tumour Registry of the United States. Patients of any age, who had NDHC CNS tumours, either primary or secondary, were included. The following parameters of the patients were retrieved : age at diagnosis, gender, tumour location, and histological diagnosis. Population data were obtained from sources provided by the Government of Hong Kong. The incident rate, estimated by the annual number of cases per 100000 population, for each histology grouping was calculated. Statistical analyses, both including and excluding brain metastases, were performed. Statistical analysis was performed with Microsoft Excel, 2016 (Microsoft, Redmond, WA, USA). Results : Among the 2134 cases of NDHC CNS tumours, there were 1936 cases of intracranial tumours and 198 cases of spinal tumours. The annual number of cases per 100000 population of combined primary intracranial and spinal CNS tumours was 3.6 in 1996, and 11.1 in 2016. Comparing the 5-year average annual number of cases per 100000 population of primary CNS tumours from the period 1996-2000 to 2011-2015, there was an 88% increase, which represent an increase in the absolute number of cases by 4.52 cases/100000 population. This increase was mainly contributed by benign histologies. In the aforementioned periods, meningiomas increased by 1.45 cases/100000 population; schwannomas by 1.05 cases/100000 population, and pituitary adenomas by 0.91 cases/100000 population. While gliomas had a fluctuating 5-year average annual number of cases per 100000 population, it only had an absolute increase of 0.51 cases/100000 population between the 2 periods, which was mainly accounted for by the change in glioblastomas. Conclusion : This retrospective study of CNS tumour epidemiology revealed increasing trends in the incidences of several common CNS tumour histologies in Hong Kong, which agrees with the findings in large-scale studies in Korea and the United States. It is important for different geographic locations to establish their own CNS tumour registry with well-defined and structured data collection and analysis system to meet the international standards.

• Journal of Korean Academy of Nursing Administration
• /
• v.20 no.1
• /
• pp.69-81
• /
• 2014

Purpose: The aim of this study was to investigate and identify work environment, job embeddedness, and burnout among general hospital nurses in Korea. Methods: The participants were 563 clinical nurses working in 13 general hospitals across the country. Data were analyzed using SPSS and Microsoft Excel programs. Results: Mean scores were 2.62 for nurses' work environment, 2.97 for job embeddedness, and 3.61 for burnout. Nurses' work environment showed a positive correlation with job embeddedness (r=.70, p<.001), but a negative correlation with burnout (r=-.49, p<.001). Subcategories of nurses' work environment that predicted job embeddedness included satisfaction and happiness, hospital support for the work environment, patient care environment, satisfaction with work schedule, manager leadership, supportive environment for nurses' work, and computer problems. Subcategories of nurses' work environment that predicted burnout included satisfaction and happiness, violence within ward, hospital support for work environment, and patient care environment. Conclusion: Findings from this study indicate the need to evaluate and improve the work environment for nurses to increase job embeddedness and control burnout. Future studies should explore ways in which turnover intention can be decreased by changing nurses' work environment.

• Journal of the Korea Society of Computer and Information
• /
• v.25 no.9
• /
• pp.117-123
• /
• 2020

This study intended to develop the Performance Evaluation system for the modern pentathlon such as an Olympic sporting event. The performance evaluation index system for the modern pentathlon was developed by Microsoft Excel 2016 with Visual Basic for Application that it is able to be understandable for the practical field in sport. Consequently, the system for the performance evaluation index is able to be developed within the concept of performance analysis of sport such as a notational analysis of sport. And the performance indicators for the performance evaluation index were selected by the skills to make successful outcomes. Finally, the simulation with big data gathering by the developed system would be requested that systematic reviews on successful outcomes in other sporting events would be necessary.

• The Journal of Society for e-Business Studies
• /
• v.25 no.3
• /
• pp.131-145
• /
• 2020

The numbers of SNS (Social Network Service) users and usage amounts are increasing every year. The influence of SNS is increasing also. SNS has a wide range of influences from daily decision-making to corporate management activities. Therefore, proper analysis of SNS can be a very meaningful work, and many studies are making a lot of effort to look into various activities and relationships in SNS. In this study, we analyze the SNS following relationships using Twitter, one of the representative SNS services. In other words, unlike the existing SNS analysis, our intention is to analyze the interests of the accounts by extracting and visualizing the accounts that two accounts follow in common. For this, a common following account was extracted using Microsoft Excel macros, and the relationship between the extracted accounts was defined using an adjacency matrix. In addition, to facilitate the analysis of the following relationships, a direction graph was used for visualization, and R programming was used for such visualization.

• Korean Journal of Community Nutrition
• /
• v.12 no.2
• /
• pp.150-159
• /
• 2007

Since the 1980's, despite the conclusion of a number of studies in Western countries focusing upon weight maintenance there has been no similar research in Korea which takes into account the contrasts of culture and eating habits between east and west. In order to identify eating, snacking and exercise behaviors, 24 female university students who have maintained weight for at least a year were enrolled fur an 11 day study. Participants were required to sign into the program and complete the questionnaire, answering questions by concerning what they ate and did everyday. After excluding unanswered questions, data over 11 days were exported into the Microsoft Excel spreadsheet, then both ANOVA and Kendall's tau correlation were applied with SPSS. 75% of weight maintainers had normal BMI (18-23.5) in relation to Korean standard, and appeared to eat a main meal smaller than moderate in portion size. Only two days showed that amount of breakfast eaten negatively correlated with lunch (p < 0.05), while no correlations between amounts of lunch and dinner eaten over all study period. Compared with breakfast or lunch, dinner was usually larger in portion size, but some variables such as TV viewing, restaurant meals, number of people at dinner table seemed not correlated with amount of dinner eaten. In addition, the weight-maintainers reported they rarely consumed snacks or sweetened beverages. Unlike their western counterparts, ffw participants reported that they took part in regular exercise during the day, which may lead us to the conclusion that these young female weight maintainers seem to maintain their weight with eating behaviours such as 'eat small portion', 'avoid snacking' and 'avoid soft drinks' rather than doing regular exercise. The study did not include a control group, and was foreshortened due to technical difficulties so it may be necessary to repeat the study while considering these two points.