Package org.zkoss.zss.engine.xel

Examples of org.zkoss.zss.engine.xel.SSErrorXelException

76
77
78
79
80
81
82
83
84
   * @return the average of its arguments
   */
  public static Object statAverage(Object[] args, XelContext ctx){
    final List ls = UtilFns.toList(args, ctx);
    if (ls.isEmpty()) {
      throw new SSErrorXelException(SSError.DIV0);
    }
    return UtilFns.validateNumber(UtilFns.getStats(UtilFns.toDoubleArray(ls)).getMean());
  }
View Full Code Here
110
111
112
113
114
115
116
117
118
119
        use the AVERAGE function
     */

    final List ls = UtilFns.toAList(args, ctx);
    if (ls.isEmpty()) {
      throw new SSErrorXelException(SSError.DIV0);
    }
   
    return UtilFns.validateNumber(UtilFns.getStats(UtilFns.toDoubleArray(ls)).getMean());
  }
View Full Code Here
131
132
133
134
135
136
137
138
139
140
141
    int trails = CommonFns.toNumber(args[1]).intValue();
    double p_s = CommonFns.toNumber(args[2]).doubleValue();
    boolean isCumulative = ((Boolean)args[3]).booleanValue();
   
    if(number>trails || number <0)
      throw new SSErrorXelException(SSError.NUM);
    else{
      DistributionFactory factory = DistributionFactory.newInstance();
      BinomialDistribution bd = factory.createBinomialDistribution(trails, p_s);
      if(isCumulative)
        return UtilFns.validateNumber(bd.cumulativeProbability(number));
View Full Code Here
154
155
156
157
158
159
160
161
162
163
164
  public static Object statChidist(Object[] args, XelContext ctx) throws MathException{
    //EXCEL: CHIDIST(x,degrees_freedom)
    double x = CommonFns.toNumber(args[0]).doubleValue();
    double df = CommonFns.toNumber(args[1]).doubleValue();
    if(x <0)
      throw new SSErrorXelException(SSError.NUM);
    else{   
      DistributionFactory factory = DistributionFactory.newInstance();
      return UtilFns.validateNumber(1-factory.createChiSquareDistribution(df).cumulativeProbability(x));
    }
  }
View Full Code Here
172
173
174
175
176
177
178
179
180
181
182
   */
  public static Object statChiinv(Object[] args, XelContext ctx) throws MathException{
    double p = CommonFns.toNumber(args[0]).doubleValue();
    double df = CommonFns.toNumber(args[1]).doubleValue();
    if(p<0 || p>1)
      throw new SSErrorXelException(SSError.NUM);
    else{
      DistributionFactory factory = DistributionFactory.newInstance();
      return UtilFns.validateNumber(factory.createChiSquareDistribution(df).inverseCumulativeProbability((1-p)));
    }
  }
View Full Code Here
563
564
565
566
567
568
569
570
571
572
573
   * @param ctx context information for XEL evalution.
   * @return the sum of deviation
   */
  private static double sumDeviation(double total, Object arg, double mean, XelContext ctx) {
    if (arg instanceof SSError) {
      throw new SSErrorXelException((SSError) arg);
    } else if (arg instanceof Range) { // a range, iterator thru available
                      // cells
      final Range rng = (Range) arg;
      final Book book = rng.getSheet().getBook();
      final Collection cells = rng.getCells();
View Full Code Here
79
80
81
82
83
84
85
86
87
    return _ref;
  }
  public Collection getCells() {
     final Ref2d ref = (Ref2d) _ref;
    if (ref.getLtIndex() == null || ref.getRbIndex() == null) {
      throw new SSErrorXelException(SSError.REF);
    }
    return super.getCells();
  }
View Full Code Here
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
    Date issue = UtilFns.stringToDate(args[0].toString());
    Date firI = UtilFns.stringToDate(args[1].toString());
    Date settlement = UtilFns.stringToDate(args[2].toString());
    if(settlement.before(issue))
    {
      throw new SSErrorXelException(SSError.NUM);
    }
    double rate = CommonFns.toNumber(args[3]).doubleValue();
    double Par;
    int freq;
    try{
      Par = CommonFns.toNumber(args[4]).doubleValue();
    }catch(ClassCastException e){
      Par = 10E+3; //provided as MSFT Excel help says
    }
    try{
    freq = CommonFns.toNumber(args[5]).intValue();
    }catch(ClassCastException e){
      throw new SSErrorXelException(SSError.NUM);
    }
    int basis = 0;
    boolean method = true;
    if(args.length == 7)
    {
      try{
        basis = basis(CommonFns.toNumber(args[6]).intValue());
      }catch(ClassCastException e){
        basis = 0;
      }
    }
    else if(args.length == 8)
    {
      try{
        basis = basis(CommonFns.toNumber(args[6]).intValue());
      }catch(ClassCastException e){
        basis = 0;
      }
      try{
        method = CommonFns.toBoolean(args[7]);
      }catch(ClassCastException e){
        method = true;
      }
    }
   
    if(!(freq == 1 || freq == 2 || freq == 4))
    {
      throw new SSErrorXelException(SSError.NUM);
    }
    if( rate <= 0 || Par <= 0)
    {
      throw new SSErrorXelException(SSError.NUM);
    }
   
    double result = 0;
    //TODO:only only a few situations are correct
    if(method) //because Par * rate / freq * diff * freq == Par * rate * diff
 
View Full Code Here
180
181
182
183
184
185
186
187
188
189
 
  /* return frequency */
 
  private static int frequency(int frequency) {
    if(frequency != 1 && frequency != 2 && frequency != 4) {
      throw new SSErrorXelException(SSError.NUM);
    } else {
      return 12/frequency;
    }
  }
View Full Code Here
189
190
191
192
193
194
195
196
197
198
  }
 
  /* return basis */
  private static int basis(int basis) {
    if(basis > 4 || basis < 0) {
      throw new SSErrorXelException(SSError.NUM);
    } else {
      return basis;     
    }
  }
View Full Code Here
TOP

Related Classes of org.zkoss.zss.engine.xel.SSErrorXelException

  • org.zkoss.zss.engine.fn.DateTimeFns
  • org.zkoss.zss.engine.fn.EngineeringFns
  • org.zkoss.zss.engine.fn.FinancialFns
  • org.zkoss.zss.engine.fn.MathFns
  • org.zkoss.zss.engine.fn.StatFns
  • org.zkoss.zss.engine.fn.TextDataFns
  • org.zkoss.zss.engine.fn.UtilFns
  • org.zkoss.zss.model.impl.AbstractRange
  • org.zkoss.zss.model.impl.RangeRef
  • org.zkoss.zss.model.impl.RangeRefError
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.