{"action":"created","comment":{"url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/pulls/comments/30003895","id":30003895,"diff_hunk":"@@ -0,0 +1,413 @@\n+1\n+00:00:01,180 --> 00:00:04,150\n+Dus je weet wat testen is, je weet\n+waarom je zou moeten testen\n+\n+2\n+00:00:04,150 --> 00:00:07,700\n+en wat je moet teten, maar hebben nog\n+niet besproken\n+\n+3\n+00:00:07,700 --> 00:00:11,710\n+hoe je moet testen, hoe we aan de gebruiker\n+van de spreadsheet\n+\n+4\n+00:00:11,710 --> 00:00:15,130\n+duidelijk maken dat de test faalt.\n+Er zijn\n+\n+5\n+00:00:15,130 --> 00:00:19,810\n+twee verschillende manieren waarop je kan testen\n+in een spreadsheet, zoals je hier kan zien.\n+\n+6\n+00:00:19,810 --> 00:00:23,439\n+Het eerste wat je kan doen is\n+voorwaardelijke opmaak (conditional formatting).\n+\n+7\n+00:00:23,439 --> 00:00:27,880\n+Misschien heb je het eerder gebruikt.\n+Voorwaardelijke opmaak is een functie\n+\n+8\n+00:00:27,880 --> 00:00:31,510\n+waarmee je de kleur op opmaak\n+van een cell \n+\n+9\n+00:00:31,510 --> 00:00:34,969\n+kan veranderen gebaseerd op regeld. Hier\n+kun je zien hoe het werkt.\n+\n+10\n+00:00:34,969 --> 00:00:39,030\n+Stel dat je voorwaardelijke opmaak\n+wil toevoegen aan de \"Margin\" kolom.\n+\n+11\n+00:00:39,030 --> 00:00:42,100\n+Dan selecteren we de hele kolom en dan\n+\n+12\n+00:00:42,100 --> 00:00:45,789\n+voorwaardelijke opmaak. We krijgen een\n+uitklap-scherm,\n+\n+13\n+00:00:45,789 --> 00:00:49,309\n+en in dat scherm kunnen we selecteren\n+dat we,\n+\n+14\n+00:00:49,309 --> 00:00:53,770\n+een regel willen hebben voor waarden\n+\n+15\n+00:00:53,770 --> 00:00:58,140\n+onder een bepaalde grens. En dan kunnen we\n+zeggen wat de grens moet zijn,\n+\n+16\n+00:00:58,140 --> 00:01:02,270\n+als het onder 0 is willen we dat het\n+rood wordt,\n+\n+17\n+00:01:02,270 --> 00:01:06,369\n+en dan worden alle waarden onder\n+nul rood.\n+\n+18\n+00:01:06,369 --> 00:01:11,260\n+En dat werkt voor de hele kolom\n+omdat we de hele kolom hadden geselecteerd\n+19\n+00:01:11,260 --> 00:01:14,060\n+toen we de regel toevoegden.\n+Dus als we een extr artikel\n+\n+20\n+00:01:14,060 --> 00:01:17,070\n+aan onze catalogus toevoegen\n+en een fout maken,\n+\n+21\n+00:01:17,070 --> 00:01:20,580\n+dan krijgen we direct een rode waarde in\n+\n+22\n+00:01:20,580 --> 00:01:24,299\n+de cell, dus voorwaardelijke opmaak is handig.\n+\n+23\n+00:01:24,299 --> 00:01:28,540\n+Het werkt erg goed omdat foutieve waarden\n+\n+24\n+00:01:28,540 --> 00:01:32,780\n+direct opvallen. Je eisen de focus omdat\n+ze erg anders zijn dan\n+\n+25\n+00:01:32,780 --> 00:01:37,380\n+de andere waarden. Dit is echte niet\n+de manier van testen die ik het fijnst vind.\n+\n+26\n+00:01:37,380 --> 00:01:41,770\n+Ten eerste kunnen sommige kleuren\n+verschillende betekenissen hebben.\n+\n+27\n+00:01:41,770 --> 00:01:43,659\n+Je kunt voorwaardelijke opmaak bijvoorbeeld,\n+\n+28\n+00:01:43,659 --> 00:01:46,960\n+zoals we hier doen, waar rode waarden geen \n+fout aanduiden\n+as we do here where, where the red values do","path":"Week6/6-5-NL.srt","position":133,"original_position":133,"commit_id":"9fa93f0b044cb28ddbbd5072e4fe79a1dc456c72","original_commit_id":"9fa93f0b044cb28ddbbd5072e4fe79a1dc456c72","user":{"login":"MrHug","id":3225139,"avatar_url":"https://avatars.githubusercontent.com/u/3225139?v=3","gravatar_id":"","url":"https://api.github.com/users/MrHug","html_url":"https://github.com/MrHug","followers_url":"https://api.github.com/users/MrHug/followers","following_url":"https://api.github.com/users/MrHug/following{/other_user}","gists_url":"https://api.github.com/users/MrHug/gists{/gist_id}","starred_url":"https://api.github.com/users/MrHug/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MrHug/subscriptions","organizations_url":"https://api.github.com/users/MrHug/orgs","repos_url":"https://api.github.com/users/MrHug/repos","events_url":"https://api.github.com/users/MrHug/events{/privacy}","received_events_url":"https://api.github.com/users/MrHug/received_events","type":"User","site_admin":false},"body":"English should be removed ;)","created_at":"2015-05-10T16:53:13Z","updated_at":"2015-05-10T16:53:13Z","html_url":"https://github.com/MOOCDataAnalysis/subtitles/pull/19#discussion_r30003895","pull_request_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/pulls/19","_links":{"self":{"href":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/pulls/comments/30003895"},"html":{"href":"https://github.com/MOOCDataAnalysis/subtitles/pull/19#discussion_r30003895"},"pull_request":{"href":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/pulls/19"}}},"pull_request":{"url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/pulls/19","id":34996846,"html_url":"https://github.com/MOOCDataAnalysis/subtitles/pull/19","diff_url":"https://github.com/MOOCDataAnalysis/subtitles/pull/19.diff","patch_url":"https://github.com/MOOCDataAnalysis/subtitles/pull/19.patch","issue_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/issues/19","number":19,"state":"open","locked":false,"title":"Dutch translations of 6.5 and 6.7","user":{"login":"dhoepelman","id":992153,"avatar_url":"https://avatars.githubusercontent.com/u/992153?v=3","gravatar_id":"","url":"https://api.github.com/users/dhoepelman","html_url":"https://github.com/dhoepelman","followers_url":"https://api.github.com/users/dhoepelman/followers","following_url":"https://api.github.com/users/dhoepelman/following{/other_user}","gists_url":"https://api.github.com/users/dhoepelman/gists{/gist_id}","starred_url":"https://api.github.com/users/dhoepelman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dhoepelman/subscriptions","organizations_url":"https://api.github.com/users/dhoepelman/orgs","repos_url":"https://api.github.com/users/dhoepelman/repos","events_url":"https://api.github.com/users/dhoepelman/events{/privacy}","received_events_url":"https://api.github.com/users/dhoepelman/received_events","type":"User","site_admin":false},"body":"","created_at":"2015-05-08T10:23:50Z","updated_at":"2015-05-10T16:53:13Z","closed_at":null,"merged_at":null,"merge_commit_sha":"ae2b3e11c9b9731b10b31eca892b2332750068c6","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/pulls/19/commits","review_comments_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/pulls/19/comments","review_comment_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/pulls/comments{/number}","comments_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/issues/19/comments","statuses_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/statuses/9fa93f0b044cb28ddbbd5072e4fe79a1dc456c72","head":{"label":"dhoepelman:master","ref":"master","sha":"9fa93f0b044cb28ddbbd5072e4fe79a1dc456c72","user":{"login":"dhoepelman","id":992153,"avatar_url":"https://avatars.githubusercontent.com/u/992153?v=3","gravatar_id":"","url":"https://api.github.com/users/dhoepelman","html_url":"https://github.com/dhoepelman","followers_url":"https://api.github.com/users/dhoepelman/followers","following_url":"https://api.github.com/users/dhoepelman/following{/other_user}","gists_url":"https://api.github.com/users/dhoepelman/gists{/gist_id}","starred_url":"https://api.github.com/users/dhoepelman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dhoepelman/subscriptions","organizations_url":"https://api.github.com/users/dhoepelman/orgs","repos_url":"https://api.github.com/users/dhoepelman/repos","events_url":"https://api.github.com/users/dhoepelman/events{/privacy}","received_events_url":"https://api.github.com/users/dhoepelman/received_events","type":"User","site_admin":false},"repo":{"id":35158393,"name":"subtitles","full_name":"dhoepelman/subtitles","owner":{"login":"dhoepelman","id":992153,"avatar_url":"https://avatars.githubusercontent.com/u/992153?v=3","gravatar_id":"","url":"https://api.github.com/users/dhoepelman","html_url":"https://github.com/dhoepelman","followers_url":"https://api.github.com/users/dhoepelman/followers","following_url":"https://api.github.com/users/dhoepelman/following{/other_user}","gists_url":"https://api.github.com/users/dhoepelman/gists{/gist_id}","starred_url":"https://api.github.com/users/dhoepelman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dhoepelman/subscriptions","organizations_url":"https://api.github.com/users/dhoepelman/orgs","repos_url":"https://api.github.com/users/dhoepelman/repos","events_url":"https://api.github.com/users/dhoepelman/events{/privacy}","received_events_url":"https://api.github.com/users/dhoepelman/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/dhoepelman/subtitles","description":"All subtitles for the ET101X MOOC can be found here","fork":true,"url":"https://api.github.com/repos/dhoepelman/subtitles","forks_url":"https://api.github.com/repos/dhoepelman/subtitles/forks","keys_url":"https://api.github.com/repos/dhoepelman/subtitles/keys{/key_id}","collaborators_url":"https://api.github.com/repos/dhoepelman/subtitles/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/dhoepelman/subtitles/teams","hooks_url":"https://api.github.com/repos/dhoepelman/subtitles/hooks","issue_events_url":"https://api.github.com/repos/dhoepelman/subtitles/issues/events{/number}","events_url":"https://api.github.com/repos/dhoepelman/subtitles/events","assignees_url":"https://api.github.com/repos/dhoepelman/subtitles/assignees{/user}","branches_url":"https://api.github.com/repos/dhoepelman/subtitles/branches{/branch}","tags_url":"https://api.github.com/repos/dhoepelman/subtitles/tags","blobs_url":"https://api.github.com/repos/dhoepelman/subtitles/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/dhoepelman/subtitles/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/dhoepelman/subtitles/git/refs{/sha}","trees_url":"https://api.github.com/repos/dhoepelman/subtitles/git/trees{/sha}","statuses_url":"https://api.github.com/repos/dhoepelman/subtitles/statuses/{sha}","languages_url":"https://api.github.com/repos/dhoepelman/subtitles/languages","stargazers_url":"https://api.github.com/repos/dhoepelman/subtitles/stargazers","contributors_url":"https://api.github.com/repos/dhoepelman/subtitles/contributors","subscribers_url":"https://api.github.com/repos/dhoepelman/subtitles/subscribers","subscription_url":"https://api.github.com/repos/dhoepelman/subtitles/subscription","commits_url":"https://api.github.com/repos/dhoepelman/subtitles/commits{/sha}","git_commits_url":"https://api.github.com/repos/dhoepelman/subtitles/git/commits{/sha}","comments_url":"https://api.github.com/repos/dhoepelman/subtitles/comments{/number}","issue_comment_url":"https://api.github.com/repos/dhoepelman/subtitles/issues/comments{/number}","contents_url":"https://api.github.com/repos/dhoepelman/subtitles/contents/{+path}","compare_url":"https://api.github.com/repos/dhoepelman/subtitles/compare/{base}...{head}","merges_url":"https://api.github.com/repos/dhoepelman/subtitles/merges","archive_url":"https://api.github.com/repos/dhoepelman/subtitles/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/dhoepelman/subtitles/downloads","issues_url":"https://api.github.com/repos/dhoepelman/subtitles/issues{/number}","pulls_url":"https://api.github.com/repos/dhoepelman/subtitles/pulls{/number}","milestones_url":"https://api.github.com/repos/dhoepelman/subtitles/milestones{/number}","notifications_url":"https://api.github.com/repos/dhoepelman/subtitles/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/dhoepelman/subtitles/labels{/name}","releases_url":"https://api.github.com/repos/dhoepelman/subtitles/releases{/id}","created_at":"2015-05-06T12:55:26Z","updated_at":"2015-03-27T13:17:24Z","pushed_at":"2015-05-07T14:35:29Z","git_url":"git://github.com/dhoepelman/subtitles.git","ssh_url":"git@github.com:dhoepelman/subtitles.git","clone_url":"https://github.com/dhoepelman/subtitles.git","svn_url":"https://github.com/dhoepelman/subtitles","homepage":null,"size":852,"stargazers_count":0,"watchers_count":0,"language":null,"has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"MOOCDataAnalysis:master","ref":"master","sha":"4b4df04fc494e65b010a8d656d045e9aa22b4be8","user":{"login":"MOOCDataAnalysis","id":10114956,"avatar_url":"https://avatars.githubusercontent.com/u/10114956?v=3","gravatar_id":"","url":"https://api.github.com/users/MOOCDataAnalysis","html_url":"https://github.com/MOOCDataAnalysis","followers_url":"https://api.github.com/users/MOOCDataAnalysis/followers","following_url":"https://api.github.com/users/MOOCDataAnalysis/following{/other_user}","gists_url":"https://api.github.com/users/MOOCDataAnalysis/gists{/gist_id}","starred_url":"https://api.github.com/users/MOOCDataAnalysis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MOOCDataAnalysis/subscriptions","organizations_url":"https://api.github.com/users/MOOCDataAnalysis/orgs","repos_url":"https://api.github.com/users/MOOCDataAnalysis/repos","events_url":"https://api.github.com/users/MOOCDataAnalysis/events{/privacy}","received_events_url":"https://api.github.com/users/MOOCDataAnalysis/received_events","type":"Organization","site_admin":false},"repo":{"id":31412897,"name":"subtitles","full_name":"MOOCDataAnalysis/subtitles","owner":{"login":"MOOCDataAnalysis","id":10114956,"avatar_url":"https://avatars.githubusercontent.com/u/10114956?v=3","gravatar_id":"","url":"https://api.github.com/users/MOOCDataAnalysis","html_url":"https://github.com/MOOCDataAnalysis","followers_url":"https://api.github.com/users/MOOCDataAnalysis/followers","following_url":"https://api.github.com/users/MOOCDataAnalysis/following{/other_user}","gists_url":"https://api.github.com/users/MOOCDataAnalysis/gists{/gist_id}","starred_url":"https://api.github.com/users/MOOCDataAnalysis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MOOCDataAnalysis/subscriptions","organizations_url":"https://api.github.com/users/MOOCDataAnalysis/orgs","repos_url":"https://api.github.com/users/MOOCDataAnalysis/repos","events_url":"https://api.github.com/users/MOOCDataAnalysis/events{/privacy}","received_events_url":"https://api.github.com/users/MOOCDataAnalysis/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/MOOCDataAnalysis/subtitles","description":"All subtitles for the ET101X MOOC can be found here","fork":false,"url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles","forks_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/forks","keys_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/keys{/key_id}","collaborators_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/teams","hooks_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/hooks","issue_events_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/issues/events{/number}","events_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/events","assignees_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/assignees{/user}","branches_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/branches{/branch}","tags_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/tags","blobs_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/git/refs{/sha}","trees_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/git/trees{/sha}","statuses_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/statuses/{sha}","languages_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/languages","stargazers_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/stargazers","contributors_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/contributors","subscribers_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/subscribers","subscription_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/subscription","commits_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/commits{/sha}","git_commits_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/git/commits{/sha}","comments_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/comments{/number}","issue_comment_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/issues/comments{/number}","contents_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/contents/{+path}","compare_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/compare/{base}...{head}","merges_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/merges","archive_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/downloads","issues_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/issues{/number}","pulls_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/pulls{/number}","milestones_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/milestones{/number}","notifications_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/labels{/name}","releases_url":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/releases{/id}","created_at":"2015-02-27T09:45:32Z","updated_at":"2015-03-27T13:17:24Z","pushed_at":"2015-05-10T16:46:15Z","git_url":"git://github.com/MOOCDataAnalysis/subtitles.git","ssh_url":"git@github.com:MOOCDataAnalysis/subtitles.git","clone_url":"https://github.com/MOOCDataAnalysis/subtitles.git","svn_url":"https://github.com/MOOCDataAnalysis/subtitles","homepage":null,"size":1584,"stargazers_count":1,"watchers_count":1,"language":null,"has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":3,"mirror_url":null,"open_issues_count":2,"forks":3,"open_issues":2,"watchers":1,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/pulls/19"},"html":{"href":"https://github.com/MOOCDataAnalysis/subtitles/pull/19"},"issue":{"href":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/issues/19"},"comments":{"href":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/issues/19/comments"},"review_comments":{"href":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/pulls/19/comments"},"review_comment":{"href":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/pulls/19/commits"},"statuses":{"href":"https://api.github.com/repos/MOOCDataAnalysis/subtitles/statuses/9fa93f0b044cb28ddbbd5072e4fe79a1dc456c72"}}}}