If the reader is to grasp what the writer means, the writer must understand what the reader needs George D. Gopen and Judith A.…
View More The Science of Scientific WritingAuthor: calsalmon
Write data (frame) to Excel file using R package xlsx
Writing to Excel files comes up rather often, especially if you’re collaborating with non-OSS users. There are several options, but I like the xlsx package way of…
View More Write data (frame) to Excel file using R package xlsxHow to choose between Pearson and Spearman correlation?
How do I know when to choose between Spearman’s ρ and Pearson’s r? My variable includes satisfaction and the scores were interpreted using the sum of the scores.…
View More How to choose between Pearson and Spearman correlation?VB.NET – Create Excel file with Pivot Table using VB.Net
In this example I create Excel file with 2 sheets – one with data in table format – another with pivot tableThis code can be…
View More VB.NET – Create Excel file with Pivot Table using VB.NetVB.NET – How to creae Excel file – Simple example
1. Create new project 2. Add reference 3. Select Microsoft.Office.Interop.Excel – ensure Excel is installed. 4. Copy the following code – this will create simple…
View More VB.NET – How to creae Excel file – Simple exampleGIS -> Shapefile -> Visum (Transport Network), known issues + snippet for common error
This post summaries problems, that transport modelers experience while importing GIS data as transport network. It contains solutions for known issues, and free python script…
View More GIS -> Shapefile -> Visum (Transport Network), known issues + snippet for common errorOptimal Count Locator (OCL) for Visum
Optimal Count Locator (OCL) for Visum i2 – Intelligent-infrastructure is proud to present its newest Visum add-on which tells you where to place counting locations…
View More Optimal Count Locator (OCL) for VisumPlate number survey add-in for Visum
From raw input files to Visum OD and travel time matrices. i2 – Intelligent-infrastructure was working hard last months. We struggled to integrate powerful…
View More Plate number survey add-in for VisumChange Node/Link/Zone Numbers in Visum via COM + limit of Visum
I believe anyone who has created once Visum network out of big extrenal datasets (mainly GIS – .shp) came across problems with numbering duplicates. Here…
View More Change Node/Link/Zone Numbers in Visum via COM + limit of VisumHow to get data from Visum COM object fast – test of various ways.
There’s at least some ways that data from Visum can be donwloaded to COM object. To see which one is the fastest I carried out…
View More How to get data from Visum COM object fast – test of various ways.