{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["1. Instructions","2. Example","3. Summary & Data","4. Graphs","5. Annual Report"],"not_rendered":{"charts":15,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"1. Instructions","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[16,3,17,8],[0,2,0,9],[2,3,2,9],[3,3,3,5],[4,3,4,7],[5,3,5,9]]}
[null,null,"Quarterly/Annual Evaluation Report Instructions"]
[]
[null,null,"1.","Complete the information requested in the \"Summary & Data\" tab."]
[null,null,null,"a. Do not leave anything blank."]
[null,null,null,"b. List each Performance Measure separately."]
[null,null,null,"c. Put ONLY numerical data in the quarterly \"Goal\" and \"Actual\" fields."]
[]
[null,null,"3.","Submit the worksheet to your Grant Administrator."]
[null,null,null,"Documents are only accepted via email."]
[]
[null,null,null,"Call or email your specific Grant Administrator:"]
[null,null,null,null,"Lii Levale",null,"907-465-5642"]
[null,null,null,null,"lii.levale@ alaska.gov"]
[null,null,null,null,"Stephanie Hinckle",null,"907-465-6996"]
[null,null,null,null,"stephanie.hinckle@alaska.gov"]
[]
[null,null,"4.","Quarterly Reports are due on the 15th of the month following each Federal Fiscal Quarter:"]
[]
[null,null,null,"Q1","Oct-Dec","Due on January 15"]
[null,null,null,"Q2","Jan-Mar","Due on April 15"]
[null,null,null,"Q3","Apr-Jun","Due on July 15"]
[null,null,null,"Q4","Jul-Sep","Due on October 15"]

{"sheet":"2. Example","index":1,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,2,45,3],[44,4,45,14],[41,2,41,3],[2,2,4,14],[19,2,27,9],[42,4,43,14],[41,4,41,14],[39,4,40,14],[37,4,38,14],[6,5,6,13],[34,2,34,3],[39,2,40,3],[42,2,43,3],[35,4,36,14],[35,2,36,3],[37,2,38,3]]}
[null,null,"Sample Exercise"]
[]
[null,null,"What is my organization's actual \"baseline\"? And how's that different from the baseline goal? This exercise will walk you through filling out the Alaska Highway Safety Office's Quarterly/Annual Evaluation Report, while answering some key questions. "]
[]
[]
[]
[null,null,"Performance Measure: "]
[]
[null,null,"Quarterly","Baseline","Q1","Q2","Q3","Q4","Year-end"]
[null,null,"Goal",40,null,null,null,null,{"$f":"SUM(E10:H10)","v":0}]
[null,null,"Actual",42,null,null,null,null,{"$f":"SUM(E11:H11)","v":0}]
[]
[]
[null,null,"Annually","FY2017","FY2018","FY2019","FY2022","FY2021","FY2022"]
[null,null,"Goal"]
[null,null,"Actual"]
[]
[null,null,"Is this measure achieving measureable progress?"]
[null,null,"Explanation:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"What is…"]
[null,null,"the quarterly baseline goal?",null,"The baseline goal is a number that should be established by looking at prior trends and setting reasonable expectations for the upcoming fiscal year. This is the number from the yellow-highlighted box."]
[]
[null,null,"the quarterly actual baseline?",null,"The actual baseline is last year's \"Actual\" year-end total."]
[]
[null,null,"the quarterly actual  amount?",null,"The actual quarterly number is the number for that quarter only. This row is not a running total (that's what the \"Year-end\" column is for!)."]
[]
[null,null,"the annual goal?",null,"The annual goal is the total goal for a given year."]
[null,null,"the annual actual amount?",null,"The annual actual amount is the actual year-end total."]
[]
[null,null,"the yellow-highlighted box?",null,"The yellow highlighted box (in this case, the annual FY2022 goal) is your organization's projected goal based on past annual goals."]

{"sheet":"3. Summary & Data","index":2,"n_rows":197,"n_cols":9,"rows_kept":197,"cut":false,"hidden":false,"merged":[[7,4,8,6],[9,3,9,6],[10,3,10,6],[11,3,11,9],[12,3,12,9],[177,4,185,9],[197,2,205,9],[13,3,13,9],[14,3,14,9],[101,2,109,9],[113,4,121,9],[133,2,141,9],[145,4,153,9],[165,2,173,9],[21,2,21,4],[25,2,45,9],[49,4,57,9],[69,2,77,9],[81,4,89,9],[22,3,22,4]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"State of Alaska, DOT&PF"]
[null,null,null,null,null,null,null,"PO Box 112500"]
[null,null,null,null,"Quarterly Report",null,null,"Juneau, AK 99811-2500"]
[null,null,null,null,null,null,null,"Phone: 907-465-4070"]
[null,null,"Organization",null,null,null,null,"Fax: 907-465-6984"]
[null,null,"Grant No.",null,null,null,null,"www.dot.alaska.gov/ahso"]
[null,null,"Project Manager"]
[null,null,"Phone"]
[null,null,"Report Prepared By"]
[null,null,"Grant Title"]
[]
[]
[]
[]
[]
[]
[null,null,"Reimbursement Request Form Attached?"]
[null,null,"Reporting Quarter","Q4: Jul-Sep"]
[]
[null,null,"Project Activities this Quarter:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"List each performance measure separately."]
[]
[null,"Performance Measure 1:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Quarterly","Baseline","Q1","Q2","Q3","Q4","Year-end"]
[null,null,"Goal",null,null,null,null,null,{"$f":"SUM(E61:H61)","v":0}]
[null,null,"Actual",null,null,null,null,null,{"$f":"SUM(E62:H62)","v":0}]
[]
[null,null,"Annually","FY2017","FY2018","FY2019","FY2020","FY2021","FY2022"]
[null,null,"Goal"]
[null,null,"Actual"]
[]
[null,"Is this measure achieving measureable progress?"]
[null,"Explanation:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Performance Measure 2:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Quarterly","Baseline","Q1","Q2","Q3","Q4","Year-end"]
[null,null,"Goal",null,null,null,null,null,{"$f":"SUM(E93:H93)","v":0}]
[null,null,"Actual",null,null,null,null,null,{"$f":"SUM(E94:H94)","v":0}]
[]
[null,null,"Annually","FY2017","FY2018","FY2019","FY2020","FY2021","FY2022"]
[null,null,"Goal"]
[null,null,"Actual"]
[]
[null,"Is this measure achieving measureable progress?"]
[null,"Explanation:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Performance Measure 3:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Quarterly","Baseline","Q1","Q2","Q3","Q4","Year-end"]
[null,null,"Goal",null,null,null,null,null,{"$f":"SUM(E125:H125)","v":0}]
[null,null,"Actual",null,null,null,null,null,{"$f":"SUM(E126:H126)","v":0}]
[]
[null,null,"Annually","FY2017","FY2018","FY2019","FY2020","FY2021","FY2022"]
[null,null,"Goal"]
[null,null,"Actual"]
[]
[null,"Is this measure achieving measureable progress?"]
[null,"Explanation:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Performance Measure 4:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Quarterly","Baseline","Q1","Q2","Q3","Q4","Year-end"]
[null,null,"Goal",null,null,null,null,null,{"$f":"SUM(E157:H157)","v":0}]
[null,null,"Actual",null,null,null,null,null,{"$f":"SUM(E158:H158)","v":0}]
[]
[null,null,"Annually","FY2017","FY2018","FY2019","FY2020","FY2021","FY2022"]
[null,null,"Goal",null,null,null,null,null,15]
[null,null,"Actual"]
[]
[null,"Is this measure achieving measureable progress?"]
[null,"Explanation:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Performance Measure 5:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Quarterly","Baseline","Q1","Q2","Q3","Q4","Year-end"]
[null,null,"Goal",null,null,null,null,null,{"$f":"SUM(E189:H189)","v":0}]
[null,null,"Actual",null,null,null,null,null,{"$f":"SUM(E190:H190)","v":0}]
[]
[null,null,"Annually","FY2017","FY2018","FY2019","FY2020","FY2021","FY2022"]
[null,null,"Goal"]
[null,null,"Actual"]
[]
[null,"Is this measure achieving measureable progress?"]
[null,"Explanation:"]

{"sheet":"4. Graphs","index":3,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Graphs"]

{"sheet":"5. Annual Report","index":4,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,2,0,6],[5,2,7,10],[9,2,48,10]]}
[null,null,"Year-End Report Narrative"]
[null,null,"Grant Title:"]
[null,null,"Grant Number: "]
[null,null,"Grant Award Amt: "]
[null,null,"Grant Award Expenditure:"]
[null,null,"For this narrative, outline what your organization's goals were this year and whether those goals were met. If they were met, detail how this was accomplished. If they were not, explain the challenges that your organization faced in achieving those goals."]