Application of excel static temperature analysis to SLRA

Autor: Ishii, Tadashi, Kunimori, Hiroo, Takeuchi, Hiroshi, Koga, Shigeaki, Suzaki, Yasuji
Jazyk: japonština
Rok vydání: 2008
Předmět:
Zdroj: 第27回宇宙エネルギーシンポジウム 平成19年度 = The Twenty-seventh Space Energy Symposium. :126-130
Popis: A simplified method to compute static temperature using Microsoft Excel is presented in this report. There are two ways for prediction of temperature. One is transient temperature analysis, and the other is steady state analysis. For the thermal design of spacecrafts, both are important. We ordinarily use the maximum and minimum temperature obtained by the steady-state thermal analysis for the preliminary design. Therefore, although this method cannot treat large models, it is useful for preliminary design level. Because the heat transfer equation is a first-order differential equation, it can be easily solved by using MS (MicroSoft)-Excel. Temperature analysis using Excel are widely performed. But in many cases, they use cells as a meshes of the target's shape. The method that we developed this time simply uses Excel's worksheet as a data of thermal properties, and the calculation is done by Visual Basic for Applications (VBA). The analysis is done by using iterative sequential process and the equilibrium temperature will be calculated. The Excel sheet used for this method has good readability and can be used for a report directly. Because the calculation is coded by VBA, the code is easy to maintain. The calculation is done by VBA interpreter, so it is faster than ordinary Excel process. We applied this method to analyze the temperature of SLRA (Satellite Laser Reflector Array) equipped in ASTRO-G (Radio-Astronomical Satellite), and had a good result that agrees with an analysis using SINDA (System Improved Numerical Differential Analyzer) and detail model.
資料番号: AA0063965026
Databáze: OpenAIRE