What are you missing?
Context
Users regularly need to cross-reference data between:
1.) The sample grid
2.) The measurement grid for both proteomics and genomic measurements
3.) The raw data grid,
4.) The exported sample sheet
5.) The exported measurement sheet for both genomics and proteomics measurements
6.) The exported raw data download URLs
Two concrete use cases drive this issue:
Use Case 1 — Copy QBiC Barcodes for internal storage (e.g. for measurement download):
User registers a spreadsheet and copies the newly assigned barcodes into from the downloaded excel sheet into the original sheet for internal reference.
Since there is no inherent order, there is already a misalignment between the original sheet and exported barcodes.
Use Case 2 — Compare information between linked entities:
User wants to compare sample information against measurement IDs and raw data download links.
They download the sample sheet, the measurement sheet, and raw data URLs, then attempt to combine them into a single sheet.
The misaligned row ordering leads to constant mismatches between the individual entries.
Expected Behaviour
Currently, there is no consistent sorting across these elements. This causes rows to be misaligned when users copy data between sheets, leading to incorrect cross-referencing by the user
Expected Behaviour
All grids and downloaded sheets use a consistent default sort order.
Why do you need a solution?
Users misalign the individual information aspects into their internal excel sheets due to not having a consistent sorting.
Additionally, direct comparison between sample and measurements is complicated within an experiment due this inconsistent display
Ideas
1.) This ordering could be based lexicographically on the ascending QBiC barcode assignment within the sample and measurement ids per entity. NOTE This only works if the barcodes are assigned lexicographically one at a time.
2.) Alternatively store the ordering of the uploaded excel sheets within the system and restore the original order upon download. NOTE The order has to be preserved even when entities are deleted and the order of the latest excel upload would take precedence
3.) Alternatively enable Users to sort the entities within the system via the UI and copy that ordering into the exported sheets.
Code of Conduct
What are you missing?
Context
Users regularly need to cross-reference data between:
1.) The sample grid
2.) The measurement grid for both proteomics and genomic measurements
3.) The raw data grid,
4.) The exported sample sheet
5.) The exported measurement sheet for both genomics and proteomics measurements
6.) The exported raw data download URLs
Two concrete use cases drive this issue:
Use Case 1 — Copy QBiC Barcodes for internal storage (e.g. for measurement download):
User registers a spreadsheet and copies the newly assigned barcodes into from the downloaded excel sheet into the original sheet for internal reference.
Since there is no inherent order, there is already a misalignment between the original sheet and exported barcodes.
Use Case 2 — Compare information between linked entities:
User wants to compare sample information against measurement IDs and raw data download links.
They download the sample sheet, the measurement sheet, and raw data URLs, then attempt to combine them into a single sheet.
The misaligned row ordering leads to constant mismatches between the individual entries.
Expected Behaviour
Currently, there is no consistent sorting across these elements. This causes rows to be misaligned when users copy data between sheets, leading to incorrect cross-referencing by the user
Expected Behaviour
All grids and downloaded sheets use a consistent default sort order.
Why do you need a solution?
Users misalign the individual information aspects into their internal excel sheets due to not having a consistent sorting.
Additionally, direct comparison between sample and measurements is complicated within an experiment due this inconsistent display
Ideas
1.) This ordering could be based lexicographically on the ascending QBiC barcode assignment within the sample and measurement ids per entity. NOTE This only works if the barcodes are assigned lexicographically one at a time.
2.) Alternatively store the ordering of the uploaded excel sheets within the system and restore the original order upon download. NOTE The order has to be preserved even when entities are deleted and the order of the latest excel upload would take precedence
3.) Alternatively enable Users to sort the entities within the system via the UI and copy that ordering into the exported sheets.
Code of Conduct