I need to know how this situation can be solved

Lets say I need to distribute documents among translators. Each of them is able to translate max 6 pages per day. lets assume that translator Luka is assigned with document to translate.
this document contains 18 pages and the date that document was given to him is 18/01/2006 with deadline 24/01/2006, and meanwhile comes another document which I would like assign to him this document is given to him 19/01/2006 with deadline on 31/01/2006 and it contains 30 pages: What I would like to know is if he is able to translate this one, if he already has the first document assigned to him.

And is C# the right tool for doing this or is some other tool more suitable

Saban,

You have posted a question about the suitability of C# on a VBA message board so I'm going to answer with reference to these two languages but bear in mind that any other language could be used.

The problem described is a relatively trivial programming exercise. Because the processing required to do the scenario described is minimal you could pretty much choose any programming language you wanted. In particular C# is a much more powerful language than VBA and is pre-compiled as opposed to VBA which is compiled at run-time. This means that C# is probably going to be in the order of 10 times quicker to run but when the program is going to take milliseconds (as the situation described would) then its a bit meaningless. If, however, your situation is changed and you are planning to process thousands of these situations simultaneously then you may start to find that processing speed becomes an issue.

The other factor to consider is the amount of time that the program will take to put together and how robust it will be. Basically this boils down to how quickly you can learn a given programming language to the necessary level to get the program running and properly debug it. If you have any programming experience then I'd recommend that you use what you know as there are no real speed limitations. If you have no experience then I'd recommend you try to use VB or VBA as they are specifically designed to be easy to pick up and use.

Having decided on a language you're going to need some sort of reference book to teach yourself the basics. I can't really recommend one as I've never bought such a book but there are plenty around and I'm sure they all do a decent job.

If you decide to use Excel VBA, which would be fine for the situation described, and are stuck on a particular aspect of getting the program working post back here and we may be able to help you with a bit of code.

Maccas

I would be very gratefull if you could help me out with this one. I would prefer doing it in VBA because I know something about VBA(not much) but for C# I know as much as my grandma knows about nuclear science :)
I tried already to solve this situtation with excel formulas but i didnt quite manage. So I will send you example of my workbook if it helps?

Thnx for all your time and help

How can i send you my workbook? Is there any attachment option? Sorry for my English I am from Slovenia
(and weekends shall be excluded-translators are free for the weekends)

I'm a bit too busy to have a look at a whole workbook today. If you have a query about what formula to write where or a specific bit of code to do something then maybe someone else will be able to help out.

Also I'm not sure you can attach files to these posts. Maybe someone else could lcear that one up?

Maccas