Excel file manager

From Tygron Support wiki
Revision as of 13:20, 14 June 2019 by Godelief@tygron.nl (talk | contribs) (Created page with "{{being updated}} {{learned|what the Excel file manager is|how to use the Excel file manager}} ==What is the Excel file manager== Excel files are used in a number o...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
Please note: This page is currently being updated.

Template:Learned

What is the Excel file manager

Excel files are used in a number of places in the Tygron Platform, for example Indicators and Panels. To allow for the reuse of Excel files, the Tygron Platform presents an Excel File Manager, in which Excel files can be uploaded, replaced, and selected for use.

Uploading and Downloading

The "Select Excelsheet" option.

When, in the Editor, an item is selected which uses an Excel file, it will present you with the option to "Select Excelsheet". This will open the Excel File Manager.

How to select an Excel File:
  1. Open the Excel File Manager
  2. Select the file you wish to use
  3. Select "Apply"
How to download an Excel File:
  1. Open the Excel File Manager
  2. Select the file you wish to use
  3. Select the "Download" option
  4. Select the location to save the file and select "Save"
  5. Select "Cancel" in the Excel File Manager to close it


How to import a new Excel File:
  1. Open the Excel File Manager
  2. Select "Import new Excelsheet"
  3. Browse to the Excel file you wish to import and select "Open"
  4. Select the file you wish to use (which may or may not be the imported Excel) in the Excel File Manager
  5. Select "Apply"
How to replace an Excel File:
  1. Open the Excel File Manager
  2. Select the file you wish to replace
  3. Select the "Update" option
  4. Browse to the Excel file you wish to import and select "Open"
  5. Select the file you wish to use (which may or may not be the replaced Excel) in the Excel File Manager
  6. Select "Apply"

Debugging

Sometimes, when you look at the output of an Excel-based calculation in the Tygron Platform, you may not directly recognize how a certain result was achieved. As more complex Excel files are uploaded, this may occur more often. At these times, it may be desirable to see how the Excel file has been filled by the Tygron Platform, and how these values are treated by the Excel file's calculation. This can be done by downloading the Excel file using the "Debug Excelsheet" option. This will allow you to download the Excel file with the current values filled in.

After download, you can open the Excel File in Microsoft Office Excel. You will see that all input cells are filled with values from the Tygron Platform. Inspecting the output cells and tracing back through your calculation will allow you to determine how certain values came to be, based on the provided input.

It is important to note that the downloaded file may have lost some formatting in the sheet, as well as contain some project-specific adjustments when "X" or "ID" queries were used. For this reason, we advise not to re-upload Excel files which were downloaded with current values, even when they require a change altered. Instead, download the original file using the Excel File Manager, adjust it, and re-upload that version.

How to debug an Excel File:
  1. Select the item with the relevant Excel File in the editor
  2. Select "Debug Excelsheet"
  3. Select the location to save the file and select "Save"
  4. Download the original Excel file as well
  5. Open the Excel file with the current values and step through it to find any issues
  6. Make any desired changes in the original Excel file
  7. Upload the modified original Excel file