Results 1 to 4 of 4

Thread: Importing Spreadsheets

  1. #1
    Newbie
    Join Date
    Jul 2005
    Posts
    4

    Thumbs up

    (I am not sure where to ask this question. I am thinking the Access forum would be better than Excel, but could be done in both.)

    I am working with 5 other people for an Architect, and I have designed separate bi-weekly time sheets in Excel. The spreadsheets are set up to calculate the time spent on each project a person does, vacation and holiday time, and then give a total at the bottom.

    Here's my questions: Is there anyway that Access or Excel can take a person's time and the client each person works on, and put it in a single spreadsheet to show how many hours each client has? For instance, 2 other co-workers are doing work on the same project I am, and the architect wants to know how much total time was spent for this client.

    What he really wants to see is column A list the job number; Column B list the client; Columns C - H be for the employees, and Column I be for the total times. Of course, down at the bottom of Columns C - H would be totals for each employee.

    Any ideas how this can be accomplished and which program (Access or Excel) would work best?

    Thank you in advance for your replies!
    Dan

  2. #2
    Senior Member RickDev's Avatar
    Join Date
    Jul 2005
    Location
    Melbourne, Florida
    Posts
    438
    Now my question is, can you setup a spot that each person can use the same spreadsheet or the same access database? Access would be a nice option, very flexible and easy to creat any kind of report that your client might need. But it would require that each person be able to use the same database. This can be done either through a share or maybe create a website where they can log in and enter the information.

    You don't NEED to access the same file, thought it is nice. You can look into importing data from one access database into another, or look into mergeing in excel. All depends on how each person can access the files.

    Post here or email/PM me if you want more details or may need some help on this. I will reply as quickly as I can. I have classes all next week but will reply when I get home.

    RickDev
    "Nobody knows what I do until I stop doing it."

    Florida Web Design | Online Geek Hangout | Office Pranks and Humor

  3. #3
    Newbie
    Join Date
    Jul 2005
    Posts
    4
    RickDev, Thank you for your quick reply. I think the following example spreadsheets: "Bi-weekly Report" and "Time Card" (click on the names) might help explain what we currently have. Each of these are not linked together.

    I would like to know more about your ideas of creating a website or accessing from a database.

    Any other thoughts or comments after viewing the Excel files?

    Dan

  4. #4
    Senior Member RickDev's Avatar
    Join Date
    Jul 2005
    Location
    Melbourne, Florida
    Posts
    438
    Does your website support PHP or ASP or anything to that nature? If so, you could use access as a backend database and then create a web interface that would allow people to enter their time and such.

    Without really sitting down and playing, I am not sure if there would be an easy way to link them. But like I said, I would need the time to just look at them which I don't right at this minute. I will look at them more when I get a chance.

    RickDev
    "Nobody knows what I do until I stop doing it."

    Florida Web Design | Online Geek Hangout | Office Pranks and Humor

Similar Threads

  1. Importing .csv contacts into Evolution
    By JoeyJoeJoe in forum Linux - Software, Applications & Programming
    Replies: 0
    Last Post: 05-05-2007, 03:01 PM
  2. Duplicate emails after importing pst
    By jonfa in forum Windows - General Topics
    Replies: 0
    Last Post: 08-04-2006, 09:06 AM
  3. Importing Spreadsheets
    By Dannoboone in forum Windows - General Topics
    Replies: 1
    Last Post: 07-24-2005, 04:11 PM
  4. Error Importing XML Files
    By regix in forum Windows - General Topics
    Replies: 0
    Last Post: 01-04-2005, 01:48 AM
  5. Importing old thunderbird e-mail
    By mcdougrs in forum Linux - Hardware, Networking & Security
    Replies: 3
    Last Post: 10-29-2004, 01:31 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •