Ultimate LED Bulbs - Ultra High CRI - The Honorable Quest

I added ColorMunki cri results to the chinese Marswell 40w 5700k bulb pics on google drive Ultimate LED Bulbs - Ultra High CRI - The Honorable Quest - #236 by Dalamar

4 other bulbs here and some flashlights, https://drive.google.com/drive/folders/1kcl_uOhgfpR4RSsa8F4b-UUVP9mkL6Cr

It would be appreciated if someone told me how to get a proper spectral graph out of argyll…god I hate cli.
ColorMunki does not work with CT&A, although I found 5.0 on the seven seas…

It depends what you’re looking at. Cyan, violet, red colors of the variety you can find on natural things can be drastically different with the Sunlike SOL.
My collared dove neck highlight looks rather bland under my Cree light Cree 1600 lumen 5000k ta21-16050mdfh25-12de26-1-11.png - Google Drive , but under the mix of halogen/sunlike the neck highlights look a lot less dull. Manmade stuff you generally won’t see much different….

Sunlike’s cri comparison photo looks like a 80CRI with bad R9, which isnt really a fair comparison…

You could use HCFR for spectrum. The SPD graph generator from Argyll is not very pretty, but it does have one.

edit: another option is to read the SPD data from Argyll and then paste the values into Osram Color Calculator

It can create TM-30 reports and also visualize the tint on a CIE graph. See contactr’s examples.

I dont have access to my device/computer right now but here are some more tips.

I believe I used one of these two commands to get high res spectral output

spotread -a -x -H -s
spotread -a -x -H -s -N -O

Then I pasted or opened the data in a google sheet and ran a macro to transpose the data into columns and saved as a CSV file so it would end up formatted like this:

spectrum, measurement

spectrum, measurement

Then you can import it into Osram Color Calc as a spectrum CSV file. You can create your own way to parse it but I just used google sheets as a quick and dirty macro cause I didnt have Excel w/ VBA or anything installed on that computer.

/** @OnlyCurrentDoc */

function Spotreadtranspose() {
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.getRange('1:14').activate();
spreadsheet.getActiveSheet().deleteRows(spreadsheet.getActiveRange().getRow(), spreadsheet.getActiveRange().getNumRows());
spreadsheet.getRange('2:5').activate();
spreadsheet.getActiveSheet().deleteRows(spreadsheet.getActiveRange().getRow(), spreadsheet.getActiveRange().getNumRows());
spreadsheet.getRange('3:5').activate();
spreadsheet.getActiveSheet().deleteRows(spreadsheet.getActiveRange().getRow(), spreadsheet.getActiveRange().getNumRows());
spreadsheet.getRange('A1').activate();
spreadsheet.getRange('A1').splitTextToColumns(SpreadsheetApp.TextToColumnsDelimiter.SPACE);
spreadsheet.getRange('A2').activate();
spreadsheet.getRange('A2').splitTextToColumns(SpreadsheetApp.TextToColumnsDelimiter.SPACE);
spreadsheet.getRange('A3').activate();
spreadsheet.getRange('1:1').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_NORMAL, true);
spreadsheet.getRange('B3').activate();
spreadsheet.getRange('2:2').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_NORMAL, true);
spreadsheet.getRange('1:2').activate();
spreadsheet.getActiveSheet().deleteRows(spreadsheet.getActiveRange().getRow(), spreadsheet.getActiveRange().getNumRows());
spreadsheet.getRange('A1:A106').activate();
var values = spreadsheet.getDataRange().getValues();

