{"action":"reopened","issue":{"url":"https://api.github.com/repos/OpenSourceMalaria/OSM_To_Do_List/issues/319","labels_url":"https://api.github.com/repos/OpenSourceMalaria/OSM_To_Do_List/issues/319/labels{/name}","comments_url":"https://api.github.com/repos/OpenSourceMalaria/OSM_To_Do_List/issues/319/comments","events_url":"https://api.github.com/repos/OpenSourceMalaria/OSM_To_Do_List/issues/319/events","html_url":"https://github.com/OpenSourceMalaria/OSM_To_Do_List/issues/319","id":94936419,"number":319,"title":"How do we Manage the Size of the Master Compound List?","user":{"login":"mattodd","id":4386101,"avatar_url":"https://avatars.githubusercontent.com/u/4386101?v=3","gravatar_id":"","url":"https://api.github.com/users/mattodd","html_url":"https://github.com/mattodd","followers_url":"https://api.github.com/users/mattodd/followers","following_url":"https://api.github.com/users/mattodd/following{/other_user}","gists_url":"https://api.github.com/users/mattodd/gists{/gist_id}","starred_url":"https://api.github.com/users/mattodd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mattodd/subscriptions","organizations_url":"https://api.github.com/users/mattodd/orgs","repos_url":"https://api.github.com/users/mattodd/repos","events_url":"https://api.github.com/users/mattodd/events{/privacy}","received_events_url":"https://api.github.com/users/mattodd/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/OpenSourceMalaria/OSM_To_Do_List/labels/Administration","name":"Administration","color":"009800"},{"url":"https://api.github.com/repos/OpenSourceMalaria/OSM_To_Do_List/labels/question","name":"question","color":"cc317c"}],"state":"open","locked":false,"assignee":{"login":"mattodd","id":4386101,"avatar_url":"https://avatars.githubusercontent.com/u/4386101?v=3","gravatar_id":"","url":"https://api.github.com/users/mattodd","html_url":"https://github.com/mattodd","followers_url":"https://api.github.com/users/mattodd/followers","following_url":"https://api.github.com/users/mattodd/following{/other_user}","gists_url":"https://api.github.com/users/mattodd/gists{/gist_id}","starred_url":"https://api.github.com/users/mattodd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mattodd/subscriptions","organizations_url":"https://api.github.com/users/mattodd/orgs","repos_url":"https://api.github.com/users/mattodd/repos","events_url":"https://api.github.com/users/mattodd/events{/privacy}","received_events_url":"https://api.github.com/users/mattodd/received_events","type":"User","site_admin":false},"milestone":null,"comments":40,"created_at":"2015-07-14T12:35:28Z","updated_at":"2015-11-18T21:10:39Z","closed_at":null,"body":"Advice needed @lpatiny @drc007 @cdsouthan (and anyone else obviously...) I want to make sure we're doing this sheet correctly, meaning a few decisions ought to be made up front. There are a number of people interested in volunteering for OSM for data entry right now.\r\n\r\n(Context: We're doing retrospective data entry, moving away from the [Experimental Procedures](http://malaria.ourexperiment.org/osm_procedures) lab notebook as a repository of all OSM data and towards a [Google Sheet](https://docs.google.com/spreadsheets/d/1Rvy6OiM291d1GN_cyT6eSw_C3lSuJ1jaR7AJa8hgGsc/edit#gid=510297618) that can be more easily manipulated.)\r\n\r\nBrowsing SAR is the first use of this sheet, so obviously the spreadsheet should contain compound strings and codes, as well as potencies. But the sheet will need more.\r\n\r\n**Question 1**: can we extend the spreadsheet limitlessly? What we need to do is include columns for all kinds of biological data, meaning columns for values, units and qualifiers. Won't performance/usability suffer if the sheet has e.g. 100 columns? Or should we treat this as a primary data source, like an SDF, and assume that we will always extract data from it for focussed analysis?\r\n\r\n**Question 2**: I'd like to include URLs for original sources of data (i.e. lab notebook pages). Do we include URLs as text in distinct cells, or can we hyperlink from text/numerical values? e.g. if compound X has potency value Y, and the raw data for that value is on web page Z do we have a separate column containing the value Z or do I hyperlink \"Y\" with Z.\r\n\r\n**Question 3**: I want to do the same with synthetic chemistry - a way of collecting all the attempts at the synthesis of a given molecule. This was the ultimate purpose of the original \"Experimental Procedures\" ELN and is very useful. A sheet like this would involve a lot of columns. Again, do we hyperlink on values, or do we paste text-based URLs into cells?\r\n\r\n**Question 4**: Would it be better (from a usability perspective) to have a separate sheet for Synthetic Chemistry, or does it not matter? I'd like to make sure we handle synthesis in a way that allows us to note batch numbers for preparations (which we're not doing well right now). A way of doing that is to have each preparation use the chemist's own code as the text value inserted into a given column, and then hyperlink back to the relevant page containing the prep. But doing this relies on hyperlinks in sheets being OK...\r\n\r\nFor an idea of the data that needs to be entered for a compound take a look at the page for one of the best compounds from Series 1, [OSM-S-5](http://malaria.ourexperiment.org/osm_procedures/7054/Preparation_of_OSMS5.html). How best to translate what's on that page to spreadsheet format so that the data are useful but also link back to original data sources to maintain the ability to navigate the project?\r\n\r\nAlso pinging for info @PaulBarrett79 , involved in [ChemReg](https://chembiohub.ox.ac.uk/blog/2015/03/10/introducing-chemreg-compound-registration-system.html)\r\n"}}