{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["enter Fringe%","enter Fringe$","OLS Augmentees","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":65,"n_cols":11,"rows_kept":65,"cut":false,"hidden":false,"merged":[[61,2,61,5],[62,2,62,5],[63,2,63,5],[64,2,64,5],[64,9,64,11],[57,1,57,2],[2,2,3,11],[4,2,4,11],[6,2,6,11],[10,4,10,6],[11,4,11,6],[12,4,12,6],[53,5,56,10],[55,1,55,2],[56,1,56,2],[5,2,5,11],[9,4,9,6],[8,4,8,6]]}
[]
[]
[null,null,"Office of the Governor"]
[]
[null,null,"Operation Lone Star (OLS)"]
[]
[null,null,"PERSONNEL OVERTIME SUMMARY"]
[null,null,null,null,null,null,null,null,null,null,"    Note:  Use a separate form for each"]
[null,null,null,null,null,null,null,null,null,null,"    Personnel budget line."]
[null,null,null,null,null,null,null,null,null,null,"    Personnel budget line."]
[null,null,"GRANTEE/AGENCY NAME:",null,null,null,null,null,null,null,"    Personnel budget line."]
[null,null,"FSR REPORTING PERIOD:"]
[null,null,"GRANT NUMBER:",null,null,null,null,null,"Enter Fringe PERCENTAGE"]
[null,null,"A.",null,"B.","C.","D.","E.","F.","G.","H."]
[null,null,"SECTION I.  CURRENT PERIOD EXPENDITURES:",null,null,null,null,"(C. x D.)",null,"(E. x F.)","(E. + G.)"]
[null,null,"First & Last Name","TCOLE PID #","Pay Period Ending Date","OLS OT Hours","OT Rate Per Hour","Overtime","Enter Fringe Rate","Fringe","Overtime Plus Fringe"]
[null,null,null,null,null,null,null,{"$f":"ROUND(F17*G17,2)","v":0},null,{"$f":"ROUND(H17*I17,2)","v":0},{"$f":"+J17+H17","v":0}]
[null,null,null,null,null,null,null,{"$f":"ROUND(F18*G18,2)","v":0},null,{"$f":"ROUND(H18*I18,2)","v":0},{"$f":"+J18+H18","v":0}]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,{"$f":"ROUND(F24*G24,2)","v":0},null,{"$f":"ROUND(H24*I24,2)","v":0},{"$f":"+J24+H24","v":0}]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,{"$f":"ROUND(F29*G29,2)","v":0},null,{"$f":"ROUND(H29*I29,2)","v":0},{"$f":"+J29+H29","v":0}]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,{"$f":"ROUND(F38*G38,2)","v":0},null,{"$f":"ROUND(H38*I38,2)","v":0},{"$f":"+J38+H38","v":0}]
[null,null,null,null,null,null,null,{"$f":"ROUND(F39*G39,2)","v":0},null,{"$f":"ROUND(H39*I39,2)","v":0},{"$f":"+J39+H39","v":0}]
[null,null,null,null,null,null,null,0,null,0,0]
[null,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,null,0,null,0,0]
[null,null,null,null,"CURRENT PERIOD EXPENDITURES:",{"$f":"SUM(F17:F42)","v":0},null,{"$f":"SUM(H17:H42)","v":0},null,{"$f":"SUM(J17:J42)","v":0},{"$f":"SUM(K17:K42)","v":0}]
[]
[null,null,"SECTION II.  ADJUSTMENTS:"]
[null,null,"First & Last Name","TCOLE PID #","Pay Period Ending Date","OLS OT Hours","OT Rate Per Hour","Overtime","Enter Fringe Rate","Fringe","Overtime Plus Fringe"]
[null,null,null,null,null,null,null,{"$f":"ROUND(F47*G47,2)","v":0},null,{"$f":"ROUND(H47*I47,2)","v":0},{"$f":"+J47+H47","v":0}]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,{"$f":"ROUND(F50*G50,2)","v":0},null,{"$f":"ROUND(H50*I50,2)","v":0},{"$f":"+J50+H50","v":0}]
[null,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,null,0,null,0,0]
[null,null,null,null,"TOTAL ADJUSTMENTS:",{"$f":"SUM(F47:F52)","v":0},null,{"$f":"SUM(H47:H52)","v":0},null,{"$f":"SUM(J47:J52)","v":0},{"$f":"SUM(K47:K52)","v":0}]
[]
[null,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,null,"TOTAL THIS PERIOD:",{"$f":"SUM(F53+F43)","v":0},null,{"$f":"SUM(H53+H43)","v":0},null,{"$f":"SUM(J53+J43)","v":0},{"$f":"SUM(K53+K43)","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,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,null,{"$f":"SUM(F59)","v":0},{"$f":"SUM(K59)","v":0}]
[null,null,"CUMULATIVE TOTALS FOR CURRENT FSR:",null,null,null,{"$f":"SUM(G63:G64)","v":0},{"$f":"SUM(H63:H64)","v":0}]

{"sheet":"enter Fringe$","index":1,"n_rows":59,"n_cols":11,"rows_kept":59,"cut":false,"hidden":false,"merged":[[55,2,55,5],[56,2,56,5],[57,2,57,5],[58,2,58,5],[58,9,58,11],[51,1,51,2],[2,2,3,11],[4,2,4,11],[5,2,5,11],[7,4,7,6],[8,4,8,6],[9,4,9,6],[47,5,50,10],[49,1,49,2],[50,1,50,2]]}
[]
[]
[null,null,"Office of the Governor"]
[]
[null,null,"Operation Lone Star (OLS)"]
[null,null,"PERSONNEL OVERTIME SUMMARY"]
[null,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,null,"    Personnel budget line."]
[null,null,"FSR REPORTING PERIOD:"]
[null,null,"GRANT NUMBER:",null,null,null,null,null,"Enter Fringe DOLLAR AMT"]
[null,null,"A.",null,"B.","C.","D.","E.","F.","G.","H."]
[null,null,"SECTION I.  CURRENT PERIOD EXPENDITURES:",null,null,null,null,"(C. x D.)","(G. / E.)",null,"(E. + G.)"]
[null,null,"First & Last Name","TCOLE PID #","Pay Period Ending Date","OLS OT Hours","OT Rate Per Hour","Overtime","Fringe Rate","Enter Fringe Dollars","Overtime Plus Fringe"]
[null,null,null,null,null,null,null,{"$f":"ROUND(F14*G14,2)","v":0},{"$f":"IF(H14=0,\"\",J14/H14)","v":""},null,{"$f":"ROUND(H14+J14,2)","v":0}]
[null,null,null,null,null,null,null,{"$f":"ROUND(F15*G15,2)","v":0},{"$f":"IF(H15=0,\"\",J15/H15)","v":""},null,{"$f":"ROUND(H15+J15,2)","v":0}]
[null,null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,null,{"$f":"ROUND(F34*G34,2)","v":0},{"$f":"IF(H34=0,\"\",J34/H34)","v":""},null,0]
[null,null,null,null,null,null,null,0,"",null,{"$f":"ROUND(H35+J35,2)","v":0}]
[null,null,"****Place Cursor Here to Insert Row.  Then Click Red Button.",null,null,null,null,0,"",null,0]
[null,null,null,null,"CURRENT PERIOD EXPENDITURES:",{"$f":"SUM(F14:F36)","v":0},null,{"$f":"SUM(H14:H36)","v":0},null,{"$f":"SUM(J14:J36)","v":0},{"$f":"SUM(K14:K36)","v":0}]
[]
[null,null,"SECTION II.  ADJUSTMENTS:"]
[null,null,"First & Last Name","TCOLE PID #","Pay Period Ending Date","OLS OT Hours","OT Rate Per Hour","Overtime","Fringe Rate","Enter Fringe Dollars","Overtime Plus Fringe"]
[null,null,null,null,null,null,null,{"$f":"ROUND(F41*G41,2)","v":0},{"$f":"IF(H41=0,\"\",J41/H41)","v":""},null,{"$f":"ROUND(H41+J41,2)","v":0}]
[null,null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,null,0,"",null,0]
[null,null,null,null,null,null,null,{"$f":"ROUND(F45*G45,2)","v":0},{"$f":"IF(H45=0,\"\",J45/H45)","v":""},null,{"$f":"ROUND(H45+J45,2)","v":0}]
[null,null,"****Place Cursor Here to Insert Row.  Then Click Red Button.",null,null,null,null,0,"",null,0]
[null,null,null,null,"TOTAL ADJUSTMENTS:",{"$f":"SUM(F41:F46)","v":0},null,{"$f":"SUM(H41:H46)","v":0},null,{"$f":"SUM(J41:J46)","v":0},{"$f":"SUM(K41:K46)","v":0}]
[]
[null,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,null,"TOTAL THIS PERIOD:",{"$f":"SUM(F47+F37)","v":0},null,{"$f":"SUM(H47+H37)","v":0},null,{"$f":"SUM(J47+J37)","v":0},{"$f":"SUM(K47+K37)","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,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,null,{"$f":"SUM(F53)","v":0},{"$f":"SUM(K53)","v":0}]
[null,null,"CUMULATIVE TOTALS FOR CURRENT FSR:",null,null,null,{"$f":"SUM(G57:G58)","v":0},{"$f":"SUM(H57:H58)","v":0}]

{"sheet":"OLS Augmentees","index":2,"n_rows":59,"n_cols":11,"rows_kept":59,"cut":false,"hidden":false,"merged":[[9,4,9,6],[2,2,3,11],[4,2,4,11],[5,2,5,11],[7,4,7,6],[8,4,8,6],[57,2,57,5],[58,2,58,5],[58,9,58,11],[47,5,50,10],[49,1,49,2],[50,1,50,2],[51,1,51,2],[55,2,55,5],[56,2,56,5]]}
[]
[]
[null,null,"Office of the Governor"]
[]
[null,null,"Operation Lone Star (OLS)"]
[null,null,"PERSONNEL SUMMARY - AUGMENTEES"]
[null,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,null,"    Personnel budget line."]
[null,null,"FSR REPORTING PERIOD:"]
[null,null,"GRANT NUMBER:",null,null,null,null,null,"Enter Fringe PERCENTAGE"]
[null,null,"A.",null,"B.","C.","D.","E.","F.","G.","H."]
[null,null,"SECTION I.  CURRENT PERIOD EXPENDITURES:",null,null,null,null,"(C. x D.)",null,"(E. x F.)","(E. + G.)"]
[null,null,"First & Last Name","TCOLE PID #","Pay Period Ending Date","OLS Hours","Rate Per Hour","Personnel Cost","Enter Fringe Rate","Fringe","Personnel Plus Fringe"]
[null,null,null,null,null,null,null,{"$f":"ROUND(F14*G14,2)","v":0},null,{"$f":"ROUND(H14*I14,2)","v":0},{"$f":"+J14+H14","v":0}]
[null,null,null,null,null,null,null,{"$f":"ROUND(F15*G15,2)","v":0},null,{"$f":"ROUND(H15*I15,2)","v":0},{"$f":"+J15+H15","v":0}]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,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,null,0,null,0,0]
[null,null,null,null,"CURRENT PERIOD EXPENDITURES:",{"$f":"SUM(F14:F36)","v":0},null,{"$f":"SUM(H14:H36)","v":0},null,{"$f":"SUM(J14:J36)","v":0},{"$f":"SUM(K14:K36)","v":0}]
[]
[null,null,"SECTION II.  ADJUSTMENTS:"]
[null,null,"First & Last Name","TCOLE PID #","Pay Period Ending Date","OLS Hours","Rate Per Hour","Personnel Cost","Enter Fringe Rate","Fringe","Personnel Plus Fringe"]
[null,null,null,null,null,null,null,{"$f":"ROUND(F41*G41,2)","v":0},null,{"$f":"ROUND(H41*I41,2)","v":0},{"$f":"+J41+H41","v":0}]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,0,null,0,0]
[null,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,null,0,null,0,0]
[null,null,null,null,"TOTAL ADJUSTMENTS:",{"$f":"SUM(F41:F46)","v":0},null,{"$f":"SUM(H41:H46)","v":0},null,{"$f":"SUM(J41:J46)","v":0},{"$f":"SUM(K41:K46)","v":0}]
[]
[null,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,null,"TOTAL THIS PERIOD:",{"$f":"SUM(F47+F37)","v":0},null,{"$f":"SUM(H47+H37)","v":0},null,{"$f":"SUM(J47+J37)","v":0},{"$f":"SUM(K47+K37)","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,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,null,{"$f":"SUM(F53)","v":0},{"$f":"SUM(K53)","v":0}]
[null,null,"CUMULATIVE TOTALS FOR CURRENT FSR:",null,null,null,{"$f":"SUM(G57:G58)","v":0},{"$f":"SUM(H57:H58)","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":[[49,1,49,2],[50,1,50,2],[48,1,48,2],[9,3,9,5],[46,4,49,9],[2,2,3,10],[4,2,4,10],[5,2,5,10],[7,3,7,5],[8,3,8,5],[54,2,54,4],[56,2,56,4],[57,2,57,4],[55,2,55,4],[57,8,57,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:","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}]