I don't know if it's alowed to ask questions about design ideas and if my question is at al solvable in excel. But here's my situation, ill try to explain as good as i can:
I have imported a whole bunch of data, from an access database. in this database there is a deals table. From that table i get my values. here are the most important values.
1) volume certificates sold
2) period from
3) period to
and from another table i get my expected volume of certificates per month.
What i now have to do is create a table/sheet that calculates the difference between certificates sold and expected certificates. The difficult part is that Period from to is flexible. for example: if period from is january and period to is march, you can sell from january february and march. So what i have done is set all flexible volumes to the first month possible i.e. the month from. But what i now have to do is: if the result between volume sold and volume bought is negative, i have to put some flexible volumes to the next month. for example if there is a negative number in january. the flexible volume mentioned earlier will be set to february, this will be done with flexible volumes till the result is positive. i will make a little example file and add it to the question.
Hope someone has great ideas! Thanks in advance!