by Oz du Soleil | Jun 18, 2012 | Case Studies, Data Integrity, Excel Geekdom, Screencast, Spreadsheet Tidiness, Tips
This project has a lot of pieces and resulted in something fun and challenging for me but also something quite valuable for the client. A key piece in the success was an Excel User form. Here’s a photo of me in actual battle with the Exceltopus that we roused...
by Oz du Soleil | May 13, 2012 | Case Studies
Client Challenge: A client was struggling with a recurring nine-variable calculation that helped them determine the services they could provide and for how long. Calculation Variables Fixed allotment amount Deductible Hourly rate of Therapy 1 Hourly rate of Therapy 2...
by Oz du Soleil | May 8, 2012 | Case Studies
This client was charged with evaluating Requests-for-Proposals (RFPs) as his company prepared to make a $3.5M/year decision. Over his 14 years in his industry, he knew which questions to ask and how to analyze the responses. The challenge: Presenting text answers and...
by Oz du Soleil | May 1, 2012 | Case Studies, Data Integrity, Data Management, Tips
Who’s the Data Boss? Anyone? As a Data Mercenary, I’ve seen a lot. One thing that has regularly come up: disconnects in Data Governance which result in a lot of people feeling pain within and outside of the business, and confusion about who’s...
by Oz du Soleil | Apr 21, 2012 | Case Studies, Excel Geekdom, Spreadsheet Development, Spreadsheet Tidiness, Tips
The following isn’t meant to be a “how-to.” This is designed to quickly show how we got over a challenge faced by a client who didn’t think that there was a simple solution. Have a look. Maybe this will inspire you to think about ways that your...
by Oz du Soleil | Apr 21, 2012 | Case Studies, Data Integrity, Data Management
One challenge in Data Governance is ensuring that business rules are accurately reflected in your processes, reports, queries and spreadsheet formulae. A critical element is anticipation of the strange things that might happen that would cause false positives and...
