I need an Excel expert to make a Spreadsheet that will calculate a daily study schedule containing 10-20 things to do per day. The study items on the Schedule are based on formulas that calculate percentages of how much time should be spent on each item.These percentages are user-defined and can be changed. A daily schedule for a 2-3 month period must be generated/created (basically, around 90 daily schedules must be generated with each daily schedule different based on the inputs). For each daily schedule, user inputs must be taken into account, such as shower breaks, breakfast breaks, lunch breaks, workout breaks, dinner breaks, other breaks including simple study breaks that should occur after every few hours of studying. It must also take into account vacation days that the user inputs and be able to calculate the accurate percentages of study time for each item factoring in all these breaks. To make things more complicated, some items should only be done once a week or once every two weeks, and the Schedule must be able to figure out how and when to allocate time for these items in the daily schedules. I have a basic schedule that does this which I will forward to you, but it must be significantly improved or a new better once created, especially to take into account the semi-weekly items. Details description : I enclose the spreadsheet I am currently using. In the Study Plans worksheet, I have the formulas for dividing the study time. The study items on the Schedule are based on formulas that calculate percentages of how much time should be spent on each item. These percentages are user-defined and can be changed. In the "Schedule" worksheet, take a look at the comment in the first row. This is a good example of how someone will give me their schedule, and then I need to plug it into the sheet. In the "Schedule" worksheet, I took this information and created a daily row to calculate how many hours the person could study versus how many hours were for breaks or personal matters. The Print Area on this workbook is what I send to the people as their study schedule. Right now I copy and paste rows until the schedule looks OK. I want something that is automatic. The hardest part for me is trying to fit the criteria in around the breaks, etc. For example, lunch should always be around 12PM. Also, there should be a 15 minute or so break after every 2 hours of studying. I don't know how to automate the calculation of this and for the spreadsheet to be smart enough to put everything where it belongs. I only do about 6 days at a time, but I want a daily schedule for a 2-3 month period to be generated/created (basically, around 90 daily schedules must be generated with each daily schedule different based on the inputs). As I explain above, for each daily schedule, user inputs must be taken into account, such as shower breaks, breakfast breaks, lunch breaks, workout breaks, dinner breaks, other breaks including simple study breaks that should occur after every few hours of studying. It must also take into account vacation days that the user inputs and be able to calculate the accurate percentages of study time for each item factoring in all these breaks. To make things more complicated, some items should only be done once a week or once every two weeks, and the Schedule must be able to figure out how and when to allocate time for these items in the daily schedules. Obviously, my basic schedule must be significantly improved or a new better once created, especially to take into account the semi-weekly items. I hope this is very easy for excel experts. I want to complete this in 1 day once accepted the bid. please excuse if its not possible in one day, Dont waste my time. While bidding say "Complete in 1 day" without Quotation at end of your bid so that i know you have read this project description. Please see the attached file and let me know your idea like how you going to do this. Happy Bidding. Thanks Bala