Lighting Design Calculation Excel Sheet Download

Lighting design calculation is a crucial aspect of creating effective and efficient lighting systems for various types of spaces, ensuring adequate illumination for tasks, safety, and aesthetics. Here’s a step-by-step guide to performing lighting design calculations, along with the key factors to consider.

Steps for Lighting Design Calculation

1. Determine the Purpose and Requirements of the Space:
   • Identify the type of space (e.g., office, classroom, warehouse, living room).
   • Determine the required illuminance levels (measured in lux or foot-candles) based on standards and guidelines, such as those provided by the Illuminating Engineering Society (IES) or local building codes.
2. Collect Room and Surface Information:
   • Measure the dimensions of the room (length, width, height).
   • Note the reflectance values of the room surfaces (walls, ceiling, floor).
3. Choose the Light Fixtures:
   • Select appropriate light fixtures based on the type of lighting (e.g., general, task, accent) and the desired light distribution.
   • Gather photometric data for the chosen fixtures, which includes information on light output (lumens), distribution patterns, and efficacy.
4. Calculate the Total Luminous Flux Required:
   • Use the formula:Total Luminous Flux(𝑙𝑚)=Illuminance(𝑙𝑢𝑥)×Area(𝑚2)Total Luminous Flux(lm)=Illuminance(lux)×Area(m2)
   • For example, if the required illuminance is 500 lux and the area is 20 square meters:Total Luminous Flux=500 lux×20 m2=10,000 lumensTotal Luminous Flux=500lux×20m2=10,000lumens
5. Determine the Number of Fixtures:
   • Divide the total luminous flux by the lumen output of a single fixture:Number of Fixtures=Total Luminous FluxLumen Output per FixtureNumber of Fixtures=Lumen Output per FixtureTotal Luminous Flux​
   • For example, if each fixture provides 2000 lumens:Number of Fixtures=10,000 lumens2000 lumens/fixture=5 fixturesNumber of Fixtures=2000lumens/fixture10,000lumens​=5fixtures
6. Consider the Light Loss Factor (LLF):
   • LLF accounts for real-world conditions that reduce light output, such as fixture dirt depreciation and lamp lumen depreciation.
   • Apply the LLF to adjust the number of fixtures:Adjusted Number of Fixtures=Number of FixturesLLFAdjusted Number of Fixtures=LLFNumber of Fixtures​
   • For example, if LLF is 0.8:Adjusted Number of Fixtures=50.8=6.25≈7 fixturesAdjusted Number of Fixtures=0.85​=6.25≈7fixtures
7. Verify and Optimize the Design:
   • Use lighting design software (e.g., DIALux, AGi32, Relux) to create a detailed layout and perform more precise calculations.
   • Ensure uniformity of illumination and adjust fixture placement as needed to avoid shadows and glare.

Example Calculation

Let’s perform a simplified example calculation for an office space.

Inputs:

• Room dimensions: 10m (length) x 5m (width) x 3m (height)
• Required illuminance: 500 lux
• Reflectance values: Ceiling (0.8), Walls (0.5), Floor (0.2)
• Light fixture: LED panel, 3000 lumens each
• LLF: 0.8

Calculation Steps:

1. Calculate the Area:Area=10 m×5 m=50 m2Area=10m×5m=50m2
2. Calculate Total Luminous Flux:Total Luminous Flux=500 lux×50 m2=25,000 lumensTotal Luminous Flux=500lux×50m2=25,000lumens
3. Determine Number of Fixtures:Number of Fixtures=25,000 lumens3000 lumens/fixture≈8.33≈9 fixturesNumber of Fixtures=3000lumens/fixture25,000lumens​≈8.33≈9fixtures
4. Apply Light Loss Factor:Adjusted Number of Fixtures=90.8≈11.25≈12 fixturesAdjusted Number of Fixtures=0.89​≈11.25≈12fixtures

Final Design and Verification

• Using lighting design software, place the 12 fixtures in a grid layout to ensure even distribution.
• Verify the uniformity ratio (the ratio of average illuminance to minimum illuminance) to ensure good lighting quality.
• Adjust fixture positions if necessary to avoid glare and shadows.

Tools and Software

• DIALux: Widely used for comprehensive lighting design, including indoor and outdoor applications.
• AGi32: Professional software for detailed lighting analysis and visualization.
• Relux: Another popular tool for lighting simulation and design.
• IES Standards: Refer to the Illuminating Engineering Society standards for recommended illuminance levels and design guidelines.

Conclusion

Lighting design calculation is essential for creating effective lighting systems that meet the specific needs of different spaces. By following these steps and using appropriate tools, you can ensure that your lighting design is both efficient and effective, providing adequate illumination while optimizing energy use.

Note: All Password are [“salaimep” or “salaimep.com”]

Download |OneDrive , Google Drive

Also Download – Voltage Drop Calculation Software Download