Feedback on Excel/Google Sheets curation tool

[lwaldron]

I've drafted a spreadsheet-based curation tool (with great help from MS Copilot) for assisting curation based on the current data dictionary. I'd love to get some feedback from @SvetlanaUP's curation team on its usability compared to ODM, and on any improvements that could be made. Excel version is attached; Google Sheets version is here.

There's a lot of (hidden) complexity in this spreadsheet (hidden in hidden sheets) to have a curator-friendly "Curator_Entry" sheet with labels for ontology terms, and an export-ready "Export" sheet calculated from the curation sheet. The "Audit" sheet tells you how close you are to finished. If the export was handled by an external program directly from the spreadsheet, the spreadsheet itself could be much simpler while remaining curator-friendly. FYI @seandavi @shbrief

[shbrief]

@lwaldron Implement a dynamic enum (i.e., a large list of descendants as allowed values) handling

[SvetlanaUP]

Update: Tosin, my Outrechy mentee, and I have been testing this solution for curation on 11 datasets from published studies focused on oral conditions: gingivitis, periodontitis, mucositis, and peri-implantitis. These studies have been curated also in BugSigDB. We will share our experience asap.

[lwaldron]

Cool!