Spreadsheets and data
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
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 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 well be that there is a Codeplex project does those straight-forward non-recursive operations, perhaps with a few simple Excel-like functions. I would doubt that such a project or code library would handle anything more like most businesses' use of Excel. Unless you want to make a VSTO application? _ Ian Thomas Victoria Park, Western Australia From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Stephen Price Sent: Friday, March 28, 2014 3:03 PM To: ozDotNet Subject: Spreadsheets and data 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
RE: Spreadsheets and data
Not quite what I was after. The prototype uses excel. The finished webapp will have nothing to do with excel. More interested in how to produce the json that the graphs bind to. At this point will most likely create it on the fly but will fall back to database if that's too slow. Ta -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 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 well be that there is a Codeplex project does those straight-forward non-recursive operations, perhaps with a few simple Excel-like functions. I would doubt that such a project or code library would handle anything more like most businesses’ use of Excel. Unless you want to make a VSTO application? Ian Thomas Victoria Park, Western Australia From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Stephen Price Sent: Friday, March 28, 2014 3:03 PM To: ozDotNet Subject: Spreadsheets and data 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
Powershell Training Course
Hi, I have a new sys-admin and before he starts I'd like to put him on an intensive 2 week powershell online training course. Anyone can recommend a PS course that is intense and well focused for sys-admins role? I'd like the course to have an Azure management component as well. Thanks, Corneliu.
Re: Powershell Training Course
I have a new sys-admin and before he starts I'd like to put him on an intensive 2 week powershell online training course. Two weeks intensive, wow! I reckon you and I could write powershell in that time ;-) Greg