Input
Output
iVBORw0KGgoAAAANSUhEUgAAAXoAAAA0CAIAAAAL52RvAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAEnEAABJxAfPceo4AAAASdEVYdFNvZnR3YXJlAEdyZWVuc2hvdF5VCAUAAA0cSURBVHhe7Z3fjhXHEYf9Bs4bxG+A38B+A/sN7DdI3sBccYcSKXBhCQkuLPliibGEfcNeJGKvFiFhNgoKijFai+BVEPJCIrAlS+TbU72V2uo/02dn5uyedX1qjU7XVPd0D1O/qZ4zZ3nrTRAEwUoIuQmCYEWE3ARBsCJORm7+8uQ/Nx7tp0qwDjx58uTu3bu7u7upHgTLs2q5efzi5/e/+PatP31DSaZgHQi5CcazUrm59+zVbz79m2jNsnLz40+/nN/eQ6oQrGQKVkjITTCelcrNJ9s/qNYsJTdWp1iIJWuwQkJugvGsh9y8/emOtgq5ORFCboLxrIfc2FYhNydCyE0wnpCboIuQm2A8ITdBFyE3wXhCboIuQm6C8YTcBF2E3ATjGZCbH3/65Y/fPPt48/v3v/jWvjJDeffzh9jZe+/Zq+Q9xMnKDeM8v733+9v/Yi5s+fzloxdpXzBEyE0wngG5+eCr72yo18o71x4QwIMv4C0lN3+49290gYKu2VZoHEphy6AAXX3w3GmlFuz0gKom1xLs/euT/0pJpsXvMES5RLySdQG71L/ds6JNrHbzWftJpgp2hDO9BhlyE4xnQG4+2tx18dkohG5qVmEpubGe7fLen/+Z2mQQh06tigWfhi5YzUUE8URi1CIluS6wdk5gstZBDdX/t9f+nqxH3zb63e0nyZrh5thzxGMQchOMZ0BuuOty0RPPhBxiYQsWGw9S2okGraxzslawnu3SkJtzn/8jd5bi7ERsapNhnZl1nii5AVh5GpRgsIPkFCXrIr9TO6V2blEi67bW2c3+/j6HAD4kU5PXr1+LPyRTnU43RQbDIVJ9wbKd7O3tuU7EwjbVSxR9BluBjNmdPSzWKNUexH9Cxj4qdgoyodzkSlErNkQt7nBUbQrDZxeotX5ybXLFJRQ3Hu3bve3fvqMO1tmJhT0JrFjzFIwTrg6U2hTGM6vcEAk3b968fPnyBQPVzc1NF+0Cxq2trStXriTXQ7Ds7OwkpwzxuXXrVqo3efjwofi7KYuR0aZ6k9u3b4u/7eSzzz7DwjbVSxR9Fj1duH//fqqXkCOyTfUF0lCNUu1BTsLFixcbMscucb5z504y1RkrN+5yn1BulKUOobgwJlNIO45iFYd4Ttaj5HJDWofEMJJ7z16xzVWANZE6t1c3NoVxWRLQv+6luCUVx2XMuhdtSjtmYD65IX7kei3Ctc5Fn1wXcH1jTLsXEJbWgugUwyPtvnBhMEeAS5cuiXNRbmDwVKCJOqoJ5aYd/NPKDc6Dox10sJxZubE6Yh+IOIhYdaMUO3dyQ1TbB7pFXN6U65Fihenqg+fJanAnzY7QHWVwVGOYSW64JS4u7AOIBxtIHIskAvvGxkYyHdUa9lp/UiR6kL3FmJRWMBgbVgFrcjPYiUS+MKHcAHpaTPpADqrKIkgrZ1QYmzgU/3E5q7K3mFXpiWoooOXMyo19rlRLbQSrJowwWQ3WgW57otrlVkUdAZu80HNNlYpLKndaiiOfkDnkhmtULtbGHRu7DS1dQLmUR8FfFAfPZDoEo0pVYyKalUiC4zwXrVM/jXVNo5ORciPd1lZzk8sNSJ+sbZ3G6Rw716dwNuXm2KP64KvvktVg5SZf79SwGlHsFmx60lhzuenIksr2T4rUSKAmYQ65kaCCznuj3ktrkSNo/Dg5ECOxwZbgSdYMiS7cZHhuygddLAbAttGJ5GVs806KUuIo+mABPQlFsZOBufMj/rWTpqer8Y8roul6kGOhOE6GGpxNuXHf6SRrBTuqopocT27s19uUohzYFKw9L7du+vDrx7bac05GMrncaJZeu1HnSGrTc303wlXvycVwlb1yCOmkKDfaSTGGZWo48CHvpDg2R9EHC/BBtAxymRYJcKMS5+JQoUdu1IcZiUX/+WppZpGzKTdkCrZJslaYSW7QF21FyddT9gusxtMlgd7sUx5bJNmZm8nlRu/SndcrES7+PfKkj4RSfYFaGrdliWSJzFwp4KCLRScy/mN0UpQSR9EHC/CBI4ry5gscmZpTlkW7UXIDGxsb+Fy/fl2qPbPI6ZIbrvUvH704v73HTVXeo9XiXqI7JXJjBYLixuyK/XJnQrkBq3ocKFkPsXt7JMOdBykrWEYJk8uNBAZ0rqQ0KmphYymGkFjkc3F1IHdsdkkMS0S5KR90cbQT9+RCU5taJz2BWvTBAvJZH1Fp/AtyVt28Fu3Gyg3zkiPipk002elkQG4ev/j5483v3SXeKKdTbvrLtHLjXsCx79S43Me9blPDLakoK/sPLeaTm1QfQi/xWthY1NkOWCzyWXMTGzByA9dFVq4UcNDFYSd6FNuJtNKXUPJOilLiKPpggVSpPMmSs+pOUe5mKZ6rIpIzMioZXs8/hKMlN+T/tZ8a1coccuMegswqN8XntceWG7ArIPsFmZ3Uue73ZZzy9ryyPBXzyU3nHVKjoucqL4aQWFLlMKR1aSZNSFikCuLgpnzQRdaJphg9nYiFbaqXKPpggVRZII+9QfuXs+pOkfjUzpuMGdxMi+g3g5oDLkVVbrjfOq0hKtALCndUrnst1odqal/ieHLjWrUPIViBYNg61MGS2h9ljNzYwdvfSdg+88c6NZiLtpJC/2nfzMwnN519snwQ/x65kddhwWqZWFLFhJms5mq64Ia3aPH/TnRU4iZNND+CWrdsU71E0QcLpMoh7vH53HKjJ3apJ8RKVW7sD3/aL5uoG6UWscKJyM34FGCM3LgXcGTR5IydD1/cedAy69t9yuRyoxduj3wI8qwkf6EmR277NsuAxdGOhKusnohqWZi48JaYd1M+6OJoJ/JgGGeJ28FO9KCpXkJaOR8skCqHoKfySEVOy9xys5RzTlVu7AXdfk3Oep5CuaEk63EZIzdgm8uZtN/TN163sdgXAl1p/Lh0QiaXG5A4aby94pDAHrzWuc9Lz7pQEqRtqiwgVsUo/u6hda4UsHD3nehE2Dr/vBNRBJqkegkR1qJqpIpBhRuRXUu5IaTtBd2O8H7PlcmNazLyu5uRcmMf08jPsuyaqPNZr21CsuleLGK+yW825pAbiQ2oRYJD1YE7eePBgaqSXUmBGFPlEH384bQJOuUGdCIuH4G8E11/2TWXRUPayZ8YU+UoOgtZW6233CRrBeu5lNwcbxHRIzdu/P0PR4qMlBumaV/ns+oz+LqN4MRFUiQ7KsrcS6o55EbTEKj9nphAskKggU1cOTUBOrx+/bo45B2KPVUOkTFA3lu/3CzbiRjxz88nEoOdvblyHRy4IjcgfQrrLTftCO/3PIZwgAu2nnTAfc2cv/OyFCPlBtxrh1p6Xrdxz+x1ANitis29pJpDbkCjC1iMoBEcQuCzLE9cGGvyAojL1tYWqwm22LWrPFUB2ZUqBsQCUsXQLzewVCdMR4fKFHZ2dhYz3t3c3BQje11qA7IrVTI4uva5ZnLjnhQ0sgP31LOtIPbGTul8bOG0r7OVi/AxCc54uXFT0CJPjtvYo6Mvtkkx65mJmeQGiCtZAhQhXPPAYxkiTzdysNcWKeKQKh0sJTc1ip1AY9ZMIZ8yyN5UKaFasGZyA/bO+c61B3lgIEn5G4DcY+XvB5NQ5BGeP+/EU3omH5EXl/NFgVM0iv5dZLb9rXArLt8ahxbGyw3kP0E41/G6jROU/BmNHRtJkJyWOZhPbgQyFFISgpNbNPHGB5ZR7cPRhBDa2NjAmS2fsaR9JXCDVOmAAeDvIn+SThSUkZGL7jBrPte0EnoOzRnIO5GGtZ4ZmzjUBmlZyjmnKjf5C6woiPwHBh9+/di++F8rxW+gaz/80TL4m+xiKS4l3NpNCp4yEflBhp1IbT0yidzkgxlMuNAOu4wqypNT1ZHLxgZzy03wa6AqN9zzB6WBgk9DC/J8obas0FIUqTwtyktyPUrtoUmtFNOfSeQmz7aKx7K4E1tLvpyQzbSkCrkJxlOVG+D6zl9jtYUMiJghkOzKS4t70KBwVy/6S6n9aZgbj/YbrRoLkzxNa5TigCeRG7D9DD6Bcs+50JS0o4T9Z5ppSRVyE4ynJTcC1z0SoJkOMU/YcAu1N2c+Ez/qw9VPkDcuevzpgW7pSjqkEFG1G7hQbMWBBr+rYiQMr6FWjLwxYAYmbdkOroAaMHI94uCYmalMUOaYrBU4b+pMaZ/G4xFyE4xnWG7OEsQhcY58SCGkWdzNkQvkcBTVGmQrWdeHkJtgPL8uuTlB7JpuMFs5hYTcBOMJuVkFLAPtd0yryaemJeQmGE/IzSpg4aZa896Ih80nSMhNMJ6Qm9m59+yVTW3aL16fWkJugvGE3MwIa6jz23tWa9Y0tYGQm2A8ITcTg6AgK+8e/YvxUt6u/8d1p5+Qm2A8ITcT4yRGC1ozx+swKyPkJhhPyM3EOJWR8tHm7vrmNULITTCekJuJ0fee2X6y/cPVB8/X8WvvnJcvXz59+jT/81FB0E/ITRAEKyLkJgiCFRFyEwTBSnjz5n+Bsg0wC+hiuAAAAABJRU5ErkJggg==
Weekly Challenge #209
C:\Users\dsmda\AppData\Local\Temp\Engine_2000_ea62d176c4114b3ea798c0b3d8bf0b2b_\Engine_12788_0341c04d5615440fa16c0f2eb2b0fdaa_.yxdb
Single
Profile
24-04-2017
2017-04-01
10320
1849
1985974.59
1985974.59
0
0
0
24-04-2017
2017-05-01
10385
8324
8064636.49
8064636.49
0
0
0
24-04-2017
2017-06-01
10382
5859
5279349.51
5279349.51
0
0
0
24-04-2017
2017-07-01
10375
7496
7377419.28
7377419.28
0
0
0
24-04-2017
2017-08-01
10393
7262
7265501.55
7265501.55
0
0
0
24-04-2017
2017-09-01
10405
6407
6992772
6992772
0
0
0
24-04-2017
2017-10-01
10450
8344
7319265.22
7319265.22
0
0
0
24-04-2017
2017-11-01
10489
8713
7858932.5
7858932.5
0
0
0
24-04-2017
2017-12-01
10494
8640
7878868.83
7878868.83
0
0
0
24-04-2017
2018-01-01
10433
8686
8421750.49
8688719.98
0
0
0
24-04-2017
2018-02-01
10289
8334
7281329.36
7512147.5
0
0
0
24-04-2017
2018-03-01
10061
9052
7849509.59
8098339.05
0
0
0
24-04-2017
2018-04-01
9960
6903
6057094.47
6249104.36
0
0
0
24-04-2018
2018-04-01
9663
1293
1408698.12
1453353.85
0
0
0
24-04-2018
2018-05-01
9586
6092
5937072.15
6125277.33
0
0
0
24-04-2018
2018-06-01
9467
4485
4079795.07
4209124.58
0
0
0
24-04-2018
2018-07-01
9403
5341
5916140.24
6103681.89
0
0
0
24-04-2018
2018-08-01
9323
4946
4593841.41
4739466.18
0
0
0
24-04-2018
2018-09-01
9266
6038
5757437.57
5939948.34
0
0
0
24-04-2018
2018-10-01
9250
6445
6374160.02
6576220.9
0
0
0
24-04-2018
2018-11-01
9203
6180
4958654.43
5115843.78
0
0
0
24-04-2018
2018-12-01
9173
6705
6088946.97
6281966.59
0
0
0
24-04-2018
2019-01-01
9163
6913
6620825.7
6830705.87
0
0
0
24-04-2018
2019-02-01
9137
6535
5562491.74
5738822.73
0
0
0
24-04-2018
2019-03-01
9158
6869
5507350.9
5643894.98
0
0
0
24-04-2018
2019-04-01
9105
5484
4223102.68
4323390.35
0
0
0
24-04-2019
2019-04-01
8952
1391
1481993.93
1510717.28
0
0
0
24-04-2019
2019-05-01
8959
5465
5287881.47
5408356.66
0
0
0
24-04-2019
2019-06-01
8925
4548
3942014.75
4042258.21
0
0
0
24-04-2019
2019-07-01
8926
5525
5316636.58
5452801.74
0
0
0
24-04-2019
2019-08-01
8973
4230
3573086.99
3655762.26
0
0
0
24-04-2019
2019-09-01
9004
5748
5467749.6
5587539.1
0
0
0
24-04-2019
2019-10-01
8999
6383
6342485.89
6476909.48
0
0
0
Inception 24-04-2019 Claims Processed to 31/10/2019
Expiry 23-04-2020 Class VIP
Deductible 20 % OHN 100 OCN 100 MPN 75 Dental Limit 2,000.00 Optical Limit 400.00
Annual Limit 500,000.00 In- patient limit 500,000.00 Out patient Limit 500,000.00 Maternity Limit 500,000.00
Annual Claims No. of Lives No. of Paid Amt of Paid Claims Amt of Paid Claims No. of OS Amt of OS Claims Amt of OS Claims
Claims (before VAT) (after VAT) Claims (before VAT) (after VAT)
Period
Last Policy Year
1 04/2019 8,844 1,390 1,481,798.93 1,510,522.28 0 0.00 0.00
05/2019 8,849 5,451 5,277,674.00 5,398,082.71 0 0.00 0.00
06/2019 8,817 4,528 3,924,225.84 4,024,250.50 0 0.00 0.00
07/2019 8,821 5,509 5,294,859.51 5,430,547.20 0 0.00 0.00
08/2019 8,868 4,214 3,558,281.52 3,640,881.47 0 0.00 0.00
09/2019 8,900 5,734 5,458,328.10 5,578,056.16 0 0.00 0.00
10/2019 8,897 6,363 6,332,559.68 6,466,712.77 0 0.00 0.00
Inception 24-04-2019 Claims Processed to 31/10/2019
Expiry 23-04-2020 Class C
Deductible 20 % OHN 100 OCN 100 MPN 75 Dental Limit 2,000.00 Optical Limit 400.00
Annual Limit 500,000.00 In- patient limit 500,000.00 Out patient Limit 500,000.00 Maternity Limit 15,000.00
Annual Claims No. of Lives No. of Paid Amt of Paid Claims Amt of Paid Claims No. of OS Amt of OS Claims Amt of OS Claims
Claims (before VAT) (after VAT) Claims (before VAT) (after VAT)
Period
Last Policy Year
3 04/2019 108 1 195.00 195.00 0 0.00 0.00
05/2019 110 14 10,207.47 10,273.95 0 0.00 0.00
06/2019 108 20 17,788.91 18,007.71 0 0.00 0.00
07/2019 105 16 21,777.07 22,254.54 0 0.00 0.00
08/2019 105 16 14,805.47 14,880.79 0 0.00 0.00
09/2019 104 14 9,421.50 9,482.94 0 0.00 0.00
10/2019 102 20 9,926.21 10,196.71 0 0.00 0.00
Inception 24-04-2018 Claims Processed to 30/04/2019
Expiry 23-04-2019 Class VIP
Deductible 20 % OHN 100 OCN 100 MPN 75 Dental Limit 2,000.00 Optical Limit 400.00
Annual Limit 500,000.00 In- patient limit 500,000.00 Out patient Limit 500,000.00 Maternity Limit 500,000.00
Annual Claims No. of Lives No. of Paid Amt of Paid Claims Amt of Paid Claims No. of OS Amt of OS Claims Amt of OS Claims
Claims (before VAT) (after VAT) Claims (before VAT) (after VAT)
Period
Last Policy Year
1 04/2018 9,553 1,293 1,408,698.12 1,453,353.85 0 0.00 0.00
05/2018 9,476 6,085 5,935,579.58 6,123,737.45 0 0.00 0.00
06/2018 9,359 4,478 4,077,039.68 4,206,281.84 0 0.00 0.00
07/2018 9,293 5,332 5,912,087.23 6,099,500.40 0 0.00 0.00
08/2018 9,214 4,938 4,590,359.30 4,735,873.69 0 0.00 0.00
09/2018 9,157 6,030 5,752,388.11 5,934,738.81 0 0.00 0.00
10/2018 9,139 6,434 6,370,241.49 6,572,178.15 0 0.00 0.00
11/2018 9,093 6,161 4,944,852.33 5,101,604.15 0 0.00 0.00
12/2018 9,066 6,675 6,016,430.17 6,207,151.01 0 0.00 0.00
01/2019 9,058 6,874 6,569,605.81 6,777,862.31 0 0.00 0.00
02/2019 9,033 6,506 5,528,051.70 5,703,290.94 0 0.00 0.00
03/2019 9,045 6,852 5,498,071.03 5,634,522.80 0 0.00 0.00
04/2019 8,994 5,464 4,109,709.82 4,205,807.24 0 0.00 0.00
Inception 24-04-2018 Claims Processed to 30/04/2019
Expiry 23-04-2019 Class C
Deductible 20 % OHN 100 OCN 100 MPN 75 Dental Limit 2,000.00 Optical Limit 400.00
Annual Limit 500,000.00 In- patient limit 500,000.00 Out patient Limit 500,000.00 Maternity Limit 15,000.00
Annual Claims No. of Lives No. of Paid Amt of Paid Claims Amt of Paid Claims No. of OS Amt of OS Claims Amt of OS Claims
Claims (before VAT) (after VAT) Claims (before VAT) (after VAT)
Period
Last Policy Year
3 04/2018 110 0 0.00 0.00 0 0.00 0.00
05/2018 110 7 1,492.57 1,539.88 0 0.00 0.00
06/2018 108 7 2,755.39 2,842.74 0 0.00 0.00
07/2018 110 9 4,053.01 4,181.49 0 0.00 0.00
08/2018 109 8 3,482.11 3,592.49 0 0.00 0.00
09/2018 109 8 5,049.46 5,209.53 0 0.00 0.00
10/2018 111 11 3,918.53 4,042.75 0 0.00 0.00
11/2018 110 19 13,802.10 14,239.63 0 0.00 0.00
12/2018 107 30 72,516.80 74,815.58 0 0.00 0.00
01/2019 105 39 51,219.89 52,843.56 0 0.00 0.00
02/2019 104 29 34,440.04 35,531.79 0 0.00 0.00
03/2019 113 17 9,279.87 9,372.18 0 0.00 0.00
04/2019 111 20 113,392.86 117,583.11 0 0.00 0.00
Inception 24-04-2017 Claims Processed to 30/04/2018
Expiry 23-04-2018 Class VIP
Deductible 20 % OHN 20 OCN 20 MPN 20 Dental Limit 4,000.00 Optical Limit 400.00
Annual Limit 500000 In- patient limit 500,000.00 Out patient Limit 500,000.00 Maternity Limit 500,000.00
Annual Claims No. of Lives No. of Paid Amt of Paid Claims Amt of Paid Claims No. of OS Amt of OS Claims Amt of OS Claims
(before VAT) (after VAT)
Claims (before VAT) (after VAT) Claims
Period
Last Policy Year
1 04/2017 10,257 1,848 1,982,142.74 1,982,142.74 0 0.00 0.00
05/2017 10,244 8,318 8,061,843.40 8,061,843.40 0 0.00 0.00
06/2017 10,240 5,855 5,276,833.05 5,276,833.05 0 0.00 0.00
07/2017 10,239 7,496 7,377,419.28 7,377,419.28 0 0.00 0.00
08/2017 10,258 7,258 7,259,396.55 7,259,396.55 0 0.00 0.00
09/2017 10,270 6,405 6,989,788.39 6,989,788.39 0 0.00 0.00
10/2017 10,316 8,341 7,317,028.12 7,317,028.12 0 0.00 0.00
11/2017 10,357 8,712 7,858,684.62 7,858,684.62 0 0.00 0.00
12/2017 10,363 8,631 7,870,948.90 7,870,948.90 0 0.00 0.00
01/2018 10,305 8,686 8,421,750.49 8,688,719.98 0 0.00 0.00
02/2018 10,160 8,334 7,281,329.36 7,512,147.50 0 0.00 0.00
03/2018 9,951 9,049 7,845,148.44 8,093,839.65 0 0.00 0.00
04/2018 9,855 6,903 6,057,094.47 6,249,104.36 0 0.00 0.00
Inception 24-04-2017 Claims Processed to 30/04/2018
Expiry 23-04-2018 Class C
Deductible 20 % OHN 100 OCN 100 MPN 75 Dental Limit 2,000.00 Optical Limit 400.00
Annual Limit 500000 In- patient limit 500,000.00 Out patient Limit 500,000.00 Maternity Limit 15,000.00
Annual Claims No. of Lives No. of Paid Amt of Paid Claims Amt of Paid Claims No. of OS Amt of OS Claims Amt of OS Claims
(before VAT) (after VAT)
Claims (before VAT) (after VAT) Claims
Period
Last Policy Year
3 04/2017 63 1 3,831.85 3,831.85 0 0.00 0.00
05/2017 141 6 2,793.09 2,793.09 0 0.00 0.00
06/2017 142 4 2,516.46 2,516.46 0 0.00 0.00
07/2017 136 0 0.00 0.00 0 0.00 0.00
08/2017 135 4 6,105.00 6,105.00 0 0.00 0.00
09/2017 135 2 2,983.61 2,983.61 0 0.00 0.00
10/2017 134 3 2,237.10 2,237.10 0 0.00 0.00
11/2017 132 1 247.88 247.88 0 0.00 0.00
12/2017 131 9 7,919.93 7,919.93 0 0.00 0.00
01/2018 128 0 0.00 0.00 0 0.00 0.00
02/2018 129 0 0.00 0.00 0 0.00 0.00
03/2018 110 3 4,361.15 4,499.40 0 0.00 0.00
04/2018 105 0 0.00 0.00 0 0.00 0.00
C:\Users\dsmda\AppData\Local\Temp\Engine_2000_ea62d176c4114b3ea798c0b3d8bf0b2b_\Engine_12788_45b96e39c7d14a3997cc4b1d230eff14_.yxdb
Single
Profile
Field1
ParseComplex
Field1
Warn
Field1_Matched
Inception Date
Inception Date
Field1
Replace
Field1
Warn
Field1_Matched
Get Data
Get Data
Field1
Get Rows
Get Rows
Field1
ParseComplex
Field1
Warn
Field1_Matched
GetTable
GetTable
"RegExOut2"
True
True
True
True
False
False
False
False
False
upper
RegExOut2
Last
RegExOut2
Make Columns
Make Columns
Agg
Agg
RightInputMetadata
Warn
False
Proper names
Proper names
Remove
Prefix
Sum_
Warn
Remove prefix
Remove prefix
RegExOut21
MM/yyyy
DateTime_Out
Convert RegExOut21 From:
Custom
Sort to match
Inception - Ascending
Accident Month - Ascending
Headers
Headers
Horizontal
david_209