{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Riskk","Login","Main","NetIncome","InTB"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":2,"defined_names":100,"comments":1,"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":"Riskk","index":0,"n_rows":3,"n_cols":24,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,{"$f":"COUNT(H3:H20)","v":"00:00:00"},false]
[null,null,null,null,null,null,null,"Main/sub","Caption","On Action","NewGroup",null,"CITI raw",null,null,null,null,null,null,null,null,null,"Bizdate","2020-05-27"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Select 'New',\"","v":"Select 'New',"}]

{"sheet":"Login","index":1,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Riskk   .  Com"]
[null,"Sdn Bhd (CN 388306K)"]
[null,null,null,null,null,null,null,"Box 389, Lot 7.16, Wisma Central, Jln Ampang, 50450 Kuala Lumpur"]
[]
[]
[]
[]
["00:00:00","Net Income MTD YTD"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"`"]

{"sheet":"Main","index":2,"n_rows":21,"n_cols":30,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[]
[null,"SYARIKAT TAKAFUL MALAYSIA BERHAD"]
[null,null,null,"* Please sheet(s) to print"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Custodian Instruction - Citi","KWAP","KWAPFI"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,null,null,null,null,null,null,null,null,"MM","KHAZANAH","YH-AUR-VCAM"]
["Value Date:","2020-05-22",null,"Pg5","NO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YAMIR-MM","YAMIR-VCAM","VCAM-TABA","ASEAN5ESG"]
[null,null,null,null,null,null,null,null,null,null,"Please debit the above Beneficiary Account and remit the funds to the aforementioned Placement to effect the Placement. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YAMIR","YAMIR-VCAM","VCAM-TABA","ASEAN5ESG"]
["Fund Group Code:","INTERNAL",null,null,null,null,null,null,null,null,"On maturity of the Placement, please arrange to credit all monies due (whether principal or otherwise) from the Placement into the above Beneficiary Account."]
[]
[]
["Step 1: Refresh Data",null,null,"Pg6","NO",null,null,null,"FUND","FUND MAPPING"]
[null,null,null,null,null,null,null,null,"PSA","PSA-EQ"]
[null,null,null,null,null,null,null,null,"PA","PA-EQ","__________________________________",null,null,null,null,null,"__________________________________"]
[null,null,null,null,null,null,null,null,"Ansta","STA-EQ","Authorised Signatory",null,null,null,null,null,"Authorised Signatory"]
["Step 3.1: Print Report",null,null,null,null,null,null,null,"Group","GFTA-EQ"]
[null,null,null,null,null,null,null,null,"Gen","GEN-EQ",{"$f":"\"Name: \" & Signature1","v":"Name: INTERNAL"},null,null,null,null,null,{"$f":"\"Name: \" & Signature2","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"SHF","SHF-EQ",{"$f":"\"Designation: \" & Designation1","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"\"Designation: \" &Designation2","v":{"$error":"#REF!"}}]
[]
[]
["Step 2: Export Report"]

{"sheet":"NetIncome","index":3,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"FUND","Realised MTD","Realised YTD","Dividend for the MTH (ex-date)","Dividend for the Year (ex-date)","MTD Unrealised Gain/(Loss)","YTD Unrealised Gain/(Loss)","Net Income \nMTD","Net Income \nYTD"]
[null,"PSA",{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B4,Main!I:J,2,FALSE),InTB!C:C,\">=600000\",InTB!C:C,\"<=600999\")","v":-691912.8900000006},{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B4,Main!I:J,2,FALSE),InTB!C:C,\">=600000\",InTB!C:C,\"<=600999\")","v":-6090306.2000000002},{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B4,Main!I:J,2,FALSE),InTB!C:C,\">=636010\",InTB!C:C,\"<=636999\")+SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B4,Main!I:J,2,FALSE),InTB!C:C,\">=635010\",InTB!C:C,\"<=635999\")","v":0},{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B4,Main!I:J,2,FALSE),InTB!C:C,\">=636010\",InTB!C:C,\"<=636999\")+SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B4,Main!I:J,2,FALSE),InTB!C:C,\">=635010\",InTB!C:C,\"<=635999\")","v":700917.71},{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B4,Main!I:J,2,FALSE),InTB!C:C,\">=689000\",InTB!C:C,\"<=689999\")+SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B4,Main!I:J,2,FALSE),InTB!C:C,\">=688000\",InTB!C:C,\"<=688999\")+SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B4,Main!I:J,2,FALSE),InTB!C:C,\">=989000\",InTB!C:C,\"<=989999\")+SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B4,Main!I:J,2,FALSE),InTB!C:C,\">=988000\",InTB!C:C,\"<=988999\")","v":3242658.29},{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B4,Main!I:J,2,FALSE),InTB!C:C,\">=689000\",InTB!C:C,\"<=689999\")+SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B4,Main!I:J,2,FALSE),InTB!C:C,\">=688000\",InTB!C:C,\"<=688999\")+SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B4,Main!I:J,2,FALSE),InTB!C:C,\">=989000\",InTB!C:C,\"<=989999\")+SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B4,Main!I:J,2,FALSE),InTB!C:C,\">=988000\",InTB!C:C,\"<=988999\")","v":-103544.25},{"$f":"+C4+E4+G4","v":2550745.3999999994},-5492932.7400000002]
[null,"PA",{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B5,Main!I:J,2,FALSE),InTB!C:C,\">=600000\",InTB!C:C,\"<=600999\")","v":-1098676.8399999999},{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B5,Main!I:J,2,FALSE),InTB!C:C,\">=600000\",InTB!C:C,\"<=600999\")","v":-6361736.4299999997},{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B5,Main!I:J,2,FALSE),InTB!C:C,\">=636010\",InTB!C:C,\"<=636999\")+SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B5,Main!I:J,2,FALSE),InTB!C:C,\">=635010\",InTB!C:C,\"<=635999\")","v":0},{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B5,Main!I:J,2,FALSE),InTB!C:C,\">=636010\",InTB!C:C,\"<=636999\")+SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B5,Main!I:J,2,FALSE),InTB!C:C,\">=635010\",InTB!C:C,\"<=635999\")","v":815038.66},{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B5,Main!I:J,2,FALSE),InTB!C:C,\">=689000\",InTB!C:C,\"<=689999\")+SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B5,Main!I:J,2,FALSE),InTB!C:C,\">=688000\",InTB!C:C,\"<=688999\")+SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B5,Main!I:J,2,FALSE),InTB!C:C,\">=989000\",InTB!C:C,\"<=989999\")+SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B5,Main!I:J,2,FALSE),InTB!C:C,\">=988000\",InTB!C:C,\"<=988999\")","v":3687491.4000000004},{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B5,Main!I:J,2,FALSE),InTB!C:C,\">=689000\",InTB!C:C,\"<=689999\")+SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B5,Main!I:J,2,FALSE),InTB!C:C,\">=688000\",InTB!C:C,\"<=688999\")+SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B5,Main!I:J,2,FALSE),InTB!C:C,\">=989000\",InTB!C:C,\"<=989999\")+SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B5,Main!I:J,2,FALSE),InTB!C:C,\">=988000\",InTB!C:C,\"<=988999\")","v":217621.95000000019},2588814.5600000005,-5329075.8199999994]
[null,"Ansta",{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B6,Main!I:J,2,FALSE),InTB!C:C,\">=600000\",InTB!C:C,\"<=600999\")","v":-122689.06000000006},{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B6,Main!I:J,2,FALSE),InTB!C:C,\">=600000\",InTB!C:C,\"<=600999\")","v":-1001069.14},{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B6,Main!I:J,2,FALSE),InTB!C:C,\">=636010\",InTB!C:C,\"<=636999\")+SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B6,Main!I:J,2,FALSE),InTB!C:C,\">=635010\",InTB!C:C,\"<=635999\")","v":0},{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B6,Main!I:J,2,FALSE),InTB!C:C,\">=636010\",InTB!C:C,\"<=636999\")+SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B6,Main!I:J,2,FALSE),InTB!C:C,\">=635010\",InTB!C:C,\"<=635999\")","v":110576.56},{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B6,Main!I:J,2,FALSE),InTB!C:C,\">=689000\",InTB!C:C,\"<=689999\")+SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B6,Main!I:J,2,FALSE),InTB!C:C,\">=688000\",InTB!C:C,\"<=688999\")+SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B6,Main!I:J,2,FALSE),InTB!C:C,\">=989000\",InTB!C:C,\"<=989999\")+SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B6,Main!I:J,2,FALSE),InTB!C:C,\">=988000\",InTB!C:C,\"<=988999\")","v":560591.70000000007},{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B6,Main!I:J,2,FALSE),InTB!C:C,\">=689000\",InTB!C:C,\"<=689999\")+SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B6,Main!I:J,2,FALSE),InTB!C:C,\">=688000\",InTB!C:C,\"<=688999\")+SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B6,Main!I:J,2,FALSE),InTB!C:C,\">=989000\",InTB!C:C,\"<=989999\")+SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B6,Main!I:J,2,FALSE),InTB!C:C,\">=988000\",InTB!C:C,\"<=988999\")","v":-96168.530000000028},437902.64,-986661.1100000001]
[null,"Group",{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B7,Main!I:J,2,FALSE),InTB!C:C,\">=600000\",InTB!C:C,\"<=600999\")","v":-126418.58999999997},{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B7,Main!I:J,2,FALSE),InTB!C:C,\">=600000\",InTB!C:C,\"<=600999\")","v":-649651.18999999994},{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B7,Main!I:J,2,FALSE),InTB!C:C,\">=636010\",InTB!C:C,\"<=636999\")+SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B7,Main!I:J,2,FALSE),InTB!C:C,\">=635010\",InTB!C:C,\"<=635999\")","v":0},{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B7,Main!I:J,2,FALSE),InTB!C:C,\">=636010\",InTB!C:C,\"<=636999\")+SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B7,Main!I:J,2,FALSE),InTB!C:C,\">=635010\",InTB!C:C,\"<=635999\")","v":86029.74},{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B7,Main!I:J,2,FALSE),InTB!C:C,\">=689000\",InTB!C:C,\"<=689999\")+SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B7,Main!I:J,2,FALSE),InTB!C:C,\">=688000\",InTB!C:C,\"<=688999\")+SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B7,Main!I:J,2,FALSE),InTB!C:C,\">=989000\",InTB!C:C,\"<=989999\")+SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B7,Main!I:J,2,FALSE),InTB!C:C,\">=988000\",InTB!C:C,\"<=988999\")","v":391039.52000000008},{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B7,Main!I:J,2,FALSE),InTB!C:C,\">=689000\",InTB!C:C,\"<=689999\")+SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B7,Main!I:J,2,FALSE),InTB!C:C,\">=688000\",InTB!C:C,\"<=688999\")+SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B7,Main!I:J,2,FALSE),InTB!C:C,\">=989000\",InTB!C:C,\"<=989999\")+SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B7,Main!I:J,2,FALSE),InTB!C:C,\">=988000\",InTB!C:C,\"<=988999\")","v":-44563.979999999981},264620.93000000011,-608185.42999999993]
[null,"Gen",{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B8,Main!I:J,2,FALSE),InTB!C:C,\">=600000\",InTB!C:C,\"<=600999\")","v":0},{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B8,Main!I:J,2,FALSE),InTB!C:C,\">=600000\",InTB!C:C,\"<=600999\")","v":0},{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B8,Main!I:J,2,FALSE),InTB!C:C,\">=636010\",InTB!C:C,\"<=636999\")+SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B8,Main!I:J,2,FALSE),InTB!C:C,\">=635010\",InTB!C:C,\"<=635999\")","v":0},{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B8,Main!I:J,2,FALSE),InTB!C:C,\">=636010\",InTB!C:C,\"<=636999\")+SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B8,Main!I:J,2,FALSE),InTB!C:C,\">=635010\",InTB!C:C,\"<=635999\")","v":0},{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B8,Main!I:J,2,FALSE),InTB!C:C,\">=689000\",InTB!C:C,\"<=689999\")+SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B8,Main!I:J,2,FALSE),InTB!C:C,\">=688000\",InTB!C:C,\"<=688999\")+SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B8,Main!I:J,2,FALSE),InTB!C:C,\">=989000\",InTB!C:C,\"<=989999\")+SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B8,Main!I:J,2,FALSE),InTB!C:C,\">=988000\",InTB!C:C,\"<=988999\")","v":0},{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B8,Main!I:J,2,FALSE),InTB!C:C,\">=689000\",InTB!C:C,\"<=689999\")+SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B8,Main!I:J,2,FALSE),InTB!C:C,\">=688000\",InTB!C:C,\"<=688999\")+SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B8,Main!I:J,2,FALSE),InTB!C:C,\">=989000\",InTB!C:C,\"<=989999\")+SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B8,Main!I:J,2,FALSE),InTB!C:C,\">=988000\",InTB!C:C,\"<=988999\")","v":0},0,0]
[null,"SHF",{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B9,Main!I:J,2,FALSE),InTB!C:C,\">=600000\",InTB!C:C,\"<=600999\")","v":-21923.479999999981},{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B9,Main!I:J,2,FALSE),InTB!C:C,\">=600000\",InTB!C:C,\"<=600999\")","v":-529088.87},{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B9,Main!I:J,2,FALSE),InTB!C:C,\">=636010\",InTB!C:C,\"<=636999\")+SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B9,Main!I:J,2,FALSE),InTB!C:C,\">=635010\",InTB!C:C,\"<=635999\")","v":0},{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B9,Main!I:J,2,FALSE),InTB!C:C,\">=636010\",InTB!C:C,\"<=636999\")+SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B9,Main!I:J,2,FALSE),InTB!C:C,\">=635010\",InTB!C:C,\"<=635999\")","v":78481.039999999994},{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B9,Main!I:J,2,FALSE),InTB!C:C,\">=689000\",InTB!C:C,\"<=689999\")+SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B9,Main!I:J,2,FALSE),InTB!C:C,\">=688000\",InTB!C:C,\"<=688999\")+SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B9,Main!I:J,2,FALSE),InTB!C:C,\">=989000\",InTB!C:C,\"<=989999\")+SUMIFS(InTB!B:B,InTB!A:A,\"MTH\",InTB!D:D,VLOOKUP(B9,Main!I:J,2,FALSE),InTB!C:C,\">=988000\",InTB!C:C,\"<=988999\")","v":220947.58999999997},{"$f":"SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B9,Main!I:J,2,FALSE),InTB!C:C,\">=689000\",InTB!C:C,\"<=689999\")+SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B9,Main!I:J,2,FALSE),InTB!C:C,\">=688000\",InTB!C:C,\"<=688999\")+SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B9,Main!I:J,2,FALSE),InTB!C:C,\">=989000\",InTB!C:C,\"<=989999\")+SUMIFS(InTB!B:B,InTB!A:A,\"YTD\",InTB!D:D,VLOOKUP(B9,Main!I:J,2,FALSE),InTB!C:C,\">=988000\",InTB!C:C,\"<=988999\")","v":128901.78000000003},199024.11,-321706.05]

{"sheet":"InTB","index":4,"n_rows":233,"n_cols":4,"rows_kept":233,"cut":false,"hidden":true,"merged":[]}
[]
["sType","Diff","GLCode","qFundCode"]
["MTH",0,100010,"GEN-EQ"]
["MTH",0,101010,"GEN-EQ"]
["MTH",0,800000,"GEN-EQ"]
["MTH",0,830000,"GEN-EQ"]
["MTH",383808,100010,"GFTA-EQ"]
["MTH",-233000,100211,"GFTA-EQ"]
["MTH",0,100460,"GFTA-EQ"]
["MTH",0,101010,"GFTA-EQ"]
["MTH",-273.93,139211,"GFTA-EQ"]
["MTH",-388639.52000000008,189010,"GFTA-EQ"]
["MTH",-2399.9999999999991,189460,"GFTA-EQ"]
["MTH",-17333.169999999998,500000,"GFTA-EQ"]
["MTH",-126418.58999999997,600010,"GFTA-EQ"]
["MTH",7668.5800000000017,630211,"GFTA-EQ"]
["MTH",0,636010,"GFTA-EQ"]
["MTH",273.93,639211,"GFTA-EQ"]
["MTH",388639.52000000008,689010,"GFTA-EQ"]
["MTH",2399.9999999999991,689460,"GFTA-EQ"]
["MTH",-50.039999999999964,700301,"GFTA-EQ"]
["MTH",0,800000,"GFTA-EQ"]
["MTH",0,810000,"GFTA-EQ"]
["MTH",0,830000,"GFTA-EQ"]
["MTH",0,939211,"GFTA-EQ"]
["MTH",0,989010,"GFTA-EQ"]
["MTH",3305036.6600000039,100010,"PA-EQ"]
["MTH",-2019000,100211,"PA-EQ"]
["MTH",0,100460,"PA-EQ"]
["MTH",0,101010,"PA-EQ"]
["MTH",-50527.549999999988,139211,"PA-EQ"]
["MTH",-3665371.4000000004,189010,"PA-EQ"]
["MTH",-22120,189460,"PA-EQ"]
["MTH",12.25,500000,"PA-EQ"]
["MTH",-1098676.8399999999,600010,"PA-EQ"]
["MTH",59121.899999999965,630211,"PA-EQ"]
["MTH",0,636010,"PA-EQ"]
["MTH",50527.549999999988,639211,"PA-EQ"]
["MTH",3665371.4000000004,689010,"PA-EQ"]
["MTH",22120,689460,"PA-EQ"]
["MTH",-462.92000000000098,700301,"PA-EQ"]
["MTH",0,710102,"PA-EQ"]
["MTH",0,800000,"PA-EQ"]
["MTH",0,810000,"PA-EQ"]
["MTH",0,830000,"PA-EQ"]
["MTH",0,939211,"PA-EQ"]
["MTH",0,989010,"PA-EQ"]
["MTH",2058099.3699999973,100010,"PSA-EQ"]
["MTH",-1166000,100211,"PSA-EQ"]
["MTH",0,100460,"PSA-EQ"]
["MTH",0,101010,"PSA-EQ"]
["MTH",-71523.47000000003,139211,"PSA-EQ"]
["MTH",-3218534.29,189010,"PSA-EQ"]
["MTH",-24124,189460,"PSA-EQ"]
["MTH",0,299010,"PSA-EQ"]
["MTH",-22.710000000000036,500000,"PSA-EQ"]
["MTH",-691912.8900000006,600010,"PSA-EQ"]
["MTH",72054.049999999988,630211,"PSA-EQ"]
["MTH",0,636010,"PSA-EQ"]
["MTH",71523.47000000003,639211,"PSA-EQ"]
["MTH",3218534.29,689010,"PSA-EQ"]
["MTH",24124,689460,"PSA-EQ"]
["MTH",-469.56999999999971,700301,"PSA-EQ"]
["MTH",0,710102,"PSA-EQ"]
["MTH",0,800000,"PSA-EQ"]
["MTH",0,810000,"PSA-EQ"]
["MTH",0,830000,"PSA-EQ"]
["MTH",0,939211,"PSA-EQ"]
["MTH",0,989010,"PSA-EQ"]
["MTH",67116.269999999553,100010,"SHF-EQ"]
["MTH",-56000,100211,"SHF-EQ"]
["MTH",0,100460,"SHF-EQ"]
["MTH",0,101010,"SHF-EQ"]
["MTH",-196.36999999999989,139211,"SHF-EQ"]
["MTH",-218377.58999999997,189010,"SHF-EQ"]
["MTH",-2570,189460,"SHF-EQ"]
["MTH",-174.51,500000,"SHF-EQ"]
["MTH",-21923.479999999981,600010,"SHF-EQ"]
["MTH",11025.020000000004,630211,"SHF-EQ"]
["MTH",0,636010,"SHF-EQ"]
["MTH",196.36999999999989,639211,"SHF-EQ"]
["MTH",218377.58999999997,689010,"SHF-EQ"]
["MTH",2570,689460,"SHF-EQ"]
["MTH",-43.300000000000182,700301,"SHF-EQ"]
["MTH",0,710102,"SHF-EQ"]
["MTH",0,800000,"SHF-EQ"]
["MTH",0,810000,"SHF-EQ"]
["MTH",0,830000,"SHF-EQ"]
["MTH",0,939211,"SHF-EQ"]
["MTH",0,989010,"SHF-EQ"]
["MTH",357943.34000000171,100010,"STA-EQ"]
["MTH",-210000,100211,"STA-EQ"]
["MTH",0,100460,"STA-EQ"]
["MTH",0,101010,"STA-EQ"]
["MTH",6810.079999999999,139211,"STA-EQ"]
["MTH",-555741.70000000007,189010,"STA-EQ"]
["MTH",-4850,189460,"STA-EQ"]
["MTH",-52059.88,500000,"STA-EQ"]
["MTH",-122689.06000000006,600010,"STA-EQ"]
["MTH",26886.189999999973,630211,"STA-EQ"]
["MTH",0,636010,"STA-EQ"]
["MTH",-6810.079999999999,639211,"STA-EQ"]
["MTH",555741.70000000007,689010,"STA-EQ"]
["MTH",4850,689460,"STA-EQ"]
["MTH",-80.590000000000146,700301,"STA-EQ"]
["MTH",0,710102,"STA-EQ"]
["MTH",0,800000,"STA-EQ"]
["MTH",0,810000,"STA-EQ"]
["MTH",0,830000,"STA-EQ"]
["MTH",0,939211,"STA-EQ"]
["MTH",0,989010,"STA-EQ"]
["YTD",-588688.16,100010,"GEN-EQ"]
["YTD",588688.16,101010,"GEN-EQ"]
["YTD",2885853.8,800000,"GEN-EQ"]
["YTD",-2885853.8,830000,"GEN-EQ"]
["YTD",-6317680.2199999997,100010,"GFTA-EQ"]
["YTD",-6502000,100211,"GFTA-EQ"]
["YTD",-518847.8,100460,"GFTA-EQ"]
["YTD",304914.2,101010,"GFTA-EQ"]
["YTD",-694.73,139211,"GFTA-EQ"]
["YTD",511453.66,189010,"GFTA-EQ"]
["YTD",8167.8,189460,"GFTA-EQ"]
["YTD",-14674.78,200200,"GFTA-EQ"]
["YTD",-2656,299460,"GFTA-EQ"]
["YTD",-17894.23,500000,"GFTA-EQ"]
["YTD",-649651.18999999994,600010,"GFTA-EQ"]
["YTD",59626.28,630211,"GFTA-EQ"]
["YTD",83373.740000000005,636010,"GFTA-EQ"]
["YTD",2656,636460,"GFTA-EQ"]
["YTD",694.73,639211,"GFTA-EQ"]
["YTD",-511453.66,689010,"GFTA-EQ"]
["YTD",-8167.8,689460,"GFTA-EQ"]
["YTD",-4435.3,700301,"GFTA-EQ"]
["YTD",14953083.76,800000,"GFTA-EQ"]
["YTD",-475057.48,810000,"GFTA-EQ"]
["YTD",-1375538.36,830000,"GFTA-EQ"]
["YTD",-276.10000000000002,939211,"GFTA-EQ"]
["YTD",475057.48,989010,"GFTA-EQ"]
["YTD",-56082973.909999996,100010,"PA-EQ"]
["YTD",-65309000,100211,"PA-EQ"]
["YTD",-4843146.8600000003,100460,"PA-EQ"]
["YTD",420112.29,101010,"PA-EQ"]
["YTD",-344620.24,139211,"PA-EQ"]
["YTD",4499016.05,189010,"PA-EQ"]
["YTD",74426.86,189460,"PA-EQ"]
["YTD",-246031.05,200200,"PA-EQ"]
["YTD",-24900,299460,"PA-EQ"]
["YTD",-347.85,500000,"PA-EQ"]
["YTD",-6361736.4299999997,600010,"PA-EQ"]
["YTD",444383.16,630211,"PA-EQ"]
["YTD",790138.66,636010,"PA-EQ"]
["YTD",24900,636460,"PA-EQ"]
["YTD",344620.24,639211,"PA-EQ"]
["YTD",-4499016.05,689010,"PA-EQ"]
["YTD",-74426.86,689460,"PA-EQ"]
["YTD",-8414.6200000000008,700301,"PA-EQ"]
["YTD",-75,710102,"PA-EQ"]
["YTD",147555352.28999999,800000,"PA-EQ"]
["YTD",-4791064.8600000003,810000,"PA-EQ"]
["YTD",-16324236.640000001,830000,"PA-EQ"]
["YTD",-34024.04,939211,"PA-EQ"]
["YTD",4791064.8600000003,989010,"PA-EQ"]
["YTD",-57555386.340000004,100010,"PSA-EQ"]
["YTD",-78050000,100211,"PSA-EQ"]
["YTD",-5447282.1600000001,100460,"PSA-EQ"]
["YTD",833801.44,101010,"PSA-EQ"]
["YTD",-593266.54,139211,"PSA-EQ"]
["YTD",4550624.84,189010,"PSA-EQ"]
["YTD",84872.16,189460,"PSA-EQ"]
["YTD",-271748.25,200200,"PSA-EQ"]
["YTD",-0.01,299010,"PSA-EQ"]
["YTD",-28253.200000000001,299460,"PSA-EQ"]
["YTD",-929.85,500000,"PSA-EQ"]
["YTD",-6090306.2000000002,600010,"PSA-EQ"]
["YTD",543017.72,630211,"PSA-EQ"]
["YTD",672664.51,636010,"PSA-EQ"]
["YTD",28253.200000000001,636460,"PSA-EQ"]
["YTD",593266.54,639211,"PSA-EQ"]
["YTD",-4550624.84,689010,"PSA-EQ"]
["YTD",-84872.16,689460,"PSA-EQ"]
["YTD",-7555.46,700301,"PSA-EQ"]
["YTD",-80,710102,"PSA-EQ"]
["YTD",154290115.37,800000,"PSA-EQ"]
["YTD",-4531952.75,810000,"PSA-EQ"]
["YTD",-8776189.2200000007,830000,"PSA-EQ"]
["YTD",-140121.54999999999,939211,"PSA-EQ"]
["YTD",4531952.75,989010,"PSA-EQ"]
["YTD",-5482878.3600000003,100010,"SHF-EQ"]
["YTD",-8419000,100211,"SHF-EQ"]
["YTD",-564832.62,100460,"SHF-EQ"]
["YTD",257236.12,101010,"SHF-EQ"]
["YTD",-1542.26,139211,"SHF-EQ"]
["YTD",431429.48,189010,"SHF-EQ"]
["YTD",9012.6200000000008,189460,"SHF-EQ"]
["YTD",-2905,299460,"SHF-EQ"]
["YTD",-948.7,500000,"SHF-EQ"]
["YTD",-529088.87,600010,"SHF-EQ"]
["YTD",87495.5,630211,"SHF-EQ"]
["YTD",75576.039999999994,636010,"SHF-EQ"]
["YTD",2905,636460,"SHF-EQ"]
["YTD",1542.26,639211,"SHF-EQ"]
["YTD",-431429.48,689010,"SHF-EQ"]
["YTD",-9012.6200000000008,689460,"SHF-EQ"]
["YTD",-2747.23,700301,"SHF-EQ"]
["YTD",-5,710102,"SHF-EQ"]
["YTD",18337589.239999998,800000,"SHF-EQ"]
["YTD",-569343.88,810000,"SHF-EQ"]
["YTD",-3756657.24,830000,"SHF-EQ"]
["YTD",-1738.88,939211,"SHF-EQ"]
["YTD",569343.88,989010,"SHF-EQ"]
["YTD",-9821347.2899999991,100010,"STA-EQ"]
["YTD",-15054000,100211,"STA-EQ"]
["YTD",-1027486.04,100460,"STA-EQ"]
["YTD",163811.97,101010,"STA-EQ"]
["YTD",-2445.13,139211,"STA-EQ"]
["YTD",795509.09,189010,"STA-EQ"]
["YTD",15866.04,189460,"STA-EQ"]
["YTD",-5229,299460,"STA-EQ"]
["YTD",-52178.95,500000,"STA-EQ"]
["YTD",-1001069.14,600010,"STA-EQ"]
["YTD",165231.60999999999,630211,"STA-EQ"]
["YTD",105347.56,636010,"STA-EQ"]
["YTD",5229,636460,"STA-EQ"]
["YTD",2445.13,639211,"STA-EQ"]
["YTD",-795509.09,689010,"STA-EQ"]
["YTD",-15866.04,689460,"STA-EQ"]
["YTD",-3853.79,700301,"STA-EQ"]
["YTD",-5,710102,"STA-EQ"]
["YTD",28024876.219999999,800000,"STA-EQ"]
["YTD",-715206.6,810000,"STA-EQ"]
["YTD",-1493928.74,830000,"STA-EQ"]
["YTD",-5398.41,939211,"STA-EQ"]
["YTD",715206.6,989010,"STA-EQ"]