Search

Premium Membership ♕

Save 10% on Pro Membership Plan with coupon DEC10 and study specialized LV/MV/HV technical articles and papers.

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
Price:Free
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

15 Comments


  1. SAFDAR
    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 ?.


  2. DEEPAK SIRSAT GOA
    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.
    Thank


  9. GORDON ALLISON
    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

    sir
    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

    Hello,
    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

    Hello.

    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!

nineteen  −    =  17

Learn How to Design Power Systems

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

EEP Hand-Crafted Video Courses

Check more than a hundred hand-crafted video courses and learn from experienced engineers. Lifetime access included.
Experience matters. Premium membership gives you an opportunity to study specialized technical articles, online video courses, electrical engineering guides, and papers written by experienced electrical engineers.