• Title/Summary/Keyword: Spread sheet

Search Result 50, Processing Time 0.032 seconds

Development of Submerged Land Compensation Management Geographic Information System (수몰지구 보상관리 지리정보시스템 구축에 관한 연구)

  • Sim, Jeung-Min;Lee, Chang-Kyung
    • Journal of Korean Society for Geospatial Information Science
    • /
    • v.13 no.2 s.32
    • /
    • pp.29-37
    • /
    • 2005
  • The compensation data for submerged land have been filed in the form of document or managed with spread sheet like Excell up to now. In the case of dam or highway construction, huge compensation data for the submerged or included land have been managed inefficiently by the administrative manpower. Moreover, where and how to keep the enormous data becomes big problems. In response to the requirements, an submerged land compensation management system based on the location and property information of parcels was developed. The compensation management system has many functions including site searching for compensation, compensation money computing, and compensation data managing. It is expected that the submerged land compensation management system creates various information effects.

  • PDF

A Study on Rotary Weeding Blade Installation Angle for Reduction of Hand Vibration in Working Type Cultivator

  • Kwon, Tae Hyeong;Kim, Joonyong;Lee, Chungu;Kang, Tae Gyoung;Lee, Byeong-Mo;Rhee, Joong-Yong
    • Journal of Biosystems Engineering
    • /
    • v.39 no.1
    • /
    • pp.11-20
    • /
    • 2014
  • Purpose: Walking type cultivator used for weeding generated excessive handle vibration as well as bouncing motion depending on the weeding speed. This research was conducted to define a design factor of the rotary weeding blades for reducing soil reaction forces as well as hand vibration. Methods: The motion and forces acting on the rotary blades were reviewed to find out the most influencing parameter on hand vibration. The installation angle (IA) of the blade was selected and analyzed to determine the condition of no reaction force less. For removing the unnecessary upward soil reaction, the design factor theory of weeding blade was suggested based on geometrics and dynamics. For evaluation of design factor theory, the experiment in situ was performed base on ISO 5349:1. The vibration $a_{hv}$ and theoretical value $X_{MF}$ were compared with two groups that one was positive group ($X_{MF}$ > 0) and the other was negative group ($X_{MF}$ < 0). Results: $X_{MF}$ was derived from rotational velocity, forward velocity, disk diameter, weeding depth, blade's width and IA of blade. Two groups had significant difference (p < 0.05). In aspect of the group mean total exposure duration, positive group was 17.53% bigger than negative group. When disk radius 100, 150 and 200 mm, minimum IAs were $4{\sim}27^{\circ}$, $3{\sim}15^{\circ}$ and $2{\sim}10^{\circ}$, respectively. A spread sheet program which calculated XMF was developed by Excel 2013. Conclusions: According to this result, minimum IA of weeding blade for soil reaction reduction could be obtained. For reduction hand-arm vibration and power consumption, minimum IA is needed.

Computer Simulation of Extrusion and Die Design for the Extrusion of Butyl Rubber (부틸고무의 압출을 위한 압출해석 및 다이설계)

  • Choi, T.G.;Lee, H.J.;Lyu, M.Y.
    • Elastomers and Composites
    • /
    • v.49 no.4
    • /
    • pp.275-283
    • /
    • 2014
  • Butyl rubber is used as an adhesive and it is mainly used in the form of sheets. The goal of this study is to design an extrusion die for the butyl rubber sheets using computer simulation. The extrusion die for the butylrubber sheets consists of manifold area and land area. In the manifold area, flows are spread from the entrance of the extrusion die to the land area. In the land area, flows become stable to the flow direction and uniform sheet can be obtained. Island area is being installed in the land area to get uniform flow. Four parameters, angle of manifold, length of manifold, length of land and island, were examined in the computer simulation. The optimum geometry of the extrusion die is derived which has a uniform flow in the width direction of the die.

LIDMOD3 Development for Design and Evaluation of Low Impact Development (저영향개발기법 설계 및 평가를 위한 LIDMOD3 개발)

  • Jeon, Ji-Hong;Seo, Seong-Cheol
    • Journal of Korean Society on Water Environment
    • /
    • v.34 no.4
    • /
    • pp.382-390
    • /
    • 2018
  • In this study, the LIDMOD3 was developed to design and evaluate low impact development (LIDMOD). In the same fashion, the LIDMOD3 employs a curve number (NRCS-CN) method to estimate the surface runoff, infiltration and event mean concentration as applicable to pollutant loads which are based on a daily time step. In these terms, the LIDMOD3 can consider a hydrologic soil group for each land use type LID-BMP, and the applied removal efficiency of the surface runoff and pollutant loads by virtue of the stored capacity, which was calculated by analyzing the recorded water balance. As a result of Model development, the LIDMOD3 is based on an Excel spread sheet and consists of 8 sheets of information data, including: General information, Annual precipitation, Land use, Drainage area, LID-BMPs, Cals-cap, Parameters, and the Results. In addition, the LIDMOD3 can estimate the annual hydrology and annual pollutant loads including surface runoff and infiltration, the LID efficiency of the estimated surface runoff for a design rainfall event, and an analysis of the peak flow and time to peak using a unit hydrolograph for pre-development, post-development without LID, and as calculated with LID. As a result of the model application as applied to an apartment, the LIDMOD3 can estimate LID-BMPs considering a well spatical distributed hydroloic soil group as realized on land use and with the LID-BMPs. Essentially, the LIDMOD3 is a screen level and simple model which is easy to use because it is an Excel based model, as are most parameters in the database. This system can be expected to be widely used at the LID site to collect data within various programmable model parameters for the processing of a detail LID model simulation.

Super-resolution Microscopy with Adaptive Optics for Volumetric Imaging

  • Park, Sangjun;Min, Cheol Hong;Han, Seokyoung;Choi, Eunjin;Cho, Kyung-Ok;Jang, Hyun-Jong;Kim, Moonseok
    • Current Optics and Photonics
    • /
    • v.6 no.6
    • /
    • pp.550-564
    • /
    • 2022
  • Optical microscopy is a useful tool for study in the biological sciences. With an optical microscope, we can observe the micro world of life such as tissues, cells, and proteins. A fluorescent dye or a fluorescent protein provides an opportunity to mark a specific target in the crowd of biological samples, so that an image of a specific target can be observed by an optical microscope. The optical microscope, however, is constrained in resolution due to diffraction limit. Super-resolution microscopy made a breakthrough with this diffraction limit. Using a super-resolution microscope, many biomolecules are observed beyond the diffraction limit in cells. In the case of volumetric imaging, the super-resolution techniques are only applied to a limited area due to long imaging time, multiple scattering of photons, and sample-induced aberration in deep tissue. In this article, we review recent advances in super-resolution microscopy for volumetric imaging. The super-resolution techniques have been integrated with various modalities, such as a line-scan confocal microscope, a spinning disk confocal microscope, a light sheet microscope, and point spread function engineering. Super-resolution microscopy combined with adaptive optics by compensating for wave distortions is a promising method for deep tissue imaging and biomedical applications.

3D-printed Face Shields for Healthcare Professionals Battling COVID-19 Pandemic

  • Kim, Gyeong-Man;Assefa, Dawit;Kang, Joon Wun;Gebreyouhannes, Esayas
    • Journal of Appropriate Technology
    • /
    • v.6 no.2
    • /
    • pp.226-237
    • /
    • 2020
  • As the number of reported COVID-19 cases rises around the world, regions affected by the virus are taking serious measures to contain its spread. Face shields are one of the highest-need personal protective equipment (PPE) during COVID-19 pandemic. Beyond traditional face masks, as known cases of the coronavirus soar, currently there is a significant shortage of face shields around the world. In response, the protective face shields were designed and fabricated with open-source 3D modelling software and 3D printing technology, respectively. Our face shield consisted of two parts only; a reusable 3D printed headband and a visor made of transparent plastic sheet, as barrier. The resulting 3D printed face shields are affordable, lightweight, one-size-fits-most and ready-to-wear with minimal assemblies, and go on easily over glass, goggle and face mask. To ensure being donated to the healthcare professionals without risk infected by any pathogens, the 3D printed face shields were successfully be disinfected with ultraviolet germicidal irradiation (UVGI dosage of 1000 mJ/cm2) and 70% alcohol. For routine disinfection a UVGI chamber was designed and optimized to provide uniform UV-C illumination with an appreciated fluence for complete decontamination. More than 1,000 face shields were produced already and donated to the special hospitals for COVID-19 patients, quarantines, government and medical agencies in Ethiopia as well as in East-African countries. With certainty, our intention goes beyond the hospitals and other first responders, but not limited for all those who have to stay in the service or be in contact with many other people in the time of COVID-19 pandemic.

A Method for Information Management of Defects in Bridge Superstructure Using BIM-COBie (BIM-COBie를 활용한 교량 상부구조의 손상정보 관리 방법)

  • Lee, Sangho;Lee, Jung-Bin;Tak, Ho-Kyun;Lee, Sang-Ho
    • KSCE Journal of Civil and Environmental Engineering Research
    • /
    • v.43 no.2
    • /
    • pp.165-173
    • /
    • 2023
  • The data management and the evaluation of defects in the bridge are generally conducted based on inspection and diagnosis data, including the exterior damage map and defect quantity table prepared by periodic inspection. Since most of these data are written in 2D-based documents and are difficult to digitize in a standardized manner, it is challenging to utilize them beyond the defined functionality. This study proposed methods to efficiently build a BIM (Building Information Modeling)-based bridge damage model from raw data of inspection report and to manage and utilize the damage information linking to bridge model through the spread sheet data generated by COBie (Construction Operations Building Information Exchange). In addition, a method to conduct the condition assessment of defects in bridge was proposed based on an automatic evaluation process using digitized bridge member and damage information. The proposed methods were tested using superstructure of PSC-I girder concrete bridge, and the efficiency and effectiveness of the methods were verified.

A Study of the Effect of Acoustic Noise Attenuator on Auditory Functional MRI (소음 감쇠기를 이용한 청각의 뇌기능 자기공명영상)

  • Kim, S.H.;Kim, I.S.;Lee, J.J.;Park, J.A.;Lee, Y.J.;Yeo, J.R.;Bae, S.J.;Lee, S.H.;Chang, Y.
    • Investigative Magnetic Resonance Imaging
    • /
    • v.9 no.2
    • /
    • pp.134-139
    • /
    • 2005
  • Purpose : To evaluate the usefulness of acoustic noise attenuator on auditory fMRI examination. Materials and methods : The acoustic noise attenuator consists of mask, earmuff and silicon earplug. The soft polyurethane sheet and polyurethane form , which has a good soundproof characteristic were used for mask and earmuff. Auditory fMRI experiments of 500 Hz pure tone stimulation were performed in three different cases; first all of mask, earmuff and earplug, secondly earmuff and earplug only and finally without attenuator in 4 normal hearing volunteers. For data acquisition, BOLD MR imaging technique was employed at a 1.5T MR scanner equipped with high performance gradient system. The raw data were analyzed using a SPM-99 analysis software and the activation maps were obtained. Results : In case of all items of acoustic attenuator used, the results revealed that activation was focused on primary auditory area. When only earmuff and earplug were used, the results showed that the activation spread over primary auditory and secondary associative areas. Last, when no device used, only weak activation was observed on the right auditory cortex. Conclusion : It is expected that the acoustic noise attenuator, which consists of earplugs, earmuffs and mask, is a very useful device in auditory fMRI study.

  • PDF

Investigation of H model blended e-learning technique in enhanced effectiveness of class learning (대학 강의실 수업의 효과성 향상을 위한 H형 블렌디드 이러닝 적용 효과 분석)

  • Choi, Byongsu;Yoo, Sang-Mi
    • The Journal of Korean Association of Computer Education
    • /
    • v.16 no.3
    • /
    • pp.49-60
    • /
    • 2013
  • This study is aimed to investigate that the blended e-learning could enhance the effectiveness compared to the conventional lecture performed in classroom. At first, both the CbE(Class based E-learning) and the EbC(E-learning based Class) mode have been generated in blended e-learning operation method following the process which analyze the various studies of interest. In addition, the instruction structures of Z Type(Zigzag model) and H-Type(Ladder model) were established as proposed model. The H-Blended e-learning based on CbE mode was introduced in the Excel Spread Sheet subject which held in A University to achieve the goal of this study. Learners were categorized and belonged to either the group 1(over 50% of attendance in cyber lecture) or the group 2(the rest of them). The data analysis was performed with $x^2$-test, t -test to compare the achievement of study between groups. The t -test result showed that the academic achievement in learning with group 1 was statistically significant than the learner in group 2. The effectiveness of the blended e-learning has been proved as the logistic regression analysis showed that the rate of the attendance in the cyber lecture functioned as indicator that enable to predict the acceptance.

  • PDF

Factors Affecting the Morbidity Related to Respiratory Dieseases in Urban Korea (한국 도시의 만성호흡기 질환 이환율에 영향을 주는 요인)

  • Han, Sung-Hyun;Park, Jae-Sung;Seo, Seung-Hee;Yoon, Jee-Eun;Jee, Sun-Ha
    • Korea journal of population studies
    • /
    • v.28 no.2
    • /
    • pp.205-217
    • /
    • 2005
  • Purpose: To evaluate the factors affecting hospital utilization for respiratory diseases by ecological study design and GIS tool. To raise the social concern for respiratory disease by the result. Methods: Hospital admission data supported by national health insurance cooperation were transformed to spread sheet data format and combined with air monitoring dataset. Air pollution data were collected from the annual report of air monitoring published by Korea Ministry of Environment. Socioeconomic statistics including population density, age distribution, forest ratio etc.. were filed using Korea National Statistical Office database. Multiple linear regression analysis was performed to evaluate the factors affecting hospital utilization for respiratory diseases. Analytical unit was 52 cities. Results: The factors affecting hospital utilization for respiratory diseases were the proportion of population 60 years and over, seaside city, $O_3$ level, smoking rate. Conclusions: However, outdoor pollutants monitoring data and smoking rate have weakness in reflecting individual exposure. Further research is required to propose more illustrative means to evaluate causal relationship between air pollution and respiratory health effect factors.