jfogel (6/13/2014)
Tell them it is a report. If they want a work of fiction they should call Stephen King.
I am so using this line:laugh:
@BWFC
I actually had this conversation a few weeks ago. A little background. We had a department that was using some unknown method of data collection for the last 7 years it was then inputted into excel sheets. I standardized it, created a method for data capture from clients, showed them how to enter via the application. 3 months go by and they want to see how this new method is working.
Me: Here's your first report on the new method, please look it over.
Them: hmm, nice it looks pretty and clean.
Me: Thanks
Them: But there is one major problem
Me: What's that?
Them: These numbers don't match our baseline numbers for the last 7 years. They look much better for us. I think this may raise a red flag with our funders.
Me:??? Well, I'm confused how were you getting your numbers before.
Them: Well we would ask the manager how many people came in, she gave us a educated guess on what she thought she saw for the day. We then put that into a spread sheet and applied a formula.
Me: Formula? What does the formula do?
Them: We aren't really sure? But it gives us our numbers we use.
Me: So you are confused why hard data entry and retrieval with methods of integrity is not matching 7 years of guessing with a mystery excel sheet formula.
ME: Hmmmm, not sure I will be able to answer this one.:hehe:
Them: yeah, I know it doesn't make sense does it.
***SQL born on date Spring 2013:-)