• Title/Summary/Keyword: EXCEL

Search Result 833, Processing Time 0.026 seconds

Overview of the Leading Environmental Specimen Banks in the World and Future Challenges of the National Environmental Specimen Bank in Korea (선진국 환경시료은행의 특성 분석을 통한 국가환경시료은행의 발전방안)

  • Lee, Jong-Chun;Kim, Myung-Jin
    • Economic and Environmental Geology
    • /
    • v.45 no.2
    • /
    • pp.169-180
    • /
    • 2012
  • The ESBs (Environmental Specimen Banks) have monitoring functions for the contemporary environmental qualities and also offer the future generation tangible information on the past environment by preserving the specimens. This entails the sampling of the representative specimen for each distinctive ecosystem, which is performed under a strict and stipulated procedure and a condition that does not allow any change in the component so that a retrospective analysis can be readily done even in the distant future. It has been more than 30 years that some developing countries started collecting a broad spectrum of specimens to vindicate the effectiveness of an environmental policy and to monitor the long-term variations of background concentrations of environmental pollutants. Though being late, the National Institute of Environmental Research (NIER), Korea, has successfully launched the National Environmental Specimen Bank (NESB) in 2009 equipped with its state-of-the-art automated cryogenic tanks. Since then, the researchers at the NESB have been doing their best to excel the existing ESBs around the world by learning and improving the expertise. To do so, they conducted a pilot study for developing and testing their own Standard Operating Procedure (SOP) based on the analysis of the examples of the other ESBs. The problems from the pilot study had been reviewed to improve the SOP to meet the requirements for an ESB, that is to say, preserving representative environmental specimens in cryogenic condition and enhancing the analytical method. Furthermore, they also need to prepare themselves to address the future challenges by providing some additional functions, which makes it distinguishable from the other ESBs. If successful, this will be a step further to be recognized as a full-fledged member of the ESB society of the world.

Heating and Cooling Energy Demand Evaluating of Standard Houses According to Layer Component of Masonry, Concrete and Wood Frame Using PHPP (PHPP를 활용한 조적, 콘크리트, 목조 레이어 구성별 표준주택 냉·난방 에너지 요구량 평가)

  • Kang, Yujin;Lee, Junhee;Lee, Hwayoung;Kim, Sumin
    • Journal of the Korean Wood Science and Technology
    • /
    • v.45 no.1
    • /
    • pp.1-11
    • /
    • 2017
  • A lot of the energy are consumed on heating and cooling in buildings. The buildings need to minimize the heating and cooling loads for $CO_2$ emissions and energy consumption reduction. In recently, also demand of detached houses were increase while the residential culture was changed. The structure of the domestic detached houses can be divided into masonry, concrete, wood frame houses. Therefore, in this study, the heating and cooling load and energy demand were analyzed on the equal area detached house consisting of three structural methods (Masonry, Concrete, Wood frame). Layer of wall, roof, and floor were composited by structure. Thermal transmittance (U-value) of each layer was using the PHPP calculation for considering stud, such as the wood frame wall. In addition, the case of without considering for studs in wood frame wall (Non-studs) was analyzed in order to compare the difference between studs or not. Analysis was performed using self-developed heating and cooling load calculation program (CHLC) based excel and ECO2. The results of cooling and heating load and energy demand showed the highest values in the wood frame structure, and the concrete structure were confirmed to maintain a high value secondly. Two structure were determined to be disadvantageous on the energy consumption. Consequently, the masonry structure have an advantage over the other structure under the identical conditions. It was determined that if the except for thermal bridges due to the studs in the wood frame structure, it can be reduced the energy consumption.

Construction and Application of Network Design System for Optimal Water Quality Monitoring in Reservoir (저수지 최적수질측정망 구축시스템 개발 및 적용)

  • Lee, Yo-Sang;Kwon, Se-Hyug;Lee, Sang-Uk;Ban, Yang-Jin
    • Journal of Korea Water Resources Association
    • /
    • v.44 no.4
    • /
    • pp.295-304
    • /
    • 2011
  • For effective water quality management, it is necessary to secure reliable water quality information. There are many variables that need to be included in a comprehensive practical monitoring network : representative sampling locations, suitable sampling frequencies, water quality variable selection, and budgetary and logistical constraints are examples, especially sampling location is considered to be the most important issues. Until now, monitoring network design for water quality management was set according to the qualitative judgments, which is a problem of representativeness. In this paper, we propose network design system for optimal water quality monitoring using the scientific statistical techniques. Network design system is made based on the SAS program of version 9.2 and configured with simple input system and user friendly outputs considering the convenience of users. It applies to Excel data format for ease to use and all data of sampling location is distinguished to sheet base. In this system, time plots, dendrogram, and scatter plots are shown as follows: Time plots of water quality variables are graphed for identifying variables to classify sampling locations significantly. Similarities of sampling locations are calculated using euclidean distances of principal component variables and dimension coordinate of multidimensional scaling method are calculated and dendrogram by clustering analysis is represented and used for users to choose an appropriate number of clusters. Scatter plots of principle component variables are shown for clustering information with sampling locations and representative location.

