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 (and easily wrap my head around). thanks! On Mon, Mar 31, 2014 at 8:57 AM, Preet Sangha <[email protected]> wrote: > Stephen, > > SQL Server Analysis Cubes are essentially multidimensional spreadsheets. > > Preet Sangha > > > On 28 March 2014 20:03, Stephen Price <[email protected]> wrote: > >> Hey all, >> >> Wondering if anyone has taken a spreadsheet and turned it into an app >> before? >> >> This spreadsheet has lots of data that used the previous row to calculate >> the new row's data (as spreadsheets often do). Was wondering how the best >> way to duplicate that functionality in a .Net app with classes/database. >> >> Possible ways I've thought of; >> 1. Class that calculates on the fly the desired row/year of data each >> time it needs it. >> >> 2. The spreadsheet takes some starting values and the applies a formula >> to each row, could do the same thing in memory in a lookup dictionary or >> similar so it only needs to be done once. >> >> 3. Alternatively put that data into tables in database... downside, if >> the initial value is changed it would have to find and modify the >> appropriate rows in the database. >> >> other ways? >> >> cheers, >> Stephen >> >> >> > > > -- > regards, > Preet, Overlooking the Ocean, Auckland >
