• Title/Summary/Keyword: MS Excel

Search Result 101, Processing Time 0.028 seconds

Statistical Process Control Software developed by MS-EXCEL and Visual Basic (MS-EXCEL과 Visual Basic으로 개발한 통계적 공정관리 소프트웨어)

  • Han, Kyung-Soo;Ahn, Jeong-Yong
    • Journal of Korean Society for Quality Management
    • /
    • v.24 no.2
    • /
    • pp.172-178
    • /
    • 1996
  • In this study, we developed a software for statistical process control. This software presents $\bar{x}$, R, CUSUM, EWMA control chart and process capability index. In this system, statistical process control methods are integrated into the automated method on a real time base. It is available in process control of specified type and can be performed on personal computer with network system.

  • PDF

Production and Application of the Dose Calculation Program which used MS EXCEL and Bit System (MS EXCEL 및 Bit system을 이용한 피부선량 계산 프로그램의 제작 및 응용)

  • Kim, Sung-Chul;Kim, Chong-Yeal
    • Journal of radiological science and technology
    • /
    • v.32 no.1
    • /
    • pp.39-43
    • /
    • 2009
  • The medical diagnostic examination using ionizing radiation has improved the patients' life and brought revolution in medical examination along with the mechanical development. However, the development of medical imaging systems has also been the reason to increase the patients' exposure for ionizing radiation. ICRP recommends that each country adopts diagnostic reference levels depending on regional and national situations. The Korea Food & Drug Administration suggested the dosimetry measurement guideline for patients in 2007. Nonetheless, in reality, it is hard to know the skin dose of the patients when applying a x-ray since there is no radiation dosimeter in most of clinical situation. Therefore, this study sets a program based on the bit system to figure out easily the skin dose of a patients using MS Excel program in the PC setting. The results showed 10% better outcome.

  • PDF

A Case Study on Team Project in Calculus for Medicine - Numerical Methods of Integration - (의대생을 위한 미분적분학 팀프로젝트 사례 - 정적분의 수치채산법을 중심으로 -)

  • Min, Sook
    • Communications of Mathematical Education
    • /
    • v.26 no.2
    • /
    • pp.155-176
    • /
    • 2012
  • In this paper, we present a practical and essential method of using team projects for calculus. We, specifically, take into account the team project that calculate the volume of lung represented on CT scan images. We have demonstrated that the process of analyzing the images in a team project encourage studying numerical methods of integration for calculus. Also, we have used various technological programs(MATLAB, MATHEMATICA, MS Excel) to solve the team project.

A Method for Automatic Generating Check Sheet of Jig and Die in Automobile Components Using CAD Model (CAD모델을 이용한 자동차 프레스 부품 검사 치구 체크 시트의 자동 생성방법)

  • 박성도;이철수
    • Korean Journal of Computational Design and Engineering
    • /
    • v.7 no.2
    • /
    • pp.102-109
    • /
    • 2002
  • This paper presents a method for automatic generating of check sheet to measure deep-drawn sheet metal. By using polyhedral model of CAD, the proposed procedure calculates measuring points automatically. The results of measure are exported to MS-Excel. The proposed method is implemented by API functions and C language using SPEED plus CAD/CAM system and MS-Window OLE.

A Real Problem-based Teaching Method in Statistics Education with a Web-based Data Collection Program (웹 기반 자료수집 프로그램을 활용한 실제 문제중심의 통계교육 수업방안)

  • Han, Beom-Soo;Han, Kyung-Soo;Ahn, Jeong-Yong
    • Journal of the Korean School Mathematics Society
    • /
    • v.8 no.2
    • /
    • pp.167-181
    • /
    • 2005
  • Statistics is based on a data, therefore a practical use of suitable data is important in teaching statistics. But, most teachers feel always that there is seldom data that students can understand easily. In this study, we presented a teaching method of statistics education that can elevate student's participation and interest in their statistics class using a web-based data collection program and MS Excel software. Also, the presented teaching method may apply extending to various part of statistics education.

  • PDF

Design and Implementation of Metadata Management System for Serious Game (기능성 게임을 위한 메타데이터 관리 시스템의 설계 및 구현)

  • Yoon, Sun-Jung;Park, Hee-Sook
    • Journal of the Korea Institute of Information and Communication Engineering
    • /
    • v.14 no.4
    • /
    • pp.893-900
    • /
    • 2010
  • One of the most interests is currently a field related with serious game. Also, the scale of serious game industry is rapid quantitative growth every year. For effective management of metadata of serious game is an important issue so that we propose design of integrated management system for effective management of metadata of serious game. The system provide a service based on internet. Users(general users, developers, experts and managers of metadata) of serious game who can carry out effectively works using proposed system such as new metadata information input, existing metadata information search, generated document files(HTML, XML, EXCEL, MS-WORD) as search results saving into their owns local computer system and so on.

