{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Leap Year Template","Non-leap Year Template"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"Leap Year Template","index":0,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[[22,0,22,1],[22,2,22,12],[13,10,13,12],[17,2,17,3],[17,10,17,12],[20,0,20,1],[19,2,19,3],[9,10,9,12],[10,2,10,3],[12,2,12,3],[11,10,11,12],[19,10,19,12],[13,2,13,3],[20,10,20,12],[12,10,12,12],[10,10,10,12],[8,0,8,1],[7,0,7,1],[9,2,9,3],[8,2,8,3],[8,5,8,7],[8,8,8,9],[8,10,8,13],[0,6,3,13],[4,0,4,13],[5,0,5,13],[6,0,6,13],[11,2,11,3],[15,2,15,3],[15,10,15,12],[14,2,14,3],[14,10,14,12],[18,2,18,3],[18,10,18,12],[16,2,16,3],[16,10,16,12]]}
[null,null,"EMPLOYEE FUNDING PROFILE (EFP) ",null,null,null,"Please complete the form, obtain and attach any necessary Memo(s) of Commitment, and retain for entry into eUMB.  "]
[null,null,"University of Maryland, Baltimore"]
[]
[]
["The Employee Funding Profile (EFP) is to be used by the Position Owner1 to manage funding source information for an individual employee.  The Position Owner should establish and maintain one EFP for each employee for which they have fiscal authority.  The EFP is a tool by which the Position Owner can manage funding profiles for the department’s employees.  "]
["The EFP shows ALL funding sources that constitute the employee’s salary (and possibly fringes).  When the Position Owner does not have direct fiscal authority over an account, a Memo of Commitment will need to be established between the Position Owner and the Account Owner for the appropriate portion of the employee’s overall funding profile.  Since an employee’s overall funding may come from several sources, it is possible that an employee may have several Memos of Commitment.  The EFP is used to capture the account codes, funding begin dates, funding end dates, and distribution percentages that have been agreed to through the use of the Memo(s) of Commitment.  All Memo(s) of Commitment should be attached to the EFP for the Position Owner’s records."]
["The sum of all distribution percentages for an employee must equal 100% for the duration of the fiscal year.   Only one 'Begin Date' may be used for each record. For instance, several funding sources may be listed for an employee using Rcd #1, but all Rcd #1s must have the same 'Begin Date'."]
["Employee ID:",null,"Employee Name:",null,"Department Code","Department Name",null,null,"Effective Date",null,"Fiscal Year"]
["999999",null,"Template Tester",null,"01000000","Testing Department",null,null,"2019-07-01",null,2020]
["Account Status","Combo Code","Combo Code Name",null,"Annual Paid Salary","Begin Date:","End Date:","Days:","(%):","Bi-Weekly Amount:","Annual Amount:",null,null,"Memo Needed?"]
["New","5xxxxxxxxx","State",null,100000,{"$f":"I9","v":"2019-07-01"},"2020-06-30",{"$f":"(G11-F11)+1","v":366},0.5,{"$f":"(K11/H11)*14","v":1912.5683060109291},{"$f":"(E11*I11)*(H11/366)","v":50000}]
["New","5xxxxxxxxx","Revolving",null,100000,{"$f":"$F$11","v":"2019-07-01"},"2020-06-30",{"$f":"(G12-F12)+1","v":366},0.25,{"$f":"(K12/H12)*14","v":956.28415300546453},{"$f":"(E12*I12)*(H12/366)","v":25000}]
["New","5xxxxxxxxx","Grant",null,100000,{"$f":"$F$11","v":"2019-07-01"},"2020-06-30",{"$f":"(G13-F13)+1","v":366},0.25,{"$f":"(K13/H13)*14","v":956.28415300546453},{"$f":"(E13*I13)*(H13/366)","v":25000}]
[]
[]
[]
[]
[]
[]
[]
["TOTALS",null,null,null,null,null,null,null,{"$f":"SUM(I11:I20)","v":1},{"$f":"SUM(J11:J20)","v":3825.1366120218581},{"$f":"SUM(K11:M20)","v":100000}]
[]
["Comments:",null,"Sample for Leap Year use"]
["1Position Owner = Department representative who has fiscal authority for the department to which the employee is assigned."]
["2Account Owner = Department representative who has fiscal authority over the account."]

{"sheet":"Non-leap Year Template","index":1,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[[16,2,16,3],[16,10,16,12],[13,2,13,3],[13,10,13,12],[17,2,17,3],[17,10,17,12],[15,2,15,3],[15,10,15,12],[0,6,3,13],[4,0,4,13],[5,0,5,13],[6,0,6,13],[11,2,11,3],[10,10,10,12],[19,10,19,12],[8,0,8,1],[20,10,20,12],[22,0,22,1],[7,0,7,1],[9,2,9,3],[20,0,20,1],[19,2,19,3],[9,10,9,12],[10,2,10,3],[14,2,14,3],[14,10,14,12],[22,2,22,12],[12,10,12,12],[18,2,18,3],[18,10,18,12],[12,2,12,3],[11,10,11,12],[8,2,8,3],[8,5,8,7],[8,8,8,9],[8,10,8,13]]}
[null,null,"EMPLOYEE FUNDING PROFILE (EFP) ",null,null,null,"Please complete the form, obtain and attach any necessary Memo(s) of Commitment, and retain for entry into eUMB.  "]
[null,null,"University of Maryland, Baltimore"]
[]
[]
["The Employee Funding Profile (EFP) is to be used by the Position Owner1 to manage funding source information for an individual employee.  The Position Owner should establish and maintain one EFP for each employee for which they have fiscal authority.  The EFP is a tool by which the Position Owner can manage funding profiles for the department’s employees.  "]
["The EFP shows ALL funding sources that constitute the employee’s salary (and possibly fringes).  When the Position Owner does not have direct fiscal authority over an account, a Memo of Commitment will need to be established between the Position Owner and the Account Owner for the appropriate portion of the employee’s overall funding profile.  Since an employee’s overall funding may come from several sources, it is possible that an employee may have several Memos of Commitment.  The EFP is used to capture the account codes, funding begin dates, funding end dates, and distribution percentages that have been agreed to through the use of the Memo(s) of Commitment.  All Memo(s) of Commitment should be attached to the EFP for the Position Owner’s records."]
["The sum of all distribution percentages for an employee must equal 100% for the duration of the fiscal year.   Only one 'Begin Date' may be used for each record. For instance, several funding sources may be listed for an employee using Rcd #1, but all Rcd #1s must have the same 'Begin Date'."]
["Employee ID:",null,"Employee Name:",null,"Department Code","Department Name",null,null,"Effective Date",null,"Fiscal Year"]
["999999",null,"Template Tester",null,"01000000","Testing Department",null,null,"2019-07-01",null,2020]
["Account Status","Combo Code","Combo Code Name",null,"Annual Paid Salary","Begin Date:","End Date:","Days:","(%):","Bi-Weekly Amount:","Annual Amount:",null,null,"Memo Needed?"]
["New","5xxxxxxxxx","State",null,100000,{"$f":"I9","v":"2019-07-01"},"2020-06-30",365,0.5,{"$f":"(K11/H11)*14","v":1917.8082191780823},{"$f":"(E11*I11)*(H11/365)","v":50000}]
["New","5xxxxxxxxx","Revolving",null,{"$f":"$E$11","v":100000},{"$f":"$F$11","v":"2019-07-01"},"2020-06-30",365,0.25,{"$f":"(K12/H12)*14","v":958.90410958904113},{"$f":"(E12*I12)*(H12/365)","v":25000}]
["New","5xxxxxxxxx","Grant",null,{"$f":"$E$11","v":100000},{"$f":"$F$11","v":"2019-07-01"},"2020-06-30",365,0.25,{"$f":"(K13/H13)*14","v":958.90410958904113},{"$f":"(E13*I13)*(H13/365)","v":25000}]
[]
[]
[]
[]
[]
[]
[]
["TOTALS",null,null,null,null,null,null,null,{"$f":"SUM(I11:I20)","v":1},{"$f":"SUM(J11:J20)","v":3835.6164383561645},{"$f":"SUM(K11:M20)","v":100000}]
[]
["Comments:",null,"Sample for Non-leap year use"]
["1Position Owner = Department representative who has fiscal authority for the department to which the employee is assigned."]
["2Account Owner = Department representative who has fiscal authority over the account."]