{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["MAIN","Share of Fund 2021"],"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":"MAIN","index":0,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Scheme Name","Trustee Name","Member yes/no","DOB","Sex","Share of fund","Remuneration","Employer Contribution","Retirement Date (Assumed)","Estimated Retirement Fund","Cash Lump Sum","Pension Income","Estimated Retirement Fund Inclusive of Employer Contributions A","Cash Lump sum A","Pension Income B"]
[]
["Universal Group","Simon J Best","Yes","1964-12-11","M",92001.89,50000.0,0.1,65.0,134875.24584693235,33718.81146173309,6020.984925571985,203951.1241368649,50987.78103421623,9104.610977874661]
["Universal Group","David J Coates","Yes","1959-03-20","M",167537.87,50000.0,0.1,65.0,203134.21977644583,50783.554944111456,9068.143434784513,232630.26218953176,58157.56554738294,10384.880435840825]
["Universal Group","Graham HN Gerred","Yes","1964-07-25","M",153180.55,50000.0,0.1,65.0,224563.47733963197,56140.86933490799,10024.769952452341,293639.35562956455,73409.83890739114,13108.39600475502]
["Universal Group","Michael G Holland","Yes","1950-01-31","M",568366.29,50000.0,0.1,70.0,590816.758455,147704.18961375,33199.880734671206,596014.2584550001,149003.56461375003,33491.94486055974]
["Universal Group","Philip J Holland","Yes","1958-01-01","M",237898.51,50000.0,0.1,65.0,277600.44073986006,69400.11018496501,12392.400536742762,300462.59195079753,75115.64798769938,13412.993062397332]
["Universal Group","Susan M Holland","Yes","1951-04-10","F",92704.09,50000.0,0.1,70.0,100162.13404050001,25040.533510125002,4723.297381650452,110891.8215405,27722.955385125,5229.272073185934]
["Universal Group","Kim Lombard","Yes","1983-02-08","F",59052.84,50000.0,0.1,65.0,172579.34267998528,43144.83566999632,6674.765740912645,534753.205283374,133688.3013208435,20682.384803651494]
["Universal Group","Melissa Holland","Yes","1980-10-19","F",60226.52,50000.0,0.1,65.0,158467.8862679116,39616.9715669779,6128.983932087764,454486.17170545296,113621.54292636324,17577.936510300064]
["Universal Group","Iain Craig","Yes","1976-09-14","M",39439.89,50000.0,0.1,65.0,89990.12959172626,22497.532397931565,4017.2621026171555,311255.4926766977,77813.87316917442,13894.800470167242]
["Universal Group","Roger Best","Yes","1966-10-10","M",254191.81,50000.0,0.1,65.0,401712.93361013354,100428.23340253338,17932.92388448258,489988.8314701993,122497.20786754982,21873.660725918904]

{"sheet":"Share of Fund 2021","index":1,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Scheme Name","Trustee Name","Member yes/no","DOB",null,null,"Sex","Share of fund 2020"]
[]
["Universal Group","Simon J Best","Yes","1964-12-11","2021-03-31",null,"M",92001.89]
["Universal Group","David J Coates","Yes","1959-03-20","2021-04-01",null,"M",167537.87]
["Universal Group","Graham HN Gerred","Yes","1964-07-25","2021-04-02",null,"M",153180.55]
["Universal Group","Michael G Holland","Yes","1950-01-31","2021-04-03",null,"M",568366.29]
["Universal Group","Philip J Holland","Yes","1958-01-01","2021-04-04",null,"M",237898.51]
["Universal Group","Susan M Holland","Yes","1951-04-10","2021-04-05",null,"F",92704.09]
["Universal Group","Kim Lombard","Yes","1983-02-08","2021-04-06",null,"F",59052.84]
["Universal Group","Melissa Holland","Yes","1980-10-19","2021-04-07",null,"F",60226.52]
["Universal Group","Iain Craig","Yes","1976-09-14","2021-04-08",null,"M",39439.89]
["Universal Group","Roger Best","Yes","1966-10-10","2021-04-09",null,"M",254191.81]