{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["12 Burden Hours Collection","12 Not Inc in Burden Hours","12 Est Prof Wage Rate","14 Annual Cost to Fed Gov Est"],"not_rendered":{"defined_names":92,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"12 Burden Hours Collection","index":0,"n_rows":40,"n_cols":11,"rows_kept":40}
["USDA"]
["RURAL UTILITIES SERVICE"]
["RURAL DECENTRALIZED WATER SYSTEMS"]
["INFORMATION COLLECTION BURDEN HOURS"]
["0572 - 0139"]
["May 2024"]
[]
["Estimated No. of Total Respondents (Applicants)",null,{"v":7,"d":"7 "},{"$nulls":6},"Estimated No. of Total Awards (Awardees)",6]
["Average hours per response",null,{"$f":"I10/G10","v":{"v":4.463703602246267,"d":"4.464"}},{"$nulls":6},"Number of responses per respondent",{"$f":"G10/C8","v":{"v":20.860000000000003,"d":"20.86"}}]
["Gray Columns have automatic formulas.  DO NOT input numbers in these columns.  ",{"$nulls":4},"TOTAL",{"$f":"SUM(G15:G40)","v":{"v":146.02,"d":"146"}},null,{"$f":"SUM(I15:I40)","v":{"v":651.79,"d":"652"}},null,{"$f":"SUM(K15:K40)","v":{"v":34962.9520176,"d":"$34,963"}}]
["(A) ","(B)","(C)  ","(D)","(E)  ","(F)","(G)","(H)","(I)","(J)","(K)"]
["Regulation Reference","Title","Form No. \n(If Any)","% of Respondents Line Item is Applicable To","Estimated # of Respondents","Reports Filed Annually ","Total Responses \n(E) x (F)  ","Estimated # of Hours Per Response ","Estimated Total Hours \n(G) x (H)","Prof. Wage Rate","Total Cost\n(I) x (J)"]
[null,"APPLICATION"]
[]
[null,"SAM Registration","SAM.gov",{"v":1,"d":"100%"},{"v":7,"d":"7 "},{"v":1,"d":"1 "},{"$f":"E15*F15","v":7},{"v":2,"d":"2.00"},{"$f":"IF((H15*G15)=\"\",\"\",(H15*G15))","v":14},{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"$f":"IF((J15*I15)=\"\",\"\",(J15*I15))","v":{"v":750.9801600000001,"d":"$751"}}]
["1776.2 and RD Inst. 1900-D","Identify Employee Relationship","Written",{"v":1,"d":"100%"},{"$f":"$C$8*D16","v":{"v":7,"d":"7 "}},{"v":1,"d":"1 "},{"$f":"E16*F16","v":7},0.25,{"$f":"IF((H16*G16)=\"\",\"\",(H16*G16))","v":{"v":1.75,"d":"2"}},{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"$f":"IF((J16*I16)=\"\",\"\",(J16*I16))","v":{"v":93.87252000000001,"d":"$94"}}]
[1776.5,"Organizational Documents-Evidence of Legal Existence and Authority","Written",{"v":1,"d":"100%"},{"v":7,"d":"7 "},{"v":1,"d":"1 "},7,0.25,{"v":1.75,"d":"2"},{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"v":93.87252000000001,"d":"$94"}]
[1776.5,"List of Directors and Officers","Written",{"v":1,"d":"100%"},{"v":7,"d":"7 "},{"v":1,"d":"1 "},7,0.25,{"v":1.75,"d":"2"},{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"v":93.87252000000001,"d":"$94"}]
[1776.5,"Evidence of Tax Exempt Status","Written",{"v":1,"d":"100%"},{"v":7,"d":"7 "},{"v":1,"d":"1 "},7,0.25,{"v":1.75,"d":"2"},{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"v":93.87252000000001,"d":"$94"}]
["1776.7 (b)","Work Plan (Project Proposal, Work Plan, and Budget Justification)","Written",{"v":1,"d":"100%"},{"v":7,"d":"7 "},{"v":1,"d":"1 "},7,{"v":60,"d":"60.00"},420,{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"v":22529.4048,"d":"$22,529"}]
["1776.7(c)","Statement of Experience","Written",{"v":1,"d":"100%"},{"v":7,"d":"7 "},{"v":1,"d":"1 "},7,{"v":4,"d":"4.00"},28,{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"v":1501.9603200000001,"d":"$1,502"}]
["1776.9 (d) (1)","Pro-forma Balance Sheet","Written",{"v":1,"d":"100%"},{"v":7,"d":"7 "},{"v":1,"d":"1 "},7,{"v":4,"d":"4.00"},28,{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"v":1501.9603200000001,"d":"$1,502"}]
["1776.7 (d) (2)","Prior year Audit / Financial Statement","Written",{"v":1,"d":"100%"},{"$f":"$C$8*D23","v":{"v":7,"d":"7 "}},{"v":1,"d":"1 "},{"$f":"E23*F23","v":7},0.25,{"v":1.75,"d":"2"},{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"v":93.87252000000001,"d":"$94"}]
["1776.7 (d) (3)","Pro-forma Income Statement and Cash Flow ","Written",{"v":1,"d":"100%"},{"v":7,"d":"7 "},{"v":1,"d":"1 "},7,{"v":4,"d":"4.00"},28,{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"v":1501.9603200000001,"d":"$1,502"}]
[{"$nulls":4},{"v":0,"d":"0 "},null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"v":0,"d":"$0"}]
[{"$nulls":4},{"$f":"D26*$C$8","v":{"v":0,"d":"0 "}},null,{"$f":"E26*F26","v":0},null,0,{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"v":0,"d":"$0"}]
[null,"AWARD CLOSING, SERVICING, AND REPORTING"]
[]
[null,"SAM Maintenance","SAM.gov",{"v":1,"d":"100%"},{"$f":"D29*$K$8","v":{"v":6,"d":"6 "}},{"v":1,"d":"1 "},6,{"v":1,"d":"1.00"},{"$f":"IF((H29*G29)=\"\",\"\",(H29*G29))","v":6},{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"$f":"IF((J29*I29)=\"\",\"\",(J29*I29))","v":{"v":321.84864000000005,"d":"$322"}}]
[null,"Request for Obligation of Funds ","1940-1",{"v":1,"d":"100%"},{"v":6,"d":"6 "},{"v":1,"d":"1 "},6,0.25,{"v":1.5,"d":"2"},{"v":53.64,"d":"$53.64"},{"v":80.46000000000001,"d":"$80"}]
["1776.2, 3019.26 and 3052","Annual Audit / Financial Statement","Written",{"v":1,"d":"100%"},{"$f":"D31*$K$8","v":{"v":6,"d":"6 "}},{"v":1,"d":"1 "},6,0.25,{"v":1.5,"d":"2"},{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"v":80.46216000000001,"d":"$80"}]
["1776.2 and 3019.51","Project Performance Report","Written"]
[null,"Initial",null,{"v":1,"d":"100%"},{"v":6,"d":"6 "},{"v":4,"d":"4 "},24,{"v":2,"d":"2.00"},48,{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"v":2574.7891200000004,"d":"$2,575"}]
[null,"Extension",null,{"v":1,"d":"100%"},{"v":6,"d":"6 "},{"v":4,"d":"4 "},24,{"v":2,"d":"2.00"},48,{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"v":2574.7891200000004,"d":"$2,575"}]
["1776.2 and 3019.25","Request written approval of workplan changes","Written",{"v":0.67,"d":"67%"},{"v":4.0200000000000005,"d":"4 "},{"v":1,"d":"1 "},{"v":4.0200000000000005,"d":"4"},{"v":2,"d":"2.00"},{"v":8.040000000000001,"d":"8"},{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"v":431.2771776000001,"d":"$431"}]
[1776.1,"Grant Agreement","Written",{"v":1,"d":"100%"},{"v":6,"d":"6 "},{"v":1,"d":"1 "},6,{"v":2,"d":"2.00"},12,{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"v":643.6972800000001,"d":"$644"}]
[{"$nulls":4},{"v":0,"d":"0 "},null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"v":0,"d":"$0"}]
[{"$nulls":4},{"v":0,"d":"0 "},null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"v":0,"d":"$0"}]
[{"$nulls":4},{"v":0,"d":"0 "},null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"v":0,"d":"$0"}]
[{"$nulls":4},{"v":0,"d":"0 "},null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"v":0,"d":"$0"}]

