Web Admin
Quantitative Jobs 2 – UK Power Grid – Demand and Supply
14Apr2020 Updated to midnight 12Apr2020 Also now available as a PDF: GridwatchUK_Demand_and_Supply.pdf 29Jan2019 See the previous post on AEMO for a general overview of handling […]
Quantitative Jobs 1 – Australian Eastern Power Grid – Demand and Price
5May20: updated to end of Apr20. Update 9Apr20: All charts updated to end of March20 Last30Day, Last30Months and Last26Week charts added to the All set […]
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
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 […]
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 […]