background image

 

 

 

 

NT228B GB2 

 

58 / 98 

11.3

 

 Editing the data logger (by Excel) 

 

The Ultraflux Macro for Excel can do this edition through dialogue / File and the 

Excel icon, as it is with PC records.  

 

The recommended  method is manual edition with Excel import wizard: 

Launch Excel and select the file to open (option All Files) with your browser.  As 

the (*.log) file has a (*.prn) format, Excel asks for the wizard: 

 

 

 

 

 

Accept Next / Next …, to Finish. 

This opens Excel spreadsheet

 

It may be necessary to format column 3 that has a date + time information.  

Select it, then format / Cells / Date + Time format. 

 

 

Automatic Edit:  

 

Just  after  importing  the  data-logger,  our  software  asks  you  (if  Excel  is  available 

and tight) if you want to use our Macro for automatic edit. 

 

If  you  accept,  results  will  be  arranged  as  above  and  the  flow  curve  will  be 

automatically edited. 

If you have an UF 801-PB version (dual-pipe), we will edit the three curves Q

A

, Q

B

 

and Q

T. 

 

When all is OK for you on Excel, you can rename the final file as an *.xls file, for 

further direct opening by Excel. 

 

Attention !

  If your recorded file has more lines than Excel can accept (32000), it 

could result a problem.  You can save the data-logger into two files by using Stop 

or downloading from, or later split the file in two or more files. 

Содержание UF 801-P

Страница 1: ...B timent TEXAS 9 all e Rosa Luxemburg CS 40213 RAGNY SUR OISE 95614 CERGY PONTOISE CEDEX Tel 33 0 1 30 27 27 30 Fax 33 0 1 30 39 84 34 NT 228B GB2 Rev 8 Nov 2012 UF 801 P UF 801 PB NEW GENERATION ULTR...

Страница 2: ...acteristics UF 801 P portable unit is the first new meter of this family All our flow meters work on the principle of ultrasonic transit time and can be associated with clamp on or wetted probes depen...

Страница 3: ...and measurement methods to a non specialist and specialist alike to obtain the best results Meanwhile Ultraflux will not accept any liability for errors including language or missing information which...

Страница 4: ...evice connected to the charger longer than necessary without checking or securing these conditions 2 Conformity to EC Norms All equipments are CE certified UF 801 P is typically announced as IP67 and...

Страница 5: ...ion certificate Contact our sales people to know more about these conditions 4 Warranty Please refer to the sales contract for term and conditions This Warranty supposes that this instrument is used f...

Страница 6: ...ipe Fluid settings for the application 32 6 4 Probes choice 32 6 5 Distance between Probes clamp on 33 6 6 Other Settings 33 7 NORMAL ADVANCED MODES 34 7 1 Introduction 35 7 2 Additional Parameters of...

Страница 7: ...ns 78 18 CALORIC HEAT FLOW ENERGY MEASUREMENT 79 18 1 Introduction 80 18 2 Typical installation on a heater 80 18 3 Wirings 81 18 4 Physical data settings 82 18 5 PT100 or PT1000 RTD settings 82 18 6...

Страница 8: ...NT228B GB2 8 98 3 APPLICATIONS 3 1 Overview 3 2 Measurement Principle 3 3 Typical applications 3 4 Probes their Supports or Accessories Contents...

Страница 9: ...ion As the UF 801 P is a portable unit it is usually powered from its internal battery It is delivered with an external charger that requires an external supply to be connected to Mains from 100 to 24...

Страница 10: ...that the flow integration and flow results depend on the flow section and the flow profile Choose the best probe arrangement and location to minimize other influences Fully developed and stabilized h...

Страница 11: ...nter Ultraflux offers a wide range of probes with different sizes and frequencies to be selected depending on the application and pipe diameter from 10 mm I D to more than 5 metres A large advantage o...

Страница 12: ...Each reference is attached to an internal table with the probe frequency the beam angle and the dead time in the wedge Insertion probes or wetted probes are referenced SM The attached table considers...

Страница 13: ...a Direct Reflex V the more common or N W installation mode will depend on your decision regarding the pipe dimensions and internal external conditions and also the flowing fluid to be measured From th...

Страница 14: ...98 4 HANDLING THE FLOWMETER 4 1 Pr sentation Scope of Delivery 4 2 External Connections 4 3 Connection to a PC 4 4 Using Keypad 4 5 The Menus Review 4 6 The Configuration Menu 4 7 The PC Software Gen...

Страница 15: ...5m 1 Cable for connection to PC or other outputs 1 Pair of straps for general purpose probe attachment to pipes 1 Coupling gel bottle 1 Short form user guide 1 CD Rom including PC Software and Technic...

Страница 16: ...irty after some use finger prints muddy water projection clean the instrument with a soft cloth Do not use detergents Alcohol solution is acceptable Remove traces of acoustic gel from the probes with...

Страница 17: ...or use with its batteries charged UF 801 PB Ch 2 F to select a menu V or to enter in a menu A B to change of page to change a value text See next page for connections details On Off Long press message...

Страница 18: ...ogger download Our delivered cable is ready for use directly on a RS 232 port or on an USB port through a converter Other connections can be wired on the DB 15 to transmit or to acquire analog data or...

Страница 19: ...in the screen that you can select by pressing V or up down after probe installation and connection To select a measurement screen by default display it and then press Menus header access Press and rep...

Страница 20: ...e Fluid Settings Permits to set the pipe geometry fluid characteristics and the probes Totalizers Volume counting settings units Inputs Outputs Setting of the available outputs analogue relays frequen...

Страница 21: ...on We list below with only a few comments these possibilities CONFIGURATION OPTION FILES Load Option File N xxxxxxx Save Option File N xxxxxxx LANGUAGE ENGLISH STATION S NAME xxxxxxx BACK LIGHT xxxxxx...

Страница 22: ...or settings It asks also for the language that you would prefer to use The installation proposes also the connection to your already installed Microsoft Excel version It is up to you to accept this co...

Страница 23: ...NT228B GB2 23 98 5 PROBES INSTALLATION 5 1 Selection criteria of the probes 5 2 Selection of the measurement section 5 3 Probes Coupling 5 4 First Measurements Contents...

Страница 24: ...s using F 1 MHz probes We recommend our SE_1515 SE_1707 or our SE_1662 S For larger pipes ND 0 8 m up to 10 m or difficult conditions our recommended choice is SE_1599 I F 0 5 MHz Most of these probes...

Страница 25: ...brush No need to remove good paintwork If paintwork is flaking off remove it with a brush or a scrapper the air gap under the paint will stop ultrasonic transmission Use the right gel for actual cond...

Страница 26: ...n probes are connected and UF 801 P device correctly parameterized the flow reading should be available To check that conditions are OK or if no result we duly recommend using the echo display menu to...

Страница 27: ...NT228B GB2 27 98 6 SIMPLE MODE 6 1 Mode Simple 6 2 Measurement Menu 6 3 Pipe Fluid settings 6 4 Choice of probes 6 5 Distance between probes 6 6 Other settings Contents...

Страница 28: ...ere forced at following values Product Water with Co 1472 m s and Delta C 400 m s K Hydro Auto Viscosity 1 0 CSt Pipe Roughness 0 1 mm Flow Cut Off 0 Auto Zero No Memory 10 s Filter 10 s Graph Period...

Страница 29: ...Chord 1 Probe xxxxxxxx Mounting xxxxxxxx D Probe mm Next automatic display is the By Default screen that you have already selected with B or that you can select at any time among the following display...

Страница 30: ...different conditions this coefficient can be manually set via the Normal or Advanced modes Speed of Sound value Ultrasonic wave velocity permits correlations with water temperature Transit time is the...

Страница 31: ...with this means that there is no result At the bottom of the measurement screens if display shows this is fault warning Consult fault report 01 08 2008 11h10mn33 Battery Range 78 This screen shows act...

Страница 32: ...s as Ext Diam or Ext Circ O D UF 801 P displays both and calculates the pipe I D Use a tape measure or a vernier for Ext Diam and a thickness gage for pipe thickness unless drawings are available or m...

Страница 33: ...asured between lateral marks on probe side Chord 1 Probe xxxxxxxx Mounting xxxxxxxx D Probe mm You can at any time select this screen with in measurement menu 6 6 Other Settings You can select also th...

Страница 34: ...98 7 NORMAL ADVANCED MODES 7 1 Introduction 7 2 Additional Parameters in normal mode 7 3 Zero Auto Zero Settings 7 4 Additional Parameters in advanced mode 7 5 Filtering Response time 7 6 Factory sett...

Страница 35: ...tering a linearization curve for optimised accuracy In addition this menu includes a test menu 2 special probe setting and possibility to apply specific ultrasonic signal treatment 7 2 Additional Para...

Страница 36: ...mportant for accuracy when there is a low delta T at flow range small pipe This offset is almost due to the pipe itself to the probes choice even matched and their installation To prevent from errors...

Страница 37: ...meters in Advanced mode Exact Settings on a multilayer pipe PIPE Tube Ext Diam mm Ext Circ mm Wall Material 1 xxxxxxx Thick 1 mm Material 2 xxxxxxx Thick 2 mm Material 3 xxxxxxx Thick 3 mm Sp Sound I...

Страница 38: ...801 P flow display will be in late and not realistic for some time The Delta V Filter parameter permits an efficient compromise UF 801 P does raw acquisitions of Delta T and calculates flow instantan...

Страница 39: ...mpensation The graph below shows an example and attached settings Note that one compensation curve can be entered for positive flows another one for negative Q or Q Q Ref 0 or x m3 h Coef 0 1 000 Coef...

Страница 40: ...NT228B GB2 40 98 8 DUAL PIPE VERSION UF 801 PB 8 1 Introduction to UF 801 PB 8 2 Complementary screens Contents...

Страница 41: ...with Nr of pipes 1 It will be very similar to UF 801 P but QT display as total flow that remains and will be equal to QA After setting Nr of pipes 2 Pipe Fluid Menu you will have complete and totally...

Страница 42: ...AutoZero No Yes The main difference concerns the measurement menu Two new screns are available QT m3 h QA m3 h QB m3 h QT m3 h QA m3 h QB m3 h Technical displays are identical to previous ones but wi...

Страница 43: ...NT228B GB2 43 98 9 ECHO DISPLAY MENU 9 1 When and How use this menu 9 2 Examples of echoes and criteria Contents...

Страница 44: ...e version The first one shows from the left to the right side all energised signals ultrasonic but also noises that UF 801 P is receiving and must filter and treat The two dotted vertical lines are sh...

Страница 45: ...ial compared to pipe thickness has influence on the echo shape This could lead you to use higher frequency probes Finally this probe frequency allows more or less from the pipe roughness corrosion or...

Страница 46: ...NT228B GB2 46 98 10 PC Software 10 1 Installation Connections 10 2 Menu Dialogue 10 3 Archive records management Contents...

Страница 47: ...uitable model The exchange protocol is JBus ModBus with the PC as Master and UF801 as slave which requires a slave Nr N JBus by default 1 The Bytes or Baud Rate can be set from 300 up to 115200 Bd Set...

Страница 48: ...a try with UF 801 P at 115 000 and then at 9600 bauds if no result The recording period max time and sampling rate time interval are explained further in 10 2 They set the automatic measurement recor...

Страница 49: ...Measurement It does importing actual measurement results that are displayed by UF 801 They are grouped on three screens G n ral which shows the actual flow and totalizers Pipe per pipe technical displ...

Страница 50: ...e and recording period Setting Max time period 0 means manual stop the icon Stop replaces the icon Save Then you can read print manipulate these records with Excel from the File Open Selection Menu A...

Страница 51: ...do it with Synchro Yes and then Send As with Keypad you can activate or disable I O Tot or data logger resources does exporting these new settings to UF 801 and permits to save them in a file archive...

Страница 52: ...rements with in addition the following icons to select a record to print the actual page to send this file to Excel and do the automatic treatment with the dedicated Macro Excel macro offers you time...

Страница 53: ...s You can recall them with Load edit or reuse them or simply save them on PC These archives on a PC present many advantages they are very helpful for your reports or to share typical settings instruct...

Страница 54: ...NT228B GB2 54 98 11 DATA LOGGER 11 1 Setting the Data Logger 11 2 Reading the data logger 11 3 Treatment by Excel Contents...

Страница 55: ...Logger You can operate through the keypad If you would prefer using the PC Software select the Data Logger tab in settings menu With the Keypad you have successive programming screens as follows LOGGE...

Страница 56: ...pipe 1 or 2 if a PB version and some are classified General values as the totalizers or QT if it is a dual pipe PB version Return to measurement menu by F or after up loading setting from the PC start...

Страница 57: ...tab Fully download the data logger Downloading between 2 dates You are requested to name the file to be saved Then downloading starts automatically You can see it progress as follows Clicking on Stop...

