{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Period Ending MMDDYY","Lookup"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Period Ending MMDDYY","index":0,"n_rows":58,"n_cols":8,"rows_kept":58,"cut":false,"hidden":false,"merged":[[57,4,57,5],[55,4,55,5],[47,1,47,2],[30,1,30,2],[38,1,38,2],[45,1,45,2],[49,0,49,2],[0,0,0,5],[15,0,15,5],[6,0,6,5],[1,1,1,2],[1,4,1,5],[3,4,3,5],[7,2,7,3]]}
["ONESTAR USE ONLY"]
[" PER APPROVED BY:"," GO Initials & Date: ",null," Director Initials & Date: ","   FINAL PER:    Yes   /    No"]
[" OneStar Prime Grant:",{"$f":"VLOOKUP($C$8,Lookup!$A$4:$N$103,13,FALSE)","v":"(blank)"},null,{"$f":"\"Program Code:   \"&VLOOKUP($C$8,Lookup!$A$4:$L$103,2,FALSE)","v":"Program Code:   (blank)"}," Fund Code:",{"$f":"+IF($C$11=\"2012-2013\",LOOKUP($C$8,Lookup!$A$4:$A$105,Lookup!$F$34:'Lookup'!$F$105),IF($C$11=\"2013-2014\",LOOKUP($C$8,Lookup!$A$4:$A$105,Lookup!$H$4:$H$105),IF($C$11=\"2014-2015\",LOOKUP($C$8,Lookup!$A$4:$A$105,Lookup!$J$4:$J$105),IF($C$11=\"2015-2016\",VLOOKUP($C$8,Lookup!A4:L105,12),IF($C$11=\"2016-2017\",VLOOKUP($C$8,Lookup!A4:N105,14,FALSE),FALSE)))))","v":"(blank)"}]
[null,null,null,"PER #",{"$f":"\"PER\"&RIGHT(D3,3)&MONTH(E14)&DAY(E14)&RIGHT((YEAR(E14)),2)","v":"PERnk)83116"}]
[]
["AmeriCorps Periodic Expense Report (PER)"]
["The information in this section is REQUIRED for each periodic expense report (PER)."]
["Legal Applicant Name",null,"(blank)",null,null,null,null,"."]
["Program Name"]
[]
["Grant Year",null,"2016-2017","Grant Type","AmeriCorps Grant"]
[]
["PER For the Period Covering"]
[null,"Start Date","2016-08-01","End Date","2016-08-31"]
[]
["INSTRUCTIONS: Enter information below in areas highlighted in YELLOW as applicable for the current period."]
["SECTION I.","PROGRAM OPERATING COSTS",null,"CNCS SHARE CURRENT EXPENSE","GRANTEE SHARE CURRENT EXPENSE","TOTAL CURRENT EXPENSE \n(auto-calculates)"]
["A.","Personnel Expenses",null,null,null,{"$f":"SUM(D18:E18)","v":0}]
["B.","Personnel Fringe Benefits",null,null,null,{"$f":"SUM(D19:E19)","v":0}]
["C.","Travel"]
[null,"Staff Travel",null,null,null,0]
[null,"Member Travel",null,null,null,0]
["D.","Equipment",null,null,null,0]
["E.","Supplies",null,null,null,0]
["F.","Contractual and Consultant Services",null,null,null,0]
["G.","Training"]
[null,"Staff Training",null,null,null,0]
[null,"Member Training",null,null,null,0]
["H.","Evaluation",null,null,null,0]
["I.","Other Program Operating Costs",null,null,null,0]
[null,"SECTION I TOTAL",null,{"$f":"SUM(D18:D30)","v":0},{"$f":"SUM(E18:E30)","v":0},{"$f":"SUM(F18:F30)","v":0}]
[]
["SECTION II.","MEMBER COSTS",null,"CNCS SHARE CURRENT EXPENSE","GRANTEE SHARE CURRENT EXPENSE","TOTAL CURRENT EXPENSE \n(auto-calculates)"]
["A.","Living Allowance",null,null,null,{"$f":"SUM(D34:E34)","v":0}]
["B.","Member Support Costs",null,null,null,{"$f":"SUM(D35:E35)","v":0}]
[null,"FICA",null,null,null,{"$f":"SUM(D36:E36)","v":0}]
[null,"Worker's Compensation",null,null,null,{"$f":"SUM(D37:E37)","v":0}]
[null,"Health Care",null,null,null,{"$f":"SUM(D38:E38)","v":0}]
[null,"SECTION II TOTAL",null,{"$f":"SUM(D34:D38)","v":0},{"$f":"SUM(E34:E38)","v":0},{"$f":"SUM(F34:F38)","v":0}]
[]
["SECTION III.","ADMINISTRATIVE/INDIRECT COSTS",null,"CNCS SHARE CURRENT EXPENSE","GRANTEE SHARE CURRENT EXPENSE","TOTAL CURRENT EXPENSE \n(auto-calculates)"]
["A.","Corporation Fixed Percentage"]
[null,"Corporation Fixed Amount (3%)",null,null,null,{"$f":"SUM(D43:E43)","v":0}]
[null,"Commission Fixed Amount (2%)",null,null,null,{"$f":"SUM(D44:E44)","v":0}]
["B.","Federally Approved Indirect Cost Rate",null,null,null,{"$f":"SUM(D45:E45)","v":0}]
[null,"SECTION III TOTAL",null,{"$f":"SUM(D42:D45)","v":0},{"$f":"SUM(E42:E45)","v":0},{"$f":"SUM(F42:F45)","v":0}]
[]
["TOTAL","CNCS / GRANTEE (auto-calculates) ",null,{"$f":"SUM(D31+D39+D46)","v":0},{"$f":"SUM(E31+E39+E46)","v":0},{"$f":"SUM(F31+F39+F46)","v":0}]
[]
["Amount Reimbursable to Grantee",null,null,{"$f":"D48-D44","v":0}]
[]
["By signing this report, I certify to the best of my knowledge and belief that the report is true, complete, and accurate, and the expenditures, "]
["disbursements and cash receipts are for the purposes and objectives set forth in the terms and conditions of the Federal award. I am aware that any "]
["false, fictitious, or fraudulent information, or the omission of any material fact, may subject me to criminal, civil or administrative penalties for fraud, false "]
["statements, false claims or otherwise. (U.S. Code Title 18, Section 1001 and Title 31, Sections 3729-3730 and 3801-3812)."]
["Printed Name",null,null,"Signature"]
[]
["Date"]

{"sheet":"Lookup","index":1,"n_rows":103,"n_cols":19,"rows_kept":103,"cut":false,"hidden":false,"merged":[[0,12,0,13],[0,2,0,3],[0,4,0,5],[0,6,0,7],[0,8,0,9],[0,10,0,11]]}
["Account Title","Account Code","2011-2012",null,"2012-2013",null,"2013-2014",null,"2014-2015",null,"2015-2016",null,"2016-2017"]
[null,null,"Prime Grant #","Fund#/\nAcct Code","Prime Grant #","Fund#/\nAcct Code","Prime Grant #","Fund#/\nAcct Code","Prime Grant #","Fund#/\nAcct Code","Prime Grant #","Fund#/\nAcct Code","Prime Grant #","Fund#/\nAcct Code","FUND","PRIME","Grant Year"]
[]
["(blank)","(blank)","(blank)","(blank)","(blank)","(blank)","(blank)","(blank)","(blank)","(blank)","(blank)","(blank)","(blank)","(blank)",33,"13WCHTX001","2012-2013"]
["Amarillo Independent School District",111,"06AFHTX001",92,"06AFHTX001",92,"13AFHTX001",96,"13AFHTX001",96,"13AFHTX001",96,"16AFHTX001",99,42,"10ESHTX001","2013-2014"]
["American YouthWorks",112,null,null,"12FXHTX001",94,"12FXHTX001",94,"12FXHTX001",94,"15FXHTX001",98,"15FXHTX001",98,43,"14ESHTX001","2014-2015"]
["Boys and Girls Club of Austin",202,null,null,"06AFHTX001",92,null,null,"13AFHTX001",96,"13AFHTX001",96,"16AFHTX001",99,92,"06AFHTX001","2015-2016"]
["Breakthrough",191,"06AFHTX001",92,"06AFHTX001",92,"13AFHTX001",96,"12ACHTX001",95,"15ACHTX001",97,"15ACHTX001",97,93,"09ACHTX001","2016-2017"]
["CIS - Central Texas",115,"09ACHTX001",93,"12ACHTX001",95,"12ACHTX001",95,"12ACHTX001",95,"13AFHTX001",96,"16AFHTX001",99,94,"12FXHTX001"]
["CIS-Heart of TX (MCYC)",130,"06AFHTX001",92,"06AFHTX001",92,"13AFHTX001",96,"13AFHTX001",96,"13AFHTX001",96,"15ACHTX001",97,95,"12ACHTX001"]
["City Square (Fmr. Central Dallas Min.)",134,"06AFHTX001",92,"06AFHTX001",92,"13AFHTX001",96,"13AFHTX001",96,"13AFHTX001",96,"16AFHTX001",99,96,"13AFHTX001"]
["City Year - Dallas",208,null,null,null,null,null,null,null,null,"14ESHTX001",43,"14ESHTX001",43,97,"15ACHTX001"]
["City Year - San Antonio",129,"06AFHTX001",92,"12ACHTX001",95,"12ACHTX001",95,"12ACHTX001",95,"15ACHTX001",97,"15ACHTX001",97,98,"15FXHTX001"]
["College Forward (Adm. Control)",136,"06AFHTX001",92,"12ACHTX001",95,"12ACHTX001",95,"12ACHTX001",95,"13AFHTX001",96,"16AFHTX001",99,99,"16AFHTX001"]
["Equal Heart",215,null,null,null,null,null,null,null,null,null,null,"16AFHTX001",99]
["Front Steps (Fmr. Capitol Area Homeless Alliance)",114,"06AFHTX001",92,"12FXHTX001",94,"12FXHTX001",94,"12FXHTX001",94,"15FXHTX001",98,"15FXHTX001",98]
["Habitat for Humanity Texas",217,null,null,null,null,null,null,null,null,null,null,"16AFHTX001",99]
["Literacy Coalition of Central Texas",203,null,null,"06AFHTX001",92,"12FXHTX001",94,"12FXHTX001",94,"15FXHTX001",98,"14ESHTX001",43]
["Lone Star College - Kingwood",210,null,null,null,null,null,null,null,null,"13AFHTX001",96,"16AFHTX001",99]
["National College Advising Corps",212,null,null,null,null,null,null,null,null,"15FXHTX001",98,"15FXHTX001",98]
["OneStar Foundation",216,null,null,null,null,null,null,null,null,null,null,"16AFHTX001",99]
["Project Transformation",119,"09ACHTX001",93,"12ACHTX001",95,"12ACHTX001",95,"12ACHTX001",95,"15ACHTX001",97,"15ACHTX001",97]
["Reading Partners",205,null,null,"06AFHTX001",92,"10ESHTX001",42,"14ESHTX001",43,"14ESHTX001",43,"14ESHTX001",43]
["Relay Graduate School of Education",211,null,null,null,null,null,null,null,null,"15FXHTX001",98,"15FXHTX001",98]
["Senior Citizens of Greater Dallas",214,null,null,null,null,null,null,null,null,null,null,"16AFHTX001",99]
["Teach for America",121,"10ESHTX001",42,"12FXHTX001",94,"12FXHTX001",94,"12FXHTX001",94,"15FXHTX001",98,"15FXHTX001",98]
["Texas A & M International",187,"06AFHTX001",92,null,null,null,null,null,null,null,null,"16AFHTX001",99]
["Travis County Health and Human Services and Veterans Service",123,"06AFHTX001",92,"06AFHTX001",92,"13AFHTX001",96,"13AFHTX001",96,"13AFHTX001",96,"16AFHTX001",99]
["United Way of El Paso County",131,"06AFHTX001",92,null,null,null,null,"12ACHTX001",95,"15ACHTX001",97,"15ACHTX001",97]
["University of North Texas",124,"06AFHTX001",92,"06AFHTX001",92,"12ACHTX001",95,"12ACHTX001",95,"15ACHTX001",97,"15ACHTX001",97,null,null,null,null," "]
["University of Texas - Rio Grande Valley",213,null,null,null,null,null,null,null,null,"13AFHTX001",96,"16AFHTX001",99]
["UT Austin Charles A. Dana Center",125,"09ACHTX001",93,"06AFHTX001",92,"13AFHTX001",96,"13AFHTX001",96,"14ESHTX001",43,"14ESHTX001",43]
["inactive below this line:"]
["Abilene Christian University",146]
["Alamo Area Rape Crisis Center",110]
["American Youthworks Recovery",170]
["American Youthworks Recovery",173]
["AmeriCorps Administrative",100]
["Andrews Center - Independence Project",113]
["Assoc. For Retarded ( ARC ) Real Life",152]
["Austin Habitat for Humanity",154]
["Austin Independent School District",207,null,null,null,null,"13WCHTX001",33,"13WCHTX001",33,"13WCHTX001",33]
["Avance Elpaso Recovery",175]
["AVANCE Inc. El- Paso",145,"06AFHTX001",92,"06AFHTX001",92,"13AFHTX001",96,"13AFHTX001",96]
["Big Brothers Big Sister El Paso",144]
["Bishop Blue",150]
["Capital Area Food Bank",139]
["Capital Area Homeless ( Front Steps ) Recovery",178]
["Casa De Amigos",186,"06AFHTX001",92]
["Catholic Charities of Central TX.",160]
["Central Dallas Min. Recovery",183]
["CIS - Heart of Texas Recovery",171]
["CIS - MCYC Heart of Texas Recovery",177]
["CIS Dallas Region",166,"06AFHTX001",92]
["City of Houston",155]
["City Square (Fmr. Central Dallas Min.) Slot Buyback",134,null,null,null,null,"06AFHTX001",92]
["City Year Inc Recovery",176]
["College for all Texans",161]
["College Forward Recovery",174]
["Disability Inclusion",201]
["Easter Seals (Fmr. Unit Cer. Palsy)",148]
["Edcouch-Elsa ISD",116]
["Family Abuse Center",153]
["Goodwill Industries of Central East Texas",132,"06AFHTX001",92]
["Green Light Ministries, Inc.",133]
["Habitat for Humanity",117]
["Habitat for Humanity Deconstruction",159]
["Harris County Dept of Ed.",140,"06AFHTX001",92,"06AFHTX001",92,"13AFHTX001",96,"13AFHTX001",96]
["Harris County Hospital District",118]
["Jumpstart for young Children",164]
["National Association of Comm. Health Center",157]
["National Association of Community Health  Center",156]
["Northeast Texas Community College",149]
["Pharr-San Juan-Alamo ISD",195,"06AFHTX001",92,"06AFHTX001",92]
["Project GRAD",204,null,null,"06AFHTX001",92,"12ACHTX001",95,"12ACHTX001",95,"15ACHTX001",97]
["Project Transformation Recovery",172]
["Public Allies Inc.",151]
["Refugee Services of Texas",162]
["San Antonio Youth Center",165,null,null,"06AFHTX001",92,"13AFHTX001",96]
["Schulenburg Weimar In Focus Together",143,"06AFHTX001",92,"06AFHTX001",92,"13AFHTX001",96,"13AFHTX001",96]
["Student Conservation Association",209,null,null,null,null,null,null,null,null,"13AFHTX001",96]
["St. Edward's University",120]
["St. Mary's University",147]
["Tech Prep of Rio Grande Valley Inc.",137]
["Texas A&M International University (planning)",184]
["Texas A&M Colonias",188,"06AFHTX001",92]
["Texas Cooperative",138]
["Texas Education Agency-CIS of TX Americorps Planning",196]
["Texas Higher Education",179]
["The Houston READ Commission",122]
["United Cerebral Palsey Recovery",180]
["United way Elpaso County recovery",181]
["United Way Elpaso Disaster Rel",158]
["University of Texas - Brownsville",190,"06AFHTX001",92,"06AFHTX001",92,"13AFHTX001",96,"13AFHTX001",96,"13AFHTX001",96]
["UT Austin Charles A Dana Recovery",182]
["UT Austin-Ins. for Pub School Init",194]
["UT Health Science Center/San Antonio",126]
["UT Southwest Medical",163]
["West Central Texas COG",206,null,null,"06AFHTX001",92]
["YMCA of Metropolitan Dallas",127]
["Youth Advocate San Antonio",142]
["Youth Advocates",128]
["Youth Launch",135]