User Tools

Site Tools


leon:fuel-prices

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision Both sides next revision
leon:fuel-prices [2021/02/15 09:35]
rafal [Fuel Prices]
leon:fuel-prices [2021/04/01 05:49]
bartek
Line 42: Line 42:
  
 <box>**If required, we can add a new fuel card or a new fuel uploader to the list of the existing ones - please contact [[support@leonsoftware.com]] in this matter.**</box>  <box>**If required, we can add a new fuel card or a new fuel uploader to the list of the existing ones - please contact [[support@leonsoftware.com]] in this matter.**</box> 
 +
 +----
 +
 +===== COUNTRY TAX RATES FILE =====
 +
 +
 +
 +When uploading fuel prices files to Leon, not all of them consist of both: 'Base' (excluding taxes) and 'Total' price (including taxes). To make it possible viewing both fuel prices in panels: Fuel Prices & OPS > tab FUEL, we have made it possible uploading a file with **Country tax rates**.
 +
 +A file itself needs to be created as per the format below - only 2 columns are needed: **Country** and **Total Taxes**. 
 +
 +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|}}
 +
 +Once the file is ready, go to **OPS > Fuel Prices** panel and use an uploader **Upload countries tax rates**.
 +
 +{{:leon:fuel-prices:fuel taxes upload.png|}}
 +
 +Uploaded fuel taxes will show on the main 'Fuel Prices' page in a column **Country tax rate** (see screenshot on the right).
 +
 +
 +In a panel OPS, tab FUEL, if you switch between 'BASE' & 'TOTAL', Leon will show prices accordingly, as per an example below: the 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>
leon/fuel-prices.txt · Last modified: 2024/01/19 14:33 by rafal