Software for Excel to compute using GPU
Results 1 to 6 of 6

Thread: Software for Excel to compute using GPU
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jan 2017
    Posts
    135
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Software for Excel to compute using GPU

    Is anybody aware of any software that would allow Excel to use the GPU for computations?


    I'm currently working on a project and even when trying to optimize the sheets they will simply take too long to calculate.


    If you have any info I would greatly appreciate your comments.


    Thank you
    MM

  2. #2
    Board Regular Logit's Avatar
    Join Date
    Aug 2016
    Location
    United States
    Posts
    2,718
    Post Thanks / Like
    Mentioned
    36 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Software for Excel to compute using GPU


  3. #3
    Board Regular
    Join Date
    Jan 2017
    Posts
    135
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Software for Excel to compute using GPU

    Thanks for the link but I can't seem to find any specific mention as to how Excel can use GPU for calculations, Am I missing it?..........

  4. #4
    Board Regular Logit's Avatar
    Join Date
    Aug 2016
    Location
    United States
    Posts
    2,718
    Post Thanks / Like
    Mentioned
    36 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Software for Excel to compute using GPU

    .
    I misread your post (need my glasses). I thought it referred to CPU.

    After surfing the Net and reviewing a number of websites concerning a Graphics Processing Unit speeding up Excel .... my findings indicate
    the GPU isn't going to help at all. Seems like everyone is in agreement that the total amount of RAM you are using will determine how well
    Excel functions. Several sites spoke of their users having 8 / 16 / 32 / 64 gb of RAM and no one was using anywhere near 8 gb. One site
    said their users have 8 gb of RAM and they were only utilizing max o 3 gb with Excel.

    My personal experience has shown using Win10/64bit improved Excel performance. My machine has 32 gb of RAM. My CPU is a quad-core
    and is set to utilize all four as much as possible. There is a setting in Excel's options for this was well. I run Excel 2007 and the setting
    is located in ADVANCED / FORMULAS.

    Here is a link to one site where the members discussed the topic at length. I include this because it has a variety of input from the members
    which pretty much encapsulates what is to be found on any number of other sites.

    https://community.spiceworks.com/top...p-excel?page=2

    Hopefully others here on the Forum can add their experiences as well.

  5. #5
    Board Regular lrobbo314's Avatar
    Join Date
    Jul 2008
    Location
    California
    Posts
    2,381
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Software for Excel to compute using GPU

    I searched the internet as well and it seems like it really isn't an option. I did find a Korean website that claimed to have an add-in that could leverage GPU for Excel, but it isn't available for purchase from their website and doesn't have pricing available. It seems like it could technically be possible by writing dlls, but it would be a pretty involved process and might not work anyway because of the way that Excel works. Even writing your own program and leveraging GPU is pretty complicated. I would imagine that if you have that massive of an Excel file, that Excel is probably not the right platform for the job. Maybe using Access in conjunction with Excel. Although, Access has its own limitations as well. Might be time to upgrade to using a SQL server.
    To add code to a workbook. Hit Alt+F11. Hit Alt+I+M to insert new module. Then paste code.
    Array formulas must be entered by hitting Ctrl+Shift+Enter.

    We can't solve problems by using the same kind of thinking we used when we created them.

    Imagination is more important than knowledge.

  6. #6
    Board Regular
    Join Date
    Jan 2017
    Posts
    135
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Software for Excel to compute using GPU

    I'm not too sure about RAM and find it a little hard to truly understand it's relationship with Excel. I have 2 computers, an 7700K with 32G RAM and a 8700K with 16G RAM. I ran 20 instances of a workbook all at the same time, max out my CPU 100% and the RAM on the 7700K pushed 25G then the same test on the 8700K. I thought I would max out the RAM since I only had 16G but it never touched 16G but got close hitting 15G. These workbooks were massive, 200,000KB with intricate macros and running 20 of them all at the same time and still didn't use all the RAM available. I really have no idea how or why but just interesting overall.


    I reached out to the Korean company mentioned and will let you know if anything comes of it.

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
  •