A Study on the Necessity of an Age Limitation in Screening Mammography (검진 기관에서의 선별 유방촬영술 시행에 따른 연령 제한의 필요성에 대한 연구)

  • Yun, Ha-Yan;Lee, Choon-Mi;Ahn, Ui-Kyeong;Kim, Yong-Hwan
    • Korean Journal of Digital Imaging in Medicine
    • /
    • v.12 no.1
    • /
    • pp.33-41
    • /
    • 2010
  • National Cancer Screening Project and Korean Society of Breast Imaging recommend that breast cancer screening should be performed on those aged 40 and above. Nevertheless, this recommendation is usually ignored by a number of medical institutions. The purpose of this study is to emphasize the necessity of an age limitation in screening mammography. Ten institutions were randomly selected and telephone inquiries about patients' age limitation and internal guidelines were set up. The 3,214 women, who underwent screening mammography through 'GE Senography 2000D' in each hospital, were classified into five groups according to age(from 20s to 40s, at intervals of 5). And then, collected data was analyzed by a radiologist in accordance with ACR-BIRADS(American College of Radiology Breast Imaging Reporting and Data System), through which breast parenchymal density and the results of analysis were categorized in order to predict the sensitivity of mammography. Information about craniocaudal-view mammograms was automatically produced by use of GE Senography 2000D, and the average glandular dose was retrospectively analyzed through the program 'Excel 2007.' Two institutions did not set the age limitation. Other seven institutions internally allowed those who wanted to receive mammography regardless of age. Approximately 99% of those aged 20 to 29 were judged as having the dense breast. In those aged 35 to 39, breast parenchymal density tended to be lower, but the fatty breast to increase. In the case of 'category-zero' that does not need additional tests, the rate of 'heterogeneously dense' and 'extremely dense' reached to 83.1% and 15.1% respectively. Regarding dense breasts, there was no sufficient information for image reading. The glandular dose, applied to 3,214, was 1.47mGy on the average. In those aged 20 to 24 who are sensitive to radiation, the average glandular dose indicated 1.59mGy. Those aged 35 and above showed the lowest value, 1.43mGy. In those aged 35 to 39, the breast tended to change from denseness to fattiness. The average glandular dose was lowest in those aged 35 and above, which suggests that screening mammography should be periodically performed on those aged 35 and above in order that breast cancer may be early detected. On the other hand, in those aged less than 35, it is difficult to analyze mammograms due to the high density of breast parenchyma, and also retakes become frequent. In particular, subjects may be exposed to excessive doses. Accordingly, it should be substituted by breast self-examination or clinical breast examination. In case of need, it is advisable to perform ultrasonography.

  • PDF

Prevalence and risk factors of subclinical bovine mastitis in some dairy farms of Sylhet district of Bangladesh

  • Kahir, Md. Abdul;Islam, Md. Mazharul;Rahman, A.K.M. Anisur;Nahar, A.;Rahman, Md. Siddiqur;Son, Hee-Jong
    • Korean Journal of Veterinary Service
    • /
    • v.31 no.4
    • /
    • pp.497-504
    • /
    • 2008
  • A cross-sectional study was undertaken to report prevalence and to identify risk factors of subclinical mastitis of dairy cattle in Sylhet district of Bangladesh. Among 325 dairy farms of the district 12 farms(3.7%) were selected conveniently for this study. All the dairy cows of the 12 farms were selected for sample collection. Fresh milk samples from each of the selected dairy cows were collected aseptically in separate sterilized test tube as RF, RH, LF and LH quarter of the udder. Rapid modified White Side Test(WST) was used to detect subclinical mastitis(SCM). Results of WST and data derived from filled in questionnaire were entered in Microsoft Excel 2003 and transferred to $STATA^{(R)}$, version 8.0/Intercooled(Stata Corporation, Texas, USA, 2003). The overall prevalence of SCM and its distribution in different categories of variables in cow and their exact binomial 95% confidence intervals were calculated in $STATA^{(R)}$. Simple bivariable associations among independent variables were investigated by $x^2$ test in $STATA^{(R)}$. Multiple logistic regression analysis with backward elimination method was used to identify risk factors of SCM. To identify significant variation in quarter SCM, linear regression analysis was performed after arcsine transformation of the data. The overall prevalence of SCM found in this study is 54%. Dairy cows with teat lesions had significantly increased SCM(OR=12342, P value=0.000, 95% CI=762, 199798) than others without teat lesions. The Holstein Friesian X Jersey X Sahiwal breed has significantly decreased(OR=0.18, p=0.03, 95% CI 0.04, 0.85) SCM than other breeds. The prevalence of SCM found in this study is in agreement with others. The injury in the teat increases the probability of getting infected with microbes and thereby mastitis. If the prevalence of teat lesion can be decreased the probability of subclinical mastitis will also be decreased. The negatively associated Holstein Friesian X Jersey X Sahiwall breed may help in planning mastitis control program if this finding can be validated by a more powerful case-control or cohort study design.

