A web-based solution that allows the insertion of hours of work of a group of users, and produces specific statistics to organize shifts.
A control panel that allows you to enter single user, which can be grouped into "sectors" (eg. Pharmacists, cosmetics). for each user is specified number of hours worked by the contract, a previous total hours (debit or credit) for the "holidays" and the "permissions".
currently we use an excel spreadsheet, and fill the hours actually worked by each employee. in the right box are counted the hours actually worked and, if possible differences (debit or credit) with contractual hours. the cell with any credit or debit card is colored in green or red.
There are a few different templates to the weekly schedule on the basis that if any employee is on vacation. would be useful to recall previously saved patterns weekly. Each weekly schedule, which runs from Monday to Saturday, (but in the new version must also include the activation at will of the working day on Sundays) must have a name and date clearly visible.
is also present a total of daily hours worked by all employees of a sector in the total column.
(exampleA-fillform excel decsribe the actual interface)
the most important is the management of weekly reports, monthly and annual.
the goal of the software is the schedule of working hours is the equitable distribution of parameters such as: holidays, allowances, Saturday morning, worked, worked Saturday afternoon, Sunday worked, public holiday worked.
count as a unit is based on single hour of work.
every worker is entitled to a number of vacation days and days off each year.
in file exampleB, we have divided each month into weeks.
Since each month begins with Monday ', we counted the weeks according to the days of each month and got the hours to be worked per week.
every employee has a total daily hours to be worked. tot weekly hours / 6
these hours are modified by factors such as:
- Illness (in days)
- Permits (in hours)
- Leave (in days)
- Holidays worked (in hours)
- Sunday worked (in hours)
- Added holiday hours (in hours)
the important thing is to see if an employee has worked for all his hours as per the contract, or has generated a surplus, or even a savings (column L)
There are some important indicators as already specified for use in the planning of schedules:
these data must be present in a dashboard (including graphics) for quick reference, in which there are data for all users.
Saturday worked (divided into morning or afternoon or whole)
savings or surplus of hours
Holiday made (for the year)
permits made (for the year)
morning work (hours 9:00 to 13:00)
afternoons worked (hours 14:30 to 20:00)
continued shift (6 hours)
split shift (morning shift and afternoon shift but with a break during lunch)
closures made the evening (until 20:00 hours)
the goal of the planning and decisions to be made is to homogenize all the values of the indicators for each employee.
There will be a dash page with :
View report ( weekly - monthly )
Print report (week - month)
In config you should:
enter name of worker
specify the contract (how many hours weekly ex. 40)
attribute group (pharmacist -other) in order to make report per group
set working time area (daily) ex. 9:00 - 20:00
set working sundays (ex. a calendar to click on sunday) and set working time ex. 9:00 -19:00
set working public holidays (same input method as sundays) and set working time as above
particular attention should be used with input method page.
something like point and release click to set worked hours or something easy
(actually we put value of 1 for each half hour worked)
there will be a sum of worked hours daily for each user, and a whole view of all the week on same page (see my excel sample)
view the whole week it's fundamental for planning a good scheme.
the main indicators (see page) on global report with icons and easily readable: (set report for week, month or custom period)
working hours as contract.
effective worked hours
saved(green) or overworked hours(red)
worked sundays (hours)
worked saturdays (hours)
worked holidays (hours)
sub reports for:
with all user and worked hours separated by morning work, afternoon, continued shift, split shift, closures
P L E A S E - in order to discuss I need a quick demo on input page. when i see best and simplest method, i will follow contact.
24 freelancers are bidding on average $1324 for this job
I am an expert PHP developer and recently developed very similar project. Available to start immediately and finish as soon as possible. Please contact in PMB to discuss details if you are interested. Thank you.
Hi there- My name is imran.I am highly Expert in this field. I'll provide you satisfaction. So your time and money will be safe when you will award me project. take a look at my Freelancer Portfolio