Create a population of data from given inputs

I have inputs from my boss that will change that describes our forecasted future projects (year, state, total size, etc). I need to take his inputs and create the population of future projects. Right now it's manual.

I am trying to automate this, so that if the details of his inputs change i can automatically update the number of records in the population.  I don't really know how to do this. 

I think I need to create some rules (average project size in New Jersey = 2) therefore if total size in NJ = 20, number of project records in the population = 10.

Any ideas? Would this require VBA? I don't really know VBA