We are looking for someone to build us an Excel workbook that can be used to track school lunch orders. We've created a master class list that includes the names of each student (by grade) and their lunch selections for each day of the month. We will receive hard copy order forms and input the orders into this workbook manually.
## Deliverables
1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).
2. From this input, the following outputs are required: a. Report listing daily number of orders by order type (there are 16 order types), aggregated for an entire month (i.e. daily totals of each type for the entire school as well as by grade); b. Weekly and daily reports of lunch orders by student, by grade (i.e. all of the first grade student's orders for Tuesday/Wed/etc. that can be printed daily and weekly. 3. Copies of MS excel workbooks/templates that can be easily used by non-technical people to replicate the order process each month. Ideally, we'd like to use one workbook per month but be able to easily replicate it for the following month. 4. Instructions on how to run the reports listed above.
## Platform
MS Excel (1997-2003)