Страница 58: ...then format Cells Date Time format Automatic Edit Just after importing the data logger our software asks you if Excel is available and tight if you want to use our Macro for automatic edit If you acc...

Страница 59: ...NT228B GB2 59 98 12 TOTALIZERS 12 1 Description Contents...

Страница 60: ...Pulse Weight xxxx TOTALIZER 3 Dir OFF TOTALIZER 4 Dir OFF TOTALIZERS SETTINGS Each totalizer can be set OFF to ON by attaching it to a flow direction or or any If your have a UF 801 P B dual chord ver...

Страница 61: ...228B GB2 61 98 13 INPUTS OUTPUTS 13 1 Introduction 13 2 Analogue Output s 13 3 Relay Ouputs as pulsed volume 13 4 Frequency Output 13 5 PT100 RTD Inputs 13 6 External Connections Wiring diagram Conten...

Страница 62: ...e current or voltage offers two inputs For PT100 PT1000 sensors we install double module 2 T C acquisitions UF 801 is delivered as standard with two modules 1 current output and 2 relays Optionally it...

Страница 63: ...r circuitry safety reasons To use it you must connect on the DB 15 male connector or a dedicated one as shown in attached table 01 A It is necessary to solder two wires 13 3 Relay outputs pulsed outpu...

Страница 64: ...ipe A B Q Rel Stat OPEN Wiring 02 B Copy the sign attached to the flow direction or INPUT OUTPUT 2 Relay Output B Function Flow DIR Polarity Norm Open Value Pipe A B Q Rel Stat OPEN Wiring 02 A An ala...

Страница 65: ...ut A Function FREQUENCY Value Pipe A B Q 0 Hertz xxx xx 1 kHertz xxx xx Rel Stat Closed F Fault 0 Hz Simul F xxx Hz Wiring 02 B This resource is mainly used for calibration by comparison to a standard...

Страница 66: ...s connections on each Binder 12 or 8 Pts and on DB 15 Male recommended are UF 801 P is delivered with a cable having a 12 Pts Binder connector at one ending and a DB 15 Fem Male at the other ending Us...

Страница 67: ...NT228B GB2 67 98 14 TIMER SEQUENCER 14 1 Settings Contents...

Страница 68: ...the battery available for a much longer time UF 801 P allows an infinitive sequential ON OFF periods The Setting of the Timer Sequencer is only available on the instrument not through the PC The TIME...

Страница 69: ...t time and then periodically if requested as per your settings Complementary information If you have set the Differed mode the Timer is automatically reset OFF after the operation If you have set the...

Страница 70: ...NT228B GB2 70 98 15 SETTING FILES SAVING AND CALL IN UF801 P 15 1 Saving and recalling of a Calibration file Contents...

Страница 71: ...ory space Nr 1 or 2 Validate the saved record by changing the line V To recall these archived settings Go to Load Option File line and select which one you want To load the file press the down arrow c...

Страница 72: ...NT228B GB2 72 98 16 PIPE WALL THICKNESS MEASUREMENT 16 1 Pipe wall thickness measurement 16 2 Installation procedure 16 3 Sound velocity measurement in a material Contents...

Страница 73: ...nowledge of the longitudinal sound velocity in the tested material and the transit time measurement we can know with accuracy 0 1 mm the thickness of this layer This pipe wall thickness knowledge is v...

Страница 74: ...ALL Material St Steel Display Graph Mode AUTO MANUAL If Manual R solution mm Th Min Th Max The Thickness measurement result should be displayed Thickness 7 1 mm We recommend using the second measureme...

Страница 75: ...l thickness corrosion including crystallization as with grey cast iron The vertical bar graph gives you information on echo strength With very thin pipe walls less than 3 mm on steel the danger is to...

Страница 76: ...hickness Test Material Thickness xx x mm Go to the next display The corresponding sound velocity must be displayed Press B to send this result to thickness mode Speed Sound xxxx m s Thickness Mode Thi...

Страница 77: ...NT228B GB2 77 98 17 CUSTOMIZED FONCTIONS 17 1 Introduction 17 2 Special Functions 17 3 To day available Functions Contents...

Страница 78: ...and corrected flow and volume as it is necessary with gases or petroleum liquids For that UF 801 P uses currently its acquisition module possibilities 17 2 Special Functions The UF 801 P architecture...

Страница 79: ...ENT 18 1 Introduction 18 2 Typical Installation on a heater thermal exchanger 18 3 Wirings 18 4 Physical data settings 18 5 PT100 PT1000 settings 18 6 Measurements reading 18 7 Records and readings wi...

Страница 80: ...g them We recommend our new modules for PT 100 PT1000 with possibility of 2 3 or 4 wires connection to optimize cable length compensation They offer a typical accuracy of 0 1 C The temperatures can al...

Страница 81: ...8 Pts Binder plug uses the second entry on UF 801 P PT100 PT1000 A Binder Cable with at its other ending a dedicated connection box with terminals Here any type of PT 100 or PT 1000 can be connected P...

Страница 82: ...talled it appears a new Tab named Function 18 5 PT100 or PT1000 RTD settings The temperature acquisition modules are factory calibrated or controlled on very accurate resistor used as standards to sim...

Страница 83: ...TD probes This menu is in Settings Input or Outputs tab PT 100 1000 Offset 18 6 Measurements reading On the UF 801 P Measurement menu dedicated display On the PC Menu Measurements Tab Function OUTPUT...

Страница 84: ...r have entered the selection menu for records data logger select function and then the output values that you need to record Value N 1 is for the Delta T C Value 2 is for the Power and value N 3 is fo...

Страница 85: ...6 18 08 38 18 11 31 18 14 24 18 17 17 18 20 10 temps delta_T C puissance kW nergie kW h The theoretical power of the heater is 35 kW but here the peak power is less than 20 kW with an average power of...

Страница 86: ...0 1 01 958 1 4216 110 1 5 950 4 4230 120 2 0 942 9 4245 130 2 75 934 3 4265 140 3 6 925 8 4285 150 4 5 916 5 4312 160 6 2 907 3 4339 170 8 0 897 0 4373 180 10 0 886 9 4408 190 12 5 875 7 4452 200 15 5...

Страница 87: ...NT228B GB2 87 98 19 BATTERY CHARGER 19 1 Battery Charger 19 2 Battery pack whole life Contents...

Страница 88: ...2 5 hours When battery is charged the charge supervisor switches from high to low current to maintain the charge but also to supply an UF 801 P that is kept ON In that case the charger can be consider...

Страница 89: ...9 98 20 TROUBLESHOOTING FAQ 20 1 General Recommendation 20 2 Typical troubles or situations 20 2 1 Case 1 20 2 2 Case 2 20 2 3 Case 3 20 2 4 Case 4 20 3 Other investigations 20 4 After Sales Services...

Страница 90: ...splayed and transmitted meets your expectations Case 2 The measurement operates but is inaccurate or is unstable Case 3 The measurement is not reliable or the UF 801 P is displaying a Fault Case 4 The...

Страница 91: ...erwise choose K_Hydro Manual and adjust this correction coefficient to compensate this particular flow profile and have a reliable flow rate reading Flow f 1 Kh With insertion probes it is also possib...

Страница 92: ...signals Concrete pipe corroded pipe Is the installation mode suitable for conditions Try Direct mode or other sensors Are the probes correctly installed orientation coupling Case 4 The UF 801 has no d...

Страница 93: ...flux qualified technicians are allowed to open a UF 801 P PB adding a module maintenance purpose The IP 67 or 68 keeping depends also from When to exchange a battery pack UF 801 P includes a supervisi...

Страница 94: ...21 APPENDIX 21 1 Pipes typical dimensions 21 2 Pipe Roughness coefficients for pipes 21 3 Sound Velocity in Fluids 21 4 Applications on Water 21 5 Applications on Petroleum Products 21 6 Measurements...

Страница 95: ...I pipes consider O D dimensions and are labeled in inches The thickness and also the I D depend on the pipe pressure schedule So For pipes with diameter 14 and above the O D is obtained by multiplying...

Страница 96: ...fluid compressibility Water has special and unique characteristics but presents a very reliable relation between this sound velocity and the temperature that allows a number of tests to be run on the...

Страница 97: ...74 C Beyond that the water becomes a conventional product again The water pressure coefficient is relatively low at around 0 15 m s per bar The presence of salts as Na Cl in solution increases the val...

Страница 98: ...UF 801 P offer a more completed list of typical products encountered in the industry If you need some prior to test information please ask us You can also do some tests by yourself with the method exp...

Отзывы: