1def calculate_junction_box_size(wire_count, wire_gauge, conduit_count, include_ground_wire):
2    # Wire volume requirements in cubic inches
3    wire_volumes = {
4        "14": 2.0,
5        "12": 2.25,
6        "10": 2.5,
7        "8": 3.0,
8        "6": 5.0,
9        "4": 6.0,
10        "2": 8.0,
11        "1/0": 10.0,
12        "2/0": 11.0,
13        "3/0": 12.0,
14        "4/0": 13.0
15    }
16    
17    # Standard box sizes and volumes
18    standard_boxes = {
19        "4×1-1/2": 12.5,
20        "4×2-1/8": 18.0,
21        "4-11/16×1-1/2": 21.0,
22        "4-11/16×2-1/8": 30.3,
23        "4×4×1-1/2": 21.0,
24        "4×4×2-1/8": 30.3,
25        "4×4×3-1/2": 49.5,
26        "5×5×2-1/8": 59.0,
27        "5×5×2-7/8": 79.5,
28        "6×6×3-1/2": 110.0,
29        "8×8×4": 192.0,
30        "10×10×4": 300.0,
31        "12×12×4": 432.0
32    }
33    
34    # Check if wire gauge is valid
35    if wire_gauge not in wire_volumes:
36        raise ValueError(f"Invalid wire gauge: {wire_gauge}")
37    
38    # Calculate total wire count including ground
39    total_wire_count = wire_count + 1 if include_ground_wire else wire_count
40    
41    # Calculate required volume
42    required_volume = total_wire_count * wire_volumes[wire_gauge]
43    
44    # Add volume for device/equipment
45    required_volume += wire_volumes[wire_gauge]
46    
47    # Add volume for conduit entries
48    required_volume += conduit_count * wire_volumes[wire_gauge]
49    
50    # Add 25% safety factor
51    required_volume *= 1.25
52    
53    # Round up to nearest cubic inch
54    required_volume = math.ceil(required_volume)
55    
56    # Find appropriate box size
57    recommended_box = "Custom size needed"
58    smallest_sufficient_volume = float('inf')
59    
60    for box_size, volume in standard_boxes.items():
61        if volume >= required_volume and volume < smallest_sufficient_volume:
62            recommended_box = box_size
63            smallest_sufficient_volume = volume
64    
65    return {
66        "required_volume": required_volume,
67        "recommended_box": recommended_box
68    }
69
70# Example usage
71import math
72result = calculate_junction_box_size(6, "12", 2, True)
73print(f"Required volume: {result['required_volume']} cubic inches")
74print(f"Recommended box size: {result['recommended_box']}")
75

