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

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

건축재료 LCI DB 기반의 공동주택 부위별 환경영향 평가 프로그램 개발 및 적용에 관한 연구 (The development and application of environmental impact assessment program for apartment building element based on building materials LCI DB)

  • 김낙현;태성호;김지훈;이종건
    • KIEAE Journal
    • /
    • 제16권6호
    • /
    • pp.151-157
    • /
    • 2016
  • Purpose: The purpose of this study is to develop and apply an environmental impact assessment program for apartment building elements, based on the building materials of the LCI DB, which can link the LCA results of building materials and buildings. Method: For this purpose, a framework for building elements was established, and several building material combinations were developed. In addition, the LCA method for quantifying environmental load emissions from the building materials of each site was applied to establish an environmental impact database of the building materials of the LCI DB. Result: An environmental impact assessment program, based on a Microsoft Excel worksheet, was developed for apartment building elements. This program can link the environmental impact assessment of building materials and building units. To validate the program evaluation results that were obtained in this study, a comparative analysis was carried out using the results of existing evaluation methods. The error rate was estimated to be 5% for environmental impact assessment using existing evaluation methods.

하수에서의 대장균수 확률분포 특성 분석 (Statistics and Probability Distribution of Total Coliforms in Wastewater)

  • 전상민;송인홍;정한석;강문성;박승우
    • 한국농공학회논문집
    • /
    • 제55권3호
    • /
    • pp.105-111
    • /
    • 2013
  • Probability distribution of microbes in wastewater is a crucial factor to be determined for microbial risk assessment associated with its reuse. The objective of this study was to investigate probability distribution of an indicator microorganism in wastewater. Daily total coliform counts measured from nationwide wastewater treatment plants in 2010 by the Ministry of Environment were used for statistical analysis. Basic statistics and probability distributions were estimated in the three different spatial scales using the MS Excel software and FARD2006 model. Overall, wastewater from manure and livestock treatment plants demonstrated greater median coliform counts than from sewage and village treatment plants. Generalized logistic (GLO) and 2-parameter Weibull (WBU2) appeared to be the two probability distributions that fitted best for total coliform numbers in wastewater. The study results of microbial statistics and probability distributions would provide useful data for quantitative assessment of microbial risk from agricultural wastewater reuse.

Preference and Use of Electronic Information and Resources by Blind/Visually Impaired in NCR Libraries in India

  • Kumar, Shailendra;Sanaman, Gareema
    • Journal of Information Science Theory and Practice
    • /
    • 제1권2호
    • /
    • pp.69-83
    • /
    • 2013
  • This paper aims to determine the preference and use of electronic information and resources by blind/visually impaired users in the leading National Capital Region (NCR) libraries of India. Survey methodology has been used as the basic research tool for data collection with the help of questionnaires. The 125 in total users surveyed in all the five libraries were selected randomly on the basis of willingness of the users with experience of working in digital environments to participate in the survey. The survey results were tabulated and analyzed with descriptive statistics methods using Excel software and 'Stata version 11'. The findings reveal that ICT have a positive impact in the lives of people with disabilities as it helps them to work independently and increases the level of confidence among them. The Internet is the most preferred medium of access to information among the majority of blind/visually impaired users. The 'Complexity of content available on the net' is found as the major challenge faced during Internet use by blind users of NCR libraries. 'Audio books on CDs/DVDs and DAISY books' are the most preferred electronic resources among the majority of blind/visually impaired users. This study will help the library professionals and organizations/institutions serving people with disabilities to develop effective library services for blind/visually impaired users in the digital environment on the basis of findings on information usage behavior in the study.

