Developing an excel panelboard program
- Thread starter Pietenpol
- Start date
- Status
Sample panelboard sheet
Sample panelboard sheet
https://www.dropbox.com/s/27bczj5ev2551l3/santa maria beta.xls
I modify circuit description, breaker sizes and loads per job but everything else automatically calcs and updates.
Sample panelboard sheet
https://www.dropbox.com/s/27bczj5ev2551l3/santa maria beta.xls
I modify circuit description, breaker sizes and loads per job but everything else automatically calcs and updates.
Last edited:
- Location
- Chapel Hill, NC
- Occupation
- Retired Electrical Contractor
I get a message that says the program has unreadable contents
I got the former ods version to open in Excel 2010, but all the formulas where lost... only values made it through. The xls version opens in Excel with formulas intact AFAICT.
https://www.dropbox.com/s/w9c1u8rp2nhvytr/santa maria.xls
This version should make all the approriate changes when you modify any coded values on the circuits. A change on B should carry through to panel A etc.
This version should make all the approriate changes when you modify any coded values on the circuits. A change on B should carry through to panel A etc.
Ragin Cajun
Senior Member
- Location
- Upstate S.C.
Where you have all the "FALSE" results, change the formulas to include double "" so the entry is blank, such as =IF(Q9="L",((K9*0.25)/1000),""). Removes confusing clutter.
Enter the "POLE" on the same line as the TRIP, makes it easier to read.
I trust this schedule is not "real" as there are NO spares!
UNLOCK the cells that are used for user input.
RC
Enter the "POLE" on the same line as the TRIP, makes it easier to read.
I trust this schedule is not "real" as there are NO spares!
UNLOCK the cells that are used for user input.
RC
kingpb
Senior Member
- Location
- SE USA as far as you can go
- Occupation
- Engineer, Registered
My input -
1. The voltage you selected is 120/208V, which is NOT 3 phase, 4 wire. Please refer to Note (d) from ANSI C92.2; the voltage should be stated as 208Y/120V.
2. The schedule is not very automated. It doesn't even use the voltage stated.
3. What does "coded" mean?
4. There is an error where it says VA when it is actually KVA.
5. The amps calculated is based on total 3 phase KVA, but that does you no good if the average amps is less than any one of the individual phases. MCA should be based on the largest phase, KVA.
1. The voltage you selected is 120/208V, which is NOT 3 phase, 4 wire. Please refer to Note (d) from ANSI C92.2; the voltage should be stated as 208Y/120V.
2. The schedule is not very automated. It doesn't even use the voltage stated.
3. What does "coded" mean?
4. There is an error where it says VA when it is actually KVA.
5. The amps calculated is based on total 3 phase KVA, but that does you no good if the average amps is less than any one of the individual phases. MCA should be based on the largest phase, KVA.
The calcs on the side are shown just for my own use while creating this sheet. They wont be on the final version. There are spares included in the updated version I posted. Eventually it will have cross checks and color coded errors for overloaded breakers and unblanced phases
- Location
- Chapel Hill, NC
- Occupation
- Retired Electrical Contractor
It works now and I agree get rid of the false by inserting quotations with nothing between them
- Status