Closed

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

--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 :)

Skills: Excel, Excel Macros, Excel VB Capabilities, Excel VBA, Project Management

See more: needed text, calculation needed, facebook clone drupal modules needed let know, crm workflow create task user, animator animation movie hour wanted needed, php user login create excel file, start task curent hour, vbnet read excel file uploaded user, active directory excel file automate add user, powershell script add user excel file, scheduled task user log, rails list task user, hour support needed, man hour calculation excel sheet, user experience consultant needed, task prioritization app calculation, web developer hours per week per hour, is user interface design needed before hiring a developer, web developer task management hour, user experience design needed

About the Employer:
( 3 reviews ) Berlin, Germany

Project ID: #22236090

51 freelancers are bidding on average €24 for this job

datakillers

"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 skill More

€20 EUR in 1 day
(205 Reviews)
6.9
ksriniravi

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. More

€25 EUR in 1 day
(189 Reviews)
6.8
bdoutsource

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 in More

€30 EUR in 1 day
(104 Reviews)
6.1
nvchien94

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
(145 Reviews)
5.9
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] More

€30 EUR in 1 day
(133 Reviews)
6.0
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. Regards

€28 EUR in 2 days
(47 Reviews)
5.6
bhupendrayadav

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 br More

€70 EUR in 1 day
(36 Reviews)
5.4
zu02

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
(19 Reviews)
5.3
charleslimnet

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 Managemen More

€19 EUR in 7 days
(46 Reviews)
5.6
dalsaniyasonu123

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 don More

€30 EUR in 2 days
(44 Reviews)
5.1
daniyal3214

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 dashboar More

€30 EUR in 1 day
(53 Reviews)
5.5
shahinrahimi

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. More

€24 EUR in 1 day
(44 Reviews)
4.8
serdaryalcin

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 showin More

€23 EUR in 3 days
(21 Reviews)
4.4
scorpionobaid01

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
(23 Reviews)
4.2
arash18k

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 hou More

€30 EUR in 7 days
(9 Reviews)
4.0
ielucerotrad1

GOT YOUR TASK READY! two hours work so 30Eur is a fair price. No VBA, just one formula (you can modify one cell and copy to the rest in the work area). Send me a message and I can send you print screen of the result. I More

€30 EUR in 1 day
(16 Reviews)
4.0
umairabdillah12

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
(11 Reviews)
3.8
vivirain

Hi, Good day! I’m interested in the task and can try fulfilling your requirements without VBA program. Feel free to contact me if any. Look forward to hearing from you soon! Best Regards,

€20 EUR in 1 day
(11 Reviews)
3.7
IgeS

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 mess More

€25 EUR in 7 days
(5 Reviews)
3.8
zobaer07

Hello, I am an Engineer professional in Content writing, Article writing, Technical writing, Article rewriting, Ghostwriting, Academic writing, Report writing, Essay writing, and Blog writing. I can do your work effe More

€19 EUR in 1 day
(5 Reviews)
3.4