-
Formatting external drives for Mac and Windows
Formatting external drives (flash drives and external HD) for use in Mac and Windows environment can be quite confusing. Here is some info I put together: NTFS Windows (XP+): read/write Mac: read* Note: There is an option to activate writing to NTFS partitions in Mac, but it’s not stable and can corrupt files. FAT32 Windows (XP+):…
-
Scheduling automatic Google Sheets changes
I have a weekly schedule for our rotations at the hospital in Google Sheets. It usually contains the schedule for the next two months. The problem was that one always had always to search for the current week… So I thought there should be a way to automatically hide past weeks from the sheet. In fact, this…
-
Printing your brain in 3D
So I’ve been doing some testing on our newly acquired CubeX 3D printer and had the idea to print a miniature of my brain. Since I served as a control for one study, I had a great T1 scan from a 3T MRI. This scan had allready been processed by FreeSurfer, so all I had…
-
Remove spaces from filename in Mac
This is just a small code to remove spaces from filenames in a Mac bash terminal: for i in *.nii; do mv “$i” “`echo $i | sed -e ‘s, ,,g’`”; done Change *.nii to find other type of files. Put a – or _ between the two commas before the g to substitute the space…
-
Google script: substitute blank cells by “x”
Today I had a big spreadsheet with quite a few missing values, which I wanted to substitue by “x”. So I decided to write my first google script! I’ts pretty straight forward: in your open spreadsheet, go to Tools > Script Editor and put in the following code: function onOpen() { var sheet = SpreadsheetApp.getActiveSheet(); var…
-
Datas no Google Docs
Pra quem já esquentou a cabeça com a formatação automatica de datas para o formato americano (mes-dia-ano) no Google Docs, aqui vai a dica de como resolver o problema: Abrir uma planilha. Clicar em Arquivo > Configurações da planilha. Na janela exibida, alterar o fuso horário e a localidade. Clicar em Salvar configurações. Pronto, agora é só ir em…