Premium Membership ♕

Save 50% on all EEP Academy courses with Enterprise Membership Plan and study specialized LV/MV/HV technical articles & guides.

Home / Download Center / Electrical Software Reviews / Calculate Size of Air Conditioning For Room
Size of Air Conditioning For Room - MS Excel Spreadsheet
Size of Air Conditioning For Room – MS Excel Spreadsheet

Introduction to spreadsheet

The following calculation spreadsheet is used to determine the capacity of room air conditioner:

  1. Size of Air Conditioning for Your Room
  2. AC Size in BTU/Hr
  3. AC size in Tone
  4. Heating and Cooling BTU

Following Room Details are inputs:

  • Length of room(foot)
  • Width of room(foot)
  • Windows in north side
  • Window in south side
  • Total room area in sq.foot
  • Is there any blinds on the windows?
  • Number of persons who may utilize the room
  • Electrical Appliances in The Room:
    • Electrical Equipment
    • Electrical Lighting
Software:Calculate size of air conditioning for room
Version:22.8.2012 New
Developer:Jignesh Parmar
Size:43 kB
Downloads:Right here | Video Courses | Membership | Download Updates
Calculate size of air conditioning for room
Calculate size of air conditioning for room

Premium Membership

Get access to premium HV/MV/LV technical articles, advanced electrical engineering guides, papers, and much more! It will help you to shape up your technical skills in your everyday life as an electrical engineer.
50% Discount 💥 - Save 50% on all 90+ video courses with Enterprise Membership plan.

More Information


    May 19, 2020

    one CFPP MV electrical panal room of a industrial building having the size of 10Mx18Mx4M. The panals heat load for electrical equipment is 54-KW.
    How much will be the total cooling requirement ?.

    Feb 20, 2019

    Dear Friend,
    Thank you so much, I am very grateful to you for sharing your hard work

  3. Noriza
    Jan 29, 2019

    Thank you, Jignesh.

  4. uditha
    Dec 21, 2018

    was really helpful. thanks for the effort :-)

  5. Johnattan
    Sep 21, 2018

    Great article about air conditioning! Thank you my friend for sharing this.

  6. Vikash Dwivedi
    Apr 21, 2018

    What should i enter into electrical equipment i.e. actual rating of equipment in watt or i have to enter Heat Dissipation in watt.

  7. Prashanth
    Apr 15, 2018

    How to download excel spread sheet

  8. Richard
    Jan 04, 2018

    Dear all,
    I am interested in using the spread sheet but I have an issue. The spread sheet requires a password so as to edit, what’s the password.

    Apr 25, 2017

    air con calculation looks ok. What are the chances of modifying it to work for a substation, where
    the amount of DOL drives, amount of free standing VSD drives of different KW ratings and soft starters are installed. Therefore taking into consideration the heat generated by each of these units.
    sub station will have no windows and fire proof door [steel/flameproof coated wood]
    one to consider all drives running 24hrs.

  10. Gopi
    Jan 03, 2016

    I hope, we must consider the volume of the room in calculations. Since heat transfer coefficient value for window is higher compared to bricks wall, we shall consider the windows in all directions.

  11. shabmanu
    May 18, 2015

    what if the the window is in east and west? ,do we need to consider door?

    thanks in advance

  12. shabmanu
    May 18, 2015

    thanks for the spread sheet

    if the window is facing east or west ,what will be the changes in calculation ,do i need to consider door measurement ,waiting for ur reply ,thanks

  13. Hayder
    Oct 23, 2014

    It is wonderful excel sheet, but how can I calculate the AC capacity without input the height of building, I have a room 20×10 m2 and 12 m height and the result of this sheet does not match the requirement.

  14. andrewelec
    Aug 28, 2013


    How can we make a correction to external temperature?

  15. Mohamed Shafei
    Mar 05, 2013

    I cannot download the file

Leave a Comment

Tell us what you're thinking. We care about your opinion! Please keep in mind that comments are moderated and rel="nofollow" is in use. So, please do not use a spammy keyword or a domain as your name, or it will be deleted. Let's have a professional and meaningful conversation instead. Thanks for dropping by!

thirty six  −    =  twenty nine

Learn How to Design Power Systems

Learn to design LV/MV/HV power systems through professional video courses. Lifetime access. Enjoy learning!

Subscribe to Weekly Newsletter

Subscribe to our Weekly Digest newsletter and receive free updates on new technical articles, video courses and guides (PDF).
EEP Academy Courses - A hand crafted cutting-edge electrical engineering knowledge