Закрито

Google Sheets Formula for Tracking Resources allocation

Hi I need the following formula.

We use Google sheets for tracking projects. We need to be able to know when we have assigend a person too many tasks for them to complete in one day. So if we assign them too many hours, something goes red to highlight it.

Here is a sample spreadsheet: [login to view URL]

Column H is the person who the task is assigned to.

From column I to BJ is a ghantt chart

Inside each row for each task, we put in roughly how many hours it will take.

We want to be able to add up the hours that are allocated to each person so we know if we make them do more than 8hrs of tasks a day.

Навички: Excel

Деталі: google analytics conversion tracking, google maps usps tracking, google maps ups tracking, google analytics redirect tracking, google maps gps tracking web, google adwords conversion tracking code aspnet, set google analytics conversion tracking, google map ups tracking example, google flash mouse tracking, integrating google map gps tracking, iphone gps data google maps xml tracking, real time google map location tracking code, google analytics conversion tracking joomla, using google map asset tracking, google maps gps tracking software development asp net, google sheets formula, https://docs.google.com/spreadsheets/d/1BoluYWe-QeEmRDwp1nHYwzJw5AZwmHxdjsMlLuv8Lns/edit?usp=sharing

Про роботодавця:
( 7 відгуки(-ів) ) Mullingar, Ireland

ID Проекту: #18133612

23 фрілансерів(-и) у середньому готові виконати цю роботу за $107

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Більше

$150 USD за 2 дні(-в)
(628 відгуків(и))
8.3
schoudhary1553

Hello, Hope you are doing well. I can help with you in your project Google Sheets Formula for Tracking Resources allocation. I can assure you the quality job. I have good experience in Excel. We have worked on Більше

$150 USD за 1 день
(267 відгуків(и))
7.6
zekovicm

Hi there,I am Miljan,Google sheets expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within Більше

$155 USD за 7 дні(-в)
(81 відгуків(и))
6.8
polarjin2017

Hello? How are you? I have good experiences in "Google Sheets Formula for Tracking Resources allocation" as you can see my profile for these (Excel). I have been working for 7 yrs in this scope. While we contract a Більше

$155 USD за 3 дні(-в)
(59 відгуків(и))
6.3
fatimatuzzohura

Hi, I am experienced on Microsoft Access , Excel and VBA. I can start your job immediately also. Please contact me to discuss the project in details. Thanks

$150 USD за 3 дні(-в)
(126 відгуків(и))
6.2
kevivu

Completed numerous similar projects in the past and always impressed the clients with my excellent solutions. Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis Більше

$66 USD за 3 дні(-в)
(70 відгуків(и))
5.7
sonarkaushik

Sir, I am well versed in these kind of jobs and can do your project as per requirement. ***I am ready to start Waiting to hear from you. with thanks and regards Relevant Skills and Experience Google sheet, ex Більше

$155 USD за 3 дні(-в)
(43 відгуків(и))
5.6
beltran0404

Hello, I am Luis from Venezuela and it will be my pleasure to help you with this project. I can do figure out the formula to solve the issue you have. Please contact me by chat and then we could discuss better yo Більше

$50 USD за 3 дні(-в)
(94 відгуків(и))
5.2
c4cuteconain

I am a professional accountant with a decade of experience working in a US based NASDAQ registered company's finance department with excellent excel skills and knowledge.

$30 USD за 3 дні(-в)
(36 відгуків(и))
5.0
cziner

Hello there! I've successfully applied formulas to highlight more than 8hrs of tasks a day for each person. It is also possible to display extra hours if you wish. Anyway, please come to inbox to see what I've done. Більше

$30 USD за 1 день
(7 відгуків(и))
4.7
jsb1156

Experienced project professional, US based, MBA, EXCEL, SHEETS and MS Project expert; very experienced with Project Resource allocation analysis, Gantt and Histogram visualization of over/under-allocation. I would b Більше

$55 USD за 3 дні(-в)
(13 відгуків(и))
3.7
sevillajk01

hello! I can help you with your project. I offer you a high quality, accurate and fast turnaround. Why only ask for the formula when I can create the full tracker for you. Please see reviews on my previous projects. th Більше

$225 USD за 7 дні(-в)
(12 відгуків(и))
3.7
akritisood94

I have 4 yrs in Programming, Automation & more importantly delivering projects as required & in quick turn around time. I work full time as Freelancer & Blogger. I will be able to start your work immediately. My Main S Більше

$155 USD за 3 дні(-в)
(8 відгуків(и))
3.5
dataexplorer

"Hello, I am happy to inform you that I have read your current project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional wor Більше

$100 USD за 3 дні(-в)
(15 відгуків(и))
3.4
nvchien94

I have 2 years experience in project managerment so this so easy task. Please contact me soon for detail solving. Thanks

$30 USD за 0 дні(-в)
(9 відгуків(и))
2.8
Johnniechat

Hi. am new here on freelancer. I am really interested in your project because I know am the right man person for this project and am looking forward to a long term relationship

$30 USD за 1 день
(1 відгук)
1.4
ITspecialist247

Hello, Thank you for your job posting. I'm an Excel & data processing specialist. I can complete any Excel and Data entry related job with 100% accuracy. I’m a hard working, fast learner, and honest person. I believe Більше

$88 USD за 3 дні(-в)
(1 відгук)
0.8
anhmaiico

I'm good at excel. I'm interested in taking care of everybody. I like the feeling of being in a team, too. I think I'm perfect for this work.

$244 USD за 3 дні(-в)
(0 відгуків(и))
0.0
girishpd65

It can be done by using a pivot table which can be refreshed after new data is available so no need to make it again

$111 USD за 2 дні(-в)
(0 відгуків(и))
0.0
muhammadsaheer92

Greetings, Very simple [login to view URL] expert is here. I can do this task with high accuracy I am confident that i can deliver best service for you if i am awarded. Please send me a message so that we can discuss more. Більше

$30 USD за 0 дні(-в)
(0 відгуків(и))
0.0