Raoul, this has already been accomplished. A vendor called Selltech has a software program for the draught industry. Unfortunately, this is not useful since liquid temperature is so elusive. When 38F can be conquered and you have an ale or lager at 2.5 volumes of CO2 and you live at sea level, push this beer with 14 PSIG. God forbid the temperature changes. If it does, raise pressure one pound for every two degree change. Conversely, lower one pound for every two degree change warmer. If you have a 2.8 vol product - two pounds higher than a 2.5 beer.
If you really want to put system balance including restriction in a spreadsheet, call customer service at 866 327-4159 and ask for my number. Then we can discuss another twist - the use of blend gas and restriction. Cheers.
Scott Zuhse, Instructor
Micro Matic Dispense Institute