• 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:-)