News-Record.com

The North Carolina Piedmont Triad's top go-to source for News
A service of the News & Record, Greensboro, North Carolina

Home

The Inside Scoop

« Perkins-Souther audio uploaded | Main | Billy Yow for Grand Poo-Bah »

Do you dig county budgets? Pivot tables?

We have a copy of the 2008-09 Guilford County budget, line item by line item, in this handy dandy Excel file. (Warning: it's a big file and may take a bit to download.)

For county geeks, it's kind of like the Rosetta Stone that explains what money goes where.

But first, you have to know a little bit about how to navigate pivot tables in Excel. When Michael Halford, the county's budget director gave a little walk-thru to Scoop on navigating the budget, he said pivot tables were "like a cube that you can turn around and look at in different ways."

It's also a handy tool for ranking your selections for your fantasy football draft, if you're into that.

As for using them, here's a primer on pivot tables.

But if you just want to see where the government spent more money in 2008-09, you can open the file, click on "Base/Expansion", drag it down to the right of the "Dept" column. On the "Base/Expansion" column, click on the little arrow that points down, and check Expansion. Then grab "Division/AU" from above and drag that to the right of "Base/Expansion". It should look like this:

pivot%20table%20screen%20shot.JPG

Dragging and so on, you can slice it any number of ways. Have fun.

Comments (2)

To report abuse of the comment feature on this site, please use the feedback form at the bottom of any page.

Roch101 said:

"It's also a handy tool for ranking your selections for your fantasy football draft, if you're into that."

And if one is, are there such tables out there already populated with stats from last year or projections for this season?

Gerald Witt said:

I don't think there is, at least not that I know of.

Due to recent automated spamming attacks on our blogs, we are temporarily requiring commenters to authenticate themselves via TypeKey® before posting comments to any News & Record blog in order to prevent denials of service. We sincerely apologize for the inconvenience.

Post a comment

Users who post comments to this blog tacitly agree to observe the News & Record Online Service Terms of Use and Content Submission Agreement. Comments which do not adhere to the terms of this agreement may be removed and the submitter may be banned from further participation. Please use the feedback form at the bottom of any page to report abuse of this feature.

Explore This Blog

Contact Scoop

ADVERTISEMENT
ADVERTISEMENT

Search

Search

Channels
Font Size
Tools
Question, Comment or Suggestion? Please contact us.

News & Record and NRinteractive

200 E. Market Street, Greensboro, NC 27401 (336) 373-7000 (800) 553-6880
1813 N. Main Street, High Point, NC 27262 (336) 883-4422
203 E. Harris Place, Eden, NC 27288 (336) 627-1781
4213 S. Church Street, Burlington, NC 27215 (336) 449-7064

Copyright (C) 2008 News & Record and Landmark Communications, Inc.