Excel_Geek...I'll Do That in Excel for $50

Get Your 2010 March Madness Pool Manager Here!

noreply@blogger.com (Excel_Geek) — Mon, 15 Mar 2010 00:10:00 +0000

Alright, folks. It's done. And, as I've been telling you...it's going to be absolutely free this year. Here's how it'll work: the "Master Bracket" file -- the one you use as the pool manager -- still requires you to input and submit a "key code" to unlock the file for use. I've pre-filled this in for you. You'll simply need to click "submit" and accept the terms of use to begin using the file. You'll notice that the file will be open for use until May 1st of this year. (Hey, if I even want to think about ever charging for this again, I can't simply give away all the goods, right?)

The "Standard Bracket" is the file that others in your pool will use to make their picks and track their own progress.

Now, I'm not going to be available to help people with technical difficulties this year (part of the reason I'm giving it away for free this year), so let me tell you the most common reason people have trouble using the file. They don't have macros enabled in Excel. If this happens to you, simply go to Tools --> Macro --> Security... and make sure your security level is set to Medium or Low. I'd recommend Medium, as it will always prompt you to enable macros upon opening a file with macros embedded. Once you've done this, close the file and then reopen the file. You should be prompted to enable macros.

Here are the files:

March Madness Master Bracket by Excel_Geek v.2010a.xls

March Madness Standard Bracket by Excel_Geek v.2010a.xls

Enjoy!

2010 March Madness Pool Spreadsheet Coming Soon

noreply@blogger.com (Excel_Geek) — Mon, 08 Mar 2010 22:26:00 +0000

Yes. I will be doing a March Madness Pool Spreadsheet this year, just like last year's with one exception: this year's will be free! I'll still have some lock-down on the file, though.

It should be ready after all the selections are made this Sunday.

Ideas for the College Bowl Pool Sheet for Next Year

noreply@blogger.com (Excel_Geek) — Sun, 03 Jan 2010 16:23:00 +0000

Well, folks, it's wrapping up again. Thanks for making this my biggest college bowl pool spreadsheet year ever!

Four remaining games in one of our most beloved sports pool events of the year -- college football bowl game season. This is that point in many of our pools where some age-old questions start to emerge...

"Do I really have a shot to win this thing?"

"Do I even have a chance?"

"Who else is in the running?"

"Which games are really most important to my chances?"

I intend to give you the power to answer these questions (and maybe more) in next year's pool sheet. Stay tuned...but in the meantime best of luck in this year's pool! (oh, and get ready for March Madness...)

Alternate Requests for College Bowl Pool Pick 'em Sheets

noreply@blogger.com (Excel_Geek) — Thu, 17 Dec 2009 13:46:00 +0000

I've been getting flooded for requests for all types of variations on my traditional college football bowl pool pick 'em sheet. For those of you familiar with mine, it's a straight up pick the winner (not picking against the line) and you assign points to each pick between 1 and 34 (each number used only once) depending on how confident you are in your pick.

I cannot possibly keep up with each and every variation people want, but I have gotten a number of requests for a simpler version that is more like my NFL Weekly Pool sheet that I did not that long ago. This version is picking a winner straight up (no line) and one point is assigned for each correct pick. The tie-breaker is the total combined score of the championship game. This version I made with 30 possible games (I know there are 34 bowl games, but you can figure out how to add the rest if you want to.) and is set up for up to 100 participants.

Excel_Geek Insiders subscribers will get this file for free as part of their subscription. Not a subscriber? Sign up. It's cheap and easy and you get copies of all the $50 Projects I complete.

I'll probably do another version of two of pool sheets.

Later,

Excel_Geek

2009-10 College Football Bowl Pool Spreadsheet

noreply@blogger.com (Excel_Geek) — Mon, 07 Dec 2009 02:01:00 +0000

Okay folks...it's ready. Well...sort of.

We won't know whether or not it's Army or UCLA vs. Temple in the EagleBank Bowl until Army plays Navy on December 12th. Army has to win that game to become bowl eligible. My money's on Navy, so I'm guessing we'll see UCLA. Whenever we know, you'll have to make that last change for yourself.

Here are the files:

Click here for the corrected main file.

Note: I just found out that I had a problem with this file. It wouldn't let you select the winner of each game in the "WINNER" column. I've since corrected this and this download now works. If you've already got all your data in the file you previously downloaded don't worry, the fix is simple. Go to Tools --> Protection --> Unprotect Sheet... Then select all of the cells where you determine the winner in the "WINNER" column and go to Format --> Cells... --> Protection tab, and uncheck the "Locked" option. Then go back to Tools --> Protection --> Protect Sheet... and click OK without setting a password.

