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 -

Modsonic Instruments Mfg Co Pvt Ltd
We are leading Indian manufacturer and exporter of portable “Ultrasonic Testing Equipment”
664 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

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.
>

HD-CR 35 NDT Computed Radiography System

Portable high-resolution CR scanner for all radiography applications - weld testing, profile images
...
and aerospace. No matter what type of radiographic testing you are performing, the unique TreFoc Technology of the HD-CR 35 NDT imaging plate scanner always guarantees the highest image quality.
>

FAAST-PA! OEM Patented phased Array for high speed UT inspection

Multiangle, Multifocus, Multifrequency, Multibeam. Instead of stacking UT electronics and having m
...
any PA probes, FAAST-PA is able to transmit all delay laws within ONE single shot in Real time.
>

iProbe - USB Phased Array Probe

Turn your PC, Laptop or Tablet into a powerful 32:64 Phased Array system with our USB powered Phas
...
ed Array iProbe and inspection software package. Perform affordable weld inspection and corrosion mapping inspections with this powerful but small system. The probe has a 100V pulser, 8K PRF, dual axis encoder input and achieves outstanding signal quality.
>

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