Google Docs

Overview

Using Google Docs for documentation of laser power measurements.

Format

Please have a look at "lpm-empty" for the basic layout. Columns should be modified based on the systems, especially the number of laser lines.

Indicate power minimum

Minimum values can be indicated by red background color:

• Click on the column header (A,B,C...) to select it.
• Click on the "Background color" icon and select "Change with rules".
• Select "Less than" and type in the minimum provided by the company for this line.
• Select the "Background" box and choose red.
• "Save rules"

Link

Google Docs

Test Area

trying to integrate lpm values in html...

test page

using this formula: offset formula

now trying to automatically get the last 5 values:
=OFFSET(E1,COUNT(E:E)-4,0)
=OFFSET(E1,COUNT(E:E)-3,0)
=OFFSET(E1,COUNT(E:E)-2,0)
=OFFSET(E1,COUNT(E:E)-1,0)
=OFFSET(E1,COUNT(E:E),0)