{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Sheet1","index":0,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Type","Country","(Class)","Class","Number","CheckDigit","EVN"]
[91,85,"4",460,"001",{"$f":"XDIGIT(A2&B2&C2&D2&E2)","v":"1"},{"$f":"EVN(A2&B2&C2&D2&E2)","v":"91 85 4460 001-1"}]
[91,85,"4",460,"002",{"$f":"XDIGIT(A3&B3&C3&D3&E3)","v":"9"},{"$f":"EVN(A3&B3&C3&D3&E3)","v":"91 85 4460 002-9"}]
[91,85,"4",460,"003",{"$f":"XDIGIT(A4&B4&C4&D4&E4)","v":"7"},{"$f":"EVN(A4&B4&C4&D4&E4)","v":"91 85 4460 003-7"}]
[91,85,"4",460,"009",{"$f":"XDIGIT(A5&B5&C5&D5&E5)","v":"4"},{"$f":"EVN(A5&B5&C5&D5&E5)","v":"91 85 4460 009-4"}]
[91,85,"4",460,"005",{"$f":"XDIGIT(A6&B6&C6&D6&E6)","v":"2"},{"$f":"EVN(A6&B6&C6&D6&E6)","v":"91 85 4460 005-2"}]
[91,80,null,6182,"001",{"$f":"XDIGIT(A7&B7&C7&D7&E7)","v":"8"},{"$f":"EVN(A7&B7&C7&D7&E7)","v":"91 80 6182 001-8"}]
[]
[null,null,null,null,"91 85 4460 030",{"$f":"XDIGIT(E9)","v":"0"},{"$f":"EVN(E9)","v":"91 85 4460 030-0"}]
[]
[null,"Spotlog EVN calculation spreadsheet"]
[null,"two functions are defined =EVN(number) which returns the whole EVN"]
[null,"and =XDIGIT(number) which calculates the check digit"]
[null,"Both functions expect an 11 digit long text string as input"]
[]
[null,"NOTE you need to enable macros for the functions to work"]
[]
[null,"https://spotlog.org"]