{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["enter Fringe%","enter Fringe$","for augmentees-OPSG","Instructions","SampleForm"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":9,"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":"enter Fringe%","index":0,"n_rows":59,"n_cols":10,"rows_kept":59,"cut":false,"hidden":false,"merged":[[51,1,51,2],[2,2,3,10],[4,2,4,10],[5,2,5,10],[7,3,7,5],[8,3,8,5],[9,3,9,5],[47,4,50,9],[49,1,49,2],[50,1,50,2],[55,2,55,4],[56,2,56,4],[57,2,57,4],[58,2,58,4],[58,8,58,10]]}
[]
[]
[null,null,"Office of the Governor"]
[]
[null,null,"Homeland Security Grants Division"]
[null,null,"PERSONNEL OVERTIME SUMMARY"]
[null,null,null,null,null,null,null,null,null,"    Note:  Use a separate form for each"]
[null,null,"GRANTEE/AGENCY NAME:",null,null,null,null,null,null,"    Personnel budget line."]
[null,null,"FSR REPORTING PERIOD:"]
[null,null,"GRANT NUMBER:",null,null,null,null,"Enter Fringe PERCENTAGE"]
[null,null,"A.","B.","C.","D.","E.","F.","G.","H."]
[null,null,"SECTION I.  CURRENT PERIOD EXPENDITURES:",null,null,null,"(C. x D.)",null,"(E. x F.)","(E. + G.)"]
[null,null,"First & Last Name","Pay Period Ending Date","Program OT Hours","OT Rate Per Hour","Overtime","Enter Fringe Rate","Fringe","Overtime Plus Fringe"]
[null,null,null,null,null,null,{"$f":"ROUND(E14*F14,2)","v":0},null,{"$f":"ROUND(G14*H14,2)","v":0},{"$f":"+I14+G14","v":0}]
[null,null,null,null,null,null,{"$f":"ROUND(E15*F15,2)","v":0},null,{"$f":"ROUND(G15*H15,2)","v":0},{"$f":"+I15+G15","v":0}]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,{"$f":"ROUND(E25*F25,2)","v":0},null,{"$f":"ROUND(G25*H25,2)","v":0},{"$f":"+I25+G25","v":0}]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,{"$f":"ROUND(E34*F34,2)","v":0},null,{"$f":"ROUND(G34*H34,2)","v":0},{"$f":"+I34+G34","v":0}]
[null,null,null,null,null,null,{"$f":"ROUND(E35*F35,2)","v":0},null,{"$f":"ROUND(G35*H35,2)","v":0},{"$f":"+I35+G35","v":0}]
[null,null,"****Place Cursor Here to Insert Row.  Then Click Red Button.",null,null,null,0,null,0,0]
[null,null,null,"CURRENT PERIOD EXPENDITURES:",{"$f":"SUM(E14:E36)","v":0},null,{"$f":"SUM(G14:G36)","v":0},null,{"$f":"SUM(I14:I36)","v":0},{"$f":"SUM(J14:J36)","v":0}]
[]
[null,null,"SECTION II.  ADJUSTMENTS:"]
[null,null,"First & Last Name","Pay Period Ending Date","Program OT Hours","OT Rate Per Hour","Overtime","Enter Fringe Rate","Fringe","Overtime Plus Fringe"]
[null,null,null,null,null,null,{"$f":"ROUND(E41*F41,2)","v":0},null,{"$f":"ROUND(G41*H41,2)","v":0},{"$f":"+I41+G41","v":0}]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,{"$f":"ROUND(E44*F44,2)","v":0},null,{"$f":"ROUND(G44*H44,2)","v":0},{"$f":"+I44+G44","v":0}]
[null,null,null,null,null,null,0,null,0,0]
[null,null,"****Place Cursor Here to Insert Row.  Then Click Red Button.",null,null,null,0,null,0,0]
[null,null,null,"TOTAL ADJUSTMENTS:",{"$f":"SUM(E41:E46)","v":0},null,{"$f":"SUM(G41:G46)","v":0},null,{"$f":"SUM(I41:I46)","v":0},{"$f":"SUM(J41:J46)","v":0}]
[]
[null,null,null,"ADJUSTMENT EXPLANATION: "]
[null,"To ADD ROWS to Section I or II:"]
[null,"Place Cursor In Last Row indicated above"]
[null,"THEN CLICK BUTTON BELOW"]
[null,null,null,"TOTAL THIS PERIOD:",{"$f":"SUM(E47+E37)","v":0},null,{"$f":"SUM(G47+G37)","v":0},null,{"$f":"SUM(I47+I37)","v":0},{"$f":"SUM(J47+J37)","v":0}]
[]
[null,null,"SECTION III.  TOTALS:"]
[null,null,"** For PREVIOUS FSR totals:  In eGrants, go to Budget Tab, then Budget.Summary Tab.  In the Financial Status Report (FSR) Summary-To-Date section next to Personnel, click the + sign for the budget line being reported on this form until you see previous hours and dollars.",null,null,"Number of Hours Worked","Budget Line  OOG_Funds"]
[null,null,"** TOTAL FROM PREVIOUS FINANCIAL STATUS REPORT (FSR):"]
[null,null,"TOTAL FOR THIS FSR PERIOD: ",null,null,{"$f":"SUM(E53)","v":0},{"$f":"SUM(J53)","v":0}]
[null,null,"CUMULATIVE TOTALS FOR CURRENT FSR:",null,null,{"$f":"SUM(F57:F58)","v":0},{"$f":"SUM(G57:G58)","v":0}]

{"sheet":"enter Fringe$","index":1,"n_rows":59,"n_cols":10,"rows_kept":59,"cut":false,"hidden":false,"merged":[[51,1,51,2],[2,2,3,10],[4,2,4,10],[5,2,5,10],[7,3,7,5],[8,3,8,5],[9,3,9,5],[47,4,50,9],[49,1,49,2],[50,1,50,2],[55,2,55,4],[56,2,56,4],[57,2,57,4],[58,2,58,4],[58,8,58,10]]}
[]
[]
[null,null,"Office of the Governor"]
[]
[null,null,"Homeland Security Grants Division"]
[null,null,"PERSONNEL OVERTIME SUMMARY"]
[null,null,null,null,null,null,null,null,null,"    Note:  Use a separate form for each"]
[null,null,"GRANTEE/AGENCY NAME:",null,null,null,null,null,null,"    Personnel budget line."]
[null,null,"FSR REPORTING PERIOD:"]
[null,null,"GRANT NUMBER:",null,null,null,null,"Enter Fringe DOLLAR AMT"]
[null,null,"A.","B.","C.","D.","E.","F.","G.","H."]
[null,null,"SECTION I.  CURRENT PERIOD EXPENDITURES:",null,null,null,"(C. x D.)","(G. / E.)",null,"(E. + G.)"]
[null,null,"First & Last Name","Pay Period Ending Date","Program OT Hours","OT Rate Per Hour","Overtime","Fringe Rate","Enter Fringe Dollars","Overtime Plus Fringe"]
[null,null,null,null,null,null,{"$f":"ROUND(E14*F14,2)","v":0},{"$f":"IF(G14=0,\"\",I14/G14)","v":""},null,{"$f":"ROUND(G14+I14,2)","v":0}]
[null,null,null,null,null,null,{"$f":"ROUND(E15*F15,2)","v":0},{"$f":"IF(G15=0,\"\",I15/G15)","v":""},null,{"$f":"ROUND(G15+I15,2)","v":0}]
[null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,{"$f":"ROUND(E34*F34,2)","v":0},{"$f":"IF(G34=0,\"\",I34/G34)","v":""},null,0]
[null,null,null,null,null,null,0,"",null,{"$f":"ROUND(G35+I35,2)","v":0}]
[null,null,"****Place Cursor Here to Insert Row.  Then Click Red Button.",null,null,null,0,"",null,0]
[null,null,null,"CURRENT PERIOD EXPENDITURES:",{"$f":"SUM(E14:E36)","v":0},null,{"$f":"SUM(G14:G36)","v":0},null,{"$f":"SUM(I14:I36)","v":0},{"$f":"SUM(J14:J36)","v":0}]
[]
[null,null,"SECTION II.  ADJUSTMENTS:"]
[null,null,"First & Last Name","Pay Period Ending Date","Program OT Hours","OT Rate Per Hour","Overtime","Fringe Rate","Enter Fringe Dollars","Overtime Plus Fringe"]
[null,null,null,null,null,null,{"$f":"ROUND(E41*F41,2)","v":0},{"$f":"IF(G41=0,\"\",I41/G41)","v":""},null,{"$f":"ROUND(G41+I41,2)","v":0}]
[null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,{"$f":"ROUND(E45*F45,2)","v":0},{"$f":"IF(G45=0,\"\",I45/G45)","v":""},null,{"$f":"ROUND(G45+I45,2)","v":0}]
[null,null,"****Place Cursor Here to Insert Row.  Then Click Red Button.",null,null,null,0,"",null,0]
[null,null,null,"TOTAL ADJUSTMENTS:",{"$f":"SUM(E41:E46)","v":0},null,{"$f":"SUM(G41:G46)","v":0},null,{"$f":"SUM(I41:I46)","v":0},{"$f":"SUM(J41:J46)","v":0}]
[]
[null,null,null,"ADJUSTMENT EXPLANATION: "]
[null,"To ADD ROWS to Section I or II:"]
[null,"Place Cursor In Last Row indicated above"]
[null,"THEN CLICK BUTTON BELOW"]
[null,null,null,"TOTAL THIS PERIOD:",{"$f":"SUM(E47+E37)","v":0},null,{"$f":"SUM(G47+G37)","v":0},null,{"$f":"SUM(I47+I37)","v":0},{"$f":"SUM(J47+J37)","v":0}]
[]
[null,null,"SECTION III.  TOTALS:"]
[null,null,"** For PREVIOUS FSR totals:  In eGrants, go to Budget Tab, then Budget.Summary Tab.  In the Financial Status Report (FSR) Summary-To-Date section next to Personnel, click the + sign for the budget line being reported on this form until you see previous hours and dollars.",null,null,"Number of Hours Worked","Budget Line  OOG_Funds"]
[null,null,"** TOTAL FROM PREVIOUS FINANCIAL STATUS REPORT (FSR):"]
[null,null,"TOTAL FOR THIS FSR PERIOD: ",null,null,{"$f":"SUM(E53)","v":0},{"$f":"SUM(J53)","v":0}]
[null,null,"CUMULATIVE TOTALS FOR CURRENT FSR:",null,null,{"$f":"SUM(F57:F58)","v":0},{"$f":"SUM(G57:G58)","v":0}]

