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 / Number of Lighting Fittings and Lumen Output

Lighting lumen calculation sheet

This MS Excel spreadsheet calculates the following parameters:

  • Total Lumen Output for particular Area
  • Total No of Lighting Lamps
  • Total No of Lighting Fixtures
  • Number of Fittings along with the Length and Width of Room
Software:Number of Lighting Fittings and Lumen Output
Version:22.8.2012 New
Developer:Jignesh Parmar
Size:72 Kb
Download:Right here | Video Courses | Membership | Download Updates

Number of Lighting Fittings and Lumen Output

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


    Oct 05, 2022

    please, I need pasword for unprotect sheet, thanks

  2. fahmi Ahmed
    Nov 22, 2020

    need your supporting design for lighting protection for our new project

  3. Ruwan
    Oct 25, 2020

    what is the meaning of Lux- (chart indicated)

  4. Nozad
    Feb 25, 2020

    please the password for protect sheet —- thanks

  5. rudresh
    Sep 11, 2019

    hello jignesh, i have downloaded the sheet of Number of Lighting Fittings and Lumen Output.
    but it is a protected sheet. though it says free to download. what do i do?

  6. John Terzuoli
    Oct 28, 2018

    I have a question about brightness level. If I have a fixture with a single bulb producing 400 lumens. Would replacing it with a fixture containing two 400 bulbs increase the brightness or am I just maintaining the same 400 lumens of brightness and obtaining greater dispersion because of the two bulbs.

  7. sharullahwali
    Apr 08, 2018

    As I saw itis really a big service and I appreciate this your good job

  8. Aniruddha Murgudkar
    Mar 23, 2016

    I want to make lighting design for stadium , with high mast, ICC and FIFA standard. which basic data or software, excel spread sheets will give the correct results ?

  9. Deepak Pakharia
    Sep 15, 2014

    Please provide me technical help related to “Lighting lumen calculation sheet” that if we taken different types of fixture & lamp, Then how can we calculate lumen output and no of fixtuer & lamp as per give dimension & desire lux level.

  10. Amit
    May 14, 2014

    I need techinal help in developing some software , please share the contact details.

  11. chuckm
    Jun 20, 2012

    Has anyone found a reliable inverse square law for lighting that works well in excel? I am trying to find one to use with Physical Security applications.
    My scenario changes with each application but in general, I have a light fixture that produces “X” Lux or FC’s. I have an object that is “X” feet away from the light source. I use the inverse square law to identify the lux rating at the target object. I now have a new “source” because I am reversing distance to go back to a CCTV camera using the reflectance of the original source off of the object at the farthest point. Working the formula back and allowing for some loss at my new source object (where it doesn’t reflect 100% of what it received) I can look at a spec sheet and know whether or not the CCTV camera: A) has enough light to stay in color or black and white B) if the light levels are too low C) what the delta is for the lighting specialist to add illumination so that the camera operates as desired.

    LinkedIn Jay C McCormick, PSP

    Any assistance on this would be greatly appreciated… – Chuck

    Dec 20, 2011


    • Edvard
      Dec 20, 2011

      You should contact mr. Jignesh Parmar at

  13. mmoli
    Aug 11, 2011

    very easy and useful

  14. Edvard
    Jun 25, 2011

    There are many of them available on the internet. On EEP you can find very good lighting software CalcuLuX Area, DiaLUX, Relux and others. They all have 2D and 3D preview of project, and they are also free.

    Take a look at page with electrical software:

    Best regards

  15. SAM
    Jun 24, 2011

    The WorkSheet is usefull but may i know is there any other tools which can let me see the outcome in terms of 2D or 3D view ?

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!

five  ×  6  =  

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