Note: to use the tem data capture worksheet ms excel version 0a or later must be installed on your workstation




Скачать 20.96 Kb.
НазваниеNote: to use the tem data capture worksheet ms excel version 0a or later must be installed on your workstation
Дата конвертации10.02.2016
Размер20.96 Kb.
ТипДокументы
источникhttp://www.env.gov.bc.ca/esd/distdata/ecosystems/wis/tem/userguide/dc_instruct.rtf
NOTE: TO USE THE TEM DATA CAPTURE WORKSHEET MS EXCEL VERSION 5.0A OR LATER MUST BE INSTALLED ON YOUR WORKSTATION.


PLEASE READ ALL INSTRUCTIONS BELOW CAREFULLY AS IT WILL ASSIT YOU IN RUNNING THE APPLICATION PROPERLY


The current version of the Terrestrial Ecosystem Mapping (TEM) Data Capture (DC) application is supplied by the Ministry of Environment, Lands and Parks. All necessary files to run the application are contained within the file temdc01.exe.


The version is identified in the name by a 2 digit number (e.g. temdc01.exe). The highest number (i.e. 01, 02, 03) is the most recent version. Always download the most recent version.


TO INSTALL THE TEM DC:


  • place the temdc01.exe into c:\temp directory (or other if you choose);

  • double click on temdc01.exe; (this will bring up the install wizard) and

  • let it install into c:\tem\project1 or the destination of the user's choice.

  • to change the default directory click the Browse button and select another directory.


Warning: The setup program will place the TEM DC application (i.e. temdc01.xls)

in the destination directory. If the file already exists in the destination directory it will

be overwritten.


Once it is installed, open the temdc01.xls by:

  • Double clicking on TEM DC Icon;

  • or in Windows 95, 98 or NT go to - ‘start’, ‘programs’, ‘tem’, "tem dc" or

  • run MS Excel and open temdc01.xls in the directory where it was installed (usually c:\tem\project1).


Once the temdc01.xls is open:

  • Input data into the worksheet; or

  • Copy and paste data from other source into worksheet.


Once data is loaded (or during loading process);

  • Save worksheet under new name, ex. TFL###.xls


NOTES:

  • Be sure to save this worksheet in c:\tem\project1 (or wherever you have installed the TEM DC);

  • The blue highlighted columns are the columns that are mandatory and must be filled in;

  • The purple columns indicate the column is mandatory where appropriate.


For example:


Site_S (Site Series) and Site_MC (Site Map Code) at least one of these columns must be filled in, both columns may be filled in, but at least one, OR

Struct_S (Structural Stage) must be filled in if the Site_S or the Site_MC requires it.


  • Any columns that have no highlighting, can be deleted and it will not affect the validation.



WHAT MUST BE FILLED IN: (all mandatory attributes)

  • Project Tab;

  • Polygon Tab;

  • User Defined.


NOTE:

If you are unsure as to what information or what format is required for project or polygon information, please see Table 2-2 of the TEM Data Capture Standards, Version 2.0.


NOTE:

This application was built to the 1998 Standard for Digital Terrestrial Ecosystem Mapping (TEM) Data Capture in British Columbia, so there are some mandatory attributes that were not collected prior to the release of the 1998 standards. The attributes are:


  • Trim_Nbr - (Trim Version)

  • TSIL - (Terrain Survey Intensity Level)

  • Recor_Name - (Recorder Name)

  • Air_Yr - (Air Photo Year)

  • Pho_Sc - (Air Photo Scale)

  • Pho_Type - (Air Photo Type)

  • Pack_Nbr - (Version of Package Used)

  • Tern_Map - (Terrain Mapper)

  • Dig_Cap - (Digital Capture)



If the data being entered does not include these attributes, the user can fill in the missing information with the following:


  • Trim_Nbr - 1

  • TSIL - A

  • Recor_Name - ????

  • Pho_Yr - 1900

  • Pho_Sc - 20000

  • Pho_Type - 1

  • Pack_Nbr - 1

  • Tern_Map - ????

  • Dig_Cap - ????


USER DEFINED INFORMATION


The user defined table is for inputting information that is correct but has yet to be approved. Common user defined codes are Site_MC (Site Map Codes).

It is important to fill out columns possible for each user defined code. Here is an example of the columns the user must fill out a user defined Site Map Code:



  • Applies to; Ecosystem

  • Column name; Mapcode

  • Value type; C (for character)

  • Length; 2

  • Required; Y

  • Case; U (upper)

  • Description; and BGxh3

  • Value. JR



TO VALIDATE A DATASET:


