Fermé

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.

Compétences : Excel

en voir plus : 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

Concernant l'employeur :
( 7 commentaires ) Mullingar, Ireland

Nº du projet : #18133612

23 freelance font une offre moyenne de $107 pour ce travail

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 ( Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(628 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(267 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(81 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(59 Commentaires)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(126 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(70 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(43 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(94 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(36 Commentaires)
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. Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(7 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(13 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(12 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(8 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(15 Commentaires)
3.4
nvchien94

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(9 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(1 Évaluation)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
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. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(0 Commentaires)
0.0