{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["ADD Information","Dropdown","Project List","Funding List","Activity List","Annual Summary","Quarterly Project Summary","Funding Summary","Activity Summary","CountyList"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":21,"comments":0,"pivot_tables":9},"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":"ADD Information","index":0,"n_rows":16,"n_cols":1,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["FY"]
["ADD Name"]
["Address"]
["City, State, Zip"]
[]
["Executive Director"]
["Phone"]
["Email"]
[]
["Primary Contact"]
["Primary Phone"]
["Primary Email"]
[]
["Finance Contact"]
["Finance Phone"]
["Finance Email"]

{"sheet":"Dropdown","index":1,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["County","Applicant","Scope","Staff","Grant","Type","Status","Program","Activity","Quarter"]
[null,null,"Project Development",null,"ARC","State","Not Started","120","Board Meeting","Quarter 1"]
[null,null,"Application Preparation",null,"BRIC","Federal","In Progress","125","Committee/Council Meeting","Quarter 2"]
[null,null,"Release of Funds",null,"CDBG","Local","Stuck","130","Local Government Meeting","Quarter 3"]
[null,null,"Project Management",null,"CDBG - CV","Other","Pending","135","Planning/Stakeholder Meeting","Quarter 4"]
[null,null,"Technical Assistance",null,"CWSRF",null,"Awarded","140","Project/Progress Meeting"]
[null,null,"Closeout",null,"DOW",null,"Denied","150","Regional Cooperation"]
[null,null,null,null,"DWSRF",null,"Withdrawn","Other","Public Meeting"]
[null,null,null,null,"EDA",null,"Closed",null,"Project Administration"]
[null,null,null,null,"EPA",null,"NA",null,"Technical Assistance"]
[null,null,null,null,"FEMA",null,null,null,"Clearinghouse Review"]
[null,null,null,null,"FMA",null,null,null,"Staff Training"]
[null,null,null,null,"HMA",null,null,null,"Training Facilitation"]
[null,null,null,null,"KIA - CW",null,null,null,"Other"]
[null,null,null,null,"KIA - Fund B"]
[null,null,null,null,"KIA - Fund C"]
[null,null,null,null,"KOHS"]
[null,null,null,null,"KY 911"]
[null,null,null,null,"LWCF"]
[null,null,null,null,"RTP"]
[null,null,null,null,"SS4A"]
[null,null,null,null,"USDA"]

{"sheet":"Project List","index":2,"n_rows":3,"n_cols":24,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,10,0,12],[0,13,0,15],[0,16,0,18],[0,19,0,21],[0,1,0,3]]}
["Quarter 1",{"$f":"'ADD Information'!B2 & CHAR(10) & \"FY\" & 'ADD Information'!B1 & \" Project List\"","v":"\nFY Project List"},null,null,null,null,null,null,null,null,"Quarter 1",null,null,"Quarter 2",null,null,"Quarter 3",null,null,"Quarter 4"]
["PNUM","Project Lead","County","Applicant","Name","Project Description","Jobs Created","Jobs Retained","Population Impacted","Private Investment","Scope Q1","Estimated Cost Q1","Quarter 1","Scope Q2","Estimated Cost Q2","Quarter 2","Scope Q3","Estimated Cost Q3","Quarter 3","Scope Q4","Estimated Cost Q4","Quarter 4","Total","Total Cost"]
[null,null,null,null,null,null,null,null,null,null,"Project Development",null,null,null,{"$f":"IF(OR($A$1=\"Quarter 2\", $A$1=\"Quarter 3\",$A$1=\"Quarter 4\"),ProjectList[[#This Row],[Estimated Cost Q1]],\"\")","v":""},null,null,{"$f":"IF(OR($A$1=\"Quarter 3\",$A$1=\"Quarter 4\"),ProjectList[[#This Row],[Estimated Cost Q2]],\"\")","v":""},null,null,{"$f":"IF($A$1=\"Quarter 4\",ProjectList[[#This Row],[Estimated Cost Q3]],\"\")","v":""},null,{"$f":"IF(COUNTA(ProjectList[[#This Row],[Quarter 1]],ProjectList[[#This Row],[Quarter 2]],ProjectList[[#This Row],[Quarter 3]],ProjectList[[#This Row],[Quarter 4]])>0,1,0)","v":0},{"$f":"IF(ProjectList[[#This Row],[Estimated Cost Q4]]<>\"\",ProjectList[[#This Row],[Estimated Cost Q4]],IF(ProjectList[[#This Row],[Estimated Cost Q3]]<>\"\",ProjectList[[#This Row],[Estimated Cost Q3]],IF(ProjectList[[#This Row],[Estimated Cost Q2]]<>\"\",ProjectList[[#This Row],[Estimated Cost Q2]],IF(ProjectList[[#This Row],[Estimated Cost Q1]]<>\"\",ProjectList[[#This Row],[Estimated Cost Q1]],\"\"))))","v":""}]

{"sheet":"Funding List","index":3,"n_rows":3,"n_cols":16,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
[{"$f":"'ADD Information'!B2 & CHAR(10) & \"FY\" & 'ADD Information'!B1 & \" Funding List\"","v":"\nFY Funding List"}]
["County","Project Name","Funding Source","Application Amount","Application Status","Grant ID","Preparer","Fiscal Year","Funding Type","Grant/Loan","Quarter Submitted","Date Awarded","Commitment Amount","Final Amount","Date Closed","Total Amount"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(FundingList[[#This Row],[Final Amount]]<>\"\",FundingList[[#This Row],[Final Amount]],IF(FundingList[[#This Row],[Commitment Amount]]<>\"\",FundingList[[#This Row],[Commitment Amount]],FundingList[[#This Row],[Application Amount]]))","v":0}]

{"sheet":"Activity List","index":4,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
[{"$f":"'ADD Information'!B2 & CHAR(10) & \"FY\" & 'ADD Information'!B1 & \" Activity List\"","v":"\nFY Activity List"}]
["County","Project Name (If Applicable)","Staff Person","Activity","Description","Quarter","Program"]

{"sheet":"Annual Summary","index":5,"n_rows":4,"n_cols":13,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[{"$f":"('ADD Information'!B2 & \" Annual Summary\")","v":" Annual Summary"}]
[]
["Quarter 1 Projects","Quarter 1 Total Cost","Quarter 2 Projects","Quarter 2 Total Cost","Quarter 3 Projects","Quarter 3 Total Cost","Quarter 4 Projects","Quarter 4 Total Cost","Annual Total Projects","Annual Total Cost","Total Jobs Created","Total Jobs Retained","Total Private Investment"]
[null,null,null,0,null,0,null,0,0,0]

{"sheet":"Quarterly Project Summary","index":6,"n_rows":17,"n_cols":15,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'ADD Information'!B2 & \" FY\" & 'ADD Information'!B1 &\" Annual Project Report\"","v":" FY Annual Project Report"}]
["Quarter 1 Total Projects",null,{"$f":"GETPIVOTDATA(\"Total Projects\",$A$14)","v":1},null,"Quarter 2 Total Projects",null,{"$f":"GETPIVOTDATA(\"Total Projects\",$E$14)","v":0},null,"Quarter 3 Total Projects",null,{"$f":"GETPIVOTDATA(\"Total Projects\",$I$14)","v":0},null,"Quarter 4 Total Projects",null,{"$f":"GETPIVOTDATA(\"Total Projects\",$M$14)","v":0}]
["Quarter 1 Total Cost",null,{"$f":"GETPIVOTDATA(\"Estimated Cost\",$A$14)","v":0},null,"Quarter 2 Total Cost",null,{"$f":"GETPIVOTDATA(\"Estimated Cost\",$E$14)","v":0},null,"Quarter 3 Total Cost",null,{"$f":"GETPIVOTDATA(\"Estimated Cost\",$I$14)","v":0},null,"Quarter 4 Total Cost",null,{"$f":"GETPIVOTDATA(\"Estimated Cost\",$M$14)","v":0}]
[]
[{"$f":"\"FY\" & 'ADD Information'!B1 & \" Total Projects\"","v":"FY Total Projects"},null,{"$f":"GETPIVOTDATA(\"Annual Total Projects\",'Annual Summary'!$A$3)","v":0}]
[{"$f":"\"FY\" & 'ADD Information'!B1 & \" Total Cost\"","v":"FY Total Cost"},null,{"$f":"GETPIVOTDATA(\"Annual Total Cost\",'Annual Summary'!$A$3)","v":0}]
[]
["Total Jobs Created",null,{"$f":"GETPIVOTDATA(\"Total Jobs Created\",'Annual Summary'!$A$3)","v":0}]
["Total Jobs Retained",null,{"$f":"GETPIVOTDATA(\"Total Jobs Retained\",'Annual Summary'!$A$3)","v":0}]
["Total Private Investment",null,{"$f":"GETPIVOTDATA(\"Total Private Investment\",'Annual Summary'!$A$3)","v":0}]
[]
[{"$f":"('ADD Information'!$B$2 & \" Quarter 1 Report\")","v":" Quarter 1 Report"},null,null,null,{"$f":"('ADD Information'!$B$2 & \" Quarter 2 Report\")","v":" Quarter 2 Report"},null,null,null,{"$f":"('ADD Information'!$B$2 & \" Quarter 3 Report\")","v":" Quarter 3 Report"},null,null,null,{"$f":"('ADD Information'!$B$2 & \" Quarter 4 Report\")","v":" Quarter 4 Report"}]
[]
["Activities/Programs","Total Projects","Estimated Cost",null,"Programs/Activities","Total Projects","Estimated Cost",null,"Programs","Total Projects","Estimated Cost",null,"Programs","Total Projects","Estimated Cost"]
["Project Development",1,null,null,"(blank)",null,0,null,"(blank)",null,0,null,"(blank)",null,0]
["(blank)",1,null,null,"(blank)",null,0,null,"(blank)",null,0,null,"(blank)",null,0]
["Grand Total",1,null,null,"Grand Total",null,0,null,"Grand Total",null,0,null,"Grand Total",null,0]

{"sheet":"Funding Summary","index":7,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[{"$f":"('ADD Information'!$B$2 & \" Total Active Applications &  Awards\")","v":" Total Active Applications &  Awards"},null,null,null,{"$f":"('ADD Information'!$B$2 & \" FY\" & 'ADD Information'!B1 & \" Applications by Funding Source\")","v":" FY Applications by Funding Source"},null,null,null,null,null,null,{"$f":"('ADD Information'!$B$2 & \" FY\" & 'ADD Information'!B1 & \" Application Amounts by Funding Source\")","v":" FY Application Amounts by Funding Source"}]
[]
["Fiscal Year","Total Applications","Total Funding",null," "," ",null,null,null,null,null," "," "]
["(blank)",null,0,null,"Fiscal Year","Grand Total",null,null,null,null,null,"Fiscal Year","Grand Total"]
["(blank)",null,0,null,"Grand Total",null,null,null,null,null,null,"Grand Total"]
["Grand Total",null,0]

{"sheet":"Activity Summary","index":8,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[{"$f":"('ADD Information'!$B$2 & \" FY\" & 'ADD Information'!B1 & \" Actvities\")","v":" FY Actvities"}]
[]
[" "," "]
["Activities","(blank)","Grand Total"]
["(blank)"]
["(blank)"]
["Grand Total"]

{"sheet":"CountyList","index":9,"n_rows":3,"n_cols":24,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23]
[{"$f":"Dropdown!$A$2","v":0},{"$f":"OFFSET(Dropdown!$A$2,B1,0)","v":0},{"$f":"OFFSET(Dropdown!$A$2,C1,0)","v":0},{"$f":"OFFSET(Dropdown!$A$2,D1,0)","v":0},{"$f":"OFFSET(Dropdown!$A$2,E1,0)","v":0},{"$f":"OFFSET(Dropdown!$A$2,F1,0)","v":0},{"$f":"OFFSET(Dropdown!$A$2,G1,0)","v":0},{"$f":"OFFSET(Dropdown!$A$2,H1,0)","v":0},{"$f":"OFFSET(Dropdown!$A$2,I1,0)","v":0},{"$f":"OFFSET(Dropdown!$A$2,J1,0)","v":0},{"$f":"OFFSET(Dropdown!$A$2,K1,0)","v":0},{"$f":"OFFSET(Dropdown!$A$2,L1,0)","v":0},{"$f":"OFFSET(Dropdown!$A$2,M1,0)","v":0},{"$f":"OFFSET(Dropdown!$A$2,N1,0)","v":0},{"$f":"OFFSET(Dropdown!$A$2,O1,0)","v":0},{"$f":"OFFSET(Dropdown!$A$2,P1,0)","v":0},{"$f":"OFFSET(Dropdown!$A$2,Q1,0)","v":0},{"$f":"OFFSET(Dropdown!$A$2,R1,0)","v":0},{"$f":"OFFSET(Dropdown!$A$2,S1,0)","v":0},{"$f":"OFFSET(Dropdown!$A$2,T1,0)","v":0},{"$f":"OFFSET(Dropdown!$A$2,U1,0)","v":0},{"$f":"OFFSET(Dropdown!$A$2,V1,0)","v":0},{"$f":"OFFSET(Dropdown!$A$2,W1,0)","v":0},{"$f":"OFFSET(Dropdown!$A$2,X1,0)","v":0}]
[{"$f":"_xlfn._xlws.SORT(_xlfn._xlws.FILTER(ProjectList[Name],ProjectList[County]=A2),,1)","v":0},{"$f":"_xlfn._xlws.SORT(_xlfn._xlws.FILTER(ProjectList[Name],ProjectList[County]=B2),,1)","v":0},{"$f":"_xlfn._xlws.SORT(_xlfn._xlws.FILTER(ProjectList[Name],ProjectList[County]=C2),,1)","v":0},{"$f":"_xlfn._xlws.SORT(_xlfn._xlws.FILTER(ProjectList[Name],ProjectList[County]=D2),,1)","v":0},{"$f":"_xlfn._xlws.SORT(_xlfn._xlws.FILTER(ProjectList[Name],ProjectList[County]=E2),,1)","v":0},{"$f":"_xlfn._xlws.SORT(_xlfn._xlws.FILTER(ProjectList[Name],ProjectList[County]=F2),,1)","v":0},{"$f":"_xlfn._xlws.SORT(_xlfn._xlws.FILTER(ProjectList[Name],ProjectList[County]=G2),,1)","v":0},{"$f":"_xlfn._xlws.SORT(_xlfn._xlws.FILTER(ProjectList[Name],ProjectList[County]=H2),,1)","v":0},{"$f":"_xlfn._xlws.SORT(_xlfn._xlws.FILTER(ProjectList[Name],ProjectList[County]=I2),,1)","v":0},{"$f":"_xlfn._xlws.SORT(_xlfn._xlws.FILTER(ProjectList[Name],ProjectList[County]=J2),,1)","v":0},{"$f":"_xlfn._xlws.SORT(_xlfn._xlws.FILTER(ProjectList[Name],ProjectList[County]=K2),,1)","v":0},{"$f":"_xlfn._xlws.SORT(_xlfn._xlws.FILTER(ProjectList[Name],ProjectList[County]=L2),,1)","v":0},{"$f":"_xlfn._xlws.SORT(_xlfn._xlws.FILTER(ProjectList[Name],ProjectList[County]=M2),,1)","v":0},{"$f":"_xlfn._xlws.SORT(_xlfn._xlws.FILTER(ProjectList[Name],ProjectList[County]=N2),,1)","v":0},{"$f":"_xlfn._xlws.SORT(_xlfn._xlws.FILTER(ProjectList[Name],ProjectList[County]=O2),,1)","v":0},{"$f":"_xlfn._xlws.SORT(_xlfn._xlws.FILTER(ProjectList[Name],ProjectList[County]=P2),,1)","v":0},{"$f":"_xlfn._xlws.SORT(_xlfn._xlws.FILTER(ProjectList[Name],ProjectList[County]=Q2),,1)","v":0},{"$f":"_xlfn._xlws.SORT(_xlfn._xlws.FILTER(ProjectList[Name],ProjectList[County]=R2),,1)","v":0},{"$f":"_xlfn._xlws.SORT(_xlfn._xlws.FILTER(ProjectList[Name],ProjectList[County]=S2),,1)","v":0},{"$f":"_xlfn._xlws.SORT(_xlfn._xlws.FILTER(ProjectList[Name],ProjectList[County]=T2),,1)","v":0},{"$f":"_xlfn._xlws.SORT(_xlfn._xlws.FILTER(ProjectList[Name],ProjectList[County]=U2),,1)","v":0},{"$f":"_xlfn._xlws.SORT(_xlfn._xlws.FILTER(ProjectList[Name],ProjectList[County]=V2),,1)","v":0},{"$f":"_xlfn._xlws.SORT(_xlfn._xlws.FILTER(ProjectList[Name],ProjectList[County]=W2),,1)","v":0},{"$f":"_xlfn._xlws.SORT(_xlfn._xlws.FILTER(ProjectList[Name],ProjectList[County]=X2),,1)","v":0}]