• Title/Summary/Keyword: excel macro

Search Result 24, Processing Time 0.017 seconds

A Development of the Software to Estimate of Economics for Combined Heat and Power Generation Systems in Apartment Estates (아파트의 소형열병합발전시스템 경제성평가 프로그램개발)

  • Lee, Jong-Sung;Park, Tae-Won;Lee, Taik-Seob
    • Proceedings of the SAREK Conference
    • /
    • 2006.06a
    • /
    • pp.89-94
    • /
    • 2006
  • For a development of the software which estimates the economics of a combined heat and power generation system in apartment estates, the thermal consumption and electric power consumption data were investigated in about 115 apartment estates. And the algorithm was developed, then the software was made by the macro function of the Excel spread sheets.

  • PDF

A Study on the make Fire Scenario for Residential Facility Combustible Materials

  • Kim, Dong-Eun;Lee, Dong-Yeol
    • Journal of the Korea Society of Computer and Information
    • /
    • v.26 no.6
    • /
    • pp.137-143
    • /
    • 2021
  • In the case of residential facilities, general fire scenarios cannot be applied. Becauseit is difficult to quantify due to the types of combustibles and various fire loads. Existing research conducting surveys of combustibles, but research on fire characteristics is insufficient. Therefore, in this study, an Excel macro that can be quantified by experimenting with the HRR experiments of sofa, drawer, mattress, chair, desk and TV, which are typical combustibles. As a result of experimenting 6 loading combustibles in domestic residential facilities by using a furniture calorimeter, values of 2,391.26kW appeared from the sofa, 1,891.80kW from the drawer, 1,778.95kW from the mattress, 1,104kW from the chair, 291kW from the desk, and 135.09kW from the TV. Also, by applying the α value of the fire growth rate by classifying fire-growing speeds at NFPA 72 (National Fire Alarm Code 2007, Annex B), the mattress can be defined as Very Fast, the sofa and drawer Fast, the TV Slow, the desk Slow, and the chair Medium.

Variation Analysis of Distance and Exposure Dose in Radiation Control Area and Monitoring Area according to the Thickness of Radiation Protection Tool Using the Calculation Model: Non-Destructive Test Field (계산 모델을 활용한 방사선방어용 도구 두께에 따른 방사선관리구역 및 감시구역의 거리 및 피폭선량 변화 분석 : 방사선투과검사 분야 중심으로)

  • Gwon, Da Yeong;Park, Chan-hee;Kim, Hye Jin;Kim, Yongmin
    • Journal of the Korean Society of Radiology
    • /
    • v.14 no.3
    • /
    • pp.279-287
    • /
    • 2020
  • Recently, interest in radiation protection is increasing because of the occurrence of accidents related to exposure dose. So, the nuclear safety act provides to install the shields to avoid exceeding the dose limit. In particular, when the worker conducts the non-destructive testing (NDT) without the fixed shielding structure, we should monitor the access to the workplace based on a constant dose rate. However, when we apply for permits for NDT work in these work environments, the consideration factors to the estimation of the distance and exposure dose are not legally specified. Therefore, we developed the excel model that automatically calculates the distance, exposure dose, and cost if we input the factors. We applied the assumption data to this model. As a result of the application, the distance change rate was low when the thickness of the lead blanket and collimator is above 25 mm, 21.5 mm, respectively. However, we didn't consider the scattering and build-up factor. And, we assumed the shape of the lead blanket and collimator. Therefore, if we make up for these limitations and use the actual data, we expect that we can build a database on the distance and exposure dose.

Nutritional Adequacy of Target Pattern in Dietary Guidance System - Dietary Reference Intakes for Koreans 2015 - (식사구성안 권장식사패턴의 영양 적정성 평가 - 2015 한국인 영양소 섭취기준 -)

  • Kim, Youngnam
    • Journal of Korean Home Economics Education Association
    • /
    • v.29 no.3
    • /
    • pp.77-88
    • /
    • 2017
  • Nutritional adequacy of Target patterns in Dietary Guidance System were evaluated. Study subjects were 18 Target patterns designed for 2 children groups, 4 adolescent and 4 adult male and female groups in Dietary Reference Intakes for Koreans 2015. Nutrients examined were 4 macro-nutrients(protein, fat, carbohydrate, and dietary fiber), 5 minerals(Ca, P, Fe, Na, and K), and 5 vitamins(vitamin A, thiamin, riboflavin, niacin, and vitamin C). Energy and nutrients contents were calculated based upon assigned multiples of single serving in Target pattern and Representative Food Composition Table by Excel program. Among the 18 Target patterns, only 5 were mean adequacy ratio(MAR) of 1.0, fulfilled the expectations of Dietary Guidance System. Protein and Na contents were more than dietary reference intakes(DRI) in all 18 Target patterns. Dietary fiber, Ca, and K were deficient nutrient in 15, 10, and 9 Target patterns, respectively. The units of vitamin A were not same in Target pattern and DRI, retinol equivalent(RE) in Target pattern and retinol activity equivalent(RAE) in DRI. When calculate RE content of vitamin A in Target pattern to RAE content, 15 Target patterns did not reach to DRI of vitamin A. The Target pattern of elderly women showed the lowest mean adequacy ratio(MAR), 7 nutrients were less than DRI, need to be revised. Average energy contribution ratio of protein, fat, and carbohydrate were 16.04%, 24.35%, and 60.91%, respectively, fulfilled the adequate acceptable macro-nutrient distribution range(AMDR). To improve the nutritional inadequacy of dietary fiber, Ca, K, and vitamin A in Target pattern, effective mean may be the increasing vegetable group assignment. Also decreasing the meat fish egg legume group assignment in some Target pattern may be the way of preventing of protein overconsumption. The energy in adequate amount for condiment use also need to be considered.