{"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":"+LOOKUP($F$3, Lookup!$K$3:$K$10, Lookup!$L3:$L$10)","v":"13WCHTX001"},null,{"$f":"\"Program Code:  \"& LOOKUP($C$8,Lookup!$B$3:$B$91,Lookup!$A$3:$A$91)","v":"Program Code:  207"}," Fund Code:",{"$f":"+IF($C$11=\"2011-2012\",LOOKUP($C$8,Lookup!$B$3:$B$91,Lookup!$D3:$D$91),IF($C$11=\"2012-2013\",LOOKUP($C$8,Lookup!$B$3:$B$91,Lookup!$F$3:$F$91),IF($C$11=\"2013-2014\",LOOKUP($C$8,Lookup!$B$3:$B$91,Lookup!$H$3:$H$91),IF($C$11=\"2014-2015\",LOOKUP($C$8,Lookup!$B$3:$B$91,Lookup!$J$3:$J$91)))))","v":33}]
[null,null,null,"PER #",{"$f":"\"PER\"&RIGHT(D3,3)&MONTH(E14)&DAY(E14)&RIGHT((YEAR(E14)),2)","v":"PER20783114"}]
[]
["AmeriCorps Periodic Expense Report (PER)"]
["The information in this section is REQUIRED for each periodic expense report (PER)."]
["Legal Applicant Name",null,"Austin Independent School District",null,null,null,null,"."]
["Program Name"]
[]
["Grant Year",null,"2014-2015","Grant Type","AmeriCorps Grant"]
[]
["PER For the Period Covering"]
[null,"Start Date","2014-08-01","End Date","2014-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}]
[]
["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":89,"n_cols":15,"rows_kept":89,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,5],[0,6,0,7],[0,8,0,9]]}
["Account Code","Account Title","2011-2012",null,"2012-2013",null,"2013-2014",null,"2014-2015"]
[null,null,"Prime Grant #","Fund#/\nAcct Code","Prime Grant #","Fund#/\nAcct Code","Prime Grant #","Fund#/\nAcct Code","Prime Grant #","Fund#/\nAcct Code",null,null,"Grant Year"]
[146,"Abilene Christian University",null,null,null,null,null,null,null,null,33,"13WCHTX001","2011-2012"]
[110,"Alamo Area Rape Crisis Center",null,null,null,null,null,null,null,null,42,"10ESHTX001","2012-2013"]
[111,"Amarillo Independent School District","06AFHTX001",92,"06AFHTX001",92,"13AFHTX001",96,"13AFHTX001",96,43,"14ESHTX001","2013-2014"]
[112,"American YouthWorks",null,null,"12FXHTX001",94,"12FXHTX001",94,"12FXHTX001",94,92,"06AFHTX001","2014-2015"]
[170,"American Youthworks Recovery",null,null,null,null,null,null,null,null,93,"09ACHTX001"]
[173,"American Youthworks Recovery",null,null,null,null,null,null,null,null,94,"12FXHTX001"]
[100,"AmeriCorps Administrative",null,null,null,null,null,null,null,null,95,"12ACHTX001"]
[113,"Andrews Center - Independence Project",null,null,null,null,null,null,null,null,96,"13AFHTX001"]
[152,"Assoc. For Retarded ( ARC ) Real Life"]
[154,"Austin Habitat for Humanity"]
[207,"Austin Independent School District",null,null,null,null,"13WCHTX001",33,"13WCHTX001",33]
[175,"Avance Elpaso Recovery"]
[145,"AVANCE Inc. El- Paso","06AFHTX001",92,"06AFHTX001",92,"13AFHTX001",96,"13AFHTX001",96]
[144,"Big Brothers Big Sister El Paso"]
[150,"Bishop Blue"]
[202,"Boys and Girls Club of Austin",null,null,"06AFHTX001",92,null,null,"13AFHTX001",96]
[191,"Breakthrough","06AFHTX001",92,"06AFHTX001",92,"13AFHTX001",96,"12ACHTX001",95]
[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,"12ACHTX001",95,"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,null,null,null,null," "]
[130,"CIS-Heart of TX (MCYC)","06AFHTX001",92,"06AFHTX001",92,"13AFHTX001",96,"13AFHTX001",96]
[155,"City of Houston"]
[134,"City Square (Fmr. Central Dallas Min.)","06AFHTX001",92,"06AFHTX001",92,"13AFHTX001",96,"13AFHTX001",96]
[134,"City Square (Fmr. Central Dallas Min.) Slot Buyback",null,null,null,null,"06AFHTX001",92]
[176,"City Year Inc Recovery"]
[129,"City Year, Inc.","06AFHTX001",92,"12ACHTX001",95,"12ACHTX001",95,"12ACHTX001",95]
[161,"College for all Texans"]
[136,"College Forward (Adm. Control)","06AFHTX001",92,"12ACHTX001",95,"12ACHTX001",95,"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,"12FXHTX001",94,"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,"13AFHTX001",96,"13AFHTX001",96]
[118,"Harris County Hospital District"]
[164,"Jumpstart for young Children"]
[203,"Literacy Coalition of Central Texas",null,null,"06AFHTX001",92,"12FXHTX001",94,"12FXHTX001",94]
[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]
[204,"Project GRAD",null,null,"06AFHTX001",92,"12ACHTX001",95,"12ACHTX001",95]
[119,"Project Transformation","09ACHTX001",93,"12ACHTX001",95,"12ACHTX001",95,"12ACHTX001",95]
[172,"Project Transformation Recovery"]
[151,"Public Allies Inc."]
[205,"Reading Partners",null,null,"06AFHTX001",92,"10ESHTX001",42,"14ESHTX001",43]
[162,"Refugee Services of Texas"]
[165,"San Antonio Youth Center",null,null,"06AFHTX001",92,"13AFHTX001",96]
[143,"Schulenburg Weimar In Focus Together","06AFHTX001",92,"06AFHTX001",92,"13AFHTX001",96,"13AFHTX001",96]
[120,"St. Edward's University"]
[147,"St. Mary's University"]
[121,"Teach for America","10ESHTX001",42,"12FXHTX001",94,"12FXHTX001",94,"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 Health and Human Services and Veterans Service","06AFHTX001",92,"06AFHTX001",92,"13AFHTX001",96,"13AFHTX001",96]
[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,null,null,null,null,"12ACHTX001",95]
[124,"University of North Texas","06AFHTX001",92,"06AFHTX001",92,"12ACHTX001",95,"12ACHTX001",95]
[190,"University of Texas at Brownsville and Texas Southmost","06AFHTX001",92,"06AFHTX001",92,"13AFHTX001",96,"13AFHTX001",96]
[182,"UT Austin Charles A Dana Recovery"]
[125,"UT Austin Charles A. Dana Center","09ACHTX001",93,"06AFHTX001",92,"13AFHTX001",96,"13AFHTX001",96]
[194,"UT Austin-Ins. for Pub School Init"]
[126,"UT Health Science Center/San Antonio"]
[163,"UT Southwest Medical"]
[206,"West Central Texas COG",null,null,"06AFHTX001",92]
[127,"YMCA of Metropolitan Dallas"]
[142,"Youth Advocate San Antonio"]
[128,"Youth Advocates"]
[135,"Youth Launch"]