Using VB Express for Scripting
Update: The recommended Visual Studio edition is now Visual Studio Community. The recommended version is now Visual Studio Express for Desktop. This can be downloaded […]
Monthly Archives: January 2017
Memory Import Threshold with more than 4 Gig RAM
Ruby 64-bit, released first quarter 2016, is up to 45% faster on big jobs, and uses RAM beyond the 2-gigabyte limit. Machines with more than […]
EEFFACE
This error should be obviated in all but the most extreme circumstances by upgrading to Ruby 64-bit edition, released in the first quarter 2016. ———————————————————————————————————- […]
Excel Locales
A common problem with non-English locales is that the locale settings for the decimal symbol as set on Control Panel can be overridden in Excel […]
New Table Export to Excel Available for Trial
In Ruby version 3.x (Ribbon interface) this is accessed from Home | Send to | Excel If you have thousands of tables to export, use […]
Run R from Ruby
It’s looking bad for SPSS: http://r4stats.com/2012/05/09/beginning-of-the-end/ So in keeping with the spirit of the times, the Ruby to R interface has been much extended. The […]
Quantum and Dimensions Levels
Quantum-style levels (as opposed to Ruby variable hierarchies) are now supported. A levels job can have different case counts at each level, and has index […]
Auto-Generate a Blend File for Multi-Response
Despite our best efforts to get Triple-S established as the preferred format for survey data interchange between the collection system and Ruby, the SAV (or […]
Using Windows Compression for Ruby Jobs
Ruby jobs use a lot of files for case data storage. There are many advantages in the way Ruby stores variables (trivial to transfer, simple […]
On the Virtues of ZTree (or comparable file management tool)
Compression reduces disk space (see the Blog entry “Using Windows Compression for Ruby Jobs”), but the multitude of files remains, and a system which uses […]
Brand Indexing
A simple form of indexing we often see is to base on the row average rather than on respondent column counts. This is easily achieved […]
Reversed and Offset Code Means
A common issue is a rating scale collected as 1=worst, 10=best, but for analysis and stats purposes you want 1=best, 10=worst. Similarly, the data collection […]
Batch Processing from the GUI: Codeframes Report
Update 7 March 2016 With Ruby version 3.x and later, the CodeFrames report is accessed from Tools | Codeframes The recent Ruby release has several […]
Batch Processing from the GUI: Axis by Folder
Update 7 March 2016 Axis by Folder (Ruby version 3.x and later) is accessed from Tools | Axis by Vartree Folder See also the topic […]
Batch Processing by Script
We’ve had a few goes at the perfect approach to scripted reports, but I think that this is it. If anyone reckons they have a […]
Debug/Develop Scripts using If 1 = 2 and Exit Sub
A good way to temporarily remove large slabs of code within a subroutine is to fence it as if 1 = 2 then … code […]
Rolling in Ruby
The traditional approach to rolling or moving averages in a cross tabulation is to construct a moving average variable which multiply counts the periods. Such […]
RTools for Visual Studio Community
More details and examples here… http://www.codeproject.com/Articles/1087130/Understanding-the-Visual-Studio-IDE-for-R-language 12 March 2016 Here’s a fascinating development. See https://blogs.technet.microsoft.com/machinelearning/2016/03/09/announcing-r-tools-for-visual-studio-2/ I have tried other IDEs for R in the past […]
SharpDevelop: An Alternative IDE to Visual Studio Express
16Mar2016 A client recently asked about alternatives to VS Express for scripting Ruby jobs. I did a search on “VB.net free IDE” and got to […]
A Beginner’s Guide to Using VB for Ruby
I’m often asked for a quick’n’dirty tutorial on VB scripting. I’ve hunted the internet, but the contenders are either much too complicated for this purpose, […]