{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Fee for Service Invoice","One Twelfth Invoice","Invoice Instructions","Welcome","Reference Sheet"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":3,"defined_names":18,"comments":2,"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":"Fee for Service Invoice","index":0,"n_rows":22,"n_cols":27,"rows_kept":22,"cut":false,"hidden":true,"merged":[[20,14,21,15],[21,2,21,3],[21,7,21,8],[21,10,21,11],[0,5,0,10],[6,2,6,4],[4,2,4,4],[4,12,4,13],[2,0,2,15],[4,7,4,8],[0,11,0,14],[6,12,6,14],[8,0,9,1],[8,7,8,8],[8,10,8,11],[6,7,6,8],[17,0,17,15],[19,14,19,15],[10,2,10,4],[15,0,15,4],[6,10,6,11],[8,2,8,4],[10,13,10,14],[13,0,13,4],[14,0,14,4]]}
[null,null,null,null,null,"ODHS Fee for Service Contract Invoice",null,null,null,null,null,{"$f":"IF('One Twelfth Invoice'!O11>0,\"One Twelfth tab has lines.\",\"\")","v":""},null,null,null,"CF0846\n(05/10/2021)"]
[]
["Payee information"]
[]
["  Payee number:",null,null,null,null,null,"Payee contact:",null,null,null,null,"Invoice number:"]
[]
["  Payee name:",null,null,null,null,null,"Contact email:",null,null,null,"DHS Branch | County:",null," "]
[]
["  Payee address:",null,null,null,null,null,"Contact phone:",null,null,null,"Billing month/year:"]
[]
[null,null,"(Street, City, State, ZIP)",null,null,null,null,null,null,null,null,null,null,"Validated Amount",null,{"$f":"SUM(AA21:AA22)/2","v":0}]
[]
[]
[]
["Payee Electronic Signature",null,null,null,null,"Date"]
[]
["  Payee Invoice comments (if needed):",null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Invoice",{"$f":"SUM(M21:M22)","v":0}]
["  Example comment: This invoice was submitted to Newport and Coos Bay branches for approval."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[" Line #","Contract Number","Case Number","Participant Number","Participant Last Name","Participant First Name","Service Category","Service Type","Service Start Date","Service End Date","Rate Per Unit","Number of Units","Invoiced Amount","Service Outcome","OFS Only",null," ","Case Number Sort","Contract Number Sort","Participant Number","Service Category","Service Type","Service Start Date","Participant First Name","Participant Last Name","Branch","Validated Amount"]
[{"$f":"A19+1","v":1},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDDOWN(K21*L21,2)","v":0},null,"`",null," ",{"$f":"C21","v":0},{"$f":"B21","v":0},{"$f":"D21","v":0},{"$f":"G21","v":0},{"$f":"H21","v":0},{"$f":"I21","v":"00:00:00"},{"$f":"F21","v":0},{"$f":"E21","v":0},{"$f":"F22","v":0},{"$f":"IF(OR(N22=\"VP\",N22=\"OP\"),M21,0)","v":0}]
[{"$f":"A21","v":1},"Payee Notes:",null,null,"Branch/\nOffice: ",null,"DHS Notes:",null,null,"Payment ID:",null,null,"Validation code:",null,null,null," ",{"$f":"C21","v":0},{"$f":"B21","v":0},{"$f":"D21","v":0},{"$f":"G21","v":0},{"$f":"H21","v":0},{"$f":"I21","v":"00:00:00"},{"$f":"F21","v":0},{"$f":"E21","v":0},{"$f":"F22","v":0},{"$f":"IF(OR(N22=\"VP\",N22=\"OP\"),M21,0)","v":0}]

{"sheet":"One Twelfth Invoice","index":1,"n_rows":23,"n_cols":26,"rows_kept":23,"cut":false,"hidden":true,"merged":[[21,12,22,14],[22,2,22,3],[10,2,12,5],[14,0,14,4],[16,0,16,4],[15,0,15,4],[18,0,18,14],[20,12,20,14],[0,11,0,13],[2,0,2,14],[6,9,6,10],[8,9,8,10],[6,11,6,13],[4,2,4,5],[6,2,6,5],[8,2,8,5],[6,7,6,8],[8,7,8,8],[4,7,4,8],[0,3,0,10],[8,0,9,1]]}
[null,null,null,"           ODHS Contract Invoice for Regular 1/12th Monthly Payments",null,null,null,null,null,null,null,{"$f":"IF('Fee for Service Invoice'!P17>0,\"Fee for Service tab and BRS tab have lines.\",\"\")","v":""},null,null,"CF0846\n(05/10/2021)"," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
["Payee information"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
["  Payee number:",null,null,null,null,null,"Payee contact:",null,null,null,"Invoice number:",null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
["  Payee name:",null,null,null,null,null,"Contact email:",null,null,"DHS Branch | County:",null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
["  Payee address:",null,null,null,null,null,"Contact phone:",null,null,"Billing month/year:",null,null," ",null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,"(Street, City, State, ZIP)",null,null,null,null,null,null,null,null,null,null,"Units (calculated field)",{"$f":"SUM(Z21:Z23)/2","v":0}," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Amount per Contract"]
[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," "," "]
["Payee Electronic Signature",null,null,null,null,"Date",null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
["  Payee Invoice comments (if needed):",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
["  Example comment: This invoice was submitted to Newport and Coos Bay branches for approval.",null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[" Line #","Contract Number","Case Number","Participant Number","Participant Last Name","Participant First Name","Service Category","Service Type","Service Start Date","Service End Date","Number of Units","Service Outcome","OFS Only",null,null," ","Case Number Sort","Contract Number Sort","Participant Number","Service Category","Service Type","Service Start Date","Participant First Name","Participant Last Name","Branch","Sum of Units"]
[{"$f":"A20+1","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",{"$f":"C22","v":0},{"$f":"B22","v":0},{"$f":"D22","v":0},{"$f":"G22","v":0},{"$f":"H22","v":0},{"$f":"I22","v":0},{"$f":"F22","v":0},{"$f":"E22","v":0},{"$f":"F23","v":0},{"$f":"K22","v":0}]
[{"$f":"A22","v":1},"Payee Notes:",null,null,"Branch/\nOffice: ",null,"DHS Notes:",null,"Payment ID:",null,"Validation code:",null,null,null,null," ",{"$f":"C22","v":0},{"$f":"B22","v":0},{"$f":"D22","v":0},{"$f":"G22","v":0},{"$f":"H22","v":0},{"$f":"I22","v":0},{"$f":"F22","v":0},{"$f":"E22","v":0},{"$f":"F23","v":0},{"$f":"K22","v":0}]

{"sheet":"Invoice Instructions","index":2,"n_rows":63,"n_cols":3,"rows_kept":63,"cut":false,"hidden":true,"merged":[[0,0,0,2],[15,0,15,1],[36,0,36,1],[31,0,31,1],[34,0,34,1],[33,0,33,1],[32,0,32,1],[35,0,35,1],[10,0,10,2],[11,0,11,1],[1,0,1,1],[3,0,3,1],[4,0,5,1],[19,0,19,1],[18,0,18,1],[12,0,12,1],[37,0,37,1],[38,0,38,1],[42,0,42,1],[41,0,41,1],[40,0,40,1],[39,0,39,1],[13,0,13,1],[14,0,14,1],[17,0,17,1],[16,0,16,1],[29,0,29,1],[30,0,30,1],[22,0,22,1],[21,0,21,1],[20,0,20,1],[23,0,23,1],[28,0,28,1],[27,0,27,1],[26,0,26,1],[25,0,25,1],[24,0,24,1],[43,0,43,1],[52,0,52,1],[53,0,53,1],[57,0,57,1],[56,0,56,1],[55,0,55,1],[54,0,54,1],[51,0,51,1],[45,0,45,1],[46,0,46,1],[48,0,48,1],[47,0,47,1],[49,0,49,1],[50,0,50,1],[44,0,44,1],[60,0,60,1],[59,0,59,1],[58,0,58,1],[61,0,61,2],[69,2,69,4],[62,0,62,1]]}
["Invoice Submission Instructions"]
[]
["Each invoice must be password protected with your provider number, then emailed to the branch from which services were referred."]
[]
["How to password protect your invoice:",null,"Microsoft 2003: File>Save As>Tools>Options>Password to open: Enter DHS Provider #>OK>Reenter password at prompt>OK>Save>Close"]
[null,null,"Microsoft 2007:  Microsoft Office Button>Prepare>Encrypt Document>Enter DHS Provider #>OK>Reenter password at prompt>OK>Save>Close"]
[null,null,"Microsoft 2010 or Newer: File>Info>Protect Workbook>Encrypt with Password>Enter DHS Provider #>Save>Close"]
[]
["Email submission: ",null,"Invoices must be submitted via email to the branch from which services were referred. All Child Welfare branch offices have a standard email box a full listing of branches and their email address is located in this cell.\n\n"]
[null,null,"Title your email subject line with your business name, the words contract invoice and the month/year being invoiced (\"Provider, Contract Invoice, 12/14\")"]
["Invoice Completion Instructions"]
["Invoice Type",null,"Description"]
["Fee for Service Invoice",null,"Complete the \"Contract Invoice\" template tab for purchases and for services with variable rates (as opposed to set monthly rates).\n\nIt is also imperative that the number of units be entered for each service. The type of unit, whether it is days, hours, etc., must be in compliance with the language of the related contract, if no units are outlined in the contract the days of service provided can be used. If no services were provided to the client, but the line needs to stay on the invoice please enter “0” in the units field. "]
["One Twelfth Invoice",null,"Complete the \"One Twelfth Payments\" template tab for services that are paid at a set monthly rate.  \n\nPLEASE NOTE: Provider information located in the top half of the invoice needs to be input on the \"Contract Invoice\" tab; from there it prefills the \"One Twelfth Payments\" tab.\n\nA separate invoice sheet (tab) is required to delineate any contracted services for which a provider receives a regular \"1/12th\" monthly rate.  For these types of contracts there is no \"rate per unit\" to provide nor will an \"invoiced amount\" be calculated.\n\nIt is important to submit a separate one-twelfth invoice for each contract and for each branch within a given contract. It is also imperative that the number of units be entered for each service. The type of unit, whether it is days, hours, etc., must be in compliance with the language of the related contract, if no units are outlined in the contract the days of service provided can be used. If no services were provided to the client, but the line needs to stay on the invoice please enter “0” in the units field."]
["BRS/Non-BRS/\nFocus/One-on-One",null,"Complete the “BRS/Non-BRS/Focus/One-on-One” template tab for services that are provided for BRS and Focus programs.  It is also imperative that the number of units be entered for each service. The type of unit, whether it is days, hours, etc., must be in compliance with the language of the related contract, if no units are outlined in the contract the days of service provided can be used. If no services were provided to the client, but the line needs to stay on the invoice please enter “0” in the units field."]
["Invoice Field Title",null,"Details"]
["Payee number",null,"Individual or organization being paid for services, this is the primary contractor – even it a sub-contractor or foster parent is providing the service. If unsure of the correct provider number, please contact the DHS contract administrator identified in the contract."]
["Payee name",null,"Name of the primary contractor as indicated on page one of the provider’s contracts."]
["Payee address",null,"Provider's billing address. If the address has changed please send an email to Child.Welfare.ContractSupport@state.or.us to have the address updated. "]
["Payee contact",null,"Provider or provider staff who can answer questions about the invoice if necessary."]
["Contact email ",null,"E-mail address where the provider contact can be reached."]
["Contact phone",null,"Daytime phone number where the provider contact can be reached Monday - Friday."]
["Invoice number",null,"Adding a unique invoice number assigned by the provider for each invoice is highly recommended. This number will aid in the provider’s internal tracking purposes and will be printed on the remittance advice. Limit this entry to no more than 11 alpha-numeric digits. If you do not have an invoicing system we recommend you use the month, year, and submission number. For example, your third invoice submittal, during May 2018 would be listed as 05-18-3."]
["DHS branch ",null,"This is a drop-down list, please select the name of the DHS branch you are sending the invoice to. Examples: North Clackamas, Marion, Alberta, Jackson.  If unsure of the correct branch name, please contact the DHS contract administrator identified in the contract. A listing of Child Welfare branch informatin is available by clicking in this cell."]
["Billing month/year",null,"Month and year in which the services documented on the invoice were provided. This date should match service start and end dates listed on individual invoice lines. Do not bill for services provided in more than one month on the same invoice. Submit separate invoices for each month."]
["Validated amount",null,"This is a calculated field; a total will populate as lines are marked payable by branch staff. "]
["Payee signature",null,"Provider authorization to request payment. Provider may type the authorizer's name into the Excel document."]
["Payee invoice comments",null,"Include any information about the entire invoice that will assist staff in the validation or payment of the invoice. "]
["Total invoice",null,"This is a calculate field; a total will populate as lines are entered on the invoice. This represents the total amount requested on the invoice. "]
["Contract number",null,"Enter the contract number as it appears at the top of page one of the contract.\n\nFor placement services when a contract is being written and a contract number is not assigned yet, enter \"N/A\"."]
["Case number",null,"Enter the DHS case number.  The Case number is indicated in the referral document or authorization from DHS that initiated the service. The DHS caseworker can also provide this information."]
["Foster provider / Subcontractor\n(BRS//Non-BRS/Focus/One-on-One)",null,"For placement services, enter the DHS issued foster/proctor provider number where the client was placed for the dates specified.  Each placement must be listed separately.\n\nFor services provided by a subcontractor, enter the DHS issued provider number for the subcontractor that provided services."]
["Participant number",null,"Enter the DHS-assigned participant number for the participant who received the service.  Each individual referred for service has a unique participant ID number. The number can be found in the original referral document or service authorization from DHS. The assigned DHS caseworker can also provide this information."]
["Participant last name",null,"Enter the last name of the individual who received the service. If more than one individual under the same case number received the same service, the information for each participant must be entered on separate lines of the invoice. "]
["Participant first name",null,"Enter the first name of the individual who received the service. If more than one individual under the same case number received the same service, the information for each participant must be entered on separate lines of the invoice."]
["Service category",null,"The service category and service type can be found on the referral document, authorization from DHS that initiated the service, or the contract notification email sent at the start of the contract. The information listed on the invoice must match the approved service category and service type for the invoice to be processed. If you do not have your referral document the DHS caseworker can help provide this information. Contracts often provide for more than one service category or type. If a participant received more than one category or type of service within a given month, the different services must be accounted for on separate lines on the invoice.  "]
["Service type",null,"The service category and service type can be found on the referral document, authorization from DHS that initiated the service, or the contract notification email sent at the start of the contract. The information listed on the invoice must match the approved service category and service type for the invoice to be processed. If you do not have your referral document the DHS caseworker can help provide this information. Contracts often provide for more than one service category or type. If an individual received more than one category or type of service within a given month, the different services must be accounted for on separate lines on the invoice.  "]
["Service start date",null,"Enter the 8 digit date with 2 digits for month, 2 digits for day and 4 digits for year. You must use the \"/\" between fields.\n\nFor services, enter the date on which the service began during the month that the invoice pertains to. Below is an example of how days should be calculated:\n\nReferral/Placement approved for 03/16/2018 thru 05/28/2018. Monthly billings would reflect as follows: \n         March Invoice: 03/16/2018- 03/31/2018= 16 days/units\n         April Invoice:    04/01/2018- 04/30/2018= 30 days/units\n         May Invoice:    05/01/2018- 05/28/2018= 28 days/units\n\nIf invoicing for expenditures of one or more “purchases”, as opposed to “services” indicate the date of the purchase.  If there were more than one purchase, enter the date of the first purchase. Refer to Other Notes for additional guidance related to direct support service and emergency funds purchases. "]
["Service end date",null,"Enter the 8 digit date with 2 digits for month, 2 digits for day and 4 digits for year. You must use the \"/\" between fields.\n\nFor services, enter the date on which the service began during the month that the invoice pertains to. Below is an example of how days should be calculated:\n\nReferral/Placement approved for 03/16/2018 thru 05/28/2018. Monthly billings would reflect as follows: \n         March Invoice: 03/16/2018- 03/31/2018= 16 days/units\n         April Invoice:    04/01/2018- 04/30/2018= 30 days/units\n         May Invoice:    05/01/2018- 05/28/2018= 28 days/units\n\nIf invoicing for expenditures of one or more “purchases”, as opposed to “services” indicate the date of the purchase.  If there were more than one purchase, enter the date of the first purchase. Refer to Other Notes for additional guidance related to direct support service and emergency funds purchases. "]
["Rate per unit",null,"Rate per unit as indicated in the contract's payment provisions or, if provided, in the invoicing instructions issued after execution of the contract. If invoicing for reimbursement for “purchases”, as opposed to “services”, for the participant, enter the total dollar amount of all purchases in the month for the identified participant in this field. Attach a separate list of the individual purchases separated by participant if there is more than one purchase per participant for the month. Must include copies of receipts.  "]
["Number of units",null,"Enter the number of units of service provided during this invoicing period, i.e. the number of hours or quarter hours or days of service or other unit of service as described in the contract's payment provisions. If units aren’t identified in the contract use the number of days the service was provided. If invoicing for expenditures of “purchases”, as opposed to “services”, for the participant, enter “1” in this field. If no services were provided to the client, but the line needs to stay on the invoice please enter “0” in the units field."]
["Invoiced amount",null,"This is a calculate field; a total will populate as information is entered into the “Rate Per Unit” field and the “Number of Units” field. "]
["Service outcome",null,"This field defaults to \"N/A\". Outcome selection to be made at service closure, only as required by contract. If your contract has not yet established outcome determinations, leave this field as \"N/A\"."]
["OFS only",null,"DHS USE ONLY: This field is used by Office of Financial Services staff when processing invoice payments. Please do not enter data into this field. "]
["Payee notes",null,"Enter any line specific notes for branch validators. "]
["Branch",null,"Enter the name of the branch services were provided for. In some cases there are multiple branches receiving services for one contract. "]
["DHS notes",null,"DHS USE ONLY: This field is used by branch staff to make notes on the line while validating the invoice. "]
["Payment ID",null,"DHS USE ONLY: Enter the payment identification number.  Each time DHS authorizes a contracted service for a given individual, the Department’s information system generates a unique payment identification number to aid DHS in service tracking and payment."]
["Validation code",null,"DHS USE ONLY: Enter an applicable Validation Code from this list:\n\nAH – Agency Hold - withhold payment at this time while branch staff work internally to resolve\nBH – BRS (Placement) Hold - withhold payment at this time while branch staff work internally to resolve.\nCH – Contract Hold - withhold payment at this time while DHS staff work to finalize contract.\nFH – Financial Hold – payment is on hold due to processing issue in OFS.\nNP – Do not pay - this line is not expected to ever be paid.\nOP – Pay, One Time Payment\nPH – Provider Hold - withhold payment at this time while branch staff work with the provider to resolve.\nVP – Pay"]
["Button",null,"Instructions for Invoice Button Options"]
["Add a row",null,"With your cursor in any field of the invoice, click \"Add a row\" to insert a new row for entry at the bottom of the invoice. The invoice is set up to automatically add one row for provider entry with a joined row for DHS notes. These new rows are automatically numbered."]
["Delete a row",null,"Select a cell where provider information has been input then click \"Delete a row\". This will delete your row of entry and its corresponding DHS notes row.\n\nPlease be very careful in selecting the row to delete because there is no way to undo this selection."]
["Copy a row",null,"Before you copy a row, you need to follow the instructions above to Add a row. Once you've added a row, place your cursor in any cell of the row you want to copy, click \"Copy row\". A message will pop up telling you \"Click on any cell in destination row to paste.\" Once you click into a cell where you want to paste, click \"Ok\" and your row will be copied and pasted. \n\nIf you accidentally select a cell in a row where you don't want to paste you can delete the cell name from the pop up box, hit Esc or select cancel. If you hit Esc or select cancel you will get a message stating \"Action Canceled.\""]
["Clear row contents",null,"Select a cell where provider information has been input then click \"Clear row contents\". This will delete the contents of the row of entry and its corresponding DHS notes row.\n\nPlease be very careful in selecting the row to clear because there is no way to undo this selection."]
["Freeze & scroll",null,"Select \"Freeze & scroll\" when entering several lines of data to allow the column headings to remain in sight."]
["Unfreeze rows",null,"Select \"Unfreeze rows\" to allow scrolling up and down through the entire invoice."]
["Contract number sort",null,"Select \"Contract number sort\" to see all services grouped by contract number."]
["Case number sort",null,"Select \"Case number sort\" to see all services grouped by case number."]
["Last name sort",null,"Select \"Last name sort\" to see all services grouped by the last name of the participant. "]
["Branch sort",null,"Select “Branch sort” to see all services grouped by branch. "]
["Sync invoice",null,"When provider and DHS staff work to validate invoice information it is recommended that both parties select the \"Sync Invoice\" button to re-align all invoice rows. This sorts the invoices by participant number. "]
["Other Notes"]
["Direct Support Services & Emergency Funds",null,"Only enter one total on one line of the invoice for all purchases in a given month separated by participant if there is more than one purchase per participant for the month. Receipts must accompany the invoice. It is recommended that providers log purchases on the provided template to quicken the review and payment process. Alternatively, a note on each receipt that corresponds with the line number on which the purchase is listed on the invoice can be accepted."]

{"sheet":"Welcome","index":3,"n_rows":41,"n_cols":2,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[null,"WELCOME!\nBelow are examples of one or more steps to be performed to access the DHS Contract Invoice and for the "]
[null," invoice to function properly. Depending on the security settings of you computer and or network and "]
[null,"the version of Excel being used the examples below could be different than what appears on your "]
[null,"monitor.  Please review all of the information below before performing the steps. "]
[]
[]
[null,"For Excel 2016"]
[]
[]
[]
[]
[]
[null,"PROTECTED VIEW - If this message appears select the Enable Editing button as shown in the example above."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"SECURITY WARNING - If this message appears select the Enable Content button as shown in the example above."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"SECURITY WARNING - If this message appears select Yes to make this file a Trusted Document."]
[]
[]
[null,"For Excel 2007"]

{"sheet":"Reference Sheet","index":4,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
["District","Branch","County","Branch | County",null,"Month","Year",null,null,"Validation Code","Service Outcome"]
[1,"Albany","Linn",{"$f":"B2&\" | \"&C2","v":"Albany | Linn"},null,"January ",2018,null,null,"AH","N/A"]
[1,"Alberta","Multnomah","Alberta | Multnomah",null,"February",2019,null,null,"BH","Achieved"]
[1,"Astoria","Clatsop","Astoria | Clatsop",null,"March",2020,null,null,"CH","Partially Achieved"]
[2,"Baker City","Baker","Baker City | Baker",null,"April",2021,null,null,"FH","Not Achieved"]
[2,"Beaverton","Washington","Beaverton | Washington",null,"May",2022,null,null,"NP","No progress"]
[2,"Boardman","Morrow","Boardman | Morrow",null,"June",2023,null,null,"OP"]
[2,"BRS","Central Office","BRS | Central Office",null,"July",2024,null,null,"PH"]
[2,"Burns","Harney","Burns | Harney",null,"August",null,null,null,"VP"]
[2,"Central Office","Central Office","Central Office | Central Office",null,"September"]
[3,"Coos Bay","Coos","Coos Bay | Coos",null,"October"]
[3,"Corvallis","Benton","Corvallis | Benton",null,"November"]
[3,"Crook","Crook","Crook | Crook",null,"December"]
[4,"Curry","Curry","Curry | Curry"]
[4,"Deschutes","Deschutes","Deschutes | Deschutes"]
[4,"District Office 2","Multnomah","District Office 2 | Multnomah"]
[5,"East","Multnomah","East | Multnomah"]
[6,"Enterprise","Wallowa","Enterprise | Wallowa"]
[6,"Eugene","Lane","Eugene | Lane"]
[7,"Focus","Central Office","Focus | Central Office"]
[8,"Gilliam","Gilliam","Gilliam | Gilliam"]
[8,"Gresham","Multnomah","Gresham | Multnomah"]
[8,"Hermiston","Umatilla","Hermiston | Umatilla"]
[9,"Hillsboro","Washington","Hillsboro | Washington"]
[9,"Hood River","Hood River","Hood River | Hood River"]
[9,"Hotline","Multnomah","Hotline | Multnomah"]
[10,"ILP","Central Office","ILP | Central Office"]
[10,"Jackson","Jackson","Jackson | Jackson"]
[11,"Jefferson","Jefferson","Jefferson | Jefferson"]
[11,"John Day","Grant","John Day | Grant"]
[11,"Josephine","Josephine","Josephine | Josephine"]
[12,"Klamath Falls","Klamath","Klamath Falls | Klamath"]
[12,"La Grande","Union","La Grande | Union"]
[12,"Lakeview","Lake",{"$f":"B34&\" | \"&C34","v":"Lakeview | Lake"}]
[13,"Marion","Marion","Marion | Marion"]
[13,"Midtown","Multnomah","Midtown | Multnomah"]
[13,"Newport","Lincoln","Newport | Lincoln"]
[14,"North Clackamas","Clackamas","North Clackamas | Clackamas"]
[14,"Ontario","Malheur","Ontario | Malheur"]
[15,"Oregon City","Clackamas","Oregon City | Clackamas"]
[15,"Pendleton","Umatilla","Pendleton | Umatilla"]
[15,"Personal Care","Central Office","Personal Care | Central Office"]
[16,"Polk","Polk","Polk | Polk"]
[16,"Roseburg","Douglas","Roseburg | Douglas"]
["Tribal","St. Helens","Columbia","St. Helens | Columbia"]
["ILP","Tigard Admin Office (SOC Contracts ONLY)","Washington","Tigard Admin Office (SOC Contracts ONLY) | Washington"]
["BRS","Tillamook","Tillamook","Tillamook | Tillamook"]
["Focus","Tribal Contracts","Central Office","Tribal Contracts | Central Office"]
["PC","Wasco","Wasco","Wasco | Wasco"]
["CO","Yamhill","Yamhill","Yamhill | Yamhill"]
[null,null,null," "]