In our last article we showed you the steps that you need to take to produce tables in Data Collection. Open the data , create the table structure , populate the tables and then export. In this article we will spend some time showing you how to create some of the different tables that you may need and some of the basic additions that we need to add to our script to make it run smother.
Xcel Export V1.1.029 FULL RELEASE is now available.
Xceed Technologies has created an application that allows you to export your data into Excel fast and easy. Some projects take 40 minutes or more to export to Excel from your IBM SPSS Data Collection Base Professional Studio application or Survey Reporter. Xcel Export can export 100’s of tables in just 2 – 3 minutes, with visual features.
Xcel Export can provide:
- Running Excel tables faster than usual
- Table of Contents, with detailed information and hyperlinking to each table
- Better formatted Table of Contents with template
- Save Projects and Load Projects
- Command-Line runner
- Option for using standard theme/clearing theme
- Option for using a logo
- Positioning logo
- Freeze Panes of Axes
- Option for Showing/Hiding Grid Lines
Please visit: http://www.xceed-tec.com/index.php/application-showcase/xcel-export for more information.
In the past we have done lots of articles about creating surveys and all the things that you might want to do with them , so now we thought it was time to run some articles on tabulation. As you know , we have four products that you can use to create tables in Data Collection and in these articles we are only going to use Professional and scripts. So in this first article we will look at how we load up a datafile create one table and export it to HTML.
Recently we where asked how do you put comments in your scripts. This quick post shows us that you can have two types of comments. The first is the block comment. To create a block comment place a ‘! at the start of the bit you want to comment out and then a !’ at the end and you will see that you have commented out that section.
Routing(Web) '! * Survey Description : Comments * Last Updated : 16th June 2011 !' Q1.ask() ' **** End of Survey End: End Routing
The next type of comment you can have is a single line comment. To create a single line comment place a ‘ at the front of the line that you want to comment out.
when we ran our article on question types we did not touch on one of the more complex types. In this article we will look at Compound Questions. You see this type of question more in Web and paper surveys as they offer a unique way at representing the allowable choices.
We received a comment on a post recently that lead us to this site which we thought you might be interested in. 22Surveys is a site in Amsterdam run by Dennis Sewberath. Dennis has been a Survey Developer and Designer and has been creating and designing surveys for many years and loves to share his ideas and opinions. He tries to use only open source and free software and code to show you his ideas and examples for online surveys.
His latest post was on clickable images using CSS for Data Collection and we think its worth a look.