SPD Simulator For DIY Builders

ChiefRunningPhist

Drunk on Knowledge
Creating a custom SPD (Spectral Power Distribution, ie spectrum) can be confusing. This might help reduce some ambiguity in determining how much of a light is needed, or how much of a certain color is required to supplement proportionately, ie Far Red, UV, ect. Once you've entered in an approximation of your system it should be fairly easy to test a range of different colors and CCTs at various power levels and point source quantities to achieve the SPD in the proportionality you're after (amoung other things). There are various background curves to help guide and give reference.

Attached is an SPD simulator built in Excel. I use a 4K TV as my monitor so you may need to adjust your zoom setting in excel to match the monitor size you are using more closely.

v5.72.zip
- 04.12.21
- updated LM301H efficiency scaling.

v5.1.zip - older - has both low res & hi res files, but low res just removes some bold formatting, so its not much different.

The spreadsheet is built based on this conversion constant...
0807191816b.jpg
^^^Talked about in more detail here...


CIE luminous functions were downloaded rather than digitized, the McCree yield curves were digitized. UVI is based upon a digitized erythemal function.


SPD Simulator v5.6 screenshot...
SPD Simulator v5.6 SS.png


How I digitize graphs...
*up to 7,000 data points now

v5.1 run through video...




Good luck! :)
 

Attachments

Last edited:
Top