{"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":57,"n_cols":6,"rows_kept":57,"cut":false,"hidden":false,"merged":[[56,4,56,5],[54,4,54,5],[46,1,46,2],[29,1,29,2],[37,1,37,2],[44,1,44,2],[48,0,48,2],[2,0,2,1],[0,0,0,5],[14,0,14,5],[5,0,5,5],[1,1,1,2],[1,4,1,5],[3,4,3,5],[6,2,6,3]]}
["ONESTAR USE ONLY"]
[" PER APPROVED BY:"," GO Initials & Date: ",null," AD Initials & Date: ","   FINAL PER:    Yes   /    No"]
[" OneStar Prime Grant:",null,{"$f":"+LOOKUP($F$3, Lookup!$G$3:$G$7, Lookup!$H3:$H$7)","v":{"$error":"#N/A"}},{"$f":"\"Program Code:  \"& LOOKUP($C$7,Lookup!$B$3:$B$84,Lookup!$A$3:$A$84)","v":{"$error":"#N/A"}}," Fund Code:",{"$f":"+IF($C$10=\"2011-2012\",(LOOKUP($C$7,Lookup!$B$3:$B$84,Lookup!$D3:$D$84)),((LOOKUP($C$7,Lookup!$B$3:$B$84,Lookup!$F3:$F$84))))","v":{"$error":"#N/A"}}]
[null,null,null,"PER #",{"$f":"\"PER\"&RIGHT(D3,3)&MONTH(E13)&DAY(E13)&RIGHT((YEAR(E13)),2)","v":{"$error":"#N/A"}}]
["AmeriCorps Periodic Expense Report (PER)"]
["The information in this section is REQUIRED for each periodic expense report (PER)."]
["Legal Applicant Name"]
["Program Name"]
[]
["Grant Year",null,null,"Grant Type","AmeriCorps Grant"]
[]
["PER For the Period Covering"]
[null,"Start Date",null,"End Date"]
[]
["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(D17:E17)","v":0}]
["B.","Personnel Fringe Benefits",null,null,null,{"$f":"SUM(D18:E18)","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(D17:D29)","v":0},{"$f":"SUM(E17:E29)","v":0},{"$f":"SUM(F17:F29)","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(D33:E33)","v":0}]
["B.","Member Support Costs",null,null,null,{"$f":"SUM(D34:E34)","v":0}]
[null,"FICA",null,null,null,{"$f":"SUM(D35:E35)","v":0}]
[null,"Worker's Compensation",null,null,null,{"$f":"SUM(D36:E36)","v":0}]
[null,"Health Care",null,null,null,{"$f":"SUM(D37:E37)","v":0}]
[null,"SECTION II TOTAL",null,{"$f":"SUM(D33:D37)","v":0},{"$f":"SUM(E33:E37)","v":0},{"$f":"SUM(F33:F37)","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",null,null,null,{"$f":"SUM(D42:E42)","v":0}]
[null,"Commission Fixed Amount",null,null,null,{"$f":"SUM(D43:E43)","v":0}]
["B.","Federally Approved Indirect Cost Rate",null,null,null,{"$f":"SUM(D44:E44)","v":0}]
[null,"SECTION III TOTAL",null,{"$f":"SUM(D41:D44)","v":0},{"$f":"SUM(E41:E44)","v":0},{"$f":"SUM(F41:F44)","v":0}]
[]
["TOTAL","CNCS / GRANTEE (auto-calculates) ",null,{"$f":"SUM(D30+D38+D45)","v":0},{"$f":"SUM(E30+E38+E45)","v":0},{"$f":"SUM(F30+F38+F45)","v":0}]
[]
["Amount Reimbursable to Grantee",null,null,{"$f":"D47-D43","v":0}]
[]
["The person signing this Periodic Expense Report (PER) on behalf of Sub-Grantee or representing himself/herself as signing this PER "]
["on behalf of the Sub-Grantee, hereby warrant and guarantee that he/she has been duly authorized by the Sub-Grantee and certify"]
["to the best of my knowledge and belief that this report is correct and complete.  "]
[]
["Printed Name",null,null,"Signature"]
[]
["Date"]

{"sheet":"Lookup","index":1,"n_rows":82,"n_cols":11,"rows_kept":82,"cut":false,"hidden":true,"merged":[[0,2,0,3],[0,4,0,5]]}
["Account Code","Account Title","2011-2012",null,"2012-2013"]
[null,null,"Prime Grant #","Fund#/\nAcct Code","Prime Grant #","Fund#/\nAcct Code",null,null,"Grant Year"]
[146,"Abilene Christian University",null,null,null,null,42,"10ESHTX001","2011-2012"]
[110,"Alamo Area Rape Crisis Center",null,null,null,null,92,"06AFHTX001","2012-2013"]
[111,"Amarillo Independent School District","06AFHTX001",92,"06AFHTX001",92,93,"09ACHTX001"]
[112,"American YouthWorks",null,null,"12FXHTX001",94,94,"12FXHTX001"]
[170,"American Youthworks Recovery",null,null,null,null,95,"12ACHTX001"]
[173,"American Youthworks Recovery"]
[100,"AmeriCorps Administrative"]
[113,"Andrews Center - Independence Project"]
[152,"Assoc. For Retarded ( ARC ) Real Life"]
[154,"Austin Habitat for Humanity"]
[175,"Avance Elpaso Recovery"]
[145,"Avance Inc. El- Paso","06AFHTX001",92,"06AFHTX001",92]
[144,"Big Brothers Big Sister El Paso"]
[150,"Bishop Blue"]
[191,"Breakthrough","06AFHTX001",92,"06AFHTX001",92]
[139,"Capital Area Food Bank"]
[178,"Capital Area Homeless ( Front Steps ) Recovery"]
[186,"Casa De Amigos","06AFHTX001",92]
[160,"Catholic Charities of Central TX."]
[183,"Central Dallas Min. Recovery"]
[115,"CIS - Central Texas","09ACHTX001",93,"12ACHTX001",95]
[171,"CIS - Heart of Texas Recovery"]
[177,"CIS - MCYC Heart of Texas Recovery"]
[166,"CIS Dallas Region","06AFHTX001",92,null,null,null,null,null,null," "]
[130,"CIS-Heart of TX (MCYC)","06AFHTX001",92,"06AFHTX001",92]
[155,"City of Houston"]
[134,"City Square (Fmr. Central Dallas Min.)","06AFHTX001",92,"06AFHTX001",92]
[176,"City Year Inc Recovery"]
[129,"City Year, Inc.","06AFHTX001",92,"12ACHTX001",95]
[161,"College for all Texans"]
[136,"College Forward (Adm. Control)","06AFHTX001",92,"12ACHTX001",95]
[174,"College Forward Recovery"]
[201,"Disability Inclusion"]
[148,"Easter Seals (Fmr. Unit Cer. Palsy)"]
[116,"Edcouch-Elsa ISD"]
[153,"Family Abuse Center"]
[114,"Front Steps (Fmr. Capitol Area Homeless Alliance)","06AFHTX001",92,"12FXHTX001",94]
[132,"Goodwill Industries of Central East Texas","06AFHTX001",92]
[133,"Green Light Ministries, Inc."]
[117,"Habitat for Humanity"]
[159,"Habitat for Humanity Deconstruction"]
[140,"Harris County Dept of Ed.","06AFHTX001",92,"06AFHTX001",92]
[118,"Harris County Hospital District"]
[164,"Jumpstart for young Children"]
[157,"National Association of Comm. Health Center"]
[156,"National Association of Community Health  Center"]
[149,"Northeast Texas Community College"]
[195,"Pharr-San Juan-Alamo ISD","06AFHTX001",92,"06AFHTX001",92]
[119,"Project Transformation","09ACHTX001",93,"12ACHTX001",95]
[172,"Project Transformation Recovery"]
[151,"Public Allies Inc."]
[162,"Refugee Services of Texas"]
[165,"San Antonio Youth Center",null,null,"06AFHTX001",92]
[143,"Schulenburg Weimar In Focus Together","06AFHTX001",92,"06AFHTX001",92]
[120,"St. Edward's University"]
[147,"St. Mary's University"]
[121,"Teach for America","10ESHTX001",42,"12FXHTX001",94]
[137,"Tech Prep of Rio Grande Valley Inc."]
[187,"Texas A & M International","06AFHTX001",92]
[188,"Texas A&M Colonias","06AFHTX001",92]
[138,"Texas Cooperative"]
[196,"Texas Education Agency-CIS of TX Americorps Planning"]
[179,"Texas Higher Education"]
[122,"The Houston READ Commission"]
[123,"Travis County 4-H","06AFHTX001",92,"06AFHTX001",92]
[180,"United Cerebral Palsey Recovery"]
[181,"United way Elpaso County recovery"]
[158,"United Way Elpaso Disaster Rel"]
[131,"United Way of El Paso County","06AFHTX001",92]
[124,"University of North Texas","06AFHTX001",92,"06AFHTX001",92]
[190,"University of Texas at Brownsville and Texas Southmost","06AFHTX001",92,"06AFHTX001",92]
[182,"UT Austin Charles A Dana Recovery"]
[125,"UT Austin Charles A. Dana Center","09ACHTX001",93,"06AFHTX001",92]
[194,"UT Austin-Ins. for Pub School Init"]
[126,"UT Health Science Center/San Antonio"]
[163,"UT Southwest Medical"]
[127,"YMCA of Metropolitan Dallas"]
[142,"Youth Advocate San Antonio"]
[128,"Youth Advocates"]
[135,"Youth Launch"]