+ Reply to Thread
Results 1 to 8 of 8

Spreadsheet to program

  1. #1
    Forum Contributor
    Join Date
    06-05-2013
    Location
    Sweden
    MS-Off Ver
    Excel 2010
    Posts
    153

    Spreadsheet to program

    Hi!

    I've got a pretty extensive Excel document with genetic calculations, with lots of different calculations (on some sections it's in 16 000 rows across several hundred columns).

    The answers in all these cells change depending on what I write into only 28 original cells. Once all the calculations are done by Excel, the resluts will be presented in 1-16 cells.

    All I want now is for a program to convert the spread sheets into a simple little program or web app or something where someone can change the content of the 28 original cells and immediately see the result of the 1-16 cells. Is there a program that does this?

    This is basically all the information that I want to be visible in the resulting program, though all the calculations should be run in the background by the program. The yellow cells are the ones anyone should be able to change:

    Excel spreadsheet.png

    Sincerely,
    Tina,
    Sweden

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,011

    Re: Spreadsheet to program

    Insert another sheet called (say USER)
    in col.1 with only 28 cells the user will change. (these feed the true sheet)
    then column 3 will show the referenced 16 cells.
    Last edited by ranman256; 04-28-2014 at 03:32 PM.

  3. #3
    Forum Contributor
    Join Date
    06-05-2013
    Location
    Sweden
    MS-Off Ver
    Excel 2010
    Posts
    153

    Re: Spreadsheet to program

    Thing is, though, that this dokument has become so massive that when I try to insert any data in the 28 cells, Excel lags. I need a program that does all the calculations faster than Excel.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    49,713

    Re: Spreadsheet to program

    1 option *may* be to put all your basic data in a seperate workbook, and then just reference that with your formulas?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Forum Contributor
    Join Date
    06-05-2013
    Location
    Sweden
    MS-Off Ver
    Excel 2010
    Posts
    153

    Re: Spreadsheet to program

    You mean I have only the 28 cells where one can change the data and the 1-16 cells with the results in one document and then have all the other cells with formulas in another document and link them together? Will that also speed up the calculating process, or will it slow it down?

  6. #6
    Forum Contributor
    Join Date
    06-05-2013
    Location
    Sweden
    MS-Off Ver
    Excel 2010
    Posts
    153

    Re: Spreadsheet to program

    ...anyone?

  7. #7
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,637

    Re: Spreadsheet to program

    There's no obvious answer.

    If the workbook uses formulas to arrive at its results (versus VBA), then you would have to convert all of that to code. Pick a language you like (Java would be a common choice for a web app), get a development environment, and have at it.

    That said, this is an Excel/VBA forum, so may not be the best place to ask.
    Entia non sunt multiplicanda sine necessitate

  8. #8
    Forum Contributor
    Join Date
    06-05-2013
    Location
    Sweden
    MS-Off Ver
    Excel 2010
    Posts
    153

    Re: Spreadsheet to program

    Thank you anyways, though. You've given me the first clues about what to do.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Display Program Then Spreadsheet
    By lvlister2005 in forum Excel General
    Replies: 1
    Last Post: 04-07-2007, 11:21 AM
  2. [SOLVED] Can you open a new spreadsheet in a new program window?
    By 3R''s in forum Excel General
    Replies: 3
    Last Post: 11-09-2005, 09:10 PM
  3. Need Help Initializing Excel Spreadsheet Program
    By jb999 in forum Excel General
    Replies: 3
    Last Post: 11-02-2005, 07:15 PM
  4. [SOLVED] How do I access an unopened spreadsheet from a program?
    By Pete at Sappi Fine Paper in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-08-2005, 12:05 PM
  5. How to program a spreadsheet to do this?
    By Natalie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-27-2005, 07:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1