Create Excel-based work time sheets/project tracking - repost
₹100-400 INR / hour
Closed
Posted over 10 years ago
₹100-400 INR / hour
Create a fast and easy to use, Excel-based weekly work timesheet for workflow and project time tracking in our small PR/media/marketing business.
We want to include a graphic front end interface incorporating our company branding/feel for staff to be presented with, with access to the backend data only for management. We can provide a full graphics/design if required.
The timesheet needs to have drop down selection menus listing our clients and their various departments, allocate job numbers (abbreviated client name/yy-mm-dd/job number of the day), include selection menu for job particulars (our departments/services), a space for staff comments undertaking the role, time started, finished and accumulated time spent.
We also need the capability of expanding the selection criteria at any stage, and to be able to draw information and statistics from the data input.
The goal of this project is to build a capability which will allow us to accurately track time spent on jobs, understand our workflow, organise job schedules, delegate responsibilities and build a database of knowledge from which we can build our business.
Columns:
Date – (drop down menu, date selection)
Clients (list client names
Department
Job Number – automatically allocated using abbreviated client name, date (yy-mm-dd) and job number of the day
Project – Project name
Job Type – (drop down menu listing our
Comments – room for employees to make comments on jobs
Time Started – (drop down menu, clock selection)
Time Finished – (drop down menu, clock selection)
Total Time – accumulated total from start/finish columns
We envisage this as the first of many jobs that we will undertake over coming weeks and months.
Hi
I am an expert in Excel and VBA Programming in Excel. I have experience in Excel Designing, Excel VBA Programming, Providing Business Solutions in Excel and Creating Dashboards in Excel for Presentations.
I am interested to work for your project. Please give me a chance. I have handled many projects involving data manipulation handling, business solutions, Excel automated dashboards, Report Generation and Excel Applications.
If you offer me your project, I can start immediately and deliver the job within 2 days after testing (QA) . I guarantee 100% accuracy for my deliverable.
I do hope you'll give me the honourable chance to work with you and help me with making my mark on freelancer.com. I will take your project as the priority job and will complete your work in minimum time with 100% commitment.
Thanks
Fibin
Hi! I would like to take up the project. You can have look at my portfolio- Studio K(This is a sample report of address book). Although your project would be similar to this. Price I have quoted is negotiable but I need reviews in bargain.
I am an expert in Excel and can easily do this for you. I can get it back to you within a couple hours. I have over 7 years of experience working in Excel on daily basis. I can start right away.
Dear Rfreedom,
My previous job requires not only perform in operation but also analysis and research that requires me to create data entry myself. I am detail oriented, organized and will present the job according to your requirement.
Skill: Data Entry, Copy Typing, Accounting, Excel, Microsoft Office
Look forward to your favorable response. Thank you.
Hi I can do this for you in excel using VBA. You will be able to change anything that you want to as well and have a graphic interface. I can do this within a week charging 300 rupees per hour. I will consult with you as and when i need further information or clarity. Looking forward to hearing from you
Greetings! I have worked on more than 25 academic papers including dissertation thesis in the past 1 year and all of them have been greatly appreciated with high marks. My work is original, well researched and 100% completed by me, not subcontractors. I hold a Bachelor of Marketing degree, a Bachelor of Finance degree and a Master of Marketing Research degree. I would very much like to work with you on this project and request that you contact me through Freelancer.com to discuss specifics. Thank you in advance. Alex