You answered the 3 easy questions out of appr. 10 questions.
I know how, in general, you'd handle this in Sweden. But even if I'd be able to find information about the labor law in your country, I really don't know about the specific details in your contracts.
So, if you want help creating that model in Excel, you need to give the needed input.
Oh, and it's quite possible that when you sort this information out for yourself, then you'll be able to create the model on your own. It's not that hard. But if you need help with formulas for calendar dates etc, then we can help here.
A hint, though:
If we assume that a year has 52 weeks (which is not completely true) and are going to count public holidays etc as worked time, then you could say that 4 holiday weeks should be accrued over (52-4)=48 weeks (i.e. one work week gains 1/12 vacation week.
And, correspondingly, 5 holiday weeks would be earned over 47 weeks.