Projects calendar by priorities

[zgoda]

Hello guys.

Im with a problem. I have this attached report, with a calendar that i found in the internet.

In the first Sheet "Projects" I have to input the projects that me and another friend are working on.

I need that in the Sheet Calendar, the working days (monday to friday) would be filled when there is any project in that period assigned in the sheet Projects.

And, in the projects, if any project with a higher priority ends inside the period of one of minor priority the start date of the minor would be pushed forward to start in the last day of the higher +1.

I've searched dozens of sheets in the net and couldnt find any that would solve my problems, i think that this is a Visual Basic need.blema.

Anyone can help me? Or anyone knows any other ready sheet that could solve my problem?

Thanks in advance guys!

https://drive.google.com/file/d/0B-HgHi16qG_uTHNIcWJIUWotdFE/view?usp=sharing

 

[zgoda]

If we are already inside the running days of the project Mary, the project banana would be delayed unitl Mary is completed. If the project Banana was inserted before the start date of Mary, like Feb 17th, if Mary started 18, the Mary would be postponed until the end of banana, because of the higher priority.

Running projects in the actual date are not affected by insertions. You are obligated to insert any activities after the end of current running project.Hope this helps.I've searched dozens of sheets in the net and couldnt find any that would solve my problems, i think that this is a Visual Basic problem.

 

[zgoda]

Anyone?

I think this is too hard.. lets go by steps. i think that a formula will solve this.

First, i want to discover how i do to, in column "H", bring me the project date rearranged, as the following rule:

* If more than one project happens in the same time interval, as in the next example, the one with higher priority will keep its start date, the others with lower priority would start on the next working day (monday to friday) after the end of the with higher priority and then successively.

I've created that numers after column "O" so i had any idea of rules, but it is dispensable if you want.

Sincerely.

https://drive.google.com/open?id=0B-HgHi16qG_uZWU0ZnpTYzEzS28

 

[zgoda]

anyone?