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

검색결과 176건 처리시간 0.024초

Orofacial Soft Tissue Reconstruction with Locoregional Flaps in a Health Resource-Depleted Environment: Experiences from Nigeria

  • Agbara, Rowland;Obiadazie, Athanasius Chukwudi;Fomete, Benjamin;Omeje, Kelvin Uchenna
    • Archives of Plastic Surgery
    • /
    • 제43권3호
    • /
    • pp.265-271
    • /
    • 2016
  • Background Reconstruction of orofacial soft tissue defects is often challenging due to functional and aesthetic demands. Despite advances in orofacial soft tissue defect reconstruction using free flaps, locoregional flaps still remain an important option, especially in health resource-depleted environments. This retrospective study highlights our experiences in oral and maxillofacial soft tissue reconstruction using locoregional flaps. Methods A twenty-three years retrospective analysis of all patients managed in our department was undertaken. Information was sourced from patients' case notes and operating theater records. Data was analyzed using SPSS ver. 16 (SPSS Inc.) and Microsoft Excel 2007 (Microsoft). Results A total of 77 patients underwent orofacial soft tissue defect reconstruction within the years reviewed. Males accounted for 55 (71.4%) cases and trauma was the main etiological factor in 45 (58.4%) of the patients treated. When sites of defect were considered, the lip, 27 (32.1%), was the most frequent site followed by the nose, 17 (20.2%). Forehead flap, 51 (59.3%), was the most commonly used flap. Complications noted were tumor recurrences at the recipient bed in 3 (3.9%) cases, tumor occurrence at the donor site in 1 (1.3%) case and postoperative infection in 11 (14.3%) cases. Conclusions Locoregional flaps still have an important role in the rehabilitation of patients with orofacial soft tissue defects. They remain a vital tool in the armamentarium of the reconstructive surgeon, especially in health resource-depleted environments where advanced reconstructive techniques may not be feasible.

자연휴양림 모니터링 시스템 구축에 관한 연구 (Developing Monitoring System for the Recreational Forests in Korea)

  • 이주희;이덕순;한상열;심규원;우경덕
    • 한국환경과학회지
    • /
    • 제14권10호
    • /
    • pp.929-935
    • /
    • 2005
  • The Monitoring System developed in this study was designed to help manage the recreational forests by gathering data on visitors' profiles and their opinions about recreational use and related facilities, This data could identify for changing situations in forest recreation demand as well as providing information on planning the management and use of the forest areas in advance. The standardized questionnaire had contained visitor profiles, activities, distribution of use by area, distribution us by time, duration of the visit, expenditure of visitors and information on visitor satisfaction and motivation. Also, the questionnaire had included the evaluations visitors' perception of facilities in order to identify the importance and performance of the various facilities, such as recreational and educational facilities, accomodations, directional signs as well as infrastructure. The monitoring system was developed in the object-oriented programming (OOP) environment. Microsoft Visual Basic 6,0 for the program language, Microsoft Access, and Excel program were used to develop the system. The monitoring system was composed of data input, database, and data analysis system, Once data were put into data input system, it automatically transferred to database, and it eventually produced the results of statistical analysis with one step procedure. This study was integrated with facilities and visitor monitoring system to identify the visitor impact at the recreational forests. In addition, this monitoring system would provide necessary and useful background information for management on recreational use of natural resources in a practical manner.

Can a spontaneous smile invalidate facial identification by photo-anthropometry?

  • Pinto, Paulo Henrique Viana;Rodrigues, Caio Henrique Pinke;Rozatto, Juliana Rodrigues;da Silva, Ana Maria Bettoni Rodrigues;Bruni, Aline Thais;da Silva, Marco Antonio Moreira Rodrigues;da Silva, Ricardo Henrique Alves
    • Imaging Science in Dentistry
    • /
    • 제51권3호
    • /
    • pp.279-290
    • /
    • 2021
  • Purpose: Using images in the facial image comparison process poses a challenge for forensic experts due to limitations such as the presence of facial expressions. The aims of this study were to analyze how morphometric changes in the face during a spontaneous smile influence the facial image comparison process and to evaluate the reproducibility of measurements obtained by digital stereophotogrammetry in these situations. Materials and Methods: Three examiners used digital stereophotogrammetry to obtain 3-dimensional images of the faces of 10 female participants(aged between 23 and 45 years). Photographs of the participants' faces were captured with their faces at rest (group 1) and with a spontaneous smile (group 2), resulting in a total of 60 3-dimensional images. The digital stereophotogrammetry device obtained the images with a 3.5-ms capture time, which prevented undesirable movements of the participants. Linear measurements between facial landmarks were made, in units of millimeters, and the data were subjected to multivariate and univariate statistical analyses using Pirouette® version 4.5 (InfoMetrix Inc., Woodinville, WA, USA) and Microsoft Excel® (Microsoft Corp., Redmond, WA, USA), respectively. Results: The measurements that most strongly influenced the separation of the groups were related to the labial/buccal region. In general, the data showed low standard deviations, which differed by less than 10% from the measured mean values, demonstrating that the digital stereophotogrammetry technique was reproducible. Conclusion: The impact of spontaneous smiles on the facial image comparison process should be considered, and digital stereophotogrammetry provided good reproducibility.

