Random numbers meeting 3 conditions

oddy73

New member
Joined
Feb 25, 2015
Messages
10
Reaction score
0
Points
0
Hey guys,

I need this function or code that produces random numbers that meets some conditions.
I asked post a similar problem in the following website Ozgrid and MrExcel , but they were not able to help me. I also asked a similar question on this forum but in the formula section, but unfortunately no answer.

I have restructured my sheet and my question, hopefully this time we can solve this issue.
As you can see in the attachment I have this timesheet of a person of January 2015. I have all the information I need to populate the timesheet but I want the numbers be randomly divided over the days and projects.

I already filled the hours as an example, but I want this via some code or formula.
  • So this person works on 2 projects.
  • He can work 176 tot in this month.
  • A workday has 8 work hours
  • Weekends they are off
  • The sum of project 1 should be 106 hours
  • The sum of project 2 should be 70 hours
  • The numbers generated should be random but should meet the above conditions!!

I hope I am clear to what I am asking.
 

Attachments

  • Timesheet_v0.1.xlsx
    15 KB · Views: 12
Back
Top