Sensitivity Analysis-Data Table

[koklok123]

It is hard to put all this in words so I think if you look at the attachment to see what I'm looking for. I did include all the details there.
Basically it is a Sensitivity Analysis table but I not sure if sensitivity table can even handle this problem.

If you have any other Idea on how to solve problem please let me know.

P.S. I know I can just do things manually and get it over but it is for management and It needs to be automated.

Thanks

[shg]

See Help for Create a two-variable data table

[koklok123]

Well Shg,

I know how to create two variable data table but this doesn't sound that easy.
Maybe easy for somebody but not for me.

[koklok123]

Ok can someone at least tell me if formula can be outside of the table.
I mean does it always have to be in the top left corner of the table or I can have it somewhere else. And if I can do that please tell me how.
Thanks

[shg]

In E6, =N29

Select E6-J12, Data > Table

Row input cell: $C$9

Column Input cell: $C$4

Press OK

EDIT: Before that, copy F6:J6 and replace formulas with values. Ditto for E7:E12

[koklok123]

Shg,

You basically told me how make a sensitivity table which I already know.

[shg]

It completes the result that your example shows the beginning of. If that's not what you want, I haven't a clue, sorry.