I recently had an exercise where I needed to extract all the text from an OmniGraffle document. The task at hand was to check a beautifully designed organisation chart against a spreadsheet list of staff. Doing this task manually was going to take … [Read more...] about OmniGraffle API: Get Text Data From Shapes
Blog
Python: Empty String To INT
To convert a string to an integer you use the handy int() function. For example, if you have a string such as "79" and you insert this like so into the int() function: int("79") you get the result 79. But what happens when you don't have a string … [Read more...] about Python: Empty String To INT
Google Sheets: IF Statement Multiple Conditions
One of the first formulas I started with when exploring more about the functionality of spreadsheets is the IF formula. The IF formula is easy to understand and contains only three parameters which are all required. The first parameter is the … [Read more...] about Google Sheets: IF Statement Multiple Conditions
How To Check If Cell Is Empty (Or Not): Google Sheets
How do you check if a cell is empty or blank in Google Sheets? There is a handy function called ISBLANK which enables you to check if a cell is empty. What Does Empty Really Mean? In Google Sheets there are two ways of having an empty cell, … [Read more...] about How To Check If Cell Is Empty (Or Not): Google Sheets
What Is The Formula To Calculate Age?
Recently, I had an issue where I needed to calculate the age of a person at specific dates throughout the year. Using a Google Sheet, I thought I could simply subtract one date from the other and divide by 365, but this ended up not being as accurate … [Read more...] about What Is The Formula To Calculate Age?
How To Flatten A List Of Lists In Python (Examples & No Imports)
Recently, I had an exercise where I needed to flatten a two-dimensional list down to just one dimension, something where I needed the result to be like this: There were a couple of ways I completed this task, one involved using the common … [Read more...] about How To Flatten A List Of Lists In Python (Examples & No Imports)