Closed

Task Management

Job Description:

I want a spreadsheet that can calculate the man-hours needed for a set of tasks and a dashboard to check budget.

In one sheet I have a list of tasks and various data associated with those tasks (image001 (2).png).

In another sheet ([login to view URL]) I want to be able to take task name/dept from sheet one and show it so that managers can input/adjust the units needed per client contract (the peach column in image002). It'll then calculate the hours needed, and we want to be able to use slicers and whatnot to see how many hours are needed for certain categories.

Finally, I want an additional sheet that takes the task list from sheet1 and the corresponding hours from sheet2 and allows for input of how many hours are budgeted, how many of those hours have been used and what amount of tasks are done. Then it'll show how many hours we have left to complete those tasks and just general budget/progress info (e.g. this video [login to view URL]).

Skills: Excel, Data Processing, Project Management, Visual Basic, Excel Macros

About the Client:
( 0 reviews ) San Mateo, United States

Project ID: #35439467

23 freelancers are bidding on average $104 for this job

schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. I am a More

$220 USD in 5 days
(563 Reviews)
8.5
Giovanni704

Hi there! I have more than 10 years of experience as a Data Base Administrator and Analytics Engineer. I'd love to work together on your project. I'm so responsible and kind, I'll always send you the files on time and More

$30 USD in 1 day
(47 Reviews)
6.7
zu02

Hi I saw also the video. It's very complicated for your project. Allow me to make/code ms Access app for your project and you'll be very happy. Best, Zurab

$500 USD in 7 days
(48 Reviews)
6.2
huzaifarizwan995

I am an accounting,STATS, economics, marketing and finance and excel expert with success in maintaining and organizing data, including dictionaries, metadata repositories, and cross-reference indexes across a broad ran More

$50 USD in 2 days
(10 Reviews)
4.9
topacademictutor

I have 14 years of experience in the Writing Industry and I can provide you with “SUPREME QUALITY WORK” within your “GIVEN DEADLINE” with “PERFECT GRAMMAR” and “ZERO PLAGIARISM”. I have 1700 + "EXCELLENT REVIEWS" which More

$30 USD in 1 day
(30 Reviews)
5.1
assignsolver

I have read and understood all your project details and I feel my self the best candidate to complete this project with 100% accuracy. I have vast amount of experience in this industry since I am working from 2009 a More

$30 USD in 1 day
(35 Reviews)
4.6
toplinesolutions

I am a professional ghostwriter since 2010. I have helped in writing a magnitude of Articles, Blogs, Resumes/CVs, Website Content, Product Descriptions, Novels, Short Stories, Press Releases, Biographies, Books and eBo More

$30 USD in 1 day
(13 Reviews)
4.2
HelpingHut

I am damn sure that I can complete this project beyond your expectations within your given time and budget. I do not believe in charging high rates because I just love to write and fulfill my client’s need. I have c More

$30 USD in 1 day
(5 Reviews)
3.6
amokhtar70

Hi, I have gone through the project description and am interested in taking it up. I need a sample of what is exactly required. I’m Ahmed Hassanein. I have over 25 years of experience supporting systems and users in t More

$180 USD in 2 days
(2 Reviews)
2.7
SupremeWriters

I have more than 7 years of writing experience, I am a master in writing. I can deliver your work according to your requirements, given deadline, and 0% of plagiarism. I have served more than 4000 clients in the past 7 More

$30 USD in 1 day
(3 Reviews)
2.3
FineIdeas

I have more than 8 years of experience in managing academic writing tasks successfully. I am working with my friends from different backgrounds, which means I can manage a wide range of projects like; Engineering, Busi More

$30 USD in 1 day
(2 Reviews)
2.1
TopWritingGuru

My name is Rabia Faisal, I am working in the writing industry since 2011. In this time, I have served countless clients with full amount of satisfaction by providing them TOP Quality Solutions. I have command on all re More

$30 USD in 1 day
(2 Reviews)
1.7
WritingLabb

I am Minahil Hameed with a vast amount of experience in multiple fields like; Finance & Economics, Accounting & Cost Accounting, Business & Management, and Taxation & Auditing. I have achieved a great amount of success More

$30 USD in 1 day
(1 Review)
0.7
rashidamjad

Hi there, I am Rashid, I am a full stack developer with 4+ years of experience in both front-end and back-end development. I have read your Task Management description very carefully and would like to have a detailed c More

$250 USD in 8 days
(0 Reviews)
0.0
HelpingLab

I am an academic expert who can help you with your solutions like; Case Studies, Summaries, Reports, Thesis & Dissertations, and Online Exams and Courses in almost every language. I am new to this website but I assure More

$30 USD in 1 day
(0 Reviews)
0.0
Katyagoodwork233

Hello Dear. I have rich experiences in data processing using Excel and Excel VBA. I will provide perfect result in short time. Please kindly contact me for further discussion. Best regards.

$50 USD in 1 day
(0 Reviews)
0.0
pospakistan

i am the besti am the besti am the besti am the besti am the besti am the besti am the besti am the besti am the besti am the besti am the besti am the besti am the besti am the besti am the besti am the besti am the b More

$200 USD in 7 days
(0 Reviews)
0.0
kadamvinaya1998

Hi! I am perfectly fit on this job requirements that you have mentioned it. I will do this project better way because I'm expert in Ms Office, Data entry and it's related work .I am new in freelancer but not for this More

$50 USD in 2 days
(0 Reviews)
0.0
AliArifain

I wanted to watch the intro of the youtube link you provided before I bid and I did And gotta say, I was fascinated by it and I would absolutely love to help you get this done I always have fun with analyzing data and More

$80 USD in 2 days
(0 Reviews)
0.0
Amanrawat001

Interested & That's Enough ......................................................................................................................................................!

$140 USD in 7 days
(0 Reviews)
0.0