CIE S 026 alpha-opic Toolbox
# 工作表：Maintenance CIE S 026 α-opic Toolbox - v1.049a - 2020/11 Maintenance | Deliberately not accessible. | Display length | 44 | Use 43 to include yyyy/mm, 24 for Powerpoint images Hide from here down and G:G right when updates complete and proceed to Disclaimer, and then Hide this tab, as well as Spectra, Physics, Photobiology and Calculations tabs Code | Status | Date | Comments Showing updates from 1.045: LP1 | Changed | 2019-11-11 00:00:00 | Unlocked and unhidden created LP2 | Changed | 2019-11-11 00:00:00 | Updated version number to 1.047 and date to 2019/11/11 on Disclaimer sheet LP3 | Changed | 2019-11-11 00:00:00 | Error markers on Inputs sheet changed to vertical centred 18 pt, cells D11, D12, D13 and D17. Visible row heights all set at 15, except row 1. LP4 | Changed | 2019-11-11 00:00:00 | Correct display of illuminance Outputs D15 and Advanced Outputs H17, H18 to 2 d.p. LP5 | Changed | 2019-11-11 00:00:00 | Correct title for "a-opic photon irradiance in standard notation" Ouputs B41 LP6 | Changed | 2020-02-19 00:00:00 | Updated version number to 1.048, title to α-opic Toolbox (from EDI Toolbox),date to 2020/02/19 on Disclaimer sheet and updated the main message from CB agreed Powerpoint slide LP7 | Added | 2020-02-19 00:00:00 | Added display length input in Maintenance to support version-free Powerpoint images, and updated B1 formula in all other sheets LP8 | Changed | 2020-02-19 00:00:00 | Updated the EDI Toolbox text in Ouputs!C3, and linked Charts, Action spectra, Glossary and Advanced Warnings cells C3 to Ouputs!C3 LP9 | Changed | 2020-02-19 00:00:00 | Calculations: Spectral conversion to radiometric corrected from SI Brochure error - refractive index goes in denomintor of this factor LP10 | Not changed | 2020-02-19 00:00:00 | Dependency of chart title. Quantity value and units match the photometric units selected on advanced outputs, which can lead to zeros. However, changing this to be overridden by another option, e.g. main input units if these are photometric, requires a change to the calculations. The simplest option would be to add a futher scaling factor and quantity value for the chart versions of Test and Ref on the calculations sheet. Another option would be to allow user control on the charts sheet itself, requiring additional calculation columns as well. This is left until a later version if necessary. LP11 | Changed | 2020-02-19 00:00:00 | Number format validation added to numerical input cells: C17>=-1 and C24:C424<999999.999999 (and allow blanks) LP12 | Added text | 2020-02-19 00:00:00 | Added "The units used on the y-axis depend on the prefixes selected in Inputs cells C12 and C13. The units used in the chart titles depend on the prefixes selected in Advanced Outputs cells H10 and H11." below the Charts LP13 | Added text | 2020-02-19 00:00:00 | Added "The input data is called the Test source. The default CIE S 026 Reference source is daylight (D65); Lucas et al., 2014 uses equi-energy (E)." below the Charts LP14 | Published | 2020-03-26 00:00:00 | Version 1.049 updated to include commenting from ballots. LP15 | Changed | 2020-11-17 00:00:00 | Saved as 1.049a for updates, with Header text changed to "CIE S 026 α-opic Toolbox v1.049a - 2020/11/16" in Disclaimer cell B1 and omitting "/16" in dependent cells on other sheets via changing the value in Maintenance cell I3 (=44) LP16 | Changed | 2020-11-17 00:00:00 | Changed the second box of the Disclaimer to “The a-opic Toolbox is a CIE publication (DOI: 10.25039/S026.2018.TB) under … The toolbox was designed with feedback from experts …”. Note that the DOI is moved to the first mention of the toolbox in the box. The DOI will not change with the version number. Additionally: Removed the version number from the text. It should be sufficient to have it in the header. LP17 | Changed | 2020-11-17 00:00:00 | Final version 1.049a includes the correction to Advanced Outputs in cell F45 so that it (equation T8) reads as a multiplication using "*" rather than a division using "/" under all the options and settings available. # 工作表：Disclaimer CIE S 026 α-opic Toolbox - v1.049a - 2020/11/16 Disclaimer | © CIE 2020 - All rights reserved # 工作表：Inputs CIE S 026 α-opic Toolbox - v1.049a - 2020/11 | List of completely hidden formulae for maintenance Inputs sheet | Inputs = blue | Instructions | C14 | log base - No dependents D11 | Error indicator - No dependents Enter a title for your data | CELL B5: Enter measurement name. | D12 | Error indicator - No dependents CELL C8: Enter "User" to enter spectrum OR | D13 | Error indicator - No dependents 1. Select source of spectral data | select the built-in spectrum matching the | D17 | Error indicator - No dependents Spectrum | conditions of your measurement value. | J9 | Default indicator - No dependents CELLS C11-C13: Enter the type of quantity | J13 | Default indicator - No dependents 2. Select measurement details | and unit prefixes for your data. | J17 | Default indicator - No dependents Quantity, Q | If you selected "User" in CELL C8: | J18 | log base - No dependents Main SI prefix | Clear CELL C17. | E24 | Output!B14 message only Area prefix | CELL C20: Enter wavelength step | E26 | E24 only for your data (≤ 5 nm). | E28 | E24 only 3. Enter value | CELLS C24:C424: Enter spectral data to | E30 | E24 only (units) | match the units and wavelength step. | L24 | No dependents Enter value | If you did not select "User" in CELL C8: | L26 | L24 only CELL C17: Enter the measurement | L28 | L24 only 4. Select wavelength step | value to match the units. | L30 | L24 only Step size, nm | Clear CELLS C24:C424. | L32 | L24 only Some prompts also contain formulae, but have not dependents 5. Enter spectral data | Error messages | Outputs!I11 is another error indicator - no dependents nm | (units) | There are disclaimer messages as formulae on each sheet 380 | ERROR: Select spectrum or User in cell C8. 380 | Only user inputs are shaded cells together with Ages!D7 and Outputs!F10:11, H10:11 and …