Advanced Table Conversion
In earlier versions, foxer currency calculator used to treat tables as number containers only, any other information was considered plain text. But then we realised that regular tables could have a special first row and first column with a valuable meaning, and in the context of exchange rate calculations, currency ISO codes and dates were, of course, something useful to look for.
As this new feature was expected to be a big step compared with previous table processing, and effectively it was, we named this technology Advanced Table Conversion or ATC for short.
So, what is ATC?
ATC is the special processing that helps identify dates, currencies and even bank codes when converting tables. Having this information preset on a table and then the ability to recognize it, opens the door to a whole new range of features. Firstly, because it makes dealing with multiple currency conversions possible – which can’t be achieved in a one-to-one scenario. And secondly, because with date specification, now the converter can look for and load different exchange rates in every single line before converting subsequent values.
ATC is made visible on the conversion pop up as a toggle button which behaves oppositely:
- With ATC-In, the values on the table are considered as being expressed as incoming currencies, and will be converted to the main outgoing one.
- With ATC-Out, the values on the table will be converted to the specified outgoing currencies, while the values on the table are understood to be expressed in the main incoming one.
ATC currency replacement is shown as strikethrough on the left for clarity in the popup window. Also note you can still toggle the original incoming & outgoing converter currencies, therefore giving you a lot of flexibility and control over the conversion adjustments, which is ATC’s final goal.
The last element you can play with in ATC is the Plugin specification. This is the way to tell foxer currency calculator the provider to use when converting a table. To do so, just set the subscription code on the very first cell of the table, for example: ECB for European Central Bank. If you don’t specify it, it will use the one currently selected in the converter.
About date format
ATC technology tries to determine the date convention used in a table by checking all valid options, and usually gets it right as long as the format is consistent. The only case where failing is possible is in dual interpretations, where interchangeable month and day give a valid date. Examples for this are 01-06-2019 and 10-09-2018. In this case, user intervention may be needed by clicking on the date format that appears at the top right of the pop up, until the desired format is shown.
Accepted formats are ddmmyy / mmddyy / yyyymmdd with any of the following separators: “-/.“. For the yyyymmdd format, year should be 4 digits.
For foxer, the only valid table delimiters for rows and columns, are End of line (cr+lf) and Tabulator (#8) characters, and standard html tokens for table row and table cell.
Things to keep in mind
- Published currencies are not the same for every subscription, so maybe one specific currency is not available in a determined Bank.
- If you don’t specify a date column, current exchange rates in memory are used.
- If you specify a subscription plugin code, but also no date, latest exchange rates of that subscription are used.
- You can always see how the converter solved all the calculations by clicking on Conversion Report button.
foxer Currency Calculator
A conversion pop up with ATC enabled
You can try on this sample table
Date elements should be on first column only
Currency codes can be placed on first row or first column of a table
First cell of a table ( first row and first column ) is a special position to specify the subscription code
Currency ISO codes placed both on first row and first column will generate a cross table