1import java.util.HashMap;
2import java.util.Map;
3
4public class JunctionBoxCalculator {
5    // Wire volume requirements in cubic inches
6    private static final Map<String, Double> wireVolumes = new HashMap<>();
7    // Standard box sizes and volumes
8    private static final Map<String, Double> standardBoxes = new HashMap<>();
9    
10    static {
11        // Initialize wire volumes
12        wireVolumes.put("14", 2.0);
13        wireVolumes.put("12", 2.25);
14        wireVolumes.put("10", 2.5);
15        wireVolumes.put("8", 3.0);
16        wireVolumes.put("6", 5.0);
17        wireVolumes.put("4", 6.0);
18        wireVolumes.put("2", 8.0);
19        wireVolumes.put("1/0", 10.0);
20        wireVolumes.put("2/0", 11.0);
21        wireVolumes.put("3/0", 12.0);
22        wireVolumes.put("4/0", 13.0);
23        
24        // Initialize standard box sizes
25        standardBoxes.put("4×1-1/2", 12.5);
26        standardBoxes.put("4×2-1/8", 18.0);
27        standardBoxes.put("4-11/16×1-1/2", 21.0);
28        standardBoxes.put("4-11/16×2-1/8", 30.3);
29        standardBoxes.put("4×4×1-1/2", 21.0);
30        standardBoxes.put("4×4×2-1/8", 30.3);
31        standardBoxes.put("4×4×3-1/2", 49.5);
32        standardBoxes.put("5×5×2-1/8", 59.0);
33        standardBoxes.put("5×5×2-7/8", 79.5);
34        standardBoxes.put("6×6×3-1/2", 110.0);
35        standardBoxes.put("8×8×4", 192.0);
36        standardBoxes.put("10×10×4", 300.0);
37        standardBoxes.put("12×12×4", 432.0);
38    }
39    
40    public static class BoxSizeResult {
41        private final double requiredVolume;
42        private final String recommendedBox;
43        
44        public BoxSizeResult(double requiredVolume, String recommendedBox) {
45            this.requiredVolume = requiredVolume;
46            this.recommendedBox = recommendedBox;
47        }
48        
49        public double getRequiredVolume() {
50            return requiredVolume;
51        }
52        
53        public String getRecommendedBox() {
54            return recommendedBox;
55        }
56    }
57    
58    public static BoxSizeResult calculateJunctionBoxSize(
59            int wireCount, String wireGauge, int conduitCount, boolean includeGroundWire) {
60        
61        // Check if wire gauge is valid
62        if (!wireVolumes.containsKey(wireGauge)) {
63            throw new IllegalArgumentException("Invalid wire gauge: " + wireGauge);
64        }
65        
66        // Calculate total wire count including ground
67        int totalWireCount = includeGroundWire ? wireCount + 1 : wireCount;
68        
69        // Calculate required volume
70        double requiredVolume = totalWireCount * wireVolumes.get(wireGauge);
71        
72        // Add volume for device/equipment
73        requiredVolume += wireVolumes.get(wireGauge);
74        
75        // Add volume for conduit entries
76        requiredVolume += conduitCount * wireVolumes.get(wireGauge);
77        
78        // Add 25% safety factor
79        requiredVolume *= 1.25;
80        
81        // Round up to nearest cubic inch
82        requiredVolume = Math.ceil(requiredVolume);
83        
84        // Find appropriate box size
85        String recommendedBox = "Custom size needed";
86        double smallestSufficientVolume = Double.MAX_VALUE;
87        
88        for (Map.Entry<String, Double> entry : standardBoxes.entrySet()) {
89            String boxSize = entry.getKey();
90            double volume = entry.getValue();
91            
92            if (volume >= requiredVolume && volume < smallestSufficientVolume) {
93                recommendedBox = boxSize;
94                smallestSufficientVolume = volume;
95            }
96        }
97        
98        return new BoxSizeResult(requiredVolume, recommendedBox);
99    }
100    
101    public static void main(String[] args) {
102        BoxSizeResult result = calculateJunctionBoxSize(6, "12", 2, true);
103        System.out.println("Required volume: " + result.getRequiredVolume() + " cubic inches");
104        System.out.println("Recommended box size: " + result.getRecommendedBox());
105    }
106}
107

1' Excel formula for junction box sizing
2' Assumes the following:
3' - Wire gauge in cell A2 (as text, e.g., "12")
4' - Wire count in cell B2 (numeric)
5' - Conduit count in cell C2 (numeric)
6' - Include ground wire in cell D2 (TRUE/FALSE)
7
8' Create named ranges for wire volumes
9' (This would be done in Name Manager)
10' WireVolume14 = 2.0
11' WireVolume12 = 2.25
12' WireVolume10 = 2.5
13' WireVolume8 = 3.0
14' etc.
15
16' Formula for required volume
17=LET(
18    wireGauge, A2,
19    wireCount, B2,
20    conduitCount, C2,
21    includeGround, D2,
22    
23    wireVolume, SWITCH(wireGauge,
24        "14", WireVolume14,
25        "12", WireVolume12,
26        "10", WireVolume10,
27        "8", WireVolume8,
28        "6", WireVolume6,
29        "4", WireVolume4,
30        "2", WireVolume2,
31        "1/0", WireVolume10,
32        "2/0", WireVolume20,
33        "3/0", WireVolume30,
34        "4/0", WireVolume40,
35        0),
36    
37    totalWireCount, IF(includeGround, wireCount + 1, wireCount),
38    
39    wireTotal, totalWireCount * wireVolume,
40    deviceTotal, wireVolume,
41    conduitTotal, conduitCount * wireVolume,
42    
43    subtotal, wireTotal + deviceTotal + conduitTotal,
44    CEILING(subtotal * 1.25, 1)
45)
46