Customising GetMrData.xls ( Split Data Across Sheets )

In a recent coment we where asked by Nathan to change the

 so that when the get data section is run it spreads the data across multiple sheets. Having the data all on one sheet can be a problem in older versions of excel, as you are limited to a certain amount of columns. This article provides you with this updated 
 and explains how it is done.

Read more

How to use GetMrData.xls

GetMrData.xls has been around for as long as we can remember, but how many of you know about it ? In the article we will show you how to use it and get your data into an excel file. Yes you can export directly out of Data collection to do this directly, but with this file and some customization you could make it do allot more than just that.

Read more

Quick Question : What spec hardware should I buy?

Recently we where asked what spec hardware should we buy for our new Data Collection Interview Server setup, and we had to honestly reply we don’t know, but we know people that might have an in stite on some rules that they used. So … When you purchased your setup , how did you decide what hardware to buy? Did you use any sort of sizing calculator or was it just a guess?

If you did not use any sort of calculator, but have a setup in use and its working for you, what spec machines do you have , how many emails do you send out , and what is your response rate for WEB and CATI ?  How many questions do you have on average in your surveys? What does DimensionNet or Interview Administrator say your max con-currents are ?

We would love to hear from you be it from a comment on this article or a email to if you are willing to send us all your IVW* log files ( from all servers in the cluster )  then that would be great , we plan to run some articles on how we can write programs to read these and work out actual concurrency and then perhaps come up with a sizing calculator. So anything you send us will help us write a realy cool set of articles and scripts. We promise that all confidentiality will be kept and no names will be given as to whose setup is who’s

The Smarter Dimensions Team.

PS We cannot do this without your input !!

%d bloggers like this: