No Way Know How

When concatenating PDFs into a single file, I tried imagemagick: convert first.pdf second.pdf third.pdf output.pdf but the resolution suffered. This forum suggests that Imagemagick makes use of ghostscript in this action and provides a command that cuts out the middleman: gs -dBATCH -dNOPAUSE -q -sDEVICE=pdfwrite -sOutputFile=temp.pdf pdf1.pdf pdf2.pdf This worked like a charm, and fast, but I'm not massively happy copypasting commands I'll never remember. 1) record it here for future use 2) alias it, or write a super simple bash script? 3) look into ghostscript and see if I can simplify the command, learn the syntax

When concatenating PDFs into a single file, I tried imagemagick: convert first.pdf second.pdf third.pdf output.pdf but the resolution suffered. This forum suggests that Imagemagick makes use of ghostscript in this action and provides a command that cuts out the middleman: gs -dBATCH -dNOPAUSE -q -sDEVICE=pdfwrite -sOutputFile=temp.pdf pdf1.pdf pdf2.pdf This worked like a charm, and fast, but I'm not massively happy copypasting commands I'll never remember. 1) record it here for future use 2) alias it, or write a super simple bash script? 3) look into ghostscript and see if I can simplify the command, learn the syntax

finally think I've figured this out, after many attempts. quite simple really. http://stackoverflow.com/questions/3881209/keep-absolute-reference-even-when-inserting-rows-in-excel-2007 formula is =INDIRECT("[reference]") the crucial part is the quotes. presumably they turn the refernce into a literal string which obviously does not change with the workbook structure.

Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Column < 5 Then Exit Sub If Target.Column > 5 Then Exit Sub On Error GoTo ErrHandler Application.EnableEvents = False Target.Formula = UCase(Target.Formula) ErrHandler: Application.EnableEvents = True End Sub adapted from this forum http://www.excelforum.com/excel-formulas-and-functions/347695-automatically-change-text-to-uppercase.html

https://exceljet.net/keyboard-shortcuts/insert-current-date CTRL + ; when recording a macro, this action will be interpreted as insert "11/05/2016" say - rather than "insert current date" you need = Date instead

https://github.com/get-iplayer/get_iplayer/wiki/documentation my usage so far has been: get_iplayer --type=radio [search term] to locate the Programme ID (PID) then: get_iplayer --type=radio --pid:b00sf0d1

I managed this more or less by myself. sudo pacman -S linux-lts linux-headers-lts Installing the lts kernel will prompt for the headers, so you might as well do them together. Then go to /boot and find the conf file, under loader or wherever. copy the file and append -lts to the linux img lines and vmlinuz-linux. then sudo bootctl update, reboot, and you should have the new entry in the UEFI boot menu.