BIBEXCEL

A tool-box developed by Olle Persson, Inforsk, Umeå univ, Sweden

olle.persson@soc.umu.se


Bibexcel is designed to assist a user in analysing bibliographic data, or any data of a textual nature formatted in a similar manner.The idea is to generate data files that can be imported to Excel, or any program that takes tabbed data records, for further processing.

This tool-box includes a number of tools, some of them visible in the window and others hide behind the menues. Don't try to learn them all at once. Better to start with what you want to accomplish and then try out the tools for that purpose. Many of the tools can be used in combination to achieve the desired result.

So far bibexcel is a free-ware for academic non-profit use. Don't be too optimistic about my assistance when you start using the program. Still, please report bugs to me!

Keywords (indicating what you can do with Bibexcel):
bibliometric

bibliometry

citation analysis

co-citation

shared references

bibliographic coupling

cluster analysis

prepare bibliometric maps, mapping
Pajek, NetDraw

Bibexcel uses ISI records, SCI, SSCI, A&HCI,
but Bibexcel can also convert other formats


Example:
Life on Mars

Bibexcel-Window
 

Download the latest version
 bibexcel.exe

Always replace old bibexcel.exe with the newest one!
Latest up-date will show at the top of the Bibexcel-window!


Also, download these help-files:
 bibexcel.hlp

 bibexcel.cnt

Please note that these help-files are not updated as fast as the program.

NEW! Please download this "Festschrift" and read the 1st chapter that shows how to use Bibexcel

In some instances you will also need this version of comdlg32.ocx to reside in c:\windows\system. But first, please rename the old comdlg32.ocx in case you will need it for other programs.

Installing Bibexcel
Make a c:\bibexcel directory, and put the downloaded files there!

Now it might even work if you put the files in another drive and directory!

When you start bibexcel.exe the system will tell you if you'll need additional files.

Get them from the net or elsewhere.

Mapping
With Pajek or NetDraw
Bibexcel can produce link-files for co-authorships, co-citations etc, and then convert these for further analysis and visualization with Pajek or NetDraw, both freely available on the net.

MDS and mapping
If you want to use Bibexcel own drwaing features you'llneed an extenal MDS-program.

Please note that, the MDS-software is not distributed here. Bibexcel is designed to let Systat/Dos version 4.1 take care of the scaling. If you have got that program let data.exe, data.def and mds.exe be in the c:\bibexcel directory, or the directory where bibexcel.exe resides. Other softwares, like SPSS and SAS, also have MDS-modules which can be used.

To be able to use the MDS-coordinates in Bibexcel, please be sure that c:\bibexcel contains a text-flile named mapk.dat that lists the coordinates like this:

      -0.030,       0.104
      -1.396,       0.532

      -1.495,      -0.297

       0.219,       0.643

       0.125,       0.506

       1.194,      -0.893

       0.353,       0.235

       0.520,       0.370

       0.261,      -0.108

      -1.594,      -0.642

      -1.563,       0.143

      -1.327,      -0.666

       0.498,       0.238

       0.374,       0.448

..and that another text-file map.ma2 has the matrix values ordered with one value per row, reading the matrix row by row, left to right.
A matrix like this:

1
2    3

4    5    6

must be written like this in map.ma2:

1
2

3

4

5

6

But please note that bibexcel can produce the map.ma2 file, as well as the preceeding lower left matrix!