Excel file manager - Revision history

Maxim@tygron.com at 11:52, 5 October 2022

2022-10-05T11:52:05Z

← Older revision		Revision as of 11:52, 5 October 2022
Line 1:		Line 1:
	~~{{learned\|what the Excel file manager is\|how to use the Excel file manager}}~~

	~~==What is the Excel file manager==~~
	[[Excel\|Excel files]] are used in a number of places in the {{software}}, for example [[Indicator]]s and [[Panel]]s. To allow for the reuse of Excel files, the {{software}} presents an Excel File Manager, in which Excel files can be uploaded, replaced, and selected for use.		[[Excel\|Excel files]] are used in a number of places in the {{software}}, for example [[Indicator]]s and [[Panel]]s. To allow for the reuse of Excel files, the {{software}} presents an Excel File Manager, in which Excel files can be uploaded, replaced, and selected for use.

Godelief@tygron.nl at 13:42, 14 June 2019

2019-06-14T13:42:58Z

← Older revision		Revision as of 13:42, 14 June 2019
Line 1:		Line 1:
	~~{{being updated}}~~
	{{learned\|what the Excel file manager is\|how to use the Excel file manager}}		{{learned\|what the Excel file manager is\|how to use the Excel file manager}}

Godelief@tygron.nl: /* What is the Excel file manager */

2019-06-14T13:42:45Z

What is the Excel file manager

← Older revision		Revision as of 13:42, 14 June 2019
Line 11:		Line 11:
	{{Editor steps\|title=select an Excel File\|Open the Excel File Manager\|Select the file you wish to use\|Select "Apply"}}		{{Editor steps\|title=select an Excel File\|Open the Excel File Manager\|Select the file you wish to use\|Select "Apply"}}
	{{Editor steps\|title=download an Excel File\|Open the Excel File Manager\|Select the file you wish to use\|Select the "Download" option\|Select the location to save the file and select "Save"\|Select "Cancel" in the Excel File Manager to close it}}<br clear=all>		{{Editor steps\|title=download an Excel File\|Open the Excel File Manager\|Select the file you wish to use\|Select the "Download" option\|Select the location to save the file and select "Save"\|Select "Cancel" in the Excel File Manager to close it}}<br clear=all>
			[[File:Excel_file_manager.JPG\|thumb\|right\|400px\|The Excel file manager.]]
	{{Editor steps\|title=import a new Excel File\|Open the Excel File Manager\|Select "Import new Excelsheet"\|Browse to the Excel file you wish to import and select "Open"\|Select the file you wish to use (which may or may not be the imported Excel) in the Excel File Manager\|Select "Apply"}}		{{Editor steps\|title=import a new Excel File\|Open the Excel File Manager\|Select "Import new Excelsheet"\|Browse to the Excel file you wish to import and select "Open"\|Select the file you wish to use (which may or may not be the imported Excel) in the Excel File Manager\|Select "Apply"}}
	{{Editor steps\|title=replace an Excel File\|Open the Excel File Manager\|Select the file you wish to replace\|Select the "Update" option\|Browse to the Excel file you wish to import and select "Open"\|Select the file you wish to use (which may or may not be the replaced Excel) in the Excel File Manager\|Select "Apply"}}		{{Editor steps\|title=replace an Excel File\|Open the Excel File Manager\|Select the file you wish to replace\|Select the "Update" option\|Browse to the Excel file you wish to import and select "Open"\|Select the file you wish to use (which may or may not be the replaced Excel) in the Excel File Manager\|Select "Apply"}}

Godelief@tygron.nl: /* What is the Excel file manager */

2019-06-14T13:23:26Z

What is the Excel file manager

