PBW - Excel Calculation sheet
- jmc
- Even further under the Table
- Posts: 2486
- Joined: Thu May 13, 2010 11:43 pm
- Location: Swaledale, North Yorkshire
PBW - Excel Calculation sheet
Following on from a request from orlando I've created a 1st version of an Excel calculation sheet to work out weight of PBW to add when making up a cleaning solution.
Variables are
a) Litres of cleaning solution you are making
and
b) Drop down list of type of cleaning you're doing.
*** Edit *** Version 3 now available compatible with Excel 2003, 2007 & 2010
PBW Excel Calc Sheet version 3 available for download here (Excel .xls file).
More Info
*** End Edit ***
Feedback appreciated.
BTW Unfortunately I don't have any PBW.
I could add volume amounts if I knew density of PBW eg weight of teaspoon of PBW (5.91939cc) or (better) weight of 100cc of PBW.
See also
Five Star PBW Tech Sheet (PDF)
Topics
PBW instructions translated to metric
Starsan--have I got this right?
Screenshot
.
Variables are
a) Litres of cleaning solution you are making
and
b) Drop down list of type of cleaning you're doing.
*** Edit *** Version 3 now available compatible with Excel 2003, 2007 & 2010
PBW Excel Calc Sheet version 3 available for download here (Excel .xls file).
More Info
*** End Edit ***
Feedback appreciated.
BTW Unfortunately I don't have any PBW.
I could add volume amounts if I knew density of PBW eg weight of teaspoon of PBW (5.91939cc) or (better) weight of 100cc of PBW.
See also
Five Star PBW Tech Sheet (PDF)
Topics
PBW instructions translated to metric
Starsan--have I got this right?
Screenshot
.
Last edited by jmc on Tue Jan 07, 2014 11:37 pm, edited 1 time in total.
- orlando
- So far gone I'm on the way back again!
- Posts: 7197
- Joined: Thu Nov 17, 2011 3:22 pm
- Location: North Norfolk: Nearest breweries All Day Brewery, Salle. Panther, Reepham. Yetman's, Holt
Re: PBW - Excel Calculation sheet
First class John, thank you very much a really good tool to have. As an example I wanted to just clean my plate chiller from yesterdays brew. I had already given it a good flush but was unhappy as I saw bits of hop coming out. I can get the chiller in a small bucket and have it covered and soaking in as little as 3 litres of water. My guess up till now was approx. 5 grams per litre, your calculator suggests this is light by 2 grams (1,9 to be precise). Another thing I like to do is clean my 2 litre flask for making starters, again small amounts which I can now accurately clean properly.
Brilliant
My only complaint is I will probably be using a lot more PBW and it is wickedly expensive, but not as bad as throwing a brew down the drain.
Brilliant
My only complaint is I will probably be using a lot more PBW and it is wickedly expensive, but not as bad as throwing a brew down the drain.
I am "The Little Red Brooster"
Fermenting:
Conditioning:
Drinking: Southwold Again,
Up Next: John Barleycorn (Barley Wine)
Planning: Winter drinking Beer
Fermenting:
Conditioning:
Drinking: Southwold Again,
Up Next: John Barleycorn (Barley Wine)
Planning: Winter drinking Beer
- orlando
- So far gone I'm on the way back again!
- Posts: 7197
- Joined: Thu Nov 17, 2011 3:22 pm
- Location: North Norfolk: Nearest breweries All Day Brewery, Salle. Panther, Reepham. Yetman's, Holt
Re: PBW - Excel Calculation sheet
On further examination I have noticed that the Non CIP clean has the same cleaning method as CIP.
I am "The Little Red Brooster"
Fermenting:
Conditioning:
Drinking: Southwold Again,
Up Next: John Barleycorn (Barley Wine)
Planning: Winter drinking Beer
Fermenting:
Conditioning:
Drinking: Southwold Again,
Up Next: John Barleycorn (Barley Wine)
Planning: Winter drinking Beer
- jmc
- Even further under the Table
- Posts: 2486
- Joined: Thu May 13, 2010 11:43 pm
- Location: Swaledale, North Yorkshire
Re: PBW - Excel Calculation sheet
I used the cleaning method I saw on the image below, which seems to be the same, apart from a different dosage for all cleaning apart from the Carbonized / Protien stained stuff.orlando wrote:On further examination I have noticed that the Non CIP clean has the same cleaning method as CIP.
I can add other types of cleaning , methods & dosing if you want?
Have you got some way of accurately weighing say 25, 50 or 100cc of PBW so I can add a line indicating number of teaspoons to use?
- orlando
- So far gone I'm on the way back again!
- Posts: 7197
- Joined: Thu Nov 17, 2011 3:22 pm
- Location: North Norfolk: Nearest breweries All Day Brewery, Salle. Panther, Reepham. Yetman's, Holt
Re: PBW - Excel Calculation sheet
I have some gram scales but nothing that I can measure cc's in. I remember there is a podcast somewhere that has John Palmer and possibly Jamil interviewing a guy prom 5 Star that might contain a bit more information, unfortunately I can't remember where or whether it was linked to form on here. If I remember I will point you at it.
I am "The Little Red Brooster"
Fermenting:
Conditioning:
Drinking: Southwold Again,
Up Next: John Barleycorn (Barley Wine)
Planning: Winter drinking Beer
Fermenting:
Conditioning:
Drinking: Southwold Again,
Up Next: John Barleycorn (Barley Wine)
Planning: Winter drinking Beer
- jmc
- Even further under the Table
- Posts: 2486
- Joined: Thu May 13, 2010 11:43 pm
- Location: Swaledale, North Yorkshire
Re: PBW - Excel Calculation sheet
Thanks for suggestion to look for Five Star comments.orlando wrote:I have some gram scales but nothing that I can measure cc's in. I remember there is a podcast somewhere that has John Palmer and possibly Jamil interviewing a guy prom 5 Star that might contain a bit more information, unfortunately I can't remember where or whether it was linked to form on here. If I remember I will point you at it.
I found some useful info from Jim Jennings from Five Star
I've included this info to include added dosage options based on volume. See:
PBW Excel Calc Sheet version 2 available for download here (Excel .xlsx file).
As before feedback appreciated.
I've also added an option to soak for homebrewers as most of the other info was for CIP / commercial cleaning. There's lots of varying suggestions for dosage on the web, but I've based on the dosage in this calc sheet on info from Five Star.
Screenshot
.
- orlando
- So far gone I'm on the way back again!
- Posts: 7197
- Joined: Thu Nov 17, 2011 3:22 pm
- Location: North Norfolk: Nearest breweries All Day Brewery, Salle. Panther, Reepham. Yetman's, Holt
Re: PBW - Excel Calculation sheet
Excellent again John. Just one further question, is there any issues over the length of time varying say by material base of item being cleaned?
I am "The Little Red Brooster"
Fermenting:
Conditioning:
Drinking: Southwold Again,
Up Next: John Barleycorn (Barley Wine)
Planning: Winter drinking Beer
Fermenting:
Conditioning:
Drinking: Southwold Again,
Up Next: John Barleycorn (Barley Wine)
Planning: Winter drinking Beer
- jmc
- Even further under the Table
- Posts: 2486
- Joined: Thu May 13, 2010 11:43 pm
- Location: Swaledale, North Yorkshire
Re: PBW - Excel Calculation sheet
I couldn't see anything specific on PBW's use with different materials apart from a mention onorlando wrote:Excellent again John. Just one further question, is there any issues over the length of time varying say by material base of item being cleaned?
John Palmer - How To Brew - Brewing Metallurgy
A 1% of PBW solution is about 11-12 ph, so its very alkaline, so personally I wouldn't let it sit in Aluminium for long.
See Five-Star MATERIAL SAFETY DATA SHEET (PDF)
- orlando
- So far gone I'm on the way back again!
- Posts: 7197
- Joined: Thu Nov 17, 2011 3:22 pm
- Location: North Norfolk: Nearest breweries All Day Brewery, Salle. Panther, Reepham. Yetman's, Holt
Re: PBW - Excel Calculation sheet
Righto, thanks again.
I am "The Little Red Brooster"
Fermenting:
Conditioning:
Drinking: Southwold Again,
Up Next: John Barleycorn (Barley Wine)
Planning: Winter drinking Beer
Fermenting:
Conditioning:
Drinking: Southwold Again,
Up Next: John Barleycorn (Barley Wine)
Planning: Winter drinking Beer
Re: PBW - Excel Calculation sheet
Gents,
what length of time should i be soaking the fv for?
what length of time should i be soaking the fv for?
- orlando
- So far gone I'm on the way back again!
- Posts: 7197
- Joined: Thu Nov 17, 2011 3:22 pm
- Location: North Norfolk: Nearest breweries All Day Brewery, Salle. Panther, Reepham. Yetman's, Holt
Re: PBW - Excel Calculation sheet
30 minutes is fine for a lightly soiled one.
I am "The Little Red Brooster"
Fermenting:
Conditioning:
Drinking: Southwold Again,
Up Next: John Barleycorn (Barley Wine)
Planning: Winter drinking Beer
Fermenting:
Conditioning:
Drinking: Southwold Again,
Up Next: John Barleycorn (Barley Wine)
Planning: Winter drinking Beer
-
- Steady Drinker
- Posts: 66
- Joined: Tue Jan 22, 2013 6:07 pm
- Location: Newcastle upon Tyne, UK
Re: PBW - Excel Calculation sheet
Many thanks for creating this spreadsheet, version 2 has helped me loads tonight.
- orlando
- So far gone I'm on the way back again!
- Posts: 7197
- Joined: Thu Nov 17, 2011 3:22 pm
- Location: North Norfolk: Nearest breweries All Day Brewery, Salle. Panther, Reepham. Yetman's, Holt
Re: PBW - Excel Calculation sheet
All down to jmc really I was just the slave driver
I am "The Little Red Brooster"
Fermenting:
Conditioning:
Drinking: Southwold Again,
Up Next: John Barleycorn (Barley Wine)
Planning: Winter drinking Beer
Fermenting:
Conditioning:
Drinking: Southwold Again,
Up Next: John Barleycorn (Barley Wine)
Planning: Winter drinking Beer
- jmc
- Even further under the Table
- Posts: 2486
- Joined: Thu May 13, 2010 11:43 pm
- Location: Swaledale, North Yorkshire
Re: PBW - Excel Calculation sheet
Glad it was useful. ATB JohnNorthEastBrewer wrote:Many thanks for creating this spreadsheet, version 2 has helped me loads tonight.