Please see attachment.
I need an interactive table where a user can input different values for hours and pay rates for two different people.
This will then give me a result of the most efficient way to complete as much of the two job lists (one takes 20 minutes and the other takes 80minutes) as possible given the hours inputted.
The pay rates are different so I want the lower rate performing the work first and as much as possible. Unfortunately they can only work from the 20min list.
The 20min list should be fully completed (by either worker) before the remainder of person B's hours moves to the 80 minute list.
Both lists may contain from 0-100 entries.
If possible, it would also be great to highlight the entries in the table which are completed by the given hours.
Thanks, hope it makes sense but am able to clarify anything as needed!
19 freelancere byder i gennemsnit $27 på dette job
Hi Sir I have checked the excel and have written the formula to calculate the hours /week based on the input for each person. I can show you the demo file if required Regards
its a interseting proposal for me.......i have a excellent knowledge of microsoft excel , microsoft ppt ,microsoft acces, .....so i made your project according to your requriment...