{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["README","Constants","Application","ApplicationTag","ApplicationTagGroup","Integration","IntegrationTag","FieldDefinition","SOURCE Application","SOURCE Integration"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"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":"README","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Aplas Import Template"]
[null,"This is an optional Excel template that provides some support for converting your source application and integration data into a format for CSV/ZIP import to Aplas."]
[]
[null,"Yellow sheets are in Aplas format ready for CSV export."]
[null,"Blue sheets are for your source data (examples provided). This data is referenced in the yellow target sheets."]
[]
[null,"Helper functions"]
[null,"STRINGTOID(string)",null,"Converts a string to Aplas ID format."]
[null,"TOID(cell)",null,"Converts a referenced cell to Aplas ID format."]

{"sheet":"Constants","index":1,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Small name size",20]
["Version default","1.0"]
["Status default","Standard"]
["Vendor default","Unknown"]
["Payload default","Data"]

{"sheet":"Application","index":2,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Id","Name","ShortName","Version","Vendor","TagIds","MapSize","Status","Description"]
[{"$f":"TOID(B2)","v":"sap_finance"},{"$f":"IF('SOURCE Application'!A2<>\"\",'SOURCE Application'!A2,\"\")","v":"SAP Finance"},{"$f":"LEFT(B2, VLOOKUP(\"Small name size\", Constants, 2))","v":"SAP Finance"},{"$f":"IF('SOURCE Application'!D2<>\"\",'SOURCE Application'!D2,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"IF('SOURCE Application'!B2<>\"\",'SOURCE Application'!B2,VLOOKUP(\"Vendor default\", Constants, 2))","v":"SAP"},{"$f":"STRINGTOID(IF('SOURCE Application'!E2<>\"\",'SOURCE Application'!E2,ApplicationTag!A$2))","v":"core_accounting_platform"},"Regular",{"$f":"VLOOKUP(\"Status default\", Constants, 2)","v":"Standard"},{"$f":"IF('SOURCE Application'!E2<>\"\",'SOURCE Application'!E2,\"\")","v":"Core accounting platform"}]
[{"$f":"TOID(B3)","v":"salesforce"},{"$f":"IF('SOURCE Application'!A3<>\"\",'SOURCE Application'!A3,\"\")","v":"Salesforce"},{"$f":"LEFT(B3, VLOOKUP(\"Small name size\", Constants, 2))","v":"Salesforce"},{"$f":"IF('SOURCE Application'!D3<>\"\",'SOURCE Application'!D3,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"IF('SOURCE Application'!B3<>\"\",'SOURCE Application'!B3,VLOOKUP(\"Vendor default\", Constants, 2))","v":"Salesforce"},{"$f":"STRINGTOID(IF('SOURCE Application'!E3<>\"\",'SOURCE Application'!E3,ApplicationTag!A$2))","v":"core_crm_paltform"},"Regular",{"$f":"VLOOKUP(\"Status default\", Constants, 2)","v":"Standard"},{"$f":"IF('SOURCE Application'!E3<>\"\",'SOURCE Application'!E3,\"\")","v":"Core CRM paltform"}]
[{"$f":"TOID(B4)","v":""},{"$f":"IF('SOURCE Application'!A4<>\"\",'SOURCE Application'!A4,\"\")","v":""},{"$f":"LEFT(B4, VLOOKUP(\"Small name size\", Constants, 2))","v":""},{"$f":"IF('SOURCE Application'!D4<>\"\",'SOURCE Application'!D4,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"IF('SOURCE Application'!B4<>\"\",'SOURCE Application'!B4,VLOOKUP(\"Vendor default\", Constants, 2))","v":"Unknown"},{"$f":"STRINGTOID(IF('SOURCE Application'!E4<>\"\",'SOURCE Application'!E4,ApplicationTag!A$2))","v":"unknown"},"Regular",{"$f":"VLOOKUP(\"Status default\", Constants, 2)","v":"Standard"},{"$f":"IF('SOURCE Application'!E4<>\"\",'SOURCE Application'!E4,\"\")","v":""}]
[{"$f":"TOID(B5)","v":""},{"$f":"IF('SOURCE Application'!A5<>\"\",'SOURCE Application'!A5,\"\")","v":""},{"$f":"LEFT(B5, VLOOKUP(\"Small name size\", Constants, 2))","v":""},{"$f":"IF('SOURCE Application'!D5<>\"\",'SOURCE Application'!D5,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"IF('SOURCE Application'!B5<>\"\",'SOURCE Application'!B5,VLOOKUP(\"Vendor default\", Constants, 2))","v":"Unknown"},{"$f":"STRINGTOID(IF('SOURCE Application'!E5<>\"\",'SOURCE Application'!E5,ApplicationTag!A$2))","v":"unknown"},"Regular",{"$f":"VLOOKUP(\"Status default\", Constants, 2)","v":"Standard"},{"$f":"IF('SOURCE Application'!E5<>\"\",'SOURCE Application'!E5,\"\")","v":""}]
[{"$f":"TOID(B6)","v":""},{"$f":"IF('SOURCE Application'!A6<>\"\",'SOURCE Application'!A6,\"\")","v":""},{"$f":"LEFT(B6, VLOOKUP(\"Small name size\", Constants, 2))","v":""},{"$f":"IF('SOURCE Application'!D6<>\"\",'SOURCE Application'!D6,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"IF('SOURCE Application'!B6<>\"\",'SOURCE Application'!B6,VLOOKUP(\"Vendor default\", Constants, 2))","v":"Unknown"},{"$f":"STRINGTOID(IF('SOURCE Application'!E6<>\"\",'SOURCE Application'!E6,ApplicationTag!A$2))","v":"unknown"},"Regular",{"$f":"VLOOKUP(\"Status default\", Constants, 2)","v":"Standard"},{"$f":"IF('SOURCE Application'!E6<>\"\",'SOURCE Application'!E6,\"\")","v":""}]
[{"$f":"TOID(B7)","v":""},{"$f":"IF('SOURCE Application'!A7<>\"\",'SOURCE Application'!A7,\"\")","v":""},{"$f":"LEFT(B7, VLOOKUP(\"Small name size\", Constants, 2))","v":""},{"$f":"IF('SOURCE Application'!D7<>\"\",'SOURCE Application'!D7,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"IF('SOURCE Application'!B7<>\"\",'SOURCE Application'!B7,VLOOKUP(\"Vendor default\", Constants, 2))","v":"Unknown"},{"$f":"STRINGTOID(IF('SOURCE Application'!E7<>\"\",'SOURCE Application'!E7,ApplicationTag!A$2))","v":"unknown"},"Regular",{"$f":"VLOOKUP(\"Status default\", Constants, 2)","v":"Standard"},{"$f":"IF('SOURCE Application'!E7<>\"\",'SOURCE Application'!E7,\"\")","v":""}]
[{"$f":"TOID(B8)","v":""},{"$f":"IF('SOURCE Application'!A8<>\"\",'SOURCE Application'!A8,\"\")","v":""},{"$f":"LEFT(B8, VLOOKUP(\"Small name size\", Constants, 2))","v":""},{"$f":"IF('SOURCE Application'!D8<>\"\",'SOURCE Application'!D8,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"IF('SOURCE Application'!B8<>\"\",'SOURCE Application'!B8,VLOOKUP(\"Vendor default\", Constants, 2))","v":"Unknown"},{"$f":"STRINGTOID(IF('SOURCE Application'!E8<>\"\",'SOURCE Application'!E8,ApplicationTag!A$2))","v":"unknown"},"Regular",{"$f":"VLOOKUP(\"Status default\", Constants, 2)","v":"Standard"},{"$f":"IF('SOURCE Application'!E8<>\"\",'SOURCE Application'!E8,\"\")","v":""}]
[{"$f":"TOID(B9)","v":""},{"$f":"IF('SOURCE Application'!A9<>\"\",'SOURCE Application'!A9,\"\")","v":""},{"$f":"LEFT(B9, VLOOKUP(\"Small name size\", Constants, 2))","v":""},{"$f":"IF('SOURCE Application'!D9<>\"\",'SOURCE Application'!D9,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"IF('SOURCE Application'!B9<>\"\",'SOURCE Application'!B9,VLOOKUP(\"Vendor default\", Constants, 2))","v":"Unknown"},{"$f":"STRINGTOID(IF('SOURCE Application'!E9<>\"\",'SOURCE Application'!E9,ApplicationTag!A$2))","v":"unknown"},"Regular",{"$f":"VLOOKUP(\"Status default\", Constants, 2)","v":"Standard"},{"$f":"IF('SOURCE Application'!E9<>\"\",'SOURCE Application'!E9,\"\")","v":""}]
[{"$f":"TOID(B10)","v":""},{"$f":"IF('SOURCE Application'!A10<>\"\",'SOURCE Application'!A10,\"\")","v":""},{"$f":"LEFT(B10, VLOOKUP(\"Small name size\", Constants, 2))","v":""},{"$f":"IF('SOURCE Application'!D10<>\"\",'SOURCE Application'!D10,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"IF('SOURCE Application'!B10<>\"\",'SOURCE Application'!B10,VLOOKUP(\"Vendor default\", Constants, 2))","v":"Unknown"},{"$f":"STRINGTOID(IF('SOURCE Application'!E10<>\"\",'SOURCE Application'!E10,ApplicationTag!A$2))","v":"unknown"},"Regular",{"$f":"VLOOKUP(\"Status default\", Constants, 2)","v":"Standard"},{"$f":"IF('SOURCE Application'!E10<>\"\",'SOURCE Application'!E10,\"\")","v":""}]
[{"$f":"TOID(B11)","v":""},{"$f":"IF('SOURCE Application'!A11<>\"\",'SOURCE Application'!A11,\"\")","v":""},{"$f":"LEFT(B11, VLOOKUP(\"Small name size\", Constants, 2))","v":""},{"$f":"IF('SOURCE Application'!D11<>\"\",'SOURCE Application'!D11,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"IF('SOURCE Application'!B11<>\"\",'SOURCE Application'!B11,VLOOKUP(\"Vendor default\", Constants, 2))","v":"Unknown"},{"$f":"STRINGTOID(IF('SOURCE Application'!E11<>\"\",'SOURCE Application'!E11,ApplicationTag!A$2))","v":"unknown"},"Regular",{"$f":"VLOOKUP(\"Status default\", Constants, 2)","v":"Standard"},{"$f":"IF('SOURCE Application'!E11<>\"\",'SOURCE Application'!E11,\"\")","v":""}]
[{"$f":"TOID(B12)","v":""},{"$f":"IF('SOURCE Application'!A12<>\"\",'SOURCE Application'!A12,\"\")","v":""},{"$f":"LEFT(B12, VLOOKUP(\"Small name size\", Constants, 2))","v":""},{"$f":"IF('SOURCE Application'!D12<>\"\",'SOURCE Application'!D12,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"IF('SOURCE Application'!B12<>\"\",'SOURCE Application'!B12,VLOOKUP(\"Vendor default\", Constants, 2))","v":"Unknown"},{"$f":"STRINGTOID(IF('SOURCE Application'!E12<>\"\",'SOURCE Application'!E12,ApplicationTag!A$2))","v":"unknown"},"Regular",{"$f":"VLOOKUP(\"Status default\", Constants, 2)","v":"Standard"},{"$f":"IF('SOURCE Application'!E12<>\"\",'SOURCE Application'!E12,\"\")","v":""}]
[{"$f":"TOID(B13)","v":""},{"$f":"IF('SOURCE Application'!A13<>\"\",'SOURCE Application'!A13,\"\")","v":""},{"$f":"LEFT(B13, VLOOKUP(\"Small name size\", Constants, 2))","v":""},{"$f":"IF('SOURCE Application'!D13<>\"\",'SOURCE Application'!D13,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"IF('SOURCE Application'!B13<>\"\",'SOURCE Application'!B13,VLOOKUP(\"Vendor default\", Constants, 2))","v":"Unknown"},{"$f":"STRINGTOID(IF('SOURCE Application'!E13<>\"\",'SOURCE Application'!E13,ApplicationTag!A$2))","v":"unknown"},"Regular",{"$f":"VLOOKUP(\"Status default\", Constants, 2)","v":"Standard"},{"$f":"IF('SOURCE Application'!E13<>\"\",'SOURCE Application'!E13,\"\")","v":""}]
[{"$f":"TOID(B14)","v":""},{"$f":"IF('SOURCE Application'!A14<>\"\",'SOURCE Application'!A14,\"\")","v":""},{"$f":"LEFT(B14, VLOOKUP(\"Small name size\", Constants, 2))","v":""},{"$f":"IF('SOURCE Application'!D14<>\"\",'SOURCE Application'!D14,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"IF('SOURCE Application'!B14<>\"\",'SOURCE Application'!B14,VLOOKUP(\"Vendor default\", Constants, 2))","v":"Unknown"},{"$f":"STRINGTOID(IF('SOURCE Application'!E14<>\"\",'SOURCE Application'!E14,ApplicationTag!A$2))","v":"unknown"},"Regular",{"$f":"VLOOKUP(\"Status default\", Constants, 2)","v":"Standard"},{"$f":"IF('SOURCE Application'!E14<>\"\",'SOURCE Application'!E14,\"\")","v":""}]
[{"$f":"TOID(B15)","v":""},{"$f":"IF('SOURCE Application'!A15<>\"\",'SOURCE Application'!A15,\"\")","v":""},{"$f":"LEFT(B15, VLOOKUP(\"Small name size\", Constants, 2))","v":""},{"$f":"IF('SOURCE Application'!D15<>\"\",'SOURCE Application'!D15,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"IF('SOURCE Application'!B15<>\"\",'SOURCE Application'!B15,VLOOKUP(\"Vendor default\", Constants, 2))","v":"Unknown"},{"$f":"STRINGTOID(IF('SOURCE Application'!E15<>\"\",'SOURCE Application'!E15,ApplicationTag!A$2))","v":"unknown"},"Regular",{"$f":"VLOOKUP(\"Status default\", Constants, 2)","v":"Standard"},{"$f":"IF('SOURCE Application'!E15<>\"\",'SOURCE Application'!E15,\"\")","v":""}]
[{"$f":"TOID(B16)","v":""},{"$f":"IF('SOURCE Application'!A16<>\"\",'SOURCE Application'!A16,\"\")","v":""},{"$f":"LEFT(B16, VLOOKUP(\"Small name size\", Constants, 2))","v":""},{"$f":"IF('SOURCE Application'!D16<>\"\",'SOURCE Application'!D16,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"IF('SOURCE Application'!B16<>\"\",'SOURCE Application'!B16,VLOOKUP(\"Vendor default\", Constants, 2))","v":"Unknown"},{"$f":"STRINGTOID(IF('SOURCE Application'!E16<>\"\",'SOURCE Application'!E16,ApplicationTag!A$2))","v":"unknown"},"Regular",{"$f":"VLOOKUP(\"Status default\", Constants, 2)","v":"Standard"},{"$f":"IF('SOURCE Application'!E16<>\"\",'SOURCE Application'!E16,\"\")","v":""}]
[{"$f":"TOID(B17)","v":""},{"$f":"IF('SOURCE Application'!A17<>\"\",'SOURCE Application'!A17,\"\")","v":""},{"$f":"LEFT(B17, VLOOKUP(\"Small name size\", Constants, 2))","v":""},{"$f":"IF('SOURCE Application'!D17<>\"\",'SOURCE Application'!D17,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"IF('SOURCE Application'!B17<>\"\",'SOURCE Application'!B17,VLOOKUP(\"Vendor default\", Constants, 2))","v":"Unknown"},{"$f":"STRINGTOID(IF('SOURCE Application'!E17<>\"\",'SOURCE Application'!E17,ApplicationTag!A$2))","v":"unknown"},"Regular",{"$f":"VLOOKUP(\"Status default\", Constants, 2)","v":"Standard"},{"$f":"IF('SOURCE Application'!E17<>\"\",'SOURCE Application'!E17,\"\")","v":""}]
[{"$f":"TOID(B18)","v":""},{"$f":"IF('SOURCE Application'!A18<>\"\",'SOURCE Application'!A18,\"\")","v":""},{"$f":"LEFT(B18, VLOOKUP(\"Small name size\", Constants, 2))","v":""},{"$f":"IF('SOURCE Application'!D18<>\"\",'SOURCE Application'!D18,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"IF('SOURCE Application'!B18<>\"\",'SOURCE Application'!B18,VLOOKUP(\"Vendor default\", Constants, 2))","v":"Unknown"},{"$f":"STRINGTOID(IF('SOURCE Application'!E18<>\"\",'SOURCE Application'!E18,ApplicationTag!A$2))","v":"unknown"},"Regular",{"$f":"VLOOKUP(\"Status default\", Constants, 2)","v":"Standard"},{"$f":"IF('SOURCE Application'!E18<>\"\",'SOURCE Application'!E18,\"\")","v":""}]
[{"$f":"TOID(B19)","v":""},{"$f":"IF('SOURCE Application'!A19<>\"\",'SOURCE Application'!A19,\"\")","v":""},{"$f":"LEFT(B19, VLOOKUP(\"Small name size\", Constants, 2))","v":""},{"$f":"IF('SOURCE Application'!D19<>\"\",'SOURCE Application'!D19,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"IF('SOURCE Application'!B19<>\"\",'SOURCE Application'!B19,VLOOKUP(\"Vendor default\", Constants, 2))","v":"Unknown"},{"$f":"STRINGTOID(IF('SOURCE Application'!E19<>\"\",'SOURCE Application'!E19,ApplicationTag!A$2))","v":"unknown"},"Regular",{"$f":"VLOOKUP(\"Status default\", Constants, 2)","v":"Standard"},{"$f":"IF('SOURCE Application'!E19<>\"\",'SOURCE Application'!E19,\"\")","v":""}]
[{"$f":"TOID(B20)","v":""},{"$f":"IF('SOURCE Application'!A20<>\"\",'SOURCE Application'!A20,\"\")","v":""},{"$f":"LEFT(B20, VLOOKUP(\"Small name size\", Constants, 2))","v":""},{"$f":"IF('SOURCE Application'!D20<>\"\",'SOURCE Application'!D20,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"IF('SOURCE Application'!B20<>\"\",'SOURCE Application'!B20,VLOOKUP(\"Vendor default\", Constants, 2))","v":"Unknown"},{"$f":"STRINGTOID(IF('SOURCE Application'!E20<>\"\",'SOURCE Application'!E20,ApplicationTag!A$2))","v":"unknown"},"Regular",{"$f":"VLOOKUP(\"Status default\", Constants, 2)","v":"Standard"},{"$f":"IF('SOURCE Application'!E20<>\"\",'SOURCE Application'!E20,\"\")","v":""}]
[{"$f":"TOID(B21)","v":""},{"$f":"IF('SOURCE Application'!A21<>\"\",'SOURCE Application'!A21,\"\")","v":""},{"$f":"LEFT(B21, VLOOKUP(\"Small name size\", Constants, 2))","v":""},{"$f":"IF('SOURCE Application'!D21<>\"\",'SOURCE Application'!D21,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"IF('SOURCE Application'!B21<>\"\",'SOURCE Application'!B21,VLOOKUP(\"Vendor default\", Constants, 2))","v":"Unknown"},{"$f":"STRINGTOID(IF('SOURCE Application'!E21<>\"\",'SOURCE Application'!E21,ApplicationTag!A$2))","v":"unknown"},"Regular",{"$f":"VLOOKUP(\"Status default\", Constants, 2)","v":"Standard"},{"$f":"IF('SOURCE Application'!E21<>\"\",'SOURCE Application'!E21,\"\")","v":""}]
[{"$f":"TOID(B22)","v":""},{"$f":"IF('SOURCE Application'!A22<>\"\",'SOURCE Application'!A22,\"\")","v":""},{"$f":"LEFT(B22, VLOOKUP(\"Small name size\", Constants, 2))","v":""},{"$f":"IF('SOURCE Application'!D22<>\"\",'SOURCE Application'!D22,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"IF('SOURCE Application'!B22<>\"\",'SOURCE Application'!B22,VLOOKUP(\"Vendor default\", Constants, 2))","v":"Unknown"},{"$f":"STRINGTOID(IF('SOURCE Application'!E22<>\"\",'SOURCE Application'!E22,ApplicationTag!A$2))","v":"unknown"},"Regular",{"$f":"VLOOKUP(\"Status default\", Constants, 2)","v":"Standard"},{"$f":"IF('SOURCE Application'!E22<>\"\",'SOURCE Application'!E22,\"\")","v":""}]
[{"$f":"TOID(B23)","v":""},{"$f":"IF('SOURCE Application'!A23<>\"\",'SOURCE Application'!A23,\"\")","v":""},{"$f":"LEFT(B23, VLOOKUP(\"Small name size\", Constants, 2))","v":""},{"$f":"IF('SOURCE Application'!D23<>\"\",'SOURCE Application'!D23,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"IF('SOURCE Application'!B23<>\"\",'SOURCE Application'!B23,VLOOKUP(\"Vendor default\", Constants, 2))","v":"Unknown"},{"$f":"STRINGTOID(IF('SOURCE Application'!E23<>\"\",'SOURCE Application'!E23,ApplicationTag!A$2))","v":"unknown"},"Regular",{"$f":"VLOOKUP(\"Status default\", Constants, 2)","v":"Standard"},{"$f":"IF('SOURCE Application'!E23<>\"\",'SOURCE Application'!E23,\"\")","v":""}]
[{"$f":"TOID(B24)","v":""},{"$f":"IF('SOURCE Application'!A24<>\"\",'SOURCE Application'!A24,\"\")","v":""},{"$f":"LEFT(B24, VLOOKUP(\"Small name size\", Constants, 2))","v":""},{"$f":"IF('SOURCE Application'!D24<>\"\",'SOURCE Application'!D24,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"IF('SOURCE Application'!B24<>\"\",'SOURCE Application'!B24,VLOOKUP(\"Vendor default\", Constants, 2))","v":"Unknown"},{"$f":"STRINGTOID(IF('SOURCE Application'!E24<>\"\",'SOURCE Application'!E24,ApplicationTag!A$2))","v":"unknown"},"Regular",{"$f":"VLOOKUP(\"Status default\", Constants, 2)","v":"Standard"},{"$f":"IF('SOURCE Application'!E24<>\"\",'SOURCE Application'!E24,\"\")","v":""}]
[{"$f":"TOID(B25)","v":""},{"$f":"IF('SOURCE Application'!A25<>\"\",'SOURCE Application'!A25,\"\")","v":""},{"$f":"LEFT(B25, VLOOKUP(\"Small name size\", Constants, 2))","v":""},{"$f":"IF('SOURCE Application'!D25<>\"\",'SOURCE Application'!D25,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"IF('SOURCE Application'!B25<>\"\",'SOURCE Application'!B25,VLOOKUP(\"Vendor default\", Constants, 2))","v":"Unknown"},{"$f":"STRINGTOID(IF('SOURCE Application'!E25<>\"\",'SOURCE Application'!E25,ApplicationTag!A$2))","v":"unknown"},"Regular",{"$f":"VLOOKUP(\"Status default\", Constants, 2)","v":"Standard"},{"$f":"IF('SOURCE Application'!E25<>\"\",'SOURCE Application'!E25,\"\")","v":""}]
[null,{"$f":"IF('SOURCE Application'!A26<>\"\",'SOURCE Application'!A26,\"\")","v":""}]
[null,{"$f":"IF('SOURCE Application'!A27<>\"\",'SOURCE Application'!A27,\"\")","v":""}]
[null,{"$f":"IF('SOURCE Application'!A28<>\"\",'SOURCE Application'!A28,\"\")","v":""}]
[null,{"$f":"IF('SOURCE Application'!A29<>\"\",'SOURCE Application'!A29,\"\")","v":""}]
[null,{"$f":"IF('SOURCE Application'!A30<>\"\",'SOURCE Application'!A30,\"\")","v":""}]
[null,{"$f":"IF('SOURCE Application'!A31<>\"\",'SOURCE Application'!A31,\"\")","v":""}]
[null,{"$f":"IF('SOURCE Application'!A32<>\"\",'SOURCE Application'!A32,\"\")","v":""}]
[null,{"$f":"IF('SOURCE Application'!A33<>\"\",'SOURCE Application'!A33,\"\")","v":""}]
[null,{"$f":"IF('SOURCE Application'!A34<>\"\",'SOURCE Application'!A34,\"\")","v":""}]
[null,{"$f":"IF('SOURCE Application'!A35<>\"\",'SOURCE Application'!A35,\"\")","v":""}]
[null,{"$f":"IF('SOURCE Application'!A36<>\"\",'SOURCE Application'!A36,\"\")","v":""}]
[null,{"$f":"IF('SOURCE Application'!A37<>\"\",'SOURCE Application'!A37,\"\")","v":""}]
[null,{"$f":"IF('SOURCE Application'!A38<>\"\",'SOURCE Application'!A38,\"\")","v":""}]
[null,{"$f":"IF('SOURCE Application'!A39<>\"\",'SOURCE Application'!A39,\"\")","v":""}]
[null,{"$f":"IF('SOURCE Application'!A40<>\"\",'SOURCE Application'!A40,\"\")","v":""}]
[null,{"$f":"IF('SOURCE Application'!A41<>\"\",'SOURCE Application'!A41,\"\")","v":""}]
[null,{"$f":"IF('SOURCE Application'!A42<>\"\",'SOURCE Application'!A42,\"\")","v":""}]
[null,{"$f":"IF('SOURCE Application'!A43<>\"\",'SOURCE Application'!A43,\"\")","v":""}]
[null,{"$f":"IF('SOURCE Application'!A44<>\"\",'SOURCE Application'!A44,\"\")","v":""}]
[null,{"$f":"IF('SOURCE Application'!A45<>\"\",'SOURCE Application'!A45,\"\")","v":""}]
[null,{"$f":"IF('SOURCE Application'!A46<>\"\",'SOURCE Application'!A46,\"\")","v":""}]
[null,{"$f":"IF('SOURCE Application'!A47<>\"\",'SOURCE Application'!A47,\"\")","v":""}]

{"sheet":"ApplicationTag","index":3,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["Id","Name","ShortName","Color","Status","ParentTagId","TagGroupId","Description"]
["unknown","Unknown",{"$f":"LEFT(B2, VLOOKUP(\"Small name size\", Constants, 2))","v":"Unknown"},"#B00000","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B3)","v":"accounts"},{"$f":"_xlfn.UNIQUE('SOURCE Application'!C2:C52)","v":"Accounts"},{"$f":"LEFT(B3, VLOOKUP(\"Small name size\", Constants, 2))","v":"Accounts"},"#CC9900","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B4)","v":"sales"},"Sales",{"$f":"LEFT(B4, VLOOKUP(\"Small name size\", Constants, 2))","v":"Sales"},"#385D35","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B5)","v":"0"},0,{"$f":"LEFT(B5, VLOOKUP(\"Small name size\", Constants, 2))","v":"0"},"#11868D","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B6)","v":""},null,{"$f":"LEFT(B6, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#CC9900","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B7)","v":""},null,{"$f":"LEFT(B7, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#CC9900","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B8)","v":""},null,{"$f":"LEFT(B8, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#1D99C7","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B9)","v":""},null,{"$f":"LEFT(B9, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#B00000","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B10)","v":""},null,{"$f":"LEFT(B10, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#B00000","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B11)","v":""},null,{"$f":"LEFT(B11, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#B00000","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B12)","v":""},null,{"$f":"LEFT(B12, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#385D35","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B13)","v":""},null,{"$f":"LEFT(B13, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#385D35","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B14)","v":""},null,{"$f":"LEFT(B14, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#11868D","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B15)","v":""},null,{"$f":"LEFT(B15, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#11868D","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B16)","v":""},null,{"$f":"LEFT(B16, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#11868D","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B17)","v":""},null,{"$f":"LEFT(B17, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#B00000","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B18)","v":""},null,{"$f":"LEFT(B18, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#385D35","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B19)","v":""},null,{"$f":"LEFT(B19, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#B00000","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B20)","v":""},null,{"$f":"LEFT(B20, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#B00000","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B21)","v":""},null,{"$f":"LEFT(B21, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#CC9900","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B22)","v":""},null,{"$f":"LEFT(B22, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#1D99C7","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B23)","v":""},null,{"$f":"LEFT(B23, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#11868D","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B24)","v":""},null,{"$f":"LEFT(B24, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#CC9900","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B25)","v":""},null,{"$f":"LEFT(B25, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#CC9900","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B26)","v":""},null,{"$f":"LEFT(B26, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#B00000","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B27)","v":""},null,{"$f":"LEFT(B27, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#1D99C7","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B28)","v":""},null,{"$f":"LEFT(B28, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#B00000","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B29)","v":""},null,{"$f":"LEFT(B29, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#CC9900","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B30)","v":""},null,{"$f":"LEFT(B30, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#11868D","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B31)","v":""},null,{"$f":"LEFT(B31, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#B00000","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B32)","v":""},null,{"$f":"LEFT(B32, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#11868D","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B33)","v":""},null,{"$f":"LEFT(B33, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#1D99C7","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B34)","v":""},null,{"$f":"LEFT(B34, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#CC9900","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B35)","v":""},null,{"$f":"LEFT(B35, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#11868D","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B36)","v":""},null,{"$f":"LEFT(B36, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#1D99C7","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B37)","v":""},null,{"$f":"LEFT(B37, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#1D99C7","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B38)","v":""},null,{"$f":"LEFT(B38, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#11868D","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B39)","v":""},null,{"$f":"LEFT(B39, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#B00000","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B40)","v":""},null,{"$f":"LEFT(B40, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#11868D","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B41)","v":""},null,{"$f":"LEFT(B41, VLOOKUP(\"Small name size\", Constants, 2))","v":""},"#11868D","Standard",null,{"$f":"ApplicationTagGroup!A$2","v":"default"}]
[{"$f":"TOID(B42)","v":""}]

{"sheet":"ApplicationTagGroup","index":4,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Id","Name"]
["default","Default"]

{"sheet":"Integration","index":5,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Id","Name","ShortName","Version","TagIds","SourceApplicationId","TargetApplicationId","Payload","Status","Description"]
[{"$f":"TOID(B2)","v":"int_001"},{"$f":"\"INT-\"&TEXT(ROW($A1), \"000\")","v":"INT-001"},{"$f":"LEFT(B2, VLOOKUP(\"Small name size\", Constants, 2))","v":"INT-001"},{"$f":"IF('SOURCE Integration'!F2<>\"\",'SOURCE Integration'!F2,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"STRINGTOID(IF('SOURCE Integration'!E2<>\"\",'SOURCE Integration'!E2,IntegrationTag!A$2))","v":"invoice"},{"$f":"TOID('SOURCE Integration'!C2)","v":"sap_finance"},{"$f":"TOID('SOURCE Integration'!D2)","v":"salesforce"},{"$f":"IF('SOURCE Integration'!E2<>\"\",'SOURCE Integration'!E2,VLOOKUP(\"Payload default\", Constants, 2))","v":"Invoice"},"Standard"]
[{"$f":"TOID(B3)","v":"int_002"},{"$f":"\"INT-\"&TEXT(ROW($A2), \"000\")","v":"INT-002"},{"$f":"LEFT(B3, VLOOKUP(\"Small name size\", Constants, 2))","v":"INT-002"},{"$f":"IF('SOURCE Integration'!F3<>\"\",'SOURCE Integration'!F3,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"STRINGTOID(IF('SOURCE Integration'!E3<>\"\",'SOURCE Integration'!E3,IntegrationTag!A$2))","v":"invoice"},{"$f":"TOID('SOURCE Integration'!C3)","v":"salesforce"},{"$f":"TOID('SOURCE Integration'!D3)","v":"sap_finance"},{"$f":"IF('SOURCE Integration'!E3<>\"\",'SOURCE Integration'!E3,VLOOKUP(\"Payload default\", Constants, 2))","v":"Invoice"},"Standard"]
[{"$f":"TOID(B4)","v":"int_003"},"INT-003",{"$f":"LEFT(B4, VLOOKUP(\"Small name size\", Constants, 2))","v":"INT-003"},{"$f":"IF('SOURCE Integration'!F4<>\"\",'SOURCE Integration'!F4,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"STRINGTOID(IF('SOURCE Integration'!E4<>\"\",'SOURCE Integration'!E4,IntegrationTag!A$2))","v":"unknown"},{"$f":"TOID('SOURCE Integration'!C4)","v":""},{"$f":"TOID('SOURCE Integration'!D4)","v":""},{"$f":"IF('SOURCE Integration'!E4<>\"\",'SOURCE Integration'!E4,VLOOKUP(\"Payload default\", Constants, 2))","v":{"$error":"#N/A"}}]
[{"$f":"TOID(B5)","v":"int_004"},"INT-004",{"$f":"LEFT(B5, VLOOKUP(\"Small name size\", Constants, 2))","v":"INT-004"},{"$f":"IF('SOURCE Integration'!F5<>\"\",'SOURCE Integration'!F5,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"STRINGTOID(IF('SOURCE Integration'!E5<>\"\",'SOURCE Integration'!E5,IntegrationTag!A$2))","v":"unknown"},{"$f":"TOID('SOURCE Integration'!C5)","v":""},{"$f":"TOID('SOURCE Integration'!D5)","v":""},{"$f":"IF('SOURCE Integration'!E5<>\"\",'SOURCE Integration'!E5,VLOOKUP(\"Payload default\", Constants, 2))","v":{"$error":"#N/A"}}]
[{"$f":"TOID(B6)","v":"int_005"},"INT-005",{"$f":"LEFT(B6, VLOOKUP(\"Small name size\", Constants, 2))","v":"INT-005"},{"$f":"IF('SOURCE Integration'!F6<>\"\",'SOURCE Integration'!F6,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"STRINGTOID(IF('SOURCE Integration'!E6<>\"\",'SOURCE Integration'!E6,IntegrationTag!A$2))","v":"unknown"},{"$f":"TOID('SOURCE Integration'!C6)","v":""},{"$f":"TOID('SOURCE Integration'!D6)","v":""},{"$f":"IF('SOURCE Integration'!E6<>\"\",'SOURCE Integration'!E6,VLOOKUP(\"Payload default\", Constants, 2))","v":{"$error":"#N/A"}}]
[{"$f":"TOID(B7)","v":"int_006"},"INT-006",{"$f":"LEFT(B7, VLOOKUP(\"Small name size\", Constants, 2))","v":"INT-006"},{"$f":"IF('SOURCE Integration'!F7<>\"\",'SOURCE Integration'!F7,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"STRINGTOID(IF('SOURCE Integration'!E7<>\"\",'SOURCE Integration'!E7,IntegrationTag!A$2))","v":"unknown"},{"$f":"TOID('SOURCE Integration'!C7)","v":""},{"$f":"TOID('SOURCE Integration'!D7)","v":""},{"$f":"IF('SOURCE Integration'!E7<>\"\",'SOURCE Integration'!E7,VLOOKUP(\"Payload default\", Constants, 2))","v":{"$error":"#N/A"}}]
[{"$f":"TOID(B8)","v":"int_007"},"INT-007",{"$f":"LEFT(B8, VLOOKUP(\"Small name size\", Constants, 2))","v":"INT-007"},{"$f":"IF('SOURCE Integration'!F8<>\"\",'SOURCE Integration'!F8,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"STRINGTOID(IF('SOURCE Integration'!E8<>\"\",'SOURCE Integration'!E8,IntegrationTag!A$2))","v":"unknown"},{"$f":"TOID('SOURCE Integration'!C8)","v":""},{"$f":"TOID('SOURCE Integration'!D8)","v":""},{"$f":"IF('SOURCE Integration'!E8<>\"\",'SOURCE Integration'!E8,VLOOKUP(\"Payload default\", Constants, 2))","v":{"$error":"#N/A"}}]
[{"$f":"TOID(B9)","v":"int_008"},"INT-008",{"$f":"LEFT(B9, VLOOKUP(\"Small name size\", Constants, 2))","v":"INT-008"},{"$f":"IF('SOURCE Integration'!F9<>\"\",'SOURCE Integration'!F9,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"STRINGTOID(IF('SOURCE Integration'!E9<>\"\",'SOURCE Integration'!E9,IntegrationTag!A$2))","v":"unknown"},{"$f":"TOID('SOURCE Integration'!C9)","v":""},{"$f":"TOID('SOURCE Integration'!D9)","v":""},{"$f":"IF('SOURCE Integration'!E9<>\"\",'SOURCE Integration'!E9,VLOOKUP(\"Payload default\", Constants, 2))","v":{"$error":"#N/A"}}]
[{"$f":"TOID(B10)","v":"int_009"},"INT-009",{"$f":"LEFT(B10, VLOOKUP(\"Small name size\", Constants, 2))","v":"INT-009"},{"$f":"IF('SOURCE Integration'!F10<>\"\",'SOURCE Integration'!F10,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"STRINGTOID(IF('SOURCE Integration'!E10<>\"\",'SOURCE Integration'!E10,IntegrationTag!A$2))","v":"unknown"},{"$f":"TOID('SOURCE Integration'!C10)","v":""},{"$f":"TOID('SOURCE Integration'!D10)","v":""},{"$f":"IF('SOURCE Integration'!E10<>\"\",'SOURCE Integration'!E10,VLOOKUP(\"Payload default\", Constants, 2))","v":{"$error":"#N/A"}}]
[{"$f":"TOID(B11)","v":"int_010"},"INT-010",{"$f":"LEFT(B11, VLOOKUP(\"Small name size\", Constants, 2))","v":"INT-010"},{"$f":"IF('SOURCE Integration'!F11<>\"\",'SOURCE Integration'!F11,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"STRINGTOID(IF('SOURCE Integration'!E11<>\"\",'SOURCE Integration'!E11,IntegrationTag!A$2))","v":"unknown"},{"$f":"TOID('SOURCE Integration'!C11)","v":""},{"$f":"TOID('SOURCE Integration'!D11)","v":""},{"$f":"IF('SOURCE Integration'!E11<>\"\",'SOURCE Integration'!E11,VLOOKUP(\"Payload default\", Constants, 2))","v":{"$error":"#N/A"}}]
[{"$f":"TOID(B12)","v":"int_011"},"INT-011",{"$f":"LEFT(B12, VLOOKUP(\"Small name size\", Constants, 2))","v":"INT-011"},{"$f":"IF('SOURCE Integration'!F12<>\"\",'SOURCE Integration'!F12,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"STRINGTOID(IF('SOURCE Integration'!E12<>\"\",'SOURCE Integration'!E12,IntegrationTag!A$2))","v":"unknown"},{"$f":"TOID('SOURCE Integration'!C12)","v":""},{"$f":"TOID('SOURCE Integration'!D12)","v":""},{"$f":"IF('SOURCE Integration'!E12<>\"\",'SOURCE Integration'!E12,VLOOKUP(\"Payload default\", Constants, 2))","v":{"$error":"#N/A"}}]
[{"$f":"TOID(B13)","v":"int_012"},"INT-012",{"$f":"LEFT(B13, VLOOKUP(\"Small name size\", Constants, 2))","v":"INT-012"},{"$f":"IF('SOURCE Integration'!F13<>\"\",'SOURCE Integration'!F13,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"STRINGTOID(IF('SOURCE Integration'!E13<>\"\",'SOURCE Integration'!E13,IntegrationTag!A$2))","v":"unknown"},{"$f":"TOID('SOURCE Integration'!C13)","v":""},{"$f":"TOID('SOURCE Integration'!D13)","v":""},{"$f":"IF('SOURCE Integration'!E13<>\"\",'SOURCE Integration'!E13,VLOOKUP(\"Payload default\", Constants, 2))","v":{"$error":"#N/A"}}]
[{"$f":"TOID(B14)","v":"int_013"},"INT-013",{"$f":"LEFT(B14, VLOOKUP(\"Small name size\", Constants, 2))","v":"INT-013"},{"$f":"IF('SOURCE Integration'!F14<>\"\",'SOURCE Integration'!F14,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"STRINGTOID(IF('SOURCE Integration'!E14<>\"\",'SOURCE Integration'!E14,IntegrationTag!A$2))","v":"unknown"},{"$f":"TOID('SOURCE Integration'!C14)","v":""},{"$f":"TOID('SOURCE Integration'!D14)","v":""},{"$f":"IF('SOURCE Integration'!E14<>\"\",'SOURCE Integration'!E14,VLOOKUP(\"Payload default\", Constants, 2))","v":{"$error":"#N/A"}}]
[{"$f":"TOID(B15)","v":"int_014"},"INT-014",{"$f":"LEFT(B15, VLOOKUP(\"Small name size\", Constants, 2))","v":"INT-014"},{"$f":"IF('SOURCE Integration'!F15<>\"\",'SOURCE Integration'!F15,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"STRINGTOID(IF('SOURCE Integration'!E15<>\"\",'SOURCE Integration'!E15,IntegrationTag!A$2))","v":"unknown"},{"$f":"TOID('SOURCE Integration'!C15)","v":""},{"$f":"TOID('SOURCE Integration'!D15)","v":""},{"$f":"IF('SOURCE Integration'!E15<>\"\",'SOURCE Integration'!E15,VLOOKUP(\"Payload default\", Constants, 2))","v":{"$error":"#N/A"}}]
[{"$f":"TOID(B16)","v":"int_015"},"INT-015",{"$f":"LEFT(B16, VLOOKUP(\"Small name size\", Constants, 2))","v":"INT-015"},{"$f":"IF('SOURCE Integration'!F16<>\"\",'SOURCE Integration'!F16,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"STRINGTOID(IF('SOURCE Integration'!E16<>\"\",'SOURCE Integration'!E16,IntegrationTag!A$2))","v":"unknown"},{"$f":"TOID('SOURCE Integration'!C16)","v":""},{"$f":"TOID('SOURCE Integration'!D16)","v":""},{"$f":"IF('SOURCE Integration'!E16<>\"\",'SOURCE Integration'!E16,VLOOKUP(\"Payload default\", Constants, 2))","v":{"$error":"#N/A"}}]
[{"$f":"TOID(B17)","v":"int_016"},"INT-016",{"$f":"LEFT(B17, VLOOKUP(\"Small name size\", Constants, 2))","v":"INT-016"},{"$f":"IF('SOURCE Integration'!F17<>\"\",'SOURCE Integration'!F17,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"STRINGTOID(IF('SOURCE Integration'!E17<>\"\",'SOURCE Integration'!E17,IntegrationTag!A$2))","v":"unknown"},{"$f":"TOID('SOURCE Integration'!C17)","v":""},{"$f":"TOID('SOURCE Integration'!D17)","v":""},{"$f":"IF('SOURCE Integration'!E17<>\"\",'SOURCE Integration'!E17,VLOOKUP(\"Payload default\", Constants, 2))","v":{"$error":"#N/A"}}]
[{"$f":"TOID(B18)","v":"int_017"},"INT-017",{"$f":"LEFT(B18, VLOOKUP(\"Small name size\", Constants, 2))","v":"INT-017"},{"$f":"IF('SOURCE Integration'!F18<>\"\",'SOURCE Integration'!F18,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"STRINGTOID(IF('SOURCE Integration'!E18<>\"\",'SOURCE Integration'!E18,IntegrationTag!A$2))","v":"unknown"},{"$f":"TOID('SOURCE Integration'!C18)","v":""},{"$f":"TOID('SOURCE Integration'!D18)","v":""},{"$f":"IF('SOURCE Integration'!E18<>\"\",'SOURCE Integration'!E18,VLOOKUP(\"Payload default\", Constants, 2))","v":{"$error":"#N/A"}}]
[{"$f":"TOID(B19)","v":"int_018"},"INT-018",{"$f":"LEFT(B19, VLOOKUP(\"Small name size\", Constants, 2))","v":"INT-018"},{"$f":"IF('SOURCE Integration'!F19<>\"\",'SOURCE Integration'!F19,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"STRINGTOID(IF('SOURCE Integration'!E19<>\"\",'SOURCE Integration'!E19,IntegrationTag!A$2))","v":"unknown"},{"$f":"TOID('SOURCE Integration'!C19)","v":""},{"$f":"TOID('SOURCE Integration'!D19)","v":""},{"$f":"IF('SOURCE Integration'!E19<>\"\",'SOURCE Integration'!E19,VLOOKUP(\"Payload default\", Constants, 2))","v":{"$error":"#N/A"}}]
[{"$f":"TOID(B20)","v":"int_019"},"INT-019",{"$f":"LEFT(B20, VLOOKUP(\"Small name size\", Constants, 2))","v":"INT-019"},{"$f":"IF('SOURCE Integration'!F20<>\"\",'SOURCE Integration'!F20,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"STRINGTOID(IF('SOURCE Integration'!E20<>\"\",'SOURCE Integration'!E20,IntegrationTag!A$2))","v":"unknown"},{"$f":"TOID('SOURCE Integration'!C20)","v":""},{"$f":"TOID('SOURCE Integration'!D20)","v":""},{"$f":"IF('SOURCE Integration'!E20<>\"\",'SOURCE Integration'!E20,VLOOKUP(\"Payload default\", Constants, 2))","v":{"$error":"#N/A"}}]
[{"$f":"TOID(B21)","v":"int_020"},"INT-020",{"$f":"LEFT(B21, VLOOKUP(\"Small name size\", Constants, 2))","v":"INT-020"},{"$f":"IF('SOURCE Integration'!F21<>\"\",'SOURCE Integration'!F21,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"STRINGTOID(IF('SOURCE Integration'!E21<>\"\",'SOURCE Integration'!E21,IntegrationTag!A$2))","v":"unknown"},{"$f":"TOID('SOURCE Integration'!C21)","v":""},{"$f":"TOID('SOURCE Integration'!D21)","v":""},{"$f":"IF('SOURCE Integration'!E21<>\"\",'SOURCE Integration'!E21,VLOOKUP(\"Payload default\", Constants, 2))","v":{"$error":"#N/A"}}]
[{"$f":"TOID(B22)","v":"int_021"},"INT-021",{"$f":"LEFT(B22, VLOOKUP(\"Small name size\", Constants, 2))","v":"INT-021"},{"$f":"IF('SOURCE Integration'!F22<>\"\",'SOURCE Integration'!F22,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"STRINGTOID(IF('SOURCE Integration'!E22<>\"\",'SOURCE Integration'!E22,IntegrationTag!A$2))","v":"unknown"},{"$f":"TOID('SOURCE Integration'!C22)","v":""},{"$f":"TOID('SOURCE Integration'!D22)","v":""},{"$f":"IF('SOURCE Integration'!E22<>\"\",'SOURCE Integration'!E22,VLOOKUP(\"Payload default\", Constants, 2))","v":{"$error":"#N/A"}}]
[{"$f":"TOID(B23)","v":"int_022"},"INT-022",{"$f":"LEFT(B23, VLOOKUP(\"Small name size\", Constants, 2))","v":"INT-022"},{"$f":"IF('SOURCE Integration'!F23<>\"\",'SOURCE Integration'!F23,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"STRINGTOID(IF('SOURCE Integration'!E23<>\"\",'SOURCE Integration'!E23,IntegrationTag!A$2))","v":"unknown"},{"$f":"TOID('SOURCE Integration'!C23)","v":""},{"$f":"TOID('SOURCE Integration'!D23)","v":""},{"$f":"IF('SOURCE Integration'!E23<>\"\",'SOURCE Integration'!E23,VLOOKUP(\"Payload default\", Constants, 2))","v":{"$error":"#N/A"}}]
[{"$f":"TOID(B24)","v":"int_023"},"INT-023",{"$f":"LEFT(B24, VLOOKUP(\"Small name size\", Constants, 2))","v":"INT-023"},{"$f":"IF('SOURCE Integration'!F24<>\"\",'SOURCE Integration'!F24,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"STRINGTOID(IF('SOURCE Integration'!E24<>\"\",'SOURCE Integration'!E24,IntegrationTag!A$2))","v":"unknown"},{"$f":"TOID('SOURCE Integration'!C24)","v":""},{"$f":"TOID('SOURCE Integration'!D24)","v":""},{"$f":"IF('SOURCE Integration'!E24<>\"\",'SOURCE Integration'!E24,VLOOKUP(\"Payload default\", Constants, 2))","v":{"$error":"#N/A"}}]
[{"$f":"TOID(B25)","v":"int_024"},"INT-024",{"$f":"LEFT(B25, VLOOKUP(\"Small name size\", Constants, 2))","v":"INT-024"},{"$f":"IF('SOURCE Integration'!F25<>\"\",'SOURCE Integration'!F25,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"STRINGTOID(IF('SOURCE Integration'!E25<>\"\",'SOURCE Integration'!E25,IntegrationTag!A$2))","v":"unknown"},{"$f":"TOID('SOURCE Integration'!C25)","v":""},{"$f":"TOID('SOURCE Integration'!D25)","v":""},{"$f":"IF('SOURCE Integration'!E25<>\"\",'SOURCE Integration'!E25,VLOOKUP(\"Payload default\", Constants, 2))","v":{"$error":"#N/A"}}]
[{"$f":"TOID(B26)","v":"int_025"},"INT-025",{"$f":"LEFT(B26, VLOOKUP(\"Small name size\", Constants, 2))","v":"INT-025"},{"$f":"IF('SOURCE Integration'!F26<>\"\",'SOURCE Integration'!F26,VLOOKUP(\"Version default\", Constants, 2))","v":"Data"},{"$f":"STRINGTOID(IF('SOURCE Integration'!E26<>\"\",'SOURCE Integration'!E26,IntegrationTag!A$2))","v":"unknown"},{"$f":"TOID('SOURCE Integration'!C26)","v":""},{"$f":"TOID('SOURCE Integration'!D26)","v":""},{"$f":"IF('SOURCE Integration'!E26<>\"\",'SOURCE Integration'!E26,VLOOKUP(\"Payload default\", Constants, 2))","v":{"$error":"#N/A"}}]

{"sheet":"IntegrationTag","index":6,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Id","Name","ShortName","Color","Status","Description"]
["unknown","Unknown",null,"#B00000","Standard"]
[null,null,null,"#CC9900","Standard"]
[null,null,null,"#385D35","Standard"]
[null,null,null,"#55CA42","Standard"]
[null,null,null,"#11868D","Standard"]
[null,null,null,"#1D99C7","Standard"]
[null,null,null,"#1D99C7","Standard"]

{"sheet":"FieldDefinition","index":7,"n_rows":1,"n_cols":14,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Scope","Id","Name","TaggedBy","Type","SubType","Required","VisibilityType","Description","IsArray","IsArrayLabeled","IsArrayOrdered","Options","Default"]

{"sheet":"SOURCE Application","index":8,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Name","Vendor","Business Owner","Version","Description"]
["SAP Finance","SAP","Accounts",null,"Core accounting platform"]
["Salesforce","Salesforce","Sales",null,"Core CRM paltform"]

{"sheet":"SOURCE Integration","index":9,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Id","Name","Source Application","Target Application","Payload","Version","Description"]
["int-001","SAP to Salesforce invoice message","SAP Finance","Salesforce","Invoice"]
["int-002","Salesforce to SAP invoice confirmation","Salesforce","SAP Finance","Invoice"]