File:Splash Wall Ink Saver Range Blaster Chart.png

Formula
A = Ink Saver (Main) % change = (0.99*x-(0.09*x)^2)/(200/3)

B = Ink Saver (Sub) % change = (0.99*x-(0.09*x)^2)/(600/7)

C = Ink consumption of Splash Wall = 60.01*(1-B)

D = Ink consumption of Range Blaster = 10*(1-A)

Blasters recover (5/3)% of the ink tank after every shot. The Splash Wall prevents ink recovery for the first 3 Range Blaster blasts.

E = Number of blasts after deploying Splash Wall, without counting ink recovered between shots = (100-C)/(D)

F = Extra blasts from the ink recovered while firing E shots = IF(ROUNDDOWN(E,0)>3,(ROUNDDOWN(E,0)-3)*(5/3)/D,0)

G = Extra blasts from the ink recovered while firing F shots = ROUNDDOWN(F,0)*(5/3)/D

The ROUNDDOWN(number,0) function rounds the number of blasts down to a whole number.

The IF(logical_test, value_if_true, value_if_false) function is used to prevent ink recovery from being calculated for the first 3 blasts.

Total blasts = ROUNDDOWN(E+F+G,0)