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

검색결과 177건 처리시간 0.021초

Estimating Completeness of Cancer Registration in Iran with Capture-Recapture Methods

  • Mohammadi, Gohar;Akbari, Mohammad Esmaeil;Mehrabi, Yadolah;Motlagh, Ali Ghanbari;Pour, Elham Partovi;Roshandel, Gholamreza;Khosravi, Ardasheir
    • Asian Pacific Journal of Cancer Prevention
    • /
    • 제17권sup3호
    • /
    • pp.93-99
    • /
    • 2016
  • Completeness is an important indicator of data quality in cancer registry programs. This study aimed to estimate the completeness of registered cases in a population based cancer registry program implemented in five provinces of Iran. Capture-recapture methods were used to estimate the number of cases that may have been missed and to estimate rates of completeness for different categories of age, year, and sex. The data used for this study were obtained from three sources: 1) National Pathology Database; 2) National Hospital Discharge Database; and 3) National Death Registry Database. The three sources were linked and duplicates were identified based on first name, last name, father's names, and date of birth, ICD code, and case's residency address using Microsoft Excel. Removing duplicates, the three sources reported a total of 35,643 cases from March 2008 to March 2011. Running many different multivariate models of capture-recapture and controlling for source dependencies revealed an overall under-reporting of 49% in all five registries combined. The estimated completeness differed based on age, sex, and year. The overall completeness was higher for males than females (71.2% for males and 59.9% for females). Younger age had lower rates of completeness compared to older age (38.1% for <40 years, 55.4% for 40-60 years, and 76.7 for >60 years). The results of this study indicated a moderate to severe (depending on the age, sex and year) degree of completeness in the population based cancer registration of Iran.

Male Breast Cancer: a 24 Year Experience of a Tertiary Care Hospital in Pakistan

  • Jamy, Omer;Rafiq, Ammar;Laghari, Altaf;Chawla, Tabish
    • Asian Pacific Journal of Cancer Prevention
    • /
    • 제16권4호
    • /
    • pp.1559-1563
    • /
    • 2015
  • Background: Male breast cancer accounts for less than 1% of all cancers found in men. It usually presents at a later age and stage as compared to female breast cancer. Treatment strategies are extrapolated from the management of female breast cancer. Our study here looked at 18 patients diagnosed with and treated for male breast cancer at The Aga Khan University Hospital in Pakistan. We compared our findings with the existing data from Asian and Western countries. Materials and Methods: A retrospective study was conducted looking at patients with male breast cancer between January 1986 and December 2009. Patient and disease characteristics were analyzed and 5 year overall survival was calculated using Microsoft Excel and SPSS. Results: The average age at diagnosis was 52 years (38-67 years). Twelve (66.7%) patients had axillary lymphadenopathy. Stage II disease was the most common stage at presentation (9 patients, 50%). Infiltrating ductal carcinoma was seen in 16 patients (88.8%). Seven lesions were positive for both estrogen and progesterone receptors. Sixteen patients had surgery in the form of either modified radical mastectomy or radical mastectomy. Radiation was used in 7 patients in an adjuvant setting. The five year overall survival for stage I, II, III and IV disease was 100% vs 78% vs 50% vs 0%( p<0.05). Five year overall survival was 61%. None of the other prognostic factors were statistically significant. Median follow up was 15 months (3-202 months). Conclusions: Male breast cancer may be on a slow rise but is still an uncommon disease. Tumor stage and lymph node status are important prognostic markers. Public awareness and screening may help in detecting the disease at an earlier stage. Prospective trials are needed to improve the management of this disease.

