{"action":"created","issue":{"url":"https://api.github.com/repos/OpenSourceMalaria/OSM_To_Do_List/issues/345","labels_url":"https://api.github.com/repos/OpenSourceMalaria/OSM_To_Do_List/issues/345/labels{/name}","comments_url":"https://api.github.com/repos/OpenSourceMalaria/OSM_To_Do_List/issues/345/comments","events_url":"https://api.github.com/repos/OpenSourceMalaria/OSM_To_Do_List/issues/345/events","html_url":"https://github.com/OpenSourceMalaria/OSM_To_Do_List/issues/345","id":105565007,"number":345,"title":"Adding GSK PRR data and codes to the main sheet","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/Paper%201","name":"Paper 1","color":"F7FE2E"}],"state":"open","locked":false,"assignee":{"login":"minkyungchong","id":13162407,"avatar_url":"https://avatars.githubusercontent.com/u/13162407?v=3","gravatar_id":"","url":"https://api.github.com/users/minkyungchong","html_url":"https://github.com/minkyungchong","followers_url":"https://api.github.com/users/minkyungchong/followers","following_url":"https://api.github.com/users/minkyungchong/following{/other_user}","gists_url":"https://api.github.com/users/minkyungchong/gists{/gist_id}","starred_url":"https://api.github.com/users/minkyungchong/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/minkyungchong/subscriptions","organizations_url":"https://api.github.com/users/minkyungchong/orgs","repos_url":"https://api.github.com/users/minkyungchong/repos","events_url":"https://api.github.com/users/minkyungchong/events{/privacy}","received_events_url":"https://api.github.com/users/minkyungchong/received_events","type":"User","site_admin":false},"milestone":null,"comments":3,"created_at":"2015-09-09T10:03:54Z","updated_at":"2015-09-12T22:07:03Z","closed_at":null,"body":"Hey @minkyungchong - do you have time for a short piece of data entry?\r\n\r\nWe need the data on [this page](http://malaria.ourexperiment.org/biological_data/13274) added to the [Master Sheet](https://docs.google.com/spreadsheets/d/1Rvy6OiM291d1GN_cyT6eSw_C3lSuJ1jaR7AJa8hgGsc/edit#gid=510297618). Specifically:\r\n\r\n1) Can you make sure the 6 relevant compounds are actually in the sheet, along with the OSM and MMV codes, and their strings?\r\n2) Can you add in the rate of killing (i.e. \"slow\", \"moderate\" etc) into the new column I created, column N\r\n3) GSK re-measured the potencies of these compounds before doing the assay. These data need to go into column I - I think that you will just need to separate the new numbers from the old numbers with a comma and a space, but @lpatiny or @drc007 may think differently...\r\n\r\nThese compounds are all Series 1, so please put that into column F if needed. We're actually going to need a push on Series 1 in the short term, but this is a good place to start since we have just acquired these data.\r\n\r\nThank you!\r\n"},"comment":{"url":"https://api.github.com/repos/OpenSourceMalaria/OSM_To_Do_List/issues/comments/139823234","html_url":"https://github.com/OpenSourceMalaria/OSM_To_Do_List/issues/345#issuecomment-139823234","issue_url":"https://api.github.com/repos/OpenSourceMalaria/OSM_To_Do_List/issues/345","id":139823234,"user":{"login":"minkyungchong","id":13162407,"avatar_url":"https://avatars.githubusercontent.com/u/13162407?v=3","gravatar_id":"","url":"https://api.github.com/users/minkyungchong","html_url":"https://github.com/minkyungchong","followers_url":"https://api.github.com/users/minkyungchong/followers","following_url":"https://api.github.com/users/minkyungchong/following{/other_user}","gists_url":"https://api.github.com/users/minkyungchong/gists{/gist_id}","starred_url":"https://api.github.com/users/minkyungchong/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/minkyungchong/subscriptions","organizations_url":"https://api.github.com/users/minkyungchong/orgs","repos_url":"https://api.github.com/users/minkyungchong/repos","events_url":"https://api.github.com/users/minkyungchong/events{/privacy}","received_events_url":"https://api.github.com/users/minkyungchong/received_events","type":"User","site_admin":false},"created_at":"2015-09-12T22:07:03Z","updated_at":"2015-09-12T22:07:03Z","body":"All done!\n\n\nOn 11 September 2015 at 21:11, Mat Todd <notifications@github.com> wrote:\n\n> Ah @minkyungchong <https://github.com/minkyungchong> - you've added\n> duplicate entries for these compounds. First thing to do, at the start, is\n> to check if the compounds you're entering are already in the sheet\n> (increasingly common as the dataset grows) and it looks like they are. You\n> can do a quick search by eye using the OSM codes, or a comprehensive search\n> on the sheet using e.g. SMILES.\n>\n> So... could you take the data you added in and combine it with any data\n> already in there for these compounds, please, to make sure we only have one\n> (complete) record for each?\n>\n> Actually it's looking to me like these compounds still don't have any\n> values for potency already in there, right? So:\n>\n> The “old” GSK potencies come from:\n>\n> http://malaria.ourexperiment.org/biological_data/1438\n>\n> for OSM-S-5 0.818\n>\n> and\n>\n> http://malaria.ourexperiment.org/biological_data/2722\n>\n> for\n>\n> OSM-S-35 0.036\n> OSM-S-37 0.028\n> OSM-S-39 0.007\n> OSM-S-51 0.309\n>\n> Could you quickly check these are right, and add the data into column I?\n>\n> The values for OSM-S-10 are from other sources:\n>\n> 0.201 from Ralph (http://malaria.ourexperiment.org/biological_data/1389)\n> please put into the new column N\n>\n> 0.176 from Avery (http://malaria.ourexperiment.org/biological_data/1393)\n> please put into the new column L\n>\n> 0.361 from Avery (http://malaria.ourexperiment.org/biological_data/1393)\n> but against K1 strain, so column M\n>\n> But while we’re at it, we should add in other potency data that we have\n> for these six compounds. Could you please check that the following\n> potencies are correct, and then put them in the relevant columns?\n>\n> OSM-S-5\n> 0.610 from Ralph (http://malaria.ourexperiment.org/biological_data/1389)\n> Column N\n> 0.404 from Avery (http://malaria.ourexperiment.org/biological_data/1393)\n> Column L\n>\n> OSM-S-35:\n> 0.011 Ralph (http://malaria.ourexperiment.org/biological_data/3152)\n> Column N\n> 0.026 Avery (http://malaria.ourexperiment.org/biological_data/2430)\n> Column L\n> 0.038 Avery (http://malaria.ourexperiment.org/biological_data/6734)\n> Column L\n>\n> OSM-S-37\n> 0.009 Ralph (http://malaria.ourexperiment.org/biological_data/3152)\n> Column N\n> 0.015 Avery (http://malaria.ourexperiment.org/biological_data/2430)\n> Column L\n> 0.161 Guy (http://malaria.ourexperiment.org/biological_data/11103) Column\n> O\n> 0.176 (against strain K1) Guy (\n> http://malaria.ourexperiment.org/biological_data/11103) Column P\n>\n> OSM-S-39\n> 0.005 Ralph (http://malaria.ourexperiment.org/biological_data/3152)\n> Column N\n> 0.001 Avery (http://malaria.ourexperiment.org/biological_data/2430)\n> Column L\n>\n> OSM-S-51\n> 0.442 Ralph (http://malaria.ourexperiment.org/biological_data/3152)\n> Column N\n> 0.307 Avery (http://malaria.ourexperiment.org/biological_data/2430)\n> Column L\n>\n> Thank you! This is all part of the important process of tidying up Series\n> 1. A bunch of other data are missing from the sheet (you may notice this as\n> you’re going through!). We’ll try to deal with this systematically, but\n> let's manage the above data for now.\n>\n> —\n> Reply to this email directly or view it on GitHub\n> <https://github.com/OpenSourceMalaria/OSM_To_Do_List/issues/345#issuecomment-139517720>\n> .\n>\n"}}