• Title/Summary/Keyword: EXCEL

Search Result 832, Processing Time 0.021 seconds

The study on the shade color change that depends on the kind of zirconia core and the porcelain thickness (지르코니아 코어의 종류와 도재 두께에 따른 색상의 변화)

  • Yeom, Mi-Ok;Lee, Jong-Hyuk;Shin, Soo-Yeon;Sin, Seung-Chul;Cho, Ja-Won
    • Journal of Technologic Dentistry
    • /
    • v.32 no.4
    • /
    • pp.341-350
    • /
    • 2010
  • Purpose: This study focused on achieving desired shades by combining zirconia core with different thickness porcelain in order to make dental prostheses effectively. Methods: White and colored $LAVA^{TM}$ All Ceramic (3M-ESPE, Seefeld, Germany), and Zirkonzahn (Bruneck, Italy) Trans and prettau were used to have Zirconia. LAVATM Ceram (3M-ESPE, Germany) and ICE (Zirkonzahn, Italy) powder were used to have the porcelain. We made quadrilateral specimen of thickness 0.3mm, 0.5mm, 0.7mm and diameter 10 to use zirconia ceramics system of 2 kinds that color tone reappearance way is different and produced total 120 specimens to 4 experimental groups. We used Spectrophotometer to analyze color tone. Data's value getting by dispersal colorimetry period found L*, a*, b* value using Excel program. We used one-way ANOVA to use SPSS WIN 12.0 program. Results: All L*, a*, b* indexes of zirconia core and porcelain veneer in LAVA group and Zirkonzahn group were different. When you combine the white zirconia core of LAVA group with a porcelain veneer, the thickness of the porcelain must be more than 0.5mm to meet the standard target. When all the colored zirconia cores of LAVA group were combined with porcelain veneers, there was no significant difference from the standard target. When the zirconia cores of Zirkonzahn group are combined with porcelain veneers, the thinner thicknesses were closer to the standard tab than thicker thicknesses; however, there was a significant difference in all combinations, with Delta E* value indicating more than 3. Conclusion: When it comes to colored zirconia, which is the most popular, the thicknesses of both a core and a dentin veneer must be more than 0.3mm to get an appropriate shade. There is more possibility to get desirable shades when the thicknesses of a white core are thinner; however, they would be vulnerable to the environment and lose their color. When combine a zirconia core with a dentin veneer, using Zirkonzahn group needs more considerations in order to meet the standard target.

Development of Video Work Manual for Rock-Drill Data In Fire Service (소방에서의 도상훈련 기초자료 영상화작업 매뉴얼 개발)

  • Cho, Jae-Kwan;Park, Hee-Jin;Hwang, Inn;Kwon, Hayrran
    • The Korean Journal of Emergency Medical Services
    • /
    • v.6 no.1
    • /
    • pp.103-128
    • /
    • 2002
  • As a result of trying the various manufacturing methods considering the reality of manpower and equipments with this manual, the following standardized procedures and contents can be suggested. (1) Since tools presenting Rock-Drill data must formalize the order of explanation although explainers are different, it will be valid that it is configured by existing power point method rather than by web document type. Composition of contents are selected on the basis of defence card and survey and then 8 items including initial screen, peripheral conditions, mobilization route, general conditions, use and structure by floor, department of vehicle consideration in activities and end screen are included. (2) Making methods and cautions of data included and used in power point are as follows ; - It was most effective that objects of fire fighting and location of neighboring fire fighting water were expressed by electronic map and drawing of inner building was made by scanning it after paining general architecture drawing(plan by each floor) rather than using drawing tools of EXCEL program or CAD drawing. And it was helpful to simplify contents of architecture drawing to wall, stairs and gate in understanding them. - Photographing of video data should be taken to show available fire fighting facilities in fire, use of planned space and the whole inner structure of each floor from the inside of fire fighting buildings and to display play time between 10 sec. and 1 min, for obstacles to distance from adjacent buildings or passage of special vehicles and fire fighting water from the outside of the building. - File format of video data taken in this way is most suitable to use wmv(window media video) or asf(advanced streaming format) type in consideration of time required for export, screen quality, file capacity and play type in Rock-Drill through network. - Still screen(photo) is more effective to express the department of fire fighting vehicles or other equipments than using video. (3) In configuration work of power point, hyper link was used most and configured to see any part at any situation like web document and then uniformity of presentation order of power point was complemented. (4) In case of sales facilities with the area of $35.557m^2$, the time of 22 hours and 30 minutes for five days was taken with five persons. Therefore, when eight-hour works a day were calculated, the whole process of video work for Rock-Drill can be finished with three day works.

  • PDF