Once all mandatory columns have been populated, and all other data entered that is available, be sure to save a copy of the worksheet in the same directory where the DC is installed (generally c:/tem/project1).

On the menu bar, choose 'tem', 'verify'.

Once the pop up screen appears, choose 'verify'


NOTE:

Option # 1 for viewing error report:

When the pop up screen appears and the user is given the choice to verify, there is a box that is checked that says "use excel". If the box remains checked, once the error report is complete, a list of errors will pop up in an excel window and show all errors found. The user can then click once on an error and the system will take you directly to that error. However, the user cannot copy this list!

Option # 2 for viewing error report:

When the pop us screen appears and the user is given the choice to verify, there is a box that is checked that says "use excel". If the user removes the check, once the error report is complete, a list of errors will pop up in a notepad window and show all errors found. This list will provide the location of the error, but will not take the user directly there.

However, the user can copy and save this list!


HELPFUL MACROS:


If the data is clumped, i.e. site modifiers jp, the user can split out modifiers to j p. To do this, highlight the column BUT VERY IMPORTANT, do not highlight the column header, (i.e. Site_M1) as the macro will split that word out, it gets messy, just put the cursor at the top of the data and highlight to the bottom of the data and hit "ctrl s". This will take each individual character and put it into the next column. This is a helpful function for other attributes commonly clumped together, such as Surface Expression and Terrain Texture etc.


If the data for Disturbance Class is clumped, the use can split the codes into two single characters then a double character, i.e. Fiwn needs to be F i wn. Once the data in the column is highlighted, IMPORTANT, just highlight the data, not the column heading,

use the macro "ctrl t" and this split it out accordingly.


To speed up the validation process or to make viewing the data easier, the user can delete all columns that do not contain data (except mandatory columns). Once the data in the column is highlighted, IMPORTANT, just highlight the data, not the column heading,

use the macro "ctrl d". It is strongly suggested that this macro be used after all of the data has been entered and validated, as data is often entered into the wrong column and the column must be re-inserted with proper header names.


To change the case of codes, i.e. a to A or B to b, use the macros "ctrl u" to change case from lower to upper and "ctrl l" to change case from upper to lower.

Похожие:

Note: to use the tem data capture worksheet ms excel version 0a or later must be installed on your workstation iconComputer Workstation Risk Assessment and Control Worksheet Deakin University

Note: to use the tem data capture worksheet ms excel version 0a or later must be installed on your workstation iconImporting an Excel Worksheet into sas

Note: to use the tem data capture worksheet ms excel version 0a or later must be installed on your workstation icon\\irc-w03-arcgis\arcmap data\gis data\vast\agriculture in usa data

Note: to use the tem data capture worksheet ms excel version 0a or later must be installed on your workstation iconThese course notes are intended to be used as an introduction to ms-dos version 0 although much of the material is also relevant to version 6 and its

Note: to use the tem data capture worksheet ms excel version 0a or later must be installed on your workstation iconThe latest way: Run sas and the next moment you see a nice graph in an excel sheet (though it still requires some excel work to get the first excel graph done)

Note: to use the tem data capture worksheet ms excel version 0a or later must be installed on your workstation iconExcel программасын жүктеу үшін тапсырмалар тақтасындағы Іске қосу (Пуск) батырмасын таңдап, Программалар қатарындағы Microsoft Excel жолында тышқанды шертеміз
Пуск батырмасын таңдап, Программалар қатарындағы Microsoft Excel жолында тышқанды шертеміз. Егер жұмыс үстелінде Excel программасының...
Note: to use the tem data capture worksheet ms excel version 0a or later must be installed on your workstation iconДӘріс №16 microsoft excel электрондық кестесін қҰру жоспар
Ол Excel программасын іске қосқаннан кейін компьютер экранында терезе шығады (программаны баптауа байланысты өзгеруі ықтимал.)
Note: to use the tem data capture worksheet ms excel version 0a or later must be installed on your workstation iconРеферат Транспортные задачи в Excel
Решение классической сбалансированной транспортной задачи в Excel
Note: to use the tem data capture worksheet ms excel version 0a or later must be installed on your workstation iconThe Excel Interface t he names of the various parts of the Excel interface are shown above. Standard Toolbar

Note: to use the tem data capture worksheet ms excel version 0a or later must be installed on your workstation iconMövzu 1: Microsoft Excel cədvəl redaktoru haqqında ümumi məlumat
Пуск –Программы Microsoft Offise Microsoft Excel 2007 əmrlərini ardıcıl seçirik
Разместите кнопку на своём сайте:
Документы


База данных защищена авторским правом ©kzdocs.docdat.com 2012
обратиться к администрации
Документы
Главная страница