{"sheet":"12 Not Inc in Burden Hours","index":1,"n_rows":29,"n_cols":11,"rows_kept":29}
[{"$f":"'12 Burden Hours Collection'!A1","v":"USDA"}]
[{"$f":"'12 Burden Hours Collection'!A2","v":"RURAL UTILITIES SERVICE"}]
[{"$f":"'12 Burden Hours Collection'!A3","v":"RURAL DECENTRALIZED WATER SYSTEMS"}]
[{"$f":"'12 Burden Hours Collection'!A4","v":"INFORMATION COLLECTION BURDEN HOURS"}]
[{"$f":"'12 Burden Hours Collection'!A5","v":"0572 - 0139"}]
[{"$f":"'12 Burden Hours Collection'!A6","v":"May 2024"}]
[]
["Estimated No. of Total Respondents (Applicants)",null,{"$f":"'12 Burden Hours Collection'!C8","v":{"v":7,"d":"7 "}},{"$nulls":6},"Estimated No. of Total Awards (Awardees)",{"$f":"'12 Burden Hours Collection'!K8","v":6}]
["Average hours per response",null,{"$f":"I10/G10","v":{"v":0.7635441176470588,"d":"0.764"}},{"$nulls":6},"Number of responses per respondent",{"$f":"G10/C8","v":{"v":9.714285714285714,"d":"9.71"}}]
["Gray Columns have automatic formulas.  DO NOT input numbers in these columns.  ",{"$nulls":4},"TOTAL",{"$f":"SUM(G14:G20)","v":68},null,{"$f":"SUM(I14:I20)","v":{"v":51.921,"d":"52"}},null,{"$f":"SUM(K14:K20)","v":{"v":2785.11720624,"d":"$2,785"}}]
["(A) ","(B)","(C)  ","(D)","(E)  ","(F)","(G)","(H)","(I)","(J)","(K)"]
["Regulation Reference","Title","Form No. \n(If Any)","% of Respondents Line Item is Applicable To","Estimated # of Respondents","Reports Filed Annually ","Total Responses \n(E) x (F)  ","Estimated # of Hours Per Response ","Estimated Total Hours \n(G) x (H)","Prof. Wage Rate","Total Cost\n(I) x (J)"]
["APPLICATION"]
[]
[1776.2,"Equal Opportunity Agreement (Cleared under 0575-0201)","RD 400-1",{"v":1,"d":"100%"},{"$f":"D15*$C$8","v":7},1,{"$f":"E15*F15","v":7},0.167,{"$f":"IF((H15*G15)=\"\",\"\",(H15*G15))","v":{"v":1.169,"d":"1"}},{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"$f":"IF((J15*I15)=\"\",\"\",(J15*I15))","v":{"v":62.70684336000001,"d":"$63"}}]
[1776.2,"Assurance Agreement (Cleared under 0575-0201)","RD 400-4",{"v":1,"d":"100%"},{"$f":"D16*$C$8","v":7},1,7,0.25,{"v":1.75,"d":"2"},{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"v":93.87252000000001,"d":"$94"}]
["1776.2 and 3018.11","Disclosure of Lobbying Activities-(Cleared under 4040-0013)","SF-LLL",{"v":1,"d":"100%"},{"$f":"D17*$K$8","v":6},1,6,0.167,{"v":1.002,"d":"1"},{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"v":53.74872288,"d":"$54"}]
["1776.2 and 3019.22","Request for Advance or Reimbursement - (Cleared under 4040-0012)","SF 270"]
[null,"Initial",null,{"v":1,"d":"100%"},{"$f":"D19*$K$8","v":6},4,24,{"v":1,"d":"1.00"},24,{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"v":1287.3945600000002,"d":"$1,287"}]
[null,"Extension",null,{"v":1,"d":"100%"},{"$f":"D20*$K$8","v":6},4,24,{"v":1,"d":"1.00"},24,{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"v":1287.3945600000002,"d":"$1,287"}]
["1776.7 (a)(1)","Application for Federal Assistance (Cleared under 4040-0004)","SF-424"]
[null,"Initial",null,{"v":1,"d":"100%"},{"$f":"D22*$K$8","v":6},1,{"$f":"E22*F22","v":6},{"v":1,"d":"1.00"},{"$f":"IF((H22*G22)=\"\",\"\",(H22*G22))","v":6},{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"$f":"IF((J22*I22)=\"\",\"\",(J22*I22))","v":{"v":321.84864000000005,"d":"$322"}}]
[null,"Revised",null,{"v":0,"d":"0%"},0,1,0,{"v":1,"d":"1.00"},0,{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"v":0,"d":"$0"}]
["1776.9(a)(2)","Budget Information  -  (Cleared under 4040-0006)","SF-424A"]
[null,"Initial",null,{"v":1,"d":"100%"},6,1,6,{"v":3,"d":"3.00"},18,{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"v":965.54592,"d":"$966"}]
[null,"Revised",null,{"v":0,"d":"0%"},0,1,0,{"v":3,"d":"3.00"},0,{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"v":0,"d":"$0"}]
["1776.2 and 3019.52","Federal Financial  Report - (Cleared under 4040-0014)","SF-425"]
[null,"Initial",null,{"v":1,"d":"100%"},6,4,24,{"v":1.5,"d":"1.50"},36,{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"v":1931.09184,"d":"$1,931"}]
[null,"Extension",null,{"v":1,"d":"100%"},6,4,24,{"v":1.5,"d":"1.50"},36,{"$f":"'12 Est Prof Wage Rate'!$G$37","v":{"v":53.64144,"d":"$53.64"}},{"v":1931.09184,"d":"$1,931"}]

{"sheet":"12 Est Prof Wage Rate","index":2,"n_rows":37,"n_cols":7,"rows_kept":37}
[{"$f":"'12 Burden Hours Collection'!A1","v":"USDA"}]
[{"$f":"'12 Burden Hours Collection'!A2","v":"RURAL UTILITIES SERVICE"}]
[{"$f":"'12 Burden Hours Collection'!A3","v":"RURAL DECENTRALIZED WATER SYSTEMS"}]
[{"$f":"'12 Burden Hours Collection'!A4","v":"INFORMATION COLLECTION BURDEN HOURS"}]
[{"$f":"'12 Burden Hours Collection'!A5","v":"0572 - 0139"}]
[{"$f":"'12 Burden Hours Collection'!A6","v":"May 2024"}]
[]
["Instructions:"]
["1.  Use the U.S. Bureau of Labor Statistics Occupational Emplyment and Wage Statistics Link below to complete Columns A, B, C for the table below."]
["     a.  Click the link:","https://www.bls.gov/oes/tables.htm "]
["     b.  Under the latest Month Year (May 2022) click Occupation Profiles "]
["     c.  Use the Occupational Titles to choose which professions (A) need to be added to the table below.  You can more than one occupation or just one."]
["     d.  The code in front of each Occupational Title is the Occupation Code that goes in (B) for the table below."]
["     e.  When you click on each Occupational Titles, choose the Mean Hourly Wage to input in (C) for the table below.  "]
["2.  Use the U.S. Bureau of Labor Economic News Release, Employer Costs for Employee Compension to complete Column D for the table below.  "]
["     a.  Click the link:","https://www.bls.gov/news.release/ecec.toc.htm "]
["     b.  Choose \"The PDF verison of the news release\" link"]
["     c.  The latest (September 12, 2023) News Release for Employer Costs for Employee Compensation - Juner 2023 opens in separate tab."]
["     d.  On first page, second paragraph use the benefit costs % of: ",null,null,{"v":0.296,"d":"29.60%"}]
["3.  For each profession fill in the % for (F).  The total for the column should be 100%.  "]
["     a.  Note that if there is only one profession then (F) would be 100%. "]
[]
["Gray Columns have automatic formulas.  DO NOT input numbers in these columns.  "]
["(A)","(B)","(C)","(D)","(E)","(F)","(G)"]
["Profession","Bureau of Labor Occupation Code 1.d","Mean Wage 1.e","Benefits 2\n(C) * (2.d)","Total Hourly Wage\n(C ) + (D)","% Time Spent on Burden","Weighted Hourly Salary\n(E) * (F)"]
["Business and Financial Operations Occupations","13-0000",{"v":41.39,"d":"$41.39"},{"$f":"IF(C26=0,\"\",(C26*$D$19))","v":{"v":12.251439999999999,"d":"$12.25"}},{"$f":"IF(SUM(C26:D26)=0,\"\",SUM(C26:D26))","v":{"v":53.64144,"d":"$53.64"}},{"v":1,"d":"100%"},{"$f":"IF(E26=\"\",\"\",(E26*F26))","v":{"v":53.64144,"d":"$53.64"}}]
[{"$nulls":3},{"$f":"IF(C27=0,\"\",(C27*$D$19))","v":""},{"$f":"IF(SUM(C27:D27)=0,\"\",SUM(C27:D27))","v":""},null,{"$f":"IF(E27=\"\",\"\",(E27*F27))","v":""}]
[{"$nulls":3},{"$f":"IF(C28=0,\"\",(C28*$D$19))","v":""},{"$f":"IF(SUM(C28:D28)=0,\"\",SUM(C28:D28))","v":""},null,{"$f":"IF(E28=\"\",\"\",(E28*F28))","v":""}]
[{"$nulls":3},{"$f":"IF(C29=0,\"\",(C29*$D$19))","v":""},{"$f":"IF(SUM(C29:D29)=0,\"\",SUM(C29:D29))","v":""},null,{"$f":"IF(E29=\"\",\"\",(E29*F29))","v":""}]
{"$rows_empty":7}
["TOTAL",null,null,{"$f":"IF(C37=0,\"\",(C37*#REF!))","v":""},null,{"$f":"SUM(F26:F36)","v":{"v":1,"d":"100%"}},{"$f":"SUM(G26:G36)","v":{"v":53.64144,"d":"$53.64"}}]