Click here for a simply entry form you can pass around to other to make their picks.

Let me know if you have questions. Also, please pass along any great improvements you make. Remember, last year Jonathan chipped in some nice new features.

Later,

Excel_Geek

Code Crackers Challenge: Round One

noreply@blogger.com (Excel_Geek) — Mon, 19 Oct 2009 16:48:00 +0000

Ok everyone...here's something that I've been wanting to do for some time, but am just finally getting around to: a series on encoding and decoding data.

I've always had an interest in "breaking secret codes" etc. which has led me to creating those secret codes and encryption techniques. Some of you may already know I've done a bit of code-creating. My March Madness bracket spreadsheet is protected using my own code and methodology.

I have a hunch that there's a group of code-cracking geeks out there like me just waiting to be challenged. So here's the challenge:

I'm going to provide an encrypted message.

You may ask questions (use the blog's comment feature so all can see and benefit from the answers).

I'll give answers and hints as I feel appropriate.

The first person to submit via the comment feature the message "Excel_Geek, I have cracked your code." encoded using the same technique I've used wins. (This helps prevent "brute force" type attacks, which tend to give answers without knowing how they were derived.)

What do you win? I dunno...let's see...how about your pick between two free $50 Projects or 2 free hours of Excel consulting/instruction via Skype? Oh, and you'll obviously also be held out as the Code Cracking Champion (if that's meaningful to you).

So here is the Code Crackers Challenge Round One Encoded Message:

R0#4y,4y, y3'44yudiyI'*/46%my)-48&4x

I also feel compelled to give you a first hint, and it's been encrypted using the same technique (which is also kind of a hint in and of itself!):

P$/.s0+2%,. s12 ./s$%s&. 2,.e

So...pass this along to your code-cracking geek friends and family. Ask questions. I'll do the best i can to respond to each question, though not always as directly as you'll probably hope.

Good Luck!

Excel_Geek

Pull numeric value from string

noreply@blogger.com (Excel_Geek) — Thu, 15 Oct 2009 02:43:00 +0000

The other day I had an interesting request for help via my little MeeboMe chat window. James wanted a formula to pull a numeric value from a string contained in another cell. The string was something like this:

"Nylon rope 300Ft"

He had a whole column of this type of data and wanted to pull out the number of feet of each item. The "Ft" would always be immediately after the numeric value desired, and a space would always immediately precede it, but here's the kicker: there could be any number of other spaces before the numeric value and there could also be other number before the numeric value desired.

It took me a bit to get where I needed to be, but here's the logic built into a pretty long, nasty, nested formula:

First get the string that contains everything up to and including the "Ft" using LEFT and FIND.

Count the number of spaces in the string identified in #1 by comparing the length of that string versus that string if all the spaces are replaced with nothing (""), using LEN and SUBSTITUTE.

Replace the last space found in the string identified in #1 with an odd character not likely to be in any of the data (I used a tilde ~) using SUBSTITUTE.

Pull out the numeric value, which is the remainder of the string after the tilde using MID, FIND, and LEN.

I put together a sample spreadsheet of this process both broken out into parts and also all nested together in a single formula.

Excel_Geek Insiders, enjoy!

Later,

Excel_Geek

NFL Weekly Pool Template

noreply@blogger.com (Excel_Geek) — Thu, 24 Sep 2009 18:23:00 +0000

The other day I got a request for a simple template for a weekly NFL office pool. After a few more clarifying questions, here's the scenario:

The requester is the organizer for a weekly NFL football office pool. Each person picks the winner of each of the 16 games each week during the regular season -- no scores, no picking against "the line", etc. -- just a straight up pick, and for each correct pick, that person gets a point. The person who has the most correct picks at the end of the week wins. In the event of a tie, each person also predicts the total combined points scored in the Monday night game. Whomever is closest wins.

I whipped together a quick template that can either be printed and used manually or filled out in Excel as actual results come in, automatically calculated scores and tie-breakers, if necessary. I thought it was decent, so I thought I'd share it -- with everyone, not just Excel_Geek Insiders (though, Insiders, I'll be emailing your copy to you personally, and everyone else has to download it on their own.)

Later,

Excel_Geek

Mail Merge and Named Ranges

noreply@blogger.com (Excel_Geek) — Wed, 16 Sep 2009 15:54:00 +0000

Okay, so today I was helping out a friend over at Husker Diesel who's pulling together a customers/contacts list into Excel. One of his planned uses is for printing mailing/shipping labels. "No problem," i thought. "Let's just crank up a good old-fashioned mail merge in Word.

Turns out it was pretty easy, but i ran across some knowledge along the way i thought I'd share:

For a variety of reasons that are immaterial to the story, the Excel contacts list we were working with wasn't just a simple top-row-contains-headers type of list. There's a form at the top of the page and the column headers started further down the page -- say row 11 or so. Sooo...when i browsed for the Excel file in the mail merge process what it pulled back wasn't very useful -- the form part of the worksheet was included in the contact records since it's at the top. "No problem," i thought. "Let's just create a dynamic named range that will define just the contact records part of the sheet .

Turns out that mail merge doesn't recognize dynamic named ranges. ?! Odd.

I couldn't find a lot out there on this issue, so I ended up just using the work around of created a "hard defined" named range of 10,000 rows of the contacts list, just to be sure there was ample room for all the contacts he'd be adding. Doing this caused me to have to select only non-blank rows during the mail merge process, but it worked just fine.

If anyone out there has encountered this and has a better work around, I'd love to hear it.

Later,

Excel_Geek

Google Analytics Data in Excel

noreply@blogger.com (Excel_Geek) — Fri, 19 Jun 2009 18:08:00 +0000

Have you seen this? Very cool. (Thanks for finding this, Bart.) I haven't dug into it yet, but plan to soon...

Stay tuned.

Chat Support RE: Custom Number Formats

noreply@blogger.com (Excel_Geek) — Wed, 17 Jun 2009 21:21:00 +0000

Here's a short one from today:

[15:39] meeboguest######: hi, Im trying to import 11 digit UPC numbers into my software, but can't find the correct format to keep the digits at 11. All my UPC numbers that start with a 0 are cut off and made 10 digits every time I try to import
[15:39] meeboguest######: I tryed formatting the columns into text and it still shows 10 digits if it start with 0.
[16:15] excel_geek: go to Format --> Cells...
[16:15] excel_geek: from the Number tab select Custom
[16:16] excel_geek: then replace where it says "General" with 11 zeros.
[16:16] excel_geek: tada!

Gotta love customer number formats.

$50 Project - Parse Google Search Results within a Domain for First Result

noreply@blogger.com (Excel_Geek) — Sat, 06 Jun 2009 15:14:00 +0000

I recently completed a $50 Project for a client who wanted a spreadsheet where he could have a list of domains in which to search and a list of search terms and return the URL for the first returned search result from Google while searching withing the specific domain. It took a little modification of some other stuff I've done with parsing Google search pages, but it seems to work nicely.

Excel_Geek Insiders, your file is on it's way.

Later,

Excel_Geek

Chat Support RE: Counting in Pivot Tables

noreply@blogger.com (Excel_Geek) — Tue, 02 Jun 2009 13:06:00 +0000

Here's another one from yesterday:

[15:40] meeboguest######: hi excel_geek - looking for a cont function in a pivot table... can you help?
[15:40] excel_geek: cont?
[15:40] excel_geek: count?
[15:40] meeboguest######: oups.. "count"
[15:42] meeboguest######: have multiple entries by various "agents" and wnat to find how many agents are ther in total... regardless of the entries
[15:42] excel_geek: sure
[15:42] excel_geek: right click in the table detail part
[15:42] excel_geek: and pick field options
[15:42] excel_geek: then select "count"
[15:44] excel_geek: follow?
[15:44] meeboguest######: ok
[15:46] meeboguest######: it gives me the total count of entries, not count of unique individuals... (1 individual = multiple entries)...
[15:47] excel_geek: hmmm
[15:47] excel_geek: maybe i should back up
[15:48] excel_geek: so drag the agents field into the left part of the pivot table
[15:48] excel_geek: then drag any other column into the right (detail) part
[15:48] excel_geek: the right click the field you put in the right part and field settings to "count"
[15:50] meeboguest######: ok... i think i figured it out!
[15:50] meeboguest######: thx a bunch :)
[15:50] excel_geek: np
[15:50] excel_geek: thanks for stopping by
[15:50] meeboguest######: :D

10 Minutes to understanding. Not too bad. Some of that pivot table stuff is unintuitive.

Chat Support RE: =INDIRECT() Function

noreply@blogger.com (Excel_Geek) — Mon, 01 Jun 2009 20:07:00 +0000

More and more I'm helping folks via the MeeboMe chat window I've embedded in the blog. I thought it'd be interesting for you all to see the sorts of conversations I'm having this way:

[14:36] meeboguest######: eric!
[14:36] meeboguest######: do you have a sec?
[14:36] XLgeke: for u?
[14:36] XLgeke: always
[14:36] XLgeke: and now it's over... ;)
[14:36] XLgeke: what's up
[14:36] meeboguest######: excel question
[14:36] meeboguest######: umm
[14:36] meeboguest######: trying to think how to explain
[14:37] XLgeke: reboot
[14:37] XLgeke: that should do it
[14:37] meeboguest######:
[14:37] meeboguest######: ok, I'm wondering if there's a way to dynamically reference a cell in a formula
[14:37] XLgeke: yes
[14:38] meeboguest######: so that if I was to reference cell B
[14:38] XLgeke: right
[14:38] XLgeke: use =INDIRECT()
[14:38] meeboguest######: and that number is a value generated in another cell
[14:38] XLgeke: so like
[14:38] meeboguest######: oooh
[14:38] XLgeke: =INDIRECT("B"&B1")
[14:38] meeboguest######: woah
[14:39] meeboguest######: nice
[14:39] XLgeke: in B1 you'd change the number for BX
[14:39] meeboguest######: right
[14:39] meeboguest######: I'll give that a shot
[14:39] meeboguest######: thanks!
[14:39] XLgeke: np

And that was it...less than 3 minutes and issue solved. This happens scores of times each month.

Finally - Pool Administrator version of March Madness Spreadsheet is up

noreply@blogger.com (Excel_Geek) — Mon, 16 Mar 2009 05:22:00 +0000

UPDATE - 03/27/09 8:52 AM CDT: Another bug found! Ugh! The "master" file was not properly updating the results of last night's games. It's fixed now in this update. (Relatively) good news: it only affected the "master" sheet, so you only have to re-input your picks in the master and retype in the filenames, etc. of the individual sheets in the summary page.

UPDATE - 03/22/09: I found a problem with the files. It's not summarizing the regional semifinals round properly. I've worked out the fix and here are the corrected versions of both the freebie individual file and the "master" file.

It's done. It's late. I've tried to debug as much as I could think to. There's a lot new going on behind the scenes, though, so if you run into trouble, just drop me a note. I'll try to help you out.

Download the file. When you open the "master" file, you'll be given a lock code. Email that to me after you PayPal me $3.00, and I'll get you set up.

Good nite,

Excel_Geek

2009 March Madness Bracket -- Freebie for tracking your own picks

noreply@blogger.com (Excel_Geek) — Mon, 16 Mar 2009 01:10:00 +0000

Okay...so I thought I'd get out this before too late tonight.

Here is the free spreadsheet that anyone can use to track his or her own picks versus actual results in the 2009 NCAA basketball tournament.

What I'm still working on is the companion spreadsheet intended for those of us who coordinate the thousands of March Madness office pools. When it's done I'll simply add it into the zipped directory with this file. It'll cost $3.00 to use. If you like you can PayPal me $3.00 now and I'll put you on the list to get the 2009 version as soon as it's ready.

2009 March Madness NCAA Backetball Bracket

noreply@blogger.com (Excel_Geek) — Wed, 04 Mar 2009 23:02:00 +0000

The inquiries are piling in now...

Yes. I am doing a new bracket spreadsheet for 2009. I'll probably be working on it again tonight for awhile. You can still find the older versions I've done here:

2007
2008

If you do download an older version, though, please don't ask me to make a bunch of feature changes to it. They're old. I'm working on a new one. If you like you can PayPal me $3.00 now and I'll put you on the list to get the 2009 version as soon as it's ready.

What'll be new in the 2009 version? Well, I'm going to put more focus on those "pool administrators" out there. This version will actually have two companion spreadsheets. The first is for the "pool administrator" where he or she can both set up the points system for each round, track his or her own bracket, as well as those of all the people in there pool. The second will be the bracket file for each of the participants. The "pool administrator" file will be the only one locked down and password protected as it was in prior versions. The other spreadsheet will be available for anyone to download and use.

Oh and if you're an Insiders subscriber, as always, you can get the files for free. Just drop me a note.

More to come...stay tuned...

Excel_Geek

Heat Charts for Crime Stats Analysis

noreply@blogger.com (Excel_Geek) — Sun, 11 Jan 2009 22:44:00 +0000

I recently got a request for a $50 Project from Kurt Smith with the San Diego County Sheriff's Department Crime Analysis Unit. (Cool, huh?)

Kurt wanted to apply the heat charting techniques I've posted about before to crime statistics on a Time-of-Day vs. Day-of-Week form. He shot me over some sample data on vehicle thefts. A simple Copy --> Paste Special... --> Values operation later and here's what we've got...

I'm obviously biased, but I think heat charts is a great way to visualize this sort of data, which can tend to get lost in tabular form. In this example, you can easily see the clustering occur just after midnight on the weekends.

The SDSD's apparently got a few Excel geek's on staff, as Kurt tells me that their resident Excel afficianado, Ted, has "...played with it and built some other ranges that approximate standard deviation, 'thirds' and so on from percentiles..." and that they're "...going to begin using it to replace our Excel surface charts for when particular crime types are being reported (we use split times and some aoristic analysis, depending on the crime)..." Whoa...slow down...you're losing me, Kurt.

Kurt also tells me that Lincoln's very own Police Chief Tom Casady is a stats/spreadsheet junky, too. Who knew this? Apparently there's a whole hidden world of Excel geeks: Cops! I'll have to subscribe to Chief Casady's blog.

Excel_Geek Insiders subscribers, I've sent this file out before, but just in case you've lost it, this new version is on it's way.

Later,

Excel_Geek

Bullseye Chart in Excel

noreply@blogger.com (Excel_Geek) — Sun, 28 Dec 2008 23:12:00 +0000

The other day I got a $50 Project request from a guy who was analyzing shooting range results -- that's right, guns and stuff. Cool. Anyway...he couldn't figure out a nice, clean way to visually represent the results in scatter plot fashion. He had even started to mess around with various in-cell charting techniques to pull it off.

I decided that Excel's built-in XY scatter plot graph should be able to do the trick, but it took treating each data point as it's own series (so you can use the "shot number" as the data series name and place it in the data point), adding additional data series to "draw" the bullseye and concentric circles, and some other formatting tricks to pull it off. Here's what it looks like:

All in all, not bad, I'd say.

ExcelGeek.com Insiders subscribers, your file's on it's way.

Dial / Gauge / Speedometer Chart

noreply@blogger.com (Excel_Geek) — Fri, 26 Dec 2008 21:21:00 +0000

Many of you are no doubt aware that this is far from an original concept. Just google "Excel dial chart" or "Excel gauge chart" or "Excel speedometer chart" and you'll see the legions of others before me -- Jon Peltier, Andy Pope, Bill Jelen, to name some major influences on me -- who have done their own versions of this type of chart. Some even have released handy add-ins so that non-power users can easily create these charts for themselves. Nonetheless, I thought it'd be fun to put my own stamp on this type of chart and let my Insiders subscribers play with it. Here's a shot of the chart:

Users will be able to change it's size, scale, start and stop angles, show or hide major and minor gauge marks and add one or two "red zone" regions for the chart, among other features.

Have fun with it.

Later,

Excel_Geek

Reader's Enhancement to 2008-2009 College Football Bowl Spreadsheet

noreply@blogger.com (Excel_Geek) — Sun, 14 Dec 2008 19:38:00 +0000

This is what I love most about the Internet: collaboration with complete strangers.

A couple days ago I got an email from one of my readers, Jonathan Sickinger. Jonathan said that he searched on Google for bowl spreadsheets and found the one I did. (BTW, I saw that I'm the number one hit for a great variety of college bowl pool spreadsheet-related queries...wow!) Jonathan said that after playing around with the spreadsheet for a few days he decided to make some edits and customizations. Great! He made some cosmetic changes to match an entry form that he sends out to his pool participants. I like the look better than what I had done, personally. Next he added space for up to 40 participants (over my 35).

Then Jonathan said that he had an epiphany: In addition to the individual tracking charts, wouldn't it be great if we also had a chart for each bowl? These charts allow participants to see the pick dispersion for each game, giving them a sense of how important that game is to their overall chances. For example, if everyone in the pool weights the same game as one of their most confident picks then the relative importance of that game drops significantly. Follow? Jonathan also threw in some data on each game to show where the bowl ranks in average points wagered and the distribution of who picked which team. Very cool.

I thought it'd be nice to share with everyone this new and improved version and it's accompanying entry form, so here you go:

0809_College_Bowl_Pool_worksheet_Sickinger_mod.xls
0809_College_Bowl_Pool_Sickinger_entry_form.xls

Note: the file's a bit heftier now at >2,500 KB vs. the roughly 1,200 KB it was before, but I think the new features are worth the added weight.

Next up? Jonathan and I are thinking about collaborating on a VBA-based enhancement to make it so that once a pool organizer gets everyone's entry forms back, he or she can simply click a button to pull everyone's picks into the master workbook. That'll be sweet, no?

Later,

Excel_Geek

Pulling Images into Excel from Websites

noreply@blogger.com (Excel_Geek) — Sat, 13 Dec 2008 18:14:00 +0000

You may recall a post I did just over a year ago about pulling images into Excel. That project involved pulling images from directories on your computer. I just completed another $50 Project where the client wanted to pull images into Excel from a website. Really the process was the same, except that this client is using Excel 2007, so I had to head Jonah's advice (see comment on that last project's post) and instead of directly pull the images using

ActiveSheet.Pictures.Insert().Select

I had to first draw an appropriately sized rectangle, move it to the appropriate cell, and "pull the image" by making it the background fill for that rectangle. Maybe someday Microsoft will fix this little idiosyncrasy in Excel 2007, but we'll not hold our breaths.

In the end it's a nice little file. Insiders, your file's on it's way.

Later,

Excel_Geek

The Lawyer's Guide to Microsoft Excel 2007

noreply@blogger.com (Excel_Geek) — Thu, 11 Dec 2008 22:41:00 +0000

I don't know why, but when a lawyer friend of mine sent me this, it struck me as terribly funny.

The Lawyer's Guide to Microsoft® Excel 2007

"Spreadsheet programs are one of the most powerful but underutilized tools in the trial lawyer's toolbox. John Tredennick's concise, clear book shows you how to use spreadsheets powerfully and quickly. I believe that every litigator should be familiar with the contents of this book." -- Joe Kashi, Esq., Author

Maybe it's just this Excel_Geek's frame of mind, but isn't a spreadsheet "...one of the most powerful but underutilized tools..." in almost any profession's toolbox?

No offense to John Tredennick. I'm a fan of anything and everything Excel, but what's next? One of these specialized titles?

The Rancher's Guide to Microsoft® Excel 2007
The Cab Driver's Guide to Microsoft® Excel 2007
The Hitchhiker's Guide to Microsoft® Excel 2007

Too funny.

2008-2009 College Football Bowl Spreadsheet

noreply@blogger.com (Excel_Geek) — Tue, 09 Dec 2008 02:06:00 +0000

Remember that college football bowl pool spreadsheet I did last year (and the year before )?

Well...I guess it's now a holiday season tradition. Here's the same one updated for this season's match-ups. My gift to you.

0809_College_Bowl_Pool_worksheet.xls

This year's has been updated so that you can track up to 35 participants, and I've reformatted the individual charts sheet, so that it prints out nicely.

Merry Christmas,

Excel_Geek

Pulling Company Financial Statements from Yahoo Finance

noreply@blogger.com (Excel_Geek) — Thu, 13 Nov 2008 00:28:00 +0000

Here's an interesting $50 Project I just completed. The request was for a spreadsheet that would allow the user to enter a stock ticker symbol, and it would go out to the Yahoo Finance website and pull back either the quarterly or annual versions of the income statement, balance sheet, or statement of cash flows for the company. I think I've accomplished that pretty well.

I even did some formatting to make them look similar to those on Yahoo Finance. Here's what the Yahoo Finance version of the Cash Flow statement looks like...

(click on the image above to see a larger version)

And here's the Excel version ...

(click on the image above to see a larger version)

I even did a little "...gathering data...one moment please..." status message while the query is running.

(click on the image above to see a larger version)

This is another example of a web query project that I did where instead of using the CreateObject("MSXML2.ServerXMLHTTP") method, I actually initiate an Internet Explorer session behind the scenes using the CreateObject("InternetExplorer.Application") method. Using this method was preferable for this project, as I was able to identify the table containing the financial statements and pulled the "inner HTML" from it rather than having to use Regular Expressions to tease out each data point.

I thought it was interesting, but being the Excel_Geek, I probably would.

Excel_Geek Insiders subscribers, your file is on its way!

Later,

Excel_Geek