public void AcothHandlesTrueOrFalse() { var function = new Acoth(); var input1 = true; var input2 = false; var result1 = function.Execute(FunctionsHelper.CreateArgs(input1), this.ParsingContext); var result2 = function.Execute(FunctionsHelper.CreateArgs(input2), this.ParsingContext); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result1.Result).Type); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result2.Result).Type); }
public void AcothHandlesInputDatesAreSeperatedByDashes() { var function = new Acoth(); var input1 = "1-17-2017 2:00"; var input2 = "1-17-2017 2:00 am"; var result1 = function.Execute(FunctionsHelper.CreateArgs(input1), this.ParsingContext); var result2 = function.Execute(FunctionsHelper.CreateArgs(input2), this.ParsingContext); Assert.AreEqual(2.33907E-05, System.Math.Round(result1.ResultNumeric, 9), .0001); Assert.AreEqual(2.33907E-05, System.Math.Round(result2.ResultNumeric, 9), .0001); }
public void AcothHandlesMilitaryTimesPast2400() { var function = new Acoth(); var input1 = "01:00"; var input2 = "02:00"; var result1 = function.Execute(FunctionsHelper.CreateArgs(input1), this.ParsingContext); var result2 = function.Execute(FunctionsHelper.CreateArgs(input2), this.ParsingContext); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result1.Result).Type); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result2.Result).Type); }
public void AcothTestInputsWithDatesThatHaveSlashesInThem() { var function = new Acoth(); var input1 = "1/17/2011 2:00 am"; var input2 = "17/01/2011 2:00 AM"; var input3 = "17/Jan/2011 2:00 AM"; var input4 = "17/January/2011 2:00 am"; var input5 = "1/17/2011 2:00:00 am"; var input6 = "17/01/2011 2:00:00 AM"; var input7 = "17/Jan/2011 2:00:00 AM"; var input8 = "17/January/2011 2:00:00 am"; var result1 = function.Execute(FunctionsHelper.CreateArgs(input1), this.ParsingContext); var result2 = function.Execute(FunctionsHelper.CreateArgs(input2), this.ParsingContext); var result3 = function.Execute(FunctionsHelper.CreateArgs(input3), this.ParsingContext); var result4 = function.Execute(FunctionsHelper.CreateArgs(input4), this.ParsingContext); var result5 = function.Execute(FunctionsHelper.CreateArgs(input5), this.ParsingContext); var result6 = function.Execute(FunctionsHelper.CreateArgs(input6), this.ParsingContext); var result7 = function.Execute(FunctionsHelper.CreateArgs(input7), this.ParsingContext); var result8 = function.Execute(FunctionsHelper.CreateArgs(input8), this.ParsingContext); Assert.AreEqual(2.4655E-05, System.Math.Round(result1.ResultNumeric, 9)); Assert.AreEqual(eErrorType.Value, ((ExcelErrorValue)result2.Result).Type); Assert.AreEqual(2.4655E-05, System.Math.Round(result3.ResultNumeric, 9)); Assert.AreEqual(2.4655E-05, System.Math.Round(result4.ResultNumeric, 9)); Assert.AreEqual(2.4655E-05, System.Math.Round(result5.ResultNumeric, 9)); Assert.AreEqual(eErrorType.Value, ((ExcelErrorValue)result6.Result).Type); Assert.AreEqual(2.4655E-05, System.Math.Round(result7.ResultNumeric, 9)); Assert.AreEqual(2.4655E-05, System.Math.Round(result8.ResultNumeric, 9)); }
public void AcothHandlesNormal12HourClockInputs() { var function = new Acoth(); var input1 = "00:00:00 AM"; var input2 = "00:01:32 AM"; var input3 = "12:00 PM"; var input4 = "12:00 AM"; var input5 = "1:00 PM"; var input6 = "1:10:32 am"; var input7 = "3:42:32 pm"; var result1 = function.Execute(FunctionsHelper.CreateArgs(input1), this.ParsingContext); var result2 = function.Execute(FunctionsHelper.CreateArgs(input2), this.ParsingContext); var result3 = function.Execute(FunctionsHelper.CreateArgs(input3), this.ParsingContext); var result4 = function.Execute(FunctionsHelper.CreateArgs(input4), this.ParsingContext); var result5 = function.Execute(FunctionsHelper.CreateArgs(input5), this.ParsingContext); var result6 = function.Execute(FunctionsHelper.CreateArgs(input6), this.ParsingContext); var result7 = function.Execute(FunctionsHelper.CreateArgs(input7), this.ParsingContext); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result1.Result).Type); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result2.Result).Type); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result3.Result).Type); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result4.Result).Type); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result5.Result).Type); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result6.Result).Type); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result7.Result).Type); }
public void AcothIsGivenAStringAsInput() { var function = new Acoth(); var input1 = "string"; var input2 = "0"; var input3 = "1"; var input4 = "1.5"; var result1 = function.Execute(FunctionsHelper.CreateArgs(input1), this.ParsingContext); var result2 = function.Execute(FunctionsHelper.CreateArgs(input2), this.ParsingContext); var result3 = function.Execute(FunctionsHelper.CreateArgs(input3), this.ParsingContext); var result4 = function.Execute(FunctionsHelper.CreateArgs(input4), this.ParsingContext); Assert.AreEqual(eErrorType.Value, ((ExcelErrorValue)result1.Result).Type); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result2.Result).Type); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result3.Result).Type); Assert.AreEqual(0.804718956, result4.ResultNumeric, .00001); }
public void AcothHandlesInputsWithDatesInTheFormMonthDateCommaYearTime() { var function = new Acoth(); var input1 = "Jan 17, 2011 2:00 am"; var input2 = "June 5, 2017 11:00 pm"; var input3 = "Jan 17, 2011 2:00:00 am"; var input4 = "June 5, 2017 11:00:00 pm"; var result1 = function.Execute(FunctionsHelper.CreateArgs(input1), this.ParsingContext); var result2 = function.Execute(FunctionsHelper.CreateArgs(input2), this.ParsingContext); var result3 = function.Execute(FunctionsHelper.CreateArgs(input3), this.ParsingContext); var result4 = function.Execute(FunctionsHelper.CreateArgs(input4), this.ParsingContext); Assert.AreEqual(2.46548E-05, System.Math.Round(result1.ResultNumeric, 9), .0001); Assert.AreEqual(2.33144E-05, System.Math.Round(result2.ResultNumeric, 9), .0001); Assert.AreEqual(2.46548E-05, System.Math.Round(result3.ResultNumeric, 9), .0001); Assert.AreEqual(2.33144E-05, System.Math.Round(result4.ResultNumeric, 9), .0001); }
public void AcothTestMilitaryTimeAndNormalTimeComparisions() { var function = new Acoth(); var input1 = "16:30"; var input2 = "04:30 pm"; var input3 = "02:30"; var input4 = "2:30 am"; var result1 = function.Execute(FunctionsHelper.CreateArgs(input1), this.ParsingContext); var result2 = function.Execute(FunctionsHelper.CreateArgs(input2), this.ParsingContext); var result3 = function.Execute(FunctionsHelper.CreateArgs(input3), this.ParsingContext); var result4 = function.Execute(FunctionsHelper.CreateArgs(input4), this.ParsingContext); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result1.Result).Type); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result2.Result).Type); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result3.Result).Type); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result4.Result).Type); }
public void AcothHandlesDateTimeInputs() { var function = new Acoth(); var input1 = "1/17/2011 2:00"; var input2 = "1/17/2011 2:00 AM"; var input3 = "17/1/2011 2:00 AM"; var input4 = "17/Jan/2011 2:00 AM"; var result1 = function.Execute(FunctionsHelper.CreateArgs(input1), this.ParsingContext); var result2 = function.Execute(FunctionsHelper.CreateArgs(input2), this.ParsingContext); var result3 = function.Execute(FunctionsHelper.CreateArgs(input3), this.ParsingContext); var result4 = function.Execute(FunctionsHelper.CreateArgs(input4), this.ParsingContext); Assert.AreEqual(2.46548E-05, result1.ResultNumeric, .0001); Assert.AreEqual(2.46548E-05, result1.ResultNumeric, .0001); Assert.AreEqual(eErrorType.Value, ((ExcelErrorValue)result3.Result).Type); Assert.AreEqual(2.46548E-05, result1.ResultNumeric, .0001); }
public void AcothHandlesPi() { var function = new Acoth(); var Pi = System.Math.PI; var input1 = Pi; var input2 = Pi / 2; var input3 = 2 * Pi; var input4 = 60 * Pi / 180; var result1 = function.Execute(FunctionsHelper.CreateArgs(input1), this.ParsingContext); var result2 = function.Execute(FunctionsHelper.CreateArgs(input2), this.ParsingContext); var result3 = function.Execute(FunctionsHelper.CreateArgs(input3), this.ParsingContext); var result4 = function.Execute(FunctionsHelper.CreateArgs(input4), this.ParsingContext); Assert.AreEqual(0.329765315, result1.ResultNumeric, .0001); Assert.AreEqual(0.752469267, result2.ResultNumeric, .0001); Assert.AreEqual(0.160519558, result3.ResultNumeric, .0001); Assert.AreEqual(1.884942539, result4.ResultNumeric, .0001); }
public void AcothIntAndDoublesAsInputs() { var function = new Acoth(); var input1 = 20; var input2 = 100; var input3 = 1; var input4 = 1.0; var input5 = 1.5; var input6 = 1000; var result1 = function.Execute(FunctionsHelper.CreateArgs(input1), this.ParsingContext); var result2 = function.Execute(FunctionsHelper.CreateArgs(input2), this.ParsingContext); var result3 = function.Execute(FunctionsHelper.CreateArgs(input3), this.ParsingContext); var result4 = function.Execute(FunctionsHelper.CreateArgs(input4), this.ParsingContext); var result5 = function.Execute(FunctionsHelper.CreateArgs(input5), this.ParsingContext); var result6 = function.Execute(FunctionsHelper.CreateArgs(input6), this.ParsingContext); Assert.AreEqual(0.050041729, result1.ResultNumeric, .0001); Assert.AreEqual(0.010000333, result2.ResultNumeric, .0001); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result3.Result).Type); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result4.Result).Type); Assert.AreEqual(0.804718956, result5.ResultNumeric, .0001); Assert.AreEqual(0.001, result6.ResultNumeric, .0001); }
public void AcothIsGivenValuesRanginFromNegative10to10() { var function = new Acoth(); var input1 = -10; var input2 = -1; var input3 = 0; var input4 = 1; var input5 = 10; var result1 = function.Execute(FunctionsHelper.CreateArgs(input1), this.ParsingContext); var result2 = function.Execute(FunctionsHelper.CreateArgs(input2), this.ParsingContext); var result3 = function.Execute(FunctionsHelper.CreateArgs(input3), this.ParsingContext); var result4 = function.Execute(FunctionsHelper.CreateArgs(input4), this.ParsingContext); var result5 = function.Execute(FunctionsHelper.CreateArgs(input5), this.ParsingContext); Assert.AreEqual(-0.100335348, result1.ResultNumeric, .0001); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result2.Result).Type); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result3.Result).Type); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result4.Result).Type); Assert.AreEqual(0.100335348, result5.ResultNumeric, .0001); }
public void AcothHandlesDoublesCorrectly() { var function = new Acoth(); var input1 = 0.5; var input2 = 0.25; var input3 = 0.9; var input4 = -0.9; var input5 = ".5"; var result1 = function.Execute(FunctionsHelper.CreateArgs(input1), this.ParsingContext); var result2 = function.Execute(FunctionsHelper.CreateArgs(input2), this.ParsingContext); var result3 = function.Execute(FunctionsHelper.CreateArgs(input3), this.ParsingContext); var result4 = function.Execute(FunctionsHelper.CreateArgs(input4), this.ParsingContext); var result5 = function.Execute(FunctionsHelper.CreateArgs(input5), this.ParsingContext); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result1.Result).Type); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result2.Result).Type); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result3.Result).Type); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result4.Result).Type); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result5.Result).Type); }