Don't know if this is an easy way, but it works; creates an txt file that opens in Excel. Solution has no error checking etc., e.g. the scripts work under the assumption that each Student actually has 600 Standards entries.
If this is not the case, then you can modify the Standards Export script to write empty values to fill the sequential gaps. (Or, if you haven't done so already, modify your solution to create 600 entries for each Student by default, so there are no gaps and empty values are actual data.)
You could also set up a calculation in the students table for :
1. The column headings as a global separated by commas
2. The record rows calculating the value for each standard related separated by commas. Record 1 has the global field added at the top separated by a carriage return.
Then just export the single field in #2 as a CSV.
Consider having a layout with the Student's name and a portal showing the Standards.
Then just switch view to Table View and use the Save/Send Records to Excel menu item.
[by futzing with the field names in Standard table you get what you want]
Brian Excel.fp7.zip 7.9 K
Thanks to everyone who replied.
Eroist: Both of your scripts did exactly what I needed, very neat. I was on to the idea of using a list but I was just doing a regular export and I would lose the tabs. I've never used the exportfield contents. That seems very powerful.
Dr. Brian Garman
University of Tampa