ANSI-IES-TM-30-18-Basic-Calculation-Tool-v2.00.xlsm
# 工作表：Version Notes ANSI/IES TM-30-18 Basic Calculation Tool This document has been approved and copyrighted by the Illuminating Engineering Society (IES) for use in conjunction with ANSI/IES TM-30-18. In the event of any discrepancy between the calculation tool and the procedure described in ANSI/IES TM-30-18, the standard takes precedence. This version of the calculation tool uses limited VBA sheet macros (to compute CCT, reference illuminant, and chromaticity). It is designed for SPDs having a 1 nm resolution, ranging from 380 to 780 nm. For other reso Version Number | Release Date | Notes 1.0 | 2015-09-14 00:00:00 | Initial public release with IES TM-30-15. 1.01 | 2015-10-02 00:00:00 | Corrected to apply equation 3.12.4 as specified in IES TM-30-15. 1.02 | 2015-06-09 00:00:00 | Correctred formula for Color Distortion Icon. Clarification of index abbreviations. Correction of hue composition formula. 2.00 | 2018-08-10 00:00:00 | Implements ANSI/IES TM-30-18 changes, with new formatting. PLEASE CHECK FOR UPDATES PRIOR TO USE AT: http://www.ies.org/redirect/tm-30/ # 工作表：Instructions ANSI/IES TM-30-18 Basic Calculation Tool This document has been approved and copyrighted by the Illuminating Engineering Society (IES) for use in conjunction with ANSI/IES TM-30-18. In the event of any discrepancy between the calculation tool and the procedure described in ANSI/IES TM-30-18, the standard takes precedence. This version of the calculation tool uses limited VBA sheet macros (to compute CCT, reference illuminant, and chromaticity). It is designed for SPDs having a 1 nm resolution, ranging from 380 to 780 nm. For other reso Instructions 1) | Make sure macros are enabled. This tool uses three sheet macros (but no VBA code). 2) | The SPD can be input in two ways: (a) in the Calculator sheet, or (b) in the SPD Library sheet. The SPD must always have a resolution of 1 nm and a range of 380 to 780 nm. For other increments, it is suggested to use the TM-30 Advanced Calculation Tool instead. 2a) | To enter an SPD manually in the Calculator sheet: - Enter 0 as the selected SPD (cell C3). - Paste the SPD in the shaded area of column C. 2b) | To select an SPD from the SPD Library sheet, enter the corresponding SPD number in cell C1. - Additional SPDs can be added to the SPD library. They must have a resolution of 1 nm and a range of 380 to 780 nm. Sheet Descriptions Calculator This sheet serves as the main user interface. Use this page to paste or recall SPDs and view the calculation results. CalcEngine This sheet includes the formulas and detailed numerical results for the ANSI/IES TM-30-18 calculations. CVG This sheet includes acceptable alternative version of the Color Vector Graphic. It also stores data used to generate the graphics. CVG (Dynamic) [Hidden] Includes data for the CVG that reflects the selected viewing options. SimpleReport This sheet provides a printable 1/4 page layout, as described in ANSI/IES TM-30-18 Annex D. Note: the aspect ratio on this sheet is formatted for printing; verify that that CVG prints square. IntermediateReport This sheet provides a printable 1/2 page layout, as described in ANSI/IES TM-30-18 Annex D. Note: the aspect ratio on this sheet is formatted for printing; verify that that CVG prints square. FullReport This sheet provides a printable full page layout, as described in ANSI/IES TM-30-18 Annex D. Note: the aspect ratio on this sheet is formatted for printing; verify that that CVG prints square. SPD Library This sheet allows SPDs to be stored for recall from the Calculator sheet. The default library includes a set of SPDs intended to help users understand ANSI/IES TM-30-18. This Library has been populated with a subset of SPDs used in: Kevin W. Houser, Minchen Wei, Aurélien David, Michael R. Krames, and Xiangyou Sharon Shen. Optics Express, Vol. 21, Issue 8, pp. 10393-10411 (2013) - http://dx.doi.org/10.1364/OE.21.010393. Please refer to this manuscript for additional specifics and citations regard CES This sheet provides the 99 color evaluation samples (CES) specified in ANSI/IES TM-30-18. CMF [Hidden] This sheet stores the CIE 1931 2° CMFs and CIE 1964 10° CMFs used in the calculations. RefCalc [Hidden] This sheet calculates the SPD of the appropriate reference illuminant based on the CCT of the test source. CCTCalc [Hidden] This sheet calculates the CCT of the test source. Contributions General engine: Aurelien David CCT, chromaticity, reference illuminant: Yoshi Ohno CAM02-UCS engine: Lorne Whitehead, Kevin Smet # 工作表：Calculator DATA INPUT [See Instructions sheet for additional information] PLEASE CHECK FOR UPDATES PRIOR TO USE AT: http://www.ies.org/redirect/tm-30/ | BASIC RESULTS [Printable results in other sheets] Select Library SPD: [Enter 0 for Use SPD] | 1 | CIE F1 Wavelength (nm) | User SPD (0) 380 | True 381 | True 382 | True 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 | True 406 | True 407 | True 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 | 0 | 0 455 | 100 | 100 456 | 0 | 200 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657…