We have a job that we print every week for the school district that consist of standardize test. Currently we are printing 60 tests for every grade and every school. So on a week with three tests the drop would look like the following:
Elementary School A
60 Grade 1 Math Test
60 Grade 1 English Test
60 Grade 3 Science Test
Elementary School B
60 Grade 1 Math Test
60 Grade 1 English Test
60 Grade 3 Science Test
Elementary School C
60 Grade 1 Math Test
60 Grade 1 English Test
60 Grade 3 Science Test
And so on….
We get it to come off the printer exactly like this by printing the contents of a folder which has the three pdf files and sending to a queue on our printer that auto formats the job and sets the print count to 60.
There is talk about printing the exact student counts in the coming school year and I want the work to come off the same way, by school, if possible. So I would like by drop to look like this:
Elementary School A
100 Grade 1 Math Test
107 Grade 1 English Test
145 Grade 3 Science Test
Elementary School B
55 Grade 1 Math Test
63 Grade 1 English Test
87 Grade 3 Science Test
Elementary School C
145 Grade 1 Math Test
122 Grade 1 English Test
170 Grade 3 Science Test
And so on….
My initial question is, is there a piece of software out there that can do this by reading an Excel spreadsheet and the name of the file and generate the proper counts to the printer?
If not or if you know a better way of accomplishing my goal I would appreciate any ideas.
Elementary School A
60 Grade 1 Math Test
60 Grade 1 English Test
60 Grade 3 Science Test
Elementary School B
60 Grade 1 Math Test
60 Grade 1 English Test
60 Grade 3 Science Test
Elementary School C
60 Grade 1 Math Test
60 Grade 1 English Test
60 Grade 3 Science Test
And so on….
We get it to come off the printer exactly like this by printing the contents of a folder which has the three pdf files and sending to a queue on our printer that auto formats the job and sets the print count to 60.
There is talk about printing the exact student counts in the coming school year and I want the work to come off the same way, by school, if possible. So I would like by drop to look like this:
Elementary School A
100 Grade 1 Math Test
107 Grade 1 English Test
145 Grade 3 Science Test
Elementary School B
55 Grade 1 Math Test
63 Grade 1 English Test
87 Grade 3 Science Test
Elementary School C
145 Grade 1 Math Test
122 Grade 1 English Test
170 Grade 3 Science Test
And so on….
My initial question is, is there a piece of software out there that can do this by reading an Excel spreadsheet and the name of the file and generate the proper counts to the printer?
If not or if you know a better way of accomplishing my goal I would appreciate any ideas.