I created this Excel spreadsheet in hopes that it would make calibrations easier for you all. It has helped me greatly. It is designed to work with HCFR and the AVSHD disc, but you can enter the required information from any measurement software. The saturation measurements should come from AVSHD, since these were the saturation targets I used for the calculations.
The Excel spreadsheet provides the following:
1) Calibration Aid. Provides correct brightness and saturation locations for all color windows in AVSHD. Also provides Brightness targets for 10%, 20% 100% gray windows for a user selectable gamma.
2) CIE Gamut charting, with all color reference saturation points (something not available in HCFR) Now including color background
3) Edit 1-21-09, Updated to include 'u 'v charting. Now including color background
4) Color brightness versus saturation charts (versus the incorrect method in HCFR)
5) Color Saturation %error versus saturation charts, x, y color space
6) Edit 1-30-09, Updated Color Saturation %error versus saturation charts, 'u 'v color space
7) dE charting at all color measurement points (something not available accurately in HCFR)
8) New 2-7-09 Worksheet from Bill Mitchel to adjust primary and secondary llocations and brightness if a gamma of 2.22 is not used. User is able to select any gamma they choose. -These calculations are yet to be verified.
9) New 2-7-09 Worksheet from angryht to adjust secondary locations if the primary locations do not line up with the target locations. This is similar to the Accupel calculator
If you open a file in HCFR, and check the editable data box on the main screen, you can then highlight the cells you need and copy and paste them into my file. For example, use the dropdown menu and choose Red Saturation Scale Highlight all 15 of the cells that you need. Choose, Edit, Copy from the top menu bar. Highlight the correct cells for red saturation in the Excel file and choose, Edit, Paste. Repeat for all the colors.
In the first and second worksheet, also simply type in the Y value from your 100% gray window from the Grayscale menu in HCFR and the worksheets will automatically provide brightness targets for accurate 2.22 gamma and primary and secondary color brightness.
I think some of you will be very surprised how far off your 25-75% color saturations are off, even if your 100% saturations are set optimally.
Note:
A special thanks to Tom Huffman, who's dE measurement calculations were used, and then adjusted, to cover all other color saturation points on the AVSHD disc, not just the 100% saturation points.
Update: 1-22-09. The locations in my files are correct and accurate. Enjoy! To be the most accurate, a gamma of 2.22 should be strived for
Update: 4-11-09. Included HCFR specific % bar values for 100% and 75% saturation windows. These are the bars to the left of the ftL and cd/m2 readings on the bottom left of the HCFR main screen. Simply use your CMS saturation and hue adjsutments to match the %'s listed in my table. Takes a lot of guesswork out of hitting the correct saturation and hue.
Dan
The Excel spreadsheet provides the following:
1) Calibration Aid. Provides correct brightness and saturation locations for all color windows in AVSHD. Also provides Brightness targets for 10%, 20% 100% gray windows for a user selectable gamma.
2) CIE Gamut charting, with all color reference saturation points (something not available in HCFR) Now including color background
3) Edit 1-21-09, Updated to include 'u 'v charting. Now including color background
4) Color brightness versus saturation charts (versus the incorrect method in HCFR)
5) Color Saturation %error versus saturation charts, x, y color space
6) Edit 1-30-09, Updated Color Saturation %error versus saturation charts, 'u 'v color space
7) dE charting at all color measurement points (something not available accurately in HCFR)
8) New 2-7-09 Worksheet from Bill Mitchel to adjust primary and secondary llocations and brightness if a gamma of 2.22 is not used. User is able to select any gamma they choose. -These calculations are yet to be verified.
9) New 2-7-09 Worksheet from angryht to adjust secondary locations if the primary locations do not line up with the target locations. This is similar to the Accupel calculator
If you open a file in HCFR, and check the editable data box on the main screen, you can then highlight the cells you need and copy and paste them into my file. For example, use the dropdown menu and choose Red Saturation Scale Highlight all 15 of the cells that you need. Choose, Edit, Copy from the top menu bar. Highlight the correct cells for red saturation in the Excel file and choose, Edit, Paste. Repeat for all the colors.
In the first and second worksheet, also simply type in the Y value from your 100% gray window from the Grayscale menu in HCFR and the worksheets will automatically provide brightness targets for accurate 2.22 gamma and primary and secondary color brightness.
I think some of you will be very surprised how far off your 25-75% color saturations are off, even if your 100% saturations are set optimally.
Note:
A special thanks to Tom Huffman, who's dE measurement calculations were used, and then adjusted, to cover all other color saturation points on the AVSHD disc, not just the 100% saturation points.
Update: 1-22-09. The locations in my files are correct and accurate. Enjoy! To be the most accurate, a gamma of 2.22 should be strived for
Update: 4-11-09. Included HCFR specific % bar values for 100% and 75% saturation windows. These are the bars to the left of the ftL and cd/m2 readings on the bottom left of the HCFR main screen. Simply use your CMS saturation and hue adjsutments to match the %'s listed in my table. Takes a lot of guesswork out of hitting the correct saturation and hue.
Dan
Gamut, Saturation, Brightness, dE Chart.zip 376.2724609375k . file
Hopefully some of this will be in the next HCFR update, and then we won't need auxiliary files like this.
