Example: Value-added tax (VAT)

SpreadsheetConverter lets you create web pages with live formulas. One example is when VAT is added to a sale. As always, you create your formula-driven web page directly in Excel, with the skills you already have. The resulting web page may be simple, but very promising.

In this example, 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.

Before we go any further: would you like to try this on one of your own spreadsheets? With our free-demo offer, you can get any spreadsheet converted to web format for free, just to see what it would look like. Try it now!

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

Printer-friendly