spreadsheet like calculations on the fly?

  • Thread starter Thread starter MDBJ
  • Start date Start date
M

MDBJ

A possibly silly question

I'd like to take a matrix of of dates & rates (this for a motel)
I'd like to have a calendar, where a webvisitor indicates their intended
start & end dates either through clicking on a calendar for a start date,
and given x# of nights rates with total, or indicating an end date as well

the total to be presented is based on my spreadsheet

is this-- not impossible to do? with fp2003 as is?

bonus points, Ideally I'd like to make a spreadsheet from my current rates
sheet,
and if the rates change, just update the spreadsheet and have the new
numbers plug in...

can anyone throw me some research keywords my way?
 
Sounds like a job for a database.

--
Steve Easton
Microsoft MVP FrontPage
95isalive
This site is best viewed..................
...............................with a computer
 
sadly, the client is me, and i have more time than money at the momment,
I was planning on educating myself to this degree.

It appears what I'd need to do is dig really deeply into asp to get to this
level of 2-way data back to browsers.
 
I'd recommend an out of print book "Beginning Active Server Pages 2.0" by
WROX you can find at Amazon as it was considered the classic but it would be
better in the long run to use ASP.NET 2.0 which is very difficult to learn
for neophytes. There's also going to be a significant need for Javascript to
manage the calendar data selections.

It may prove more efficient to dump the spreadsheet and use a database on
the web server with an admin login or again use ASP.NET to integrate the
spreadsheet data from the desktop to the web.

<%= Clinton Gallagher
 
Back
Top