Hi, i need to create a spreadsheet with a Gant chart that auto populates when i enter in some data/constraints. Basically the spreadsheet will consist of rows of retail stores. I must be able to rank the stores, specify the duration they will be running and how many stores can run in a given period. The Gant chart must then auto populate. Please let me know if this is unclear.