{ "success": true, "data": [ { "shareholderName": "Mille", "dividend": 4165211.243778872, "claim": -1012809.9400000001, "balance": 3152401.3037788705, "currencies": { "All": { "dividend": 4165211.243778872, "claim": -1012809.9400000001, "balance": 3152401.3037788705 }, "AUD": { "dividend": 4223738.731244952, "claim": -1012809.9400000001, "balance": 3210928.791244951 }, "NPR": { "dividend": -10306.0867, "claim": 0, "balance": -10306.0867 }, "PGK": { "dividend": -45226.23276608004, "claim": 0, "balance": -45226.23276608004 }, "MYR": { "dividend": -2995.168, "claim": 0, "balance": -2995.168 } } }, { "shareholderName": "Adrian Ang Zhen Han", "dividend": 650400.720803513, "claim": -169980.58000000002, "balance": 480420.14080351277, "currencies": { "All": { "dividend": 650400.720803513, "claim": -169980.58000000002, "balance": 480420.14080351277 }, "AUD": { "dividend": 648617.8854451127, "claim": -169980.58000000002, "balance": 478637.30544511264 }, "NPR": { "dividend": -1366.855, "claim": 0, "balance": -1366.855 }, "PGK": { "dividend": 3490.0503584000016, "claim": 0, "balance": 3490.0503584000016 }, "MYR": { "dividend": -340.36, "claim": 0, "balance": -340.36 } } }, { "shareholderName": "Lance", "dividend": 505678.12405999954, "claim": -361822.57, "balance": 143855.55405999953, "currencies": { "All": { "dividend": 505678.12405999954, "claim": -361822.57, "balance": 143855.55405999953 }, "AUD": { "dividend": 516403.9140599995, "claim": -361822.57, "balance": 154581.34405999954 }, "NPR": { "dividend": 0, "claim": 0, "balance": 0 }, "PGK": { "dividend": -7322.1900000000005, "claim": 0, "balance": -7322.1900000000005 }, "MYR": { "dividend": -3403.6, "claim": 0, "balance": -3403.6 } } }, { "shareholderName": "ERK", "dividend": 377614.08337303996, "claim": -276466.13, "balance": 101147.95337303996, "currencies": { "All": { "dividend": 377614.08337303996, "claim": -276466.13, "balance": 101147.95337303996 }, "AUD": { "dividend": 377614.08337303996, "claim": -276466.13, "balance": 101147.95337303996 }, "NPR": { "dividend": 0, "claim": 0, "balance": 0 }, "PGK": { "dividend": 0, "claim": 0, "balance": 0 }, "MYR": { "dividend": 0, "claim": 0, "balance": 0 } } }, { "shareholderName": "William", "dividend": 90127.29407634758, "claim": 0, "balance": 90127.29407634758, "currencies": { "All": { "dividend": 90127.29407634758, "claim": 0, "balance": 90127.29407634758 }, "AUD": { "dividend": 89689.24562466756, "claim": 0, "balance": 89689.24562466756 }, "NPR": { "dividend": -218.6968, "claim": 0, "balance": -218.6968 }, "PGK": { "dividend": 724.8172516800005, "claim": 0, "balance": 724.8172516800005 }, "MYR": { "dividend": -68.072, "claim": 0, "balance": -68.072 } } }, { "shareholderName": "Lau Tan Wei Ping", "dividend": 76251.19759595596, "claim": 0, "balance": 76251.19759595596, "currencies": { "All": { "dividend": 76251.19759595596, "claim": 0, "balance": 76251.19759595596 }, "AUD": { "dividend": 78572.28260595596, "claim": 0, "balance": 78572.28260595596 }, "NPR": { "dividend": 0, "claim": 0, "balance": 0 }, "PGK": { "dividend": -2321.085010000003, "claim": 0, "balance": -2321.085010000003 }, "MYR": { "dividend": 0, "claim": 0, "balance": 0 } } }, { "shareholderName": "Ahan(Ivan)", "dividend": 36415.67052000003, "claim": 0, "balance": 36415.67052000003, "currencies": { "All": { "dividend": 36415.67052000003, "claim": 0, "balance": 36415.67052000003 }, "AUD": { "dividend": -1635, "claim": 0, "balance": -1635 }, "NPR": { "dividend": 0, "claim": 0, "balance": 0 }, "PGK": { "dividend": 38050.67052000003, "claim": 0, "balance": 38050.67052000003 }, "MYR": { "dividend": 0, "claim": 0, "balance": 0 } } }, { "shareholderName": "Lee Chun Kit", "dividend": 31206.376931999974, "claim": 0, "balance": 31206.376931999974, "currencies": { "All": { "dividend": 31206.376931999974, "claim": 0, "balance": 31206.376931999974 }, "AUD": { "dividend": 28850.324791999978, "claim": 0, "balance": 28850.324791999978 }, "NPR": { "dividend": 0, "claim": 0, "balance": 0 }, "PGK": { "dividend": 2356.0521399999975, "claim": 0, "balance": 2356.0521399999975 }, "MYR": { "dividend": 0, "claim": 0, "balance": 0 } } }, { "shareholderName": "Law Wei Lun", "dividend": 26917.09169499997, "claim": 0, "balance": 26917.09169499997, "currencies": { "All": { "dividend": 26917.09169499997, "claim": 0, "balance": 26917.09169499997 }, "AUD": { "dividend": 26917.09169499997, "claim": 0, "balance": 26917.09169499997 }, "NPR": { "dividend": 0, "claim": 0, "balance": 0 }, "PGK": { "dividend": 0, "claim": 0, "balance": 0 }, "MYR": { "dividend": 0, "claim": 0, "balance": 0 } } }, { "shareholderName": "Tan Kian Quan", "dividend": 25290.02983599998, "claim": 0, "balance": 25290.02983599998, "currencies": { "All": { "dividend": 25290.02983599998, "claim": 0, "balance": 25290.02983599998 }, "AUD": { "dividend": 25290.02983599998, "claim": 0, "balance": 25290.02983599998 }, "NPR": { "dividend": 0, "claim": 0, "balance": 0 }, "PGK": { "dividend": 0, "claim": 0, "balance": 0 }, "MYR": { "dividend": 0, "claim": 0, "balance": 0 } } }, { "shareholderName": "Ang Kuan Zen", "dividend": 219038.27326262993, "claim": -202318.40000000002, "balance": 16719.873262629902, "currencies": { "All": { "dividend": 219038.27326262993, "claim": -202318.40000000002, "balance": 16719.873262629902 }, "AUD": { "dividend": 223617.9613726299, "claim": -202318.40000000002, "balance": 21299.56137262992 }, "NPR": { "dividend": -410.05649999999997, "claim": 0, "balance": -410.05649999999997 }, "PGK": { "dividend": -4169.631610000003, "claim": 0, "balance": -4169.631610000003 }, "MYR": { "dividend": 0, "claim": 0, "balance": 0 } } }, { "shareholderName": "Luee Chui Hui", "dividend": 15151.529430000028, "claim": 0, "balance": 15151.529430000028, "currencies": { "All": { "dividend": 15151.529430000028, "claim": 0, "balance": 15151.529430000028 }, "AUD": { "dividend": 15151.529430000028, "claim": 0, "balance": 15151.529430000028 }, "NPR": { "dividend": 0, "claim": 0, "balance": 0 }, "PGK": { "dividend": 0, "claim": 0, "balance": 0 }, "MYR": { "dividend": 0, "claim": 0, "balance": 0 } } }, { "shareholderName": "Ivan", "dividend": 14665.230840000006, "claim": 0, "balance": 14665.230840000006, "currencies": { "All": { "dividend": 14665.230840000006, "claim": 0, "balance": 14665.230840000006 }, "AUD": { "dividend": -545, "claim": 0, "balance": -545 }, "NPR": { "dividend": 0, "claim": 0, "balance": 0 }, "PGK": { "dividend": 15210.230840000006, "claim": 0, "balance": 15210.230840000006 }, "MYR": { "dividend": 0, "claim": 0, "balance": 0 } } }, { "shareholderName": "Teng Zhao Xuan", "dividend": 12770.225340000003, "claim": 0, "balance": 12770.225340000003, "currencies": { "All": { "dividend": 12770.225340000003, "claim": 0, "balance": 12770.225340000003 }, "AUD": { "dividend": -545, "claim": 0, "balance": -545 }, "NPR": { "dividend": 0, "claim": 0, "balance": 0 }, "PGK": { "dividend": 13315.225340000003, "claim": 0, "balance": 13315.225340000003 }, "MYR": { "dividend": 0, "claim": 0, "balance": 0 } } }, { "shareholderName": "Femi Yap Jin Bei", "dividend": 9774.348989999966, "claim": 0, "balance": 9774.348989999966, "currencies": { "All": { "dividend": 9774.348989999966, "claim": 0, "balance": 9774.348989999966 }, "AUD": { "dividend": 9774.348989999966, "claim": 0, "balance": 9774.348989999966 }, "NPR": { "dividend": 0, "claim": 0, "balance": 0 }, "PGK": { "dividend": 0, "claim": 0, "balance": 0 }, "MYR": { "dividend": 0, "claim": 0, "balance": 0 } } }, { "shareholderName": "Ang Chen Yang", "dividend": 5526.202924999981, "claim": 0, "balance": 5526.202924999981, "currencies": { "All": { "dividend": 5526.202924999981, "claim": 0, "balance": 5526.202924999981 }, "AUD": { "dividend": 5526.202924999981, "claim": 0, "balance": 5526.202924999981 }, "NPR": { "dividend": 0, "claim": 0, "balance": 0 }, "PGK": { "dividend": 0, "claim": 0, "balance": 0 }, "MYR": { "dividend": 0, "claim": 0, "balance": 0 } } }, { "shareholderName": "Chia Chun Wei", "dividend": 5526.202924999981, "claim": 0, "balance": 5526.202924999981, "currencies": { "All": { "dividend": 5526.202924999981, "claim": 0, "balance": 5526.202924999981 }, "AUD": { "dividend": 5526.202924999981, "claim": 0, "balance": 5526.202924999981 }, "NPR": { "dividend": 0, "claim": 0, "balance": 0 }, "PGK": { "dividend": 0, "claim": 0, "balance": 0 }, "MYR": { "dividend": 0, "claim": 0, "balance": 0 } } }, { "shareholderName": "Tan Yi Hong", "dividend": 1133.7465299999585, "claim": 0, "balance": 1133.7465299999585, "currencies": { "All": { "dividend": 1133.7465299999585, "claim": 0, "balance": 1133.7465299999585 }, "AUD": { "dividend": 1133.7465299999585, "claim": 0, "balance": 1133.7465299999585 }, "NPR": { "dividend": 0, "claim": 0, "balance": 0 }, "PGK": { "dividend": 0, "claim": 0, "balance": 0 }, "MYR": { "dividend": 0, "claim": 0, "balance": 0 } } }, { "shareholderName": "BD", "dividend": -2228.489283849974, "claim": 0, "balance": -2228.489283849974, "currencies": { "All": { "dividend": -2228.489283849974, "claim": 0, "balance": -2228.489283849974 }, "AUD": { "dividend": -2228.489283849974, "claim": 0, "balance": -2228.489283849974 }, "NPR": { "dividend": 0, "claim": 0, "balance": 0 }, "PGK": { "dividend": 0, "claim": 0, "balance": 0 }, "MYR": { "dividend": 0, "claim": 0, "balance": 0 } } }, { "shareholderName": "KY", "dividend": -2228.489283849974, "claim": 0, "balance": -2228.489283849974, "currencies": { "All": { "dividend": -2228.489283849974, "claim": 0, "balance": -2228.489283849974 }, "AUD": { "dividend": -2228.489283849974, "claim": 0, "balance": -2228.489283849974 }, "NPR": { "dividend": 0, "claim": 0, "balance": 0 }, "PGK": { "dividend": 0, "claim": 0, "balance": 0 }, "MYR": { "dividend": 0, "claim": 0, "balance": 0 } } }, { "shareholderName": "Kenny", "dividend": -3343.4345006399644, "claim": 0, "balance": -3343.4345006399644, "currencies": { "All": { "dividend": -3343.4345006399644, "claim": 0, "balance": -3343.4345006399644 }, "AUD": { "dividend": -3343.4345006399644, "claim": 0, "balance": -3343.4345006399644 }, "NPR": { "dividend": 0, "claim": 0, "balance": 0 }, "PGK": { "dividend": 0, "claim": 0, "balance": 0 }, "MYR": { "dividend": 0, "claim": 0, "balance": 0 } } }, { "shareholderName": "Ong Ming Jun", "dividend": -5466.833499999995, "claim": 0, "balance": -5466.833499999995, "currencies": { "All": { "dividend": -5466.833499999995, "claim": 0, "balance": -5466.833499999995 }, "AUD": { "dividend": -5466.833499999995, "claim": 0, "balance": -5466.833499999995 }, "NPR": { "dividend": 0, "claim": 0, "balance": 0 }, "PGK": { "dividend": 0, "claim": 0, "balance": 0 }, "MYR": { "dividend": 0, "claim": 0, "balance": 0 } } }, { "shareholderName": "Greg Yap Cha Shen", "dividend": -24358.249270000008, "claim": 0, "balance": -24358.249270000008, "currencies": { "All": { "dividend": -24358.249270000008, "claim": 0, "balance": -24358.249270000008 }, "AUD": { "dividend": -24358.249270000008, "claim": 0, "balance": -24358.249270000008 }, "NPR": { "dividend": 0, "claim": 0, "balance": 0 }, "PGK": { "dividend": 0, "claim": 0, "balance": 0 }, "MYR": { "dividend": 0, "claim": 0, "balance": 0 } } }, { "shareholderName": "LK", "dividend": -39423.54187480003, "claim": 0, "balance": -39423.54187480003, "currencies": { "All": { "dividend": -39423.54187480003, "claim": 0, "balance": -39423.54187480003 }, "AUD": { "dividend": -39423.54187480003, "claim": 0, "balance": -39423.54187480003 }, "NPR": { "dividend": 0, "claim": 0, "balance": 0 }, "PGK": { "dividend": 0, "claim": 0, "balance": 0 }, "MYR": { "dividend": 0, "claim": 0, "balance": 0 } } }, { "shareholderName": "Terrence", "dividend": -65068.365000000005, "claim": 0, "balance": -65068.365000000005, "currencies": { "All": { "dividend": -65068.365000000005, "claim": 0, "balance": -65068.365000000005 }, "AUD": { "dividend": -46762.89000000001, "claim": 0, "balance": -46762.89000000001 }, "NPR": { "dividend": 0, "claim": 0, "balance": 0 }, "PGK": { "dividend": -18305.475000000002, "claim": 0, "balance": -18305.475000000002 }, "MYR": { "dividend": 0, "claim": 0, "balance": 0 } } }, { "shareholderName": "CS", "dividend": 250306.91197000002, "claim": -326716.02, "balance": -76409.10802999999, "currencies": { "All": { "dividend": 250306.91197000002, "claim": -326716.02, "balance": -76409.10802999999 }, "AUD": { "dividend": 250306.91197000002, "claim": -326716.02, "balance": -76409.10802999999 }, "NPR": { "dividend": 0, "claim": 0, "balance": 0 }, "PGK": { "dividend": 0, "claim": 0, "balance": 0 }, "MYR": { "dividend": 0, "claim": 0, "balance": 0 } } }, { "shareholderName": "Win", "dividend": 2139179.178710097, "claim": -2339641.25, "balance": -200462.0712899025, "currencies": { "All": { "dividend": 2139179.178710097, "claim": -2339641.25, "balance": -200462.0712899025 }, "AUD": { "dividend": 2110037.3194740973, "claim": -2339641.25, "balance": -229603.93052590245 }, "NPR": { "dividend": -1366.855, "claim": 0, "balance": -1366.855 }, "PGK": { "dividend": 30508.714235999996, "claim": 0, "balance": 30508.714235999996 }, "MYR": { "dividend": 0, "claim": 0, "balance": 0 } } } ], "debug": true, "timings": { "init": 0.00095367431640625, "getShareholders": 2.192974090576172, "getWebsites": 1.6300678253173828, "prepareYearMonths": 8.748054504394531, "cashBookCache_prepare": 0.27489662170410156, "cashBookCache_execute": 3.130197525024414, "cashBookCache_fetch": 37.33682632446289, "loadCashBookCache": 42.51813888549805, "cashBookCache_count": 1348, "divOutCache_query": 264.64009284973145, "divOutCache_execute": 263.17691802978516, "divOutCache_fetch": 144.67906951904297, "loadDivOutCache": 409.32703018188477, "divOutCache_queryCount": 1, "identifyNeedsCalculation": 0.7939338684082031, "needsCalculationCount": 561, "neededWebsiteIdsCount": 83, "neededYearMonthsCount": 23, "loadMCInCache": 1268.6309814453125, "loadMCOutCache": 945.6050395965576, "loadExpensesOutCache": 448.6041069030762, "loadOpeningBalanceCache": 7.51495361328125, "loadSharePercentageCache": 43.13802719116211, "initializeCacheKeys": 5.374908447265625, "batchLoadAll": 2719.6760177612305, "calculateAllShareholders": 181.6420555114746, "calculationStats": { "savedData": 41788, "calculated": 17391, "mcInCalls": 0, "mcOutCalls": 0, "expensesOutCalls": 0, "openingBalanceCalls": 0, "sharePercentageCalls": 0 }, "calculationAvg": 0.005988993368485433, "calculationMin": 0, "calculationMax": 14.118194580078125, "sort": 0.03790855407714844, "total": 3366.8899536132812, "totalSeconds": 3.3668899536132812 }, "stats": { "shareholdersCount": 31, "websitesCount": 83, "yearMonthsCount": 23, "resultCount": 27, "cacheHitRate": 70.61288632792038, "totalCalculations": 59179, "cacheMissRate": 29.38711367207962 }, "performanceAnalysis": { "bottlenecks": [], "recommendations": [] }, "parameters": { "year": null, "queryAllYears": true }, "debugDetails": [], "divOutCacheSample": null }