Create Excel-based work time sheets/project tracking - repost
$10-30 USD
Cerrado
Publicado hace más de 10 años
$10-30 USD
Pagado a la entrega
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.
Good day, I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting.
I've done the same project before:
https://www.freelancer.com/projects/Excel/Excel-Spreadsheet-Timecard-for-work.html
Here are the links for my past experiences:
https://www.freelancer.com/projects/Excel/Drawing-EXCEL.html
https://www.freelancer.com/projects/4848189.html
https://www.freelancer.com/projects/Visual-Basic-Excel/Excel-user-form.html
https://www.freelancer.com/projects/Data-Entry-Excel/Excel-Line-Restructured.html
Regards.
I am expert in typing, data processing, data mining and extracting data. I am also very well versed with excel. This task can be completed within stipulated time with 100% accuracy. Thanks.
I am ready to do it. Please provide me task details. I have much experience with this type of task.
I am ready to do it. Please provide me task details. I have much experience with this type of task.
I have TONS of experience with creating these types of documents with 100% accuracy. I will be able to get this done quickly. I have plenty of time on my hands at the moment. PM me for more information!
Hi i have an extensive 12 years of experience in the Excel spreadsheet creation and the automated excel sheet. I am good at Excel programming with VB and with out VB. I have done automated excel sheets. If you provide me this project i will make it fully automatic and secured with individual passwords and username as well and one admin password and username to enroll, check and edit and extract data. Please give me an chance to show you my skills i have already done and been awarded innovation award in my present UK based Design consultancy which operates in all parts of the world.
Regards
Srinivasa Temkar
I'm biostatistician : 5th year of university in agronomy + 5th year of university in statistical methodes in France. I'm working in an insurance as statistician and excel expert. I'm ready to do your sheet. Well-off with manipulations on Excel and Internet, it will be easy for me to create your sheet. I worked in big companies and I realized international projects. You can develop trust in me, I'm competent, contentious, and efficient. I'm new on this site but I realized already 2 missions. I’m waiting your proposition, we can speak about the price without problems. I hope to hear from you. Thanks.
Hi,
Our Data Entry operators are enriched with preparation of MIS and other Reports & are highly exposure on MS office packages (MS Word, Excel, Power Point etc.).They have a excellent typing speed of 35-40 wpm which ensure timely completion of assigned task.
Please check our portfolio.
It would be a pleasure if we can get an opportunity to work with you. Hope to hear from you soon.
Warm Regards,
SD Info
I am a finance professional with Advanced excel skills with over 5 years of reporting experience.
I have created various such reports/tracking templates for my company as well as for various other company while i was doing my internship.
I understand the requirement here and propose to provide with a draft report within a hour of getting the inputs that i need to get things done. I already have a template ready with some random data. I can send that to you if required.
Requirements from my end would be
1. Little more details regarding how you would need the front end to be decided - the look and feel aspect of it
2. Complete list of Clients,Departments,Projects and Job types which i would need to incorporate into the respective drop downs.
Please do let me know if you have any other special requirement with respect to this template.
Thanks.
I have over 15 yrs experience in IT and data processing. I have excellent knowledge in excel and word, I have very good communication skills - both written and oral. I am very confident that I will deliver a quality product and provide you great value for money.