PDA

View Full Version : Dilution ratio matrix



RippyD
06-06-2017, 01:12 PM
RippyD's dilution table (https://docs.google.com/spreadsheets/d/1Ga7a8CMQjCM-e2y_NOBWxd92MrIEEPxO-eVhp9uDfvU/edit?usp=sharing)

People have posted the CG one (http://www.chemicalguys.com/How_To_Dilute_Car_Wash_Chemicals_s/373.htm) here previously, and it's excellent. I wanted something that covered more measures and ratios. I also added a table for commonly used products. My goal was to be able to mix whatever I want quickly without having to go to a PC to look up ratio or think about conversions.

Sharing this as a Google sheet so anybody can customize, add, or remove items. This prints as a one-pager. Couple of additional comments:



I have less than a 1/4 cup or gallon grayed out. It's just noise to me - below those amounts I'm using a different measure
To add a new dilution ratio just add a row, put the ratio in the far left column, and cut/paste the others cells from another row


Feedback is welcome, but keep in mind that you easily edit for your own usage. For me the 5 gal and mL are unnecessary and I'll likely remove them.

Eldorado2k
06-06-2017, 01:42 PM
Hopefully this helps.

http://dilutioncalc.com

RippyD
06-06-2017, 02:02 PM
That calculator is good. I usually don't want to go to a PC when I'm gloved up and working. If I need something while I'm in the garage, I prefer to have a chart on the wall I can review. Most important for me is the ratios for all the various product uses. But... having a tablet that lives in the garage is maybe not a bad way to go...

Eldorado2k
06-06-2017, 02:05 PM
I use it on my phone which is on me at all times.. I created its own tab so it's available with 1 touch from my home screen.

Cruzscarwash
06-06-2017, 02:09 PM
thanks man, this is helpful

atgonzales
06-06-2017, 02:33 PM
Thank you, Rippy

LSNAutoDetailing
06-06-2017, 02:52 PM
Nice chart! I'll be sure to print and past on the product cabinet door. I have a good one on there now... but this is very granular.

HockeyCrazi
06-06-2017, 03:19 PM
I like this, thank you!

Joe@NextLevelDetail
06-06-2017, 03:27 PM
Really nice chart!

Thanks for taking out the time to make this and share to help others.

cleanmycorolla
06-06-2017, 03:34 PM
Excellent chart, i'd love to contribute can I get access or at least give you some product info i have handy? It'd be great if people could add on the fly, i think people here are all good enough to contribute in a proper manner.

AWESOME job!

RippyD
06-06-2017, 04:32 PM
Excellent chart, i'd love to contribute can I get access or at least give you some product info i have handy? It'd be great if people could add on the fly, i think people here are all good enough to contribute in a proper manner.

AWESOME job!
I can make changes up to a point. Tell me what you want to add. If you go to the File menu and select "Save a copy" you'll then have one you can edit.

RippyD
06-25-2017, 07:42 PM
Chart updated. More readable now. Also added a cost per gallon table. To print only what you want, highlight those cells, then select print. In the print dialog that opens the first open is the area to print. Of you choose "selected cells" and then fit to page, just the container measures or the measures + product ratios can be printed.

Also added a few more rinseless/waterless products and a few APCs to the product table.

Mike Honcho
06-26-2017, 07:54 AM
Hopefully this helps.

http://dilutioncalc.com

That's the one I use. EZPZ!


Sent from my iPhone using Autogeekonline mobile app (http://r.tapatalk.com/byo?rid=87407)

Old Girl
07-24-2017, 06:30 PM
Thank you so much! Trying to word it correctly to get what you want on the internet is a p*** Thank you!

RippyD
07-24-2017, 07:24 PM
That's the one I use. EZPZ!
That's an excellent calculator. I use it as well.


Thank you so much! Trying to word it correctly to get what you want on the internet is a p*** Thank you!
Np. A few comments:


I added a few more products and a few more ratios. If too busy just save a copy and delete the rows you don't need
Made a few cosmetic changes to make it easier to navigate when you're hands are full of product
Any ratio can now be entered - so it can be 200:1, 1:200, 2:400, or whatever else you like. It will assume the larger portion is water

If anybody has problems printing I'll post PDFs and share on Google.