Google Docs
From BioDIP
(Difference between revisions)
Line 31: | Line 31: | ||
now trying to automatically get the last 5 values: | now trying to automatically get the last 5 values: | ||
− | =OFFSET(E1,COUNT(E:E)-4,0) | + | <br>=OFFSET(E1,COUNT(E:E)-4,0) |
− | =OFFSET(E1,COUNT(E:E)-3,0) | + | <br>=OFFSET(E1,COUNT(E:E)-3,0) |
− | =OFFSET(E1,COUNT(E:E)-2,0) | + | <br>=OFFSET(E1,COUNT(E:E)-2,0) |
− | =OFFSET(E1,COUNT(E:E)-1,0) | + | <br>=OFFSET(E1,COUNT(E:E)-1,0) |
− | =OFFSET(E1,COUNT(E:E),0) | + | <br>=OFFSET(E1,COUNT(E:E),0) |
Revision as of 17:36, 25 June 2008
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)