Residential Load Calculation Spreadsheet
  • Residential Load Calculation Spreadsheet
  • Residential Load Calculation Spreadsheet
  • Residential Load Calculation Spreadsheet
  • Residential Load Calculation Spreadsheet
  • Residential Load Calculation Spreadsheet
Originally published: 22/11/2017 14:01
Publication number: ELQ-60106-1
View all versions & Certificate
certified

Residential Load Calculation Spreadsheet

Spreadsheet in Excel to help you calculate residential load.

Description
This spreadsheet has been made to help electrical contractors by providing a step-by-step document to calculate a service demand.

This spreadsheet can be used to calculate the load of:

1. Appliance demand
2. Dryer demand
3. Service demand
4. Range demand
5. General lighting demand
6. Heating and CU

Notes & Instructions by the author included on the 2nd sheet: "Residential Calculation."

*Originally shared on electrical-engineering-portal.com*

This Best Practice includes
1 Downloadable Residential Load Calculator Spreadsheet in Excel

John Sokolik offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Reviews


    • 4.5 / 5 (57 votes)

      • 74%
      • 16%
      • 4%
      • 5%
      • 2%
    • Rate this Downloadable Tool

      Write a review

  • Wynand Versteeg(last updated: 13/07/2020 11:39)
  • mehdi Rahmani(last updated: 09/06/2020 19:46)
  • Jonathan Palumbo(last updated: 29/05/2020 12:22)
  • CHRIS DOERTING(last updated: 10/04/2020 16:02)
  • Peter Starr(last updated: 01/04/2020 15:41)
  • Barry(last updated: 09/02/2020 22:25)
  • MATIUS FLOREZ(last updated: 29/01/2020 21:03)
  • Ashish Patel(last updated: 02/01/2020 14:57)
  • Bryan Peterson(last updated: 26/12/2019 22:38)
    Out of Date
    This is a great starting tool to check your work and compare it to the recent code years (2017 or 2020) but it no longer is accepted by AHJs if you wish to use it for a permit. In the 2011 version there was a section that told you minimum wire size for the service feeder, but that is gone in this version.Column C does not properly calculate if you use number of appliances (cell G45) instead of faceplate rating (Cell G44). You have to use faceplate rating if you have electrical appliances, otherwise the service is under sized.
  • Rashid Akbar KaimKhani(last updated: 11/12/2019 09:22)
  • Ronald Leach(last updated: 14/11/2019 19:50)
  • Shuk Ran(last updated: 09/11/2019 04:37)
  • Osama Aqel(last updated: 25/10/2019 07:28)
  • Atul Mahajan(last updated: 09/10/2019 19:08)
  • Vincent Anderson(last updated: 29/09/2019 14:53)
  • Md Rahman(last updated: 14/09/2019 06:34)
  • Pete Mogab(last updated: 11/09/2019 01:04)
    All cells don't work correctly
    Can't get Column C number of appliances to calculate. It only adds the neutral load, not the demand
  • Masaki Ishii(last updated: 06/09/2019 05:58)
  • Paula Stemler(last updated: 05/09/2019 07:33)
  • Jacob Cu(last updated: 11/08/2019 06:04)
  • Jose Larios(last updated: 03/08/2019 00:49)
  • Maurice Smulders(last updated: 24/07/2019 04:30)
  • David Uchetel(last updated: 18/07/2019 11:43)
  • Bhupendra Vishwakarma(last updated: 16/07/2019 09:15)
  • Juan Pablo Villarroel(last updated: 12/07/2019 14:26)
  • khan6525(last updated: 02/07/2019 06:35)
  • Magesh Shankar(last updated: 17/06/2019 09:26)
  • Gustavo Cuárez(last updated: 22/05/2019 14:04)
  • Jeanpy Julva(last updated: 17/05/2019 13:42)
  • Guillermoir(last updated: 25/04/2019 07:05)

keyboard_arrow_downShow all


keyboard_arrow_leftkeyboard_arrow_right

Related categories


See all
keyboard_arrow_leftkeyboard_arrow_right

Discussion feed for Residential Load Calculation Spreadsheet

The user community and author are here to help. Go ahead!

  • Bryan Peterson
    I see the latest version is for 2014. With the 2020 code year out, will this be updated to match the new changes?
    arrow_drop_uparrow_drop_downReply reply
    • Ernest Silcox
      LOOKING FOR EXCEL SPREADSHEET FOR MULI-RESIDENTIAL NEC 220.84
      arrow_drop_uparrow_drop_downReply reply


      4.5 / 5 (57 votes)

      please wait...