HomeMy WebLinkAboutB18-0108_approved plans_1525104200.pdfR-3 Townhouse
04/30/18
04/30/18
04/30/18
04/30/18
04/30/18
04/30/18
04/30/18
04/30/18
Water Heater Refrigerator Freezer Dishwasher Disposal
GAS 1,400 VA 600 VA 1,030 VA 690 VA
4,500 VA 1,500 VA 700 VA 1,100 VA 828 VA
3,500 VA 1,600 VA 800 VA 1,200 VA 1,127 VA
6,000 VA 1,700 VA 900 VA 1,300 VA 1,587 VA
9,000 VA 1,800 VA 1,000 VA 1,400 VA 1,840 VA
28,800 VA 1,900 VA
2,000 VA
Microwave Mini Refrig Wine Clr Insta Hot R / Hood
1,440 VA 170 VA 400 VA 5,000 VA 400 VA
1,600 VA 230 VA 780 VA 7,500 VA 540 VA
1,800 VA 340 VA 850 VA 10,000 VA 700 VA
4,000 VA 12,500 VA
Yellow cells
Enter numer
Central Air Strip Heat Units
Select Blower/fan Total Load Blue cells
5kW + 800VA = 5,800 VA
7.5kW + 800VA = 8,300 VA
8kW + 800VA = 8,800 VA Cond
9.6kW + 1,200VA = 10,800 VA Select
10 kW + 1,600VA = 11,600 VA 1 ton
12.5 kW + 1,600VA = 14,100 VA 1.5 ton
14.4 kW + 1,600VA = 16,000 VA 2 ton
17.5 kW + 2,400VA = 19,900 VA 2.5 ton
20 kW + 2,400VA = 22,400 VA 3 ton
+ = 0 VA 3.5 ton
4 ton
5 ton
!1
04/30/18
!2
04/30/18
!3
04/30/18
!4
04/30/18
Microwave
1/4hp 1,630 VA
1/3hp 1,000 VA
1/2hp 1,100 VA
3/4hp 1,200 VA
1 hp 1,300 VA
1,400 VA
1,500 VA
1,700 VA
Ironing Center
1,500 VA
1,800 VA
2,400 VA
ells are fixed and the first value is the
default
ondensing Units / Heat Pumps Supplementary Heat & Blower
Condensing Unit Heat Pump Select Blower/fan Total Load
1,840VA 2.5 kW + 1,200VA = 3,700VA
2,200VA 2,230VA 3 kW + 800VA = 3,800VA
2,850VA 3,100VA 4 kW + 1,000VA = 5,000VA
3,600VA 3,496VA 4.5 kW + 1,200VA = 5,700VA
4,275VA 4,370VA 10 kW + 1,600VA = 11,600VA
5,000VA 5,152VA 6.5 kW + 1,600VA = 8,100VA
5,700VA 5,313VA 7.5 kW + 1,600VA = 9,100VA
7,130VA 6,371VA + = 0VA
+ = 0VA
+ = 0VA
!5
04/30/18
!6
04/30/18
!7
04/30/18
!8
04/30/18
!9
04/30/18
!10
04/30/18
!11
04/30/18
!12
04/30/18
Residential Standard Calculation 9/25/97 LUSK RESIDENCE: 1476 Westhaven drive, Unit 18 STANDARD A/C
by: John Sokolik Version 2011 L
STEP 1 Article 220.42 & 220.52 Cobalt Electric standard optional standard
2100 General Lighting load 6,300 VA PO Box 71 ahu 0 0% 0 0
2 Small Appliance 3,000 VA Gypsum, CO 81637 cool 0 VA 0 VA 0 VA
1 Laundry circuit 1,500 VA (970)309-7054
Gen.Lgt, Sm App.& Laun. Load 10,800 VA 3/26/18 10:21 ahu 0 VA 0 VA 0 VA
3,000 VA @ 100%= 3,000 VA hp 0 VA 0 VA 0 VA
7,800 VA @ 35% = 2,730 VA
0 VA @ 25% = 0VA
STEP 2 Article 220.50 & 220.51 General Lighting Demand Load 5,730 VA
A/C Condenser & Fixed Electric Space Heating QTY Total 0 TRUE CU / HP AHU 1 Blower
0 VA AHU 1 1,200 VA 10 Heating Load 0 VA 0 0 VA 0 0
0 VA AHU 2 0 VA CU Load 0 VA 0 0 VA 0 0
0 VA AHU 3 0 VA 0 0 VA 0 0
0 VA AHU 4 0 VA Greater of Heat @ 100% vs.A/C @ 100% 0 VA 0 0 VA 0 0
0 VA AHU 5 0 VA 0 0 VA 0 0
STEP 3 Article 220.53 Appliance Demand Load 7,538 VA 0 Art 220.82 ( C ) (4)
1 Water Heater 4,500 VA 0 VA 0 0 Heat Load 0 Optional
1 Refrigerator 1,400 VA Dryer Demand Load 4,200 VA HP + (AHU(t) X 65%)
Freezer 0 VA DEM FACTOR 65%
1 Dishwasher 1,030 VA Range Demand Load 0 VA 0%
1 Disposal 690 VA <4 65% 0%
1 R / Hood 400 VA Service Demand 17,468 VA >3 40%
1 Microwave 1,630 VA
Microwave 0 VA Demand Load 73 A
Mini Refrig 0 VA
1 Wine Clr 400 VA Neutral Demand 71 A
Insta Hot 0 VA
Ironing Center 0 VA Min.Service Req. 100 A
Jacuzzi Tub 0 VA
Sprinkler Pump 0 VA Min. Feeder size 4
Well Pump 0 VA Min. Neutral size 4
Fountain Pump 0 VA Eq. Grding Cond. 8
Elevator 0 VA Copper
Pool Equip. Panel 0 VA 100% Demand
GATES 0 VA No Demand
Other load 0 VA No Demand Total Appliance Load 10,050 VA
4 or more demand @ 75% plus 100% demand loads 7,538 VA
STEP 4 Article 220.54
Electric Clothes Dryers 4,200 VA
STEP 5 Article 220.55
Electric Ranges 1 W Col C demand 0
or Number of appliances
Cooktop Col B demand
Cooktop Col B demand
Oven(s) 8,000 W Col B demand
Oven(s) Col B demand
Number of appliances 1 Dem. Factor 80%
Cooktop & Oven Demand Load 6,400 W
jmp1jds@comcast.net
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
Pool Panel Feeder Calculation (See Note) A B N Continuous Non-continuous
Continuous Motors 0 . . . . . . 0 0 0 Motors Motors
Non-continuous 0 . . . . . . 0 0 0 240v 240v
Spa heater 11 kVA . . . . . . 0 0 240v 240v
Pool heater 3.5 ton . . . . . . 0 0 240v 240v
Pool heater 5 ton . . . . . . 0 0 240v 240v
Pool Light 0 . . . . . . 0 0 0 240v 240v
Blower 2333 0 240v 0 0 0
other load 0 240v 0 0 0 0.0 Motor Neutral Load
other load 0 240v 0 0 0
Min.Copper Pool Feeder AWG 0 A 0 A 0 A Max.Unbalanced Neutral Load
Minimum Panel Rating 0A Phase Amperes Neut. load
0 Column C demand table 0 W These are used in the standard calc to select the lowest of col C and A
or B0 0 0
The residential load calculator spreadsheet was first conceived to assist electrical contractors by providing a set format document that followed steps
to calculate a service demand. In SW Florida this one page calculation is recognized by building department plans examiners as a tried and true calc
spreadsheet simplifying the permitting process. I want to thank the hundreds of Users over the past 13 years that have sent me e-mails as far away
as the University of Sciences of Saudi Arabia, inspiring me to continue to update for each code session.
I remember as one of Mike Holts students in 1980, he taught this simple way of calculating by Steps with each applicable code article.
Here is how it works, In Step 1 by inserting area sq ft, number of small appliance and laundry circuits. A drop-down box has been added to convert
from square feet to meters.
For Step 2, As contractors suggested the calculator was expanded from 2 HVAC units to multiple quantities. Also a check box to select between
Condensing Units or Heat Pumps. See the equipment set-up sheet tab on the bottom left to customize unit loads.
Step 3, Insert the quantity of fixed appliances. Original loads were used from the average appliance loads for the GE appliance guide. Now you can
customize HVAC and appliance loads by means of an equipment set-up sheet (this is found by the tab at the bottom left of your screen) with fixed and
new entry cells (blue cells are fixed loads, yellow cells to insert your own personal entries).
Step 4, insert number of household dryers
Step 5, Range demand, with separate entries for column A & B appliances. In Standard mode you can enter the kW for one range or just enter the
number of appliances for a Column C demand. You can then calc a Col B demand (if applicable for kW) for these appliances and the calculator will
select the smaller of the two load calculations. When using the Optional calc with a Gas Range, be sure to use the check to box or the calculation will
not total because it appears incomplete.
I attached a User Info sheet (this is found by the tab at the bottom left of your screen) added a personal company/corporate information, allowed this
sheet to be set up, saved and used time and again.
Holding your cursor over any cell with a RED marker in the upper right reveals comments or helps to guide you thru the data entry. Validation rules
have been added as a helpful feature, try entering 1 for small appliance circuits, the validation is set for 2 minimum, by clicking on cell E6 the code
article pop-up window shows the corresponding article. If the window is in your way just pull it to the side and keep entering. Press the Tab
to move from entry cell to entry cell.
If you decide you want to change from calculating a Standard calc (Art 220.42 thru 220.55) to an Optional calc (Art 220.82), just check the box in cell
D6 next to the title of the sheet, and your now working an Optional Calc.
The Neutral Calculation is always based on Art 220.42 thru 220.55 and not affected by the use of the Optional Calculation.
Locally the AHJ were requesting that the pool equipment loads be shown with pool heat pumps calculated @ 125% as continuous loads (3 hours or
more). This made for the addition of the lower section Pool Feeder Calculation. In this section the largest motor is calculated @ 125%, automatically a
pool pump selected from the continuous drop-down box the VA is multiplied by 125%, if you then select a 3.5 or 5 ton heat pump, the heat pump
becomes the largest motor and the continuous motor value changes to 100%. Other motors, like a sprinkler pump might be inserted from the non-
continuous drop-down boxes. There are two other user entries for other loads (grill, landscape lighting, etc.) that can be names and loads inserted with
check boxes for identifying neutral connected loads.
Validation rules have been applied to minimize errors when entering loads and/or quantities.
To print go to the top of the page, next to File , Edit, is View from there go down to Custom Views, I have set-up a 'calc w/ pool' and 'calc no pool'.
Select the one you want to print and press the print button
If you would like this spreadsheet to be modified to meet your own special requirements, Please e-mail me with your name and telephone number and
I will schedule a time to discuss your needs, ecalc@comcast.net
John Sokolik
Tab
!1
04/30/18
Company Name
Company Name
Address
Address
City, State, Zip Code
City, State, Zip Code
Telephone & Fax
Telephone & Fax
Serial Number
!1
04/30/18
!2
04/30/18
!3
04/30/18
!4
04/30/18
!5
04/30/18
!6
04/30/18
!7
04/30/18
!8
04/30/18
!9
04/30/18
!10
04/30/18
!11
04/30/18
!12
04/30/18