Careful with the formula they sent you. It is correct of course, but has been rearranged to solve for the air space depth instead of the frequency.
Let me know if you get my spreadsheet to work.
Here's a sample calculation (first line in the table).
hole size = 1/8" (0.125), spacing = 2.22, thickness = 1/8", depth = 3 5/8" (3.625)
using the square configuration:
perf % = 78.5*(0.125/2.22)^2 = 0.25%
t (effective hole length) = 0.125 + 0.8*0.125 = 0.225
f = 200*(0.25/(0.225*3.625))^0.5 = 110 Hz
Let me know if you get my spreadsheet to work.
Here's a sample calculation (first line in the table).
hole size = 1/8" (0.125), spacing = 2.22, thickness = 1/8", depth = 3 5/8" (3.625)
using the square configuration:
perf % = 78.5*(0.125/2.22)^2 = 0.25%
t (effective hole length) = 0.125 + 0.8*0.125 = 0.225
f = 200*(0.25/(0.225*3.625))^0.5 = 110 Hz