Take a look at KDCalc, which would run your Excel
spreadsheet on the web,
also Exceleverywhere.
Regards, Russell Thoms.
FleetPro, bond
-----Original Message-----
From: ASP.NET Architecture digest
[mailto:aspnet-architecture aspadvice.com]
Sent: 08 September 2006 05:00
To: aspnet-architecture digest recipients
Subject: aspnet-architecture digest: September 07, 2006
ASPNET-ARCHITECTURE Digest for Thursday, September 07, 2006.
1. RE: Complex Spreadsheet to ASP.NET
2. RE: tcp connection webservice?
3. RE: Complex Spreadsheet to ASP.NET
4. RE: Complex Spreadsheet to ASP.NET
------------------------------------------------------------
----------
Subject: RE: Complex Spreadsheet to ASP.NET
From: "Doug K. Wilson" <dougfridge.com>
Date: Wed, 6 Sep 2006 17:12:11 -0700
X-Message-Number: 1
Thanks for the responses so far!
> What is the output supposed to look like?=20
The application is a financial calculator. The output is a
series of
graphs and tables for monthly and annual performance ranging
over a
period of 10-25 years. Over that range we need to compare
the actual
performance against the baseline, continually updating the
actuals
(monthly/quarterly). Additionally, some of the initial
variables can
change over time as well, for example, the prime interest
rate. These
changes must be applied to both the baseline and the actual
from that
point forward.
What I'm really looking for is ideas on how to approach the
Data Model,
and specifically, the bit where the computed values are
overridden with
actual values.
When I take a step back and look at this problem, the
existing
spreadsheet does the job really well. The reasons for
turning it into
an application (web or otherwise) are to protect the
formulas from the
users and make it safer to distribute. (Currently they get
messed up
quite easily and because of the need to override a computed
value with
an actual value, we can't simply apply protection to the
cells. Well,
that and a lot of the users are not technically savvy.
Introducing a
wizard like process for initial setups and regular updates
will make a
lot of people very happy.) =20
If there was a way to safely automate Excel server side,
that would be a
good solution. Unfortunately that is not the case and while
I'm sure I
don't need to create (or license) a "server
safe" spreadsheet, I am
looking to get part way there: spreadsheet like calculation
functionality without a user interface.
Any more thoughts?
dw
-----Original Message-----
From: Tim Curtin [mailto:tjc_tekhotmail.com]=20
Sent: Wednesday, September 06, 2006 2:01 PM
To: aspnet-architectureaspadvice.com
Subject: [aspnet-architecture] RE: Complex Spreadsheet to
ASP.NET
if the # of input controls are fixed. then put a 'submit'
button and=20
double-click it to create a server-side event handler. Then
do a
boat-load=20
of if statements based on each of the input fields storing
values/defaults=20
in variables. Then at the end of the routing do your
calculation.
What is the output supposed to look like?=20
>From: "Doug K. Wilson" <dougfridge.com>
>Reply-To: aspnet-architectureaspadvice.com
>To: aspnet-architectureaspadvice.com
>Subject: [aspnet-architecture] Complex Spreadsheet to
ASP.NET
>Date: Wed, 6 Sep 2006 13:28:23 -0700
>
>Hi All,
>
>I'm just starting down the road of converting a very
complex Excel
>spreadsheet into a multi-user web based application. As
you would
>expect, there are a lot of functions and formulas spread
across many
>worksheets that will need to be turned into business
logic and have a
>user interface applied. There is no need to emulate a
spreadsheet
here,
>as all of the calculations are based off about a dozen
user entered
>values. Where it gets interesting is that as time
progresses,
>calculated values need to be overridden with actual
values and
>re-incorporated into the remaining calculations.
>
>I'm a bit of a loss at where to start, specifically
with managing the
>sheer number of calculations that need to be done. I'd
appreciate any
>suggestions, especially regarding architecture and/or
book
>recomendations.
>
>TIA
>
>Doug Wilson
>
>
>
>Need SQL Advice? http://sqladvice.com
>Need RegEx Advice? http://regexadvice.com
>Need XML Advice? http://xmladvice.com
Need SQL Advice? http://sqladvice.com
Need RegEx Advice? http://regexadvice.com
Need XML Advice? http://xmladvice.com
------------------------------------------------------------
----------
Subject: RE: tcp connection webservice?
From: "Michal Tesar" <michal.tesargmail.com>
Date: Thu, 7 Sep 2006 07:35:54 +0200
X-Message-Number: 2
Thank you guys, I will try to talk to them if they can set
up a simple
webservice, after all there will be only one message type. I
will let you
know if they can do it.
Thank you very much for your input,
Mike
----- Original Message -----
From: "Paul Glavich" <glavaspalliance.com>
To: <aspnet-architectureaspadvice.com>
Sent: Thursday, September 07, 2006 5:49 AM
Subject: [aspnet-architecture] RE: tcp connection
webservice?
> Here is what I'd do.
>
> Expose a web service to accept requests.
> Your middle-tier then passes that request to a web
service downstream of
> your design. Initially, that web service may exist
locally on your system.
>
> So your middle-tier is simply accepting data via web
service, and sending
> to
> another web service. Thats the middle tier done and you
have separated out
> the tier from being tightly coupled to always sending
to a particular type
> of downstream 3rd party.
>
> That final web service then only has to worry about how
to connect to the
> third party system (remember, initially this service
may be hosted locally
> on the same machine as your middle tier component).
I'd advise trying to
> get
> them to expose a web service, or something that accepts
HTTP POST data as
> that is pretty easy. Ideally, if they could use the
service that you have
> defined on their system, you would have an easy job of
sending data to it.
> If not, then you may have to deal with TCP
communications, it really
> depends
> on what they will expose. I would expect this to change
over time though
> as
> they perhaps formalise/enhance their method of
communications though. The
> beauty of this design is never having to change your
middle-tier at all,
> just the implementation of your downstream service.
>
> - Glav
>
>
> -----Original Message-----
> From: Peter Suter [mailto:petersuterozemail.com.au]
> Sent: Thursday, 7 September 2006 8:19 AM
> To: aspnet-architectureaspadvice.com
> Subject: [aspnet-architecture] RE: tcp connection
webservice?
>
> I have recently been building almost exactly what
you've just specified.
> Let
> me know if you're interested in buying.
>
> I use a webservice to accept the request, a tpc socket
connection to the
> 3rd
> system to pass the request on and get it's response,
followed by sending
> the
> response from the webservice.
>
>
> ' A basic TCP/IP send via socket:.
> Dim sender As New Socket(AddressFamily.InterNetwork,
SocketType.Stream,
> ProtocolType.Tcp)
> sender.Connect(remoteEP)
> Dim msg As Byte() = Encoding.ASCII.GetBytes(SendPacket)
> Dim bytesSent As Integer = sender.Send(msg)
>
> Best Regards
> Peter Suter
> Adaptable Business Software
> http://www.adapta
blesoftware.com.au
> petersuteradaptablesoftware.com.au
>
>
> ----- Original Message -----
> From: "Michal Tesar" <michal.tesargmail.com>
> To: <aspnet-architectureaspadvice.com>
> Sent: Wednesday, September 06, 2006 7:11 PM
> Subject: [aspnet-architecture] tcp connection
webservice?
>
>
>> Hi All,
>>
>> I have few questions and I couldn't find anything
good on google about
>> this, if someone could point me to some direction,
or give me any advice
>> on this problem I have, I would really appriciate
it.
>>
>> I have to build a system, which will accept a
request(structured xml)
>> from
>
>> another location, I then have to save some
information from this request
>> into my database, and pass the request on to
another system (another
>> location).
>>
>> The third system (the one my application will pass
the request on) has
>> those specifications:
>> The system features a simple single request
dialogue. Using the
>> connection-oriented feature of the TCP connection
the system is able to
>> detect if the response was successfully delivered
to MySystem. In the
>> event that the response is not successful 3rdSystem
will perform a
>> real-time roll-back of the reserved request.
>>
>> Communication:
>> I need to establish a TCP socket connection to the
3rdSystem to a
>> designated PORT.
>> The socket is closed after each Request/Response.
Multiple connections
>> can
>
>> be running
>> at the same time.
>>
>> Security:
>> The IP address and port number will be provided for
each client. A VPN
>> connection needs to be set up.
>>
>> When I receive the response from the 3rdSystem, I
will pass it on to the
>> first client that is waiting for the response from
the begenning.
>>
>> I need to make the middle software, so I am
thinking that I would
>> implement the same thing the 3rdSystem has. And I
would pass on the same
>> requirements to the client, I need something very
simple and fast.
>>
>> I've got no idea how TCP protocol works, and if I
should do this via a
>> .net webservice, or how?
>>
>> Please help!
>>
>> Thank you,
>> Mike
>>
>>
>> Need SQL Advice? http://sqladvice.com
>> Need RegEx Advice? http://regexadvice.com
>> Need XML Advice? http://xmladvice.com
>>
>
>
>
> Need SQL Advice? http://sqladvice.com
> Need RegEx Advice? http://regexadvice.com
> Need XML Advice? http://xmladvice.com
>
>
>
> Need SQL Advice? http://sqladvice.com
> Need RegEx Advice? http://regexadvice.com
> Need XML Advice? http://xmladvice.com
>
>
> --
> Internal Virus Database is out-of-date.
> Checked by AVG Free Edition.
> Version: 7.1.405 / Virus Database: 268.11.7/434 -
Release Date: 8/30/2006
>
>
------------------------------------------------------------
----------
Subject: RE: Complex Spreadsheet to ASP.NET
From: "Steven A Smith" <steven.smithaspalliance.com>
Date: Thu, 7 Sep 2006 12:20:02 -0400
X-Message-Number: 3
For Excel automation, look to SoftArtisans OfficeWriter.
You can basically
take your Excel sheet and turn it into a template that is
then populated
server-side with values based on (whatever you want -- user
input, some
wizard, etc). It's quite slick.
Steve
--
Steven A Smith
President, http://ASPAlliance.com
Microsoft Regional Director | Microsoft ASP.NET MVP |
ASPInsider
ssmithaspalliance.com
-----Original Message-----
From: Doug K. Wilson [mailto:dougfridge.com]
Sent: Wednesday, September 06, 2006 8:12 PM
To: aspnet-architectureaspadvice.com
Subject: [aspnet-architecture] RE: Complex Spreadsheet to
ASP.NET
Thanks for the responses so far!
> What is the output supposed to look like?
The application is a financial calculator. The output is a
series of graphs
and tables for monthly and annual performance ranging over a
period of 10-25
years. Over that range we need to compare the actual
performance against
the baseline, continually updating the actuals
(monthly/quarterly).
Additionally, some of the initial variables can change over
time as well,
for example, the prime interest rate. These changes must be
applied to both
the baseline and the actual from that point forward.
What I'm really looking for is ideas on how to approach the
Data Model, and
specifically, the bit where the computed values are
overridden with actual
values.
When I take a step back and look at this problem, the
existing spreadsheet
does the job really well. The reasons for turning it into
an application
(web or otherwise) are to protect the formulas from the
users and make it
safer to distribute. (Currently they get messed up quite
easily and because
of the need to override a computed value with an actual
value, we can't
simply apply protection to the cells. Well, that and a lot
of the users are
not technically savvy. Introducing a wizard like process
for initial setups
and regular updates will make a lot of people very happy.)
If there was a way to safely automate Excel server side,
that would be a
good solution. Unfortunately that is not the case and while
I'm sure I
don't need to create (or license) a "server
safe" spreadsheet, I am looking
to get part way there: spreadsheet like calculation
functionality without a
user interface.
Any more thoughts?
dw
-----Original Message-----
From: Tim Curtin [mailto:tjc_tekhotmail.com]
Sent: Wednesday, September 06, 2006 2:01 PM
To: aspnet-architectureaspadvice.com
Subject: [aspnet-architecture] RE: Complex Spreadsheet to
ASP.NET
if the # of input controls are fixed. then put a 'submit'
button and
double-click it to create a server-side event handler. Then
do a boat-load
of if statements based on each of the input fields storing
values/defaults
in variables. Then at the end of the routing do your
calculation.
What is the output supposed to look like?
>From: "Doug K. Wilson" <dougfridge.com>
>Reply-To: aspnet-architectureaspadvice.com
>To: aspnet-architectureaspadvice.com
>Subject: [aspnet-architecture] Complex Spreadsheet to
ASP.NET
>Date: Wed, 6 Sep 2006 13:28:23 -0700
>
>Hi All,
>
>I'm just starting down the road of converting a very
complex Excel
>spreadsheet into a multi-user web based application. As
you would
>expect, there are a lot of functions and formulas spread
across many
>worksheets that will need to be turned into business
logic and have a
>user interface applied. There is no need to emulate a
spreadsheet
here,
>as all of the calculations are based off about a dozen
user entered
>values. Where it gets interesting is that as time
progresses,
>calculated values need to be overridden with actual
values and
>re-incorporated into the remaining calculations.
>
>I'm a bit of a loss at where to start, specifically
with managing the
>sheer number of calculations that need to be done. I'd
appreciate any
>suggestions, especially regarding architecture and/or
book
>recomendations.
>
>TIA
>
>Doug Wilson
>
>
>
>Need SQL Advice? http://sqladvice.com
>Need RegEx Advice? http://regexadvice.com
Need XML Advice?
>http://xmladvice.com
Need SQL Advice? http://sqladvice.com
Need RegEx Advice? http://regexadvice.com
Need XML Advice?
http://xmladvice.com
Need SQL Advice? http://sqladvice.com
Need RegEx Advice? http://regexadvice.com
Need XML Advice?
http://xmladvice.com
------------------------------------------------------------
----------
Subject: RE: Complex Spreadsheet to ASP.NET
From: "Eli Robillard" <elierobillard.com>
Date: Thu, 7 Sep 2006 12:41:01 -0400
X-Message-Number: 4
Excel Server is a part of SharePoint Server 2007, and it's
designed for
exactly this purpose. The technical refresh (B2TR) will be
released in the
next couple weeks, you might want to look into it.
Otherwise, since the goal
is to protect the source data, you might look at ways of
either using your
Excel numbers as a data source using ODBC and generating
your reports and
graphs from that - basically letting Excel do what it's
good at and just add
a web presentation layer. Or find a convenient way to take a
snapshot of
your results from inside Excel - basically to export the
charts produced by
Excel.
Cheers,
Eli.
-----Original Message-----
From: Doug K. Wilson [mailto:dougfridge.com]
Sent: September 6, 2006 8:12 PM
To: aspnet-architectureaspadvice.com
Subject: [aspnet-architecture] RE: Complex Spreadsheet to
ASP.NET
Thanks for the responses so far!
> What is the output supposed to look like?
The application is a financial calculator. The output is a
series of graphs
and tables for monthly and annual performance ranging over a
period of 10-25
years. Over that range we need to compare the actual
performance against
the baseline, continually updating the actuals
(monthly/quarterly).
Additionally, some of the initial variables can change over
time as well,
for example, the prime interest rate. These changes must be
applied to both
the baseline and the actual from that point forward.
What I'm really looking for is ideas on how to approach the
Data Model, and
specifically, the bit where the computed values are
overridden with actual
values.
When I take a step back and look at this problem, the
existing spreadsheet
does the job really well. The reasons for turning it into
an application
(web or otherwise) are to protect the formulas from the
users and make it
safer to distribute. (Currently they get messed up quite
easily and because
of the need to override a computed value with an actual
value, we can't
simply apply protection to the cells. Well, that and a lot
of the users are
not technically savvy. Introducing a wizard like process
for initial setups
and regular updates will make a lot of people very happy.)
If there was a way to safely automate Excel server side,
that would be a
good solution. Unfortunately that is not the case and while
I'm sure I
don't need to create (or license) a "server
safe" spreadsheet, I am looking
to get part way there: spreadsheet like calculation
functionality without a
user interface.
Any more thoughts?
dw
-----Original Message-----
From: Tim Curtin [mailto:tjc_tekhotmail.com]
Sent: Wednesday, September 06, 2006 2:01 PM
To: aspnet-architectureaspadvice.com
Subject: [aspnet-architecture] RE: Complex Spreadsheet to
ASP.NET
if the # of input controls are fixed. then put a 'submit'
button and
double-click it to create a server-side event handler. Then
do a boat-load
of if statements based on each of the input fields storing
values/defaults
in variables. Then at the end of the routing do your
calculation.
What is the output supposed to look like?
>From: "Doug K. Wilson" <dougfridge.com>
>Reply-To: aspnet-architectureaspadvice.com
>To: aspnet-architectureaspadvice.com
>Subject: [aspnet-architecture] Complex Spreadsheet to
ASP.NET
>Date: Wed, 6 Sep 2006 13:28:23 -0700
>
>Hi All,
>
>I'm just starting down the road of converting a very
complex Excel
>spreadsheet into a multi-user web based application. As
you would
>expect, there are a lot of functions and formulas spread
across many
>worksheets that will need to be turned into business
logic and have a
>user interface applied. There is no need to emulate a
spreadsheet
here,
>as all of the calculations are based off about a dozen
user entered
>values. Where it gets interesting is that as time
progresses,
>calculated values need to be overridden with actual
values and
>re-incorporated into the remaining calculations.
>
>I'm a bit of a loss at where to start, specifically
with managing the
>sheer number of calculations that need to be done. I'd
appreciate any
>suggestions, especially regarding architecture and/or
book
>recomendations.
>
>TIA
>
>Doug Wilson
>
>
>
>Need SQL Advice? http://sqladvice.com
>Need RegEx Advice? http://regexadvice.com
Need XML Advice?
>http://xmladvice.com
Need SQL Advice? http://sqladvice.com
Need RegEx Advice? http://regexadvice.com
Need XML Advice?
http://xmladvice.com
Need SQL Advice? http://sqladvice.com
Need RegEx Advice? http://regexadvice.com
Need XML Advice?
http://xmladvice.com
---
END OF DIGEST
Need SQL Advice? http://sqladvice.com
Need RegEx Advice? http://regexadvice.com
Need XML Advice? http://xmladvice.com
--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.1.406 / Virus Database: 268.12.1/440 - Release
Date: 06/09/2006
Need SQL Advice? http://sqladvice.com
Need RegEx Advice? http://regexadvice.com
Need XML Advice? http://xmladvice.com
|