|
Main Menu
|
|
|
|
Detailing
|
|
|
|
|
*New*
|
*New*
|
|
|
|
|
|
|
|
|
|
|
|
|
|
*New*
|
|
|
|
|
|
|
|
|
|
|
|
*New*
|
|
*New*
|
|
|
4Runner History
|
|
|
|
Other
|
|
|
|
|
Concept:
Welcome to my Foam Cannon Dilution Ratio and Panel Impact Ratio (PIR) Calculator webpage.
One of the most misunderstood topics in automotive detailing is foam cannon dilution. Many enthusiasts simply fill their foam cannon bottle with a random amount of soap and water without understanding how much shampoo is actually reaching the vehicle's paint surface.
The reality is that different foam cannons consume solution at dramatically different rates.
Some foam cannons may run for over two minutes on a full bottle while others may empty their bottle in sixty seconds.
Some cannons draw concentrate aggressively while others are designed to be more economical.
As a result, simply copying another person's soap to water mixture often produces very different results.
To better understand these differences, I developed the Foam Cannon Spreadsheet which measures a foam cannon's native dilution characteristics
and then calculates the exact soap and water quantities required to achieve a desired Panel Impact Ratio (PIR).
The spreadsheet also includes runtime normalization calculations which allow different foam cannons to be compared on an equal basis regardless
of bottle size, dilution characteristics or chemical consumption rates.
The goal is to remove the guesswork and provide a repeatable, data-driven approach to foam cannon setup.
Download My Foam Cannon Calculator Spreadsheet!
Example Foam Cannon Spreadsheet Output
|
Understanding Native Dilution Ratio Testing:
The foundation of the spreadsheet is the Native Dilution Ratio Test.
“Native dilution ratio” is how much a foam cannon automatically mixes water and soap internally
during spraying. It shows how much the solution is diluted by your pressure washer setup alone. For example,
an 9:1 ratio means 9 parts water for every 1 part soap. This number helps determine the Panel Impact Ratio
(PIR) or final soap strength actually hitting your vehicle’s surface.
In short, this test determines how much total foam solution a foam cannon produces from a known quantity of liquid drawn from the bottle..
For example:
Suppose the foam cannon consumes the entire 1,000ml bottle and produces 10,000ml of total output.
Of that 10,000ml:
The foam cannon therefore mixed:
9,000ml water
1,000ml bottle solution
which results in a dilution ratio of:
9:1
or:
9 parts water
1 part bottle solution
Once the Native Dilution Ratio (9:1) is known, the spreadsheet can calculate the exact amount of soap and water required within the
bottle to achieve a desired Panel Impact Ratio (PIR).
These measurements form the foundation of all subsequent calculations contained within the spreadsheet.
Selecting Your Desired Panel Impact Ratio (Cell I2):
The spreadsheet allows the user to select a desired Panel Impact Ratio (PIR) using the dropdown menu in Cell I2.
Three operating modes are currently available:
pH Neutral Washing 0.5%
Touchless Moderate 1.5%
Touchless Maximum 2.0%
After selecting the desired PIR, the spreadsheet automatically calculates the exact amount of soap and water required to achieve that target based upon the tested dilution characteristics of each individual foam cannon.
Important Disclaimer, your results may vary
While this testing provides a useful baseline, every pressure washing system is unique.
Factors that can significantly influence results include:
Pressure washer model
Motor design
Pump design
Household voltage
Circuit wiring
Extension cord use
Incoming water pressure
Water temperature
Water hardness
Hose length
Hose diameter
Hose construction
Spray gun design
Foam cannon design
Soap formulation
Soap dilution ratio
For this reason, users should perform their own dilution testing and enter their own measured data into the spreadsheet.
The values contained within my spreadsheet are representative of my specific testing setup and should not be assumed to apply universally.
Runtime Normalization Calculator:
One of the most overlooked aspects of foam cannon testing is runtime. Most enthusiasts focus on bottle size, foam thickness, or soap consumption, but the amount of time a foam cannon can continuously produce foam is often far more important in real-world use.
The problem is that different foam cannons consume solution at dramatically different rates.
Even when loaded with the exact same amount of soap and water, one foam cannon may run for over two minutes while another may empty
the bottle in sixty seconds.
As an example, two of my favorite foam cannons demonstrate this perfectly:
MJJC Pro V3.0: approximately 2 minutes 6 seconds runtime (126 seconds) MJJC S V3.0: approximately 1 minute 43 seconds runtime (103 seconds)
At first glance, both cannons may appear to be using similar amounts of shampoo because they both utilize a 1000ml bottle. However, because the Pro V3.0 runs longer, it is actually distributing its contents over a greater period of time. Simply comparing bottle fill levels therefore does not provide an accurate comparison between the two products.
To solve this problem, the spreadsheet includes a Target Runtime Bottle Fill Calculator.
This calculator allows the user to specify a desired runtime. Once a target runtime is entered, the spreadsheet automatically calculates:
Total bottle fill required Required soap volume Required water volume Maintained target Panel Impact Ratio (PIR)
This makes it possible to compare different foam cannons on an equal basis regardless of their native dilution characteristics or consumption rates.
For example, suppose a user wishes to compare multiple foam cannons while maintaining:
0.5% PIR 100 second runtime. 1:40 is a good runtime to get around my 4th Gen Toyota 4Runner without having much left in the bottle when complete.
The spreadsheet will automatically determine the exact amount of soap and water required for each foam cannon to achieve those conditions.
This creates a true "apples-to-apples" comparison where every foam cannon is operating:
At the same runtime At the same panel impact ratio Using the same shampoo
Without runtime normalization, one foam cannon may appear more economical or more effective simply because it empties its bottle at a different rate.
In practical terms, runtime often matters more than bottle fill level. When washing a vehicle, the user experiences foam production over time, not bottle volume. A cannon that runs longer may allow a complete vehicle to be foamed without refilling, while a cannon with a shorter runtime may require a refill before the job is complete.
Runtime normalization also provides valuable insight into shampoo consumption. By standardizing runtime across multiple foam cannons, users can better understand which products produce the desired results with the least amount of chemical usage.
The ultimate goal is to remove as many variables as possible so that meaningful comparisons can be made between foam cannons. By normalizing both Panel Impact Ratio and runtime, the spreadsheet provides a much more accurate representation of real-world performance than bottle fill levels alone.
While this methodology greatly improves comparison accuracy, users should remember that their individual results may vary due to differences in pressure washers, household voltage, incoming water pressure, hose configuration, foam cannon design, water quality, shampoo formulation, and other system variables. The calculated values should therefore be viewed as a starting point for optimization rather than absolute values that will apply equally to every setup.
Final Thoughts:
The purpose of this spreadsheet is to provide enthusiasts with a repeatable methodology for understanding exactly how their foam cannon
performs and to remove much of the guesswork associated with soap dilution. By measuring a foam cannon's native dilution characteristics
and runtime, it becomes possible to calculate precise soap and water mixtures for virtually any desired washing scenario.
The spreadsheet also serves as the foundation of my Top4Runners foam cannon testing methodology by allowing every foam cannon to be tested
at the same target Panel Impact Ratio (PIR). This eliminates one of the largest variables in foam cannon testing, soap concentration,
and ensures that differences in foam quality, runtime, chemical consumption, and overall performance are attributable to the foam cannon
itself rather than variations in bottle mixtures. As a result, comparisons between products become far more meaningful and repeatable.
The inclusion of the Target Runtime Bottle Fill Calculator takes the concept a step further by recognizing that runtime,
not bottle fill level, is often what matters most during actual vehicle washing. Two foam cannons may utilize the same size bottle,
yet produce foam for dramatically different lengths of time. Normalizing runtime allows more meaningful comparisons between products
while helping users optimize both chemical consumption and washing performance.
It is important to remember that the calculations contained within this spreadsheet are only as accurate as the test data entered.
Small differences in pressure washer design, household voltage, incoming water pressure, hose configuration, foam cannon construction,
water quality, and shampoo formulation can all influence the final results. For that reason, I strongly encourage users to perform
their own testing rather than relying solely on the values contained within my spreadsheet.
Ultimately there is no single "correct" dilution ratio, Panel Impact Ratio, or foam cannon setup. Some users may prioritize maximum
cleaning performance and thick foam for touchless washing, while others may prefer lower chemical consumption and longer runtimes for
routine maintenance washes. The objective of this calculator is not to tell you what settings to use, but rather to provide the data
necessary to make informed decisions based on your own equipment, washing style, and goals.
I hope this spreadsheet proves useful to fellow detailing enthusiasts and helps bring a more scientific, data driven approach to foam
cannon testing and setup. As additional foam cannons are tested and added to my collection, this spreadsheet will continue to
evolve and serve as a valuable resource for comparing performance across a wide range of products.
As always, if you perform your own testing, discover interesting results, or identify opportunities to improve the methodology,
I welcome your feedback. Thank you.
|
|