← Older revision		Revision as of 13:23, 14 June 2019
Line 5:		Line 5:
	[[Excel\|Excel files]] are used in a number of places in the {{software}}, for example [[Indicator]]s and [[Panel]]s. To allow for the reuse of Excel files, the {{software}} presents an Excel File Manager, in which Excel files can be uploaded, replaced, and selected for use.		[[Excel\|Excel files]] are used in a number of places in the {{software}}, for example [[Indicator]]s and [[Panel]]s. To allow for the reuse of Excel files, the {{software}} presents an Excel File Manager, in which Excel files can be uploaded, replaced, and selected for use.

	===~~Uploading and Downloading~~===		===Use the Excel file manager===
	[[File:ExcelSelectExcelsheet.jpg\|framed\|right\|The "Select Excelsheet" option.]]		[[File:ExcelSelectExcelsheet.jpg\|framed\|right\|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.		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.

Godelief@tygron.nl: /* Debugging */

2019-06-14T13:21:33Z

Debugging

← Older revision		Revision as of 13:21, 14 June 2019
Line 13:		Line 13:
	{{Editor steps\|title=import a new Excel File\|Open the Excel File Manager\|Select "Import new Excelsheet"\|Browse to the Excel file you wish to import and select "Open"\|Select the file you wish to use (which may or may not be the imported Excel) in the Excel File Manager\|Select "Apply"}}		{{Editor steps\|title=import a new Excel File\|Open the Excel File Manager\|Select "Import new Excelsheet"\|Browse to the Excel file you wish to import and select "Open"\|Select the file you wish to use (which may or may not be the imported Excel) in the Excel File Manager\|Select "Apply"}}
	{{Editor steps\|title=replace an Excel File\|Open the Excel File Manager\|Select the file you wish to replace\|Select the "Update" option\|Browse to the Excel file you wish to import and select "Open"\|Select the file you wish to use (which may or may not be the replaced Excel) in the Excel File Manager\|Select "Apply"}}		{{Editor steps\|title=replace an Excel File\|Open the Excel File Manager\|Select the file you wish to replace\|Select the "Update" option\|Browse to the Excel file you wish to import and select "Open"\|Select the file you wish to use (which may or may not be the replaced Excel) in the Excel File Manager\|Select "Apply"}}

	~~===Debugging===~~
	Sometimes, when you look at the output of an Excel-based calculation in the {{software}}, 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 {{software}}, 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 {{software}}. 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.

	{{Editor steps\|title=debug an Excel File\|Select the item with the relevant Excel File in the editor\|Select "Debug Excelsheet"\|Select the location to save the file and select "Save"\|Download the original Excel file as well\|Open the Excel file with the current values and step through it to find any issues\|Make any desired changes in the original Excel file\|Upload the modified original Excel file}}

Godelief@tygron.nl: 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..."

2019-06-14T13:20:49Z

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..."

New page

{{being updated}}
{{learned|what the Excel file manager is|how to use the Excel file manager}}

==What is the Excel file manager==
[[Excel|Excel files]] are used in a number of places in the {{software}}, for example [[Indicator]]s and [[Panel]]s. To allow for the reuse of Excel files, the {{software}} presents an Excel File Manager, in which Excel files can be uploaded, replaced, and selected for use.

===Uploading and Downloading===
[[File:ExcelSelectExcelsheet.jpg|framed|right|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.

{{Editor steps|title=select an Excel File|Open the Excel File Manager|Select the file you wish to use|Select "Apply"}}
{{Editor steps|title=download an Excel File|Open the Excel File Manager|Select the file you wish to use|Select the "Download" option|Select the location to save the file and select "Save"|Select "Cancel" in the Excel File Manager to close it}}<br clear=all>
{{Editor steps|title=import a new Excel File|Open the Excel File Manager|Select "Import new Excelsheet"|Browse to the Excel file you wish to import and select "Open"|Select the file you wish to use (which may or may not be the imported Excel) in the Excel File Manager|Select "Apply"}}
{{Editor steps|title=replace an Excel File|Open the Excel File Manager|Select the file you wish to replace|Select the "Update" option|Browse to the Excel file you wish to import and select "Open"|Select the file you wish to use (which may or may not be the replaced Excel) in the Excel File Manager|Select "Apply"}}

===Debugging===
Sometimes, when you look at the output of an Excel-based calculation in the {{software}}, 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 {{software}}, 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 {{software}}. 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.

{{Editor steps|title=debug an Excel File|Select the item with the relevant Excel File in the editor|Select "Debug Excelsheet"|Select the location to save the file and select "Save"|Download the original Excel file as well|Open the Excel file with the current values and step through it to find any issues|Make any desired changes in the original Excel file|Upload the modified original Excel file}}