{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Sheet1","index":0,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[null,"Before using this URL creator read this support article about tracking links. To make edits click File > Make a copy"]
[]
[{"$nulls":7},"?utm_source=","&utm_medium="]
[null,"Input: Job shortlink (including https://...)",{"$nulls":4},"Shortcode","Input: Source (use underscores instead of spaces)","Input: Medium","Output: Tracking URL"]
[{"$nulls":7},"THIS IS TRACKED IN WORKABLE REPORTS","THIS IS NOT TRACKED IN WORKABLE REPORTS"]
["Example -->","https://apply.workable.com/j/27254F1D50",{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"SPLIT(B6,\"\"/\"\",TRUE,TRUE)\"),\"https:\")","v":"https:"},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"\"\"COMPUTED_VALUE\"\"\"),\"apply.workable.com\")","v":"apply.workable.com"},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"\"\"COMPUTED_VALUE\"\"\"),\"j\")","v":"j"},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"\"\"COMPUTED_VALUE\"\"\"),\"27254F1D50\")","v":"27254F1D50"},null,"Q1_Newsletter","Email",{"$f":"IF(B6=\"\",\"\",CONCATENATE(B6,$H$3,H6,$I$3,I6,$J$3))","v":"https://apply.workable.com/j/27254F1D50?utm_source=Q1_Newsletter&utm_medium=Email"}]
["Example -->","https://apply.workable.com/j/27254F1D50",{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IF(B7=\"\"\"\",\"\"\"\", SPLIT(B7,\"\"/\"\",TRUE,TRUE))\"),\"https:\")","v":"https:"},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"\"\"COMPUTED_VALUE\"\"\"),\"apply.workable.com\")","v":"apply.workable.com"},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"\"\"COMPUTED_VALUE\"\"\"),\"j\")","v":"j"},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"\"\"COMPUTED_VALUE\"\"\"),\"27254F1D50\")","v":"27254F1D50"},null,"Acme_Job_Board","Job Board","https://apply.workable.com/j/27254F1D50?utm_source=Acme_Job_Board&utm_medium=Job Board"]
["Example -->","https://apply.workable.com/j/27254F1D50",{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IF(B8=\"\"\"\",\"\"\"\", SPLIT(B8,\"\"/\"\",TRUE,TRUE))\"),\"https:\")","v":"https:"},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"\"\"COMPUTED_VALUE\"\"\"),\"apply.workable.com\")","v":"apply.workable.com"},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"\"\"COMPUTED_VALUE\"\"\"),\"j\")","v":"j"},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"\"\"COMPUTED_VALUE\"\"\"),\"27254F1D50\")","v":"27254F1D50"},null,"London_Careers_Fair","Careers fair","https://apply.workable.com/j/27254F1D50?utm_source=London_Careers_Fair&utm_medium=Careers fair"]
[]
[null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IF(B10=\"\"\"\",\"\"\"\", SPLIT(B10,\"\"/\"\",TRUE,TRUE))\"),\"\")","v":""},{"$nulls":6},{"$f":"IF(B10=\"\",\"\",CONCATENATE(B10,$H$3,H10,$I$3,I10,$J$3))","v":""}]
[null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IF(B11=\"\"\"\",\"\"\"\", SPLIT(B11,\"\"/\"\",TRUE,TRUE))\"),\"\")","v":""},{"$nulls":6},""]
[null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IF(B12=\"\"\"\",\"\"\"\", SPLIT(B12,\"\"/\"\",TRUE,TRUE))\"),\"\")","v":""},{"$nulls":6},""]
[null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IF(B13=\"\"\"\",\"\"\"\", SPLIT(B13,\"\"/\"\",TRUE,TRUE))\"),\"\")","v":""},{"$nulls":6},""]
[null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IF(B14=\"\"\"\",\"\"\"\", SPLIT(B14,\"\"/\"\",TRUE,TRUE))\"),\"\")","v":""},{"$nulls":6},""]
[null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IF(B15=\"\"\"\",\"\"\"\", SPLIT(B15,\"\"/\"\",TRUE,TRUE))\"),\"\")","v":""},{"$nulls":6},""]
[null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IF(B16=\"\"\"\",\"\"\"\", SPLIT(B16,\"\"/\"\",TRUE,TRUE))\"),\"\")","v":""},{"$nulls":6},""]
[null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IF(B17=\"\"\"\",\"\"\"\", SPLIT(B17,\"\"/\"\",TRUE,TRUE))\"),\"\")","v":""},{"$nulls":6},""]
[null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IF(B18=\"\"\"\",\"\"\"\", SPLIT(B18,\"\"/\"\",TRUE,TRUE))\"),\"\")","v":""},{"$nulls":6},""]
[null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IF(B19=\"\"\"\",\"\"\"\", SPLIT(B19,\"\"/\"\",TRUE,TRUE))\"),\"\")","v":""},{"$nulls":6},""]
[null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IF(B20=\"\"\"\",\"\"\"\", SPLIT(B20,\"\"/\"\",TRUE,TRUE))\"),\"\")","v":""},{"$nulls":6},""]
[null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IF(B21=\"\"\"\",\"\"\"\", SPLIT(B21,\"\"/\"\",TRUE,TRUE))\"),\"\")","v":""},{"$nulls":6},""]
[null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IF(B22=\"\"\"\",\"\"\"\", SPLIT(B22,\"\"/\"\",TRUE,TRUE))\"),\"\")","v":""},{"$nulls":6},""]
[null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IF(B23=\"\"\"\",\"\"\"\", SPLIT(B23,\"\"/\"\",TRUE,TRUE))\"),\"\")","v":""},{"$nulls":6},""]
[null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IF(B24=\"\"\"\",\"\"\"\", SPLIT(B24,\"\"/\"\",TRUE,TRUE))\"),\"\")","v":""},{"$nulls":6},""]
[null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IF(B25=\"\"\"\",\"\"\"\", SPLIT(B25,\"\"/\"\",TRUE,TRUE))\"),\"\")","v":""},{"$nulls":6},""]
[null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IF(B26=\"\"\"\",\"\"\"\", SPLIT(B26,\"\"/\"\",TRUE,TRUE))\"),\"\")","v":""},{"$nulls":6},""]
[null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IF(B27=\"\"\"\",\"\"\"\", SPLIT(B27,\"\"/\"\",TRUE,TRUE))\"),\"\")","v":""},{"$nulls":6},""]
[null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IF(B28=\"\"\"\",\"\"\"\", SPLIT(B28,\"\"/\"\",TRUE,TRUE))\"),\"\")","v":""},{"$nulls":6},""]
[null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IF(B29=\"\"\"\",\"\"\"\", SPLIT(B29,\"\"/\"\",TRUE,TRUE))\"),\"\")","v":""},{"$nulls":6},""]
[null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IF(B30=\"\"\"\",\"\"\"\", SPLIT(B30,\"\"/\"\",TRUE,TRUE))\"),\"\")","v":""},{"$nulls":6},""]
[null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IF(B31=\"\"\"\",\"\"\"\", SPLIT(B31,\"\"/\"\",TRUE,TRUE))\"),\"\")","v":""},{"$nulls":6},""]