Wednesday, June 28, 2017

target .Net framework

When adding library dependencies, make sure they dlls are targeting the same .Net framework as the project. took me ~12 hours to figure out that i was using a dll with 4.5.2 in place of 4.5. couldnt figure out wth was going on, why the build was failing

Friday, June 16, 2017

missing dependencis

-rdkit
-improper cudnn (used this for upgrading)

ubuntu login loop while nvidia driver update

got into a login loop, when i updated my nvidia driver. not sure what fixed the issue. But i just uninstalled and reinstalled the driver from the shell and the login loop was gone.

Monday, April 24, 2017

Filtering in excel using a list of values

https://www.extendoffice.com/documents/excel/3186-excel-filter-rows-by-list.html

Wednesday, March 8, 2017

Monday, February 6, 2017

Most frequently occuring data in a row

=INDEX(B2:D2,MODE(MATCH(B2:D2,B2:D2,0)))

can be used for example to count votes

Splitting a colum into multiple columns Excel

=INDIRECT("Sheet1!R" & (ROW()-1)*3+1 & "C1", FALSE)


Say you have a long oclumn of data. You want to split it  into 3 columns such that, every third element  goes into each column.  for example youd data is: AAABBBCCCDDDEEEFFFGGGHHH
you want to split into 3 columns : ABCDEFGH, ABCDEFGH, ABCDEFGH. use the above formula