public void DailyAverageBug()
{
string filename = TestData.DataPath + "\\Deadwood at SF.xls";
SpreadsheetGearSeries s = GetSimpleSeries(filename);
s.Read();
//Assert.AreEqual(31740, s.Count);
Assert.AreEqual(33812, s.Count);
Point pt = Reclamation.TimeSeries.Math.TimeWeightedAverageForDay(s, DateTime.Parse("10/3/2006"));
Console.WriteLine(pt);
Assert.IsTrue(pt.IsMissing);
pt = Reclamation.TimeSeries.Math.TimeWeightedAverageForDay(s, DateTime.Parse("10/4/2006"));
Assert.IsTrue(pt.IsMissing);
}
public void WaterYearFormat()
{
string filename = TestData.DataPath + "\\wateryear.xls";
Assert.IsTrue(System.IO.File.Exists(filename), "missing file " + filename);
SpreadsheetGearSeries xls = new SpreadsheetGearSeries(filename,
"Sheet1", "WaterYear", "Oct", true);
xls.Read();
Assert.AreEqual(12, xls[0].Value, 0.001);
Assert.AreEqual(DateTime.Parse("1889-10-1"), xls[0].DateTime);
Assert.AreEqual(1100, xls[DateTime.Parse("1934-6-1")].Value);
xls.WriteCsv(@"c:\temp\a.csv");
}
public void ColumnReferenceNames()
{
int i = SpreadsheetGearSeries.ColumnIndexFromRef("A");
Assert.AreEqual(0, i);
i = SpreadsheetGearSeries.ColumnIndexFromRef("AA");
Assert.AreEqual(26, i);
i = SpreadsheetGearSeries.ColumnIndexFromRef("IV");
Assert.AreEqual(255, i);
string s = SpreadsheetGearExcel.ReferenceFromIndex(0);
Assert.AreEqual("A", s);
s = SpreadsheetGearExcel.ReferenceFromIndex(26);
Assert.AreEqual("AA", s);
s = SpreadsheetGearExcel.ReferenceFromIndex(255);
Assert.AreEqual("IV", s);
}
private void newExcel_Click(object sender, EventArgs e)
{
if (openExcelDialog.ShowDialog() == DialogResult.OK)
{
SelectExcelSeries dlg = new SelectExcelSeries(openExcelDialog.FileName);
if (dlg.ShowDialog() == DialogResult.OK)
{
Series s = SpreadsheetGearSeries.ReadFromFile(dlg.WorkBook, dlg.SheetName, dlg.DateColumn, dlg.ValueColumn);
if (s.Count > 0)
{
DB.AddSeries(s, tree1.SelectedID);
}
else
{
MessageBox.Show("No data in the selection. File " + openExcelDialog.FileName);
}
}
}
}
public void UnregulatedFlow()
{
var fn = TestData.DataPath + "\\CalculationTests.xlsx";
Series af = new SpreadsheetGearSeries(fn, "jck_qu", "Date", "jck af", false);
Series qd = new SpreadsheetGearSeries(fn, "jck_qu", "Date", "jck qd", false);
Series qu = new Series();
qu.Parser.VariableResolver.Add("af", af);
qu.Parser.VariableResolver.Add("qd", qd);
qu.Expression = "(af[t]-af[t-1])/1.98347+qd";
DateTime t1 = DateTime.Parse("12/25/2010");
DateTime t2 = DateTime.Parse("12/27/2010");
qu.Calculate(t1, t2);
qu.WriteToConsole();
Assert.AreEqual(674.39, qu["12/26/2010"].Value, .01);
}