{"sheet":"14 Annual Cost to Fed Gov Est","index":3,"n_rows":33,"n_cols":13,"rows_kept":33,"merged":[[25,0,25,6],[28,0,28,6],[31,0,31,6]]}
[{"$f":"'12 Burden Hours Collection'!A1","v":"USDA"}]
[{"$f":"'12 Burden Hours Collection'!A2","v":"RURAL UTILITIES SERVICE"}]
[{"$f":"'12 Burden Hours Collection'!A3","v":"RURAL DECENTRALIZED WATER SYSTEMS"}]
[{"$f":"'12 Burden Hours Collection'!A4","v":"INFORMATION COLLECTION BURDEN HOURS"}]
[{"$f":"'12 Burden Hours Collection'!A5","v":"0572 - 0139"}]
[{"$f":"'12 Burden Hours Collection'!A6","v":"May 2024"}]
[]
["OPM GS Pay Tables - Table 2023 DCB",null,"https://www.opm.gov/policy-data-oversight/pay-leave/salaries-wages/2024/general-schedule  "]
["OPM SES Schedules - Table 2023-ES",null,"Executive Senior Level (opm.gov)"]
["Benefit % (OMB Memo M-08 13)","https://www.whitehouse.gov/wp-content/uploads/legacy_drupal_files/omb/memoranda/2008/m08-13.pdf ",{"$nulls":8},{"v":0.3625,"d":"36.25%"}]
[]
["Gray & Blue Columns have automatic formulas.  DO NOT input numbers in these columns.",{"$nulls":5},"Total  ",{"$f":"H14+H17+H20+H23","v":{"v":24,"d":"24.00"}},{"$f":"I14+I17+I20+I23","v":{"v":2101.7925000000005,"d":"$2,101.79"}},null,{"$f":"K14+K17+K20+K23+K26+K29+K32","v":{"v":27323.30250000001,"d":"$27,323.30"}}]
["Staff \nPosition","GS Grade","GS Step","GS \nSalary","Hourly Rate Calc","Benefits Calc","Total Salary Rate Calc","Hours Required","Cost Subtotals","# of Responses","Total Costs"]
["Application",{"$nulls":6},{"$f":"SUM(H15:H16)","v":{"v":12,"d":"12.00"}},{"$f":"SUM(I15:I16)","v":{"v":1050.8962500000002,"d":"$1,051"}},7,{"$f":"J14*I14","v":{"v":7356.273750000002,"d":"$7,356.27"}}]
["Community Program Specialist",13,5,{"v":133692,"d":"$133,692"},{"$f":"(D15/52)/40","v":{"v":64.275,"d":"$64.28"}},{"$f":"E15*$K$10","v":{"v":23.2996875,"d":"$23.30"}},{"$f":"E15+F15","v":{"v":87.57468750000001,"d":"$87.57"}},{"v":12,"d":"12.00"},{"$f":"H15*G15","v":{"v":1050.8962500000002,"d":"$1,050.90"}}]
[{"$nulls":4},{"$f":"(D16/52)/40","v":{"v":0,"d":"$0.00"}},{"$f":"E16*$K$10","v":{"v":0,"d":"$0.00"}},{"$f":"E16+F16","v":{"v":0,"d":"$0.00"}},null,{"$f":"H16*G16","v":{"v":0,"d":"$0.00"}}]
["First Administrative Phase",{"$nulls":6},{"$f":"SUM(H18:H19)","v":{"v":6,"d":"6.00"}},{"$f":"SUM(I18:I19)","v":{"v":525.4481250000001,"d":"$525"}},7,{"$f":"J17*I17","v":{"v":3678.136875000001,"d":"$3,678.14"}}]
["Community Program Specialist",13,5,{"v":133692,"d":"$133,692"},{"$f":"(D18/52)/40","v":{"v":64.275,"d":"$64.28"}},{"$f":"E18*$K$10","v":{"v":23.2996875,"d":"$23.30"}},{"$f":"E18+F18","v":{"v":87.57468750000001,"d":"$87.57"}},{"v":6,"d":"6.00"},{"v":525.4481250000001,"d":"$525.45"}]
[{"$nulls":4},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
["Second Administrative Phase",{"$nulls":6},{"$f":"SUM(H21:H22)","v":{"v":3,"d":"3.00"}},{"$f":"SUM(I21:I22)","v":{"v":262.72406250000006,"d":"$263"}},6,{"$f":"J20*I20","v":{"v":1576.3443750000004,"d":"$1,576.34"}}]
["Community Program Specialist",13,5,{"v":133692,"d":"$133,692"},{"$f":"(D21/52)/40","v":{"v":64.275,"d":"$64.28"}},{"$f":"E21*$K$10","v":{"v":23.2996875,"d":"$23.30"}},{"$f":"E21+F21","v":{"v":87.57468750000001,"d":"$87.57"}},{"v":3,"d":"3.00"},{"v":262.72406250000006,"d":"$262.72"}]
[{"$nulls":4},{"$f":"(D22/52)/40","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
["Servicing per Quarter (initial)",{"$nulls":6},{"$f":"SUM(H24:H24)","v":{"v":3,"d":"3.00"}},{"$f":"SUM(I24:I24)","v":{"v":262.72406250000006,"d":"$263"}},24,{"$f":"J23*I23","v":{"v":6305.377500000001,"d":"$6,305.38"}}]
["Community Program Specialist",13,5,{"v":133692,"d":"$133,692"},{"$f":"(D24/52)/40","v":{"v":64.275,"d":"$64.28"}},{"$f":"E24*$K$10","v":{"v":23.2996875,"d":"$23.30"}},{"$f":"E24+F24","v":{"v":87.57468750000001,"d":"$87.57"}},{"v":3,"d":"3.00"},{"v":262.72406250000006,"d":"$262.72"}]
[]
["Servicing per Quarter (Extended)",{"$nulls":6},{"$f":"SUM(H27:H27)","v":{"v":3,"d":"3.00"}},{"$f":"SUM(I27:I27)","v":{"v":262.72406250000006,"d":"$263"}},16,{"$f":"J26*I26","v":{"v":4203.585000000001,"d":"$4,203.59"}},null,"4 qrts x 4 borrowers"]
["Community Program Specialist",13,5,{"v":133692,"d":"$133,692"},{"$f":"(D27/52)/40","v":{"v":64.275,"d":"$64.28"}},{"$f":"E27*$K$10","v":{"v":23.2996875,"d":"$23.30"}},{"$f":"E27+F27","v":{"v":87.57468750000001,"d":"$87.57"}},{"v":3,"d":"3.00"},{"$f":"H27*G27","v":{"v":262.72406250000006,"d":"$262.72"}}]
[]
["End of Grant period",{"$nulls":6},{"$f":"SUM(H30:H30)","v":{"v":6,"d":"6.00"}},{"$f":"SUM(I30:I30)","v":{"v":525.4481250000001,"d":"$525"}},6,{"$f":"J29*I29","v":{"v":3152.6887500000007,"d":"$3,152.69"}}]
["Community Program Specialist",13,5,{"v":133692,"d":"$133,692"},{"$f":"(D30/52)/40","v":{"v":64.275,"d":"$64.28"}},{"$f":"E30*$K$10","v":{"v":23.2996875,"d":"$23.30"}},{"$f":"E30+F30","v":{"v":87.57468750000001,"d":"$87.57"}},{"v":6,"d":"6.00"},{"$f":"H30*G30","v":{"v":525.4481250000001,"d":"$525.45"}}]
[]
["Closeout",{"$nulls":6},{"$f":"SUM(H33:H33)","v":{"v":2,"d":"2.00"}},{"$f":"SUM(I33:I33)","v":{"v":175.14937500000002,"d":"$175"}},6,{"$f":"J32*I32","v":{"v":1050.8962500000002,"d":"$1,050.90"}}]
["Community Program Specialist ",13,5,{"v":133692,"d":"$133,692"},{"$f":"(D33/52)/40","v":{"v":64.275,"d":"$64.28"}},{"$f":"E33*$K$10","v":{"v":23.2996875,"d":"$23.30"}},{"$f":"E33+F33","v":{"v":87.57468750000001,"d":"$87.57"}},{"v":2,"d":"2.00"},{"$f":"H33*G33","v":{"v":175.14937500000002,"d":"$175.15"}}]