• Title/Summary/Keyword: Spread sheet

Search Result 50, Processing Time 0.026 seconds

A Spread Sheet Model for a Long Range Water Supply Planning (장기 용수 공급계획 수립을 위한 스프레드 쉬트 모델)

  • 김승권
    • Proceedings of the Korea Water Resources Association Conference
    • /
    • 1992.07a
    • /
    • pp.479-489
    • /
    • 1992
  • A mathematical model for a long range water supply planning is develoted as a dynamic capacitated facility location problem, in which operation costs and two types of fixed costs are considered. The fixed costs are for water supply systems such as dams and reservoirs and for water conveyance systems of waterways or conduits from each water supply points. A Spreadsheet model is developed to support the efficiency of user interface and to implement a heuristic solution procedure. The proposed solution procedure utilizes SOLVER tool and it has been applied to a system with fictitious data but with reality and applicability in mind. As a result of the mathematical analysis, not only the most economic construction timings of surface water supply facilities and distribution systems but also the most economical water supply operating patterns are identified.

  • PDF

Analysis on Printing Advertisements Appearing Monthly Magazines for Korean Women (여성잡지광고의 레이아웃요소와 제품생명주기에 관한 연구)

  • Lee, Kwang-Sook
    • Journal of the Korean Graphic Arts Communication Society
    • /
    • v.20 no.2
    • /
    • pp.107-118
    • /
    • 2002
  • Two-page spread sheet advertising appearing on monthly women's magazine were selected and analyzed for this study. All 299 advertisements were sampled from 5 kinds of women's magazines published from January to June in 2002. The results shows that; 1) all elements of layout in advertisements are significantly related to product life cycle; 2) Similarity of layout type proposed to differentiate layout from competitor's advertisements; 3) Realistic picture of products using high technological equipments and skill occupied most of ad space. It proposed the possibility of varied illustration type; finally, Using foreign models both imported products and domestic products are increased. It shows that the level of westernized insight of current consumer.

  • PDF

A Fundamental Study on the Comparison of As-Planned with As-Built of Free-form Building Skins Using Laser Scanning Technology (Laser Scanning 기술을 이용한 비정형 건축외피의 As-Planned와 As-Built 비교에 관한 기초적 연구)

  • Kwen, Soon-Ho;Shim, Hyoun-Woo;Jang, Hyoun-Seung;Ock, Jong-Ho
    • Korean Journal of Computational Design and Engineering
    • /
    • v.16 no.2
    • /
    • pp.126-136
    • /
    • 2011
  • The existing approaches to freeform building construction cause many problems. However, recent BIM technique development based on parametric modeling method and improvement of freeform materials manufacturing technology using IT technology encouraged many advanced countries to try experimental projects. Thus, laser scanning technique is in the limelight as a new alternative in the field of freeform building construction and inspection. This study selected a domestic small freeform building and practiced laser scanning and as-planned modeling by using Reverse Engineering. Then each deviation was comparatively analyzed through figures which extracted data by numerically analyzing the newly modeled as-built and Excel spread sheet. Through the process, limits and follow-up research subjects are discussed as well.

A Study of Smoke Spread and Flow in a Long Corridor (복도에서의 연기 확산 및 유동에 관한 연구)

  • 김충익;유홍선;김명배;한용식;김진곤;윤명오;김상욱
    • Proceedings of the Korea Institute of Fire Science and Engineering Conference
    • /
    • 1998.11a
    • /
    • pp.29-39
    • /
    • 1998
  • 복도는 사무실용 건물, 호텔 등 공중이용 건물에서 중요한 피난경로의 일부이다. 화재로 복도에 연기가 확산되면 그 온도, 연층의 높이, 유해물질의 농도 등에 따라 피난에 심각한 장애를 가져올 수 있다. 본 연구는 이러한 복도에서의 연기의 확산 및 유동에 관하여 연구하기 위하여 길이 40m의 복도에서 pool fire로부터의 연기 유동에 관한 실제크기의 실험과 수치해석을 수행하였다. 화재실과 그에 접해있는 긴 복도가 있는 실험장치에 직경 15, 20, 30cm의 가솔린 pool을 화재실 중앙에서 점화 시켰다. 연기의 온도 및 이동을 측정하기 위해 전장 중앙선을 따라 열전대를 설치하였고 연층의 두께를 측정하기 위하여 수직방향으로 세곳에 열전대가 부착된 수직봉을 설치하였다. 아르곤 레이저 sheet 과 비디오 카메라를 이용해 연기의 유동을 가시화 하였다.

  • PDF

Development of a Data Analysis Program Using a Data Analysis Competition for Primary School Students (초등학생을 위한 데이터 분석대회를 활용한 데이터 분석 프로그램 개발)

  • HakNeung Go;JaeRi Jeong;Youngjun Lee
    • Proceedings of the Korean Society of Computer Information Conference
    • /
    • 2024.01a
    • /
    • pp.471-472
    • /
    • 2024
  • 본 논문에서는 초등학생을 위한 데이터 분석 대회를 활용한 데이터 분석 프로그램을 개발하였다. 데이터 분석 프로그램은 ADDIE 모형에 개발하였다. 분석 단계에서 G초등학교 학생들의 데이터 분석 도구인 스프레드 시트를 학습한 경험이 적고 배우고자 하는 동기가 없었다. 하지만 교육과정에서 공학도구로 활용하도록 제시되어 있다. 이를 바탕으로 디자인 학생들이 스프레드 시트를 학습할 수 있는 프로그램과 이를 실습할 수 있는 데이터 분석 대회를 디자인 하였다. 개발 단계에서는 LMS를 활용하여 학생들에게 학습을 위한 데이터를 제공하고 학습하며, 데이터 분석 대회에서는 학습한 데이터와 문제만 제공하여 대회에 참여하면서 실습할 수 있는 기회를 제공하였다. 평가 도구로는 데이터 리터러시 평가 도구를 선정하였다.

  • PDF

An Algorithim for Converting 2D Face Image into 3D Model (얼굴 2D 이미지의 3D 모델 변환 알고리즘)

  • Choi, Tae-Jun;Lee, Hee-Man
    • Journal of the Korea Society of Computer and Information
    • /
    • v.20 no.4
    • /
    • pp.41-48
    • /
    • 2015
  • Recently, the spread of 3D printers has been increasing the demand for 3D models. However, the creation of 3D models should have a trained specialist using specialized softwares. This paper is about an algorithm to produce a 3D model from a single sheet of two-dimensional front face photograph, so that ordinary people can easily create 3D models. The background and the foreground are separated from a photo and predetermined constant number vertices are placed on the seperated foreground 2D image at a same interval. The arranged vertex location are extended in three dimensions by using the gray level of the pixel on the vertex and the characteristics of eyebrows and nose of the nomal human face. The separating method of the foreground and the background uses the edge information of the silhouette. The AdaBoost algorithm using the Haar-like feature is also employed to find the location of the eyes and nose. The 3D models obtained by using this algorithm are good enough to use for 3D printing even though some manual treatment might be required a little bit. The algorithm will be useful for providing 3D contents in conjunction with the spread of 3D printers.

Design of a Stainless Steel Insert for Mechanical Joining of Long Fiber-reinforced Composite Structures (장섬유강화 복합재료 구조물의 기계적 접합을 위한 스테인레스 강 인서트 설계)

  • Lee, Sung-Woo;Chang, Seung-Hwan
    • Composites Research
    • /
    • v.31 no.4
    • /
    • pp.139-144
    • /
    • 2018
  • Long Fiber-reinforced composites have advantages of excellent production efficiency and formability of complex shapes compared to conventional continuous fiber reinforced composite materials. However, if we need to make complicated composite shapes or to assemble parts made of different materials, a variety of joining methods are needed. In general, long fiber prepreg sheet (LFPS) contains mold release agent to facilitate demolding after thermoforming. Therefore, mechanical fastening is required in addition to the adhesive bonding to get proper joining strength. In this study, we proposed a stainless steel insert for co-cure bonding which cures LFPS and bonds the stainless steel insert through thermoforming process. The wing of the insert which is spread during the thermoforming process induces adhesion and mechanical wedging effect and serves as a hook to resist the pulling force. The burn-out method was used to confirm the unfolded state of the stainless steel insert wings inserted into the composite material. The static pull-out test was performed to quantitatively evaluate the joining strength. From these experimental results, the condition which guarantees the most appropriate joining strength was derived.

Sneak Peek into Tobacco Habits and Associated Insidious Oral Lesions in an Odisha Sample Population

  • Das, Shibani;Shenoy, Sadhana
    • Asian Pacific Journal of Cancer Prevention
    • /
    • v.16 no.16
    • /
    • pp.7007-7009
    • /
    • 2015
  • Background: Tobacco use in various forms, including with Areca nut, causes several potentially malignant disorders. Many lesions may transform into oral squamous cell carcinoma. Although patients may be aware of the hazards of tobacco habits, the lesions by themselves are insidious in nature resulting in failure of patients to present to general dentists/specialists at early stages. Our aim was to study the types of habits prevalent in the region of Rourkela in Orissa and to assess the insidious nature of the lesions associated with these habits. Not many studies have been done from this part of India. Materials and Methods: A camp was conducted for habitual users of tobacco and its products, Areca nut and other mixed habit users. A thorough history was taken of the type, duration and frequency of habits, symptoms of patients along with clinical examination by a single examiner. The data was entered in detail into an excel sheet and analysed. Results: 54.7% had lesions and 60.9 % of them were asymptomatic and rest had mild burning sensation while eating. There was a very low awareness of the presence of lesions among the patients. Conclusions: There is a need to spread the awareness of the ill effects of the tobacco and other associated habits far and wide and more importantly educate the general public on the appearance of associated lesions as these are almost always insidious in nature. The patients can self-examine, detect lesions early when present and approach the dentist at the earliest opportunity.

The Automatical Process Map Generation Using Network Representation In Radiopharmaceutical Synthesis (네트워크 모델링을 통한 방사성의약품 합성 프로세스 맵 자동생성 시스템)

  • Lee, Cheol-Soo;Heo, Eun-Young;Kim, Jong-Min;Kim, Dong-Soo
    • IE interfaces
    • /
    • v.24 no.2
    • /
    • pp.156-163
    • /
    • 2011
  • The radiopharmaceutical synthesis for PET (positron emission tomography) is composed of chemical reactions using automated synthetical equipment. Due to the radioactive material, the automated equipment is being frequently developed to replace human operators who conduct dangerous, repetitive and dexterous operations. As to operation, the manipulating program is commonly coded using the spread sheet while the whole actuators are mapped in every step. The process map (program) is changed according to such parameters as temperature of reactor, keeping time, mixture sequence and amount of reagent. In cases of customizing the automated synthetical equipment or developing the new radiopharmaceuticals, lots of experiments should be conducted and the programming mistake is not allowed as it can lead abnormal control of the equipment to leak the radioactive materials. The exact process map has depended on trial and error manner. Thus, this study developed the methodology to tabulate the synthetical process to convert the process map automatically while the synthetical module formation is represented by a network model. The proposed method is validated using the actual radiopharmaceutical synthetical procedure.

Development of A Validation System For Automatic Radiopharmaceutical Synthesis Process Using Network Modeling (방사성의약품 합성 프로세스 검증을 위한 네트워크 모델링)

  • Lee, Cheol-Soo;Heo, Eun-Young;Kim, Jong-Min;Kim, Dong-Soo
    • IE interfaces
    • /
    • v.24 no.3
    • /
    • pp.187-195
    • /
    • 2011
  • The automatic radiopharmaceutical module consists of several 2-way valves, couple of syringes, gas supply unit, heating(cooling) unit and sensors to control the chemical reagents as well as to help the chemical reaction. In order to control the actuators of radiopharmaceutical module, the process is tabulated using spread sheet as like excel. Unlike the common program, a trivial error is too critical to allowed in the process because the error can lead to leak the radioactive reagent and to cause the synthesis equipment failure during synthesizing. Hence, the synthesis process has been validated using graphic simulation while the operator checks the whole process visually and undergoes trial and error. The verification of the synthesis process takes a long time and has a difficulty in finding the error. This study presents a methodology to verify the process algebraically while the radiopharmaceutical module is converted to the network model. The proposed method is validated using actual synthesis process.