Last active
July 17, 2019 17:21
-
-
Save brettbond/7dfe97d15dc33cec771ae3590bc2dffa to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
applicant id,question,timestamp,response time,response given,is correct,total_score,points | |
2015-DEPC-3547,Question 23,2017-11-22 16:56:31.146472+00:00,0:01:20.668118,Answer 4,False,4,"=if(E2=TRUE, 1, 0)" | |
2015-DEPC-3547,Question 32,2017-11-22 16:56:50.585263+00:00,0:00:18.858509,Answer 1,True,4,"=if(E3=TRUE, 1, 0)" | |
2015-DEPC-3547,Question 68,2017-11-22 16:57:19.112457+00:00,0:00:07.918250,Answer 2,False,4,"=if(E4=TRUE, 1, 0)" | |
2015-DEPC-3547,Question 65,2017-11-22 16:58:14.922487+00:00,0:00:54.301350,Answer 1,True,4,"=if(E5=TRUE, 1, 0)" | |
2015-DEPC-3547,Question 24,2017-11-22 16:58:30.939549+00:00,0:00:13.085649,Answer 2,False,4,"=if(E6=TRUE, 1, 0)" | |
2015-DEPC-3547,Question 64,2017-11-22 16:59:04.647258+00:00,0:00:35.153020,Answer 2,False,4,"=if(E7=TRUE, 1, 0)" | |
2015-DEPC-3547,Question 95,2017-11-22 16:59:31.642663+00:00,0:00:25.921001,Answer 1,True,4,"=if(E8=TRUE, 1, 0)" | |
2015-DEPC-3547,Question 99,2017-11-22 16:59:59.757249+00:00,0:00:28.065829,Answer 4,False,4,"=if(E9=TRUE, 1, 0)" | |
2015-DEPC-3547,Question 74,2017-11-22 17:00:10.392453+00:00,0:00:10.152396,Answer 1,True,4,"=if(E10=TRUE, 1, 0)" | |
2015-DEPC-3547,Question 94,2017-11-22 17:00:20.755451+00:00,0:00:06.957527,Answer 2,False,4,"=if(E11=TRUE, 1, 0)" | |
2015-DEPC-3547,Question 52,2017-11-22 17:00:29.822427+00:00,0:00:08.451609,Answer 2,False,4,"=if(E12=TRUE, 1, 0)" | |
2015-DEPC-3547,Question 100,2017-11-22 16:55:06.333731+00:00,,,,4,"=if(E13=TRUE, 1, 0)" | |
2015-DEPC-3547,Question 21,2017-11-22 16:53:12.426867+00:00,,Answer 4,False,4,"=if(E14=TRUE, 1, 0)" | |
2015-DEPC-3547,Question 29,2017-11-22 16:53:52.588516+00:00,,Answer 4,False,4,"=if(E15=TRUE, 1, 0)" | |
2015-JKEE-2775,Question 40,2017-02-19 12:45:38.229566+00:00,0:00:14.221699,Answer 1,True,5,"=if(E16=TRUE, 1, 0)" | |
2015-JKEE-2775,Question 37,2017-02-19 12:47:24.654641+00:00,0:00:48.693526,Answer 1,True,5,"=if(E17=TRUE, 1, 0)" | |
2015-JKEE-2775,Question 80,2017-02-19 12:48:41.520381+00:00,0:00:55.170892,Answer 3,False,5,"=if(E18=TRUE, 1, 0)" | |
2015-JKEE-2775,Question 64,2017-02-19 12:49:27.156395+00:00,0:00:42.450106,Answer 3,False,5,"=if(E19=TRUE, 1, 0)" | |
2015-JKEE-2775,Question 19,2017-02-19 12:53:14.180364+00:00,0:03:46.470077,Answer 2,False,5,"=if(E20=TRUE, 1, 0)" | |
2015-JKEE-2775,Question 38,2017-02-19 12:50:21.636981+00:00,0:00:12.868629,Answer 2,False,5,"=if(E21=TRUE, 1, 0)" | |
2015-JKEE-2775,Question 93,2017-02-19 12:51:00.980639+00:00,0:00:38.535534,Answer 1,True,5,"=if(E22=TRUE, 1, 0)" | |
2015-JKEE-2775,Question 48,2017-02-19 12:53:57.458322+00:00,0:02:34.132946,Answer 2,False,5,"=if(E23=TRUE, 1, 0)" | |
2015-JKEE-2775,Question 97,2017-02-19 12:52:12.357936+00:00,0:00:22.483988,Answer 4,False,5,"=if(E24=TRUE, 1, 0)" | |
2015-JKEE-2775,Question 56,2017-02-19 12:52:37.497455+00:00,0:00:24.581849,Answer 4,False,5,"=if(E25=TRUE, 1, 0)" | |
2015-JKEE-2775,Question 21,2017-02-19 12:43:12.464364+00:00,,Answer 1,True,5,"=if(E26=TRUE, 1, 0)" | |
2015-JKEE-2775,Question 29,2017-02-19 12:43:56.798714+00:00,,Answer 1,True,5,"=if(E27=TRUE, 1, 0)" | |
2016-HPJQ-7238,Question 92,2016-08-01 03:09:46.783573+00:00,,,,0,"=if(E28=TRUE, 1, 0)" | |
2016-HPJQ-7238,Question 68,2016-08-01 03:09:46.786291+00:00,,,,0,"=if(E29=TRUE, 1, 0)" | |
2016-HPJQ-7238,Question 45,2016-08-01 03:09:46.791753+00:00,,,,0,"=if(E30=TRUE, 1, 0)" | |
2016-HPJQ-7238,Question 33,2016-08-01 03:09:46.794459+00:00,,,,0,"=if(E31=TRUE, 1, 0)" | |
2016-HPJQ-7238,Question 19,2016-08-01 03:09:46.797111+00:00,,,,0,"=if(E32=TRUE, 1, 0)" | |
2016-HPJQ-7238,Question 38,2016-08-01 03:09:46.799852+00:00,,,,0,"=if(E33=TRUE, 1, 0)" | |
2016-HPJQ-7238,Question 58,2016-08-01 03:09:46.802512+00:00,,,,0,"=if(E34=TRUE, 1, 0)" | |
2016-HPJQ-7238,Question 94,2016-08-01 03:09:46.805170+00:00,,,,0,"=if(E35=TRUE, 1, 0)" | |
2016-HPJQ-7238,Question 83,2016-08-01 03:09:46.807838+00:00,,,,0,"=if(E36=TRUE, 1, 0)" | |
2016-HPJQ-7238,Question 82,2016-08-01 03:09:46.810519+00:00,,,,0,"=if(E37=TRUE, 1, 0)" | |
2016-HPJQ-7238,Question 21,2016-08-01 03:09:35.364035+00:00,,,,0,"=if(E38=TRUE, 1, 0)" | |
2016-HPJQ-7238,Question 29,2016-08-01 03:09:35.391463+00:00,,,,0,"=if(E39=TRUE, 1, 0)" | |
2016-UQPN-1909,Question 17,2016-08-01 03:50:25.361757+00:00,0:00:01.791878,Answer 3,False,2,"=if(E40=TRUE, 1, 0)" | |
2016-UQPN-1909,Question 40,2016-08-01 03:50:29.121259+00:00,0:00:01.069082,Answer 2,False,2,"=if(E41=TRUE, 1, 0)" | |
2016-UQPN-1909,Question 92,2016-08-01 03:50:32.144215+00:00,0:00:02.293632,Answer 1,True,2,"=if(E42=TRUE, 1, 0)" | |
2016-UQPN-1909,Question 68,2016-08-01 03:50:33.667453+00:00,0:00:00.573351,Answer 1,True,2,"=if(E43=TRUE, 1, 0)" | |
2016-UQPN-1909,Question 24,2016-08-01 03:50:23.151504+00:00,,,,2,"=if(E44=TRUE, 1, 0)" | |
2016-UQPN-1909,Question 64,2016-08-01 03:50:23.153581+00:00,,,,2,"=if(E45=TRUE, 1, 0)" | |
2016-UQPN-1909,Question 25,2016-08-01 03:50:23.155598+00:00,,,,2,"=if(E46=TRUE, 1, 0)" | |
2016-UQPN-1909,Question 42,2016-08-01 03:50:23.157613+00:00,,,,2,"=if(E47=TRUE, 1, 0)" | |
2016-UQPN-1909,Question 74,2016-08-01 03:50:23.159615+00:00,,,,2,"=if(E48=TRUE, 1, 0)" | |
2016-UQPN-1909,Question 57,2016-08-01 03:50:23.161573+00:00,,,,2,"=if(E49=TRUE, 1, 0)" | |
2016-UQPN-1909,Question 82,2016-08-01 03:50:23.165588+00:00,,,,2,"=if(E50=TRUE, 1, 0)" | |
2016-UQPN-1909,Question 21,2016-08-01 03:50:12.628052+00:00,,,,2,"=if(E51=TRUE, 1, 0)" | |
2016-UQPN-1909,Question 29,2016-08-01 03:50:12.649653+00:00,,,,2,"=if(E52=TRUE, 1, 0)" | |
2016-MSJB-3725,Question 17,2016-09-20 23:45:43.725599+00:00,,,,0,"=if(E53=TRUE, 1, 0)" | |
2016-MSJB-3725,Question 40,2016-09-20 23:45:43.749651+00:00,,,,0,"=if(E54=TRUE, 1, 0)" | |
2016-MSJB-3725,Question 36,2016-09-20 23:45:43.775040+00:00,,,,0,"=if(E55=TRUE, 1, 0)" | |
2016-MSJB-3725,Question 18,2016-09-20 23:45:43.832257+00:00,,,,0,"=if(E56=TRUE, 1, 0)" | |
2016-MSJB-3725,Question 45,2016-09-20 23:45:43.858296+00:00,,,,0,"=if(E57=TRUE, 1, 0)" | |
2016-MSJB-3725,Question 78,2016-09-20 23:45:43.882418+00:00,,,,0,"=if(E58=TRUE, 1, 0)" | |
2016-MSJB-3725,Question 84,2016-09-20 23:45:43.908479+00:00,,,,0,"=if(E59=TRUE, 1, 0)" | |
2016-MSJB-3725,Question 38,2016-09-20 23:45:43.933320+00:00,,,,0,"=if(E60=TRUE, 1, 0)" | |
2016-MSJB-3725,Question 93,2016-09-20 23:45:43.958159+00:00,,,,0,"=if(E61=TRUE, 1, 0)" | |
2016-MSJB-3725,Question 59,2016-09-20 23:45:43.983078+00:00,,,,0,"=if(E62=TRUE, 1, 0)" | |
2016-MSJB-3725,Question 44,2016-09-20 23:45:44.015691+00:00,,,,0,"=if(E63=TRUE, 1, 0)" | |
2016-MSJB-3725,Question 60,2016-09-20 23:45:44.042233+00:00,,,,0,"=if(E64=TRUE, 1, 0)" | |
2016-MSJB-3725,Question 21,2016-09-20 23:45:16.945990+00:00,,,,0,"=if(E65=TRUE, 1, 0)" | |
2016-MSJB-3725,Question 29,2016-09-20 23:45:32.359169+00:00,,Answer 1,True,0,"=if(E66=TRUE, 1, 0)" | |
2016-LLCO-6475,Question 23,2016-08-21 20:12:19.503250+00:00,0:00:30.573334,Answer 1,True,10,"=if(E67=TRUE, 1, 0)" | |
2016-LLCO-6475,Question 40,2016-08-21 20:13:23.926400+00:00,0:00:53.939144,Answer 1,True,10,"=if(E68=TRUE, 1, 0)" | |
2016-LLCO-6475,Question 92,2016-08-21 20:13:52.537718+00:00,0:00:22.442958,Answer 1,True,10,"=if(E69=TRUE, 1, 0)" | |
2016-LLCO-6475,Question 68,2016-08-21 20:15:38.351360+00:00,0:00:57.327204,Answer 1,True,10,"=if(E70=TRUE, 1, 0)" | |
2016-LLCO-6475,Question 65,2016-08-21 20:16:08.719135+00:00,0:00:33.583693,Answer 1,True,10,"=if(E71=TRUE, 1, 0)" | |
2016-LLCO-6475,Question 24,2016-08-21 20:17:19.759444+00:00,0:00:41.522259,Answer 1,True,10,"=if(E72=TRUE, 1, 0)" | |
2016-LLCO-6475,Question 77,2016-08-21 20:19:27.772911+00:00,0:01:41.390752,Answer 1,True,10,"=if(E73=TRUE, 1, 0)" | |
2016-LLCO-6475,Question 84,2016-08-21 20:20:18.573822+00:00,0:00:47.078090,Answer 1,True,10,"=if(E74=TRUE, 1, 0)" | |
2016-LLCO-6475,Question 98,2016-08-21 20:21:38.091053+00:00,0:00:39.118552,Answer 1,True,10,"=if(E75=TRUE, 1, 0)" | |
2016-LLCO-6475,Question 58,2016-08-21 20:30:46.938216+00:00,0:08:41.986480,Answer 2,False,10,"=if(E76=TRUE, 1, 0)" | |
2016-LLCO-6475,Question 94,2016-08-21 20:26:25.322884+00:00,0:02:26.070783,Answer 2,False,10,"=if(E77=TRUE, 1, 0)" | |
2016-LLCO-6475,Question 97,2016-08-21 20:28:59.575452+00:00,0:02:29.461563,Answer 1,True,10,"=if(E78=TRUE, 1, 0)" | |
2016-LLCO-6475,Question 69,2016-08-21 20:29:30.136314+00:00,0:00:29.710774,Answer 3,False,10,"=if(E79=TRUE, 1, 0)" | |
2016-LLCO-6475,Question 21,2016-08-21 20:10:11.772047+00:00,,Answer 1,True,10,"=if(E80=TRUE, 1, 0)" | |
2016-LLCO-6475,Question 29,2016-08-21 20:10:55.028582+00:00,,Answer 1,True,10,"=if(E81=TRUE, 1, 0)" | |
2016-ERXL-5786,Question 32,2016-08-02 03:09:15.481382+00:00,0:00:16.853216,Answer 1,True,10,"=if(E82=TRUE, 1, 0)" | |
2016-ERXL-5786,Question 92,2016-08-02 03:10:38.621376+00:00,0:01:08.589433,Answer 1,True,10,"=if(E83=TRUE, 1, 0)" | |
2016-ERXL-5786,Question 37,2016-08-02 03:11:38.153709+00:00,0:00:42.496334,Answer 1,True,10,"=if(E84=TRUE, 1, 0)" | |
2016-ERXL-5786,Question 39,2016-08-02 03:13:22.029141+00:00,0:00:45.912061,Answer 1,True,10,"=if(E85=TRUE, 1, 0)" | |
2016-ERXL-5786,Question 95,2016-08-02 03:15:18.415860+00:00,0:01:08.250611,Answer 1,True,10,"=if(E86=TRUE, 1, 0)" | |
2016-ERXL-5786,Question 38,2016-08-02 03:15:41.821030+00:00,0:00:21.555813,Answer 1,True,10,"=if(E87=TRUE, 1, 0)" | |
2016-ERXL-5786,Question 93,2016-08-02 03:16:21.377759+00:00,0:00:38.586529,Answer 1,True,10,"=if(E88=TRUE, 1, 0)" | |
2016-ERXL-5786,Question 94,2016-08-02 03:17:38.429179+00:00,0:01:14.693792,Answer 2,False,10,"=if(E89=TRUE, 1, 0)" | |
2016-ERXL-5786,Question 44,2016-08-02 03:18:28.899163+00:00,0:00:50.484961,Answer 3,False,10,"=if(E90=TRUE, 1, 0)" | |
2016-ERXL-5786,Question 100,2016-08-02 03:22:01.005613+00:00,0:03:17.189088,Answer 2,False,10,"=if(E91=TRUE, 1, 0)" | |
2016-ERXL-5786,Question 21,2016-08-02 03:07:11.614820+00:00,,Answer 1,True,10,"=if(E92=TRUE, 1, 0)" | |
2016-ERXL-5786,Question 29,2016-08-02 03:07:27.032224+00:00,,Answer 1,True,10,"=if(E93=TRUE, 1, 0)" | |
2016-RNTT-1931,Question 17,2016-08-02 09:53:40.086682+00:00,0:00:17.924139,Answer 1,True,6,"=if(E94=TRUE, 1, 0)" | |
2016-RNTT-1931,Question 34,2016-08-02 09:55:54.462019+00:00,0:01:29.379383,Answer 1,True,6,"=if(E95=TRUE, 1, 0)" | |
2016-RNTT-1931,Question 37,2016-08-02 09:56:50.584646+00:00,0:00:54.375518,Answer 2,False,6,"=if(E96=TRUE, 1, 0)" | |
2016-RNTT-1931,Question 22,2016-08-02 09:57:56.062615+00:00,0:01:04.094589,Answer 1,True,6,"=if(E97=TRUE, 1, 0)" | |
2016-RNTT-1931,Question 80,2016-08-02 09:59:40.041068+00:00,0:01:41.159679,Answer 3,False,6,"=if(E98=TRUE, 1, 0)" | |
2016-RNTT-1931,Question 64,2016-08-02 10:00:43.049426+00:00,0:01:02.539443,Answer 1,True,6,"=if(E99=TRUE, 1, 0)" | |
2016-RNTT-1931,Question 95,2016-08-02 10:02:50.654108+00:00,0:02:07.151146,Answer 4,False,6,"=if(E100=TRUE, 1, 0)" | |
2016-RNTT-1931,Question 98,2016-08-02 10:10:39.645977+00:00,0:07:31.969175,Answer 4,False,6,"=if(E101=TRUE, 1, 0)" | |
2016-RNTT-1931,Question 74,2016-08-02 10:05:58.277362+00:00,0:00:39.480627,Answer 1,True,6,"=if(E102=TRUE, 1, 0)" | |
2016-RNTT-1931,Question 94,2016-08-02 10:07:12.190112+00:00,0:01:11.621340,Answer 2,False,6,"=if(E103=TRUE, 1, 0)" | |
2016-RNTT-1931,Question 52,2016-08-02 10:11:28.183624+00:00,0:04:13.671237,Answer 2,False,6,"=if(E104=TRUE, 1, 0)" | |
2016-RNTT-1931,Question 91,2016-08-02 10:10:21.845382+00:00,0:01:16.085846,Answer 1,True,6,"=if(E105=TRUE, 1, 0)" | |
2016-RNTT-1931,Question 21,2016-08-02 09:51:09.933047+00:00,,Answer 1,True,6,"=if(E106=TRUE, 1, 0)" | |
2016-RNTT-1931,Question 29,2016-08-02 09:51:52.464725+00:00,,Answer 1,True,6,"=if(E107=TRUE, 1, 0)" | |
2016-TXTH-3311,Question 71,2016-08-03 17:10:40.601285+00:00,0:01:01.494525,Answer 3,False,4,"=if(E108=TRUE, 1, 0)" | |
2016-TXTH-3311,Question 32,2016-08-03 17:11:07.310057+00:00,0:00:25.106080,Answer 1,True,4,"=if(E109=TRUE, 1, 0)" | |
2016-TXTH-3311,Question 92,2016-08-03 17:11:32.268587+00:00,0:00:23.356626,Answer 4,False,4,"=if(E110=TRUE, 1, 0)" | |
2016-TXTH-3311,Question 66,2016-08-03 17:13:44.019450+00:00,0:02:08.677187,Answer 2,False,4,"=if(E111=TRUE, 1, 0)" | |
2016-TXTH-3311,Question 65,2016-08-03 17:16:39.149836+00:00,0:02:53.118334,Answer 4,False,4,"=if(E112=TRUE, 1, 0)" | |
2016-TXTH-3311,Question 45,2016-08-03 17:09:37.580325+00:00,,,,4,"=if(E113=TRUE, 1, 0)" | |
2016-TXTH-3311,Question 78,2016-08-03 17:20:30.802229+00:00,0:01:38.079003,Answer 4,False,4,"=if(E114=TRUE, 1, 0)" | |
2016-TXTH-3311,Question 27,2016-08-03 17:21:48.974074+00:00,0:01:17.143017,Answer 1,True,4,"=if(E115=TRUE, 1, 0)" | |
2016-TXTH-3311,Question 99,2016-08-03 17:23:35.258505+00:00,0:01:42.465760,Answer 1,True,4,"=if(E116=TRUE, 1, 0)" | |
2016-TXTH-3311,Question 58,2016-08-03 17:09:37.586888+00:00,,,,4,"=if(E117=TRUE, 1, 0)" | |
2016-TXTH-3311,Question 96,2016-08-03 17:29:08.112434+00:00,,Answer 1,True,4,"=if(E118=TRUE, 1, 0)" | |
2016-TXTH-3311,Question 44,2016-08-03 17:29:40.476123+00:00,0:00:29.864789,Answer 2,False,4,"=if(E119=TRUE, 1, 0)" | |
2016-TXTH-3311,Question 82,2016-08-03 17:30:28.299827+00:00,0:01:17.091211,Answer 3,False,4,"=if(E120=TRUE, 1, 0)" | |
2016-TXTH-3311,Question 21,2016-08-03 17:08:42.198802+00:00,,Answer 1,True,4,"=if(E121=TRUE, 1, 0)" | |
2016-TXTH-3311,Question 29,2016-08-03 17:05:55.032607+00:00,,,,4,"=if(E122=TRUE, 1, 0)" | |
2016-NDOF-9663,Question 23,2016-08-02 11:04:49.498792+00:00,0:01:10.909548,Answer 1,True,4,"=if(E123=TRUE, 1, 0)" | |
2016-NDOF-9663,Question 88,2016-08-02 11:05:03.922817+00:00,0:01:05.865501,Answer 2,False,4,"=if(E124=TRUE, 1, 0)" | |
2016-NDOF-9663,Question 26,2016-08-02 11:03:37.528014+00:00,,,,4,"=if(E125=TRUE, 1, 0)" | |
2016-NDOF-9663,Question 20,2016-08-02 11:06:24.234225+00:00,0:01:14.309121,Answer 2,False,4,"=if(E126=TRUE, 1, 0)" | |
2016-NDOF-9663,Question 65,2016-08-02 11:07:27.859663+00:00,0:01:03.299061,Answer 4,False,4,"=if(E127=TRUE, 1, 0)" | |
2016-NDOF-9663,Question 45,2016-08-02 11:07:57.166961+00:00,0:00:28.854680,Answer 2,False,4,"=if(E128=TRUE, 1, 0)" | |
2016-NDOF-9663,Question 78,2016-08-02 11:08:19.166009+00:00,0:00:20.377511,Answer 4,False,4,"=if(E129=TRUE, 1, 0)" | |
2016-NDOF-9663,Question 25,2016-08-02 11:09:02.452998+00:00,0:00:41.214176,Answer 1,True,4,"=if(E130=TRUE, 1, 0)" | |
2016-NDOF-9663,Question 38,2016-08-02 11:09:29.353802+00:00,0:00:25.590741,Answer 1,True,4,"=if(E131=TRUE, 1, 0)" | |
2016-NDOF-9663,Question 93,2016-08-02 11:10:12.702680+00:00,0:01:08.086946,Answer 2,False,4,"=if(E132=TRUE, 1, 0)" | |
2016-NDOF-9663,Question 94,2016-08-02 11:11:02.507820+00:00,0:00:48.778533,Answer 4,False,4,"=if(E133=TRUE, 1, 0)" | |
2016-NDOF-9663,Question 52,2016-08-02 11:11:53.119706+00:00,0:00:48.920147,Answer 1,True,4,"=if(E134=TRUE, 1, 0)" | |
2016-NDOF-9663,Question 55,2016-08-02 11:12:16.876917+00:00,0:00:19.941664,Answer 2,False,4,"=if(E135=TRUE, 1, 0)" | |
2016-NDOF-9663,Question 21,2016-08-02 11:02:24.618338+00:00,,Answer 1,True,4,"=if(E136=TRUE, 1, 0)" | |
2016-NDOF-9663,Question 29,2016-08-02 11:02:37.064632+00:00,,Answer 1,True,4,"=if(E137=TRUE, 1, 0)" |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment