Skip to main content
4 votes

Python using generators with Excelwriter - Performance

This submission is about performance, yet it does not contain a single timing measurement. unsure how long this should really take. We expect that processing e.g. six 1 MiB workbooks should take ...
J_H's user avatar
  • 29.1k
4 votes

Which is faster: Unhide rows during IF or Unhiding them all at once in another macro?

The answer is neither ;) What you want is something along the lines of ...
Greedo's user avatar
  • 2,395
3 votes

Snake in Excel in... VBA?

Under DrawGameBoard, when you set your game range to be Set gameRange = .Range("B2:AD31") Shouldn't it be to cell AE31? Otherwise resetting the board won'...
Jaden A. Taylor's user avatar
3 votes
Accepted

an algorithm that chooses the best games on steam

First you should split your main method into several shorter ones to clearly identify the steps of your algorithm. By naming them correctly your code will be easier to understand and to maintain. ...
fluminis's user avatar
  • 196
3 votes

an algorithm that chooses the best games on steam

Structure your code properly (Single responsibility principle) Don't pile all the logic into one method (like it can be observed in the main). Dissect it into ...
Alexander Ivanchenko's user avatar
2 votes

an algorithm that chooses the best games on steam

appropriate datastructure ...
J_H's user avatar
  • 29.1k
2 votes

Efficiently creating an array from a filtered sheet

The code in the Addendum from Tinman isn't functional. I would use the Addendum code, but instead of referencing the RelativeRowIndex, go by the ...
M4dsc1's user avatar
  • 21
2 votes
Accepted

Python script to read an XML file and write some information to an Excel file

Consider following tips: Class: Encapsulate your related def methods for parsing XML and preparing Excel within a Class object ...
Parfait's user avatar
  • 960
2 votes

an algorithm that chooses the best games on steam

String name = game[1]; String price = game[7]; String positive = game[23]; String negative = game[24]; A better practice (I don't know if there is an even better ...
Coral Kashri's user avatar
2 votes

One way Synchronize 2 Access Tables with VBA ADODB

Using nested while loops can easily turn into a time-sink. Rather, save the missing checkGUID values to an array using SQL, and only loop once to save time (and debugging headaches): ...
Erin B's user avatar
  • 21
2 votes

Using Pandas to group data based on name and see if column value is greater than or equal to values based on group names

You'll need to rethink your required experience criteria as a merge between a criteria table and a hotel records table. For your existing data, the easiest way to do this is a priority substring match....
Reinderien's user avatar
  • 62.4k
1 vote

Need assistance modifying a "too large" procedure

This may not be the appropriate site for this question -- the coding path you've been going down thus far calls into question whether advice or documentation would change your practice. I will tackle ...
J_H's user avatar
  • 29.1k
1 vote

double click on userform running slow excel vba

Here are some suggestions to optimize your code: Avoid Selecting Ranges: Instead of selecting ranges and then working with them, directly reference the ranges and cells. This helps to avoid the ...
Vipul Karkar's user avatar
1 vote

Optimize a Python code which indicates duplicated values in an excel file

As @suchislife already mentioned you can use duplicated method ...
Pavel Nekrasov's user avatar
1 vote

Efficiently creating an array from a filtered sheet

Inspired by M4dsc1's use of the phrase "helper column", I've come up with another approach - on the assumption that you can indeed add a helper column. The helper column (assuming we're on ...
Andi Allan's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible