Manual Excel Time Sheet entry & report genration to VB or any suggestions?
$10-30 AUD
Betalt ved levering
Hi Guys,
Basic background:-
I have a manual Time sheet in excel, which is filled weekly by team of 11 members individually and sent to me for further approval.
And then I require to check each of them, and copy paste the data in separate excel sheet for final report.
Requirement:-
I want 1 Single form available for everyone to fill the time sheet, and each data can be stored somewhere on company SharePoint site or Company local drive,
For each week entry, individual have option to update their previous entered data in case if they missed something or updating the entry.
It either overwrite the previous entered entry or just bring the previous filled entries for update.
I want to generate the report of required data,
The report should be generated without duplicate entries.
Back end should be secure with restricted access to myself or the person i wants to add.
There are some validation and auto calculation require with form or excel sheet.
Like- option to select normal day/public holiday, Day shift/afternoon shift,
When normal day selected and worked time entered - after ordinary hours 7.60 hrs, it auto fill overtime hours if worked hours more then [url removed, login to view]
First 3hrs overtime filled in overtime x1.5 and rest will go to overtimex2.
If public holiday selected all the no. of hours worked will be goes to back end data as public holiday X2.5,
If afternoon shift is selected, the loading will be 15% for all the hours if shift finished after 7pm.
and few bits and pieces as we build it...
I will love to hear your suggestion to build this either in program or excel.
Thanks
Happy Bidding
THIS IS a FIXED Price Project $50, So please bid around the budget mentioned, Input and output excel file will be provided during discussion.
1 more project just after this one...
Projekt ID: #8063843
Om projektet
16 freelancere byder i gennemsnit $62 timen for dette job
I have 10 yrs of Exp in VBA,VB6.0,VB.net and MsAccess. I have developed many applications in VB6,VBA,VB.NET. Ready to start with VB6.0 With Access Database Can You send me your Sample Excel file ? if you wa Flere
Hi, I am 12+ years experienced Visual Basic,ASP.NET, VB.NET,MVC, C#,Bootsrap,Telerik control,Crystal report,WCF,JSON,XML,MS Access,MySQL,SQL,MSSQL Server(2005 to On wards) developer at CMMI-5 level company. I have 12 Flere
I am a software developer with 10+ years experience. I do consulting work on the side for a Fortune 50 company doing work primarily in Excel and Access using VBA. My full-time position I develop Web applications using Flere
Hi, I have worked on excel VBA and VB.net projects extensively in a CMMi level 5 software firm. I have worked on report generation and analysis. I will deliver the work with desired efficiency and speed. Please ping m Flere
Hello, This is Ankur B. Working for ProviaIT based in Mumbai, India. We are group of highly technical people. Our expertise in - ASP.Net, MVC, SQL Server, Jqery, AJAX and by using these technologies, we can effective Flere
I have worked on the Attendance Management Systems in which we were doing all the overtime calculations and the shift management as well as the reports over the attendance of daily or weekly or monthly basis.
I have 10+ years of working experience in Information Technology field. I am new to Freelancer.com but looking for long term relationship with my partner. I am confident to provide you best solution that meets your bus Flere