Where to get consultation for my huge excel model?

[trvrt30]

Hi all,

I have found this board extremely helpful for individual problem solving. With all the knowledge here, I also thought it might be helpful for recommending professional excel/access experts.

For the last year I've been building/using a somewhat complex and dynamic test analysis program in Excel (Mac 2010) for my SAT tutoring business in NYC. Basically, I have encoded all of the existing SAT tests into excel so that I can receive students' test results and automatically produce score reports, recommendations, and charts personalized to each student.

I don't know any VBA so I've been doing this entirely with formulas. Furthermore, I don't know how to structure all this in a way to preserve working memory (I'm just doing what I need to do to make it functional as I go). So you can imagine how painfully slow this thing gets as it gets bigger and bigger.

And as my business has grown, so has the demand for these reports. It is past time for me to optimize this thing both in terms of limiting the number of steps required for report creation/printing and increasing speed of calculation. (For example, it takes at least 5 minutes to refresh certain pivot tables or copy/paste certain data; and a good 10 minutes simply to save my file; worst of all, I'd say about 15% of the time I take these actions, excel just crashes).

I'd really like to find someone with VBA knowledge and perhaps an understanding of how to link Excel and Access (since I'm starting manage so much data in Excel, I think Access makes more sense) who could help me optimize this model. If you have any ideas of specific people or places to look into, or how much I can expect to pay for this sort of thing, that would be very much appreciated.

Thanks,
Tim

 

[Jonmo1]

Welcome to the board..

Try the "Consulting Services" link at the MrExcel home page
Excel Consultant | Excel Consulting | Microsoft Office Consultants

 

[trvrt30]

Yeah, I tried sending them a message but haven't heard back. So just checking to see if there were any other options. Have you heard whether people are pleased with their services?

Welcome to the board..

Try the "Consulting Services" link at the MrExcel home page
Excel Consultant | Excel Consulting | Microsoft Office Consultants

 

[trvrt30]

Actually, I figured out the reason I haven't heard back from them. Just checked my email, and here's the message I got back from them:

"Your message to <consult@mrexcel.com> was automatically rejected:
Quota exceeded (mailbox for user is full)"

You don't happen to know any other ways I could get ahold of them, do you? Thanks again.

Yeah, I tried sending them a message but haven't heard back. So just checking to see if there were any other options. Have you heard whether people are pleased with their services?