Its still a little difficult to understand what you are trying to achieve. Can you please explain using the sheet that you have attached? Which columns do you need populated and what should be the calculations?

Do you want this done through VBA or formulae?