Changeset 19503

Timestamp:

05/22/19 09:24:05 (6 years ago)

Author:

Daniela Dorner

Message:

fixed bug in query

File:

• trunk/DataCheck/QuickLook/FlareAlerts.sh (modified) (2 diffs)

trunk/DataCheck/QuickLook/FlareAlerts.sh

@@ -70 +70 @@
 #cu="20.0"
 #cu="CUQLA(fNight)"
-cu="fCU"
+cu="Avg(fCU)"
 corr="1"
 # missing: corrected excessrates
@@ -92 +92 @@
    query=$query"ROUND(ExcErr(SUM(fNumSigEvts), SUM(fNumBgEvts))/SUM("$ontime")*3600*SUM(fNumExcEvts)/SUM(fNumExcEvts*"$corr"), 2) AS corexcrateerr, " # correctionfactor = exc / exc_cor, put here correction factor
    query=$query"ROUND(LiMa(SUM(fNumSigEvts), SUM(fNumBgEvts)),2) AS signif, "
-   query=$query"ROUND(SUM(fNumExcEvts)/SUM("$ontime")*3600/"$cu",2) AS cu, " # make value time dependent
+   query=$query"ROUND(SUM(fNumExcEvts)/SUM("$ontime")*3600/"$cu",2) AS cu, " 
    query=$query"ROUND(ExcErr(SUM(fNumSigEvts), SUM(fNumBgEvts))/SUM("$ontime")*3600/"$cu", 2) AS cuerr, " # make value time dependent
    query=$query"ROUND(SUM(fNumExcEvts*"$corr")/SUM("$ontime")*3600/"$cu",2) as corcu, " # make value time dependent # put here correction factor