Daily Archives: October 20, 2008

Excel column splitter

Author: Zhuotong Nan ([email protected])

The newest 2007 Excel holds a much larger amount of columns than the old 2003 version. So maybe you are facing the situation you want to convert to the old version but it cannot hold so much columns. Here attached the codes I developed to deal with this situation. The script will separate the sheet holding a large number of columns into several sheets with a specified number of columns.

image 
A screen shot of this script

To use it, import the VBA source codes to your Excel file, open your VBA editor, find this userform, and run it. Before running it, put your cursor on any cell of the data you want to be separated.

The author would like to thank Shugong Wang for his kind help on VBA scripting.

excel.splitter.script.zip

一个多准则决策的图形程序

我们最近实现了一个多准则决策(Multi-Criteria Approach Decision Making)的一些简单算法,Qt 4实现,代码可以全部主流平台上编译。更多算法以插件的形式添加进来。

image
value function (analysis matrix -> evaluation matrix)

image
indicators简单加权实现及solution ranking