DIY COB LED Calculator

bggrass

Well-Known Member
I'm a long time lurker here, not many posts, but I've learned a lot from the community. So I created a calculator to make it easier for users to look up different configurations.. Big credit given to SupraSPL for starting all this, and his spreadsheets, that I used for the actual numbers in the calculator. I have attached a screenshot. The actual calculator is in a dropbox as RIU does not recognize the file when I try to attach it to this thread.

I added a few cobs to it, I think currently the most used ones, but if someone wants different cobs as a selection, just post the spreadsheets here and I'll add when I get a chance. The prices are current as of today, but if they change, just post here and I'll update. If you guys come up with a need for a calculation in the calculator, post your suggestions, as long as I can implement it, I'll add the additional box for it.

https://www.dropbox.com/s/gla2g2d5apbf3dt/DIY COB LED Calculator.jar?dl=0
 

Attachments

Last edited:

bggrass

Well-Known Member
my math came to 126 volts needed @ 3.5 volts each, minimum , whattya think ?
Seems right. How many amps you gonna run them on?

Edit: you'll only get those 10watts a piece if you run them at closer to 3amps, but might not be the best idea. RS has a thread on mono chips here. You might wanna ask there. I don't know much about the monos
 
Last edited:

WwW1962

Well-Known Member
Seems right. How many amps you gonna run them on?

Edit: you'll only get those 10watts a piece if you run them at closer to 3amps, but might not be the best idea. RS has a thread on mono chips here. You might wanna ask there. I don't know much about the monos
45% @ least so 360watts of light watts max about 150-180w would that be right ? im guessing
dimmable driver so i dont cook them all on ignition LOL
 

bggrass

Well-Known Member
There was a little bug with the prices that I noticed today. It has been fixed. Same link for the updated one.
 

klx

Well-Known Member
This is awesome, thanks!

Not sure if it's possible but something that would definitely help out designing a light would be some form of PPFD calculations at different footprints. For example if you could choose 2x2, 3x3...as a footprint and the spreadsheet would calculate the PPFD for the selected configuration.
 

bggrass

Well-Known Member
This is awesome, thanks!

Not sure if it's possible but something that would definitely help out designing a light would be some form of PPFD calculations at different footprints. For example if you could choose 2x2, 3x3...as a footprint and the spreadsheet would calculate the PPFD for the selected configuration.
I can add a total PPFD box, and a PPFD per sq/ft, based on user square footage input, and cob configuration selection. Only I need to make sure I'm using the right values for umol/s/W for each cob. I found a chart that I'm looking at, hopefully it is not outdated. I looked into Alesh's excel sheet and SPDs but haven't got the time to think it through. So I have:

Cree cx 3000K 80CRI = 4.66umol/s/W, only the cxb3590CD in the calculator is 3500K and I'm not sure how that changes.
Vero 4000K V2.0 = 4.62umol/s/W

If someone can confirm those numbers, I'll add it.
 

SupraSPL

Well-Known Member
The 3500K probably has a slightly lower QER than the 3000K but I have no idea how much lower so I have just been going with 4.65. I tried to get the 3500K SPD from Cree so we could estimate the LER and QE but so far they have produced it. I think Johnson Grow Lights will have some data on that soon because one of their lamps should be getting tested in an integrating sphere soon.

Alesh qer400-700.jpg
 

bggrass

Well-Known Member
The 3500K probably has a slightly lower QER than the 3000K but I have no idea how much lower so I have just been going with 4.65. I tried to get the 3500K SPD from Cree so we could estimate the LER and QE but so far they have produced it. I think Johnson Grow Lights will have some data on that soon because one of their lamps should be getting tested in an integrating sphere soon.

View attachment 3546399
Thanks Supra.I'll go ahead and add the current values in, if anything changes later, it will be an easy fix.
 

bggrass

Well-Known Member
The 3500K probably has a slightly lower QER than the 3000K but I have no idea how much lower so I have just been going with 4.65. I tried to get the 3500K SPD from Cree so we could estimate the LER and QE but so far they have produced it. I think Johnson Grow Lights will have some data on that soon because one of their lamps should be getting tested in an integrating sphere soon.

View attachment 3546399

Supra, just to verify my math, so the numbers come out correct, I haven't done the PPFD numbers yet:

totalWatts x efficiency = PARwatts,

PARwatts x umol/s/W = totalPPFD,

totalPPFD / squareFootage = PPFD per sq. ft
 

alesh

Well-Known Member
Supra, just to verify my math, so the numbers come out correct, I haven't done the PPFD numbers yet:

totalWatts x efficiency = PARwatts,

PARwatts x umol/s/W = totalPPFD,

totalPPFD / squareFootage = PPFD per sq. ft
That D in 'PPFD' means density. Doesn't make much sense to divide density by area.
 

bggrass

Well-Known Member
That D in 'PPFD' means density. Doesn't make much sense to divide density by area.
Ok. How do we calculate it then alesh?

EDIT: Should I just do, totalPPFD box and a PPFD per cob box and leave the area calculation out? Would that make more sense?
 
Last edited:

alesh

Well-Known Member
Ok. How do we calculate it then alesh?

EDIT: Should I just do, totalPPFD box and a PPFD per cob box and leave the area calculation out? Would that make more sense?
Nah I was just pointing that you've got the terms mixed up.
PPF - photosynthetic photon flux - total photon output in a range (400-700nm or 380-780nm)
PPFD - photosynthetic photon flux density - total photon output in a range (400-700nm or 380-780nm) per area
So you can convert lumens to watts, then watts to moles of photons per second and that could be converted to average density.

But no wonder that people are confused even mfgs can't get it right - just found this gem.
 
Top