We can directly type formulas in that xml file or we have to do calculations only in excel after exporting?
You can insert formulas in the XML. ElasticRepExample.xml contains an example:
<Column name="Summary Consumption" calcType="Formula" value="=SUM(RC[-3]:RC[-2])" calcTotal="true" colStyle="col-lg" />