![[H]ard|Forum](/styles/hardforum/xenforo/logo_dark.png){kind=logo}
Navigation
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
More options
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
excel 2007 threading
- Thread starter Xethril
- Start date
It does but the extent to which it works depends on your sheet. I don't know the details but I imagine that if the calculations need to be done in order, then multi-threading doesn't get you much. If a lot of the calculations are being done in parallel then you get more out of it.
I do a lot of log parsing and have only seen it use one core.
To be honest, if you're doing as many comparisons as you say you are, it might be better to learn a slightly lower level language like PHP and tie it together with the data in an SQL database (as an example). Essentially you're hitting the limits of Excel's functionality and might be better served by a more advanced/enterprise level solution.
To be honest, if you're doing as many comparisons as you say you are, it might be better to learn a slightly lower level language like PHP and tie it together with the data in an SQL database (as an example). Essentially you're hitting the limits of Excel's functionality and might be better served by a more advanced/enterprise level solution.
Excel is single threaded.
I don't know your budget but "trillions of comparisons" sounds like a serious enterprise BI tool on top of a real DB unless you are doing some kind of mathematical factorial or proteinomics compares in which case you still need a different tool than excel (and the right custom data persistence).
I don't know your budget but "trillions of comparisons" sounds like a serious enterprise BI tool on top of a real DB unless you are doing some kind of mathematical factorial or proteinomics compares in which case you still need a different tool than excel (and the right custom data persistence).
Enduring_Warrior
[H]ard|Gawd
- Joined
- Sep 22, 2004
- Messages
- 1,973
If your going Scientific I seriously recommend you a Cluster, Fortran 90 and MPICH. That's the thing for doing Matricial calculations. Fortran despite being an oldie is built up for Matricial Jobs. Heck, Nasa Still uses it.
I am curious about this as well (one of our clients needs the solution we give them as an excel spreadsheet. end of story, end of requirement).
One sheet we give them (and that we use ourselves) has so many fucking macros that it takes like 10 seconds to "ready" itself for a certain input screen. (don't care about discussing code efficiency either right now)
multi-threading might not even help this. I don't know. just curious is all. oh, yeah, and this is in Excel 2003 btw...
(you know... this is off topic, but, excel is one Microsoft program that is fucking bad ass. it truly is.)
One sheet we give them (and that we use ourselves) has so many fucking macros that it takes like 10 seconds to "ready" itself for a certain input screen. (don't care about discussing code efficiency either right now)
multi-threading might not even help this. I don't know. just curious is all. oh, yeah, and this is in Excel 2003 btw...
(you know... this is off topic, but, excel is one Microsoft program that is fucking bad ass. it truly is.)