- Need a PC for some hydrologic modeling work involving huge excel sheets and GIS along with Google Earth Pro (Sometimes running all three together with Chrome tabs)
- With my current laptop, with 8th Gen i7 8650U with 8GB RAMthe excel sheets can be only 10000x10000 with cross-referenced formulas which take a minute to save only ta a SATA SSD.
- If I use "Excel solver" for optimization, it takes about 30 minutes to arrive at a solution, sometime more. I would like to be able to work with 100,000 X 100,000 sheets if possible at all.
- I should have chosen Python or R, but now there is no time to learn those and Excel lets me view graphs instantaneously after every value change which I am not sure is possible in the others..
- I would prefer a system without a dGPU for now as QGIS (No 3D rendering) and Google Earth should be handled fine with the APU.
CPU: | Ryzen 5700G | (As I probably don't need a dGPU) | (26000INR / $330) |
MoBo | MSI MAG B550M Mortar WiFi AMD motherboard | Reasonable price with Wifi so that I can use both M.2 drives | 16900INR / $215 |
RAM | XPG DDR4 D50 RGB 16GB (2x8GB) 3200MHz PC4-25600 CL16 | single dimms of 8GB are available for less. So does it matter if I buy two of those of a pair of these? | 6690 INR / $85 |
BOOT Drive: | WD Blue SN570 NVMe 1TB SSD, Upto 3,500 MB/s | Need to work on large excel files, sometimes more than 800MB | 8600 INR / $109 |
Storage: | Kingston NV1 2TB M.2 2280 NVMe PCIe Internal SSD Up to 2100 MB/s | Need to save a lot of files | 15300 INR / $194 |
PSU: | GIGABYTE GP-P650B 650W Power supply | (Leaving Room for a future upgrade with a DGPU) | 4499 INR / $57 |
Total | 77600 INR / $982 |
Don't want to Exceed the budget by more than 10% of what it is now
So my primary questions are,
- Will the CPU and RAM be enough for comfortable work? I don't need lightning-fast response but the PC should not hang when I am running solver
- If there is a room for improvement, should I upgrade the CPU or increase RAM to 32GB.
- single dimms of 8GB are available for less. So does it matter if I buy two of those instead of a single set of 2X8GB ram sold as a pair?
- Any other suggestion.
From India
Last edited: