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

Re: Any Excel Experts

From: Selena Deckelmann <selenamarie(at)gmail(dot)com>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Subject: Re: Any Excel Experts
Date: 2011-05-06 14:27:52
Message-ID: (view raw or whole thread)
Lists: pdxpug
(Bcc pdxpug)

Ok, this thread is done, Richard. Direct comments about the gig posting to
David, privately, folks.

Please, lets get back to talking about databases.

On May 6, 2011 6:03 AM, "Rich Shepard" <rshepard(at)appl-ecosys(dot)com> wrote:
> On Thu, 5 May 2011, David E. Wheeler wrote:
>>> I won't do it because you'd not have the budget for the hours required
>>> I have other project priorities that are more fun and satisfying.
>> You words fill me with joy. :-(
> David,
> I wasn't being flippant. I spent many days with this effort. It involved
> moving blocks of data around on a single page so everything was in one
> contiguous block, exporting each tab as a separate file, writing a python
> script or figuring out whether grep, sed, or awk could reformat the data,
> then trying to copy it into the postgres table and fixing the errors the
> dbms found.
> Many organizations have SOPs on written documents: format, style, word
> usage and so on. I don't know of any such organization that has defined
> standards for spreadsheet usage. People become familiar with spreadsheets
> when they become familiar with word processors (or shortly thereafter),
> databases are not taught in schools or colleges. A dbms is an engine that
> needs to be used in specific applications, it's not an icon on the Windows
> desktop that opens a screen for immediate use. It takes thought and
> understanding, and these are not sufficiently common.
> From your description the work will be very labor intensive and require
> someone who deeply understands the need and what has to be done with the
> displayed data to fulfill that need. That's why I suggested an overseas
> organization like those that used to be used for digitizing paper maps
> accurately and inexpensively.
> Years ago I had some map data conversion done at the medium-security
> prison in Salem. Getting that project going was in interesting experience
> since I'd never before been in a prison. But the guys did an excellent job
> and it was part of their rehabilitative training. Perhaps they have people
> who can do your data conversion. And, the people doing the work have
> else to do with their days and they're a higher class of prisoner in these
> programs than at the maximum security prisons.
> Rich
> --
> Sent via pdxpug mailing list (pdxpug(at)postgresql(dot)org)
> To make changes to your subscription:

In response to

pdxpug by date

Next:From: Melissa HollingsworthDate: 2011-05-06 22:49:53
Subject: May 19th meeting
Previous:From: Rich ShepardDate: 2011-05-06 13:02:44
Subject: Re: Any Excel Experts

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