{"sheet":"for augmentees-OPSG","index":2,"n_rows":59,"n_cols":10,"rows_kept":59,"cut":false,"hidden":false,"merged":[[57,2,57,4],[58,2,58,4],[58,8,58,10],[47,4,50,9],[49,1,49,2],[50,1,50,2],[51,1,51,2],[55,2,55,4],[56,2,56,4],[2,2,3,10],[4,2,4,10],[5,2,5,10],[7,3,7,5],[8,3,8,5],[9,3,9,5]]}
[]
[]
[null,null,"Office of the Governor"]
[]
[null,null,"Homeland Security Grants Division"]
[null,null,"PERSONNEL SUMMARY - AUGMENTEES"]
[null,null,null,null,null,null,null,null,null,"    Note:  Use a separate form for each"]
[null,null,"GRANTEE/AGENCY NAME:",null,null,null,null,null,null,"    Personnel budget line."]
[null,null,"FSR REPORTING PERIOD:"]
[null,null,"GRANT NUMBER:",null,null,null,null,"Enter Fringe PERCENTAGE"]
[null,null,"A.","B.","C.","D.","E.","F.","G.","H."]
[null,null,"SECTION I.  CURRENT PERIOD EXPENDITURES:",null,null,null,"(C. x D.)",null,"(E. x F.)","(E. + G.)"]
[null,null,"First & Last Name","Pay Period Ending Date","Program Hours","Rate Per Hour","Personnel Cost","Enter Fringe Rate","Fringe","Personnel Plus Fringe"]
[null,null,null,null,null,null,{"$f":"ROUND(E14*F14,2)","v":0},null,{"$f":"ROUND(G14*H14,2)","v":0},{"$f":"+I14+G14","v":0}]
[null,null,null,null,null,null,{"$f":"ROUND(E15*F15,2)","v":0},null,{"$f":"ROUND(G15*H15,2)","v":0},{"$f":"+I15+G15","v":0}]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,"****Place Cursor Here to Insert Row.  Then Click Red Button.",null,null,null,0,null,0,0]
[null,null,null,"CURRENT PERIOD EXPENDITURES:",{"$f":"SUM(E14:E36)","v":0},null,{"$f":"SUM(G14:G36)","v":0},null,{"$f":"SUM(I14:I36)","v":0},{"$f":"SUM(J14:J36)","v":0}]
[]
[null,null,"SECTION II.  ADJUSTMENTS:"]
[null,null,"First & Last Name","Pay Period Ending Date","Program Hours","Rate Per Hour","Personnel Cost","Enter Fringe Rate","Fringe","Personnel Plus Fringe"]
[null,null,null,null,null,null,{"$f":"ROUND(E41*F41,2)","v":0},null,{"$f":"ROUND(G41*H41,2)","v":0},{"$f":"+I41+G41","v":0}]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,"****Place Cursor Here to Insert Row.  Then Click Red Button.",null,null,null,0,null,0,0]
[null,null,null,"TOTAL ADJUSTMENTS:",{"$f":"SUM(E41:E46)","v":0},null,{"$f":"SUM(G41:G46)","v":0},null,{"$f":"SUM(I41:I46)","v":0},{"$f":"SUM(J41:J46)","v":0}]
[]
[null,null,null,"ADJUSTMENT EXPLANATION: "]
[null,"To ADD ROWS to Section I or II:"]
[null,"Place Cursor In Last Row indicated above"]
[null,"THEN CLICK BUTTON BELOW"]
[null,null,null,"TOTAL THIS PERIOD:",{"$f":"SUM(E47+E37)","v":0},null,{"$f":"SUM(G47+G37)","v":0},null,{"$f":"SUM(I47+I37)","v":0},{"$f":"SUM(J47+J37)","v":0}]
[]
[null,null,"SECTION III.  TOTALS:"]
[null,null,"** For PREVIOUS FSR totals:  In eGrants, go to Budget Tab, then Budget.Summary Tab.  In the Financial Status Report (FSR) Summary-To-Date section next to Personnel, click the + sign for the budget line being reported on this form until you see previous hours and dollars.",null,null,"Number of Hours Worked","Budget Line  OOG_Funds"]
[null,null,"** TOTAL FROM PREVIOUS FINANCIAL STATUS REPORT (FSR):"]
[null,null,"TOTAL FOR THIS FSR PERIOD: ",null,null,{"$f":"SUM(E53)","v":0},{"$f":"SUM(J53)","v":0}]
[null,null,"CUMULATIVE TOTALS FOR CURRENT FSR:",null,null,{"$f":"SUM(F57:F58)","v":0},{"$f":"SUM(G57:G58)","v":0}]