Estimation of Cancer Cases Using Capture-Recapture Method in Northwest Iran

  • Ghojazadeh, Morteza;Mohammadi, Marziye;Azami-Aghdash, Saber;Sadighi, Alireza;Piri, Reza;Naghavi-Behzad, Mohammad
    • Asian Pacific Journal of Cancer Prevention
    • /
    • 제14권5호
    • /
    • pp.3237-3241
    • /
    • 2013
  • Background: Under-ascertainment and over-ascertainment are common phenomena in surveillance and registry systems of health-related events. Capture-recapture is one of the methods which is applied to determine the sensitivity of surveillance or registry systems to recognize cancer cases. This study aimed to estimate the number of cancers using data available both in the Cancer Registry Center of Northwestern Iran and in the Population-based Cancer Registry Center of Iran. Material and Methods: The studied population consisted of all cancerous cases in the northwest of Iran from 2008 to 2010. All data were extracted from two resources and entered into Microsoft Excel software. After removing common and repeat cases the data were statistically analyzed using a capture-recapture studies' specific software "CARE 1.4". Estimations were calculated by Chapman and Petersen methods with the approximate confidence interval of 95%. Results: From 2008 to 2010, the number of all cancer cases was estimated to be 21,652 (CI 95%: 19,863-22,101). Sensitivity rate of all cancer cases was 83.9% and that of Population-based Cancer Registry Center of Iran was 52%. It was 93.1% considering both resources. Conclusion: Using two resources and the capture-recapture method rather than a single resource may be a more reliable method to estimate the number of cancer cases.

Monte Carlo Simulation of Phytosanitary Irradiation Treatment for Mangosteen Using MRI-based Geometry

  • Oh, Se-Yeol;Kim, Jongsoon;Kwon, Soon-Hong;Chung, Sung-Won;Kwon, Soon-Goo;Park, Jong-Min;Choi, Won-Sik
    • Journal of Biosystems Engineering
    • /
    • 제39권3호
    • /
    • pp.205-214
    • /
    • 2014
  • Purpose: Phytosanitary irradiation treatment can effectively control regulated pests while maintaining produce quality. The objective of this study was to establish the best irradiation treatment for mangosteen, a popular tropical fruit, using a Monte Carlo simulation. Methods: Magnetic resonance image (MRI) data were used to generate a 3-D geometry to simulate dose distributions in a mangosteen using a radiation transport code (MCNP5). Microsoft Excel with visual basic application (VBA) was used to divide the image data into seed, flesh, and rind. Radiation energies used for the simulation were 10 MeV (high-energy) and 1.35 MeV (low-energy) for the electron beam, 5 MeV for X-rays, and 1.25 MeV for gamma rays from Co-60. Results: At 5 MeV X-rays and 1.25 MeV gamma rays, all areas (seeds, flesh, and rind) were irradiated ranging from 0.3 ~ 0.7 kGy. The average doses decreased as the number of fruit increased. For a 10 MeV electron beam, the dose distribution was biased: the dose for the rind where the electrons entered was $0.45{\pm}0.03$ kGy and the other side was $0.24 {\pm}0.10$ kGy. Use of an electron kinetic energy absorber improved the dose distribution in mangosteens. For the 1.35 MeV electron beam, the dose was shown only in the rind on the irradiated side; no significant dose was found in the flesh or seeds. One rotation of the fruit while in front of the beam improved the dose distribution around the entire rind. Conclusion: These results are invaluable for determining the ideal irradiation conditions for phytosanitary irradiation treatment of tropical fruit.

국내 즉석섭취 신선채소류 중 Listerial monocytogene위해수준 평가 (The Risk Estimation of Listeria monocytogenes for Ready-to-eats Fresh Cut-Vegetables)

  • 오덕환;;하상도;박경진
    • 한국식품위생안전성학회지
    • /
    • 제24권1호
    • /
    • pp.50-55
    • /
    • 2009
  • 본 연구에서는 위해 수준이 상대적으로 클 것으로 추정되는 가열하지 않고 그대로 섭취하는 신선 채소류를 대상으로 이들 식품군에서 많은 발생하는 Listeria monocytogenes에 대한 국내 오염수준 모니터링 자료와 신선 채소류의 섭취량, L. monocytogenes의 양-반응 모델(dose-response models)을 바탕으로 위해 수준을 추정할 수 있는 모델을 개발하였고, 이를 바탕으로 위해 수준을 평가하였다. 개발된 모델을 @RISK를 이용하여 시뮬레이션 한 결과 신선 채소류의 섭취를 통한 L. monocytogenes에 의한 1인1일당 리스테리아증 발생가능성은 평균 $8.76{\times}10^{-16}$로, 연간 천만명당 발생환자수는 $3.23{\times}10^{-6}$로 추종되었다. 또한 본 연구에서 개발된 모델을 바탕으로 추후 더욱 발전된 미생물위해평가(MRA) 연구와 결과를 도출하기 위한 제언을 추가하였다.

