Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jay Jay is offline
external usenet poster
 
Posts: 671
Default Macro Optimization - 25,000+ Rows

Hi Spy128Bit -

Great to hear about your results. Attacking a problem with different
approaches may be a bit redundant, but the payoff is that we get to learn
something about how specific techniques contribute to performance.

On the subject of performance, I'm now curious about the difference in
performance between our PC's. I'd be very interested in testing the same
data on both. I'm guessing that our data values are extremely different, but
at the same time, the procedure as constructed should be somewhat immune to
that. It would be valuable to understand this by running a side-by-side
comparison.

If you'd feel comfortable emailing a data worksheet along with the
processing time, I'd be grateful. It could be dummied-up if you have
sensitive data. Alternatively, I could email mine. It's up to you if you
want to do this and I understand if you don't; no explanation necessary. My
adrs is jc .sresearch a t hotmail_com (modify to look like a standard email
address).

One additional note. Credit to sali for the overlap function. It distilled
the overlap calculations down to a few short lines which were easily
incorporated into the procedure.

----
Jay
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting Se0 Guy Excel Worksheet Functions 0 March 8th 07 04:08 AM
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting Se0 Guy Excel Discussion (Misc queries) 0 March 8th 07 04:08 AM
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting Se0 Guy Setting up and Configuration of Excel 0 March 8th 07 04:08 AM
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting Se0 Guy Links and Linking in Excel 0 March 8th 07 04:08 AM
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting Se0 Guy Charts and Charting in Excel 0 March 8th 07 04:08 AM


All times are GMT +1. The time now is 08:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"