Amy, I am interested, too! Jaynee Tolle Sr. Grant Administrator Department of Psychiatry University of Cincinnati (513) 558-1453 -----Original Message----- From: Research Administration List [mailto:xxxxxx@hrinet.org] On Behalf Of HEATHER M DANIELS Sent: Friday, August 21, 2009 12:39 PM To: xxxxxx@hrinet.org Subject: Re: [RESADM-L] Organizing Information for Internal Grant Competitions 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") ====================================================================== ====================================================================== 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") ======================================================================
