Ultimate LED Bulbs - Ultra High CRI - The Honorable Quest

Other Types of Lights LED Light Bulbs
361

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();


};

362

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

363

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.

364

One more bulb for the spreadsheet:
Bedtime Bulb review

365

Remez LED bulb with SunLike LED’s tested

366

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

367

Yes, I sent e14 3000k too

368

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

369

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

370

Say what?

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

371

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:

372

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

373

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


s. New body of SunLike50D

374

My fav is WGS84.

375

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

376

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.

377

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.

378

It was probably lost in translation, but I assume he meant to say “deep red” and “deep blue”. Not actually UV and IR.

379

It is time for a BLF Sunlike light bulb

380

Fneuf, I think it is bingo again!
Indexes:
99
99
99
98

s. I did not pay to Maukka! All legal!

9W SOL Review: SunLike9 SOL COB E27 LED bulb (4000K, CRI99)
8W smd SAW Review: SunLike8 SMD SAW E27 LED bulb (4200K, CRI98)