Coldbreak Brewing HERMS Giveaway!

HomeBrewSupply AMCYL Brew Kettle Giveaway!


Home Brew Forums > Home Brewing Beer > Brewing Software > EBC or SRM to color RGB
Reply
 
Thread Tools
Old 05-29-2010, 07:02 AM   #11
oooFishy
Feedback Score: 0 reviews
Recipes 
 
Join Date: Mar 2006
Posts: 86
Default

Is there a built in excel function to read those values, or do I need to download something?


oooFishy is offline
 
Reply With Quote
Old 05-31-2010, 07:32 PM   #12
oooFishy
Feedback Score: 0 reviews
Recipes 
 
Join Date: Mar 2006
Posts: 86
Default

bump

Could anyone let me know how to read RGB values in excel?


oooFishy is offline
 
Reply With Quote
Old 05-31-2010, 09:34 PM   #13
passedpawn
Waste Allocation Load Lifter - Earth Class
HBT_MODERATOR.png
Feedback Score: 1 reviews
 
passedpawn's Avatar
Recipes 
 
Join Date: Apr 2009
Location: ☼ Clearwater, FL ☼
Posts: 22,038
Liked 4831 Times on 2887 Posts
Likes Given: 4047

Default

Copy the data above, drop in a txt file (notepad), use replace menu item to replace commas with periods, replace spaces with commas, open in excel, choose "data separated by commas" (tab is the CSV default).

You'll need to use VBA to plot color in a cell, if that's what you're looking for.
__________________
- Andrew
passedpawn is offline
 
Reply With Quote
Old 08-06-2010, 03:29 AM   #14
ajdelange
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
Recipes 
 
Join Date: Aug 2010
Location: McLean/Ogden, Virginia/Quebec
Posts: 7,729
Liked 1027 Times on 812 Posts
Likes Given: 31

Default

Tristimulus values (R,G,B) cannot be calculated for a particular SRM because
1. The color formed depends on the thickness of beer through which the light is shining. Darker and redder the wider the glass.
2. The color formed depends on the nature of the illuminant. Redder with "warm" illuminants (A) and bluer with "cooler" (D65).
3. The color perceived depends on whether the beer is held close to the eye (10 Observer) or farther away (2 Observer).
4. The values of R,G,B depend on the color space (sRGB, NTSC, Rec. 709....)
5. Even if conditions 1-4 are the same beers with the same SRM may look totally different. For example, Lindeman's Kriek and Fuller's ESB both have the same SRM but the kriek is much darker and redder.

About the best that can be done is to establish typical viewing conditions: 5 cm path, illuminant C, 2 Observer, sRGB, for example, and then compute colors based on an "average" spectrum. There is a spreadsheet at www.wetnewf.org that will allow you to do this.
ajdelange is offline
 
Reply With Quote
Old 12-02-2010, 02:34 PM   #15
methodbeer
Feedback Score: 0 reviews
Recipes 
 
Join Date: Dec 2010
Location: Raleigh, NC
Posts: 17
Liked 2 Times on 2 Posts
Likes Given: 1

Default

Based on Soren's awesome SRM to RGB values, I whipped up a quick ini file that can do some quick calculations for you:

http://methodbrewery.com/srm.php

Coming soon, I'll add in a convert to Hex button just for kicks and some sample beer styles & brands along the beautiful beer color gradient!
methodbeer is offline
 
Reply With Quote
Old 12-02-2010, 04:05 PM   #16
ajdelange
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
Recipes 
 
Join Date: Aug 2010
Location: McLean/Ogden, Virginia/Quebec
Posts: 7,729
Liked 1027 Times on 812 Posts
Likes Given: 31

Default

As noted in #14 one cannot produce RGB values from SRM without specifying the path, the illuminant, the observer and some information about the spectral deviation of the beer from "average". The Wikipedia article referenced at
http://methodbrewery.com/srm.php (which I wrote though it has been dicked with to some extent - that's Wikipedia) goes into this in some more detail. It is pointless to calculate and display RGB colors unless you specify what path, what illuminant... etc. and verify that the colors are indeed likely to be beer colors. The colors in the chart in the Wikipedia article are not valid beer colors, for example which means that for the specified SRM values I cannot come up with any combination of path, illuminant, observer and spectrum deviation coefficients which give me the colors in the swatches.
ajdelange is offline
 
Reply With Quote
Old 10-20-2012, 06:30 PM   #17
DangMan
Feedback Score: 0 reviews
Recipes 
 
Join Date: Oct 2011
Location: vejle, denamrk
Posts: 8
Likes Given: 1

Default

#600903 -> 32 should be #560A05

