Switch To
Product Links
Languages
Themes
Feedback
Sign Up Now
VBA Editor
Coriander Green
Metallic Grey
Coriander Green
Metallic Grey
Loading...
Updating...
Please wait to edit...
Ready for editing
X
Local File
URL
(Supported Formats: xls, sxc, ods, csv and tsv)
Name of the Document:
CSV files have data in a structured format similar to a database table. Choose the desired import option based on the recommendations provided below:
Import as...
Tabular Data
Recommended for...
- Creating PIVOT Tables and Charts
- Faster loading and performance
- Auto Filters and Freeze Columns
Normal Spreadsheet
Useful for...
- Formatting options
- Formulas & Calculations, and
- Other regular spreadsheet operations
NOTE:
There will be no option inside the document to toggle between these two views.
Spreadsheet Name:
Template Name:
Spreadsheet Name:
Template Name:
Add New Name
Save As New Document...
Save As New Template...
Mark As New Version...
New Template
From Templates List
Show Text Only
Show Icons Only
Show Icons & Text
quick reference for new 21.5% VAT rate
by
ahwiki
185 views
Print
Export
Copy to My Account
Embed in Website/Blog
Tags:
Macro recorded successfully
View Macro
Macros List
|
Unsupported actions
|
Macro Recording in progress
Stop Recording
Cancel
|
Unsupported actions
|
Arial
Arial Black
Book Antiqua
Calibri
Comic Sans MS
Courier New
Garamond
Georgia
Lucida Console
MingLiU
MS Gothic
MS PGothic
MS Mincho
MS P Mincho
MS Sans Serif
SimHei
Tahoma
Times New Roman
Trebuchet MS
Verdana
8
9
10
11
12
14
16
18
20
24
26
$
Macros
Auto Filter
Freeze Columns
This worksheet is a tabular data. Regular spreadsheet operations like cut/copy/paste, undo/redo, range selection, formulas and formatting are restricted in this mode.
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
Edit
|
Publish
|
Revert Publish
|
URL
|
Clone
Quick Reference for new VAT Calculations - as usual, type in the blue, leave the formulas alone..
old 21% Calculations
Gross to Net
Gross of
121
divided by
1.210
equals Net of
100
and VAT of
21
Net to Gross
Net of
100
multiplied by
1.210
equals Gross of
121
and VAT of
21
Net to VAT
Net of
100
multiplied by
0.210
equals VAT of
21
and Gross of
121
Gross to VAT
Gross of
54.45
divided by
5.7619
equals VAT of
9.45
and Net of
45
new 21.5 Calculations
Gross to Net
Gross of
121.5
divided by
1.215
equals Net of
100
and VAT of
21.5
Net to Gross
Net of
100
multiplied by
1.215
equals Gross of
121.5
and VAT of
21.5
Net to VAT
Net of
100
multiplied by
0.215
equals VAT of
21.5
and Gross of
121.5
Gross to VAT
Gross of
54.45
divided by
5.6512
equals VAT of
9.64
and Net of
44.81
www.sortmybooks.com
Sheet1
Sheet2
Sheet3
