Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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
|
|||
|
|||
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 , =?Utf- 8?B?Q2hhcm1pbnN0ZXIgRGV2ZWxvcG1lbnRz?= <Charminster 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
|
|||
|
|||
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 , =?Utf- 8?B?Q2hhcm1pbnN0ZXIgRGV2ZWxvcG1lbnRz?= <Charminster 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How change dimensions of data label text box in pie chart? | Charts and Charting in Excel | |||
square chart with excaclty defined dimensions | Charts and Charting in Excel | |||
Plotting 4 dimensions in a chart | Charts and Charting in Excel |