public void Define(string dest, string calcStr)
{
// pull out into command pattern
var re = new Regex(@"(SUM|AVERAGE)\(([a-z]+\d+):([a-z]+\d+)\)", RegexOptions.IgnoreCase);
var m = re.Match(calcStr);
string command = m.Groups[1].Value;
string start = m.Groups[2].Value;
string end = m.Groups[3].Value;
Tuple <int, int> indexStart = IndexParser.Parse(start);
Tuple <int, int> indexEnd = IndexParser.Parse(end);
ICalculation calc = AtlasGridCalculation.Value(start);
// + 1 because we have added the first value already above..
for (var i = indexStart.Item2 + 1; i <= indexEnd.Item2; i++)
{
string grid = IndexParser.Generate(indexStart.Item1, i);
// blah
calc = ((AtlasGridCalculation)calc).Sum(grid);
}
if (command == "AVERAGE")
{
calc = new Average(calc, indexEnd.Item2 - indexStart.Item2);
}
_calcs.Add(dest, calc);
}
public string Get(string indexStr)
{
Tuple <int, int> coord = IndexParser.Parse(indexStr);
return(_table[coord.Item1, coord.Item2]);
}
