6000 zeros...
well i dont think i would ever forget 31st March 2006....y? because that was the day i had put (typed) 6000 zeroes in an excel file :(....dont think any of those tough teachers in school would have put so many in the answer sheets of the students in their lifetime ;)
it was all because of the customer master record and the junk that came up while downloading it to excel...there were records for arnd 6000 customers here and i had to download them...check them...put them in a particular format and then send it to the users to confirm on the details...generally its only the format that would be provided but here i cudnt do it as there were 6 different tables to download the records and the query that i created wouldnt work as some tables dint have records for some customers...so i had to download from each table separately and then join them...
i did that in just one day....some 2 weeks back...but later when i checked i found out that some tables dint have details for some customers and i would have to match them separately....so there it started...i had been postponing it for sometime but then who else would do it...so i took it up on Thursday...and downloaded them
while downloading i had another problem....some places records for 2 customers would be at the same row...that was irritating...now i had to go back to the tables download only for them and then put them in the excel sheet...
and also some customer records were comfortably not taken into the excel file...i dint know why and no one arnd knew too...then i tried downloading it as a html file....now this was perfect...all the customers in the table were there in the file...but the problem was i would have to copy it and paste to an excel so that i cud match with records from other tables...well that was another headache...one table when downloaded as html came to be 45MB.....and cudnt paste it to an excel file...but the others were just fine...only that when copied to an excel file...2 rows got merged for one record....so the total number of rows came to be 12000 and odd...i had to de-merge all the rows and then delete the extra rows...
now y did i put those zeros....i tried deleting selecting a few empty rows...but that was taking a long time...so thot would fill them with something and then use filter to take them out and delete the rows...but then again the filter was not working after a few 100 rows....so had to do a sort and then delete....
so i entered 6000 and odd zeros and then sorted and deleted the rows...it took arnd 1/2 to do that...and the sound of the keys in the keyboard started to have a musical effect on me....i even tried getting a beat into it...just to keep myself from getting bored...
this cud have been done pretty easily using some tools in excel...but then cudnt get any expert in excel to help :(
watever....but yesterday was unforgetable...
it was all because of the customer master record and the junk that came up while downloading it to excel...there were records for arnd 6000 customers here and i had to download them...check them...put them in a particular format and then send it to the users to confirm on the details...generally its only the format that would be provided but here i cudnt do it as there were 6 different tables to download the records and the query that i created wouldnt work as some tables dint have records for some customers...so i had to download from each table separately and then join them...
i did that in just one day....some 2 weeks back...but later when i checked i found out that some tables dint have details for some customers and i would have to match them separately....so there it started...i had been postponing it for sometime but then who else would do it...so i took it up on Thursday...and downloaded them
while downloading i had another problem....some places records for 2 customers would be at the same row...that was irritating...now i had to go back to the tables download only for them and then put them in the excel sheet...
and also some customer records were comfortably not taken into the excel file...i dint know why and no one arnd knew too...then i tried downloading it as a html file....now this was perfect...all the customers in the table were there in the file...but the problem was i would have to copy it and paste to an excel so that i cud match with records from other tables...well that was another headache...one table when downloaded as html came to be 45MB.....and cudnt paste it to an excel file...but the others were just fine...only that when copied to an excel file...2 rows got merged for one record....so the total number of rows came to be 12000 and odd...i had to de-merge all the rows and then delete the extra rows...
now y did i put those zeros....i tried deleting selecting a few empty rows...but that was taking a long time...so thot would fill them with something and then use filter to take them out and delete the rows...but then again the filter was not working after a few 100 rows....so had to do a sort and then delete....
so i entered 6000 and odd zeros and then sorted and deleted the rows...it took arnd 1/2 to do that...and the sound of the keys in the keyboard started to have a musical effect on me....i even tried getting a beat into it...just to keep myself from getting bored...
this cud have been done pretty easily using some tools in excel...but then cudnt get any expert in excel to help :(
watever....but yesterday was unforgetable...
posted by Sara at 2:08 AM
4 Comments:
6000 Zeros..cool :)
expert on excel? dude u cud have called ur manager after all what are they for only making docs, xls sheets and presentations..
hello
slow down there. and take it easy.
did u read what u wrote? :)
and i know excel can be messy when it comes to big data management. next time, try me. really! email me your Q and i will try and give u an easy solution. just believe that in excel, there is always a better way do get the job done :)
chill now.
abhinav - well my manager dint know...:(
koi - hi...thanx, i shall surely mail u next time :)
i DEMAND an UPDATE
Post a Comment
<< Home