Google Docs
From BioDIP
Contents |
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
Test Area
trying to integrate lpm values in html...
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)
in additional sheet per system?