A Study on Activation of Oriental Medicine in Public Health Sector : The role of Oriental Public Health Physicians (한방 공공의료의 활성화에 관한 연구 - 공중보건 한의사의 활동을 중심으로 -)

  • Yi Sang-Gu;Moon Ok-Ryun;Piao Song-Lin;Lee Shin-Jae;Yoon Tae-Ho;Jeong Baek-Geun;Wen Yong
    • Journal of Society of Preventive Korean Medicine
    • /
    • v.4 no.1
    • /
    • pp.1-16
    • /
    • 2000
  • From 1998, Oriental Medical Physicians(OMP) is distributed in Public Health Sector. but long term plan for Oriental Medicine in Public Health is not existed. So, this study is designed for the activation of OMP Subjects in this study were comprised 3 groups of oriental medicine related persons, the group of which are Students of 11 Oriental Medical Schools, Oriental Medical Physicians in Public Health Sector, Specialist Croup of Oriental medicine Policy(total 1,458 persons). Data were collected from July 1st to November 30, 1999. Direct interview with key persons, systematic interview by using of interview protocol, e-mail and facsimile have been conducted. The results of survey were coded by Excel 5.0, and analysed with SAS 6.12 statistical package. Inter-group difference determined by T-test, and descriptive statistics have been examined. Major findings can be epitomized as follows. 1) OMP disposition to multifarious organizations and institutes such as Public Health Centers, Public Health Sub-centers, Public Hospitals, Private Hospitals in Remote-Vulnerable Area, Community Social Welfare Centers, Institutes for Heath Policy Research, etc, will promise an effective use of Oriental Medical Physician. 2) Average number of patients treated by OMP was 22.8, average budget for oriental medical department, in which OMP were affiliated, was 39.6 million Won per year. Direct cost per every patient visit was 7,210.9 Won, which is considered expensive for public health service. Therefore, development and transformation for Oriental Medical Service in Public Health Sector is desirable in economic and political aspects. 3) It is recommended that ${\ulcorner}Advisory\;Committee{\lrcorner},{\ulcorner}Planning\;Commission\;for\; Public\;Health\;in\;Oriental\;Medicine{\lrcorner}$ should be established for the activation and for the support of Oriental Medical Physician in Public Health Sector, 4) Most effective programmes for oriental public health doctor are health service programmes for the elderly, Home health visit, chronic degenerative disease control services(p<0.001). 5) Standard guideline for facilities and equipments of Oriental Medicine Department in Public Health Center is needed for optimal supply of resources and activation of public health activity.

  • PDF

GIS Database and Google Map of the Population at Risk of Cholangiocarcinoma in Mueang Yang District, Nakhon Ratchasima Province of Thailand

  • Kaewpitoon, Soraya J;Rujirakul, Ratana;Joosiri, Apinya;Jantakate, Sirinun;Sangkudloa, Amnat;Kaewthani, Sarochinee;Chimplee, Kanokporn;Khemplila, Kritsakorn;Kaewpitoon, Natthawut
    • Asian Pacific Journal of Cancer Prevention
    • /
    • v.17 no.3
    • /
    • pp.1293-1297
    • /
    • 2016
  • Cholangiocarcinoma (CCA) is a serious problem in Thailand, particularly in the northeastern and northern regions. Database of population at risk are need required for monitoring, surveillance, home health care, and home visit. Therefore, this study aimed to develop a geographic information system (GIS) database and Google map of the population at risk of CCA in Mueang Yang district, Nakhon Ratchasima province, northeastern Thailand during June to October 2015. Populations at risk were screened using the Korat CCA verbal screening test (KCVST). Software included Microsoft Excel, ArcGIS, and Google Maps. The secondary data included the point of villages, sub-district boundaries, district boundaries, point of hospital in Mueang Yang district, used for created the spatial databese. The populations at risk for CCA and opisthorchiasis were used to create an arttribute database. Data were tranfered to WGS84 UTM ZONE 48. After the conversion, all of the data were imported into Google Earth using online web pages www.earthpoint.us. Some 222 from a 4,800 population at risk for CCA constituted a high risk group. Geo-visual display available at following www.google.com/maps/d/u/0/edit?mid=zPxtcHv_iDLo.kvPpxl5mAs90&hl=th. Geo-visual display 5 layers including: layer 1, village location and number of the population at risk for CCA; layer 2, sub-district health promotion hospital in Mueang Yang district and number of opisthorchiasis; layer 3, sub-district district and the number of population at risk for CCA; layer 4, district hospital and the number of population at risk for CCA and number of opisthorchiasis; and layer 5, district and the number of population at risk for CCA and number of opisthorchiasis. This GIS database and Google map production process is suitable for further monitoring, surveillance, and home health care for CCA sufferers.

