by Oz du Soleil | Dec 2, 2013 | Data Integrity, Data Management, Excel Geekdom, Spreadsheet Development, Spreadsheet Tidiness
October 2012, I posted a mild complaint about the ability to build a calculator in Excel and then publish online via ExcelWebApp. The Excel piece was easy. The WebApp piece was disappointing but was infinitely better than Google’s version. Yesterday a friend...
by Oz du Soleil | Aug 27, 2013 | Spreadsheet Development
BFTBY: Blogging From The Backyard This weekend a friend asked me to take a look at her spreadsheet for a bit of manicure and polish. When I received the document, it was beautiful. So, the polish that I had was easy to apply. I can’t share the data with you...
by Oz du Soleil | May 17, 2013 | Data Management, Spreadsheet Development, Tips
There are no fancy Excel stunts here. These are 6 simple pointers that escape the Excel tutorials. Like anything that’s done well, there are personal habits that quietly develop to keep you focused or avoid traps. I wasn’t aware of my own habits until I...
by Oz du Soleil | Apr 29, 2013 | Case Studies, Data Management, Data Management for Nonprofits, Spreadsheet Development
NONPROFIT FUNDRAISING: PART 2 In my previous blogpost, Nonprofit Fundraising: The Cost of $1, we looked at a fundraising campaign that generated $2026.02 after laying out $1099 in expenses for a net gain of $927.02; and we determined that it cost 54¢ to raise every...
by Oz du Soleil | Apr 26, 2013 | Data Management, Data Management for Nonprofits, Spreadsheet Development, Tips
Nonprofits, by their definition, are primarily funded by the public. That means they’re always fundraising. It helps a nonprofit to know: How much did it cost to raise $1? Nonprofit fundraising can get complex, time-consuming and expensive, sometimes...
by Oz du Soleil | Mar 9, 2013 | Data Integrity, Data Management, Spreadsheet Development
There was a steel smelter in my hometown. He was a tall, solid block of quiet energy. When asked about his occupation he’d hiss with deliberate bravado: “I work with fire” The way he emphasized “fire” conveyed his passion...