Google Docs

From BioDIP
(Difference between revisions)
Jump to: navigation, search
 
Line 24: Line 24:
 
== Test Area ==
 
== Test Area ==
  
trying to integrate lpm values in html...
+
lpm values published using Google Docs gadget feature and this [http://www.mrexcel.com/archive/Formulas/12938.html offset formula]
  
[http://web-redaktion.tu-dresden.de/die_tu_dresden/fakultaeten/medizinische_fakultaet/mtz/mtzImaging/googletest test page]
+
added for a couple of systems, link option put in template, link1 for LPM
 
+
using this formula: [http://www.mrexcel.com/archive/Formulas/12938.html offset formula]
+
 
+
now trying to automatically get the last 5 values:
+
<br>=OFFSET(E1,COUNT(E:E)-4,0)
+
<br>=OFFSET(E1,COUNT(E:E)-3,0)
+
<br>=OFFSET(E1,COUNT(E:E)-2,0)
+
<br>=OFFSET(E1,COUNT(E:E)-1,0)
+
<br>=OFFSET(E1,COUNT(E:E),0)
+
 
+
in additional sheet per system?
+

Latest revision as of 13:46, 26 June 2008

Contents

[edit] Overview

Using Google Docs for documentation of laser power measurements.

[edit] 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.

[edit] 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"

[edit] Link

Google Docs


[edit] Test Area

lpm values published using Google Docs gadget feature and this offset formula

added for a couple of systems, link option put in template, link1 for LPM

Personal tools