Paul's Latest Public Bookmarks
worksheet function - How do I calculate percentage change in an Excel formula? - Super User
=(B3/B2)-1 Set 'result' format to Percentage and you're all set!
Saved by: Paul on 24 Jul 2020
ProcessWire: An open source CMS with a powerful API
Interesting looking, relatively small CMS. As recommended on the WAUK list
Saved by: Paul on 14 Jul 2020
Hardspace: Shipbreaker on Steam
Cool looking game, not a million miles away from one of my story ideas
Saved by: Paul on 13 Jul 2020
php - dompdf character encoding UTF-8 - Stack Overflow
How to get various entities / odd character encoding problems (e.g. ticks) to show when making a PDF with dompdf - main fix was to use the DejaVu Sans font.
Saved by: Paul on 9 Jul 2020
I want a cell to change colour on 15 characters in Excel 2010 - Stack Overflow
Select the cell Go to Home tab From Conditional Formatting choose Highlight Cell Rules > More Rules Select Use a formula to determine which cells to format Write =LEN($A1)>=15 as formula and select format (change colors etc.)
Saved by: Paul on 29 Jun 2020
mysql - PHP - Using PDO with IN clause array - Stack Overflow
This seems the most relevant bit... $arr = [1,2,3]; $in = str_repeat('?,', count($arr) - 1) . '?'; $sql = "SELECT * FROM table WHERE foo=? AND column IN ($in) AND bar=? AND baz=?"; $stm = $db->prepare($sql); $params = array_merge([$foo], $arr, [$bar, $baz]); $stm->execute($params); $data = $stm->fetchAll(); ... although I ended up doing the IN with a straight list as I could be sure the items in the list were clean.
Saved by: Paul on 19 Jun 2020
Video on De-duplicating spreadsheets in OpenOffice
Highlight the column with the data in that needs de-duplicating. Data > Filter > Standard Filter > Choose column, Value: - not empty - Open "More Options" Choose "No duplication" Click "OK" Highlight all data and copy to another spreadsheet
Saved by: Paul on 11 Jun 2020
Using Statamic as a CMS alongside a Laravel App
Elliot's article about setting up Statamic within an existing Laravel app - will be useful for me to do on a couple of projects
Saved by: Paul on 5 Jun 2020
