+ Reply to Thread
Results 1 to 3 of 3

[SOLVED] Three Dimensions?

  1. #1
    Charminster Developments
    Guest

    [SOLVED] Three Dimensions?

    I am trying to use excel to enter information for each employee in a building
    company according to where they have worked each day, and how many hours at
    each location. The problem being I am not quite sure if I should or even can
    use excel for this. Say on a Monday an employee did three hours at one
    location, 5 at another and two at a third. How can I have a viable way of
    entering informtion on one day which could have one through say 15 items of
    data, totaling the hours altogether, and also totalling the hours for each
    day, and for each location.

    Although I am a new user, I do have a computer background. Any help would be
    greatly appreciated.

    Gary, Charminster Developments Ltd.

  2. #2
    Tushar Mehta
    Guest

    Re: Three Dimensions?

    The easiest and most useful way to store this information would be in a
    table with each column along the lines of
    EmployeeID, Date, StartTime, Duration (or EndTime) LocationID, TaskID

    How data are entered into the table depends on how easy you want to make
    the task. The simplest approach would be to just add data in a new row
    in the worksheet. You could also use XL's built-in Data| Form... or
    John Walkenbach's enhanced version that you will find at www.j-walk.com.
    Finally, you could create your user userform for the job.

    This, of course, presumes you can store the information in XL. You may
    also want to consider a program like MS Access. In addition to being a
    real database program (better integrity checks of the data, real
    relationships between tables, etc.) it also supports multiple concurrent
    users.

    --
    Regards,

    Tushar Mehta
    www.tushar-mehta.com
    Multi-disciplinary business expertise
    + Technology skills
    = Optimal solution to your business problem
    Recipient Microsoft MVP award 2000-2005

    In article <[email protected]>, =?Utf-
    8?B?Q2hhcm1pbnN0ZXIgRGV2ZWxvcG1lbnRz?= <Charminster
    [email protected]> says...
    > I am trying to use excel to enter information for each employee in a building
    > company according to where they have worked each day, and how many hours at
    > each location. The problem being I am not quite sure if I should or even can
    > use excel for this. Say on a Monday an employee did three hours at one
    > location, 5 at another and two at a third. How can I have a viable way of
    > entering informtion on one day which could have one through say 15 items of
    > data, totaling the hours altogether, and also totalling the hours for each
    > day, and for each location.
    >
    > Although I am a new user, I do have a computer background. Any help would be
    > greatly appreciated.
    >
    > Gary, Charminster Developments Ltd.
    >


  3. #3
    Charminster Developments
    Guest

    Re: Three Dimensions?

    Yes appreciated. That is useful. I think it is time to migrate this task to
    Access, which I have, a simple idea has become more complex than originally
    envisaged as more uses suggested themselves.

    "Tushar Mehta" wrote:

    > The easiest and most useful way to store this information would be in a
    > table with each column along the lines of
    > EmployeeID, Date, StartTime, Duration (or EndTime) LocationID, TaskID
    >
    > How data are entered into the table depends on how easy you want to make
    > the task. The simplest approach would be to just add data in a new row
    > in the worksheet. You could also use XL's built-in Data| Form... or
    > John Walkenbach's enhanced version that you will find at www.j-walk.com.
    > Finally, you could create your user userform for the job.
    >
    > This, of course, presumes you can store the information in XL. You may
    > also want to consider a program like MS Access. In addition to being a
    > real database program (better integrity checks of the data, real
    > relationships between tables, etc.) it also supports multiple concurrent
    > users.
    >
    > --
    > Regards,
    >
    > Tushar Mehta
    > www.tushar-mehta.com
    > Multi-disciplinary business expertise
    > + Technology skills
    > = Optimal solution to your business problem
    > Recipient Microsoft MVP award 2000-2005
    >
    > In article <[email protected]>, =?Utf-
    > 8?B?Q2hhcm1pbnN0ZXIgRGV2ZWxvcG1lbnRz?= <Charminster
    > [email protected]> says...
    > > I am trying to use excel to enter information for each employee in a building
    > > company according to where they have worked each day, and how many hours at
    > > each location. The problem being I am not quite sure if I should or even can
    > > use excel for this. Say on a Monday an employee did three hours at one
    > > location, 5 at another and two at a third. How can I have a viable way of
    > > entering informtion on one day which could have one through say 15 items of
    > > data, totaling the hours altogether, and also totalling the hours for each
    > > day, and for each location.
    > >
    > > Although I am a new user, I do have a computer background. Any help would be
    > > greatly appreciated.
    > >
    > > Gary, Charminster Developments Ltd.
    > >

    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1