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)

Sunday worked

holidays worked

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 :

Insert data
View report ( weekly - monthly )
Print week
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)
illness (hours)
permits (hours)
leave (hours)

sub reports for:



-all days

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.


Beceriler: PHP, Yazılım Mimarisi

Daha fazlasını gör: statistics architecture, shift planning, factors of every number, evening shift, dashboard architecture, can you use debit card as credit card, can you use a debit card as a credit card, architecture statistics, excel split a cell, sundays, spreadsheet holidays, excel php excel dashboard, excel based dashboard, spreadsheet credit card, credit card debit card, panel management solution, excel split cell, year date column, excel spreadsheet hours worked, shift days week schedule, excel name card, distribution statistics, days shift, card excel spreadsheet, day shift schedule

İşveren Hakkında:
( 0 değerlendirme ) Cremona, Italy

Proje NO: #6545477

Bu iş için 24 freelancer ortalamada $1324 teklif veriyor


Hello, We have read the project requirements in complete detail. We have noticed that you are seeking highly skilled and expert professional personnel to develop a web-based solution that allows the insertion of hou Daha Fazla

in %bids___i_period_sub_35% gün içinde1340%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(159 Değerlendirme)

Hello, I have read your post and understood your requirement. I have great experience in handling Wordpress /Magento/Joomla/Drupal/ HTML5/CSS3/PHP/Java/Python/Javascript/MySQL/ Kindly go through my works to Daha Fazla

in %bids___i_period_sub_35% gün içinde1578%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(61 Değerlendirme)

Hello, I have very big experience in this area. I checked attached files and all looks clear. ready to begin work.

in %bids___i_period_sub_35% gün içinde1578%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(368 Değerlendirme)

i have 8+ years of experience. Can we discuss the project. Please initiate a chat with me so that we can discuss the project at a broader level. Why you should hire me- 1. I have a very good communication skills Daha Fazla

in %bids___i_period_sub_35% gün içinde3157%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(29 Değerlendirme)

Hello. I can help you with this project. If you are interested in my service please first contact me through PMB to discuss.

in %bids___i_period_sub_35% gün içinde1002%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(91 Değerlendirme)

Hello Sri Technocrat will provide fully interactive website for your project. As per the detail, Sri Technocrat will provide three template functional schemes and sample pages to make your choice for layout. It will Daha Fazla

in %bids___i_period_sub_35% gün içinde1250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(57 Değerlendirme)

Hello, I am a professional programmer for web programming with php language to build the system website, Besides, I also expert in MySQL , HTML,HTML5,CSS, JS I'm always top in Vietnam freelancer [login to view URL] Daha Fazla

in %bids___i_period_sub_35% gün içinde1263%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(133 Değerlendirme)

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.

in %bids___i_period_sub_35% gün içinde1250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(171 Değerlendirme)

Hello, I have reviewed the Excel file & understand that you want employee/group work plan management system where you can track hours worked on the daily, weekly, monthly basis etc. All the data will be stored in Daha Fazla

in %bids___i_period_sub_35% gün içinde1500%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(65 Değerlendirme)

Hello, I am an PHP Certified Developer with more than 7 years of experience and shall get this done in about 20 days' time. Let me know if you have any doubts / queries about my expertise, will be more than hap Daha Fazla

in %bids___i_period_sub_35% gün içinde1578%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(71 Değerlendirme)

Hi, Can we have a discussion? please do check our portfolio [login to view URL] Srishti Innovative, an ISO 9001:2008 certified company, is a leading provider of Smart Solutions across Web, Mobile and Cl Daha Fazla

in %bids___i_period_sub_35% gün içinde1546%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(33 Değerlendirme)

Hi Sir I am a lead programmer as i have 10 years of working experience in php,mysql,wordpress, joomla, drupal, smarty, codeigniter, cakephp, YII, red5, zend, moodle, ajax, jquery, javascript, css, html, Graphics D Daha Fazla

in %bids___i_period_sub_35% gün içinde1666%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(26 Değerlendirme)

Sir, I am a professional web developer with software customization as area of expertise. Ur project is quite easy for me, as I have past experience in database related projects too... u can see from my reviews that Daha Fazla

in %bids___i_period_sub_35% gün içinde1250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(19 Değerlendirme)

Ciao, I can provide a solution based on Bootstrap 3 for the front-end and the Symfony framework, to ensure the best implementation of software architectural pattern. If you are interested in working together, le Daha Fazla

in %bids___i_period_sub_35% gün içinde888%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(37 Değerlendirme)

Hello,sir. I have experienced of developing many kinds of web projects for over 7 years. [login to view URL] [login to view URL] [login to view URL] [login to view URL] http://versantnc. Daha Fazla

in %bids___i_period_sub_35% gün içinde1184%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(28 Değerlendirme)

I am a energetic, vibrant, and creative professional with extensive skills in web solutions. I have 5+ years experience in PHP, Wordpress, Joomla, Magento, Prestashop, CSS, JQuery, HTML etc. I also developed many sof Daha Fazla

in %bids___i_period_sub_35% gün içinde789%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(33 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde1578%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(18 Değerlendirme)

Hello. I am a web developer with 11+-year experience . I work remotely on DigitalRay company - [login to view URL] - LA (USA). Technical knowledges: 1PHP JavaScript Ruby RoR ASP.Net C#, Java, Python, Zend, CakePHP, Symph Daha Fazla

in %bids___i_period_sub_35% gün içinde1000%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(23 Değerlendirme)

hi , i am ready to work with you on least amount while giving you better quality then any other one !! the reason is just to create a long term realtions with you and your organization !! i am having more then Daha Fazla

in %bids___i_period_sub_35% gün içinde750%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(17 Değerlendirme)

Hi. I've read your task carefully. I can complete your task. Believe me!!! Waiting for your reply. Thanks.

in %bids___i_period_sub_35% gün içinde1184%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(7 Değerlendirme)