장외파생상품거래를 위한 유연한 의사결정지원시스템 아키텍처 설계에 관한 연구: A은행 사례 (Design of Flexible DSS Architecture for OTC Derivatives Trading: 'A' Bank Case)

  • 이근우;양근우
    • 한국정보시스템학회지:정보시스템연구
    • /
    • 제20권1호
    • /
    • pp.107-126
    • /
    • 2011
  • Model-based decision support system (DSS) has acted as a crucial role in strengthening the business competitiveness by providing a way of modeling and solving real-world decision problems in a quantitative and scientific manner. It is even more important for trading OTC derivatives, which requires extensive financial-engineering expertise while actively reacting to the continuously changing financial market. This paper proposes a flexible model-based DSS architecture that can support user-friendly interface for executing and analyzing the models and can adapt to the changes of financial market seamlessly. For user-friendliness, we implement the user-interfaces (UIs) using Microsoft Excel, a very widely used spreadsheet program for its great generality and extensibility. Users can utilize the analysis results of DSS or reprocess them for their special needs through the UIs in the form of familiar spreadsheets easily. For adaptiveness to the markets, the proposed architecture is constructed based on the object-oriented concepts, which enables such changes as release of a new financial product can be updated into the system without any delay at the lowest cost. We investigate the practical benefits and limitations of the proposed architecture by a case study on the construction of Model-based Trading Support System (MTSS), performed by a commercial bank in Korea.

정치적 위험의 평가모형과 민감도분석 (Assessment Models of Political Risk and the Sensitivity Analysis)

  • 문창권;임춘호
    • 산학경영연구
    • /
    • 제20권1호
    • /
    • pp.105-122
    • /
    • 2007
  • 해외직접투자는 국내투자와는 달리, 프로젝트를 수행하는 기업에게 사업위험의 정도를 증가시킬 뿐만아니라, 비사업위험에서 정치적 위험과 환위험 등의 추가 위험을 초래한다. 본 연구는 정치적 위험의 식별 및 평가를 위해 위험과 불확실성의 구분을 기초로 정치적 위험의 차원을 규명하고, 정치적 위험의 평가모형을 개발한다. 그리고 평가모형의 적용방법을 스프레드시트를 통해 제시하고, 정치적 위험의 충격과 정치적 위험 발생가능성의 변화에 따른 요구수익률 변화의 민감도 분석을 수행한다. 본 연구는 정치적 위험의 충격이 부정적인 경우에도 투자유치국 현지시장의 수익률변화에 대한 정치적 충격의 발생 가능성 변화에 따라 요구수익률이 감소하는 상황을 설명하고, 정치적 위험의 차원에 따른 손실의 형태를 체계적으로 규명하여 정치적 위험의 평가를 용이하게 할 수 있도록 하였다.

  • PDF

하천유사량 특성분석을 위한 유사량산정시스템 개발 (Development of Sediment Discharge Computation System for Characteristic Analysis of River Sediment Discharge)

  • 이연길;고주연;이진원;정성원
    • 한국수자원학회:학술대회논문집
    • /
    • 한국수자원학회 2009년도 학술발표회 초록집
    • /
    • pp.723-727
    • /
    • 2009
  • 본 연구에서는 유사량 측정의 적절성과 산정결과에 대한 정확성을 도모하고자 총유사량과 하상토유사량을 일관적으로 계산하고, 분석 및 관리할 수 있는 유사량산정시스템(Sediment Discharge Computation System; SDCS)을 개발하였다. 유사량산정시스템(SDCS)은 Microsoft사의 Excel VBA(Visual Basic for Applications)로 개발되어져 실행 및 분석이 간단 용이하고, 또한 유사량 산정결과를 저장하고 관리할 수 있는 DBFPAD가 내재되어 있다. 본 시스템은 크게 총유사량과 하상토유사량 산정 모듈로 구성되어 있어 각각의 모듈에서 유량규모에 대응하는 유사량과 농도를 산정할 수 있다. 총유사량 산정 모듈은 대표적인 확산-이송형 모형이라 할 수 있는 Modified Einstein 공식을 토대로 하였으며, 하상토유사량 산정 모듈은 Einstein, Ackers & White, Engelund & Hansen, Yang의 유사량 공식을 근간으로 되었다. 본 시스템은 크게 총 5개의 모듈을 가지며, 총 20개의 부프로그램(Subroutine Program)과 23개의 사용자정의함수 구문으로 개발되었다. 또한 단면의 특성변화 분석모듈과 DBFPAD 저장 및 관리모듈이 포함되어 있어 산정된 결과를 용이하게 비교 분석할 수 있고, 기존 자료와의 비교도 쉽게 수행할 수 있도록 구성하였다.

  • PDF

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

  • 윤영민;최종천;유해영;조성제
    • 정보처리학회논문지C
    • /
    • 제14C권4호
    • /
    • pp.313-320
    • /
    • 2007
  • 본 논문에서는 MS 워드프로세서의 입력 파일에 대한 유효성을 검사하여 MS 워드프로세서의 보안 취약성을 분석하는 방법을 제안하였다. 즉, 워드프로세서에 적용되는 입력 파일의 헤더 정보를 분석함으로써, 그 입력 파일에 존재하는 취약성을 검출하였다. 본 논문에서 수행한 입력 파일 유효성 테스팅은 기존 결함 주입 도구인 Holodeck 및 CANVAS 등으로는 테스트할 수 없다. 제안한 방법은 헤더를 가진 데이터 파일을 입력으로 사용하는 한글, MS 엑셀 등의 입력 파일에 대한 취약성 검출에도 적용될 수 있다. 또한, 대상 소프트웨어들의 결함 허용성 평가 및 신뢰성 평가에도 사용될 수 있다.

학습성과 수행평가를 위한 루브릭 개발과 적용에 관한 연구 (A Study on the Development and Application of Rubrics for Performance Assessment in Terms of Promoting Program Learning Outcomes)

  • 신민희
    • 공학교육연구
    • /
    • 제15권5호
    • /
    • pp.108-118
    • /
    • 2012
  • The purpose of this study was to provide analytic rubrics for measuring teamwork(PO6), communication and presentation skills(PO7), and life-long learning(PO8) based on theoretical concepts of performance assessment and rubrics. Also, this study analyzed data about performance assessment and rubics from courses offered through college of engineering. Participants were 34 senior engineering students who took the course 'Technical writing and presentation'. In the second week of the course, students were given the pre-test instrument which was developed for measuring students' understanding of program outcomes for this study. After performing project activities using rubrics, students were encouraged to complete the post-test instrument and the reaction questionnaire during the ninth week. The data were analyzed by using SPSS 14.0 and Microsoft Excel. The research findings are as follows. First, to promote and evaluate program learning outcomes appropriately, performance assessment-based on rubircs should be implemented. Second, in the reaction questionnaire about the rubircs, students answered that using rubircs for performing the project was very useful for understanding the performance procedures and assessment criteria. Third, the mean of understanding of program outcomes of students in post-test was significantly increased than in the pre-test(p<.0001). From the findings, performance assessment and rubrics should be used as evaluation tools at course levels in terms of promoting program learning outcomes for engineering education.

간호중재분류 (NIC)에 근거한 부인과 간호단위의 간호중재 분석 (Analysis of Nursing Interventions Performed by Gynecological Nursing Unit Nurses Using the Nursing Interventions Classification)

  • 홍성정;이성희;김화선
    • 여성건강간호학회지
    • /
    • 제17권3호
    • /
    • pp.275-284
    • /
    • 2011
  • Purpose: The purpose of this study was to identify nursing intervention performed by nurses on gynecological nursing units. Methods: The instrument in this study is based on the fifth edition of Nursing Interventions Classification (NIC) (2008). Data was collected by Electronic Medical record from August, 2010 to October, 2010 at one hospital and analyzed by using frequencies in the Microsoft Excel 2010 program. Results: Of a total of 82 NIC, domains of the nursing interventions showed higher percentages for physiological: basic (36.3%) and physiological: complex (34.5%). The classes of nursing interventions showed higher percentage for health system medication (12.1%), perioperative care (10.0%), and drug management (8.6%). The most frequently used top interventions were Discharge Planning. The thirty least used interventions was environmental management. Top thirty most frequently used interventions belonged to the domain of physiological: basic (37.9%), physiological: complex (31.1%), and behavioral (5.4%). Conclusion: These findings will help in the establishment of a standardized language for gynecological nursing units and enhance the quality of nursing care.

Challenges of Transport Sector in India: A Dyadic Perspective

  • Potluri, Rajasekhara Mouly;Tejaswi, Satagopam Padma
    • The Journal of Asian Finance, Economics and Business
    • /
    • 제5권3호
    • /
    • pp.95-102
    • /
    • 2018
  • The objective of this research is to explore the diverse challenges faced by the customer as well transport providers through the selected modes of transportation of the second most populous country in the world - India. Two separate well-structured questionnaires administered to garner the opinions on different challenges. A random sample of 100 equally selected from the customers of 3 modes of transportation along with 30 transport providers. The collected data was analyzed in Microsoft Excel and R Studio platforms using Percentile Rank Tool and R Programming Language for Chi-square test respectively. Traffic congestion coupled with parking is the major problem in case of roadways while Safety and cleanliness in railways are the first amongst the problems to reckon with. High fares and lack of trained employees are the biggest challenges faced by aviation industry. The research is concentrated only in the states of Andhra Pradesh and Telangana in India with most widely used three modes of transportation viz., Road, Rail and Airways. This research paper is first of its kind which has collected the opinions of both customers as well transport providers on the problems faced. This research proffers information about the challenges faced by the customers which there will be an enormous possibility to review their strategies and plans.