Here at the Rock, We Have Data Management Policies
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 data...
Client-Developer Relationship
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...
What is =+ in an Excel formula?
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 add '=' to...
Creating Online Calculators: a comparison
How do you get a calculation from the desktop to a custom online calculator? Here are 5 things I tried and 3 interactive examples.
Excel Interactive View 1: Analyze data in a webpage
Excel Interactive View is getting lots of attention because it allows basic data crunching within a webpage. See for yourself with live data!
Excel Interactive View 2: Sample Data
Here is a table of live data for you to explore Excel Interactive View, a new feature in Excel 2013.
RANT: Excel vs. Excel Alternatives
Developers of Excel Alternatives got my hackles up with their contempt of Excel. Here are 11 criteria for choosing the right tool … and my rant.
Marketers, Beware of Inviting Crap Data
Marketers roll out the red carpet for crap data when they require us to provide information that is good for them and not for users. Let’s discuss.
Excel Date Format is Inconsistent
QUESTION Keely is trying to merge 2 lists and the Excel date format is different between the 2 lists. List 1: Date and Time in one cell 3/14/2011 11:20 AM List 2: Date only 3/14/2011 What's the deal? ANSWER We can solve this formatting...
Data Transfer, Data Organization
This stood as the only time in 12 years that I almost accepted defeat. With 70% of the work done, the last 30% was excruciating. Summary The client was conducting a Data Transfer from one database to another. They successfully downloaded the data from the old database...
Dropdown Drama: Dependent & Dynamic Dropdown Lists
THREE people in the past 24 hours have had DROPDOWN DRAMA! But there are easy solutions. We just need to relax. QUESTION Cheryl maintains clean data, by using dropdown lists to control data entry. But there's a problem she describes: "Oh! I hate it when I make...
Fixed Decimal Places: Enter 300 and Excel shows a 3
QUESTION Cory has a puzzle: Why do I enter 300 and Excel turns it into 3? In order to get 300 I have to enter 30000 ANSWER This must feel like some kind of alien prank. Enter 300 and get 3 or Enter 2716 and get 27.16 WHAT'S THE FRIKKEN DEAL?? Excel has a...