It would be nice to have the option to list variables horizontally instead of only vertically. i.e. Row #1 in excel would list all the variables. Row #2 would list all the variable values underneath each variable. Row #3 would contain the excel formulas, and finally Row #4 would display the XLC formula.

I currently have a need for such a feature in a 'USE CASE' matrix I am creating for a finance related software application.

Thanks,

iAmDmAn.

iamdman - Why don't you send me a sample spreadsheet of what you are trying to achieve and I'll have a think about it?

Hi iamdman:

John Doyle will provide you he real solution. From me in the following is a workaround ...

The image shows the variables laid out in the conventional vertical alignment in cells A1:A5 and the associated values in cells B1:B5.

I copied the variable names in cells A1:A5 and transposed them in cells A11:E11. For values, I entered the cell name B1 of the value of the variable A1 in cell A12, and then dragged B1 to the right to get the associated values B1, B2, B3, B4, and B5

in cell A13 I keyed in the formula ... =ODI(B1*B2*(B3-((B2*B1)/(1.7*B4*B5))))/UDI(1000000)

then in cell B13, I created the XLC equation for the formula in cell A13 ... then I moved the EQS function in cell B13 to cell A14, and I moved the graphic of the equation for fomula in cell A13 also to cell A14.

I could similarly create a formula in cell B13, and then move the associated EQS function from cell C13 to cell B14, and so on for mulas in cells C13, D13, and E13.

This workaround requires first keying in the variables first in the vertical orientation and then recreating them in the horizontal orientation. For this reason alone, this workaround may or may not work for you.

I noticed that for the image in my previous post I had not included the Row Numbers and the Column Names. So here is the image with Row Numbers and Column Names included ...

The EQS() function (EQuation Show) takes a cell reference whose formula will be rendered as an equation. So there is no reason why equations cannot be displayed below the cell containing the formula - just drag it there and hit the redraw button (equations are always rendered over the cell containing an EQS() function.
The problem is with naming cells because XLC assumes that all cell names are to the left hand side of the cell that is named.
Potential solutions:
1) Get XLC to check if name is defined above the cell if it is not named on the left.
2) Introduce a EQNAME() function which takes a cell reference as a parameter.
I don't clearly see how useful this functionality would be so if iamdman could give me an insight as to what he is trying to achieve I can weigh up if it is worth developing.

Hi there,

Attached is an image that explains what I am trying to do. Row 5 and 10 represent the input and output variable names respectively. Row 11 is where I would like to show the XLC formula.



Displaying the inputs, outputs and formulae vertically just does not make sense to the reader in my situation.

Thoughts?

Thanks.