EBC or SRM to color RGB - Page 2 - Home Brew Forums
Home Brew Forums > Home Brewing Beer > Brewing Software > EBC or SRM to color RGB
Cool Brewing Giveaway - Supporting Membership Drive & Discount

Reply
 
Thread Tools
Old 05-29-2010, 07:02 AM   #11
oooFishy
Recipes 
 
Mar 2006
Posts: 85

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



 
Reply With Quote
Old 05-31-2010, 07:32 PM   #12
oooFishy
Recipes 
 
Mar 2006
Posts: 85

bump

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



 
Reply With Quote
Old 05-31-2010, 09:34 PM   #13
passedpawn
Waste Allocation Load Lifter - Earth Class
HBT_ADMIN.png
 
passedpawn's Avatar
Recipes 
 
Apr 2009
☼ Clearwater, FL ☼
Posts: 25,013
Liked 6381 Times on 3782 Posts


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

 
Reply With Quote
Old 08-06-2010, 03:29 AM   #14
ajdelange
HBT_LIFETIMESUPPORTER.png
Recipes 
 
Aug 2010
McLean/Ogden, Virginia/Quebec
Posts: 8,803
Liked 1313 Times on 1005 Posts


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.

 
Reply With Quote
Old 12-02-2010, 02:34 PM   #15
methodbeer
Recipes 
 
Dec 2010
Raleigh, NC
Posts: 17
Liked 2 Times on 2 Posts


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!

 
Reply With Quote
Old 12-02-2010, 04:05 PM   #16
ajdelange
HBT_LIFETIMESUPPORTER.png
Recipes 
 
Aug 2010
McLean/Ogden, Virginia/Quebec
Posts: 8,803
Liked 1313 Times on 1005 Posts


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.

 
Reply With Quote
Old 10-20-2012, 06:30 PM   #17
DangMan
Recipes 
 
Oct 2011
vejle, denamrk
Posts: 8


#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:	3569
Size:	16.4 KB
ID:	80375  

Reason: Uploaded image

 
Reply With Quote
Old 10-20-2012, 07:27 PM   #18
ajdelange
HBT_LIFETIMESUPPORTER.png
Recipes 
 
Aug 2010
McLean/Ogden, Virginia/Quebec
Posts: 8,803
Liked 1313 Times on 1005 Posts


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.

 
Reply With Quote
Old 11-01-2012, 07:37 PM   #19
DangMan
Recipes 
 
Oct 2011
vejle, denamrk
Posts: 8


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

But thanks for the note !

 
Reply With Quote
Old 11-01-2012, 08:26 PM   #20
ajdelange
HBT_LIFETIMESUPPORTER.png
Recipes 
 
Aug 2010
McLean/Ogden, Virginia/Quebec
Posts: 8,803
Liked 1313 Times on 1005 Posts


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:	10699
Size:	36.8 KB
ID:	81934  

 
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