Hello. I need some help with a project I am developing for an accounting course I teach. In this project, the students are given 13 spreadsheets in a workbook, each of the first 9 of which having a number of cells in which they must make entries (about 50 in all). All students have common entries in about 30 of these cells, but in 20 they have unique entries so that no two people have the same entire project. The student performance is judged on four output cells that calculate from the inputs made by the student. All of their inputs are referred to by established calculations and then their final values in pro forma financial statements are graded.

So... when building my key, I can fill in the common values... but how do I set up inputs 1-20 and outputs 1-4 in a single spreadsheet? I've used a data table before, but that's not quite this I don't think. What I need here is some way of building a table of inputs so that when I have the name in column A, and all their inputs shown in columns B-U, the workbook would theorize the placement of those values in the various correct spots in the workbook and then report back the calculation the four outputs in columns W-Z. I have 105 students, so I would have 105 sets of data for this. The way I think of it is "if these 20 values were entered into these 20 cells, this would be the result for, for example, Net Income." Then, in the row below, the another set of 20 and a different answer.

I hope I have explained this well... and I appreciate any help!!

Tom