Quantitative Jobs 2 – UK Power Grid – Demand and Supply
29Jan2019 See the previous post on AEMO for a general overview of handling quantitative (as opposed to categorical) case data. If you have Ruby5 (Cloud […]
Web Admin
Qantitative Jobs 1 – Australian Eastern Power Grid – Demand and Price
26Jan19 Ruby is primarily a survey analysis tool, with default behaviour generally oriented towards making it as easy as possible to count the number of […]
Dynamic TopBox / BottomBox
Here’s an interesting scenario from a client: We have set up our nets for TB and BB on a rating scale from 1/10 as 8/10 […]
Importing Fat SAVs
Memory issues from SAV files with many tens of thousands of variables have arisen occasionally, more so on Win32/Ruby32, but you could also have problems […]
Counting Topbox Ratings Across Multiple Brands
Consider a bank of ratings questions like the FavRat set in the Ruby Demo job. The mission is to construct a variable which counts the […]
Updating Reports
You can force auto-updating of reports here: But note that this is a * […]
Lock Codeframes Against Imports
A common problem for tracking jobs is that the variable descriptions and code labels as delivered by the source system can be unsuitable for analysis. […]
New Table Export to Excel
In Ruby versions 3.x (Ribbon interface) and later, this is accessed from Home | Send to | Excel […]
EXCEL Locales
A common problem with non-English locales is that the locale settings for the decimal symbol as set on Control Panel … […]
When My Imports Go One Case at a Time and Take Forever
Ruby 64-bit version should make this henceforth a rare circumstance, but with big data beating at our doors, the advice below remains useful. ——————————————————————————————————- This […]
Perceptual Map Labels in MS Office
Here’s how to easily label map points after importing the coordinates. The example table is EDU by Income. • Download and install XYChartLabeler from http://www.appspro.com/Utilities/ChartLabeler.htm This […]
Three Ways to Set Series Defaults
House standards for chart series colours can be set in a default job.ini file. You set the default series properties on Preferences | Job Series: […]
active-x-cant-create-objects
To automate Ruby via VBscript, JScript or VB.Net and for Ruby to communicate with MSOffice (via Exports.js) and for MSOffice to communicate with Ruby (via […]
Using VB Express for Scripting
The recommended version is now Visual Studio Express for Desktop. This can be downloaded from https://www.visualstudio.com/en-us/products/visual-studio-express-vs.aspx Microsoft is constantly changing the download point, so if […]
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. ———————————————————————————————————- […]
When my Imports Go One Case at a Time and Take Forever
Ruby 64 bit edition should make this henceforth a rare circumstance, but with big data beating at our doors, the advice below remains useful. ——————————————————————————————————- […]
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. From […]