Our IT firm is horrendous and has been really unhelpful here. Some are going to tell me I should use Tableau or something else for these files and I would ask those people to, respectfully, please press the back button on your browser now.įor Excel in particular, are there any limits to how much it can take advantage of clock speed, cores, or i7/I9/Xeon?ĭoes anyone have ideas on the best path to take to not have CPU be a bottleneck? What computer should we be buying? We’d probably pay up to $4k per machine if necessary. Because of the nature of our work, we are willing to pay for something that will be lag free for everything we do because it will directly pay for itself many times over. There would be a major financial return on investing in high powered desktops or laptops for our organization and I have convinced the firm of the need. I’m running a dual core i7 with 2.7ghz or so and 16 gb of ram - so lots of room for improvement to say the least.Įven when not working with these very large and complex files, my CPU reaches 100% utilization literally every single day and causes significant efficiency to my workflows. As a result, my company-issued laptop which we use as a desktop replacement, a Lenovo ThinkPad X1 Carbon, either can’t do these tasks or it can take several days to do a task that could have taken 20 minutes if it weren’t for the lag. At the extreme, this can be as much as 20 million data points, with millions of rows of volatile formulas such as indirect functions, index match, etc running off of this data, interconnected across dozens of tabs. I work at an investing firm and we often receive significant amounts of data on companies that we need to crunch in excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |