{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","Matrix"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
["From each section  - borrower, collateral, purpose, and repayment source - select the column that best fits and filter it to \"Yes.\""]
["Start with borrower and move to the right."]
["You do not need to select the secured by real estate column, as it will not get to the answer immediately, but it is there if you want to narrow the choices."]
["The reset button at the top will place all of the filters back in the original starting position."]

{"sheet":"Matrix","index":1,"n_rows":24,"n_cols":36,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Please note this is a tool to help in decision making. It should not replace your knowledge or thought process. Also note this is considered a beta version."]
[]
[null,"Borrower",null,null,null,null,null,null,"Collateral",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Purpose",null,null,null,null,null,null,null,null,"Repayment Source"]
["Call Report Code","Government Agency","Depository financial institution","Non-depository financial institution","Farmer","Non-profit organization","Commercial Business/Sole Prop","Consumer","Is the loan secured by real estate","Land/Commercial Construction","Residential (1-4 Family) First","Residential Junior","Commercial property","Farmland","Multi-family (5+)","Hotel","Mini-storage","Nursing Home","Business Assets","Securities","Cash","Unsecured","Vehicle","Boat/Plane/Jet ski etc.","Farm/ag","Commercial - W/C, purchase prop, equip, etc.\nNot HELOC or Construction","Consumer (not prearranged overdraft) - not HELOC","HELOC","Credit Cards - Consumer","Construction - Any","Purchase Land","Purchase securities","Prearranged Overdraft/Other Consumer - not credit Card","Rental income - includes income from hotels, self storage\nMust be from an unrelated party","Personal income","Cash flow from operations"]
["1.a.1","No","Yes","Yes","Yes","Yes","Yes","Yes","Yes","No","Yes","Yes","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","Yes","No","No","No","Yes","Yes","Yes"]
["1.a.2","No","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","No","No","Yes","Yes","Yes","Yes","Yes","Yes","No","No","No","No","No","No","No","No","Yes","Yes","No","Yes","Yes","No","No","Yes","Yes","Yes"]
["1.b","No","Yes","Yes","Yes","Yes","Yes","No","Yes","No","No","No","No","Yes","No","No","No","No","No","No","No","No","No","No","Yes","No","No","No","No","No","No","No","No","Yes","No","Yes"]
["1.c.1","No","Yes","Yes","Yes","Yes","Yes","Yes","Yes","No","Yes","Yes","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","Yes","No","No","No","No","No","Yes","Yes","Yes"]
["1.c.2.a","No","Yes","Yes","Yes","Yes","Yes","Yes","Yes","No","Yes","No","No","No","No","No","No","No","No","No","No","No","No","No","No","Yes","Yes","No","No","No","No","No","No","Yes","Yes","Yes"]
["1.c.2.b","No","Yes","Yes","Yes","Yes","Yes","Yes","Yes","No","No","Yes","No","No","No","No","No","No","No","No","No","No","No","No","No","Yes","Yes","No","No","No","No","No","No","Yes","Yes","Yes"]
["1.d","No","Yes","Yes","Yes","Yes","Yes","No","Yes","No","No","No","No","No","Yes","No","No","No","No","No","No","No","No","No","No","Yes","No","No","No","No","No","No","No","Yes","No","No"]
["1.e.1","No","Yes","Yes","Yes","Yes","Yes","No","Yes","No","No","No","Yes","No","No","No","No","No","No","No","No","No","No","No","No","Yes","No","No","No","No","No","No","No","No","Yes","Yes"]
["1.e.2","No","Yes","Yes","Yes","Yes","Yes","No","Yes","No","No","No","Yes","No","No","Yes","Yes","Yes","No","No","No","No","No","No","Yes","Yes","No","No","No","Yes","Yes","Yes","No","Yes","No","No"]
[2,"No","Yes","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","Yes","Yes","Yes","Yes","Yes","Yes","No","Yes","No","No","No","No","No","No","No","Yes","No","Yes"]
[3,"No","No","No","Yes","No","No","No","Yes","Yes","Yes","Yes","Yes","No","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","No","No","No","No","No","No","No","No","Yes","No","Yes"]
[4,"No","No","No","Yes","No","Yes","No","No","No","No","No","No","No","No","No","No","No","Yes","Yes","Yes","Yes","Yes","Yes","No","Yes","No","No","No","Yes","Yes","Yes","No","Yes","Yes","Yes"]
["6.a","No","No","No","Yes","No","No","Yes","No","No","No","No","No","No","No","No","No","No","No","No","Yes","Yes","No","No","No","No","No","No","Yes","No","No","No","No","No","Yes","No"]
["6.b","No","No","No","Yes","No","No","Yes","No","No","No","No","No","No","No","No","No","No","No","No","No","Yes","No","No","No","No","Yes","Yes","No","No","No","No","No","No","Yes","No"]
["6.c","No","No","No","Yes","No","No","Yes","No","No","No","No","No","No","No","No","No","No","No","No","No","No","Yes","No","No","No","Yes","Yes","No","No","No","No","No","No","Yes","No"]
["6.d","No","No","No","Yes","No","No","Yes","No","No","No","No","No","No","No","No","No","No","No","No","No","Yes","No","Yes","No","No","Yes","Yes","No","No","No","No","Yes","No","Yes","No"]
[8,"Yes","No","No","No","No","No","No","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","No","No","No","Yes","Yes","Yes","No","Yes","No","Yes"]
["9.a","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","Yes","No","No","No","Yes","No","No","No","No","No","No","No","No","No","No"]
["9.b","No","Yes","Yes","Yes","Yes","No","Yes","No","No","No","No","No","No","No","No","No","No","Yes","Yes","Yes","Yes","Yes","Yes","No","No","No","No","No","No","No","Yes","No","Yes","Yes","Yes"]
["Blank",1]