Articles

Sharing functions across Google Sheets

Earlier, I wrote about how to create a custom function in Google Sheets.  However, have you ever wanted to use that function in a completely different Google Sheet?  Turns out, it just does not magically work.  Instead, you must create a separate web app, then bring...

Digging into Google Sheets with custom functions

I had a case where I wanted to subtract the corporate tax from a gross profit.  If you are familiar with taxes, you might realize that it is not as simple as taking a percentage and calling it a day.  Instead, you must pay a certain percentage of tax on profit up to a...

First impressions of using Google Sheets

Not bad.  Certainly not as robust as the Microsoft desktop counterparts, but pretty awesome.  I'm now using Sheets to perform financial analysis and after some tinkering and digging today, I feel that I am a moderate level of comfort (which is about where I was with...

Recently, I was writing a number of job descriptions - some I could easily write since they revolved around my own expertise.  However, for the ones that I did not understand nearly as well, I went searching for some examples as inspiration and came across a site from...

Backing up Confluence

Recently started using Confluence as the wiki of choice - wow, that was an adventure I should probably write an article on.  To backup the entire Confluence Site (i.e. all Spaces), click Cog >> General Configuration >> Backup Manager.  From here, ensure...

Prevent Heroes of the Storm from minimizing

I'm a casual player of Heroes of the Storm.  Recently, the game kept kicking me out to the desktop.  The game appears to have a display issue because it flickers while loading, but then ends up back at the desktop.  Blizzard has not provided a solution to the actual...