Car Parking Rota

[Crodchris07]

Hi,

Every week I fill out a parking rota for around 12-15 people at my workplace, I takes me forever to enter in all the people and work out who goes where because people work at different times of the day. I have provided a version of the excel sheet that I use, as you will be able to see I have typed in an example on the Monday section. Is there a way to automate this process? Any suggestions or help is greatly appreciated, at work we have access and excel.

Kind regards



Chris

 

[Ranman256]

yes, but this is not trivial. Youd have a form. click on the calendar for the week/month you want to fill. (or just set startdate/enddate in textboxs)

your tEmps table would have settings for full time/part time.
or
you could just dbl-click from a list of employees, this would put them in the tPicked list. (via append query)
Then only this list of persons would be used. Then another append query would scan the list adding dates/shifts/emps to the tWork table.

Like I said, not trivial, but do-able.

 

[Crodchris07]

Thanks for your reply Ranman256, It would be great to have a version created so that it can be automated. I am new to excel and access and don't know about any programming or technical stuff.

Many thanks Chris,

 

[Rx_]

It isn't trivial and the effort may not be worth programming for 12-15 people.
My suggestion would be to find an Excel tutorial book, on-line or other to start from the beginning instead of jumping into a complex task.
In the long run, going through any Excel course start to finish will enhance your career and skills.

As you go through an Excel course with programming, visit here again to ask questions.
Long time ago, I was a certified Microsoft Trainer including the course Microsoft Excel Object Model Programming. It was a fairly intense 5 day course for professional Excel users with some programming experience. As I kept track of the students over a 5 year period, many of them doubled their salaries. As a skill set, Excel Programming draws a lot of attention to anyone's talent. Probably the best bang for the investment of time and bucks.

 

[kevlray]

It isn't trivial and the effort may not be worth programming for 12-15 people.
My suggestion would be to find an Excel tutorial book, on-line or other to start from the beginning instead of jumping into a complex task.
In the long run, going through any Excel course start to finish will enhance your career and skills.

As you go through an Excel course with programming, visit here again to ask questions.
Long time ago, I was a certified Microsoft Trainer including the course Microsoft Excel Object Model Programming. It was a fairly intense 5 day course for professional Excel users with some programming experience. As I kept track of the students over a 5 year period, many of them doubled their salaries. As a skill set, Excel Programming draws a lot of attention to anyone's talent. Probably the best bang for the investment of time and bucks.

I learned Excel VBA on my own and have assisted co-workers with small macros to achieve various goals. But for some reason my employer does not give me a raise for going above and beyond my regular job. But then again I work for the government, so as long as I do what I am supposed to do, they keep me around

 

[Crodchris07]

I learned Excel VBA on my own and have assisted co-workers with small macros to achieve various goals. But for some reason my employer does not give me a raise for going above and beyond my regular job. But then again I work for the government, so as long as I do what I am supposed to do, they keep me around

Thanks for your reply kevlray,

I wouldn't have a clue where to start with programming, as i am more of a PC hardware guy. I thought that the Car Park Rota it would be a fun project for me to start and get advice forum like this. I guess you don't get much recognition for enhancing your skills these days. I have done excel courses in the past but only on older versions.

 

[Rx_]

I worked for State Government in databae support of Federal regulatory and enforcement for six years, six months and six days. I can remember because it is stamped on my forhead in my admin photo files as a record of service to the Beast.

Government has very little to do with measurement of recgonition. In fact, there are typically more cases where incompentence was rewarded over compentence being rewarded.

Thanks for brining up that distinction.

The best reason to work for government is to acquire inside knowledge about a subject then hop over the fence to work for private industry.

In that regard, Regulations have been very, very good to me.



This doesn't just apply to Excel, it applies to many skills. Get a course that covers all of the tool's or industry's options. Otherwise, you can be stuck by learning one single solution that is applied to all problems. While taking 80 hours to go step-by-step through Excel Programming may sound like a lot, this return on the investment can typically be made up within the first 150 hours of project work.

Figure that people work 48 weeks per year, 4 weeks of creating new Excel tools that automate repetitive tasks is a huge return on that time.



In my opinion, the project described is beyond your present skill level.

By obtaining and completing a Excel Programming Step-by-step course, book or activity, that skill level would raise significantly

 

[AccessBlaster]

It will be a little funky at first, so what nobody else is stepping up. I used to think these kind of projects would some day be finished, oh boy was I wrong. They just keep evolving into something better than the original. As your knowledge grows, so will your designs.

Good luck!