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 -

WesDyne International (AMDATA Products)
WesDyne is an engineering and technical services firm dedicated to providing standard and custom nondestructive examinations (NDE) products and systems
658 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

Lyft™: Pulsed Eddy Current Reinvented

PEC Reinvented—CUI Programs Redefined Corrosion under insulation (CUI) is possibly the greatest u
...
nresolved asset integrity problem in the industry. Current methods for measuring wall thickness with liftoff, without removing insulation, all have severe limitations. Eddyfi introduces Lyft — a reinvented, high-performance pulsed eddy current (PEC) solution. The patent- pending system features a state-of-the-art portable instrument, real- time C-scan imaging, fast data acquisition with grid-mapping and dynamic scanning modes, and flexibility with long cables. It can also scan through thick metal and insulation, as well as aluminum, stainless steel, and galvanized steel weather jackets. Who else but Eddyfi to reinvent an eddy current technique and redefine CUI programs. Got Lyft?
>

Combination of Digital Image Correlation and Thermographic Measurements

The combination of measuring results from the digital image correlation (ARAMIS, DIC) and temperat
...
ure measuring data from infrared cameras permits the simultaneous analysis of the thermal and mechanical behavior of test specimens in the materials and components testing field.
>

Ultrasonic Testing Immersion Tanks with Unmatched Scanning Features

TecScan’s non-destructive testing Ultrasonic Immersion Tanks & scanners are designed for high pe
...
rformance and demanding NDT testing applications. Our Scan3D™ line of High Precision Immersion Tanks are specifically designed for automated ultrasonic testing of complex composites parts used in aerospace and industrial applications.
>

NEW! The PragmaPro Instrument Platform

The PragmaPro is based on a modular cartridge technology and supports various NDT instrument modal
...
ities such as UT, PAUT, ECT and many more. This new platform is based on a machined, powder-coated aluminum frame for shock-proofness, best sealing qualities and maximum heat dissipation. This is practical to extend the outdoor temperature range and/or to extend the power injected in the transducers. The PragmaPro is aiming at a very wide range of applications, such as weld scanning, corrosion mapping and composite testing.
>

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