{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Macro","Formulas","Replace_Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Macro","index":0,"n_rows":97,"n_cols":23,"rows_kept":97,"cut":false,"hidden":false,"merged":[[10,21,10,29],[0,10,0,11],[0,12,0,18]]}
["https://firstmls.com/",null,null,null,null,null,null,null,null,null,"Source Folder:",null,null,null,null,null,null,null,null,null,null,"Test Mode","< just change to true if you want to review the formulas in Sheet1 and don't close the workbooks. Only for testing"]
["Just hit the Run Macro button.",null,null,null,null,null,null,null,null,null,null,null,"Your BPO Plus Files folder",null,null,null,null,null,null,null,null,false,"Default: FALSE"]
["Please do not add, delete, or change anything",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"expert2"]
["Hit the \"Enable Content\" button before hitting the \"Run Macro\" button"]
["You can only run this file 1 time.  If you rerun the file over the same file you will get erroneous data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please avoid having errors in tab like \"N/A\" or \"#DIV/0!\" errors."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please include IFERROR formula if that happens. This is because the macro might"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"place errors in the final result without the formulas as internally Excel gets confused"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"when a formula returns an error."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Example"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EI2/AS2","v":{"$error":"#DIV/0!"}},"< This formula returns an error, so we need to add IFERROR to avoid problems."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(EI2/AS2,\"\")","v":""},"< This is the corrected version of the formula."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"{"]

{"sheet":"Formulas","index":1,"n_rows":3,"n_cols":58,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Address",null,null,null,null,null,null,null,null,null,null,"Attached/Detached",null,null,null,"Blank",null,null,null,null,"Water",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,"Blank","Blank","Blank","Blank","Blank","Blank","Blank","Fake so macro won't cause a bug with find and replace"]
[null,null,null,{"$f":"+IFERROR(_xlfn.CONCAT(Replace_Data!D2,\" \",Replace_Data!BH2,\" \",Replace_Data!BI2),\" \")","v":"  "},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"*attached*\",Replace_Data!O2)),\"Attached\",IF(ISNUMBER(SEARCH(\"*detached*\",Replace_Data!O2)),\"Detached\",\"None\"))","v":"None"},null,null,null,{"$f":"+\" \"","v":" "},null,null,null,null,{"$f":"+IF(Replace_Data!X2=\"none\",\" \",\"Yes\")","v":"Yes"},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":"+\" \"","v":" "}," "," "," "," "," "," ",{"$f":"+IF(Replace_Data!EF2=\"Hello\",\"Good Bye\",\" \")","v":" "}]
[1,{"$f":"1+A3","v":2},{"$f":"1+B3","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57]

{"sheet":"Replace_Data","index":2,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Please consider this tab as if it was a copy of the sorted data, you can point the formulas here from the Formulas tab to add a second layer automation. This allows to do replacements."]