Google Docs
From BioDIP
(Difference between revisions)
Line 27: | Line 27: | ||
[http://web-redaktion.tu-dresden.de/die_tu_dresden/fakultaeten/medizinische_fakultaet/mtz/mtzImaging/googletest test page] | [http://web-redaktion.tu-dresden.de/die_tu_dresden/fakultaeten/medizinische_fakultaet/mtz/mtzImaging/googletest test page] | ||
+ | |||
+ | using this formula: [http://www.mrexcel.com/archive/Formulas/12938.html 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) |
Revision as of 17:35, 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)