Paid data coding/sorting project

CoRP

Well-Known Member
Lifetime Member
SoSH Member
Jan 15, 2007
9,457
The Epicenter
Wanna make some dough?  I have appx 2500 spreadsheets that I need to pull some data from into one fancy spreadsheet (database?).  Sound simple? It isn't. This data needs to be sorted and summed and the sort/sum isn't straightforward. In fact, I can't figure out a way to make it work in a macro. Also, each spreadsheet has it's date in it's file name, but not in the actual file and keeping the date with the data is critical.
 
I have done it by hand and it takes me about 90 seconds to do each spreadsheet.  So, manually it would take 60+ hours to do. PM me and tell me that there's a way to do this fast and guarantee the accuracy of the sort and calcs and we'll talk $.
 

CoRP

Well-Known Member
Lifetime Member
SoSH Member
Jan 15, 2007
9,457
The Epicenter
I'm starting to realize that if I could learn a language like perl, I could automate all the little BS stuff that I do manually every morning when I do my reconciliations and free up more time for drinking.
 
Suggestions on where to start learning it?
 

CoRP

Well-Known Member
Lifetime Member
SoSH Member
Jan 15, 2007
9,457
The Epicenter
Holy cow, I got a lot of PMs. Thanks everyone for all of the suggestions. I need to spend some time detailing what I want the output to look like. Should be later this weekend. I have someone to take an initial look at it, if he cant do it, I'll ask another one of you guys.  Really appreciate everyone reaching out so quickly. 
 

SumnerH

Malt Liquor Picker
Dope
Jul 18, 2005
25,880
Alexandria, VA
CoRP said:
I'm starting to realize that if I could learn a language like perl, I could automate all the little BS stuff that I do manually every morning when I do my reconciliations and free up more time for drinking.
 
Suggestions on where to start learning it?
 
You want Python, not Perl--it's a more sanely designed language that's both easier to learn and easier to maintain in large code bases (it's not without some merit that Perl is jokingly referred to as a write-only language).  There've been a bunch of threads on it here in the past; consensus is that Learn Python the Hard Way is a good place to start (there are other good places, but that's one).
 
You'd also want one of:
http://www.python-excel.org/
http://pythonhosted.org/openpyxl/
 

CoRP

Well-Known Member
Lifetime Member
SoSH Member
Jan 15, 2007
9,457
The Epicenter
I like that the guy that is directing me to the right language to learn so that I can free up more time for drinking is also the guy that can direct me to the right stuff to drink...
 

Bergs

Member
SoSH Member
Jul 22, 2005
12,992
If the layout is all standard, that would be a pretty simple VBA script.