The application also relies on a Google Sheets API, that draws data from a sheet in order to populate available items and prices. In this example, the desired final price including VAT is entered into column C, and the price excluding VAT is automatically calculated. This example sheet includes the option of applying two different VAT rates.
Let us know if you have more to add! We would be happy to include your changes.