Design Procedure for System in Package (SIP) Business

  • Kwon, Heung-Kyu
    • 한국마이크로전자및패키징학회:학술대회논문집
    • /
    • 한국마이크로전자및패키징학회 2003년도 International Symposium
    • /
    • pp.109-119
    • /
    • 2003
  • o In order to start SIP Project .Marketing (& ASIC team) should present biz planning, schedule, device/SIP specs., in SIP TFT prior to request SIP development for package development project. .In order to prevent (PCB) revision, test, burn-in, & quality strategy should be fixed by SIP TFT (PE/Test, QA) prior to request for PKG development. .Target product price/cost, package/ test cost should be delivered and reviewed. o Minimum Information for PCB Design, Package Size, and Cost .(Required) package form factor: size, height, type (BGA, QFP), Pin count/pitch .(Estimated) each die size including scribe lane .(Estimated) pad inform. : count, pitch, configuration(in-line/staggered), (open) size .(Estimated) each device (I/O & Core) power (especially for DRAM embedded SIP) .SIP Block diagram, and net-list using excel sheet format o Why is the initial evaluation important\ulcorner .The higher logic power resulted in spec. over of DRAM Tjmax. This caused business drop longrightarrow Thermal simulation of some SIP product is essential in the beginning stage of SIP business planning (or design) stage. (i.e., DRAM embedded SIP) .When SIP is developed using discrete packages, the I/O driver Capa. of each device may be so high for SIP. Since I/O driver capa. was optimized to discrete package and set board environment, this resulted in severe noise problem in SIP. longrightarrow In this case, the electrical performance of product (including PKG) should have been considered (simulated) in the beginning stage of business planning (or design).

  • PDF

비콘을 이용한 매장관리 모바일 어플리케이션 설계 및 구현 (A Design and Implementation of Store Management Application using Beacon)

  • 문가빈;전성희;김성림
    • 디지털산업정보학회논문지
    • /
    • 제14권2호
    • /
    • pp.1-9
    • /
    • 2018
  • Currently, the record of part-timer is mainly written in handwriting or using excel work schedule, paper work recorder, and time attendance program using POS program. And, work table, commute records, paycheck are managed separately. Time-attendance information is not linked and is managed separately, and payment of wages is often not done accurately. And, it is difficult to pay the wages because it is not able to accurately grasp the state of attendance of part-timer. Therefore, it is necessary to have a transparent wage and work management system based on the trust between the owner and the part-timer. In this paper, we design a system that can perform real-time commute check using beacon, transparent wage management, wage calculation by automatic calculation, and smooth communication between owner and the part-timer. We have also implemented a store management mobile application using Android Studio 2.3, Eclipse, Android 5.1 and Beacon devices in a MySQL environment.

무기체계 획득시 최적 의사결정을 위한 지식기반 대안분석모델(KAAM) 연구 (A Study on Knowledge-based Alternatives Analysis Model(KAAM) for the Best Decision Making in Weapon Systems Acquisition)

  • 박광웅;이강영;김치한;최상영
    • 한국국방경영분석학회지
    • /
    • 제33권1호
    • /
    • pp.1-18
    • /
    • 2007
  • 본 연구의 목적은 비교항목들의 척도가 서로 상이하고 측정치를 산정하기 곤란한 대안들의 의사결정시 대안 비교를 과학적으로 할 수 있는 지식기반 대안분석모델(KAAM)을 제안하는 것이다. KAAM은 기존의 방법인 Saaty, Delphi/Shang, Consensus, SAW 기법을 근간으로 하는 하이브리드 방식으로 구성되고 엑셀기반으로 구현하였다. 또한, 무기체계 획득사업의 사전분석 단계에서 최적 획득방안을 선정하는 실증적 사례를 적용함으로서 KAAM의 유용성을 확인하였다.

Study on the Improvement of Paying Taxes in China proposed by the Analysis of Paying Taxes in Korea and Japan

  • LIN, Dai-Jia;KIM, Hyung-Ho
    • 동아시아경상학회지
    • /
    • 제9권3호
    • /
    • pp.29-43
    • /
    • 2021
  • Purpose - The purpose of this study is to analyze the root causes of changes in the rankings of paying taxes in Japan and Korea from 2019 to 2020, and put forward relevant policy recommendations for China from the perspective of enterprise tax burden and tax compliance costs. Research design, data, and methodology - This paper analyzes the data information of four indicators of Japan and Korea in paying taxes from 2009 to 2019, excel tool was used to summarize the essential reasons for the changes. Result - The results showed that, through the reform of tax system, especially the application of electronic tax system for tax declaration, and this is the fundamental reason why Korea has surpassed Japan in the ranking of Paying Taxes in recent five years. Conclusion - Drawing lessons from the reforms in South Korea and Japan, it is concluded that China should improve its tax ranking through two ways. First, deepen the reform of the main tax and fee system and reduce the burden of enterprise taxes and fees. Second, further simplify the tax procedures. Return rights and responsibilities to the enterprise.

