Skip site navigation (1) Skip section navigation (2)

Re: Any Excel Experts

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: PDX PostgreSQL Users <pdxpug(at)postgresql(dot)org>
Subject: Re: Any Excel Experts
Date: 2011-05-05 22:48:03
Message-ID: alpine.LNX.2.00.1105051542150.16080@salmo.appl-ecosys.com (view raw or flat)
Thread:
Lists: pdxpug
On Thu, 5 May 2011, David E. Wheeler wrote:

> We're looking for someone who lives and breathes Microsoft Excel to
> detangle a large collection of worksheets and work it into a more
> generalizable format for publication as part of an environmental open data
> project. We're talking 5-6 years of data collected willy-nilly into 120
> worksheets and held together with links, formulas, and duct tape. The
> ideal candidate will be:

Hey, David!

   I suspect you'll not find anyone with those qualifications. My limited
experience with environmental data in spreadsheets is that those who use a
spreadsheet rather than a database have no clues what they're doing. I spent
several weeks extracting permit compliance monitoring data for one year, and
didn't get all of it yet. There are about 30 more years to go. Yuck!

   What you ought to consider is someone who knows grep, sed, and awk and can
apply those to data exported from Excel as .csv, one per tab/spreadsheet.
Then you can concatenate the data in a uniform format and put them in a
spreadsheet or database for the project. Perhaps someone in India for either
direct Excel tweaking or exported data tweaking?

   I won't do it because you'd not have the budget for the hours required and
I have other project priorities that are more fun and satisfying.

Good luck in your search,

Rich

In response to

Responses

pdxpug by date

Next:From: Rich ShepardDate: 2011-05-05 23:35:52
Subject: Migrating Data from MySQL to PostgreSQL
Previous:From: David E. WheelerDate: 2011-05-05 22:20:22
Subject: Any Excel Experts

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group