Originally Posted by angryht
Well I tried it with excel 2007 and got the same result, it only pastes the visible digits? Maybe it's an XP thing.
Here is my contribution. I put together a spreadsheet that calculates the new targets based on primaries that are off. So far I am getting the same results as the Accupel display calibration calculator. I was hoping others could check it and test it out. And maybe it could be incorporated into your tool. The formulas came from the article in Widescreen Review Magazine, December 2008. Thanks very much to Tom Huffman for making the complex math simple to understand (and all your other contributions). Let me know what you think.
So, I'm trying out the spreadsheet, and the results I see don't make sense.
Here's the raw measurements I started from for R/G/B/W:
Red Green Blue White
x 0.62700 0.29600 0.15200 0.31100
y 0.33700 0.58900 0.06400 0.16200
Y 16.58200 56.14500 5.76900 79.23100
Using your spreadsheet, under NEW TARGETS it comes up with a weird recommendation for Red Y of 54.42373, Green of 4.31013, Blue 20.49714. Possibly a rotation of variables somewhere? The corresponding calculated values from Accupel are: 16.582, 56.145, 5.769.
Another discrepancy with Accupel, the recommedations for the secondaries: the spreadsheet derives for the secondaries:
Yellow Cyan Magenta
0.61265 0.15522 0.31123
0.34792 0.07573 0.15551
58.73386 24.80727 74.92087
The yellow xy is about where Red is on the CIE chart, the Magenta xy is about where White is, and Cyan is about where Blue is. The corresponding recommendation from Accupel gives:
Yellow Cyan Magenta
0.415 0.224 0.323
0.498 0.327 0.163
73.2254 61.3788 23.8578
I don't have the article, yet. My usual book/magazine store had the Nov 2008, but not the Dec 2008, so I've not been able to verify the formulas. I probably need to make the tour of several more bookstores this weekend to see where I can find the Dec issue.