A Study of Reliability of Predictive Models for Permanent Deformation and Fatigue Failure Related to Flexible Pavement Design (연성포장설계의 소성변형과 피로파괴 예측모델에 대한 신뢰성 연구)

  • Kim, Dowan;Han, Beomsoo;Kim, Yeonjoo;Mun, Sungho
    • International Journal of Highway Engineering
    • /
    • v.16 no.6
    • /
    • pp.105-113
    • /
    • 2014
  • PURPOSES: The objective of this paper is to select the confidential intervals by utilizing the second moment reliability index(Hasofer and Lind; 1974) related to the number of load applications to failure which explains the fatigue failure and rut depth that it indicates the permanent deformation. By using Finite Element Method (FEM) Program, we can easily confirm the rut depth and number of load repetitions without Pavement Design Procedures for generally designing pavement depths. METHODS : In this study, the predictive models for the rut depth and the number of load repetitions to fatigue failure were used for determining the second moment reliability index (${\beta}$). From the case study results using KICTPAVE, the results of the rut depth and the number of load repetitions to fatigue failure were deducted by calculating the empirical predictive equations. Also, the confidential intervals for rut depth and number of load repetitions were selected from the results of the predictive models. To determine the second moment reliability index, the spreadsheet method using Excel's Solver was used. RESULTS : From the case studies about pavement conditions, the results of stress, displacement and strain were different with depth conditions of layers and layer properties. In the clay soil conditions, the values of strain and stresses in the directly loaded sections are relatively greater than other conditions. It indicates that the second moment reliability index is small and confidential intervals for rut depth and the number of load applications are narrow when we apply the clay soil conditions comparing to the applications of other soil conditions. CONCLUSIONS : According to the results of the second moment reliability index and the confidential intervals, the minimum and maximum values of reliability index indicate approximately 1.79 at Case 9 and 2.19 at Case 22. The broadest widths of confidential intervals for rut depth and the number of load repetitions are respectively occurred in Case 9 and Case 7.

A Study on the Development of Optimal Renewal Planning Model in Water Supply Facilities Connected to Future Financial Plan of Water Providers (수도사업자의 장래 재정계획과 연계한 상수도시설의 최적 개량계획 수립 모델 개발 연구)

  • Lim, Sanghyun;Shin, Hwisu;Seo, Jeewon;Kim, Kibum;Koo, Jayong
    • Journal of Korean Society of Water and Wastewater
    • /
    • v.31 no.2
    • /
    • pp.149-159
    • /
    • 2017
  • It is considered necessary to renewal a considerable number of water supply facilities in Korea because they began to be intensively buried in the period of rapid economic growth. Accordingly, local water providers are required to take measures against this situation, but they have currently been caught in a vicious circle of the lack of budget spent in renewing water supply facilities because county-based small-scale local water supply cannot afford to cover annual expenditures with their revenues from water rates. Therefore, this study developed an optimal renewal planning model capable of achieving a balance of financial revenue and expenditure in local water supply using nonlinear programming and furthermore of minimizing the total cost incurred during the analysis. To this end, this study selected the water supply area located in County Y as a research area to build the financial revenue and expenditure and used Solver function provided by Microsoft Excel to use nonlinear programming. As a result, this study developed an optimal renewal planning model minimizing incurred costs in consideration of 6 items in the financial revenue and expenditure. The optimal renewal plan was modeled according to the available annual budget. As a result, this study proposed SICD, a scenario to minimize total costs from the perspective of water suppliers, and SITS, a scenario to minimize the increase in water rates from the perspective of consumers. It can be said that the method proposed in this study is the core of the optimal financial and renewal plans as a final stage of asset management for water supply facilities. Therefore, it is considered possible for local water providers to use the method proposed in this study according to circumstances for the asset management of water supply facilities.

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

The Effect of Group Sensory Integrative Intervention for Play Skill and Social Interaction (그룹감각통합치료가 아동의 놀이와 또래 상호작용에 미치는 영향)

  • Hong, Eun-Kyoung;Kim, Kyeong-Mi
    • The Journal of Korean Academy of Sensory Integration
    • /
    • v.7 no.1
    • /
    • pp.13-25
    • /
    • 2009
  • Objective : The purpose of the study is to find out how group sensory integrative (SI) intervention enhances play skill and social interaction of the children with sensory integration disorders. Method : Three children who were showing problems related in sensory integration received 12 SI intervention sessions. The Sensory Profile (SP) and The Social Maturity Scale (SMS) were accomplished by the subject's primary caregiver. Test of Playfulness (ToP) and Peer Social Interactions Rating Scale (PSIRS) were utilized to investigate the children's play skills and social interactions with their friends. Goal Attainment Scale (GAS) is applied to assess the children's play skill, social interactions with peer, and sensory processing at each session. Data was collected before- and after the intervention and analyzed by the Wilcoxon matched-pair signed rank test with SPSS/WIN version 10.0 and Microsoft Excel. Results : The average scores of ToP, PSIRS, and SMS were increased after the sensory integrative intervention. However, there is no significant difference in the play skills and social interactions between data of pre-intervention and the one of post-intervention. The score of the GAS was frequently increased in terms of the play skills and sensory processing throughout the whole sessions. Conclusions : This study reveals a possibility of that the group sensory integrative intervention may affect not only sensory processing ability, but also play skills and social interactions of children experiencing difficulties of sensory processing. Future research should supplement limitations of this study regarding insufficient number of the subject and the short period of the experiment.

  • PDF

