{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Budget Report","Narrative","Data Validation","Certification","Data Entry Import"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":53,"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":"Instructions","index":0,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":true,"merged":[[9,9,11,21],[21,11,25,23],[1,2,1,3],[5,0,6,0]]}
[]
[null,"Purpose of This File","OHA Public Health Division provides grant funding to organizations for work related to M110 \n• To report expenses for funding received, you must complete 'Budget Cat. &Service Area' \n• Once the workbook has been completed, certify the report by signing 'Authorized Agent Signature' (Cell B10 in Certification Tab). "]
[]
[null,"Tab ","Instruction","Tab Completion Checklist"]
[null,"Instructions","This expenditure report is submitted quarterly, and documents cumulative expenses incurred for the 2022 M110 contract. Expenditure reports should be submitted to OHA one month after the quarter end date.  \n\ni.e. Expenditure reports for January 1st, 2022 - March 31st, 2022 are due to OHA by April 30th, 2022.","• Please fill in applicable cells highlighted in blue\n"]
[null,"1. Budget Cat. &Service Area","Please complete the following:\n• Your BHRN name in Cell D6.\n• Your organization's name  in Cell D7.\n• Your Grant agreement number in Cell D8\n• The quarter end date in Cell D9.\nSection A: M110 EXPENDITURES BY BUDGET CATEGORY \n• Allocate your Personnel (Salaries) and Fringe Benefits costs in the appropriate quarter (Row 13).\n• Allocate Program Staff Training Costs in the appropriate quarter (Row 14).\n• Allocate Services and Supplies Costs in the appropriate quarter (Row 15).\n• Allocate Capital Equipment in the appropriate quarter (Row 16). \nSection B: M110 EXPENDITURES BY SERVICE AREA\n• Allocate Section A expenditures to the appropriate category:\n            • Screening and Comp Behavioral Health Needs \n            • Individual Intervention Planning \n            • Low Barrier Substance Use Treatment\n            • Peer Support, Mentoring, etc.\n            • Housing Services\n            • Harm Reduction Intervention \n            • Supported Employment \n\nNote: If the file has red indicators, then Section A is not balanced with Section B.","1. Verify that you have entered in your BHRN name  (Cell D6). \n\n2. Verify that Section A Total Expenditures (Cell H17) balances with your Section B Total Expenditures (Cell E28).\n\n3. Verify that all cells highlighted in blue have been filled in (if applicable).\n\n4. Verify that all previous quarters expenses prior quarterly expenditure data are included, this report is cumulative and will capture all expenditures incurred since the start of the contract.\n\n\n"]
[null,"2. Narrative","Please complete the following:\n• Narrative Explanation of funding (Cell C3:C14) this a broad description of what the funds are being spent on. Please include any information that will show impact of dollars spent. This could include any outputs or outcomes, any stories of impact, or general numbers of clients served in each area. "]
[null,"3. Certification","Please complete the following:\n• Check box to confirm that all funding is from M110\n• Check box to attest that data and narratives are accurate \n• Complete prepared by and authorized agent signature boxes \n"]
[null,"4. Data Entry Import","This tab will auto populate after tabs 1 and 2 are completed, it is used to check for completeness."]

{"sheet":"Budget Report","index":1,"n_rows":44,"n_cols":64,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,3,1,4],[2,3,2,4],[3,3,3,4],[23,1,23,2],[13,1,13,4],[37,7,44,8],[26,7,33,8],[36,1,36,5],[27,63,27,72],[5,10,5,12],[25,10,25,12],[25,1,25,5]]}
[]
[null,null,null,"OREGON HEALTH AUTHORITY",null,"Legend"]
[null,null,null,"Health Services Division (HSD)",null,"Blue cells - require input"]
[null,null,null,"Behavioral Health Measure 110 - Budget Report Template",null,"Gray cells - auto populate "]
[]
[null,null,"BHRN Name: ","Yamhill_County"]
[null,null,"Organization Name: "]
[null,null,"Grant Agreement #: ",{"$f":"IFERROR(INDEX('Data Validation'!J:J,MATCH('Data Validation'!D1,'Data Validation'!E:E,0)),\"\")","v":""}]
[null,null,"Contract Not-to-Exceed Amount: ",{"$f":"IFERROR(INDEX('Data Validation'!$AY:$AY,MATCH('Data Validation'!$D$1,'Data Validation'!$E:$E,0)),0)","v":0}]
[]
[null,null,"Does Original Budget Require Revision?"]
[]
[]
[null,"M110 ORIGINAL BUDGET BY BUDGET CATEGORY"]
[null,"A","Budget Category","Original Budget Allocation","Original Budget Amount ($)"]
[null,"1.","Personnel Costs ",{"$f":"IFERROR(INDEX('Data Validation'!BR:BR,MATCH('Data Validation'!$D$1,'Data Validation'!E:E,0)),\"\")","v":""},{"$f":"IFERROR(D16*$D$9,\"\")","v":""}]
[null,"2.","Program Staff Training Costs",{"$f":"IFERROR(INDEX('Data Validation'!BS:BS,MATCH('Data Validation'!$D$1,'Data Validation'!E:E,0)),\"\")","v":""},{"$f":"IFERROR(D17*$D$9,\"\")","v":""}]
[null,"3.","Services and Supplies Costs",{"$f":"IFERROR(INDEX('Data Validation'!BT:BT,MATCH('Data Validation'!$D$1,'Data Validation'!E:E,0)),\"\")","v":""},{"$f":"IFERROR(D18*$D$9,\"\")","v":""}]
[null,"4.","Capital Outlay Costs",{"$f":"IFERROR(INDEX('Data Validation'!BU:BU,MATCH('Data Validation'!$D$1,'Data Validation'!E:E,0)),\"\")","v":""},{"$f":"IFERROR(D19*$D$9,\"\")","v":""}]
[null,"5.","Admin Costs",{"$f":"IFERROR(INDEX('Data Validation'!BV:BV,MATCH('Data Validation'!$D$1,'Data Validation'!E:E,0)),\"\")","v":""},{"$f":"IFERROR(D20*$D$9,\"\")","v":""}]
[null,null,"TOTAL BUDGET",{"$f":"SUM(D16:D20)","v":0},{"$f":"SUM(E16:E20)","v":0}]
[]
[]
[null,"Budget Revisions Using Dollar or Percentage Amount?"]
[]
[null,"M110 BUDGET BY BUDGET CATEGORY USING PERCENTAGE AMOUNT"]
[null,"A","Budget Category","Original Budget Allocation","Revised Budget Allocation (%)","Revised Budget Amount ($)",null,"Step 5:\n• If you selected \"No\" in Cell D11, your original allocations will populate\n• If you selected \"Yes\" in Cell D11, please enter your revised budget allocations either in percentage or dollar amounts in the blue cells (Row E for percentage amounts, Row F for dollar amounts)\n\nNote: If Budget Allocation does not equal 100% or the full Contract Not-to-Exceed amount, the Total Budget row will highlight red."]
[null,"1.","Personnel Costs ",{"$f":"IFERROR(INDEX('Data Validation'!BR:BR,MATCH('Data Validation'!$D$1,'Data Validation'!E:E,0)),\"\")","v":""},null,{"$f":"IF($D$13=\"Dollar ($)\",\"\",IFERROR($D$9*E28,\"\"))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"2.","Program Staff Training Costs",{"$f":"IFERROR(INDEX('Data Validation'!BS:BS,MATCH('Data Validation'!$D$1,'Data Validation'!E:E,0)),\"\")","v":""},null,{"$f":"IF($D$13=\"Dollar ($)\",\"\",IFERROR($D$9*E29,\"\"))","v":0}]
[null,"3.","Services and Supplies Costs",{"$f":"IFERROR(INDEX('Data Validation'!BT:BT,MATCH('Data Validation'!$D$1,'Data Validation'!E:E,0)),\"\")","v":""},null,{"$f":"IF($D$13=\"Dollar ($)\",\"\",IFERROR($D$9*E30,\"\"))","v":0}]
[null,"4.","Capital Outlay Costs",{"$f":"IFERROR(INDEX('Data Validation'!BU:BU,MATCH('Data Validation'!$D$1,'Data Validation'!E:E,0)),\"\")","v":""},null,{"$f":"IF($D$13=\"Dollar ($)\",\"\",IFERROR($D$9*E31,\"\"))","v":0}]
[null,"5.","Admin Costs",{"$f":"IFERROR(INDEX('Data Validation'!BV:BV,MATCH('Data Validation'!$D$1,'Data Validation'!E:E,0)),\"\")","v":""},null,"num"]
[null,null,"TOTAL BUDGET",{"$f":"SUM(D28:D32)","v":0},{"$f":"SUM(E28:E32)","v":0},{"$f":"SUM(F28:F32)","v":0}]
[]
[]
[]
[null,"M110 BUDGET BY BUDGET CATEGORY USING DOLLAR AMOUNT"]
[null,"A","Budget Category","Original Budget Allocation","Revised Budget Allocation (%)","Revised Budget Amount ($)",null,"Step 5:\n• If you selected \"No\" in Cell D11, your original allocations will populate\n• If you selected \"Yes\" in Cell D11, please enter your revised budget allocations either in percentage or dollar amounts in the blue cells (Row E for percentage amounts, Row F for dollar amounts)\n\nNote: If Budget Allocation does not equal 100% or the full Contract Not-to-Exceed amount, the Total Budget row will highlight red."]
[null,"1.","Personnel Costs ",{"$f":"IFERROR(INDEX('Data Validation'!BR:BR,MATCH('Data Validation'!$D$1,'Data Validation'!E:E,0)),\"\")","v":""},{"$f":"IFERROR(IF($D$11=\"No\",D39,IF($D$24=\"Percentage Amount\",\"\",F39/$D$9)),\"\")","v":""},98000]
[null,"2.","Program Staff Training Costs",{"$f":"IFERROR(INDEX('Data Validation'!BS:BS,MATCH('Data Validation'!$D$1,'Data Validation'!E:E,0)),\"\")","v":""},{"$f":"IFERROR(IF($D$11=\"No\",D40,IF($D$24=\"Percentage Amount\",\"\",F40/$D$9)),\"\")","v":""},7000]
[null,"3.","Services and Supplies Costs",{"$f":"IFERROR(INDEX('Data Validation'!BT:BT,MATCH('Data Validation'!$D$1,'Data Validation'!E:E,0)),\"\")","v":""},{"$f":"IFERROR(IF($D$11=\"No\",D41,IF($D$24=\"Percentage Amount\",\"\",F41/$D$9)),\"\")","v":""},25000]
[null,"4.","Capital Outlay Costs",{"$f":"IFERROR(INDEX('Data Validation'!BU:BU,MATCH('Data Validation'!$D$1,'Data Validation'!E:E,0)),\"\")","v":""},{"$f":"IFERROR(IF($D$11=\"No\",D42,IF($D$24=\"Percentage Amount\",\"\",F42/$D$9)),\"\")","v":""},10000]
[null,"5.","Admin Costs",{"$f":"IFERROR(INDEX('Data Validation'!BV:BV,MATCH('Data Validation'!$D$1,'Data Validation'!E:E,0)),\"\")","v":""},{"$f":"IFERROR(IF($D$11=\"No\",D43,IF($D$24=\"Percentage Amount\",\"\",F43/$D$9)),\"\")","v":""},14000]
[null,null,"TOTAL BUDGET",{"$f":"SUM(D39:D43)","v":0},{"$f":"SUM(E39:E43)","v":0},{"$f":"SUM(F39:F43)","v":154000}]

{"sheet":"Narrative","index":2,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Budget Category","Narrative Explanation of Spending",null,"Legend"]
[null,"Personnel Costs ",null,null,"Blue cells - require input"]
[null,"Program Staff Training Costs",null,null,"Gray cells - auto populate "]
[null,"Services and Supplies Costs"]
[null,"Capital Outlay Costs"]
[null,"Service Area","Narrative Explanation of Spending"]
[null,"Screening and Comp Behavioral Health Needs "]
[null,"Individual Intervention Planning "]
[null,"Low Barrier Substance Use Treatment"]
[null,"Peer Support, Mentoring, etc."]
[null,"Housing Services"]
[null,"Harm Reduction Intervention "]
[null,"Supported Employment "]

{"sheet":"Data Validation","index":3,"n_rows":271,"n_cols":123,"rows_kept":271,"cut":false,"hidden":true,"merged":[]}
[null,null,null,{"$f":"_xlfn.CONCAT(D2,'Budget Report'!D7)","v":"Yamhill County"}]
[null,null,null,{"$f":"INDEX(C:C,MATCH('Budget Report'!D6,'Data Validation'!B:B,0))","v":"Yamhill County"},"ID","County","County ID","BHRN Name","BHRN ID","Grant Number","Grantee Name","Legal Name","Grant ID","SOS Check Complete","SOS Expiration Date","SOS Expired","Access to Care Grantee","Access to Care Grant Agreement Number","Access to Care End Date","Insurance Confirmation","License Expiration Date","Workers' Comp & Employers' Liability (both >$500k)","Commercial General Liability occur>$1m; annual>$2m","Professional Liability occur>$1m; annual>$2m","COI Saved to Teams","COI Notes","Grant Agreement Number","Grant Agreement # w/ Amendment","Grant Agreement Execution Date","Date of Last BHRN Grant Agreement Execution","MOU Due Date","MOU Received Date (From BHRN Grantee)","MOU Execution Date","MOU Submission Date","MOU Saved to Teams?","MOU Email Saved to Teams","MOU Days Outstanding","Policies and Procedures Submitted","C&L Specific Svcs Submission","C&L Responsive Svcs Submission","APIDD Submission Date","APPD Submission Date","GARC Submission Date","LGBTQIA2S+ AIS Submission Date","YFIS Submission Date","PC&N Svcs Submission Date","TIE & C Submission Date","SPYC Submission Date","MOU Payment Due Date","Amount Approved","Grant Agreement NTE Amount","Approved vs. Signed Amount Variance","MOU Milestone Payment Amount","Quarterly Payment Amount","Quarterly Payments","Total Amount to be Paid","Total to be Paid vs. Grant Agreement NTE","Ready for MOU Payment","Payment w/o MOU","Amount Paid to Date","Payment Variance","Personnel Costs","Program Staff Training Costs","Services and Supplies Costs","Capital Outlay Costs","Admin Costs","Calculated Total Costs","Budget Table vs. Grant Agreement Variance","Budget Table Notes","Personnel Costs","Program Staff Training Costs","Services and Supplies Costs","Capital Outlay Costs","Admin Costs","Calculated Total Costs",null,"Example","Baker","Benton","Clackamas","Clatsop","Columbia","Columbia_County","Coos","Crook","Curry","Deschutes","Douglas","Gilliam","Grant","Harney","Hood_River_County","Jackson_County","Jefferson","Josephine","Klamath","Klamath_Child_and_Family_Treatment_Center","Lake","Lane_BHRN_#1","Lane_BHRN_2","Lane_BHRN_3","Lincoln_County_BHRN_1","Lincoln_County_BHRN_2","Linn","Malheur","Marion","Morrow","East_Multnomah_BHRN_Providers","Indigeninity_BHRN_Providers","Latino_a_x_Multnomah_County_BHRN","No_Wrong_Door_BHRN_Providers","Polk","Sherman","Tillamook","Tribal","Umatilla","Union","Wallowa","Wasco","Washington","Wheeler","Brightside","Yamhill_County"]
[null,null,null,null,{"$f":"_xlfn.CONCAT(H3,K3)","v":"ExampleGood Example"},null,null,"Example",null,123456,"Good Example",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AY3","v":154000},{"$f":"BO3","v":154000},null,{"$f":"AY3*0.4","v":61600},null,null,null,null,null,null,null,null,100000,5000,25000,10000,{"$f":"140000*0.1","v":14000},{"$f":"SUM(BJ3:BN3)","v":154000},null,null,{"$f":"IFERROR(BJ3/$BO3,\"\")","v":0.64935064935064934},{"$f":"IFERROR(BK3/$BO3,\"\")","v":3.2467532467532464E-2},{"$f":"IFERROR(BL3/$BO3,\"\")","v":0.16233766233766234},{"$f":"IFERROR(BM3/$BO3,\"\")","v":6.4935064935064929E-2},{"$f":"IFERROR(BN3/$BO3,\"\")","v":9.0909090909090912E-2},null,null,"Good Example","New Directions NW","Benton County Health Department","Bridges to Change","Clatsop Behavioral Healthcare","Boulder Care, Inc.","Boulder Care, Inc.","Adapt","BestCare Treatment Services, Inc.","Adapt","BestCare Treatment Services, Inc.","Adapt","Boulder Care, Inc.","Boulder Care, Inc.","Symmetry Care, Inc.","Columbia Gorge Health Council","Stabbin' Wagon","BestCare Treatment Services, Inc.","BestCare Treatment Services, Inc.","Max's Mission","Max's Mission","North Lake Health Center, Inc.","Community Outreach Through Radical Empowerment (CORE)","Addiction Counseling and Education Services (Emergence)","Centro Latino Americano","Coastal Phoenix Rising","CHANCE","Addiction Counseling and Education Services (Emergence)","Eastern Oregon Center for Independent Living","Bridgeway","Community Counseling Solutions","Bright Transitions","Alano Club of Portland","Central City Concern Puentes","Cascade Aids Project","Polk County","Boulder Care, Inc.","Adventist Health Tillamook","Burns Paiute Tribe","Community Counseling Solutions","Center for Human Development","Boulder Care, Inc.","Bridges to Change","Bridges to Change","Boulder Care, Inc.","Recovery Works NW","Alano Club"]
[null,null,null,null,"ExampleBad Example",null,null,"Example",null,123457,"Bad Example",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AY4","v":79500},{"$f":"BO4","v":79500},null,{"$f":"AY4*0.4","v":31800},null,null,null,null,null,null,null,null,50000,2500,15000,5000,7000,{"$f":"SUM(BJ4:BN4)","v":79500},-0.68000000005122296,null,{"$f":"IFERROR(BJ4/$BO4,\"\")","v":0.62893081761006286},3.1446540880503145E-2,{"$f":"IFERROR(BL4/$BO4,\"\")","v":0.18867924528301888},{"$f":"IFERROR(BM4/$BO4,\"\")","v":6.2893081761006289E-2},{"$f":"IFERROR(BN4/$BO4,\"\")","v":8.8050314465408799E-2},null,null,"Bad Example",null,"CHANCE","Cascadia Behavioral Healthcare","Clatsop Community Action","Columbia Community Mental Health","Columbia Community Mental Health","Bay Area First Step Inc.","Ideal Option","Brookings Community Resource Response","Boulder Care, Inc.","Boulder Care, Inc.","Community Counseling Solutions","Community Counseling Solutions",null,"Hood River County Health Dept.","Addiction Recovery Center",null,"Adapt","Red is the Road to Wellness","Red is the Road to Wellness",null,"Daisy C.H.A.I.N.","Center for Family Development","HIV Alliance","Faith, Hope and Charity, Inc. (FHC)","Phoenix Wellness Center LLC","Albany Comprehensive Treatment (CRC Health OR)","Lifeways","HIV Alliance",null,"Cascadia Behavioral Healthcare, Inc.","Bridges to Change","Fresh-Out Community Based Re-Entry Program","Cascadia Behavioral Healthcare","Youth Era","Mid-Columbia Center for Living","CARE","Coquille Indian Tribe","Eastern Oregon Alcoholism Foundation","Eastern Oregon Center for Independent Living","Wallowa Valley Center for Wellness","Columbia Gorge Health Council","CODA, Inc.","Community Counseling Solutions",null,"Encompass Yamhill Valley"]
[null,"Name Manager Name","BHRN Name",null,"BakerNew Directions NW","Baker","01","Baker","01",176574,"New Directions NW","New Directions Northwest, Inc.","084",true,"2023-05-15","Valid",true,170823,null,null,null,null,null,null,null,null,176574,"176574-0","2022-06-16","2022-06-16","2022-07-16",null,"N/A","N/A","No MOU Required","No MOU Required","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-16",860829,860829,0,344331.6,86082.9,6,860829,0,"Yes","No",344331.6,0,565207.39,0,190857.13,41000,63765.16,860829.68,-0.68000000005122296,null,0.65658445930907028,0,0.22171299902205974,4.7628469315788458E-2,7.4074072353081499E-2,null,null,null,null,"Corvallis Housing First","Harmony Academy Recovery","Clatsop County Public Health","Iron Tribe Network","Iron Tribe Network","Coos Health & Wellness","Rimrock Trails Treatment Services",null,"Deschutes County Health Services","HIV Alliance",null,null,null,"Mid-Columbia Center for Living","ColumbiaCare Services",null,"Grace Roots","The Stronghold","The Stronghold",null,"Ideal Option","HIV Alliance",null,"Community Services Consortium","Coastal Phoenix Rising","CHANCE","Origins Faith Community Outreach Initiative (OFCOI)","Ideal Option",null,"CODA, Inc.","Fresh-Out Community Based Re-Entry Program","Juntos LLC","Lutheran Community Services",null,null,"Rinehart Clinic and Pharmacy","Cow Creek","Eastern Oregon Center for Independent Living",null,null,"Eastern Oregon Center for Independent Living","Forest Grove Foundation",null,null,"Providence Newberg Medical Center"]
[null,"Example","Example",null,"BentonBenton County Health Department","Benton","03","Benton","02",176757,"Benton County Health Department",null,"008",null,null,null,null,null,null,null,null,null,null,null,null,null,176757,"176757-0","2022-07-28",null,null,"2022-07-25","2022-07-20","2022-07-25","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-19",313445.28000000003,313445.28000000003,0,125378.16,31344.52,6,313445.28000000003,0,"Yes","No",125378.16,0,183719.25,4766,93485,2980,28495.03,313445.28000000003,0,"Services and Supplies total omitting $1,200 cost for Tablets",0.58612862187620107,1.5205205833694479E-2,0.29824982529645999,9.5072415829646553E-3,9.0909105410679647E-2,null,null,null,null,"Family Recovery, Inc.","LifeStance","Helping Hands Re-Entry and Outreach","Medicine Wheel Recovery","Medicine Wheel Recovery","HIV Alliance",null,null,"Healing Reins Therapeutic Riding Center",null,null,null,null,"One Community Health","Community Works",null,"Grants Pass Sobering Center","Klamath Basin Behavioral Health","Klamath Basin Behavioral Health",null,"OSLC Developments, Inc.","Housing Our Veterans",null,"Confederated Tribes of the Siletz","Lincoln County HHS Harm Reduction Program","Community Services Consortium",null,"Iron Tribe Network",null,"Iron Tribe Network","Going Home II","New Avenues for Youth","New Avenues for Youth",null,null,"Tillamook County Community Health","CT Coos, Lower Umpqua, and Siuslaw",null,null,null,"Give them WINGS","HIV Alliance",null,null,"Provoking Hope"]
[null,"Baker","Baker",null,"BentonCHANCE","Benton","03","Benton","02",176761,"CHANCE","CHANCE LLC","022",true,"2022-11-15","Valid",null,null,null,null,null,"2023-07-01","2023-07-01","2023-07-01","Yes",null,176761,"176761-0","2022-06-29",null,null,"2022-07-25","2022-07-21","2022-07-25","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-20",1058507.45,1058507.45,0,423403.01,105850.74,6,1058507.45,0,"Yes","No",423403.01,0,205200,3839,718784.33,61000,66960,1055783.33,2724.1199999998798,null,0.19435806019024754,3.6361627342610153E-3,0.68080666702703097,5.7777006196905949E-2,6.3422103851554459E-2,null,null,null,null,"Family Tree Relief Nursery","MetroPlus Association","Iron Tribe Network","Youth ERA","Youth ERA","Youth ERA",null,null,"Ideal Option",null,null,null,null,"Providence Hood River","Compass House",null,"HIV Alliance","Lutheran Community Services","Lutheran Community Services",null,"South Lane Mental Health Services, Inc.","Laurel Hill Center",null,"Lincoln County HHS Harm Reduction Program",null,"Faith, Hope and Charity, Inc. (FHC)",null,"Marion County",null,"Morrison Child and Family Services","Just Men In Recovery","Northwest Family Services","OHSU, Addiction and Complex Pain",null,null,"Tillamook Family Counseling","Grand Ronde",null,null,null,"Greater Oregon Behavioral Health","Ideal Option",null,null,"Virginia Garcia Clinic"]
[null,"Benton","Benton",null,"BentonCorvallis Housing First","Benton","03","Benton","02",176769,"Corvallis Housing First","Corvallis Housing First","038",true,"2023-09-30","Valid",null,null,null,null,null,null,null,null,null,null,176769,"176769-0","2022-07-04",null,null,"2022-07-25","2022-07-21","2022-07-25","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-20",265923.78000000003,262923.78000000003,3000,43820.63,43820.63,5,262923.78000000003,0,"Yes","No",0,null,61541,144600,37232.78,25000,0,268373.78000000003,-5450,null,0.22931077693208329,0.53880077256429437,0.13873478996346064,9.3153660540161554E-2,0,null,null,null,null,"Pathfinder Club of Oregon","Morrison Child and Family Services","Morrison Child and Family Services",null,null,"BestCare Treatment Services, Inc.",null,null,"Rimrock Trails Treatment Services",null,null,null,null,null,"Family Nurturing Center",null,"Max's Mission","Transformations","Transformations",null,"Youth ERA","Looking Glass Community Services",null,"Samaritan Treatment & Recovery",null,"Family Tree Relief Nursery",null,"Pathfinder Club of Oregon",null,"New Avenues for Youth","Addiction Counselor Certification Board of Oregon (MHACBO)","Northwest Instituto Latino De Adicciones","OHSU, Partnership Project",null,null,"Tillamook Serenity Club","Klamath Tribes",null,null,null,"Mid-Columbia Center for Living","LifeWorks NW",null,null,"Yamhill Community Action Partnership"]
[null,"Clackamas","Clackamas",null,"BentonFamily Recovery, Inc.","Benton","03","Benton","02",176756,"Family Recovery, Inc.","Family Recovery, Inc.","046",true,"2022-10-06","Valid",null,null,null,null,null,null,null,null,null,null,176756,"176756-0","2022-06-29",null,null,"2022-07-25","2022-07-22","2022-07-25","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-21",912642,912642,0,365056.8,91264.2,6,912642,0,"Yes","No",365056.8,0,557472,10800,323570,20800,0,912642,0,null,0.61083316349674899,1.1833774908452603E-2,0.35454208769703782,2.2790973897760566E-2,0,null,null,null,null,null,"New Avenues for Youth","Providence Seaside Hosp. Foundation",null,null,"Rimrock Trails Treatment Services",null,null,"Volunteers of America - Oregon",null,null,null,null,null,"HIV Alliance",null,"OnTrack, Inc.",null,null,null,null,"Restored Connections Peer Center",null,null,null,"Samaritan Health Services",null,null,null,"Northwest Family Services","MetroPlus Association","SE Works Inc","Portland Street Medicine",null,null,"Project Quest","NARA",null,null,null,"Mid-Columbia Medical Center","Lutheran Community Services",null,null,"Yamhill County HHS"]
[null,"Clatsop","Clatsop",null,"BentonFamily Tree Relief Nursery","Benton","03","Benton","02",176759,"Family Tree Relief Nursery","Family Tree Relief Nursery","047",true,"2023-02-27","Valid",null,null,null,null,null,null,null,null,null,null,176759,"176759-0","2022-06-28",null,null,"2022-07-25","2022-07-22","2022-07-25","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-21",717510,717510,0,119585,119585,5,717510,0,"Yes","No",119585,0,498926,31500,171084,16000,0,717510,0,null,0.69535755599225102,4.3901827152234812E-2,0.23844127607977589,2.2299340775738318E-2,0,null,null,null,null,null,"Northwest Family Services",null,null,null,null,null,null,null,null,null,null,null,null,"Jackson County Health & Human Services",null,"Options for Southern Oregon",null,null,null,null,"Shelter Care",null,null,null,null,null,null,null,"Pathfinders of Oregon","Oregon Change Clinic","The 4th Dimension Recovery Center","Providence Portland Medical Foundation",null,null,null,"NPAIHB",null,null,null,"North Central Public Health District","MetroPlus Association",null,null,"Yamhill Community Action Partnership"]
[null,"Columbia_County","Columbia County",null,"BentonPathfinder Club of Oregon","Benton","03","Benton","02",176762,"Pathfinder Club of Oregon","Pathfinders of Oregon",null,true,"2022-08-05","Expired",true,170794,null,null,null,"2023-07-01","2023-06-01","2023-06-01","Yes",null,176762,"176762-0","2022-06-28",null,null,"2022-07-25","2022-07-22","2022-07-25","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-21",260458,260458,0,104183.2,26045.8,6,260458,0,"Yes","No",0,null,160650,9808,90000,0,0,260458,0,null,0.6167981018052815,3.7656743121731721E-2,0.34554515507298683,0,0,null,null,null,null,null,"Outside In",null,null,null,null,null,null,null,null,null,null,null,null,"La Clinica",null,"The Family Nurturing Center",null,null,null,null,"TransPonder",null,null,null,null,null,null,null,"Phoenix Rising","Outside In","The Pathfinder Network","SE Works Inc",null,null,null,"Siletz",null,null,null,"One Community Health","Miracles Club",null,null,"Yamhill County HHS"]
[null,"Coos","Coos",null,"ClackamasBridges to Change","Clackamas","05","Clackamas","03",177212,"Bridges to Change","Bridges to Change, Inc.","011",true,"2023-02-13","Valid",true,170864,null,null,null,null,null,null,null,null,177212,"177212-0","2022-07-19",null,null,"2022-06-22","2022-06-15","2022-06-16","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-15",null,2493469.61,-2493469.61,415578.26,415578.27,5,2493469.61,0,"Yes","No",415578.26,0,1297501,5617,169125,627572,393655,2493470,-0.39000000013038499,"Manually categorized expenses as budget table does not follow standard format.",0.52035957922092502,2.2526840106357805E-3,6.7827164553814559E-2,0.25168620436580347,0.15787436784882111,null,null,null,null,null,"Parrott Creek Child & Family Services",null,null,null,null,null,null,null,null,null,null,null,null,"Max's Mission",null,null,null,null,null,null,"Veteran's Legacy",null,null,null,null,null,null,null,"Raphael House of Portland","Painted Horse Recovery",null,"The 4th Dimension Recovery Center",null,null,null,"Umatilla",null,null,null,"Youth Empowerment Shelter","Morrison Child and Family Services"]
[null,"Crook","Crook",null,"ClackamasCascadia Behavioral Healthcare","Clackamas","05","Clackamas","03",177214,"Cascadia Behavioral Healthcare","Cascadia Behavioral Healthcare, Inc.","017",true,"2022-11-20","Valid",true,172070,null,null,null,null,null,null,null,null,177214,"177214-0","2022-07-29",null,null,"2022-06-20","2022-06-24","2022-06-24","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-24",null,306607.82,-306607.82,51101.32,51101.3,5,306607.82,0,"Yes","No",51101.32,0,251714.87,1000,12353.14,0,42539.81,307607.82,-1000,"Training costs equal variance",0.81829801986178374,3.2508926463572997E-3,4.0158731985422212E-2,0,0.13829235550643673,null,null,null,null,null,"Phoenix Rising",null,null,null,null,null,null,null,null,null,null,null,null,"Oasis Center of Rogue Valley",null,null,null,null,null,null,"White Bird Clinic",null,null,null,null,null,null,null,"The 4th Dimension Recovery Center","Project Patchwork",null,"The Everly Project",null,null,null,"Warm Springs",null,null,null,null,"NW Instituto Latino"]
[null,"Curry","Curry",null,"ClackamasHarmony Academy Recovery","Clackamas","05","Clackamas","03",177219,"Harmony Academy Recovery",null,"055",null,null,null,null,null,null,null,null,null,null,null,null,null,177219,"177219-0","2022-07-26",null,null,"2022-08-10","2022-06-15","2022-08-10","Yes","No","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-15",null,1246600.56,-1246600.56,498640.26,124660.05,6,1246600.56,0,"Yes","No",498640.26,0,977813.6,9000,193944.91,0,0,1180758.51,65842.050000000105,null,0.82812327137070563,7.6222190429099676E-3,0.16425450958638443,0,0,null,null,null,null,null,"Recovery Works NW",null,null,null,null,null,null,null,null,null,null,null,null,"OnTrack, Inc.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The Insight Alliance","Project Quest (Quest Center for Integrative Health)",null,"The Marie Equi Institute",null,null,null,null,null,null,null,null,"Phoenix Rising Transitions"]
[null,"Deschutes","Deschutes",null,"ClackamasLifeStance","Clackamas","05","Clackamas","03",177241,"LifeStance","LifeStance Health","069",true,"2023-02-12","Valid",null,null,null,null,null,null,null,null,null,null,177241,"177241-0","2022-08-08",null,null,"2022-08-10","2022-06-17","2022-08-10","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-17",null,327050,-327050,54508.35,54508.33,5,327050,0,"Yes","No",0,null,238750,23750,12800,51750,0,327050,0,null,0.73001070172756455,7.261886561687815E-2,3.9137746521938542E-2,0.15823268613361871,0,null,null,null,null,null,"The 4th Dimension Recovery Center",null,null,null,null,null,null,null,null,null,null,null,null,"Options for Homeless Residents of Ashland",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The Mental Health & Addiction Association of Oregon","SE Works Inc",null,"The Pathfinder Network",null,null,null,null,null,null,null,null,"Sequoia Mental Health"]
[null,"Douglas","Douglas",null,"ClackamasMetroPlus Association","Clackamas","05","Clackamas","03",177457,"MetroPlus Association","MetroPlus Association of Addiction Peer Professionals","078",true,"2024-06-22","Valid",null,null,null,null,null,null,null,null,null,null,177457,"177457-0","2022-08-02",null,null,"2022-06-22","2022-06-12","2022-06-16","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-12",null,42710,-42710,17084,4271,6,42710,0,"Yes","No",0,null,5000,29100,4810,3800,0,42710,0,"Can not find in CLM",0.11706860220088972,0.68133926480917817,0.11261999531725592,8.8972137672676185E-2,0,null,null,null,null,null,"The Mental Health Association of Oregon",null,null,null,null,null,null,null,null,null,null,null,null,"Options for Southern Oregon, Inc.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Volunteers of America Oregon","Sovalti LLC",null,"Yasiin's Luv LLC",null,null,null,null,null,null,null,null,"The 4th Dimension Recovery"]
[null,"Gilliam","Gilliam",null,"ClackamasMorrison Child and Family Services","Clackamas","05","Clackamas","03",177234,"Morrison Child and Family Services","Morrison Child and Family Services","082",true,"2023-03-15","Valid",true,170819,null,null,null,null,null,null,null,null,177234,"177234-0","2022-08-03",null,null,"2022-06-22","2022-06-14","2022-06-16","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-14",null,192097,-192097,32016.15,32016.17,5,192097,0,"Yes","No",32016.15,0,143069,455,29380,0,19192,192096,1,null,0.74477865234049645,2.368607362985174E-3,0.15294436115275695,0,9.9908379143761453E-2,null,null,null,null,null,"Transcending Hope",null,null,null,null,null,null,null,null,null,null,null,null,"Pathfinder Network of Oregon",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WomenFirst Transition Center","The 4th Dimension Recovery Center",null,null,null,null,null,null,null,null,null,null,"The Mental Health Association of Oregon"]
[null,"Grant","Grant",null,"ClackamasNew Avenues for Youth","Clackamas","05","Clackamas","03",177237,"New Avenues for Youth","New Avenues for Youth, Inc.","083",true,"2023-02-18","Valid",null,null,null,null,null,null,null,null,null,null,177237,"177237-0","2022-07-26",null,null,"2022-06-22","2022-06-14","2022-06-16","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-14",null,786131.26,-786131.26,314452.53999999998,78613.119999999995,6,786131.26,0,"Yes","No",314452.53999999998,0,509586.33,27100,32275,114631.06,102538.86,786131.25,1.00000000093132E-2,null,0.6482204212082906,3.4472615100849889E-2,4.1055485327672704E-2,0.1458166940952926,0.1304347842678942,null,null,null,null,null,"Volunteers of America Oregon",null,null,null,null,null,null,null,null,null,null,null,null,"Reclaiming Lives",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yasiin's Luv LLC","The Mental Health & Addiction Association of Oregon",null,null,null,null,null,null,null,null,null,null,"The Recovery Gym (Alano Club)"]
[null,"Harney","Harney",null,"ClackamasNorthwest Family Services","Clackamas","05","Clackamas","03",177244,"Northwest Family Services","Northwest Family Services","087",true,"2023-07-07","Valid",true,171993,null,null,null,null,"2022-12-31",null,"No","No professional liability coverage or worker's compensation",177244,"177244-0","2022-07-26",null,null,"2022-06-22","2022-06-14","2022-06-16","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-14",null,1198802.1299999999,-1198802.1299999999,479520.87,119880.21,6,1198802.1299999999,0,"Yes","No",479520.87,0,982452,14625,78343,14400,108982,1198802,0.12999999988824101,null,0.81952816228201153,1.2199679346547638E-2,6.5351075490364549E-2,1.2011991971985365E-2,9.0909090909090912E-2,null,null,null,null,null,"Youth ERA",null,null,null,null,null,null,null,null,null,null,null,null,"Rogue Community Health",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The Miracles Club",null,null,null,null,null,null,null,null,null,null,"Virginia Garcia Memorial Health"]
[null,"Hood_River_County","Hood River County",null,"ClackamasOutside In","Clackamas","05","Clackamas","03",177245,"Outside In","Outside In",100,true,"2023-09-23","Valid",true,170897,null,null,null,null,null,null,null,null,177245,"177245-0","2022-08-02",null,null,"2022-06-22","2022-06-21","2022-06-23","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-21",null,356789.43,-356789.43,59464.88,59464.91,5,356789.43,0,"Yes","No",59464.88,0,120203,3400,135751,65000,32435,356789,0.42999999999301503,null,0.33690220270243759,9.5294417709066142E-3,0.38047977936539523,0.18218050444380293,9.0908071717457656E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Youth ERA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WomenFirst Transition & Referral Center",null,null,null,null,null,null,null,null,null,null,"Washington County Behavioral Health Division"]
[null,"Jackson_County","Jackson County",null,"ClackamasParrott Creek Child & Family Services","Clackamas","05","Clackamas","03",177246,"Parrott Creek Child & Family Services","Parrott Creek Child & Family Services, Inc.",102,true,"2023-07-02","Valid",null,null,null,null,null,null,null,null,null,null,177246,"177246-0","2022-07-27",null,null,"2022-06-22","2022-06-14","2022-06-16","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-14",null,843594,-843594,337437.6,84359.4,6,843594,0,"Yes","No",0,null,681075,33211,71498,57810,0,843594,0,null,0.80734926990945877,3.9368463976747106E-2,8.4754040450738158E-2,6.8528225663055928E-2,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Washington County Public Health"]
[null,"Jefferson","Jefferson",null,"ClackamasPhoenix Rising","Clackamas","05","Clackamas","03",177247,"Phoenix Rising","Phoenix Rising",103,true,"2023-10-15","Valid",null,null,null,null,null,null,null,null,null,null,177247,"177247-0","2022-08-02",null,null,"2022-06-22","2022-06-14","2022-06-16","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-14",null,96691.48,-96691.48,38676.639999999999,9669.14,6,96691.48,0,"Yes","No",38676.639999999999,0,82608.53,1500,12582.95,0,0,96691.48,0,null,0.85435169675756339,1.5513259286133587E-2,0.1301350439563031,0,0]
[null,"Josephine","Josephine",null,"ClackamasRecovery Works NW","Clackamas","05","Clackamas","03",177249,"Recovery Works NW","Recovery Works NW",116,true,"2023-04-07","Valid",null,null,null,null,null,null,"2022-12-22","2023-05-01","No","No professional liability coverage or workers compensation amounts",177249,"177249-0","2022-08-26",null,null,"2022-06-22","2022-06-22","2022-06-23","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-22",null,2181240,-2181240,872496,218124,6,2181240,0,"Yes","No",0,null,361872.6,90000,273218.44,1383639.86,72509.100000000006,2181240,0,null,0.16590223909335974,4.1260934147549097E-2,0.12525831178595662,0.63433636830426732,3.3242146668867253E-2]
[null,"Klamath","Klamath",null,"ClackamasThe 4th Dimension Recovery Center","Clackamas","05","Clackamas","03",177251,"The 4th Dimension Recovery Center","The 4th Dimension Recovery Center",131,true,"2023-01-14","Valid",true,170896,null,null,null,null,null,null,null,null,177251,"177251-0","2022-07-26",null,null,"2022-06-22","2022-06-15","2022-06-16","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-15",null,1742400.4,-1742400.4,290400.05,290400.07,5,1742400.4,0,"Yes","No",290400.05,0,724849.79,3500,259500,150000,113784.98,1251634.77,490765.63,null,0.57912244639864074,2.7963428980164878E-3,0.20732885201007958,0.11984326705784946,9.0909091635413733E-2]
[null,"Lake","Lake",null,"ClackamasThe Mental Health Association of Oregon","Clackamas","05","Clackamas","03",177248,"The Mental Health Association of Oregon","The Mental Health & Addiction Association of Oregon",136,true,"2023-07-20","Valid",null,null,null,null,null,null,null,null,null,null,177248,"177248-0","2022-07-26",null,null,"2022-08-09","2022-06-17","2022-08-09","Yes","No","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-17",null,719896.94,-719896.94,287958.8,71989.69,6,719896.94,0,"Yes","No",287958.8,0,477027.34,9990,174013.02,0,65445.18,726475.54,-6578.6000000000904,"Budget on CLM has different categories",0.6566323485578055,1.3751323272356836E-2,0.23953045962153108,0,9.0085868548306525E-2]
[null,"Lane_BHRN_1","Lane BHRN 1",null,"ClackamasTranscending Hope","Clackamas","05","Clackamas","03",177250,"Transcending Hope","Transcending Hope",142,true,"2022-08-12","Expired",null,null,null,null,null,null,null,null,null,null,177250,"177250-0","2022-07-26",null,null,"2022-06-22","2022-06-15","2022-06-16","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-15",null,1079702.8600000001,-1079702.8600000001,431881.18,107970.28,6,1079702.8600000001,0,"Yes","No",431881.18,0,526542.42000000004,3000,544321.43999999994,36775,0,1110638.8600000001,-30936,"Budget spreadsheet says total is 1079702.86 but sum of their expenses is greater",0.47408967843966848,2.7011480581545649E-3,0.4900976002226321,3.3111573279544712E-2,0]
[null,"Lane_BHRN_2","Lane BHRN 2",null,"ClackamasVolunteers of America Oregon","Clackamas","05","Clackamas","03",177209,"Volunteers of America Oregon","Volunteers of America Oregon, Inc.",147,true,"2022-10-03","Valid",null,null,null,null,null,null,null,null,null,null,177209,"177209-0","2022-07-19",null,null,"2022-06-22","2022-06-22","2022-06-23","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-22",null,376414.4,-376414.4,150565.76000000001,37641.440000000002,6,376414.4,0,"Yes","No",150565.76000000001,0,0,0,221667,0,48773,270440,105974.39999999999,"Does not add up to the total, no personnel or staff training costs outlined",0,0,0.81965315781689096,0,0.18034684218310901]
[null,"Lane_BHRN_3","Lane BHRN 3",null,"ClackamasYouth ERA","Clackamas","05","Clackamas","03",177211,"Youth ERA","Youth ERA",157,true,"2022-10-06","Valid",null,null,null,null,null,null,null,null,null,null,177211,"177211-0","2022-07-26",null,null,"2022-08-09","2022-06-14","2022-08-09","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-14",null,181787,-181787,72714.8,18178.7,6,181787,0,"Yes","No",80329.8,7615,129671,1000,27405,0,23711,181787,0,null,0.71331283315088534,5.5009434117951226E-3,0.15075335420024535,0,0.13043286923707414]
[null,"Lincoln_County_BHRN_1","Lincoln County BHRN 1",null,"ClatsopClatsop Behavioral Healthcare","Clatsop","07","Clatsop","04",177465,"Clatsop Behavioral Healthcare","Clatsop Behavioral Healthcare","023",true,"2023-05-28","Valid",true,170833,null,null,null,null,null,null,null,null,177465,"177465-0","2022-08-08",null,null,"2022-08-08","2022-08-02","2022-08-08","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-09-01",null,1093678.3600000001,-1093678.3600000001,437471.38,109367.84,6,1093678.42,-5.9999999823048697E-2,"Yes","No",437471.38,0,736332.91,11100,259255.06,0,85990.399999999994,1092678.3700000001,999.98999999999103,null,0.67387891095528862,1.0158524507078876E-2,0.23726566491839676,0,7.8696899619235608E-2]
[null,"Lincoln_County_BHRN_2","Lincoln County BHRN 2",null,"ClatsopClatsop Community Action","Clatsop","07","Clatsop","04",177466,"Clatsop Community Action","Clatsop Community Action","024",true,"2023-02-21","Valid",null,null,null,null,null,null,null,null,null,null,177466,"177466-0","2022-08-08",null,null,"2022-08-08","2022-08-02","2022-08-08","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-09-01",null,1581378.31,-1581378.31,632551.32999999996,158137.82999999999,6,1581378.31,0,"Yes","No",632551.32999999996,0,357982.8,3800,599450,0,0,961232.8,620145.51,null,0.3724205000079065,3.9532566928635812E-3,0.62362624329922989,0,0]
[null,"Linn","Linn",null,"ClatsopClatsop County Public Health","Clatsop","07","Clatsop","04",177471,"Clatsop County Public Health","Clatsop County Department of Public Health","025",null,null,null,null,null,null,null,null,null,null,null,null,null,177471,"177471-0","2022-08-30",null,null,"2022-08-08","2022-07-28","2022-08-08","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-27",null,267603.45,-267603.45,44600.55,44600.58,5,267603.45,0,"Yes","No",0,null,91508.2,5700,103887.48,0,0,201095.67999999999,66507.77,null,0.45504806468244369,2.8344716306188178E-2,0.51660721901136808,0,0]
[null,"Malheur","Malheur",null,"ClatsopHelping Hands Re-Entry and Outreach","Clatsop","07","Clatsop","04",177468,"Helping Hands Re-Entry and Outreach","Helping Hands Re-Entry and Outreach","057",true,"2022-10-21","Valid",null,null,null,null,null,null,null,null,null,null,177468,"177468-0","2022-08-08",null,null,"2022-08-08","2022-08-02","2022-08-08","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-09-01",null,1801780,-1801780,720712,180178,6,1801780,0,"Yes","No",720712,0,37000,0,0,1163000,0,1200000,601780,null,3.0833333333333334E-2,0,0,0.96916666666666662,0]
[null,"Marion","Marion",null,"ClatsopIron Tribe Network","Clatsop","07","Clatsop","04",177467,"Iron Tribe Network","Iron Tribe Network","062",true,"2023-06-29","Valid",null,null,null,null,null,"2023-07-01","2023-01-02","2023-01-02","Yes",null,177467,"177467-0","2022-08-08",null,null,"2022-08-08","2022-08-08","2022-08-08","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-09-07",null,1037496.48,-1037496.48,414998.64,103749.64,6,1037496.48,0,"Yes","No",0,null,102921,2850,48625,885000,0,1039396,-1899.52000000002,null,9.9020007773745519E-2,2.7419770712991008E-3,4.6781977225234653E-2,0.85145603792972069,0]
[null,"Morrow","Morrow",null,"ClatsopMorrison Child and Family Services","Clatsop","07","Clatsop","04",177470,"Morrison Child and Family Services","Morrison Child and Family Services","082",true,"2023-03-15","Valid",true,170819,null,null,null,null,null,null,null,null,177470,"177470-0","2022-08-08",null,null,"2022-08-08","2022-08-08","2022-08-08","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-09-07",null,188695.66,-188695.66,31449.26,31449.279999999999,5,188695.66,0,"Yes","No",31449.26,0,140526,445,47725,0,0,188696,-0.33999999999650798,null,0.74472166871581802,2.3582905837961588E-3,0.25292004070038582,0,0]
[null,"East_Multnomah_BHRN_Providers","East Multnomah BHRN Providers",null,"ClatsopProvidence Seaside Hosp. Foundation","Clatsop","07","Clatsop","04",177478,"Providence Seaside Hosp. Foundation","Providence Seaside Hospital Foundation",112,true,"2022-08-22","Expired",true,null,null,null,null,"2023-01-01","2023-06-01","2023-06-01","Yes",null,177478,"177478-0","2022-08-09",null,null,"2022-08-08","2022-08-07","2022-08-08","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-09-06",null,221313,-221313,88525.2,22131.3,6,221313,0,"Yes","No",88525.2,0,307742,1500,65674,0,153612,528528,-307215,null,0.5822624345351618,2.8380710198892016E-3,0.12425831744013562,0,0.29064117700481334]
[null,"Indigeninity_BHRN_Providers","Indigeninity BHRN Providers",null,"Columbia CountyBoulder Care, Inc.","Columbia","09","Columbia County","05",176763,"Boulder Care, Inc.","Boulder Care, Inc.","010",true,"2022-11-25","Valid",null,null,null,null,null,null,"2023-05-07","2023-05-07","No","No workers compensation amount",176763,"176763-0","2022-06-25",null,null,"2022-07-08","2022-07-08","2022-07-08","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-07",97256,97256,0,38902.400000000001,9725.6,6,97256,0,"Yes","No",38902.400000000001,0,null,null,null,null,null,0,null,"The boulder care CLM folder contains the wrong budget, it contains the medicine wheel recovery budget","","","","",""]
[null,"Latino_a_x_Multnomah_County_BHRN","Latino/a/x Multnomah County BHRN",null,"Columbia CountyColumbia Community Mental Health","Columbia","09","Columbia County","05",176765,"Columbia Community Mental Health","Columbia Community Mental Health","028",true,"2022-07-15","Expired",null,null,null,null,null,null,null,null,null,null,176765,"176765-0","2022-08-01",null,null,"2022-07-08","2022-07-05","2022-07-08","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-04",1304252,1304252.1100000001,-0.110000000102445,217375.35999999999,217375.35,5,1304252.1100000001,0,"Yes","No",0,null,1181002.1100000001,14650,69260,139340,0,1404252.11,-100000,"Budget table has row highlighted 1 FTE for BHRN management/communications\nwhich totals  the variance of $100,000",0.84101857607320951,1.0432599599227235E-2,4.9321627866380773E-2,9.9227196461182457E-2,0]
[null,"No_Wrong_Door_BHRN_Providers","No Wrong Door BHRN Providers",null,"Columbia CountyIron Tribe Network","Columbia","09","Columbia County","05",176764,"Iron Tribe Network","Iron Tribe Network","062",true,"2023-06-29","Valid",null,null,null,null,null,"2023-07-01","2023-01-02","2023-01-02","Yes",null,176764,"176764-0","2022-06-27",null,null,"2022-07-08","2022-07-05","2022-07-08","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-04",1151036,1151036,0,460414.4,115103.6,6,1151036,0,"Yes","No",0,null,214209,2850,398977,535000,0,1151036,0,null,0.18610104288658216,2.4760302892350892E-3,0.34662425849408707,0.46479866833009564,0]
[null,"Polk","Polk",null,"Columbia CountyMedicine Wheel Recovery","Columbia","09","Columbia County","05",176770,"Medicine Wheel Recovery","Medicine Wheel Recovery Services","077",true,"2023-04-10","Valid",true,170486,null,null,null,null,null,null,null,null,176770,"176770-0","2022-06-23",null,null,"2022-07-08","2022-07-01","2022-07-08","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-31",874955,874955,0,349982,87495.5,6,874955,0,"Yes","No",349982,0,725600,58500,45855,45000,null,874955,0,"Received the budget with a 179763 as the grant number. The grant number in CLM in the grant agreement is 176770",0.82929979256076025,6.6860581401329208E-2,5.240840957534959E-2,5.1431216462560929E-2,0]
[null,"Sherman","Sherman",null,"Columbia CountyYouth ERA","Columbia","09","Columbia County","05",176860,"Youth ERA","Youth ERA",157,true,"2022-10-06","Valid",null,null,null,null,null,null,null,null,null,null,176860,"176860-0","2022-07-09",null,null,"2022-07-08","2022-07-08","2022-07-08","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-07",181787,181787,0,72714.8,18178.7,6,181787,0,"Yes","No",72714.8,0,129671,2700,25705,null,23711,181787,0,null,0.71331283315088534,1.4852547211846832E-2,0.14140175040019362,0,0.13043286923707414]
[null,"Tillamook","Tillamook",null,"CoosAdapt","Coos",11,"Coos","06",177222,"Adapt","Adapt","001",true,"2023-06-10","Valid",true,172298,null,null,null,null,null,null,null,null,177222,"177222-0","2022-07-26",null,null,"2022-08-04",null,"2022-08-04","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,null,null,1385000,-1385000,554000,138500,6,1385000,0,"Yes","No",554000,0,828000,67000,370000,120000,0,1385000,0,null,0.59783393501805049,4.8375451263537907E-2,0.26714801444043323,8.6642599277978335E-2,0]
[null,"Umatilla","Umatilla",null,"CoosBay Area First Step Inc.","Coos",11,"Coos","06",177229,"Bay Area First Step Inc.","Bay Area First Step Inc.","007",true,"2023-03-17","Valid",true,170472,null,null,null,null,null,null,null,null,177229,"177229-0","2022-07-24",null,null,"2022-08-04","2022-07-26","2022-08-04","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-25",null,2540435.36,-2540435.36,1016174.14,254043.54,6,2540435.38,-2.00000000186265E-2,"Yes","No",1016174.14,0,430861,0,209940.66,1690000,209633.7,2540435.36,0,null,0.16960124504014149,0,8.2639638585411596E-2,0.6652403074723382,8.2518808902108817E-2]
[null,"Union","Union",null,"CoosCoos Health & Wellness","Coos",11,"Coos","06",177242,"Coos Health & Wellness",null,"037",null,null,null,null,null,null,null,null,null,null,null,null,null,177242,"177242-0","2022-09-07",null,null,"2022-08-04","2022-08-03","2022-08-04","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-09-02",null,295080,-295080,118032,29508,6,295080,0,"Yes","No",0,null,250800,19200,0,25080,0,295080,0,null,0.84993899959333064,6.506710044733631E-2,0,8.4993899959333069E-2,0]
[null,"Wallowa","Wallowa",null,"CoosHIV Alliance","Coos",11,"Coos","06",177223,"HIV Alliance","HIV Alliance","058",true,"2022-09-21","Valid",true,172261,null,null,null,null,null,null,null,null,177223,"177223-0","2022-07-24",null,null,"2022-08-04","2022-07-28","2022-08-04","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-27",null,272586,-272586,109034.4,27258.6,6,272586,0,"Yes","No",109034.4,0,194910,2000,50896,0,24781,272587,-1,"Computers (Start-Up)\nis not brought over into the totals column",0.71503776775855044,7.3371070520604435E-3,0.18671470026083414,0,9.0910424928554917E-2]
[null,"Wasco","Wasco",null,"CoosYouth ERA","Coos",11,"Coos","06",177230,"Youth ERA","Youth ERA",157,true,"2022-10-06","Valid",null,null,null,null,null,null,null,null,null,null,177230,"177230-0","2022-07-27",null,null,"2022-08-04",null,"2022-08-04","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,null,null,177004,-177004,70801.600000000006,17700.400000000001,6,177004,0,"Yes","No",70801.600000000006,0,121892,2700,29325.5,0,23086,177003.5,0.5,null,0.68864175002189221,1.5253935656639558E-2,0.16567751485140125,0,0.13042679947006697]
[null,"Washington","Washington",null,"CrookBestCare Treatment Services, Inc.","Crook",13,"Crook","07",176690,"BestCare Treatment Services, Inc.","BestCare Treatment Services, Inc.","009",true,"2023-03-12","Valid",true,170901,null,null,null,null,null,null,null,null,176690,"176690-0","2022-06-28",null,null,"2022-07-07","2022-07-07","2022-07-07","Yes",null,"Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-06",1501318,1501318.51,-0.510000000009313,600527.41,150131.85,6,1501318.51,0,"Yes","No",0,null,711552.53,8150,62165.98,719450,0,1501318.51,0,"Number of quarters is not in the MOU",0.47395174658840383,5.4285615915039909E-3,4.1407589119779785E-2,0.47921210270031239,0]
[null,"Wheeler","Wheeler",null,"CrookRimrock Trails Treatment Services","Crook",13,"Crook","07",176689,"Rimrock Trails Treatment Services","Rimrock Trails Treatment Services",119,true,"2022-11-07","Valid",null,null,null,null,null,null,null,null,null,null,176689,"176689-0","2022-06-17",null,null,"2022-07-07","2022-07-07","2022-07-07","Yes",null,"Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-06",352855,352855,0,141142,35285.5,6,352855,0,"Yes","No",141142,0,268032.96999999997,10026,33472,48790,36032,396352.97,-43497.97,null,0.67624816839394442,2.5295634847898329E-2,8.4449979017439947E-2,0.12309734931467778,9.0908868426039555E-2]
[null,"Brightside","Brightside",null,"CurryAdapt","Curry",15,"Curry","08",176579,"Adapt","Adapt","001",true,"2023-06-10","Valid",true,172298,null,null,null,null,null,null,null,null,176579,"176579-0","2022-06-14","2022-06-14","2022-07-14",null,"2022-07-05","2022-07-05","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-04",1312468.46,1312468.46,0,524987.42000000004,131246.84,6,1312468.46,0,"Yes","No",524987.42000000004,0,396000,63000,364930,488538.46,0,1312468.46,0,null,0.30172153622647818,4.8001153490576071E-2,0.2780485864018401,0.37222872388110573,0]
[null,"Yamhill_County","Yamhill County",null,"CurryBrookings Community Resource Response","Curry",15,"Curry","08",176575,"Brookings Community Resource Response","Brookings Community Resource Response","014",true,"2022-07-09","Expired",null,null,null,null,null,null,null,null,null,null,176575,"176575-0","2022-06-13","2022-06-14","2022-07-14",null,"2022-07-05","2022-07-05","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-04",250000,250000,0,100000,25000,6,250000,0,"Yes","No",100000,0,null,null,null,null,null,0,null,"Budget in the folder appears to be a balance sheet","","","","",""]
[null,null,null,null,"DeschutesBestCare Treatment Services, Inc.","Deschutes",17,"Deschutes","09",177287,"BestCare Treatment Services, Inc.","BestCare Treatment Services, Inc.","009",true,"2023-03-13","Valid",true,170901,null,null,null,null,null,null,null,null,177287,"177287-0","2022-07-29",null,null,"2022-07-07","2022-07-06","2022-07-06","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-05",null,5493639.7199999997,-5493639.7199999997,2197455.9,549363.97,6,5493639.7199999997,0,"Yes","No",2197455.9,0,2879106.39,48400,506733.33,2059400,0,5493639.7199999997,0,null,0.52407994275969749,8.8101882298171532E-3,9.2240000405414288E-2,0.37486986860507121,0]
[null,null,null,null,"DeschutesBoulder Care, Inc.","Deschutes",17,"Deschutes","09",177291,"Boulder Care, Inc.","Boulder Care, Inc.","010",true,"2022-11-25","Valid",null,null,null,null,null,null,"2023-05-07","2023-05-07","No","No workers compensation amount",177291,"177291-0","2022-08-08",null,null,"2022-07-07","2022-07-06","2022-07-06","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-05",null,409800,-409800,163920,40980,6,409800,0,"Yes","No",163920,0,null,null,null,null,null,0,null,"No budget information has been provided.","","","","",""]
[null,null,null,null,"DeschutesDeschutes County Health Services","Deschutes",17,"Deschutes","09",177290,"Deschutes County Health Services","Deschutes County","040",null,null,null,true,170856,null,null,null,null,null,null,null,null,177290,"177290-0","2022-09-07",null,null,"2022-07-07","2022-07-01","2022-07-01","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-31",null,2890046,-2890046,481674.35,481674.33,5,2890046,0,"Yes","No",0,null,2066508,20000,470806,70000,262731,2890045,1,null,0.71504353738436599,6.920307469260859E-3,0.1629061139186414,2.4221076142413006E-2,9.0908965085318746E-2]
[null,null,null,null,"DeschutesHealing Reins Therapeutic Riding Center","Deschutes",17,"Deschutes","09",177292,"Healing Reins Therapeutic Riding Center","Healing Reins Therapeutic Riding Center, Inc.","056",true,"2023-01-04","Valid",null,null,null,null,null,"2023-04-01",-1,"2023-07-21","Yes",null,177292,"177292-0","2022-08-02",null,null,"2022-07-07","2022-07-01","2022-07-01","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-31",null,367135,-367135,146854,36713.5,6,367135,0,"Yes","No",146854,0,247911,12346,28201,78677,0,367135,0,null,0.67525841992727476,3.3627957018535416E-2,7.6813706129897727E-2,0.21429991692429215,0]
[null,null,null,null,"DeschutesIdeal Option","Deschutes",17,"Deschutes","09",177301,"Ideal Option","Ideal Option PLLC","061",true,"2023-06-13","Valid",null,null,null,null,null,"2023-05-01","2023-05-01","2023-05-01","Yes",null,177301,"177301-0","2022-08-19",null,null,"2022-07-07","2022-07-06","2022-07-06","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-05",null,1170164,-1170164,468065.6,117016.4,6,1170164,0,"Yes","No",0,null,318500,0,810414,41250,0,1170164,0,null,0.27218406992524125,0,0.6925644610499041,3.5251469024854633E-2,0]
[null,null,null,null,"DeschutesRimrock Trails Treatment Services","Deschutes",17,"Deschutes","09",177288,"Rimrock Trails Treatment Services","Rimrock Trails Treatment Services",119,true,"2022-11-07","Valid",null,null,null,null,null,null,null,null,null,null,177288,"177288-0","2022-08-08",null,null,"2022-07-07","2022-07-06","2022-07-06","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-05",null,1190079.69,-1190079.69,476031.93,119007.96,6,1190079.69,0,"Yes","No",476031.93,0,908774.08,55242,40947,76927.55,108189.06,1190079.69,0,null,0.76362456030150383,4.6418740244193228E-2,3.440693958906231E-2,6.4640671247822079E-2,9.090908861741856E-2]
[null,null,null,null,"DouglasAdapt","Douglas",19,"Douglas",10,177084,"Adapt","Adapt","001",true,"2023-06-10","Valid",true,172298,null,null,null,null,null,null,null,null,177084,"177084-0","2022-07-12","2022-07-18","2022-08-17","2022-08-18","2022-08-16","2022-08-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-09-15",7747527,7747527,0,3099010.8,774752.7,6,7747527,0,"Yes","No",0,null,1818000,209000,1100527,4620000,0,7747527,0,null,0.23465552298172049,2.6976350001748944E-2,0.14204881118839599,0.59631931582813458,0]
[null,null,null,null,"DouglasBoulder Care, Inc.","Douglas",19,"Douglas",10,177087,"Boulder Care, Inc.","Boulder Care, Inc.","010",true,"2022-11-25","Valid",null,null,null,null,null,null,"2023-05-07","2023-05-07","No","No workers compensation amount",177087,"177087-0","2022-07-18","2022-07-18","2022-08-17","2022-08-18","2022-08-16","2022-08-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-09-15",210251,210251,0,35041.85,35041.83,5,210251,0,"Yes","No",35041.85,0,null,null,null,null,null,0,null,"No budget has been uploaded. Only narratives.","","","","",""]
[null,null,null,null,"DouglasHIV Alliance","Douglas",19,"Douglas",10,177089,"HIV Alliance","HIV Alliance","058",true,"2022-09-21","Valid",true,172261,null,null,null,null,null,null,null,null,177089,"177089-0","2022-07-11","2022-07-18","2022-08-17","2022-08-18","2022-08-18","2022-08-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-09-17",575371,575371,0,230148.4,57537.1,6,575371,0,"Yes","No",0,null,331968,2500,84250,0,52306,471024,104347,"Does not add up to total",0.70477937429939874,5.3075851761269065E-3,0.17886562043547674,0,0.11104742008899759]
[null,null,null,null,"GilliamBoulder Care, Inc.","Gilliam",21,"Gilliam",11,176484,"Boulder Care, Inc.","Boulder Care, Inc.","010",true,"2022-11-25","Valid",null,null,null,null,null,null,"2023-05-07","2023-05-07","No","No workers compensation amount",176484,"176484-0","2022-06-13","2022-06-13","2022-07-13","2022-06-22","2022-06-21","2022-06-22","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-21",40000,40000,0,16000,4000,6,40000,0,"Yes","No",16000,0,null,null,null,null,0,0,null,"No budget has been uploaded. Only narratives.","","","","",""]
[null,null,null,null,"GilliamCommunity Counseling Solutions","Gilliam",21,"Gilliam",11,176480,"Community Counseling Solutions","Community Counseling Solutions","031",true,"2022-11-02","Valid",null,null,null,null,null,null,null,null,null,null,176480,"176480-0","2022-06-13","2022-06-13","2022-07-13","2022-06-22","2022-06-22","2022-06-22","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-22",710000,710000,0,284000,71000,6,710000,0,"Yes","No",284000,0,377926,0,292875,39199,0,710000,0,null,0.53229014084507043,0,0.41249999999999998,5.5209859154929576E-2,0]
[null,null,null,null,"GrantBoulder Care, Inc.","Grant",23,"Grant",12,176486,"Boulder Care, Inc.","Boulder Care, Inc.","010",true,"2022-11-25","Valid",null,null,null,null,null,null,"2023-05-07","2023-05-07","No","No workers compensation amount",176486,"176486-0","2022-06-13","2022-06-13","2022-07-13","2022-06-22","2022-06-21","2022-06-22","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-21",40000,40000,0,16000,4000,6,40000,0,"Yes","No",16000,0,null,null,null,null,null,0,null,"No budget has been uploaded. Only narratives.","","","","",""]
[null,null,null,null,"GrantCommunity Counseling Solutions","Grant",23,"Grant",12,176488,"Community Counseling Solutions","Community Counseling Solutions","031",true,"2022-11-02","Valid",null,null,null,null,null,null,null,null,null,null,176488,"176488-0","2022-06-08","2022-06-13","2022-07-13","2022-06-22","2022-06-22","2022-06-22","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-22",710000,710000,0,284000,71000,6,710000,0,"Yes","No",568000,284000,337384,0,304994,67622,0,710000,0,null,0.47518873239436621,0,0.42956901408450704,9.5242253521126766E-2,0]
[null,null,null,null,"HarneySymmetry Care, Inc.","Harney",25,"Harney",13,176143,"Symmetry Care, Inc.","Symmetry Care, Inc.",130,true,"2023-04-12","Valid",null,null,null,null,null,null,null,null,null,null,176143,"176143-0","2022-05-24","2022-05-24","2022-06-23",null,"N/A","N/A","No MOU Required","No MOU Required","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-06-23",857711.54,857711.54,0,343084.64,85771.15,6,857711.54,0,"Yes","No",343084.64,0,70000,null,280711,1257000,null,1607711,-749999.46,"Need to provide a revised budget",4.3540163623934897E-2,0,0.17460289815769128,0.78185693821837388,0]
[null,null,null,null,"Hood River CountyColumbia Gorge Health Council","Hood River",27,"Hood River County",14,"2714029","Columbia Gorge Health Council","Columbia Gorge Health Council","029",true,"2022-08-20","Expired",null,null,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,0,0,"No","No",0,null,0,0,0,0,0,0,null,"They have withdrawn from M110","","","","",""]
[null,null,null,null,"Hood River CountyHood River County Health Dept.","Hood River",27,"Hood River County",14,176749,"Hood River County Health Dept.","Hood River County Health Department","059",null,null,null,null,null,null,null,null,null,null,null,null,null,176749,"176749-0","2022-08-14",null,null,"2022-09-09",null,null,null,null,"Within 30 Days",0,null,null,null,null,null,null,null,null,null,null,null,81435,81435,0,32574,8143.5,6,81435,0,"No","Paid without MOU",32574,0,77864.039999999994,0,3571.02,0,0,81435.06,-5.9999999997671701E-2,null,0.95614886266431187,0,4.3851137335688094E-2,0,0]
[null,null,null,null,"Hood River CountyMid-Columbia Center for Living","Hood River",27,"Hood River County",14,176750,"Mid-Columbia Center for Living",null,"079",null,null,null,null,null,null,null,null,null,null,null,null,null,176750,"176750-0","2022-06-22",null,null,"2022-09-09",null,null,null,null,"Within 30 Days",0,null,null,null,null,null,null,null,null,null,null,null,950914,950914,0,158485.70000000001,158485.66,5,950914,0,"No","Paid without MOU",158485.70000000001,0,430110,0,94359,300000,0,824469,126445,"They need to modify their budget by adding the 126445 amount",0.52168122755373458,0,0.11444820848327833,0.36387056396298706,0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(H67,K67)","v":"Hood River CountyOne Community Health"},"Hood River",27,"Hood River County",14,176752,"One Community Health","One Community Health","093",true,"2023-03-12","Valid",null,null,null,null,null,null,null,null,null,null,176752,"176752-0","Pending",null,null,"2022-09-09",null,null,null,null,"Within 30 Days",0,null,null,null,null,null,null,null,null,null,null,null,121637,121637,0,48654.8,12163.7,6,121637,0,"No","No",0,null,225987.94,11770,10324,0,0,248081.94,-126444.94,"They need to provide a revised budget.",0.91094071579736924,4.7444001768125479E-2,4.161528243450531E-2,0,0]
[null,null,null,null,"Hood River CountyProvidence Hood River","Hood River",27,"Hood River County",14,176755,"Providence Hood River","Providence Hood River Memorial Hospital",109,true,"2023-04-29","Valid",null,null,null,null,null,"2023-01-01","2023-06-01","2023-06-01","Yes",null,176755,"176755-0","2022-07-09",null,null,"2022-09-09",null,null,null,null,"Within 30 Days",0,null,null,null,null,null,null,null,null,null,null,null,147181,147181,0,58872.4,14718.1,6,147181,0,"No","Paid without MOU",58872.4,0,103297,16904,26980,0,0,147181,0,null,{"$f":"IFERROR(BJ68/$BO68,\"\")","v":0.70183651422398274},0.1148517811402287,{"$f":"IFERROR(BL68/$BO68,\"\")","v":0.18331170463578858},{"$f":"IFERROR(BM68/$BO68,\"\")","v":0},{"$f":"IFERROR(BN68/$BO68,\"\")","v":0}]
[null,null,null,null,"Jackson CountyStabbin' Wagon","Jackson",29,"Jackson County",16,"2916129","Stabbin' Wagon","Stabbin Wagon",129,true,"2023-07-20","Valid",null,null,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,582396,582396,0,null,null,null,null,null,"No","No",0,null,208034.44,7200,325561,42600,0,583395.43999999994,-999.43999999994401,"Cannot find any Jackson County orgs in CLM",0.35659250267708642,1.2341543156388059E-2,0.55804515715789627,7.3020797008629346E-2,0]
[null,null,null,null,"Jackson CountyAddiction Recovery Center","Jackson",29,"Jackson County",16,"2916003","Addiction Recovery Center","Addiction Recovery Center, Inc.","003",true,"2023-04-08","Valid",true,170480,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,1109347,1109347,0,443738.8,133121.64000000001,5,1109347,0,"No","No",0,null,1109347.49,0,0,0,0,1109347.49,-0.489999999990687,"Cannot find any Jackson County orgs in CLM",1,0,0,0,0]
[null,null,null,null,"Jackson CountyColumbiaCare Services","Jackson",29,"Jackson County",16,"2916030","ColumbiaCare Services","ColumbiaCare Services, Inc.","030",true,"2023-04-17","Valid",null,null,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,390319,390319,0,null,null,null,null,null,"No","No",0,null,364620,0,16448,9251,0,390319,0,"Cannot find any Jackson County orgs in CLM",0.93415898278075116,0,4.2139890704782496E-2,2.3701126514466372E-2,0]
[null,null,null,null,"Jackson CountyCommunity Works","Jackson",29,"Jackson County",16,"2916034","Community Works","Community Works, Inc.","034",true,"2023-05-03","Valid",null,null,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,119617,119617,0,19936.2,19936.16,5,119617,0,"No","No",0,null,103564.44,0,0,0,16052.49,119616.93,7.0000000006984905E-2,"Cannot find any Jackson County orgs in CLM",0.86580085277226237,0,0,0,0.13419914722773776]
[null,null,null,null,"Jackson CountyCompass House","Jackson",29,"Jackson County",16,"2916035","Compass House","Compass House, Inc.","035",true,"2023-03-14","Valid",null,null,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,76480,76480,0,null,null,null,null,null,"No","No",0,null,72666,0,1564.05,2250,0,76480.05,-5.0000000002910397E-2,"Cannot find any Jackson County orgs in CLM",0.95013013197559359,0,2.0450431190879189E-2,2.9419436833527175E-2,0]
[null,null,null,null,"Jackson CountyFamily Nurturing Center","Jackson",29,"Jackson County",16,"2916045","Family Nurturing Center","The Family Nurturing Center","045",true,"2022-10-29","Valid",null,null,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,1367463,1367463,0,null,null,null,null,null,"No","No",0,null,1023423.06,12000,287040,45000,0,1367463.06,-6.0000000055879403E-2,"Cannot find any Jackson County orgs in CLM",0.74841002286379865,8.7753741589187782E-3,0.20990694988133718,3.290765309594542E-2,0]
[null,null,null,null,"Jackson CountyHIV Alliance","Jackson",29,"Jackson County",16,"2916058","HIV Alliance","HIV Alliance","058",true,"2022-09-21","Valid",true,172261,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,104358,75240,29118,null,null,null,null,null,"No","No",0,null,0,0,69871,25000,9487,104358,-29118,"Cannot find any Jackson County orgs in CLM",0,0,0.66953180398244505,0.23955997623565037,9.0908219781904595E-2]
[null,null,null,null,"Jackson CountyJackson County Health & Human Services","Jackson",29,"Jackson County",16,"2916063","Jackson County Health & Human Services","Jackson County Health & Human Services","063",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,610527,610527,0,null,null,null,null,null,"No","No",0,null,404264.05,0,157000,0,49263,610527.05000000005,-5.0000000046566101E-2,"Cannot find any Jackson County orgs in CLM",0.66215583732121286,0,0.25715486316290159,0,8.0689299515885493E-2]
[null,null,null,null,"Jackson CountyLa Clinica","Jackson",29,"Jackson County",16,"2916067","La Clinica","La Clinica del Valle Family Health Center, Inc","067",true,"2022-10-26","Valid",true,170798,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,1502327,1502327,0,null,null,null,null,null,"No","No",0,null,1188090,4087.44,116343.9,0,193806,1502327.34,-0.34000000008381898,"Cannot find any Jackson County orgs in CLM",0.79083297518901574,2.7207386108010255E-3,7.7442443402514383E-2,0,0.12900384279766886]
[null,null,null,null,"Jackson CountyMax's Mission","Jackson",29,"Jackson County",16,"2916076","Max's Mission","Max's Mission","076",true,"2022-11-28","Valid",true,170817,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,719798,719798,0,null,null,null,null,null,"No","No",0,null,332370,1800,301229,69530,0,704929,14869,"Spreadsheet does not add correctly",0.47149429233298673,2.5534486451827061E-3,0.42731821218874527,9.8634046833085312E-2,0]
[null,null,null,null,"Jackson CountyOasis Center of Rogue Valley","Jackson",29,"Jackson County",16,"2916090","Oasis Center of Rogue Valley","Oasis Center of Rogue Valley","090",true,"2022-11-14","Valid",true,170797,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,1425981,1425981,0,null,null,null,null,null,"No","No",0,null,483931.2,5750,152900,783400,0,1425981.2,-0.19999999995343401,"Cannot find any Jackson County orgs in CLM",0.33936716697246783,4.0323112254214855E-3,0.10722441502033828,0.54937610678177251,0]
[null,null,null,null,"Jackson CountyOnTrack, Inc.","Jackson",29,"Jackson County",16,"2916094","OnTrack, Inc.","OnTrack, Inc.","094",true,"2023-05-12","Valid",null,null,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,1541627.3,1428204,113423.3,null,null,null,null,null,"No","No",0,null,733137.63,42666.67,70823,725000,0,1571627.3,-143423.29999999999,"Supplies are not accounted for in the total it appears",0.46648313502826017,2.7148084027300873E-2,4.5063482926263748E-2,0.46130529801817516,0]
[null,null,null,null,"Jackson CountyOptions for Homeless Residents of Ashland","Jackson",29,"Jackson County",16,"2916095","Options for Homeless Residents of Ashland","Options for Homeless Residents of Ashland","095",null,"2022-06-18","Expired",null,null,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,563413,327531,235882,null,null,null,null,null,"No","No",0,null,374453,null,null,null,null,374453,-46922,"Submitted budget is unclear",1,0,0,0,0]
[null,null,null,null,"Jackson CountyOptions for Southern Oregon, Inc.","Jackson",29,"Jackson County",16,"2916096","Options for Southern Oregon, Inc.","Options for Southern Oregon, Inc.","096",true,"2022-12-07","Valid",null,null,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,303873,303873,0,null,null,null,null,null,"No","No",0,null,269848,0,6400,0,27624.799999999999,303872.8,0.200000000011642,"Cannot find any Jackson County orgs in CLM",0.88802946496033874,0,2.1061444130570425E-2,0,9.0909090909090912E-2]
[null,null,null,null,"Jackson CountyPathfinder Network of Oregon","Jackson",29,"Jackson County",16,"2916","Pathfinder Network of Oregon",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-0",null,null,null,"#NO MATCH",null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,"#NO MATCH",1349947,"#INVALID OPERATION",null,null,null,null,null,"No","No",0,null,743843,12850,400531,70000,122723,1349947,0,"Cannot find any Jackson County orgs in CLM",0.55101644731237598,9.5188922231761695E-3,0.29670127790202133,5.1853887597068625E-2,9.0909494965357898E-2]
[null,null,null,null,"Jackson CountyReclaiming Lives","Jackson",29,"Jackson County",16,"2916115","Reclaiming Lives","Reclaiming Lives",115,true,"2023-01-18","Valid",null,null,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,352211,352211,0,140844.4,42265.32,5,352171,40,"No","No",0,null,374453,0,229066,0,0,603519,-251308,"Cannot find any Jackson County orgs in CLM",0.62044939761631368,0,0.37955060238368632,0,0]
[null,null,null,null,"Jackson CountyRogue Community Health","Jackson",29,"Jackson County",16,"2916121","Rogue Community Health","Rogue Community Health",121,true,"2023-01-31","Valid",null,null,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,5010125,5010125,0,null,null,null,null,null,"No","No",0,null,2480100,0,2530025,0,0,5010125,0,"Cannot find any Jackson County orgs in CLM",0.49501758938150248,0,0.50498241061849758,0,0]
[null,null,null,null,"Jackson CountyYouth ERA","Jackson",29,"Jackson County",16,"2916157","Youth ERA","Youth ERA",157,true,"2022-10-06","Valid",null,null,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,349553,349553,0,139821.20000000001,41946.36,5,349553,0,"No","No",0,null,252649,5150,46162,0,45592,349553,0,"Cannot find any Jackson County orgs in CLM",0.72277737567693601,1.4733101990256127E-2,0.13206008816974821,0,0.13042943416305969]
[null,null,null,null,"JeffersonBestCare Treatment Services, Inc.","Jefferson",31,"Jefferson",17,176375,"BestCare Treatment Services, Inc.","BestCare Treatment Services, Inc.","009",true,"2023-03-13","Valid",true,170901,null,null,null,null,null,null,null,null,176375,"176375-0","2022-05-31","2022-05-31","2022-06-30",null,"N/A","N/A","No MOU Required","No MOU Required","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-06-30",2007563.08,2007563.08,0,803025.23199999996,200756.30799999999,6,2007563.08,0,"Yes","No",803025.23,-1.9999999785795799E-3,1340033.22,0,149400,518129.98,0,2007563.2,-0.119999999878928,null,0.66749242066202452,0,7.4418578702777571E-2,0.25808900063519791,0]
[null,null,null,null,"JosephineAdapt","Josephine",33,"Josephine",18,177215,"Adapt","Adapt","001",true,"2023-06-10","Valid",true,172298,null,null,null,null,null,null,null,null,177215,"177215-0","2022-07-24",null,null,"2022-07-28","2022-07-27","2022-07-28","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-26",null,4083750,-4083750,1633500,408375,6,4083750,0,"Yes","No",1633500,0,744000,23000,350000,2966750,0,4083750,0,null,0.18218549127640038,5.6320783593510866E-3,8.5705540250994791E-2,0.72647689011325378,0]
[null,null,null,null,"JosephineGrace Roots","Josephine",33,"Josephine",18,177216,"Grace Roots","Grace Roots","052",true,"2023-03-04","Valid",null,null,null,null,null,null,"2023-08-24","2023-08-24","No","No workers compensation",177216,"177216-0","2022-08-08",null,null,"2022-07-28","2022-07-26","2022-07-28","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-25",null,1146250,-1146250,458500,114625,6,1146250,0,"Yes","No",458500,0,327250,5000,69000,745000,0,1146250,0,null,0.28549618320610687,4.3620501635768813E-3,6.0196292257360957E-2,0.64994547437295525,0]
[null,null,null,null,"JosephineGrants Pass Sobering Center","Josephine",33,"Josephine",18,177217,"Grants Pass Sobering Center","Grants Pass Sobering Center, Inc.","053",true,"2022-11-07","Valid",true,172258,null,null,null,null,null,null,null,null,177217,"177217-0","2022-07-24",null,null,"2022-07-28","2022-07-28","2022-07-28","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-27",null,229453.72,-229453.72,91781.5,22945.37,6,229453.72,0,"Yes","No",91781.5,0,206312.76,2025,21115.98,0,0,229453.74,-1.99999999895226E-2,"Budget table is off by 2 cents",0.89914751444016572,8.8253083170490056E-3,9.2027177242785405E-2,0,0]
[null,null,null,null,"JosephineHIV Alliance","Josephine",33,"Josephine",18,177226,"HIV Alliance","HIV Alliance","058",true,"2022-09-21","Valid",true,172261,null,null,null,null,null,null,null,null,177226,"177226-0","2022-07-24",null,null,"2022-07-28","2022-07-27","2022-07-28","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-26",null,323280,-323280,129312,32328,6,323280,0,"Yes","No",129312,0,170580,2000,61303,60000,29388,323271,9,"Budget table needs a revision. $9 needs to be added in",0.52766873613779153,6.1867597155327884E-3,0.18963346542065326,0.18560279146598366,9.0908247260038794E-2]
[null,null,null,null,"JosephineMax's Mission","Josephine",33,"Josephine",18,177228,"Max's Mission","Max's Mission","076",true,"2022-11-28","Valid",true,170817,null,null,null,null,null,null,null,null,177228,"177228-0","2022-07-24",null,null,"2022-07-28","2022-07-26","2022-07-28","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-25",null,505160,-505160,202064,50516,6,505160,0,"Yes","No",202064,0,158061,1900,191102,572615,0,923678,-418518,null,0.17112132149948359,2.056993887480269E-3,0.20689244520276548,0.61992923941027067,0]
[null,null,null,null,"JosephineOnTrack, Inc.","Josephine",33,"Josephine",18,177231,"OnTrack, Inc.","OnTrack, Inc.","094",true,"2023-05-12","Valid",null,null,null,null,null,null,null,null,null,null,177231,"177231-0","2022-08-16",null,null,"2022-07-28","2022-07-26","2022-07-28","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-25",null,2259707.06,-2259707.06,903882.8,225970.71,6,2259707.06,0,"Yes","No",903882.8,0,534490.39,22666.67,106193.18,1625000,null,2288350.2400000002,-28643.1800000002,"If you remove the Transitional Housing Operating Costs the budget becomes correct",0.23357018547999889,9.9052450991942553E-3,4.6405999459243612E-2,0.7101185699615632,0]
[null,null,null,null,"JosephineOptions for Southern Oregon","Josephine",33,"Josephine",18,177235,"Options for Southern Oregon","Options for Southern Oregon, Inc.","096",true,"2022-12-07","Valid",null,null,null,null,null,null,null,null,null,null,177235,"177235-0","2022-08-03",null,null,"2022-07-28","2022-07-26","2022-07-28","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-25",null,1463795.2,-1463795.2,585518.07999999996,146379.51999999999,6,1463795.2,0,"Yes","No",585518.07999999996,0,1329886,15555,111606,0,142598.20000000001,1599645.2,-135850,"They added Nurse Practitioner training which is the exact amount of 135,850",0.83136310476848241,9.7240313039416489E-3,6.9769221324828781E-2,0,8.9143642602747167E-2]
[null,null,null,null,"JosephineThe Family Nurturing Center","Josephine",33,"Josephine",18,177236,"The Family Nurturing Center","The Family Nurturing Center",133,true,"2022-10-29","Valid",null,null,null,null,null,null,null,null,null,null,177236,"177236-0","Pending",null,null,"2022-07-28","2022-07-27","2022-07-28","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-26",null,713619.14,-713619.14,118936.54,118936.52,5,713619.14,0,"Yes","No",0,null,494409.14,22470,196740,0.01,null,713619.15,-1.00000000093132E-2,"They added .01 to Capital Outlay Costs",0.69281932806876045,3.1487383711605831E-2,0.27569327420655682,1.4013076863197968E-8,0]
[null,null,null,null,"KlamathMax's Mission","Klamath",35,"Klamath",19,177228,"Max's Mission","Max's Mission","076",true,"2022-11-28","Valid",true,170817,null,null,null,null,null,null,null,null,177228,"177228-0","2022-07-24",null,null,"2022-09-08",null,"2022-09-08","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,null,null,505160,-505160,202064,50516,6,505160,0,"Yes","No",202064,0,158061,1900,191102,572615,0,923678,-418518,null,0.17112132149948359,2.056993887480269E-3,0.20689244520276548,0.61992923941027067,0]
[null,null,null,null,"KlamathRed is the Road to Wellness","Klamath",35,"Klamath",19,177593,"Red is the Road to Wellness","Red is the Road to Wellness",117,true,"2023-01-06","Valid",true,172262,null,null,null,null,null,null,null,null,177593,"177593-0","Pending",null,null,"2022-09-08",null,"2022-09-08","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,null,null,1552833,-1552833,621133.19999999995,155283.29999999999,6,1552833,0,"Yes","No",0,null,480000,34296,477537,561000,0,1552833,0,"No budget in CLM",0.30911244158257845,2.2086083951075228E-2,0.3075263083667078,0.36127516609963856,0]
[null,null,null,null,"KlamathThe Stronghold","Klamath",35,"Klamath",19,177608,"The Stronghold",null,138,null,null,null,null,null,null,null,null,null,null,null,null,null,177608,"177608-0","2022-08-23",null,null,"2022-09-08",null,"2022-09-08","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,null,null,816371.27,-816371.27,326548.49,81637.13,6,816371.27,0,"Yes","No",0,null,683770.66,5550,81116.61,45934,null,816371.27,0,null,0.8375731546750782,6.7983774098272715E-3,9.9362401619057461E-2,5.6266066296037094E-2,0]
[null,null,null,null,"KlamathKlamath Basin Behavioral Health","Klamath",35,"Klamath",19,177588,"Klamath Basin Behavioral Health","Klamath Basin Behavioral Health","066",true,"2023-07-11","Valid",null,null,null,null,null,null,null,null,null,null,177588,"177588-0","2022-08-30",null,null,"2022-09-08",null,"2022-09-08","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,null,null,425630,-425630,170252,51075.6,5,425630,0,"Yes","No",0,null,473305,0,33250,0,0,506555,-80925,"Can not find grant in CLM",0.93436053340703373,0,6.5639466592966211E-2,0,0]
[null,null,null,null,"KlamathLutheran Community Services","Klamath",35,"Klamath",19,177595,"Lutheran Community Services","Lutheran Community Services Northwest","074",true,"2023-01-04","Valid",true,170487,null,null,null,"2023-01-01","2022-07-31","2023-07-31","Yes",null,177595,"177595-0","2022-08-31",null,null,"2022-09-08",null,"2022-09-08","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,null,null,771433,-771433,128572.15,128572.17,5,771433,0,"Yes","No",0,null,380324,null,null,null,784613,1164937,-393504,null,0.32647602402533354,0,0,0,0.6735239759746664]
[null,null,null,null,"KlamathTransformations","Klamath",35,"Klamath",19,177603,"Transformations","Transformation Wellness Center",143,true,"2023-03-08","Valid",true,170489,null,null,null,null,null,null,null,null,177603,"177603-0","Pending",null,null,"2022-09-08",null,"2022-09-08","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,null,null,1491158.84,-1491158.84,596463.56000000006,149115.88,6,1491158.84,0,"Yes","No",0,null,1484587.82,50000,202800,null,null,1737387.82,-246228.98,"Budget does not match NTE amount",0.85449420268181686,2.8778836494893809E-2,0.11672696082328929,0,0]
[null,null,null,null,"LakeNorth Lake Health Center, Inc.","Lake",37,"Lake",20,176492,"North Lake Health Center, Inc.","North Lake Health Center, Inc.","086",true,"2023-03-10","Valid",null,null,null,null,null,null,null,null,null,null,176492,"176492-0","2022-06-07","2022-06-07","2022-07-07",null,"N/A","N/A","No MOU Required","No MOU Required","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-07",1233986,1233986.67,-0.66999999992549397,493594.65,123398.67,6,1233986.67,0,"Yes","No",493594.65,0,457297,17500,644189,115000,0,1233986,0.66999999992549397,null,0.37058524164779827,1.4181684395122797E-2,0.52203914793198625,9.319392602509266E-2,0]
[null,null,null,null,"Lane BHRN 1Community Outreach Through Radical Empowerment (CORE)","Lane",39,"Lane BHRN 1","#NO MATCH",177577,"Community Outreach Through Radical Empowerment (CORE)","Community Outreach Through Radical Empowerment","032",true,"2023-03-29","Valid",null,null,null,null,null,null,"2023-06-22","2023-06-22","No","No workers compensation amount",177577,"177577-0","2022-08-29","#NO MATCH","#NO MATCH","2022-08-15","2022-08-12","2022-08-15","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-09-11",null,1086254,-1086254,434501.6,108625.4,6,1086254,0,"Yes","No",0,null,576004,500,351050,130200,28500,1086254,0,null,0.53026640178079898,4.602974994798638E-4,0.32317487438481241,0.11986146886455654,2.6236957470352238E-2]
[null,null,null,null,"Lane BHRN 1Daisy C.H.A.I.N.","Lane",39,"Lane BHRN 1","#NO MATCH",177587,"Daisy C.H.A.I.N.","Daisy C.H.A.I.N. Creating Healthy Alliances in New-Mothering","039",true,"2022-09-20","Valid",true,171712,null,null,null,null,null,null,null,null,177587,"177587-0","2022-08-28","#NO MATCH","#NO MATCH","2022-08-15","2022-08-14","2022-08-15","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-09-13",null,1102215,-1102215,440886,110221.5,6,1102215,0,"Yes","No",0,null,749128,60475,258112,null,34500,1102215,0,null,0.6796568727516864,5.4866790961835943E-2,0.23417572796595945,0,3.1300608320518231E-2]
[null,null,null,null,"Lane BHRN 1Ideal Option","Lane",39,"Lane BHRN 1","#NO MATCH",177583,"Ideal Option","Ideal Option PLLC","061",true,"2023-06-13","Valid",null,null,null,null,null,"2023-05-01","2023-05-01","2023-05-01","Yes",null,177583,"177583-0","2022-08-19","#NO MATCH","#NO MATCH","2022-08-15","2022-08-15","2022-08-15","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-09-14",null,312970,-312970,125188,31297,6,312970,0,"Yes","No",0,null,269170,null,15900,27900,null,312970,0,null,0.86005048407195572,0,5.0803591398536602E-2,8.914592452950762E-2,0]
[null,null,null,null,"Lane BHRN 1OSLC Developments, Inc.","Lane",39,"Lane BHRN 1","#NO MATCH",177563,"OSLC Developments, Inc.","OSLC Developments, Inc.","099",true,"2023-03-13","Valid",null,null,null,null,null,"2023-04-01","2023-06-22","2023-06-22","Yes",null,177563,"177563-0","2022-08-28","#NO MATCH","#NO MATCH","2022-08-15","2022-08-14","2022-08-15","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-09-13",null,2402469,-2402469,960987.6,240246.9,6,2402469,0,"Yes","No",0,null,1435890,125025,241580,199560,400414,2402469,0,null,0.59767264426721012,5.2040213630227906E-2,0.1005548874928251,8.3064547346916859E-2,0.16666770726282004]
[null,null,null,null,"Lane BHRN 1South Lane Mental Health Services, Inc.","Lane",39,"Lane BHRN 1","#NO MATCH",177570,"South Lane Mental Health Services, Inc.","South Lane Mental Health Services, Inc.",127,true,"2023-01-26","Valid",true,172331,null,null,null,null,null,null,null,null,177570,"177570-0","2022-08-23","#NO MATCH","#NO MATCH","2022-08-15","2022-08-14","2022-08-15","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-09-13",null,509166,-509166,203666.4,50916.6,6,509166,0,"Yes","No",0,null,506956,2210,0,0,0,509166,0,null,0.99565956878503281,4.3404312149672207E-3,0,0,0]
[null,null,null,null,"Lane BHRN 1Youth ERA","Lane",39,"Lane BHRN 1","#NO MATCH",177574,"Youth ERA","Youth ERA",157,true,"2022-10-06","Valid",null,null,null,null,null,null,null,null,null,null,177574,"177574-0","2022-09-02","#NO MATCH","#NO MATCH","2022-08-15","2022-08-15","2022-08-15","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-09-14",null,356044,-356044,142417.60000000001,35604.400000000001,6,356044,0,"Yes","No",0,null,252649,5150,93845,4400,null,356044,0,null,0.70960049881475318,1.4464504387098225E-2,0.2635769736324724,1.2358023165676153E-2,0]
[null,null,null,null,"Lane BHRN 2Addiction Counseling and Education Services (Emergence)","Lane",39,"Lane BHRN 2","#NO MATCH",177585,"Addiction Counseling and Education Services (Emergence)",null,"002",null,null,null,null,null,null,null,null,null,null,null,null,null,177585,"177585-0","2022-08-23","#NO MATCH","#NO MATCH","2022-08-24","2022-08-18","2022-08-24","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-09-17",null,1486715,-1486715,247785.85,247785.83,5,1486715,0,"Yes","No","#INVALID OPERATION","#INVALID OPERATION",1216400,50850,219425.4,0,0,1486675.4,39.600000000093097,null,0.8182014715518936,3.4203834946081708E-2,0.14759469350202473,0,0]
[null,null,null,null,"Lane BHRN 2Center for Family Development","Lane",39,"Lane BHRN 2","#NO MATCH",177586,"Center for Family Development","Center for Family Development, Inc.","018",true,"2022-10-15","Valid",true,172072,null,null,null,null,null,null,null,null,177586,"177586-0","2022-08-23","#NO MATCH","#NO MATCH","2022-08-24","2022-08-17","2022-08-24","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-09-16",null,1001989,-1001989,400795.6,100198.9,6,1001989,0,"Yes","No",0,null,600086.25,12000,389902.86,0,0,1001989.11,-0.10999999998602999,null,0.59889498200234936,1.1976178064450222E-2,0.38912883993320047,0,0]
[null,null,null,null,"Lane BHRN 2HIV Alliance","Lane",39,"Lane BHRN 2","#NO MATCH",177580,"HIV Alliance","HIV Alliance","058",true,"2022-09-21","Valid",true,172261,null,null,null,null,null,null,null,null,177580,"177580-0","2022-08-23","#NO MATCH","#NO MATCH","2022-08-15","2022-08-23","2022-08-24","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-09-22",null,1302583,-1302583,521033.2,130258.3,6,1302583,0,"Yes","No",0,null,917256,2500,199410,65000,0,1184166,118417,null,0.77460085832560632,2.1111904918736054E-3,0.16839699839380629,5.4890952788713747E-2,0]
[null,null,null,null,"Lane BHRN 2Housing Our Veterans","Lane",39,"Lane BHRN 2","#NO MATCH",177578,"Housing Our Veterans","Housing Our Veterans, Inc.","060",true,"2023-05-09","Valid",null,null,null,null,null,null,null,null,null,null,177578,"177578-0","2022-08-23","#NO MATCH","#NO MATCH","2022-08-24","2022-08-18","2022-08-24","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-09-17",null,978735,-978735,391494,97873.5,6,978735,0,"Yes","No",0,null,79560,1500,837675,60000,0,978735,0,null,8.1288602124170481E-2,1.5325905377860196E-3,0.85587518582660271,6.1303621511440788E-2,0]
[null,null,null,null,"Lane BHRN 2Laurel Hill Center","Lane",39,"Lane BHRN 2","#NO MATCH",177572,"Laurel Hill Center","Laurel Hill Center","068",true,"2023-01-09","Valid",null,null,null,null,null,null,null,null,null,null,177572,"177572-0","2022-08-23","#NO MATCH","#NO MATCH","2022-08-24","2022-08-18","2022-08-24","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-09-17",null,938075,-938075,156345.85,156345.82999999999,5,938075,0,"Yes","No",0,null,287955,0,621120,29000,0,938075,0,null,0.30696372891293339,0,0.66212189856887771,3.0914372518188845E-2,0]
[null,null,null,null,"Lane BHRN 2Looking Glass Community Services","Lane",39,"Lane BHRN 2","#NO MATCH",177573,"Looking Glass Community Services","Looking Glass Community Services","073",true,"2023-02-24","Valid",null,null,null,null,null,null,null,null,null,null,177573,"177573-0","2022-08-19","#NO MATCH","#NO MATCH","2022-08-24","2022-08-17","2022-08-24","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-09-16",null,5190485,-5190485,2076194,519048.5,6,5190485,0,"Yes","No",0,null,3567699,195200,348781,667638,411168,5190486,-1,null,0.68735355417585176,3.7607268375254264E-2,6.719621245486454E-2,0.1286272614934324,7.9215703500597048E-2]
[null,null,null,null,"Lane BHRN 2Restored Connections Peer Center","Lane",39,"Lane BHRN 2","#NO MATCH",177575,"Restored Connections Peer Center","Restored Connections Peer Center",118,true,"2022-12-06","Valid",null,null,null,null,null,null,"2023-07-22",null,"No","No professional liability coverage or worker's compensation amounts",177575,"177575-0","2022-08-19","#NO MATCH","#NO MATCH","#NO MATCH","2022-08-17","2022-08-24","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-09-16","#NO MATCH",1082051,"#INVALID OPERATION",432820.4,108205.1,6,1082051,0,"Yes","No","#INVALID OPERATION","#INVALID OPERATION",732583.32,16000,181100,54000,98368.33,1082051.6499999999,-0.64999999990686796,null,0.67703174797617105,1.4786724829632671E-2,0.16736724166540481,4.9905196300010266E-2,9.0909089228781284E-2]
[null,null,null,null,"Lane BHRN 2Shelter Care","Lane",39,"Lane BHRN 2","#NO MATCH",177581,"Shelter Care","ShelterCare",126,true,"2022-12-02","Valid",null,null,null,null,null,null,null,null,null,null,177581,"177581-0","2022-09-01","#NO MATCH","#NO MATCH","2022-08-24","2022-08-17","2022-08-24","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-09-16",null,308618,-308618,51436.35,51436.33,5,308618,0,"Yes","No",0,null,134156.75,null,174461.08,null,null,308617.83,0.16999999998370199,null,0.43470187707560509,0,0.56529812292439485,0,0]
[null,null,null,null,"Lane BHRN 2TransPonder","Lane",39,"Lane BHRN 2","#NO MATCH",177571,"TransPonder","TransPonder",144,true,"2023-05-25","Valid",null,null,null,null,null,null,null,null,null,null,177571,"177571-0","2022-08-18","#NO MATCH","#NO MATCH","2022-08-24","2022-08-19","2022-08-24","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-09-18",null,670626,-670626,268250.40000000002,67062.600000000006,6,670626,0,"Yes","No",0,null,562626,9000,99000,0,0,670626,0,null,0.83895643771640227,1.3420296856966477E-2,0.14762326542663123,0,0]
[null,null,null,null,"Lane BHRN 2Veteran's Legacy","Lane",39,"Lane BHRN 2","#NO MATCH",177565,"Veteran's Legacy","Veteran's Legacy",145,true,"2023-03-18","Valid",null,null,null,null,null,null,null,null,null,null,177565,"177565-0","2022-08-31","#NO MATCH","#NO MATCH","2022-08-24","2022-08-18","2022-08-24","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-09-17",null,940575,-940575,156762.5,156762.5,5,940575,0,"Yes","No",0,null,79560,1500,837675,60000,null,978735,-38160,null,8.1288602124170481E-2,1.5325905377860196E-3,0.85587518582660271,6.1303621511440788E-2,0]
[null,null,null,null,"Lane BHRN 2White Bird Clinic","Lane",39,"Lane BHRN 2","#NO MATCH",177557,"White Bird Clinic","White Bird Clinic",151,true,"2023-02-13","Valid",null,null,null,null,null,null,null,null,null,null,177557,"177557-0","Pending","#NO MATCH","#NO MATCH","2022-08-24","2022-08-17","2022-08-24","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-09-16",null,4693019,-4693019,1877207.6,469301.9,6,4693019,0,"Yes","No",0,null,1712856,null,935062,1288000,787681,4723599,-30580,null,0.36261672508610487,0,0.19795541492832056,0.2726734424323487,0.16675441755322584]
[null,null,null,null,"Lane BHRN 3Centro Latino Americano","Lane",39,"Lane BHRN 3","#NO MATCH",177576,"Centro Latino Americano","Centro Latino Americano","021",true,"2023-06-23","Valid",true,170482,null,null,null,null,null,null,null,null,177576,"177576-0","2022-08-19","#NO MATCH","#NO MATCH","2022-08-15","2022-08-11","2022-08-12","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-09-10",null,4565567,-4565567,1826226.8,456556.7,6,4565567,0,"Yes","No",0,null,1323662.3999999999,43828.49,804504.22,2137118,256454.16,4565567.2699999996,-0.269999999552965,null,0.28992287742591955,9.5997906520825394E-3,0.17621122905938477,0.46809473469876178,5.6171368163851418E-2]
[null,null,null,null,"Lane BHRN 3HIV Alliance","Lane",39,"Lane BHRN 3","#NO MATCH",177580,"HIV Alliance","HIV Alliance","058",true,"2022-09-21","Valid",true,172261,null,null,null,null,null,null,null,null,177580,"177580-0","2022-08-23","#NO MATCH","#NO MATCH","2022-08-15","2022-08-11","2022-08-12","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-09-10",null,1302583,-1302583,521033.2,130258.3,6,1302583,0,"Yes","No",0,null,917256,2500,199410,65000,118417,1302583,0,null,0.70418238223591123,1.919263494149701E-3,0.15308813334735674,4.9900850847892225E-2,9.0909370074690063E-2]
[null,null,null,null,"Lincoln County BHRN 1Coastal Phoenix Rising","Lincoln",41,"Lincoln County BHRN 1","#NO MATCH",177803,"Coastal Phoenix Rising","Coastal Phoenix Rising, Inc.","026",true,"2023-02-23","Valid",null,null,null,null,null,null,null,null,null,null,177803,"177803-0","Pending","#NO MATCH","#NO MATCH",null,null,null,null,null,"#NO MATCH",0,null,null,null,null,null,null,null,null,null,null,null,null,479997,-479997,191990.8,47997.7,6,479977,20,"No","No",0,null,0,0,460475,19500,0,479975,22,"No budget in CLM folder",0,0,0.95937288400437526,4.0627115995624775E-2,0]
[null,null,null,null,"Lincoln County BHRN 1Faith, Hope and Charity, Inc. (FHC)","Lincoln",41,"Lincoln County BHRN 1","#NO MATCH","#INVALID OPERATION","Faith, Hope and Charity, Inc. (FHC)","FHC Faith, Hope, & Charity, Inc.","044",null,"2022-05-30","Expired",null,null,null,null,null,null,null,null,null,null,null,"-0",null,"#NO MATCH","#NO MATCH",null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,null,208955,-208955,83582,20895.5,6,208955,0,"No","No",0,null,146323,8150,37565,0,16917,208955,0,null,0.70026082170802328,3.900361321815702E-2,0.17977554975951759,0,8.0960015314302122E-2]
[null,null,null,null,"Lincoln County BHRN 2CHANCE","Lincoln",41,"Lincoln County BHRN 2","#NO MATCH","#INVALID OPERATION","CHANCE","CHANCE LLC","022",true,"2022-11-15","Valid",null,null,null,null,null,"2023-07-01","2023-07-01","2023-07-01","Yes",null,null,"-0",null,"#NO MATCH","#NO MATCH",null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,null,310320,-310320,124128,31032,6,310320,0,"No","No",0,null,234000,5250,71070,0,0,310320,0,null,0.75406032482598606,1.6918020108275329E-2,0.2290216550657386,0,0]
[null,null,null,null,"Lincoln County BHRN 1Community Services Consortium","Lincoln",41,"Lincoln County BHRN 1","#NO MATCH","#INVALID OPERATION","Community Services Consortium","Community Services Consortium","033",true,"2023-12-17","Valid",null,null,null,null,null,null,"2023-07-01","2023-07-01","No","No professional liability coverage",null,"-0",null,"#NO MATCH","#NO MATCH",null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,null,390494,-390494,156197.6,39049.4,6,390494,0,"No","No",0,null,177585,9000,153250,0,50659,390494,0,null,0.45477011170466125,2.3047729286493519E-2,0.39245161257279243,0,0.12973054643605281]
[null,null,null,null,"Lincoln County BHRN 2Phoenix Wellness Center LLC","Lincoln",41,"Lincoln County BHRN 2","#NO MATCH",177779,"Phoenix Wellness Center LLC","Phoenix Wellness Center LLC",104,true,"2022-10-30","Valid",true,170795,null,null,null,null,null,null,null,null,177779,"177779-0","2022-08-31","#NO MATCH","#NO MATCH",null,null,null,null,null,"#NO MATCH",0,null,null,null,null,null,null,null,null,null,null,null,null,1536047,-1536047,614418.80000000005,153604.70000000001,6,1536047,0,"No","No",0,null,1356543.95,22000,91708,65795,0,1536046.95,5.0000000046566101E-2,null,0.88313963970958054,1.4322478879958715E-2,5.9703904232875173E-2,4.2833977177585622E-2,0]
[null,null,null,null,"Lincoln County BHRN 1Confederated Tribes of the Siletz","Lincoln",41,"Lincoln County BHRN 1","#NO MATCH",177782,"Confederated Tribes of the Siletz","The Confederated Tribes of Siletz Indians","036",true,"Inactive","#INVALID OPERATION",null,null,null,null,null,null,null,null,null,null,177782,"177782-0","Pending","#NO MATCH","#NO MATCH",null,null,null,null,null,"#NO MATCH",0,null,null,null,null,null,null,null,null,null,null,null,null,78452,-78452,73075.350000000006,13075.33,5,138452,-60000,"No","No",0,null,47397.53,0,12289.11,0,18765.48,78452.12,-0.119999999995343,null,0.60415868940189255,0,0.15664471527346874,0,0.23919659532463877]
[null,null,null,null,"Lincoln County BHRN 1Lincoln County Harm Reduction Program","Lincoln",41,"Lincoln County BHRN 1","#NO MATCH","#INVALID OPERATION","Lincoln County Harm Reduction Program","Lincoln County HHS","072",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-0",null,"#NO MATCH","#NO MATCH",null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,null,1196010,-1196010,478404,119601,6,1196010,0,"No","No",0,null,829708.59,45000,169601,151700.79999999999,0,1196010.3899999999,-0.38999999989755502,null,0.69373025262765486,3.7625091200085649E-2,0.1418056242805717,0.12683903189168783,0]
[null,null,null,null,"Lincoln County BHRN 2Coastal Phoenix Rising","Lincoln",41,"Lincoln County BHRN 2","#NO MATCH",177803,"Coastal Phoenix Rising","Coastal Phoenix Rising, Inc.","026",null,"2023-02-23","Valid",null,null,null,null,null,null,null,null,null,null,177803,"177803-0","Pending","#NO MATCH","#NO MATCH",null,null,null,null,null,"#NO MATCH",0,null,null,null,null,null,null,null,null,null,null,null,null,479997,-479997,191990.8,47997.7,6,479977,20,"No","No",0,null,0,0,460475,19500,0,479975,22,null,0,0,0.95937288400437526,4.0627115995624775E-2,0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(H130,K130)","v":"Lincoln County BHRN 2Lincoln County HHS Harm Reduction Program"},"Lincoln",41,"Lincoln County BHRN 2","#NO MATCH","#INVALID OPERATION","Lincoln County HHS Harm Reduction Program","Lincoln County HHS","#NO MATCH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-0",null,"#NO MATCH","#NO MATCH","#NO MATCH",null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,"#NO MATCH",1196010,null,478404,119601,6,1196010,null,"No","#NO MATCH","#NO MATCH","#NO MATCH",829708.59,45000,169601,151700.79999999999,0,1196010.3899999999,-1196010.3899999999,null,0.69373025262765486,3.7625091200085649E-2,0.1418056242805717,0.12683903189168783,0]
[null,null,null,null,"Lincoln County BHRN 1Samaritan Treatment & Recovery","Lincoln",41,"Lincoln County BHRN 1","#NO MATCH",177783,"Samaritan Treatment & Recovery",null,123,null,null,null,null,null,null,null,null,null,null,null,null,null,177783,"177783-0","Pending","#NO MATCH","#NO MATCH",null,null,null,null,null,"#NO MATCH",0,null,null,null,null,null,null,null,null,null,null,null,null,455143,-455143,182057.2,45154.3,6,452983,2160,"No","No",0,null,170354,10500,232920,0,41377,455151,-8,null,0.37428018393895651,2.3069267122339619E-2,{"$f":"IFERROR(BL131/$BO131,\"\")","v":0.51174225696527087},{"$f":"IFERROR(BM131/$BO131,\"\")","v":0},{"$f":"IFERROR(BN131/$BO131,\"\")","v":9.0908291973432989E-2}]
[null,null,null,null,"LinnAddiction Counseling and Education Services (Emergence)","Linn",43,"Linn",27,177480,"Addiction Counseling and Education Services (Emergence)",null,"002",null,null,null,null,null,null,null,null,null,null,null,null,null,177480,"177480-0","2022-08-09",null,null,"2022-08-10",null,"2022-08-10","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,null,null,175388.05,-175388.05,29231.25,29231.34,5,175387.95,9.9999999976716894E-2,"Yes","No","#INVALID OPERATION","#INVALID OPERATION",137046.37,10625,4039,0,22876.71,174587.08,800.97000000000105,null,{"$f":"IFERROR(BJ132/$BO132,\"\")","v":0.78497429477599379},6.0857882496230538E-2,2.3134587049625895E-2,0,0.13103323567814984]
[null,null,null,null,"LinnAlbany Comprehensive Treatment (CRC Health OR)","Linn",43,"Linn",27,177477,"Albany Comprehensive Treatment (CRC Health OR)","Albany Comprehensive Treatment","006",true,"2023-01-26","Valid",null,null,null,null,null,null,null,null,null,null,177477,"177477-0","2022-08-09",null,null,"2022-08-10",null,"2022-08-10","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,null,null,110720,-110720,44288,11072,6,110720,0,"Yes","No",0,null,0,0,110720,0,0,110720,0,null,0,0,1,0,0]
[null,null,null,null,"LinnCHANCE","Linn",43,"Linn",27,177475,"CHANCE","CHANCE LLC","022",true,"2022-11-15","Valid",null,null,null,null,null,"2023-07-01","2023-07-01","2023-07-01","Yes",null,177475,"177475-0","2022-08-23",null,null,"2022-08-10",null,"2022-08-10","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,null,null,3645179,-3645179,1458071.6,364517.9,6,3645179,0,"Yes","No",0,null,null,null,1401139,94000,null,1495139,2150040,"Only noted costs that are one-time only for Start-Up purposes, and will not be on-going.",0,0,0.93712959129552498,6.2870408704474967E-2,0]
[null,null,null,null,"LinnCommunity Services Consortium","Linn",43,"Linn",27,177472,"Community Services Consortium","Community Services Consortium","033",true,"2023-12-17","Valid",null,null,null,null,null,null,"2023-07-01","2023-07-01","No","No professional liability coverage",177472,"177472-0","2022-08-08",null,null,"2022-08-10",null,"2022-08-10","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,null,null,890000,-890000,356000,89000,6,890000,0,"Yes","No",356000,0,449872,11740,339388,89000,0,890000,0,null,0.50547415730337075,1.3191011235955057E-2,0.38133483146067415,0.1,0]
[null,null,null,null,"LinnFaith, Hope and Charity, Inc. (FHC)","Linn",43,"Linn",27,177473,"Faith, Hope and Charity, Inc. (FHC)","FHC Faith, Hope, & Charity, Inc.","044",null,"2022-05-30","Expired",null,null,null,null,null,null,null,null,null,null,177473,"177473-0","2022-08-23",null,null,"2022-08-10","2022-07-28","2022-08-10","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-27",null,504210.96,-504210.96,201684.42,50421.09,6,504210.96,0,"Yes","No",0,null,411074,4400,42900,0,45837,504211,-3.99999999790452E-2,null,0.81528169754329038,8.7265053717590461E-3,8.5083427374650689E-2,0,9.0908369710299849E-2]
[null,null,null,null,"LinnFamily Tree Relief Nursery","Linn",43,"Linn",27,177460,"Family Tree Relief Nursery","Family Tree Relief Nursery","047",true,"2023-02-27","Valid",null,null,null,null,null,null,null,null,null,null,177460,"177460-0","2022-08-15",null,null,"2022-08-10",null,"2022-08-10","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,null,null,843323,-843323,140553.85,140553.82999999999,5,843323,0,"Yes","No",140553.85,0,566192,29500,227131,20500,null,843323,0,null,0.67138213946494996,3.4980665771003519E-2,0.26932859651640001,2.4308598247646512E-2,0]
[null,null,null,null,"LinnSamaritan Health Services","Linn",43,"Linn",27,177464,"Samaritan Health Services","Samaritan Health Services, Inc.",122,true,"2023-01-25","Valid",true,172237,null,null,null,null,null,null,null,null,177464,"177464-0","Pending",null,null,"2022-08-10",null,"2022-08-10","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,null,null,1081702.5,-1081702.5,432681,108170.25,6,1081702.5,0,"Yes","No",0,null,541815,29800,411751,0,98337,1081703,-0.5,null,0.50089072508812493,2.7549151661777772E-2,0.38065069617076036,0,9.0909427079336941E-2]
[null,null,null,null,"MalheurEastern Oregon Center for Independent Living","Malheur",45,"Malheur",28,177286,"Eastern Oregon Center for Independent Living","Eastern Oregon Center for Independent Living","042",true,"2022-08-25","Expired",null,null,null,null,null,"2022-12-01","2023-01-12",null,"No","Umbrella aggregate coverage is $1M but Grant Agreement requires $2M of annual aggregate professional liability coverage",177286,"177286-0","2022-08-02",null,null,"2022-07-22","2022-07-22","2022-07-22","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-21",null,515535.79,-515535.79,206214.37,51553.57,6,515535.79,0,"Yes","No",206214.37,0,109749.15,0,9413.1299999999992,350500,46873.51,516535.79,-1000,null,0.2124715307723401,0,1.8223577498860243E-2,0.67855898233111789,9.0745909397681818E-2]
[null,null,null,null,"MalheurLifeways","Malheur",45,"Malheur",28,177305,"Lifeways","Lifeways, Inc.","070",true,"2022-11-03","Valid",null,null,null,null,null,null,null,null,null,null,177305,"177305-0","2022-08-02",null,null,"2022-07-22","2022-07-22","2022-07-22","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-21",null,698210,-698210,116368.35,116368.33,5,698210,0,"Yes","No",116368.35,0,618197,0,59613,20400,0,698210,0,null,0.88540267254837368,0,8.5379756806691395E-2,2.9217570644934906E-2,0]
[null,null,null,null,"MalheurOrigins Faith Community Outreach Initiative (OFCOI)","Malheur",45,"Malheur",28,177284,"Origins Faith Community Outreach Initiative (OFCOI)",null,"098",null,null,null,null,null,null,null,null,null,null,null,null,null,177284,"177284-0","2022-08-02",null,null,"2022-07-22","2022-07-22","2022-07-22","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-21",null,616152,-616152,102692,102692,5,616152,0,"Yes","No",102692,0,310694,119781,121400,0,64277,616152,0,null,0.5042489515574079,0.19440170607252755,0.19702930445734171,0,0.10432003791272283]
[null,null,null,null,"MarionBridgeway","Marion",47,"Marion",29,176716,"Bridgeway","Bridgeway Recovery Services, Inc.","012",true,"2022-10-28","Valid",true,170491,null,null,null,null,null,null,null,null,176716,"176716-0","2022-07-12",null,null,"2022-07-21","2022-07-06","2022-07-21","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-05",null,11096437,-11096437,4438574.8,1109643.7,6,11096437,0,"Yes","No",4438574.8,0,1077515,1223917,0,8194000,601005,11096437,0,null,9.7104593122999752E-2,0.11029819752051942,0,0.73843522925421912,5.4161980102261656E-2]
[null,null,null,null,"MarionHIV Alliance","Marion",47,"Marion",29,176744,"HIV Alliance","HIV Alliance","058",true,"2022-09-21","Valid",true,172261,null,null,null,null,null,null,null,null,176744,"176744-0","2022-07-06",null,null,"2022-07-21","2022-07-06","2022-07-21","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-05",null,388105,-388105,64684.2,64684.160000000003,5,388105,0,"Yes","No",64684.2,0,274917,2000,75906,0,35282,388105,0,null,0.70835727444892493,5.153244611638603E-3,0.19558109274551991,0,9.0908388193916598E-2]
[null,null,null,null,"MarionIdeal Option","Marion",47,"Marion",29,176746,"Ideal Option","Ideal Option PLLC","061",true,"2023-06-13","Valid",null,null,null,null,null,"2023-05-01","2023-05-01","2023-05-01","Yes",null,176746,"176746-0","2022-07-05",null,null,"2022-07-21","2022-07-06","2022-07-21","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-05",null,924441,-924441,369776.4,92444.1,6,924441,0,"Yes","No",0,null,118370,0,806071,0,0,924441,0,null,0.12804494824439849,0,0.87195505175560151,0,0]
[null,null,null,null,"MarionIron Tribe Network","Marion",47,"Marion",29,176747,"Iron Tribe Network","Iron Tribe Network","062",true,"2023-06-29","Valid",null,null,null,null,null,"2023-07-01","2023-01-02","2023-01-02","Yes",null,176747,"176747-0","2022-06-28",null,null,"2022-07-21","2022-07-06","2022-07-21","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-05",null,768824,-768824,307529.59999999998,76882.399999999994,6,768824,0,"Yes","No",0,null,184249,2850,233824,535000,0,955923,-187099,null,0.19274460390638157,2.9814116827401372E-3,0.24460547554562448,0.55966850886525377,0]
[null,null,null,null,"MarionMarion County","Marion",47,"Marion",29,176751,"Marion County","Marion County Health and Human Services","075",null,null,null,null,null,null,null,null,null,null,null,null,null,176751,"176751-0","2022-08-31",null,null,"2022-07-21","2022-06-30","2022-07-21","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-30",null,6419022,-6419022,1069837,1069837,5,6419022,0,"Yes","No",0,null,2158922.54,9000,2711100,1540000,0,6419022.54,-0.54000000003725301,null,0.33633197679969512,1.4020826292346997E-3,0.42235402401313271,0.2399119165579375,0]
[null,null,null,null,"MarionPathfinder Club of Oregon","Marion",47,"Marion",29,176753,"Pathfinder Club of Oregon","Pathfinders of Oregon",null,true,"2022-08-05","Expired",true,170794,null,null,null,"2023-07-01","2023-06-01","2023-06-01","Yes",null,176753,"176753-0","2022-07-07",null,null,"2022-07-21","2022-07-06","2022-07-21","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-05",null,493935,-493935,197574,49393.5,6,493935,0,"Yes","No",0,null,299473,1800,112259,35500,44903,493935,0,null,0.60630042414487739,3.6442041969085002E-3,0.22727484385597296,7.1871804994584301E-2,9.0908722807656883E-2]
[null,null,null,null,"MorrowCommunity Counseling Solutions","Morrow",49,"Morrow",30,176490,"Community Counseling Solutions","Community Counseling Solutions","031",true,"2022-11-02","Valid",null,null,null,null,null,null,null,null,null,null,176490,"176490-0","2022-06-13","2022-06-13","2022-07-13",null,"N/A","N/A","No MOU Required","No MOU Required","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-13",924517,924517.12,-0.119999999995343,369806.92,92451.7,6,924517.12,0,"Yes","No",369806.92,0,444573,0,0,352395,127500,924468,49.119999999995301,null,0.48089603966821998,0,0,0.38118680149015433,0.13791715884162567]
[null,null,null,null,"East Multnomah BHRN ProvidersBright Transitions","Multnomah",51,"East Multnomah BHRN Providers",31,177742,"Bright Transitions","Bright Transitions LLC","013",null,"2022-05-23","Expired",null,null,null,null,null,null,null,null,null,null,177742,"177742-0","2022-09-01",null,null,"2022-07-21","2022-07-21","2022-07-21","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-20",null,898018.15,-898018.15,358407.23,89601.82,6,896018.15,2000,"Yes","No",0,null,611618,3300,60000,221100,null,896018,2000.1500000000201,null,0.68259566214071588,3.6829617262153216E-3,6.696294047664221E-2,0.24675843565642655,0]
[null,null,null,null,"East Multnomah BHRN ProvidersCascadia Behavioral Healthcare, Inc.","Multnomah",51,"East Multnomah BHRN Providers",31,177740,"Cascadia Behavioral Healthcare, Inc.","Cascadia Inc.","017",null,null,null,null,null,null,null,null,null,null,null,null,null,177740,"177740-0","Pending",null,null,"2022-07-12","2022-07-11","2022-07-12","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-10",null,797355.41,-797355.41,318942.17,79735.539999999994,6,797355.41,0,"Yes","No",0,null,633986.6,5000,115575.84,14999.94,27793.03,797355.41,0,null,0.79511168049891323,6.2707293852812757E-3,0.14494896322331341,1.8812112907091207E-2,3.4856513985400808E-2]
[null,null,null,null,"East Multnomah BHRN ProvidersCODA, Inc.","Multnomah",51,"East Multnomah BHRN Providers",31,177741,"CODA, Inc.","CODA, Inc.","027",true,"2022-09-26","Valid",null,null,null,null,null,null,null,null,null,null,177741,"177741-0","Pending",null,null,"2022-07-12","2022-07-08","2022-07-12","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-07",null,545025,-545025,90837.5,90837.5,5,545025,0,"Yes","No",0,null,368346,0,33250,14813,128511,544920,105,"No budget in CLM folder",0.67596344417529175,0,6.101813110181311E-2,2.7183806797328049E-2,0.23583461792556706]
[null,null,null,null,"East Multnomah BHRN ProvidersIron Tribe Network","Multnomah",51,"East Multnomah BHRN Providers",31,177755,"Iron Tribe Network","Iron Tribe Network","062",true,"2023-06-29","Valid",null,null,null,null,null,"2023-07-01","2023-01-02","2023-01-02","Yes",null,177755,"177755-0","2022-09-07",null,null,"2022-07-12","2022-07-08","2022-07-12","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-07",null,395361.1,-395361.1,158144.4,39536.1,6,395361,9.9999999976716894E-2,"Yes","No",0,null,209886,2850,162625,20000,0,395361,9.9999999976716894E-2,null,0.53087178553271563,7.2086017588988294E-3,0.41133293369856916,5.0586679009816345E-2,0]
[null,null,null,null,"East Multnomah BHRN ProvidersMorrison Child and Family Services","Multnomah",51,"East Multnomah BHRN Providers",31,177718,"Morrison Child and Family Services","Morrison Child and Family Services","082",true,"2023-03-15","Valid",true,170819,null,null,null,null,null,null,null,null,177718,"177718-0","2022-08-28",null,null,"2022-07-12","2022-07-12","2022-07-12","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-11",null,287521.13,-287521.13,47920.18,47920.19,5,287521.13,0,"Yes","No",0,null,210826,424,47546,0,28726,287522,-0.86999999999534305,null,0.73325171639039799,1.4746697644006373E-3,0.16536473730705825,0,9.9908876538143163E-2]
[null,null,null,null,"East Multnomah BHRN ProvidersNew Avenues for Youth","Multnomah",51,"East Multnomah BHRN Providers",31,177720,"New Avenues for Youth","New Avenues for Youth, Inc.","083",true,"2023-02-18","Valid",null,null,null,null,null,null,null,null,null,null,177720,"177720-0","2022-09-02",null,null,"2022-07-12","2022-07-08","2022-07-12","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-07",null,1059239,-1059239,423695.6,105923.9,6,1059239,0,"Yes","No",0,null,549750,26000,192327.4,153000,138161.60999999999,1059239.01,-1.00000000093132E-2,null,0.5190046767631793,2.4545923775975736E-2,0.18157129617044598,0.14444332068170337,0.13043478260869565]
[null,null,null,null,"East Multnomah BHRN ProvidersNorthwest Family Services","Multnomah",51,"East Multnomah BHRN Providers",31,177725,"Northwest Family Services","Northwest Family Services","087",true,"2023-07-07","Valid",true,171993,null,null,null,null,"2022-12-31",null,"No","No professional liability coverage or worker's compensation",177725,"177725-0","Pending",null,null,"2022-07-12","2022-07-08","2022-07-12","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-07",null,512760.25,-512760.25,null,null,null,null,null,"Yes","No",0,null,446931,2000,17216,0,46615,512762,-1.75,null,0.87161490126023378,3.9004450407791528E-3,3.3575030911026947E-2,0,9.0909622787960109E-2]
[null,null,null,null,"East Multnomah BHRN ProvidersPathfinders of Oregon","Multnomah",51,"East Multnomah BHRN Providers",31,177727,"Pathfinders of Oregon","Pathfinders of Oregon",null,true,"2022-08-05","Expired",true,170794,null,null,null,"2023-07-01","2023-06-01","2023-06-01","Yes",null,177727,"177727-0","2022-08-29",null,null,"2022-07-12","2022-07-12","2022-07-12","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-11",null,1660187,-1660187,664074.80000000005,166018.70000000001,6,1660187,0,"Yes","No",0,null,827644,13050,364707,106264,131167,1442832,217355,null,0.57362464930081947,9.0447120662696702E-3,0.25277163245616951,7.3649600230657489E-2,9.0909405946083807E-2]
[null,null,null,null,"East Multnomah BHRN ProvidersPhoenix Rising","Multnomah",51,"East Multnomah BHRN Providers",31,177744,"Phoenix Rising","Phoenix Rising",103,true,"2022-10-15","Valid",null,null,null,null,null,null,null,null,null,null,177744,"177744-0","2022-08-30",null,null,"2022-07-12","2022-07-08","2022-07-12","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-07",null,168927.55,-168927.55,67570.990000000005,16892.759999999998,6,168927.55,0,"Yes","No",0,null,147781.92000000001,1500,19645.63,0,0,168927.55,0,null,0.87482426637928523,8.8795462907027313E-3,0.11629618733001219,0,0]
[null,null,null,null,"East Multnomah BHRN ProvidersRaphael House of Portland","Multnomah",51,"East Multnomah BHRN Providers",31,177745,"Raphael House of Portland","Raphael House of Portland",114,true,"2022-11-15","Valid",true,170470,null,null,null,null,null,null,null,null,177745,"177745-0","2022-09-07",null,null,"2022-07-12","2022-07-08","2022-07-12","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-07",null,109855.95,-109855.95,43942.35,10985.6,6,109855.95,0,"Yes","No",0,null,83663,600,15606,0,9986.9,109855.9,5.0000000002910397E-2,null,0.76157038447639136,5.4617002819147631E-3,0.142058824332603,0,9.0909090909090912E-2]
[null,null,null,null,"East Multnomah BHRN ProvidersThe 4th Dimension Recovery Center","Multnomah",51,"East Multnomah BHRN Providers",31,177738,"The 4th Dimension Recovery Center","The 4th Dimension Recovery Center",131,null,null,null,true,170896,null,null,null,null,null,null,null,null,177738,"177738-0","2022-09-02",null,null,"2022-07-12",null,"2022-07-12","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,null,null,2639337.16,-2639337.16,439889.51,439889.53,5,2639337.16,0,"Yes","No",0,null,784595.13,2000,1467069.06,20000,365672.96000000002,2639337.15,1.0000000242143901E-2,"Could not find in county folder",0.29726976335706107,7.5776601712289771E-4,0.55584753922021679,7.5776601712289771E-3,0.13854727123437036]
[null,null,null,null,"East Multnomah BHRN ProvidersThe Insight Alliance","Multnomah",51,"East Multnomah BHRN Providers",31,177752,"The Insight Alliance","The Insight Alliance",134,true,"2023-05-07","Valid",null,null,null,null,null,null,null,null,null,null,177752,"177752-0","2022-09-07",null,null,"2022-07-12","2022-07-08","2022-07-12","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-07",null,1008030.5,-1008030.5,403212.2,100803.05,6,1008030.5,0,"Yes","No",0,null,244480.5,43400,225150,495000,0,1008030.5,0,null,0.24253284002815392,4.3054252822707251E-2,0.22335633693623358,0.49105657021290527,0]
[null,null,null,null,"East Multnomah BHRN ProvidersThe Mental Health & Addiction Association of Oregon","Multnomah",51,"East Multnomah BHRN Providers",31,177709,"The Mental Health & Addiction Association of Oregon","The Mental Health & Addiction Association of Oregon",136,true,"2023-07-20","Valid",null,null,null,null,null,null,null,null,null,null,177709,"177709-0","2022-08-30",null,null,"2022-07-12","2022-07-11","2022-07-12","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-10",null,4015518.63,-4015518.63,1606207.47,401551.86,6,4015518.63,0,"Yes","No","#INVALID OPERATION","#INVALID OPERATION",2850038.3539999998,0,879602.7,null,372964.11,4102605.1639999999,-87086.534,"Was not sure if this one was the grant for Multnomah or east Multnomah",0.69468989582737239,0,0.21440101224422872,0,9.0909091928398883E-2]
[null,null,null,null,"East Multnomah BHRN ProvidersVolunteers of America Oregon","Multnomah",51,"East Multnomah BHRN Providers",31,177746,"Volunteers of America Oregon","Volunteers of America Oregon, Inc.",147,true,"2022-10-03","Valid",null,null,null,null,null,null,null,null,null,null,177746,"177746-0","Pending",null,null,"2022-07-12","2022-07-12","2022-07-12","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-11",null,947613.96,-947613.96,379045.56,94761.4,6,947613.96,0,"Yes","No",0,null,315096,2223,300391,135896,70000,823606,124007.96,null,0.38258099139637158,2.6991061259874259E-3,0.3647265804280202,0.16500122631452419,8.499209573509664E-2]
[null,null,null,null,"East Multnomah BHRN ProvidersWomenFirst Transition & Referral Center","Multnomah",51,"East Multnomah BHRN Providers",31,177710,"WomenFirst Transition & Referral Center","WomanFirst Reentry Transition Center",152,null,null,null,null,null,null,null,null,null,null,null,null,null,177710,"177710-0",null,null,null,"2022-07-12","2022-07-08","2022-07-12","Yes","Yes","Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,"2022-08-07",null,952979.31,-952979.31,381191.73,95297.93,6,952979.31,0,"Yes","No","#INVALID OPERATION","#INVALID OPERATION",509263,500,342400,26000,74816.3,952979.3,1.00000000093132E-2,"Not sure which is which, repeats",0.53439041120830222,5.246703679712665E-4,0.35929426798672331,2.7282859134505857E-2,7.850779130249734E-2]
[null,null,null,null,"East Multnomah BHRN ProvidersYasiin's Luv LLC","Multnomah",51,"East Multnomah BHRN Providers",31,177748,"Yasiin's Luv LLC","Yasiin's Luv LLC",155,true,"2022-10-14","Valid",null,null,null,null,null,null,null,null,null,null,177748,"177748-0","2022-08-29",null,null,"2022-07-12","2022-07-11","2022-07-12","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-10",null,388335.65,-388335.65,155334.23000000001,38833.57,6,388335.65,0,"Yes","No",0,null,306241,9200,72894,0,0,388335,0.65000000002328295,null,0.78860004892682867,2.3690885446843574E-2,0.18770906562632778,0,0]
[null,null,null,null,"Indigeninity BHRN ProvidersAlano Club of Portland","Multnomah",51,"Indigeninity BHRN Providers",32,177705,"Alano Club of Portland","The Alano Club of Portland, Oregon","005",true,"2022-12-09","Valid",true,170478,null,null,null,null,null,null,null,null,177705,"177705-0","Pending",null,null,"2022-07-14","2022-07-14","2022-07-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-13",null,1175008.5900000001,-1175008.5900000001,470003.49,117500.85,6,1175008.5900000001,0,"Yes","No",0,null,706541.6,9600,105836.67,282376.15999999997,70654.16,1175008.5900000001,0,null,0.60130760405760086,8.1701530369237552E-3,9.0073103210249708E-2,0.24031837928946542,6.0130760405760098E-2]
[null,null,null,null,"Indigeninity BHRN ProvidersBridges to Change","Multnomah",51,"Indigeninity BHRN Providers",32,177728,"Bridges to Change","Bridges to Change, Inc.","011",true,"2023-02-13","Valid",true,170864,null,null,null,null,null,null,null,null,177728,"177728-0","Pending",null,null,"2022-07-18","2022-07-14","2022-07-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-13",null,8483789.8399999999,-8483789.8399999999,3393515.96,848378.98,6,8483789.8399999999,0,"Yes","No",0,null,null,null,null,null,null,0,null,"Budget is very unclear","","","","",""]
[null,null,null,null,"Indigeninity BHRN ProvidersFresh-Out Community Based Re-Entry Program","Multnomah",51,"Indigeninity BHRN Providers",32,177717,"Fresh-Out Community Based Re-Entry Program","Fresh Out Community Based Reentry Program","049",null,null,null,true,170827,null,null,null,null,null,null,null,null,177717,"177717-0","2022-08-28",null,null,"2022-07-13","2022-07-11","2022-07-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-10",null,494408,-494408,197763.20000000001,49440.800000000003,6,494408,0,"Yes","No",0,null,17000,21240,409440,0,46728,494408,0,null,3.4384556884192813E-2,4.296046989530914E-2,0.82814193945081793,0,9.4513033769680108E-2]
[null,null,null,null,"Indigeninity BHRN ProvidersGoing Home II","Multnomah",51,"Indigeninity BHRN Providers",32,177719,"Going Home II","Going Home II","051",true,"2023-01-16","Valid",null,null,null,null,null,null,null,null,null,null,177719,"177719-0","2022-09-02",null,null,"2022-07-18","2022-07-14","2022-07-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-13",null,4954114,-4954114,1981645.6,495411.4,6,4954114,0,"Yes","No",0,null,1705041,64542,721061,2213000,250470,4954114,0,null,0.34416668651548993,1.3027960196313609E-2,0.1455479223933886,0.44669945019432333,5.0557980700484485E-2]
[null,null,null,null,"Indigeninity BHRN ProvidersJust Men In Recovery","Multnomah",51,"Indigeninity BHRN Providers",32,177686,"Just Men In Recovery","Just Men In Recovery","065",true,"2023-04-08","Valid",null,null,null,null,null,null,null,null,null,null,177686,"177686-0","2022-08-29",null,null,"2022-07-13","2022-07-14","2022-07-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-13",null,2230324.5,-2230324.5,892009.8,223002.45,6,2230024.5,300,"Yes","No",0,null,661125,22500,1329270,19400,202729.5,2235024.5,-4700,"The budget table subtotals do not add up to the sum in the budget, there is an error somewhere",0.29580212655387,1.0067003739780034E-2,0.59474515827455132,8.6799943356325616E-3,9.0705717096166066E-2]
[null,null,null,null,"Indigeninity BHRN ProvidersMetroPlus Association","Multnomah",51,"Indigeninity BHRN Providers",32,177721,"MetroPlus Association","MetroPlus Association of Addiction Peer Professionals","078",true,"2024-06-22","Valid",null,null,null,null,null,null,null,null,null,null,177721,"177721-0","2022-09-02",null,null,"#NO MATCH","2022-07-15","2022-07-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-14","#NO MATCH",418627.52,"#INVALID OPERATION",167451.01999999999,41862.75,6,418627.52,0,"Yes","No",0,null,71085.600000000006,260811.96,86729.96,0,0,418627.52,0,"Could not locate grant",0.16980632329188489,0.62301675723564465,0.20717691947247044,0,0]
[null,null,null,null,"Indigeninity BHRN ProvidersOregon Change Clinic","Multnomah",51,"Indigeninity BHRN Providers",32,177731,"Oregon Change Clinic","Oregon Change Clinic, LLC","097",true,"2022-10-14","Valid",true,170866,null,null,null,null,null,null,null,null,177731,"177731-0","2022-09-01",null,null,"2022-07-18","2022-07-14","2022-07-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-13",null,3218373,-3218373,1287349.2,321837.3,6,3218373,0,"Yes","No",0,null,1345050,0,504000,1373050,0,3222100,-3727,"Budget is kind of unclear this is a best guess",0.41744514447099718,0,0.15641972626547904,0.42613512926352382,0]
[null,null,null,null,"Indigeninity BHRN ProvidersOutside In","Multnomah",51,"Indigeninity BHRN Providers",32,177707,"Outside In","Outside In",100,true,"2022-09-23","Valid",true,170897,null,null,null,null,null,null,null,null,177707,"177707-0","2022-08-28",null,null,"2022-07-18","2022-07-15","2022-07-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-14",null,2110456,-2110456,351742.65,351742.67,5,2110456,0,"Yes","No",0,null,1265882,28800,623915,0,191860,2110457,-1,null,0.59981416347265071,1.3646333471849936E-2,0.29563028291976573,0,9.0909220135733632E-2]
[null,null,null,null,"Indigeninity BHRN ProvidersPainted Horse Recovery","Multnomah",51,"Indigeninity BHRN Providers",32,177722,"Painted Horse Recovery","Painted Horse Recovery",101,true,"2023-05-06","Valid",null,null,null,null,null,null,null,null,null,null,177722,"177722-0","2022-08-31",null,null,"2022-07-13","2022-07-15","2022-07-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-14",null,866221.67,-866221.67,144370.26999999999,144370.28,5,866221.67,0,"Yes","No",0,null,441600.07,1000,267881.19,60000,115740.42,886221.68,-20000.009999999998,null,0.49829526851566075,1.1283858458529246E-3,0.30227334316623805,6.7703150751175487E-2,0.13059985172107275]
[null,null,null,null,"Indigeninity BHRN ProvidersProject Patchwork","Multnomah",51,"Indigeninity BHRN Providers",32,177723,"Project Patchwork","Project Patchwork",107,true,"2022-04-08","Expired",null,null,null,null,null,null,"9/7/023","9/7/023","No","No worker's compensation",177723,"177723-0","2022-09-02",null,null,"2022-07-18","2022-07-14","2022-07-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-13",null,1127145.29,-1127145.29,450858.11,112714.53,6,1127145.29,0,"Yes","No",0,null,160189.49,2643.8,210612,753700,0,1127145.29,0,null,0.14211964635011692,2.345571616592569E-3,0.18685434953997812,0.66868043249331233,0]
[null,null,null,null,"Indigeninity BHRN ProvidersProject Quest (Quest Center for Integrative Health)","Multnomah",51,"Indigeninity BHRN Providers",32,177724,"Project Quest (Quest Center for Integrative Health)","Project Quest",108,true,"2022-07-06","Expired",null,null,null,null,null,null,null,null,null,null,177724,"177724-0","2022-08-28",null,null,"2022-07-11","2022-07-14","2022-07-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-13",null,2807764.31,-2807764.31,1123105.73,280776.43,6,2807764.31,0,"Yes","No",0,null,2053398.24,0,314366.07,440000,0,2807764.31,0,null,0.73132856368560362,0,0.11196312627821671,0.15670831003617963,0]
[null,null,null,null,"Indigeninity BHRN ProvidersSE Works Inc","Multnomah",51,"Indigeninity BHRN Providers",32,177706,"SE Works Inc","SE Works Inc.",124,true,"2022-09-10","Valid",true,170471,null,null,null,"2023-07-01","2023-07-01",null,"No","No professional liability coverage",177706,"177706-0","Pending",null,null,"2022-07-12","2022-07-14","2022-07-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-13",null,917806.84,-917806.84,152967.79,152967.81,5,917806.84,0,"Yes","No",0,null,442891.54,1000,369083.61,18400,86431.7,917806.85,-1.00000000093132E-2,null,0.48255418882524137,1.0895538641926676E-3,0.40213647348567949,2.0047791101145084E-2,9.4171992723741382E-2]
[null,null,null,null,"Indigeninity BHRN ProvidersSovalti LLC","Multnomah",51,"Indigeninity BHRN Providers",32,177678,"Sovalti LLC","Sovalti L.L.C.",128,true,"2022-11-13","Valid",null,null,null,null,null,null,null,null,null,null,177678,"177678-0","2022-08-30",null,null,"2022-07-18","2022-07-15","2022-07-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-14",null,152866.59,-152866.59,61146.63,15286.66,6,152866.59,0,"Yes","No",0,null,75753,3780,53320,0,0,132853,20013.59,null,0.57020165144934631,2.8452500131724536E-2,0.40134584841892917,0,0]
[null,null,null,null,"Indigeninity BHRN ProvidersThe 4th Dimension Recovery Center","Multnomah",51,"Indigeninity BHRN Providers",32,177738,"The 4th Dimension Recovery Center","The 4th Dimension Recovery Center",131,true,"2023-01-14","Valid",true,170896,null,null,null,null,null,null,null,null,177738,"177738-0","2022-09-02",null,null,"2022-07-12","2022-07-18","2022-07-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-17",null,2639337.16,-2639337.16,439889.51,439889.53,5,2639337.16,0,"Yes","No",0,null,784595.13,2000,1467069.06,20000,365672.96000000002,2639337.15,1.0000000242143901E-2,null,0.29726976335706107,7.5776601712289771E-4,0.55584753922021679,7.5776601712289771E-3,0.13854727123437036]
[null,null,null,null,"Indigeninity BHRN ProvidersThe Mental Health & Addiction Association of Oregon","Multnomah",51,"Indigeninity BHRN Providers",32,177709,"The Mental Health & Addiction Association of Oregon","The Mental Health & Addiction Association of Oregon",136,true,"2023-07-20","Valid",null,null,null,null,null,null,null,null,null,null,177709,"177709-0","2022-08-30",null,null,"2022-07-12","2022-07-15","2022-07-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-14",null,4015518.63,-4015518.63,1606207.47,401551.86,6,4015518.63,0,"Yes","No","#INVALID OPERATION","#INVALID OPERATION",2850038.3539999998,0,879602.7,null,372964.11,4102605.1639999999,-87086.534,"Not able to find this one, might be the other",0.69468989582737239,0,0.21440101224422872,0,9.0909091928398883E-2]
[null,null,null,null,"Indigeninity BHRN ProvidersThe Miracles Club","Multnomah",51,"Indigeninity BHRN Providers",32,177730,"The Miracles Club","The Miracles Club",137,true,"2022-11-14","Valid",true,170476,null,null,null,null,null,null,null,null,177730,"177730-0","2022-09-02",null,null,"2022-07-14","2022-07-14","2022-07-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-13",null,3201077,-3201077,533512.85,533512.82999999996,5,3201077,0,"Yes","No",0,null,1186560,4800,608035,323000,305898,2428293,772784,"Budget table has a separate line item called extended housing that matches the variance, not sure what that falls under",0.48863955049905428,1.976697210756692E-3,0.25039606011300941,0.13301524980716906,0.12597244237001054]
[null,null,null,null,"Indigeninity BHRN ProvidersWomenFirst Transition & Referral Center","Multnomah",51,"Indigeninity BHRN Providers",32,177710,"WomenFirst Transition & Referral Center","WomenFirst Transition & Referral Center",152,null,null,null,null,null,null,null,null,null,null,null,null,null,177710,"177710-0",null,null,null,"2022-07-12","2022-07-18","2022-07-18","Yes","Yes","Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,"2022-08-17",null,952972.31,-952972.31,381191.73,95297.93,6,952979.31,-7,"Yes","No","#INVALID OPERATION","#INVALID OPERATION",509263,500,342400,26000,null,878163,74809.3100000001,"Not sure which is which, repeats",0.57991853448619446,5.6937037884766269E-4,0.38990483543487942,2.9607259700078461E-2,0]
[null,null,null,null,"Latino/a/x Multnomah County BHRNCentral City Concern Puentes","Multnomah",51,"Latino/a/x Multnomah County BHRN",33,177739,"Central City Concern Puentes","Central City Concern","020",null,null,null,true,170858,null,null,null,null,null,null,null,null,177739,"177739-0","Pending",null,null,"2022-07-20","2022-07-18","2022-07-20","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-17",null,633099.63,-633099.63,105516.58,105516.61,5,633099.63,0,"Yes","No",0,null,480547,3340,149199,0,0,633086,13.630000000004699,null,0.75905485194744471,5.2757445275997258E-3,0.23566940352495552,0,0]
[null,null,null,null,"Latino/a/x Multnomah County BHRNFresh-Out Community Based Re-Entry Program","Multnomah",51,"Latino/a/x Multnomah County BHRN",33,177717,"Fresh-Out Community Based Re-Entry Program","Fresh Out Community Based Reentry Program","049",null,null,null,true,170827,null,null,null,null,null,null,null,null,177717,"177717-0","2022-08-28",null,null,"2022-07-13","2022-07-19","2022-07-20","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-18",null,494408,-494408,197763.20000000001,49440.800000000003,6,494408,0,"Yes","No",0,null,17000,21240,409440,0,46728,494408,0,null,3.4384556884192813E-2,4.296046989530914E-2,0.82814193945081793,0,9.4513033769680108E-2]
[null,null,null,null,"Latino/a/x Multnomah County BHRNJuntos LLC","Multnomah",51,"Latino/a/x Multnomah County BHRN",33,177729,"Juntos LLC","Juntos, LLC","064",true,"2022-11-01","Valid",null,null,null,null,null,null,"2023-06-08","2023-06-08","No","No worker's compensation (does have Umbrella coverage)",177729,"177729-0","Pending",null,null,"2022-07-20","2022-07-15","2022-07-20","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-14",null,564793.91,-564793.91,225917.57,56479.39,6,564793.91,0,"Yes","No",0,null,316350,5000,250944,0,0,572294,-7500.0899999999701,null,0.55277532177517152,8.7367681646146906E-3,0.43848791006021381,0,0]
[null,null,null,null,"Latino/a/x Multnomah County BHRNNew Avenues for Youth","Multnomah",51,"Latino/a/x Multnomah County BHRN",33,177720,"New Avenues for Youth","New Avenues for Youth, Inc.","083",true,"2023-02-18","Valid",null,null,null,null,null,null,null,null,null,null,177720,"177720-0","2022-09-02",null,null,"2022-07-12","2022-07-15","2022-07-20","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-14",null,1059239,-1059239,423965.6,105923.9,6,1059509,-270,"Yes","No",0,null,549750,26000,192327.4,153000,138461.60999999999,1059539.01,-300.01000000000897,null,0.51885772473823311,2.4538973793895517E-2,0.18151988570954078,0.14440242271023132,0.13068099304809927]
[null,null,null,null,"Latino/a/x Multnomah County BHRNNorthwest Family Services","Multnomah",51,"Latino/a/x Multnomah County BHRN",33,177725,"Northwest Family Services","Northwest Family Services","087",true,"2023-07-07","Valid",true,171993,null,null,null,null,"2022-12-31",null,"No","No professional liability coverage or worker's compensation",177725,"177725-0","Pending",null,null,"2022-07-12","2022-07-15","2022-07-20","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-14",null,512761.25,-512761.25,205104.47,51276.13,6,512761.25,0,"Yes","No",0,null,446931,2000,17216,0,46615,512762,-0.75,null,0.87161490126023378,3.9004450407791528E-3,3.3575030911026947E-2,0,9.0909622787960109E-2]
[null,null,null,null,"Latino/a/x Multnomah County BHRNNorthwest Instituto Latino De Adicciones","Multnomah",51,"Latino/a/x Multnomah County BHRN",33,177715,"Northwest Instituto Latino De Adicciones","Northwest Instituto Latino De Adicciones","088",true,"2023-06-15","Valid",true,170473,null,null,null,null,"2022-12-31",null,"No","No professional liability coverage or worker's compensation",177715,"177715-0","2022-09-07",null,null,"2022-07-20","2022-07-18","2022-07-20","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-17",null,1204980.8400000001,-1204980.8400000001,481992.36,120498.08,6,1204980.8400000001,0,"Yes","No",0,null,662287.39,107431.56,323300,null,111961.89,1204980.8400000001,0,null,0.54962483054917288,8.9156239197961021E-2,0.26830302131608996,0,9.291590893677612E-2]
[null,null,null,null,"Latino/a/x Multnomah County BHRNSE Works Inc","Multnomah",51,"Latino/a/x Multnomah County BHRN",33,177706,"SE Works Inc","SE Works Inc.",124,true,"2022-09-10","Valid",true,170471,null,null,null,"2023-07-01","2023-07-01",null,"No","No professional liability coverage",177706,"177706-0","Pending",null,null,"2022-07-12","2022-07-15","2022-07-20","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-14",null,917806.84,-917806.84,152967.79,152967.81,5,917806.84,0,"Yes","No",0,null,442891.54,1000,369083.61,18400,86431.7,917806.85,-1.00000000093132E-2,null,0.48255418882524137,1.0895538641926676E-3,0.40213647348567949,2.0047791101145084E-2,9.4171992723741382E-2]
[null,null,null,null,"Latino/a/x Multnomah County BHRNThe 4th Dimension Recovery Center","Multnomah",51,"Latino/a/x Multnomah County BHRN",33,177738,"The 4th Dimension Recovery Center","The 4th Dimension Recovery Center",131,true,"2023-01-14","Valid",true,170896,null,null,null,null,null,null,null,null,177738,"177738-0","2022-09-02",null,null,"2022-07-12","2022-07-15","2022-07-20","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-14",null,2639337.16,-2639337.16,439889.51,439889.53,5,2639337.16,0,"Yes","No",0,null,784595.13,2000,1467069.06,20000,365672.96000000002,2639337.15,1.0000000242143901E-2,null,0.29726976335706107,7.5776601712289771E-4,0.55584753922021679,7.5776601712289771E-3,0.13854727123437036]
[null,null,null,null,"Latino/a/x Multnomah County BHRNThe Pathfinder Network","Multnomah",51,"Latino/a/x Multnomah County BHRN",33,177727,"The Pathfinder Network","Pathfinders of Oregon",null,true,"2022-08-05","Expired",true,170794,null,null,null,"2023-07-01","2023-06-01","2023-06-01","Yes",null,177727,"177727-0","2022-08-29",null,null,"#NO MATCH","2022-07-18","2022-07-20","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-17","#NO MATCH",1660187,"#INVALID OPERATION",664074.80000000005,166018.70000000001,6,1660187,0,"Yes","No","#INVALID OPERATION","#INVALID OPERATION",827644,13050,364707,106264,131167,1442832,217355,"Grant not found, there is a pathfinders of oregon org that is listed above, could be the same thing",0.57362464930081947,9.0447120662696702E-3,0.25277163245616951,7.3649600230657489E-2,9.0909405946083807E-2]
[null,null,null,null,"No Wrong Door BHRN ProvidersCascade Aids Project","Multnomah",51,"No Wrong Door BHRN Providers",34,177693,"Cascade Aids Project","Cascade Aids Project","016",null,null,null,null,null,null,null,null,null,null,null,null,null,177693,"177693-0","Pending",null,null,"2022-07-18","2022-07-18","2022-07-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-17",null,359175.9,-359175.9,59862.65,59862.65,5,359175.9,0,"Yes","No",0,null,243575,2500,113100.9,0,0,359175.9,0,"No budget in the folder",0.67814961972671328,6.9603779095423713E-3,0.31489000236374431,0,0]
[null,null,null,null,"No Wrong Door BHRN ProvidersCascadia Behavioral Healthcare","Multnomah",51,"No Wrong Door BHRN Providers",34,177740,"Cascadia Behavioral Healthcare","Cascadia Behavioral Healthcare, Inc.","017",null,null,null,null,172070,null,null,null,null,null,null,null,null,177740,"177740-0","Pending",null,null,"#NO MATCH","2022-07-18","2022-07-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-17","#NO MATCH",797355.41,"#INVALID OPERATION",318942.17,79735.539999999994,6,797355.41,0,"Yes","No",0,null,633986.6,5000,130575.78,0,27793.03,797355.41,0,null,0.79511168049891323,6.2707293852812757E-3,0.16376107613040464,0,3.4856513985400808E-2]
[null,null,null,null,"No Wrong Door BHRN ProvidersLutheran Community Services","Multnomah",51,"No Wrong Door BHRN Providers",34,177695,"Lutheran Community Services","Lutheran Community Services Northwest","074",true,"2023-01-04","Valid",true,170487,null,null,null,"2023-01-01","2022-07-31","2023-07-31","Yes",null,177695,"177695-0","Pending",null,null,"2022-07-18","2022-07-18","2022-07-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-17",null,1447214.06,-1447214.06,578885.6,144721.41,6,1447214.06,0,"Yes","No",0,null,780034,38091,629089,0,0,1447214,6.0000000055879403E-2,"Unable to locate grant in CLM, multiple Lutheran Community Services but none for Multnomah",0.53899008716057195,2.632022631069075E-2,0.4346896865287373,0,0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(H194,K194)","v":"No Wrong Door BHRN ProvidersNew Avenues for Youth"},"Multnomah",51,"No Wrong Door BHRN Providers",34,177720,"New Avenues for Youth","New Avenues for Youth, Inc.","083",true,"2023-02-18","Valid",null,null,null,null,null,null,null,null,null,null,177720,"177720-0","2022-09-02",null,null,"2022-07-12","2022-07-12","2022-07-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-11",null,1059239,-1059239,423695.6,105923.9,6,1059239,0,"Yes","No",0,null,549750,26000,192327.4,153000,138161.60999999999,1059239.01,-1.00000000093132E-2,null,0.5190046767631793,2.4545923775975736E-2,0.18157129617044598,0.14444332068170337,0.13043478260869565]
[null,null,null,null,"No Wrong Door BHRN ProvidersOHSU, Addiction and Complex Pain","Multnomah",51,"No Wrong Door BHRN Providers",34,177711,"OHSU, Addiction and Complex Pain",null,"091",null,null,null,null,null,null,null,null,null,null,null,null,null,177711,"177711-0","Pending",null,null,"2022-07-18","2022-07-18","2022-07-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-17",null,15028.2,-15028.2,6011.28,1502.82,6,15028.2,0,"Yes","No",0,null,2835,0,8550,0,3643.2,15028.2,0,"OHSU Budgets are in opposite folders",0.18864534674811353,0,{"$f":"IFERROR(BL195/$BO195,\"\")","v":0.56893041082764395},{"$f":"IFERROR(BM195/$BO195,\"\")","v":0},{"$f":"IFERROR(BN195/$BO195,\"\")","v":0.2424242424242424}]
[null,null,null,null,"No Wrong Door BHRN ProvidersOHSU, Partnership Project","Multnomah",51,"No Wrong Door BHRN Providers",34,177712,"OHSU, Partnership Project",null,"092",null,null,null,null,null,null,null,null,null,null,null,null,null,177712,"177712-0","Pending",null,null,"2022-07-18","2022-07-18","2022-07-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-17",null,56875,-56875,22750,5687.5,6,56875,0,"Yes","No",0,null,0,0,49875,7000,null,56875,0,"OHSU Budgets are in opposite folders",{"$f":"IFERROR(BJ196/$BO196,\"\")","v":0},0,0.87692307692307692,0.12307692307692308,0]
[null,null,null,null,"No Wrong Door BHRN ProvidersPortland Street Medicine","Multnomah",51,"No Wrong Door BHRN Providers",34,177750,"Portland Street Medicine","Portland Street Medicine",106,true,"2023-01-03","Valid",null,null,null,null,null,null,null,null,null,null,177750,"177750-0","Pending",null,null,"2022-07-18","2022-07-12","2022-07-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-11",null,563472.51,-563472.51,225389.01,56347.25,6,563472.51,0,"Yes","No",0,null,264368,16000,168698,73500,44907,567473,-4000.4899999999898,null,0.46586886072112682,2.8195174043522776E-2,0.29727934192463784,0.12952158076243275,7.9135042548279827E-2]
[null,null,null,null,"No Wrong Door BHRN ProvidersProvidence Portland Medical Foundation","Multnomah",51,"No Wrong Door BHRN Providers",34,177733,"Providence Portland Medical Foundation","Providence Portland Medical Foundation",111,true,"2023-01-19","Valid",null,null,null,null,null,"2023-01-01","2023-06-01","2023-06-01","Yes",null,177733,"177733-0","Pending",null,null,"2022-07-18","2022-07-13","2022-07-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-12",null,4306032.37,-4306032.37,1722412.93,430603.24,6,4306032.37,0,"Yes","No",0,null,1250921,64000,27150,2682000,0,4024071,281961.37,null,0.31085957479378468,1.5904291947135128E-2,6.7468988494487295E-3,0.66648923440963148,0]
[null,null,null,null,"No Wrong Door BHRN ProvidersSE Works Inc","Multnomah",51,"No Wrong Door BHRN Providers",34,177706,"SE Works Inc","SE Works Inc.",124,true,"2022-09-10","Valid",true,170471,null,null,null,"2023-07-01","2023-07-01",null,"No","No professional liability coverage",177706,"177706-0","Pending",null,null,"2022-07-12","2022-07-13","2022-07-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-12",null,917806.84,-917806.84,152967.79,152967.81,5,917806.84,0,"Yes","No",0,null,442891.54,1000,369083.61,18400,86431.7,917806.85,-1.00000000093132E-2,null,0.48255418882524137,1.0895538641926676E-3,0.40213647348567949,2.0047791101145084E-2,9.4171992723741382E-2]
[null,null,null,null,"No Wrong Door BHRN ProvidersThe 4th Dimension Recovery Center","Multnomah",51,"No Wrong Door BHRN Providers",34,177738,"The 4th Dimension Recovery Center","The 4th Dimension Recovery Center",131,true,"2023-01-14","Valid",true,170896,null,null,null,null,null,null,null,null,177738,"177738-0","2022-09-02",null,null,"2022-07-12","2022-07-12","2022-07-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-11",null,2639337.16,-2639337.16,439889.51,439889.53,5,2639337.16,0,"Yes","No",0,null,784595.13,2000,1467069.06,20000,365672.96000000002,2639337.15,1.0000000242143901E-2,null,0.29726976335706107,7.5776601712289771E-4,0.55584753922021679,7.5776601712289771E-3,0.13854727123437036]
[null,null,null,null,"No Wrong Door BHRN ProvidersThe Everly Project","Multnomah",51,"No Wrong Door BHRN Providers",34,177702,"The Everly Project","The Everly Project",132,true,"2022-11-30","Valid",null,null,null,null,null,null,null,null,null,null,177702,"177702-0","2022-08-26",null,null,"2022-07-18","2022-07-14","2022-07-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-13",null,381255,-381255,152502,38125.5,6,381255,0,"Yes","No",0,null,239180,0,28245,113830,0,381255,0,null,0.62734914951935061,0,7.4084274304599282E-2,0.29856657617605015,0]
[null,null,null,null,"No Wrong Door BHRN ProvidersThe Marie Equi Institute","Multnomah",51,"No Wrong Door BHRN Providers",34,177703,"The Marie Equi Institute","The Marie Equi Institute",135,true,"2023-01-11","Valid",null,null,null,null,null,null,null,null,null,null,177703,"177703-0","2022-09-01",null,null,"2022-07-18","2022-07-18","2022-07-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-17",null,756047.19,-756047.19,302418.87,75604.72,6,756047.19,0,"Yes","No",0,null,598255.12,5500,128292.07,24000,0,756047.19,0,null,0.79129335828891845,7.2746781851011182E-3,0.16968791326372104,3.1744050262259425E-2,0]
[null,null,null,null,"No Wrong Door BHRN ProvidersThe Pathfinder Network","Multnomah",51,"No Wrong Door BHRN Providers",34,177727,"The Pathfinder Network","Pathfinders of Oregon",null,true,"2022-08-05","Expired",true,170794,null,null,null,"2023-07-01","2023-06-01","2023-06-01","Yes",null,177727,"177727-0","2022-08-29",null,null,"#NO MATCH","2022-07-12","2022-07-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-11","#NO MATCH",1660187,"#INVALID OPERATION",664074.80000000005,166018.70000000001,6,1660187,0,"Yes","No","#INVALID OPERATION","#INVALID OPERATION",827644,13050,364707,106264,131167,1442832,217355,"Grant not found, there is a pathfinders of oregon org that is listed above, could be the same thing",0.57362464930081947,9.0447120662696702E-3,0.25277163245616951,7.3649600230657489E-2,9.0909405946083807E-2]
[null,null,null,null,"No Wrong Door BHRN ProvidersYasiin's Luv LLC","Multnomah",51,"No Wrong Door BHRN Providers",34,177748,"Yasiin's Luv LLC","Yasiin's Luv LLC",155,true,"2022-10-14","Valid",null,null,null,null,null,null,null,null,null,null,177748,"177748-0","2022-08-29",null,null,"2022-07-12","2022-07-14","2022-07-18","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-13",null,388335.65,-388335.65,155334.23000000001,38833.57,6,388335.65,0,"Yes","No",0,null,306241,9200,72894,0,0,388335,0.65000000002328295,null,0.78860004892682867,2.3690885446843574E-2,0.18770906562632778,0,0]
[null,null,null,null,"PolkPolk County","Polk",53,"Polk",35,176691,"Polk County",null,105,null,null,null,null,null,null,null,null,null,null,null,null,null,176691,"176691-0","2022-08-11",null,null,"2022-06-21","2022-05-20","2022-06-16","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-06-19",3078773,3078773,0,1231509.2,307877.3,6,3078773,0,"Yes","No",1231509.2,0,1568043,0,297066,1213664,0,3078773,0,null,0.50930776643812325,0,9.6488438738419488E-2,0.39420379482345724,0]
[null,null,null,null,"PolkYouth Era","Polk",53,"Polk",35,176693,"Youth Era","Youth ERA",157,true,"2022-10-06","Valid",null,null,null,null,null,null,null,null,null,null,176693,"176693-0","2022-07-26",null,null,"2022-06-21","2022-05-25","2022-06-16","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-06-24",185949,185949,0,74379.600000000006,18594.900000000001,6,185949,0,"Yes","No",74379.600000000006,0,126136,14350,24197,0,20838,185521,428,null,0.67990146668032192,7.7349733992378225E-2,0.13042728316470911,0,0.11232151616259076]
[null,null,null,null,"ShermanBoulder Care, Inc.","Sherman",55,"Sherman",36,176573,"Boulder Care, Inc.","Boulder Care, Inc.","010",true,"2022-11-25","Valid",null,null,null,null,null,null,"2023-05-07","2023-05-07","No","No workers compensation amount",176573,"176573-0","2022-06-13","2022-06-17","2022-07-17","2022-07-06",null,"2022-07-06","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,null,40000,40000,0,16000,4000,6,40000,0,"Yes","No",16000,0,null,null,null,null,null,0,null,"No budget documented","","","","",""]
[null,null,null,null,"ShermanMid-Columbia Center for Living","Sherman",55,"Sherman",36,176580,"Mid-Columbia Center for Living",null,"079",null,null,null,null,null,null,null,null,null,null,null,null,null,176580,"176580-0","2022-06-17","2022-06-17","2022-07-17","2022-07-06",null,"2022-07-06","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,null,710000,710000,0,284000,71000,6,710000,0,"Yes","No",284000,0,301746,0,238254,170000,0,710000,0,null,0.42499436619718312,0,0.33556901408450707,0.23943661971830985,0]
[null,null,null,null,"TillamookAdventist Health Tillamook","Tillamook",57,"Tillamook",37,"5737004","Adventist Health Tillamook","Adventist Health Tillamook","004",true,"2023-06-26","Valid",null,null,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,null,332640,-332640,133056,33264,6,332640,0,"No","No",0,null,0,72000,230400,0,30240,332640,0,"Naming convention not reflected in Grant Agreement -- cannot pull NTE, MOU or Quarterly Payments",0,0.21645021645021645,0.69264069264069261,0,9.0909090909090912E-2]
[null,null,null,null,"TillamookCARE","Tillamook",57,"Tillamook",37,"5737015","CARE",null,"015",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No","No",0,null,422630,4620,75936.67,276940,78087.67,858214.34,-858214.34,"Naming convention not reflected in Grant Agreement -- cannot pull NTE, MOU or Quarterly Payments",0.49245273622437957,5.3832705708459737E-3,8.8482173346113052E-2,0.32269327962988825,9.098854022877316E-2]
[null,null,null,null,"TillamookRinehart Clinic and Pharmacy","Tillamook",57,"Tillamook",37,177225,"Rinehart Clinic and Pharmacy",null,120,null,null,null,null,null,null,null,null,null,null,null,null,null,177225,"177225-0","2022-08-14",null,null,null,null,null,null,null,"Within 30 Days",0,null,null,null,null,null,null,null,null,null,null,null,null,203074.3,-203074.3,33845.699999999997,33845.72,5,203074.3,0,"No","Paid without MOU",33845.699999999997,0,154803,0,29810,0,18461.3,203074.3,0,null,0.76229734634072366,0,0.14679356275018554,0,9.0909090909090912E-2]
[null,null,null,null,"TillamookTillamook County Community Health","Tillamook",57,"Tillamook",37,177254,"Tillamook County Community Health",null,139,null,null,null,null,null,null,null,null,null,null,null,null,null,177254,"177254-0","Pending",null,null,null,null,null,null,null,"Within 30 Days",0,null,null,null,null,null,null,null,null,null,null,null,null,436943.69,-436943.69,72823.94,72823.95,5,436943.69,0,"No","No",0,null,282097.2,9736.8799999999992,105387.46,0,39722.15,436943.69,0,null,0.64561454131538099,2.2284061362689546E-2,0.24119231473510924,0,9.0909082586820289E-2]
[null,null,null,null,"TillamookTillamook Family Counseling","Tillamook",57,"Tillamook",37,177213,"Tillamook Family Counseling","Tillamook Family Counseling Center",140,true,"2022-08-19","Expired",null,null,null,null,null,null,null,null,null,null,177213,"177213-0","2022-08-18",null,null,null,null,null,null,null,"Within 30 Days",0,null,null,null,null,null,null,null,null,null,null,null,null,207270.8,-207270.8,34545.15,34545.129999999997,5,207270.8,0,"No","No",0,null,173996,3088,11344,0,18842.8,207270.8,0,null,0.83946219149055246,1.4898384142870102E-2,5.4730333457486541E-2,0,9.0909090909090912E-2]
[null,null,null,null,"TillamookTillamook Serenity Club","Tillamook",57,"Tillamook",37,177218,"Tillamook Serenity Club","Tillamook Serenity Club",141,true,"2022-08-25","Expired",null,null,null,null,null,null,null,null,null,null,177218,"177218-0","2022-08-19",null,null,null,null,null,null,null,"Within 30 Days",0,null,null,null,null,null,null,null,null,null,null,null,null,192981.8,-192981.8,77192.72,19298.18,6,192981.8,0,"No","No",0,null,116100,1738,0,57600,17543.8,192981.8,0,null,0.60161113638695463,9.0060306205041098E-3,0,0.2984737420834504,9.0909090909090912E-2]
[null,null,null,null,"TribalBurns Paiute Tribe","Tribal","#NO MATCH","Tribal","#NO MATCH","#NO MATCH","Burns Paiute Tribe","Burns Paiute Tribe Foundation","#NO MATCH",true,"2023-04-27","Valid",null,null,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,180738,null,null,null,null,null,null,null,"No","No",0,null,null,null,null,null,null,0,null,null,"","","","",""]
[null,null,null,null,"TribalCoquille Indian Tribe","Tribal","#NO MATCH","Tribal","#NO MATCH","#NO MATCH","Coquille Indian Tribe","Coquille Indian Tribe, Inc.","#NO MATCH",true,"Inactive","#INVALID OPERATION",null,null,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,559182,null,null,null,null,null,null,null,"No","No",0,null,null,null,null,null,null,0,null,null,"","","","",""]
[null,null,null,null,"TribalCow Creek","Tribal","#NO MATCH","Tribal","#NO MATCH","#NO MATCH","Cow Creek",null,"#NO MATCH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,920424,null,null,null,null,null,null,null,"No","No",0,null,null,null,null,null,null,0,null,null,"","","","",""]
[null,null,null,null,"TribalCT Coos, Lower Umpqua, and Siuslaw","Tribal","#NO MATCH","Tribal","#NO MATCH","#NO MATCH","CT Coos, Lower Umpqua, and Siuslaw",null,"#NO MATCH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,282258,null,null,null,null,null,null,null,"No","No",0,null,null,null,null,null,null,0,null,null,"","","","",""]
[null,null,null,null,"TribalGrand Ronde","Tribal","#NO MATCH","Tribal","#NO MATCH","#NO MATCH","Grand Ronde","Confederated Tribes of the Grand Ronde","#NO MATCH",null,null,null,null,170837,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,1838029,null,null,null,null,null,null,null,"No","No",0,null,null,null,null,null,null,0,null,null,"","","","",""]
[null,null,null,null,"TribalKlamath Tribes","Tribal","#NO MATCH","Tribal","#NO MATCH","#NO MATCH","Klamath Tribes",null,"#NO MATCH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,703848,null,null,null,null,null,null,null,"No","No",0,null,null,null,null,null,null,0,null,null,"","","","",""]
[null,null,null,null,"TribalNARA","Tribal","#NO MATCH","Tribal","#NO MATCH","#NO MATCH","NARA","Native American Rehabilitation Association of the Northwest dba NARA NW","#NO MATCH",null,null,null,true,170492,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,1644600,null,null,null,null,null,null,null,"No","No",0,null,null,null,null,null,null,0,null,null,"","","","",""]
[null,null,null,null,"TribalNPAIHB","Tribal","#NO MATCH","Tribal","#NO MATCH","#NO MATCH","NPAIHB",null,"#NO MATCH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,412159,null,null,null,null,null,null,null,"No","No",0,null,null,null,null,null,null,0,null,null,"","","","",""]
[null,null,null,null,"TribalSiletz","Tribal","#NO MATCH","Tribal","#NO MATCH","#NO MATCH","Siletz",null,"#NO MATCH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,1713690,null,null,null,null,null,null,null,"No","No",0,null,null,null,null,null,null,0,null,null,"","","","",""]
[null,null,null,null,"TribalUmatilla","Tribal","#NO MATCH","Tribal","#NO MATCH","#NO MATCH","Umatilla",null,"#NO MATCH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,1088214,null,null,null,null,null,null,null,"No","No",0,null,null,null,null,null,null,0,null,null,"","","","",""]
[null,null,null,null,"TribalWarm Springs","Tribal","#NO MATCH","Tribal","#NO MATCH","#NO MATCH","Warm Springs",null,"#NO MATCH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,1776858,null,null,null,null,null,null,null,"No","No",0,null,null,null,null,null,null,0,null,null,"","","","",""]
[null,null,null,null,"UmatillaCommunity Counseling Solutions","Umatilla",59,"Umatilla",38,176681,"Community Counseling Solutions","Community Counseling Solutions","031",true,"2022-11-02","Valid",null,null,null,null,null,null,null,null,null,null,176681,"176681-0","2022-06-21","2022-06-21","2022-07-21","2022-06-15","2022-06-15","2022-06-15","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-15",387989,388000,-11,155200,38800,6,388000,0,"Yes","No",155200,0,275009,67180,45800,0,0,387989,11,null,0.70880617749472274,0.17314923876707844,0.11804458373819876,0,0]
[null,null,null,null,"UmatillaEastern Oregon Alcoholism Foundation","Umatilla",59,"Umatilla",38,176688,"Eastern Oregon Alcoholism Foundation","Eastern Oregon Alcoholism Foundation","041",true,"2022-11-29","Valid",null,null,null,null,null,null,null,null,null,null,176688,"176688-0","2022-06-17","2022-06-21","2022-07-21","2022-06-15","2022-06-14","2022-06-15","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-14",3958110,3958110,0,1583244,395811,6,3958110,0,"Yes","No",1583244,0,458184,25806,624730,2849390,0,3958110,0,null,0.11575827857234892,6.5197783790748613E-3,0.15783543155698049,0.71988651149159577,0]
[null,null,null,null,"UmatillaEastern Oregon Center for Independent Living","Umatilla",59,"Umatilla",38,176692,"Eastern Oregon Center for Independent Living","Eastern Oregon Center for Independent Living","042",true,"2022-08-25","Expired",null,null,null,null,null,"2022-12-01","2023-01-12",null,"No","Umbrella aggregate coverage is $1M but Grant Agreement requires $2M of annual aggregate professional liability coverage",176692,"176692-0","2022-06-17","2022-06-21","2022-07-21","2022-06-15","2022-06-14","2022-06-15","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-14",977781,977781,0,391112.4,97778.1,6,977781,0,"Yes","No",391112.4,0,212381,0,176511,500000,88889,977781,0,null,0.21720712511288315,0,0.18052201873425644,0.51136195119356997,9.0908904959290479E-2]
[null,null,null,null,"UnionCenter for Human Development","Union",61,"Union",39,177093,"Center for Human Development","Center for Human Development, Inc.","019",true,"2022-12-01","Valid",null,null,null,null,null,null,null,null,null,null,177093,"177093-0","2022-07-18",null,null,"2022-07-05","2022-07-06",null,"Yes","Yes","Within 30 Days",0,null,null,null,null,null,null,null,null,null,null,"2022-08-05",null,1257129,-1257129,502851.6,125712.9,6,1257129,0,"No","Paid without MOU",502851.6,0,562022,15635,433462,150600,95410,1257129,0,null,0.44706788245279522,1.243706890860047E-2,0.3448031188525601,0.11979677503263388,7.5895154753410354E-2]
[null,null,null,null,"UnionEastern Oregon Center for Independent Living","Union",61,"Union",39,177094,"Eastern Oregon Center for Independent Living","Eastern Oregon Center for Independent Living","042",true,"2022-08-25","Expired",null,null,null,null,null,"2022-12-01","2023-01-12",null,"No","Umbrella aggregate coverage is $1M but Grant Agreement requires $2M of annual aggregate professional liability coverage",177094,"177094-0","2022-07-20",null,null,"2022-07-05","2022-07-06","2022-07-06","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-05",null,567433,-567433,226973.2,56743.3,6,567433,0,"Yes","No",226973.2,0,123828,0,87691,285000,70914.47,567433.47,-0.46999999997205999,null,0.21822470218402873,0,0.15453970313030707,0.50226152503834509,0.12497406964731919]
[null,null,null,null,"WallowaBoulder Care, Inc.","Wallowa",63,"Wallowa",40,176864,"Boulder Care, Inc.","Boulder Care, Inc.","010",true,"2022-11-25","Valid",null,null,null,null,null,null,"2023-05-07","2023-05-07","No","No workers compensation amount",176864,"176864-0","2022-07-07",null,null,"2022-07-06","2022-07-05","2022-07-06","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-04",40000,40000,0,16000,4000,6,40000,0,"Yes","No",16000,0,null,null,null,null,null,0,null,"No budget documented","","","","",""]
[null,null,null,null,"WallowaWallowa Valley Center for Wellness","Wallowa",63,"Wallowa",40,176869,"Wallowa Valley Center for Wellness","Wallowa Valley Center for Wellness",148,true,"2023-02-08","Valid",null,null,null,null,null,null,null,null,null,null,176869,"176869-0","2022-07-12",null,null,"2022-07-06","2022-07-06","2022-07-06","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-08-05",710000,710000,0,284000,71000,6,710000,0,"Yes","No",284000,0,117026,20000,340974,232000,0,710000,0,null,0.16482535211267604,2.8169014084507043E-2,0.48024507042253523,0.3267605633802817,0]
[null,null,null,null,"WascoBridges to Change","Wasco",65,"Wasco",41,176985,"Bridges to Change","Bridges to Change, Inc.","011",true,"2023-02-13","Valid",true,170864,null,null,null,null,null,null,null,null,176985,"176985-0","2022-07-18",null,null,"2022-08-30",null,null,null,null,"Within 30 Days",0,null,null,null,null,null,null,null,null,null,null,null,null,589466,-589466,117893.18,78595.47,6,589466,0,"No","Paid without MOU",117893.18,0,403032,13923,12435,106488,53588,589466,0,null,0.68372391282957801,2.3619682899437795E-2,2.1095364278855777E-2,0.18065164063745831,9.0909399354670156E-2]
[null,null,null,null,"WascoColumbia Gorge Health Council","Wasco",65,"Wasco",41,"6541029","Columbia Gorge Health Council","Columbia Gorge Health Council","029",true,"2022-08-20","Expired",null,null,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No","No",0,null,null,null,null,null,null,0,null,"Ben informed us that this partner dropped out of this BHRN","","","","",""]
[null,null,null,null,"WascoEastern Oregon Center for Independent Living","Wasco",65,"Wasco",41,176979,"Eastern Oregon Center for Independent Living","Eastern Oregon Center for Independent Living","042",true,"2022-08-25","Expired",null,null,null,null,null,"2022-12-01","2023-01-12",null,"No","Umbrella aggregate coverage is $1M but Grant Agreement requires $2M of annual aggregate professional liability coverage",176979,"176979-0","2022-07-07",null,null,"2022-08-30",null,null,null,null,"Within 30 Days",0,null,null,null,null,null,null,null,null,null,null,null,null,400085,-400085,160034,40008.5,6,400085,0,"No","No",0,null,192314,0,171400,0,36371,400085,0,null,0.48068285489333518,0,0.42840896309534227,0,9.09081820113226E-2]
[null,null,null,null,"WascoGive them WINGS","Wasco",65,"Wasco",41,176986,"Give them WINGS","Give them WINGS, Incorporated","050",true,"2022-11-30","Valid",null,null,null,null,null,null,null,null,null,null,176986,"176986-0","2022-07-24",null,null,"2022-08-30",null,null,null,null,"Within 30 Days",0,null,null,null,null,null,null,null,null,null,null,null,null,115800,-115800,19300,19300,5,115800,0,"No","Paid without MOU",19300,0,58000,0,57800,0,0,115800,0,null,0.50086355785837655,0,0.4991364421416235,0,0]
[null,null,null,null,"WascoGreater Oregon Behavioral Health","Wasco",65,"Wasco",41,"6541054","Greater Oregon Behavioral Health","Greater Oregon Behavioral Health, Inc.","054",true,"2023-05-02","Valid",null,null,null,null,null,null,null,null,null,null,null,"-0",null,null,null,null,null,null,null,null,"Pending Grant Agreement Execution",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No","No",0,null,null,null,null,null,null,0,null,"Ben informed us that this partner dropped out of this BHRN","","","","",""]
[null,null,null,null,"WascoMid-Columbia Center for Living","Wasco",65,"Wasco",41,176991,"Mid-Columbia Center for Living",null,"079",null,null,null,null,null,null,null,null,null,null,null,null,null,176991,"176991-0","2022-07-28",null,null,"2022-08-30",null,null,null,null,"Within 30 Days",0,null,null,null,null,null,null,null,null,null,null,null,null,647086,-647086,107847.6,107847.67999999999,5,647086,0,"No","No",0,null,384210,4000,258876,0,0,647086,0,null,0.59375415323465508,6.1815585563588151E-3,0.40006428820898615,0,0]
[null,null,null,null,"WascoMid-Columbia Medical Center","Wasco",65,"Wasco",41,176987,"Mid-Columbia Medical Center",null,"080",null,null,null,null,null,null,null,null,null,null,null,null,null,176987,"176987-0","2022-09-02",null,null,"2022-08-30",null,null,null,null,"Within 30 Days",0,null,null,null,null,null,null,null,null,null,null,null,null,132000,-132000,22000,22000,5,132000,0,"No","No",0,null,108000,null,null,null,null,108000,24000,"Extraneous $3,000 in budget",1,0,0,0,0]
[null,null,null,null,"WascoNorth Central Public Health District","Wasco",65,"Wasco",41,176993,"North Central Public Health District",null,"085",null,null,null,null,null,null,null,null,null,null,null,null,null,176993,"176993-0","2022-07-11",null,null,"2022-08-30",null,null,null,null,"Within 30 Days",0,null,null,null,null,null,null,null,null,null,null,null,null,105271,-105271,42108.4,10527.1,6,105271,0,"No","No",0,null,61218,6000,30553.06,0,0,97771.06,7499.94,null,0.62613620022121064,6.1367852614055737E-2,0.31249594716473361,0,0]
[null,null,null,null,"WascoOne Community Health","Wasco",65,"Wasco",41,176988,"One Community Health","One Community Health","093",true,"2023-03-12","Valid",null,null,null,null,null,null,null,null,null,null,176988,"176988-0","Pending",null,null,null,null,null,null,null,"Within 30 Days",0,null,null,null,null,null,null,null,null,null,null,null,null,11770,-11770,1961.75,1961.65,5,11770,0,"No","No",0,null,0,11770,0,0,0,11770,0,null,0,1,0,0,0]
[null,null,null,null,"WascoYouth Empowerment Shelter","Wasco",65,"Wasco",41,176990,"Youth Empowerment Shelter","Youth Empowerment Shelter",156,true,"2023-02-06","Valid",null,null,null,null,null,null,null,null,null,null,176990,"176990-0","2022-07-19",null,null,"2022-08-30",null,null,null,null,"Within 30 Days",0,null,null,null,null,null,null,null,null,null,null,null,null,101427,-101427,16904.5,16904.5,5,101427,0,"No","Paid without MOU",16904.5,0,78244.320000000007,6252,16931.52,0,0,101427.84,-0.83999999999650798,null,0.77142843621632884,6.1639881121396255E-2,0.16693168266227498,0,0]
[null,null,null,null,"WashingtonBridges to Change","Washington",67,"Washington",42,176710,"Bridges to Change","Bridges to Change, Inc.","011",true,"2023-02-13","Valid",true,170864,null,null,null,null,null,null,null,null,176710,"176710-0","2022-07-06",null,null,"2022-06-21","2022-06-14","2022-06-14","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-14",1522479.62,1522479.62,0,608991.86,152247.96,6,1522479.62,0,"Yes","No",608991.86,0,null,null,null,null,null,0,null,"No budget provided, budget in the folder is washington county behavioral health budget","","","","",""]
[null,null,null,null,"WashingtonCODA, Inc.","Washington",67,"Washington",42,176712,"CODA, Inc.","CODA, Inc.","027",true,"2022-09-26","Valid",null,null,null,null,null,null,null,null,null,null,176712,"176712-0","Pending",null,null,"2022-06-28","2022-06-24","2022-06-28","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-24",545025,545025,0,90837.5,90837.5,6,635862.5,-90837.5,"Yes","No",0,null,368346,0,33250,14813,128511,544920,105,"No budget provided in clm folder",0.67596344417529175,0,6.101813110181311E-2,2.7183806797328049E-2,0.23583461792556706]
[null,null,null,null,"WashingtonForest Grove Foundation","Washington",67,"Washington",42,176714,"Forest Grove Foundation","Forest Grove Foundation, Inc.","048",true,"2023-04-18","Valid",null,null,null,null,null,null,null,null,null,null,176714,"176714-0","2022-07-04",null,null,"2022-06-30","2022-06-30","2022-06-30","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-30",2606426,2606426,0,1042570.4,260642.6,6,2606426,0,"Yes","No",1042570.4,0,859326,27500,379600,1340000,0,2606426,0,null,0.32969514576665521,1.0550846254603046E-2,0.14564004502717515,0.51411396295156664,0]
[null,null,null,null,"WashingtonHIV Alliance","Washington",67,"Washington",42,176711,"HIV Alliance","HIV Alliance","058",true,"2022-09-21","Valid",true,172261,null,null,null,null,null,null,null,null,176711,"176711-0","2022-07-14",null,null,"2022-06-21","2022-06-13","2022-06-23","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-13",404829,404829,0,67471.5,67471.5,5,404829,0,"Yes","No",67471.5,0,302211,2000,63815,0,36803,404829,0,null,0.74651519530468424,4.9403575336747123E-3,0.15763445800572587,0,9.0909989155915208E-2]
[null,null,null,null,"WashingtonIdeal Option","Washington",67,"Washington",42,176713,"Ideal Option","Ideal Option PLLC","061",true,"2023-06-13","Valid",null,null,null,null,null,"2023-05-01","2023-05-01","2023-05-01","Yes",null,176713,"176713-0","2022-08-30",null,null,"2022-06-20","2022-06-17","2022-06-20","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-17",47500,47500,0,19000,4750,6,47500,0,"Yes","No",0,null,0,9500,38000,0,0,47500,0,"No budget provided, budget in the folder is washington county behavioral health budget",0,0.2,0.8,0,0]
[null,null,null,null,"WashingtonLifeWorks NW","Washington",67,"Washington",42,176708,"LifeWorks NW","Lifeworks NW","071",true,"2023-03-13","Valid",true,172166,null,null,null,null,null,null,null,null,176708,"176708-0","2022-06-24",null,null,"2022-06-29","2022-06-15","2022-06-29","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-15",2213593,2213593,0,368932.2,368932.16,5,2213593,0,"Yes","No",368932.2,0,320586,5419,92008,3000,60554,481567,1732026,"No budget provided, budget in the folder is washington county behavioral health budget",0.66571422045115214,1.1252847475013861E-2,0.19105960333660738,6.2296627468244291E-3,0.12574366599040215]
[null,null,null,null,"WashingtonLutheran Community Services","Washington",67,"Washington",42,176706,"Lutheran Community Services","Lutheran Community Services Northwest","074",true,"2023-01-04","Valid",true,170487,null,null,null,"2023-01-01","2022-07-31","2023-07-31","Yes",null,176706,"176706-0","2022-07-08",null,null,"2022-06-22","2022-06-21","2022-06-22","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-21",814072,814072,0,135678.70000000001,135678.66,5,814072,0,"Yes","No",135678.70000000001,0,468367,11000,137728,14950,182029,814074,-2,"No budget provided, budget in the folder is washington county behavioral health budget",0.57533713151384269,1.351228512395679E-2,0.1691836368683928,1.8364423873014003E-2,0.22360252262079369]
[null,null,null,null,"WashingtonMetroPlus Association","Washington",67,"Washington",42,176881,"MetroPlus Association","Addiction Counselor Certification Board of Oregon, Inc.","078",true,"2024-06-22","Valid",null,null,null,null,null,null,null,null,null,null,176881,"176881-0","2022-07-04",null,null,"2022-06-29","2022-06-12","2022-06-29","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-12",42710,42710,0,17084,4271,6,42710,0,"Yes","No",0,null,5000,29100,4810,3800,0,42710,0,"Unable to find BHRN Partner in CLM -- cannot pull NTE, MOU or Quarterly Payments",0.11706860220088972,0.68133926480917817,0.11261999531725592,8.8972137672676185E-2,0]
[null,null,null,null,"WashingtonMiracles Club","Washington",67,"Washington",42,176738,"Miracles Club","The Miracles Club","081",true,"2022-11-14","Valid",true,170476,null,null,null,null,null,null,null,null,176738,"176738-0","2022-06-22",null,null,"2022-06-29","2022-06-13","2022-06-29","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-13",395701,395701,0,65950.2,65950.16,5,395701,0,"Yes","No",65950.2,0,263447,608,36142,38000,57497,395694,7,null,0.66578467199401559,1.536540862383559E-3,9.1338256329385845E-2,9.6033803898972439E-2,0.14530672691524257]
[null,null,null,null,"WashingtonMorrison Child and Family Services","Washington",67,"Washington",42,176735,"Morrison Child and Family Services","Morrison Child and Family Services","082",true,"2023-03-15","Valid",true,170819,null,null,null,null,null,null,null,null,176735,"176735-0","2022-07-12",null,null,"2022-06-29","2022-06-29","2022-06-29","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-29",280098,280098,0,46683,46683,5,280098,0,"Yes","No",46683,0,204837,572,74689,0,0,280098,0,null,0.73130475762054714,2.0421423930195859E-3,0.26665309998643333,0,0]
[null,null,null,null,"WashingtonNW Instituto Latino","Washington",67,"Washington",42,176733,"NW Instituto Latino","Northwest Instituto Latino De Adicciones","089",true,"2023-06-15","Valid",true,170473,null,null,null,null,null,null,null,null,176733,"176733-0","2022-09-01",null,null,"2022-06-29","2022-06-13","2022-06-29","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-13",734594,734594,0,122432.35,122432.33,5,734594,0,"Yes","No",0,null,388351,27000,253280,0,65963,734594,0,"No budget provided in CLM folder",0.5286607296002962,3.6754996637598458E-2,0.34478909438410876,0,8.9795179377996553E-2]
[null,null,null,null,"WashingtonPhoenix Rising Transitions","Washington",67,"Washington",42,176732,"Phoenix Rising Transitions","Phoenix Rising",103,true,"2023-10-15","Valid",null,null,null,null,null,null,null,null,null,null,176732,"176732-0","2022-06-22",null,null,"2022-06-21","2022-06-12","2022-06-23","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-12",69466.27,69466.27,0,27786.55,6946.62,6,69466.27,0,"Yes","No",27786.55,0,56724.31,3603.27,9138.69,0,0,69466.27,0,null,0.81657342477147532,5.1870785634524491E-2,0.13155578959400008,0,0]
[null,null,null,null,"WashingtonSequoia Mental Health","Washington",67,"Washington",42,176729,"Sequoia Mental Health","Sequoia Mental Health Services, Inc.",125,true,"2023-06-08","Valid",null,null,null,null,null,"2022-10-01","2023-07-01","2023-07-01","Yes",null,176729,"176729-0","2022-07-05",null,null,"2022-06-21","2022-06-09","2022-06-13","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-09",701134.15,701134.15,0,116855.7,116855.69,5,701134.15,0,"Yes","No",116855.7,0,528710.75,10750,161673.4,0,0,701134.15,0,null,0.75407930137192714,1.5332301243635044E-2,0.23058839738443776,0,0]
[null,null,null,null,"WashingtonThe 4th Dimension Recovery Center","Washington",67,"Washington",42,176743,"The 4th Dimension Recovery Center","The 4th Dimension Recovery Center",131,true,"2023-01-14","Valid",true,170896,null,null,null,null,null,null,null,null,176743,"176743-0","2022-06-24",null,null,null,"2022-06-10","2022-06-29","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-10",null,444559.71,-444559.71,74093.31,74093.279999999999,5,444559.71,0,"Yes","No",74093.31,0,321145.19,1500,66500,15000,40414.519999999997,444559.71,0,null,0.72238932763385144,3.3741249291349409E-3,0.14958620519164906,3.3741249291349411E-2,9.09090929540151E-2]
[null,null,null,null,"WashingtonThe Mental Health Association of Oregon","Washington",67,"Washington",42,176741,"The Mental Health Association of Oregon","The Mental Health & Addiction Association of Oregon",136,true,"2023-07-20","Valid",null,null,null,null,null,null,null,null,null,null,176741,"176741-0","2022-06-28",null,null,"2022-06-29","2022-06-12","2022-06-29","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-12",624496.35,624496.35,0,104082.75,104082.72,5,624496.35,0,"Yes","No",104082.75,0,504379.68,17251.2,102865.47,0,0,624496.35,0,null,0.80765833138976717,2.7624180669750913E-2,0.16471748794048197,0,0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(H258,K258)","v":"WashingtonThe Recovery Gym (Alano Club)"},"Washington",67,"Washington",42,176717,"The Recovery Gym (Alano Club)","The Recovery Gym","05",true,"Inactive","#INVALID OPERATION",null,null,null,null,null,null,null,null,null,null,176717,"176717-0","2022-06-22",null,null,"2022-06-29","2022-06-10","2022-06-29","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-10",639243.19999999995,639243.19999999995,0,255697.28,63924.32,6,639243.19999999995,0,"Yes","No",0,null,395773.2,9600,22800,211070,0,639243.19999999995,0,null,0.61912774355675593,1.5017758499425571E-2,3.5667176436135734E-2,0.33018732150768287,0]
[null,null,null,null,"WashingtonVirginia Garcia Memorial Health","Washington",67,"Washington",42,176730,"Virginia Garcia Memorial Health","Virginia Garcia Memorial Health Center",146,true,"2022-07-31","Expired",null,null,null,null,null,"2023-04-01","2023-04-01","2023-04-01","Yes",null,176730,"176730-0","2022-07-08",null,null,"2022-06-21","2022-06-10","2022-06-23","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-10",1187803.07,1187803.07,0,197967.22,197967.17,5,1187803.07,0,"Yes","No",197967.22,0,1091100.07,32931,63772,0,0,1187803.07,0,null,0.91858667278911821,2.7724292714616405E-2,{"$f":"IFERROR(BL259/$BO259,\"\")","v":5.3689034496265442E-2},{"$f":"IFERROR(BM259/$BO259,\"\")","v":0},{"$f":"IFERROR(BN259/$BO259,\"\")","v":0}]
[null,null,null,null,"WashingtonWashington County Behavioral Health Division","Washington",67,"Washington",42,176865,"Washington County Behavioral Health Division",null,149,null,null,null,null,null,null,null,null,null,null,null,null,null,176865,"176865-0","2022-08-08",null,null,"2022-06-17","2022-06-16","2022-06-17","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-16",5328561.6900000004,5328560.58,1.1100000003352799,2131424.2799999998,532856.05000000005,6,5328560.58,0,"Yes","No",0,null,195259.84,1066.56,2957.28,5129276.9000000004,null,5328560.58,0,null,{"$f":"IFERROR(BJ260/$BO260,\"\")","v":3.6644012406067079E-2},2.0015912064567348E-4,5.5498665269936747E-4,0.96260084182058792,0]
[null,null,null,null,"WashingtonWashington County Public Health","Washington",67,"Washington",42,176867,"Washington County Public Health",null,150,null,null,null,null,null,null,null,null,null,null,null,null,null,176867,"176867-0","Pending",null,null,"2022-06-29","2022-06-15","2022-06-30","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-15",1927410.08,1927410.08,0,770964.08,192741,6,1927410.08,0,"Yes","No",0,null,1360609,16694.41,131179.92000000001,100000,318926.75,1927410.08,0,null,0.70592605803950137,8.6615765753388606E-3,6.8060202320826296E-2,5.1883094852341959E-2,0.1654690682119915]
[null,null,null,null,"WheelerBoulder Care, Inc.","Wheeler",69,"Wheeler",43,176489,"Boulder Care, Inc.","Boulder Care, Inc.","010",true,"2022-11-25","Valid",null,null,null,null,null,null,"2023-05-07","2023-05-07","No","No workers compensation amount",176489,"176489-0","2022-06-15","2022-06-15","2022-07-15","2022-06-22","2022-06-21","2022-06-22","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-21",40000,40000,0,16000,4000,6,40000,0,"Yes","No",16000,0,null,null,null,null,null,0,null,"No budget provided","","","","",""]
[null,null,null,null,"WheelerCommunity Counseling Solutions","Wheeler",69,"Wheeler",43,176487,"Community Counseling Solutions","Community Counseling Solutions","031",true,"2022-11-02","Valid",null,null,null,null,null,null,null,null,null,null,176487,"176487-0","2022-06-13","2022-06-15","2022-07-15","2022-06-22","2022-06-22","2022-06-22","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-22",710000,710000,0,284000,71000,6,710000,0,"Yes","No",284000,0,401692,0,299645,8663,0,710000,0,null,0.56576338028169015,0,0.42203521126760563,1.2201408450704226E-2,0]
[null,null,null,null,"BrightsideRecovery Works NW","Yamhill",71,"Brightside",44,177106,"Recovery Works NW","Recovery Works NW LLC",116,true,"2023-04-07","Valid",null,null,null,null,null,null,"2022-12-22",null,"No","No professional liability coverage or workers compensation amounts",177106,"177106-0","2022-08-14",null,null,"2022-07-01","N/A","N/A","No MOU Required","No MOU Required","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-09-13",1093552,1093552,0,437420.79999999999,109355.2,6,1093552,0,"Yes","No",437420.79999999999,0,212390.39999999999,30000,66500,746242.56000000006,38389.040000000001,1093522,30,"Included Health Systems Technology amount in Capital Outlay",0.19422599636769997,2.7434290302344167E-2,6.0812676836862908E-2,0.68242116756681626,3.5105868926276748E-2]
[null,null,null,null,"Yamhill CountyAlano Club","Yamhill",71,"Yamhill County",45,177107,"Alano Club","The Alano Club of Portland, Oregon","005",true,"2022-12-09","Valid",true,170478,null,null,null,null,null,null,null,null,177107,"177107-0","2022-07-14",null,null,"2022-07-01","2022-06-29","2022-07-01","Yes","No","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-29",357675,357675,0,143070,35767.5,6,357675,0,"Yes","No",143070,0,239055,9600,78300,30720,0,357675,0,null,0.6683581463619207,2.6840008387502622E-2,0.21891381841056826,8.5888026840008388E-2,0]
[null,null,null,null,"Yamhill CountyEncompass Yamhill Valley","Yamhill",71,"Yamhill County",45,177109,"Encompass Yamhill Valley","Encompass Yamhill Valley","043",true,"2023-06-11","Valid",null,null,null,null,null,null,"2023-07-01",null,"No","No direct reference to professional liability coverage or worker's compensation amounts",177109,"177109-0","2022-07-18",null,null,"2022-07-01","2022-06-20","2022-07-01","Yes","No","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-20",253245,253245,0,101298,25324.5,6,253245,0,"Yes","No",101298,0,216284,8000,28961,0,0,253245,0,null,0.85405042547730459,3.1589962289482514E-2,0.11435961223321289,0,0]
[null,null,null,null,"Yamhill CountyProvidence Newberg Medical Center","Yamhill",71,"Yamhill County",45,177096,"Providence Newberg Medical Center","Providence Newberg Medical Center",110,true,"2024-06-08","Valid",null,null,null,null,null,"2023-01-01","2023-06-01","2023-06-01","Yes",null,177096,"177096-0","2022-07-26",null,null,"2022-07-01","2022-06-24","2022-07-01","Yes","No","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-24",273213,273213,0,45535.5,45535.5,5,273213,0,"Yes","No",45535.5,0,273213.46000000002,0,0,0,0,273213.46000000002,-0.46000000002095498,"Budget lists two salaries that add up to total funding amount",1,0,0,0,0]
[null,null,null,null,"Yamhill CountyProvoking Hope","Yamhill",71,"Yamhill County",45,173772,"Provoking Hope",null,113,null,null,null,null,null,null,null,null,null,null,null,null,null,173772,"173772-0","2021-12-13",null,null,"2022-07-01","2022-06-17","2022-07-01","Yes","No","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-17",1925413,1925413,0,770165.2,192541.3,6,1925413,0,"Yes","No",0,null,1893227,2664,23022,6500,0,1925413,0,"No NTE, MOU, or Quarterly payment amounts in Grant Agreement",0.98328358643054758,1.3835992589641807E-3,1.1956915217670182E-2,3.3758990928180084E-3,0]
[null,null,null,null,"Yamhill CountyVirginia Garcia Clinic","Yamhill",71,"Yamhill County",45,177097,"Virginia Garcia Clinic","Virginia Garcia Memorial Health Center",146,true,"2022-07-31","Expired",null,null,null,null,null,"2023-04-01","2023-04-01","2023-04-01","Yes",null,177097,"177097-0","2022-07-14",null,null,"2022-07-01","2022-06-23","2022-06-23","Yes","Yes","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-23",409478,409478,0,68246.350000000006,68246.33,5,409478,0,"Yes","No",0,null,391646.49,2931,14900.51,0,0,409478,0,null,0.95645306951777631,7.157893708575308E-3,3.6389036773648402E-2,0,0]
[null,null,null,null,"Yamhill CountyYamhill Community Action Partnership","Yamhill",71,"Yamhill County",45,177099,"Yamhill Community Action Partnership","Yamhill Community Action Partnership",153,true,"2023-01-22","Valid",null,null,null,null,null,null,null,null,null,null,177099,"177099-0","2022-07-28",null,null,"2022-07-01","2022-06-24","2022-07-01","Yes","No","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-24",977681,977681,0,162946.85,162946.82999999999,5,977681,0,"Yes","No",162946.85,0,494066,6000,343926.15,25000,106017.04,975009.19,2671.81000000006,null,0.50672958272321522,6.1537881504481005E-3,0.35274144441653932,2.5640783960200416E-2,0.10873440074959703]
[null,null,null,null,"Yamhill CountyYamhill County HHS","Yamhill",71,"Yamhill County",45,177100,"Yamhill County HHS",null,154,null,null,null,null,null,null,null,null,null,null,null,null,null,177100,"177100-0","2022-08-19",null,null,"2022-07-01","2022-06-30","2022-07-01","Yes","No","Complete",0,null,null,null,null,null,null,null,null,null,null,"2022-07-30",2096198,1925413,170785,770165.2,192541.3,6,1925413,0,"Yes","No",0,null,1515856,65334,515007,0,0,2096197,-170784,null,0.72314577303564498,3.1167872103623848E-2,0.24568635486073112,0,0]

{"sheet":"Certification","index":4,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[6,2,6,3],[9,2,9,3],[13,2,13,3]]}
[]
[null,"Certification"]
[]
[null,null,"I attest that these are only M110 funds (check box)"]
[]
[]
[null,null,"Phil"]
[null,null,"PREPARED BY"]
[]
[]
[null,null,"AUTHORIZED AGENT SIGNATURE"]
[null,null,"Please type your signature in the box above"]
[]
[]
[null,null,"DATE"]

{"sheet":"Data Entry Import","index":5,"n_rows":26,"n_cols":19,"rows_kept":26,"cut":false,"hidden":true,"merged":[[2,16,2,18],[17,0,17,1],[2,1,2,5],[2,6,2,10],[2,11,2,15]]}
[]
[]
[null,"Informational Data",null,null,null,null,"M110 Budget by Budget Category (%)",null,null,null,null,"M110 Budget by Budget Category",null,null,null,null,"Certification Information"]
["Expense Category","BHRN Name","BHRN Partner Name","Grant Agreement Number","Contract Not-to-Exceed Amount","Does Original Budget Require Revision?","Personnel Costs (%)","Program Staff Training Costs (%)","Services and Supplies Costs (%)","Capital Outlay Costs (%)","Admin Costs (%)","Personnel Costs  ($)","Program Staff Training Costs ($)","Services and Supplies Costs ($)","Capital Outlay Costs ($)","Admin Costs ($)","Prepared by:","Authorized Agent Signature:","Date"]
["Data",{"$f":"'Budget Report'!D6","v":"Yamhill_County"},{"$f":"'Budget Report'!D7","v":0},{"$f":"'Budget Report'!D8","v":""},{"$f":"'Budget Report'!D9","v":0},{"$f":"'Budget Report'!D11","v":0},{"$f":"'Budget Report'!E28","v":0},{"$f":"'Budget Report'!E29","v":0},{"$f":"'Budget Report'!E30","v":0},{"$f":"'Budget Report'!E31","v":0},{"$f":"'Budget Report'!E32","v":0},{"$f":"'Budget Report'!F28","v":0},{"$f":"'Budget Report'!F29","v":0},{"$f":"'Budget Report'!F30","v":0},{"$f":"'Budget Report'!F31","v":0},{"$f":"'Budget Report'!F32","v":"num"},{"$f":"Certification!C7","v":"Phil"},{"$f":"Certification!C10","v":0},{"$f":"Certification!C14","v":"00:00:00"}]
[]
["Errors","Result"]
["Is the Report Dated After 12/1/2022?"]
[" Is report signed (Y/N)?"]
["Is the box checked to attest that only M110 funds are used?"]
["Section B Completed"]
["Report Balanced?"]
["Contract Number Entered?"]
["Expenditure Report does not include all prior quarters?","Check If all prior quarter(s) totals included"]
["Current Quarter Expenditures Reported?","Review If Current Quarter Expenditures Reported"]
[]
[]
["Error Code Legend"]
[1,"Is the Report Dated After 12/31/2022?"]
[1," Is report signed (Y/N)?"]
[3,"Section B Completed"]
[4,"Report Balanced?"]
[5,"Outdated Template Submitted?"]
[6,"Contract Number Entered?"]
[7,"Expenditure Report does not include all prior quarters?"]
[8,"Current Quarter Expenditures Reported?"]