1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: What's a good program

Discussion in 'Business Applications' started by toopay, Jan 14, 2006.

Thread Status:
Not open for further replies.
Advertisement
  1. toopay

    toopay Thread Starter

    Joined:
    Jun 7, 2003
    Messages:
    354
    I in need of a program to keep some church records information on each person how much they give and to wich department they give to. Any Ideas!
     
  2. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,658
    Excel or Access will do that for you, if you haven't already got one of them, then Open Office will also do it.
     
  3. toopay

    toopay Thread Starter

    Joined:
    Jun 7, 2003
    Messages:
    354
    Which one do think would be better for the task, I have Excel but the access. Would I have to make my own templates.
     
  4. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
    I would recommend one based off of what your needs are. Are you going to need to do many calculations with this record? Are you going to want to create dynamic reports from your data?

    It sounds like Access is the way to go, but I can't really be too sure until more information is obtained.
     
  5. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,445
    Just curious ... are there laws in the US covering who can hold what info on PCs about whom? In the UK, we have a Data Protection Act.
     
  6. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
    I don't know if there are any specific to data other than the privacy laws that are currently in place.
     
  7. toopay

    toopay Thread Starter

    Joined:
    Jun 7, 2003
    Messages:
    354
    Here is basic stuff that I would like to do. This was done in Excel.
    Jan-06 1-Jan 8-Jan 15-Jan 22-Jan 29-Jan TOTAL
    TITHES 0.00
    GENERAL 0.00
    MISSION 0.00
    SUNDAY SCHOOL 0.00
    BIBLE STUDY 0.00
    YPWW 0.00
    RADIO 0.00
    YOUTH 0.00
    CHILDREN 0.00
    BUS 0.00
    VSB 0.00
    WOMEN 0.00
    PASTOR AIDE 0.00
    BUILDING FUND 0.00
    MUSIC DEPT. 0.00
    LOVE OFFERING 0.00
    MEN 0.00
    OTHERS 0.00
    0.00
    TOTALS $0.00 $0.00 $0.00 $0.00 $0.00 0.00
     
  8. kiwiguy

    kiwiguy

    Joined:
    Aug 17, 2003
    Messages:
    17,584
    The big factor in the choice is, toopay, how many parishoners will it need to accommodate.

    If a few hunders or a thousand or so, Excel would be OK.

    If its tens of thousands, then no. You will need a database.
    Without that critical info, its guesswork.
     
  9. toopay

    toopay Thread Starter

    Joined:
    Jun 7, 2003
    Messages:
    354
    only 150. so I guess I we have to do each one at a time.
    thanks
     
  10. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,445
    Like I said, just curious ... over here, you have to register with an appointed agency to keep info which can be identified to specific individuals. & this now applies to paper records, not just computer ones. Maybe technically this could apply to someone keeping even an address book, tho' I guess there must be some kind(s) of exemption, else that would just be like total Big Brother! :eek:

    Anyways, a file is attached. I focussed on "each person how much they give and to wich department they give to". So Sheet1 is a table of donations, Sheet2 is a summary table using array formulas I cribbed from J-Walk.

    (Yeah I know everyone else uses SUMPRODUCT these days. What can I tell you? -- I'm retro. :D)

    The summary table only goes to donor 100 to keep the file size down, but the formulas can be copied down as far as needed.
     

    Attached Files:

  11. Squashman

    Squashman Trusted Advisor

    Joined:
    Apr 4, 2003
    Messages:
    19,783
  12. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Similar Threads - Solved What's program
  1. owlhootx
    Replies:
    2
    Views:
    184
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/433996

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice