RE: Spreadsheets and data

2014-03-30 Thread Andrew Coates (DPE AUSTRALIA)
Another option is to use Excel Web Serviceshttp://msdn.microsoft.com/en-us/library/office/ms546696(v=office.14).aspx to expose cells (and ranges) as inputs and outputs. Means you can leave the calculation stuff in Excel (which can be updated by the domain expert without needing a coder to

Re: Spreadsheets and data

2014-03-30 Thread Preet Sangha
Stephen, SQL Server Analysis Cubes are essentially multidimensional spreadsheets. Preet Sangha On 28 March 2014 20:03, Stephen Price step...@perthprojects.com wrote: Hey all, Wondering if anyone has taken a spreadsheet and turned it into an app before? This spreadsheet has lots of data

Re: Spreadsheets and data

2014-03-30 Thread Stephen Price
As much as it's probably more work to convert the formulas into code, once it's done there shouldn't be any updating etc to be done. Hope not anyway, I think that would be labeled as scope creep? Don't have Sharepoint in the picture. Will read up on SQL cubes to see if that's something I can use