+ Reply to Thread
Results 1 to 5 of 5

Price Simulation in Excel or Access or both?

Hybrid View

  1. #1
    Registered User
    Join Date
    03-04-2015
    Location
    London, England
    MS-Off Ver
    Microsoft 365
    Posts
    18

    Price Simulation in Excel or Access or both?

    Hi, I have a large Excel file with many data Sheets and Complex formulas. The last Sheet is a price simulator. When I input certain number of product, It shows me below the simulated cost. But the problem is that the Excel must be private, except the last Price simulator Sheet which should be public or several people using it. So my idea was making like Access FORM. Or import data from Excel to Acces....but I think it's a bad idea. So What do you suggest me?

    Excel o Access? Will all complex formulas I use in Excel can work in Access too? The SQL is same or more powerful than Excel?

    Or how to just "show" the last excel sheet like a GUI programm. Or Make an interfacte to connect and show the specific sheet for data input-simulation.

    Thanks in advance,

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.95 for Mac MS 365
    Posts
    8,682

    Re: Price Simulation in Excel or Access or both?

    If you want to use excel and don't want others to see your other sheets you can use the very hidden feature in excel but you have to note the sheet names to unhindered them and it takes vba code to unhide them again.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Price Simulation in Excel or Access or both?

    If this is an application where several people are using it, especially at the same time, a database, in my opinion, is the better tool. With a large amount of data with many tables, the database will be much faster. At least that has been my experience with an Oracle database.

    Use the capabilities of the database to produce the user forms and use Excel to "number crunch" report data.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  4. #4
    Registered User
    Join Date
    03-04-2015
    Location
    London, England
    MS-Off Ver
    Microsoft 365
    Posts
    18

    Re: Price Simulation in Excel or Access or both?

    I forgot to mention that we work in network, so everyone uses their own computer.

  5. #5
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Price Simulation in Excel or Access or both?

    My experiments using Excel over a network for simultaneous access didn't work out very well. Databases are more equipped to do this, in my opinion. (think banking and their databases)

+ 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. Replies: 1
    Last Post: 07-05-2014, 02:45 AM
  2. Bootstrapping of stock price (Data based simulation)
    By Ajohs in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-02-2013, 11:25 AM
  3. Replies: 3
    Last Post: 01-03-2013, 12:32 AM
  4. Replies: 4
    Last Post: 08-15-2012, 09:49 AM
  5. simulation using excel
    By whattodo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-29-2011, 10:55 AM

Tags for this Thread

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