I like the Rating Scale Field option. In the Response View Table it splits the Header Row into two rows. 1 for the Title of the Rating Scale Box and 1 for the Field Name.
|This is my Rating Scale Title|
|Field 1||Field 2||Field 3||This is my Rating Scale Title|
When I Export Data to an .xls Spreadsheet I get a similat Split Header Row, this makes it Difficult to Filter and Sort on Colums without reformatting the Spreadsheet.
Also a feature Request would be able to control a Field Data Translation i.e. Bad = 1, Good =2 and Best=3 This would allow data in a format that computers can manipulate without a lot of string manipulation. Acrobat IX Form Objects can do this.
As a matter of fact a more robust set of Form Objects with a little simple scripting ability (not necissarily full blown Jave) would turn FormsControl into an AWSOME Application.
If you have improvements to make to our export as excel format you should "Submit Feature Request".
Look for the link on the main forum page http://forums.adobe.com/community/formscentral
You can actually set data values to the choices.
In the View Responses Tab
1) click select the Rating Scale column.
2) click on the Table toolbar button
3) click on the Choices > Edit Choice List...
This will bring up a dialog.
1) click on the checkbox "Assign data values to choices"
2) change the values in the right column
Also, did you know that you can use excel-like formulas in the response table?
Here are a few useful links :
Shortcuts and Functions