I did a project a while back where an Excel app was querying an Oracle
database, the original spreadsheet had 100K rows or more and took over 6
hours to process its calculations. By pulling out the macro style code and
recorded code, and of course reducing the amount of row data I managed to
get
Um.
Probably the best way to think of Analysis Services is that it's the
server-side equivalent of an Excel pivot table (that is, rather than the client
- excel - having to do the pivoting itself from the raw data, the pivoting can
be done on the server and the client only gets the results).
Each row is calculated from the previous one. The formula for the
calculation shouldn't change if that helps any. The starting value would be
variable and there is some variables in the formula. Compound interest
kinda stuff.
I'm still debating if it can all be done client side or if it should be
Does the existing data provide a seed or default for a new row (which can be
overwritten), or is it a true accumulation (which cant)? And if the latter, how
much data are we talking about?
You can use lead and lag in SQL (2012) to perform these kind of projections,
but if generally suggest
Um.
Probably the best way to think of Analysis Services is that it's the
server-side equivalent of an Excel pivot table (that is, rather than the client
- excel - having to do the pivoting itself from the raw data, the pivoting can
be done on the server and the client only gets the results).
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
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
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
Stephen, there are at least 2 (not-free, expensive) .NET libraries that do a
good job of being a spreadsheet, but I don't know if either can simply scan
an existing Excel spreadsheet ecosystem or even a simple XLS or XLSX file to
make it into an application.
For your simple description, it may
-Original Message-
From: ILT (O) il.tho...@outlook.com
Sent: 28/03/2014 3:40 PM
To: 'ozDotNet' ozdotnet@ozdotnet.com
Subject: RE: Spreadsheets and data
Stephen, there are at least 2 (not-free, expensive) .NET libraries that do a
good job of being a spreadsheet, but I don’t know if either can
10 matches
Mail list logo
