Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 18 of 18

Thread: Data Table from Spreadsheet Application

  1. #11
    MrExcel MVP shg's Avatar
    Join Date
    May 2008
    Location
    The Great State of Texas
    Posts
    21,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    12 Thread(s)

    Default Re: Data Table from Spreadsheet Application

    Quote Originally Posted by circledchicken View Post
    ... you can extend them for more complex scenarios by storing your scenarios elsewhere and making one of the input variables a scenario.
    Whuchoo talkin' about, CC?

  2. #12
    Board Regular
    Join Date
    Aug 2011
    Posts
    2,932
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Data Table from Spreadsheet Application

    Quote Originally Posted by shg View Post
    Whuchoo talkin' about, CC?
    Hey shg - talkin' bout multiway data tables.

    Here's are some examples, described in detail by the great man Hui himself:
    Data Tables & Monte Carlo Simulations in Excel – A Comprehensive Guide | Chandoo.org - Learn Microsoft Excel Online

  3. #13
    MrExcel MVP shg's Avatar
    Join Date
    May 2008
    Location
    The Great State of Texas
    Posts
    21,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    12 Thread(s)

    Default Re: Data Table from Spreadsheet Application

    I've not seen that, thank you. Bookmarked it for later perusal.

  4. #14
    Board Regular
    Join Date
    Aug 2011
    Posts
    2,932
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Data Table from Spreadsheet Application

    You're welcome. I find data tables quite useful and the techniques described in that post make them very flexible, especially where VBA is not used, or you want to break down complex formulae into a series of smaller, better documented steps and apply the results to a range of scenarios.

    Anyway, hope you like it.

  5. #15
    New Member
    Join Date
    Nov 2013
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Data Table from Spreadsheet Application

    Thanks, everybvody. I figured it out. All I had to do was to set one of the input parameters as equal to a cell in the data table. I used the CAS number of the chemical as the key input. So, I set the CAS number in the application =FirstCell_in_my_data_table Concentration was based on a VLOOKUP using another table with CAS numbers and concentrations. Then I could run a one-variable data table to get the results for all of the compounds!

  6. #16
    MrExcel MVP shg's Avatar
    Join Date
    May 2008
    Location
    The Great State of Texas
    Posts
    21,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    12 Thread(s)

    Default Re: Data Table from Spreadsheet Application

    Good job!

  7. #17
    New Member
    Join Date
    Nov 2013
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Data Table from Spreadsheet Application

    Now that I have the data table working, I wonder if I can run a macro or something to print a the data entry table on the first page of the application for each chemical. So, it would enter the chemical data, calculate the result, and then print the data entry table to a PDF. If that is too complicated, I think the only thing is to make a ton of copies of the data entry worksheet and the results worksheet, link things using VLOOKUP, print all worksheets and then delete everything I don't need. Seems like a lot of work. Must be an easier way.

  8. #18
    Board Regular
    Join Date
    Aug 2011
    Posts
    2,932
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Data Table from Spreadsheet Application

    It's difficult to tell without looking in more detail at the structure of your workbook, but for printing to pdf for example, see here for a number of useful options:
    Create and Mail PDF files with Excel 2007/2013

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •