Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multi threaded calculation (multi CPU) - impact on calculation spe
I'm using huge calculation sheets for specific Engineering applications where
the iteration calculation are very low (<5.000 iteration per hour). I have a labotp with 2 CPU, and Excel 2007 (where you can define wether you use 1 or 2 CPU for the calculation. Whatever the nr CPU is (1 or 2), the Excel calculation speed remains unchanged. I were thinking to reach higher speed with 2 CPU instead of 1 CPU. Does somebody has the same experience or idea to be abble to use more then 1 CPU? I'm thinking to buy a computer with 8 CPU for other time consuming applications (not Excel), will Excell be improved by this extra nr of CPU? -- Pascal |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multi threaded calculation (multi CPU) - impact on calculation spe
Hi Pascal,
If you are using circular references and Excel's iterative calculation methods then Excel 2007 does not use multithreaded calculation on the cells in being calculated in the circular chains. If you are not using circular references but controlling the iteration through VBA then the VBA part of the process will not use multithreaded calculation but any Excel calculation initiated from VBA will use multithreaded calculation ( except for Range.Calculate and Range.CalculateRowMajorOrder) . If you are using Excel's iterative calculation method then make sure all the cells in the circular chains are on a single worksheet and that you have minimised the number of calculations and cell references Excel has to perform in each iteration. Charles __________________________________________________ The Excel Calculation Site http://www.decisionmodels.com "Pascal" wrote in message ... I'm using huge calculation sheets for specific Engineering applications where the iteration calculation are very low (<5.000 iteration per hour). I have a labotp with 2 CPU, and Excel 2007 (where you can define wether you use 1 or 2 CPU for the calculation. Whatever the nr CPU is (1 or 2), the Excel calculation speed remains unchanged. I were thinking to reach higher speed with 2 CPU instead of 1 CPU. Does somebody has the same experience or idea to be abble to use more then 1 CPU? I'm thinking to buy a computer with 8 CPU for other time consuming applications (not Excel), will Excell be improved by this extra nr of CPU? -- Pascal |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multi tiered percentage rent calculation | Excel Worksheet Functions | |||
Complex Multi-condition, multi-workbook count | Excel Discussion (Misc queries) | |||
match in multi-column and multi-row array | Excel Discussion (Misc queries) | |||
how can I paste multi-line/multi-paragraph data into ONE cell? | Excel Discussion (Misc queries) |