h2g2 The Hitchhiker's Guide to the Galaxy: Earth Edition

I'm trying to convert an Excel spreadhseet to put it onto the internal web system that we use. I can get most of it, but I want the system to do some maths using one input value and a preset value. I can get most of it, but I can't seem to get it to do the maths.
Any ideas anyone?
I can supply the spreadsheet if necesary.

HTML does not really do maths on its own. For that you need something extra - JavaScript. I think you probably want to turn your spreadsheet into an HTML form with some JavaScript code to act on button presses and turn an input value into an output one. You can get books on how to do this or look on the internet. You might also want to speak to the researchers at A623666 or A604937.

If you don't mind a little scripting you can import the values from an Excel spreadsheet using Perl and an appropriate module (there are several on cpan.org). Then you can manipulate the numbers and formatting however you like.

You may be able to leave it as an XLS (Excel) file, if all your computers have Excel. Otherwise, convert it to the universal CSV file format (so it can be read by other spreadsheet programs: if you have pictures, colours or have specified fonts for this, they will be removed in this format).

The alternative is to create a table in HTML (see "tables" under A908903) and/or use the tag with javascript or visual basic.

Copy + Past this code into the body of a HTML document (edit using Notepad)

Value 1
Answer


I've chucked this onto:
http://www.geocities.com/compunach?silly&example.htm


To see how another website has put in spreadsheet data, visit http://www.statistics.gov.uk

If you want me to have a look at it, e-mail it to:
[email protected]