//loop over the rows in the array
for(var row in values){

//use Array.map to execute a replace call on each of the cells in the row.
var replaced_values = values[row].map(function(original_value){
return original_value.toString().replace('SPEC_','');
:smiling_imp:;

//replace the original row values with the replaced values
values[row] = replaced_values;
}

//write the updated values to the sheet
spreadsheet.getDataRange().setValues(values);
spreadsheet.getRange('A1').activate();

};

Me too. It’s 2020 for God sake. We are supposed to be on to brain-computer interfaces now.

CLI interfaces won’t die any time soon.
They require learning which is a big drawback. But they are simple to implement, simple to automate and once learned can be quite ergonomic.
I use Unix shell a lot - and I’m much more productive because of that.

One more bulb for the spreadsheet:
Bedtime Bulb review

Remez LED bulb with SunLike LED’s tested

I was pretty excited to click. Then I saw only the 5700k was reviewed. Any plans for reviewing the 3000k?

Yes, I sent e14 3000k too

I’ll test the 3000K E14, but first I need to get an E27-E14 adapter for my sphere.

Here’s the CRI data for the Remez SunLike E14 3000K.

Say what?

You want red and blue, not UV and IR (and not narrow LED spikes but a fairly broad range of each color)

I know this pictures since 2013. I need just real tests, not pictures.
Or you think that manufacturer and his huge buyer are stupid? Do you really think that they did not seen this pictures? :smiley:

Looking good. I’ll take a bit of over-saturation. :+1:

Hello, peoples of the round Earth. StarLike LEDs is near!


s. New body of SunLike50D

My fav is WGS84.

I mean flat Earth. Flat Earth can be round, like disc. evidence

Well flattening it can be useful when you want it to fit a flat screen. Here’s a little code from an old project of mine. Does this make me a flat earther?

function MapLatLonToXY($phi, $lambda, $lambda0)
{
$N; $nu2; $ep2; $t; $t2; $l;
$l3coef; $l4coef; $l5coef; $l6coef; $l7coef; $l8coef;
$tmp;

/* Precalculate ep2 */
$ep2 = (pow($GLOBALS[‘sm_a’], 2.0) - pow($GLOBALS[‘sm_b’], 2.0)) / pow($GLOBALS[‘sm_b’], 2.0);

/* Precalculate nu2 */
$nu2 = $ep2 * pow (cos($phi), 2.0);

/* Precalculate N */
$N = pow($GLOBALS[‘sm_a’], 2.0) / ($GLOBALS[‘sm_b’] * sqrt(1 + $nu2));

/* Precalculate t */
$t = tan($phi);
$t2 = $t * $t;
$tmp = ($t2 * $t2 * $t2) - pow($t, 6.0);

/* Precalculate l */
$l = $lambda - $lambda0;

/* Precalculate coefficients for l**n in the equations below
so a normal human being can read the expressions for easting
and northing
— l*1 and l2 have coefficients of 1.0/
$l3coef = 1.0 - $t2 + $nu2;

$l4coef = 5.0 - $t2 + 9 * $nu2 + 4.0 * ($nu2 * $nu2);

$l5coef = 5.0 - 18.0 * $t2 + ($t2 * $t2) + 14.0 * $nu2

  • 58.0 * $t2 * $nu2;

$l6coef = 61.0 - 58.0 * $t2 + ($t2 * $t2) + 270.0 * $nu2

  • 330.0 * $t2 * $nu2;

$l7coef = 61.0 - 479.0 * $t2 + 179.0 * ($t2 * $t2) - ($t2 * $t2 * $t2);

$l8coef = 1385.0 - 3111.0 * $t2 + 543.0 * ($t2 * $t2) - ($t2 * $t2 * $t2);

/* Calculate easting (x) */
$xy;
$xy[0] = $N * cos($phi) * $l

  • ($N / 6.0 * pow (cos ($phi), 3.0) * $l3coef * pow($l, 3.0))
  • ($N / 120.0 * pow (cos ($phi), 5.0) * $l5coef * pow($l, 5.0))
  • ($N / 5040.0 * pow (cos ($phi), 7.0) * $l7coef * pow($l, 7.0));

/* Calculate northing (y) */
$xy[1] = ArcLengthOfMeridian($phi)

  • ($t / 2.0 * $N * pow(cos($phi), 2.0) * pow($l, 2.0))
  • ($t / 24.0 * $N * pow(cos($phi), 4.0) * $l4coef * pow($l, 4.0))
  • ($t / 720.0 * $N * pow(cos($phi), 6.0) * $l6coef * pow($l, 6.0))
  • ($t / 40320.0 * $N * pow(cos($phi), 8.0) * $l8coef * pow($l, 8.0));

return $xy;
}

Edit: man the formatting went to heck.

Eh? You mean you need evidence to convince you which wavelengths plants use for photosynthesis?

You could do the experiment yourself; it would be a good science fair type project.