Melanopic Ratio(可计算EML- Equivalent Melanopic Lux).xlsx
# 工作表：Circadian λ (nm) | Lamp data | circadian | visual | lamp*c | lamp*v | Source | Melanopic Ratio 380 | 0.0889428571428571 | 0.000918165136037931 | 4e-05 | 8.16642305281737e-05 | 3.55771428571429e-06 | Sample Fluorescent 4000 K | 0.587606511141279 385 | 0.0878714285714286 | 0.00166723789571435 | 6e-05 | 0.000146502575664842 | 5.27228571428571e-06 | Click here for data input 390 | 0.0868666666666667 | 0.00309441603871878 | 0.00012 | 0.000268801606563371 | 1.0424e-05 | Instructions 395 | 0.808844444444444 | 0.00588035407740231 | 0.000217 | 0.00475629172687309 | 0.000175519244444444 | 1. Select built-in sample source, or user-entered source (above). 400 | 2.477175 | 0.0114277054856856 | 0.0004 | 0.0283084263365033 | 0.00099087 | 2. For user data, paste lamp spectral power distribution (5 nm increments) into Data sheet. 405 | 1.068 | 0.0228112302031832 | 0.00064 | 0.0243623938569997 | 0.00068352 | 3. To add more user sources, insert columns to the left of User 2 on the Data sheet. 410 | 0.848142857142857 | 0.0461549945404016 | 0.00121 | 0.0391460289409092 | 0.00102625285714286 | 4. Multiply the Melanopic Ratio by measured or modeled lux to calculate equivalent melanopic lux. 415 | 1.44858571428571 | 0.0794766167098341 | 0.00218 | 0.115128691585627 | 0.00315791685714286 420 | 2.37715 | 0.137237347975805 | 0.004 | 0.326233761740684 | 0.0095086 425 | 11.7539565217391 | 0.187096366435371 | 0.0073 | 2.19912255645673 | 0.0858038826086957 430 | 22.8633175257732 | 0.253865232521735 | 0.0116 | 5.80420141989866 | 0.265214483298969 435 | 6.40444117647059 | 0.320679472841377 | 0.01684 | 2.0537728203142 | 0.107850789411765 440 | 4.28675 | 0.401587073675415 | 0.023 | 1.72150338807809 | 0.09859525 445 | 4.12168571428571 | 0.474002365330849 | 0.0298 | 1.9536887777218 | 0.122826234285714 450 | 4.23 | 0.553715241854564 | 0.038 | 2.34221547304481 | 0.16074 455 | 3.90081428571429 | 0.629653954061883 | 0.048 | 2.45616313906108 | 0.187239085714286 460 | 3.57165714285714 | 0.708048618426448 | 0.06 | 2.52890690549295 | 0.214299428571429 465 | 3.18781428571429 | 0.785216178846322 | 0.0739 | 2.50312335230029 | 0.235579475714286 470 | 3.13202857142857 | 0.860290782383489 | 0.09098 | 2.69445531016173 | 0.284951959428571 475 | 6.11653333333333 | 0.917733560337947 | 0.1126 | 5.61334791292573 | 0.688721653333333 480 | 10.7265461538462 | 0.965604648895619 | 0.13902 | 10.3576028327473 | 1.49120444630769 485 | 9.56634545454545 | 0.990621330141579 | 0.1693 | 9.47662585877567 | 1.61958228545455 490 | 6.18995714285714 | 1 | 0.20802 | 6.18995714285714 | 1.28763488485714 495 | 3.3182 | 0.992022289430387 | 0.2586 | 3.29172836078791 | 0.85808652 500 | 1.53994285714286 | 0.965951657818972 | 0.323 | 1.48751035580363 | 0.497401542857143 505 | 1.21075714285714 | 0.922298680765933 | 0.4073 | 1.11667971558507 | 0.493141384285714 510 | 0.826914285714286 | 0.862888099462505 | 0.503 | 0.713534496418395 | 0.415937885714286 515 | 0.8258 | 0.785233463499676 | 0.6082 | 0.648445794158033 | 0.50225156 520 | 0.934114285714286 | 0.699628039752382 | 0.71 | 0.653532546618982 | 0.663221142857143 525 | 5.60810454545455 | 0.609422124314349 | 0.7932 | 3.41770298546787 | 4.44834852545455 530 | 29.5306679611651 | 0.519308710435336 | 0.862 | 15.3355330972067 | 25.4554357825243 535 | 75.4151532846716 | 0.432533297123995 | 0.91485 | 32.6195649033305 | 68.9935529824818 540 | 61.275020289855 | 0.351707231388651 | 0.954 | 21.5508677394283 | 58.4563693565217 545 | 13.6425047619048 | 0.279135201347528 | 0.9803 | 3.8081033135989 | 13.3737474180952 550 | 3.53275454545455 | 0.215722253771378 | 0.99495 | 0.762093772566534 | 3.514914135 555 | 1.391525 | 0.162055886900303 | 1 | 0.225504818018944 | 1.391525 560 | 1.19902857142857 | 0.118525623360672 | 0.995 | 0.142115608855827 | 1.19303342857143 565 | 6.37793333333333 | 0.084345718537515 | 0.9786 | 0.537951369784368 | 6.24144556 570 | 15.6220114285714 | 0.0587012705556275 | 0.952 | 0.917031919491677 | 14.87215488 575 | 14.7669090909091 | 0.0400088939381398 | 0.9154 | 0.590807699612334 | 13.5176285818182 580 | 18.4786230769231 | 0.026874736625553 | 0.87 | 0.496608128395174 | 16.0764020769231 585 | 16.4922290322581 | 0.0178624465629774 | 0.8163 | 0.294591559793094 | 13.4626065590323 590 | 7.89120625 | 0.0117901407750181 | 0.757 | 0.0930384325722026 | 5.97364313125 595 | 4.03043333333333 | 0.00773429551931064 | 0.6949 | 0.0311725624708802 | 2.80074812333333 600 | 18.64042625 | 0.0050668639839674 | 0.631 | 0.0944485044119254 | 11.76210896375 605 | 34.0973071942446 | 0.00331766297347134 | 0.5668 | 0.113123373573423 | 19.3263537176978 610 | 9.68624 | 0.00217697610162907 | 0.503 | 0.0210867129946436 | 4.87217872 615 | 7.742375 | 0.0014331433756987 | 0.4412 | 0.0110959334434252 | 3.41593585 620 | 8.48613571428571 | 0.000947313149370169 | 0.381 | 0.00803902794948267 | 3.23321770714286 625 | 3.83738571428572 | 0.000627647947692957 | 0.321 | 0.0024085272680777 | 1.23180081428571 630 | 1.56687142857143 | 0.000417955408073769 | 0.265 | 0.000654882387327701 | 0.415220928571429 635 | 1.56583333333333 | 0.00027980095745636 | 0.217 | 0.00043812166588375 | 0.339785833333333 640 | 1.61955714285714 | 0.000188340809488819 | 0.175 | 0.000305028703299113 | 0.2834225 645 | 1.61841428571429 | 0.000127336840908345 | 0.138 | 0.000206083762423793 | 0.223341171428571 650 | 1.17992857142857 | 8.65750811230628e-05 | 0.107 | 0.000102152411790848 | 0.126252357142857 655 | 1.45222857142857 | 5.91913842791767e-05 | 0.0816 | 8.59594194326284e-05 | 0.118501851428571 660 | 1.17777142857143 | 4.06945171674992e-05 | 0.061 | 4.79288396193901e-05 | 0.0718440571428571 665 | 0.957957142857143 | 2.81320382263111e-05 | 0.04458 | 2.69492869620249e-05 | 0.0427057294285714 670 | 0.792828571428571 | 1.95534818795249e-05 | 0.032 | 1.55025591049982e-05 | 0.0253705142857143 675 | 1.22921428571429 | 1.36480272704651e-05 | 0.0232 | 1.67763500926738e-05 | 0.0285177714285714 680 | 1.5563 | 9.57636718625758e-06 | 0.017 | 1.49037002519727e-05 | 0.0264571 685 | 1.0084571428571…