Re: rcr : Ability to export SOVC to excel spreadsheet

One question: Would it suffice to give them a flat-file export of the SOVC that they could then import into Excel? They wouldn’t get the “SUM()” functions to actually tabulate the columns, rather it would just have the totals as numeric rows like all the others. But if you think about it do they really want the SUM() functions anyway? Depends really on what they want to use the spreadsheet for. Maybe tell us a bit about the motivation for the request.

Ken

-----Original Message-----
From: owner-rcr@dieboldes.com [mailto:owner-rcr@dieboldes.com] On Behalf Of Tari Runyan
Sent: Wednesday, April 24, 2002 2:05 PM
To: rcr@dieboldes.com
Subject: Re: rcr : Ability to export SOVC to excel spreadsheet

I will tell them we are investigating the possibilities and will keep them posted

Thanks

Tari

----- Original Message -----

From: Ken Clark

To: rcr@dieboldes.com

Sent: Wednesday, April 24, 2002 4:27 PM

Subject: RE: rcr : Ability to export SOVC to excel spreadsheet

You submitted this once before, though I can’t seem to find the follow up. It’s been requested a few other times as well, but the responses seem to predate the archive. The SOVC and Summary report are custom code, while the pre-election reports are generated by Crystal Reports. Crystal has built-in functionality for Excel export. GEMS doesn’t. Excel is a proprietary format, so it is not a “just do it” kind of request. There might be some libraries or toolkits available to do this – in fact I’m sure there are – but we haven’t done any research on this. It we can find such a toolkit it might not be too bad to implement. We’ll have a look and follow up as to whether this is doable by the October deadline. Don’t promise your accounts anything yet.

Ken

-----Original Message-----
From: owner-rcr@dieboldes.com [mailto:owner-rcr@dieboldes.com] On Behalf Of Tari Runyan
Sent: Wednesday, April 24, 2002 1:06 PM
To: rcr
Subject: rcr : Ability to export SOVC to excel spreadsheet

Submitted:     4/24/02    Tari Runyan

Requested by :     Santa Barbara

                            San Luis Obispo

                            other Ca accounts

Required:             Oct 1, 2002

Would like ability to export SOVC directly into Excel spreadsheet (like we do in Pre Election reports)

Have had many requests for this report in and editable format.