{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Example conversion","Testing"],"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":"Example conversion","index":0,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,"From Time MM:SS.HH","Event","Conversion","Converted time"]
["Time in MM:SS.HH","2:03.40","200BA","SC->LC",{"$f":"dec2MMSSHH(E5)","v":"2:06.10"}]
[]
["Time in seconds",{"$f":"MMSSHH2dec(B3)","v":123.4},null,"Conversion",{"$f":"IF($D$3=\"SC->LC\",decSCM2LCM(B5,C3),decLCM2SCM(B5,C3))","v":126.1}]
[]
["Legal values for Event and Conversion:",null,"50FR","SC->LC"]
[null,null,"100FR","LC->SC"]
[null,null,"200FR"]
[null,null,"400FR"]
[null,null,"800FR"]
[null,null,"1500FR"]
[null,null,"50BR"]
[null,null,"100BR"]
[null,null,"200BR"]
[null,null,"50FL"]
[null,null,"100FL"]
[null,null,"200FL"]
[null,null,"50BA"]
[null,null,"100BA"]
[null,null,"200BA"]
[null,null,"200IM"]
[null,null,"400IM"]

{"sheet":"Testing","index":1,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["Times checked against the Sport Systems Equivalent Time Converter"]
[]
[null,"Time","Event","Conversion","Calculated ","Matches?","From SportSys Converter"]
[null,"30.50","50FR","LC->SC",{"$f":"dec2MMSSHH(decLCM2SCM(MMSSHH2dec( B4),C4))","v":"29.80"},{"$f":"IF(E4=G4,\"OK\",\"FAIL\")","v":"OK"},"29.80"]
[null,"30.50","50BA","LC->SC",{"$f":"dec2MMSSHH(decLCM2SCM(MMSSHH2dec( B5),C5))","v":"29.80"},{"$f":"IF(E5=G5,\"OK\",\"FAIL\")","v":"OK"},"29.80"]
[null,"30.50","50BR","LC->SC",{"$f":"dec2MMSSHH(decLCM2SCM(MMSSHH2dec( B6),C6))","v":"29.50"},"OK","29.50"]
[null,"30.50","50FL","LC->SC",{"$f":"dec2MMSSHH(decLCM2SCM(MMSSHH2dec( B7),C7))","v":"29.90"},"OK","29.90"]
[]
[null,"30.50","50FR","SC->LC",{"$f":"dec2MMSSHH(decSCM2LCM(MMSSHH2dec( B9),C9))","v":"31.20"},{"$f":"IF(E9=G9,\"OK\",\"FAIL\")","v":"OK"},"31.20"]
[null,"30.50","50BA","SC->LC",{"$f":"dec2MMSSHH(decSCM2LCM(MMSSHH2dec( B10),C10))","v":"31.20"},{"$f":"IF(E10=G10,\"OK\",\"FAIL\")","v":"OK"},"31.20"]
[null,"30.50","50BR","SC->LC",{"$f":"dec2MMSSHH(decSCM2LCM(MMSSHH2dec( B11),C11))","v":"31.50"},"OK","31.50"]
[null,"30.50","50FL","SC->LC",{"$f":"dec2MMSSHH(decSCM2LCM(MMSSHH2dec( B12),C12))","v":"31.10"},"OK","31.10"]
[]
[null,"1:02.30","100FR","LC->SC",{"$f":"dec2MMSSHH(decLCM2SCM(MMSSHH2dec( B14),C14))","v":"1:00.90"},{"$f":"IF(E14=G14,\"OK\",\"FAIL\")","v":"OK"},"1:00.90"]
[null,"1:02.30","100BA","LC->SC",{"$f":"dec2MMSSHH(decLCM2SCM(MMSSHH2dec( B15),C15))","v":"1:01.00"},{"$f":"IF(E15=G15,\"OK\",\"FAIL\")","v":"OK"},"1:01.00"]
[null,"1:02.30","100BR","LC->SC",{"$f":"dec2MMSSHH(decLCM2SCM(MMSSHH2dec( B16),C16))","v":"1:00.30"},"OK","1:00.30"]
[null,"1:02.30","100FL","LC->SC",{"$f":"dec2MMSSHH(decLCM2SCM(MMSSHH2dec( B17),C17))","v":"1:01.10"},"OK","1:01.10"]
[]
[null,"1:02.30","100FR","SC->LC",{"$f":"dec2MMSSHH(decSCM2LCM(MMSSHH2dec( B19),C19))","v":"1:03.60"},{"$f":"IF(E19=G19,\"OK\",\"FAIL\")","v":"OK"},"1:03.60"]
[null,"1:02.30","100BA","SC->LC",{"$f":"dec2MMSSHH(decSCM2LCM(MMSSHH2dec( B20),C20))","v":"1:03.60"},{"$f":"IF(E20=G20,\"OK\",\"FAIL\")","v":"OK"},"1:03.60"]
[null,"1:02.30","100BR","SC->LC",{"$f":"dec2MMSSHH(decSCM2LCM(MMSSHH2dec( B21),C21))","v":"1:04.30"},"OK","1:04.30"]
[null,"1:02.30","100FL","SC->LC",{"$f":"dec2MMSSHH(decSCM2LCM(MMSSHH2dec( B22),C22))","v":"1:03.50"},"OK","1:03.50"]
[]
[null,"2:03.40","200FR","LC->SC",{"$f":"dec2MMSSHH(decLCM2SCM(MMSSHH2dec( B24),C24))","v":"2:00.60"},{"$f":"IF(E24=G24,\"OK\",\"FAIL\")","v":"OK"},"2:00.60"]
[null,"2:03.40","200BA","LC->SC",{"$f":"dec2MMSSHH(decLCM2SCM(MMSSHH2dec( B25),C25))","v":"2:00.70"},{"$f":"IF(E25=G25,\"OK\",\"FAIL\")","v":"OK"},"2:00.70"]
[null,"2:03.40","200BR","LC->SC",{"$f":"dec2MMSSHH(decLCM2SCM(MMSSHH2dec( B26),C26))","v":"1:59.10"},"OK","1:59.10"]
[null,"2:03.40","200FL","LC->SC",{"$f":"dec2MMSSHH(decLCM2SCM(MMSSHH2dec( B27),C27))","v":"2:00.80"},"OK","2:00.80"]
[null,"2:03.40","200IM","LC->SC",{"$f":"dec2MMSSHH(decLCM2SCM(MMSSHH2dec( B28),C28))","v":"2:00.20"},"OK","2:00.20"]
[]
[null,"2:03.40","200FR","SC->LC",{"$f":"dec2MMSSHH(decSCM2LCM(MMSSHH2dec( B30),C30))","v":"2:06.20"},{"$f":"IF(E30=G30,\"OK\",\"FAIL\")","v":"OK"},"2:06.20"]
[null,"2:03.40","200BA","SC->LC",{"$f":"dec2MMSSHH(decSCM2LCM(MMSSHH2dec( B31),C31))","v":"2:06.10"},{"$f":"IF(E31=G31,\"OK\",\"FAIL\")","v":"OK"},"2:06.10"]
[null,"2:03.40","200BR","SC->LC",{"$f":"dec2MMSSHH(decSCM2LCM(MMSSHH2dec( B32),C32))","v":"2:07.60"},"OK","2:07.60"]
[null,"2:03.40","200FL","SC->LC",{"$f":"dec2MMSSHH(decSCM2LCM(MMSSHH2dec( B33),C33))","v":"2:05.90"},"OK","2:05.90"]
[null,"2:03.40","200IM","SC->LC",{"$f":"dec2MMSSHH(decSCM2LCM(MMSSHH2dec( B34),C34))","v":"2:06.50"},"OK","2:06.50"]
[]
[null,"4:05.66","400FR","LC->SC",{"$f":"dec2MMSSHH(decLCM2SCM(MMSSHH2dec( B36),C36))","v":"3:59.90"},{"$f":"IF(E36=G36,\"OK\",\"FAIL\")","v":"OK"},"3:59.90"]
[null,"4:05.66","400IM","LC->SC",{"$f":"dec2MMSSHH(decLCM2SCM(MMSSHH2dec( B37),C37))","v":"3:58.40"},{"$f":"IF(E37=G37,\"OK\",\"FAIL\")","v":"OK"},"3:58.40"]
[]
[null,"4:05.66","400FR","SC->LC",{"$f":"dec2MMSSHH(decSCM2LCM(MMSSHH2dec( B39),C39))","v":"4:11.30"},{"$f":"IF(E39=G39,\"OK\",\"FAIL\")","v":"OK"},"4:11.30"]
[null,"4:05.66","400IM","SC->LC",{"$f":"dec2MMSSHH(decSCM2LCM(MMSSHH2dec( B40),C40))","v":"4:12.70"},{"$f":"IF(E40=G40,\"OK\",\"FAIL\")","v":"OK"},"4:12.70"]
[]
[null,"10:22.33","800FR","LC->SC",{"$f":"dec2MMSSHH(decLCM2SCM(MMSSHH2dec( B42),C42))","v":"10:13.00"},{"$f":"IF(E42=G42,\"OK\",\"FAIL\")","v":"OK"},"10:13.00"]
[null,"15:44.66","1500FR","LC->SC",{"$f":"dec2MMSSHH(decLCM2SCM(MMSSHH2dec( B43),C43))","v":"15:22.60"},{"$f":"IF(E43=G43,\"OK\",\"FAIL\")","v":"OK"},"15:22.60"]
[]
[null,"10:22.33","800FR","SC->LC",{"$f":"dec2MMSSHH(decSCM2LCM(MMSSHH2dec( B45),C45))","v":"10:31.60"},{"$f":"IF(E45=G45,\"OK\",\"FAIL\")","v":"OK"},"10:31.60"]
[null,"15:44.66","1500FR","SC->LC",{"$f":"dec2MMSSHH(decSCM2LCM(MMSSHH2dec( B46),C46))","v":"16:06.20"},{"$f":"IF(E46=G46,\"OK\",\"FAIL\")","v":"OK"},"16:06.20"]