Google Sheets Integration explained
A previous post outlined how Phast Web Services (PWS) could be integrated with the desktop version of Excel using macros and VBA. Integrating with Excel Online is not currently possible (July 2020) as macros and VBA are not supported in this version.
The example below shows this. This uses a combination of Phast Web Services models (Discharge, Dispersion, Results Postprocessing) to calculate flammable cloud parameters with just a definition of material, pressure, temperature and hole size (other inputs such as weather etc. can be varied but are defaulted in this simple example).
Author: Kenny Shaba