怎样用excel计算空调冷负荷

No.3/201013331RefrigerationAirConditioning&ElectricPowerMachineryTU831.2A1006-8449201003-0054-040、。。、Z。Z。MicrosoftExcel[1]。ZExcel。1[2~4]1.11.1.1、、qn=ni=0ΣbiTen-i-ni=0ΣciTinn-i-ni=1Σdiqn-i1qn—n、W/m2qn-i—n-i、W/m2Ten-i—n-i℃bicidi—ZTinn-i—n-i℃。nTen=Twn+ρInαw-εwΔRαw2Twn—℃ρ—In—W/m2αw—W/m2·Kεw—ΔR—W/m2。Twn=Tw-aiΔTTw—℃ai—ΔT—。Tinn-i=constqn=ni=0ΣbiTen-i-Tinni=0Σci-ni=1Σdiqn-i3bi、ci、diExcel121.5180312.300350MicrosoftExcelZZMicrosoftExcel、、。MicrosoftExcelIT54No.3/201013331RefrigerationAirConditioning&ElectricPowerMachinery。。。1.1.21。qc=KTen-Tin4qc—W/m2K—W/m2·KTen—n℃Tin—℃。2。qf=Cs·Cn·Dj5qf—W/m2Cs—Cn—Dj—W/m2。1.21.2.1、、CLqn=V0qn+V1qn-1+V2qn-2+W1CLqn-16CLqnCLqn-1—nn-1、W/m2qnqn-1qn-2—n、n-1、n-2W/m2V0V1V2W1—、Z。ZV0、V1、V2、W1。。1.2.21CLqcn=V0qcn+V1qcn-1+V2qcn-2+W1CLqcn-17CLqcnCLqcn-1—n、n-1W/m2qcnqcn-1qcn-2—n、n-1、n-2W/m2V0V1V2W1———Z。2CLqfn=V0qfn+V1qfn-1+V2qfn-2+W1CLqfn-18CLqfnCLqfn-1—n、n-1W/m2qfnqfn-1qfn-2—n、n-1、n-2W/m2V0V1V2W1—Z。1.2.3、、。2。145ρ＝0.930。53.4ma×b=7200mm×3600mm2400mm×2200mm5mm。、42362。240W460W200080012h。500W800~14006h。2.12。、、、。BExcel。B36“＝”B28“*”B29“*”B32“Enter”。36B36Y36。IT55No.3/201013331RefrigerationAirConditioning&ElectricPowerMachinery2.23A—B—C—D—E—F—。。qnCLqnqnCLqn。ExcelIT56No.3/201013331RefrigerationAirConditioning&ElectricPowerMachineryApplicationofMicrosoftExcelinAirConditioningCoolingLoadCalculationRONGQing-xing1MENGWei21.ShenZhenA+EDesignCo.LtdShenzhen518031China2.TianjinMcc20MachineryInstaucnentEngineeringBranchCompanyTianjin300350ChinaAbstractTakingtheadvantageofMicrosoftExcelinrepeatedcomputationitsusinginairconditioning'scoolingloadcalculationbytheZtransferfunctionmethodswasintroduced.Thenatwo-storeyofficebuildinginWuhanwastakenasanexampleitsair-conditioningcoolingloadwascalculatedinthiswaytheresultsshowedthatwithZtransferfunctionmethodandtheMicrosoftExcelsoftwarecalculationoftheairconditioningcoolingloadwasconvenientfastandaccurate.KeywordsairconditioningcoolingloadcalculationtransferfunctionMicrosoftExcel。2.34。1~10Excel24h。。3ExcelExcel。。。Z。[1].Excel[J].2003171~72.[2].[M].1990.[3].[M].1978.[4].[M].1990.2010-11-242010-01-071977-1981-。IT57