The attached spreadsheet calculates the quantitys of water, SH, and Green Wash needed to make a batch of mix based on 3 input variables: Desired Gallons of Mix, Desired Strength of Mix, and Strength of SH per Gallon.

You can change the input variables to any quantities you like.

If you don't like working with fractions you can change the output varables to whole numbers by highlighting colums E, F and G, then right click/format cells/Category: number/decmial places: 0

You can also go the other way to expand the number of decimal places to achieve more exact amounts.

I keep a one page version of this spreadsheet, in 10 gallon increments, in my truck log.

To compress the spreadsheet you can hide Row(s) by highlighting the rows you want to hide, then right click/hide

This spreadsheet was developed using Microsoft Excel 2007.

If you see any ways to improve this document, let me know, I'll work on it as time permits.

Have a great day.

Paul

Thank you. How is your fingers after figuring all that out ? LOL 

Glen

Doug Rucker wrote:

---

cant download it, says I need a newer version of excell

---

Doug,

Download the Excel 2007 viewer from the Microsoft website. You won't be able to customize it to your liking, but you will be able to view it.

Doug Rucker wrote:

---

cant download it, says I need a newer version of excell

---

 Doug, here is a PDF file for you.

Glen, I only typed the first line using AC's, 100 gallon chart as a guide. Then, after I proved the numbers using a bunch of different variables, I copied and pasted the other 299 lines!

Got a love the copy and paste. LOL 

Glen wrote:

---

Doug Rucker wrote:

---

cant download it, says I need a newer version of excell

---

 Doug, here is a PDF file for you.

---

 Thanks Glen, got it now.

Always SoftWash wrote:

---

Thanks Paul for the chart, this will be a big help.

I do have a question about the strength of SH you have listed 10 percent and I'm buying it at 12.5 percent, will this make a difference? If so how do I figure the change?

---

 John,

There are two spreadsheets in that workbook. The first one is using 10% SH and the second uses 12.5%

You can copy either spreadsheet to make a 3rd spreadsheet in the workbook. Then just do a global change on Desired Strength of Mix or Strength of SH per Gallon. Or, you can change the input variables in either sheet to whatever you want. For example, lets say you want to make 50 gallons of mix at 4% strength and you have 15% SH (per gallon).

You would enter 50 into the Desired Gallons of Mix variable, enter 4 into the Desired Strength of Mix variable, and enter 15 into the Strength of SH per Gallon variable. As soon as you enter the third variable and hit enter or Tab, excell will have recomputed the answer. Excel actually recomputes everytime you change a single input variable and hit the Tab or Enter button, but don't pay any attention to the new answer until you've entered all 3 input variables. That's very IMPORTANT! If you intended to change all 3 input variables but only changed 2, the computed mix formula WILL BE WRONG.  Be careful when changing those input variables. It's okay to change them, but MAKE SURE ALL 3 INPUT VARIABLES ARE WHAT YOU INTENDED THEM TO BE.

Hope that helps.

Paul

Thanks Paul for the chart, this will be a big help.

I do have a question about the strength of SH you have listed 10 percent and I'm buying it at 12.5 percent, will this make a difference? If so how do I figure the change?

Wow....Thanks.. If i am using 8% strength bleach, how do i change that variable?

Just saw this Paul...Thanks again

Hi Paul,

Thank you so much for posting this. I was banging my head against a wall (not literally) trying to figure for sure  what the mix would be using a 30 gallon tank. Right now that's all I have. And just getting into the whole softwash method from the pressure cleaning method with the mix ratios is a challenge. One reason is because I have a pool supply near me that only stocks 12.5% SH and AC's mixology chart just gives calculations for 10% SH. Oddly enough the calculations I did for a 3% Bleach Cleaning Solution were spot on with what your chart produced. Scary.

Water: 23-24 gallons

SH 12.5%: 6-7 gallons

GW: 19-20 oz

I thought when I go do this for the first time I will have to bring down the SH amount and just add more as needed. Now I don't have to guess. Your chart has helped a great deal. Thanks again.

BTW what kind of mix do you use for other things than the roof i.e. different types of siding, concrete, wood shake shingles, decks, etc.

On a side note, maybe AC should make this more readily available for the newbies on the main site (just a thought AC if you read this)

Also, I checked out your forum where you have a link. But the link didn't work.

The formulas sound nice but you are leaving several variables out.  What type of roof is it and how dirty is it.  Tile roofs usually require a 50/50 mix of SH/H20 where as composite roofs require a 30/70 mix.  That is the minimum that I use in regard to SH.  If the roof is very dirty then I use more SH & less H20. 

I hear of many people talking about how little SH they use.  When you have a lot of work I have found that I like to use more SH so I do not have to clean the are more than once.  Time is money and is more valuable than SH.  I would rather use more SH and squeeze an extra job in for the day.

Thanks guys for the suggestions. I am going to have to just experiment and see. I know that there is no exact formula being there are so many different variables. But it's important, I think to be able to have something in place to start from to minimize the learning curve.

Great Advice! Thanks

Doug Rucker wrote:

---

My theory is new guys should never use more than a 3% mix and NEVER 50/50. Tis better to spray a couple more applications, (work on your spray technique, less SH means less chance of damage to plants, etc etc) and TAKE YOUR TIME and BE PATIENT than flood a roof, and be in a hurry, and possibly cause more damage than the price of the whole job. Once experience is gained, and you are booked solid everyday then you can up the SH %.

---

 Very good point Doug!  You have to learn to walk before you run.

Just a reminder folks...

The input fields to the left of the equal sign on the spreadsheet (Desired Gallons of Mix, Desired Strength of Mix, and Strength of SH per Gallon) are variables. In other words you can change them to whatever values you need to work with. Before doing that you might want to copy one of the existing workbooks and put it at the end of the spreadsheet with a new name.

Another thing you can do is expand the tables in the existing workbooks by copying and pasting lines onto the end of the individual workbooks. For example, if you work with 4 or 5% (40 or 50%) batches of mix, just copy all the lines in the 2 and 3% tables and append the copied lines to the end of the workbook. Then, change the Desired Strength of Mix variable of each line to 4 or 5 respectively.

If you're really feeling slick, you can change any of the variables to the left of the equal sign on the fly. Just make sure all 3 variables to the left of the equal sign represent your inputs for the batch of mix you're making.

Regards,
Paul