Coloration behaviors of phthalocyanine reactive dye on nylon substrates: experiments, empirical modeling and statistical analysis

  • Kim, Byung-Soon;Ravikumar, K.;Yoon, Seok-Han;Son, Young-A
    • 한국염색가공학회지
    • /
    • 제19권2호
    • /
    • pp.14-23
    • /
    • 2007
  • This research article explores the use of phthalocyanine reactive dye on nylon substrate. The effect of factors such as pH, temperature, liquor ratio and alkali addition on level of dye exhaustion, fixation and total fixation efficiency. Low pH, high temperature and low liquor ratio were found to be suitable conditions for maximum % exhaustion values. The effect of sulphatoethylsulphone(SES) and vinylsulphone(VS) form of the dyes on level of dye fixation was also discussed. The optimized exhaustion (%E), fixation(%F) and total fixation efficiency were determined. Modification of the dyeing process with alkali addition displayed that dye fixation(%) increased by alkali addition. Vinylsulphone(VS) moiety of the dye was found to be superior to. maximum fixation (%F). Appropriate predictable empirical models, relatively a new approach in dyeing processes, were developed incorporating interactions effects of temperature, pH and liquor ratio for predicting % exhaustion, fixation and total fixation efficiency. The significance of the mathematical model developed was ascertained using microsoft excel regression(solver) analysis module. High correlation coefficient was obtained (R2=0.9895 for % exhaustion, R2=0.9932 for fixation, R2=0.9965 for total fixation efficiency) for the model which shows prominent prediction capacity of the model for my conditions. The predictable polynomial equations developed from tile experimental results were thoroughly analyzed by ANOVA (Analysis of Variance) statistical concepts.

초고층건축 알루미늄커튼월 구조설계검토 프로세스와 매뉴얼 개발에 관한 연구: 멀리언과 트랜섬을 중심으로 (A Study on the Development of the Structural Performance Evaluation Manual of the Skyscrapers Curtain Wall Systems for Construction Managers)

  • 조예원;이민철;옥종호
    • 한국건설관리학회논문집
    • /
    • 제10권3호
    • /
    • pp.92-101
    • /
    • 2009
  • 초고층건물의 외장재로 많이 사용되고 있는 자재는 경량이면서도 실내환경 영향요소의 흐름을 조절/차단하는 필터기능이 탁월한 알루미늄 커튼월이다. 초고층건물 커튼월의 설계와 관련된 CMr의 역할에는 커튼월의 구조적 적정성 검토가 포함되며 이를 위해서는 커튼월을 구성하고 있는 각종 자재들의 물성, 다양한 커튼월시스템 구성방식의 이해와 더불어 구조설계가 필요한 구조부재의 종류, 구조설계 프로세스, 적정성 판단 설계요소 등에 대한 복합적 이해가 필수적이다. 본 연구는 CMr가 커튼월 구조설계의 적정성을 간편하게 검토할 수 있는 구조설계 검토프로세스를 도출하고 커튼월 구조부재인 멀리언 (수직재), 트랜섬 (수평재) 구조설계의 적정성을 쉽게 검토할 수 있는 구조설계검토 매뉴얼 개발을 목적으로 한다. 개발된 매뉴얼의 적용성을 검토하기 위해 동 매뉴얼을 실제 커튼월 설계프로젝트에 적용하여 보았으며 커튼월 설계전문가 및 CMr와 워크샵 설시하여 매뉴얼의 개선방향을 모색하였다.

Current status of and trends in post-mastectomy breast reconstruction in Korea

  • Song, Woo Jin;Kang, Sang Gue;Kim, Eun Key;Song, Seung Yong;Lee, Joon Seok;Lee, Jung Ho;Jin, Ung Sik
    • Archives of Plastic Surgery
    • /
    • 제47권2호
    • /
    • pp.118-125
    • /
    • 2020
  • Since April 2015, post-mastectomy breast reconstruction has been covered by the Korean National Health Insurance Service (NHIS). The frequency of these procedures has increased very rapidly. We analyzed data obtained from the Big Data Hub of the Health Insurance Review and Assessment Service (HIRA) and determined annual changes in the number of breast reconstruction procedures and related trends in Korea. We evaluated the numbers of mastectomy and breast reconstruction procedures performed between April 2015 and December 2018 using data from the HIRA Big Data Hub. We determined annual changes in the numbers of total, autologous, and implant breast reconstructions after NHIS coverage commenced. Data were analyzed using Microsoft Excel. The post-mastectomy breast reconstruction rate increased from 19.4% in 2015 to 53.4% in 2018. In 2015, implant reconstruction was performed in 1,366 cases and autologous reconstruction in 905 (60.1% and 39.8%, respectively); these figures increased to 3,703 and 1,570 (70.2% and 29.7%, respectively) in 2018. Free tissue transfer and deep inferior epigastric perforator flap creation were the most common autologous reconstruction procedures. For implant-based reconstructions, the rates of directto-implant and tissue-expander breast reconstructions (first stage) were similar in 2018. This study summarizes breast reconstruction trends in Korea after NHIS coverage was expanded in 2015. A significant increase over time in the post-mastectomy breast reconstruction rate was evident, with a trend toward implant-based reconstruction. Analysis of data from the HIRA Big Data Hub can be used to predict breast reconstruction trends and convey precise information to patients and physicians.

