manualshive.com logo in svg

Christ Elektronik CLM1000 Professional, Инструкция по эксплуатации, Страница: 21 / 23

Поделиться
Скачать
Christ Elektronik CLM1000 Professional Скачать руководство пользователя страница 21

 

E461756 

20 

C

C

C

L

L

L

M

M

M

1

1

1

0

0

0

0

0

0

0

0

0

 

 

 

7.4

 

Import *.csv files  

 
Import the data in the corresponding program before treating text files in spreadsheet software 
like Microsoft Excel

®

 or Apache Open Office™ Calc. The following instruction indicates step for 

step how to import *.csv files in Microsoft Excel

® 

2010. Refer to the corresponding handbook 

when using another program. 
 

1.

 

Open Microsoft Excel

®

 2010 to treat the *.csv file. 

2.

 

Select the tab "Data".

 

 

 

3.

 

Click the button „From text“ in the group "Get external data".

 

 

 

 

 

 

4.

 

Once in the pop-up window "Import text file" navigate to the folder in which the *csv file 

is stored. Mark the file and click on "Import".

 

 

 

 

 

 

 

 

 

Содержание CLM1000 Professional

Страница 1: ... www christ elektronik de Copyright It is forbidden to reproduce or process using electronic systems copy or distribute any part of this document Translation into another language requires written authorisation This document is for the personal use of the owner of the device or Christ Elektronik GmbH personnel only Technical modifications Christ Elektronik GmbH reserves the right to modify the des...

Страница 2: ...fessionalFehler Textmarke nicht definiert 2 3 3 Description of the ON Function 8 3 Interface only Plus Version 9 4 Error handling 12 5 Technical data 13 5 1 CLM1000 variant types and measurings 13 5 2 Display and operation 14 5 3 Measuring principle and accuracy 14 5 4 Voltage supply 14 5 5 Enviroment and dimensions 14 6 FAQ 15 7 Software and data evaluation 16 7 1 Installation of the VCP driver 1...

Страница 3: ...r on the back of the device shall not be opened Warranty voids if the device is opened DANGER Ensure that any repairs to the unit are carried out by qualified personnel Substantial risk for the user arises from improper repairs Liquids and dust shall not enter the device Don t expose the device to humidity or solar radiation for any length of time DANGER Connect the CLM1000 only to approved securi...

Страница 4: ...e different modes using the arrow keys Approve the settings with the OK key CLM1000 Example Reading 1 Unit of reading 1 Reading 2 Unit of reading 2 3 9 Page 3 of 9 Keys 2 2 Contrast setting The contrast setting is saved after switching off the wattmeter The contrast setting is only possible in menu item 1 Increase contrast Press the OK button and the arrow up button simultaneously to increase cont...

Страница 5: ...A Power factor Load detection resistance inductance capacitance Active energy consumption kWh Apparent energy kVAh Reactive energy kvarh Testing time hh mm Rate of time over Stand By threshold Time over Stand By threshold hh mm Setting the display color for different performance levels The CLM1000 Professional Plus has the following options Setting of date and time Setting the transmission speed o...

Страница 6: ...shold can be from 0 Watts to 100 Watts An accurate description of this function can be seen under 2 3 3 Description of the ON Set up the display color for different values If the OK button is pressed for the shown setting then the Settings menu for the Colour Setup will be displayed Here the thresholds for the red yellow and green colours can be set For the example in the left the colour modificat...

Страница 7: ... previously Log data saved with and deactivates the menu point automatically after the after the successful data transmission Log data If this menu item is activated CLM1000 will save the measurement data in the internal memory Attention Starting a new data storage means that the previously recorded data will be deleted Send CSV The current measured data is continuously transmitted with the adjust...

Страница 8: ...h Measurement time h 0 0000 99999 99 kWh 00 00 9999 59 h Active energy consumption since the beginning of the measurement Passed time since the beginning of the measurement Apparent energy kVAh Idle energy kvarh 0 0000 99999 99 kVAh 0 0000 99999 99 kvarh Apparent energy consump since the beginning of the measurement Idle energy consump since the beginning of the measurement Max Voltage V Min Volta...

Страница 9: ... 2 3 3 Description of the ON Function Many consumers e g refrigerator doesn t need constantly the full power from the supply Therefore it is interesting to know for how long a consumer really needs the full power and not only for how long it runs on Stand by Mode The function ON indicates how much of the entire measurement time and for how many hours does the consumer run in the adjusted ON thresh...

Страница 10: ... RS232 converter After the successful installation of the WINCLM program the interface of the CLM1000 is recognized and can be used as COM Port on your computer Transfer format 1 bit Start 8 bit Data 1 bit Stop without parity Transfer rate Depending on the setting 9600 Baud 18200 Baud 38400 Baud 57600 Baud 115200 Baud Since the transmission rate of the measuring instrument is limited to 115200 Bau...