I entered all the colors into a database and made a color table with it, and number 32 was not right ! So i took 31 and 33 and took the average !
Othervise a realy cool chart, thanks

Quote:
Originally Posted by Boerderij_Kabouter View Post
Here is the code list from the above listed sight. Sorry HBT, but I like these colors WAY more.

code -> SRM

#FFE699 -> 1
#FFD878 -> 2
#FFCA5A -> 3
#FFBF42 -> 4
#FBB123 -> 5
#F8A600 -> 6
#F39C00 -> 7
#EA8F00 -> 8
#E58500 -> 9
#DE7C00 -> 10
#D77200 -> 11
#CF6900 -> 12
#CB6200 -> 13
#C35900 -> 14
#BB5100 -> 15
#B54C00 -> 16
#B04500 -> 17
#A63E00 -> 18
#A13700 -> 19
#9B3200 -> 20
#952D00 -> 21
#8E2900 -> 22
#882300 -> 23
#821E00 -> 24
#7B1A00 -> 25
#771900 -> 26
#701400 -> 27
#6A0E00 -> 28
#660D00 -> 29
#5E0B00 -> 30
#5A0A02 -> 31
#600903 -> 32
#520907 -> 33
#4C0505 -> 34
#470606 -> 35
#440607 -> 36
#3F0708 -> 37
#3B0607 -> 38
#3A070B -> 39
#36080A -> 40
Click image for larger version

Name:	ebc32.png
Views:	2276
Size:	16.4 KB
ID:	80375  

Reason: Uploaded image
DangMan is offline
 
Reply With Quote
Old 10-20-2012, 07:27 PM   #18
ajdelange
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
Recipes 
 
Join Date: Aug 2010
Location: McLean/Ogden, Virginia/Quebec
Posts: 7,729
Liked 1027 Times on 812 Posts
Likes Given: 31

Default

As noted in #16 and #14 you cannot map SRM to color. Very significant in this is that the gamut of modern display systems is much smaller than the gamut of beer colors (which become quite saturated even for modest SRM). IOW you can't do what you are trying to do. If you are going to publish a mapping anyway you are obliged to at least indicate what set of viewing conditions you think this mapping approximates and you especially need to indicate the color space to which your numbers belong. The BJCP guide tries to do what you are trying to do but it states very clearly that the color patches represent 1 cm of beer of average spectral characteristics (which in this case does include some krieks etc.), Illuminant C and the 2 observer.
ajdelange is offline
 
Reply With Quote
Old 11-01-2012, 07:37 PM   #19
DangMan
Feedback Score: 0 reviews
Recipes 
 
Join Date: Oct 2011
Location: vejle, denamrk
Posts: 8
Likes Given: 1

Default

Not relevant, its for my own brewing programme, no intensions making it public !

But thanks for the note !
DangMan is offline
 
Reply With Quote
Old 11-01-2012, 08:26 PM   #20
ajdelange
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
Recipes 
 
Join Date: Aug 2010
Location: McLean/Ogden, Virginia/Quebec
Posts: 7,729
Liked 1027 Times on 812 Posts
Likes Given: 31

Default

Glad you popped up again - I couldn't remember where this thread was. I did remember that I made a graphic with the colors of 'average' beer as a function of SRM and path for Illuminant C in the sRGB space. It is appended. As you will see if you use your computer's color analysis capabilities, clipping occurs (in the Blue channel) at about 12 SRM for a 1 cm path and at 3 SRM for a 5 cm path. Thus the conclusion that except for very light beers or beers observed in a very short path you can't represent beer color very well on a computer monitor.

Looking back over the thread which I recognize is old I see there was a question as to a formula. There is a formula in the Wikipedia article Standard Reference Method which gives the transmission spectrum of 'average' beer (including lambics etc.). Assuming you know something of color theory you will know how to insert that spectrum into the ASTM E-308 algorithm to calculate X, Y, and Z and how to transform those to sRGB or any other color space which can be tied to XYZ.


Click image for larger version

Name:	BeerColors.jpg
Views:	6501
Size:	36.8 KB
ID:	81934  
ajdelange is offline
 
Reply With Quote
Reply


Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
color cshort4 Beginners Beer Brewing Forum 3 08-18-2009 02:19 PM
Color to B+W ShortSnoutBrewing Label Display & Discussion 14 05-06-2009 01:28 AM
Is kraeusen color indicative the finished product's head color? nukebrewer General Beer Discussion 2 10-28-2008 11:11 PM
Help with Color razyrsharpe Extract Brewing 8 01-04-2008 04:47 PM
Color CAlexander General Techniques 7 05-31-2007 08:21 PM


Forum Jump

Newest Threads

LATEST SPONSOR DEALS