Starsan--have I got this right?

[jmc]

I found a handy Excel spreadsheet that calculates the right amounts based on a conversation with Starsan themselves. http://community.mrbeer.com/media/kunen ... _San_B.xls Now if some bright spark can make a metric version we're all in business.

Thanks for that. Very useful.

It will be in US pints (16oz) & gallons no doubt.

Looking at formula its based on starsan SG being 29.57/28.3495= 1.043
I'm sure we could create a UK one for Jim's calculators section.

[orlando]

I found a handy Excel spreadsheet that calculates the right amounts based on a conversation with Starsan themselves. http://community.mrbeer.com/media/kunen ... _San_B.xls Now if some bright spark can make a metric version we're all in business.

Thanks for that. Very useful.

It will be in US pints (16oz) & gallons no doubt.

Looking at formula its based on starsan SG being 29.57/28.3495= 1.043
I'm sure we could create a UK one for Jim's calculators section.

There is a section showing ml amounts to add but this is based on US measurements for amount of diluted SS required.

[jmc]

Having just bought some Starsan but not having used it (nor made any up) yet, I thought that it states 300:1 dilution - which would be about 3.3ml per litre rather than 1.6... Have I got it wrong?

_

I found a handy Excel spreadsheet that calculates the right amounts based on a conversation with Starsan themselves. http://community.mrbeer.com/media/kunen ... _San_B.xls Now if some bright spark can make a metric version we're all in business.

I used the above calculator. I entered 1litre = 0.264172 US gallons (according to Google conversion)
Calculator comes up with 1.56 ml, so 1.6ml/Litre should be OK.


BTW: I had to copy & paste to a new worksheet to get around protection stopping editing number of decimal places displayed.

[Underscore]

Having just bought some Starsan but not having used it (nor made any up) yet, I thought that it states 300:1 dilution - which would be about 3.3ml per litre rather than 1.6... Have I got it wrong?

_

I found a handy Excel spreadsheet that calculates the right amounts based on a conversation with Starsan themselves. http://community.mrbeer.com/media/kunen ... _San_B.xls Now if some bright spark can make a metric version we're all in business.

I used the above calculator. I entered 1litre = 0.264172 US gallons (according to Google conversion)
Calculator comes up with 1.56 ml, so 1.6ml/Litre should be OK.


BTW: I had to copy & paste to a new worksheet to get around protection stopping editing number of decimal places displayed.

Interesting. Looking at the spreadsheet, it is using a proportion of 0.0015625 - or 640:1 dilution. As the spreadsheet points out, this matches the 1oz to 5 (US) gallons on the label but elsewhere the label definitely says 300:1. May be it is effective (and still rinse free) at a range of dilutions. Still, if everyone is using 640:1 without a problem, that's all that matters. I will probably go with 500:1 simply because I've bought a 500ml spray bottle...

Cheers!

_

[jonnyt]

Then you would need a 501ml spray bottle

[jmc]

I found a handy Excel spreadsheet that calculates the right amounts based on a conversation with Starsan themselves. http://community.mrbeer.com/media/kunen ... _San_B.xls Now if some bright spark can make a metric version we're all in business.

I've uploaded 1st draft of a UK/Metric version here (StarSan_UK.xls). Feel welcome to download and try it out.
Feedback welcome. Please tell me about any errors or improvements so I can update.
(eg I can probably add a gram converter to in case anyone wants to weigh StarSan added in g)

[orlando]

Excellent work John, now, er would you like to do one for PBW as well ?

[Underscore]

Then you would need a 501ml spray bottle

Darn! OK, I'll dilute it at 499:1 instead.

[jmc]

Excellent work John, now, er would you like to do one for PBW as well ?

Thanks

For PBW sheet, would it need to be based on Five Star PBW Tech Sheet (PDF)?

From this dosage varies for recirculation cleaning 1-3 oz per US gallon, depending on how badly soiled kit is.
Therefore would you need 3 drop-down options , for light, medium & heavy soiled equipment? (1,2,3?)

[orlando]

That would make sense. On the product packaging there is a different regime based on whether it is CIP or individual bits of kit to be soaked. Other than that I don't know. There was someone who reinterpreted the instructions for metric use so that is on the forum somewhere, I will have a dig round and repost the thread if I find it.

[jmc]

That would make sense. On the product packaging there is a different regime based on whether it is CIP or individual bits of kit to be soaked. Other than that I don't know. There was someone who reinterpreted the instructions for metric use so that is on the forum somewhere, I will have a dig round and repost the thread if I find it.

Is this the topic?
PBW instructions translated to metric

[orlando]

Yes, I found out yesterday from a printed off version that it was stich and was going to post today but only just finished a brewday, an old fashioned mild, so well done for finding it.

[jmc]

Hi orlando.
As requested, I uploaded an Excel PBW calculation sheet yesterday evening.
I thought it better if its on a separate topic
see PBW - Excel Calculation sheet

You need to enter:
a) Litres of cleaning solution you are making
and
b) Drop down list of type of cleaning you're doing.
ATB John

[dedken]

Depends how tight you want to be! The dilution rate is actually printed on the bottle. 1ml/500 is more than enough by their calculations. Which means that it is DIRT CHEAP. Basically.

I'll top up every now and then with mineral water and a little drop of Star San and check with pH strip. It's always below 2.5 so plenty acidic enough.

[orlando]

Depends how tight you want to be! The dilution rate is actually printed on the bottle. 1ml/500 is more than enough by their calculations. Which means that it is DIRT CHEAP. Basically.

Unlike PBW which is horrendously expensive, if only they would bring that down in price I wouldn't use anything else.