Create Excel-based work time sheets/project tracking
$8-15 AUD / hour
Closed
Posted over 10 years ago
$8-15 AUD / 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.
Hello - I am an Expert Techno-Functional Analyst in lots of arenas of IT industry including Excel Macros. I am an Engineering Graduate with an MBA degree.
I am among the niche full 5 Star bidder becasue I work till the fullest satisfaction of employers and you can find the same in any of the past reviews of mine.
I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done.
Thanks,
Jay
Consider it done. Check my past reviews for your reference. I have create many such sheets before and I am sure will create user friendly interface for you. Eagerly looking forward for your reply.
Hope you are doing well. I am the Team lead of one of the most experienced and skilled data entry team on freelancer.com and I am interested in offering our services to cater your data entry requirements.
I am offering you a very economic price. I hope you will consider the price as well as my experience.
please let me know if you have any questions.
thank you and I shall look forward to hear from you.
All best regards,
Devendra
Hello
We highly recommend our team for your work. They have vast experience in data entry projects like data mining, data research, email scrapping, profile and account creation. We are capable to provide excellent work with sharp accuracy and on time delivery. We have a team of 40 operators. We will be in touch with you through out project. Please consider us for this project.
Looking forward to hearing from you.
Best regards
Deepansh
Pandeypriya E Solutions
Hi there,
I'm expert in Advance Excel, Formula, Function and Macro. I can do this. Please check my feedback as I've done several Excel project on freelancer. Please PM me
Thank you,
Farzana Pinky.
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.
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/Excel/Excel-Spreadsheet-Timecard-for-work.html
https://www.freelancer.com/projects/Data-Entry-Excel/Excel-Line-Restructured.html
Regards.
Hey veracitymedia, If you are using WINDOWS based system, then we may the right team to approach... please have a look at our profile...we have delivered a lot of such products... thank you.. please reply !
Hello!
Thanks for considering my bid. I have done some projects of this nature. Being a management professional, know the need for simplistic but attractive design. I intend to use separate databases for employees and clients etc. so that the data can be updated in respective tables without changing the front end. I am also proficient in use of Visual Basic for making attractive front end tools/forms for data entry. If required, the reports can also be generated, printed and mails automatically using VB application.
I assure you of prompt and accurate completion of the project and availability for future projecs.
Dear Sir, I have such project finished and with small modification it can be up and running in very litlle time. My area of expertise is project management (time tracking, budget tracking,..) , VBA in Office applications and complicated graphics in Excel (user defined graphs, charts, ...). Please check my portfolio and reviews of my employers and award me with trust. Also note that I have 100% repeat hire rate. With regards, Tom
Hi there,
I have created same type of time sheets in past project. I m ready to finish this task withing time and with full satisfaction. If interested pls reply asap.......
thanks & regards:
Mandeep Singh
Similar Projects:******Please check IOHL, Hotel Management Template in my Portfolio.*********
I can provide you with an attractive userform.
Good Day!... I'm an Expert in Excel Automation. Having 6+ yrs of Exp. Have devleoped & designed various Excel based Projects, Dashboards, Templates & Trackers by using Excel VBA Macros & also with Advanced Excel Functions.
You can check few of my project samples at my Portfolio to know my excel coding skills.
I can finish your task very easily. I can edit pricing within your preferred budgeted range, if you say.
Please award this project to me. & lets start working on this right away.
I can finish your task perfectly & Ongoing support Assured
Please initiate chat & come for discussion.
Hello,
I'm an expert in excel programming using vba/macro/ formula. I can do the task with perfection and you can revise that any time. Also if you need any after support then kindly let me know.
Bid price and time are negotiable.
Looking forward to your response,
Sharly
PS: I just need 2 days to do the task.
I have a better than excel and a robust solution for this project.
Using of excel will create problems with the passage of time as your data will grow. This is happened always in case of excel based applications
Instead I shall develop you a stand alone desktop application using Visual Basic at front end and Ms Access at back end This is considered best combination for database projects. Here are benefits of this combination
--You do not need to install Ms Access on your pc
-You do not need to have any additional component on your pc to run this application
-You only need to install the proposed application with installation wizard (I shall provide it) and start your work.
Key Features of application:
1- Add / modify / delete options / search for the data
2-Maximum drop down menus selection to minimize the manual input
3-Auto calculation
4-User friendly input forms
5- Dynamic professional looking reports
I shall deliver you
-Installable exe package
-A robust, relational, and normalized Ms Access database.
-Application installation wizard package (which will help you to install the application on your pc).
Price: $13.50 / hour
I look forward to hear from you
Regards,
Asghar
Lovely project and nice job. I worked as a consultant and I am familiar with the time sheets and their role.I am also an experienced specialist in excel and I am interested for a long cooperation. Regards Doina
Good day sir! I'm very interested in this project and ready to discuss further for details. Please see my letter in PM. I'm looking forward to get your reply. Thanks and regards