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 / Spreadsheet For Calculation The Required Number Of Fixtures And Illuminance Level
Spreadsheet for calculation of fixture number and illuminance level
Spreadsheet for calculation of fixture number and illuminance level


This spreadsheet consist of two parts:

  1. Calculation of Numbers of Fixtures as per Sq.Ft Area and
  2. Calculation of Numbers of Fixtures / Lux for Indoor Lighting

First one as a results have following values:

  • Required Fixtures (Nos)
  • Required Lamps (Nos)
  • Required Fixture Spacing (Feet)
  • Total Kw (kW)
  • Watts per Sq.Ft
  • Energy Cost per Year

Second one (Numbers of Fixtures / Lux for Indoor Lighting) as a results have fololowing values:

  • Actual No of Fixtures
  • Actual Lux
Software:Spreadsheet For Calculation The Required Number Of fixtures And Illuminance Level
Version:10.06.2013 New
Developer:Jignesh Parmar
Size:28.7 Kb
Download:Right here | Video Courses | Membership | Download Updates
Spreadsheet For Calculation The Required Number Of fixtures And Illuminance Level
Spreadsheet For Calculation The Required Number Of fixtures And Illuminance Level

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


  1. Santosh Deshpande
    Jan 03, 2023

    Can I see the TRAIL?

  2. Bhushan
    Apr 29, 2022

    same result for 1 meter & 12 meter

    is there any solution ?
    how much it will be for 12 meter (in %)

  3. Marx Bautista
    Jan 08, 2022


  4. Sanjeev
    Sep 04, 2021

    Please mention Ref standard

  5. Christopher Balbuena
    Nov 14, 2019


    Do you have a computation for outdoor lighting like streetlights??

    Thank you!

  6. Sewa Singh
    Aug 11, 2019

    I want LED Street lighting design calculator for detail project report (DPR)

  7. Muhammad Qasim Jalal
    May 24, 2015

    Dear Mr. Parmer,
    thanks for your nice work. I use couple of sheets that you have designed.

    but for the lighting, Your calculation fails when it comes to height.
    the sheet gives same result for a height of 1 meter and a height of 100 meter.

    I will be thankful if you could send me an updated version.

    my email: engr.qasimjalal in gmail.

  8. detmar52
    Aug 25, 2013

    Dear sir
    Hereby I inform that I can’t download your spreedsheets which you have sent by e-mail.Please advise me.

  9. wbbinder
    Aug 25, 2013

    I loaded the spreadsheet into OpenOfficeOrg the open source software from Apache which can read Microsoft Word and Excel files. The calculation spreadsheet crashed the program. It is not compatible. It would be great if you could make it compatible. Sorry, I can’t tell you how, as I never got the file to load without crashing the software.

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!

3  ×  one  =  

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