1def calculate_furnace_size(square_footage, climate_zone, insulation_quality,
2                          ceiling_height=8, home_age='modern'):
3    """
4    根据家庭特征计算推荐炉子尺寸（BTU）。
5    
6    参数：
7    square_footage (float): 家庭面积（平方英尺）
8    climate_zone (str): 'mild', 'moderate', 'cold', 或 'severe'
9    insulation_quality (str): 'poor', 'average', 或 'excellent'
10    ceiling_height (float): 平均天花板高度（英尺）
11    home_age (str): 'new', 'modern', 'older', 或 'historic'
12    
13    返回：
14    int: 推荐炉子尺寸（BTU）
15    """
16    # 基础BTU因子按气候区
17    climate_btu_factors = {
18        'mild': 25,
19        'moderate': 35,
20        'cold': 45,
21        'severe': 60
22    }
23    
24    # 调整因子
25    insulation_factors = {
26        'poor': 1.15,
27        'average': 1.0,
28        'excellent': 0.85
29    }
30    
31    home_age_factors = {
32        'new': 0.95,
33        'modern': 1.0,
34        'older': 1.05,
35        'historic': 1.1
36    }
37    
38    # 计算基础BTU需求
39    btu_requirement = square_footage * climate_btu_factors[climate_zone]
40    
41    # 应用绝缘因子
42    btu_requirement *= insulation_factors[insulation_quality]
43    
44    # 应用天花板高度因子（每英尺增加12.5%）
45    if ceiling_height > 8:
46        btu_requirement *= (1 + ((ceiling_height - 8) * 0.125))
47    
48    # 应用房屋年龄因子
49    btu_requirement *= home_age_factors[home_age]
50    
51    # 四舍五入到最接近的5,000 BTU（常见炉子尺寸增量）
52    return round(btu_requirement / 5000) * 5000
53
54# 示例用法
55home_size = 2000  # 平方英尺
56climate = 'moderate'
57insulation = 'average'
58ceiling_height = 9  # 英尺
59home_age = 'modern'
60
61recommended_size = calculate_furnace_size(home_size, climate, insulation, 
62                                        ceiling_height, home_age)
63print(f"推荐炉子尺寸：{recommended_size:,} BTU")
64

1' Excel VBA 函数用于炉子尺寸计算
2Function CalculateFurnaceSize(SquareFootage As Double, ClimateZone As String, _
3                             InsulationQuality As String, _
4                             Optional CeilingHeight As Double = 8, _
5                             Optional HomeAge As String = "modern") As Double
6    
7    Dim BTURequirement As Double
8    Dim ClimateFactor As Double
9    Dim InsulationFactor As Double
10    Dim CeilingFactor As Double
11    Dim AgeFactor As Double
12    
13    ' 设置气候因子
14    Select Case ClimateZone
15        Case "mild"
16            ClimateFactor = 25
17        Case "moderate"
18            ClimateFactor = 35
19        Case "cold"
20            ClimateFactor = 45
21        Case "severe"
22            ClimateFactor = 60
23        Case Else
24            ClimateFactor = 35 ' 默认适中
25    End Select
26    
27    ' 设置绝缘因子
28    Select Case InsulationQuality
29        Case "poor"
30            InsulationFactor = 1.15
31        Case "average"
32            InsulationFactor = 1
33        Case "excellent"
34            InsulationFactor = 0.85
35        Case Else
36            InsulationFactor = 1 ' 默认一般
37    End Select
38    
39    ' 计算天花板高度因子
40    If CeilingHeight > 8 Then
41        CeilingFactor = 1 + ((CeilingHeight - 8) * 0.125)
42    Else
43        CeilingFactor = 1
44    End If
45    
46    ' 设置年龄因子
47    Select Case HomeAge
48        Case "new"
49            AgeFactor = 0.95
50        Case "modern"
51            AgeFactor = 1
52        Case "older"
53            AgeFactor = 1.05
54        Case "historic"
55            AgeFactor = 1.1
56        Case Else
57            AgeFactor = 1 ' 默认现代
58    End Select
59    
60    ' 计算BTU需求
61    BTURequirement = SquareFootage * ClimateFactor * InsulationFactor * CeilingFactor * AgeFactor
62    
63    ' 四舍五入到最接近的5,000 BTU
64    CalculateFurnaceSize = Round(BTURequirement / 5000) * 5000
65End Function
66

1public class FurnaceSizeCalculator {
2    
3    public static int calculateFurnaceSize(double squareFootage, String climateZone,
4                                         String insulationQuality, double ceilingHeight,
5                                         String homeAge) {
6        
7        // 基础BTU因子按气候区
8        Map<String, Double> climateBtuFactors = new HashMap<>();
9        climateBtuFactors.put("mild", 25.0);
10        climateBtuFactors.put("moderate", 35.0);
11        climateBtuFactors.put("cold", 45.0);
12        climateBtuFactors.put("severe", 60.0);
13        
14        // 调整因子
15        Map<String, Double> insulationFactors = new HashMap<>();
16        insulationFactors.put("poor", 1.15);
17        insulationFactors.put("average", 1.0);
18        insulationFactors.put("excellent", 0.85);
19        
20        Map<String, Double> homeAgeFactors = new HashMap<>();
21        homeAgeFactors.put("new", 0.95);
22        homeAgeFactors.put("modern", 1.0);
23        homeAgeFactors.put("older", 1.05);
24        homeAgeFactors.put("historic", 1.1);
25        
26        // 计算基础BTU需求
27        double btuRequirement = squareFootage * climateBtuFactors.get(climateZone);
28        
29        // 应用绝缘因子
30        btuRequirement *= insulationFactors.get(insulationQuality);
31        
32        // 应用天花板高度因子（每英尺增加12.5%）
33        if (ceilingHeight > 8) {
34            btuRequirement *= (1 + ((ceilingHeight - 8) * 0.125));
35        }
36        
37        // 应用房屋年龄因子
38        btuRequirement *= homeAgeFactors.get(homeAge);
39        
40        // 四舍五入到最接近的5,000 BTU
41        return (int) (Math.round(btuRequirement / 5000) * 5000);
42    }
43    
44    public static void main(String[] args) {
45        double homeSize = 2000; // 平方英尺
46        String climate = "moderate";
47        String insulation = "average";
48        double ceilingHeight = 9; // 英尺
49        String homeAge = "modern";
50        
51        int recommendedSize = calculateFurnaceSize(homeSize, climate, insulation, 
52                                                 ceilingHeight, homeAge);
53        System.out.printf("推荐炉子尺寸：%,d BTU%n", recommendedSize);
54    }
55}
56