https://s3-us-west-1.amazonaws.com/ayx.community.assets/data-download-pub78.txt
URL
String
65001
GET
Compose
2
600
DownloadData
Skip
2
Skip 1st 2
DownloadData
Last
DownloadData
C:\Users\osv9382\Downloads\17eofinextractdoc.xls|||`990$`
False
False
17eofinextractdoc.xls
Table=`990$`
C:\Users\osv9382\Downloads\17eofinextract990.dat
28591
\s
False
254
False
True
DoubleQuotes
1
17eofinextract990.dat
RightInputRows
Warn
Mapped
Element Name
Description
Skip
1
Skip 1st 1
FirstRow
Warn
[State] = "CO"
Simple
=
State
True
fixed
2018-12-19 14:19:36
0
2018-12-19 14:19:36
2018-12-19 14:19:36
CO
[State] = "CO"
C:\Users\osv9382\AppData\Local\Temp\Engine_9224_21763043a98942c295d2945ddf13687f_\Engine_17948_15120382b8bf452694c548a04178621f_.yxdb
Single
Profile
[Grants to individuals?] = "Y"
AND
[Fundraising activities?] ='Y'
AND
[Deductible non-cash contributions?] = 'Y'
AND
[Number of employees]<300
AND
[Advertising and promotion]<1000
AND
[Total contributions]>5000000
Custom
=
Grants to individuals?
True
fixed
2018-12-19 14:22:07
0
Y
2018-12-19 14:22:07
2018-12-19 14:22:07
[Grants to individuals?] = "Y"
AND
[Fundraising activities?] ='Y'
AND
[Deductibl...
Average Fundraising Efficiency* = Average Fundraising Expenses* ÷ Average Total Contributions*
(When Calculating Using Form 990) = Average of Part IX line 25D* ÷ Average of Part VIII line 1h*
Fundraising Efficiency - Descending
Horizontal
challenge_145_start_file Santalytics I