Bob, I have not worked with that spreadsheet. However, Chuck, Udi, Raghu and all the others who understand this material are in substantial agreement. It's not new stuff at all; the principles were worked out before WWI. It's only new to homebuilt-gyro people.
Forget the spreadsheet for now. Your time is better spent working to UNDERSTAND the underlying principles and doing a few problems with a simple pocket calculator. Don't work blindly with a complex Excel program. H-stab lift is so simple that a program isn't necessary unless you need to run a large number of scenarios.
There are two stabilities to consider.
1. STATIC stability is the type that prevents the deadly power pushover (PPO) in HTL machines. The power of a H-stab to provide static stability does NOT increase as the square of the length of the moment arm. Rather, this power is a linear function of arm length, a linear function of H-stab area and a linear function of angle of attack. Twice the arm, twice the H-stab moment. Twice the area, twice the H-stab moment. Twice the angle of attack, twice the H-stab moment.
The only square function involved is that of airspeed. Twice the airspeed, FOUR times the H-stab moment if all the other factors stay the same.
To use the attached chart (based on actual H-stab lift tests), pick an airspeed, an angle of attack and a H-stab area. Read airspeed in mph down the left column and AOA across the top row. Multiply the resulting lift/sq. ft. by HS area and then by moment arm length to get your HS's moment in foot-pounds. For 600 lb. thrust on a 12" HTL, you'll need at least 600 foot-lb. of HS moment.
2. Dynamic stability (also know as damping) is the power of the H-stab to prevent or stop oscillations. This power IS a square function of arm length. It's a linear function of H-stab area. It's a square function of airspeed. A H-stab that provides positive static stability is almost certain to provide good damping as well. In practice, you size the HS for static stability at a reasonable AOA and dynamic stability is just about guaranteed.
Since the ability to provide static stability is a linear function of arm length, while dynamic stabilizing power is a square function of arm length, you will typically get more vigorous damping in a craft that gets its stab power from lots of arm length than one that gets it power from a huge stab area. That's probably why some people especially enjoy the feel of tractor gyros.