{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"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":19,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Hi Surround   been struggling again  yeah l know learning excel would have help heaps but got a few grey hairs left and under them not that much good...."]
[null,null,null,"left...and what you have done for me will be all l need from excel..(hope)...l can live with what l have in those between the  blue ... rest l can use my one finger...."]
[null,null,null,"but afther a few hour trying  different numbers  doing this and that l''show you what l 've done and your formulas might help any one else....Thanks Again  "]
[]
[]
[]
[null,"Distance 12-10-2-5",{"$f":"RIGHT(B8, LEN(B8)-8)","v":" 12-10-2-5"},null,null,"Got this one  going for B8..No trouble",{"$nulls":5},{"$f":"--TRIM(REPLACE(C8,FIND(\"-\",C8),255,\"\"))","v":12},{"$f":"--TRIM(REPLACE(Q8,FIND(\"-\",Q8),255,\"\"))","v":10},{"$f":"--TRIM(REPLACE(R8,FIND(\"-\",R8),255,\"\"))","v":2},{"$f":"RIGHT(R8,LEN(R8)-FIND(\"-\",R8))","v":"5"},null,{"$f":"RIGHT(C8,LEN(C8)-FIND(\"-\",C8))","v":"10-2-5"},{"$f":"RIGHT(Q8,LEN(Q8)-FIND(\"-\",Q8))","v":"2-5"},"5"]
[]
[]
[null,"Distance: 12:10-2-5",{"$f":"RIGHT(B11, LEN(B11)-9)","v":" 12:10-2-5"},{"$nulls":4},"But with this c9 :",null,null,null,{"$f":"--TRIM(REPLACE(C11,FIND(\"-\",C11),255,\"\"))","v":0.50694444444444442},{"$f":"--TRIM(REPLACE(Q11,FIND(\"-\",Q11),255,\"\"))","v":2},{"$f":"--TRIM(REPLACE(R11,FIND(\"-\",R11),255,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"RIGHT(R11,LEN(R11)-FIND(\"-\",R11))","v":{"$error":"#VALUE!"}},null,{"$f":"RIGHT(C11,LEN(C11)-FIND(\"-\",C11))","v":"2-5"},"5",{"$error":"#VALUE!"}]
[]
[null,"just need him out please"]
[null,"(distance)"]
[]
[]
[null,"track 9-1-3-2",{"$f":"RIGHT(B17, LEN(B17)-6)","v":"9-1-3-2"},null,null,"Got this one  going for B15..No trouble",{"$nulls":5},{"$f":"--TRIM(REPLACE(C17,FIND(\"-\",C17),255,\"\"))","v":9},{"$f":"--TRIM(REPLACE(Q17,FIND(\"-\",Q17),255,\"\"))","v":1},3,{"$f":"RIGHT(R17,LEN(R17)-FIND(\"-\",R17))","v":"2"},null,{"$f":"RIGHT(C17,LEN(C17)-FIND(\"-\",C17))","v":"1-3-2"},{"$f":"RIGHT(Q17,LEN(Q17)-FIND(\"-\",Q17))","v":"3-2"},"2"]
[]
[]
[{"$nulls":5},"Got this one  going for B20..No trouble"]
[]
[]
[{"$nulls":9},"XX","copy d20 for L20  because l was getting 0.67014"]
[null,"16:5-2-1",{"$f":"RIGHT(B24, LEN(B24)-7)","v":"1"},{"$f":"LEFT(B24, LEN(B24)-6)","v":"16"},{"$f":"RIGHT(B24, LEN(B24)-3)","v":"5-2-1"},{"$f":"LEFT(E24, LEN(E24)-4)","v":"5"},{"$f":"RIGHT(B24, LEN(B24)-5)","v":"2-1"},{"$f":"LEFT(G24, LEN(G24)-2)","v":"2"},null,null,null,{"$f":"D24","v":"16"},{"$f":"LEFT(E24, LEN(E24)-4)","v":"5"},{"$f":"LEFT(G24, LEN(G24)-2)","v":"2"},{"$f":"RIGHT(B24, LEN(B24)-7)","v":"1"},null,{"$f":"RIGHT(C24,LEN(C24)-FIND(\"-\",C24))","v":{"$error":"#VALUE!"}},{"$f":"RIGHT(Q24,LEN(Q24)-FIND(\"-\",Q24))","v":{"$error":"#VALUE!"}},{"$f":"RIGHT(R24,LEN(R24)-FIND(\"-\",R24))","v":{"$error":"#VALUE!"}}]
[null,"But add a 10 or take 10 off goes mad"]
[]
[]
[{"$nulls":5},"Got this one  going for B20..No trouble"]
[null,"16:19-12-2",null,null,{"$f":"RIGHT(B29, LEN(B29)-3)","v":"19-12-2"},null,{"$f":"RIGHT(B29, LEN(B29)-5)","v":"-12-2"}]
[null,"but have this  6:2:3:1"]
[null,null,{"$f":"LEFT(B29, LEN(B29)-8)","v":"16"},{"$f":"LEFT(E29, LEN(E29)-5)","v":"19"},{"$f":"LEFT(G29, LEN(G29)-2)","v":"-12"},{"$f":"RIGHT(B29, LEN(B29)-9)","v":"2"},{"$nulls":5},{"$f":"C31","v":"16"},{"$f":"LEFT(E29, LEN(E29)-5)","v":"19"},{"$f":"RIGHT(E31, LEN(E31)-1)","v":"12"},{"$f":"F31","v":"2"},null,{"$f":"RIGHT(C31,LEN(C31)-FIND(\"-\",C31))","v":{"$error":"#VALUE!"}},{"$f":"RIGHT(Q31,LEN(Q31)-FIND(\"-\",Q31))","v":{"$error":"#VALUE!"}},{"$f":"RIGHT(R31,LEN(R31)-FIND(\"-\",R31))","v":{"$error":"#VALUE!"}}]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}