Green Wash Roof Mix Spreadsheet - Certified SoftWash Roof Cleaning

Paul Freeman · Junior Member

Green Wash Roof Mix Spreadsheet

Doug Rucker · UAMCC Officer

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

Ray Burke · Community Member

Thank you! Can't wait to play around with this!

Glen Evans · Sophmore Member

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

Glen

Paul Freeman · Junior Member

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.

Glen Evans · Sophmore Member

Doug Rucker wrote:
cant download it, says I need a newer version of excell

Doug, here is a PDF file for you.

Paul Freeman · Junior Member

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!

Glen Evans · Sophmore Member

Got a love the copy and paste. LOL

Doug Rucker · UAMCC Officer

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.

Doug Rucker · UAMCC Officer

Paul thanks for doing this. This took a lot of work and will be very useful to a lot of people. We appreciate you doing this.

AC Lockyer · Administrator

Paul, THANKS.

Now everyone needs to go to an AG supply house and buy a graduated 128 ounce measuring cup.

AC

Marcus Raif · Junior Member

Thanks Paul for sharing the roof cleaning green wash mix spreadsheet that you made.

Steve Salley · Junior Member

Paul
Thanks for making it "K.I.S.S". This labor of love is very much appreciated.

Have a great day!

Paul Freeman · Junior Member

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

-- Edited by Exterior Cleaning NW Florida on Monday 6th of February 2012 09:39:17 PM

Marcus Raif · Junior Member

Be aware that 15% breaks down quickly to 12% and later to 10%and eventually it turns back into sea water... It is affected by the temperature and the ultra violet rays of the sun. Therefore to have a longer shelf life for SH store it in a cool shaded area. That is why I paint the SH tank on my trailer a silver color to reflect the suns rays and to keep the mix cool in the summer.

Please click on the Facebook link under my business card and you will be taken to my Facebook Fan page where you can Like us.

Thanks in advance,
Marcus

-- Edited by Marcus on Monday 6th of February 2012 10:00:51 PM

Schall Bradley · Sophmore Member

Thanks Paul this will be a great help and get the " Yea that looks about right" out of the mixing, saving time and materials.

Always SoftWash · Freshmen Member

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?

Laurie Benjamin · Lead Tech Certified

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

Laurie Benjamin · Lead Tech Certified

Just saw this Paul...Thanks again

Peter Blau · Sophmore Member

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.

Michael Derose · SoftWash Systems Certified Applicator

For a 30 gallon mix i would go 10 gallons of SH, 20 gallons of water, and 12 oz of green wash

Marcus Raif · Junior Member

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.

Peter Blau · Sophmore Member

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.

-- Edited by CEC on Friday 26th of October 2012 07:08:02 AM

Doug Rucker · UAMCC Officer

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 %.

Peter Blau · Sophmore Member

Great Advice! Thanks

Marcus Raif · Junior Member

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.

Paul Freeman · Junior Member

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

Doug Rucker · UAMCC Officer

Paul how are you, haven't seen you on the BBS in awhile. Hope all is well

Paul Freeman · Junior Member

Doug, we're going okay. Hope all is well for you and yours too.

Besides campaigning for the next POTUS and anticipating pro-business election results Tuesday night... and praying the current tenant of 1600 Pennsylvania Avenue is given a one way ticket out of the District of Columbia, there's not much to do here because people are holding their money as close to the vest as they are their Bibles and guns, IMHO - of course!

I hope the spreadsheet is working out for you.

Regards,
Paul

Jason Reider · Freshmen Member

Great information and resource Paul. Thanks for posting this!

Woody Schmidt · Lead Tech Certified

What a great tool, thanks Paul. I've found this very helpful when I'm diluting my remaining roof mix for a house wash. Makes life easier.

FIRST STATE ROOF & EXTERIOR CLEANING

FIRST STATE ROOF & EXTERIOR CLEANING

FIRST STATE ROOF & EXTERIOR CLEANING