where expertise comes together - since 1996 -

The Largest Open Access Portal of Nondestructive Testing (NDT)

Conference Proceedings, Articles, News, Exhibition, Forum, Network and more

where expertise comes together
- since 1996 -
671 views
Technical Discussions
Mike Plant
Mike Plant
03:28 Jul-23-1998
Coloring cells for MS excel thickness survey report

I have recently completed a UT thickness survey of a vessel and have written up the results in micrsoft excel. I wish to color code the cells according to their thickness to highlight thin areas. Does anyone know how this is done, maybe by macro?
Thanks in advance.


 
 Reply 
 
U. Mletzko
R & D, Retired
Germany, Joined Nov 1998, 89

U. Mletzko

R & D, Retired
Germany,
Joined Nov 1998
89
01:49 Jul-24-1998
Re: Coloring cells for MS excel thickness survey report
: I have recently completed a UT thickness survey of a vessel and have written up the results in micrsoft excel. I wish to color code the cells according to their thickness to highlight thin areas. Does anyone know how this is done, maybe by macro?
: Thanks in advance.

Using Excel 97, this is a built-in feature. It is in menu ***Format***. In German language the menu item is ***Bedingte Formatierung***, in English it might be ***Format with conditions*** or similar.

Best regards
Uli Mletzko, MPA,University of Stuttgart, Germany





 
 Reply 
 
William Friedman
William Friedman
01:32 Jul-25-1998
Re: Coloring cells for MS excel thickness survey report
: : I have recently completed a UT thickness survey of a vessel and have written up the results in micrsoft excel. I wish to color code the cells according to their thickness to highlight thin areas. Does anyone know how this is done, maybe by macro?
: : Thanks in advance.

If you have an earlier version of Excel then you need to use a macro. You can use the RECORD MACRO mode to define the code for setting the color by using the Format Pattern selections. Then you will have to create a Do Loop in visual basic with an If statement to check every cell in your image.

Good luck, Using Visual Basic is not trivial.

Bill Friedman


 
 Reply 
 

Product Spotlight

NEW Wheel Type Phased Array Probe

DOPPLER NEW Wheel Type Phased Array Probe, more stable, new tyre makes lesser acoustic attenuation
...
, much lighter makes easier to handle, more slim size, magnetic and mechanical encoder optional etc...more
>

MUSE Mobile Ultrasonic Equipment

The MUSE, a portable ultrasonic imaging system, was developed for in-field inspections of light-weig
...
ht structures. The MUSE consists of a motor-driven manipulator, a water circulation system for the acoustic coupling and a portable ultrasonic flaw detector (USPC 3010). The MUSE provides images of internal defects (A-, B-,C- and D-scan).
>

CIVA 2020 UT Module

CIVA NDE Simulation Software is the world leader of NDT Simulation. The UT simulation Module incl
...
udes: - "Beam computation": Beam propagation simulation - "Inspection Simulation": Beam interaction with flaws or specimens The user can simulate a whole inspection process (pulse echo, tandem or TOFD) with a wide range of probes (conventional, Phased- arrays or EMAT), components, and flaws.
>

EKOSCAN Phased Array

In order to always fit your needs, EKOSCAN can manufacture any type of UT transducer, either convent
...
ional or Phased Array. As an ISO 9001: 2015 certified company, EKOSCAN is extremely careful as far a material selection and manufacturing processes are concerned. Our probes guarantee our customers the benefits of latest innovations regarding piezo-composite, backing, impedance adaptation layer, etc. Specific probes for hostile environment: high temperature, high pressure, corrosive environment,etc. Specific probes designed to fit your specific application: optimization of every parameter to guarantee you the best detection.
>

Share...
We use technical and analytics cookies to ensure that we will give you the best experience of our website - More Info
Accept
top
this is debug window