CSCalculator_2017_10_03_Mac(CS&CLa计算工具)
# 工作表：Instructions LRC Circadian Light Combined Calculator General notes and instructions: March 07, 2017 1 | The purpose of this calculator is to facilitate the calculation of circadian light (CLA) and circadian stimulus (CS) for several example light source spectra as well as for user-supplied light source spectra. The workbook implements the formulae documented in the following journal paper and corrigendum: a. | Rea MS, Figueiro MG, Bierman A, Hamner R. Modeling the spectral sensitivity of the human circadian system. Lighting Research & Technology 2012; 44(4):386–396. DOI: 10.1177/1477153511430474 b. | Corrigendum, Lighting Research & Technology 2012 44(4):516. DOI: 10.1177/1477153512467607 c. | Rea MS, Figueiro MG Light as a circadian stimulus for architectural lighting. Lighting Research & Technology 2016; In press 2 | To run a calculation for one of the supplied light source spectra: a. | Select the spectrum from the drop-down menu in cell E3. The drop-down menu arrow will appear adjacent to the cell on the right when the cell is selected (e.g., by clicking on the cell with the mouse pointer). Click the down arrow to display the drop-down menu options. Once a selection for a source is made, press the "Add New Source" button. Your selection will appear in the next available cell in column B. b. | Directly next to your selection, in column C, a zero will appear. This zero represents the illuminance level for the corresponding source. Edit this cell to change the desired illuminance level from the corresponding source. Once the cell is deselected, the graph will automatically adjust to represent the new source. The program will then take a few seconds to calculate the new "Spectral Contribution Function", plotted in red in the graph. Typically, this would be the illuminance at the cor c. | Values for illuminance, circadian light (CLA) and circadian stimulus (CS) are displayed in cells J23, J24, and J25, respectively. d. | Adding additional sources will update the illuminance, circadian light, and circadian stimulus values displayed in the cells. The normalized SPD created by combining the selected sources is displayed in cells I28:J203. 3 | To run a calculation for a user-supplied spectrum: a. | Select “User” in cell E3 following the instructions in step 2a, above, then enter a name for the SPD. This name will serve as an identifier for the SPD in column B. This procedure instructs the calculator to use the spectrum located in columns E and F as the source for calculations, specifically columns E and F starting at row 11. Column E contains the wavelength value in nanometers (nm), and column F contains the corresponding relative spectral power values in radiometric units (e.g., W/nm b. | Enter or copy and paste the spectral data to cells in columns E and F starting at row 11. The program will accept any wavelength value and increment ranging from 1 to 5000 nm. The calculator works with data supplied in either uniform or non-uniform wavelength increments, as many array spectrometers provide data in non-uniform wavelength increments. The calculator interpolates the supplied spectral data, implementing trapezoidal integration methods to handle the non-uniform wavelength incre c. | Follow the instructions in step 2b to set the illuminance level. d. | As with the other selected spectra from the drop-down menu, the user-supplied spectrum is plotted in the graph to the right of the data and the calculated values (J23, J24, and J25) and normalized spectrum (I28:J203) are updated appropriately. 4 | To remove a source from a calculation: a. | The sources can be deleted one at a time starting with the last source entered. To delete a source press the "Delete Last Source" button. The last source added to the calculation and the corresponding illuminance level will be removed from columns B and C. 5 | For questions and comments about this calculator, you may contact Andrew Bierman (bierma2@rpi.edu) or Gregory Ward (wardg3@rpi.edu) at the Lighting Research Center. For more information about circadian light go to: http://www.lrc.rpi.edu/programs/lightHealth/index.asp 6 | For users who want to adapt this workbook for their own functionality, here is a listing of the CLA and CS values for the included spectra at a light level of 1000 lux to serve as reference values to check against a reformulated workbook. Spectrum | Illuminance (lux) | CLA | CS Equal energy | 1000 | 1430 | 0.576 D65 | 1000 | 1615 | 0.589 Xenon | 1000 | 1402 | 0.574 A lamp | 1000 | 950 | 0.523 Enrich A lamp | 1000 | 1103 | 0.544 Halogen 3277 K | 1000 | 1187 | 0.553 CFL | 1000 | 690 | 0.473 RE 3500 K | 1000 | 1031 | 0.535 Cool white | 1000 | 537 | 0.428 Design50 | 1000 | 969 | 0.526 PS MH | 1000 | 597 | 0.447 Clear MV | 1000 | 359 | 0.352 LPS | 1000 | 59 | 0.084 HPS | 1000 | 410 | 0.377 LED 2700 K | 1000 | 814 | 0.499 LED 6500 K | 1000 | 1280 | 0.563 Navy 13 K | 1000 | 2463 | 0.626 LED 470nm | 1000 | 17763 | 0.691 Ceramic MH | 1000 | 778 | 0.492 Promolux | 1000 | 1240 | 0.559 Blue LED | 1000 | 18592 | 0.691 Red LED | 1000 | 7 | 0.01 # 工作表：MainDisplay Selected Sources | Corresponding Illuminances (lux) | Add New Souce | Results Select Preloaded Source User SPD User Source Name: Wavelength (nm) | Value Combined Illuminance (lux) | 0 | cool Circadian Light (Cla) | 0 Circadian Stimulus (CS) | 0 Wavelength | Relative Combined SPD 380 382 384 386 388 390 392 394 396 398 400 402 404 406 408 410 412 414 416 418 420 422 424 426 428 430 432 434 436 438 440 442 444 446 448 450 452 454 456 458 460 462 464 466 468 470 472 474 476 478 480 482 484 486 488 490 492 494 496 498 500 502 504 506 508 510 512 514 516 518 520 522 524 526 528 530 532 534 536 538 540 542 544 546 548 550 552 554 556 558 560 562 564 566 568 570 572 574 576 578 580 582 584 586 588 590 592 594 596 598 600 602 604 606 608 610 612 614 616 618 620 622 624 626 628 630 632 634 636 638 640 642 644 646 648 650 652 654 656 658 660 662 664 666 668 670 672 674 676 678 680 682 684 686 688 6…