June Stats
The Spreadsheet Page
Pointy Haired Dilbert
Archive for the ‘General’ Category.
Interrupting Calculations
Normally, Excel calculates your workbooks so fast you don’t notice. Sometimes, however, your workbook is so big that it takes Excel some time to calculate it. I’m guessing readers of this blog run into that situation more than the average Joe. While Excel is calculating, the status bar displays its progress. [...]
Quick PivotTables
Sometime in the mid-1990s, a man named Lyle Lanley walked into Microsoft with an idea. Probably the greatest.... Oh, it's more of an Apple idea. "Just tell us the idea and we'll implement it", said Bill Gates.
I'm on a quest to rid my life of wizards. The wizards that Microsoft seems [...]
Animate a greeting with Excel and VBA
Inspired by Dick's XL birthday, the upcoming birthday of my fiancee, and tinkering with iphone app development, I thought of an animated greeting in the form of a stadium wave (known to some as an audience wave)...
See http://www.tushar-mehta.com/publish_train/xl_vba_cases/greeting_wave.html
XL
If I were Roman, that's how old I would be today.
Today I will be spending my birthday processing inventory transactions and answering the phone - great fun. Tomorrow, however, we're having a little shindig in my honor with family, friends, and beer.
Euler Problem 83
Euler Problem 83 asks:
NOTE: This problem is a significantly more challenging version of Problem 81.
In the 5 by 5 matrix below, the minimal path sum from the top left to the bottom right, by moving left, right, up, and down, is indicated in red and is equal to 2297.
131 673 234 103 18
201 96 [...]
Euler Problem 81
Euler Problem 81 asks:
In the 5 by 5 matrix below, the minimal path Min from the top left to the bottom right,
by only moving to the right and down, is indicated in red and is equal to 2427.
131 673 234 103 18
201 96 [...]
Look Up
The last control on the right click menu is Look Up. That opens the Research task pane.
I'd be interested to know if anyone actually uses this. I accidentally click on it several times a week, but I don't actually use it. Anyone?
