Find Jobs
Hire Freelancers

Assignment of the hours according to task and user (Hour calculation needed)

€8-30 EUR

Closed
Posted over 4 years ago

€8-30 EUR

Paid on delivery
--we can talk about Price if it feels like too low. -- Hello, I am looking for Hour calculation of the user after assigning the task to them with some factor. Basically what i need is a process : I assigned the hours to the user for a task for a period eg: for jan, i assigned 152 hours and user has available 192 working hours then result should come 152 hours not 192 hours as max we need is 152 for that task. and again if i assigned task 2 to same user to work for 50 hours, it should take only 40 as user has only this monuch left for that month . More details are in the pdf and excel file. I made it everything Ready only thing needed is , (I guess) is the Record sheet to Minus the Already assigned hours. But i am open to ideas. I prefer it without VBA but if its not possible without i might consider it .. we can talk about it later. Let me know if you think its possible. People sending request without Reading task, will be ignored. :D Text me :)
Project ID: 22236090

About the project

47 proposals
Remote project
Active 4 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
47 freelancers are bidding on average €25 EUR for this job
User Avatar
"I am an expert with great skills of data processing, Microsoft Excel, data entry and data management. I have successfully completed lot of tasks here means at freelancer.com. You can view my profile page for my skills, review and feedback of my client. I hopefully said that you will be satisfied to award me this job and I promise that I will deliver you a great quality output in timely manners. Your work will be delivered well in advance with seamless communication & timely response until project is completed. As well as for any alternation and query we are available 24 x7. Looking forward for nice start to great future business relations "
€20 EUR in 1 day
4.9 (433 reviews)
7.8
7.8
User Avatar
Edit: The formula addresses the situation given in Project Description. I notice that there are couple of more situations that need to be addressed and the formula below will have to be updated to cover these as well. Greetings! I have worked on the problem. Please use this formula in cell F10 and copy the same from all table cells from row 10 to row 18. For row 9, existing formula is sufficient. IF(AND(F$8>=$C10,F$8<=$D10),IF((INDEX('Available '!$A$2:$M$12,MATCH('work sheet'!$B10,'Available '!$A$2:$A$12,0),MATCH('work sheet'!F$8,'Available '!$A$2:$M$2,0)))-(INDEX(Record!$A$1:$M$11,MATCH('work sheet'!$B10,Record!$A$1:$A$11,0),MATCH('work sheet'!F$8,Record!$A$1:$M$1,0)))<(INDEX($F$3:$Q$5,MATCH($A10,$E$3:$E$5,0),MATCH(F$8,$F$8:$Q$8,0))*$E10),(INDEX('Available '!$A$2:$M$12,MATCH('work sheet'!$B10,'Available '!$A$2:$A$12,0),MATCH('work sheet'!F$8,'Available '!$A$2:$M$2,0)))-(INDEX(Record!$A$1:$M$11,MATCH('work sheet'!$B10,Record!$A$1:$A$11,0),MATCH('work sheet'!F$8,Record!$A$1:$M$1,0))),MIN((INDEX('Available '!$A$2:$M$12,MATCH('work sheet'!$B10,'Available '!$A$2:$A$12,0),MATCH('work sheet'!F$8,'Available '!$A$2:$M$2,0)))-SUM(F$9:F9),INDEX($F$3:$Q$5,MATCH($A10,$E$3:$E$5,0),MATCH(F$8,$F$8:$Q$8,0))*$E10)),"") Please try it out and let me know your feedback. Have a Great Weekend! Srinivasan
€25 EUR in 1 day
5.0 (220 reviews)
7.0
7.0
User Avatar
Hello there, I am an Excel expert and I think small VBA script can make it faster and better for you. Please contact me. I think I can do it within 2 hours. Thank you.
€30 EUR in 1 day
5.0 (230 reviews)
6.6
6.6
User Avatar
I can definitely help you with that. I am a professional Financial Analyst, Statistical Analyst and Data Science expert holding years of experience in developing some highly and automated excel based tools and dashboards to perform some complex financial and statistical calculations. I will be happy to discuss in detail how I am highly suitable for this project.
€30 EUR in 1 day
4.7 (120 reviews)
6.7
6.7
User Avatar
Hi, Greetings. I went through the pdf file with requirements and understood what i need to implement into excel. Yes, we can achieve it without using vba, just need to use some functions. Plz let me know if you are interested that i could show you a sample. Thank you.
€30 EUR in 1 day
4.8 (105 reviews)
6.1
6.1
User Avatar
Hi, I agree with you so I do suggest VBA coding for good quality results. I have rich experience in VBA coding (API, Websacrping, Automation tasks, managing data, .....), and I do my best to save your time and pocket. Please feel free to contact me. Services: # Accuracy # Customer satisfaction is my first "Priority" # Time Commitment # Availability Thanks, Shahin
€24 EUR in 1 day
4.6 (66 reviews)
6.1
6.1
User Avatar
I possess exceptional data science and statistical analysis experience. I use Excel, STATA, R-Programming and SPSS software’s in qualitative and quantitative research and report writing. I hold MBA (Strategic Management) undergraduate degree (Statistics) & CPA.K (Accounting and statistics.) As a data and research analyst, I have attained utmost discipline in delivering quality, accurate and reliable results. Happy to work with YOU
€19 EUR in 7 days
4.7 (54 reviews)
6.1
6.1
User Avatar
I can develop the hour calculation sheet with exact requirements mentioned in task excel and pdf file along with any other requirements we discuss. Please initiate chat to discuss this in detail. Please find below a brief introduction of myself. I am postgraduate with more than 6 years of experience in advanced excel formulas and calculations, project management systems, VBA automation, google spreadsheets, google scripting and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I have developed excel based project management template for Ernst & Young also. You can get your work done here with highest quality at lowest price. Looking forward to work with you
€70 EUR in 1 day
4.9 (53 reviews)
6.0
6.0
User Avatar
Hello, I am ready to discuss project with you. Being experienced in working on several excel projects related to macro/formula/vba/functions/charts etc. Based on that i can quickly help you in getting your project done as you mentioned in the description. I am available to start now and want to discuss more specific details. Looking forward to have further project discussion on chat. Thanks. Sapna Dalsaniya
€30 EUR in 2 days
5.0 (45 reviews)
5.2
5.2
User Avatar
Hi I've viewed you Excel file..and pdf What to say ,as my experience shows here best way will be to code it via Ms Access , I'll detail on private chat Best wishes, Zurab
€19 EUR in 7 days
4.8 (24 reviews)
5.6
5.6
User Avatar
Hi, I go through your formulas, It seems like you haven't include the previous amount of hours that one person is working within one month for another tasks into the new task (meaning that if user 1 should work 150 hours for task one, so you need to minus this amount from his/her total available work 195 - 150 , so if you use formula like -SUM(F9:F9) in the F10 cells (and -SUM(F9:F10) in the cell F11 and so on) than you will have your result. Please send me message to discuss more and fix your formula
€30 EUR in 7 days
5.0 (14 reviews)
5.1
5.1
User Avatar
Hi there, YES! what you need to accomplish can be achieve using Excel in-built formulas like logical functions and modified vlook-up. My rate for this job is €25 and I can turn it around after two days. Please message me if this is what you need. I'll be standing by to help. -Reggie
€25 EUR in 7 days
5.0 (35 reviews)
5.2
5.2
User Avatar
Hello. Sure this can be done using a formula. You have already made some lengthy formulas using Index, match and Look ups. You can do the same here too. Calculate the sum of each user for a month separately and store it a hidden cell or may be a hidden sheet. Using If, check if this total work is exceeding the maximum possible. If it is exceeding, then return 192 , else the hours in task 2 . Feed this into your main Sheet. This method can get tedious if it involves more users and more tasks. But, if you are to do this using VBA, it will take care of all the things with a couple of lines of code. Lets discuss this if you find my suggestions valid. Thank you
€20 EUR in 1 day
5.0 (22 reviews)
5.3
5.3
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. Regards
€28 EUR in 2 days
4.5 (47 reviews)
5.7
5.7
User Avatar
Hi, The solution to your Project is ready and is elegant without any VBA.I have your solution ready and working.. Regards. Reuben
€15 EUR in 1 day
5.0 (20 reviews)
5.0
5.0
User Avatar
Hi What you are requesting is month to month getting totals from "Available" worksheet. And using that totals, setting values in worksheet "work sheet". It is easy. But is that all? Don't you need another list showing user totals in detail? Just award me and let's talk about the other needs later? If we proceed together, I think you will have a very different result in the end. Regards,
€23 EUR in 3 days
5.0 (24 reviews)
4.7
4.7
User Avatar
Hi there. I am available to complete your work. I have read thoroughly your project description and I have looked at the attachments. I am a professional in excel and will create the hour-scheduling as you like it. I am available to start work now. Thanks in advance.
€25 EUR in 1 day
4.8 (41 reviews)
4.8
4.8
User Avatar
Hi There, I can help you to create formula for calculation hours, i have read all your requirements, i can do it just for couple hours. Please kindly chat me, i'm available now. thanks. Regards.
€15 EUR in 1 day
5.0 (23 reviews)
4.8
4.8
User Avatar
Dear Sir or Madam, I used listobjects to make the tool more robust and solved the equation.... =IF(AND(DATEVALUE(TableWork[[#Headers];[Jän.19]])>=[@[Start ]];DATEVALUE(TableWork[[#Headers];[Jän.19]])<=[@End]);MIN(VLOOKU.... I'll deliver immediately after order is placed. Best regards Davide
€30 EUR in 1 day
5.0 (2 reviews)
4.7
4.7
User Avatar
Hi there Yes i can make this for your calculation of hours You can see my profile for extensive experience and skills that i have based on clients reviews Would be happy to discuss this one with u Thanks Obaid
€24 EUR in 1 day
5.0 (23 reviews)
4.2
4.2

About the client

Flag of GERMANY
Berlin, Germany
5.0
3
Payment method verified
Member since Aug 7, 2019

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.