Hi,If you are looking for outofbox Solution in SharePoint and if its the first time setup, then I would suggest you import data from Excel, it would be much easier to setup this way.note: Excel to SP List works only for creating new lists, and not for updating data from excel again, if you try to import to SharePoint after initial import it would overwrite data.Synchronize a SharePoint list with a spreadsheet programEdit: If you want the excel data to be updated, I would suggest to use SharePoint list as a primary source and start updating SP list rather than Excel. You can still export form SharePoint list to Excel after all your updates.Hope this helps!Ram - SharePoint ArchitectBlog -Please vote or mark your question answered, if my reply helps you. Hi,If you are looking for outofbox Solution in SharePoint and if its the first time setup, then I would suggest you import data from Excel, it would be much easier to setup this way.note: Excel to SP List works only for creating new lists, and not for updating data from excel again, if you try to import to SharePoint after initial import it would overwrite data.Synchronize a SharePoint list with a spreadsheet programEdit: If you want the excel data to be updated, I would suggest to use SharePoint list as a primary source and start updating SP list rather than Excel. You can still export form SharePoint list to Excel after all your updates.Hope this helps!Ram - SharePoint ArchitectBlog -Please vote or mark your question answered, if my reply helps you.
Thanks Robin.I have imported a spreadsheet which contains thousands of data to my SharePoint list with columns such as Emp ID, Start and end mode as 'E' and 'S', and Date and Time. One Emp ID has several Start and End mode per day.
I am asked to write a code tocalculate the total duration of hours worked per day of a particular employee. The code has to be written in Visual Studio and the total duration of hours calculated from the raw data in the list should be displayed in another list.
Any help would be greatlyappreciated.Thanks in advanceRegards,NeoNeo Alpha. Thank You.I have imported a spreadsheet which contains thousands of data to my SharePoint list with columns such as Emp ID, Start and end mode as 'E' and 'S', and Date and Time. One Emp ID has several Start and End mode per day. I am asked to write a code tocalculate the total duration of hours worked per day of a particular employee. The code has to be written in Visual Studio and the total duration of hours calculated from the raw data in the list should be displayed in another list. Any help would be greatlyappreciated.Thanks in advance.Neo Alpha. One question is when do you want to calculate total duration of hours.
I mean on which event like item change, item created or for a particulare date like start of the month or end of the month.Here are some ideas,. you can use Event receivers to calculate data based on a event. You can use Timer Job to calculate data on a particular time. you can use SharePoint designer based custom workflow to calculate the datahere are some references -Event Receivers -Timer Job-SharePoint Designer Workflow -Hope this helps!Ram - SharePoint ArchitectBlog -Please vote or mark your question answered, if my reply helps you.
2010 Sample Employee Absence Tracker.1.Employee absence tracking 201 2010 2010 2009 2010 2010STotal Total Vacation Personal Vacation Total ick Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecLeft Used Allotted Allotted Left Allotted DaysEmployee 1 2 6 5 2 1 8 0.5 1.0 -1.0 -1.0 - 1.0 1.0 1.0Employee 2 0 11 7 2 2 11 1.0 1.0 1.0 1.0 0.5 0.5 1.0 0.5 0.5 1.0 1.0 1.0 2.0Click on desired name and you will be directed toemployee's data entry calendar.Add new employee as needed., 12:sampleemployeeabsencetracker-2446-phpapp02.xls.1. To record an absence or enter current/prior year vacation allotment:a) Go to the 'Total' sheetb) Click on desired employee's name and you will go to employee's data entry calendarALL OUT OF OFFICE DAYS ARE RECORDED ONLY ON THE EMPLOYEE'S INDIVIDUAL SHEET.2. Select a letter from the drop-down list or type the following letter to record out of office days: V=Vacation or P=Personal Day.3.
Excel Template Employee Absence
Work Absence Template
This calendar has been configured to allow the usage of 1/2 days with (V)acation and (P)ersonal. Select an item from thedrop-down list or type the appropriate letter, a space, then (am) or (pm); i.e. 'V (pm)' for afternoon vacation day.Select from drop-down list or type 'VPh' to use 1/2 vacation and personal time for a day.4. If you have more vacation days or personal days than allotted, a message will appear at the top of the sheet telling you whichone (vacation or personal day amounts) you need to check.5. Just type in Jan 1 date and the entire year will fill out. No need to type in each date. If it is not a leap year,delete February 29th.Legend:H=Holiday; P=Personal; S=Sick; V=Vacation; VPh=1/2 of Vacation & Personal DayP 1/2 Day=Personal (am) or (pm)S 1/2 Day=Sick (am) or (pm)V 1/2 Day= Vacation (am) or (pm)Original Calendar Template Created by:J.
Excel Template Employee Absence Schedule
SykesCalendar Template Modified by:J. Elder, 12:sampleemployeeabsencetracker-2446-phpapp02.xls.1, 12:sampleemployeeabsencetracker-2446-phpapp02.xls.4 2009 Out Of Office CalendarEMPLOYEE: Employee 1 #NAME?