Implementation of Customized 4D and 5D System based on BIM (BIM 기반 사용자 맞춤형 4D 및 5D 시스템 구현)

  • Lee, Jae-Cheol
    • Journal of the Korea Academia-Industrial cooperation Society
    • /
    • v.17 no.8
    • /
    • pp.55-61
    • /
    • 2016
  • BIM is a rising core technology for increasing the productivity of the AEC industry, but such a paradigm shift is placing excessive demand on the practice of small medium size enterprises. BIM has many useful functions that are difficult to imagine in 2D CAD but BIM programs and the system buildup cost are too expensive. Therefore, small medium size enterprises hesitate to apply BIM in their fields. In this study, a customized 4D and 5D system was implemented using the building information generated from basic BIM tools, such as Revit, MS Project, Navisworks, and Excel VBA's customizing process to review the schedule and verify the quantities according to the schedule. Those programs are so basic in BIM circumstances, that small medium size enterprises can be equipped without burden. As a result, essential building information for 4D and 5D system implementation was investigated and its customizing process was established.

A Study on Validation Testing for Input Files of MS Word-Processor (MS 워드프로세서의 입력 파일에 대한 유효성 테스팅 방법에 관한 연구)

  • Yun, Young-Min;Choi, Jong-Cheon;Yoo, Hae-Young;Cho, Seong-Je
    • The KIPS Transactions:PartC
    • /
    • v.14C no.4
    • /
    • pp.313-320
    • /
    • 2007
  • In this paper, we propose a method to analyze security vulnerabilities of MS word-processor by checking the validation of its input files. That is, this study is to detect some vulnerabilities in the input file of the word processor by analyzing the header information of its input file. This validation test can not be conducted by the existing software fault injection tools including Holodeck and CANVAS. The proposed method can be also applied to identify the input file vulnerabilities of Hangul and Microsoft Excel which handle a data file with a header as an input. Moreover, our method can provide a means for assessing the fault tolerance and trustworthiness of the target software.

ShareIt: An Application Sharing System using Window Capturing and Multicast under Heterogeneous Window Systems

  • Jung, Jin-H.;Park, Hyun, J.;Yang, Hyun-S.
    • Proceedings of the Korean Society of Broadcast Engineers Conference
    • /
    • 1998.06b
    • /
    • pp.99-104
    • /
    • 1998
  • Application sharing is the ability to use existing applications, such as Excel or MS-Word, during a group session without modification. In this paper, we present the design and implementation of an application sharing system, called ShareIt, which enable users to share arbitrary MS-Windows applications under the Win 3.1/95/NT and X window system, and evaluation of the system performance. To share an application, the image of the application window is captured and transmitted to other sites. With the use of the window capturing method, ShareIt allows any MS-Windows application to be shared regardless of not only the window systems but also the version-up of window systems.

  • PDF

Evaluation of Recent Data Processing Strategies on Q-TOF LC/MS Based Untargeted Metabolomics

  • Kaplan, Ozan;Celebier, Mustafa
    • Mass Spectrometry Letters
    • /
    • v.11 no.1
    • /
    • pp.1-5
    • /
    • 2020
  • In this study, some of the recently reported data processing strategies were evaluated and modified based on their capabilities and a brief workflow for data mining was redefined for Q-TOF LC-MS based untargeted metabolomics. Commercial pooled human plasma samples were used for this purpose. An ultrafiltration procedure was applied on sample preparation. Sample set was analyzed through Q-TOF LC/MS. A C18 column (Agilent Zorbax 1.8 µM, 50 × 2.1 mm) was used for chromatographic separation. Raw chromatograms were processed using XCMS - R programming language edition and Isotopologue Parameter Optimization (IPO) was used to optimize XCMS parameters. The raw XCMS table was processed using MS Excel to find reliable and reproducible peaks. Totally 1650 reliable and reproducible potential metabolite peaks were found based on the data processing procedures given in this paper. The redefined dataset was upload into MetaboAnalyst platform and the identified metabolites were matched with 86 metabolic pathways. Thus, two list were obtained and presented in this study as supplement files. The first list is to present the retention times and m/z values of detected metabolite peaks. The second list is the metabolic pathways related with the identified metabolites. The briefly described data processing strategies and dataset presented in this study could be beneficial for the researchers working on untargeted metabolomics for processing their data and validating their results.