• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Identify a Bad Meter Reading

charlestonpaul

New Member
Hi Guys,

I have a list of meters with the date of the meter reading and the value. I need to identify a bad meter reading so that it can be scrubbed. The reading may be too much or too little.


Reading

Meter # Date Meter

117 5/29/2009 668,597

117 6/17/2009 671,072

117 6/25/2009 11,080,553 Bad

117 7/8/2009 674,063

117 7/16/2009 690,347


154 7/10/2009 865,276

154 7/15/2009 868,855

154 7/23/2009 539,551 Bad

154 7/24/2009 882,304

154 7/31/2009 892,191


Any help would be greatly appreciated!!
 

keymaster

New Member
are you trying to find the outliers in the meter reading? you can then use percentile formula to see if the meter reading is in first 10 or last 10 percentile and highlight it.
 
Top