A calculating web page is created in a few minutes. We start with a very simple Excel spreadsheet, and create an HTML-page that looks the same and calculates the same.

The spreadsheet

It is a simple spreadsheet that takes a user entered value, the price without VAT, and that calculates the value with VAT.

VAT - Excel



The formula is price_without_vat * (1+vat in %) equals price_with_vat. The spreadsheet can be downloaded here.

VAT - the formulas


Formatting

In the spreadsheet I selected
  • Set background color (Format Cells – Pattern) of all cells except B2
  • Format B2 and B4 with 2 decimals and 1000-separator
  • Format B3 as percentage with 1 decimal
  • Set the font size of A1 to 14 and made A1 bold

Wizard settings

These are the settings I made in the wizard
  • Select cells on first sheet only using coloring. Since the only cell that has a white background is B2, this will be the only value the user can change. B2 is called an input cell. B4 is the result, and is therefore called an output cell. The other cells are just there to help the users, and are called label cells.
  • Select spreadsheet layout in order to be able to keep column width and row heights from the spreadsheet. Select row height and cell width as ‘Same as Excel’.
  • Select to retain all formatting
  • Accept the location where to store the resulting HTML-page

The result

After pressing ‘Finished’ in the wizard, the resulting webpage will be opened. Enter the price and press TAB. The price including VAT will be updated immediately.

VAT - the web version



The webpage is self-contained. You can put it onto a web server, or send it as an email to a customer. Everyone with a browser can use it. Test it here!

Attached files

vat.xls
( vat.xls 13.50 KB )
The original Excel spreadsheet
vat.htm
( vat.htm 5.17 KB )
The resulting webpage