CDP Phase II

Date of Release/
Update

Screen Shot(s)
(click image to enlarge)

Version

Purpose/Uses

1/27/2003
Subj: Template Version v1.4

1.4

Generic layout of all data points, unfiltered. A good place to browse, brainstorm and start to understand the pivot structure.

1/15/2003
Subj: Custom Groups

CustomGroupDemo.xls CDPBasicv1.3.dqy*

New

	Demonstrates the “Group and Outline/Show Detail” function.
	Useful for choosing a few data points or organizations for targeted analysis.

1/13/2003
Subj: Template Version v1.2

AssetGroups.xls
CDPBasic1.2.dqy*

New

Demonstrate use of “Assets In Millions” field

1/12/03
Subj: Percent Distribution Pivot Table

PercentDistrib.xls
PercentDistrib.dqy

New

	Shows distribution of "%" Responses Counts (All responses >= 0, >= 25%, >= 50%, >= 75% )
	Filter "Not Zero" is applied Note: Only Two sections have "%" Responses: Output and Capital (Weighted Costs). The second worksheet is filtered on the Outputs Section in the Page area, and shows the distribution of target markets for each year.

1/10/03
Subj: Pivots

ActivityPerState.xls
StateWithActivity.dqy

New (1.0)

Sums TOTAL CDFI ACTIVITY under each state that the CDFI listed as “served”. Demonstrates layout; does not reflect funds actually provided to any state.

1/10/03
Subj: Pivots

AltText.xls
AltText.oqy
AltText.cub

New

	Alternate text analysis.
	Demonstrates xls connected to offline cube (small, fast but limited).

1/10/03
Subj: Pivots

AltTextOWC2000.htm
AltText.cub

New

	Alternate text analysis.
	Demonstrates Office 2000 Web Components connected to cube file. OWC pivot has fuller functionality than Excel pivot.

1/10/03

Subj: Pivots

AltTextOWC2002.htm
AltText.cub

New

	Alternate text analysis.
	Demonstrates Office 2002 Web Components connected to cube file. OWC pivot has fuller functionality than Excel pivot..

1/10/03
Subj: Pivots

AverageSize.xls
BasicCDPv1.1.dqy*

1.0

Demonstrates pivot table calculated field “Avg Size” = $/#.

1/10/03
Subj: Pivots

CapitalBreakouts.xls
BasicCDPv1.1.dqy*

1.0

Demonstrates a “cross-tab” type report with Breakouts in row area and Items in columns.

1/10/03
Subj: Pivots

Directory.xls
CDPDirectory.dqy

1.0

CDFI Contact information. Answers 'per survey' questions like “how many surveys are from Banks?” and “How many surveys are Public Data based?”

1/10/03
Subj: Pivots

LoanSoftware.xls
LnSvyInfo.dqy

Original (email release)

	Selected fields from “flat tables” (886 rows) around Loan Software analysis.
	Demonstrates need for "translating" the various text answers for "Hardest Section" and Loan Software into common groupings for analysis.

1/10/03
Subj: Pivots

PivotReports.xls
BasicCDPv1.1.dqy*

1.0

	“Sampler” of customized pivot templates.
	'Flags' sheet gives details of flagged data. Office 2002 users can pull in the "Results" pivot field for more details
	'Sample Size' sheet tells total response counts for every field, how many years the question has appeared (Yrs), and the Scope: CDP, Local or Calc.

1/9/03 Subj: Flat File Update”

FlatTables.xls
(Based on 13 .dqy files that will be provided upon request)

1.1

	13 sheets of 886-row (one for each survey) tables with data points in columns (non-local).
	Used as a vehicle to export data to other databases such as SPSS

12/20/02 CD-ROM

Text.xls
Text.dqy

Original

	All text fields from “flat tables” (886 rows).
	Good for browsing survey comments.

Zip File	Extract To	Contents
CDPII.zip	C:\CDPII	*MS Word Documents (.doc)**
Queries.zip	C:\CDPII\Queries	*MS Query files (.dqy, .oqy, .cub)**
ReportSamples.zip	C:\CDPII\ReportSamples	*MS Excel and Office Web Component files (.xls and .htm)*

	Excel Pivot tables are filled from a truncated, public database and must be synchronized with local data.
	View, Toolbars, External Data. Click the "Refresh All" icon