I would be interested as well.

Heather Daniels
UW-Madison

----- Original Message -----
From: "Avery, Sonja" <xxxxxx@UNF.EDU>
Date: Friday, August 21, 2009 7:42 am
Subject: Re: [RESADM-L] Organizing Information for Internal Grant Competitions
To: xxxxxx@hrinet.org

> I am also interested.
>
> __________________________________________________
>
> Sonja Y. Avery
> Research Development Coordinator
> Office of Research and Sponsored Programs
> University of North Florida
> 1 UNF Drive
> Jacksonville, FL 32224
> Ph 904-620-2456
> Fax 904-620-2457
> xxxxxx@unf.edu <
>
>
>
>
>
> From: Research Administration List [mailto:xxxxxx@hrinet.org] On
> Behalf Of Ann Laura Walker
> Sent: Thursday, August 20, 2009 12:45 PM
> To: xxxxxx@hrinet.org
> Subject: Re: [RESADM-L] Organizing Information for Internal Grant Competitions
>
>
>
> I'm interested as well.
>
>
>
> Thank you all so much
>
> LAura
>
>
>
>
>
> >>> On Thursday, August 20, 2009 at 12:37, in message
> 20670-1191519001, Maldve Regina<xxxxxx@MAIL.UTEXAS.EDU> wrote:
>
> Would it be possible to get a template of your database?
>
>
>
> Thanks.
>
>
>
> Regina Maldve, Ph.D., CRA
>
> Sr. Grants and Contracts Specialist
>
> Office of the Associate Dean for Research and Graduate Studies
>
> The University of Texas at Austin
>
> College of Pharmacy
>
> (512) 232-7511
>
>
>
>
>
>
>
>
>
> On Aug 20, 2009, at 9:45 AM, Taylor, Amy wrote:
>
>
>
>
>
> Last year my team and I designed an access database to track all the
> information related to grant activity in our healthcare system (15
> hospitals) – including sponsor and recurring opportunity information –
> all grant application activity, awards and financial tracking to
> support the real time detail our corporate accounting software could
> not provide on encumbrances. The relational table structure of the
> database is very flexible, the query and reporting capabilities allow
> us to design dozens of reports to track activity by hospital,
> department, grant manager, expense code, sponsor, etc., just about any
> detail we might want to track, now or in the future. Data entry is
> easy using a form layout (which can be accessed via the web for remote
> data entry).   The reporting capability allows us to track upcoming
> deadlines by month and person, so that work loads can be adjusted as
> necessary.  We can produce immediate reports for our project directors
> to show the status of their applications (such as which submissions
> are still pending a sponsor decision) and financial reports on active
> applications. And if we can’t get it in an existing report format, we
> can query and download info to excel with ease for more strenuous data
> analysis if necessary.
>
> While I do like excel for many things, and was a bit of a skeptic at
> first, I honestly have found that Access more than meets our
> application tracking and reporting needs for now.
>
> Amy L. Taylor
>
> Corporate Director, Grants & Awards, Mountain States Health Alliance
>
> Office: 423-854-5944
>
> ________________________________
>
> From: Research Administration List [mailto:xxxxxx@hrinet.org] On
> Behalf Of Cappellucci, James E.
> Sent: Thursday, August 20, 2009 9:52 AM
> To: xxxxxx@hrinet.org
> Subject: Re: [RESADM-L] Organizing Information for Internal Grant Competitions
>
>   We recently went to an access database, and it is not terribly
> flexible. Excel is better, but for the reasons you cited we moved away
> from it.
>
>   The model I would like to see in place is that each individual keep
> their own work log in excel. The work logs have some standard columns
> with information that we'd all need & this enables merging/copying the
> data. The reasons for this is that it tracks the administrators work
> to see what is coming up, what is work in process & what has been
> completed. This is also an effective management tool. managers would
> review the logs on a weekly basis to assist in not only managing
> workloads but also measure productivity. This is only one means of
> measurement. though; Some items take longer than others to complete,
> an admin might have a strong departmental person preparing the
> application while another admin has a weak person, etc...  This is
> just not a business where you can apply an assembly line approach to everything.
>
> ________________________________
>
> From: Research Administration List [mailto:xxxxxx@hrinet.org] On
> Behalf Of Ann Laura Walker
> Sent: Thursday, August 20, 2009 9:22 AM
> To: xxxxxx@hrinet.org
> Subject: [RESADM-L] Organizing Information for Internal Grant Competitions
>
> Good Morning,
>
> I'm trying to make my life a little bit easier (aren't we all) for our
> upcoming internal grant competition and I was wondering if y'all could
> share with me how you organize the various kinds of information you'll
> need during the competition? Do you put things into an Access
> Database? I suggest that because I use excel and the worksheet just
> gets TOO BIG by the end.
>
> Any kinds of suggestions will be appreciated.
>
> Laura
>
>
>
> The information in this e-mail is intended only for the person to whom
> it is
> addressed. If you believe this e-mail was sent to you in error and the
> e-mail
> contains patient information, please contact the Partners Compliance
> HelpLine at
> http://www.partners.org/complianceline . If the e-mail was sent to you
> in error
> but does not contain patient information, please contact the sender
> and properly
> dispose of the e-mail.
>
> ======================================================================
> Instructions on how to use the RESADM-L Mailing List, including
> subscription information and a web-searchable archive, are available
> via our web site at http://www.hrinet.org (click on "Listserv Lists")
> ======================================================================
>
>
> === MSHA Communications Disclaimer ===
> This message is from Mountain States Health Alliance. The contents
> contained herein may contain confidential information. If you are not
> the intended recipient, you are hereby notified that any disclosure,
> copying, distribution, printing or action taken on the contents is
> strictly prohibited. If you have received this email in error, please
> notify the sender immediately and delete this message. =====================================================
>
> ======================================================================
> Instructions on how to use the RESADM-L Mailing List, including
> subscription information and a web-searchable archive, are available
> via our web site at http://www.hrinet.org (click on "Listserv Lists")
> ======================================================================
>
>
>
> ======================================================================
> Instructions on how to use the RESADM-L Mailing List, including
> subscription information and a web-searchable archive, are available
> via our web site at http://www.hrinet.org (click on "Listserv Lists")
> ======================================================================
>
>

======================================================================
 Instructions on how to use the RESADM-L Mailing List, including
 subscription information and a web-searchable archive, are available
 via our web site at http://www.hrinet.org (click on "Listserv Lists")
======================================================================