The Effects of Urban Park and Vegetation on Crime in Seoul and Its Planning Implication to CPTED (CPTED 요소로써 서울시 공원·녹지의 효과와 계획적 함의)

  • Cho, Min-gyun;Park, Chan;Jang, Jeong-in
    • Journal of the Korean Institute of Landscape Architecture
    • /
    • v.46 no.3
    • /
    • pp.27-35
    • /
    • 2018
  • In the mandatory application of the CPTED, only negative parts of urban parks and vegetation were reflected. Therefore, this study tries to present the positive effects of urban parks and vegetation. The purpose of this study is to demonstrate the effects of urban parks and vegetation on crime occurrence and to suggest the planning implications of this to CPTED based on theory related to crime, environmental psychology, and crime occurrence analysis. This study used the crime occurrence data of Seoul, NDVI, population, distance from urban park, floating population, and the like. This study collected data from the Statistics Korea, the local government, and Landsat 8 satellite images provided by the USGS and created data of environmental variables and social variables by district using ArcGIS and statistical program. Literature analysis, correlation analysis, regression analysis, and geographically weighted regression were used to determine the relationship between crime occurrence and environmental variables, and to discuss its implication. It was found that crime occurrence has a relationship with the total population (${\beta}=.663$), the number of amusement facilities (${\beta}=.447$) and the area of a police station jurisdiction (${\beta}=.395$). This confirms that a crime rate is low when the floating population is large (${\beta}=-.241$) and vegetation vitality is high (NDVI, ${\beta}=-.281$). Vegetation vitality (NDVI) is effective in lowering violence through psychological stabilization, strengthening territoriality and improving regional image. The implications for the allocation of urban park and vegetation, program and management plan of urban park and vegetation to reduce crime occurrence have therefore been presented.

A Study on the Establishment & Functional Characteristics of Health Facilities for the Aged in Japan

  • Kim, Tae Il;Yoshida, Tomo Hiko
    • Architectural research
    • /
    • v.8 no.1
    • /
    • pp.1-7
    • /
    • 2006
  • Various housing measures are needed for the rapidly aging society of Korea. In particular, the welfare policy for the elderly has changed towards the community care. Taking this fact into consideration, it is necessary to have the establishment of a system that offers the elderly appropriate welfare services at their appropriate residence (ageing in place) for the effectiveness of the community care. In this aspect, there are a number of implications to Korea to study merits and demerits of the Health Facilities for the Aged (HFA) in Japan. The society of Japan has been rapidly aging since 1970, and Korea is to face the same situation. As for the data of this study, a total of 2,393 facilities (as of November 1999) mentioned in the annual report of the Japanese Ministry of Health, Labor and Welfare were classified based on types of their establishment: (1) free-standing structures (603 facilities); (2) annexes to hospitals (981 facilities); (3) annexes to welfare facilities (511 facilities); and (4) annexes to clinics (298 facilities). Next, 239 facilities were selected through taking a sample of 10 percent from each type of the HFA mentioned above. This was done through the random sampling method with the computer program of MS EXCEL. The Implications of the results of analyses are as follows. First, most of the health facilities were planned with the scale that was larger than the scale of standard special nursing homes in terms of the total floor area. Precise equations that were to obtain precise results of the scale of the HFA and the appropriate number of residents were obtained through the method of the regression analysis. Korea and Japan have similarities in terms of culture, society and family relations; however, the two countries also have differences in terms of the application of laws on the establishment of houses, hospitals, and welfare facilities. As for planning the scale of the HFA, the realities of Korea should be considered. Second, as for the functional aspect of the HFA with a condition of returning home, the place before and after the HFA showed the pattern of 'from a residential place to a residential place' and 'from a hospital to a hospital.' This reveals a close correlation with the types of the HFAs and operational ways of the facilities. Its cause is considered to be the aspect of the operation and management of the HFA rather than the aspect of its function of providing services in association with medical and health facilities. Therefore, when intermediate welfare facilities are considered in Korea, it is strongly advised to consider the problem of annexes to other facilities and efficiency of sharing of the facilities in terms of its operation and management.