{"sheet":"Instructions","index":3,"n_rows":60,"n_cols":3,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["PERSONNEL OVERTIME SUMMARY - Homeland Security Grants Division, Office of the Governor"]
[]
["INSTRUCTIONS:  You may refer to the \"SampleForm\" tab for an example of a completed OT Summary Form."]
["The steps below should be completed for the tab labeled either \"enter Fringe%\" or \"enter Fringe$.\"  "]
["Use \"enter Fringe$\" if payroll reports show a dollar amount for each person; otherwise, use \"enter Fringe%.\""]
["* Prepare a separate OT Summary for each budget line, i.e. one for Peace-Officers and one for All-Other-Personnel."]
["* Cumulative Totals in Section III must match numbers entered into eGrants for the Financial Status Report (FSR)."]
["* Once completed, upload a copy of the Personnel OT Summary report to eGrants in either pdf or Excel (xls or xlsx) format.  "]
["* When uploading file - use a naming convention that denotes the FSR period (i.e. December 2016 FSR)"]
["* Keep all other supporting documentation for review upon request; submit only this report when entering an FSR."]
[]
["REPORTING PERIOD:  An FSR is required at least Quarterly, but may be submitted Monthly."]
["The reporting period must reconcile to entries posted to your general ledger, which may consist of multiple pay periods. "]
["For each FSR, report all entries posted to the general ledger for this Monthly or Quarterly FSR reporting period."]
[]
["SECTION I.  CURRENT PERIOD EXPENDITURES:"]
["To add more lines, place the cursor on the last row for Section I and click the ADD ROWS button."]
["* Enter the names for each individual claiming grant-funded Overtime Hours for this FSR reporting period."]
[null,"Note:  When entering the FSR in eGrants for a Personnel/Overtime budget line, First and Last Names "]
[null,"will also be entered into eGrants in the Personnel-Compensated field of the FSR."]
["* Enter Pay Period Ending date for each individual claiming grant-funded Overtime Hours for this FSR reporting period."]
[null,"Note:  If an individual earned overtime during multiple pay periods within this FSR reporting period, "]
[null,null,"list the individual's name separately under each appropriate Pay Period End Date."]
["* Enter the total Number of Program Overtime Hours worked (and paid) for each individual for each pay period."]
["* Enter the Overtime Rate Per Hour for each individual for each pay period."]
["* If using the \"enter Fringe%\" tab, enter the Fringe Rate for each individual for each pay period.  If using the"]
["   \"enter Fringe$\" tab, enter the Fringe Dollar Amount for each individual for each pay period."]
[]
["SECTION II.  ADJUSTMENTS:"]
["To add more lines, place the cursor on the last row for Section II and click the ADD ROWS button."]
["This section may be used to report any corrections or adjustments necessary from a previous FSR reporting period.  "]
[null,"Examples -  Adjustments might be necessary in the following circumstances:"]
[null,null," - Unclaimed hours from a previous reporting period."]
[null,null," - Correction of timesheet errors from a previous reporting period."]
[null,null," - Adjustments to remove disallowed hours from a previous reporting period."]
[null,null," - Other accounting adjustments to reconcile the FSR with your general ledger."]
[]
["* Enter the names for each individual whose OT Hours require adjustment for a prior FSR reporting period."]
["* Enter the prior pay period affected by the adjustment.  "]
["* Enter any adjustments to the Number of Overtime Hours Worked from a previous pay period.  "]
[null,"Be sure to enter a minus sign (-) for negative adjustments."]
["* Enter the Overtime Rate Per Hour for each individual for each pay period period affected."]
["* Enter the Fringe Rate or Fringe Dollar Amount for each individual for each pay period affected.  "]
[null,"You may leave this field blank if Fringe costs were not involved in the adjustment."]
[]
["SECTION III.  TOTALS:"]
["* Enter the cumulative Total Overtime Hours Worked and cumulative Total Expenditures from the PREVIOUS FSR."]
[]
[null,"Steps to locate Cumulative Total Hours and Total Expenditures for this line item from previous FSR in eGrants:"]
[null,null," - Open eGrants and log in."]
[null,null," - From the My.Home page, locate the grant record and click the hyperlinked grant number."]
[null,null," - Navigate to the Budget tab and then the Financial.Status.Report sub tab."]
[null,null," - If you have not already created the FSR for this period, do so now."]
[null,null," - Open the Personnel Budget Category by clicking the plus (+) sign."]
[null,null," - Click the plus (+) sign next to the appropriate OT line item."]
[null,null," - The Cumulative Total Hours and Cumulative Total Expenditures will be displayed in the most "]
[null,null,"recent FSR under the column headings \"Number of Hours Worked\" and \"OOG Funds\", respectively."]
[]
["* The Cumulative Totals for the CURRENT FSR will auto-calculate.  "]
[null,"Use these numbers to complete data entry into eGrants for the current FSR."]

{"sheet":"SampleForm","index":4,"n_rows":58,"n_cols":10,"rows_kept":58,"cut":false,"hidden":false,"merged":[[54,2,54,4],[56,2,56,4],[57,2,57,4],[55,2,55,4],[57,8,57,10],[2,2,3,10],[4,2,4,10],[5,2,5,10],[7,3,7,5],[8,3,8,5],[49,1,49,2],[50,1,50,2],[48,1,48,2],[9,3,9,5],[46,4,49,9]]}
[]
[]
[null,null,"Office of the Governor"]
[]
[null,null,"Homeland Security Grants Division"]
[null,null,"PERSONNEL OVERTIME SUMMARY"]
[null,null,null,null,null,null,null,null,null,"    Note:  Use a separate form for each"]
[null,null,"GRANTEE/AGENCY NAME:","Sample Agency",null,null,null,null,null,"    Personnel-Overtime budget line."]
[null,null,"FSR REPORTING PERIOD:","2016-12-31"]
[null,null,"GRANT NUMBER:",1234501]
[null,null,"A.","B.","C.","D.","E.","F.","G.","H."]
[null,null,"SECTION I.  CURRENT PERIOD EXPENDITURES:",null,null,null,"(C. x D.)",null,"(E. x F.)","(E. + G.)"]
[null,null,"First & Last Name","Pay Period Ending","Program OT Hours","OT Rate Per Hour","Overtime","Fringe Rate","Fringe","Overtime Plus Fringe"]
[null,null,"John Doe","2016-12-10",15,18,{"$f":"ROUND(E14*F14,2)","v":270},0.14649999999999999,{"$f":"ROUND(G14*H14,2)","v":39.56},{"$f":"+I14+G14","v":309.56}]
[null,null,"Jane Smith","2016-12-10",10,25,{"$f":"ROUND(E15*F15,2)","v":250},0.14649999999999999,{"$f":"ROUND(G15*H15,2)","v":36.630000000000003},{"$f":"+I15+G15","v":286.63}]
[null,null,"Joe Grant","2016-12-10",5,25,125,0.14649999999999999,18.309999999999999,143.31]
[null,null,"Jill Funded","2016-12-10",7,18,126,0.14649999999999999,18.46,144.46]
[null,null,null,null,null,null,0,0.14649999999999999,0,0]
[null,null,"John Doe","2016-12-24",10,18,180,0.14649999999999999,26.37,206.37]
[null,null,"Jane Smith","2016-12-24",12,25,300,0.14649999999999999,43.95,343.95]
[null,null,"Joe Grant","2016-12-24",16,25,400,0.14649999999999999,58.6,458.6]
[null,null,"Jill Funded","2016-12-24",20,18,360,0.14649999999999999,52.74,412.74]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,"****Place Cursor Here to Insert Row.  Then Click Button",null,null,null,{"$f":"ROUND(E35*F35,2)","v":0},null,{"$f":"ROUND(G35*H35,2)","v":0},{"$f":"+I35+G35","v":0}]
[null,null,null,"CURRENT PERIOD EXPENDITURES:",{"$f":"SUM(E14:E35)","v":95},null,{"$f":"SUM(G14:G35)","v":2011},null,{"$f":"SUM(I14:I35)","v":294.62},{"$f":"SUM(J14:J35)","v":2305.62}]
[]
[null,null,"SECTION II.  ADJUSTMENTS:"]
[null,null,"First & Last Name","Pay Period Ending","Program OT Hours","OT Rate Per Hour","Overtime","Fringe Rate","Fringe","Overtime Plus Fringe"]
[null,null,"John Doe","2016-11-12",-2,25,{"$f":"ROUND(E40*F40,2)","v":-50},0.14649999999999999,{"$f":"ROUND(G40*H40,2)","v":-7.33},{"$f":"+I40+G40","v":-57.33}]
[null,null,"Jane Smith","2016-11-12",5,18,90,0.14649999999999999,{"$f":"ROUND(G41*H41,2)","v":13.19},{"$f":"+I41+G41","v":103.19}]
[null,null,"Jill Funded","2016-11-12",-10,33.5,-335,0.14649999999999999,-49.08,-384.08]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,{"$f":"ROUND(E44*F44,2)","v":0},null,{"$f":"ROUND(G44*H44,2)","v":0},{"$f":"+I44+G44","v":0}]
[null,null,"****Place Cursor Here to Insert Row and Click Button",null,null,null,0,null,0,0]
[null,null,null,"TOTAL ADJUSTMENTS:",{"$f":"SUM(E40:E45)","v":-7},null,{"$f":"SUM(G40:G45)","v":-295},null,{"$f":"SUM(I40:I45)","v":-43.22},{"$f":"SUM(J40:J45)","v":-338.21999999999997}]
[]
[null,null,null,"ADJUSTMENT EXPLANATION: "]
[null,"To ADD ROWS to Section I or II:"]
[null,"Place Cursor In Last Row indicated above"]
[null,"THEN CLICK BUTTON BELOW"]
[null,null,null,"TOTAL THIS PERIOD:",{"$f":"SUM(E46+E36)","v":88},null,{"$f":"SUM(G46+G36)","v":1716},null,{"$f":"SUM(I46+I36)","v":251.4},{"$f":"SUM(J46+J36)","v":1967.3999999999999}]
[]
[null,null,"SECTION III.  TOTALS:"]
[null,null,"** For PREVIOUS FSR totals:  In eGrants, go to Budget Tab, then Budget.Summary Tab.  In the Financial Status Report (FSR) Summary-To-Date section next to Personnel, click the + sign for the budget line being reported on this form until you see previous hours and dollars.",null,null,"Number of Hours Worked","Budget Line  OOG_Funds"]
[null,null,"** TOTAL FROM PREVIOUS FINANCIAL STATUS REPORT (FSR):",null,null,97,2330]
[null,null,"TOTAL FOR THIS FSR PERIOD: ",null,null,{"$f":"SUM(E52)","v":88},{"$f":"SUM(J52)","v":1967.3999999999999}]
[null,null,"CUMULATIVE TOTALS FOR CURRENT FSR:",null,null,{"$f":"SUM(F56:F57)","v":185},{"$f":"SUM(G56:G57)","v":4297.3999999999996}]