excell - pass parameter?

[JeroenB]

hi all,

I am puzzled with the following issue; hope someone can help me out...

PROBLEM DESCRIPTION:

I have a first Excell Worksheet (sheet 1) with a list of dates:

(Sheet 1 - Column A)

1 15-May-95
2 16-May-95
3 17-May-95
4 18-May-95
5 19-May-95
6 20-May-95
7 21-May-95
8 ...
[/color red]
I have a second Worksheet (Sheet 2) containing an algorithm which takes several input parameters (among which a year, month and day value). The input parameters of the algorithm (which calls many sub-formulas) are provided in column A of Sheet 2:

(Sheet 2 - Column A)

1 yyyy (year)
2 mm (month)
3 dd (day)
4 parameter x
5 parameter y
6 ...
[/color red]
The result of the algorithm is conveyed in cell 1B of Sheet 2 (the algorithm itself is implemented in several other Sheets):

(Sheet 2 - Column B)

1 result algorithm
[/color red]
QUESTION:

How can I add a second column in Sheet 1, containing the results of applying the algorithm for each input date (year/month/day) value provided in Column A of Sheet 1?

many thanks in advance!

j

 

[KenWright]

Lookup 'One-variable data table' or 'Two-Variable data table' in Help. Depending on your version you may just want to search for 'Data Table'

This assumes you take an input, do stuff to it via some kind of algorithm, and then spit out an answer. It allows you to set up a table of values for your input(s) variable(s), and then calculates all the values for those variables as if you had run them through the algorithm.

Regards
Ken..................

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------