Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
data tables
I have a modest spreadsheet i'm using for a linear
programming problem which computes five results from two inputs. I am trying to automate the process so i don't have to manually change the inputs and then transfer the outputs by hand. THE data table function would do the trick but i can't figure out what to use for the function. the functional dependences are not easily describable with a formula like x,y=f(a,b,c,d,e) that can be entered into one cell. Rather they are buried in the formulas that make up the spreadsheet. I tried using "scenarios" but the manual data entry and transfer of the results is too much for me. This seems like a common need. WHat am I missing? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing Data Tables formed from importing data from Access | Excel Discussion (Misc queries) | |||
PLEASE ANYONE ... DATA IMPORT EXTERNAL DATA - WEB TABLES | Excel Discussion (Misc queries) | |||
DATA > TABLE -- 2 variable data tables? | Excel Worksheet Functions | |||
DATA > TABLE -- 2 variable data tables? | Excel Discussion (Misc queries) | |||
How to cause a pivot tables to not summarize data - just report the data | Excel Discussion (Misc queries) |