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
leon:fuel-prices [2021/02/15 09:35]
rafal [Fuel Prices]
leon:fuel-prices [2021/04/01 05:49] (current)
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: 2021/04/01 05:49 by bartek