Changeset 19915 for trunk/FACT++/spectrum/simulation.sql

Timestamp:

12/16/19 20:03:18 (5 years ago)

Author:

tbretz

Message:

Improved comments

File:

• trunk/FACT++/spectrum/simulation.sql (modified) (3 diffs)

trunk/FACT++/spectrum/simulation.sql

@@ -3 +3 @@
    SELECT
       Weight, Energy, LogEnergyEst,
+
+      -- Convert variable to bin index
       INTERVAL(Theta, %107:theta)  AS `.theta`,
       INTERVAL(LogEnergyEst, %108:sparse)  AS `.sparse_est`,
@@ -38 +40 @@
 */
 
-   -- Binning in estimated energy: Signal, Background, Excess
+   -- Binning in estimated energy: Signal, Background
    SUM(  IF(Weight>0,        ZdWeight*SpectralWeight,    0))  AS  SignalW,
    SUM(  IF(Weight<0,        ZdWeight*SpectralWeight,    0))  AS  BackgroundW,
@@ -44 +46 @@
    SUM(  IF(Weight<0, POW(ErrZdWeight*SpectralWeight,2), 0))  AS  BackgroundW2,
 
-   -- Energy Estimation
+   -- Energy Estimation: Bias=ResidualW/SignalW; Resolution=sigma(Bias)
    SUM(IF(Weight>0,     Residual*   ZdWeight*SpectralWeight, 0))  AS  ResidualW,
    SUM(IF(Weight>0, POW(Residual,2)*ZdWeight*SpectralWeight, 0))  AS  ResidualW2,
 
+   -- Average Energy: SumEnergyX/SignalW
    SUM(IF(Weight>0, Energy               *ZdWeight*SpectralWeight, 0))  AS  SumEnergySimW,
    SUM(IF(Weight>0, POW(10, LogEnergyEst)*ZdWeight*SpectralWeight, 0))  AS  SumEnergyEstW