공급사슬 리스크 관리에 관한 우선순위 분석 (Priority Analysis of Supply Chain Risk Management for Business Using AHP)

  • 고지영
    • 무역학회지
    • /
    • 제47권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.

Development of a Questionnaire on the Use of Outcome Measures by Korean Physical Therapists Using Focus Group Interview-Based Cognitive Interviewing

  • Jae Hyun Lim;Se Ju Park;Sung Hwan Park;Ho Jin Jeong
    • The Journal of Korean Physical Therapy
    • /
    • 제35권5호
    • /
    • pp.139-144
    • /
    • 2023
  • Purpose: This study developed a Korean sentiment questionnaire by adapting an existing English survey using focus group interview (FGI)-based cognitive interview (CI) techniques to investigate the utilization of outcome measures (OMs) among Korean physical therapists. Methods: The existing OMs survey questionnaire was adapted by dividing eight physical therapists into two groups: mid-experienced (n=4) and high-experienced (n=4). Each group participated in a 120-minute FGI-based CI session. All interviews were recorded, and the researcher transcribed the data immediately after each interview. The data were then organized and categorized into themes using Excel 2021 and verified with the participants. Results: FGI-based CI sessions were conducted with Korean physical therapists to revise the English version of the questionnaire, tailoring it to the local context. Four main themes emerged from the interviews: inappropriate items or translations, questionnaire length and organization, questionnaire improvements, and additional items. The questionnaire was revised based on the feedback obtained during these interviews. Conclusion: The questionnaire was modified according to the themes derived from the interviews. The questionnaire was developed to represent the clinical environment of Korean physical therapy accurately by removing elements of the questionnaire unsuitable for the Korean sentiment and incorporating the perspectives of Korean physical therapists.

전문가시스템을 이용한 석면 및 비석면의 분류 및 확인 (Classifying and Identifying Asbestos and Non-Asbestos Fibers by a Rule Building Expert System)

  • 최영아;이태정;김동술
    • 한국대기환경학회지
    • /
    • 제24권3호
    • /
    • pp.346-356
    • /
    • 2008
  • Asbestos is the name of a group of minerals with long and thin fibers that originate naturally in the environment. Asbestos mainly affects lungs and the membrane that surrounds the lungs. In general, PCM (phase contrast microscopy) and PLM (polarized light microscopy) have been used to analyze asbestos fibers. However, these methods have often problems to over-estimate number concentration when counting real asbestos fibers. Moreover, there are many difficulties when separating and identifying various asbestos and non-asbestos fibers. In order to determine quantitative information on fibrous particles, source profiles for asbestos and non-asbestos fibers must be initially developed on the basis of their chemical compositions and physical parameters. In our study, a SEM/EDX was used to develop source profiles from known asbestos samples as reference samples. We could make the source profile matrix consisting of 6 types of asbestos fibers and 2 types of non-asbestos fibers by analyzing 380 fibers. Based on these profiles, a rule building expert system was developed by using the visual basic application (VBA). Various fibers were successfully classified by 2 simple rules in the EXCEL environment based on several visual steps such as inserting data, viewing results, and saving results. For a case study to test the expert system, samples from a construction materials and from various indoor environments such as a residental area, a preschool classroom, and an underground store were collected and analyzed. As a result of the survey, a total of 76 individual test fiber particles was well classified into 5 different types of particle classes; 9.3% of chrysotile, 15.4% of amosite, 0.8 of crocidolite, 4.2% of tremolite, 5.8% glass fiber, 21.1% of other fibers, and 43.5% of unknown fibers in terms of number concentration. Even though unknown portion was high, it will be decreased markedly when expanding fiber source profiles.