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

--we can talk about Price if it feels like too low. --


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

Kemahiran: Excel, Excel Macros, Excel VB Capabilities, Excel VBA, Pengurusan Projek

Lihat lagi: 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

Tentang Majikan:
( 3 ulasan ) Berlin, Germany

ID Projek: #22236090

51 pekerja bebas membida secara purata €24 untuk pekerjaan ini


"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 Lagi

€20 EUR dalam sehari
(205 Ulasan)

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

€25 EUR dalam sehari
(189 Ulasan)

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 Lagi

€30 EUR dalam sehari
(104 Ulasan)

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 dalam sehari
(145 Ulasan)

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] Lagi

€30 EUR dalam sehari
(133 Ulasan)

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 dalam 2 hari
(47 Ulasan)

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 Lagi

€70 EUR dalam sehari
(36 Ulasan)

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 dalam 7 hari
(19 Ulasan)

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 Lagi

€19 EUR dalam 7 hari
(46 Ulasan)

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 Lagi

€30 EUR dalam 2 hari
(44 Ulasan)

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 Lagi

€30 EUR dalam sehari
(53 Ulasan)

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

€24 EUR dalam sehari
(44 Ulasan)

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 Lagi

€23 EUR dalam 3 hari
(21 Ulasan)

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 dalam sehari
(23 Ulasan)

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 Lagi

€30 EUR dalam 7 hari
(9 Ulasan)

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 Lagi

€30 EUR dalam sehari
(16 Ulasan)

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 dalam sehari
(11 Ulasan)

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 dalam sehari
(11 Ulasan)

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 Lagi

€25 EUR dalam 7 hari
(5 Ulasan)

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 Lagi

€19 EUR dalam sehari
(5 Ulasan)