1.) Create a new spreadsheet (from Menu Entry), and generate a Google Query Script based off of selected items from the previous spreadsheet, as well as adding another column and conditional formulas.
2.) Create a new spreadsheet off of the generated Google Query (from Menu Entry), that takes into some account specific inputs that are entered by the user.
3.) Once that last sheet is generated, we'll need an "association" between that output and any changes in the query over time, linking the output to specific ID's.
I can obviously elaborate quite a bit more, but this is just a series of loops and arrays that I need built, and for anyone familiar with the Google Query I can document this sufficiently to give you all of the info you need. I would like to get this done relatively quickly.