Skip to content

Instantly share code, notes, and snippets.

@brettbond
Last active July 17, 2019 17:21
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save brettbond/7dfe97d15dc33cec771ae3590bc2dffa to your computer and use it in GitHub Desktop.
Save brettbond/7dfe97d15dc33cec771ae3590bc2dffa to your computer and use it in GitHub Desktop.
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