Differences

This shows you the differences between two versions of the page.

--- updates:fuel-uploading-country-tax-rates-file-is-now-possible [2021/02/23 18:12]
bartek created
+++ updates:fuel-uploading-country-tax-rates-file-is-now-possible [2021/02/23 18:33]
bartek
@@ Line 3: / Line 3: @@
-When uploading fuel prices files to Leon, not all of them contain of a 'Total' price (including taxes). To make possible viewing 'Total' fuel prices in both: Fuel Prices & OPS > tab FUEL section, we have made possible uploading a file with **Country tax rates**, which will update 'Total' fuel price.
+When uploading fuel prices files to Leon, not all of them contain of both: 'Base' (excluding taxes) and 'Total' price (including taxes). To make possible viewing both fuel prices in panels: Fuel Prices & OPS > tab FUEL, we have made possible uploading a file with **Country tax rates**.
-A file itself needs to be created as per a format below - only 2 columns are needed: **Country** and **Total Taxes**. A column 'Country' can have either country name (Argentina), country code (ARG) or iso code (AR). 'Total Taxes' values will multiply 'Base' price and will show as 'Total' price.
+A file itself needs to be created as per a format below - only 2 columns are needed: **Country** and **Total Taxes**.
-What's important is that the sheet's name must be 'Fuel Taxes', otherwise it will not work.
+A column 'Country' can have inserted either country name (Argentina), country code (ARG) or iso code (AR).
+A value from 'Total Taxes' column will update fuel prices for airports of a country from this file:
+  * **Total price** = 'Base price' multiplied by 'Total Taxes' value.
+  * **Base price** = 'Total price' divided by 'Total Taxes' value.
+What's important is that inside the file, the sheet's name must be 'Fuel Taxes', otherwise it will not work.
 [{{ :leon:fuel-prices:fuel prices after tax uploaded.png?200|Country tax rates from uploaded file}}]
 {{:leon:fuel-prices:fuel taxes file.png|}}
@@ Line 17: / Line 24: @@
 Uploaded fuel taxes will show on the main 'Fuel Prices' page in a column **Country tax rate** (see screenshot on the right).
-If the fuel file uploaded to Leon already contained of 'Total' fuel prices, Leon will not update them.
-In a panel OPS, tab FUEL, if you switch between 'BASE' & 'TOTAL', Leon will show prices accordingly, as per an example below: tax rate for Germany has been defined to '3' and Leon multiplied 'Base' price by '3'.
+In a panel OPS, tab FUEL, if you switch between 'BASE' & 'TOTAL', Leon will show prices accordingly, as per an example below: tax rate for Germany has been defined to '3' and Leon shows 'Total' price as 'Base' price multiplied by '3'.
 {{:leon:fuel-prices:base total fuel price.png?nolink|}}
+<box>**If the fuel file uploaded to Leon already contained both prices: 'Base' & 'Total', Leon will not update them.**</box>

Leonsoftware Wiki

User Tools

Site Tools

Differences

Page Tools