knna

Nice work, Quantrill !

Its perfect. I was curious about what result it gets if using the 5nm model, and i obtain similar result as yours (slighty better, but less than 3%, and this into the normal error margin).

That lamp is really blue for a HPS, now i know why people like it so much. Its system efficiency is very similar to the best 600w HPSs i analyzed but having a very enriched blue spectrum.

Im glad my sheet is useful for the people, this is i wanted, each grower analyzing its prefer bulb. Thanks a lot for using it, make me feel useful, and i need it when my body dont work fine, as now

__________________


Bulb Analyzer Tool

knna

Ive just seen your edit, Quantrill.

Ive noted graphs not accurate before when marking the refference points. It dont mind in the vertical axis, because the sheet use it in relative terms, but of course is very relevant in horizontal axis.

What i do is supposing the graph is accurate (exported from a spectrometer plot), so i correct the markings, using the squared mode in MS Paint: first i count the graph dots, compute for letting 1 sq for each 5nm band, convert it with "Expand/contract" tool and then remark all the refference points.

Sometimes, letting just one sq per 5nm band gets a excesive dense graph, so i let (2 or) 3 sq per 5nm band, but then inputing data is more tough work, because the right way is sum the three columns and divide by 3 (compute the average value). But this way is the most accurate.

I filled the 5nm sheet with the data from a converted to 1sq per 5nm band graph, so not the best accuracy, but surprisingly, i obtained results very closer to your first sheet. Anyway, now you get how to input the data, the more detail you put into it, the more accurate results you get, but always taking into account that converting data from a graph always has a error margin, about +-5% in my experience.

Errors in the area of higher photometric efficacy (around 555nm) give the higher differences, so take care when inputing this..

knna

__________________


Bulb Analyzer Tool

Quantrill

Great, thanks for double checking me. I am really glad you posted this tool. It is really useful. I have some questions I hope you don't mind me asking.

would it be possible to get a red to far red ratio calculator added? For phytochrome manipulation. its easy enough to do in my head, but it would be great if it was availible on the spreadsheet.

So you are saying that I can measure my light intensity with my lux meter and then using the PUR/Klm ratio get a decent approximation of the quanta at plant level? Because I have a nice lux meter, what good it has done me so far I don't know.

Ok, last one. Some SPD graphs have the vertical axis rated in percent relative energy, and some give it in uW/10nm/Lumens (whatever that means). Does it matter when inputing the data? is there a way to convert between the two?


Thanks man, good luck with the upcoming knee surgery.

__________________
Each man must for himself alone decide what is right and what is wrong, which course is patriotic and which isn't.

~Mark Twain

knna

Yes, its possible and very easy. Add a row at the end (below the R/B row), and set it to compute $44/$45 in the desired columns (E, I, J). Ive made some modifications as this: change the cells I46 and J46 to SUM(I42:I44) and SUM(J42:J44) respectivelly, in order to obtain PAR data (the sheet i uploaded compute infrared uE too).

Yep, exactly, at least in no shaded areas (undercanopy, light spectrum will be different, more rich in IR and poorer in blue, a general shift toward longer wl). This allows to know the irradiance in "botanical" units (uE/m2), wich use all the studies, allowing to use many botanical knowledge we currently dont use. Anyway, having data of irradiance in uE/m2 is far more accurate than lux readings and allow to compare grows using different lights.

It dont matter, the sheet understand it always as relative units. My first sheet model used absolute measurements, but i found that many graphs arnt accurate in this, so i choosed to compute all from relative SPD data and check it with lm emission to get the bulb efficiency, from all the remaining data are computed.

Thanks for your good wishes

__________________


Bulb Analyzer Tool

knna

I digitalized the Hortilux EYE Super HPS spectrum. Your second input was right, result are similar. This sheet have the more accurate data possible from the spectrum graph.

Results are into the 10% error margin. The last accurate input provide similar results, but higher overall perfomance and less blue content (still very high for a HPS lamp).

Very nice bulb, same perfomance than most 600watters for a 1000w bulb and plenty of blue.

C'mon boys, analyze your lights and report it!

Attached Files

HortiluxEYE_SuperHPS.zip (14.1 KB, 61 views)

__________________


Bulb Analyzer Tool

Quantrill

Cool, thanks for doing the leg work on that knna!

Now I know I am getting and inputting fairly accurite data. I'll try and get a couple more up in the next few days.

This tool should put us miles ahead of the game compared to relying on photometric data to choose bulbs.

__________________
Each man must for himself alone decide what is right and what is wrong, which course is patriotic and which isn't.

~Mark Twain

choader

Wow! What a thread! My head is spinning!!

This is some good work. Nice to see the EYE bulbs look good. I need some time to look at this. Whew!

Choader

__________________
SS Bubblegum & DP Mazar Small Cab - Complete
Choader's 600W HPS Grow - Complete
Small Cab Grow - Complete

READ ME!! Posting Guidelines
Male and Female Pre-Flowers

choader

Have either of you looked at the 600W EYE?

Choader

__________________
SS Bubblegum & DP Mazar Small Cab - Complete
Choader's 600W HPS Grow - Complete
Small Cab Grow - Complete

READ ME!! Posting Guidelines
Male and Female Pre-Flowers

Quantrill

How many lumens is it? Whats the total system wattage, the bulb and ballast together? this should be listed on the ballast, or give me the amp draw.

It would have the same SPD so most the other input data would be the same as the 1000 watter. Just open the file and change the required fields.

__________________
Each man must for himself alone decide what is right and what is wrong, which course is patriotic and which isn't.

~Mark Twain

Quantrill

Here

Attached Files

Copy of HortiluxEYE_SuperHPS 1000 and 600.zip (13.5 KB, 48 views)

__________________
Each man must for himself alone decide what is right and what is wrong, which course is patriotic and which isn't.

~Mark Twain