Find Jobs
Hire Freelancers

Google Sheets Formula for Tracking Resources allocation

$30-250 USD

Closed
Posted over 5 years ago

$30-250 USD

Paid on delivery
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.
Project ID: 18133612

About the project

23 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
23 freelancers are bidding on average $107 USD for this job
User Avatar
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 several similar projects before! We have worked on 400+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$150 USD in 1 day
5.0 (267 reviews)
7.6
7.6
User Avatar
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 the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
$155 USD in 7 days
4.8 (81 reviews)
6.8
6.8
User Avatar
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 and work in our jobs, I will get paid once you have confirmed satisfied result. If I do not deliver satisfied result, I will never get paid from you. We can discuss more details to understand more easily if you have other infos. Hope to work with you. Thank you.
$155 USD in 3 days
4.8 (59 reviews)
6.3
6.3
User Avatar
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 in 3 days
4.9 (126 reviews)
6.2
6.2
User Avatar
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, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Out of my 75 projects, almost 70+ are complex PYTHON/VB/VBA/.Net/Webscrapping projects, hence i can definitely deliver an excellent solution to your requirement. Expert in PYTHON/VBA/VB/.NET, SQL, MS Office, Access/Excel/Word/Outlook, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex Webscrapping (Amazon / Aliexpress / eBay), VBA projects, viz converting Raw data to structured report, sales dashboard, PO tracking, Invoice Automation, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers.
$66 USD in 3 days
4.8 (70 reviews)
5.7
5.7
User Avatar
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 your project! Kind regards, Luis Romero
$50 USD in 3 days
5.0 (94 reviews)
5.2
5.2
User Avatar
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, excel
$155 USD in 3 days
4.6 (43 reviews)
5.6
5.6
User Avatar
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 in 3 days
4.8 (36 reviews)
5.0
5.0
User Avatar
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. Thank you. Looking forward to work with you.
$30 USD in 1 day
5.0 (7 reviews)
4.7
4.7
User Avatar
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. thanks
$225 USD in 7 days
5.0 (12 reviews)
3.7
3.7
User Avatar
"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 working here with 100% results and more creative and innovative ideas for our clients. I've worked on several similar projects before. I'm offering my services for more than five years in the field of Excel, Internet Research, Leads, Research, Web Search. I have a team with eight members. They can get the required data manually from the website. If you need the data to be scrapped then also I can do scrapping and put them into excel sheet. I am very responsible towards my clients and I can complete the task within time with cent percent accuracy. Regards "
$100 USD in 3 days
4.9 (15 reviews)
3.4
3.4
User Avatar
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 Skills: - Excel - VBA - Python - Web Scraping - MS Office Word, Outlook, Access, PPT Skill Set in Detail: - Office & Web Automation & Blogging on Office Tricks & tips. - Python Programming, Web Scraping - Data Scraping - Manual to Automatic updates in Excel - Excel Pivot Charts & Tables - Excel Auto Filter, Vlookup, Formula Assistance - Excel to Access - User Forms in Excel - Calendars in Excel - Bulk Files Processing in side a Folder - Folder Operations - Sending Email from Excel - Extract Data from Webpages Requesting to Contact before ordering. This would enable me to give a feasible custom offer. Please drop a message once you feel comfortable with my profile & lets get started with a feasible amount. Thanks for your time
$155 USD in 3 days
4.9 (8 reviews)
3.5
3.5
User Avatar
I have 2 years experience in project managerment so this so easy task. Please contact me soon for detail solving. Thanks
$30 USD in 0 day
5.0 (9 reviews)
2.8
2.8
User Avatar
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 in 1 day
5.0 (1 review)
1.4
1.4
User Avatar
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 my capabilities would be perfect for your project. So, I'm hoping that you will give me chance. Thank You. Foisal Alam
$88 USD in 3 days
5.0 (1 review)
0.8
0.8
User Avatar
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 in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have done a very similar task for my first project on freelancer. One of the many objectives was this : "If the total time each employee for each day is less than 9 hours then that row should be highlighted" If you wish you can see the full problem statement here : https://www.freelancer.in/projects/javascript/google-sheet-modification-using-google/ Would be glad to work on this. Thanks
$40 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I reviewed the google spread sheets. I'm very knowledgeable and make can make this happen for you. Lets work together.
$111 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of IRELAND
Mullingar, Ireland
5.0
8
Payment method verified
Member since Jun 26, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.