Any excel template to fill up formula and load to dashboard?

[jim_chan]

Hi all,

Recently I have friend told me, do not write complicate set analysis in the expression of the object, use an excel file , write in your formula there. Then load the formula excel file to the dashboard instead. 

I need help, is there anyone out there has a standard formula excel template that I can refer? And in terms of load editor script side, how should I write the script . And at the front end dashboard,  how should I call back the formula from the excel ? How the front end script should look like?

Please help.

Thanks

Jim

[Channa]

in xls create variables

vSales =Sun(sale)

u can use vSales as measure in your charts