Страница 11: ...tive power W 1001 1 Apparent power VA 2001 5 Reactive power var 1733 1 Tension V 230 0 Current A 8 702 Power factor 0 500 Active energy kWh 0 5415 Apparent energy kVAh 0 8745 Reactive energy kvarh 0 1257 Indentification of load 0 resistor 1 inductivity 2 capacitor 0 CR LF Example Data block 01 01 2007 20 50 00 1001 1 2001 5 1733 1 230 0 8 702 0 500 0 5415 0 8745 0 1257 0 01 01 2007 20 50 01 1001 1...

Страница 12: ...he usual spread sheet programs Example visualization WINCLM The WINCLM software and the software description can be downloaded from the homepage of Christ Elektronik GmbH www christ elektronik de Product Range of Measuring Instruments Important pointer The software WINCLM will no longer be supported See chapter 7 Software and data evaluation for further information about other software and about t...

Страница 13: ...n If the error continues to exist the CLM1000 can t be used Please send in ERROR2 Internal error 2 The CLM1000 shows the error and all readings are reset The CLM1000 starts a new measuring If this error keeps occurring during start up the CLM1000 has to be sent in for further inspection ERROR3 Amperage above the maximum allowable value more than 16 Ampere Unplug wattmeter ERROR4 The internal memor...

Страница 14: ... 01 kVAh Reactive energy 0 0000 99999 99 kvarh 0 0001 0 01 kvarh Consumption costs 0 00 99999 99 0 01 Consumption costs 24 h 0 00 99999 99 0 01 Tariff 0 000 99 999 0 001 Testing time 00 00 9999 59 h 1 Minute ON threshold measuring 0 0 100 0 0 1 Voltage 100 0 264 0 V 0 1 V Voltage min max 100 0 264 0 V 0 1 V Current 0 000 16 00 A 0 001 A 0 01 A Current min max 0 000 16 00 A 0 001 A 0 01 A Load reco...

Страница 15: ...or is set to 1 00 The type of resistance is set to ohm resistance EEPROM Memory All readings are saved even after unplugging Measuring error 0 3 3 digit from reading at power factor 0 3 5 4 Voltage supply Connection Socket at the adapter permanent load max 16 A Supply voltage 100 264 VAC 47 63 Hz Power consumption 4 VA 5 5 Enviroment and dimensions Dimensions ABS plastic casing approx 200 95 35 mm...

Страница 16: ...um measurable current of 2 mA Consider the tolerance of 3 mA too Question 2 My measuring instrument doesn t display any measuring values although at least a 3 mA current runs Answer 2 A current exceeding 3 mA may run through instruments having only an inductive or a capacitive load and no measured value would be displayed Reason in the case of a low power factor the active power lowers under the p...

Страница 17: ...you are not logged as administrator and select the device manager the advice meaning that you can access the device settings but cannot modify anything without administrator rights will be displayed Click on OK to confirm this dialogue and continue according to the above mentioned description 1 Call up the Internet page of the manufacturer with your browser http www ftdichip com Drivers VCP htm 2 ...

Страница 18: ...ailable for download on the following Internet page http www heise de download hterm eea223273b529eea4efb930f381de933 1378287065 2653283 html 1 Click the download button to start the download 2 Open the storage location for download files which is most of the time the folder Downloads 3 Unzip the file and double click the to open the program Downloading the file means you accept the conditions of ...

Страница 19: ... is mentioned under the tab General of the CLM1000 3 Open the program HTerm The following start window appears 4 Select the noted port of the CLM1000 like COM22 under port 5 Call up the menu of the measuring instrument as described under Setting of the interface and data memory data logger Plus version only page 6 6 Input the Baud rate mentioned in the menu of the measuring instrument like 9600 un...

Страница 20: ... saved in csv format be treated and represented graphically with spreadsheet software like Microsoft Excel or Apache Open Office Click the button Save output to save the data The next window opens Select a storage location and enter a file name The file name must end with csv Click Save output to close the process and save the data ...

Страница 21: ... following instruction indicates step for step how to import csv files in Microsoft Excel 2010 Refer to the corresponding handbook when using another program 1 Open Microsoft Excel 2010 to treat the csv file 2 Select the tab Data 3 Click the button From text in the group Get external data 4 Once in the pop up window Import text file navigate to the folder in which the csv file is stored Mark the f...

Страница 22: ...k on Next 6 Activate semicolon as delimiter Now the data in the preview should be separated with columns Click on Next 7 Columns that should not be imported might be selected in the text conversion wizard under the following point Mark the corresponding column and select the lowest box Do not import column skip Click on Finish ...

Страница 23: ... which the left upper corner of the imported data should appear Click on OK 9 Once the work with the wizard is done the parts of a line of the text file are split into different columns of the table The further process of the data like the visualisation in diagrams is possible For further information see handbook of Microsoft Excel 2010 ...

Отзывы:

Нет отзывов