Hi, I'm building sales models in excel for a wholesaler with lots of distribution. My models reach 100MB+ quickly and are taking a long time to calculate (lots of VLOOKUPs for example).

I'm buying a machine to handle this, and money is basically not an issue. What is the fastest processor/computer configuration I should get? These are some example options:
- Dual Core Xeon
- Two Dual Core Xeon
- Regular Xeon
- Pentium processor.

My question is simple, what is the fastest? Does RAM matter? I'd also love any optimal configurations (processor/bus/ram) you can suggest.

THANKS!