Determinants of Advanced Stage at Initial Diagnosis of Breast Cancer in Pakistan: Adverse Tumor Biology vs Delay in Diagnosis

  • Khokher, Samina;Qureshi, Muhammad Usman;Mahmood, Saqib;Sadiq, Sadia
    • Asian Pacific Journal of Cancer Prevention
    • /
    • v.17 no.2
    • /
    • pp.759-765
    • /
    • 2016
  • Background: Breast cancer is the most frequent cancer of women in Pakistan with the majority presenting with stage III or IV lesionsat initial diagnosis. Patient and health system related factors are well known determinants of delay in presentation and diagnosis. Additionally, breast cancer being a heterogeneous disease, the various molecular subtypes featuring different aggressiveness also need to be considered. The present study evaluated the association of stage at initial diagnosis of breast cancer with these two factors in local women at a tertiary level health care facility in Lahore, Pakistan. Materials and Methods: Patient and tumor features were recorded separately during diagnostic workup in Breast Clinics at INMOL and at Services Hospital, Lahore. Data were entered in MS Excel and analyzed by descriptive statistics and Chi-Square test. Results: Among the 261 patients, 64% were staged as late breast cancer (LBC), the mean age was 46.8 with standard deviation of 13 years. Some 92% had invasive ductal carcinoma (IDC), 61% had luminal types (LT) of non-aggressive tumor while 39% had the non-luminal types (NLT) of of HER2-enriched or basal aggressive tumors. While 70% of patients presented within one year of symptomatic disease (early report group "ERG"), 30% reported after a mean delay of 4 years with a standard deviation of 3.75 years. The stage distribution among ERG patients was not statistically different from those reporting late (P=0.123). Statistically larger proportion of patients with NLT presented as LBC as compared to the LT (P =0.034). Among the ERG, statistically different stage distribution of disease was observed for the NLT versus LT (P=0.047). Among those presenting late, this difference was insignificant (P=0.416). Conclusions: Breast cancer is a distinct disease in Pakistan with a high frequency of aggressive molecular types affecting younger women, with the majority presenting as LBC. Association of NLT with higher stage at diagnosis is statistically significant whereas time delay in diagnosis is not. Further research is required to define the risk profile and features in local patients. The burden of LBC can be reduced by promoting breast health awareness and by establishing easily accessible dedicated breast care set ups in the hospitals.

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

  • Choi, Young-A;Lee, Tae-Jung;Kim, Dong-Sool
    • Journal of Korean Society for Atmospheric Environment
    • /
    • v.24 no.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.

Nurse Practitioner Roles and Curriculums in the United States (미국 전문간호사(NP)의 역할과 교육과정에 관한 고찰)

  • Lee Sun-Ock
    • The Journal of Korean Academic Society of Nursing Education
    • /
    • v.5 no.1
    • /
    • pp.97-105
    • /
    • 1999
  • Based on literature, status and role of the NP in America was reviewed. The process of developing NP program in America suggests us many things. In America, nurse practitioners have sustained a mutually beneficial status with their patients for over thirty years. Excel fence in academic education and clinical training will enable nurse practitioners to continue to provide quality health care. The magnitude changes in the health care system of the United States, the challange of providing real access of health care continues. Lack of access to adequate primary care was the driving force in the initial 1965 Federal Involvement in developing the NP role. In 1993 President Bill Clinton's health care reform initiative provided policy support for NPs as primary care providers. The Institute of Medicine explicitly recognized NPs as an integral part of the primary care team. In addition, several national reports recognized NPs as affordable, accessible, high-quality care providers. The recent passage of direct Medicare reimbursement for NPs reflected public policy statements coincided with and likely contributed to a growth spurt in the NP workforce. From 1965 to 1977 NP programs offered traditional primary care clinical tracks(adult, family, woman's health, and pediatrics) for relatively small clusters of students in a variety of institutional settings. From 1978 to 1990 these educational programs were incorporated into graduate schools of nursing. By 1990 the majority of NPs received educational preparation in master's-level nursing programs. A new emphases was placed on postmaster's NP programs designed for master's prepared clinical nurse specialists and nurse managers. he the health care system shifted hospital nursing resources toward community-based care, these master's -level nurses sought additional NP preparation. NP educational programs are defined as the educational structure in which one or more NP clinical tracks are offered. NP clinical tracks, in turn, offer curriculum and supervised clinical experiences that match standards in specific practice areas such as family(FNP), adult(AUP), geriatrics(GNP), pediatrics(PNP), women's health (WHNP), neonatal (NNP), and acute care(ACNP). There were indications that NP practice was expanding into new clinical areas as evidenced by new types of tracks, particularly in acute care and psychiatry. The increase in acute care NP students likely reflects the increased demand from hospitals and other acute care settings. In Korea, change of nurse's role into nurse practitioner's role may have many difficulties. The need of health consumer, policy support of government, approval of medical care team are all essential component. Every nursing personnel make effort to planning the new health care delivery system.

  • PDF