{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["README","Reading_list"],"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":"README","index":0,"n_rows":44,"n_cols":3,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["Hey!"]
["This is a quick page that might help you if you run into challenges with the macros."]
[]
["The macros are very sensitive to changes in the worksheet and workbook. It can be super annoying."]
["Note the hidden OR and AND columns which are the basis of the filtering."]
["If you get an error, check the following things:"]
["1) open the macro code"]
[null,"Right click on the name of the worksheet and click \"view code\""]
[null,"This will open a VBA window"]
[null,"On the Lefthand panel there is a list of modules. Each of these relates to either the clear filter, the apply OR, or apply AND buttons"]
[]
["2) check the worksheet name"]
[null,"The first error could be caused because it doesn't know the sheet name"]
[null,"See this line of code"]
[null,null,"Worksheets(\"Sheet1\").AutoFilterMode = False"]
[null,"Make sure that everywhere it says \"Sheet1\" is refering to the name of the tab (i.e. worksheet) your button is in"]
[]
["3) Check the range"]
[null,"This line"]
[null,null,"Worksheets(\"Sheet1\").Range(\"A6:N6\").AutoFilter"]
[null,"refers to the range on which to apply the filter (these should be the column names of the Table)"]
[null,"If you add a column, you will need to change the range to include the new column number"]
[null,"If you add or remove a row, you'll need to change the number to refer to the header row"]
[]
["4) Check the criteria"]
[null,"If you add a column, then you also need to repoint the field to the flag column"]
[null,"See this code"]
[null,null,"Field:=13, _"]
[null,"Field refers to the column number of the flag column."]
[null,"The OR field value is the column number of the True/False column for the OR"]
[null,"etc."]
[null,"So remember to change it"]
[]
[]
["CHANGING THE SEARCH CRITERIA"]
["The filters are currently set up so you can apply filters to multiple columns or combinations of columns of the Table."]
["The \"OR\" filter will retain results that match ANY of the criteria"]
["The \"AND\" filter will retain results that match ALL of the criteria"]
[]
["The columns to filter by (e.g. \"Title\", \"Author\", \"Notes\") can be changed by changing the formulas in the hidden columns (M:N)"]
["If you want to add a new column for searching, the general format is:"]
[null,"For OR:","IF(ISBLANK(search_cell), FALSE, ISNUMBER(SEARCH(search_cell,[@Heading_name]))"]
[null,"For AND:","IF(ISBLANK(search_cell), TRUE, ISNUMBER(SEARCH(search_cell,[@Heading_name]))"]
["You need to add this into the outer AND() or OR() functions."]

{"sheet":"Reading_list","index":1,"n_rows":23,"n_cols":15,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,0,3,0],[0,2,0,7],[2,9,3,10]]}
[null,null,"Column(s) / data to search"]
[null,null,"Author","Title","Journal","Keywords","Notes (H:L)","All"]
[null,"OR",null,null,null,null,null,null,null,"NOTE: Do not drag and drop text in the search cells (C3:H4), as this will affect the filter formulae"]
[null,"AND"]
[]
["Author","Title","Year","Date read","Journal","Keywords","Location","Main ideas","Methods","Results","Other notes","My thoughts","OR","AND","."]
["Logan, Williams, Nisbet, Liberman, Zuo, Guikema","Evaluating urban accessibility: leveraging open-source data and analytics to overcome existing limitations",2017,"2017-01-11","Environment and planning B","urban accessibility; proximity","USA","develop a framework for measuring proximity to urban services","the method:\n- is independent of subjective thresholds\n- is at the parcel level\n- utilizes open source data and routing algorithms\n","analysis at aggregated scales (e.g. census blocks) can give significantly different pictures of accessibility --> motivation for using their method","Tim and Tom are really cool",null,{"$f":"OR(IF(ISBLANK($D$3), FALSE, ISNUMBER(SEARCH($D$3,Reading[[#This Row],[Title]]))),IF(ISBLANK($F$3), FALSE, ISNUMBER(SEARCH($F$3,Reading[[#This Row],[Keywords]]))), IF(ISBLANK($E$3), FALSE, ISNUMBER(SEARCH($E$3, Reading[[#This Row],[Journal]]))), IF(ISBLANK($G$3), FALSE, ISNUMBER(SEARCH($G$3, _xlfn.CONCAT(Reading[[#This Row],[Main ideas]:[My thoughts]])))), IF(ISBLANK($H$3), FALSE, ISNUMBER(SEARCH($H$3, _xlfn.CONCAT(Reading[[#This Row],[Author]:[My thoughts]])))), IF(ISBLANK($C$3), FALSE, ISNUMBER(SEARCH($C$3, Reading[[#This Row],[Author]]))), IF(COUNTBLANK($C$3:$H$3)=6, TRUE, FALSE))","v":true},{"$f":"AND(IF(ISBLANK($D$4), TRUE, ISNUMBER(SEARCH($D$4,Reading[[#This Row],[Title]]))), IF(ISBLANK($F$4), TRUE, ISNUMBER(SEARCH($F$4,Reading[[#This Row],[Keywords]]))), IF(ISBLANK($E$4), TRUE, ISNUMBER(SEARCH($E$4, Reading[[#This Row],[Title]]))), IF(ISBLANK($G$4), TRUE, ISNUMBER(SEARCH($G$4, _xlfn.CONCAT(Reading[[#This Row],[Main ideas]:[My thoughts]])))), IF(ISBLANK($H$4), TRUE, ISNUMBER(SEARCH($H$4, _xlfn.CONCAT(Reading[[#This Row],[Author]:[My thoughts]])))), IF(ISBLANK($C$4), TRUE,ISNUMBER(SEARCH($C$4, Reading[[#This Row],[Author]]))))","v":true}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"OR(IF(ISBLANK($D$3), FALSE, ISNUMBER(SEARCH($D$3,Reading[[#This Row],[Title]]))),IF(ISBLANK($F$3), FALSE, ISNUMBER(SEARCH($F$3,Reading[[#This Row],[Keywords]]))), IF(ISBLANK($E$3), FALSE, ISNUMBER(SEARCH($E$3, Reading[[#This Row],[Journal]]))), IF(ISBLANK($G$3), FALSE, ISNUMBER(SEARCH($G$3, _xlfn.CONCAT(Reading[[#This Row],[Main ideas]:[My thoughts]])))), IF(ISBLANK($H$3), FALSE, ISNUMBER(SEARCH($H$3, _xlfn.CONCAT(Reading[[#This Row],[Author]:[My thoughts]])))), IF(ISBLANK($C$3), FALSE, ISNUMBER(SEARCH($C$3, Reading[[#This Row],[Author]]))), IF(COUNTBLANK($C$3:$H$3)=6, TRUE, FALSE))","v":true},{"$f":"AND(IF(ISBLANK($D$4), TRUE, ISNUMBER(SEARCH($D$4,Reading[[#This Row],[Title]]))), IF(ISBLANK($F$4), TRUE, ISNUMBER(SEARCH($F$4,Reading[[#This Row],[Keywords]]))), IF(ISBLANK($E$4), TRUE, ISNUMBER(SEARCH($E$4, Reading[[#This Row],[Title]]))), IF(ISBLANK($G$4), TRUE, ISNUMBER(SEARCH($G$4, _xlfn.CONCAT(Reading[[#This Row],[Main ideas]:[My thoughts]])))), IF(ISBLANK($H$4), TRUE, ISNUMBER(SEARCH($H$4, _xlfn.CONCAT(Reading[[#This Row],[Author]:[My thoughts]])))), IF(ISBLANK($C$4), TRUE,ISNUMBER(SEARCH($C$4, Reading[[#This Row],[Author]]))))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"OR(IF(ISBLANK($D$3), FALSE, ISNUMBER(SEARCH($D$3,Reading[[#This Row],[Title]]))),IF(ISBLANK($F$3), FALSE, ISNUMBER(SEARCH($F$3,Reading[[#This Row],[Keywords]]))), IF(ISBLANK($E$3), FALSE, ISNUMBER(SEARCH($E$3, Reading[[#This Row],[Journal]]))), IF(ISBLANK($G$3), FALSE, ISNUMBER(SEARCH($G$3, _xlfn.CONCAT(Reading[[#This Row],[Main ideas]:[My thoughts]])))), IF(ISBLANK($H$3), FALSE, ISNUMBER(SEARCH($H$3, _xlfn.CONCAT(Reading[[#This Row],[Author]:[My thoughts]])))), IF(ISBLANK($C$3), FALSE, ISNUMBER(SEARCH($C$3, Reading[[#This Row],[Author]]))), IF(COUNTBLANK($C$3:$H$3)=6, TRUE, FALSE))","v":true},{"$f":"AND(IF(ISBLANK($D$4), TRUE, ISNUMBER(SEARCH($D$4,Reading[[#This Row],[Title]]))), IF(ISBLANK($F$4), TRUE, ISNUMBER(SEARCH($F$4,Reading[[#This Row],[Keywords]]))), IF(ISBLANK($E$4), TRUE, ISNUMBER(SEARCH($E$4, Reading[[#This Row],[Title]]))), IF(ISBLANK($G$4), TRUE, ISNUMBER(SEARCH($G$4, _xlfn.CONCAT(Reading[[#This Row],[Main ideas]:[My thoughts]])))), IF(ISBLANK($H$4), TRUE, ISNUMBER(SEARCH($H$4, _xlfn.CONCAT(Reading[[#This Row],[Author]:[My thoughts]])))), IF(ISBLANK($C$4), TRUE,ISNUMBER(SEARCH($C$4, Reading[[#This Row],[Author]]))))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"OR(IF(ISBLANK($D$3), FALSE, ISNUMBER(SEARCH($D$3,Reading[[#This Row],[Title]]))),IF(ISBLANK($F$3), FALSE, ISNUMBER(SEARCH($F$3,Reading[[#This Row],[Keywords]]))), IF(ISBLANK($E$3), FALSE, ISNUMBER(SEARCH($E$3, Reading[[#This Row],[Journal]]))), IF(ISBLANK($G$3), FALSE, ISNUMBER(SEARCH($G$3, _xlfn.CONCAT(Reading[[#This Row],[Main ideas]:[My thoughts]])))), IF(ISBLANK($H$3), FALSE, ISNUMBER(SEARCH($H$3, _xlfn.CONCAT(Reading[[#This Row],[Author]:[My thoughts]])))), IF(ISBLANK($C$3), FALSE, ISNUMBER(SEARCH($C$3, Reading[[#This Row],[Author]]))), IF(COUNTBLANK($C$3:$H$3)=6, TRUE, FALSE))","v":true},{"$f":"AND(IF(ISBLANK($D$4), TRUE, ISNUMBER(SEARCH($D$4,Reading[[#This Row],[Title]]))), IF(ISBLANK($F$4), TRUE, ISNUMBER(SEARCH($F$4,Reading[[#This Row],[Keywords]]))), IF(ISBLANK($E$4), TRUE, ISNUMBER(SEARCH($E$4, Reading[[#This Row],[Title]]))), IF(ISBLANK($G$4), TRUE, ISNUMBER(SEARCH($G$4, _xlfn.CONCAT(Reading[[#This Row],[Main ideas]:[My thoughts]])))), IF(ISBLANK($H$4), TRUE, ISNUMBER(SEARCH($H$4, _xlfn.CONCAT(Reading[[#This Row],[Author]:[My thoughts]])))), IF(ISBLANK($C$4), TRUE,ISNUMBER(SEARCH($C$4, Reading[[#This Row],[Author]]))))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"OR(IF(ISBLANK($D$3), FALSE, ISNUMBER(SEARCH($D$3,Reading[[#This Row],[Title]]))),IF(ISBLANK($F$3), FALSE, ISNUMBER(SEARCH($F$3,Reading[[#This Row],[Keywords]]))), IF(ISBLANK($E$3), FALSE, ISNUMBER(SEARCH($E$3, Reading[[#This Row],[Journal]]))), IF(ISBLANK($G$3), FALSE, ISNUMBER(SEARCH($G$3, _xlfn.CONCAT(Reading[[#This Row],[Main ideas]:[My thoughts]])))), IF(ISBLANK($H$3), FALSE, ISNUMBER(SEARCH($H$3, _xlfn.CONCAT(Reading[[#This Row],[Author]:[My thoughts]])))), IF(ISBLANK($C$3), FALSE, ISNUMBER(SEARCH($C$3, Reading[[#This Row],[Author]]))), IF(COUNTBLANK($C$3:$H$3)=6, TRUE, FALSE))","v":true},{"$f":"AND(IF(ISBLANK($D$4), TRUE, ISNUMBER(SEARCH($D$4,Reading[[#This Row],[Title]]))), IF(ISBLANK($F$4), TRUE, ISNUMBER(SEARCH($F$4,Reading[[#This Row],[Keywords]]))), IF(ISBLANK($E$4), TRUE, ISNUMBER(SEARCH($E$4, Reading[[#This Row],[Title]]))), IF(ISBLANK($G$4), TRUE, ISNUMBER(SEARCH($G$4, _xlfn.CONCAT(Reading[[#This Row],[Main ideas]:[My thoughts]])))), IF(ISBLANK($H$4), TRUE, ISNUMBER(SEARCH($H$4, _xlfn.CONCAT(Reading[[#This Row],[Author]:[My thoughts]])))), IF(ISBLANK($C$4), TRUE,ISNUMBER(SEARCH($C$4, Reading[[#This Row],[Author]]))))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"OR(IF(ISBLANK($D$3), FALSE, ISNUMBER(SEARCH($D$3,Reading[[#This Row],[Title]]))),IF(ISBLANK($F$3), FALSE, ISNUMBER(SEARCH($F$3,Reading[[#This Row],[Keywords]]))), IF(ISBLANK($E$3), FALSE, ISNUMBER(SEARCH($E$3, Reading[[#This Row],[Journal]]))), IF(ISBLANK($G$3), FALSE, ISNUMBER(SEARCH($G$3, _xlfn.CONCAT(Reading[[#This Row],[Main ideas]:[My thoughts]])))), IF(ISBLANK($H$3), FALSE, ISNUMBER(SEARCH($H$3, _xlfn.CONCAT(Reading[[#This Row],[Author]:[My thoughts]])))), IF(ISBLANK($C$3), FALSE, ISNUMBER(SEARCH($C$3, Reading[[#This Row],[Author]]))), IF(COUNTBLANK($C$3:$H$3)=6, TRUE, FALSE))","v":true},{"$f":"AND(IF(ISBLANK($D$4), TRUE, ISNUMBER(SEARCH($D$4,Reading[[#This Row],[Title]]))), IF(ISBLANK($F$4), TRUE, ISNUMBER(SEARCH($F$4,Reading[[#This Row],[Keywords]]))), IF(ISBLANK($E$4), TRUE, ISNUMBER(SEARCH($E$4, Reading[[#This Row],[Title]]))), IF(ISBLANK($G$4), TRUE, ISNUMBER(SEARCH($G$4, _xlfn.CONCAT(Reading[[#This Row],[Main ideas]:[My thoughts]])))), IF(ISBLANK($H$4), TRUE, ISNUMBER(SEARCH($H$4, _xlfn.CONCAT(Reading[[#This Row],[Author]:[My thoughts]])))), IF(ISBLANK($C$4), TRUE,ISNUMBER(SEARCH($C$4, Reading[[#This Row],[Author]]))))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"OR(IF(ISBLANK($D$3), FALSE, ISNUMBER(SEARCH($D$3,Reading[[#This Row],[Title]]))),IF(ISBLANK($F$3), FALSE, ISNUMBER(SEARCH($F$3,Reading[[#This Row],[Keywords]]))), IF(ISBLANK($E$3), FALSE, ISNUMBER(SEARCH($E$3, Reading[[#This Row],[Journal]]))), IF(ISBLANK($G$3), FALSE, ISNUMBER(SEARCH($G$3, _xlfn.CONCAT(Reading[[#This Row],[Main ideas]:[My thoughts]])))), IF(ISBLANK($H$3), FALSE, ISNUMBER(SEARCH($H$3, _xlfn.CONCAT(Reading[[#This Row],[Author]:[My thoughts]])))), IF(ISBLANK($C$3), FALSE, ISNUMBER(SEARCH($C$3, Reading[[#This Row],[Author]]))), IF(COUNTBLANK($C$3:$H$3)=6, TRUE, FALSE))","v":true},{"$f":"AND(IF(ISBLANK($D$4), TRUE, ISNUMBER(SEARCH($D$4,Reading[[#This Row],[Title]]))), IF(ISBLANK($F$4), TRUE, ISNUMBER(SEARCH($F$4,Reading[[#This Row],[Keywords]]))), IF(ISBLANK($E$4), TRUE, ISNUMBER(SEARCH($E$4, Reading[[#This Row],[Title]]))), IF(ISBLANK($G$4), TRUE, ISNUMBER(SEARCH($G$4, _xlfn.CONCAT(Reading[[#This Row],[Main ideas]:[My thoughts]])))), IF(ISBLANK($H$4), TRUE, ISNUMBER(SEARCH($H$4, _xlfn.CONCAT(Reading[[#This Row],[Author]:[My thoughts]])))), IF(ISBLANK($C$4), TRUE,ISNUMBER(SEARCH($C$4, Reading[[#This Row],[Author]]))))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"OR(IF(ISBLANK($D$3), FALSE, ISNUMBER(SEARCH($D$3,Reading[[#This Row],[Title]]))),IF(ISBLANK($F$3), FALSE, ISNUMBER(SEARCH($F$3,Reading[[#This Row],[Keywords]]))), IF(ISBLANK($E$3), FALSE, ISNUMBER(SEARCH($E$3, Reading[[#This Row],[Journal]]))), IF(ISBLANK($G$3), FALSE, ISNUMBER(SEARCH($G$3, _xlfn.CONCAT(Reading[[#This Row],[Main ideas]:[My thoughts]])))), IF(ISBLANK($H$3), FALSE, ISNUMBER(SEARCH($H$3, _xlfn.CONCAT(Reading[[#This Row],[Author]:[My thoughts]])))), IF(ISBLANK($C$3), FALSE, ISNUMBER(SEARCH($C$3, Reading[[#This Row],[Author]]))), IF(COUNTBLANK($C$3:$H$3)=6, TRUE, FALSE))","v":true},{"$f":"AND(IF(ISBLANK($D$4), TRUE, ISNUMBER(SEARCH($D$4,Reading[[#This Row],[Title]]))), IF(ISBLANK($F$4), TRUE, ISNUMBER(SEARCH($F$4,Reading[[#This Row],[Keywords]]))), IF(ISBLANK($E$4), TRUE, ISNUMBER(SEARCH($E$4, Reading[[#This Row],[Title]]))), IF(ISBLANK($G$4), TRUE, ISNUMBER(SEARCH($G$4, _xlfn.CONCAT(Reading[[#This Row],[Main ideas]:[My thoughts]])))), IF(ISBLANK($H$4), TRUE, ISNUMBER(SEARCH($H$4, _xlfn.CONCAT(Reading[[#This Row],[Author]:[My thoughts]])))), IF(ISBLANK($C$4), TRUE,ISNUMBER(SEARCH($C$4, Reading[[#This Row],[Author]]))))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"OR(IF(ISBLANK($D$3), FALSE, ISNUMBER(SEARCH($D$3,Reading[[#This Row],[Title]]))),IF(ISBLANK($F$3), FALSE, ISNUMBER(SEARCH($F$3,Reading[[#This Row],[Keywords]]))), IF(ISBLANK($E$3), FALSE, ISNUMBER(SEARCH($E$3, Reading[[#This Row],[Journal]]))), IF(ISBLANK($G$3), FALSE, ISNUMBER(SEARCH($G$3, _xlfn.CONCAT(Reading[[#This Row],[Main ideas]:[My thoughts]])))), IF(ISBLANK($H$3), FALSE, ISNUMBER(SEARCH($H$3, _xlfn.CONCAT(Reading[[#This Row],[Author]:[My thoughts]])))), IF(ISBLANK($C$3), FALSE, ISNUMBER(SEARCH($C$3, Reading[[#This Row],[Author]]))), IF(COUNTBLANK($C$3:$H$3)=6, TRUE, FALSE))","v":true},{"$f":"AND(IF(ISBLANK($D$4), TRUE, ISNUMBER(SEARCH($D$4,Reading[[#This Row],[Title]]))), IF(ISBLANK($F$4), TRUE, ISNUMBER(SEARCH($F$4,Reading[[#This Row],[Keywords]]))), IF(ISBLANK($E$4), TRUE, ISNUMBER(SEARCH($E$4, Reading[[#This Row],[Title]]))), IF(ISBLANK($G$4), TRUE, ISNUMBER(SEARCH($G$4, _xlfn.CONCAT(Reading[[#This Row],[Main ideas]:[My thoughts]])))), IF(ISBLANK($H$4), TRUE, ISNUMBER(SEARCH($H$4, _xlfn.CONCAT(Reading[[#This Row],[Author]:[My thoughts]])))), IF(ISBLANK($C$4), TRUE,ISNUMBER(SEARCH($C$4, Reading[[#This Row],[Author]]))))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"OR(IF(ISBLANK($D$3), FALSE, ISNUMBER(SEARCH($D$3,Reading[[#This Row],[Title]]))),IF(ISBLANK($F$3), FALSE, ISNUMBER(SEARCH($F$3,Reading[[#This Row],[Keywords]]))), IF(ISBLANK($E$3), FALSE, ISNUMBER(SEARCH($E$3, Reading[[#This Row],[Journal]]))), IF(ISBLANK($G$3), FALSE, ISNUMBER(SEARCH($G$3, _xlfn.CONCAT(Reading[[#This Row],[Main ideas]:[My thoughts]])))), IF(ISBLANK($H$3), FALSE, ISNUMBER(SEARCH($H$3, _xlfn.CONCAT(Reading[[#This Row],[Author]:[My thoughts]])))), IF(ISBLANK($C$3), FALSE, ISNUMBER(SEARCH($C$3, Reading[[#This Row],[Author]]))), IF(COUNTBLANK($C$3:$H$3)=6, TRUE, FALSE))","v":true},{"$f":"AND(IF(ISBLANK($D$4), TRUE, ISNUMBER(SEARCH($D$4,Reading[[#This Row],[Title]]))), IF(ISBLANK($F$4), TRUE, ISNUMBER(SEARCH($F$4,Reading[[#This Row],[Keywords]]))), IF(ISBLANK($E$4), TRUE, ISNUMBER(SEARCH($E$4, Reading[[#This Row],[Title]]))), IF(ISBLANK($G$4), TRUE, ISNUMBER(SEARCH($G$4, _xlfn.CONCAT(Reading[[#This Row],[Main ideas]:[My thoughts]])))), IF(ISBLANK($H$4), TRUE, ISNUMBER(SEARCH($H$4, _xlfn.CONCAT(Reading[[#This Row],[Author]:[My thoughts]])))), IF(ISBLANK($C$4), TRUE,ISNUMBER(SEARCH($C$4, Reading[[#This Row],[Author]]))))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"OR(IF(ISBLANK($D$3), FALSE, ISNUMBER(SEARCH($D$3,Reading[[#This Row],[Title]]))),IF(ISBLANK($F$3), FALSE, ISNUMBER(SEARCH($F$3,Reading[[#This Row],[Keywords]]))), IF(ISBLANK($E$3), FALSE, ISNUMBER(SEARCH($E$3, Reading[[#This Row],[Journal]]))), IF(ISBLANK($G$3), FALSE, ISNUMBER(SEARCH($G$3, _xlfn.CONCAT(Reading[[#This Row],[Main ideas]:[My thoughts]])))), IF(ISBLANK($H$3), FALSE, ISNUMBER(SEARCH($H$3, _xlfn.CONCAT(Reading[[#This Row],[Author]:[My thoughts]])))), IF(ISBLANK($C$3), FALSE, ISNUMBER(SEARCH($C$3, Reading[[#This Row],[Author]]))), IF(COUNTBLANK($C$3:$H$3)=6, TRUE, FALSE))","v":true},{"$f":"AND(IF(ISBLANK($D$4), TRUE, ISNUMBER(SEARCH($D$4,Reading[[#This Row],[Title]]))), IF(ISBLANK($F$4), TRUE, ISNUMBER(SEARCH($F$4,Reading[[#This Row],[Keywords]]))), IF(ISBLANK($E$4), TRUE, ISNUMBER(SEARCH($E$4, Reading[[#This Row],[Title]]))), IF(ISBLANK($G$4), TRUE, ISNUMBER(SEARCH($G$4, _xlfn.CONCAT(Reading[[#This Row],[Main ideas]:[My thoughts]])))), IF(ISBLANK($H$4), TRUE, ISNUMBER(SEARCH($H$4, _xlfn.CONCAT(Reading[[#This Row],[Author]:[My thoughts]])))), IF(ISBLANK($C$4), TRUE,ISNUMBER(SEARCH($C$4, Reading[[#This Row],[Author]]))))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"OR(IF(ISBLANK($D$3), FALSE, ISNUMBER(SEARCH($D$3,Reading[[#This Row],[Title]]))),IF(ISBLANK($F$3), FALSE, ISNUMBER(SEARCH($F$3,Reading[[#This Row],[Keywords]]))), IF(ISBLANK($E$3), FALSE, ISNUMBER(SEARCH($E$3, Reading[[#This Row],[Journal]]))), IF(ISBLANK($G$3), FALSE, ISNUMBER(SEARCH($G$3, _xlfn.CONCAT(Reading[[#This Row],[Main ideas]:[My thoughts]])))), IF(ISBLANK($H$3), FALSE, ISNUMBER(SEARCH($H$3, _xlfn.CONCAT(Reading[[#This Row],[Author]:[My thoughts]])))), IF(ISBLANK($C$3), FALSE, ISNUMBER(SEARCH($C$3, Reading[[#This Row],[Author]]))), IF(COUNTBLANK($C$3:$H$3)=6, TRUE, FALSE))","v":true},{"$f":"AND(IF(ISBLANK($D$4), TRUE, ISNUMBER(SEARCH($D$4,Reading[[#This Row],[Title]]))), IF(ISBLANK($F$4), TRUE, ISNUMBER(SEARCH($F$4,Reading[[#This Row],[Keywords]]))), IF(ISBLANK($E$4), TRUE, ISNUMBER(SEARCH($E$4, Reading[[#This Row],[Title]]))), IF(ISBLANK($G$4), TRUE, ISNUMBER(SEARCH($G$4, _xlfn.CONCAT(Reading[[#This Row],[Main ideas]:[My thoughts]])))), IF(ISBLANK($H$4), TRUE, ISNUMBER(SEARCH($H$4, _xlfn.CONCAT(Reading[[#This Row],[Author]:[My thoughts]])))), IF(ISBLANK($C$4), TRUE,ISNUMBER(SEARCH($C$4, Reading[[#This Row],[Author]]))))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"OR(IF(ISBLANK($D$3), FALSE, ISNUMBER(SEARCH($D$3,Reading[[#This Row],[Title]]))),IF(ISBLANK($F$3), FALSE, ISNUMBER(SEARCH($F$3,Reading[[#This Row],[Keywords]]))), IF(ISBLANK($E$3), FALSE, ISNUMBER(SEARCH($E$3, Reading[[#This Row],[Journal]]))), IF(ISBLANK($G$3), FALSE, ISNUMBER(SEARCH($G$3, _xlfn.CONCAT(Reading[[#This Row],[Main ideas]:[My thoughts]])))), IF(ISBLANK($H$3), FALSE, ISNUMBER(SEARCH($H$3, _xlfn.CONCAT(Reading[[#This Row],[Author]:[My thoughts]])))), IF(ISBLANK($C$3), FALSE, ISNUMBER(SEARCH($C$3, Reading[[#This Row],[Author]]))), IF(COUNTBLANK($C$3:$H$3)=6, TRUE, FALSE))","v":true},{"$f":"AND(IF(ISBLANK($D$4), TRUE, ISNUMBER(SEARCH($D$4,Reading[[#This Row],[Title]]))), IF(ISBLANK($F$4), TRUE, ISNUMBER(SEARCH($F$4,Reading[[#This Row],[Keywords]]))), IF(ISBLANK($E$4), TRUE, ISNUMBER(SEARCH($E$4, Reading[[#This Row],[Title]]))), IF(ISBLANK($G$4), TRUE, ISNUMBER(SEARCH($G$4, _xlfn.CONCAT(Reading[[#This Row],[Main ideas]:[My thoughts]])))), IF(ISBLANK($H$4), TRUE, ISNUMBER(SEARCH($H$4, _xlfn.CONCAT(Reading[[#This Row],[Author]:[My thoughts]])))), IF(ISBLANK($C$4), TRUE,ISNUMBER(SEARCH($C$4, Reading[[#This Row],[Author]]))))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"OR(IF(ISBLANK($D$3), FALSE, ISNUMBER(SEARCH($D$3,Reading[[#This Row],[Title]]))),IF(ISBLANK($F$3), FALSE, ISNUMBER(SEARCH($F$3,Reading[[#This Row],[Keywords]]))), IF(ISBLANK($E$3), FALSE, ISNUMBER(SEARCH($E$3, Reading[[#This Row],[Journal]]))), IF(ISBLANK($G$3), FALSE, ISNUMBER(SEARCH($G$3, _xlfn.CONCAT(Reading[[#This Row],[Main ideas]:[My thoughts]])))), IF(ISBLANK($H$3), FALSE, ISNUMBER(SEARCH($H$3, _xlfn.CONCAT(Reading[[#This Row],[Author]:[My thoughts]])))), IF(ISBLANK($C$3), FALSE, ISNUMBER(SEARCH($C$3, Reading[[#This Row],[Author]]))), IF(COUNTBLANK($C$3:$H$3)=6, TRUE, FALSE))","v":true},{"$f":"AND(IF(ISBLANK($D$4), TRUE, ISNUMBER(SEARCH($D$4,Reading[[#This Row],[Title]]))), IF(ISBLANK($F$4), TRUE, ISNUMBER(SEARCH($F$4,Reading[[#This Row],[Keywords]]))), IF(ISBLANK($E$4), TRUE, ISNUMBER(SEARCH($E$4, Reading[[#This Row],[Title]]))), IF(ISBLANK($G$4), TRUE, ISNUMBER(SEARCH($G$4, _xlfn.CONCAT(Reading[[#This Row],[Main ideas]:[My thoughts]])))), IF(ISBLANK($H$4), TRUE, ISNUMBER(SEARCH($H$4, _xlfn.CONCAT(Reading[[#This Row],[Author]:[My thoughts]])))), IF(ISBLANK($C$4), TRUE,ISNUMBER(SEARCH($C$4, Reading[[#This Row],[Author]]))))","v":true}]