Population Tracking Spreadsheet

I need a spreadsheet to project population for a hypothetical community. The spreadsheet needs to take a list of current community members as input and produce a table/line graph showing the projected population of each city as well total population. The list of community Members must contain the following details: • First Name (text) • Last Name(text) • City (droplist) • Suburb (text) • Household (text) • Data of Birth (date) • Gender (droplist) The spreadsheet then needs to project the population of each city and the total community for each of the next 15 years based on the following assumptions: • Males will be married at 24 (wife will come from outside the community so population will increase by one) • Females will be married at 24 (will marry someone outside the commmunity so the population will decrease by one) • Households will have three children: o First after 1 year of marriage o Second 3 years after marriage o Third 5 years after marriage • People will die at 80 If you have any questions about the project please post them to the public message board so everyone can benefit from the answers. This is required urgently for a project I'm working on for a friend so people who respond quickly with a description of how they will accomplish this will be selected. Regards, Matt.