博文

BibExcel

已有 16480 次阅读 2016-7-7 20:47 |个人分类:知识图谱|系统分类:科研笔记

BibExcel has been made available here courtesy of his creator, Olle Persson.

A tool-box developed by Olle Persson

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!

See BibExcel exercises at the bottom of this page!

Keywords (indicating what you can do with BibExcel):
bibliometric, bibliometry, citation analysis, co-citation, shared references, bibliographic coupling, cluster analysis, prepare bibliometric maps for mapping withPajek, NetDraw. BibExcel uses ISI records, SCI, SSCI, A&HCI, but BibExcel can also convert other formats

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 and bibexcel.cnt
Please note that these help-files are not updated as fast as the program.
In some instances you will also need this version of comdlg32.ocx to reside in c:windowssystem. 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.
BibExcel also runs under Linux using "wine"
Mapping - use Pajek!
BibExcel can produce net-files for co-authorships, co-citations etc, and then convert these for further analysis and visualization with Pajek. BibExcel can also make clu-files and vec-files for Pajek. Pajek is freely available on the net. Download this version to match the exercises below: http://vlado.fmf.uni-lj.si/pub/networks/pajek/pajekBE2.exe.

BibExcel exercises

1	Download test data (569 Web of Science records on co-citation studies)
2	Preparing data from downloaded datasets
3	Mapping co-authorships with BibExcel
4	Shared units/coupling
5	Mapping science using BibExcel and Pajek
6	Making tables with BibExcel for Excel
7	Author addresses with BibExcel
8	Classification, recoding and adding new field tags with BibExcel
9	Matching source and cited journals
10	Calculating h-index using BibExcel
11	Making Google Maps
12	BibExcel to VOSviewer
13	Mapping and joining clusters
14	Matching records with titles
15	Building matrices and normalization
16	Price's Index Calculation

Read more about the use of BibExcel in this "Festschrift"

How to cite BibExcel
If you use BibExcel, please inform the readers of where to find the software (here!) and please also cite this publication which has a good description of BibExcel:

Persson, O., R. Danell, J. Wiborg Schneider. 2009. How to use Bibexcel for various types of bibliometric analysis. In Celebrating scholarly communication studies: A Festschrift for Olle Persson at his 60th Birthday, ed. F. Åström, R. Danell, B. Larsen, J. Schneider, p 9–24. Leuven, Belgium: International Society for Scientometrics and Informetrics.

Audiovisual Documentation
Furthermore videos of the course "Building collaborative netwo

Videos of the course "Building collaborative networks". Polytechnic University of Valencia, July 2012. Updated to 2016 course https://www.dropbox.com/sh/c9eioqls7ttwghc/AACCfwsaXLZveEUsXEgdQR-ia?dl=0

If you are interested, please contact with Luis.M.Gonzalez@uv.es

To cite these materials, please use:

Peset, F. Gonzalez, LM. (2012). Building networks with Bibexcel, Pajek, Vosviewer and GPSVisualizer. Available in: http://personales.upv.es/mpesetm/

1 Search

http://dl.dropbox.com/u/57069747/Redes/1BusquedaPesetyGonzalezBibexcelSP.mp4

2 Add files and Prepare

http://dl.dropbox.com/u/57069747/Redes/2UniryprepararPesetyGonzalezBibexcelSP.mp4

3 Extract one field

http://dl.dropbox.com/u/57069747/Redes/3Extraer%20un%20campoPesetyGonzalezBibexcelSP.mp4

4 Frecuencies

http://dl.dropbox.com/u/57069747/Redes/4FrecuenciasPesetyGonzalezBibexcelSP.mp4

5 Normalization

http://dl.dropbox.com/u/57069747/Redes/5NormalizarPesetyGonzalezBibexcelSP.mp4

6 Coauthor

http://dl.dropbox.com/u/57069747/Redes/6CoautoriaPesetyGonzalezBibexcelSP.mp4

7 Citation local map

http://dl.dropbox.com/u/57069747/Redes/7MapaCitacionLocalPesetyGonzalezBibexcelSP.mp4

8 Cocite

http://dl.dropbox.com/u/57069747/Redes/8CocitacionPesetyGonzalezBibexcelSP.mp4

9 Bibliographic coupling

http://dl.dropbox.com/u/57069747/Redes/9BibliographicCouplingPesetyGonzalezBibexcelSP.mp4

10Geolocalizer

http://dl.dropbox.com/u/57069747/Redes/10GeolocalizacionPesetyGonzalezBibexcelSP.mp4

11Geolocalizer with coauthor

http://dl.dropbox.com/u/57069747/Redes/11GeolocalizacionyCoautoriaPesetyGonzalezBibexcelSP.mp4

For other issues, visit the website CIEPI Group: http://www.ciepi.org and DATASEA project: http://www.datasea.es

This is the Fernanda Peset’s personal page http://www.directorioexit.info/ficha234

UPV

Videos del curso “Construcción de redes de colaboración”. Universidad Politécnica de Valencia, julio 2012. Actualizados en 2016 https://www.dropbox.com/sh/c9eioqls7ttwghc/AACCfwsaXLZveEUsXEgdQR-ia?dl=0

Si estáis interesados en contactar con nosotros escribid a Luis.M.Gonzalez@uv.es.

Para citar los materiales utilizad:

Peset, F. y González, LM. (2012). Construcción de redes de colaboración con Bibexcel, Pajek, Vosviewer y GPSVisualizer. Disponible en: http://personales.upv.es/mpesetm/

1Búsqueda

http://dl.dropbox.com/u/57069747/Redes/1BusquedaPesetyGonzalezBibexcelSP.mp4

2Unir y Preparar

http://dl.dropbox.com/u/57069747/Redes/2UniryprepararPesetyGonzalezBibexcelSP.mp4

3Extraer un campo

http://dl.dropbox.com/u/57069747/Redes/3Extraer%20un%20campoPesetyGonzalezBibexcelSP.mp4

4Frecuencias

http://dl.dropbox.com/u/57069747/Redes/4FrecuenciasPesetyGonzalezBibexcelSP.mp4

5Normalizar

http://dl.dropbox.com/u/57069747/Redes/5NormalizarPesetyGonzalezBibexcelSP.mp4

6Coautoria

http://dl.dropbox.com/u/57069747/Redes/6CoautoriaPesetyGonzalezBibexcelSP.mp4