Home   News   Our idea   Products   Methods   Contact   Links   Impressum     Login
  Methods  Categories  Find Method  Find Example
Brief Description
Main Users / Purpose
Advantages & Limitations
Principles & Procedures
References
Example
PDF/Download
Copyright:

Method:

by: MethodFinder

Created: 2002/05


Authors / Editors:
 Michael Becker
 Project Team Members FRCS

 

Merging MS Excel Tables and Charts into ArcView

Advantages / Limitations:

  • Technical staff can be quickly taught how to enter and manipulate data using spreadsheet programmes.
  • Statistical data can be easily entered and manipulated using statistical formulas in the spreadsheet programme.
  • Files can be exported (e.g. in DBF format) or embedded into the GIS.
  • Spreadsheet programmes such as Excel are available in many different (local) languages.
  • High quality charts can be generated in order to visualise the statistical data.

    Attribute data has to be stored separately on the computer and the links to the spatial data (i.e. maps) has to be re-established each time the data is physically moved to another computer.
  • The combination possibilities of datasets from various tables is limited
  • The number of datasets per sheet is limited (e.g. in Excel the limit is to 65.536 records).
  • Statistical formulas used in the table have to be repeatedly copied throughout the whole table.
  • The ability to sort the datasets is limited to only 3 columns of data.
  • The filtering function of the datasets is limited.
  • Data integrity can not be guaranteed and has to be monitored manually.

              
top  |   Select Methods after category