-
$150 per hour. $120 per hour if the project is big enough that you won’t have to look for work for a while. $100 per hour if you’re really hungry.
I’m sick of reading blog posts about how much to charge. They don’t tell me anything I don’t already know. And they [...] Read...
-
I’ve been following Dick’s VBHelpers Build series (1, 2, 3) and his last post reminded me that, from time to time, I need to sort a collection of items in-memory.
I don’t have to sort all that often, so my approach has changed over time. I’ve kind of settled on the following....
-
Part of my part-time job schedules world-wide PC-chat conferences weekly, and I announce the time referenced to the East Coast. As daylight savings time is about to end, I wanted an algorithm that knew whether standard time or daylight savings time was in effect.
As I’m not worried about the 2...
-
Hi all
FYI
A few weeks back I start working on my first Mac, and I must say I love the OS but there is a lot of work to do in Office for the Mac.
My idea is to go through all my webpages and see if I can make the VBA code also working in Excel [...] Read More...
-
There’s an Excel Power Analyst Bootcamp in our nation’s capital next month. Well not our nation’s capital, but mine. OK, it’s Washington DC. More like Alexandria, VA. Or it might be Springfield, VA. Just ask the cabbie to take you to the Sheraton in old town Alexandria. He’ll...
-
I came across a very reasonable request from someone who wanted to see which entries in a list matched those in the current cell (http://answers.microsoft.com/en-us/office/forum/office_2010-excel/event/49aa9987-3cf5-4007-9f08-df076ff0beba). While the original request dealt with names, I abstracted the...
-
This was inspired by Dick Kusleika’s post Masking Passwords (http://www.dailydoseofexcel.com/archives/2011/07/12/masking-passwords/). It’s an enhanced version of DK’s approach in the sense that the same userform module supports both entering a new password as well as entering a password for confirmation...
-
Hi all
FYI, I add this page last weekend to my site :
Enable or Disable custom Ribbon buttons in Excel 2007-2010
http://www.rondebruin.nl/enable.htm
I also have a page for hiding and displaying :
Hide or Display Custom Ribbon Tab/Group/Control with getVisible
http://www.rondebruin.nl/hidevisible.htm...
-
Specifically, MacPaint files. Why MacPaint? 1. With a maximum size of 576 pixels wide by 720 pixels tall, MacPaint images fit on a modern spreadsheet when using cells as pixels, and 2. MacPaint prototyped the lossless PackBits compression algorithm, which is the default compression scheme for TIFF.
PackBits...
-
A few years ago I remapped my Caps Lock key and I’ve never been happier. Until now. Do you ever try to do a quick calculation in Excel and forget the equal sign? Do you ever start typing a number and end up in a different cell? If these have happened [...] Read More...
-
Amazon seller lists book at $23,698,655.93 — plus shipping
http://www.cnn.com/2011/TECH/web/04/25/amazon.price.algorithm/index.html?iref=NS1
which references
Amazon’s $23,698,655.93 book about flies
http://www.michaeleisen.org/blog/?p=358
– Tushar Mehta Read More...
-
It’s time once again for the Excel and Access Power Users Workshop put on by Data Pig Technologies and DDoE. It’s in Chicago this year on May 18th-19th.
Here’s what you’ll learn: Move Data between Excel and Access
Leverage advanced MSQuery and SQL Techniques to Enhance Reporting...
-
Hi all
There is a common problem when you are working with the Ribbon with RibbonX and VBA.
The ribbon object (which is initialized when Excel loads your file) can loose its reference
to the ribbon, which means your code can no longer tell Excel to update your ribbon customizations.
There is simply no...
-
Those who have used an Excel 2010 slicer may have wanted to see that capability in earlier versions of Excel. I like what Microsoft did with slicers in 2010 and wanted to extend that capability backwards. For those who haven’t used a slicer, it is a filter on a particular pivot field shown [.....
-
Charles asks about credit card processors for accepting payments from clients. Like me, he uses Paypal, but would like to explore some other options. If you’re a freelancer or otherwise accept credit cards, who do you use? I’m not sure what the criteria should be, but here’s my list...