by Oz du Soleil | Nov 9, 2012 | How Tos and Q&As
QUESTION Here’s an example an example of Data Parsing in Excel. Phil sent in this challenge. He receives a report and it’s not useful the way it is. Often, these reports are generated for an executive to read. That same report gets turned over to an...
by Oz du Soleil | Oct 21, 2012 | Data Integrity, Data Management
Data Management Policies are one area for limiting crap data and related consequences. This is an aspect of Data Management that’s away from the doing inside the cells, formulae, queries, PHP coding and data fields. Why is this important? Why do businesses need...
by Oz du Soleil | Oct 17, 2012 | Case Studies, Data Management
In the past week Client-Developer Relationship topics have shown up a lot. You all know that I primarily focus on Data Management. Some of you also know that I also work on WordPress sites. Today’s blog post will matter to both clients and developers in Data...
by Oz du Soleil | Oct 15, 2012 | How Tos and Q&As
QUESTION Erika saw an Excel formula that started with: =+ What’s the deal? ANSWER Nothing. People who grew up with Lotus notes got into the habit of starting a formula with ‘+’ and they carried it over to Excel. What excel does with that is simply...
by Oz du Soleil | Oct 9, 2012 | Data Management, Excel Geekdom
UPDATE (2DEC13): ExcelWebApp continues to improve. They’ve added key validation features that didn’t exist when I originally published this blogpost in October 2012. See: App Development in Excel and Break-Even Calculator ♦♦♦ This was an unplanned blog...
