I have written spreadsheets for the weight and balance of a SA-227 used in the cargo configuration. I had it configured so that it with a defined pressure altitude, temperature, and fuel load it would calculate the max payload, required runway (with and without water injection) and the V speeds for takeoff and landing. It also was configured for maximum weight limits per compartment and bending moment restrictions and all the pertinent W & B information required for flight. The other thing I did was have it give me a percentage of CG range, I used this for presetting the trim. (There are no preset procedures on this aircraft, but my method worked pretty well).
All this runs on a Palm Pilot III
There was a fair amount of challenges involved with it, though it is not impossible. I am no math whiz but if I can figure it out pretty much anyone can.
I did use a formula that set the CG limits in situations where the CG limit varies with gross weight. I took this information off the graphed CG envelope and plugged it into the spreadsheet. So I guess I did integrate the graphed information into the program. I would have to look back through the 'sheet to see how I did it. I just remember it was not that hard.
Hammer away at it, spreadsheets can do a fair amount of stuff. Having something personalized for your need is probably the best way to go. The only problem that I have with it is dealing with time inputs. I have yet to get a good handle on that.
Overall, of all the spreadsheets Weight & Balance is probably the easiest.