CCDC26 Gene Polymorphism and Glioblastoma Risk in the Han Chinese Population

  • Wei, Xiao-Bing;Jin, Tian-Bo;Li, Gang;Geng, Ting-Ting;Zhang, Jia-Yi;Chen, Cui-Ping;Gao, Guo-Dong;Chen, Chao;Gong, Yong-Kuan
    • Asian Pacific Journal of Cancer Prevention
    • /
    • v.15 no.8
    • /
    • pp.3629-3633
    • /
    • 2014
  • Background: Glioblastoma (GBM) is an immunosuppressive tumor whose median survival time is only 12-15 months, and patients with GBM have a uniformly poor prognosis. It is known that heredity contributes to formation of glioma, but there are few genetic studies concerning GBM. Materials and Methods: We genotyped six tagging SNPs (tSNP) in Han Chinese GBM and control patients. We used Microsoft Excel and SPSS 16.0 statistical package for statistical analysis and SNP Stats to test for associations between certain tSNPs and risk of GBM in five different models. ORs and 95%CIs were calculated for unconditional logistic-regression analysis with adjustment for age and gender. The SHEsis software platform was applied for analysis of linkage disequilibrium, haplotype construction, and genetic associations at polymorphism loci. Results: We found rs891835 in CCDC26 to be associated with GBM susceptibility at a level of p=0.009. The following genotypes of rs891835 were found to be associated with GBM risk in four different models of gene action: i) genotype GT (OR=2.26; 95%CI, 1.29-3.97; p=0.019) or GG (OR=1.33; 95%CI, 0.23-7.81; p=0.019) in the codominant model; ii) genotypes GT and GG (OR=2.18; 95%CI, 1.26-3.78; p=0.0061) in the dominant model; iii) GT (OR=2.24; 95%CI, 1.28-3.92; p=0.0053) in the overdominant model; iv) the allele G of rs891835 (OR=1.85; 95%CI, 1.14-3.00; p=0.015) in the additive model. In addition, "CG" and "CGGAG" were found by haplotype analysis to be associated with increased GBM risk. In contrast, genotype GG of CCDC26 rs6470745 was associated with decreased GBM risk (OR=0.34; 95%CI, 0.12-1.01; p=0.029) in the recessive model. Conclusions: Our results, combined with those from previous studies, suggest a potential genetic contribution of CCDC26 to GBM progression among Han Chinese.

Quantitative Analyses of Esophageal Cancer Research in Pakistan

  • Qureshi, Muhammad Asif;Khan, Saeed;Ujjan, Ikram Din;Iqbal, Asif;Khan, Ramsha;Khan, Bilal Ahmed
    • Asian Pacific Journal of Cancer Prevention
    • /
    • v.17 no.7
    • /
    • pp.3117-3122
    • /
    • 2016
  • Background: Health-care research is a neglected discipline in Pakistan and research related to esophageal cancer (ranks 9th in Pakistani males and 5th in females) is no exception in this regard. Particularly, there are no data available to delineate the overall status of esophageal cancer epidemiological studies in Pakistan. This study describes the first ever effort to make a systematic quantification, in an attempt to provide a road-map to all stakeholders for designing appropriate epidemiological, diagnostic and therapeutic strategies. Materials and Methods: International (PubMed, ISI Web of Knowledge) and local (PakMedinet) scientific databases as well as Google search engine were searched using specified keywords to extract relevant publication. Well-defined inclusion criteria were implemented to select publications for final analyses. All data were recorded by at least 3 authors and consensus data were entered into and analyzed for descriptive statistics (such as frequencies, percentages and annual growth rates) using Microsoft Excel and SPSS software. Results: A total of 79 publications fulfilled the inclusion criteria including 20 publications for which full texts were not available. Of the 79 publications, 59 (74.6%) were original/research publications, 5 (6.3%) were case reports, 4 (5.1%) were research communications, 2 (2.5%) were review articles, 1 was (1.2%) correspondence and 8 (10.1%) were undefined categories. Only 13 (<20%) cities of Pakistan contributed towards the 79 publications. On average, only 1.9 relevant publications/year were published from 1976 (year of first publication) to the present. Alarmingly, a decline in the annual growth at -4.1% was recorded in the last six years. Conclusions: Esophageal cancer research is largely unfathomed in Pakistan. Urgent/dramatic steps are required by all concerned to address this common (and under reported) cancer of Pakistan.