1' נוסחת Excel לחישוב כמות מלט
2=IF(B2="bricklaying",IF(C2="standard",A2*0.022,IF(C2="highStrength",A2*0.024,A2*0.02)),
3 IF(B2="blockwork",IF(C2="standard",A2*0.018,IF(C2="highStrength",A2*0.02,A2*0.016)),
4 IF(B2="stonework",IF(C2="standard",A2*0.028,IF(C2="highStrength",A2*0.03,A2*0.026)),
5 IF(B2="tiling",IF(C2="standard",A2*0.008,IF(C2="highStrength",A2*0.01,A2*0.007)),
6 IF(C2="standard",A2*0.016,IF(C2="highStrength",A2*0.018,A2*0.014))))))
7

1function calculateMortarVolume(area, constructionType, mortarType) {
2  const factors = {
3    bricklaying: {
4      standard: 0.022,
5      highStrength: 0.024,
6      lightweight: 0.020
7    },
8    blockwork: {
9      standard: 0.018,
10      highStrength: 0.020,
11      lightweight: 0.016
12    },
13    stonework: {
14      standard: 0.028,
15      highStrength: 0.030,
16      lightweight: 0.026
17    },
18    tiling: {
19      standard: 0.008,
20      highStrength: 0.010,
21      lightweight: 0.007
22    },
23    plastering: {
24      standard: 0.016,
25      highStrength: 0.018,
26      lightweight: 0.014
27    }
28  };
29  
30  return area * factors[constructionType][mortarType];
31}
32
33function calculateBags(volume, mortarType, unit = 'metric') {
34  const bagsPerVolume = {
35    metric: {
36      standard: 40,
37      highStrength: 38,
38      lightweight: 45
39    },
40    imperial: {
41      standard: 1.13,
42      highStrength: 1.08,
43      lightweight: 1.27
44    }
45  };
46  
47  return volume * bagsPerVolume[unit][mortarType];
48}
49
50// דוגמת שימוש
51const area = 50; // מ²
52const constructionType = 'bricklaying';
53const mortarType = 'standard';
54const unit = 'metric';
55
56const volume = calculateMortarVolume(area, constructionType, mortarType);
57const bags = calculateBags(volume, mortarType, unit);
58
59console.log(`נפח מלט: ${volume.toFixed(2)} מ³`);
60console.log(`מספר שקיות: ${Math.ceil(bags)}`);
61

1def calculate_mortar_volume(area, construction_type, mortar_type):
2    factors = {
3        'bricklaying': {
4            'standard': 0.022,
5            'high_strength': 0.024,
6            'lightweight': 0.020
7        },
8        'blockwork': {
9            'standard': 0.018,
10            'high_strength': 0.020,
11            'lightweight': 0.016
12        },
13        'stonework': {
14            'standard': 0.028,
15            'high_strength': 0.030,
16            'lightweight': 0.026
17        },
18        'tiling': {
19            'standard': 0.008,
20            'high_strength': 0.010,
21            'lightweight': 0.007
22        },
23        'plastering': {
24            'standard': 0.016,
25            'high_strength': 0.018,
26            'lightweight': 0.014
27        }
28    }
29    
30    return area * factors[construction_type][mortar_type]
31
32def calculate_bags(volume, mortar_type, unit='metric'):
33    bags_per_volume = {
34        'metric': {
35            'standard': 40,
36            'high_strength': 38,
37            'lightweight': 45
38        },
39        'imperial': {
40            'standard': 1.13,
41            'high_strength': 1.08,
42            'lightweight': 1.27
43        }
44    }
45    
46    return volume * bags_per_volume[unit][mortar_type]
47
48# דוגמת שימוש
49area = 50  # מ²
50construction_type = 'bricklaying'
51mortar_type = 'standard'
52unit = 'metric'
53
54volume = calculate_mortar_volume(area, construction_type, mortar_type)
55bags = calculate_bags(volume, mortar_type, unit)
56
57print(f"נפח מלט: {volume:.2f} מ³")
58print(f"מספר שקיות: {math.ceil(bags)}")
59

1public class MortarCalculator {
2    public static double calculateMortarVolume(double area, String constructionType, String mortarType) {
3        double factor = 0.0;
4        
5        switch (constructionType) {
6            case "bricklaying":
7                if (mortarType.equals("standard")) factor = 0.022;
8                else if (mortarType.equals("highStrength")) factor = 0.024;
9                else if (mortarType.equals("lightweight")) factor = 0.020;
10                break;
11            case "blockwork":
12                if (mortarType.equals("standard")) factor = 0.018;
13                else if (mortarType.equals("highStrength")) factor = 0.020;
14                else if (mortarType.equals("lightweight")) factor = 0.016;
15                break;
16            case "stonework":
17                if (mortarType.equals("standard")) factor = 0.028;
18                else if (mortarType.equals("highStrength")) factor = 0.030;
19                else if (mortarType.equals("lightweight")) factor = 0.026;
20                break;
21            case "tiling":
22                if (mortarType.equals("standard")) factor = 0.008;
23                else if (mortarType.equals("highStrength")) factor = 0.010;
24                else if (mortarType.equals("lightweight")) factor = 0.007;
25                break;
26            case "plastering":
27                if (mortarType.equals("standard")) factor = 0.016;
28                else if (mortarType.equals("highStrength")) factor = 0.018;
29                else if (mortarType.equals("lightweight")) factor = 0.014;
30                break;
31        }
32        
33        return area * factor;
34    }
35    
36    public static double calculateBags(double volume, String mortarType, String unit) {
37        double bagsPerVolume = 0.0;
38        
39        if (unit.equals("metric")) {
40            if (mortarType.equals("standard")) bagsPerVolume = 40.0;
41            else if (mortarType.equals("highStrength")) bagsPerVolume = 38.0;
42            else if (mortarType.equals("lightweight")) bagsPerVolume = 45.0;
43        } else if (unit.equals("imperial")) {
44            if (mortarType.equals("standard")) bagsPerVolume = 1.13;
45            else if (mortarType.equals("highStrength")) bagsPerVolume = 1.08;
46            else if (mortarType.equals("lightweight")) bagsPerVolume = 1.27;
47        }
48        
49        return volume * bagsPerVolume;
50    }
51    
52    public static void main(String[] args) {
53        double area = 50.0; // מ²
54        String constructionType = "bricklaying";
55        String mortarType = "standard";
56        String unit = "metric";
57        
58        double volume = calculateMortarVolume(area, constructionType, mortarType);
59        double bags = calculateBags(volume, mortarType, unit);
60        
61        System.out.printf("נפח מלט: %.2f מ³%n", volume);
62        System.out.printf("מספר שקיות: %d%n", (int)Math.ceil(bags));
63    }
64}
65