Converting Spreadsheets???

Cailean

I need to convert a spreadsheet (Excel) calculation into a more user-friendly PHP script...

the basic function of the spreadsheet is this (I'm not asking for full code, just a nudge in the right direction)

Row one is a list of large numbers (entered by user) with each column representing a unique entity,
Each successive row is the value of row1 divided by increasing integers (+1)...

the final requirement is to identify the x number of largest numbers in the matrix and then SUM those by column... (I haven't been able to get Excel to do this which is partly why I'm trying php)

I'd be happy to get just the first bit...

Am I insane?

EDIT: I've sifted through a bunch of the Excel related posts here but most have to do with importing/exporting pure data - what I need is a way for PHP to do what my Excel formulas do...

devinemke

a very basic example:

<?
echo '
<form action="" method="POST">
enter a number: <input type="text" name="num" value="'; if (isset($_POST['num'])) {echo $_POST['num'];} echo '">
<input type="submit" name="submit" value="submit">
</form>
';

if (isset($_POST['submit']) && $_POST['num'])
{
	echo '
	<table border=1>
	<tr><td><b>number entered</b></td><td><b>' . $_POST['num'] . '</b></td></tr>
	';

for ($i = 1; $i <= 10; $i++)
{
	echo '<tr><td>divided by ' . $i . '</td><td>' . $_POST['num'] / $i . '</td></tr>';
}

echo '</table>';
}
?>

Cailean

Thanks for the help... I actually got a fair ways on my own since I posted using a for loop to create an array with the dividend values and displaying them so that I can use the values again, the output has two columns, one with the divisor and one with the dividend... my next step is to multi dimensionalize the array to hold more than one column of dividends.

Cailean

Here's what I've got so far... it only does half the job, but one step at a time... The script currently calculates for 5 columns, any suggestions how to make this number variable?

removed...

I'll still take suggestions on part 2... that is, finding the highest x numbers from all the columns and counting how many come from each column...

EDIT: In case anyone is wondering, I have considered that using MySQL may be necessary here... and in the end, that may be preferable to save the results, but for now I'd like to see the logic played out without the DB if possible...

EDIT2: Well, got it working on my own... thanks to anyone who took a look.