ROWNo.|| COLUMNNAME || COLUMNNo.|| MESSAGE ------------------------------------------------------------------------------------------------------------ 2 || KVAH || 4 ||Consumer ID 1000345231 : KVAH cannot be smaller than the KWH entered 447481.71 ------------------------------------------------------------------------------------------------------------------------------------- 2 || KWH || 2 ||Consumer ID 1000345231 : KWH Consumption 166881.96 cannot be greater than the KVAH Consumption 131374.8 ------------------------------------------------------------------------------------------------------------- 3 || KVAH || 4 ||Consumer ID 1000345240 : KVAH cannot be smaller than the existing KVAH 260571.3 ------------------------------------------------------------------------------------------------------------ 3 || KVAH || 4 ||Consumer ID 1000345240 : KVAH cannot be smaller than the KWH entered 273853.86 ------------------------------------------------------------------------------------------------------------------------------------- 3 || KWH || 2 ||Consumer ID 1000345240 : KWH Consumption 522309.1 cannot be greater than the KVAH Consumption -273112.7 ----------------------------------------------------------------------------------------------------------- 4 || KVAH || 4 ||Consumer ID 1000345245 : KVAH cannot be smaller than the existing KVAH 839.64 --------------------------------------------------------------------------------------------------------- 4 || KVAH || 4 ||Consumer ID 1000345245 : KVAH cannot be smaller than the KWH entered 883.52 ------------------------------------------------------------------------------------------------------------------------------- 4 || KWH || 2 ||Consumer ID 1000345245 : KWH Consumption 8824 cannot be greater than the KVAH Consumption -2133.6 -------------------------------------------------------------------------------------------------------------- 5 || KVAH || 4 ||Consumer ID 1000345246 : KVAH cannot be smaller than the existing KVAH 385171.36 ------------------------------------------------------------------------------------------------------------ 5 || KVAH || 4 ||Consumer ID 1000345246 : KVAH cannot be smaller than the KWH entered 422704.44 --------------------------------------------------------------------------------------------------------------------------------------- 5 || KWH || 2 ||Consumer ID 1000345246 : KWH Consumption 378431.07 cannot be greater than the KVAH Consumption -179230.71 ----------------------------------------------------------------------------------------------------------- 6 || KVAH || 4 ||Consumer ID 1000345258 : KVAH cannot be smaller than the existing KVAH 445000 ------------------------------------------------------------------------------------------------------------ 6 || KVAH || 4 ||Consumer ID 1000345258 : KVAH cannot be smaller than the KWH entered 454401.12 ------------------------------------------------------------------------------------------------------------------------------------- 6 || KWH || 2 ||Consumer ID 1000345258 : KWH Consumption 523762.4 cannot be greater than the KVAH Consumption -150938.4 ------------------------------------------------------------------------------------------------------------ 7 || KVAH || 4 ||Consumer ID 1000345260 : KVAH cannot be smaller than the KWH entered 273977.75 -------------------------------------------------------------------------------------------------------------------------------------------- 7 || KWH || 2 ||Consumer ID 1000345260 : KWH Consumption 755839.2 cannot be greater than the KVAH Consumption 11603.9999999997 -------------------------------------------------------------------------------------------------------------- 8 || KVAH || 4 ||Consumer ID 1000345261 : KVAH cannot be smaller than the existing KVAH 183858.64 ------------------------------------------------------------------------------------------------------------ 8 || KVAH || 4 ||Consumer ID 1000345261 : KVAH cannot be smaller than the KWH entered 190517.93 -------------------------------------------------------------------------------------------------------------------------------------- 8 || KWH || 2 ||Consumer ID 1000345261 : KWH Consumption 247381.92 cannot be greater than the KVAH Consumption -14057.46 ------------------------------------------------------------------------------------------------------------- 9 || KVAH || 4 ||Consumer ID 1000345267 : KVAH cannot be smaller than the existing KVAH 48321.48 ----------------------------------------------------------------------------------------------------------- 9 || KVAH || 4 ||Consumer ID 1000345267 : KVAH cannot be smaller than the KWH entered 50359.45 ------------------------------------------------------------------------------------------------------------------------------------- 9 || KWH || 2 ||Consumer ID 1000345267 : KWH Consumption 34781.34 cannot be greater than the KVAH Consumption -28109.34 ----------------------------------------------------------------------------------------------------------- 10 || KVAH || 4 ||Consumer ID 1000345282 : KVAH cannot be smaller than the existing KVAH 4214.9 ---------------------------------------------------------------------------------------------------------- 10 || KVAH || 4 ||Consumer ID 1000345282 : KVAH cannot be smaller than the KWH entered 4491.85 --------------------------------------------------------------------------------------------------------------------------------- 10 || KWH || 2 ||Consumer ID 1000345282 : KWH Consumption 80316.6 cannot be greater than the KVAH Consumption -51240 ------------------------------------------------------------------------------------------------------------ 11 || KVAH || 4 ||Consumer ID 1000345283 : KVAH cannot be smaller than the KWH entered 296759.73 -------------------------------------------------------------------------------------------------------------------------------------------- 11 || KWH || 2 ||Consumer ID 1000345283 : KWH Consumption 212015.4 cannot be greater than the KVAH Consumption 49102.1999999997 ------------------------------------------------------------------------------------------------------------ 12 || KVAH || 4 ||Consumer ID 1000345284 : KVAH cannot be smaller than the existing KVAH 98385.5 ----------------------------------------------------------------------------------------------------------- 12 || KVAH || 4 ||Consumer ID 1000345284 : KVAH cannot be smaller than the KWH entered 103340.1 ------------------------------------------------------------------------------------------------------------------------------------ 12 || KWH || 2 ||Consumer ID 1000345284 : KWH Consumption 32901.93 cannot be greater than the KVAH Consumption -3559.17 ---------------------------------------------------------------------------------------------------------- 13 || KVAH || 4 ||Consumer ID 1000345287 : KVAH cannot be smaller than the KWH entered 50510.2 ------------------------------------------------------------------------------------------------------------------------------------------ 13 || KWH || 2 ||Consumer ID 1000345287 : KWH Consumption 393852 cannot be greater than the KVAH Consumption 77977.7999999998 ---------------------------------------------------------------------------------------------------------------------------------------------- 14 || CONSUMER_ID || 1 ||Consumer Id 1000345292 belong to BS is not allowed for bulk billing. Excluded category - BPL(UM),PL(UM),BS,CCTV ----------------------------------------------------------------------------------------------------------- 14 || KVAH || 4 ||Consumer ID 1000345292 : KVAH cannot be smaller than the KWH entered 5002.981 ------------------------------------------------------------------------------------------------------------------------------------------- 14 || KWH || 2 ||Consumer ID 1000345292 : KWH Consumption 5510.82 cannot be greater than the KVAH Consumption 566.939999999995 -------------------------------------------------------------------------------------------------------------- 15 || KVAH || 4 ||Consumer ID 1000345299 : KVAH cannot be smaller than the existing KVAH 309437.42 ----------------------------------------------------------------------------------------------------------- 15 || KVAH || 4 ||Consumer ID 1000345299 : KVAH cannot be smaller than the KWH entered 322095.4 --------------------------------------------------------------------------------------------------------------------------------------- 15 || KWH || 2 ||Consumer ID 1000345299 : KWH Consumption 262528.02 cannot be greater than the KVAH Consumption -117369.72 -------------------------------------------------------------------------------------------------------------- 16 || KVAH || 4 ||Consumer ID 1000345301 : KVAH cannot be smaller than the existing KVAH 422327.27 ------------------------------------------------------------------------------------------------------------ 16 || KVAH || 4 ||Consumer ID 1000345301 : KVAH cannot be smaller than the KWH entered 446355.65 -------------------------------------------------------------------------------------------------------------------------------------- 16 || KWH || 2 ||Consumer ID 1000345301 : KWH Consumption 378512.04 cannot be greater than the KVAH Consumption -97943.22 ------------------------------------------------------------------------------------------------------------ 17 || KVAH || 4 ||Consumer ID 1000345307 : KVAH cannot be smaller than the KWH entered 707645.22 -------------------------------------------------------------------------------------------------------------------------------------------- 17 || KWH || 2 ||Consumer ID 1000345307 : KWH Consumption 165034.5 cannot be greater than the KVAH Consumption 23760.6299999999 ------------------------------------------------------------------------------------------------------------ 18 || KVAH || 4 ||Consumer ID 1000345333 : KVAH cannot be smaller than the existing KVAH 4754.54 ---------------------------------------------------------------------------------------------------------- 18 || KVAH || 4 ||Consumer ID 1000345333 : KVAH cannot be smaller than the KWH entered 5187.93 ----------------------------------------------------------------------------------------------------------------------------------- 18 || KWH || 2 ||Consumer ID 1000345333 : KWH Consumption 60087.9 cannot be greater than the KVAH Consumption -38645.4 ------------------------------------------------------------------------------------------------------------ 19 || KVAH || 4 ||Consumer ID 1000345336 : KVAH cannot be smaller than the KWH entered 938520.29 ------------------------------------------------------------------------------------------------------------------------------------ 19 || KWH || 2 ||Consumer ID 1000345336 : KWH Consumption 3544407 cannot be greater than the KVAH Consumption 2653769.4 ----------------------------------------------------------------------------------------------------------- 20 || KVAH || 4 ||Consumer ID 1000345319 : KVAH cannot be smaller than the KWH entered 11499.48 ------------------------------------------------------------------------------------------------------------------------------------ 20 || KWH || 2 ||Consumer ID 1000345319 : KWH Consumption 284659.2 cannot be greater than the KVAH Consumption 132388.8 ------------------------------------------------------------------------------------------------------------ 21 || KVAH || 4 ||Consumer ID 1000600006 : KVAH cannot be smaller than the existing KVAH 6518.71 ---------------------------------------------------------------------------------------------------------- 21 || KVAH || 4 ||Consumer ID 1000600006 : KVAH cannot be smaller than the KWH entered 6776.16 ------------------------------------------------------------------------------------------------------------------------------------- 21 || KWH || 2 ||Consumer ID 1000600006 : KWH Consumption 154849.6 cannot be greater than the KVAH Consumption -119566.4 -------------------------------------------------------------------------------------------------------------- 22 || KVAH || 4 ||Consumer ID 1000617099 : KVAH cannot be smaller than the existing KVAH 244489.13 ------------------------------------------------------------------------------------------------------------ 22 || KVAH || 4 ||Consumer ID 1000617099 : KVAH cannot be smaller than the KWH entered 259715.36 ------------------------------------------------------------------------------------------------------------------------------------- 22 || KWH || 2 ||Consumer ID 1000617099 : KWH Consumption 112247.92 cannot be greater than the KVAH Consumption -57773.6 ----------------------------------------------------------------------------------------------------------- 23 || KVAH || 4 ||Consumer ID 1000841335 : KVAH cannot be smaller than the KWH entered 51281.88 ------------------------------------------------------------------------------------------------------------------------------------ 23 || KWH || 2 ||Consumer ID 1000841335 : KWH Consumption 372412.8 cannot be greater than the KVAH Consumption 308651.4 ----------------------------------------------------------------------------------------------------------- 24 || KVAH || 4 ||Consumer ID 1000868939 : KVAH cannot be smaller than the KWH entered 47749.38 ----------------------------------------------------------------------------------------------------------------------------------- 24 || KWH || 2 ||Consumer ID 1000868939 : KWH Consumption 63832.08 cannot be greater than the KVAH Consumption 55761.3 --------------------------------------------------------------------------------------------------------- 25 || CONSUMER_ID || 1 ||Consumer ID 2213000027 : does not belong to your location --------------------------------------------------------------------------------------------------------- 25 || KVAH || 4 ||Consumer ID 2213000027 : KVAH cannot be smaller than the KWH entered 3908.1 ---------------------------------------------------------------------------------------------------------------------------------- 25 || KWH || 2 ||Consumer ID 2213000027 : KWH Consumption 18570.9 cannot be greater than the KVAH Consumption 12621.3 ------------------------------------------------------------------------------------------------------------- 26 || KVAH || 4 ||Consumer ID 1000345230 : KVAH cannot be smaller than the existing KVAH 80420.83 ----------------------------------------------------------------------------------------------------------- 26 || KVAH || 4 ||Consumer ID 1000345230 : KVAH cannot be smaller than the KWH entered 87522.23 --------------------------------------------------------------------------------------------------------------------------------------------- 26 || KWH || 2 ||Consumer ID 1000345230 : KWH Consumption 92577.7799999999 cannot be greater than the KVAH Consumption -11459.22