노인들의 일반의약품 및 건강기능식품 복용실태 평가 (The Evaluation of OTC Drugs and Health Functional Food Use in Elderly People)

  • 김재윤;이보름;장제관;조하나;이지선;김미경;이명구;임성실
    • 약학회지
    • /
    • 제53권6호
    • /
    • pp.334-341
    • /
    • 2009
  • Aging society and aged society are determined by the component ratio of the elderly to the whole population; aging society is defined as a society whose ratio of the elderly population is less than 7%, and it is called aged society when the ratio is over 14%. Korea's aging process is so fast and unprecedented over the world according to many statistical data and investigations. The purpose of this study was to provide guidance and basic data to educate the elderly for the proper use of medication and health functional food. This study was carried out on 80 subjects of age 65 or older in Cheong Jusi in Choogncheongbuk-do. They answered questionnaire that was prepared for this study. The data were collected from August 4, 2008 to August 18, 2008. The collected data were analyzed by using the SPSS 12.0OK (for window) program and Microsoft EXCEL. The following is a summary of the results of this study. First, in the aspect of purchasing, the majority of respondents bought OTC drugs and health functional food for health and illness prevention. Purchasing places of drugs were diverse. Second, in the aspect of taking drugs, the older answerers were, the higher the number of drugs being taken was. Third, in the aspect of proper storage of drugs, most respondents have no specific spaces. Finally, regarding recognition of drug abuse and disposal, most people have little awareness or have no idea.

압전방식초음파치석제거기의작업조건에따른치과주조용합금의삭제결손부 양상에 관한 고찰 (A morphologic evaluation of defects created by a piezoelectric ultrasonic scaler on casting gold alloy)

  • 김영성;김수환;김원경;이영규
    • Journal of Periodontal and Implant Science
    • /
    • 제39권4호
    • /
    • pp.385-390
    • /
    • 2009
  • Purpose: In this study we evaluated the morphologic aspects of defects created by a piezoelectric ultrasonic scaler with scaler tip on casting gold alloy using scanning electron microscope (SEM) images and defect surface profiles. Methods: 54 blocks of type III casting gold alloy (Firmilay, Jellenko Inc, CA, USA) were scaled by a piezoelectric ultrasonic scaler (P-MAX, Satelec, France) with scaler tip (No. 1 tip) on a sledge device. 2-dimensional profiles of defects on all samples were investigated by a surface profilometer (a-Step 500, KLA-Tencor, CA, USA). The selected working parameters were lateral force (0.5 N, 1.0 N, 2.0 N), mode (P mode, S mode), and power setting (2, 4, 8). SEM images were obtained. Defect surface profiles were made on Microsoft Excel program using data obtained by a surface profilometer. Results: Among P mode samples, there were similarities on defect surface profiles and SEM images regardless of lateral force. The defects created in P mode were narrow and shallow although the depth and the width increased as power setting changed low (2) to high (8). In P mode samples, the defect depth was the greatest when lateral force of 0.5 N was applied. However all the depths were smaller than 1 m. SEM images of Lateral force of 0.5 N, S mode, power setting 2 and 4 were similar to that of P mode, but the other SEM images of S mode showed discernible changes. Defect depth of S mode samples was the greatest when lateral force of 1.0 N was applied. Conclusions: Within the limitations of this study, it can be concoluded that removing capability of piezoelectric scaler with scaler tip becomes maximized as power level becomes higher but the capability is restricted when excessive lateral force is applied on scaler tip.