{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["2016 Electric Load Calculator"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"2016 Electric Load Calculator","index":0,"n_rows":82,"n_cols":12,"rows_kept":82,"cut":false,"hidden":false,"merged":[[58,1,58,3],[57,1,57,3],[56,1,56,9],[55,1,55,9],[48,2,48,3],[48,7,48,8],[52,8,52,9],[53,7,53,9],[54,7,54,9],[49,2,49,3],[49,7,49,8],[50,2,50,3],[50,7,50,8],[51,2,51,3],[51,7,51,8],[43,2,43,3],[43,7,43,8],[44,6,44,9],[45,6,45,9],[47,2,47,3],[47,7,47,8],[40,2,40,3],[40,7,40,8],[41,2,41,3],[41,7,41,8],[42,2,42,3],[42,7,42,8],[37,2,37,3],[37,7,37,8],[38,2,38,3],[38,7,38,8],[39,2,39,3],[39,7,39,8],[25,5,25,7],[26,5,26,7],[27,6,27,9],[34,7,34,9],[36,2,36,3],[36,7,36,8],[29,2,29,4],[30,2,30,4],[31,2,31,4],[32,2,32,4],[33,2,33,4],[11,4,11,7],[13,5,13,7],[14,5,14,9],[19,6,19,9],[24,5,24,7],[9,2,10,8],[1,9,1,11],[2,9,2,11],[3,1,3,11],[4,2,4,4],[5,2,5,8],[6,6,6,7],[7,4,7,7],[8,2,8,4],[1,2,1,3]]}
[]
[null,null,"City of Naperville",null,null,null,null,null,"Application #"," "]
[null,null,null,null,null,null,null,null,"Address :"," "]
[null,"2017  Dwelling Unit Electric Service & Feeder Load Calculator"]
[null,220.12,"General Lighting Load"]
[null,null,"3 va/ft2 of floor area, including unused space adaptable for future use."]
[null,null,null,null,null,null,"Floor Area =",null,null,"ft2",{"$f":"3*I7","v":0},"va"]
[null,null,null,null,"Basement Floor Area =",null,null,null,null,"ft2",{"$f":"3*I8","v":0},"va"]
[null,"220.52(A)","Small Appliance Load"]
[null,null,"1500 va for each 20 amp branch circuit required per 210.1(C)(1) in EACH kitchen, pantry, breakfast room, dining room, or similar areas."]
[]
[null,null,null,null,"# of Small Appliance Branch Circuits =",null,null,null,0,"x 1500 va =",{"$f":"1500*I12","v":0},"va"]
[null,"220.52(B)","Laundry Load",null,null,null,null,null," "]
[null,null," ",null,null,"# of Laundry Branch Circuits =",null,null,0,"x 1500 va =",{"$f":"1500*I14","v":0},"va"]
[null,null,null,null,null,"Total General Lighting & Appliance Load=",null,null,null,null,{"$f":"SUM(K8,K12,K14,K7)","v":0},"va"]
[null,220.42,"Lighting Load Feeder Demand Factors"]
[null,null,null,null,"First 3000 or less at 100%",null,null,null,null,null,{"$f":"IF(K15>3000,3000,K15)","v":0},"va"]
[null,null,null,null,"From 3001 to 120,000 at 35%",null,null,null,null,null,{"$f":"(K15-K17)*0.35","v":0},"va"]
[null,null,null,null,"Remainder over 120,000 at 25%",null,null,null,null,null,{"$f":"IF(K15>120000,(K15-123000)*0.25,0)","v":0},"va"]
[null,null,null,null,null,null,"Total Lighting Demand Load=",null,null,null,{"$f":"SUM(K17,K18,K19)","v":0},"va"]
[null,220.54,"Electric Clothes Dryers"]
[null,null,null,"Qty",0,null,null,"Electric Dryer #1",null,"kw",{"$f":"IF(AND(I22<>0,I22<=5),5000,I22*1000)*E22","v":0},"w"]
[null,null,null,"Qty",0,null,null,"Electric Dryer #2",0,"kw",{"$f":"IF(AND(I23<>0,I23<=5),5000,I23*1000)*E23","v":0},"w"]
[null,220.55,"Electric Cooking-Ranges, Stove Tops and Wall Ovens"]
[null,null,null,"Qty",0,"Wall Oven Nameplate",null,null,0,"kw"]
[null,null,null,"Qty",0,"Electric Range Nameplate",null,null,0,"kw"]
[null,null,null,"Qty",0,"Wall Oven Nameplate",null,null,0,"kw"]
[null,null,null,null,null,null,"Electric Cooking Demand Load=",null,null,null,{"$f":"ECOOKS(I25,I26,I27,E25,E26,E27)*1000","v":0},"w"]
[null,220.51,"Fixed Electric Space Heating Loads or Air Conditioning Load:"]
[null,null,"Fixed Electric Space Heat #1 ",null,null,0,"kw","AC#1/Geo",null,null,{"$f":"IF(OR($I30=\"\",$J30=\"\"),0,(LOOKUP($J30,$G$77:$H$82)/LOOKUP($I30,$E$77:$F$81)/240))","v":0},"kva"]
[null,null,"Fixed Electric Space Heat #2 ",null,null,0,"kw","AC#2/Geo",null,null,{"$f":"IF(OR($I31=\"\",$J31=\"\"),0,(LOOKUP($J31,$G$77:$H$82)/LOOKUP($I31,$E$77:$F$81)/240))","v":0},"kva"]
[null,null,"Fixed Electric Space Heat #3 ",null,null,0,"kw","AC#3/Geo",null,null,{"$f":"IF(OR($I32=\"\",$J32=\"\"),0,(LOOKUP($J32,$G$77:$H$82)/LOOKUP($I32,$E$77:$F$81)/240))","v":0},"kva"]
[null,null,"Fixed Electric Space Heat #4 ",null,null,0,"kw","AC#4/Geo",null,null,0,"kva"]
[null,null,"Fixed Electric Space Heat #5 ",null,null,0,"kw","AC#5/Geo",null,null,0,"kva"]
[null,null,null,null,null,null,null,"Total Heat & AC Load =",null,null,{"$f":"SUM(F30:F34,K30:K34)*1000","v":0},"va"]
[null,220.14,"Appliance load--Dwelling Units"]
[null,"Qty","Description",null,"va(watts)",null,"Qty","Description",null,"va(watts)"]
[null,2,"Central Furnace",null,{"$f":"IF($C38=\"\",0,LOOKUP($C38,$C$61:$C$82,$D$61:$D$82)*B38)","v":2400},null,0,null,null,{"$f":"IF($H38=\"\",0,LOOKUP($H38,$C$61:$C$82,$D$61:$D$82)*G38)","v":0}]
[null,1,"Dishwasher",null,1200,null,0,null,null,0]
[null,1,"Refrigerator",null,1440,null,0,null,null,0]
[null,1,"Microwave",null,1580,null,0,null,null,0]
[null,1,"Range Hood",null,240,null,0,null,null,0]
[null,4,"Vent Fan",null,400,null,0,null,null,0]
[null,2,"Paddle Fan",null,180,null,0,null,null,0]
[null,null,null,null,null,null,"Total Connected Appliance Load =",null,null,null,{"$f":"SUM(E38:E44,J38:J44)","v":7440},"va"]
[null,220.53,"Appliance load--Dwelling Units",null,null,null,"Total Appliance Demand Load =",null,null,null,{"$f":"IF(SUM(B38:B44,G38:G44)>3,0.75*K45,K45)","v":5580},"va"]
[null,220.5,"Motor Loads @ 120 Volts"]
[null,"Qty","Description",null,"va(watts)",null,"Qty","Description",null,"va(watts)"]
[null,1,"1/2hpSump/EjectPump",null,{"$f":"IF(C49=\"\",0,VLOOKUP(C49,G61:H75,2,FALSE))","v":375},null,0,null,null,{"$f":"IF(H49=\"\",0,VLOOKUP(H49,G61:H75,2,FALSE))","v":0}]
[null,1,"1/2hpGarbage Disposal ",null,{"$f":"IF(C50=\"\",0,VLOOKUP(C50,G61:H75,2,FALSE))","v":375},null,0,null,null,{"$f":"IF(H50=\"\",0,VLOOKUP(H50,G61:H75,2,FALSE))","v":0}]
[null,2,"1/2hpGar/DoorOpener",null,{"$f":"IF(C51=\"\",0,VLOOKUP(C51,G61:H75,2,FALSE))","v":375},null,0,null,null,{"$f":"IF(H51=\"\",0,VLOOKUP(H51,G61:H75,2,FALSE))","v":0}]
[null,0,null,null,{"$f":"IF(C52=\"\",0,VLOOKUP(C52,G61:H75,2,FALSE))","v":0},null,0,null,null,{"$f":"IF(H52=\"\",0,VLOOKUP(H52,G61:H75,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"Total Motor Load =",null,{"$f":"SUM(B49*E49,B50*E50,B51*E51,B52*E52,G49*J49,G50*J50,G51*J51,G52*J52)","v":1500},"va"]
[null,430.24,"Several Motors or a Motor(s) and Other Load(s)",null,null,null,null,"25% of Largest Motor Load =",null,null,{"$f":"IF(K53=0,0,MAX(E49:E52,J49:J52)*0.25)","v":93.75},"va"]
[null,null,null,null,null,null,null,"Total Motor Demand Load =",null,null,{"$f":"SUM(K53:K54)","v":1593.75},"va"]
[null,"TOTAL CALCULATED DEMAND LOAD in Volt-amperes =",null,null,null,null,null,null,null,null,{"$f":"SUM(K55,K46,K35,K28,K23,K22,K20)","v":7173.75},"va"]
[null,"TOTAL CALCULATED DEMAND LOAD in AMPS @120/240V 1ph3W =",null,null,null,null,null,null,null,null,{"$f":"K56/240","v":29.890625},"amps"]
[null,"EXISTING SERVICE SIZE",null,null,"NEW","AMPS"]
[null,"MINIMUM SERVICE SIZE",null,null,{"$f":"IF(K57=0,0,IF(K57<=100,100,IF(K57<=200,200,IF(K57<=320,400,\"400CT\"))))","v":100},"AMPS",null,"CHOOSE",null,"SERVICE SIZE REQUESTED =",200,"amps"]
[]
[null,null,"Air Cleaner",600,null,null,"1/3HPpump/Eject Pump",250,null,"NEW",0]
[null,null,"Central Furnace",1200,null,null,"1/2hpSump/EjectPump",375,0,60,60]
[null,null,"Central Vacuum",1560,null,null,"3/4hpSump/EjectPump",563,1,100,100]
[null,null,"Dishwasher",1200,null,null,"1/3hpGar/DoorOpener",250,2,125,125]
[null,null,"ERV/HRV",120,null,null,"1/2hpGar/DoorOpener",375,3,150,150]
[null,null,"Elec Car Charger",7000,null,null,"1/3hpGarbage Disposal ",250,4,200,200]
[null,null,"Freezer",1440,null,null,"1/2hpGarbage Disposal ",375,5,250,250]
[null,null,"Instant Hot Water",360,null,null,"Elevator",2100,6,300,300]
[null,null,"Landscape Ltg",500,null,null,"Hydromassage Tub",900,7,350,350]
[null,null,"Microwave",1580,null,null,"1/3hpPool/Spa Pump ",250,8,400,400]
[null,null,"Other",0,null,null,"1/2hpPool/Spa Pump",375,9,450,450]
[null,null,"Paddle Fan",90,null,null,"3/4hpPool/Spa Pump ",563,10,500,500]
[null,null,"Range Hood",240,null,null,"1hpPool/Spa Pump ",750,null,550,550]
[null,null,"Refrigerator",1440,null,null,"1.5hpPool/Spa Pump",1125,null,600,600]
[null,null,"Spa/Hot Tub",12000,null,null,"2hpPool/Spa Pump ",1500,null,650,650]
[null,null,"Steam Generator",12000,null,null,null,null,null,700,700]
[null,null,"Trash Compactor",860,"13 SEER",13,"1.5 Ton",7100,null,800,800]
[null,null,"Vent Fan",100,"14 SEER",14,"2 Ton",10250]
[null,null,"Warming Drawer",1800,"15 SEER",15,"2.5 Ton",13750,"Electric Cooktop Nameplate"]
[null,null,"Water Heater",300,"16 SEER",16,"3 Ton",13900,"Electric Range Nameplate"]
[null,null,"Whole House Fan",350,"17 SEER",17,"4 Ton",19500,"Wall Oven Nameplate"]
[null,null,"Wine Cooler",360,null,null,"5 Ton",21950]