{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["FFY 17 Budget Summary","FFY 17 Annual Budget Detail","Fringe Double Check","Indirect Double Check"],"not_rendered":{"charts":0,"images":0,"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":"FFY 17 Budget Summary","index":0,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,3],[22,0,22,3],[2,0,2,3],[3,0,3,3],[4,0,4,3],[5,0,5,3],[6,0,6,3]]}
[]
[]
["COMBINED BUDGET SUMMARY"]
["Official Name of Applying Agency"]
["Agreement Number: TBD"]
["October 1, 2016 through September 30, 2017"]
["(FFY 2017)"]
[]
[]
["Budget Line Categories","State Share           (Not Reimbursable)","Federal Share (Reimbursable)","Total Program Costs"]
["Personnel Salaries",{"$f":"'FFY 17 Annual Budget Detail'!J60","v":0},{"$f":"'FFY 17 Annual Budget Detail'!K60","v":0},{"$f":"'FFY 17 Annual Budget Detail'!L60","v":0}]
["Fringe Benefits",{"$f":"'FFY 17 Annual Budget Detail'!J111","v":0},{"$f":"'FFY 17 Annual Budget Detail'!K111","v":0},{"$f":"'FFY 17 Annual Budget Detail'!L111","v":0}]
["Operating Expenses",{"$f":"'FFY 17 Annual Budget Detail'!J149","v":0},{"$f":"'FFY 17 Annual Budget Detail'!K149","v":0},{"$f":"'FFY 17 Annual Budget Detail'!L149","v":0}]
["Equipment  ",{"$f":"'FFY 17 Annual Budget Detail'!J182","v":0},{"$f":"'FFY 17 Annual Budget Detail'!K182","v":0},{"$f":"'FFY 17 Annual Budget Detail'!L182","v":0}]
["Travel and Per Diem",{"$f":"'FFY 17 Annual Budget Detail'!J216","v":0},{"$f":"'FFY 17 Annual Budget Detail'!K216","v":0},{"$f":"'FFY 17 Annual Budget Detail'!L216","v":0}]
["Subcontractors",{"$f":"'FFY 17 Annual Budget Detail'!J275","v":0},{"$f":"'FFY 17 Annual Budget Detail'!K275","v":0},{"$f":"'FFY 17 Annual Budget Detail'!L275","v":0}]
["Other Costs",{"$f":"'FFY 17 Annual Budget Detail'!J312","v":0},{"$f":"'FFY 17 Annual Budget Detail'!K312","v":0},{"$f":"'FFY 17 Annual Budget Detail'!L312","v":0}]
["Indirect Costs",{"$f":"'FFY 17 Annual Budget Detail'!J329","v":0},{"$f":"'FFY 17 Annual Budget Detail'!K329","v":0},{"$f":"'FFY 17 Annual Budget Detail'!L329","v":0}]
["TOTALS",{"$f":"'FFY 17 Annual Budget Detail'!J332","v":0},{"$f":"'FFY 17 Annual Budget Detail'!K332","v":0},{"$f":"'FFY 17 Annual Budget Detail'!L332","v":0}]
[]
[]
[]
["Note: This Budget Summary worksheet will be automatically populated by data entered from the Annual Budget Detail worksheet. Please check to ensure that all data transfers properly and that all calculations are correct.   Total Federal Share Budget must be 77% (or less) of total State Share Budget as reflected below."]
[]
["Percent of Federal Share to State Share:",null,{"$f":"IF(B19=0,0,C19/B19)","v":0}]

{"sheet":"FFY 17 Annual Budget Detail","index":1,"n_rows":368,"n_cols":12,"rows_kept":368,"cut":false,"hidden":false,"merged":[[255,1,255,8],[256,1,256,8],[257,1,257,8],[246,1,246,8],[247,1,247,8],[248,1,248,8],[249,1,249,8],[250,1,250,8],[251,1,251,8],[252,1,252,8],[253,1,253,8],[254,1,254,8],[237,1,237,8],[238,1,238,8],[239,1,239,8],[240,1,240,8],[241,1,241,8],[242,1,242,8],[243,1,243,8],[244,1,244,8],[245,1,245,8],[228,1,228,8],[229,1,229,8],[230,1,230,8],[231,1,231,8],[232,1,232,8],[233,1,233,8],[234,1,234,8],[235,1,235,8],[236,1,236,8],[192,1,192,7],[193,1,193,7],[194,1,194,7],[195,1,195,7],[196,1,196,7],[197,1,197,7],[150,1,150,7],[133,1,133,7],[134,1,134,7],[135,1,135,7],[136,1,136,7],[154,1,154,6],[157,1,157,7],[142,1,142,7],[143,1,143,7],[140,1,140,7],[141,1,141,7],[138,1,138,7],[139,1,139,7],[173,1,173,7],[174,1,174,7],[175,1,175,7],[161,1,161,7],[162,1,162,7],[96,1,96,11],[97,1,97,11],[190,1,190,7],[191,1,191,7],[126,1,126,7],[127,1,127,7],[163,1,163,7],[128,1,128,7],[129,1,129,7],[120,1,120,7],[121,1,121,7],[122,1,122,7],[87,1,87,11],[88,1,88,11],[89,1,89,11],[90,1,90,11],[91,1,91,11],[92,1,92,11],[93,1,93,11],[94,1,94,11],[95,1,95,11],[78,1,78,11],[79,1,79,11],[80,1,80,11],[81,1,81,11],[82,1,82,11],[83,1,83,11],[84,1,84,11],[85,1,85,11],[86,1,86,11],[46,4,46,6],[47,4,47,6],[48,4,48,6],[53,1,53,3],[54,1,54,3],[53,4,53,6],[54,4,54,6],[98,1,98,11],[99,1,99,11],[63,1,63,11],[64,1,64,11],[65,1,65,11],[66,1,66,11],[67,1,67,11],[68,1,68,11],[69,1,69,11],[70,1,70,11],[71,1,71,11],[72,1,72,11],[73,1,73,11],[74,1,74,11],[75,1,75,11],[76,1,76,11],[77,1,77,11],[322,1,322,2],[219,1,219,11],[144,1,144,7],[145,1,145,7],[153,1,153,6],[178,1,178,7],[170,1,170,7],[171,1,171,7],[172,1,172,7],[176,1,176,7],[177,1,177,7],[169,1,169,7],[164,1,164,7],[165,1,165,7],[166,1,166,7],[212,1,212,7],[188,1,188,7],[189,1,189,7],[209,1,209,7],[210,1,210,7],[211,1,211,7],[158,1,158,7],[159,1,159,7],[160,1,160,7],[11,1,11,5],[12,1,12,5],[13,1,13,5],[14,1,14,5],[62,1,62,11],[274,1,274,8],[110,1,110,8],[148,1,148,8],[181,1,181,8],[215,1,215,8],[114,1,114,6],[115,1,115,6],[118,1,118,7],[119,1,119,7],[57,0,57,11],[105,1,105,5],[123,1,123,7],[124,1,124,7],[137,1,137,7],[264,1,264,8],[265,1,265,8],[266,1,266,8],[267,1,267,8],[130,1,130,7],[331,1,331,8],[311,1,311,8],[328,1,328,8],[277,1,277,6],[278,1,278,6],[281,1,281,7],[286,1,286,7],[287,1,287,7],[288,1,288,7],[289,1,289,7],[290,1,290,7],[282,1,282,7],[283,1,283,7],[284,1,284,7],[285,1,285,7],[304,1,304,7],[305,1,305,7],[306,1,306,7],[307,1,307,7],[308,1,308,7],[291,1,291,7],[292,1,292,7],[293,1,293,7],[296,1,296,7],[221,1,221,8],[258,1,258,8],[259,1,259,8],[260,1,260,8],[261,1,261,8],[262,1,262,8],[263,1,263,8],[198,1,198,7],[199,1,199,7],[200,1,200,7],[206,1,206,7],[207,1,207,7],[208,1,208,7],[201,1,201,7],[202,1,202,7],[203,1,203,7],[204,1,204,7],[205,1,205,7],[222,1,222,8],[223,1,223,8],[224,1,224,8],[225,1,225,8],[226,1,226,8],[227,1,227,8],[20,4,20,6],[49,1,49,3],[50,1,50,3],[49,4,49,6],[18,1,18,3],[16,1,16,3],[16,4,16,6],[36,1,36,3],[35,4,35,6],[19,4,19,6],[20,1,20,3],[17,1,17,3],[17,4,17,6],[19,1,19,3],[35,1,35,3],[18,4,18,6],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[28,1,28,3],[29,1,29,3],[30,1,30,3],[36,4,36,6],[107,1,107,8],[108,1,108,8],[37,1,37,3],[38,1,38,3],[39,1,39,3],[40,1,40,3],[41,1,41,3],[42,1,42,3],[43,1,43,3],[44,1,44,3],[45,1,45,3],[46,1,46,3],[47,1,47,3],[48,1,48,3],[37,4,37,6],[38,4,38,6],[39,4,39,6],[40,4,40,6],[41,4,41,6],[42,4,42,6],[43,4,43,6],[44,4,44,6],[45,4,45,6],[297,1,297,7],[298,1,298,7],[299,1,299,7],[300,1,300,7],[301,1,301,7],[302,1,302,7],[303,1,303,7],[268,1,268,8],[271,1,271,8],[269,1,269,8],[270,1,270,8],[0,0,0,11],[1,0,1,11],[2,0,2,11],[3,0,3,11],[4,0,4,11],[5,0,5,11],[7,0,7,11],[185,1,185,5],[187,1,187,7],[101,1,101,11],[50,4,50,6],[56,1,56,3],[51,1,51,3],[55,1,55,3],[55,4,55,6],[51,4,51,6],[59,1,59,8],[52,4,52,6],[52,1,52,3],[56,4,56,6],[100,1,100,11],[125,1,125,7],[26,1,26,3],[27,1,27,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,1,34,3],[30,4,30,6],[31,4,31,6],[32,4,32,6],[33,4,33,6],[34,4,34,6],[21,4,21,6],[22,4,22,6],[23,4,23,6],[24,4,24,6],[25,4,25,6],[26,4,26,6],[27,4,27,6],[28,4,28,6],[29,4,29,6]]}
[]
["Combined Annual Budget Detail"]
["Official Name of Applying Agency"]
["Agreement Number: TBD"]
["October 1, 2016 through September 30, 2017"]
["(FFY 2017)"]
[]
["Note: This budget represents both the State Share costs (not reimbursable) and Federal Share costs (reimbursable by USDA).  Both State Share costs and Federal Share costs are to be used to conduct allowable CalFresh outreach activities. Budgetary dollars designated as State Share must be from non-Federal sources, as defined by the USDA Guidance, to be used to conduct allowable CalFresh outreach activities. Data entered on this tab will automatically populate the Combined Budget Summary worksheet, which shows the nine-line-item budget to be used for invoicing. Please double-check that all data are accurate and transferred accurately and completely."]
[]
[null,"PERSONNEL SALARIES: (Add as many lines as necessary to include all outreach staff, actual or proposed)"]
[]
[null,"Percent of Salary Paid from State Share:",null,null,null,null,0]
[null,"Total FTE for All Staff Listed:",null,null,null,null,0]
[null,"Organization's Total FTEs for Proration:",null,null,null,null,0]
[null,"Percent FTE for Proration:",null,null,null,null,{"$f":"IF(G14=0,0,G13/G14)","v":0}]
[]
[null,"Name",null,null,"Position Title",null,null,"Annual Salary","Total FTE                                  (as a decimal) ","State Share","Federal Share","Total Dollars     "]
["1."," ",null,null," ",null,null,0,0,{"$f":"ROUND($G$12*(H18*I18),0)","v":0},{"$f":"ROUND((H18*I18)-J18,0)","v":0},{"$f":"J18+K18","v":0}]
["2."," ",null,null," ",null,null,0,0,{"$f":"ROUND($G$12*(H19*I19),0)","v":0},0,{"$f":"J19+K19","v":0}]
["3.",null,null,null,null,null,null,0,0,0,0,0]
["4.",null,null,null,null,null,null,0,0,{"$f":"ROUND($G$12*(H21*I21),0)","v":0},{"$f":"ROUND((H21*I21)-J21,0)","v":0},{"$f":"J21+K21","v":0}]
["5.",null,null,null,null,null,null,0,0,0,0,0]
["6.",null,null,null,null,null,null,0,0,0,0,0]
["7.",null,null,null,null,null,null,0,0,0,0,0]
["8.",null,null,null,null,null,null,0,0,0,0,0]
["9.",null,null,null,null,null,null,0,0,0,0,0]
["10.",null,null,null,null,null,null,0,0,0,0,0]
["11.",null,null,null,null,null,null,0,0,0,0,0]
["12.",null,null,null,null,null,null,0,0,0,0,0]
["13.",null,null,null,null,null,null,0,0,0,0,0]
["14.",null,null,null,null,null,null,0,0,0,0,0]
["15.",null,null,null,null,null,null,0,0,0,0,0]
["16.",null,null,null,null,null,null,0,0,0,0,0]
["17.",null,null,null,null,null,null,0,0,0,0,0]
["18.",null,null,null,null,null,null,0,0,0,0,0]
["19.",null,null,null,null,null,null,0,0,0,0,0]
["20.",null,null,null,null,null,null,0,0,0,0,0]
["21.",null,null,null,null,null,null,0,0,0,0,0]
["22.",null,null,null,null,null,null,0,0,0,0,0]
["23.",null,null,null,null,null,null,0,0,0,0,0]
["24.",null,null,null,null,null,null,0,0,0,0,0]
["25.",null,null,null,null,null,null,0,0,0,0,0]
["26.",null,null,null,null,null,null,0,0,0,0,0]
["27.",null,null,null,null,null,null,0,0,0,0,0]
["28.",null,null,null,null,null,null,0,0,0,0,0]
["29.",null,null,null,null,null,null,0,0,0,0,0]
["30.",null,null,null,null,null,null,0,0,0,0,0]
["31.",null,null,null,null,null,null,0,0,0,0,0]
["32.",null,null,null,null,null,null,0,0,0,0,0]
["33.",null,null,null,null,null,null,0,0,0,0,0]
["34.",null,null,null,null,null,null,0,0,0,0,0]
["35.",null,null,null,null,null,null,0,0,0,0,0]
["36.",null,null,null,null,null,null,0,0,0,0,0]
["37.",null,null,null,null,null,null,0,0,0,0,0]
["38.",null,null,null,null,null,null,0,0,0,0,0]
["39.",null,null,null,null,null,null,0,0,0,0,0]
["40.",null,null,null,null,null,null,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,"State Share","Federal Share","Total Dollars     "]
[null,"TOTAL PERSONNEL SALARIES",null,null,null,null,null,null,null,{"$f":"SUM(J18:J57)","v":0},{"$f":"SUM(K18:K57)","v":0},{"$f":"SUM(L18:L57)","v":0}]
[]
[null,"POSITION DESCRIPTIONS for each position/staff person listed above"]
["1."]
["2."]
["3."]
["4."]
["5."]
["6."]
["7."]
["8."]
["9."]
["10."]
["11."]
["12."]
["13."]
["14."]
["15."]
["16."]
["17."]
["18."]
["19."]
["20."]
["21."]
["22."]
["23."]
["24."]
["25."]
["26."]
["27."]
["28."]
["29."]
["30."]
["31."]
["32."]
["33."]
["34."]
["35."]
["36."]
["37."]
["38."]
["39."]
["40."]
[]
[null,"FRINGE BENEFITS:"]
[]
[null,"Benefits Rate (percent of salary):",null,null,null,null,0]
[]
[null,"Double-Check the correct percent calculation in the \"Fringe Double Check\" tab."]
[null,"Fringe Benefit Rate must be adjusted to the corrected percent."]
[null,null,null,null,null,null,null,null,null,"State Share","Federal Share","Total Dollars     "]
[null,"FRINGE BENEFITS",null,null,null,null,null,null,null,{"$f":"ROUND($G$106*J60,0)","v":0},{"$f":"ROUND($G$106*K60,0)","v":0},{"$f":"ROUND($G$106*L60,0)","v":0}]
[]
[null,"OPERATING EXPENSES: (add as many lines as necessary)"]
[]
[null,"Percent of Operation Expenses Paid from State Share:",null,null,null,null,null,0]
[null,"Proration Percentage (as calculated in Personnel section):",null,null,null,null,null,{"$f":"G15","v":0}]
[]
[null,"FIXED COSTS:"]
[null,"Description",null,null,null,null,null,null,"Annual Cost","State Share","Federal Share","Total Dollars     "]
["1.",null,null,null,null,null,null,null,0,{"$f":"ROUND($H$115*I120,0)","v":0},{"$f":"ROUND(I120-J120,0)","v":0},{"$f":"J120+K120","v":0}]
["2.",null,null,null,null,null,null,null,0,0,0,{"$f":"J121+K121","v":0}]
["3.",null,null,null,null,null,null,null,0,0,0,0]
["4.",null,null,null,null,null,null,null,0,0,0,0]
["5.",null,null,null,null,null,null,null,0,0,0,0]
["6.",null,null,null,null,null,null,null,0,0,0,0]
["7.",null,null,null,null,null,null,null,0,0,0,0]
["8.",null,null,null,null,null,null,null,0,0,0,0]
["9.",null,null,null,null,null,null,null,0,0,0,0]
["10.",null,null,null,null,null,null,null,0,0,0,0]
["11.",null,null,null,null,null,null,null,0,0,0,0]
["12.",null,null,null,null,null,null,null,0,0,0,{"$f":"J131+K131","v":0}]
[]
[null,"PRORATED COSTS:"]
[null,"Description",null,null,null,null,null,null,"Annual Cost","State Share","Federal Share","Total Dollars     "]
["1.",null,null,null,null,null,null,null,0,{"$f":"ROUND($H$115*$H$116*I135,0)","v":0},{"$f":"ROUND((I135*$H$116)-J135,0)","v":0},{"$f":"J135+K135","v":0}]
["2.",null,null,null,null,null,null,null,0,0,0,{"$f":"J136+K136","v":0}]
["3.",null,null,null,null,null,null,null,0,0,0,0]
["4.",null,null,null,null,null,null,null,0,0,0,0]
["5.",null,null,null,null,null,null,null,0,0,0,0]
["6.",null,null,null,null,null,null,null,0,0,0,0]
["7.",null,null,null,null,null,null,null,0,0,0,0]
["8.",null,null,null,null,null,null,null,0,0,0,0]
["9.",null,null,null,null,null,null,null,0,0,0,0]
["10.",null,null,null,null,null,null,null,0,0,0,0]
["11.",null,null,null,null,null,null,null,0,0,0,0]
["12.",null,null,null,null,null,null,null,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,"State Share","Federal Share","Total Dollars     "]
[null,"OPERATING EXPENSES",null,null,null,null,null,null,null,{"$f":"SUM(J135:J146,J120:J131)","v":0},{"$f":"SUM(K135:K146,K120:K131)","v":0},{"$f":"SUM(L135:L146,L120:L131)","v":0}]
[]
[null,"EQUIPMENT: (add as many lines as necessary)"]
[null,"Note:  Equipment purchased with any portion of outreach funds will become property of the State of California."]
[]
[null,"Percent of Equipment Purchases Paid from State Share:",null,null,null,null,null,0]
[null,"Proration Percentage (as calculated in Personnel section):",null,null,null,null,null,{"$f":"G15","v":0}]
[]
[null,"FIXED COSTS:"]
[null,"Description",null,null,null,null,null,null,"Estimated Cost","State Share","Federal Share","Total Dollars     "]
["1.",null,null,null,null,null,null,null,0,{"$f":"ROUND($H$154*I159,0)","v":0},{"$f":"ROUND(I159-J159,0)","v":0},{"$f":"J159+K159","v":0}]
["2.",null,null,null,null,null,null,null,0,{"$f":"ROUND($H$154*I160,0)","v":0},0,{"$f":"J160+K160","v":0}]
["3.",null,null,null,null,null,null,null,0,{"$f":"ROUND($H$154*I161,0)","v":0},0,0]
["4.",null,null,null,null,null,null,null,0,{"$f":"ROUND($H$154*I162,0)","v":0},{"$f":"ROUND(I162-J162,0)","v":0},{"$f":"J162+K162","v":0}]
["5.",null,null,null,null,null,null,null,0,0,0,0]
["6.",null,null,null,null,null,null,null,0,0,0,0]
["7.",null,null,null,null,null,null,null,0,0,0,0]
["8.",null,null,null,null,null,null,null,0,{"$f":"ROUND($H$154*I166,0)","v":0},0,0]
["9.",null,null,null,null,null,null,null,0,{"$f":"ROUND($H$154*I167,0)","v":0},0,0]
[]
[null,"PRORATED COSTS:"]
[null,"Description",null,null,null,null,null,null,"Estimated Cost","State Share","Federal Share","Total Dollars     "]
["1.",null,null,null,null,null,null,null,0,{"$f":"ROUND($H$154*$H$155*I171,0)","v":0},{"$f":"ROUND((I171*$H$155)-J171,0)","v":0},{"$f":"J171+K171","v":0}]
["2.",null,null,null,null,null,null,null,0,{"$f":"ROUND($H$154*$H$155*I172,0)","v":0},{"$f":"ROUND((I172*$H$155)-J172,0)","v":0},{"$f":"J172+K172","v":0}]
["3.",null,null,null,null,null,null,null,0,{"$f":"ROUND($H$154*$H$155*I173,0)","v":0},{"$f":"ROUND((I173*$H$155)-J173,0)","v":0},0]
["4.",null,null,null,null,null,null,null,0,{"$f":"ROUND($H$154*$H$155*I174,0)","v":0},{"$f":"ROUND((I174*$H$155)-J174,0)","v":0},{"$f":"J174+K174","v":0}]
["5.",null,null,null,null,null,null,null,0,0,0,0]
["6.",null,null,null,null,null,null,null,0,0,0,0]
["7.",null,null,null,null,null,null,null,0,0,0,0]
["8.",null,null,null,null,null,null,null,0,{"$f":"ROUND($H$154*$H$155*I178,0)","v":0},{"$f":"ROUND((I178*$H$155)-J178,0)","v":0},0]
["9.",null,null,null,null,null,null,null,0,{"$f":"ROUND($H$154*$H$155*I179,0)","v":0},{"$f":"ROUND((I179*$H$155)-J179,0)","v":0},0]
[]
[null,null,null,null,null,null,null,null,null,"State Share","Federal Share","Total Dollars     "]
[null,"EQUIPMENT",null,null,null,null,null,null,null,{"$f":"SUM(J171:J179,J159:J167)","v":0},{"$f":"SUM(K171:K179,K159:K167)","v":0},0]
[]
[null,"TRAVEL AND PER DIEM: (add as many lines as necessary)"]
[]
[null,"Percent of Travel Paid From State Share:",null,null,null,null,0]
[]
[null,"Description",null,null,null,null,null,null,"Estimated Cost","State Share","Federal Share","Total Dollars     "]
["1.",null,null,null,null,null,null,null,0,{"$f":"ROUND($G$186*I189,0)","v":0},{"$f":"ROUND(I189-J189,0)","v":0},{"$f":"J189+K189","v":0}]
["2.",null,null,null,null,null,null,null,0,{"$f":"ROUND($G$186*I190,0)","v":0},0,{"$f":"J190+K190","v":0}]
["3.",null,null,null,null,null,null,null,0,{"$f":"ROUND($G$186*I191,0)","v":0},{"$f":"ROUND(I191-J191,0)","v":0},{"$f":"J191+K191","v":0}]
["4.",null,null,null,null,null,null,null,0,0,0,0]
["5.",null,null,null,null,null,null,null,0,0,0,0]
["6.",null,null,null,null,null,null,null,0,0,0,0]
["7.",null,null,null,null,null,null,null,0,0,0,0]
["8.",null,null,null,null,null,null,null,0,0,0,0]
["9.",null,null,null,null,null,null,null,0,0,0,0]
["10.",null,null,null,null,null,null,null,0,0,0,0]
["11.",null,null,null,null,null,null,null,0,0,0,0]
["12.",null,null,null,null,null,null,null,0,0,0,0]
["13.",null,null,null,null,null,null,null,0,0,0,0]
["14.",null,null,null,null,null,null,null,0,0,0,0]
["15.",null,null,null,null,null,null,null,0,0,0,0]
["16.",null,null,null,null,null,null,null,0,0,0,0]
["17.",null,null,null,null,null,null,null,0,0,0,0]
["18.",null,null,null,null,null,null,null,0,0,0,0]
["19.",null,null,null,null,null,null,null,0,0,0,0]
["20.",null,null,null,null,null,null,null,0,0,0,0]
["21.",null,null,null,null,null,null,null,0,0,0,0]
["22.",null,null,null,null,null,null,null,0,0,0,0]
["23.",null,null,null,null,null,null,null,0,{"$f":"ROUND($G$186*I211,0)","v":0},0,0]
["24.",null,null,null,null,null,null,null,0,{"$f":"ROUND($G$186*I212,0)","v":0},0,0]
["25.",null,null,null,null,null,null,null,0,{"$f":"ROUND($G$186*I213,0)","v":0},0,0]
[]
[null,null,null,null,null,null,null,null,null,"State Share","Federal Share","Total Dollars     "]
[null,"TRAVEL AND PER DIEM",null,null,null,null,null,null,null,{"$f":"SUM(J189:J213)","v":0},{"$f":"SUM(K189:K213)","v":0},0]
[]
[null,"SUBCONTRACTS: (add as many lines as necessary or leave blank if not applicable)"]
[]
[null,"Note: Insert State Share, Federal Share and Total Dollars from the corresponding Federal Fiscal Year of the  Subcontractor Budget Summary page. "]
[]
[null,"Subcontractor Name",null,null,null,null,null,null,null,"State Share","Federal Share","Total Dollars     "]
["1.",null,null,null,null,null,null,null,null,0,0,0]
["2.",null,null,null,null,null,null,null,null,0,0,0]
["3.",null,null,null,null,null,null,null,null,0,0,0]
["4.",null,null,null,null,null,null,null,null,0,0,0]
["5.",null,null,null,null,null,null,null,null,0,0,0]
["6.",null,null,null,null,null,null,null,null,0,0,0]
["7.",null,null,null,null,null,null,null,null,0,0,0]
["8.",null,null,null,null,null,null,null,null,0,0,0]
["9.",null,null,null,null,null,null,null,null,0,0,0]
["10.",null,null,null,null,null,null,null,null,0,0,0]
["11.",null,null,null,null,null,null,null,null,0,0,0]
["12.",null,null,null,null,null,null,null,null,0,0,0]
["13.",null,null,null,null,null,null,null,null,0,0,0]
["14.",null,null,null,null,null,null,null,null,0,0,0]
["15.",null,null,null,null,null,null,null,null,0,0,0]
["16.",null,null,null,null,null,null,null,null,0,0,0]
["17.",null,null,null,null,null,null,null,null,0,0,0]
["18.",null,null,null,null,null,null,null,null,0,0,0]
["19.",null,null,null,null,null,null,null,null,0,0,0]
["20.",null,null,null,null,null,null,null,null,0,0,0]
["21.",null,null,null,null,null,null,null,null,0,0,0]
["22.",null,null,null,null,null,null,null,null,0,0,0]
["23.",null,null,null,null,null,null,null,null,0,0,0]
["24.",null,null,null,null,null,null,null,null,0,0,0]
["25.",null,null,null,null,null,null,null,null,0,0,0]
["26.",null,null,null,null,null,null,null,null,0,0,0]
["27.",null,null,null,null,null,null,null,null,0,0,0]
["28.",null,null,null,null,null,null,null,null,0,0,0]
["29.",null,null,null,null,null,null,null,null,0,0,0]
["30.",null,null,null,null,null,null,null,null,0,0,0]
["31.",null,null,null,null,null,null,null,null,0,0,0]
["32.",null,null,null,null,null,null,null,null,0,0,0]
["33.",null,null,null,null,null,null,null,null,0,0,0]
["34.",null,null,null,null,null,null,null,null,0,0,0]
["35.",null,null,null,null,null,null,null,null,0,0,0]
["36.",null,null,null,null,null,null,null,null,0,0,0]
["37.",null,null,null,null,null,null,null,null,0,0,0]
["38.",null,null,null,null,null,null,null,null,0,0,0]
["39.",null,null,null,null,null,null,null,null,0,0,0]
["40.",null,null,null,null,null,null,null,null,0,0,0]
["41.",null,null,null,null,null,null,null,null,0,0,0]
["42.",null,null,null,null,null,null,null,null,0,0,0]
["43.",null,null,null,null,null,null,null,null,0,0,0]
["44.",null,null,null,null,null,null,null,null,0,0,0]
["45.",null,null,null,null,null,null,null,null,0,0,0]
["46.",null,null,null,null,null,null,null,null,0,0,0]
["47.",null,null,null,null,null,null,null,null,0,0,0]
["48.",null,null,null,null,null,null,null,null,0,0,0]
["49.",null,null,null,null,null,null,null,null,0,0,0]
["50.",null,null,null,null,null,null,null,null,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,"State Share","Federal Share","Total Dollars     "]
[null,"SUBCONTRACTS",null,null,null,null,null,null,null,{"$f":"SUM(J223:J272)","v":0},{"$f":"SUM(K223:K272)","v":0},{"$f":"SUM(L223:L272)","v":0}]
[null,"OTHER COSTS: (add as many lines as necessary)"]
[]
[null,"Percent of Other Costs Paid from State Share:",null,null,null,null,null,0]
[null,"Proration Percentage (as calculated in Personnel section):",null,null,null,null,null,{"$f":"G15","v":0}]
[]
[null,"FIXED COSTS:"]
[null,"Description",null,null,null,null,null,null,"Annual Cost","State Share","Federal Share","Total Dollars     "]
["1.",null,null,null,null,null,null,null,0,{"$f":"ROUND($H$278*I283,0)","v":0},{"$f":"ROUND(I283-J283,0)","v":0},{"$f":"J283+K283","v":0}]
["2.",null,null,null,null,null,null,null,0,0,0,{"$f":"J284+K284","v":0}]
["3.",null,null,null,null,null,null,null,0,0,0,0]
["4.",null,null,null,null,null,null,null,0,0,0,0]
["5.",null,null,null,null,null,null,null,0,0,0,0]
["6.",null,null,null,null,null,null,null,0,0,0,0]
["7.",null,null,null,null,null,null,null,0,0,0,0]
["8.",null,null,null,null,null,null,null,0,0,0,0]
["9.",null,null,null,null,null,null,null,0,0,0,0]
["10.",null,null,null,null,null,null,null,0,0,0,0]
["11.",null,null,null,null,null,null,null,0,0,0,0]
["12.",null,null,null,null,null,null,null,0,0,0,{"$f":"J294+K294","v":0}]
[]
[null,"PRORATED COSTS:"]
[null,"Description",null,null,null,null,null,null,"Annual Cost","State Share","Federal Share","Total Dollars     "]
["1.",null,null,null,null,null,null,null,0,{"$f":"ROUND($H$278*$H$279*I298,0)","v":0},{"$f":"ROUND((I298*$H$279)-J298,0)","v":0},{"$f":"J298+K298","v":0}]
["2.",null,null,null,null,null,null,null,0,0,0,{"$f":"J299+K299","v":0}]
["3.",null,null,null,null,null,null,null,0,0,0,0]
["4.",null,null,null,null,null,null,null,0,0,0,0]
["5.",null,null,null,null,null,null,null,0,0,0,0]
["6.",null,null,null,null,null,null,null,0,0,0,0]
["7.",null,null,null,null,null,null,null,0,0,0,0]
["8.",null,null,null,null,null,null,null,0,0,0,0]
["9.",null,null,null,null,null,null,null,0,0,0,0]
["10.",null,null,null,null,null,null,null,0,0,0,0]
["11.",null,null,null,null,null,null,null,0,0,0,0]
["12.",null,null,null,null,null,null,null,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,"State Share","Federal Share","Total Dollars     "]
[null,"OTHER COSTS",null,null,null,null,null,null,null,{"$f":"SUM(J298:J309,J283:J294)","v":0},{"$f":"SUM(K298:K309,K283:K294)","v":0},0]
[]
[null,"INDIRECT COSTS:"]
[null,"Check the line items on which indirect costs are to be applied:"]
[null,null,null,null,null,null,null,null,null,"State Share","Federal Share","Total Dollars     "]
[null,null,null,null,null,"Personnel Salaries",null,null,null,{"$f":"IF($C$364=TRUE,$J$60*$D$323,0)","v":0},{"$f":"IF($C$364=TRUE,$K$60*$D$323,0)","v":0},{"$f":"IF($C$364=TRUE,$L$60*$D$323,0)","v":0}]
[null,null,null,null,null,"Fringe Benefits",null,null,null,{"$f":"IF($C$365=TRUE,$J$111*$D$323,0)","v":0},{"$f":"IF($C$365=TRUE,$K$111*$D$323,0)","v":0},{"$f":"IF($C$365=TRUE,$L$111*$D$323,0)","v":0}]
[null,null,null,null,null,"Operating Expenses",null,null,null,{"$f":"IF($C$366=TRUE,$J$149*$D$323,0)","v":0},{"$f":"IF($C$366=TRUE,$K$149*$D$323,0)","v":0},{"$f":"IF($C$366=TRUE,$L$149*$D$323,0)","v":0}]
[null,null,null,null,null,"Travel and Per Diem",null,null,null,{"$f":"IF($C$367=TRUE,$J$216*$D$323,0)","v":0},{"$f":"IF($C$367=TRUE,$K$216*$D$323,0)","v":0},{"$f":"IF($C$367=TRUE,$L$216*$D$323,0)","v":0}]
[null,null,null,null,null,"Other Costs",null,null,null,{"$f":"IF($C$368=TRUE,$J$312*$D$323,0)","v":0},{"$f":"IF($C$368=TRUE,$K$312*$D$323,0)","v":0},{"$f":"IF($C$368=TRUE,$L$312*$D$323,0)","v":0}]
[null,null,null,null,null,null,null,null,"Total",{"$f":"ROUND(SUM(J317:J321),0)","v":0},{"$f":"ROUND(SUM(K317:K321),0)","v":0},0]
[null,"Enter Indirect Rate:",null,0,"Indirect Costs (between 10 and 26%)"]
[]
[null,"Double-Check the correct percent calculation in the \"Indirect Double Check\" tab."]
[null,"Indirect Costs rate must be adjusted to the corrected percent. Not to exceed 26.0000%"]
[]
[null,null,null,null,null,null,null,null,null,"State Share","Federal Share","Total Dollars     "]
[null,"INDIRECT COSTS",null,null,null,null,null,null,null,{"$f":"J322","v":0},{"$f":"K322","v":0},{"$f":"L322","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"State Share","Federal Share","Total Dollars     "]
[null,"TOTAL EXPENSES",null,null,null,null,null,null,null,{"$f":"J60+J111+J149+J182+J216+J275+J312+J329","v":0},{"$f":"K60+K111+K149+K182+K216+K275+K312+K329","v":0},{"$f":"L60+L111+L149+L182+L216+L275+L312+L329","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,false]
[null,null,false]
[null,null,false]
[null,null,false]
[null,null,false]

{"sheet":"Fringe Double Check","index":2,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,"FRINGE BENEFITS DOUBLE CHECK:"]
[]
[null,"Double-Check Percent Calculation:"]
[]
[null,null,null,null,"State Share","Federal Share","Total Dollars"]
[null,null,"Personnel Salaries",null,{"$f":"'FFY 17 Annual Budget Detail'!J60","v":0},{"$f":"'FFY 17 Annual Budget Detail'!K60","v":0},{"$f":"'FFY 17 Annual Budget Detail'!L60","v":0}]
[]
[]
[null,null,null,null,"State Share","Federal Share","Total Dollars"]
[null,null,"Fringe Benefits",null,{"$f":"'FFY 17 Annual Budget Detail'!J111","v":0},{"$f":"'FFY 17 Annual Budget Detail'!K111","v":0},{"$f":"'FFY 17 Annual Budget Detail'!L111","v":0}]
[]
[]
[null,"Corrected Percent:",null,null,{"$f":"F10/F6","v":{"$error":"#DIV/0!"}}]

{"sheet":"Indirect Double Check","index":3,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,"INDIRECT COSTS DOUBLE CHECK:"]
[]
[null,"Double-Check Percent Calculation:"]
[]
[null,null,null,null,"State  Share","Federal Share","Total Dollars     "]
[null,null,"Personnel Salaries",null,{"$f":"IF('FFY 17 Annual Budget Detail'!$C$364=TRUE,'FFY 17 Annual Budget Detail'!$J$60,0)","v":0},{"$f":"IF('FFY 17 Annual Budget Detail'!$C$364=TRUE,'FFY 17 Annual Budget Detail'!$K$60,0)","v":0},{"$f":"IF('FFY 17 Annual Budget Detail'!$C$364=TRUE,'FFY 17 Annual Budget Detail'!$L$60,0)","v":0}]
[null,null,"Fringe Benefits",null,{"$f":"IF('FFY 17 Annual Budget Detail'!$C$365=TRUE,'FFY 17 Annual Budget Detail'!$J$111,0)","v":0},{"$f":"IF('FFY 17 Annual Budget Detail'!$C$365=TRUE,'FFY 17 Annual Budget Detail'!$K$111,0)","v":0},{"$f":"IF('FFY 17 Annual Budget Detail'!$C$365=TRUE,'FFY 17 Annual Budget Detail'!$L$111,0)","v":0}]
[null,null,"Operating Expenses",null,{"$f":"IF('FFY 17 Annual Budget Detail'!$C$366=TRUE,'FFY 17 Annual Budget Detail'!$J$149,0)","v":0},{"$f":"IF('FFY 17 Annual Budget Detail'!$C$366=TRUE,'FFY 17 Annual Budget Detail'!$K$149,0)","v":0},{"$f":"IF('FFY 17 Annual Budget Detail'!$C$366=TRUE,'FFY 17 Annual Budget Detail'!$L$149,0)","v":0}]
[null,null,"Travel and Per Diem",null,{"$f":"IF('FFY 17 Annual Budget Detail'!$C$367=TRUE,'FFY 17 Annual Budget Detail'!$J$216,0)","v":0},{"$f":"IF('FFY 17 Annual Budget Detail'!$C$367=TRUE,'FFY 17 Annual Budget Detail'!$K$216,0)","v":0},{"$f":"IF('FFY 17 Annual Budget Detail'!$C$367=TRUE,'FFY 17 Annual Budget Detail'!$L$216,0)","v":0}]
[null,null,"Other Costs",null,{"$f":"IF('FFY 17 Annual Budget Detail'!$C$368=TRUE,'FFY 17 Annual Budget Detail'!$J$312,0)","v":0},{"$f":"IF('FFY 17 Annual Budget Detail'!$C$368=TRUE,'FFY 17 Annual Budget Detail'!$K$312,0)","v":0},{"$f":"IF('FFY 17 Annual Budget Detail'!$C$368=TRUE,'FFY 17 Annual Budget Detail'!$L$312,0)","v":0}]
[null,null,"Total",null,{"$f":"ROUND(SUM(E6:E10),0)","v":0},{"$f":"ROUND(SUM(F6:F10),0)","v":0},0]
[]
[null,"Corrected Percent:",null,null,{"$f":"'FFY 17 Annual Budget Detail'!K322/'Indirect Double Check'!F11","v":{"$error":"#DIV/0!"}}]