M
Michael VBS
Guest
Hi there,
I work with really big spreadsheets, and have for many years. I am very versed in large excel data sets with many nested routines etc. one sheet I have now takes 8 minutes to open at little over a 1GB file. And I do have a UFO for a workstation.
Lately I've been thinking that maybe I can just do this through a visual studio project, as I could just write the same thing in VBSTUDIO and get the same results. While excel provides a convenient UI- I really only need quick iterative results.
So wondering if I cut out the excel operations that lend time to the whole of the progam program - and just input/output the raw data in its most basic form by recreating the monster array in a VB Studio project. Would this drastically cut down operating times? I have the 7980Xe with 18 cores and 36 threads and it does well enough- but I think there maybe a better way of processing the problem.
Does anyone know how a nested If And Else statements execution in Visual Studio compares to a Nested If statement in Excel?
Does any one know the fractional rate of either statement against the CPU's Clock Cycle? Am I looking at this right and asking the right question?
Also if I went totally bonkers, could the same be accomplished in Assembly Language for even a faster advantage?
Thank you for your help!
Continue reading...
I work with really big spreadsheets, and have for many years. I am very versed in large excel data sets with many nested routines etc. one sheet I have now takes 8 minutes to open at little over a 1GB file. And I do have a UFO for a workstation.
Lately I've been thinking that maybe I can just do this through a visual studio project, as I could just write the same thing in VBSTUDIO and get the same results. While excel provides a convenient UI- I really only need quick iterative results.
So wondering if I cut out the excel operations that lend time to the whole of the progam program - and just input/output the raw data in its most basic form by recreating the monster array in a VB Studio project. Would this drastically cut down operating times? I have the 7980Xe with 18 cores and 36 threads and it does well enough- but I think there maybe a better way of processing the problem.
Does anyone know how a nested If And Else statements execution in Visual Studio compares to a Nested If statement in Excel?
Does any one know the fractional rate of either statement against the CPU's Clock Cycle? Am I looking at this right and asking the right question?
Also if I went totally bonkers, could the same be accomplished in Assembly Language for even a faster advantage?
Thank you for your help!
Continue reading...