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 30, 2012 | Excel Geekdom, Spreadsheet Tidiness, Tips
Have you written a complex formula or had to understand a long formula that someone else wrote? It can become a jungle of parentheses and commas. One simple tip: Use ALT+ENTER in the Formula Bar to Make Troubleshooting and Validation easier Here’s a...
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...
